postgresql-storage-check

Diagnose PostgreSQL storage health across Kubernetes Patroni pods via SQL and kubectl.

1|3|Updated Mar 23, 2026

Search Tags:#postgresql #kubernetes #storage #bloat #wal #replication-slots

Ready to run

npx skills add https://github.com/IldarMinaev/troubleshooting-skill --skill postgresql-storage-check

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: postgresql-storage-check
Source: https://github.com/IldarMinaev/troubleshooting-skill/tree/main/skills/postgresql-storage-check
Command: npx skills add https://github.com/IldarMinaev/troubleshooting-skill --skill postgresql-storage-check

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Diagnoses PostgreSQL storage health, including PVC capacity, in-pod disk usage, and object sizes to prevent outages and performance degradation.

Core Features & Use Cases

PVC capacity checks across Patroni pods
Disk usage and WAL accumulation assessment
WAL replication slot analysis and table bloat estimation for maintenance planning
Use Case: When a cluster shows disk pressure, run these checks to identify the largest consumers and prioritize actions.

Quick Start

Run the storage-check workflow against the target cluster to surface PVC usage, per-pod disk usage, and top database objects by size.

Frequently Asked Questions about postgresql-storage-check

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I check PostgreSQL storage health in Kubernetes?▼

To check PostgreSQL storage health, run SQL queries and kubectl commands to assess PVC capacity, in-pod disk usage, and database object sizes across multiple Patroni pods to prevent outages and performance degradation.

Why does my PostgreSQL PVC keep filling up on Kubernetes?▼

Your PostgreSQL PVC may be filling up due to WAL accumulation, inactive replication slots, or table bloat. Diagnose these specific storage consumers by running operational checks with SQL queries and kubectl commands across your Patroni pods.

Does this storage check work with pgskipper-operator and Patroni clusters?▼

Yes, this storage check explicitly supports Kubernetes deployments using Patroni and pgskipper-operator. It handles environment-aware credentials and performs inline data directory discovery across multiple pods within these specific cluster architectures.

How do I find the largest database objects causing PostgreSQL disk pressure?▼

To find the largest database objects causing PostgreSQL disk pressure, run a storage-check workflow that surfaces PVC usage, per-pod disk usage, and top database objects by size, prioritizing maintenance actions to resolve the pressure.

Can I estimate table bloat and analyze WAL replication slots in PostgreSQL?▼

Yes, you can estimate table bloat and analyze WAL replication slots in PostgreSQL through targeted SQL queries. This diagnostic capability allows you to plan maintenance and identify inactive slots causing storage accumulation.

What's the best way to diagnose WAL accumulation across multiple PostgreSQL pods?▼

The best way to diagnose WAL accumulation across multiple PostgreSQL pods is executing end-to-end operational checks using SQL queries and kubectl commands, which provides inline data directory discovery and environment-aware credential handling.