gcloud sql instances describe YourInstance

gcloud sql instances describe YourInstance

backendType: SECOND_GEN
connectionName: yourproject:europe-west3:prod
createTime: '2020-04-05T19:12:22.734Z'
databaseInstalledVersion: POSTGRES_11_16
databaseVersion: POSTGRES_11
etag: 2e128ab6c656xxdsf53da41455d40259df8e05afdasf
gceZone: europe-west3-b
instanceType: CLOUD_SQL_INSTANCE
ipAddresses:
- ipAddress: 55.242.253.10
  type: PRIMARY
- ipAddress: 55.242.211.10
  type: OUTGOING
- ipAddress: 10.28.32.25
  type: PRIVATE
kind: sql#instance
maintenanceVersion: POSTGRES_11_16.R20220710.01_08
name: YourInstance
project: yourproject
region: europe-west3
selfLink: https://sqladmin.googleapis.com/sql/v1beta4/projects/yourproject/instances/prod
serverCaCert:
  cert: |-
    -----BEGIN CERTIFICATE-----
    asdgaggdasgBAgIBADANBgkqhkiG9w0BAQsFADB3MS0wKwYDVQQuEyQ5MDc2
    ODgyZS1kZjY4LTQ1YjUtYTJkNS1lOTBhN2ZiNTkxZTgxIzAhBgNVBAMTGkdvb2ds
    .../...
    FfAseyh9oS6phYpWcX+NWohEKO26f6FzuoMdWTXUNNasOvbpAQWOAqvYGh6Cqgxz
    NMd5tvt8v/aIqDf1CvamNdCZHAfOavOlTAPZ0tdYP0XuRDzKiGma5tvgryDMyKqn
    zdGtZqdPPe4ofx2fqUluDgu+EgZBX0RpUNEDe5upquaMoEGuHMSa+gtHfJA8CjoY
    Oz/uBXnWUpOEbfq7poW/eB69Xadfasf
    -----END CERTIFICATE-----
  certSerialNumber: '0'
  commonName: C=US,O=Google\, Inc,CN=Google Cloud SQL Server CA,dnQualifier=907asfadf-df68-45b5-a2d5-e90a7fb591e8
  createTime: '2020-04-05T19:13:20.693Z'
  expirationTime: '2030-04-03T19:14:20.693Z'
  instance: YourInstance
  kind: sql#sslCert
  sha1Fingerprint: gasdfg14b9824aadfasfsdfg0ed7c0f4d7c4a06
serviceAccountEmailAddress: [email protected]
settings:
  activationPolicy: ALWAYS
  availabilityType: ZONAL
  backupConfiguration:
    backupRetentionSettings:
      retainedBackups: 7
      retentionUnit: COUNT
    enabled: true
    kind: sql#backupConfiguration
    pointInTimeRecoveryEnabled: false
    replicationLogArchivingEnabled: false
    startTime: 04:00
    transactionLogRetentionDays: 7
  connectorEnforcement: NOT_REQUIRED
  dataDiskSizeGb: '203'
  dataDiskType: PD_SSD
  ipConfiguration:
    authorizedNetworks:
    - kind: sql#aclEntry
      name: 
      value: 55.246.195.10/32
    - kind: sql#aclEntry
      name: 
      value: 55.246.204.10/32
    - kind: sql#aclEntry
      name: 
      value: 55.246.243.10/32
    ipv4Enabled: true
    privateNetwork: projects/yourproject/global/networks/default
  kind: sql#settings
  locationPreference:
    kind: sql#locationPreference
    zone: europe-west3-b
  maintenanceWindow:
    day: 0
    hour: 0
    kind: sql#maintenanceWindow
  pricingPlan: PER_USE
  replicationType: SYNCHRONOUS
  settingsVersion: '178'
  storageAutoResize: true
  storageAutoResizeLimit: '0'
  tier: db-custom-8-30720
state: RUNNABLE

See also

• Cloud SQL: gcloud sql [ databases | import | export | instances | backups ]