explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6Bet : penalty_request_balance_operations

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.174 61.441 ↑ 1.0 1 1

Aggregate (cost=236.68..236.69 rows=1 width=32) (actual time=61.441..61.441 rows=1 loops=1)

2. 61.267 61.267 ↓ 30.3 91 1

Index Scan using index_balance_operations_on_user_id on balance_operations (cost=0.57..236.67 rows=3 width=5) (actual time=0.624..61.267 rows=91 loops=1)

  • Index Cond: (user_id = 8,061,353)
  • Filter: ((updated_at >= '2020-05-30 01:55:17.205453'::timestamp without time zone) AND (operation_type = ANY ('{0,1,3,4,5,6,8,10}'::integer[])))
  • Rows Removed by Filter: 32
Planning time : 0.098 ms
Execution time : 61.465 ms