{"ok":true,"cached":true,"plan":{"sql":"SELECT full_name, title, total_users_30d, runs30_total, hard_failure_rate, months_since_modified, opportunity_score, CASE WHEN pricing_model = 'FREE' OR COALESCE(price_usd, 0) <= 0 THEN 0.0 WHEN pricing_model = 'FLAT_PRICE_PER_MONTH' THEN COALESCE(total_users_30d, 0) * 0.15 * COALESCE(price_usd, 0) WHEN pricing_model = 'PRICE_PER_DATASET_ITEM' THEN (COALESCE(runs30_total, 0) * (1 - LEAST(GREATEST(COALESCE(hard_failure_rate, 0), 0), 1))) * 50 * COALESCE(price_usd, 0) * 0.80 WHEN pricing_model = 'PAY_PER_EVENT' THEN CASE WHEN CASE WHEN COALESCE(price_usd, 0) >= 10 THEN COALESCE(total_users_30d, 0) * 1 * COALESCE(price_usd, 0) * 0.80 WHEN COALESCE(price_usd, 0) >= 1 THEN COALESCE(total_users_30d, 0) * 10 * COALESCE(price_usd, 0) * 0.80 ELSE NULL END IS NULL THEN ((COALESCE(runs30_total, 0) * (1 - LEAST(GREATEST(COALESCE(hard_failure_rate, 0), 0), 1))) * CASE WHEN COALESCE(price_usd, 0) >= 1 THEN 1 WHEN COALESCE(price_usd, 0) >= 0.1 THEN 2 WHEN COALESCE(price_usd, 0) >= 0.01 THEN 10 ELSE 50 END * COALESCE(price_usd, 0) * 0.80) ELSE LEAST(((COALESCE(runs30_total, 0) * (1 - LEAST(GREATEST(COALESCE(hard_failure_rate, 0), 0), 1))) * CASE WHEN COALESCE(price_usd, 0) >= 1 THEN 1 WHEN COALESCE(price_usd, 0) >= 0.1 THEN 2 WHEN COALESCE(price_usd, 0) >= 0.01 THEN 10 ELSE 50 END * COALESCE(price_usd, 0) * 0.80), CASE WHEN COALESCE(price_usd, 0) >= 10 THEN COALESCE(total_users_30d, 0) * 1 * COALESCE(price_usd, 0) * 0.80 WHEN COALESCE(price_usd, 0) >= 1 THEN COALESCE(total_users_30d, 0) * 10 * COALESCE(price_usd, 0) * 0.80 ELSE NULL END) END ELSE 0.0 END AS est_monthly_revenue, pricing_model, allows_agentic_users, categories, target_platform, volatility_risk, url, (detail_embedding <=> '<qvec>'::vector) AS distance FROM apify.actor WHERE detail_embedding IS NOT NULL ORDER BY detail_embedding <=> '<qvec>'::vector LIMIT 10","mode":"vector","view":"auto","limit":10,"notes":["sql path failed (DatabaseError: {'S': 'ERROR', 'V': 'ERROR', 'C': '42803', 'M': 'column \"actor.detail_embedding\" must appear in the GROUP BY clause or be used in an aggregate function', 'P': '413', 'F': 'parse_agg.c', 'L': '1439', 'R': 'check_ungrouped_columns_walker'}); fell back to vector"],"offset":0,"rationale":"pg vector path (Text-to-SQL / vector over pgvector)"},"results":[{"key":"https://apify.com/excessivecode/my-actor-1","url":"https://apify.com/excessivecode/my-actor-1","score":0.459,"title":"excessivecode/my-actor-1","runs_30d":29,"users_30d":2,"categories":"[\"JOBS\"]","pricing_model":"FLAT_PRICE_PER_MONTH","hard_failure_rate":0,"opportunity_score":0.0249,"allowsAgenticUsers":false,"estimated_monthly_revenue":6},{"key":"https://apify.com/potent_jinglessssd/my-actor-2","url":"https://apify.com/potent_jinglessssd/my-actor-2","score":0.4305,"title":"potent_jinglessssd/my-actor-2","runs_30d":29,"users_30d":1,"categories":"[\"AI\"]","pricing_model":"FREE","hard_failure_rate":0,"opportunity_score":0.0094,"allowsAgenticUsers":false,"estimated_monthly_revenue":0},{"key":"https://apify.com/useful-tools/actor-builder","url":"https://apify.com/useful-tools/actor-builder","score":0.4268,"title":"useful-tools/actor-builder","runs_30d":552,"users_30d":1,"categories":"[\"AUTOMATION\", \"DEVELOPER_TOOLS\"]","pricing_model":"FREE","hard_failure_rate":0.0416667,"opportunity_score":0.0151,"allowsAgenticUsers":false,"months_since_modified":5.25624,"estimated_monthly_revenue":0},{"key":"https://apify.com/code_crafter/actor-1","url":"https://apify.com/code_crafter/actor-1","score":0.4224,"title":"code_crafter/actor-1","runs_30d":32,"users_30d":1,"categories":"[\"LEAD_GENERATION\", \"DEVELOPER_TOOLS\", \"AUTOMATION\"]","pricing_model":"PAY_PER_EVENT","hard_failure_rate":0,"opportunity_score":0.0237,"allowsAgenticUsers":false,"estimated_monthly_revenue":12.8000001907349},{"key":"https://apify.com/louisdeconinck/web-traffic-generator","url":"https://apify.com/louisdeconinck/web-traffic-generator","score":0.417,"title":"louisdeconinck/web-traffic-generator","runs_30d":38,"users_30d":3,"categories":"[\"AUTOMATION\", \"SOCIAL_MEDIA\"]","pricing_model":"FLAT_PRICE_PER_MONTH","hard_failure_rate":0.0526316,"opportunity_score":0.1982,"allowsAgenticUsers":false,"months_since_modified":19.5466,"estimated_monthly_revenue":4.05},{"key":"https://apify.com/ellustar/my-actor-8","url":"https://apify.com/ellustar/my-actor-8","score":0.4129,"title":"ellustar/my-actor-8","runs_30d":1,"users_30d":1,"categories":"[\"AUTOMATION\", \"DEVELOPER_TOOLS\", \"OTHER\"]","pricing_model":"PAY_PER_EVENT","hard_failure_rate":0,"opportunity_score":0.0186,"allowsAgenticUsers":false,"estimated_monthly_revenue":0.00199999994947575},{"key":"https://apify.com/storeleads/my-actor-2","url":"https://apify.com/storeleads/my-actor-2","score":0.4107,"title":"storeleads/my-actor-2","runs_30d":29,"users_30d":2,"categories":"[\"AUTOMATION\", \"DEVELOPER_TOOLS\"]","pricing_model":"PAY_PER_EVENT","hard_failure_rate":0,"opportunity_score":0.0249,"allowsAgenticUsers":false,"estimated_monthly_revenue":0.0579999985347968},{"key":"https://apify.com/storeleads/my-actor-1","url":"https://apify.com/storeleads/my-actor-1","score":0.4097,"title":"storeleads/my-actor-1","runs_30d":29,"users_30d":2,"categories":"[\"ECOMMERCE\"]","pricing_model":"PAY_PER_EVENT","hard_failure_rate":0,"opportunity_score":0.0249,"allowsAgenticUsers":false,"estimated_monthly_revenue":0.231999994139187},{"key":"https://apify.com/ellustar/my-actor-81","url":"https://apify.com/ellustar/my-actor-81","score":0.4084,"title":"ellustar/my-actor-81","runs_30d":1,"users_30d":1,"categories":"[\"DEVELOPER_TOOLS\", \"AUTOMATION\", \"OTHER\"]","pricing_model":"PAY_PER_EVENT","hard_failure_rate":0,"opportunity_score":0.0194,"allowsAgenticUsers":false,"estimated_monthly_revenue":0.00199999994947575},{"key":"https://apify.com/lurid_quadrille/my-actor","url":"https://apify.com/lurid_quadrille/my-actor","score":0.4077,"title":"lurid_quadrille/my-actor","runs_30d":29,"users_30d":3,"categories":"[\"DEVELOPER_TOOLS\", \"AI\"]","pricing_model":"FREE","hard_failure_rate":0,"opportunity_score":0.0327,"allowsAgenticUsers":false,"months_since_modified":10.0526,"estimated_monthly_revenue":0}],"answer":null,"meta":{"q":"high+traffic+but+unmaintained+actors","mode":"query","view":"auto","page":1,"limit":10}}