explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wBLs

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 218.347 ↑ 1.0 1 1

Limit (cost=0.00..6.83 rows=1 width=6,802) (actual time=218.347..218.347 rows=1 loops=1)

2. 0.004 218.346 ↑ 1,559,111,862.0 1 1

Nested Loop Left Join (cost=0.00..10,655,775,621.62 rows=1,559,111,862 width=6,802) (actual time=218.346..218.346 rows=1 loops=1)

  • Join Filter: (c.chrgid = js.chrgid)
3. 0.012 218.337 ↑ 4,601,865.0 1 1

Nested Loop Left Join (cost=0.00..801,340,139.62 rows=4,601,865 width=6,697) (actual time=218.337..218.337 rows=1 loops=1)

  • Join Filter: (agen.z_agencyname_agencies = pub_arra.agenciesid)
  • Rows Removed by Join Filter: 102
4. 0.003 218.286 ↑ 4,601,865.0 1 1

Nested Loop Left Join (cost=0.00..794,299,275.90 rows=4,601,865 width=5,842) (actual time=218.286..218.286 rows=1 loops=1)

  • Join Filter: (b.arragid = agen.agencycode)
  • Rows Removed by Join Filter: 23
5. 4.276 218.241 ↑ 4,601,865.0 1 1

Nested Loop Left Join (cost=0.00..786,430,082.32 rows=4,601,865 width=5,578) (actual time=218.241..218.241 rows=1 loops=1)

  • Join Filter: (j.personid = p.id)
  • Rows Removed by Join Filter: 69,227
6. 1.502 202.959 ↑ 13,295.0 1 1

Nested Loop (cost=0.00..757,598,445.61 rows=13,295 width=5,333) (actual time=202.959..202.959 rows=1 loops=1)

  • Join Filter: (b.jailid = i.jailid)
  • Rows Removed by Join Filter: 17,765
7. 3.737 180.306 ↑ 17.0 1 1

Nested Loop Left Join (cost=0.00..757,464,363.30 rows=17 width=3,670) (actual time=180.306..180.306 rows=1 loops=1)

  • Join Filter: ((b.jailid = r.jailid) AND (b.bookid = r.bookid))
  • Rows Removed by Join Filter: 49,517
8. 0.004 161.199 ↑ 17.0 1 1

Nested Loop Left Join (cost=0.00..757,425,561.65 rows=17 width=3,293) (actual time=161.199..161.199 rows=1 loops=1)

  • Join Filter: (j.judgeid = c.judgeid)
  • Rows Removed by Join Filter: 3
9. 0.169 161.188 ↑ 17.0 1 1

Nested Loop (cost=0.00..757,425,559.85 rows=17 width=3,085) (actual time=161.188..161.188 rows=1 loops=1)

  • Join Filter: (c.z_code_offenses = o.offensesid)
  • Rows Removed by Join Filter: 2,189
10. 5.600 160.802 ↑ 17.0 1 1

Nested Loop (cost=0.00..757,417,471.03 rows=17 width=2,382) (actual time=160.802..160.802 rows=1 loops=1)

  • Join Filter: ((b.jailid = c.jailid) AND (b.bookid = c.bookid))
  • Rows Removed by Join Filter: 71,750
11. 3.749 75.129 ↑ 21,208.0 1 1

Nested Loop (cost=0.00..71,818,502.03 rows=21,208 width=1,368) (actual time=75.129..75.129 rows=1 loops=1)

  • Join Filter: (b.jamin_book_zid = pt_js.convertedid)
  • Rows Removed by Join Filter: 49,512
12. 0.022 0.022 ↑ 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.022..0.022 rows=1 loops=1)

13. 33.181 71.358 ↑ 1.0 49,513 1

Materialize (cost=0.00..15,428.66 rows=49,977 width=407) (actual time=7.389..71.358 rows=49,513 loops=1)

14. 38.177 38.177 ↑ 1.0 49,513 1

Seq Scan on jamin_book b (cost=0.00..12,542.77 rows=49,977 width=407) (actual time=7.385..38.177 rows=49,513 loops=1)

15. 80.073 80.073 ↑ 8.1 71,751 1

Seq Scan on jamin_charge c (cost=0.00..23,585.75 rows=582,775 width=1,014) (actual time=0.485..80.073 rows=71,751 loops=1)

16. 0.217 0.217 ↑ 3.7 2,190 1

Seq Scan on offenses o (cost=0.00..374.25 rows=8,125 width=703) (actual time=0.002..0.217 rows=2,190 loops=1)

17. 0.003 0.007 ↑ 1.0 3 1

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

18. 0.004 0.004 ↑ 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.004 rows=3 loops=1)

19. 15.370 15.370 ↑ 1.0 49,518 1

Seq Scan on jamin_releas r (cost=0.00..1,532.78 rows=49,978 width=377) (actual time=0.004..15.370 rows=49,518 loops=1)

20. 21.151 21.151 ↑ 9.1 17,766 1

Seq Scan on jamin_inmate i (cost=0.00..5,860.42 rows=162,142 width=1,663) (actual time=0.008..21.151 rows=17,766 loops=1)

21. 11.006 11.006 ↑ 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..11.006 rows=69,227 loops=1)

22. 0.007 0.042 ↑ 4.8 24 1

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

23. 0.035 0.035 ↑ 4.8 24 1

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

24. 0.020 0.039 ↑ 1.0 102 1

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

25. 0.019 0.019 ↑ 1.0 102 1

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

26. 0.002 0.005 ↑ 67,760.0 1 1

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

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

Planning time : 8.429 ms
Execution time : 221.161 ms