Re: Query Feromance

Поиск
Список
Период
Сортировка
От Marco Furetto
Тема Re: Query Feromance
Дата
Msg-id 4421165E.4070800@bluestudio.it
обсуждение исходный текст
Ответ на Re: Query Feromance  (Thomas Pundt <mlists@rp-online.de>)
Список pgsql-performance
I find another java program for monitory application query:
http://www.p6spy.com/
with interface
http://www.jahia.net/jahia/page597.html

Thomas Pundt wrote:
> Hi,
>
> On Tuesday 21 March 2006 09:25, Marco Furetto wrote:
> | I'm managing the db of a "Content Management environment" and I'm
> | searching for a "Query analyzer" to improve performance because i don't
> | know how many and what type of queries are executing on the system (for
> | the "where and join" block).
>
> as a first step, I'd enable query duration logging; in postgresql.conf
> I have set
>
>   log_min_duration_statement = 3000
>
> this will log each query that needs more than 3 seconds to complete.
>
> The next step would be to "explain analyze" the problematic queries.
>
> Ciao,
> Thomas
>

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

Предыдущее
От: "Mikael Carneholm"
Дата:
Сообщение: Re: Migration study, step 1: bulk write performanceoptimization
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: Migration study, step 1: bulk write