Finds DBConnection processes from Process.info

find_dbconnection_procs_erlang_elxir.ex

Enum.each(Process.list, fn pid -> 
  case Process.info(pid)[:dictionary] do
    [_, "$initial_call": {:supervisor, DBConnection.ConnectionPool.Pool, _}] ->
      state = :sys.get_state(pid, 5000)
      case elem(state, 11) do
        {pid, _, Postgrex.Protocol, opts} ->
        if opts[:hostname] == "db.REDACTED.supabase.co" do
          IO.inspect({pid, state})
        end
        _ -> nil
      end
    _ -> nil
  end
end)