Re: Date range for pg_stat_all_tables? - Mailing list pgsql-admin

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