Re: list of extended statistics on psql

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: list of extended statistics on psql
Дата
Msg-id 20200827235323.GA13919@alvherre.pgsql
обсуждение исходный текст
Ответ на Re: list of extended statistics on psql  (Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>)
Ответы Re: list of extended statistics on psql  (Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>)
Re: list of extended statistics on psql  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Список pgsql-hackers
+1 for the general idea, and +1 for \dX being the syntax to use

IMO the per-type columns should show both the type being enabled as
well as it being built.

(How many more stat types do we expect -- Tomas?  I wonder if having one
column per type is going to scale in the long run.)

Also, the stat obj name column should be first, followed by a single
column listing both table and columns that it applies to.  Keep in mind
that in the future we might want to add stats that cross multiple tables
-- that's why the CREATE syntax is the way it is.  So we should give
room for that in psql's display too.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Ranier Vilela
Дата:
Сообщение: Re: Clang Address Sanitizer (Postgres14) Detected Memory Leaks
Следующее
От: Mark Dilger
Дата:
Сообщение: Re: XMAX_LOCK_ONLY and XMAX_COMMITTED (fk/multixact code)