Himanshu Baweja wrote: > 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)....
Sure, see log_min_duration_statement. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
