Skip to content

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

@srkanthn

Description

@srkanthn

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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions