explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XLqF

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

Finalize Aggregate (cost=10,062.72..10,062.73 rows=1 width=8) (actual time=115.725..115.725 rows=1 loops=1)

2. 17.650 120.563 ↓ 1.5 3 1

Gather (cost=10,062.50..10,062.71 rows=2 width=8) (actual time=115.434..120.563 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 27.222 102.913 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=9,062.50..9,062.51 rows=1 width=8) (actual time=102.912..102.913 rows=1 loops=3)

4. 75.691 75.691 ↑ 1.2 132,696 3 / 3

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

  • Filter: (ingevoerd_op IS NOT NULL)
  • Rows Removed by Filter: 13452
Planning time : 0.116 ms
Execution time : 120.655 ms