Re: Date range for pg_stat_all_tables?

Hi -

Thank you Laurnez.

Ronit

On Fri, Nov 16, 2012 at 11:56 AM, Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)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
>