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	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
Zone	string	Availability Zone. See Availability Zone List	Yes
LogType	string	Log Type	Yes
CompanyID	int	Company ID	Yes
AccountID	int	Account ID	Yes
BeginTime	int	Start time, timestamp required	Yes
InstanceID	string	Instance Resource ID	Yes
EndTime	int	End time, timestamp should be used, end time should be greater than start time No need to pass when querying in real time.	No

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.sigcalcloud.com/?Action=GetUPgSQLInstanceLog
&Region=cn-zj
&ProjectId=hjoEHCAh
&ZoneID=666003001
&DBId=hZkoNEiZ
&LogType=sDVQeSdg
&CompanyID=6
&AccountID=6
&BeginTime=9
&EndTime=3

Response Example


{
  "Action": "GetUPgSQLInstanceLogResponse",
  "Log": "qxfLrSZN",
  "RetCode": 0
}