PHPMem v2.0.1

Version
1.6.45
Uptime
17 days 23 hours 22 minutes 3 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
242 445
Rejected
0
llm:3c05aa63791c15b6c5d1dd7ac6d7e7d6f5c9f0eadbaaccec4fe0f542f2c83859
TTL 5 days 3 hours 53 minutes 19 seconds Size 1,61KB Export
Edit
{
    "action": "tool_call",
    "reasoning": "Founded and Amount are the numeric columns; Amount is VARCHAR so it needs parsing. Compute summary stats across all five monthly tables in one query.",
    "tool": "query_sql",
    "args": {
        "sql": "WITH allr AS (SELECT TRY_CAST(\"Founded\" AS BIGINT) AS f, \"Amount\" AS a FROM raw.\"Indian Startups _ Funding  Investors Data January 2022\" UNION ALL SELECT TRY_CAST(\"Founded\" AS BIGINT), \"Amount\" FROM raw.\"Indian Startups _ Funding  Investors Data February 2022\" UNION ALL SELECT TRY_CAST(\"Founded\" AS BIGINT), \"Amount\" FROM raw.\"Indian Startups _ Funding  Investors Data March 2022\" UNION ALL SELECT TRY_CAST(\"Founded\" AS BIGINT), \"Amount\" FROM raw.\"Indian Startups _ Funding  Investors Data April 2022\" UNION ALL SELECT TRY_CAST(\"Founded\" AS BIGINT), \"Amount\" FROM raw.\"Indian Startups _ Funding  Investors Data May 2022\"), p AS (SELECT f, TRY_CAST(REPLACE(REPLACE(a,'$',''),',','') AS DOUBLE) AS amt FROM allr) SELECT 'Founded' AS metric, COUNT(*) AS total_rows, COUNT(f) AS n_valid, MIN(f) AS min_v, MAX(f) AS max_v, ROUND(AVG(f),1) AS mean_v, MEDIAN(f) AS median_v, ROUND(STDDEV(f),1) AS stddev_v, QUANTILE_CONT(f,0.25) AS p25, QUANTILE_CONT(f,0.75) AS p75 FROM p UNION ALL SELECT 'Amount_USD', COUNT(*), COUNT(amt), MIN(amt), MAX(amt), ROUND(AVG(amt),0), MEDIAN(amt), ROUND(STDDEV(amt),0), QUANTILE_CONT(amt,0.25), QUANTILE_CONT(amt,0.75) FROM p",
        "purpose": "Summary statistics for Founded and parsed Amount across all five monthly tables",
        "source": "raw"
    }
}