Logging query durations into another table in PostgreSQL 7.4

From: Rajesh Kumar Mallah <mallah(at)trade-india(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Logging query durations into another table in PostgreSQL 7.4
Date: 2003-11-01 07:37:55
Message-ID: 3FA362D3.4070008@trade-india.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


Hi,

Is it possible to log the statements and durations of executed
queries into a special table for later analysis. Or capturing the
logfile and parsing it the only way? In the case of latter is it
possible to use syslog to pipe the lines through a program
can anyone please share the config if he has done it before

Regds
Mallah.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Dmitry Morozovsky 2003-11-01 09:41:24 Re: Shared memory corrupted?
Previous Message Rajesh Kumar Mallah 2003-11-01 06:05:13 Re: PostgreSQL Metadata