CVS Check-in: EXPLAIN command

This message was edited 1 time. Last update was at 1 Feb 2010 13:51:02

New SQL command is implemented
EXPLAIN [VERBOSE] <query>
Returns the plan of the <query> as a result set
Only SELECT queries are supported

Sample output:

xtest=> explain verbose select count(*) from mds1 group by col2;
Query Plan
-------------------------------------------------------------------------------------------------

Step: 0
-------
Target: CREATE TABLE "TMPTT24_1" ( "XCOL1" INT, "col2" INT) WITHOUT OIDS
Select: SELECT count(*) AS "XCOL1","mds1"."col2" AS "col2" FROM "mds1" group by "mds1"."col2"

Step: 1
-------
Select: SELECT SUM("XCOL1") AS "EXPRESSION4" FROM "TMPTT24_1" group by "col2"
Drop:
TMPTT24_1

----------------
Execution Plan
----------------

ExecutionStep
-------------
producerCount = 4
consumerCount = 4
isExtraStep = false
isFinalStep = false
destNodeList = 1 2 3 4

aStepDetail
-----------

requestId = 0
StepNo = 1
isProducer = true
isConsumer = true
queryString =
SELECT count (*) as XCOL1,
mds1.col2 as col2
FROM mds1
GROUP by mds1.col2
targetTable = TMPTT24_1
targetSchema = CREATE TABLE "TMPTT24_1" ( "XCOL1" INT, "col2" INT) WITHOUT OIDS
DropList =
destType = DEST_TYPE_HASH
hashColumnPosition = 2
groupHashColumns =
combineOnCoordFirst = false
consumerNodeList = 1 2 3 4

nodeUsageTable
--------------
nodeId = 2
isProducer = true
isConsumer = true
nodeId = 4
isProducer = true
isConsumer = true
nodeId = 1
isProducer = true
isConsumer = true
nodeId = 3
isProducer = true
isConsumer = true

ExecutionStep
-------------
producerCount = 4
consumerCount = 0
isExtraStep = false
isFinalStep = true

aStepDetail
-----------

requestId = 0
StepNo = 2
isProducer = true
isConsumer = false
queryString =
SELECT sum (XCOL1) as EXPRESSION4
FROM TMPTT24_1
GROUP by col2
DropList = TMPTT24_1
destType = DEST_TYPE_COORD_FINAL
combineOnCoordFirst = false
consumerNodeList =

nodeUsageTable
--------------
nodeId = 2
isProducer = true
isConsumer = false
nodeId = 4
isProducer = true
isConsumer = false
nodeId = 1
isProducer = true
isConsumer = false
nodeId = 3
isProducer = true
isConsumer = false
(102 rows)

Files:

