Re: Showing applied extended statistics in explain Part 2

From: Ilia Evdokimov <ilya(dot)evdokimov(at)tantorlabs(dot)com>
To: Tatsuro Yamada <yamatattsu(at)gmail(dot)com>
Cc: Masahiro(dot)Ikeda(at)nttdata(dot)com, tomas(dot)vondra(at)enterprisedb(dot)com, tatsuro(dot)yamada(at)ntt(dot)com, pgsql-hackers(at)postgresql(dot)org, Masao(dot)Fujii(at)nttdata(dot)com, Andrei Lepikhov <lepihov(at)gmail(dot)com>
Subject: Re: Showing applied extended statistics in explain Part 2
Date: 2025-02-05 15:19:44
Message-ID: 309325bc-a46c-48b5-97b1-18add1451938@tantorlabs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Vladlen Popolitov 2025-02-05 15:26:14 Re: Make COPY format extendable: Extract COPY TO format implementations
Previous Message Bertrand Drouvot 2025-02-05 14:28:08 Re: per backend WAL statistics