SELECT Query taking time WITH Sequence

From: Daulat <daulat(dot)dba(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: SELECT Query taking time WITH Sequence
Date: 2025-03-12 17:05:35
Message-ID: CALfOM6K4u1=giocgfSy04JKvhN4YxKWuvSfe4Z1+7LFk1zXSFw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi Team,

The SELECT query takes around 4 minutes to complete when fetching data from
the tables using a sequence, but without the sequence, the same query takes
only a few seconds."

Anyone please help me with what I need to take care of.

Thanks,

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2025-03-12 17:08:17 Re: SELECT Query taking time WITH Sequence
Previous Message Achilleas Mantzios - cloud 2025-03-12 13:58:32 Re: People obsessed with docker - how can I help?