<- 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",
"links": [],
"panels": [
{
"id": "7t5vrd93qiri8",
"tz": "local",
"title": "Backends",
"overrides": [],
"panelType": "STATS",
"timeRange": "1h",
"statConfig": {
"rename": [],
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last",
"value_mappings": []
},
"description": "no. of backends",
"node_configs": [
{
"exp": "postgresql_backends{host_name=\"$DBHOST\", postgresql_database_name=\"$Database\"}",
"page": 1,
"stat": "",
"type": "query",
"limit": null,
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"columns": [],
"dataset": "metrics",
"filters": [
{
"type": "string",
"field": "host_name",
"value": "$DBHOST",
"operator": "="
},
{
"type": "string",
"field": "postgresql_database_name",
"value": "$Database",
"operator": "="
}
],
"groupBy": [],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"distinctBy": null,
"metricType": "",
"query_type": "promql",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "AVG",
"type": "",
"unit": "1",
"field": "",
"value": "postgresql_backends",
"metric": "postgresql_backends",
"spatial": "LAST",
"temporal": "AVG",
"metricType": "gauge",
"temporality": "unspecified"
},
"datasourceId": "kloudmate",
"responseType": "series",
"promql_query_type": "instant"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "u9ttgoeayufew",
"tz": "local",
"title": "Max Connections",
"overrides": [],
"panelType": "STATS",
"timeRange": "1h",
"statConfig": {
"rename": [],
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last",
"value_mappings": []
},
"description": "configured max no. of client connections allowed",
"node_configs": [
{
"exp": "postgresql_connection_max",
"page": 1,
"stat": "",
"type": "query",
"limit": null,
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"columns": [],
"dataset": "metrics",
"filters": [
{
"type": "string",
"field": "host_name",
"value": "$DBHOST",
"operator": "="
}
],
"groupBy": [],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"distinctBy": null,
"metricType": "",
"query_type": "qb",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "AVG",
"type": "",
"unit": "{connections}",
"field": "",
"value": "postgresql_connection_max",
"metric": "postgresql_connection_max",
"spatial": "LAST",
"temporal": "AVG",
"metricType": "gauge",
"temporality": "unspecified"
},
"datasourceId": "kloudmate",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "knmxw8x4hcsfo",
"tz": "local",
"title": "Database Count",
"overrides": [],
"panelType": "STATS",
"timeRange": "1h",
"statConfig": {
"rename": [],
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last",
"value_mappings": []
},
"description": "no. of user databases",
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"limit": null,
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"columns": [],
"dataset": "metrics",
"filters": [
{
"type": "string",
"field": "host_name",
"value": "$DBHOST",
"operator": "="
}
],
"groupBy": [],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"distinctBy": null,
"metricType": "",
"query_type": "qb",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "AVG",
"type": "",
"unit": "{databases}",
"field": "",
"value": "postgresql_database_count",
"metric": "postgresql_database_count",
"spatial": "LAST",
"temporal": "AVG",
"metricType": "gauge",
"temporality": "unspecified"
},
"datasourceId": "kloudmate",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "osi5pfuk5md31",
"tz": "local",
"title": "Database Size",
"overrides": [],
"panelType": "STATS",
"timeRange": "1h",
"statConfig": {
"format": "bytes",
"rename": [],
"decimals": "1",
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last",
"value_mappings": []
},
"description": "database disk usage",
"node_configs": [
{
"exp": "postgresql_db_size",
"page": 1,
"stat": "",
"type": "query",
"limit": null,
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"columns": [],
"dataset": "metrics",
"filters": [
{
"type": "string",
"field": "host_name",
"value": "$DBHOST",
"operator": "="
},
{
"type": "string",
"field": "postgresql_database_name",
"value": "$Database",
"operator": "="
}
],
"groupBy": [],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"distinctBy": null,
"metricType": "",
"query_type": "qb",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "AVG",
"type": "",
"unit": "By",
"field": "",
"value": "postgresql_db_size",
"metric": "postgresql_db_size",
"ranking": {
"func": "None"
},
"spatial": "LAST",
"temporal": "AVG",
"metricType": "gauge",
"temporality": "unspecified"
},
"datasourceId": "kloudmate",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "jpw7rmf7qzuei",
"tz": "local",
"title": "Table Count",
"overrides": [],
"panelType": "STATS",
"timeRange": "1h",
"statConfig": {
"rename": [],
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last",
"value_mappings": []
},
"description": "no. of user tables in a database",
"node_configs": [
{
"exp": "postgresql_table_count",
"page": 1,
"stat": "",
"type": "query",
"limit": null,
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"columns": [],
"dataset": "metrics",
"filters": [
{
"type": "string",
"field": "host_name",
"value": "$DBHOST",
"operator": "="
},
{
"type": "string",
"field": "postgresql_database_name",
"value": "$Database",
"operator": "="
}
],
"groupBy": [],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"distinctBy": null,
"metricType": "",
"query_type": "qb",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "AVG",
"type": "",
"unit": "{table}",
"field": "",
"value": "postgresql_table_count",
"metric": "postgresql_table_count",
"ranking": {
"func": "None"
},
"spatial": "LAST",
"temporal": "AVG",
"metricType": "gauge",
"temporality": "unspecified"
},
"datasourceId": "kloudmate",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "ai4rzms41duoh",
"tz": "local",
"axis": {
"x": {
"max": "",
"min": "",
"date_style": "auto",
"bucketCount": "30",
"bucketOffset": "0"
},
"y": {
"format": "number",
"suffix": " ops/s",
"decimals": ""
}
},
"title": "Blocks Read",
"tooltip": {
"mode": "all"
},
"overrides": [],
"panelType": "TimeSeries",
"timeRange": "3h",
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"description": "rate of heap and index buffer operations",
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"limit": null,
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"columns": [],
"dataset": "metrics",
"filters": [
{
"type": "string",
"field": "source",
"value": "tidx_hit",
"operator": "!="
},
{
"type": "string",
"field": "source",
"value": "tidx_read",
"operator": "!="
},
{
"type": "string",
"field": "source",
"value": "toast_hit",
"operator": "!="
},
{
"type": "string",
"field": "source",
"value": "toast_read",
"operator": "!="
},
{
"type": "string",
"field": "host_name",
"value": "$DBHOST",
"operator": "="
},
{
"type": "string",
"field": "postgresql_database_name",
"value": "$Database",
"operator": "="
}
],
"groupBy": [
{
"type": "string",
"field": "source"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"distinctBy": null,
"metricType": "",
"query_type": "qb",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "AVG",
"type": "",
"unit": "1",
"field": "",
"value": "postgresql_blocks_read",
"metric": "postgresql_blocks_read",
"ranking": {
"func": "None"
},
"spatial": "SUM",
"temporal": "RATE",
"metricType": "sum",
"temporality": "cumulative"
},
"datasourceId": "kloudmate",
"legendFormat": "{{source}}",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "lxqmirn204ac0",
"tz": "local",
"axis": {
"x": {
"max": "",
"min": "",
"date_style": "auto",
"bucketCount": "30",
"bucketOffset": "0"
},
"y": {
"format": "number",
"prefix": "",
"suffix": " ops/s",
"decimals": "1",
"multiplyBy": 1
},
"y1": {
"suffix": "",
"multiplyBy": ""
}
},
"title": "Commits & Rollbacks",
"tooltip": {
"mode": "all"
},
"overrides": [],
"panelType": "TimeSeries",
"timeRange": "1h",
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"description": "db commits and rollbacks operations",
"node_configs": [
{
"exp": "postgresql_commits",
"page": 1,
"stat": "",
"type": "query",
"limit": null,
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"columns": [],
"dataset": "metrics",
"filters": [
{
"type": "string",
"field": "host_name",
"value": "$DBHOST",
"operator": "="
},
{
"type": "string",
"field": "postgresql_database_name",
"value": "$Database",
"operator": "="
}
],
"groupBy": [],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"distinctBy": null,
"metricType": "",
"query_type": "qb",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "AVG",
"type": "",
"unit": "1",
"field": "",
"value": "postgresql_commits",
"metric": "postgresql_commits",
"ranking": {
"func": "None"
},
"spatial": "SUM",
"temporal": "RATE",
"metricType": "sum",
"temporality": "cumulative"
},
"datasourceId": "kloudmate",
"legendFormat": "commits",
"responseType": "series"
},
{
"page": 1,
"stat": "",
"type": "query",
"limit": null,
"hidden": false,
"metric": "",
"nodeId": "B",
"region": "",
"source": "kloudmate",
"columns": [],
"dataset": "metrics",
"filters": [
{
"type": "string",
"field": "host_name",
"value": "$DBHOST",
"operator": "="
},
{
"type": "string",
"field": "postgresql_database_name",
"value": "$Database",
"operator": "="
}
],
"groupBy": [],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"distinctBy": null,
"metricType": "",
"query_type": "qb",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "AVG",
"type": "",
"unit": "1",
"field": "",
"value": "postgresql_rollbacks",
"metric": "postgresql_rollbacks",
"spatial": "SUM",
"temporal": "RATE",
"metricType": "sum",
"temporality": "cumulative"
},
"datasourceId": "kloudmate",
"legendFormat": "rollbacks",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "vtmt7jjybi1f2",
"tz": "local",
"axis": {
"x": {
"max": "",
"min": "",
"date_style": "auto",
"bucketCount": "30",
"bucketOffset": "0"
},
"y": {
"format": "number",
"suffix": " ops/s",
"decimals": "1"
}
},
"title": "Row Operations",
"tooltip": {
"mode": "all"
},
"overrides": [],
"panelType": "TimeSeries",
"timeRange": "1h",
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"description": "no. of db row operations",
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"limit": null,
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"columns": [],
"dataset": "metrics",
"filters": [
{
"type": "string",
"field": "host_name",
"value": "$DBHOST",
"operator": "="
},
{
"type": "string",
"field": "postgresql_database_name",
"value": "$Database",
"operator": "="
}
],
"groupBy": [
{
"type": "string",
"field": "operation"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"distinctBy": null,
"metricType": "",
"query_type": "qb",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "AVG",
"type": "",
"unit": "1",
"field": "",
"value": "postgresql_operations",
"metric": "postgresql_operations",
"ranking": {
"func": "None"
},
"spatial": "SUM",
"temporal": "RATE",
"metricType": "sum",
"temporality": "cumulative"
},
"datasourceId": "kloudmate",
"legendFormat": "{{operation}}",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "l4iq33r6bi0x6",
"tz": "local",
"table": {
"columns": [
{
"key": "postgresql_table_name",
"rename": "Table"
},
{
"key": "A:LAST()",
"format": {
"format": "bytes",
"decimals": "1"
},
"rename": "Size"
}
]
},
"title": "Top Tables by Size",
"panelType": "table",
"timeRange": "1h",
"description": "disk space used by a table",
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"limit": null,
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"columns": [],
"dataset": "metrics",
"filters": [
{
"type": "string",
"field": "host_name",
"value": "$DBHOST",
"operator": "="
},
{
"type": "string",
"field": "postgresql_database_name",
"value": "$Database",
"operator": "="
}
],
"groupBy": [
{
"type": "string",
"field": "postgresql_table_name"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"distinctBy": null,
"metricType": "",
"query_type": "qb",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "LAST",
"type": "",
"unit": "By",
"field": "",
"value": "postgresql_table_size",
"metric": "postgresql_table_size",
"ranking": {
"func": "TopK",
"value": 10
},
"spatial": "LAST",
"temporal": "AVG",
"metricType": "gauge",
"temporality": "unspecified"
},
"datasourceId": "kloudmate",
"responseType": "number"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "6p5eigzdfivdr",
"tz": "local",
"table": {
"columns": [
{
"key": "postgresql_index_name",
"rename": "Index"
},
{
"key": "A:LAST()",
"format": {
"format": "bytes"
},
"rename": "Size"
}
]
},
"title": "Top Indices by Size",
"panelType": "table",
"timeRange": "1h",
"description": "size of the index on disk",
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"limit": null,
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"columns": [],
"dataset": "metrics",
"filters": [
{
"type": "string",
"field": "host_name",
"value": "$DBHOST",
"operator": "="
},
{
"type": "string",
"field": "postgresql_database_name",
"value": "$Database",
"operator": "="
}
],
"groupBy": [
{
"type": "string",
"field": "postgresql_index_name"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"distinctBy": null,
"metricType": "",
"query_type": "qb",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "LAST",
"type": "",
"unit": "By",
"field": "",
"value": "postgresql_index_size",
"metric": "postgresql_index_size",
"ranking": {
"func": "TopK",
"value": 10
},
"spatial": "LAST",
"temporal": "AVG",
"metricType": "gauge",
"temporality": "unspecified"
},
"datasourceId": "kloudmate",
"responseType": "number"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "2p7scbn9c655p",
"tz": "local",
"table": {
"columns": [
{
"key": "postgresql_table_name",
"rename": "Table"
},
{
"key": "A:LAST()",
"rename": "Live rows"
},
{
"key": "B:LAST()",
"rename": "Dead rows"
}
]
},
"title": "New Panel",
"panelType": "table",
"timeRange": "3h",
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"limit": null,
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"columns": [],
"dataset": "metrics",
"filters": [
{
"type": "string",
"field": "host_name",
"value": "$DBHOST",
"operator": "="
},
{
"type": "string",
"field": "postgresql_database_name",
"value": "$Database",
"operator": "="
},
{
"type": "string",
"field": "state",
"value": "live",
"operator": "="
}
],
"groupBy": [
{
"type": "string",
"field": "postgresql_table_name"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"distinctBy": null,
"metricType": "",
"query_type": "qb",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "LAST",
"type": "",
"unit": "1",
"field": "",
"value": "postgresql_rows",
"metric": "postgresql_rows",
"ranking": {
"func": "None"
},
"spatial": "LAST",
"temporal": "AVG",
"metricType": "gauge",
"temporality": "unspecified"
},
"datasourceId": "kloudmate",
"responseType": "number"
},
{
"page": 1,
"stat": "",
"type": "query",
"limit": null,
"hidden": false,
"metric": "",
"nodeId": "B",
"region": "",
"source": "kloudmate",
"columns": [],
"dataset": "metrics",
"filters": [
{
"type": "string",
"field": "host_name",
"value": "$DBHOST",
"operator": "="
},
{
"type": "string",
"field": "postgresql_database_name",
"value": "$Database",
"operator": "="
},
{
"type": "string",
"field": "state",
"value": "dead",
"operator": "="
}
],
"groupBy": [
{
"type": "string",
"field": "postgresql_table_name"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"distinctBy": null,
"metricType": "",
"query_type": "qb",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "LAST",
"type": "",
"unit": "1",
"field": "",
"value": "postgresql_rows",
"metric": "postgresql_rows",
"ranking": {
"func": "None"
},
"spatial": "AVG",
"temporal": "AVG",
"metricType": "gauge",
"temporality": "unspecified"
},
"datasourceId": "kloudmate",
"responseType": "number"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "n44io7nz28l4y",
"tz": "local",
"axis": {
"x": {
"max": "",
"min": "",
"date_style": "auto",
"bucketCount": "30",
"bucketOffset": "0"
},
"y": {
"format": "number",
"suffix": " dl/s",
"decimals": "1"
}
},
"title": "Deadlocks",
"tooltip": {
"mode": "single"
},
"overrides": [],
"panelType": "TimeSeries",
"timeRange": "8h",
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"description": "no. of deadlocks per sec",
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"limit": null,
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"columns": [],
"dataset": "metrics",
"filters": [
{
"type": "string",
"field": "host_name",
"value": "$DBHOST",
"operator": "="
},
{
"type": "string",
"field": "postgresql_database_name",
"value": "$Database",
"operator": "="
}
],
"groupBy": [],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"distinctBy": null,
"metricType": "",
"query_type": "qb",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "AVG",
"type": "",
"unit": "{deadlock}",
"field": "",
"value": "postgresql_deadlocks",
"metric": "postgresql_deadlocks",
"spatial": "SUM",
"temporal": "RATE",
"metricType": "sum",
"temporality": "cumulative"
},
"datasourceId": "kloudmate",
"legendFormat": "deadlocks",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "lzehrigf6r565",
"tz": "local",
"axis": {
"x": {
"max": "",
"min": "",
"date_style": "auto",
"bucketCount": "30",
"bucketOffset": "0"
},
"y": {
"format": "number",
"suffix": " sc/s",
"decimals": "1"
}
},
"title": "Index Scans",
"tooltip": {
"mode": "single"
},
"overrides": [],
"panelType": "TimeSeries",
"timeRange": "1h",
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"description": "no. of index scans on a table",
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"limit": null,
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"columns": [],
"dataset": "metrics",
"filters": [
{
"type": "string",
"field": "host_name",
"value": "$DBHOST",
"operator": "="
},
{
"type": "string",
"field": "postgresql_database_name",
"value": "$Database",
"operator": "="
}
],
"groupBy": [],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"distinctBy": null,
"metricType": "",
"query_type": "qb",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "AVG",
"type": "",
"unit": "{scans}",
"field": "",
"value": "postgresql_index_scans",
"metric": "postgresql_index_scans",
"spatial": "SUM",
"temporal": "RATE",
"metricType": "sum",
"temporality": "cumulative"
},
"datasourceId": "kloudmate",
"legendFormat": "index scans",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "3uegua44fjjrq",
"tz": "local",
"axis": {
"x": {
"max": "",
"min": "",
"date_style": "auto",
"bucketCount": "30",
"bucketOffset": "0"
},
"y": {
"format": "number",
"suffix": "",
"decimals": ""
}
},
"title": "Database Locks",
"tooltip": {
"mode": "all"
},
"overrides": [],
"panelType": "TimeSeries",
"timeRange": "1h",
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"description": "no. of database locks",
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"limit": null,
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"columns": [],
"dataset": "metrics",
"filters": [
{
"type": "string",
"field": "host_name",
"value": "$DBHOST",
"operator": "="
}
],
"groupBy": [
{
"type": "string",
"field": "relation"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"distinctBy": null,
"metricType": "",
"query_type": "qb",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "AVG",
"type": "",
"unit": "{lock}",
"field": "",
"value": "postgresql_database_locks",
"metric": "postgresql_database_locks",
"ranking": {
"func": "None"
},
"spatial": "LAST",
"temporal": "AVG",
"metricType": "gauge",
"temporality": "unspecified"
},
"datasourceId": "kloudmate",
"legendFormat": "{{relation}}",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
}
],
"timeRange": "1h",
"variables": [
{
"name": "DBHOST",
"type": "query",
"label": "DB_HOST",
"config": {
"otel": {
"key": {
"type": "string",
"field": "host_name"
},
"dataset": "metrics",
"filters": [
{
"type": "string",
"field": "postgresql_database_name",
"value": "",
"operator": "EXISTS"
}
]
},
"source": "cloudwatch",
"queryType": "otel.values"
},
"is_multi": false,
"description": "",
"usesVariables": [],
"show_all_option": false
},
{
"name": "Database",
"type": "query",
"label": "Database",
"config": {
"otel": {
"key": {
"type": "string",
"field": "postgresql_database_name"
},
"dataset": "metrics"
},
"source": "cloudwatch",
"queryType": "otel.values"
},
"is_multi": false,
"description": "",
"show_all_option": false
}
],
"panel_layouts": [
{
"h": 6,
"i": "7t5vrd93qiri8",
"w": 5,
"x": 9,
"y": 0,
"minH": 1,
"minW": 1,
"moved": false,
"static": false
},
{
"h": 6,
"i": "u9ttgoeayufew",
"w": 5,
"x": 4,
"y": 0,
"minH": 1,
"minW": 1,
"moved": false,
"static": false
},
{
"h": 6,
"i": "knmxw8x4hcsfo",
"w": 4,
"x": 0,
"y": 0,
"minH": 1,
"minW": 1,
"moved": false,
"static": false
},
{
"h": 6,
"i": "osi5pfuk5md31",
"w": 5,
"x": 14,
"y": 0,
"minH": 1,
"minW": 1,
"moved": false,
"static": false
},
{
"h": 6,
"i": "jpw7rmf7qzuei",
"w": 5,
"x": 19,
"y": 0,
"minH": 1,
"minW": 1,
"moved": false,
"static": false
},
{
"h": 10,
"i": "ai4rzms41duoh",
"w": 8,
"x": 0,
"y": 6,
"minH": 1,
"minW": 1,
"moved": false,
"static": false
},
{
"h": 10,
"i": "lxqmirn204ac0",
"w": 8,
"x": 8,
"y": 6,
"minH": 1,
"minW": 1,
"moved": false,
"static": false
},
{
"h": 10,
"i": "vtmt7jjybi1f2",
"w": 8,
"x": 16,
"y": 6,
"minH": 1,
"minW": 1,
"moved": false,
"static": false
},
{
"h": 10,
"i": "l4iq33r6bi0x6",
"w": 8,
"x": 0,
"y": 16,
"minH": 1,
"minW": 1,
"moved": false,
"static": false
},
{
"h": 10,
"i": "6p5eigzdfivdr",
"w": 8,
"x": 8,
"y": 16,
"minH": 1,
"minW": 1,
"moved": false,
"static": false
},
{
"h": 10,
"i": "2p7scbn9c655p",
"w": 8,
"x": 16,
"y": 16,
"minH": 1,
"minW": 1,
"moved": false,
"static": false
},
{
"h": 10,
"i": "n44io7nz28l4y",
"w": 8,
"x": 0,
"y": 26,
"minH": 1,
"minW": 1,
"moved": false,
"static": false
},
{
"h": 10,
"i": "lzehrigf6r565",
"w": 8,
"x": 8,
"y": 26,
"minH": 1,
"minW": 1,
"moved": false,
"static": false
},
{
"h": 10,
"i": "3uegua44fjjrq",
"w": 8,
"x": 16,
"y": 26,
"minH": 1,
"minW": 1,
"moved": false,
"static": false
}
],
"default_region": "us-east-1"
},
"tags": []
}