Hi - Thank you Laurnez.
Ronit On Fri, Nov 16, 2012 at 11:56 AM, Albe Laurenz <laurenz.a...@wien.gv.at>wrote: > Ronit Allen wrote: > > 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?.. > > 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). > > I don't see it documented there, except maybe by omission. > > Yours, > Laurenz Albe >