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 <jeff(at)frostconsultingllc(dot)com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954