explain.depesz.com

PostgreSQL's explain analyze made readable

Result: flSn

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 24.568 ↑ 1.0 1 1

Limit (cost=0.29..7.00 rows=1 width=4,674) (actual time=24.568..24.568 rows=1 loops=1)

2. 0.002 24.566 ↑ 234,450.0 1 1

Nested Loop Left Join (cost=0.29..1,573,139.89 rows=234,450 width=4,674) (actual time=24.566..24.566 rows=1 loops=1)

  • Join Filter: (c.chrgid = js.chrgid)
3. 0.012 24.556 ↑ 692.0 1 1

Nested Loop Left Join (cost=0.29..89,520.09 rows=692 width=4,569) (actual time=24.556..24.556 rows=1 loops=1)

  • Join Filter: (agen.z_agencyname_agencies = pub_arra.agenciesid)
  • Rows Removed by Join Filter: 102
4. 0.003 24.471 ↑ 692.0 1 1

Nested Loop Left Join (cost=0.29..88,451.06 rows=692 width=3,714) (actual time=24.471..24.471 rows=1 loops=1)

  • Join Filter: (b.arragid = agen.agencycode)
  • Rows Removed by Join Filter: 2
5. 0.004 24.456 ↑ 692.0 1 1

Nested Loop Left Join (cost=0.29..87,263.31 rows=692 width=3,450) (actual time=24.456..24.456 rows=1 loops=1)

  • Join Filter: (j.personid = p.id)
  • Rows Removed by Join Filter: 3
6. 0.675 24.446 ↑ 2.0 1 1

Nested Loop Left Join (cost=0.29..82,926.10 rows=2 width=3,205) (actual time=24.446..24.446 rows=1 loops=1)

  • Join Filter: ((b.jailid = r.jailid) AND (b.bookid = r.bookid))
  • Rows Removed by Join Filter: 9,018
7. 0.005 21.119 ↑ 2.0 1 1

Nested Loop Left Join (cost=0.29..78,361.20 rows=2 width=3,036) (actual time=21.119..21.119 rows=1 loops=1)

  • Join Filter: (j.judgeid = c.judgeid)
  • Rows Removed by Join Filter: 2
8. 0.550 21.109 ↑ 2.0 1 1

Nested Loop (cost=0.29..78,360.07 rows=2 width=2,828) (actual time=21.109..21.109 rows=1 loops=1)

  • Join Filter: (c.z_code_offenses = o.offensesid)
  • Rows Removed by Join Filter: 5,366
9. 6.546 19.807 ↑ 2.0 1 1

Nested Loop (cost=0.29..77,408.44 rows=2 width=2,125) (actual time=19.807..19.807 rows=1 loops=1)

  • Join Filter: (b.jamin_book_zid = pt_js.convertedid)
  • Rows Removed by Join Filter: 18,001
10. 0.471 10.202 ↑ 4.0 1 1

Nested Loop (cost=0.29..64,895.72 rows=4 width=1,164) (actual time=10.202..10.202 rows=1 loops=1)

  • Join Filter: (b.jailid = i.jailid)
  • Rows Removed by Join Filter: 6,496
11. 0.003 0.032 ↑ 7.0 1 1

Nested Loop (cost=0.29..54,561.35 rows=7 width=758) (actual time=0.032..0.032 rows=1 loops=1)

12. 0.008 0.008 ↑ 49,977.0 1 1

Seq Scan on jamin_book b (cost=0.00..12,539.77 rows=49,977 width=407) (actual time=0.008..0.008 rows=1 loops=1)

13. 0.021 0.021 ↑ 1.0 1 1

Index Scan using jamin_charge_jailid_bookid_idx on jamin_charge c (cost=0.29..0.83 rows=1 width=351) (actual time=0.021..0.021 rows=1 loops=1)

  • Index Cond: ((jailid = b.jailid) AND (bookid = b.bookid))
14. 4.431 9.699 ↑ 2.8 6,497 1

Materialize (cost=0.00..2,670.26 rows=18,284 width=406) (actual time=0.031..9.699 rows=6,497 loops=1)

15. 5.268 5.268 ↑ 2.8 6,497 1

Seq Scan on jamin_inmate i (cost=0.00..1,613.84 rows=18,284 width=406) (actual time=0.026..5.268 rows=6,497 loops=1)

16. 3.059 3.059 ↑ 1.2 18,002 1

Seq Scan on stg_combined_jail_stays pt_js (cost=0.00..2,863.08 rows=21,208 width=961) (actual time=0.002..3.059 rows=18,002 loops=1)

17. 0.752 0.752 ↑ 1.5 5,367 1

Seq Scan on offenses o (cost=0.00..374.25 rows=8,125 width=703) (actual time=0.003..0.752 rows=5,367 loops=1)

18. 0.003 0.005 ↑ 1.0 3 1

Materialize (cost=0.00..1.04 rows=3 width=208) (actual time=0.004..0.005 rows=3 loops=1)

19. 0.002 0.002 ↑ 1.0 3 1

Seq Scan on tdt_core_judge j (cost=0.00..1.03 rows=3 width=208) (actual time=0.002..0.002 rows=3 loops=1)

20. 2.652 2.652 ↑ 5.5 9,019 1

Seq Scan on jamin_releas r (cost=0.00..1,532.78 rows=49,978 width=169) (actual time=0.002..2.652 rows=9,019 loops=1)

21. 0.006 0.006 ↑ 17,306.8 4 1

Seq Scan on tdt_core_person p (cost=0.00..1,303.27 rows=69,227 width=245) (actual time=0.005..0.006 rows=4 loops=1)

22. 0.007 0.012 ↑ 38.0 3 1

Materialize (cost=0.00..4.71 rows=114 width=264) (actual time=0.011..0.012 rows=3 loops=1)

23. 0.005 0.005 ↑ 38.0 3 1

Seq Scan on tdt_core_agency agen (cost=0.00..4.14 rows=114 width=264) (actual time=0.005..0.005 rows=3 loops=1)

24. 0.056 0.073 ↑ 1.0 102 1

Materialize (cost=0.00..10.53 rows=102 width=855) (actual time=0.004..0.073 rows=102 loops=1)

25. 0.017 0.017 ↑ 1.0 102 1

Seq Scan on agencies pub_arra (cost=0.00..10.02 rows=102 width=855) (actual time=0.002..0.017 rows=102 loops=1)

26. 0.004 0.008 ↑ 67,760.0 1 1

Materialize (cost=0.00..3,065.40 rows=67,760 width=105) (actual time=0.008..0.008 rows=1 loops=1)

27. 0.004 0.004 ↑ 67,760.0 1 1

Seq Scan on jamin_sentence js (cost=0.00..1,601.60 rows=67,760 width=105) (actual time=0.004..0.004 rows=1 loops=1)

Planning time : 9.237 ms
Execution time : 26.035 ms