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
