List Question
20 TechQA 2024-03-21T18:02:34.263000How can I tell the SQL planner that a WHERE condition in the main query should be executed in the subqueries?
64 views
Asked by Jorge Domínguez Arnáez
Postgres Query Planner expects 1 row for a join doing a Nested Loop Join
32 views
Asked by Mcscrag
Vastly different query performance on GIN indexed table using different search words
86 views
Asked by Stefan FPF
Postgres order of execution in query that computes a function and locks rows
102 views
Asked by Andrew
bad performance of postgres query if on-clause of inner-join is positioned after following left-joins
64 views
Asked by J. Dieckmann
How can I update the statistics of a table in cockroachdb
118 views
Asked by alyshan
PostgreSQL Index Not Utilized for JSONB Field Filtering on Non-Equality: What Am I Missing?
95 views
Asked by Viktor Egorov
Why does varchar(max) column in concat function cause query plan to blow up
71 views
Asked by Adam
postgres LIKE % operator vs similarity - pg_trgm.similarity_threshold . different query plans
255 views
Asked by Vertago
Xmin queries in Postgres not using parallel sequential scans
86 views
Asked by Dev K
Query with identical query plan but different limits have vastly different execution times
35 views
Asked by thebenman
Why does PostgreSQL not use the index in this scenario?
78 views
Asked by M Somerville
Where condition dramatically reduces performance unexpectedly
83 views
Asked by Fernando Rojo
MySQL. Help me understand the following execution plan
64 views
Asked by ShrihariShetty
Getting Index Scan instead Index Seeking if IN clause larger in Azure Sql
283 views
Asked by SUVAM ROY
Postgres Query uses Bitmap index scan on GIN indexed item. Does not GIN use B-Tree internally?
508 views
Asked by samshers
Correct planner estimate of 1:1 join without FK or left join
237 views
Asked by Peter
PostgreSQL Query Planner/Optimizer: Is there a way to get candidate plans?
390 views
Asked by Ymi