Skip to content

Remove incorrect enterprise users metrics

Bogdan Denkovych requested to merge bdenkovych-remove-incorrect-enterprise-users-metrics-412320 into master

What does this MR do and why?

Related to #412320 (closed)

How to set up and validate locally

DB migrations validation

bin/rails db:migrate RAILS_ENV=test 
main: == [advisory_lock_connection] object_id: 271880, pg_backend_pid: 27197
main: == 20230524150232 RemoveIndexUserDetailsOnUserIdForEnterpriseUsersWithoutDate: migrating
main: -- transaction_open?()
main:    -> 0.0000s
main: -- view_exists?(:postgres_partitions)
main:    -> 0.0026s
main: -- indexes(:user_details)
main:    -> 0.0043s
main: -- execute("SET statement_timeout TO 0")
main:    -> 0.0005s
main: -- remove_index(:user_details, {:algorithm=>:concurrently, :name=>"index_user_details_on_user_id_for_enterprise_users_without_date"})
main:    -> 0.0012s
main: -- execute("RESET statement_timeout")
main:    -> 0.0004s
main: == 20230524150232 RemoveIndexUserDetailsOnUserIdForEnterpriseUsersWithoutDate: migrated (0.0259s)

main: == 20230524150438 RemoveIndexUserDetailsOnUserIdForEnterpriseUsersWithDate: migrating
main: -- transaction_open?()
main:    -> 0.0000s
main: -- view_exists?(:postgres_partitions)
main:    -> 0.0008s
main: -- indexes(:user_details)
main:    -> 0.0032s
main: -- remove_index(:user_details, {:algorithm=>:concurrently, :name=>"index_user_details_on_user_id_for_enterprise_users_with_date"})
main:    -> 0.0010s
main: == 20230524150438 RemoveIndexUserDetailsOnUserIdForEnterpriseUsersWithDate: migrated (0.0148s)

main: == [advisory_lock_connection] object_id: 271880, pg_backend_pid: 27197
ci: == [advisory_lock_connection] object_id: 272040, pg_backend_pid: 27201
ci: == 20230524150232 RemoveIndexUserDetailsOnUserIdForEnterpriseUsersWithoutDate: migrating
ci: -- transaction_open?()
ci:    -> 0.0000s
ci: -- view_exists?(:postgres_partitions)
ci:    -> 0.0007s
ci: -- indexes(:user_details)
ci:    -> 0.0043s
ci: -- execute("SET statement_timeout TO 0")
ci:    -> 0.0004s
ci: -- remove_index(:user_details, {:algorithm=>:concurrently, :name=>"index_user_details_on_user_id_for_enterprise_users_without_date"})
ci:    -> 0.0011s
ci: -- execute("RESET statement_timeout")
ci:    -> 0.0005s
ci: == 20230524150232 RemoveIndexUserDetailsOnUserIdForEnterpriseUsersWithoutDate: migrated (0.0210s)

ci: == 20230524150438 RemoveIndexUserDetailsOnUserIdForEnterpriseUsersWithDate: migrating
ci: -- transaction_open?()
ci:    -> 0.0000s
ci: -- view_exists?(:postgres_partitions)
ci:    -> 0.0006s
ci: -- indexes(:user_details)
ci:    -> 0.0030s
ci: -- remove_index(:user_details, {:algorithm=>:concurrently, :name=>"index_user_details_on_user_id_for_enterprise_users_with_date"})
ci:    -> 0.0009s
ci: == 20230524150438 RemoveIndexUserDetailsOnUserIdForEnterpriseUsersWithDate: migrated (0.0167s)

ci: == [advisory_lock_connection] object_id: 272040, pg_backend_pid: 27201
bin/rails db:rollback:main RAILS_ENV=test 
main: == [advisory_lock_connection] object_id: 271920, pg_backend_pid: 27586
main: == 20230524150438 RemoveIndexUserDetailsOnUserIdForEnterpriseUsersWithDate: reverting
main: -- transaction_open?()
main:    -> 0.0000s
main: -- view_exists?(:postgres_partitions)
main:    -> 0.0041s
main: -- index_exists?(:user_details, :user_id, {:where=>"provisioned_by_group_id IS NOT NULL AND provisioned_by_group_at IS NOT NULL", :name=>"index_user_details_on_user_id_for_enterprise_users_with_date", :algorithm=>:concurrently})
main:    -> 0.0053s
main: -- execute("SET statement_timeout TO 0")
main:    -> 0.0009s
main: -- add_index(:user_details, :user_id, {:where=>"provisioned_by_group_id IS NOT NULL AND provisioned_by_group_at IS NOT NULL", :name=>"index_user_details_on_user_id_for_enterprise_users_with_date", :algorithm=>:concurrently})
main:    -> 0.0021s
main: -- execute("RESET statement_timeout")
main:    -> 0.0006s
main: == 20230524150438 RemoveIndexUserDetailsOnUserIdForEnterpriseUsersWithDate: reverted (0.0303s)

