---
title: "Discussion on \"Finding Unused Indexes in Postgres\" | Hashnode"
description: "Discussion on \"Finding Unused Indexes in Postgres\". A pg_stat_user_indexes query to find Postgres indexes with zero scans. Unused indexes waste disk space and slow writes — drop them."
url: "https://hashnode.com/posts/find-unused-indexes-postgres/69c1fce530a9b81e3ada4fd3"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Finding Unused Indexes in Postgres](https://blog.pjhoberman.com/find-unused-indexes-postgres?utm_source=hashnode&utm_medium=feed)

A pg\_stat\_user\_indexes query to find Postgres indexes with zero scans. Unused indexes waste disk space and slow writes — drop them.

Sep 18, 2024 · 2 min read · blog.pjhoberman.com  
Read the article

-   [#postgresql](https://hashnode.com/tag/postgresql)
-   [#backend](https://hashnode.com/tag/backend)
-   [#indexing](https://hashnode.com/tag/indexing)

## Written by

[PJ Hoberman](https://hashnode.com/@pjh)

@pjh · Denver

  
[View profile](https://hashnode.com/@pjh)

## Responses

Markdown supported · ⌘↵ to post

No responses yet.