On this link there is a better explanation of Log Insight storage.
https://blogs.vmware.com/management/2020/05/vrealize-log-insight-index-partitions-and-variable-reten...