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

     1  # The cluster secret is used for hashing application names.
     2  exec
     3  SET CLUSTER SETTING cluster.secret = 'secret'
     4  ----
     5  
     6  # Application names that begin with '$ ' are not hashed.
     7  exec
     8  SET application_name = '$ some app' 
     9  ----
    10  
    11  # Verify values and identifiers from queries are scrubbed.
    12  sql-stats
    13  CREATE DATABASE foo;
    14  CREATE TABLE foo.a (a INT, CONSTRAINT a CHECK (a > 1));
    15  INSERT INTO foo.a SELECT unnest(ARRAY[1,2,3,4,5]);
    16  SET CLUSTER SETTING cluster.organization = 'ACME';
    17  SELECT (1, 20, 30, 40) = (SELECT a, 1, 2, 3 FROM foo.a LIMIT 1);
    18  ----
    19  error: pq: failed to satisfy CHECK constraint (a > 1:::INT8)
    20  sql-stats
    21   └── $ some app
    22        ├── [nodist] CREATE DATABASE _
    23        ├── [nodist] CREATE TABLE _ (_ INT8, CONSTRAINT _ CHECK (_ > _))
    24        └── [failed,nodist] INSERT INTO _ SELECT unnest(ARRAY[_, _, __more3__])
    25  
    26  # Verify statements are correctly separated by app.
    27  sql-stats
    28  CREATE TABLE foo.t (x INT, y INT);
    29  SET application_name = '$ some other app';
    30  CREATE DATABASE bar;
    31  CREATE TABLE bar.t (x INT, y INT);
    32  SET application_name = 'hashed app name';
    33  CREATE DATABASE baz;
    34  CREATE TABLE baz.t (x INT, y INT);
    35  INSERT INTO baz.t VALUES (1, 1), (2, 2);
    36  ----
    37  sql-stats
    38   ├── $ some app
    39   │    ├── [nodist] CREATE TABLE _ (_ INT8, _ INT8)
    40   │    └── [nodist] SET application_name = _
    41   ├── $ some other app
    42   │    ├── [nodist] CREATE DATABASE _
    43   │    ├── [nodist] CREATE TABLE _ (_ INT8, _ INT8)
    44   │    └── [nodist] SET application_name = _
    45   └── b16e4363
    46        ├── [nodist] CREATE DATABASE _
    47        ├── [nodist] CREATE TABLE _ (_ INT8, _ INT8)
    48        └── [nodist] INSERT INTO _ VALUES (_, _), (__more1__)