Re: [HACKERS] Identifying time of last stat reset via sql

2004-12-18 Thread Bruce Momjian
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. -

[HACKERS] Identifying time of last stat reset via sql

2004-12-17 Thread Ed Loehr
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

[HACKERS] Identifying time of last stat reset via sql

2004-12-15 Thread Ed L.
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. Maybe a function similar to the fictitious pg_stat