explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lNYj

Settings
# exclusive inclusive rows x rows loops node
1. 0.050 131.598 ↑ 1.0 1 1

Aggregate (cost=34,746.60..34,746.61 rows=1 width=152) (actual time=131.598..131.598 rows=1 loops=1)

2. 1.438 131.548 ↓ 3.0 12 1

Hash Join (cost=107.80..34,746.46 rows=4 width=81) (actual time=45.016..131.548 rows=12 loops=1)

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

Seq Scan on incident i (cost=0.00..34,613.14 rows=6,793 width=53) (actual time=0.046..129.922 rows=8,299 loops=1)

  • Filter: (((status)::text = 'COMPLETED'::text) AND ((type)::text = 'RR_TEST_AUTOMATION.HTTP_RRTESTAUTOMATION_RRHTTPFieldNameWithSpecialChar1'::text))
  • Rows Removed by Filter: 202534
4. 0.035 0.188 ↓ 1.5 204 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 36kB
5. 0.153 0.153 ↓ 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.013..0.153 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.363 ms