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

Number of queries in different categories

219 queries
128 queries
127 queries
89 queries
82 queries
68 queries
66 queries
52 queries
51 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)2191
User-defined routines (opens in new tab)2142
Validity and completeness (opens in new tab)1633
CHECK constraints (opens in new tab)1624
Data types (opens in new tab)1285
Derived tables (opens in new tab)1276
Relationships between tables (opens in new tab)1217
Comfortability of database evolution (opens in new tab)1168
Result quality depends on names (opens in new tab)1168
Triggers and rules (opens in new tab)1168
Inconsistencies (opens in new tab)1099
Comfortability of data management (opens in new tab)10610
Does not work in some earlier PostgreSQL version (opens in new tab)9211
Uniqueness (opens in new tab)8912
Performance (opens in new tab)8213
Default value (opens in new tab)6814
Security (opens in new tab)6615
Duplication of implementation elements (opens in new tab)5916
Missing data (opens in new tab)5217
Domains (opens in new tab)5118
Regular expressions (opens in new tab)3319
Sequence generators (opens in new tab)3319
Temporal data (opens in new tab)3319
Structure of base tables (opens in new tab)3120
Data at the database physical level (opens in new tab)2521
Syntactics (opens in new tab)2521
Boolean data (opens in new tab)2422
Field size (opens in new tab)2323
Unused implementation elements (opens in new tab)2024
Compensating actions (opens in new tab)1925
Database design antipatterns (opens in new tab)1925
Table inheritance (opens in new tab)1626
Transactions (opens in new tab)1626
System-defined functions (opens in new tab)1527
Concurrency control (opens in new tab)1428
Data at the database logical level (opens in new tab)1428
Classifier tables (opens in new tab)1329
Distributed database (opens in new tab)1329
Assessment (opens in new tab)1230
Comments (opens in new tab)1230
Fatal problems (opens in new tab)1131
Hierarchical data (opens in new tab)1131
User-defined types (opens in new tab)1131
State machine (opens in new tab)1032
Case sensitivity vs. case insensitivity (opens in new tab)933
Range types (opens in new tab)933
Stubs (opens in new tab)834
Full text search (opens in new tab)735
TOAST (opens in new tab)735
Extensions (opens in new tab)636
Generated columns (opens in new tab)636
Overloading (opens in new tab)636
Conformance to SQL standard (opens in new tab)437
Data redundancy (opens in new tab)338
Read user data (opens in new tab)338
Schemas (opens in new tab)338