Project

General

Profile

Bug #7577

Slow query

Added by Christopher Backhouse almost 5 years ago.

Status:
New
Priority:
Normal
Assignee:
-
Target version:
-
Start date:
12/31/2014
Due date:
% Done:

0%

Estimated time:
Duration:

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.



Also available in: Atom PDF