explain.depesz.com

PostgreSQL's explain analyze made readable

Result: URnt

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

Limit (cost=3,859.62..6,238.13 rows=1 width=4,432) (actual time=800.022..800.022 rows=1 loops=1)

2. 0.010 800.021 ↑ 1.0 1 1

Nested Loop Left Join (cost=3,859.62..6,238.13 rows=1 width=4,432) (actual time=800.021..800.021 rows=1 loops=1)

  • Join Filter: (agen.z_agencyname_agencies = pub_arra.agenciesid)
  • Rows Removed by Join Filter: 102
3. 0.008 799.994 ↑ 1.0 1 1

Nested Loop Left Join (cost=3,859.62..6,226.84 rows=1 width=3,577) (actual time=799.994..799.994 rows=1 loops=1)

  • Join Filter: (b.arragid = agen.agencycode)
  • Rows Removed by Join Filter: 38
4. 0.004 799.977 ↑ 1.0 1 1

Nested Loop Left Join (cost=3,859.62..6,224.98 rows=1 width=3,313) (actual time=799.977..799.977 rows=1 loops=1)

5. 0.005 799.967 ↑ 1.0 1 1

Nested Loop Left Join (cost=3,859.33..6,224.57 rows=1 width=3,144) (actual time=799.967..799.967 rows=1 loops=1)

  • Join Filter: (j.judgeid = c.judgeid)
  • Rows Removed by Join Filter: 3
6. 0.005 799.960 ↑ 1.0 1 1

Nested Loop (cost=3,859.33..6,223.50 rows=1 width=2,936) (actual time=799.960..799.960 rows=1 loops=1)

7. 0.003 799.950 ↑ 1.0 1 1

Nested Loop (cost=3,859.05..6,223.17 rows=1 width=2,233) (actual time=799.950..799.950 rows=1 loops=1)

  • Join Filter: (b.jailid = i.jailid)
8. 0.111 799.940 ↑ 1.0 1 1

Hash Right Join (cost=3,858.76..6,222.67 rows=1 width=1,827) (actual time=799.940..799.940 rows=1 loops=1)

  • Hash Cond: ((js.jailid = c.jailid) AND (js.bookid = c.bookid) AND (js.chrgid = c.chrgid))
9. 0.007 0.007 ↑ 9,680.0 7 1

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

10. 157.185 799.822 ↓ 73,046.0 73,046 1

Hash (cost=3,858.74..3,858.74 rows=1 width=1,722) (actual time=799.822..799.822 rows=73,046 loops=1)

  • Buckets: 8,192 (originally 1024) Batches: 16 (originally 1) Memory Usage: 5,057kB
11. 27.743 642.637 ↓ 73,046.0 73,046 1

Nested Loop (cost=0.71..3,858.74 rows=1 width=1,722) (actual time=0.029..642.637 rows=73,046 loops=1)

12. 33.720 215.278 ↓ 471.2 49,952 1

Nested Loop (cost=0.41..3,762.60 rows=106 width=1,368) (actual time=0.021..215.278 rows=49,952 loops=1)

13. 31.702 31.702 ↓ 471.2 49,952 1

Seq Scan on stg_combined_jail_stays pt_js (cost=0.00..2,911.70 rows=106 width=961) (actual time=0.008..31.702 rows=49,952 loops=1)

  • Filter: (wtrun = 201)
14. 149.856 149.856 ↑ 1.0 1 49,952

Index Scan using jamin_book_pkey on jamin_book b (cost=0.41..8.02 rows=1 width=407) (actual time=0.003..0.003 rows=1 loops=49,952)

  • Index Cond: (jamin_book_zid = pt_js.convertedid)
15. 399.616 399.616 ↑ 1.0 1 49,952

Index Scan using jamin_charge_jailid_bookid_idx on jamin_charge c (cost=0.29..0.90 rows=1 width=354) (actual time=0.005..0.008 rows=1 loops=49,952)

  • Index Cond: (jailid = b.jailid)
  • Filter: (b.bookid = bookid)
  • Rows Removed by Filter: 12
16. 0.007 0.007 ↑ 1.0 1 1

Index Scan using jamin_inmate_jailid_idx on jamin_inmate i (cost=0.29..0.49 rows=1 width=406) (actual time=0.007..0.007 rows=1 loops=1)

  • Index Cond: (jailid = c.jailid)
17. 0.005 0.005 ↑ 1.0 1 1

Index Scan using offenses_pkey on offenses o (cost=0.28..0.32 rows=1 width=703) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (offensesid = c.z_code_offenses)
18. 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)

19. 0.006 0.006 ↑ 1.0 1 1

Index Scan using jamin_releas_jailid_bookid_idx on jamin_releas r (cost=0.29..0.40 rows=1 width=169) (actual time=0.006..0.006 rows=1 loops=1)

  • Index Cond: ((b.jailid = jailid) AND (b.bookid = bookid))
20. 0.009 0.009 ↑ 1.0 38 1

Seq Scan on tdt_core_agency agen (cost=0.00..1.38 rows=38 width=264) (actual time=0.003..0.009 rows=38 loops=1)

21. 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)

Planning time : 15.782 ms
Execution time : 811.612 ms