Ben Webber wrote:
> I wrote a shell script to find the duration and the related statement in the log file and place them one after the other if the duration is over a specified time like this:-
> 2008-10-31 02:00:49 GMT  [mp_live] LOG: statement: CLUSTER;
> 2008-10-31 02:04:42 GMT  [mp_live] LOG: duration: 232783.684 ms
I wonder if you'd benefit from doing CSV logs and then storing them into
a table. Querying using SQL is probably going to be easier (and more
robust -- it'd work even with embedded newlines etc).
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
In response to
pgsql-admin by date
|Next:||From: Ben Webber||Date: 2008-11-17 15:18:56|
|Subject: Re: Change in logging behaviour between 8.1 and 8.2|
|Previous:||From: Anony Mous||Date: 2008-11-17 14:55:27|
|Subject: restore failure|