explain.depesz.com

PostgreSQL's explain analyze made readable

Result: k2CV : Optimization for: plan #8Oxg

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.013 19.608 ↑ 1.0 10 1

Limit (cost=52.11..77.88 rows=10 width=109) (actual time=13.665..19.608 rows=10 loops=1)

2. 19.595 19.595 ↑ 2,968.5 30 1

Index Scan using index_balance_operations_on_user_id_and_operation_type on balance_operations (cost=0.57..229,506.25 rows=89,055 width=109) (actual time=2.666..19.595 rows=30 loops=1)

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