Re: Extracting SQL from logs in a usable format

From: Greg Smith <greg(at)2ndquadrant(dot)com>
To: Chris Ernst <cernst(at)esoft(dot)com>
Cc: Rory Campbell-Lange <rory(at)campbell-lange(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: Extracting SQL from logs in a usable format
Date: 2009-12-19 06:19:29
Message-ID: 4B2C7071.2060401@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)2ndQuadrant(dot)com www.2ndQuadrant.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gauthier, Dave 2009-12-19 06:24:07 pulling metadata creation strings from metadata tables?
Previous Message Postgres User 2009-12-19 06:05:19 Re: Selecting from table into an array var