Обсуждение: [ADMIN] Is it safe to run pg_stat_reset() i Prod?

Поиск

Список

Период

Сортировка

[ADMIN] Is it safe to run pg_stat_reset() i Prod?

От

Gustav Karlsson

Дата:

17 декабря 2018 г., 11:41:10

Hi,

Am tracking unused indices and wondering if it is safe to run pg_stat_reset() i production? I.e. will pg_stat_reset()
affectstats used by the query planner in any way which could affect performance? 

Regards,
Gustav

Re: [ADMIN] Is it safe to run pg_stat_reset() i Prod?

От

Shreeyansh Dba

Дата:

17 декабря 2018 г., 12:33:28

Hi Gustav Karlsson,

It only resets the stats for the current database, not the cluster wide stats - pg_database is cluster wide.

Specially when values associated to inserts, updates, deleted, etc. In pg_stat_user_* get a new value after running pg_stat_reset().

On Mon, Dec 17, 2018 at 5:11 PM Gustav Karlsson <gustav.karlsson@bekk.no> wrote:

Hi,

Am tracking unused indices and wondering if it is safe to run pg_stat_reset() i production? I.e. will pg_stat_reset() affect stats used by the query planner in any way which could affect performance?

Regards,
Gustav

Re: [ADMIN] Is it safe to run pg_stat_reset() i Prod?

От

Tom Lane

Дата:

17 декабря 2018 г., 14:28:34

Gustav Karlsson <gustav.karlsson@bekk.no> writes:
> Am tracking unused indices and wondering if it is safe to run pg_stat_reset() i production? I.e. will pg_stat_reset()
affectstats used by the query planner in any way which could affect performance? 

The planner doesn't look at any of that data.

            regards, tom lane

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Обсуждение: [ADMIN] Is it safe to run pg_stat_reset() i Prod?

[ADMIN] Is it safe to run pg_stat_reset() i Prod?

Re: [ADMIN] Is it safe to run pg_stat_reset() i Prod?

Re: [ADMIN] Is it safe to run pg_stat_reset() i Prod?