explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5jnP

Settings
# exclusive inclusive rows x rows loops node
1. 0.061 26,180.728 ↑ 1.0 1 1

Aggregate (cost=46,953.54..46,953.55 rows=1 width=64) (actual time=26,180.728..26,180.728 rows=1 loops=1)

2. 237.491 26,180.667 ↓ 12.0 12 1

Nested Loop (cost=0.00..46,953.53 rows=1 width=24) (actual time=1,299.787..26,180.667 rows=12 loops=1)

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

Seq Scan on incident_resolution ir (cost=0.00..12,287.47 rows=1 width=45) (actual time=24.652..45.580 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,897.596 25,897.596 ↓ 1.2 8,294 204

Seq Scan on incident i (cost=0.00..34,581.22 rows=6,787 width=53) (actual time=0.035..126.949 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.212 ms