WITH start_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'test', 'dev') AND collected_at <= '2026-04-25 11:05:14+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), fallback_start AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'test', 'dev') AND collected_at BETWEEN '2026-04-25 11:05:14+02' AND '2026-04-25 23:05:14+02' ORDER BY tenant_key, fingerprint, collected_at ASC ), end_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, query, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'test', 'dev') AND collected_at BETWEEN '2026-04-25 11:05:14+02' AND '2026-04-25 23:05:14+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), deltas AS ( SELECT e.tenant_key, e.fingerprint, e.query, e.collected_at AS last_seen, GREATEST (COALESCE(e.total_time_ms, 0) - COALESCE(s.total_time_ms, fs.total_time_ms, 0), 0) AS total_time_ms, GREATEST (COALESCE(e.calls, 0) - COALESCE(s.calls, fs.calls, 0), 0) AS calls, GREATEST (COALESCE(e.rows_returned, 0) - COALESCE(s.rows_returned, fs.rows_returned, 0), 0) AS rows_returned FROM end_snap e LEFT JOIN start_snap s ON s.tenant_key = e.tenant_key AND s.fingerprint = e.fingerprint LEFT JOIN fallback_start fs ON fs.tenant_key = e.tenant_key AND fs.fingerprint = e.fingerprint AND s.tenant_key IS NULL ) SELECT fingerprint, MAX(query) AS query, MAX(last_seen) AS last_seen, SUM(total_time_ms) AS total_time_ms, SUM(calls) AS calls, SUM(rows_returned) AS rows_returned, CASE WHEN SUM(calls) > 0 THEN SUM(total_time_ms) / SUM(calls) ELSE 0 END AS mean_time_ms, array_agg(DISTINCT tenant_key ORDER BY tenant_key) AS tenant_keys FROM deltas WHERE total_time_ms > 0 OR calls > 0 GROUP BY fingerprint ORDER BY total_time_ms DESC, calls DESC LIMIT '20' OFFSET '0';

Date: 2026-04-25 23:06:05
Duration: 50s626ms
Database: zemm_monitoring
User: labanimal
Log file: /var/log/postgresql/postgresql-2026-04-25_000000.csv

WITH start_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'test', 'dev') AND collected_at <= '2026-04-25 11:21:15+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), fallback_start AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'test', 'dev') AND collected_at BETWEEN '2026-04-25 11:21:15+02' AND '2026-04-25 23:21:15+02' ORDER BY tenant_key, fingerprint, collected_at ASC ), end_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, query, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'test', 'dev') AND collected_at BETWEEN '2026-04-25 11:21:15+02' AND '2026-04-25 23:21:15+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), deltas AS ( SELECT e.tenant_key, e.fingerprint, e.query, e.collected_at AS last_seen, GREATEST (COALESCE(e.total_time_ms, 0) - COALESCE(s.total_time_ms, fs.total_time_ms, 0), 0) AS total_time_ms, GREATEST (COALESCE(e.calls, 0) - COALESCE(s.calls, fs.calls, 0), 0) AS calls, GREATEST (COALESCE(e.rows_returned, 0) - COALESCE(s.rows_returned, fs.rows_returned, 0), 0) AS rows_returned FROM end_snap e LEFT JOIN start_snap s ON s.tenant_key = e.tenant_key AND s.fingerprint = e.fingerprint LEFT JOIN fallback_start fs ON fs.tenant_key = e.tenant_key AND fs.fingerprint = e.fingerprint AND s.tenant_key IS NULL ) SELECT fingerprint, MAX(query) AS query, MAX(last_seen) AS last_seen, SUM(total_time_ms) AS total_time_ms, SUM(calls) AS calls, SUM(rows_returned) AS rows_returned, CASE WHEN SUM(calls) > 0 THEN SUM(total_time_ms) / SUM(calls) ELSE 0 END AS mean_time_ms, array_agg(DISTINCT tenant_key ORDER BY tenant_key) AS tenant_keys FROM deltas WHERE total_time_ms > 0 OR calls > 0 GROUP BY fingerprint ORDER BY total_time_ms DESC, calls DESC LIMIT '20' OFFSET '0';

Date: 2026-04-25 23:21:49
Duration: 34s679ms
Database: zemm_monitoring
User: labanimal
Log file: /var/log/postgresql/postgresql-2026-04-25_000000.csv

