explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7muU : Optimization for: plan #cFlH

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.000 4,571.577 ↓ 1.2 5,000,000 1

Gather Merge (cost=550,322.97..1,036,467.94 rows=4,166,666 width=97) (actual time=1,951.726..4,571.577 rows=5,000,000 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 6,019.344 7,063.077 ↑ 1.2 1,666,667 3

Sort (cost=549,322.94..554,531.28 rows=2,083,333 width=97) (actual time=1,930.413..2,354.359 rows=1,666,667 loops=3)

  • Sort Key: abalance
  • Sort Method: external merge Disk: 173976kB
  • Worker 0: Sort Method: external merge Disk: 178328kB
  • Worker 1: Sort Method: external merge Disk: 171456kB
3. 1,043.733 1,043.733 ↑ 1.2 1,666,667 3

Parallel Seq Scan on pgbench_accounts (cost=0.00..102,801.33 rows=2,083,333 width=97) (actual time=0.013..347.911 rows=1,666,667 loops=3)

Planning time : 0.270 ms
Execution time : 5,027.669 ms