Add n_live_tuples and n_dead_tuples to pg_stat_all_tables.
Bruce Momjian <bruce@momjian.us>
Add n_live_tuples and n_dead_tuples to pg_stat_all_tables. The purpose is to allow autovacuum-esq conditional vacuuming and clustering using SQL to discover the required stats. No documentation updates required. Catalog version updated. Glen Parker
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/catalog/system_views.sql | modified | +4 −2 |
| src/backend/utils/adt/pgstatfuncs.c | modified | +35 −1 |
| src/include/catalog/catversion.h | modified | +2 −2 |
| src/include/catalog/pg_proc.h | modified | +5 −1 |
| src/test/regress/expected/rules.out | modified | +3 −3 |