AWR Plan Volatility

_.md

[ Launch: AWR Plan Volatility ] c529d376ae7c0c44dee4 by dmann99
[ Launch: test ] 4653053 by enjalot
[ Launch: test ] 4652017 by enjalot
[ Launch: test ] 4582399 by enjalot

config.json

{"description":"AWR Plan Volatility","endpoint":"","display":"svg","public":true,"require":[],"fileconfigs":{"inlet.js":{"default":true,"vim":false,"emacs":false,"fontSize":12},"_.md":{"default":true,"vim":false,"emacs":false,"fontSize":12},"config.json":{"default":true,"vim":false,"emacs":false,"fontSize":12},"mydata.json":{"default":true,"vim":false,"emacs":false,"fontSize":12},"mydata.csv":{"default":true,"vim":false,"emacs":false,"fontSize":12},"survey.csv":{"default":true,"vim":false,"emacs":false,"fontSize":12}},"play":false,"loop":false,"restart":false,"autoinit":true,"pause":true,"loop_type":"period","bv":false,"nclones":15,"clone_opacity":0.4,"duration":3000,"ease":"linear","dt":0.01,"tab":"edit","display_percent":0.7,"thumbnail":"http://i.imgur.com/Z4ghHZY.png","fullscreen":false,"ajax-caching":true}

inlet.js

// David Mann | http://ba6.us | @ba6dotus

// Purpose: Show Explain Plan volatility of a specific SQL Statement

// Inputs: SQL_ID, PLAN_HASH_VALUE, SNAP_ID, EXEC_COUNT, ELAPSED_PER_EXEC

// v1 Plans:
// Vertical Bar Chart
//  o X axis shows time progression 
//  o Y axis shows elapsed per exec 
//    o Highlight background of bar with PLAN_HASH_VALUE color map
//    o Assign unique color for each distinct PLAN_HASH_VALUE
//
// v2 Plans:
// Pan / Zoom

// References:
// Graph - http://tributary.io/inlet/7113193
// Color Space - http://bl.ocks.org/mbostock/310c99e53880faec2434


// Constants
var colorData = [
    {"colorval" : "#B8B800"},
    {"colorval" : "#993300"},
    {"colorval" : "#000066"},
    {"colorval" : "#006600"},
    {"colorval" : "#990033"},
    {"colorval" : "#3D3D5C"},
    {"colorval" : "#CC0099"},
    {"colorval" : "#6600FF"},
    {"colorval" : "#FF0000"},
    {"colorval" : "#33CC33"},
    {"colorval" : "#000000"}
];
var colorCounter = 0;

//this is using data from twitter survey
//http://bit.ly/advd3presurvey
var results = tributary.survey;
results.forEach(function(d) { 
  d.evil = +d.evil;
  d.passion = +d.passion;
  d.age = +d.age || 0;
  d.exp = +d.exp;
  d.time = new Date(d.time);
});


var linearScale = d3.scale.linear()
.domain(d3.extent(results, function(d) { return d.age }))
.range([0, 500]);

var ordinalScale = d3.scale.ordinal()
.domain(d3.range(results.length))
.rangeBands([0, 500], 0.328);


var svg = d3.select("svg")
var rects = svg.selectAll("rect")
.data(results)
rects.enter().append("rect");

rects
.attr({
  width: ordinalScale.rangeBand(),
  height: function(d) { return linearScale(d.age) },
  x: function(d,i) { return 100 + ordinalScale(i) },
  y: function(d) { return 100 + linearScale.range()[1] - linearScale(d.age) }
});

mydata.csv

survey.csv