Hi, On 2019-05-06 11:58:18 -0400, Tom Lane wrote: > Not sure though --- generally, if you're looking at a specific > toast table, you already know which table is its parent. But > maybe confirmation is a good thing.
I'm not convinced by that. I've certainly many a time wrote queries against pg_class to figure out which relation a toast table belongs to. E.g. after looking at the largest relations in the system, looking at pg_stat_*_tables, after seeing an error in the logs, etc. > That seems off-topic for this thread though. I agree with the > stated premise that \d on a toast table should show all the same > information \d on a regular table would. +1 Greetings, Andres Freund