I have a 12.11 postgresql database on Linux. When I ran the below query, the query planner uses the gist index. However, the query runs faster if I drop the gist index, because the query planner uses the b-tree index. Why does the query planner use the gist index instead of the b-tree?
Please show the definition of both indexes. Also, eliminate the joins and where clause conditions which are not needed to reproduce the base problem, then show the full plans, not just one line.