---
title: "PostgreSQL Performance Investigation - Air Market"
description: "A query against your PostgreSQL database is slow, and you need to know why before you can fix it. This is a guide to investigating slow queries. Reach for it when something that should return quickly…"
canonical: "https://airmarket.ai/app/postgres-performance"
---

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

Skill by [HolmesGPT](/@holmesgpt)

# PostgreSQL Performance Investigation

Find out why that Postgres query is taking so long

## What this does

A query against your PostgreSQL database is slow, and you need to know why before you can fix it. This is a guide to investigating slow queries. Reach for it when something that should return quickly does not.

### Top 3 things it does for you

- Investigate a slow query
- Work out where the time is going

## Information

**PostgreSQL Performance Investigation at a glance**

|  |  |
| --- | --- |
| Kind | Skill |
| Publisher | [HolmesGPT](/@holmesgpt) |
| Category | [Data & Analytics](/category/data) |
| Works with | Agent Skills - an open standard supported by 40+ agents |
| Size | 1 KB |
| Licence | Apache-2.0 |
| Repository | [HolmesGPT/holmesgpt](https://github.com/HolmesGPT/holmesgpt/tree/dba45e588be04bd769836ac061a12af4e9d2e7df/tests/llm/fixtures/test_ask_holmes/104b_postgres_missing_index_pgstat/postgres-performance) |
| GitHub stars | 3,131 (as of Nov 2026) |

## Security report

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

**What PostgreSQL Performance Investigation's check was run against**

|  |  |
| --- | --- |
| Commit | dba45e588be04bd769836ac061a12af4e9d2e7df |
| Content hash | 0baa2e6ffb92e231188c77de20410d2bc65564ebfea59b822d2904db686fd498 |
| Files read | [Browse the files at this exact commit](https://github.com/HolmesGPT/holmesgpt/blob/dba45e588be04bd769836ac061a12af4e9d2e7df/tests/llm/fixtures/test_ask_holmes/104b_postgres_missing_index_pgstat/postgres-performance/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 Performance Investigation](/security/postgres-performance)

## About PostgreSQL Performance Investigation

A guide for investigating slow PostgreSQL queries. It is aimed at the investigation itself: finding out why a query is slow.

## What's inside

- SKILL.md - instructions

## Questions

### Is PostgreSQL Performance Investigation safe to install?

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

### How do I install PostgreSQL Performance Investigation?

Open https://airmarket.ai/app/postgres-performance 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/HolmesGPT/holmesgpt/tree/dba45e588be04bd769836ac061a12af4e9d2e7df/tests/llm/fixtures/test_ask_holmes/104b_postgres_missing_index_pgstat/postgres-performance. Install from that link, not the branch.

## Related on Air Market

- [More Data & Analytics listings](/category/data)
- [Everything by HolmesGPT](/@holmesgpt)

---

Canonical URL: <https://airmarket.ai/app/postgres-performance>