[PERFORM] How to tell what your postgresql server is doing

[Jeff Frost]

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?

--
Jeff Frost, Owner       <[EMAIL PROTECTED]>
Frost Consulting, LLC   http://www.frostconsultingllc.com/
Phone: 650-780-7908     FAX: 650-649-1954

Advertising







---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]