Poor performance on default instance

I loaded up 13 million rows for test to see if this DB is something I can use.

I am back filling 3 years worth of data and after loading around 13M rows I am getting this for a simple count. 15 minutes to select count 13M rows…

In general the query performance is not very good.

The system is a 24 core / dual xeon cpu with SSD. I am not running any other queries and the system is generally idle. Nothing in the logs point to an issue and the linux syslog are normal.

I do not have that much experience with time series database so perhaps the performance is normal ?

time influx -database ‘test’ -execute 'select count(*) from test’
name: test
time count_value

0 13833700

real 15m7.975s
user 0m0.004s
sys 0m0.004s

@telco5 Can you share the schema of your data? Query performance will depend on what the underlying data looks like.