# Metricbeat Kibana Dashboard for Postgresql

**URL:** <https://discuss.elastic.co/t/metricbeat-kibana-dashboard-for-postgresql/183544>\
**Category:** Beats\
**Tags:** metricbeat\
**Created:** [May 30, 2019, 1:48pm UTC](https://discuss.elastic.co/t/metricbeat-kibana-dashboard-for-postgresql/183544 "2019-05-30T13:48:10Z")\
**Posts on this page:** 12\
**Page:** 1

<div class="post-metadata">

**Author:** ![RockD](https://avatars.discourse-cdn.com/v4/letter/r/f6c823/32.png) [@RockD](https://discuss.elastic.co/u/RockD)\
**Post date:** [May 30, 2019, 1:48pm UTC](https://discuss.elastic.co/t/metricbeat-kibana-dashboard-for-postgresql/183544/1 "2019-05-30T13:48:10Z")

</div>

Hi  
I have installed metricbeat in a machine with a postgresql service on it, so I enabled the postgresql module of metricbeat.  
I loaded the dashboards into kibana and search for a postgresql dashboard and doesn't exist.  
Theres a dashboard for this service? in any place?

Thanks in advance

Regards

Rod

---

<div class="post-metadata">

**Author:** ![Bargs](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bargs/32/5429_2.png) [@Bargs](https://discuss.elastic.co/u/Bargs)\
**Post date:** [May 30, 2019, 10:06pm UTC](https://discuss.elastic.co/t/metricbeat-kibana-dashboard-for-postgresql/183544/2 "2019-05-30T22:06:34Z")

</div>

Did you see any errors in your terminal when you ran `./metricbeat setup`?

---

<div class="post-metadata">

**Author:** ![RockD](https://avatars.discourse-cdn.com/v4/letter/r/f6c823/32.png) [@RockD](https://discuss.elastic.co/u/RockD)\
**Post date:** [May 31, 2019, 3:28pm UTC](https://discuss.elastic.co/t/metricbeat-kibana-dashboard-for-postgresql/183544/3 "2019-05-31T15:28:17Z")

</div>

No Bargs, Metricbeat doesn't show any errors, I tried with versions 6.6.2, 6.7 and 7.0, and neither of them load a dashboar for postgresql.

There's a place to download and install it manually, or to replicate by hand?

thanks for the reply.

Rod

---

<div class="post-metadata">

**Author:** ![Bargs](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bargs/32/5429_2.png) [@Bargs](https://discuss.elastic.co/u/Bargs)\
**Post date:** [May 31, 2019, 5:55pm UTC](https://discuss.elastic.co/t/metricbeat-kibana-dashboard-for-postgresql/183544/4 "2019-05-31T17:55:45Z")

</div>

I think the Beats folks will be able to help you more with that question so I moved this topic to the Beats forum.

---

<div class="post-metadata">

**Author:** ![RockD](https://avatars.discourse-cdn.com/v4/letter/r/f6c823/32.png) [@RockD](https://discuss.elastic.co/u/RockD)\
**Post date:** [May 31, 2019, 5:59pm UTC](https://discuss.elastic.co/t/metricbeat-kibana-dashboard-for-postgresql/183544/5 "2019-05-31T17:59:54Z")

</div>

thanks Bargs I hope they can hellp me with this

---

<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:** [June 4, 2019, 7:21am UTC](https://discuss.elastic.co/t/metricbeat-kibana-dashboard-for-postgresql/183544/6 "2019-06-04T07:21:26Z")

</div>

Could you run `./metricbeat setup -e` and share the output?

---

<div class="post-metadata">

**Author:** ![RockD](https://avatars.discourse-cdn.com/v4/letter/r/f6c823/32.png) [@RockD](https://discuss.elastic.co/u/RockD)\
**Post date:** [June 4, 2019, 3:38pm UTC](https://discuss.elastic.co/t/metricbeat-kibana-dashboard-for-postgresql/183544/7 "2019-06-04T15:38:51Z")

</div>

sure

> Blockquote  
> $ ./metricbeat setup -e -E output.logstash.enabled=false -E output.elasticsearch.hosts=['192.168.1.229:9200'] -E setup.kibana.host=192.168.1.229:5601 -E setup.kibana.space.id=beats  
> 2019-06-04T12:31:06.087-0300 INFO instance/beat.go:616 Home path: [/home/johndoe/Downloads/metricbeat-6.6.2-linux-x86\_64] Config path: [/home/johndoe/Downloads/metricbeat-6.6.2-linux-x86\_64] Data path: [/home/johndoe/Downloads/metricbeat-6.6.2-linux-x86\_64/data] Logs path: [/home/johndoe/Downloads/metricbeat-6.6.2-linux-x86\_64/logs]  
> 2019-06-04T12:31:06.087-0300 INFO instance/beat.go:623 Beat UUID: a69b28a1-9908-483f-b41a-8d284f873786  
> 2019-06-04T12:31:06.087-0300 INFO [beat] instance/beat.go:936 Beat info {"system\_info": {"beat": {"path": {"config": "/home/johndoe/Downloads/metricbeat-6.6.2-linux-x86\_64", "data": "/home/johndoe/Downloads/metricbeat-6.6.2-linux-x86\_64/data", "home": "/home/johndoe/Downloads/metricbeat-6.6.2-linux-x86\_64", "logs": "/home/johndoe/Downloads/metricbeat-6.6.2-linux-x86\_64/logs"}, "type": "metricbeat", "uuid": "a69b28a1-9908-483f-b41a-8d284f873786"}}}  
> 2019-06-04T12:31:06.087-0300 INFO [beat] instance/beat.go:945 Build info {"system\_info": {"build": {"commit": "1eea934ce81be553337f2828bd12131896fea8e4", "libbeat": "6.6.2", "time": "2019-03-06T14:28:17.000Z", "version": "6.6.2"}}}  
> 2019-06-04T12:31:06.087-0300 INFO [beat] instance/beat.go:948 Go runtime info {"system\_info": {"go": {"os":"linux","arch":"amd64","max\_procs":4,"version":"go1.10.8"}}}  
> 2019-06-04T12:31:06.089-0300 INFO [beat] instance/beat.go:952 Host info {"system\_info": {"host": {"architecture":"x86\_64","boot\_time":"2019-05-20T09:34:28-03:00","containerized":false,"name":"bernardo","ip":["127.0.0.1/8","::1/128","192.168.1.15/24","fe80::e269:95ff:fe35:8f93/64","192.168.25.95/32","fe80::8e1e:d99c:f822:4354/64","172.17.0.1/16","fe80::42:70ff:fed5:a25b/64","fe80::2c89:48ff:feec:f2fa/64","172.20.0.1/16","fe80::42:d3ff:fed7:85c0/64","fe80::5814:15ff:fea1:6cf6/64","fe80::b0bf:80ff:fefc:6091/64"],"kernel\_version":"4.15.0-50-generic","mac":["e0:69:95:35:8f:93","02:42:70:d5:a2:5b","2e:89:48:ec:f2:fa","02:42:d3:d7:85:c0","5a:14:15:a1:6c:f6","b2:bf:80:fc:60:91"],"os":{"family":"debian","platform":"ubuntu","name":"Ubuntu","version":"16.04.6 LTS (Xenial Xerus)","major":16,"minor":4,"patch":6,"codename":"xenial"},"timezone":"-03","timezone\_offset\_sec":-10800,"id":"10e8e34584e54694ad178cc75df6ab7e"}}}  
> 2019-06-04T12:31:06.089-0300 INFO [beat] instance/beat.go:981 Process info {"system\_info": {"process": {"capabilities": {"inheritable":null,"permitted":null,"effective":null,"bounding":["chown","dac\_override","dac\_read\_search","fowner","fsetid","kill","setgid","setuid","setpcap","linux\_immutable","net\_bind\_service","net\_broadcast","net\_admin","net\_raw","ipc\_lock","ipc\_owner","sys\_module","sys\_rawio","sys\_chroot","sys\_ptrace","sys\_pacct","sys\_admin","sys\_boot","sys\_nice","sys\_resource","sys\_time","sys\_tty\_config","mknod","lease","audit\_write","audit\_control","setfcap","mac\_override","mac\_admin","syslog","wake\_alarm","block\_suspend","audit\_read"],"ambient":null}, "cwd": "/home/johndoe/Downloads/metricbeat-6.6.2-linux-x86\_64", "exe": "/home/johndoe/Downloads/metricbeat-6.6.2-linux-x86\_64/metricbeat", "name": "metricbeat", "pid": 14108, "ppid": 13869, "seccomp": {"mode":"disabled","no\_new\_privs":false}, "start\_time": "2019-06-04T12:31:05.720-0300"}}}  
> 2019-06-04T12:31:06.089-0300 INFO instance/beat.go:281 Setup Beat: metricbeat; Version: 6.6.2  
> 2019-06-04T12:31:09.092-0300 INFO add\_cloud\_metadata/add\_cloud\_metadata.go:319 add\_cloud\_metadata: hosting provider type not detected.  
> 2019-06-04T12:31:09.092-0300 INFO elasticsearch/client.go:165 Elasticsearch url: [http://192.168.1.229:9200](http://192.168.1.229:9200)  
> 2019-06-04T12:31:09.093-0300 INFO [publisher] pipeline/module.go:110 Beat name: bernardo  
> 2019-06-04T12:31:09.093-0300 INFO elasticsearch/client.go:165 Elasticsearch url: [http://192.168.1.229:9200](http://192.168.1.229:9200)  
> 2019-06-04T12:31:09.115-0300 INFO elasticsearch/client.go:721 Connected to Elasticsearch version 6.6.2  
> 2019-06-04T12:31:09.128-0300 INFO template/load.go:130 Template already exists and will not be overwritten.  
> 2019-06-04T12:31:09.128-0300 INFO instance/beat.go:894 Template successfully loaded.  
> Loaded index template  
> Loading dashboards (Kibana must be running and reachable)  
> 2019-06-04T12:31:09.128-0300 INFO elasticsearch/client.go:165 Elasticsearch url: [http://192.168.1.229:9200](http://192.168.1.229:9200)  
> 2019-06-04T12:31:09.159-0300 INFO elasticsearch/client.go:721 Connected to Elasticsearch version 6.6.2  
> 2019-06-04T12:31:09.160-0300 INFO kibana/client.go:118 Kibana url: [http://192.168.1.229:5601/s/beats](http://192.168.1.229:5601/s/beats)  
> 2019-06-04T12:31:33.491-0300 INFO instance/beat.go:741 Kibana dashboards successfully loaded.  
> Loaded dashboards  
> Blockquote

That's the output of the metricbeat loading the dashboards, indeed the dashboards are loaded but the postgresql one is missing

BTW thanks for the reply

cheers

Rod

---

<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:** [June 5, 2019, 8:19am UTC](https://discuss.elastic.co/t/metricbeat-kibana-dashboard-for-postgresql/183544/8 "2019-06-05T08:19:33Z")

</div>

I just realised there is a very simple answer for your question: In 6.6 we did not have dashboards for postgresql: [https://www.elastic.co/guide/en/beats/metricbeat/6.6/metricbeat-modules.html](https://www.elastic.co/guide/en/beats/metricbeat/6.6/metricbeat-modules.html) Actually up to today we don't have any ☹

---

<div class="post-metadata">

**Author:** ![RockD](https://avatars.discourse-cdn.com/v4/letter/r/f6c823/32.png) [@RockD](https://discuss.elastic.co/u/RockD)\
**Post date:** [June 7, 2019, 12:42pm UTC](https://discuss.elastic.co/t/metricbeat-kibana-dashboard-for-postgresql/183544/9 "2019-06-07T12:42:56Z")

</div>

Thanks for the answer  
regards  
Rod

---

<div class="post-metadata">

**Author:** ![Matt-Yorkley](https://avatars.discourse-cdn.com/v4/letter/m/f475e1/32.png) [@Matt-Yorkley](https://discuss.elastic.co/u/Matt-Yorkley)\
**Post date:** [June 25, 2019, 12:49pm UTC](https://discuss.elastic.co/t/metricbeat-kibana-dashboard-for-postgresql/183544/10 "2019-06-25T12:49:53Z")

</div>

@ruflin are there any plans to add Postgres dashboards? The Postgres metricbeat module is pretty useless as it is...

---

<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:** [June 25, 2019, 1:04pm UTC](https://discuss.elastic.co/t/metricbeat-kibana-dashboard-for-postgresql/183544/11 "2019-06-25T13:04:24Z")

</div>

We definitively want to add dashboards to all our modules. Feel free to open a feature request for this dashboard on Github. Would be also great if you could mention the metrics you are most interested in.

I wonder why it's useless in the current form? I assume you get all the data but have to build the visualisation for the metrics yourself? Or is there more to it?

---

<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 23, 2019, 1:04pm UTC](https://discuss.elastic.co/t/metricbeat-kibana-dashboard-for-postgresql/183544/12 "2019-07-23T13:04:27Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.
