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(at)libertyrms(dot)info> M6K 3E3
+1 416 646 3304 x110