Sort (cost=52.73..52.75 rows=10 width=21) |
Sort Key: tbl_project_architects.contribution DESC, tbl_project_architects.engineer_id |
-> Hash Left Join (cost=9.17..52.56 rows=10 width=21) |
Hash Cond: (tbl_project_architects.engineer_id = u.id) |
-> Seq Scan on tbl_project_architects (cost=0.00..43.36 rows=10 width=12) |
Filter: (project_id = ANY ('{3837,3895,3820,3867,3933,3932,3936,3908,3907,3818}'::integer[])) |
-> Hash (cost=7.41..7.41 rows=141 width=13) |
-> Seq Scan on tbl_users u (cost=0.00..7.41 rows=141 width=13) |