spoterianski

-- show running queries (pre 9.2)
SELECT procpid, age(query_start, clock_timestamp()), 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(query_start, clock_timestamp()), usename, query 
FROM pg_stat_activity 
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' 

spoterianski

Keybase proof

I hereby claim:

• I am spoterianski on github.
• I am m0n0 (https://keybase.io/m0n0) on keybase.
• I have a public key ASBFH15VLtcq0ra5YkTQkOXzoBCl2BDKXsm8cnG7YTzsEQo

To claim this, I am signing this object:

spoterianski

'''
Example of Tornado that autoreloads/watches all files in folder 'static'
'''
import tornado.ioloop
import tornado.web
import tornado.autoreload
import os


''' serves index.html'''

spoterianski

# Математика 4 класс
# Генератор примеров для вычитание четырехзначных чисел
import random
res = []
for i in range(20):
    a = random.randint(100, 9999)
    b = random.randint(100, 9999)
    if b > a:
        a, b = b, a
    print(f'{i})\n')

spoterianski

#!/bin/bash
# Description: Split an m4b into its chapters. No recoding is done, just splitting
# Usage: m4b_split.sh $input_file $output_dir/
# Requires: ffmpeg, jq
# Author: Hasan Arous, Sergey Poterianski
# License: MIT


in="$1"
out="$2"

spoterianski

#!/bin/zsh

HOST="remote-hostname"
PORT="22"
TIMEOUT="10"
OBSIDIAN_VAULT="/home/user/Obsidian/Notes"

if ssh -o ConnectTimeout=$TIMEOUT -p $PORT "$HOST" echo "SSH is up"; then
    echo "Host $HOST is available"
else