Listing visits of parmap times out

https://archive.softwareheritage.org/browse/origin/visits/?origin_url=https://github.com/rdicosmo/parmap causes this:

https://sentry.softwareheritage.org/organizations/swh/issues/10364/?referrer=phabricator_plugin

RemoteException: <RemoteException 500 QueryCanceled: ['canceling statement due to statement timeout\n']>
(6 additional frame(s) were not displayed)
...
  File "swh/core/api/__init__.py", line 183, in meth_
    return self._post(meth._endpoint_path, post_data)
  File "swh/core/api/__init__.py", line 278, in _post
    return self._decode_response(response)
  File "swh/core/api/__init__.py", line 370, in _decode_response
    self.raise_for_status(response)
  File "swh/storage/api/client.py", line 29, in raise_for_status
    super().raise_for_status(response)
  File "swh/core/api/__init__.py", line 360, in raise_for_status
    raise exception from None

---

Migrated from T4386 (view on Phabricator)