Hi, I’m working with a Postgres database which tends to take really long to retrieve data, it’s a simple :read action with a filter. There are no optimisations to the database that can be done on my side and so I’m looking to increase the timeout when querying the AshPostgres.Repo to avoid this error:

Postgrex.Protocol (#PID<0.359.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.739.0> timed out because it queued and checked out the connection for longer than 15000ms

I have tried setting timeout to :infinity in config/dev.exs as so:

config :hachiware, Hachiware.Reports.Repo,
  hostname: "hachiware-db",
  username: "postgres",
  password: "postgres",
  database: "postgres",
  port: 5432,
  show_sensitive_data_on_connection_error: true,
  pool_size: 10,
  timeout: :infinity

On the repo:

  use AshPostgres.Repo, otp_app: :hachiware, timeout: :infinity

On the domain:

execution do
  timeout :infinity
end

As well as on the Ash.read! action:

__MODULE__
|> Ash.read!(timeout: :infinity)

However it feels that nothing I’m doing works at all, any advice and help is appreciated!