Checking in src/com/edb/gridsql/parser/core/visitor/ObjectDepthFirst.java;
/cvsroot/gridsql/apps/gridsql/src/com/edb/gridsql/parser/core/visitor/ObjectDepthFirst.java,v <-- ObjectDepthFirst.java
new revision: 1.15; previous revision: 1.14
done
Checking in src/com/edb/gridsql/parser/core/visitor/ObjectVisitor.java;
/cvsroot/gridsql/apps/gridsql/src/com/edb/gridsql/parser/core/visitor/ObjectVisitor.java,v <-- ObjectVisitor.java
new revision: 1.15; previous revision: 1.14
done
Checking in src/com/edb/gridsql/parser/core/visitor/Visitor.java;
/cvsroot/gridsql/apps/gridsql/src/com/edb/gridsql/parser/core/visitor/Visitor.java,v <-- Visitor.java
new revision: 1.15; previous revision: 1.14
done
Checking in src/com/edb/gridsql/parser/core/visitor/DepthFirstVisitor.java;
/cvsroot/gridsql/apps/gridsql/src/com/edb/gridsql/parser/core/visitor/DepthFirstVisitor.java,v <-- DepthFirstVisitor.java
new revision: 1.16; previous revision: 1.15
done
Checking in src/com/edb/gridsql/engine/ExecutionResult.java;
/cvsroot/gridsql/apps/gridsql/src/com/edb/gridsql/engine/ExecutionResult.java,v <-- ExecutionResult.java
new revision: 1.3; previous revision: 1.2
done
Checking in src/com/edb/gridsql/parser/Parser.java;
/cvsroot/gridsql/apps/gridsql/src/com/edb/gridsql/parser/Parser.java,v <-- Parser.java
new revision: 1.5; previous revision: 1.4
done
RCS file: /cvsroot/gridsql/apps/gridsql/src/com/edb/gridsql/parser/SqlExplain.java,v
done
Checking in src/com/edb/gridsql/parser/SqlExplain.java;
/cvsroot/gridsql/apps/gridsql/src/com/edb/gridsql/parser/SqlExplain.java,v <-- SqlExplain.java
initial revision: 1.1
done
Checking in src/com/edb/gridsql/planner/QueryPlan.java;
/cvsroot/gridsql/apps/gridsql/src/com/edb/gridsql/planner/QueryPlan.java,v <-- QueryPlan.java
new revision: 1.12; previous revision: 1.11
done
Checking in src/com/edb/gridsql/planner/ExecutionPlan.java;
/cvsroot/gridsql/apps/gridsql/src/com/edb/gridsql/planner/ExecutionPlan.java,v <-- ExecutionPlan.java
new revision: 1.7; previous revision: 1.6
done
Checking in src/com/edb/gridsql/planner/StepDetail.java;
/cvsroot/gridsql/apps/gridsql/src/com/edb/gridsql/planner/StepDetail.java,v <-- StepDetail.java
new revision: 1.8; previous revision: 1.7
done
Checking in src/com/edb/gridsql/parser/core/sql_extendb.jj;
/cvsroot/gridsql/apps/gridsql/src/com/edb/gridsql/parser/core/sql_extendb.jj,v <-- sql_extendb.jj
new revision: 1.18; previous revision: 1.17
done
Checking in src/com/edb/gridsql/parser/core/CSQLParserTokenManager.java;
/cvsroot/gridsql/apps/gridsql/src/com/edb/gridsql/parser/core/CSQLParserTokenManager.java,v <-- CSQLParserTokenManager.java
new revision: 1.13; previous revision: 1.12
done
Checking in src/com/edb/gridsql/parser/core/jtb.out.jj;
/cvsroot/gridsql/apps/gridsql/src/com/edb/gridsql/parser/core/jtb.out.jj,v <-- jtb.out.jj
new revision: 1.17; previous revision: 1.16
done
Checking in src/com/edb/gridsql/parser/core/CSQLParserConstants.java;
/cvsroot/gridsql/apps/gridsql/src/com/edb/gridsql/parser/core/CSQLParserConstants.java,v <-- CSQLParserConstants.java
new revision: 1.10; previous revision: 1.9
done
Checking in src/com/edb/gridsql/parser/core/CSQLParser.java;
/cvsroot/gridsql/apps/gridsql/src/com/edb/gridsql/parser/core/CSQLParser.java,v <-- CSQLParser.java
new revision: 1.17; previous revision: 1.16
done
RCS file: /cvsroot/gridsql/apps/gridsql/src/com/edb/gridsql/parser/core/syntaxtree/Explain.java,v
done
Checking in src/com/edb/gridsql/parser/core/syntaxtree/Explain.java;
/cvsroot/gridsql/apps/gridsql/src/com/edb/gridsql/parser/core/syntaxtree/Explain.java,v <-- Explain.java
initial revision: 1.1
done
Checking in src/com/edb/gridsql/parser/core/syntaxtree/process.java;
/cvsroot/gridsql/apps/gridsql/src/com/edb/gridsql/parser/core/syntaxtree/process.java,v <-- process.java
new revision: 1.4; previous revision: 1.3
done
Checking in src/com/edb/gridsql/queryproc/QueryProcessor.java;
/cvsroot/gridsql/apps/gridsql/src/com/edb/gridsql/queryproc/QueryProcessor.java,v <-- QueryProcessor.java
new revision: 1.18; previous revision: 1.17
done