This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- show running queries (pre 9.2) | |
SELECT procpid, age(clock_timestamp(), query_start), usename, current_query | |
FROM pg_stat_activity | |
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' | |
ORDER BY query_start desc; | |
-- show running queries (9.2) | |
SELECT pid, age(clock_timestamp(), query_start), usename, query | |
FROM pg_stat_activity | |
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Rootユーザに変更 | |
sudo su - | |
# virtualenvインストール | |
pip install -U virtualenv | |
virtualenv /www/sentry/ | |
source /www/sentry/bin/activate |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/usr/bin/python | |
# strace an existing process tree. `strace -f` only follows newly spawned | |
# processes which is not always what you want. | |
import os | |
import sys | |
import subprocess | |
# /proc/[pid]/task/* == directory of threads including self | |
# /proc/[pid]/task/[pid]/children == child processes |
The following compares the output of several creative hash functions designed for human readability.
sha1's are merely used as arbitrary, longer, distributed input values.
input | 1 word output | 2 word output | 3 word output |
---|
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# generated by Slic3r 1.37.2-prusa3d on Thu Dec 7 09:48:20 2017 | |
# Figured out by trial and error engineer metacollin | |
# Released as public domain. | |
# USE GLUESTICK FOR PRINT BED ADHESION | |
avoid_crossing_perimeters = 0 | |
bed_shape = 0x0,250x0,250x210,0x210 | |
bed_temperature = 110 | |
before_layer_gcode = ;BEFORE_LAYER_CHANGE\n;[layer_z]\n\n | |
bottom_solid_layers = 8 | |
bridge_acceleration = 1000 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import { | |
Inject, | |
Injectable, | |
InjectionToken, | |
Injector, | |
Optional | |
} from '@angular/core'; | |
import { | |
HttpClient, | |
HttpEvent, |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/usr/bin/env python3 | |
# The goal of this is to gradually balance a btrfs filesystem which contains DM-SMR drives. | |
# Such drive are described in detail at https://www.usenix.org/node/188434 | |
# A normal drive should be able to balance a single 1GB chunk in under 30s. | |
# Such a stripe would normally be written directly to the shingled blocks, but in the case | |
# it was cached, it would take roughly 100s to clean. | |
# So our heuristic here is: |