On Mon, Sep 19, 2005 at 06:12:54PM +0100, Patrick Welche wrote:
> #15 0x081a4c2f in exec_simple_query (
> query_string=0x834501c "select timesliced, count(stats_id) from trans
> left j
I just truncated one line early.. the query was:
# explain select timesliced, count(stats_id) from trans left join stats on
stats_id=stats.id group by timesliced;
QUERY PLAN
-------------------------------------------------------------------------------
HashAggregate (cost=123718.66..123738.61 rows=1596 width=8)
-> Hash Left Join (cost=4143.88..115550.16 rows=1633701 width=8)
Hash Cond: ("outer".stats_id = "inner".id)
-> Seq Scan on trans (cost=0.00..61341.01 rows=1633701 width=4)
-> Hash (cost=3292.30..3292.30 rows=123430 width=8)
-> Seq Scan on stats (cost=0.00..3292.30 rows=123430 width=8)
(6 rows)
Cheers,
Patrick
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
