explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2AFA : Optimization for: Optimization for: penalty_request_balance_operations; plan #6Bet; plan #ygXK

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.024 0.312 ↑ 1.0 1 1

Aggregate (cost=10.28..10.29 rows=1 width=32) (actual time=0.312..0.312 rows=1 loops=1)

2. 0.288 0.288 ↓ 8.3 91 1

Index Scan using index_partial_balance_operations_user_id_updated_at on balance_operations (cost=0.57..10.25 rows=11 width=5) (actual time=0.037..0.288 rows=91 loops=1)

  • Index Cond: ((user_id = 8,061,353) AND (updated_at >= '2020-05-30 01:55:17.205453'::timestamp without time zone))
Planning time : 0.582 ms
Execution time : 0.332 ms