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 full text search
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 7 queries.

Seq nr	Name▲	Goal	Type	Data source	Last update	License	...
1	Columns with tsvector type	Find columns of base tables and materialized views that have tsvector type.	General	INFORMATION_SCHEMA+system catalog base tables	2023-12-22 12:41	MIT License	View
2	Full text search columns that have no gin or gist index	Find columns of base tabels and materialized views with the type tsvector that do not have a gin or a gist index. These are the preferred index types for text search.	Problem detection	INFORMATION_SCHEMA+system catalog base tables	2023-11-07 09:22	MIT License	View
3	Full text search columns with other type of index than gin or gist index	Find columns of base tabels and materialized views with the type tsvector that do not have a gin or a gist index but have another type of index (e.g., b-tree). Gin and Gist are the preferred index types for text search.	Problem detection	INFORMATION_SCHEMA+system catalog base tables	2023-11-07 09:22	MIT License	View
4	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
5	Multiple triggers that update tsvector values	Find base tables that have multiple triggers to update tsvector values.	Problem detection	system catalog base tables only	2023-11-07 10:14	MIT License	View
6	Triggers that are used to calculate tsvector values react to a wrong set of events	Find triggers on base tables that are used to calculate tsvector values that react to a wrong set of events, i.e., react to the DELETE event or do not react to the INSERT and UPDATE events.	Problem detection	system catalog base tables only	2023-11-07 10:14	MIT License	View
7	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