---
title: "PostgreSQL Indexing - Air Market"
description: "A query is slow, or you are not sure the index you added is doing anything. This walks you through designing indexes, reading query plans, and checking which ones actually get used. Reach for it when…"
canonical: "https://airmarket.ai/app/postgresql-indexing"
---

[Air Market](/) / [Data & Analytics](/category/data) / PostgreSQL Indexing

Skill by [Prowler](/@prowler-cloud)

# PostgreSQL Indexing

Work out why a query is slow and what index would help

## What this does

A query is slow, or you are not sure the index you added is doing anything. This walks you through designing indexes, reading query plans, and checking which ones actually get used. Reach for it when you are adding an index, chasing a slow query, or cleaning up ones you no longer need.

### Top 3 things it does for you

- Figure out why this query is slow
- Decide what index to add
- Check whether an index is being used at all

## Information

**PostgreSQL Indexing at a glance**

|  |  |
| --- | --- |
| Kind | Skill |
| Publisher | [Prowler](/@prowler-cloud) |
| Category | [Data & Analytics](/category/data) |
| Works with | Agent Skills - an open standard supported by 40+ agents |
| Version | 1.0 |
| Size | 14 KB |
| Licence | Apache-2.0 |
| Repository | [prowler-cloud/prowler](https://github.com/prowler-cloud/prowler/tree/bcd282d3d0d17655ea0d799605268d362e10f1dc/skills/postgresql-indexing) |
| GitHub stars | 14,666 (as of Nov 2026) |
| Installs | 25, counted by skills.sh (Nov 2026) |

## Security report

**Verified.** AIR scanned this exact version of PostgreSQL Indexing and flagged nothing. AIR's verdict: **safe**.

**What PostgreSQL Indexing's check was run against**

|  |  |
| --- | --- |
| Commit | bcd282d3d0d17655ea0d799605268d362e10f1dc |
| Content hash | adb130377887013b72187067302d47fafebc818f6b4b5620058217b0a3c813c7 |
| Files read | [Browse the files at this exact commit](https://github.com/prowler-cloud/prowler/blob/bcd282d3d0d17655ea0d799605268d362e10f1dc/skills/postgresql-indexing/SKILL.md) |

A scan is named by the exact content it read, not by a version number. A different version is a different artifact, and nothing here applies to a version AIR has not scanned.

[Read the full security report for PostgreSQL Indexing](/security/postgresql-indexing)

## About PostgreSQL Indexing

This covers PostgreSQL indexing practice for Prowler: index design, partial indexes, indexing on partitioned tables, validating with EXPLAIN ANALYZE, concurrent operations, monitoring, and maintenance.

It applies when you are creating or changing indexes, analyzing query performance with EXPLAIN, debugging a slow query, reviewing index usage statistics, reindexing, dropping indexes, or working with indexes on partitioned tables.

It also applies to the conversation before the work: weighing index strategies, deciding whether a partial index fits, or planning maintenance operations like VACUUM and ANALYZE.

## What's inside

- SKILL.md - instructions

## Questions

### Is PostgreSQL Indexing safe to install?

AIR scanned this exact version of PostgreSQL Indexing and flagged nothing. AIR's verdict: safe. The verdict is named by the content that was read, at commit bcd282d3d0d1, so it cannot drift onto a version nobody scanned. The full report is at https://airmarket.ai/security/postgresql-indexing.

### How do I install PostgreSQL Indexing?

Open https://airmarket.ai/app/postgresql-indexing on Air Market and use the install action: Air Market hands Claude a prompt naming this exact skill, and Claude sets it up. Source, pinned to the exact commit this listing describes: https://github.com/prowler-cloud/prowler/tree/bcd282d3d0d17655ea0d799605268d362e10f1dc/skills/postgresql-indexing. Install from that link, not the branch.

## Related on Air Market

- [More Data & Analytics listings](/category/data)
- [Everything by Prowler](/@prowler-cloud)

---

Canonical URL: <https://airmarket.ai/app/postgresql-indexing>