Glance

add missing index for 'owner' column on images table

Bug #1214830 reported by Venkatesh Sampath
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Glance
Fix Released
Wishlist
Venkatesh Sampath
Glance 2013.2 "havana"

Bug Description

The image-list query involves fetching of images by images.owner. Because there is an index missing on the owner column, a full table scan is done while filtering for images.

Venkatesh Sampath (venkateshsampath)
Changed in glance:
assignee: nobody → Venkatesh Sampath (venkateshsampath)
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to glance (master)

Fix proposed to branch: master
Review: https://review.openstack.org/43094

Changed in glance:
status: New → In Progress
Revision history for this message
Iccha Sethi (iccha-sethi) wrote :

could you add the explain plan here for more details? thanks!

Changed in glance:
importance: Undecided → Wishlist
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to glance (master)

Reviewed: https://review.openstack.org/43094
Committed: http://github.com/openstack/glance/commit/677d1b07753a8c5c309d3992aaa4a1c8976ef2e5
Submitter: Jenkins
Branch: master

commit 677d1b07753a8c5c309d3992aaa4a1c8976ef2e5
Author: Venkatesh Sampath <email address hidden>
Date: Wed Aug 21 15:22:32 2013 +0530

    add missing index for 'owner' column on images table.

    Fixes bug 1214830

    Change-Id: I13355cd53460188a5154aa3f50277c3e92335e28

Changed in glance:
status: In Progress → Fix Committed
Mark Washenberger (markwash)
Changed in glance:
milestone: none → havana-rc1
Thierry Carrez (ttx)
Changed in glance:
status: Fix Committed → Fix Released
Thierry Carrez (ttx)
Changed in glance:
milestone: havana-rc1 → 2013.2
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.