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. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
