On Wed, Sep 9, 2015 at 2:17 AM, Haribabu Kommi <[email protected]> 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 protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
