Re: Slow query on V12.
| От | Luís Roberto Weck |
|---|---|
| Тема | Re: Slow query on V12. |
| Дата | |
| Msg-id | 13d5836f-27c0-d8c3-0106-6ba0160fcd2b@siscobra.com.br обсуждение исходный текст |
| Ответ на | Re: Slow query on V12. (nikhil raj <nikhilraj474@gmail.com>) |
| Ответы |
Re: Slow query on V12.
|
| Список | pgsql-performance |
Em 23/09/2019 15:43, nikhil raj escreveu:
Thanks for the reply!
Here's the plan after running vacuum analyze: https://explain.depesz.com/s/lhcl
There was no difference in execution time.
Hi!Hi,Can you check by vacuum analyze the database. And run the query.**Remember don't use Vacuum full.On Tue, 24 Sep 2019, 12:07 am Luís Roberto Weck, <luisroberto@siscobra.com.br> wrote:Hi!
Recently I've been looking for bloat in my databases and found a query to show which tables are more bloated and by how much.
This is the explain plan on v12.3: https://explain.depesz.com/s/8dW8C
And this is with v11: https://explain.depesz.com/s/diXY
Both databases have approx. the same size and have the same schema, but on v12 I the query takes much longer to run.
Thanks for the reply!
Here's the plan after running vacuum analyze: https://explain.depesz.com/s/lhcl
There was no difference in execution time.
В списке pgsql-performance по дате отправления: