Skip to content

Instantly share code, notes, and snippets.

View akaashanky's full-sized avatar

Akaash Patnaik akaashanky

View GitHub Profile
Verifying that +akaash is my openname (Bitcoin username). https://onename.com/akaash
{
"basics": {
"name": "Akaash Patnaik",
"label": "Software Engineer",
"picture": "https://pbs.twimg.com/profile_images/999675836587425793/UWhRRxNu_400x400.jpg",
"email": "akaashanky@gmail.com",
"phone": "9886-324-974",
"website": "https://akaash.xyz",
"summary": "Full-stack engineer with an interest in iterative, customer-driven, product development. Most of my work has been in the B2B Software domain where I have built web, mobile and desktop applications, and have experience leading agile software development teams.",
"location": {
@akaashanky
akaashanky / pg_admin_queries.sql
Last active December 9, 2021 05:11
A few useful queries for Postgres admins
-- See how long the currrently active txns have been running for
SELECT now()-xact_start, * FROM pg_stat_activity;
-- pg_stat_activity is a very useful table in general
-- eg. you can also see a summary of how many txns are currently running and
-- in what state
SELECT state, count(*) FROM pg_stat_activity GROUP BY state;
-- terminate process
SELECT pg_terminate_backend(pid);