# Metricbeat: postgresql (module); kibana: dashboard and/or visualize is missing?

**URL:** <https://discuss.elastic.co/t/metricbeat-postgresql-module-kibana-dashboard-and-or-visualize-is-missing/109436>\
**Category:** Beats\
**Tags:** metricbeat\
**Created:** [November 28, 2017, 4:20pm UTC](https://discuss.elastic.co/t/metricbeat-postgresql-module-kibana-dashboard-and-or-visualize-is-missing/109436 "2017-11-28T16:20:33Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![alexus](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/alexus/32/12696_2.png) [@alexus](https://discuss.elastic.co/u/alexus)\
**Post date:** [November 28, 2017, 4:20pm UTC](https://discuss.elastic.co/t/metricbeat-postgresql-module-kibana-dashboard-and-or-visualize-is-missing/109436/1 "2017-11-28T16:20:33Z")

</div>

I renamed _postgresql.yml.disabled_ to _postgresql.yml_ inside of _/etc/metricbeat/modules.d/_ directory, followed by restarting of _metricbeat.service_ per following:

[PostgreSQL Module | Metricbeat Reference [6.0] | Elastic](https://www.elastic.co/guide/en/beats/metricbeat/current/metricbeat-module-postgresql.html)

* * *

I'm unable to see any of metrics via Kibana (not even seeing a dashboard and/or visualize).

Please advise.

---

<div class="post-metadata">

**Author:** ![andrewkroh](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/andrewkroh/32/3784_2.png) [@andrewkroh](https://discuss.elastic.co/u/andrewkroh)\
**Post date:** [November 28, 2017, 4:47pm UTC](https://discuss.elastic.co/t/metricbeat-postgresql-module-kibana-dashboard-and-or-visualize-is-missing/109436/2 "2017-11-28T16:47:20Z")

</div>

Are there any warnings or errors in the Metricbeat log file?

Did you set a username or password for postgres in the postgresql.yml file? Maybe is failing because it needs this.

---

<div class="post-metadata">

**Author:** ![alexus](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/alexus/32/12696_2.png) [@alexus](https://discuss.elastic.co/u/alexus)\
**Post date:** [November 28, 2017, 5:08pm UTC](https://discuss.elastic.co/t/metricbeat-postgresql-module-kibana-dashboard-and-or-visualize-is-missing/109436/3 "2017-11-28T17:08:58Z")

</div>

I don't see any:

```
# grep -v INFO /var/log/metricbeat/metricbeat 
# 

```

I probably didn't made myself clear at the first place, perhaps metricbeat works just fine and maybe my main issue is more with Kibana rather then metricbeat. I'm don't see anything in relates to Postgresql inside of visualize and/or dashboard inside of Kibana.

---

<div class="post-metadata">

**Author:** ![andrewkroh](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/andrewkroh/32/3784_2.png) [@andrewkroh](https://discuss.elastic.co/u/andrewkroh)\
**Post date:** [November 28, 2017, 5:19pm UTC](https://discuss.elastic.co/t/metricbeat-postgresql-module-kibana-dashboard-and-or-visualize-is-missing/109436/4 "2017-11-28T17:19:39Z")

</div>

Can you check the log for lines that have "non-zero". This line has metrics in it that will say how many events or errors were produced by each metricset. And how many events were published to the output.

If there were events published they should be showing up in the Discover tab on Kibana when you query for `metricset.module: postgresql`.

---

<div class="post-metadata">

**Author:** ![alexus](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/alexus/32/12696_2.png) [@alexus](https://discuss.elastic.co/u/alexus)\
**Post date:** [November 28, 2017, 5:47pm UTC](https://discuss.elastic.co/t/metricbeat-postgresql-module-kibana-dashboard-and-or-visualize-is-missing/109436/5 "2017-11-28T17:47:03Z")

</div>

last line of my _/var/log/metricbeat/metricbeat_ log file:

```
# tail -1 /var/log/metricbeat/metricbeat 
2017-11-28T12:33:59-05:00 INFO Non-zero metrics in the last 30s: beat.memstats.gc_next=7065440 beat.memstats.memory_alloc=4281304 beat.memstats.memory_total=4247128440 libbeat.config.module.running=3 libbeat.output.read.bytes=5409 libbeat.output.write.bytes=37326 libbeat.pipeline.clients=6 libbeat.pipeline.events.active=0 libbeat.pipeline.events.filtered=26 libbeat.pipeline.events.published=63 libbeat.pipeline.events.total=89 libbeat.pipeline.queue.acked=63 metricbeat.postgresql.activity.events=3 metricbeat.postgresql.activity.failures=3 metricbeat.postgresql.bgwriter.events=3 metricbeat.postgresql.bgwriter.failures=3 metricbeat.postgresql.database.events=3 metricbeat.postgresql.database.failures=3 metricbeat.system.cpu.events=3 metricbeat.system.cpu.success=3 metricbeat.system.filesystem.events=31 metricbeat.system.filesystem.success=31 metricbeat.system.fsstat.events=1 metricbeat.system.fsstat.success=1 metricbeat.system.load.events=3 metricbeat.system.load.success=3 metricbeat.system.memory.events=3 metricbeat.system.memory.success=3 metricbeat.system.network.events=6 metricbeat.system.network.success=6 metricbeat.system.process.events=30 metricbeat.system.process.success=30 metricbeat.system.process_summary.events=3 metricbeat.system.process_summary.success=3
# 

```

in _Kibana_ via _Discover_ if I filter to _metricset.module: postgresql_, I'm seeing following

> {  
> "message": "QueryStats: pq: SSL is not enabled on the server"  
> }

which points to my postgresql (I'll look into SSL error outside of this discussion), however _Discover_ is not _Dashboard_ and/or _Visualize_.

How does one see it using Dashboard (Visualize) instead of Discover?

---

<div class="post-metadata">

**Author:** ![andrewkroh](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/andrewkroh/32/3784_2.png) [@andrewkroh](https://discuss.elastic.co/u/andrewkroh)\
**Post date:** [November 28, 2017, 8:25pm UTC](https://discuss.elastic.co/t/metricbeat-postgresql-module-kibana-dashboard-and-or-visualize-is-missing/109436/6 "2017-11-28T20:25:49Z")

</div>

> [@alexus](#):
>
> metricbeat.postgresql.database.failures=3

That log statement indicates that metricbeat is failing when getting the metrics from the DB. The errors should be sent to elasticsearch. This is probably where the message above is from (full field name should be `error.message`).

I think this means you need to disable SSL. Try a URL like `postgres://localhost:40001?sslmode=disable`.

Regarding the dashboards, did you [install them](https://www.elastic.co/guide/en/beats/metricbeat/current/load-kibana-dashboards.html)? What version of ES and Kibana are you using?

---

<div class="post-metadata">

**Author:** ![alexus](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/alexus/32/12696_2.png) [@alexus](https://discuss.elastic.co/u/alexus)\
**Post date:** [November 28, 2017, 8:35pm UTC](https://discuss.elastic.co/t/metricbeat-postgresql-module-kibana-dashboard-and-or-visualize-is-missing/109436/7 "2017-11-28T20:35:05Z")

</div>

I'll try _?sslmode=disable_

dashboard:

I've used _setup_ to load dashboards into Kibana, however I only have 11 and postgresql isn't one of them.

My environment:

```
# cat /etc/redhat-release 
Red Hat Enterprise Linux Server release 7.4 (Maipo)
# rpm -q elasticsearch kibana metricbeat
elasticsearch-6.0.0-1.noarch
kibana-6.0.0-1.x86_64
metricbeat-6.0.0-1.x86_64
#
```

---

<div class="post-metadata">

**Author:** ![andrewkroh](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/andrewkroh/32/3784_2.png) [@andrewkroh](https://discuss.elastic.co/u/andrewkroh)\
**Post date:** [November 28, 2017, 8:48pm UTC](https://discuss.elastic.co/t/metricbeat-postgresql-module-kibana-dashboard-and-or-visualize-is-missing/109436/8 "2017-11-28T20:48:08Z")

</div>

I don't see anything in our documentation for the module about dashboards so perhaps no one has contributed dashboards for this module yet. Let me check.

---

<div class="post-metadata">

**Author:** ![andrewkroh](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/andrewkroh/32/3784_2.png) [@andrewkroh](https://discuss.elastic.co/u/andrewkroh)\
**Post date:** [November 28, 2017, 8:52pm UTC](https://discuss.elastic.co/t/metricbeat-postgresql-module-kibana-dashboard-and-or-visualize-is-missing/109436/9 "2017-11-28T20:52:15Z")

</div>

Yeah, no dashboards checked into the repo for postgresql yet. And it's on this [list](https://github.com/elastic/beats/issues/5451).

Once you get some real data ingested, if you build some dashboards please consider [exporting them](https://www.elastic.co/guide/en/beats/devguide/current/export-dashboards.html) and contributing to the project.

---

<div class="post-metadata">

**Author:** ![alexus](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/alexus/32/12696_2.png) [@alexus](https://discuss.elastic.co/u/alexus)\
**Post date:** [November 28, 2017, 8:52pm UTC](https://discuss.elastic.co/t/metricbeat-postgresql-module-kibana-dashboard-and-or-visualize-is-missing/109436/10 "2017-11-28T20:52:20Z")

</div>

I'm also exploring `elasticsearch.yml` and `kibana.yml` modules from metricbeat and they're also "missing" dashboards (visualizers), shouldn't at least elasticsearch and kibana have dashboards (visualizers)?

---

<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:** [December 26, 2017, 8:52pm UTC](https://discuss.elastic.co/t/metricbeat-postgresql-module-kibana-dashboard-and-or-visualize-is-missing/109436/11 "2017-12-26T20:52:20Z")

</div>

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