Re: New function pg_stat_statements_reset_query() to resetstatistics of a specific query

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: New function pg_stat_statements_reset_query() to resetstatistics of a specific query
Дата
Msg-id 20181216142846.zb6jggzjjccab335@alvherre.pgsql
обсуждение исходный текст
Ответ на Re: New function pg_stat_statements_reset_query() to reset statisticsof a specific query  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Список pgsql-hackers
On 2018-Dec-15, Peter Eisentraut wrote:

> An example:
> 
> select pg_stat_statements_reset(
> 10,
> (select min(oid) from pg_database where datname like 'test%'),
> 1234);
> 
> (This is obviously a weird example, but it illustrates the
> language-theoretic point.)

This is not at all weird.  Lack of clarity on this point is the reason
that spawned this whole sub-thread, because a reset was removing data
that was not about the query that was intended.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


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

Предыдущее
От: "Daniel Verite"
Дата:
Сообщение: Re: Alternative to \copy in psql modelled after \g
Следующее
От: Tomas Vondra
Дата:
Сообщение: Re: PATCH: logical_work_mem and logical streaming of largein-progress transactions