search

cockroachdb / cockroach

CockroachDB — the cloud native, distributed SQL database designed for high availability, effortless scale, and control over data placement.
https://www.cockroachlabs.com
Other
29.95k stars 3.79k forks source link

Add additional SQL statistics to break down RU consumption #108436

Open kevin-v-ngo opened 1 year ago

kevin-v-ngo commented 1 year ago

It's difficult for CockroachDB Serverless users to understand how RUs are correlated with their workload, specifically SQL statements and Transactions.

This issue tracks adding additional SQL statistics to specifically allow users to correlate and breakdown RUs:

Related issue for SQL Stats collected via telemetry: https://github.com/cockroachdb/cockroach/issues/95194

Jira issue: CRDB-30472

kevin-v-ngo commented 1 year ago

Adding SQL Queries to this issue as well since it may be a joint effort in case these metrics are not yet available.

Network egress (to client) is not yet collected: https://github.com/cockroachdb/cockroach/issues/108436