measuring most-expensive queries

Поиск
Список
Период
Сортировка
От Enrico Weigelt
Тема measuring most-expensive queries
Дата
Msg-id 20050502031830.GC24546@nibiru.borg.metux.de
обсуждение исходный текст
Ответы Re: measuring most-expensive queries  (Gourish Singbal <gourish@gmail.com>)
Список pgsql-admin
Hi folks,


I'd like to find out which queries are most expensive (taking very
long or producing high load) in a running system, to see what
requires further optimization. (the application is quite large
and some more folks involved, so I cant check evrything manually).

Well, the postmaster can log ev'ry single statement, but its
really too for a human person, to read the log files.

Is there any tool for that ?


thx
--
---------------------------------------------------------------------
 Enrico Weigelt    ==   metux IT service
  phone:     +49 36207 519931         www:       http://www.metux.de/
  fax:       +49 36207 519932         email:     contact@metux.de
---------------------------------------------------------------------
  Realtime Forex/Stock Exchange trading powered by postgresSQL :))
                                            http://www.fxignal.net/
---------------------------------------------------------------------

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

Предыдущее
От: Enrico Weigelt
Дата:
Сообщение: Re: Suse 9.2 stops booting while starting the postgres-server
Следующее
От: Gourish Singbal
Дата:
Сообщение: Re: measuring most-expensive queries