On 6/25/19 7:24 AM, Pawan Sharma wrote: > In PostgreSQL logs it's showing select queries are running with duration > approx 37001.347ms >
Is this normal?
Did you run ANALYZE on the database after you restored it to the new Postgres 11 cluster?
If not do so.
Then run the query in psql or something similar with EXPALIN ANALYZE and see what the time is.
I cannot find the error message string in the Postgres source code, so I am guessing it came from somewhere else. Best guess is the app/driver has a timeout set.
