diff options
| author | Andrew Dunstan | 2013-09-02 18:41:02 +0000 |
|---|---|---|
| committer | Andrew Dunstan | 2013-09-02 18:41:02 +0000 |
| commit | 9346ed0be1ac9b326d6eeb78ec19efa2ed95a88d (patch) | |
| tree | 6808d8f5f3300362a2054c3e60dfdcce485278dd /doc/src | |
| parent | 70ebdd084484d5dbea04a04d425334600818f2fe (diff) | |
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.
Diffstat (limited to 'doc/src')
| -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 c866322014e..385ee20d0cf 100644 --- a/doc/src/sgml/maintenance.sgml +++ b/doc/src/sgml/maintenance.sgml @@ -489,7 +489,12 @@ examine this information is to execute queries such as: <programlisting> -SELECT relname, age(relfrozenxid) FROM pg_class WHERE relkind = 'r'; +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 = 'r'; + SELECT datname, age(datfrozenxid) FROM pg_database; </programlisting> |