More PG Log - Mailing list pgsql-general

Oh, thankx for the answer on PG Log.
 
our postgres is on windows , it is version 9.0.5. There are a variety of applications, like CRM , Stockrelated
and now there is a online game based on it.
 
We are providing application development, statistics, datametrics support . For simple application and user settings
we use SqlLite and main application is on Postgres
 
PG Log is our only window to all the activies on DB Server and therefore it becomes very important especially to track
abnormal query or activities that are causing frequent errors. at any time we have aroung 10k entries waiting to be analyzed
for which we are building a customer application in c sharp, that matches our keywords.
 
For which,
 
Query 1
-----------
do we have a standard list of following Log Codes
- Command_tag ex. IDLE, SELECT ..
- error_severity , ex. FATAL, LOG .. 
- sql_state_code , ex. 00000, 08P01 ..
 
 
Query 2
----------

I have my CSV Log with lot of occurances of a certain Log select statement. 
-----------------------------------------------------------------------------------------------------
2012-03-28 19:25:48.015 IST,"postgres","stock_apals",2388,"localhost:1898",4f731863.954,7,"idle",2012-03-28 19:25:47 IST,2/98,0,LOG,00000,"statement: SELECT typname, oid FROM pg_type WHERE typname IN ('oidvector', '_oidvector', 'unknown', '_unknown', 'refcursor', '_refcursor', 'char', '_char', 'bpchar', '_bpchar', 'varchar', '_varchar', 'text', '_text', 'name', '_name', 'bytea', '_bytea', 'bit', '_bit', 'bool', '_bool', 'int2', '_int2', 'int4', '_int4', 'int8', '_int8', 'oid', '_oid', 'float4', '_float4', 'float8', '_float8', 'numeric', '_numeric', 'inet', '_inet', 'money', '_money', 'point', '_point', 'lseg', '_lseg', 'path', '_path', 'box', '_box', 'circle', '_circle', 'polygon', '_polygon', 'uuid', '_uuid', 'xml', '_xml', 'interval', '_interval', 'date', '_date', 'time', '_time', 'timetz', '_timetz', 'timestamp', '_timestamp', 'abstime', '_abstime', 'timestamptz', '_timestamptz')",,,,,,,,"exec_simple_query, .\src\backend\tcop\postgres.c:900",""
-----------------------------------------------------------------------------------------------------
 
Is is a performance concern. ?
is there anything that i can do to keep this statement from recurring.

 
 
Regards
arvind