pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedmeasuring most-expensive queries
3+ messages / 3 participants
[nested] [flat]
* measuring most-expensive queries
@ 2005-05-02 03:18 Enrico Weigelt <weigelt@metux.de>
2005-05-02 05:11 ` Re: measuring most-expensive queries Gourish Singbal <gourish@gmail.com>
2005-05-02 11:36 ` Re: measuring most-expensive queries Holger Hoffstaette <holger@wizards.de>
0 siblings, 2 replies; 3+ messages in thread
From: Enrico Weigelt @ 2005-05-02 03:18 UTC (permalink / raw)
To: 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/
---------------------------------------------------------------------
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: measuring most-expensive queries
2005-05-02 03:18 measuring most-expensive queries Enrico Weigelt <weigelt@metux.de>
@ 2005-05-02 05:11 ` Gourish Singbal <gourish@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Gourish Singbal @ 2005-05-02 05:11 UTC (permalink / raw)
To: pgsql-admin
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 <weigelt@metux.de> 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: measuring most-expensive queries
2005-05-02 03:18 measuring most-expensive queries Enrico Weigelt <weigelt@metux.de>
@ 2005-05-02 11:36 ` Holger Hoffstaette <holger@wizards.de>
1 sibling, 0 replies; 3+ messages in thread
From: Holger Hoffstaette @ 2005-05-02 11:36 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2005-05-02 11:36 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-05-02 03:18 measuring most-expensive queries Enrico Weigelt <weigelt@metux.de>
2005-05-02 05:11 ` Gourish Singbal <gourish@gmail.com>
2005-05-02 11:36 ` Holger Hoffstaette <holger@wizards.de>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox