Re: Extracting SQL from logs in a usable format

From: Chris Ernst <cernst(at)esoft(dot)com>
To: Greg Smith <greg(at)2ndquadrant(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Extracting SQL from logs in a usable format
Date: 2009-12-19 14:28:08
Message-ID: 4B2CE2F8.9040007@esoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2009-12-19 14:56:05 Re: Selecting from table into an array var
Previous Message Clayton Graf 2009-12-19 14:04:56 AccessShareLock question