Viewing Greenplum® cluster logs

If you do not have the Yandex Cloud command line interface yet, install and initialize it.

The folder specified in the CLI profile is used by default. You can specify a different folder using the --folder-name or --folder-id parameter.

1. View the description of the CLI command to view cluster logs:

   yc managed-greenplum cluster list-logs --help
   

2. Run the following command to get cluster logs (our example does not contain a complete list of available parameters):

   yc managed-greenplum cluster list-logs <cluster_name_or_ID> \
      --limit <entry_number_limit> \
      --format <output_format> \
      --service-type <service_type> \
      --columns <list_of_columns_for_data_output> \
      --filter <entry_filtration_settings> \
      --since <time_range_left_boundary> \
      --until <time_range_right_boundary>
   

   Where:

   • --limit: limits on the number of entries to output.

   • --format: Format for log entries (text, yaml, json, or json-rest).

   • --service-type: Type of the service for which you want to output entries:

     • greenplum: Greenplum® operations log.
     • greenplum-pooler: Connection manager operations log.
     • greenplum-pxf: PXF protocol log.

   • --columns: List of columns for data output:

     • hostname: Host name.
     • level: Logging level, e.g., info.
     • pid: ID of the current session’s server process.
     • text: Message output by the component.

     Note

     A list of columns to output depends on the selected --service-type. The example shows only the main columns for the greenplum-pooler type.

     To output separate columns, provide the --format key and specify the output format (yaml, json, or json-rest). Columns are not supported for text output format that is set by default.

   • --filter: record filter settings, for example, message.hostname='node1.mdb.yandexcloud.net'.

   • --since: Left boundary of a time range in RFC-3339, HH:MM:SS format or a time interval relative to the current time. Examples: 2006-01-02T15:04:05Z, 15:04:05, 2h, 3h30m ago.

   • --until: right boundary of a time range, the format is similar to that of --since.

You can request the cluster name and ID with a list of clusters in the folder.

To get a cluster log, use the listLogs REST API method for the Cluster resource or the ClusterService/ListLogs gRPC API call, and provide in the request:

• Cluster ID in the clusterId parameter.

  To find out the cluster ID, get a list of clusters in the folder.

• Service type you need to get records for in the serviceType parameter.

  • GREENPLUM: Greenplum® operations log.
  • GREENPLUM_POOLER: Connection manager operations log.
  • GREENPLUM_PXF: PXF protocol log.

To get a cluster log stream, use the streamLogs REST API method for the Cluster resource or the ClusterService/StreamLogs gRPC API call, and provide in the request:

• Cluster ID in the clusterId parameter.

  To find out the cluster ID, get a list of clusters in the folder.

• Service type you need to get records for in the serviceType parameter.

  • GREENPLUM: Greenplum® operations log.
  • GREENPLUM_POOLER: Connection manager operations log.
  • GREENPLUM_PXF: PXF protocol log.