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
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"
}
}