Active session history in PostgreSQL — a new pgsentinel extension
The company pgsentinel has released its namesake extension pgsentinel (GitHub repository), which adds the pg_active_session_history view to PostgreSQL — a history of active sessions (similar to Oracle's v$active_session_history). Essentially, this is simply snapshots from pg_stat_activity taken every second, but there are important points: All accumulated information is stored only in memory, and the amount of memory consumed is regulated by the number of recent records stored. A queryid field is added — […]
