Re: log sql?

What we really need is something that prints the query, username, and
times for admins who want to see which queries are slow.  That is on the
TODO list.

---------------------------------------------------------------------------

Andrew Sullivan wrote:
> On Tue, Jul 30, 2002 at 12:14:16AM -0400, Bruce Momjian wrote:
> > Andrew, what postgresql.conf parameter is query logging.  I don't see
> > it.  I see:
> >
> >     #log_connections = false
> >     #log_timestamp = false
> >     #log_pid = false
>
>     debug_print_query = true
>
> If you really want to see what's going on, you can also turn on any
> of these:
>
> #debug_print_parse = false
> #debug_print_rewritten = false
> #debug_print_plan = false
> #debug_pretty_print = false
>
> The _rewritten one is really interesting, and sometimes shows you why
> your query runs slowly.  Not recommended for production systems,
> though!
>
> Note that all of this exacts a cost, so if you need really blazing
> performance, it's not a bad idea to turn it off.  But for tracking
> down problems, nothing beats a good verbose log.
>
> A
>
> --
> ----
> Andrew Sullivan                               87 Mowat Avenue
> Liberty RMS                           Toronto, Ontario Canada
> <andrew@libertyrms.info>                              M6K 3E3
>                                          +1 416 646 3304 x110
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@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