[HACKERS] PATCH: psql show index with type info

Поиск
Список
Период
Сортировка
От Amos Bird
Тема [HACKERS] PATCH: psql show index with type info
Дата
Msg-id 87fuiq1wd1.fsf@t450s
обсуждение исходный текст
Ответы Re: [HACKERS] PATCH: psql show index with type info  (Stephen Frost <sfrost@snowman.net>)
Re: [HACKERS] PATCH: psql show index with type info  (Fabien COELHO <coelho@cri.ensmp.fr>)
Список pgsql-hackers
psql currently supports \di+ to view indexes,

                              List of relations
 Schema |        Name        | Type  | Owner |  Table  |  Size  | Description
--------+--------------------+-------+-------+---------+--------+-------------
 public | ii                 | index | amos  | i       | 131 MB |
 public | jj                 | index | amos  | i       | 12 MB  |
 public | kk                 | index | amos  | i       | 456 kB |
 public | numbers_mod2       | index | amos  | numbers | 10 MB  |
 public | numbers_mod2_btree | index | amos  | numbers | 214 MB |
(5 rows)

The co
lumn "Type" is kinda useless (all equals to index). Representing
the actual index type will be more interesting,

 Schema |        Name        |     Type     | Owner |  Table  |  Size  | Description
--------+--------------------+--------------+-------+---------+--------+-------------
 public | ii                 | index: gist  | amos  | i       | 131 MB |
 public | jj                 | index: gin   | amos  | i       | 12 MB  |
 public | kk                 | index: btree | amos  | i       | 456 kB |
 public | numbers_mod2       | index: gin   | amos  | numbers | 10 MB  |
 public | numbers_mod2_btree | index: btree | amos  | numbers | 214 MB |
(5 rows)

I'm not sure where to add documentations about this patch or if needed one. Please help
me if you think this patch is useful.

Best regards,
Amos


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Вложения

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

Предыдущее
От: Petr Jelinek
Дата:
Сообщение: Re: [HACKERS] Logical replication existing data copy
Следующее
От: Michael Banck
Дата:
Сообщение: Re: [HACKERS] Parallel Index Scans