| GroupAggregate (cost=550.97..551.14 rows=6 width=20) |
| Group Key: project_id |
| -> Sort (cost=550.97..550.99 rows=6 width=24) |
| Sort Key: project_id |
| -> Bitmap Heap Scan on tbl_work_logs (cost=148.50..550.90 rows=6 width=24) |
| Recheck Cond: (project_id = ANY ('{4184,4182,4185,4183,4181,4174,4173,4172,4171,4170,4169,4168,4167,4166,4144,4161,4164,4151,4157,4155,4152,4150,4142,4158,4127,4098,4111,4096,4086,4063,4057,4052,3991,4079,4078,4014,3950,3927,3949,3751}'::integer[])) |
| Filter: ((NOT is_draft) AND (scenario_id = 2)) |
| -> Bitmap Index Scan on tbl_work_logs_project_id_idx (cost=0.00..148.50 rows=134 width=0) |
| Index Cond: (project_id = ANY ('{4184,4182,4185,4183,4181,4174,4173,4172,4171,4170,4169,4168,4167,4166,4144,4161,4164,4151,4157,4155,4152,4150,4142,4158,4127,4098,4111,4096,4086,4063,4057,4052,3991,4079,4078,4014,3950,3927,3949,3751}'::integer[])) |