Skip site navigation (1) Skip section navigation (2)

stored procedure stats in collector

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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: track_functions.patch
Description: text/x-diff (53.5 KB)

In response to

Responses

pgsql-hackers by date

Next:From: Volkan YAZICIDate: 2008-03-23 20:25:45
Subject: Re: stored procedure stats in collector
Previous:From: Alvaro HerreraDate: 2008-03-23 15:45:15
Subject: Re: pg_dump additional options for performance

pgsql-patches by date

Next:From: Volkan YAZICIDate: 2008-03-23 20:25:45
Subject: Re: stored procedure stats in collector
Previous:From: Guillaume SmetDate: 2008-03-23 07:56:10
Subject: Re: Logging conflicted queries on deadlocks

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group