PHPMem v2.0.1

Version
1.6.45
Uptime
17 days 1 hour 33 minutes 22 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
194 614
Rejected
0
llm:2bdeefe1865e794f7ddb30b007bd0fb6089ebf824464fc9f291654b2883c1303
TTL 6 days 1 hour 39 minutes 5 seconds Size 2,52KB Export
Edit
{
    "action": "tool_call",
    "reasoning": "The earlier reply cannot be used because I have no tool results in evidence to back its numbers. I'll recompute missing rates (NULL or blank) per column and per month in one query.",
    "tool": "query_sql",
    "args": {
        "sql": "WITH a AS (SELECT 'January' AS m, \"Company Name\" AS c, CAST(Founded AS VARCHAR) AS f, Location AS l, Sector AS s, \"What it does\" AS w, Founders AS fo, Investor AS i, Amount AS am, Stage AS st FROM raw.\"Indian Startups _ Funding  Investors Data January 2022\" UNION ALL SELECT 'February', \"Company Name\", CAST(Founded AS VARCHAR), Location, Sector, \"What it does\", Founders, Investor, Amount, Stage FROM raw.\"Indian Startups _ Funding  Investors Data February 2022\" UNION ALL SELECT 'March', \"Company Name\", CAST(Founded AS VARCHAR), Location, Sector, \"What it does\", Founders, Investor, Amount, Stage FROM raw.\"Indian Startups _ Funding  Investors Data March 2022\" UNION ALL SELECT 'April', \"Company Name\", CAST(Founded AS VARCHAR), Location, Sector, \"What it does\", Founders, Investor, Amount, Stage FROM raw.\"Indian Startups _ Funding  Investors Data April 2022\" UNION ALL SELECT 'May', \"Company Name\", Founded, Location, Sector, \"What it does\", Founders, Investor, Amount, Stage FROM raw.\"Indian Startups _ Funding  Investors Data May 2022\") SELECT m AS month, COUNT(*) AS n_rows, ROUND(100.0*SUM(CASE WHEN c IS NULL OR TRIM(c) IN ('','[]') THEN 1 ELSE 0 END)/COUNT(*),1) AS pct_company, ROUND(100.0*SUM(CASE WHEN f IS NULL OR TRIM(f) IN ('','[]') THEN 1 ELSE 0 END)/COUNT(*),1) AS pct_founded, ROUND(100.0*SUM(CASE WHEN l IS NULL OR TRIM(l) IN ('','[]') THEN 1 ELSE 0 END)/COUNT(*),1) AS pct_location, ROUND(100.0*SUM(CASE WHEN s IS NULL OR TRIM(s) IN ('','[]') THEN 1 ELSE 0 END)/COUNT(*),1) AS pct_sector, ROUND(100.0*SUM(CASE WHEN w IS NULL OR TRIM(w) IN ('','[]') THEN 1 ELSE 0 END)/COUNT(*),1) AS pct_what_it_does, ROUND(100.0*SUM(CASE WHEN fo IS NULL OR TRIM(fo) IN ('','[]') THEN 1 ELSE 0 END)/COUNT(*),1) AS pct_founders, ROUND(100.0*SUM(CASE WHEN i IS NULL OR TRIM(i) IN ('','[]') THEN 1 ELSE 0 END)/COUNT(*),1) AS pct_investor, ROUND(100.0*SUM(CASE WHEN am IS NULL OR TRIM(am) IN ('','[]') THEN 1 ELSE 0 END)/COUNT(*),1) AS pct_amount, ROUND(100.0*SUM(CASE WHEN st IS NULL OR TRIM(st) IN ('','[]') THEN 1 ELSE 0 END)/COUNT(*),1) AS pct_stage FROM a GROUP BY ROLLUP(m) ORDER BY n_rows",
        "purpose": "Missing (NULL/blank) rate per column per month and overall"
    }
}