ooni / ooni/devops

Create skipping indexes on observations and analysis tables

Open
#411 0 comments 0 reactions 1 assignee View on GitHub

@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

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.