pg_stat_monitor: A cool extension for better monitoring using PMM - Percona Live Online 2020 скачать в хорошем качестве

pg_stat_monitor: A cool extension for better monitoring using PMM - Percona Live Online 2020

#pg_stat_monitor is a statistics collection tool authored by Percona and contributed to the community. It is based on pg_stat_statements, an existing #PostgreSQL contrib module. The major shortcoming in pg_stat_statements is that it accumulates all the queries and their statistics but does not provide aggregated statistics nor histogram information. In this case, a user needs to calculate the aggregate, which is quite expensive. pg_stat_monitor provides the pre-calculated aggregates. Comment 💬, Share 🔗, Like 👍, and Subscribe ✅ to our channel + Turn on the 🔔 📺 Subscribe To Our Channel + Turn on the 🔔 and Get More videos about #OpenSource #Databases, and many other things. https://percona.tv/subscribe pg_stat_monitor collects and aggregates data on a bucket basis. The size and number of buckets is configured using #GUC (Grand Unified Configuration). The buckets are used to collect the statistics and aggregate them into a bucket. This talk covers the usage of pg_stat_monitor and how it is an improvement on pg_stat_statements. pg_stat_monitor is added to Percona Monitoring and Management to collect query metrics. This provides users the ability to see examples instead of fingerprints. pg_stat_monitor provides more accurate data because of bucket based logic. Also, collecting data from pg_stat_monitor provides better performance than pg_stat_statements. You can find more information about #PostgreSQL #Databases and Percona Database Events in these links 👇👇👇 Postgresql Support ⏩ https://per.co.na/postgresql-support Postgresql info ⏩ https://per.co.na/postgresql-info Postgresql events ⏩ https://per.co.na/lGkGc9 Percona Private Cloud ⏩ https://per.co.na/pl2020 Percona Distribution for PostgreSQL ⏩ https://per.co.na/postgresql Monitor your PostgreSQL For Free ⏩ https://percona.tv/pmm-yt Connect With us on our Social Networks 👇👇👇 Follow Percona on Twitter: https://per.co.na/twitter Follow Percona on Facebook: https://per.co.na/facebook Follow Percona on Instagram: https://per.co.na/instagram Follow Percona on LinkedIn: https://per.co.na/linkedin