From: Brendan Duddridge <brendan@clickspace.com>
To: PostgreSQL Performance <pgsql-performance@postgresql.org>
Cc: Tony Copping <tony@clickspace.com>
Subject: Really really slow query. What's a better way?
Date: Thu, 23 Feb 2006 23:54:45 -0700
Message-ID: <1831440F-F848-471D-ACE9-F84CE9F4E359@clickspace.com> (raw)
Hi,
We're executing a query that has the following plan and we're
wondering given the size of the data set, what's a better way to
write the query? It's been running since 2pm 2 days ago.
explain DELETE FROM cds.cds_mspecxx WHERE ProdID not in (SELECT
stage.ProdID FROM cds_stage.cds_Catalog stage where stage.countryCode
= 'us') and countryCode = 'us';
QUERY PLAN
------------------------------------------------------------------------
---------------------------
Index Scan using pk_mspecxx on cds_mspecxx
(cost=53360.87..208989078645.48 rows=7377879 width=6)
Index Cond: ((countrycode)::text = 'us'::text)
Filter: (NOT (subplan))
SubPlan
-> Materialize (cost=53360.87..77607.54 rows=1629167 width=12)
-> Seq Scan on cds_catalog stage (cost=0.00..43776.70 rows=1629167
width=12)
Filter: ((countrycode)::text = 'us'::text)
(7 rows)
Thanks,
____________________________________________________________________
Brendan Duddridge | CTO | 403-277-5591 x24 | brendan@clickspace.com
ClickSpace Interactive Inc.
Suite L100, 239 - 10th Ave. SE
Calgary, AB T2G 0V9
http://www.clickspace.comAttachments:
smime.p7s (application/pkcs7-signature, 2.3K) download
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: brendan@clickspace.com, tony@clickspace.com
Subject: Re: Really really slow query. What's a better way?
In-Reply-To: <1831440F-F848-471D-ACE9-F84CE9F4E359@clickspace.com>
* 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