Forum: Building VoltDB Applications

Post: Is there any way I can see the result of sql planner?

Is there any way I can see the result of sql planner?
hayatoa
Dec 5, 2011
The following shows the result of the sql planner.

http://blog.voltdb.com/optimizing-distributed-read-operations-voltdb/


Is there any way, I can see such output like below to understand how sql is processed and also to understand how voltdb is processing data?

RETURN RESULTS TO STORED PROCEDURE
ORDER BY (SORT)
AGGREGATION ops: sum
RECEIVE FROM ALL PARTITIONS
SEND PARTITION RESULTS TO COORDINATOR
AGGREGATION ops: count
SEQUENTIAL SCAN of "VOTES"
VoltDB Explain Plans
rbetts
Dec 6, 2011
Those plans are produced by VoltCompiler when it processes your project.xml and stored procedure class files. It writes the explain plan for each processed SQL statement to debugoutput/statement-winner-plans in a file named liked:
(Procedure)-(statement).txt

cd examples/voter
./run.sh catalog
ls debugoutput/statement-winner-plans
Hello, How to read and use
ajgent
Dec 6, 2011
Hello,
How to read and use the SQL plans is one of the topics covered in a new performance guide that will be released later this month. I am attaching a draft of the chapter on execution plans to this note. Let us know if this provides the information you need.
Best,


---Andrew
attach17


Evaluating the table order for joins
hayatoa
Dec 7, 2011
Hello,
How to read and use the SQL plans is one of the topics covered in a new performance guide that will be released later this month..


Thank you, Andrew!!

This document is essential for improving tuning database.

"3.3.2. Evaluating the Table Order for Joins" describes we can manually set the order of tables to look.

Is this feature available in voltdb 2.1.2 ?
Yes. The ability to specify
ajgent
Dec 7, 2011
Thank you, Andrew!!

This document is essential for improving tuning database.

"3.3.2. Evaluating the Table Order for Joins" describes we can manually set the order of tables to look.

Is this feature available in voltdb 2.1.2 ?


Yes. The ability to specify the join order was added in V1.3.

--Andrew