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

Number of queries in different categories

218 queries
128 queries
126 queries
106 queries
87 queries
80 queries
68 queries
60 queries
49 queries
49 queries
33 queries
25 queries
24 queries
23 queries
16 queries
12 queries
12 queries
11 queries
10 queries
9 queries
8 queries
7 queries
6 queries
6 queries
3 queries
Category NameNumber of QueriesRanking
Naming (opens in new tab)2181
User-defined routines (opens in new tab)1982
Validity and completeness (opens in new tab)1623
CHECK constraints (opens in new tab)1604
Data types (opens in new tab)1285
Derived tables (opens in new tab)1266
Relationships between tables (opens in new tab)1217
Comfortability of database evolution (opens in new tab)1158
Result quality depends on names (opens in new tab)1079
Inconsistencies (opens in new tab)10610
Comfortability of data management (opens in new tab)10511
Triggers and rules (opens in new tab)9712
Does not work in some earlier PostgreSQL version (opens in new tab)9213
Uniqueness (opens in new tab)8714
Performance (opens in new tab)8015
Default value (opens in new tab)6816
Security (opens in new tab)6017
Duplication of implementation elements (opens in new tab)5918
Domains (opens in new tab)4919
Missing data (opens in new tab)4919
Sequence generators (opens in new tab)3320
Temporal data (opens in new tab)3320
Regular expressions (opens in new tab)3221
Structure of base tables (opens in new tab)3122
Data at the database physical level (opens in new tab)2523
Syntactics (opens in new tab)2523
Boolean data (opens in new tab)2424
Field size (opens in new tab)2325
Unused implementation elements (opens in new tab)2026
Compensating actions (opens in new tab)1927
Database design antipatterns (opens in new tab)1927
Table inheritance (opens in new tab)1628
Transactions (opens in new tab)1628
System-defined functions (opens in new tab)1529
Classifier tables (opens in new tab)1330
Data at the database logical level (opens in new tab)1330
Distributed database (opens in new tab)1330
Assessment (opens in new tab)1231
Comments (opens in new tab)1231
Concurrency control (opens in new tab)1231
Fatal problems (opens in new tab)1132
Hierarchical data (opens in new tab)1132
User-defined types (opens in new tab)1132
State machine (opens in new tab)1033
Case sensitivity vs. case insensitivity (opens in new tab)934
Range types (opens in new tab)934
Stubs (opens in new tab)835
Full text search (opens in new tab)736
TOAST (opens in new tab)736
Extensions (opens in new tab)637
Generated columns (opens in new tab)637
Overloading (opens in new tab)637
Conformance to SQL standard (opens in new tab)438
Data redundancy (opens in new tab)339
Read user data (opens in new tab)339
Schemas (opens in new tab)339