explain.depesz.com

PostgreSQL's explain analyze made readable

Result: svcK

Settings
# exclusive inclusive rows x rows loops node
1. 0.064 26,224.450 ↑ 1.0 1 1

Aggregate (cost=46,946.39..46,946.40 rows=1 width=64) (actual time=26,224.450..26,224.450 rows=1 loops=1)

2. 234.442 26,224.386 ↓ 12.0 12 1

Nested Loop (cost=0.00..46,946.37 rows=1 width=24) (actual time=1,184.744..26,224.386 rows=12 loops=1)

  • Join Filter: ((i.incident_id)::text = (ir.incident_id)::text)
  • Rows Removed by Join Filter: 1691964
3. 44.816 44.816 ↓ 204.0 204 1

Seq Scan on incident_resolution ir (cost=0.00..12,297.95 rows=1 width=45) (actual time=23.704..44.816 rows=204 loops=1)

  • Filter: ((time_started > '1565589600000'::bigint) AND (time_started < '1565596800000'::bigint) AND (time_completed < '1565596800000'::bigint) AND (time_started <> 0) AND (time_completed <> 0))
  • Rows Removed by Filter: 210839
4. 25,945.128 25,945.128 ↓ 1.2 8,294 204

Seq Scan on incident i (cost=0.00..34,564.04 rows=6,750 width=53) (actual time=0.034..127.182 rows=8,294 loops=204)

  • Filter: (((status)::text = 'COMPLETED'::text) AND ((type)::text = 'RR_TEST_AUTOMATION.HTTP_RRTESTAUTOMATION_RRHTTPFieldNameWithSpecialChar1'::text))
  • Rows Removed by Filter: 202454
Planning time : 0.184 ms