SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 10100106) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100106) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100106) 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.alive = 'f' AND 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-05-27 09:22:23
Duration: 19s215ms
Database: zemm_produktiv_8
User: labanimal
Application: _desktop_index.php_zemm_produktiv_8_localhost_5432
Log file: /var/log/postgresql/postgresql-2026-05-27_000000.csv

SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 10100106) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100106) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100106) 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.alive = 'f' AND 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-05-27 09:20:22
Duration: 19s154ms
Database: zemm_produktiv_8
User: labanimal
Application: _desktop_index.php_zemm_produktiv_8_localhost_5432
Log file: /var/log/postgresql/postgresql-2026-05-27_000000.csv

SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 10100106) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100106) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100106) 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.alive = 'f' AND 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-05-27 09:20:22
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: 1h47m45s - Times executed: 1434 ]

x Hide

CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);

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

CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);

Date: 2026-05-27 09:21:01
Duration: 19s154ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-27_000000.csv

CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);

Date: 2026-05-27 02:29:01
Duration: 12s357ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-27_000000.csv

x Hide

Times Reported Time consuming queries #2

x Hide

[ User: monitoring_admin - Total duration: 1h47m45s - Times executed: 1434 ]

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-05-27 09:36:01
Duration: 19s215ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-27_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-05-27 09:21:01
Duration: 19s154ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-27_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-05-27 02:29:01
Duration: 12s357ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-27_000000.csv

x Hide

Times Reported Time consuming queries #3

x Hide

[ User: monitoring_admin - Total duration: 1h47m45s - Times executed: 1434 ]

x Hide

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

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

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

Date: 2026-05-27 09:21:01
Duration: 19s154ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-27_000000.csv

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

Date: 2026-05-27 02:29:01
Duration: 12s357ms
Database: zemm_monitoring
User: monitoring_admin
Bind query: yes
Log file: /var/log/postgresql/postgresql-2026-05-27_000000.csv

x Hide