Let’s see how to capture pg_stat_statements from all the nodes in a persistent table to use for analysis. The data can then be stored in YugabyteDB tables, accessible from any node unless purged. Want to see how it can be done?
It’s good to keep a record about the growing size of databases and tables to make reporting easier and to quickly determine why there was a sudden drop or increase in table size or infer table create and drop dates. YugabyteDB Anywhere provides an API to capture table-level size metrics on a daily basis in a permanent table. This blog will provide the instructions to capture those table size metrics.
Alerts can be created from the YugabyteDB Anywhere UI or by using APIs designed specifically for the product, which can be extremely helpful if you need to create a new universe or migrate a platform. This blog will walk you through how to create these alert configurations using APIs in YugabyteDB Anywhere product.