PHPMem v2.0.1

Version
1.6.45
Uptime
18 days 6 hours 32 minutes 35 seconds

Memory

Total
512MB
Used
12,33MB (2.41%)
Free
499,67MB

Keys

Current
13 424
Total (since start)
40 994
Evictions
0
Reclaimed
762
Expired Unfetched
0
Evicted Unfetched
0

Connections

Current
3 / 1 024 max
Total
244 871
Rejected
0
llm:3634e4067c6b6338996ac99303df4d6e7fb62dee174072369b84f6446ce169e2
TTL 4 days 16 hours 12 minutes 9 seconds Size 2,63KB Export
Edit
**Classification of the 20 columns in `raw.Social_media_impact_on_life`** (from the column metadata and the profiling query on 4,500 rows) **Identifier (1)** - `Student_ID` (VARCHAR) is the primary key. The profile query found 4,500 rows, 4,500 distinct IDs and no nulls, so there is one row per student. The catalog's "~4717 distinct" is only an approximation. **Categorical dimensions (8)** - `Gender` has 4 distinct values. - `Academic_Level` has 3: High School, Undergraduate and one other. - `Primary_Platform` has 7. - `Device_Type` has 3. - `Social_Comparison_Frequency` has 5, from Always to Sometimes. - `Overall_Impact` has 3: Beneficial, Neutral and one other. - `Late_Night_Usage` is a BOOLEAN with 2 values. - `Age` (BIGINT, 15–26, 12 distinct values) is stored as a number, but the catalog tags it as a dimension. It works best as a grouping field (age bands), though it can also be treated as a numeric covariate. **Numeric metrics (8)** - Outcome measures: - `Mental_Health_Index` is an integer from 32 to 98 with no nulls. - `Perceived_Stress_Score` runs from 0 to 40 and has 46 nulls. - `Academic_Performance_GPA` runs from 1.9 to 4.0 and has 85 nulls. - `Sleep_Duration_Hours` runs from 3.0 to 10.5. - `Sleep_Quality_Score` is an ordinal score from 1 to 5, with only 5 distinct values. Treat it as a rating scale rather than a continuous measure. - Usage measures (duration quantities, not dates): - `Daily_Usage_Hours` runs from 0.9 to 14.0. - `Weekend_Extra_Hours` runs from 0.0 to 4.5. - The catalog tags both as "temporal", but they are hours of use, so treat them as numeric exposure metrics. They are the natural predictors for the sleep, stress, mental-health and GPA outcomes. **Dates and times (effectively none)** - The data has no business or event date, so trend-over-time questions can't be answered from it. - The only true timestamp is `_ingestion_timestamp` (TIMESTAMP). It has a single distinct value (2026-10-01 14:08:19), so it is load metadata and not an analytic time axis. **Pipeline metadata (3)** - `_batch_id`, `_source_file` and `_source_system` each have one constant value. They are lineage fields with no analytic value. **Data-quality notes** - Only `Perceived_Stress_Score` (46 nulls) and `Academic_Performance_GPA` (85 nulls) have missing values. Every other analytic column is complete. - The automatic role tags are partly unreliable: they label `Age` a "measure", the two usage-hour columns "temporal", and several numeric columns "categorical". Use the classification above instead.