Re: log_min_cost_statement

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Nichlas Löfdahl <crotalus(at)acc(dot)umu(dot)se>, pgsql-admin(at)postgresql(dot)org
Subject: Re: log_min_cost_statement
Date: 2004-04-13 18:46:05
Message-ID: 200404132046.05893.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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 believe that the costs have any absolute meaning at all then they
should be proportional to the execution time, so the existing setting
should be enough.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Eisentraut 2004-04-13 18:52:12 Re: Real time replication of PG DBs accross two servers - any experiences?
Previous Message Tom Lane 2004-04-13 18:45:57 Re: log_min_cost_statement