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