some broken on pg_stat_user_functions
От | Pavel Stehule |
---|---|
Тема | some broken on pg_stat_user_functions |
Дата | |
Msg-id | 162867790902220627u2c131cb7q9ac471bac4cb9ecd@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: some broken on pg_stat_user_functions
|
Список | pgsql-hackers |
Hello I am checking this functionality and I am afraid, so option all is broken. postgres=# select * from pg_stat_user_functions; funcid | schemaname | funcname | calls | total_time | self_time --------+------------+----------+-------+------------+----------- 24608 | public | test | 6 | 2002 | 2002 (1 row) postgres=# create or replace function test(i integer) returns int as $$begin perform pg_sleep(1);return i; end;$$ language plpgsql; CREATE FUNCTION postgres=# create or replace function test1(i integer) returns int as $$ select $1; $$ language sql; CREATE FUNCTION postgres=# select test(10);test ------ 10 (1 row) postgres=# select test1(10);test1 ------- 10 (1 row) postgres=# set track_functions to 'all'; SET postgres=# select test1(10);test1 ------- 10 (1 row) postgres=# select test(10);test ------ 10 (1 row) postgres=# select * from pg_stat_user_functions; funcid | schemaname | funcname | calls | total_time | self_time --------+------------+----------+-------+------------+----------- 24608 | public | test | 8 | 4003 | 4003 (1 row) I don't see call test1 :( regards Pavel Stehule
В списке pgsql-hackers по дате отправления: