rgreenjr

-- 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%' 

linuxkathirvel

How to assign PrtScr(Print Screen) key to Flameshot screenshot tool in Gnome 3?

1. Goto Keyboard settings and click 'Save a screenshot to Pictures' under 'Screenshots' section.
2. Press 'Backspace' key delete 'PrtScr' key shortcut and press 'Set' button
3. Press '+'(Plust) icon in the 'Custom Shortcuts' in the same window
4. Enter 'Flameshot' in 'Name' field , 'flameshot gui' in 'Command' field, and click 'Set Shortcut' button and press 'PrtScr' button in the keyboard and close the dialog box 5.That's it. If you press 'PrtScr' key, the Flameshot selection area screen will appear.