You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by "Vijay Sarathy (Jira)" <ji...@apache.org> on 2023/01/25 04:51:00 UTC
[jira] [Resolved] (ASTERIXDB-3098) Add cardinality and cost to the EXPLAIN STRING plan
[ https://issues.apache.org/jira/browse/ASTERIXDB-3098?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Vijay Sarathy resolved ASTERIXDB-3098.
--------------------------------------
Resolution: Fixed
> 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
> Assignee: 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)