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

Re: 8.0 logging question

From: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: 8.0 logging question
Date: 2004-09-24 17:52:59
Message-ID: 200409241152.59273.pgsql@bluepolka.net (view raw or flat)
Thread:
Lists: pgsql-general
On Friday September 24 2004 11:45, Ed L. wrote:
>
> They appear to be coming from the saveplan calls in Slony's
> src/backend/slony1_funcs.c (attached) for sl_log_1 and sl_log_2.  Jan
> says "you never see the real execution of saved SPI plans in the log." 
> Here's what I see in my log resulting from a simple insert with
> log_error_verbosity = default and logging all:

Correction, that's with log_statement = 'mod'.

On a related note, I see that even though I have log_statement = 'mod' and 
log_duration = 'true', we are logging the durations for all queries, not 
just those that modify data.  That doesn't make much sense; there is no 
information there to know what the duration was for.

Ed


In response to

pgsql-general by date

Next:From: Paul TillotsonDate: 2004-09-24 18:39:11
Subject: Re: books/sites for someone really learning PG's advanced
Previous:From: Joshua D. DrakeDate: 2004-09-24 17:40:14
Subject: Re: pg_dump: what is advantage with schema and data dumps?

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