Re: Query not using index

I vacuum every half hour! Here is the output from EXPLAIN:

NOTICE: QUERY PLAN:

Seq Scan on pa_shopping_cart (cost=0.00..7237.94 rows=9420 width=296)

EXPLAIN

Thanks!

On Thu, 10 May 2001 18:19:16 +0000 (UTC),
sszabo(at)megazone23(dot)bigpanda(dot)com (Stephan Szabo) wrote:

>
>Have you vacuum analyzed recently and what does
>explain show for the query?
>
>On Thu, 10 May 2001 ryan(at)paymentalliance(dot)net wrote:
>
>> Here's the query:
>>
>> SELECT
>> cart_row_id
>> FROM
>> pa_shopping_cart
>> WHERE
>> order_id = 20;
>> [ ... ]
>> There is an index on:
>> just order_id
>> just order_id and cart_row_id
>> and a PK on cart row_id
>>
>> I don't understand why it's not using one of these indexes!
>> Please post your responses to the group - my email is down.
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)