There may come a time where you want more insight into your database; to understand who is doing what...and when.
You might already be familiar with some of Postgres' system functions and views and, in this short guide, we will take a look at the catchy Cumulative Statistics System
, providing insights into replication slots, connections, the WAL and more (that you can read about here)
All connections can be viewed using pg_stat_activity
and you can simply start with: