explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7Hxn

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

Limit (cost=0.41..432.58 rows=1 width=4,677) (actual time=122.334..122.334 rows=1 loops=1)

2. 0.002 122.332 ↑ 234,450.0 1 1

Nested Loop Left Join (cost=0.41..101,320,650.83 rows=234,450 width=4,677) (actual time=122.332..122.332 rows=1 loops=1)

  • Join Filter: (c.chrgid = js.chrgid)
3. 0.011 122.324 ↑ 692.0 1 1

Nested Loop Left Join (cost=0.41..99,837,031.03 rows=692 width=4,572) (actual time=122.324..122.324 rows=1 loops=1)

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

Nested Loop Left Join (cost=0.41..99,835,961.99 rows=692 width=3,717) (actual time=122.226..122.226 rows=1 loops=1)

  • Join Filter: (b.arragid = agen.agencycode)
  • Rows Removed by Join Filter: 23
5. 3.936 122.195 ↑ 692.0 1 1

Nested Loop Left Join (cost=0.41..99,834,774.25 rows=692 width=3,453) (actual time=122.195..122.195 rows=1 loops=1)

  • Join Filter: (j.personid = p.id)
  • Rows Removed by Join Filter: 69,227
6. 3.621 107.607 ↑ 2.0 1 1

Nested Loop Left Join (cost=0.41..99,830,437.03 rows=2 width=3,208) (actual time=107.607..107.607 rows=1 loops=1)

  • Join Filter: ((b.jailid = r.jailid) AND (b.bookid = r.bookid))
  • Rows Removed by Join Filter: 49,222
7. 0.005 89.547 ↑ 2.0 1 1

Nested Loop Left Join (cost=0.41..99,825,872.13 rows=2 width=3,039) (actual time=89.547..89.547 rows=1 loops=1)

  • Join Filter: (j.judgeid = c.judgeid)
  • Rows Removed by Join Filter: 3
8. 0.501 89.537 ↑ 2.0 1 1

Nested Loop (cost=0.41..99,825,871.01 rows=2 width=2,831) (actual time=89.537..89.537 rows=1 loops=1)

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

Nested Loop (cost=0.41..99,824,919.38 rows=2 width=2,128) (actual time=88.388..88.388 rows=1 loops=1)

  • Join Filter: (b.jailid = i.jailid)
  • Rows Removed by Join Filter: 17,290
10. 3.225 63.386 ↑ 3.0 1 1

Nested Loop (cost=0.41..99,819,542.05 rows=3 width=1,722) (actual time=63.386..63.386 rows=1 loops=1)

  • Join Filter: ((b.jailid = c.jailid) AND (b.bookid = c.bookid))
  • Rows Removed by Join Filter: 44,490
11. 0.004 0.019 ↑ 21,208.0 1 1

Nested Loop (cost=0.41..62,435.62 rows=21,208 width=1,368) (actual time=0.019..0.019 rows=1 loops=1)

12. 0.004 0.004 ↑ 21,208.0 1 1

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

13. 0.011 0.011 ↑ 1.0 1 1

Index Scan using jamin_book_pkey on jamin_book b (cost=0.41..2.80 rows=1 width=407) (actual time=0.011..0.011 rows=1 loops=1)

  • Index Cond: (jamin_book_zid = pt_js.convertedid)
14. 33.897 60.142 ↑ 1.6 44,491 1

Materialize (cost=0.00..10,794.78 rows=73,052 width=354) (actual time=0.006..60.142 rows=44,491 loops=1)

15. 26.245 26.245 ↑ 1.6 44,491 1

Seq Scan on jamin_charge c (cost=0.00..7,004.52 rows=73,052 width=354) (actual time=0.003..26.245 rows=44,491 loops=1)

16. 12.040 23.705 ↑ 1.1 17,291 1

Materialize (cost=0.00..2,670.26 rows=18,284 width=406) (actual time=0.015..23.705 rows=17,291 loops=1)

17. 11.665 11.665 ↑ 1.1 17,291 1

Seq Scan on jamin_inmate i (cost=0.00..1,613.84 rows=18,284 width=406) (actual time=0.012..11.665 rows=17,291 loops=1)

18. 0.648 0.648 ↑ 1.5 5,367 1

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

19. 0.002 0.005 ↑ 1.0 3 1

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

20. 0.003 0.003 ↑ 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.003 rows=3 loops=1)

21. 14.439 14.439 ↑ 1.0 49,223 1

Seq Scan on jamin_releas r (cost=0.00..1,532.78 rows=49,978 width=169) (actual time=0.003..14.439 rows=49,223 loops=1)

22. 10.652 10.652 ↑ 1.0 69,227 1

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

23. 0.013 0.025 ↑ 4.8 24 1

Materialize (cost=0.00..4.71 rows=114 width=264) (actual time=0.006..0.025 rows=24 loops=1)

24. 0.012 0.012 ↑ 4.8 24 1

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

25. 0.067 0.087 ↑ 1.0 102 1

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

26. 0.020 0.020 ↑ 1.0 102 1

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

27. 0.001 0.006 ↑ 67,760.0 1 1

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

28. 0.005 0.005 ↑ 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.005..0.005 rows=1 loops=1)

Planning time : 9.742 ms
Execution time : 125.729 ms