From: Alvaro Herrera <alvherre@commandprompt.com>
To: Ben Webber <ben.webber@egsgroup.com>
Cc: pgsql-admin@postgresql.org, Alexander Stanier <alexander.stanier@egsgroup.com>
Subject: Re: Change in logging behaviour between 8.1 and 8.2
Date: Mon, 17 Nov 2008 11:58:37 -0300
Message-ID: <20081117145837.GG4291@alvh.no-ip.org> (raw)
In-Reply-To: <49217587.4030709@egsgroup.com>
References: <4901E4ED.7090301@egsgroup.com>
<6092.1224892561@sss.pgh.pa.us>
<49217587.4030709@egsgroup.com>
Ben Webber wrote:
> Hi,
>
> 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 [23683] [mp_live] LOG: statement: CLUSTER;
> 2008-10-31 02:04:42 GMT [23683] [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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: alvherre@commandprompt.com, ben.webber@egsgroup.com, alexander.stanier@egsgroup.com
Subject: Re: Change in logging behaviour between 8.1 and 8.2
In-Reply-To: <20081117145837.GG4291@alvh.no-ip.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox