explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TQK5

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

Finalize Aggregate (cost=712,215.45..712,215.46 rows=1 width=8) (actual time=1,267.321..1,267.321 rows=1 loops=1)

2. 47.383 1,304.416 ↓ 1.5 3 1

Gather (cost=712,215.23..712,215.44 rows=2 width=8) (actual time=1,267.171..1,304.416 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.211 1,257.033 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=711,215.23..711,215.24 rows=1 width=8) (actual time=1,257.033..1,257.033 rows=1 loops=3)

4. 4.382 1,256.822 ↑ 429.9 381 3 / 3

Nested Loop (cost=0.44..710,805.72 rows=163,803 width=0) (actual time=6.712..1,256.822 rows=381 loops=3)

5. 58.179 58.179 ↑ 1.2 132,696 3 / 3

Parallel Seq Scan on follow_up_radiologieverslag rv (cost=0.00..8,647.85 rows=165,860 width=8) (actual time=0.133..58.179 rows=132,696 loops=3)

  • Filter: (ingevoerd_op IS NOT NULL)
  • Rows Removed by Filter: 13,452
6. 1,194.261 1,194.261 ↓ 0.0 0 398,087 / 3

Index Scan using screening_ronde_pkey on screening_ronde r (cost=0.44..4.23 rows=1 width=8) (actual time=0.009..0.009 rows=0 loops=398,087)

  • Index Cond: (id = rv.screening_ronde)
  • Filter: (follow_up_conclusie_status IS NULL)
  • Rows Removed by Filter: 1
Planning time : 0.569 ms
Execution time : 1,304.501 ms