Project

General

Profile

Actions

Story #13007

open

[API] Review Postgres index usage

Added by Peter Amstutz over 6 years ago. Updated over 1 year ago.

Status:
New
Priority:
Normal
Assigned To:
-
Category:
-
Target version:
-
Start date:
Due date:
% Done:

0%

Estimated time:
Story points:
-
Release:
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 #1

Updated by Peter Amstutz over 6 years ago

  • Description updated (diff)
Actions #2

Updated by Lucas Di Pentima over 1 year ago

  • Release set to 60
Actions

Also available in: Atom PDF