explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IEjy

Settings
# exclusive inclusive rows x rows loops node
1. 0.032 11.313 ↑ 1.0 1 1

Aggregate (cost=18,624.21..18,624.22 rows=1 width=152) (actual time=11.313..11.313 rows=1 loops=1)

2. 0.993 11.281 ↓ 3.0 12 1

Hash Join (cost=448.69..18,624.07 rows=4 width=81) (actual time=11.245..11.281 rows=12 loops=1)

  • Hash Cond: ((i.incident_id)::text = (ir.incident_id)::text)
3. 8.791 10.099 ↓ 1.2 8,299 1

Bitmap Heap Scan on incident i (cost=340.89..18,490.77 rows=6,790 width=53) (actual time=2.314..10.099 rows=8,299 loops=1)

  • Recheck Cond: ((type)::text = 'RR_TEST_AUTOMATION.HTTP_RRTESTAUTOMATION_RRHTTPFieldNameWithSpecialChar1'::text)
  • Filter: ((status)::text = 'COMPLETED'::text)
  • Heap Blocks: exact=7570
4. 1.308 1.308 ↓ 1.1 8,299 1

Bitmap Index Scan on inc_type_idx (cost=0.00..339.19 rows=7,836 width=0) (actual time=1.308..1.308 rows=8,299 loops=1)

  • Index Cond: ((type)::text = 'RR_TEST_AUTOMATION.HTTP_RRTESTAUTOMATION_RRHTTPFieldNameWithSpecialChar1'::text)
5. 0.046 0.189 ↓ 1.5 204 1

Hash (cost=106.06..106.06 rows=139 width=102) (actual time=0.189..0.189 rows=204 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 36kB
6. 0.143 0.143 ↓ 1.5 204 1

Index Scan using time_started_idx on incident_resolution ir (cost=0.42..106.06 rows=139 width=102) (actual time=0.014..0.143 rows=204 loops=1)

  • Index Cond: ((time_started > '1565589600000'::bigint) AND (time_started < '1565596800000'::bigint))
  • Filter: ((time_completed < '1565596800000'::bigint) AND (time_completed <> 0))
Planning time : 0.266 ms