Rob Petti rpetti

DevOps/Build Engineer

rgreenjr / postgres_queries_and_commands.sql

Last active November 17, 2024 09:32

Useful PostgreSQL Queries and Commands

	-- 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%'

rb2k / gist:8372402

Last active April 15, 2024 19:30

A jenkins script to clean up workspaces on slaves

	// Check if a slave has < 10 GB of free space, wipe out workspaces if it does

	import hudson.model.*;
	import hudson.util.*;
	import jenkins.model.*;
	import hudson.FilePath.FileCallable;
	import hudson.slaves.OfflineCause;
	import hudson.node_monitors.*;

	for (node in Jenkins.instance.nodes) {

BenWhitehead / teamcity-agent.service

Created March 7, 2014 23:09

systemd service files for running TeamCity (create in /usr/lib/systemd/system)

	[Unit]
	Description=TeamCity Build Agent
	After=network.target

	[Service]
	Type=forking
	PIDFile=$AGENT_HOME/logs/buildAgent.pid
	ExecStart=/usr/bin/sudo -u teamcity $AGENT_HOME/bin/agent.sh start
	ExecStop=/usr/bin/sudo -u teamcity $AGENT_HOME/bin/agent.sh stop

andyjones / kill-scm-threads.groovy

Created September 23, 2014 12:19

Kills long running SCM polling threads in Jenkins

	Jenkins.instance.getTrigger("SCMTrigger").getRunners().each()
	{
	item ->
	long millis = Calendar.instance.time.time - item.getStartTime()

	if(millis > (1000 * 60 * 60)) // 1000 millis in a second * 60 seconds in a minute * 3 minutes
	{
	Thread.getAllStackTraces().keySet().each()
	{
	tItem ->

bparker98 / o365-notifications.user.js

Last active July 21, 2023 22:00

Office 365 Notifications Tampermonkey Script

	// ==UserScript==
	// @name Office 365 Notifications
	// @namespace http://tampermonkey.net/
	// @version 0.4
	// @description try to take over the world!
	// @author Brandon Parker
	// @match https://outlook.office365.com/*
	// @match https://outlook.office.com/*
	// @iconURL https://r1.res.office365.com/owa/prem/16.1630.12.2223203/resources/images/0/favicon_mail.ico
	// @UpdateURL https://gist.githubusercontent.com/bparker98/fdd125541c8ec9c676ca435e9eb9165a/raw/o365-notifications.user.js

cmer / haproxy.cfg

Last active September 9, 2024 11:24

Simple, no bullshit TCP port forwarding using HAProxy