diff options
| author | Andrew Dunstan <andrew@dunslane.net> | 2013-09-02 14:37:53 -0400 |
|---|---|---|
| committer | Andrew Dunstan <andrew@dunslane.net> | 2013-09-02 14:37:53 -0400 |
| commit | 4e1e5d3bad9d51e5695c8a42612343662e886a64 (patch) | |
| tree | 5ec7597c7e852f8e1832d5c216ad9368cf046895 | |
| parent | c7ef895f697627f60c51f44d8a9d64431840b4da (diff) | |
| download | postgresql-4e1e5d3bad9d51e5695c8a42612343662e886a64.tar.gz postgresql-4e1e5d3bad9d51e5695c8a42612343662e886a64.zip | |
Fix relfrozenxid query in docs to include TOAST tables.
The original query ignored TOAST tables which could result in tables
needing a vacuum not being reported.
Backpatch to all live branches.
| -rw-r--r-- | doc/src/sgml/maintenance.sgml | 7 |
1 files changed, 6 insertions, 1 deletions
diff --git a/doc/src/sgml/maintenance.sgml b/doc/src/sgml/maintenance.sgml index ab5984f4bc5..616e41d52d2 100644 --- a/doc/src/sgml/maintenance.sgml +++ b/doc/src/sgml/maintenance.sgml @@ -534,7 +534,12 @@ examine this information is to execute queries such as: <programlisting> -SELECT relname, age(relfrozenxid) FROM pg_class WHERE relkind IN ('r', 'm'); +SELECT c.oid::regclass as table_name, + greatest(age(c.relfrozenxid),age(t.relfrozenxid)) as age +FROM pg_class c +LEFT JOIN pg_class t ON c.reltoastrelid = t.oid +WHERE c.relkind IN ('r', 'm'); + SELECT datname, age(datfrozenxid) FROM pg_database; </programlisting> |