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__)