diff options
| author | Andrew Dunstan | 2013-09-02 18:36:24 +0000 |
|---|---|---|
| committer | Andrew Dunstan | 2013-09-02 18:36:24 +0000 |
| commit | 7d0492f33737f29ff2b4267020bde726104a754f (patch) | |
| tree | 7b3883072903710de4c9626cc044db823c520259 | |
| parent | e912963a22ba5c1bd909d6ee53f41b8ae6c69166 (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.
| -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 84b452d16d4..e9b8f97ae53 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 = '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> |