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 extensions in the database.
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	Do not create user-defined routines that have the same name as some installed extension routine	Avoid creating user-defined routines that have the same name as some extension routine because it may cause confusion.	Problem detection	INFORMATION_SCHEMA+system catalog base tables	2021-10-25 16:14	MIT License	View
2	Extension routines	Find all routines that belong to an extension.	General	system catalog base tables only	2020-11-06 14:51	MIT License	View
3	Extension routines in the schema "public"	Find extensions that routines are in the schema public.	General	system catalog base tables only	2024-01-04 11:56	MIT License	View
4	Extension routines that execution privilege has been granted to PUBLIC	Know the privileges that users have in your system. Probably all the database users do not need these privileges.	Problem detection	INFORMATION_SCHEMA+system catalog base tables	2021-02-25 17:30	MIT License	View
5	Extensions that are available but are not installed	Try to use as much the possibilities of the DBMS as possible. On the other hand, do not install extensions that are not needed in order not to overcomplicate the database.	General	system catalog base tables only	2020-11-06 14:51	MIT License	View
6	Installed extensions	Try to use as much the possibilities of the DBMS as possible. On the other hand, do not install extensions that are not needed in order not to overcomplicate the database.	General	system catalog base tables only	2020-11-06 14:51	MIT License	View