Re: list of extended statistics on psql - Mailing list pgsql-hackers

From Tatsuro Yamada
Subject Re: list of extended statistics on psql
Date
Msg-id 64f3a33a-c50f-1525-1ae7-2c9bd1652229@nttcom.co.jp_1
Whole thread Raw
In response to Re: list of extended statistics on psql  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
List pgsql-hackers
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






pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: recovering from "found xmin ... from before relfrozenxid ..."
Next
From: Andres Freund
Date:
Subject: Re: [PATCH] SET search_path += octopus