PostgreSQL Deep Dive with SelectStar

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.

Figure 1: Top section of a PostgreSQL database.

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.

Figure 2: The Analysis section of a PostgreSQL database. Underlying infrastructure KPI’s would appear just below “Instance Configuration”.

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.

Figure 3: Sample query details page for a PostgreSQL query.

Advanced

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.

Figure 4: The Advanced section for PostgreSQL includes metric categories such as Disk, Engine, Queries, Rows, and more.

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.

Figure 5: Rows Fetched Rate chart, set to display the rate over the past week.

Relationships

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.

Figure 6: Sample Relationships section for a PostgreSQL database.

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.

Figure 7: A PostgreSQL Instance page.

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.io.

LET'S GET STARTED!

Try SelectStar for 14 days. No credit card required.

TRY IT NOW!