Kill

Permanently add SSH Key Password to the Keychain ssh-add --apple-use-keychain ~/.ssh/THEPRIVATEKEY Tool for Window Management Install rectangle Install with brew brew install rectangle Useful Shortcuts Move current app to previous or next display Ctrl+Opt+Cmd+LEFT or Ctrl+Opt+Cmd+RIGHT Maximize window Ctrl+Opt+ENTER Beginners List of Shortcuts coming from Linux …​ Finder Show hidden files in Finder: cmd + shift + . Open Finder: Option + Cmd + Space Open Location: Shift + Cmd + G Change to parent dir in Finder: super + UP ...

Show Indizes and their size in a specific schema SELECT tablename, indexname, indexdef, pg_size_pretty(pg_relation_size(schemaname || '.' || indexname)) AS index_size FROM pg_indexes WHERE schemaname = 'SCHEMANAME' ORDER BY pg_relation_size(schemaname || '.' || indexname) DESC; Select statement_timeout settings for all users SELECT r.rolname, (SELECT unnest(s.setconfig) FROM pg_db_role_setting s WHERE s.setrole = r.oid AND s.setconfig::text LIKE '%statement_timeout%' LIMIT 1) AS statement_timeout FROM pg_roles r WHERE r.rolcanlogin ORDER BY r.rolname; Get size of a table SELECT pg_size_pretty(pg_total_relation_size('schemaname.tablename')); ...