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

From Greg Smith
Subject Re: Extracting SQL from logs in a usable format
Date
Msg-id 4B2C7071.2060401@2ndquadrant.com
Whole thread Raw
In response to Re: Extracting SQL from logs in a usable format  (Chris Ernst <cernst@esoft.com>)
Responses Re: Extracting SQL from logs in a usable format  (Chris Ernst <cernst@esoft.com>)
List pgsql-general
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.

--
Greg Smith    2ndQuadrant   Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com  www.2ndQuadrant.com


pgsql-general by date:

Previous
From: Postgres User
Date:
Subject: Re: Selecting from table into an array var
Next
From: "Gauthier, Dave"
Date:
Subject: pulling metadata creation strings from metadata tables?