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: (view raw or whole thread)
Lists: pgsql-admin

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

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


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-2015 The PostgreSQL Global Development Group