Thread: log_min_duration_statement log parsing

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?

And may be someone have such script or other ideas how to log long-running statements in order to optimize them?

--
Vladimir Rusinov
Voronezh, Russia
UNIX Admin @ Murano Software

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.

Yes, according to description it is actually what we need.
Thanks a lot!

(Next time I should google before asking questions, sorry)

--
Vladimir Rusinov
Voronezh, Russia
UNIX Admin @ Murano Software