From: Tom Lane <tgl@sss.pgh.pa.us>
To: Bindra Bambharoliya <bindra.bambharoliya@gmail.com>
cc: Erik Brandsberg <erik@heimdalldata.com>, pgsql-sql@lists.postgresql.org
Subject: Re: Cursor with hold for select takes too long
In-reply-to: 
 <CAPLVUMAtKRFvY5+SdqHdKQ44_X1oQMeLtdz1H7Em8hOJhiVROg@mail.gmail.com>
References: 
 <CAPLVUMDKVU7YmZwUYM=oeXypj-r42++LCqW8aaWXnwPqpSmt6g@mail.gmail.com>
 <CAFcck8HEJa8-53SNWxMd_8D732skiihM4S7YEsEW63swywFosg@mail.gmail.com>
 <CAPLVUMAtKRFvY5+SdqHdKQ44_X1oQMeLtdz1H7Em8hOJhiVROg@mail.gmail.com>
Comments: In-reply-to Bindra Bambharoliya <bindra.bambharoliya@gmail.com>
	message dated "Fri, 22 Mar 2024 23:17:11 +0530"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <986895.1711130253.1@sss.pgh.pa.us>
Date: Fri, 22 Mar 2024 13:57:33 -0400
Message-ID: <986896.1711130253@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/986896.1711130253%40sss.pgh.pa.us>
Precedence: bulk

Bindra Bambharoliya <bindra.bambharoliya@gmail.com> writes:
> Query is like
> Select a.id, sum(b.amount),
> Count(c.am_id) ... from fact.a join fact.b on a.id= b.id join
> Fact.vw_c on a.ida=vw_c.ida group by a.id;

Is the query plan the same for cursor execution as regular?
Compare EXPLAIN SELECT ... versus EXPLAIN DECLARE x CURSOR FOR SELECT ...

(I'm not sure that WITH HOLD would make a difference, so
maybe compare with and without that, too.)

			regards, tom lane