Changeset View
Changeset View
Standalone View
Standalone View
site-modules/profile/files/prometheus/sql/config/queries.yml
| Show First 20 Lines • Show All 216 Lines • ▼ Show 20 Lines | query: >- | ||||
| COALESCE(n_tup_hot_upd, 0)::float AS n_tup_hot_upd, | COALESCE(n_tup_hot_upd, 0)::float AS n_tup_hot_upd, | ||||
| COALESCE(n_live_tup, 0)::float AS n_live_tup, | COALESCE(n_live_tup, 0)::float AS n_live_tup, | ||||
| COALESCE(n_dead_tup, 0)::float AS n_dead_tup, | COALESCE(n_dead_tup, 0)::float AS n_dead_tup, | ||||
| COALESCE(vacuum_count, 0)::float AS vacuum_count, | COALESCE(vacuum_count, 0)::float AS vacuum_count, | ||||
| COALESCE(autovacuum_count, 0)::float AS autovacuum_count, | COALESCE(autovacuum_count, 0)::float AS autovacuum_count, | ||||
| COALESCE(analyze_count, 0)::float AS analyze_count, | COALESCE(analyze_count, 0)::float AS analyze_count, | ||||
| COALESCE(autoanalyze_count, 0)::float AS autoanalyze_count | COALESCE(autoanalyze_count, 0)::float AS autoanalyze_count | ||||
| FROM pg_stat_user_tables FULL JOIN (VALUES(0)) filler(i) ON TRUE | FROM pg_stat_user_tables FULL JOIN (VALUES(0)) filler(i) ON TRUE | ||||
| WHERE schemaname not like 'pg_temp%' | |||||
| - name: "pg_statio_user_tables" | - name: "pg_statio_user_tables" | ||||
| help: "IO statistics" | help: "IO statistics" | ||||
| scope: database | scope: database | ||||
| labels: | labels: | ||||
| - "datname" | - "datname" | ||||
| - "schemaname" | - "schemaname" | ||||
| - "relname" | - "relname" | ||||
| values: | values: | ||||
| - "heap_blks_read" | - "heap_blks_read" | ||||
| - "heap_blks_hit" | - "heap_blks_hit" | ||||
| - "idx_blks_read" | - "idx_blks_read" | ||||
| - "idx_blks_hit" | - "idx_blks_hit" | ||||
| query: >- | query: >- | ||||
| SELECT | SELECT | ||||
| current_database()::text AS datname, | current_database()::text AS datname, | ||||
| COALESCE(schemaname::text, 'null') AS schemaname, | COALESCE(schemaname::text, 'null') AS schemaname, | ||||
| COALESCE(relname::text, 'null') AS relname, | COALESCE(relname::text, 'null') AS relname, | ||||
| COALESCE(heap_blks_read::float, 0) AS heap_blks_read, | COALESCE(heap_blks_read::float, 0) AS heap_blks_read, | ||||
| COALESCE(heap_blks_hit::float, 0) AS heap_blks_hit, | COALESCE(heap_blks_hit::float, 0) AS heap_blks_hit, | ||||
| COALESCE(idx_blks_read::float, 0) AS idx_blks_read, | COALESCE(idx_blks_read::float, 0) AS idx_blks_read, | ||||
| COALESCE(idx_blks_hit::float, 0) AS idx_blks_hit | COALESCE(idx_blks_hit::float, 0) AS idx_blks_hit | ||||
| FROM pg_statio_user_tables FULL JOIN (VALUES(0)) filler(i) ON TRUE | FROM pg_statio_user_tables FULL JOIN (VALUES(0)) filler(i) ON TRUE | ||||
| WHERE schemaname not like 'pg_temp%' | |||||
| - name: "BufferAccess" | - name: "BufferAccess" | ||||
| help: "buffer access statistics" | help: "buffer access statistics" | ||||
| scope: database | scope: database | ||||
| labels: | labels: | ||||
| - "datname" | - "datname" | ||||
| - "schemaname" | - "schemaname" | ||||
| - "relname" | - "relname" | ||||
| values: | values: | ||||
| - "reads" | - "reads" | ||||
| query: >- | query: >- | ||||
| SELECT | SELECT | ||||
| current_database()::text AS datname, | current_database()::text AS datname, | ||||
| COALESCE(schemaname::text, 'null') AS schemaname, | COALESCE(schemaname::text, 'null') AS schemaname, | ||||
| COALESCE(relname::text, 'null') AS relname, | COALESCE(relname::text, 'null') AS relname, | ||||
| SUM(COALESCE(heap_blks_read, 0) | SUM(COALESCE(heap_blks_read, 0) | ||||
| + COALESCE(heap_blks_hit, 0) | + COALESCE(heap_blks_hit, 0) | ||||
| + COALESCE(idx_blks_hit, 0) | + COALESCE(idx_blks_hit, 0) | ||||
| + COALESCE(idx_blks_read, 0) | + COALESCE(idx_blks_read, 0) | ||||
| + COALESCE(toast_blks_hit, 0) | + COALESCE(toast_blks_hit, 0) | ||||
| + COALESCE(toast_blks_read, 0) | + COALESCE(toast_blks_read, 0) | ||||
| + COALESCE(tidx_blks_hit, 0) | + COALESCE(tidx_blks_hit, 0) | ||||
| + COALESCE(tidx_blks_read, 0)) * 8192::bigint as reads | + COALESCE(tidx_blks_read, 0)) * 8192::bigint as reads | ||||
| FROM pg_statio_user_tables FULL JOIN (VALUES(0)) filler(i) ON TRUE | FROM pg_statio_user_tables FULL JOIN (VALUES(0)) filler(i) ON TRUE | ||||
| WHERE schemaname not like 'pg_temp%' | |||||
| GROUP BY 1, 2, 3 | GROUP BY 1, 2, 3 | ||||
| - name: "Maintenancecounters" | - name: "Maintenancecounters" | ||||
| help: "table maintenance job counters" | help: "table maintenance job counters" | ||||
| scope: database | scope: database | ||||
| labels: | labels: | ||||
| - "datname" | - "datname" | ||||
| values: | values: | ||||
| - "vacuum_count" | - "vacuum_count" | ||||
| - "autovacuum_count" | - "autovacuum_count" | ||||
| - "analyze_count" | - "analyze_count" | ||||
| - "autoanalyze_count" | - "autoanalyze_count" | ||||
| query: >- | query: >- | ||||
| SELECT | SELECT | ||||
| current_database()::text AS datname, | current_database()::text AS datname, | ||||
| COALESCE(SUM(vacuum_count), 0) vacuum_count, | COALESCE(SUM(vacuum_count), 0) vacuum_count, | ||||
| COALESCE(SUM(autovacuum_count), 0) autovacuum_count, | COALESCE(SUM(autovacuum_count), 0) autovacuum_count, | ||||
| COALESCE(SUM(analyze_count), 0) analyze_count, | COALESCE(SUM(analyze_count), 0) analyze_count, | ||||
| COALESCE(SUM(autoanalyze_count), 0) autoanalyze_count | COALESCE(SUM(autoanalyze_count), 0) autoanalyze_count | ||||
| FROM pg_stat_user_tables | FROM pg_stat_user_tables | ||||
| WHERE schemaname not like 'pg_temp%' | |||||