Managed Service for Greenplum® Audit Trails Events: ExpandCluster
- Event JSON schema
- Field description
- IamAuthentication
- IamTokenInfo
- Authorization
- ResourceMetadata
- Resource
- RequestMetadata
- Status
- ClusterEventDetails
- Cluster
- GreenplumConfig
- TimeOfDay
- Access
- Monitoring
- MasterSubclusterConfig
- Resources
- SegmentSubclusterConfig
- MaintenanceWindow
- WeeklyMaintenanceWindow
- MaintenanceOperation
- ClusterConfigSet
- GreenplumConfigSet6
- GreenplumConfig6
- ConnectionPoolerConfigSet
- ConnectionPoolerConfig
- BackgroundActivitiesConfig
- TableSizes
- BackgroundActivityStartAt
- AnalyzeAndVacuum
- QueryKillerScripts
- QueryKiller
- PXFConfigSet
- PXFConfig
- CloudStorage
- LoggingConfig
Event JSON schema
{
"eventId": "string",
"eventSource": "string",
"eventType": "string",
"eventTime": "string",
"authentication": {
"authenticated": "boolean",
// Includes only one of the fields `subjectType`
"subjectType": "string",
// end of the list of possible fields
// Includes only one of the fields `subjectId`
"subjectId": "string",
// end of the list of possible fields
// Includes only one of the fields `subjectName`
"subjectName": "string",
// end of the list of possible fields
// Includes only one of the fields `federationId`
"federationId": "string",
// end of the list of possible fields
// Includes only one of the fields `federationName`
"federationName": "string",
// end of the list of possible fields
// Includes only one of the fields `federationType`
"federationType": "string",
// end of the list of possible fields
"tokenInfo": {
"maskedIamToken": "string",
// Includes only one of the fields `iamTokenId`
"iamTokenId": "string",
// end of the list of possible fields
// Includes only one of the fields `impersonatorId`
"impersonatorId": "string",
// end of the list of possible fields
// Includes only one of the fields `impersonatorType`
"impersonatorType": "string",
// end of the list of possible fields
// Includes only one of the fields `impersonatorName`
"impersonatorName": "string",
// end of the list of possible fields
// Includes only one of the fields `impersonatorFederationId`
"impersonatorFederationId": "string",
// end of the list of possible fields
// Includes only one of the fields `impersonatorFederationName`
"impersonatorFederationName": "string",
// end of the list of possible fields
// Includes only one of the fields `impersonatorFederationType`
"impersonatorFederationType": "string"
// end of the list of possible fields
}
},
"authorization": {
"authorized": "boolean"
},
"resourceMetadata": {
"path": [
{
"resourceType": "string",
"resourceId": "string",
// Includes only one of the fields `resourceName`
"resourceName": "string"
// end of the list of possible fields
}
]
},
"requestMetadata": {
"remoteAddress": "string",
"userAgent": "string",
"requestId": "string",
// Includes only one of the fields `remotePort`
"remotePort": "string"
// end of the list of possible fields
},
"eventStatus": "string",
"error": {
"code": "integer",
"message": "string",
"details": [
"object"
]
},
"details": {
"clusterId": "string",
"clusterName": "string",
"cluster": {
"id": "string",
"folderId": "string",
"createdAt": "string",
"name": "string",
"config": {
"version": "string",
"backupWindowStart": {
"hours": "integer",
"minutes": "integer",
"seconds": "integer",
"nanos": "integer"
},
"backupRetainPeriodDays": "string",
"access": {
"dataLens": "boolean",
"webSql": "boolean",
"dataTransfer": "boolean",
"yandexQuery": "boolean"
},
"zoneId": "string",
"subnetId": "string",
"assignPublicIp": "boolean",
"fullVersion": "string"
},
"description": "string",
"labels": "object",
"environment": "string",
"monitoring": [
{
"name": "string",
"description": "string",
"link": "string"
}
],
"masterConfig": {
"resources": {
"resourcePresetId": "string",
"diskSize": "string",
"diskTypeId": "string"
}
},
"segmentConfig": {
"resources": {
"resourcePresetId": "string",
"diskSize": "string",
"diskTypeId": "string"
}
},
"masterHostCount": "string",
"segmentHostCount": "string",
"segmentInHost": "string",
"networkId": "string",
"health": "string",
"status": "string",
"maintenanceWindow": {
// Includes only one of the fields `anytime`, `weeklyMaintenanceWindow`
"anytime": "object",
"weeklyMaintenanceWindow": {
"day": "string",
"hour": "string"
}
// end of the list of possible fields
},
"plannedOperation": {
"info": "string",
"delayedUntil": "string"
},
"securityGroupIds": [
"string"
],
"userName": "string",
"deletionProtection": "boolean",
"hostGroupIds": [
"string"
],
"clusterConfig": {
// Includes only one of the fields `greenplumConfigSet_6`
"greenplumConfigSet_6": {
"effectiveConfig": {
"maxConnections": "string",
"maxSlotWalKeepSize": "string",
"gpWorkfileLimitPerSegment": "string",
"gpWorkfileLimitPerQuery": "string",
"gpWorkfileLimitFilesPerQuery": "string",
"maxPreparedTransactions": "string",
"gpWorkfileCompression": "boolean",
"maxStatementMem": "string",
"logStatement": "string",
"gpAddColumnInheritsTableSetting": "boolean",
"gpEnableGlobalDeadlockDetector": "boolean",
"gpGlobalDeadlockDetectorPeriod": "string",
"gpMaxSlices": "string",
"gpCachedSegworkersThreshold": "string",
"lockTimeout": "string",
"idleInTransactionSessionTimeout": "string",
"runawayDetectorActivationPercent": "string",
"gpVmemProtectSegworkerCacheLimit": "string",
"gpEnableZstdMemoryAccounting": "boolean",
"gpMaxPlanSize": "string",
"gpAutostatsMode": "string",
"gpAutostatsOnChangeThreshold": "string",
"gpResourceGroupMemoryLimit": "number",
"logConnections": "boolean",
"logDisconnections": "boolean",
"logHostname": "boolean",
"logStatementStats": "boolean",
"logMinDurationStatement": "string",
"masterSharedBuffers": "string",
"maxLocksPerTransaction": "string",
"segmentSharedBuffers": "string",
"logErrorVerbosity": "string",
"logMinMessages": "string"
},
"userConfig": {
"maxConnections": "string",
"maxSlotWalKeepSize": "string",
"gpWorkfileLimitPerSegment": "string",
"gpWorkfileLimitPerQuery": "string",
"gpWorkfileLimitFilesPerQuery": "string",
"maxPreparedTransactions": "string",
"gpWorkfileCompression": "boolean",
"maxStatementMem": "string",
"logStatement": "string",
"gpAddColumnInheritsTableSetting": "boolean",
"gpEnableGlobalDeadlockDetector": "boolean",
"gpGlobalDeadlockDetectorPeriod": "string",
"gpMaxSlices": "string",
"gpCachedSegworkersThreshold": "string",
"lockTimeout": "string",
"idleInTransactionSessionTimeout": "string",
"runawayDetectorActivationPercent": "string",
"gpVmemProtectSegworkerCacheLimit": "string",
"gpEnableZstdMemoryAccounting": "boolean",
"gpMaxPlanSize": "string",
"gpAutostatsMode": "string",
"gpAutostatsOnChangeThreshold": "string",
"gpResourceGroupMemoryLimit": "number",
"logConnections": "boolean",
"logDisconnections": "boolean",
"logHostname": "boolean",
"logStatementStats": "boolean",
"logMinDurationStatement": "string",
"masterSharedBuffers": "string",
"maxLocksPerTransaction": "string",
"segmentSharedBuffers": "string",
"logErrorVerbosity": "string",
"logMinMessages": "string"
},
"defaultConfig": {
"maxConnections": "string",
"maxSlotWalKeepSize": "string",
"gpWorkfileLimitPerSegment": "string",
"gpWorkfileLimitPerQuery": "string",
"gpWorkfileLimitFilesPerQuery": "string",
"maxPreparedTransactions": "string",
"gpWorkfileCompression": "boolean",
"maxStatementMem": "string",
"logStatement": "string",
"gpAddColumnInheritsTableSetting": "boolean",
"gpEnableGlobalDeadlockDetector": "boolean",
"gpGlobalDeadlockDetectorPeriod": "string",
"gpMaxSlices": "string",
"gpCachedSegworkersThreshold": "string",
"lockTimeout": "string",
"idleInTransactionSessionTimeout": "string",
"runawayDetectorActivationPercent": "string",
"gpVmemProtectSegworkerCacheLimit": "string",
"gpEnableZstdMemoryAccounting": "boolean",
"gpMaxPlanSize": "string",
"gpAutostatsMode": "string",
"gpAutostatsOnChangeThreshold": "string",
"gpResourceGroupMemoryLimit": "number",
"logConnections": "boolean",
"logDisconnections": "boolean",
"logHostname": "boolean",
"logStatementStats": "boolean",
"logMinDurationStatement": "string",
"masterSharedBuffers": "string",
"maxLocksPerTransaction": "string",
"segmentSharedBuffers": "string",
"logErrorVerbosity": "string",
"logMinMessages": "string"
}
},
// end of the list of possible fields
"pool": {
"effectiveConfig": {
"mode": "string",
"size": "string",
"clientIdleTimeout": "string",
"idleInTransactionTimeout": "string"
},
"userConfig": {
"mode": "string",
"size": "string",
"clientIdleTimeout": "string",
"idleInTransactionTimeout": "string"
},
"defaultConfig": {
"mode": "string",
"size": "string",
"clientIdleTimeout": "string",
"idleInTransactionTimeout": "string"
}
},
"backgroundActivities": {
"tableSizes": {
"starts": [
{
"hours": "string",
"minutes": "string"
}
]
},
"analyzeAndVacuum": {
"start": {
"hours": "string",
"minutes": "string"
},
"analyzeTimeout": "string",
"vacuumTimeout": "string"
},
"queryKillerScripts": {
"idle": {
"enable": "boolean",
"maxAge": "string",
"ignoreUsers": [
"string"
]
},
"idleInTransaction": {
"enable": "boolean",
"maxAge": "string",
"ignoreUsers": [
"string"
]
},
"longRunning": {
"enable": "boolean",
"maxAge": "string",
"ignoreUsers": [
"string"
]
}
}
},
"pxfConfig": {
"effectiveConfig": {
"connectionTimeout": "string",
"uploadTimeout": "string",
"maxThreads": "string",
"poolAllowCoreThreadTimeout": "boolean",
"poolCoreSize": "string",
"poolQueueCapacity": "string",
"poolMaxSize": "string",
"xmx": "string",
"xms": "string"
},
"userConfig": {
"connectionTimeout": "string",
"uploadTimeout": "string",
"maxThreads": "string",
"poolAllowCoreThreadTimeout": "boolean",
"poolCoreSize": "string",
"poolQueueCapacity": "string",
"poolMaxSize": "string",
"xmx": "string",
"xms": "string"
},
"defaultConfig": {
"connectionTimeout": "string",
"uploadTimeout": "string",
"maxThreads": "string",
"poolAllowCoreThreadTimeout": "boolean",
"poolCoreSize": "string",
"poolQueueCapacity": "string",
"poolMaxSize": "string",
"xmx": "string",
"xms": "string"
}
}
},
"cloudStorage": {
"enable": "boolean"
},
"masterHostGroupIds": [
"string"
],
"segmentHostGroupIds": [
"string"
],
"serviceAccountId": "string",
"logging": {
"enabled": "boolean",
// Includes only one of the fields `folderId`, `logGroupId`
"folderId": "string",
"logGroupId": "string",
// end of the list of possible fields
"commandCenterEnabled": "boolean",
"greenplumEnabled": "boolean",
"poolerEnabled": "boolean"
}
}
},
"requestParameters": "object",
"response": "object"
}
Field description
|
Field |
Description |
|
eventId |
string |
|
eventSource |
string |
|
eventType |
string |
|
eventTime |
string (date-time) String in RFC3339 To work with values in this field, use the APIs described in the |
|
authentication |
|
|
authorization |
|
|
resourceMetadata |
|
|
requestMetadata |
|
|
eventStatus |
enum (EventStatus)
|
|
error |
The error result of the operation in case of failure or cancellation. |
|
details |
|
|
requestParameters |
object |
|
response |
object |
IamAuthentication
|
Field |
Description |
|
authenticated |
boolean |
|
subjectType |
enum (IamSubjectType) Includes only one of the fields
|
|
subjectId |
string Includes only one of the fields |
|
subjectName |
string Includes only one of the fields |
|
federationId |
string Includes only one of the fields |
|
federationName |
string Includes only one of the fields |
|
federationType |
enum (FederationType) Includes only one of the fields
|
|
tokenInfo |
IamTokenInfo
|
Field |
Description |
|
maskedIamToken |
string |
|
iamTokenId |
string Includes only one of the fields |
|
impersonatorId |
string Includes only one of the fields |
|
impersonatorType |
enum (IamSubjectType) Includes only one of the fields
|
|
impersonatorName |
string Includes only one of the fields |
|
impersonatorFederationId |
string Includes only one of the fields |
|
impersonatorFederationName |
string Includes only one of the fields |
|
impersonatorFederationType |
enum (FederationType) Includes only one of the fields
|
Authorization
|
Field |
Description |
|
authorized |
boolean |
ResourceMetadata
|
Field |
Description |
|
path[] |
Resource
|
Field |
Description |
|
resourceType |
string |
|
resourceId |
string |
|
resourceName |
string Includes only one of the fields |
RequestMetadata
|
Field |
Description |
|
remoteAddress |
string |
|
userAgent |
string |
|
requestId |
string |
|
remotePort |
string (int64) Includes only one of the fields |
Status
The error result of the operation in case of failure or cancellation.
|
Field |
Description |
|
code |
integer (int32) Error code. An enum value of google.rpc.Code |
|
message |
string An error message. |
|
details[] |
object A list of messages that carry the error details. |
ClusterEventDetails
|
Field |
Description |
|
clusterId |
string The maximum string length in characters is 50. |
|
clusterName |
string |
|
cluster |
Cluster
|
Field |
Description |
|
id |
string |
|
folderId |
string |
|
createdAt |
string (date-time) String in RFC3339 To work with values in this field, use the APIs described in the |
|
name |
string The maximum string length in characters is 63. |
|
config |
|
|
description |
string The maximum string length in characters is 256. |
|
labels |
object (map<string, string>) |
|
environment |
enum (Environment)
|
|
monitoring[] |
|
|
masterConfig |
|
|
segmentConfig |
|
|
masterHostCount |
string (int64) |
|
segmentHostCount |
string (int64) |
|
segmentInHost |
string (int64) |
|
networkId |
string |
|
health |
enum (Health)
|
|
status |
enum (Status)
|
|
maintenanceWindow |
|
|
plannedOperation |
|
|
securityGroupIds[] |
string |
|
userName |
string |
|
deletionProtection |
boolean |
|
hostGroupIds[] |
string |
|
clusterConfig |
|
|
cloudStorage |
|
|
masterHostGroupIds[] |
string |
|
segmentHostGroupIds[] |
string |
|
serviceAccountId |
string |
|
logging |
GreenplumConfig
|
Field |
Description |
|
version |
string |
|
backupWindowStart |
|
|
backupRetainPeriodDays |
string (int64) Acceptable values are 1 to 60, inclusive. |
|
access |
|
|
zoneId |
string The maximum string length in characters is 50. |
|
subnetId |
string The maximum string length in characters is 50. |
|
assignPublicIp |
boolean |
|
fullVersion |
string |
TimeOfDay
|
Field |
Description |
|
hours |
integer (int32) |
|
minutes |
integer (int32) |
|
seconds |
integer (int32) |
|
nanos |
integer (int32) |
Access
|
Field |
Description |
|
dataLens |
boolean |
|
webSql |
boolean |
|
dataTransfer |
boolean |
|
yandexQuery |
boolean |
Monitoring
|
Field |
Description |
|
name |
string |
|
description |
string |
|
link |
string |
MasterSubclusterConfig
|
Field |
Description |
|
resources |
Resources
|
Field |
Description |
|
resourcePresetId |
string |
|
diskSize |
string (int64) |
|
diskTypeId |
string |
SegmentSubclusterConfig
|
Field |
Description |
|
resources |
MaintenanceWindow
|
Field |
Description |
|
anytime |
object Includes only one of the fields |
|
weeklyMaintenanceWindow |
Includes only one of the fields |
WeeklyMaintenanceWindow
|
Field |
Description |
|
day |
enum (WeekDay)
|
|
hour |
string (int64) Acceptable values are 1 to 24, inclusive. |
MaintenanceOperation
|
Field |
Description |
|
info |
string The maximum string length in characters is 256. |
|
delayedUntil |
string (date-time) String in RFC3339 To work with values in this field, use the APIs described in the |
ClusterConfigSet
|
Field |
Description |
|
greenplumConfigSet_6 |
Includes only one of the fields |
|
pool |
|
|
backgroundActivities |
|
|
pxfConfig |
GreenplumConfigSet6
|
Field |
Description |
|
effectiveConfig |
|
|
userConfig |
|
|
defaultConfig |
GreenplumConfig6
|
Field |
Description |
|
maxConnections |
string (int64) Acceptable values are 50 to 1000, inclusive. |
|
maxSlotWalKeepSize |
string (int64) Acceptable values are 0 to 214748364800, inclusive. |
|
gpWorkfileLimitPerSegment |
string (int64) The minimum value is 0. |
|
gpWorkfileLimitPerQuery |
string (int64) Acceptable values are 0 to 1099511627776, inclusive. |
|
gpWorkfileLimitFilesPerQuery |
string (int64) Acceptable values are 0 to 100000, inclusive. |
|
maxPreparedTransactions |
string (int64) Acceptable values are 50 to 10000, inclusive. |
|
gpWorkfileCompression |
boolean |
|
maxStatementMem |
string (int64) Acceptable values are 134217728 to 1099511627776, inclusive. |
|
logStatement |
enum (LogStatement)
|
|
gpAddColumnInheritsTableSetting |
boolean |
|
gpEnableGlobalDeadlockDetector |
boolean |
|
gpGlobalDeadlockDetectorPeriod |
string (int64) |
|
gpMaxSlices |
string (int64) Acceptable values are 10 to 100, inclusive. |
|
gpCachedSegworkersThreshold |
string (int64) Acceptable values are 0 to 10, inclusive. |
|
lockTimeout |
string (int64) Acceptable values are 0 to 2147483647, inclusive. |
|
idleInTransactionSessionTimeout |
string (int64) Acceptable values are 0 to 2147483647, inclusive. |
|
runawayDetectorActivationPercent |
string (int64) Acceptable values are 0 to 100, inclusive. |
|
gpVmemProtectSegworkerCacheLimit |
string (int64) Acceptable values are 0 to 4096, inclusive. |
|
gpEnableZstdMemoryAccounting |
boolean |
|
gpMaxPlanSize |
string (int64) Acceptable values are 0 to 2147483647, inclusive. |
|
gpAutostatsMode |
enum (GPAutostatsMode)
|
|
gpAutostatsOnChangeThreshold |
string (int64) Acceptable values are 0 to 2147483647, inclusive. |
|
gpResourceGroupMemoryLimit |
number (double) |
|
logConnections |
boolean |
|
logDisconnections |
boolean |
|
logHostname |
boolean |
|
logStatementStats |
boolean |
|
logMinDurationStatement |
string (int64) |
|
masterSharedBuffers |
string (int64) Acceptable values are 1048576 to 2147483647, inclusive. |
|
maxLocksPerTransaction |
string (int64) Acceptable values are 128 to 2048, inclusive. |
|
segmentSharedBuffers |
string (int64) Acceptable values are 1048576 to 2147483647, inclusive. |
|
logErrorVerbosity |
enum (LogErrorVerbosity)
|
|
logMinMessages |
enum (LogLevelMessage)
|
ConnectionPoolerConfigSet
|
Field |
Description |
|
effectiveConfig |
|
|
userConfig |
|
|
defaultConfig |
ConnectionPoolerConfig
|
Field |
Description |
|
mode |
enum (PoolMode)
|
|
size |
string (int64) |
|
clientIdleTimeout |
string (int64) |
|
idleInTransactionTimeout |
string (int64) |
BackgroundActivitiesConfig
|
Field |
Description |
|
tableSizes |
|
|
analyzeAndVacuum |
|
|
queryKillerScripts |
TableSizes
|
Field |
Description |
|
starts[] |
The maximum number of elements is 4. |
BackgroundActivityStartAt
|
Field |
Description |
|
hours |
string (int64) Acceptable values are 0 to 23, inclusive. |
|
minutes |
string (int64) Acceptable values are 0 to 59, inclusive. |
AnalyzeAndVacuum
|
Field |
Description |
|
start |
|
|
analyzeTimeout |
string (int64) Acceptable values are 7200 to 86399, inclusive. |
|
vacuumTimeout |
string (int64) Acceptable values are 7200 to 86399, inclusive. |
QueryKillerScripts
|
Field |
Description |
|
idle |
|
|
idleInTransaction |
|
|
longRunning |
QueryKiller
|
Field |
Description |
|
enable |
boolean |
|
maxAge |
string (int64) Acceptable values are 1 to 86400, inclusive. |
|
ignoreUsers[] |
string |
PXFConfigSet
|
Field |
Description |
|
effectiveConfig |
|
|
userConfig |
|
|
defaultConfig |
PXFConfig
|
Field |
Description |
|
connectionTimeout |
string (int64) Acceptable values are 5 to 600, inclusive. |
|
uploadTimeout |
string (int64) Acceptable values are 5 to 600, inclusive. |
|
maxThreads |
string (int64) Acceptable values are 1 to 1024, inclusive. |
|
poolAllowCoreThreadTimeout |
boolean |
|
poolCoreSize |
string (int64) Acceptable values are 1 to 1024, inclusive. |
|
poolQueueCapacity |
string (int64) The minimum value is 0. |
|
poolMaxSize |
string (int64) Acceptable values are 1 to 1024, inclusive. |
|
xmx |
string (int64) The minimum value is 64. |
|
xms |
string (int64) The minimum value is 64. |
CloudStorage
|
Field |
Description |
|
enable |
boolean |
LoggingConfig
|
Field |
Description |
|
enabled |
boolean |
|
folderId |
string Value must match the regular expression Includes only one of the fields |
|
logGroupId |
string Value must match the regular expression Includes only one of the fields |
|
commandCenterEnabled |
boolean |
|
greenplumEnabled |
boolean |
|
poolerEnabled |
boolean |