Postgres Pro
Downloads
Home   >   mailing lists

Thread: Trace postgresql

Trace postgresql

From
Kevin Heflin
Date:
Is there any type of trace function or any logs that can be created and
viewed that show any/all sql sent to postgres and the results?

Kevin

--------------------------------------------------------------------
Kevin Heflin          | ShreveNet, Inc.      | Ph:318.222.2638 x103
VP/Mac Tech           | 333 Texas St #175    | FAX:318.221.6612
kheflin@shreve.net    | Shreveport, LA 71101 | http://www.shreve.net
--------------------------------------------------------------------

Re: [GENERAL] Trace postgresql

From
Bruce Momjian
Date:
>
> Is there any type of trace function or any logs that can be created and
> viewed that show any/all sql sent to postgres and the results?
>
> Kevin

Sure, use -d flags to postgres backend and postmaster.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026