From: | Tourtounis Sotiris <tourtoun(at)csd(dot)uoc(dot)gr> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | Basilhs Christofides <christop(at)ics(dot)forth(dot)gr> |
Subject: | Number of disk pages obtained by explain analyze |
Date: | 2002-09-24 12:56:25 |
Message-ID: | Pine.GSO.4.44.0209241542510.25206-100000@fryni.csd.uch.gr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have a table of the form || att0 int4 | att1 int4 | att2 int4 ||
and i declare an index on att0.
With the SQL query
"select * from pg_class where relnane = 'Name of Table'
i get the information of created disk pages = 1623. However when i run an
sql query of the form "select att0 from table where att0 < A(int4) and
att0> B(int4)" i get through explain analyze the following result, which
as we see refers that in actual time have as total cost 4362.73 disk
pages. Are they the same thing or those two refer to different referring
characteristics?Thank you!!!
NOTICE: QUERY PLAN:
Index Scan using index1 on class y (cost=0.00..3662.16 rows=1266 width=4)
(actual time=0.41..4362.73 rows=253215 loops=1)
Total runtime: 4614.22 msec
NOTICE: QUERY PLAN:
Index Scan using index1 on class y (cost=0.00..3662.16 rows=1266 width=4)
(actual time=0.41..4362.73 rows=253215 loops=1)
Total runtime: 4614.22 msec
4.617384
SWTHRHS TOYRTOYNHS
(tourtoun(at)csd(dot)uch(dot)gr)
From | Date | Subject | |
---|---|---|---|
Next Message | snpe | 2002-09-24 13:04:38 | Re: query for non-unique values? |
Previous Message | Shridhar Daithankar | 2002-09-24 12:30:55 | Re: Aggregate of blocks written to a database |