query-planner

13 Questions
Newest Active Unanswered Frequent
Score
View
Card Compact
Why is there much difference in query plan with union vs "or" operator
user_119326790
•
3
1
104
query-planner postgresql
How do I convince postgres to choose the MUCH more efficient of two nearly identical indexes (6 orders of magnitude more efficient)
user_19243580
•
2
0
47
query-planner query-optimization postgresql sql performance
Why does removing the BINARY function call from my SQL query change the query plan so dramatically?
user_65937890
•
4
1
119
query-planner collation query-optimization mysql sql
How to fix PostgreSQL generic plan estimate for any($1) array parameter?
user_18952070
•
4
1
280
query-planner postgresql-13 sql-execution-plan postgresql
Sequential scan in Postgis reads more than 10x relpages - why?
user_18988020
•
1
0
27
query-planner postgis postgresql
How can I make postgres use this index instead of a sequential scan in an EXISTS query on a large table with all equal foreign key values?
user_158235720
•
3
0
244
query-planner postgresql performance
Why plainning time is doubled when I call IMMUTABLE function with exatly same arguments second time?
user_46320190
•
2
1
36
query-planner query-optimization postgresql
Why optimization is not applied/different index is used?
user_46320190
•
2
2
51
query-planner postgresql-performance postgresql
Why my query is slower when sorting in RAM vs disk in Postgres?
user_102232430
•
2
1
334
query-planner postgresql sql performance
How many disk pages are read by a query in Postgres?
user_18988020
•
2
2
571
query-planner postgresql optimization sql
Hot Questions