Create skipping indexes on observations and analysis tables
Open
@hellais is already working on this.
Since Apr 21, 2026.
- Dominant language
- HCL
- Stars
- 4
- Forks
- 15
- Avg merge
- 1h 50m
- Merged PRs (30d)
- 4
Description
Currently the observations and analysis tables don't have complete indexes. We should create the following ones:
ALTER TABLE obs_web ON CLUSTER oonidata_cluster ADD INDEX measurement_start_time_idx measurement_start_time TYPE minmax GRANULARITY 2;
ALTER TABLE obs_web ON CLUSTER oonidata_cluster ADD INDEX probe_cc_idx probe_cc TYPE minmax GRANULARITY 1;
ALTER TABLE obs_web ON CLUSTER oonidata_cluster ADD INDEX probe_asn_idx probe_asn TYPE minmax GRANULARITY 1;
ALTER TABLE analysis_web_measurement ON CLUSTER oonidata_cluster ADD INDEX probe_asn_idx probe_asn TYPE minmax GRANULARITY 1;
And then re-index the data using:
ALTER TABLE obs_web ON CLUSTER oonidata_cluster MATERIALIZE INDEX measurement_start_time_idx;
ALTER TABLE obs_web ON CLUSTER oonidata_cluster MATERIALIZE INDEX probe_cc_idx;
ALTER TABLE obs_web ON CLUSTER oonidata_cluster MATERIALIZE INDEX probe_asn_idx;
ALTER TABLE analysis_web_measurement ON CLUSTER oonidata_cluster MATERIALIZE INDEX probe_asn_idx;
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Assessment
This issue has not been assessed yet.