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 constraints1584
Derived tables1265
Data types1246
Relationships between tables1197
Comfortability of database evolution1148
Comfortability of data management1049
Inconsistencies10310
Triggers and rules9711
Result quality depends on names9312
Does not work in some earlier PostgreSQL version9213
Uniqueness8614
Performance8015
Default value6716
Security5917
Duplication of implementation elements5818
Domains4919
Missing data4820
Regular expressions3221
Sequence generators3122
Structure of base tables3122
Temporal data3023
Data at the database physical level2524
Syntactics2524
Boolean data2425
Unused implementation elements2026
Database design antipatterns1927
Compensating actions1828
Field size1828
Table inheritance1629
Transactions1629
System-defined functions1530
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
Classifier tables737
Full text search737
TOAST737
Extensions638
Generated columns638
Overloading638
Conformance to SQL standard439
Data redundancy340
Read user data340
Schemas340