i'm new to elasticsearch, i have more than 2.5 crores of data in elasticsearch index on a single node cluster, when i perform aggregation query it takes lot of time and even get timeout. i think i'm doing something wrong here, please help me.
total index size: 90gb,
each shards holding 3gb of data,
250 SSD ram 28GB