WITH start_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'test', 'dev') AND collected_at <= '2026-04-25 11:26:15+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), fallback_start AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'test', 'dev') AND collected_at BETWEEN '2026-04-25 11:26:15+02' AND '2026-04-25 23:26:15+02' ORDER BY tenant_key, fingerprint, collected_at ASC ), end_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, query, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'test', 'dev') AND collected_at BETWEEN '2026-04-25 11:26:15+02' AND '2026-04-25 23:26:15+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), deltas AS ( SELECT e.tenant_key, e.fingerprint, e.query, e.collected_at AS last_seen, GREATEST (COALESCE(e.total_time_ms, 0) - COALESCE(s.total_time_ms, fs.total_time_ms, 0), 0) AS total_time_ms, GREATEST (COALESCE(e.calls, 0) - COALESCE(s.calls, fs.calls, 0), 0) AS calls, GREATEST (COALESCE(e.rows_returned, 0) - COALESCE(s.rows_returned, fs.rows_returned, 0), 0) AS rows_returned FROM end_snap e LEFT JOIN start_snap s ON s.tenant_key = e.tenant_key AND s.fingerprint = e.fingerprint LEFT JOIN fallback_start fs ON fs.tenant_key = e.tenant_key AND fs.fingerprint = e.fingerprint AND s.tenant_key IS NULL ) SELECT fingerprint, MAX(query) AS query, MAX(last_seen) AS last_seen, SUM(total_time_ms) AS total_time_ms, SUM(calls) AS calls, SUM(rows_returned) AS rows_returned, CASE WHEN SUM(calls) > 0 THEN SUM(total_time_ms) / SUM(calls) ELSE 0 END AS mean_time_ms, array_agg(DISTINCT tenant_key ORDER BY tenant_key) AS tenant_keys FROM deltas WHERE total_time_ms > 0 OR calls > 0 GROUP BY fingerprint ORDER BY total_time_ms DESC, calls DESC LIMIT '20' OFFSET '0';

Date: 2026-04-25 23:26:50
Duration: 34s362ms
Database: zemm_monitoring
User: labanimal
Log file: /var/log/postgresql/postgresql-2026-04-25_000000.csv

x Hide

ALTER TABLE ONLY public."targetgroupMembers" ADD CONSTRAINT "targetgroupMembers_pkey" PRIMARY KEY (id);

Date: 2026-04-25 14:19:48
Duration: 534ms
Database: zemm_test
User: labanimal
Application: pg_restore
Log file: /var/log/postgresql/postgresql-2026-04-25_000000.csv

x Hide

ALTER TABLE ONLY public.diary ADD CONSTRAINT diary_pkey PRIMARY KEY (id);

Date: 2026-04-25 14:19:47
Duration: 731ms
Database: zemm_test
User: labanimal
Application: pg_restore
Log file: /var/log/postgresql/postgresql-2026-04-25_000000.csv

x Hide

ALTER TABLE ONLY public.animals_search_mview ADD CONSTRAINT animals_search_mview_pkey PRIMARY KEY (id);

Date: 2026-04-25 14:19:47
Duration: 731ms
Database: zemm_test
User: labanimal
Application: pg_restore
Log file: /var/log/postgresql/postgresql-2026-04-25_000000.csv

x Hide

ALTER TABLE ONLY public.cost_history ADD CONSTRAINT cost_history_pkey PRIMARY KEY (id);

Date: 2026-04-25 14:19:47
Duration: 731ms
Database: zemm_test
User: labanimal
Application: pg_restore
Log file: /var/log/postgresql/postgresql-2026-04-25_000000.csv

x Hide

ALTER TABLE ONLY public.animals ADD CONSTRAINT animals_pkey PRIMARY KEY (id);

Date: 2026-04-25 14:19:47
Duration: 731ms
Database: zemm_test
User: labanimal
Application: pg_restore
Log file: /var/log/postgresql/postgresql-2026-04-25_000000.csv

x Hide

ALTER TABLE ONLY public.targetgroups ADD CONSTRAINT targetgroups_pkey PRIMARY KEY (id);

Date: 2026-04-25 14:19:49
Duration: 1s212ms
Database: zemm_test
User: labanimal
Application: pg_restore
Log file: /var/log/postgresql/postgresql-2026-04-25_000000.csv

x Hide

ALTER TABLE ONLY public.tasks_changes ADD CONSTRAINT tasks_changes_index01 PRIMARY KEY (id, task);

Date: 2026-04-25 14:19:50
Duration: 673ms
Database: zemm_test
User: labanimal
Application: pg_restore
Log file: /var/log/postgresql/postgresql-2026-04-25_000000.csv

