[
https://issues.apache.org/jira/browse/ASTERIXDB-3098?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vijay Sarathy updated ASTERIXDB-3098:
-------------------------------------
Description:
Add cardinality and cost to the EXPLAIN STRING plan.
Specifically, add the following to the EXPLAIN STRING 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:
*cardinality: 600.57*
*cost: 201311.84*
distribute result [$$16] *[cardinality: 600.57, op-cost: 0.0, total-cost:
201311.84]*
-- DISTRIBUTE_RESULT |PARTITIONED|
exchange *[cardinality: 600.57, op-cost: 0.0, total-cost: 201311.84]*
-- ONE_TO_ONE_EXCHANGE |PARTITIONED|
project ([$$16]) *[cardinality: 600.57, op-cost: 0.0, total-cost:
201311.84]*
-- STREAM_PROJECT |PARTITIONED|
assign [$$16] <- [\{"l": $$l}] *[cardinality: 600.57, op-cost: 0.0,
total-cost: 201311.84]*
-- ASSIGN |PARTITIONED|
select (eq($$l.getField("l_orderkey"), 1)) *[cardinality: 600.57,
op-cost: 0.0, total-cost: 201311.84]*
-- STREAM_SELECT |PARTITIONED|
...
> Add cardinality and cost to the EXPLAIN STRING plan
> ---------------------------------------------------
>
> Key: ASTERIXDB-3098
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-3098
> Project: Apache AsterixDB
> Issue Type: Improvement
> Reporter: Vijay Sarathy
> Priority: Major
>
> Add cardinality and cost to the EXPLAIN STRING plan.
> Specifically, add the following to the EXPLAIN STRING 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:
>
> *cardinality: 600.57*
> *cost: 201311.84*
> distribute result [$$16] *[cardinality: 600.57, op-cost: 0.0, total-cost:
> 201311.84]*
> -- DISTRIBUTE_RESULT |PARTITIONED|
> exchange *[cardinality: 600.57, op-cost: 0.0, total-cost: 201311.84]*
> -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
> project ([$$16]) *[cardinality: 600.57, op-cost: 0.0, total-cost:
> 201311.84]*
> -- STREAM_PROJECT |PARTITIONED|
> assign [$$16] <- [\{"l": $$l}] *[cardinality: 600.57, op-cost: 0.0,
> total-cost: 201311.84]*
> -- ASSIGN |PARTITIONED|
> select (eq($$l.getField("l_orderkey"), 1)) *[cardinality: 600.57,
> op-cost: 0.0, total-cost: 201311.84]*
> -- STREAM_SELECT |PARTITIONED|
> ...
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
