Table: linode_volume - Query Linode Volumes using SQL

Linode Volumes are a type of block storage that can be attached to Linode instances. They are highly available, automatically replicated, and allow users to create, resize, and move volumes within a Linode instance. Volumes are scalable and designed for 99.9% durability.

Table Usage Guide

The linode_volume table provides insights into the block storage volumes within Linode. As a system administrator or DevOps engineer, you can explore volume-specific details through this table, including size, region, and associated Linode instance. Utilize it to uncover information about volumes, such as their current status, creation time, and the Linode instance they are attached to.

Examples

List volumes

Explore all available storage volumes within your Linode service. This can help you manage your storage resources effectively and plan for capacity upgrades if necessary.

select
  *
from
  linode_volume;

select
  *
from
  linode_volume;

Find volumes in a bad state

Discover the segments that have volumes in a suboptimal condition, requiring support intervention, to understand potential issues and regions affected. This aids in troubleshooting and maintaining system health.

select
  label,
  size,
  status,
  region
from
  linode_volume
where
  status = 'contact_support';

select
  label,
  size,
  status,
  region
from
  linode_volume
where
  status = 'contact_support';

Volumes with a given tag

Explore which storage volumes are associated with a specific tag to manage resources effectively across different regions.

select
  label,
  size,
  status,
  region
from
  linode_volume
where
  tags ? 'foo'

Error: SQLite does not support the '?' operator for checking the existence of a key in a JSON object.

Top 5 volumes by size

Discover the segments that have the largest volume sizes to better manage storage resources and optimize data distribution across different regions. This is particularly useful for identifying potential areas for data cleanup or redistribution to improve system performance.

select
  label,
  size,
  status,
  region
from
  linode_volume
order by
  size desc
limit
  5;

select
  label,
  size,
  status,
  region
from
  linode_volume
order by
  size desc
limit
  5;

Schema for linode_volume

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
created	timestamp with time zone		When this Volume was created.
filesystem_path	text		The full filesystem path for the Volume based on the Volume’s label.
filter	text	=	Raw Linode list filter string in JSON format.
id	bigint	=	The unique ID of this Volume.
label	text	=	The Volume’s label is for display purposes only.
linode_id	bigint		If a Volume is attached to a specific Linode, the ID of that Linode will be displayed here.
region	text		Region where the volume resides.
size	bigint		The Volume’s size, in GiB.
status	text		The current status of the volume: creating, active, resizing, contact_support.
tags	jsonb		Tags applied to this volume as a map.
tags_src	jsonb		List of Tags applied to this volume.
updated	timestamp with time zone		When this Volume was last updated.

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)" -- linode

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

steampipe_export_linode --config '<your_config>' linode_volume