Postgres Pro
Downloads
Home   >   mailing lists

Logging query durations into another table in PostgreSQL 7.4 - Mailing list pgsql-admin

From Rajesh Kumar Mallah
Subject Logging query durations into another table in PostgreSQL 7.4
Date
Msg-id 3FA362D3.4070008@trade-india.com
Whole thread Raw
Responses Re: Logging query durations into another table in PostgreSQL  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-admin
Tree view 
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.

pgsql-admin by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Matching indexes on int8 columns?
Next
From: Tom Lane
Date:
Subject: Re: Shared memory corrupted?