Skip to content

Instantly share code, notes, and snippets.

View tallica's full-sized avatar

Michał Lipski tallica

  • Brandwatch
  • Poland
View GitHub Profile
@tallica
tallica / gtkrc
Last active September 5, 2022 06:22
gtk2 dark theme
gtk-color-scheme = "base_color:#4F524F\nfg_color:#eeeeec\ntooltip_fg_color:#eeeeee\nselected_bg_color:#3465a4\nselected_fg_color:#eeeeec\ntext_color:#EEEEEC\nbg_color:#363B3B\ntooltip_bg_color:#000000"
gtk-auto-mnemonics = 1
style "default" {
xthickness = 1
ythickness = 1
#######################
# Style Properties
@rgreenjr
rgreenjr / postgres_queries_and_commands.sql
Last active July 18, 2024 22:25
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%'