Re: selective statement logging - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: selective statement logging
Date
Msg-id 200403101924.i2AJOI314772@candle.pha.pa.us
Whole thread Raw
In response to selective statement logging  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: selective statement logging  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
Andrew Dunstan wrote:
> 
> The TODO list contains this item which I said I would look at:
> 
>   Allow logging of only data definition(DDL), or DDL and modification 
> statements
> 
> The trouble I see is that we currently do statement logging before we 
> have examined the query string at all, in the code shown below from 
> src/backend/tcop/postgres.c.
> 
> I guess I could construct one or more regexes to examine the query 
> string, although that might affect performance a bit (of course, I would 
> precompile the patterns).
> 
> Any other ideas on how to proceed?

Yes, look at how the command tag is grabbed for the PS display, and do
the log checks at that point.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Default Stats Revisited
Next
From: Bruce Momjian
Date:
Subject: Re: Timing of 'SELECT 1'