Skip to content

Instantly share code, notes, and snippets.

Avatar
🔐
...

Aaron Zauner azet

🔐
...
View GitHub Profile
@azet
azet / psql_internals_cheatsheet.sql
Last active Sep 10, 2020
PostgreSQL internals SQL collection
View psql_internals_cheatsheet.sql
# long running queries:
SELECT
pid,
now() - pg_stat_activity.query_start AS duration,
query,
state
FROM pg_stat_activity
WHERE (now() - pg_stat_activity.query_start) > interval '5 minutes';
## active queries and killing them:
@azet
azet / numastat_dumb
Created May 23, 2019
numastat replacement - dumbed down (doesn't seem to be packaged in RHEL7)
View numastat_dumb
watch -n1 --differences=cumulative cat /sys/devices/system/node/node*/numastat
@azet
azet / slabinfo
Last active May 22, 2019
human readable SLABInfo
View slabinfo
awk '{printf "%5d MB %s\n", $3*$4/(1024*1024), $1}' < /proc/slabinfo | sort -nr | head -25
@azet
azet / chk_pgsql
Last active Mar 25, 2019
keepalived 'track_script' for PostgreSQL 'bgw_replstatus' Plugin
View chk_pgsql
#!/usr/bin/env python
#
# keepalived 'track_script' for PostgreSQL 'bgw_replstatus' Plugin
#
# Author: Aaron Zauner <azet@azet.org>
# License: CC0 1.0 Public Domain (https://creativecommons.org/publicdomain/zero/1.0/)
#
import socket
s = socket.socket(socket.AF_INET, socket.SOCK_STREAM)
@azet
azet / QSickChill.sh
Last active Feb 8, 2019
QSickChill git without https (tlsv1 unsupported by GitHub, https checkout doesn't work on old QNAP Appliances) - howto provided in the comment section
View QSickChill.sh
#! /bin/sh
QPKG_NAME=QSickChill
QPKG_DIR=$(/sbin/getcfg $QPKG_NAME Install_Path -f /etc/config/qpkg.conf)
PID_FILE="$QPKG_DIR/config/sickchill.pid"
DAEMON_OPTS="SickBeard.py --datadir $QPKG_DIR/config --daemon --pidfile $PID_FILE --port 7073"
# Determin Arch
ver="none"
@azet
azet / opkg-upgrade-all-installed.sh
Created Dec 15, 2018
[OpenWRT] opkg upgrade all installed packages (alias)
View opkg-upgrade-all-installed.sh
alias 'opkg-upgrade'='for x in $(opkg list-upgradable | awk "{print $1}"); do opkg upgrade $x ; done'
View darkmatter.txt
Date: Tue, 5 Apr 2016 16:11:42 +0200
From: Aaron Zauner <azet@azet.org>
To: redacted <redacted@arm.co.uk>
Subject: Re: LinkedIn
Message-ID: <20160405160645.acd82bb63a@64bc86c3c218530>
References: <A3BC8318FB5EB6449FE735A962284AC30423B30C4DBB@V-ARM-MAIL1.arm1.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="k+w/mQv8wyuph6w0"
Content-Disposition: inline
In-Reply-To: <A3BC8318FB5EB6449FE735A962284AC30423B30C4DBB@V-ARM-MAIL1.arm1.com>
@azet
azet / cros_crouton-chroots-azet
Last active Nov 1, 2018
standard crouton/chroot setup on my chromebook pixel (2015)
View cros_crouton-chroots-azet
#!/usr/bin/env bash
set -e -o pipefail
# if you just want/need to update run this script with (.... -u)
#[[ -z ${1} ]] && 1=""
[[ ${USER} == "chronos" ]] || exit 1
cd ~/Downloads
curl -O https://raw.githubusercontent.com/dnschneid/crouton/master/installer/crouton
@azet
azet / tattoo.tex
Last active Aug 18, 2017
LaTeX source for my "Fermat's little theorem"-Tattoo (yes, it ain't generalized - on purpose)
View tattoo.tex
%% PoC* by: Karo Kawalle
%% PoC* URL: https://twitter.com/a_z_e_t/status/898274928515874816
%% Author: Aaron Zauner <azet@azet.org> [Theorem: Pierre de Fermat]
%% Date: 17.08.2017 [18.10.1640]
%% License: CC0 1.0 Universal [Public Domain Dedication]
%% Depends: `texlive-full latexmk` [on deb/apt based distros]
%% Build: `latexmk -pdf tattoo.tex`
%% * PoC = "Proof of Concept" (abbreviation) [i.e. implementation]
\documentclass[a4paper]{letter}
\usepackage{quattrocento, microtype, mathtools}
View random_part.c
static void fast_mix(struct fast_pool *f)
{
__u32 a = f->pool[0], b = f->pool[1];
__u32 c = f->pool[2], d = f->pool[3];
a += b; c += d;
b = rol32(b, 6); d = rol32(d, 27);
d ^= a; b ^= c;
a += b; c += d;
You can’t perform that action at this time.