PL Profiler Report for tpcb-using-collect

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_fetch_abalance() oid=66446 (show)

self_time = 3,310,825,465 µs
total_time = 3,310,825,465 µs

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

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

self_time = 2,870,372,449 µs
total_time = 6,181,197,914 µs

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

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

self_time = 393,465,416 µs
total_time = 393,465,416 µs

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

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

self_time = 175,842,662 µs
total_time = 175,842,662 µs

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

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

self_time = 20,614,676 µs
total_time = 6,774,775,742 µs

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

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

self_time = 3,655,074 µs
total_time = 3,655,074 µs

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