Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Index scan is not happening on tables in data nodes in multi node architecture #119

Open
srkanthn opened this issue Feb 16, 2023 · 0 comments

Comments

@srkanthn
Copy link

I have a 2 server Database setup with timescale installed, one server has 1 access node and another server has 2 data nodes.

I have a query that joins tables in the access node and data node and I am trying to fetch a few million rows over a few days range.
The query takes 20 minutes to run and I observed Custom Scan/Data Node scan is happening instead of Index Scan.
We ingest more than a million rows every 5 minutes (40GB per day)

Example:
-> Custom Scan (AsyncAppend) (cost=101.33..35936027.84 rows=29464 width=24) (actual time=428.564..5473.172 rows=7254167 loops=1)

I would like to know if this is a limitation of Timescale DB or I am missing something.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant