PHPMem v2.0.1
Version
1.6.45
Uptime
17 days 9 hours 1 minute 6 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
14 / 1 024 max
Total
235 050
Rejected
0
llm:5d793d90601c50eb0a134ab21ec3e0fe1580169e6d216b1506171ad6df9e78bf
Edit
<invoke name="query_sql">
<parameter name="sql">WITH t AS (
SELECT 'Industry Vertical' AS col, "Industry Vertical" AS v FROM raw.startup_funding
UNION ALL SELECT 'SubVertical', "SubVertical" FROM raw.startup_funding
UNION ALL SELECT 'City Location', "City Location" FROM raw.startup_funding
UNION ALL SELECT 'InvestmentnType', "InvestmentnType" FROM raw.startup_funding
), c AS (
SELECT col, v, COUNT(*) AS n FROM t GROUP BY col, v
), r AS (
SELECT col, v, n, ROUND(100.0 * n / SUM(n) OVER (PARTITION BY col), 1) AS pct, ROW_NUMBER() OVER (PARTITION BY col ORDER BY n DESC) AS rk FROM c
)
SELECT col, rk, v, n, pct FROM r WHERE rk <= 7 ORDER BY col, rk</parameter>
<parameter name="purpose">Top values and frequencies for main categorical columns</parameter>
</invoke>