aqetuner / encoder / test_plan
test_plan
Raw
{    "NodeId" : 223,    "NodeType" : "Projection",    "Expressions" : [      "Views",      "DownVotes",      "count():=`expr#count()`"    ],    "Statistic" : {      "RowCount" : 24097,      "Cost" : 608364.5224767606    },    "Children" : [      {        "NodeId" : 222,        "NodeType" : "Exchange",        "Mode" : "Gather",        "Statistic" : {          "RowCount" : 24097,          "Cost" : 606581.3444501891        },        "Children" : [          {            "NodeId" : 221,            "NodeType" : "MergingAggregated",            "Aggregates" : [              "expr#count():=count()"            ],            "GroupByKeys" : [              "DownVotes",              "Views"            ],            "Statistic" : {              "RowCount" : 24097,              "Cost" : 602725.6644501891            },            "Children" : [              {                "NodeId" : 220,                "NodeType" : "Exchange",                "Mode" : "Repartition",                "PartitionBy" : [                  "DownVotes",                  "Views"                ],                "Statistic" : {                  "RowCount" : 24097,                  "Cost" : 602725.6644501891                },                "Children" : [                  {                    "NodeId" : 219,                    "NodeType" : "Aggregating",                    "Aggregates" : [                      "expr#count():=count()"                    ],                    "GroupByKeys" : [                      "DownVotes",                      "Views"                    ],                    "Statistic" : {                      "RowCount" : 24097,                      "Cost" : 598869.9044501891                    },                    "Children" : [                      {                        "NodeId" : 218,                        "NodeType" : "Join",                        "Strictness" : "",                        "JoinKind" : "Inner",                        "RuntimeFiltersBuilder" : [                          "Id"                        ],                        "Condition" : [                          "UserId == Id"                        ],                        "Statistic" : {                          "RowCount" : 324419,                          "Cost" : 598869.9044501891                        },                        "Children" : [                          {                            "NodeId" : 214,                            "NodeType" : "Filter",                            "RuntimeFilter" : "$runtimeFilter(0, UserId, 0.9040091007035878, )",                            "Filter" : "1",                            "Statistic" : {                              "RowCount" : 328064,                              "Cost" : 267044.09636175155                            },                            "Children" : [                              {                                "NodeId" : 193,                                "NodeType" : "TableScan",                                "Where" : "Runtime Filters: {UserId}",                                "Outputs" : [                                  "UserId"                                ],                                "Statistic" : {                                  "RowCount" : 328064,                                  "Cost" : 242767.36                                }                              }                            ]                          },                          {                            "NodeId" : 217,                            "NodeType" : "Exchange",                            "Mode" : "Broadcast",                            "Statistic" : {                              "RowCount" : 39877,                              "Cost" : 42155.92808843762                            },                            "Children" : [                              {                                "NodeId" : 216,                                "NodeType" : "Projection",                                "Expressions" : [                                  "Views",                                  "Id",                                  "DownVotes"                                ],                                "Statistic" : {                                  "RowCount" : 39877,                                  "Cost" : 35775.44808843762                                },                                "Children" : [                                  {                                    "NodeId" : 215,                                    "NodeType" : "Filter",                                    "Filter" : "(Reputation >= 1) AND (Reputation <= 691)",                                    "Statistic" : {                                      "RowCount" : 39877,                                      "Cost" : 32824.55004446581                                    },                                    "Children" : [                                      {                                        "NodeId" : 195,                                        "NodeType" : "TableScan",                                        "Where" : "(Reputation >= 1) AND (Reputation <= 691)",                                        "Outputs" : [                                          "DownVotes",                                          "Views",                                          "Reputation",                                          "Id"                                        ],                                        "Statistic" : {                                          "RowCount" : 40325,                                          "Cost" : 29840.5                                        }                                      }                                    ]                                  }                                ]                              }                            ]                          }                        ]                      }                    ]                  }                ]              }            ]          }        ]      }    ]  }