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 ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
