Rendering pre-captured profiler JSON

The Query Profiler queries the cluster that the Kibana node is attached to. It does this by executing the query against the cluster and collecting the results.

But sometimes you may want to investigate performance problems that are temporal in nature. For example, a query might only be slow at certain time of day when many customers are using your system. You can setup a process to automatically profile slow queries when they occur and then save those profile responses for later analysis.

The Query Profiler supports this workflow by allowing you to paste the pre-captured JSON in the query editor. The Query Profiler will detect that you have entered a JSON response (rather than a query) and will just render the visualization, rather than querying the cluster.

To see how this works, copy and paste the following profile response into the query editor and click Profile.

  1. {
  2.    "took": 3,
  3.    "timed_out": false,
  4.    "_shards": {
  5.       "total": 1,
  6.       "successful": 1,
  7.       "failed": 0
  8.    },
  9.    "hits": {
  10.       "total": 1,
  11.       "max_score": 1.3862944,
  12.       "hits": [
  13.          {
  14.             "_index": "test",
  15.             "_type": "test",
  16.             "_id": "AVi3aRDmGKWpaS38wV57",
  17.             "_score": 1.3862944,
  18.             "_source": {
  19.                "name": "fred",
  20.                "age": 69,
  21.                "hair": "blonde"
  22.             }
  23.          }
  24.       ]
  25.    },
  26.    "profile": {
  27.       "shards": [
  28.          {
  29.             "id": "[O-l25nM4QN6Z68UA5rUYqQ][test][0]",
  30.             "searches": [
  31.                {
  32.                   "query": [
  33.                      {
  34.                         "type": "BooleanQuery",
  35.                         "description": "+name:fred #(ConstantScore(*:*))^0.0",
  36.                         "time": "0.5884370000ms",
  37.                         "breakdown": {
  38.                            "score": 7243,
  39.                            "build_scorer_count": 1,
  40.                            "match_count": 0,
  41.                            "create_weight": 196239,
  42.                            "next_doc": 9851,
  43.                            "match": 0,
  44.                            "create_weight_count": 1,
  45.                            "next_doc_count": 2,
  46.                            "score_count": 1,
  47.                            "build_scorer": 375099,
  48.                            "advance": 0,
  49.                            "advance_count": 0
  50.                         },
  51.                         "children": [
  52.                            {
  53.                               "type": "TermQuery",
  54.                               "description": "name:fred",
  55.                               "time": "0.3016880000ms",
  56.                               "breakdown": {
  57.                                  "score": 4218,
  58.                                  "build_scorer_count": 1,
  59.                                  "match_count": 0,
  60.                                  "create_weight": 132425,
  61.                                  "next_doc": 2196,
  62.                                  "match": 0,
  63.                                  "create_weight_count": 1,
  64.                                  "next_doc_count": 2,
  65.                                  "score_count": 1,
  66.                                  "build_scorer": 162844,
  67.                                  "advance": 0,
  68.                                  "advance_count": 0
  69.                               }
  70.                            },
  71.                            {
  72.                               "type": "BoostQuery",
  73.                               "description": "(ConstantScore(*:*))^0.0",
  74.                               "time": "0.1223030000ms",
  75.                               "breakdown": {
  76.                                  "score": 0,
  77.                                  "build_scorer_count": 1,
  78.                                  "match_count": 0,
  79.                                  "create_weight": 17366,
  80.                                  "next_doc": 0,
  81.                                  "match": 0,
  82.                                  "create_weight_count": 1,
  83.                                  "next_doc_count": 0,
  84.                                  "score_count": 0,
  85.                                  "build_scorer": 102329,
  86.                                  "advance": 2604,
  87.                                  "advance_count": 2
  88.                               },
  89.                               "children": [
  90.                                  {
  91.                                     "type": "MatchAllDocsQuery",
  92.                                     "description": "*:*",
  93.                                     "time": "0.03307600000ms",
  94.                                     "breakdown": {
  95.                                        "score": 0,
  96.                                        "build_scorer_count": 1,
  97.                                        "match_count": 0,
  98.                                        "create_weight": 6068,
  99.                                        "next_doc": 0,
  100.                                        "match": 0,
  101.                                        "create_weight_count": 1,
  102.                                        "next_doc_count": 0,
  103.                                        "score_count": 0,
  104.                                        "build_scorer": 25615,
  105.                                        "advance": 1389,
  106.                                        "advance_count": 2
  107.                                     }
  108.                                  }
  109.                               ]
  110.                            }
  111.                         ]
  112.                      }
  113.                   ],
  114.                   "rewrite_time": 168640,
  115.                   "collector": [
  116.                      {
  117.                         "name": "CancellableCollector",
  118.                         "reason": "search_cancelled",
  119.                         "time": "0.02952900000ms",
  120.                         "children": [
  121.                            {
  122.                               "name": "SimpleTopScoreDocCollector",
  123.                               "reason": "search_top_hits",
  124.                               "time": "0.01931700000ms"
  125.                            }
  126.                         ]
  127.                      }
  128.                   ]
  129.                }
  130.             ],
  131.             "aggregations": []
  132.          }
  133.       ]
  134.    }
  135. }

Visualizing pre-collected responses

Most Popular