Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Metricbeat] Create PostgreSQL dashboard #13103

Closed
sayden opened this issue Jul 30, 2019 · 5 comments

Comments

@sayden
Copy link
Contributor

commented Jul 30, 2019

Very self descriptive. Requested here #10594

I considered to include the following fields (grouped by visualization):

- name: database
  - name: transactions.commit
    description: Number of transactions in this database that have been committed.
  - name: transactions.rollback
    description: Number of transactions in this database that have been rolled back.

  - name: blocks.hit
    description: >
      Number of times disk blocks were found already in the buffer cache, so
      that a read was not necessary (this only includes hits in the PostgreSQL
      buffer cache, not the operating system's file system cache).

  - name: blocks.time.read.ms
    description: Time spent reading data file blocks by backends in this database, in milliseconds.
  - name: blocks.time.write.ms
    description: Time spent writing data file blocks by backends in this database, in milliseconds.

  - name: rows.returned
    description: Number of rows returned by queries in this database.
  - name: rows.fetched
    description: Number of rows fetched by queries in this database.

  - name: rows.inserted
    description: Number of rows inserted by queries in this database.
  - name: rows.updated
    description: Number of rows updated by queries in this database.
  - name: rows.deleted
    description: Number of rows deleted by queries in this database.

  - name: conflicts
    description: Number of queries canceled due to conflicts with recovery in this database.
  - name: deadlocks
    description: Number of deadlocks detected in this database.

- name: statement
  - name: query.calls
    description: Number of times the query has been run.
  - name: query.rows
    description: Total number of rows returned by query.

  - name: query.time.total.ms
    description: Total number of milliseconds spent running query.
  - name: query.time.min.ms
    description: Minimum number of milliseconds spent running query.
  - name: query.time.max.ms
    description: Maximum number of milliseconds spent running query.
  - name: query.time.mean.ms
    description: Mean number of milliseconds spent running query.

  - name: query.memory.shared.hit
    description: Total number of shared block cache hits by the query.
  - name: query.memory.shared.read
    description: Total number of shared block cache read by the query.

  - name: query.memory.local.hit
    description: Total number of local block cache hits by the query.
  - name: query.memory.local.read
    description: Total number of local block cache read by the query.

Total 6 visualizations for database metricset and 4 of statement.

@jsoriano

This comment has been minimized.

Copy link
Member

commented Aug 5, 2019

There was a PostgreSQL dashboard by @dov0211 that was ready to be merged after updating the branch: #7734

@sorantis

This comment has been minimized.

Copy link
Contributor

commented Aug 5, 2019

@sayden, based on (some of) the proposed grouping, I made this dashboard:

Screen Shot 2019-08-05 at 19 45 16

Let me know if you want to add anything else to it.

@Matt-Yorkley

This comment has been minimized.

Copy link

commented Aug 7, 2019

@sorantis I think the "rows fetched vs. rows returned" metric should be a graph rather than a bar chart. Example:

fetched

@Matt-Yorkley

This comment has been minimized.

Copy link

commented Aug 7, 2019

It looks like the (abandoned?) PR #7734 made a start on views for the statement metricset:

statements

LGTM as a layout for visualising the statement metrics in general, and specifically it covers the first half of:

  - name: query.calls
    description: Number of times the query has been run.
  - name: query.rows
    description: Total number of rows returned by query.
@sorantis

This comment has been minimized.

Copy link
Contributor

commented Aug 7, 2019

@Matt-Yorkley thanks for the feedback. I've changed the "Rows fetched/received" to a graph and added the query.calls Top N graph.
Screen Shot 2019-08-07 at 13 48 20

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
6 participants
You can’t perform that action at this time.