On Wed, Sep 9, 2015 at 8:09 PM, Robert Haas <robertmh...@gmail.com> wrote: > > On Wed, Sep 9, 2015 at 2:17 AM, Haribabu Kommi <kommi.harib...@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. With Regards, Amit Kapila. EnterpriseDB: http://www.enterprisedb.com
