CURRENT_TIME

FERREIRA William (COFRAMI · *nix forums beginner Joined: 07 Mar 2005 Posts: 34

hi

i need to know the execution time of a part of my pl/pgsql code

so, i tried to use CURRENT_TIME :

t_time_d TIME;
t_time_f TIME;
t_diff TIME;

select CURRENT_TIME into t_time_d;

//the traitment

select CURRENT_TIME into t_time_f;
t_diff=t_time_f-t_time_d;
raise notice 'DEBUT : % | FIN : % | DIFF : % | POUR :
%',t_time_d,t_time_f,t_diff;

my function is recursive and the problem is that i always get the same
result for each iteration
t_time_d is set at the first iteration and doesn't change

thanks

Michael Glaesemann · *nix forums Guru Wannabe Joined: 15 Mar 2005 Posts: 159

On Mar 15, 2005, at 23:21, FERREIRA William (COFRAMI) wrote:

Google