非互換
FUJITSU Enterprise Postgres 11では、パラレルクエリが有効の場合、EXPLAIN ANALYZE 文で出力する計測データにパラレルワーカーのソート処理情報を追加します。
EXPLAIN ANALYZE 文の出力情報にパラレルワーカーのソート処理情報は出力しません。
[例]
=# EXPLAIN ANALYZE SELECT * FROM t1 ORDER BY c1;
QUERY PLAN ----------------------------------------------------------------------- Gather Merge (cost=9204049.69..19925528.06 rows=91891970 width=12) (actual time=112404.558..154479.236 rows=100000000 loops=1) Workers Planned: 2 Workers Launched: 2 -> Sort (cost=9203049.67..9317914.63 rows=45945985 width=12) (actual time=111671.406..115815.382 rows=33333333 loops=3) Sort Key: c1 Sort Method: external sort Disk: 856432kB -> Parallel Seq Scan on test3 (cost=0.00..1000000.85 rows=45945985 width=12) (actual time=2.710..93100.395 rows=33
333333 loops=3) Planning time: 0.160 ms Execution time: 158725.714 ms (9 行) =#
EXPLAIN ANALYZE 文の出力情報にパラレルワーカーのソート処理情報(ソート方法、処理サイズ)を出力します。
[例]
=# EXPLAIN ANALYZE SELECT * FROM t1 ORDER BY c1; QUERY PLAN ----------------------------------------------------------------------- Gather Merge (cost=8367863.07..18090772.59 rows=83333406 width=12) (actual time=212648.534..234706.544 rows=100000000 loops=1) Workers Planned: 2 Workers Launched: 2 -> Sort (cost=8366863.05..8471029.81 rows=41666703 width=12) (actual time=204899.404..208541.511 rows=33333333 loops=3) Sort Key: c1 Sort Method: external merge Disk: 867128kB Worker 0: Sort Method: external merge Disk: 853328kB Worker 1: Sort Method: external merge Disk: 823776kB -> Parallel Seq Scan on test8 (cost=0.00..957208.03 rows=41666703 width=12) (actual time=8.744..135696.844 rows=33333333
loops=3) Planning Time: 0.720 ms Execution Time: 238852.702 ms (11 行) =#
対処方法
ありません。