QUERY PLAN
Aggregate (cost=35.46..35.47 rows=1 width=8)
-> Group (cost=35.44..35.45 rows=1 width=479)
Group Key: s.id
-> Sort (cost=35.44..35.45 rows=1 width=4)
Sort Key: s.id
-> Hash Right Join (cost=22.75..35.43 rows=1 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.73..22.73 rows=1 width=12)
-> Bitmap Heap Scan on tbl_schedules s (cost=4.32..22.73 rows=1 width=12)
Recheck Cond: (client_id = 1956)
Filter: (set_top_at IS NOT NULL)
-> Bitmap Index Scan on tbl_schedules_client_id_idx (cost=0.00..4.32 rows=5 width=0)
Index Cond: (client_id = 1956)