Metric Beat No PostgreSQL Dashboard Found

Kernel_Panic · May 2, 2017, 8:18pm

Hi there guys

I configured metricbeat to monitor a postgresql database, but I noticed that there is no metricbeat dashboard by default, only for MongoDB, is that correct? is there any template out there that I missed to add?

Thanks
Regards

Xavy · May 2, 2017, 11:05pm

Hello:

Yes, there is a shipped PSQL module on metricbeat:
https://www.elastic.co/guide/en/beats/metricbeat/current/metricbeat-module-postgresql.html

Kernel_Panic · May 3, 2017, 1:04am

Hi Xavy

Yes, there is a pgsql module which I configured in metribeat.yml, my question is that I see no template or default
Metricbeat-PosgreSQL dashboard as there is for MongoDB, for Redis, Apache, is there a template that I need to add to ES to represent the data on the board? did I myself clear?

Thanks
Regards

Xavy · May 3, 2017, 5:25am

HI there:

Sorry I misunderstood you. Still there is a Kibana Dashboard available:

github.com

elastic/beats-dashboards/blob/master/dashboards/dashboard/Packetbeat-PgSQL-performance.json

{
  "hits": 0, 
  "timeRestore": false, 
  "description": "", 
  "title": "Packetbeat PgSQL performance", 
  "uiStateJSON": "{}", 
  "panelsJSON": "[{\"col\":1,\"id\":\"Navigation\",\"row\":1,\"size_x\":3,\"size_y\":4,\"type\":\"visualization\",\"panelIndex\":1},{\"col\":4,\"id\":\"PgSQL-Errors\",\"row\":1,\"size_x\":5,\"size_y\":4,\"type\":\"visualization\",\"panelIndex\":2},{\"col\":9,\"id\":\"PgSQL-Methods\",\"row\":1,\"size_x\":4,\"size_y\":4,\"type\":\"visualization\",\"panelIndex\":3},{\"col\":1,\"id\":\"PgSQL-response-times-percentiles\",\"row\":5,\"size_x\":12,\"size_y\":3,\"type\":\"visualization\",\"panelIndex\":4},{\"col\":7,\"id\":\"PgSQL-throughput\",\"row\":8,\"size_x\":6,\"size_y\":3,\"type\":\"visualization\",\"panelIndex\":5},{\"col\":1,\"id\":\"PgSQL-Reads-vs-Writes\",\"row\":8,\"size_x\":6,\"size_y\":3,\"type\":\"visualization\",\"panelIndex\":6},{\"id\":\"Most-frequent-PgSQL-queries\",\"type\":\"visualization\",\"size_x\":6,\"size_y\":6,\"col\":1,\"row\":11,\"panelIndex\":7},{\"id\":\"Slowest-PgSQL-queries\",\"type\":\"visualization\",\"size_x\":6,\"size_y\":6,\"col\":7,\"row\":11,\"panelIndex\":8}]", 
  "optionsJSON": "{\"darkTheme\":false}", 
  "version": 1, 
  "kibanaSavedObjectMeta": {
    "searchSourceJSON": "{\"filter\":[{\"query\":{\"query_string\":{\"analyze_wildcard\":true,\"query\":\"*\"}}}]}"
  }
}

Have you run the import_dashboards script?

https://www.elastic.co/guide/en/beats/libbeat/5.3/import-dashboards.html

Kernel_Panic · May 3, 2017, 4:58pm

Thank you buddy
Regards

system · May 31, 2017, 4:59pm

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

Topic		Replies	Views
Metricbeat Kibana Dashboard for Postgresql Beats metricbeat	11	2670	July 23, 2019
Postgresql Dashboard for metricbeat6.4.0 Beats metricbeat	3	634	September 24, 2019
Postgresql Searches, Visualizations & Dashboards for metricbeat Beats	3	1167	July 6, 2017
Metricbeat: postgresql (module); kibana: dashboard and/or visualize is missing? Beats metricbeat	10	4733	December 26, 2017
Postgresql Module? Beats metricbeat	5	1460	November 2, 2018

Metric Beat No PostgreSQL Dashboard Found

Related topics