Re: RAISE INFO in function

[Pavel Stehule]

po 9. 11. 2020 v 14:46 odesílatel Yambu <hya...@gmail.com> napsal:

> Hi
>
> May i know if RAISE INFO impacts performance significantly in a function?
>
> Should i comment them out once i'm done using/debugging ?
>

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


> regards
>