Times Reported Time consuming queries #1

x Hide

[ User: monitoring_admin - Total duration: 7h1m13s - Times executed: 1438 ]

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-24 03:36:01
Duration: 19s390ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-24_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-24 06:10:01
Duration: 19s373ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-24_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-24 02:45:01
Duration: 19s297ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-24_000000.csv

x Hide

Times Reported Time consuming queries #2

x Hide

[ User: monitoring_admin - Total duration: 7h1m13s - Times executed: 1438 ]

x Hide

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

Date: 2026-05-24 03:36:01
Duration: 19s390ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-24_000000.csv

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

Date: 2026-05-24 06:10:01
Duration: 19s373ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-24_000000.csv

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

Date: 2026-05-24 02:45:01
Duration: 19s297ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-24_000000.csv

x Hide

Times Reported Time consuming queries #3

x Hide

[ User: monitoring_admin - Total duration: 7h1m13s - Times executed: 1438 ]

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-24 03:36:01
Duration: 19s390ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-24_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-24 06:10:01
Duration: 19s373ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-24_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-24 02:45:01
Duration: 19s297ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-24_000000.csv

x Hide

Times Reported Time consuming queries #4

x Hide

[ User: monitoring_admin - Total duration: 7h1m13s - Times executed: 1438 ]

x Hide

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

Date: 2026-05-24 03:36:01
Duration: 19s390ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-24_000000.csv

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

Date: 2026-05-24 06:10:01
Duration: 19s373ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-24_000000.csv

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

Date: 2026-05-24 02:45:01
Duration: 19s297ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-24_000000.csv

x Hide

Times Reported Time consuming queries #5

x Hide

[ User: monitoring_admin - Total duration: 7h1m13s - Times executed: 1438 ]

x Hide

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

Date: 2026-05-24 03:36:01
Duration: 19s390ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-24_000000.csv

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

Date: 2026-05-24 06:10:01
Duration: 19s373ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-24_000000.csv

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

Date: 2026-05-24 02:45:01
Duration: 19s297ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-24_000000.csv

x Hide

Times Reported Time consuming queries #6

x Hide

[ User: monitoring_admin - Total duration: 7h1m13s - Times executed: 1438 ]

x Hide

CREATE SCHEMA IF NOT EXISTS observability;

Date: 2026-05-24 03:36:01
Duration: 19s390ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-24_000000.csv

CREATE SCHEMA IF NOT EXISTS observability;

Date: 2026-05-24 06:10:01
Duration: 19s373ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-24_000000.csv

CREATE SCHEMA IF NOT EXISTS observability;

Date: 2026-05-24 02:45:01
Duration: 19s297ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-24_000000.csv

x Hide

Times Reported Time consuming queries #7

x Hide

[ User: monitoring_admin - Total duration: 7h1m13s - Times executed: 1438 ]

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-24 03:36:01
Duration: 19s390ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-24_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-24 06:10:01
Duration: 19s373ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-24_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-24 02:45:01
Duration: 19s297ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-24_000000.csv

x Hide

Times Reported Time consuming queries #8

x Hide

[ User: monitoring_admin - Total duration: 7h1m13s - Times executed: 1438 ]

x Hide

ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS label text;

Date: 2026-05-24 03:36:01
Duration: 19s390ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-24_000000.csv

ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS label text;

Date: 2026-05-24 06:10:01
Duration: 19s373ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-24_000000.csv

ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS label text;

Date: 2026-05-24 02:45:01
Duration: 19s297ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-24_000000.csv

x Hide