How I can do a query to count the comments where a user is mentioned?

Wilmer Caiza_zp7ox9

I tried the query below, but our jiraaction table has around 30 million records and it takes around 10 minutes to execute by each user.
I need to consider de archived issues for this reason I can't use JQL.

select count (id) from jiraaction ja where ja.actionbody like '%~userFilter%';

 

If you have any ideas I appreciate.

 

Thanks.

 

 

Mirek

Hi @Wilmer Caiza 

Maybe this could be helpful to get more accurate (and faster) query

https://confluence.atlassian.com/jirakb/how-to-find-all-the-comments-related-to-one-user-in-the-database-385909306.html