Skip to content

Add `counts.enterprise_users` metric

What does this MR do and why?

This MR adds counts.enterprise_users metric to understand the adoption of Enterprise Users.

Related to #383140 (closed)

DB Query Plan

SELECT COUNT("user_details"."user_id") FROM "user_details" WHERE "user_details"."enterprise_group_id" IS NOT NULL;

https://console.postgres.ai/gitlab/gitlab-production-main/sessions/24686/commands/78528

This query uses index_user_details_on_enterprise_group_id_and_user_id.

I've considered adding new specific to this query index:

CREATE INDEX index_user_details_on_user_id_for_enterprise_users ON user_details USING btree (user_id) WHERE (enterprise_group_id IS NOT NULL);

but I don't see any improvements, see https://console.postgres.ai/gitlab/gitlab-production-main/sessions/24686/commands/78535.

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

Edited by Bogdan Denkovych

Merge request reports

Loading