Identify columns that need indexes

From: Yambu <hyambu(at)gmail(dot)com>
To: pgsql-sql(at)lists(dot)postgresql(dot)org
Subject: Identify columns that need indexes
Date: 2020-11-12 07:50:03
Message-ID: CALhHtcCmDSYf6_+JYF1uqojj0nQbqwYNCm0u5++7jcWnyCFfwg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message hubert depesz lubaczewski 2020-11-12 11:14:08 Re: Identify columns that need indexes
Previous Message Iuri Sampaio 2020-10-21 22:11:57 Re: Best way to change values of a primary key referenced by many tables