pg_sessions 0.0.2
- This Release
- pg_sessions 0.0.2
- Date
- Status
- Testing
- Latest Stable
- pg_sessions 0.0.5 —
- Other Releases
- Abstract
- Merge Postgresql session/query metrics with linux process table
- Description
- pg_sessions intend to fill the hole in sessions monitoring where you can have the operating system statistics displayed with the sessions currently running
- Released By
- menardorama
- License
- PostgreSQL
- Resources
- Special Files
Extensions
- pg_sessions 0.0.2
- Postgresql and Operating system process table
README
pg_sessions
Postgresql active session history including pid and timestamp
This project is made because of the lack of admin view on Postgresql
What has been done ?
- based on pg_stat_statement
- added the pid and the last run of the query
- implemented the system statistics based on pg_proctab extension
Future addons :
- Wait events on postgresql 9.6 but may be difficult if not catchable using the hooks
- Add a custom background worker to collect and store for historical
- Go to a per pid/queryid/timestamp metric.