Re: Log Slow Queries

[Chris <dmagick@xxxxxxxxx>]

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/