Re: Show estimated number of groups for IncrementalSort in EXPLAIN

From: Enrique Sánchez <enriqueesanchz(at)gmail(dot)com>
To: Ilia Evdokimov <ilya(dot)evdokimov(at)tantorlabs(dot)com>
Cc: PostgreSQL Developers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Show estimated number of groups for IncrementalSort in EXPLAIN
Date: 2026-06-16 22:51:05
Message-ID: CAOCkzAkUgZSDHeR30p1u=wa4rZrLy+yAbFiqqN-4XadKBb=jug@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi, thanks for working on this.

On 10/06/26 17:50, Ilia Evdokimov wrote:

> *Estimated Groups: 100*
>
I think it's useful to know the estimated number of groups to understand
why the planner chooses IncrementalSort. The patch looks clean.

There are no tests for this change, although it should be safe, you might
want to consider adding one to `src/test/regress/sql/incremental_sort.sql`.

Best regards,
Enrique.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2026-06-16 22:57:04 Re: use of SPI by postgresImportForeignStatistics
Previous Message Corey Huinker 2026-06-16 22:50:20 Re: use of SPI by postgresImportForeignStatistics