Skip to content

Instantly share code, notes, and snippets.

View janatjak's full-sized avatar

Jakub Janata janatjak

View GitHub Profile
@DavidPesticcio
DavidPesticcio / docker-registry-delete-image.txt
Created June 28, 2018 20:47
remove images from docker registry v2.4
How to delete an image tag/image from docker registry v2.4
1) Re/Start registry with delete option enabled
Edit the config.yml
storage:
delete:
enabled: true
@rgreenjr
rgreenjr / postgres_queries_and_commands.sql
Last active May 7, 2025 09:27
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%'