# To display the perf.data header info, please use --header/--header-only options. # # # Total Lost Samples: 0 # # Samples: 25K of event 'cycles:ppp' # Event count (approx.): 29111914550 # # Overhead Command Shared Object Symbol # ........ ........ .................. .............................................. # 23.36% postgres postgres [.] subcolor | ---subcolor | |--21.14%--subcolorcvec | brackpart (inlined) | bracket | | | --21.14%--wordchrs | wordchrs | parseqatom (inlined) | parsebranch | | | |--19.88%--parse | | pg_regcomp | | RE_compile_and_cache | | textregexreplace_noopt | | ExecInterpExpr | | ExecEvalExpr (inlined) | | exec_eval_simple_expr (inlined) | | exec_eval_expr | | exec_assign_expr | | exec_stmt_assign (inlined) | | exec_stmt | | exec_stmts | | | | | |--18.95%--exec_stmt_block | | | exec_stmt | | | plpgsql_exec_function | | | plpgsql_call_handler | | | ExecInterpExpr | | | ExecEvalExpr (inlined) | | | exec_eval_simple_expr (inlined) | | | exec_eval_expr | | | exec_assign_expr | | | exec_stmt_assign (inlined) | | | exec_stmt | | | exec_stmts | | | exec_stmt_block | | | exec_stmt | | | plpgsql_exec_function | | | plpgsql_call_handler | | | ExecInterpExpr | | | ExecEvalExpr (inlined) | | | exec_eval_simple_expr (inlined) | | | exec_eval_expr | | | exec_stmt_return (inlined) | | | exec_stmt | | | exec_stmts | | | exec_stmt_if (inlined) | | | exec_stmt | | | exec_stmts | | | exec_stmt_if (inlined) | | | exec_stmt | | | exec_stmts | | | exec_stmt_if (inlined) | | | exec_stmt | | | exec_stmts | | | exec_stmt_block | | | exec_stmt | | | plpgsql_exec_function | | | plpgsql_call_handler | | | ExecInterpExpr | | | ExecEvalExpr (inlined) | | | exec_eval_simple_expr (inlined) | | | exec_eval_expr | | | exec_stmt_return (inlined) | | | exec_stmt | | | 0xffffffffffffffff | | | | | --0.93%--exec_stmt_if (inlined) | | exec_stmt | | exec_stmts | | exec_stmt_block | | exec_stmt | | plpgsql_exec_function | | plpgsql_call_handler | | ExecInterpExpr | | ExecEvalExpr (inlined) | | exec_eval_simple_expr (inlined) | | exec_eval_expr | | exec_assign_expr | | exec_stmt_assign (inlined) | | exec_stmt | | exec_stmts | | exec_stmt_block | | exec_stmt | | plpgsql_exec_function | | plpgsql_call_handler | | ExecInterpExpr | | ExecEvalExpr (inlined) | | exec_eval_simple_expr (inlined) | | exec_eval_expr | | exec_stmt_return (inlined) | | exec_stmt | | exec_stmts | | exec_stmt_if (inlined) | | exec_stmt | | exec_stmts | | exec_stmt_if (inlined) | | exec_stmt | | exec_stmts | | exec_stmt_if (inlined) | | exec_stmt | | exec_stmts | | exec_stmt_block | | exec_stmt | | plpgsql_exec_function | | plpgsql_call_handler | | ExecInterpExpr | | 0xffffffffffffffff | | | --1.26%--parseqatom (inlined) | parsebranch | parse | pg_regcomp | RE_compile_and_cache | textregexreplace_noopt | ExecInterpExpr | ExecEvalExpr (inlined) | exec_eval_simple_expr (inlined) | exec_eval_expr | exec_assign_expr | exec_stmt_assign (inlined) | exec_stmt | exec_stmts | exec_stmt_block | exec_stmt | plpgsql_exec_function | plpgsql_call_handler | ExecInterpExpr | ExecEvalExpr (inlined) | exec_eval_simple_expr (inlined) | exec_eval_expr | exec_assign_expr | exec_stmt_assign (inlined) | exec_stmt | exec_stmts | exec_stmt_block | exec_stmt | plpgsql_exec_function | plpgsql_call_handler | ExecInterpExpr | ExecEvalExpr (inlined) | exec_eval_simple_expr (inlined) | exec_eval_expr | exec_stmt_return (inlined) | exec_stmt | exec_stmts | exec_stmt_if (inlined) | exec_stmt | exec_stmts | exec_stmt_if (inlined) | exec_stmt | exec_stmts | exec_stmt_if (inlined) | exec_stmt | exec_stmts | exec_stmt_block | exec_stmt | plpgsql_exec_function | plpgsql_call_handler | ExecInterpExpr | ExecEvalExpr (inlined) | exec_eval_simple_expr (inlined) | exec_eval_expr | 0xffffffffffffffff | --0.74%--0x7ffdff82bb6f 7.18% postgres postgres [.] optimize.isra.52 | |--1.87%--pullback (inlined) | optimize (inlined) | | | |--1.07%--nfanode (inlined) | | | | | --0.91%--pg_regcomp | | RE_compile_and_cache | | textregexreplace_noopt | | ExecInterpExpr | | ExecEvalExpr (inlined) | | exec_eval_simple_expr (inlined) | | exec_eval_expr | | exec_assign_expr | | exec_stmt_assign (inlined) | | exec_stmt | | exec_stmts | | | | | --0.89%--exec_stmt_block | | exec_stmt | | plpgsql_exec_function | | plpgsql_call_handler | | ExecInterpExpr | | ExecEvalExpr (inlined) | | exec_eval_simple_expr (inlined) | | exec_eval_expr | | exec_assign_expr | | exec_stmt_assign (inlined) | | exec_stmt | | exec_stmts | | exec_stmt_block | | exec_stmt | | plpgsql_exec_function | | plpgsql_call_handler | | ExecInterpExpr | | ExecEvalExpr (inlined) | | exec_eval_simple_expr (inlined) | | exec_eval_expr | | exec_stmt_return (inlined) | | exec_stmt | | exec_stmts | | exec_stmt_if (inlined) | | exec_stmt | | exec_stmts | | exec_stmt_if (inlined) | | exec_stmt | | exec_stmts | | exec_stmt_if (inlined) | | exec_stmt | | exec_stmts | | exec_stmt_block | | exec_stmt | | plpgsql_exec_function | | plpgsql_call_handler | | ExecInterpExpr | | ExecEvalExpr (inlined) | | exec_eval_simple_expr (inlined) | | exec_eval_expr | | exec_stmt_return (inlined) | | exec_stmt | | exec_stmts | | exec_stmt_block | | 0xffffffffffffffff | | | --0.80%--pg_regcomp | RE_compile_and_cache | textregexreplace_noopt | ExecInterpExpr | ExecEvalExpr (inlined) | exec_eval_simple_expr (inlined) | exec_eval_expr | exec_assign_expr | exec_stmt_assign (inlined) | exec_stmt | exec_stmts | | | --0.77%--exec_stmt_block | exec_stmt | plpgsql_exec_function | plpgsql_call_handler | ExecInterpExpr | ExecEvalExpr (inlined) | exec_eval_simple_expr (inlined) | exec_eval_expr | exec_assign_expr | exec_stmt_assign (inlined) | exec_stmt | exec_stmts | exec_stmt_block | exec_stmt | plpgsql_exec_function | plpgsql_call_handler | ExecInterpExpr | ExecEvalExpr (inlined) | exec_eval_simple_expr (inlined) | exec_eval_expr | exec_stmt_return (inlined) | exec_stmt | exec_stmts | exec_stmt_if (inlined) | exec_stmt | exec_stmts | exec_stmt_if (inlined) | exec_stmt | exec_stmts | exec_stmt_if (inlined) | exec_stmt | exec_stmts | exec_stmt_block | exec_stmt | plpgsql_exec_function | plpgsql_call_handler | ExecInterpExpr | ExecEvalExpr (inlined) | exec_eval_simple_expr (inlined) | exec_eval_expr | exec_stmt_return (inlined) | exec_stmt | exec_stmts | exec_stmt_block | 0xffffffffffffffff | |--1.51%--fixempties (inlined) | optimize (inlined) | | | |--0.92%--nfanode (inlined) | | | | | --0.72%--pg_regcomp | | RE_compile_and_cache | | textregexreplace_noopt | | ExecInterpExpr | | ExecEvalExpr (inlined) | | exec_eval_simple_expr (inlined) | | exec_eval_expr | | exec_assign_expr | | exec_stmt_assign (inlined) | | exec_stmt | | exec_stmts | | | | | --0.71%--exec_stmt_block | | exec_stmt | | plpgsql_exec_function | | plpgsql_call_handler | | ExecInterpExpr | | ExecEvalExpr (inlined) | | exec_eval_simple_expr (inlined) | | exec_eval_expr | | exec_assign_expr | | exec_stmt_assign (inlined) | | exec_stmt | | exec_stmts | | exec_stmt_block | | exec_stmt | | plpgsql_exec_function | | plpgsql_call_handler | | ExecInterpExpr | | ExecEvalExpr (inlined) | | exec_eval_simple_expr (inlined) | | exec_eval_expr | | exec_stmt_return (inlined) | | exec_stmt | | exec_stmts | | exec_stmt_if (inlined) | | exec_stmt | | exec_stmts | | exec_stmt_if (inlined) | | exec_stmt | | exec_stmts | | exec_stmt_if (inlined) | | exec_stmt | | exec_stmts | | exec_stmt_block | | exec_stmt | | plpgsql_exec_function | | plpgsql_call_handler | | ExecInterpExpr | | ExecEvalExpr (inlined) | | exec_eval_simple_expr (inlined) | | exec_eval_expr | | exec_stmt_return (inlined) | | exec_stmt | | exec_stmts | | exec_stmt_block | | 0xffffffffffffffff | | | --0.59%--pg_regcomp | RE_compile_and_cache | textregexreplace_noopt | ExecInterpExpr | ExecEvalExpr (inlined) | exec_eval_simple_expr (inlined) | exec_eval_expr | exec_assign_expr | exec_stmt_assign (inlined) | exec_stmt | exec_stmts | | | --0.58%--exec_stmt_block | exec_stmt | plpgsql_exec_function | plpgsql_call_handler | ExecInterpExpr | ExecEvalExpr (inlined) | exec_eval_simple_expr (inlined) | exec_eval_expr | exec_assign_expr | exec_stmt_assign (inlined) | exec_stmt | exec_stmts | exec_stmt_block | exec_stmt | plpgsql_exec_function | plpgsql_call_handler | ExecInterpExpr | ExecEvalExpr (inlined) | exec_eval_simple_expr (inlined) | exec_eval_expr | exec_stmt_return (inlined) | exec_stmt | exec_stmts | exec_stmt_if (inlined) | exec_stmt | exec_stmts | exec_stmt_if (inlined) | exec_stmt | exec_stmts | exec_stmt_if (inlined) | exec_stmt | exec_stmts | exec_stmt_block | exec_stmt | plpgsql_exec_function | plpgsql_call_handler | ExecInterpExpr | ExecEvalExpr (inlined) | exec_eval_simple_expr (inlined) | exec_eval_expr | exec_stmt_return (inlined) | exec_stmt | exec_stmts | exec_stmt_block | 0xffffffffffffffff | |--1.19%--pushfwd (inlined) | optimize (inlined) | | | --0.69%--nfanode (inlined) | | | --0.56%--pg_regcomp | RE_compile_and_cache | textregexreplace_noopt | ExecInterpExpr | ExecEvalExpr (inlined) | exec_eval_simple_expr (inlined) | exec_eval_expr | exec_assign_expr | exec_stmt_assign (inlined) | exec_stmt | exec_stmts | | | --0.53%--exec_stmt_block | exec_stmt | plpgsql_exec_function | plpgsql_call_handler | ExecInterpExpr | ExecEvalExpr (inlined) | exec_eval_simple_expr (inlined) | exec_eval_expr | exec_assign_expr | exec_stmt_assign (inlined) | exec_stmt | exec_stmts | exec_stmt_block | exec_stmt | plpgsql_exec_function | plpgsql_call_handler | ExecInterpExpr | ExecEvalExpr (inlined) | exec_eval_simple_expr (inlined) | exec_eval_expr | exec_stmt_return (inlined) | exec_stmt | exec_stmts | exec_stmt_if (inlined) | exec_stmt | exec_stmts | exec_stmt_if (inlined) | exec_stmt | exec_stmts | exec_stmt_if (inlined) | exec_stmt | exec_stmts | exec_stmt_block | exec_stmt | plpgsql_exec_function | plpgsql_call_handler | ExecInterpExpr | ExecEvalExpr (inlined) | exec_eval_simple_expr (inlined) | exec_eval_expr | exec_stmt_return (inlined) | exec_stmt | exec_stmts | exec_stmt_block | 0xffffffffffffffff | |--0.94%--fixconstraintloops (inlined) | optimize (inlined) | | | --0.61%--nfanode (inlined) | --0.57%--push (inlined) pushfwd (inlined) optimize (inlined) 7.10% postgres postgres [.] newsub | ---newsub | --6.17%--subcolor | --5.97%--subcolorcvec brackpart (inlined) bracket | --5.96%--wordchrs wordchrs parseqatom (inlined) parsebranch | --5.62%--parse pg_regcomp RE_compile_and_cache textregexreplace_noopt ExecInterpExpr ExecEvalExpr (inlined) exec_eval_simple_expr (inlined) exec_eval_expr exec_assign_expr exec_stmt_assign (inlined) exec_stmt exec_stmts | --5.36%--exec_stmt_block exec_stmt plpgsql_exec_function plpgsql_call_handler ExecInterpExpr ExecEvalExpr (inlined) exec_eval_simple_expr (inlined) exec_eval_expr exec_assign_expr exec_stmt_assign (inlined) exec_stmt exec_stmts exec_stmt_block exec_stmt plpgsql_exec_function plpgsql_call_handler ExecInterpExpr ExecEvalExpr (inlined) exec_eval_simple_expr (inlined) exec_eval_expr exec_stmt_return (inlined) exec_stmt exec_stmts exec_stmt_if (inlined) exec_stmt exec_stmts exec_stmt_if (inlined) exec_stmt exec_stmts exec_stmt_if (inlined) exec_stmt exec_stmts exec_stmt_block exec_stmt plpgsql_exec_function plpgsql_call_handler ExecInterpExpr ExecEvalExpr (inlined) exec_eval_simple_expr (inlined) exec_eval_expr exec_stmt_return (inlined) exec_stmt 0xffffffffffffffff 6.96% postgres postgres [.] subcolorcvec | --6.74%--subcolorcvec brackpart (inlined) bracket | --6.73%--wordchrs wordchrs parseqatom (inlined) parsebranch | --6.29%--parse pg_regcomp RE_compile_and_cache textregexreplace_noopt ExecInterpExpr ExecEvalExpr (inlined) exec_eval_simple_expr (inlined) exec_eval_expr exec_assign_expr exec_stmt_assign (inlined) exec_stmt exec_stmts | --5.99%--exec_stmt_block exec_stmt plpgsql_exec_function plpgsql_call_handler ExecInterpExpr ExecEvalExpr (inlined) exec_eval_simple_expr (inlined) exec_eval_expr exec_assign_expr exec_stmt_assign (inlined) exec_stmt exec_stmts exec_stmt_block exec_stmt plpgsql_exec_function plpgsql_call_handler ExecInterpExpr ExecEvalExpr (inlined) exec_eval_simple_expr (inlined) exec_eval_expr exec_stmt_return (inlined) exec_stmt exec_stmts exec_stmt_if (inlined) exec_stmt exec_stmts exec_stmt_if (inlined) exec_stmt exec_stmts exec_stmt_if (inlined) exec_stmt exec_stmts exec_stmt_block exec_stmt plpgsql_exec_function plpgsql_call_handler ExecInterpExpr ExecEvalExpr (inlined) exec_eval_simple_expr (inlined) exec_eval_expr exec_stmt_return (inlined) exec_stmt 0xffffffffffffffff 5.48% postgres postgres [.] newarc | ---newarc | |--2.95%--newarc | | | --1.39%--cparc (inlined) | | | --0.66%--copyouts | | | --0.65%--push (inlined) | pushfwd (inlined) | optimize (inlined) | --1.05%--cparc (inlined) 5.31% postgres postgres [.] createarc | |--3.68%--createarc | | | --1.91%--cparc (inlined) | | | |--0.61%--moveins | | | --0.57%--copyouts | | | --0.56%--push (inlined) | pushfwd (inlined) | optimize (inlined) | |--0.95%--colorchain (inlined) | createarc | --0.68%--allocarc (inlined) createarc 3.84% postgres postgres [.] freearc.isra.4 | --3.35%--freearc (inlined) | |--1.27%--push (inlined) | pushfwd (inlined) | optimize (inlined) | | | |--0.69%--pg_regcomp | | RE_compile_and_cache | | textregexreplace_noopt | | ExecInterpExpr | | ExecEvalExpr (inlined) | | exec_eval_simple_expr (inlined) | | exec_eval_expr | | exec_assign_expr | | exec_stmt_assign (inlined) | | exec_stmt | | exec_stmts | | | | | --0.65%--exec_stmt_block | | exec_stmt | | plpgsql_exec_function | | plpgsql_call_handler | | ExecInterpExpr | | ExecEvalExpr (inlined) | | exec_eval_simple_expr (inlined) | | exec_eval_expr | | exec_assign_expr | | exec_stmt_assign (inlined) | | exec_stmt | | exec_stmts | | exec_stmt_block | | exec_stmt | | plpgsql_exec_function | | plpgsql_call_handler | | ExecInterpExpr | | ExecEvalExpr (inlined) | | exec_eval_simple_expr (inlined) | | exec_eval_expr | | exec_stmt_return (inlined) | | exec_stmt | | exec_stmts | | exec_stmt_if (inlined) | | exec_stmt | | exec_stmts | | exec_stmt_if (inlined) | | exec_stmt | | exec_stmts | | exec_stmt_if (inlined) | | exec_stmt | | exec_stmts | | exec_stmt_block | | exec_stmt | | plpgsql_exec_function | | plpgsql_call_handler | | ExecInterpExpr | | ExecEvalExpr (inlined) | | exec_eval_simple_expr (inlined) | | exec_eval_expr | | exec_stmt_return (inlined) | | exec_stmt | | exec_stmts | | exec_stmt_block | | 0xffffffffffffffff | | | --0.57%--nfanode (inlined) | |--0.75%--pull (inlined) | pullback (inlined) | optimize (inlined) | --0.65%--moveins 2.82% postgres postgres [.] stack_is_too_deep | ---stack_is_too_deep | --2.42%--rstacktoodeep | |--0.72%--cleartraverse (inlined) | | | --0.70%--cleartraverse (inlined) | |--0.65%--markcanreach (inlined) | | | --0.60%--markcanreach (inlined) | markcanreach (inlined) | --0.59%--markreachable (inlined) | --0.55%--markreachable (inlined) markreachable (inlined) 2.58% postgres libc-2.28.so [.] _int_malloc | --2.52%--_int_malloc | --2.01%--__GI___libc_malloc (inlined) | |--1.34%--newstate | | | --0.60%--duptraverse (inlined) | duptraverse (inlined) | duptraverse (inlined) | | | --0.57%--duptraverse (inlined) | duptraverse (inlined) | | | --0.54%--duptraverse (inlined) | duptraverse (inlined) | | | --0.51%--duptraverse (inlined) | duptraverse (inlined) | --0.56%--newdfa (inlined) | --0.52%--find (inlined) pg_regexec 0xffffffffffffffff 2.53% postgres libc-2.28.so [.] malloc | |--1.86%--__GI___libc_malloc (inlined) | | | --0.64%--newstate | --0.67%--tcache_get (inlined) __GI___libc_malloc (inlined) 2.02% postgres libc-2.28.so [.] _int_free | --1.92%--_int_free | --1.31%--destroystate (inlined) freenfa | |--0.71%--nfanode (inlined) | | | --0.56%--pg_regcomp | RE_compile_and_cache | textregexreplace_noopt | ExecInterpExpr | ExecEvalExpr (inlined) | exec_eval_simple_expr (inlined) | exec_eval_expr | exec_assign_expr | exec_stmt_assign (inlined) | exec_stmt | exec_stmts | | | --0.56%--exec_stmt_block | exec_stmt | plpgsql_exec_function | plpgsql_call_handler | ExecInterpExpr | ExecEvalExpr (inlined) | exec_eval_simple_expr (inlined) | exec_eval_expr | exec_assign_expr | exec_stmt_assign (inlined) | exec_stmt | exec_stmts | exec_stmt_block | exec_stmt | plpgsql_exec_function | plpgsql_call_handler | ExecInterpExpr | ExecEvalExpr (inlined) | exec_eval_simple_expr (inlined) | exec_eval_expr | exec_stmt_return (inlined) | exec_stmt | exec_stmts | exec_stmt_if (inlined) | exec_stmt | exec_stmts | exec_stmt_if (inlined) | exec_stmt | exec_stmts | exec_stmt_if (inlined) | exec_stmt | exec_stmts | exec_stmt_block | exec_stmt | plpgsql_exec_function | plpgsql_call_handler | ExecInterpExpr | ExecEvalExpr (inlined) | exec_eval_simple_expr (inlined) | exec_eval_expr | exec_stmt_return (inlined) | exec_stmt | exec_stmts | exec_stmt_block | 0xffffffffffffffff | --0.60%--freev pg_regcomp RE_compile_and_cache textregexreplace_noopt ExecInterpExpr ExecEvalExpr (inlined) exec_eval_simple_expr (inlined) exec_eval_expr exec_assign_expr exec_stmt_assign (inlined) exec_stmt exec_stmts | --0.59%--exec_stmt_block exec_stmt plpgsql_exec_function plpgsql_call_handler ExecInterpExpr ExecEvalExpr (inlined) exec_eval_simple_expr (inlined) exec_eval_expr exec_assign_expr exec_stmt_assign (inlined) exec_stmt exec_stmts exec_stmt_block exec_stmt plpgsql_exec_function plpgsql_call_handler ExecInterpExpr ExecEvalExpr (inlined) exec_eval_simple_expr (inlined) exec_eval_expr exec_stmt_return (inlined) exec_stmt exec_stmts exec_stmt_if (inlined) exec_stmt exec_stmts exec_stmt_if (inlined) exec_stmt exec_stmts exec_stmt_if (inlined) exec_stmt exec_stmts exec_stmt_block exec_stmt plpgsql_exec_function plpgsql_call_handler ExecInterpExpr ExecEvalExpr (inlined) exec_eval_simple_expr (inlined) exec_eval_expr exec_stmt_return (inlined) exec_stmt exec_stmts exec_stmt_block 0xffffffffffffffff 1.80% postgres libc-2.28.so [.] cfree@GLIBC_2.2.5 | ---__GI___libc_free (inlined) 1.75% postgres postgres [.] markreachable.isra.11.constprop.57 | ---markreachable (inlined) | --1.57%--markreachable (inlined) | --1.39%--markreachable (inlined) | --1.15%--markreachable (inlined) | --1.12%--markreachable (inlined) | --1.07%--markreachable (inlined) | --1.05%--markreachable (inlined) | --0.99%--markreachable (inlined) | --0.98%--markreachable (inlined) | --0.92%--markreachable (inlined) | --0.90%--markreachable (inlined) | --0.85%--markreachable (inlined) | --0.84%--markreachable (inlined) | --0.79%--markreachable (inlined) | --0.75%--markreachable (inlined) | --0.67%--markreachable (inlined) | --0.63%--markreachable (inlined) | --0.54%--markreachable (inlined) 1.73% postgres postgres [.] markcanreach.isra.13 | ---markcanreach (inlined) | --1.53%--markcanreach (inlined) | --1.42%--markcanreach (inlined) | --1.15%--markcanreach (inlined) | --1.13%--markcanreach (inlined) | --1.05%--markcanreach (inlined) | --0.99%--markcanreach (inlined) | --0.86%--markcanreach (inlined) | --0.82%--markcanreach (inlined) | --0.73%--markcanreach (inlined) | --0.72%--markcanreach (inlined) | --0.67%--markcanreach (inlined) | --0.66%--markcanreach (inlined) | --0.60%--markcanreach (inlined) | --0.58%--markcanreach (inlined) | --0.54%--markcanreach (inlined) 1.71% postgres postgres [.] cleartraverse.isra.6 | ---cleartraverse (inlined) | --1.40%--cleartraverse (inlined) | --1.09%--cleartraverse (inlined) | --1.00%--cleartraverse (inlined) | --0.91%--cleartraverse (inlined) | --0.89%--cleartraverse (inlined) | --0.82%--cleartraverse (inlined) | --0.76%--cleartraverse (inlined) | --0.68%--cleartraverse (inlined) | --0.56%--cleartraverse (inlined) 1.69% postgres postgres [.] pg_qsort | ---pg_qsort | --1.15%--carcsort (inlined) compact | --0.71%--pg_regcomp RE_compile_and_cache textregexreplace_noopt ExecInterpExpr ExecEvalExpr (inlined) exec_eval_simple_expr (inlined) exec_eval_expr exec_assign_expr exec_stmt_assign (inlined) exec_stmt exec_stmts | --0.68%--exec_stmt_block exec_stmt plpgsql_exec_function plpgsql_call_handler ExecInterpExpr ExecEvalExpr (inlined) exec_eval_simple_expr (inlined) exec_eval_expr exec_assign_expr exec_stmt_assign (inlined) exec_stmt exec_stmts exec_stmt_block exec_stmt plpgsql_exec_function plpgsql_call_handler ExecInterpExpr ExecEvalExpr (inlined) exec_eval_simple_expr (inlined) exec_eval_expr exec_stmt_return (inlined) exec_stmt exec_stmts exec_stmt_if (inlined) exec_stmt exec_stmts exec_stmt_if (inlined) exec_stmt exec_stmts exec_stmt_if (inlined) exec_stmt exec_stmts exec_stmt_block exec_stmt plpgsql_exec_function plpgsql_call_handler ExecInterpExpr ExecEvalExpr (inlined) exec_eval_simple_expr (inlined) exec_eval_expr exec_stmt_return (inlined) exec_stmt exec_stmts exec_stmt_block 0xffffffffffffffff 1.31% postgres postgres [.] miss | --1.25%--miss | --1.21%--shortest | --1.19%--find (inlined) pg_regexec 0xffffffffffffffff 1.27% postgres postgres [.] compact | --1.24%--compact | |--0.64%--pg_regcomp | RE_compile_and_cache | textregexreplace_noopt | ExecInterpExpr | ExecEvalExpr (inlined) | exec_eval_simple_expr (inlined) | exec_eval_expr | exec_assign_expr | exec_stmt_assign (inlined) | exec_stmt | exec_stmts | | | --0.63%--exec_stmt_block | exec_stmt | plpgsql_exec_function | plpgsql_call_handler | ExecInterpExpr | ExecEvalExpr (inlined) | exec_eval_simple_expr (inlined) | exec_eval_expr | exec_assign_expr | exec_stmt_assign (inlined) | exec_stmt | exec_stmts | exec_stmt_block | exec_stmt | plpgsql_exec_function | plpgsql_call_handler | ExecInterpExpr | ExecEvalExpr (inlined) | exec_eval_simple_expr (inlined) | exec_eval_expr | exec_stmt_return (inlined) | exec_stmt | exec_stmts | exec_stmt_if (inlined) | exec_stmt | exec_stmts | exec_stmt_if (inlined) | exec_stmt | exec_stmts | exec_stmt_if (inlined) | exec_stmt | exec_stmts | exec_stmt_block | exec_stmt | plpgsql_exec_function | plpgsql_call_handler | ExecInterpExpr | ExecEvalExpr (inlined) | exec_eval_simple_expr (inlined) | exec_eval_expr | exec_stmt_return (inlined) | exec_stmt | exec_stmts | exec_stmt_block | exec_stmt | 0xffffffffffffffff | --0.59%--nfanode (inlined) 1.13% postgres postgres [.] findconstraintloop | --0.97%--findconstraintloop | --0.63%--fixconstraintloops (inlined) optimize (inlined) 0.92% postgres postgres [.] freenfa 0.86% postgres postgres [.] rstacktoodeep | ---rstacktoodeep 0.84% postgres postgres [.] carc_cmp | ---carc_cmp 0.82% postgres postgres [.] newstate | ---newstate 0.70% postgres libc-2.28.so [.] __memmove_avx_unaligned_erms | ---__memmove_avx_unaligned_erms 0.63% postgres postgres [.] getvacant 0.57% postgres postgres [.] emptyreachable | ---emptyreachable | --0.51%--fixempties (inlined) optimize (inlined) 0.54% postgres postgres [.] cleanup.part.15 | ---cleanup (inlined) | --0.53%--cleanup (inlined) optimize (inlined) 0.49% postgres postgres [.] duptraverse.isra.23 0.47% postgres postgres [.] okcolors 0.45% postgres postgres [.] next.part.37 0.39% postgres postgres [.] makesearch.isra.50 0.38% postgres postgres [.] rcancelrequested 0.37% postgres postgres [.] moveins 0.35% postgres postgres [.] rainbow.constprop.59 0.35% postgres postgres [.] combine.isra.8 0.34% postgres postgres [.] dropstate 0.31% postgres postgres [.] ExecInterpExpr 0.30% postgres postgres [.] colorcomplement.isra.27 0.30% postgres postgres [.] subcoloronechr 0.30% postgres postgres [.] parsebranch 0.27% postgres postgres [.] shortest 0.23% postgres postgres [.] copyouts 0.21% postgres postgres [.] sortins_cmp 0.21% postgres postgres [.] SPI_plan_get_cached_plan 0.19% postgres libc-2.28.so [.] __memset_avx2_erms 0.19% postgres libc-2.28.so [.] __memcmp_avx2_movbe 0.18% postgres postgres [.] RE_compile_and_cache 0.17% postgres postgres [.] newcolor 0.15% postgres postgres [.] AcquireExecutorLocks 0.15% postgres postgres [.] pg_regcomp 0.14% postgres plpgsql.so [.] exec_stmt 0.14% postgres libc-2.28.so [.] malloc_consolidate 0.12% postgres postgres [.] pg_regexec 0.12% postgres postgres [.] nocachegetattr 0.12% postgres postgres [.] rfree.part.29 0.12% postgres plpgsql.so [.] plpgsql_param_eval_var_ro 0.11% postgres postgres [.] pfree 0.11% postgres postgres [.] AllocSetAlloc 0.10% postgres postgres [.] palloc 0.10% postgres postgres [.] moveouts 0.09% postgres libc-2.28.so [.] __libc_calloc 0.09% postgres plpgsql.so [.] exec_eval_expr 0.09% postgres postgres [.] replace_text_regexp 0.09% postgres postgres [.] pg_utf2wchar_with_len 0.09% postgres postgres [.] pg_detoast_datum_packed 0.08% postgres postgres [.] RevalidateCachedQuery 0.08% postgres libc-2.28.so [.] __memset_avx2_unaligned_erms 0.08% postgres postgres [.] AllocSetFree 0.08% postgres postgres [.] malloc@plt 0.07% postgres postgres [.] bracket 0.07% postgres postgres [.] free@plt 0.07% postgres libc-2.28.so [.] realloc 0.07% postgres postgres [.] OverrideSearchPathMatchesCurrent 0.07% postgres postgres [.] AllocSetReset 0.07% postgres postgres [.] hash_search_with_hash_value 0.07% postgres postgres [.] pseudocolor 0.07% postgres postgres [.] ReleaseCachedPlan 0.07% postgres postgres [.] newnfa 0.07% postgres postgres [.] tts_buffer_heap_getsomeattrs 0.06% postgres plpgsql.so [.] exec_stmts 0.06% postgres postgres [.] ResourceArrayRemove 0.06% postgres postgres [.] freesubre 0.05% postgres libc-2.28.so [.] __GI___iswalnum 0.05% postgres postgres [.] onechr 0.05% postgres postgres [.] subre 0.05% postgres postgres [.] pg_mbstrlen_with_len 0.05% postgres postgres [.] MakeExpandedObjectReadOnlyInternal 0.05% postgres postgres [.] MemoryContextReset 0.05% postgres postgres [.] med3 0.04% postgres plpgsql.so [.] exec_assign_value 0.04% postgres postgres [.] pg_mblen 0.04% postgres postgres [.] initialize 0.04% postgres postgres [.] byteaout 0.04% postgres plpgsql.so [.] exec_eval_cleanup.isra.16 0.04% postgres postgres [.] MemoryContextResetOnly 0.04% postgres postgres [.] newdfa.isra.3 0.04% postgres postgres [.] nfanode.isra.53 0.04% postgres plpgsql.so [.] plpgsql_call_handler 0.04% postgres postgres [.] sortins.isra.43 0.04% postgres postgres [.] GetCachedPlan 0.04% postgres postgres [.] parse 0.04% postgres plpgsql.so [.] plpgsql_compile 0.04% postgres postgres [.] cleanst.isra.31 0.04% postgres plpgsql.so [.] assign_simple_var 0.03% postgres postgres [.] specialcolors 0.03% postgres plpgsql.so [.] plpgsql_exec_function 0.03% postgres postgres [.] heap_compute_data_size 0.03% postgres postgres [.] swapfunc 0.03% postgres postgres [.] wordchrs 0.03% postgres postgres [.] freedfa 0.03% postgres plpgsql.so [.] copy_plpgsql_datums.isra.11.constprop.37 0.03% postgres postgres [.] text_substring 0.03% postgres postgres [.] pg_mb2wchar_with_len 0.03% postgres postgres [.] comparetup_heap 0.03% postgres postgres [.] pg_detoast_datum 0.03% postgres postgres [.] pg_set_regex_collation 0.03% postgres postgres [.] heap_page_prune_opt 0.03% postgres libc-2.28.so [.] @plt 0.03% postgres postgres [.] heap_fill_tuple 0.03% postgres postgres [.] datumCopy 0.02% postgres postgres [.] pg_char_and_wchar_strncmp 0.02% postgres postgres [.] array_in 0.02% postgres postgres [.] AllocSetContextCreateInternal 0.02% postgres postgres [.] appendBinaryStringInfo 0.02% postgres hstore.so [.] hstoreFindKey 0.02% postgres plpgsql.so [.] exec_cast_value 0.02% postgres postgres [.] heap_hot_search_buffer 0.02% postgres postgres [.] pg_utf_mblen 0.02% postgres postgres [.] SPI_finish 0.02% postgres postgres [.] ScanQueryForLocks 0.02% postgres postgres [.] CreateExprContext 0.02% postgres plpgsql.so [.] exec_stmt_block 0.02% postgres postgres [.] LWLockRelease 0.02% postgres postgres [.] heap_tuple_untoast_attr 0.02% postgres postgres [.] list_delete_ptr 0.02% postgres postgres [.] hash_any 0.02% postgres plpgsql.so [.] exec_assign_expr 0.02% postgres postgres [.] pg_database_encoding_max_length 0.02% postgres postgres [.] SearchCatCache1 0.02% postgres libc-2.28.so [.] _int_realloc 0.02% postgres postgres [.] ExecHashJoin 0.02% postgres postgres [.] gistScanPage 0.02% postgres postgres [.] subcolorhi 0.02% postgres postgres [.] textregexreplace_noopt 0.02% postgres postgres [.] freecnfa 0.02% postgres postgres [.] numst 0.02% postgres postgres [.] pg_regfree 0.02% postgres postgres [.] GetDatabaseEncoding 0.02% postgres [e1000e] [k] e1000_irq_enable 0.02% postgres postgres [.] ExecScan 0.02% postgres postgres [.] ArrayCount 0.01% postgres postgres [.] newcvec 0.01% postgres hstore.so [.] hstore_fetchval 0.01% postgres postgres [.] scanplain 0.01% postgres postgres [.] slot_getsomeattrs_int 0.01% postgres postgres [.] SPI_datumTransfer 0.01% postgres postgres [.] pg_ctype_get_cache 0.01% postgres postgres [.] MemoryContextDelete 0.01% postgres postgres [.] LWLockAttemptLock 0.01% postgres postgres [.] GetCurrentSubTransactionId 0.01% postgres libc-2.28.so [.] __GI_iswalpha 0.01% postgres postgres [.] recomputeNamespacePath 0.01% postgres postgres [.] texteq 0.01% postgres postgres [.] nfatree.constprop.55 0.01% postgres postgres [.] text_position_setup 0.01% postgres postgres [.] ExecEvalScalarArrayOp 0.01% postgres postgres [.] SPI_connect_ext 0.01% postgres postgres [.] markst 0.01% postgres postgres [.] GetPrivateRefCountEntry 0.01% postgres postgres [.] ResourceOwnerForgetPlanCacheRef 0.01% postgres plpgsql.so [.] plpgsql_param_eval_var 0.01% postgres [kernel.kallsyms] [k] prepare_exit_to_usermode 0.01% postgres postgres [.] ExecHashGetHashValue 0.01% postgres hstore.so [.] pg_detoast_datum_packed@plt 0.01% postgres libc-2.28.so [.] __strlen_avx2 0.01% postgres postgres [.] CatalogCacheComputeHashValue 0.01% postgres postgres [.] heapgettup_pagemode 0.01% postgres postgres [.] _bt_compare 0.01% postgres plpgsql.so [.] plpgsql_destroy_econtext.isra.33 0.01% postgres postgres [.] AcquirePlannerLocks 0.01% postgres plpgsql.so [.] exec_eval_boolean 0.01% postgres postgres [.] gistdentryinit.part.0 0.01% postgres postgres [.] MemoryContextCreate 0.01% postgres postgres [.] UnpinBuffer.constprop.11 0.01% postgres postgres [.] realloc@plt 0.01% postgres postgres [.] textpos 0.01% postgres postgres [.] datumTransfer 0.01% postgres postgres [.] cstring_to_text_with_len 0.01% postgres postgres [.] 0x00000000000b7e20 0.01% postgres plpgsql.so [.] ReleaseCachedPlan@plt 0.01% postgres postgres [.] ResourceArrayAdd 0.01% postgres libc-2.28.so [.] __strcoll_l 0.01% postgres postgres [.] toast_raw_datum_size 0.01% postgres plpgsql.so [.] plpgsql_create_econtext.isra.12 0.01% postgres postgres [.] freev 0.01% postgres postgres [.] ItemPointerEquals 0.01% postgres postgres [.] ShutdownExprContext 0.01% postgres postgres [.] expand_array 0.01% postgres postgres [.] ExecScanHashBucket 0.01% postgres postgres [.] dupnfa 0.01% postgres postgres [.] MemoryContextAlloc 0.01% postgres plpgsql.so [.] datumTransfer@plt 0.01% postgres postgres [.] lexescape 0.01% postgres postgres [.] int4gt 0.01% postgres postgres [.] MemoryContextSetParent 0.01% postgres postgres [.] printtup 0.01% postgres postgres [.] base_yyparse 0.00% postgres [kernel.kallsyms] [k] native_write_msr 0.00% postgres [kernel.kallsyms] [k] swapgs_restore_regs_and_return_to_usermode 0.00% postgres postgres [.] choose_custom_plan 0.00% postgres postgres [.] initStringInfo 0.00% postgres postgres [.] heap_form_minimal_tuple 0.00% postgres [kernel.kallsyms] [k] __intel_pmu_disable_all 0.00% postgres plpgsql.so [.] SPI_plan_get_cached_plan@plt 0.00% postgres [kernel.kallsyms] [k] __calc_delta 0.00% postgres [kernel.kallsyms] [k] cpuacct_account_field 0.00% postgres postgres [.] MemoryContextAllocZeroAligned 0.00% postgres postgres [.] cdissect 0.00% postgres postgres [.] ReadBufferExtended 0.00% postgres postgres [.] hash_uint32 0.00% postgres postgres [.] nonword 0.00% postgres postgres [.] ExecSort 0.00% postgres postgres [.] bytea_catenate 0.00% postgres postgres [.] __memmove_chk@plt 0.00% postgres [kernel.kallsyms] [k] switch_to_thread_stack 0.00% postgres postgres [.] LockRelationOid 0.00% postgres [kernel.kallsyms] [k] update_wall_time 0.00% postgres [kernel.kallsyms] [k] rcu_check_callbacks 0.00% postgres [kernel.kallsyms] [k] clear_page_erms 0.00% postgres postgres [.] text_position 0.00% postgres postgres [.] index_getnext_tid 0.00% postgres [kernel.kallsyms] [k] get_page_from_freelist 0.00% postgres [kernel.kallsyms] [k] native_irq_return_iret 0.00% postgres postgres [.] enlargeStringInfo 0.00% postgres postgis-3.so [.] gserialized_gist_decompress_2d 0.00% postgres [kernel.kallsyms] [k] __update_load_avg_se.isra.37 0.00% postgres postgres [.] EOH_init_header 0.00% postgres plpgsql.so [.] plpgsql_estate_setup 0.00% postgres postgres [.] lc_ctype_is_c 0.00% postgres postgres [.] heapam_index_fetch_tuple 0.00% postgres [kernel.kallsyms] [k] hrtimer_interrupt 0.00% postgres postgres [.] merge.isra.0.part.1 0.00% postgres hstore.so [.] hstore_exists 0.00% postgres [kernel.kallsyms] [k] __handle_mm_fault 0.00% postgres [kernel.kallsyms] [k] rcu_segcblist_ready_cbs 0.00% postgres [kernel.kallsyms] [k] mem_cgroup_commit_charge 0.00% postgres libc-2.28.so [.] __sigsetjmp 0.00% postgres postgres [.] ReleaseAndReadBuffer 0.00% postgres postgres [.] PinBuffer 0.00% postgres postgres [.] GetUserId 0.00% postgres [kernel.kallsyms] [k] cpu_needs_another_gp 0.00% postgres plpgsql.so [.] MakeExpandedObjectReadOnlyInternal@plt 0.00% postgres postgres [.] IndexNext 0.00% postgres postgres [.] pstrdup 0.00% postgres postgis-3.so [.] gserialized_gist_consistent_2d 0.00% postgres plpgsql.so [.] palloc@plt 0.00% postgres [e1000e] [k] e1000_intr_msi 0.00% postgres postgres [.] ExecStoreBufferHeapTuple 0.00% postgres hstore.so [.] hstoreFindKey@plt 0.00% postgres postgres [.] FreeExprContext 0.00% postgres postgres [.] puttuple_common 0.00% postgres postgres [.] index_beginscan_internal 0.00% postgres postgres [.] lcons 0.00% postgres postgres [.] get_typlenbyvalalign 0.00% postgres postgres [.] InputFunctionCall 0.00% postgres postgres [.] varstrfastcmp_locale.isra.6 0.00% postgres postgres [.] ReleaseSysCache 0.00% postgres postgres [.] list_free_private 0.00% postgres postgres [.] repeat 0.00% postgres [kernel.kallsyms] [k] calc_global_load_tick 0.00% postgres postgres [.] LWLockAcquire 0.00% postgres [kernel.kallsyms] [k] update_fast_timekeeper 0.00% postgres [kernel.kallsyms] [k] __hrtimer_run_queues 0.00% postgres postgres [.] btgettuple 0.00% postgres postgres [.] get_hash_value 0.00% postgres postgres [.] RelationDecrementReferenceCount 0.00% postgres postgres [.] ExecHashGetSkewBucket 0.00% postgres postgis-3.so [.] box2df_overlaps 0.00% postgres postgis-3.so [.] 0x00000000000c272a 0.00% postgres [kernel.kallsyms] [k] rb_next 0.00% postgres postgres [.] memmove@plt 0.00% postgres postgres [.] makeParamList 0.00% postgres postgres [.] ascii 0.00% postgres postgres [.] text_length 0.00% postgres [kernel.kallsyms] [k] fib_validate_source 0.00% postgres plpgsql.so [.] ReleaseSysCache@plt 0.00% postgres postgres [.] text_position_next 0.00% postgres postgres [.] ResourceOwnerForgetTupleDesc 0.00% postgres plpgsql.so [.] SPI_datumTransfer@plt 0.00% postgres [kernel.kallsyms] [k] update_blocked_averages 0.00% postgres postgres [.] ArrayGetOffset0 0.00% postgres [kernel.kallsyms] [k] update_curr 0.00% postgres [kernel.kallsyms] [k] read_tsc 0.00% postgres postgres [.] AllocSetDelete 0.00% postgres [e1000e] [k] e1000_clean_rx_irq 0.00% postgres postgres [.] pg_wc_isalnum 0.00% postgres postgis-3.so [.] pg_detoast_datum@plt 0.00% postgres postgres [.] MakeTupleTableSlot 0.00% postgres postgres [.] heap_getnextslot 0.00% postgres postgres [.] _bt_readnextpage 0.00% postgres libc-2.28.so [.] __strcmp_avx2 0.00% postgres postgres [.] equal 0.00% postgres postgres [.] pull_varnos_walker 0.00% postgres [iptable_nat] [k] iptable_nat_ipv4_out 0.00% postgres postgis-3.so [.] 0x000000000008db47 0.00% postgres postgres [.] ExecInitExprRec 0.00% postgres postgres [.] deconstruct_array 0.00% postgres postgres [.] tts_minimal_getsomeattrs 0.00% postgres [kernel.kallsyms] [k] _raw_spin_lock_bh 0.00% postgres postgres [.] pq_sendcountedtext 0.00% postgres postgres [.] core_yylex 0.00% postgres postgres [.] list_copy 0.00% postgres [kernel.kallsyms] [k] ip_finish_output2 0.00% postgres postgis-3.so [.] memcpy@plt 0.00% postgres [kernel.kallsyms] [k] copy_user_enhanced_fast_string 0.00% postgres postgres [.] generate_gather_paths 0.00% postgres postgres [.] _bt_freestack 0.00% postgres postgres [.] ExecEvalStepOp.part.4 0.00% postgres [veth] [k] veth_xmit 0.00% postgres libpthread-2.28.so [.] __libc_write 0.00% postgres [kernel.kallsyms] [k] aa_sk_perm 0.00% postgres postgres [.] HeapTupleSatisfiesVisibility 0.00% postgres postgres [.] pg_proc_aclcheck 0.00% postgres postgres [.] estimate_expression_value 0.00% postgres postgres [.] extractRemainingColumns 0.00% postgres postgres [.] ExprEvalPushStep 0.00% postgres postgres [.] expression_tree_walker.part.4 0.00% postgres postgres [.] add_paths_to_joinrel 0.00% postgres postgres [.] exprTypmod 0.00% postgres [kernel.kallsyms] [k] SYSC_recvfrom 0.00% postgres [kernel.kallsyms] [k] nmi_cpu_backtrace 0.00% postgres [kernel.kallsyms] [k] native_sched_clock 0.00% postgres [kernel.kallsyms] [k] intel_bts_enable_local # # (Cannot load tips.txt file, please install perf!) #