explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FPtw

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 58.662 ↑ 1.0 1 1

Limit (cost=5,132.72..14,105.53 rows=1 width=5,193) (actual time=58.661..58.662 rows=1 loops=1)

2. 0.006 58.658 ↑ 1.0 1 1

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

3. 0.011 58.616 ↑ 1.0 1 1

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

  • Join Filter: (i.caseformid = p.formid)
4. 0.098 58.559 ↑ 1.0 1 1

Hash Join (cost=5,132.00..14,104.20 rows=1 width=1,948) (actual time=58.559..58.559 rows=1 loops=1)

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

Seq Scan on rms_incident i (cost=0.00..3,089.89 rows=12,529 width=1,767) (actual time=0.011..0.015 rows=4 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)))
6. 6.481 58.446 ↑ 1.0 10,821 1

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

  • Buckets: 16,384 Batches: 2 Memory Usage: 1,166kB
7. 37.033 51.965 ↑ 1.0 10,821 1

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

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

9. 1.421 3.771 ↑ 1.0 10,821 1

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

  • Buckets: 16,384 Batches: 1 Memory Usage: 1,122kB
10. 2.350 2.350 ↑ 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.008..2.350 rows=10,821 loops=1)

  • Filter: (wtrun = 101)
11. 0.046 0.046 ↑ 1.0 1 1

Index Scan using rms_persons_formids_idx on rms_persons p (cost=0.43..0.97 rows=1 width=3,180) (actual time=0.046..0.046 rows=1 loops=1)

  • Index Cond: (formid = co.caseformid)
  • Filter: (persontypeid IS NOT NULL)
12. 0.036 0.036 ↑ 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.036..0.036 rows=1 loops=1)

  • Index Cond: ((convertedid = p.rms_persons_zid) AND (wtrun = 101))
Planning time : 7.516 ms
Execution time : 59.818 ms