github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/opt/xform/testdata/coster/groupby (about)

     1  exec-ddl
     2  CREATE TABLE a (k INT PRIMARY KEY, i INT, s STRING, d DECIMAL NOT NULL)
     3  ----
     4  
     5  opt
     6  SELECT max(k), min(k), i, s FROM a GROUP BY i, s
     7  ----
     8  group-by
     9   ├── columns: max:5!null min:6!null i:2 s:3
    10   ├── grouping columns: i:2 s:3
    11   ├── stats: [rows=1000, distinct(2,3)=1000, null(2,3)=0.1]
    12   ├── cost: 1130.04
    13   ├── key: (2,3)
    14   ├── fd: (2,3)-->(5,6)
    15   ├── scan a
    16   │    ├── columns: k:1!null i:2 s:3
    17   │    ├── stats: [rows=1000, distinct(2,3)=1000, null(2,3)=0.1]
    18   │    ├── cost: 1070.02
    19   │    ├── key: (1)
    20   │    └── fd: (1)-->(2,3)
    21   └── aggregations
    22        ├── max [as=max:5, outer=(1)]
    23        │    └── k:1
    24        └── min [as=min:6, outer=(1)]
    25             └── k:1