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:	Overview of some aspect of the database.
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 221 queries.

Seq nr	Name▲	Goal	Type	Data source	Last update	License	...
1	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
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	2020-11-06 14:51	MIT License	View
3	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
4	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
5	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
6	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
7	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
8	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
9	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
10	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
11	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
12	All domains	Find all domains.	General	INFORMATION_SCHEMA only	2020-11-10 11:49	MIT License	View
13	All enumerated types	Find all enumerated types.	General	INFORMATION_SCHEMA+system catalog base tables	2022-10-31 10:19	MIT License	View
14	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
15	All exclude constraints	Find all exclude constraints.	General	system catalog base tables only	2021-12-16 11:21	MIT License	View
16	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
17	All foreign tables	Find all foreign tables.	General	INFORMATION_SCHEMA only	2020-11-06 15:20	MIT License	View
18	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	2020-11-06 14:51	MIT License	View
19	All identifying relationships	Find all non-identifying relationships where the foreign key (a set of columns) is a subset of a uniqueness constraint (primary key, unique, or exclude constraint).	General	system catalog base tables only	2023-11-01 11:32	MIT License	View
20	All key constraints	Find all the primary key and unique constraints of base tables.	General	system catalog base tables only	2021-10-16 10:37	MIT License	View