# Visualize mongo query performance in Kibana

**URL:** <https://discuss.elastic.co/t/visualize-mongo-query-performance-in-kibana/42018>\
**Category:** Beats\
**Tags:** filebeat\
**Created:** [February 17, 2016, 11:35am UTC](https://discuss.elastic.co/t/visualize-mongo-query-performance-in-kibana/42018 "2016-02-17T11:35:35Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![swapnil-jaiswal](https://avatars.discourse-cdn.com/v4/letter/s/b19c9b/32.png) [@swapnil-jaiswal](https://discuss.elastic.co/u/swapnil-jaiswal)\
**Post date:** [February 17, 2016, 11:35am UTC](https://discuss.elastic.co/t/visualize-mongo-query-performance-in-kibana/42018/1 "2016-02-17T11:35:35Z")

</div>

Hi,  
I have successfully configured filebeat clients to stream data to centralized ELK server. Now i want to to visualize the mongo query performance data in various dashboards. For this is followed the instructions as below :

# On ELK server

```auto
mkdir mongo_kibana_template ; cd mongo_kibana_template
curl -L -O http://download.elastic.co/beats/dashboards/beats-dashboards-1.1.1.zip
unzip beats-dashboards-1.1.1.zip
cd beats-dashboards-1.1.1/
./load.sh 

```

I also appended the following snippet of config on the filebeat client running on Mongo server.

# On Filebeat client

```auto
protocols:  
  mongodb:
    ports: [27017, 27019]
    send_request: true # index the request payload
    send_response: true # index the response payload
    max_docs: 10 # maximum number of documents to index per request/response
    max_doc_length: 1024 # maximum document size to index

```

Besides the above rest of the config like TLS certificate addition, log file path were added as usual.

Post the above steps I got new dashboard and visualizations on my existing ELK server  
but **Data was missing**.

_Please point out if I am missing a step ?_  
Please note : data is being streamed to the ELK server normally from the FileBeat client.  
(verified by checking checking KIBANA for logs from specific hostname.)  
But same is not being picked up by the dashboard.

Sample dashboard i got following the above steps was like following but Without Data ☹  
[http://goo.gl/jTPG63](http://goo.gl/jTPG63)

Reference links for above steps :  
Ref1: [https://goo.gl/tcW954](https://goo.gl/tcW954)  
Ref2: [https://goo.gl/89gMNE](https://goo.gl/89gMNE)

PFB : FileBeat client config  
[Filebeat.yml](https://github.com/elastic/kibana/files/130804/filebeat.yml.txt)

PFA the screenshots

Data is being streamed normally to the ELK server since same is searchable based on Mongo Server hostname - as below

 ![screenshot - 15-02-16 6_41_08 pm](https://cloud.githubusercontent.com/assets/10742314/13049551/c3d7615c-d413-11e5-9e05-2cddd344b850.png)  
 ![screenshot - 15-02-16 6_38_59 pm](https://cloud.githubusercontent.com/assets/10742314/13049556/c3e2a65c-d413-11e5-887f-cfa50f9bde40.png)  
 ![screenshot - 15-02-16 6_38_48 pm](https://cloud.githubusercontent.com/assets/10742314/13049552/c3e060d6-d413-11e5-9457-9cc63198cfcb.png)  
Index Mapping config warning -- post running load.sh

 ![screenshot - 15-02-16 6_38_38 pm](https://cloud.githubusercontent.com/assets/10742314/13049553/c3e113e6-d413-11e5-8049-0feaf8a07cce.png)  
 ![screenshot - 15-02-16 6_38_23 pm](https://cloud.githubusercontent.com/assets/10742314/13049554/c3e19eb0-d413-11e5-9e25-1c6a13dc2d24.png)  
 ![screenshot - 15-02-16 6_38_03 pm](https://cloud.githubusercontent.com/assets/10742314/13049555/c3e1c39a-d413-11e5-91bd-4ab5b0d09d6b.png)  
 ![screenshot - 15-02-16 6_37_51 pm](https://cloud.githubusercontent.com/assets/10742314/13049558/c3eb4da2-d413-11e5-9c47-54d42504d448.png)  
 ![screenshot - 15-02-16 6_37_38 pm](https://cloud.githubusercontent.com/assets/10742314/13049557/c3eac49a-d413-11e5-9028-90d502c784d3.png)

Dashboard data not being fetched;  
_Error : Could not locate that index-pattern-field (id: resource)_

 ![screenshot - 15-02-16 6_51_58 pm](https://cloud.githubusercontent.com/assets/10742314/13049810/7428455c-d415-11e5-8fc0-e1f9dacd54a6.png)

```
System info :

Filebeat Client 
filebeat-1.1.1-1.x86_64
OS: CentOS release 6.7 (Final)
Linux ip-172-31-57-210 2.6.32-573.3.1.el6.x86_64 #1 SMP Thu Aug 13 22:55:16 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux

ELK server 
OS : Ubuntu 14.04.3 LTS (GNU/Linux 3.19.0-49-generic x86_64)
Kibana : 4.3.0

Elastic search details :
  "name" : "Zip-Zap",
  "cluster_name" : "elasticsearch",
  "version" : {
    "number" : "2.2.0",
    "build_hash" : "8ff36d139e16f8720f2947ef62c8167a888992fe",
    "build_timestamp" : "2016-01-27T13:32:39Z",
    "build_snapshot" : false,
    "lucene_version" : "5.4.1"
  },

```

Config File for filebeat client running mongodb

 ![](https://us1.discourse-cdn.com/elastic/original/2X/1/17083efb46829efd0ade436d20a104cfdaf105cd.png)

---

<div class="post-metadata">

**Author:** ![ruflin](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ruflin/32/3116_2.png) [@ruflin](https://discuss.elastic.co/u/ruflin)\
**Post date:** [February 17, 2016, 2:58pm UTC](https://discuss.elastic.co/t/visualize-mongo-query-performance-in-kibana/42018/2 "2016-02-17T14:58:37Z")

</div>

Could it be that you are mixing filebeat and packetbeat? It seems like you have the configuration for both beats in on config file. The protocols part is for packetbeat, and not filebeat.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 5, 2017, 9:55pm UTC](https://discuss.elastic.co/t/visualize-mongo-query-performance-in-kibana/42018/3 "2017-07-05T21:55:37Z")

</div>