| GroupAggregate (cost=593.60..593.77 rows=6 width=20) |
| Group Key: project_id |
| -> Sort (cost=593.60..593.62 rows=6 width=24) |
| Sort Key: project_id |
| -> Bitmap Heap Scan on tbl_work_logs (cost=148.80..593.52 rows=6 width=24) |
| Recheck Cond: (project_id = ANY ('{4024,4005,4149,4136,4133,4184,4182,4165,4163,4147,4134,4131,4125,4109,4088,4083,3976,3778,4183,4181,4146,3957,3854,3796,4177,4174,4173,4162,4148,4143,4097,4082,4060,4034,4002,3981,4172,4171,4170,4169}'::integer[])) |
| Filter: ((NOT is_draft) AND (scenario_id = 2)) |
| -> Bitmap Index Scan on tbl_work_logs_project_id_idx (cost=0.00..148.80 rows=152 width=0) |
| Index Cond: (project_id = ANY ('{4024,4005,4149,4136,4133,4184,4182,4165,4163,4147,4134,4131,4125,4109,4088,4083,3976,3778,4183,4181,4146,3957,3854,3796,4177,4174,4173,4162,4148,4143,4097,4082,4060,4034,4002,3981,4172,4171,4170,4169}'::integer[])) |