Technologies/PostgreSQL/postgresql.live_rows
PostgreSQLPostgreSQLMetric

postgresql.live_rows

Estimated live rows
Dimensions:None
Available on:DatadogDatadog (1)Native (1)PrometheusPrometheus (1)
Interface Metrics (3)
DatadogDatadog
Enabled with `relations`. The number of live rows on the toast table of a relation. This metric is tagged with db, schema, table.
Dimensions:None
Native
Estimated number of live rows
Dimensions:None
PrometheusPrometheus
Estimated number of live rows
Dimensions:None
Sources
postgresql.toast.live_rowsgithub.com
n_live_tupgithub.com
stat_user_tables_n_live_tupgithub.com

Technical Annotations (6)

CLI Commands (1)
SELECT reltuples::bigint AS estimate FROM pg_class WHERE relname = 'orders';diagnostic
Technical References (5)
pg_classcomponentMVCCconceptxmaxcomponentpg_stat_all_tables.n_dead_tupcomponentpgstattuplecomponent
Related Insights (2)
COUNT(*) on large tables without WHERE clause scans entire tablewarning
▸
MVCC dead rows consume disk space and degrade query performancewarning
▸