PostgreSQL is one of the many database technologies that SelectStar can monitor. Combine your database monitoring, from MySQL to MongoDB to PostgreSQL, in a single platform to simplify heterogeneous environment monitoring. Read on to see what is possible with PostgreSQL monitoring in SelectStar.
Health, Compliance, & Configuration
One of the first thing you’ll notice when monitoring PostgreSQL with SelectStar is the Health, Compliance, and Configuration section at the top of the PostgreSQL resource page. This sections provides important information about your PostgreSQL Database without digging around.
Health is directly tied to Alerts (found in the right sidebar), which generally relate to performance problems. For example, you could set a threshold on the number of active sessions. If this threshold is exceeded, an Alert would appear in the sidebar and the PostgreSQL Health would be degraded.
Compliance is tied to Recommendations (also found in the right sidebar). Recommendations are based on PostgreSQL configuration best-practices, which you can customize to meet your specific configuration requirements. If a PostgreSQL database configuration doesn’t match the recommended values, a Recommendation will appear in the right sidebar and the Compliance score will decrease.
Finally, key PostgreSQL information is available in the Configuration Details section such as version, underlying infrastructure, and collector status.
Deep Dive with Analysis
The next section, Analysis, displays key performance and configuration metrics for PostgreSQL. This includes Sessions, Queries, Reads, Writes, and Instance Configuration. Additionally, if you are monitoring the underlying infrastructure with SelectStar, it will appear at the bottom of this section.
Each of the key performance and configuration sections is clickable and gives you the ability to see more historical and contextual information. For example, opening Queries gives you a closer look at the specific queries being executed against your PostgreSQL database. You can also click on a specific query to view more detailed information about it. You can see an example in Figure 3 below where the query execution history is graphed and query text, number of query calls, total time spent on the query, and block reads/writes are available.
The third section for PostgreSQL is title “Advanced” and displays metric categories such as Disk, Engine, Queries, Rows, and Miscellaneous. Each of these categories contain many more metrics that are accessible by clicking on the category.
Clicking on a category, Rows for example, gives you access to metrics like Rows Deleted, Rows Deleted Rate, Rows Fetched, Rows Fetched Rate, Rows Inserts, and many more. Clicking on any of the metrics in category page will give you a customizable historical chart.
The final section displays relationships, both within the PostgreSQL stack (such as database to instance) and to infrastructure resources. Each resource is clickable, giving you the ability to quickly navigate up and down the database and infrastructure stack. Note that compliance scores are also available at each layer, giving an overview of configuration compliance for the entire stack.
You can get more information about the PostgreSQL Instance (10.202.12.20:5432 in Figure 6) by clicking on the resource. You’ll see a page like the PostgreSQL database page, but with specifics about the Instance such as configuration, checkpoints, buffers, and other instance-specific information.
Links are provided at the top of the PostgreSQL Instance page (as seen in Figure 7) for ease of navigation back to your PostgreSQL Database.
To learn more about SelectStar or request a free trial, visit selectstar.staging.wpengine.com.