Re: Identifying time of last stat reset via sql

This relates to an earlier request from someone to allow reporting of
the server start time. It seems both stats start/reset time and server
start time are related.

Is this something for the TODO list? I can't remember why we didn't
want to report server start time, at least for super-users.

---------------------------------------------------------------------------

Ed Loehr wrote:
>
> I asked this on general, but didn't receive any responses. Is it possible
> via SQL to identify the time of the last stat reset (or pg_stat_reset()
> call)? This is what I'm lacking to be able to measure query activity
> volume over time via SQL, i.e., maybe a function similar to the fictitious
> pg_stat_get_last_reset_time() below:
>
> select sum(n_tup_ins + n_tup_upd + n_tup_del)
> / (now() - pg_stat_get_last_reset_time()) as write_qps
> from pg_stat_all_tables
>
> If not, would this be considered worthy of a TODO item? Or is there another
> approached designed for determining QPS, etc?
>
> Ed
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073