Retrieve information regarding PostgreSQL database connection pools.
View Specific Information
Digital Ocean supports only DatabaseId and Name columns with "=" operator as filter criteria for this view.
Note: The DatabaseId columns is a required filter. The driver will fetch a list of all database clusters if this filter is not present as part of the criteria.
SELECT * FROM DatabaseConnectionPools WHERE DatabaseId='9cc10173-e9ea-4176-9dbc-a4cee4c4ff30' AND Name = 'DatabaseName'
You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any other search criteria will be ignored and an unfiltered response will be returned.
|Name [KEY]||String||The name for the connection pool.|
|DatabaseId||String||A unique ID that can be used to identify and reference a database cluster.|
|ConnectionDatabase||String||The name of the default database.|
|ConnectionHost||String||The FQDN pointing to the database cluster's current primary node.|
|ConnectionPassword||String||The randomly generated password for the default user.|
|ConnectionPort||Integer||The port on which the database cluster is listening.|
|ConnectionSsl||Boolean||A boolean value indicating if the connection should be made over SSL.|
|ConnectionUri||String||A connection string in the format accepted by the psql command. This is provided as a convenience and should be able to be constructed by the other attributes.|
|ConnectionUser||String||The default user for the database.|
|Database||String||The database for use with the connection pool.|
|User||String||The name of the user for use with the connection pool.|
|Size||Integer||The size of the PGBouncer connection pool.|
|Mode||String||The PGBouncer pool mode for the connection pool. The allowed values are session, transaction, and statement.|