Hi -
Thank you Laurnez.
Ronit
Thank you Laurnez.
Ronit
On Fri, Nov 16, 2012 at 11:56 AM, Albe Laurenz <laurenz.albe@xxxxxxxxxx> wrote:
Ronit Allen wrote:All time.
> 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 it documented there, except maybe by omission.
> 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).
Yours,
Laurenz Albe
