Skip to content

Instantly share code, notes, and snippets.

@ejholmes

ejholmes/gist:6803f4dff0aa8b764b3a

Last active August 29, 2015 14:06
Show Gist options
  • Save ejholmes/6803f4dff0aa8b764b3a to your computer and use it in GitHub Desktop.
Save ejholmes/6803f4dff0aa8b764b3a to your computer and use it in GitHub Desktop.
Download ZIP
WLM Breakdown
Raw
gistfile1.sql
select btrim(c.condition) as "wlm group", s.state, count(distinct s.query) from stv_wlm_query_state s
inner join stv_wlm_classification_config c on s.service_class = c.action_service_class
group by "wlm group", s.state;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment