Slow query using simple equality operators

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

Responses

Browse pgsql-general by date

  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