PL Profiler Report for tpcb-problem-fixed

PL/pgSQL Call Graph

List of functions detailed below

public.tpcb() oid=66237
public.tpcb_fetch_abalance() oid=66446
public.tpcb_ins_history() oid=66241
public.tpcb_upd_accounts() oid=66238
public.tpcb_upd_branches() oid=66240
public.tpcb_upd_tellers() oid=66239

All 6 functions (by self_time)

Function public.tpcb_upd_tellers() oid=66239 (show)

self_time = 195,487,118 µs
total_time = 195,487,118 µs

`public.tpcb_upd_tellers`	`(par_tid integer, par_delta integer)`
`RETURNS void`

Function public.tpcb_upd_branches() oid=66240 (show)

self_time = 81,747,512 µs
total_time = 81,747,512 µs

`public.tpcb_upd_branches`	`(par_bid integer, par_delta integer)`
`RETURNS void`

Function public.tpcb() oid=66237 (show)

self_time = 3,291,322 µs
total_time = 286,005,315 µs

`public.tpcb`	`(par_aid integer, par_bid integer, par_tid integer, par_delta integer)`
`RETURNS integer`

Function public.tpcb_upd_accounts() oid=66238 (show)

self_time = 3,086,741 µs
total_time = 4,335,474 µs

`public.tpcb_upd_accounts`	`(par_aid integer, par_delta integer)`
`RETURNS integer`

Function public.tpcb_fetch_abalance() oid=66446 (show)

self_time = 1,248,733 µs
total_time = 1,248,733 µs

`public.tpcb_fetch_abalance`	`(par_aid integer)`
`RETURNS integer`

Function public.tpcb_ins_history() oid=66241 (show)

self_time = 1,150,113 µs
total_time = 1,150,113 µs

`public.tpcb_ins_history`	`(par_aid integer, par_tid integer, par_bid integer, par_delta integer)`
`RETURNS void`