Piwik segment taking some time

I have a piwik installation on a aws c3.large and db on c3.2xlarge. Our database has already grown to 65Gb including archive. Our problem is, its getting slower every and new segments takes longer to complete. Does segmenting creates report from the visitor log? Is there anyway I can improve performance on the current machines? I’ve already tune the machines using How to configure Piwik for speed - Analytics Platform - Piwik

Yes Segments create reports from the visitor log. There are ways to make Piwik faster but it takes time to help you with such complex use case. Contact us at: We offer support subscriptions for businesses worldwide to make the most out of Piwik analytics. - Analytics Platform - Piwik