explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wZlI1

Settings
# exclusive inclusive rows x rows loops node
1. 11.971 15.295 ↑ 1.0 14,389 1

HashAggregate (cost=1,038.54..1,182.43 rows=14,389 width=8) (actual time=12.655..15.295 rows=14,389 loops=1)

  • Group Key: customer_id
2. 3.324 3.324 ↑ 1.0 29,036 1

Seq Scan on subscriptions (cost=0.00..893.36 rows=29,036 width=8) (actual time=0.008..3.324 rows=29,036 loops=1)

Planning time : 0.071 ms
Execution time : 16.165 ms