| From: | Martin Pihlak <martin(dot)pihlak(at)gmail(dot)com> |
|---|---|
| To: | pgsql-patches(at)postgresql(dot)org |
| Cc: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
| Subject: | stored procedure stats in collector |
| Date: | 2008-03-23 18:05:04 |
| Message-ID: | 47E69BD0.6070403@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
Attached is a patch that enables tracking function calls through
the stats subsystem. Original discussion:
http://archives.postgresql.org/pgsql-hackers/2007-07/msg00377.php
Introduces new guc variable - track_functions. Possible values are:
none - no collection, default
pl - tracks procedural language functions
all - tracks procedural, SQL and C (not internal) functions
The results are visible from pg_stat_get_function_* functions and
pg_stat_user_functions view.
regards,
Martin
| Attachment | Content-Type | Size |
|---|---|---|
| track_functions.patch | text/x-diff | 53.5 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Volkan YAZICI | 2008-03-23 20:25:45 | Re: stored procedure stats in collector |
| Previous Message | Alvaro Herrera | 2008-03-23 15:45:15 | Re: pg_dump additional options for performance |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Volkan YAZICI | 2008-03-23 20:25:45 | Re: stored procedure stats in collector |
| Previous Message | Guillaume Smet | 2008-03-23 07:56:10 | Re: Logging conflicted queries on deadlocks |