explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tNo3

Settings
# exclusive inclusive rows x rows loops node
1. 42.872 1,753.030 ↑ 6.6 416 1

Gather (cost=1,000.00..464,451.38 rows=2,744 width=224) (actual time=1,654.149..1,753.030 rows=416 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 1,710.158 1,710.158 ↑ 8.2 139 3 / 3

Parallel Seq Scan on onderzoek o (cost=0.00..463,176.98 rows=1,143 width=224) (actual time=1,649.305..1,710.158 rows=139 loops=3)

  • Filter: (is_doorgevoerd AND ((status)::text = 'ONDERBROKEN'::text))
  • Rows Removed by Filter: 7,837,701
Planning time : 0.109 ms
Execution time : 1,753.121 ms