Logging query durations into another table in PostgreSQL 7.4
Logging query durations into another table in PostgreSQL 7.4
От:
Rajesh Kumar Mallah <mallah@trade-india.com>
Дата:
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.
Re: Logging query durations into another table in PostgreSQL
От:
Bruce Momjian <pgman@candle.pha.pa.us>
Дата:
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