explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5PKe

Settings
# exclusive inclusive rows x rows loops node
1. 43.141 1,112.726 ↑ 268.4 910 1

Gather (cost=1,000.44..550,965.74 rows=244,235 width=826) (actual time=5.499..1,112.726 rows=910 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 51.719 1,069.585 ↑ 335.9 303 3 / 3

Nested Loop (cost=0.44..525,542.24 rows=101,765 width=826) (actual time=674.875..1,069.585 rows=303 loops=3)

3. 28.658 28.658 ↑ 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.025..28.658 rows=82,434 loops=3)

4. 989.208 989.208 ↓ 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.012..0.012 rows=0 loops=247,302)

  • Index Cond: (id = pa.screening_ronde)
  • Filter: (follow_up_conclusie_status_gewijzigd_op IS NULL)
  • Rows Removed by Filter: 1
Planning time : 0.811 ms
Execution time : 1,113.025 ms