Cloud Monitor:Hologres use management

Procedure

1. Log on to the Cloud Monitor 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 basic information such as Instances, Data Collection Instance, and Region. The Access Overview section summarizes Hologres instances for resource auditing and log collection management.

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

   4. Click the Destination Logstores tab to view information about the destination Logstores for Hologres, including 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 a Hologres instance ID to query and analyze its SQL audit logs.

      Note

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

      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 elapsed time from SQL execution to result return. Unit: ms.
      end_time	The end time of the operation.
      instance	The ID of the Hologres instance.
      query	The executed SQL statement.
      start_time	The start time of the operation.
      status	The execution status.
      usename	The username of the user who performed the operation.

   Report Center

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

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

   3. Filter audit logs by conditions such as Instance ID, Database, Account, Type, Client IP, and Status to generate data reports.

   4. View the SQL audit log analysis results. 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.