# Size limitation

**URL:** <https://discuss.elastic.co/t/size-limitation/224696>\
**Category:** Kibana\
**Tags:** canvas\
**Created:** [March 23, 2020, 5:06pm UTC](https://discuss.elastic.co/t/size-limitation/224696 "2020-03-23T17:06:41Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![preetish\_P](https://avatars.discourse-cdn.com/v4/letter/p/77aa72/32.png) [@preetish\_P](https://discuss.elastic.co/u/preetish_P)\
**Post date:** [March 27, 2020, 1:55pm UTC](https://discuss.elastic.co/t/size-limitation/224696/2 "2020-03-27T13:55:57Z")

</div>

Hi @wadhah ,

The 10000 records limit in es-sql causes hindrance, if you are pulling the entire record set in SQL and aggregating on the 'Display' tab . Instead you can use aggregate functions within the SQL.

In your case you can use the below SQL:  
`SELECT SUM(Costs) AS sum FROM \"test*\" WHERE Costs IS NOT NULL`

This is is equivalent to using the 'exists' filter on discover tab.

---

_[View the full topic](https://discuss.elastic.co/t/size-limitation/224696)._