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
