Hi - Thanks for below.
On 9.1 with postgresql.conf left at defaults, what period of time does a query on pg_stat_all_tables cover? Let's say my database has been running for exactly one year. I then issue SELECT relname, n_tup_ins FROM pg_stat_all_tables; Do the results show me inserts for the last 7 days? 30 days? all time?.. I don't see the answer to this in http://www.postgresql.org/docs/9.1/static/monitoring-stats.html (or maybe it is there and I am not understanding). Thanks once again, Ronit On Tue, Nov 13, 2012 at 10:54 AM, Albe Laurenz <laurenz.a...@wien.gv.at>wrote: > 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 >
