Times Reported Time consuming queries #1

x Hide

[ User: monitoring_admin - Total duration: 6h9m7s - Times executed: 1436 ]

x Hide

CREATE INDEX IF NOT EXISTS idx_uptime_checks_key ON observability.uptime_checks (check_key, checked_at DESC);

Date: 2026-05-25 10:38:01
Duration: 16s332ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-25_000000.csv

CREATE INDEX IF NOT EXISTS idx_uptime_checks_key ON observability.uptime_checks (check_key, checked_at DESC);

Date: 2026-05-25 11:09:01
Duration: 16s316ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-25_000000.csv

CREATE INDEX IF NOT EXISTS idx_uptime_checks_key ON observability.uptime_checks (check_key, checked_at DESC);

Date: 2026-05-25 09:58:01
Duration: 16s288ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-25_000000.csv

x Hide

Times Reported Time consuming queries #2

x Hide

[ User: monitoring_admin - Total duration: 6h9m7s - Times executed: 1436 ]

x Hide

CREATE SCHEMA IF NOT EXISTS observability;

Date: 2026-05-25 10:38:01
Duration: 16s332ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-25_000000.csv

CREATE SCHEMA IF NOT EXISTS observability;

Date: 2026-05-25 11:09:01
Duration: 16s316ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-25_000000.csv

CREATE SCHEMA IF NOT EXISTS observability;

Date: 2026-05-25 09:58:01
Duration: 16s288ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-25_000000.csv

x Hide

Times Reported Time consuming queries #3

x Hide

[ User: monitoring_admin - Total duration: 6h9m7s - Times executed: 1436 ]

x Hide

CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );

Date: 2026-05-25 10:38:01
Duration: 16s332ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-25_000000.csv

CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );

Date: 2026-05-25 11:09:01
Duration: 16s316ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-25_000000.csv

CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );

Date: 2026-05-25 09:58:01
Duration: 16s288ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-25_000000.csv

x Hide

Times Reported Time consuming queries #4

x Hide

[ User: monitoring_admin - Total duration: 6h9m7s - Times executed: 1436 ]

x Hide

CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);

Date: 2026-05-25 10:38:01
Duration: 16s332ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-25_000000.csv

CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);

Date: 2026-05-25 11:09:01
Duration: 16s316ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-25_000000.csv

CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);

Date: 2026-05-25 09:58:01
Duration: 16s288ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-25_000000.csv

x Hide

Times Reported Time consuming queries #5

x Hide

[ User: monitoring_admin - Total duration: 6h9m7s - Times executed: 1436 ]

x Hide

CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);

Date: 2026-05-25 10:38:01
Duration: 16s332ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-25_000000.csv

CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);

Date: 2026-05-25 11:09:01
Duration: 16s316ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-25_000000.csv

CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);

Date: 2026-05-25 09:58:01
Duration: 16s288ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-25_000000.csv

x Hide

Times Reported Time consuming queries #6

x Hide

[ User: monitoring_admin - Total duration: 6h9m7s - Times executed: 1436 ]

x Hide

CREATE INDEX IF NOT EXISTS idx_uptime_checks_endpoint ON observability.uptime_checks (endpoint, checked_at DESC);

Date: 2026-05-25 10:38:01
Duration: 16s332ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-25_000000.csv

CREATE INDEX IF NOT EXISTS idx_uptime_checks_endpoint ON observability.uptime_checks (endpoint, checked_at DESC);

Date: 2026-05-25 11:09:01
Duration: 16s316ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-25_000000.csv

CREATE INDEX IF NOT EXISTS idx_uptime_checks_endpoint ON observability.uptime_checks (endpoint, checked_at DESC);

Date: 2026-05-25 09:58:01
Duration: 16s288ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-25_000000.csv

x Hide

Times Reported Time consuming queries #7

x Hide

[ User: monitoring_admin - Total duration: 6h9m7s - Times executed: 1436 ]

x Hide

CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );

Date: 2026-05-25 10:38:01
Duration: 16s332ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-25_000000.csv

CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );

Date: 2026-05-25 11:09:01
Duration: 16s316ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-25_000000.csv

CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );

Date: 2026-05-25 09:58:01
Duration: 16s288ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-25_000000.csv

x Hide

Times Reported Time consuming queries #8

x Hide

[ User: monitoring_admin - Total duration: 6h9m7s - Times executed: 1436 ]

x Hide

CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );

Date: 2026-05-25 10:38:01
Duration: 16s332ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-25_000000.csv

CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );

Date: 2026-05-25 11:09:01
Duration: 16s316ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-25_000000.csv

CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );

Date: 2026-05-25 09:58:01
Duration: 16s288ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-25_000000.csv