Skip to main content

Storage overview

The Storage tab gives an at-a-glance view of storage usage across the connected instance.

What it shows

  • Database size — current size of the connected database
  • Cluster size — total size across all databases on the instance
  • Top tables — largest tables by total relation size (table + indexes)
  • Top indexes — largest indexes independent of bloat status
  • Table count and index count — catalog summary

How it works

Storage metrics come from pg_database_size(current_database()) and pg_total_relation_size(). These are cached views — repeated page loads use the short TTL cache, and a "Refresh" button fetches fresh values.

Connection to monitoring

Large tables feed into:

  • Vacuum & Bloat — dead tuple ratios and vacuum threshold analysis
  • Index Advisor — index size context for bloat estimates
  • Performance — disk growth trend over time