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