explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Qz1

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

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

2. 53.022 1,420.753 ↓ 1.5 3 1

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

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.223 1,367.731 ↑ 1.0 1 3 / 3

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

4. 109.298 1,367.508 ↑ 429.9 381 3 / 3

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

5. 63.949 63.949 ↑ 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.113..63.949 rows=132,696 loops=3)

  • Filter: (ingevoerd_op IS NOT NULL)
  • Rows Removed by Filter: 13452
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.689 ms
Execution time : 1,420.856 ms