Create index to support group direct members count
What does this MR do and why?
Creates index to support count group direct members. The index was created asynchronously over the weekend with !142719 (merged).
related to #439262 (closed) and #423513 (closed)
Migration output
main: == [advisory_lock_connection] object_id: 116560, pg_backend_pid: 44667
main: == 20240129175213 CreateIndexMembersOnSourceAndTypeAndId: migrating ===========
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- view_exists?(:postgres_partitions)
main: -> 0.0022s
main: -- index_exists?(:members, [:source_id, :source_type, :type, :id], {:where=>"invite_token IS NULL", :name=>"index_members_on_source_and_type_and_id", :algorithm=>:concurrently})
main: -> 0.0074s
main: -- execute("SET statement_timeout TO 0")
main: -> 0.0004s
main: -- add_index(:members, [:source_id, :source_type, :type, :id], {:where=>"invite_token IS NULL", :name=>"index_members_on_source_and_type_and_id", :algorithm=>:concurrently})
main: -> 0.0015s
main: -- execute("RESET statement_timeout")
main: -> 0.0005s
main: == 20240129175213 CreateIndexMembersOnSourceAndTypeAndId: migrated (0.0300s) ==
main: == [advisory_lock_connection] object_id: 116560, pg_backend_pid: 44667
MR acceptance checklist
Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.