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 constraints1594
Data types1275
Derived tables1266
Relationships between tables1197
Comfortability of database evolution1158
Comfortability of data management1049
Inconsistencies10310
Result quality depends on names10111
Triggers and rules9712
Does not work in some earlier PostgreSQL version9213
Uniqueness8714
Performance8015
Default value6816
Security6017
Duplication of implementation elements5918
Domains4919
Missing data4820
Sequence generators3321
Regular expressions3222
Structure of base tables3123
Temporal data3024
Data at the database physical level2525
Syntactics2525
Boolean data2426
Field size2327
Unused implementation elements2028
Database design antipatterns1929
Compensating actions1830
Table inheritance1631
Transactions1631
System-defined functions1532
Data at the database logical level1333
Distributed database1333
Assessment1234
Comments1234
Concurrency control1234
Classifier tables1135
Fatal problems1135
Hierarchical data1135
User-defined types1135
State machine1036
Case sensitivity vs. case insensitivity937
Range types937
Stubs838
Full text search739
TOAST739
Extensions640
Generated columns640
Overloading640
Conformance to SQL standard441
Data redundancy342
Read user data342
Schemas342