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
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. |
Query parameters
Field |
Description |
pageSize |
string (int64) The maximum number of results per page to return. If the number of available |
pageToken |
string Page token. To get the next page of results, set |
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_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"
}
// 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. |
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) |
oldSnapshotThreshold |
string (int64) |
maxStandbyStreamingDelay |
string (int64) in milliseconds. |
constraintExclusion |
enum (ConstraintExclusion)
|
cursorTupleFraction |
number (double) |
fromCollapseLimit |
string (int64) |
joinCollapseLimit |
string (int64) |
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. |
byteaOutput |
enum (ByteaOutput)
|
xmlbinary |
enum (XmlBinary)
|
xmloption |
enum (XmlOption)
|
ginPendingListLimit |
string (int64) in bytes. |
deadlockTimeout |
string (int64) in milliseconds. |
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) |
effectiveCacheSize |
string (int64) |
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) |
oldSnapshotThreshold |
string (int64) |
maxStandbyStreamingDelay |
string (int64) in milliseconds. |
constraintExclusion |
enum (ConstraintExclusion)
|
cursorTupleFraction |
number (double) |
fromCollapseLimit |
string (int64) |
joinCollapseLimit |
string (int64) |
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. |
byteaOutput |
enum (ByteaOutput)
|
xmlbinary |
enum (XmlBinary)
|
xmloption |
enum (XmlOption)
|
ginPendingListLimit |
string (int64) in bytes. |
deadlockTimeout |
string (int64) in milliseconds. |
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) |
maxParallelWorkersPerGather |
string (int64) |
timezone |
string |
effectiveIoConcurrency |
string (int64) |
effectiveCacheSize |
string (int64) |
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) |
oldSnapshotThreshold |
string (int64) |
maxStandbyStreamingDelay |
string (int64) in milliseconds. |
constraintExclusion |
enum (ConstraintExclusion)
|
cursorTupleFraction |
number (double) |
fromCollapseLimit |
string (int64) |
joinCollapseLimit |
string (int64) |
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. |
byteaOutput |
enum (ByteaOutput)
|
xmlbinary |
enum (XmlBinary)
|
xmloption |
enum (XmlOption)
|
ginPendingListLimit |
string (int64) in bytes. |
deadlockTimeout |
string (int64) in milliseconds. |
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) |
maxParallelWorkersPerGather |
string (int64) |
timezone |
string |
effectiveIoConcurrency |
string (int64) |
effectiveCacheSize |
string (int64) |
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) |
oldSnapshotThreshold |
string (int64) |
maxStandbyStreamingDelay |
string (int64) in milliseconds. |
constraintExclusion |
enum (ConstraintExclusion)
|
cursorTupleFraction |
number (double) |
fromCollapseLimit |
string (int64) |
joinCollapseLimit |
string (int64) |
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. |
byteaOutput |
enum (ByteaOutput)
|
xmlbinary |
enum (XmlBinary)
|
xmloption |
enum (XmlOption)
|
ginPendingListLimit |
string (int64) in bytes. |
deadlockTimeout |
string (int64) in milliseconds. |
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) |
maxParallelWorkersPerGather |
string (int64) |
timezone |
string |
effectiveIoConcurrency |
string (int64) |
effectiveCacheSize |
string (int64) |
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) |
oldSnapshotThreshold |
string (int64) |
maxStandbyStreamingDelay |
string (int64) in milliseconds. |
constraintExclusion |
enum (ConstraintExclusion)
|
cursorTupleFraction |
number (double) |
fromCollapseLimit |
string (int64) |
joinCollapseLimit |
string (int64) |
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. |
byteaOutput |
enum (ByteaOutput)
|
xmlbinary |
enum (XmlBinary)
|
xmloption |
enum (XmlOption)
|
ginPendingListLimit |
string (int64) in bytes. |
deadlockTimeout |
string (int64) in milliseconds. |
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) |
maxParallelWorkersPerGather |
string (int64) |
timezone |
string |
effectiveIoConcurrency |
string (int64) |
effectiveCacheSize |
string (int64) |
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) |
oldSnapshotThreshold |
string (int64) |
maxStandbyStreamingDelay |
string (int64) in milliseconds. |
constraintExclusion |
enum (ConstraintExclusion)
|
cursorTupleFraction |
number (double) |
fromCollapseLimit |
string (int64) |
joinCollapseLimit |
string (int64) |
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. |
byteaOutput |
enum (ByteaOutput)
|
xmlbinary |
enum (XmlBinary)
|
xmloption |
enum (XmlOption)
|
ginPendingListLimit |
string (int64) in bytes. |
deadlockTimeout |
string (int64) in milliseconds. |
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) |
maxParallelWorkersPerGather |
string (int64) |
timezone |
string |
effectiveIoConcurrency |
string (int64) |
effectiveCacheSize |
string (int64) |
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) |
oldSnapshotThreshold |
string (int64) |
maxStandbyStreamingDelay |
string (int64) in milliseconds. |
constraintExclusion |
enum (ConstraintExclusion)
|
cursorTupleFraction |
number (double) |
fromCollapseLimit |
string (int64) |
joinCollapseLimit |
string (int64) |
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. |
byteaOutput |
enum (ByteaOutput)
|
xmlbinary |
enum (XmlBinary)
|
xmloption |
enum (XmlOption)
|
ginPendingListLimit |
string (int64) in bytes. |
deadlockTimeout |
string (int64) in milliseconds. |
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) |
maxParallelWorkersPerGather |
string (int64) |
timezone |
string |
effectiveIoConcurrency |
string (int64) |
effectiveCacheSize |
string (int64) |
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) |
oldSnapshotThreshold |
string (int64) |
maxStandbyStreamingDelay |
string (int64) in milliseconds. |
constraintExclusion |
enum (ConstraintExclusion)
|
cursorTupleFraction |
number (double) |
fromCollapseLimit |
string (int64) |
joinCollapseLimit |
string (int64) |
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. |
byteaOutput |
enum (ByteaOutput)
|
xmlbinary |
enum (XmlBinary)
|
xmloption |
enum (XmlOption)
|
ginPendingListLimit |
string (int64) in bytes. |
deadlockTimeout |
string (int64) in milliseconds. |
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) |
maxParallelWorkersPerGather |
string (int64) |
timezone |
string |
effectiveIoConcurrency |
string (int64) |
effectiveCacheSize |
string (int64) |
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) |
oldSnapshotThreshold |
string (int64) |
maxStandbyStreamingDelay |
string (int64) in milliseconds. |
constraintExclusion |
enum (ConstraintExclusion)
|
cursorTupleFraction |
number (double) |
fromCollapseLimit |
string (int64) |
joinCollapseLimit |
string (int64) |
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. |
byteaOutput |
enum (ByteaOutput)
|
xmlbinary |
enum (XmlBinary)
|
xmloption |
enum (XmlOption)
|
ginPendingListLimit |
string (int64) in bytes. |
deadlockTimeout |
string (int64) in milliseconds. |
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) |
maxParallelWorkersPerGather |
string (int64) |
timezone |
string |
effectiveIoConcurrency |
string (int64) |
effectiveCacheSize |
string (int64) |
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) |
oldSnapshotThreshold |
string (int64) |
maxStandbyStreamingDelay |
string (int64) in milliseconds. |
constraintExclusion |
enum (ConstraintExclusion)
|
cursorTupleFraction |
number (double) |
fromCollapseLimit |
string (int64) |
joinCollapseLimit |
string (int64) |
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. |
byteaOutput |
enum (ByteaOutput)
|
xmlbinary |
enum (XmlBinary)
|
xmloption |
enum (XmlOption)
|
ginPendingListLimit |
string (int64) in bytes. |
deadlockTimeout |
string (int64) in milliseconds. |
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) |
maxParallelWorkersPerGather |
string (int64) |
timezone |
string |
effectiveIoConcurrency |
string (int64) |
effectiveCacheSize |
string (int64) |
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) |
oldSnapshotThreshold |
string (int64) |
maxStandbyStreamingDelay |
string (int64) in milliseconds. |
constraintExclusion |
enum (ConstraintExclusion)
|
cursorTupleFraction |
number (double) |
fromCollapseLimit |
string (int64) |
joinCollapseLimit |
string (int64) |
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. |
byteaOutput |
enum (ByteaOutput)
|
xmlbinary |
enum (XmlBinary)
|
xmloption |
enum (XmlOption)
|
ginPendingListLimit |
string (int64) in bytes. |
deadlockTimeout |
string (int64) in milliseconds. |
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) |
maxParallelWorkersPerGather |
string (int64) |
timezone |
string |
effectiveIoConcurrency |
string (int64) |
effectiveCacheSize |
string (int64) |
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) |
oldSnapshotThreshold |
string (int64) |
maxStandbyStreamingDelay |
string (int64) in milliseconds. |
constraintExclusion |
enum (ConstraintExclusion)
|
cursorTupleFraction |
number (double) |
fromCollapseLimit |
string (int64) |
joinCollapseLimit |
string (int64) |
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. |
byteaOutput |
enum (ByteaOutput)
|
xmlbinary |
enum (XmlBinary)
|
xmloption |
enum (XmlOption)
|
ginPendingListLimit |
string (int64) in bytes. |
deadlockTimeout |
string (int64) in milliseconds. |
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) |
maxParallelWorkersPerGather |
string (int64) |
timezone |
string |
effectiveIoConcurrency |
string (int64) |
effectiveCacheSize |
string (int64) |
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) |
oldSnapshotThreshold |
string (int64) |
maxStandbyStreamingDelay |
string (int64) in milliseconds. |
constraintExclusion |
enum (ConstraintExclusion)
|
cursorTupleFraction |
number (double) |
fromCollapseLimit |
string (int64) |
joinCollapseLimit |
string (int64) |
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. |
byteaOutput |
enum (ByteaOutput)
|
xmlbinary |
enum (XmlBinary)
|
xmloption |
enum (XmlOption)
|
ginPendingListLimit |
string (int64) in bytes. |
deadlockTimeout |
string (int64) in milliseconds. |
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) |
maxParallelWorkersPerGather |
string (int64) |
timezone |
string |
effectiveIoConcurrency |
string (int64) |
effectiveCacheSize |
string (int64) |
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) |
oldSnapshotThreshold |
string (int64) |
maxStandbyStreamingDelay |
string (int64) in milliseconds. |
constraintExclusion |
enum (ConstraintExclusion)
|
cursorTupleFraction |
number (double) |
fromCollapseLimit |
string (int64) |
joinCollapseLimit |
string (int64) |
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. |
byteaOutput |
enum (ByteaOutput)
|
xmlbinary |
enum (XmlBinary)
|
xmloption |
enum (XmlOption)
|
ginPendingListLimit |
string (int64) in bytes. |
deadlockTimeout |
string (int64) in milliseconds. |
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) |
maxParallelWorkersPerGather |
string (int64) |
timezone |
string |
effectiveIoConcurrency |
string (int64) |
effectiveCacheSize |
string (int64) |
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) |
oldSnapshotThreshold |
string (int64) |
maxStandbyStreamingDelay |
string (int64) in milliseconds. |
constraintExclusion |
enum (ConstraintExclusion)
|
cursorTupleFraction |
number (double) |
fromCollapseLimit |
string (int64) |
joinCollapseLimit |
string (int64) |
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. |
byteaOutput |
enum (ByteaOutput)
|
xmlbinary |
enum (XmlBinary)
|
xmloption |
enum (XmlOption)
|
ginPendingListLimit |
string (int64) in bytes. |
deadlockTimeout |
string (int64) in milliseconds. |
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) |
maxParallelWorkersPerGather |
string (int64) |
timezone |
string |
effectiveIoConcurrency |
string (int64) |
effectiveCacheSize |
string (int64) |
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) |
maxStandbyStreamingDelay |
string (int64) in milliseconds. |
constraintExclusion |
enum (ConstraintExclusion)
|
cursorTupleFraction |
number (double) |
fromCollapseLimit |
string (int64) |
joinCollapseLimit |
string (int64) |
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. |
byteaOutput |
enum (ByteaOutput)
|
xmlbinary |
enum (XmlBinary)
|
xmloption |
enum (XmlOption)
|
ginPendingListLimit |
string (int64) in bytes. |
deadlockTimeout |
string (int64) in milliseconds. |
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) |
maxParallelWorkersPerGather |
string (int64) |
timezone |
string |
effectiveIoConcurrency |
string (int64) |
effectiveCacheSize |
string (int64) |
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) |
maxStandbyStreamingDelay |
string (int64) in milliseconds. |
constraintExclusion |
enum (ConstraintExclusion)
|
cursorTupleFraction |
number (double) |
fromCollapseLimit |
string (int64) |
joinCollapseLimit |
string (int64) |
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. |
byteaOutput |
enum (ByteaOutput)
|
xmlbinary |
enum (XmlBinary)
|
xmloption |
enum (XmlOption)
|
ginPendingListLimit |
string (int64) in bytes. |
deadlockTimeout |
string (int64) in milliseconds. |
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) |
maxParallelWorkersPerGather |
string (int64) |
timezone |
string |
effectiveIoConcurrency |
string (int64) |
effectiveCacheSize |
string (int64) |