Slow Sum/Group By over large amount of rows
I would try with an index like:

 echo, yankee, whiskey_india, mike_romeo


Perhaps you can replace your index_unique with:

 "index_unique" UNIQUE, btree (echo, yankee, whiskey_india, mike_romeo, oscar)  


The idea is to put the predicates first in then index, followed by group by columns.