| commit | f8da037534e90bcd7b8b632c1c349a5d3685a171 | [log] [tgz] |
|---|---|---|
| author | Zvonimir Pavlinovic <zpavlinovic@google.com> | Wed Nov 15 19:15:00 2023 +0000 |
| committer | Zvonimir Pavlinovic <zpavlinovic@google.com> | Thu Nov 16 01:49:19 2023 +0000 |
| tree | 83d741d663cb576cc437ac3a738f4fb6e54d29d2 | |
| parent | 389421632f24357d7eb98d3e02479b6648974d60 [diff] |
internal/worker: reduce data read in work version queries These seemingly simple queries can take a long time to execute due to the size of the data they operate on and move around; this can create slot contention. We try to reduce the amount of data being moved around by not selecting module paths, versions, and binary names as they are already fixated in the WHERE clause. https://cloud.google.com/bigquery/docs/best-practices-performance-compute#reduce-data-processed Change-Id: Ieef57c5494cf50cf06628f17b784c44e575c8a78 Reviewed-on: https://go-review.googlesource.com/c/pkgsite-metrics/+/542675 TryBot-Result: Gopher Robot <gobot@golang.org> LUCI-TryBot-Result: Go LUCI <golang-scoped@luci-project-accounts.iam.gserviceaccount.com> Run-TryBot: Zvonimir Pavlinovic <zpavlinovic@google.com> Reviewed-by: Jonathan Amsterdam <jba@google.com>
This repository contains code that serves pkg.go.dev/metrics.
This repository uses Gerrit for code changes. To learn how to submit changes to this repository, see https://golang.org/doc/contribute.html.
The main issue tracker for the time repository is located at https://github.com/golang/go/issues. Prefix your issue with “x/pkgsite-metrics:” in the subject line, so it is easy to find.