explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lRDW

Settings
# exclusive inclusive rows x rows loops node
1. 466.133 1,163.729 ↓ 1.1 99,996 1

GroupAggregate (cost=0.42..65,105.00 rows=91,664 width=44) (actual time=0.196..1,163.729 rows=99,996 loops=1)

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

Index Scan using sale_idx on sale s (cost=0.42..51,459.20 rows=1,000,000 width=13) (actual time=0.131..697.596 rows=1,000,000 loops=1)