Re: Interpreting query debug output

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Interpreting query debug output
Дата
Msg-id 10080.1084928803@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Interpreting query debug output  (Steve Lane <slane@moyergroup.com>)
Ответы Re: Interpreting query debug output  (Steve Lane <slane@moyergroup.com>)
Список pgsql-admin
Steve Lane <slane@moyergroup.com> writes:
> I have a database that is exhibiting sluggishness under load. Suspecting
> that some queries may be poorly optimized, I turned on a fair amount of
> debugging output in the logs. But I could use some help interpreting it.

I think you're going at this all wrong.  EXPLAIN ANALYZE should be the
first tool you turn to, not low-level stats.  Browsing the archives of
the pgsql-performance mailing list may help you get started.

            regards, tom lane

В списке pgsql-admin по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: "IDENT authentication failed" but I'm not using ident
Следующее
От: mike g
Дата:
Сообщение: Re: Set Timestamp