Postgres Pro
Downloads
Home   >   mailing lists

Identify columns that need indexes - Mailing list pgsql-sql

From Yambu
Subject Identify columns that need indexes
Date
Msg-id CALhHtcCmDSYf6_+JYF1uqojj0nQbqwYNCm0u5++7jcWnyCFfwg@mail.gmail.com
Whole thread Raw
Responses Re: Identify columns that need indexes  (hubert depesz lubaczewski <depesz@depesz.com>)
List pgsql-sql
Tree view
Hi

May I know if there is a query I can run to identify the columns that need indexes. I know I can get tables that are having high sequential scans ,what I need is to identify are the columns.

regards

pgsql-sql by date:

Previous
From: Iuri Sampaio
Date:
Subject: Re: Best way to change values of a primary key referenced by many tables
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: Identify columns that need indexes