search

LucidDB / adminui

DEFUNCT. Front-end in-browser flash client for connecting to LucidDB's admin web services.
http://www.dynamobi.com/c/products/luciddb/administration-ui/
GNU General Public License v2.0
1 stars 1 forks source link

[DADMINUI-16] Present full text EXPLAIN PLAN with Explain Plan visual #43

Closed dynamobi-build closed 12 years ago

dynamobi-build commented 12 years ago

[reporter="ngoodman", created="Thu, 10 Jun 2010 09:41:53 -0700", resolved="Sat, 19 Feb 2011 16:36:09 -0800"]

Currently only the visual, abbreviated Explain Plan is presented to the user.

Enhance the Flex client to also present the full explain result set in the Results tab as well as the visual Explain Plan.

dynamobi-build commented 12 years ago

[author="ngoodman", created="Thu, 10 Jun 2010 09:48:05 -0700"]

And here's corresponding output from full explain plan that should show up in Results tab (row by row, ignore the '')

'IterCalcRel(expr#0..14=tok0-block-tok, expr#15=[CAST($t12):VARCHAR(128) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary"], expr#16=[CAST($t11):VARCHAR(128) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary"], expr#17=[CAST($t14):VARCHAR(128) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary"], expr#18=[CAST($t1):VARCHAR(128) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary"], expr#19=1, expr#20=[+($t8, $t19)], expr#21=IS NOT NULL($t5), expr#22=CASE($t21, $t5, $t2), expr#23=[CAST($t4):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary"], expr#24='columnNoNulls', expr#25==($t23, $t24), expr#26=0, expr#27='columnNullable', expr#28==($t23, $t27), expr#29=2, expr#30=CASE($t25, $t26, $t28, $t19, $t29), expr#31=CAST($t30):INTEGER, expr#32==($t31, $t26), expr#33=false, expr#34==($t31, $t19), expr#35=true, expr#36=null, expr#37=CAST($t36):BOOLEAN, expr#38=CASE($t32, $t33, $t34, $t35, $t37), expr#39=[CAST($t0):VARCHAR(128) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary"], expr#40=[CAST($t7):VARCHAR(128) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary"], CATALOG_NAME=[$t15], SCHEMA_NAME=[$t16], TABLE_NAME=[$t17], COLUMN_NAME=[$t18], ORDINAL_POSITION=[$t20], DATATYPE=[$t10], PRECISION=[$t22], DEC_DIGITS=[$t3], IS_NULLABLE=[$t38], REMARKS=[$t6], MOF_ID=[$t39], LINEAGE_ID=[$t40])'
' FennelToIteratorConverter'
' LhxJoinRel(leftKeys=[9], rightKeys=[2], joinType=INNER)'
' FennelReshapeRel(projection=[0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 12], outputRowType=[RecordType(VARCHAR(1024) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" mofId, VARCHAR(1024) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" name, INTEGER precision, INTEGER scale, VARCHAR(1024) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" isNullable, INTEGER length, VARCHAR(1024) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" description, VARCHAR(1024) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" lineageId, INTEGER ordinal, VARCHAR(1024) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" owner, VARCHAR(1024) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" name0) NOT NULL])'
'LhxJoinRel(leftKeys=[10], rightKeys=[0], joinType=INNER)'
' IteratorToFennelConverter'
' ResultSetToFarragoIteratorConverter'
' MedJdbcQueryRel(foreignSql=[SELECT "mofId", "name", "precision", "scale", "isNullable", "length", "description", "lineageId", "ordinal", "owner", "type"'
'FROM "FEM_VT_Sql2003_AbstractColumn"])'
' IteratorToFennelConverter'
' ResultSetToFarragoIteratorConverter'
' MedJdbcQueryRel(foreignSql=[SELECT "mofId", "name"'
'FROM "FEM_VT_Relational_SQLDataType"])'
' FennelReshapeRel(projection=[1, 2, 3, 4], outputRowType=[RecordType(VARCHAR(1024) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" name, VARCHAR(1024) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" name0, VARCHAR(1024) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" mofId1, VARCHAR(1024) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" name1) NOT NULL])'
'LhxJoinRel(leftKeys=[0], rightKeys=[2], joinType=INNER)'
' FennelReshapeRel(projection=[0, 1, 4], outputRowType=[RecordType(VARCHAR(1024) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" mofId, VARCHAR(1024) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" name, VARCHAR(1024) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" name0) NOT NULL])'
' IteratorToFennelConverter'
' ResultSetToFarragoIteratorConverter'
'MedJdbcQueryRel(foreignSql=[SELECT *'
'FROM (SELECT "mofId", "name", "namespace"'
'FROM "FEM_VT_Relational_Schema") AS "LEFT_INPUT",'
'(SELECT "mofId", "name"'
'FROM "FEM_VT_Relational_Catalog") AS "RIGHT_INPUT"'
'WHERE "RIGHT_INPUT"."mofId" = "LEFT_INPUT"."namespace"])'
' IteratorToFennelConverter'
' ResultSetToFarragoIteratorConverter'
' MedJdbcQueryRel(foreignSql=[SELECT "mofId", "name", "namespace"'
'FROM "FEM_VT_Relational_NamedColumnSet"])'

dynamobi-build commented 12 years ago

[author="ksecretan", created="Thu, 12 Aug 2010 13:38:44 -0700"]

Got it

dynamobi-build commented 12 years ago

[author="ksecretan", created="Mon, 21 Feb 2011 09:49:34 -0800"]

Isn't it? If you click the explain plan button it should give the visual
graph, then click the results tab to see what you would see if you just ran
explain plan for...

On Sat, Feb 19, 2011 at 4:36 PM, Nicholas Goodman (JIRA) <