sqlstats: use aost in sql activity update job aggregation queries

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

30.06k stars 3.8k forks source link

sqlstats: use aost in sql activity update job aggregation queries #133495

Open xinhaoz opened 2 hours ago

xinhaoz commented 2 hours ago

The queries in the sql activity update job that select the top-k data from the full sql stats tables don't use aost clauses. This results in contention on the tables since the flush operations from different nodes are frequently being run in the bg.

We should just split these txns up so we can use aost.

Jira issue: CRDB-43647

blathers-crl[bot] commented 2 hours ago

Hi @xinhaoz, please add branch-* labels to identify which branch(es) this C-bug affects.

_{:owl: Hoot! I am a Blathers, a bot for CockroachDB. My owner is dev-inf.}