influxdata / influxdata/influxdb

Each query takes minimum 75 seconds even for 500 entries

Open
#23,833 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Rust
Stars
31.7k
Forks
3.7k
Avg merge
13h 37m
Merged PRs (30d)
8

Description

Hello everyone,

I have a bucket which has in total around 40.000 entries, I use 2 tags and 3 fields (and I have 3 measurements).
Each time I make any operation on this bucket it takes a minimum of 75 seconds. If I activate debug I can clearly see that after the http connection was open nothing happens for approx. 60 seconds. If I check the journaling system from the server I can see the request after aprox. 60 seconds.

Even if in the logs on the server I can see information like:
`stat_total_duration=14.311ms stat_compile_duration=0.380ms stat_execute_duration=13.851ms stat_max_allocated=30968 stat_total_allocated=0`

Still takes a lot of time to get the answer, which can contains 500 sometimes or 14.000 entries.

The current configuration:
>>> User-Agent: influxdb-client-python/1.33.0

<<< X-Influxdb-Build: OSS
<<< X-Influxdb-Version: v2.4.0
The server has 4 vCPU and 8 GB Ram, the CPU load is between 1 - 10%, and memory load is 800 MB.

Contributor guide

Open the contributing guide

Research direction

No source file, test, or entry point is named. Start by reproducing the delay with influxdb-client-python 1.33.0 against InfluxDB OSS v2.4.0, then compare the client wait with the server journal and query timing; done means identifying the source of the approximately 60-second gap and resolving it.

Written by the indexing model from the issue text.

Assessment

Tech stack
python
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.