vishesh92 commented on PR #8737: URL: https://github.com/apache/cloudstack/pull/8737#issuecomment-1995638271
I have removed the index on `timestamp`. The index on `(vm_id, timestamp)` should help with faster listing of metrics for a vm. As @rohityadavcloud said this index helped bring down the latency from 15s to 1s in one of our environments. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@cloudstack.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org