Skip to content

Improve mesa-performance-tracking query execution time

Guilherme Gallo requested to merge gallo/mesa-performance-tracking:optimize-influxdb-schema into master
  • Reduce database cardinality from 22k+ to 164 via the transformation of the following tags into fields: "job_id", "pipeline_id", "commit_sha", and "commit_title"
  • Reduce query execution time for last record timing from ~8s to < 300 ms in a database with 30+ days of recordings.
  • Update the queries to group metadata fields in each frame_time value.

For more information about tags, fields and cardinality, see:

Merge request reports