explain analyze

From: Tourtounis Sotiris <tourtoun(at)csd(dot)uoc(dot)gr>
To: pgsql-general(at)postgresql(dot)org
Subject: explain analyze
Date: 2002-09-13 08:43:52
Message-ID: Pine.GSO.4.44.0209131138430.20334-100000@fryni.csd.uch.gr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello, ia have an SQl query of the following form :

select Y.at from table Y where Y.at >=1 and Y.at < 253214

I have state an index on attribute at and by using the explain in front of
the select ... i get the information of an index scan-however i can't
distingusish whether that index scan refers to one of the two comparisons
or to the conjuction of those two - how i can see that?
explain analyze works on that question?

SWTHRHS TOYRTOYNHS
(tourtoun(at)csd(dot)uch(dot)gr)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Justin Clift 2002-09-13 08:47:47 Re: encryption problem
Previous Message Sylvain Sainnier 2002-09-13 08:33:45 encryption problem