explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CiYV

Settings
# exclusive inclusive rows x rows loops node
1. 30.969 444.376 ↓ 155.3 9,937 1

Hash Join (cost=6,249.81..19,087.41 rows=64 width=38) (actual time=43.760..444.376 rows=9,937 loops=1)

  • Hash Cond: ((rm.reticle_design_id = rd.reticle_design_id) AND ((rrl.mask_no)::text = (rd.mask_no)::text))
2. 0.000 392.687 ↓ 28.8 171,946 1

Nested Loop (cost=3,460.04..16,252.16 rows=5,978 width=57) (actual time=22.936..392.687 rows=171,946 loops=1)

3. 36.323 73.009 ↓ 20.4 171,951 1

Hash Join (cost=3,459.62..8,270.07 rows=8,430 width=26) (actual time=22.919..73.009 rows=171,951 loops=1)

  • Hash Cond: (pm.proj_parent_id = pg.proj_id)
4. 13.886 13.886 ↓ 1.0 90,901 1

Seq Scan on proj_master pm (cost=0.00..4,385.75 rows=90,775 width=38) (actual time=0.002..13.886 rows=90,901 loops=1)

5. 1.830 22.800 ↓ 1.2 10,493 1

Hash (cost=3,353.35..3,353.35 rows=8,502 width=26) (actual time=22.800..22.800 rows=10,493 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 733kB
6. 3.173 20.970 ↓ 1.2 10,493 1

Merge Join (cost=1,684.90..3,353.35 rows=8,502 width=26) (actual time=10.211..20.970 rows=10,493 loops=1)

  • Merge Cond: (pg.reticle_request_id = rrl.reticle_request_id)
7. 6.696 6.696 ↑ 10.3 8,793 1

Index Scan using fki_proj_master_reticle_request_fk on proj_master pg (cost=0.29..15,876.36 rows=90,775 width=38) (actual time=0.011..6.696 rows=8,793 loops=1)

8. 6.638 11.101 ↓ 1.0 11,280 1

Sort (cost=1,684.60..1,712.45 rows=11,142 width=26) (actual time=10.196..11.101 rows=11,280 loops=1)

  • Sort Key: rrl.reticle_request_id
  • Sort Method: quicksort Memory: 1265kB
9. 4.463 4.463 ↓ 1.0 11,275 1

Seq Scan on reticle_request_layer rrl (cost=0.00..935.65 rows=11,142 width=26) (actual time=0.167..4.463 rows=11,275 loops=1)

  • Filter: (estimated_release_to_warp IS NOT NULL)
  • Rows Removed by Filter: 17390
10. 343.902 343.902 ↑ 1.0 1 171,951

Index Scan using reticle_master_pkey on reticle_master rm (cost=0.41..0.94 rows=1 width=50) (actual time=0.001..0.002 rows=1 loops=171,951)

  • Index Cond: (reticle_master_id = pm.proj_id)
11. 11.128 20.720 ↑ 1.0 44,471 1

Hash (cost=2,122.71..2,122.71 rows=44,471 width=22) (actual time=20.720..20.720 rows=44,471 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 2858kB
12. 9.592 9.592 ↑ 1.0 44,471 1

Seq Scan on reticle_design rd (cost=0.00..2,122.71 rows=44,471 width=22) (actual time=0.008..9.592 rows=44,471 loops=1)

Planning time : 3.601 ms
Execution time : 445.106 ms