Strange execution plan

2021-07-08 Thread Joel Frid
Hi, On my production environment (PostgreSQL 13.3), one of my queries runs very slow, about 2 minutes. I noticed that it does not use an execution plan that I anticapited it would. The query is : SELECT t.* FROM test t  WHERE  t."existe" IS true and  t.json_data" @> '{"book":{"title"

Strange execution plan

2021-07-08 Thread Joel Frid
Hi, On my production environment (PostgreSQL 13.3), one of my queries runs very slow, about 2 minutes. I noticed that it does not use an execution plan that I anticapited it would. The query is : SELECT t.* FROM test t  WHERE  t."existe" IS true and  t.json_data" @> '{"book":{"title"