explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ess6

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

Finalize Aggregate (cost=586,656.04..586,656.05 rows=1 width=8) (actual time=69,646.621..69,646.623 rows=1 loops=1)

  • Functions: 11
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 1.749 ms, Inlining 127.410 ms, Optimization 42.094 ms, Emission 25.166 ms, Total 196.419 ms
2. 51.955 69,648.505 ↓ 1.5 3 1

Gather (cost=586,655.83..586,656.04 rows=2 width=8) (actual time=69,646.604..69,648.505 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 747.984 69,596.550 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=585,655.83..585,655.84 rows=1 width=8) (actual time=69,596.548..69,596.550 rows=1 loops=3)

4. 68,848.566 68,848.566 ↑ 1.3 839,292 3 / 3

Parallel Seq Scan on measurement_data (cost=0.00..582,997.26 rows=1,063,426 width=4) (actual time=0.704..68,848.566 rows=839,292 loops=3)

Planning time : 0.063 ms
Execution time : 69,649.192 ms