Logging query plan for queries - Mailing list pgsql-general

From Himanshu Baweja
Subject Logging query plan for queries
Date
Msg-id 20050606162944.6686.qmail@web51006.mail.yahoo.com
Whole thread Raw
Responses Re: Logging query plan for queries
List pgsql-general
when i enable debug_print_plan and
debug_pretty_print...
query plans are written to log file for all
queries....(3 gb of logs in 3 mins) which is of course
diffcult to analyze and consume too much resources....

is it possible to log plans for only the queries whose
duration was more than a particular value or something
like that... (e.g. log_min_duration_statement)....

thx
Himanshu

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

pgsql-general by date:

Previous
From: Chris Browne
Date:
Subject: Re: postgresql books
Next
From: Bruce Momjian
Date:
Subject: Re: Logging query plan for queries