Ronit Allen wrote: > I have the following query on pg_stat_all_tables to look at updates, inserts, and deletes: > > SELECT relname, n_tup_ins, n_tup_upd, n_tup_del FROM pg_stat_all_tables; > > How can I add a date range to the WHERE clause to show data from a specified date range? > > I don't see anything in the table or in possible joins that will provide dates. > > Thanks for any assistance that can be provided.
If you want that, you will have to take regular snapshots of the table (e.g. with a cron job). Then you can calculate differences. Yours, Laurenz Albe -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
