explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CAeq

Settings
# exclusive inclusive rows x rows loops node
1. 120.672 1,158.811 ↑ 1.0 247,302 1

Gather (cost=1,000.44..551,272.44 rows=247,302 width=826) (actual time=4.011..1,158.811 rows=247,302 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 108.163 1,038.139 ↑ 1.2 82,434 3 / 3

Nested Loop (cost=0.44..525,542.24 rows=103,042 width=826) (actual time=0.170..1,038.139 rows=82,434 loops=3)

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

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

4. 906.774 906.774 ↑ 1.0 1 247,302 / 3

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

  • Index Cond: (id = cv.screening_ronde)
Planning time : 5.096 ms
Execution time : 1,184.310 ms