Logging query plan for queries

From: Himanshu Baweja <himanshubaweja(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Logging query plan for queries
Date: 2005-06-06 16:29:44
Message-ID: 20050606162944.6686.qmail@web51006.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2005-06-06 16:43:41 Re: Logging query plan for queries
Previous Message Jan Wieck 2005-06-06 16:00:36 Re: numeric precision when raising one numeric to another.