Postgres Table pg_stat_activity Table Fields Explained
The pg_stat_activity table will show you what activity is currently happening on your PostgreSQL database server. The information will detail the database the activity is occuring on, the username initiating the activity, the length of time the acitivy has been occuring for, and much more. Below is example output from running a SELECT query against…