Select query takes long to execute

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

Responses

Browse pgsql-performance by date

  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)