Обсуждение: log_min_duration_statement log parsing
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
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
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.
On Mon, Mar 31, 2008 at 4:19 PM, Alexey Klyukin <alexk@commandprompt.com> wrote:
Yes, according to description it is actually what we need.> And may be someone have such script or other ideas how to log long-runningI suggest you to take a look at pgFouine:
> statements in order to optimize them?
http://pgfouine.projects.postgresql.org/
Thanks a lot!
(Next time I should google before asking questions, sorry)
--
Vladimir Rusinov
Voronezh, Russia
UNIX Admin @ Murano Software