explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ozZ6

Settings
# exclusive inclusive rows x rows loops node
1. 9.905 11.419 ↓ 31.8 6,353 1

HashAggregate (cost=289.00..291.50 rows=200 width=44) (actual time=9.211..11.419 rows=6,353 loops=1)

  • Group Key: customer_id
2. 1.514 1.514 ↑ 1.0 10,000 1

Seq Scan on sale s (cost=0.00..164.00 rows=10,000 width=40) (actual time=0.021..1.514 rows=10,000 loops=1)