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 possible data redunancy.
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	Duplicate materialized views	Find materialized views with exactly the same subquery. There should not be multiple materialized views with the same subquery. Do remember that the same task can be solved in SQL usually in multiple different ways. Thus, the exact copies are not the only possible duplication.	Problem detection	system catalog base tables only	2021-02-25 17:30	MIT License	View
2	Pairs of base tables that have at least two columns with the same names and data types	What are the pairs of base tables that have at least two columns with the same names and data types. The tables might violate the principle of orthogonal design and hence might facilitate uncontrolled data redundancy over different tables.	Problem detection	INFORMATION_SCHEMA only	2022-11-09 13:13	MIT License	View
3	Tables with the same name in different schemas	Find tables with the same name in different schemas. Make sure that this is not a duplication.	General	INFORMATION_SCHEMA+system catalog base tables	2021-11-10 15:40	MIT License	View