┌─────────────────────────────────────────────────────────────────┬───────┬────────┬───────────┬───────────┬───────────┐
│ Operation                                                       │ A-Cpu │ A-Rows │ E-Cost    │ E-Rows    │ E-Size    │
├─────────────────────────────────────────────────────────────────┼───────┼────────┼───────────┼───────────┼───────────┤
│  -> ResultSet                                                   │       │        │           │           │           │
│    -> Limit (A-SelfCpu: 2.808, A-Size: 15997, Limit: 100)       │ 3893  │ 100    │           │           │           │
│      -> TopSort (A-SelfCpu: 256.639, A-Size: 31927, Limit: 100, │ 3890  │ 200    │           │           │           │
│  TopSortBy: [Arg.s_1.s_acctbal,Arg.n.n_name,Arg.s_1.s_name,Arg. │       │        │           │           │           │
│ ps_1.ps_partkey])                                               │       │        │           │           │           │
│        -> InnerJoin (Grace) (m.Min0,m.ps.ps_partkey = ps_1.ps_p │       │ 460    │ 4.800e+11 │ 3.200e+11 │ 2.427e+14 │
│ artkey,ps_1.ps_supplycost)                                      │       │        │           │           │           │
│          -> HashShuffle (KeyColumns: ["ps.ps_partkey","Min0"],  │       │        │           │           │           │
│ HashFunc: "HashV1")                                             │       │        │           │           │           │
│            -> HashShuffle (KeyColumns: ["ps.ps_partkey"], HashF │       │        │           │           │           │
│ unc: "HashV1")                                                  │       │        │           │           │           │
│              -> Aggregate (GroupBy: [0], Aggregation: MIN, A-Se │ 2692  │ 130353 │           │           │           │
│ lfCpu: 1185.095, Phase: Intermediate, A-Size: 2085790)          │       │        │           │           │           │
│                -> LeftSemiJoin (Grace) (ps.ps_suppkey = s_1.s_s │       │ 158960 │ 2460144   │ 800000    │ 2.869e+08 │
│ uppkey)                                                         │       │        │           │           │           │
│                  -> HashShuffle (KeyColumns: ["ps_suppkey"], Ha │       │        │           │           │           │
│ shFunc: "HashV1")                                               │       │        │           │           │           │
│                    -> TableFullScan (Table: olap_yatests/tpch/s │ 1457  │ 800000 │ 0         │ 800000    │ 32712192  │
│ 1/partsupp, Scan: Parallel, ReadRanges: ["ps_partkey (-∞, +∞)", │       │        │           │           │           │
│ "ps_suppkey (-∞, +∞)"], A-SelfCpu: 1456.822, Path: /local/test_ │       │        │           │           │           │
│ db/olap_yatests/tpch/s1/partsupp, ReadColumns: ["ps_partkey","p │       │        │           │           │           │
│ s_suppkey","ps_supplycost"], A-Size: 10507060)                  │       │        │           │           │           │
│                  -> HashShuffle (KeyColumns: ["s_1.s_suppkey"], │       │        │           │           │           │
│  HashFunc: "HashV1")                                            │       │        │           │           │           │
│                    -> LeftSemiJoin (MapJoin) (A-SelfCpu: 38.204 │ 50    │ 1987   │ 30144     │ 10000     │ 3177880   │
│ , s_1.s_nationkey = n.n_nationkey, A-Size: 6601)                │       │        │           │           │           │
│                      -> TableFullScan (Table: olap_yatests/tpch │ 10    │ 10000  │ 0         │ 10000     │ 1106680   │
│ /s1/supplier, Scan: Parallel, ReadRanges: ["s_suppkey (-∞, +∞)" │       │        │           │           │           │
│ ], A-SelfCpu: 9.959, Path: /local/test_db/olap_yatests/tpch/s1/ │       │        │           │           │           │
│ supplier, ReadColumns: ["s_acctbal","s_address","s_comment","s_ │       │        │           │           │           │
│ name","s_nationkey","s_phone","s_suppkey"], A-Size: 120640)     │       │        │           │           │           │
│                      -> LeftSemiJoin (MapJoin) (A-SelfCpu: 1.56 │ 2     │ 5      │ 76        │ 25        │ 5178      │
│ 1, n.n_regionkey = r.r_regionkey, A-Size: 7)                    │       │        │           │           │           │
│                        -> TableFullScan (Table: olap_yatests/tp │       │ 25     │ 0         │ 25        │ 1818      │
│ ch/s1/nation, Scan: Parallel, ReadRanges: ["n_nationkey (-∞, +∞ │       │        │           │           │           │
│ )"], Path: /local/test_db/olap_yatests/tpch/s1/nation, ReadColu │       │        │           │           │           │
│ mns: ["n_name","n_nationkey","n_regionkey"], A-Size: 677)       │       │        │           │           │           │
│                        -> Filter (r_name == "EUROPE", A-SelfCpu │ 0     │ 1      │ 0         │ 1         │ 67        │
│ : 0.475, Pushdown: True, A-Size: 9)                             │       │        │           │           │           │
│                          -> TableFullScan (Table: olap_yatests/ │       │ 1      │ 0         │ 5         │ 672       │
│ tpch/s1/region, Scan: Parallel, ReadRanges: ["r_regionkey (-∞,  │       │        │           │           │           │
│ +∞)"], Path: /local/test_db/olap_yatests/tpch/s1/region, ReadCo │       │        │           │           │           │
│ lumns: ["r_name","r_regionkey"], A-Size: 13)                    │       │        │           │           │           │
│          -> HashShuffle (KeyColumns: ["ps_1.ps_partkey","ps_1.p │       │        │           │           │           │
│ s_supplycost"], HashFunc: "HashV1")                             │       │        │           │           │           │
│            -> InnerJoin (MapJoin) (A-SelfCpu: 179.468, s_1.s_na │ 941   │ 642    │ 6657144   │ 2000000   │ 7.997e+08 │
│ tionkey = n.n_nationkey, A-Size: 114160)                        │       │        │           │           │           │
│              -> InnerJoin (Grace) (ps_1.ps_suppkey = s_1.s_supp │       │        │ 3057000   │ 400000    │ 77090418  │
│ key)                                                            │       │        │           │           │           │
│                -> HashShuffle (KeyColumns: ["ps_1.ps_suppkey"], │       │        │           │           │           │
│  HashFunc: "HashV1")                                            │       │        │           │           │           │
│                  -> InnerJoin (MapJoin) (A-SelfCpu: 649.001, ps │ 657   │ 2988   │ 1827000   │ 400000    │ 32823218  │
│ _1.ps_partkey = p.p_partkey, A-Size: 93241)                     │       │        │           │           │           │
│                    -> TableFullScan (Table: olap_yatests/tpch/s │ 5     │ 800000 │ 0         │ 800000    │ 32712192  │
│ 1/partsupp, Scan: Parallel, ReadRanges: ["ps_partkey (-∞, +∞)", │       │        │           │           │           │
│ "ps_suppkey (-∞, +∞)"], A-SelfCpu: 4.683, Path: /local/test_db/ │       │        │           │           │           │
│ olap_yatests/tpch/s1/partsupp, ReadColumns: ["ps_partkey","ps_s │       │        │           │           │           │
│ uppkey","ps_supplycost"], A-Size: 19201024)                     │       │        │           │           │           │
│                    -> Filter ((p_size == 15) AND (p_type LIKE " │ 4     │ 747    │ 0         │ 10000     │ 411678    │
│ %BRASS"), A-SelfCpu: 3.654, Pushdown: True, A-Size: 20247)      │       │        │           │           │           │
│                      -> TableFullScan (Table: olap_yatests/tpch │       │ 747    │ 0         │ 200000    │ 8233561   │
│ /s1/part, Scan: Parallel, ReadRanges: ["p_partkey (-∞, +∞)"], P │       │        │           │           │           │
│ ath: /local/test_db/olap_yatests/tpch/s1/part, ReadColumns: ["p │       │        │           │           │           │
│ _mfgr","p_partkey","p_size","p_type"], A-Size: 25652)           │       │        │           │           │           │
│                -> HashShuffle (KeyColumns: ["s_suppkey"], HashF │       │        │           │           │           │
│ unc: "HashV1")                                                  │       │        │           │           │           │
│                  -> TableFullScan (Table: olap_yatests/tpch/s1/ │ 102   │ 10000  │ 0         │ 10000     │ 1106680   │
│ supplier, Scan: Parallel, ReadRanges: ["s_suppkey (-∞, +∞)"], A │       │        │           │           │           │
│ -SelfCpu: 102.191, Path: /local/test_db/olap_yatests/tpch/s1/su │       │        │           │           │           │
│ pplier, ReadColumns: ["s_acctbal","s_address","s_comment","s_na │       │        │           │           │           │
│ me","s_nationkey","s_phone","s_suppkey"], A-Size: 1357278)      │       │        │           │           │           │
│              -> LeftSemiJoin (MapJoin) (A-SelfCpu: 1.497, n.n_r │ 2     │ 5      │ 76        │ 25        │ 5178      │
│ egionkey = r.r_regionkey, A-Size: 55)                           │       │        │           │           │           │
│                -> TableFullScan (Table: olap_yatests/tpch/s1/na │       │ 25     │ 0         │ 25        │ 1818      │
│ tion, Scan: Parallel, ReadRanges: ["n_nationkey (-∞, +∞)"], Pat │       │        │           │           │           │
│ h: /local/test_db/olap_yatests/tpch/s1/nation, ReadColumns: ["n │       │        │           │           │           │
│ _name","n_nationkey","n_regionkey"], A-Size: 677)               │       │        │           │           │           │
│                -> Filter (r_name == "EUROPE", A-SelfCpu: 0.507, │ 1     │ 1      │ 0         │ 1         │ 67        │
│  Pushdown: True, A-Size: 9)                                     │       │        │           │           │           │
│                  -> TableFullScan (Table: olap_yatests/tpch/s1/ │       │ 1      │ 0         │ 5         │ 672       │
│ region, Scan: Parallel, ReadRanges: ["r_regionkey (-∞, +∞)"], P │       │        │           │           │           │
│ ath: /local/test_db/olap_yatests/tpch/s1/region, ReadColumns: [ │       │        │           │           │           │
│ "r_name","r_regionkey"], A-Size: 13)                            │       │        │           │           │           │
└─────────────────────────────────────────────────────────────────┴───────┴────────┴───────────┴───────────┴───────────┘
