Metricbeat Kibana Dashboard for Postgresql

Elastic Stack Beats
1

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

2

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

3

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

4

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

5

thanks Bargs I hope they can hellp me with this

6

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

7

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
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
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
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
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

8

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 Actually up to today we don't have any :frowning:

9

Thanks for the answer
regards
Rod

10

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

11

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?

1 Like
12

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