Horton

Re: postmaster core dump

Patrick Welche <prlw1@newn.cam.ac.uk>

View thread View on postgr.es
From: Patrick Welche <prlw1@newn.cam.ac.uk>
To: pgsql-hackers@postgresql.org
Date: 2005-09-19T19:07:34Z
Lists: pgsql-hackers 
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