Skip to main content

51 docs tagged with "PostgreSQL"

View All Tags

Agent Installation

The following guides you to the basic installation method for using the WhaTap database monitoring service.

Alert Settings

You can set event conditions and receive notifications in various forms.

Application

It guides you how to collect logs from the database and AWS RDS.

Application of the template

Use the pre-configured templates. You can easily perform the initial configuration and change the settings for use.

Configuration

Learn about additional options you can set through the whatap.conf file on the database agent server.

Dashboard

The WhaTap monitoring dashboard provides functions to understand the overall status of a project at a glance.

Database alert

Alerts are sent through event condition settings per metric in the database.

Event History

You can see the history of alerts that occurred through Event History.

Event Setting

Alerts are sent through event condition settings per metric in the database.

Flex Board

Let's learn about the custom integrated dashboard, Flex board.

Instance List

You can see the list of database servers in which the agent has been installed.

Instance Monitoring

In the instance monitoring menu, you can check the information details on key metrics of the PostgreSQL database server in real time.

Live Tail

It guides you to Live Tail of the log monitoring.

Lock tree

You can analyze the lock trend during the day and check deadlocked queries.

Log

It guides you to the main menus of the log monitoring.

Log Search

It guides you to the Log Search menu of Log Monitoring.

Log Trend

It guides you to the Log Trend menu of Log Monitoring.

Management

Let's learn how to update or remove the agent.

Metrics

Let's learn about the metrics menus for Database Monitoring analysis.

Metrics alert

Use the metrics event settings to set specific and complex events.

Metrics widget

Let's learn the metrics widgets placed on the Flex board.

PG SQL Statistics

SQL statistics (execution count, execution time, row count, etc.) provided by PostgreSQL are collected through the pg_state_statements view.

PostgreSQL Monitoring

The WhaTap database monitoring service (DBX) provides the performance monitoring service by collecting data based on queries.

Report

Let's learn about the documents that report the service usage and failure records for individual projects of the PostgreSQL product.

Session History

For a long-running session, you can check how much resource has been used for SQL and analyze the causes.

Slow Query

You can analyze slow queries after identifying active sessions at a specific time point.

SQL statistics

It provides the statistical data for each PostgreSQL DB.

Top Object

It provides information to help users make appropriate tuning and optimize the database.

Troubleshooting

You can check the problems that may occur during database agent installation.

Wait analysis

You can check in which wait event the active session is waiting and which wait events occur frequently.

XOS agent configuration

It provides a configuration method for additional monitoring of the database server resources.