pgSentinel
@pg_sentinel
Thanks for the mention Postgres Weekly 🐘 !
Easy way to test the PostgreSQL pgsentinel extension providing Active Session History feature #Postgres #PostgreSQL
Example of active session history usage in PostgreSQL : drill down in case of blocking activity #Postgres #PostgreSQL Postgres Weekly 🐘
Sharing some sql scripts to retrieve information from the pg_active_session_history view: github.com/pgsentinel/pg_… PostgreSQL recursive query + window function + pg_active_session_history view provide valuable insights #PostgreSQL #postgres
Sharing sql scripts to retrieve information from the pg_active_session_history view: github.com/pgsentinel/pg_… & a post as example: bdrouvot.wordpress.com/2018/09/01/act… PostgreSQL recursive query + window function + pg_active_session_history provide valuable insights #PostgreSQL #postgres
Some examples of pg_active_session_history insights in PostgreSQL (avg number of sessions on cpu per second, top 10 application, top 10 queryid on cpu, top 10 queryid waiting on IO and so on): github.com/pgsentinel/pg_… #postgres #postgresql
You can now beta test the pgsentinel extension (providing active session history feature): github.com/pgsentinel/pgs… on PostgreSQL 9.6 or higher (was >= 10 previously) #postgres #postgresql
Jan Karremans hydrobiont @postgresql EDB Data Egret | PostgreSQL support And this demonstrates why pg_active_session_history is a must to link together many of those components beyond their isolated statistics /cc pgSentinel github.com/pgsentinel/pgs…
Another great study where pgSentinel could be used. Thanks Franck Pachot for sharing
Check out this Meetup: une journée avec Jan Karremans (EDB) et Bertrand Drouvot (Digora) meetup.com/parisoracle/ev… #Meetup #Colombes via Meetup Travel and stay booked!! See you there!! Yves Colin Bertrand Drouvot
Starting on my way to #Paris!! Meeting Yves Colin and Bertrand Drouvot for the Paris #Oracle Meetup on EDB! meetup.com/parisoracle/ev… Be there!! I will be...
Indeed and that’s why the pgSentinel extension rely on it to provide active session history linked to queryid
Looks like I'll demo some @kevinclosson #pgio and Bertrand Drouvot #pgSentinel at #PostgresLondon 2019 🇬🇧 🐘 - the tools and methods for #PostgreSQL that come from the Oracle DBA experience... postgreslondon.org/#schedule
Coming soon in pgSentinel: in memory sampling of pg_stat_statements (only for queryid currently linked to an active session). Then use window functions to compute the delta (see pic as example) of the queryid stats.
