ZEMM PG Report-
Global information
- Generated on Sun Mar 15 06:01:13 2026
- Log file: /var/log/postgresql/postgresql-2026-03-06_225012.csv, ..., /var/log/postgresql/postgresql-2026-03-15_000000.csv
- Parsed 212,352 log entries in 1m12s
- Log start from 2026-03-08 00:00:01 to 2026-03-08 23:59:54
-
Overview
Global Stats
- 24 Number of unique normalized queries
- 17,302 Number of queries
- 5h25s Total query duration
- 2026-03-08 00:00:01 First query
- 2026-03-08 23:59:01 Last query
- 13 queries/s at 2026-03-08 19:00:01 Query peak
- 5h25s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 5h25s Execute total duration
- 28 Number of events
- 7 Number of unique normalized events
- 14 Max number of times the same event was reported
- 0 Number of cancellation
- 23 Total number of automatic vacuums
- 15 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 19,879 Total number of sessions
- 16 sessions at 2026-03-08 17:43:54 Session peak
- 44m42s Total duration of sessions
- 134ms Average duration of sessions
- 0 Average queries per session
- 906ms Average queries duration per session
- 0ms Average idle time per session
- 19,893 Total number of connections
- 32 connections/s at 2026-03-08 11:40:36 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 13 queries/s Query Peak
- 2026-03-08 19:00:01 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2026-03-08 12:11:34 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 12 queries/s Query Peak
- 2026-03-08 13:13:01 Date
Queries duration
Key values
- 5h25s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 08 00 720 0ms 0ms 0ms 0ms 0ms 0ms 01 721 0ms 1s591ms 770ms 19s98ms 19s98ms 19s98ms 02 721 1s480ms 1s591ms 1s482ms 17s764ms 17s764ms 20s579ms 03 720 1s480ms 1s480ms 1s480ms 17s764ms 17s764ms 17s764ms 04 720 1s480ms 1s480ms 1s480ms 17s764ms 17s764ms 17s764ms 05 720 1s480ms 1s480ms 1s480ms 17s764ms 17s764ms 17s764ms 06 720 1s480ms 1s480ms 1s480ms 17s764ms 17s764ms 17s764ms 07 720 1s480ms 1s480ms 1s480ms 17s764ms 17s764ms 17s764ms 08 720 1s480ms 1s480ms 1s480ms 17s764ms 17s764ms 17s764ms 09 720 1s480ms 1s480ms 1s480ms 17s764ms 17s764ms 17s764ms 10 720 1s480ms 1s480ms 1s480ms 17s764ms 17s764ms 17s764ms 11 720 1s480ms 1s480ms 1s480ms 17s764ms 17s764ms 17s764ms 12 722 620ms 1s480ms 791ms 17s764ms 17s764ms 19s44ms 13 721 620ms 813ms 742ms 9s764ms 9s764ms 9s764ms 14 721 794ms 813ms 806ms 9s764ms 9s764ms 10s559ms 15 722 599ms 794ms 711ms 9s534ms 9s534ms 10s134ms 16 720 789ms 789ms 789ms 9s475ms 9s475ms 9s475ms 17 722 789ms 809ms 800ms 9s715ms 9s715ms 10s484ms 18 721 784ms 809ms 806ms 9s715ms 9s715ms 10s500ms 19 723 524ms 804ms 721ms 9s653ms 9s653ms 10s450ms 20 721 789ms 797ms 793ms 9s566ms 9s566ms 10s355ms 21 721 789ms 822ms 799ms 9s864ms 9s864ms 10s293ms 22 720 822ms 822ms 822ms 9s864ms 9s864ms 9s864ms 23 726 542ms 1s967ms 846ms 10s654ms 15s976ms 15s976ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 08 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 1 0 1s480ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 2 0 640ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 1 0 524ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 5 1s268ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 08 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 1 0 0 1s591ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 1 0 0 599ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Mar 08 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 1 1.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Mar 08 00 242 0.07/s 01 243 0.07/s 02 242 0.07/s 03 245 0.07/s 04 245 0.07/s 05 242 0.07/s 06 242 0.07/s 07 270 0.07/s 08 268 0.07/s 09 595 0.17/s 10 2,191 0.61/s 11 1,524 0.42/s 12 1,198 0.33/s 13 1,389 0.39/s 14 1,466 0.41/s 15 1,363 0.38/s 16 950 0.26/s 17 1,455 0.40/s 18 761 0.21/s 19 1,017 0.28/s 20 1,095 0.30/s 21 933 0.26/s 22 761 0.21/s 23 956 0.27/s Day Hour Count Average Duration Average idle time Mar 08 00 242 46ms 46ms 01 243 56ms 0ms 02 242 54ms 0ms 03 245 45ms 0ms 04 243 46ms 0ms 05 242 46ms 0ms 06 242 46ms 0ms 07 270 664ms 0ms 08 268 49ms 0ms 09 595 85ms 0ms 10 2,191 129ms 0ms 11 1,520 78ms 0ms 12 1,198 100ms 0ms 13 1,389 119ms 0ms 14 1,466 135ms 0ms 15 1,363 142ms 0ms 16 950 209ms 0ms 17 1,449 188ms 0ms 18 758 98ms 0ms 19 1,018 237ms 0ms 20 1,094 135ms 0ms 21 934 135ms 0ms 22 761 131ms 0ms 23 956 115ms 0ms -
Connections
Established Connections
Key values
- 32 connections Connection Peak
- 2026-03-08 11:40:36 Date
Connections per database
Key values
- zemm_monitoring Main Database
- 19,893 connections Total
Connections per user
Key values
- labanimal Main User
- 19,893 connections Total
-
Sessions
Simultaneous sessions
Key values
- 16 sessions Session Peak
- 2026-03-08 17:43:54 Date
Histogram of session times
Key values
- 18,871 0-500ms duration
Sessions per database
Key values
- zemm_monitoring Main Database
- 19,879 sessions Total
Sessions per user
Key values
- labanimal Main User
- 19,879 sessions Total
Sessions per host
Key values
- ::1 Main Host
- 19,879 sessions Total
Sessions per application
Key values
- Main Application
- 19,879 sessions Total
Application Count Total Duration Average Duration 18,533 37m25s 121ms _backend_cage_autocomplete_api.php_q_2025_limit_12_zemm_produkt 11 313ms 28ms _backend_cage_autocomplete_api.php_q_55-065_limit_12_zemm_produ 11 323ms 29ms _backend_wean_api.php_litter_id_10130227_zemm_produktiv_7_local 55 7s611ms 138ms _backend_wean_api.php_litter_id_10130236_zemm_produktiv_7_local 54 7s843ms 145ms _backend_wean_api.php_litter_id_10130257_zemm_produktiv_7_local 66 9s400ms 142ms _backend_wean_api.php_litter_id_10131252_zemm_produktiv_8_local 2 289ms 144ms _backend_wean_api.php_litter_id_10131253_zemm_produktiv_8_local 2 276ms 138ms _backend_wean_api.php_litter_id_10131254_zemm_produktiv_8_local 3 412ms 137ms _backend_wean_api.php_litter_id_10131255_zemm_produktiv_8_local 2 282ms 141ms _backend_wean_api.php_litter_id_10131256_zemm_produktiv_8_local 2 267ms 133ms _backend_wean_api.php_litter_id_10131257_zemm_produktiv_8_local 2 278ms 139ms _backend_wean_api.php_litter_id_10131375_zemm_produktiv_8_local 2 282ms 141ms _backend_wean_api.php_litter_id_10131376_zemm_produktiv_8_local 2 287ms 143ms _backend_wean_api.php_litter_id_10131377_zemm_produktiv_8_local 2 280ms 140ms _backend_wean_api.php_litter_id_10131378_zemm_produktiv_8_local 3 431ms 143ms _backend_wean_api.php_litter_id_10131381_zemm_produktiv_8_local 3 431ms 143ms _backend_wean_api.php_litter_id_10131382_zemm_produktiv_8_local 2 276ms 138ms _backend_wean_api.php_litter_id_10131383_zemm_produktiv_8_local 2 272ms 136ms _backend_wean_api.php_litter_id_10131384_zemm_produktiv_8_local 2 288ms 144ms _backend_wean_api.php_litter_id_10131385_zemm_produktiv_8_local 2 281ms 140ms _backend_wean_api.php_litter_id_10131386_zemm_produktiv_8_local 2 287ms 143ms _backend_wean_api.php_litter_id_10131387_zemm_produktiv_8_local 2 278ms 139ms _backend_wean_api.php_litter_id_10131558_zemm_produktiv_8_local 2 284ms 142ms _backend_wean_api.php_litter_id_10131559_zemm_produktiv_8_local 3 431ms 143ms _desktop__zemm_produktiv_7_localhost_5432 11 4s884ms 444ms _desktop__zemm_produktiv_8_localhost_5432 5 330ms 66ms _desktop_index.php_command_admin_subcommand_strains_management_ 8 512ms 64ms _desktop_index.php_command_animals_breedings_subcommand_select_ 22 11s548ms 524ms _desktop_index.php_command_animals_create_subcommand_init_zemm_ 11 526ms 47ms _desktop_index.php_command_animals_edit_subcommand_link_init_va 33 2s877ms 87ms _desktop_index.php_command_animals_edit_subcommand_m_init_scree 33 3s26ms 91ms _desktop_index.php_command_animals_litters_edit_subcommand_init 11 1s23ms 93ms _desktop_index.php_command_animals_litters_edit_subcommand_m_in 55 11s903ms 216ms _desktop_index.php_command_animals_litters_subcommand_select_ze 22 1s751ms 79ms _desktop_index.php_command_animals_subcommand_init_zemm_produkt 361 1m50s 307ms _desktop_index.php_command_animals_subcommand_open_zemm_produkt 2 88ms 44ms _desktop_index.php_command_animals_subcommand_select_zemm_produ 33 9s502ms 287ms _desktop_index.php_command_home_subcommand_init_zemm_produktiv_ 7 591ms 84ms _desktop_index.php_command_login_subcommand_init_zemm_produktiv 221 35s752ms 161ms _desktop_index.php_command_reports_subcommand_animals_per_user_ 3 960ms 320ms _desktop_index.php_command_reports_subcommand_fates_zemm_produk 12 1s229ms 102ms _desktop_index.php_command_reports_subcommand_init_zemm_produkt 22 6s208ms 282ms _desktop_index.php_command_reports_subcommand_task_status_zemm_ 14 1s66ms 76ms _desktop_index.php_command_strains_subcommand_init_zemm_produkt 5 684ms 136ms _desktop_index.php_command_tasks_subcommand_edit_id_10126484_ze 11 746ms 67ms _desktop_index.php_command_tasks_subcommand_init_search_zemm_pr 22 1s269ms 57ms _desktop_index.php_command_tasks_subcommand_init_zemm_produktiv 8 1s761ms 220ms _desktop_index.php_command_tasks_subcommand_open_zemm_produktiv 38 8s231ms 216ms _desktop_index.php_command_tasks_subcommand_search_zemm_produkt 33 1s987ms 60ms _desktop_index.php_zemm_produktiv_8_localhost_5432 1 64ms 64ms backend:zemm_produktiv_8@localhost 1 64ms 64ms expire_tasks:zemm_produktiv_8@h2940066.stratoserver.net:5432 1 1s608ms 1s608ms notification:zemm_produktiv_8@h2940066.stratoserver.net:5432 2 2m47s 1m23s pg_dump 1 11s430ms 11s430ms psql 48 1s960ms 40ms taskscron:zemm_produktiv_7@zemm.fbiscience.eu 24 631ms 26ms taskscron:zemm_produktiv_8@h2940066.stratoserver.net:5432 24 2s954ms 123ms zemm_produktiv_7_localhost_5432 2 42ms 21ms -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 19,189 buffers Checkpoint Peak
- 2026-03-08 01:39:05 Date
- 270.056 seconds Highest write time
- 0.474 seconds Sync time
Checkpoints Wal files
Key values
- 0 files Wal files usage Peak
- 2026-03-08 23:55:13 Date
Checkpoints distance
Key values
- 267.67 Mo Distance Peak
- 2026-03-08 01:39:05 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Mar 08 00 1,634 163.91s 0.06s 164.029s 01 20,494 400.218s 0.059s 400.383s 02 3,357 335.974s 0.065s 336.099s 03 2,166 216.986s 0.061s 217.103s 04 1,651 165.634s 0.063s 165.755s 05 1,538 154.328s 0.061s 154.437s 06 1,672 167.726s 0.063s 167.849s 07 1,762 176.734s 0.065s 176.859s 08 1,750 175.555s 0.063s 175.664s 09 2,014 201.844s 0.097s 201.998s 10 9,031 602.07s 0.153s 602.283s 11 9,855 464.355s 0.086s 464.506s 12 2,607 261.437s 0.093s 261.584s 13 2,323 233.038s 0.162s 233.258s 14 2,568 257.78s 0.097s 257.921s 15 21,130 745.372s 0.101s 745.567s 16 2,408 241.465s 0.091s 241.607s 17 8,106 493.774s 0.115s 493.99s 18 3,161 316.806s 0.087s 316.954s 19 2,356 236.334s 0.125s 236.527s 20 2,024 203.048s 0.09s 203.199s 21 2,021 202.711s 0.08s 202.853s 22 1,929 193.52s 0.078s 193.661s 23 3,533 354.198s 0.54s 354.796s Day Hour Added Removed Recycled Synced files Longest sync Average sync Mar 08 00 0 1 0 272 0.002s 0.012s 01 0 9 0 267 0.002s 0.011s 02 0 1 0 280 0.003s 0.012s 03 0 1 0 273 0.002s 0.012s 04 0 1 0 268 0.002s 0.012s 05 0 0 0 266 0.002s 0.012s 06 0 1 0 267 0.002s 0.012s 07 0 1 0 303 0.002s 0.012s 08 0 0 0 278 0.002s 0.012s 09 0 1 0 512 0.002s 0.011s 10 0 2 0 834 0.002s 0.012s 11 0 3 0 329 0.002s 0.012s 12 0 1 0 377 0.002s 0.012s 13 0 1 0 382 0.021s 0.014s 14 0 0 0 359 0.002s 0.012s 15 0 7 0 383 0.003s 0.012s 16 0 1 0 277 0.002s 0.012s 17 0 2 0 341 0.020s 0.013s 18 0 1 0 315 0.002s 0.012s 19 0 1 0 386 0.008s 0.013s 20 0 1 0 375 0.002s 0.012s 21 0 0 0 329 0.002s 0.012s 22 0 1 0 302 0.002s 0.012s 23 0 1 0 315 0.207s 0.032s Day Hour Count Avg time (sec) Mar 08 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Mar 08 00 857.17 kB 930.42 kB 01 13,272.09 kB 51,630.18 kB 02 2,521.75 kB 50,159.58 kB 03 856.50 kB 14,787.42 kB 04 868.33 kB 4,790.00 kB 05 845.00 kB 1,967.00 kB 06 871.83 kB 1,173.17 kB 07 907.25 kB 971.50 kB 08 892.25 kB 984.08 kB 09 1,040.73 kB 1,186.64 kB 10 3,250.33 kB 10,706.25 kB 11 3,462.50 kB 13,405.25 kB 12 1,179.17 kB 12,271.25 kB 13 1,124.92 kB 4,288.58 kB 14 1,175.75 kB 2,031.17 kB 15 9,260.17 kB 49,305.58 kB 16 1,095.17 kB 19,840.17 kB 17 2,923.25 kB 10,416.83 kB 18 1,355.83 kB 10,402.25 kB 19 1,107.25 kB 3,872.33 kB 20 982.83 kB 1,824.17 kB 21 970.50 kB 1,217.25 kB 22 952.33 kB 1,037.08 kB 23 1,265.75 kB 2,732.67 kB -
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Mar 08 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.55 sec Highest CPU-cost vacuum
Table public.tasks
Database zemm_produktiv_8 - 2026-03-08 01:30:14 Date
- 0 sec Highest CPU-cost analyze
Table
Database zemm_produktiv_8 - Date
Average Autovacuum Duration
Key values
- 0.55 sec Highest CPU-cost vacuum
Table public.tasks
Database zemm_produktiv_8 - 2026-03-08 01:30:14 Date
Analyzes per table
Key values
- public.tasks (2) Main table analyzed (database zemm_produktiv_8)
- 15 analyzes Total
Table Number of analyzes zemm_produktiv_8.public.tasks 2 zemm_produktiv_7.pg_catalog.pg_type 2 zemm_monitoring.observability.metrics_timeseries 2 zemm_produktiv_8.public.tasks_changes 2 zemm_monitoring.observability.db_top_queries 1 zemm_produktiv_8.pg_catalog.pg_namespace 1 zemm_produktiv_7.pg_catalog.pg_attribute 1 zemm_produktiv_7.pg_catalog.pg_namespace 1 zemm_produktiv_7.pg_catalog.pg_depend 1 zemm_produktiv_7.pg_catalog.pg_class 1 zemm_produktiv_8.pg_catalog.pg_class 1 Total 15 Vacuums per table
Key values
- pg_toast.pg_toast_67431 (12) Main table vacuumed on database zemm_monitoring
- 23 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples zemm_monitoring.pg_toast.pg_toast_67431 12 0 0 0 0 0 0 4,339 1,463 3,291,318 1,415 8,490 zemm_produktiv_8.public.tasks 2 2 0 0 0 0 0 59,583 217 5,038,595 1 1 zemm_produktiv_8.pg_catalog.pg_type 1 1 0 0 0 0 0 51 18 15,915 1 4 zemm_produktiv_7.pg_catalog.pg_type 1 1 0 0 0 0 0 29 15 23,651 1 24 zemm_produktiv_8.pg_catalog.pg_statistic 1 1 0 0 0 0 0 199 79 287,869 27 231 zemm_produktiv_7.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 214 72 476,273 58 259 zemm_produktiv_7.pg_catalog.pg_depend 1 1 0 0 0 0 0 28 17 39,148 1 91 zemm_monitoring.observability.metrics_timeseries 1 1 0 0 0 0 0 2,205 1,338 3,237,584 55 820 zemm_produktiv_8.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 185 46 240,045 22 80 zemm_monitoring.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 90 16 100,814 1 2 zemm_produktiv_8.pg_catalog.pg_attribute 1 1 0 0 0 0 0 142 57 41,778 1 19 Total 23 11 0 0 0 0 0 67,065 3,338 12,792,990 1,583 10,021 Vacuum throughput per table
Key values
- public.tasks (1.08) Max CPU elapsed for vacuum on database zemm_produktiv_8
- observability.metrics_timeseries (4.532 ms) Max I/O read time for vacuum on database zemm_produktiv_8
- observability.metrics_timeseries (0.336 ms) Max I/O write time for vacuum on database zemm_produktiv_8
I/O timing (ms) CPU (s) Table read write elapsed zemm_monitoring.pg_toast.pg_toast_67431 0 0 0.25 zemm_produktiv_8.public.tasks 0.044 0.121 1.08 zemm_produktiv_8.pg_catalog.pg_type 0 0 0 zemm_produktiv_7.pg_catalog.pg_type 0 0 0.01 zemm_produktiv_8.pg_catalog.pg_statistic 0 0 0.02 zemm_produktiv_7.pg_toast.pg_toast_2619 0 0 0.01 zemm_produktiv_7.pg_catalog.pg_depend 0 0 0 zemm_monitoring.observability.metrics_timeseries 4.532 0.336 0.43 zemm_produktiv_8.pg_toast.pg_toast_2619 0 0 0.02 zemm_monitoring.pg_toast.pg_toast_2619 0 0 0 zemm_produktiv_8.pg_catalog.pg_attribute 0 0 0.01 Total 4.576 0.457 1.83 Tuples removed per table
Key values
- public.tasks (54342) Main table with removed tuples on database zemm_produktiv_8
- 60097 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain zemm_produktiv_8.public.tasks 2 2 54,342 112,136 0 0 32,500 zemm_monitoring.observability.metrics_timeseries 1 1 4,225 181,309 0 0 3,437 zemm_produktiv_8.pg_catalog.pg_attribute 1 1 926 5,788 0 0 184 zemm_produktiv_8.pg_catalog.pg_type 1 1 198 831 0 0 31 zemm_produktiv_8.pg_catalog.pg_statistic 1 1 165 1,271 0 0 144 zemm_produktiv_8.pg_toast.pg_toast_2619 1 1 97 292 0 11 106 zemm_monitoring.pg_toast.pg_toast_2619 1 1 64 60 0 0 29 zemm_produktiv_7.pg_toast.pg_toast_2619 1 1 36 275 0 0 67 zemm_produktiv_7.pg_catalog.pg_depend 1 1 27 4,171 0 0 32 zemm_produktiv_7.pg_catalog.pg_type 1 1 17 831 0 2 20 zemm_monitoring.pg_toast.pg_toast_67431 12 0 0 731,478 0 0 122,373 Total 23 11 60,097 1,038,442 0 13 158,923 Pages removed per table
Key values
- pg_toast.pg_toast_2619 (11) Main table with removed pages on database zemm_produktiv_8
- 13 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed zemm_produktiv_8.pg_toast.pg_toast_2619 1 1 97 11 zemm_produktiv_7.pg_catalog.pg_type 1 1 17 2 zemm_produktiv_8.pg_catalog.pg_type 1 1 198 0 zemm_produktiv_8.public.tasks 2 2 54342 0 zemm_produktiv_8.pg_catalog.pg_statistic 1 1 165 0 zemm_produktiv_7.pg_toast.pg_toast_2619 1 1 36 0 zemm_produktiv_7.pg_catalog.pg_depend 1 1 27 0 zemm_monitoring.observability.metrics_timeseries 1 1 4225 0 zemm_monitoring.pg_toast.pg_toast_67431 12 0 0 0 zemm_monitoring.pg_toast.pg_toast_2619 1 1 64 0 zemm_produktiv_8.pg_catalog.pg_attribute 1 1 926 0 Total 23 11 60,097 13 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Mar 08 00 1 0 01 3 2 02 1 1 03 0 0 04 1 0 05 0 0 06 1 0 07 0 0 08 1 0 09 1 2 10 1 1 11 0 0 12 1 0 13 0 0 14 1 2 15 4 4 16 1 0 17 1 1 18 1 1 19 1 1 20 1 0 21 0 0 22 0 0 23 2 0 - 0.55 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 4 Total read queries
- 17,298 Total write queries
Queries by database
Key values
- zemm_monitoring Main database
- 17,281 Requests
- 5h5s (zemm_monitoring)
- Main time consuming database
Queries by user
Key values
- labanimal Main user
- 35,434 Requests
User Request type Count Duration labanimal Total 35,434 21h23m1s cte 22 19s59ms ddl 35,396 21h19m31s others 4 3s68ms select 9 3m4s update 1 1s591ms postgres Total 3,531 1h1m51s copy from 19 54s373ms copy to 70 2m37s cte 5 10s291ms ddl 2,728 45m51s others 679 11m32s update 1 599ms Duration by user
Key values
- 21h23m1s (labanimal) Main time consuming user
User Request type Count Duration labanimal Total 35,434 21h23m1s cte 22 19s59ms ddl 35,396 21h19m31s others 4 3s68ms select 9 3m4s update 1 1s591ms postgres Total 3,531 1h1m51s copy from 19 54s373ms copy to 70 2m37s cte 5 10s291ms ddl 2,728 45m51s others 679 11m32s update 1 599ms Queries by host
Key values
- unknown Main host
- 35,431 Requests
- 21h20m (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 17,281 Requests
- 5h5s (unknown)
- Main time consuming application
Application Request type Count Duration _desktop_index.php_command_animals_breedings_subcommand_select_ Total 11 8s800ms cte 11 8s800ms _desktop_index.php_command_login_subcommand_init_zemm_produktiv Total 2 1s280ms select 2 1s280ms expire_tasks:zemm_produktiv_8@h2940066.stratoserver.net:5432 Total 1 1s591ms update 1 1s591ms pg_dump Total 5 6s341ms copy to 5 6s341ms psql Total 1 599ms update 1 599ms taskscron:zemm_produktiv_8@h2940066.stratoserver.net:5432 Total 1 1s480ms select 1 1s480ms unknown Total 17,281 5h5s ddl 17,280 5h4s select 1 524ms Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-03-08 13:13:01 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 16 500-1000ms duration
Slowest individual queries
Rank Duration Query 1 1s967ms COPY public.diary (id, "animalID", date, "entrybyID", "cageID", weight, temperature, "fDeprivation", "wDeprivation", "sDeprivation", "feedingClass", health, comments, "breedingInfo", deleted, "inOutDate", "inOutFlag", text, sdesc, treatment, tailcut_id, tailcut_result, file_name, file_content, file_type, upload_name, old_gene_type, old_gene_info, old_gene2_type, old_gene2_info, old_gene3_info, old_gene3_type, old_gene4_info, old_gene4_type, old_gene5_info, old_gene5_type) TO stdout;[ Date: 2026-03-08 23:55:07 - Database: zemm_produktiv_8 - User: postgres - Remote: [local] - Application: pg_dump - Bind query: yes ]
2 1s591ms UPDATE tasks SET task_status = '7' WHERE time_completed < now() - interval '1' month;[ Date: 2026-03-08 01:30:02 - Database: zemm_produktiv_8 - User: labanimal - Remote: 81.169.238.237 - Application: expire_tasks:zemm_produktiv_8@h2940066.stratoserver.net:5432 ]
3 1s591ms CREATE SCHEMA IF NOT EXISTS observability;[ Date: 2026-03-08 01:31:01 - Database: zemm_monitoring - User: labanimal ]
4 1s591ms CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );[ Date: 2026-03-08 01:31:01 - Database: zemm_monitoring - User: labanimal ]
5 1s591ms CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);[ Date: 2026-03-08 01:31:01 - Database: zemm_monitoring - User: labanimal ]
6 1s591ms CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);[ Date: 2026-03-08 01:31:01 - Database: zemm_monitoring - User: labanimal ]
7 1s591ms CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );[ Date: 2026-03-08 01:31:01 - Database: zemm_monitoring - User: labanimal ]
8 1s591ms CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);[ Date: 2026-03-08 01:31:01 - Database: zemm_monitoring - User: labanimal ]
9 1s591ms CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);[ Date: 2026-03-08 01:31:01 - Database: zemm_monitoring - User: labanimal ]
10 1s591ms 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-08 01:31:01 - Database: zemm_monitoring - User: labanimal ]
11 1s591ms CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);[ Date: 2026-03-08 01:31:01 - Database: zemm_monitoring - User: labanimal ]
12 1s591ms 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-03-08 01:31:01 - Database: zemm_monitoring - User: labanimal ]
13 1s591ms CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );[ Date: 2026-03-08 01:31:01 - Database: zemm_monitoring - User: labanimal ]
14 1s591ms 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-03-08 01:31:01 - Database: zemm_monitoring - User: labanimal ]
15 1s591ms CREATE SCHEMA IF NOT EXISTS observability;[ Date: 2026-03-08 01:32:01 - Database: zemm_monitoring - User: labanimal ]
16 1s591ms CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );[ Date: 2026-03-08 01:32:01 - Database: zemm_monitoring - User: labanimal ]
17 1s591ms CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);[ Date: 2026-03-08 01:32:01 - Database: zemm_monitoring - User: labanimal ]
18 1s591ms CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);[ Date: 2026-03-08 01:32:01 - Database: zemm_monitoring - User: labanimal ]
19 1s591ms CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );[ Date: 2026-03-08 01:32:01 - Database: zemm_monitoring - User: labanimal ]
20 1s591ms CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);[ Date: 2026-03-08 01:32:01 - Database: zemm_monitoring - User: labanimal ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 25m 1,440 524ms 1s591ms 1s41ms create table if not exists observability.nginx_counters ( id bigserial primary key, payload jsonb not null, collected_at timestamptz not null default now() );Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 08 00 60 0ms 0ms 01 60 46s155ms 769ms 02 60 1m28s 1s482ms 03 60 1m28s 1s480ms 04 60 1m28s 1s480ms 05 60 1m28s 1s480ms 06 60 1m28s 1s480ms 07 60 1m28s 1s480ms 08 60 1m28s 1s480ms 09 60 1m28s 1s480ms 10 60 1m28s 1s480ms 11 60 1m28s 1s480ms 12 60 47s540ms 792ms 13 60 44s568ms 742ms 14 60 48s420ms 807ms 15 60 42s667ms 711ms 16 60 47s379ms 789ms 17 60 48s43ms 800ms 18 60 48s402ms 806ms 19 60 43s312ms 721ms 20 60 47s634ms 793ms 21 60 47s978ms 799ms 22 60 49s323ms 822ms 23 60 50s647ms 844ms [ User: labanimal - Total duration: 25m - Times executed: 1349 ]
-
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-03-08 02:00:01 Duration: 1s591ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-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-03-08 12:11:01 Duration: 1s480ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-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-03-08 23:59:01 Duration: 1s331ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
2 25m 1,440 524ms 1s591ms 1s41ms 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() );Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 08 00 60 0ms 0ms 01 60 46s155ms 769ms 02 60 1m28s 1s482ms 03 60 1m28s 1s480ms 04 60 1m28s 1s480ms 05 60 1m28s 1s480ms 06 60 1m28s 1s480ms 07 60 1m28s 1s480ms 08 60 1m28s 1s480ms 09 60 1m28s 1s480ms 10 60 1m28s 1s480ms 11 60 1m28s 1s480ms 12 60 47s540ms 792ms 13 60 44s568ms 742ms 14 60 48s420ms 807ms 15 60 42s667ms 711ms 16 60 47s379ms 789ms 17 60 48s43ms 800ms 18 60 48s402ms 806ms 19 60 43s312ms 721ms 20 60 47s634ms 793ms 21 60 47s978ms 799ms 22 60 49s323ms 822ms 23 60 50s647ms 844ms [ User: labanimal - Total duration: 25m - Times executed: 1349 ]
-
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-08 02:00:01 Duration: 1s591ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_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-08 12:11:01 Duration: 1s480ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_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-08 23:59:01 Duration: 1s331ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
3 25m 1,440 524ms 1s591ms 1s41ms create schema if not exists observability;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 08 00 60 0ms 0ms 01 60 46s155ms 769ms 02 60 1m28s 1s482ms 03 60 1m28s 1s480ms 04 60 1m28s 1s480ms 05 60 1m28s 1s480ms 06 60 1m28s 1s480ms 07 60 1m28s 1s480ms 08 60 1m28s 1s480ms 09 60 1m28s 1s480ms 10 60 1m28s 1s480ms 11 60 1m28s 1s480ms 12 60 47s540ms 792ms 13 60 44s568ms 742ms 14 60 48s420ms 807ms 15 60 42s667ms 711ms 16 60 47s379ms 789ms 17 60 48s43ms 800ms 18 60 48s402ms 806ms 19 60 43s312ms 721ms 20 60 47s634ms 793ms 21 60 47s978ms 799ms 22 60 49s323ms 822ms 23 60 50s647ms 844ms [ User: labanimal - Total duration: 25m - Times executed: 1349 ]
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-08 02:00:01 Duration: 1s591ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-08 12:11:01 Duration: 1s480ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-08 23:59:01 Duration: 1s331ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
4 25m 1,440 524ms 1s591ms 1s41ms create table if not exists observability.phpfpm_counters ( id bigserial primary key, payload jsonb not null, collected_at timestamptz not null default now() );Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 08 00 60 0ms 0ms 01 60 46s155ms 769ms 02 60 1m28s 1s482ms 03 60 1m28s 1s480ms 04 60 1m28s 1s480ms 05 60 1m28s 1s480ms 06 60 1m28s 1s480ms 07 60 1m28s 1s480ms 08 60 1m28s 1s480ms 09 60 1m28s 1s480ms 10 60 1m28s 1s480ms 11 60 1m28s 1s480ms 12 60 47s540ms 792ms 13 60 44s568ms 742ms 14 60 48s420ms 807ms 15 60 42s667ms 711ms 16 60 47s379ms 789ms 17 60 48s43ms 800ms 18 60 48s402ms 806ms 19 60 43s312ms 721ms 20 60 47s634ms 793ms 21 60 47s978ms 799ms 22 60 49s323ms 822ms 23 60 50s647ms 844ms [ User: labanimal - Total duration: 25m - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-08 02:00:01 Duration: 1s591ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-08 12:11:01 Duration: 1s480ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-08 23:59:01 Duration: 1s331ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
5 25m 1,440 524ms 1s591ms 1s41ms create index if not exists idx_metrics_timeseries_metric on observability.metrics_timeseries (metric_name);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Mar 08 00 60 0ms 0ms 01 60 46s155ms 769ms 02 60 1m28s 1s482ms 03 60 1m28s 1s480ms 04 60 1m28s 1s480ms 05 60 1m28s 1s480ms 06 60 1m28s 1s480ms 07 60 1m28s 1s480ms 08 60 1m28s 1s480ms 09 60 1m28s 1s480ms 10 60 1m28s 1s480ms 11 60 1m28s 1s480ms 12 60 47s540ms 792ms 13 60 44s568ms 742ms 14 60 48s420ms 807ms 15 60 42s667ms 711ms 16 60 47s379ms 789ms 17 60 48s43ms 800ms 18 60 48s402ms 806ms 19 60 43s312ms 721ms 20 60 47s634ms 793ms 21 60 47s978ms 799ms 22 60 49s323ms 822ms 23 60 50s647ms 844ms [ User: labanimal - Total duration: 25m - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-08 02:00:01 Duration: 1s591ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-08 12:11:01 Duration: 1s480ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-08 23:59:01 Duration: 1s331ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
6 25m 1,440 524ms 1s591ms 1s41ms 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() );Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Mar 08 00 60 0ms 0ms 01 60 46s155ms 769ms 02 60 1m28s 1s482ms 03 60 1m28s 1s480ms 04 60 1m28s 1s480ms 05 60 1m28s 1s480ms 06 60 1m28s 1s480ms 07 60 1m28s 1s480ms 08 60 1m28s 1s480ms 09 60 1m28s 1s480ms 10 60 1m28s 1s480ms 11 60 1m28s 1s480ms 12 60 47s540ms 792ms 13 60 44s568ms 742ms 14 60 48s420ms 807ms 15 60 42s667ms 711ms 16 60 47s379ms 789ms 17 60 48s43ms 800ms 18 60 48s402ms 806ms 19 60 43s312ms 721ms 20 60 47s634ms 793ms 21 60 47s978ms 799ms 22 60 49s323ms 822ms 23 60 50s647ms 844ms [ User: labanimal - Total duration: 25m - Times executed: 1349 ]
-
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-03-08 02:00:01 Duration: 1s591ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_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-03-08 12:11:01 Duration: 1s480ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_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-03-08 23:59:01 Duration: 1s331ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
7 25m 1,440 524ms 1s591ms 1s41ms create table if not exists observability.metrics_timeseries ( id bigserial primary key, tenant_key text not null, metric_name text not null, bucket_start timestamptz not null, bucket_width_seconds integer not null default ?, sum_value double precision not null default ?, count_value bigint not null default ?, histogram jsonb, created_at timestamptz not null default now(), updated_at timestamptz not null default now(), unique (tenant_key, metric_name, bucket_start, bucket_width_seconds) );Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Mar 08 00 60 0ms 0ms 01 60 46s155ms 769ms 02 60 1m28s 1s482ms 03 60 1m28s 1s480ms 04 60 1m28s 1s480ms 05 60 1m28s 1s480ms 06 60 1m28s 1s480ms 07 60 1m28s 1s480ms 08 60 1m28s 1s480ms 09 60 1m28s 1s480ms 10 60 1m28s 1s480ms 11 60 1m28s 1s480ms 12 60 47s540ms 792ms 13 60 44s568ms 742ms 14 60 48s420ms 807ms 15 60 42s667ms 711ms 16 60 47s379ms 789ms 17 60 48s43ms 800ms 18 60 48s402ms 806ms 19 60 43s312ms 721ms 20 60 47s634ms 793ms 21 60 47s978ms 799ms 22 60 49s323ms 822ms 23 60 50s647ms 844ms [ User: labanimal - Total duration: 25m - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-03-08 02:00:01 Duration: 1s591ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-03-08 12:11:01 Duration: 1s480ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-03-08 23:59:01 Duration: 1s331ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
8 25m 1,440 524ms 1s591ms 1s41ms create index if not exists idx_db_top_queries_tenant on observability.db_top_queries (tenant_key, collected_at desc);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Mar 08 00 60 0ms 0ms 01 60 46s155ms 769ms 02 60 1m28s 1s482ms 03 60 1m28s 1s480ms 04 60 1m28s 1s480ms 05 60 1m28s 1s480ms 06 60 1m28s 1s480ms 07 60 1m28s 1s480ms 08 60 1m28s 1s480ms 09 60 1m28s 1s480ms 10 60 1m28s 1s480ms 11 60 1m28s 1s480ms 12 60 47s540ms 792ms 13 60 44s568ms 742ms 14 60 48s420ms 807ms 15 60 42s667ms 711ms 16 60 47s379ms 789ms 17 60 48s43ms 800ms 18 60 48s402ms 806ms 19 60 43s312ms 721ms 20 60 47s634ms 793ms 21 60 47s978ms 799ms 22 60 49s323ms 822ms 23 60 50s647ms 844ms [ User: labanimal - Total duration: 25m - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-03-08 02:00:01 Duration: 1s591ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_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-08 12:11:01 Duration: 1s480ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_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-08 23:59:01 Duration: 1s331ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
9 25m 1,440 524ms 1s591ms 1s41ms create index if not exists idx_app_events_tenant on observability.app_events (tenant_key, occurred_at desc);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Mar 08 00 60 0ms 0ms 01 60 46s155ms 769ms 02 60 1m28s 1s482ms 03 60 1m28s 1s480ms 04 60 1m28s 1s480ms 05 60 1m28s 1s480ms 06 60 1m28s 1s480ms 07 60 1m28s 1s480ms 08 60 1m28s 1s480ms 09 60 1m28s 1s480ms 10 60 1m28s 1s480ms 11 60 1m28s 1s480ms 12 60 47s540ms 792ms 13 60 44s568ms 742ms 14 60 48s420ms 807ms 15 60 42s667ms 711ms 16 60 47s379ms 789ms 17 60 48s43ms 800ms 18 60 48s402ms 806ms 19 60 43s312ms 721ms 20 60 47s634ms 793ms 21 60 47s978ms 799ms 22 60 49s323ms 822ms 23 60 50s647ms 844ms [ User: labanimal - Total duration: 25m - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-08 02:00:01 Duration: 1s591ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-08 12:11:01 Duration: 1s480ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-08 23:59:01 Duration: 1s331ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
10 25m 1,440 524ms 1s591ms 1s41ms create table if not exists observability.app_events ( id bigserial primary key, tenant_key text not null, event_type text not null, severity text not null, message text not null, payload jsonb, occurred_at timestamptz not null default now(), created_at timestamptz not null default now() );Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Mar 08 00 60 0ms 0ms 01 60 46s155ms 769ms 02 60 1m28s 1s482ms 03 60 1m28s 1s480ms 04 60 1m28s 1s480ms 05 60 1m28s 1s480ms 06 60 1m28s 1s480ms 07 60 1m28s 1s480ms 08 60 1m28s 1s480ms 09 60 1m28s 1s480ms 10 60 1m28s 1s480ms 11 60 1m28s 1s480ms 12 60 47s540ms 792ms 13 60 44s568ms 742ms 14 60 48s420ms 807ms 15 60 42s667ms 711ms 16 60 47s379ms 789ms 17 60 48s43ms 800ms 18 60 48s402ms 806ms 19 60 43s312ms 721ms 20 60 47s634ms 793ms 21 60 47s978ms 799ms 22 60 49s323ms 822ms 23 60 50s647ms 844ms [ User: labanimal - Total duration: 25m - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-08 02:00:01 Duration: 1s591ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-08 12:11:01 Duration: 1s480ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-08 23:59:01 Duration: 1s331ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
11 25m 1,440 524ms 1s591ms 1s41ms create index if not exists idx_app_events_type on observability.app_events (event_type);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Mar 08 00 60 0ms 0ms 01 60 46s155ms 769ms 02 60 1m28s 1s482ms 03 60 1m28s 1s480ms 04 60 1m28s 1s480ms 05 60 1m28s 1s480ms 06 60 1m28s 1s480ms 07 60 1m28s 1s480ms 08 60 1m28s 1s480ms 09 60 1m28s 1s480ms 10 60 1m28s 1s480ms 11 60 1m28s 1s480ms 12 60 47s540ms 792ms 13 60 44s568ms 742ms 14 60 48s420ms 807ms 15 60 42s667ms 711ms 16 60 47s379ms 789ms 17 60 48s43ms 800ms 18 60 48s402ms 806ms 19 60 43s312ms 721ms 20 60 47s634ms 793ms 21 60 47s978ms 799ms 22 60 49s323ms 822ms 23 60 50s647ms 844ms [ User: labanimal - Total duration: 25m - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-08 02:00:01 Duration: 1s591ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-08 12:11:01 Duration: 1s480ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-08 23:59:01 Duration: 1s331ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
12 25m 1,440 524ms 1s591ms 1s41ms create index if not exists idx_metrics_timeseries_bucket on observability.metrics_timeseries (bucket_start);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Mar 08 00 60 0ms 0ms 01 60 46s155ms 769ms 02 60 1m28s 1s482ms 03 60 1m28s 1s480ms 04 60 1m28s 1s480ms 05 60 1m28s 1s480ms 06 60 1m28s 1s480ms 07 60 1m28s 1s480ms 08 60 1m28s 1s480ms 09 60 1m28s 1s480ms 10 60 1m28s 1s480ms 11 60 1m28s 1s480ms 12 60 47s540ms 792ms 13 60 44s568ms 742ms 14 60 48s420ms 807ms 15 60 42s667ms 711ms 16 60 47s379ms 789ms 17 60 48s43ms 800ms 18 60 48s402ms 806ms 19 60 43s312ms 721ms 20 60 47s634ms 793ms 21 60 47s978ms 799ms 22 60 49s323ms 822ms 23 60 50s647ms 844ms [ User: labanimal - Total duration: 25m - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-08 02:00:01 Duration: 1s591ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-08 12:11:01 Duration: 1s480ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-08 23:59:01 Duration: 1s331ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
13 8s800ms 11 784ms 822ms 800ms with damdam as ( select breedingid, string_agg(cast(dam as text), ?) as dam from breedingsdams inner join ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" from animals) as dam on dam.id = breedingsdams.dam and case when user_is_tgm (dam.owner, ?) then true when user_is_tgm (dam.editor, ?) then true when user_is_tgm (dam.tourist, ?) then true else false end group by breedingid ), siresire as ( select breedingid, string_agg(cast(sire as text), ?) as sire from breedingssires inner join ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" from animals) as sire on sire.id = breedingssires.sire and case when user_is_tgm (sire.owner, ?) then true when user_is_tgm (sire.editor, ?) then true when user_is_tgm (sire.tourist, ?) then true else false end group by breedingid ), cagess as ( select id, "cageName" from cages) ( select breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire from damdam, siresire, cagess, breedings where breedings.deleted != true and cagess.id = breedings.cage and damdam.breedingid = breedings.id and siresire.breedingid = breedings.id and breedings."unbreeding_date" is null group by breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire order by breeding_date, plug_date);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Mar 08 13 1 813ms 813ms 14 1 794ms 794ms 15 1 789ms 789ms 17 2 1s615ms 807ms 18 1 784ms 784ms 19 2 1s601ms 800ms 20 1 789ms 789ms 21 1 822ms 822ms 23 1 789ms 789ms [ User: labanimal - Total duration: 8s800ms - Times executed: 11 ]
[ Application: _desktop_index.php_command_animals_breedings_subcommand_select_ - Total duration: 8s800ms - Times executed: 11 ]
-
WITH damdam AS ( SELECT breedingid, string_agg(cast(dam as text), ';') AS dam FROM breedingsdams INNER JOIN ( SELECT id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS dam ON dam.id = breedingsdams.dam AND CASE WHEN user_is_tgm (dam.owner, 1) THEN TRUE WHEN user_is_tgm (dam.editor, 1) THEN TRUE WHEN user_is_tgm (dam.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), siresire AS ( SELECT breedingid, string_agg(cast(sire as text), ';') AS sire FROM breedingssires INNER JOIN ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS sire ON sire.id = breedingssires.sire AND CASE WHEN user_is_tgm (sire.owner, 1) THEN TRUE WHEN user_is_tgm (sire.editor, 1) THEN TRUE WHEN user_is_tgm (sire.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-03-08 21:40:19 Duration: 822ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_command_animals_breedings_subcommand_select_ Bind query: yes Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
-
WITH damdam AS ( SELECT breedingid, string_agg(cast(dam as text), ';') AS dam FROM breedingsdams INNER JOIN ( SELECT id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS dam ON dam.id = breedingsdams.dam AND CASE WHEN user_is_tgm (dam.owner, 1) THEN TRUE WHEN user_is_tgm (dam.editor, 1) THEN TRUE WHEN user_is_tgm (dam.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), siresire AS ( SELECT breedingid, string_agg(cast(sire as text), ';') AS sire FROM breedingssires INNER JOIN ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS sire ON sire.id = breedingssires.sire AND CASE WHEN user_is_tgm (sire.owner, 1) THEN TRUE WHEN user_is_tgm (sire.editor, 1) THEN TRUE WHEN user_is_tgm (sire.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-03-08 13:21:21 Duration: 813ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_command_animals_breedings_subcommand_select_ Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
-
WITH damdam AS ( SELECT breedingid, string_agg(cast(dam as text), ';') AS dam FROM breedingsdams INNER JOIN ( SELECT id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS dam ON dam.id = breedingsdams.dam AND CASE WHEN user_is_tgm (dam.owner, 1) THEN TRUE WHEN user_is_tgm (dam.editor, 1) THEN TRUE WHEN user_is_tgm (dam.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), siresire AS ( SELECT breedingid, string_agg(cast(sire as text), ';') AS sire FROM breedingssires INNER JOIN ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS sire ON sire.id = breedingssires.sire AND CASE WHEN user_is_tgm (sire.owner, 1) THEN TRUE WHEN user_is_tgm (sire.editor, 1) THEN TRUE WHEN user_is_tgm (sire.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-03-08 17:54:04 Duration: 809ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_command_animals_breedings_subcommand_select_ Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
14 1s967ms 1 1s967ms 1s967ms 1s967ms copy public.diary (id, "animalID", date, "entrybyID", "cageID", weight, temperature, "fDeprivation", "wDeprivation", "sDeprivation", "feedingClass", health, comments, "breedingInfo", deleted, "inOutDate", "inOutFlag", text, sdesc, treatment, tailcut_id, tailcut_result, file_name, file_content, file_type, upload_name, old_gene_type, old_gene_info, old_gene2_type, old_gene2_info, old_gene3_info, old_gene3_type, old_gene4_info, old_gene4_type, old_gene5_info, old_gene5_type) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Mar 08 23 1 1s967ms 1s967ms [ User: postgres - Total duration: 1s967ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s967ms - Times executed: 1 ]
-
COPY public.diary (id, "animalID", date, "entrybyID", "cageID", weight, temperature, "fDeprivation", "wDeprivation", "sDeprivation", "feedingClass", health, comments, "breedingInfo", deleted, "inOutDate", "inOutFlag", text, sdesc, treatment, tailcut_id, tailcut_result, file_name, file_content, file_type, upload_name, old_gene_type, old_gene_info, old_gene2_type, old_gene2_info, old_gene3_info, old_gene3_type, old_gene4_info, old_gene4_type, old_gene5_info, old_gene5_type) TO stdout;
Date: 2026-03-08 23:55:07 Duration: 1s967ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Bind query: yes Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
15 1s591ms 1 1s591ms 1s591ms 1s591ms update tasks set task_status = ? where time_completed < now() - interval ? month;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Mar 08 01 1 1s591ms 1s591ms [ User: labanimal - Total duration: 1s591ms - Times executed: 1 ]
[ Application: expire_tasks:zemm_produktiv_8@h2940066.stratoserver.net:5432 - Total duration: 1s591ms - Times executed: 1 ]
-
UPDATE tasks SET task_status = '7' WHERE time_completed < now() - interval '1' month;
Date: 2026-03-08 01:30:02 Duration: 1s591ms Database: zemm_produktiv_8 User: labanimal Remote: 81.169.238.237 Application: expire_tasks:zemm_produktiv_8@h2940066.stratoserver.net:5432 Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
16 1s480ms 1 1s480ms 1s480ms 1s480ms select tc.id, tc.status_new as task_status, tasks.id as task_id, tasks.name as task_name, tasks.instructions as task_instructions, tasks.comment as task_comment, issuer."fullName" as issuer, tasks.time_issued, completed_by."fullName" as completed_by, tasks.time_completed, array ( select users."eMail" from "targetgroupMembers" recipients inner join users on users.id = recipients."user" where recipients.targetgroup = tc.originator and users."eMail" is not null and not (users.disablemail)) AS "to", array ( select users."eMail" from "targetgroupMembers" recipients inner join "groupMembers" gm on gm."group" = recipients."group" inner join users on users.id = gm."user" where recipients.targetgroup = tc.originator and users."eMail" is not null and not (users.disablemail)) AS "cc" from tasks_changes tc inner join tasks on tasks.id = tc.task left join users issuer on issuer.id = tasks.issuer left join users completed_by on completed_by.id = tasks.completed_by where not (tc.deleted);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Mar 08 02 1 1s480ms 1s480ms [ User: labanimal - Total duration: 1s480ms - Times executed: 1 ]
[ Application: taskscron:zemm_produktiv_8@h2940066.stratoserver.net:5432 - Total duration: 1s480ms - Times executed: 1 ]
-
SELECT tc.id, tc.status_new AS task_status, tasks.id AS task_id, tasks.name AS task_name, tasks.instructions AS task_instructions, tasks.comment AS task_comment, issuer."fullName" as issuer, tasks.time_issued, completed_by."fullName" AS completed_by, tasks.time_completed, ARRAY ( SELECT users."eMail" FROM "targetgroupMembers" recipients INNER JOIN users ON users.id = recipients."user" WHERE recipients.targetgroup = tc.originator AND users."eMail" IS NOT NULL AND NOT (users.disablemail)) as "to", ARRAY ( SELECT users."eMail" FROM "targetgroupMembers" recipients INNER JOIN "groupMembers" gm ON gm."group" = recipients."group" INNER JOIN users ON users.id = gm."user" WHERE recipients.targetgroup = tc.originator AND users."eMail" IS NOT NULL AND NOT (users.disablemail)) as "cc" FROM tasks_changes tc INNER JOIN tasks ON tasks.id = tc.task LEFT JOIN users issuer ON issuer.id = tasks.issuer LEFT JOIN users completed_by ON completed_by.id = tasks.completed_by WHERE NOT (tc.deleted);
Date: 2026-03-08 02:00:03 Duration: 1s480ms Database: zemm_produktiv_8 User: labanimal Remote: 81.169.238.237 Application: taskscron:zemm_produktiv_8@h2940066.stratoserver.net:5432 Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
17 1s331ms 1 1s331ms 1s331ms 1s331ms copy public."targetgroupMembers" (id, targetgroup, "user", "group") to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Mar 08 23 1 1s331ms 1s331ms [ User: postgres - Total duration: 1s331ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s331ms - Times executed: 1 ]
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-03-08 23:55:09 Duration: 1s331ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Bind query: yes Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
18 1s284ms 1 1s284ms 1s284ms 1s284ms copy public.animals_search_mview (id, name, animal_id, deleted, alive, birth_date, arrival_date, death_date, outgoing_date, cage, comments, sterile, breeding, fate, last_mating, last_mating_date, breeding_cage, sex, strain, line, gene_1_info, gene_1_type, gene_2_info, gene_2_type, gene_3_info, gene_3_type, gene_4_info, gene_4_type, gene_5_info, gene_5_type, backcross, generation, project, project_name, species, species_name, cage_name, location, location_name, dam, dam_name, dam_id, sire, sire_name, sire_id, cohort, litter, rfid, owner, editor, tourist, breeding_status, workgroup_infos, experiment, experiment_name) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Mar 08 23 1 1s284ms 1s284ms [ User: postgres - Total duration: 1s284ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s284ms - Times executed: 1 ]
-
COPY public.animals_search_mview (id, name, animal_id, deleted, alive, birth_date, arrival_date, death_date, outgoing_date, cage, comments, sterile, breeding, fate, last_mating, last_mating_date, breeding_cage, sex, strain, line, gene_1_info, gene_1_type, gene_2_info, gene_2_type, gene_3_info, gene_3_type, gene_4_info, gene_4_type, gene_5_info, gene_5_type, backcross, generation, project, project_name, species, species_name, cage_name, location, location_name, dam, dam_name, dam_id, sire, sire_name, sire_id, cohort, litter, rfid, owner, editor, tourist, breeding_status, workgroup_infos, experiment, experiment_name) TO stdout;
Date: 2026-03-08 23:55:04 Duration: 1s284ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Bind query: yes Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
19 1s214ms 1 1s214ms 1s214ms 1s214ms copy public.animals (id, species, transgen, "homeCage", tourist, editor, owner, comments, pregnant, name, sex, "standardDescription", "parentFemale", "parentMale", "parentFoster", colour, "plannedUseFor", deleted, generation, chimare, "birthDate", "arrivalDate", "outgoingDate", "deathDate", breedstatus_2, "healthState", breeder, restrictions, "geneStatus", "geneFlanking", "geneDeleted", "fromOrder_2", "group", "fromOrder", strain, "breedStatus", "FEMnumber", genotype, inbreeding, identification, jax, "KOgene", "feedingClass", dummy_gen_info, breeding, sterile, project, dummy_line_info, dummy_strain_info, "bredWith", "curCage", dummy_backcross_info, fate, "fateComment", alive, reciever, "animalID", litter, weight_at_arrival, cohort, gen_2_info, gen_3_info, gen_4_info, gen_5_info, gen_1_typ, gen_2_typ, gen_3_typ, gen_4_typ, gen_5_typ, "latestMatingDate", "latestMating", genecomment, recycle) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 08 23 1 1s214ms 1s214ms [ User: postgres - Total duration: 1s214ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s214ms - Times executed: 1 ]
-
COPY public.animals (id, species, transgen, "homeCage", tourist, editor, owner, comments, pregnant, name, sex, "standardDescription", "parentFemale", "parentMale", "parentFoster", colour, "plannedUseFor", deleted, generation, chimare, "birthDate", "arrivalDate", "outgoingDate", "deathDate", breedstatus_2, "healthState", breeder, restrictions, "geneStatus", "geneFlanking", "geneDeleted", "fromOrder_2", "group", "fromOrder", strain, "breedStatus", "FEMnumber", genotype, inbreeding, identification, jax, "KOgene", "feedingClass", dummy_gen_info, breeding, sterile, project, dummy_line_info, dummy_strain_info, "bredWith", "curCage", dummy_backcross_info, fate, "fateComment", alive, reciever, "animalID", litter, weight_at_arrival, cohort, gen_2_info, gen_3_info, gen_4_info, gen_5_info, gen_1_typ, gen_2_typ, gen_3_typ, gen_4_typ, gen_5_typ, "latestMatingDate", "latestMating", genecomment, recycle) TO stdout;
Date: 2026-03-08 23:55:03 Duration: 1s214ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Bind query: yes Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
20 659ms 1 659ms 659ms 659ms select count(distinct animal_id) AS "count" from ( select animals_search_mview.*, b.unbreeding_date, a.id as animal, user_is_tgm (animals_search_mview.owner, ?) as is_owner, user_is_tgm (animals_search_mview.editor, ?) as is_editor, user_is_tgm (animals_search_mview.tourist, ?) as is_tourist, case when animals_search_mview.id not in ( select animals_id from scoresheet_diary) then ? else ? end as isscored from animals_search_mview left join strains on strains.name = animals_search_mview.strain left join license_history lh on lh.anid = animals_search_mview.id left join animals a on a."animalID" = animals_search_mview.animal_id left join breedings b on b.id = animals_search_mview.last_mating) data where fate = ? and alive = ? and deleted = ? and (is_owner or is_editor or is_tourist);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 08 12 1 659ms 659ms [ User: labanimal - Total duration: 659ms - Times executed: 1 ]
[ Application: _desktop_index.php_command_login_subcommand_init_zemm_produktiv - Total duration: 659ms - Times executed: 1 ]
-
SELECT COUNT(DISTINCT animal_id) AS "count" FROM ( SELECT animals_search_mview.*, b.unbreeding_date, a.id as animal, user_is_tgm (animals_search_mview.owner, 10100107) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100107) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100107) AS is_tourist, CASE WHEN animals_search_mview.id NOT IN ( SELECT animals_id FROM scoresheet_diary) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN animals a ON a."animalID" = animals_search_mview.animal_id LEFT JOIN breedings b ON b.id = animals_search_mview.last_mating) data WHERE fate = 5 AND alive = 't' AND deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-03-08 12:11:34 Duration: 659ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_command_login_subcommand_init_zemm_produktiv Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,440 25m 524ms 1s591ms 1s41ms create table if not exists observability.nginx_counters ( id bigserial primary key, payload jsonb not null, collected_at timestamptz not null default now() );Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 08 00 60 0ms 0ms 01 60 46s155ms 769ms 02 60 1m28s 1s482ms 03 60 1m28s 1s480ms 04 60 1m28s 1s480ms 05 60 1m28s 1s480ms 06 60 1m28s 1s480ms 07 60 1m28s 1s480ms 08 60 1m28s 1s480ms 09 60 1m28s 1s480ms 10 60 1m28s 1s480ms 11 60 1m28s 1s480ms 12 60 47s540ms 792ms 13 60 44s568ms 742ms 14 60 48s420ms 807ms 15 60 42s667ms 711ms 16 60 47s379ms 789ms 17 60 48s43ms 800ms 18 60 48s402ms 806ms 19 60 43s312ms 721ms 20 60 47s634ms 793ms 21 60 47s978ms 799ms 22 60 49s323ms 822ms 23 60 50s647ms 844ms [ User: labanimal - Total duration: 25m - Times executed: 1349 ]
-
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-03-08 02:00:01 Duration: 1s591ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-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-03-08 12:11:01 Duration: 1s480ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-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-03-08 23:59:01 Duration: 1s331ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
2 1,440 25m 524ms 1s591ms 1s41ms 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() );Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 08 00 60 0ms 0ms 01 60 46s155ms 769ms 02 60 1m28s 1s482ms 03 60 1m28s 1s480ms 04 60 1m28s 1s480ms 05 60 1m28s 1s480ms 06 60 1m28s 1s480ms 07 60 1m28s 1s480ms 08 60 1m28s 1s480ms 09 60 1m28s 1s480ms 10 60 1m28s 1s480ms 11 60 1m28s 1s480ms 12 60 47s540ms 792ms 13 60 44s568ms 742ms 14 60 48s420ms 807ms 15 60 42s667ms 711ms 16 60 47s379ms 789ms 17 60 48s43ms 800ms 18 60 48s402ms 806ms 19 60 43s312ms 721ms 20 60 47s634ms 793ms 21 60 47s978ms 799ms 22 60 49s323ms 822ms 23 60 50s647ms 844ms [ User: labanimal - Total duration: 25m - Times executed: 1349 ]
-
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-08 02:00:01 Duration: 1s591ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_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-08 12:11:01 Duration: 1s480ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_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-08 23:59:01 Duration: 1s331ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
3 1,440 25m 524ms 1s591ms 1s41ms create schema if not exists observability;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 08 00 60 0ms 0ms 01 60 46s155ms 769ms 02 60 1m28s 1s482ms 03 60 1m28s 1s480ms 04 60 1m28s 1s480ms 05 60 1m28s 1s480ms 06 60 1m28s 1s480ms 07 60 1m28s 1s480ms 08 60 1m28s 1s480ms 09 60 1m28s 1s480ms 10 60 1m28s 1s480ms 11 60 1m28s 1s480ms 12 60 47s540ms 792ms 13 60 44s568ms 742ms 14 60 48s420ms 807ms 15 60 42s667ms 711ms 16 60 47s379ms 789ms 17 60 48s43ms 800ms 18 60 48s402ms 806ms 19 60 43s312ms 721ms 20 60 47s634ms 793ms 21 60 47s978ms 799ms 22 60 49s323ms 822ms 23 60 50s647ms 844ms [ User: labanimal - Total duration: 25m - Times executed: 1349 ]
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-08 02:00:01 Duration: 1s591ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-08 12:11:01 Duration: 1s480ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-08 23:59:01 Duration: 1s331ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
4 1,440 25m 524ms 1s591ms 1s41ms create table if not exists observability.phpfpm_counters ( id bigserial primary key, payload jsonb not null, collected_at timestamptz not null default now() );Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 08 00 60 0ms 0ms 01 60 46s155ms 769ms 02 60 1m28s 1s482ms 03 60 1m28s 1s480ms 04 60 1m28s 1s480ms 05 60 1m28s 1s480ms 06 60 1m28s 1s480ms 07 60 1m28s 1s480ms 08 60 1m28s 1s480ms 09 60 1m28s 1s480ms 10 60 1m28s 1s480ms 11 60 1m28s 1s480ms 12 60 47s540ms 792ms 13 60 44s568ms 742ms 14 60 48s420ms 807ms 15 60 42s667ms 711ms 16 60 47s379ms 789ms 17 60 48s43ms 800ms 18 60 48s402ms 806ms 19 60 43s312ms 721ms 20 60 47s634ms 793ms 21 60 47s978ms 799ms 22 60 49s323ms 822ms 23 60 50s647ms 844ms [ User: labanimal - Total duration: 25m - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-08 02:00:01 Duration: 1s591ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-08 12:11:01 Duration: 1s480ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-08 23:59:01 Duration: 1s331ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
5 1,440 25m 524ms 1s591ms 1s41ms create index if not exists idx_metrics_timeseries_metric on observability.metrics_timeseries (metric_name);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Mar 08 00 60 0ms 0ms 01 60 46s155ms 769ms 02 60 1m28s 1s482ms 03 60 1m28s 1s480ms 04 60 1m28s 1s480ms 05 60 1m28s 1s480ms 06 60 1m28s 1s480ms 07 60 1m28s 1s480ms 08 60 1m28s 1s480ms 09 60 1m28s 1s480ms 10 60 1m28s 1s480ms 11 60 1m28s 1s480ms 12 60 47s540ms 792ms 13 60 44s568ms 742ms 14 60 48s420ms 807ms 15 60 42s667ms 711ms 16 60 47s379ms 789ms 17 60 48s43ms 800ms 18 60 48s402ms 806ms 19 60 43s312ms 721ms 20 60 47s634ms 793ms 21 60 47s978ms 799ms 22 60 49s323ms 822ms 23 60 50s647ms 844ms [ User: labanimal - Total duration: 25m - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-08 02:00:01 Duration: 1s591ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-08 12:11:01 Duration: 1s480ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-08 23:59:01 Duration: 1s331ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
6 1,440 25m 524ms 1s591ms 1s41ms 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() );Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Mar 08 00 60 0ms 0ms 01 60 46s155ms 769ms 02 60 1m28s 1s482ms 03 60 1m28s 1s480ms 04 60 1m28s 1s480ms 05 60 1m28s 1s480ms 06 60 1m28s 1s480ms 07 60 1m28s 1s480ms 08 60 1m28s 1s480ms 09 60 1m28s 1s480ms 10 60 1m28s 1s480ms 11 60 1m28s 1s480ms 12 60 47s540ms 792ms 13 60 44s568ms 742ms 14 60 48s420ms 807ms 15 60 42s667ms 711ms 16 60 47s379ms 789ms 17 60 48s43ms 800ms 18 60 48s402ms 806ms 19 60 43s312ms 721ms 20 60 47s634ms 793ms 21 60 47s978ms 799ms 22 60 49s323ms 822ms 23 60 50s647ms 844ms [ User: labanimal - Total duration: 25m - Times executed: 1349 ]
-
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-03-08 02:00:01 Duration: 1s591ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_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-03-08 12:11:01 Duration: 1s480ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_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-03-08 23:59:01 Duration: 1s331ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
7 1,440 25m 524ms 1s591ms 1s41ms create table if not exists observability.metrics_timeseries ( id bigserial primary key, tenant_key text not null, metric_name text not null, bucket_start timestamptz not null, bucket_width_seconds integer not null default ?, sum_value double precision not null default ?, count_value bigint not null default ?, histogram jsonb, created_at timestamptz not null default now(), updated_at timestamptz not null default now(), unique (tenant_key, metric_name, bucket_start, bucket_width_seconds) );Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Mar 08 00 60 0ms 0ms 01 60 46s155ms 769ms 02 60 1m28s 1s482ms 03 60 1m28s 1s480ms 04 60 1m28s 1s480ms 05 60 1m28s 1s480ms 06 60 1m28s 1s480ms 07 60 1m28s 1s480ms 08 60 1m28s 1s480ms 09 60 1m28s 1s480ms 10 60 1m28s 1s480ms 11 60 1m28s 1s480ms 12 60 47s540ms 792ms 13 60 44s568ms 742ms 14 60 48s420ms 807ms 15 60 42s667ms 711ms 16 60 47s379ms 789ms 17 60 48s43ms 800ms 18 60 48s402ms 806ms 19 60 43s312ms 721ms 20 60 47s634ms 793ms 21 60 47s978ms 799ms 22 60 49s323ms 822ms 23 60 50s647ms 844ms [ User: labanimal - Total duration: 25m - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-03-08 02:00:01 Duration: 1s591ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-03-08 12:11:01 Duration: 1s480ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-03-08 23:59:01 Duration: 1s331ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
8 1,440 25m 524ms 1s591ms 1s41ms create index if not exists idx_db_top_queries_tenant on observability.db_top_queries (tenant_key, collected_at desc);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Mar 08 00 60 0ms 0ms 01 60 46s155ms 769ms 02 60 1m28s 1s482ms 03 60 1m28s 1s480ms 04 60 1m28s 1s480ms 05 60 1m28s 1s480ms 06 60 1m28s 1s480ms 07 60 1m28s 1s480ms 08 60 1m28s 1s480ms 09 60 1m28s 1s480ms 10 60 1m28s 1s480ms 11 60 1m28s 1s480ms 12 60 47s540ms 792ms 13 60 44s568ms 742ms 14 60 48s420ms 807ms 15 60 42s667ms 711ms 16 60 47s379ms 789ms 17 60 48s43ms 800ms 18 60 48s402ms 806ms 19 60 43s312ms 721ms 20 60 47s634ms 793ms 21 60 47s978ms 799ms 22 60 49s323ms 822ms 23 60 50s647ms 844ms [ User: labanimal - Total duration: 25m - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-03-08 02:00:01 Duration: 1s591ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_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-08 12:11:01 Duration: 1s480ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_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-08 23:59:01 Duration: 1s331ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
9 1,440 25m 524ms 1s591ms 1s41ms create index if not exists idx_app_events_tenant on observability.app_events (tenant_key, occurred_at desc);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Mar 08 00 60 0ms 0ms 01 60 46s155ms 769ms 02 60 1m28s 1s482ms 03 60 1m28s 1s480ms 04 60 1m28s 1s480ms 05 60 1m28s 1s480ms 06 60 1m28s 1s480ms 07 60 1m28s 1s480ms 08 60 1m28s 1s480ms 09 60 1m28s 1s480ms 10 60 1m28s 1s480ms 11 60 1m28s 1s480ms 12 60 47s540ms 792ms 13 60 44s568ms 742ms 14 60 48s420ms 807ms 15 60 42s667ms 711ms 16 60 47s379ms 789ms 17 60 48s43ms 800ms 18 60 48s402ms 806ms 19 60 43s312ms 721ms 20 60 47s634ms 793ms 21 60 47s978ms 799ms 22 60 49s323ms 822ms 23 60 50s647ms 844ms [ User: labanimal - Total duration: 25m - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-08 02:00:01 Duration: 1s591ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-08 12:11:01 Duration: 1s480ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-08 23:59:01 Duration: 1s331ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
10 1,440 25m 524ms 1s591ms 1s41ms create table if not exists observability.app_events ( id bigserial primary key, tenant_key text not null, event_type text not null, severity text not null, message text not null, payload jsonb, occurred_at timestamptz not null default now(), created_at timestamptz not null default now() );Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Mar 08 00 60 0ms 0ms 01 60 46s155ms 769ms 02 60 1m28s 1s482ms 03 60 1m28s 1s480ms 04 60 1m28s 1s480ms 05 60 1m28s 1s480ms 06 60 1m28s 1s480ms 07 60 1m28s 1s480ms 08 60 1m28s 1s480ms 09 60 1m28s 1s480ms 10 60 1m28s 1s480ms 11 60 1m28s 1s480ms 12 60 47s540ms 792ms 13 60 44s568ms 742ms 14 60 48s420ms 807ms 15 60 42s667ms 711ms 16 60 47s379ms 789ms 17 60 48s43ms 800ms 18 60 48s402ms 806ms 19 60 43s312ms 721ms 20 60 47s634ms 793ms 21 60 47s978ms 799ms 22 60 49s323ms 822ms 23 60 50s647ms 844ms [ User: labanimal - Total duration: 25m - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-08 02:00:01 Duration: 1s591ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-08 12:11:01 Duration: 1s480ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-08 23:59:01 Duration: 1s331ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
11 1,440 25m 524ms 1s591ms 1s41ms create index if not exists idx_app_events_type on observability.app_events (event_type);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Mar 08 00 60 0ms 0ms 01 60 46s155ms 769ms 02 60 1m28s 1s482ms 03 60 1m28s 1s480ms 04 60 1m28s 1s480ms 05 60 1m28s 1s480ms 06 60 1m28s 1s480ms 07 60 1m28s 1s480ms 08 60 1m28s 1s480ms 09 60 1m28s 1s480ms 10 60 1m28s 1s480ms 11 60 1m28s 1s480ms 12 60 47s540ms 792ms 13 60 44s568ms 742ms 14 60 48s420ms 807ms 15 60 42s667ms 711ms 16 60 47s379ms 789ms 17 60 48s43ms 800ms 18 60 48s402ms 806ms 19 60 43s312ms 721ms 20 60 47s634ms 793ms 21 60 47s978ms 799ms 22 60 49s323ms 822ms 23 60 50s647ms 844ms [ User: labanimal - Total duration: 25m - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-08 02:00:01 Duration: 1s591ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-08 12:11:01 Duration: 1s480ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-08 23:59:01 Duration: 1s331ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
12 1,440 25m 524ms 1s591ms 1s41ms create index if not exists idx_metrics_timeseries_bucket on observability.metrics_timeseries (bucket_start);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Mar 08 00 60 0ms 0ms 01 60 46s155ms 769ms 02 60 1m28s 1s482ms 03 60 1m28s 1s480ms 04 60 1m28s 1s480ms 05 60 1m28s 1s480ms 06 60 1m28s 1s480ms 07 60 1m28s 1s480ms 08 60 1m28s 1s480ms 09 60 1m28s 1s480ms 10 60 1m28s 1s480ms 11 60 1m28s 1s480ms 12 60 47s540ms 792ms 13 60 44s568ms 742ms 14 60 48s420ms 807ms 15 60 42s667ms 711ms 16 60 47s379ms 789ms 17 60 48s43ms 800ms 18 60 48s402ms 806ms 19 60 43s312ms 721ms 20 60 47s634ms 793ms 21 60 47s978ms 799ms 22 60 49s323ms 822ms 23 60 50s647ms 844ms [ User: labanimal - Total duration: 25m - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-08 02:00:01 Duration: 1s591ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-08 12:11:01 Duration: 1s480ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-08 23:59:01 Duration: 1s331ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
13 11 8s800ms 784ms 822ms 800ms with damdam as ( select breedingid, string_agg(cast(dam as text), ?) as dam from breedingsdams inner join ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" from animals) as dam on dam.id = breedingsdams.dam and case when user_is_tgm (dam.owner, ?) then true when user_is_tgm (dam.editor, ?) then true when user_is_tgm (dam.tourist, ?) then true else false end group by breedingid ), siresire as ( select breedingid, string_agg(cast(sire as text), ?) as sire from breedingssires inner join ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" from animals) as sire on sire.id = breedingssires.sire and case when user_is_tgm (sire.owner, ?) then true when user_is_tgm (sire.editor, ?) then true when user_is_tgm (sire.tourist, ?) then true else false end group by breedingid ), cagess as ( select id, "cageName" from cages) ( select breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire from damdam, siresire, cagess, breedings where breedings.deleted != true and cagess.id = breedings.cage and damdam.breedingid = breedings.id and siresire.breedingid = breedings.id and breedings."unbreeding_date" is null group by breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire order by breeding_date, plug_date);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Mar 08 13 1 813ms 813ms 14 1 794ms 794ms 15 1 789ms 789ms 17 2 1s615ms 807ms 18 1 784ms 784ms 19 2 1s601ms 800ms 20 1 789ms 789ms 21 1 822ms 822ms 23 1 789ms 789ms [ User: labanimal - Total duration: 8s800ms - Times executed: 11 ]
[ Application: _desktop_index.php_command_animals_breedings_subcommand_select_ - Total duration: 8s800ms - Times executed: 11 ]
-
WITH damdam AS ( SELECT breedingid, string_agg(cast(dam as text), ';') AS dam FROM breedingsdams INNER JOIN ( SELECT id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS dam ON dam.id = breedingsdams.dam AND CASE WHEN user_is_tgm (dam.owner, 1) THEN TRUE WHEN user_is_tgm (dam.editor, 1) THEN TRUE WHEN user_is_tgm (dam.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), siresire AS ( SELECT breedingid, string_agg(cast(sire as text), ';') AS sire FROM breedingssires INNER JOIN ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS sire ON sire.id = breedingssires.sire AND CASE WHEN user_is_tgm (sire.owner, 1) THEN TRUE WHEN user_is_tgm (sire.editor, 1) THEN TRUE WHEN user_is_tgm (sire.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-03-08 21:40:19 Duration: 822ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_command_animals_breedings_subcommand_select_ Bind query: yes Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
-
WITH damdam AS ( SELECT breedingid, string_agg(cast(dam as text), ';') AS dam FROM breedingsdams INNER JOIN ( SELECT id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS dam ON dam.id = breedingsdams.dam AND CASE WHEN user_is_tgm (dam.owner, 1) THEN TRUE WHEN user_is_tgm (dam.editor, 1) THEN TRUE WHEN user_is_tgm (dam.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), siresire AS ( SELECT breedingid, string_agg(cast(sire as text), ';') AS sire FROM breedingssires INNER JOIN ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS sire ON sire.id = breedingssires.sire AND CASE WHEN user_is_tgm (sire.owner, 1) THEN TRUE WHEN user_is_tgm (sire.editor, 1) THEN TRUE WHEN user_is_tgm (sire.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-03-08 13:21:21 Duration: 813ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_command_animals_breedings_subcommand_select_ Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
-
WITH damdam AS ( SELECT breedingid, string_agg(cast(dam as text), ';') AS dam FROM breedingsdams INNER JOIN ( SELECT id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS dam ON dam.id = breedingsdams.dam AND CASE WHEN user_is_tgm (dam.owner, 1) THEN TRUE WHEN user_is_tgm (dam.editor, 1) THEN TRUE WHEN user_is_tgm (dam.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), siresire AS ( SELECT breedingid, string_agg(cast(sire as text), ';') AS sire FROM breedingssires INNER JOIN ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS sire ON sire.id = breedingssires.sire AND CASE WHEN user_is_tgm (sire.owner, 1) THEN TRUE WHEN user_is_tgm (sire.editor, 1) THEN TRUE WHEN user_is_tgm (sire.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-03-08 17:54:04 Duration: 809ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_command_animals_breedings_subcommand_select_ Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
14 1 1s967ms 1s967ms 1s967ms 1s967ms copy public.diary (id, "animalID", date, "entrybyID", "cageID", weight, temperature, "fDeprivation", "wDeprivation", "sDeprivation", "feedingClass", health, comments, "breedingInfo", deleted, "inOutDate", "inOutFlag", text, sdesc, treatment, tailcut_id, tailcut_result, file_name, file_content, file_type, upload_name, old_gene_type, old_gene_info, old_gene2_type, old_gene2_info, old_gene3_info, old_gene3_type, old_gene4_info, old_gene4_type, old_gene5_info, old_gene5_type) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Mar 08 23 1 1s967ms 1s967ms [ User: postgres - Total duration: 1s967ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s967ms - Times executed: 1 ]
-
COPY public.diary (id, "animalID", date, "entrybyID", "cageID", weight, temperature, "fDeprivation", "wDeprivation", "sDeprivation", "feedingClass", health, comments, "breedingInfo", deleted, "inOutDate", "inOutFlag", text, sdesc, treatment, tailcut_id, tailcut_result, file_name, file_content, file_type, upload_name, old_gene_type, old_gene_info, old_gene2_type, old_gene2_info, old_gene3_info, old_gene3_type, old_gene4_info, old_gene4_type, old_gene5_info, old_gene5_type) TO stdout;
Date: 2026-03-08 23:55:07 Duration: 1s967ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Bind query: yes Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
15 1 1s591ms 1s591ms 1s591ms 1s591ms update tasks set task_status = ? where time_completed < now() - interval ? month;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Mar 08 01 1 1s591ms 1s591ms [ User: labanimal - Total duration: 1s591ms - Times executed: 1 ]
[ Application: expire_tasks:zemm_produktiv_8@h2940066.stratoserver.net:5432 - Total duration: 1s591ms - Times executed: 1 ]
-
UPDATE tasks SET task_status = '7' WHERE time_completed < now() - interval '1' month;
Date: 2026-03-08 01:30:02 Duration: 1s591ms Database: zemm_produktiv_8 User: labanimal Remote: 81.169.238.237 Application: expire_tasks:zemm_produktiv_8@h2940066.stratoserver.net:5432 Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
16 1 1s480ms 1s480ms 1s480ms 1s480ms select tc.id, tc.status_new as task_status, tasks.id as task_id, tasks.name as task_name, tasks.instructions as task_instructions, tasks.comment as task_comment, issuer."fullName" as issuer, tasks.time_issued, completed_by."fullName" as completed_by, tasks.time_completed, array ( select users."eMail" from "targetgroupMembers" recipients inner join users on users.id = recipients."user" where recipients.targetgroup = tc.originator and users."eMail" is not null and not (users.disablemail)) AS "to", array ( select users."eMail" from "targetgroupMembers" recipients inner join "groupMembers" gm on gm."group" = recipients."group" inner join users on users.id = gm."user" where recipients.targetgroup = tc.originator and users."eMail" is not null and not (users.disablemail)) AS "cc" from tasks_changes tc inner join tasks on tasks.id = tc.task left join users issuer on issuer.id = tasks.issuer left join users completed_by on completed_by.id = tasks.completed_by where not (tc.deleted);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Mar 08 02 1 1s480ms 1s480ms [ User: labanimal - Total duration: 1s480ms - Times executed: 1 ]
[ Application: taskscron:zemm_produktiv_8@h2940066.stratoserver.net:5432 - Total duration: 1s480ms - Times executed: 1 ]
-
SELECT tc.id, tc.status_new AS task_status, tasks.id AS task_id, tasks.name AS task_name, tasks.instructions AS task_instructions, tasks.comment AS task_comment, issuer."fullName" as issuer, tasks.time_issued, completed_by."fullName" AS completed_by, tasks.time_completed, ARRAY ( SELECT users."eMail" FROM "targetgroupMembers" recipients INNER JOIN users ON users.id = recipients."user" WHERE recipients.targetgroup = tc.originator AND users."eMail" IS NOT NULL AND NOT (users.disablemail)) as "to", ARRAY ( SELECT users."eMail" FROM "targetgroupMembers" recipients INNER JOIN "groupMembers" gm ON gm."group" = recipients."group" INNER JOIN users ON users.id = gm."user" WHERE recipients.targetgroup = tc.originator AND users."eMail" IS NOT NULL AND NOT (users.disablemail)) as "cc" FROM tasks_changes tc INNER JOIN tasks ON tasks.id = tc.task LEFT JOIN users issuer ON issuer.id = tasks.issuer LEFT JOIN users completed_by ON completed_by.id = tasks.completed_by WHERE NOT (tc.deleted);
Date: 2026-03-08 02:00:03 Duration: 1s480ms Database: zemm_produktiv_8 User: labanimal Remote: 81.169.238.237 Application: taskscron:zemm_produktiv_8@h2940066.stratoserver.net:5432 Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
17 1 1s331ms 1s331ms 1s331ms 1s331ms copy public."targetgroupMembers" (id, targetgroup, "user", "group") to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Mar 08 23 1 1s331ms 1s331ms [ User: postgres - Total duration: 1s331ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s331ms - Times executed: 1 ]
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-03-08 23:55:09 Duration: 1s331ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Bind query: yes Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
18 1 1s284ms 1s284ms 1s284ms 1s284ms copy public.animals_search_mview (id, name, animal_id, deleted, alive, birth_date, arrival_date, death_date, outgoing_date, cage, comments, sterile, breeding, fate, last_mating, last_mating_date, breeding_cage, sex, strain, line, gene_1_info, gene_1_type, gene_2_info, gene_2_type, gene_3_info, gene_3_type, gene_4_info, gene_4_type, gene_5_info, gene_5_type, backcross, generation, project, project_name, species, species_name, cage_name, location, location_name, dam, dam_name, dam_id, sire, sire_name, sire_id, cohort, litter, rfid, owner, editor, tourist, breeding_status, workgroup_infos, experiment, experiment_name) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Mar 08 23 1 1s284ms 1s284ms [ User: postgres - Total duration: 1s284ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s284ms - Times executed: 1 ]
-
COPY public.animals_search_mview (id, name, animal_id, deleted, alive, birth_date, arrival_date, death_date, outgoing_date, cage, comments, sterile, breeding, fate, last_mating, last_mating_date, breeding_cage, sex, strain, line, gene_1_info, gene_1_type, gene_2_info, gene_2_type, gene_3_info, gene_3_type, gene_4_info, gene_4_type, gene_5_info, gene_5_type, backcross, generation, project, project_name, species, species_name, cage_name, location, location_name, dam, dam_name, dam_id, sire, sire_name, sire_id, cohort, litter, rfid, owner, editor, tourist, breeding_status, workgroup_infos, experiment, experiment_name) TO stdout;
Date: 2026-03-08 23:55:04 Duration: 1s284ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Bind query: yes Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
19 1 1s214ms 1s214ms 1s214ms 1s214ms copy public.animals (id, species, transgen, "homeCage", tourist, editor, owner, comments, pregnant, name, sex, "standardDescription", "parentFemale", "parentMale", "parentFoster", colour, "plannedUseFor", deleted, generation, chimare, "birthDate", "arrivalDate", "outgoingDate", "deathDate", breedstatus_2, "healthState", breeder, restrictions, "geneStatus", "geneFlanking", "geneDeleted", "fromOrder_2", "group", "fromOrder", strain, "breedStatus", "FEMnumber", genotype, inbreeding, identification, jax, "KOgene", "feedingClass", dummy_gen_info, breeding, sterile, project, dummy_line_info, dummy_strain_info, "bredWith", "curCage", dummy_backcross_info, fate, "fateComment", alive, reciever, "animalID", litter, weight_at_arrival, cohort, gen_2_info, gen_3_info, gen_4_info, gen_5_info, gen_1_typ, gen_2_typ, gen_3_typ, gen_4_typ, gen_5_typ, "latestMatingDate", "latestMating", genecomment, recycle) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 08 23 1 1s214ms 1s214ms [ User: postgres - Total duration: 1s214ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s214ms - Times executed: 1 ]
-
COPY public.animals (id, species, transgen, "homeCage", tourist, editor, owner, comments, pregnant, name, sex, "standardDescription", "parentFemale", "parentMale", "parentFoster", colour, "plannedUseFor", deleted, generation, chimare, "birthDate", "arrivalDate", "outgoingDate", "deathDate", breedstatus_2, "healthState", breeder, restrictions, "geneStatus", "geneFlanking", "geneDeleted", "fromOrder_2", "group", "fromOrder", strain, "breedStatus", "FEMnumber", genotype, inbreeding, identification, jax, "KOgene", "feedingClass", dummy_gen_info, breeding, sterile, project, dummy_line_info, dummy_strain_info, "bredWith", "curCage", dummy_backcross_info, fate, "fateComment", alive, reciever, "animalID", litter, weight_at_arrival, cohort, gen_2_info, gen_3_info, gen_4_info, gen_5_info, gen_1_typ, gen_2_typ, gen_3_typ, gen_4_typ, gen_5_typ, "latestMatingDate", "latestMating", genecomment, recycle) TO stdout;
Date: 2026-03-08 23:55:03 Duration: 1s214ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Bind query: yes Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
20 1 659ms 659ms 659ms 659ms select count(distinct animal_id) AS "count" from ( select animals_search_mview.*, b.unbreeding_date, a.id as animal, user_is_tgm (animals_search_mview.owner, ?) as is_owner, user_is_tgm (animals_search_mview.editor, ?) as is_editor, user_is_tgm (animals_search_mview.tourist, ?) as is_tourist, case when animals_search_mview.id not in ( select animals_id from scoresheet_diary) then ? else ? end as isscored from animals_search_mview left join strains on strains.name = animals_search_mview.strain left join license_history lh on lh.anid = animals_search_mview.id left join animals a on a."animalID" = animals_search_mview.animal_id left join breedings b on b.id = animals_search_mview.last_mating) data where fate = ? and alive = ? and deleted = ? and (is_owner or is_editor or is_tourist);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 08 12 1 659ms 659ms [ User: labanimal - Total duration: 659ms - Times executed: 1 ]
[ Application: _desktop_index.php_command_login_subcommand_init_zemm_produktiv - Total duration: 659ms - Times executed: 1 ]
-
SELECT COUNT(DISTINCT animal_id) AS "count" FROM ( SELECT animals_search_mview.*, b.unbreeding_date, a.id as animal, user_is_tgm (animals_search_mview.owner, 10100107) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100107) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100107) AS is_tourist, CASE WHEN animals_search_mview.id NOT IN ( SELECT animals_id FROM scoresheet_diary) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN animals a ON a."animalID" = animals_search_mview.animal_id LEFT JOIN breedings b ON b.id = animals_search_mview.last_mating) data WHERE fate = 5 AND alive = 't' AND deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-03-08 12:11:34 Duration: 659ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_command_login_subcommand_init_zemm_produktiv Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 1s967ms 1s967ms 1s967ms 1 1s967ms copy public.diary (id, "animalID", date, "entrybyID", "cageID", weight, temperature, "fDeprivation", "wDeprivation", "sDeprivation", "feedingClass", health, comments, "breedingInfo", deleted, "inOutDate", "inOutFlag", text, sdesc, treatment, tailcut_id, tailcut_result, file_name, file_content, file_type, upload_name, old_gene_type, old_gene_info, old_gene2_type, old_gene2_info, old_gene3_info, old_gene3_type, old_gene4_info, old_gene4_type, old_gene5_info, old_gene5_type) to stdout;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 08 23 1 1s967ms 1s967ms [ User: postgres - Total duration: 1s967ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s967ms - Times executed: 1 ]
-
COPY public.diary (id, "animalID", date, "entrybyID", "cageID", weight, temperature, "fDeprivation", "wDeprivation", "sDeprivation", "feedingClass", health, comments, "breedingInfo", deleted, "inOutDate", "inOutFlag", text, sdesc, treatment, tailcut_id, tailcut_result, file_name, file_content, file_type, upload_name, old_gene_type, old_gene_info, old_gene2_type, old_gene2_info, old_gene3_info, old_gene3_type, old_gene4_info, old_gene4_type, old_gene5_info, old_gene5_type) TO stdout;
Date: 2026-03-08 23:55:07 Duration: 1s967ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Bind query: yes Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
2 1s591ms 1s591ms 1s591ms 1 1s591ms update tasks set task_status = ? where time_completed < now() - interval ? month;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 08 01 1 1s591ms 1s591ms [ User: labanimal - Total duration: 1s591ms - Times executed: 1 ]
[ Application: expire_tasks:zemm_produktiv_8@h2940066.stratoserver.net:5432 - Total duration: 1s591ms - Times executed: 1 ]
-
UPDATE tasks SET task_status = '7' WHERE time_completed < now() - interval '1' month;
Date: 2026-03-08 01:30:02 Duration: 1s591ms Database: zemm_produktiv_8 User: labanimal Remote: 81.169.238.237 Application: expire_tasks:zemm_produktiv_8@h2940066.stratoserver.net:5432 Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
3 1s480ms 1s480ms 1s480ms 1 1s480ms select tc.id, tc.status_new as task_status, tasks.id as task_id, tasks.name as task_name, tasks.instructions as task_instructions, tasks.comment as task_comment, issuer."fullName" as issuer, tasks.time_issued, completed_by."fullName" as completed_by, tasks.time_completed, array ( select users."eMail" from "targetgroupMembers" recipients inner join users on users.id = recipients."user" where recipients.targetgroup = tc.originator and users."eMail" is not null and not (users.disablemail)) AS "to", array ( select users."eMail" from "targetgroupMembers" recipients inner join "groupMembers" gm on gm."group" = recipients."group" inner join users on users.id = gm."user" where recipients.targetgroup = tc.originator and users."eMail" is not null and not (users.disablemail)) AS "cc" from tasks_changes tc inner join tasks on tasks.id = tc.task left join users issuer on issuer.id = tasks.issuer left join users completed_by on completed_by.id = tasks.completed_by where not (tc.deleted);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 08 02 1 1s480ms 1s480ms [ User: labanimal - Total duration: 1s480ms - Times executed: 1 ]
[ Application: taskscron:zemm_produktiv_8@h2940066.stratoserver.net:5432 - Total duration: 1s480ms - Times executed: 1 ]
-
SELECT tc.id, tc.status_new AS task_status, tasks.id AS task_id, tasks.name AS task_name, tasks.instructions AS task_instructions, tasks.comment AS task_comment, issuer."fullName" as issuer, tasks.time_issued, completed_by."fullName" AS completed_by, tasks.time_completed, ARRAY ( SELECT users."eMail" FROM "targetgroupMembers" recipients INNER JOIN users ON users.id = recipients."user" WHERE recipients.targetgroup = tc.originator AND users."eMail" IS NOT NULL AND NOT (users.disablemail)) as "to", ARRAY ( SELECT users."eMail" FROM "targetgroupMembers" recipients INNER JOIN "groupMembers" gm ON gm."group" = recipients."group" INNER JOIN users ON users.id = gm."user" WHERE recipients.targetgroup = tc.originator AND users."eMail" IS NOT NULL AND NOT (users.disablemail)) as "cc" FROM tasks_changes tc INNER JOIN tasks ON tasks.id = tc.task LEFT JOIN users issuer ON issuer.id = tasks.issuer LEFT JOIN users completed_by ON completed_by.id = tasks.completed_by WHERE NOT (tc.deleted);
Date: 2026-03-08 02:00:03 Duration: 1s480ms Database: zemm_produktiv_8 User: labanimal Remote: 81.169.238.237 Application: taskscron:zemm_produktiv_8@h2940066.stratoserver.net:5432 Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
4 1s331ms 1s331ms 1s331ms 1 1s331ms copy public."targetgroupMembers" (id, targetgroup, "user", "group") to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 08 23 1 1s331ms 1s331ms [ User: postgres - Total duration: 1s331ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s331ms - Times executed: 1 ]
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-03-08 23:55:09 Duration: 1s331ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Bind query: yes Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
5 1s284ms 1s284ms 1s284ms 1 1s284ms copy public.animals_search_mview (id, name, animal_id, deleted, alive, birth_date, arrival_date, death_date, outgoing_date, cage, comments, sterile, breeding, fate, last_mating, last_mating_date, breeding_cage, sex, strain, line, gene_1_info, gene_1_type, gene_2_info, gene_2_type, gene_3_info, gene_3_type, gene_4_info, gene_4_type, gene_5_info, gene_5_type, backcross, generation, project, project_name, species, species_name, cage_name, location, location_name, dam, dam_name, dam_id, sire, sire_name, sire_id, cohort, litter, rfid, owner, editor, tourist, breeding_status, workgroup_infos, experiment, experiment_name) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Mar 08 23 1 1s284ms 1s284ms [ User: postgres - Total duration: 1s284ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s284ms - Times executed: 1 ]
-
COPY public.animals_search_mview (id, name, animal_id, deleted, alive, birth_date, arrival_date, death_date, outgoing_date, cage, comments, sterile, breeding, fate, last_mating, last_mating_date, breeding_cage, sex, strain, line, gene_1_info, gene_1_type, gene_2_info, gene_2_type, gene_3_info, gene_3_type, gene_4_info, gene_4_type, gene_5_info, gene_5_type, backcross, generation, project, project_name, species, species_name, cage_name, location, location_name, dam, dam_name, dam_id, sire, sire_name, sire_id, cohort, litter, rfid, owner, editor, tourist, breeding_status, workgroup_infos, experiment, experiment_name) TO stdout;
Date: 2026-03-08 23:55:04 Duration: 1s284ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Bind query: yes Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
6 1s214ms 1s214ms 1s214ms 1 1s214ms copy public.animals (id, species, transgen, "homeCage", tourist, editor, owner, comments, pregnant, name, sex, "standardDescription", "parentFemale", "parentMale", "parentFoster", colour, "plannedUseFor", deleted, generation, chimare, "birthDate", "arrivalDate", "outgoingDate", "deathDate", breedstatus_2, "healthState", breeder, restrictions, "geneStatus", "geneFlanking", "geneDeleted", "fromOrder_2", "group", "fromOrder", strain, "breedStatus", "FEMnumber", genotype, inbreeding, identification, jax, "KOgene", "feedingClass", dummy_gen_info, breeding, sterile, project, dummy_line_info, dummy_strain_info, "bredWith", "curCage", dummy_backcross_info, fate, "fateComment", alive, reciever, "animalID", litter, weight_at_arrival, cohort, gen_2_info, gen_3_info, gen_4_info, gen_5_info, gen_1_typ, gen_2_typ, gen_3_typ, gen_4_typ, gen_5_typ, "latestMatingDate", "latestMating", genecomment, recycle) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Mar 08 23 1 1s214ms 1s214ms [ User: postgres - Total duration: 1s214ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s214ms - Times executed: 1 ]
-
COPY public.animals (id, species, transgen, "homeCage", tourist, editor, owner, comments, pregnant, name, sex, "standardDescription", "parentFemale", "parentMale", "parentFoster", colour, "plannedUseFor", deleted, generation, chimare, "birthDate", "arrivalDate", "outgoingDate", "deathDate", breedstatus_2, "healthState", breeder, restrictions, "geneStatus", "geneFlanking", "geneDeleted", "fromOrder_2", "group", "fromOrder", strain, "breedStatus", "FEMnumber", genotype, inbreeding, identification, jax, "KOgene", "feedingClass", dummy_gen_info, breeding, sterile, project, dummy_line_info, dummy_strain_info, "bredWith", "curCage", dummy_backcross_info, fate, "fateComment", alive, reciever, "animalID", litter, weight_at_arrival, cohort, gen_2_info, gen_3_info, gen_4_info, gen_5_info, gen_1_typ, gen_2_typ, gen_3_typ, gen_4_typ, gen_5_typ, "latestMatingDate", "latestMating", genecomment, recycle) TO stdout;
Date: 2026-03-08 23:55:03 Duration: 1s214ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Bind query: yes Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
7 524ms 1s591ms 1s41ms 1,440 25m create table if not exists observability.nginx_counters ( id bigserial primary key, payload jsonb not null, collected_at timestamptz not null default now() );Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Mar 08 00 60 0ms 0ms 01 60 46s155ms 769ms 02 60 1m28s 1s482ms 03 60 1m28s 1s480ms 04 60 1m28s 1s480ms 05 60 1m28s 1s480ms 06 60 1m28s 1s480ms 07 60 1m28s 1s480ms 08 60 1m28s 1s480ms 09 60 1m28s 1s480ms 10 60 1m28s 1s480ms 11 60 1m28s 1s480ms 12 60 47s540ms 792ms 13 60 44s568ms 742ms 14 60 48s420ms 807ms 15 60 42s667ms 711ms 16 60 47s379ms 789ms 17 60 48s43ms 800ms 18 60 48s402ms 806ms 19 60 43s312ms 721ms 20 60 47s634ms 793ms 21 60 47s978ms 799ms 22 60 49s323ms 822ms 23 60 50s647ms 844ms [ User: labanimal - Total duration: 25m - Times executed: 1349 ]
-
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-03-08 02:00:01 Duration: 1s591ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-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-03-08 12:11:01 Duration: 1s480ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-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-03-08 23:59:01 Duration: 1s331ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
8 524ms 1s591ms 1s41ms 1,440 25m 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() );Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Mar 08 00 60 0ms 0ms 01 60 46s155ms 769ms 02 60 1m28s 1s482ms 03 60 1m28s 1s480ms 04 60 1m28s 1s480ms 05 60 1m28s 1s480ms 06 60 1m28s 1s480ms 07 60 1m28s 1s480ms 08 60 1m28s 1s480ms 09 60 1m28s 1s480ms 10 60 1m28s 1s480ms 11 60 1m28s 1s480ms 12 60 47s540ms 792ms 13 60 44s568ms 742ms 14 60 48s420ms 807ms 15 60 42s667ms 711ms 16 60 47s379ms 789ms 17 60 48s43ms 800ms 18 60 48s402ms 806ms 19 60 43s312ms 721ms 20 60 47s634ms 793ms 21 60 47s978ms 799ms 22 60 49s323ms 822ms 23 60 50s647ms 844ms [ User: labanimal - Total duration: 25m - Times executed: 1349 ]
-
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-08 02:00:01 Duration: 1s591ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_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-08 12:11:01 Duration: 1s480ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_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-08 23:59:01 Duration: 1s331ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
9 524ms 1s591ms 1s41ms 1,440 25m create schema if not exists observability;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Mar 08 00 60 0ms 0ms 01 60 46s155ms 769ms 02 60 1m28s 1s482ms 03 60 1m28s 1s480ms 04 60 1m28s 1s480ms 05 60 1m28s 1s480ms 06 60 1m28s 1s480ms 07 60 1m28s 1s480ms 08 60 1m28s 1s480ms 09 60 1m28s 1s480ms 10 60 1m28s 1s480ms 11 60 1m28s 1s480ms 12 60 47s540ms 792ms 13 60 44s568ms 742ms 14 60 48s420ms 807ms 15 60 42s667ms 711ms 16 60 47s379ms 789ms 17 60 48s43ms 800ms 18 60 48s402ms 806ms 19 60 43s312ms 721ms 20 60 47s634ms 793ms 21 60 47s978ms 799ms 22 60 49s323ms 822ms 23 60 50s647ms 844ms [ User: labanimal - Total duration: 25m - Times executed: 1349 ]
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-08 02:00:01 Duration: 1s591ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-08 12:11:01 Duration: 1s480ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-08 23:59:01 Duration: 1s331ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
10 524ms 1s591ms 1s41ms 1,440 25m create table if not exists observability.phpfpm_counters ( id bigserial primary key, payload jsonb not null, collected_at timestamptz not null default now() );Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Mar 08 00 60 0ms 0ms 01 60 46s155ms 769ms 02 60 1m28s 1s482ms 03 60 1m28s 1s480ms 04 60 1m28s 1s480ms 05 60 1m28s 1s480ms 06 60 1m28s 1s480ms 07 60 1m28s 1s480ms 08 60 1m28s 1s480ms 09 60 1m28s 1s480ms 10 60 1m28s 1s480ms 11 60 1m28s 1s480ms 12 60 47s540ms 792ms 13 60 44s568ms 742ms 14 60 48s420ms 807ms 15 60 42s667ms 711ms 16 60 47s379ms 789ms 17 60 48s43ms 800ms 18 60 48s402ms 806ms 19 60 43s312ms 721ms 20 60 47s634ms 793ms 21 60 47s978ms 799ms 22 60 49s323ms 822ms 23 60 50s647ms 844ms [ User: labanimal - Total duration: 25m - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-08 02:00:01 Duration: 1s591ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-08 12:11:01 Duration: 1s480ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-08 23:59:01 Duration: 1s331ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
11 524ms 1s591ms 1s41ms 1,440 25m create index if not exists idx_metrics_timeseries_metric on observability.metrics_timeseries (metric_name);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Mar 08 00 60 0ms 0ms 01 60 46s155ms 769ms 02 60 1m28s 1s482ms 03 60 1m28s 1s480ms 04 60 1m28s 1s480ms 05 60 1m28s 1s480ms 06 60 1m28s 1s480ms 07 60 1m28s 1s480ms 08 60 1m28s 1s480ms 09 60 1m28s 1s480ms 10 60 1m28s 1s480ms 11 60 1m28s 1s480ms 12 60 47s540ms 792ms 13 60 44s568ms 742ms 14 60 48s420ms 807ms 15 60 42s667ms 711ms 16 60 47s379ms 789ms 17 60 48s43ms 800ms 18 60 48s402ms 806ms 19 60 43s312ms 721ms 20 60 47s634ms 793ms 21 60 47s978ms 799ms 22 60 49s323ms 822ms 23 60 50s647ms 844ms [ User: labanimal - Total duration: 25m - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-08 02:00:01 Duration: 1s591ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-08 12:11:01 Duration: 1s480ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-08 23:59:01 Duration: 1s331ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
12 524ms 1s591ms 1s41ms 1,440 25m 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() );Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Mar 08 00 60 0ms 0ms 01 60 46s155ms 769ms 02 60 1m28s 1s482ms 03 60 1m28s 1s480ms 04 60 1m28s 1s480ms 05 60 1m28s 1s480ms 06 60 1m28s 1s480ms 07 60 1m28s 1s480ms 08 60 1m28s 1s480ms 09 60 1m28s 1s480ms 10 60 1m28s 1s480ms 11 60 1m28s 1s480ms 12 60 47s540ms 792ms 13 60 44s568ms 742ms 14 60 48s420ms 807ms 15 60 42s667ms 711ms 16 60 47s379ms 789ms 17 60 48s43ms 800ms 18 60 48s402ms 806ms 19 60 43s312ms 721ms 20 60 47s634ms 793ms 21 60 47s978ms 799ms 22 60 49s323ms 822ms 23 60 50s647ms 844ms [ User: labanimal - Total duration: 25m - Times executed: 1349 ]
-
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-03-08 02:00:01 Duration: 1s591ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_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-03-08 12:11:01 Duration: 1s480ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_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-03-08 23:59:01 Duration: 1s331ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
13 524ms 1s591ms 1s41ms 1,440 25m create table if not exists observability.metrics_timeseries ( id bigserial primary key, tenant_key text not null, metric_name text not null, bucket_start timestamptz not null, bucket_width_seconds integer not null default ?, sum_value double precision not null default ?, count_value bigint not null default ?, histogram jsonb, created_at timestamptz not null default now(), updated_at timestamptz not null default now(), unique (tenant_key, metric_name, bucket_start, bucket_width_seconds) );Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Mar 08 00 60 0ms 0ms 01 60 46s155ms 769ms 02 60 1m28s 1s482ms 03 60 1m28s 1s480ms 04 60 1m28s 1s480ms 05 60 1m28s 1s480ms 06 60 1m28s 1s480ms 07 60 1m28s 1s480ms 08 60 1m28s 1s480ms 09 60 1m28s 1s480ms 10 60 1m28s 1s480ms 11 60 1m28s 1s480ms 12 60 47s540ms 792ms 13 60 44s568ms 742ms 14 60 48s420ms 807ms 15 60 42s667ms 711ms 16 60 47s379ms 789ms 17 60 48s43ms 800ms 18 60 48s402ms 806ms 19 60 43s312ms 721ms 20 60 47s634ms 793ms 21 60 47s978ms 799ms 22 60 49s323ms 822ms 23 60 50s647ms 844ms [ User: labanimal - Total duration: 25m - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-03-08 02:00:01 Duration: 1s591ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-03-08 12:11:01 Duration: 1s480ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-03-08 23:59:01 Duration: 1s331ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
14 524ms 1s591ms 1s41ms 1,440 25m create index if not exists idx_db_top_queries_tenant on observability.db_top_queries (tenant_key, collected_at desc);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Mar 08 00 60 0ms 0ms 01 60 46s155ms 769ms 02 60 1m28s 1s482ms 03 60 1m28s 1s480ms 04 60 1m28s 1s480ms 05 60 1m28s 1s480ms 06 60 1m28s 1s480ms 07 60 1m28s 1s480ms 08 60 1m28s 1s480ms 09 60 1m28s 1s480ms 10 60 1m28s 1s480ms 11 60 1m28s 1s480ms 12 60 47s540ms 792ms 13 60 44s568ms 742ms 14 60 48s420ms 807ms 15 60 42s667ms 711ms 16 60 47s379ms 789ms 17 60 48s43ms 800ms 18 60 48s402ms 806ms 19 60 43s312ms 721ms 20 60 47s634ms 793ms 21 60 47s978ms 799ms 22 60 49s323ms 822ms 23 60 50s647ms 844ms [ User: labanimal - Total duration: 25m - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-03-08 02:00:01 Duration: 1s591ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_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-08 12:11:01 Duration: 1s480ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_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-08 23:59:01 Duration: 1s331ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
15 524ms 1s591ms 1s41ms 1,440 25m create index if not exists idx_app_events_tenant on observability.app_events (tenant_key, occurred_at desc);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Mar 08 00 60 0ms 0ms 01 60 46s155ms 769ms 02 60 1m28s 1s482ms 03 60 1m28s 1s480ms 04 60 1m28s 1s480ms 05 60 1m28s 1s480ms 06 60 1m28s 1s480ms 07 60 1m28s 1s480ms 08 60 1m28s 1s480ms 09 60 1m28s 1s480ms 10 60 1m28s 1s480ms 11 60 1m28s 1s480ms 12 60 47s540ms 792ms 13 60 44s568ms 742ms 14 60 48s420ms 807ms 15 60 42s667ms 711ms 16 60 47s379ms 789ms 17 60 48s43ms 800ms 18 60 48s402ms 806ms 19 60 43s312ms 721ms 20 60 47s634ms 793ms 21 60 47s978ms 799ms 22 60 49s323ms 822ms 23 60 50s647ms 844ms [ User: labanimal - Total duration: 25m - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-08 02:00:01 Duration: 1s591ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-08 12:11:01 Duration: 1s480ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-08 23:59:01 Duration: 1s331ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
16 524ms 1s591ms 1s41ms 1,440 25m create table if not exists observability.app_events ( id bigserial primary key, tenant_key text not null, event_type text not null, severity text not null, message text not null, payload jsonb, occurred_at timestamptz not null default now(), created_at timestamptz not null default now() );Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Mar 08 00 60 0ms 0ms 01 60 46s155ms 769ms 02 60 1m28s 1s482ms 03 60 1m28s 1s480ms 04 60 1m28s 1s480ms 05 60 1m28s 1s480ms 06 60 1m28s 1s480ms 07 60 1m28s 1s480ms 08 60 1m28s 1s480ms 09 60 1m28s 1s480ms 10 60 1m28s 1s480ms 11 60 1m28s 1s480ms 12 60 47s540ms 792ms 13 60 44s568ms 742ms 14 60 48s420ms 807ms 15 60 42s667ms 711ms 16 60 47s379ms 789ms 17 60 48s43ms 800ms 18 60 48s402ms 806ms 19 60 43s312ms 721ms 20 60 47s634ms 793ms 21 60 47s978ms 799ms 22 60 49s323ms 822ms 23 60 50s647ms 844ms [ User: labanimal - Total duration: 25m - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-08 02:00:01 Duration: 1s591ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-08 12:11:01 Duration: 1s480ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-08 23:59:01 Duration: 1s331ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
17 524ms 1s591ms 1s41ms 1,440 25m create index if not exists idx_app_events_type on observability.app_events (event_type);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Mar 08 00 60 0ms 0ms 01 60 46s155ms 769ms 02 60 1m28s 1s482ms 03 60 1m28s 1s480ms 04 60 1m28s 1s480ms 05 60 1m28s 1s480ms 06 60 1m28s 1s480ms 07 60 1m28s 1s480ms 08 60 1m28s 1s480ms 09 60 1m28s 1s480ms 10 60 1m28s 1s480ms 11 60 1m28s 1s480ms 12 60 47s540ms 792ms 13 60 44s568ms 742ms 14 60 48s420ms 807ms 15 60 42s667ms 711ms 16 60 47s379ms 789ms 17 60 48s43ms 800ms 18 60 48s402ms 806ms 19 60 43s312ms 721ms 20 60 47s634ms 793ms 21 60 47s978ms 799ms 22 60 49s323ms 822ms 23 60 50s647ms 844ms [ User: labanimal - Total duration: 25m - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-08 02:00:01 Duration: 1s591ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-08 12:11:01 Duration: 1s480ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-08 23:59:01 Duration: 1s331ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
18 524ms 1s591ms 1s41ms 1,440 25m create index if not exists idx_metrics_timeseries_bucket on observability.metrics_timeseries (bucket_start);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Mar 08 00 60 0ms 0ms 01 60 46s155ms 769ms 02 60 1m28s 1s482ms 03 60 1m28s 1s480ms 04 60 1m28s 1s480ms 05 60 1m28s 1s480ms 06 60 1m28s 1s480ms 07 60 1m28s 1s480ms 08 60 1m28s 1s480ms 09 60 1m28s 1s480ms 10 60 1m28s 1s480ms 11 60 1m28s 1s480ms 12 60 47s540ms 792ms 13 60 44s568ms 742ms 14 60 48s420ms 807ms 15 60 42s667ms 711ms 16 60 47s379ms 789ms 17 60 48s43ms 800ms 18 60 48s402ms 806ms 19 60 43s312ms 721ms 20 60 47s634ms 793ms 21 60 47s978ms 799ms 22 60 49s323ms 822ms 23 60 50s647ms 844ms [ User: labanimal - Total duration: 25m - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-08 02:00:01 Duration: 1s591ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-08 12:11:01 Duration: 1s480ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-08 23:59:01 Duration: 1s331ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
19 784ms 822ms 800ms 11 8s800ms with damdam as ( select breedingid, string_agg(cast(dam as text), ?) as dam from breedingsdams inner join ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" from animals) as dam on dam.id = breedingsdams.dam and case when user_is_tgm (dam.owner, ?) then true when user_is_tgm (dam.editor, ?) then true when user_is_tgm (dam.tourist, ?) then true else false end group by breedingid ), siresire as ( select breedingid, string_agg(cast(sire as text), ?) as sire from breedingssires inner join ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" from animals) as sire on sire.id = breedingssires.sire and case when user_is_tgm (sire.owner, ?) then true when user_is_tgm (sire.editor, ?) then true when user_is_tgm (sire.tourist, ?) then true else false end group by breedingid ), cagess as ( select id, "cageName" from cages) ( select breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire from damdam, siresire, cagess, breedings where breedings.deleted != true and cagess.id = breedings.cage and damdam.breedingid = breedings.id and siresire.breedingid = breedings.id and breedings."unbreeding_date" is null group by breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire order by breeding_date, plug_date);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 08 13 1 813ms 813ms 14 1 794ms 794ms 15 1 789ms 789ms 17 2 1s615ms 807ms 18 1 784ms 784ms 19 2 1s601ms 800ms 20 1 789ms 789ms 21 1 822ms 822ms 23 1 789ms 789ms [ User: labanimal - Total duration: 8s800ms - Times executed: 11 ]
[ Application: _desktop_index.php_command_animals_breedings_subcommand_select_ - Total duration: 8s800ms - Times executed: 11 ]
-
WITH damdam AS ( SELECT breedingid, string_agg(cast(dam as text), ';') AS dam FROM breedingsdams INNER JOIN ( SELECT id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS dam ON dam.id = breedingsdams.dam AND CASE WHEN user_is_tgm (dam.owner, 1) THEN TRUE WHEN user_is_tgm (dam.editor, 1) THEN TRUE WHEN user_is_tgm (dam.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), siresire AS ( SELECT breedingid, string_agg(cast(sire as text), ';') AS sire FROM breedingssires INNER JOIN ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS sire ON sire.id = breedingssires.sire AND CASE WHEN user_is_tgm (sire.owner, 1) THEN TRUE WHEN user_is_tgm (sire.editor, 1) THEN TRUE WHEN user_is_tgm (sire.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-03-08 21:40:19 Duration: 822ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_command_animals_breedings_subcommand_select_ Bind query: yes Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
-
WITH damdam AS ( SELECT breedingid, string_agg(cast(dam as text), ';') AS dam FROM breedingsdams INNER JOIN ( SELECT id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS dam ON dam.id = breedingsdams.dam AND CASE WHEN user_is_tgm (dam.owner, 1) THEN TRUE WHEN user_is_tgm (dam.editor, 1) THEN TRUE WHEN user_is_tgm (dam.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), siresire AS ( SELECT breedingid, string_agg(cast(sire as text), ';') AS sire FROM breedingssires INNER JOIN ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS sire ON sire.id = breedingssires.sire AND CASE WHEN user_is_tgm (sire.owner, 1) THEN TRUE WHEN user_is_tgm (sire.editor, 1) THEN TRUE WHEN user_is_tgm (sire.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-03-08 13:21:21 Duration: 813ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_command_animals_breedings_subcommand_select_ Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
-
WITH damdam AS ( SELECT breedingid, string_agg(cast(dam as text), ';') AS dam FROM breedingsdams INNER JOIN ( SELECT id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS dam ON dam.id = breedingsdams.dam AND CASE WHEN user_is_tgm (dam.owner, 1) THEN TRUE WHEN user_is_tgm (dam.editor, 1) THEN TRUE WHEN user_is_tgm (dam.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), siresire AS ( SELECT breedingid, string_agg(cast(sire as text), ';') AS sire FROM breedingssires INNER JOIN ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS sire ON sire.id = breedingssires.sire AND CASE WHEN user_is_tgm (sire.owner, 1) THEN TRUE WHEN user_is_tgm (sire.editor, 1) THEN TRUE WHEN user_is_tgm (sire.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-03-08 17:54:04 Duration: 809ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_command_animals_breedings_subcommand_select_ Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
20 659ms 659ms 659ms 1 659ms select count(distinct animal_id) AS "count" from ( select animals_search_mview.*, b.unbreeding_date, a.id as animal, user_is_tgm (animals_search_mview.owner, ?) as is_owner, user_is_tgm (animals_search_mview.editor, ?) as is_editor, user_is_tgm (animals_search_mview.tourist, ?) as is_tourist, case when animals_search_mview.id not in ( select animals_id from scoresheet_diary) then ? else ? end as isscored from animals_search_mview left join strains on strains.name = animals_search_mview.strain left join license_history lh on lh.anid = animals_search_mview.id left join animals a on a."animalID" = animals_search_mview.animal_id left join breedings b on b.id = animals_search_mview.last_mating) data where fate = ? and alive = ? and deleted = ? and (is_owner or is_editor or is_tourist);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 08 12 1 659ms 659ms [ User: labanimal - Total duration: 659ms - Times executed: 1 ]
[ Application: _desktop_index.php_command_login_subcommand_init_zemm_produktiv - Total duration: 659ms - Times executed: 1 ]
-
SELECT COUNT(DISTINCT animal_id) AS "count" FROM ( SELECT animals_search_mview.*, b.unbreeding_date, a.id as animal, user_is_tgm (animals_search_mview.owner, 10100107) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100107) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100107) AS is_tourist, CASE WHEN animals_search_mview.id NOT IN ( SELECT animals_id FROM scoresheet_diary) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN animals a ON a."animalID" = animals_search_mview.animal_id LEFT JOIN breedings b ON b.id = animals_search_mview.last_mating) data WHERE fate = 5 AND alive = 't' AND deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-03-08 12:11:34 Duration: 659ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_command_login_subcommand_init_zemm_produktiv Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
-
Events
Log levels
Key values
- 97,511 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 15 FATAL entries
- 7 ERROR entries
- 0 WARNING entries
- 6 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 14 Max number of times the same event was reported
- 28 Total events found
Rank Times reported Error 1 14 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Mar 08 04 2 11 4 17 6 18 2 - FATAL: database "monitoring" does not exist
- FATAL: database "monitoring" does not exist
- FATAL: database "monitoring" does not exist
Date: 2026-03-08 04:56:40 Database: monitoring Application: User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
Date: 2026-03-08 04:56:41 Database: monitoring Application: User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
Date: 2026-03-08 11:19:17 Database: monitoring Application: User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
2 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Mar 08 17 2 19 2 - ERROR: relation "monitoring_request_metrics" does not exist
- ERROR: relation "observability.metrics_timeseries" does not exist
- ERROR: relation "__db_error_logger_smoke_test_missing_table__" does not exist
Statement: select bucket_start, request_count, error_rate, p95_ms, p99_ms from monitoring_request_metrics where tenant_key='prod' order by bucket_start desc limit 40;
Date: 2026-03-08 17:52:10 Database: zemm_produktiv_8 Application: psql User: postgres Remote: [local] Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
Statement: select tenant_key, metric_name, count(*) from observability.metrics_timeseries group by tenant_key, metric_name order by tenant_key, metric_name;
Date: 2026-03-08 17:54:30 Database: zemm_produktiv_8 Application: psql User: deploy Remote: [local] Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
Statement: SELECT * FROM __db_error_logger_smoke_test_missing_table__
Date: 2026-03-08 19:54:48 Database: zemm_produktiv_7 Application: zemm_produktiv_7_localhost_5432 User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
3 4 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count Mar 08 13 2 15 1 19 1 - ERROR: column "target" does not exist
- ERROR: column litters.cage does not exist
- ERROR: column "status" does not exist
Hint: Perhaps you meant to reference the column "tasks.parent" or the column "tasks.agent".
Statement: select 'overdue_tasks', count(*) from tasks where not done and deadline < now() union all select 'overdue_tasks_with_target', count(*) from tasks where not done and deadline < now() and target is not null union all select 'weaning_due', count(*) from litters inner join cages on cages.id = litters.cage inner join licenses on licenses.id = cages.license inner join users on users.id = licenses.user_id inner join species on species.id = litters.species where litters."birthDate" + species."weaningAge"::integer < current_date and litters.weaning is null union all select 'licenses_expired_unnotified', count(*) from licenses where limitation is not null and limitation < current_date and proposed_end >= current_date and coalesce(limitation_notified,false)=false;Date: 2026-03-08 13:22:40 Database: zemm_produktiv_8 Application: psql User: postgres Remote: [local] Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
Statement: select 'overdue_tasks', count(*) from tasks where not done and deadline < now() union all select 'weaning_due', count(*) from litters inner join cages on cages.id = litters.cage inner join licenses on licenses.id = cages.license inner join users on users.id = licenses.user_id inner join species on species.id = litters.species where litters."birthDate" + species."weaningAge"::integer < current_date and litters.weaning is null union all select 'licenses_expired_unnotified', count(*) from licenses where limitation is not null and limitation < current_date and coalesce(limitation_notified,false)=false union all select 'tasks_changes_open', count(*) from tasks_changes where not deleted;
Date: 2026-03-08 13:22:56 Database: zemm_produktiv_8 Application: psql User: postgres Remote: [local] Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
Statement: select count(*) as total_false, count(*) filter (where deadline < now() - interval '7 days') as older_than_7d_false from tasks where not deadline_notified and deadline is not null; select coalesce(status::text,'<null>'), count(*) from tasks where not deadline_notified and deadline is not null and deadline < now() - interval '7 days' group by 1 order by 2 desc;
Date: 2026-03-08 15:04:22 Database: zemm_produktiv_8 Application: psql User: postgres Remote: [local] Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
4 3 FATAL: Peer authentication failed for user "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Mar 08 17 1 19 2 - FATAL: Peer authentication failed for user "bucket_start,"
- FATAL: Peer authentication failed for user "column_name,data_type"
- FATAL: Peer authentication failed for user "column_name,data_type"
Detail: Connection matched file "/etc/postgresql/18/main/pg_hba.conf" line 18: "local all all peer"
Date: 2026-03-08 17:51:52 Database: zemm_produktiv_8 Application: User: bucket_start, Remote: [local] Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
Detail: Connection matched file "/etc/postgresql/18/main/pg_hba.conf" line 18: "local all all peer"
Date: 2026-03-08 19:32:03 Database: zemm_produktiv_7 Application: User: column_name,data_type Remote: [local] Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
Detail: Connection matched file "/etc/postgresql/18/main/pg_hba.conf" line 18: "local all all peer"
Date: 2026-03-08 19:32:03 Database: zemm_produktiv_7 Application: User: column_name,data_type Remote: [local] Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
5 1 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #5
Day Hour Count Mar 08 19 1 - LOG: could not receive data from client: Connection reset by peer
Date: 2026-03-08 19:00:01 Database: zemm_monitoring Application: User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
6 1 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #6
Day Hour Count Mar 08 17 1 - ERROR: syntax error at or near "3"
Statement: select bucket_start::timestamp(0), sum(case when metric_name=http_requests_total then sum_value else 0 end) as req, sum(case when metric_name=http_request_errors_total then sum_value else 0 end) as err from observability.metrics_timeseries where tenant_key=prod and bucket_start >= now() - interval 3 hours group by bucket_start order by bucket_start desc limit 20;
Date: 2026-03-08 17:54:30 Database: zemm_produktiv_8 Application: psql User: deploy Remote: [local] Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv
7 1 ERROR: zero-length delimited identifier at or near """"
Times Reported Most Frequent Error / Event #7
Day Hour Count Mar 08 14 1 - ERROR: zero-length delimited identifier at or near """"
Statement: COPY ( SELECT id, ""fullName"", ""eMail"", active, disablemail FROM users WHERE lower(""eMail"") IN ( 'sawako.fukushima@uni-wuerzburg.de', 'sabrina.schneider@uni-wuerzburg.de', 'patrick.penndorf@uni-wuerzburg.de', 'tommaso.torcellan@uni-wuerzburg.de', 'ana.mansilla-merlano@uni-wuerzburg.de', 'sana.siddig@uni-wuerzburg.de', 'theresa.brand@uni-wuerzburg.de', 'muege.oezkan@uni-wuerzburg.de', 'olga.frank@uni-wuerzburg.de', 'anika.schridde@uni-wuerzburg.de', 'maximilian.englert@stud-mail.uni-wuerzburg.de', 'chloe.fenton@uni-wuerzburg.de', 'andris.avots@uni-wuerzburg.de', 'iris.ramos@uni-wuerzburg.de', 'eliana.ribechini@virchow.uni-wuerzburg.de', 'annika.gerber@stud-mail.uni-wuerzburg.de', 'paulina.cruz-de-casas@uni-wuerzburg.de', 'dehui.chang@uni-wuerzburg.de', 'laura.hannig@.uni-wuerzburg.de', 'reuben.labios@uni-wuerzburg.de', 'christina.bielmeier@uni-wuerzburg.de', 'charly.kusch@uni-wuerzburg.de', 'jessica.pfeiffer@uni-wuerzburg.de', 'konrad.knoepper@uni-wuerzburg.de', 'lennart.ruettger@uni-wuerzburg.de', 'nina.houben@uni-wuerzburg.de' ) ORDER BY lower(""eMail""), id ) TO '/tmp/zemm_produktiv_8-invalid-emails-before-20260308.csv' WITH CSV HEADER;
Date: 2026-03-08 14:06:05 Database: zemm_produktiv_8 Application: psql User: postgres Remote: [local] Log file: /var/log/postgresql/postgresql-2026-03-08_000000.csv