github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/opt/optgen/exprgen/testdata/explain (about)

     1  exec-ddl
     2  CREATE TABLE abc (a INT, b INT, c INT, INDEX ab(a, b))
     3  ----
     4  
     5  expr
     6  (Explain
     7    (Scan [ (Table "abc") (Cols "a") ])
     8    [
     9      (Options "opt,verbose")
    10      (Props (MinPhysProps))
    11    ]
    12  )
    13  ----
    14  explain
    15   ├── mode: opt, verbose
    16   ├── stats: [rows=10]
    17   ├── cost: 1050.03
    18   └── scan t.public.abc
    19        ├── columns: t.public.abc.a:1(int)
    20        ├── stats: [rows=1000]
    21        ├── cost: 1050.02
    22        ├── prune: (1)
    23        └── interesting orderings: (+1)
    24  
    25  expr
    26  (Explain
    27    (Scan [ (Table "abc") (Cols "a") ])
    28    [
    29      (Options "verbose")
    30      (Props (MinPhysProps))
    31    ]
    32  )
    33  ----
    34  explain
    35   ├── mode: verbose
    36   ├── stats: [rows=10]
    37   ├── cost: 1050.03
    38   └── scan t.public.abc
    39        ├── columns: t.public.abc.a:1(int)
    40        ├── stats: [rows=1000]
    41        ├── cost: 1050.02
    42        ├── prune: (1)
    43        └── interesting orderings: (+1)
    44  
    45  expr
    46  (Explain
    47    (Scan [ (Table "abc") (Cols "a") ])
    48    [
    49      (Options "opt")
    50      (Props (MinPhysProps))
    51    ]
    52  )
    53  ----
    54  explain
    55   ├── mode: opt
    56   ├── stats: [rows=10]
    57   ├── cost: 1050.03
    58   └── scan t.public.abc
    59        ├── columns: t.public.abc.a:1(int)
    60        ├── stats: [rows=1000]
    61        ├── cost: 1050.02
    62        ├── prune: (1)
    63        └── interesting orderings: (+1)
    64  
    65  expr
    66  (Explain
    67    (Sort
    68      (Scan [ (Table "abc") (Cols "a,b") ])
    69    )
    70    [
    71      (Options "opt")
    72      (Props
    73        (MakePhysProps
    74          (Presentation "a")
    75          (OrderingChoice "+b")
    76        )
    77      )
    78    ]
    79  )
    80  ----
    81  explain
    82   ├── mode: opt
    83   ├── stats: [rows=10]
    84   ├── cost: 1279.35569
    85   └── sort
    86        ├── columns: a:1(int)  [hidden: t.public.abc.b:2(int)]
    87        ├── stats: [rows=1000]
    88        ├── cost: 1279.34569
    89        ├── ordering: +2
    90        └── scan t.public.abc
    91             ├── columns: t.public.abc.a:1(int) t.public.abc.b:2(int)
    92             ├── stats: [rows=1000]
    93             └── cost: 1060.02
    94  
    95  expr
    96  (Explain
    97    (Scan [ (Table "abc") (Cols "a") ])
    98    [
    99      (Options "distsql")
   100      (Props (MinPhysProps))
   101    ]
   102  )
   103  ----
   104  explain
   105   ├── mode: distsql
   106   ├── stats: [rows=10]
   107   ├── cost: 1050.03
   108   └── scan t.public.abc
   109        ├── columns: t.public.abc.a:1(int)
   110        ├── stats: [rows=1000]
   111        ├── cost: 1050.02
   112        ├── prune: (1)
   113        └── interesting orderings: (+1)