[DOCS] pg_stat_statements max size clarification

Поиск
Список
Период
Сортировка
От baron@xaprb.com
Тема [DOCS] pg_stat_statements max size clarification
Дата
Msg-id 20170716003147.9230.86974@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: [DOCS] pg_stat_statements max size clarification  (Peter Geoghegan <pg@bowt.ie>)
Список pgsql-docs
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/9.6/static/pgstatstatements.html
Description:

From https://www.postgresql.org/docs/current/static/pgstatstatements.html

pg_stat_statements.max (integer)
pg_stat_statements.max is the maximum number of statements tracked by the
module (i.e., the maximum number of rows in the pg_stat_statements view). If
more distinct statements than that are observed, information about the
least-executed statements is discarded. The default value is 5000. This
parameter can only be set at server start.

I wonder if "least-executed" is correct. I'm not an expert and haven't
convinced myself of this by examining the code, but I think after N distinct
queryid's have been seen, then any additional ones are ignored. But that may
not be "least-executed" at all. It's "most-recent" instead. I think we need
a new phrase here.

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

Предыдущее
От: Conor McNally
Дата:
Сообщение: Re: [DOCS] Canonical url for latest document set?
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: [DOCS] pg_stat_statements max size clarification