Re: [GENERAL] How to know which queries are to be optimised?

Поиск
Список
Период
Сортировка
От Rudi Starcevic
Тема Re: [GENERAL] How to know which queries are to be optimised?
Дата
Msg-id 411BF429.1090106@wildcash.com
обсуждение исходный текст
Ответ на Re: [GENERAL] How to know which queries are to be optimised?  (Richard Huxton <dev@archonet.com>)
Список pgsql-performance
Hi,

>> But is there a tool that could compile a summary out of the log? The
>> log grows awefully big after a short time.

There's also pg_analyzer to check out.

http://www.samse.fr/GPL/pg_analyzer/

Some of it's features are: written in Perl and produces HTML output.

> You might want to look at the "Practical Query Analyser" - haven't used
> it myself yet, but it seems a sensible idea.
>
> http://pqa.projects.postgresql.org/


Cheers,
Rudi.

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

Предыдущее
От: William Yu
Дата:
Сообщение: Re: Help specifying new machine
Следующее
От: Ulrich Wisser
Дата:
Сообщение: insert