Skip to content

Instantly share code, notes, and snippets.

View k4m4r82's full-sized avatar
🏠
Working from home

Kamarudin k4m4r82

🏠
Working from home
View GitHub Profile
@k4m4r82
k4m4r82 / postgres_queries_and_commands.sql
Created March 11, 2020 03: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%'
@k4m4r82
k4m4r82 / API.md
Created January 31, 2016 06:45 — forked from iros/API.md
Documenting your REST API

Title

<Additional information about your API call. Try to use verbs that match both request type (fetching vs modifying) and plurality (one vs multiple).>

  • URL

    <The URL Structure (path only, no root url)>

  • Method: