Aggregate (cost=15.59..15.60 rows=1 width=8) |
-> Bitmap Heap Scan on member_balance_history (cost=14.57..15.59 rows=1 width=0) |
Recheck Cond: (((member_id)::text = '1f05e3b5-5aee-6d5a-8f45-5e1409fc0711'::text) AND ("time" >= '2025-07-04 00:00:00'::timestamp without time zone) AND ("time" <= '2025-07-11 23:59:59'::timestamp without time zone)) |
-> BitmapAnd (cost=14.57..14.57 rows=1 width=0) |
-> Bitmap Index Scan on member_balance_history_member_id_index (cost=0.00..5.10 rows=490 width=0) |
Index Cond: ((member_id)::text = '1f05e3b5-5aee-6d5a-8f45-5e1409fc0711'::text) |
-> Bitmap Index Scan on member_balance_history_time_type_index (cost=0.00..9.22 rows=579 width=0) |
Index Cond: (("time" >= '2025-07-04 00:00:00'::timestamp without time zone) AND ("time" <= '2025-07-11 23:59:59'::timestamp without time zone)) |