Adds Service Desk custom email enabled to Service Ping

Feature context

Custom email for Service Desk allows customers to use their own email address for support communication. They forward all emails to the project-specific service desk email address (generated from incoming_email) and provide their SMTP credential for the custom email address. We send all outgoing Service Desk emails using the provided credentials.

What does this MR do and why?

Adds Service Desk custom email enabled to Service Ping

1. Adds an index to the service_desk_settings.custom_email_enabled column
2. Adds the counts.service_desk_custom_email_enabled metric to Service Ping. Provides the number of projects that have Service Desk custom email enabled.

Database review

Query for metric

SELECT COUNT(*) 
FROM "service_desk_settings" 
WHERE "service_desk_settings"."custom_email_enabled" = TRUE

Plan without index

Aggregate  (cost=1516.72..1516.73 rows=1 width=8)  
  ->  Seq Scan on service_desk_settings  (cost=0.00..1516.67 rows=21 width=0)  
        Filter: custom_email_enabled  

Plan with index

Ran create index:

exec CREATE INDEX CONCURRENTLY index_service_desk_settings_on_custom_email_enabled ON service_desk_settings(custom_email_enabled);

Aggregate  (cost=3.71..3.72 rows=1 width=8)  
  ->  Index Only Scan using index_service_desk_settings_on_custom_email_enabled on service_desk_settings  (cost=0.29..3.66 rows=21 width=0)  
        Index Cond: (custom_email_enabled = true) 

Screenshots or screen recordings

🚫

How to set up and validate locally

🚫

MR acceptance checklist

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

• I have evaluated the MR acceptance checklist for this MR.