measuring most-expensive queries

Поиск
Список
Период
Сортировка
Искать

measuring most-expensive queries

От:
Enrico Weigelt <weigelt@metux.de>
Дата:

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/
---------------------------------------------------------------------

Re: measuring most-expensive queries

От:
Gourish Singbal <gourish@gmail.com>
Дата:
You could have made the following change in your conf file and reload
the postgresql server.

log_min_duration_statement = 10000

This will help you log the queries that take more than 10000 mili
seconds to execute in your postgresql sever log file

regards
Gourish Singbal


On 5/2/05, Enrico Weigelt  wrote:
> 
> 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/
> ---------------------------------------------------------------------
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> 


-- 
Best,
Gourish Singbal

Re: measuring most-expensive queries

От:
"Holger Hoffstaette" <holger@wizards.de>
Дата:
On Mon, 02 May 2005 05:18:30 +0200, Enrico Weigelt wrote:

> 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).

http://pqa.projects.postgresql.org/

-h

FAQ