PostgreSQL's pg_stat_activity system view keeps track of all running PostgreSQL backends. This includes information such as the query that is being currently executed, or the last query that was executed by each backend; who is connected; when the connection, the transaction, and/or the query were started; and so on.