PG Log MultiLine Records

From: Arvind Singh <arvindps(at)hotmail(dot)com>
To: PG laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: PG Log MultiLine Records
Date: 2012-09-21 11:16:37
Message-ID: BLU164-W53F72AEF7F0477513EA576CA990@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


we have been working on a CSV Log parser application in csharp.

we recently discovered that certain log entries or records can span across multiple lines.

in the sense, that the same activity has more detail in subsequent lines.

For ex, a select,insert query has
A query entry
A Duration entry
A Stats entry

and that is why there was a serious coding mistake in counting select entries, because the same select statement
is displayed in Query column twice and once in Detail column

So our application counted them as three queries.

My query is, has any of us come across more such examples or
:: is there a link or page explaining type of Log entries
:: Number of log statements a logentry type occupy.
:: or other finer details that we may overlook

it will be helpfull as we wish to release this application for all pg users at no price.

thanks arvind

----------------------------------------------What charm in words, a charm no words could give?
O dying words, can Music make you live
Far--far--away?
--------- (Alfred, Lord Tennyson in Far-Far-Away)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2012-09-21 12:02:32 Re: PG Log MultiLine Records
Previous Message Albe Laurenz 2012-09-21 10:25:09 Re: Why csvlog logs contexts without leading tab?