The age() of a column?

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.

Responses

Browse pgsql-general by date

  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