Skip to content

Instantly share code, notes, and snippets.

View ikenfin's full-sized avatar

Tominov Sergey ikenfin

20 followers · 21 following
View GitHub Profile
@ikenfin
ikenfin / postgres_queries_and_commands.sql
Created April 1, 2021 07:22 — forked from rgreenjr/postgres_queries_and_commands.sql
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%'
@ikenfin
ikenfin / jwtRS256.sh
Created January 24, 2019 20:18 — forked from ygotthilf/jwtRS256.sh
How to generate JWT RS256 key
ssh-keygen -t rsa -b 4096 -m PEM -f jwtRS256.key
# Don't add passphrase
openssl rsa -in jwtRS256.key -pubout -outform PEM -out jwtRS256.key.pub
cat jwtRS256.key
cat jwtRS256.key.pub
@ikenfin
ikenfin / GitCommitEmoji.md
Created January 25, 2018 23:32 — forked from parmentf/GitCommitEmoji.md
Git Commit message Emoji