zwolf

# ssh onto the redis node in question and run these cmds

# congestion:* keys are for https://github.com/parrish/Sidekiq-Congestion
# uniquejobs:* https://github.com/mhenrixon/sidekiq-unique-jobs

# get a count of the locks
redis-cli -n 0 --scan --pattern 'congestion:*' | wc -l
redis-cli -n 0 --scan --pattern 'uniquejobs:*' | wc -l

# clear them for both key namespaces

zwolf

# Manual csv classifications dump
# ensure you have a manual secondary database connection specified in config/database.yml
#
# run via rails runner from the panoptes cmd line via 
# rails r project_classifications_csv_dump_export.rb

require 'csv'

PROJECT_ID = 1

zwolf

SELECT bl.pid                 AS blocked_pid,
       a.usename              AS blocked_user,
       ka.query               AS current_statement_in_blocking_process,
       now() - ka.query_start AS blocking_duration,
       kl.pid                 AS blocking_pid,
       ka.usename             AS blocking_user,
       a.query                AS blocked_statement,
       now() - a.query_start  AS blocked_duration
FROM  pg_catalog.pg_locks         bl
 JOIN pg_catalog.pg_stat_activity a  ON a.pid = bl.pid

zwolf

SELECT 
    relid::regclass AS table, 
    indexrelid::regclass AS index, 
    pg_size_pretty(pg_relation_size(indexrelid::regclass)) AS index_size, 
    idx_tup_read, 
    idx_tup_fetch, 
    idx_scan
FROM 
    pg_stat_user_indexes 
    JOIN pg_index USING (indexrelid) 

zwolf

#!/bin/sh
#
# /etc/init.d/kibana4 -- startup script for kibana4
# [email protected] 2015-02-20; used elasticsearch init script as template
# https://github.com/akabdog/scripts/edit/master/kibana4_init
#
### BEGIN INIT INFO
# Provides:          kibana4
# Required-Start:    $network $remote_fs $named
# Required-Stop:     $network $remote_fs $named