Обсуждение: Log Slow Queries

Hi Guys,

Is there a feature in PostgreSQL like
"--log-slow-queries"(MySQL) ???

Regards,
Marcelo P.



_______________________________________________________
Abra sua conta no Yahoo! Mail: 1GB de espaço, alertas de e-mail no celular e anti-spam realmente eficaz.
http://br.info.mail.yahoo.com/

MaRCeLO PeReiRA wrote:
> Hi Guys,
>
> Is there a feature in PostgreSQL like
> "--log-slow-queries"(MySQL) ???

Unfortunately not.

What you can do is edit your postgresql.conf file and set:

log_min_duration_statement

See
http://www.postgresql.org/docs/8.1/interactive/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHEN
for more info.

This will go into the main log file, it won't create a separate log (as
slow-queries allows you to do in mysql).

--
Postgresql & php tutorials
http://www.designmagick.com/

On Tue, Apr 04, 2006 at 12:25:09PM +1000, Chris wrote:
> MaRCeLO PeReiRA wrote:
> >Hi Guys,
> >
> >Is there a feature in PostgreSQL like
> >"--log-slow-queries"(MySQL) ???
>
> Unfortunately not.
>
> What you can do is edit your postgresql.conf file and set:
>
> log_min_duration_statement

You can also set it per connection:

test=# set log_min_duration_statement =1;
SET

If you only want it some times but not others.
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.