Обсуждение: Trace postgresql

Поиск
Список
Период
Сортировка

Trace postgresql

От
Kevin Heflin
Дата:
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

От
Bruce Momjian
Дата:
>
> 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