turbot/cloudflare
steampipe plugin install cloudflare

Table: cloudflare_load_balancer_pool - Query Cloudflare Load Balancer Pools using SQL

Cloudflare Load Balancer Pools are a component of Cloudflare's Load Balancing service. They consist of one or more origin servers where Cloudflare can direct traffic. These pools provide a way to distribute network or application traffic across many servers to optimize resource usage, reduce latency, and increase capacity to handle large amounts of traffic.

Table Usage Guide

The cloudflare_load_balancer_pool table provides insights into Load Balancer Pools within Cloudflare's Load Balancing service. As a network administrator, explore pool-specific details through this table, including pool ID, creation date, description, and enabled status. Utilize it to uncover information about pools, such as their geographical distribution, the health of the servers within them, and the balance of traffic across the servers.

Examples

Basic info

Explore the status and details of Cloudflare load balancer pools, such as their names, identifiers, and whether they are enabled or not. This information can be useful in understanding and managing the distribution of network traffic across multiple servers.

select
name,
id,
enabled,
description,
created_on,
jsonb_pretty(origins) as origins
from
cloudflare_load_balancer_pool;
select
name,
id,
enabled,
description,
created_on,
origins
from
cloudflare_load_balancer_pool;

List active pools

Analyze the settings to understand the active load balancer pools in your Cloudflare account. This can help you manage your resources effectively by identifying which pools are currently in use.

select
name,
id,
monitor
from
cloudflare_load_balancer_pool
where
enabled;
select
name,
id,
monitor
from
cloudflare_load_balancer_pool
where
enabled = 1;

Schema for cloudflare_load_balancer_pool

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
check_regionsjsonbA list of regions (specified by region code) from which to run health checks.
created_ontimestamp with time zoneTimestamp when the pool was created.
descriptiontextDescription for the pool.
enabledbooleanStatus of this pool. Disabled pools will not receive traffic and are excluded from health checks.
idtextThe API item identifier.
latitudetextThe latitude this pool is physically located at; used for proximity steering. Values should be between -90 and 90.
load_sheddingjsonbSetting for controlling load shedding for this pool.
longitudetextThe longitude this pool is physically located at; used for proximity steering. Values should be between -180 and 180.
minimum_originsbigintThe minimum number of origins that must be healthy for this pool to serve traffic. If the number of healthy origins falls below this number, the pool will be marked unhealthy and we will failover to the next available pool. Default: 1.
modified_ontimestamp with time zoneTimestamp when the pool was last modified.
monitortextThe ID of the Monitor to use for health checking origins within this pool.
nametextA short name for the pool.
notification_emailtextThe email address to send health status notifications to. This can be an individual mailbox or a mailing list. Multiple emails can be supplied as a comma delimited list.
originsjsonbThe list of origins within this pool. Traffic directed at this pool is balanced across all currently healthy origins, provided the pool itself is healthy.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- cloudflare

You can pass the configuration to the command with the --config argument:

steampipe_export_cloudflare --config '<your_config>' cloudflare_load_balancer_pool