PHPMem v2.0.1

Version
1.6.45
Uptime
17 days 47 minutes 54 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
15 / 1 024 max
Total
194 327
Rejected
0
llm:e663cabdf6e145a79c90c97ccb0910495f24bc9915c1fdfe8b61cd1785b15c22
TTL 6 days 2 hours 17 minutes 12 seconds Size 1,72KB Export
Edit
<result> <column_name>Amount</column_name> <family>additive</family> <subtype>real_additive</subtype> <confidence>0.72</confidence> <requires_user_confirmation>false</requires_user_confirmation> <sum_meaningful>true</sum_meaningful> <signed>false</signed> <reducers> <primary_reducer>sum</primary_reducer> <valid_reducers>sum, min, max, mean, median, count, distribution</valid_reducers> <excluded_reducers>product (not a ratio), geomean (not a ratio)</excluded_reducers> <average_semantics>arithmetic_mean</average_semantics> </reducers> <inner_outer_measure> <inner_measure_reducer>sum</inner_measure_reducer> <outer_measure_reducer>sum</outer_measure_reducer> </inner_outer_measure> <multiplicative_partner_derivable>false</multiplicative_partner_derivable> <reasoning>The table is a DIMENSION with no sequence axis, so the gate strongly favors additive and rules out multiplicative. The name "Amount" and the currency-formatted samples ($1,000,000 and up) point to an absolute extensive monetary quantity, so I chose real_additive. The column is stored as VARCHAR, so the numeric statistics are null and the dollar-formatted strings must be parsed to numeric before aggregating. Confidence is reduced because it is a dimension table with one row per entity, where the amount could be a posted level such as a budget or price rather than an accumulating quantity, and because the numeric evidence is missing. The values appear unsigned, and the blank first sample suggests empty strings may need handling.</reasoning> <table_type_conflict>false</table_type_conflict> </result>