Re: Extracting SQL from logs in a usable format - Mailing list pgsql-general

From Chris Ernst
Subject Re: Extracting SQL from logs in a usable format
Date
Msg-id 4B2CE2F8.9040007@esoft.com
Whole thread Raw
In response to Re: Extracting SQL from logs in a usable format  (Greg Smith <greg@2ndquadrant.com>)
List pgsql-general
Greg Smith wrote:
> Chris Ernst wrote:
>> I started writing my own log parser to pull the statements from the
>> postgres logs, but as I get in to the details, it's not quite as
>> straight forward as I had thought.  Keeping track of which client
>> connections have prepared queries, merging the correct arguments and
>> maintaining concurrency are all critical and far from trivial.
>>
> I hope you're using the CVS format logs, which should make the job a lot
> easier than the standard text one.


HOLY COW!  I hadn't even thought of that.  Excellent point.  Thank you,
Greg.

    - Chris


pgsql-general by date:

Previous
From: Clayton Graf
Date:
Subject: AccessShareLock question
Next
From: Merlin Moncure
Date:
Subject: Re: Selecting from table into an array var