Skip to main content
Sumo Logic

Install the Aurora PostgreSQL ULM App and view the Dashboards

This page provides instructions for installing the Sumo App for Aurora PostgreSQL ULM, and descriptions of the app dashboards.

This page provides instructions for installing the Sumo App for Aurora PostgreSQL ULM, as well as the descriptions of each of the app dashboards. Click a link to jump to a section:

Install the app

Now that you have set up log and metric collection for Amazon Aurora PostgreSQL, you can install the Sumo Logic App for Aurora PostgreSQL ULM, and use its pre-configured searches and dashboards.

To  install the app, do the following:

Locate and install the app you need from the App Catalog. If you want to see a preview of the dashboards included with the app before installing, click Preview Dashboards.

  1. From the App Catalog, search for and select the app. 
  2. To install the app, click Add to Library and complete the following fields.
    1. App Name. You can retain the existing name, or enter a name of your choice for the app.

    2. Data Source. Select either of these options for the data source.

      • Choose Source Category, and select a source category from the list.

      • Choose Enter a Custom Data Filter, and enter a custom source category beginning with an underscore. Example: (_sourceCategory=MyCategory).

    3. Advanced. Select the Location in Library (the default is the Personal folder in the library), or click New Folder to add a new folder.
    4. Click Add to Library.

Once an app is installed, it will appear in your Personal folder, or other folder that you specified. From here, you can share it with your organization. See Welcome to the New Library for information on working with the library in the new UI.

Panels will start to fill automatically. It's important to note that each panel slowly fills with data matching the time range query and received since the panel was created. Results won't immediately be available, but with a bit of time, you'll see full graphs and maps. 

Dashboard filters

Each dashboard has a set of filters that you can apply to the entire dashboard, as shown in the following example. Click the funnel icon in the top dashboard menu bar to display a scrollable list of filters that narrow search results across the entire dashboard.

AuroraPostreSQL_Dashboard_Filters_icon.png

Each panel has a set of filters that are applied to the results for that panel only, as shown in the following example. Click the funnel icon in the top panel menu bar to display a list of panel-specific filters.

AuroraPostgreSQL_PanelFilter_icon.png

CloudTrail Event - Overview Dashboard

Aurora PostgreSQL ULM CloudTrail Event - Overview Dashboard allows you to view details for event logs, including geographical locations, trends, successful and failed events, user activity, and error codes. 

Use this dashboard to keep get an at-a-glance overview of following:

  • Locations of successful and failed activities to check if they're within compliance.
  • Event trends to identify if there is something different compared to typical patterns.
  • Users and the type of authentication method used.
  • Failed activities so you can take corrective actions.

AuroraPostgreSQLULM_CloudTrailEvent_Overview.png

CloudTrail Event - Details Dashboard

Aurora PostgreSQL ULM CloudTrail Event - Details Dashboard allows you to view details for events, including creating, modifying, and deleting database clusters and database instances. Use this dashboard to:

Use this dashboard to keep track of your Aurora PostgreSQL Clusters and Instances. This dashboard provides details about various cluster and instance related activities, such as creation, modification, deletion and reboot of instances. The improper configuration of clusters and instances may have adverse impact on performance. This dashboard will help identify problems with details about the Aurora PostgreSQL specific events that provide insights into how to solve a particular problem.

AuroraPostgreSQLULM_CloudTrailEvent_Details.png

Metric - Overview Dashboard

Aurora PostgreSQL ULM Metric - Overview Dashboard allows you to view a high-level analysis of Aurora PostgreSQL database CPU utilization, connections, IOPS, replica lag, and memory usage.

Use this dashboard to:

  • Monitor the number of connections. 
  • Monitor CPU utilization.
  • Monitor Volume Read and Write IOPS to ensure the database is optimally interacting with disk.
  • Monitor replica lags and available free memory to ensure support of heavy read loads with good performance.

AuroraPostgreSQLULM_Metric_Overview.pngMetric - Generic Dashboard

Aurora PostgreSQL ULM Metric - Generic Dashboard allows you to view analysis of replica lag, network throughput, buffer cache hit ratio, deadlocks, and free storage capacity.

Use this dashboard to:

  • Monitor replica lags. Aurora supports read replicas with extremely low replica lags to support applications with heavy read activity loads.
  • Monitor network traffic load and usage. RDS supports monitoring network throughput.
  • Monitor cache hit ratio to identify free memory from query performance perspective.
  • Identify deadlocks, if any, and identify free local storage.

AuroraPostgreSQLULM_Metric_Generic.png

Metric - Latency, Throughput, and IOPS Monitoring Dashboard

Aurora PostgreSQL ULM Metric - Latency, Throughput, and IOPS Monitoring Dashboard allows you to view granular details of database latency, throughput, IOPS and disk queue depth. It is important to monitor the performance of database queries. Latency and throughput are the key performance metrics.

Use this dashboard to:

  • Monitor read, write latency and throughput.
  • Monitor Read and Write IOPS to ensure your database is interacting with disk optimally.
  • Monitor database wait times for disk access with the Disk Queue Depth panel.

AuroraPostgreSQLULM_Metric_LTIOPSMonitoring.png

Metric - Resource Utilization Monitoring Dashboard

Aurora PostgreSQL ULM Metric - Resource Utilization Monitoring Dashboard allows you to view analysis of resource utilization, including volume usage, swap usage, transaction log disk usage, uptime, transaction IDs, and replica lag.

Use this dashboard to:

  • Monitor disk usage for transaction logs and swap usage for a database instance.
  • Monitor Maximum transaction IDs used to avoid the database going into read-only mode to avoid transaction ID wraparound.
  • Monitor replica lag when replicating updates from the primary RDS PostgreSQL instance to other cluster nodes.
  • Monitor engine up time.

AuroraPostgreSQL_Metric_ResourceUtilizationMonitoring.png