Skip site navigation (1) Skip section navigation (2)

debug_print_plan (pg7.4) doesn't seem to do anything

From: Eric Brown <eric(dot)brown(at)propel(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: debug_print_plan (pg7.4) doesn't seem to do anything
Date: 2004-12-29 21:38:42
Message-ID: 02D23B31-59E2-11D9-AD0C-000A95C7176C@propel.com (view raw or flat)
Thread:
Lists: pgsql-general
I have the following settings:
syslog = 2
client_min_messages = notice
log_min_messages = debug5 (tried debug1 too)
log_error_verbosity = default (tried verbose too, but still doesn't 
print plan)
log_statement = true
log_duration = true
debug_print_plan = true
debug_print_parse = true

I thought setting debug_print_plan was supposed to explain every query 
in my log file? I don't see the plan print either.

I'm running version 7.4.6 (from fink) on OS X 10.3.7.

Thanks.

Eric Brown
408-571-6341
www.propel.com

Responses

pgsql-general by date

Next:From: Dave SmithDate: 2004-12-29 21:58:58
Subject: Advice on moving rows to history
Previous:From: Scott MarloweDate: 2004-12-29 21:07:06
Subject: pg_dump and pgpool

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group