Re: Parallel Seq Scan

On Fri, Nov 13, 2015 at 9:16 PM, Thom Brown <thom(at)linux(dot)com> wrote:
>
> On 13 November 2015 at 15:22, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> wrote:
> >
> > There will be hardly any difference in nodes for each worker and it
could
> > be very long plan for large number of workers. What kind of additional
> > information you want which can't be shown in current format.
>
> For explain plans, not that useful, but it's useful to see how long
> each worker took for explain analyse.
>

The statistics related to buffers, timing and infact rows filtered will be
different for each worker, so it sounds sensible to me to display separate
plan info for each worker or at least display the same in verbose or some
other mode and then display aggregated information at Gather node. The
only point that needs more thought is that parallel plans will look big for
many number of workers. I think this will need somewhat substantial
changes than what is done currently for parallel seq scan, so it is better
if others also share their opinion about this form of display of information
for parallel queries.

With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com