# How query index data and indexed data

**URL:** <https://discuss.elastic.co/t/how-query-index-data-and-indexed-data/360537>\
**Category:** Elasticsearch\
**Created:** [May 30, 2024, 7:08am UTC](https://discuss.elastic.co/t/how-query-index-data-and-indexed-data/360537 "2024-05-30T07:08:44Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Andy\_Cong](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/andy_cong/32/134851_2.png) [@Andy\_Cong](https://discuss.elastic.co/u/Andy_Cong)\
**Post date:** [May 30, 2024, 7:08am UTC](https://discuss.elastic.co/t/how-query-index-data-and-indexed-data/360537/1 "2024-05-30T07:08:44Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\
**Post date:** [May 30, 2024, 7:46am UTC](https://discuss.elastic.co/t/how-query-index-data-and-indexed-data/360537/2 "2024-05-30T07:46:51Z")

</div>

> [@Andy\_Cong](#):
>
> I want to query an index table data and for other data related to this table, such as indexed data.

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.

> [@Andy\_Cong](#):
>
> I want to estimate how much disk storage capacity is needed based on the growth of index 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.

---

<div class="post-metadata">

**Author:** ![Andy\_Cong](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/andy_cong/32/134851_2.png) [@Andy\_Cong](https://discuss.elastic.co/u/Andy_Cong)\
**Post date:** [June 3, 2024, 11:49am UTC](https://discuss.elastic.co/t/how-query-index-data-and-indexed-data/360537/3 "2024-06-03T11:49:03Z")

</div>

**POST /xxx/\_disk\_usage?run\_expensive\_tasks=true**  
It can query the very detail data on disk.