Re: On disable_cost - Mailing list pgsql-hackers

From Laurenz Albe
Subject Re: On disable_cost
Date
Msg-id 1871ece0cc369fddcf89a4e1cbb778db75e2e8c6.camel@cybertec.at
Whole thread Raw
In response to Re: On disable_cost  (Alena Rybakina <a.rybakina@postgrespro.ru>)
Responses Re: On disable_cost
List pgsql-hackers
On Tue, 2024-10-08 at 18:12 +0300, Alena Rybakina wrote:
> > > However you are right that this display will not appear for all
> > > nodes that only contain a data collection procedure, such as Append,
> > > MergeAppend, Gather, etc. And I agree with you that we should
> > > information about it. I also think it’s worth adding additional
> > > information that this option does not appear in the postgres_fdw
> > > extension.
> >
> > I cannot quite follow that either...
>
> I meant this [0].
> [0] https://www.postgresql.org/message-id/CAApHDvpMyKJpLGWRmR3%2B3g4DxrSf6iRpwTRCXMorU0HvgWbocw%40mail.gmail.com
>
> Th disabled description won't display if the MergeAppend and Append
> nodes are used in the query plan. I tried to generalize it, but without
> success. I'm not sure that these nodes can be called accumulating data.
> But I tried to describe this case in the documentation.

You mean you rediscovered the bug that David's patch fixes?

> About postgres_fdw extension disabled nodes won't show [1]. I think we
> should add information about it too.
>
> [1] https://www.postgresql.org/message-id/CA%2BTgmoZRwy8202vxbUPBeZd_Tx5NYVtmpvBnJnOzZS3b81cpkg%40mail.gmail.com

You cannot disable a foreign scan...

Or do you want to see "disabled" if the remote query uses a disabled node?
I think that would be out of scope...

Yours,
Laurenz Albe



pgsql-hackers by date:

Previous
From: Alena Rybakina
Date:
Subject: Re: Add parallel columns for seq scan and index scan on pg_stat_all_tables and _indexes
Next
From: Bertrand Drouvot
Date:
Subject: Re: per backend I/O statistics