Skip to content

Instantly share code, notes, and snippets.

herokuconnect-prod::DATABASE=> select pid,query from pg_stat_activity where query like 'SELECT COUNT(*) AS "__count" FROM "mirror_transitionhistory" WHERE "mirror_transitionhistory".%' order by query;
pid | query
-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------
31248 | SELECT COUNT(*) AS "__count" FROM "mirror_transitionhistory" WHERE "mirror_transitionhistory"."timestamp" > '2016-07-05T08:56:29.963402+00:00'::timestamptz
31203 | SELECT COUNT(*) AS "__count" FROM "mirror_transitionhistory" WHERE "mirror_transitionhistory"."timestamp" > '2016-07-05T08:57:01.023705+00:00'::timestamptz
31261 | SELECT COUNT(*) AS "__count" FROM "mirror_transitionhistory" WHERE "mirror_transitionhistory"."timestamp" > '2016-07-05T08:57:30.059660+00:00'::timestamptz
31299 | SELECT COUNT(*) AS "__count" FROM "mirror_transitionhistory" WH
@sibson
sibson / after
Last active November 4, 2015 04:09
> h pg:diagnose -a campgrounddemo
Report 1544d87c-b8ea-445d-976c-81d0a8279c0a for campgrounddemo::DATABASE_URL
available for one month after creation on 2015-11-03 23:52:22.85383+00
RED: Hit Rate
Name Ratio
----------------------------------- ------------------
overall index hit rate 0.8686475184695037
overall cache hit rate 0.7648839967012158
campgrounddemo._trigger_log 0.9835142910600523
@sibson
sibson / bs2to3.sh
Last active August 29, 2015 13:56
Find classes that changed between Bootstrap 2 and 3
#!/bin/sh
searchpath='.'
if [ $# -gt 0 ]; then
searchpath=$1
shift 1
fi
searchterm="-e container-fluid -e row-fluid -e span* -e offset* -e brand* -e navbar -e nav -e hero-unit -e icon* -e btn -e btb-mini -e btn-small -e btn-large -e visible-phone -e visible-tablet -e visible-desktop -e hidden-phone -e hidden-tablet -e hidden-desktop -e input-prepend -e input-append -e add-on -e btn-navbar -e thumbnail"
@sibson
sibson / test_circusctl.py
Created July 31, 2012 04:58
circusctl add --start testcase
import subprocess
import sys
import time
from circus.tests.support import TestCircus
class TestCommandline(TestCircus):
def setUp(self):
@sibson
sibson / fix.patch
Created November 9, 2011 20:34
svn project within project fails
diff --git a/zest/releaser/svn.py b/zest/releaser/svn.py
index 45c10ad..44696ed 100644
--- a/zest/releaser/svn.py
+++ b/zest/releaser/svn.py
@@ -28,7 +28,7 @@ class Subversion(BaseVersionControl):
# Note: slashes are used to prevent problems with 'tha.tagfinder'-like
# project names...
for remove in ['/trunk', '/tags', '/branches', '/tag', '/branch']:
- base = base.split(remove)[0]
+ base = base.rsplit(remove, 1)[0]