Обсуждение: Logging query durations into another table in PostgreSQL 7.4

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.

Rajesh Kumar Mallah wrote:
>
> Hi,
>
> Is it possible to log the statements and durations of executed
> queries into a special table for later analysis. Or capturing the

No table option.

> 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

Sure, you can use syslog.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073