explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3rey : Optimization for: Optimization for: plan #8Oxg; plan #Pvd4

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.003 0.038 ↑ 1.0 10 1

Limit (cost=2.38..4.34 rows=10 width=121) (actual time=0.032..0.038 rows=10 loops=1)

2. 0.035 0.035 ↑ 4,105.4 20 1

Index Scan Backward using index_balance_operations_on_user_id_and_created_at on balance_operations (cost=0.42..16,068.63 rows=82,108 width=121) (actual time=0.025..0.035 rows=20 loops=1)

  • Index Cond: (user_id = 4,560,461)
Planning time : 0.136 ms
Execution time : 0.061 ms