From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | some broken on pg_stat_user_functions |
Date: | 2009-02-22 14:27:33 |
Message-ID: | 162867790902220627u2c131cb7q9ac471bac4cb9ecd@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2009-02-22 14:52:55 | Re: some broken on pg_stat_user_functions |
Previous Message | Gregory Stark | 2009-02-22 14:22:30 | Re: Multi calendar system for pgsql |