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