Functions not visible in pg_stat_user_functions view

From: Bartosz Dmytrak <bdmytrak(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Functions not visible in pg_stat_user_functions view
Date: 2013-01-18 09:20:52
Message-ID: CAD8_UcZvdZDtv=m73gtiqH08ULxHKBTR2QRMUEoEwVOQoMfOCQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,
I've notice not all my functions are tracked by pg_stat_user_functions view.
Interesting thing is similar functions in different db are tracked
correctly.

query:
SELECT p.* FROM pg_proc p
LEFT JOIN pg_stat_user_functions stat
ON (p.OID = stat.funcid)
INNER JOIN pg_language l
ON (l.oid = p.prolang)
WHERE stat.funcid IS NULL AND l.lanname = 'plpgsql'

gives non null output (50 rows in my case)
I am aware internal functions are not tracked, but in my case there are
user defined functions all written in plpgsql

any ideas?

params:
track_functions=all
PostgreSQL v. 9.2.2 on Windows 2008R2 (64bit)

Regards,
Bartek

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jasen Betts 2013-01-18 09:45:43 Re: Best method to compare subdomains
Previous Message Tom Lane 2013-01-18 01:02:44 Re: SELECT DISTINCT