I have a k8s cluster with autoscale. I want to query the last time there was a change in the number of nodes in my cluster (for example, 1 hour ago i had 20 and now the cluster grew to 25), and get a list of the nodes added to the cluster.
right now, I have two lists of nodes comparing now and 1 hour ago, using the next query:
SELECT uniques(hostname) as ‘number of hosts’ FROM K8sNodeSample COMPARE WITH 1 day ago where clusterName=‘my_cluster’
But with that I have two problems: first, It doesnt show the new nodes, it shows all of the existing nodes
and second, the lists doesnt show the times of growth, it shows two different times i picked.
any ideas in this subject?