Get
Returns the specified PostgreSQL Cluster resource.
To get the list of available PostgreSQL Cluster resources, make a List request.
- TypeScript
- Python
import { cloudApi, serviceClients, Session } from "@yandex-cloud/nodejs-sdk";
const GetClusterRequest = cloudApi.dataproc.cluster_service.GetClusterRequest;
(async () => {
const authToken = process.env["YC_OAUTH_TOKEN"];
const session = new Session({ oauthToken: authToken });
const client = session.client(serviceClients.ClusterServiceClient);
const result = await client.get(
GetClusterRequest.fromPartial({
clusterId: "clusterId",
})
);
console.log(result);
})();
import os
import grpc
import yandexcloud
from yandex.cloud.dataproc.v1.cluster_service_pb2_grpc import ClusterServiceStub
from yandex.cloud.dataproc.v1.cluster_service_pb2 import GetClusterRequest
token = os.getenv("YC_OAUTH_TOKEN")
sdk = yandexcloud.SDK(token=token)
service = sdk.client(ClusterServiceStub)
response = service.Get(GetClusterRequest(cluster_id="clusterId"))
print(response)
GetClusterRequest
clusterId : string
ID of the PostgreSQL Cluster resource to return. To get the cluster ID use a ClusterService.List request.
Cluster
A PostgreSQL Cluster resource. For more information, see the Concepts section of the documentation.
Environment
ENVIRONMENT_UNSPECIFIEDPRODUCTIONStable environment with a conservative update policy: only hotfixes are applied during regular maintenance.
PRESTABLEEnvironment with more aggressive update policy: new versions are rolled out irrespective of backward compatibility.
Health
HEALTH_UNKNOWNState of the cluster is unknown ([Host.health][3] for every host in the cluster is UNKNOWN).
ALIVECluster is alive and well ([Host.health][4] for every host in the cluster is ALIVE).
DEADCluster is inoperable ([Host.health][5] for every host in the cluster is DEAD).
DEGRADEDCluster is working below capacity ([Host.health][6] for at least one host in the cluster is not ALIVE).
Status
STATUS_UNKNOWNCluster state is unknown.
CREATINGCluster is being created.
RUNNINGCluster is running normally.
ERRORCluster encountered a problem and cannot operate.
UPDATINGCluster is being updated.
STOPPINGCluster is stopping.
STOPPEDCluster stopped.
STARTINGCluster is starting.
id : string
ID of the PostgreSQL cluster. This ID is assigned by MDB at creation time.
folderId : string
ID of the folder that the PostgreSQL cluster belongs to.
createdAt : google.protobuf.Timestamp
Creation timestamp in RFC3339 text format.
name : string
Name of the PostgreSQL cluster. The name is unique within the folder. 1-63 characters long.
description : string
Description of the PostgreSQL cluster. 0-256 characters long.
labels : string
Custom labels for the PostgreSQL cluster as key:value pairs.
Maximum 64 per resource.
environment : Environment
Deployment environment of the PostgreSQL cluster.
monitoring : Monitoring
Description of monitoring systems relevant to the PostgreSQL cluster.
config : ClusterConfig
Configuration of the PostgreSQL cluster.
networkId : string
ID of the network that the cluster belongs to.
health : Health
Aggregated cluster health.
status : Status
Current state of the cluster.
maintenanceWindow : MaintenanceWindow
Maintenance window for the cluster.
plannedOperation : MaintenanceOperation
Planned maintenance operation to be started for the cluster within the nearest maintenance_window.
securityGroupIds : string
User security groups
deletionProtection : bool
Deletion Protection inhibits deletion of the cluster
hostGroupIds : string
Host groups hosting VMs of the cluster.
Monitoring
Monitoring system.
name : string
Name of the monitoring system.
description : string
Description of the monitoring system.
link : string
Link to the monitoring system charts for the PostgreSQL cluster.
ClusterConfig
version : string
Version of PostgreSQL server software.
One of postgresqlConfig
Configuration for PostgreSQL servers in the cluster.
postgresqlConfig_9_6: config.PostgresqlConfigSet9_6Configuration of a PostgreSQL 9.6 server.
postgresqlConfig_10_1c: config.PostgresqlConfigSet10_1CConfiguration of a PostgreSQL 10 1C server.
postgresqlConfig_10: config.PostgresqlConfigSet10Configuration of a PostgreSQL 10 server.
postgresqlConfig_11: config.PostgresqlConfigSet11Configuration of a PostgreSQL 11 server.
postgresqlConfig_11_1c: config.PostgresqlConfigSet11_1CConfiguration of a PostgreSQL 11 1C server.
postgresqlConfig_12: config.PostgresqlConfigSet12Configuration of a PostgreSQL 12 server.
postgresqlConfig_12_1c: config.PostgresqlConfigSet12_1CConfiguration of a PostgreSQL 12 1C server.
postgresqlConfig_13: config.PostgresqlConfigSet13Configuration of a PostgreSQL 13 server.
postgresqlConfig_13_1c: config.PostgresqlConfigSet13_1CConfiguration of a PostgreSQL 13 1C server.
postgresqlConfig_14: config.PostgresqlConfigSet14Configuration of a PostgreSQL 14 server.
postgresqlConfig_14_1c: config.PostgresqlConfigSet14_1CConfiguration of a PostgreSQL 14 1C server.
postgresqlConfig_15: config.PostgresqlConfigSet15Configuration of a PostgreSQL 15 server.
postgresqlConfig_15_1c: config.PostgresqlConfigSet15_1CConfiguration of a PostgreSQL 15 1C server.
postgresqlConfig_16: config.PostgresqlConfigSet16Configuration of a PostgreSQL 16 server.
postgresqlConfig_16_1c: config.PostgresqlConfigSet16_1CConfiguration of a PostgreSQL 16 1C server.
poolerConfig : ConnectionPoolerConfig
Configuration of the connection pooler.
resources : Resources
Resources allocated to PostgreSQL hosts.
autofailover : google.protobuf.BoolValue
Configuration setting which enables/disables autofailover in cluster.
backupWindowStart : google.type.TimeOfDay
Time to start the daily backup, in the UTC timezone.
backupRetainPeriodDays : google.protobuf.Int64Value
Retention policy of automated backups.
access : Access
Access policy to DB
performanceDiagnostics : PerformanceDiagnostics
Configuration of the performance diagnostics service.
diskSizeAutoscaling : DiskSizeAutoscaling
Disk size autoscaling
MaintenanceWindow
A maintenance window settings.
One of policy
The maintenance policy in effect.
anytime: AnytimeMaintenanceWindowMaintenance operation can be scheduled anytime.
weeklyMaintenanceWindow: WeeklyMaintenanceWindowMaintenance operation can be scheduled on a weekly basis.
MaintenanceOperation
A planned maintenance operation.
info : string
Information about this maintenance operation.
delayedUntil : google.protobuf.Timestamp
Time until which this maintenance operation is delayed.
PostgresqlConfigSet9_6
effectiveConfig : PostgresqlConfig9_6
Effective settings for a PostgreSQL 9.6 cluster (a combination of settings defined in user_config and default_config).
userConfig : PostgresqlConfig9_6
User-defined settings for a PostgreSQL 9.6 cluster.
defaultConfig : PostgresqlConfig9_6
Default configuration for a PostgreSQL 9.6 cluster.
PostgresqlConfigSet10_1C
effectiveConfig : PostgresqlConfig10_1C
Effective settings for a PostgreSQL 10 1C cluster (a combination of settings defined in user_config and default_config).
userConfig : PostgresqlConfig10_1C
User-defined settings for a PostgreSQL 10 1C cluster.
defaultConfig : PostgresqlConfig10_1C
Default configuration for a PostgreSQL 10 1C cluster.
PostgresqlConfigSet10
effectiveConfig : PostgresqlConfig10
Effective settings for a PostgreSQL 10 cluster (a combination of settings defined in user_config and default_config).
userConfig : PostgresqlConfig10
User-defined settings for a PostgreSQL 10 cluster.
defaultConfig : PostgresqlConfig10
Default configuration for a PostgreSQL 10 cluster.
PostgresqlConfigSet11
effectiveConfig : PostgresqlConfig11
Effective settings for a PostgreSQL 11 cluster (a combination of settings defined in user_config and default_config).
userConfig : PostgresqlConfig11
User-defined settings for a PostgreSQL 11 cluster.
defaultConfig : PostgresqlConfig11
Default configuration for a PostgreSQL 11 cluster.
PostgresqlConfigSet11_1C
effectiveConfig : PostgresqlConfig11_1C
Effective settings for a PostgreSQL 11 1C cluster (a combination of settings defined in user_config and default_config).
userConfig : PostgresqlConfig11_1C
User-defined settings for a PostgreSQL 11 1C cluster.
defaultConfig : PostgresqlConfig11_1C
Default configuration for a PostgreSQL 11 1C cluster.
PostgresqlConfigSet12
effectiveConfig : PostgresqlConfig12
Effective settings for a PostgreSQL 12 cluster (a combination of settings defined in user_config and default_config).
userConfig : PostgresqlConfig12
User-defined settings for a PostgreSQL 12 cluster.
defaultConfig : PostgresqlConfig12
Default configuration for a PostgreSQL 12 cluster.
PostgresqlConfigSet12_1C
effectiveConfig : PostgresqlConfig12_1C
Effective settings for a PostgreSQL 12 1C cluster (a combination of settings defined in user_config and default_config).
userConfig : PostgresqlConfig12_1C
User-defined settings for a PostgreSQL 12 1C cluster.
defaultConfig : PostgresqlConfig12_1C
Default configuration for a PostgreSQL 12 1C cluster.
PostgresqlConfigSet13
effectiveConfig : PostgresqlConfig13
Effective settings for a PostgreSQL 13 cluster (a combination of settings defined in user_config and default_config).
userConfig : PostgresqlConfig13
User-defined settings for a PostgreSQL 13 cluster.
defaultConfig : PostgresqlConfig13
Default configuration for a PostgreSQL 13 cluster.
PostgresqlConfigSet13_1C
effectiveConfig : PostgresqlConfig13_1C
Effective settings for a PostgreSQL 13 1C cluster (a combination of settings defined in user_config and default_config).
userConfig : PostgresqlConfig13_1C
User-defined settings for a PostgreSQL 13 1C cluster.
defaultConfig : PostgresqlConfig13_1C
Default configuration for a PostgreSQL 13 1C cluster.
PostgresqlConfigSet14
effectiveConfig : PostgresqlConfig14
Effective settings for a PostgreSQL 14 cluster (a combination of settings defined in user_config and default_config).
userConfig : PostgresqlConfig14
User-defined settings for a PostgreSQL 14 cluster.
defaultConfig : PostgresqlConfig14
Default configuration for a PostgreSQL 14 cluster.
PostgresqlConfigSet14_1C
effectiveConfig : PostgresqlConfig14_1C
Effective settings for a PostgreSQL 14 1C cluster (a combination of settings defined in user_config and default_config).
userConfig : PostgresqlConfig14_1C
User-defined settings for a PostgreSQL 14 1C cluster.
defaultConfig : PostgresqlConfig14_1C
Default configuration for a PostgreSQL 14 1C cluster.
PostgresqlConfigSet15
effectiveConfig : PostgresqlConfig15
Effective settings for a PostgreSQL 15 cluster (a combination of settings defined in user_config and default_config).
userConfig : PostgresqlConfig15
User-defined settings for a PostgreSQL 15 cluster.
defaultConfig : PostgresqlConfig15
Default configuration for a PostgreSQL 15 cluster.
PostgresqlConfigSet15_1C
effectiveConfig : PostgresqlConfig15_1C
Effective settings for a PostgreSQL 15 1C cluster (a combination of settings defined in user_config and default_config).
userConfig : PostgresqlConfig15_1C
User-defined settings for a PostgreSQL 15 1C cluster.
defaultConfig : PostgresqlConfig15_1C
Default configuration for a PostgreSQL 15 1C cluster.
PostgresqlConfigSet16
effectiveConfig : PostgresqlConfig16
Effective settings for a PostgreSQL 16 cluster (a combination of settings defined in user_config and default_config).
userConfig : PostgresqlConfig16
User-defined settings for a PostgreSQL 16 cluster.
defaultConfig : PostgresqlConfig16
Default configuration for a PostgreSQL 16 cluster.
PostgresqlConfigSet16_1C
effectiveConfig : PostgresqlConfig16_1C
Effective settings for a PostgreSQL 16 1C cluster (a combination of settings defined in user_config and default_config).
userConfig : PostgresqlConfig16_1C
User-defined settings for a PostgreSQL 16 1C cluster.
defaultConfig : PostgresqlConfig16_1C
Default configuration for a PostgreSQL 16 1C cluster.
ConnectionPoolerConfig
PoolingMode
POOLING_MODE_UNSPECIFIEDSESSIONSession pooling mode.
TRANSACTIONTransaction pooling mode.
STATEMENTStatement pooling mode.
poolingMode : PoolingMode
Mode that the connection pooler is working in. See descriptions of all modes in the documentation for PgBouncer.
poolDiscard : google.protobuf.BoolValue
Setting server_reset_query_always parameter in PgBouncer.
Resources
resourcePresetId : string
ID of the preset for computational resources available to a host (CPU, memory etc.). All available presets are listed in the documentation.
diskSize : int64
Volume of the storage available to a host, in bytes.
diskTypeId : string
Type of the storage environment for the host. Possible values:
- network-hdd - network HDD drive,
- network-ssd - network SSD drive,
- local-ssd - local SSD storage.
Access
dataLens : bool
Allow access for DataLens
webSql : bool
Allow SQL queries to the cluster databases from the management console.
See SQL queries in the management console for more details.
serverless : bool
Allow access for Serverless
dataTransfer : bool
Allow access for DataTransfer.
yandexQuery : bool
Allow access for YandexQuery.
PerformanceDiagnostics
enabled : bool
Configuration setting which enables/disables performance diagnostics service in cluster.
sessionsSamplingInterval : int64
Interval (in seconds) for pg_stat_activity sampling
statementsSamplingInterval : int64
Interval (in seconds) for pg_stat_statements sampling
DiskSizeAutoscaling
plannedUsageThreshold : int64
Threshold of storage usage (in percent) that triggers automatic scaling of the storage during the maintenance window. Zero value means disabled threshold.
emergencyUsageThreshold : int64
Threshold of storage usage (in percent) that triggers immediate automatic scaling of the storage. Zero value means disabled threshold.
diskSizeLimit : int64
New storage size (in bytes) that is set when one of the thresholds is achieved.
AnytimeMaintenanceWindow
WeeklyMaintenanceWindow
Weelky maintenance window settings.
WeekDay
WEEK_DAY_UNSPECIFIEDMONTUEWEDTHUFRISATSUN
day : WeekDay
Day of the week (in DDD format).
hour : int64
Hour of the day in UTC (in HH format).
PostgresqlConfig9_6
Options and structure of PostgresqlConfig reflects PostgreSQL configuration file
parameters whose detailed description is available in
PostgreSQL documentation.
WalLevel
WAL_LEVEL_UNSPECIFIEDWAL_LEVEL_REPLICAWAL_LEVEL_LOGICAL
SynchronousCommit
SYNCHRONOUS_COMMIT_UNSPECIFIEDSYNCHRONOUS_COMMIT_ONSYNCHRONOUS_COMMIT_OFFSYNCHRONOUS_COMMIT_LOCALSYNCHRONOUS_COMMIT_REMOTE_WRITESYNCHRONOUS_COMMIT_REMOTE_APPLY
ConstraintExclusion
CONSTRAINT_EXCLUSION_UNSPECIFIEDCONSTRAINT_EXCLUSION_ONCONSTRAINT_EXCLUSION_OFFCONSTRAINT_EXCLUSION_PARTITION
ForceParallelMode
FORCE_PARALLEL_MODE_UNSPECIFIEDFORCE_PARALLEL_MODE_ONFORCE_PARALLEL_MODE_OFFFORCE_PARALLEL_MODE_REGRESS
LogLevel
LOG_LEVEL_UNSPECIFIEDLOG_LEVEL_DEBUG5LOG_LEVEL_DEBUG4LOG_LEVEL_DEBUG3LOG_LEVEL_DEBUG2LOG_LEVEL_DEBUG1LOG_LEVEL_LOGLOG_LEVEL_NOTICELOG_LEVEL_WARNINGLOG_LEVEL_ERRORLOG_LEVEL_FATALLOG_LEVEL_PANIC
LogErrorVerbosity
LOG_ERROR_VERBOSITY_UNSPECIFIEDLOG_ERROR_VERBOSITY_TERSELOG_ERROR_VERBOSITY_DEFAULTLOG_ERROR_VERBOSITY_VERBOSE
LogStatement
LOG_STATEMENT_UNSPECIFIEDLOG_STATEMENT_NONELOG_STATEMENT_DDLLOG_STATEMENT_MODLOG_STATEMENT_ALL
TransactionIsolation
TRANSACTION_ISOLATION_UNSPECIFIEDTRANSACTION_ISOLATION_READ_UNCOMMITTEDTRANSACTION_ISOLATION_READ_COMMITTEDTRANSACTION_ISOLATION_REPEATABLE_READTRANSACTION_ISOLATION_SERIALIZABLE
ByteaOutput
BYTEA_OUTPUT_UNSPECIFIEDBYTEA_OUTPUT_HEXBYTEA_OUTPUT_ESCAPED
XmlBinary
XML_BINARY_UNSPECIFIEDXML_BINARY_BASE64XML_BINARY_HEX
XmlOption
XML_OPTION_UNSPECIFIEDXML_OPTION_DOCUMENTXML_OPTION_CONTENT
BackslashQuote
BACKSLASH_QUOTE_UNSPECIFIEDBACKSLASH_QUOTEBACKSLASH_QUOTE_ONBACKSLASH_QUOTE_OFFBACKSLASH_QUOTE_SAFE_ENCODING
maxConnections : google.protobuf.Int64Value
sharedBuffers : google.protobuf.Int64Value
in bytes.
tempBuffers : google.protobuf.Int64Value
in bytes.
maxPreparedTransactions : google.protobuf.Int64Value
workMem : google.protobuf.Int64Value
in bytes.
maintenanceWorkMem : google.protobuf.Int64Value
in bytes.
replacementSortTuples : google.protobuf.Int64Value
autovacuumWorkMem : google.protobuf.Int64Value
in bytes.
tempFileLimit : google.protobuf.Int64Value
in bytes.
vacuumCostDelay : google.protobuf.Int64Value
in milliseconds.
vacuumCostPageHit : google.protobuf.Int64Value
vacuumCostPageMiss : google.protobuf.Int64Value
vacuumCostPageDirty : google.protobuf.Int64Value
vacuumCostLimit : google.protobuf.Int64Value
bgwriterDelay : google.protobuf.Int64Value
in milliseconds.
bgwriterLruMaxpages : google.protobuf.Int64Value
bgwriterLruMultiplier : google.protobuf.DoubleValue
bgwriterFlushAfter : google.protobuf.Int64Value
in bytes
backendFlushAfter : google.protobuf.Int64Value
in bytes
oldSnapshotThreshold : google.protobuf.Int64Value
walLevel : WalLevel
synchronousCommit : SynchronousCommit
checkpointTimeout : google.protobuf.Int64Value
in milliseconds.
checkpointCompletionTarget : google.protobuf.DoubleValue
Acceptable values are 0.0 to 1.0, inclusive.
checkpointFlushAfter : google.protobuf.Int64Value
in bytes
maxWalSize : google.protobuf.Int64Value
in bytes.
minWalSize : google.protobuf.Int64Value
in bytes.
maxStandbyStreamingDelay : google.protobuf.Int64Value
in milliseconds.
defaultStatisticsTarget : google.protobuf.Int64Value
constraintExclusion : ConstraintExclusion
cursorTupleFraction : google.protobuf.DoubleValue
fromCollapseLimit : google.protobuf.Int64Value
joinCollapseLimit : google.protobuf.Int64Value
forceParallelMode : ForceParallelMode
clientMinMessages : LogLevel
logMinMessages : LogLevel
logMinErrorStatement : LogLevel
logMinDurationStatement : google.protobuf.Int64Value
in milliseconds.
logCheckpoints : google.protobuf.BoolValue
logConnections : google.protobuf.BoolValue
logDisconnections : google.protobuf.BoolValue
logDuration : google.protobuf.BoolValue
logErrorVerbosity : LogErrorVerbosity
logLockWaits : google.protobuf.BoolValue
logStatement : LogStatement
logTempFiles : google.protobuf.Int64Value
searchPath : string
rowSecurity : google.protobuf.BoolValue
defaultTransactionIsolation : TransactionIsolation
statementTimeout : google.protobuf.Int64Value
in milliseconds.
lockTimeout : google.protobuf.Int64Value
in milliseconds.
idleInTransactionSessionTimeout : google.protobuf.Int64Value
in milliseconds.
byteaOutput : ByteaOutput
xmlbinary : XmlBinary
xmloption : XmlOption
ginPendingListLimit : google.protobuf.Int64Value
in bytes.
deadlockTimeout : google.protobuf.Int64Value
in milliseconds.
maxLocksPerTransaction : google.protobuf.Int64Value
maxPredLocksPerTransaction : google.protobuf.Int64Value
arrayNulls : google.protobuf.BoolValue
backslashQuote : BackslashQuote
defaultWithOids : google.protobuf.BoolValue
escapeStringWarning : google.protobuf.BoolValue
loCompatPrivileges : google.protobuf.BoolValue
operatorPrecedenceWarning : google.protobuf.BoolValue
quoteAllIdentifiers : google.protobuf.BoolValue
standardConformingStrings : google.protobuf.BoolValue
synchronizeSeqscans : google.protobuf.BoolValue
transformNullEquals : google.protobuf.BoolValue
exitOnError : google.protobuf.BoolValue
seqPageCost : google.protobuf.DoubleValue
randomPageCost : google.protobuf.DoubleValue
sqlInheritance : google.protobuf.BoolValue
This option has been removed in PostgreSQL 10.
autovacuumMaxWorkers : google.protobuf.Int64Value
autovacuumVacuumCostDelay : google.protobuf.Int64Value
autovacuumVacuumCostLimit : google.protobuf.Int64Value
autovacuumNaptime : google.protobuf.Int64Value
in milliseconds.
archiveTimeout : google.protobuf.Int64Value
in milliseconds.
trackActivityQuerySize : google.protobuf.Int64Value
effectiveIoConcurrency : google.protobuf.Int64Value
effectiveCacheSize : google.protobuf.Int64Value
PostgresqlConfig10_1C
Options and structure of PostgresqlConfig reflects PostgreSQL configuration file
parameters whose detailed description is available in
PostgreSQL documentation.
WalLevel
WAL_LEVEL_UNSPECIFIEDWAL_LEVEL_REPLICAWAL_LEVEL_LOGICAL
SynchronousCommit
SYNCHRONOUS_COMMIT_UNSPECIFIEDSYNCHRONOUS_COMMIT_ONSYNCHRONOUS_COMMIT_OFFSYNCHRONOUS_COMMIT_LOCALSYNCHRONOUS_COMMIT_REMOTE_WRITESYNCHRONOUS_COMMIT_REMOTE_APPLY
ConstraintExclusion
CONSTRAINT_EXCLUSION_UNSPECIFIEDCONSTRAINT_EXCLUSION_ONCONSTRAINT_EXCLUSION_OFFCONSTRAINT_EXCLUSION_PARTITION
ForceParallelMode
FORCE_PARALLEL_MODE_UNSPECIFIEDFORCE_PARALLEL_MODE_ONFORCE_PARALLEL_MODE_OFFFORCE_PARALLEL_MODE_REGRESS
LogErrorVerbosity
LOG_ERROR_VERBOSITY_UNSPECIFIEDLOG_ERROR_VERBOSITY_TERSELOG_ERROR_VERBOSITY_DEFAULTLOG_ERROR_VERBOSITY_VERBOSE
LogLevel
LOG_LEVEL_UNSPECIFIEDLOG_LEVEL_DEBUG5LOG_LEVEL_DEBUG4LOG_LEVEL_DEBUG3LOG_LEVEL_DEBUG2LOG_LEVEL_DEBUG1LOG_LEVEL_LOGLOG_LEVEL_NOTICELOG_LEVEL_WARNINGLOG_LEVEL_ERRORLOG_LEVEL_FATALLOG_LEVEL_PANIC
LogStatement
LOG_STATEMENT_UNSPECIFIEDLOG_STATEMENT_NONELOG_STATEMENT_DDLLOG_STATEMENT_MODLOG_STATEMENT_ALL
PasswordEncryption
PASSWORD_ENCRYPTION_UNSPECIFIEDPASSWORD_ENCRYPTION_MD5PASSWORD_ENCRYPTION_SCRAM_SHA_256
TransactionIsolation
TRANSACTION_ISOLATION_UNSPECIFIEDTRANSACTION_ISOLATION_READ_UNCOMMITTEDTRANSACTION_ISOLATION_READ_COMMITTEDTRANSACTION_ISOLATION_REPEATABLE_READTRANSACTION_ISOLATION_SERIALIZABLE
ByteaOutput
BYTEA_OUTPUT_UNSPECIFIEDBYTEA_OUTPUT_HEXBYTEA_OUTPUT_ESCAPED
XmlBinary
XML_BINARY_UNSPECIFIEDXML_BINARY_BASE64XML_BINARY_HEX
XmlOption
XML_OPTION_UNSPECIFIEDXML_OPTION_DOCUMENTXML_OPTION_CONTENT
BackslashQuote
BACKSLASH_QUOTE_UNSPECIFIEDBACKSLASH_QUOTEBACKSLASH_QUOTE_ONBACKSLASH_QUOTE_OFFBACKSLASH_QUOTE_SAFE_ENCODING
PgHintPlanDebugPrint
PG_HINT_PLAN_DEBUG_PRINT_UNSPECIFIEDPG_HINT_PLAN_DEBUG_PRINT_OFFPG_HINT_PLAN_DEBUG_PRINT_ONPG_HINT_PLAN_DEBUG_PRINT_DETAILEDPG_HINT_PLAN_DEBUG_PRINT_VERBOSE
SharedPreloadLibraries
SHARED_PRELOAD_LIBRARIES_UNSPECIFIEDSHARED_PRELOAD_LIBRARIES_AUTO_EXPLAINSHARED_PRELOAD_LIBRARIES_PG_HINT_PLANSHARED_PRELOAD_LIBRARIES_TIMESCALEDBSHARED_PRELOAD_LIBRARIES_PG_QUALSTATSSHARED_PRELOAD_LIBRARIES_PG_CRONSHARED_PRELOAD_LIBRARIES_PGLOGICALSHARED_PRELOAD_LIBRARIES_PG_PREWARMSHARED_PRELOAD_LIBRARIES_PGAUDIT
maxConnections : google.protobuf.Int64Value
sharedBuffers : google.protobuf.Int64Value
in bytes.
tempBuffers : google.protobuf.Int64Value
in bytes.
maxPreparedTransactions : google.protobuf.Int64Value
workMem : google.protobuf.Int64Value
in bytes.
maintenanceWorkMem : google.protobuf.Int64Value
in bytes.
replacementSortTuples : google.protobuf.Int64Value
autovacuumWorkMem : google.protobuf.Int64Value
in bytes.
tempFileLimit : google.protobuf.Int64Value
in bytes.
vacuumCostDelay : google.protobuf.Int64Value
in milliseconds.
vacuumCostPageHit : google.protobuf.Int64Value
vacuumCostPageMiss : google.protobuf.Int64Value
vacuumCostPageDirty : google.protobuf.Int64Value
vacuumCostLimit : google.protobuf.Int64Value
bgwriterDelay : google.protobuf.Int64Value
in milliseconds.
bgwriterLruMaxpages : google.protobuf.Int64Value
bgwriterLruMultiplier : google.protobuf.DoubleValue
bgwriterFlushAfter : google.protobuf.Int64Value
in bytes
backendFlushAfter : google.protobuf.Int64Value
in bytes
oldSnapshotThreshold : google.protobuf.Int64Value
walLevel : WalLevel
synchronousCommit : SynchronousCommit
checkpointTimeout : google.protobuf.Int64Value
in milliseconds.
checkpointCompletionTarget : google.protobuf.DoubleValue
checkpointFlushAfter : google.protobuf.Int64Value
in bytes
maxWalSize : google.protobuf.Int64Value
in bytes.
minWalSize : google.protobuf.Int64Value
in bytes.
maxStandbyStreamingDelay : google.protobuf.Int64Value
in milliseconds.
defaultStatisticsTarget : google.protobuf.Int64Value
constraintExclusion : ConstraintExclusion
cursorTupleFraction : google.protobuf.DoubleValue
fromCollapseLimit : google.protobuf.Int64Value
joinCollapseLimit : google.protobuf.Int64Value
forceParallelMode : ForceParallelMode
clientMinMessages : LogLevel
logMinMessages : LogLevel
logMinErrorStatement : LogLevel
logMinDurationStatement : google.protobuf.Int64Value
in milliseconds.
logCheckpoints : google.protobuf.BoolValue
logConnections : google.protobuf.BoolValue
logDisconnections : google.protobuf.BoolValue
logDuration : google.protobuf.BoolValue
logErrorVerbosity : LogErrorVerbosity
logLockWaits : google.protobuf.BoolValue
logStatement : LogStatement
logTempFiles : google.protobuf.Int64Value
searchPath : string
rowSecurity : google.protobuf.BoolValue
defaultTransactionIsolation : TransactionIsolation
statementTimeout : google.protobuf.Int64Value
in milliseconds.
lockTimeout : google.protobuf.Int64Value
in milliseconds.
idleInTransactionSessionTimeout : google.protobuf.Int64Value
in milliseconds.
byteaOutput : ByteaOutput
xmlbinary : XmlBinary
xmloption : XmlOption
ginPendingListLimit : google.protobuf.Int64Value
in bytes.
deadlockTimeout : google.protobuf.Int64Value
in milliseconds.
maxLocksPerTransaction : google.protobuf.Int64Value
maxPredLocksPerTransaction : google.protobuf.Int64Value
arrayNulls : google.protobuf.BoolValue
backslashQuote : BackslashQuote
defaultWithOids : google.protobuf.BoolValue
escapeStringWarning : google.protobuf.BoolValue
loCompatPrivileges : google.protobuf.BoolValue
operatorPrecedenceWarning : google.protobuf.BoolValue
quoteAllIdentifiers : google.protobuf.BoolValue
standardConformingStrings : google.protobuf.BoolValue
synchronizeSeqscans : google.protobuf.BoolValue
transformNullEquals : google.protobuf.BoolValue
exitOnError : google.protobuf.BoolValue
seqPageCost : google.protobuf.DoubleValue
randomPageCost : google.protobuf.DoubleValue
autovacuumMaxWorkers : google.protobuf.Int64Value
autovacuumVacuumCostDelay : google.protobuf.Int64Value
autovacuumVacuumCostLimit : google.protobuf.Int64Value
autovacuumNaptime : google.protobuf.Int64Value
in milliseconds.
archiveTimeout : google.protobuf.Int64Value
in milliseconds.
trackActivityQuerySize : google.protobuf.Int64Value
enableBitmapscan : google.protobuf.BoolValue
enableHashagg : google.protobuf.BoolValue
enableHashjoin : google.protobuf.BoolValue
enableIndexscan : google.protobuf.BoolValue
enableIndexonlyscan : google.protobuf.BoolValue
enableMaterial : google.protobuf.BoolValue
enableMergejoin : google.protobuf.BoolValue
enableNestloop : google.protobuf.BoolValue
enableSeqscan : google.protobuf.BoolValue
enableSort : google.protobuf.BoolValue
enableTidscan : google.protobuf.BoolValue
maxWorkerProcesses : google.protobuf.Int64Value
maxParallelWorkers : google.protobuf.Int64Value
maxParallelWorkersPerGather : google.protobuf.Int64Value
autovacuumVacuumScaleFactor : google.protobuf.DoubleValue
autovacuumAnalyzeScaleFactor : google.protobuf.DoubleValue
defaultTransactionReadOnly : google.protobuf.BoolValue
timezone : string
effectiveIoConcurrency : google.protobuf.Int64Value
effectiveCacheSize : google.protobuf.Int64Value
sharedPreloadLibraries : SharedPreloadLibraries
autoExplainLogMinDuration : google.protobuf.Int64Value
in milliseconds.
autoExplainLogAnalyze : google.protobuf.BoolValue
autoExplainLogBuffers : google.protobuf.BoolValue
autoExplainLogTiming : google.protobuf.BoolValue
autoExplainLogTriggers : google.protobuf.BoolValue
autoExplainLogVerbose : google.protobuf.BoolValue
autoExplainLogNestedStatements : google.protobuf.BoolValue
autoExplainSampleRate : google.protobuf.DoubleValue
pgHintPlanEnableHint : google.protobuf.BoolValue
pgHintPlanEnableHintTable : google.protobuf.BoolValue
pgHintPlanDebugPrint : PgHintPlanDebugPrint
pgHintPlanMessageLevel : LogLevel
onlineAnalyzeEnable : google.protobuf.BoolValue
plantunerFixEmptyTable : google.protobuf.BoolValue
pgQualstatsEnabled : google.protobuf.BoolValue
pgQualstatsTrackConstants : google.protobuf.BoolValue
pgQualstatsMax : google.protobuf.Int64Value
pgQualstatsResolveOids : google.protobuf.BoolValue
pgQualstatsSampleRate : google.protobuf.DoubleValue
maxStackDepth : google.protobuf.Int64Value
in bytes.
geqo : google.protobuf.BoolValue
enable Genetic Query Optimizer, by default is on
geqoThreshold : google.protobuf.Int64Value
The number of tables to use geqo, default is 12
geqoEffort : google.protobuf.Int64Value
tradeoff between planning time and query plan quality, default is 5
geqoPoolSize : google.protobuf.Int64Value
number of individuals in the genetic population, useful values are typically 100 to 1000; default - 0 - choose based on based on geqo_effort
geqoGenerations : google.protobuf.Int64Value
the number of generations used by GEQO, useful values are in the same range as the pool size
geqoSelectionBias : google.protobuf.DoubleValue
selective pressure within the population
geqoSeed : google.protobuf.DoubleValue
initial value of the random number generator used by GEQO
maxStandbyArchiveDelay : google.protobuf.Int64Value
in milliseconds.
sessionDurationTimeout : google.protobuf.Int64Value
Terminate any session that exceeds the designated timeout, specified in milliseconds. If a timeout is not specified, the default session timeout is set to 12 hours. To disable it, specify a value of 0.
logReplicationCommands : google.protobuf.BoolValue
logAutovacuumMinDuration : google.protobuf.Int64Value
in milliseconds. The default is 1000 (1 sec).
passwordEncryption : PasswordEncryption
A default value for user_password_encryption user-level setting, if it not specified for new users. Possible values are PASSWORD_ENCRYPTION_MD5 or PASSWORD_ENCRYPTION_SCRAM_SHA_256. The default is PASSWORD_ENCRYPTION_MD5.
PostgresqlConfig10
Options and structure of PostgresqlConfig reflects PostgreSQL configuration file
parameters whose detailed description is available in
PostgreSQL documentation.
WalLevel
WAL_LEVEL_UNSPECIFIEDWAL_LEVEL_REPLICAWAL_LEVEL_LOGICAL
SynchronousCommit
SYNCHRONOUS_COMMIT_UNSPECIFIEDSYNCHRONOUS_COMMIT_ONSYNCHRONOUS_COMMIT_OFFSYNCHRONOUS_COMMIT_LOCALSYNCHRONOUS_COMMIT_REMOTE_WRITESYNCHRONOUS_COMMIT_REMOTE_APPLY
ConstraintExclusion
CONSTRAINT_EXCLUSION_UNSPECIFIEDCONSTRAINT_EXCLUSION_ONCONSTRAINT_EXCLUSION_OFFCONSTRAINT_EXCLUSION_PARTITION
ForceParallelMode
FORCE_PARALLEL_MODE_UNSPECIFIEDFORCE_PARALLEL_MODE_ONFORCE_PARALLEL_MODE_OFFFORCE_PARALLEL_MODE_REGRESS
LogErrorVerbosity
LOG_ERROR_VERBOSITY_UNSPECIFIEDLOG_ERROR_VERBOSITY_TERSELOG_ERROR_VERBOSITY_DEFAULTLOG_ERROR_VERBOSITY_VERBOSE
LogLevel
LOG_LEVEL_UNSPECIFIEDLOG_LEVEL_DEBUG5LOG_LEVEL_DEBUG4LOG_LEVEL_DEBUG3LOG_LEVEL_DEBUG2LOG_LEVEL_DEBUG1LOG_LEVEL_LOGLOG_LEVEL_NOTICELOG_LEVEL_WARNINGLOG_LEVEL_ERRORLOG_LEVEL_FATALLOG_LEVEL_PANIC
LogStatement
LOG_STATEMENT_UNSPECIFIEDLOG_STATEMENT_NONELOG_STATEMENT_DDLLOG_STATEMENT_MODLOG_STATEMENT_ALL
PasswordEncryption
PASSWORD_ENCRYPTION_UNSPECIFIEDPASSWORD_ENCRYPTION_MD5PASSWORD_ENCRYPTION_SCRAM_SHA_256
TransactionIsolation
TRANSACTION_ISOLATION_UNSPECIFIEDTRANSACTION_ISOLATION_READ_UNCOMMITTEDTRANSACTION_ISOLATION_READ_COMMITTEDTRANSACTION_ISOLATION_REPEATABLE_READTRANSACTION_ISOLATION_SERIALIZABLE
ByteaOutput
BYTEA_OUTPUT_UNSPECIFIEDBYTEA_OUTPUT_HEXBYTEA_OUTPUT_ESCAPED
XmlBinary
XML_BINARY_UNSPECIFIEDXML_BINARY_BASE64XML_BINARY_HEX
XmlOption
XML_OPTION_UNSPECIFIEDXML_OPTION_DOCUMENTXML_OPTION_CONTENT
BackslashQuote
BACKSLASH_QUOTE_UNSPECIFIEDBACKSLASH_QUOTEBACKSLASH_QUOTE_ONBACKSLASH_QUOTE_OFFBACKSLASH_QUOTE_SAFE_ENCODING
PgHintPlanDebugPrint
PG_HINT_PLAN_DEBUG_PRINT_UNSPECIFIEDPG_HINT_PLAN_DEBUG_PRINT_OFFPG_HINT_PLAN_DEBUG_PRINT_ONPG_HINT_PLAN_DEBUG_PRINT_DETAILEDPG_HINT_PLAN_DEBUG_PRINT_VERBOSE
SharedPreloadLibraries
SHARED_PRELOAD_LIBRARIES_UNSPECIFIEDSHARED_PRELOAD_LIBRARIES_AUTO_EXPLAINSHARED_PRELOAD_LIBRARIES_PG_HINT_PLANSHARED_PRELOAD_LIBRARIES_TIMESCALEDBSHARED_PRELOAD_LIBRARIES_PG_QUALSTATSSHARED_PRELOAD_LIBRARIES_PG_CRONSHARED_PRELOAD_LIBRARIES_PGLOGICALSHARED_PRELOAD_LIBRARIES_PG_PREWARMSHARED_PRELOAD_LIBRARIES_PGAUDIT
maxConnections : google.protobuf.Int64Value
sharedBuffers : google.protobuf.Int64Value
in bytes.
tempBuffers : google.protobuf.Int64Value
in bytes.
maxPreparedTransactions : google.protobuf.Int64Value
workMem : google.protobuf.Int64Value
in bytes.
maintenanceWorkMem : google.protobuf.Int64Value
in bytes.
replacementSortTuples : google.protobuf.Int64Value
autovacuumWorkMem : google.protobuf.Int64Value
in bytes.
tempFileLimit : google.protobuf.Int64Value
in bytes.
vacuumCostDelay : google.protobuf.Int64Value
in milliseconds.
vacuumCostPageHit : google.protobuf.Int64Value
vacuumCostPageMiss : google.protobuf.Int64Value
vacuumCostPageDirty : google.protobuf.Int64Value
vacuumCostLimit : google.protobuf.Int64Value
bgwriterDelay : google.protobuf.Int64Value
in milliseconds.
bgwriterLruMaxpages : google.protobuf.Int64Value
bgwriterLruMultiplier : google.protobuf.DoubleValue
bgwriterFlushAfter : google.protobuf.Int64Value
in bytes
backendFlushAfter : google.protobuf.Int64Value
in bytes
oldSnapshotThreshold : google.protobuf.Int64Value
walLevel : WalLevel
synchronousCommit : SynchronousCommit
checkpointTimeout : google.protobuf.Int64Value
in milliseconds.
checkpointCompletionTarget : google.protobuf.DoubleValue
checkpointFlushAfter : google.protobuf.Int64Value
in bytes
maxWalSize : google.protobuf.Int64Value
in bytes.
minWalSize : google.protobuf.Int64Value
in bytes.
maxStandbyStreamingDelay : google.protobuf.Int64Value
in milliseconds.
defaultStatisticsTarget : google.protobuf.Int64Value
constraintExclusion : ConstraintExclusion
cursorTupleFraction : google.protobuf.DoubleValue
fromCollapseLimit : google.protobuf.Int64Value
joinCollapseLimit : google.protobuf.Int64Value
forceParallelMode : ForceParallelMode
clientMinMessages : LogLevel
logMinMessages : LogLevel
logMinErrorStatement : LogLevel
logMinDurationStatement : google.protobuf.Int64Value
in milliseconds.
logCheckpoints : google.protobuf.BoolValue
logConnections : google.protobuf.BoolValue
logDisconnections : google.protobuf.BoolValue
logDuration : google.protobuf.BoolValue
logErrorVerbosity : LogErrorVerbosity
logLockWaits : google.protobuf.BoolValue
logStatement : LogStatement
logTempFiles : google.protobuf.Int64Value
searchPath : string
rowSecurity : google.protobuf.BoolValue
defaultTransactionIsolation : TransactionIsolation
statementTimeout : google.protobuf.Int64Value
in milliseconds.
lockTimeout : google.protobuf.Int64Value
in milliseconds.
idleInTransactionSessionTimeout : google.protobuf.Int64Value
in milliseconds.
byteaOutput : ByteaOutput
xmlbinary : XmlBinary
xmloption : XmlOption
ginPendingListLimit : google.protobuf.Int64Value
in bytes.
deadlockTimeout : google.protobuf.Int64Value
in milliseconds.
maxLocksPerTransaction : google.protobuf.Int64Value
maxPredLocksPerTransaction : google.protobuf.Int64Value
arrayNulls : google.protobuf.BoolValue
backslashQuote : BackslashQuote
defaultWithOids : google.protobuf.BoolValue
escapeStringWarning : google.protobuf.BoolValue
loCompatPrivileges : google.protobuf.BoolValue
operatorPrecedenceWarning : google.protobuf.BoolValue
quoteAllIdentifiers : google.protobuf.BoolValue
standardConformingStrings : google.protobuf.BoolValue
synchronizeSeqscans : google.protobuf.BoolValue
transformNullEquals : google.protobuf.BoolValue
exitOnError : google.protobuf.BoolValue
seqPageCost : google.protobuf.DoubleValue
randomPageCost : google.protobuf.DoubleValue
autovacuumMaxWorkers : google.protobuf.Int64Value
autovacuumVacuumCostDelay : google.protobuf.Int64Value
autovacuumVacuumCostLimit : google.protobuf.Int64Value
autovacuumNaptime : google.protobuf.Int64Value
in milliseconds.
archiveTimeout : google.protobuf.Int64Value
in milliseconds.
trackActivityQuerySize : google.protobuf.Int64Value
enableBitmapscan : google.protobuf.BoolValue
enableHashagg : google.protobuf.BoolValue
enableHashjoin : google.protobuf.BoolValue
enableIndexscan : google.protobuf.BoolValue
enableIndexonlyscan : google.protobuf.BoolValue
enableMaterial : google.protobuf.BoolValue
enableMergejoin : google.protobuf.BoolValue
enableNestloop : google.protobuf.BoolValue
enableSeqscan : google.protobuf.BoolValue
enableSort : google.protobuf.BoolValue
enableTidscan : google.protobuf.BoolValue
maxWorkerProcesses : google.protobuf.Int64Value
maxParallelWorkers : google.protobuf.Int64Value
maxParallelWorkersPerGather : google.protobuf.Int64Value
autovacuumVacuumScaleFactor : google.protobuf.DoubleValue
autovacuumAnalyzeScaleFactor : google.protobuf.DoubleValue
defaultTransactionReadOnly : google.protobuf.BoolValue
timezone : string
effectiveIoConcurrency : google.protobuf.Int64Value
effectiveCacheSize : google.protobuf.Int64Value
sharedPreloadLibraries : SharedPreloadLibraries
autoExplainLogMinDuration : google.protobuf.Int64Value
in milliseconds.
autoExplainLogAnalyze : google.protobuf.BoolValue
autoExplainLogBuffers : google.protobuf.BoolValue
autoExplainLogTiming : google.protobuf.BoolValue
autoExplainLogTriggers : google.protobuf.BoolValue
autoExplainLogVerbose : google.protobuf.BoolValue
autoExplainLogNestedStatements : google.protobuf.BoolValue
autoExplainSampleRate : google.protobuf.DoubleValue
pgHintPlanEnableHint : google.protobuf.BoolValue
pgHintPlanEnableHintTable : google.protobuf.BoolValue
pgHintPlanDebugPrint : PgHintPlanDebugPrint
pgHintPlanMessageLevel : LogLevel
pgQualstatsEnabled : google.protobuf.BoolValue
pgQualstatsTrackConstants : google.protobuf.BoolValue
pgQualstatsMax : google.protobuf.Int64Value
pgQualstatsResolveOids : google.protobuf.BoolValue
pgQualstatsSampleRate : google.protobuf.DoubleValue
maxStackDepth : google.protobuf.Int64Value
in bytes.
geqo : google.protobuf.BoolValue
enable Genetic Query Optimizer, by default is on
geqoThreshold : google.protobuf.Int64Value
The number of tables to use geqo, default is 12
geqoEffort : google.protobuf.Int64Value
tradeoff between planning time and query plan quality, default is 5
geqoPoolSize : google.protobuf.Int64Value
number of individuals in the genetic population, useful values are typically 100 to 1000; default - 0 - choose based on based on geqo_effort
geqoGenerations : google.protobuf.Int64Value
the number of generations used by GEQO, useful values are in the same range as the pool size
geqoSelectionBias : google.protobuf.DoubleValue
selective pressure within the population
geqoSeed : google.protobuf.DoubleValue
initial value of the random number generator used by GEQO
maxStandbyArchiveDelay : google.protobuf.Int64Value
in milliseconds.
sessionDurationTimeout : google.protobuf.Int64Value
Terminate any session that exceeds the designated timeout, specified in milliseconds. If a timeout is not specified, the default session timeout is set to 12 hours. To disable it, specify a value of 0.
logReplicationCommands : google.protobuf.BoolValue
logAutovacuumMinDuration : google.protobuf.Int64Value
in milliseconds. The default is 1000 (1 sec).
passwordEncryption : PasswordEncryption
A default value for user_password_encryption user-level setting, if it not specified for new users. Possible values are PASSWORD_ENCRYPTION_MD5 or PASSWORD_ENCRYPTION_SCRAM_SHA_256. The default is PASSWORD_ENCRYPTION_MD5.
PostgresqlConfig11
Options and structure of PostgresqlConfig reflects PostgreSQL configuration file
parameters which detailed description is available in
PostgreSQL documentation.
BackslashQuote
BACKSLASH_QUOTE_UNSPECIFIEDBACKSLASH_QUOTEBACKSLASH_QUOTE_ONBACKSLASH_QUOTE_OFFBACKSLASH_QUOTE_SAFE_ENCODING
ByteaOutput
BYTEA_OUTPUT_UNSPECIFIEDBYTEA_OUTPUT_HEXBYTEA_OUTPUT_ESCAPED
ConstraintExclusion
CONSTRAINT_EXCLUSION_UNSPECIFIEDCONSTRAINT_EXCLUSION_ONCONSTRAINT_EXCLUSION_OFFCONSTRAINT_EXCLUSION_PARTITION
ForceParallelMode
FORCE_PARALLEL_MODE_UNSPECIFIEDFORCE_PARALLEL_MODE_ONFORCE_PARALLEL_MODE_OFFFORCE_PARALLEL_MODE_REGRESS
LogErrorVerbosity
LOG_ERROR_VERBOSITY_UNSPECIFIEDLOG_ERROR_VERBOSITY_TERSELOG_ERROR_VERBOSITY_DEFAULTLOG_ERROR_VERBOSITY_VERBOSE
LogLevel
LOG_LEVEL_UNSPECIFIEDLOG_LEVEL_DEBUG5LOG_LEVEL_DEBUG4LOG_LEVEL_DEBUG3LOG_LEVEL_DEBUG2LOG_LEVEL_DEBUG1LOG_LEVEL_LOGLOG_LEVEL_NOTICELOG_LEVEL_WARNINGLOG_LEVEL_ERRORLOG_LEVEL_FATALLOG_LEVEL_PANIC
LogStatement
LOG_STATEMENT_UNSPECIFIEDLOG_STATEMENT_NONELOG_STATEMENT_DDLLOG_STATEMENT_MODLOG_STATEMENT_ALL
PasswordEncryption
PASSWORD_ENCRYPTION_UNSPECIFIEDPASSWORD_ENCRYPTION_MD5PASSWORD_ENCRYPTION_SCRAM_SHA_256
PgHintPlanDebugPrint
PG_HINT_PLAN_DEBUG_PRINT_UNSPECIFIEDPG_HINT_PLAN_DEBUG_PRINT_OFFPG_HINT_PLAN_DEBUG_PRINT_ONPG_HINT_PLAN_DEBUG_PRINT_DETAILEDPG_HINT_PLAN_DEBUG_PRINT_VERBOSE
SharedPreloadLibraries
SHARED_PRELOAD_LIBRARIES_UNSPECIFIEDSHARED_PRELOAD_LIBRARIES_AUTO_EXPLAINSHARED_PRELOAD_LIBRARIES_PG_HINT_PLANSHARED_PRELOAD_LIBRARIES_TIMESCALEDBSHARED_PRELOAD_LIBRARIES_PG_QUALSTATSSHARED_PRELOAD_LIBRARIES_PG_CRONSHARED_PRELOAD_LIBRARIES_PGLOGICALSHARED_PRELOAD_LIBRARIES_PG_PREWARMSHARED_PRELOAD_LIBRARIES_PGAUDIT
SynchronousCommit
SYNCHRONOUS_COMMIT_UNSPECIFIEDSYNCHRONOUS_COMMIT_ONSYNCHRONOUS_COMMIT_OFFSYNCHRONOUS_COMMIT_LOCALSYNCHRONOUS_COMMIT_REMOTE_WRITESYNCHRONOUS_COMMIT_REMOTE_APPLY
TransactionIsolation
TRANSACTION_ISOLATION_UNSPECIFIEDTRANSACTION_ISOLATION_READ_UNCOMMITTEDTRANSACTION_ISOLATION_READ_COMMITTEDTRANSACTION_ISOLATION_REPEATABLE_READTRANSACTION_ISOLATION_SERIALIZABLE
WalLevel
WAL_LEVEL_UNSPECIFIEDWAL_LEVEL_REPLICAWAL_LEVEL_LOGICAL
XmlBinary
XML_BINARY_UNSPECIFIEDXML_BINARY_BASE64XML_BINARY_HEX
XmlOption
XML_OPTION_UNSPECIFIEDXML_OPTION_DOCUMENTXML_OPTION_CONTENT
maxConnections : google.protobuf.Int64Value
sharedBuffers : google.protobuf.Int64Value
in bytes.
tempBuffers : google.protobuf.Int64Value
in bytes.
maxPreparedTransactions : google.protobuf.Int64Value
workMem : google.protobuf.Int64Value
in bytes.
maintenanceWorkMem : google.protobuf.Int64Value
in bytes.
autovacuumWorkMem : google.protobuf.Int64Value
in bytes.
tempFileLimit : google.protobuf.Int64Value
in bytes.
vacuumCostDelay : google.protobuf.Int64Value
in milliseconds.
vacuumCostPageHit : google.protobuf.Int64Value
vacuumCostPageMiss : google.protobuf.Int64Value
vacuumCostPageDirty : google.protobuf.Int64Value
vacuumCostLimit : google.protobuf.Int64Value
bgwriterDelay : google.protobuf.Int64Value
in milliseconds.
bgwriterLruMaxpages : google.protobuf.Int64Value
bgwriterLruMultiplier : google.protobuf.DoubleValue
bgwriterFlushAfter : google.protobuf.Int64Value
in bytes
backendFlushAfter : google.protobuf.Int64Value
in bytes
oldSnapshotThreshold : google.protobuf.Int64Value
walLevel : WalLevel
synchronousCommit : SynchronousCommit
checkpointTimeout : google.protobuf.Int64Value
in milliseconds.
checkpointCompletionTarget : google.protobuf.DoubleValue
checkpointFlushAfter : google.protobuf.Int64Value
in bytes
maxWalSize : google.protobuf.Int64Value
in bytes.
minWalSize : google.protobuf.Int64Value
in bytes.
maxStandbyStreamingDelay : google.protobuf.Int64Value
in milliseconds.
defaultStatisticsTarget : google.protobuf.Int64Value
constraintExclusion : ConstraintExclusion
cursorTupleFraction : google.protobuf.DoubleValue
fromCollapseLimit : google.protobuf.Int64Value
joinCollapseLimit : google.protobuf.Int64Value
forceParallelMode : ForceParallelMode
clientMinMessages : LogLevel
logMinMessages : LogLevel
logMinErrorStatement : LogLevel
logMinDurationStatement : google.protobuf.Int64Value
in milliseconds.
logCheckpoints : google.protobuf.BoolValue
logConnections : google.protobuf.BoolValue
logDisconnections : google.protobuf.BoolValue
logDuration : google.protobuf.BoolValue
logErrorVerbosity : LogErrorVerbosity
logLockWaits : google.protobuf.BoolValue
logStatement : LogStatement
logTempFiles : google.protobuf.Int64Value
searchPath : string
rowSecurity : google.protobuf.BoolValue
defaultTransactionIsolation : TransactionIsolation
statementTimeout : google.protobuf.Int64Value
in milliseconds.
lockTimeout : google.protobuf.Int64Value
in milliseconds.
idleInTransactionSessionTimeout : google.protobuf.Int64Value
in milliseconds.
byteaOutput : ByteaOutput
xmlbinary : XmlBinary
xmloption : XmlOption
ginPendingListLimit : google.protobuf.Int64Value
in bytes.
deadlockTimeout : google.protobuf.Int64Value
in milliseconds.
maxLocksPerTransaction : google.protobuf.Int64Value
maxPredLocksPerTransaction : google.protobuf.Int64Value
arrayNulls : google.protobuf.BoolValue
backslashQuote : BackslashQuote
defaultWithOids : google.protobuf.BoolValue
escapeStringWarning : google.protobuf.BoolValue
loCompatPrivileges : google.protobuf.BoolValue
operatorPrecedenceWarning : google.protobuf.BoolValue
quoteAllIdentifiers : google.protobuf.BoolValue
standardConformingStrings : google.protobuf.BoolValue
synchronizeSeqscans : google.protobuf.BoolValue
transformNullEquals : google.protobuf.BoolValue
exitOnError : google.protobuf.BoolValue
seqPageCost : google.protobuf.DoubleValue
randomPageCost : google.protobuf.DoubleValue
autovacuumMaxWorkers : google.protobuf.Int64Value
autovacuumVacuumCostDelay : google.protobuf.Int64Value
autovacuumVacuumCostLimit : google.protobuf.Int64Value
autovacuumNaptime : google.protobuf.Int64Value
in milliseconds.
archiveTimeout : google.protobuf.Int64Value
in milliseconds.
trackActivityQuerySize : google.protobuf.Int64Value
enableBitmapscan : google.protobuf.BoolValue
enableHashagg : google.protobuf.BoolValue
enableHashjoin : google.protobuf.BoolValue
enableIndexscan : google.protobuf.BoolValue
enableIndexonlyscan : google.protobuf.BoolValue
enableMaterial : google.protobuf.BoolValue
enableMergejoin : google.protobuf.BoolValue
enableNestloop : google.protobuf.BoolValue
enableSeqscan : google.protobuf.BoolValue
enableSort : google.protobuf.BoolValue
enableTidscan : google.protobuf.BoolValue
maxWorkerProcesses : google.protobuf.Int64Value
maxParallelWorkers : google.protobuf.Int64Value
maxParallelWorkersPerGather : google.protobuf.Int64Value
autovacuumVacuumScaleFactor : google.protobuf.DoubleValue
autovacuumAnalyzeScaleFactor : google.protobuf.DoubleValue
defaultTransactionReadOnly : google.protobuf.BoolValue
timezone : string
enableParallelAppend : google.protobuf.BoolValue
enableParallelHash : google.protobuf.BoolValue
enablePartitionPruning : google.protobuf.BoolValue
enablePartitionwiseAggregate : google.protobuf.BoolValue
enablePartitionwiseJoin : google.protobuf.BoolValue
jit : google.protobuf.BoolValue
maxParallelMaintenanceWorkers : google.protobuf.Int64Value
parallelLeaderParticipation : google.protobuf.BoolValue
vacuumCleanupIndexScaleFactor : google.protobuf.DoubleValue
effectiveIoConcurrency : google.protobuf.Int64Value
effectiveCacheSize : google.protobuf.Int64Value
sharedPreloadLibraries : SharedPreloadLibraries
autoExplainLogMinDuration : google.protobuf.Int64Value
in milliseconds.
autoExplainLogAnalyze : google.protobuf.BoolValue
autoExplainLogBuffers : google.protobuf.BoolValue
autoExplainLogTiming : google.protobuf.BoolValue
autoExplainLogTriggers : google.protobuf.BoolValue
autoExplainLogVerbose : google.protobuf.BoolValue
autoExplainLogNestedStatements : google.protobuf.BoolValue
autoExplainSampleRate : google.protobuf.DoubleValue
pgHintPlanEnableHint : google.protobuf.BoolValue
pgHintPlanEnableHintTable : google.protobuf.BoolValue
pgHintPlanDebugPrint : PgHintPlanDebugPrint
pgHintPlanMessageLevel : LogLevel
pgQualstatsEnabled : google.protobuf.BoolValue
pgQualstatsTrackConstants : google.protobuf.BoolValue
pgQualstatsMax : google.protobuf.Int64Value
pgQualstatsResolveOids : google.protobuf.BoolValue
pgQualstatsSampleRate : google.protobuf.DoubleValue
maxStackDepth : google.protobuf.Int64Value
in bytes.
geqo : google.protobuf.BoolValue
enable Genetic Query Optimizer, by default is on
geqoThreshold : google.protobuf.Int64Value
The number of tables to use geqo, default is 12
geqoEffort : google.protobuf.Int64Value
tradeoff between planning time and query plan quality, default is 5
geqoPoolSize : google.protobuf.Int64Value
number of individuals in the genetic population, useful values are typically 100 to 1000; default - 0 - choose based on based on geqo_effort
geqoGenerations : google.protobuf.Int64Value
the number of generations used by GEQO, useful values are in the same range as the pool size
geqoSelectionBias : google.protobuf.DoubleValue
selective pressure within the population
geqoSeed : google.protobuf.DoubleValue
initial value of the random number generator used by GEQO
pgTrgmSimilarityThreshold : google.protobuf.DoubleValue
pgTrgmWordSimilarityThreshold : google.protobuf.DoubleValue
pgTrgmStrictWordSimilarityThreshold : google.protobuf.DoubleValue
maxStandbyArchiveDelay : google.protobuf.Int64Value
in milliseconds.
sessionDurationTimeout : google.protobuf.Int64Value
Terminate any session that exceeds the designated timeout, specified in milliseconds. If a timeout is not specified, the default session timeout is set to 12 hours. To disable it, specify a value of 0.
logReplicationCommands : google.protobuf.BoolValue
logAutovacuumMinDuration : google.protobuf.Int64Value
in milliseconds. The default is 1000 (1 sec).
passwordEncryption : PasswordEncryption
A default value for user_password_encryption user-level setting, if it not specified for new users. Possible values are PASSWORD_ENCRYPTION_MD5 or PASSWORD_ENCRYPTION_SCRAM_SHA_256. The default is PASSWORD_ENCRYPTION_MD5.
PostgresqlConfig11_1C
Options and structure of PostgresqlConfig reflects PostgreSQL configuration file
parameters which detailed description is available in
PostgreSQL documentation.
BackslashQuote
BACKSLASH_QUOTE_UNSPECIFIEDBACKSLASH_QUOTEBACKSLASH_QUOTE_ONBACKSLASH_QUOTE_OFFBACKSLASH_QUOTE_SAFE_ENCODING
ByteaOutput
BYTEA_OUTPUT_UNSPECIFIEDBYTEA_OUTPUT_HEXBYTEA_OUTPUT_ESCAPED
ConstraintExclusion
CONSTRAINT_EXCLUSION_UNSPECIFIEDCONSTRAINT_EXCLUSION_ONCONSTRAINT_EXCLUSION_OFFCONSTRAINT_EXCLUSION_PARTITION
ForceParallelMode
FORCE_PARALLEL_MODE_UNSPECIFIEDFORCE_PARALLEL_MODE_ONFORCE_PARALLEL_MODE_OFFFORCE_PARALLEL_MODE_REGRESS
LogErrorVerbosity
LOG_ERROR_VERBOSITY_UNSPECIFIEDLOG_ERROR_VERBOSITY_TERSELOG_ERROR_VERBOSITY_DEFAULTLOG_ERROR_VERBOSITY_VERBOSE
LogLevel
LOG_LEVEL_UNSPECIFIEDLOG_LEVEL_DEBUG5LOG_LEVEL_DEBUG4LOG_LEVEL_DEBUG3LOG_LEVEL_DEBUG2LOG_LEVEL_DEBUG1LOG_LEVEL_LOGLOG_LEVEL_NOTICELOG_LEVEL_WARNINGLOG_LEVEL_ERRORLOG_LEVEL_FATALLOG_LEVEL_PANIC
LogStatement
LOG_STATEMENT_UNSPECIFIEDLOG_STATEMENT_NONELOG_STATEMENT_DDLLOG_STATEMENT_MODLOG_STATEMENT_ALL
PasswordEncryption
PASSWORD_ENCRYPTION_UNSPECIFIEDPASSWORD_ENCRYPTION_MD5PASSWORD_ENCRYPTION_SCRAM_SHA_256
PgHintPlanDebugPrint
PG_HINT_PLAN_DEBUG_PRINT_UNSPECIFIEDPG_HINT_PLAN_DEBUG_PRINT_OFFPG_HINT_PLAN_DEBUG_PRINT_ONPG_HINT_PLAN_DEBUG_PRINT_DETAILEDPG_HINT_PLAN_DEBUG_PRINT_VERBOSE
SharedPreloadLibraries
SHARED_PRELOAD_LIBRARIES_UNSPECIFIEDSHARED_PRELOAD_LIBRARIES_AUTO_EXPLAINSHARED_PRELOAD_LIBRARIES_PG_HINT_PLANSHARED_PRELOAD_LIBRARIES_TIMESCALEDBSHARED_PRELOAD_LIBRARIES_PG_QUALSTATSSHARED_PRELOAD_LIBRARIES_PG_CRONSHARED_PRELOAD_LIBRARIES_PGLOGICALSHARED_PRELOAD_LIBRARIES_PG_PREWARMSHARED_PRELOAD_LIBRARIES_PGAUDIT
SynchronousCommit
SYNCHRONOUS_COMMIT_UNSPECIFIEDSYNCHRONOUS_COMMIT_ONSYNCHRONOUS_COMMIT_OFFSYNCHRONOUS_COMMIT_LOCALSYNCHRONOUS_COMMIT_REMOTE_WRITESYNCHRONOUS_COMMIT_REMOTE_APPLY
TransactionIsolation
TRANSACTION_ISOLATION_UNSPECIFIEDTRANSACTION_ISOLATION_READ_UNCOMMITTEDTRANSACTION_ISOLATION_READ_COMMITTEDTRANSACTION_ISOLATION_REPEATABLE_READTRANSACTION_ISOLATION_SERIALIZABLE
WalLevel
WAL_LEVEL_UNSPECIFIEDWAL_LEVEL_REPLICAWAL_LEVEL_LOGICAL
XmlBinary
XML_BINARY_UNSPECIFIEDXML_BINARY_BASE64XML_BINARY_HEX
XmlOption
XML_OPTION_UNSPECIFIEDXML_OPTION_DOCUMENTXML_OPTION_CONTENT
maxConnections : google.protobuf.Int64Value
sharedBuffers : google.protobuf.Int64Value
in bytes.
tempBuffers : google.protobuf.Int64Value
in bytes.
maxPreparedTransactions : google.protobuf.Int64Value
workMem : google.protobuf.Int64Value
in bytes.
maintenanceWorkMem : google.protobuf.Int64Value
in bytes.
autovacuumWorkMem : google.protobuf.Int64Value
in bytes.
tempFileLimit : google.protobuf.Int64Value
in bytes.
vacuumCostDelay : google.protobuf.Int64Value
in milliseconds.
vacuumCostPageHit : google.protobuf.Int64Value
vacuumCostPageMiss : google.protobuf.Int64Value
vacuumCostPageDirty : google.protobuf.Int64Value
vacuumCostLimit : google.protobuf.Int64Value
bgwriterDelay : google.protobuf.Int64Value
in milliseconds.
bgwriterLruMaxpages : google.protobuf.Int64Value
bgwriterLruMultiplier : google.protobuf.DoubleValue
bgwriterFlushAfter : google.protobuf.Int64Value
in bytes
backendFlushAfter : google.protobuf.Int64Value
in bytes
oldSnapshotThreshold : google.protobuf.Int64Value
walLevel : WalLevel
synchronousCommit : SynchronousCommit
checkpointTimeout : google.protobuf.Int64Value
in milliseconds.
checkpointCompletionTarget : google.protobuf.DoubleValue
checkpointFlushAfter : google.protobuf.Int64Value
in bytes
maxWalSize : google.protobuf.Int64Value
in bytes.
minWalSize : google.protobuf.Int64Value
in bytes.
maxStandbyStreamingDelay : google.protobuf.Int64Value
in milliseconds.
defaultStatisticsTarget : google.protobuf.Int64Value
constraintExclusion : ConstraintExclusion
cursorTupleFraction : google.protobuf.DoubleValue
fromCollapseLimit : google.protobuf.Int64Value
joinCollapseLimit : google.protobuf.Int64Value
forceParallelMode : ForceParallelMode
clientMinMessages : LogLevel
logMinMessages : LogLevel
logMinErrorStatement : LogLevel
logMinDurationStatement : google.protobuf.Int64Value
in milliseconds.
logCheckpoints : google.protobuf.BoolValue
logConnections : google.protobuf.BoolValue
logDisconnections : google.protobuf.BoolValue
logDuration : google.protobuf.BoolValue
logErrorVerbosity : LogErrorVerbosity
logLockWaits : google.protobuf.BoolValue
logStatement : LogStatement
logTempFiles : google.protobuf.Int64Value
searchPath : string
rowSecurity : google.protobuf.BoolValue
defaultTransactionIsolation : TransactionIsolation
statementTimeout : google.protobuf.Int64Value
in milliseconds.
lockTimeout : google.protobuf.Int64Value
in milliseconds.
idleInTransactionSessionTimeout : google.protobuf.Int64Value
in milliseconds.
byteaOutput : ByteaOutput
xmlbinary : XmlBinary
xmloption : XmlOption
ginPendingListLimit : google.protobuf.Int64Value
in bytes.
deadlockTimeout : google.protobuf.Int64Value
in milliseconds.
maxLocksPerTransaction : google.protobuf.Int64Value
maxPredLocksPerTransaction : google.protobuf.Int64Value
arrayNulls : google.protobuf.BoolValue
backslashQuote : BackslashQuote
defaultWithOids : google.protobuf.BoolValue
escapeStringWarning : google.protobuf.BoolValue
loCompatPrivileges : google.protobuf.BoolValue
operatorPrecedenceWarning : google.protobuf.BoolValue
quoteAllIdentifiers : google.protobuf.BoolValue
standardConformingStrings : google.protobuf.BoolValue
synchronizeSeqscans : google.protobuf.BoolValue
transformNullEquals : google.protobuf.BoolValue
exitOnError : google.protobuf.BoolValue
seqPageCost : google.protobuf.DoubleValue
randomPageCost : google.protobuf.DoubleValue
autovacuumMaxWorkers : google.protobuf.Int64Value
autovacuumVacuumCostDelay : google.protobuf.Int64Value
autovacuumVacuumCostLimit : google.protobuf.Int64Value
autovacuumNaptime : google.protobuf.Int64Value
in milliseconds.
archiveTimeout : google.protobuf.Int64Value
in milliseconds.
trackActivityQuerySize : google.protobuf.Int64Value
onlineAnalyzeEnable : google.protobuf.BoolValue
enableBitmapscan : google.protobuf.BoolValue
enableHashagg : google.protobuf.BoolValue
enableHashjoin : google.protobuf.BoolValue
enableIndexscan : google.protobuf.BoolValue
enableIndexonlyscan : google.protobuf.BoolValue
enableMaterial : google.protobuf.BoolValue
enableMergejoin : google.protobuf.BoolValue
enableNestloop : google.protobuf.BoolValue
enableSeqscan : google.protobuf.BoolValue
enableSort : google.protobuf.BoolValue
enableTidscan : google.protobuf.BoolValue
maxWorkerProcesses : google.protobuf.Int64Value
maxParallelWorkers : google.protobuf.Int64Value
maxParallelWorkersPerGather : google.protobuf.Int64Value
autovacuumVacuumScaleFactor : google.protobuf.DoubleValue
autovacuumAnalyzeScaleFactor : google.protobuf.DoubleValue
defaultTransactionReadOnly : google.protobuf.BoolValue
timezone : string
enableParallelAppend : google.protobuf.BoolValue
enableParallelHash : google.protobuf.BoolValue
enablePartitionPruning : google.protobuf.BoolValue
enablePartitionwiseAggregate : google.protobuf.BoolValue
enablePartitionwiseJoin : google.protobuf.BoolValue
jit : google.protobuf.BoolValue
maxParallelMaintenanceWorkers : google.protobuf.Int64Value
parallelLeaderParticipation : google.protobuf.BoolValue
vacuumCleanupIndexScaleFactor : google.protobuf.DoubleValue
effectiveIoConcurrency : google.protobuf.Int64Value
effectiveCacheSize : google.protobuf.Int64Value
sharedPreloadLibraries : SharedPreloadLibraries
autoExplainLogMinDuration : google.protobuf.Int64Value
in milliseconds.
autoExplainLogAnalyze : google.protobuf.BoolValue
autoExplainLogBuffers : google.protobuf.BoolValue
autoExplainLogTiming : google.protobuf.BoolValue
autoExplainLogTriggers : google.protobuf.BoolValue
autoExplainLogVerbose : google.protobuf.BoolValue
autoExplainLogNestedStatements : google.protobuf.BoolValue
autoExplainSampleRate : google.protobuf.DoubleValue
pgHintPlanEnableHint : google.protobuf.BoolValue
pgHintPlanEnableHintTable : google.protobuf.BoolValue
pgHintPlanDebugPrint : PgHintPlanDebugPrint
pgHintPlanMessageLevel : LogLevel
pgQualstatsEnabled : google.protobuf.BoolValue
pgQualstatsTrackConstants : google.protobuf.BoolValue
pgQualstatsMax : google.protobuf.Int64Value
pgQualstatsResolveOids : google.protobuf.BoolValue
pgQualstatsSampleRate : google.protobuf.DoubleValue
plantunerFixEmptyTable : google.protobuf.BoolValue
maxStackDepth : google.protobuf.Int64Value
in bytes.
geqo : google.protobuf.BoolValue
enable Genetic Query Optimizer, by default is on
geqoThreshold : google.protobuf.Int64Value
The number of tables to use geqo, default is 12
geqoEffort : google.protobuf.Int64Value
tradeoff between planning time and query plan quality, default is 5
geqoPoolSize : google.protobuf.Int64Value
number of individuals in the genetic population, useful values are typically 100 to 1000; default - 0 - choose based on based on geqo_effort
geqoGenerations : google.protobuf.Int64Value
the number of generations used by GEQO, useful values are in the same range as the pool size
geqoSelectionBias : google.protobuf.DoubleValue
selective pressure within the population
geqoSeed : google.protobuf.DoubleValue
initial value of the random number generator used by GEQO
pgTrgmSimilarityThreshold : google.protobuf.DoubleValue
pgTrgmWordSimilarityThreshold : google.protobuf.DoubleValue
pgTrgmStrictWordSimilarityThreshold : google.protobuf.DoubleValue
maxStandbyArchiveDelay : google.protobuf.Int64Value
in milliseconds.
sessionDurationTimeout : google.protobuf.Int64Value
Terminate any session that exceeds the designated timeout, specified in milliseconds. If a timeout is not specified, the default session timeout is set to 12 hours. To disable it, specify a value of 0.
logReplicationCommands : google.protobuf.BoolValue
logAutovacuumMinDuration : google.protobuf.Int64Value
in milliseconds. The default is 1000 (1 sec).
passwordEncryption : PasswordEncryption
A default value for user_password_encryption user-level setting, if it not specified for new users. Possible values are PASSWORD_ENCRYPTION_MD5 or PASSWORD_ENCRYPTION_SCRAM_SHA_256. The default is PASSWORD_ENCRYPTION_MD5.
PostgresqlConfig12
Options and structure of PostgresqlConfig reflects PostgreSQL configuration file
parameters which detailed description is available in
PostgreSQL documentation.
BackslashQuote
BACKSLASH_QUOTE_UNSPECIFIEDBACKSLASH_QUOTEBACKSLASH_QUOTE_ONBACKSLASH_QUOTE_OFFBACKSLASH_QUOTE_SAFE_ENCODING
ByteaOutput
BYTEA_OUTPUT_UNSPECIFIEDBYTEA_OUTPUT_HEXBYTEA_OUTPUT_ESCAPED
ConstraintExclusion
CONSTRAINT_EXCLUSION_UNSPECIFIEDCONSTRAINT_EXCLUSION_ONCONSTRAINT_EXCLUSION_OFFCONSTRAINT_EXCLUSION_PARTITION
ForceParallelMode
FORCE_PARALLEL_MODE_UNSPECIFIEDFORCE_PARALLEL_MODE_ONFORCE_PARALLEL_MODE_OFFFORCE_PARALLEL_MODE_REGRESS
LogErrorVerbosity
LOG_ERROR_VERBOSITY_UNSPECIFIEDLOG_ERROR_VERBOSITY_TERSELOG_ERROR_VERBOSITY_DEFAULTLOG_ERROR_VERBOSITY_VERBOSE
LogLevel
LOG_LEVEL_UNSPECIFIEDLOG_LEVEL_DEBUG5LOG_LEVEL_DEBUG4LOG_LEVEL_DEBUG3LOG_LEVEL_DEBUG2LOG_LEVEL_DEBUG1LOG_LEVEL_LOGLOG_LEVEL_NOTICELOG_LEVEL_WARNINGLOG_LEVEL_ERRORLOG_LEVEL_FATALLOG_LEVEL_PANIC
LogStatement
LOG_STATEMENT_UNSPECIFIEDLOG_STATEMENT_NONELOG_STATEMENT_DDLLOG_STATEMENT_MODLOG_STATEMENT_ALL
PasswordEncryption
PASSWORD_ENCRYPTION_UNSPECIFIEDPASSWORD_ENCRYPTION_MD5PASSWORD_ENCRYPTION_SCRAM_SHA_256
PgHintPlanDebugPrint
PG_HINT_PLAN_DEBUG_PRINT_UNSPECIFIEDPG_HINT_PLAN_DEBUG_PRINT_OFFPG_HINT_PLAN_DEBUG_PRINT_ONPG_HINT_PLAN_DEBUG_PRINT_DETAILEDPG_HINT_PLAN_DEBUG_PRINT_VERBOSE
PlanCacheMode
PLAN_CACHE_MODE_UNSPECIFIEDPLAN_CACHE_MODE_AUTOPLAN_CACHE_MODE_FORCE_CUSTOM_PLANPLAN_CACHE_MODE_FORCE_GENERIC_PLAN
SharedPreloadLibraries
SHARED_PRELOAD_LIBRARIES_UNSPECIFIEDSHARED_PRELOAD_LIBRARIES_AUTO_EXPLAINSHARED_PRELOAD_LIBRARIES_PG_HINT_PLANSHARED_PRELOAD_LIBRARIES_TIMESCALEDBSHARED_PRELOAD_LIBRARIES_PG_QUALSTATSSHARED_PRELOAD_LIBRARIES_PG_CRONSHARED_PRELOAD_LIBRARIES_PGLOGICALSHARED_PRELOAD_LIBRARIES_PG_PREWARMSHARED_PRELOAD_LIBRARIES_PGAUDIT
SynchronousCommit
SYNCHRONOUS_COMMIT_UNSPECIFIEDSYNCHRONOUS_COMMIT_ONSYNCHRONOUS_COMMIT_OFFSYNCHRONOUS_COMMIT_LOCALSYNCHRONOUS_COMMIT_REMOTE_WRITESYNCHRONOUS_COMMIT_REMOTE_APPLY
TransactionIsolation
TRANSACTION_ISOLATION_UNSPECIFIEDTRANSACTION_ISOLATION_READ_UNCOMMITTEDTRANSACTION_ISOLATION_READ_COMMITTEDTRANSACTION_ISOLATION_REPEATABLE_READTRANSACTION_ISOLATION_SERIALIZABLE
WalLevel
WAL_LEVEL_UNSPECIFIEDWAL_LEVEL_REPLICAWAL_LEVEL_LOGICAL
XmlBinary
XML_BINARY_UNSPECIFIEDXML_BINARY_BASE64XML_BINARY_HEX
XmlOption
XML_OPTION_UNSPECIFIEDXML_OPTION_DOCUMENTXML_OPTION_CONTENT
maxConnections : google.protobuf.Int64Value
sharedBuffers : google.protobuf.Int64Value
in bytes.
tempBuffers : google.protobuf.Int64Value
in bytes.
maxPreparedTransactions : google.protobuf.Int64Value
workMem : google.protobuf.Int64Value
in bytes.
maintenanceWorkMem : google.protobuf.Int64Value
in bytes.
autovacuumWorkMem : google.protobuf.Int64Value
in bytes.
tempFileLimit : google.protobuf.Int64Value
in bytes.
vacuumCostDelay : google.protobuf.Int64Value
in milliseconds.
vacuumCostPageHit : google.protobuf.Int64Value
vacuumCostPageMiss : google.protobuf.Int64Value
vacuumCostPageDirty : google.protobuf.Int64Value
vacuumCostLimit : google.protobuf.Int64Value
bgwriterDelay : google.protobuf.Int64Value
in milliseconds.
bgwriterLruMaxpages : google.protobuf.Int64Value
bgwriterLruMultiplier : google.protobuf.DoubleValue
bgwriterFlushAfter : google.protobuf.Int64Value
in bytes
backendFlushAfter : google.protobuf.Int64Value
in bytes
oldSnapshotThreshold : google.protobuf.Int64Value
walLevel : WalLevel
synchronousCommit : SynchronousCommit
checkpointTimeout : google.protobuf.Int64Value
in milliseconds.
checkpointCompletionTarget : google.protobuf.DoubleValue
checkpointFlushAfter : google.protobuf.Int64Value
in bytes
maxWalSize : google.protobuf.Int64Value
in bytes.
minWalSize : google.protobuf.Int64Value
in bytes.
maxStandbyStreamingDelay : google.protobuf.Int64Value
in milliseconds.
defaultStatisticsTarget : google.protobuf.Int64Value
constraintExclusion : ConstraintExclusion
cursorTupleFraction : google.protobuf.DoubleValue
fromCollapseLimit : google.protobuf.Int64Value
joinCollapseLimit : google.protobuf.Int64Value
forceParallelMode : ForceParallelMode
clientMinMessages : LogLevel
logMinMessages : LogLevel
logMinErrorStatement : LogLevel
logMinDurationStatement : google.protobuf.Int64Value
in milliseconds.
logCheckpoints : google.protobuf.BoolValue
logConnections : google.protobuf.BoolValue
logDisconnections : google.protobuf.BoolValue
logDuration : google.protobuf.BoolValue
logErrorVerbosity : LogErrorVerbosity
logLockWaits : google.protobuf.BoolValue
logStatement : LogStatement
logTempFiles : google.protobuf.Int64Value
searchPath : string
rowSecurity : google.protobuf.BoolValue
defaultTransactionIsolation : TransactionIsolation
statementTimeout : google.protobuf.Int64Value
in milliseconds.
lockTimeout : google.protobuf.Int64Value
in milliseconds.
idleInTransactionSessionTimeout : google.protobuf.Int64Value
in milliseconds.
byteaOutput : ByteaOutput
xmlbinary : XmlBinary
xmloption : XmlOption
ginPendingListLimit : google.protobuf.Int64Value
in bytes.
deadlockTimeout : google.protobuf.Int64Value
in milliseconds.
maxLocksPerTransaction : google.protobuf.Int64Value
maxPredLocksPerTransaction : google.protobuf.Int64Value
arrayNulls : google.protobuf.BoolValue
backslashQuote : BackslashQuote
defaultWithOids : google.protobuf.BoolValue
escapeStringWarning : google.protobuf.BoolValue
loCompatPrivileges : google.protobuf.BoolValue
operatorPrecedenceWarning : google.protobuf.BoolValue
quoteAllIdentifiers : google.protobuf.BoolValue
standardConformingStrings : google.protobuf.BoolValue
synchronizeSeqscans : google.protobuf.BoolValue
transformNullEquals : google.protobuf.BoolValue
exitOnError : google.protobuf.BoolValue
seqPageCost : google.protobuf.DoubleValue
randomPageCost : google.protobuf.DoubleValue
autovacuumMaxWorkers : google.protobuf.Int64Value
autovacuumVacuumCostDelay : google.protobuf.Int64Value
autovacuumVacuumCostLimit : google.protobuf.Int64Value
autovacuumNaptime : google.protobuf.Int64Value
in milliseconds.
archiveTimeout : google.protobuf.Int64Value
in milliseconds.
trackActivityQuerySize : google.protobuf.Int64Value
enableBitmapscan : google.protobuf.BoolValue
enableHashagg : google.protobuf.BoolValue
enableHashjoin : google.protobuf.BoolValue
enableIndexscan : google.protobuf.BoolValue
enableIndexonlyscan : google.protobuf.BoolValue
enableMaterial : google.protobuf.BoolValue
enableMergejoin : google.protobuf.BoolValue
enableNestloop : google.protobuf.BoolValue
enableSeqscan : google.protobuf.BoolValue
enableSort : google.protobuf.BoolValue
enableTidscan : google.protobuf.BoolValue
maxWorkerProcesses : google.protobuf.Int64Value
maxParallelWorkers : google.protobuf.Int64Value
maxParallelWorkersPerGather : google.protobuf.Int64Value
autovacuumVacuumScaleFactor : google.protobuf.DoubleValue
autovacuumAnalyzeScaleFactor : google.protobuf.DoubleValue
defaultTransactionReadOnly : google.protobuf.BoolValue
timezone : string
enableParallelAppend : google.protobuf.BoolValue
enableParallelHash : google.protobuf.BoolValue
enablePartitionPruning : google.protobuf.BoolValue
enablePartitionwiseAggregate : google.protobuf.BoolValue
enablePartitionwiseJoin : google.protobuf.BoolValue
jit : google.protobuf.BoolValue
maxParallelMaintenanceWorkers : google.protobuf.Int64Value
parallelLeaderParticipation : google.protobuf.BoolValue
vacuumCleanupIndexScaleFactor : google.protobuf.DoubleValue
logTransactionSampleRate : google.protobuf.DoubleValue
planCacheMode : PlanCacheMode
effectiveIoConcurrency : google.protobuf.Int64Value
effectiveCacheSize : google.protobuf.Int64Value
sharedPreloadLibraries : SharedPreloadLibraries
autoExplainLogMinDuration : google.protobuf.Int64Value
in milliseconds.
autoExplainLogAnalyze : google.protobuf.BoolValue
autoExplainLogBuffers : google.protobuf.BoolValue
autoExplainLogTiming : google.protobuf.BoolValue
autoExplainLogTriggers : google.protobuf.BoolValue
autoExplainLogVerbose : google.protobuf.BoolValue
autoExplainLogNestedStatements : google.protobuf.BoolValue
autoExplainSampleRate : google.protobuf.DoubleValue
pgHintPlanEnableHint : google.protobuf.BoolValue
pgHintPlanEnableHintTable : google.protobuf.BoolValue
pgHintPlanDebugPrint : PgHintPlanDebugPrint
pgHintPlanMessageLevel : LogLevel
pgQualstatsEnabled : google.protobuf.BoolValue
pgQualstatsTrackConstants : google.protobuf.BoolValue
pgQualstatsMax : google.protobuf.Int64Value
pgQualstatsResolveOids : google.protobuf.BoolValue
pgQualstatsSampleRate : google.protobuf.DoubleValue
maxStackDepth : google.protobuf.Int64Value
in bytes.
geqo : google.protobuf.BoolValue
enable Genetic Query Optimizer, by default is on
geqoThreshold : google.protobuf.Int64Value
The number of tables to use geqo, default is 12
geqoEffort : google.protobuf.Int64Value
tradeoff between planning time and query plan quality, default is 5
geqoPoolSize : google.protobuf.Int64Value
number of individuals in the genetic population, useful values are typically 100 to 1000; default - 0 - choose based on based on geqo_effort
geqoGenerations : google.protobuf.Int64Value
the number of generations used by GEQO, useful values are in the same range as the pool size
geqoSelectionBias : google.protobuf.DoubleValue
selective pressure within the population
geqoSeed : google.protobuf.DoubleValue
initial value of the random number generator used by GEQO
pgTrgmSimilarityThreshold : google.protobuf.DoubleValue
pgTrgmWordSimilarityThreshold : google.protobuf.DoubleValue
pgTrgmStrictWordSimilarityThreshold : google.protobuf.DoubleValue
maxStandbyArchiveDelay : google.protobuf.Int64Value
in milliseconds.
sessionDurationTimeout : google.protobuf.Int64Value
Terminate any session that exceeds the designated timeout, specified in milliseconds. If a timeout is not specified, the default session timeout is set to 12 hours. To disable it, specify a value of 0.
logReplicationCommands : google.protobuf.BoolValue
logAutovacuumMinDuration : google.protobuf.Int64Value
in milliseconds. The default is 1000 (1 sec).
passwordEncryption : PasswordEncryption
A default value for user_password_encryption user-level setting, if it not specified for new users. Possible values are PASSWORD_ENCRYPTION_MD5 or PASSWORD_ENCRYPTION_SCRAM_SHA_256. The default is PASSWORD_ENCRYPTION_MD5.
PostgresqlConfig12_1C
Options and structure of PostgresqlConfig reflects PostgreSQL configuration file
parameters which detailed description is available in
PostgreSQL documentation.
BackslashQuote
BACKSLASH_QUOTE_UNSPECIFIEDBACKSLASH_QUOTEBACKSLASH_QUOTE_ONBACKSLASH_QUOTE_OFFBACKSLASH_QUOTE_SAFE_ENCODING
ByteaOutput
BYTEA_OUTPUT_UNSPECIFIEDBYTEA_OUTPUT_HEXBYTEA_OUTPUT_ESCAPED
ConstraintExclusion
CONSTRAINT_EXCLUSION_UNSPECIFIEDCONSTRAINT_EXCLUSION_ONCONSTRAINT_EXCLUSION_OFFCONSTRAINT_EXCLUSION_PARTITION
ForceParallelMode
FORCE_PARALLEL_MODE_UNSPECIFIEDFORCE_PARALLEL_MODE_ONFORCE_PARALLEL_MODE_OFFFORCE_PARALLEL_MODE_REGRESS
LogErrorVerbosity
LOG_ERROR_VERBOSITY_UNSPECIFIEDLOG_ERROR_VERBOSITY_TERSELOG_ERROR_VERBOSITY_DEFAULTLOG_ERROR_VERBOSITY_VERBOSE
LogLevel
LOG_LEVEL_UNSPECIFIEDLOG_LEVEL_DEBUG5LOG_LEVEL_DEBUG4LOG_LEVEL_DEBUG3LOG_LEVEL_DEBUG2LOG_LEVEL_DEBUG1LOG_LEVEL_LOGLOG_LEVEL_NOTICELOG_LEVEL_WARNINGLOG_LEVEL_ERRORLOG_LEVEL_FATALLOG_LEVEL_PANIC
LogStatement
LOG_STATEMENT_UNSPECIFIEDLOG_STATEMENT_NONELOG_STATEMENT_DDLLOG_STATEMENT_MODLOG_STATEMENT_ALL
PasswordEncryption
PASSWORD_ENCRYPTION_UNSPECIFIEDPASSWORD_ENCRYPTION_MD5PASSWORD_ENCRYPTION_SCRAM_SHA_256
PgHintPlanDebugPrint
PG_HINT_PLAN_DEBUG_PRINT_UNSPECIFIEDPG_HINT_PLAN_DEBUG_PRINT_OFFPG_HINT_PLAN_DEBUG_PRINT_ONPG_HINT_PLAN_DEBUG_PRINT_DETAILEDPG_HINT_PLAN_DEBUG_PRINT_VERBOSE
PlanCacheMode
PLAN_CACHE_MODE_UNSPECIFIEDPLAN_CACHE_MODE_AUTOPLAN_CACHE_MODE_FORCE_CUSTOM_PLANPLAN_CACHE_MODE_FORCE_GENERIC_PLAN
SharedPreloadLibraries
SHARED_PRELOAD_LIBRARIES_UNSPECIFIEDSHARED_PRELOAD_LIBRARIES_AUTO_EXPLAINSHARED_PRELOAD_LIBRARIES_PG_HINT_PLANSHARED_PRELOAD_LIBRARIES_TIMESCALEDBSHARED_PRELOAD_LIBRARIES_PG_QUALSTATSSHARED_PRELOAD_LIBRARIES_PG_CRONSHARED_PRELOAD_LIBRARIES_PGLOGICALSHARED_PRELOAD_LIBRARIES_PG_PREWARMSHARED_PRELOAD_LIBRARIES_PGAUDIT
SynchronousCommit
SYNCHRONOUS_COMMIT_UNSPECIFIEDSYNCHRONOUS_COMMIT_ONSYNCHRONOUS_COMMIT_OFFSYNCHRONOUS_COMMIT_LOCALSYNCHRONOUS_COMMIT_REMOTE_WRITESYNCHRONOUS_COMMIT_REMOTE_APPLY
TransactionIsolation
TRANSACTION_ISOLATION_UNSPECIFIEDTRANSACTION_ISOLATION_READ_UNCOMMITTEDTRANSACTION_ISOLATION_READ_COMMITTEDTRANSACTION_ISOLATION_REPEATABLE_READTRANSACTION_ISOLATION_SERIALIZABLE
WalLevel
WAL_LEVEL_UNSPECIFIEDWAL_LEVEL_REPLICAWAL_LEVEL_LOGICAL
XmlBinary
XML_BINARY_UNSPECIFIEDXML_BINARY_BASE64XML_BINARY_HEX
XmlOption
XML_OPTION_UNSPECIFIEDXML_OPTION_DOCUMENTXML_OPTION_CONTENT
maxConnections : google.protobuf.Int64Value
sharedBuffers : google.protobuf.Int64Value
in bytes.
tempBuffers : google.protobuf.Int64Value
in bytes.
maxPreparedTransactions : google.protobuf.Int64Value
workMem : google.protobuf.Int64Value
in bytes.
maintenanceWorkMem : google.protobuf.Int64Value
in bytes.
autovacuumWorkMem : google.protobuf.Int64Value
in bytes.
tempFileLimit : google.protobuf.Int64Value
in bytes.
vacuumCostDelay : google.protobuf.Int64Value
in milliseconds.
vacuumCostPageHit : google.protobuf.Int64Value
vacuumCostPageMiss : google.protobuf.Int64Value
vacuumCostPageDirty : google.protobuf.Int64Value
vacuumCostLimit : google.protobuf.Int64Value
bgwriterDelay : google.protobuf.Int64Value
in milliseconds.
bgwriterLruMaxpages : google.protobuf.Int64Value
bgwriterLruMultiplier : google.protobuf.DoubleValue
bgwriterFlushAfter : google.protobuf.Int64Value
in bytes
backendFlushAfter : google.protobuf.Int64Value
in bytes
oldSnapshotThreshold : google.protobuf.Int64Value
walLevel : WalLevel
synchronousCommit : SynchronousCommit
checkpointTimeout : google.protobuf.Int64Value
in milliseconds.
checkpointCompletionTarget : google.protobuf.DoubleValue
checkpointFlushAfter : google.protobuf.Int64Value
in bytes
maxWalSize : google.protobuf.Int64Value
in bytes.
minWalSize : google.protobuf.Int64Value
in bytes.
maxStandbyStreamingDelay : google.protobuf.Int64Value
in milliseconds.
defaultStatisticsTarget : google.protobuf.Int64Value
constraintExclusion : ConstraintExclusion
cursorTupleFraction : google.protobuf.DoubleValue
fromCollapseLimit : google.protobuf.Int64Value
joinCollapseLimit : google.protobuf.Int64Value
forceParallelMode : ForceParallelMode
clientMinMessages : LogLevel
logMinMessages : LogLevel
logMinErrorStatement : LogLevel
logMinDurationStatement : google.protobuf.Int64Value
in milliseconds.
logCheckpoints : google.protobuf.BoolValue
logConnections : google.protobuf.BoolValue
logDisconnections : google.protobuf.BoolValue
logDuration : google.protobuf.BoolValue
logErrorVerbosity : LogErrorVerbosity
logLockWaits : google.protobuf.BoolValue
logStatement : LogStatement
logTempFiles : google.protobuf.Int64Value
searchPath : string
rowSecurity : google.protobuf.BoolValue
defaultTransactionIsolation : TransactionIsolation
statementTimeout : google.protobuf.Int64Value
in milliseconds.
lockTimeout : google.protobuf.Int64Value
in milliseconds.
idleInTransactionSessionTimeout : google.protobuf.Int64Value
in milliseconds.
byteaOutput : ByteaOutput
xmlbinary : XmlBinary
xmloption : XmlOption
ginPendingListLimit : google.protobuf.Int64Value
in bytes.
deadlockTimeout : google.protobuf.Int64Value
in milliseconds.
maxLocksPerTransaction : google.protobuf.Int64Value
maxPredLocksPerTransaction : google.protobuf.Int64Value
arrayNulls : google.protobuf.BoolValue
backslashQuote : BackslashQuote
defaultWithOids : google.protobuf.BoolValue
escapeStringWarning : google.protobuf.BoolValue
loCompatPrivileges : google.protobuf.BoolValue
operatorPrecedenceWarning : google.protobuf.BoolValue
quoteAllIdentifiers : google.protobuf.BoolValue
standardConformingStrings : google.protobuf.BoolValue
synchronizeSeqscans : google.protobuf.BoolValue
transformNullEquals : google.protobuf.BoolValue
exitOnError : google.protobuf.BoolValue
seqPageCost : google.protobuf.DoubleValue
randomPageCost : google.protobuf.DoubleValue
autovacuumMaxWorkers : google.protobuf.Int64Value
autovacuumVacuumCostDelay : google.protobuf.Int64Value
autovacuumVacuumCostLimit : google.protobuf.Int64Value
autovacuumNaptime : google.protobuf.Int64Value
in milliseconds.
archiveTimeout : google.protobuf.Int64Value
in milliseconds.
trackActivityQuerySize : google.protobuf.Int64Value
onlineAnalyzeEnable : google.protobuf.BoolValue
enableBitmapscan : google.protobuf.BoolValue
enableHashagg : google.protobuf.BoolValue
enableHashjoin : google.protobuf.BoolValue
enableIndexscan : google.protobuf.BoolValue
enableIndexonlyscan : google.protobuf.BoolValue
enableMaterial : google.protobuf.BoolValue
enableMergejoin : google.protobuf.BoolValue
enableNestloop : google.protobuf.BoolValue
enableSeqscan : google.protobuf.BoolValue
enableSort : google.protobuf.BoolValue
enableTidscan : google.protobuf.BoolValue
maxWorkerProcesses : google.protobuf.Int64Value
maxParallelWorkers : google.protobuf.Int64Value
maxParallelWorkersPerGather : google.protobuf.Int64Value
autovacuumVacuumScaleFactor : google.protobuf.DoubleValue
autovacuumAnalyzeScaleFactor : google.protobuf.DoubleValue
defaultTransactionReadOnly : google.protobuf.BoolValue
timezone : string
enableParallelAppend : google.protobuf.BoolValue
enableParallelHash : google.protobuf.BoolValue
enablePartitionPruning : google.protobuf.BoolValue
enablePartitionwiseAggregate : google.protobuf.BoolValue
enablePartitionwiseJoin : google.protobuf.BoolValue
jit : google.protobuf.BoolValue
maxParallelMaintenanceWorkers : google.protobuf.Int64Value
parallelLeaderParticipation : google.protobuf.BoolValue
vacuumCleanupIndexScaleFactor : google.protobuf.DoubleValue
logTransactionSampleRate : google.protobuf.DoubleValue
planCacheMode : PlanCacheMode
effectiveIoConcurrency : google.protobuf.Int64Value
effectiveCacheSize : google.protobuf.Int64Value
sharedPreloadLibraries : SharedPreloadLibraries
autoExplainLogMinDuration : google.protobuf.Int64Value
in milliseconds.
autoExplainLogAnalyze : google.protobuf.BoolValue
autoExplainLogBuffers : google.protobuf.BoolValue
autoExplainLogTiming : google.protobuf.BoolValue
autoExplainLogTriggers : google.protobuf.BoolValue
autoExplainLogVerbose : google.protobuf.BoolValue
autoExplainLogNestedStatements : google.protobuf.BoolValue
autoExplainSampleRate : google.protobuf.DoubleValue
pgHintPlanEnableHint : google.protobuf.BoolValue
pgHintPlanEnableHintTable : google.protobuf.BoolValue
pgHintPlanDebugPrint : PgHintPlanDebugPrint
pgHintPlanMessageLevel : LogLevel
pgQualstatsEnabled : google.protobuf.BoolValue
pgQualstatsTrackConstants : google.protobuf.BoolValue
pgQualstatsMax : google.protobuf.Int64Value
pgQualstatsResolveOids : google.protobuf.BoolValue
pgQualstatsSampleRate : google.protobuf.DoubleValue
plantunerFixEmptyTable : google.protobuf.BoolValue
maxStackDepth : google.protobuf.Int64Value
in bytes.
geqo : google.protobuf.BoolValue
enable Genetic Query Optimizer, by default is on
geqoThreshold : google.protobuf.Int64Value
The number of tables to use geqo, default is 12
geqoEffort : google.protobuf.Int64Value
tradeoff between planning time and query plan quality, default is 5
geqoPoolSize : google.protobuf.Int64Value
number of individuals in the genetic population, useful values are typically 100 to 1000; default - 0 - choose based on based on geqo_effort
geqoGenerations : google.protobuf.Int64Value
the number of generations used by GEQO, useful values are in the same range as the pool size
geqoSelectionBias : google.protobuf.DoubleValue
selective pressure within the population
geqoSeed : google.protobuf.DoubleValue
initial value of the random number generator used by GEQO
pgTrgmSimilarityThreshold : google.protobuf.DoubleValue
pgTrgmWordSimilarityThreshold : google.protobuf.DoubleValue
pgTrgmStrictWordSimilarityThreshold : google.protobuf.DoubleValue
maxStandbyArchiveDelay : google.protobuf.Int64Value
in milliseconds.
sessionDurationTimeout : google.protobuf.Int64Value
Terminate any session that exceeds the designated timeout, specified in milliseconds. If a timeout is not specified, the default session timeout is set to 12 hours. To disable it, specify a value of 0.
logReplicationCommands : google.protobuf.BoolValue
logAutovacuumMinDuration : google.protobuf.Int64Value
in milliseconds. The default is 1000 (1 sec).
passwordEncryption : PasswordEncryption
A default value for user_password_encryption user-level setting, if it not specified for new users. Possible values are PASSWORD_ENCRYPTION_MD5 or PASSWORD_ENCRYPTION_SCRAM_SHA_256. The default is PASSWORD_ENCRYPTION_MD5.
PostgresqlConfig13
Options and structure of PostgresqlConfig reflects PostgreSQL configuration file
parameters which detailed description is available in
PostgreSQL documentation.
BackslashQuote
BACKSLASH_QUOTE_UNSPECIFIEDBACKSLASH_QUOTEBACKSLASH_QUOTE_ONBACKSLASH_QUOTE_OFFBACKSLASH_QUOTE_SAFE_ENCODING
ByteaOutput
BYTEA_OUTPUT_UNSPECIFIEDBYTEA_OUTPUT_HEXBYTEA_OUTPUT_ESCAPED
ConstraintExclusion
CONSTRAINT_EXCLUSION_UNSPECIFIEDCONSTRAINT_EXCLUSION_ONCONSTRAINT_EXCLUSION_OFFCONSTRAINT_EXCLUSION_PARTITION
ForceParallelMode
FORCE_PARALLEL_MODE_UNSPECIFIEDFORCE_PARALLEL_MODE_ONFORCE_PARALLEL_MODE_OFFFORCE_PARALLEL_MODE_REGRESS
LogErrorVerbosity
LOG_ERROR_VERBOSITY_UNSPECIFIEDLOG_ERROR_VERBOSITY_TERSELOG_ERROR_VERBOSITY_DEFAULTLOG_ERROR_VERBOSITY_VERBOSE
LogLevel
LOG_LEVEL_UNSPECIFIEDLOG_LEVEL_DEBUG5LOG_LEVEL_DEBUG4LOG_LEVEL_DEBUG3LOG_LEVEL_DEBUG2LOG_LEVEL_DEBUG1LOG_LEVEL_LOGLOG_LEVEL_NOTICELOG_LEVEL_WARNINGLOG_LEVEL_ERRORLOG_LEVEL_FATALLOG_LEVEL_PANIC
LogStatement
LOG_STATEMENT_UNSPECIFIEDLOG_STATEMENT_NONELOG_STATEMENT_DDLLOG_STATEMENT_MODLOG_STATEMENT_ALL
PasswordEncryption
PASSWORD_ENCRYPTION_UNSPECIFIEDPASSWORD_ENCRYPTION_MD5PASSWORD_ENCRYPTION_SCRAM_SHA_256
PgHintPlanDebugPrint
PG_HINT_PLAN_DEBUG_PRINT_UNSPECIFIEDPG_HINT_PLAN_DEBUG_PRINT_OFFPG_HINT_PLAN_DEBUG_PRINT_ONPG_HINT_PLAN_DEBUG_PRINT_DETAILEDPG_HINT_PLAN_DEBUG_PRINT_VERBOSE
PlanCacheMode
PLAN_CACHE_MODE_UNSPECIFIEDPLAN_CACHE_MODE_AUTOPLAN_CACHE_MODE_FORCE_CUSTOM_PLANPLAN_CACHE_MODE_FORCE_GENERIC_PLAN
SharedPreloadLibraries
SHARED_PRELOAD_LIBRARIES_UNSPECIFIEDSHARED_PRELOAD_LIBRARIES_AUTO_EXPLAINSHARED_PRELOAD_LIBRARIES_PG_HINT_PLANSHARED_PRELOAD_LIBRARIES_TIMESCALEDBSHARED_PRELOAD_LIBRARIES_PG_QUALSTATSSHARED_PRELOAD_LIBRARIES_PG_CRONSHARED_PRELOAD_LIBRARIES_PGLOGICALSHARED_PRELOAD_LIBRARIES_PG_PREWARMSHARED_PRELOAD_LIBRARIES_PGAUDIT
SynchronousCommit
SYNCHRONOUS_COMMIT_UNSPECIFIEDSYNCHRONOUS_COMMIT_ONSYNCHRONOUS_COMMIT_OFFSYNCHRONOUS_COMMIT_LOCALSYNCHRONOUS_COMMIT_REMOTE_WRITESYNCHRONOUS_COMMIT_REMOTE_APPLY
TransactionIsolation
TRANSACTION_ISOLATION_UNSPECIFIEDTRANSACTION_ISOLATION_READ_UNCOMMITTEDTRANSACTION_ISOLATION_READ_COMMITTEDTRANSACTION_ISOLATION_REPEATABLE_READTRANSACTION_ISOLATION_SERIALIZABLE
WalLevel
WAL_LEVEL_UNSPECIFIEDWAL_LEVEL_REPLICAWAL_LEVEL_LOGICAL
XmlBinary
XML_BINARY_UNSPECIFIEDXML_BINARY_BASE64XML_BINARY_HEX
XmlOption
XML_OPTION_UNSPECIFIEDXML_OPTION_DOCUMENTXML_OPTION_CONTENT
maxConnections : google.protobuf.Int64Value
sharedBuffers : google.protobuf.Int64Value
in bytes.
tempBuffers : google.protobuf.Int64Value
in bytes.
maxPreparedTransactions : google.protobuf.Int64Value
workMem : google.protobuf.Int64Value
in bytes.
maintenanceWorkMem : google.protobuf.Int64Value
in bytes.
autovacuumWorkMem : google.protobuf.Int64Value
in bytes.
tempFileLimit : google.protobuf.Int64Value
in bytes.
vacuumCostDelay : google.protobuf.Int64Value
in milliseconds.
vacuumCostPageHit : google.protobuf.Int64Value
vacuumCostPageMiss : google.protobuf.Int64Value
vacuumCostPageDirty : google.protobuf.Int64Value
vacuumCostLimit : google.protobuf.Int64Value
bgwriterDelay : google.protobuf.Int64Value
in milliseconds.
bgwriterLruMaxpages : google.protobuf.Int64Value
bgwriterLruMultiplier : google.protobuf.DoubleValue
bgwriterFlushAfter : google.protobuf.Int64Value
in bytes
backendFlushAfter : google.protobuf.Int64Value
in bytes
oldSnapshotThreshold : google.protobuf.Int64Value
walLevel : WalLevel
synchronousCommit : SynchronousCommit
checkpointTimeout : google.protobuf.Int64Value
in milliseconds.
checkpointCompletionTarget : google.protobuf.DoubleValue
checkpointFlushAfter : google.protobuf.Int64Value
in bytes
maxWalSize : google.protobuf.Int64Value
in bytes.
minWalSize : google.protobuf.Int64Value
in bytes.
maxStandbyStreamingDelay : google.protobuf.Int64Value
in milliseconds.
defaultStatisticsTarget : google.protobuf.Int64Value
constraintExclusion : ConstraintExclusion
cursorTupleFraction : google.protobuf.DoubleValue
fromCollapseLimit : google.protobuf.Int64Value
joinCollapseLimit : google.protobuf.Int64Value
forceParallelMode : ForceParallelMode
clientMinMessages : LogLevel
logMinMessages : LogLevel
logMinErrorStatement : LogLevel
logMinDurationStatement : google.protobuf.Int64Value
in milliseconds.
logCheckpoints : google.protobuf.BoolValue
logConnections : google.protobuf.BoolValue
logDisconnections : google.protobuf.BoolValue
logDuration : google.protobuf.BoolValue
logErrorVerbosity : LogErrorVerbosity
logLockWaits : google.protobuf.BoolValue
logStatement : LogStatement
logTempFiles : google.protobuf.Int64Value
searchPath : string
rowSecurity : google.protobuf.BoolValue
defaultTransactionIsolation : TransactionIsolation
statementTimeout : google.protobuf.Int64Value
in milliseconds.
lockTimeout : google.protobuf.Int64Value
in milliseconds.
idleInTransactionSessionTimeout : google.protobuf.Int64Value
in milliseconds.
byteaOutput : ByteaOutput
xmlbinary : XmlBinary
xmloption : XmlOption
ginPendingListLimit : google.protobuf.Int64Value
in bytes.
deadlockTimeout : google.protobuf.Int64Value
in milliseconds.
maxLocksPerTransaction : google.protobuf.Int64Value
maxPredLocksPerTransaction : google.protobuf.Int64Value
arrayNulls : google.protobuf.BoolValue
backslashQuote : BackslashQuote
defaultWithOids : google.protobuf.BoolValue
escapeStringWarning : google.protobuf.BoolValue
loCompatPrivileges : google.protobuf.BoolValue
operatorPrecedenceWarning : google.protobuf.BoolValue
quoteAllIdentifiers : google.protobuf.BoolValue
standardConformingStrings : google.protobuf.BoolValue
synchronizeSeqscans : google.protobuf.BoolValue
transformNullEquals : google.protobuf.BoolValue
exitOnError : google.protobuf.BoolValue
seqPageCost : google.protobuf.DoubleValue
randomPageCost : google.protobuf.DoubleValue
autovacuumMaxWorkers : google.protobuf.Int64Value
autovacuumVacuumCostDelay : google.protobuf.Int64Value
autovacuumVacuumCostLimit : google.protobuf.Int64Value
autovacuumNaptime : google.protobuf.Int64Value
in milliseconds.
archiveTimeout : google.protobuf.Int64Value
in milliseconds.
trackActivityQuerySize : google.protobuf.Int64Value
enableBitmapscan : google.protobuf.BoolValue
enableHashagg : google.protobuf.BoolValue
enableHashjoin : google.protobuf.BoolValue
enableIndexscan : google.protobuf.BoolValue
enableIndexonlyscan : google.protobuf.BoolValue
enableMaterial : google.protobuf.BoolValue
enableMergejoin : google.protobuf.BoolValue
enableNestloop : google.protobuf.BoolValue
enableSeqscan : google.protobuf.BoolValue
enableSort : google.protobuf.BoolValue
enableTidscan : google.protobuf.BoolValue
maxWorkerProcesses : google.protobuf.Int64Value
maxParallelWorkers : google.protobuf.Int64Value
maxParallelWorkersPerGather : google.protobuf.Int64Value
autovacuumVacuumScaleFactor : google.protobuf.DoubleValue
autovacuumAnalyzeScaleFactor : google.protobuf.DoubleValue
defaultTransactionReadOnly : google.protobuf.BoolValue
timezone : string
enableParallelAppend : google.protobuf.BoolValue
enableParallelHash : google.protobuf.BoolValue
enablePartitionPruning : google.protobuf.BoolValue
enablePartitionwiseAggregate : google.protobuf.BoolValue
enablePartitionwiseJoin : google.protobuf.BoolValue
jit : google.protobuf.BoolValue
maxParallelMaintenanceWorkers : google.protobuf.Int64Value
parallelLeaderParticipation : google.protobuf.BoolValue
vacuumCleanupIndexScaleFactor : google.protobuf.DoubleValue
logTransactionSampleRate : google.protobuf.DoubleValue
planCacheMode : PlanCacheMode
effectiveIoConcurrency : google.protobuf.Int64Value
effectiveCacheSize : google.protobuf.Int64Value
sharedPreloadLibraries : SharedPreloadLibraries
autoExplainLogMinDuration : google.protobuf.Int64Value
in milliseconds.
autoExplainLogAnalyze : google.protobuf.BoolValue
autoExplainLogBuffers : google.protobuf.BoolValue
autoExplainLogTiming : google.protobuf.BoolValue
autoExplainLogTriggers : google.protobuf.BoolValue
autoExplainLogVerbose : google.protobuf.BoolValue
autoExplainLogNestedStatements : google.protobuf.BoolValue
autoExplainSampleRate : google.protobuf.DoubleValue
pgHintPlanEnableHint : google.protobuf.BoolValue
pgHintPlanEnableHintTable : google.protobuf.BoolValue
pgHintPlanDebugPrint : PgHintPlanDebugPrint
pgHintPlanMessageLevel : LogLevel
hashMemMultiplier : google.protobuf.DoubleValue
logicalDecodingWorkMem : google.protobuf.Int64Value
in bytes.
maintenanceIoConcurrency : google.protobuf.Int64Value
maxSlotWalKeepSize : google.protobuf.Int64Value
in bytes.
walKeepSize : google.protobuf.Int64Value
in bytes.
enableIncrementalSort : google.protobuf.BoolValue
autovacuumVacuumInsertThreshold : google.protobuf.Int64Value
autovacuumVacuumInsertScaleFactor : google.protobuf.DoubleValue
logMinDurationSample : google.protobuf.Int64Value
in milliseconds.
logStatementSampleRate : google.protobuf.DoubleValue
logParameterMaxLength : google.protobuf.Int64Value
in bytes.
logParameterMaxLengthOnError : google.protobuf.Int64Value
in bytes.
pgQualstatsEnabled : google.protobuf.BoolValue
pgQualstatsTrackConstants : google.protobuf.BoolValue
pgQualstatsMax : google.protobuf.Int64Value
pgQualstatsResolveOids : google.protobuf.BoolValue
pgQualstatsSampleRate : google.protobuf.DoubleValue
maxStackDepth : google.protobuf.Int64Value
in bytes.
geqo : google.protobuf.BoolValue
enable Genetic Query Optimizer, by default is on
geqoThreshold : google.protobuf.Int64Value
The number of tables to use geqo, default is 12
geqoEffort : google.protobuf.Int64Value
tradeoff between planning time and query plan quality, default is 5
geqoPoolSize : google.protobuf.Int64Value
number of individuals in the genetic population, useful values are typically 100 to 1000; default - 0 - choose based on based on geqo_effort
geqoGenerations : google.protobuf.Int64Value
the number of generations used by GEQO, useful values are in the same range as the pool size
geqoSelectionBias : google.protobuf.DoubleValue
selective pressure within the population
geqoSeed : google.protobuf.DoubleValue
initial value of the random number generator used by GEQO
pgTrgmSimilarityThreshold : google.protobuf.DoubleValue
pgTrgmWordSimilarityThreshold : google.protobuf.DoubleValue
pgTrgmStrictWordSimilarityThreshold : google.protobuf.DoubleValue
maxStandbyArchiveDelay : google.protobuf.Int64Value
in milliseconds.
sessionDurationTimeout : google.protobuf.Int64Value
Terminate any session that exceeds the designated timeout, specified in milliseconds. If a timeout is not specified, the default session timeout is set to 12 hours. To disable it, specify a value of 0.
logReplicationCommands : google.protobuf.BoolValue
logAutovacuumMinDuration : google.protobuf.Int64Value
in milliseconds. The default is 1000 (1 sec).
passwordEncryption : PasswordEncryption
A default value for user_password_encryption user-level setting, if it not specified for new users. Possible values are PASSWORD_ENCRYPTION_MD5 or PASSWORD_ENCRYPTION_SCRAM_SHA_256. The default is PASSWORD_ENCRYPTION_MD5.
PostgresqlConfig13_1C
Options and structure of PostgresqlConfig reflects PostgreSQL configuration file
parameters which detailed description is available in
PostgreSQL documentation.
BackslashQuote
BACKSLASH_QUOTE_UNSPECIFIEDBACKSLASH_QUOTEBACKSLASH_QUOTE_ONBACKSLASH_QUOTE_OFFBACKSLASH_QUOTE_SAFE_ENCODING
ByteaOutput
BYTEA_OUTPUT_UNSPECIFIEDBYTEA_OUTPUT_HEXBYTEA_OUTPUT_ESCAPED
ConstraintExclusion
CONSTRAINT_EXCLUSION_UNSPECIFIEDCONSTRAINT_EXCLUSION_ONCONSTRAINT_EXCLUSION_OFFCONSTRAINT_EXCLUSION_PARTITION
ForceParallelMode
FORCE_PARALLEL_MODE_UNSPECIFIEDFORCE_PARALLEL_MODE_ONFORCE_PARALLEL_MODE_OFFFORCE_PARALLEL_MODE_REGRESS
LogErrorVerbosity
LOG_ERROR_VERBOSITY_UNSPECIFIEDLOG_ERROR_VERBOSITY_TERSELOG_ERROR_VERBOSITY_DEFAULTLOG_ERROR_VERBOSITY_VERBOSE
LogLevel
LOG_LEVEL_UNSPECIFIEDLOG_LEVEL_DEBUG5LOG_LEVEL_DEBUG4LOG_LEVEL_DEBUG3LOG_LEVEL_DEBUG2LOG_LEVEL_DEBUG1LOG_LEVEL_LOGLOG_LEVEL_NOTICELOG_LEVEL_WARNINGLOG_LEVEL_ERRORLOG_LEVEL_FATALLOG_LEVEL_PANIC
LogStatement
LOG_STATEMENT_UNSPECIFIEDLOG_STATEMENT_NONELOG_STATEMENT_DDLLOG_STATEMENT_MODLOG_STATEMENT_ALL
PasswordEncryption
PASSWORD_ENCRYPTION_UNSPECIFIEDPASSWORD_ENCRYPTION_MD5PASSWORD_ENCRYPTION_SCRAM_SHA_256
PgHintPlanDebugPrint
PG_HINT_PLAN_DEBUG_PRINT_UNSPECIFIEDPG_HINT_PLAN_DEBUG_PRINT_OFFPG_HINT_PLAN_DEBUG_PRINT_ONPG_HINT_PLAN_DEBUG_PRINT_DETAILEDPG_HINT_PLAN_DEBUG_PRINT_VERBOSE
PlanCacheMode
PLAN_CACHE_MODE_UNSPECIFIEDPLAN_CACHE_MODE_AUTOPLAN_CACHE_MODE_FORCE_CUSTOM_PLANPLAN_CACHE_MODE_FORCE_GENERIC_PLAN
SharedPreloadLibraries
SHARED_PRELOAD_LIBRARIES_UNSPECIFIEDSHARED_PRELOAD_LIBRARIES_AUTO_EXPLAINSHARED_PRELOAD_LIBRARIES_PG_HINT_PLANSHARED_PRELOAD_LIBRARIES_TIMESCALEDBSHARED_PRELOAD_LIBRARIES_PG_QUALSTATSSHARED_PRELOAD_LIBRARIES_PG_CRONSHARED_PRELOAD_LIBRARIES_PGLOGICALSHARED_PRELOAD_LIBRARIES_PG_PREWARMSHARED_PRELOAD_LIBRARIES_PGAUDIT
SynchronousCommit
SYNCHRONOUS_COMMIT_UNSPECIFIEDSYNCHRONOUS_COMMIT_ONSYNCHRONOUS_COMMIT_OFFSYNCHRONOUS_COMMIT_LOCALSYNCHRONOUS_COMMIT_REMOTE_WRITESYNCHRONOUS_COMMIT_REMOTE_APPLY
TransactionIsolation
TRANSACTION_ISOLATION_UNSPECIFIEDTRANSACTION_ISOLATION_READ_UNCOMMITTEDTRANSACTION_ISOLATION_READ_COMMITTEDTRANSACTION_ISOLATION_REPEATABLE_READTRANSACTION_ISOLATION_SERIALIZABLE
WalLevel
WAL_LEVEL_UNSPECIFIEDWAL_LEVEL_REPLICAWAL_LEVEL_LOGICAL
XmlBinary
XML_BINARY_UNSPECIFIEDXML_BINARY_BASE64XML_BINARY_HEX
XmlOption
XML_OPTION_UNSPECIFIEDXML_OPTION_DOCUMENTXML_OPTION_CONTENT
maxConnections : google.protobuf.Int64Value
sharedBuffers : google.protobuf.Int64Value
in bytes.
tempBuffers : google.protobuf.Int64Value
in bytes.
maxPreparedTransactions : google.protobuf.Int64Value
workMem : google.protobuf.Int64Value
in bytes.
maintenanceWorkMem : google.protobuf.Int64Value
in bytes.
autovacuumWorkMem : google.protobuf.Int64Value
in bytes.
tempFileLimit : google.protobuf.Int64Value
in bytes.
vacuumCostDelay : google.protobuf.Int64Value
in milliseconds.
vacuumCostPageHit : google.protobuf.Int64Value
vacuumCostPageMiss : google.protobuf.Int64Value
vacuumCostPageDirty : google.protobuf.Int64Value
vacuumCostLimit : google.protobuf.Int64Value
bgwriterDelay : google.protobuf.Int64Value
in milliseconds.
bgwriterLruMaxpages : google.protobuf.Int64Value
bgwriterLruMultiplier : google.protobuf.DoubleValue
bgwriterFlushAfter : google.protobuf.Int64Value
in bytes
backendFlushAfter : google.protobuf.Int64Value
in bytes
oldSnapshotThreshold : google.protobuf.Int64Value
walLevel : WalLevel
synchronousCommit : SynchronousCommit
checkpointTimeout : google.protobuf.Int64Value
in milliseconds.
checkpointCompletionTarget : google.protobuf.DoubleValue
checkpointFlushAfter : google.protobuf.Int64Value
in bytes
maxWalSize : google.protobuf.Int64Value
in bytes.
minWalSize : google.protobuf.Int64Value
in bytes.
maxStandbyStreamingDelay : google.protobuf.Int64Value
in milliseconds.
defaultStatisticsTarget : google.protobuf.Int64Value
constraintExclusion : ConstraintExclusion
cursorTupleFraction : google.protobuf.DoubleValue
fromCollapseLimit : google.protobuf.Int64Value
joinCollapseLimit : google.protobuf.Int64Value
forceParallelMode : ForceParallelMode
clientMinMessages : LogLevel
logMinMessages : LogLevel
logMinErrorStatement : LogLevel
logMinDurationStatement : google.protobuf.Int64Value
in milliseconds.
logCheckpoints : google.protobuf.BoolValue
logConnections : google.protobuf.BoolValue
logDisconnections : google.protobuf.BoolValue
logDuration : google.protobuf.BoolValue
logErrorVerbosity : LogErrorVerbosity
logLockWaits : google.protobuf.BoolValue
logStatement : LogStatement
logTempFiles : google.protobuf.Int64Value
searchPath : string
rowSecurity : google.protobuf.BoolValue
defaultTransactionIsolation : TransactionIsolation
statementTimeout : google.protobuf.Int64Value
in milliseconds.
lockTimeout : google.protobuf.Int64Value
in milliseconds.
idleInTransactionSessionTimeout : google.protobuf.Int64Value
in milliseconds.
byteaOutput : ByteaOutput
xmlbinary : XmlBinary
xmloption : XmlOption
ginPendingListLimit : google.protobuf.Int64Value
in bytes.
deadlockTimeout : google.protobuf.Int64Value
in milliseconds.
maxLocksPerTransaction : google.protobuf.Int64Value
maxPredLocksPerTransaction : google.protobuf.Int64Value
arrayNulls : google.protobuf.BoolValue
backslashQuote : BackslashQuote
defaultWithOids : google.protobuf.BoolValue
escapeStringWarning : google.protobuf.BoolValue
loCompatPrivileges : google.protobuf.BoolValue
operatorPrecedenceWarning : google.protobuf.BoolValue
quoteAllIdentifiers : google.protobuf.BoolValue
standardConformingStrings : google.protobuf.BoolValue
synchronizeSeqscans : google.protobuf.BoolValue
transformNullEquals : google.protobuf.BoolValue
exitOnError : google.protobuf.BoolValue
seqPageCost : google.protobuf.DoubleValue
randomPageCost : google.protobuf.DoubleValue
autovacuumMaxWorkers : google.protobuf.Int64Value
autovacuumVacuumCostDelay : google.protobuf.Int64Value
autovacuumVacuumCostLimit : google.protobuf.Int64Value
autovacuumNaptime : google.protobuf.Int64Value
in milliseconds.
archiveTimeout : google.protobuf.Int64Value
in milliseconds.
trackActivityQuerySize : google.protobuf.Int64Value
onlineAnalyzeEnable : google.protobuf.BoolValue
enableBitmapscan : google.protobuf.BoolValue
enableHashagg : google.protobuf.BoolValue
enableHashjoin : google.protobuf.BoolValue
enableIndexscan : google.protobuf.BoolValue
enableIndexonlyscan : google.protobuf.BoolValue
enableMaterial : google.protobuf.BoolValue
enableMergejoin : google.protobuf.BoolValue
enableNestloop : google.protobuf.BoolValue
enableSeqscan : google.protobuf.BoolValue
enableSort : google.protobuf.BoolValue
enableTidscan : google.protobuf.BoolValue
maxWorkerProcesses : google.protobuf.Int64Value
maxParallelWorkers : google.protobuf.Int64Value
maxParallelWorkersPerGather : google.protobuf.Int64Value
autovacuumVacuumScaleFactor : google.protobuf.DoubleValue
autovacuumAnalyzeScaleFactor : google.protobuf.DoubleValue
defaultTransactionReadOnly : google.protobuf.BoolValue
timezone : string
enableParallelAppend : google.protobuf.BoolValue
enableParallelHash : google.protobuf.BoolValue
enablePartitionPruning : google.protobuf.BoolValue
enablePartitionwiseAggregate : google.protobuf.BoolValue
enablePartitionwiseJoin : google.protobuf.BoolValue
jit : google.protobuf.BoolValue
maxParallelMaintenanceWorkers : google.protobuf.Int64Value
parallelLeaderParticipation : google.protobuf.BoolValue
vacuumCleanupIndexScaleFactor : google.protobuf.DoubleValue
logTransactionSampleRate : google.protobuf.DoubleValue
planCacheMode : PlanCacheMode
effectiveIoConcurrency : google.protobuf.Int64Value
effectiveCacheSize : google.protobuf.Int64Value
sharedPreloadLibraries : SharedPreloadLibraries
autoExplainLogMinDuration : google.protobuf.Int64Value
in milliseconds.
autoExplainLogAnalyze : google.protobuf.BoolValue
autoExplainLogBuffers : google.protobuf.BoolValue
autoExplainLogTiming : google.protobuf.BoolValue
autoExplainLogTriggers : google.protobuf.BoolValue
autoExplainLogVerbose : google.protobuf.BoolValue
autoExplainLogNestedStatements : google.protobuf.BoolValue
autoExplainSampleRate : google.protobuf.DoubleValue
pgHintPlanEnableHint : google.protobuf.BoolValue
pgHintPlanEnableHintTable : google.protobuf.BoolValue
pgHintPlanDebugPrint : PgHintPlanDebugPrint
pgHintPlanMessageLevel : LogLevel
hashMemMultiplier : google.protobuf.DoubleValue
logicalDecodingWorkMem : google.protobuf.Int64Value
in bytes.
maintenanceIoConcurrency : google.protobuf.Int64Value
maxSlotWalKeepSize : google.protobuf.Int64Value
in bytes.
walKeepSize : google.protobuf.Int64Value
in bytes.
enableIncrementalSort : google.protobuf.BoolValue
autovacuumVacuumInsertThreshold : google.protobuf.Int64Value
autovacuumVacuumInsertScaleFactor : google.protobuf.DoubleValue
logMinDurationSample : google.protobuf.Int64Value
in milliseconds.
logStatementSampleRate : google.protobuf.DoubleValue
logParameterMaxLength : google.protobuf.Int64Value
in bytes.
logParameterMaxLengthOnError : google.protobuf.Int64Value
in bytes.
pgQualstatsEnabled : google.protobuf.BoolValue
pgQualstatsTrackConstants : google.protobuf.BoolValue
pgQualstatsMax : google.protobuf.Int64Value
pgQualstatsResolveOids : google.protobuf.BoolValue
pgQualstatsSampleRate : google.protobuf.DoubleValue
plantunerFixEmptyTable : google.protobuf.BoolValue
geqo : google.protobuf.BoolValue
enable Genetic Query Optimizer, by default is on
geqoThreshold : google.protobuf.Int64Value
The number of tables to use geqo, default is 12
geqoEffort : google.protobuf.Int64Value
tradeoff between planning time and query plan quality, default is 5
geqoPoolSize : google.protobuf.Int64Value
number of individuals in the genetic population, useful values are typically 100 to 1000; default - 0 - choose based on based on geqo_effort
geqoGenerations : google.protobuf.Int64Value
the number of generations used by GEQO, useful values are in the same range as the pool size
geqoSelectionBias : google.protobuf.DoubleValue
selective pressure within the population
geqoSeed : google.protobuf.DoubleValue
initial value of the random number generator used by GEQO
pgTrgmSimilarityThreshold : google.protobuf.DoubleValue
pgTrgmWordSimilarityThreshold : google.protobuf.DoubleValue
pgTrgmStrictWordSimilarityThreshold : google.protobuf.DoubleValue
maxStandbyArchiveDelay : google.protobuf.Int64Value
in milliseconds.
sessionDurationTimeout : google.protobuf.Int64Value
Terminate any session that exceeds the designated timeout, specified in milliseconds. If a timeout is not specified, the default session timeout is set to 12 hours. To disable it, specify a value of 0.
logReplicationCommands : google.protobuf.BoolValue
logAutovacuumMinDuration : google.protobuf.Int64Value
in milliseconds. The default is 1000 (1 sec).
passwordEncryption : PasswordEncryption
A default value for user_password_encryption user-level setting, if it not specified for new users. Possible values are PASSWORD_ENCRYPTION_MD5 or PASSWORD_ENCRYPTION_SCRAM_SHA_256. The default is PASSWORD_ENCRYPTION_MD5.
PostgresqlConfig14
Options and structure of PostgresqlConfig reflects PostgreSQL configuration file
parameters which detailed description is available in
PostgreSQL documentation.
BackslashQuote
BACKSLASH_QUOTE_UNSPECIFIEDBACKSLASH_QUOTEBACKSLASH_QUOTE_ONBACKSLASH_QUOTE_OFFBACKSLASH_QUOTE_SAFE_ENCODING
ByteaOutput
BYTEA_OUTPUT_UNSPECIFIEDBYTEA_OUTPUT_HEXBYTEA_OUTPUT_ESCAPED
ConstraintExclusion
CONSTRAINT_EXCLUSION_UNSPECIFIEDCONSTRAINT_EXCLUSION_ONCONSTRAINT_EXCLUSION_OFFCONSTRAINT_EXCLUSION_PARTITION
ForceParallelMode
FORCE_PARALLEL_MODE_UNSPECIFIEDFORCE_PARALLEL_MODE_ONFORCE_PARALLEL_MODE_OFFFORCE_PARALLEL_MODE_REGRESS
LogErrorVerbosity
LOG_ERROR_VERBOSITY_UNSPECIFIEDLOG_ERROR_VERBOSITY_TERSELOG_ERROR_VERBOSITY_DEFAULTLOG_ERROR_VERBOSITY_VERBOSE
LogLevel
LOG_LEVEL_UNSPECIFIEDLOG_LEVEL_DEBUG5LOG_LEVEL_DEBUG4LOG_LEVEL_DEBUG3LOG_LEVEL_DEBUG2LOG_LEVEL_DEBUG1LOG_LEVEL_LOGLOG_LEVEL_NOTICELOG_LEVEL_WARNINGLOG_LEVEL_ERRORLOG_LEVEL_FATALLOG_LEVEL_PANIC
LogStatement
LOG_STATEMENT_UNSPECIFIEDLOG_STATEMENT_NONELOG_STATEMENT_DDLLOG_STATEMENT_MODLOG_STATEMENT_ALL
PasswordEncryption
PASSWORD_ENCRYPTION_UNSPECIFIEDPASSWORD_ENCRYPTION_MD5PASSWORD_ENCRYPTION_SCRAM_SHA_256
PgHintPlanDebugPrint
PG_HINT_PLAN_DEBUG_PRINT_UNSPECIFIEDPG_HINT_PLAN_DEBUG_PRINT_OFFPG_HINT_PLAN_DEBUG_PRINT_ONPG_HINT_PLAN_DEBUG_PRINT_DETAILEDPG_HINT_PLAN_DEBUG_PRINT_VERBOSE
PlanCacheMode
PLAN_CACHE_MODE_UNSPECIFIEDPLAN_CACHE_MODE_AUTOPLAN_CACHE_MODE_FORCE_CUSTOM_PLANPLAN_CACHE_MODE_FORCE_GENERIC_PLAN
SharedPreloadLibraries
SHARED_PRELOAD_LIBRARIES_UNSPECIFIEDSHARED_PRELOAD_LIBRARIES_AUTO_EXPLAINSHARED_PRELOAD_LIBRARIES_PG_HINT_PLANSHARED_PRELOAD_LIBRARIES_TIMESCALEDBSHARED_PRELOAD_LIBRARIES_PG_QUALSTATSSHARED_PRELOAD_LIBRARIES_PG_CRONSHARED_PRELOAD_LIBRARIES_PGLOGICALSHARED_PRELOAD_LIBRARIES_PG_PREWARMSHARED_PRELOAD_LIBRARIES_PGAUDIT
SynchronousCommit
SYNCHRONOUS_COMMIT_UNSPECIFIEDSYNCHRONOUS_COMMIT_ONSYNCHRONOUS_COMMIT_OFFSYNCHRONOUS_COMMIT_LOCALSYNCHRONOUS_COMMIT_REMOTE_WRITESYNCHRONOUS_COMMIT_REMOTE_APPLY
TransactionIsolation
TRANSACTION_ISOLATION_UNSPECIFIEDTRANSACTION_ISOLATION_READ_UNCOMMITTEDTRANSACTION_ISOLATION_READ_COMMITTEDTRANSACTION_ISOLATION_REPEATABLE_READTRANSACTION_ISOLATION_SERIALIZABLE
WalLevel
WAL_LEVEL_UNSPECIFIEDWAL_LEVEL_REPLICAWAL_LEVEL_LOGICAL
XmlBinary
XML_BINARY_UNSPECIFIEDXML_BINARY_BASE64XML_BINARY_HEX
XmlOption
XML_OPTION_UNSPECIFIEDXML_OPTION_DOCUMENTXML_OPTION_CONTENT
maxConnections : google.protobuf.Int64Value
sharedBuffers : google.protobuf.Int64Value
in bytes.
tempBuffers : google.protobuf.Int64Value
in bytes.
maxPreparedTransactions : google.protobuf.Int64Value
workMem : google.protobuf.Int64Value
in bytes.
maintenanceWorkMem : google.protobuf.Int64Value
in bytes.
autovacuumWorkMem : google.protobuf.Int64Value
in bytes.
tempFileLimit : google.protobuf.Int64Value
in bytes.
vacuumCostDelay : google.protobuf.Int64Value
in milliseconds.
vacuumCostPageHit : google.protobuf.Int64Value
vacuumCostPageMiss : google.protobuf.Int64Value
vacuumCostPageDirty : google.protobuf.Int64Value
vacuumCostLimit : google.protobuf.Int64Value
bgwriterDelay : google.protobuf.Int64Value
in milliseconds.
bgwriterLruMaxpages : google.protobuf.Int64Value
bgwriterLruMultiplier : google.protobuf.DoubleValue
bgwriterFlushAfter : google.protobuf.Int64Value
in bytes
backendFlushAfter : google.protobuf.Int64Value
in bytes
oldSnapshotThreshold : google.protobuf.Int64Value
walLevel : WalLevel
synchronousCommit : SynchronousCommit
checkpointTimeout : google.protobuf.Int64Value
in milliseconds.
checkpointCompletionTarget : google.protobuf.DoubleValue
checkpointFlushAfter : google.protobuf.Int64Value
in bytes
maxWalSize : google.protobuf.Int64Value
in bytes.
minWalSize : google.protobuf.Int64Value
in bytes.
maxStandbyStreamingDelay : google.protobuf.Int64Value
in milliseconds.
defaultStatisticsTarget : google.protobuf.Int64Value
constraintExclusion : ConstraintExclusion
cursorTupleFraction : google.protobuf.DoubleValue
fromCollapseLimit : google.protobuf.Int64Value
joinCollapseLimit : google.protobuf.Int64Value
forceParallelMode : ForceParallelMode
clientMinMessages : LogLevel
logMinMessages : LogLevel
logMinErrorStatement : LogLevel
logMinDurationStatement : google.protobuf.Int64Value
in milliseconds.
logCheckpoints : google.protobuf.BoolValue
logConnections : google.protobuf.BoolValue
logDisconnections : google.protobuf.BoolValue
logDuration : google.protobuf.BoolValue
logErrorVerbosity : LogErrorVerbosity
logLockWaits : google.protobuf.BoolValue
logStatement : LogStatement
logTempFiles : google.protobuf.Int64Value
searchPath : string
rowSecurity : google.protobuf.BoolValue
defaultTransactionIsolation : TransactionIsolation
statementTimeout : google.protobuf.Int64Value
in milliseconds.
lockTimeout : google.protobuf.Int64Value
in milliseconds.
idleInTransactionSessionTimeout : google.protobuf.Int64Value
in milliseconds.
byteaOutput : ByteaOutput
xmlbinary : XmlBinary
xmloption : XmlOption
ginPendingListLimit : google.protobuf.Int64Value
in bytes.
deadlockTimeout : google.protobuf.Int64Value
in milliseconds.
maxLocksPerTransaction : google.protobuf.Int64Value
maxPredLocksPerTransaction : google.protobuf.Int64Value
arrayNulls : google.protobuf.BoolValue
backslashQuote : BackslashQuote
defaultWithOids : google.protobuf.BoolValue
escapeStringWarning : google.protobuf.BoolValue
loCompatPrivileges : google.protobuf.BoolValue
quoteAllIdentifiers : google.protobuf.BoolValue
standardConformingStrings : google.protobuf.BoolValue
synchronizeSeqscans : google.protobuf.BoolValue
transformNullEquals : google.protobuf.BoolValue
exitOnError : google.protobuf.BoolValue
seqPageCost : google.protobuf.DoubleValue
randomPageCost : google.protobuf.DoubleValue
autovacuumMaxWorkers : google.protobuf.Int64Value
autovacuumVacuumCostDelay : google.protobuf.Int64Value
autovacuumVacuumCostLimit : google.protobuf.Int64Value
autovacuumNaptime : google.protobuf.Int64Value
in milliseconds.
archiveTimeout : google.protobuf.Int64Value
in milliseconds.
trackActivityQuerySize : google.protobuf.Int64Value
enableBitmapscan : google.protobuf.BoolValue
enableHashagg : google.protobuf.BoolValue
enableHashjoin : google.protobuf.BoolValue
enableIndexscan : google.protobuf.BoolValue
enableIndexonlyscan : google.protobuf.BoolValue
enableMaterial : google.protobuf.BoolValue
enableMergejoin : google.protobuf.BoolValue
enableNestloop : google.protobuf.BoolValue
enableSeqscan : google.protobuf.BoolValue
enableSort : google.protobuf.BoolValue
enableTidscan : google.protobuf.BoolValue
maxWorkerProcesses : google.protobuf.Int64Value
maxParallelWorkers : google.protobuf.Int64Value
maxParallelWorkersPerGather : google.protobuf.Int64Value
autovacuumVacuumScaleFactor : google.protobuf.DoubleValue
autovacuumAnalyzeScaleFactor : google.protobuf.DoubleValue
defaultTransactionReadOnly : google.protobuf.BoolValue
timezone : string
enableParallelAppend : google.protobuf.BoolValue
enableParallelHash : google.protobuf.BoolValue
enablePartitionPruning : google.protobuf.BoolValue
enablePartitionwiseAggregate : google.protobuf.BoolValue
enablePartitionwiseJoin : google.protobuf.BoolValue
jit : google.protobuf.BoolValue
maxParallelMaintenanceWorkers : google.protobuf.Int64Value
parallelLeaderParticipation : google.protobuf.BoolValue
logTransactionSampleRate : google.protobuf.DoubleValue
planCacheMode : PlanCacheMode
effectiveIoConcurrency : google.protobuf.Int64Value
effectiveCacheSize : google.protobuf.Int64Value
sharedPreloadLibraries : SharedPreloadLibraries
autoExplainLogMinDuration : google.protobuf.Int64Value
in milliseconds.
autoExplainLogAnalyze : google.protobuf.BoolValue
autoExplainLogBuffers : google.protobuf.BoolValue
autoExplainLogTiming : google.protobuf.BoolValue
autoExplainLogTriggers : google.protobuf.BoolValue
autoExplainLogVerbose : google.protobuf.BoolValue
autoExplainLogNestedStatements : google.protobuf.BoolValue
autoExplainSampleRate : google.protobuf.DoubleValue
pgHintPlanEnableHint : google.protobuf.BoolValue
pgHintPlanEnableHintTable : google.protobuf.BoolValue
pgHintPlanDebugPrint : PgHintPlanDebugPrint
pgHintPlanMessageLevel : LogLevel
hashMemMultiplier : google.protobuf.DoubleValue
logicalDecodingWorkMem : google.protobuf.Int64Value
in bytes.
maintenanceIoConcurrency : google.protobuf.Int64Value
maxSlotWalKeepSize : google.protobuf.Int64Value
in bytes.
walKeepSize : google.protobuf.Int64Value
in bytes.
enableIncrementalSort : google.protobuf.BoolValue
autovacuumVacuumInsertThreshold : google.protobuf.Int64Value
autovacuumVacuumInsertScaleFactor : google.protobuf.DoubleValue
logMinDurationSample : google.protobuf.Int64Value
in milliseconds.
logStatementSampleRate : google.protobuf.DoubleValue
logParameterMaxLength : google.protobuf.Int64Value
in bytes.
logParameterMaxLengthOnError : google.protobuf.Int64Value
in bytes.
clientConnectionCheckInterval : google.protobuf.Int64Value
in milliseconds.
enableAsyncAppend : google.protobuf.BoolValue
enableGathermerge : google.protobuf.BoolValue
enableMemoize : google.protobuf.BoolValue
logRecoveryConflictWaits : google.protobuf.BoolValue
in milliseconds.
vacuumFailsafeAge : google.protobuf.Int64Value
in milliseconds.
vacuumMultixactFailsafeAge : google.protobuf.Int64Value
in milliseconds.
pgQualstatsEnabled : google.protobuf.BoolValue
pgQualstatsTrackConstants : google.protobuf.BoolValue
pgQualstatsMax : google.protobuf.Int64Value
pgQualstatsResolveOids : google.protobuf.BoolValue
pgQualstatsSampleRate : google.protobuf.DoubleValue
maxStackDepth : google.protobuf.Int64Value
in bytes.
geqo : google.protobuf.BoolValue
enable Genetic Query Optimizer, by default is on
geqoThreshold : google.protobuf.Int64Value
The number of tables to use geqo, default is 12
geqoEffort : google.protobuf.Int64Value
tradeoff between planning time and query plan quality, default is 5
geqoPoolSize : google.protobuf.Int64Value
number of individuals in the genetic population, useful values are typically 100 to 1000; default - 0 - choose based on based on geqo_effort
geqoGenerations : google.protobuf.Int64Value
the number of generations used by GEQO, useful values are in the same range as the pool size
geqoSelectionBias : google.protobuf.DoubleValue
selective pressure within the population
geqoSeed : google.protobuf.DoubleValue
initial value of the random number generator used by GEQO
pgTrgmSimilarityThreshold : google.protobuf.DoubleValue
pgTrgmWordSimilarityThreshold : google.protobuf.DoubleValue
pgTrgmStrictWordSimilarityThreshold : google.protobuf.DoubleValue
maxStandbyArchiveDelay : google.protobuf.Int64Value
in milliseconds.
sessionDurationTimeout : google.protobuf.Int64Value
Terminate any session that exceeds the designated timeout, specified in milliseconds. If a timeout is not specified, the default session timeout is set to 12 hours. To disable it, specify a value of 0.
logReplicationCommands : google.protobuf.BoolValue
logAutovacuumMinDuration : google.protobuf.Int64Value
in milliseconds. The default is 1000 (1 sec).
passwordEncryption : PasswordEncryption
A default value for user_password_encryption user-level setting, if it not specified for new users. Possible values are PASSWORD_ENCRYPTION_MD5 or PASSWORD_ENCRYPTION_SCRAM_SHA_256. The default is PASSWORD_ENCRYPTION_MD5.
PostgresqlConfig14_1C
Options and structure of PostgresqlConfig reflects PostgreSQL configuration file
parameters which detailed description is available in
PostgreSQL documentation.
BackslashQuote
BACKSLASH_QUOTE_UNSPECIFIEDBACKSLASH_QUOTEBACKSLASH_QUOTE_ONBACKSLASH_QUOTE_OFFBACKSLASH_QUOTE_SAFE_ENCODING
ByteaOutput
BYTEA_OUTPUT_UNSPECIFIEDBYTEA_OUTPUT_HEXBYTEA_OUTPUT_ESCAPED
ConstraintExclusion
CONSTRAINT_EXCLUSION_UNSPECIFIEDCONSTRAINT_EXCLUSION_ONCONSTRAINT_EXCLUSION_OFFCONSTRAINT_EXCLUSION_PARTITION
ForceParallelMode
FORCE_PARALLEL_MODE_UNSPECIFIEDFORCE_PARALLEL_MODE_ONFORCE_PARALLEL_MODE_OFFFORCE_PARALLEL_MODE_REGRESS
LogErrorVerbosity
LOG_ERROR_VERBOSITY_UNSPECIFIEDLOG_ERROR_VERBOSITY_TERSELOG_ERROR_VERBOSITY_DEFAULTLOG_ERROR_VERBOSITY_VERBOSE
LogLevel
LOG_LEVEL_UNSPECIFIEDLOG_LEVEL_DEBUG5LOG_LEVEL_DEBUG4LOG_LEVEL_DEBUG3LOG_LEVEL_DEBUG2LOG_LEVEL_DEBUG1LOG_LEVEL_LOGLOG_LEVEL_NOTICELOG_LEVEL_WARNINGLOG_LEVEL_ERRORLOG_LEVEL_FATALLOG_LEVEL_PANIC
LogStatement
LOG_STATEMENT_UNSPECIFIEDLOG_STATEMENT_NONELOG_STATEMENT_DDLLOG_STATEMENT_MODLOG_STATEMENT_ALL
PasswordEncryption
PASSWORD_ENCRYPTION_UNSPECIFIEDPASSWORD_ENCRYPTION_MD5PASSWORD_ENCRYPTION_SCRAM_SHA_256
PgHintPlanDebugPrint
PG_HINT_PLAN_DEBUG_PRINT_UNSPECIFIEDPG_HINT_PLAN_DEBUG_PRINT_OFFPG_HINT_PLAN_DEBUG_PRINT_ONPG_HINT_PLAN_DEBUG_PRINT_DETAILEDPG_HINT_PLAN_DEBUG_PRINT_VERBOSE
PlanCacheMode
PLAN_CACHE_MODE_UNSPECIFIEDPLAN_CACHE_MODE_AUTOPLAN_CACHE_MODE_FORCE_CUSTOM_PLANPLAN_CACHE_MODE_FORCE_GENERIC_PLAN
SharedPreloadLibraries
SHARED_PRELOAD_LIBRARIES_UNSPECIFIEDSHARED_PRELOAD_LIBRARIES_AUTO_EXPLAINSHARED_PRELOAD_LIBRARIES_PG_HINT_PLANSHARED_PRELOAD_LIBRARIES_TIMESCALEDBSHARED_PRELOAD_LIBRARIES_PG_QUALSTATSSHARED_PRELOAD_LIBRARIES_PG_CRONSHARED_PRELOAD_LIBRARIES_PGLOGICALSHARED_PRELOAD_LIBRARIES_PG_PREWARMSHARED_PRELOAD_LIBRARIES_PGAUDIT
SynchronousCommit
SYNCHRONOUS_COMMIT_UNSPECIFIEDSYNCHRONOUS_COMMIT_ONSYNCHRONOUS_COMMIT_OFFSYNCHRONOUS_COMMIT_LOCALSYNCHRONOUS_COMMIT_REMOTE_WRITESYNCHRONOUS_COMMIT_REMOTE_APPLY
TransactionIsolation
TRANSACTION_ISOLATION_UNSPECIFIEDTRANSACTION_ISOLATION_READ_UNCOMMITTEDTRANSACTION_ISOLATION_READ_COMMITTEDTRANSACTION_ISOLATION_REPEATABLE_READTRANSACTION_ISOLATION_SERIALIZABLE
WalLevel
WAL_LEVEL_UNSPECIFIEDWAL_LEVEL_REPLICAWAL_LEVEL_LOGICAL
XmlBinary
XML_BINARY_UNSPECIFIEDXML_BINARY_BASE64XML_BINARY_HEX
XmlOption
XML_OPTION_UNSPECIFIEDXML_OPTION_DOCUMENTXML_OPTION_CONTENT
maxConnections : google.protobuf.Int64Value
sharedBuffers : google.protobuf.Int64Value
in bytes.
tempBuffers : google.protobuf.Int64Value
in bytes.
maxPreparedTransactions : google.protobuf.Int64Value
workMem : google.protobuf.Int64Value
in bytes.
maintenanceWorkMem : google.protobuf.Int64Value
in bytes.
autovacuumWorkMem : google.protobuf.Int64Value
in bytes.
tempFileLimit : google.protobuf.Int64Value
in bytes.
vacuumCostDelay : google.protobuf.Int64Value
in milliseconds.
vacuumCostPageHit : google.protobuf.Int64Value
vacuumCostPageMiss : google.protobuf.Int64Value
vacuumCostPageDirty : google.protobuf.Int64Value
vacuumCostLimit : google.protobuf.Int64Value
bgwriterDelay : google.protobuf.Int64Value
in milliseconds.
bgwriterLruMaxpages : google.protobuf.Int64Value
bgwriterLruMultiplier : google.protobuf.DoubleValue
bgwriterFlushAfter : google.protobuf.Int64Value
in bytes
backendFlushAfter : google.protobuf.Int64Value
in bytes
oldSnapshotThreshold : google.protobuf.Int64Value
walLevel : WalLevel
synchronousCommit : SynchronousCommit
checkpointTimeout : google.protobuf.Int64Value
in milliseconds.
checkpointCompletionTarget : google.protobuf.DoubleValue
checkpointFlushAfter : google.protobuf.Int64Value
in bytes
maxWalSize : google.protobuf.Int64Value
in bytes.
minWalSize : google.protobuf.Int64Value
in bytes.
maxStandbyStreamingDelay : google.protobuf.Int64Value
in milliseconds.
defaultStatisticsTarget : google.protobuf.Int64Value
constraintExclusion : ConstraintExclusion
cursorTupleFraction : google.protobuf.DoubleValue
fromCollapseLimit : google.protobuf.Int64Value
joinCollapseLimit : google.protobuf.Int64Value
forceParallelMode : ForceParallelMode
clientMinMessages : LogLevel
logMinMessages : LogLevel
logMinErrorStatement : LogLevel
logMinDurationStatement : google.protobuf.Int64Value
in milliseconds.
logCheckpoints : google.protobuf.BoolValue
logConnections : google.protobuf.BoolValue
logDisconnections : google.protobuf.BoolValue
logDuration : google.protobuf.BoolValue
logErrorVerbosity : LogErrorVerbosity
logLockWaits : google.protobuf.BoolValue
logStatement : LogStatement
logTempFiles : google.protobuf.Int64Value
searchPath : string
rowSecurity : google.protobuf.BoolValue
defaultTransactionIsolation : TransactionIsolation
statementTimeout : google.protobuf.Int64Value
in milliseconds.
lockTimeout : google.protobuf.Int64Value
in milliseconds.
idleInTransactionSessionTimeout : google.protobuf.Int64Value
in milliseconds.
byteaOutput : ByteaOutput
xmlbinary : XmlBinary
xmloption : XmlOption
ginPendingListLimit : google.protobuf.Int64Value
in bytes.
deadlockTimeout : google.protobuf.Int64Value
in milliseconds.
maxLocksPerTransaction : google.protobuf.Int64Value
maxPredLocksPerTransaction : google.protobuf.Int64Value
arrayNulls : google.protobuf.BoolValue
backslashQuote : BackslashQuote
defaultWithOids : google.protobuf.BoolValue
escapeStringWarning : google.protobuf.BoolValue
loCompatPrivileges : google.protobuf.BoolValue
quoteAllIdentifiers : google.protobuf.BoolValue
standardConformingStrings : google.protobuf.BoolValue
synchronizeSeqscans : google.protobuf.BoolValue
transformNullEquals : google.protobuf.BoolValue
exitOnError : google.protobuf.BoolValue
seqPageCost : google.protobuf.DoubleValue
randomPageCost : google.protobuf.DoubleValue
autovacuumMaxWorkers : google.protobuf.Int64Value
autovacuumVacuumCostDelay : google.protobuf.Int64Value
autovacuumVacuumCostLimit : google.protobuf.Int64Value
autovacuumNaptime : google.protobuf.Int64Value
in milliseconds.
archiveTimeout : google.protobuf.Int64Value
in milliseconds.
trackActivityQuerySize : google.protobuf.Int64Value
onlineAnalyzeEnable : google.protobuf.BoolValue
enableBitmapscan : google.protobuf.BoolValue
enableHashagg : google.protobuf.BoolValue
enableHashjoin : google.protobuf.BoolValue
enableIndexscan : google.protobuf.BoolValue
enableIndexonlyscan : google.protobuf.BoolValue
enableMaterial : google.protobuf.BoolValue
enableMergejoin : google.protobuf.BoolValue
enableNestloop : google.protobuf.BoolValue
enableSeqscan : google.protobuf.BoolValue
enableSort : google.protobuf.BoolValue
enableTidscan : google.protobuf.BoolValue
maxWorkerProcesses : google.protobuf.Int64Value
maxParallelWorkers : google.protobuf.Int64Value
maxParallelWorkersPerGather : google.protobuf.Int64Value
autovacuumVacuumScaleFactor : google.protobuf.DoubleValue
autovacuumAnalyzeScaleFactor : google.protobuf.DoubleValue
defaultTransactionReadOnly : google.protobuf.BoolValue
timezone : string
enableParallelAppend : google.protobuf.BoolValue
enableParallelHash : google.protobuf.BoolValue
enablePartitionPruning : google.protobuf.BoolValue
enablePartitionwiseAggregate : google.protobuf.BoolValue
enablePartitionwiseJoin : google.protobuf.BoolValue
jit : google.protobuf.BoolValue
maxParallelMaintenanceWorkers : google.protobuf.Int64Value
parallelLeaderParticipation : google.protobuf.BoolValue
logTransactionSampleRate : google.protobuf.DoubleValue
planCacheMode : PlanCacheMode
effectiveIoConcurrency : google.protobuf.Int64Value
effectiveCacheSize : google.protobuf.Int64Value
sharedPreloadLibraries : SharedPreloadLibraries
autoExplainLogMinDuration : google.protobuf.Int64Value
in milliseconds.
autoExplainLogAnalyze : google.protobuf.BoolValue
autoExplainLogBuffers : google.protobuf.BoolValue
autoExplainLogTiming : google.protobuf.BoolValue
autoExplainLogTriggers : google.protobuf.BoolValue
autoExplainLogVerbose : google.protobuf.BoolValue
autoExplainLogNestedStatements : google.protobuf.BoolValue
autoExplainSampleRate : google.protobuf.DoubleValue
pgHintPlanEnableHint : google.protobuf.BoolValue
pgHintPlanEnableHintTable : google.protobuf.BoolValue
pgHintPlanDebugPrint : PgHintPlanDebugPrint
pgHintPlanMessageLevel : LogLevel
hashMemMultiplier : google.protobuf.DoubleValue
logicalDecodingWorkMem : google.protobuf.Int64Value
in bytes.
maintenanceIoConcurrency : google.protobuf.Int64Value
maxSlotWalKeepSize : google.protobuf.Int64Value
in bytes.
walKeepSize : google.protobuf.Int64Value
in bytes.
enableIncrementalSort : google.protobuf.BoolValue
autovacuumVacuumInsertThreshold : google.protobuf.Int64Value
autovacuumVacuumInsertScaleFactor : google.protobuf.DoubleValue
logMinDurationSample : google.protobuf.Int64Value
in milliseconds.
logStatementSampleRate : google.protobuf.DoubleValue
logParameterMaxLength : google.protobuf.Int64Value
in bytes.
logParameterMaxLengthOnError : google.protobuf.Int64Value
in bytes.
clientConnectionCheckInterval : google.protobuf.Int64Value
in milliseconds.
enableAsyncAppend : google.protobuf.BoolValue
enableGathermerge : google.protobuf.BoolValue
enableMemoize : google.protobuf.BoolValue
logRecoveryConflictWaits : google.protobuf.BoolValue
in milliseconds.
vacuumFailsafeAge : google.protobuf.Int64Value
in milliseconds.
vacuumMultixactFailsafeAge : google.protobuf.Int64Value
in milliseconds.
pgQualstatsEnabled : google.protobuf.BoolValue
pgQualstatsTrackConstants : google.protobuf.BoolValue
pgQualstatsMax : google.protobuf.Int64Value
pgQualstatsResolveOids : google.protobuf.BoolValue
pgQualstatsSampleRate : google.protobuf.DoubleValue
plantunerFixEmptyTable : google.protobuf.BoolValue
geqo : google.protobuf.BoolValue
enable Genetic Query Optimizer, by default is on
geqoThreshold : google.protobuf.Int64Value
The number of tables to use geqo, default is 12
geqoEffort : google.protobuf.Int64Value
tradeoff between planning time and query plan quality, default is 5
geqoPoolSize : google.protobuf.Int64Value
number of individuals in the genetic population, useful values are typically 100 to 1000; default - 0 - choose based on based on geqo_effort
geqoGenerations : google.protobuf.Int64Value
the number of generations used by GEQO, useful values are in the same range as the pool size
geqoSelectionBias : google.protobuf.DoubleValue
selective pressure within the population
geqoSeed : google.protobuf.DoubleValue
initial value of the random number generator used by GEQO
pgTrgmSimilarityThreshold : google.protobuf.DoubleValue
pgTrgmWordSimilarityThreshold : google.protobuf.DoubleValue
pgTrgmStrictWordSimilarityThreshold : google.protobuf.DoubleValue
maxStandbyArchiveDelay : google.protobuf.Int64Value
in milliseconds.
sessionDurationTimeout : google.protobuf.Int64Value
Terminate any session that exceeds the designated timeout, specified in milliseconds. If a timeout is not specified, the default session timeout is set to 12 hours. To disable it, specify a value of 0.
logReplicationCommands : google.protobuf.BoolValue
logAutovacuumMinDuration : google.protobuf.Int64Value
in milliseconds. The default is 1000 (1 sec).
passwordEncryption : PasswordEncryption
A default value for user_password_encryption user-level setting, if it not specified for new users. Possible values are PASSWORD_ENCRYPTION_MD5 or PASSWORD_ENCRYPTION_SCRAM_SHA_256. The default is PASSWORD_ENCRYPTION_MD5.
PostgresqlConfig15
Options and structure of PostgresqlConfig reflects PostgreSQL configuration file
parameters which detailed description is available in
PostgreSQL documentation.
BackslashQuote
BACKSLASH_QUOTE_UNSPECIFIEDBACKSLASH_QUOTEBACKSLASH_QUOTE_ONBACKSLASH_QUOTE_OFFBACKSLASH_QUOTE_SAFE_ENCODING
ByteaOutput
BYTEA_OUTPUT_UNSPECIFIEDBYTEA_OUTPUT_HEXBYTEA_OUTPUT_ESCAPED
ConstraintExclusion
CONSTRAINT_EXCLUSION_UNSPECIFIEDCONSTRAINT_EXCLUSION_ONCONSTRAINT_EXCLUSION_OFFCONSTRAINT_EXCLUSION_PARTITION
ForceParallelMode
FORCE_PARALLEL_MODE_UNSPECIFIEDFORCE_PARALLEL_MODE_ONFORCE_PARALLEL_MODE_OFFFORCE_PARALLEL_MODE_REGRESS
LogErrorVerbosity
LOG_ERROR_VERBOSITY_UNSPECIFIEDLOG_ERROR_VERBOSITY_TERSELOG_ERROR_VERBOSITY_DEFAULTLOG_ERROR_VERBOSITY_VERBOSE
LogLevel
LOG_LEVEL_UNSPECIFIEDLOG_LEVEL_DEBUG5LOG_LEVEL_DEBUG4LOG_LEVEL_DEBUG3LOG_LEVEL_DEBUG2LOG_LEVEL_DEBUG1LOG_LEVEL_LOGLOG_LEVEL_NOTICELOG_LEVEL_WARNINGLOG_LEVEL_ERRORLOG_LEVEL_FATALLOG_LEVEL_PANIC
LogStatement
LOG_STATEMENT_UNSPECIFIEDLOG_STATEMENT_NONELOG_STATEMENT_DDLLOG_STATEMENT_MODLOG_STATEMENT_ALL
PasswordEncryption
PASSWORD_ENCRYPTION_UNSPECIFIEDPASSWORD_ENCRYPTION_MD5PASSWORD_ENCRYPTION_SCRAM_SHA_256
PgHintPlanDebugPrint
PG_HINT_PLAN_DEBUG_PRINT_UNSPECIFIEDPG_HINT_PLAN_DEBUG_PRINT_OFFPG_HINT_PLAN_DEBUG_PRINT_ONPG_HINT_PLAN_DEBUG_PRINT_DETAILEDPG_HINT_PLAN_DEBUG_PRINT_VERBOSE
PlanCacheMode
PLAN_CACHE_MODE_UNSPECIFIEDPLAN_CACHE_MODE_AUTOPLAN_CACHE_MODE_FORCE_CUSTOM_PLANPLAN_CACHE_MODE_FORCE_GENERIC_PLAN
SharedPreloadLibraries
SHARED_PRELOAD_LIBRARIES_UNSPECIFIEDSHARED_PRELOAD_LIBRARIES_AUTO_EXPLAINSHARED_PRELOAD_LIBRARIES_PG_HINT_PLANSHARED_PRELOAD_LIBRARIES_TIMESCALEDBSHARED_PRELOAD_LIBRARIES_PG_QUALSTATSSHARED_PRELOAD_LIBRARIES_PG_CRONSHARED_PRELOAD_LIBRARIES_PGLOGICALSHARED_PRELOAD_LIBRARIES_PG_PREWARMSHARED_PRELOAD_LIBRARIES_PGAUDITSHARED_PRELOAD_LIBRARIES_ANON
SynchronousCommit
SYNCHRONOUS_COMMIT_UNSPECIFIEDSYNCHRONOUS_COMMIT_ONSYNCHRONOUS_COMMIT_OFFSYNCHRONOUS_COMMIT_LOCALSYNCHRONOUS_COMMIT_REMOTE_WRITESYNCHRONOUS_COMMIT_REMOTE_APPLY
TransactionIsolation
TRANSACTION_ISOLATION_UNSPECIFIEDTRANSACTION_ISOLATION_READ_UNCOMMITTEDTRANSACTION_ISOLATION_READ_COMMITTEDTRANSACTION_ISOLATION_REPEATABLE_READTRANSACTION_ISOLATION_SERIALIZABLE
WalLevel
WAL_LEVEL_UNSPECIFIEDWAL_LEVEL_REPLICAWAL_LEVEL_LOGICAL
XmlBinary
XML_BINARY_UNSPECIFIEDXML_BINARY_BASE64XML_BINARY_HEX
XmlOption
XML_OPTION_UNSPECIFIEDXML_OPTION_DOCUMENTXML_OPTION_CONTENT
maxConnections : google.protobuf.Int64Value
sharedBuffers : google.protobuf.Int64Value
in bytes.
tempBuffers : google.protobuf.Int64Value
in bytes.
maxPreparedTransactions : google.protobuf.Int64Value
workMem : google.protobuf.Int64Value
in bytes.
maintenanceWorkMem : google.protobuf.Int64Value
in bytes.
autovacuumWorkMem : google.protobuf.Int64Value
in bytes.
tempFileLimit : google.protobuf.Int64Value
in bytes.
vacuumCostDelay : google.protobuf.Int64Value
in milliseconds.
vacuumCostPageHit : google.protobuf.Int64Value
vacuumCostPageMiss : google.protobuf.Int64Value
vacuumCostPageDirty : google.protobuf.Int64Value
vacuumCostLimit : google.protobuf.Int64Value
bgwriterDelay : google.protobuf.Int64Value
in milliseconds.
bgwriterLruMaxpages : google.protobuf.Int64Value
bgwriterLruMultiplier : google.protobuf.DoubleValue
bgwriterFlushAfter : google.protobuf.Int64Value
in bytes
backendFlushAfter : google.protobuf.Int64Value
in bytes
oldSnapshotThreshold : google.protobuf.Int64Value
walLevel : WalLevel
synchronousCommit : SynchronousCommit
checkpointTimeout : google.protobuf.Int64Value
in milliseconds.
checkpointCompletionTarget : google.protobuf.DoubleValue
checkpointFlushAfter : google.protobuf.Int64Value
in bytes
maxWalSize : google.protobuf.Int64Value
in bytes.
minWalSize : google.protobuf.Int64Value
in bytes.
maxStandbyStreamingDelay : google.protobuf.Int64Value
in milliseconds.
defaultStatisticsTarget : google.protobuf.Int64Value
constraintExclusion : ConstraintExclusion
cursorTupleFraction : google.protobuf.DoubleValue
fromCollapseLimit : google.protobuf.Int64Value
joinCollapseLimit : google.protobuf.Int64Value
forceParallelMode : ForceParallelMode
clientMinMessages : LogLevel
logMinMessages : LogLevel
logMinErrorStatement : LogLevel
logMinDurationStatement : google.protobuf.Int64Value
in milliseconds.
logCheckpoints : google.protobuf.BoolValue
logConnections : google.protobuf.BoolValue
logDisconnections : google.protobuf.BoolValue
logDuration : google.protobuf.BoolValue
logErrorVerbosity : LogErrorVerbosity
logLockWaits : google.protobuf.BoolValue
logStatement : LogStatement
logTempFiles : google.protobuf.Int64Value
searchPath : string
rowSecurity : google.protobuf.BoolValue
defaultTransactionIsolation : TransactionIsolation
statementTimeout : google.protobuf.Int64Value
in milliseconds.
lockTimeout : google.protobuf.Int64Value
in milliseconds.
idleInTransactionSessionTimeout : google.protobuf.Int64Value
in milliseconds.
byteaOutput : ByteaOutput
xmlbinary : XmlBinary
xmloption : XmlOption
ginPendingListLimit : google.protobuf.Int64Value
in bytes.
deadlockTimeout : google.protobuf.Int64Value
in milliseconds.
maxLocksPerTransaction : google.protobuf.Int64Value
maxPredLocksPerTransaction : google.protobuf.Int64Value
arrayNulls : google.protobuf.BoolValue
backslashQuote : BackslashQuote
defaultWithOids : google.protobuf.BoolValue
escapeStringWarning : google.protobuf.BoolValue
loCompatPrivileges : google.protobuf.BoolValue
quoteAllIdentifiers : google.protobuf.BoolValue
standardConformingStrings : google.protobuf.BoolValue
synchronizeSeqscans : google.protobuf.BoolValue
transformNullEquals : google.protobuf.BoolValue
exitOnError : google.protobuf.BoolValue
seqPageCost : google.protobuf.DoubleValue
randomPageCost : google.protobuf.DoubleValue
autovacuumMaxWorkers : google.protobuf.Int64Value
autovacuumVacuumCostDelay : google.protobuf.Int64Value
autovacuumVacuumCostLimit : google.protobuf.Int64Value
autovacuumNaptime : google.protobuf.Int64Value
in milliseconds.
archiveTimeout : google.protobuf.Int64Value
in milliseconds.
trackActivityQuerySize : google.protobuf.Int64Value
enableBitmapscan : google.protobuf.BoolValue
enableHashagg : google.protobuf.BoolValue
enableHashjoin : google.protobuf.BoolValue
enableIndexscan : google.protobuf.BoolValue
enableIndexonlyscan : google.protobuf.BoolValue
enableMaterial : google.protobuf.BoolValue
enableMergejoin : google.protobuf.BoolValue
enableNestloop : google.protobuf.BoolValue
enableSeqscan : google.protobuf.BoolValue
enableSort : google.protobuf.BoolValue
enableTidscan : google.protobuf.BoolValue
maxWorkerProcesses : google.protobuf.Int64Value
maxParallelWorkers : google.protobuf.Int64Value
maxParallelWorkersPerGather : google.protobuf.Int64Value
autovacuumVacuumScaleFactor : google.protobuf.DoubleValue
autovacuumAnalyzeScaleFactor : google.protobuf.DoubleValue
defaultTransactionReadOnly : google.protobuf.BoolValue
timezone : string
enableParallelAppend : google.protobuf.BoolValue
enableParallelHash : google.protobuf.BoolValue
enablePartitionPruning : google.protobuf.BoolValue
enablePartitionwiseAggregate : google.protobuf.BoolValue
enablePartitionwiseJoin : google.protobuf.BoolValue
jit : google.protobuf.BoolValue
maxParallelMaintenanceWorkers : google.protobuf.Int64Value
parallelLeaderParticipation : google.protobuf.BoolValue
logTransactionSampleRate : google.protobuf.DoubleValue
planCacheMode : PlanCacheMode
effectiveIoConcurrency : google.protobuf.Int64Value
effectiveCacheSize : google.protobuf.Int64Value
sharedPreloadLibraries : SharedPreloadLibraries
autoExplainLogMinDuration : google.protobuf.Int64Value
in milliseconds.
autoExplainLogAnalyze : google.protobuf.BoolValue
autoExplainLogBuffers : google.protobuf.BoolValue
autoExplainLogTiming : google.protobuf.BoolValue
autoExplainLogTriggers : google.protobuf.BoolValue
autoExplainLogVerbose : google.protobuf.BoolValue
autoExplainLogNestedStatements : google.protobuf.BoolValue
autoExplainSampleRate : google.protobuf.DoubleValue
pgHintPlanEnableHint : google.protobuf.BoolValue
pgHintPlanEnableHintTable : google.protobuf.BoolValue
pgHintPlanDebugPrint : PgHintPlanDebugPrint
pgHintPlanMessageLevel : LogLevel
hashMemMultiplier : google.protobuf.DoubleValue
logicalDecodingWorkMem : google.protobuf.Int64Value
in bytes.
maintenanceIoConcurrency : google.protobuf.Int64Value
maxSlotWalKeepSize : google.protobuf.Int64Value
in bytes.
walKeepSize : google.protobuf.Int64Value
in bytes.
enableIncrementalSort : google.protobuf.BoolValue
autovacuumVacuumInsertThreshold : google.protobuf.Int64Value
autovacuumVacuumInsertScaleFactor : google.protobuf.DoubleValue
logMinDurationSample : google.protobuf.Int64Value
in milliseconds.
logStatementSampleRate : google.protobuf.DoubleValue
logParameterMaxLength : google.protobuf.Int64Value
in bytes.
logParameterMaxLengthOnError : google.protobuf.Int64Value
in bytes.
clientConnectionCheckInterval : google.protobuf.Int64Value
in milliseconds.
enableAsyncAppend : google.protobuf.BoolValue
enableGathermerge : google.protobuf.BoolValue
enableMemoize : google.protobuf.BoolValue
logRecoveryConflictWaits : google.protobuf.BoolValue
in milliseconds.
vacuumFailsafeAge : google.protobuf.Int64Value
in milliseconds.
vacuumMultixactFailsafeAge : google.protobuf.Int64Value
in milliseconds.
pgQualstatsEnabled : google.protobuf.BoolValue
pgQualstatsTrackConstants : google.protobuf.BoolValue
pgQualstatsMax : google.protobuf.Int64Value
pgQualstatsResolveOids : google.protobuf.BoolValue
pgQualstatsSampleRate : google.protobuf.DoubleValue
maxStackDepth : google.protobuf.Int64Value
in bytes.
enableGroupByReordering : google.protobuf.BoolValue
geqo : google.protobuf.BoolValue
enable Genetic Query Optimizer, by default is on
geqoThreshold : google.protobuf.Int64Value
The number of tables to use geqo, default is 12
geqoEffort : google.protobuf.Int64Value
tradeoff between planning time and query plan quality, default is 5
geqoPoolSize : google.protobuf.Int64Value
number of individuals in the genetic population, useful values are typically 100 to 1000; default - 0 - choose based on based on geqo_effort
geqoGenerations : google.protobuf.Int64Value
the number of generations used by GEQO, useful values are in the same range as the pool size
geqoSelectionBias : google.protobuf.DoubleValue
selective pressure within the population
geqoSeed : google.protobuf.DoubleValue
initial value of the random number generator used by GEQO
pgTrgmSimilarityThreshold : google.protobuf.DoubleValue
pgTrgmWordSimilarityThreshold : google.protobuf.DoubleValue
pgTrgmStrictWordSimilarityThreshold : google.protobuf.DoubleValue
maxStandbyArchiveDelay : google.protobuf.Int64Value
in milliseconds.
sessionDurationTimeout : google.protobuf.Int64Value
Terminate any session that exceeds the designated timeout, specified in milliseconds. If a timeout is not specified, the default session timeout is set to 12 hours. To disable it, specify a value of 0.
logReplicationCommands : google.protobuf.BoolValue
logAutovacuumMinDuration : google.protobuf.Int64Value
in milliseconds. The default is 1000 (1 sec).
passwordEncryption : PasswordEncryption
A default value for user_password_encryption user-level setting, if it not specified for new users. Possible values are PASSWORD_ENCRYPTION_MD5 or PASSWORD_ENCRYPTION_SCRAM_SHA_256. The default is PASSWORD_ENCRYPTION_MD5.
PostgresqlConfig15_1C
Options and structure of PostgresqlConfig reflects PostgreSQL configuration file
parameters which detailed description is available in
PostgreSQL documentation.
BackslashQuote
BACKSLASH_QUOTE_UNSPECIFIEDBACKSLASH_QUOTEBACKSLASH_QUOTE_ONBACKSLASH_QUOTE_OFFBACKSLASH_QUOTE_SAFE_ENCODING
ByteaOutput
BYTEA_OUTPUT_UNSPECIFIEDBYTEA_OUTPUT_HEXBYTEA_OUTPUT_ESCAPED
ConstraintExclusion
CONSTRAINT_EXCLUSION_UNSPECIFIEDCONSTRAINT_EXCLUSION_ONCONSTRAINT_EXCLUSION_OFFCONSTRAINT_EXCLUSION_PARTITION
ForceParallelMode
FORCE_PARALLEL_MODE_UNSPECIFIEDFORCE_PARALLEL_MODE_ONFORCE_PARALLEL_MODE_OFFFORCE_PARALLEL_MODE_REGRESS
LogErrorVerbosity
LOG_ERROR_VERBOSITY_UNSPECIFIEDLOG_ERROR_VERBOSITY_TERSELOG_ERROR_VERBOSITY_DEFAULTLOG_ERROR_VERBOSITY_VERBOSE
LogLevel
LOG_LEVEL_UNSPECIFIEDLOG_LEVEL_DEBUG5LOG_LEVEL_DEBUG4LOG_LEVEL_DEBUG3LOG_LEVEL_DEBUG2LOG_LEVEL_DEBUG1LOG_LEVEL_LOGLOG_LEVEL_NOTICELOG_LEVEL_WARNINGLOG_LEVEL_ERRORLOG_LEVEL_FATALLOG_LEVEL_PANIC
LogStatement
LOG_STATEMENT_UNSPECIFIEDLOG_STATEMENT_NONELOG_STATEMENT_DDLLOG_STATEMENT_MODLOG_STATEMENT_ALL
PasswordEncryption
PASSWORD_ENCRYPTION_UNSPECIFIEDPASSWORD_ENCRYPTION_MD5PASSWORD_ENCRYPTION_SCRAM_SHA_256
PgHintPlanDebugPrint
PG_HINT_PLAN_DEBUG_PRINT_UNSPECIFIEDPG_HINT_PLAN_DEBUG_PRINT_OFFPG_HINT_PLAN_DEBUG_PRINT_ONPG_HINT_PLAN_DEBUG_PRINT_DETAILEDPG_HINT_PLAN_DEBUG_PRINT_VERBOSE
PlanCacheMode
PLAN_CACHE_MODE_UNSPECIFIEDPLAN_CACHE_MODE_AUTOPLAN_CACHE_MODE_FORCE_CUSTOM_PLANPLAN_CACHE_MODE_FORCE_GENERIC_PLAN
SharedPreloadLibraries
SHARED_PRELOAD_LIBRARIES_UNSPECIFIEDSHARED_PRELOAD_LIBRARIES_AUTO_EXPLAINSHARED_PRELOAD_LIBRARIES_PG_HINT_PLANSHARED_PRELOAD_LIBRARIES_TIMESCALEDBSHARED_PRELOAD_LIBRARIES_PG_QUALSTATSSHARED_PRELOAD_LIBRARIES_PG_CRONSHARED_PRELOAD_LIBRARIES_PGLOGICALSHARED_PRELOAD_LIBRARIES_PG_PREWARMSHARED_PRELOAD_LIBRARIES_PGAUDITSHARED_PRELOAD_LIBRARIES_ANON
SynchronousCommit
SYNCHRONOUS_COMMIT_UNSPECIFIEDSYNCHRONOUS_COMMIT_ONSYNCHRONOUS_COMMIT_OFFSYNCHRONOUS_COMMIT_LOCALSYNCHRONOUS_COMMIT_REMOTE_WRITESYNCHRONOUS_COMMIT_REMOTE_APPLY
TransactionIsolation
TRANSACTION_ISOLATION_UNSPECIFIEDTRANSACTION_ISOLATION_READ_UNCOMMITTEDTRANSACTION_ISOLATION_READ_COMMITTEDTRANSACTION_ISOLATION_REPEATABLE_READTRANSACTION_ISOLATION_SERIALIZABLE
WalLevel
WAL_LEVEL_UNSPECIFIEDWAL_LEVEL_REPLICAWAL_LEVEL_LOGICAL
XmlBinary
XML_BINARY_UNSPECIFIEDXML_BINARY_BASE64XML_BINARY_HEX
XmlOption
XML_OPTION_UNSPECIFIEDXML_OPTION_DOCUMENTXML_OPTION_CONTENT
maxConnections : google.protobuf.Int64Value
sharedBuffers : google.protobuf.Int64Value
in bytes.
tempBuffers : google.protobuf.Int64Value
in bytes.
maxPreparedTransactions : google.protobuf.Int64Value
workMem : google.protobuf.Int64Value
in bytes.
maintenanceWorkMem : google.protobuf.Int64Value
in bytes.
autovacuumWorkMem : google.protobuf.Int64Value
in bytes.
tempFileLimit : google.protobuf.Int64Value
in bytes.
vacuumCostDelay : google.protobuf.Int64Value
in milliseconds.
vacuumCostPageHit : google.protobuf.Int64Value
vacuumCostPageMiss : google.protobuf.Int64Value
vacuumCostPageDirty : google.protobuf.Int64Value
vacuumCostLimit : google.protobuf.Int64Value
bgwriterDelay : google.protobuf.Int64Value
in milliseconds.
bgwriterLruMaxpages : google.protobuf.Int64Value
bgwriterLruMultiplier : google.protobuf.DoubleValue
bgwriterFlushAfter : google.protobuf.Int64Value
in bytes
backendFlushAfter : google.protobuf.Int64Value
in bytes
oldSnapshotThreshold : google.protobuf.Int64Value
walLevel : WalLevel
synchronousCommit : SynchronousCommit
checkpointTimeout : google.protobuf.Int64Value
in milliseconds.
checkpointCompletionTarget : google.protobuf.DoubleValue
checkpointFlushAfter : google.protobuf.Int64Value
in bytes
maxWalSize : google.protobuf.Int64Value
in bytes.
minWalSize : google.protobuf.Int64Value
in bytes.
maxStandbyStreamingDelay : google.protobuf.Int64Value
in milliseconds.
defaultStatisticsTarget : google.protobuf.Int64Value
constraintExclusion : ConstraintExclusion
cursorTupleFraction : google.protobuf.DoubleValue
fromCollapseLimit : google.protobuf.Int64Value
joinCollapseLimit : google.protobuf.Int64Value
forceParallelMode : ForceParallelMode
clientMinMessages : LogLevel
logMinMessages : LogLevel
logMinErrorStatement : LogLevel
logMinDurationStatement : google.protobuf.Int64Value
in milliseconds.
logCheckpoints : google.protobuf.BoolValue
logConnections : google.protobuf.BoolValue
logDisconnections : google.protobuf.BoolValue
logDuration : google.protobuf.BoolValue
logErrorVerbosity : LogErrorVerbosity
logLockWaits : google.protobuf.BoolValue
logStatement : LogStatement
logTempFiles : google.protobuf.Int64Value
searchPath : string
rowSecurity : google.protobuf.BoolValue
defaultTransactionIsolation : TransactionIsolation
statementTimeout : google.protobuf.Int64Value
in milliseconds.
lockTimeout : google.protobuf.Int64Value
in milliseconds.
idleInTransactionSessionTimeout : google.protobuf.Int64Value
in milliseconds.
byteaOutput : ByteaOutput
xmlbinary : XmlBinary
xmloption : XmlOption
ginPendingListLimit : google.protobuf.Int64Value
in bytes.
deadlockTimeout : google.protobuf.Int64Value
in milliseconds.
maxLocksPerTransaction : google.protobuf.Int64Value
maxPredLocksPerTransaction : google.protobuf.Int64Value
arrayNulls : google.protobuf.BoolValue
backslashQuote : BackslashQuote
defaultWithOids : google.protobuf.BoolValue
escapeStringWarning : google.protobuf.BoolValue
loCompatPrivileges : google.protobuf.BoolValue
quoteAllIdentifiers : google.protobuf.BoolValue
standardConformingStrings : google.protobuf.BoolValue
synchronizeSeqscans : google.protobuf.BoolValue
transformNullEquals : google.protobuf.BoolValue
exitOnError : google.protobuf.BoolValue
seqPageCost : google.protobuf.DoubleValue
randomPageCost : google.protobuf.DoubleValue
autovacuumMaxWorkers : google.protobuf.Int64Value
autovacuumVacuumCostDelay : google.protobuf.Int64Value
autovacuumVacuumCostLimit : google.protobuf.Int64Value
autovacuumNaptime : google.protobuf.Int64Value
in milliseconds.
archiveTimeout : google.protobuf.Int64Value
in milliseconds.
trackActivityQuerySize : google.protobuf.Int64Value
onlineAnalyzeEnable : google.protobuf.BoolValue
enableBitmapscan : google.protobuf.BoolValue
enableHashagg : google.protobuf.BoolValue
enableHashjoin : google.protobuf.BoolValue
enableIndexscan : google.protobuf.BoolValue
enableIndexonlyscan : google.protobuf.BoolValue
enableMaterial : google.protobuf.BoolValue
enableMergejoin : google.protobuf.BoolValue
enableNestloop : google.protobuf.BoolValue
enableSeqscan : google.protobuf.BoolValue
enableSort : google.protobuf.BoolValue
enableTidscan : google.protobuf.BoolValue
maxWorkerProcesses : google.protobuf.Int64Value
maxParallelWorkers : google.protobuf.Int64Value
maxParallelWorkersPerGather : google.protobuf.Int64Value
autovacuumVacuumScaleFactor : google.protobuf.DoubleValue
autovacuumAnalyzeScaleFactor : google.protobuf.DoubleValue
defaultTransactionReadOnly : google.protobuf.BoolValue
timezone : string
enableParallelAppend : google.protobuf.BoolValue
enableParallelHash : google.protobuf.BoolValue
enablePartitionPruning : google.protobuf.BoolValue
enablePartitionwiseAggregate : google.protobuf.BoolValue
enablePartitionwiseJoin : google.protobuf.BoolValue
jit : google.protobuf.BoolValue
maxParallelMaintenanceWorkers : google.protobuf.Int64Value
parallelLeaderParticipation : google.protobuf.BoolValue
logTransactionSampleRate : google.protobuf.DoubleValue
planCacheMode : PlanCacheMode
effectiveIoConcurrency : google.protobuf.Int64Value
effectiveCacheSize : google.protobuf.Int64Value
sharedPreloadLibraries : SharedPreloadLibraries
autoExplainLogMinDuration : google.protobuf.Int64Value
in milliseconds.
autoExplainLogAnalyze : google.protobuf.BoolValue
autoExplainLogBuffers : google.protobuf.BoolValue
autoExplainLogTiming : google.protobuf.BoolValue
autoExplainLogTriggers : google.protobuf.BoolValue
autoExplainLogVerbose : google.protobuf.BoolValue
autoExplainLogNestedStatements : google.protobuf.BoolValue
autoExplainSampleRate : google.protobuf.DoubleValue
pgHintPlanEnableHint : google.protobuf.BoolValue
pgHintPlanEnableHintTable : google.protobuf.BoolValue
pgHintPlanDebugPrint : PgHintPlanDebugPrint
pgHintPlanMessageLevel : LogLevel
hashMemMultiplier : google.protobuf.DoubleValue
logicalDecodingWorkMem : google.protobuf.Int64Value
in bytes.
maintenanceIoConcurrency : google.protobuf.Int64Value
maxSlotWalKeepSize : google.protobuf.Int64Value
in bytes.
walKeepSize : google.protobuf.Int64Value
in bytes.
enableIncrementalSort : google.protobuf.BoolValue
autovacuumVacuumInsertThreshold : google.protobuf.Int64Value
autovacuumVacuumInsertScaleFactor : google.protobuf.DoubleValue
logMinDurationSample : google.protobuf.Int64Value
in milliseconds.
logStatementSampleRate : google.protobuf.DoubleValue
logParameterMaxLength : google.protobuf.Int64Value
in bytes.
logParameterMaxLengthOnError : google.protobuf.Int64Value
in bytes.
clientConnectionCheckInterval : google.protobuf.Int64Value
in milliseconds.
enableAsyncAppend : google.protobuf.BoolValue
enableGathermerge : google.protobuf.BoolValue
enableMemoize : google.protobuf.BoolValue
logRecoveryConflictWaits : google.protobuf.BoolValue
in milliseconds.
vacuumFailsafeAge : google.protobuf.Int64Value
in milliseconds.
vacuumMultixactFailsafeAge : google.protobuf.Int64Value
in milliseconds.
pgQualstatsEnabled : google.protobuf.BoolValue
pgQualstatsTrackConstants : google.protobuf.BoolValue
pgQualstatsMax : google.protobuf.Int64Value
pgQualstatsResolveOids : google.protobuf.BoolValue
pgQualstatsSampleRate : google.protobuf.DoubleValue
plantunerFixEmptyTable : google.protobuf.BoolValue
maxStackDepth : google.protobuf.Int64Value
in bytes.
enableGroupByReordering : google.protobuf.BoolValue
geqo : google.protobuf.BoolValue
enable Genetic Query Optimizer, by default is on
geqoThreshold : google.protobuf.Int64Value
The number of tables to use geqo, default is 12
geqoEffort : google.protobuf.Int64Value
tradeoff between planning time and query plan quality, default is 5
geqoPoolSize : google.protobuf.Int64Value
number of individuals in the genetic population, useful values are typically 100 to 1000; default - 0 - choose based on based on geqo_effort
geqoGenerations : google.protobuf.Int64Value
the number of generations used by GEQO, useful values are in the same range as the pool size
geqoSelectionBias : google.protobuf.DoubleValue
selective pressure within the population
geqoSeed : google.protobuf.DoubleValue
initial value of the random number generator used by GEQO
pgTrgmSimilarityThreshold : google.protobuf.DoubleValue
pgTrgmWordSimilarityThreshold : google.protobuf.DoubleValue
pgTrgmStrictWordSimilarityThreshold : google.protobuf.DoubleValue
maxStandbyArchiveDelay : google.protobuf.Int64Value
in milliseconds.
sessionDurationTimeout : google.protobuf.Int64Value
Terminate any session that exceeds the designated timeout, specified in milliseconds. If a timeout is not specified, the default session timeout is set to 12 hours. To disable it, specify a value of 0.
logReplicationCommands : google.protobuf.BoolValue
logAutovacuumMinDuration : google.protobuf.Int64Value
in milliseconds. The default is 1000 (1 sec).
passwordEncryption : PasswordEncryption
A default value for user_password_encryption user-level setting, if it not specified for new users. Possible values are PASSWORD_ENCRYPTION_MD5 or PASSWORD_ENCRYPTION_SCRAM_SHA_256. The default is PASSWORD_ENCRYPTION_MD5.
PostgresqlConfig16
Options and structure of PostgresqlConfig reflects PostgreSQL configuration file
parameters which detailed description is available in
PostgreSQL documentation.
BackslashQuote
BACKSLASH_QUOTE_UNSPECIFIEDBACKSLASH_QUOTEBACKSLASH_QUOTE_ONBACKSLASH_QUOTE_OFFBACKSLASH_QUOTE_SAFE_ENCODING
ByteaOutput
BYTEA_OUTPUT_UNSPECIFIEDBYTEA_OUTPUT_HEXBYTEA_OUTPUT_ESCAPED
ConstraintExclusion
CONSTRAINT_EXCLUSION_UNSPECIFIEDCONSTRAINT_EXCLUSION_ONCONSTRAINT_EXCLUSION_OFFCONSTRAINT_EXCLUSION_PARTITION
DebugParallelQuery
DEBUG_PARALLEL_QUERY_UNSPECIFIEDDEBUG_PARALLEL_QUERY_ONDEBUG_PARALLEL_QUERY_OFFDEBUG_PARALLEL_QUERY_REGRESS
LogErrorVerbosity
LOG_ERROR_VERBOSITY_UNSPECIFIEDLOG_ERROR_VERBOSITY_TERSELOG_ERROR_VERBOSITY_DEFAULTLOG_ERROR_VERBOSITY_VERBOSE
LogLevel
LOG_LEVEL_UNSPECIFIEDLOG_LEVEL_DEBUG5LOG_LEVEL_DEBUG4LOG_LEVEL_DEBUG3LOG_LEVEL_DEBUG2LOG_LEVEL_DEBUG1LOG_LEVEL_INFOLOG_LEVEL_LOGLOG_LEVEL_NOTICELOG_LEVEL_WARNINGLOG_LEVEL_ERRORLOG_LEVEL_FATALLOG_LEVEL_PANIC
LogStatement
LOG_STATEMENT_UNSPECIFIEDLOG_STATEMENT_NONELOG_STATEMENT_DDLLOG_STATEMENT_MODLOG_STATEMENT_ALL
PasswordEncryption
PASSWORD_ENCRYPTION_UNSPECIFIEDPASSWORD_ENCRYPTION_MD5PASSWORD_ENCRYPTION_SCRAM_SHA_256
PgHintPlanDebugPrint
PG_HINT_PLAN_DEBUG_PRINT_UNSPECIFIEDPG_HINT_PLAN_DEBUG_PRINT_OFFPG_HINT_PLAN_DEBUG_PRINT_ONPG_HINT_PLAN_DEBUG_PRINT_DETAILEDPG_HINT_PLAN_DEBUG_PRINT_VERBOSE
PlanCacheMode
PLAN_CACHE_MODE_UNSPECIFIEDPLAN_CACHE_MODE_AUTOPLAN_CACHE_MODE_FORCE_CUSTOM_PLANPLAN_CACHE_MODE_FORCE_GENERIC_PLAN
SharedPreloadLibraries
SHARED_PRELOAD_LIBRARIES_UNSPECIFIEDSHARED_PRELOAD_LIBRARIES_AUTO_EXPLAINSHARED_PRELOAD_LIBRARIES_PG_HINT_PLANSHARED_PRELOAD_LIBRARIES_TIMESCALEDBSHARED_PRELOAD_LIBRARIES_PG_QUALSTATSSHARED_PRELOAD_LIBRARIES_PG_CRONSHARED_PRELOAD_LIBRARIES_PGLOGICALSHARED_PRELOAD_LIBRARIES_PG_PREWARMSHARED_PRELOAD_LIBRARIES_PGAUDITSHARED_PRELOAD_LIBRARIES_ANON
SynchronousCommit
SYNCHRONOUS_COMMIT_UNSPECIFIEDSYNCHRONOUS_COMMIT_ONSYNCHRONOUS_COMMIT_OFFSYNCHRONOUS_COMMIT_LOCALSYNCHRONOUS_COMMIT_REMOTE_WRITESYNCHRONOUS_COMMIT_REMOTE_APPLY
TransactionIsolation
TRANSACTION_ISOLATION_UNSPECIFIEDTRANSACTION_ISOLATION_READ_UNCOMMITTEDTRANSACTION_ISOLATION_READ_COMMITTEDTRANSACTION_ISOLATION_REPEATABLE_READTRANSACTION_ISOLATION_SERIALIZABLE
WalLevel
WAL_LEVEL_UNSPECIFIEDWAL_LEVEL_REPLICAWAL_LEVEL_LOGICAL
XmlBinary
XML_BINARY_UNSPECIFIEDXML_BINARY_BASE64XML_BINARY_HEX
XmlOption
XML_OPTION_UNSPECIFIEDXML_OPTION_DOCUMENTXML_OPTION_CONTENT
maxConnections : google.protobuf.Int64Value
sharedBuffers : google.protobuf.Int64Value
in bytes.
tempBuffers : google.protobuf.Int64Value
in bytes.
maxPreparedTransactions : google.protobuf.Int64Value
workMem : google.protobuf.Int64Value
in bytes.
maintenanceWorkMem : google.protobuf.Int64Value
in bytes.
autovacuumWorkMem : google.protobuf.Int64Value
in bytes.
tempFileLimit : google.protobuf.Int64Value
in bytes.
vacuumCostDelay : google.protobuf.Int64Value
in milliseconds.
vacuumCostPageHit : google.protobuf.Int64Value
vacuumCostPageMiss : google.protobuf.Int64Value
vacuumCostPageDirty : google.protobuf.Int64Value
vacuumCostLimit : google.protobuf.Int64Value
bgwriterDelay : google.protobuf.Int64Value
in milliseconds.
bgwriterLruMaxpages : google.protobuf.Int64Value
bgwriterLruMultiplier : google.protobuf.DoubleValue
bgwriterFlushAfter : google.protobuf.Int64Value
in bytes
backendFlushAfter : google.protobuf.Int64Value
in bytes
oldSnapshotThreshold : google.protobuf.Int64Value
walLevel : WalLevel
synchronousCommit : SynchronousCommit
checkpointTimeout : google.protobuf.Int64Value
in milliseconds.
checkpointCompletionTarget : google.protobuf.DoubleValue
checkpointFlushAfter : google.protobuf.Int64Value
in bytes
maxWalSize : google.protobuf.Int64Value
in bytes.
minWalSize : google.protobuf.Int64Value
in bytes.
maxStandbyStreamingDelay : google.protobuf.Int64Value
in milliseconds.
defaultStatisticsTarget : google.protobuf.Int64Value
constraintExclusion : ConstraintExclusion
cursorTupleFraction : google.protobuf.DoubleValue
fromCollapseLimit : google.protobuf.Int64Value
joinCollapseLimit : google.protobuf.Int64Value
debugParallelQuery : DebugParallelQuery
clientMinMessages : LogLevel
logMinMessages : LogLevel
logMinErrorStatement : LogLevel
logMinDurationStatement : google.protobuf.Int64Value
in milliseconds.
logCheckpoints : google.protobuf.BoolValue
logConnections : google.protobuf.BoolValue
logDisconnections : google.protobuf.BoolValue
logDuration : google.protobuf.BoolValue
logErrorVerbosity : LogErrorVerbosity
logLockWaits : google.protobuf.BoolValue
logStatement : LogStatement
logTempFiles : google.protobuf.Int64Value
searchPath : string
rowSecurity : google.protobuf.BoolValue
defaultTransactionIsolation : TransactionIsolation
statementTimeout : google.protobuf.Int64Value
in milliseconds.
lockTimeout : google.protobuf.Int64Value
in milliseconds.
idleInTransactionSessionTimeout : google.protobuf.Int64Value
in milliseconds.
byteaOutput : ByteaOutput
xmlbinary : XmlBinary
xmloption : XmlOption
ginPendingListLimit : google.protobuf.Int64Value
in bytes.
deadlockTimeout : google.protobuf.Int64Value
in milliseconds.
maxLocksPerTransaction : google.protobuf.Int64Value
maxPredLocksPerTransaction : google.protobuf.Int64Value
arrayNulls : google.protobuf.BoolValue
backslashQuote : BackslashQuote
defaultWithOids : google.protobuf.BoolValue
escapeStringWarning : google.protobuf.BoolValue
loCompatPrivileges : google.protobuf.BoolValue
quoteAllIdentifiers : google.protobuf.BoolValue
standardConformingStrings : google.protobuf.BoolValue
synchronizeSeqscans : google.protobuf.BoolValue
transformNullEquals : google.protobuf.BoolValue
exitOnError : google.protobuf.BoolValue
seqPageCost : google.protobuf.DoubleValue
randomPageCost : google.protobuf.DoubleValue
autovacuumMaxWorkers : google.protobuf.Int64Value
autovacuumVacuumCostDelay : google.protobuf.Int64Value
autovacuumVacuumCostLimit : google.protobuf.Int64Value
autovacuumNaptime : google.protobuf.Int64Value
in milliseconds.
archiveTimeout : google.protobuf.Int64Value
in milliseconds.
trackActivityQuerySize : google.protobuf.Int64Value
enableBitmapscan : google.protobuf.BoolValue
enableHashagg : google.protobuf.BoolValue
enableHashjoin : google.protobuf.BoolValue
enableIndexscan : google.protobuf.BoolValue
enableIndexonlyscan : google.protobuf.BoolValue
enableMaterial : google.protobuf.BoolValue
enableMergejoin : google.protobuf.BoolValue
enableNestloop : google.protobuf.BoolValue
enableSeqscan : google.protobuf.BoolValue
enableSort : google.protobuf.BoolValue
enableTidscan : google.protobuf.BoolValue
maxWorkerProcesses : google.protobuf.Int64Value
maxParallelWorkers : google.protobuf.Int64Value
maxParallelWorkersPerGather : google.protobuf.Int64Value
autovacuumVacuumScaleFactor : google.protobuf.DoubleValue
autovacuumAnalyzeScaleFactor : google.protobuf.DoubleValue
defaultTransactionReadOnly : google.protobuf.BoolValue
timezone : string
enableParallelAppend : google.protobuf.BoolValue
enableParallelHash : google.protobuf.BoolValue
enablePartitionPruning : google.protobuf.BoolValue
enablePartitionwiseAggregate : google.protobuf.BoolValue
enablePartitionwiseJoin : google.protobuf.BoolValue
jit : google.protobuf.BoolValue
maxParallelMaintenanceWorkers : google.protobuf.Int64Value
parallelLeaderParticipation : google.protobuf.BoolValue
logTransactionSampleRate : google.protobuf.DoubleValue
planCacheMode : PlanCacheMode
effectiveIoConcurrency : google.protobuf.Int64Value
effectiveCacheSize : google.protobuf.Int64Value
sharedPreloadLibraries : SharedPreloadLibraries
autoExplainLogMinDuration : google.protobuf.Int64Value
in milliseconds.
autoExplainLogAnalyze : google.protobuf.BoolValue
autoExplainLogBuffers : google.protobuf.BoolValue
autoExplainLogTiming : google.protobuf.BoolValue
autoExplainLogTriggers : google.protobuf.BoolValue
autoExplainLogVerbose : google.protobuf.BoolValue
autoExplainLogNestedStatements : google.protobuf.BoolValue
autoExplainSampleRate : google.protobuf.DoubleValue
pgHintPlanEnableHint : google.protobuf.BoolValue
pgHintPlanEnableHintTable : google.protobuf.BoolValue
pgHintPlanDebugPrint : PgHintPlanDebugPrint
pgHintPlanMessageLevel : LogLevel
hashMemMultiplier : google.protobuf.DoubleValue
logicalDecodingWorkMem : google.protobuf.Int64Value
in bytes.
maintenanceIoConcurrency : google.protobuf.Int64Value
maxSlotWalKeepSize : google.protobuf.Int64Value
in bytes.
walKeepSize : google.protobuf.Int64Value
in bytes.
enableIncrementalSort : google.protobuf.BoolValue
autovacuumVacuumInsertThreshold : google.protobuf.Int64Value
autovacuumVacuumInsertScaleFactor : google.protobuf.DoubleValue
logMinDurationSample : google.protobuf.Int64Value
in milliseconds.
logStatementSampleRate : google.protobuf.DoubleValue
logParameterMaxLength : google.protobuf.Int64Value
in bytes.
logParameterMaxLengthOnError : google.protobuf.Int64Value
in bytes.
clientConnectionCheckInterval : google.protobuf.Int64Value
in milliseconds.
enableAsyncAppend : google.protobuf.BoolValue
enableGathermerge : google.protobuf.BoolValue
enableMemoize : google.protobuf.BoolValue
logRecoveryConflictWaits : google.protobuf.BoolValue
in milliseconds.
vacuumFailsafeAge : google.protobuf.Int64Value
in milliseconds.
vacuumMultixactFailsafeAge : google.protobuf.Int64Value
in milliseconds.
pgQualstatsEnabled : google.protobuf.BoolValue
pgQualstatsTrackConstants : google.protobuf.BoolValue
pgQualstatsMax : google.protobuf.Int64Value
pgQualstatsResolveOids : google.protobuf.BoolValue
pgQualstatsSampleRate : google.protobuf.DoubleValue
maxStackDepth : google.protobuf.Int64Value
in bytes.
enableGroupByReordering : google.protobuf.BoolValue
geqo : google.protobuf.BoolValue
enable Genetic Query Optimizer, by default is on
geqoThreshold : google.protobuf.Int64Value
The number of tables to use geqo, default is 12
geqoEffort : google.protobuf.Int64Value
tradeoff between planning time and query plan quality, default is 5
geqoPoolSize : google.protobuf.Int64Value
number of individuals in the genetic population, useful values are typically 100 to 1000; default - 0 - choose based on based on geqo_effort
geqoGenerations : google.protobuf.Int64Value
the number of generations used by GEQO, useful values are in the same range as the pool size
geqoSelectionBias : google.protobuf.DoubleValue
selective pressure within the population
geqoSeed : google.protobuf.DoubleValue
initial value of the random number generator used by GEQO
pgTrgmSimilarityThreshold : google.protobuf.DoubleValue
pgTrgmWordSimilarityThreshold : google.protobuf.DoubleValue
pgTrgmStrictWordSimilarityThreshold : google.protobuf.DoubleValue
maxStandbyArchiveDelay : google.protobuf.Int64Value
in milliseconds.
sessionDurationTimeout : google.protobuf.Int64Value
Terminate any session that exceeds the designated timeout, specified in milliseconds. If a timeout is not specified, the default session timeout is set to 12 hours. To disable it, specify a value of 0.
logReplicationCommands : google.protobuf.BoolValue
logAutovacuumMinDuration : google.protobuf.Int64Value
in milliseconds. The default is 1000 (1 sec).
passwordEncryption : PasswordEncryption
A default value for user_password_encryption user-level setting, if it not specified for new users. Possible values are PASSWORD_ENCRYPTION_MD5 or PASSWORD_ENCRYPTION_SCRAM_SHA_256. The default is PASSWORD_ENCRYPTION_MD5.
PostgresqlConfig16_1C
Options and structure of PostgresqlConfig reflects PostgreSQL configuration file
parameters which detailed description is available in
PostgreSQL documentation.
BackslashQuote
BACKSLASH_QUOTE_UNSPECIFIEDBACKSLASH_QUOTEBACKSLASH_QUOTE_ONBACKSLASH_QUOTE_OFFBACKSLASH_QUOTE_SAFE_ENCODING
ByteaOutput
BYTEA_OUTPUT_UNSPECIFIEDBYTEA_OUTPUT_HEXBYTEA_OUTPUT_ESCAPED
ConstraintExclusion
CONSTRAINT_EXCLUSION_UNSPECIFIEDCONSTRAINT_EXCLUSION_ONCONSTRAINT_EXCLUSION_OFFCONSTRAINT_EXCLUSION_PARTITION
DebugParallelQuery
DEBUG_PARALLEL_QUERY_UNSPECIFIEDDEBUG_PARALLEL_QUERY_ONDEBUG_PARALLEL_QUERY_OFFDEBUG_PARALLEL_QUERY_REGRESS
LogErrorVerbosity
LOG_ERROR_VERBOSITY_UNSPECIFIEDLOG_ERROR_VERBOSITY_TERSELOG_ERROR_VERBOSITY_DEFAULTLOG_ERROR_VERBOSITY_VERBOSE
LogLevel
LOG_LEVEL_UNSPECIFIEDLOG_LEVEL_DEBUG5LOG_LEVEL_DEBUG4LOG_LEVEL_DEBUG3LOG_LEVEL_DEBUG2LOG_LEVEL_DEBUG1LOG_LEVEL_INFOLOG_LEVEL_LOGLOG_LEVEL_NOTICELOG_LEVEL_WARNINGLOG_LEVEL_ERRORLOG_LEVEL_FATALLOG_LEVEL_PANIC
LogStatement
LOG_STATEMENT_UNSPECIFIEDLOG_STATEMENT_NONELOG_STATEMENT_DDLLOG_STATEMENT_MODLOG_STATEMENT_ALL
PasswordEncryption
PASSWORD_ENCRYPTION_UNSPECIFIEDPASSWORD_ENCRYPTION_MD5PASSWORD_ENCRYPTION_SCRAM_SHA_256
PgHintPlanDebugPrint
PG_HINT_PLAN_DEBUG_PRINT_UNSPECIFIEDPG_HINT_PLAN_DEBUG_PRINT_OFFPG_HINT_PLAN_DEBUG_PRINT_ONPG_HINT_PLAN_DEBUG_PRINT_DETAILEDPG_HINT_PLAN_DEBUG_PRINT_VERBOSE
PlanCacheMode
PLAN_CACHE_MODE_UNSPECIFIEDPLAN_CACHE_MODE_AUTOPLAN_CACHE_MODE_FORCE_CUSTOM_PLANPLAN_CACHE_MODE_FORCE_GENERIC_PLAN
SharedPreloadLibraries
SHARED_PRELOAD_LIBRARIES_UNSPECIFIEDSHARED_PRELOAD_LIBRARIES_AUTO_EXPLAINSHARED_PRELOAD_LIBRARIES_PG_HINT_PLANSHARED_PRELOAD_LIBRARIES_TIMESCALEDBSHARED_PRELOAD_LIBRARIES_PG_QUALSTATSSHARED_PRELOAD_LIBRARIES_PG_CRONSHARED_PRELOAD_LIBRARIES_PGLOGICALSHARED_PRELOAD_LIBRARIES_PG_PREWARMSHARED_PRELOAD_LIBRARIES_PGAUDITSHARED_PRELOAD_LIBRARIES_ANON
SynchronousCommit
SYNCHRONOUS_COMMIT_UNSPECIFIEDSYNCHRONOUS_COMMIT_ONSYNCHRONOUS_COMMIT_OFFSYNCHRONOUS_COMMIT_LOCALSYNCHRONOUS_COMMIT_REMOTE_WRITESYNCHRONOUS_COMMIT_REMOTE_APPLY
TransactionIsolation
TRANSACTION_ISOLATION_UNSPECIFIEDTRANSACTION_ISOLATION_READ_UNCOMMITTEDTRANSACTION_ISOLATION_READ_COMMITTEDTRANSACTION_ISOLATION_REPEATABLE_READTRANSACTION_ISOLATION_SERIALIZABLE
WalLevel
WAL_LEVEL_UNSPECIFIEDWAL_LEVEL_REPLICAWAL_LEVEL_LOGICAL
XmlBinary
XML_BINARY_UNSPECIFIEDXML_BINARY_BASE64XML_BINARY_HEX
XmlOption
XML_OPTION_UNSPECIFIEDXML_OPTION_DOCUMENTXML_OPTION_CONTENT
maxConnections : google.protobuf.Int64Value
sharedBuffers : google.protobuf.Int64Value
in bytes.
tempBuffers : google.protobuf.Int64Value
in bytes.
maxPreparedTransactions : google.protobuf.Int64Value
workMem : google.protobuf.Int64Value
in bytes.
maintenanceWorkMem : google.protobuf.Int64Value
in bytes.
autovacuumWorkMem : google.protobuf.Int64Value
in bytes.
tempFileLimit : google.protobuf.Int64Value
in bytes.
vacuumCostDelay : google.protobuf.Int64Value
in milliseconds.
vacuumCostPageHit : google.protobuf.Int64Value
vacuumCostPageMiss : google.protobuf.Int64Value
vacuumCostPageDirty : google.protobuf.Int64Value
vacuumCostLimit : google.protobuf.Int64Value
bgwriterDelay : google.protobuf.Int64Value
in milliseconds.
bgwriterLruMaxpages : google.protobuf.Int64Value
bgwriterLruMultiplier : google.protobuf.DoubleValue
bgwriterFlushAfter : google.protobuf.Int64Value
in bytes
backendFlushAfter : google.protobuf.Int64Value
in bytes
oldSnapshotThreshold : google.protobuf.Int64Value
walLevel : WalLevel
synchronousCommit : SynchronousCommit
checkpointTimeout : google.protobuf.Int64Value
in milliseconds.
checkpointCompletionTarget : google.protobuf.DoubleValue
checkpointFlushAfter : google.protobuf.Int64Value
in bytes
maxWalSize : google.protobuf.Int64Value
in bytes.
minWalSize : google.protobuf.Int64Value
in bytes.
maxStandbyStreamingDelay : google.protobuf.Int64Value
in milliseconds.
defaultStatisticsTarget : google.protobuf.Int64Value
constraintExclusion : ConstraintExclusion
cursorTupleFraction : google.protobuf.DoubleValue
fromCollapseLimit : google.protobuf.Int64Value
joinCollapseLimit : google.protobuf.Int64Value
debugParallelQuery : DebugParallelQuery
clientMinMessages : LogLevel
logMinMessages : LogLevel
logMinErrorStatement : LogLevel
logMinDurationStatement : google.protobuf.Int64Value
in milliseconds.
logCheckpoints : google.protobuf.BoolValue
logConnections : google.protobuf.BoolValue
logDisconnections : google.protobuf.BoolValue
logDuration : google.protobuf.BoolValue
logErrorVerbosity : LogErrorVerbosity
logLockWaits : google.protobuf.BoolValue
logStatement : LogStatement
logTempFiles : google.protobuf.Int64Value
searchPath : string
rowSecurity : google.protobuf.BoolValue
defaultTransactionIsolation : TransactionIsolation
statementTimeout : google.protobuf.Int64Value
in milliseconds.
lockTimeout : google.protobuf.Int64Value
in milliseconds.
idleInTransactionSessionTimeout : google.protobuf.Int64Value
in milliseconds.
byteaOutput : ByteaOutput
xmlbinary : XmlBinary
xmloption : XmlOption
ginPendingListLimit : google.protobuf.Int64Value
in bytes.
deadlockTimeout : google.protobuf.Int64Value
in milliseconds.
maxLocksPerTransaction : google.protobuf.Int64Value
maxPredLocksPerTransaction : google.protobuf.Int64Value
arrayNulls : google.protobuf.BoolValue
backslashQuote : BackslashQuote
defaultWithOids : google.protobuf.BoolValue
escapeStringWarning : google.protobuf.BoolValue
loCompatPrivileges : google.protobuf.BoolValue
quoteAllIdentifiers : google.protobuf.BoolValue
standardConformingStrings : google.protobuf.BoolValue
synchronizeSeqscans : google.protobuf.BoolValue
transformNullEquals : google.protobuf.BoolValue
exitOnError : google.protobuf.BoolValue
seqPageCost : google.protobuf.DoubleValue
randomPageCost : google.protobuf.DoubleValue
autovacuumMaxWorkers : google.protobuf.Int64Value
autovacuumVacuumCostDelay : google.protobuf.Int64Value
autovacuumVacuumCostLimit : google.protobuf.Int64Value
autovacuumNaptime : google.protobuf.Int64Value
in milliseconds.
archiveTimeout : google.protobuf.Int64Value
in milliseconds.
trackActivityQuerySize : google.protobuf.Int64Value
onlineAnalyzeEnable : google.protobuf.BoolValue
enableBitmapscan : google.protobuf.BoolValue
enableHashagg : google.protobuf.BoolValue
enableHashjoin : google.protobuf.BoolValue
enableIndexscan : google.protobuf.BoolValue
enableIndexonlyscan : google.protobuf.BoolValue
enableMaterial : google.protobuf.BoolValue
enableMergejoin : google.protobuf.BoolValue
enableNestloop : google.protobuf.BoolValue
enableSeqscan : google.protobuf.BoolValue
enableSort : google.protobuf.BoolValue
enableTidscan : google.protobuf.BoolValue
maxWorkerProcesses : google.protobuf.Int64Value
maxParallelWorkers : google.protobuf.Int64Value
maxParallelWorkersPerGather : google.protobuf.Int64Value
autovacuumVacuumScaleFactor : google.protobuf.DoubleValue
autovacuumAnalyzeScaleFactor : google.protobuf.DoubleValue
defaultTransactionReadOnly : google.protobuf.BoolValue
timezone : string
enableParallelAppend : google.protobuf.BoolValue
enableParallelHash : google.protobuf.BoolValue
enablePartitionPruning : google.protobuf.BoolValue
enablePartitionwiseAggregate : google.protobuf.BoolValue
enablePartitionwiseJoin : google.protobuf.BoolValue
jit : google.protobuf.BoolValue
maxParallelMaintenanceWorkers : google.protobuf.Int64Value
parallelLeaderParticipation : google.protobuf.BoolValue
logTransactionSampleRate : google.protobuf.DoubleValue
planCacheMode : PlanCacheMode
effectiveIoConcurrency : google.protobuf.Int64Value
effectiveCacheSize : google.protobuf.Int64Value
sharedPreloadLibraries : SharedPreloadLibraries
autoExplainLogMinDuration : google.protobuf.Int64Value
in milliseconds.
autoExplainLogAnalyze : google.protobuf.BoolValue
autoExplainLogBuffers : google.protobuf.BoolValue
autoExplainLogTiming : google.protobuf.BoolValue
autoExplainLogTriggers : google.protobuf.BoolValue
autoExplainLogVerbose : google.protobuf.BoolValue
autoExplainLogNestedStatements : google.protobuf.BoolValue
autoExplainSampleRate : google.protobuf.DoubleValue
pgHintPlanEnableHint : google.protobuf.BoolValue
pgHintPlanEnableHintTable : google.protobuf.BoolValue
pgHintPlanDebugPrint : PgHintPlanDebugPrint
pgHintPlanMessageLevel : LogLevel
hashMemMultiplier : google.protobuf.DoubleValue
logicalDecodingWorkMem : google.protobuf.Int64Value
in bytes.
maintenanceIoConcurrency : google.protobuf.Int64Value
maxSlotWalKeepSize : google.protobuf.Int64Value
in bytes.
walKeepSize : google.protobuf.Int64Value
in bytes.
enableIncrementalSort : google.protobuf.BoolValue
autovacuumVacuumInsertThreshold : google.protobuf.Int64Value
autovacuumVacuumInsertScaleFactor : google.protobuf.DoubleValue
logMinDurationSample : google.protobuf.Int64Value
in milliseconds.
logStatementSampleRate : google.protobuf.DoubleValue
logParameterMaxLength : google.protobuf.Int64Value
in bytes.
logParameterMaxLengthOnError : google.protobuf.Int64Value
in bytes.
clientConnectionCheckInterval : google.protobuf.Int64Value
in milliseconds.
enableAsyncAppend : google.protobuf.BoolValue
enableGathermerge : google.protobuf.BoolValue
enableMemoize : google.protobuf.BoolValue
logRecoveryConflictWaits : google.protobuf.BoolValue
in milliseconds.
vacuumFailsafeAge : google.protobuf.Int64Value
in milliseconds.
vacuumMultixactFailsafeAge : google.protobuf.Int64Value
in milliseconds.
pgQualstatsEnabled : google.protobuf.BoolValue
pgQualstatsTrackConstants : google.protobuf.BoolValue
pgQualstatsMax : google.protobuf.Int64Value
pgQualstatsResolveOids : google.protobuf.BoolValue
pgQualstatsSampleRate : google.protobuf.DoubleValue
plantunerFixEmptyTable : google.protobuf.BoolValue
maxStackDepth : google.protobuf.Int64Value
in bytes.
enableGroupByReordering : google.protobuf.BoolValue
geqo : google.protobuf.BoolValue
enable Genetic Query Optimizer, by default is on
geqoThreshold : google.protobuf.Int64Value
The number of tables to use geqo, default is 12
geqoEffort : google.protobuf.Int64Value
tradeoff between planning time and query plan quality, default is 5
geqoPoolSize : google.protobuf.Int64Value
number of individuals in the genetic population, useful values are typically 100 to 1000; default - 0 - choose based on based on geqo_effort
geqoGenerations : google.protobuf.Int64Value
the number of generations used by GEQO, useful values are in the same range as the pool size
geqoSelectionBias : google.protobuf.DoubleValue
selective pressure within the population
geqoSeed : google.protobuf.DoubleValue
initial value of the random number generator used by GEQO
pgTrgmSimilarityThreshold : google.protobuf.DoubleValue
pgTrgmWordSimilarityThreshold : google.protobuf.DoubleValue
pgTrgmStrictWordSimilarityThreshold : google.protobuf.DoubleValue
maxStandbyArchiveDelay : google.protobuf.Int64Value
in milliseconds.
sessionDurationTimeout : google.protobuf.Int64Value
Terminate any session that exceeds the designated timeout, specified in milliseconds. If a timeout is not specified, the default session timeout is set to 12 hours. To disable it, specify a value of 0.
logReplicationCommands : google.protobuf.BoolValue
logAutovacuumMinDuration : google.protobuf.Int64Value
in milliseconds. The default is 1000 (1 sec).
passwordEncryption : PasswordEncryption
A default value for user_password_encryption user-level setting, if it not specified for new users. Possible values are PASSWORD_ENCRYPTION_MD5 or PASSWORD_ENCRYPTION_SCRAM_SHA_256. The default is PASSWORD_ENCRYPTION_MD5.