| GroupAggregate (cost=30.92..31.05 rows=4 width=44) |
| Group Key: (CASE WHEN ((p.project_status = 3) AND (p.budget <= p.collected)) THEN '-1'::integer WHEN ((p.project_status = 3) AND (p.budget > p.collected)) THEN 3 ELSE p.project_status END) |
| -> Sort (cost=30.92..30.93 rows=4 width=9) |
| Sort Key: (CASE WHEN ((p.project_status = 3) AND (p.budget <= p.collected)) THEN '-1'::integer WHEN ((p.project_status = 3) AND (p.budget > p.collected)) THEN 3 ELSE p.project_status END) |
| -> Bitmap Heap Scan on tbl_projects p (cost=4.34..30.88 rows=4 width=9) |
| Recheck Cond: (client_id = 982) |
| Filter: (project_status <> 3) |
| -> Bitmap Index Scan on tbl_projects_client_id_idx (cost=0.00..4.34 rows=8 width=0) |
| Index Cond: (client_id = 982) |