<- Back to Templates
PostgreSQL
By KloudMate
The PostgreSQL dashboard provides deep visibility into database health, performance, and resource usage by integrating with OpenTelemetry (Otel).
Template JSON
{
"name": "PostgreSQL",
"description": "",
"data": {
"tz": "local",
"panels": [
{
"id": "dsbsb8q5lo",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "number",
"decimals": 3
}
},
"title": "Operations",
"panelType": "TimeSeries",
"timeRange": "1h",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"node_configs": [
{
"stat": "",
"type": "query",
"limit": "",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [
{
"type": "root",
"field": "serviceName",
"value": "$hostname",
"operator": "="
}
],
"groupBy": [
{
"type": "string",
"field": "operation"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "AVG",
"type": "",
"unit": "1",
"field": "",
"value": "postgresql_operations",
"metric": "postgresql_operations",
"metricType": "Sum",
"temporality": "Delta"
},
"datasourceId": "kloudmate",
"legendFormat": "{{operation}}",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "denz4pnhynb",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "number",
"suffix": "{deadlock}",
"decimals": 3
}
},
"title": "Deadlock",
"panelType": "TimeSeries",
"timeRange": "1h",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"node_configs": [
{
"stat": "",
"type": "query",
"limit": "",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [
{
"type": "root",
"field": "serviceName",
"value": "$hostname",
"operator": "="
}
],
"groupBy": [
{
"type": "string",
"field": "postgresql_database_name"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"unit": "{deadlock}",
"field": "",
"range": "1m",
"value": "postgresql_deadlocks",
"metric": "postgresql_deadlocks",
"metricType": "Sum",
"temporality": "Delta"
},
"datasourceId": "kloudmate",
"legendFormat": "{{postgresql_database_name}}",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "4fn3njcz4qc",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "number",
"suffix": "{lock}",
"decimals": 3
}
},
"title": "Databaselock_relation",
"panelType": "TimeSeries",
"timeRange": "1h",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"description": "OID of the relation targeted by the lock, or null if the target is not a relation or part of a relation",
"node_configs": [
{
"stat": "",
"type": "query",
"limit": "",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [
{
"type": "root",
"field": "serviceName",
"value": "$hostname",
"operator": "="
}
],
"groupBy": [
{
"type": "string",
"field": "relation"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"unit": "{lock}",
"field": "",
"value": "postgresql_database_locks",
"metric": "postgresql_database_locks",
"metricType": "Gauge",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate",
"legendFormat": "{{relation}}",
"responseType": "series"
},
{
"stat": "",
"type": "query",
"limit": "",
"hidden": true,
"metric": "",
"nodeId": "B",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [
{
"type": "root",
"field": "serviceName",
"value": "$hostname",
"operator": "="
}
],
"groupBy": [
{
"type": "string",
"field": "mode"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"unit": "{lock}",
"field": "",
"value": "postgresql_database_locks",
"metric": "postgresql_database_locks",
"metricType": "Gauge",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate",
"legendFormat": "{{mode}}",
"responseType": "series"
},
{
"stat": "",
"type": "query",
"limit": "",
"hidden": true,
"metric": "",
"nodeId": "C",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [
{
"type": "root",
"field": "serviceName",
"value": "$hostname",
"operator": "="
}
],
"groupBy": [
{
"type": "string",
"field": "lock_type"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"unit": "{lock}",
"field": "",
"value": "postgresql_database_locks",
"metric": "postgresql_database_locks",
"metricType": "Gauge",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate",
"legendFormat": "{{lock_type}}",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "8zrul4pwsk",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "number",
"decimals": 3
}
},
"title": "Block Read",
"panelType": "TimeSeries",
"timeRange": "1h",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"description": "The number of blocks read",
"node_configs": [
{
"stat": "",
"type": "query",
"limit": "",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [
{
"type": "root",
"field": "serviceName",
"value": "$hostname",
"operator": "="
}
],
"groupBy": [
{
"type": "string",
"field": "source"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"unit": "1",
"field": "",
"value": "postgresql_blocks_read",
"metric": "postgresql_blocks_read",
"metricType": "Sum",
"temporality": "Delta"
},
"datasourceId": "kloudmate",
"legendFormat": "{{source}}",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "guajfdwqa8r",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "bytes",
"decimals": 3
}
},
"title": "Database size",
"panelType": "TimeSeries",
"timeRange": "1h",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "table",
"values": [
{
"label": "Last",
"value": "last"
}
]
}
},
"node_configs": [
{
"stat": "",
"type": "query",
"limit": "",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [
{
"type": "root",
"field": "serviceName",
"value": "$hostname",
"operator": "="
}
],
"groupBy": [
{
"type": "string",
"field": "postgresql_database_name"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "AVG",
"type": "",
"unit": "By",
"field": "",
"value": "postgresql_db_size",
"metric": "postgresql_db_size",
"metricType": "Sum",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate",
"legendFormat": "{{postgresql_database_name}}",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "2s28u2trtc2",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "number",
"suffix": "{connections}",
"decimals": 3
}
},
"title": "Maximum connections",
"panelType": "STATS",
"timeRange": "1h",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"node_configs": [
{
"stat": "",
"type": "query",
"limit": "",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [
{
"type": "root",
"field": "serviceName",
"value": "$hostname",
"operator": "="
}
],
"groupBy": [
{
"type": "root",
"field": "serviceName"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"unit": "{connections}",
"field": "",
"value": "postgresql_connection_max",
"metric": "postgresql_connection_max",
"metricType": "Gauge",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate",
"legendFormat": "{{serviceName}}",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "gn0a256xiun",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "number",
"suffix": "{connections}",
"decimals": 3
}
},
"table": {
"columns": [
{
"key": "A:COUNT()",
"rename": ""
}
]
},
"title": "Database count",
"overrides": [],
"panelType": "STATS",
"timeRange": "1h",
"statConfig": {
"format": "number",
"suffix": "",
"decimals": 3,
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"node_configs": [
{
"stat": "",
"type": "query",
"limit": "",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [
{
"type": "root",
"field": "serviceName",
"value": "$hostname",
"operator": "="
}
],
"groupBy": [],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"unit": "{databases}",
"field": "",
"value": "postgresql_database_count",
"metric": "postgresql_database_count",
"metricType": "Sum",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate",
"legendFormat": "",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "34goz12p2l6",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "number",
"suffix": "{connections}",
"decimals": 3
}
},
"title": "Total Rows",
"panelType": "STATS",
"timeRange": "1h",
"statConfig": {
"format": "number",
"decimals": 3,
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"node_configs": [
{
"stat": "",
"type": "query",
"limit": "",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [
{
"type": "root",
"field": "serviceName",
"value": "$hostname",
"operator": "="
}
],
"groupBy": [
{
"type": "root",
"field": "serviceName"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"unit": "1",
"field": "",
"value": "postgresql_rows",
"metric": "postgresql_rows",
"metricType": "Sum",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate",
"legendFormat": "{{serviceName}}",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "jra8s3hgd9d",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "bytes",
"decimals": 3
}
},
"table": {
"columns": [
{
"key": "A:AVG()",
"rename": ""
},
{
"key": "postgresql_table_name",
"rename": ""
}
]
},
"title": "Table size",
"panelType": "TimeSeries",
"timeRange": "1h",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "table",
"values": [
{
"label": "Last",
"value": "last"
}
]
}
},
"node_configs": [
{
"stat": "",
"type": "query",
"limit": "",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [
{
"type": "root",
"field": "serviceName",
"value": "$hostname",
"operator": "="
}
],
"groupBy": [
{
"type": "string",
"field": "postgresql_table_name"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "AVG",
"type": "",
"unit": "By",
"field": "",
"value": "postgresql_table_size",
"metric": "postgresql_table_size",
"metricType": "Sum",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate",
"legendFormat": "{{postgresql_table_name}}",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "ijxhe8umdlj",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "number",
"suffix": "{connections}",
"decimals": 3
}
},
"table": {
"columns": [
{
"key": "A:COUNT()",
"rename": ""
}
]
},
"title": "Table count",
"overrides": [],
"panelType": "STATS",
"timeRange": "1h",
"statConfig": {
"format": "number",
"suffix": "",
"decimals": 3,
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"node_configs": [
{
"stat": "",
"type": "query",
"limit": "",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [
{
"type": "root",
"field": "serviceName",
"value": "$hostname",
"operator": "="
}
],
"groupBy": [],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"unit": "{table}",
"field": "",
"value": "postgresql_table_count",
"metric": "postgresql_table_count",
"metricType": "Sum",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate",
"legendFormat": "",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "5xkogyi2szm",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "bytes",
"decimals": 3
}
},
"title": "Index size",
"panelType": "TimeSeries",
"timeRange": "1h",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "table",
"values": [
{
"label": "Mean",
"value": "mean"
}
]
}
},
"node_configs": [
{
"stat": "",
"type": "query",
"limit": "",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [
{
"type": "root",
"field": "serviceName",
"value": "$hostname",
"operator": "="
}
],
"groupBy": [
{
"type": "string",
"field": "postgresql_index_name"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "MAX",
"type": "",
"unit": "By",
"field": "",
"value": "postgresql_index_size",
"metric": "postgresql_index_size",
"metricType": "Gauge",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate",
"legendFormat": "{{postgresql_index_name}}",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "5mq81kj94fm",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "number",
"decimals": 3
}
},
"title": "Rollback",
"panelType": "TimeSeries",
"timeRange": "1h",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"node_configs": [
{
"stat": "",
"type": "query",
"limit": "",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [
{
"type": "root",
"field": "serviceName",
"value": "$hostname",
"operator": "="
}
],
"groupBy": [
{
"type": "string",
"field": "postgresql_database_name"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"unit": "1",
"field": "",
"value": "postgresql_rollbacks",
"metric": "postgresql_rollbacks",
"metricType": "Sum",
"temporality": "Delta"
},
"datasourceId": "kloudmate",
"legendFormat": "{{postgresql_database_name}}",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "awx2hxmvijv",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "number",
"suffix": "{buffers}",
"decimals": 3
}
},
"title": "Background Writer Buffer Allocated",
"panelType": "TimeSeries",
"timeRange": "1h",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"node_configs": [
{
"stat": "",
"type": "query",
"limit": "",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [
{
"type": "root",
"field": "serviceName",
"value": "$hostname",
"operator": "="
}
],
"groupBy": [],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"unit": "{buffers}",
"field": "",
"value": "postgresql_bgwriter_buffers_allocated",
"metric": "postgresql_bgwriter_buffers_allocated",
"metricType": "Sum",
"temporality": "Delta"
},
"datasourceId": "kloudmate",
"legendFormat": "Buffers allocated",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "qc8x2k345ya",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "number",
"suffix": "{buffers}",
"decimals": 3
}
},
"title": "Background Writer Buffer Writes",
"panelType": "TimeSeries",
"timeRange": "1h",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"description": "Number of buffers written",
"node_configs": [
{
"stat": "",
"type": "query",
"limit": "",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [
{
"type": "root",
"field": "serviceName",
"value": "$hostname",
"operator": "="
}
],
"groupBy": [
{
"type": "string",
"field": "source"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "AVG",
"type": "",
"unit": "{buffers}",
"field": "",
"value": "postgresql_bgwriter_buffers_writes",
"metric": "postgresql_bgwriter_buffers_writes",
"metricType": "Sum",
"temporality": "Delta"
},
"datasourceId": "kloudmate",
"legendFormat": "{{source}}",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "dxaqnhgpyd",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "bytes",
"decimals": 3
}
},
"table": {
"columns": [
{
"key": "A:AVG()",
"format": {
"format": "bytes"
},
"rename": "DatabaseSize"
},
{
"key": "postgresql_database_name",
"rename": "DatabaseName"
}
]
},
"title": "Database sizes Order by Desc",
"panelType": "table",
"timeRange": "1h",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"node_configs": [
{
"stat": "",
"type": "query",
"limit": null,
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"columns": [],
"dataset": "metrics",
"filters": [
{
"type": "root",
"field": "serviceName",
"value": "$hostname",
"operator": "="
}
],
"groupBy": [
{
"type": "string",
"field": "postgresql_database_name"
}
],
"orderBy": [
{
"field": "postgresql_database_name",
"order": "desc"
}
],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"query_type": "qb",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "AVG",
"type": "",
"field": "",
"value": "postgresql_db_size",
"metric": "postgresql_db_size"
},
"datasourceId": "kloudmate",
"legendFormat": "{{postgresql_database_name}}",
"responseType": "number"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "lf9ttx3jzll",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "bytes",
"decimals": 3
}
},
"table": {
"columns": [
{
"key": "A:AVG()",
"format": {
"format": "bytes",
"decimals": 3
},
"rename": "table size"
},
{
"key": "postgresql_database_name",
"rename": ""
},
{
"key": "postgresql_table_name",
"rename": ""
}
]
},
"title": "Table size Order by Desc",
"panelType": "table",
"timeRange": "1h",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": [
{
"label": "Last",
"value": "last"
}
]
}
},
"node_configs": [
{
"stat": "",
"type": "query",
"limit": null,
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"columns": [],
"dataset": "metrics",
"filters": [
{
"type": "root",
"field": "serviceName",
"value": "$hostname",
"operator": "="
}
],
"groupBy": [
{
"type": "string",
"field": "postgresql_database_name"
},
{
"type": "string",
"field": "postgresql_table_name"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"query_type": "qb",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "AVG",
"type": "",
"field": "",
"value": "postgresql_table_size",
"metric": "postgresql_table_size"
},
"datasourceId": "kloudmate",
"legendFormat": "{{postgresql_table_name}}",
"responseType": "number"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "c2onm6efuc",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "bytes",
"decimals": 3
}
},
"table": {
"columns": [
{
"key": "A:AVG()",
"format": {
"format": "bytes"
},
"rename": "Index Size"
},
{
"key": "postgresql_database_name",
"rename": "DatabaseName"
},
{
"key": "postgresql_index_name",
"rename": "IndexName"
},
{
"key": "postgresql_table_name",
"rename": "TableName"
}
]
},
"title": "Index size Order by Desc",
"panelType": "table",
"timeRange": "1h",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "table",
"values": [
{
"label": "Mean",
"value": "mean"
}
]
}
},
"node_configs": [
{
"stat": "",
"type": "query",
"limit": null,
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"columns": [],
"dataset": "metrics",
"filters": [
{
"type": "root",
"field": "serviceName",
"value": "$hostname",
"operator": "="
}
],
"groupBy": [
{
"type": "string",
"field": "postgresql_database_name"
},
{
"type": "string",
"field": "postgresql_index_name"
},
{
"type": "string",
"field": "postgresql_table_name"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"query_type": "qb",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "AVG",
"type": "",
"field": "",
"value": "postgresql_index_size",
"metric": "postgresql_index_size"
},
"datasourceId": "kloudmate",
"legendFormat": "{{postgresql_index_name}}",
"responseType": "number"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "omikp205qyo",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "number",
"decimals": 3
}
},
"title": "Backend",
"panelType": "TimeSeries",
"timeRange": "1h",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [
{
"type": "root",
"field": "serviceName",
"value": "$hostname",
"operator": "="
}
],
"groupBy": [
{
"type": "string",
"field": "postgresql_database_name"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"unit": "1",
"field": "",
"value": "postgresql_backends",
"metric": "postgresql_backends",
"metricType": "Sum",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate",
"legendFormat": "{{postgresql_database_name}}"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "gyj6ieu52yl",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "unformatted",
"decimals": 3
}
},
"title": "Total Rows",
"panelType": "TimeSeries",
"timeRange": "1h",
"statConfig": {
"format": "number",
"decimals": 3,
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"node_configs": [
{
"stat": "",
"type": "query",
"limit": null,
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"columns": [],
"dataset": "metrics",
"filters": [
{
"type": "root",
"field": "serviceName",
"value": "$hostname",
"operator": "="
}
],
"groupBy": [
{
"type": "string",
"field": "state"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"query_type": "qb",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"field": "",
"value": "postgresql_rows",
"metric": "postgresql_rows"
},
"datasourceId": "kloudmate",
"legendFormat": "{{state}}",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "gh1laandu9s",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "number",
"suffix": "{lock}",
"decimals": 3
}
},
"title": "Databaselock_mode",
"panelType": "TimeSeries",
"timeRange": "1h",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"description": "Name of the lock mode held or desired by the process",
"node_configs": [
{
"stat": "",
"type": "query",
"limit": "",
"hidden": true,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [
{
"type": "root",
"field": "serviceName",
"value": "$hostname",
"operator": "="
}
],
"groupBy": [
{
"type": "string",
"field": "relation"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"unit": "{lock}",
"field": "",
"value": "postgresql_database_locks",
"metric": "postgresql_database_locks",
"metricType": "Gauge",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate",
"legendFormat": "{{relation}}",
"responseType": "series"
},
{
"stat": "",
"type": "query",
"limit": "",
"hidden": false,
"metric": "",
"nodeId": "B",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [
{
"type": "root",
"field": "serviceName",
"value": "$hostname",
"operator": "="
}
],
"groupBy": [
{
"type": "string",
"field": "mode"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"unit": "{lock}",
"field": "",
"value": "postgresql_database_locks",
"metric": "postgresql_database_locks",
"metricType": "Gauge",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate",
"legendFormat": "{{mode}}",
"responseType": "series"
},
{
"stat": "",
"type": "query",
"limit": "",
"hidden": true,
"metric": "",
"nodeId": "C",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [
{
"type": "root",
"field": "serviceName",
"value": "$hostname",
"operator": "="
}
],
"groupBy": [
{
"type": "string",
"field": "lock_type"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"unit": "{lock}",
"field": "",
"value": "postgresql_database_locks",
"metric": "postgresql_database_locks",
"metricType": "Gauge",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate",
"legendFormat": "{{lock_type}}",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "5js8wcx4u17",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "number",
"suffix": "{lock}",
"decimals": 3
}
},
"title": "Databaselock_locktype",
"panelType": "TimeSeries",
"timeRange": "1h",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"description": "Type of the lockable object",
"node_configs": [
{
"stat": "",
"type": "query",
"limit": "",
"hidden": true,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [
{
"type": "root",
"field": "serviceName",
"value": "$hostname",
"operator": "="
}
],
"groupBy": [
{
"type": "string",
"field": "relation"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"unit": "{lock}",
"field": "",
"value": "postgresql_database_locks",
"metric": "postgresql_database_locks",
"metricType": "Gauge",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate",
"legendFormat": "{{relation}}",
"responseType": "series"
},
{
"stat": "",
"type": "query",
"limit": "",
"hidden": true,
"metric": "",
"nodeId": "B",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [
{
"type": "root",
"field": "serviceName",
"value": "$hostname",
"operator": "="
}
],
"groupBy": [
{
"type": "string",
"field": "mode"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"unit": "{lock}",
"field": "",
"value": "postgresql_database_locks",
"metric": "postgresql_database_locks",
"metricType": "Gauge",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate",
"legendFormat": "{{mode}}",
"responseType": "series"
},
{
"stat": "",
"type": "query",
"limit": "",
"hidden": false,
"metric": "",
"nodeId": "C",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [
{
"type": "root",
"field": "serviceName",
"value": "$hostname",
"operator": "="
}
],
"groupBy": [
{
"type": "string",
"field": "lock_type"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"unit": "{lock}",
"field": "",
"value": "postgresql_database_locks",
"metric": "postgresql_database_locks",
"metricType": "Gauge",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate",
"legendFormat": "{{lock_type}}",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "ff6tp0xsp9v",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "unformatted",
"decimals": 3
}
},
"title": "Index Scans",
"panelType": "TimeSeries",
"timeRange": "1h",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"description": "The number of index scans on a table",
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [
{
"type": "root",
"field": "serviceName",
"value": "$hostname",
"operator": "="
}
],
"groupBy": [
{
"type": "string",
"field": "postgresql_database_name"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"field": "",
"value": "postgresql_index_scans",
"metric": "postgresql_index_scans"
},
"datasourceId": "kloudmate",
"legendFormat": "{{postgresql_database_name}}"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "082b2y9cvxbf",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "number",
"suffix": "{checkpoints}",
"decimals": 3
}
},
"title": "Background Writer Checkpoint Count",
"panelType": "TimeSeries",
"timeRange": "1h",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [
{
"type": "root",
"field": "serviceName",
"value": "$hostname",
"operator": "="
}
],
"groupBy": [
{
"type": "string",
"field": "type"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"unit": "{checkpoints}",
"field": "",
"value": "postgresql_bgwriter_checkpoint_count",
"metric": "postgresql_bgwriter_checkpoint_count",
"metricType": "Sum",
"temporality": "Delta"
},
"datasourceId": "kloudmate",
"legendFormat": "{{type}}"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "30ts9uw2ttc",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "duration",
"decimals": 3
}
},
"title": "Background Writer Duration",
"panelType": "TimeSeries",
"timeRange": "1h",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [
{
"type": "root",
"field": "serviceName",
"value": "$hostname",
"operator": "="
}
],
"groupBy": [
{
"type": "string",
"field": "type"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"unit": "ms",
"field": "",
"value": "postgresql_bgwriter_duration",
"metric": "postgresql_bgwriter_duration",
"metricType": "Sum",
"temporality": "Delta"
},
"datasourceId": "kloudmate",
"legendFormat": "{{type}}"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "5e69wg4fr08",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
}
},
"table": {
"columns": [
{
"key": "timestamp",
"rename": ""
},
{
"key": "@message.query",
"rename": "QUERY"
},
{
"key": "@message.duration",
"rename": "duration (in milisecond)"
}
]
},
"title": "Slow Query",
"panelType": "logs",
"timeRange": "30m",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"limit": "100",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"columns": [
{
"type": "root",
"field": "timestamp"
},
{
"type": "string",
"field": "@message.query"
},
{
"type": "string",
"field": "@message.duration"
}
],
"dataset": "logs",
"filters": [
{
"type": "root",
"field": "serviceName",
"value": "$hostname",
"operator": "="
},
{
"type": "string",
"field": "@message.duration",
"value": "1000",
"operator": ">"
}
],
"groupBy": [],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"query_type": "raw",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "AVG",
"type": "",
"field": ""
},
"datasourceId": "kloudmate",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
}
],
"timeRange": "1h",
"variables": [
{
"id": "9c594b7a-66b1-4d0e-b3ab-9d953bd09d0c",
"name": "hostname",
"type": "query",
"config": {
"otel": {
"key": {
"type": "root",
"field": "serviceName"
},
"dataset": "metrics"
},
"source": "cloudwatch",
"queryType": "otel.values"
},
"is_multi": false,
"description": "",
"show_all_option": false
}
],
"panel_layouts": [
{
"h": 3,
"i": "dsbsb8q5lo",
"w": 7,
"x": 5,
"y": 7,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 3,
"i": "denz4pnhynb",
"w": 6,
"x": 6,
"y": 15,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 3,
"i": "4fn3njcz4qc",
"w": 4,
"x": 0,
"y": 12,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 3,
"i": "8zrul4pwsk",
"w": 6,
"x": 0,
"y": 15,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 3,
"i": "guajfdwqa8r",
"w": 4,
"x": 0,
"y": 1,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 1,
"i": "2s28u2trtc2",
"w": 3,
"x": 6,
"y": 0,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 1,
"i": "gn0a256xiun",
"w": 3,
"x": 0,
"y": 0,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 1,
"i": "34goz12p2l6",
"w": 3,
"x": 9,
"y": 0,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 3,
"i": "jra8s3hgd9d",
"w": 4,
"x": 4,
"y": 1,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 1,
"i": "ijxhe8umdlj",
"w": 3,
"x": 3,
"y": 0,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 3,
"i": "5xkogyi2szm",
"w": 4,
"x": 8,
"y": 1,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 2,
"i": "5mq81kj94fm",
"w": 6,
"x": 0,
"y": 20,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 2,
"i": "awx2hxmvijv",
"w": 6,
"x": 0,
"y": 18,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 2,
"i": "qc8x2k345ya",
"w": 6,
"x": 6,
"y": 18,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 3,
"i": "dxaqnhgpyd",
"w": 4,
"x": 0,
"y": 4,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 3,
"i": "lf9ttx3jzll",
"w": 4,
"x": 4,
"y": 4,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 3,
"i": "c2onm6efuc",
"w": 4,
"x": 8,
"y": 4,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 2,
"i": "omikp205qyo",
"w": 6,
"x": 6,
"y": 20,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 2,
"i": "gyj6ieu52yl",
"w": 3,
"x": 5,
"y": 10,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 3,
"i": "gh1laandu9s",
"w": 4,
"x": 4,
"y": 12,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 3,
"i": "5js8wcx4u17",
"w": 4,
"x": 8,
"y": 12,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 2,
"i": "ff6tp0xsp9v",
"w": 4,
"x": 8,
"y": 10,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 2,
"i": "082b2y9cvxbf",
"w": 6,
"x": 0,
"y": 22,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 2,
"i": "30ts9uw2ttc",
"w": 6,
"x": 6,
"y": 22,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 5,
"i": "5e69wg4fr08",
"w": 5,
"x": 0,
"y": 7,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
}
],
"default_region": "us-east-1"
},
"tags": []
}