In trigger table now exist index by value (triggers_2)
But if change it to value and lastchange. Performance in maps will be improved up to 10 times.
As example see ZBX-8232
Performance issue in maps
Monitoring->triggers page is too slow on systems with a lot of triggers because of seq scan of triggers table
Slow SQL Query