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

From Albe Laurenz
Subject Re: Date range for pg_stat_all_tables?
Date
Msg-id D960CB61B694CF459DCFB4B0128514C208B87B80@exadv11.host.magwien.gv.at
Whole thread Raw
In response to Re: Date range for pg_stat_all_tables?  (Ronit Allen <ronit.allen@gmail.com>)
Responses Re: Date range for pg_stat_all_tables?
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


pgsql-admin by date:

Previous
From: Dinesh Bhandary
Date:
Subject: openssl-1.0,0e for Solaris 10 64 bit
Next
From: Aaron Bono
Date:
Subject: Fwd: Postgre Eating Up Too Much RAM