On Sat, 12 May 2001, Tom Lane wrote:
> The Hermit Hacker <scrappy@hub.org> writes:
> > So why is it counting 12 more images then are actually found/exist:
>
> Hm. Could we see the EXPLAIN output for both of those?
without count:
NOTICE: QUERY PLAN:
Unique (cost=8.66..8.67 rows=1 width=37) -> Sort (cost=8.66..8.66 rows=1 width=37) -> Nested Loop
(cost=0.00..8.65rows=1 width=37) -> Nested Loop (cost=0.00..6.52 rows=1 width=33) ->
NestedLoop (cost=0.00..4.26 rows=1 width=29) -> Index Scan using status_gid on status s
(cost=0.00..2.23rows=1 width=12) -> Index Scan using images_gid on images i (cost=0.00..2.02
rows=1width=17) -> Index Scan using personal_data_gid on personal_data pd (cost=0.00..2.25 rows=1
width=4) -> Index Scan using relationship_wanted_gid on relationship_wanted rw (cost=0.00..2.11 rows=1
width=4)
EXPLAIN
with count:
NOTICE: QUERY PLAN:
Unique (cost=8.68..8.69 rows=1 width=37) -> Sort (cost=8.68..8.68 rows=1 width=37) -> Aggregate
(cost=8.66..8.67rows=1 width=37) -> Group (cost=8.66..8.67 rows=1 width=37) -> Sort
(cost=8.66..8.66rows=1 width=37) -> Nested Loop (cost=0.00..8.65 rows=1 width=37)
-> Nested Loop (cost=0.00..6.52 rows=1 width=33) -> Nested Loop
(cost=0.00..4.26 rows=1 width=29) -> Index Scan using status_gid on status s
(cost=0.00..2.23 rows=1 width=12) -> Index Scan using images_gid on images i
(cost=0.00..2.02 rows=1 width=17) -> Index Scan using personal_data_gid on
personal_datapd (cost=0.00..2.25 rows=1 width=4) -> Index Scan using
relationship_wanted_gidon relationship_wanted rw (cost=0.00..2.11 rows=1 width=4)
EXPLAIN
>
> regards, tom lane
>
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org