Skip to content

Instantly share code, notes, and snippets.

View ardentperf's full-sized avatar

Jeremy Schneider ardentperf

View GitHub Profile
@ardentperf
ardentperf / test_random.lua
Created January 19, 2023 06:34
print a clear representation of a sysbench random distribution
function thread_init()
h = sysbench.histogram.new(1000, 1, 100)
end
function event()
h:update(sysbench.rand.default(1, 100))
end
function thread_done()
h:print()
# https://github.com/brendangregg/FlameGraph
#
# skipping directories "test" and "demos"
~/src/FlameGraph$ for F in $(find . -type f -a \! -path ./test\* -a \! -path ./.git\* -a \! -path ./demos\*); do echo $(egrep "(Free Software.*version|CDDL-|Apache)" $F||echo "UNKNOWN") -- $F -- $(git shortlog -s $F|awk '{$1="";print}') ; done | sort
# as published by the Free Software Foundation; either version 2 -- ./difffolded.pl -- Brendan Gregg
# as published by the Free Software Foundation; either version 2 -- ./stackcollapse-bpftrace.pl -- Jose Fernandez Peter Sanford
@ardentperf
ardentperf / psqlrc.sql
Created May 8, 2019 16:47
ardentperf psqlrc
-- Jeremy Schneider's psqlrc http://ardentperf.com
--
-- see also https://www.citusdata.com/blog/2017/07/16/customizing-my-postgres-shell-using-psqlrc/
--
\set QUIET 1
select case when count(*)=0 then 'select ''not-aurora'' as avers'
else 'select aurora_version() as avers'
end as aurora_version_query
from pg_settings where name='rds.extensions' and setting like '%aurora_stat_utils%' \gset