Nichlas Löfdahl wrote: > Hello! > > Would it be possible to have an option "log_min_cost_statement", similar to > "log_min_duration_statement" except that it logs all statement that has > an minimum cost estimated by the planner? I think it would be easier to > find unoptimized queries that way.
Uh, yea, I guess we could, but the costs are more comparison with other costs, not really with other queries, I think, so I am not sure it would be meaningful. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (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