如何查看TOAST表的扩展表

郑全

比如建立了一个TOAST表:TOAST_T1，想找他的扩展表，可以通过以下方式找到扩展表：

select relname,reltoastrelid::regclass
  from pg_class
where relname='toast_t1';
relname  |      reltoastrelid      
----------+-------------------------
toast_t1 | pg_toast.pg_toast_17623
(1 row)

zlcost=# \d+ pg_toast.pg_toast_17623
TOAST table "pg_toast.pg_toast_17623"
   Column   |  Type   | Storage
------------+---------+---------
chunk_id   | oid     | plain
chunk_seq  | integer | plain
chunk_data | bytea   | plain
Owning table: "sztech.toast_t1"
Indexes:
    "pg_toast_17623_index" PRIMARY KEY, btree (chunk_id, chunk_seq)
Access method: heap