QUERY PLAN
Aggregate (cost=132.52..132.53 rows=1 width=8)
-> Group (cost=132.50..132.51 rows=1 width=479)
Group Key: s.id
-> Sort (cost=132.50..132.51 rows=1 width=4)
Sort Key: s.id
-> Hash Right Join (cost=119.79..132.49 rows=1 width=4)
Hash Cond: (ccr.schedule_id = s.id)
-> Seq Scan on tbl_schedule_carbon_copy_rels ccr (cost=0.00..10.89 rows=689 width=4)
-> Hash (cost=119.78..119.78 rows=1 width=12)
-> Bitmap Heap Scan on tbl_schedules s (cost=4.57..119.78 rows=1 width=12)
Recheck Cond: (client_id = 982)
Filter: (set_top_at IS NOT NULL)
-> Bitmap Index Scan on tbl_schedules_client_id_idx (cost=0.00..4.57 rows=38 width=0)
Index Cond: (client_id = 982)