Em 22/11/2019 08:46, Sterpu Victor escreveu:
I did runned "VACCUM FULL" followed by "VACUUM" but no difference.
------ Original Message ------
From: "Fırat Güleç" <[email protected]
<mailto:[email protected]>>
To: "Sterpu Victor" <[email protected] <mailto:[email protected]>>
Cc: [email protected]
<mailto:[email protected]>
Sent: 2019-11-22 1:35:15 PM
Subject: RE: Postgresql planning time too high
Hello Sterpu,
First, please run vaccum for your Postgresql DB.
No rows returned from your query. Could you double check your query
criteria.
After that could you send explain analyze again .
Regards,
*FIRAT GÜLEÇ***
Infrastructure & Database Operations Manager
[email protected] <mailto:[email protected]>
*M:*0 532 210 57 18
İnönü Mh. Mimar Sinan Cd. No:3 Güzeller Org.San.Bölg. GEBZE / KOCAELİ
image.png
*From:*Sterpu Victor <[email protected] <mailto:[email protected]>>
*Sent:* Friday, November 22, 2019 2:21 PM
*To:* [email protected]
<mailto:[email protected]>
*Subject:* Postgresql planning time too high
Hello
I'm on a PostgreSQL 12.1 and I just restored a database from a backup.
When I run a query I get a big execution time: 5.482 ms
After running EXPLAIN ANALYZE I can see that the "Planning Time:
5165.742 ms" and the "Execution Time: 6.244 ms".
The database is new(no need to vacuum) and i'm the only one connected
to it. I use a single partition on the harddrive.
I also tried this on a postgresql 9.5 and the result was the same.
I'm not sure what to do to improve this situation.
The query and the explain is attached.
Thank you
Have you run the ANALYZE command to update your DB statistics?
