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-08 12:47:11
Duration: 28s472ms
Database: zemm_produktiv_8
User: labanimal
Application: _desktop_index.php_zemm_produktiv_8_localhost_5432
Log file: /var/log/postgresql/postgresql-2026-06-08_000000.csv

SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 10100201) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100201) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100201) 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-08 16:09:34
Duration: 27s777ms
Database: zemm_produktiv_8
User: labanimal
Application: _desktop_index.php_zemm_produktiv_8_localhost_5432
Log file: /var/log/postgresql/postgresql-2026-06-08_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-08 12:47:11
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: 2h4m56s - Times executed: 1349 ]

x Hide

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

Date: 2026-06-08 13:00:01
Duration: 28s472ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-06-08_000000.csv

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

Date: 2026-06-08 16:11:01
Duration: 27s777ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-06-08_000000.csv

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

Date: 2026-06-08 12:47:01
Duration: 25s999ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-06-08_000000.csv

x Hide

Times Reported Time consuming queries #2

x Hide

[ User: monitoring_admin - Total duration: 2h4m56s - Times executed: 1349 ]

x Hide

CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);

Date: 2026-06-08 13:00:01
Duration: 28s472ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-06-08_000000.csv

CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);

Date: 2026-06-08 16:11:01
Duration: 27s777ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-06-08_000000.csv

CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);

Date: 2026-06-08 12:47:01
Duration: 25s999ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-06-08_000000.csv

x Hide

Times Reported Time consuming queries #3

x Hide

[ User: monitoring_admin - Total duration: 2h4m56s - Times executed: 1349 ]

x Hide

CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );

Date: 2026-06-08 13:00:01
Duration: 28s472ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-06-08_000000.csv

CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );

Date: 2026-06-08 16:11:01
Duration: 27s777ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-06-08_000000.csv

CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );

Date: 2026-06-08 12:47:01
Duration: 25s999ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-06-08_000000.csv

x Hide

Times Reported Time consuming queries #4