Bug #7577
Slow query
Status:
New
Priority:
Normal
Assignee:
-
Target version:
-
Start date:
12/31/2014
Due date:
% Done:
0%
Estimated time:
Description
I time samweb count-definition-files prod_lemsum_FA14-12-29_nd_genie_nonswap_postshutdown
at a reasonable 5sec, while prod_lemsum_FA14-12-29_nd_genie_nonswap_postshutdown_draining_prod_lempart_FA14-12-29_nd_genie_nonswap_postshutdown
takes 2m30.
The actual definitions are
data_tier lemsum and defname: parent_FA14-10-03_nd_genie_fhc_nonswap_post-shutdown and pidpart.base_release 'FA14-12-29' and nova.standard true and reconstructed.base_release 'FA14-12-29'
and
data_tier lemsum and defname: parent_FA14-10-03_nd_genie_fhc_nonswap_post-shutdown and pidpart.base_release 'FA14-12-29' and nova.standard true and reconstructed.base_release 'FA14-12-29' and not isparentof:( data_tier lempart and defname: parent_FA14-10-03_nd_genie_fhc_nonswap_post-shutdown and nova.release 'FA14-12-29' and nova.standard true and reconstructed.base_release 'FA14-12-29' and pidpart.base_release 'FA14-12-29' )
The "base" query parent_FA14-10-03_nd_genie_fhc_nonswap_post-shutdown
is
fcl.version 'FA14-10-03' and nova.label beta and nova.detectorid nd and nova.hornconfig mn000z200i and nova.hornpolarity fhc and simulated.cryflavorset none and simulated.cryused false and simulated.genieflavorset nonswap and simulated.genieused true and simulated.singlepflavorset none and simulated.singlepused false and simulated.mixingtype overlay and simulated.volume rock_detector and nova.special 'post-shutdown'
Actually, this base query took 3m20 for me, which surprises me because there's nothing fancy in it, and because I don't understand then how my first query ends up so fast.