explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0ph5Y

Settings
# exclusive inclusive rows x rows loops node
1. 0.163 25,485.061 ↑ 1.0 1 1

Aggregate (cost=46,953.57..46,953.58 rows=1 width=152) (actual time=25,485.061..25,485.061 rows=1 loops=1)

2. 215.521 25,484.898 ↓ 12.0 12 1

Nested Loop (cost=0.00..46,953.53 rows=1 width=81) (actual time=1,214.689..25,484.898 rows=12 loops=1)

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

Seq Scan on incident_resolution ir (cost=0.00..12,287.47 rows=1 width=102) (actual time=25.958..46.817 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,222.560 25,222.560 ↓ 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..123.640 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.237 ms