Re: log_min_cost_statement

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Nichlas Löfdahl <crotalus(at)acc(dot)umu(dot)se>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: log_min_cost_statement
Date: 2004-04-13 18:45:57
Message-ID: 25219.1081881957@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Nichlas =?iso-8859-1?Q?L=F6fdahl?= <crotalus(at)acc(dot)umu(dot)se> 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 unoptimized queries that way.

Why would you want to filter on the planner's cost estimate rather than
the true runtime?

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Eisentraut 2004-04-13 18:46:05 Re: log_min_cost_statement
Previous Message Bruce Momjian 2004-04-13 18:26:15 Re: log_min_cost_statement