Himanshu Baweja wrote: > > --- Bruce Momjian <pgman@xxxxxxxxxxxxxxxx> 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_duration_statement will log only the queries > which are longer than a particular value... and if i > turn debug_print_plan.... it will log plans for all > the queries irrespective of the value of > log_min_duration_statement... > that is wht my testing says.... > > plz point out if i am wrong... > and also... is there any way of logging plans for only > a part of queries which satisfy a particular duration > criteria... Oh, log _plans_ for queries over a certain duration --- we don't have any way to support that, sorry. In fact, at plan time we don't even know how long it will take for the query to run. -- Bruce Momjian | http://candle.pha.pa.us pgman@xxxxxxxxxxxxxxxx | (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 8: explain analyze is your friend
