From: | "Kevin Schroeder" <mirage(at)mirageworks(dot)com> |
---|---|
To: | <pgsql-performance(at)postgresql(dot)org> |
Subject: | Select query takes long to execute |
Date: | 2003-05-29 13:58:07 |
Message-ID: | 005501c325ea$5879ad10$0200a8c0@WORKSTATION |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Hello,
I'm running a simple query on a table and I'm getting a very long
response time. The table has 56,000 rows in it. It has a full text field,
but it is not being referenced in this query. The query I'm running is
select row_key, column1, column2, column3, column4, column5 from table1
where column6 = 1 order by column3 desc limit 21;
There is an index on the table
message_index btree (column6, column3, column7)
Column 3 is a date type, column 6 is an integer and column 7 is unused in
this query.
The total query time is 6 seconds, but I can bring that down to 4.5 if I
append "offset 0" to the end of the query. By checking query using "explain
analyze" it shows that it is using the index.
If anyone has any ideas as to why the query is taking so long and what I can
do to make it more efficient I would love to know.
Thanks
Kevin
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Schroeder | 2003-05-29 14:09:23 | Query problem fixed |
Previous Message | Dave Tenny | 2003-05-29 12:48:41 | Re: IN list processing performance (yet again) |