pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Csaba Nagy <nagy@ecircle-ag.com>
To: mario.splivalo@mobart.hr
Cc: Pgsql performance <pgsql-performance@postgresql.org>
Subject: Re: Identical query on two machines, different plans....
Date: Thu, 20 Apr 2006 16:06:11 +0200
Message-ID: <1145541970.3553.36.camel@coppola.muc.ecircle.de> (raw)
In-Reply-To: <1145541587.3553.30.camel@coppola.muc.ecircle.de>
References: <1145541113.9373.9.camel@localhost.localdomain>
	<1145541587.3553.30.camel@coppola.muc.ecircle.de>

OK, I marked the wrong row counts, but the conclusion is the same.

Cheers,
Csaba.


> > QUERY PLAN
> > ---------------------------------------------------------------------------------------------------------------------------------------------------
> >  Index Scan using ticketing_codes_uq_value_group_id on ticketing_codes
> > (cost=0.00..6.02 rows=1 width=4) (actual time=0.104..0.107 rows=1
>                    ^^^^^^   
> > loops=1)
> >    Index Cond: (((code_value)::text = 'C7ZP2U'::text) AND (code_group_id
> > = 1000))
> >  Total runtime: 0.148 ms
> > (3 rows)
> > 
> > 
> > PLAN 
> > ----------------------------------------------------------------------------------------------------------------------------------------------
> >  Bitmap Heap Scan on ticketing_codes  (cost=2.01..1102.05 rows=288
>                                                             ^^^^^^^^
> > width=4) (actual time=88.164..88.170 rows=1 loops=1)
> >    Recheck Cond: (((code_value)::text = 'C7ZP2U'::text) AND
> > (code_group_id = 1000))
> >    ->  Bitmap Index Scan on ticketing_codes_uq_value_group_id
> > (cost=0.00..2.01 rows=288 width=0) (actual time=54.397..54.397 rows=1
                     ^^^^^^^^
> > loops=1)
> >          Index Cond: (((code_value)::text = 'C7ZP2U'::text) AND
> > (code_group_id = 1000))
> >  Total runtime: 88.256 ms
> > (5 rows)
> > 
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster




view thread (4+ messages)

Message-ID: <1145541970.3553.36.camel@coppola.muc.ecircle.de>
Permalink:  ../1145541970.3553.36.camel@coppola.muc.ecircle.de/
Also on:    postgresql.org/message-id/1145541970.3553.36.camel@coppola.muc.ecircle.de

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: nagy@ecircle-ag.com, mario.splivalo@mobart.hr
  Subject: Re: Identical query on two machines, different plans....
  In-Reply-To: <1145541970.3553.36.camel@coppola.muc.ecircle.de>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox