Skip to content

Create index to support group direct members count

Felipe Artur requested to merge issue_439262 into master

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.

Merge request reports