When track_activities is set to on, PostgreSQL starts collecting data for all executed queries. Users with appropriate privileges can monitor user activity through this feature using the system view pg_stat_activities.

One of the PostgreSQL system views, pg_stat_activity, keeps a list of all currently running PostgreSQL background processes. This information includes which queries are running, connected users and when they connected, and the start time of running transactions and queries.