From: | Ron <ronljohnsonjr(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | The age() of a column? |
Date: | 2018-11-29 03:32:48 |
Message-ID: | 5e967a88-1054-5559-0712-44ef00b6b7c1@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
What does it mean, and where is it documented? The only place in the docs I
see reference to age() is
https://www.postgresql.org/docs/9.6/functions-datetime.html and this doesn't
seem to fit that use case.
Thanks
TAPb=# select COALESCE(ta.schemaname, 'pg_toast') || '.' || cl.relname,
cl.relfrozenxid,
age(cl.relfrozenxid)
from pg_class cl FULL JOIN pg_tables ta
ON ta.tablename = cl.relname
where not cl.relfrozenxid = xid '0'
--and age(cl.relfrozenxid) > 4000000
order by 1
limit 30;
?column? | relfrozenxid | age
-------------------------------+--------------+---------
cds.ach_return_batch | 58569152 | 2111005
cds.ach_return_detail | 58569152 | 2111005
cds.all_day_event | 58569152 | 2111005
cds.all_day_event_trigger | 58569152 | 2111005
[snip]
cds.bank_ftp | 58569152 | 2111005
cds.bank_health_care_job | 58569152 | 2111005
cds.bank_inbound_file | 58569152 | 2111005
cds.bank_input_format | 58569152 | 2111005
(30 rows)
--
Angular momentum makes the world go 'round.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2018-11-29 04:05:44 | Re: The age() of a column? |
Previous Message | Stephen Frost | 2018-11-28 22:49:50 | Re: surprising query optimisation |