skills.rest
interflownex
interflownexCOMMUNITY
Explore all skills by this author →
GitHub

alloydb-postgres-health

Analyze PostgreSQL database health by detecting storage bloat and invalid indexes.

2|1|Updated May 25, 2026
Search Tags:#performance#database#postgresql#optimization#vacuum#alloydb
One-click install
npx skills add https://github.com/interflownex/All-in-One --skill alloydb-postgres-health
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: alloydb-postgres-health
Source: https://github.com/interflownex/All-in-One/tree/main/.gemini/skills/alloydb-postgres-health
Command: npx skills add https://github.com/interflownex/All-in-One --skill alloydb-postgres-health

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires @toolbox-sdk/server, and includes scripts (resource) components.

What problem does it solve?

This Skill addresses performance bottlenecks and maintenance overhead in AlloyDB for PostgreSQL by providing automated diagnostic tools for storage, indexing, and vacuuming.

Core Features & Use Cases

  • Performance Diagnostics: Identify bloated tables, invalid indexes, and inefficient sequential scans to improve query speed.
  • Maintenance Automation: Monitor autovacuum configurations and tablespace usage to ensure long-term database stability.
  • Use Case: When a database query slows down, use this Skill to list top bloated tables and invalid indexes, allowing you to perform targeted maintenance and reclaim disk space.

Quick Start

Use the alloydb-postgres-health skill to list the top bloated tables in the current database.

Frequently Asked Questions about alloydb-postgres-health

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

FAQPage Schema
How do I check AlloyDB PostgreSQL database health and identify storage bloat?▼

To check AlloyDB PostgreSQL database health, you can run diagnostic scripts to identify storage bloat, invalid indexes, and inefficient table statistics. This allows you to pinpoint bloated tables and reclaim disk space.

Why does my PostgreSQL query slow down and how can I find invalid indexes?▼

PostgreSQL queries slow down due to bloated tables and invalid indexes. You can analyze database health to list top bloated tables and invalid indexes, enabling targeted maintenance to improve query speed.

What is the best way to monitor autovacuum configurations in AlloyDB?▼

The best way to monitor autovacuum configurations in AlloyDB is by using diagnostic scripts to analyze table statistics and tablespace usage. This ensures long-term database stability and automates maintenance tasks.

Do I need the @toolbox-sdk/server package to run PostgreSQL performance diagnostics?▼

Yes, you need the @toolbox-sdk/server package to execute diagnostic scripts against the PostgreSQL database engine. It provides the required environment to analyze storage bloat and inefficient sequential scans.

Can I use these diagnostic scripts to fix inefficient sequential scans in my database?▼

Yes, you can use the scripts to identify inefficient sequential scans and invalid indexes in your PostgreSQL database. By highlighting these issues, you can perform performance tuning to improve query speed.

Related Skills

Explore More Software Engineering Skills→
interflownexinterflownex
2

alloydb-omni-replication

Monitor PostgreSQL replication health and audit publication tables in AlloyDB Omni.

Community
Intermediate
Mercurium-AnalyticsMercurium-Analytics

pg-repack-runbook

Rebuild bloated PostgreSQL tables online with pg_repack.

Official
Intermediate
interflownexinterflownex
2

alloydb-postgres-monitor

Monitor AlloyDB for PostgreSQL query performance, system metrics, and lock states.

Community
Advanced
interflownexinterflownex
2

alloydb-omni-health

Audit PostgreSQL database health in AlloyDB Omni environments.

Community
Intermediate