x Hide

ALTER TABLE ONLY public.tasks ADD CONSTRAINT tasks_pkey PRIMARY KEY (id);

Date: 2026-04-25 14:19:50
Duration: 673ms
Database: zemm_test
User: labanimal
Application: pg_restore
Log file: /var/log/postgresql/postgresql-2026-04-25_000000.csv

x Hide

CREATE INDEX "targetgroupMembers_FKIndex1" ON public."targetgroupMembers" USING btree (targetgroup);

Date: 2026-04-25 14:19:55
Duration: 626ms
Database: zemm_test
User: labanimal
Application: pg_restore
Log file: /var/log/postgresql/postgresql-2026-04-25_000000.csv

x Hide

CREATE INDEX "targetgroupMembers_FKIndex2" ON public."targetgroupMembers" USING btree ("group");

Date: 2026-04-25 14:19:56
Duration: 1s602ms
Database: zemm_test
User: labanimal
Application: pg_restore
Log file: /var/log/postgresql/postgresql-2026-04-25_000000.csv

x Hide

CREATE INDEX "targetgroupMembers_user_idx" ON public."targetgroupMembers" USING btree ("user");

Date: 2026-04-25 14:19:58
Duration: 1s470ms
Database: zemm_test
User: labanimal
Application: pg_restore
Log file: /var/log/postgresql/postgresql-2026-04-25_000000.csv

x Hide

CREATE INDEX diary_animalid_idx ON public.diary USING btree ("animalID");

Date: 2026-04-25 14:19:54
Duration: 948ms
Database: zemm_test
User: labanimal
Application: pg_restore
Log file: /var/log/postgresql/postgresql-2026-04-25_000000.csv

x Hide

ALTER TABLE ONLY public.monitoring_session_activity ADD CONSTRAINT monitoring_session_activity_pkey PRIMARY KEY (session_id);

Date: 2026-04-25 14:19:48
Duration: 534ms
Database: zemm_test
User: labanimal
Application: pg_restore
Log file: /var/log/postgresql/postgresql-2026-04-25_000000.csv

x Hide

ALTER TABLE ONLY public.litter_history ADD CONSTRAINT litter_history_pkey PRIMARY KEY (id);

Date: 2026-04-25 14:19:48
Duration: 534ms
Database: zemm_test
User: labanimal
Application: pg_restore
Log file: /var/log/postgresql/postgresql-2026-04-25_000000.csv

x Hide

CREATE INDEX titleindex ON public.targetgroups USING btree (title);

Date: 2026-04-25 14:20:00
Duration: 2s325ms
Database: zemm_test
User: labanimal
Application: pg_restore
Log file: /var/log/postgresql/postgresql-2026-04-25_000000.csv

x Hide

ALTER TABLE ONLY public.litters_search_mview ADD CONSTRAINT litters_search_mview_pkey PRIMARY KEY (id);

Date: 2026-04-25 14:19:48
Duration: 534ms
Database: zemm_test
User: labanimal
Application: pg_restore
Log file: /var/log/postgresql/postgresql-2026-04-25_000000.csv

x Hide

ALTER TABLE ONLY public.fem_numbers ADD CONSTRAINT main_ukey UNIQUE (year, th, num);

Date: 2026-04-25 14:19:48
Duration: 534ms
Database: zemm_test
User: labanimal
Application: pg_restore
Log file: /var/log/postgresql/postgresql-2026-04-25_000000.csv

x Hide

CREATE INDEX "animals_FKIndex11" ON public.animals USING btree (species);

Date: 2026-04-25 14:19:50
Duration: 673ms
Database: zemm_test
User: labanimal
Application: pg_restore
Log file: /var/log/postgresql/postgresql-2026-04-25_000000.csv

x Hide

CREATE INDEX "animals_FKIndex2" ON public.animals USING btree ("homeCage");

Date: 2026-04-25 14:19:51
Duration: 673ms
Database: zemm_test
User: labanimal
Application: pg_restore
Log file: /var/log/postgresql/postgresql-2026-04-25_000000.csv

x Hide

ALTER TABLE ONLY public.litters ADD CONSTRAINT litters_pkey PRIMARY KEY (id);

Date: 2026-04-25 14:19:48
Duration: 534ms
Database: zemm_test
User: labanimal
Application: pg_restore
Log file: /var/log/postgresql/postgresql-2026-04-25_000000.csv

x Hide

