Ya this is because of ANALYZE. now it's working fine.
Thanks for your support. On Tue, Jun 25, 2019, 8:03 PM Adrian Klaver <adrian.kla...@aklaver.com> wrote: > 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. > > > -- > Adrian Klaver > adrian.kla...@aklaver.com >
