PHPMem v2.0.1

Version
1.6.45
Uptime
16 days 22 hours 2 minutes 35 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
192 804
Rejected
0
llm:8cf69a70c134ff39971f0f95aa6a989c2ddc22c1719e53b27c64d696bfdd2118
TTL 6 days 5 hours 15 minutes 44 seconds Size 1,74KB Export
Edit
{
    "action": "tool_call",
    "reasoning": "Relate Stage to Amount and company age across all five monthly tables, unioned. Amount is VARCHAR so strip $ and commas before casting; use TRY_CAST for safety.",
    "tool": "query_sql",
    "args": {
        "sql": "WITH u AS (SELECT \"Company Name\" c, TRY_CAST(Founded AS BIGINT) f, Location l, Sector s, Stage st, TRY_CAST(REPLACE(REPLACE(Amount,'$',''),',','') AS DOUBLE) a FROM raw.\"Indian Startups _ Funding  Investors Data January 2022\" UNION ALL SELECT \"Company Name\", TRY_CAST(Founded AS BIGINT), Location, Sector, Stage, TRY_CAST(REPLACE(REPLACE(Amount,'$',''),',','') AS DOUBLE) FROM raw.\"Indian Startups _ Funding  Investors Data February 2022\" UNION ALL SELECT \"Company Name\", TRY_CAST(Founded AS BIGINT), Location, Sector, Stage, TRY_CAST(REPLACE(REPLACE(Amount,'$',''),',','') AS DOUBLE) FROM raw.\"Indian Startups _ Funding  Investors Data March 2022\" UNION ALL SELECT \"Company Name\", TRY_CAST(Founded AS BIGINT), Location, Sector, Stage, TRY_CAST(REPLACE(REPLACE(Amount,'$',''),',','') AS DOUBLE) FROM raw.\"Indian Startups _ Funding  Investors Data April 2022\" UNION ALL SELECT \"Company Name\", TRY_CAST(Founded AS BIGINT), Location, Sector, Stage, TRY_CAST(REPLACE(REPLACE(Amount,'$',''),',','') AS DOUBLE) FROM raw.\"Indian Startups _ Funding  Investors Data May 2022\") SELECT st AS stage, COUNT(*) n, COUNT(a) n_with_amount, ROUND(MEDIAN(a)) median_amount, ROUND(AVG(f)) avg_founded FROM u WHERE st IS NOT NULL AND st <> '' GROUP BY st HAVING COUNT(*) >= 5 ORDER BY median_amount DESC NULLS LAST",
        "purpose": "Relate Stage to Amount and company founding year across all months",
        "source": "raw"
    }
}