explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3FSp

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

Limit (cost=69,515.56..74,505.67 rows=1 width=5,281) (actual time=389.644..389.644 rows=1 loops=1)

2. 2.692 389.642 ↑ 1.0 1 1

Nested Loop (cost=69,515.56..74,505.67 rows=1 width=5,281) (actual time=389.642..389.642 rows=1 loops=1)

  • Join Filter: (co.rms_xref_incident_offense_zid = pt_co.convertedid)
  • Rows Removed by Join Filter: 32,524
3. 0.298 381.338 ↓ 4.0 4 1

Hash Join (cost=69,515.56..74,112.15 rows=1 width=5,219) (actual time=380.495..381.338 rows=4 loops=1)

  • Hash Cond: ((co.caseformid = p.formid) AND (co.caseinfoid = i.caseinfoid))
4. 2.005 2.005 ↑ 515.0 209 1

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

5. 32.631 379.035 ↓ 822.6 8,226 1

Hash (cost=69,515.41..69,515.41 rows=10 width=5,100) (actual time=379.035..379.035 rows=8,226 loops=1)

  • Buckets: 2,048 (originally 1024) Batches: 8 (originally 1) Memory Usage: 2,033kB
6. 38.756 346.404 ↓ 822.6 8,226 1

Hash Join (cost=66,347.11..69,515.41 rows=10 width=5,100) (actual time=299.855..346.404 rows=8,226 loops=1)

  • Hash Cond: (i.caseformid = p.formid)
7. 7.884 7.884 ↓ 1.0 12,566 1

Seq Scan on rms_incident i (cost=0.00..3,089.89 rows=12,529 width=1,767) (actual time=0.014..7.884 rows=12,566 loops=1)

  • Filter: (((z_rank_dup_incidents_persons = '1'::text) OR (z_rank_dup_incidents_persons IS NULL)) AND ((z_rank_dup_incidents_persons_rank = '1'::text) OR (z_rank_dup_incidents_persons_rank IS NULL)))
  • Rows Removed by Filter: 27
8. 15.416 299.764 ↓ 18.2 8,226 1

Hash (cost=66,341.45..66,341.45 rows=453 width=3,333) (actual time=299.764..299.764 rows=8,226 loops=1)

  • Buckets: 8,192 (originally 1024) Batches: 2 (originally 1) Memory Usage: 1,985kB
9. 24.848 284.348 ↓ 18.2 8,226 1

Hash Join (cost=1,766.46..66,341.45 rows=453 width=3,333) (actual time=14.539..284.348 rows=8,226 loops=1)

  • Hash Cond: (p.rms_persons_zid = pt_cn.convertedid)
10. 245.102 245.102 ↑ 1.0 58,088 1

Seq Scan on rms_persons p (cost=0.00..63,912.07 rows=58,523 width=3,268) (actual time=0.057..245.102 rows=58,088 loops=1)

  • Filter: (persontypeid IS NOT NULL)
  • Rows Removed by Filter: 1,409,624
11. 2.708 14.398 ↓ 1.0 11,561 1

Hash (cost=1,624.44..1,624.44 rows=11,362 width=65) (actual time=14.398..14.398 rows=11,561 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 1,122kB
12. 11.690 11.690 ↓ 1.0 11,561 1

Index Scan using dce_pt_casesnames_unique_convertedid_wtrun_idx on pt_casesnames pt_cn (cost=0.29..1,624.44 rows=11,362 width=65) (actual time=0.014..11.690 rows=11,561 loops=1)

  • Index Cond: (wtrun = 101)
13. 5.612 5.612 ↑ 1.3 8,131 4

Seq Scan on pt_casesoffenses pt_co (cost=0.00..258.26 rows=10,821 width=62) (actual time=0.004..1.403 rows=8,131 loops=4)

  • Filter: (wtrun = 101)
Planning time : 30.343 ms
Execution time : 392.484 ms