explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6v8u

Settings
# exclusive inclusive rows x rows loops node
1. 0.117 56.828 ↓ 1.1 445 1

erge Right Join (cost=44,177.08..44,183.66 rows=415 width=105) (actual time=56.617..56.828 rows=445 loops=1)

  • Merge Cond: (bar.j = baz.j)
2. 0.033 0.033 ↑ 909,098.2 11 1

Index Scan using ix_bar_j on bar (cost=0.43..333,222.64 rows=10,000,080 width=31) (actual time=0.025..0.033 rows=11 loops=1)

3. 0.000 56.678 ↓ 1.1 445 1

Sort (cost=44,176.64..44,177.68 rows=415 width=74) (actual time=56.581..56.678 rows=445 loops=1)

  • Sort Key: baz.j
  • Sort Method: quicksort Memory: 87kB
4. 6.534 59.554 ↓ 1.1 445 1

Gather (cost=37,628.53..44,158.60 rows=415 width=74) (actual time=30.530..59.554 rows=445 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 14.109 53.020 ↑ 1.2 148 3 / 3

Parallel Hash Join (cost=36,628.53..43,117.10 rows=173 width=74) (actual time=27.387..53.020 rows=148 loops=3)

  • Hash Cond: (foobar.d = baz.d)
6. 11.892 11.892 ↑ 1.2 143,468 3 / 3

Parallel Seq Scan on foobar (cost=0.00..5,815.35 rows=179,335 width=37) (actual time=0.007..11.892 rows=143,468 loops=3)

7. 1.183 27.019 ↑ 1.2 4,295 3 / 3

Parallel Hash (cost=36,563.61..36,563.61 rows=5,193 width=37) (actual time=27.019..27.019 rows=4,295 loops=3)

  • Buckets: 16384 Batches: 1 Memory Usage: 1152kB
8. 24.981 25.836 ↑ 1.2 4,295 3 / 3

Parallel Bitmap Heap Scan on baz (cost=237.02..36,563.61 rows=5,193 width=37) (actual time=2.395..25.836 rows=4,295 loops=3)

  • Recheck Cond: (k < '10'::numeric)
  • Heap Blocks: exact=5413
9. 0.855 0.855 ↓ 1.0 12,886 1 / 3

Bitmap Index Scan on ix_baz_k (cost=0.00..233.91 rows=12,463 width=0) (actual time=2.565..2.565 rows=12,886 loops=1)

  • Index Cond: (k < '10'::numeric)