Query Log - GetUPgSQLInstanceLog
Overview
You can query the error logs and full query logs of the DB
Definition
Public Parameters
| Parameter Name | Type | Description Information | Required |
|---|---|---|---|
| Action | string | Corresponding API command name, the current API is GetUPgSQLInstanceLog. | Yes |
| PublicKey | string | The user's public key can be obtained from Console (opens in a new tab) | Yes |
| Signature | string | User signature generated based on public key and API command, see Signature Algorithm | Yes |
Request Parameters
| Parameter Name | Type | Description Information | Required |
|---|---|---|---|
| Region | string | Region. See List of Regions and Availability Zones | Yes |
| ProjectId | string | Project ID. If not filled in, the default project is used, sub-accounts must be filled in. Please refer to the GetProjectList interface. | No |
| ZoneID | int | Availability Zone | Yes |
| DBId | string | Instance ClusterID | Yes |
| LogType | string | Log Type | Yes |
| CompanyID | int | Yes | |
| AccountID | int | Yes | |
| BeginTime | int | Start time, timestamp required | Yes |
| EndTime | int | End time, timestamp required, end time must be greater than start time | Yes |
Response Field
| Field Name | Type | Description Information | Required |
|---|---|---|---|
| RetCode | int | Return status code. If it is 0, it means successful return. If it is not 0, it means failure. | Yes |
| Action | string | Operation command name. | Yes |
| Message | string | Returns an error message, providing detailed description when RetCode is non-zero. | No |
| Log | string | Returned log information | Yes |
Example
Request Example
https://api.surfercloud.com/?Action=GetUPgSQLInstanceLog
&Region=cn-zj
&ProjectId=hjoEHCAh
&ZoneID=666003001
&DBId=hZkoNEiZ
&LogType=sDVQeSdg
&CompanyID=6
&AccountID=6
&BeginTime=9
&EndTime=3Response Example
{
"Action": "GetUPgSQLInstanceLogResponse",
"Log": "qxfLrSZN",
"RetCode": 0
}