Re: [proposal] pg_stat_statements: extension timing instrumentation

Поиск
Список
Период
Сортировка
От legrand legrand
Тема Re: [proposal] pg_stat_statements: extension timing instrumentation
Дата
Msg-id 1540160070161-0.post@n3.nabble.com
обсуждение исходный текст
Ответ на [proposal] pg_stat_statements: extension timing instrumentation  (legrand legrand <legrand_legrand@hotmail.com>)
Список pgsql-general
An other way is to use "waits" reporting ...
something like :

pgss_store (...)
    pgstat_report_wait_start(PG_WAIT_EXTENSION);
        ...
    pgstat_report_wait_end();

gives waits of type "Extension", name "Extension" when spending time in this
part of pgss.

This can help those working with waits sampling
as found in pg_stat_activity, pg_wait_sampling or pgsentinel.

note: some of the contentions are already reported as  "LWLock" /
"pg_stat_statements"

Regards
PAscal




--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html


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

Предыдущее
От: Tim Clarke
Дата:
Сообщение: Re: archive items not in correct section order
Следующее
От: legrand legrand
Дата:
Сообщение: Re: no queryId in post_parse_analyze hook when row is locked