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();

Enter fullscreen mode