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.klaver@xxxxxxxxxxx> 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.klaver@xxxxxxxxxxx
