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
