We have docker containers (12) running on-prem machines, one of them is a postgres DB, on the same query we sometimes get peaks of 30+ seconds for a query that most of the time takes 2 seconds.
The graph below displays the table select duration (so we assume it is not network/server/pools latency)
We are trying to eliminate options here when looking for the cause of this temporary failure, should i be checking something specific in postges ? we use the default configuration.
Can it be that postgres chooses different query strategy once in a while that has such an effect on performance? (we see different results on the exact same data sometimes)

EDIT-1 query runs on view, ( not Materialized View)