From: | Csaba Nagy <nagy(at)ecircle-ag(dot)com> |
---|---|
To: | mario(dot)splivalo(at)mobart(dot)hr |
Cc: | Pgsql performance <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: Identical query on two machines, different plans.... |
Date: | 2006-04-20 14:06:11 |
Message-ID: | 1145541970.3553.36.camel@coppola.muc.ecircle.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2006-04-20 14:16:27 | Re: Inserts optimization? |
Previous Message | Mario Splivalo | 2006-04-20 14:03:58 | Re: Identical query on two machines, different plans.... |