explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0Cxa

Settings
# exclusive inclusive rows x rows loops node
1. 45.725 1,040.248 ↑ 269.5 910 1

Gather (cost=1,000.44..552,356.06 rows=245,258 width=826) (actual time=3.250..1,040.248 rows=910 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 61.565 994.523 ↑ 337.3 303 3 / 3

Nested Loop (cost=0.44..526,830.26 rows=102,191 width=826) (actual time=315.655..994.523 rows=303 loops=3)

3. 26.184 26.184 ↑ 1.2 82,434 3 / 3

Parallel Seq Scan on cda_verslag pa (cost=0.00..5,085.43 rows=103,042 width=621) (actual time=0.028..26.184 rows=82,434 loops=3)

4. 906.774 906.774 ↓ 0.0 0 247,302 / 3

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

  • 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 : 1.667 ms
Execution time : 1,040.596 ms