explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JZdm

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

Limit (cost=0.00..6.35 rows=1 width=7,918) (actual time=209.144..209.145 rows=1 loops=1)

2. 0.003 209.143 ↑ 36,704,048,098,564.0 1 1

Nested Loop Left Join (cost=0.00..233,023,877,889,177.91 rows=36,704,048,098,564 width=7,918) (actual time=209.143..209.143 rows=1 loops=1)

  • Join Filter: (c.chrgid = js.chrgid)
3. 0.019 209.128 ↑ 108,335,443,030.0 1 1

Nested Loop Left Join (cost=0.00..1,034,360,182,964.88 rows=108,335,443,030 width=7,813) (actual time=209.128..209.128 rows=1 loops=1)

  • Join Filter: (agen.z_agencyname_agencies = pub_arra.agenciesid)
  • Rows Removed by Join Filter: 102
4. 0.005 209.080 ↑ 108,335,443,030.0 1 1

Nested Loop Left Join (cost=0.00..868,606,955,118.71 rows=108,335,443,030 width=6,958) (actual time=209.080..209.080 rows=1 loops=1)

  • Join Filter: (b.arragid = agen.agencycode)
  • Rows Removed by Join Filter: 23
5. 4.142 209.051 ↑ 108,335,443,030.0 1 1

Nested Loop Left Join (cost=0.00..683,353,347,532.98 rows=108,335,443,030 width=6,694) (actual time=209.051..209.051 rows=1 loops=1)

  • Join Filter: (j.personid = p.id)
  • Rows Removed by Join Filter: 69,227
6. 1.245 191.238 ↑ 312,986,098.0 1 1

Nested Loop (cost=0.00..4,609,348,014.45 rows=312,986,098 width=6,449) (actual time=191.238..191.238 rows=1 loops=1)

  • Join Filter: (b.jailid = i.jailid)
  • Rows Removed by Join Filter: 17,765
7. 0.004 169.227 ↑ 386,064.0 1 1

Nested Loop Left Join (cost=0.00..1,564,385,963.97 rows=386,064 width=4,786) (actual time=169.227..169.227 rows=1 loops=1)

  • Join Filter: (j.judgeid = c.judgeid)
  • Rows Removed by Join Filter: 3
8. 0.161 169.210 ↑ 386,064.0 1 1

Nested Loop (cost=0.00..1,564,368,590.05 rows=386,064 width=4,578) (actual time=169.210..169.210 rows=1 loops=1)

  • Join Filter: (c.z_code_offenses = o.offensesid)
  • Rows Removed by Join Filter: 2,189
9. 4.964 168.525 ↑ 386,064.0 1 1

Nested Loop (cost=0.00..1,380,674,513.05 rows=386,064 width=3,875) (actual time=168.525..168.525 rows=1 loops=1)

  • Join Filter: ((b.jailid = c.jailid) AND (b.bookid = c.bookid))
  • Rows Removed by Join Filter: 71,750
10. 3.337 84.474 ↑ 26,498.0 1 1

Nested Loop Left Join (cost=0.00..524,063,730.30 rows=26,498 width=2,861) (actual time=84.474..84.474 rows=1 loops=1)

  • Join Filter: ((b.jailid = r.jailid) AND (b.bookid = r.bookid))
  • Rows Removed by Join Filter: 49,517
11. 3.448 67.122 ↑ 21,208.0 1 1

Nested Loop (cost=0.00..475,657,530.70 rows=21,208 width=2,484) (actual time=67.122..67.122 rows=1 loops=1)

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

13. 63.649 63.649 ↑ 9.3 49,513 1

Seq Scan on jamin_book b (cost=0.00..16,658.59 rows=461,559 width=1,523) (actual time=30.948..63.649 rows=49,513 loops=1)

14. 14.015 14.015 ↑ 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..14.015 rows=49,518 loops=1)

15. 79.087 79.087 ↑ 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.520..79.087 rows=71,751 loops=1)

16. 0.524 0.524 ↑ 3.7 2,190 1

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

17. 0.005 0.013 ↑ 1.0 3 1

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

18. 0.008 0.008 ↑ 1.0 3 1

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

19. 20.766 20.766 ↑ 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..20.766 rows=17,766 loops=1)

20. 13.671 13.671 ↑ 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.009..13.671 rows=69,227 loops=1)

21. 0.009 0.024 ↑ 4.8 24 1

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

22. 0.015 0.015 ↑ 4.8 24 1

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

23. 0.015 0.029 ↑ 1.0 102 1

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

24. 0.014 0.014 ↑ 1.0 102 1

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

25. 0.001 0.012 ↑ 67,760.0 1 1

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

26. 0.011 0.011 ↑ 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.011..0.011 rows=1 loops=1)

Planning time : 10.241 ms
Execution time : 210.092 ms