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 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
