How to see how long did it take for inserting data into the tables, and query execution time?
We just added support for this (see https://github.com/cockroachdb/cockroach/pull/17358), but it will only be available in a stable version when CockroachDB 1.1 is released. In the meantime, you could run
select now(); before and after your query, and measure individual latency that way.
You can also peruse the
crdb_internal.node_statement_statistics table which keeps some aggregate stats, but it’s not very fine grained (I think durations are in seconds). This too will be better documented in 1.1.