{
    "Plan" : {
        "Plans" : [
            {
                "PlanNodeId" : 7,
                "Plans" : [
                    {
                        "PlanNodeId" : 6,
                        "Operators" : [
                            {
                                "Inputs" : [
                                    {
                                        "InternalOperatorId" : 1
                                    }
                                ],
                                "Iterator" : "precompute_0_0",
                                "Name" : "Iterator"
                            },
                            {
                                "Inputs" : [ ],
                                "Name" : "Member",
                                "Member" : "precompute_0_0"
                            }
                        ],
                        "Node Type" : "ConstantExpr-ConstantExpr",
                        "Stats" : {
                            "UseLlvm" : "undefined",
                            "Output" : [
                                {
                                    "Pop" : {
                                        "Chunks" : {
                                            "Count" : 1,
                                            "Sum" : 1,
                                            "Max" : 1,
                                            "Min" : 1
                                        },
                                        "Rows" : {
                                            "Count" : 1,
                                            "Sum" : 1,
                                            "Max" : 1,
                                            "Min" : 1
                                        },
                                        "Bytes" : {
                                            "Count" : 1,
                                            "Sum" : 456,
                                            "Max" : 456,
                                            "Min" : 456
                                        }
                                    },
                                    "Name" : "RESULT",
                                    "Push" : {
                                        "Chunks" : {
                                            "Count" : 1,
                                            "Sum" : 1,
                                            "Max" : 1,
                                            "Min" : 1
                                        },
                                        "Rows" : {
                                            "Count" : 1,
                                            "Sum" : 1,
                                            "Max" : 1,
                                            "Min" : 1
                                        }
                                    }
                                }
                            ],
                            "MaxMemoryUsage" : {
                                "Count" : 1,
                                "Sum" : 1114112,
                                "Max" : 1114112,
                                "Min" : 1114112
                            },
                            "ResultRows" : {
                                "Count" : 1,
                                "Sum" : 1,
                                "Max" : 1,
                                "Min" : 1
                            },
                            "Tasks" : 1,
                            "ResultBytes" : {
                                "Count" : 1,
                                "Sum" : 456,
                                "Max" : 456,
                                "Min" : 456
                            },
                            "FinishedTasks" : 1,
                            "OutputRows" : {
                                "Count" : 1,
                                "Sum" : 1,
                                "Max" : 1,
                                "Min" : 1
                            },
                            "PhysicalStageId" : 0,
                            "StageDurationUs" : 0,
                            "BaseTimeMs" : 1765530801423,
                            "CpuTimeUs" : {
                                "Count" : 1,
                                "Sum" : 4197,
                                "Max" : 4197,
                                "Min" : 4197
                            },
                            "OutputBytes" : {
                                "Count" : 1,
                                "Sum" : 456,
                                "Max" : 456,
                                "Min" : 456
                            }
                        },
                        "CTE Name" : "precompute_0_0"
                    }
                ],
                "Node Type" : "ResultSet_1",
                "PlanNodeType" : "ResultSet"
            },
            {
                "PlanNodeId" : 4,
                "Subplan Name" : "CTE precompute_0_0",
                "Plans" : [
                    {
                        "PlanNodeId" : 3,
                        "Plans" : [
                            {
                                "PlanNodeId" : 2,
                                "Plans" : [
                                    {
                                        "Tables" : [
                                            "olap_yatests/clickbench/hits"
                                        ],
                                        "PlanNodeId" : 1,
                                        "Operators" : [
                                            {
                                                "Inputs" : [
                                                    {
                                                        "InternalOperatorId" : 1
                                                    }
                                                ],
                                                "Name" : "Aggregate",
                                                "Phase" : "Intermediate"
                                            },
                                            {
                                                "Scan" : "Parallel",
                                                "E-Size" : "164006.4762",
                                                "ReadRanges" : [
                                                    "CounterID (-∞, +∞)",
                                                    "EventDate (-∞, +∞)",
                                                    "UserID (-∞, +∞)",
                                                    "EventTime (-∞, +∞)",
                                                    "WatchID (-∞, +∞)"
                                                ],
                                                "Name" : "TableFullScan",
                                                "Inputs" : [ ],
                                                "Path" : "/local/test_db/olap_yatests/clickbench/hits",
                                                "E-Rows" : "30150",
                                                "Table" : "olap_yatests/clickbench/hits",
                                                "ReadColumns" : [
                                                    "ResolutionWidth"
                                                ],
                                                "SsaProgram" : {
                                                    "Version" : 5,
                                                    "Command" : [
                                                        {
                                                            "Projection" : {
                                                                "Columns" : [
                                                                    {
                                                                        "Id" : 21
                                                                    }
                                                                ]
                                                            }
                                                        }
                                                    ]
                                                },
                                                "E-Cost" : "0"
                                            }
                                        ],
                                        "Node Type" : "Aggregate-TableFullScan",
                                        "Stats" : {
                                            "UseLlvm" : "undefined",
                                            "Output" : [
                                                {
                                                    "Pop" : {
                                                        "Chunks" : {
                                                            "Count" : 3,
                                                            "Sum" : 3,
                                                            "Max" : 1,
                                                            "Min" : 1
                                                        },
                                                        "Rows" : {
                                                            "Count" : 3,
                                                            "Sum" : 3,
                                                            "Max" : 1,
                                                            "Min" : 1
                                                        },
                                                        "LastMessageMs" : {
                                                            "Count" : 3,
                                                            "Sum" : 9240,
                                                            "Max" : 3089,
                                                            "Min" : 3066
                                                        },
                                                        "ActiveMessageMs" : {
                                                            "Count" : 3,
                                                            "Max" : 3089,
                                                            "Min" : 3066
                                                        },
                                                        "FirstMessageMs" : {
                                                            "Count" : 3,
                                                            "Sum" : 9240,
                                                            "Max" : 3089,
                                                            "Min" : 3066
                                                        },
                                                        "Bytes" : {
                                                            "Count" : 3,
                                                            "Sum" : 1095,
                                                            "Max" : 365,
                                                            "Min" : 365
                                                        }
                                                    },
                                                    "Name" : "3",
                                                    "Push" : {
                                                        "LastMessageMs" : {
                                                            "Count" : 3,
                                                            "Sum" : 9240,
                                                            "Max" : 3089,
                                                            "Min" : 3066
                                                        },
                                                        "Rows" : {
                                                            "Count" : 3,
                                                            "Sum" : 3,
                                                            "Max" : 1,
                                                            "Min" : 1
                                                        },
                                                        "Chunks" : {
                                                            "Count" : 3,
                                                            "Sum" : 3,
                                                            "Max" : 1,
                                                            "Min" : 1
                                                        },
                                                        "ResumeMessageMs" : {
                                                            "Count" : 3,
                                                            "Sum" : 9240,
                                                            "Max" : 3089,
                                                            "Min" : 3066
                                                        },
                                                        "FirstMessageMs" : {
                                                            "Count" : 3,
                                                            "Sum" : 9240,
                                                            "Max" : 3089,
                                                            "Min" : 3066
                                                        },
                                                        "ActiveMessageMs" : {
                                                            "Count" : 3,
                                                            "Max" : 3089,
                                                            "Min" : 3066
                                                        },
                                                        "PauseMessageMs" : {
                                                            "Count" : 3,
                                                            "Sum" : 9238,
                                                            "Max" : 3088,
                                                            "Min" : 3066
                                                        },
                                                        "WaitTimeUs" : {
                                                            "Count" : 3,
                                                            "Sum" : 9206838,
                                                            "Max" : 3072575,
                                                            "Min" : 3065884
                                                        },
                                                        "WaitPeriods" : {
                                                            "Count" : 3,
                                                            "Sum" : 3,
                                                            "Max" : 1,
                                                            "Min" : 1
                                                        },
                                                        "WaitMessageMs" : {
                                                            "Count" : 3,
                                                            "Max" : 3089,
                                                            "Min" : 3066
                                                        }
                                                    }
                                                }
                                            ],
                                            "MaxMemoryUsage" : {
                                                "Count" : 3,
                                                "Sum" : 3342336,
                                                "Max" : 1114112,
                                                "Min" : 1114112
                                            },
                                            "IngressBytes" : {
                                                "Count" : 3,
                                                "Sum" : 1000000,
                                                "Max" : 341120,
                                                "Min" : 324110
                                            },
                                            "Tasks" : 3,
                                            "OutputRows" : {
                                                "Count" : 3,
                                                "Sum" : 3,
                                                "Max" : 1,
                                                "Min" : 1
                                            },
                                            "FinishedTasks" : 3,
                                            "IngressRows" : {
                                                "Count" : 3,
                                                "Sum" : 100000,
                                                "Max" : 34112,
                                                "Min" : 32411
                                            },
                                            "PhysicalStageId" : 0,
                                            "StageDurationUs" : 0,
                                            "Table" : [
                                                {
                                                    "Path" : "/local/test_db/olap_yatests/clickbench/hits",
                                                    "ReadRows" : {
                                                        "Count" : 3,
                                                        "Sum" : 100000,
                                                        "Max" : 34112,
                                                        "Min" : 32411
                                                    },
                                                    "ReadBytes" : {
                                                        "Count" : 3,
                                                        "Sum" : 1000000,
                                                        "Max" : 341120,
                                                        "Min" : 324110
                                                    }
                                                }
                                            ],
                                            "BaseTimeMs" : 1765530798316,
                                            "OutputBytes" : {
                                                "Count" : 3,
                                                "Sum" : 1095,
                                                "Max" : 365,
                                                "Min" : 365
                                            },
                                            "CpuTimeUs" : {
                                                "Count" : 3,
                                                "Sum" : 4718031,
                                                "Max" : 1613866,
                                                "Min" : 1509650
                                            },
                                            "Ingress" : [
                                                {
                                                    "Pop" : { },
                                                    "External" : {
                                                        "PartitionCount" : 128,
                                                        "LastMessageMs" : {
                                                            "Count" : 128,
                                                            "Sum" : 215145,
                                                            "Max" : 3068,
                                                            "Min" : 157
                                                        },
                                                        "ExternalRows" : {
                                                            "Count" : 128,
                                                            "Sum" : 100000,
                                                            "Max" : 844,
                                                            "Min" : 709
                                                        },
                                                        "ExternalBytes" : {
                                                            "Count" : 128,
                                                            "Sum" : 1000000,
                                                            "Max" : 8440,
                                                            "Min" : 7090
                                                        },
                                                        "FirstMessageMs" : {
                                                            "Count" : 128,
                                                            "Sum" : 207567,
                                                            "Max" : 3025,
                                                            "Min" : 131
                                                        }
                                                    },
                                                    "Name" : "CS",
                                                    "Ingress" : {
                                                        "Rows" : {
                                                            "Count" : 3,
                                                            "Sum" : 100000,
                                                            "Max" : 34112,
                                                            "Min" : 32411
                                                        },
                                                        "LastMessageMs" : {
                                                            "Count" : 3,
                                                            "Sum" : 9176,
                                                            "Max" : 3068,
                                                            "Min" : 3042
                                                        },
                                                        "ActiveMessageMs" : {
                                                            "Count" : 3,
                                                            "Max" : 3068,
                                                            "Min" : 131
                                                        },
                                                        "FirstMessageMs" : {
                                                            "Count" : 3,
                                                            "Sum" : 401,
                                                            "Max" : 136,
                                                            "Min" : 131
                                                        },
                                                        "Bytes" : {
                                                            "Count" : 3,
                                                            "Sum" : 1000000,
                                                            "Max" : 341120,
                                                            "Min" : 324110
                                                        },
                                                        "ActiveTimeUs" : {
                                                            "Count" : 3,
                                                            "Sum" : 8775000,
                                                            "Max" : 2934000,
                                                            "Min" : 2911000
                                                        }
                                                    },
                                                    "Push" : { }
                                                }
                                            ],
                                            "UpdateTimeMs" : 3089
                                        }
                                    }
                                ],
                                "Node Type" : "UnionAll",
                                "PlanNodeType" : "Connection"
                            }
                        ],
                        "Operators" : [
                            {
                                "Inputs" : [
                                    {
                                        "InternalOperatorId" : 1
                                    }
                                ],
                                "Name" : "Aggregate",
                                "Phase" : "Final"
                            },
                            {
                                "Inputs" : [
                                    {
                                        "InternalOperatorId" : 2
                                    }
                                ],
                                "Name" : "Limit",
                                "Limit" : "1"
                            },
                            {
                                "Inputs" : [
                                    {
                                        "ExternalPlanNodeId" : 2
                                    }
                                ],
                                "Name" : "Aggregate",
                                "Phase" : "Final"
                            }
                        ],
                        "Node Type" : "Aggregate-Limit-Aggregate",
                        "Stats" : {
                            "UseLlvm" : "undefined",
                            "OutputRows" : {
                                "Count" : 1,
                                "Sum" : 1,
                                "Max" : 1,
                                "Min" : 1
                            },
                            "PhysicalStageId" : 1,
                            "FinishedTasks" : 1,
                            "InputBytes" : {
                                "Count" : 1,
                                "Sum" : 1095,
                                "Max" : 1095,
                                "Min" : 1095
                            },
                            "DurationUs" : {
                                "Count" : 1,
                                "Sum" : 24000,
                                "Max" : 24000,
                                "Min" : 24000
                            },
                            "MaxMemoryUsage" : {
                                "Count" : 1,
                                "Sum" : 1114112,
                                "Max" : 1114112,
                                "Min" : 1114112
                            },
                            "BaseTimeMs" : 1765530798316,
                            "Output" : [
                                {
                                    "Pop" : {
                                        "Chunks" : {
                                            "Count" : 1,
                                            "Sum" : 1,
                                            "Max" : 1,
                                            "Min" : 1
                                        },
                                        "Rows" : {
                                            "Count" : 1,
                                            "Sum" : 1,
                                            "Max" : 1,
                                            "Min" : 1
                                        },
                                        "LastMessageMs" : {
                                            "Count" : 1,
                                            "Sum" : 3090,
                                            "Max" : 3090,
                                            "Min" : 3090
                                        },
                                        "FirstMessageMs" : {
                                            "Count" : 1,
                                            "Sum" : 3090,
                                            "Max" : 3090,
                                            "Min" : 3090
                                        },
                                        "Bytes" : {
                                            "Count" : 1,
                                            "Sum" : 456,
                                            "Max" : 456,
                                            "Min" : 456
                                        }
                                    },
                                    "Name" : "RESULT",
                                    "Push" : {
                                        "LastMessageMs" : {
                                            "Count" : 1,
                                            "Sum" : 3090,
                                            "Max" : 3090,
                                            "Min" : 3090
                                        },
                                        "Rows" : {
                                            "Count" : 1,
                                            "Sum" : 1,
                                            "Max" : 1,
                                            "Min" : 1
                                        },
                                        "Chunks" : {
                                            "Count" : 1,
                                            "Sum" : 1,
                                            "Max" : 1,
                                            "Min" : 1
                                        },
                                        "ResumeMessageMs" : {
                                            "Count" : 1,
                                            "Sum" : 3090,
                                            "Max" : 3090,
                                            "Min" : 3090
                                        },
                                        "FirstMessageMs" : {
                                            "Count" : 1,
                                            "Sum" : 3090,
                                            "Max" : 3090,
                                            "Min" : 3090
                                        },
                                        "PauseMessageMs" : {
                                            "Count" : 1,
                                            "Sum" : 3085,
                                            "Max" : 3085,
                                            "Min" : 3085
                                        },
                                        "WaitTimeUs" : {
                                            "Count" : 1,
                                            "Sum" : 3073858,
                                            "Max" : 3073858,
                                            "Min" : 3073858
                                        },
                                        "WaitPeriods" : {
                                            "Count" : 1,
                                            "Sum" : 1,
                                            "Max" : 1,
                                            "Min" : 1
                                        },
                                        "WaitMessageMs" : {
                                            "Count" : 1,
                                            "Max" : 3090,
                                            "Min" : 3085
                                        }
                                    }
                                }
                            ],
                            "CpuTimeUs" : {
                                "Count" : 1,
                                "Sum" : 16157,
                                "Max" : 16157,
                                "Min" : 16157
                            },
                            "StageDurationUs" : 24000,
                            "ResultRows" : {
                                "Count" : 1,
                                "Sum" : 1,
                                "Max" : 1,
                                "Min" : 1
                            },
                            "ResultBytes" : {
                                "Count" : 1,
                                "Sum" : 456,
                                "Max" : 456,
                                "Min" : 456
                            },
                            "OutputBytes" : {
                                "Count" : 1,
                                "Sum" : 456,
                                "Max" : 456,
                                "Min" : 456
                            },
                            "Input" : [
                                {
                                    "Pop" : {
                                        "Chunks" : {
                                            "Count" : 1,
                                            "Sum" : 3,
                                            "Max" : 3,
                                            "Min" : 3
                                        },
                                        "Rows" : {
                                            "Count" : 1,
                                            "Sum" : 3,
                                            "Max" : 3,
                                            "Min" : 3
                                        },
                                        "LastMessageMs" : {
                                            "Count" : 1,
                                            "Sum" : 3089,
                                            "Max" : 3089,
                                            "Min" : 3089
                                        },
                                        "ActiveMessageMs" : {
                                            "Count" : 1,
                                            "Max" : 3089,
                                            "Min" : 3067
                                        },
                                        "FirstMessageMs" : {
                                            "Count" : 1,
                                            "Sum" : 3067,
                                            "Max" : 3067,
                                            "Min" : 3067
                                        },
                                        "Bytes" : {
                                            "Count" : 1,
                                            "Sum" : 1095,
                                            "Max" : 1095,
                                            "Min" : 1095
                                        },
                                        "ActiveTimeUs" : {
                                            "Count" : 1,
                                            "Sum" : 22000,
                                            "Max" : 22000,
                                            "Min" : 22000
                                        }
                                    },
                                    "Name" : "1",
                                    "Push" : {
                                        "Rows" : {
                                            "Count" : 1,
                                            "Sum" : 3,
                                            "Max" : 3,
                                            "Min" : 3
                                        },
                                        "LastMessageMs" : {
                                            "Count" : 1,
                                            "Sum" : 3089,
                                            "Max" : 3089,
                                            "Min" : 3089
                                        },
                                        "Chunks" : {
                                            "Count" : 1,
                                            "Sum" : 3,
                                            "Max" : 3,
                                            "Min" : 3
                                        },
                                        "ResumeMessageMs" : {
                                            "Count" : 1,
                                            "Sum" : 3089,
                                            "Max" : 3089,
                                            "Min" : 3089
                                        },
                                        "FirstMessageMs" : {
                                            "Count" : 1,
                                            "Sum" : 3067,
                                            "Max" : 3067,
                                            "Min" : 3067
                                        },
                                        "ActiveMessageMs" : {
                                            "Count" : 1,
                                            "Max" : 3089,
                                            "Min" : 3067
                                        },
                                        "Bytes" : {
                                            "Count" : 1,
                                            "Sum" : 1095,
                                            "Max" : 1095,
                                            "Min" : 1095
                                        },
                                        "PauseMessageMs" : {
                                            "Count" : 1,
                                            "Sum" : 3039,
                                            "Max" : 3039,
                                            "Min" : 3039
                                        },
                                        "ActiveTimeUs" : {
                                            "Count" : 1,
                                            "Sum" : 22000,
                                            "Max" : 22000,
                                            "Min" : 22000
                                        },
                                        "WaitTimeUs" : {
                                            "Count" : 1,
                                            "Sum" : 3064426,
                                            "Max" : 3064426,
                                            "Min" : 3064426
                                        },
                                        "WaitPeriods" : {
                                            "Count" : 1,
                                            "Sum" : 3,
                                            "Max" : 3,
                                            "Min" : 3
                                        },
                                        "WaitMessageMs" : {
                                            "Count" : 1,
                                            "Max" : 3089,
                                            "Min" : 3039
                                        }
                                    }
                                }
                            ],
                            "UpdateTimeMs" : 3091,
                            "InputRows" : {
                                "Count" : 1,
                                "Sum" : 3,
                                "Max" : 3,
                                "Min" : 3
                            },
                            "Tasks" : 1
                        }
                    }
                ],
                "Node Type" : "Precompute_0",
                "Parent Relationship" : "InitPlan",
                "PlanNodeType" : "Materialize"
            }
        ],
        "Node Type" : "Query",
        "Stats" : {
            "Compilation" : {
                "FromCache" : false,
                "DurationUs" : 12809724,
                "CpuTimeUs" : 12799579
            },
            "ProcessCpuTimeUs" : 639,
            "TotalDurationUs" : 16013667,
            "ResourcePoolId" : "default",
            "QueuedTimeUs" : 0
        },
        "PlanNodeType" : "Query"
    },
    "meta" : {
        "version" : "0.2",
        "type" : "query"
    },
    "SimplifiedPlan" : {
        "PlanNodeId" : 0,
        "Plans" : [
            {
                "PlanNodeId" : 1,
                "Plans" : [
                    {
                        "PlanNodeId" : 5,
                        "Plans" : [
                            {
                                "PlanNodeId" : 6,
                                "Plans" : [
                                    {
                                        "PlanNodeId" : 7,
                                        "Plans" : [
                                            {
                                                "PlanNodeId" : 9,
                                                "Plans" : [
                                                    {
                                                        "PlanNodeId" : 10,
                                                        "Operators" : [
                                                            {
                                                                "Scan" : "Parallel",
                                                                "E-Size" : "164006.4762",
                                                                "ReadRanges" : [
                                                                    "CounterID (-∞, +∞)",
                                                                    "EventDate (-∞, +∞)",
                                                                    "UserID (-∞, +∞)",
                                                                    "EventTime (-∞, +∞)",
                                                                    "WatchID (-∞, +∞)"
                                                                ],
                                                                "Name" : "TableFullScan",
                                                                "A-Rows" : 100000,
                                                                "Path" : "/local/test_db/olap_yatests/clickbench/hits",
                                                                "E-Rows" : "30150",
                                                                "Table" : "olap_yatests/clickbench/hits",
                                                                "ReadColumns" : [
                                                                    "ResolutionWidth"
                                                                ],
                                                                "A-Size" : 1000000,
                                                                "SsaProgram" : {
                                                                    "Version" : 5,
                                                                    "Command" : [
                                                                        {
                                                                            "Projection" : {
                                                                                "Columns" : [
                                                                                    {
                                                                                        "Id" : 21
                                                                                    }
                                                                                ]
                                                                            }
                                                                        }
                                                                    ]
                                                                },
                                                                "E-Cost" : "0"
                                                            }
                                                        ],
                                                        "Node Type" : "TableFullScan"
                                                    }
                                                ],
                                                "Operators" : [
                                                    {
                                                        "A-Rows" : 3,
                                                        "A-SelfCpu" : 1613.866,
                                                        "A-Cpu" : 1613.866,
                                                        "A-Size" : 1095,
                                                        "Name" : "Aggregate",
                                                        "Phase" : "Intermediate"
                                                    }
                                                ],
                                                "Node Type" : "Aggregate"
                                            }
                                        ],
                                        "Operators" : [
                                            {
                                                "Name" : "Aggregate",
                                                "Phase" : "Final"
                                            }
                                        ],
                                        "Node Type" : "Aggregate"
                                    }
                                ],
                                "Operators" : [
                                    {
                                        "Name" : "Limit",
                                        "Limit" : "1"
                                    }
                                ],
                                "Node Type" : "Limit"
                            }
                        ],
                        "Operators" : [
                            {
                                "A-Rows" : 1,
                                "A-SelfCpu" : 16.157,
                                "A-Cpu" : 1630.023,
                                "A-Size" : 456,
                                "Name" : "Aggregate",
                                "Phase" : "Final"
                            }
                        ],
                        "Node Type" : "Aggregate"
                    }
                ],
                "Node Type" : "ResultSet_1",
                "PlanNodeType" : "ResultSet"
            }
        ],
        "Node Type" : "Query",
        "PlanNodeType" : "Query"
    }
}
