PHPMem v2.0.1

Version
1.6.45
Uptime
18 days 11 hours 46 minutes 14 seconds

Memory

Total
512MB
Used
12,33MB (2.41%)
Free
499,67MB

Keys

Current
13 424
Total (since start)
40 994
Evictions
0
Reclaimed
762
Expired Unfetched
0
Evicted Unfetched
0

Connections

Current
2 / 1 024 max
Total
246 434
Rejected
0
llm:2de72617a94f191c52bffd2655454451b74951f1f9aee2dcc00c418e1c91a845
TTL 4 days 15 hours 26 minutes 37 seconds Size 1,45KB Export
Edit
{
    "action": "tool_call",
    "reasoning": "Combine all five monthly tables and find company names that appear more than once, within or across months, with the amount and stage on each row so duplicates can be told apart from repeat rounds.",
    "tool": "query_sql",
    "args": {
        "sql": "WITH u AS (SELECT 'Jan' AS m, \"Company Name\" AS c, Amount AS a, Stage AS st, Investor AS i FROM raw.\"Indian Startups _ Funding  Investors Data January 2022\" UNION ALL SELECT 'Feb', \"Company Name\", Amount, Stage, Investor FROM raw.\"Indian Startups _ Funding  Investors Data February 2022\" UNION ALL SELECT 'Mar', \"Company Name\", Amount, Stage, Investor FROM raw.\"Indian Startups _ Funding  Investors Data March 2022\" UNION ALL SELECT 'Apr', \"Company Name\", Amount, Stage, Investor FROM raw.\"Indian Startups _ Funding  Investors Data April 2022\" UNION ALL SELECT 'May', \"Company Name\", Amount, Stage, Investor FROM raw.\"Indian Startups _ Funding  Investors Data May 2022\") SELECT lower(trim(c)) AS company, COUNT(*) AS n_rows, COUNT(DISTINCT m) AS n_months, string_agg(m || ':' || coalesce(a,'NULL') || ':' || coalesce(st,'NULL'), ' | ') AS detail FROM u WHERE c IS NOT NULL GROUP BY lower(trim(c)) HAVING COUNT(*) > 1 ORDER BY n_rows DESC, company LIMIT 50",
        "purpose": "Find duplicate company names within and across the five monthly tables",
        "source": "raw"
    }
}