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

Choose collection:
ANDChoose query type:
ANDChoose query reliability:
ANDChoose category:
ANDChoose data source:From where does the query gets its information?
ANDEnter string:
ANDHas fixing queries?

There are 718 queries.

Seq nrNameGoalTypeData sourceLicense...
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 onlyMIT License
2All 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 onlyMIT License
3All clustered indexesFin all tables that rows have been physically sorted based on an index.Generalsystem catalog base tables onlyMIT License
4All column DEFAULT valuesFidnd all the default values of base table, view, and foreign table columns.GeneralINFORMATION_SCHEMA onlyMIT License
5All columns of a base table have a default valueFind base tables where all the columns have a default value.Problem detectionINFORMATION_SCHEMA onlyMIT License
6All covering indexesFind all covering indexes, which include data from additional columns in leaf blocks.GeneralINFORMATION_SCHEMA+system catalog base tablesMIT License
7All 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 tablesMIT License
8All 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 onlyMIT License
9All domainsFind all domains.GeneralINFORMATION_SCHEMA onlyMIT License
10All event triggersFind event triggers, which are not associated to a specific schema object.Generalsystem catalog base tables onlyMIT License
11All exclude constraintsFind all exclude constraints.Generalsystem catalog base tables onlyMIT License
12All foreign key constraintsEnforce referential integrity in database. Find all referential integrity (foreign key) constraints.Generalsystem catalog base tables onlyMIT License
13All foreign tablesFind all foreign tables.GeneralINFORMATION_SCHEMA onlyMIT License
14All 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 tablesMIT License
15All identifying relationshipsFind all identifying relationships where the foreign key (a set of columns) is a subset of the primary key of the table.Generalsystem catalog base tables onlyMIT License
16All key constraintsFind all the primary key and unique constraints of base tables.Generalsystem catalog base tables onlyMIT License
17All non-identifying relationshipsFind all non-identifying relationships where the foreign key (a set of columns) is not a subset of the primary key of the table.Generalsystem catalog base tables onlyMIT License
18All non-unique indexesFind secondary indexes that have been created in the database.GeneralINFORMATION_SCHEMA+system catalog base tablesMIT License
19All parameters with DEFAULT valuesFind parameters of user-defined routines that have a default value.GeneralINFORMATION_SCHEMA+system catalog base tablesMIT License
20All partial indexesFind indexes to a subset of table rows.GeneralINFORMATION_SCHEMA+system catalog base tablesMIT License