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 generated stored base table columns.
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 6 queries.

Seq nr	Name▲	Goal	Type	Data source	Last update	License	...
1	Duplicate stored generated base table columns	Find base tables that have more than one stored generated column with the same expression. The support of generated columns was added to PostgreSQL 12. 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	INFORMATION_SCHEMA only	2021-02-25 17:30	MIT License	View
2	Generated stored base table columns	Find generated stored columns in PostgreSQL base tables. The support of generated columns was added to PostgreSQL 12. These could be used to improve the performance of queries.	General	INFORMATION_SCHEMA only	2020-11-06 14:51	MIT License	View
3	Generated stored base table columns duplicates another column in the table	Find generated stored columns in PostgreSQL base tables that duplicate other columns in the table.	Problem detection	INFORMATION_SCHEMA only	2021-02-25 17:30	MIT License	View
4	Generated stored base table columns that expression does not refer to any column	Find generated stored base table columns that expression does not refer to any column of the table. It could be that there will be a constant value in every row in case of this column. The support of generated columns was added to PostgreSQL 12.	Problem detection	INFORMATION_SCHEMA only	2021-02-25 17:29	MIT License	View
5	Inconsistent means to calculate tsvector values	Find as to whether in the database there are multiple ways to calculate tsvector values, i.e., by using a generated column and by not using a generated column.	Problem detection	INFORMATION_SCHEMA only	2023-11-07 11:35	MIT License	View
6	Tsvector values are not automatically calculated	Find base table columns with tsvector type in case of which it is not a generated column nor does the table has an associated trigger to calculate the tsvector value automatically.	Problem detection	INFORMATION_SCHEMA+system catalog base tables	2023-11-07 11:45	MIT License	View