PostgreSQL stores the information about, among others, the running tasks in the pg_stat_activity table: postgres=# \x on Expanded display is on. postgres=# select datid, datname, pid, usename, ap...
If you want to, click on the banner ☝️