doctl Verified current stable Not installed? Cloud Infrastructure

Doctl / Retrieve Database Connection Pool Info

Retrieve Database Connection Pool Info

Retrieve information regarding a database connection pool.

$
Terminal
doctl d p g <database_id> <pool_name>

When To Use

When detailed statistics and configurations of the pool are required for optimization.

Pro Tip

Retrieve pool info during peak hours for performance benchmarking.

Command Builder

Tune the command before you copy it

Back to syntax
$
Generated Command
doctl d p g <database_id> <pool_name>

Anatomy of Output

Understanding the result

Pool Name: main-app-pool Pool Name

The identifier of the connection pool.

Max Connections: 10 Connections Cap

Maximum allowable connections for this pool.

Database ID: 345678 Database ID

The associated database identifier.

Power User Variants

Optimized versions

doctl databases pool get 345678 main-app-pool --verbose

Get detailed pool information with additional metadata.

doctl databases pool get 345678 main-app-pool --format json

Retrieve pool info formatted in JSON.

Troubleshooting

Common pitfalls

Error: Pool not found.

Solution: Verify the pool name and ensure it matches an existing pool.

Error: Database ID is required.

Solution: Provide a valid database ID.

Error: Failed to retrieve pool information - network timeout.

Solution: Check network connection or try again later.

Command Breakdown

What each part is doing

doctl
Base Command
The executable that performs this operation. Here it runs Doctl before the shell applies any redirect operators.
d
d|databases
The value supplied for d|databases.
p
p|pool
The value supplied for p|pool.
g
g|get
The value supplied for g|get.
<database_id>
database id
The value supplied for database id.
<pool_name>
pool name
The value supplied for pool name.

Alternative Approaches

Comparable commands in other tools

Alternative cloud infrastructure tools for the same job.