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.