EXPLAIN ANALYZE for parallel query doesn't report the SortMethod information.

From: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: EXPLAIN ANALYZE for parallel query doesn't report the SortMethod information.
Date: 2016-07-07 07:53:19
Message-ID: CAHGQGwFuAqC=p70Z_2BTHKztjkfFovfKCw2xJ9WmDSRFYJZ43w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

I found $SUBJECT while trying to test parallel queries. Is this a bug?

In not parallel mode, EXPLAIN ANALYZE reports the information about
Sort Method as follows.

=# EXPLAIN ANALYZE SELECT * FROM pgbench_accounts ORDER BY bid;
QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------------
Sort (cost=180739.34..183239.34 rows=1000000 width=97) (actual
time=1501.342..1836.057 rows=1000000 loops=1)
Sort Key: bid
Sort Method: external sort Disk: 104600kB
-> Seq Scan on pgbench_accounts (cost=0.00..26394.00 rows=1000000
width=97) (actual time=0.013..179.315 rows=1000000 loops=1)

However, in parallel mode, it's not reported, as follows.

=# SET force_parallel_mode TO on;
=# EXPLAIN ANALYZE SELECT * FROM pgbench_accounts ORDER BY bid;
QUERY
PLAN
-----------------------------------------------------------------------------------------------------------------------------------------
Gather (cost=181739.34..284239.34 rows=1000000 width=97) (actual
time=1507.138..2394.028 rows=1000000 loops=1)
Workers Planned: 1
Workers Launched: 1
Single Copy: true
-> Sort (cost=180739.34..183239.34 rows=1000000 width=97) (actual
time=1503.112..1901.117 rows=1000000 loops=1)
Sort Key: bid
-> Seq Scan on pgbench_accounts (cost=0.00..26394.00
rows=1000000 width=97) (actual time=0.021..181.079 rows=1000000
loops=1)

Regards,

--
Fujii Masao

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kyotaro HORIGUCHI 2016-07-07 07:57:29 Re: Header and comments describing routines in incorrect shape in visibilitymap.c
Previous Message Magnus Hagander 2016-07-07 07:49:18 Re: Don't include MMAP DSM's transient files in basebackup