Catalog of PostgreSQL queries for finding information about a PostgreSQL database and its design problems.
Choose collection:
Not specified
Find problems about integrity constraints
Find problems automatically
Find problems by overview
Find quick numeric overview of the database
Investigation of tables
AND
Choose query type:
Not specified
General
Problem detection
Sofware measure
AND
Choose category:
Not specified
Assessment
Boolean data
Case sensitivity vs. case insensitivity
CHECK constraints
Classifier tables
Comfortability of database evolution
Comfortability of data management
Comments
Compensating actions
Concurrency control
Data at the database logical level
Data at the database physical level
Database design antipatterns
Data redundancy
Data types
Default value
Derived tables
Distributed database
Domains
Duplication of implementation elements
Extensions
Fatal problems
Field size
Generated columns
Generation of key values
Hierarchical data
Inconsistencies
Missing data
Naming
Overloading
Performance
Read user data
Regular expressions
Relationships between tables
Result quality depends on names
Security
Sequence generators
State machine
Structure of base tables
Stubs
Syntactics
System-defined functions
Table inheritance
Temporal data
TOAST
Transactions
Triggers and rules
Uniqueness
Unused implementation elements
User-defined routines
User-defined types
Validity and completeness
AND
Choose data source:
Not specified
INFORMATION_SCHEMA+system catalog base tables
INFORMATION_SCHEMA only
system catalog base tables only
From where does the query gets its information?
AND
Enter string:
AND
Has fixing queries?