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

log_min_duration_statement log parsing

From: "Vladimir Rusinov" <vladimir(at)greenmice(dot)info>
To: pgsql-admin(at)postgresql(dot)org
Subject: log_min_duration_statement log parsing
Date: 2008-03-31 12:06:26
Message-ID: f6fdfb550803310506r4fea74ecre3018158529fefff@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
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

Responses

pgsql-admin by date

Next:From: Julius TuskenisDate: 2008-03-31 12:09:22
Subject: Re: what is the origin of postgreSQL time
Previous:From: Vishal AroraDate: 2008-03-31 12:04:16
Subject: Re: what is the origin of postgreSQL time

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