Re: list of extended statistics on psql

Hi Tomas,

On 2020/10/29 4:07, Tomas Vondra wrote:
> On Wed, Oct 28, 2020 at 04:20:25PM +0900, Tatsuro Yamada wrote:
>> Hi,
>>
>>> Results of \dX and \dX+:
>>> ========================
>>> postgres=# \dX
>>>                             List of extended statistics
>>>     Schema    |   Name    |   Definition    | N_distinct | Dependencies |   Mcv
>>> -------------+-----------+-----------------+------------+--------------+---------
>>>   public      | hoge1_ext | a, b FROM hoge1 | defined    | defined      | defined
>>>   hoge1schema | hoge1_ext | a, b FROM hoge1 | built      | built        | built
>>> (2 rows)
>>
>>
>> I used "Order by 1, 2" on the query but I realized the ordering of
>> result was wrong so I fixed on the attached patch.
>> Please find the patch file. :-D
>>
> 
> Thanks. I'll take a look at the beginning of the 2020-11 commitfest, and
> I hope to get this committed.


Thanks for your reply and I'm glad to hear that.

I'm going to revise the patch as possible to get this committed on
the next commitfest.

Regards,
Tatsuro Yamada