Cloud Monitor:Hologres use management

Procedure

1. Log on to the CloudMonitor console.

2. In the left-side navigation pane, choose CloudLens > CloudLens for Hologres. The CloudLens for Hologres page appears.

   Data Import Management

   1. In the left-side navigation pane, click Data Import Management and then click the Hologres Instance tab.

   2. On the Hologres Instance tab, view the basic information including Instances, Data Collection Instance, and Region. In the Access Overview section, the Hologres instances are summarized to facilitate resource auditing and log collection management.

   3. In the instance list in the lower part, view the details in the Production Instance ID/Name, Region, Instance Type, Version, and SQL Audit Log columns.

   4. Click the Destination Logstores tab. On the Destination Logstores tab, view the following information about the destination Logstores for Hologres: Destination, Region, Data Retention Period (Days), Collected Instance, and Type.

   Query and Analysis

   1. In the left-side navigation pane, click Query and Analysis and then click the SQL Audit Log tab.

   2. Select the ID of the Hologres instance and then query and analyze the SQL audit logs.

      Note

      For more information about how to query and analyze logs, see Query and analyze logs.

      The following table describes the Hologres fields and indexes.

      Field	Description
      __topic__	The log topic. Valid value: hologres_audit_log.
      authid	The ID used for authentication.
      client_addr	The IP address of the client accessing the Hologres instance.
      collect_time	The time when the log was collected.
      command_tag	The operation type.
      datname	The database name.
      duration	The time taken to return results after executing the SQL operation. Unit: ms.
      end_time	The end time point of the operation execution.
      instance	The ID of the Hologres instance.
      query	The executed SQL statement.
      start_time	The start time point of the operation execution.
      status	The status.
      usename	The username of the operation executor.

   Report Center

   1. In the left-side navigation pane, click Report Center and then click the SQL Audit Overview tab.

   2. Select the ID of the Hologres instance. On the right side of the page, set the time for SQL audit log analysis. You can also manually refresh and reset the time. You can click Save As to save the log. The report is displayed in full-screen mode on the page.

   3. Set multiple conditions to filter audit logs and show data reports, such as Instance ID, Database, Account, Type, Client IP, and Status.

   4. Analyze the SQL audit logs and collect statistics. The statistics are displayed in charts.

      • Statistics section: displays metrics such as Number of Users, Number of Audit Logs, Number of Clients, Execution Failure, and Number of Operated Databases.

      • Top data trend analysis section: displays charts for metrics such as Top 5 Users, Top 5 Executed Commands, and Top 5 Clients.

      • Quantity trend analysis section: displays charts for metrics such as Trend of Log Quantity and Trend of Logged-on Clients.

      • Audit Log Details: displays information such as Instance ID, Username, Authentication Information, Client IP, Collection Time, Database, Type, Status, Query, Start Time, End Time, and Duration.