explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ezrR

Settings
# exclusive inclusive rows x rows loops node
1. 47.256 1,147.574 ↑ 270.4 907 1

Gather (cost=1,000.44..552,613.67 rows=245,258 width=826) (actual time=3.351..1,147.574 rows=907 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 62.401 1,100.318 ↑ 338.4 302 3 / 3

Nested Loop (cost=0.44..527,087.87 rows=102,191 width=826) (actual time=648.551..1,100.318 rows=302 loops=3)

3. 48.729 48.729 ↑ 1.3 82,432 3 / 3

Parallel Seq Scan on cda_verslag pa (cost=0.00..5,343.03 rows=103,042 width=621) (actual time=0.038..48.729 rows=82,432 loops=3)

  • Filter: ((status)::text = 'AFGEROND'::text)
  • Rows Removed by Filter: 2
4. 989.188 989.188 ↓ 0.0 0 247,297 / 3

Index Scan using screening_ronde_pkey on screening_ronde par (cost=0.44..5.05 rows=1 width=205) (actual time=0.012..0.012 rows=0 loops=247,297)

  • Index Cond: (id = pa.screening_ronde)
  • Filter: ((follow_up_conclusie_status_gewijzigd_op IS NULL) OR (follow_up_conclusie_status_gewijzigd_op < pa.datum_verwerkt))
  • Rows Removed by Filter: 1
Planning time : 0.991 ms
Execution time : 1,147.865 ms