Hello,

First off, thank you for the advice in SA ID: SA-21927 (https://community.pega.com/support/support-articles/ftsincrementalindexer-agent-queue-size-large) The problem actually occured at my site, so I am especially appreciative. Begging your pardon, there is a small error in the SQL posted in the resolution section. I have included a correction below.

Cheers,
Elliott

The Resolution contains this SQL

select count(pxworkkey), pxworkclass from pr_sys_queue_ftsindexer group by pxworkclass order by pxworkkey ASC

That fails. I think the author meant to order by count(pxWorkKey) so that the results show the count of entries for each class:

select count(pxworkkey), pxworkclass from pr_sys_queue_ftsindexer
group by pxworkclass order by count(pxworkkey) DESC;