PL Profiler Report for current

Example 1 for plprofiler documentation.

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_accounts() oid=66238 (show)

self_time = 575,965 µs
total_time = 1,066,077 µs

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

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

self_time = 490,112 µs
total_time = 490,112 µs

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

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

self_time = 2,878 µs
total_time = 2,878 µs

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

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

self_time = 2,832 µs
total_time = 1,073,876 µs

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

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

self_time = 1,055 µs
total_time = 1,055 µs

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

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

self_time = 1,034 µs
total_time = 1,034 µs

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