Re: [GENERAL] How to find which query are doing seq_scan

2010-10-18 Thread Scott Marlowe
On Sun, Oct 17, 2010 at 10:58 PM, AI Rumman wrote: > I am using Postgresql 8.1. > I need to know which query are executing seq_scan on tables as statistics > said there were 4 seq_scan on the tables for the last 2 days. Not sure really. You could log all query plans I think, but I don't know if

[GENERAL] How to find which query are doing seq_scan

2010-10-17 Thread AI Rumman
I am using Postgresql 8.1. I need to know which query are executing seq_scan on tables as statistics said there were 4 seq_scan on the tables for the last 2 days. Any idea please.