CREATE INDEX animals_curcage_active_idx ON public.animals USING btree ("curCage") WHERE (NOT deleted);

Date: 2026-04-25 14:19:52
Duration: 1s407ms
Database: zemm_test
User: labanimal
Application: pg_restore
Log file: /var/log/postgresql/postgresql-2026-04-25_000000.csv

x Hide

CREATE INDEX animals_mview_idx ON public.animals_search_mview USING btree (id NULLS FIRST, owner NULLS FIRST, editor NULLS FIRST, tourist NULLS FIRST);

Date: 2026-04-25 14:19:52
Duration: 1s407ms
Database: zemm_test
User: labanimal
Application: pg_restore
Log file: /var/log/postgresql/postgresql-2026-04-25_000000.csv

x Hide

CREATE INDEX cost_history_animal_idx ON public.cost_history USING btree (animal);

Date: 2026-04-25 14:19:54
Duration: 948ms
Database: zemm_test
User: labanimal
Application: pg_restore
Log file: /var/log/postgresql/postgresql-2026-04-25_000000.csv

x Hide

CREATE INDEX animals_animalid_idx ON public.animals USING btree ("animalID");

Date: 2026-04-25 14:19:51
Duration: 673ms
Database: zemm_test
User: labanimal
Application: pg_restore
Log file: /var/log/postgresql/postgresql-2026-04-25_000000.csv

x Hide

ALTER TABLE ONLY public.fem_numbers ADD CONSTRAINT pkey PRIMARY KEY (id);

Date: 2026-04-25 14:19:48
Duration: 534ms
Database: zemm_test
User: labanimal
Application: pg_restore
Log file: /var/log/postgresql/postgresql-2026-04-25_000000.csv

x Hide

CREATE INDEX tasks_changes_deleted_idx ON public.tasks_changes USING btree (deleted);

Date: 2026-04-25 14:20:00
Duration: 2s325ms
Database: zemm_test
User: labanimal
Application: pg_restore
Log file: /var/log/postgresql/postgresql-2026-04-25_000000.csv

x Hide

CREATE INDEX tasks_active_index ON public.tasks USING btree (active);

Date: 2026-04-25 14:20:00
Duration: 2s325ms
Database: zemm_test
User: labanimal
Application: pg_restore
Log file: /var/log/postgresql/postgresql-2026-04-25_000000.csv

x Hide

CREATE INDEX tasks_done_idx ON public.tasks USING btree (done);

Date: 2026-04-25 14:20:00
Duration: 2s325ms
Database: zemm_test
User: labanimal
Application: pg_restore
Log file: /var/log/postgresql/postgresql-2026-04-25_000000.csv

x Hide

CREATE INDEX tasks_task_status_idx ON public.tasks USING btree (task_status);

Date: 2026-04-25 14:20:00
Duration: 2s325ms
Database: zemm_test
User: labanimal
Application: pg_restore
Log file: /var/log/postgresql/postgresql-2026-04-25_000000.csv

x Hide

CREATE INDEX tasks_owner_index ON public.tasks USING btree (owner);

Date: 2026-04-25 14:20:00
Duration: 2s325ms
Database: zemm_test
User: labanimal
Application: pg_restore
Log file: /var/log/postgresql/postgresql-2026-04-25_000000.csv

x Hide

CREATE INDEX tasks_editor_idx ON public.tasks USING btree (editor);

Date: 2026-04-25 14:20:00
Duration: 2s325ms
Database: zemm_test
User: labanimal
Application: pg_restore
Log file: /var/log/postgresql/postgresql-2026-04-25_000000.csv

x Hide

CREATE INDEX tasks_id_parent_idx ON public.tasks USING btree (id, parent);

Date: 2026-04-25 14:20:00
Duration: 2s325ms
Database: zemm_test
User: labanimal
Application: pg_restore
Log file: /var/log/postgresql/postgresql-2026-04-25_000000.csv

x Hide

CREATE INDEX monitoring_session_activity_user_idx ON public.monitoring_session_activity USING btree (user_id);

Date: 2026-04-25 14:19:55
Duration: 626ms
Database: zemm_test
User: labanimal
Application: pg_restore
Log file: /var/log/postgresql/postgresql-2026-04-25_000000.csv

x Hide

CREATE INDEX litters_dam_index ON public.litters USING btree (dam);

Date: 2026-04-25 14:19:55
Duration: 626ms
Database: zemm_test
User: labanimal
Application: pg_restore
Log file: /var/log/postgresql/postgresql-2026-04-25_000000.csv

x Hide