[Stack Monitoring] Request paginated index stats from ES

[matschaffer]

elastic/elasticsearch#87555 is open to add paging to the index stats API.

Once it's available, we should update metricbeat to issue paged queries to timing out on very large responses.

[original-brownbear]

@matschaffer as discussed linking elastic/elasticsearch#87555 here for the suggested approach to paginating the index stats API.

[botelastic]

Hi!
We just realized that we haven't looked into this issue in a while. We're sorry!

We're labeling this issue as Stale to make it hit our filters and make sure we get back to it as soon as possible. In the meantime, it'd be extremely helpful if you could take a look at it as well and confirm its relevance. A simple comment with a nice emoji will be enough :+1.
Thank you for your contribution!