explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nhOC

Settings
# exclusive inclusive rows x rows loops node
1. 79.086 975.182 ↓ 159.3 10,196 1

Nested Loop (cost=3,501.16..23,228.47 rows=64 width=38) (actual time=24.492..975.182 rows=10,196 loops=1)

  • Join Filter: ((rrl.mask_no)::text = (rd.mask_no)::text)
  • Rows Removed by Join Filter: 169616
2. 83.643 536.472 ↓ 29.9 179,812 1

Nested Loop (cost=3,500.74..16,402.85 rows=6,012 width=57) (actual time=24.470..536.472 rows=179,812 loops=1)

3. 53.289 93.195 ↓ 21.2 179,817 1

Hash Join (cost=3,500.32..8,402.53 rows=8,472 width=26) (actual time=24.456..93.195 rows=179,817 loops=1)

  • Hash Cond: (pm.proj_parent_id = pg.proj_id)
4. 15.529 15.529 ↓ 1.0 91,581 1

Seq Scan on proj_master pm (cost=0.00..4,475.35 rows=91,235 width=38) (actual time=0.003..15.529 rows=91,581 loops=1)

5. 1.988 24.377 ↓ 1.3 10,707 1

Hash (cost=3,393.51..3,393.51 rows=8,545 width=26) (actual time=24.377..24.377 rows=10,707 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 745kB
6. 3.946 22.389 ↓ 1.3 10,707 1

Merge Join (cost=1,691.72..3,393.51 rows=8,545 width=26) (actual time=11.363..22.389 rows=10,707 loops=1)

  • Merge Cond: (pg.reticle_request_id = rrl.reticle_request_id)
7. 6.199 6.199 ↑ 10.2 8,913 1

Index Scan using fki_proj_master_reticle_request_fk on proj_master pg (cost=0.29..16,219.78 rows=91,235 width=38) (actual time=0.005..6.199 rows=8,913 loops=1)

8. 6.819 12.244 ↓ 1.0 11,516 1

Sort (cost=1,691.42..1,719.45 rows=11,210 width=26) (actual time=11.354..12.244 rows=11,516 loops=1)

  • Sort Key: rrl.reticle_request_id
  • Sort Method: quicksort Memory: 1284kB
9. 5.425 5.425 ↓ 1.0 11,511 1

Seq Scan on reticle_request_layer rrl (cost=0.00..937.41 rows=11,210 width=26) (actual time=0.183..5.425 rows=11,511 loops=1)

  • Filter: (estimated_release_to_warp IS NOT NULL)
  • Rows Removed by Filter: 17577
10. 359.634 359.634 ↑ 1.0 1 179,817

Index Scan using reticle_master_pkey on reticle_master rm (cost=0.41..0.93 rows=1 width=50) (actual time=0.002..0.002 rows=1 loops=179,817)

  • Index Cond: (reticle_master_id = pm.proj_id)
11. 359.624 359.624 ↑ 1.0 1 179,812

Index Scan using reticle_design_pkey on reticle_design rd (cost=0.42..1.12 rows=1 width=22) (actual time=0.002..0.002 rows=1 loops=179,812)

  • Index Cond: (reticle_design_id = rm.reticle_design_id)