explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.007 0.031 ↑ 1.0 1 1

Aggregate (cost=23.70..23.71 rows=1 width=32) (actual time=0.031..0.031 rows=1 loops=1)

2. 0.004 0.024 ↑ 2.5 2 1

Bitmap Heap Scan on balance_operations (cost=4.47..23.69 rows=5 width=5) (actual time=0.023..0.024 rows=2 loops=1)

  • Recheck Cond: ((user_id = 8,061,353) AND (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[])))
  • Heap Blocks: exact=2
3. 0.020 0.020 ↑ 2.5 2 1

Bitmap Index Scan on index_partial_balance_operations_user_id_updated_at (cost=0.00..4.47 rows=5 width=0) (actual time=0.020..0.020 rows=2 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.222 ms
Execution time : 0.071 ms