Обсуждение: last insert/update for a table

Hi all;

is there a system catalog query or function that will show me the last time an
insert or update occurred for a specified table ?


Thanks in advance

Kevin Kempter <kevink@consistentstate.com> wrote:

> is there a system catalog query or function that will show me the
> last time  an insert or update occurred for a specified table ?

That would be rather expensive to maintain.  You could almost count
on looking at the timestamps on the underlying files, except that
various maintenance, like setting hint bits and vacuuming, would
cause changes there in addition to inserts and updates.

If this is some sort of audit because of suspected inappropriate
actions, be sure you capture a copy of the database ASAP.  You might
be able to figure something useful based on the xmin and xmax values
for tuples.  Without knowing exactly why you want this, it's hard to
offer specific advice.

-Kevin