storage: snapshot duration observability

[jbowens]

Expose per-usage timerseries on the duration LSM snapshots are held open.

Jira issue: CRDB-28931

[blathers-crl[bot]]

Hi @jbowens, please add a C-ategory label to your issue. Check out the label system docs.

_{:owl: Hoot! I am a Blathers, a bot for CockroachDB. My owner is dev-inf.}