Managed Service for PostgreSQL API, REST: Cluster.ListHosts
- HTTP request
- Path parameters
- Query parameters
- Response
- Host
- Resources
- Service
- HostConfig
- PostgresqlHostConfig9_6
- PostgresqlHostConfig10_1C
- PostgresqlHostConfig10
- PostgresqlHostConfig11
- PostgresqlHostConfig11_1C
- PostgresqlHostConfig12
- PostgresqlHostConfig12_1C
- PostgresqlHostConfig13
- PostgresqlHostConfig13_1C
- PostgresqlHostConfig14
- PostgresqlHostConfig14_1C
- PostgresqlHostConfig15
- PostgresqlHostConfig15_1C
- PostgresqlHostConfig16
- PostgresqlHostConfig16_1C
- PostgresqlHostConfig17
- PostgresqlHostConfig17_1C
- PostgresqlHostConfig18
- PostgresqlHostConfig18_1C
Retrieves a list of hosts for the specified cluster.
HTTP request
GET https://mdb.api.yandexcloud.kz/managed-postgresql/v1/clusters/{clusterId}/hosts
Path parameters
|
Field |
Description |
|
clusterId |
string Required field. ID of the PostgreSQL cluster. The maximum string length in characters is 50. |
Query parameters
|
Field |
Description |
|
pageSize |
string (int64) The maximum number of results per page to return. If the number of available The maximum value is 1000. |
|
pageToken |
string Page token. To get the next page of results, set The maximum string length in characters is 100. |
Response
HTTP Code: 200 - OK
{
"hosts": [
{
"name": "string",
"clusterId": "string",
"zoneId": "string",
"resources": {
"resourcePresetId": "string",
"diskSize": "string",
"diskTypeId": "string"
},
"role": "string",
"health": "string",
"services": [
{
"type": "string",
"health": "string"
}
],
"subnetId": "string",
"replicationSource": "string",
"priority": "string",
"config": {
// Includes only one of the fields `postgresqlConfig_9_6`, `postgresqlConfig_10_1c`, `postgresqlConfig_10`, `postgresqlConfig_11`, `postgresqlConfig_11_1c`, `postgresqlConfig_12`, `postgresqlConfig_12_1c`, `postgresqlConfig_13`, `postgresqlConfig_13_1c`, `postgresqlConfig_14`, `postgresqlConfig_14_1c`, `postgresqlConfig_15`, `postgresqlConfig_15_1c`, `postgresqlConfig_16`, `postgresqlConfig_16_1c`, `postgresqlConfig_17`, `postgresqlConfig_17_1c`, `postgresqlConfig_18`, `postgresqlConfig_18_1c`
"postgresqlConfig_9_6": {
"recoveryMinApplyDelay": "string",
"sharedBuffers": "string",
"tempBuffers": "string",
"workMem": "string",
"replacementSortTuples": "string",
"tempFileLimit": "string",
"backendFlushAfter": "string",
"oldSnapshotThreshold": "string",
"maxStandbyStreamingDelay": "string",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "string",
"joinCollapseLimit": "string",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "string",
"logCheckpoints": "boolean",
"logConnections": "boolean",
"logDisconnections": "boolean",
"logDuration": "boolean",
"logErrorVerbosity": "string",
"logLockWaits": "boolean",
"logStatement": "string",
"logTempFiles": "string",
"searchPath": "string",
"rowSecurity": "boolean",
"defaultTransactionIsolation": "string",
"statementTimeout": "string",
"lockTimeout": "string",
"idleInTransactionSessionTimeout": "string",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "string",
"deadlockTimeout": "string",
"maxLocksPerTransaction": "string",
"maxPredLocksPerTransaction": "string",
"arrayNulls": "boolean",
"backslashQuote": "string",
"defaultWithOids": "boolean",
"escapeStringWarning": "boolean",
"loCompatPrivileges": "boolean",
"operatorPrecedenceWarning": "boolean",
"quoteAllIdentifiers": "boolean",
"standardConformingStrings": "boolean",
"synchronizeSeqscans": "boolean",
"transformNullEquals": "boolean",
"exitOnError": "boolean",
"seqPageCost": "number",
"randomPageCost": "number",
"sqlInheritance": "boolean",
"effectiveIoConcurrency": "string",
"effectiveCacheSize": "string"
},
"postgresqlConfig_10_1c": {
"recoveryMinApplyDelay": "string",
"sharedBuffers": "string",
"tempBuffers": "string",
"workMem": "string",
"replacementSortTuples": "string",
"tempFileLimit": "string",
"backendFlushAfter": "string",
"oldSnapshotThreshold": "string",
"maxStandbyStreamingDelay": "string",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "string",
"joinCollapseLimit": "string",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "string",
"logCheckpoints": "boolean",
"logConnections": "boolean",
"logDisconnections": "boolean",
"logDuration": "boolean",
"logErrorVerbosity": "string",
"logLockWaits": "boolean",
"logStatement": "string",
"logTempFiles": "string",
"searchPath": "string",
"rowSecurity": "boolean",
"defaultTransactionIsolation": "string",
"statementTimeout": "string",
"lockTimeout": "string",
"idleInTransactionSessionTimeout": "string",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "string",
"deadlockTimeout": "string",
"maxLocksPerTransaction": "string",
"maxPredLocksPerTransaction": "string",
"arrayNulls": "boolean",
"backslashQuote": "string",
"defaultWithOids": "boolean",
"escapeStringWarning": "boolean",
"loCompatPrivileges": "boolean",
"operatorPrecedenceWarning": "boolean",
"quoteAllIdentifiers": "boolean",
"standardConformingStrings": "boolean",
"synchronizeSeqscans": "boolean",
"transformNullEquals": "boolean",
"exitOnError": "boolean",
"seqPageCost": "number",
"randomPageCost": "number",
"enableBitmapscan": "boolean",
"enableHashagg": "boolean",
"enableHashjoin": "boolean",
"enableIndexscan": "boolean",
"enableIndexonlyscan": "boolean",
"enableMaterial": "boolean",
"enableMergejoin": "boolean",
"enableNestloop": "boolean",
"enableSeqscan": "boolean",
"enableSort": "boolean",
"enableTidscan": "boolean",
"maxParallelWorkers": "string",
"maxParallelWorkersPerGather": "string",
"timezone": "string",
"effectiveIoConcurrency": "string",
"effectiveCacheSize": "string"
},
"postgresqlConfig_10": {
"recoveryMinApplyDelay": "string",
"sharedBuffers": "string",
"tempBuffers": "string",
"workMem": "string",
"replacementSortTuples": "string",
"tempFileLimit": "string",
"backendFlushAfter": "string",
"oldSnapshotThreshold": "string",
"maxStandbyStreamingDelay": "string",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "string",
"joinCollapseLimit": "string",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "string",
"logCheckpoints": "boolean",
"logConnections": "boolean",
"logDisconnections": "boolean",
"logDuration": "boolean",
"logErrorVerbosity": "string",
"logLockWaits": "boolean",
"logStatement": "string",
"logTempFiles": "string",
"searchPath": "string",
"rowSecurity": "boolean",
"defaultTransactionIsolation": "string",
"statementTimeout": "string",
"lockTimeout": "string",
"idleInTransactionSessionTimeout": "string",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "string",
"deadlockTimeout": "string",
"maxLocksPerTransaction": "string",
"maxPredLocksPerTransaction": "string",
"arrayNulls": "boolean",
"backslashQuote": "string",
"defaultWithOids": "boolean",
"escapeStringWarning": "boolean",
"loCompatPrivileges": "boolean",
"operatorPrecedenceWarning": "boolean",
"quoteAllIdentifiers": "boolean",
"standardConformingStrings": "boolean",
"synchronizeSeqscans": "boolean",
"transformNullEquals": "boolean",
"exitOnError": "boolean",
"seqPageCost": "number",
"randomPageCost": "number",
"enableBitmapscan": "boolean",
"enableHashagg": "boolean",
"enableHashjoin": "boolean",
"enableIndexscan": "boolean",
"enableIndexonlyscan": "boolean",
"enableMaterial": "boolean",
"enableMergejoin": "boolean",
"enableNestloop": "boolean",
"enableSeqscan": "boolean",
"enableSort": "boolean",
"enableTidscan": "boolean",
"maxParallelWorkers": "string",
"maxParallelWorkersPerGather": "string",
"timezone": "string",
"effectiveIoConcurrency": "string",
"effectiveCacheSize": "string"
},
"postgresqlConfig_11": {
"recoveryMinApplyDelay": "string",
"sharedBuffers": "string",
"tempBuffers": "string",
"workMem": "string",
"tempFileLimit": "string",
"backendFlushAfter": "string",
"oldSnapshotThreshold": "string",
"maxStandbyStreamingDelay": "string",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "string",
"joinCollapseLimit": "string",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "string",
"logCheckpoints": "boolean",
"logConnections": "boolean",
"logDisconnections": "boolean",
"logDuration": "boolean",
"logErrorVerbosity": "string",
"logLockWaits": "boolean",
"logStatement": "string",
"logTempFiles": "string",
"searchPath": "string",
"rowSecurity": "boolean",
"defaultTransactionIsolation": "string",
"statementTimeout": "string",
"lockTimeout": "string",
"idleInTransactionSessionTimeout": "string",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "string",
"deadlockTimeout": "string",
"maxLocksPerTransaction": "string",
"maxPredLocksPerTransaction": "string",
"arrayNulls": "boolean",
"backslashQuote": "string",
"defaultWithOids": "boolean",
"escapeStringWarning": "boolean",
"loCompatPrivileges": "boolean",
"operatorPrecedenceWarning": "boolean",
"quoteAllIdentifiers": "boolean",
"standardConformingStrings": "boolean",
"synchronizeSeqscans": "boolean",
"transformNullEquals": "boolean",
"exitOnError": "boolean",
"seqPageCost": "number",
"randomPageCost": "number",
"enableBitmapscan": "boolean",
"enableHashagg": "boolean",
"enableHashjoin": "boolean",
"enableIndexscan": "boolean",
"enableIndexonlyscan": "boolean",
"enableMaterial": "boolean",
"enableMergejoin": "boolean",
"enableNestloop": "boolean",
"enableSeqscan": "boolean",
"enableSort": "boolean",
"enableTidscan": "boolean",
"maxParallelWorkers": "string",
"maxParallelWorkersPerGather": "string",
"timezone": "string",
"effectiveIoConcurrency": "string",
"effectiveCacheSize": "string"
},
"postgresqlConfig_11_1c": {
"recoveryMinApplyDelay": "string",
"sharedBuffers": "string",
"tempBuffers": "string",
"workMem": "string",
"tempFileLimit": "string",
"backendFlushAfter": "string",
"oldSnapshotThreshold": "string",
"maxStandbyStreamingDelay": "string",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "string",
"joinCollapseLimit": "string",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "string",
"logCheckpoints": "boolean",
"logConnections": "boolean",
"logDisconnections": "boolean",
"logDuration": "boolean",
"logErrorVerbosity": "string",
"logLockWaits": "boolean",
"logStatement": "string",
"logTempFiles": "string",
"searchPath": "string",
"rowSecurity": "boolean",
"defaultTransactionIsolation": "string",
"statementTimeout": "string",
"lockTimeout": "string",
"idleInTransactionSessionTimeout": "string",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "string",
"deadlockTimeout": "string",
"maxLocksPerTransaction": "string",
"maxPredLocksPerTransaction": "string",
"arrayNulls": "boolean",
"backslashQuote": "string",
"defaultWithOids": "boolean",
"escapeStringWarning": "boolean",
"loCompatPrivileges": "boolean",
"operatorPrecedenceWarning": "boolean",
"quoteAllIdentifiers": "boolean",
"standardConformingStrings": "boolean",
"synchronizeSeqscans": "boolean",
"transformNullEquals": "boolean",
"exitOnError": "boolean",
"seqPageCost": "number",
"randomPageCost": "number",
"enableBitmapscan": "boolean",
"enableHashagg": "boolean",
"enableHashjoin": "boolean",
"enableIndexscan": "boolean",
"enableIndexonlyscan": "boolean",
"enableMaterial": "boolean",
"enableMergejoin": "boolean",
"enableNestloop": "boolean",
"enableSeqscan": "boolean",
"enableSort": "boolean",
"enableTidscan": "boolean",
"maxParallelWorkers": "string",
"maxParallelWorkersPerGather": "string",
"timezone": "string",
"effectiveIoConcurrency": "string",
"effectiveCacheSize": "string"
},
"postgresqlConfig_12": {
"recoveryMinApplyDelay": "string",
"sharedBuffers": "string",
"tempBuffers": "string",
"workMem": "string",
"tempFileLimit": "string",
"backendFlushAfter": "string",
"oldSnapshotThreshold": "string",
"maxStandbyStreamingDelay": "string",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "string",
"joinCollapseLimit": "string",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "string",
"logCheckpoints": "boolean",
"logConnections": "boolean",
"logDisconnections": "boolean",
"logDuration": "boolean",
"logErrorVerbosity": "string",
"logLockWaits": "boolean",
"logStatement": "string",
"logTempFiles": "string",
"searchPath": "string",
"rowSecurity": "boolean",
"defaultTransactionIsolation": "string",
"statementTimeout": "string",
"lockTimeout": "string",
"idleInTransactionSessionTimeout": "string",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "string",
"deadlockTimeout": "string",
"maxLocksPerTransaction": "string",
"maxPredLocksPerTransaction": "string",
"arrayNulls": "boolean",
"backslashQuote": "string",
"defaultWithOids": "boolean",
"escapeStringWarning": "boolean",
"loCompatPrivileges": "boolean",
"operatorPrecedenceWarning": "boolean",
"quoteAllIdentifiers": "boolean",
"standardConformingStrings": "boolean",
"synchronizeSeqscans": "boolean",
"transformNullEquals": "boolean",
"exitOnError": "boolean",
"seqPageCost": "number",
"randomPageCost": "number",
"enableBitmapscan": "boolean",
"enableHashagg": "boolean",
"enableHashjoin": "boolean",
"enableIndexscan": "boolean",
"enableIndexonlyscan": "boolean",
"enableMaterial": "boolean",
"enableMergejoin": "boolean",
"enableNestloop": "boolean",
"enableSeqscan": "boolean",
"enableSort": "boolean",
"enableTidscan": "boolean",
"maxParallelWorkers": "string",
"maxParallelWorkersPerGather": "string",
"timezone": "string",
"effectiveIoConcurrency": "string",
"effectiveCacheSize": "string"
},
"postgresqlConfig_12_1c": {
"recoveryMinApplyDelay": "string",
"sharedBuffers": "string",
"tempBuffers": "string",
"workMem": "string",
"tempFileLimit": "string",
"backendFlushAfter": "string",
"oldSnapshotThreshold": "string",
"maxStandbyStreamingDelay": "string",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "string",
"joinCollapseLimit": "string",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "string",
"logCheckpoints": "boolean",
"logConnections": "boolean",
"logDisconnections": "boolean",
"logDuration": "boolean",
"logErrorVerbosity": "string",
"logLockWaits": "boolean",
"logStatement": "string",
"logTempFiles": "string",
"searchPath": "string",
"rowSecurity": "boolean",
"defaultTransactionIsolation": "string",
"statementTimeout": "string",
"lockTimeout": "string",
"idleInTransactionSessionTimeout": "string",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "string",
"deadlockTimeout": "string",
"maxLocksPerTransaction": "string",
"maxPredLocksPerTransaction": "string",
"arrayNulls": "boolean",
"backslashQuote": "string",
"defaultWithOids": "boolean",
"escapeStringWarning": "boolean",
"loCompatPrivileges": "boolean",
"operatorPrecedenceWarning": "boolean",
"quoteAllIdentifiers": "boolean",
"standardConformingStrings": "boolean",
"synchronizeSeqscans": "boolean",
"transformNullEquals": "boolean",
"exitOnError": "boolean",
"seqPageCost": "number",
"randomPageCost": "number",
"enableBitmapscan": "boolean",
"enableHashagg": "boolean",
"enableHashjoin": "boolean",
"enableIndexscan": "boolean",
"enableIndexonlyscan": "boolean",
"enableMaterial": "boolean",
"enableMergejoin": "boolean",
"enableNestloop": "boolean",
"enableSeqscan": "boolean",
"enableSort": "boolean",
"enableTidscan": "boolean",
"maxParallelWorkers": "string",
"maxParallelWorkersPerGather": "string",
"timezone": "string",
"effectiveIoConcurrency": "string",
"effectiveCacheSize": "string"
},
"postgresqlConfig_13": {
"recoveryMinApplyDelay": "string",
"sharedBuffers": "string",
"tempBuffers": "string",
"workMem": "string",
"tempFileLimit": "string",
"backendFlushAfter": "string",
"oldSnapshotThreshold": "string",
"maxStandbyStreamingDelay": "string",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "string",
"joinCollapseLimit": "string",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "string",
"logCheckpoints": "boolean",
"logConnections": "boolean",
"logDisconnections": "boolean",
"logDuration": "boolean",
"logErrorVerbosity": "string",
"logLockWaits": "boolean",
"logStatement": "string",
"logTempFiles": "string",
"searchPath": "string",
"rowSecurity": "boolean",
"defaultTransactionIsolation": "string",
"statementTimeout": "string",
"lockTimeout": "string",
"idleInTransactionSessionTimeout": "string",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "string",
"deadlockTimeout": "string",
"maxLocksPerTransaction": "string",
"maxPredLocksPerTransaction": "string",
"arrayNulls": "boolean",
"backslashQuote": "string",
"defaultWithOids": "boolean",
"escapeStringWarning": "boolean",
"loCompatPrivileges": "boolean",
"operatorPrecedenceWarning": "boolean",
"quoteAllIdentifiers": "boolean",
"standardConformingStrings": "boolean",
"synchronizeSeqscans": "boolean",
"transformNullEquals": "boolean",
"exitOnError": "boolean",
"seqPageCost": "number",
"randomPageCost": "number",
"enableBitmapscan": "boolean",
"enableHashagg": "boolean",
"enableHashjoin": "boolean",
"enableIndexscan": "boolean",
"enableIndexonlyscan": "boolean",
"enableMaterial": "boolean",
"enableMergejoin": "boolean",
"enableNestloop": "boolean",
"enableSeqscan": "boolean",
"enableSort": "boolean",
"enableTidscan": "boolean",
"maxParallelWorkers": "string",
"maxParallelWorkersPerGather": "string",
"timezone": "string",
"effectiveIoConcurrency": "string",
"effectiveCacheSize": "string"
},
"postgresqlConfig_13_1c": {
"recoveryMinApplyDelay": "string",
"sharedBuffers": "string",
"tempBuffers": "string",
"workMem": "string",
"tempFileLimit": "string",
"backendFlushAfter": "string",
"oldSnapshotThreshold": "string",
"maxStandbyStreamingDelay": "string",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "string",
"joinCollapseLimit": "string",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "string",
"logCheckpoints": "boolean",
"logConnections": "boolean",
"logDisconnections": "boolean",
"logDuration": "boolean",
"logErrorVerbosity": "string",
"logLockWaits": "boolean",
"logStatement": "string",
"logTempFiles": "string",
"searchPath": "string",
"rowSecurity": "boolean",
"defaultTransactionIsolation": "string",
"statementTimeout": "string",
"lockTimeout": "string",
"idleInTransactionSessionTimeout": "string",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "string",
"deadlockTimeout": "string",
"maxLocksPerTransaction": "string",
"maxPredLocksPerTransaction": "string",
"arrayNulls": "boolean",
"backslashQuote": "string",
"defaultWithOids": "boolean",
"escapeStringWarning": "boolean",
"loCompatPrivileges": "boolean",
"operatorPrecedenceWarning": "boolean",
"quoteAllIdentifiers": "boolean",
"standardConformingStrings": "boolean",
"synchronizeSeqscans": "boolean",
"transformNullEquals": "boolean",
"exitOnError": "boolean",
"seqPageCost": "number",
"randomPageCost": "number",
"enableBitmapscan": "boolean",
"enableHashagg": "boolean",
"enableHashjoin": "boolean",
"enableIndexscan": "boolean",
"enableIndexonlyscan": "boolean",
"enableMaterial": "boolean",
"enableMergejoin": "boolean",
"enableNestloop": "boolean",
"enableSeqscan": "boolean",
"enableSort": "boolean",
"enableTidscan": "boolean",
"maxParallelWorkers": "string",
"maxParallelWorkersPerGather": "string",
"timezone": "string",
"effectiveIoConcurrency": "string",
"effectiveCacheSize": "string"
},
"postgresqlConfig_14": {
"recoveryMinApplyDelay": "string",
"sharedBuffers": "string",
"tempBuffers": "string",
"workMem": "string",
"tempFileLimit": "string",
"backendFlushAfter": "string",
"oldSnapshotThreshold": "string",
"maxStandbyStreamingDelay": "string",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "string",
"joinCollapseLimit": "string",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "string",
"logCheckpoints": "boolean",
"logConnections": "boolean",
"logDisconnections": "boolean",
"logDuration": "boolean",
"logErrorVerbosity": "string",
"logLockWaits": "boolean",
"logStatement": "string",
"logTempFiles": "string",
"searchPath": "string",
"rowSecurity": "boolean",
"defaultTransactionIsolation": "string",
"statementTimeout": "string",
"lockTimeout": "string",
"idleInTransactionSessionTimeout": "string",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "string",
"deadlockTimeout": "string",
"maxLocksPerTransaction": "string",
"maxPredLocksPerTransaction": "string",
"arrayNulls": "boolean",
"backslashQuote": "string",
"defaultWithOids": "boolean",
"escapeStringWarning": "boolean",
"loCompatPrivileges": "boolean",
"quoteAllIdentifiers": "boolean",
"standardConformingStrings": "boolean",
"synchronizeSeqscans": "boolean",
"transformNullEquals": "boolean",
"exitOnError": "boolean",
"seqPageCost": "number",
"randomPageCost": "number",
"enableBitmapscan": "boolean",
"enableHashagg": "boolean",
"enableHashjoin": "boolean",
"enableIndexscan": "boolean",
"enableIndexonlyscan": "boolean",
"enableMaterial": "boolean",
"enableMergejoin": "boolean",
"enableNestloop": "boolean",
"enableSeqscan": "boolean",
"enableSort": "boolean",
"enableTidscan": "boolean",
"maxParallelWorkers": "string",
"maxParallelWorkersPerGather": "string",
"timezone": "string",
"effectiveIoConcurrency": "string",
"effectiveCacheSize": "string"
},
"postgresqlConfig_14_1c": {
"recoveryMinApplyDelay": "string",
"sharedBuffers": "string",
"tempBuffers": "string",
"workMem": "string",
"tempFileLimit": "string",
"backendFlushAfter": "string",
"oldSnapshotThreshold": "string",
"maxStandbyStreamingDelay": "string",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "string",
"joinCollapseLimit": "string",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "string",
"logCheckpoints": "boolean",
"logConnections": "boolean",
"logDisconnections": "boolean",
"logDuration": "boolean",
"logErrorVerbosity": "string",
"logLockWaits": "boolean",
"logStatement": "string",
"logTempFiles": "string",
"searchPath": "string",
"rowSecurity": "boolean",
"defaultTransactionIsolation": "string",
"statementTimeout": "string",
"lockTimeout": "string",
"idleInTransactionSessionTimeout": "string",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "string",
"deadlockTimeout": "string",
"maxLocksPerTransaction": "string",
"maxPredLocksPerTransaction": "string",
"arrayNulls": "boolean",
"backslashQuote": "string",
"defaultWithOids": "boolean",
"escapeStringWarning": "boolean",
"loCompatPrivileges": "boolean",
"quoteAllIdentifiers": "boolean",
"standardConformingStrings": "boolean",
"synchronizeSeqscans": "boolean",
"transformNullEquals": "boolean",
"exitOnError": "boolean",
"seqPageCost": "number",
"randomPageCost": "number",
"enableBitmapscan": "boolean",
"enableHashagg": "boolean",
"enableHashjoin": "boolean",
"enableIndexscan": "boolean",
"enableIndexonlyscan": "boolean",
"enableMaterial": "boolean",
"enableMergejoin": "boolean",
"enableNestloop": "boolean",
"enableSeqscan": "boolean",
"enableSort": "boolean",
"enableTidscan": "boolean",
"maxParallelWorkers": "string",
"maxParallelWorkersPerGather": "string",
"timezone": "string",
"effectiveIoConcurrency": "string",
"effectiveCacheSize": "string"
},
"postgresqlConfig_15": {
"recoveryMinApplyDelay": "string",
"sharedBuffers": "string",
"tempBuffers": "string",
"workMem": "string",
"tempFileLimit": "string",
"backendFlushAfter": "string",
"oldSnapshotThreshold": "string",
"maxStandbyStreamingDelay": "string",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "string",
"joinCollapseLimit": "string",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "string",
"logCheckpoints": "boolean",
"logConnections": "boolean",
"logDisconnections": "boolean",
"logDuration": "boolean",
"logErrorVerbosity": "string",
"logLockWaits": "boolean",
"logStatement": "string",
"logTempFiles": "string",
"searchPath": "string",
"rowSecurity": "boolean",
"defaultTransactionIsolation": "string",
"statementTimeout": "string",
"lockTimeout": "string",
"idleInTransactionSessionTimeout": "string",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "string",
"deadlockTimeout": "string",
"maxLocksPerTransaction": "string",
"maxPredLocksPerTransaction": "string",
"arrayNulls": "boolean",
"backslashQuote": "string",
"defaultWithOids": "boolean",
"escapeStringWarning": "boolean",
"loCompatPrivileges": "boolean",
"quoteAllIdentifiers": "boolean",
"standardConformingStrings": "boolean",
"synchronizeSeqscans": "boolean",
"transformNullEquals": "boolean",
"exitOnError": "boolean",
"seqPageCost": "number",
"randomPageCost": "number",
"enableBitmapscan": "boolean",
"enableHashagg": "boolean",
"enableHashjoin": "boolean",
"enableIndexscan": "boolean",
"enableIndexonlyscan": "boolean",
"enableMaterial": "boolean",
"enableMergejoin": "boolean",
"enableNestloop": "boolean",
"enableSeqscan": "boolean",
"enableSort": "boolean",
"enableTidscan": "boolean",
"maxParallelWorkers": "string",
"maxParallelWorkersPerGather": "string",
"timezone": "string",
"effectiveIoConcurrency": "string",
"effectiveCacheSize": "string"
},
"postgresqlConfig_15_1c": {
"recoveryMinApplyDelay": "string",
"sharedBuffers": "string",
"tempBuffers": "string",
"workMem": "string",
"tempFileLimit": "string",
"backendFlushAfter": "string",
"oldSnapshotThreshold": "string",
"maxStandbyStreamingDelay": "string",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "string",
"joinCollapseLimit": "string",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "string",
"logCheckpoints": "boolean",
"logConnections": "boolean",
"logDisconnections": "boolean",
"logDuration": "boolean",
"logErrorVerbosity": "string",
"logLockWaits": "boolean",
"logStatement": "string",
"logTempFiles": "string",
"searchPath": "string",
"rowSecurity": "boolean",
"defaultTransactionIsolation": "string",
"statementTimeout": "string",
"lockTimeout": "string",
"idleInTransactionSessionTimeout": "string",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "string",
"deadlockTimeout": "string",
"maxLocksPerTransaction": "string",
"maxPredLocksPerTransaction": "string",
"arrayNulls": "boolean",
"backslashQuote": "string",
"defaultWithOids": "boolean",
"escapeStringWarning": "boolean",
"loCompatPrivileges": "boolean",
"quoteAllIdentifiers": "boolean",
"standardConformingStrings": "boolean",
"synchronizeSeqscans": "boolean",
"transformNullEquals": "boolean",
"exitOnError": "boolean",
"seqPageCost": "number",
"randomPageCost": "number",
"enableBitmapscan": "boolean",
"enableHashagg": "boolean",
"enableHashjoin": "boolean",
"enableIndexscan": "boolean",
"enableIndexonlyscan": "boolean",
"enableMaterial": "boolean",
"enableMergejoin": "boolean",
"enableNestloop": "boolean",
"enableSeqscan": "boolean",
"enableSort": "boolean",
"enableTidscan": "boolean",
"maxParallelWorkers": "string",
"maxParallelWorkersPerGather": "string",
"timezone": "string",
"effectiveIoConcurrency": "string",
"effectiveCacheSize": "string"
},
"postgresqlConfig_16": {
"recoveryMinApplyDelay": "string",
"sharedBuffers": "string",
"tempBuffers": "string",
"workMem": "string",
"tempFileLimit": "string",
"backendFlushAfter": "string",
"oldSnapshotThreshold": "string",
"maxStandbyStreamingDelay": "string",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "string",
"joinCollapseLimit": "string",
"debugParallelQuery": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "string",
"logCheckpoints": "boolean",
"logConnections": "boolean",
"logDisconnections": "boolean",
"logDuration": "boolean",
"logErrorVerbosity": "string",
"logLockWaits": "boolean",
"logStatement": "string",
"logTempFiles": "string",
"searchPath": "string",
"rowSecurity": "boolean",
"defaultTransactionIsolation": "string",
"statementTimeout": "string",
"lockTimeout": "string",
"idleInTransactionSessionTimeout": "string",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "string",
"deadlockTimeout": "string",
"maxLocksPerTransaction": "string",
"maxPredLocksPerTransaction": "string",
"arrayNulls": "boolean",
"backslashQuote": "string",
"defaultWithOids": "boolean",
"escapeStringWarning": "boolean",
"loCompatPrivileges": "boolean",
"quoteAllIdentifiers": "boolean",
"standardConformingStrings": "boolean",
"synchronizeSeqscans": "boolean",
"transformNullEquals": "boolean",
"exitOnError": "boolean",
"seqPageCost": "number",
"randomPageCost": "number",
"enableBitmapscan": "boolean",
"enableHashagg": "boolean",
"enableHashjoin": "boolean",
"enableIndexscan": "boolean",
"enableIndexonlyscan": "boolean",
"enableMaterial": "boolean",
"enableMergejoin": "boolean",
"enableNestloop": "boolean",
"enableSeqscan": "boolean",
"enableSort": "boolean",
"enableTidscan": "boolean",
"maxParallelWorkers": "string",
"maxParallelWorkersPerGather": "string",
"timezone": "string",
"effectiveIoConcurrency": "string",
"effectiveCacheSize": "string"
},
"postgresqlConfig_16_1c": {
"recoveryMinApplyDelay": "string",
"sharedBuffers": "string",
"tempBuffers": "string",
"workMem": "string",
"tempFileLimit": "string",
"backendFlushAfter": "string",
"oldSnapshotThreshold": "string",
"maxStandbyStreamingDelay": "string",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "string",
"joinCollapseLimit": "string",
"debugParallelQuery": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "string",
"logCheckpoints": "boolean",
"logConnections": "boolean",
"logDisconnections": "boolean",
"logDuration": "boolean",
"logErrorVerbosity": "string",
"logLockWaits": "boolean",
"logStatement": "string",
"logTempFiles": "string",
"searchPath": "string",
"rowSecurity": "boolean",
"defaultTransactionIsolation": "string",
"statementTimeout": "string",
"lockTimeout": "string",
"idleInTransactionSessionTimeout": "string",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "string",
"deadlockTimeout": "string",
"maxLocksPerTransaction": "string",
"maxPredLocksPerTransaction": "string",
"arrayNulls": "boolean",
"backslashQuote": "string",
"defaultWithOids": "boolean",
"escapeStringWarning": "boolean",
"loCompatPrivileges": "boolean",
"quoteAllIdentifiers": "boolean",
"standardConformingStrings": "boolean",
"synchronizeSeqscans": "boolean",
"transformNullEquals": "boolean",
"exitOnError": "boolean",
"seqPageCost": "number",
"randomPageCost": "number",
"enableBitmapscan": "boolean",
"enableHashagg": "boolean",
"enableHashjoin": "boolean",
"enableIndexscan": "boolean",
"enableIndexonlyscan": "boolean",
"enableMaterial": "boolean",
"enableMergejoin": "boolean",
"enableNestloop": "boolean",
"enableSeqscan": "boolean",
"enableSort": "boolean",
"enableTidscan": "boolean",
"maxParallelWorkers": "string",
"maxParallelWorkersPerGather": "string",
"timezone": "string",
"effectiveIoConcurrency": "string",
"effectiveCacheSize": "string"
},
"postgresqlConfig_17": {
"recoveryMinApplyDelay": "string",
"sharedBuffers": "string",
"tempBuffers": "string",
"workMem": "string",
"tempFileLimit": "string",
"backendFlushAfter": "string",
"maxStandbyStreamingDelay": "string",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "string",
"joinCollapseLimit": "string",
"debugParallelQuery": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "string",
"logCheckpoints": "boolean",
"logConnections": "boolean",
"logDisconnections": "boolean",
"logDuration": "boolean",
"logErrorVerbosity": "string",
"logLockWaits": "boolean",
"logStatement": "string",
"logTempFiles": "string",
"searchPath": "string",
"rowSecurity": "boolean",
"defaultTransactionIsolation": "string",
"statementTimeout": "string",
"lockTimeout": "string",
"idleInTransactionSessionTimeout": "string",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "string",
"deadlockTimeout": "string",
"maxLocksPerTransaction": "string",
"maxPredLocksPerTransaction": "string",
"arrayNulls": "boolean",
"backslashQuote": "string",
"defaultWithOids": "boolean",
"escapeStringWarning": "boolean",
"loCompatPrivileges": "boolean",
"quoteAllIdentifiers": "boolean",
"standardConformingStrings": "boolean",
"synchronizeSeqscans": "boolean",
"transformNullEquals": "boolean",
"exitOnError": "boolean",
"seqPageCost": "number",
"randomPageCost": "number",
"enableBitmapscan": "boolean",
"enableHashagg": "boolean",
"enableHashjoin": "boolean",
"enableIndexscan": "boolean",
"enableIndexonlyscan": "boolean",
"enableMaterial": "boolean",
"enableMergejoin": "boolean",
"enableNestloop": "boolean",
"enableSeqscan": "boolean",
"enableSort": "boolean",
"enableTidscan": "boolean",
"maxParallelWorkers": "string",
"maxParallelWorkersPerGather": "string",
"timezone": "string",
"effectiveIoConcurrency": "string",
"effectiveCacheSize": "string"
},
"postgresqlConfig_17_1c": {
"recoveryMinApplyDelay": "string",
"sharedBuffers": "string",
"tempBuffers": "string",
"workMem": "string",
"tempFileLimit": "string",
"backendFlushAfter": "string",
"maxStandbyStreamingDelay": "string",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "string",
"joinCollapseLimit": "string",
"debugParallelQuery": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "string",
"logCheckpoints": "boolean",
"logConnections": "boolean",
"logDisconnections": "boolean",
"logDuration": "boolean",
"logErrorVerbosity": "string",
"logLockWaits": "boolean",
"logStatement": "string",
"logTempFiles": "string",
"searchPath": "string",
"rowSecurity": "boolean",
"defaultTransactionIsolation": "string",
"statementTimeout": "string",
"lockTimeout": "string",
"idleInTransactionSessionTimeout": "string",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "string",
"deadlockTimeout": "string",
"maxLocksPerTransaction": "string",
"maxPredLocksPerTransaction": "string",
"arrayNulls": "boolean",
"backslashQuote": "string",
"defaultWithOids": "boolean",
"escapeStringWarning": "boolean",
"loCompatPrivileges": "boolean",
"quoteAllIdentifiers": "boolean",
"standardConformingStrings": "boolean",
"synchronizeSeqscans": "boolean",
"transformNullEquals": "boolean",
"exitOnError": "boolean",
"seqPageCost": "number",
"randomPageCost": "number",
"enableBitmapscan": "boolean",
"enableHashagg": "boolean",
"enableHashjoin": "boolean",
"enableIndexscan": "boolean",
"enableIndexonlyscan": "boolean",
"enableMaterial": "boolean",
"enableMergejoin": "boolean",
"enableNestloop": "boolean",
"enableSeqscan": "boolean",
"enableSort": "boolean",
"enableTidscan": "boolean",
"maxParallelWorkers": "string",
"maxParallelWorkersPerGather": "string",
"timezone": "string",
"effectiveIoConcurrency": "string",
"effectiveCacheSize": "string"
},
"postgresqlConfig_18": {
"recoveryMinApplyDelay": "string",
"sharedBuffers": "string",
"tempBuffers": "string",
"workMem": "string",
"tempFileLimit": "string",
"backendFlushAfter": "string",
"maxStandbyStreamingDelay": "string",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "string",
"joinCollapseLimit": "string",
"debugParallelQuery": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "string",
"logCheckpoints": "boolean",
"logConnections": "boolean",
"logDisconnections": "boolean",
"logDuration": "boolean",
"logErrorVerbosity": "string",
"logLockWaits": "boolean",
"logStatement": "string",
"logTempFiles": "string",
"searchPath": "string",
"rowSecurity": "boolean",
"defaultTransactionIsolation": "string",
"statementTimeout": "string",
"lockTimeout": "string",
"idleInTransactionSessionTimeout": "string",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "string",
"deadlockTimeout": "string",
"maxLocksPerTransaction": "string",
"maxPredLocksPerTransaction": "string",
"arrayNulls": "boolean",
"backslashQuote": "string",
"defaultWithOids": "boolean",
"escapeStringWarning": "boolean",
"loCompatPrivileges": "boolean",
"quoteAllIdentifiers": "boolean",
"standardConformingStrings": "boolean",
"synchronizeSeqscans": "boolean",
"transformNullEquals": "boolean",
"exitOnError": "boolean",
"seqPageCost": "number",
"randomPageCost": "number",
"enableBitmapscan": "boolean",
"enableHashagg": "boolean",
"enableHashjoin": "boolean",
"enableIndexscan": "boolean",
"enableIndexonlyscan": "boolean",
"enableMaterial": "boolean",
"enableMergejoin": "boolean",
"enableNestloop": "boolean",
"enableSeqscan": "boolean",
"enableSort": "boolean",
"enableTidscan": "boolean",
"maxParallelWorkers": "string",
"maxParallelWorkersPerGather": "string",
"timezone": "string",
"effectiveIoConcurrency": "string",
"effectiveCacheSize": "string"
},
"postgresqlConfig_18_1c": {
"recoveryMinApplyDelay": "string",
"sharedBuffers": "string",
"tempBuffers": "string",
"workMem": "string",
"tempFileLimit": "string",
"backendFlushAfter": "string",
"maxStandbyStreamingDelay": "string",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "string",
"joinCollapseLimit": "string",
"debugParallelQuery": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "string",
"logCheckpoints": "boolean",
"logConnections": "boolean",
"logDisconnections": "boolean",
"logDuration": "boolean",
"logErrorVerbosity": "string",
"logLockWaits": "boolean",
"logStatement": "string",
"logTempFiles": "string",
"searchPath": "string",
"rowSecurity": "boolean",
"defaultTransactionIsolation": "string",
"statementTimeout": "string",
"lockTimeout": "string",
"idleInTransactionSessionTimeout": "string",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "string",
"deadlockTimeout": "string",
"maxLocksPerTransaction": "string",
"maxPredLocksPerTransaction": "string",
"arrayNulls": "boolean",
"backslashQuote": "string",
"defaultWithOids": "boolean",
"escapeStringWarning": "boolean",
"loCompatPrivileges": "boolean",
"quoteAllIdentifiers": "boolean",
"standardConformingStrings": "boolean",
"synchronizeSeqscans": "boolean",
"transformNullEquals": "boolean",
"exitOnError": "boolean",
"seqPageCost": "number",
"randomPageCost": "number",
"enableBitmapscan": "boolean",
"enableHashagg": "boolean",
"enableHashjoin": "boolean",
"enableIndexscan": "boolean",
"enableIndexonlyscan": "boolean",
"enableMaterial": "boolean",
"enableMergejoin": "boolean",
"enableNestloop": "boolean",
"enableSeqscan": "boolean",
"enableSort": "boolean",
"enableTidscan": "boolean",
"maxParallelWorkers": "string",
"maxParallelWorkersPerGather": "string",
"timezone": "string",
"effectiveIoConcurrency": "string",
"effectiveCacheSize": "string"
}
// end of the list of possible fields
},
"assignPublicIp": "boolean",
"replicaType": "string"
}
],
"nextPageToken": "string"
}
|
Field |
Description |
|
hosts[] |
List of Host resources. |
|
nextPageToken |
string This token allows you to get the next page of results for list requests. If the number of results |
Host
|
Field |
Description |
|
name |
string Name of the PostgreSQL host. The host name is assigned by MDB at creation time, and cannot be changed. The name is unique across all MDB hosts that exist on the platform, as it defines the FQDN of the host. |
|
clusterId |
string ID of the PostgreSQL host. The ID is assigned by MDB at creation time. |
|
zoneId |
string ID of the availability zone where the PostgreSQL host resides. |
|
resources |
Resources allocated to the PostgreSQL host. |
|
role |
enum (Role) Role of the host in the cluster. If the field has default value, it is not returned in the response.
|
|
health |
enum (Health) Aggregated health of the host. If the field has default value, it is not returned in the response.
|
|
services[] |
Services provided by the host. |
|
subnetId |
string ID of the subnet that the host belongs to. |
|
replicationSource |
string Name of the host to be used as the replication source for cascading replication. |
|
priority |
string (int64) Priority of the host as a replica. Higher value means higher priority. The host with the highest priority is the synchronous replica. All others are asynchronous. When a replica becomes the master, its priority is ignored. |
|
config |
Configuration of a PostgreSQL server for the host. |
|
assignPublicIp |
boolean Flag showing public IP assignment status to this host. |
|
replicaType |
enum (ReplicaType)
|
Resources
|
Field |
Description |
|
resourcePresetId |
string ID of the preset for computational resources available to a host (CPU, memory etc.). |
|
diskSize |
string (int64) Volume of the storage available to a host, in bytes. |
|
diskTypeId |
string Type of the storage environment for the host.
|
Service
|
Field |
Description |
|
type |
enum (Type) Type of the service provided by the host. If the field has default value, it is not returned in the response.
|
|
health |
enum (Health) Aggregated health of the service. If the field has default value, it is not returned in the response.
|
HostConfig
|
Field |
Description |
|
postgresqlConfig_9_6 |
Configuration for a host with PostgreSQL 9.6 server deployed. Includes only one of the fields Configuration of a PostgreSQL server for the host. |
|
postgresqlConfig_10_1c |
Configuration for a host with PostgreSQL 10 1C server deployed. Includes only one of the fields Configuration of a PostgreSQL server for the host. |
|
postgresqlConfig_10 |
Configuration for a host with PostgreSQL 10 server deployed. Includes only one of the fields Configuration of a PostgreSQL server for the host. |
|
postgresqlConfig_11 |
Configuration for a host with PostgreSQL 11 server deployed. Includes only one of the fields Configuration of a PostgreSQL server for the host. |
|
postgresqlConfig_11_1c |
Configuration for a host with PostgreSQL 11 1C server deployed. Includes only one of the fields Configuration of a PostgreSQL server for the host. |
|
postgresqlConfig_12 |
Configuration for a host with PostgreSQL 12 server deployed. Includes only one of the fields Configuration of a PostgreSQL server for the host. |
|
postgresqlConfig_12_1c |
Configuration for a host with PostgreSQL 12 1C server deployed. Includes only one of the fields Configuration of a PostgreSQL server for the host. |
|
postgresqlConfig_13 |
Configuration for a host with PostgreSQL 13 server deployed. Includes only one of the fields Configuration of a PostgreSQL server for the host. |
|
postgresqlConfig_13_1c |
Configuration for a host with PostgreSQL 13 1C server deployed. Includes only one of the fields Configuration of a PostgreSQL server for the host. |
|
postgresqlConfig_14 |
Configuration for a host with PostgreSQL 14 server deployed. Includes only one of the fields Configuration of a PostgreSQL server for the host. |
|
postgresqlConfig_14_1c |
Configuration for a host with PostgreSQL 14 1C server deployed. Includes only one of the fields Configuration of a PostgreSQL server for the host. |
|
postgresqlConfig_15 |
Configuration for a host with PostgreSQL 15 server deployed. Includes only one of the fields Configuration of a PostgreSQL server for the host. |
|
postgresqlConfig_15_1c |
Configuration for a host with PostgreSQL 15 1C server deployed. Includes only one of the fields Configuration of a PostgreSQL server for the host. |
|
postgresqlConfig_16 |
Configuration for a host with PostgreSQL 16 server deployed. Includes only one of the fields Configuration of a PostgreSQL server for the host. |
|
postgresqlConfig_16_1c |
Configuration for a host with PostgreSQL 16 1C server deployed. Includes only one of the fields Configuration of a PostgreSQL server for the host. |
|
postgresqlConfig_17 |
Configuration for a host with PostgreSQL 17 server deployed. Includes only one of the fields Configuration of a PostgreSQL server for the host. |
|
postgresqlConfig_17_1c |
Configuration for a host with PostgreSQL 17 1C server deployed. Includes only one of the fields Configuration of a PostgreSQL server for the host. |
|
postgresqlConfig_18 |
Configuration for a host with PostgreSQL 18 server deployed. Includes only one of the fields Configuration of a PostgreSQL server for the host. |
|
postgresqlConfig_18_1c |
Configuration for a host with PostgreSQL 18 1C server deployed. Includes only one of the fields Configuration of a PostgreSQL server for the host. |
PostgresqlHostConfig9_6
Options and structure of PostgresqlHostConfig reflects parameters of a PostgreSQL
configuration file. Detailed description is available in
PostgreSQL documentation
|
Field |
Description |
|
recoveryMinApplyDelay |
string (int64) in milliseconds. |
|
sharedBuffers |
string (int64) in bytes. |
|
tempBuffers |
string (int64) in bytes. |
|
workMem |
string (int64) in bytes. |
|
replacementSortTuples |
string (int64) in bytes. |
|
tempFileLimit |
string (int64) in bytes. |
|
backendFlushAfter |
string (int64) Acceptable values are 0 to 2048, inclusive. |
|
oldSnapshotThreshold |
string (int64) |
|
maxStandbyStreamingDelay |
string (int64) in milliseconds. |
|
constraintExclusion |
enum (ConstraintExclusion)
|
|
cursorTupleFraction |
number (double) |
|
fromCollapseLimit |
string (int64) Acceptable values are 1 to 2147483647, inclusive. |
|
joinCollapseLimit |
string (int64) Acceptable values are 1 to 2147483647, inclusive. |
|
forceParallelMode |
enum (ForceParallelMode)
|
|
clientMinMessages |
enum (LogLevel)
|
|
logMinMessages |
enum (LogLevel)
|
|
logMinErrorStatement |
enum (LogLevel)
|
|
logMinDurationStatement |
string (int64) in milliseconds. |
|
logCheckpoints |
boolean |
|
logConnections |
boolean |
|
logDisconnections |
boolean |
|
logDuration |
boolean |
|
logErrorVerbosity |
enum (LogErrorVerbosity)
|
|
logLockWaits |
boolean |
|
logStatement |
enum (LogStatement)
|
|
logTempFiles |
string (int64) |
|
searchPath |
string |
|
rowSecurity |
boolean |
|
defaultTransactionIsolation |
enum (TransactionIsolation)
|
|
statementTimeout |
string (int64) in milliseconds. |
|
lockTimeout |
string (int64) in milliseconds. |
|
idleInTransactionSessionTimeout |
string (int64) in milliseconds. Acceptable values are 0 to 2147483647, inclusive. |
|
byteaOutput |
enum (ByteaOutput)
|
|
xmlbinary |
enum (XmlBinary)
|
|
xmloption |
enum (XmlOption)
|
|
ginPendingListLimit |
string (int64) in bytes. |
|
deadlockTimeout |
string (int64) in milliseconds. Acceptable values are 1 to 2147483647, inclusive. |
|
maxLocksPerTransaction |
string (int64) |
|
maxPredLocksPerTransaction |
string (int64) |
|
arrayNulls |
boolean |
|
backslashQuote |
enum (BackslashQuote)
|
|
defaultWithOids |
boolean |
|
escapeStringWarning |
boolean |
|
loCompatPrivileges |
boolean |
|
operatorPrecedenceWarning |
boolean |
|
quoteAllIdentifiers |
boolean |
|
standardConformingStrings |
boolean |
|
synchronizeSeqscans |
boolean |
|
transformNullEquals |
boolean |
|
exitOnError |
boolean |
|
seqPageCost |
number (double) |
|
randomPageCost |
number (double) |
|
sqlInheritance |
boolean This option has been removed in PostgreSQL 10. |
|
effectiveIoConcurrency |
string (int64) Acceptable values are 0 to 1000, inclusive. |
|
effectiveCacheSize |
string (int64) Acceptable values are 1048576 to 549755813888, inclusive. |
PostgresqlHostConfig10_1C
Options and structure of PostgresqlHostConfig reflects PostgreSQL configuration file
parameters whose detailed description is available in
PostgreSQL documentation
|
Field |
Description |
|
recoveryMinApplyDelay |
string (int64) in milliseconds. |
|
sharedBuffers |
string (int64) in bytes. |
|
tempBuffers |
string (int64) in bytes. |
|
workMem |
string (int64) in bytes. |
|
replacementSortTuples |
string (int64) in bytes. |
|
tempFileLimit |
string (int64) in bytes. |
|
backendFlushAfter |
string (int64) Acceptable values are 0 to 2048, inclusive. |
|
oldSnapshotThreshold |
string (int64) |
|
maxStandbyStreamingDelay |
string (int64) in milliseconds. |
|
constraintExclusion |
enum (ConstraintExclusion)
|
|
cursorTupleFraction |
number (double) |
|
fromCollapseLimit |
string (int64) Acceptable values are 1 to 2147483647, inclusive. |
|
joinCollapseLimit |
string (int64) Acceptable values are 1 to 2147483647, inclusive. |
|
forceParallelMode |
enum (ForceParallelMode)
|
|
clientMinMessages |
enum (LogLevel)
|
|
logMinMessages |
enum (LogLevel)
|
|
logMinErrorStatement |
enum (LogLevel)
|
|
logMinDurationStatement |
string (int64) in milliseconds. |
|
logCheckpoints |
boolean |
|
logConnections |
boolean |
|
logDisconnections |
boolean |
|
logDuration |
boolean |
|
logErrorVerbosity |
enum (LogErrorVerbosity)
|
|
logLockWaits |
boolean |
|
logStatement |
enum (LogStatement)
|
|
logTempFiles |
string (int64) |
|
searchPath |
string |
|
rowSecurity |
boolean |
|
defaultTransactionIsolation |
enum (TransactionIsolation)
|
|
statementTimeout |
string (int64) in milliseconds. |
|
lockTimeout |
string (int64) in milliseconds. |
|
idleInTransactionSessionTimeout |
string (int64) in milliseconds. Acceptable values are 0 to 2147483647, inclusive. |
|
byteaOutput |
enum (ByteaOutput)
|
|
xmlbinary |
enum (XmlBinary)
|
|
xmloption |
enum (XmlOption)
|
|
ginPendingListLimit |
string (int64) in bytes. |
|
deadlockTimeout |
string (int64) in milliseconds. Acceptable values are 1 to 2147483647, inclusive. |
|
maxLocksPerTransaction |
string (int64) |
|
maxPredLocksPerTransaction |
string (int64) |
|
arrayNulls |
boolean |
|
backslashQuote |
enum (BackslashQuote)
|
|
defaultWithOids |
boolean |
|
escapeStringWarning |
boolean |
|
loCompatPrivileges |
boolean |
|
operatorPrecedenceWarning |
boolean |
|
quoteAllIdentifiers |
boolean |
|
standardConformingStrings |
boolean |
|
synchronizeSeqscans |
boolean |
|
transformNullEquals |
boolean |
|
exitOnError |
boolean |
|
seqPageCost |
number (double) |
|
randomPageCost |
number (double) |
|
enableBitmapscan |
boolean |
|
enableHashagg |
boolean |
|
enableHashjoin |
boolean |
|
enableIndexscan |
boolean |
|
enableIndexonlyscan |
boolean |
|
enableMaterial |
boolean |
|
enableMergejoin |
boolean |
|
enableNestloop |
boolean |
|
enableSeqscan |
boolean |
|
enableSort |
boolean |
|
enableTidscan |
boolean |
|
maxParallelWorkers |
string (int64) Acceptable values are 0 to 1024, inclusive. |
|
maxParallelWorkersPerGather |
string (int64) Acceptable values are 0 to 1024, inclusive. |
|
timezone |
string |
|
effectiveIoConcurrency |
string (int64) Acceptable values are 0 to 1000, inclusive. |
|
effectiveCacheSize |
string (int64) Acceptable values are 1048576 to 549755813888, inclusive. |
PostgresqlHostConfig10
Options and structure of PostgresqlHostConfig reflects PostgreSQL configuration file
parameters whose detailed description is available in
PostgreSQL documentation
|
Field |
Description |
|
recoveryMinApplyDelay |
string (int64) in milliseconds. |
|
sharedBuffers |
string (int64) in bytes. |
|
tempBuffers |
string (int64) in bytes. |
|
workMem |
string (int64) in bytes. |
|
replacementSortTuples |
string (int64) in bytes. |
|
tempFileLimit |
string (int64) in bytes. |
|
backendFlushAfter |
string (int64) Acceptable values are 0 to 2048, inclusive. |
|
oldSnapshotThreshold |
string (int64) |
|
maxStandbyStreamingDelay |
string (int64) in milliseconds. |
|
constraintExclusion |
enum (ConstraintExclusion)
|
|
cursorTupleFraction |
number (double) |
|
fromCollapseLimit |
string (int64) Acceptable values are 1 to 2147483647, inclusive. |
|
joinCollapseLimit |
string (int64) Acceptable values are 1 to 2147483647, inclusive. |
|
forceParallelMode |
enum (ForceParallelMode)
|
|
clientMinMessages |
enum (LogLevel)
|
|
logMinMessages |
enum (LogLevel)
|
|
logMinErrorStatement |
enum (LogLevel)
|
|
logMinDurationStatement |
string (int64) in milliseconds. |
|
logCheckpoints |
boolean |
|
logConnections |
boolean |
|
logDisconnections |
boolean |
|
logDuration |
boolean |
|
logErrorVerbosity |
enum (LogErrorVerbosity)
|
|
logLockWaits |
boolean |
|
logStatement |
enum (LogStatement)
|
|
logTempFiles |
string (int64) |
|
searchPath |
string |
|
rowSecurity |
boolean |
|
defaultTransactionIsolation |
enum (TransactionIsolation)
|
|
statementTimeout |
string (int64) in milliseconds. |
|
lockTimeout |
string (int64) in milliseconds. |
|
idleInTransactionSessionTimeout |
string (int64) in milliseconds. Acceptable values are 0 to 2147483647, inclusive. |
|
byteaOutput |
enum (ByteaOutput)
|
|
xmlbinary |
enum (XmlBinary)
|
|
xmloption |
enum (XmlOption)
|
|
ginPendingListLimit |
string (int64) in bytes. |
|
deadlockTimeout |
string (int64) in milliseconds. Acceptable values are 1 to 2147483647, inclusive. |
|
maxLocksPerTransaction |
string (int64) |
|
maxPredLocksPerTransaction |
string (int64) |
|
arrayNulls |
boolean |
|
backslashQuote |
enum (BackslashQuote)
|
|
defaultWithOids |
boolean |
|
escapeStringWarning |
boolean |
|
loCompatPrivileges |
boolean |
|
operatorPrecedenceWarning |
boolean |
|
quoteAllIdentifiers |
boolean |
|
standardConformingStrings |
boolean |
|
synchronizeSeqscans |
boolean |
|
transformNullEquals |
boolean |
|
exitOnError |
boolean |
|
seqPageCost |
number (double) |
|
randomPageCost |
number (double) |
|
enableBitmapscan |
boolean |
|
enableHashagg |
boolean |
|
enableHashjoin |
boolean |
|
enableIndexscan |
boolean |
|
enableIndexonlyscan |
boolean |
|
enableMaterial |
boolean |
|
enableMergejoin |
boolean |
|
enableNestloop |
boolean |
|
enableSeqscan |
boolean |
|
enableSort |
boolean |
|
enableTidscan |
boolean |
|
maxParallelWorkers |
string (int64) Acceptable values are 0 to 1024, inclusive. |
|
maxParallelWorkersPerGather |
string (int64) Acceptable values are 0 to 1024, inclusive. |
|
timezone |
string |
|
effectiveIoConcurrency |
string (int64) Acceptable values are 0 to 1000, inclusive. |
|
effectiveCacheSize |
string (int64) Acceptable values are 1048576 to 549755813888, inclusive. |
PostgresqlHostConfig11
Options and structure of PostgresqlConfig reflects PostgreSQL configuration file
parameters which detailed description is available in
PostgreSQL documentation
|
Field |
Description |
|
recoveryMinApplyDelay |
string (int64) in milliseconds. |
|
sharedBuffers |
string (int64) in bytes. |
|
tempBuffers |
string (int64) in bytes. |
|
workMem |
string (int64) in bytes. |
|
tempFileLimit |
string (int64) in bytes. |
|
backendFlushAfter |
string (int64) Acceptable values are 0 to 2048, inclusive. |
|
oldSnapshotThreshold |
string (int64) |
|
maxStandbyStreamingDelay |
string (int64) in milliseconds. |
|
constraintExclusion |
enum (ConstraintExclusion)
|
|
cursorTupleFraction |
number (double) |
|
fromCollapseLimit |
string (int64) Acceptable values are 1 to 2147483647, inclusive. |
|
joinCollapseLimit |
string (int64) Acceptable values are 1 to 2147483647, inclusive. |
|
forceParallelMode |
enum (ForceParallelMode)
|
|
clientMinMessages |
enum (LogLevel)
|
|
logMinMessages |
enum (LogLevel)
|
|
logMinErrorStatement |
enum (LogLevel)
|
|
logMinDurationStatement |
string (int64) in milliseconds. |
|
logCheckpoints |
boolean |
|
logConnections |
boolean |
|
logDisconnections |
boolean |
|
logDuration |
boolean |
|
logErrorVerbosity |
enum (LogErrorVerbosity)
|
|
logLockWaits |
boolean |
|
logStatement |
enum (LogStatement)
|
|
logTempFiles |
string (int64) |
|
searchPath |
string |
|
rowSecurity |
boolean |
|
defaultTransactionIsolation |
enum (TransactionIsolation)
|
|
statementTimeout |
string (int64) in milliseconds. |
|
lockTimeout |
string (int64) in milliseconds. |
|
idleInTransactionSessionTimeout |
string (int64) in milliseconds. Acceptable values are 0 to 2147483647, inclusive. |
|
byteaOutput |
enum (ByteaOutput)
|
|
xmlbinary |
enum (XmlBinary)
|
|
xmloption |
enum (XmlOption)
|
|
ginPendingListLimit |
string (int64) in bytes. |
|
deadlockTimeout |
string (int64) in milliseconds. Acceptable values are 1 to 2147483647, inclusive. |
|
maxLocksPerTransaction |
string (int64) |
|
maxPredLocksPerTransaction |
string (int64) |
|
arrayNulls |
boolean |
|
backslashQuote |
enum (BackslashQuote)
|
|
defaultWithOids |
boolean |
|
escapeStringWarning |
boolean |
|
loCompatPrivileges |
boolean |
|
operatorPrecedenceWarning |
boolean |
|
quoteAllIdentifiers |
boolean |
|
standardConformingStrings |
boolean |
|
synchronizeSeqscans |
boolean |
|
transformNullEquals |
boolean |
|
exitOnError |
boolean |
|
seqPageCost |
number (double) |
|
randomPageCost |
number (double) |
|
enableBitmapscan |
boolean |
|
enableHashagg |
boolean |
|
enableHashjoin |
boolean |
|
enableIndexscan |
boolean |
|
enableIndexonlyscan |
boolean |
|
enableMaterial |
boolean |
|
enableMergejoin |
boolean |
|
enableNestloop |
boolean |
|
enableSeqscan |
boolean |
|
enableSort |
boolean |
|
enableTidscan |
boolean |
|
maxParallelWorkers |
string (int64) Acceptable values are 0 to 1024, inclusive. |
|
maxParallelWorkersPerGather |
string (int64) Acceptable values are 0 to 1024, inclusive. |
|
timezone |
string |
|
effectiveIoConcurrency |
string (int64) Acceptable values are 0 to 1000, inclusive. |
|
effectiveCacheSize |
string (int64) Acceptable values are 1048576 to 549755813888, inclusive. |
PostgresqlHostConfig11_1C
Options and structure of PostgresqlConfig reflects PostgreSQL configuration file
parameters which detailed description is available in
PostgreSQL documentation
|
Field |
Description |
|
recoveryMinApplyDelay |
string (int64) in milliseconds. |
|
sharedBuffers |
string (int64) in bytes. |
|
tempBuffers |
string (int64) in bytes. |
|
workMem |
string (int64) in bytes. |
|
tempFileLimit |
string (int64) in bytes. |
|
backendFlushAfter |
string (int64) Acceptable values are 0 to 2048, inclusive. |
|
oldSnapshotThreshold |
string (int64) |
|
maxStandbyStreamingDelay |
string (int64) in milliseconds. |
|
constraintExclusion |
enum (ConstraintExclusion)
|
|
cursorTupleFraction |
number (double) |
|
fromCollapseLimit |
string (int64) Acceptable values are 1 to 2147483647, inclusive. |
|
joinCollapseLimit |
string (int64) Acceptable values are 1 to 2147483647, inclusive. |
|
forceParallelMode |
enum (ForceParallelMode)
|
|
clientMinMessages |
enum (LogLevel)
|
|
logMinMessages |
enum (LogLevel)
|
|
logMinErrorStatement |
enum (LogLevel)
|
|
logMinDurationStatement |
string (int64) in milliseconds. |
|
logCheckpoints |
boolean |
|
logConnections |
boolean |
|
logDisconnections |
boolean |
|
logDuration |
boolean |
|
logErrorVerbosity |
enum (LogErrorVerbosity)
|
|
logLockWaits |
boolean |
|
logStatement |
enum (LogStatement)
|
|
logTempFiles |
string (int64) |
|
searchPath |
string |
|
rowSecurity |
boolean |
|
defaultTransactionIsolation |
enum (TransactionIsolation)
|
|
statementTimeout |
string (int64) in milliseconds. |
|
lockTimeout |
string (int64) in milliseconds. |
|
idleInTransactionSessionTimeout |
string (int64) in milliseconds. Acceptable values are 0 to 2147483647, inclusive. |
|
byteaOutput |
enum (ByteaOutput)
|
|
xmlbinary |
enum (XmlBinary)
|
|
xmloption |
enum (XmlOption)
|
|
ginPendingListLimit |
string (int64) in bytes. |
|
deadlockTimeout |
string (int64) in milliseconds. Acceptable values are 1 to 2147483647, inclusive. |
|
maxLocksPerTransaction |
string (int64) |
|
maxPredLocksPerTransaction |
string (int64) |
|
arrayNulls |
boolean |
|
backslashQuote |
enum (BackslashQuote)
|
|
defaultWithOids |
boolean |
|
escapeStringWarning |
boolean |
|
loCompatPrivileges |
boolean |
|
operatorPrecedenceWarning |
boolean |
|
quoteAllIdentifiers |
boolean |
|
standardConformingStrings |
boolean |
|
synchronizeSeqscans |
boolean |
|
transformNullEquals |
boolean |
|
exitOnError |
boolean |
|
seqPageCost |
number (double) |
|
randomPageCost |
number (double) |
|
enableBitmapscan |
boolean |
|
enableHashagg |
boolean |
|
enableHashjoin |
boolean |
|
enableIndexscan |
boolean |
|
enableIndexonlyscan |
boolean |
|
enableMaterial |
boolean |
|
enableMergejoin |
boolean |
|
enableNestloop |
boolean |
|
enableSeqscan |
boolean |
|
enableSort |
boolean |
|
enableTidscan |
boolean |
|
maxParallelWorkers |
string (int64) Acceptable values are 0 to 1024, inclusive. |
|
maxParallelWorkersPerGather |
string (int64) Acceptable values are 0 to 1024, inclusive. |
|
timezone |
string |
|
effectiveIoConcurrency |
string (int64) Acceptable values are 0 to 1000, inclusive. |
|
effectiveCacheSize |
string (int64) Acceptable values are 1048576 to 549755813888, inclusive. |
PostgresqlHostConfig12
Options and structure of PostgresqlConfig reflects PostgreSQL configuration file
parameters which detailed description is available in
PostgreSQL documentation
|
Field |
Description |
|
recoveryMinApplyDelay |
string (int64) in milliseconds. |
|
sharedBuffers |
string (int64) in bytes. |
|
tempBuffers |
string (int64) in bytes. |
|
workMem |
string (int64) in bytes. |
|
tempFileLimit |
string (int64) in bytes. |
|
backendFlushAfter |
string (int64) Acceptable values are 0 to 2048, inclusive. |
|
oldSnapshotThreshold |
string (int64) |
|
maxStandbyStreamingDelay |
string (int64) in milliseconds. |
|
constraintExclusion |
enum (ConstraintExclusion)
|
|
cursorTupleFraction |
number (double) |
|
fromCollapseLimit |
string (int64) Acceptable values are 1 to 2147483647, inclusive. |
|
joinCollapseLimit |
string (int64) Acceptable values are 1 to 2147483647, inclusive. |
|
forceParallelMode |
enum (ForceParallelMode)
|
|
clientMinMessages |
enum (LogLevel)
|
|
logMinMessages |
enum (LogLevel)
|
|
logMinErrorStatement |
enum (LogLevel)
|
|
logMinDurationStatement |
string (int64) in milliseconds. |
|
logCheckpoints |
boolean |
|
logConnections |
boolean |
|
logDisconnections |
boolean |
|
logDuration |
boolean |
|
logErrorVerbosity |
enum (LogErrorVerbosity)
|
|
logLockWaits |
boolean |
|
logStatement |
enum (LogStatement)
|
|
logTempFiles |
string (int64) |
|
searchPath |
string |
|
rowSecurity |
boolean |
|
defaultTransactionIsolation |
enum (TransactionIsolation)
|
|
statementTimeout |
string (int64) in milliseconds. |
|
lockTimeout |
string (int64) in milliseconds. |
|
idleInTransactionSessionTimeout |
string (int64) in milliseconds. Acceptable values are 0 to 2147483647, inclusive. |
|
byteaOutput |
enum (ByteaOutput)
|
|
xmlbinary |
enum (XmlBinary)
|
|
xmloption |
enum (XmlOption)
|
|
ginPendingListLimit |
string (int64) in bytes. |
|
deadlockTimeout |
string (int64) in milliseconds. Acceptable values are 1 to 2147483647, inclusive. |
|
maxLocksPerTransaction |
string (int64) |
|
maxPredLocksPerTransaction |
string (int64) |
|
arrayNulls |
boolean |
|
backslashQuote |
enum (BackslashQuote)
|
|
defaultWithOids |
boolean |
|
escapeStringWarning |
boolean |
|
loCompatPrivileges |
boolean |
|
operatorPrecedenceWarning |
boolean |
|
quoteAllIdentifiers |
boolean |
|
standardConformingStrings |
boolean |
|
synchronizeSeqscans |
boolean |
|
transformNullEquals |
boolean |
|
exitOnError |
boolean |
|
seqPageCost |
number (double) |
|
randomPageCost |
number (double) |
|
enableBitmapscan |
boolean |
|
enableHashagg |
boolean |
|
enableHashjoin |
boolean |
|
enableIndexscan |
boolean |
|
enableIndexonlyscan |
boolean |
|
enableMaterial |
boolean |
|
enableMergejoin |
boolean |
|
enableNestloop |
boolean |
|
enableSeqscan |
boolean |
|
enableSort |
boolean |
|
enableTidscan |
boolean |
|
maxParallelWorkers |
string (int64) Acceptable values are 0 to 1024, inclusive. |
|
maxParallelWorkersPerGather |
string (int64) Acceptable values are 0 to 1024, inclusive. |
|
timezone |
string |
|
effectiveIoConcurrency |
string (int64) Acceptable values are 0 to 1000, inclusive. |
|
effectiveCacheSize |
string (int64) Acceptable values are 1048576 to 549755813888, inclusive. |
PostgresqlHostConfig12_1C
Options and structure of PostgresqlConfig reflects PostgreSQL configuration file
parameters which detailed description is available in
PostgreSQL documentation
|
Field |
Description |
|
recoveryMinApplyDelay |
string (int64) in milliseconds. |
|
sharedBuffers |
string (int64) in bytes. |
|
tempBuffers |
string (int64) in bytes. |
|
workMem |
string (int64) in bytes. |
|
tempFileLimit |
string (int64) in bytes. |
|
backendFlushAfter |
string (int64) Acceptable values are 0 to 2048, inclusive. |
|
oldSnapshotThreshold |
string (int64) |
|
maxStandbyStreamingDelay |
string (int64) in milliseconds. |
|
constraintExclusion |
enum (ConstraintExclusion)
|
|
cursorTupleFraction |
number (double) |
|
fromCollapseLimit |
string (int64) Acceptable values are 1 to 2147483647, inclusive. |
|
joinCollapseLimit |
string (int64) Acceptable values are 1 to 2147483647, inclusive. |
|
forceParallelMode |
enum (ForceParallelMode)
|
|
clientMinMessages |
enum (LogLevel)
|
|
logMinMessages |
enum (LogLevel)
|
|
logMinErrorStatement |
enum (LogLevel)
|
|
logMinDurationStatement |
string (int64) in milliseconds. |
|
logCheckpoints |
boolean |
|
logConnections |
boolean |
|
logDisconnections |
boolean |
|
logDuration |
boolean |
|
logErrorVerbosity |
enum (LogErrorVerbosity)
|
|
logLockWaits |
boolean |
|
logStatement |
enum (LogStatement)
|
|
logTempFiles |
string (int64) |
|
searchPath |
string |
|
rowSecurity |
boolean |
|
defaultTransactionIsolation |
enum (TransactionIsolation)
|
|
statementTimeout |
string (int64) in milliseconds. |
|
lockTimeout |
string (int64) in milliseconds. |
|
idleInTransactionSessionTimeout |
string (int64) in milliseconds. Acceptable values are 0 to 2147483647, inclusive. |
|
byteaOutput |
enum (ByteaOutput)
|
|
xmlbinary |
enum (XmlBinary)
|
|
xmloption |
enum (XmlOption)
|
|
ginPendingListLimit |
string (int64) in bytes. |
|
deadlockTimeout |
string (int64) in milliseconds. Acceptable values are 1 to 2147483647, inclusive. |
|
maxLocksPerTransaction |
string (int64) |
|
maxPredLocksPerTransaction |
string (int64) |
|
arrayNulls |
boolean |
|
backslashQuote |
enum (BackslashQuote)
|
|
defaultWithOids |
boolean |
|
escapeStringWarning |
boolean |
|
loCompatPrivileges |
boolean |
|
operatorPrecedenceWarning |
boolean |
|
quoteAllIdentifiers |
boolean |
|
standardConformingStrings |
boolean |
|
synchronizeSeqscans |
boolean |
|
transformNullEquals |
boolean |
|
exitOnError |
boolean |
|
seqPageCost |
number (double) |
|
randomPageCost |
number (double) |
|
enableBitmapscan |
boolean |
|
enableHashagg |
boolean |
|
enableHashjoin |
boolean |
|
enableIndexscan |
boolean |
|
enableIndexonlyscan |
boolean |
|
enableMaterial |
boolean |
|
enableMergejoin |
boolean |
|
enableNestloop |
boolean |
|
enableSeqscan |
boolean |
|
enableSort |
boolean |
|
enableTidscan |
boolean |
|
maxParallelWorkers |
string (int64) Acceptable values are 0 to 1024, inclusive. |
|
maxParallelWorkersPerGather |
string (int64) Acceptable values are 0 to 1024, inclusive. |
|
timezone |
string |
|
effectiveIoConcurrency |
string (int64) Acceptable values are 0 to 1000, inclusive. |
|
effectiveCacheSize |
string (int64) Acceptable values are 1048576 to 549755813888, inclusive. |
PostgresqlHostConfig13
Options and structure of PostgresqlConfig reflects PostgreSQL configuration file
parameters which detailed description is available in
PostgreSQL documentation
|
Field |
Description |
|
recoveryMinApplyDelay |
string (int64) in milliseconds. |
|
sharedBuffers |
string (int64) in bytes. |
|
tempBuffers |
string (int64) in bytes. |
|
workMem |
string (int64) in bytes. |
|
tempFileLimit |
string (int64) in bytes. |
|
backendFlushAfter |
string (int64) Acceptable values are 0 to 2048, inclusive. |
|
oldSnapshotThreshold |
string (int64) |
|
maxStandbyStreamingDelay |
string (int64) in milliseconds. |
|
constraintExclusion |
enum (ConstraintExclusion)
|
|
cursorTupleFraction |
number (double) |
|
fromCollapseLimit |
string (int64) Acceptable values are 1 to 2147483647, inclusive. |
|
joinCollapseLimit |
string (int64) Acceptable values are 1 to 2147483647, inclusive. |
|
forceParallelMode |
enum (ForceParallelMode)
|
|
clientMinMessages |
enum (LogLevel)
|
|
logMinMessages |
enum (LogLevel)
|
|
logMinErrorStatement |
enum (LogLevel)
|
|
logMinDurationStatement |
string (int64) in milliseconds. |
|
logCheckpoints |
boolean |
|
logConnections |
boolean |
|
logDisconnections |
boolean |
|
logDuration |
boolean |
|
logErrorVerbosity |
enum (LogErrorVerbosity)
|
|
logLockWaits |
boolean |
|
logStatement |
enum (LogStatement)
|
|
logTempFiles |
string (int64) |
|
searchPath |
string |
|
rowSecurity |
boolean |
|
defaultTransactionIsolation |
enum (TransactionIsolation)
|
|
statementTimeout |
string (int64) in milliseconds. |
|
lockTimeout |
string (int64) in milliseconds. |
|
idleInTransactionSessionTimeout |
string (int64) in milliseconds. Acceptable values are 0 to 2147483647, inclusive. |
|
byteaOutput |
enum (ByteaOutput)
|
|
xmlbinary |
enum (XmlBinary)
|
|
xmloption |
enum (XmlOption)
|
|
ginPendingListLimit |
string (int64) in bytes. |
|
deadlockTimeout |
string (int64) in milliseconds. Acceptable values are 1 to 2147483647, inclusive. |
|
maxLocksPerTransaction |
string (int64) |
|
maxPredLocksPerTransaction |
string (int64) |
|
arrayNulls |
boolean |
|
backslashQuote |
enum (BackslashQuote)
|
|
defaultWithOids |
boolean |
|
escapeStringWarning |
boolean |
|
loCompatPrivileges |
boolean |
|
operatorPrecedenceWarning |
boolean |
|
quoteAllIdentifiers |
boolean |
|
standardConformingStrings |
boolean |
|
synchronizeSeqscans |
boolean |
|
transformNullEquals |
boolean |
|
exitOnError |
boolean |
|
seqPageCost |
number (double) |
|
randomPageCost |
number (double) |
|
enableBitmapscan |
boolean |
|
enableHashagg |
boolean |
|
enableHashjoin |
boolean |
|
enableIndexscan |
boolean |
|
enableIndexonlyscan |
boolean |
|
enableMaterial |
boolean |
|
enableMergejoin |
boolean |
|
enableNestloop |
boolean |
|
enableSeqscan |
boolean |
|
enableSort |
boolean |
|
enableTidscan |
boolean |
|
maxParallelWorkers |
string (int64) Acceptable values are 0 to 1024, inclusive. |
|
maxParallelWorkersPerGather |
string (int64) Acceptable values are 0 to 1024, inclusive. |
|
timezone |
string |
|
effectiveIoConcurrency |
string (int64) Acceptable values are 0 to 1000, inclusive. |
|
effectiveCacheSize |
string (int64) Acceptable values are 1048576 to 549755813888, inclusive. |
PostgresqlHostConfig13_1C
Options and structure of PostgresqlConfig reflects PostgreSQL configuration file
parameters which detailed description is available in
PostgreSQL documentation
|
Field |
Description |
|
recoveryMinApplyDelay |
string (int64) in milliseconds. |
|
sharedBuffers |
string (int64) in bytes. |
|
tempBuffers |
string (int64) in bytes. |
|
workMem |
string (int64) in bytes. |
|
tempFileLimit |
string (int64) in bytes. |
|
backendFlushAfter |
string (int64) Acceptable values are 0 to 2048, inclusive. |
|
oldSnapshotThreshold |
string (int64) |
|
maxStandbyStreamingDelay |
string (int64) in milliseconds. |
|
constraintExclusion |
enum (ConstraintExclusion)
|
|
cursorTupleFraction |
number (double) |
|
fromCollapseLimit |
string (int64) Acceptable values are 1 to 2147483647, inclusive. |
|
joinCollapseLimit |
string (int64) Acceptable values are 1 to 2147483647, inclusive. |
|
forceParallelMode |
enum (ForceParallelMode)
|
|
clientMinMessages |
enum (LogLevel)
|
|
logMinMessages |
enum (LogLevel)
|
|
logMinErrorStatement |
enum (LogLevel)
|
|
logMinDurationStatement |
string (int64) in milliseconds. |
|
logCheckpoints |
boolean |
|
logConnections |
boolean |
|
logDisconnections |
boolean |
|
logDuration |
boolean |
|
logErrorVerbosity |
enum (LogErrorVerbosity)
|
|
logLockWaits |
boolean |
|
logStatement |
enum (LogStatement)
|
|
logTempFiles |
string (int64) |
|
searchPath |
string |
|
rowSecurity |
boolean |
|
defaultTransactionIsolation |
enum (TransactionIsolation)
|
|
statementTimeout |
string (int64) in milliseconds. |
|
lockTimeout |
string (int64) in milliseconds. |
|
idleInTransactionSessionTimeout |
string (int64) in milliseconds. Acceptable values are 0 to 2147483647, inclusive. |
|
byteaOutput |
enum (ByteaOutput)
|
|
xmlbinary |
enum (XmlBinary)
|
|
xmloption |
enum (XmlOption)
|
|
ginPendingListLimit |
string (int64) in bytes. |
|
deadlockTimeout |
string (int64) in milliseconds. Acceptable values are 1 to 2147483647, inclusive. |
|
maxLocksPerTransaction |
string (int64) |
|
maxPredLocksPerTransaction |
string (int64) |
|
arrayNulls |
boolean |
|
backslashQuote |
enum (BackslashQuote)
|
|
defaultWithOids |
boolean |
|
escapeStringWarning |
boolean |
|
loCompatPrivileges |
boolean |
|
operatorPrecedenceWarning |
boolean |
|
quoteAllIdentifiers |
boolean |
|
standardConformingStrings |
boolean |
|
synchronizeSeqscans |
boolean |
|
transformNullEquals |
boolean |
|
exitOnError |
boolean |
|
seqPageCost |
number (double) |
|
randomPageCost |
number (double) |
|
enableBitmapscan |
boolean |
|
enableHashagg |
boolean |
|
enableHashjoin |
boolean |
|
enableIndexscan |
boolean |
|
enableIndexonlyscan |
boolean |
|
enableMaterial |
boolean |
|
enableMergejoin |
boolean |
|
enableNestloop |
boolean |
|
enableSeqscan |
boolean |
|
enableSort |
boolean |
|
enableTidscan |
boolean |
|
maxParallelWorkers |
string (int64) Acceptable values are 0 to 1024, inclusive. |
|
maxParallelWorkersPerGather |
string (int64) Acceptable values are 0 to 1024, inclusive. |
|
timezone |
string |
|
effectiveIoConcurrency |
string (int64) Acceptable values are 0 to 1000, inclusive. |
|
effectiveCacheSize |
string (int64) Acceptable values are 1048576 to 549755813888, inclusive. |
PostgresqlHostConfig14
Options and structure of PostgresqlConfig reflects PostgreSQL configuration file
parameters which detailed description is available in
PostgreSQL documentation
|
Field |
Description |
|
recoveryMinApplyDelay |
string (int64) in milliseconds. |
|
sharedBuffers |
string (int64) in bytes. |
|
tempBuffers |
string (int64) in bytes. |
|
workMem |
string (int64) in bytes. |
|
tempFileLimit |
string (int64) in bytes. |
|
backendFlushAfter |
string (int64) Acceptable values are 0 to 2048, inclusive. |
|
oldSnapshotThreshold |
string (int64) |
|
maxStandbyStreamingDelay |
string (int64) in milliseconds. |
|
constraintExclusion |
enum (ConstraintExclusion)
|
|
cursorTupleFraction |
number (double) |
|
fromCollapseLimit |
string (int64) Acceptable values are 1 to 2147483647, inclusive. |
|
joinCollapseLimit |
string (int64) Acceptable values are 1 to 2147483647, inclusive. |
|
forceParallelMode |
enum (ForceParallelMode)
|
|
clientMinMessages |
enum (LogLevel)
|
|
logMinMessages |
enum (LogLevel)
|
|
logMinErrorStatement |
enum (LogLevel)
|
|
logMinDurationStatement |
string (int64) in milliseconds. |
|
logCheckpoints |
boolean |
|
logConnections |
boolean |
|
logDisconnections |
boolean |
|
logDuration |
boolean |
|
logErrorVerbosity |
enum (LogErrorVerbosity)
|
|
logLockWaits |
boolean |
|
logStatement |
enum (LogStatement)
|
|
logTempFiles |
string (int64) |
|
searchPath |
string |
|
rowSecurity |
boolean |
|
defaultTransactionIsolation |
enum (TransactionIsolation)
|
|
statementTimeout |
string (int64) in milliseconds. |
|
lockTimeout |
string (int64) in milliseconds. |
|
idleInTransactionSessionTimeout |
string (int64) in milliseconds. Acceptable values are 0 to 2147483647, inclusive. |
|
byteaOutput |
enum (ByteaOutput)
|
|
xmlbinary |
enum (XmlBinary)
|
|
xmloption |
enum (XmlOption)
|
|
ginPendingListLimit |
string (int64) in bytes. |
|
deadlockTimeout |
string (int64) in milliseconds. Acceptable values are 1 to 2147483647, inclusive. |
|
maxLocksPerTransaction |
string (int64) |
|
maxPredLocksPerTransaction |
string (int64) |
|
arrayNulls |
boolean |
|
backslashQuote |
enum (BackslashQuote)
|
|
defaultWithOids |
boolean |
|
escapeStringWarning |
boolean |
|
loCompatPrivileges |
boolean |
|
quoteAllIdentifiers |
boolean |
|
standardConformingStrings |
boolean |
|
synchronizeSeqscans |
boolean |
|
transformNullEquals |
boolean |
|
exitOnError |
boolean |
|
seqPageCost |
number (double) |
|
randomPageCost |
number (double) |
|
enableBitmapscan |
boolean |
|
enableHashagg |
boolean |
|
enableHashjoin |
boolean |
|
enableIndexscan |
boolean |
|
enableIndexonlyscan |
boolean |
|
enableMaterial |
boolean |
|
enableMergejoin |
boolean |
|
enableNestloop |
boolean |
|
enableSeqscan |
boolean |
|
enableSort |
boolean |
|
enableTidscan |
boolean |
|
maxParallelWorkers |
string (int64) Acceptable values are 0 to 1024, inclusive. |
|
maxParallelWorkersPerGather |
string (int64) Acceptable values are 0 to 1024, inclusive. |
|
timezone |
string |
|
effectiveIoConcurrency |
string (int64) Acceptable values are 0 to 1000, inclusive. |
|
effectiveCacheSize |
string (int64) Acceptable values are 1048576 to 549755813888, inclusive. |
PostgresqlHostConfig14_1C
Options and structure of PostgresqlConfig reflects PostgreSQL configuration file
parameters which detailed description is available in
PostgreSQL documentation
|
Field |
Description |
|
recoveryMinApplyDelay |
string (int64) in milliseconds. |
|
sharedBuffers |
string (int64) in bytes. |
|
tempBuffers |
string (int64) in bytes. |
|
workMem |
string (int64) in bytes. |
|
tempFileLimit |
string (int64) in bytes. |
|
backendFlushAfter |
string (int64) Acceptable values are 0 to 2048, inclusive. |
|
oldSnapshotThreshold |
string (int64) |
|
maxStandbyStreamingDelay |
string (int64) in milliseconds. |
|
constraintExclusion |
enum (ConstraintExclusion)
|
|
cursorTupleFraction |
number (double) |
|
fromCollapseLimit |
string (int64) Acceptable values are 1 to 2147483647, inclusive. |
|
joinCollapseLimit |
string (int64) Acceptable values are 1 to 2147483647, inclusive. |
|
forceParallelMode |
enum (ForceParallelMode)
|
|
clientMinMessages |
enum (LogLevel)
|
|
logMinMessages |
enum (LogLevel)
|
|
logMinErrorStatement |
enum (LogLevel)
|
|
logMinDurationStatement |
string (int64) in milliseconds. |
|
logCheckpoints |
boolean |
|
logConnections |
boolean |
|
logDisconnections |
boolean |
|
logDuration |
boolean |
|
logErrorVerbosity |
enum (LogErrorVerbosity)
|
|
logLockWaits |
boolean |
|
logStatement |
enum (LogStatement)
|
|
logTempFiles |
string (int64) |
|
searchPath |
string |
|
rowSecurity |
boolean |
|
defaultTransactionIsolation |
enum (TransactionIsolation)
|
|
statementTimeout |
string (int64) in milliseconds. |
|
lockTimeout |
string (int64) in milliseconds. |
|
idleInTransactionSessionTimeout |
string (int64) in milliseconds. Acceptable values are 0 to 2147483647, inclusive. |
|
byteaOutput |
enum (ByteaOutput)
|
|
xmlbinary |
enum (XmlBinary)
|
|
xmloption |
enum (XmlOption)
|
|
ginPendingListLimit |
string (int64) in bytes. |
|
deadlockTimeout |
string (int64) in milliseconds. Acceptable values are 1 to 2147483647, inclusive. |
|
maxLocksPerTransaction |
string (int64) |
|
maxPredLocksPerTransaction |
string (int64) |
|
arrayNulls |
boolean |
|
backslashQuote |
enum (BackslashQuote)
|
|
defaultWithOids |
boolean |
|
escapeStringWarning |
boolean |
|
loCompatPrivileges |
boolean |
|
quoteAllIdentifiers |
boolean |
|
standardConformingStrings |
boolean |
|
synchronizeSeqscans |
boolean |
|
transformNullEquals |
boolean |
|
exitOnError |
boolean |
|
seqPageCost |
number (double) |
|
randomPageCost |
number (double) |
|
enableBitmapscan |
boolean |
|
enableHashagg |
boolean |
|
enableHashjoin |
boolean |
|
enableIndexscan |
boolean |
|
enableIndexonlyscan |
boolean |
|
enableMaterial |
boolean |
|
enableMergejoin |
boolean |
|
enableNestloop |
boolean |
|
enableSeqscan |
boolean |
|
enableSort |
boolean |
|
enableTidscan |
boolean |
|
maxParallelWorkers |
string (int64) Acceptable values are 0 to 1024, inclusive. |
|
maxParallelWorkersPerGather |
string (int64) Acceptable values are 0 to 1024, inclusive. |
|
timezone |
string |
|
effectiveIoConcurrency |
string (int64) Acceptable values are 0 to 1000, inclusive. |
|
effectiveCacheSize |
string (int64) Acceptable values are 1048576 to 549755813888, inclusive. |
PostgresqlHostConfig15
Options and structure of PostgresqlConfig reflects PostgreSQL configuration file
parameters which detailed description is available in
PostgreSQL documentation
|
Field |
Description |
|
recoveryMinApplyDelay |
string (int64) in milliseconds. |
|
sharedBuffers |
string (int64) in bytes. |
|
tempBuffers |
string (int64) in bytes. |
|
workMem |
string (int64) in bytes. |
|
tempFileLimit |
string (int64) in bytes. |
|
backendFlushAfter |
string (int64) Acceptable values are 0 to 2048, inclusive. |
|
oldSnapshotThreshold |
string (int64) |
|
maxStandbyStreamingDelay |
string (int64) in milliseconds. |
|
constraintExclusion |
enum (ConstraintExclusion)
|
|
cursorTupleFraction |
number (double) |
|
fromCollapseLimit |
string (int64) Acceptable values are 1 to 2147483647, inclusive. |
|
joinCollapseLimit |
string (int64) Acceptable values are 1 to 2147483647, inclusive. |
|
forceParallelMode |
enum (ForceParallelMode)
|
|
clientMinMessages |
enum (LogLevel)
|
|
logMinMessages |
enum (LogLevel)
|
|
logMinErrorStatement |
enum (LogLevel)
|
|
logMinDurationStatement |
string (int64) in milliseconds. |
|
logCheckpoints |
boolean |
|
logConnections |
boolean |
|
logDisconnections |
boolean |
|
logDuration |
boolean |
|
logErrorVerbosity |
enum (LogErrorVerbosity)
|
|
logLockWaits |
boolean |
|
logStatement |
enum (LogStatement)
|
|
logTempFiles |
string (int64) |
|
searchPath |
string |
|
rowSecurity |
boolean |
|
defaultTransactionIsolation |
enum (TransactionIsolation)
|
|
statementTimeout |
string (int64) in milliseconds. |
|
lockTimeout |
string (int64) in milliseconds. |
|
idleInTransactionSessionTimeout |
string (int64) in milliseconds. Acceptable values are 0 to 2147483647, inclusive. |
|
byteaOutput |
enum (ByteaOutput)
|
|
xmlbinary |
enum (XmlBinary)
|
|
xmloption |
enum (XmlOption)
|
|
ginPendingListLimit |
string (int64) in bytes. |
|
deadlockTimeout |
string (int64) in milliseconds. Acceptable values are 1 to 2147483647, inclusive. |
|
maxLocksPerTransaction |
string (int64) |
|
maxPredLocksPerTransaction |
string (int64) |
|
arrayNulls |
boolean |
|
backslashQuote |
enum (BackslashQuote)
|
|
defaultWithOids |
boolean |
|
escapeStringWarning |
boolean |
|
loCompatPrivileges |
boolean |
|
quoteAllIdentifiers |
boolean |
|
standardConformingStrings |
boolean |
|
synchronizeSeqscans |
boolean |
|
transformNullEquals |
boolean |
|
exitOnError |
boolean |
|
seqPageCost |
number (double) |
|
randomPageCost |
number (double) |
|
enableBitmapscan |
boolean |
|
enableHashagg |
boolean |
|
enableHashjoin |
boolean |
|
enableIndexscan |
boolean |
|
enableIndexonlyscan |
boolean |
|
enableMaterial |
boolean |
|
enableMergejoin |
boolean |
|
enableNestloop |
boolean |
|
enableSeqscan |
boolean |
|
enableSort |
boolean |
|
enableTidscan |
boolean |
|
maxParallelWorkers |
string (int64) Acceptable values are 0 to 1024, inclusive. |
|
maxParallelWorkersPerGather |
string (int64) Acceptable values are 0 to 1024, inclusive. |
|
timezone |
string |
|
effectiveIoConcurrency |
string (int64) Acceptable values are 0 to 1000, inclusive. |
|
effectiveCacheSize |
string (int64) Acceptable values are 1048576 to 549755813888, inclusive. |
PostgresqlHostConfig15_1C
Options and structure of PostgresqlConfig reflects PostgreSQL configuration file
parameters which detailed description is available in
PostgreSQL documentation
|
Field |
Description |
|
recoveryMinApplyDelay |
string (int64) in milliseconds. |
|
sharedBuffers |
string (int64) in bytes. |
|
tempBuffers |
string (int64) in bytes. |
|
workMem |
string (int64) in bytes. |
|
tempFileLimit |
string (int64) in bytes. |
|
backendFlushAfter |
string (int64) Acceptable values are 0 to 2048, inclusive. |
|
oldSnapshotThreshold |
string (int64) |
|
maxStandbyStreamingDelay |
string (int64) in milliseconds. |
|
constraintExclusion |
enum (ConstraintExclusion)
|
|
cursorTupleFraction |
number (double) |
|
fromCollapseLimit |
string (int64) Acceptable values are 1 to 2147483647, inclusive. |
|
joinCollapseLimit |
string (int64) Acceptable values are 1 to 2147483647, inclusive. |
|
forceParallelMode |
enum (ForceParallelMode)
|
|
clientMinMessages |
enum (LogLevel)
|
|
logMinMessages |
enum (LogLevel)
|
|
logMinErrorStatement |
enum (LogLevel)
|
|
logMinDurationStatement |
string (int64) in milliseconds. |
|
logCheckpoints |
boolean |
|
logConnections |
boolean |
|
logDisconnections |
boolean |
|
logDuration |
boolean |
|
logErrorVerbosity |
enum (LogErrorVerbosity)
|
|
logLockWaits |
boolean |
|
logStatement |
enum (LogStatement)
|
|
logTempFiles |
string (int64) |
|
searchPath |
string |
|
rowSecurity |
boolean |
|
defaultTransactionIsolation |
enum (TransactionIsolation)
|
|
statementTimeout |
string (int64) in milliseconds. |
|
lockTimeout |
string (int64) in milliseconds. |
|
idleInTransactionSessionTimeout |
string (int64) in milliseconds. Acceptable values are 0 to 2147483647, inclusive. |
|
byteaOutput |
enum (ByteaOutput)
|
|
xmlbinary |
enum (XmlBinary)
|
|
xmloption |
enum (XmlOption)
|
|
ginPendingListLimit |
string (int64) in bytes. |
|
deadlockTimeout |
string (int64) in milliseconds. Acceptable values are 1 to 2147483647, inclusive. |
|
maxLocksPerTransaction |
string (int64) |
|
maxPredLocksPerTransaction |
string (int64) |
|
arrayNulls |
boolean |
|
backslashQuote |
enum (BackslashQuote)
|
|
defaultWithOids |
boolean |
|
escapeStringWarning |
boolean |
|
loCompatPrivileges |
boolean |
|
quoteAllIdentifiers |
boolean |
|
standardConformingStrings |
boolean |
|
synchronizeSeqscans |
boolean |
|
transformNullEquals |
boolean |
|
exitOnError |
boolean |
|
seqPageCost |
number (double) |
|
randomPageCost |
number (double) |
|
enableBitmapscan |
boolean |
|
enableHashagg |
boolean |
|
enableHashjoin |
boolean |
|
enableIndexscan |
boolean |
|
enableIndexonlyscan |
boolean |
|
enableMaterial |
boolean |
|
enableMergejoin |
boolean |
|
enableNestloop |
boolean |
|
enableSeqscan |
boolean |
|
enableSort |
boolean |
|
enableTidscan |
boolean |
|
maxParallelWorkers |
string (int64) Acceptable values are 0 to 1024, inclusive. |
|
maxParallelWorkersPerGather |
string (int64) Acceptable values are 0 to 1024, inclusive. |
|
timezone |
string |
|
effectiveIoConcurrency |
string (int64) Acceptable values are 0 to 1000, inclusive. |
|
effectiveCacheSize |
string (int64) Acceptable values are 1048576 to 549755813888, inclusive. |
PostgresqlHostConfig16
Options and structure of PostgresqlConfig reflects PostgreSQL configuration file
parameters which detailed description is available in
PostgreSQL documentation
|
Field |
Description |
|
recoveryMinApplyDelay |
string (int64) in milliseconds. |
|
sharedBuffers |
string (int64) in bytes. |
|
tempBuffers |
string (int64) in bytes. |
|
workMem |
string (int64) in bytes. |
|
tempFileLimit |
string (int64) in bytes. |
|
backendFlushAfter |
string (int64) Acceptable values are 0 to 2048, inclusive. |
|
oldSnapshotThreshold |
string (int64) |
|
maxStandbyStreamingDelay |
string (int64) in milliseconds. |
|
constraintExclusion |
enum (ConstraintExclusion)
|
|
cursorTupleFraction |
number (double) |
|
fromCollapseLimit |
string (int64) Acceptable values are 1 to 2147483647, inclusive. |
|
joinCollapseLimit |
string (int64) Acceptable values are 1 to 2147483647, inclusive. |
|
debugParallelQuery |
enum (DebugParallelQuery)
|
|
clientMinMessages |
enum (LogLevel)
|
|
logMinMessages |
enum (LogLevel)
|
|
logMinErrorStatement |
enum (LogLevel)
|
|
logMinDurationStatement |
string (int64) in milliseconds. |
|
logCheckpoints |
boolean |
|
logConnections |
boolean |
|
logDisconnections |
boolean |
|
logDuration |
boolean |
|
logErrorVerbosity |
enum (LogErrorVerbosity)
|
|
logLockWaits |
boolean |
|
logStatement |
enum (LogStatement)
|
|
logTempFiles |
string (int64) |
|
searchPath |
string |
|
rowSecurity |
boolean |
|
defaultTransactionIsolation |
enum (TransactionIsolation)
|
|
statementTimeout |
string (int64) in milliseconds. |
|
lockTimeout |
string (int64) in milliseconds. |
|
idleInTransactionSessionTimeout |
string (int64) in milliseconds. Acceptable values are 0 to 2147483647, inclusive. |
|
byteaOutput |
enum (ByteaOutput)
|
|
xmlbinary |
enum (XmlBinary)
|
|
xmloption |
enum (XmlOption)
|
|
ginPendingListLimit |
string (int64) in bytes. |
|
deadlockTimeout |
string (int64) in milliseconds. Acceptable values are 1 to 2147483647, inclusive. |
|
maxLocksPerTransaction |
string (int64) |
|
maxPredLocksPerTransaction |
string (int64) |
|
arrayNulls |
boolean |
|
backslashQuote |
enum (BackslashQuote)
|
|
defaultWithOids |
boolean |
|
escapeStringWarning |
boolean |
|
loCompatPrivileges |
boolean |
|
quoteAllIdentifiers |
boolean |
|
standardConformingStrings |
boolean |
|
synchronizeSeqscans |
boolean |
|
transformNullEquals |
boolean |
|
exitOnError |
boolean |
|
seqPageCost |
number (double) |
|
randomPageCost |
number (double) |
|
enableBitmapscan |
boolean |
|
enableHashagg |
boolean |
|
enableHashjoin |
boolean |
|
enableIndexscan |
boolean |
|
enableIndexonlyscan |
boolean |
|
enableMaterial |
boolean |
|
enableMergejoin |
boolean |
|
enableNestloop |
boolean |
|
enableSeqscan |
boolean |
|
enableSort |
boolean |
|
enableTidscan |
boolean |
|
maxParallelWorkers |
string (int64) Acceptable values are 0 to 1024, inclusive. |
|
maxParallelWorkersPerGather |
string (int64) Acceptable values are 0 to 1024, inclusive. |
|
timezone |
string |
|
effectiveIoConcurrency |
string (int64) Acceptable values are 0 to 1000, inclusive. |
|
effectiveCacheSize |
string (int64) Acceptable values are 1048576 to 549755813888, inclusive. |
PostgresqlHostConfig16_1C
Options and structure of PostgresqlConfig reflects PostgreSQL configuration file
parameters which detailed description is available in
PostgreSQL documentation
|
Field |
Description |
|
recoveryMinApplyDelay |
string (int64) in milliseconds. |
|
sharedBuffers |
string (int64) in bytes. |
|
tempBuffers |
string (int64) in bytes. |
|
workMem |
string (int64) in bytes. |
|
tempFileLimit |
string (int64) in bytes. |
|
backendFlushAfter |
string (int64) Acceptable values are 0 to 2048, inclusive. |
|
oldSnapshotThreshold |
string (int64) |
|
maxStandbyStreamingDelay |
string (int64) in milliseconds. |
|
constraintExclusion |
enum (ConstraintExclusion)
|
|
cursorTupleFraction |
number (double) |
|
fromCollapseLimit |
string (int64) Acceptable values are 1 to 2147483647, inclusive. |
|
joinCollapseLimit |
string (int64) Acceptable values are 1 to 2147483647, inclusive. |
|
debugParallelQuery |
enum (DebugParallelQuery)
|
|
clientMinMessages |
enum (LogLevel)
|
|
logMinMessages |
enum (LogLevel)
|
|
logMinErrorStatement |
enum (LogLevel)
|
|
logMinDurationStatement |
string (int64) in milliseconds. |
|
logCheckpoints |
boolean |
|
logConnections |
boolean |
|
logDisconnections |
boolean |
|
logDuration |
boolean |
|
logErrorVerbosity |
enum (LogErrorVerbosity)
|
|
logLockWaits |
boolean |
|
logStatement |
enum (LogStatement)
|
|
logTempFiles |
string (int64) |
|
searchPath |
string |
|
rowSecurity |
boolean |
|
defaultTransactionIsolation |
enum (TransactionIsolation)
|
|
statementTimeout |
string (int64) in milliseconds. |
|
lockTimeout |
string (int64) in milliseconds. |
|
idleInTransactionSessionTimeout |
string (int64) in milliseconds. Acceptable values are 0 to 2147483647, inclusive. |
|
byteaOutput |
enum (ByteaOutput)
|
|
xmlbinary |
enum (XmlBinary)
|
|
xmloption |
enum (XmlOption)
|
|
ginPendingListLimit |
string (int64) in bytes. |
|
deadlockTimeout |
string (int64) in milliseconds. Acceptable values are 1 to 2147483647, inclusive. |
|
maxLocksPerTransaction |
string (int64) |
|
maxPredLocksPerTransaction |
string (int64) |
|
arrayNulls |
boolean |
|
backslashQuote |
enum (BackslashQuote)
|
|
defaultWithOids |
boolean |
|
escapeStringWarning |
boolean |
|
loCompatPrivileges |
boolean |
|
quoteAllIdentifiers |
boolean |
|
standardConformingStrings |
boolean |
|
synchronizeSeqscans |
boolean |
|
transformNullEquals |
boolean |
|
exitOnError |
boolean |
|
seqPageCost |
number (double) |
|
randomPageCost |
number (double) |
|
enableBitmapscan |
boolean |
|
enableHashagg |
boolean |
|
enableHashjoin |
boolean |
|
enableIndexscan |
boolean |
|
enableIndexonlyscan |
boolean |
|
enableMaterial |
boolean |
|
enableMergejoin |
boolean |
|
enableNestloop |
boolean |
|
enableSeqscan |
boolean |
|
enableSort |
boolean |
|
enableTidscan |
boolean |
|
maxParallelWorkers |
string (int64) Acceptable values are 0 to 1024, inclusive. |
|
maxParallelWorkersPerGather |
string (int64) Acceptable values are 0 to 1024, inclusive. |
|
timezone |
string |
|
effectiveIoConcurrency |
string (int64) Acceptable values are 0 to 1000, inclusive. |
|
effectiveCacheSize |
string (int64) Acceptable values are 1048576 to 549755813888, inclusive. |
PostgresqlHostConfig17
Options and structure of PostgresqlConfig reflects PostgreSQL configuration file
parameters which detailed description is available in
PostgreSQL documentation
|
Field |
Description |
|
recoveryMinApplyDelay |
string (int64) in milliseconds. |
|
sharedBuffers |
string (int64) in bytes. |
|
tempBuffers |
string (int64) in bytes. |
|
workMem |
string (int64) in bytes. |
|
tempFileLimit |
string (int64) in bytes. |
|
backendFlushAfter |
string (int64) Acceptable values are 0 to 2048, inclusive. |
|
maxStandbyStreamingDelay |
string (int64) in milliseconds. |
|
constraintExclusion |
enum (ConstraintExclusion)
|
|
cursorTupleFraction |
number (double) |
|
fromCollapseLimit |
string (int64) Acceptable values are 1 to 2147483647, inclusive. |
|
joinCollapseLimit |
string (int64) Acceptable values are 1 to 2147483647, inclusive. |
|
debugParallelQuery |
enum (DebugParallelQuery)
|
|
clientMinMessages |
enum (LogLevel)
|
|
logMinMessages |
enum (LogLevel)
|
|
logMinErrorStatement |
enum (LogLevel)
|
|
logMinDurationStatement |
string (int64) in milliseconds. |
|
logCheckpoints |
boolean |
|
logConnections |
boolean |
|
logDisconnections |
boolean |
|
logDuration |
boolean |
|
logErrorVerbosity |
enum (LogErrorVerbosity)
|
|
logLockWaits |
boolean |
|
logStatement |
enum (LogStatement)
|
|
logTempFiles |
string (int64) |
|
searchPath |
string |
|
rowSecurity |
boolean |
|
defaultTransactionIsolation |
enum (TransactionIsolation)
|
|
statementTimeout |
string (int64) in milliseconds. |
|
lockTimeout |
string (int64) in milliseconds. Acceptable values are 0 to 2147483647, inclusive. |
|
idleInTransactionSessionTimeout |
string (int64) in milliseconds. Acceptable values are 0 to 2147483647, inclusive. |
|
byteaOutput |
enum (ByteaOutput)
|
|
xmlbinary |
enum (XmlBinary)
|
|
xmloption |
enum (XmlOption)
|
|
ginPendingListLimit |
string (int64) in bytes. |
|
deadlockTimeout |
string (int64) in milliseconds. Acceptable values are 1 to 2147483647, inclusive. |
|
maxLocksPerTransaction |
string (int64) |
|
maxPredLocksPerTransaction |
string (int64) |
|
arrayNulls |
boolean |
|
backslashQuote |
enum (BackslashQuote)
|
|
defaultWithOids |
boolean |
|
escapeStringWarning |
boolean |
|
loCompatPrivileges |
boolean |
|
quoteAllIdentifiers |
boolean |
|
standardConformingStrings |
boolean |
|
synchronizeSeqscans |
boolean |
|
transformNullEquals |
boolean |
|
exitOnError |
boolean |
|
seqPageCost |
number (double) |
|
randomPageCost |
number (double) |
|
enableBitmapscan |
boolean |
|
enableHashagg |
boolean |
|
enableHashjoin |
boolean |
|
enableIndexscan |
boolean |
|
enableIndexonlyscan |
boolean |
|
enableMaterial |
boolean |
|
enableMergejoin |
boolean |
|
enableNestloop |
boolean |
|
enableSeqscan |
boolean |
|
enableSort |
boolean |
|
enableTidscan |
boolean |
|
maxParallelWorkers |
string (int64) Acceptable values are 0 to 1024, inclusive. |
|
maxParallelWorkersPerGather |
string (int64) Acceptable values are 0 to 1024, inclusive. |
|
timezone |
string |
|
effectiveIoConcurrency |
string (int64) Acceptable values are 0 to 1000, inclusive. |
|
effectiveCacheSize |
string (int64) Acceptable values are 0 to 549755813888, inclusive. |
PostgresqlHostConfig17_1C
Options and structure of PostgresqlConfig reflects PostgreSQL configuration file
parameters which detailed description is available in
PostgreSQL documentation
|
Field |
Description |
|
recoveryMinApplyDelay |
string (int64) in milliseconds. |
|
sharedBuffers |
string (int64) in bytes. |
|
tempBuffers |
string (int64) in bytes. |
|
workMem |
string (int64) in bytes. |
|
tempFileLimit |
string (int64) in bytes. |
|
backendFlushAfter |
string (int64) Acceptable values are 0 to 2048, inclusive. |
|
maxStandbyStreamingDelay |
string (int64) in milliseconds. |
|
constraintExclusion |
enum (ConstraintExclusion)
|
|
cursorTupleFraction |
number (double) |
|
fromCollapseLimit |
string (int64) Acceptable values are 1 to 2147483647, inclusive. |
|
joinCollapseLimit |
string (int64) Acceptable values are 1 to 2147483647, inclusive. |
|
debugParallelQuery |
enum (DebugParallelQuery)
|
|
clientMinMessages |
enum (LogLevel)
|
|
logMinMessages |
enum (LogLevel)
|
|
logMinErrorStatement |
enum (LogLevel)
|
|
logMinDurationStatement |
string (int64) in milliseconds. |
|
logCheckpoints |
boolean |
|
logConnections |
boolean |
|
logDisconnections |
boolean |
|
logDuration |
boolean |
|
logErrorVerbosity |
enum (LogErrorVerbosity)
|
|
logLockWaits |
boolean |
|
logStatement |
enum (LogStatement)
|
|
logTempFiles |
string (int64) |
|
searchPath |
string |
|
rowSecurity |
boolean |
|
defaultTransactionIsolation |
enum (TransactionIsolation)
|
|
statementTimeout |
string (int64) in milliseconds. |
|
lockTimeout |
string (int64) in milliseconds. Acceptable values are 0 to 2147483647, inclusive. |
|
idleInTransactionSessionTimeout |
string (int64) in milliseconds. Acceptable values are 0 to 2147483647, inclusive. |
|
byteaOutput |
enum (ByteaOutput)
|
|
xmlbinary |
enum (XmlBinary)
|
|
xmloption |
enum (XmlOption)
|
|
ginPendingListLimit |
string (int64) in bytes. |
|
deadlockTimeout |
string (int64) in milliseconds. Acceptable values are 1 to 2147483647, inclusive. |
|
maxLocksPerTransaction |
string (int64) |
|
maxPredLocksPerTransaction |
string (int64) |
|
arrayNulls |
boolean |
|
backslashQuote |
enum (BackslashQuote)
|
|
defaultWithOids |
boolean |
|
escapeStringWarning |
boolean |
|
loCompatPrivileges |
boolean |
|
quoteAllIdentifiers |
boolean |
|
standardConformingStrings |
boolean |
|
synchronizeSeqscans |
boolean |
|
transformNullEquals |
boolean |
|
exitOnError |
boolean |
|
seqPageCost |
number (double) |
|
randomPageCost |
number (double) |
|
enableBitmapscan |
boolean |
|
enableHashagg |
boolean |
|
enableHashjoin |
boolean |
|
enableIndexscan |
boolean |
|
enableIndexonlyscan |
boolean |
|
enableMaterial |
boolean |
|
enableMergejoin |
boolean |
|
enableNestloop |
boolean |
|
enableSeqscan |
boolean |
|
enableSort |
boolean |
|
enableTidscan |
boolean |
|
maxParallelWorkers |
string (int64) Acceptable values are 0 to 1024, inclusive. |
|
maxParallelWorkersPerGather |
string (int64) Acceptable values are 0 to 1024, inclusive. |
|
timezone |
string |
|
effectiveIoConcurrency |
string (int64) Acceptable values are 0 to 1000, inclusive. |
|
effectiveCacheSize |
string (int64) Acceptable values are 0 to 549755813888, inclusive. |
PostgresqlHostConfig18
Options and structure of PostgresqlConfig reflects PostgreSQL configuration file
parameters which detailed description is available in
PostgreSQL documentation
|
Field |
Description |
|
recoveryMinApplyDelay |
string (int64) in milliseconds. |
|
sharedBuffers |
string (int64) in bytes. |
|
tempBuffers |
string (int64) in bytes. |
|
workMem |
string (int64) in bytes. |
|
tempFileLimit |
string (int64) in bytes. |
|
backendFlushAfter |
string (int64) Acceptable values are 0 to 2048, inclusive. |
|
maxStandbyStreamingDelay |
string (int64) in milliseconds. |
|
constraintExclusion |
enum (ConstraintExclusion)
|
|
cursorTupleFraction |
number (double) |
|
fromCollapseLimit |
string (int64) Acceptable values are 1 to 2147483647, inclusive. |
|
joinCollapseLimit |
string (int64) Acceptable values are 1 to 2147483647, inclusive. |
|
debugParallelQuery |
enum (DebugParallelQuery)
|
|
clientMinMessages |
enum (LogLevel)
|
|
logMinMessages |
enum (LogLevel)
|
|
logMinErrorStatement |
enum (LogLevel)
|
|
logMinDurationStatement |
string (int64) in milliseconds. |
|
logCheckpoints |
boolean |
|
logConnections |
boolean |
|
logDisconnections |
boolean |
|
logDuration |
boolean |
|
logErrorVerbosity |
enum (LogErrorVerbosity)
|
|
logLockWaits |
boolean |
|
logStatement |
enum (LogStatement)
|
|
logTempFiles |
string (int64) |
|
searchPath |
string |
|
rowSecurity |
boolean |
|
defaultTransactionIsolation |
enum (TransactionIsolation)
|
|
statementTimeout |
string (int64) in milliseconds. |
|
lockTimeout |
string (int64) in milliseconds. Acceptable values are 0 to 2147483647, inclusive. |
|
idleInTransactionSessionTimeout |
string (int64) in milliseconds. Acceptable values are 0 to 2147483647, inclusive. |
|
byteaOutput |
enum (ByteaOutput)
|
|
xmlbinary |
enum (XmlBinary)
|
|
xmloption |
enum (XmlOption)
|
|
ginPendingListLimit |
string (int64) in bytes. |
|
deadlockTimeout |
string (int64) in milliseconds. Acceptable values are 1 to 2147483647, inclusive. |
|
maxLocksPerTransaction |
string (int64) |
|
maxPredLocksPerTransaction |
string (int64) |
|
arrayNulls |
boolean |
|
backslashQuote |
enum (BackslashQuote)
|
|
defaultWithOids |
boolean |
|
escapeStringWarning |
boolean |
|
loCompatPrivileges |
boolean |
|
quoteAllIdentifiers |
boolean |
|
standardConformingStrings |
boolean |
|
synchronizeSeqscans |
boolean |
|
transformNullEquals |
boolean |
|
exitOnError |
boolean |
|
seqPageCost |
number (double) |
|
randomPageCost |
number (double) |
|
enableBitmapscan |
boolean |
|
enableHashagg |
boolean |
|
enableHashjoin |
boolean |
|
enableIndexscan |
boolean |
|
enableIndexonlyscan |
boolean |
|
enableMaterial |
boolean |
|
enableMergejoin |
boolean |
|
enableNestloop |
boolean |
|
enableSeqscan |
boolean |
|
enableSort |
boolean |
|
enableTidscan |
boolean |
|
maxParallelWorkers |
string (int64) Acceptable values are 0 to 1024, inclusive. |
|
maxParallelWorkersPerGather |
string (int64) Acceptable values are 0 to 1024, inclusive. |
|
timezone |
string |
|
effectiveIoConcurrency |
string (int64) Acceptable values are 0 to 1000, inclusive. |
|
effectiveCacheSize |
string (int64) Acceptable values are 0 to 549755813888, inclusive. |
PostgresqlHostConfig18_1C
Options and structure of PostgresqlConfig reflects PostgreSQL configuration file
parameters which detailed description is available in
PostgreSQL documentation
|
Field |
Description |
|
recoveryMinApplyDelay |
string (int64) in milliseconds. |
|
sharedBuffers |
string (int64) in bytes. |
|
tempBuffers |
string (int64) in bytes. |
|
workMem |
string (int64) in bytes. |
|
tempFileLimit |
string (int64) in bytes. |
|
backendFlushAfter |
string (int64) Acceptable values are 0 to 2048, inclusive. |
|
maxStandbyStreamingDelay |
string (int64) in milliseconds. |
|
constraintExclusion |
enum (ConstraintExclusion)
|
|
cursorTupleFraction |
number (double) |
|
fromCollapseLimit |
string (int64) Acceptable values are 1 to 2147483647, inclusive. |
|
joinCollapseLimit |
string (int64) Acceptable values are 1 to 2147483647, inclusive. |
|
debugParallelQuery |
enum (DebugParallelQuery)
|
|
clientMinMessages |
enum (LogLevel)
|
|
logMinMessages |
enum (LogLevel)
|
|
logMinErrorStatement |
enum (LogLevel)
|
|
logMinDurationStatement |
string (int64) in milliseconds. |
|
logCheckpoints |
boolean |
|
logConnections |
boolean |
|
logDisconnections |
boolean |
|
logDuration |
boolean |
|
logErrorVerbosity |
enum (LogErrorVerbosity)
|
|
logLockWaits |
boolean |
|
logStatement |
enum (LogStatement)
|
|
logTempFiles |
string (int64) |
|
searchPath |
string |
|
rowSecurity |
boolean |
|
defaultTransactionIsolation |
enum (TransactionIsolation)
|
|
statementTimeout |
string (int64) in milliseconds. |
|
lockTimeout |
string (int64) in milliseconds. Acceptable values are 0 to 2147483647, inclusive. |
|
idleInTransactionSessionTimeout |
string (int64) in milliseconds. Acceptable values are 0 to 2147483647, inclusive. |
|
byteaOutput |
enum (ByteaOutput)
|
|
xmlbinary |
enum (XmlBinary)
|
|
xmloption |
enum (XmlOption)
|
|
ginPendingListLimit |
string (int64) in bytes. |
|
deadlockTimeout |
string (int64) in milliseconds. Acceptable values are 1 to 2147483647, inclusive. |
|
maxLocksPerTransaction |
string (int64) |
|
maxPredLocksPerTransaction |
string (int64) |
|
arrayNulls |
boolean |
|
backslashQuote |
enum (BackslashQuote)
|
|
defaultWithOids |
boolean |
|
escapeStringWarning |
boolean |
|
loCompatPrivileges |
boolean |
|
quoteAllIdentifiers |
boolean |
|
standardConformingStrings |
boolean |
|
synchronizeSeqscans |
boolean |
|
transformNullEquals |
boolean |
|
exitOnError |
boolean |
|
seqPageCost |
number (double) |
|
randomPageCost |
number (double) |
|
enableBitmapscan |
boolean |
|
enableHashagg |
boolean |
|
enableHashjoin |
boolean |
|
enableIndexscan |
boolean |
|
enableIndexonlyscan |
boolean |
|
enableMaterial |
boolean |
|
enableMergejoin |
boolean |
|
enableNestloop |
boolean |
|
enableSeqscan |
boolean |
|
enableSort |
boolean |
|
enableTidscan |
boolean |
|
maxParallelWorkers |
string (int64) Acceptable values are 0 to 1024, inclusive. |
|
maxParallelWorkersPerGather |
string (int64) Acceptable values are 0 to 1024, inclusive. |
|
timezone |
string |
|
effectiveIoConcurrency |
string (int64) Acceptable values are 0 to 1000, inclusive. |
|
effectiveCacheSize |
string (int64) Acceptable values are 0 to 549755813888, inclusive. |