Re: overhead of expression evaluation - Mailing list pgsql-hackers

Hi

just for curiosity - I tested simple script

postgres=# do
$$
declare s bigint = 0;
begin
  for i in 1..1000000000 loop
    s := s + i;
  end loop;
  raise notice '%', s;
end;
$$;

to see a overhead of some components

   5,72%  plpgsql.so                             [.] exec_assign_value
   5,59%  postgres                               [.] GetSnapshotData
   4,94%  plpgsql.so                             [.] exec_eval_simple_expr
   4,84%  postgres                               [.] AllocSetAlloc
   3,61%  postgres                               [.] ResourceOwnerForgetPlanCacheRef
   2,95%  postgres                               [.] choose_custom_plan
   2,94%  postgres                               [.] GetUserId
   2,92%  postgres                               [.] GetCachedPlan
   2,87%  postgres                               [.] LWLockAttemptLock
   2,85%  postgres                               [.] memset@plt
   2,76%  postgres                               [.] LWLockRelease
   2,70%  postgres                               [.] AllocSetFree
   2,42%  plpgsql.so                             [.] assign_simple_var
   2,36%  postgres                               [.] ExecInterpExpr
   2,35%  postgres                               [.] PopActiveSnapshot
   2,27%  postgres                               [.] OverrideSearchPathMatchesCurrent
   2,22%  plpgsql.so                             [.] plpgsql_param_eval_var
   2,21%  plpgsql.so                             [.] exec_stmt
   1,89%  libc-2.27.so                           [.] __memset_sse2_unaligned_erms
   1,75%  postgres                               [.] PushActiveSnapshot
   1,74%  postgres                               [.] AcquireExecutorLocks
   1,67%  postgres                               [.] CopySnapshot
   1,64%  postgres                               [.] CheckCachedPlan
   1,56%  postgres                               [.] RevalidateCachedQuery
   1,55%  postgres                               [.] MemoryContextAlloc
   1,53%  postgres                               [.] pfree
   1,50%  postgres                               [.] ResourceArrayRemove
   1,43%  postgres                               [.] LWLockAcquire
   1,40%  postgres                               [.] SPI_plan_get_cached_plan

Regards

Pavel