How to find which query are doing seq_scan

From: AI Rumman <rummandba(at)gmail(dot)com>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: How to find which query are doing seq_scan
Date: 2010-10-18 04:58:24
Message-ID: AANLkTik_Y6OV60WvqiA++38Oe_QMSZb6imUpCz=cHnKq@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2010-10-18 05:39:04 Re: installing from source in Windows
Previous Message Tom Lane 2010-10-18 04:08:45 Re: installing from source in Windows