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 databse schemas
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.

Seq nr	Name▲	Goal	Type	Data source	Last update	License	...
1	All user schemas	Find all the schemas in the database that are not used for the system purposes.	General	INFORMATION_SCHEMA only	2022-11-04 15:14	MIT License	View
2	Empty schemas	Find schemas without schema objects.	Problem detection	INFORMATION_SCHEMA+system catalog base tables	2022-11-04 15:30	MIT License	View
3	INFORMATION_SCHEMA is missing	Make sure that you do not drop INFORMATION_SCHEMA schema. In this case most of the design checking queries will not work. This schema automatically exists in all databases.	Problem detection	INFORMATION_SCHEMA+system catalog base tables	2022-12-07 19:07	MIT License	View