PHPMem v2.0.1
Version
1.6.45
Uptime
17 days 20 hours 49 minutes 26 seconds
Memory
Total
512MB
Used
12,72MB (2.48%)
Free
499,28MB
Keys
Current
14 060
Total (since start)
40 994
Evictions
0
Reclaimed
760
Expired Unfetched
0
Evicted Unfetched
0
Connections
Current
2 / 1 024 max
Total
241 638
Rejected
0
llm:7e61e2b7633dc289a9ad36d56ba785f5b2615702af1f2042d09406dbca753435
Edit
Sixteen columns are tagged "categorical" in the catalog metadata I pulled, and the counts below are the catalog's approximate distinct counts (`approx_distinct_count`). The exact `distinct_count` field was blank for every column.
**True category-style columns**
- `Surface` has about 4 distinct values in each of the three fact tables (`raw_kaggle`, `return_kaggle`, `serve_kaggle`).
- `Rd` (round) has about 14 in each of those three tables.
- `return_kaggle.against` has 1, so it carries no information.
- `Name` has about 491 in each fact table. `players_tournament_man_.year` has 24, covering 2002 to 2024.
- `serve_kaggle.Bpsvd` has about 236, and `serve_kaggle.Df%` has about 231. Both are stored as text.
**Numeric measures that the profiler tagged "categorical" because they have few distinct values**
- `raw_kaggle.Aces` has about 54.
- `raw_kaggle.DFs` has about 29.
- `raw_kaggle.vA` has about 62.
- `raw_kaggle.1SP` has about 189.
- `raw_kaggle.2SP` has about 134.
**Caveats**
- `Name` shows about 491 distinct values, but `players_man_` has only 462 rows. The approximate count may be slightly off, or some names may appear only in other tables.
- Many other columns, such as `Tournament` (about 3,963 distinct) and `Score` (about 10,386), are tagged "classifier" or "text" rather than categorical, so I left them out. They are high-cardinality labels.