QUERY PLAN
Aggregate (cost=387.20..387.21 rows=1 width=8)
-> Group (cost=387.18..387.19 rows=1 width=479)
Group Key: s.id
-> Sort (cost=387.18..387.18 rows=1 width=4)
Sort Key: s.id
-> Hash Right Join (cost=374.48..387.17 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=374.47..374.47 rows=1 width=12)
-> Bitmap Heap Scan on tbl_schedules s (cost=6.03..374.47 rows=1 width=12)
Recheck Cond: (client_id = 149)
Filter: (set_top_at IS NOT NULL)
-> Bitmap Index Scan on tbl_schedules_client_id_idx (cost=0.00..6.03 rows=232 width=0)
Index Cond: (client_id = 149)