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@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073