Skip to content

Add terraform state metrics to usage data

Matt Kasa requested to merge mattkasa/207510-terraform-state-usage-ping into master

What does this MR do?

  • Adds terraform state metrics to usage data

terraform_states

Queries
SELECT "features"."key" FROM "features"

https://explain.depesz.com/s/TNFl

SELECT MIN("terraform_states"."id") FROM "terraform_states"

https://explain.depesz.com/s/RRZN

SELECT MAX("terraform_states"."id") FROM "terraform_states"

https://explain.depesz.com/s/ruAh

SELECT COUNT("terraform_states"."id") FROM "terraform_states" WHERE "terraform_states"."id" BETWEEN 0 AND 999999

https://explain.depesz.com/s/YFAE

projects_with_terraform_states

Queries
SELECT "features"."key" FROM "features"

https://explain.depesz.com/s/TNFl

SELECT MIN("terraform_states"."project_id") FROM "terraform_states"

https://explain.depesz.com/s/8f24

SELECT MAX("terraform_states"."project_id") FROM "terraform_states"

https://explain.depesz.com/s/HsiZ

SELECT COUNT(DISTINCT "terraform_states"."project_id") FROM "terraform_states" WHERE "terraform_states"."project_id" BETWEEN 0 AND 999999

https://explain.depesz.com/s/vRUT

Closes #207510 (closed)

Does this MR meet the acceptance criteria?

Conformity

Availability and Testing

Security

If this MR contains changes to processing or storing of credentials or tokens, authorization and authentication methods and other items described in the security review guidelines:

  • [-] Label as security and @ mention @gitlab-com/gl-security/appsec
  • [-] The MR includes necessary changes to maintain consistency between UI, API, email, or other methods
  • [-] Security reports checked/validated by a reviewer from the AppSec team
Edited by 🤖 GitLab Bot 🤖

Merge request reports