| Sort (cost=11.84..11.87 rows=15 width=10) |
| Sort Key: d."order" |
| -> HashAggregate (cost=11.39..11.54 rows=15 width=10) |
| Group Key: u.id, d.id |
| -> Hash Left Join (cost=1.20..11.32 rows=15 width=10) |
| Hash Cond: (u.department_id = d.id) |
| -> Seq Scan on tbl_users u (cost=0.00..10.05 rows=15 width=8) |
| Filter: (id = ANY ('{1000,5360,5300,1011,5445,1005,1004,5296,1015,5295,1013,5064,5446,1001,5087}'::integer[])) |
| -> Hash (cost=1.09..1.09 rows=9 width=6) |
| -> Seq Scan on tbl_departments d (cost=0.00..1.09 rows=9 width=6) |