Insert time and query execution time

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.

2 Likes