Re: How to tell what your postgresql server is doing

> Is there a way to look at the stats tables and tell what is jamming up
> your postgres server the most? Other than seeing long running queries
> and watch top, atop, iostat, vmstat in separate xterms...I'm wondering
> if postgres keeps some stats on what it spends the most time doing or if
> there's a way to extract that sort of info from other metrics it keeps
> in the stats table?
>
> Maybe a script which polls the stats table and correlates the info with
> stats about the system in /proc?

Turn on logging of all queries, sample for a few hours or one day. Then
run Practical Query Analyzer (PQA on pgfoundry.org) over it to get
aggregate query information.

Chris