github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/opt/xform/testdata/coster/virtual-scan (about) 1 opt 2 SELECT * FROM information_schema.schemata WHERE SCHEMA_NAME='public' 3 ---- 4 select 5 ├── columns: catalog_name:2!null schema_name:3!null default_character_set_name:4 sql_path:5 6 ├── stats: [rows=10, distinct(3)=1, null(3)=0] 7 ├── cost: 1100.03 8 ├── fd: ()-->(3) 9 ├── scan information_schema.schemata 10 │ ├── columns: catalog_name:2!null schema_name:3!null default_character_set_name:4 sql_path:5 11 │ ├── stats: [rows=1000, distinct(2)=100, null(2)=0, distinct(3)=100, null(3)=0] 12 │ └── cost: 1090.02 13 └── filters 14 └── schema_name:3 = 'public' [outer=(3), constraints=(/3: [/'public' - /'public']; tight), fd=()-->(3)]