explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7BDM

Settings
# exclusive inclusive rows x rows loops node
1. 0.020 127.484 ↑ 1.0 1 1

Aggregate (cost=34,728.72..34,728.73 rows=1 width=64) (actual time=127.484..127.484 rows=1 loops=1)

2. 1.381 127.464 ↓ 2.4 12 1

Hash Join (cost=121.95..34,728.67 rows=5 width=24) (actual time=22.719..127.464 rows=12 loops=1)

  • Hash Cond: ((i.incident_id)::text = (ir.incident_id)::text)
3. 125.848 125.848 ↓ 1.2 8,294 1

Seq Scan on incident i (cost=0.00..34,581.22 rows=6,787 width=53) (actual time=0.063..125.848 rows=8,294 loops=1)

  • Filter: (((status)::text = 'COMPLETED'::text) AND ((type)::text = 'RR_TEST_AUTOMATION.HTTP_RRTESTAUTOMATION_RRHTTPFieldNameWithSpecialChar1'::text))
  • Rows Removed by Filter: 202454
4. 0.033 0.235 ↓ 1.3 204 1

Hash (cost=119.97..119.97 rows=158 width=45) (actual time=0.235..0.235 rows=204 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 24kB
5. 0.202 0.202 ↓ 1.3 204 1

Index Scan using time_started_idx on incident_resolution ir (cost=0.42..119.97 rows=158 width=45) (actual time=0.036..0.202 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.565 ms