some broken on pg_stat_user_functions

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

Responses

Browse pgsql-hackers by date

  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