PostgreSQL Design Check Queries

Catalog of PostgreSQL queries for finding information about a PostgreSQL database and its design problems

	Choose collection:
AND	Choose query type:
AND	Choose query reliability:
AND	Choose category:	Queries of this category provide information about The Oversized-Attribute Storage Technique.
AND	Choose data source:	From where does the query gets its information?
AND	Enter string:
AND	Has fixing queries?

All the queries about database objects contain a subcondition to exclude from the result information about the system catalog.
Although the statements use SQL constructs (common table expressions; NOT in subqueries) that could cause performance problems in case of large datasets it shouldn't be a problem in case of relatively small amount of data, which is in the system catalog of a database.
Statistics about the catalog content and project home in GitHub that has additional information.

There are 7 queries.

Seq nr	Name▲	Goal	Type	Data source	Last update	License	...
1	All system-defined TOAST-able types	Find system-defined types in case of which the system can use the TOAST technique, i.e., save the value in a compressed form or store it in a automatically-created secondary table, which is hidden from the database user (TOAST table).	General	system catalog base tables only	2020-11-06 14:51	MIT License	View
2	All user-defined TOAST-able types	Find user-defined types in case of which the system can use the TOAST technique, i.e., save the value in a compressed form or store it in a automatically-created secondary table, which is hidden from the database user (TOAST table).	General	system catalog base tables only	2020-11-06 14:51	MIT License	View
3	Base table columns where TOASTing is possible	Find all base table columns in case of which the system can use TOAST technique.	General	system catalog base tables only	2020-11-06 14:51	MIT License	View
4	Base table columns where TOAST-ing strategy has been changed	Find base table columns in case of which the system can use TOAST technique (due to the data type of the column) and where the toasting strategy has been changed so that it is different than the default strategy determined by the type. Make sure that the new strategy is optimal.	General	system catalog base tables only	2020-11-06 14:51	MIT License	View
5	Base table columns where TOAST-ing strategy has been changed to plain	Find base table columns in case of which the system can use TOAST technique (due to the data type of the column) and where the toasting strategy has been changed to plain. It means that potentially, if a value in the column is large enough, it is not possible to save the row.	Problem detection	system catalog base tables only	2021-02-25 17:29	MIT License	View
6	Base tables that do not have a TOAST table	Find base tables that (due to the types of their columns) do not have an associated TOAST table for storing out-of-line data.	General	system catalog base tables only	2020-11-06 14:51	MIT License	View
7	Minimum tuple length required before trying to move long column values into TOAST tables has been changed	Find base tables in case of which toast_tuple_target storage parameter value is not the default value (2040). "Changing this value may not be useful for very short or very long rows. Note that the default setting is often close to optimal, and it is possible that setting this parameter could have negative effects in some cases. " Make sure that the parameter has an optimal value.	General	INFORMATION_SCHEMA+system catalog base tables	2020-11-06 14:51	MIT License	View