overhead of expression evaluation
От | Pavel Stehule |
---|---|
Тема | overhead of expression evaluation |
Дата | |
Msg-id | CAFj8pRDMJh0nPW8vLvr3Gp5Nm+jyd6fKanA5Bpq50FzaL3ScWA@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: overhead of expression evaluation
|
Список | 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;
$$;
$$
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
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
В списке pgsql-hackers по дате отправления: