# Performance in Influxdb 1.8

**URL:** <https://community.influxdata.com/t/performance-in-influxdb-1-8/14608>\
**Category:** Store\
**Tags:** influxdb, performance\
**Created:** [June 1, 2020, 2:22pm UTC](https://community.influxdata.com/t/performance-in-influxdb-1-8/14608 "2020-06-01T14:22:31Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![cova](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/cova/32/3483_2.png) [@cova](https://community.influxdata.com/u/cova)\
**Post date:** [June 1, 2020, 2:22pm UTC](https://community.influxdata.com/t/performance-in-influxdb-1-8/14608/1 "2020-06-01T14:22:31Z")

</div>

Deal all,

I’m doing a proof of concept with Influxdb + Grafana for a monitoring platform. After implementing it for a small data subset, when I loaded an entire day for analysis, influxdb takes a long time to execute the queries (high CPU consumption - starvation and excessive memory consumption - TSI in use).  
The server has 4 CPUs and 16GB of memory.

My essential question should I have better performance that I have currently for about 3 million points / day?

> SHOW SERIES CARDINALITY  
> cardinality estimation

* * *

3180978

Example of slowness:

This query is taking 24 seconds:  
Jun 1 15:13:02 server1 influxd: ts=2020-06-01T14:13:02.022081Z lvl=info msg=“Executing query” log\_id=0N82ObTW000 service=query query=“SELECT mean(total\_duration) FROM performance.autogen.emas WHERE time \>= 1590369394686ms AND time \<= 1590370358767ms GROUP BY time(1m)”  
Jun 1 15:13:26 server1 influxd: [httpd] ::1 - - [01/Jun/2020:15:13:02 +0100] "POST /query?chunked=true

It returns 17 records:  
select count(\*) from (SELECT mean(total\_duration) FROM performance.autogen.emas WHERE time \>= 1590369394686ms AND time \<= 1590370358767ms GROUP BY time(1m));  
name: emas  
time count\_mean

* * *

0 17

This behaviour is common for all queries. From grafana is even worst - maybe because of fetch(?) and rendering charts?

Thanks in advance