| From: | Justin Pryzby <pryzby(at)telsasoft(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | make \d pg_toast.foo show its indices |
| Date: | 2019-04-22 15:49:02 |
| Message-ID: | 20190422154902.GH14223@telsasoft.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
It's deliberate that \dt doesn't show toast tables.
\d shows them, but doesn't show their indices.
It seems to me that their indices should be shown, without having to think and
know to query pg_index.
postgres=# \d pg_toast.pg_toast_2600
TOAST table "pg_toast.pg_toast_2600"
Column | Type
------------+---------
chunk_id | oid
chunk_seq | integer
chunk_data | bytea
Indexes:
"pg_toast_2600_index" PRIMARY KEY, btree (chunk_id, chunk_seq)
Justin
| Attachment | Content-Type | Size |
|---|---|---|
| slash-d-show-indices-on-toast.patch | text/x-diff | 518 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2019-04-22 15:50:49 | Re: finding changed blocks using WAL scanning |
| Previous Message | Bruce Momjian | 2019-04-22 15:48:21 | Re: finding changed blocks using WAL scanning |