On Wed, 2025-03-12 at 22:35 +0530, Daulat wrote:
> 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.
Start with a useful problem report.
You cannot access a table using a sequence. Perhaps you are talking about a sequential scan.
What is the table definition, the query and its EXPLAIN (ANALYZE, BUFFERS) output?
Yours,
Laurenz Albe