QUERY PLAN
Sort (cost=19.35..19.37 rows=11 width=10)
Sort Key: d."order"
-> Group (cost=19.07..19.16 rows=11 width=10)
Group Key: u.id, d.id
-> Sort (cost=19.07..19.10 rows=11 width=10)
Sort Key: u.id, d.id
-> Hash Left Join (cost=1.20..18.88 rows=11 width=10)
Hash Cond: (u.department_id = d.id)
-> Seq Scan on tbl_users u (cost=0.00..17.64 rows=11 width=8)
Filter: ((user_status = '1'::type_global_user_status) AND ((id = ANY ('{1000,1001,1004,1005,1011,1013,1015,1017,1022,1023,5016,5064,5085,5087,5248,5250,5252,5295,5296,5300,5311,5329,5332,5360,5388,5404,5420,5440,5445,5446}'::integer[])) OR (id = ANY ('{5015,5087,5252,5295,5329}'::integer[])) OR (id = ANY ('{5252,1015,1000,5412,5295,1013,5360,5359,5388,5364,5015,5413,1014,5064,5300,5329,1011,5016,1017,1005,1004,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)