News for hackers. Stuff that matters.

A comment on EventReduce: An algorithm to optimize database queries that run multiple times. Parent comment

Re:EventReduce: An algorithm to optimize database queries th... by theandrewbailey on Thursday April 16, 2020 @10:45AM (#22889877)
> Databases like PostgreSQL don't offer insights into the query plans

How so?

https://www.postgresql.org/docs/current/sql-explain.html

https://stackoverflow.com/questions/7359702/how-do-i-obtain-...

https://mariadb.com/kb/en/analyze-statement/

https://docs.oracle.com/cd/B19306_01/server.102/b14211/ex_pl...

[ Parent | on HN ]
Re:EventReduce: An algorithm to optimize database queries th... by LunaSea on Thursday April 16, 2020 @10:56AM (#22889995)
This 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.

[ Parent | on HN ]