chore: Add indexes to improve reporting performance

chatwoot / chatwoot

Open-source live-chat, email support, omni-channel desk. An alternative to Intercom, Zendesk, Salesforce Service Cloud etc. 🔥💬

https://www.chatwoot.com/help-center

Other

19.46k stars 3.08k forks source link

chore: Add indexes to improve reporting performance #9478

Closed sojan-official closed 1 month ago

sojan-official commented 1 month ago

Adding a new index on (account_id,created_at,message_type) based on our performance improvement exercise. This index significantly improves the page load speeds of messaging reports.

sojan-official commented 1 month ago

note: marked this migration done in production

github-actions[bot] commented 3 days ago

This pull request has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs.