On Sun, Oct 17, 2010 at 10:58 PM, AI Rumman <rummandba@xxxxxxxxx> 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 8.1 supports that. Upgrading to 8.4 or 9.0 would be a huge performance boost, and sequential scans can run in parallel from > 1 query there, as well as a lot of work done on keeping them in a ring buffer so they don't blow out the shared_buffers cache. If you're just looking for slow queries, then just log slow queries. -- To understand recursion, one must first understand recursion. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
