influxdata / influxdata/influxdb
Each query takes minimum 75 seconds even for 500 entries
- 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
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