3 ms·
> Databases like PostgreSQL don't offer insights into the query plans How so? https://www.postgresql.org/docs/current/sql-explain.html https://www.postgresql.
by theandrewbailey 7y ago
> Databases like PostgreSQL don't offer insights into the query plans
How so?
https://www.postgresql.org/docs/current/sql-explain.html https://www.postgresql.org/docs/current/sql-explain.html
https://stackoverflow.com/questions/7359702/how-do-i-obtain-a-query-execution-plan-in-sql-server https://stackoverflow.com/questions/7359702/how-do-i-obtain-...
https://mariadb.com/kb/en/analyze-statement/ https://mariadb.com/kb/en/analyze-statement/
https://docs.oracle.com/cd/B19306_01/server.102/b14211/ex_plan.htm https://docs.oracle.com/cd/B19306_01/server.102/b14211/ex_pl...
- LunaSea 7y agoThis is only for queries where you explicitly want the query plan. However, your query won't return the query results. And regular PostgreSQL queries don't let you return the query plan they used on top the query results.