Re: Last insert/update/delete time for a table

From: "Fujii Masao" <masao(dot)fujii(at)gmail(dot)com>
To:
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Last insert/update/delete time for a table
Date: 2008-04-25 14:25:29
Message-ID: 3f0b79eb0804250725w3349903iedbe11f0e2cd3fe5@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2008/4/25 Aleksander Kmetec - INTERA <aleksander(dot)kmetec(at)intera(dot)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';

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ben Chobot 2008-04-25 15:19:34 Re: How to modify ENUM datatypes?
Previous Message Richard Huxton 2008-04-25 13:26:26 Re: Last insert/update/delete time for a table