SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 332) AS is_owner, user_is_tgm (animals_search_mview.editor, 332) AS is_editor, user_is_tgm (animals_search_mview.tourist, 332) AS is_tourist, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, STRING_AGG(l."application_id" || ':' || l."title" || ' - ' || Date(lh."timestamp")::varchar, '; ') AS licensehistory, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview INNER JOIN fates ON fates.id = animals_search_mview.fate LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN licenses l ON l.id = lh.licid left join breedings b ON b.id = animals_search_mview.last_mating GROUP BY animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data WHERE data.deleted = 'f' AND (is_owner OR is_editor OR is_tourist) and (data.straindeleted = 'f' or data.straindeleted is null) ORDER BY data.cage_name, data.animal_id, data.name;

Date: 2026-06-01 15:21:25
Duration: 29s122ms
Database: zemm_produktiv_8
User: labanimal
Application: _desktop_index.php_zemm_produktiv_8_localhost_5432
Log file: /var/log/postgresql/postgresql-2026-06-01_000000.csv

SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 332) AS is_owner, user_is_tgm (animals_search_mview.editor, 332) AS is_editor, user_is_tgm (animals_search_mview.tourist, 332) AS is_tourist, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, STRING_AGG(l."application_id" || ':' || l."title" || ' - ' || Date(lh."timestamp")::varchar, '; ') AS licensehistory, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview INNER JOIN fates ON fates.id = animals_search_mview.fate LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN licenses l ON l.id = lh.licid left join breedings b ON b.id = animals_search_mview.last_mating GROUP BY animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data WHERE data.deleted = 'f' AND (is_owner OR is_editor OR is_tourist) and (data.straindeleted = 'f' or data.straindeleted is null) ORDER BY data.cage_name, data.animal_id, data.name;

Date: 2026-06-01 15:23:04
Duration: 29s49ms
Database: zemm_produktiv_8
User: labanimal
Application: _desktop_index.php_zemm_produktiv_8_localhost_5432
Log file: /var/log/postgresql/postgresql-2026-06-01_000000.csv

SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 332) AS is_owner, user_is_tgm (animals_search_mview.editor, 332) AS is_editor, user_is_tgm (animals_search_mview.tourist, 332) AS is_tourist, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, STRING_AGG(l."application_id" || ':' || l."title" || ' - ' || Date(lh."timestamp")::varchar, '; ') AS licensehistory, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview INNER JOIN fates ON fates.id = animals_search_mview.fate LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN licenses l ON l.id = lh.licid left join breedings b ON b.id = animals_search_mview.last_mating GROUP BY animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data WHERE data.deleted = 'f' AND (is_owner OR is_editor OR is_tourist) and (data.straindeleted = 'f' or data.straindeleted is null) ORDER BY data.cage_name, data.animal_id, data.name;

Date: 2026-06-01 15:21:25
Duration: 0ms
Database: zemm_produktiv_8
User: labanimal
Application: _desktop_index.php_zemm_produktiv_8_localhost_5432

x Hide

Times Reported Time consuming queries #1

x Hide

[ User: monitoring_admin - Total duration: 34m35s - Times executed: 1349 ]

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-06-01 15:22:02
Duration: 29s122ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-06-01_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-06-01 15:33:01
Duration: 29s49ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-06-01_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-06-01 15:23:01
Duration: 26s446ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-06-01_000000.csv

x Hide

Times Reported Time consuming queries #2

x Hide

[ User: monitoring_admin - Total duration: 34m35s - Times executed: 1349 ]

x Hide

ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS payload jsonb;

Date: 2026-06-01 15:22:02
Duration: 29s122ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-06-01_000000.csv

ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS payload jsonb;

Date: 2026-06-01 15:33:01
Duration: 29s49ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-06-01_000000.csv

ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS payload jsonb;

Date: 2026-06-01 15:23:01
Duration: 26s446ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-06-01_000000.csv

x Hide