PL Profile for pgbench_pl run #1

PL/pgSQL Call Graph

PL Profile for pgbench_pl run #1 Reset Zoom public.tpcb_upd_tellers() oid=66239 (2,912 samples, 0.30%) public.tpcb_upd_branches() oid=66240 (1,085 samples, 0.11%) public.tpcb_upd_accounts() oid=66238 (979,064 samples, 99.21%) public.tpcb_upd_accounts() oid=66238 all (986,899 samples, 100%) public.tpcb() oid=66237 (986,899 samples, 100.00%) public.tpcb() oid=66237 public.tpcb_fetch_abalance() oid=66446 (481,666 samples, 48.81%) public.tpcb_fetch_abalance() oid=66446 public.tpcb_ins_history() oid=66241 (943 samples, 0.10%)

List of functions detailed below

All 6 functions (by self_time)

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

self_time = 497,398 µs
total_time = 979,064 µs

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

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

self_time = 481,666 µs
total_time = 481,666 µs

public.tpcb_fetch_abalance  (par_aid integer)
    RETURNS integer

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

self_time = 2,912 µs
total_time = 2,912 µs

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

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

self_time = 2,895 µs
total_time = 986,899 µ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,085 µs
total_time = 1,085 µs

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

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

self_time = 943 µs
total_time = 943 µs

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