cnpg.json (250084B)
1 { 2 "__inputs": [ 3 { 4 "name": "DS_PROMETHEUS", 5 "label": "Prometheus", 6 "description": "", 7 "type": "datasource", 8 "pluginId": "prometheus", 9 "pluginName": "Prometheus" 10 }, 11 { 12 "name": "DS_EXPRESSION", 13 "label": "Expression", 14 "description": "", 15 "type": "datasource", 16 "pluginId": "__expr__" 17 } 18 ], 19 "__elements": {}, 20 "__requires": [ 21 { 22 "type": "datasource", 23 "id": "__expr__", 24 "version": "1.0.0" 25 }, 26 { 27 "type": "panel", 28 "id": "alertlist", 29 "name": "Alert list", 30 "version": "" 31 }, 32 { 33 "type": "panel", 34 "id": "bargauge", 35 "name": "Bar gauge", 36 "version": "" 37 }, 38 { 39 "type": "panel", 40 "id": "gauge", 41 "name": "Gauge", 42 "version": "" 43 }, 44 { 45 "type": "grafana", 46 "id": "grafana", 47 "name": "Grafana", 48 "version": "10.3.3" 49 }, 50 { 51 "type": "panel", 52 "id": "heatmap", 53 "name": "Heatmap", 54 "version": "" 55 }, 56 { 57 "type": "datasource", 58 "id": "prometheus", 59 "name": "Prometheus", 60 "version": "1.0.0" 61 }, 62 { 63 "type": "panel", 64 "id": "stat", 65 "name": "Stat", 66 "version": "" 67 }, 68 { 69 "type": "panel", 70 "id": "table", 71 "name": "Table", 72 "version": "" 73 }, 74 { 75 "type": "panel", 76 "id": "text", 77 "name": "Text", 78 "version": "" 79 }, 80 { 81 "type": "panel", 82 "id": "timeseries", 83 "name": "Time series", 84 "version": "" 85 } 86 ], 87 "annotations": { 88 "list": [ 89 { 90 "builtIn": 1, 91 "datasource": { 92 "type": "datasource", 93 "uid": "grafana" 94 }, 95 "enable": true, 96 "hide": true, 97 "iconColor": "rgba(0, 211, 255, 1)", 98 "name": "Annotations & Alerts", 99 "target": { 100 "limit": 100, 101 "matchAny": false, 102 "tags": [], 103 "type": "dashboard" 104 }, 105 "type": "dashboard" 106 } 107 ] 108 }, 109 "editable": true, 110 "fiscalYearStartMonth": 0, 111 "graphTooltip": 1, 112 "id": null, 113 "links": [ 114 { 115 "asDropdown": false, 116 "icon": "external link", 117 "includeVars": false, 118 "keepTime": false, 119 "tags": ["cloudnativepg"], 120 "targetBlank": false, 121 "title": "Related Dashboards", 122 "tooltip": "", 123 "type": "dashboards", 124 "url": "" 125 } 126 ], 127 "liveNow": false, 128 "panels": [ 129 { 130 "datasource": { 131 "type": "prometheus", 132 "uid": "${DS_PROMETHEUS}" 133 }, 134 "gridPos": { 135 "h": 7, 136 "w": 3, 137 "x": 0, 138 "y": 0 139 }, 140 "id": 676, 141 "options": { 142 "alertInstanceLabelFilter": "{namespace=~\"$namespace\",pod=~\"$instances\"}", 143 "alertName": "", 144 "dashboardAlerts": false, 145 "folder": "", 146 "groupBy": [], 147 "groupMode": "default", 148 "maxItems": 20, 149 "sortOrder": 1, 150 "stateFilter": { 151 "error": true, 152 "firing": true, 153 "noData": false, 154 "normal": true, 155 "pending": true 156 }, 157 "viewMode": "list" 158 }, 159 "title": "Alerts", 160 "type": "alertlist" 161 }, 162 { 163 "datasource": { 164 "type": "prometheus", 165 "uid": "${DS_PROMETHEUS}" 166 }, 167 "gridPos": { 168 "h": 1, 169 "w": 4, 170 "x": 3, 171 "y": 0 172 }, 173 "id": 586, 174 "options": { 175 "code": { 176 "language": "plaintext", 177 "showLineNumbers": false, 178 "showMiniMap": false 179 }, 180 "content": "", 181 "mode": "markdown" 182 }, 183 "pluginVersion": "10.3.3", 184 "title": "Health", 185 "type": "text" 186 }, 187 { 188 "datasource": { 189 "type": "prometheus", 190 "uid": "${DS_PROMETHEUS}" 191 }, 192 "gridPos": { 193 "h": 1, 194 "w": 12, 195 "x": 7, 196 "y": 0 197 }, 198 "id": 336, 199 "options": { 200 "code": { 201 "language": "plaintext", 202 "showLineNumbers": false, 203 "showMiniMap": false 204 }, 205 "content": "", 206 "mode": "markdown" 207 }, 208 "pluginVersion": "10.3.3", 209 "title": "Overview", 210 "type": "text" 211 }, 212 { 213 "datasource": { 214 "type": "prometheus", 215 "uid": "${DS_PROMETHEUS}" 216 }, 217 "gridPos": { 218 "h": 1, 219 "w": 2, 220 "x": 19, 221 "y": 0 222 }, 223 "id": 352, 224 "options": { 225 "code": { 226 "language": "plaintext", 227 "showLineNumbers": false, 228 "showMiniMap": false 229 }, 230 "content": "", 231 "mode": "markdown" 232 }, 233 "pluginVersion": "10.3.3", 234 "title": "Storage", 235 "type": "text" 236 }, 237 { 238 "datasource": { 239 "type": "prometheus", 240 "uid": "${DS_PROMETHEUS}" 241 }, 242 "gridPos": { 243 "h": 1, 244 "w": 3, 245 "x": 21, 246 "y": 0 247 }, 248 "id": 354, 249 "options": { 250 "code": { 251 "language": "plaintext", 252 "showLineNumbers": false, 253 "showMiniMap": false 254 }, 255 "content": "", 256 "mode": "markdown" 257 }, 258 "pluginVersion": "10.3.3", 259 "title": "Backups", 260 "type": "text" 261 }, 262 { 263 "datasource": { 264 "type": "prometheus", 265 "uid": "${DS_PROMETHEUS}" 266 }, 267 "description": "Cluster Replication Health represents the availability of replica servers available to replace the primary in case of a failure.", 268 "fieldConfig": { 269 "defaults": { 270 "color": { 271 "mode": "thresholds" 272 }, 273 "mappings": [ 274 { 275 "options": { 276 "0": { 277 "color": "green", 278 "index": 1, 279 "text": "Healthy" 280 }, 281 "-1": { 282 "color": "red", 283 "index": 0, 284 "text": "None" 285 } 286 }, 287 "type": "value" 288 }, 289 { 290 "options": { 291 "from": 2, 292 "result": { 293 "color": "orange", 294 "index": 2, 295 "text": "Degraded" 296 }, 297 "to": 999 298 }, 299 "type": "range" 300 } 301 ], 302 "thresholds": { 303 "mode": "absolute", 304 "steps": [ 305 { 306 "color": "green", 307 "value": null 308 } 309 ] 310 }, 311 "unitScale": true 312 }, 313 "overrides": [] 314 }, 315 "gridPos": { 316 "h": 2, 317 "w": 2, 318 "x": 3, 319 "y": 1 320 }, 321 "id": 585, 322 "options": { 323 "colorMode": "background", 324 "graphMode": "none", 325 "justifyMode": "auto", 326 "orientation": "auto", 327 "reduceOptions": { 328 "calcs": ["lastNotNull"], 329 "fields": "", 330 "values": false 331 }, 332 "showPercentChange": false, 333 "textMode": "auto", 334 "wideLayout": true 335 }, 336 "pluginVersion": "10.3.3", 337 "targets": [ 338 { 339 "datasource": { 340 "type": "prometheus", 341 "uid": "${DS_PROMETHEUS}" 342 }, 343 "editorMode": "code", 344 "expr": "(max(cnpg_pg_replication_streaming_replicas{namespace=~\"$namespace\", pod=~\"$instances\"}) - sum(cnpg_pg_replication_is_wal_receiver_up{namespace=~\"$namespace\", pod=~\"$instances\"})) + (clamp_max(max(cnpg_pg_replication_streaming_replicas{namespace=~\"$namespace\", pod=~\"$instances\"}), 1) - 1)", 345 "legendFormat": "Replication", 346 "range": true, 347 "refId": "A" 348 } 349 ], 350 "type": "stat" 351 }, 352 { 353 "datasource": { 354 "type": "prometheus", 355 "uid": "${DS_PROMETHEUS}" 356 }, 357 "description": "High lag indicates issue with replication. Network or storage interfaces may not have enough bandwidth to handle incoming traffic and replication at the same time.", 358 "fieldConfig": { 359 "defaults": { 360 "color": { 361 "mode": "thresholds" 362 }, 363 "mappings": [ 364 { 365 "options": { 366 "match": "null", 367 "result": { 368 "color": "text", 369 "index": 0, 370 "text": "No data" 371 } 372 }, 373 "type": "special" 374 }, 375 { 376 "options": { 377 "from": 0, 378 "result": { 379 "color": "green", 380 "index": 1, 381 "text": "Healthy" 382 }, 383 "to": 0.1 384 }, 385 "type": "range" 386 }, 387 { 388 "options": { 389 "from": 0.1, 390 "result": { 391 "color": "yellow", 392 "index": 2, 393 "text": "Sub-second" 394 }, 395 "to": 1 396 }, 397 "type": "range" 398 }, 399 { 400 "options": { 401 "from": 1, 402 "result": { 403 "color": "orange", 404 "index": 3, 405 "text": "Delayed" 406 }, 407 "to": 5 408 }, 409 "type": "range" 410 }, 411 { 412 "options": { 413 "from": 5, 414 "result": { 415 "color": "red", 416 "index": 4, 417 "text": "High" 418 }, 419 "to": 4294967295 420 }, 421 "type": "range" 422 } 423 ], 424 "thresholds": { 425 "mode": "absolute", 426 "steps": [ 427 { 428 "color": "green", 429 "value": null 430 } 431 ] 432 }, 433 "unitScale": true 434 }, 435 "overrides": [] 436 }, 437 "gridPos": { 438 "h": 2, 439 "w": 1, 440 "x": 5, 441 "y": 1 442 }, 443 "id": 590, 444 "options": { 445 "colorMode": "background", 446 "graphMode": "none", 447 "justifyMode": "auto", 448 "orientation": "auto", 449 "reduceOptions": { 450 "calcs": ["lastNotNull"], 451 "fields": "", 452 "values": false 453 }, 454 "showPercentChange": false, 455 "textMode": "value_and_name", 456 "wideLayout": true 457 }, 458 "pluginVersion": "10.3.3", 459 "targets": [ 460 { 461 "datasource": { 462 "type": "prometheus", 463 "uid": "${DS_PROMETHEUS}" 464 }, 465 "editorMode": "code", 466 "expr": "max(cnpg_pg_replication_lag{namespace=~\"$namespace\",pod=~\"$instances\"}) + max(cnpg_pg_stat_replication_write_lag_seconds{namespace=~\"$namespace\",pod=~\"$instances\"}) + max(cnpg_pg_stat_replication_flush_lag_seconds{namespace=~\"$namespace\",pod=~\"$instances\"}) + max(cnpg_pg_stat_replication_replay_lag_seconds{namespace=~\"$namespace\",pod=~\"$instances\"})", 467 "hide": false, 468 "instant": false, 469 "legendFormat": "Lag", 470 "range": true, 471 "refId": "LAG" 472 }, 473 { 474 "datasource": { 475 "type": "prometheus", 476 "uid": "${DS_PROMETHEUS}" 477 }, 478 "expr": "", 479 "hide": false, 480 "instant": false, 481 "range": true, 482 "refId": "A" 483 } 484 ], 485 "type": "stat" 486 }, 487 { 488 "datasource": { 489 "type": "prometheus", 490 "uid": "${DS_PROMETHEUS}" 491 }, 492 "description": "Low disk space or low inode count will result in data loss.", 493 "fieldConfig": { 494 "defaults": { 495 "color": { 496 "mode": "thresholds" 497 }, 498 "mappings": [ 499 { 500 "options": { 501 "match": "null", 502 "result": { 503 "color": "text", 504 "index": 0, 505 "text": "No data" 506 } 507 }, 508 "type": "special" 509 }, 510 { 511 "options": { 512 "from": 0, 513 "result": { 514 "color": "green", 515 "index": 1, 516 "text": "Healthy" 517 }, 518 "to": 0.8 519 }, 520 "type": "range" 521 }, 522 { 523 "options": { 524 "from": 0.8, 525 "result": { 526 "color": "orange", 527 "index": 2, 528 "text": "Warning" 529 }, 530 "to": 0.9 531 }, 532 "type": "range" 533 }, 534 { 535 "options": { 536 "from": 0.9, 537 "result": { 538 "color": "red", 539 "index": 3, 540 "text": "Critical" 541 }, 542 "to": 0.98 543 }, 544 "type": "range" 545 }, 546 { 547 "options": { 548 "from": 0.98, 549 "result": { 550 "color": "red", 551 "index": 4, 552 "text": "Data Loss" 553 }, 554 "to": 1 555 }, 556 "type": "range" 557 }, 558 { 559 "options": { 560 "from": 1, 561 "result": { 562 "color": "red", 563 "index": 5, 564 "text": "Full" 565 }, 566 "to": 4294967295 567 }, 568 "type": "range" 569 } 570 ], 571 "thresholds": { 572 "mode": "absolute", 573 "steps": [ 574 { 575 "color": "green", 576 "value": null 577 } 578 ] 579 }, 580 "unitScale": true 581 }, 582 "overrides": [] 583 }, 584 "gridPos": { 585 "h": 2, 586 "w": 1, 587 "x": 6, 588 "y": 1 589 }, 590 "id": 613, 591 "options": { 592 "colorMode": "background", 593 "graphMode": "none", 594 "justifyMode": "auto", 595 "orientation": "auto", 596 "reduceOptions": { 597 "calcs": ["lastNotNull"], 598 "fields": "", 599 "values": false 600 }, 601 "showPercentChange": false, 602 "textMode": "value_and_name", 603 "wideLayout": true 604 }, 605 "pluginVersion": "10.3.3", 606 "targets": [ 607 { 608 "datasource": { 609 "type": "prometheus", 610 "uid": "${DS_PROMETHEUS}" 611 }, 612 "editorMode": "code", 613 "expr": "max((max(max by(persistentvolumeclaim) (1 - kubelet_volume_stats_available_bytes{namespace=\"$namespace\", persistentvolumeclaim=~\"$instances\"} / kubelet_volume_stats_capacity_bytes{namespace=\"$namespace\", persistentvolumeclaim=~\"$instances\"}))) OR (max by(persistentvolumeclaim) (kubelet_volume_stats_inodes_used{namespace=\"$namespace\", persistentvolumeclaim=~\"$instances\"} / kubelet_volume_stats_inodes{namespace=\"$namespace\", persistentvolumeclaim=~\"$instances\"})))", 614 "hide": false, 615 "legendFormat": "Storage", 616 "range": true, 617 "refId": "STORAGE" 618 } 619 ], 620 "type": "stat" 621 }, 622 { 623 "datasource": { 624 "type": "prometheus", 625 "uid": "${DS_PROMETHEUS}" 626 }, 627 "description": "", 628 "fieldConfig": { 629 "defaults": { 630 "color": { 631 "mode": "thresholds" 632 }, 633 "mappings": [], 634 "thresholds": { 635 "mode": "absolute", 636 "steps": [ 637 { 638 "color": "dark-blue", 639 "value": null 640 } 641 ] 642 }, 643 "unit": "dateTimeFromNow", 644 "unitScale": true 645 }, 646 "overrides": [] 647 }, 648 "gridPos": { 649 "h": 3, 650 "w": 2, 651 "x": 7, 652 "y": 1 653 }, 654 "id": 338, 655 "options": { 656 "colorMode": "background", 657 "graphMode": "none", 658 "justifyMode": "auto", 659 "orientation": "horizontal", 660 "reduceOptions": { 661 "calcs": ["lastNotNull"], 662 "fields": "", 663 "values": false 664 }, 665 "showPercentChange": false, 666 "text": {}, 667 "textMode": "value", 668 "wideLayout": true 669 }, 670 "pluginVersion": "10.3.3", 671 "targets": [ 672 { 673 "datasource": { 674 "type": "prometheus", 675 "uid": "${DS_PROMETHEUS}" 676 }, 677 "editorMode": "code", 678 "exemplar": false, 679 "expr": "max(cnpg_pg_postmaster_start_time{namespace=~\"$namespace\",pod=~\"$instances\"})*1000", 680 "format": "time_series", 681 "hide": false, 682 "instant": true, 683 "interval": "", 684 "intervalFactor": 1, 685 "legendFormat": "", 686 "refId": "A" 687 } 688 ], 689 "title": "Last failover", 690 "transformations": [], 691 "type": "stat" 692 }, 693 { 694 "datasource": { 695 "type": "prometheus", 696 "uid": "${DS_PROMETHEUS}" 697 }, 698 "fieldConfig": { 699 "defaults": { 700 "color": { 701 "mode": "thresholds" 702 }, 703 "mappings": [], 704 "thresholds": { 705 "mode": "absolute", 706 "steps": [ 707 { 708 "color": "green", 709 "value": null 710 } 711 ] 712 }, 713 "unitScale": true 714 }, 715 "overrides": [] 716 }, 717 "gridPos": { 718 "h": 6, 719 "w": 2, 720 "x": 9, 721 "y": 1 722 }, 723 "id": 342, 724 "interval": "1m", 725 "options": { 726 "colorMode": "value", 727 "graphMode": "area", 728 "justifyMode": "auto", 729 "orientation": "auto", 730 "reduceOptions": { 731 "calcs": ["lastNotNull"], 732 "fields": "", 733 "values": false 734 }, 735 "showPercentChange": false, 736 "textMode": "auto", 737 "wideLayout": true 738 }, 739 "pluginVersion": "10.3.3", 740 "targets": [ 741 { 742 "datasource": { 743 "type": "prometheus", 744 "uid": "${DS_PROMETHEUS}" 745 }, 746 "editorMode": "code", 747 "exemplar": true, 748 "expr": "sum(rate(cnpg_pg_stat_database_xact_commit{namespace=~\"$namespace\",pod=~\"$instances\"}[$__interval])) + sum(rate(cnpg_pg_stat_database_xact_rollback{namespace=~\"$namespace\",pod=~\"$instances\"}[$__interval]))", 749 "interval": "", 750 "legendFormat": "TPS", 751 "range": true, 752 "refId": "TPS" 753 } 754 ], 755 "title": "TPS", 756 "type": "stat" 757 }, 758 { 759 "datasource": { 760 "type": "prometheus", 761 "uid": "${DS_PROMETHEUS}" 762 }, 763 "description": "CPU Utilisation from Requests", 764 "fieldConfig": { 765 "defaults": { 766 "color": { 767 "mode": "thresholds" 768 }, 769 "mappings": [ 770 { 771 "options": { 772 "match": "null", 773 "result": { 774 "color": "text", 775 "index": 0, 776 "text": "Missing request" 777 } 778 }, 779 "type": "special" 780 } 781 ], 782 "max": 1, 783 "min": 0, 784 "thresholds": { 785 "mode": "absolute", 786 "steps": [ 787 { 788 "color": "green", 789 "value": null 790 }, 791 { 792 "color": "orange", 793 "value": 0.8 794 }, 795 { 796 "color": "red", 797 "value": 0.9 798 } 799 ] 800 }, 801 "unit": "percentunit", 802 "unitScale": true 803 }, 804 "overrides": [] 805 }, 806 "gridPos": { 807 "h": 4, 808 "w": 2, 809 "x": 11, 810 "y": 1 811 }, 812 "id": 344, 813 "interval": "1m", 814 "links": [], 815 "options": { 816 "minVizHeight": 75, 817 "minVizWidth": 75, 818 "orientation": "horizontal", 819 "reduceOptions": { 820 "calcs": ["mean"], 821 "fields": "", 822 "values": false 823 }, 824 "showThresholdLabels": false, 825 "showThresholdMarkers": true, 826 "sizing": "auto" 827 }, 828 "pluginVersion": "10.3.3", 829 "targets": [ 830 { 831 "datasource": { 832 "type": "prometheus", 833 "uid": "${DS_PROMETHEUS}" 834 }, 835 "editorMode": "code", 836 "expr": "sum(node_namespace_pod_container:container_cpu_usage_seconds_total:sum_irate{namespace=\"$namespace\", pod=~\"$instances\"}) / sum(kube_pod_container_resource_requests{job=\"kube-state-metrics\", namespace=\"$namespace\", resource=\"cpu\", pod=~\"$instances\"})", 837 "format": "time_series", 838 "instant": true, 839 "intervalFactor": 2, 840 "refId": "A" 841 } 842 ], 843 "title": "CPU Utilisation", 844 "type": "gauge" 845 }, 846 { 847 "datasource": { 848 "type": "prometheus", 849 "uid": "${DS_PROMETHEUS}" 850 }, 851 "description": "Memory Utilisation from Requests", 852 "fieldConfig": { 853 "defaults": { 854 "color": { 855 "mode": "thresholds" 856 }, 857 "mappings": [ 858 { 859 "options": { 860 "match": "null", 861 "result": { 862 "color": "text", 863 "index": 0, 864 "text": "Missing request" 865 } 866 }, 867 "type": "special" 868 } 869 ], 870 "max": 1, 871 "min": 0, 872 "thresholds": { 873 "mode": "absolute", 874 "steps": [ 875 { 876 "color": "green", 877 "value": null 878 }, 879 { 880 "color": "orange", 881 "value": 0.8 882 }, 883 { 884 "color": "red", 885 "value": 0.9 886 } 887 ] 888 }, 889 "unit": "percentunit", 890 "unitScale": true 891 }, 892 "overrides": [] 893 }, 894 "gridPos": { 895 "h": 4, 896 "w": 2, 897 "x": 13, 898 "y": 1 899 }, 900 "id": 348, 901 "interval": "1m", 902 "links": [], 903 "options": { 904 "minVizHeight": 75, 905 "minVizWidth": 75, 906 "orientation": "horizontal", 907 "reduceOptions": { 908 "calcs": ["mean"], 909 "fields": "", 910 "values": false 911 }, 912 "showThresholdLabels": false, 913 "showThresholdMarkers": true, 914 "sizing": "auto" 915 }, 916 "pluginVersion": "10.3.3", 917 "targets": [ 918 { 919 "datasource": { 920 "type": "prometheus", 921 "uid": "${DS_PROMETHEUS}" 922 }, 923 "editorMode": "code", 924 "expr": "sum(container_memory_working_set_bytes{job=\"kubelet\", metrics_path=\"/metrics/cadvisor\", namespace=\"$namespace\",container!=\"\", image!=\"\", pod=~\"$instances\"}) / sum(max by(pod) (kube_pod_container_resource_requests{job=\"kube-state-metrics\", namespace=\"$namespace\", resource=\"memory\", pod=~\"$instances\"}))", 925 "format": "time_series", 926 "instant": true, 927 "intervalFactor": 2, 928 "refId": "A" 929 } 930 ], 931 "title": "Memory Utilisation", 932 "type": "gauge" 933 }, 934 { 935 "datasource": { 936 "type": "prometheus", 937 "uid": "${DS_PROMETHEUS}" 938 }, 939 "fieldConfig": { 940 "defaults": { 941 "color": { 942 "mode": "thresholds" 943 }, 944 "mappings": [], 945 "max": 30, 946 "min": 0, 947 "thresholds": { 948 "mode": "absolute", 949 "steps": [ 950 { 951 "color": "green", 952 "value": null 953 }, 954 { 955 "color": "yellow", 956 "value": 1 957 }, 958 { 959 "color": "orange", 960 "value": 10 961 }, 962 { 963 "color": "red", 964 "value": 20 965 } 966 ] 967 }, 968 "unit": "s", 969 "unitScale": true 970 }, 971 "overrides": [] 972 }, 973 "gridPos": { 974 "h": 3, 975 "w": 2, 976 "x": 15, 977 "y": 1 978 }, 979 "id": 465, 980 "options": { 981 "colorMode": "value", 982 "graphMode": "area", 983 "justifyMode": "auto", 984 "orientation": "auto", 985 "reduceOptions": { 986 "calcs": ["lastNotNull"], 987 "fields": "", 988 "values": false 989 }, 990 "showPercentChange": false, 991 "textMode": "auto", 992 "wideLayout": true 993 }, 994 "pluginVersion": "10.3.3", 995 "targets": [ 996 { 997 "datasource": { 998 "type": "prometheus", 999 "uid": "${DS_PROMETHEUS}" 1000 }, 1001 "editorMode": "code", 1002 "exemplar": false, 1003 "expr": "max(cnpg_pg_replication_lag{namespace=~\"$namespace\",pod=~\"$instances\"})", 1004 "instant": true, 1005 "legendFormat": "__auto", 1006 "range": false, 1007 "refId": "A" 1008 } 1009 ], 1010 "title": "Replication Lag", 1011 "type": "stat" 1012 }, 1013 { 1014 "datasource": { 1015 "type": "prometheus", 1016 "uid": "${DS_PROMETHEUS}" 1017 }, 1018 "fieldConfig": { 1019 "defaults": { 1020 "color": { 1021 "mode": "thresholds" 1022 }, 1023 "mappings": [], 1024 "thresholds": { 1025 "mode": "absolute", 1026 "steps": [ 1027 { 1028 "color": "green", 1029 "value": null 1030 }, 1031 { 1032 "color": "yellow", 1033 "value": 1 1034 }, 1035 { 1036 "color": "orange", 1037 "value": 10 1038 }, 1039 { 1040 "color": "red", 1041 "value": 20 1042 } 1043 ] 1044 }, 1045 "unit": "s", 1046 "unitScale": true 1047 }, 1048 "overrides": [] 1049 }, 1050 "gridPos": { 1051 "h": 3, 1052 "w": 2, 1053 "x": 17, 1054 "y": 1 1055 }, 1056 "id": 467, 1057 "options": { 1058 "colorMode": "value", 1059 "graphMode": "area", 1060 "justifyMode": "auto", 1061 "orientation": "auto", 1062 "reduceOptions": { 1063 "calcs": ["lastNotNull"], 1064 "fields": "", 1065 "values": false 1066 }, 1067 "showPercentChange": false, 1068 "textMode": "auto", 1069 "wideLayout": true 1070 }, 1071 "pluginVersion": "10.3.3", 1072 "targets": [ 1073 { 1074 "datasource": { 1075 "type": "prometheus", 1076 "uid": "${DS_PROMETHEUS}" 1077 }, 1078 "editorMode": "code", 1079 "expr": "max(cnpg_pg_stat_replication_write_lag_seconds{namespace=~\"$namespace\",pod=~\"$instances\"})", 1080 "legendFormat": "__auto", 1081 "range": true, 1082 "refId": "A" 1083 } 1084 ], 1085 "title": "Write Lag", 1086 "type": "stat" 1087 }, 1088 { 1089 "datasource": { 1090 "type": "prometheus", 1091 "uid": "${DS_PROMETHEUS}" 1092 }, 1093 "fieldConfig": { 1094 "defaults": { 1095 "color": { 1096 "mode": "thresholds" 1097 }, 1098 "mappings": [], 1099 "max": 1, 1100 "min": 0, 1101 "thresholds": { 1102 "mode": "absolute", 1103 "steps": [ 1104 { 1105 "color": "green", 1106 "value": null 1107 }, 1108 { 1109 "color": "orange", 1110 "value": 0.8 1111 }, 1112 { 1113 "color": "red", 1114 "value": 0.9 1115 } 1116 ] 1117 }, 1118 "unit": "percentunit", 1119 "unitScale": true 1120 }, 1121 "overrides": [] 1122 }, 1123 "gridPos": { 1124 "h": 4, 1125 "w": 2, 1126 "x": 19, 1127 "y": 1 1128 }, 1129 "id": 356, 1130 "options": { 1131 "minVizHeight": 75, 1132 "minVizWidth": 75, 1133 "orientation": "auto", 1134 "reduceOptions": { 1135 "calcs": ["lastNotNull"], 1136 "fields": "", 1137 "values": false 1138 }, 1139 "showThresholdLabels": false, 1140 "showThresholdMarkers": true, 1141 "sizing": "auto" 1142 }, 1143 "pluginVersion": "10.3.3", 1144 "targets": [ 1145 { 1146 "datasource": { 1147 "type": "prometheus", 1148 "uid": "${DS_PROMETHEUS}" 1149 }, 1150 "editorMode": "code", 1151 "exemplar": false, 1152 "expr": "max(max by(persistentvolumeclaim) (1 - kubelet_volume_stats_available_bytes{namespace=\"$namespace\", persistentvolumeclaim=~\"$instances\"} / kubelet_volume_stats_capacity_bytes{namespace=\"$namespace\", persistentvolumeclaim=~\"$instances\"}))", 1153 "format": "time_series", 1154 "instant": true, 1155 "interval": "", 1156 "legendFormat": "DATA", 1157 "range": false, 1158 "refId": "DATA" 1159 }, 1160 { 1161 "datasource": { 1162 "type": "prometheus", 1163 "uid": "${DS_PROMETHEUS}" 1164 }, 1165 "editorMode": "code", 1166 "exemplar": false, 1167 "expr": "max(max by(persistentvolumeclaim) (1 - kubelet_volume_stats_available_bytes{namespace=\"$namespace\", persistentvolumeclaim=~\"(${instances})-wal\"} / kubelet_volume_stats_capacity_bytes{namespace=\"$namespace\", persistentvolumeclaim=~\"(${instances})-wal\"}))", 1168 "format": "time_series", 1169 "instant": true, 1170 "interval": "", 1171 "legendFormat": "WAL", 1172 "range": false, 1173 "refId": "WAL" 1174 }, 1175 { 1176 "datasource": { 1177 "type": "prometheus", 1178 "uid": "${DS_PROMETHEUS}" 1179 }, 1180 "editorMode": "code", 1181 "exemplar": false, 1182 "expr": "max(\n sum by (namespace,persistentvolumeclaim) (kubelet_volume_stats_used_bytes{namespace=\"$namespace\", persistentvolumeclaim=~\"(${instances})-tbs.*\"}) \n /\n sum by (namespace,persistentvolumeclaim) (kubelet_volume_stats_capacity_bytes{namespace=\"$namespace\", persistentvolumeclaim=~\"(${instances})-tbs.*\"}) \n *\n on(namespace, persistentvolumeclaim) group_left(volume)\n kube_pod_spec_volumes_persistentvolumeclaims_info{pod=~\"$instances\"}\n)", 1183 "hide": false, 1184 "instant": true, 1185 "legendFormat": "Tablespaces (max)", 1186 "range": false, 1187 "refId": "Max Tablespace" 1188 } 1189 ], 1190 "title": "Volume Space Usage", 1191 "type": "gauge" 1192 }, 1193 { 1194 "datasource": { 1195 "type": "prometheus", 1196 "uid": "${DS_PROMETHEUS}" 1197 }, 1198 "description": "Elapsed time since the last successful base backup.", 1199 "fieldConfig": { 1200 "defaults": { 1201 "color": { 1202 "mode": "thresholds" 1203 }, 1204 "mappings": [], 1205 "thresholds": { 1206 "mode": "absolute", 1207 "steps": [ 1208 { 1209 "color": "green", 1210 "value": null 1211 } 1212 ] 1213 }, 1214 "unit": "dateTimeAsSystem", 1215 "unitScale": true 1216 }, 1217 "overrides": [] 1218 }, 1219 "gridPos": { 1220 "h": 2, 1221 "w": 3, 1222 "x": 21, 1223 "y": 1 1224 }, 1225 "id": 360, 1226 "options": { 1227 "colorMode": "value", 1228 "graphMode": "none", 1229 "justifyMode": "auto", 1230 "orientation": "auto", 1231 "reduceOptions": { 1232 "calcs": ["lastNotNull"], 1233 "fields": "", 1234 "values": false 1235 }, 1236 "showPercentChange": false, 1237 "textMode": "auto", 1238 "wideLayout": true 1239 }, 1240 "pluginVersion": "10.3.3", 1241 "targets": [ 1242 { 1243 "datasource": { 1244 "type": "prometheus", 1245 "uid": "${DS_PROMETHEUS}" 1246 }, 1247 "editorMode": "code", 1248 "exemplar": false, 1249 "expr": "max(kube_customresource_cnpg_backup_stopped_at{namespace=\"$namespace\"}) * 1000", 1250 "instant": true, 1251 "legendFormat": "__auto", 1252 "range": false, 1253 "refId": "A" 1254 } 1255 ], 1256 "title": "Last Base Backup", 1257 "type": "stat" 1258 }, 1259 { 1260 "datasource": { 1261 "type": "prometheus", 1262 "uid": "${DS_PROMETHEUS}" 1263 }, 1264 "description": "High resource usage (CPU, Memory, DB Connections)", 1265 "fieldConfig": { 1266 "defaults": { 1267 "color": { 1268 "mode": "thresholds" 1269 }, 1270 "mappings": [ 1271 { 1272 "options": { 1273 "match": "null", 1274 "result": { 1275 "color": "text", 1276 "index": 0, 1277 "text": "No data" 1278 } 1279 }, 1280 "type": "special" 1281 }, 1282 { 1283 "options": { 1284 "from": 0, 1285 "result": { 1286 "color": "green", 1287 "index": 1, 1288 "text": "Healthy" 1289 }, 1290 "to": 0.8 1291 }, 1292 "type": "range" 1293 }, 1294 { 1295 "options": { 1296 "from": 0.8, 1297 "result": { 1298 "color": "orange", 1299 "index": 2, 1300 "text": "Warning" 1301 }, 1302 "to": 0.9 1303 }, 1304 "type": "range" 1305 }, 1306 { 1307 "options": { 1308 "from": 0.9, 1309 "result": { 1310 "color": "red", 1311 "index": 3, 1312 "text": "Critical" 1313 }, 1314 "to": 0.98 1315 }, 1316 "type": "range" 1317 }, 1318 { 1319 "options": { 1320 "from": 0.98, 1321 "result": { 1322 "color": "red", 1323 "index": 4, 1324 "text": "Data Loss" 1325 }, 1326 "to": 999 1327 }, 1328 "type": "range" 1329 } 1330 ], 1331 "thresholds": { 1332 "mode": "absolute", 1333 "steps": [ 1334 { 1335 "color": "green", 1336 "value": null 1337 } 1338 ] 1339 }, 1340 "unitScale": true 1341 }, 1342 "overrides": [] 1343 }, 1344 "gridPos": { 1345 "h": 2, 1346 "w": 4, 1347 "x": 3, 1348 "y": 3 1349 }, 1350 "id": 591, 1351 "options": { 1352 "colorMode": "background", 1353 "graphMode": "none", 1354 "justifyMode": "auto", 1355 "orientation": "auto", 1356 "reduceOptions": { 1357 "calcs": ["lastNotNull"], 1358 "fields": "", 1359 "values": false 1360 }, 1361 "showPercentChange": false, 1362 "textMode": "value_and_name", 1363 "wideLayout": true 1364 }, 1365 "pluginVersion": "10.3.3", 1366 "targets": [ 1367 { 1368 "datasource": { 1369 "type": "prometheus", 1370 "uid": "${DS_PROMETHEUS}" 1371 }, 1372 "editorMode": "code", 1373 "expr": "(sum(node_namespace_pod_container:container_cpu_usage_seconds_total:sum_irate{ namespace=\"$namespace\", pod=~\"$instances\"}) / sum(kube_pod_container_resource_requests{job=\"kube-state-metrics\", namespace=\"$namespace\", resource=\"cpu\", pod=~\"$instances\"}))", 1374 "hide": false, 1375 "legendFormat": "CPU", 1376 "range": true, 1377 "refId": "CPU" 1378 }, 1379 { 1380 "datasource": { 1381 "type": "prometheus", 1382 "uid": "${DS_PROMETHEUS}" 1383 }, 1384 "editorMode": "code", 1385 "expr": "(sum(container_memory_working_set_bytes{job=\"kubelet\", metrics_path=\"/metrics/cadvisor\", namespace=\"$namespace\",container!=\"\", image!=\"\", pod=~\"$instances\"}) / sum(max by(pod) (kube_pod_container_resource_requests{job=\"kube-state-metrics\", namespace=\"$namespace\", resource=\"memory\", pod=~\"$instances\"})))", 1386 "hide": false, 1387 "instant": false, 1388 "legendFormat": "Memory", 1389 "range": true, 1390 "refId": "MEM" 1391 }, 1392 { 1393 "datasource": { 1394 "type": "prometheus", 1395 "uid": "${DS_PROMETHEUS}" 1396 }, 1397 "editorMode": "code", 1398 "expr": " (max(sum by (pod) (cnpg_backends_total{namespace=~\"$namespace\", pod=~\"$instances\"}) / sum by (pod) (cnpg_pg_settings_setting{name=\"max_connections\", namespace=~\"$namespace\", pod=~\"$instances\"})))", 1399 "hide": false, 1400 "instant": false, 1401 "legendFormat": "Connections", 1402 "range": true, 1403 "refId": "CONNS" 1404 } 1405 ], 1406 "type": "stat" 1407 }, 1408 { 1409 "datasource": { 1410 "type": "prometheus", 1411 "uid": "${DS_PROMETHEUS}" 1412 }, 1413 "description": "Computes the time since the last known WAL archival in the primary.\nWe ensure to ignore the metric in the replicas by using (1 - cnpg_pg_replication_in_recovery ) as a multiplicative factor. It will be 0 for replicas, 1 for the primary.", 1414 "fieldConfig": { 1415 "defaults": { 1416 "color": { 1417 "mode": "thresholds" 1418 }, 1419 "mappings": [ 1420 { 1421 "options": { 1422 "match": "null", 1423 "result": { 1424 "color": "red", 1425 "index": 0, 1426 "text": "No backups" 1427 } 1428 }, 1429 "type": "special" 1430 }, 1431 { 1432 "options": { 1433 "from": -1e22, 1434 "result": { 1435 "color": "text", 1436 "index": 1, 1437 "text": "No data" 1438 }, 1439 "to": 0 1440 }, 1441 "type": "range" 1442 } 1443 ], 1444 "thresholds": { 1445 "mode": "absolute", 1446 "steps": [ 1447 { 1448 "color": "green", 1449 "value": null 1450 } 1451 ] 1452 }, 1453 "unit": "dtdurations", 1454 "unitScale": true 1455 }, 1456 "overrides": [] 1457 }, 1458 "gridPos": { 1459 "h": 2, 1460 "w": 3, 1461 "x": 21, 1462 "y": 3 1463 }, 1464 "id": 362, 1465 "options": { 1466 "colorMode": "value", 1467 "graphMode": "none", 1468 "justifyMode": "auto", 1469 "orientation": "auto", 1470 "reduceOptions": { 1471 "calcs": ["lastNotNull"], 1472 "fields": "", 1473 "values": false 1474 }, 1475 "showPercentChange": false, 1476 "textMode": "auto", 1477 "wideLayout": true 1478 }, 1479 "pluginVersion": "10.3.3", 1480 "targets": [ 1481 { 1482 "datasource": { 1483 "type": "prometheus", 1484 "uid": "${DS_PROMETHEUS}" 1485 }, 1486 "editorMode": "code", 1487 "exemplar": false, 1488 "expr": "max((1 - cnpg_pg_replication_in_recovery{namespace=~\"$namespace\",pod=~\"$instances\"}) * (time() - timestamp(cnpg_pg_stat_archiver_seconds_since_last_archival{namespace=~\"$namespace\",pod=~\"$instances\"}) +\ncnpg_pg_stat_archiver_seconds_since_last_archival{namespace=~\"$namespace\",pod=~\"$instances\"}))", 1489 "format": "time_series", 1490 "instant": true, 1491 "interval": "", 1492 "legendFormat": "__auto", 1493 "range": false, 1494 "refId": "A" 1495 } 1496 ], 1497 "title": "Last archived WAL", 1498 "type": "stat" 1499 }, 1500 { 1501 "datasource": { 1502 "type": "prometheus", 1503 "uid": "${DS_PROMETHEUS}" 1504 }, 1505 "description": "", 1506 "fieldConfig": { 1507 "defaults": { 1508 "color": { 1509 "mode": "thresholds" 1510 }, 1511 "mappings": [], 1512 "thresholds": { 1513 "mode": "absolute", 1514 "steps": [ 1515 { 1516 "color": "dark-blue", 1517 "value": null 1518 } 1519 ] 1520 }, 1521 "unit": "string", 1522 "unitScale": true 1523 }, 1524 "overrides": [] 1525 }, 1526 "gridPos": { 1527 "h": 3, 1528 "w": 2, 1529 "x": 7, 1530 "y": 4 1531 }, 1532 "id": 340, 1533 "options": { 1534 "colorMode": "background", 1535 "graphMode": "none", 1536 "justifyMode": "auto", 1537 "orientation": "horizontal", 1538 "reduceOptions": { 1539 "calcs": ["lastNotNull"], 1540 "fields": "/^full$/", 1541 "values": false 1542 }, 1543 "showPercentChange": false, 1544 "text": {}, 1545 "textMode": "value", 1546 "wideLayout": true 1547 }, 1548 "pluginVersion": "10.3.3", 1549 "repeatDirection": "v", 1550 "targets": [ 1551 { 1552 "datasource": { 1553 "type": "prometheus", 1554 "uid": "${DS_PROMETHEUS}" 1555 }, 1556 "editorMode": "builder", 1557 "exemplar": false, 1558 "expr": "cnpg_collector_postgres_version{namespace=~\"$namespace\",pod=~\"$instances\"}", 1559 "format": "table", 1560 "hide": false, 1561 "instant": true, 1562 "interval": "", 1563 "intervalFactor": 1, 1564 "legendFormat": "{{pod}}", 1565 "range": false, 1566 "refId": "A" 1567 } 1568 ], 1569 "title": "Version", 1570 "transformations": [], 1571 "type": "stat" 1572 }, 1573 { 1574 "datasource": { 1575 "type": "prometheus", 1576 "uid": "${DS_PROMETHEUS}" 1577 }, 1578 "fieldConfig": { 1579 "defaults": { 1580 "color": { 1581 "mode": "thresholds" 1582 }, 1583 "mappings": [], 1584 "thresholds": { 1585 "mode": "absolute", 1586 "steps": [ 1587 { 1588 "color": "green", 1589 "value": null 1590 }, 1591 { 1592 "color": "yellow", 1593 "value": 1 1594 }, 1595 { 1596 "color": "orange", 1597 "value": 10 1598 }, 1599 { 1600 "color": "red", 1601 "value": 20 1602 } 1603 ] 1604 }, 1605 "unit": "s", 1606 "unitScale": true 1607 }, 1608 "overrides": [] 1609 }, 1610 "gridPos": { 1611 "h": 3, 1612 "w": 2, 1613 "x": 15, 1614 "y": 4 1615 }, 1616 "id": 466, 1617 "options": { 1618 "colorMode": "value", 1619 "graphMode": "area", 1620 "justifyMode": "auto", 1621 "orientation": "auto", 1622 "reduceOptions": { 1623 "calcs": ["lastNotNull"], 1624 "fields": "", 1625 "values": false 1626 }, 1627 "showPercentChange": false, 1628 "textMode": "auto", 1629 "wideLayout": true 1630 }, 1631 "pluginVersion": "10.3.3", 1632 "targets": [ 1633 { 1634 "datasource": { 1635 "type": "prometheus", 1636 "uid": "${DS_PROMETHEUS}" 1637 }, 1638 "editorMode": "code", 1639 "expr": "max(cnpg_pg_stat_replication_flush_lag_seconds{namespace=~\"$namespace\",pod=~\"$instances\"})", 1640 "legendFormat": "__auto", 1641 "range": true, 1642 "refId": "A" 1643 } 1644 ], 1645 "title": "Flush Lag", 1646 "type": "stat" 1647 }, 1648 { 1649 "datasource": { 1650 "type": "prometheus", 1651 "uid": "${DS_PROMETHEUS}" 1652 }, 1653 "fieldConfig": { 1654 "defaults": { 1655 "color": { 1656 "mode": "thresholds" 1657 }, 1658 "mappings": [], 1659 "thresholds": { 1660 "mode": "absolute", 1661 "steps": [ 1662 { 1663 "color": "green", 1664 "value": null 1665 }, 1666 { 1667 "color": "yellow", 1668 "value": 1 1669 }, 1670 { 1671 "color": "orange", 1672 "value": 10 1673 }, 1674 { 1675 "color": "red", 1676 "value": 20 1677 } 1678 ] 1679 }, 1680 "unit": "s", 1681 "unitScale": true 1682 }, 1683 "overrides": [] 1684 }, 1685 "gridPos": { 1686 "h": 3, 1687 "w": 2, 1688 "x": 17, 1689 "y": 4 1690 }, 1691 "id": 468, 1692 "options": { 1693 "colorMode": "value", 1694 "graphMode": "area", 1695 "justifyMode": "auto", 1696 "orientation": "auto", 1697 "reduceOptions": { 1698 "calcs": ["lastNotNull"], 1699 "fields": "", 1700 "values": false 1701 }, 1702 "showPercentChange": false, 1703 "textMode": "auto", 1704 "wideLayout": true 1705 }, 1706 "pluginVersion": "10.3.3", 1707 "targets": [ 1708 { 1709 "datasource": { 1710 "type": "prometheus", 1711 "uid": "${DS_PROMETHEUS}" 1712 }, 1713 "editorMode": "code", 1714 "expr": "max(cnpg_pg_stat_replication_replay_lag_seconds{namespace=~\"$namespace\",pod=~\"$instances\"})", 1715 "legendFormat": "__auto", 1716 "range": true, 1717 "refId": "A" 1718 } 1719 ], 1720 "title": "Replay Lag", 1721 "type": "stat" 1722 }, 1723 { 1724 "datasource": { 1725 "type": "prometheus", 1726 "uid": "${DS_PROMETHEUS}" 1727 }, 1728 "description": "Base Backups are considered healthy when there has been at least one base backup in the last 24 hours.", 1729 "fieldConfig": { 1730 "defaults": { 1731 "color": { 1732 "mode": "thresholds" 1733 }, 1734 "mappings": [ 1735 { 1736 "options": { 1737 "match": "null", 1738 "result": { 1739 "color": "orange", 1740 "index": 0, 1741 "text": "None" 1742 } 1743 }, 1744 "type": "special" 1745 }, 1746 { 1747 "options": { 1748 "from": 0, 1749 "result": { 1750 "color": "green", 1751 "index": 1, 1752 "text": "Healthy" 1753 }, 1754 "to": 90000 1755 }, 1756 "type": "range" 1757 }, 1758 { 1759 "options": { 1760 "from": 90000, 1761 "result": { 1762 "color": "orange", 1763 "index": 2, 1764 "text": "Degraded" 1765 }, 1766 "to": 108000 1767 }, 1768 "type": "range" 1769 }, 1770 { 1771 "options": { 1772 "from": 108000, 1773 "result": { 1774 "color": "red", 1775 "index": 3, 1776 "text": "None recent" 1777 }, 1778 "to": 4294967295 1779 }, 1780 "type": "range" 1781 } 1782 ], 1783 "thresholds": { 1784 "mode": "absolute", 1785 "steps": [ 1786 { 1787 "color": "green", 1788 "value": null 1789 } 1790 ] 1791 }, 1792 "unitScale": true 1793 }, 1794 "overrides": [ 1795 { 1796 "matcher": { 1797 "id": "byName", 1798 "options": "WAL" 1799 }, 1800 "properties": [ 1801 { 1802 "id": "mappings", 1803 "value": [ 1804 { 1805 "options": { 1806 "match": "null", 1807 "result": { 1808 "color": "orange", 1809 "index": 0, 1810 "text": "None" 1811 } 1812 }, 1813 "type": "special" 1814 }, 1815 { 1816 "options": { 1817 "from": 0, 1818 "result": { 1819 "color": "green", 1820 "index": 1, 1821 "text": "Healthy" 1822 }, 1823 "to": 360 1824 }, 1825 "type": "range" 1826 }, 1827 { 1828 "options": { 1829 "from": 360, 1830 "result": { 1831 "color": "orange", 1832 "index": 2, 1833 "text": "Delayed" 1834 }, 1835 "to": 900 1836 }, 1837 "type": "range" 1838 }, 1839 { 1840 "options": { 1841 "from": 900, 1842 "result": { 1843 "color": "red", 1844 "index": 3, 1845 "text": "Unsynced" 1846 }, 1847 "to": 4294967295 1848 }, 1849 "type": "range" 1850 } 1851 ] 1852 } 1853 ] 1854 } 1855 ] 1856 }, 1857 "gridPos": { 1858 "h": 2, 1859 "w": 1, 1860 "x": 3, 1861 "y": 5 1862 }, 1863 "id": 588, 1864 "options": { 1865 "colorMode": "background", 1866 "graphMode": "none", 1867 "justifyMode": "auto", 1868 "orientation": "auto", 1869 "reduceOptions": { 1870 "calcs": ["lastNotNull"], 1871 "fields": "", 1872 "values": false 1873 }, 1874 "showPercentChange": false, 1875 "textMode": "value_and_name", 1876 "wideLayout": true 1877 }, 1878 "pluginVersion": "10.3.3", 1879 "targets": [ 1880 { 1881 "datasource": { 1882 "type": "prometheus", 1883 "uid": "${DS_PROMETHEUS}" 1884 }, 1885 "editorMode": "code", 1886 "expr": "time() - max(kube_customresource_cnpg_backup_stopped_at{namespace=\"$namespace\"})", 1887 "legendFormat": "Backups", 1888 "range": true, 1889 "refId": "BACKUPS" 1890 } 1891 ], 1892 "type": "stat" 1893 }, 1894 { 1895 "datasource": { 1896 "type": "prometheus", 1897 "uid": "${DS_PROMETHEUS}" 1898 }, 1899 "description": "WAL is considered Healthy when the last WAL is 0min to 6min old, Delayed when it is less than 15min and Unsynced for >15min.", 1900 "fieldConfig": { 1901 "defaults": { 1902 "color": { 1903 "mode": "thresholds" 1904 }, 1905 "mappings": [ 1906 { 1907 "options": { 1908 "match": "null", 1909 "result": { 1910 "color": "orange", 1911 "index": 0, 1912 "text": "None" 1913 } 1914 }, 1915 "type": "special" 1916 }, 1917 { 1918 "options": { 1919 "from": 0, 1920 "result": { 1921 "color": "green", 1922 "index": 1, 1923 "text": "Healthy" 1924 }, 1925 "to": 360 1926 }, 1927 "type": "range" 1928 }, 1929 { 1930 "options": { 1931 "from": 360, 1932 "result": { 1933 "color": "orange", 1934 "index": 2, 1935 "text": "Delayed" 1936 }, 1937 "to": 900 1938 }, 1939 "type": "range" 1940 }, 1941 { 1942 "options": { 1943 "from": 900, 1944 "result": { 1945 "color": "red", 1946 "index": 3, 1947 "text": "Unsynced" 1948 }, 1949 "to": 4294967295 1950 }, 1951 "type": "range" 1952 } 1953 ], 1954 "thresholds": { 1955 "mode": "absolute", 1956 "steps": [ 1957 { 1958 "color": "green", 1959 "value": null 1960 } 1961 ] 1962 }, 1963 "unitScale": true 1964 }, 1965 "overrides": [ 1966 { 1967 "matcher": { 1968 "id": "byName", 1969 "options": "WAL" 1970 }, 1971 "properties": [ 1972 { 1973 "id": "mappings", 1974 "value": [ 1975 { 1976 "options": { 1977 "match": "null", 1978 "result": { 1979 "color": "orange", 1980 "index": 0, 1981 "text": "None" 1982 } 1983 }, 1984 "type": "special" 1985 }, 1986 { 1987 "options": { 1988 "from": 0, 1989 "result": { 1990 "color": "green", 1991 "index": 1, 1992 "text": "Healthy" 1993 }, 1994 "to": 360 1995 }, 1996 "type": "range" 1997 }, 1998 { 1999 "options": { 2000 "from": 360, 2001 "result": { 2002 "color": "orange", 2003 "index": 2, 2004 "text": "Delayed" 2005 }, 2006 "to": 900 2007 }, 2008 "type": "range" 2009 }, 2010 { 2011 "options": { 2012 "from": 900, 2013 "result": { 2014 "color": "red", 2015 "index": 3, 2016 "text": "Unsynced" 2017 }, 2018 "to": 4294967295 2019 }, 2020 "type": "range" 2021 } 2022 ] 2023 } 2024 ] 2025 } 2026 ] 2027 }, 2028 "gridPos": { 2029 "h": 2, 2030 "w": 1, 2031 "x": 4, 2032 "y": 5 2033 }, 2034 "id": 612, 2035 "options": { 2036 "colorMode": "background", 2037 "graphMode": "none", 2038 "justifyMode": "auto", 2039 "orientation": "auto", 2040 "reduceOptions": { 2041 "calcs": ["lastNotNull"], 2042 "fields": "", 2043 "values": false 2044 }, 2045 "showPercentChange": false, 2046 "textMode": "value_and_name", 2047 "wideLayout": true 2048 }, 2049 "pluginVersion": "10.3.3", 2050 "targets": [ 2051 { 2052 "datasource": { 2053 "type": "prometheus", 2054 "uid": "${DS_PROMETHEUS}" 2055 }, 2056 "editorMode": "code", 2057 "expr": "max((1 - cnpg_pg_replication_in_recovery{namespace=~\"$namespace\", pod=~\"$instances\"}) * (time() - timestamp(cnpg_pg_stat_archiver_seconds_since_last_archival{namespace=~\"$namespace\", pod=~\"$instances\"}) +\ncnpg_pg_stat_archiver_seconds_since_last_archival{namespace=~\"$namespace\", pod=~\"$instances\"}))", 2058 "hide": false, 2059 "instant": false, 2060 "legendFormat": "WAL", 2061 "range": true, 2062 "refId": "WAL" 2063 } 2064 ], 2065 "type": "stat" 2066 }, 2067 { 2068 "datasource": { 2069 "type": "prometheus", 2070 "uid": "${DS_PROMETHEUS}" 2071 }, 2072 "description": "Online if there is at least one ready operator pod", 2073 "fieldConfig": { 2074 "defaults": { 2075 "color": { 2076 "mode": "thresholds" 2077 }, 2078 "mappings": [ 2079 { 2080 "options": { 2081 "0": { 2082 "color": "red", 2083 "index": 0, 2084 "text": "Failure" 2085 } 2086 }, 2087 "type": "value" 2088 }, 2089 { 2090 "options": { 2091 "from": 1, 2092 "result": { 2093 "color": "green", 2094 "index": 1, 2095 "text": "Online" 2096 }, 2097 "to": 99 2098 }, 2099 "type": "range" 2100 } 2101 ], 2102 "thresholds": { 2103 "mode": "absolute", 2104 "steps": [ 2105 { 2106 "color": "green", 2107 "value": null 2108 } 2109 ] 2110 }, 2111 "unitScale": true 2112 }, 2113 "overrides": [ 2114 { 2115 "matcher": { 2116 "id": "byName", 2117 "options": "A" 2118 }, 2119 "properties": [ 2120 { 2121 "id": "displayName", 2122 "value": "Reconcile errors" 2123 } 2124 ] 2125 } 2126 ] 2127 }, 2128 "gridPos": { 2129 "h": 2, 2130 "w": 1, 2131 "x": 5, 2132 "y": 5 2133 }, 2134 "id": 589, 2135 "options": { 2136 "colorMode": "background", 2137 "graphMode": "none", 2138 "justifyMode": "auto", 2139 "orientation": "auto", 2140 "reduceOptions": { 2141 "calcs": ["lastNotNull"], 2142 "fields": "", 2143 "values": false 2144 }, 2145 "showPercentChange": false, 2146 "textMode": "value_and_name", 2147 "wideLayout": true 2148 }, 2149 "pluginVersion": "10.3.3", 2150 "targets": [ 2151 { 2152 "datasource": { 2153 "type": "prometheus", 2154 "uid": "${DS_PROMETHEUS}" 2155 }, 2156 "editorMode": "code", 2157 "expr": "sum(kube_pod_status_ready{namespace=\"$operatorNamespace\", pod=~\"cloudnative-pg.+|cnpg-controller-manager.+\", condition=\"true\"})", 2158 "hide": false, 2159 "instant": true, 2160 "legendFormat": "Operator Status", 2161 "range": false, 2162 "refId": "A" 2163 } 2164 ], 2165 "type": "stat" 2166 }, 2167 { 2168 "datasource": { 2169 "type": "prometheus", 2170 "uid": "${DS_PROMETHEUS}" 2171 }, 2172 "description": "The operator reconcile errors don't distinguish between database cluster or namespaces.", 2173 "fieldConfig": { 2174 "defaults": { 2175 "color": { 2176 "mode": "thresholds" 2177 }, 2178 "mappings": [ 2179 { 2180 "options": { 2181 "0": { 2182 "color": "green", 2183 "index": 0, 2184 "text": "None" 2185 } 2186 }, 2187 "type": "value" 2188 }, 2189 { 2190 "options": { 2191 "from": 1, 2192 "result": { 2193 "color": "red", 2194 "index": 1, 2195 "text": "Backup" 2196 }, 2197 "to": 9 2198 }, 2199 "type": "range" 2200 }, 2201 { 2202 "options": { 2203 "from": 10, 2204 "result": { 2205 "color": "red", 2206 "index": 2, 2207 "text": "Cluster" 2208 }, 2209 "to": 99 2210 }, 2211 "type": "range" 2212 }, 2213 { 2214 "options": { 2215 "from": 100, 2216 "result": { 2217 "color": "red", 2218 "index": 3, 2219 "text": "Pooler" 2220 }, 2221 "to": 999 2222 }, 2223 "type": "range" 2224 }, 2225 { 2226 "options": { 2227 "from": 1000, 2228 "result": { 2229 "color": "red", 2230 "index": 4, 2231 "text": "Scheduled Backup" 2232 }, 2233 "to": 9999 2234 }, 2235 "type": "range" 2236 } 2237 ], 2238 "thresholds": { 2239 "mode": "absolute", 2240 "steps": [ 2241 { 2242 "color": "green", 2243 "value": null 2244 } 2245 ] 2246 }, 2247 "unitScale": true 2248 }, 2249 "overrides": [ 2250 { 2251 "matcher": { 2252 "id": "byName", 2253 "options": "A" 2254 }, 2255 "properties": [ 2256 { 2257 "id": "displayName", 2258 "value": "Reconcile errors" 2259 } 2260 ] 2261 } 2262 ] 2263 }, 2264 "gridPos": { 2265 "h": 2, 2266 "w": 1, 2267 "x": 6, 2268 "y": 5 2269 }, 2270 "id": 655, 2271 "options": { 2272 "colorMode": "background", 2273 "graphMode": "none", 2274 "justifyMode": "auto", 2275 "orientation": "auto", 2276 "reduceOptions": { 2277 "calcs": ["lastNotNull"], 2278 "fields": "", 2279 "values": false 2280 }, 2281 "showPercentChange": false, 2282 "textMode": "value_and_name", 2283 "wideLayout": true 2284 }, 2285 "pluginVersion": "10.3.3", 2286 "targets": [ 2287 { 2288 "datasource": { 2289 "type": "prometheus", 2290 "uid": "${DS_PROMETHEUS}" 2291 }, 2292 "editorMode": "code", 2293 "expr": "clamp_max(max(controller_runtime_reconcile_total{namespace=~\"$operatorNamespace\", result=\"error\", controller=\"backup\"}), 1)", 2294 "hide": true, 2295 "legendFormat": "__auto", 2296 "range": true, 2297 "refId": "RECONCILE_ERRORS_BACKUP" 2298 }, 2299 { 2300 "datasource": { 2301 "type": "prometheus", 2302 "uid": "${DS_PROMETHEUS}" 2303 }, 2304 "editorMode": "code", 2305 "expr": "clamp_max(max(controller_runtime_reconcile_total{namespace=~\"$operatorNamespace\", result=\"error\", controller=\"cluster\"}), 1)", 2306 "hide": true, 2307 "legendFormat": "__auto", 2308 "range": true, 2309 "refId": "RECONCILE_ERRORS_CLUSTER" 2310 }, 2311 { 2312 "datasource": { 2313 "type": "prometheus", 2314 "uid": "${DS_PROMETHEUS}" 2315 }, 2316 "editorMode": "code", 2317 "expr": "clamp_max(max(controller_runtime_reconcile_total{namespace=~\"$operatorNamespace\", result=\"error\", controller=\"pooler\"}), 1)", 2318 "hide": true, 2319 "legendFormat": "__auto", 2320 "range": true, 2321 "refId": "RECONCILE_ERRORS_POOLER" 2322 }, 2323 { 2324 "datasource": { 2325 "type": "prometheus", 2326 "uid": "${DS_PROMETHEUS}" 2327 }, 2328 "editorMode": "code", 2329 "expr": "clamp_max(max(controller_runtime_reconcile_total{namespace=~\"$operatorNamespace\", result=\"error\", controller=~\"scheduledbackup|scheduled-backup\"}), 1)", 2330 "hide": true, 2331 "legendFormat": "__auto", 2332 "range": true, 2333 "refId": "RECONCILE_ERRORS_SCHEDULED_BACKUP" 2334 }, 2335 { 2336 "datasource": { 2337 "type": "__expr__", 2338 "uid": "${DS_EXPRESSION}" 2339 }, 2340 "expression": "$RECONCILE_ERRORS_BACKUP + $RECONCILE_ERRORS_CLUSTER * 10 + $RECONCILE_ERRORS_POOLER * 100 + $RECONCILE_ERRORS_SCHEDULED_BACKUP * 1000", 2341 "hide": false, 2342 "refId": "A", 2343 "type": "math" 2344 } 2345 ], 2346 "type": "stat" 2347 }, 2348 { 2349 "datasource": { 2350 "type": "prometheus", 2351 "uid": "${DS_PROMETHEUS}" 2352 }, 2353 "description": "", 2354 "fieldConfig": { 2355 "defaults": { 2356 "color": { 2357 "mode": "thresholds" 2358 }, 2359 "decimals": 2, 2360 "mappings": [], 2361 "thresholds": { 2362 "mode": "absolute", 2363 "steps": [ 2364 { 2365 "color": "green", 2366 "value": null 2367 }, 2368 { 2369 "color": "#EAB839", 2370 "value": 80000000000 2371 }, 2372 { 2373 "color": "red", 2374 "value": 90000000000 2375 } 2376 ] 2377 }, 2378 "unit": "none", 2379 "unitScale": true 2380 }, 2381 "overrides": [] 2382 }, 2383 "gridPos": { 2384 "h": 2, 2385 "w": 2, 2386 "x": 11, 2387 "y": 5 2388 }, 2389 "id": 346, 2390 "links": [], 2391 "options": { 2392 "colorMode": "value", 2393 "graphMode": "area", 2394 "justifyMode": "center", 2395 "orientation": "horizontal", 2396 "reduceOptions": { 2397 "calcs": ["lastNotNull"], 2398 "fields": "", 2399 "values": false 2400 }, 2401 "showPercentChange": false, 2402 "textMode": "auto", 2403 "wideLayout": true 2404 }, 2405 "pluginVersion": "10.3.3", 2406 "targets": [ 2407 { 2408 "datasource": { 2409 "type": "prometheus", 2410 "uid": "${DS_PROMETHEUS}" 2411 }, 2412 "editorMode": "code", 2413 "exemplar": true, 2414 "expr": "sum(node_namespace_pod_container:container_cpu_usage_seconds_total:sum_irate{namespace=\"$namespace\", pod=~\"$instances\"})", 2415 "hide": false, 2416 "interval": "", 2417 "legendFormat": "Total", 2418 "range": true, 2419 "refId": "B" 2420 } 2421 ], 2422 "type": "stat" 2423 }, 2424 { 2425 "datasource": { 2426 "type": "prometheus", 2427 "uid": "${DS_PROMETHEUS}" 2428 }, 2429 "description": "Container memory working set", 2430 "fieldConfig": { 2431 "defaults": { 2432 "color": { 2433 "mode": "thresholds" 2434 }, 2435 "mappings": [], 2436 "thresholds": { 2437 "mode": "absolute", 2438 "steps": [ 2439 { 2440 "color": "green", 2441 "value": null 2442 }, 2443 { 2444 "color": "#EAB839", 2445 "value": 80000000000 2446 }, 2447 { 2448 "color": "red", 2449 "value": 90000000000 2450 } 2451 ] 2452 }, 2453 "unit": "bytes", 2454 "unitScale": true 2455 }, 2456 "overrides": [] 2457 }, 2458 "gridPos": { 2459 "h": 2, 2460 "w": 2, 2461 "x": 13, 2462 "y": 5 2463 }, 2464 "id": 350, 2465 "links": [], 2466 "options": { 2467 "colorMode": "value", 2468 "graphMode": "area", 2469 "justifyMode": "center", 2470 "orientation": "horizontal", 2471 "reduceOptions": { 2472 "calcs": ["lastNotNull"], 2473 "fields": "", 2474 "values": false 2475 }, 2476 "showPercentChange": false, 2477 "textMode": "auto", 2478 "wideLayout": true 2479 }, 2480 "pluginVersion": "10.3.3", 2481 "targets": [ 2482 { 2483 "datasource": { 2484 "type": "prometheus", 2485 "uid": "${DS_PROMETHEUS}" 2486 }, 2487 "editorMode": "code", 2488 "exemplar": true, 2489 "expr": "sum(container_memory_working_set_bytes{pod=~\"$instances\", namespace=\"$namespace\", container!=\"\", image!=\"\"})", 2490 "hide": false, 2491 "interval": "", 2492 "legendFormat": "Total", 2493 "range": true, 2494 "refId": "B" 2495 } 2496 ], 2497 "type": "stat" 2498 }, 2499 { 2500 "datasource": { 2501 "type": "prometheus", 2502 "uid": "${DS_PROMETHEUS}" 2503 }, 2504 "description": "", 2505 "fieldConfig": { 2506 "defaults": { 2507 "color": { 2508 "mode": "thresholds" 2509 }, 2510 "decimals": 2, 2511 "mappings": [], 2512 "thresholds": { 2513 "mode": "absolute", 2514 "steps": [ 2515 { 2516 "color": "green", 2517 "value": null 2518 }, 2519 { 2520 "color": "#EAB839", 2521 "value": 60000000000 2522 }, 2523 { 2524 "color": "red", 2525 "value": 80000000000 2526 } 2527 ] 2528 }, 2529 "unit": "decbytes", 2530 "unitScale": true 2531 }, 2532 "overrides": [] 2533 }, 2534 "gridPos": { 2535 "h": 2, 2536 "w": 2, 2537 "x": 19, 2538 "y": 5 2539 }, 2540 "id": 358, 2541 "links": [], 2542 "options": { 2543 "colorMode": "value", 2544 "graphMode": "none", 2545 "justifyMode": "auto", 2546 "orientation": "auto", 2547 "reduceOptions": { 2548 "calcs": ["sum"], 2549 "fields": "", 2550 "values": false 2551 }, 2552 "showPercentChange": false, 2553 "textMode": "value", 2554 "wideLayout": true 2555 }, 2556 "pluginVersion": "10.3.3", 2557 "targets": [ 2558 { 2559 "datasource": { 2560 "type": "prometheus", 2561 "uid": "${DS_PROMETHEUS}" 2562 }, 2563 "editorMode": "code", 2564 "exemplar": false, 2565 "expr": "cnpg_pg_database_size_bytes{namespace=\"$namespace\", pod=~\"$instances\"}", 2566 "format": "table", 2567 "instant": false, 2568 "legendFormat": "__auto", 2569 "range": true, 2570 "refId": "A" 2571 } 2572 ], 2573 "title": "Database Size", 2574 "transformations": [ 2575 { 2576 "id": "groupBy", 2577 "options": { 2578 "fields": { 2579 "Value": { 2580 "aggregations": ["max"], 2581 "operation": "aggregate" 2582 }, 2583 "datname": { 2584 "aggregations": [], 2585 "operation": "groupby" 2586 } 2587 } 2588 } 2589 } 2590 ], 2591 "type": "stat" 2592 }, 2593 { 2594 "datasource": { 2595 "type": "prometheus", 2596 "uid": "${DS_PROMETHEUS}" 2597 }, 2598 "fieldConfig": { 2599 "defaults": { 2600 "color": { 2601 "mode": "thresholds" 2602 }, 2603 "mappings": [ 2604 { 2605 "options": { 2606 "0": { 2607 "color": "red", 2608 "index": 1, 2609 "text": "N/A" 2610 } 2611 }, 2612 "type": "value" 2613 }, 2614 { 2615 "options": { 2616 "match": "null", 2617 "result": { 2618 "color": "red", 2619 "index": 0, 2620 "text": "No backups" 2621 } 2622 }, 2623 "type": "special" 2624 } 2625 ], 2626 "thresholds": { 2627 "mode": "absolute", 2628 "steps": [ 2629 { 2630 "color": "green", 2631 "value": null 2632 } 2633 ] 2634 }, 2635 "unit": "dateTimeAsIso", 2636 "unitScale": true 2637 }, 2638 "overrides": [] 2639 }, 2640 "gridPos": { 2641 "h": 2, 2642 "w": 3, 2643 "x": 21, 2644 "y": 5 2645 }, 2646 "id": 364, 2647 "options": { 2648 "colorMode": "value", 2649 "graphMode": "none", 2650 "justifyMode": "auto", 2651 "orientation": "auto", 2652 "reduceOptions": { 2653 "calcs": ["lastNotNull"], 2654 "fields": "", 2655 "values": false 2656 }, 2657 "showPercentChange": false, 2658 "textMode": "auto", 2659 "wideLayout": true 2660 }, 2661 "pluginVersion": "10.3.3", 2662 "targets": [ 2663 { 2664 "datasource": { 2665 "type": "prometheus", 2666 "uid": "${DS_PROMETHEUS}" 2667 }, 2668 "editorMode": "code", 2669 "exemplar": false, 2670 "expr": "min(kube_customresource_cnpg_backup_stopped_at{namespace=\"$namespace\"}) * 1000", 2671 "format": "time_series", 2672 "instant": true, 2673 "interval": "", 2674 "legendFormat": "{{pod}}", 2675 "range": false, 2676 "refId": "A" 2677 } 2678 ], 2679 "title": "First Recoverability Point", 2680 "type": "stat" 2681 }, 2682 { 2683 "collapsed": false, 2684 "datasource": { 2685 "uid": "prometheus" 2686 }, 2687 "gridPos": { 2688 "h": 1, 2689 "w": 24, 2690 "x": 0, 2691 "y": 7 2692 }, 2693 "id": 12, 2694 "panels": [], 2695 "targets": [ 2696 { 2697 "datasource": { 2698 "uid": "prometheus" 2699 }, 2700 "refId": "A" 2701 } 2702 ], 2703 "title": "Server Health", 2704 "type": "row" 2705 }, 2706 { 2707 "datasource": { 2708 "type": "prometheus", 2709 "uid": "${DS_PROMETHEUS}" 2710 }, 2711 "gridPos": { 2712 "h": 1, 2713 "w": 3, 2714 "x": 0, 2715 "y": 8 2716 }, 2717 "id": 191, 2718 "options": { 2719 "code": { 2720 "language": "plaintext", 2721 "showLineNumbers": false, 2722 "showMiniMap": false 2723 }, 2724 "content": "", 2725 "mode": "html" 2726 }, 2727 "pluginVersion": "10.3.3", 2728 "repeatDirection": "v", 2729 "targets": [ 2730 { 2731 "datasource": { 2732 "type": "prometheus", 2733 "uid": "${DS_PROMETHEUS}" 2734 }, 2735 "exemplar": true, 2736 "expr": "kube_pod_container_status_ready{container=\"postgres\",namespace=~\"$namespace\",pod=~\"$instances\"}", 2737 "instant": true, 2738 "interval": "", 2739 "legendFormat": "{{pod}}", 2740 "refId": "A" 2741 } 2742 ], 2743 "title": "Instance", 2744 "transparent": true, 2745 "type": "text" 2746 }, 2747 { 2748 "datasource": { 2749 "type": "prometheus", 2750 "uid": "${DS_PROMETHEUS}" 2751 }, 2752 "gridPos": { 2753 "h": 1, 2754 "w": 2, 2755 "x": 3, 2756 "y": 8 2757 }, 2758 "id": 192, 2759 "options": { 2760 "code": { 2761 "language": "plaintext", 2762 "showLineNumbers": false, 2763 "showMiniMap": false 2764 }, 2765 "content": "", 2766 "mode": "html" 2767 }, 2768 "pluginVersion": "10.3.3", 2769 "repeatDirection": "v", 2770 "targets": [ 2771 { 2772 "datasource": { 2773 "type": "prometheus", 2774 "uid": "${DS_PROMETHEUS}" 2775 }, 2776 "exemplar": true, 2777 "expr": "kube_pod_container_status_ready{container=\"postgres\",namespace=~\"$namespace\",pod=~\"$instances\"}", 2778 "instant": true, 2779 "interval": "", 2780 "legendFormat": "{{pod}}", 2781 "refId": "A" 2782 } 2783 ], 2784 "title": "Status", 2785 "type": "text" 2786 }, 2787 { 2788 "datasource": { 2789 "type": "prometheus", 2790 "uid": "${DS_PROMETHEUS}" 2791 }, 2792 "gridPos": { 2793 "h": 1, 2794 "w": 3, 2795 "x": 5, 2796 "y": 8 2797 }, 2798 "id": 193, 2799 "options": { 2800 "code": { 2801 "language": "plaintext", 2802 "showLineNumbers": false, 2803 "showMiniMap": false 2804 }, 2805 "content": "", 2806 "mode": "html" 2807 }, 2808 "pluginVersion": "10.3.3", 2809 "repeatDirection": "v", 2810 "targets": [ 2811 { 2812 "datasource": { 2813 "type": "prometheus", 2814 "uid": "${DS_PROMETHEUS}" 2815 }, 2816 "exemplar": true, 2817 "expr": "kube_pod_container_status_ready{container=\"postgres\",namespace=~\"$namespace\",pod=~\"$instances\"}", 2818 "instant": true, 2819 "interval": "", 2820 "legendFormat": "{{pod}}", 2821 "refId": "A" 2822 } 2823 ], 2824 "title": "Clustering / replicas", 2825 "type": "text" 2826 }, 2827 { 2828 "datasource": { 2829 "type": "prometheus", 2830 "uid": "${DS_PROMETHEUS}" 2831 }, 2832 "gridPos": { 2833 "h": 1, 2834 "w": 2, 2835 "x": 8, 2836 "y": 8 2837 }, 2838 "id": 384, 2839 "options": { 2840 "code": { 2841 "language": "plaintext", 2842 "showLineNumbers": false, 2843 "showMiniMap": false 2844 }, 2845 "content": "", 2846 "mode": "html" 2847 }, 2848 "pluginVersion": "10.3.3", 2849 "repeatDirection": "v", 2850 "targets": [ 2851 { 2852 "datasource": { 2853 "type": "prometheus", 2854 "uid": "${DS_PROMETHEUS}" 2855 }, 2856 "exemplar": true, 2857 "expr": "kube_pod_container_status_ready{container=\"postgres\",namespace=~\"$namespace\",pod=~\"$instances\"}", 2858 "instant": true, 2859 "interval": "", 2860 "legendFormat": "{{pod}}", 2861 "refId": "A" 2862 } 2863 ], 2864 "title": "Zone", 2865 "type": "text" 2866 }, 2867 { 2868 "datasource": { 2869 "type": "prometheus", 2870 "uid": "${DS_PROMETHEUS}" 2871 }, 2872 "gridPos": { 2873 "h": 1, 2874 "w": 4, 2875 "x": 10, 2876 "y": 8 2877 }, 2878 "id": 195, 2879 "options": { 2880 "code": { 2881 "language": "plaintext", 2882 "showLineNumbers": false, 2883 "showMiniMap": false 2884 }, 2885 "content": "", 2886 "mode": "html" 2887 }, 2888 "pluginVersion": "10.3.3", 2889 "repeatDirection": "v", 2890 "targets": [ 2891 { 2892 "datasource": { 2893 "type": "prometheus", 2894 "uid": "${DS_PROMETHEUS}" 2895 }, 2896 "exemplar": true, 2897 "expr": "kube_pod_container_status_ready{container=\"postgres\",namespace=~\"$namespace\",pod=~\"$instances\"}", 2898 "instant": true, 2899 "interval": "", 2900 "legendFormat": "{{pod}}", 2901 "refId": "A" 2902 } 2903 ], 2904 "title": "Connections", 2905 "type": "text" 2906 }, 2907 { 2908 "datasource": { 2909 "type": "prometheus", 2910 "uid": "${DS_PROMETHEUS}" 2911 }, 2912 "gridPos": { 2913 "h": 1, 2914 "w": 3, 2915 "x": 14, 2916 "y": 8 2917 }, 2918 "id": 196, 2919 "options": { 2920 "code": { 2921 "language": "plaintext", 2922 "showLineNumbers": false, 2923 "showMiniMap": false 2924 }, 2925 "content": "", 2926 "mode": "html" 2927 }, 2928 "pluginVersion": "10.3.3", 2929 "repeatDirection": "v", 2930 "targets": [ 2931 { 2932 "datasource": { 2933 "type": "prometheus", 2934 "uid": "${DS_PROMETHEUS}" 2935 }, 2936 "exemplar": true, 2937 "expr": "kube_pod_container_status_ready{container=\"postgres\",namespace=~\"$namespace\",pod=~\"$instances\"}", 2938 "instant": true, 2939 "interval": "", 2940 "legendFormat": "{{pod}}", 2941 "refId": "A" 2942 } 2943 ], 2944 "title": "Max Connections", 2945 "type": "text" 2946 }, 2947 { 2948 "datasource": { 2949 "type": "prometheus", 2950 "uid": "${DS_PROMETHEUS}" 2951 }, 2952 "description": "", 2953 "gridPos": { 2954 "h": 1, 2955 "w": 3, 2956 "x": 17, 2957 "y": 8 2958 }, 2959 "id": 197, 2960 "options": { 2961 "code": { 2962 "language": "plaintext", 2963 "showLineNumbers": false, 2964 "showMiniMap": false 2965 }, 2966 "content": "", 2967 "mode": "html" 2968 }, 2969 "pluginVersion": "10.3.3", 2970 "repeatDirection": "v", 2971 "targets": [ 2972 { 2973 "datasource": { 2974 "type": "prometheus", 2975 "uid": "${DS_PROMETHEUS}" 2976 }, 2977 "exemplar": true, 2978 "expr": "kube_pod_container_status_ready{container=\"postgres\",namespace=~\"$namespace\",pod=~\"$instances\"}", 2979 "instant": true, 2980 "interval": "", 2981 "legendFormat": "{{pod}}", 2982 "refId": "A" 2983 } 2984 ], 2985 "title": "Wraparound", 2986 "type": "text" 2987 }, 2988 { 2989 "datasource": { 2990 "type": "prometheus", 2991 "uid": "${DS_PROMETHEUS}" 2992 }, 2993 "gridPos": { 2994 "h": 1, 2995 "w": 2, 2996 "x": 20, 2997 "y": 8 2998 }, 2999 "id": 313, 3000 "options": { 3001 "code": { 3002 "language": "plaintext", 3003 "showLineNumbers": false, 3004 "showMiniMap": false 3005 }, 3006 "content": "", 3007 "mode": "html" 3008 }, 3009 "pluginVersion": "10.3.3", 3010 "repeatDirection": "v", 3011 "targets": [ 3012 { 3013 "datasource": { 3014 "type": "prometheus", 3015 "uid": "${DS_PROMETHEUS}" 3016 }, 3017 "exemplar": true, 3018 "expr": "kube_pod_container_status_ready{container=\"postgres\",namespace=~\"$namespace\",pod=~\"$instances\"}", 3019 "instant": true, 3020 "interval": "", 3021 "legendFormat": "{{pod}}", 3022 "refId": "A" 3023 } 3024 ], 3025 "title": "Started", 3026 "type": "text" 3027 }, 3028 { 3029 "datasource": { 3030 "type": "prometheus", 3031 "uid": "${DS_PROMETHEUS}" 3032 }, 3033 "gridPos": { 3034 "h": 1, 3035 "w": 2, 3036 "x": 22, 3037 "y": 8 3038 }, 3039 "id": 198, 3040 "options": { 3041 "code": { 3042 "language": "plaintext", 3043 "showLineNumbers": false, 3044 "showMiniMap": false 3045 }, 3046 "content": "", 3047 "mode": "html" 3048 }, 3049 "pluginVersion": "10.3.3", 3050 "repeatDirection": "v", 3051 "targets": [ 3052 { 3053 "datasource": { 3054 "type": "prometheus", 3055 "uid": "${DS_PROMETHEUS}" 3056 }, 3057 "exemplar": true, 3058 "expr": "kube_pod_container_status_ready{container=\"postgres\",namespace=~\"$namespace\",pod=~\"$instances\"}", 3059 "instant": true, 3060 "interval": "", 3061 "legendFormat": "{{pod}}", 3062 "refId": "A" 3063 } 3064 ], 3065 "title": "Version", 3066 "type": "text" 3067 }, 3068 { 3069 "datasource": { 3070 "type": "prometheus", 3071 "uid": "${DS_PROMETHEUS}" 3072 }, 3073 "gridPos": { 3074 "h": 3, 3075 "w": 3, 3076 "x": 0, 3077 "y": 9 3078 }, 3079 "id": 61, 3080 "options": { 3081 "code": { 3082 "language": "plaintext", 3083 "showLineNumbers": false, 3084 "showMiniMap": false 3085 }, 3086 "content": "<table style=\"width:100%; height:100%;border:0px solid black;\">\n <td style=\"text-align: center;vertical-align: middle;border:0px solid black; \"><p style=\"font-weight: bold;\">$instances</p>\n </td>\n</table>", 3087 "mode": "html" 3088 }, 3089 "pluginVersion": "10.3.3", 3090 "repeat": "instances", 3091 "repeatDirection": "v", 3092 "targets": [ 3093 { 3094 "datasource": { 3095 "type": "prometheus", 3096 "uid": "${DS_PROMETHEUS}" 3097 }, 3098 "exemplar": true, 3099 "expr": "kube_pod_container_status_ready{container=\"postgres\",namespace=~\"$namespace\",pod=~\"$instances\"}", 3100 "instant": true, 3101 "interval": "", 3102 "legendFormat": "{{pod}}", 3103 "refId": "A" 3104 } 3105 ], 3106 "type": "text" 3107 }, 3108 { 3109 "datasource": { 3110 "type": "prometheus", 3111 "uid": "${DS_PROMETHEUS}" 3112 }, 3113 "fieldConfig": { 3114 "defaults": { 3115 "color": { 3116 "mode": "thresholds" 3117 }, 3118 "mappings": [ 3119 { 3120 "options": { 3121 "0": { 3122 "index": 0, 3123 "text": "Down" 3124 }, 3125 "1": { 3126 "index": 1, 3127 "text": "Up" 3128 } 3129 }, 3130 "type": "value" 3131 } 3132 ], 3133 "thresholds": { 3134 "mode": "absolute", 3135 "steps": [ 3136 { 3137 "color": "dark-red", 3138 "value": null 3139 }, 3140 { 3141 "color": "green", 3142 "value": 1 3143 } 3144 ] 3145 }, 3146 "unitScale": true 3147 }, 3148 "overrides": [] 3149 }, 3150 "gridPos": { 3151 "h": 3, 3152 "w": 2, 3153 "x": 3, 3154 "y": 9 3155 }, 3156 "id": 33, 3157 "options": { 3158 "colorMode": "background", 3159 "graphMode": "area", 3160 "justifyMode": "auto", 3161 "orientation": "auto", 3162 "reduceOptions": { 3163 "calcs": ["lastNotNull"], 3164 "fields": "", 3165 "values": false 3166 }, 3167 "showPercentChange": false, 3168 "text": {}, 3169 "textMode": "value", 3170 "wideLayout": true 3171 }, 3172 "pluginVersion": "10.3.3", 3173 "repeat": "instances", 3174 "repeatDirection": "v", 3175 "targets": [ 3176 { 3177 "datasource": { 3178 "type": "prometheus", 3179 "uid": "${DS_PROMETHEUS}" 3180 }, 3181 "editorMode": "code", 3182 "exemplar": true, 3183 "expr": "min(kube_pod_container_status_ready{container=\"postgres\",namespace=~\"$namespace\",pod=~\"$instances\"})", 3184 "instant": true, 3185 "interval": "", 3186 "legendFormat": "", 3187 "refId": "A" 3188 } 3189 ], 3190 "type": "stat" 3191 }, 3192 { 3193 "datasource": { 3194 "type": "prometheus", 3195 "uid": "${DS_PROMETHEUS}" 3196 }, 3197 "description": "", 3198 "fieldConfig": { 3199 "defaults": { 3200 "color": { 3201 "mode": "thresholds" 3202 }, 3203 "mappings": [ 3204 { 3205 "options": { 3206 "0": { 3207 "color": "red", 3208 "index": 1, 3209 "text": "No" 3210 }, 3211 "1": { 3212 "color": "green", 3213 "index": 0, 3214 "text": "Yes" 3215 } 3216 }, 3217 "type": "value" 3218 } 3219 ], 3220 "noValue": "-", 3221 "thresholds": { 3222 "mode": "absolute", 3223 "steps": [ 3224 { 3225 "color": "green", 3226 "value": null 3227 }, 3228 { 3229 "color": "red", 3230 "value": 80 3231 } 3232 ] 3233 }, 3234 "unitScale": true 3235 }, 3236 "overrides": [] 3237 }, 3238 "gridPos": { 3239 "h": 3, 3240 "w": 2, 3241 "x": 5, 3242 "y": 9 3243 }, 3244 "id": 60, 3245 "options": { 3246 "colorMode": "background", 3247 "graphMode": "area", 3248 "justifyMode": "auto", 3249 "orientation": "auto", 3250 "reduceOptions": { 3251 "calcs": ["lastNotNull"], 3252 "fields": "", 3253 "values": false 3254 }, 3255 "showPercentChange": false, 3256 "text": {}, 3257 "textMode": "value", 3258 "wideLayout": true 3259 }, 3260 "pluginVersion": "10.3.3", 3261 "repeat": "instances", 3262 "repeatDirection": "v", 3263 "targets": [ 3264 { 3265 "datasource": { 3266 "type": "prometheus", 3267 "uid": "${DS_PROMETHEUS}" 3268 }, 3269 "exemplar": true, 3270 "expr": "1 - cnpg_pg_replication_in_recovery{namespace=~\"$namespace\",pod=~\"$instances\"} + cnpg_pg_replication_is_wal_receiver_up{namespace=~\"$namespace\",pod=~\"$instances\"}", 3271 "instant": true, 3272 "interval": "", 3273 "legendFormat": "{{pod}}", 3274 "refId": "A" 3275 } 3276 ], 3277 "transformations": [], 3278 "type": "stat" 3279 }, 3280 { 3281 "datasource": { 3282 "type": "prometheus", 3283 "uid": "${DS_PROMETHEUS}" 3284 }, 3285 "description": "", 3286 "fieldConfig": { 3287 "defaults": { 3288 "color": { 3289 "mode": "thresholds" 3290 }, 3291 "mappings": [], 3292 "noValue": "-", 3293 "thresholds": { 3294 "mode": "absolute", 3295 "steps": [ 3296 { 3297 "color": "green", 3298 "value": null 3299 }, 3300 { 3301 "color": "red", 3302 "value": 80 3303 } 3304 ] 3305 }, 3306 "unitScale": true 3307 }, 3308 "overrides": [] 3309 }, 3310 "gridPos": { 3311 "h": 3, 3312 "w": 1, 3313 "x": 7, 3314 "y": 9 3315 }, 3316 "id": 229, 3317 "options": { 3318 "colorMode": "value", 3319 "graphMode": "none", 3320 "justifyMode": "auto", 3321 "orientation": "auto", 3322 "reduceOptions": { 3323 "calcs": ["lastNotNull"], 3324 "fields": "", 3325 "values": false 3326 }, 3327 "showPercentChange": false, 3328 "text": {}, 3329 "textMode": "value", 3330 "wideLayout": true 3331 }, 3332 "pluginVersion": "10.3.3", 3333 "repeat": "instances", 3334 "repeatDirection": "v", 3335 "targets": [ 3336 { 3337 "datasource": { 3338 "type": "prometheus", 3339 "uid": "${DS_PROMETHEUS}" 3340 }, 3341 "editorMode": "code", 3342 "exemplar": true, 3343 "expr": "cnpg_pg_replication_streaming_replicas{namespace=~\"$namespace\", pod=~\"$instances\"}", 3344 "instant": true, 3345 "interval": "", 3346 "legendFormat": "{{pod}}", 3347 "refId": "A" 3348 } 3349 ], 3350 "transformations": [], 3351 "type": "stat" 3352 }, 3353 { 3354 "datasource": { 3355 "type": "prometheus", 3356 "uid": "${DS_PROMETHEUS}" 3357 }, 3358 "description": "This metric depends on exporting the: `topology.kubernetes.io/zone` label through kube-state-metrics (not enabled by default). Can be added by changing its configuration with:\n\n```yaml\nmetricLabelsAllowlist:\n - nodes=[topology.kubernetes.io/zone]\n```", 3359 "fieldConfig": { 3360 "defaults": { 3361 "color": { 3362 "mode": "thresholds" 3363 }, 3364 "mappings": [], 3365 "thresholds": { 3366 "mode": "absolute", 3367 "steps": [ 3368 { 3369 "color": "blue", 3370 "value": null 3371 } 3372 ] 3373 }, 3374 "unitScale": true 3375 }, 3376 "overrides": [] 3377 }, 3378 "gridPos": { 3379 "h": 3, 3380 "w": 2, 3381 "x": 8, 3382 "y": 9 3383 }, 3384 "id": 386, 3385 "options": { 3386 "colorMode": "value", 3387 "graphMode": "none", 3388 "justifyMode": "auto", 3389 "orientation": "auto", 3390 "reduceOptions": { 3391 "calcs": ["lastNotNull"], 3392 "fields": "/^label_topology_kubernetes_io_zone$/", 3393 "values": false 3394 }, 3395 "showPercentChange": false, 3396 "text": { 3397 "valueSize": 18 3398 }, 3399 "textMode": "value", 3400 "wideLayout": true 3401 }, 3402 "pluginVersion": "10.3.3", 3403 "repeat": "instances", 3404 "repeatDirection": "v", 3405 "targets": [ 3406 { 3407 "datasource": { 3408 "type": "prometheus", 3409 "uid": "${DS_PROMETHEUS}" 3410 }, 3411 "editorMode": "code", 3412 "exemplar": true, 3413 "expr": "kube_pod_info{namespace=~\"$namespace\", pod=~\"$instances\"} * on(node,instance) group_left(label_topology_kubernetes_io_zone) kube_node_labels", 3414 "format": "table", 3415 "instant": true, 3416 "interval": "", 3417 "legendFormat": "{{pod}}", 3418 "refId": "A" 3419 } 3420 ], 3421 "transformations": [], 3422 "type": "stat" 3423 }, 3424 { 3425 "datasource": { 3426 "type": "prometheus", 3427 "uid": "${DS_PROMETHEUS}" 3428 }, 3429 "fieldConfig": { 3430 "defaults": { 3431 "color": { 3432 "mode": "palette-classic" 3433 }, 3434 "custom": { 3435 "axisBorderShow": false, 3436 "axisCenteredZero": false, 3437 "axisColorMode": "text", 3438 "axisLabel": "", 3439 "axisPlacement": "auto", 3440 "barAlignment": 0, 3441 "drawStyle": "line", 3442 "fillOpacity": 10, 3443 "gradientMode": "none", 3444 "hideFrom": { 3445 "legend": false, 3446 "tooltip": false, 3447 "viz": false 3448 }, 3449 "insertNulls": false, 3450 "lineInterpolation": "linear", 3451 "lineWidth": 1, 3452 "pointSize": 5, 3453 "scaleDistribution": { 3454 "type": "linear" 3455 }, 3456 "showPoints": "never", 3457 "spanNulls": true, 3458 "stacking": { 3459 "group": "A", 3460 "mode": "none" 3461 }, 3462 "thresholdsStyle": { 3463 "mode": "off" 3464 } 3465 }, 3466 "mappings": [], 3467 "thresholds": { 3468 "mode": "absolute", 3469 "steps": [ 3470 { 3471 "color": "green", 3472 "value": null 3473 } 3474 ] 3475 }, 3476 "unit": "short", 3477 "unitScale": true 3478 }, 3479 "overrides": [] 3480 }, 3481 "gridPos": { 3482 "h": 3, 3483 "w": 4, 3484 "x": 10, 3485 "y": 9 3486 }, 3487 "id": 58, 3488 "options": { 3489 "legend": { 3490 "calcs": ["last", "mean"], 3491 "displayMode": "list", 3492 "placement": "bottom", 3493 "showLegend": true 3494 }, 3495 "tooltip": { 3496 "mode": "multi", 3497 "sort": "none" 3498 } 3499 }, 3500 "pluginVersion": "8.2.1", 3501 "repeat": "instances", 3502 "repeatDirection": "v", 3503 "targets": [ 3504 { 3505 "datasource": { 3506 "type": "prometheus", 3507 "uid": "${DS_PROMETHEUS}" 3508 }, 3509 "editorMode": "code", 3510 "exemplar": true, 3511 "expr": "sum by (pod) (cnpg_backends_total{namespace=~\"$namespace\", pod=~\"$instances\"})", 3512 "instant": false, 3513 "interval": "", 3514 "legendFormat": "-", 3515 "refId": "A" 3516 } 3517 ], 3518 "type": "timeseries" 3519 }, 3520 { 3521 "datasource": { 3522 "type": "prometheus", 3523 "uid": "${DS_PROMETHEUS}" 3524 }, 3525 "description": "", 3526 "fieldConfig": { 3527 "defaults": { 3528 "color": { 3529 "mode": "thresholds" 3530 }, 3531 "decimals": 0, 3532 "mappings": [], 3533 "max": 100, 3534 "min": 0, 3535 "noValue": "<1%", 3536 "thresholds": { 3537 "mode": "absolute", 3538 "steps": [ 3539 { 3540 "color": "green", 3541 "value": null 3542 }, 3543 { 3544 "color": "#EAB839", 3545 "value": 75 3546 }, 3547 { 3548 "color": "red", 3549 "value": 90 3550 } 3551 ] 3552 }, 3553 "unit": "percent", 3554 "unitScale": true 3555 }, 3556 "overrides": [] 3557 }, 3558 "gridPos": { 3559 "h": 3, 3560 "w": 3, 3561 "x": 14, 3562 "y": 9 3563 }, 3564 "id": 32, 3565 "options": { 3566 "minVizHeight": 75, 3567 "minVizWidth": 75, 3568 "orientation": "horizontal", 3569 "reduceOptions": { 3570 "calcs": ["last"], 3571 "fields": "", 3572 "values": false 3573 }, 3574 "showThresholdLabels": false, 3575 "showThresholdMarkers": true, 3576 "sizing": "auto", 3577 "text": {} 3578 }, 3579 "pluginVersion": "10.3.3", 3580 "repeat": "instances", 3581 "repeatDirection": "v", 3582 "targets": [ 3583 { 3584 "datasource": { 3585 "type": "prometheus", 3586 "uid": "${DS_PROMETHEUS}" 3587 }, 3588 "editorMode": "code", 3589 "exemplar": true, 3590 "expr": "100 * sum by (pod) (cnpg_backends_total{namespace=~\"$namespace\", pod=~\"$instances\"}) / sum by (pod) (cnpg_pg_settings_setting{name=\"max_connections\", namespace=~\"$namespace\", pod=~\"$instances\"})", 3591 "instant": true, 3592 "interval": "", 3593 "legendFormat": "{{pod}}", 3594 "refId": "A" 3595 } 3596 ], 3597 "type": "gauge" 3598 }, 3599 { 3600 "datasource": { 3601 "type": "prometheus", 3602 "uid": "${DS_PROMETHEUS}" 3603 }, 3604 "fieldConfig": { 3605 "defaults": { 3606 "color": { 3607 "mode": "thresholds" 3608 }, 3609 "mappings": [], 3610 "max": 2147483647, 3611 "min": 0, 3612 "thresholds": { 3613 "mode": "absolute", 3614 "steps": [ 3615 { 3616 "color": "green", 3617 "value": null 3618 }, 3619 { 3620 "color": "#EAB839", 3621 "value": 200000000 3622 }, 3623 { 3624 "color": "red", 3625 "value": 1000000000 3626 } 3627 ] 3628 }, 3629 "unit": "none", 3630 "unitScale": true 3631 }, 3632 "overrides": [] 3633 }, 3634 "gridPos": { 3635 "h": 3, 3636 "w": 3, 3637 "x": 17, 3638 "y": 9 3639 }, 3640 "id": 8, 3641 "options": { 3642 "displayMode": "lcd", 3643 "maxVizHeight": 300, 3644 "minVizHeight": 10, 3645 "minVizWidth": 0, 3646 "namePlacement": "auto", 3647 "orientation": "horizontal", 3648 "reduceOptions": { 3649 "calcs": ["lastNotNull"], 3650 "fields": "", 3651 "values": false 3652 }, 3653 "showUnfilled": true, 3654 "sizing": "auto", 3655 "text": {}, 3656 "valueMode": "color" 3657 }, 3658 "pluginVersion": "10.3.3", 3659 "repeat": "instances", 3660 "repeatDirection": "v", 3661 "targets": [ 3662 { 3663 "datasource": { 3664 "type": "prometheus", 3665 "uid": "${DS_PROMETHEUS}" 3666 }, 3667 "editorMode": "code", 3668 "exemplar": true, 3669 "expr": "max by (pod) (cnpg_pg_database_xid_age{namespace=~\"$namespace\", pod=~\"$instances\"})", 3670 "instant": true, 3671 "interval": "", 3672 "legendFormat": "{{pod}}", 3673 "refId": "A" 3674 } 3675 ], 3676 "type": "bargauge" 3677 }, 3678 { 3679 "datasource": { 3680 "type": "prometheus", 3681 "uid": "${DS_PROMETHEUS}" 3682 }, 3683 "description": "", 3684 "fieldConfig": { 3685 "defaults": { 3686 "color": { 3687 "mode": "thresholds" 3688 }, 3689 "mappings": [], 3690 "thresholds": { 3691 "mode": "absolute", 3692 "steps": [ 3693 { 3694 "color": "dark-blue", 3695 "value": null 3696 } 3697 ] 3698 }, 3699 "unit": "dateTimeFromNow", 3700 "unitScale": true 3701 }, 3702 "overrides": [] 3703 }, 3704 "gridPos": { 3705 "h": 3, 3706 "w": 2, 3707 "x": 20, 3708 "y": 9 3709 }, 3710 "id": 314, 3711 "options": { 3712 "colorMode": "background", 3713 "graphMode": "none", 3714 "justifyMode": "auto", 3715 "orientation": "horizontal", 3716 "reduceOptions": { 3717 "calcs": ["lastNotNull"], 3718 "fields": "", 3719 "values": false 3720 }, 3721 "showPercentChange": false, 3722 "text": {}, 3723 "textMode": "value", 3724 "wideLayout": true 3725 }, 3726 "pluginVersion": "10.3.3", 3727 "repeat": "instances", 3728 "repeatDirection": "v", 3729 "targets": [ 3730 { 3731 "datasource": { 3732 "type": "prometheus", 3733 "uid": "${DS_PROMETHEUS}" 3734 }, 3735 "editorMode": "code", 3736 "exemplar": false, 3737 "expr": "cnpg_pg_postmaster_start_time{namespace=~\"$namespace\", pod=~\"$instances\"}*1000", 3738 "format": "time_series", 3739 "hide": false, 3740 "instant": true, 3741 "interval": "", 3742 "intervalFactor": 1, 3743 "legendFormat": "", 3744 "refId": "A" 3745 } 3746 ], 3747 "transformations": [], 3748 "type": "stat" 3749 }, 3750 { 3751 "datasource": { 3752 "type": "prometheus", 3753 "uid": "${DS_PROMETHEUS}" 3754 }, 3755 "description": "", 3756 "fieldConfig": { 3757 "defaults": { 3758 "color": { 3759 "mode": "thresholds" 3760 }, 3761 "mappings": [], 3762 "thresholds": { 3763 "mode": "absolute", 3764 "steps": [ 3765 { 3766 "color": "dark-blue", 3767 "value": null 3768 } 3769 ] 3770 }, 3771 "unit": "string", 3772 "unitScale": true 3773 }, 3774 "overrides": [] 3775 }, 3776 "gridPos": { 3777 "h": 3, 3778 "w": 2, 3779 "x": 22, 3780 "y": 9 3781 }, 3782 "id": 42, 3783 "options": { 3784 "colorMode": "background", 3785 "graphMode": "none", 3786 "justifyMode": "auto", 3787 "orientation": "horizontal", 3788 "reduceOptions": { 3789 "calcs": ["lastNotNull"], 3790 "fields": "/^full$/", 3791 "values": false 3792 }, 3793 "showPercentChange": false, 3794 "text": {}, 3795 "textMode": "value", 3796 "wideLayout": true 3797 }, 3798 "pluginVersion": "10.3.3", 3799 "repeat": "instances", 3800 "repeatDirection": "v", 3801 "targets": [ 3802 { 3803 "datasource": { 3804 "type": "prometheus", 3805 "uid": "${DS_PROMETHEUS}" 3806 }, 3807 "editorMode": "code", 3808 "exemplar": false, 3809 "expr": "cnpg_collector_postgres_version{namespace=~\"$namespace\", pod=~\"$instances\"}", 3810 "format": "table", 3811 "hide": false, 3812 "instant": true, 3813 "interval": "", 3814 "intervalFactor": 1, 3815 "legendFormat": "{{pod}}", 3816 "refId": "A" 3817 } 3818 ], 3819 "transformations": [], 3820 "type": "stat" 3821 }, 3822 { 3823 "collapsed": true, 3824 "datasource": { 3825 "uid": "prometheus" 3826 }, 3827 "gridPos": { 3828 "h": 1, 3829 "w": 24, 3830 "x": 0, 3831 "y": 18 3832 }, 3833 "id": 41, 3834 "panels": [ 3835 { 3836 "datasource": { 3837 "type": "prometheus", 3838 "uid": "${DS_PROMETHEUS}" 3839 }, 3840 "gridPos": { 3841 "h": 1, 3842 "w": 3, 3843 "x": 0, 3844 "y": 25 3845 }, 3846 "id": 187, 3847 "options": { 3848 "code": { 3849 "language": "plaintext", 3850 "showLineNumbers": false, 3851 "showMiniMap": false 3852 }, 3853 "content": "", 3854 "mode": "html" 3855 }, 3856 "pluginVersion": "10.3.1", 3857 "repeatDirection": "v", 3858 "targets": [ 3859 { 3860 "datasource": { 3861 "type": "prometheus", 3862 "uid": "${DS_PROMETHEUS}" 3863 }, 3864 "exemplar": true, 3865 "expr": "kube_pod_container_status_ready{container=\"postgres\",namespace=~\"$namespace\",pod=~\"$instances\"}", 3866 "instant": true, 3867 "interval": "", 3868 "legendFormat": "{{pod}}", 3869 "refId": "A" 3870 } 3871 ], 3872 "title": "Instance", 3873 "transparent": true, 3874 "type": "text" 3875 }, 3876 { 3877 "datasource": { 3878 "type": "prometheus", 3879 "uid": "${DS_PROMETHEUS}" 3880 }, 3881 "gridPos": { 3882 "h": 1, 3883 "w": 3, 3884 "x": 3, 3885 "y": 25 3886 }, 3887 "id": 183, 3888 "options": { 3889 "code": { 3890 "language": "plaintext", 3891 "showLineNumbers": false, 3892 "showMiniMap": false 3893 }, 3894 "content": "", 3895 "mode": "html" 3896 }, 3897 "pluginVersion": "10.3.1", 3898 "repeatDirection": "v", 3899 "targets": [ 3900 { 3901 "datasource": { 3902 "type": "prometheus", 3903 "uid": "${DS_PROMETHEUS}" 3904 }, 3905 "exemplar": true, 3906 "expr": "kube_pod_container_status_ready{container=\"postgres\",namespace=~\"$namespace\",pod=~\"$instances\"}", 3907 "instant": true, 3908 "interval": "", 3909 "legendFormat": "{{pod}}", 3910 "refId": "A" 3911 } 3912 ], 3913 "title": "Max Connections", 3914 "type": "text" 3915 }, 3916 { 3917 "datasource": { 3918 "type": "prometheus", 3919 "uid": "${DS_PROMETHEUS}" 3920 }, 3921 "gridPos": { 3922 "h": 1, 3923 "w": 3, 3924 "x": 6, 3925 "y": 25 3926 }, 3927 "id": 184, 3928 "options": { 3929 "code": { 3930 "language": "plaintext", 3931 "showLineNumbers": false, 3932 "showMiniMap": false 3933 }, 3934 "content": "", 3935 "mode": "html" 3936 }, 3937 "pluginVersion": "10.3.1", 3938 "repeatDirection": "v", 3939 "targets": [ 3940 { 3941 "datasource": { 3942 "type": "prometheus", 3943 "uid": "${DS_PROMETHEUS}" 3944 }, 3945 "exemplar": true, 3946 "expr": "kube_pod_container_status_ready{container=\"postgres\",namespace=~\"$namespace\",pod=~\"$instances\"}", 3947 "instant": true, 3948 "interval": "", 3949 "legendFormat": "{{pod}}", 3950 "refId": "A" 3951 } 3952 ], 3953 "title": "Shared Buffers", 3954 "type": "text" 3955 }, 3956 { 3957 "datasource": { 3958 "type": "prometheus", 3959 "uid": "${DS_PROMETHEUS}" 3960 }, 3961 "gridPos": { 3962 "h": 1, 3963 "w": 3, 3964 "x": 9, 3965 "y": 25 3966 }, 3967 "id": 185, 3968 "options": { 3969 "code": { 3970 "language": "plaintext", 3971 "showLineNumbers": false, 3972 "showMiniMap": false 3973 }, 3974 "content": "", 3975 "mode": "html" 3976 }, 3977 "pluginVersion": "10.3.1", 3978 "repeatDirection": "v", 3979 "targets": [ 3980 { 3981 "datasource": { 3982 "type": "prometheus", 3983 "uid": "${DS_PROMETHEUS}" 3984 }, 3985 "exemplar": true, 3986 "expr": "kube_pod_container_status_ready{container=\"postgres\",namespace=~\"$namespace\",pod=~\"$instances\"}", 3987 "instant": true, 3988 "interval": "", 3989 "legendFormat": "{{pod}}", 3990 "refId": "A" 3991 } 3992 ], 3993 "title": "Effective Cache Size", 3994 "type": "text" 3995 }, 3996 { 3997 "datasource": { 3998 "type": "prometheus", 3999 "uid": "${DS_PROMETHEUS}" 4000 }, 4001 "gridPos": { 4002 "h": 1, 4003 "w": 3, 4004 "x": 12, 4005 "y": 25 4006 }, 4007 "id": 186, 4008 "options": { 4009 "code": { 4010 "language": "plaintext", 4011 "showLineNumbers": false, 4012 "showMiniMap": false 4013 }, 4014 "content": "", 4015 "mode": "html" 4016 }, 4017 "pluginVersion": "10.3.1", 4018 "repeatDirection": "v", 4019 "targets": [ 4020 { 4021 "datasource": { 4022 "type": "prometheus", 4023 "uid": "${DS_PROMETHEUS}" 4024 }, 4025 "exemplar": true, 4026 "expr": "kube_pod_container_status_ready{container=\"postgres\",namespace=~\"$namespace\",pod=~\"$instances\"}", 4027 "instant": true, 4028 "interval": "", 4029 "legendFormat": "{{pod}}", 4030 "refId": "A" 4031 } 4032 ], 4033 "title": "Work Mem", 4034 "type": "text" 4035 }, 4036 { 4037 "datasource": { 4038 "type": "prometheus", 4039 "uid": "${DS_PROMETHEUS}" 4040 }, 4041 "gridPos": { 4042 "h": 1, 4043 "w": 3, 4044 "x": 15, 4045 "y": 25 4046 }, 4047 "id": 188, 4048 "options": { 4049 "code": { 4050 "language": "plaintext", 4051 "showLineNumbers": false, 4052 "showMiniMap": false 4053 }, 4054 "content": "", 4055 "mode": "html" 4056 }, 4057 "pluginVersion": "10.3.1", 4058 "repeatDirection": "v", 4059 "targets": [ 4060 { 4061 "datasource": { 4062 "type": "prometheus", 4063 "uid": "${DS_PROMETHEUS}" 4064 }, 4065 "exemplar": true, 4066 "expr": "kube_pod_container_status_ready{container=\"postgres\",namespace=~\"$namespace\",pod=~\"$instances\"}", 4067 "instant": true, 4068 "interval": "", 4069 "legendFormat": "{{pod}}", 4070 "refId": "A" 4071 } 4072 ], 4073 "title": "Maintenance Work Mem", 4074 "type": "text" 4075 }, 4076 { 4077 "datasource": { 4078 "type": "prometheus", 4079 "uid": "${DS_PROMETHEUS}" 4080 }, 4081 "gridPos": { 4082 "h": 1, 4083 "w": 3, 4084 "x": 18, 4085 "y": 25 4086 }, 4087 "id": 189, 4088 "options": { 4089 "code": { 4090 "language": "plaintext", 4091 "showLineNumbers": false, 4092 "showMiniMap": false 4093 }, 4094 "content": "", 4095 "mode": "html" 4096 }, 4097 "pluginVersion": "10.3.1", 4098 "repeatDirection": "v", 4099 "targets": [ 4100 { 4101 "datasource": { 4102 "type": "prometheus", 4103 "uid": "${DS_PROMETHEUS}" 4104 }, 4105 "exemplar": true, 4106 "expr": "kube_pod_container_status_ready{container=\"postgres\",namespace=~\"$namespace\",pod=~\"$instances\"}", 4107 "instant": true, 4108 "interval": "", 4109 "legendFormat": "{{pod}}", 4110 "refId": "A" 4111 } 4112 ], 4113 "title": "Random Page Cost", 4114 "type": "text" 4115 }, 4116 { 4117 "datasource": { 4118 "type": "prometheus", 4119 "uid": "${DS_PROMETHEUS}" 4120 }, 4121 "gridPos": { 4122 "h": 1, 4123 "w": 3, 4124 "x": 21, 4125 "y": 25 4126 }, 4127 "id": 190, 4128 "options": { 4129 "code": { 4130 "language": "plaintext", 4131 "showLineNumbers": false, 4132 "showMiniMap": false 4133 }, 4134 "content": "", 4135 "mode": "html" 4136 }, 4137 "pluginVersion": "10.3.1", 4138 "repeatDirection": "v", 4139 "targets": [ 4140 { 4141 "datasource": { 4142 "type": "prometheus", 4143 "uid": "${DS_PROMETHEUS}" 4144 }, 4145 "exemplar": true, 4146 "expr": "kube_pod_container_status_ready{container=\"postgres\",namespace=~\"$namespace\",pod=~\"$instances\"}", 4147 "instant": true, 4148 "interval": "", 4149 "legendFormat": "{{pod}}", 4150 "refId": "A" 4151 } 4152 ], 4153 "title": "Sequential Page Cost", 4154 "type": "text" 4155 }, 4156 { 4157 "datasource": { 4158 "type": "prometheus", 4159 "uid": "${DS_PROMETHEUS}" 4160 }, 4161 "gridPos": { 4162 "h": 3, 4163 "w": 3, 4164 "x": 0, 4165 "y": 26 4166 }, 4167 "id": 86, 4168 "options": { 4169 "code": { 4170 "language": "plaintext", 4171 "showLineNumbers": false, 4172 "showMiniMap": false 4173 }, 4174 "content": "<table style=\"width:100%; height:100%;border:0px solid black;\">\n <td style=\"text-align: center;vertical-align: middle;border:0px solid black; \"><p style=\"font-weight: bold;\">$instances</p>\n </td>\n</table>", 4175 "mode": "html" 4176 }, 4177 "pluginVersion": "10.3.1", 4178 "repeat": "instances", 4179 "repeatDirection": "v", 4180 "targets": [ 4181 { 4182 "datasource": { 4183 "type": "prometheus", 4184 "uid": "${DS_PROMETHEUS}" 4185 }, 4186 "exemplar": true, 4187 "expr": "kube_pod_container_status_ready{container=\"postgres\",namespace=~\"$namespace\",pod=~\"$instances\"}", 4188 "instant": true, 4189 "interval": "", 4190 "legendFormat": "{{pod}}", 4191 "refId": "A" 4192 } 4193 ], 4194 "type": "text" 4195 }, 4196 { 4197 "datasource": { 4198 "type": "prometheus", 4199 "uid": "${DS_PROMETHEUS}" 4200 }, 4201 "fieldConfig": { 4202 "defaults": { 4203 "color": { 4204 "mode": "thresholds" 4205 }, 4206 "mappings": [], 4207 "thresholds": { 4208 "mode": "absolute", 4209 "steps": [ 4210 { 4211 "color": "dark-purple" 4212 } 4213 ] 4214 }, 4215 "unitScale": true 4216 }, 4217 "overrides": [] 4218 }, 4219 "gridPos": { 4220 "h": 3, 4221 "w": 3, 4222 "x": 3, 4223 "y": 26 4224 }, 4225 "id": 30, 4226 "options": { 4227 "colorMode": "background", 4228 "graphMode": "none", 4229 "justifyMode": "auto", 4230 "orientation": "horizontal", 4231 "reduceOptions": { 4232 "calcs": ["lastNotNull"], 4233 "fields": "", 4234 "values": false 4235 }, 4236 "showPercentChange": false, 4237 "text": {}, 4238 "textMode": "value", 4239 "wideLayout": true 4240 }, 4241 "pluginVersion": "10.3.1", 4242 "repeat": "instances", 4243 "repeatDirection": "v", 4244 "targets": [ 4245 { 4246 "datasource": { 4247 "type": "prometheus", 4248 "uid": "${DS_PROMETHEUS}" 4249 }, 4250 "exemplar": true, 4251 "expr": "cnpg_pg_settings_setting{name=\"max_connections\",namespace=~\"$namespace\",pod=~\"$instances\"}", 4252 "instant": true, 4253 "interval": "", 4254 "legendFormat": "{{pod}}", 4255 "refId": "A" 4256 } 4257 ], 4258 "type": "stat" 4259 }, 4260 { 4261 "datasource": { 4262 "type": "prometheus", 4263 "uid": "${DS_PROMETHEUS}" 4264 }, 4265 "description": "", 4266 "fieldConfig": { 4267 "defaults": { 4268 "color": { 4269 "mode": "thresholds" 4270 }, 4271 "mappings": [], 4272 "thresholds": { 4273 "mode": "absolute", 4274 "steps": [ 4275 { 4276 "color": "dark-purple" 4277 } 4278 ] 4279 }, 4280 "unit": "bytes", 4281 "unitScale": true 4282 }, 4283 "overrides": [] 4284 }, 4285 "gridPos": { 4286 "h": 3, 4287 "w": 3, 4288 "x": 6, 4289 "y": 26 4290 }, 4291 "id": 24, 4292 "options": { 4293 "colorMode": "background", 4294 "graphMode": "none", 4295 "justifyMode": "auto", 4296 "orientation": "horizontal", 4297 "reduceOptions": { 4298 "calcs": ["lastNotNull"], 4299 "fields": "", 4300 "values": false 4301 }, 4302 "showPercentChange": false, 4303 "text": {}, 4304 "textMode": "value", 4305 "wideLayout": true 4306 }, 4307 "pluginVersion": "10.3.1", 4308 "repeat": "instances", 4309 "repeatDirection": "v", 4310 "targets": [ 4311 { 4312 "datasource": { 4313 "type": "prometheus", 4314 "uid": "${DS_PROMETHEUS}" 4315 }, 4316 "exemplar": true, 4317 "expr": "max by (pod) (cnpg_pg_settings_setting{name=\"shared_buffers\",namespace=~\"$namespace\",pod=~\"$instances\"}) * max by (pod) (cnpg_pg_settings_setting{name=\"block_size\",namespace=~\"$namespace\",pod=~\"$instances\"})", 4318 "instant": true, 4319 "interval": "", 4320 "legendFormat": "{{pod}}", 4321 "refId": "A" 4322 } 4323 ], 4324 "type": "stat" 4325 }, 4326 { 4327 "datasource": { 4328 "type": "prometheus", 4329 "uid": "${DS_PROMETHEUS}" 4330 }, 4331 "description": "", 4332 "fieldConfig": { 4333 "defaults": { 4334 "color": { 4335 "mode": "thresholds" 4336 }, 4337 "mappings": [], 4338 "thresholds": { 4339 "mode": "absolute", 4340 "steps": [ 4341 { 4342 "color": "dark-purple" 4343 } 4344 ] 4345 }, 4346 "unit": "bytes", 4347 "unitScale": true 4348 }, 4349 "overrides": [] 4350 }, 4351 "gridPos": { 4352 "h": 3, 4353 "w": 3, 4354 "x": 9, 4355 "y": 26 4356 }, 4357 "id": 57, 4358 "options": { 4359 "colorMode": "background", 4360 "graphMode": "none", 4361 "justifyMode": "auto", 4362 "orientation": "horizontal", 4363 "reduceOptions": { 4364 "calcs": ["lastNotNull"], 4365 "fields": "", 4366 "values": false 4367 }, 4368 "showPercentChange": false, 4369 "text": {}, 4370 "textMode": "value", 4371 "wideLayout": true 4372 }, 4373 "pluginVersion": "10.3.1", 4374 "repeat": "instances", 4375 "repeatDirection": "v", 4376 "targets": [ 4377 { 4378 "datasource": { 4379 "type": "prometheus", 4380 "uid": "${DS_PROMETHEUS}" 4381 }, 4382 "exemplar": true, 4383 "expr": "max by (pod) (cnpg_pg_settings_setting{name=\"effective_cache_size\",namespace=~\"$namespace\",pod=~\"$instances\"}) * max by (pod) (cnpg_pg_settings_setting{name=\"block_size\",namespace=~\"$namespace\",pod=~\"$instances\"})", 4384 "instant": true, 4385 "interval": "", 4386 "legendFormat": "{{pod}}", 4387 "refId": "A" 4388 } 4389 ], 4390 "type": "stat" 4391 }, 4392 { 4393 "datasource": { 4394 "type": "prometheus", 4395 "uid": "${DS_PROMETHEUS}" 4396 }, 4397 "description": "", 4398 "fieldConfig": { 4399 "defaults": { 4400 "color": { 4401 "mode": "thresholds" 4402 }, 4403 "mappings": [], 4404 "thresholds": { 4405 "mode": "absolute", 4406 "steps": [ 4407 { 4408 "color": "dark-purple" 4409 } 4410 ] 4411 }, 4412 "unit": "bytes", 4413 "unitScale": true 4414 }, 4415 "overrides": [] 4416 }, 4417 "gridPos": { 4418 "h": 3, 4419 "w": 3, 4420 "x": 12, 4421 "y": 26 4422 }, 4423 "id": 26, 4424 "options": { 4425 "colorMode": "background", 4426 "graphMode": "none", 4427 "justifyMode": "auto", 4428 "orientation": "horizontal", 4429 "reduceOptions": { 4430 "calcs": ["lastNotNull"], 4431 "fields": "", 4432 "values": false 4433 }, 4434 "showPercentChange": false, 4435 "text": {}, 4436 "textMode": "value", 4437 "wideLayout": true 4438 }, 4439 "pluginVersion": "10.3.1", 4440 "repeat": "instances", 4441 "repeatDirection": "v", 4442 "targets": [ 4443 { 4444 "datasource": { 4445 "type": "prometheus", 4446 "uid": "${DS_PROMETHEUS}" 4447 }, 4448 "exemplar": true, 4449 "expr": "cnpg_pg_settings_setting{name=\"work_mem\",namespace=~\"$namespace\",pod=~\"$instances\"} * 1024", 4450 "instant": true, 4451 "interval": "", 4452 "legendFormat": "{{pod}}", 4453 "refId": "A" 4454 } 4455 ], 4456 "type": "stat" 4457 }, 4458 { 4459 "datasource": { 4460 "type": "prometheus", 4461 "uid": "${DS_PROMETHEUS}" 4462 }, 4463 "fieldConfig": { 4464 "defaults": { 4465 "color": { 4466 "mode": "thresholds" 4467 }, 4468 "mappings": [], 4469 "thresholds": { 4470 "mode": "absolute", 4471 "steps": [ 4472 { 4473 "color": "dark-purple" 4474 } 4475 ] 4476 }, 4477 "unit": "bytes", 4478 "unitScale": true 4479 }, 4480 "overrides": [] 4481 }, 4482 "gridPos": { 4483 "h": 3, 4484 "w": 3, 4485 "x": 15, 4486 "y": 26 4487 }, 4488 "id": 47, 4489 "options": { 4490 "colorMode": "background", 4491 "graphMode": "none", 4492 "justifyMode": "auto", 4493 "orientation": "horizontal", 4494 "reduceOptions": { 4495 "calcs": ["lastNotNull"], 4496 "fields": "", 4497 "values": false 4498 }, 4499 "showPercentChange": false, 4500 "text": {}, 4501 "textMode": "value", 4502 "wideLayout": true 4503 }, 4504 "pluginVersion": "10.3.1", 4505 "repeat": "instances", 4506 "repeatDirection": "v", 4507 "targets": [ 4508 { 4509 "datasource": { 4510 "type": "prometheus", 4511 "uid": "${DS_PROMETHEUS}" 4512 }, 4513 "exemplar": true, 4514 "expr": "cnpg_pg_settings_setting{name=\"maintenance_work_mem\",namespace=~\"$namespace\",pod=~\"$instances\"}", 4515 "instant": true, 4516 "interval": "", 4517 "legendFormat": "{{pod}}", 4518 "refId": "A" 4519 } 4520 ], 4521 "type": "stat" 4522 }, 4523 { 4524 "datasource": { 4525 "type": "prometheus", 4526 "uid": "${DS_PROMETHEUS}" 4527 }, 4528 "fieldConfig": { 4529 "defaults": { 4530 "color": { 4531 "mode": "thresholds" 4532 }, 4533 "mappings": [], 4534 "thresholds": { 4535 "mode": "absolute", 4536 "steps": [ 4537 { 4538 "color": "dark-purple" 4539 } 4540 ] 4541 }, 4542 "unit": "none", 4543 "unitScale": true 4544 }, 4545 "overrides": [] 4546 }, 4547 "gridPos": { 4548 "h": 3, 4549 "w": 3, 4550 "x": 18, 4551 "y": 26 4552 }, 4553 "id": 48, 4554 "options": { 4555 "colorMode": "background", 4556 "graphMode": "none", 4557 "justifyMode": "auto", 4558 "orientation": "horizontal", 4559 "reduceOptions": { 4560 "calcs": ["lastNotNull"], 4561 "fields": "", 4562 "values": false 4563 }, 4564 "showPercentChange": false, 4565 "text": {}, 4566 "textMode": "value", 4567 "wideLayout": true 4568 }, 4569 "pluginVersion": "10.3.1", 4570 "repeat": "instances", 4571 "repeatDirection": "v", 4572 "targets": [ 4573 { 4574 "datasource": { 4575 "type": "prometheus", 4576 "uid": "${DS_PROMETHEUS}" 4577 }, 4578 "exemplar": true, 4579 "expr": "cnpg_pg_settings_setting{name=\"random_page_cost\",namespace=~\"$namespace\",pod=~\"$instances\"}", 4580 "instant": true, 4581 "interval": "", 4582 "legendFormat": "{{pod}}", 4583 "refId": "A" 4584 } 4585 ], 4586 "type": "stat" 4587 }, 4588 { 4589 "datasource": { 4590 "type": "prometheus", 4591 "uid": "${DS_PROMETHEUS}" 4592 }, 4593 "fieldConfig": { 4594 "defaults": { 4595 "color": { 4596 "mode": "thresholds" 4597 }, 4598 "mappings": [], 4599 "thresholds": { 4600 "mode": "absolute", 4601 "steps": [ 4602 { 4603 "color": "dark-purple" 4604 } 4605 ] 4606 }, 4607 "unit": "none", 4608 "unitScale": true 4609 }, 4610 "overrides": [] 4611 }, 4612 "gridPos": { 4613 "h": 3, 4614 "w": 3, 4615 "x": 21, 4616 "y": 26 4617 }, 4618 "id": 56, 4619 "options": { 4620 "colorMode": "background", 4621 "graphMode": "none", 4622 "justifyMode": "auto", 4623 "orientation": "horizontal", 4624 "reduceOptions": { 4625 "calcs": ["lastNotNull"], 4626 "fields": "", 4627 "values": false 4628 }, 4629 "showPercentChange": false, 4630 "text": {}, 4631 "textMode": "value", 4632 "wideLayout": true 4633 }, 4634 "pluginVersion": "10.3.1", 4635 "repeat": "instances", 4636 "repeatDirection": "v", 4637 "targets": [ 4638 { 4639 "datasource": { 4640 "type": "prometheus", 4641 "uid": "${DS_PROMETHEUS}" 4642 }, 4643 "exemplar": true, 4644 "expr": "cnpg_pg_settings_setting{name=\"seq_page_cost\",namespace=~\"$namespace\",pod=~\"$instances\"}", 4645 "instant": true, 4646 "interval": "", 4647 "legendFormat": "{{pod}}", 4648 "refId": "A" 4649 } 4650 ], 4651 "type": "stat" 4652 }, 4653 { 4654 "datasource": { 4655 "type": "prometheus", 4656 "uid": "${DS_PROMETHEUS}" 4657 }, 4658 "fieldConfig": { 4659 "defaults": { 4660 "color": { 4661 "mode": "thresholds" 4662 }, 4663 "custom": { 4664 "align": "auto", 4665 "cellOptions": { 4666 "type": "auto" 4667 }, 4668 "filterable": true, 4669 "inspect": false 4670 }, 4671 "mappings": [], 4672 "thresholds": { 4673 "mode": "absolute", 4674 "steps": [ 4675 { 4676 "color": "dark-purple" 4677 } 4678 ] 4679 }, 4680 "unitScale": true 4681 }, 4682 "overrides": [] 4683 }, 4684 "gridPos": { 4685 "h": 9, 4686 "w": 24, 4687 "x": 0, 4688 "y": 32 4689 }, 4690 "id": 150, 4691 "options": { 4692 "cellHeight": "sm", 4693 "footer": { 4694 "countRows": false, 4695 "fields": "", 4696 "reducer": ["sum"], 4697 "show": false 4698 }, 4699 "showHeader": true, 4700 "sortBy": [] 4701 }, 4702 "pluginVersion": "10.3.1", 4703 "repeatDirection": "v", 4704 "targets": [ 4705 { 4706 "datasource": { 4707 "type": "prometheus", 4708 "uid": "${DS_PROMETHEUS}" 4709 }, 4710 "exemplar": true, 4711 "expr": "cnpg_pg_settings_setting{namespace=~\"$namespace\",pod=~\"$instances\"}", 4712 "format": "table", 4713 "instant": true, 4714 "interval": "", 4715 "legendFormat": "{{pod}}", 4716 "refId": "A" 4717 } 4718 ], 4719 "title": "Configurations", 4720 "transformations": [ 4721 { 4722 "id": "organize", 4723 "options": { 4724 "excludeByName": { 4725 "Time": true, 4726 "__name__": true, 4727 "container": true, 4728 "endpoint": true, 4729 "instance": true, 4730 "job": true, 4731 "name": false, 4732 "namespace": true, 4733 "pod": false 4734 }, 4735 "indexByName": { 4736 "Time": 0, 4737 "Value": 9, 4738 "__name__": 1, 4739 "container": 2, 4740 "endpoint": 3, 4741 "instance": 4, 4742 "job": 5, 4743 "name": 7, 4744 "namespace": 8, 4745 "pod": 6 4746 }, 4747 "renameByName": { 4748 "__name__": "", 4749 "name": "parameter" 4750 } 4751 } 4752 }, 4753 { 4754 "id": "groupingToMatrix", 4755 "options": { 4756 "columnField": "pod", 4757 "rowField": "parameter", 4758 "valueField": "Value" 4759 } 4760 }, 4761 { 4762 "id": "organize", 4763 "options": { 4764 "excludeByName": {}, 4765 "indexByName": {}, 4766 "renameByName": { 4767 "parameter\\pod": "parameter" 4768 } 4769 } 4770 } 4771 ], 4772 "type": "table" 4773 } 4774 ], 4775 "targets": [ 4776 { 4777 "datasource": { 4778 "uid": "prometheus" 4779 }, 4780 "refId": "A" 4781 } 4782 ], 4783 "title": "Configuration", 4784 "type": "row" 4785 }, 4786 { 4787 "collapsed": false, 4788 "datasource": { 4789 "uid": "prometheus" 4790 }, 4791 "gridPos": { 4792 "h": 1, 4793 "w": 24, 4794 "x": 0, 4795 "y": 19 4796 }, 4797 "id": 10, 4798 "panels": [], 4799 "targets": [ 4800 { 4801 "datasource": { 4802 "uid": "prometheus" 4803 }, 4804 "refId": "A" 4805 } 4806 ], 4807 "title": "Operational Stats", 4808 "type": "row" 4809 }, 4810 { 4811 "datasource": { 4812 "type": "prometheus", 4813 "uid": "${DS_PROMETHEUS}" 4814 }, 4815 "fieldConfig": { 4816 "defaults": { 4817 "color": { 4818 "mode": "palette-classic" 4819 }, 4820 "custom": { 4821 "axisBorderShow": false, 4822 "axisCenteredZero": false, 4823 "axisColorMode": "text", 4824 "axisLabel": "", 4825 "axisPlacement": "auto", 4826 "barAlignment": 0, 4827 "drawStyle": "line", 4828 "fillOpacity": 100, 4829 "gradientMode": "none", 4830 "hideFrom": { 4831 "legend": false, 4832 "tooltip": false, 4833 "viz": false 4834 }, 4835 "insertNulls": false, 4836 "lineInterpolation": "linear", 4837 "lineWidth": 2, 4838 "pointSize": 5, 4839 "scaleDistribution": { 4840 "log": 10, 4841 "type": "log" 4842 }, 4843 "showPoints": "never", 4844 "spanNulls": false, 4845 "stacking": { 4846 "group": "A", 4847 "mode": "normal" 4848 }, 4849 "thresholdsStyle": { 4850 "mode": "off" 4851 } 4852 }, 4853 "mappings": [], 4854 "min": 0, 4855 "thresholds": { 4856 "mode": "absolute", 4857 "steps": [ 4858 { 4859 "color": "green", 4860 "value": null 4861 }, 4862 { 4863 "color": "red", 4864 "value": 80 4865 } 4866 ] 4867 }, 4868 "unit": "short", 4869 "unitScale": true 4870 }, 4871 "overrides": [] 4872 }, 4873 "gridPos": { 4874 "h": 7, 4875 "w": 12, 4876 "x": 0, 4877 "y": 20 4878 }, 4879 "id": 273, 4880 "links": [], 4881 "options": { 4882 "legend": { 4883 "calcs": [], 4884 "displayMode": "list", 4885 "placement": "bottom", 4886 "showLegend": true 4887 }, 4888 "tooltip": { 4889 "mode": "multi", 4890 "sort": "desc" 4891 } 4892 }, 4893 "pluginVersion": "10.3.1", 4894 "targets": [ 4895 { 4896 "datasource": { 4897 "type": "prometheus", 4898 "uid": "${DS_PROMETHEUS}" 4899 }, 4900 "exemplar": true, 4901 "expr": "sum(node_namespace_pod_container:container_cpu_usage_seconds_total:sum_irate{pod=~\"$instances\", namespace=~\"$namespace\"}) by (pod)", 4902 "format": "time_series", 4903 "interval": "", 4904 "intervalFactor": 2, 4905 "legendFormat": "{{pod}}", 4906 "refId": "A", 4907 "step": 10 4908 } 4909 ], 4910 "title": "CPU Usage", 4911 "type": "timeseries" 4912 }, 4913 { 4914 "datasource": { 4915 "type": "prometheus", 4916 "uid": "${DS_PROMETHEUS}" 4917 }, 4918 "fieldConfig": { 4919 "defaults": { 4920 "color": { 4921 "mode": "palette-classic" 4922 }, 4923 "custom": { 4924 "axisBorderShow": false, 4925 "axisCenteredZero": false, 4926 "axisColorMode": "text", 4927 "axisLabel": "", 4928 "axisPlacement": "auto", 4929 "barAlignment": 0, 4930 "drawStyle": "line", 4931 "fillOpacity": 100, 4932 "gradientMode": "none", 4933 "hideFrom": { 4934 "legend": false, 4935 "tooltip": false, 4936 "viz": false 4937 }, 4938 "insertNulls": false, 4939 "lineInterpolation": "linear", 4940 "lineWidth": 2, 4941 "pointSize": 5, 4942 "scaleDistribution": { 4943 "type": "linear" 4944 }, 4945 "showPoints": "never", 4946 "spanNulls": false, 4947 "stacking": { 4948 "group": "A", 4949 "mode": "none" 4950 }, 4951 "thresholdsStyle": { 4952 "mode": "off" 4953 } 4954 }, 4955 "mappings": [], 4956 "min": 0, 4957 "thresholds": { 4958 "mode": "absolute", 4959 "steps": [ 4960 { 4961 "color": "green", 4962 "value": null 4963 }, 4964 { 4965 "color": "red", 4966 "value": 80 4967 } 4968 ] 4969 }, 4970 "unit": "bytes", 4971 "unitScale": true 4972 }, 4973 "overrides": [ 4974 { 4975 "matcher": { 4976 "id": "byName", 4977 "options": "quota - requests" 4978 }, 4979 "properties": [ 4980 { 4981 "id": "color", 4982 "value": { 4983 "fixedColor": "#F2495C", 4984 "mode": "fixed" 4985 } 4986 }, 4987 { 4988 "id": "custom.fillOpacity", 4989 "value": 0 4990 }, 4991 { 4992 "id": "custom.lineWidth", 4993 "value": 2 4994 }, 4995 { 4996 "id": "custom.stacking", 4997 "value": { 4998 "group": "A", 4999 "mode": "none" 5000 } 5001 }, 5002 { 5003 "id": "custom.lineStyle", 5004 "value": { 5005 "dash": [10, 10], 5006 "fill": "dash" 5007 } 5008 } 5009 ] 5010 }, 5011 { 5012 "matcher": { 5013 "id": "byName", 5014 "options": "quota - limits" 5015 }, 5016 "properties": [ 5017 { 5018 "id": "color", 5019 "value": { 5020 "fixedColor": "#FF9830", 5021 "mode": "fixed" 5022 } 5023 }, 5024 { 5025 "id": "custom.fillOpacity", 5026 "value": 0 5027 }, 5028 { 5029 "id": "custom.lineWidth", 5030 "value": 2 5031 }, 5032 { 5033 "id": "custom.stacking", 5034 "value": { 5035 "group": "A", 5036 "mode": "none" 5037 } 5038 }, 5039 { 5040 "id": "custom.lineStyle", 5041 "value": { 5042 "dash": [10, 10], 5043 "fill": "dash" 5044 } 5045 } 5046 ] 5047 } 5048 ] 5049 }, 5050 "gridPos": { 5051 "h": 7, 5052 "w": 12, 5053 "x": 12, 5054 "y": 20 5055 }, 5056 "id": 275, 5057 "links": [], 5058 "options": { 5059 "legend": { 5060 "calcs": [], 5061 "displayMode": "list", 5062 "placement": "bottom", 5063 "showLegend": true 5064 }, 5065 "tooltip": { 5066 "mode": "multi", 5067 "sort": "desc" 5068 } 5069 }, 5070 "pluginVersion": "10.3.1", 5071 "targets": [ 5072 { 5073 "datasource": { 5074 "type": "prometheus", 5075 "uid": "${DS_PROMETHEUS}" 5076 }, 5077 "exemplar": true, 5078 "expr": "sum(container_memory_working_set_bytes{pod=~\"$instances\", namespace=\"$namespace\", container!=\"\", image!=\"\"}) by (pod)", 5079 "format": "time_series", 5080 "interval": "", 5081 "intervalFactor": 2, 5082 "legendFormat": "{{pod}}", 5083 "refId": "A", 5084 "step": 10 5085 } 5086 ], 5087 "title": "Memory Usage (container memory working set)", 5088 "type": "timeseries" 5089 }, 5090 { 5091 "datasource": { 5092 "type": "prometheus", 5093 "uid": "${DS_PROMETHEUS}" 5094 }, 5095 "description": "", 5096 "fieldConfig": { 5097 "defaults": { 5098 "color": { 5099 "mode": "palette-classic" 5100 }, 5101 "custom": { 5102 "axisBorderShow": false, 5103 "axisCenteredZero": false, 5104 "axisColorMode": "text", 5105 "axisLabel": "", 5106 "axisPlacement": "auto", 5107 "barAlignment": 0, 5108 "drawStyle": "line", 5109 "fillOpacity": 10, 5110 "gradientMode": "opacity", 5111 "hideFrom": { 5112 "legend": false, 5113 "tooltip": false, 5114 "viz": false 5115 }, 5116 "insertNulls": false, 5117 "lineInterpolation": "linear", 5118 "lineWidth": 1, 5119 "pointSize": 5, 5120 "scaleDistribution": { 5121 "type": "linear" 5122 }, 5123 "showPoints": "never", 5124 "spanNulls": true, 5125 "stacking": { 5126 "group": "A", 5127 "mode": "none" 5128 }, 5129 "thresholdsStyle": { 5130 "mode": "off" 5131 } 5132 }, 5133 "mappings": [], 5134 "thresholds": { 5135 "mode": "absolute", 5136 "steps": [ 5137 { 5138 "color": "green", 5139 "value": null 5140 } 5141 ] 5142 }, 5143 "unitScale": true 5144 }, 5145 "overrides": [] 5146 }, 5147 "gridPos": { 5148 "h": 8, 5149 "w": 24, 5150 "x": 0, 5151 "y": 27 5152 }, 5153 "id": 39, 5154 "options": { 5155 "legend": { 5156 "calcs": [], 5157 "displayMode": "list", 5158 "placement": "bottom", 5159 "showLegend": true 5160 }, 5161 "tooltip": { 5162 "mode": "multi", 5163 "sort": "none" 5164 } 5165 }, 5166 "targets": [ 5167 { 5168 "datasource": { 5169 "type": "prometheus", 5170 "uid": "${DS_PROMETHEUS}" 5171 }, 5172 "exemplar": true, 5173 "expr": "sum(cnpg_backends_total{namespace=~\"$namespace\",pod=~\"$instances\"}) by (pod)", 5174 "hide": false, 5175 "interval": "", 5176 "legendFormat": "total ({{pod}})", 5177 "refId": "B" 5178 }, 5179 { 5180 "datasource": { 5181 "type": "prometheus", 5182 "uid": "${DS_PROMETHEUS}" 5183 }, 5184 "exemplar": true, 5185 "expr": "sum(cnpg_backends_total{namespace=~\"$namespace\",pod=~\"$instances\"}) by (state, pod)", 5186 "interval": "", 5187 "legendFormat": "{{state}} ({{pod}})", 5188 "refId": "A" 5189 } 5190 ], 5191 "title": "Session States", 5192 "type": "timeseries" 5193 }, 5194 { 5195 "datasource": { 5196 "type": "prometheus", 5197 "uid": "${DS_PROMETHEUS}" 5198 }, 5199 "fieldConfig": { 5200 "defaults": { 5201 "color": { 5202 "mode": "palette-classic" 5203 }, 5204 "custom": { 5205 "axisBorderShow": false, 5206 "axisCenteredZero": false, 5207 "axisColorMode": "text", 5208 "axisLabel": "", 5209 "axisPlacement": "auto", 5210 "barAlignment": 0, 5211 "drawStyle": "line", 5212 "fillOpacity": 10, 5213 "gradientMode": "opacity", 5214 "hideFrom": { 5215 "legend": false, 5216 "tooltip": false, 5217 "viz": false 5218 }, 5219 "insertNulls": false, 5220 "lineInterpolation": "linear", 5221 "lineWidth": 1, 5222 "pointSize": 5, 5223 "scaleDistribution": { 5224 "type": "linear" 5225 }, 5226 "showPoints": "never", 5227 "spanNulls": true, 5228 "stacking": { 5229 "group": "A", 5230 "mode": "none" 5231 }, 5232 "thresholdsStyle": { 5233 "mode": "off" 5234 } 5235 }, 5236 "mappings": [], 5237 "thresholds": { 5238 "mode": "absolute", 5239 "steps": [ 5240 { 5241 "color": "green" 5242 }, 5243 { 5244 "color": "red", 5245 "value": 80 5246 } 5247 ] 5248 }, 5249 "unitScale": true 5250 }, 5251 "overrides": [] 5252 }, 5253 "gridPos": { 5254 "h": 8, 5255 "w": 12, 5256 "x": 0, 5257 "y": 35 5258 }, 5259 "id": 50, 5260 "options": { 5261 "legend": { 5262 "calcs": [], 5263 "displayMode": "list", 5264 "placement": "bottom", 5265 "showLegend": true 5266 }, 5267 "tooltip": { 5268 "mode": "multi", 5269 "sort": "none" 5270 } 5271 }, 5272 "targets": [ 5273 { 5274 "datasource": { 5275 "type": "prometheus", 5276 "uid": "${DS_PROMETHEUS}" 5277 }, 5278 "editorMode": "code", 5279 "exemplar": true, 5280 "expr": "sum(rate(cnpg_pg_stat_database_xact_commit{namespace=~\"$namespace\",pod=~\"$instances\"}[5m])) by (pod)", 5281 "interval": "", 5282 "legendFormat": "committed ({{pod}})", 5283 "range": true, 5284 "refId": "A" 5285 }, 5286 { 5287 "datasource": { 5288 "type": "prometheus", 5289 "uid": "${DS_PROMETHEUS}" 5290 }, 5291 "exemplar": true, 5292 "expr": "sum(rate(cnpg_pg_stat_database_xact_rollback{namespace=~\"$namespace\",pod=~\"$instances\"}[5m])) by (pod)", 5293 "hide": false, 5294 "interval": "", 5295 "legendFormat": "rolled back ({{pod}})", 5296 "refId": "B" 5297 } 5298 ], 5299 "title": "Transactions [5m]", 5300 "type": "timeseries" 5301 }, 5302 { 5303 "datasource": { 5304 "type": "prometheus", 5305 "uid": "${DS_PROMETHEUS}" 5306 }, 5307 "description": "", 5308 "fieldConfig": { 5309 "defaults": { 5310 "color": { 5311 "mode": "palette-classic" 5312 }, 5313 "custom": { 5314 "axisBorderShow": false, 5315 "axisCenteredZero": false, 5316 "axisColorMode": "text", 5317 "axisLabel": "", 5318 "axisPlacement": "auto", 5319 "barAlignment": 0, 5320 "drawStyle": "line", 5321 "fillOpacity": 10, 5322 "gradientMode": "none", 5323 "hideFrom": { 5324 "legend": false, 5325 "tooltip": false, 5326 "viz": false 5327 }, 5328 "insertNulls": false, 5329 "lineInterpolation": "linear", 5330 "lineWidth": 1, 5331 "pointSize": 5, 5332 "scaleDistribution": { 5333 "type": "linear" 5334 }, 5335 "showPoints": "never", 5336 "spanNulls": true, 5337 "stacking": { 5338 "group": "A", 5339 "mode": "none" 5340 }, 5341 "thresholdsStyle": { 5342 "mode": "off" 5343 } 5344 }, 5345 "mappings": [], 5346 "thresholds": { 5347 "mode": "absolute", 5348 "steps": [ 5349 { 5350 "color": "green" 5351 }, 5352 { 5353 "color": "red", 5354 "value": 80 5355 } 5356 ] 5357 }, 5358 "unit": "s", 5359 "unitScale": true 5360 }, 5361 "overrides": [] 5362 }, 5363 "gridPos": { 5364 "h": 8, 5365 "w": 12, 5366 "x": 12, 5367 "y": 35 5368 }, 5369 "id": 4, 5370 "options": { 5371 "legend": { 5372 "calcs": [], 5373 "displayMode": "list", 5374 "placement": "bottom", 5375 "showLegend": true 5376 }, 5377 "tooltip": { 5378 "mode": "multi", 5379 "sort": "none" 5380 } 5381 }, 5382 "targets": [ 5383 { 5384 "datasource": { 5385 "type": "prometheus", 5386 "uid": "${DS_PROMETHEUS}" 5387 }, 5388 "exemplar": true, 5389 "expr": "max by (pod) (cnpg_backends_max_tx_duration_seconds{namespace=~\"$namespace\",pod=~\"$instances\"})", 5390 "interval": "", 5391 "legendFormat": "{{pod}}", 5392 "refId": "A" 5393 } 5394 ], 5395 "title": "Longest Transaction", 5396 "type": "timeseries" 5397 }, 5398 { 5399 "datasource": { 5400 "type": "prometheus", 5401 "uid": "${DS_PROMETHEUS}" 5402 }, 5403 "description": "", 5404 "fieldConfig": { 5405 "defaults": { 5406 "color": { 5407 "mode": "palette-classic" 5408 }, 5409 "custom": { 5410 "axisBorderShow": false, 5411 "axisCenteredZero": false, 5412 "axisColorMode": "text", 5413 "axisLabel": "", 5414 "axisPlacement": "auto", 5415 "barAlignment": 0, 5416 "drawStyle": "line", 5417 "fillOpacity": 10, 5418 "gradientMode": "none", 5419 "hideFrom": { 5420 "legend": false, 5421 "tooltip": false, 5422 "viz": false 5423 }, 5424 "insertNulls": false, 5425 "lineInterpolation": "linear", 5426 "lineWidth": 1, 5427 "pointSize": 5, 5428 "scaleDistribution": { 5429 "type": "linear" 5430 }, 5431 "showPoints": "never", 5432 "spanNulls": true, 5433 "stacking": { 5434 "group": "A", 5435 "mode": "none" 5436 }, 5437 "thresholdsStyle": { 5438 "mode": "off" 5439 } 5440 }, 5441 "mappings": [], 5442 "thresholds": { 5443 "mode": "absolute", 5444 "steps": [ 5445 { 5446 "color": "green" 5447 }, 5448 { 5449 "color": "red", 5450 "value": 80 5451 } 5452 ] 5453 }, 5454 "unitScale": true 5455 }, 5456 "overrides": [] 5457 }, 5458 "gridPos": { 5459 "h": 8, 5460 "w": 12, 5461 "x": 0, 5462 "y": 43 5463 }, 5464 "id": 55, 5465 "options": { 5466 "legend": { 5467 "calcs": [], 5468 "displayMode": "list", 5469 "placement": "bottom", 5470 "showLegend": true 5471 }, 5472 "tooltip": { 5473 "mode": "multi", 5474 "sort": "none" 5475 } 5476 }, 5477 "targets": [ 5478 { 5479 "datasource": { 5480 "type": "prometheus", 5481 "uid": "${DS_PROMETHEUS}" 5482 }, 5483 "exemplar": true, 5484 "expr": "rate(cnpg_pg_stat_database_deadlocks{datname=\"\",namespace=~\"$namespace\",pod=~\"$instances\"}[5m])", 5485 "hide": false, 5486 "instant": false, 5487 "interval": "", 5488 "legendFormat": "count ({{pod}})", 5489 "refId": "B" 5490 } 5491 ], 5492 "title": "Deadlocks [5m]", 5493 "type": "timeseries" 5494 }, 5495 { 5496 "datasource": { 5497 "type": "prometheus", 5498 "uid": "${DS_PROMETHEUS}" 5499 }, 5500 "description": "", 5501 "fieldConfig": { 5502 "defaults": { 5503 "color": { 5504 "mode": "palette-classic" 5505 }, 5506 "custom": { 5507 "axisBorderShow": false, 5508 "axisCenteredZero": false, 5509 "axisColorMode": "text", 5510 "axisLabel": "", 5511 "axisPlacement": "auto", 5512 "barAlignment": 0, 5513 "drawStyle": "line", 5514 "fillOpacity": 10, 5515 "gradientMode": "none", 5516 "hideFrom": { 5517 "legend": false, 5518 "tooltip": false, 5519 "viz": false 5520 }, 5521 "insertNulls": false, 5522 "lineInterpolation": "linear", 5523 "lineWidth": 1, 5524 "pointSize": 5, 5525 "scaleDistribution": { 5526 "type": "linear" 5527 }, 5528 "showPoints": "never", 5529 "spanNulls": true, 5530 "stacking": { 5531 "group": "A", 5532 "mode": "none" 5533 }, 5534 "thresholdsStyle": { 5535 "mode": "off" 5536 } 5537 }, 5538 "mappings": [], 5539 "thresholds": { 5540 "mode": "absolute", 5541 "steps": [ 5542 { 5543 "color": "green" 5544 }, 5545 { 5546 "color": "red", 5547 "value": 80 5548 } 5549 ] 5550 }, 5551 "unitScale": true 5552 }, 5553 "overrides": [] 5554 }, 5555 "gridPos": { 5556 "h": 8, 5557 "w": 12, 5558 "x": 12, 5559 "y": 43 5560 }, 5561 "id": 54, 5562 "options": { 5563 "legend": { 5564 "calcs": [], 5565 "displayMode": "list", 5566 "placement": "bottom", 5567 "showLegend": true 5568 }, 5569 "tooltip": { 5570 "mode": "multi", 5571 "sort": "none" 5572 } 5573 }, 5574 "targets": [ 5575 { 5576 "datasource": { 5577 "type": "prometheus", 5578 "uid": "${DS_PROMETHEUS}" 5579 }, 5580 "exemplar": true, 5581 "expr": "cnpg_backends_waiting_total{namespace=~\"$namespace\",pod=~\"$instances\"}", 5582 "interval": "", 5583 "legendFormat": "{{pod}}", 5584 "refId": "A" 5585 } 5586 ], 5587 "title": "Blocked Queries", 5588 "type": "timeseries" 5589 }, 5590 { 5591 "collapsed": true, 5592 "datasource": { 5593 "uid": "prometheus" 5594 }, 5595 "gridPos": { 5596 "h": 1, 5597 "w": 24, 5598 "x": 0, 5599 "y": 51 5600 }, 5601 "id": 35, 5602 "panels": [ 5603 { 5604 "datasource": { 5605 "type": "prometheus", 5606 "uid": "${DS_PROMETHEUS}" 5607 }, 5608 "fieldConfig": { 5609 "defaults": { 5610 "color": { 5611 "mode": "thresholds" 5612 }, 5613 "mappings": [], 5614 "max": 1, 5615 "min": 0, 5616 "thresholds": { 5617 "mode": "absolute", 5618 "steps": [ 5619 { 5620 "color": "green" 5621 }, 5622 { 5623 "color": "#EAB839", 5624 "value": 0.7 5625 }, 5626 { 5627 "color": "red", 5628 "value": 0.8 5629 } 5630 ] 5631 }, 5632 "unit": "percentunit", 5633 "unitScale": true 5634 }, 5635 "overrides": [] 5636 }, 5637 "gridPos": { 5638 "h": 8, 5639 "w": 12, 5640 "x": 0, 5641 "y": 52 5642 }, 5643 "id": 424, 5644 "options": { 5645 "minVizHeight": 75, 5646 "minVizWidth": 75, 5647 "orientation": "auto", 5648 "reduceOptions": { 5649 "calcs": ["lastNotNull"], 5650 "fields": "", 5651 "values": false 5652 }, 5653 "showThresholdLabels": false, 5654 "showThresholdMarkers": true, 5655 "sizing": "auto", 5656 "text": {} 5657 }, 5658 "pluginVersion": "10.3.3", 5659 "targets": [ 5660 { 5661 "datasource": { 5662 "type": "prometheus", 5663 "uid": "${DS_PROMETHEUS}" 5664 }, 5665 "editorMode": "code", 5666 "expr": "max by(persistentvolumeclaim) (1 - kubelet_volume_stats_available_bytes{namespace=\"$namespace\", persistentvolumeclaim=~\"$instances\"} / kubelet_volume_stats_capacity_bytes{namespace=\"$namespace\", persistentvolumeclaim=~\"$instances\"})", 5667 "format": "time_series", 5668 "interval": "", 5669 "legendFormat": "{{persistentvolumeclaim}}", 5670 "range": true, 5671 "refId": "FREE_SPACE" 5672 }, 5673 { 5674 "datasource": { 5675 "type": "prometheus", 5676 "uid": "${DS_PROMETHEUS}" 5677 }, 5678 "editorMode": "code", 5679 "expr": "max by(persistentvolumeclaim) (1 - kubelet_volume_stats_available_bytes{namespace=\"$namespace\", persistentvolumeclaim=~\"(${instances})-wal\"} / kubelet_volume_stats_capacity_bytes{namespace=\"$namespace\", persistentvolumeclaim=~\"(${instances})-wal\"})", 5680 "format": "time_series", 5681 "interval": "", 5682 "legendFormat": "{{persistentvolumeclaim}}", 5683 "range": true, 5684 "refId": "FREE_SPACE_WAL" 5685 } 5686 ], 5687 "title": "Volume Space Usage: PGDATA and WAL", 5688 "transformations": [], 5689 "type": "gauge" 5690 }, 5691 { 5692 "datasource": { 5693 "type": "prometheus", 5694 "uid": "${DS_PROMETHEUS}" 5695 }, 5696 "fieldConfig": { 5697 "defaults": { 5698 "color": { 5699 "mode": "thresholds" 5700 }, 5701 "decimals": 2, 5702 "mappings": [], 5703 "max": 1, 5704 "min": 0, 5705 "thresholds": { 5706 "mode": "absolute", 5707 "steps": [ 5708 { 5709 "color": "green" 5710 }, 5711 { 5712 "color": "#EAB839", 5713 "value": 0.8 5714 }, 5715 { 5716 "color": "red", 5717 "value": 0.9 5718 } 5719 ] 5720 }, 5721 "unit": "percentunit", 5722 "unitScale": true 5723 }, 5724 "overrides": [] 5725 }, 5726 "gridPos": { 5727 "h": 8, 5728 "w": 12, 5729 "x": 12, 5730 "y": 52 5731 }, 5732 "id": 426, 5733 "options": { 5734 "minVizHeight": 75, 5735 "minVizWidth": 75, 5736 "orientation": "auto", 5737 "reduceOptions": { 5738 "calcs": ["lastNotNull"], 5739 "fields": "", 5740 "values": false 5741 }, 5742 "showThresholdLabels": false, 5743 "showThresholdMarkers": true, 5744 "sizing": "auto" 5745 }, 5746 "pluginVersion": "10.3.3", 5747 "targets": [ 5748 { 5749 "datasource": { 5750 "type": "prometheus", 5751 "uid": "${DS_PROMETHEUS}" 5752 }, 5753 "editorMode": "code", 5754 "expr": "max by(persistentvolumeclaim) (kubelet_volume_stats_inodes_used{namespace=\"$namespace\", persistentvolumeclaim=~\"$instances\"} / kubelet_volume_stats_inodes{namespace=\"$namespace\", persistentvolumeclaim=~\"$instances\"})", 5755 "format": "time_series", 5756 "interval": "", 5757 "legendFormat": "{{persistentvolumeclaim}}", 5758 "range": true, 5759 "refId": "FREE_INODES" 5760 }, 5761 { 5762 "datasource": { 5763 "type": "prometheus", 5764 "uid": "${DS_PROMETHEUS}" 5765 }, 5766 "editorMode": "code", 5767 "expr": "max by(persistentvolumeclaim) (kubelet_volume_stats_inodes_used{namespace=\"$namespace\", persistentvolumeclaim=~\"(${instances})-wal\"} / kubelet_volume_stats_inodes{namespace=\"$namespace\", persistentvolumeclaim=~\"(${instances})-wal\"})", 5768 "format": "time_series", 5769 "interval": "", 5770 "legendFormat": "{{persistentvolumeclaim}}", 5771 "range": true, 5772 "refId": "FREE_INODES_WAL" 5773 } 5774 ], 5775 "title": "Volume Inode Usage: PGDATA and WAL", 5776 "transformations": [], 5777 "type": "gauge" 5778 }, 5779 { 5780 "datasource": { 5781 "type": "prometheus", 5782 "uid": "${DS_PROMETHEUS}" 5783 }, 5784 "fieldConfig": { 5785 "defaults": { 5786 "color": { 5787 "mode": "thresholds" 5788 }, 5789 "mappings": [], 5790 "max": 1, 5791 "min": 0, 5792 "thresholds": { 5793 "mode": "absolute", 5794 "steps": [ 5795 { 5796 "color": "green" 5797 }, 5798 { 5799 "color": "#EAB839", 5800 "value": 0.7 5801 }, 5802 { 5803 "color": "red", 5804 "value": 0.8 5805 } 5806 ] 5807 }, 5808 "unit": "percentunit", 5809 "unitScale": true 5810 }, 5811 "overrides": [] 5812 }, 5813 "gridPos": { 5814 "h": 7, 5815 "w": 24, 5816 "x": 0, 5817 "y": 60 5818 }, 5819 "id": 564, 5820 "options": { 5821 "minVizHeight": 75, 5822 "minVizWidth": 75, 5823 "orientation": "auto", 5824 "reduceOptions": { 5825 "calcs": ["lastNotNull"], 5826 "fields": "", 5827 "values": false 5828 }, 5829 "showThresholdLabels": false, 5830 "showThresholdMarkers": true, 5831 "sizing": "auto", 5832 "text": {} 5833 }, 5834 "pluginVersion": "10.3.3", 5835 "targets": [ 5836 { 5837 "datasource": { 5838 "type": "prometheus", 5839 "uid": "${DS_PROMETHEUS}" 5840 }, 5841 "editorMode": "code", 5842 "expr": "sum by (namespace,persistentvolumeclaim) (kubelet_volume_stats_used_bytes{namespace=\"$namespace\", persistentvolumeclaim=~\"(${instances})-tbs.*\"}) \n/\nsum by (namespace,persistentvolumeclaim) (kubelet_volume_stats_capacity_bytes{namespace=\"$namespace\", persistentvolumeclaim=~\"(${instances})-tbs.*\"}) \n*\non(namespace, persistentvolumeclaim) group_left(volume,pod)\nkube_pod_spec_volumes_persistentvolumeclaims_info{pod=~\"$instances\"}", 5843 "format": "time_series", 5844 "interval": "", 5845 "legendFormat": "{{volume}}-{{pod}}", 5846 "range": true, 5847 "refId": "FREE_SPACE" 5848 } 5849 ], 5850 "title": "Volume Space Usage: Tablespaces", 5851 "transformations": [], 5852 "type": "gauge" 5853 }, 5854 { 5855 "datasource": { 5856 "type": "prometheus", 5857 "uid": "${DS_PROMETHEUS}" 5858 }, 5859 "fieldConfig": { 5860 "defaults": { 5861 "color": { 5862 "mode": "palette-classic" 5863 }, 5864 "custom": { 5865 "axisBorderShow": false, 5866 "axisCenteredZero": false, 5867 "axisColorMode": "text", 5868 "axisLabel": "", 5869 "axisPlacement": "auto", 5870 "barAlignment": 0, 5871 "drawStyle": "line", 5872 "fillOpacity": 10, 5873 "gradientMode": "none", 5874 "hideFrom": { 5875 "legend": false, 5876 "tooltip": false, 5877 "viz": false 5878 }, 5879 "insertNulls": false, 5880 "lineInterpolation": "linear", 5881 "lineWidth": 1, 5882 "pointSize": 5, 5883 "scaleDistribution": { 5884 "type": "linear" 5885 }, 5886 "showPoints": "never", 5887 "spanNulls": true, 5888 "stacking": { 5889 "group": "A", 5890 "mode": "none" 5891 }, 5892 "thresholdsStyle": { 5893 "mode": "off" 5894 } 5895 }, 5896 "mappings": [], 5897 "thresholds": { 5898 "mode": "absolute", 5899 "steps": [ 5900 { 5901 "color": "green" 5902 }, 5903 { 5904 "color": "red", 5905 "value": 80 5906 } 5907 ] 5908 }, 5909 "unitScale": true 5910 }, 5911 "overrides": [] 5912 }, 5913 "gridPos": { 5914 "h": 8, 5915 "w": 12, 5916 "x": 0, 5917 "y": 67 5918 }, 5919 "id": 44, 5920 "options": { 5921 "legend": { 5922 "calcs": [], 5923 "displayMode": "list", 5924 "placement": "bottom", 5925 "showLegend": true 5926 }, 5927 "tooltip": { 5928 "mode": "multi", 5929 "sort": "none" 5930 } 5931 }, 5932 "targets": [ 5933 { 5934 "datasource": { 5935 "type": "prometheus", 5936 "uid": "${DS_PROMETHEUS}" 5937 }, 5938 "editorMode": "code", 5939 "exemplar": true, 5940 "expr": "sum(rate(cnpg_pg_stat_database_tup_deleted{datname=\"\",namespace=~\"$namespace\",pod=~\"$instances\"}[5m]))", 5941 "interval": "", 5942 "legendFormat": "deleted", 5943 "range": true, 5944 "refId": "A" 5945 }, 5946 { 5947 "datasource": { 5948 "type": "prometheus", 5949 "uid": "${DS_PROMETHEUS}" 5950 }, 5951 "editorMode": "code", 5952 "exemplar": true, 5953 "expr": "sum(rate(cnpg_pg_stat_database_tup_inserted{datname=\"\",namespace=~\"$namespace\",pod=~\"$instances\"}[5m]))", 5954 "hide": false, 5955 "interval": "", 5956 "legendFormat": "inserted", 5957 "range": true, 5958 "refId": "B" 5959 }, 5960 { 5961 "datasource": { 5962 "type": "prometheus", 5963 "uid": "${DS_PROMETHEUS}" 5964 }, 5965 "editorMode": "code", 5966 "exemplar": true, 5967 "expr": "sum(rate(cnpg_pg_stat_database_tup_fetched{datname=\"\",namespace=~\"$namespace\",pod=~\"$instances\"}[5m]))", 5968 "hide": false, 5969 "interval": "", 5970 "legendFormat": "fetched", 5971 "range": true, 5972 "refId": "C" 5973 }, 5974 { 5975 "datasource": { 5976 "type": "prometheus", 5977 "uid": "${DS_PROMETHEUS}" 5978 }, 5979 "editorMode": "code", 5980 "exemplar": true, 5981 "expr": "sum(rate(cnpg_pg_stat_database_tup_returned{datname=\"\",namespace=~\"$namespace\",pod=~\"$instances\"}[5m]))", 5982 "hide": false, 5983 "interval": "", 5984 "legendFormat": "returned", 5985 "range": true, 5986 "refId": "D" 5987 }, 5988 { 5989 "datasource": { 5990 "type": "prometheus", 5991 "uid": "${DS_PROMETHEUS}" 5992 }, 5993 "editorMode": "code", 5994 "exemplar": true, 5995 "expr": "sum(rate(cnpg_pg_stat_database_tup_updated{datname=\"\",namespace=~\"$namespace\",pod=~\"$instances\"}[5m]))", 5996 "hide": false, 5997 "interval": "", 5998 "legendFormat": "updated", 5999 "range": true, 6000 "refId": "E" 6001 } 6002 ], 6003 "title": "Tuple I/O [5m]", 6004 "type": "timeseries" 6005 }, 6006 { 6007 "datasource": { 6008 "type": "prometheus", 6009 "uid": "${DS_PROMETHEUS}" 6010 }, 6011 "fieldConfig": { 6012 "defaults": { 6013 "color": { 6014 "mode": "palette-classic" 6015 }, 6016 "custom": { 6017 "axisBorderShow": false, 6018 "axisCenteredZero": false, 6019 "axisColorMode": "text", 6020 "axisLabel": "", 6021 "axisPlacement": "auto", 6022 "barAlignment": 0, 6023 "drawStyle": "line", 6024 "fillOpacity": 10, 6025 "gradientMode": "none", 6026 "hideFrom": { 6027 "legend": false, 6028 "tooltip": false, 6029 "viz": false 6030 }, 6031 "insertNulls": false, 6032 "lineInterpolation": "linear", 6033 "lineWidth": 1, 6034 "pointSize": 5, 6035 "scaleDistribution": { 6036 "type": "linear" 6037 }, 6038 "showPoints": "never", 6039 "spanNulls": true, 6040 "stacking": { 6041 "group": "A", 6042 "mode": "none" 6043 }, 6044 "thresholdsStyle": { 6045 "mode": "off" 6046 } 6047 }, 6048 "mappings": [], 6049 "thresholds": { 6050 "mode": "absolute", 6051 "steps": [ 6052 { 6053 "color": "green" 6054 }, 6055 { 6056 "color": "red", 6057 "value": 80 6058 } 6059 ] 6060 }, 6061 "unitScale": true 6062 }, 6063 "overrides": [] 6064 }, 6065 "gridPos": { 6066 "h": 8, 6067 "w": 12, 6068 "x": 12, 6069 "y": 67 6070 }, 6071 "id": 46, 6072 "options": { 6073 "legend": { 6074 "calcs": [], 6075 "displayMode": "list", 6076 "placement": "bottom", 6077 "showLegend": true 6078 }, 6079 "tooltip": { 6080 "mode": "multi", 6081 "sort": "none" 6082 } 6083 }, 6084 "targets": [ 6085 { 6086 "datasource": { 6087 "type": "prometheus", 6088 "uid": "${DS_PROMETHEUS}" 6089 }, 6090 "editorMode": "code", 6091 "exemplar": true, 6092 "expr": "rate(cnpg_pg_stat_database_blks_hit{datname=\"\",namespace=~\"$namespace\",pod=~\"$instances\"}[5m])", 6093 "interval": "", 6094 "legendFormat": "hit ({{pod}})", 6095 "range": true, 6096 "refId": "A" 6097 }, 6098 { 6099 "datasource": { 6100 "type": "prometheus", 6101 "uid": "${DS_PROMETHEUS}" 6102 }, 6103 "editorMode": "code", 6104 "exemplar": true, 6105 "expr": "rate(cnpg_pg_stat_database_blks_read{datname=\"\",namespace=~\"$namespace\",pod=~\"$instances\"}[5m])", 6106 "hide": false, 6107 "interval": "", 6108 "legendFormat": "read ({{pod}})", 6109 "range": true, 6110 "refId": "B" 6111 } 6112 ], 6113 "title": "Block I/O [5m]", 6114 "type": "timeseries" 6115 }, 6116 { 6117 "datasource": { 6118 "type": "prometheus", 6119 "uid": "${DS_PROMETHEUS}" 6120 }, 6121 "fieldConfig": { 6122 "defaults": { 6123 "color": { 6124 "mode": "palette-classic" 6125 }, 6126 "custom": { 6127 "axisBorderShow": false, 6128 "axisCenteredZero": false, 6129 "axisColorMode": "text", 6130 "axisLabel": "", 6131 "axisPlacement": "auto", 6132 "barAlignment": 0, 6133 "drawStyle": "line", 6134 "fillOpacity": 10, 6135 "gradientMode": "none", 6136 "hideFrom": { 6137 "legend": false, 6138 "tooltip": false, 6139 "viz": false 6140 }, 6141 "insertNulls": false, 6142 "lineInterpolation": "linear", 6143 "lineWidth": 1, 6144 "pointSize": 5, 6145 "scaleDistribution": { 6146 "type": "linear" 6147 }, 6148 "showPoints": "never", 6149 "spanNulls": true, 6150 "stacking": { 6151 "group": "A", 6152 "mode": "none" 6153 }, 6154 "thresholdsStyle": { 6155 "mode": "off" 6156 } 6157 }, 6158 "mappings": [], 6159 "thresholds": { 6160 "mode": "absolute", 6161 "steps": [ 6162 { 6163 "color": "green" 6164 } 6165 ] 6166 }, 6167 "unit": "decbytes", 6168 "unitScale": true 6169 }, 6170 "overrides": [] 6171 }, 6172 "gridPos": { 6173 "h": 8, 6174 "w": 12, 6175 "x": 0, 6176 "y": 75 6177 }, 6178 "id": 22, 6179 "options": { 6180 "legend": { 6181 "calcs": [], 6182 "displayMode": "list", 6183 "placement": "bottom", 6184 "showLegend": true 6185 }, 6186 "tooltip": { 6187 "mode": "multi", 6188 "sort": "none" 6189 } 6190 }, 6191 "pluginVersion": "8.0.5", 6192 "targets": [ 6193 { 6194 "datasource": { 6195 "type": "prometheus", 6196 "uid": "${DS_PROMETHEUS}" 6197 }, 6198 "editorMode": "code", 6199 "exemplar": true, 6200 "expr": "max by (datname) (cnpg_pg_database_size_bytes{datname!~\"template.*\",datname!=\"postgres\",namespace=~\"$namespace\",pod=~\"$instances\"})", 6201 "interval": "", 6202 "legendFormat": " {{pod}}: {{datname}}", 6203 "range": true, 6204 "refId": "A" 6205 } 6206 ], 6207 "title": "Database Size", 6208 "type": "timeseries" 6209 }, 6210 { 6211 "datasource": { 6212 "type": "prometheus", 6213 "uid": "${DS_PROMETHEUS}" 6214 }, 6215 "fieldConfig": { 6216 "defaults": { 6217 "color": { 6218 "mode": "palette-classic" 6219 }, 6220 "custom": { 6221 "axisBorderShow": false, 6222 "axisCenteredZero": false, 6223 "axisColorMode": "text", 6224 "axisLabel": "", 6225 "axisPlacement": "auto", 6226 "barAlignment": 0, 6227 "drawStyle": "line", 6228 "fillOpacity": 10, 6229 "gradientMode": "none", 6230 "hideFrom": { 6231 "legend": false, 6232 "tooltip": false, 6233 "viz": false 6234 }, 6235 "insertNulls": false, 6236 "lineInterpolation": "linear", 6237 "lineWidth": 1, 6238 "pointSize": 5, 6239 "scaleDistribution": { 6240 "type": "linear" 6241 }, 6242 "showPoints": "never", 6243 "spanNulls": true, 6244 "stacking": { 6245 "group": "A", 6246 "mode": "none" 6247 }, 6248 "thresholdsStyle": { 6249 "mode": "off" 6250 } 6251 }, 6252 "mappings": [], 6253 "thresholds": { 6254 "mode": "absolute", 6255 "steps": [ 6256 { 6257 "color": "green" 6258 }, 6259 { 6260 "color": "red", 6261 "value": 80 6262 } 6263 ] 6264 }, 6265 "unit": "decbytes", 6266 "unitScale": true 6267 }, 6268 "overrides": [] 6269 }, 6270 "gridPos": { 6271 "h": 8, 6272 "w": 12, 6273 "x": 12, 6274 "y": 75 6275 }, 6276 "id": 2, 6277 "options": { 6278 "legend": { 6279 "calcs": [], 6280 "displayMode": "list", 6281 "placement": "bottom", 6282 "showLegend": true 6283 }, 6284 "tooltip": { 6285 "mode": "multi", 6286 "sort": "none" 6287 } 6288 }, 6289 "targets": [ 6290 { 6291 "datasource": { 6292 "type": "prometheus", 6293 "uid": "${DS_PROMETHEUS}" 6294 }, 6295 "exemplar": true, 6296 "expr": "rate(cnpg_pg_stat_database_temp_bytes{datname=\"\",namespace=~\"$namespace\",pod=~\"$instances\"}[5m])", 6297 "instant": false, 6298 "interval": "", 6299 "legendFormat": "{{pod}}", 6300 "refId": "A" 6301 } 6302 ], 6303 "title": "Temp Bytes [5m]", 6304 "type": "timeseries" 6305 } 6306 ], 6307 "targets": [ 6308 { 6309 "datasource": { 6310 "uid": "prometheus" 6311 }, 6312 "refId": "A" 6313 } 6314 ], 6315 "title": "Storage & I/O", 6316 "type": "row" 6317 }, 6318 { 6319 "collapsed": true, 6320 "datasource": { 6321 "uid": "prometheus" 6322 }, 6323 "gridPos": { 6324 "h": 1, 6325 "w": 24, 6326 "x": 0, 6327 "y": 52 6328 }, 6329 "id": 37, 6330 "panels": [ 6331 { 6332 "datasource": { 6333 "type": "prometheus", 6334 "uid": "${DS_PROMETHEUS}" 6335 }, 6336 "fieldConfig": { 6337 "defaults": { 6338 "color": { 6339 "mode": "palette-classic" 6340 }, 6341 "custom": { 6342 "axisBorderShow": false, 6343 "axisCenteredZero": false, 6344 "axisColorMode": "text", 6345 "axisLabel": "", 6346 "axisPlacement": "auto", 6347 "barAlignment": 0, 6348 "drawStyle": "line", 6349 "fillOpacity": 10, 6350 "gradientMode": "none", 6351 "hideFrom": { 6352 "legend": false, 6353 "tooltip": false, 6354 "viz": false 6355 }, 6356 "insertNulls": false, 6357 "lineInterpolation": "linear", 6358 "lineWidth": 1, 6359 "pointSize": 5, 6360 "scaleDistribution": { 6361 "type": "linear" 6362 }, 6363 "showPoints": "never", 6364 "spanNulls": true, 6365 "stacking": { 6366 "group": "A", 6367 "mode": "none" 6368 }, 6369 "thresholdsStyle": { 6370 "mode": "off" 6371 } 6372 }, 6373 "mappings": [], 6374 "thresholds": { 6375 "mode": "absolute", 6376 "steps": [ 6377 { 6378 "color": "green" 6379 }, 6380 { 6381 "color": "red", 6382 "value": 80 6383 } 6384 ] 6385 }, 6386 "unitScale": true 6387 }, 6388 "overrides": [] 6389 }, 6390 "gridPos": { 6391 "h": 8, 6392 "w": 8, 6393 "x": 0, 6394 "y": 53 6395 }, 6396 "id": 6, 6397 "options": { 6398 "legend": { 6399 "calcs": [], 6400 "displayMode": "list", 6401 "placement": "bottom", 6402 "showLegend": true 6403 }, 6404 "tooltip": { 6405 "mode": "multi", 6406 "sort": "none" 6407 } 6408 }, 6409 "targets": [ 6410 { 6411 "datasource": { 6412 "type": "prometheus", 6413 "uid": "${DS_PROMETHEUS}" 6414 }, 6415 "exemplar": true, 6416 "expr": "cnpg_collector_pg_wal_archive_status{value=\"ready\",namespace=~\"$namespace\",pod=~\"$instances\"}", 6417 "interval": "", 6418 "legendFormat": "ready ({{pod}})", 6419 "refId": "A" 6420 }, 6421 { 6422 "datasource": { 6423 "type": "prometheus", 6424 "uid": "${DS_PROMETHEUS}" 6425 }, 6426 "exemplar": true, 6427 "expr": "cnpg_collector_pg_wal_archive_status{value=\"done\",namespace=~\"$namespace\",pod=~\"$instances\"}", 6428 "hide": false, 6429 "interval": "", 6430 "legendFormat": "done ({{pod}})", 6431 "refId": "B" 6432 } 6433 ], 6434 "title": "WAL Segment Archive Status", 6435 "type": "timeseries" 6436 }, 6437 { 6438 "datasource": { 6439 "type": "prometheus", 6440 "uid": "${DS_PROMETHEUS}" 6441 }, 6442 "fieldConfig": { 6443 "defaults": { 6444 "color": { 6445 "mode": "palette-classic" 6446 }, 6447 "custom": { 6448 "axisBorderShow": false, 6449 "axisCenteredZero": false, 6450 "axisColorMode": "text", 6451 "axisLabel": "", 6452 "axisPlacement": "auto", 6453 "barAlignment": 0, 6454 "drawStyle": "line", 6455 "fillOpacity": 10, 6456 "gradientMode": "none", 6457 "hideFrom": { 6458 "legend": false, 6459 "tooltip": false, 6460 "viz": false 6461 }, 6462 "insertNulls": false, 6463 "lineInterpolation": "linear", 6464 "lineWidth": 1, 6465 "pointSize": 5, 6466 "scaleDistribution": { 6467 "type": "linear" 6468 }, 6469 "showPoints": "never", 6470 "spanNulls": true, 6471 "stacking": { 6472 "group": "A", 6473 "mode": "none" 6474 }, 6475 "thresholdsStyle": { 6476 "mode": "off" 6477 } 6478 }, 6479 "mappings": [], 6480 "thresholds": { 6481 "mode": "absolute", 6482 "steps": [ 6483 { 6484 "color": "green" 6485 }, 6486 { 6487 "color": "red", 6488 "value": 80 6489 } 6490 ] 6491 }, 6492 "unitScale": true 6493 }, 6494 "overrides": [] 6495 }, 6496 "gridPos": { 6497 "h": 8, 6498 "w": 8, 6499 "x": 8, 6500 "y": 53 6501 }, 6502 "id": 52, 6503 "options": { 6504 "legend": { 6505 "calcs": [], 6506 "displayMode": "list", 6507 "placement": "bottom", 6508 "showLegend": true 6509 }, 6510 "tooltip": { 6511 "mode": "multi", 6512 "sort": "none" 6513 } 6514 }, 6515 "targets": [ 6516 { 6517 "datasource": { 6518 "type": "prometheus", 6519 "uid": "${DS_PROMETHEUS}" 6520 }, 6521 "exemplar": true, 6522 "expr": "rate(cnpg_pg_stat_archiver_archived_count{namespace=~\"$namespace\",pod=~\"$instances\"}[5m])", 6523 "interval": "", 6524 "legendFormat": "archived ({{pod}})", 6525 "refId": "A" 6526 }, 6527 { 6528 "datasource": { 6529 "type": "prometheus", 6530 "uid": "${DS_PROMETHEUS}" 6531 }, 6532 "exemplar": true, 6533 "expr": "rate(cnpg_pg_stat_archiver_failed_count{namespace=~\"$namespace\",pod=~\"$instances\"}[5m])", 6534 "hide": false, 6535 "interval": "", 6536 "legendFormat": "failed ({{pod}})", 6537 "refId": "B" 6538 } 6539 ], 6540 "title": "Archiver Status [5m]", 6541 "type": "timeseries" 6542 }, 6543 { 6544 "datasource": { 6545 "type": "prometheus", 6546 "uid": "${DS_PROMETHEUS}" 6547 }, 6548 "description": "", 6549 "fieldConfig": { 6550 "defaults": { 6551 "color": { 6552 "mode": "palette-classic" 6553 }, 6554 "custom": { 6555 "axisBorderShow": false, 6556 "axisCenteredZero": false, 6557 "axisColorMode": "text", 6558 "axisLabel": "", 6559 "axisPlacement": "auto", 6560 "barAlignment": 0, 6561 "drawStyle": "line", 6562 "fillOpacity": 10, 6563 "gradientMode": "none", 6564 "hideFrom": { 6565 "legend": false, 6566 "tooltip": false, 6567 "viz": false 6568 }, 6569 "insertNulls": false, 6570 "lineInterpolation": "linear", 6571 "lineWidth": 1, 6572 "pointSize": 5, 6573 "scaleDistribution": { 6574 "type": "linear" 6575 }, 6576 "showPoints": "never", 6577 "spanNulls": true, 6578 "stacking": { 6579 "group": "A", 6580 "mode": "none" 6581 }, 6582 "thresholdsStyle": { 6583 "mode": "off" 6584 } 6585 }, 6586 "mappings": [], 6587 "thresholds": { 6588 "mode": "absolute", 6589 "steps": [ 6590 { 6591 "color": "green" 6592 }, 6593 { 6594 "color": "red", 6595 "value": 80 6596 } 6597 ] 6598 }, 6599 "unit": "s", 6600 "unitScale": true 6601 }, 6602 "overrides": [] 6603 }, 6604 "gridPos": { 6605 "h": 8, 6606 "w": 8, 6607 "x": 16, 6608 "y": 53 6609 }, 6610 "id": 53, 6611 "options": { 6612 "legend": { 6613 "calcs": [], 6614 "displayMode": "list", 6615 "placement": "bottom", 6616 "showLegend": true 6617 }, 6618 "tooltip": { 6619 "mode": "multi", 6620 "sort": "none" 6621 } 6622 }, 6623 "targets": [ 6624 { 6625 "datasource": { 6626 "type": "prometheus", 6627 "uid": "${DS_PROMETHEUS}" 6628 }, 6629 "exemplar": true, 6630 "expr": "cnpg_pg_stat_archiver_seconds_since_last_archival{namespace=~\"$namespace\",pod=~\"$instances\"}", 6631 "interval": "", 6632 "legendFormat": "age ({{pod}})", 6633 "refId": "A" 6634 } 6635 ], 6636 "title": "Last Archive Age", 6637 "type": "timeseries" 6638 }, 6639 { 6640 "datasource": { 6641 "type": "prometheus", 6642 "uid": "${DS_PROMETHEUS}" 6643 }, 6644 "fieldConfig": { 6645 "defaults": { 6646 "color": { 6647 "mode": "palette-classic" 6648 }, 6649 "custom": { 6650 "axisBorderShow": false, 6651 "axisCenteredZero": false, 6652 "axisColorMode": "text", 6653 "axisLabel": "", 6654 "axisPlacement": "auto", 6655 "barAlignment": 0, 6656 "drawStyle": "line", 6657 "fillOpacity": 0, 6658 "gradientMode": "none", 6659 "hideFrom": { 6660 "legend": false, 6661 "tooltip": false, 6662 "viz": false 6663 }, 6664 "insertNulls": false, 6665 "lineInterpolation": "linear", 6666 "lineWidth": 1, 6667 "pointSize": 5, 6668 "scaleDistribution": { 6669 "type": "linear" 6670 }, 6671 "showPoints": "auto", 6672 "spanNulls": false, 6673 "stacking": { 6674 "group": "A", 6675 "mode": "none" 6676 }, 6677 "thresholdsStyle": { 6678 "mode": "off" 6679 } 6680 }, 6681 "mappings": [], 6682 "thresholds": { 6683 "mode": "absolute", 6684 "steps": [ 6685 { 6686 "color": "green" 6687 }, 6688 { 6689 "color": "red", 6690 "value": 80 6691 } 6692 ] 6693 }, 6694 "unitScale": true 6695 }, 6696 "overrides": [] 6697 }, 6698 "gridPos": { 6699 "h": 8, 6700 "w": 8, 6701 "x": 0, 6702 "y": 61 6703 }, 6704 "id": 725, 6705 "options": { 6706 "legend": { 6707 "calcs": [], 6708 "displayMode": "list", 6709 "placement": "bottom", 6710 "showLegend": true 6711 }, 6712 "tooltip": { 6713 "mode": "single", 6714 "sort": "none" 6715 } 6716 }, 6717 "targets": [ 6718 { 6719 "datasource": { 6720 "type": "prometheus", 6721 "uid": "${DS_PROMETHEUS}" 6722 }, 6723 "editorMode": "code", 6724 "expr": "cnpg_collector_pg_wal{pod=~\"$instances\", namespace=~\"$namespace\", value=\"count\"}", 6725 "instant": false, 6726 "legendFormat": "{{pod}}", 6727 "range": true, 6728 "refId": "A" 6729 } 6730 ], 6731 "title": "WAL Count", 6732 "type": "timeseries" 6733 } 6734 ], 6735 "targets": [ 6736 { 6737 "datasource": { 6738 "uid": "prometheus" 6739 }, 6740 "refId": "A" 6741 } 6742 ], 6743 "title": "Write Ahead Log", 6744 "type": "row" 6745 }, 6746 { 6747 "collapsed": true, 6748 "datasource": { 6749 "uid": "prometheus" 6750 }, 6751 "gridPos": { 6752 "h": 1, 6753 "w": 24, 6754 "x": 0, 6755 "y": 53 6756 }, 6757 "id": 18, 6758 "panels": [ 6759 { 6760 "datasource": { 6761 "type": "prometheus", 6762 "uid": "${DS_PROMETHEUS}" 6763 }, 6764 "fieldConfig": { 6765 "defaults": { 6766 "color": { 6767 "mode": "palette-classic" 6768 }, 6769 "custom": { 6770 "axisBorderShow": false, 6771 "axisCenteredZero": false, 6772 "axisColorMode": "text", 6773 "axisLabel": "", 6774 "axisPlacement": "auto", 6775 "barAlignment": 0, 6776 "drawStyle": "line", 6777 "fillOpacity": 10, 6778 "gradientMode": "none", 6779 "hideFrom": { 6780 "legend": false, 6781 "tooltip": false, 6782 "viz": false 6783 }, 6784 "insertNulls": false, 6785 "lineInterpolation": "linear", 6786 "lineWidth": 1, 6787 "pointSize": 5, 6788 "scaleDistribution": { 6789 "type": "linear" 6790 }, 6791 "showPoints": "never", 6792 "spanNulls": true, 6793 "stacking": { 6794 "group": "A", 6795 "mode": "none" 6796 }, 6797 "thresholdsStyle": { 6798 "mode": "line" 6799 } 6800 }, 6801 "mappings": [], 6802 "thresholds": { 6803 "mode": "absolute", 6804 "steps": [ 6805 { 6806 "color": "green" 6807 }, 6808 { 6809 "color": "#EAB839", 6810 "value": 600 6811 }, 6812 { 6813 "color": "dark-red", 6814 "value": 3600 6815 } 6816 ] 6817 }, 6818 "unit": "s", 6819 "unitScale": true 6820 }, 6821 "overrides": [] 6822 }, 6823 "gridPos": { 6824 "h": 8, 6825 "w": 6, 6826 "x": 0, 6827 "y": 59 6828 }, 6829 "id": 16, 6830 "options": { 6831 "legend": { 6832 "calcs": [], 6833 "displayMode": "list", 6834 "placement": "bottom", 6835 "showLegend": true 6836 }, 6837 "tooltip": { 6838 "mode": "multi", 6839 "sort": "none" 6840 } 6841 }, 6842 "targets": [ 6843 { 6844 "datasource": { 6845 "type": "prometheus", 6846 "uid": "${DS_PROMETHEUS}" 6847 }, 6848 "exemplar": true, 6849 "expr": "cnpg_pg_replication_lag{namespace=~\"$namespace\",pod=~\"$instances\"}", 6850 "instant": false, 6851 "interval": "", 6852 "legendFormat": "{{pod}}", 6853 "refId": "A" 6854 } 6855 ], 6856 "title": "Replication Lag", 6857 "type": "timeseries" 6858 }, 6859 { 6860 "datasource": { 6861 "type": "prometheus", 6862 "uid": "${DS_PROMETHEUS}" 6863 }, 6864 "fieldConfig": { 6865 "defaults": { 6866 "color": { 6867 "mode": "palette-classic" 6868 }, 6869 "custom": { 6870 "axisBorderShow": false, 6871 "axisCenteredZero": false, 6872 "axisColorMode": "text", 6873 "axisLabel": "", 6874 "axisPlacement": "auto", 6875 "barAlignment": 0, 6876 "drawStyle": "line", 6877 "fillOpacity": 10, 6878 "gradientMode": "none", 6879 "hideFrom": { 6880 "legend": false, 6881 "tooltip": false, 6882 "viz": false 6883 }, 6884 "insertNulls": false, 6885 "lineInterpolation": "linear", 6886 "lineWidth": 1, 6887 "pointSize": 5, 6888 "scaleDistribution": { 6889 "type": "linear" 6890 }, 6891 "showPoints": "never", 6892 "spanNulls": true, 6893 "stacking": { 6894 "group": "A", 6895 "mode": "none" 6896 }, 6897 "thresholdsStyle": { 6898 "mode": "off" 6899 } 6900 }, 6901 "mappings": [], 6902 "thresholds": { 6903 "mode": "absolute", 6904 "steps": [ 6905 { 6906 "color": "green" 6907 }, 6908 { 6909 "color": "red", 6910 "value": 80 6911 } 6912 ] 6913 }, 6914 "unit": "s", 6915 "unitScale": true 6916 }, 6917 "overrides": [] 6918 }, 6919 "gridPos": { 6920 "h": 8, 6921 "w": 6, 6922 "x": 6, 6923 "y": 59 6924 }, 6925 "id": 14, 6926 "options": { 6927 "legend": { 6928 "calcs": [], 6929 "displayMode": "list", 6930 "placement": "bottom", 6931 "showLegend": true 6932 }, 6933 "tooltip": { 6934 "mode": "multi", 6935 "sort": "none" 6936 } 6937 }, 6938 "targets": [ 6939 { 6940 "datasource": { 6941 "type": "prometheus", 6942 "uid": "${DS_PROMETHEUS}" 6943 }, 6944 "editorMode": "code", 6945 "exemplar": true, 6946 "expr": "cnpg_pg_stat_replication_write_lag_seconds{namespace=~\"$namespace\",pod=~\"$instances\"}", 6947 "instant": false, 6948 "interval": "", 6949 "legendFormat": "{{pod}} -> {{application_name}}", 6950 "refId": "A" 6951 } 6952 ], 6953 "title": "Write Lag", 6954 "type": "timeseries" 6955 }, 6956 { 6957 "datasource": { 6958 "type": "prometheus", 6959 "uid": "${DS_PROMETHEUS}" 6960 }, 6961 "fieldConfig": { 6962 "defaults": { 6963 "color": { 6964 "mode": "palette-classic" 6965 }, 6966 "custom": { 6967 "axisBorderShow": false, 6968 "axisCenteredZero": false, 6969 "axisColorMode": "text", 6970 "axisLabel": "", 6971 "axisPlacement": "auto", 6972 "barAlignment": 0, 6973 "drawStyle": "line", 6974 "fillOpacity": 10, 6975 "gradientMode": "none", 6976 "hideFrom": { 6977 "legend": false, 6978 "tooltip": false, 6979 "viz": false 6980 }, 6981 "insertNulls": false, 6982 "lineInterpolation": "linear", 6983 "lineWidth": 1, 6984 "pointSize": 5, 6985 "scaleDistribution": { 6986 "type": "linear" 6987 }, 6988 "showPoints": "never", 6989 "spanNulls": true, 6990 "stacking": { 6991 "group": "A", 6992 "mode": "none" 6993 }, 6994 "thresholdsStyle": { 6995 "mode": "off" 6996 } 6997 }, 6998 "mappings": [], 6999 "thresholds": { 7000 "mode": "absolute", 7001 "steps": [ 7002 { 7003 "color": "green" 7004 }, 7005 { 7006 "color": "red", 7007 "value": 80 7008 } 7009 ] 7010 }, 7011 "unit": "s", 7012 "unitScale": true 7013 }, 7014 "overrides": [] 7015 }, 7016 "gridPos": { 7017 "h": 8, 7018 "w": 6, 7019 "x": 12, 7020 "y": 59 7021 }, 7022 "id": 59, 7023 "options": { 7024 "legend": { 7025 "calcs": [], 7026 "displayMode": "list", 7027 "placement": "bottom", 7028 "showLegend": true 7029 }, 7030 "tooltip": { 7031 "mode": "multi", 7032 "sort": "none" 7033 } 7034 }, 7035 "targets": [ 7036 { 7037 "datasource": { 7038 "type": "prometheus", 7039 "uid": "${DS_PROMETHEUS}" 7040 }, 7041 "editorMode": "code", 7042 "exemplar": true, 7043 "expr": "cnpg_pg_stat_replication_flush_lag_seconds{namespace=~\"$namespace\",pod=~\"$instances\"}", 7044 "instant": false, 7045 "interval": "", 7046 "legendFormat": "{{pod}} -> {{application_name}}", 7047 "refId": "A" 7048 } 7049 ], 7050 "title": "Flush Lag", 7051 "type": "timeseries" 7052 }, 7053 { 7054 "datasource": { 7055 "type": "prometheus", 7056 "uid": "${DS_PROMETHEUS}" 7057 }, 7058 "description": "", 7059 "fieldConfig": { 7060 "defaults": { 7061 "color": { 7062 "mode": "palette-classic" 7063 }, 7064 "custom": { 7065 "axisBorderShow": false, 7066 "axisCenteredZero": false, 7067 "axisColorMode": "text", 7068 "axisLabel": "", 7069 "axisPlacement": "auto", 7070 "barAlignment": 0, 7071 "drawStyle": "line", 7072 "fillOpacity": 10, 7073 "gradientMode": "none", 7074 "hideFrom": { 7075 "legend": false, 7076 "tooltip": false, 7077 "viz": false 7078 }, 7079 "insertNulls": false, 7080 "lineInterpolation": "linear", 7081 "lineWidth": 1, 7082 "pointSize": 5, 7083 "scaleDistribution": { 7084 "type": "linear" 7085 }, 7086 "showPoints": "never", 7087 "spanNulls": true, 7088 "stacking": { 7089 "group": "A", 7090 "mode": "none" 7091 }, 7092 "thresholdsStyle": { 7093 "mode": "off" 7094 } 7095 }, 7096 "mappings": [], 7097 "thresholds": { 7098 "mode": "absolute", 7099 "steps": [ 7100 { 7101 "color": "green" 7102 }, 7103 { 7104 "color": "red", 7105 "value": 80 7106 } 7107 ] 7108 }, 7109 "unit": "s", 7110 "unitScale": true 7111 }, 7112 "overrides": [] 7113 }, 7114 "gridPos": { 7115 "h": 8, 7116 "w": 6, 7117 "x": 18, 7118 "y": 59 7119 }, 7120 "id": 20, 7121 "options": { 7122 "legend": { 7123 "calcs": [], 7124 "displayMode": "list", 7125 "placement": "bottom", 7126 "showLegend": true 7127 }, 7128 "tooltip": { 7129 "mode": "multi", 7130 "sort": "none" 7131 } 7132 }, 7133 "targets": [ 7134 { 7135 "datasource": { 7136 "type": "prometheus", 7137 "uid": "${DS_PROMETHEUS}" 7138 }, 7139 "editorMode": "code", 7140 "exemplar": true, 7141 "expr": "cnpg_pg_stat_replication_replay_lag_seconds{namespace=~\"$namespace\",pod=~\"$instances\"}", 7142 "interval": "", 7143 "legendFormat": "{{pod}} -> {{application_name}}", 7144 "range": true, 7145 "refId": "A" 7146 } 7147 ], 7148 "title": "Replay Lag", 7149 "type": "timeseries" 7150 } 7151 ], 7152 "targets": [ 7153 { 7154 "datasource": { 7155 "uid": "prometheus" 7156 }, 7157 "refId": "A" 7158 } 7159 ], 7160 "title": "Replication", 7161 "type": "row" 7162 }, 7163 { 7164 "collapsed": true, 7165 "datasource": { 7166 "uid": "prometheus" 7167 }, 7168 "gridPos": { 7169 "h": 1, 7170 "w": 24, 7171 "x": 0, 7172 "y": 54 7173 }, 7174 "id": 231, 7175 "panels": [ 7176 { 7177 "cards": {}, 7178 "color": { 7179 "cardColor": "#b4ff00", 7180 "colorScale": "sqrt", 7181 "colorScheme": "interpolateOranges", 7182 "exponent": 0.5, 7183 "mode": "spectrum" 7184 }, 7185 "dataFormat": "timeseries", 7186 "datasource": { 7187 "type": "prometheus", 7188 "uid": "${DS_PROMETHEUS}" 7189 }, 7190 "fieldConfig": { 7191 "defaults": { 7192 "custom": { 7193 "hideFrom": { 7194 "legend": false, 7195 "tooltip": false, 7196 "viz": false 7197 }, 7198 "scaleDistribution": { 7199 "type": "linear" 7200 } 7201 }, 7202 "unitScale": true 7203 }, 7204 "overrides": [] 7205 }, 7206 "gridPos": { 7207 "h": 8, 7208 "w": 12, 7209 "x": 0, 7210 "y": 55 7211 }, 7212 "heatmap": {}, 7213 "hideZeroBuckets": false, 7214 "highlightCards": true, 7215 "id": 233, 7216 "legend": { 7217 "show": false 7218 }, 7219 "options": { 7220 "calculate": true, 7221 "calculation": {}, 7222 "cellGap": 2, 7223 "cellValues": {}, 7224 "color": { 7225 "exponent": 0.5, 7226 "fill": "#b4ff00", 7227 "mode": "scheme", 7228 "reverse": false, 7229 "scale": "exponential", 7230 "scheme": "Oranges", 7231 "steps": 128 7232 }, 7233 "exemplars": { 7234 "color": "rgba(255,0,255,0.7)" 7235 }, 7236 "filterValues": { 7237 "le": 1e-9 7238 }, 7239 "legend": { 7240 "show": false 7241 }, 7242 "rowsFrame": { 7243 "layout": "auto" 7244 }, 7245 "showValue": "never", 7246 "tooltip": { 7247 "mode": "single", 7248 "showColorScale": false, 7249 "yHistogram": false 7250 }, 7251 "yAxis": { 7252 "axisPlacement": "left", 7253 "reverse": false, 7254 "unit": "s" 7255 } 7256 }, 7257 "pluginVersion": "10.3.3", 7258 "reverseYBuckets": false, 7259 "targets": [ 7260 { 7261 "datasource": { 7262 "type": "prometheus", 7263 "uid": "${DS_PROMETHEUS}" 7264 }, 7265 "exemplar": true, 7266 "expr": "cnpg_collector_collection_duration_seconds{namespace=~\"$namespace\",pod=~\"$instances\"}", 7267 "interval": "", 7268 "legendFormat": "", 7269 "refId": "A" 7270 } 7271 ], 7272 "title": "Collection Duration", 7273 "tooltip": { 7274 "show": true, 7275 "showHistogram": false 7276 }, 7277 "type": "heatmap", 7278 "xAxis": { 7279 "show": true 7280 }, 7281 "yAxis": { 7282 "format": "s", 7283 "logBase": 1, 7284 "show": true 7285 }, 7286 "yBucketBound": "auto" 7287 }, 7288 { 7289 "datasource": { 7290 "type": "prometheus", 7291 "uid": "${DS_PROMETHEUS}" 7292 }, 7293 "fieldConfig": { 7294 "defaults": { 7295 "color": { 7296 "mode": "palette-classic" 7297 }, 7298 "custom": { 7299 "axisBorderShow": false, 7300 "axisCenteredZero": false, 7301 "axisColorMode": "text", 7302 "axisLabel": "", 7303 "axisPlacement": "auto", 7304 "barAlignment": 0, 7305 "drawStyle": "line", 7306 "fillOpacity": 0, 7307 "gradientMode": "none", 7308 "hideFrom": { 7309 "legend": false, 7310 "tooltip": false, 7311 "viz": false 7312 }, 7313 "insertNulls": false, 7314 "lineInterpolation": "linear", 7315 "lineWidth": 1, 7316 "pointSize": 5, 7317 "scaleDistribution": { 7318 "type": "linear" 7319 }, 7320 "showPoints": "auto", 7321 "spanNulls": false, 7322 "stacking": { 7323 "group": "A", 7324 "mode": "none" 7325 }, 7326 "thresholdsStyle": { 7327 "mode": "off" 7328 } 7329 }, 7330 "mappings": [], 7331 "thresholds": { 7332 "mode": "absolute", 7333 "steps": [ 7334 { 7335 "color": "green" 7336 }, 7337 { 7338 "color": "red", 7339 "value": 80 7340 } 7341 ] 7342 }, 7343 "unitScale": true 7344 }, 7345 "overrides": [] 7346 }, 7347 "gridPos": { 7348 "h": 8, 7349 "w": 12, 7350 "x": 12, 7351 "y": 55 7352 }, 7353 "id": 235, 7354 "options": { 7355 "legend": { 7356 "calcs": [], 7357 "displayMode": "list", 7358 "placement": "bottom", 7359 "showLegend": true 7360 }, 7361 "tooltip": { 7362 "mode": "multi", 7363 "sort": "none" 7364 } 7365 }, 7366 "targets": [ 7367 { 7368 "datasource": { 7369 "type": "prometheus", 7370 "uid": "${DS_PROMETHEUS}" 7371 }, 7372 "exemplar": true, 7373 "expr": "cnpg_collector_last_collection_error{namespace=~\"$namespace\",pod=~\"$instances\"}", 7374 "interval": "", 7375 "legendFormat": "{{pod}}", 7376 "refId": "A" 7377 } 7378 ], 7379 "title": "Errors", 7380 "type": "timeseries" 7381 } 7382 ], 7383 "targets": [ 7384 { 7385 "datasource": { 7386 "uid": "prometheus" 7387 }, 7388 "refId": "A" 7389 } 7390 ], 7391 "title": "Collector Stats", 7392 "type": "row" 7393 }, 7394 { 7395 "collapsed": true, 7396 "datasource": { 7397 "uid": "prometheus" 7398 }, 7399 "gridPos": { 7400 "h": 1, 7401 "w": 24, 7402 "x": 0, 7403 "y": 55 7404 }, 7405 "id": 239, 7406 "panels": [ 7407 { 7408 "datasource": { 7409 "type": "prometheus", 7410 "uid": "${DS_PROMETHEUS}" 7411 }, 7412 "fieldConfig": { 7413 "defaults": { 7414 "color": { 7415 "mode": "palette-classic" 7416 }, 7417 "custom": { 7418 "axisBorderShow": false, 7419 "axisCenteredZero": false, 7420 "axisColorMode": "text", 7421 "axisLabel": "", 7422 "axisPlacement": "auto", 7423 "barAlignment": 0, 7424 "drawStyle": "line", 7425 "fillOpacity": 0, 7426 "gradientMode": "none", 7427 "hideFrom": { 7428 "legend": false, 7429 "tooltip": false, 7430 "viz": false 7431 }, 7432 "insertNulls": false, 7433 "lineInterpolation": "linear", 7434 "lineWidth": 1, 7435 "pointSize": 5, 7436 "scaleDistribution": { 7437 "type": "linear" 7438 }, 7439 "showPoints": "auto", 7440 "spanNulls": false, 7441 "stacking": { 7442 "group": "A", 7443 "mode": "none" 7444 }, 7445 "thresholdsStyle": { 7446 "mode": "off" 7447 } 7448 }, 7449 "mappings": [], 7450 "thresholds": { 7451 "mode": "absolute", 7452 "steps": [ 7453 { 7454 "color": "green" 7455 }, 7456 { 7457 "color": "red", 7458 "value": 80 7459 } 7460 ] 7461 }, 7462 "unit": "dateTimeAsIso", 7463 "unitScale": true 7464 }, 7465 "overrides": [] 7466 }, 7467 "gridPos": { 7468 "h": 6, 7469 "w": 8, 7470 "x": 0, 7471 "y": 56 7472 }, 7473 "id": 237, 7474 "options": { 7475 "legend": { 7476 "calcs": [], 7477 "displayMode": "list", 7478 "placement": "bottom", 7479 "showLegend": true 7480 }, 7481 "tooltip": { 7482 "mode": "multi", 7483 "sort": "none" 7484 } 7485 }, 7486 "targets": [ 7487 { 7488 "datasource": { 7489 "type": "prometheus", 7490 "uid": "${DS_PROMETHEUS}" 7491 }, 7492 "exemplar": true, 7493 "expr": "cnpg_collector_first_recoverability_point{namespace=~\"$namespace\",pod=~\"$instances\"}*1000 > 0", 7494 "format": "time_series", 7495 "interval": "", 7496 "legendFormat": "{{pod}}", 7497 "refId": "A" 7498 } 7499 ], 7500 "title": "First Recoverability Point", 7501 "type": "timeseries" 7502 } 7503 ], 7504 "targets": [ 7505 { 7506 "datasource": { 7507 "uid": "prometheus" 7508 }, 7509 "refId": "A" 7510 } 7511 ], 7512 "title": "Backups", 7513 "type": "row" 7514 }, 7515 { 7516 "collapsed": true, 7517 "datasource": { 7518 "uid": "prometheus" 7519 }, 7520 "gridPos": { 7521 "h": 1, 7522 "w": 24, 7523 "x": 0, 7524 "y": 56 7525 }, 7526 "id": 293, 7527 "panels": [ 7528 { 7529 "datasource": { 7530 "type": "prometheus", 7531 "uid": "${DS_PROMETHEUS}" 7532 }, 7533 "description": "", 7534 "fieldConfig": { 7535 "defaults": { 7536 "color": { 7537 "mode": "palette-classic" 7538 }, 7539 "custom": { 7540 "axisBorderShow": false, 7541 "axisCenteredZero": false, 7542 "axisColorMode": "text", 7543 "axisLabel": "", 7544 "axisPlacement": "auto", 7545 "barAlignment": -1, 7546 "drawStyle": "line", 7547 "fillOpacity": 8, 7548 "gradientMode": "none", 7549 "hideFrom": { 7550 "legend": false, 7551 "tooltip": false, 7552 "viz": false 7553 }, 7554 "insertNulls": false, 7555 "lineInterpolation": "linear", 7556 "lineWidth": 1, 7557 "pointSize": 5, 7558 "scaleDistribution": { 7559 "type": "linear" 7560 }, 7561 "showPoints": "never", 7562 "spanNulls": true, 7563 "stacking": { 7564 "group": "A", 7565 "mode": "none" 7566 }, 7567 "thresholdsStyle": { 7568 "mode": "off" 7569 } 7570 }, 7571 "mappings": [], 7572 "thresholds": { 7573 "mode": "absolute", 7574 "steps": [ 7575 { 7576 "color": "green" 7577 }, 7578 { 7579 "color": "red", 7580 "value": 80 7581 } 7582 ] 7583 }, 7584 "unit": "none", 7585 "unitScale": true 7586 }, 7587 "overrides": [] 7588 }, 7589 "gridPos": { 7590 "h": 6, 7591 "w": 5, 7592 "x": 0, 7593 "y": 57 7594 }, 7595 "id": 295, 7596 "options": { 7597 "legend": { 7598 "calcs": [], 7599 "displayMode": "list", 7600 "placement": "bottom", 7601 "showLegend": true 7602 }, 7603 "tooltip": { 7604 "mode": "multi", 7605 "sort": "none" 7606 } 7607 }, 7608 "pluginVersion": "8.2.1", 7609 "targets": [ 7610 { 7611 "datasource": { 7612 "type": "prometheus", 7613 "uid": "${DS_PROMETHEUS}" 7614 }, 7615 "exemplar": true, 7616 "expr": "{__name__=~\"cnpg_pg_stat_(bgwriter|checkpointer)_checkpoints_req\",namespace=~\"$namespace\",pod=~\"$instances\"}", 7617 "format": "time_series", 7618 "hide": false, 7619 "instant": false, 7620 "interval": "", 7621 "intervalFactor": 1, 7622 "legendFormat": "req/{{pod}}", 7623 "refId": "B" 7624 }, 7625 { 7626 "datasource": { 7627 "type": "prometheus", 7628 "uid": "${DS_PROMETHEUS}" 7629 }, 7630 "exemplar": true, 7631 "expr": "{__name__=~\"cnpg_pg_stat_(bgwriter|checkpointer)_checkpoints_timed\",namespace=~\"$namespace\",pod=~\"$instances\"}", 7632 "format": "time_series", 7633 "interval": "", 7634 "intervalFactor": 1, 7635 "legendFormat": "timed/{{pod}}", 7636 "refId": "A" 7637 } 7638 ], 7639 "title": "Requested/Timed", 7640 "type": "timeseries" 7641 }, 7642 { 7643 "datasource": { 7644 "type": "prometheus", 7645 "uid": "${DS_PROMETHEUS}" 7646 }, 7647 "description": "", 7648 "fieldConfig": { 7649 "defaults": { 7650 "color": { 7651 "mode": "palette-classic" 7652 }, 7653 "custom": { 7654 "axisBorderShow": false, 7655 "axisCenteredZero": false, 7656 "axisColorMode": "text", 7657 "axisLabel": "", 7658 "axisPlacement": "auto", 7659 "barAlignment": -1, 7660 "drawStyle": "line", 7661 "fillOpacity": 8, 7662 "gradientMode": "none", 7663 "hideFrom": { 7664 "legend": false, 7665 "tooltip": false, 7666 "viz": false 7667 }, 7668 "insertNulls": false, 7669 "lineInterpolation": "linear", 7670 "lineWidth": 1, 7671 "pointSize": 5, 7672 "scaleDistribution": { 7673 "type": "linear" 7674 }, 7675 "showPoints": "never", 7676 "spanNulls": true, 7677 "stacking": { 7678 "group": "A", 7679 "mode": "none" 7680 }, 7681 "thresholdsStyle": { 7682 "mode": "off" 7683 } 7684 }, 7685 "mappings": [], 7686 "thresholds": { 7687 "mode": "absolute", 7688 "steps": [ 7689 { 7690 "color": "green" 7691 }, 7692 { 7693 "color": "red", 7694 "value": 80 7695 } 7696 ] 7697 }, 7698 "unit": "ms", 7699 "unitScale": true 7700 }, 7701 "overrides": [] 7702 }, 7703 "gridPos": { 7704 "h": 6, 7705 "w": 5, 7706 "x": 5, 7707 "y": 57 7708 }, 7709 "id": 296, 7710 "options": { 7711 "legend": { 7712 "calcs": [], 7713 "displayMode": "list", 7714 "placement": "bottom", 7715 "showLegend": true 7716 }, 7717 "tooltip": { 7718 "mode": "multi", 7719 "sort": "none" 7720 } 7721 }, 7722 "pluginVersion": "8.2.1", 7723 "targets": [ 7724 { 7725 "datasource": { 7726 "type": "prometheus", 7727 "uid": "${DS_PROMETHEUS}" 7728 }, 7729 "exemplar": true, 7730 "expr": "{__name__=~\"cnpg_pg_stat_(bgwriter_checkpoint|checkpointer)_write_time\",namespace=~\"$namespace\",pod=~\"$instances\"}", 7731 "format": "time_series", 7732 "hide": false, 7733 "instant": false, 7734 "interval": "", 7735 "intervalFactor": 1, 7736 "legendFormat": "write/{{pod}}", 7737 "refId": "B" 7738 }, 7739 { 7740 "datasource": { 7741 "type": "prometheus", 7742 "uid": "${DS_PROMETHEUS}" 7743 }, 7744 "exemplar": true, 7745 "expr": "{__name__=~\"cnpg_pg_stat_(bgwriter_checkpoint|checkpointer)_sync_time\",namespace=~\"$namespace\",pod=~\"$instances\"}", 7746 "format": "time_series", 7747 "interval": "", 7748 "intervalFactor": 1, 7749 "legendFormat": "sync/{{pod}}", 7750 "refId": "A" 7751 } 7752 ], 7753 "title": "Write/Sync time", 7754 "type": "timeseries" 7755 } 7756 ], 7757 "targets": [ 7758 { 7759 "datasource": { 7760 "uid": "prometheus" 7761 }, 7762 "refId": "A" 7763 } 7764 ], 7765 "title": "Checkpoints", 7766 "type": "row" 7767 }, 7768 { 7769 "collapsed": true, 7770 "gridPos": { 7771 "h": 1, 7772 "w": 24, 7773 "x": 0, 7774 "y": 57 7775 }, 7776 "id": 794, 7777 "panels": [ 7778 { 7779 "datasource": { 7780 "type": "prometheus", 7781 "uid": "${DS_PROMETHEUS}" 7782 }, 7783 "description": "Show the installed extensions and their versions", 7784 "fieldConfig": { 7785 "defaults": { 7786 "color": { 7787 "mode": "thresholds" 7788 }, 7789 "custom": { 7790 "align": "auto", 7791 "cellOptions": { 7792 "type": "auto", 7793 "wrapText": false 7794 }, 7795 "filterable": false, 7796 "inspect": false 7797 } 7798 }, 7799 "overrides": [ 7800 { 7801 "matcher": { 7802 "id": "byName", 7803 "options": "Update Available" 7804 }, 7805 "properties": [ 7806 { 7807 "id": "unit", 7808 "value": "bool" 7809 }, 7810 { 7811 "id": "mappings", 7812 "value": [ 7813 { 7814 "options": { 7815 "0": { 7816 "color": "transparent", 7817 "index": 1 7818 }, 7819 "1": { 7820 "color": "red", 7821 "index": 0 7822 } 7823 }, 7824 "type": "value" 7825 } 7826 ] 7827 }, 7828 { 7829 "id": "custom.cellOptions", 7830 "value": { 7831 "applyToRow": true, 7832 "mode": "gradient", 7833 "type": "color-background" 7834 } 7835 } 7836 ] 7837 } 7838 ] 7839 }, 7840 "gridPos": { 7841 "h": 8, 7842 "w": 24, 7843 "x": 0, 7844 "y": 81 7845 }, 7846 "id": 792, 7847 "options": { 7848 "cellHeight": "sm", 7849 "footer": { 7850 "countRows": false, 7851 "fields": "", 7852 "reducer": ["sum"], 7853 "show": false 7854 }, 7855 "showHeader": true, 7856 "sortBy": [ 7857 { 7858 "desc": false, 7859 "displayName": "Value" 7860 } 7861 ] 7862 }, 7863 "pluginVersion": "11.4.0", 7864 "targets": [ 7865 { 7866 "disableTextWrap": false, 7867 "exemplar": false, 7868 "expr": "max(cnpg_pg_extensions_update_available{pod=~\"$instances\", namespace=~\"$namespace\"}) by (datname, extname, default_version, installed_version)", 7869 "format": "table", 7870 "fullMetaSearch": false, 7871 "includeNullMetadata": true, 7872 "instant": true, 7873 "interval": "", 7874 "legendFormat": "__auto", 7875 "range": false, 7876 "refId": "A", 7877 "useBackend": false 7878 } 7879 ], 7880 "title": "Installed extensions", 7881 "transformations": [ 7882 { 7883 "id": "sortBy", 7884 "options": { 7885 "fields": {}, 7886 "sort": [ 7887 { 7888 "field": "extname" 7889 } 7890 ] 7891 } 7892 }, 7893 { 7894 "id": "organize", 7895 "options": { 7896 "excludeByName": { 7897 "Time": true 7898 }, 7899 "indexByName": { 7900 "Time": 0, 7901 "extname": 1, 7902 "datname": 2, 7903 "default_version": 3, 7904 "installed_version": 4, 7905 "Value": 5 7906 }, 7907 "renameByName": { 7908 "default_version": "Default Version", 7909 "datname": "Database", 7910 "extname": "Extension", 7911 "installed_version": "Installed Version", 7912 "Value": "Update Available" 7913 }, 7914 "includeByName": {} 7915 } 7916 } 7917 ], 7918 "type": "table" 7919 } 7920 ], 7921 "title": "Extensions", 7922 "type": "row" 7923 }, 7924 { 7925 "collapsed": true, 7926 "gridPos": { 7927 "h": 1, 7928 "w": 24, 7929 "x": 0, 7930 "y": 58 7931 }, 7932 "id": 696, 7933 "panels": [ 7934 { 7935 "datasource": { 7936 "type": "prometheus", 7937 "uid": "${DS_PROMETHEUS}" 7938 }, 7939 "description": "", 7940 "fieldConfig": { 7941 "defaults": { 7942 "color": { 7943 "mode": "thresholds" 7944 }, 7945 "mappings": [ 7946 { 7947 "options": { 7948 "0": { 7949 "color": "red", 7950 "index": 0, 7951 "text": "No Ready pods" 7952 } 7953 }, 7954 "type": "value" 7955 } 7956 ], 7957 "thresholds": { 7958 "mode": "absolute", 7959 "steps": [ 7960 { 7961 "color": "green" 7962 } 7963 ] 7964 }, 7965 "unitScale": true 7966 }, 7967 "overrides": [ 7968 { 7969 "matcher": { 7970 "id": "byName", 7971 "options": "A" 7972 }, 7973 "properties": [ 7974 { 7975 "id": "displayName", 7976 "value": "Reconcile errors" 7977 } 7978 ] 7979 } 7980 ] 7981 }, 7982 "gridPos": { 7983 "h": 2, 7984 "w": 4, 7985 "x": 0, 7986 "y": 64 7987 }, 7988 "id": 697, 7989 "options": { 7990 "colorMode": "background", 7991 "graphMode": "none", 7992 "justifyMode": "auto", 7993 "orientation": "auto", 7994 "reduceOptions": { 7995 "calcs": ["lastNotNull"], 7996 "fields": "", 7997 "values": false 7998 }, 7999 "showPercentChange": false, 8000 "textMode": "value_and_name", 8001 "wideLayout": true 8002 }, 8003 "pluginVersion": "10.3.3", 8004 "targets": [ 8005 { 8006 "datasource": { 8007 "type": "prometheus", 8008 "uid": "${DS_PROMETHEUS}" 8009 }, 8010 "editorMode": "code", 8011 "exemplar": false, 8012 "expr": "sum(kube_pod_status_ready{namespace=\"$operatorNamespace\", pod=~\"cloudnative-pg.+|cnpg-controller-manager.+\", condition=\"true\"})", 8013 "hide": false, 8014 "instant": true, 8015 "legendFormat": "Ready Operator Pods", 8016 "range": false, 8017 "refId": "A" 8018 } 8019 ], 8020 "type": "stat" 8021 }, 8022 { 8023 "datasource": { 8024 "type": "prometheus", 8025 "uid": "${DS_PROMETHEUS}" 8026 }, 8027 "description": "The operator reconcile errors don't distinguish between database cluster or namespaces.", 8028 "fieldConfig": { 8029 "defaults": { 8030 "color": { 8031 "mode": "thresholds" 8032 }, 8033 "mappings": [ 8034 { 8035 "options": { 8036 "0": { 8037 "color": "green", 8038 "index": 0, 8039 "text": "None" 8040 } 8041 }, 8042 "type": "value" 8043 }, 8044 { 8045 "options": { 8046 "from": 1, 8047 "result": { 8048 "color": "red", 8049 "index": 1 8050 }, 8051 "to": 4294967295 8052 }, 8053 "type": "range" 8054 } 8055 ], 8056 "thresholds": { 8057 "mode": "absolute", 8058 "steps": [ 8059 { 8060 "color": "green" 8061 } 8062 ] 8063 }, 8064 "unitScale": true 8065 }, 8066 "overrides": [ 8067 { 8068 "matcher": { 8069 "id": "byName", 8070 "options": "A" 8071 }, 8072 "properties": [ 8073 { 8074 "id": "displayName", 8075 "value": "Reconcile errors" 8076 } 8077 ] 8078 } 8079 ] 8080 }, 8081 "gridPos": { 8082 "h": 2, 8083 "w": 4, 8084 "x": 4, 8085 "y": 64 8086 }, 8087 "id": 702, 8088 "options": { 8089 "colorMode": "background", 8090 "graphMode": "none", 8091 "justifyMode": "auto", 8092 "orientation": "auto", 8093 "reduceOptions": { 8094 "calcs": ["lastNotNull"], 8095 "fields": "", 8096 "values": false 8097 }, 8098 "showPercentChange": false, 8099 "textMode": "value_and_name", 8100 "wideLayout": true 8101 }, 8102 "pluginVersion": "10.3.3", 8103 "targets": [ 8104 { 8105 "datasource": { 8106 "type": "prometheus", 8107 "uid": "${DS_PROMETHEUS}" 8108 }, 8109 "editorMode": "code", 8110 "exemplar": false, 8111 "expr": "max(controller_runtime_reconcile_total{namespace=~\"$operatorNamespace\", result=\"error\", controller=\"cluster\"})", 8112 "hide": false, 8113 "instant": true, 8114 "legendFormat": "Cluster Reconcile Errors", 8115 "range": false, 8116 "refId": "RECONCILE_ERRORS_BACKUP" 8117 } 8118 ], 8119 "type": "stat" 8120 }, 8121 { 8122 "datasource": { 8123 "type": "prometheus", 8124 "uid": "${DS_PROMETHEUS}" 8125 }, 8126 "description": "The operator reconcile errors don't distinguish between database cluster or namespaces.", 8127 "fieldConfig": { 8128 "defaults": { 8129 "color": { 8130 "mode": "thresholds" 8131 }, 8132 "mappings": [ 8133 { 8134 "options": { 8135 "0": { 8136 "color": "green", 8137 "index": 0, 8138 "text": "None" 8139 } 8140 }, 8141 "type": "value" 8142 }, 8143 { 8144 "options": { 8145 "from": 1, 8146 "result": { 8147 "color": "red", 8148 "index": 1 8149 }, 8150 "to": 4294967295 8151 }, 8152 "type": "range" 8153 } 8154 ], 8155 "thresholds": { 8156 "mode": "absolute", 8157 "steps": [ 8158 { 8159 "color": "green" 8160 } 8161 ] 8162 }, 8163 "unitScale": true 8164 }, 8165 "overrides": [ 8166 { 8167 "matcher": { 8168 "id": "byName", 8169 "options": "A" 8170 }, 8171 "properties": [ 8172 { 8173 "id": "displayName", 8174 "value": "Reconcile errors" 8175 } 8176 ] 8177 } 8178 ] 8179 }, 8180 "gridPos": { 8181 "h": 2, 8182 "w": 4, 8183 "x": 8, 8184 "y": 64 8185 }, 8186 "id": 698, 8187 "options": { 8188 "colorMode": "background", 8189 "graphMode": "none", 8190 "justifyMode": "auto", 8191 "orientation": "auto", 8192 "reduceOptions": { 8193 "calcs": ["lastNotNull"], 8194 "fields": "", 8195 "values": false 8196 }, 8197 "showPercentChange": false, 8198 "textMode": "value_and_name", 8199 "wideLayout": true 8200 }, 8201 "pluginVersion": "10.3.3", 8202 "targets": [ 8203 { 8204 "datasource": { 8205 "type": "prometheus", 8206 "uid": "${DS_PROMETHEUS}" 8207 }, 8208 "editorMode": "code", 8209 "exemplar": false, 8210 "expr": "max(controller_runtime_reconcile_total{namespace=~\"$operatorNamespace\", result=\"error\", controller=\"backup\"})", 8211 "hide": false, 8212 "instant": true, 8213 "legendFormat": "Backup Reconcile Errors", 8214 "range": false, 8215 "refId": "RECONCILE_ERRORS_BACKUP" 8216 } 8217 ], 8218 "type": "stat" 8219 }, 8220 { 8221 "datasource": { 8222 "type": "prometheus", 8223 "uid": "${DS_PROMETHEUS}" 8224 }, 8225 "description": "The operator reconcile errors don't distinguish between database cluster or namespaces.", 8226 "fieldConfig": { 8227 "defaults": { 8228 "color": { 8229 "mode": "thresholds" 8230 }, 8231 "mappings": [ 8232 { 8233 "options": { 8234 "0": { 8235 "color": "green", 8236 "index": 0, 8237 "text": "None" 8238 } 8239 }, 8240 "type": "value" 8241 }, 8242 { 8243 "options": { 8244 "from": 1, 8245 "result": { 8246 "color": "red", 8247 "index": 1 8248 }, 8249 "to": 4294967295 8250 }, 8251 "type": "range" 8252 } 8253 ], 8254 "thresholds": { 8255 "mode": "absolute", 8256 "steps": [ 8257 { 8258 "color": "green" 8259 } 8260 ] 8261 }, 8262 "unitScale": true 8263 }, 8264 "overrides": [ 8265 { 8266 "matcher": { 8267 "id": "byName", 8268 "options": "A" 8269 }, 8270 "properties": [ 8271 { 8272 "id": "displayName", 8273 "value": "Reconcile errors" 8274 } 8275 ] 8276 } 8277 ] 8278 }, 8279 "gridPos": { 8280 "h": 2, 8281 "w": 4, 8282 "x": 12, 8283 "y": 64 8284 }, 8285 "id": 704, 8286 "options": { 8287 "colorMode": "background", 8288 "graphMode": "none", 8289 "justifyMode": "auto", 8290 "orientation": "auto", 8291 "reduceOptions": { 8292 "calcs": ["lastNotNull"], 8293 "fields": "", 8294 "values": false 8295 }, 8296 "showPercentChange": false, 8297 "textMode": "value_and_name", 8298 "wideLayout": true 8299 }, 8300 "pluginVersion": "10.3.3", 8301 "targets": [ 8302 { 8303 "datasource": { 8304 "type": "prometheus", 8305 "uid": "${DS_PROMETHEUS}" 8306 }, 8307 "editorMode": "code", 8308 "exemplar": false, 8309 "expr": "max(controller_runtime_reconcile_total{namespace=~\"$operatorNamespace\", result=\"error\", controller=~\"scheduledbackup|scheduled-backup\"})", 8310 "hide": false, 8311 "instant": true, 8312 "legendFormat": "Scheduled Backup Reconcile Errors", 8313 "range": false, 8314 "refId": "RECONCILE_ERRORS_BACKUP" 8315 } 8316 ], 8317 "type": "stat" 8318 }, 8319 { 8320 "datasource": { 8321 "type": "prometheus", 8322 "uid": "${DS_PROMETHEUS}" 8323 }, 8324 "description": "The operator reconcile errors don't distinguish between database cluster or namespaces.", 8325 "fieldConfig": { 8326 "defaults": { 8327 "color": { 8328 "mode": "thresholds" 8329 }, 8330 "mappings": [ 8331 { 8332 "options": { 8333 "0": { 8334 "color": "green", 8335 "index": 0, 8336 "text": "None" 8337 } 8338 }, 8339 "type": "value" 8340 }, 8341 { 8342 "options": { 8343 "from": 1, 8344 "result": { 8345 "color": "red", 8346 "index": 1 8347 }, 8348 "to": 4294967295 8349 }, 8350 "type": "range" 8351 } 8352 ], 8353 "thresholds": { 8354 "mode": "absolute", 8355 "steps": [ 8356 { 8357 "color": "green" 8358 } 8359 ] 8360 }, 8361 "unitScale": true 8362 }, 8363 "overrides": [ 8364 { 8365 "matcher": { 8366 "id": "byName", 8367 "options": "A" 8368 }, 8369 "properties": [ 8370 { 8371 "id": "displayName", 8372 "value": "Reconcile errors" 8373 } 8374 ] 8375 } 8376 ] 8377 }, 8378 "gridPos": { 8379 "h": 2, 8380 "w": 4, 8381 "x": 16, 8382 "y": 64 8383 }, 8384 "id": 703, 8385 "options": { 8386 "colorMode": "background", 8387 "graphMode": "none", 8388 "justifyMode": "auto", 8389 "orientation": "auto", 8390 "reduceOptions": { 8391 "calcs": ["lastNotNull"], 8392 "fields": "", 8393 "values": false 8394 }, 8395 "showPercentChange": false, 8396 "textMode": "value_and_name", 8397 "wideLayout": true 8398 }, 8399 "pluginVersion": "10.3.3", 8400 "targets": [ 8401 { 8402 "datasource": { 8403 "type": "prometheus", 8404 "uid": "${DS_PROMETHEUS}" 8405 }, 8406 "editorMode": "code", 8407 "exemplar": false, 8408 "expr": "max(controller_runtime_reconcile_total{namespace=~\"$operatorNamespace\", result=\"error\", controller=\"pooler\"})", 8409 "hide": false, 8410 "instant": true, 8411 "legendFormat": "Pooler Reconcile Errors", 8412 "range": false, 8413 "refId": "RECONCILE_ERRORS_BACKUP" 8414 } 8415 ], 8416 "type": "stat" 8417 }, 8418 { 8419 "datasource": { 8420 "type": "prometheus", 8421 "uid": "${DS_PROMETHEUS}" 8422 }, 8423 "description": "", 8424 "fieldConfig": { 8425 "defaults": { 8426 "color": { 8427 "mode": "palette-classic" 8428 }, 8429 "custom": { 8430 "axisBorderShow": false, 8431 "axisCenteredZero": false, 8432 "axisColorMode": "text", 8433 "axisLabel": "", 8434 "axisPlacement": "auto", 8435 "barAlignment": 0, 8436 "drawStyle": "line", 8437 "fillOpacity": 0, 8438 "gradientMode": "none", 8439 "hideFrom": { 8440 "legend": false, 8441 "tooltip": false, 8442 "viz": false 8443 }, 8444 "insertNulls": false, 8445 "lineInterpolation": "linear", 8446 "lineWidth": 1, 8447 "pointSize": 5, 8448 "scaleDistribution": { 8449 "type": "linear" 8450 }, 8451 "showPoints": "auto", 8452 "spanNulls": false, 8453 "stacking": { 8454 "group": "A", 8455 "mode": "none" 8456 }, 8457 "thresholdsStyle": { 8458 "mode": "off" 8459 } 8460 }, 8461 "mappings": [ 8462 { 8463 "options": { 8464 "0": { 8465 "color": "red", 8466 "index": 0, 8467 "text": "No Ready pods" 8468 } 8469 }, 8470 "type": "value" 8471 } 8472 ], 8473 "thresholds": { 8474 "mode": "absolute", 8475 "steps": [ 8476 { 8477 "color": "green" 8478 } 8479 ] 8480 }, 8481 "unitScale": true 8482 }, 8483 "overrides": [ 8484 { 8485 "matcher": { 8486 "id": "byName", 8487 "options": "A" 8488 }, 8489 "properties": [ 8490 { 8491 "id": "displayName", 8492 "value": "Reconcile errors" 8493 } 8494 ] 8495 } 8496 ] 8497 }, 8498 "gridPos": { 8499 "h": 8, 8500 "w": 4, 8501 "x": 0, 8502 "y": 66 8503 }, 8504 "id": 746, 8505 "options": { 8506 "legend": { 8507 "calcs": [], 8508 "displayMode": "list", 8509 "placement": "bottom", 8510 "showLegend": true 8511 }, 8512 "tooltip": { 8513 "mode": "single", 8514 "sort": "none" 8515 } 8516 }, 8517 "pluginVersion": "10.3.3", 8518 "targets": [ 8519 { 8520 "datasource": { 8521 "type": "prometheus", 8522 "uid": "${DS_PROMETHEUS}" 8523 }, 8524 "editorMode": "code", 8525 "expr": "sum(kube_pod_status_ready{namespace=\"$operatorNamespace\", pod=~\"cloudnative-pg.+|cnpg-controller-manager.+\", condition=\"true\"})", 8526 "hide": false, 8527 "instant": false, 8528 "legendFormat": "Ready Operator Pods", 8529 "range": true, 8530 "refId": "A" 8531 } 8532 ], 8533 "title": "Ready Operator Pods", 8534 "type": "timeseries" 8535 }, 8536 { 8537 "datasource": { 8538 "type": "prometheus", 8539 "uid": "${DS_PROMETHEUS}" 8540 }, 8541 "description": "The operator reconcile errors don't distinguish between database cluster or namespaces.", 8542 "fieldConfig": { 8543 "defaults": { 8544 "color": { 8545 "mode": "palette-classic" 8546 }, 8547 "custom": { 8548 "axisBorderShow": false, 8549 "axisCenteredZero": false, 8550 "axisColorMode": "text", 8551 "axisLabel": "", 8552 "axisPlacement": "auto", 8553 "barAlignment": 0, 8554 "drawStyle": "line", 8555 "fillOpacity": 0, 8556 "gradientMode": "none", 8557 "hideFrom": { 8558 "legend": false, 8559 "tooltip": false, 8560 "viz": false 8561 }, 8562 "insertNulls": false, 8563 "lineInterpolation": "linear", 8564 "lineWidth": 1, 8565 "pointSize": 5, 8566 "scaleDistribution": { 8567 "type": "linear" 8568 }, 8569 "showPoints": "auto", 8570 "spanNulls": false, 8571 "stacking": { 8572 "group": "A", 8573 "mode": "none" 8574 }, 8575 "thresholdsStyle": { 8576 "mode": "off" 8577 } 8578 }, 8579 "mappings": [ 8580 { 8581 "options": { 8582 "0": { 8583 "color": "green", 8584 "index": 0, 8585 "text": "None" 8586 } 8587 }, 8588 "type": "value" 8589 }, 8590 { 8591 "options": { 8592 "from": 1, 8593 "result": { 8594 "color": "red", 8595 "index": 1 8596 }, 8597 "to": 4294967295 8598 }, 8599 "type": "range" 8600 } 8601 ], 8602 "thresholds": { 8603 "mode": "absolute", 8604 "steps": [ 8605 { 8606 "color": "green" 8607 } 8608 ] 8609 }, 8610 "unitScale": true 8611 }, 8612 "overrides": [ 8613 { 8614 "matcher": { 8615 "id": "byName", 8616 "options": "A" 8617 }, 8618 "properties": [ 8619 { 8620 "id": "displayName", 8621 "value": "Reconcile errors" 8622 } 8623 ] 8624 } 8625 ] 8626 }, 8627 "gridPos": { 8628 "h": 8, 8629 "w": 4, 8630 "x": 4, 8631 "y": 66 8632 }, 8633 "id": 767, 8634 "options": { 8635 "legend": { 8636 "calcs": [], 8637 "displayMode": "list", 8638 "placement": "bottom", 8639 "showLegend": true 8640 }, 8641 "tooltip": { 8642 "mode": "single", 8643 "sort": "none" 8644 } 8645 }, 8646 "pluginVersion": "10.3.3", 8647 "targets": [ 8648 { 8649 "datasource": { 8650 "type": "prometheus", 8651 "uid": "${DS_PROMETHEUS}" 8652 }, 8653 "editorMode": "code", 8654 "expr": "max(controller_runtime_reconcile_total{namespace=~\"$operatorNamespace\", result=\"error\", controller=\"cluster\"})", 8655 "hide": false, 8656 "legendFormat": "Cluster Reconcile Errors", 8657 "range": true, 8658 "refId": "RECONCILE_ERRORS_BACKUP" 8659 } 8660 ], 8661 "title": "Cluster Reconcile Errors", 8662 "type": "timeseries" 8663 }, 8664 { 8665 "datasource": { 8666 "type": "prometheus", 8667 "uid": "${DS_PROMETHEUS}" 8668 }, 8669 "description": "The operator reconcile errors don't distinguish between database cluster or namespaces.", 8670 "fieldConfig": { 8671 "defaults": { 8672 "color": { 8673 "mode": "palette-classic" 8674 }, 8675 "custom": { 8676 "axisBorderShow": false, 8677 "axisCenteredZero": false, 8678 "axisColorMode": "text", 8679 "axisLabel": "", 8680 "axisPlacement": "auto", 8681 "barAlignment": 0, 8682 "drawStyle": "line", 8683 "fillOpacity": 0, 8684 "gradientMode": "none", 8685 "hideFrom": { 8686 "legend": false, 8687 "tooltip": false, 8688 "viz": false 8689 }, 8690 "insertNulls": false, 8691 "lineInterpolation": "linear", 8692 "lineWidth": 1, 8693 "pointSize": 5, 8694 "scaleDistribution": { 8695 "type": "linear" 8696 }, 8697 "showPoints": "auto", 8698 "spanNulls": false, 8699 "stacking": { 8700 "group": "A", 8701 "mode": "none" 8702 }, 8703 "thresholdsStyle": { 8704 "mode": "off" 8705 } 8706 }, 8707 "mappings": [ 8708 { 8709 "options": { 8710 "0": { 8711 "color": "green", 8712 "index": 0, 8713 "text": "None" 8714 } 8715 }, 8716 "type": "value" 8717 }, 8718 { 8719 "options": { 8720 "from": 1, 8721 "result": { 8722 "color": "red", 8723 "index": 1 8724 }, 8725 "to": 4294967295 8726 }, 8727 "type": "range" 8728 } 8729 ], 8730 "thresholds": { 8731 "mode": "absolute", 8732 "steps": [ 8733 { 8734 "color": "green" 8735 } 8736 ] 8737 }, 8738 "unitScale": true 8739 }, 8740 "overrides": [ 8741 { 8742 "matcher": { 8743 "id": "byName", 8744 "options": "A" 8745 }, 8746 "properties": [ 8747 { 8748 "id": "displayName", 8749 "value": "Reconcile errors" 8750 } 8751 ] 8752 } 8753 ] 8754 }, 8755 "gridPos": { 8756 "h": 8, 8757 "w": 4, 8758 "x": 8, 8759 "y": 66 8760 }, 8761 "id": 768, 8762 "options": { 8763 "legend": { 8764 "calcs": [], 8765 "displayMode": "list", 8766 "placement": "bottom", 8767 "showLegend": true 8768 }, 8769 "tooltip": { 8770 "mode": "single", 8771 "sort": "none" 8772 } 8773 }, 8774 "pluginVersion": "10.3.3", 8775 "targets": [ 8776 { 8777 "datasource": { 8778 "type": "prometheus", 8779 "uid": "${DS_PROMETHEUS}" 8780 }, 8781 "editorMode": "code", 8782 "expr": "max(controller_runtime_reconcile_total{namespace=~\"$operatorNamespace\", result=\"error\", controller=\"backup\"})", 8783 "hide": false, 8784 "legendFormat": "Backup Reconcile Errors", 8785 "range": true, 8786 "refId": "RECONCILE_ERRORS_BACKUP" 8787 } 8788 ], 8789 "title": "Backup Reconcile Errors", 8790 "type": "timeseries" 8791 }, 8792 { 8793 "datasource": { 8794 "type": "prometheus", 8795 "uid": "${DS_PROMETHEUS}" 8796 }, 8797 "description": "The operator reconcile errors don't distinguish between database cluster or namespaces.", 8798 "fieldConfig": { 8799 "defaults": { 8800 "color": { 8801 "mode": "palette-classic" 8802 }, 8803 "custom": { 8804 "axisBorderShow": false, 8805 "axisCenteredZero": false, 8806 "axisColorMode": "text", 8807 "axisLabel": "", 8808 "axisPlacement": "auto", 8809 "barAlignment": 0, 8810 "drawStyle": "line", 8811 "fillOpacity": 0, 8812 "gradientMode": "none", 8813 "hideFrom": { 8814 "legend": false, 8815 "tooltip": false, 8816 "viz": false 8817 }, 8818 "insertNulls": false, 8819 "lineInterpolation": "linear", 8820 "lineWidth": 1, 8821 "pointSize": 5, 8822 "scaleDistribution": { 8823 "type": "linear" 8824 }, 8825 "showPoints": "auto", 8826 "spanNulls": false, 8827 "stacking": { 8828 "group": "A", 8829 "mode": "none" 8830 }, 8831 "thresholdsStyle": { 8832 "mode": "off" 8833 } 8834 }, 8835 "mappings": [ 8836 { 8837 "options": { 8838 "0": { 8839 "color": "green", 8840 "index": 0, 8841 "text": "None" 8842 } 8843 }, 8844 "type": "value" 8845 }, 8846 { 8847 "options": { 8848 "from": 1, 8849 "result": { 8850 "color": "red", 8851 "index": 1 8852 }, 8853 "to": 4294967295 8854 }, 8855 "type": "range" 8856 } 8857 ], 8858 "thresholds": { 8859 "mode": "absolute", 8860 "steps": [ 8861 { 8862 "color": "green" 8863 } 8864 ] 8865 }, 8866 "unitScale": true 8867 }, 8868 "overrides": [ 8869 { 8870 "matcher": { 8871 "id": "byName", 8872 "options": "A" 8873 }, 8874 "properties": [ 8875 { 8876 "id": "displayName", 8877 "value": "Reconcile errors" 8878 } 8879 ] 8880 } 8881 ] 8882 }, 8883 "gridPos": { 8884 "h": 8, 8885 "w": 4, 8886 "x": 12, 8887 "y": 66 8888 }, 8889 "id": 790, 8890 "options": { 8891 "legend": { 8892 "calcs": [], 8893 "displayMode": "list", 8894 "placement": "bottom", 8895 "showLegend": true 8896 }, 8897 "tooltip": { 8898 "mode": "single", 8899 "sort": "none" 8900 } 8901 }, 8902 "pluginVersion": "10.3.3", 8903 "targets": [ 8904 { 8905 "datasource": { 8906 "type": "prometheus", 8907 "uid": "${DS_PROMETHEUS}" 8908 }, 8909 "editorMode": "code", 8910 "exemplar": false, 8911 "expr": "max(controller_runtime_reconcile_total{namespace=~\"$operatorNamespace\", result=\"error\", controller=~\"scheduledbackup|scheduled-backup\"})", 8912 "hide": false, 8913 "instant": false, 8914 "legendFormat": "Scheduled Backup Reconcile Errors", 8915 "range": true, 8916 "refId": "RECONCILE_ERRORS_BACKUP" 8917 } 8918 ], 8919 "title": "Scheduled Backup Reconcile Errors", 8920 "type": "timeseries" 8921 }, 8922 { 8923 "datasource": { 8924 "type": "prometheus", 8925 "uid": "${DS_PROMETHEUS}" 8926 }, 8927 "description": "The operator reconcile errors don't distinguish between database cluster or namespaces.", 8928 "fieldConfig": { 8929 "defaults": { 8930 "color": { 8931 "mode": "palette-classic" 8932 }, 8933 "custom": { 8934 "axisBorderShow": false, 8935 "axisCenteredZero": false, 8936 "axisColorMode": "text", 8937 "axisLabel": "", 8938 "axisPlacement": "auto", 8939 "barAlignment": 0, 8940 "drawStyle": "line", 8941 "fillOpacity": 0, 8942 "gradientMode": "none", 8943 "hideFrom": { 8944 "legend": false, 8945 "tooltip": false, 8946 "viz": false 8947 }, 8948 "insertNulls": false, 8949 "lineInterpolation": "linear", 8950 "lineWidth": 1, 8951 "pointSize": 5, 8952 "scaleDistribution": { 8953 "type": "linear" 8954 }, 8955 "showPoints": "auto", 8956 "spanNulls": false, 8957 "stacking": { 8958 "group": "A", 8959 "mode": "none" 8960 }, 8961 "thresholdsStyle": { 8962 "mode": "off" 8963 } 8964 }, 8965 "mappings": [ 8966 { 8967 "options": { 8968 "0": { 8969 "color": "green", 8970 "index": 0, 8971 "text": "None" 8972 } 8973 }, 8974 "type": "value" 8975 }, 8976 { 8977 "options": { 8978 "from": 1, 8979 "result": { 8980 "color": "red", 8981 "index": 1 8982 }, 8983 "to": 4294967295 8984 }, 8985 "type": "range" 8986 } 8987 ], 8988 "thresholds": { 8989 "mode": "absolute", 8990 "steps": [ 8991 { 8992 "color": "green" 8993 } 8994 ] 8995 }, 8996 "unitScale": true 8997 }, 8998 "overrides": [ 8999 { 9000 "matcher": { 9001 "id": "byName", 9002 "options": "A" 9003 }, 9004 "properties": [ 9005 { 9006 "id": "displayName", 9007 "value": "Reconcile errors" 9008 } 9009 ] 9010 } 9011 ] 9012 }, 9013 "gridPos": { 9014 "h": 8, 9015 "w": 4, 9016 "x": 16, 9017 "y": 66 9018 }, 9019 "id": 769, 9020 "options": { 9021 "legend": { 9022 "calcs": [], 9023 "displayMode": "list", 9024 "placement": "bottom", 9025 "showLegend": true 9026 }, 9027 "tooltip": { 9028 "mode": "single", 9029 "sort": "none" 9030 } 9031 }, 9032 "pluginVersion": "10.3.3", 9033 "targets": [ 9034 { 9035 "datasource": { 9036 "type": "prometheus", 9037 "uid": "${DS_PROMETHEUS}" 9038 }, 9039 "editorMode": "code", 9040 "expr": "max(controller_runtime_reconcile_total{namespace=~\"$operatorNamespace\", result=\"error\", controller=\"pooler\"})", 9041 "hide": false, 9042 "legendFormat": "Pooler Reconcile Errors", 9043 "range": true, 9044 "refId": "RECONCILE_ERRORS_BACKUP" 9045 } 9046 ], 9047 "title": "Pooler Reconcile Errors", 9048 "type": "timeseries" 9049 } 9050 ], 9051 "title": "Operator", 9052 "type": "row" 9053 } 9054 ], 9055 "refresh": "30s", 9056 "revision": 1, 9057 "schemaVersion": 39, 9058 "tags": ["cloudnativepg"], 9059 "templating": { 9060 "list": [ 9061 { 9062 "current": { 9063 "selected": false, 9064 "text": "Prometheus", 9065 "value": "prometheus" 9066 }, 9067 "hide": 0, 9068 "includeAll": false, 9069 "label": "Datasource", 9070 "multi": false, 9071 "name": "DS_PROMETHEUS", 9072 "options": [], 9073 "query": "prometheus", 9074 "queryValue": "", 9075 "refresh": 1, 9076 "regex": "", 9077 "skipUrlSync": false, 9078 "type": "datasource" 9079 }, 9080 { 9081 "current": {}, 9082 "datasource": { 9083 "type": "prometheus", 9084 "uid": "${DS_PROMETHEUS}" 9085 }, 9086 "definition": "label_values(controller_runtime_webhook_requests_total{webhook=\"/mutate-postgresql-cnpg-io-v1-cluster\"},namespace)", 9087 "description": "Namespace where the CNPG operator is located", 9088 "hide": 0, 9089 "includeAll": false, 9090 "label": "Operator Namespace", 9091 "multi": false, 9092 "name": "operatorNamespace", 9093 "options": [], 9094 "query": { 9095 "qryType": 1, 9096 "query": "label_values(controller_runtime_webhook_requests_total{webhook=\"/mutate-postgresql-cnpg-io-v1-cluster\"},namespace)", 9097 "refId": "PrometheusVariableQueryEditor-VariableQuery" 9098 }, 9099 "refresh": 2, 9100 "regex": "", 9101 "skipUrlSync": false, 9102 "sort": 0, 9103 "type": "query" 9104 }, 9105 { 9106 "current": {}, 9107 "datasource": { 9108 "type": "prometheus", 9109 "uid": "${DS_PROMETHEUS}" 9110 }, 9111 "definition": "cnpg_collector_up", 9112 "description": "Namespace where the database cluster is located", 9113 "hide": 0, 9114 "includeAll": false, 9115 "label": "Database Namespace", 9116 "multi": false, 9117 "name": "namespace", 9118 "options": [], 9119 "query": { 9120 "query": "cnpg_collector_up", 9121 "refId": "StandardVariableQuery" 9122 }, 9123 "refresh": 2, 9124 "regex": "/namespace=\"(?<text>[^\"]+)/g", 9125 "skipUrlSync": false, 9126 "sort": 0, 9127 "type": "query" 9128 }, 9129 { 9130 "current": {}, 9131 "datasource": { 9132 "type": "prometheus", 9133 "uid": "${DS_PROMETHEUS}" 9134 }, 9135 "definition": "cnpg_collector_up{namespace=~\"$namespace\"}", 9136 "description": "CNPG Cluster", 9137 "hide": 0, 9138 "includeAll": false, 9139 "label": "Cluster", 9140 "multi": false, 9141 "name": "cluster", 9142 "options": [], 9143 "query": { 9144 "query": "cnpg_collector_up{namespace=~\"$namespace\"}", 9145 "refId": "PrometheusVariableQueryEditor-VariableQuery" 9146 }, 9147 "refresh": 2, 9148 "regex": "/\\bcluster\\b=\"(?<text>[^\"]+)/g", 9149 "skipUrlSync": false, 9150 "sort": 1, 9151 "type": "query" 9152 }, 9153 { 9154 "allValue": "$cluster-([1-9][0-9]*)", 9155 "current": {}, 9156 "datasource": { 9157 "type": "prometheus", 9158 "uid": "${DS_PROMETHEUS}" 9159 }, 9160 "definition": "cnpg_collector_up{namespace=~\"$namespace\",pod=~\"$cluster-([1-9][0-9]*)$\"}", 9161 "description": "Database cluster instances", 9162 "hide": 0, 9163 "includeAll": true, 9164 "label": "Instances", 9165 "multi": true, 9166 "name": "instances", 9167 "options": [], 9168 "query": { 9169 "qryType": 4, 9170 "query": "cnpg_collector_up{namespace=~\"$namespace\",pod=~\"$cluster-([1-9][0-9]*)$\"}", 9171 "refId": "PrometheusVariableQueryEditor-VariableQuery" 9172 }, 9173 "refresh": 2, 9174 "regex": "/pod=\"(?<text>[^\"]+)/g", 9175 "skipUrlSync": false, 9176 "sort": 1, 9177 "type": "query" 9178 } 9179 ] 9180 }, 9181 "time": { 9182 "from": "now-7d", 9183 "to": "now" 9184 }, 9185 "timepicker": { 9186 "nowDelay": "" 9187 }, 9188 "timezone": "", 9189 "title": "CloudNativePG", 9190 "uid": "cloudnative-pg", 9191 "version": 2, 9192 "weekStart": "" 9193 }