explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MuEp

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

Limit (cost=86,176.62..92,556.73 rows=1 width=5,166) (actual time=396.176..396.176 rows=1 loops=1)

2. 14.500 396.174 ↑ 1.0 1 1

Nested Loop (cost=86,176.62..92,556.73 rows=1 width=5,166) (actual time=396.174..396.174 rows=1 loops=1)

  • Join Filter: (co.rms_xref_incident_offense_zid = pt_co.convertedid)
  • Rows Removed by Join Filter: 198,262
3. 0.759 354.124 ↓ 19.0 19 1

Hash Join (cost=86,176.62..92,163.21 rows=1 width=5,104) (actual time=350.679..354.124 rows=19 loops=1)

  • Hash Cond: ((co.caseformid = p.formid) AND (co.caseinfoid = i.caseinfoid))
4. 3.521 3.521 ↑ 49.0 2,196 1

Seq Scan on rms_xref_incident_offense co (cost=0.00..5,179.33 rows=107,633 width=118) (actual time=0.087..3.521 rows=2,196 loops=1)

5. 26.883 349.844 ↓ 822.6 8,226 1

Hash (cost=86,176.47..86,176.47 rows=10 width=4,986) (actual time=349.844..349.844 rows=8,226 loops=1)

  • Buckets: 2,048 (originally 1024) Batches: 8 (originally 1) Memory Usage: 2,034kB
6. 31.572 322.961 ↓ 822.6 8,226 1

Hash Join (cost=83,005.83..86,176.47 rows=10 width=4,986) (actual time=284.819..322.961 rows=8,226 loops=1)

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

Seq Scan on rms_incident i (cost=0.00..3,107.89 rows=12,529 width=1,759) (actual time=0.011..6.679 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. 14.419 284.710 ↓ 18.1 8,226 1

Hash (cost=83,000.15..83,000.15 rows=454 width=3,227) (actual time=284.710..284.710 rows=8,226 loops=1)

  • Buckets: 8,192 (originally 1024) Batches: 2 (originally 1) Memory Usage: 1,985kB
9. 20.311 270.291 ↓ 18.1 8,226 1

Hash Join (cost=1,761.31..83,000.15 rows=454 width=3,227) (actual time=22.697..270.291 rows=8,226 loops=1)

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

Seq Scan on rms_persons p (cost=0.00..80,580.40 rows=58,125 width=3,162) (actual time=8.821..236.669 rows=58,088 loops=1)

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

Hash (cost=1,618.01..1,618.01 rows=11,464 width=65) (actual time=13.311..13.311 rows=11,561 loops=1)

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

Index Scan using dce_pt_casesnames_unique_convertedid_wtrun_idx on pt_casesnames pt_cn (cost=0.29..1,618.01 rows=11,464 width=65) (actual time=0.017..10.508 rows=11,561 loops=1)

  • Index Cond: (wtrun = 101)
13. 27.550 27.550 ↑ 1.0 10,435 19

Seq Scan on pt_casesoffenses pt_co (cost=0.00..258.26 rows=10,821 width=62) (actual time=0.002..1.450 rows=10,435 loops=19)

  • Filter: (wtrun = 101)
Planning time : 29.495 ms
Execution time : 398.895 ms