On Wed, Sep 9, 2015 at 8:09 PM, Robert Haas <
robertmhaas@gmail.com> wrote:
>
> On Wed, Sep 9, 2015 at 2:17 AM, Haribabu Kommi <
kommi.haribabu@gmail.com> wrote:
> > And also regarding the number of workers (16) that is shown in the
> > explain analyze plan are not actually allotted because the in my
> > configuration i set the max_worker_process as 8 only. I feel the plan
> > should show the allotted workers not the planned workers.
> > If the query execution takes time because of lack of workers and the
> > plan is showing as 16 workers, in that case user may think that
> > even with 16 workers the query is slower, but actually it is not.
>
> I would expect EXPLAIN should show the # of workers planned, and
> EXPLAIN ANALYZE should show both the planned and actual values.
>
Sounds sensible, will look into doing that way.