: Tracking Full Table Scans

From: Venkat Balaji <venkat(dot)balaji(at)verse(dot)in>
To: PGSQL Performance <pgsql-performance(at)postgresql(dot)org>
Subject: : Tracking Full Table Scans
Date: 2011-09-27 12:36:01
Message-ID: CAFrxt0gyMK8aPS9T1DDdvhaOJjnpC7D_x3kcYURVtw-GhKhF3w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hello Everyone,

I am preparing a plan to track the tables undergoing Full Table Scans for
most number of times.

If i track seq_scan from the pg_stat_user_tables, will that help
(considering the latest analyzed ones) ?

Please help !

Thanks
VB

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Timothy Garnett 2011-09-27 12:40:09 Re: Performance Anomaly with "col in (A,B)" vs. "col = A OR col = B" ver. 9.0.3
Previous Message Venkat Balaji 2011-09-27 12:31:01 Re: : Performance Improvement Strategy