Trace postgresql
Started by Kevin Heflinover 26 years ago2 messagesgeneral
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
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