Catalog of PostgreSQL queries for finding information about a PostgreSQL database and its design problems

ANDFrom where does the query gets its information?

There are 961 queries.

Seq nrNameGoalTypeData sourceLast updateLicense...
1Address 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 detectionINFORMATION_SCHEMA only2023-11-09 12:55MIT License
2A getter does not return a valueFind user-defined SQL and PL/pgSQL routines that do not return a value although the name suggest that it should return a value (starts with "get").Problem detectionINFORMATION_SCHEMA+system catalog base tables2023-01-06 14:24MIT License
3A large number of triggersShow 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.GeneralINFORMATION_SCHEMA+system catalog base tables2023-12-25 11:23MIT License
4All CHECK constraints of domains that are not associated with any tableFind all CHECK constraints (except NOT NULL) of domains that are not associated with any column.GeneralINFORMATION_SCHEMA only2020-11-06 14:51MIT License
5All clustered indexesFind all tables that rows have been physically sorted based on an index.Generalsystem catalog base tables only2022-10-31 10:17MIT License
6All column DEFAULT valuesFind all the default values of base table, view, and foreign table columns.GeneralINFORMATION_SCHEMA only2022-10-31 10:18MIT License
7All column dynamic DEFAULT values values that do not invoke a sequenceFind 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.GeneralINFORMATION_SCHEMA only2021-11-15 15:57MIT License
8All columns of a base table have a default valueFind base tables where all the columns have a default value.Problem detectionINFORMATION_SCHEMA only2021-02-25 17:29MIT License
9All column static DEFAULT valuesFind all columns that have a static default value, i.e., the value is not returned by a function.GeneralINFORMATION_SCHEMA only2021-11-15 15:57MIT License
10All covering indexesFind all covering indexes, which include data from additional columns in leaf blocks.GeneralINFORMATION_SCHEMA+system catalog base tables2020-12-23 11:54MIT License
11All database privilegesFind the privileges to use the database. c - CONNECT; C - CREATE; T - TEMPORARY.Generalsystem catalog base tables only2021-11-23 20:28MIT License
12All declaratively partitioned tablesFind partitioned tables that have been implemented by using the declarative approach. Declarative partitioning is implemented in PostgreSQL starting from PostgreSQL 10.GeneralINFORMATION_SCHEMA+system catalog base tables2020-11-06 15:13MIT License
13All domain default valuesFind domains that specify a default values and columns that are defined based on the domain. Make sure that there are no unsuitable default values.GeneralINFORMATION_SCHEMA only2021-01-19 13:04MIT License
14All domainsFind all domains.GeneralINFORMATION_SCHEMA only2020-11-10 11:49MIT License
15All enumerated typesFind all enumerated types.GeneralINFORMATION_SCHEMA+system catalog base tables2022-10-31 10:19MIT License
16All event triggersFind event triggers, which are not associated to a specific schema object.Generalsystem catalog base tables only2020-12-24 14:54MIT License
17All exclude constraintsFind all exclude constraints.Generalsystem catalog base tables only2021-12-16 11:21MIT License
18All foreign key constraintsEnforce referential integrity in database. Find all referential integrity (foreign key) constraints.Generalsystem catalog base tables only2023-12-07 12:48MIT License
19All foreign tablesFind all foreign tables.GeneralINFORMATION_SCHEMA only2020-11-06 15:20MIT License
20All gin indexesFind indexes with less common access methods. Gin indexes are, for instance, used to speed up PostgreSQL's built in full text search.GeneralINFORMATION_SCHEMA+system catalog base tables2020-11-06 14:51MIT License