[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