PostgreSQL active session history - new pgsentinel extension
The pgsentinel company has released the pgsentinel extension of the same name (github repository), which adds the pg_active_session_history view to PostgreSQL - the history of active sessions (similar to Oracle's v$active_session_history). Essentially, these are simply every second snapshots from pg_stat_activity, but there are important points: All accumulated information is stored only in RAM, and the amount of memory consumed is regulated by the number of last stored records. The queryid field is added - [...]