Sort (cost=51.97..52.00 rows=11 width=21) |
Sort Key: tbl_project_architects.contribution DESC, tbl_project_architects.engineer_id |
-> Hash Left Join (cost=9.13..51.78 rows=11 width=21) |
Hash Cond: (tbl_project_architects.engineer_id = u.id) |
-> Seq Scan on tbl_project_architects (cost=0.00..42.62 rows=11 width=12) |
Filter: (project_id = ANY ('{3815,3786,3805,1018,3811,3404,1111,3814,3804,3800}'::integer[])) |
-> Hash (cost=7.39..7.39 rows=139 width=13) |
-> Seq Scan on tbl_users u (cost=0.00..7.39 rows=139 width=13) |