Hi pgsql-novice:
I am using 8.3 and trying to build a log analyzer to take stats. I am trying
to log the following:
Database Connection: Database Name, so I know which database its on
Statement: SELECT, INSERT, UPDATE, DELETE
Timestamp of Statement
Duration of statement (could be important for performance tuning)
And most important, I would like a record seperator, "<**** >", after each
log entry so my parser can know when to start and stop, for example:
<****>
foo_db: select * from some_table: Feb 21, 2008: 1s
<****>
Is this possible to do? Are there internal catalog command I can use
instead?
Any thoughts?
TIA