CockroachDB SQL Statistics
| SQL statistic name | Description | DBmarlin collects? | Doc Link |
|---|---|---|---|
duration | Computed field = STATISTICS→’statistics’→’svcLat’→’mean’ * STATISTICS→’statistics’→’cnt’ | Yes - Derived | N/A |
executions | Computed field = STATISTICS→’statistics’→’cnt’ | Yes - Derived | N/A |
execution_statistics__cnt | The number of times execution statistics were recorded. | Yes | https://www.cockroachlabs.com/docs/stable/crdb-internal#statistics-column |
execution_statistics__contentionTime__mean | The time the statement spent contending for resources before being executed. Running mean value. | Yes | https://www.cockroachlabs.com/docs/stable/crdb-internal#statistics-column |
execution_statistics__contentionTime__sqDiff | The time the statement spent contending for resources before being executed. Running sum of the squared difference from the mean. | Yes | https://www.cockroachlabs.com/docs/stable/crdb-internal#statistics-column |
execution_statistics__cpuSQLNanos__mean | The amount of CPU time spent executing the statement in nanoseconds. Running mean value. | No | https://www.cockroachlabs.com/docs/stable/crdb-internal#statistics-column |
execution_statistics__cpuSQLNanos__sqDiff | The amount of CPU time spent executing the statement in nanoseconds. Running sum of the squared difference from the mean. | No | https://www.cockroachlabs.com/docs/stable/crdb-internal#statistics-column |
execution_statistics__maxDiskUsage__mean | The maximum temporary disk usage (spilling) that occurred on a node. Running mean value. | Yes | https://www.cockroachlabs.com/docs/stable/crdb-internal#statistics-column |
execution_statistics__maxDiskUsage__sqDiff | Running sum of the squared difference from the mean of the maximum temporary disk usage (spilling) that occurred while executing this statement. | Yes | https://www.cockroachlabs.com/docs/stable/crdb-internal#statistics-column |
execution_statistics__maxMemUsage__mean | Running mean value of the maximum memory usage that occurred on a node. | Yes | https://www.cockroachlabs.com/docs/stable/crdb-internal#statistics-column |
execution_statistics__maxMemUsage__sqDiff | Running sum of the squared difference from the mean of the maximum memory usage that occurred on a node. | Yes | https://www.cockroachlabs.com/docs/stable/crdb-internal#statistics-column |
execution_statistics__networkBytes__mean | Running mean value of the number of bytes sent over the network. | Yes | https://www.cockroachlabs.com/docs/stable/crdb-internal#statistics-column |
execution_statistics__networkBytes__sqDiff | Running sum of the squared difference from the mean of the number of bytes sent over the network. | Yes | https://www.cockroachlabs.com/docs/stable/crdb-internal#statistics-column |
execution_statistics__networkMsgs__mean | Running mean value of the number of messages sent over the network. | Yes | https://www.cockroachlabs.com/docs/stable/crdb-internal#statistics-column |
execution_statistics__networkMsgs__sqDiff | Running sum of the squared difference from the mean of the number of messages sent over the network. | Yes | https://www.cockroachlabs.com/docs/stable/crdb-internal#statistics-column |
statistics__bytesRead__mean | Running mean value of the number of bytes read from disk. | Yes | https://www.cockroachlabs.com/docs/stable/crdb-internal#statistics-column |
statistics__bytesRead__sqDiff | Running sum of the squared difference from the mean of the number of bytes read from disk. | Yes | https://www.cockroachlabs.com/docs/stable/crdb-internal#statistics-column |
statistics__cnt | The total number of times this statement was executed since the begin of the aggregation period. | Yes | https://www.cockroachlabs.com/docs/stable/crdb-internal#statistics-column |
statistics__firstAttemptCnt | The total number of times a first attempt was executed. | Yes | https://www.cockroachlabs.com/docs/stable/crdb-internal#statistics-column |
statistics__idleLat__mean | Running mean value of the time spent waiting for the client to send the statement while holding the transaction open. | No | https://www.cockroachlabs.com/docs/stable/crdb-internal#statistics-column |
statistics__idleLat__sqDiff | Running sum of the squared difference from the mean of the time spent waiting for the client to send the statement while holding the transaction open. | No | https://www.cockroachlabs.com/docs/stable/crdb-internal#statistics-column |
statistics__indexes | The list of indexes used by the statement. | No | https://www.cockroachlabs.com/docs/stable/crdb-internal#statistics-column |
statistics__lastErrorCode | The PostgreSQL Error Code from the last failed execution of the statement fingerprint. | No | https://www.cockroachlabs.com/docs/stable/crdb-internal#statistics-column |
statistics__lastExecAt | The last timestamp the statement was executed. | No | https://www.cockroachlabs.com/docs/stable/crdb-internal#statistics-column |
statistics__maxRetries | The maximum observed number of automatic retries in the aggregation period. | Yes | https://www.cockroachlabs.com/docs/stable/crdb-internal#statistics-column |
statistics__nodes | An ordered list of nodes IDs on which the statement was executed. | No | https://www.cockroachlabs.com/docs/stable/crdb-internal#statistics-column |
statistics__numRows__mean | Running mean value of the number of rows returned or observed. | Yes | https://www.cockroachlabs.com/docs/stable/crdb-internal#statistics-column |
statistics__numRows__sqDiff | Running sum of the squared difference from the mean of the number of rows returned or observed. | Yes | https://www.cockroachlabs.com/docs/stable/crdb-internal#statistics-column |
statistics__ovhLat__mean | Running mean value of the difference between svcLat and the sum of parseLat+planLat+runLat latencies. | Yes | https://www.cockroachlabs.com/docs/stable/crdb-internal#statistics-column |
statistics__ovhLat__sqDiff | Running sum of the squared difference from the mean. The difference between svcLat and the sum of parseLat+planLat+runLat latencies. | Yes | https://www.cockroachlabs.com/docs/stable/crdb-internal#statistics-column |
statistics__parseLat__mean | Running mean value of the time to transform the SQL string into an abstract syntax tree (AST). | Yes | https://www.cockroachlabs.com/docs/stable/crdb-internal#statistics-column |
statistics__parseLat__sqDiff | Running sum of the squared difference from the mean of the time to transform the SQL string into an abstract syntax tree (AST). | Yes | https://www.cockroachlabs.com/docs/stable/crdb-internal#statistics-column |
statistics__planGists | A sequence of bytes representing the flattened tree of operators and various operator specific metadata of the statement plan. | No | https://www.cockroachlabs.com/docs/stable/crdb-internal#statistics-column |
statistics__planLat__mean | Running mean value of the time to transform the AST into a logical query plan. | Yes | https://www.cockroachlabs.com/docs/stable/crdb-internal#statistics-column |
statistics__planLat__sqDiff | Running sum of the squared difference from the mean of the time to transform the AST into a logical query plan. | Yes | https://www.cockroachlabs.com/docs/stable/crdb-internal#statistics-column |
statistics__rowsRead__mean | Running mean value of the number of rows read from disk. | Yes | https://www.cockroachlabs.com/docs/stable/crdb-internal#statistics-column |
statistics__rowsRead__sqDiff | Running sum of the squared difference from the mean of the number of rows read from disk. | Yes | https://www.cockroachlabs.com/docs/stable/crdb-internal#statistics-column |
statistics__rowsWritten__mean | Running mean value of the number of rows written to disk. | Yes | https://www.cockroachlabs.com/docs/stable/crdb-internal#statistics-column |
statistics__rowsWritten__sqDiff | Running sum of the squared difference from the mean of the number of rows written to disk. | Yes | https://www.cockroachlabs.com/docs/stable/crdb-internal#statistics-column |
statistics__runLat__mean | Running mean value of the time to run the query and fetch or compute the result rows. | Yes | https://www.cockroachlabs.com/docs/stable/crdb-internal#statistics-column |
statistics__runLat__sqDiff | Running sum of the squared difference from the mean of the time to run the query and fetch or compute the result rows. | Yes | https://www.cockroachlabs.com/docs/stable/crdb-internal#statistics-column |
statistics__svcLat__mean | Running mean value of the time to service the query, from start of parse to end of execute. | Yes | https://www.cockroachlabs.com/docs/stable/crdb-internal#statistics-column |
statistics__svcLat__sqDiff | Running sum of the squared difference from the mean of the time to service the query, from start of parse to end of execute. | Yes | https://www.cockroachlabs.com/docs/stable/crdb-internal#statistics-column |
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.