explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Udf

Settings
# exclusive inclusive rows x rows loops node
1. 9.762 11.960 ↓ 31.8 6,353 1

HashAggregate (cost=218.08..220.58 rows=200 width=44) (actual time=9.703..11.960 rows=6,353 loops=1)

  • Group Key: customer_id
2. 2.198 2.198 ↓ 1.5 10,000 1

Seq Scan on sale s (cost=0.00..132.48 rows=6,848 width=40) (actual time=0.047..2.198 rows=10,000 loops=1)