Re: [ADMIN] log_min_duration_statement log parsing

2008-03-31 Thread Vladimir Rusinov
On Mon, Mar 31, 2008 at 4:19 PM, Alexey Klyukin <[EMAIL PROTECTED]> wrote: > > 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/ Yes, acco

Re: [ADMIN] log_min_duration_statement log parsing

2008-03-31 Thread Alexey Klyukin
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 se

[ADMIN] log_min_duration_statement log parsing

2008-03-31 Thread Vladimir Rusinov
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