explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Iiye

Settings
# exclusive inclusive rows x rows loops node
1. 282.714 1,356.907 ↓ 1.1 99,996 1

Finalize GroupAggregate (cost=57,552.00..89,087.49 rows=91,664 width=44) (actual time=421.123..1,356.907 rows=99,996 loops=1)

  • Group Key: customer_id
2. 0.000 1,074.193 ↓ 1.6 287,812 1

Gather Merge (cost=57,552.00..86,108.41 rows=183,328 width=44) (actual time=421.095..1,074.193 rows=287,812 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 894.786 2,177.022 ↓ 1.0 95,937 3

Partial GroupAggregate (cost=56,551.98..63,947.78 rows=91,664 width=44) (actual time=349.109..725.674 rows=95,937 loops=3)

  • Group Key: customer_id
4. 1,049.487 1,282.236 ↑ 1.3 333,333 3

Sort (cost=56,551.98..57,593.65 rows=416,667 width=13) (actual time=349.060..427.412 rows=333,333 loops=3)

  • Sort Key: customer_id
  • Sort Method: external merge Disk: 9224kB
  • Worker 0: Sort Method: external merge Disk: 6344kB
  • Worker 1: Sort Method: external merge Disk: 7040kB
5. 232.749 232.749 ↑ 1.3 333,333 3

Parallel Seq Scan on sale s (cost=0.00..10,536.67 rows=416,667 width=13) (actual time=0.024..77.583 rows=333,333 loops=3)