Schema Inspector & Tables

Registry, sizing and index topology for production-analytics-v2. Search filters by relation name, comment or partition key.

Total Relations

3 primary · 15 partitions / matviews

On-Disk Footprint

586GB

+ 94 GB indexes · 21 GB TOAST

Rows Tracked

5.38B

n_live_tup estimates, refreshed 11 min ago

Index Methods

B-Tree HNSW Vector BRIN GIN

41 indexes · 0 invalid

Sort

Partitioned only

18 relations matched · Aggregate size 586 GB · Largest telemetry_timeseries / focus search · Esc clear

Table Registry

Click a row to inspect columns, indexes and storage layout

database production-analytics-v2

Relation	Rows	Size	Index	Seq scans	Index Methods

Sizes from pg_total_relation_size(), rows from pg_stat_user_tables

telemetry_timeseries

partitioned table

Heap

281 GB

Indexes

29.6 GB

TOAST

1.4 GB

Autovacuum on · last vacuum 2026-05-30 03:41 UTC

9 fields

4 objects

Export this relation

Distribution of 41 index objects across the scoped database

0 invalid · 0 bloat > 30%

Tablespace pg_default · NVMe RAID-10