calculate_dialup1.sql

CREATE OR REPLACE FUNCTION calculate_dialup(
  hours real,
  service_dialup_id int
) RETURNS real as $$
DECLARE
  dialup service_dialups%ROWTYPE;
  excess_usage_charge real := 0;
BEGIN
  SELECT * INTO dialup FROM service_dialups WHERE id = service_dialup_id;
  -- ...
END
$$ LANGUAGE plpgsql;

calculate_dialup2.sql

CREATE OR REPLACE FUNCTION calculate_dialup(
  hours real,
  dialup_monthly_charge real,
  dialup_uncharged real,
  dialup_excess_usage_charge real
) RETURNS real as $$
DECLARE
  excess_usage_charge real := 0;
BEGIN
  -- ...
END
$$ LANGUAGE plpgsql STABLE;

pg_stat_user_functions.sql

draft=# SELECT * FROM pg_stat_user_functions;
 funcid | schemaname |               funcname               | calls | total_time | self_time 
--------+------------+--------------------------------------+-------+------------+-----------
 423124 | public     | calculate_dialup                     |  4265 |     292042 |    291912
 423129 | public     | calculate_local_calling              |  4265 |       2643 |      2643

pg_stat_user_functions2.sql

draft=# SELECT * FROM pg_stat_user_functions;
 funcid | schemaname |               funcname               | calls | total_time | self_time 
--------+------------+--------------------------------------+-------+------------+-----------
 423124 | public     | calculate_dialup                     |  4265 |        222 |       222
 423129 | public     | calculate_local_calling              |  4265 |       2400 |      2400