Use Supabase Logs Explorer to see ChatGCP-User requests

supabase-logs-chatgpt-bot.sql

SELECT
  count(t0.id) as count,
  f2.path as path
FROM
  edge_logs AS t0
  INNER JOIN UNNEST(t0.metadata) AS f1 ON TRUE
  INNER JOIN UNNEST(f1.request) AS f2 ON TRUE
  INNER JOIN UNNEST(f2.headers) AS f3 ON TRUE
WHERE
  AND (REGEXP_CONTAINS(f3.user_agent, 'ChatGPT-User'))
GROUP BY
  path
ORDER BY
  count DESC
LIMIT
  10