Skip site navigation (1) Skip section navigation (2)

Re: log_min_duration_statement log parsing

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 (view raw or flat)
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.

In response to

Responses

pgsql-admin by date

Next:From: Julius TuskenisDate: 2008-03-31 12:24:09
Subject: Re: what is the origin of postgreSQL time
Previous:From: Tommy GildsethDate: 2008-03-31 12:17:31
Subject: Re: what is the origin of postgreSQL time

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group