explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lvHD

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

Finalize Aggregate (cost=318,649.87..318,649.88 rows=1 width=8) (actual time=870.529..870.529 rows=1 loops=1)

2. 10.363 878.298 ↓ 1.5 3 1

Gather (cost=318,649.66..318,649.87 rows=2 width=8) (actual time=870.458..878.298 rows=3 loops=1)

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

Partial Aggregate (cost=317,649.66..317,649.67 rows=1 width=8) (actual time=867.935..867.935 rows=1 loops=3)

  • -> Parallel Index Only Scan using pgbench_accounts_pkey on pgbench_accounts (cost=0.43..302024.64 rows=6250009 width=0) (actual time=0.046..53
  • Heap Fetches: 0