From: Tom Arthurs <tarthurs@jobflash.com>
To: Brent Henry <bh_pgperf@yahoo.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: General DB Tuning
Date: Tue, 12 Jul 2005 14:54:31 -0700
Message-ID: <42D43C17.90005@jobflash.com> (raw)
In-Reply-To: <20050712062247.37243.qmail@web33902.mail.mud.yahoo.com>
References: <20050712062247.37243.qmail@web33902.mail.mud.yahoo.com>
I have this in my postgresql.conf file and it works fine (set the min to
whatever you want to log)
log_min_duration_statement = 3000 # -1 is disabled, in milliseconds.
Another setting that might get what you want:
#log_duration = false
uncomment and change to true.
From the docs:
(http://www.postgresql.org/docs/8.0/interactive/runtime-config.html)
Causes the duration of every completed statement which satisfies
log_statement to be logged. When using this option, if you are not using
syslog, it is recommended that you log the PID or session ID using
log_line_prefix so that you can link the statement to the duration using
the process ID or session ID. The default is off. Only superusers can
change this setting.
Brent Henry wrote:
> Help! After recently migrating to Postgres 8, I've
> discovered to my horror that I can't determine which
> queries are poorly performing anymore because the
> logging has drastically changed and no longer shows
> durations for anything done through JDBC.
>
> So I'm desperately trying to do performance tuning on
> my servers and have no way to sort out which
> statements are the slowest.
>
> Does anyone have any suggestions? How do you
> determine what queries are behaving badly when you
> can't get durations out of the logs?
>
> I have a perl script that analyzes the output from
> Postgres 7 logs and it works great! But it relies on
> the duration being there.
>
> I did some searches on postgresql.org mailing lists
> and have seen a few people discussing this problem,
> but noone seems to be too worried about it. Is there
> a simple work-around?
>
> Sincerely,
>
> Brent
>
>
>
> ____________________________________________________
> Sell on Yahoo! Auctions – no fees. Bid on great items.
> http://auctions.yahoo.com/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tarthurs@jobflash.com, bh_pgperf@yahoo.com
Subject: Re: General DB Tuning
In-Reply-To: <42D43C17.90005@jobflash.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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