CloudLens for Hologres provides the Log Explore feature for you to query and analyze your data.
Prerequisites
Procedure
-
Log on to the CloudMonitor 2.0 console. Select the target workspace. In the left-side navigation pane, choose All Features > CloudLens for Hologres.
-
In the top navigation bar, choose to query and analyze data. For more information about the query syntax, see Query and analysis with index patterns. In CloudLens for Hologres, you can view hologres_audit_log data in Log Service (SLS). The index fields include authid, client_addr, command_tag, datname, duration, query, status, and usename. Each log record displays the SQL statement, execution time, and status, such as
SUCCESS. You can perform multi-dimensional analysis using the time-series chart and the raw logs, Statistics and Charts, and log clustering tabs.
Hologres audit log fields
|
Field |
Description |
|
__topic__ |
The value is always hologres_audit_log. |
|
authid |
The authentication ID. |
|
client_addr |
The client IP address used to access the Hologres instance. |
|
collect_time |
The collection time. |
|
command_tag |
The operation type. |
|
datname |
The database name. |
|
duration |
The execution time of the SQL operation, in milliseconds (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 status of the operation. |
|
usename |
The user who executed the operation. |