explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5NMd

Settings
# exclusive inclusive rows x rows loops node
1. 85.476 1,379.233 ↓ 453.3 300,091 1

Gather (cost=8,810.22..47,869.75 rows=662 width=46) (actual time=123.862..1,379.233 rows=300,091 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=1,205,067 read=16,724
2. 72.474 1,293.757 ↓ 362.4 100,030 3 / 3

Nested Loop (cost=7,810.22..46,803.55 rows=276 width=46) (actual time=118.439..1,293.757 rows=100,030 loops=3)

  • Buffers: shared hit=1,205,067 read=16,724
3. 500.942 821.162 ↓ 320.6 100,030 3 / 3

Parallel Hash Join (cost=7,809.80..46,663.94 rows=312 width=39) (actual time=118.386..821.162 rows=100,030 loops=3)

  • Hash Cond: ((salaries.emp_no = titles.emp_no) AND (salaries.from_date = titles.from_date))
  • Buffers: shared hit=5,519 read=15,906
4. 204.781 204.781 ↑ 1.2 948,016 3 / 3

Parallel Seq Scan on salaries (cost=0.00..29,965.20 rows=1,185,020 width=20) (actual time=0.050..204.781 rows=948,016 loops=3)

  • Buffers: shared hit=2,209 read=15,906
5. 76.822 115.439 ↑ 1.3 147,769 3 / 3

Parallel Hash (cost=5,039.12..5,039.12 rows=184,712 width=23) (actual time=115.439..115.439 rows=147,769 loops=3)

  • Buckets: 524,288 Batches: 1 Memory Usage: 31,296kB
  • Buffers: shared hit=3,192
6. 38.617 38.617 ↑ 1.3 147,769 3 / 3

Parallel Seq Scan on titles (cost=0.00..5,039.12 rows=184,712 width=23) (actual time=0.028..38.617 rows=147,769 loops=3)

  • Buffers: shared hit=3,192
7. 400.121 400.121 ↑ 1.0 1 300,091 / 3

Index Scan using employees_pkey on employees (cost=0.42..0.45 rows=1 width=23) (actual time=0.004..0.004 rows=1 loops=300,091)

  • Index Cond: (emp_no = titles.emp_no)
  • Buffers: shared hit=1,199,548 read=818