SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 10100050) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100050) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100050) 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-03-27 09:40:26
Duration: 26s52ms
Database: zemm_produktiv_8
User: labanimal
Application: _desktop_index.php_zemm_produktiv_8_localhost_5432
Log file: /var/log/postgresql/postgresql-2026-03-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, 10100050) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100050) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100050) 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-03-27 09:43:37
Duration: 25s947ms
Database: zemm_produktiv_8
User: labanimal
Application: _desktop_index.php_zemm_produktiv_8_localhost_5432
Log file: /var/log/postgresql/postgresql-2026-03-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, 10100050) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100050) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100050) 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-03-27 09:40:26
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: labanimal - Total duration: 26m54s - Times executed: 1349 ]

x Hide

CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );

Date: 2026-03-27 09:43:01
Duration: 26s52ms
Database: zemm_monitoring
User: labanimal
Log file: /var/log/postgresql/postgresql-2026-03-27_000000.csv

CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );

Date: 2026-03-27 09:48:01
Duration: 25s947ms
Database: zemm_monitoring
User: labanimal
Log file: /var/log/postgresql/postgresql-2026-03-27_000000.csv

CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );

Date: 2026-03-27 09:40:01
Duration: 23s985ms
Database: zemm_monitoring
User: labanimal
Log file: /var/log/postgresql/postgresql-2026-03-27_000000.csv

x Hide

Times Reported Time consuming queries #2

x Hide

[ User: labanimal - Total duration: 26m54s - Times executed: 1349 ]

x Hide

CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);

Date: 2026-03-27 09:43:01
Duration: 26s52ms
Database: zemm_monitoring
User: labanimal
Log file: /var/log/postgresql/postgresql-2026-03-27_000000.csv

CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);

Date: 2026-03-27 09:48:01
Duration: 25s947ms
Database: zemm_monitoring
User: labanimal
Log file: /var/log/postgresql/postgresql-2026-03-27_000000.csv

CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);

Date: 2026-03-27 09:40:01
Duration: 23s985ms
Database: zemm_monitoring
User: labanimal
Log file: /var/log/postgresql/postgresql-2026-03-27_000000.csv

x Hide

Times Reported Time consuming queries #3