Skip to content

Add indexes to product_analytics_events_experimental to optimize usage ping queries

The following discussion from !40024 (merged) should be addressed:

  • @a_akgun started a discussion: (+1 comment)

    Thanks @ali-gitlab for the query plans.

    • What are the expected growth for this table gitlab.com for the next few months?
    • I think eventually product_analytics_events_experimental will grow large, and we need to add solid indexes (or partial indexes) for avoiding the "Filters" in the query plans
    • We may do this in an immediately followup MR in 13.4

    Filter: ((product_analytics_events_experimental_39.id >= 10) AND (product_analytics_events_experimental_39.id <= 100,009) AND ((product_analytics_events_experimental_39.se_category)::text = 'epics'::text) AND ((product_analytics_events_experimental_39.se_action)::text = 'promote'::text))