You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by "ASF subversion and git services (Jira)" <ji...@apache.org> on 2023/01/30 03:27:00 UTC
[jira] [Commented] (ASTERIXDB-3094) Add cardinality and cost to the EXPLAIN plan
[ https://issues.apache.org/jira/browse/ASTERIXDB-3094?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17681870#comment-17681870 ]
ASF subversion and git services commented on ASTERIXDB-3094:
------------------------------------------------------------
Commit 39d7562a593cae1afbc5496383e207f7bb4b08c5 in asterixdb's branch refs/heads/master from Vijay Sarathy
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=39d7562a59 ]
[ASTERIXDB-3094][COMP] Add cost and cardinality to explain
Backport changes:
- Compensate for lack of add'l operator stats change in this branch
Change-Id: I7b4a6c78dca3326f070e1dda888d774dc6100c0b
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/17301
Integration-Tests: Jenkins <je...@fulliautomatix.ics.uci.edu>
Tested-by: Jenkins <je...@fulliautomatix.ics.uci.edu>
Reviewed-by: Ali Alsuliman <al...@gmail.com>
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/17341
Reviewed-by: Michael Blow <mb...@apache.org>
Tested-by: Michael Blow <mb...@apache.org>
> Add cardinality and cost to the EXPLAIN plan
> --------------------------------------------
>
> Key: ASTERIXDB-3094
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-3094
> Project: Apache AsterixDB
> Issue Type: Improvement
> Reporter: Vijay Sarathy
> Assignee: Vijay Sarathy
> Priority: Major
>
> Add cardinality and cost to the EXPLAIN plan.
> Specifically, add the following to the EXPLAIN plan.
> * estimated per-operator cardinality
> * estimated per-operator cost
> * estimated total cost for the plan up to the current operator
> * estimated cardinality for the whole plan
> * estimated total cost for the whole plan
> Example snippet of query plan:
> "requestID": "01af0e04-c950-4f6d-878b-05cd4c43c5a0",
> "signature": {
> "*": "*"
> },
> "results": [ {
> *"cardinality" : 15.0,*
> *"cost" : 5021.1,*
> "plan" : {
> "operator" : "distribute-result",
> "expressions" : [
> "$$36"
> ],
> "operatorId" : "1.1",
> "runtime-id" : "ODID:1",
> "physical-operator" : "DISTRIBUTE_RESULT",
> "execution-mode" : "UNPARTITIONED",
> *"optimizer-estimates" : {*
> *"cardinality" : 15.0,*
> *"op-cost" : 0.0,*
> *"total-cost" : 5021.1*
> *},*
> "inputs" : [
> {
> "operator" : "exchange",
> "operatorId" : "1.2",
> "runtime-id" : "CDID:3",
> "physical-operator" : "ONE_TO_ONE_EXCHANGE",
> "execution-mode" : "UNPARTITIONED",
> *"optimizer-estimates" : {*
> *"cardinality" : 15.0,*
> *"op-cost" : 0.0,*
> *"total-cost" : 5021.1*
> *},*
--
This message was sent by Atlassian Jira
(v8.20.10#820010)