I am using Entity Framework 6 code first and Postgresql database, I came across that EF generates unnecessarily complex query that runs few seconds, but can be optimized to few miliseconds.