| 1 | taxonomy_version: 1 |
| 2 | plugin_name: go.d.plugin |
| 3 | module_name: postgres |
| 4 | placements: |
| 5 | - id: postgres |
| 6 | section_id: applications.postgres |
| 7 | title: Postgres |
| 8 | icon: postgres |
| 9 | families: true |
| 10 | items: |
| 11 | - type: grid |
| 12 | id: postgres-heads |
| 13 | items: |
| 14 | - type: context |
| 15 | title: Average Connections Utilization |
| 16 | contexts: |
| 17 | - postgres.connections_utilization |
| 18 | chart_library: gauge |
| 19 | group_by: |
| 20 | - selected |
| 21 | aggregation_method: avg |
| 22 | value_range: [0, 100] |
| 23 | colors: |
| 24 | - "#6633CC" |
| 25 | - "#905bfd" |
| 26 | layout: { left: 0, top: 0, width: 2.5, height: 5 } |
| 27 | - type: context |
| 28 | title: Avg Fetched Row Ratio |
| 29 | contexts: |
| 30 | - postgres.db_ops_fetched_rows_ratio |
| 31 | chart_library: dygraph |
| 32 | group_by: |
| 33 | - selected |
| 34 | aggregation_method: avg |
| 35 | sparkline: true |
| 36 | renderer: |
| 37 | overlays: |
| 38 | - type: latestValue |
| 39 | colors: |
| 40 | - "#AAAA11" |
| 41 | - "#ef0aef" |
| 42 | layout: { left: 2.5, top: 0, width: 2, height: 5 } |
| 43 | - type: context |
| 44 | title: Average Cache Miss Ratio |
| 45 | contexts: |
| 46 | - postgres.db_cache_io_ratio |
| 47 | chart_library: gauge |
| 48 | group_by: |
| 49 | - selected |
| 50 | aggregation_method: avg |
| 51 | value_range: [0, 100] |
| 52 | colors: |
| 53 | - "#DC3912" |
| 54 | - "#FE3912" |
| 55 | layout: { left: 4.5, top: 0, width: 2.5, height: 5 } |
| 56 | - type: context |
| 57 | title: Connection State Count |
| 58 | contexts: |
| 59 | - postgres.connections_state_count |
| 60 | chart_library: bars |
| 61 | dimensions_sort: valueDesc |
| 62 | layout: { left: 7, top: 0, width: 2.5, height: 5 } |
| 63 | - type: context |
| 64 | title: Minimum Uptime |
| 65 | contexts: |
| 66 | - postgres.uptime |
| 67 | chart_library: number |
| 68 | group_by: |
| 69 | - selected |
| 70 | aggregation_method: min |
| 71 | layout: { left: 9.5, top: 0, width: 2.5, height: 1.66 } |
| 72 | - type: context |
| 73 | title: Total Database count |
| 74 | contexts: |
| 75 | - postgres.databases_count |
| 76 | chart_library: number |
| 77 | group_by: |
| 78 | - selected |
| 79 | layout: { left: 9.5, top: 1.66, width: 2.5, height: 1.66 } |
| 80 | - type: context |
| 81 | title: Total Database Size |
| 82 | contexts: |
| 83 | - postgres.db_size |
| 84 | chart_library: dygraph |
| 85 | sparkline: true |
| 86 | renderer: |
| 87 | overlays: |
| 88 | - type: latestValue |
| 89 | layout: { left: 9.5, top: 3.33, width: 2.5, height: 1.66 } |
| 90 | - type: context |
| 91 | title: Connections Utilization per Database |
| 92 | contexts: |
| 93 | - postgres.db_connections_utilization |
| 94 | chart_library: bars |
| 95 | group_by: |
| 96 | - label |
| 97 | group_by_label: |
| 98 | - database |
| 99 | dimensions_sort: valueDesc |
| 100 | layout: { left: 0, top: 5, width: 2.5, height: 5 } |
| 101 | - type: context |
| 102 | title: Fetched Row Ratio per DB |
| 103 | contexts: |
| 104 | - postgres.db_ops_fetched_rows_ratio |
| 105 | chart_library: bars |
| 106 | group_by: |
| 107 | - label |
| 108 | group_by_label: |
| 109 | - database |
| 110 | dimensions_sort: valueDesc |
| 111 | layout: { left: 2.5, top: 5, width: 2, height: 5 } |
| 112 | - type: context |
| 113 | title: Cache Miss Ratio per DB |
| 114 | contexts: |
| 115 | - postgres.db_cache_io_ratio |
| 116 | chart_library: bars |
| 117 | group_by: |
| 118 | - label |
| 119 | group_by_label: |
| 120 | - database |
| 121 | dimensions_sort: valueDesc |
| 122 | layout: { left: 4.5, top: 5, width: 2.5, height: 5 } |
| 123 | - type: context |
| 124 | title: Rows Written per Database |
| 125 | contexts: |
| 126 | - postgres.db_ops_write_rows_rate |
| 127 | chart_library: bars |
| 128 | dimensions_sort: valueDesc |
| 129 | layout: { left: 7, top: 5, width: 2.5, height: 5 } |
| 130 | - type: context |
| 131 | title: Database Sizes |
| 132 | contexts: |
| 133 | - postgres.db_size |
| 134 | chart_library: bars |
| 135 | group_by: |
| 136 | - label |
| 137 | group_by_label: |
| 138 | - database |
| 139 | dimensions_sort: valueDesc |
| 140 | layout: { left: 9.5, top: 5, width: 2.5, height: 5 } |
| 141 | - type: context |
| 142 | title: Top Queries by Duration |
| 143 | contexts: |
| 144 | - postgres.queries_duration |
| 145 | chart_library: bars |
| 146 | dimensions_sort: valueDesc |
| 147 | layout: { left: 0, top: 10, width: 4.5, height: 5 } |
| 148 | - type: context |
| 149 | title: Average Dead Row Ratio |
| 150 | contexts: |
| 151 | - postgres.table_rows_dead_ratio |
| 152 | chart_library: gauge |
| 153 | group_by: |
| 154 | - selected |
| 155 | aggregation_method: avg |
| 156 | value_range: [0, 100] |
| 157 | colors: |
| 158 | - "#AAAA11" |
| 159 | - "#ef0aef" |
| 160 | layout: { left: 4.5, top: 10, width: 2.5, height: 5 } |
| 161 | - type: context |
| 162 | title: Average Table Bloat % |
| 163 | contexts: |
| 164 | - postgres.table_bloat_size_perc |
| 165 | chart_library: gauge |
| 166 | group_by: |
| 167 | - selected |
| 168 | aggregation_method: avg |
| 169 | value_range: [0, 100] |
| 170 | colors: |
| 171 | - "#DC3912" |
| 172 | - "#FE3912" |
| 173 | layout: { left: 7, top: 10, width: 2.5, height: 5 } |
| 174 | - type: context |
| 175 | title: Average Index Bloat % |
| 176 | contexts: |
| 177 | - postgres.index_bloat_size_perc |
| 178 | chart_library: gauge |
| 179 | group_by: |
| 180 | - selected |
| 181 | aggregation_method: avg |
| 182 | value_range: [0, 100] |
| 183 | colors: |
| 184 | - "#DC3912" |
| 185 | - "#FE3912" |
| 186 | layout: { left: 9.5, top: 10, width: 2.5, height: 5 } |
| 187 | - postgres.connections_utilization |
| 188 | - postgres.connections_usage |
| 189 | - postgres.connections_state_count |
| 190 | - postgres.transactions_duration |
| 191 | - postgres.queries_duration |
| 192 | - postgres.locks_utilization |
| 193 | - postgres.checkpoints_rate |
| 194 | - postgres.checkpoints_time |
| 195 | - postgres.bgwriter_halts_rate |
| 196 | - postgres.buffers_io_rate |
| 197 | - postgres.buffers_backend_fsync_rate |
| 198 | - postgres.buffers_allocated_rate |
| 199 | - postgres.wal_io_rate |
| 200 | - postgres.wal_files_count |
| 201 | - postgres.wal_archiving_files_count |
| 202 | - postgres.autovacuum_workers_count |
| 203 | - postgres.txid_exhaustion_towards_autovacuum_perc |
| 204 | - postgres.txid_exhaustion_perc |
| 205 | - postgres.txid_exhaustion_oldest_txid_num |
| 206 | - postgres.catalog_relations_count |
| 207 | - postgres.catalog_relations_size |
| 208 | - postgres.uptime |
| 209 | - postgres.databases_count |
| 210 | - postgres.replication_app_wal_lag_size |
| 211 | - postgres.replication_app_wal_lag_time |
| 212 | - postgres.replication_slot_files_count |
| 213 | - postgres.db_transactions_ratio |
| 214 | - postgres.db_transactions_rate |
| 215 | - postgres.db_connections_utilization |
| 216 | - postgres.db_connections_count |
| 217 | - postgres.db_cache_io_ratio |
| 218 | - postgres.db_io_rate |
| 219 | - postgres.db_ops_fetched_rows_ratio |
| 220 | - postgres.db_ops_read_rows_rate |
| 221 | - postgres.db_ops_write_rows_rate |
| 222 | - postgres.db_conflicts_rate |
| 223 | - postgres.db_conflicts_reason_rate |
| 224 | - postgres.db_deadlocks_rate |
| 225 | - postgres.db_locks_held_count |
| 226 | - postgres.db_locks_awaited_count |
| 227 | - postgres.db_temp_files_created_rate |
| 228 | - postgres.db_temp_files_io_rate |
| 229 | - postgres.db_size |
| 230 | - postgres.table_rows_dead_ratio |
| 231 | - postgres.table_rows_count |
| 232 | - postgres.table_ops_rows_rate |
| 233 | - postgres.table_ops_rows_hot_ratio |
| 234 | - postgres.table_ops_rows_hot_rate |
| 235 | - postgres.table_cache_io_ratio |
| 236 | - postgres.table_io_rate |
| 237 | - postgres.table_index_cache_io_ratio |
| 238 | - postgres.table_index_io_rate |
| 239 | - postgres.table_toast_cache_io_ratio |
| 240 | - postgres.table_toast_io_rate |
| 241 | - postgres.table_toast_index_cache_io_ratio |
| 242 | - postgres.table_toast_index_io_rate |
| 243 | - postgres.table_scans_rate |
| 244 | - postgres.table_scans_rows_rate |
| 245 | - postgres.table_autovacuum_since_time |
| 246 | - postgres.table_vacuum_since_time |
| 247 | - postgres.table_autoanalyze_since_time |
| 248 | - postgres.table_analyze_since_time |
| 249 | - postgres.table_null_columns |
| 250 | - postgres.table_size |
| 251 | - postgres.table_bloat_size_perc |
| 252 | - postgres.table_bloat_size |
| 253 | - postgres.index_size |
| 254 | - postgres.index_bloat_size_perc |
| 255 | - postgres.index_bloat_size |
| 256 | - postgres.index_usage_status |