explain.depesz.com

PostgreSQL's explain analyze made readable

Result: u3xE

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 175,736.598 ↓ 0.0 1 1

Finalize Aggregate (cost=0..0 rows=0 width=0) (actual time=175,736.597..175,736.598 rows=1 loops=1)

  • Buffers: shared hit=65,128 read=1,363,444 dirtied=1,238,961 written=1,220,075
2. 590.041 175,752.829 ↓ 0.0 8 1

Gather (cost=0..0 rows=0 width=0) (actual time=175,427.216..175,752.829 rows=8 loops=1)

  • Workers Planned: 7
  • Workers Launched: 7
  • Buffers: shared hit=65,128 read=1,363,444 dirtied=1,238,961 written=1,220,075
3. 366.577 175,162.788 ↓ 0.0 1 8 / 8

Partial Aggregate (cost=0..0 rows=0 width=0) (actual time=175,162.788..175,162.788 rows=1 loops=8)

  • Buffers: shared hit=65,128 read=1,363,444 dirtied=1,238,961 written=1,220,075
4. 174,796.211 174,796.211 ↓ 0.0 1,250,000 8 / 8

Parallel Seq Scan on t2 (cost=0..0 rows=0 width=0) (actual time=4.712..174,796.211 rows=1,250,000 loops=8)

  • Buffers: shared hit=65,128 read=1,363,444 dirtied=1,238,961 written=1,220,075