Add last-vacuum/analyze-time columns to the stats collector, both manual and
Alvaro Herrera <alvherre@alvh.no-ip.org>
Add last-vacuum/analyze-time columns to the stats collector, both manual and issued by autovacuum. Add accessor functions to them, and use those in the pg_stat_*_tables system views. Catalog version bumped due to changes in the pgstat views and the pgstat file. Patch from Larry Rosenman, minor improvements by me.
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/monitoring.sgml | modified | +36 −2 |
| src/backend/catalog/system_views.sql | modified | +5 −1 |
| src/backend/postmaster/pgstat.c | modified | +23 −1 |
| src/backend/utils/adt/pgstatfuncs.c | modified | +84 −1 |
| src/include/catalog/catversion.h | modified | +2 −2 |
| src/include/catalog/pg_proc.h | modified | +9 −1 |
| src/include/pgstat.h | modified | +9 −1 |
| src/test/regress/expected/rules.out | modified | +3 −3 |