ydb
ydb copied to clipboard
ydb-platform
Add vertical lines to match idents
For large plans it is impossible to match (second) nodes link after is several lines
Some kind of vertical lines is needed to pair node and its subnode
┌──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┬────────┬────────┐
│ Operation │ E-Cost │ E-Rows │
├──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┼────────┼────────┤
│ -> ResultSet │ │ │
│ -> Sort (SortBy: row.o_year) │ │ │
│ -> Aggregate (GroupBy: item.o_year, Aggregation: {_yql_agg_0: SUM(If,state._yql_agg_0),_yql_agg_1: SUM(item.volume,state._y │ │ │
│ ql_agg_1)}) │ │ │
│ -> InnerJoin (Grace) (Condition: 0 = 0) │ │ │
│ -> Filter (Predicate: Exist(item.n.n_regionkey)) │ │ │
│ -> InnerJoin (Grace) (Condition: 0 = 0) │ │ │
│ -> Filter (Predicate: Exist(item.c.c_nationkey)) │ │ │
│ -> InnerJoin (Grace) (Condition: 0 = 0) │ │ │
│ -> Filter (Predicate: Exist(item.o.o_custkey)) │ │ │
│ -> InnerJoin (Grace) (Condition: 0 = 0) │ │ │
│ -> Filter (Predicate: Exist(item.l.l_orderkey)) │ │ │
│ -> InnerJoin (Grace) (Condition: 0 = 0) │ │ │
│ -> Filter (Predicate: Exist(item.s.s_nationkey)) │ │ │
│ -> InnerJoin (Grace) (Condition: 0 = 0) │ │ │
│ -> Filter (Predicate: Exist(item.l.l_suppkey)) │ │ │
│ -> InnerJoin (Grace) (Condition: 0 = 0) │ │ │
│ -> Filter (Predicate: Exist(item.p_partkey) And item.p_type == "ECONOMY PLATED COPPER") │ │ │
│ -> TableFullScan (ReadColumns: ["p_partkey","p_type"], ReadRanges: ["p_partkey (-∞, +∞)"], Ta │ │ │
│ ble: tpch10/part) │ │ │
│ -> Filter (Predicate: Exist(item.l_partkey)) │ │ │
│ -> TableFullScan (ReadColumns: ["l_discount","l_extendedprice","l_orderkey","l_partkey","l_suppkey"], │ │ │
│ ReadRanges: ["l_orderkey (-∞, +∞)","l_linenumber (-∞, +∞)"], Table: tpch10/lineitem) │ │ │
│ -> Filter (Predicate: Exist(item.s_suppkey)) │ │ │
│ -> TableFullScan (ReadColumns: ["s_nationkey","s_suppkey"], ReadRanges: ["s_suppkey (-∞, +∞)"], T │ │ │
│ able: tpch10/supplier) │ │ │
│ -> Filter (Predicate: Exist(item.n_nationkey)) │ │ │
│ -> TableFullScan (ReadColumns: ["n_name","n_nationkey","n_regionkey"], ReadRanges: ["n_nationkey (-∞, + │ │ │
│ ∞)"], Table: tpch10/nation) │ │ │
│ -> Filter (Predicate: Exist(item.o_orderkey) And item.o_orderdate >= "9131" And item.o_orderdate <= "9861") │ │ │
│ -> TableFullScan (ReadColumns: ["o_custkey","o_orderdate","o_orderkey"], ReadRanges: ["o_orderkey (-∞, +∞ │ │ │
│ )"], Table: tpch10/orders) │ │ │
│ -> Filter (Predicate: Exist(item.c_custkey)) │ │ │
│ -> TableFullScan (ReadColumns: ["c_custkey","c_nationkey"], ReadRanges: ["c_custkey (-∞, +∞)"], Table: tpch10 │ │ │
│ /customer) │ │ │
│ -> Filter (Predicate: Exist(item.n_nationkey)) │ │ │
│ -> TableFullScan (ReadColumns: ["n_name","n_nationkey","n_regionkey"], ReadRanges: ["n_nationkey (-∞, +∞)"], Tabl │ │ │
│ e: tpch10/nation) │ │ │
│ -> Filter (Predicate: Exist(item.r_regionkey) And item.r_name == "AFRICA") │ │ │
│ -> TableFullScan (ReadColumns: ["r_name","r_regionkey"], ReadRanges: ["r_regionkey (-∞, +∞)"], Table: tpch10/region) │ │ │
└──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┴────────┴────────┘
