Request a Demo
Home   >   mailing lists

Re: Show estimated number of groups for IncrementalSort in EXPLAIN - Mailing list pgsql-hackers

From Ilia Evdokimov
Subject Re: Show estimated number of groups for IncrementalSort in EXPLAIN
Date
Msg-id 700a3c59-804a-44d0-8b3a-6bb1d28733c3@tantorlabs.com
Whole thread
In response to Re: Show estimated number of groups for IncrementalSort in EXPLAIN  (Enrique Sánchez <enriqueesanchz@gmail.com>)
List pgsql-hackers
Tree view

On 6/17/26 01:51, Enrique Sánchez wrote:

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`.

Memoize has similar planner estimation output in EXPLAIN, but has no regression tests for it either. Besides, in `inremental_sort` test all EXPLAIN calls use COSTS OFF, so the new line would not appear there at all. To be honest, I don't see any reason to display it in regression tests.

--
Best regards,
Ilia Evdokimov,
Tantor Labs LLC,
https://tantorlabs.com/

pgsql-hackers by date:

Previous
From: Ewan Young
Date:
Subject: Re: btree_gist: Fix NaN handling in float4 and float8 opclasses
Next
From: Nisha Moond
Date:
Subject: Re: [PATCH] Preserve replication origin OIDs in pg_upgrade