explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hi5L

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 210.123 ↓ 0.0 0 1

Limit (cost=2,593.34..7,189.96 rows=1 width=846) (actual time=210.123..210.123 rows=0 loops=1)

2. 23.187 210.121 ↓ 0.0 0 1

Nested Loop (cost=2,593.34..7,189.96 rows=1 width=846) (actual time=210.121..210.121 rows=0 loops=1)

3. 89.924 138.184 ↓ 48,750.0 48,750 1

Hash Join (cost=2,593.05..7,189.64 rows=1 width=784) (actual time=36.445..138.184 rows=48,750 loops=1)

  • Hash Cond: ((co.caseinfoid = sa.caseinfoid) AND (co.caseformid = sa.caseformid))
4. 11.932 11.932 ↑ 1.0 107,633 1

Seq Scan on rms_xref_incident_offense co (cost=0.00..3,789.33 rows=107,633 width=119) (actual time=0.018..11.932 rows=107,633 loops=1)

5. 12.974 36.328 ↓ 7.7 10,120 1

Hash (cost=2,573.31..2,573.31 rows=1,316 width=665) (actual time=36.328..36.328 rows=10,120 loops=1)

  • Buckets: 8,192 (originally 2048) Batches: 2 (originally 1) Memory Usage: 1,985kB
6. 10.936 23.354 ↓ 7.7 10,120 1

Hash Join (cost=1,742.20..2,573.31 rows=1,316 width=665) (actual time=8.533..23.354 rows=10,120 loops=1)

  • Hash Cond: (sa.rms_xref_incident_suspectarrest_zid = pt_cn.convertedid)
7. 3.922 3.922 ↓ 1.4 10,121 1

Seq Scan on rms_xref_incident_suspectarrest sa (cost=0.00..733.93 rows=7,469 width=600) (actual time=0.014..3.922 rows=10,121 loops=1)

  • Filter: (suspect OR arrestee OR suspectarrestee OR runaway OR missing OR other)
  • Rows Removed by Filter: 272
8. 1.977 8.496 ↓ 1.0 10,390 1

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

  • Buckets: 16,384 Batches: 1 Memory Usage: 1,113kB
9. 6.519 6.519 ↓ 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.519 rows=10,390 loops=1)

  • Index Cond: (wtrun = 103)
10. 48.750 48.750 ↓ 0.0 0 48,750

Index Scan using dce_pt_casesoffenses_unique_convertedid_wtrun_idx on pt_casesoffenses pt_co (cost=0.29..0.31 rows=1 width=62) (actual time=0.001..0.001 rows=0 loops=48,750)

  • Index Cond: ((convertedid = co.rms_xref_incident_offense_zid) AND (wtrun = 101))
Planning time : 21.071 ms
Execution time : 210.301 ms