I turned the psql commands I keep forgetting into buttons (opens in new tab)
You know the command exists. You've run it a dozen times. But every single time you need to see what's actually running on your database, you end up typing some variant of: SELECT pid, state, query, wait_event_type FROM pg_stat_activity WHERE state != 'idle' AND pid != pg_backend_pid(); …and then googling pg_stat_activity columns halfway through because you forgot whether it's wait_event or wait_event_type. I got tired of that. So I built cli2ui — a small web UI that turns the database CLI co...
Read the original article