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:
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 974 queries.

Seq nr	Name▲	Goal	Type	Data source	Last update	License	...
1	Address field size is incorrect (too short or too long)	Find base table columns that are meant for recording different types of addresses where the filed size does not take into account the possible maximum length.	Problem detection	INFORMATION_SCHEMA only	2023-11-09 12:55	MIT License	View
2	A getter does not return a value	Find user-defined SQL and PL/pgSQL routines that do not return a value although the name suggest that it should return a value (starts with "get").	Problem detection	INFORMATION_SCHEMA+system catalog base tables	2023-01-06 14:24	MIT License	View
3	A large number of triggers	Show user-defined triggers if there are more than 9 different trigger routine bodies, i.e., different triggers on different tables that do the same thing count as one trigger.	General	INFORMATION_SCHEMA+system catalog base tables	2023-12-25 11:23	MIT License	View
4	All CHECK constraints of domains that are not associated with any table	Find all CHECK constraints (except NOT NULL) of domains that are not associated with any column.	General	INFORMATION_SCHEMA only	2020-11-06 14:51	MIT License	View
5	All clustered indexes	Find all tables that rows have been physically sorted based on an index.	General	system catalog base tables only	2022-10-31 10:17	MIT License	View
6	All column DEFAULT values	Find all the default values of base table, view, and foreign table columns.	General	INFORMATION_SCHEMA only	2022-10-31 10:18	MIT License	View
7	All column dynamic DEFAULT values values that do not invoke a sequence	Find all columns that have a dynamic default value, i.e., the value is returned by a function but the function is not for invoking a sequence.	General	INFORMATION_SCHEMA only	2021-11-15 15:57	MIT License	View
8	All columns of a base table have a default value	Find base tables where all the columns have a default value.	Problem detection	INFORMATION_SCHEMA only	2021-02-25 17:29	MIT License	View
9	All column static DEFAULT values	Find all columns that have a static default value, i.e., the value is not returned by a function.	General	INFORMATION_SCHEMA only	2021-11-15 15:57	MIT License	View
10	All covering indexes	Find all covering indexes, which include data from additional columns in leaf blocks.	General	INFORMATION_SCHEMA+system catalog base tables	2020-12-23 11:54	MIT License	View
11	All database privileges	Find the privileges to use the database. c - CONNECT; C - CREATE; T - TEMPORARY.	General	system catalog base tables only	2021-11-23 20:28	MIT License	View
12	All declaratively partitioned tables	Find partitioned tables that have been implemented by using the declarative approach. Declarative partitioning is implemented in PostgreSQL starting from PostgreSQL 10.	General	INFORMATION_SCHEMA+system catalog base tables	2020-11-06 15:13	MIT License	View
13	All derived tables that use joining tables	Find all derived tables that join two or more tables.	General	INFORMATION_SCHEMA+system catalog base tables	2024-10-05 18:34	MIT License	View
14	All domain default values	Find domains that specify a default values and columns that are defined based on the domain. Make sure that there are no unsuitable default values.	General	INFORMATION_SCHEMA only	2021-01-19 13:04	MIT License	View
15	All domains	Find all domains.	General	INFORMATION_SCHEMA only	2020-11-10 11:49	MIT License	View
16	All enumerated types	Find all enumerated types.	General	INFORMATION_SCHEMA+system catalog base tables	2022-10-31 10:19	MIT License	View
17	All event triggers	Find event triggers, which are not associated to a specific schema object.	General	system catalog base tables only	2020-12-24 14:54	MIT License	View
18	All exclude constraints	Find all exclude constraints.	General	system catalog base tables only	2021-12-16 11:21	MIT License	View
19	All foreign key constraints	Enforce referential integrity in database. Find all referential integrity (foreign key) constraints.	General	system catalog base tables only	2023-12-07 12:48	MIT License	View
20	All foreign tables	Find all foreign tables.	General	INFORMATION_SCHEMA only	2020-11-06 15:20	MIT License	View