Re: The age() of a column?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ron <ronljohnsonjr(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: The age() of a column?
Date: 2018-11-29 04:05:44
Message-ID: 406.1543464344@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ron <ronljohnsonjr(at)gmail(dot)com> writes:
> What does it mean, and where is it documented?

age(xid) returns the difference between the given xid and the current xid.
It's not terribly well documented, but psql's \df gives some info:

regression=# \df+ age
Schema | Name | Result data type | Argument data types | Type | Volatility | Parallel | Owner | Security | Access privileges | Language | Source code | Description
...
pg_catalog | age | integer | xid | func | stable | restricted | postgres | invoker | | internal | xid_age | age of a transaction ID, in transactions before current transaction

The only reference I could find in the SGML docs is in the maintenance
chapter.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Where is Where 2018-11-29 04:11:33 Re: tsvector 256 limit and matching text with common words
Previous Message Ron 2018-11-29 03:32:48 The age() of a column?