Re: SuperUser check in pg_stat_statements

Поиск
Список
Период
Сортировка
От Feike Steenbergen
Тема Re: SuperUser check in pg_stat_statements
Дата
Msg-id CAK_s-G0_vBtR=Safrja10d1oWo-cSsQiBRoVJYQOQUoJNQCHYg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: SuperUser check in pg_stat_statements  (rajan <vgmonnet@gmail.com>)
Список pgsql-hackers
You can create a Security Definer Funtion which can then be executed by then non-superuser monitoring role:

(Assuming you have a role monitoring and pg_stat_statements is installed in schema public)

    -- connected as a superuser
    CREATE FUNCTION pg_stat_statements()
    RETURNS SETOF pg_stat_statements
    LANGUAGE SQL
    SET search_path='public'
    SECURITY DEFINER
    AS
    $BODY$
    SELECT *
      FROM pg_stat_statements;
    $BODY$;

    REVOKE ALL ON FUNCTION pg_stat_statements() FROM public;
    GRANT EXECUTE ON FUNCTION pg_stat_statements() TO monitoring;

    -- connected as monitoring
    SELECT * FROM pg_stat_statements();

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

Предыдущее
От: "Syed, Rahila"
Дата:
Сообщение: Re: [PROPOSAL] VACUUM Progress Checker.
Следующее
От: David Rowley
Дата:
Сообщение: Re: Parallel Aggregate