CockroachDB TIL: Volume 7
This is my series of articles covering short "Today I learned" topics as I work with CockroachDB. Today, we're covering CLI query stats, clone schemas quickly, distinguish which table IDs correspond to which table names, connect to non-default databases and copy columns between column families. Previous articles Volume 1 Volume 2 Volume 3 Volume 4 Volume 5 Volume 6 Volume 7 Topics Topic 1: SHOW LAST QUERY STATISTICS Topic 2: Clone table definitions in bulk across schemas Topic 3: Quick way to map a table name to a table ID Topic 4: Changing default database for sql client Topic 5: Quick way to move a column from one Column Family to another Topic 1: SHOW LAST QUERY STATISTICS CockroachDB has a very user-friendly and helpful UI called DB Console. I like to refer to it when I debug query performance. We have a very useful Statements page which shows a statement overview, explain plan and execution stats. Little did I know CockroachDB has an und...
