| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | AI Rumman <rummandba(at)gmail(dot)com> |
| Cc: | pgsql-general General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: How to find which query are doing seq_scan |
| Date: | 2010-10-18 16:11:14 |
| Message-ID: | AANLkTi=N5ug8R8Qkwes-g-eZ-H51zO580tbySKTnQHv7@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sun, Oct 17, 2010 at 10:58 PM, AI Rumman <rummandba(at)gmail(dot)com> 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scot Kreienkamp | 2010-10-18 17:24:02 | Re: archiver process problem |
| Previous Message | Scot Kreienkamp | 2010-10-18 15:28:39 | archiver process problem |