Re: log_min_duration_statement log parsing

[Alexey Klyukin <alexk(at)commandprompt(dot)com>]

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.