Attachment 663010 Details for Bug 877741 – sorted queries

sorted queries

queriesSorted.txt (text/plain), 4.32 KB, created by Alissa on 2012-12-13 15:02:41 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Alissa

Created: 2012-12-13 15:02:41 UTC

Size: 4.32 KB

patch

obsolete

>  15784  select * from  getvdsbyvdsid($1, $2, $3)
>  12783  select * from  getvmsrunningonvds($1)
>   8346  select * from  getdisksvmguid($1, $2, $3)
>   2455  select * from  getvdsgroupbyvdsgroupid($1, $2, $3)
>   1771  select 1
>   1487  select * from  getinterface_viewbyvds_id($1, $2, $3)
>   1369  select * from  getvm_interfacebyvm_id($1, $2, $3)
>    498  select * from updatevds_interface_statistics($1, $2, $3, $4, $5, $6, $7) as result
>    288  select * from  getstorage_poolbyid($1, $2, $3)
>    214  select * from  getallnetworkbyclusterid($1, $2, $3)
>    179  select * from  getstorage_domains_by_id_and_by_storage_pool_id($1, $2)
>    114  select * from updatevdsdynamic($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38) as result
>     93  select * from  getstorage_domains_by_storagepoolid($1, $2, $3)
>     87  select * from updatevdsstatistics($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15) as result
>     83  select * from  getstoragedomainidsbystoragepoolidandstatus($1, $2)
>     35  select * from updatevmdynamic($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32) as result
>     23  select * from updatevmstatistics($1, $2, $3, $4, $5, $6, $7, $8) as result
>     21  select * from updatedisk_image_dynamic($1, $2, $3, $4, $5, $6, $7) as result
>     20  select * from updatevm_interface_statistics($1, $2, $3, $4, $5, $6, $7) as result
>     16  SELECT * FROM (SELECT * FROM vds WHERE ( vds_id IN (SELECT vds_with_tags.vds_id FROM  vds_with_tags  ))  ORDER BY vds_name ASC ) as T1 OFFSET (201 -1) LIMIT 100
>     15  SELECT * FROM (SELECT * FROM audit_log WHERE ( audit_log_id > 108750 and audit_log_id IN (SELECT audit_log.audit_log_id FROM  audit_log  ))  ORDER BY audit_log_id DESC ) as T1 OFFSET (1 -1) LIMIT 100
>     13  SELECT * FROM (SELECT * FROM audit_log WHERE ( audit_log_id > 108749 and audit_log_id IN (SELECT audit_log.audit_log_id FROM  audit_log  ))  ORDER BY audit_log_id DESC ) as T1 OFFSET (1 -1) LIMIT 100
>     12  SELECT * FROM (SELECT * FROM audit_log WHERE ( audit_log_id > 108747 and audit_log_id IN (SELECT audit_log.audit_log_id FROM  audit_log  ))  ORDER BY audit_log_id DESC ) as T1 OFFSET (1 -1) LIMIT 100
>     12  SELECT * FROM (SELECT * FROM audit_log WHERE ( audit_log_id > 0 and audit_log_id IN (SELECT audit_log.audit_log_id FROM  audit_log   WHERE  audit_log.severity = '10' ))  ORDER BY audit_log_id DESC ) as T1 OFFSET (1 -1) LIMIT 100
>     10  select * from  getpermissionsbyentityid($1, $2, $3)
>      8  select * from  getallfromvdsgroups($1, $2)
>      6  select * from insertauditlog($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26) as result
>      3  select * from  getjobsbyoffsetandpagesize($1, $2)
>      2  SELECT * FROM (SELECT * FROM vds WHERE ( vds_id IN (SELECT vds_with_tags.vds_id FROM  vds_with_tags   WHERE  vds_with_tags.vds_group_name LIKE 'cl_fake' ))  ORDER BY vds_name ASC ) as T1 OFFSET (1 -1) LIMIT 2147483647
>      2  SELECT * FROM (SELECT * FROM vds WHERE ( vds_id IN (SELECT vds_with_tags.vds_id FROM  vds_with_tags   WHERE (  vds_with_tags.status = '3'  AND  vds_with_tags.storage_pool_name LIKE 'dc_fake'  )))  ORDER BY vds_name ASC ) as T1 OFFSET (1 -1) LIMIT 2147483647
>      2  SELECT * FROM (SELECT * FROM audit_log WHERE ( audit_log_id > 108752 and audit_log_id IN (SELECT audit_log.audit_log_id FROM  audit_log  ))  ORDER BY audit_log_id DESC ) as T1 OFFSET (1 -1) LIMIT 100
>      2  select * from insertstep($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12) as result
>      2  select * from  getvmsdedicatedtopowerclientbyvdsid($1)
>      2  select * from  getstorage_domains_list_by_storagedomainid($1)
>      2  select * from  getallfromvm_pools()
>      1  select * from updatevds_interface($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18) as result
>      1  select * from insertjobsubjectentity($1, $2, $3) as result
>      1  select * from  getvdsstaticbyvdsid($1)
>      1  select * from  getstorage_server_connectionsbystoragepoolid($1)
>      1  select * from  getfailingvdss()
>      1  select * from  getallfromrole()
>      1  select * from deletecompletedjobsolderthandate($1, $2) as result

Actions: View

Attachments on bug 877741: 658812 | 663010 | 671557