| From: | Tatsuro Yamada <tatsuro(dot)yamada(dot)tf(at)nttcom(dot)co(dot)jp> |
|---|---|
| To: | Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com> |
| Cc: | Michael Paquier <michael(at)paquier(dot)xyz>, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Julien Rouhaud <rjuju123(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: list of extended statistics on psql |
| Date: | 2020-10-29 01:22:47 |
| Message-ID: | 64f3a33a-c50f-1525-1ae7-2c9bd1652229@nttcom.co.jp_1 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2020-10-29 01:29:30 | Re: [PATCH] SET search_path += octopus |
| Previous Message | Andres Freund | 2020-10-29 01:13:44 | Re: recovering from "found xmin ... from before relfrozenxid ..." |