Kevin Kempter <kevink@xxxxxxxxxxxxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
