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