| From: | Bruce Momjian <pgman(at)candle(dot)pha(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:26:15 |
| Message-ID: | 200404131826.i3DIQFB01304@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Nichlas Lfdahl 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
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-04-13 18:45:57 | Re: log_min_cost_statement |
| Previous Message | Tom Lane | 2004-04-13 17:16:29 | Re: Postgres Admin - Export Database |