explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xj0j

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=39,705,889.88..39,705,889.89 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=39,705,889.88..39,757,103.01 rows=20,485,249 width=8) (actual rows= loops=)

  • Sort Key: (count(*))
3. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=37,350,086.27..39,603,463.64 rows=20,485,249 width=8) (actual rows= loops=)

  • Group Key: member_id, entitlement_id
4. 0.000 0.000 ↓ 0.0

Sort (cost=37,350,086.27..37,862,217.49 rows=204,852,488 width=8) (actual rows= loops=)

  • Sort Key: member_id, entitlement_id
5. 0.000 0.000 ↓ 0.0

Seq Scan on content_download (cost=0.00..5,869,365.88 rows=204,852,488 width=8) (actual rows= loops=)