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

Aleksander Kmetec - INTERA wrote:
> Hi all,
>
> I'm in the process of writing a backup script which only dumps those
> tables which were changed in the last 24 hours. We have hundreds of
> tables (one per user), but most of them don't get changed very often, so
> there's no point in dumping them every night.
>
> Is there a way to get the time of the last insert, update or delete
> statement for a specific table?

You can always look at pg_stat_user_tables on a regular basis (see ch 26
of the docs). Note that there is a small chance not all updates will be
recorded here.

--
Richard Huxton
Archonet Ltd