From: | ryan(at)paymentalliance(dot)net |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Query not using index |
Date: | 2001-05-10 12:16:48 |
Message-ID: | 3afa85e1.271675648@news.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Here's the query:
SELECT
cart_row_id
FROM
pa_shopping_cart
WHERE
order_id = 20;
Here's the schema:
Attribute | Type |
Modifier
-----------------------+--------------------------+---------------------------------------------------------------------
cart_row_id | integer | not null default
product_id | integer | not null
color | character varying(100) |
size | character varying(100) |
style | character varying(100) |
order_id | integer | not null
time_added | timestamp with time zone |
voided_date | timestamp with time zone |
voided_by | integer |
expired_date | timestamp with time zone |
item_state | character varying(50) | default
'in_basket'
received_back_date | timestamp with time zone |
price_charged | numeric(30,6) |
price_refunded | numeric(30,6) |
shipping_charged | numeric(30,6) |
shipping_refunded | numeric(30,6) |
price_tax_charged | numeric(30,6) |
price_tax_refunded | numeric(30,6) |
shipping_tax_charged | numeric(30,6) |
shipping_tax_refunded | numeric(30,6) |
price_name | character varying(30) |
refund_id | integer |
cs_comments | text |
price | numeric(30,6) |
ship_group_id | integer |
ship_package_id | integer |
delivery_date | date |
sentiment | text |
vendor_id | integer |
linkshare_sent | bit(1) |
mapped_to_address | character(1) |
product_name | character varying(200) |
Indices: delivery_date_pa_shopping_cart_,
pa_cart_by_item_state,
pa_cart_by_order,
pa_cart_by_product,
pa_cart_row_order,
pa_item_map_to_addr,
pa_shop_cart_prod_ord_idx,
pa_shopping_cart_pkey,
ship_package_id_pa_shopping_car,
vendor_id_pa_shopping_cart_key
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.
Thanks for any help!
-r
From | Date | Subject | |
---|---|---|---|
Next Message | Justin Clift | 2001-05-10 12:34:40 | Re: ER diagrams |
Previous Message | Vince Vielhaber | 2001-05-10 12:15:52 | Re: Where to get Postgres |