QUERY PLAN
Aggregate (cost=35.63..35.64 rows=1 width=8)
-> Group (cost=35.54..35.57 rows=5 width=479)
Group Key: s.id
-> Sort (cost=35.54..35.55 rows=5 width=4)
Sort Key: s.id
-> Hash Right Join (cost=22.80..35.48 rows=5 width=4)
Hash Cond: (ccr.schedule_id = s.id)
-> Seq Scan on tbl_schedule_carbon_copy_rels ccr (cost=0.00..10.88 rows=688 width=4)
-> Hash (cost=22.74..22.74 rows=5 width=12)
-> Bitmap Heap Scan on tbl_schedules s (cost=4.32..22.74 rows=5 width=12)
Recheck Cond: (client_id = 1956)
Filter: ((set_top_at IS NULL) AND is_complete)
-> Bitmap Index Scan on tbl_schedules_client_id_idx (cost=0.00..4.32 rows=5 width=0)
Index Cond: (client_id = 1956)