PHPMem v2.0.1

Version
1.6.45
Uptime
18 days 7 hours 4 minutes 40 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
245 000
Rejected
0
llm:965de6d4dd1def63c3f6734d9e2f5e58fdb09ba8bf8b35dd0cfdccca28ac9291
TTL 4 days 20 hours 8 minutes 11 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"
    }
}