Skip to content

Instantly share code, notes, and snippets.

View orrc's full-sized avatar
🏴󠁧󠁢󠁳󠁣󠁴󠁿

Christopher Orr orrc

🏴󠁧󠁢󠁳󠁣󠁴󠁿
View GitHub Profile
WITH table_scans as (
SELECT relid,
tables.idx_scan + tables.seq_scan as all_scans,
( tables.n_tup_ins + tables.n_tup_upd + tables.n_tup_del ) as writes,
pg_relation_size(relid) as table_size
FROM pg_stat_user_tables as tables
),
all_writes as (
SELECT sum(writes) as total_writes
FROM table_scans
@orrc
orrc / bad-plugins.md
Last active August 29, 2015 14:20
Jenkins plugins without a valid wiki URL
### Keybase proof
I hereby claim:
* I am orrc on github.
* I am orrc (https://keybase.io/orrc) on keybase.
* I have a public key whose fingerprint is E685 820C 2B9C 15B7 12F8 B329 EA22 F28D 8980 6FEB
To claim this, I am signing this object:
{
"canon_url": "https://bitbucket.org",
"commits": [
{
"author": "chris_iosphere",
"branch": "feature/do-something",
"files": [
{
"file": "README.md",
"type": "modified"
@orrc
orrc / golang.json
Created April 27, 2014 10:40
Sample output from the Jenkins backend-crawler/golang.groovy
{
"releases": [
{
"variants": [
{
"url": "https://go.googlecode.com/files/go1.2.1.darwin-amd64-osx10.8.tar.gz",
"osVersion": "osx10.8",
"os": "darwin",
"arch": "amd64"
},
@orrc
orrc / BasicMapActivity.java
Created October 11, 2012 16:08
Swiss Grid map with Nutiteq 2.0 SDK
// Compile against nutiteq-3dlib-preview.jar or drop into the HelloMap3D sample
import javax.microedition.khronos.opengles.GL10;
import android.app.Activity;
import android.os.Bundle;
import android.widget.Toast;
import com.nutiteq.MapView;
import com.nutiteq.components.Bounds;
@orrc
orrc / UsageData.java
Created September 11, 2011 23:10
Jenkins usage data parser
package org.jenkinsci.tools;
import java.io.File;
import java.io.IOException;
import org.codehaus.jackson.JsonFactory;
import org.codehaus.jackson.JsonParseException;
import org.codehaus.jackson.JsonParser;
import org.codehaus.jackson.JsonToken;