diff options
| author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2006-05-19 19:08:27 +0000 |
|---|---|---|
| committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2006-05-19 19:08:27 +0000 |
| commit | 1f219cf433e792d61040246c24b136b0e6a2c930 (patch) | |
| tree | 4489a0e0cb6947bc2ece721f220b68f80e64a0f6 /src/backend/catalog | |
| parent | 09518fbdf445554f54e4c3cffc964fe2d073b550 (diff) | |
| download | postgresql-1f219cf433e792d61040246c24b136b0e6a2c930.tar.gz | |
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.
Diffstat (limited to 'src/backend/catalog')
| -rw-r--r-- | src/backend/catalog/system_views.sql | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/src/backend/catalog/system_views.sql b/src/backend/catalog/system_views.sql index 907a254949..eba31082bc 100644 --- a/src/backend/catalog/system_views.sql +++ b/src/backend/catalog/system_views.sql @@ -3,7 +3,7 @@ * * Copyright (c) 1996-2006, PostgreSQL Global Development Group * - * $PostgreSQL: pgsql/src/backend/catalog/system_views.sql,v 1.26 2006/03/05 15:58:23 momjian Exp $ + * $PostgreSQL: pgsql/src/backend/catalog/system_views.sql,v 1.27 2006/05/19 19:08:26 alvherre Exp $ */ CREATE VIEW pg_roles AS @@ -193,6 +193,10 @@ CREATE VIEW pg_stat_all_tables AS C.oid AS relid, N.nspname AS schemaname, C.relname AS relname, + pg_stat_get_last_vacuum_time(C.oid) as last_vacuum, + pg_stat_get_last_autovacuum_time(C.oid) as last_autovacuum, + pg_stat_get_last_analyze_time(C.oid) as last_analyze, + pg_stat_get_last_autoanalyze_time(C.oid) as last_autoanalyze, pg_stat_get_numscans(C.oid) AS seq_scan, pg_stat_get_tuples_returned(C.oid) AS seq_tup_read, sum(pg_stat_get_numscans(I.indexrelid))::bigint AS idx_scan, |