On Thu, 16 Jan 2020 at 20:20, Laurenz Albe <laurenz.albe@xxxxxxxxxxx> 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
