github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/opt/testutils/opttester/testdata/inject-stats (about)

     1  exec-ddl
     2  CREATE TABLE rides (
     3      id UUID NOT NULL,
     4      city VARCHAR NOT NULL,
     5      vehicle_city VARCHAR NULL,
     6      rider_id UUID NULL,
     7      vehicle_id UUID NULL,
     8      start_address VARCHAR NULL,
     9      end_address VARCHAR NULL,
    10      start_time TIMESTAMP NULL,
    11      end_time TIMESTAMP NULL,
    12      revenue DECIMAL(10,2) NULL,
    13      CONSTRAINT "primary" PRIMARY KEY (city ASC, id ASC),
    14      INDEX rides_auto_index_fk_city_ref_users (city ASC, rider_id ASC),
    15      INDEX rides_auto_index_fk_vehicle_city_ref_vehicles (vehicle_city ASC, vehicle_id ASC),
    16      FAMILY "primary" (id, city, vehicle_city, rider_id, vehicle_id, start_address, end_address, start_time, end_time, revenue),
    17      CONSTRAINT check_vehicle_city_city CHECK (vehicle_city = city)
    18  )
    19  ----
    20  
    21  opt format=show-stats
    22  SELECT * FROM rides WHERE city = 'rome'
    23  ----
    24  scan rides
    25   ├── columns: id:1(uuid!null) city:2(varchar!null) vehicle_city:3(varchar) rider_id:4(uuid) vehicle_id:5(uuid) start_address:6(varchar) end_address:7(varchar) start_time:8(timestamp) end_time:9(timestamp) revenue:10(decimal)
    26   ├── constraint: /2/1: [/'rome' - /'rome']
    27   ├── stats: [rows=10, distinct(2)=1, null(2)=0]
    28   ├── key: (1)
    29   └── fd: ()-->(2), (1)-->(3-10)
    30  
    31  inject-stats file=inject-stats.json table=rides
    32  ----
    33  
    34  opt format=show-stats
    35  SELECT * FROM rides WHERE city = 'rome'
    36  ----
    37  scan rides
    38   ├── columns: id:1(uuid!null) city:2(varchar!null) vehicle_city:3(varchar) rider_id:4(uuid) vehicle_id:5(uuid) start_address:6(varchar) end_address:7(varchar) start_time:8(timestamp) end_time:9(timestamp) revenue:10(decimal)
    39   ├── constraint: /2/1: [/'rome' - /'rome']
    40   ├── stats: [rows=55, distinct(2)=1, null(2)=0]
    41   │   histogram(2)=  0    55
    42   │                <--- 'rome'
    43   ├── key: (1)
    44   └── fd: ()-->(2), (1)-->(3-10)