Monitoring and logs in Yandex MPP Analytics for PostgreSQL

What metrics and processes can be tracked using monitoring?What metrics and processes can be tracked using monitoring?

For all DBMS types, you can track:

• CPU, memory, network, or disk usage, in absolute terms.
• Memory, network, or disk usage as a percentage of the set limits for the corresponding cluster host class.
• Amount of data in the DB cluster and the remaining free space in the data storage.

For DB hosts, you can track metrics specific to the corresponding type of DBMS. For example, for Greenplum®, you can track:

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

You can monitor with a minimum resolution of 5 seconds.

For more information about monitoring, see Monitoring cluster and host state.

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

Cluster logs are stored for 30 days.

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