Home > mailing lists

: Tracking Full Table Scans - Mailing list pgsql-performance

From	Venkat Balaji
Subject	: Tracking Full Table Scans
Date	September 27, 2011 09:36:11
Msg-id	CAFrxt0gyMK8aPS9T1DDdvhaOJjnpC7D_x3kcYURVtw-GhKhF3w@mail.gmail.com Whole thread Raw
Responses	Re: : Tracking Full Table Scans
List	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

From: Venkat Balaji
Date: 27 September 2011, 09:31:11
Subject: Re: : Performance Improvement Strategy

From: Tom Lane
Date: 27 September 2011, 10:49:26
Subject: Re: Ineffective autovacuum