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
Derived tables1265
Data types1246
Relationships between tables1197
Comfortability of database evolution1158
Comfortability of data management1049
Inconsistencies10310
Triggers and rules9711
Result quality depends on names9412
Does not work in some earlier PostgreSQL version9213
Uniqueness8714
Performance8015
Default value6716
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
Unused implementation elements2027
Database design antipatterns1928
Compensating actions1829
Field size1829
Table inheritance1630
Transactions1630
System-defined functions1531
Data at the database logical level1332
Distributed database1332
Assessment1233
Comments1233
Concurrency control1233
Fatal problems1134
Hierarchical data1134
User-defined types1134
State machine1035
Case sensitivity vs. case insensitivity936
Range types936
Stubs837
Classifier tables738
Full text search738
TOAST738
Extensions639
Generated columns639
Overloading639
Conformance to SQL standard440
Data redundancy341
Read user data341
Schemas341