explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YoKJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 1,052.081 ↑ 1.0 1 1

Finalize Aggregate (cost=526,800.06..526,800.07 rows=1 width=8) (actual time=1,052.081..1,052.081 rows=1 loops=1)

2. 41.120 1,079.696 ↓ 1.5 3 1

Gather (cost=526,799.84..526,800.05 rows=2 width=8) (actual time=1,051.755..1,079.696 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 19.114 1,038.576 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=525,799.84..525,799.85 rows=1 width=8) (actual time=1,038.576..1,038.576 rows=1 loops=3)

4. 84.790 1,019.462 ↑ 1.2 82,434 3 / 3

Nested Loop (cost=0.44..525,542.24 rows=103,042 width=0) (actual time=0.156..1,019.462 rows=82,434 loops=3)

5. 27.898 27.898 ↑ 1.2 82,434 3 / 3

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

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

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

  • Index Cond: (id = cv.screening_ronde)
  • Heap Fetches: 247302
Planning time : 0.710 ms
Execution time : 1,079.789 ms