Re: Finding slow queries?

Jessica Dalman <jessica_dalman(at)yahoo(dot)com> writes:
> I am trying to find which
> queries are the slowest from a web site which runs on
> top of postgres 7.4.1. I'm not sure what I need to
> do, though. I set the log_min_duration_statement to
> 10000, but I don't see anything new being logged to
> the pg.log.

Are you sure that you have any queries that take more than 10 seconds?
Maybe you need a smaller value of log_min_duration_statement.

Another thought: did you remember to SIGHUP the postmaster (or
equivalently "pg_ctl reload") after changing the config file?
It won't notice your change unless nudged. You can check whether
the change has taken effect by psql'ing in and doing a SHOW on
the variable.

regards, tom lane