How to tell what your postgresql server is doing

От: Jeff Frost
Тема: How to tell what your postgresql server is doing
Дата: ,
Msg-id: Pine.LNX.4.62.0504192141120.21883@discord.dyndns.org
(см: обсуждение, исходный текст)
Ответы: Re: How to tell what your postgresql server is doing  (Christopher Kings-Lynne)
Список: pgsql-performance

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


В списке pgsql-performance по дате сообщения:

От: Dawid Kuroczko
Дата:
Сообщение: Re: How to improve db performance with $7K?
От: Richard van den Berg
Дата:
Сообщение: When are index scans used over seq scans?