main: == [advisory_lock_connection] object_id: 271920, pg_backend_pid: 27586
bin/rails db:rollback:ci RAILS_ENV=test 
ci: == [advisory_lock_connection] object_id: 271560, pg_backend_pid: 27979
ci: == 20230524150438 RemoveIndexUserDetailsOnUserIdForEnterpriseUsersWithDate: reverting
ci: -- transaction_open?()
ci:    -> 0.0000s
ci: -- view_exists?(:postgres_partitions)
ci:    -> 0.0175s
ci: -- index_exists?(:user_details, :user_id, {:where=>"provisioned_by_group_id IS NOT NULL AND provisioned_by_group_at IS NOT NULL", :name=>"index_user_details_on_user_id_for_enterprise_users_with_date", :algorithm=>:concurrently})
ci:    -> 0.0057s
ci: -- execute("SET statement_timeout TO 0")
ci:    -> 0.0009s
ci: -- add_index(:user_details, :user_id, {:where=>"provisioned_by_group_id IS NOT NULL AND provisioned_by_group_at IS NOT NULL", :name=>"index_user_details_on_user_id_for_enterprise_users_with_date", :algorithm=>:concurrently})
ci:    -> 0.0025s
ci: -- execute("RESET statement_timeout")
ci:    -> 0.0009s
ci: == 20230524150438 RemoveIndexUserDetailsOnUserIdForEnterpriseUsersWithDate: reverted (0.0544s)

ci: == [advisory_lock_connection] object_id: 271560, pg_backend_pid: 27979
bin/rails db:rollback:main RAILS_ENV=test 
main: == [advisory_lock_connection] object_id: 271540, pg_backend_pid: 28377
main: == 20230524150232 RemoveIndexUserDetailsOnUserIdForEnterpriseUsersWithoutDate: reverting
main: -- transaction_open?()
main:    -> 0.0000s
main: -- view_exists?(:postgres_partitions)
main:    -> 0.0196s
main: -- index_exists?(:user_details, :user_id, {:where=>"provisioned_by_group_id IS NOT NULL AND provisioned_by_group_at IS NULL", :name=>"index_user_details_on_user_id_for_enterprise_users_without_date", :algorithm=>:concurrently})
main:    -> 0.0051s
main: -- execute("SET statement_timeout TO 0")
main:    -> 0.0009s
main: -- add_index(:user_details, :user_id, {:where=>"provisioned_by_group_id IS NOT NULL AND provisioned_by_group_at IS NULL", :name=>"index_user_details_on_user_id_for_enterprise_users_without_date", :algorithm=>:concurrently})
main:    -> 0.0022s
main: -- execute("RESET statement_timeout")
main:    -> 0.0007s
main: == 20230524150232 RemoveIndexUserDetailsOnUserIdForEnterpriseUsersWithoutDate: reverted (0.0452s)

main: == [advisory_lock_connection] object_id: 271540, pg_backend_pid: 28377
bin/rails db:rollback:ci RAILS_ENV=test 
ci: == [advisory_lock_connection] object_id: 271540, pg_backend_pid: 28718
ci: == 20230524150232 RemoveIndexUserDetailsOnUserIdForEnterpriseUsersWithoutDate: reverting
ci: -- transaction_open?()
ci:    -> 0.0000s
ci: -- view_exists?(:postgres_partitions)
ci:    -> 0.0174s
ci: -- index_exists?(:user_details, :user_id, {:where=>"provisioned_by_group_id IS NOT NULL AND provisioned_by_group_at IS NULL", :name=>"index_user_details_on_user_id_for_enterprise_users_without_date", :algorithm=>:concurrently})
ci:    -> 0.0052s
ci: -- execute("SET statement_timeout TO 0")
ci:    -> 0.0008s
ci: -- add_index(:user_details, :user_id, {:where=>"provisioned_by_group_id IS NOT NULL AND provisioned_by_group_at IS NULL", :name=>"index_user_details_on_user_id_for_enterprise_users_without_date", :algorithm=>:concurrently})
ci:    -> 0.0024s
ci: -- execute("RESET statement_timeout")
ci:    -> 0.0007s
ci: == 20230524150232 RemoveIndexUserDetailsOnUserIdForEnterpriseUsersWithoutDate: reverted (0.0490s)

ci: == [advisory_lock_connection] object_id: 271540, pg_backend_pid: 28718

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