explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wXbJ

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

Unique (cost=440,988.89..453,129.95 rows=107 width=38) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=440,988.89..447,059.42 rows=2,428,213 width=38) (actual rows= loops=)

  • Sort Key: account_id, created_at DESC
3. 0.000 0.000 ↓ 0.0

Seq Scan on balances_snapshot (cost=0.00..50,662.13 rows=2,428,213 width=38) (actual rows= loops=)