Monitoring and logs in Yandex MPP Analytics for PostgreSQL

What metrics and processes can be monitored?What metrics and processes can be monitored?

For all DBMS types, you can monitor:

• CPU, memory, network, and disk utilization, in absolute terms.
• Memory, network, and disk utilization as a percentage of the set limits for the cluster’s host class.
• Total cluster data size and available storage space remaining.

For DB hosts, you can monitor metrics specific to their DBMS type. For example, for Greenplum®, you can track:

• Average query execution time.
• Number of queries per second.
• Number of errors in logs.

You can monitor metrics with a minimum granularity of five seconds.

For more information, see Monitoring the cluster and host state.

Which charts reflect the state of hybrid storage?Which charts reflect the state of hybrid storage?

On the Hybrid Storage graph, you can track the number of files in cold storage and their total size. The number and total size of files may decrease over time due to the hybrid storage cleanup procedure. For more information, see Hybrid storage in Yandex MPP Analytics for PostgreSQL

What is the retention period for logs?What is the retention period for logs?

Cluster logs are stored for 45 days.

Greenplum® and Greenplum Database® are registered trademarks or trademarks of Broadcom Inc. in the United States and/or other countries.