explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Pvd4 : Optimization for: plan #8Oxg

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.004 0.021 ↑ 1.0 10 1

Limit (cost=0.42..3.35 rows=10 width=121) (actual time=0.013..0.021 rows=10 loops=1)

2. 0.017 0.017 ↑ 8,213.0 10 1

Index Scan Backward using index_balance_operations_on_created_at on balance_operations (cost=0.42..24,061.80 rows=82,130 width=121) (actual time=0.012..0.017 rows=10 loops=1)

  • Filter: (user_id = 4,560,461)
Planning time : 0.123 ms
Execution time : 0.042 ms