>
>
> Here B is a ltree column, E is a jsonb column.
>
It may also help to mention the indexes and their types. eg. Does column B
have a GiST index?
>
> EXPLAIN ANALYZE SELECT * FROM A
>
> where ( B <@ 'INDIA' ) AND C = 'D'
>
> AND CAST ( E->'F'->'G'->>'H' AS DATE ) >= '2021-02-01'
>
> AND CA
Hi Team,
I am trying to execute the below query and getting below explain plan in
postgres .
Please provide any inputs on the same , on how to optimize the same.
Here B is a ltree column, E is a jsonb column.
EXPLAIN ANALYZE SELECT * FROM A
where ( B <@ 'INDIA' ) AND C = 'D'
AND CAST ( E->'F'
