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
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
