|
Thanx for the reply,
I have enabled the csvlog option. There seem to be 24 columns in the Log. I have difficulty in understanding the following columns - virtual_transaction_id - transaction_id - hint - internal_query - internal_query_pos - context I have correlated the column names from log structure mentioned in documentation arvind
> Subject: RE: application for postgres Log > Date: Mon, 10 Sep 2012 09:31:29 +0200 > From: laurenz.albe@xxxxxxxxxx > To: arvindps@xxxxxxxxxxx; pgsql-general@xxxxxxxxxxxxxx > > Arvind Singh wrote: > > I am in a project that uses PostGresSql v9.0. We are developing an > application in CSharp to parse the > > PG server activity log installed on Windows 2003/XP or higher. > > > > Our application will : > > Scan the Log for a given search text and Post rows found > > Produce statistics related to SQL queries tracked in a time frame > > Will allow selection of log columns, that can be displayed in a > DataGrid > > > > I need some help or even a simple link that is related to this > subject. I am already checking Goog > > query of Postgres Log, though it gives mostly results for the postgres > Documentation. > > Maybe pgreplay can give you some inspiration: > http://pgreplay.projects.postgresql.org/ > > Check out parse.c which parses a log file. > > One bit of advice I'd like to give you is a recommendation > to use the CSV log format. The regular error log is much > harder to parse, and moreover everything that gets printed > to stderr by the server will end up there. This could be > dumps when the server runs out of memory or stuff that loaded > modules produce. All this will screw up your log file > parsing. > > Yours, > Laurenz Albe |
