Hi，andybody.
I want to query an index table data and for other data related to this table, such as indexed data.
I want to estimate how much disk storage capacity is needed based on the growth of index data.
How can I do that?
It is not clear to me what you mean by this. Note that Elasticsearch does not support joins like relational databases do so this is something that is likely to affect how you structure, index and query data.
The ratio between the raw size of the data ingested and the size this takes up on disk depends on a number of factors, e.g. the data itself, mappings used, index settings, shard size etc. I would recommend creating an index with the mappings and setting you will use in production and then index a good, realistic amount of real data (ideally at least a GB of data if you have large amounts of data) into it and then measure the exact ratio for your use case.
1 Like
POST /xxx/_disk_usage?run_expensive_tasks=true
It can query the very detail data on disk.