explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ErOh

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

Limit (cost=1,963.62..7,628.26 rows=1 width=1,495) (actual time=29.279..29.279 rows=1 loops=1)

2. 0.007 29.277 ↑ 1.0 1 1

Nested Loop (cost=1,963.62..7,628.26 rows=1 width=1,495) (actual time=29.277..29.277 rows=1 loops=1)

3. 0.081 29.254 ↑ 1.0 1 1

Hash Join (cost=1,963.33..7,627.71 rows=1 width=1,430) (actual time=29.254..29.254 rows=1 loops=1)

  • Hash Cond: ((co.caseinfoid = ip.caseinfoid) AND (co.caseformid = ip.caseformid))
4. 0.134 8.579 ↑ 5,410.5 2 1

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

  • Hash Cond: (co.rms_xref_incident_offense_zid = pt_co.convertedid)
5. 1.835 1.835 ↑ 752.7 143 1

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

6. 2.590 6.610 ↑ 1.0 10,821 1

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

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

  • Filter: (wtrun = 101)
8. 10.555 20.594 ↓ 9.2 41,288 1

Hash (cost=797.12..797.12 rows=4,512 width=1,249) (actual time=20.594..20.594 rows=41,288 loops=1)

  • Buckets: 2,048 Batches: 4 Memory Usage: 1,519kB
9. 10.039 10.039 ↓ 9.2 41,288 1

Seq Scan on rms_xref_incident_person ip (cost=0.00..797.12 rows=4,512 width=1,249) (actual time=0.009..10.039 rows=41,288 loops=1)

  • Filter: (persontypeid IS NOT NULL)
10. 0.016 0.016 ↑ 1.0 1 1

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

  • Index Cond: ((convertedid = ip.rms_xref_incident_person_zid) AND (wtrun = 104))
Planning time : 4.228 ms
Execution time : 30.696 ms