explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cYsv

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

Limit (cost=3,149.49..76,384.49 rows=1 width=7,526) (actual time=86.659..86.659 rows=1 loops=1)

2. 0.007 86.657 ↑ 1.0 1 1

Nested Loop Left Join (cost=3,149.49..76,384.49 rows=1 width=7,526) (actual time=86.657..86.657 rows=1 loops=1)

3. 0.009 86.649 ↑ 1.0 1 1

Nested Loop Left Join (cost=3,149.06..76,384.00 rows=1 width=7,486) (actual time=86.649..86.649 rows=1 loops=1)

4. 0.125 86.638 ↑ 1.0 1 1

Nested Loop Left Join (cost=3,148.64..76,382.18 rows=1 width=6,999) (actual time=86.638..86.638 rows=1 loops=1)

  • Join Filter: (i.caseinfoid = iv.caseinfoid)
  • Rows Removed by Join Filter: 1,417
5. 0.016 83.290 ↑ 1.0 1 1

Nested Loop Left Join (cost=3,148.64..75,847.31 rows=1 width=6,720) (actual time=83.290..83.290 rows=1 loops=1)

  • Join Filter: ((ao.badgenumber = sa.reportingofficerbadge) AND (ao.username = i.reportingofficer))
  • Rows Removed by Join Filter: 45
6. 0.011 83.249 ↑ 1.0 1 1

Nested Loop Left Join (cost=3,148.64..75,821.17 rows=1 width=6,413) (actual time=83.249..83.249 rows=1 loops=1)

  • Join Filter: (cb.userid = sa.createby)
  • Rows Removed by Join Filter: 46
7. 0.054 83.231 ↑ 1.0 1 1

Nested Loop Left Join (cost=3,148.64..75,795.99 rows=1 width=6,106) (actual time=83.231..83.231 rows=1 loops=1)

  • Join Filter: (ub.userid = sa.lastmodby)
  • Rows Removed by Join Filter: 210
8. 0.947 83.137 ↑ 1.0 1 1

Nested Loop (cost=3,148.64..75,770.82 rows=1 width=5,799) (actual time=83.137..83.137 rows=1 loops=1)

  • Join Filter: (a.caseinfoid = i.caseinfoid)
  • Rows Removed by Join Filter: 6,567
9. 0.083 78.576 ↑ 1.0 1 1

Hash Join (cost=3,148.64..72,555.48 rows=1 width=4,032) (actual time=78.576..78.576 rows=1 loops=1)

  • Hash Cond: (p.personid = sa.personid)
10. 0.014 0.014 ↑ 133,466.6 11 1

Seq Scan on rms_persons p (cost=0.00..63,901.33 rows=1,468,133 width=3,180) (actual time=0.005..0.014 rows=11 loops=1)

11. 18.813 78.479 ↓ 10,383.0 10,383 1

Hash (cost=3,148.63..3,148.63 rows=1 width=852) (actual time=78.479..78.479 rows=10,383 loops=1)

  • Buckets: 8,192 (originally 1024) Batches: 4 (originally 1) Memory Usage: 1,985kB
12. 17.891 59.666 ↓ 10,383.0 10,383 1

Hash Join (cost=2,664.50..3,148.63 rows=1 width=852) (actual time=37.496..59.666 rows=10,383 loops=1)

  • Hash Cond: ((a.caseinfoid = sa.caseinfoid) AND (a.caseformid = sa.caseformid))
13. 4.357 4.357 ↑ 1.0 10,405 1

Seq Scan on rms_xref_incident_arrest a (cost=0.00..406.08 rows=10,405 width=187) (actual time=0.007..4.357 rows=10,405 loops=1)

  • Filter: (rms_xref_incident_arrest_zid <> 758)
  • Rows Removed by Filter: 1
14. 13.972 37.418 ↓ 5.7 10,372 1

Hash (cost=2,637.10..2,637.10 rows=1,827 width=665) (actual time=37.418..37.418 rows=10,372 loops=1)

  • Buckets: 8,192 (originally 2048) Batches: 2 (originally 1) Memory Usage: 1,985kB
15. 12.271 23.446 ↓ 5.7 10,372 1

Hash Join (cost=1,742.20..2,637.10 rows=1,827 width=665) (actual time=8.897..23.446 rows=10,372 loops=1)

  • Hash Cond: (sa.rms_xref_incident_suspectarrest_zid = pt_cn.convertedid)
16. 2.362 2.362 ↑ 1.0 10,375 1

Seq Scan on rms_xref_incident_suspectarrest sa (cost=0.00..759.91 rows=10,375 width=600) (actual time=0.004..2.362 rows=10,375 loops=1)

  • Filter: ((z_rank_arrest IS NULL) OR (z_rank_arrest = 1))
  • Rows Removed by Filter: 18
17. 2.379 8.813 ↓ 1.0 10,390 1

Hash (cost=1,613.10..1,613.10 rows=10,328 width=65) (actual time=8.813..8.813 rows=10,390 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 1,113kB
18. 6.434 6.434 ↓ 1.0 10,390 1

Index Scan using dce_pt_casesnames_unique_convertedid_wtrun_idx on pt_casesnames pt_cn (cost=0.29..1,613.10 rows=10,328 width=65) (actual time=0.019..6.434 rows=10,390 loops=1)

  • Index Cond: (wtrun = 103)
19. 3.614 3.614 ↑ 1.9 6,568 1

Seq Scan on rms_incident i (cost=0.00..3,058.41 rows=12,554 width=1,767) (actual time=0.006..3.614 rows=6,568 loops=1)

  • Filter: ((z_rank_dup_incidents_arrestee = '1'::text) OR (z_rank_dup_incidents_arrestee IS NULL))
  • Rows Removed by Filter: 10
20. 0.040 0.040 ↑ 1.1 211 1

Seq Scan on rms_users ub (cost=0.00..22.30 rows=230 width=307) (actual time=0.004..0.040 rows=211 loops=1)

21. 0.007 0.007 ↑ 4.9 47 1

Seq Scan on rms_users cb (cost=0.00..22.30 rows=230 width=307) (actual time=0.001..0.007 rows=47 loops=1)

22. 0.025 0.025 ↑ 4.7 46 1

Seq Scan on rms_users ao (cost=0.00..22.88 rows=218 width=307) (actual time=0.004..0.025 rows=46 loops=1)

  • Filter: (z_rank = 1)
  • Rows Removed by Filter: 1
23. 3.223 3.223 ↓ 1.0 1,417 1

Seq Scan on rms_xref_incident_vehicle iv (cost=0.00..517.57 rows=1,384 width=279) (actual time=0.015..3.223 rows=1,417 loops=1)

  • Filter: (("position" = 1) AND (vehiclenumber = 1) AND (rms_xref_incident_vehicle_zid <> ALL ('{95,713,1033,2487,3983}'::bigint[])))
  • Rows Removed by Filter: 11,645
24. 0.002 0.002 ↓ 0.0 0 1

Index Scan using rms_vehicle_vehicleid_idx on rms_vehicle v (cost=0.42..1.81 rows=1 width=487) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (iv.vehicleid = vehicleid)
25. 0.001 0.001 ↓ 0.0 0 1

Index Scan using ptvehicles_convertedid_wtrun_idx on pt_vehicles pt_v (cost=0.42..0.48 rows=1 width=40) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: ((convertedid = v.rms_vehicle_zid) AND (wtrun = 301))
Planning time : 20.992 ms
Execution time : 89.794 ms