Re: Planner debug views

From: Qingqing Zhou <zhouqq(dot)postgres(at)gmail(dot)com>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Planner debug views
Date: 2015-07-23 19:27:02
Message-ID: CAJjS0u1P1LpDHCDO2PK95GEpyW3Q2wYfB=h1Nv-N18ktxxB=BA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Jul 21, 2015 at 5:15 PM, Qingqing Zhou
<zhouqq(dot)postgres(at)gmail(dot)com> wrote:
> Here is a proposal introducing some debugging infrastructure into the
> core. The basic idea is to allow us to query the planner search space.
> To so do, we can dump related information to csv files and use foreign
> table to query them.

FWIW, this is to tackle(+) optimizer TODO item:

https://wiki.postgresql.org/wiki/Todo#Optimizer_.2F_Executor
Improve ability to display optimizer analysis using OPTIMIZER_DEBUG

Regards,
Qingqing

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2015-07-23 19:33:07 Re: What is HeapScanDescData.rs_initblock good for?
Previous Message Ildus Kurbangaliev 2015-07-23 19:01:39 Re: RFC: replace pg_stat_activity.waiting with something more descriptive