Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

add database size / top x tables in size to postgres dashboard

Description

add information about database / table size to postgres dashboard

SQL like these https://wiki.postgresql.org/wiki/Disk_Usage

information per database

How to test

None

How to document

None

Attachments

15
  • 27 Apr 2021, 12:08 PM
  • 03 Apr 2020, 11:00 AM
  • 03 Apr 2020, 10:46 AM
  • 03 Apr 2020, 10:46 AM
  • 26 Mar 2020, 02:35 PM
  • 26 Mar 2020, 02:34 PM
  • 26 Mar 2020, 02:27 PM
  • 26 Mar 2020, 07:46 AM
  • 25 Mar 2020, 01:13 PM
  • 25 Mar 2020, 01:12 PM
  • 25 Mar 2020, 12:15 PM
  • 18 Mar 2020, 04:19 PM

Smart Checklist

Activity

Show:

Vadim Yalovets April 28, 2021 at 2:13 PM

Hi Hubertus,

Was this added in a specific version along the way?

Yes. Exporter was synced with the latest community version of exporter.

So the new filed is required for custom queries.

Hubertus Krogmann April 27, 2021 at 12:33 PM

Hello Vadim,

A year ago I "I installed the rev6," of the dashboard, https://grafana.com/grafana/dashboards/11874/revisions still show rev3 
I'm not sure what has changed between, but perhaps that could be corrected there too?

 

Regards

Hubertus Krogmann April 27, 2021 at 12:25 PM

Hello Vadim,

That worked, no error anymore and value showing up in the dashboard.

Perhaps this should be added to https://github.com/Percona-Lab/pmm-custom-queries/blob/master/postgresql/postgres_query_pg_class_generator.sh

Was this added in a specific version along the way?

Thanks

Vadim Yalovets April 27, 2021 at 12:09 PM

Hi Hubertus,

Please add field "master: true" into the file.
It has to be placed after query field.

e.g.

Hubertus Krogmann April 27, 2021 at 11:56 AM

Hello Vadim

I forgot to mention:

pmm2 Server: 2.16

Agent Versions:
maschine1: 2.4.0 (custom query is working)

maschine2: 2.9.1 (custom query is working)

new maschine: 2.16 (avove mentioned errors)

Details

Assignee

Reporter

Priority

Components

Labels

Needs QA

Yes

Needs Doc

Yes

Smart Checklist

Created January 17, 2020 at 12:34 PM
Updated January 29, 2025 at 11:28 AM

Flag notifications