{"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': '397', '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/apify/instagram-scraper","url":"https://apify.com/apify/instagram-scraper","score":0.6338,"title":"apify/instagram-scraper","runs_30d":15083825,"users_30d":29747,"categories":"[\"SOCIAL_MEDIA\"]","pricing_model":"PAY_PER_EVENT","hard_failure_rate":0.00126526,"opportunity_score":0.0977,"allowsAgenticUsers":true,"months_since_modified":-0.0328515,"estimated_monthly_revenue":1626991.96223719},{"key":"https://apify.com/api-ninja/instagram-scraper","url":"https://apify.com/api-ninja/instagram-scraper","score":0.6247,"title":"api-ninja/instagram-scraper","runs_30d":515,"users_30d":105,"categories":"[\"SOCIAL_MEDIA\", \"DEVELOPER_TOOLS\", \"AUTOMATION\"]","pricing_model":"PAY_PER_EVENT","hard_failure_rate":0,"opportunity_score":0.0482,"allowsAgenticUsers":true,"months_since_modified":0.821288,"estimated_monthly_revenue":102.999997697771},{"key":"https://apify.com/scrap3r/instagram-profile-scraper","url":"https://apify.com/scrap3r/instagram-profile-scraper","score":0.6228,"title":"scrap3r/instagram-profile-scraper","runs_30d":31,"users_30d":1,"categories":"[\"SOCIAL_MEDIA\", \"LEAD_GENERATION\", \"DEVELOPER_TOOLS\"]","pricing_model":"FLAT_PRICE_PER_MONTH","hard_failure_rate":0,"opportunity_score":0.0245,"allowsAgenticUsers":false,"estimated_monthly_revenue":3.75},{"key":"https://apify.com/scraperx/instagram-post-scraper","url":"https://apify.com/scraperx/instagram-post-scraper","score":0.6218,"title":"scraperx/instagram-post-scraper","runs_30d":29,"users_30d":1,"categories":"[\"AUTOMATION\", \"LEAD_GENERATION\", \"SOCIAL_MEDIA\"]","pricing_model":"PAY_PER_EVENT","hard_failure_rate":0,"opportunity_score":0.0235,"allowsAgenticUsers":false,"estimated_monthly_revenue":4.62840013206005},{"key":"https://apify.com/scraper-engine/instagram-posts-scraper-cheapest","url":"https://apify.com/scraper-engine/instagram-posts-scraper-cheapest","score":0.6198,"title":"scraper-engine/instagram-posts-scraper-cheapest","runs_30d":29,"users_30d":3,"categories":"[\"SOCIAL_MEDIA\", \"LEAD_GENERATION\", \"AUTOMATION\"]","pricing_model":"FLAT_PRICE_PER_MONTH","hard_failure_rate":0,"opportunity_score":0.0286,"allowsAgenticUsers":false,"months_since_modified":3.15375,"estimated_monthly_revenue":8.99549989700317},{"key":"https://apify.com/api-ninja/instagram-hashtag-scraper","url":"https://apify.com/api-ninja/instagram-hashtag-scraper","score":0.6185,"title":"api-ninja/instagram-hashtag-scraper","runs_30d":110,"users_30d":62,"categories":"[\"SOCIAL_MEDIA\", \"AUTOMATION\", \"DEVELOPER_TOOLS\"]","pricing_model":"PAY_PER_EVENT","hard_failure_rate":0,"opportunity_score":0.0389,"allowsAgenticUsers":true,"months_since_modified":0.788436,"estimated_monthly_revenue":13.199999704957},{"key":"https://apify.com/logical_scrapers/instagram-followings-scraper","url":"https://apify.com/logical_scrapers/instagram-followings-scraper","score":0.6174,"title":"logical_scrapers/instagram-followings-scraper","runs_30d":5,"users_30d":2,"categories":"[\"SOCIAL_MEDIA\", \"DEVELOPER_TOOLS\", \"AUTOMATION\"]","pricing_model":"PAY_PER_EVENT","hard_failure_rate":1,"opportunity_score":0.0233,"allowsAgenticUsers":true,"estimated_monthly_revenue":0},{"key":"https://apify.com/scrapesmith/instagram-hashtag-scraper","url":"https://apify.com/scrapesmith/instagram-hashtag-scraper","score":0.615,"title":"scrapesmith/instagram-hashtag-scraper","runs_30d":1015,"users_30d":81,"categories":"[\"SOCIAL_MEDIA\", \"AUTOMATION\", \"VIDEOS\"]","pricing_model":"PAY_PER_EVENT","hard_failure_rate":0.00295567,"opportunity_score":0.0474,"allowsAgenticUsers":true,"months_since_modified":0.065703,"estimated_monthly_revenue":20.2400009595463},{"key":"https://apify.com/logical_scrapers/instagram-followers-scraper","url":"https://apify.com/logical_scrapers/instagram-followers-scraper","score":0.6148,"title":"logical_scrapers/instagram-followers-scraper","runs_30d":96,"users_30d":9,"categories":"[\"SOCIAL_MEDIA\", \"LEAD_GENERATION\", \"OTHER\"]","pricing_model":"PAY_PER_EVENT","hard_failure_rate":0.989583,"opportunity_score":0.2237,"allowsAgenticUsers":false,"months_since_modified":3.61367,"estimated_monthly_revenue":0.100000188499685},{"key":"https://apify.com/scrapapi/instagram-phone-number-scraper","url":"https://apify.com/scrapapi/instagram-phone-number-scraper","score":0.6145,"title":"scrapapi/instagram-phone-number-scraper","runs_30d":78,"users_30d":8,"categories":"[\"AUTOMATION\", \"LEAD_GENERATION\", \"SOCIAL_MEDIA\"]","pricing_model":"PAY_PER_EVENT","hard_failure_rate":0.0128205,"opportunity_score":0.0312,"allowsAgenticUsers":false,"months_since_modified":0.952694,"estimated_monthly_revenue":9.20919984423146}],"answer":null,"meta":{"q":"cheap+instagram+scrapers","mode":"query","view":"auto","page":1,"limit":10}}