QUERY PLAN
Hash Left Join (cost=2342.77..2677.89 rows=163 width=52)
Hash Cond: (ca.engineer_id = egr.engineer_id)
-> Hash Join (cost=2341.16..2674.04 rows=163 width=52)
Hash Cond: (c.id = ca.case_id)
-> Seq Scan on tbl_cases c (cost=0.00..288.43 rows=6852 width=4)
Filter: (case_type = 2)
-> Hash (cost=2338.62..2338.62 rows=203 width=52)
-> Seq Scan on tbl_case_assignments ca (cost=0.00..2338.62 rows=203 width=52)
Filter: (case_id = ANY ('{5020,4814,4815,4660,5040,5125,5224,5028,4786,4690,4787,4788,4789,3414,3475,3498,3517,3528,5134,2093,2198,2170,2187,1769,2370,4379,1992,2094,2199,2305,1993,1999,2095,2134,2164,2200,2306,1761,2046,2096,2126,2135,2165,4395,2012,2057,2114,2217,2229,2202,2308,2451,2218,2175,2230,2167,2514,1968,2129,2099,2152,2281,2433,2050,2153,2100,2139,2232,2169,2205,2220,2323,1766,1814,2101,2233,2221,2206,2273,2324,2586,1733,1786,2052,2141,2119,2196,1868,2007,2142,2156,2285,2314,2589,1840,2143,2366,2539,2144,2367,2540,2576,2211,2184,2160,2212,2042,2161,2186,2263,1951,2564,2446,2565,2547,2567,96,4156,145,254,906,938,940,990,4170,4124,1359,1406,1492,1531,1532,1555,1571,1652,1687,1690,1692,1718,2605,2876,3121,4101,3317,3329,3324,3405,3417,3419,3404,3420,3418,3616,3619,3841,3945,3985,4564,4559,4565,5285,5266,5275,5273,5274,5368,5488,5471,5593,5915,6065,6187,6424,6471,6616,6675,6644,6717,6854,6822,6867,6977,6978,7036,7157,7284,7453,7667,7974,7972,8023,8057,8031,8032,8217,8408,8389,8546,8655,8638,8700,9051,9158}'::integer[]))
-> Hash (cost=1.27..1.27 rows=27 width=4)
-> Seq Scan on tbl_engineer_group_relationships egr (cost=0.00..1.27 rows=27 width=4)