Re: Showing applied extended statistics in explain Part 2 - Mailing list pgsql-hackers

From Ilia Evdokimov
Subject Re: Showing applied extended statistics in explain Part 2
Date
Msg-id 309325bc-a46c-48b5-97b1-18add1451938@tantorlabs.com
Whole thread Raw
In response to Re: Showing applied extended statistics in explain Part 2  (Tatsuro Yamada <yamatattsu@gmail.com>)
List pgsql-hackers
On 05.02.2025 09:28, Tatsuro Yamada wrote:
> Hi All,
>
> Thank you everyone for your cooperation with comments on the patch and 
> solution ideas.
> I am sorting through your review comments now. And after rebasing the 
> patch, I plan to
> send a patch that addresses the comments as much as possible to 
> -hackers by Feb 21 at the latest.
>
> Therefore, the status of the patch for this feature from last month's 
> commit fest will be
> "moving to the next commit fest".
>
> P.S.
> Thanks for letting me know, Ilia.
>
> Thanks,
> Tatsuro Yamada
>

Thank for your work!

Regarding dependency statistics, I noticed that we can't apply them 
individually, which makes it difficult to map specific clauses to 
individual stats. However, why not display the dependency statistics 
above the execution plan as a list? We could format it as a list, but I 
believe it's crucial to highlight when dependency statistics are 
applied, Analyzing dependencies stats often takes the longest compared 
to other statistics, and if users could see the extended statistics for 
dependencies upfront, they might be able to remove them if they're not 
useful for the plan.

--
Best regards,
Ilia Evdokimov,
Tantor Labs LLC.




pgsql-hackers by date:

Previous
From: Bertrand Drouvot
Date:
Subject: Re: per backend WAL statistics
Next
From: Vladlen Popolitov
Date:
Subject: Re: Make COPY format extendable: Extract COPY TO format implementations