feat(db): Add Postgres table size metrics

[slowli]

What ❔

Exports Postgres table sizes as gauge metrics.

Why ❔

Useful to monitor state growth, especially once we have state pruning, and/or have access to metrics from the partners' nodes.

Checklist

• [x] PR title corresponds to the body of PR (we generate changelog entries from PRs).
• [x] Documentation comments have been added / updated.
• [x] Code has been formatted via zk fmt and zk lint.
• [x] Spellcheck has been run via zk spellcheck.
• [x] Linkcheck has been run via zk linkcheck.