Product Tour

Schema Statistics — Size and Growth per Table

Per-table size breakdown, growth trends, and TOAST / index ratios.

MonPG Schema Statistics page

Schema Statistics is a treemap plus a sortable table of every relation in your databases. The treemap is for "where is my storage going" at a glance; the table is for digging in.

Treemap view

Boxes sized by total relation size — heap plus TOAST plus indexes. Hover for the exact byte count. Click a box to drill into that table. People underestimate how often the answer to "why is the disk filling up" is one specific table that nobody noticed.

Per-table breakdown

ColumnMeaning
Heap sizeRaw table data. Grows with inserts.
TOAST sizeOut-of-line storage for rows over 8KB. Often JSONB or bytea. A high TOAST/heap ratio suggests JSONB columns can be compressed or moved out.
Index sizeAll indexes combined. When index size exceeds heap size, you have too many indexes — or one really big one.
RowsEstimated, from pg_class.reltuples. Updated after ANALYZE. For exact count, click through.
Growth (7d)Delta from 7 days ago. Negative means rows were pruned or the table was rewritten.

The "top 5 largest databases" card on the Dashboard links here for per-table drill-down. The same table can also be reached from Queries → table badges when a query hits a specific relation. Wherever you spot a fat table, you can land here in one click.