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 [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]