Kevin Kempter <kevink(at)consistentstate(dot)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.
In response to
pgsql-admin by date
|Next:||From: Kevin Kempter||Date: 2010-01-22 05:14:39|
|Subject: query to list all user tables and related constraints|
|Previous:||From: Uwe Bartels||Date: 2010-01-21 07:52:25|
|Subject: vacuum + autovacuum|