Re: Extracting SQL from logs in a usable format

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