Monitoring the state of a Greenplum® cluster and hosts

1. Go to the folder page and select Managed Service for Greenplum.
2. Click the name of the cluster you need and select the Monitoring tab.

3. To get started with Yandex Monitoring metrics, dashboards, or alerts, click Open in Monitoring in the top panel.

The page displays the following charts:

• Alive hosts: Cluster host functionality.

• Alive segments: Primary and backup master as well as primary and mirror segment functionality.

• Connections: Number of DB connections in each state:

  • Active: Active.
  • Waiting: Waiting.
  • Idle: Idle.
  • Idle in transaction: Idle in a transaction.
  • Aborted: Terminated.

• Group resource cpu: Processor core workload by process group:

  • admin_group: In the administrative group.
  • default_group: In the default group.

• Group resource memory: Bytes of RAM used by process group:

  • admin_group: In the administrative group.
  • default_group: In the default group.

• Master: Definition of the primary master host.

• Master replication lag: Master replication delay (in bytes).

• Master replication state: Master replication condition.

• Segment health: Number of segments with various levels of performance:

  • total: Everything.
  • not sync: Unsynced.
  • down: Unavailable.
  • not prefer role: Non-preferred.

• Spill files count: Number of temporary files.

• Spill files size: Total size of temporary files (in bytes).

• Xid wraparound: Utilization of sequence of transaction IDs (as a percentage).

• Background activities: Group of charts presenting information about background processes:

  • Tables vacuum age: Number of custom tables that were vacuumed N days ago.

  • Tables analyze age: Number of custom tables for which statistics were collected N days ago.

  • Expansion progress: Progress of data redistribution when expanding a cluster:

    • Tables: Percentage of processed tables.
    • Bytes: Percentage of redistributed data bytes.

    Note

    This chart will show the current progress, even if the data redistribution was started not as a background process.

1. Go to the folder page and select Managed Service for Greenplum.
2. Click the name of the cluster you need and select the Hosts → Monitoring tab.
3. Select the host from the drop-down list.

This page displays charts showing the workload of an individual cluster host (master or segment):

• CPU: Load on processor cores. As the load goes up, the Idle value goes down.
• Disk IOPS in progress: Number of pending disk operations.
• Disk io time: Duration of disk operations.
• Disk read and write: Amount of data in disk operations (in bytes).
• Disk read and write time: Duration of disk reads and writes.
• Disk usage: Disk space usage (two charts are displayed, in bytes and %).
• Memory usage: Use of RAM, in bytes. At high loads, the Free value goes down, while the other values go up.
• Network: Amount of network traffic (in bytes).

1. Go to the folder page and select Managed Service for Greenplum.
2. Click the name of the cluster you need and select the Monitoring → Network tab.

This page displays the following charts:

• Interfaces:

  • Client Interface Packets: Number of received and sent packets on the client network interface.
  • Client Interface Packets: Total size of received and sent data on the client network interface (in bytes).
  • Client Interface Drops and Errors: Number of errors and drops on the client network interface when sending or transmitting packets.
  • Service Interface Packets: Number of received and sent packets on the service network interface.
  • Service Interface Packets: Total size of received and sent data on the service network interface (in bytes).
  • Service Interface Drops and Errors: Number of errors and drops on the service network interface when sending or transmitting packets.

• CPU:

  • CPU Usage: Usage of processor cores (percentage).

• Ping and SSH response time:

  • Host Ping Average Response: Average ping response time (in milliseconds).
  • Host Ping Packet Loss: Lost ping packets (percentage).
  • Host SSH Response Time: Response time when connecting via SSH (in milliseconds).

• TCP counters:

  • TcpActiveConnection: Number of active TCP connections in the ESTABLISHED or CLOSE-WAIT state.
  • TCP Errors: Number of errors when transmitting TCP packets.
  • TcpEstabPresets: Number of times TCP connections have made a direct transition to the CLOSED state from either the ESTABLISHED or CLOSE-WAIT state.
  • TCP Retransmission: Number of retransmitted TCP packets.

• ICMP Counters:

  • IcmpErrors: Number of ICMP error messages.
  • Icmp6PacketsTooBig: Number of ICMPv6 Packet Too Big messages.
  • IcmpDestUnreached: Number of ICMP and ICMPv6 Destination Unreachable messages.

• UDP counters:

  • UdpSndbufErrors: Number of buffer errors when sending UDP packets.
  • UDP Datagrams: Number of UDP packets.
  • UdpRcvbufErrors: Number of buffer errors when receiving UDP packets.
  • UDP NoPorts: Number of UDP packets received without a listener on the destination port.

• IP:

  • IpMulticastPackets: Number of received and sent multicast packets.
  • Ip6 Neighbor Discovery: Number of sent requests and router advertisements.
  • IpBroadcastPackets: Number of received and sent broadcast packets.
  • Ip6NoRoutes: Number of IPv6 packets discarded because no route could be found.

1. Go to the folder page and select Managed Service for Greenplum.
2. Click the name of the cluster you need and select the Monitoring → PXF tab.

This page displays the following charts:

• Liveness: PXF state on hosts.

• Connections: Number of connections.

• Log messages: Number of messages of the warn, trace, info, fatal, error, and debug types.

• File handles: Number of files opened during the PXF process.

• JVM memory: JVM PXF memory usage (in GB).

• PXF threads: Number of PXF threads.

• Sent data: Amount of sent data.

• Sent records: Number of records send by PXF.

• JVM threads: Number of JVM PXF threads.

• PXF Busy threads: Number of busy PXF threads.

• Received data: Amount of received data.

• Received records: Number of records received by PXF.

1. In the management console, select the folder with the cluster you want to configure alerts for.
2. In the list of services, select Monitoring.
3. Under Service dashboards, select:
   • Managed Service for Greenplum® — Cluster Overview to configure cluster alerts.
   • Managed Service for Greenplum® — Host Overview to configure host alerts.
4. In the indicator chart, click and select Create alert.
5. If the chart shows multiple indicators, select a data query to generate a metric and click Continue. For more information about the query language, see the Yandex Monitoring documentation.
6. Set the Alarm and Warning thresholds for notifications.
7. Click Create alert.

1. Create an alert.
2. Add a status metric.
3. In the alert parameters, set up your alert thresholds.