On 7/7/06, ogjunk-pgjedan(at)yahoo(dot)com <ogjunk-pgjedan(at)yahoo(dot)com> wrote:
>
> Interesting, Hubert.
> Where/how do you get the data for:
> - number of transactions per second
periodically (every 5 minutes) i do:
select sum(xact_commit) + sum(xact_rollback) from pg_stat_database
and then just check against previous value, and calculate "per/second". this
is actually handled nicely by mrtg itself.
- duration of longest query
>
select * from pg_stat_activity where current_query !~ '<IDLE>' order by
query_start asc limit 1;
this has some problems though, but are more or less easily avoidable.
depesz
--
http://www.depesz.com/ - nowy, lepszy depesz