explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zWp

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

Finalize Aggregate (cost=85,811.74..85,811.75 rows=1 width=8) (actual time=378.316..378.316 rows=1 loops=1)

2. 6.725 381.112 ↓ 1.5 3 1

Gather (cost=85,811.52..85,811.73 rows=2 width=8) (actual time=378.239..381.112 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 374.387 374.387 ↑ 1.0 1 3

Partial Aggregate (cost=84,811.52..84,811.53 rows=1 width=8) (actual time=374.387..374.387 rows=1 loops=3)

  • -> Parallel Seq Scan on t_test (cost=0.00..76073.42 rows=3495242 width=0) (actual time=0.428..224.719 rows=27