How to get top 10 growing objects in grafana being graphite as backend


How to get top 10 growing objects in grafana being graphite as backend



I am using graphite and grafana. My data is as follows



db schema tablename bytes



db1 schema1 table1 1234434
db1 schema1 table2 3409853
db1 schema1 table3 4645654
.
.
..
db1 schema2 table1 2343454
db1 schema2 table2 3242323
db1 schema2 table3 3433455
.
.
.



Per schema i want to get the top 10 growing objects (i mean tables). I mean in schema1 i want to get top 10 growing objects/tables. In schema2 i want to get top 10 growing objects/tables. I have several schemas in a database. How can i acheive this? Please help









By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

-

Popular posts from this blog

C++ thread error: no type named ‘type’ MINGW

C++ thread error: no type named ‘type’ MINGW I'm currently doing a project for my operational systems class and I have to make a program to find prime numbers to run in threads. So I did this: #include <iostream> #include <cmath> #include <thread> #define THREADNUMBER 100 using namespace std; int CONTADOR = 0; int CONTADORTHREADEXECUTADA = 0; int primeRange(int v1, int v2) { int a, limit; bool isprime; for (int i = v1; i <= v2; i++) { if (i % 2 != 0 && i % 3 != 0) { isprime = true; limit = i / 2; if(i == 1) isprime =false; limit = (int)sqrt(i); //General case for(a=2; a <= limit; a++){ if(i % i == 0 && i != 2){ isprime = false; break; } } if (isprime) { CONTADOR++; } } } CONTADORTHREADEXECUTADA++; return 1; } int main(int argc, char *argv[ ] ) { int number1 = atoi(argv[1]); int num...
Read more

Decreasing a static image progress bar horizontally in SDL

Decreasing a static image progress bar horizontally in SDL In my project, I have a decreasing timer progress bar PNG image on display. This image and its background can be found at the below link: https://s3.eksiup.com/df7dd38f781.png My goal is to make the bar decrease starting from the upper green side to the lower red side. My code for this is the following: void EntityTimer::OnRender(SDL_Renderer *ren) { SDL_Rect currRect,dstRect; double rem=0.0; memcpy(&currRect,&origRect,sizeof (SDL_Rect)); memcpy(&dstRect,&origRect,sizeof (SDL_Rect)); if (timerObjPtr->remainingDuration>timerObjPtr->durationInMilisec) timerObjPtr->durationInMilisec=timerObjPtr->remainingDuration; rem=((double)timerObjPtr->remainingDuration/timerObjPtr->durationInMilisec); currRect.h=(origRect.h)*rem; currRect.h = currRect.h; dstRect.x=0; dstRect.y=0; dstRect.h=currRect.h...
Read more

How to input without newline? (Python)

How to input without newline? (Python) I am trying to create a simple file editor in Python via the console (called PyCons). Here is my current program: def PyCons(f): file = open(f, "r") appe = open(f, "a") print("n=====nPyCons Editor, v1.2nPython 3.6.1n") global i i = 0 for line in file: i += 1 print(" {}| ".format(i) + line, end='') for k in range(10000000000000): print("n {}| ".format(i+1), end='') inp = input("") if inp == "@PyCons.save()": print("n=====") break else: i += 1 appe.write("n" + inp) I used the end method to make sure that the existing code in the file was printed properly in its line format, but the input function does not have an end attribute. So, when I go to enter code in the editor: end input end PyCons("magic.html") ... ===== PyCons Editor, v1.2 Python 3.6.1 1| <p>Hello!...
Read more