[postgis-devel] function costs

Kevin Neufeld kneufeld at refractions.net
Wed Jul 1 08:32:24 PDT 2009


I just saw with the release of 8.4, a new user function "pg_stat_user_functions" entered into the playing arena.

http://www.postgresql.org/docs/8.4/static/monitoring-stats.html
"For all tracked functions, function OID, schema, name, number of calls, total time, and self time. Self time is the 
amount of time spent in the function itself, total time includes the time spent in functions it called. Time values are 
in milliseconds."

I wonder if we can use this function in conjunction with Regina's torture test suite to come up an "average time spent 
in every function estimate", which in turn we could scale into an appropriate COST parameter.

-- Kevin



More information about the postgis-devel mailing list