| #!/usr/bin/php5 | |
| <?php | |
| /** | |
| * Simple script to weight PostgreSQL query planner costs (`analyze` times included!) in explain log file. | |
| * Handy for analyzing large query plans with a lot of subqueries. | |
| * Example output (this scan took ~21% of total query run time, worth optimizing): | |
| -> Seq Scan on public.tablename (cost=0.00..3919.54 rows=1 width=0) (actual time=64.232..86.516 rows=1 loops=1) | |
| Cost: 0.00..22.35% | |
| Time: 15.53..20.92% | |
| Output: tablename.id, tablename.name, tablename.another_id |
You might want to read this to get an introduction to armel vs armhf.
If the below is too much, you can try Ubuntu-ARMv7-Qemu but note it contains non-free blobs.
First, cross-compile user programs with GCC-ARM toolchain. Then install qemu-arm-static so that you can run ARM executables directly on linux
The prep-script.sh will setup the latest Node and install the latest perf version on your Linux box.
When you want to generate the flame graph, run the following (folder locations taken from install script):
sudo sysctl kernel.kptr_restrict=0
# May also have to do the following:
# (additional reading http://unix.stackexchange.com/questions/14227/do-i-need-root-admin-permissions-to-run-userspace-perf-tool-perf-events-ar )
sudo sysctl kernel.perf_event_paranoid=0
| (defun color-cie-de2000 (color1 color2 &optional kL kC kH) | |
| "Return the CIEDE2000 color distance between COLOR1 and COLOR2. | |
| Both COLOR1 and COLOR2 should be in CIE L*a*b* format, as | |
| returned by `color-srgb-to-lab' or `color-xyz-to-lab'." | |
| (pcase-let* | |
| ((`(,L₁ ,a₁ ,b₁) color1) | |
| (`(,L₂ ,a₂ ,b₂) color2) | |
| (kL (or kL 1)) | |
| (kC (or kC 1)) | |
| (kH (or kH 1)) |
| # alias to edit commit messages without using rebase interactive | |
| # example: git reword commithash message | |
| reword = "!f() {\n GIT_SEQUENCE_EDITOR=\"sed -i 1s/^pick/reword/\" GIT_EDITOR=\"printf \\\"%s\\n\\\" \\\"$2\\\" >\" git rebase -i \"$1^\";\n git push -f;\n}; f" | |
| # aliases to change a git repo from private to public, and public to private using gh-cli | |
| alias gitpublic="gh repo edit --accept-visibility-change-consequences --visibility public" | |
| alias gitprivate="gh repo edit --accept-visibility-change-consequences --visibility private" | |
| # delete all your repos using gh-cli (please do not run this unless you want to delete all your repos) | |
| gh repo list --limit 300 --json url -q '.[].url' | xargs -n1 gh repo delete --yes |
Hi there!
The docker cheat sheet has moved to a Github project under https://github.com/wsargent/docker-cheat-sheet.
Please click on the link above to go to the cheat sheet.
| # Basically the nginx configuration I use at konklone.com. | |
| # I check it using https://www.ssllabs.com/ssltest/analyze.html?d=konklone.com | |
| # | |
| # To provide feedback, please tweet at @konklone or email [email protected]. | |
| # Comments on gists don't notify the author. | |
| # | |
| # Thanks to WubTheCaptain (https://wubthecaptain.eu) for his help and ciphersuites. | |
| # Thanks to Ilya Grigorik (https://www.igvita.com) for constant inspiration. | |
| server { |
| site :opscode | |
| cookbook 'apt' | |
| cookbook 'statsd', git: 'https://github.com/librato/statsd-cookbook.git' | |
| cookbook 'graphite', git: 'https://github.com/hw-cookbooks/graphite.git' |
