QUERY PLAN
GroupAggregate (cost=298.34..298.37 rows=1 width=20)
Group Key: project_id
-> Sort (cost=298.34..298.35 rows=1 width=24)
Sort Key: project_id
-> Bitmap Heap Scan on tbl_work_logs (cost=82.25..298.33 rows=1 width=24)
Recheck Cond: (project_id = ANY ('{3870,3901,3927,3857,3959,3950,3796,3854,3878,3880,3955,3957,3947,3874,3934,3945,3780,3833,3846,3758}'::integer[]))
Filter: ((NOT is_draft) AND (location_in_id IS NOT NULL) AND (location_out_id IS NOT NULL) AND (client_id IS NOT NULL) AND (scenario_id = 1))
-> Bitmap Index Scan on tbl_work_logs_project_id_idx (cost=0.00..82.25 rows=65 width=0)
Index Cond: (project_id = ANY ('{3870,3901,3927,3857,3959,3950,3796,3854,3878,3880,3955,3957,3947,3874,3934,3945,3780,3833,3846,3758}'::integer[]))