explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RFX2

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 625.642 ↓ 0.0 0 1

HashAggregate (cost=62,954.84..62,955.09 rows=25 width=19) (actual time=625.642..625.642 rows=0 loops=1)

  • Group Key: part.p_brand
2. 0.020 625.640 ↓ 0.0 0 1

Hash Join (cost=48,107.38..62,852.35 rows=20,497 width=11) (actual time=625.640..625.640 rows=0 loops=1)

  • Hash Cond: (mv_partsupp.partkey = part.p_partkey)
3. 0.027 0.027 ↑ 800,000.0 1 1

Seq Scan on mv_partsupp (cost=0.00..11,540.00 rows=800,000 width=8) (actual time=0.027..0.027 rows=1 loops=1)

4. 0.001 625.593 ↓ 0.0 0 1

Hash (cost=48,041.85..48,041.85 rows=5,243 width=31) (actual time=625.593..625.593 rows=0 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 64kB
5. 0.002 625.592 ↓ 0.0 0 1

Merge Join (cost=35,742.44..48,041.85 rows=5,243 width=31) (actual time=625.592..625.592 rows=0 loops=1)

  • Merge Cond: (orders.o_orderkey = lineitem.l_orderkey)
6. 0.014 0.014 ↑ 1,048,576.0 1 1

Index Only Scan using orders_pkey on orders (cost=0.42..46,512.07 rows=1,048,576 width=4) (actual time=0.014..0.014 rows=1 loops=1)

  • Heap Fetches: 1
7. 0.000 625.576 ↓ 0.0 0 1

Sort (cost=35,742.01..35,755.12 rows=5,243 width=39) (actual time=625.576..625.576 rows=0 loops=1)

  • Sort Key: lineitem.l_orderkey
  • Sort Method: quicksort Memory: 25kB
8. 146.332 655.086 ↓ 0.0 0 1

Gather (cost=1,000.42..35,418.10 rows=5,243 width=39) (actual time=625.570..655.086 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
9. 0.005 508.754 ↓ 0.0 0 3

Nested Loop (cost=0.42..33,893.80 rows=2,185 width=39) (actual time=508.754..508.754 rows=0 loops=3)

10. 508.749 508.749 ↓ 0.0 0 3

Parallel Seq Scan on lineitem (cost=0.00..26,688.33 rows=2,185 width=24) (actual time=508.748..508.749 rows=0 loops=3)

  • Filter: (l_partkey = l_suppkey)
  • Rows Removed by Filter: 349525
11. 0.000 0.000 ↓ 0.0 0

Index Scan using part_pkey on part (cost=0.42..3.30 rows=1 width=15) (never executed)

  • Index Cond: (p_partkey = lineitem.l_partkey)