Table: kubernetes_persistent_volume_claim - Query Kubernetes Persistent Volume Claims using SQL

A Kubernetes Persistent Volume Claim (PVC) is a request for storage by a user. It is similar to a pod in Kubernetes. PVCs can request specific size and access modes like read and write for a Persistent Volume (PV).

Table Usage Guide

The kubernetes_persistent_volume_claim table provides insights into the Persistent Volume Claims within a Kubernetes cluster. As a DevOps engineer, you can use this table to explore details about each claim, including its current status, requested storage capacity, and access modes. This table is beneficial when you need to manage storage resources or troubleshoot storage-related issues in your Kubernetes environment.

Examples

Basic Info

Explore the status and capacity of persistent storage volumes in a Kubernetes environment. This can help you manage resources effectively and ensure optimal allocation and usage.

select
  name,
  namespace,
  volume_name as volume,
  volume_mode,
  access_modes,
  phase as status,
  capacity ->> 'storage' as capacity,
  creation_timestamp,
  data_source,
  selector,
  resources,
  age(current_timestamp, creation_timestamp)
from
  kubernetes_persistent_volume_claim;

select
  name,
  namespace,
  volume_name as volume,
  volume_mode,
  access_modes,
  phase as status,
  json_extract(capacity, '$.storage') as capacity,
  creation_timestamp,
  data_source,
  selector,
  resources,
  (julianday('now') - julianday(creation_timestamp)) * 24 * 60 * 60 as age
from
  kubernetes_persistent_volume_claim;

List manifest resources

Explore the various resources within a manifest by identifying their names, namespaces, and statuses. This is useful for understanding the capacity and configuration of your persistent storage volumes, particularly when you need to assess the availability and allocation of resources.

select
  name,
  namespace,
  volume_name as volume,
  volume_mode,
  access_modes,
  phase as status,
  capacity ->> 'storage' as capacity,
  data_source,
  selector,
  resources,
  path
from
  kubernetes_persistent_volume_claim
where
  path is not null;

select
  name,
  namespace,
  volume_name as volume,
  volume_mode,
  access_modes,
  phase as status,
  json_extract(capacity, '$.storage') as capacity,
  data_source,
  selector,
  resources,
  path
from
  kubernetes_persistent_volume_claim
where
  path is not null;

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

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

steampipe_export_kubernetes --config '<your_config>' kubernetes_persistent_volume_claim