Re: log_min_cost_statement - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: log_min_cost_statement
Date
Msg-id 200404132046.05893.peter_e@gmx.net
Whole thread Raw
In response to log_min_cost_statement  (Nichlas Löfdahl <crotalus@acc.umu.se>)
List 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.


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: log_min_cost_statement
Next
From: Peter Eisentraut
Date:
Subject: Re: Real time replication of PG DBs accross two servers - any experiences?