Re: Slow query on V12.

Поиск
Список
Период
Сортировка
От nikhil raj
Тема Re: Slow query on V12.
Дата
Msg-id CAG1ps1zzAeB9Z3PEhQt5zVLjGocgvWWZMkhVq-NhPF7VKrn+3g@mail.gmail.com
обсуждение исходный текст
Ответ на Slow query on V12.  (Luís Roberto Weck <luisroberto@siscobra.com.br>)
Ответы Re: Slow query on V12.  (Luís Roberto Weck <luisroberto@siscobra.com.br>)
Список pgsql-performance
Дерево обсуждения
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.


В списке pgsql-performance по дате отправления:

Предыдущее
От: Luís Roberto Weck
Дата:
Сообщение: Slow query on V12.
Следующее
От: Luís Roberto Weck
Дата:
Сообщение: Re: Slow query on V12.