Skip site navigation (1) Skip section navigation (2)

Re: Change in logging behaviour between 8.1 and 8.2

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Ben Webber <ben(dot)webber(at)egsgroup(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org, Alexander Stanier <alexander(dot)stanier(at)egsgroup(dot)com>
Subject: Re: Change in logging behaviour between 8.1 and 8.2
Date: 2008-11-17 14:58:37
Message-ID: 20081117145837.GG4291@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-admin
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.

In response to

Responses

pgsql-admin by date

Next:From: Ben WebberDate: 2008-11-17 15:18:56
Subject: Re: Change in logging behaviour between 8.1 and 8.2
Previous:From: Anony MousDate: 2008-11-17 14:55:27
Subject: restore failure

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group