GravityR is a Gravity-Radar.
This exists to reduce time to find bottleneck in your application. And also this is to solve the problems faster and easier.

You can find bottleneck of application using Jaeger or AWS's PerformanceInsights

You can find bottleneck of PostgreSQL, Hasura and MySQL

Below shows performance information by digging run history like traces.

• app dig jaeger
• db dig performance-insights

Below shows how you can accelerate the query by adding index.

• db suggest mysql
• db suggest mysql --with-examine
• db suggest postgres
• db suggest postgres --with-examine
• db suggest hasura postgres
• db suggest hasura postgres --with-examine

1. Download the latest binary from releases page
2. Give execution permission and rename to gr

   chmod u+x gr_xxx
   mv gr_xxx gr

3. Run commands to find bottlenecks!
   examples:

   # Set envs to connect DB and Hasura
   export DB_USERNAME=root DB_DATABASE=gravityr
   export HASURA_URL="http://localhost:8081" HASURA_ADMIN_SECRET="myadminsecretkey" 
   export JAEGER_UI_URL="http://localhost:16686" JAEGER_GRPC_ADDRESS="localhost:16685"
   
   # Get database information with AWS' Performance Insights
   gr db dig performance-insights -o "example/performance-insights.html"
   
   # Search your MySQL's SQL with EXPLAIN
   gr db suggest mysql -o "example/mysql.html" -q "SELECT name, t.description FROM users INNER JOIN tasks AS t ON users.id = t.user_id WHERE users.name = 'foo'"
   
   # Search your MySQL's SQL by adding indexes temporarily
   gr db suggest mysql --with-examine -o "example/mysql_examine.html" -q "SELECT name, t.description FROM users INNER JOIN tasks AS t ON users.id = t.user_id WHERE users.name = 'foo'"
   
   # Search your PostgreSQL's SQL with EXPLAIN
   gr db suggest postgres -o "example/postgres.html" -q "SELECT name, t.description FROM users INNER JOIN tasks AS t ON users.id = t.user_id WHERE users.name = 'foo'"
   
   # Search your PostgreSQL's SQL by adding indexes temporarily
   gr db suggest postgres --with-examine -o "example/postgres_examine.html" -q "SELECT name, t.description FROM users INNER JOIN tasks AS t ON users.id = t.user_id WHERE users.name = 'foo'"
   
   # Search your Hasura's GraphQL with EXPLAIN
   gr db suggest hasura postgres -o "example/hasura.html" -q "query MyQuery(\$email: String) {
     tasks(where: {user: {email: {_eq: \$email}}}) {
       user {
         name
       }
       description
     }
   }
   " --json-variables '{"email": "[email protected]"}'
   
   # Search your Hasura's GraphQL by adding indexes temporarily
   gr db suggest hasura postgres --with-examine -o "example/hasura_examine.html" -q "query MyQuery(\$email: String) {
     tasks(where: {user: {email: {_eq: \$email}}}) {
       user {
         name
       }
       description
     }
   }
   " --json-variables '{"email": "[email protected]"}'
   
   # Get application information with Jaeger
   gr app dig jaeger -o "example/jaeger.html" --service-name bff

$ cd client && yarn
$ make build