Project

General

Profile

Actions
Copy link

Idea #13007

open

[API] Review Postgres index usage

Added by Peter Amstutz almost 7 years ago. Updated 10 months ago.

Status:
New
Priority:
Normal
Assigned To:
-
Category:
-
Target version:
Future
Start date:
Due date:
Story points:
-
Release:
Postponed
Release relationship:
Auto

Description

We create a lot of indexes in our database setup, but it's not clear which ones actually get used. This blog post and sample query use postgres stats to report rarely used indexes:

http://www.databasesoup.com/2014/05/new-finding-unused-indexes-query.html

https://gist.github.com/jberkus/6b1bcaf7724dfc2a54f3

Actions
Copy link
 #1

Updated by Peter Amstutz almost 7 years ago

  • Description updated (diff)
Actions
Copy link
 #2

Updated by Peter Amstutz almost 2 years ago

  • Release set to 60
Actions
Copy link
 #3

Updated by Peter Amstutz 10 months ago

  • Target version set to Future
Actions
Copy link

Also available in: Atom PDF