A slow EF Core query on Postgres was made much faster by filtering rows, reducing JOINs, picking only needed columns, and cutting requests. Other steps included avoiding too many sub queries and measuring before making changes.