Explain analyze

Martin Kersten martin.kersten at cwi.nl
Sat Apr 30 14:18:37 CEST 2016


See the documentation:https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/QueryTiming

MonetDB does not contain a cost-based optimizer as you find in other systems.

You can use both 'EXPLAIN SELECT....' and 'TRACE SELECT ....' to get insight into
the expensive components.

On 30/04/16 12:41, Shmagi Kavtaradze wrote:
> In postgres I could use explain analyze to see actions performed by database and their cost. I was not able to run explain analyze. I ran EXPLAIN, but can not see any plan or cost. Any ideas how to get costs and query plan like in Postgres?
>
>
> _______________________________________________
> users-list mailing list
> users-list at monetdb.org
> https://www.monetdb.org/mailman/listinfo/users-list
>



More information about the users-list mailing list