On Thu, 16 Jan 2020 at 20:20, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> wrote:
> Well, what should the poor thing do?
> There is no index on "LucrareBugetDateId".
>
I did add an index on "LucrareBugetDateId" (before accidentally "fixing"
the problem with ANALYZE) and it didn't help.
> Rather, you have two indexes on ("LucrareBugetVersiuneId",
> "LucrareBugetDateId"),
> one of which should be dropped.
>
One will be dropped. The second one was added out of desperation (because
it wasn't using the first one).
> Try with an index on "LucrareBugetDateId".
>
> Yours,
> Laurenz Albe
> --
> Cybertec | https://www.cybertec-postgresql.com
>
>