From: | Benjamin Arai <benjamin(at)araisoft(dot)com> |
---|---|
To: | PostgreSQL <pgsql-general(at)postgresql(dot)org> |
Subject: | Slow query using simple equality operators |
Date: | 2007-04-23 22:38:11 |
Message-ID: | 40816E1E-3DA5-4ED0-8615-CDA5A44FAED5@araisoft.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Can anybody explain to me why this query is executing so slow?
=# explain select s_content,textdir from text_search where
path_id='1' AND tb_id='P2_TB00001';
QUERY PLAN
------------------------------------------------------------------------
-------------------------
Bitmap Heap Scan on text_search (cost=39861.94..59743.55 rows=5083
width=36)
Recheck Cond: ((path_id = 1) AND (tb_id = 'P2_TB00001'::text))
-> BitmapAnd (cost=39861.94..39861.94 rows=5083 width=0)
-> Bitmap Index Scan on idx_search_path_id
(cost=0.00..16546.09 rows=1016571 width=0)
Index Cond: (path_id = 1)
-> Bitmap Index Scan on idx_search_tb_id
(cost=0.00..23315.60 rows=1016571 width=0)
Index Cond: (tb_id = 'P2_TB00001'::text)
(7 rows)
Thanks in advance!
Benjamin
From | Date | Subject | |
---|---|---|---|
Next Message | Andrej Ricnik-Bay | 2007-04-23 23:14:43 | Re: PQerrorMessage: suppress trailing new line? |
Previous Message | judexhuang | 2007-04-23 22:33:45 | Re: can't start tsearch2 in 8.2.4 |