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

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
check_regions	jsonb		A list of regions (specified by region code) from which to run health checks.
created_on	timestamp with time zone		Timestamp when the pool was created.
description	text		Description for the pool.
enabled	boolean		Status of this pool. Disabled pools will not receive traffic and are excluded from health checks.
id	text		The API item identifier.
latitude	text		The latitude this pool is physically located at; used for proximity steering. Values should be between -90 and 90.
load_shedding	jsonb		Setting for controlling load shedding for this pool.
longitude	text		The longitude this pool is physically located at; used for proximity steering. Values should be between -180 and 180.
minimum_origins	bigint		The 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_on	timestamp with time zone		Timestamp when the pool was last modified.
monitor	text		The ID of the Monitor to use for health checking origins within this pool.
name	text		A short name for the pool.
notification_email	text		The 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.
origins	jsonb		The list of origins within this pool. Traffic directed at this pool is balanced across all currently healthy origins, provided the pool itself is healthy.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
user_id	text	=, !=, ~~, ~~, !~~, !~~	ID of the current user.

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