From: | Alexey Klyukin <alexk(at)commandprompt(dot)com> |
---|---|
To: | Vladimir Rusinov <vladimir(at)greenmice(dot)info> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: log_min_duration_statement log parsing |
Date: | 2008-03-31 12:19:34 |
Message-ID: | 20080331121934.GA7007@vollmond |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Vladimir Rusinov wrote:
> Hello!
>
> I need a daily list of log-running statements. I've turned on
> log_min_duraion_statement and going to write script which would daily parse
> postgresql log and mail it to me, but I have no long-running statements (and
> don't wanna do specially) and I can't see any in my log file. How does they
> look?
Just set log_min_duration to 0, according to the manual it would print
all statement duration so you can see how it looks on your system.
>
> And may be someone have such script or other ideas how to log long-running
> statements in order to optimize them?
I suggest you to take a look at pgFouine:
http://pgfouine.projects.postgresql.org/
--
Alexey Klyukin http://www.commandprompt.com/
The PostgreSQL Company - Command Prompt, Inc.
From | Date | Subject | |
---|---|---|---|
Next Message | Julius Tuskenis | 2008-03-31 12:24:09 | Re: what is the origin of postgreSQL time |
Previous Message | Tommy Gildseth | 2008-03-31 12:17:31 | Re: what is the origin of postgreSQL time |