explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AXwq

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

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

2. 11.575 1,477.750 ↓ 1.5 3 1

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

  • Workers Planned: 2
  • Workers Launched: 2
3. 1,466.175 1,466.175 ↑ 1.0 1 3

Partial Aggregate (cost=317,649.66..317,649.67 rows=1 width=8) (actual time=1,466.175..1,466.175 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.083..88
  • Heap Fetches: 0