Re: Last insert/update/delete time for a table - Mailing list pgsql-general

2008/4/25 Aleksander Kmetec - INTERA <aleksander.kmetec@intera.si>:
>  Is there a way to get the time of the last insert, update or delete
> statement for a specific table?

You can check the time stamp of the file corresponding the table
after checkpoint. The relationship between the table name and
the file name is in pg_class.

   SELECT relfilenode FROM pg_class WHERE relname = 'tablename';