Re: Postgresql planning time too high
Luís Roberto Weck <[email protected]> Fri, 22 Nov 2019 09:22:16 -0300
| Newsgroups | gmane.comp.db.postgresql.performance |
|---|---|
| Message-ID | <[email protected]> |
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?