Sort (cost=51.94..51.97 rows=10 width=21) |
Sort Key: tbl_project_architects.contribution DESC, tbl_project_architects.engineer_id |
-> Hash Left Join (cost=9.13..51.78 rows=10 width=21) |
Hash Cond: (tbl_project_architects.engineer_id = u.id) |
-> Seq Scan on tbl_project_architects (cost=0.00..42.62 rows=10 width=12) |
Filter: (project_id = ANY ('{3805,3811,3739,3801,3461,3577,3807,3796,3809,3810}'::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) |