Reply

Reporting Index Usage Statistics Report

Adviser
Posts: 267
1255     0
<dashboard>
  <label>Reporting Index Usage Statistics</label>
  <description>System-created dashboard: Please clone before editing.</description>
  <row>
    <panel>
      <chart>
        <search>
          <query>| rest /services/data/indexes
                 | where like(title,"ib_%")
                 | eval evaled_maxsize = if(maxTotalDataSizeMB == 0, 0.01, maxTotalDataSizeMB)
                 | eval USAGE=round((currentDBSizeMB/evaled_maxsize*100),2)
                 | eval title=title + " (" + USAGE + "%)"
                 | rename title as "Index", USAGE as "Usage(%)", currentDBSizeMB as "Volume(MB)", maxTotalDataSizeMB as "Max Volume(MB)"
                 | table "Index", "Volume(MB)", "Max Volume(MB)"</query>
        </search>
        <option name="charting.axisLabelsX.majorLabelStyle.overflowMode">ellipsisNone</option>
        <option name="charting.axisLabelsX.majorLabelStyle.rotation">-45</option>
        <option name="charting.axisTitleX.visibility">visible</option>
        <option name="charting.axisTitleY.visibility">visible</option>
        <option name="charting.axisTitleY2.visibility">visible</option>
        <option name="charting.axisX.scale">linear</option>
        <option name="charting.axisY.scale">log</option>
        <option name="charting.axisY2.enabled">0</option>
        <option name="charting.axisY2.scale">inherit</option>
        <option name="charting.chart">column</option>
        <option name="charting.chart.bubbleMaximumSize">50</option>
        <option name="charting.chart.bubbleMinimumSize">10</option>
        <option name="charting.chart.bubbleSizeBy">area</option>
        <option name="charting.chart.nullValueMode">gaps</option>
        <option name="charting.chart.showDataLabels">none</option>
        <option name="charting.chart.sliceCollapsingThreshold">0.01</option>
        <option name="charting.chart.stackMode">default</option>
        <option name="charting.chart.style">shiny</option>
        <option name="charting.drilldown">none</option>
        <option name="charting.layout.splitSeries">0</option>
        <option name="charting.layout.splitSeries.allowIndependentYRanges">0</option>
        <option name="charting.legend.labelStyle.overflowMode">ellipsisMiddle</option>
        <option name="charting.legend.placement">right</option>
        <option name="charting.axisTitleX.text">Index name</option>
        <option name="charting.axisTitleY.text">Disk Usage (MB)</option>
      </chart>
    </panel>
  </row>
</dashboard>
If you appreciate my efforts, please give me a kudo ↓ or Accept as solution to help others find it faster.
Showing results for 
Search instead for 
Do you mean 

Recommended for You