fredrikroos’s gists

fredrikroos / gist:5309069

Last active December 15, 2015 19:09

	<html>
	<body>
	<iframe src="https://rpm.newrelic.com/public/charts/jiSPQSRxlVR" width="500" height="300" scrolling="no" frameborder="no"></iframe>></iframe>
	<iframe src="https://rpm.newrelic.com/public/charts/lcyDXjnWP1X" width="500" height="300" scrolling="no" frameborder="no"></iframe>
	<iframe src="https://rpm.newrelic.com/public/charts/bj18VWbCe8G" width="500" height="300" scrolling="no" frameborder="no"></iframe>
	</body>
	</html>

fredrikroos / gist:5684193

Created May 31, 2013 10:41

LA Woman

	My woman's in LA
	who wants to grab a beer after work
	My woman just informed me
	that she'll work extra this very evening,
	the universe is telling us something!

	My woman tells me to clean the windows.
	My windows tells me to get a woman.
	That's poo if anyone wonders
	My woman tells me to pick up the kids,

fredrikroos / gist:6295773

Last active December 21, 2015 10:59

largest relations

	SELECT nspname \|\| '.' \|\| relname AS "relation",
	pg_size_pretty(pg_relation_size(C.oid)) AS "size"
	FROM pg_class C
	LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace)
	WHERE nspname = 'hn_prod'
	ORDER BY pg_relation_size(C.oid) DESC
	LIMIT 40;

fredrikroos / gist:6295802

Created August 21, 2013 15:16

Busy indexes

SELECT c.relname AS ctablename, ipg.relname AS indexname, x.indnatts AS number_of_columns, idx_scan, idx_tup_read, idx_tup_fetch,indexrelname FROM pg_index x                                                JOIN pg_class c ON c.oid = x.indrelid                                                                                                                                                                      JOIN pg_class ipg ON ipg.oid = x.indexrelid                                                                                                                                                                JOIN pg_stat_all_indexes psai ON x.indexrelid = psai.indexrelid where c.relname = 'objektareas' order by idx_scan desc;

fredrikroos / gist:7151202

Created October 25, 2013 08:14

doc

!!!

fredrikroos / imagescaling

Created November 13, 2014 23:22

	// dependencies
	var async = require('async');
	var AWS = require('aws-sdk');
	var gm = require('gm')
	.subClass({ imageMagick: true }); // Enable ImageMagick integration.
	var util = require('util');

	// constants
	var MAX_WIDTH = 100;
	var MAX_HEIGHT = 100;

fredrikroos / gist:4cb20f5d238e4dbea0cb

Created December 2, 2014 12:44

	### Keybase proof

	I hereby claim:

	* I am fredrikroos on github.
	* I am fredrikroos (https://keybase.io/fredrikroos) on keybase.
	* I have a public key whose fingerprint is 3156 A6C0 C411 C977 4527 7ABD 0F85 715E B3B1 6460

	To claim this, I am signing this object:

Fredrik Roos fredrikroos