diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2006-11-24 21:18:42 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2006-11-24 21:18:42 +0000 |
| commit | 988a87a03a28146f9a106250e92aa73c43ed8f78 (patch) | |
| tree | 9bcb8b09ad61e839cde7636ab0c38ea7455678b5 /doc/src | |
| parent | 2822c7c0fce20db579c0ae7042529a418ff41d48 (diff) | |
Change pg_stat_all_tables and sister views to put the recently-added
vacuum/analyze timestamp columns at the end, rather than at a random
spot in the middle as in the original patch. This was deemed more usable
as well as less likely to break existing application code. initdb forced
accordingly. In passing, remove former kluge for initializing
pg_stat_file()'s pg_proc entry --- bootstrap mode was fixed recently
so that this can be done without any hacks, but I overlooked this usage.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/monitoring.sgml | 14 |
1 files changed, 8 insertions, 6 deletions
diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml index 58ef8b1f473..adffbec1870 100644 --- a/doc/src/sgml/monitoring.sgml +++ b/doc/src/sgml/monitoring.sgml @@ -1,4 +1,4 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/monitoring.sgml,v 1.38 2006/09/16 00:30:14 momjian Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/monitoring.sgml,v 1.39 2006/11/24 21:18:42 tgl Exp $ --> <chapter id="monitoring"> <title>Monitoring Database Activity</title> @@ -270,14 +270,16 @@ postgres: <replaceable>user</> <replaceable>database</> <replaceable>host</> <re <row> <entry><structname>pg_stat_all_tables</></entry> <entry>For each table in the current database (including TOAST tables), - the table OID, schema and table name, the last time the table was - vacuumed by the user and the autovacuum daemon, the last time the table - was analyzed by the user and the autovacuum daemon, number of sequential + the table OID, schema and table name, number of sequential scans initiated, number of live rows fetched by sequential scans, number of index scans initiated (over all indexes belonging to the table), number of live rows fetched by index - scans, - and numbers of row insertions, updates, and deletions.</entry> + scans, numbers of row insertions, updates, and deletions, + the last time the table was vacuumed manually, + the last time it was vacuumed by the autovacuum daemon, + the last time it was analyzed manually, + and the last time it was analyzed by the autovacuum daemon. + </entry> </row> <row> |