Re: log sql?

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