github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/opt/xform/testdata/coster/select (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 k, s FROM a WHERE s >= 'foo' 7 ---- 8 select 9 ├── columns: k:1!null s:3!null 10 ├── stats: [rows=333.333333, distinct(3)=33.3333333, null(3)=0] 11 ├── cost: 1070.03 12 ├── key: (1) 13 ├── fd: (1)-->(3) 14 ├── scan a 15 │ ├── columns: k:1!null s:3 16 │ ├── stats: [rows=1000, distinct(1)=1000, null(1)=0, distinct(3)=100, null(3)=10] 17 │ ├── cost: 1060.02 18 │ ├── key: (1) 19 │ └── fd: (1)-->(3) 20 └── filters 21 └── s:3 >= 'foo' [outer=(3), constraints=(/3: [/'foo' - ]; tight)]