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 718 queries.

Seq nr	Name▲	Goal	Type	Data source	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	MIT License	View
2	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	MIT License	View
3	All clustered indexes	Fin all tables that rows have been physically sorted based on an index.	General	system catalog base tables only	MIT License	View
4	All column DEFAULT values	Fidnd all the default values of base table, view, and foreign table columns.	General	INFORMATION_SCHEMA only	MIT License	View
5	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	MIT License	View
6	All covering indexes	Find all covering indexes, which include data from additional columns in leaf blocks.	General	INFORMATION_SCHEMA+system catalog base tables	MIT License	View
7	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	MIT License	View
8	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	MIT License	View
9	All domains	Find all domains.	General	INFORMATION_SCHEMA only	MIT License	View
10	All event triggers	Find event triggers, which are not associated to a specific schema object.	General	system catalog base tables only	MIT License	View
11	All exclude constraints	Find all exclude constraints.	General	system catalog base tables only	MIT License	View
12	All foreign key constraints	Enforce referential integrity in database. Find all referential integrity (foreign key) constraints.	General	system catalog base tables only	MIT License	View
13	All foreign tables	Find all foreign tables.	General	INFORMATION_SCHEMA only	MIT License	View
14	All gin indexes	Find indexes with less common access methods. Gin indexes are, for instance, used to speed up PostgreSQL's built in full text search.	General	INFORMATION_SCHEMA+system catalog base tables	MIT License	View
15	All identifying relationships	Find all identifying relationships where the foreign key (a set of columns) is a subset of the primary key of the table.	General	system catalog base tables only	MIT License	View
16	All key constraints	Find all the primary key and unique constraints of base tables.	General	system catalog base tables only	MIT License	View
17	All non-identifying relationships	Find all non-identifying relationships where the foreign key (a set of columns) is not a subset of the primary key of the table.	General	system catalog base tables only	MIT License	View
18	All non-unique indexes	Find secondary indexes that have been created in the database.	General	INFORMATION_SCHEMA+system catalog base tables	MIT License	View
19	All parameters with DEFAULT values	Find parameters of user-defined routines that have a default value.	General	INFORMATION_SCHEMA+system catalog base tables	MIT License	View
20	All partial indexes	Find indexes to a subset of table rows.	General	INFORMATION_SCHEMA+system catalog base tables	MIT License	View

	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?