PHPMem v2.0.1

Version
1.6.45
Uptime
16 days 22 hours 43 minutes 24 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
193 081
Rejected
0
llm:421c4ec9d6cd74d2ed4c147cd281597d0f89d4400b3553c3f30b5ebd083cea5d
TTL 6 days 4 hours 33 minutes 35 seconds Size 1,72KB Export
Edit
{
    "action": "tool_call",
    "reasoning": "Profile data quality across all five monthly tables in one query: nulls, non-numeric or very old Founded values, and duplicate company names per month.",
    "tool": "query_sql",
    "args": {
        "sql": "WITH allr AS (SELECT 'Jan' m, \"Company Name\" c, CAST(Founded AS VARCHAR) f, Location l, Sector s, Amount a, Stage st FROM raw.\"Indian Startups _ Funding  Investors Data January 2022\" UNION ALL SELECT 'Feb', \"Company Name\", CAST(Founded AS VARCHAR), Location, Sector, Amount, Stage FROM raw.\"Indian Startups _ Funding  Investors Data February 2022\" UNION ALL SELECT 'Mar', \"Company Name\", CAST(Founded AS VARCHAR), Location, Sector, Amount, Stage FROM raw.\"Indian Startups _ Funding  Investors Data March 2022\" UNION ALL SELECT 'Apr', \"Company Name\", CAST(Founded AS VARCHAR), Location, Sector, Amount, Stage FROM raw.\"Indian Startups _ Funding  Investors Data April 2022\" UNION ALL SELECT 'May', \"Company Name\", Founded, Location, Sector, Amount, Stage FROM raw.\"Indian Startups _ Funding  Investors Data May 2022\") SELECT m, COUNT(*) n, COUNT(*) FILTER (WHERE c IS NULL) null_name, COUNT(*) FILTER (WHERE f IS NULL) null_founded, COUNT(*) FILTER (WHERE TRY_CAST(f AS INTEGER) IS NULL AND f IS NOT NULL) nonnum_founded, COUNT(*) FILTER (WHERE TRY_CAST(f AS INTEGER) < 1950) old_founded, COUNT(*) FILTER (WHERE a IS NULL) null_amt, COUNT(*) FILTER (WHERE st IS NULL) null_stage, COUNT(*) FILTER (WHERE l IS NULL) null_loc, COUNT(*) - COUNT(DISTINCT c) dup_names FROM allr GROUP BY m ORDER BY m",
        "purpose": "Profile nulls, non-numeric/old Founded, duplicates per month",
        "source": "raw"
    }
}