Re: Log Slow Queries

From: Chris <dmagick(at)gmail(dot)com>
To: MaRCeLO PeReiRA <gandalf_mp(at)yahoo(dot)com(dot)br>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Log Slow Queries
Date: 2006-04-04 02:25:09
Message-ID: 4431D905.8040008@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Browne 2006-04-04 03:23:01 Re: FAQ 1.1
Previous Message Juan Carlos 2006-04-04 02:15:38 Duda, version para Solaris 10