Re: [GENERAL] Logging query plan for queries

2005-06-07 Thread Bruce Momjian
Himanshu Baweja wrote: > > --- Bruce Momjian wrote: > > > 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. > > i thin

Re: [GENERAL] Logging query plan for queries

2005-06-07 Thread Himanshu Baweja
--- Bruce Momjian wrote: > > 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. i think bruce u got my question wrong... log_min_du

Re: [GENERAL] Logging query plan for queries

2005-06-06 Thread Bruce Momjian
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 w

[GENERAL] Logging query plan for queries

2005-06-06 Thread Himanshu Baweja
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 particu