Re: RAISE INFO in function - Mailing list pgsql-general

It depends on more factors - but expressions in RAISE statements are calculated every time and sometimes the result can be filtered. Inside cycles or when functions is evaluated for every row of query, then the overhead can be significant:

postgres=# do $$
begin
  for i in 1..100000 loop
    raise debug '%', i;
  end loop;
end;
$$;
DO
Time: 35,164 ms
postgres=# do $$
begin

 -- plpgsql cannot to ignore empty blocks, this loop was evaluated 100K

  for i in 1..100000 loop
    --raise debug '%', i + 1;
  end loop;
end;
$$;
DO
Time: 2,535 ms

Regards

Pavel