explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nMGY

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 57.233 ↑ 1.0 1 1

Limit (cost=5,132.72..14,121.41 rows=1 width=5,193) (actual time=57.232..57.233 rows=1 loops=1)

2. 0.005 57.230 ↑ 1.0 1 1

Nested Loop (cost=5,132.72..14,121.41 rows=1 width=5,193) (actual time=57.230..57.230 rows=1 loops=1)

3. 0.008 57.213 ↑ 1.0 1 1

Nested Loop (cost=5,132.43..14,121.07 rows=1 width=5,128) (actual time=57.213..57.213 rows=1 loops=1)

4. 0.093 57.141 ↓ 2.0 2 1

Hash Join (cost=5,132.00..14,118.50 rows=1 width=1,948) (actual time=57.137..57.141 rows=2 loops=1)

  • Hash Cond: ((i.caseinfoid = co.caseinfoid) AND (i.caseformid = co.caseformid))
5. 0.013 0.013 ↑ 3,139.8 4 1

Seq Scan on rms_incident i (cost=0.00..3,089.89 rows=12,559 width=1,767) (actual time=0.008..0.013 rows=4 loops=1)

  • Filter: (((z_rank_dup_incidents_reportee = '1'::text) OR (z_rank_dup_incidents_reportee IS NULL)) AND ((z_rank_dup_incidents_reportee_rank = '1'::text) OR (z_rank_dup_incidents_reportee_rank IS NULL)))
6. 6.398 57.035 ↑ 1.0 10,821 1

Hash (cost=4,694.69..4,694.69 rows=10,821 width=181) (actual time=57.035..57.035 rows=10,821 loops=1)

  • Buckets: 16,384 Batches: 2 Memory Usage: 1,148kB
7. 36.078 50.637 ↑ 1.0 10,821 1

Hash Join (cost=393.53..4,694.69 rows=10,821 width=181) (actual time=4.952..50.637 rows=10,821 loops=1)

  • Hash Cond: (co.rms_xref_incident_offense_zid = pt_co.convertedid)
8. 11.016 11.016 ↑ 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.019..11.016 rows=107,633 loops=1)

9. 1.309 3.543 ↑ 1.0 10,821 1

Hash (cost=258.26..258.26 rows=10,821 width=62) (actual time=3.543..3.543 rows=10,821 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 1,122kB
10. 2.234 2.234 ↑ 1.0 10,821 1

Seq Scan on pt_casesoffenses pt_co (cost=0.00..258.26 rows=10,821 width=62) (actual time=0.006..2.234 rows=10,821 loops=1)

  • Filter: (wtrun = 101)
11. 0.064 0.064 ↓ 0.0 0 2

Index Scan using rms_persons_formids_idx on rms_persons p (cost=0.43..2.56 rows=1 width=3,180) (actual time=0.032..0.032 rows=0 loops=2)

  • Index Cond: (formid = i.page2formid)
  • Filter: (persontypeid IS NOT NULL)
  • Rows Removed by Filter: 0
12. 0.012 0.012 ↑ 1.0 1 1

Index Scan using dce_pt_casesnames_unique_convertedid_wtrun_idx on pt_casesnames pt_cn (cost=0.29..0.33 rows=1 width=65) (actual time=0.012..0.012 rows=1 loops=1)

  • Index Cond: ((convertedid = p.rms_persons_zid) AND (wtrun = 102))
Planning time : 5.968 ms
Execution time : 57.980 ms