explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8Oxg

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.009 19,817.404 ↑ 1.0 10 1

Limit (cost=0.57..957.02 rows=10 width=129) (actual time=1.191..19,817.404 rows=10 loops=1)

2. 19,817.395 19,817.395 ↑ 7,607.8 10 1

Index Scan Backward using index_balance_operations_on_created_at on balance_operations (cost=0.57..7,276,463.08 rows=76,078 width=129) (actual time=1.190..19,817.395 rows=10 loops=1)

  • Filter: (user_id = 4,560,461)
  • Rows Removed by Filter: 4,805,875
Planning time : 0.124 ms
Execution time : 19,817.438 ms