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. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (email@example.com) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers