| GroupAggregate (cost=598.69..601.25 rows=142 width=12) |
| Group Key: project_id |
| -> Sort (cost=598.69..599.07 rows=152 width=8) |
| Sort Key: project_id |
| -> Bitmap Heap Scan on tbl_work_logs (cost=148.84..593.18 rows=152 width=8) |
| 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) |
| -> 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[])) |