Re: [ADMIN] log_min_cost_statement

2004-04-13 Thread Tom Lane
Nichlas =?iso-8859-1?Q?L=F6fdahl?= <[EMAIL PROTECTED]> writes: > 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 uno

Re: [ADMIN] log_min_cost_statement

2004-04-13 Thread Peter Eisentraut
Nichlas Löfdahl wrote: > 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. If you belie

Re: [ADMIN] log_min_cost_statement

2004-04-13 Thread Bruce Momjian
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.

[ADMIN] log_min_cost_statement

2004-04-13 Thread Nichlas Löfdahl
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. Just a thought! /Nichlas ---