Query Statistics: Categories

Back to Query Catalog
  • Dashboard
  • Categories
  • Query Types
  • Query Reliability
  • Source of Information

Currently the catalog has 56 active categories with at least one query.

Number of queries in different categories
Category NameNumber of QueriesRanking
Naming2161
User-defined routines1982
Validity and completeness1623
CHECK constraints1604
Data types1275
Derived tables1266
Relationships between tables1217
Comfortability of database evolution1158
Comfortability of data management1059
Result quality depends on names10410
Inconsistencies10311
Triggers and rules9712
Does not work in some earlier PostgreSQL version9213
Uniqueness8714
Performance8015
Default value6816
Security6017
Duplication of implementation elements5918
Domains4919
Missing data4919
Sequence generators3320
Regular expressions3221
Structure of base tables3122
Temporal data3023
Data at the database physical level2524
Syntactics2524
Boolean data2425
Field size2326
Unused implementation elements2027
Compensating actions1928
Database design antipatterns1928
Table inheritance1629
Transactions1629
System-defined functions1530
Classifier tables1331
Data at the database logical level1331
Distributed database1331
Assessment1232
Comments1232
Concurrency control1232
Fatal problems1133
Hierarchical data1133
User-defined types1133
State machine1034
Case sensitivity vs. case insensitivity935
Range types935
Stubs836
Full text search737
TOAST737
Extensions638
Generated columns638
Overloading638
Conformance to SQL standard439
Data redundancy340
Read user data340
Schemas340