ZEMM PG Report-
Global information
- Generated on Sun Mar 15 06:01:15 2026
- Log file: /var/log/postgresql/postgresql-2026-03-06_225012.csv, ..., /var/log/postgresql/postgresql-2026-03-15_000000.csv
- Parsed 283,826 log entries in 1m14s
- Log start from 2026-03-09 00:00:01 to 2026-03-09 23:59:01
-
Overview
Global Stats
- 47 Number of unique normalized queries
- 17,482 Number of queries
- 8h26m31s Total query duration
- 2026-03-09 00:00:01 First query
- 2026-03-09 23:59:01 Last query
- 14 queries/s at 2026-03-09 09:44:02 Query peak
- 8h26m31s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 8h26m31s Execute total duration
- 50 Number of events
- 17 Number of unique normalized events
- 12 Max number of times the same event was reported
- 0 Number of cancellation
- 112 Total number of automatic vacuums
- 266 Total number of automatic analyzes
- 2 Number temporary file
- 176.73 MiB Max size of temporary file
- 176.73 MiB Average size of temporary file
- 28,651 Total number of sessions
- 9 sessions at 2026-03-09 23:53:01 Session peak
- 58m28s Total duration of sessions
- 122ms Average duration of sessions
- 0 Average queries per session
- 1s60ms Average queries duration per session
- 0ms Average idle time per session
- 28,665 Total number of connections
- 24 connections/s at 2026-03-09 12:57:36 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 14 queries/s Query Peak
- 2026-03-09 09:44:02 Date
SELECT Traffic
Key values
- 2 queries/s Query Peak
- 2026-03-09 11:06:14 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 12 queries/s Query Peak
- 2026-03-09 10:42:01 Date
Queries duration
Key values
- 8h26m31s 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 09 00 720 0ms 0ms 0ms 0ms 0ms 0ms 01 721 0ms 1s94ms 529ms 13s131ms 13s131ms 13s131ms 02 720 1s94ms 1s94ms 1s94ms 13s131ms 13s131ms 13s131ms 03 720 1s94ms 1s94ms 1s94ms 13s131ms 13s131ms 13s131ms 04 720 1s94ms 1s94ms 1s94ms 13s131ms 13s131ms 13s131ms 05 720 1s94ms 1s94ms 1s94ms 13s131ms 13s131ms 13s131ms 06 722 647ms 1s94ms 1s48ms 13s131ms 13s131ms 14s721ms 07 732 620ms 2s186ms 993ms 26s241ms 26s241ms 27s641ms 08 751 546ms 8s563ms 2s598ms 1m42s 1m42s 1m59s 09 736 615ms 2s137ms 1s111ms 25s596ms 25s649ms 27s782ms 10 726 659ms 805ms 775ms 9s664ms 10s300ms 10s796ms 11 744 613ms 27s19ms 1s214ms 9s498ms 11s984ms 6m17s 12 756 551ms 5s813ms 829ms 15s339ms 20s629ms 1m11s 13 740 550ms 2s152ms 710ms 12s719ms 20s925ms 25s825ms 14 740 617ms 3s601ms 1s278ms 43s222ms 43s222ms 46s579ms 15 727 620ms 2s169ms 820ms 26s31ms 26s31ms 28s610ms 16 735 624ms 2s136ms 1s102ms 25s641ms 25s641ms 25s641ms 17 720 2s136ms 2s136ms 2s136ms 25s641ms 25s641ms 25s641ms 18 720 2s136ms 2s136ms 2s136ms 25s641ms 25s641ms 25s641ms 19 724 620ms 2s136ms 1s73ms 25s641ms 25s641ms 28s209ms 20 721 621ms 23s619ms 652ms 7s452ms 7s452ms 31s71ms 21 722 4s738ms 23s619ms 9s197ms 4m43s 4m43s 4m51s 22 720 4s738ms 4s738ms 4s738ms 56s866ms 56s866ms 56s866ms 23 725 538ms 4s738ms 4s489ms 56s866ms 56s866ms 1m3s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 09 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 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 2 0 795ms 0ms 0ms 0ms 07 11 0 718ms 0ms 0ms 2s606ms 08 19 0 2s237ms 0ms 1s287ms 16s436ms 09 12 0 654ms 0ms 0ms 1s402ms 10 2 0 686ms 0ms 0ms 0ms 11 23 0 4s920ms 0ms 1s275ms 50s480ms 12 36 0 894ms 551ms 2s215ms 5s188ms 13 19 0 710ms 0ms 1s332ms 2s585ms 14 19 0 973ms 0ms 2s560ms 3s581ms 15 6 0 702ms 0ms 0ms 1s634ms 16 14 0 647ms 0ms 0ms 2s589ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 4 0 642ms 0ms 0ms 0ms 20 1 0 23s619ms 0ms 0ms 0ms 21 2 0 6s569ms 0ms 0ms 4s738ms 22 0 0 0ms 0ms 0ms 0ms 23 0 5 1s264ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 09 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 1 0 0 1s94ms 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 0 0 0 0ms 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 09 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 0 0.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 09 00 739 0.21/s 01 718 0.20/s 02 715 0.20/s 03 712 0.20/s 04 715 0.20/s 05 757 0.21/s 06 1,106 0.31/s 07 2,227 0.62/s 08 2,681 0.74/s 09 2,049 0.57/s 10 2,066 0.57/s 11 1,901 0.53/s 12 2,805 0.78/s 13 2,296 0.64/s 14 1,304 0.36/s 15 1,267 0.35/s 16 936 0.26/s 17 718 0.20/s 18 499 0.14/s 19 507 0.14/s 20 693 0.19/s 21 595 0.17/s 22 409 0.11/s 23 250 0.07/s Day Hour Count Average Duration Average idle time Mar 09 00 739 66ms 66ms 01 718 63ms 0ms 02 715 57ms 0ms 03 712 52ms 0ms 04 715 49ms 0ms 05 755 48ms 0ms 06 1,106 84ms 0ms 07 2,227 187ms 0ms 08 2,679 137ms 0ms 09 2,051 108ms 0ms 10 2,064 113ms 0ms 11 1,901 225ms 0ms 12 2,805 166ms 0ms 13 2,292 151ms 0ms 14 1,304 113ms 0ms 15 1,267 88ms 0ms 16 934 123ms 0ms 17 718 73ms 0ms 18 499 39ms 0ms 19 507 48ms 0ms 20 693 126ms 0ms 21 595 135ms 0ms 22 405 49ms 0ms 23 250 97ms 0ms -
Connections
Established Connections
Key values
- 24 connections Connection Peak
- 2026-03-09 12:57:36 Date
Connections per database
Key values
- zemm_monitoring Main Database
- 28,665 connections Total
Connections per user
Key values
- labanimal Main User
- 28,665 connections Total
-
Sessions
Simultaneous sessions
Key values
- 9 sessions Session Peak
- 2026-03-09 23:53:01 Date
Histogram of session times
Key values
- 27,739 0-500ms duration
Sessions per database
Key values
- zemm_monitoring Main Database
- 28,651 sessions Total
Sessions per user
Key values
- labanimal Main User
- 28,651 sessions Total
Sessions per host
Key values
- ::1 Main Host
- 28,651 sessions Total
Sessions per application
Key values
- Main Application
- 28,651 sessions Total
Application Count Total Duration Average Duration 21,826 36m10s 99ms _backend_cage_autocomplete_api.php_q_17-004_limit_12_zemm_produ 2 58ms 29ms _backend_cage_autocomplete_api.php_q_17-00_limit_12_zemm_produk 1 30ms 30ms _backend_cage_autocomplete_api.php_q_17-_limit_12_zemm_produkti 1 29ms 29ms _backend_cage_autocomplete_api.php_q_17_limit_12_zemm_produktiv 2 60ms 30ms _backend_cage_autocomplete_api.php_q_1_limit_12_zemm_produktiv_ 2 58ms 29ms _backend_cage_autocomplete_api.php_q_2025_limit_12_zemm_produkt 8 197ms 24ms _backend_cage_autocomplete_api.php_q_55-065_limit_12_zemm_produ 8 226ms 28ms _backend_cage_autocomplete_api.php_q_61-082_limit_12_zemm_produ 2 60ms 30ms _backend_cage_autocomplete_api.php_q_6_limit_12_zemm_produktiv_ 1 39ms 39ms _backend_wean_api.php_litter_id_10130227_zemm_produktiv_7_local 40 5s561ms 139ms _backend_wean_api.php_litter_id_10130236_zemm_produktiv_7_local 40 5s897ms 147ms _backend_wean_api.php_litter_id_10130257_zemm_produktiv_7_local 48 6s822ms 142ms _backend_wean_api.php_litter_id_10131240_zemm_produktiv_8_local 6 826ms 137ms _backend_wean_api.php_litter_id_10131318_zemm_produktiv_8_local 2 286ms 143ms _backend_wean_api.php_litter_id_10131319_zemm_produktiv_8_local 2 276ms 138ms _backend_wean_api.php_litter_id_10131329_zemm_produktiv_8_local 3 415ms 138ms _backend_wean_api.php_litter_id_10131336_zemm_produktiv_8_local 5 686ms 137ms _backend_wean_api.php_litter_id_10131337_zemm_produktiv_8_local 3 410ms 136ms _backend_wean_api.php_litter_id_10131354_zemm_produktiv_8_local 2 277ms 138ms _backend_wean_api.php_litter_id_10131355_zemm_produktiv_8_local 2 278ms 139ms _backend_wean_api.php_litter_id_10131356_zemm_produktiv_8_local 3 416ms 138ms _backend_wean_api.php_litter_id_10131364_zemm_produktiv_8_local 1 140ms 140ms _backend_wean_api.php_litter_id_10131365_zemm_produktiv_8_local 1 138ms 138ms _backend_wean_api.php_litter_id_10131424_zemm_produktiv_8_local 3 416ms 138ms _backend_wean_api.php_litter_id_10131426_zemm_produktiv_8_local 2 276ms 138ms _backend_wean_api.php_litter_id_10131427_zemm_produktiv_8_local 2 277ms 138ms _backend_wean_api.php_litter_id_10131428_zemm_produktiv_8_local 2 268ms 134ms _backend_wean_api.php_litter_id_10131592_zemm_produktiv_7_local 7 980ms 140ms _backend_wean_api.php_litter_id_10131594_zemm_produktiv_7_local 5 694ms 138ms _backend_wean_api.php_litter_id_10131594_zemm_produktiv_8_local 2 269ms 134ms _backend_wean_api.php_litter_id_10131596_zemm_produktiv_8_local 1 139ms 139ms _backend_wean_api.php_litter_id_10131609_zemm_produktiv_8_local 1 138ms 138ms _backend_wean_api.php_litter_id_10131611_zemm_produktiv_8_local 3 413ms 137ms _backend_wean_api.php_zemm_produktiv_7_localhost_5432 1 662ms 662ms _backend_wean_api.php_zemm_produktiv_8_localhost_5432 1 393ms 393ms _desktop__command_tasks_command_tasks_subcommand_open_screen__q 1 65ms 65ms _desktop__zemm_produktiv_7_localhost_5432 18 7s993ms 444ms _desktop__zemm_produktiv_8_localhost_5432 94 9s740ms 103ms _desktop_index.php_cages_empty__25_val4_cages_search_command_ta 2 102ms 51ms _desktop_index.php_cages_name_49-2_2A_cages_empty__25_val4_cage 1 76ms 76ms _desktop_index.php_command_admin_subcommand_init_zemm_produktiv 6 381ms 63ms _desktop_index.php_command_animals_breedings_subcommand_init_ze 6 2s536ms 422ms _desktop_index.php_command_animals_breedings_subcommand_select_ 18 9s372ms 520ms _desktop_index.php_command_animals_create_subcommand_init_zemm_ 9 375ms 41ms _desktop_index.php_command_animals_edit_subcommand_init_id_1022 1 101ms 101ms _desktop_index.php_command_animals_edit_subcommand_init_id_1027 2 208ms 104ms _desktop_index.php_command_animals_edit_subcommand_init_id_1028 1 94ms 94ms _desktop_index.php_command_animals_edit_subcommand_init_id_1029 4 394ms 98ms _desktop_index.php_command_animals_edit_subcommand_init_id_5144 1 83ms 83ms _desktop_index.php_command_animals_edit_subcommand_init_zemm_pr 1 36ms 36ms _desktop_index.php_command_animals_edit_subcommand_link_init_va 24 2s83ms 86ms _desktop_index.php_command_animals_edit_subcommand_m_init_scree 24 2s182ms 90ms _desktop_index.php_command_animals_edit_subcommand_open_zemm_pr 1 33ms 33ms _desktop_index.php_command_animals_litters_edit_subcommand_init 8 747ms 93ms _desktop_index.php_command_animals_litters_edit_subcommand_m_in 40 8s770ms 219ms _desktop_index.php_command_animals_litters_subcommand_init_zemm 17 9s867ms 580ms _desktop_index.php_command_animals_litters_subcommand_select_ze 18 1s447ms 80ms _desktop_index.php_command_animals_subcommand_edit_id_10141201_ 1 47ms 47ms _desktop_index.php_command_animals_subcommand_found_val1_101000 3 949ms 316ms _desktop_index.php_command_animals_subcommand_found_val1_101002 2 96ms 48ms _desktop_index.php_command_animals_subcommand_init_zemm_produkt 66 13s135ms 199ms _desktop_index.php_command_animals_subcommand_open_zemm_produkt 48 5s277ms 109ms _desktop_index.php_command_animals_subcommand_select_zemm_produ 35 8s134ms 232ms _desktop_index.php_command_animals_subcommand_task_status_zemm_ 6 34s129ms 5s688ms _desktop_index.php_command_cages_subcommand_open_zemm_produktiv 1 46ms 46ms _desktop_index.php_command_documents_subcommand_init_zemm_produ 2 90ms 45ms _desktop_index.php_command_facility_subcommand_init_zemm_produk 2 102ms 51ms _desktop_index.php_command_home_subcommand_animals_per_user_zem 3 269ms 89ms _desktop_index.php_command_home_subcommand_init_zemm_produktiv_ 234 29s952ms 128ms _desktop_index.php_command_home_subcommand_task_status_zemm_pro 3 1s504ms 501ms _desktop_index.php_command_login_subcommand_init_zemm_produktiv 1,542 2m57s 115ms _desktop_index.php_command_reports_subcommand_animals_per_room_ 1 104ms 104ms _desktop_index.php_command_reports_subcommand_animals_per_user_ 50 4s544ms 90ms _desktop_index.php_command_reports_subcommand_fates_zemm_produk 33 3s177ms 96ms _desktop_index.php_command_reports_subcommand_init_zemm_produkt 138 21s640ms 156ms _desktop_index.php_command_reports_subcommand_task_status_zemm_ 112 13s367ms 119ms _desktop_index.php_command_tasks_subcommand_create_task_id_47_z 1 58ms 58ms _desktop_index.php_command_tasks_subcommand_edit_id_10126484_ze 8 523ms 65ms _desktop_index.php_command_tasks_subcommand_edit_id_10140950_ze 1 84ms 84ms _desktop_index.php_command_tasks_subcommand_edit_id_10141201_ze 32 2s654ms 82ms _desktop_index.php_command_tasks_subcommand_edit_id_10141268_ze 1 87ms 87ms _desktop_index.php_command_tasks_subcommand_edit_id_10141312_ze 1 77ms 77ms _desktop_index.php_command_tasks_subcommand_edit_id_10141372_ze 1 83ms 83ms _desktop_index.php_command_tasks_subcommand_edit_id_10141440_ze 1 85ms 85ms _desktop_index.php_command_tasks_subcommand_edit_id_10141460_ze 1 82ms 82ms _desktop_index.php_command_tasks_subcommand_edit_id_10141484_ze 1 85ms 85ms _desktop_index.php_command_tasks_subcommand_edit_id_10141514_ze 6 492ms 82ms _desktop_index.php_command_tasks_subcommand_init_search_zemm_pr 17 975ms 57ms _desktop_index.php_command_tasks_subcommand_init_template_zemm_ 1 41ms 41ms _desktop_index.php_command_tasks_subcommand_init_zemm_produktiv 377 53s753ms 142ms _desktop_index.php_command_tasks_subcommand_open_zemm_produktiv 709 3m12s 270ms _desktop_index.php_command_tasks_subcommand_search_zemm_produkt 29 1s785ms 61ms _desktop_index.php_m_action_animals_3Am_delete_val4_animals_lis 1 94ms 94ms _desktop_index.php_m_action_animals_edit_3Alink_init_row_animal 1 94ms 94ms _desktop_index.php_m_action_cages_3Am_delete_command_animals_su 1 52ms 52ms _desktop_index.php_name_Abt_C3_B6ten_20v._20Tieren_20ohne_20Ver 4 209ms 52ms _desktop_index.php_name_Genotypisierungsproben_20genommen_instr 8 454ms 56ms _desktop_index.php_name_Nova_20Tarefa_add_link_animals_task_sta 1 97ms 97ms _desktop_index.php_name_Tiertransport_20durch_20das_20ZEMM_inst 1 42ms 42ms _desktop_index.php_name_Tiertransport_20innerhalb_20W_C3_BCrzbu 2 118ms 59ms _desktop_index.php_name_Verpaarungen_20zur_20Zucht_instructions 2 95ms 47ms _desktop_index.php_search_status_1_no_subtasks_true_command_tas 1 58ms 58ms _desktop_index.php_search_status_2_no_subtasks_true_command_ani 1 43ms 43ms _desktop_index.php_sire_name_72_dam_name_86_sire_id_2025_2F002_ 1 72ms 72ms _desktop_index.php_view_animal_name_on_animal_name__2ACD4-LDL_2 1 249ms 249ms _desktop_index.php_view_animal_name_on_view_animal_id_on_view_b 10 4s644ms 464ms _desktop_index.php_zemm_produktiv_7_localhost_5432 32 14s123ms 441ms _desktop_index.php_zemm_produktiv_8_localhost_5432 2,611 7m53s 181ms backend:zemm_produktiv_7@localhost 1 59ms 59ms backend:zemm_produktiv_8@localhost 54 3s909ms 72ms expire_tasks:zemm_produktiv_8@h2940066.stratoserver.net:5432 1 1s111ms 1s111ms pg_dump 1 12s82ms 12s82ms psql 41 949ms 23ms taskscron:zemm_produktiv_7@zemm.fbiscience.eu 24 1s57ms 44ms taskscron:zemm_produktiv_8@h2940066.stratoserver.net:5432 24 24s953ms 1s39ms zemm_produktiv_7_localhost_5432 20 2m28s 7s436ms -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 29,460 buffers Checkpoint Peak
- 2026-03-09 00:54:25 Date
- 269.972 seconds Highest write time
- 0.161 seconds Sync time
Checkpoints Wal files
Key values
- 4 files Wal files usage Peak
- 2026-03-09 15:39:44 Date
Checkpoints distance
Key values
- 224.90 Mo Distance Peak
- 2026-03-09 01:39:25 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Mar 09 00 31,230 446.65s 0.071s 446.815s 01 20,536 492.548s 0.079s 492.725s 02 2,041 204.713s 0.075s 204.846s 03 2,061 206.711s 0.071s 206.835s 04 1,968 197.427s 0.08s 197.574s 05 2,094 210.01s 0.068s 210.14s 06 15,859 543.809s 0.154s 544.049s 07 5,244 525.518s 0.241s 525.826s 08 6,127 613.804s 0.261s 614.13s 09 4,325 433.552s 0.198s 433.815s 10 6,655 663.191s 0.187s 663.443s 11 4,720 472.87s 0.174s 473.108s 12 8,188 820.168s 0.237s 820.471s 13 36,993 1,296.302s 0.397s 1,296.86s 14 16,853 641.837s 0.17s 642.073s 15 17,386 709.307s 0.166s 709.531s 16 3,020 302.776s 0.124s 302.952s 17 2,233 224.015s 0.102s 224.175s 18 2,005 201.107s 0.064s 201.228s 19 1,860 186.583s 0.064s 186.699s 20 2,464 247.046s 0.099s 247.199s 21 2,523 253.01s 0.074s 253.134s 22 2,541 254.85s 0.073s 254.972s 23 2,205 221.193s 0.076s 221.327s Day Hour Added Removed Recycled Synced files Longest sync Average sync Mar 09 00 0 7 0 276 0.002s 0.011s 01 0 8 0 298 0.004s 0.011s 02 0 1 0 301 0.002s 0.012s 03 0 0 0 311 0.002s 0.012s 04 0 1 0 301 0.002s 0.012s 05 0 1 0 307 0.002s 0.012s 06 0 4 0 837 0.002s 0.012s 07 0 2 0 1,417 0.002s 0.012s 08 0 1 0 1,510 0.002s 0.012s 09 0 1 0 1,141 0.003s 0.012s 10 0 2 0 1,060 0.002s 0.012s 11 0 1 0 968 0.002s 0.012s 12 0 2 0 1,378 0.002s 0.012s 13 0 15 0 1,479 0.048s 0.013s 14 0 1 4 936 0.003s 0.012s 15 0 0 4 942 0.002s 0.012s 16 0 0 1 705 0.002s 0.012s 17 0 0 1 519 0.002s 0.012s 18 0 0 1 283 0.002s 0.012s 19 0 0 0 285 0.002s 0.012s 20 0 0 1 519 0.002s 0.012s 21 0 0 1 342 0.002s 0.012s 22 0 0 1 342 0.002s 0.012s 23 0 0 0 365 0.001s 0.012s Day Hour Count Avg time (sec) Mar 09 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 09 00 10,615.55 kB 11,270.91 kB 01 11,607.73 kB 81,997.27 kB 02 989.33 kB 45,827.67 kB 03 977.08 kB 13,645.00 kB 04 950.17 kB 4,540.00 kB 05 972.42 kB 1,973.58 kB 06 5,831.25 kB 6,047.58 kB 07 2,012.50 kB 31,172.00 kB 08 2,153.50 kB 10,462.92 kB 09 1,667.83 kB 4,196.83 kB 10 2,331.92 kB 4,665.83 kB 11 1,784.67 kB 5,016.83 kB 12 2,902.33 kB 3,856.17 kB 13 19,915.92 kB 61,179.58 kB 14 6,177.17 kB 29,817.00 kB 15 6,343.67 kB 38,123.00 kB 16 1,245.58 kB 20,936.50 kB 17 1,033.75 kB 6,715.00 kB 18 963.33 kB 2,607.83 kB 19 942.25 kB 1,421.50 kB 20 1,078.83 kB 1,197.08 kB 21 1,116.83 kB 1,212.50 kB 22 1,119.92 kB 1,189.75 kB 23 1,043.67 kB 1,202.75 kB -
Temporary Files
Size of temporary files
Key values
- 176.73 MiB Temp Files size Peak
- 2026-03-09 11:26:31 Date
Number of temporary files
Key values
- 1 per second Temp Files Peak
- 2026-03-09 11:26:31 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Mar 09 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 2 353.47 MiB 176.73 MiB 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 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 2 353.47 MiB 176.73 MiB 176.73 MiB 176.73 MiB select distinct * from ( select animals_search_mview.*, b.unbreeding_date, fates.loc as fate_name, 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, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, string_agg(l."application_id" || ? || l."title" || ? || date(lh."timestamp")::varchar, ?) as licensehistory, case when not exists ( select ? from scoresheet_diary sd where sd.animals_id = animals_search_mview.id) then ? else ? end as isscored from animals_search_mview inner join fates on fates.id = animals_search_mview.fate left join strains on strains.name = animals_search_mview.strain left join license_history lh on lh.anid = animals_search_mview.id left join licenses l on l.id = lh.licid left join breedings b on b.id = animals_search_mview.last_mating group by animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data where data.deleted = ? and (is_owner or is_editor or is_tourist) and (data.straindeleted = ? or data.straindeleted is null) order by data.cage_name, data.animal_id, data.name;-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 332) AS is_owner, user_is_tgm (animals_search_mview.editor, 332) AS is_editor, user_is_tgm (animals_search_mview.tourist, 332) AS is_tourist, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, STRING_AGG(l."application_id" || ':' || l."title" || ' - ' || Date(lh."timestamp")::varchar, '; ') AS licensehistory, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview INNER JOIN fates ON fates.id = animals_search_mview.fate LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN licenses l ON l.id = lh.licid left join breedings b ON b.id = animals_search_mview.last_mating GROUP BY animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data WHERE data.deleted = 'f' AND (is_owner OR is_editor OR is_tourist) and (data.straindeleted = 'f' or data.straindeleted is null) ORDER BY data.cage_name, data.animal_id, data.name;
Date: 2026-03-09 11:26:31 Duration: 27s19ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_command_tasks_subcommand_open_zemm_produktiv Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 332) AS is_owner, user_is_tgm (animals_search_mview.editor, 332) AS is_editor, user_is_tgm (animals_search_mview.tourist, 332) AS is_tourist, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, STRING_AGG(l."application_id" || ':' || l."title" || ' - ' || Date(lh."timestamp")::varchar, '; ') AS licensehistory, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview INNER JOIN fates ON fates.id = animals_search_mview.fate LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN licenses l ON l.id = lh.licid left join breedings b ON b.id = animals_search_mview.last_mating GROUP BY animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data WHERE data.deleted = 'f' AND (is_owner OR is_editor OR is_tourist) and (data.straindeleted = 'f' or data.straindeleted is null) ORDER BY data.cage_name, data.animal_id, data.name;
Date: 2026-03-09 11:27:30 Duration: 26s795ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_command_tasks_subcommand_open_zemm_produktiv Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 332) AS is_owner, user_is_tgm (animals_search_mview.editor, 332) AS is_editor, user_is_tgm (animals_search_mview.tourist, 332) AS is_tourist, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, STRING_AGG(l."application_id" || ':' || l."title" || ' - ' || Date(lh."timestamp")::varchar, '; ') AS licensehistory, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview INNER JOIN fates ON fates.id = animals_search_mview.fate LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN licenses l ON l.id = lh.licid left join breedings b ON b.id = animals_search_mview.last_mating GROUP BY animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data WHERE data.deleted = 'f' AND (is_owner OR is_editor OR is_tourist) and (data.straindeleted = 'f' or data.straindeleted is null) ORDER BY data.cage_name, data.animal_id, data.name;
Date: 2026-03-09 11:26:31 Duration: 0ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_command_tasks_subcommand_open_zemm_produktiv
Queries generating the largest temporary files
Rank Size Query 1 176.73 MiB SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 332) AS is_owner, user_is_tgm (animals_search_mview.editor, 332) AS is_editor, user_is_tgm (animals_search_mview.tourist, 332) AS is_tourist, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, STRING_AGG(l."application_id" || ':' || l."title" || ' - ' || Date(lh."timestamp")::varchar, '; ') AS licensehistory, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview INNER JOIN fates ON fates.id = animals_search_mview.fate LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN licenses l ON l.id = lh.licid left join breedings b ON b.id = animals_search_mview.last_mating GROUP BY animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data WHERE data.deleted = 'f' AND (is_owner OR is_editor OR is_tourist) and (data.straindeleted = 'f' or data.straindeleted is null) ORDER BY data.cage_name, data.animal_id, data.name;[Â Date: 2026-03-09 11:26:31 - Database: zemm_produktiv_8 - User: labanimal - Application: _desktop_index.php_command_tasks_subcommand_open_zemm_produktiv ]
2 176.73 MiB SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 332) AS is_owner, user_is_tgm (animals_search_mview.editor, 332) AS is_editor, user_is_tgm (animals_search_mview.tourist, 332) AS is_tourist, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, STRING_AGG(l."application_id" || ':' || l."title" || ' - ' || Date(lh."timestamp")::varchar, '; ') AS licensehistory, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview INNER JOIN fates ON fates.id = animals_search_mview.fate LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN licenses l ON l.id = lh.licid left join breedings b ON b.id = animals_search_mview.last_mating GROUP BY animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data WHERE data.deleted = 'f' AND (is_owner OR is_editor OR is_tourist) and (data.straindeleted = 'f' or data.straindeleted is null) ORDER BY data.cage_name, data.animal_id, data.name;[Â Date: 2026-03-09 11:27:30 - Database: zemm_produktiv_8 - User: labanimal - Application: _desktop_index.php_command_tasks_subcommand_open_zemm_produktiv ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 7.77 sec Highest CPU-cost vacuum
Table observability.db_top_queries
Database zemm_monitoring - 2026-03-09 00:49:26 Date
- 0 sec Highest CPU-cost analyze
Table
Database zemm_monitoring - Date
Average Autovacuum Duration
Key values
- 7.77 sec Highest CPU-cost vacuum
Table observability.db_top_queries
Database zemm_monitoring - 2026-03-09 00:49:26 Date
Analyzes per table
Key values
- pg_catalog.pg_type (78) Main table analyzed (database zemm_produktiv_8)
- 266 analyzes Total
Table Number of analyzes zemm_produktiv_8.pg_catalog.pg_type 78 zemm_produktiv_8.pg_catalog.pg_attribute 58 zemm_produktiv_8.pg_catalog.pg_class 40 zemm_produktiv_8.pg_catalog.pg_depend 38 zemm_produktiv_8.public.breedingsdams 7 zemm_produktiv_8.public.breedingssires 7 zemm_produktiv_8.public.tmptasks 3 zemm_produktiv_8.public.users 3 invdb.pg_catalog.pg_shdepend 3 fbi_ci_db.pg_catalog.pg_shdepend 2 zemm_produktiv_7.pg_catalog.pg_attribute 2 postgres.pg_catalog.pg_shdepend 2 zemm_produktiv_8.public.cages_search_mview 2 fbi_unire.pg_catalog.pg_shdepend 2 zemm_monitoring.observability.metrics_timeseries 2 zemm_produktiv_7.pg_catalog.pg_type 2 zemm_produktiv_8.pg_catalog.pg_namespace 2 labanimal.pg_catalog.pg_shdepend 1 zemm_produktiv_7.pg_catalog.pg_depend 1 zemm_monitoring.observability.db_top_queries 1 zemm_produktiv_7.pg_catalog.pg_namespace 1 zemm_monitoring.observability.app_events 1 zemm_test_2.pg_catalog.pg_shdepend 1 zemm_produktiv_7.pg_catalog.pg_class 1 zemm_monitoring.observability.phpfpm_counters 1 zemm_produktiv_8.public.tasks 1 template1.pg_catalog.pg_shdepend 1 zemm_produktiv_7.pg_catalog.pg_shdepend 1 template0.pg_catalog.pg_shdepend 1 zemm_monitoring.observability.nginx_counters 1 Total 266 Vacuums per table
Key values
- pg_catalog.pg_type (26) Main table vacuumed on database zemm_produktiv_8
- 112 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples zemm_produktiv_8.pg_catalog.pg_type 26 26 0 0 0 0 0 1,342 306 308,241 2 40 zemm_produktiv_8.pg_catalog.pg_attribute 19 19 0 0 0 0 0 2,614 824 553,541 6 10 zemm_produktiv_8.pg_catalog.pg_class 13 13 0 0 0 0 0 1,280 394 471,173 9 159 zemm_monitoring.pg_toast.pg_toast_67431 11 0 0 0 0 0 0 4,267 1,442 3,247,734 1,398 8,388 zemm_produktiv_8.pg_catalog.pg_depend 10 10 0 0 0 0 0 1,279 400 494,903 13 326 zemm_produktiv_8.public.breedingsdams 7 0 0 0 0 0 0 1,379 222 754,614 0 0 zemm_produktiv_8.public.breedingssires 7 0 0 0 0 0 0 1,029 172 559,898 0 0 zemm_produktiv_8.pg_toast.pg_toast_2619 5 5 0 0 0 0 0 942 262 1,403,481 64 224 template1.pg_catalog.pg_shdepend 2 2 0 0 0 0 0 175 53 89,709 0 0 zemm_produktiv_8.pg_catalog.pg_shdepend 2 2 0 0 0 0 0 172 59 103,380 0 0 template0.pg_catalog.pg_shdepend 2 2 0 0 0 0 0 169 42 81,302 12 733 zemm_monitoring.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 91 23 133,092 4 17 zemm_produktiv_8.public.users 1 1 0 0 0 0 0 229 106 256,664 46 281 zemm_produktiv_7.pg_catalog.pg_attribute 1 1 0 0 0 0 0 128 65 93,476 0 0 zemm_produktiv_8.public.tasks 1 1 0 0 0 0 0 44,240 3 3,354,281 0 0 zemm_produktiv_8.public.tmptasks 1 1 0 0 0 0 0 68 27 25,021 0 0 zemm_produktiv_8.pg_catalog.pg_statistic 1 1 0 0 0 0 0 179 75 222,184 33 205 zemm_monitoring.observability.db_top_queries 1 0 0 0 0 0 0 41,760 29,295 108,069,158 6,188 64,762 zemm_produktiv_7.pg_catalog.pg_statistic 1 1 0 0 0 0 0 124 52 182,261 18 135 Total 112 86 0 0 0 0 0 101,467 33,822 120,404,113 7,793 75,280 Vacuum throughput per table
Key values
- observability.db_top_queries (7.77) Max CPU elapsed for vacuum on database zemm_monitoring
- observability.db_top_queries (1.764 ms) Max I/O read time for vacuum on database zemm_monitoring
- public.breedingssires (0.152 ms) Max I/O write time for vacuum on database zemm_monitoring
I/O timing (ms) CPU (s) Table read write elapsed zemm_produktiv_8.pg_catalog.pg_type 0 0 0 zemm_produktiv_8.pg_catalog.pg_attribute 0 0 0.15 zemm_produktiv_8.pg_catalog.pg_class 0 0 0 zemm_monitoring.pg_toast.pg_toast_67431 0 0 0.32 zemm_produktiv_8.pg_catalog.pg_depend 0 0 0.09 zemm_produktiv_8.public.breedingsdams 0 0.107 0 zemm_produktiv_8.public.breedingssires 0 0.152 0 zemm_produktiv_8.pg_toast.pg_toast_2619 0 0 0.05 template1.pg_catalog.pg_shdepend 0 0 0 zemm_produktiv_8.pg_catalog.pg_shdepend 0 0 0.01 template0.pg_catalog.pg_shdepend 0 0 0 zemm_monitoring.pg_toast.pg_toast_2619 0 0 0.01 zemm_produktiv_8.public.users 0 0 0.02 zemm_produktiv_7.pg_catalog.pg_attribute 0 0 0.01 zemm_produktiv_8.public.tasks 0 0 0.59 zemm_produktiv_8.public.tmptasks 0.073 0 0.01 zemm_produktiv_8.pg_catalog.pg_statistic 0 0 0.02 zemm_monitoring.observability.db_top_queries 1.764 0.049 7.77 zemm_produktiv_7.pg_catalog.pg_statistic 0 0 0.01 Total 1.837 0.308 9.06 Tuples removed per table
Key values
- public.tasks (52990) Main table with removed tuples on database zemm_produktiv_8
- 91575 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain zemm_produktiv_8.public.tasks 1 1 52,990 56,068 0 0 16,386 zemm_produktiv_8.pg_catalog.pg_attribute 19 19 19,584 107,011 0 0 3,496 zemm_produktiv_8.pg_catalog.pg_depend 10 10 8,679 41,710 0 0 550 zemm_produktiv_8.pg_catalog.pg_type 26 26 5,188 21,606 0 0 806 zemm_produktiv_8.pg_catalog.pg_class 13 13 2,024 11,622 0 0 546 zemm_produktiv_8.pg_catalog.pg_shdepend 2 2 705 7,682 0 0 76 template1.pg_catalog.pg_shdepend 2 2 696 7,682 0 0 76 template0.pg_catalog.pg_shdepend 2 2 594 7,682 0 0 76 zemm_produktiv_8.pg_toast.pg_toast_2619 5 5 539 1,423 0 0 530 zemm_produktiv_8.pg_catalog.pg_statistic 1 1 166 1,271 0 0 144 zemm_produktiv_8.public.users 1 1 138 740 0 0 108 zemm_produktiv_7.pg_catalog.pg_attribute 1 1 94 6,420 0 0 121 zemm_produktiv_8.public.tmptasks 1 1 64 828 0 15 99 zemm_produktiv_7.pg_catalog.pg_statistic 1 1 62 1,062 0 0 95 zemm_monitoring.pg_toast.pg_toast_2619 1 1 52 64 0 4 25 zemm_monitoring.observability.db_top_queries 1 0 0 2,112,774 0 0 211,157 zemm_produktiv_8.public.breedingsdams 7 0 0 211,250 0 0 1,351 zemm_monitoring.pg_toast.pg_toast_67431 11 0 0 765,738 0 0 128,129 zemm_produktiv_8.public.breedingssires 7 0 0 156,294 0 0 1,001 Total 112 86 91,575 3,518,927 0 19 364,772 Pages removed per table
Key values
- public.tmptasks (15) Main table with removed pages on database zemm_produktiv_8
- 19 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed zemm_produktiv_8.public.tmptasks 1 1 64 15 zemm_monitoring.pg_toast.pg_toast_2619 1 1 52 4 zemm_produktiv_8.pg_toast.pg_toast_2619 5 5 539 0 zemm_produktiv_8.pg_catalog.pg_class 13 13 2024 0 template1.pg_catalog.pg_shdepend 2 2 696 0 zemm_produktiv_8.public.users 1 1 138 0 zemm_produktiv_7.pg_catalog.pg_attribute 1 1 94 0 zemm_produktiv_8.pg_catalog.pg_type 26 26 5188 0 zemm_produktiv_8.public.tasks 1 1 52990 0 zemm_produktiv_8.pg_catalog.pg_statistic 1 1 166 0 zemm_monitoring.observability.db_top_queries 1 0 0 0 zemm_produktiv_8.public.breedingsdams 7 0 0 0 zemm_produktiv_7.pg_catalog.pg_statistic 1 1 62 0 zemm_produktiv_8.pg_catalog.pg_depend 10 10 8679 0 zemm_produktiv_8.pg_catalog.pg_shdepend 2 2 705 0 zemm_monitoring.pg_toast.pg_toast_67431 11 0 0 0 zemm_produktiv_8.pg_catalog.pg_attribute 19 19 19584 0 template0.pg_catalog.pg_shdepend 2 2 594 0 zemm_produktiv_8.public.breedingssires 7 0 0 0 Total 112 86 91,575 19 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Mar 09 00 1 0 01 2 1 02 0 0 03 1 0 04 0 0 05 1 0 06 6 14 07 8 19 08 13 40 09 4 17 10 8 22 11 12 27 12 11 34 13 20 43 14 11 21 15 6 15 16 5 7 17 0 3 18 1 0 19 0 0 20 1 2 21 0 1 22 1 0 23 0 0 - 7.77 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
- 170 Total read queries
- 17,312 Total write queries
Queries by database
Key values
- zemm_monitoring Main database
- 17,280 Requests
- 8h20m56s (zemm_monitoring)
- Main time consuming database
Queries by user
Key values
- labanimal Main user
- 52,911 Requests
User Request type Count Duration labanimal Total 52,911 1d5h49m26s cte 44 53s484ms ddl 52,680 1d5h40m30s others 4 3s68ms select 179 7m55s update 2 2s685ms postgres Total 3,536 1h1m58s copy from 19 54s373ms copy to 75 2m43s cte 5 10s291ms ddl 2,728 45m51s others 679 11m32s update 1 599ms Duration by user
Key values
- 1d5h49m26s (labanimal) Main time consuming user
User Request type Count Duration labanimal Total 52,911 1d5h49m26s cte 44 53s484ms ddl 52,680 1d5h40m30s others 4 3s68ms select 179 7m55s update 2 2s685ms postgres Total 3,536 1h1m58s copy from 19 54s373ms copy to 75 2m43s cte 5 10s291ms ddl 2,728 45m51s others 679 11m32s update 1 599ms Queries by host
Key values
- unknown Main host
- 52,907 Requests
- 1d5h46m24s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 17,280 Requests
- 8h20m56s (unknown)
- Main time consuming application
Application Request type Count Duration _desktop_index.php_command_animals_breedings_subcommand_init_ze Total 1 2s131ms cte 1 2s131ms _desktop_index.php_command_animals_breedings_subcommand_select_ Total 9 7s144ms cte 9 7s144ms _desktop_index.php_command_animals_litters_subcommand_init_zemm Total 4 8s509ms cte 4 8s509ms _desktop_index.php_command_animals_subcommand_task_status_zemm_ Total 4 32s955ms select 4 32s955ms _desktop_index.php_command_home_subcommand_init_zemm_produktiv_ Total 2 1s275ms select 2 1s275ms _desktop_index.php_command_home_subcommand_task_status_zemm_pro Total 2 1s287ms select 2 1s287ms _desktop_index.php_command_login_subcommand_init_zemm_produktiv Total 36 26s996ms cte 2 4s338ms select 34 22s658ms _desktop_index.php_command_reports_subcommand_init_zemm_produkt Total 10 6s499ms select 10 6s499ms _desktop_index.php_command_reports_subcommand_task_status_zemm_ Total 1 2s137ms cte 1 2s137ms _desktop_index.php_command_tasks_subcommand_init_zemm_produktiv Total 1 2s133ms cte 1 2s133ms _desktop_index.php_command_tasks_subcommand_open_zemm_produktiv Total 11 1m45s select 11 1m45s _desktop_index.php_zemm_produktiv_8_localhost_5432 Total 111 2m8s cte 4 8s30ms select 107 2m expire_tasks:zemm_produktiv_8@h2940066.stratoserver.net:5432 Total 1 1s94ms update 1 1s94ms pg_dump Total 5 6s324ms copy to 5 6s324ms psql Total 4 2s353ms ddl 4 2s353ms unknown Total 17,280 8h20m56s ddl 17,280 8h20m56s Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-03-09 08:54:05 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 160 500-1000ms duration
Slowest individual queries
Rank Duration Query 1 27s19ms SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 332) AS is_owner, user_is_tgm (animals_search_mview.editor, 332) AS is_editor, user_is_tgm (animals_search_mview.tourist, 332) AS is_tourist, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, STRING_AGG(l."application_id" || ':' || l."title" || ' - ' || Date(lh."timestamp")::varchar, '; ') AS licensehistory, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview INNER JOIN fates ON fates.id = animals_search_mview.fate LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN licenses l ON l.id = lh.licid left join breedings b ON b.id = animals_search_mview.last_mating GROUP BY animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data WHERE data.deleted = 'f' AND (is_owner OR is_editor OR is_tourist) and (data.straindeleted = 'f' or data.straindeleted is null) ORDER BY data.cage_name, data.animal_id, data.name;[ Date: 2026-03-09 11:26:31 - Database: zemm_produktiv_8 - User: labanimal - Application: _desktop_index.php_command_tasks_subcommand_open_zemm_produktiv ]
2 27s19ms CREATE SCHEMA IF NOT EXISTS observability;[ Date: 2026-03-09 11:27:01 - Database: zemm_monitoring - User: labanimal ]
3 27s19ms 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-09 11:27:01 - Database: zemm_monitoring - User: labanimal ]
4 27s19ms CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);[ Date: 2026-03-09 11:27:01 - Database: zemm_monitoring - User: labanimal ]
5 27s19ms CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);[ Date: 2026-03-09 11:27:01 - Database: zemm_monitoring - User: labanimal ]
6 27s19ms 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-09 11:27:01 - Database: zemm_monitoring - User: labanimal ]
7 27s19ms CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);[ Date: 2026-03-09 11:27:01 - Database: zemm_monitoring - User: labanimal ]
8 27s19ms CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);[ Date: 2026-03-09 11:27:01 - Database: zemm_monitoring - User: labanimal ]
9 27s19ms 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-09 11:27:01 - Database: zemm_monitoring - User: labanimal ]
10 27s19ms CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);[ Date: 2026-03-09 11:27:01 - Database: zemm_monitoring - User: labanimal ]
11 27s19ms 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-09 11:27:01 - Database: zemm_monitoring - User: labanimal ]
12 27s19ms 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-09 11:27:01 - Database: zemm_monitoring - User: labanimal ]
13 27s19ms 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-09 11:27:01 - Database: zemm_monitoring - User: labanimal ]
14 26s795ms SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 332) AS is_owner, user_is_tgm (animals_search_mview.editor, 332) AS is_editor, user_is_tgm (animals_search_mview.tourist, 332) AS is_tourist, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, STRING_AGG(l."application_id" || ':' || l."title" || ' - ' || Date(lh."timestamp")::varchar, '; ') AS licensehistory, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview INNER JOIN fates ON fates.id = animals_search_mview.fate LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN licenses l ON l.id = lh.licid left join breedings b ON b.id = animals_search_mview.last_mating GROUP BY animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data WHERE data.deleted = 'f' AND (is_owner OR is_editor OR is_tourist) and (data.straindeleted = 'f' or data.straindeleted is null) ORDER BY data.cage_name, data.animal_id, data.name;[ Date: 2026-03-09 11:27:30 - Database: zemm_produktiv_8 - User: labanimal - Application: _desktop_index.php_command_tasks_subcommand_open_zemm_produktiv ]
15 23s694ms 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, 332) AS is_owner, user_is_tgm (animals_search_mview.editor, 332) AS is_editor, user_is_tgm (animals_search_mview.tourist, 332) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview 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 deleted = 'f' AND (is_owner OR is_editor OR is_tourist);[ Date: 2026-03-09 11:27:03 - Database: zemm_produktiv_8 - User: labanimal - Application: _desktop_index.php_command_tasks_subcommand_open_zemm_produktiv ]
16 23s619ms 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, 1) AS is_owner, user_is_tgm (animals_search_mview.editor, 1) AS is_editor, user_is_tgm (animals_search_mview.tourist, 1) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview 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 species = 1 AND deleted = 'f' AND (is_owner OR is_editor OR is_tourist);[ Date: 2026-03-09 20:59:13 - Database: zemm_produktiv_8 - User: labanimal - Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 ]
17 23s619ms CREATE SCHEMA IF NOT EXISTS observability;[ Date: 2026-03-09 21:00:01 - Database: zemm_monitoring - User: labanimal ]
18 23s619ms 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-09 21:00:01 - Database: zemm_monitoring - User: labanimal ]
19 23s619ms CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);[ Date: 2026-03-09 21:00:01 - Database: zemm_monitoring - User: labanimal ]
20 23s619ms CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);[ Date: 2026-03-09 21:00:01 - Database: zemm_monitoring - User: labanimal ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 41m44s 1,440 546ms 27s19ms 1s739ms 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 #1
Day Hour Count Duration Avg duration Mar 09 00 60 0ms 0ms 01 60 31s733ms 528ms 02 60 1m5s 1s94ms 03 60 1m5s 1s94ms 04 60 1m5s 1s94ms 05 60 1m5s 1s94ms 06 60 1m2s 1s49ms 07 60 59s763ms 996ms 08 60 2m37s 2s628ms 09 60 1m7s 1s116ms 10 60 46s552ms 775ms 11 60 1m5s 1s97ms 12 60 49s549ms 825ms 13 60 42s479ms 707ms 14 60 1m17s 1s286ms 15 60 49s171ms 819ms 16 60 1m6s 1s109ms 17 60 2m8s 2s136ms 18 60 2m8s 2s136ms 19 60 1m4s 1s75ms 20 60 37s261ms 621ms 21 60 9m12s 9s205ms 22 60 4m44s 4s738ms 23 60 4m30s 4s511ms [ User: labanimal - Total duration: 41m44s - 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-09 11:27:01 Duration: 27s19ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_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-09 21:13:02 Duration: 23s619ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_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-09 08:26:01 Duration: 8s563ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
2 41m44s 1,440 546ms 27s19ms 1s739ms 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 #2
Day Hour Count Duration Avg duration Mar 09 00 60 0ms 0ms 01 60 31s733ms 528ms 02 60 1m5s 1s94ms 03 60 1m5s 1s94ms 04 60 1m5s 1s94ms 05 60 1m5s 1s94ms 06 60 1m2s 1s49ms 07 60 59s763ms 996ms 08 60 2m37s 2s628ms 09 60 1m7s 1s116ms 10 60 46s552ms 775ms 11 60 1m5s 1s97ms 12 60 49s549ms 825ms 13 60 42s479ms 707ms 14 60 1m17s 1s286ms 15 60 49s171ms 819ms 16 60 1m6s 1s109ms 17 60 2m8s 2s136ms 18 60 2m8s 2s136ms 19 60 1m4s 1s75ms 20 60 37s261ms 621ms 21 60 9m12s 9s205ms 22 60 4m44s 4s738ms 23 60 4m30s 4s511ms [ User: labanimal - Total duration: 41m44s - 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-09 11:27:01 Duration: 27s19ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_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-09 21:13:02 Duration: 23s619ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_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-09 08:26:01 Duration: 8s563ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
3 41m44s 1,440 546ms 27s19ms 1s739ms create index if not exists idx_app_events_type on observability.app_events (event_type);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 09 00 60 0ms 0ms 01 60 31s733ms 528ms 02 60 1m5s 1s94ms 03 60 1m5s 1s94ms 04 60 1m5s 1s94ms 05 60 1m5s 1s94ms 06 60 1m2s 1s49ms 07 60 59s763ms 996ms 08 60 2m37s 2s628ms 09 60 1m7s 1s116ms 10 60 46s552ms 775ms 11 60 1m5s 1s97ms 12 60 49s549ms 825ms 13 60 42s479ms 707ms 14 60 1m17s 1s286ms 15 60 49s171ms 819ms 16 60 1m6s 1s109ms 17 60 2m8s 2s136ms 18 60 2m8s 2s136ms 19 60 1m4s 1s75ms 20 60 37s261ms 621ms 21 60 9m12s 9s205ms 22 60 4m44s 4s738ms 23 60 4m30s 4s511ms [ User: labanimal - Total duration: 41m44s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-09 11:27:01 Duration: 27s19ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-09 21:13:02 Duration: 23s619ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-09 08:26:01 Duration: 8s563ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
4 41m44s 1,440 546ms 27s19ms 1s739ms create index if not exists idx_metrics_timeseries_bucket on observability.metrics_timeseries (bucket_start);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 09 00 60 0ms 0ms 01 60 31s733ms 528ms 02 60 1m5s 1s94ms 03 60 1m5s 1s94ms 04 60 1m5s 1s94ms 05 60 1m5s 1s94ms 06 60 1m2s 1s49ms 07 60 59s763ms 996ms 08 60 2m37s 2s628ms 09 60 1m7s 1s116ms 10 60 46s552ms 775ms 11 60 1m5s 1s97ms 12 60 49s549ms 825ms 13 60 42s479ms 707ms 14 60 1m17s 1s286ms 15 60 49s171ms 819ms 16 60 1m6s 1s109ms 17 60 2m8s 2s136ms 18 60 2m8s 2s136ms 19 60 1m4s 1s75ms 20 60 37s261ms 621ms 21 60 9m12s 9s205ms 22 60 4m44s 4s738ms 23 60 4m30s 4s511ms [ User: labanimal - Total duration: 41m44s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-09 11:27:01 Duration: 27s19ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-09 21:13:02 Duration: 23s619ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-09 08:26:01 Duration: 8s563ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
5 41m44s 1,440 546ms 27s19ms 1s739ms 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 #5
Day Hour Count Duration Avg duration Mar 09 00 60 0ms 0ms 01 60 31s733ms 528ms 02 60 1m5s 1s94ms 03 60 1m5s 1s94ms 04 60 1m5s 1s94ms 05 60 1m5s 1s94ms 06 60 1m2s 1s49ms 07 60 59s763ms 996ms 08 60 2m37s 2s628ms 09 60 1m7s 1s116ms 10 60 46s552ms 775ms 11 60 1m5s 1s97ms 12 60 49s549ms 825ms 13 60 42s479ms 707ms 14 60 1m17s 1s286ms 15 60 49s171ms 819ms 16 60 1m6s 1s109ms 17 60 2m8s 2s136ms 18 60 2m8s 2s136ms 19 60 1m4s 1s75ms 20 60 37s261ms 621ms 21 60 9m12s 9s205ms 22 60 4m44s 4s738ms 23 60 4m30s 4s511ms [ User: labanimal - Total duration: 41m44s - 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-09 11:27:01 Duration: 27s19ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_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-09 21:13:02 Duration: 23s619ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_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-09 08:26:01 Duration: 8s563ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
6 41m44s 1,440 546ms 27s19ms 1s739ms create schema if not exists observability;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Mar 09 00 60 0ms 0ms 01 60 31s733ms 528ms 02 60 1m5s 1s94ms 03 60 1m5s 1s94ms 04 60 1m5s 1s94ms 05 60 1m5s 1s94ms 06 60 1m2s 1s49ms 07 60 59s763ms 996ms 08 60 2m37s 2s628ms 09 60 1m7s 1s116ms 10 60 46s552ms 775ms 11 60 1m5s 1s97ms 12 60 49s549ms 825ms 13 60 42s479ms 707ms 14 60 1m17s 1s286ms 15 60 49s171ms 819ms 16 60 1m6s 1s109ms 17 60 2m8s 2s136ms 18 60 2m8s 2s136ms 19 60 1m4s 1s75ms 20 60 37s261ms 621ms 21 60 9m12s 9s205ms 22 60 4m44s 4s738ms 23 60 4m30s 4s511ms [ User: labanimal - Total duration: 41m44s - Times executed: 1349 ]
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-09 11:27:01 Duration: 27s19ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-09 21:13:02 Duration: 23s619ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-09 08:26:01 Duration: 8s563ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
7 41m44s 1,440 546ms 27s19ms 1s739ms 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 #7
Day Hour Count Duration Avg duration Mar 09 00 60 0ms 0ms 01 60 31s733ms 528ms 02 60 1m5s 1s94ms 03 60 1m5s 1s94ms 04 60 1m5s 1s94ms 05 60 1m5s 1s94ms 06 60 1m2s 1s49ms 07 60 59s763ms 996ms 08 60 2m37s 2s628ms 09 60 1m7s 1s116ms 10 60 46s552ms 775ms 11 60 1m5s 1s97ms 12 60 49s549ms 825ms 13 60 42s479ms 707ms 14 60 1m17s 1s286ms 15 60 49s171ms 819ms 16 60 1m6s 1s109ms 17 60 2m8s 2s136ms 18 60 2m8s 2s136ms 19 60 1m4s 1s75ms 20 60 37s261ms 621ms 21 60 9m12s 9s205ms 22 60 4m44s 4s738ms 23 60 4m30s 4s511ms [ User: labanimal - Total duration: 41m44s - 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-09 11:27:01 Duration: 27s19ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_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-09 21:13:02 Duration: 23s619ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_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-09 08:26:01 Duration: 8s563ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
8 41m44s 1,440 546ms 27s19ms 1s739ms create index if not exists idx_metrics_timeseries_metric on observability.metrics_timeseries (metric_name);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Mar 09 00 60 0ms 0ms 01 60 31s733ms 528ms 02 60 1m5s 1s94ms 03 60 1m5s 1s94ms 04 60 1m5s 1s94ms 05 60 1m5s 1s94ms 06 60 1m2s 1s49ms 07 60 59s763ms 996ms 08 60 2m37s 2s628ms 09 60 1m7s 1s116ms 10 60 46s552ms 775ms 11 60 1m5s 1s97ms 12 60 49s549ms 825ms 13 60 42s479ms 707ms 14 60 1m17s 1s286ms 15 60 49s171ms 819ms 16 60 1m6s 1s109ms 17 60 2m8s 2s136ms 18 60 2m8s 2s136ms 19 60 1m4s 1s75ms 20 60 37s261ms 621ms 21 60 9m12s 9s205ms 22 60 4m44s 4s738ms 23 60 4m30s 4s511ms [ User: labanimal - Total duration: 41m44s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-09 11:27:01 Duration: 27s19ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-09 21:13:02 Duration: 23s619ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-09 08:26:01 Duration: 8s563ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
9 41m44s 1,440 546ms 27s19ms 1s739ms 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 #9
Day Hour Count Duration Avg duration Mar 09 00 60 0ms 0ms 01 60 31s733ms 528ms 02 60 1m5s 1s94ms 03 60 1m5s 1s94ms 04 60 1m5s 1s94ms 05 60 1m5s 1s94ms 06 60 1m2s 1s49ms 07 60 59s763ms 996ms 08 60 2m37s 2s628ms 09 60 1m7s 1s116ms 10 60 46s552ms 775ms 11 60 1m5s 1s97ms 12 60 49s549ms 825ms 13 60 42s479ms 707ms 14 60 1m17s 1s286ms 15 60 49s171ms 819ms 16 60 1m6s 1s109ms 17 60 2m8s 2s136ms 18 60 2m8s 2s136ms 19 60 1m4s 1s75ms 20 60 37s261ms 621ms 21 60 9m12s 9s205ms 22 60 4m44s 4s738ms 23 60 4m30s 4s511ms [ User: labanimal - Total duration: 41m44s - 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-09 11:27:01 Duration: 27s19ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_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-09 21:13:02 Duration: 23s619ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_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-09 08:26:01 Duration: 8s563ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
10 41m44s 1,440 546ms 27s19ms 1s739ms create index if not exists idx_app_events_tenant on observability.app_events (tenant_key, occurred_at desc);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Mar 09 00 60 0ms 0ms 01 60 31s733ms 528ms 02 60 1m5s 1s94ms 03 60 1m5s 1s94ms 04 60 1m5s 1s94ms 05 60 1m5s 1s94ms 06 60 1m2s 1s49ms 07 60 59s763ms 996ms 08 60 2m37s 2s628ms 09 60 1m7s 1s116ms 10 60 46s552ms 775ms 11 60 1m5s 1s97ms 12 60 49s549ms 825ms 13 60 42s479ms 707ms 14 60 1m17s 1s286ms 15 60 49s171ms 819ms 16 60 1m6s 1s109ms 17 60 2m8s 2s136ms 18 60 2m8s 2s136ms 19 60 1m4s 1s75ms 20 60 37s261ms 621ms 21 60 9m12s 9s205ms 22 60 4m44s 4s738ms 23 60 4m30s 4s511ms [ User: labanimal - Total duration: 41m44s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-09 11:27:01 Duration: 27s19ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-09 21:13:02 Duration: 23s619ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-09 08:26:01 Duration: 8s563ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
11 41m44s 1,440 546ms 27s19ms 1s739ms 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 #11
Day Hour Count Duration Avg duration Mar 09 00 60 0ms 0ms 01 60 31s733ms 528ms 02 60 1m5s 1s94ms 03 60 1m5s 1s94ms 04 60 1m5s 1s94ms 05 60 1m5s 1s94ms 06 60 1m2s 1s49ms 07 60 59s763ms 996ms 08 60 2m37s 2s628ms 09 60 1m7s 1s116ms 10 60 46s552ms 775ms 11 60 1m5s 1s97ms 12 60 49s549ms 825ms 13 60 42s479ms 707ms 14 60 1m17s 1s286ms 15 60 49s171ms 819ms 16 60 1m6s 1s109ms 17 60 2m8s 2s136ms 18 60 2m8s 2s136ms 19 60 1m4s 1s75ms 20 60 37s261ms 621ms 21 60 9m12s 9s205ms 22 60 4m44s 4s738ms 23 60 4m30s 4s511ms [ User: labanimal - Total duration: 41m44s - 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-09 11:27:01 Duration: 27s19ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_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-09 21:13:02 Duration: 23s619ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_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-09 08:26:01 Duration: 8s563ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
12 41m44s 1,440 546ms 27s19ms 1s739ms 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 09 00 60 0ms 0ms 01 60 31s733ms 528ms 02 60 1m5s 1s94ms 03 60 1m5s 1s94ms 04 60 1m5s 1s94ms 05 60 1m5s 1s94ms 06 60 1m2s 1s49ms 07 60 59s763ms 996ms 08 60 2m37s 2s628ms 09 60 1m7s 1s116ms 10 60 46s552ms 775ms 11 60 1m5s 1s97ms 12 60 49s549ms 825ms 13 60 42s479ms 707ms 14 60 1m17s 1s286ms 15 60 49s171ms 819ms 16 60 1m6s 1s109ms 17 60 2m8s 2s136ms 18 60 2m8s 2s136ms 19 60 1m4s 1s75ms 20 60 37s261ms 621ms 21 60 9m12s 9s205ms 22 60 4m44s 4s738ms 23 60 4m30s 4s511ms [ User: labanimal - Total duration: 41m44s - 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-09 11:27:01 Duration: 27s19ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_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-09 21:13:02 Duration: 23s619ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_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-09 08:26:01 Duration: 8s563ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
13 54s385ms 60 655ms 7s954ms 906ms 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 not exists ( select ? from scoresheet_diary sd where sd.animals_id = animals_search_mview.id) 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 #13
Day Hour Count Duration Avg duration Mar 09 07 5 3s365ms 673ms 08 7 19s152ms 2s736ms 09 3 1s973ms 657ms 11 9 5s949ms 661ms 12 13 8s638ms 664ms 13 4 2s654ms 663ms 14 8 5s324ms 665ms 15 2 1s331ms 665ms 16 7 4s668ms 666ms 19 2 1s327ms 663ms [ User: labanimal - Total duration: 54s385ms - Times executed: 60 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 25s267ms - Times executed: 38 ]
[ Application: _desktop_index.php_command_animals_subcommand_task_status_zemm_ - Total duration: 15s855ms - Times executed: 2 ]
[ Application: _desktop_index.php_command_login_subcommand_init_zemm_produktiv - Total duration: 7s257ms - Times executed: 11 ]
[ Application: _desktop_index.php_command_reports_subcommand_init_zemm_produkt - Total duration: 3s365ms - Times executed: 5 ]
[ Application: _desktop_index.php_command_tasks_subcommand_open_zemm_produktiv - Total duration: 1s325ms - Times executed: 2 ]
[ Application: _desktop_index.php_command_home_subcommand_task_status_zemm_pro - Total duration: 659ms - Times executed: 1 ]
[ Application: _desktop_index.php_command_home_subcommand_init_zemm_produktiv_ - Total duration: 656ms - 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, 10100113) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100113) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100113) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview 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 = 6 AND alive = 't' AND deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-03-09 08:25:47 Duration: 7s954ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_command_animals_subcommand_task_status_zemm_ Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
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, 10100113) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100113) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100113) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview 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 = 6 AND alive = 't' AND deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-03-09 08:26:03 Duration: 7s901ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_command_animals_subcommand_task_status_zemm_ Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
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, 540) AS is_owner, user_is_tgm (animals_search_mview.editor, 540) AS is_editor, user_is_tgm (animals_search_mview.tourist, 540) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview 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-09 14:03:39 Duration: 685ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
14 53s815ms 2 26s795ms 27s19ms 26s907ms select distinct * from ( select animals_search_mview.*, b.unbreeding_date, fates.loc as fate_name, 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, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, string_agg(l."application_id" || ? || l."title" || ? || date(lh."timestamp")::varchar, ?) as licensehistory, case when not exists ( select ? from scoresheet_diary sd where sd.animals_id = animals_search_mview.id) then ? else ? end as isscored from animals_search_mview inner join fates on fates.id = animals_search_mview.fate left join strains on strains.name = animals_search_mview.strain left join license_history lh on lh.anid = animals_search_mview.id left join licenses l on l.id = lh.licid left join breedings b on b.id = animals_search_mview.last_mating group by animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data where data.deleted = ? and (is_owner or is_editor or is_tourist) and (data.straindeleted = ? or data.straindeleted is null) order by data.cage_name, data.animal_id, data.name;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Mar 09 11 2 53s815ms 26s907ms [ User: labanimal - Total duration: 53s815ms - Times executed: 2 ]
[ Application: _desktop_index.php_command_tasks_subcommand_open_zemm_produktiv - Total duration: 53s815ms - Times executed: 2 ]
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 332) AS is_owner, user_is_tgm (animals_search_mview.editor, 332) AS is_editor, user_is_tgm (animals_search_mview.tourist, 332) AS is_tourist, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, STRING_AGG(l."application_id" || ':' || l."title" || ' - ' || Date(lh."timestamp")::varchar, '; ') AS licensehistory, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview INNER JOIN fates ON fates.id = animals_search_mview.fate LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN licenses l ON l.id = lh.licid left join breedings b ON b.id = animals_search_mview.last_mating GROUP BY animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data WHERE data.deleted = 'f' AND (is_owner OR is_editor OR is_tourist) and (data.straindeleted = 'f' or data.straindeleted is null) ORDER BY data.cage_name, data.animal_id, data.name;
Date: 2026-03-09 11:26:31 Duration: 27s19ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_command_tasks_subcommand_open_zemm_produktiv Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 332) AS is_owner, user_is_tgm (animals_search_mview.editor, 332) AS is_editor, user_is_tgm (animals_search_mview.tourist, 332) AS is_tourist, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, STRING_AGG(l."application_id" || ':' || l."title" || ' - ' || Date(lh."timestamp")::varchar, '; ') AS licensehistory, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview INNER JOIN fates ON fates.id = animals_search_mview.fate LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN licenses l ON l.id = lh.licid left join breedings b ON b.id = animals_search_mview.last_mating GROUP BY animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data WHERE data.deleted = 'f' AND (is_owner OR is_editor OR is_tourist) and (data.straindeleted = 'f' or data.straindeleted is null) ORDER BY data.cage_name, data.animal_id, data.name;
Date: 2026-03-09 11:27:30 Duration: 26s795ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_command_tasks_subcommand_open_zemm_produktiv Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 332) AS is_owner, user_is_tgm (animals_search_mview.editor, 332) AS is_editor, user_is_tgm (animals_search_mview.tourist, 332) AS is_tourist, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, STRING_AGG(l."application_id" || ':' || l."title" || ' - ' || Date(lh."timestamp")::varchar, '; ') AS licensehistory, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview INNER JOIN fates ON fates.id = animals_search_mview.fate LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN licenses l ON l.id = lh.licid left join breedings b ON b.id = animals_search_mview.last_mating GROUP BY animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data WHERE data.deleted = 'f' AND (is_owner OR is_editor OR is_tourist) and (data.straindeleted = 'f' or data.straindeleted is null) ORDER BY data.cage_name, data.animal_id, data.name;
Date: 2026-03-09 11:26:31 Duration: 0ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_command_tasks_subcommand_open_zemm_produktiv
15 53s327ms 60 613ms 8s563ms 888ms select distinct * from ( select animals_search_mview.*, b.unbreeding_date, fates.loc as fate_name, 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, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, string_agg(l."application_id" || ? || l."title" || ? || date(lh."timestamp")::varchar, ?) as licensehistory, case when not exists ( select ? from scoresheet_diary sd where sd.animals_id = animals_search_mview.id) then ? else ? end as isscored from animals_search_mview inner join fates on fates.id = animals_search_mview.fate left join strains on strains.name = animals_search_mview.strain left join license_history lh on lh.anid = animals_search_mview.id left join licenses l on l.id = lh.licid left join breedings b on b.id = animals_search_mview.last_mating group by animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data where data.fate = ? and data.alive = ? and data.deleted = ? and (is_owner or is_editor or is_tourist) and (data.straindeleted = ? or data.straindeleted is null) order by data.cage_name, data.animal_id, data.name;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Mar 09 07 5 3s134ms 626ms 08 7 20s205ms 2s886ms 09 3 1s851ms 617ms 11 9 5s597ms 621ms 12 13 8s140ms 626ms 13 4 2s497ms 624ms 14 8 5s8ms 626ms 15 2 1s247ms 623ms 16 7 4s402ms 628ms 19 2 1s241ms 620ms [ User: labanimal - Total duration: 53s327ms - Times executed: 60 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 23s790ms - Times executed: 38 ]
[ Application: _desktop_index.php_command_animals_subcommand_task_status_zemm_ - Total duration: 17s99ms - Times executed: 2 ]
[ Application: _desktop_index.php_command_login_subcommand_init_zemm_produktiv - Total duration: 6s819ms - Times executed: 11 ]
[ Application: _desktop_index.php_command_reports_subcommand_init_zemm_produkt - Total duration: 3s134ms - Times executed: 5 ]
[ Application: _desktop_index.php_command_tasks_subcommand_open_zemm_produktiv - Total duration: 1s236ms - Times executed: 2 ]
[ Application: _desktop_index.php_command_home_subcommand_task_status_zemm_pro - Total duration: 628ms - Times executed: 1 ]
[ Application: _desktop_index.php_command_home_subcommand_init_zemm_produktiv_ - Total duration: 618ms - Times executed: 1 ]
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 10100113) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100113) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100113) AS is_tourist, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, STRING_AGG(l."application_id" || ':' || l."title" || ' - ' || Date(lh."timestamp")::varchar, '; ') AS licensehistory, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview INNER JOIN fates ON fates.id = animals_search_mview.fate LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN licenses l ON l.id = lh.licid left join breedings b ON b.id = animals_search_mview.last_mating GROUP BY animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data WHERE data.fate = 6 AND data.alive = 't' AND data.deleted = 'f' AND (is_owner OR is_editor OR is_tourist) and (data.straindeleted = 'f' or data.straindeleted is null) ORDER BY data.cage_name, data.animal_id, data.name;
Date: 2026-03-09 08:25:55 Duration: 8s563ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_command_animals_subcommand_task_status_zemm_ Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 10100113) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100113) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100113) AS is_tourist, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, STRING_AGG(l."application_id" || ':' || l."title" || ' - ' || Date(lh."timestamp")::varchar, '; ') AS licensehistory, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview INNER JOIN fates ON fates.id = animals_search_mview.fate LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN licenses l ON l.id = lh.licid left join breedings b ON b.id = animals_search_mview.last_mating GROUP BY animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data WHERE data.fate = 6 AND data.alive = 't' AND data.deleted = 'f' AND (is_owner OR is_editor OR is_tourist) and (data.straindeleted = 'f' or data.straindeleted is null) ORDER BY data.cage_name, data.animal_id, data.name;
Date: 2026-03-09 08:26:12 Duration: 8s535ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_command_animals_subcommand_task_status_zemm_ Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 332) AS is_owner, user_is_tgm (animals_search_mview.editor, 332) AS is_editor, user_is_tgm (animals_search_mview.tourist, 332) AS is_tourist, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, STRING_AGG(l."application_id" || ':' || l."title" || ' - ' || Date(lh."timestamp")::varchar, '; ') AS licensehistory, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview INNER JOIN fates ON fates.id = animals_search_mview.fate LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN licenses l ON l.id = lh.licid left join breedings b ON b.id = animals_search_mview.last_mating GROUP BY animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data WHERE data.fate = 5 AND data.alive = 't' AND data.deleted = 'f' AND (is_owner OR is_editor OR is_tourist) and (data.straindeleted = 'f' or data.straindeleted is null) ORDER BY data.cage_name, data.animal_id, data.name;
Date: 2026-03-09 12:17:02 Duration: 644ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
16 47s155ms 2 23s461ms 23s694ms 23s577ms 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 not exists ( select ? from scoresheet_diary sd where sd.animals_id = animals_search_mview.id) 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 deleted = ? and (is_owner or is_editor or is_tourist);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Mar 09 11 2 47s155ms 23s577ms [ User: labanimal - Total duration: 47s155ms - Times executed: 2 ]
[ Application: _desktop_index.php_command_tasks_subcommand_open_zemm_produktiv - Total duration: 47s155ms - Times executed: 2 ]
-
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, 332) AS is_owner, user_is_tgm (animals_search_mview.editor, 332) AS is_editor, user_is_tgm (animals_search_mview.tourist, 332) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview 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 deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-03-09 11:27:03 Duration: 23s694ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_command_tasks_subcommand_open_zemm_produktiv Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
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, 332) AS is_owner, user_is_tgm (animals_search_mview.editor, 332) AS is_editor, user_is_tgm (animals_search_mview.tourist, 332) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview 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 deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-03-09 11:26:04 Duration: 23s461ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_command_tasks_subcommand_open_zemm_produktiv Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
17 28s560ms 19 782ms 2s186ms 1s503ms 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 #17
Day Hour Count Duration Avg duration Mar 09 07 1 2s186ms 2s186ms 08 7 12s287ms 1s755ms 09 4 5s845ms 1s461ms 10 4 3s159ms 789ms 11 1 791ms 791ms 13 1 2s152ms 2s152ms 16 1 2s136ms 2s136ms [ User: labanimal - Total duration: 28s560ms - Times executed: 19 ]
[ Application: _desktop_index.php_command_animals_breedings_subcommand_select_ - Total duration: 7s144ms - Times executed: 9 ]
[ Application: _desktop_index.php_command_animals_litters_subcommand_init_zemm - Total duration: 6s386ms - Times executed: 3 ]
[ Application: _desktop_index.php_command_login_subcommand_init_zemm_produktiv - Total duration: 4s338ms - Times executed: 2 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 4s288ms - Times executed: 2 ]
[ Application: _desktop_index.php_command_reports_subcommand_task_status_zemm_ - Total duration: 2s137ms - Times executed: 1 ]
[ Application: _desktop_index.php_command_tasks_subcommand_init_zemm_produktiv - Total duration: 2s133ms - Times executed: 1 ]
[ Application: _desktop_index.php_command_animals_breedings_subcommand_init_ze - Total duration: 2s131ms - Times executed: 1 ]
-
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, 228) THEN TRUE WHEN user_is_tgm (dam.editor, 228) THEN TRUE WHEN user_is_tgm (dam.tourist, 228) 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, 228) THEN TRUE WHEN user_is_tgm (sire.editor, 228) THEN TRUE WHEN user_is_tgm (sire.tourist, 228) 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-09 07:36:37 Duration: 2s186ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_command_login_subcommand_init_zemm_produktiv Log file: /var/log/postgresql/postgresql-2026-03-09_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, 10100178) THEN TRUE WHEN user_is_tgm (dam.editor, 10100178) THEN TRUE WHEN user_is_tgm (dam.tourist, 10100178) 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, 10100178) THEN TRUE WHEN user_is_tgm (sire.editor, 10100178) THEN TRUE WHEN user_is_tgm (sire.tourist, 10100178) 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-09 13:57:59 Duration: 2s152ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-09_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, 10100116) THEN TRUE WHEN user_is_tgm (dam.editor, 10100116) THEN TRUE WHEN user_is_tgm (dam.tourist, 10100116) 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, 10100116) THEN TRUE WHEN user_is_tgm (sire.editor, 10100116) THEN TRUE WHEN user_is_tgm (sire.tourist, 10100116) 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-09 08:12:58 Duration: 2s151ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_command_login_subcommand_init_zemm_produktiv Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
18 23s619ms 1 23s619ms 23s619ms 23s619ms 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 not exists ( select ? from scoresheet_diary sd where sd.animals_id = animals_search_mview.id) 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 species = ? and deleted = ? and (is_owner or is_editor or is_tourist);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Mar 09 20 1 23s619ms 23s619ms [ User: labanimal - Total duration: 23s619ms - Times executed: 1 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 23s619ms - 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, 1) AS is_owner, user_is_tgm (animals_search_mview.editor, 1) AS is_editor, user_is_tgm (animals_search_mview.tourist, 1) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview 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 species = 1 AND deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-03-09 20:59:13 Duration: 23s619ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
19 13s138ms 2 4s738ms 8s399ms 6s569ms 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 not exists ( select ? from scoresheet_diary sd where sd.animals_id = animals_search_mview.id) 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 birth_date >= ? and birth_date <= ? and deleted = ? and (is_owner or is_editor or is_tourist);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 09 21 2 13s138ms 6s569ms [ User: labanimal - Total duration: 13s138ms - Times executed: 2 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 13s138ms - Times executed: 2 ]
-
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, 1) AS is_owner, user_is_tgm (animals_search_mview.editor, 1) AS is_editor, user_is_tgm (animals_search_mview.tourist, 1) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview 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 birth_date >= '2010-03-09' AND birth_date <= '2018-03-09' AND deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-03-09 21:13:35 Duration: 8s399ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
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, 1) AS is_owner, user_is_tgm (animals_search_mview.editor, 1) AS is_editor, user_is_tgm (animals_search_mview.tourist, 1) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview 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 birth_date >= '2010-03-09' AND birth_date <= '2016-03-09' AND deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-03-09 21:14:53 Duration: 4s738ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
20 7s183ms 2 3s581ms 3s601ms 3s591ms select * from litters_search_mview l where not (deleted) and case when user_is_tgm (l.owner, ?) then true when user_is_tgm (l.editor, ?) then true when user_is_tgm (l.tourist, ?) then true else false end and (offspring - case when male_wean is null then ? else male_wean end - case when female_wean is null then ? else female_wean end - case when male_dead is null then ? else male_dead end - case when female_dead is null then ? else female_dead end - case when female_deceased is null then ? else female_deceased end - case when male_deceased is null then ? else male_deceased end) <= ? order by bday desc, dam_name, sire_name;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 09 14 2 7s183ms 3s591ms [ User: labanimal - Total duration: 7s183ms - Times executed: 2 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 7s183ms - Times executed: 2 ]
-
SELECT * FROM litters_search_mview l WHERE NOT (deleted) AND CASE WHEN user_is_tgm (l.owner, 145) THEN TRUE WHEN user_is_tgm (l.editor, 145) THEN TRUE WHEN user_is_tgm (l.tourist, 145) THEN TRUE ELSE FALSE END AND (offspring - CASE WHEN male_wean IS NULL THEN 0 ELSE male_wean END - CASE WHEN female_wean IS NULL THEN 0 ELSE female_wean END - CASE WHEN male_dead IS NULL THEN 0 ELSE male_dead END - CASE WHEN female_dead IS NULL THEN 0 ELSE female_dead END - CASE WHEN female_deceased IS NULL THEN 0 ELSE female_deceased END - CASE WHEN male_deceased IS NULL THEN 0 ELSE male_deceased END) <= 0 ORDER BY bday DESC, dam_name, sire_name;
Date: 2026-03-09 14:44:03 Duration: 3s601ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
SELECT * FROM litters_search_mview l WHERE NOT (deleted) AND CASE WHEN user_is_tgm (l.owner, 145) THEN TRUE WHEN user_is_tgm (l.editor, 145) THEN TRUE WHEN user_is_tgm (l.tourist, 145) THEN TRUE ELSE FALSE END AND (offspring - CASE WHEN male_wean IS NULL THEN 0 ELSE male_wean END - CASE WHEN female_wean IS NULL THEN 0 ELSE female_wean END - CASE WHEN male_dead IS NULL THEN 0 ELSE male_dead END - CASE WHEN female_dead IS NULL THEN 0 ELSE female_dead END - CASE WHEN female_deceased IS NULL THEN 0 ELSE female_deceased END - CASE WHEN male_deceased IS NULL THEN 0 ELSE male_deceased END) <= 0 ORDER BY bday DESC, dam_name, sire_name;
Date: 2026-03-09 14:43:59 Duration: 3s581ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,440 41m44s 546ms 27s19ms 1s739ms 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 #1
Day Hour Count Duration Avg duration Mar 09 00 60 0ms 0ms 01 60 31s733ms 528ms 02 60 1m5s 1s94ms 03 60 1m5s 1s94ms 04 60 1m5s 1s94ms 05 60 1m5s 1s94ms 06 60 1m2s 1s49ms 07 60 59s763ms 996ms 08 60 2m37s 2s628ms 09 60 1m7s 1s116ms 10 60 46s552ms 775ms 11 60 1m5s 1s97ms 12 60 49s549ms 825ms 13 60 42s479ms 707ms 14 60 1m17s 1s286ms 15 60 49s171ms 819ms 16 60 1m6s 1s109ms 17 60 2m8s 2s136ms 18 60 2m8s 2s136ms 19 60 1m4s 1s75ms 20 60 37s261ms 621ms 21 60 9m12s 9s205ms 22 60 4m44s 4s738ms 23 60 4m30s 4s511ms [ User: labanimal - Total duration: 41m44s - 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-09 11:27:01 Duration: 27s19ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_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-09 21:13:02 Duration: 23s619ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_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-09 08:26:01 Duration: 8s563ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
2 1,440 41m44s 546ms 27s19ms 1s739ms 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 #2
Day Hour Count Duration Avg duration Mar 09 00 60 0ms 0ms 01 60 31s733ms 528ms 02 60 1m5s 1s94ms 03 60 1m5s 1s94ms 04 60 1m5s 1s94ms 05 60 1m5s 1s94ms 06 60 1m2s 1s49ms 07 60 59s763ms 996ms 08 60 2m37s 2s628ms 09 60 1m7s 1s116ms 10 60 46s552ms 775ms 11 60 1m5s 1s97ms 12 60 49s549ms 825ms 13 60 42s479ms 707ms 14 60 1m17s 1s286ms 15 60 49s171ms 819ms 16 60 1m6s 1s109ms 17 60 2m8s 2s136ms 18 60 2m8s 2s136ms 19 60 1m4s 1s75ms 20 60 37s261ms 621ms 21 60 9m12s 9s205ms 22 60 4m44s 4s738ms 23 60 4m30s 4s511ms [ User: labanimal - Total duration: 41m44s - 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-09 11:27:01 Duration: 27s19ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_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-09 21:13:02 Duration: 23s619ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_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-09 08:26:01 Duration: 8s563ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
3 1,440 41m44s 546ms 27s19ms 1s739ms create index if not exists idx_app_events_type on observability.app_events (event_type);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 09 00 60 0ms 0ms 01 60 31s733ms 528ms 02 60 1m5s 1s94ms 03 60 1m5s 1s94ms 04 60 1m5s 1s94ms 05 60 1m5s 1s94ms 06 60 1m2s 1s49ms 07 60 59s763ms 996ms 08 60 2m37s 2s628ms 09 60 1m7s 1s116ms 10 60 46s552ms 775ms 11 60 1m5s 1s97ms 12 60 49s549ms 825ms 13 60 42s479ms 707ms 14 60 1m17s 1s286ms 15 60 49s171ms 819ms 16 60 1m6s 1s109ms 17 60 2m8s 2s136ms 18 60 2m8s 2s136ms 19 60 1m4s 1s75ms 20 60 37s261ms 621ms 21 60 9m12s 9s205ms 22 60 4m44s 4s738ms 23 60 4m30s 4s511ms [ User: labanimal - Total duration: 41m44s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-09 11:27:01 Duration: 27s19ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-09 21:13:02 Duration: 23s619ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-09 08:26:01 Duration: 8s563ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
4 1,440 41m44s 546ms 27s19ms 1s739ms create index if not exists idx_metrics_timeseries_bucket on observability.metrics_timeseries (bucket_start);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 09 00 60 0ms 0ms 01 60 31s733ms 528ms 02 60 1m5s 1s94ms 03 60 1m5s 1s94ms 04 60 1m5s 1s94ms 05 60 1m5s 1s94ms 06 60 1m2s 1s49ms 07 60 59s763ms 996ms 08 60 2m37s 2s628ms 09 60 1m7s 1s116ms 10 60 46s552ms 775ms 11 60 1m5s 1s97ms 12 60 49s549ms 825ms 13 60 42s479ms 707ms 14 60 1m17s 1s286ms 15 60 49s171ms 819ms 16 60 1m6s 1s109ms 17 60 2m8s 2s136ms 18 60 2m8s 2s136ms 19 60 1m4s 1s75ms 20 60 37s261ms 621ms 21 60 9m12s 9s205ms 22 60 4m44s 4s738ms 23 60 4m30s 4s511ms [ User: labanimal - Total duration: 41m44s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-09 11:27:01 Duration: 27s19ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-09 21:13:02 Duration: 23s619ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-09 08:26:01 Duration: 8s563ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
5 1,440 41m44s 546ms 27s19ms 1s739ms 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 #5
Day Hour Count Duration Avg duration Mar 09 00 60 0ms 0ms 01 60 31s733ms 528ms 02 60 1m5s 1s94ms 03 60 1m5s 1s94ms 04 60 1m5s 1s94ms 05 60 1m5s 1s94ms 06 60 1m2s 1s49ms 07 60 59s763ms 996ms 08 60 2m37s 2s628ms 09 60 1m7s 1s116ms 10 60 46s552ms 775ms 11 60 1m5s 1s97ms 12 60 49s549ms 825ms 13 60 42s479ms 707ms 14 60 1m17s 1s286ms 15 60 49s171ms 819ms 16 60 1m6s 1s109ms 17 60 2m8s 2s136ms 18 60 2m8s 2s136ms 19 60 1m4s 1s75ms 20 60 37s261ms 621ms 21 60 9m12s 9s205ms 22 60 4m44s 4s738ms 23 60 4m30s 4s511ms [ User: labanimal - Total duration: 41m44s - 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-09 11:27:01 Duration: 27s19ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_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-09 21:13:02 Duration: 23s619ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_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-09 08:26:01 Duration: 8s563ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
6 1,440 41m44s 546ms 27s19ms 1s739ms create schema if not exists observability;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Mar 09 00 60 0ms 0ms 01 60 31s733ms 528ms 02 60 1m5s 1s94ms 03 60 1m5s 1s94ms 04 60 1m5s 1s94ms 05 60 1m5s 1s94ms 06 60 1m2s 1s49ms 07 60 59s763ms 996ms 08 60 2m37s 2s628ms 09 60 1m7s 1s116ms 10 60 46s552ms 775ms 11 60 1m5s 1s97ms 12 60 49s549ms 825ms 13 60 42s479ms 707ms 14 60 1m17s 1s286ms 15 60 49s171ms 819ms 16 60 1m6s 1s109ms 17 60 2m8s 2s136ms 18 60 2m8s 2s136ms 19 60 1m4s 1s75ms 20 60 37s261ms 621ms 21 60 9m12s 9s205ms 22 60 4m44s 4s738ms 23 60 4m30s 4s511ms [ User: labanimal - Total duration: 41m44s - Times executed: 1349 ]
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-09 11:27:01 Duration: 27s19ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-09 21:13:02 Duration: 23s619ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-09 08:26:01 Duration: 8s563ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
7 1,440 41m44s 546ms 27s19ms 1s739ms 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 #7
Day Hour Count Duration Avg duration Mar 09 00 60 0ms 0ms 01 60 31s733ms 528ms 02 60 1m5s 1s94ms 03 60 1m5s 1s94ms 04 60 1m5s 1s94ms 05 60 1m5s 1s94ms 06 60 1m2s 1s49ms 07 60 59s763ms 996ms 08 60 2m37s 2s628ms 09 60 1m7s 1s116ms 10 60 46s552ms 775ms 11 60 1m5s 1s97ms 12 60 49s549ms 825ms 13 60 42s479ms 707ms 14 60 1m17s 1s286ms 15 60 49s171ms 819ms 16 60 1m6s 1s109ms 17 60 2m8s 2s136ms 18 60 2m8s 2s136ms 19 60 1m4s 1s75ms 20 60 37s261ms 621ms 21 60 9m12s 9s205ms 22 60 4m44s 4s738ms 23 60 4m30s 4s511ms [ User: labanimal - Total duration: 41m44s - 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-09 11:27:01 Duration: 27s19ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_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-09 21:13:02 Duration: 23s619ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_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-09 08:26:01 Duration: 8s563ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
8 1,440 41m44s 546ms 27s19ms 1s739ms create index if not exists idx_metrics_timeseries_metric on observability.metrics_timeseries (metric_name);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Mar 09 00 60 0ms 0ms 01 60 31s733ms 528ms 02 60 1m5s 1s94ms 03 60 1m5s 1s94ms 04 60 1m5s 1s94ms 05 60 1m5s 1s94ms 06 60 1m2s 1s49ms 07 60 59s763ms 996ms 08 60 2m37s 2s628ms 09 60 1m7s 1s116ms 10 60 46s552ms 775ms 11 60 1m5s 1s97ms 12 60 49s549ms 825ms 13 60 42s479ms 707ms 14 60 1m17s 1s286ms 15 60 49s171ms 819ms 16 60 1m6s 1s109ms 17 60 2m8s 2s136ms 18 60 2m8s 2s136ms 19 60 1m4s 1s75ms 20 60 37s261ms 621ms 21 60 9m12s 9s205ms 22 60 4m44s 4s738ms 23 60 4m30s 4s511ms [ User: labanimal - Total duration: 41m44s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-09 11:27:01 Duration: 27s19ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-09 21:13:02 Duration: 23s619ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-09 08:26:01 Duration: 8s563ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
9 1,440 41m44s 546ms 27s19ms 1s739ms 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 #9
Day Hour Count Duration Avg duration Mar 09 00 60 0ms 0ms 01 60 31s733ms 528ms 02 60 1m5s 1s94ms 03 60 1m5s 1s94ms 04 60 1m5s 1s94ms 05 60 1m5s 1s94ms 06 60 1m2s 1s49ms 07 60 59s763ms 996ms 08 60 2m37s 2s628ms 09 60 1m7s 1s116ms 10 60 46s552ms 775ms 11 60 1m5s 1s97ms 12 60 49s549ms 825ms 13 60 42s479ms 707ms 14 60 1m17s 1s286ms 15 60 49s171ms 819ms 16 60 1m6s 1s109ms 17 60 2m8s 2s136ms 18 60 2m8s 2s136ms 19 60 1m4s 1s75ms 20 60 37s261ms 621ms 21 60 9m12s 9s205ms 22 60 4m44s 4s738ms 23 60 4m30s 4s511ms [ User: labanimal - Total duration: 41m44s - 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-09 11:27:01 Duration: 27s19ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_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-09 21:13:02 Duration: 23s619ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_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-09 08:26:01 Duration: 8s563ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
10 1,440 41m44s 546ms 27s19ms 1s739ms create index if not exists idx_app_events_tenant on observability.app_events (tenant_key, occurred_at desc);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Mar 09 00 60 0ms 0ms 01 60 31s733ms 528ms 02 60 1m5s 1s94ms 03 60 1m5s 1s94ms 04 60 1m5s 1s94ms 05 60 1m5s 1s94ms 06 60 1m2s 1s49ms 07 60 59s763ms 996ms 08 60 2m37s 2s628ms 09 60 1m7s 1s116ms 10 60 46s552ms 775ms 11 60 1m5s 1s97ms 12 60 49s549ms 825ms 13 60 42s479ms 707ms 14 60 1m17s 1s286ms 15 60 49s171ms 819ms 16 60 1m6s 1s109ms 17 60 2m8s 2s136ms 18 60 2m8s 2s136ms 19 60 1m4s 1s75ms 20 60 37s261ms 621ms 21 60 9m12s 9s205ms 22 60 4m44s 4s738ms 23 60 4m30s 4s511ms [ User: labanimal - Total duration: 41m44s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-09 11:27:01 Duration: 27s19ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-09 21:13:02 Duration: 23s619ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-09 08:26:01 Duration: 8s563ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
11 1,440 41m44s 546ms 27s19ms 1s739ms 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 #11
Day Hour Count Duration Avg duration Mar 09 00 60 0ms 0ms 01 60 31s733ms 528ms 02 60 1m5s 1s94ms 03 60 1m5s 1s94ms 04 60 1m5s 1s94ms 05 60 1m5s 1s94ms 06 60 1m2s 1s49ms 07 60 59s763ms 996ms 08 60 2m37s 2s628ms 09 60 1m7s 1s116ms 10 60 46s552ms 775ms 11 60 1m5s 1s97ms 12 60 49s549ms 825ms 13 60 42s479ms 707ms 14 60 1m17s 1s286ms 15 60 49s171ms 819ms 16 60 1m6s 1s109ms 17 60 2m8s 2s136ms 18 60 2m8s 2s136ms 19 60 1m4s 1s75ms 20 60 37s261ms 621ms 21 60 9m12s 9s205ms 22 60 4m44s 4s738ms 23 60 4m30s 4s511ms [ User: labanimal - Total duration: 41m44s - 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-09 11:27:01 Duration: 27s19ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_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-09 21:13:02 Duration: 23s619ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_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-09 08:26:01 Duration: 8s563ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
12 1,440 41m44s 546ms 27s19ms 1s739ms 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 09 00 60 0ms 0ms 01 60 31s733ms 528ms 02 60 1m5s 1s94ms 03 60 1m5s 1s94ms 04 60 1m5s 1s94ms 05 60 1m5s 1s94ms 06 60 1m2s 1s49ms 07 60 59s763ms 996ms 08 60 2m37s 2s628ms 09 60 1m7s 1s116ms 10 60 46s552ms 775ms 11 60 1m5s 1s97ms 12 60 49s549ms 825ms 13 60 42s479ms 707ms 14 60 1m17s 1s286ms 15 60 49s171ms 819ms 16 60 1m6s 1s109ms 17 60 2m8s 2s136ms 18 60 2m8s 2s136ms 19 60 1m4s 1s75ms 20 60 37s261ms 621ms 21 60 9m12s 9s205ms 22 60 4m44s 4s738ms 23 60 4m30s 4s511ms [ User: labanimal - Total duration: 41m44s - 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-09 11:27:01 Duration: 27s19ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_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-09 21:13:02 Duration: 23s619ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_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-09 08:26:01 Duration: 8s563ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
13 60 54s385ms 655ms 7s954ms 906ms 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 not exists ( select ? from scoresheet_diary sd where sd.animals_id = animals_search_mview.id) 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 #13
Day Hour Count Duration Avg duration Mar 09 07 5 3s365ms 673ms 08 7 19s152ms 2s736ms 09 3 1s973ms 657ms 11 9 5s949ms 661ms 12 13 8s638ms 664ms 13 4 2s654ms 663ms 14 8 5s324ms 665ms 15 2 1s331ms 665ms 16 7 4s668ms 666ms 19 2 1s327ms 663ms [ User: labanimal - Total duration: 54s385ms - Times executed: 60 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 25s267ms - Times executed: 38 ]
[ Application: _desktop_index.php_command_animals_subcommand_task_status_zemm_ - Total duration: 15s855ms - Times executed: 2 ]
[ Application: _desktop_index.php_command_login_subcommand_init_zemm_produktiv - Total duration: 7s257ms - Times executed: 11 ]
[ Application: _desktop_index.php_command_reports_subcommand_init_zemm_produkt - Total duration: 3s365ms - Times executed: 5 ]
[ Application: _desktop_index.php_command_tasks_subcommand_open_zemm_produktiv - Total duration: 1s325ms - Times executed: 2 ]
[ Application: _desktop_index.php_command_home_subcommand_task_status_zemm_pro - Total duration: 659ms - Times executed: 1 ]
[ Application: _desktop_index.php_command_home_subcommand_init_zemm_produktiv_ - Total duration: 656ms - 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, 10100113) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100113) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100113) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview 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 = 6 AND alive = 't' AND deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-03-09 08:25:47 Duration: 7s954ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_command_animals_subcommand_task_status_zemm_ Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
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, 10100113) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100113) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100113) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview 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 = 6 AND alive = 't' AND deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-03-09 08:26:03 Duration: 7s901ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_command_animals_subcommand_task_status_zemm_ Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
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, 540) AS is_owner, user_is_tgm (animals_search_mview.editor, 540) AS is_editor, user_is_tgm (animals_search_mview.tourist, 540) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview 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-09 14:03:39 Duration: 685ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
14 60 53s327ms 613ms 8s563ms 888ms select distinct * from ( select animals_search_mview.*, b.unbreeding_date, fates.loc as fate_name, 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, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, string_agg(l."application_id" || ? || l."title" || ? || date(lh."timestamp")::varchar, ?) as licensehistory, case when not exists ( select ? from scoresheet_diary sd where sd.animals_id = animals_search_mview.id) then ? else ? end as isscored from animals_search_mview inner join fates on fates.id = animals_search_mview.fate left join strains on strains.name = animals_search_mview.strain left join license_history lh on lh.anid = animals_search_mview.id left join licenses l on l.id = lh.licid left join breedings b on b.id = animals_search_mview.last_mating group by animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data where data.fate = ? and data.alive = ? and data.deleted = ? and (is_owner or is_editor or is_tourist) and (data.straindeleted = ? or data.straindeleted is null) order by data.cage_name, data.animal_id, data.name;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Mar 09 07 5 3s134ms 626ms 08 7 20s205ms 2s886ms 09 3 1s851ms 617ms 11 9 5s597ms 621ms 12 13 8s140ms 626ms 13 4 2s497ms 624ms 14 8 5s8ms 626ms 15 2 1s247ms 623ms 16 7 4s402ms 628ms 19 2 1s241ms 620ms [ User: labanimal - Total duration: 53s327ms - Times executed: 60 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 23s790ms - Times executed: 38 ]
[ Application: _desktop_index.php_command_animals_subcommand_task_status_zemm_ - Total duration: 17s99ms - Times executed: 2 ]
[ Application: _desktop_index.php_command_login_subcommand_init_zemm_produktiv - Total duration: 6s819ms - Times executed: 11 ]
[ Application: _desktop_index.php_command_reports_subcommand_init_zemm_produkt - Total duration: 3s134ms - Times executed: 5 ]
[ Application: _desktop_index.php_command_tasks_subcommand_open_zemm_produktiv - Total duration: 1s236ms - Times executed: 2 ]
[ Application: _desktop_index.php_command_home_subcommand_task_status_zemm_pro - Total duration: 628ms - Times executed: 1 ]
[ Application: _desktop_index.php_command_home_subcommand_init_zemm_produktiv_ - Total duration: 618ms - Times executed: 1 ]
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 10100113) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100113) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100113) AS is_tourist, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, STRING_AGG(l."application_id" || ':' || l."title" || ' - ' || Date(lh."timestamp")::varchar, '; ') AS licensehistory, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview INNER JOIN fates ON fates.id = animals_search_mview.fate LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN licenses l ON l.id = lh.licid left join breedings b ON b.id = animals_search_mview.last_mating GROUP BY animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data WHERE data.fate = 6 AND data.alive = 't' AND data.deleted = 'f' AND (is_owner OR is_editor OR is_tourist) and (data.straindeleted = 'f' or data.straindeleted is null) ORDER BY data.cage_name, data.animal_id, data.name;
Date: 2026-03-09 08:25:55 Duration: 8s563ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_command_animals_subcommand_task_status_zemm_ Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 10100113) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100113) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100113) AS is_tourist, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, STRING_AGG(l."application_id" || ':' || l."title" || ' - ' || Date(lh."timestamp")::varchar, '; ') AS licensehistory, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview INNER JOIN fates ON fates.id = animals_search_mview.fate LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN licenses l ON l.id = lh.licid left join breedings b ON b.id = animals_search_mview.last_mating GROUP BY animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data WHERE data.fate = 6 AND data.alive = 't' AND data.deleted = 'f' AND (is_owner OR is_editor OR is_tourist) and (data.straindeleted = 'f' or data.straindeleted is null) ORDER BY data.cage_name, data.animal_id, data.name;
Date: 2026-03-09 08:26:12 Duration: 8s535ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_command_animals_subcommand_task_status_zemm_ Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 332) AS is_owner, user_is_tgm (animals_search_mview.editor, 332) AS is_editor, user_is_tgm (animals_search_mview.tourist, 332) AS is_tourist, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, STRING_AGG(l."application_id" || ':' || l."title" || ' - ' || Date(lh."timestamp")::varchar, '; ') AS licensehistory, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview INNER JOIN fates ON fates.id = animals_search_mview.fate LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN licenses l ON l.id = lh.licid left join breedings b ON b.id = animals_search_mview.last_mating GROUP BY animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data WHERE data.fate = 5 AND data.alive = 't' AND data.deleted = 'f' AND (is_owner OR is_editor OR is_tourist) and (data.straindeleted = 'f' or data.straindeleted is null) ORDER BY data.cage_name, data.animal_id, data.name;
Date: 2026-03-09 12:17:02 Duration: 644ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
15 19 28s560ms 782ms 2s186ms 1s503ms 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 #15
Day Hour Count Duration Avg duration Mar 09 07 1 2s186ms 2s186ms 08 7 12s287ms 1s755ms 09 4 5s845ms 1s461ms 10 4 3s159ms 789ms 11 1 791ms 791ms 13 1 2s152ms 2s152ms 16 1 2s136ms 2s136ms [ User: labanimal - Total duration: 28s560ms - Times executed: 19 ]
[ Application: _desktop_index.php_command_animals_breedings_subcommand_select_ - Total duration: 7s144ms - Times executed: 9 ]
[ Application: _desktop_index.php_command_animals_litters_subcommand_init_zemm - Total duration: 6s386ms - Times executed: 3 ]
[ Application: _desktop_index.php_command_login_subcommand_init_zemm_produktiv - Total duration: 4s338ms - Times executed: 2 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 4s288ms - Times executed: 2 ]
[ Application: _desktop_index.php_command_reports_subcommand_task_status_zemm_ - Total duration: 2s137ms - Times executed: 1 ]
[ Application: _desktop_index.php_command_tasks_subcommand_init_zemm_produktiv - Total duration: 2s133ms - Times executed: 1 ]
[ Application: _desktop_index.php_command_animals_breedings_subcommand_init_ze - Total duration: 2s131ms - Times executed: 1 ]
-
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, 228) THEN TRUE WHEN user_is_tgm (dam.editor, 228) THEN TRUE WHEN user_is_tgm (dam.tourist, 228) 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, 228) THEN TRUE WHEN user_is_tgm (sire.editor, 228) THEN TRUE WHEN user_is_tgm (sire.tourist, 228) 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-09 07:36:37 Duration: 2s186ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_command_login_subcommand_init_zemm_produktiv Log file: /var/log/postgresql/postgresql-2026-03-09_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, 10100178) THEN TRUE WHEN user_is_tgm (dam.editor, 10100178) THEN TRUE WHEN user_is_tgm (dam.tourist, 10100178) 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, 10100178) THEN TRUE WHEN user_is_tgm (sire.editor, 10100178) THEN TRUE WHEN user_is_tgm (sire.tourist, 10100178) 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-09 13:57:59 Duration: 2s152ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-09_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, 10100116) THEN TRUE WHEN user_is_tgm (dam.editor, 10100116) THEN TRUE WHEN user_is_tgm (dam.tourist, 10100116) 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, 10100116) THEN TRUE WHEN user_is_tgm (sire.editor, 10100116) THEN TRUE WHEN user_is_tgm (sire.tourist, 10100116) 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-09 08:12:58 Duration: 2s151ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_command_login_subcommand_init_zemm_produktiv Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
16 6 5s458ms 763ms 979ms 909ms select p_update_breedings (?, null, ?, ?::date, null, ?::text, ?::text, null) as id;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Mar 09 06 1 943ms 943ms 12 1 939ms 939ms 13 3 2s596ms 865ms 15 1 979ms 979ms [ User: labanimal - Total duration: 5s458ms - Times executed: 6 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 4s515ms - Times executed: 5 ]
[ Application: _desktop_index.php_command_tasks_subcommand_open_zemm_produktiv - Total duration: 943ms - Times executed: 1 ]
-
SELECT p_update_breedings (456, NULL, 13374, '2026-03-09'::date, NULL, '10288360'::text, '10281356'::text, NULL) AS id;
Date: 2026-03-09 15:30:15 Duration: 979ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
SELECT p_update_breedings (343, NULL, 10101174, '2026-03-09'::date, NULL, '10289401'::text, '10289404'::text, NULL) AS id;
Date: 2026-03-09 06:53:27 Duration: 943ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_command_tasks_subcommand_open_zemm_produktiv Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
SELECT p_update_breedings (343, NULL, 8258, '2026-03-09'::date, NULL, '10284298'::text, '10296930;10296931'::text, NULL) AS id;
Date: 2026-03-09 12:59:54 Duration: 939ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
17 6 4s34ms 569ms 936ms 672ms select p_update_animals (?, cast(? as character varying), null, null, null, null, null, null, null, null, null, ?, null, null, ?, null, true, null, null, null, null, null, null, null);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Mar 09 06 1 647ms 647ms 12 1 936ms 936ms 13 3 1s796ms 598ms 15 1 654ms 654ms [ User: labanimal - Total duration: 4s34ms - Times executed: 6 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 3s387ms - Times executed: 5 ]
[ Application: _desktop_index.php_command_tasks_subcommand_open_zemm_produktiv - Total duration: 647ms - Times executed: 1 ]
-
SELECT p_update_animals (343, CAST('10284298;10296930;10296931' AS character varying), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10111169, NULL, NULL, 8258, NULL, TRUE, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
Date: 2026-03-09 12:59:55 Duration: 936ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
SELECT p_update_animals (343, CAST('10277603;10297782' AS character varying), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10111172, NULL, NULL, 8226, NULL, TRUE, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
Date: 2026-03-09 13:07:31 Duration: 655ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
SELECT p_update_animals (456, CAST('10288360;10281356' AS character varying), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10111173, NULL, NULL, 13374, NULL, TRUE, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
Date: 2026-03-09 15:30:16 Duration: 654ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
18 4 2s707ms 670ms 685ms 676ms 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 not exists ( select ? from scoresheet_diary sd where sd.animals_id = animals_search_mview.id) 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 animal_id like ? and fate = ? and alive = ? and deleted = ? and (is_owner or is_editor or is_tourist);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Mar 09 08 2 1s348ms 674ms 09 2 1s359ms 679ms [ User: labanimal - Total duration: 2s707ms - Times executed: 4 ]
[ Application: _desktop_index.php_command_login_subcommand_init_zemm_produktiv - Total duration: 2s707ms - Times executed: 4 ]
-
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, 10100128) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100128) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100128) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview 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 animal_id LIKE '%' AND fate = 5 AND alive = 't' AND deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-03-09 09:44:02 Duration: 685ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_command_login_subcommand_init_zemm_produktiv Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
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, 10100130) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100130) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100130) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview 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 animal_id LIKE '%' AND fate = 5 AND alive = 't' AND deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-03-09 08:18:32 Duration: 677ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_command_login_subcommand_init_zemm_produktiv Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
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, 10100128) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100128) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100128) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview 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 animal_id LIKE '%' AND fate = 5 AND alive = 't' AND deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-03-09 09:43:59 Duration: 673ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_command_login_subcommand_init_zemm_produktiv Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
19 4 2s525ms 630ms 632ms 631ms select distinct * from ( select animals_search_mview.*, b.unbreeding_date, fates.loc as fate_name, 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, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, string_agg(l."application_id" || ? || l."title" || ? || date(lh."timestamp")::varchar, ?) as licensehistory, case when not exists ( select ? from scoresheet_diary sd where sd.animals_id = animals_search_mview.id) then ? else ? end as isscored from animals_search_mview inner join fates on fates.id = animals_search_mview.fate left join strains on strains.name = animals_search_mview.strain left join license_history lh on lh.anid = animals_search_mview.id left join licenses l on l.id = lh.licid left join breedings b on b.id = animals_search_mview.last_mating group by animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data where data.animal_id like ? and data.fate = ? and data.alive = ? and data.deleted = ? and (is_owner or is_editor or is_tourist) and (data.straindeleted = ? or data.straindeleted is null) order by data.cage_name, data.animal_id, data.name;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 09 08 2 1s262ms 631ms 09 2 1s262ms 631ms [ User: labanimal - Total duration: 2s525ms - Times executed: 4 ]
[ Application: _desktop_index.php_command_login_subcommand_init_zemm_produktiv - Total duration: 2s525ms - Times executed: 4 ]
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 10100128) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100128) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100128) AS is_tourist, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, STRING_AGG(l."application_id" || ':' || l."title" || ' - ' || Date(lh."timestamp")::varchar, '; ') AS licensehistory, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview INNER JOIN fates ON fates.id = animals_search_mview.fate LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN licenses l ON l.id = lh.licid left join breedings b ON b.id = animals_search_mview.last_mating GROUP BY animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data WHERE data.animal_id LIKE '%' AND data.fate = 5 AND data.alive = 't' AND data.deleted = 'f' AND (is_owner OR is_editor OR is_tourist) and (data.straindeleted = 'f' or data.straindeleted is null) ORDER BY data.cage_name, data.animal_id, data.name;
Date: 2026-03-09 09:44:02 Duration: 632ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_command_login_subcommand_init_zemm_produktiv Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 10100130) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100130) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100130) AS is_tourist, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, STRING_AGG(l."application_id" || ':' || l."title" || ' - ' || Date(lh."timestamp")::varchar, '; ') AS licensehistory, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview INNER JOIN fates ON fates.id = animals_search_mview.fate LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN licenses l ON l.id = lh.licid left join breedings b ON b.id = animals_search_mview.last_mating GROUP BY animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data WHERE data.animal_id LIKE '%' AND data.fate = 5 AND data.alive = 't' AND data.deleted = 'f' AND (is_owner OR is_editor OR is_tourist) and (data.straindeleted = 'f' or data.straindeleted is null) ORDER BY data.cage_name, data.animal_id, data.name;
Date: 2026-03-09 08:18:33 Duration: 632ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_command_login_subcommand_init_zemm_produktiv Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 10100130) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100130) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100130) AS is_tourist, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, STRING_AGG(l."application_id" || ':' || l."title" || ' - ' || Date(lh."timestamp")::varchar, '; ') AS licensehistory, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview INNER JOIN fates ON fates.id = animals_search_mview.fate LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN licenses l ON l.id = lh.licid left join breedings b ON b.id = animals_search_mview.last_mating GROUP BY animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data WHERE data.animal_id LIKE '%' AND data.fate = 5 AND data.alive = 't' AND data.deleted = 'f' AND (is_owner OR is_editor OR is_tourist) and (data.straindeleted = 'f' or data.straindeleted is null) ORDER BY data.cage_name, data.animal_id, data.name;
Date: 2026-03-09 08:18:37 Duration: 630ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_command_login_subcommand_init_zemm_produktiv Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
20 3 2s144ms 703ms 727ms 714ms 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 not exists ( select ? from scoresheet_diary sd where sd.animals_id = animals_search_mview.id) 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 species = ? and 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 09 09 1 727ms 727ms 10 1 713ms 713ms 13 1 703ms 703ms [ User: labanimal - Total duration: 2s144ms - Times executed: 3 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 1s416ms - Times executed: 2 ]
[ Application: _desktop_index.php_command_login_subcommand_init_zemm_produktiv - Total duration: 727ms - 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, 10100079) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100079) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100079) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview 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 species = 1 AND fate = 5 AND alive = 't' AND deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-03-09 09:06:55 Duration: 727ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_command_login_subcommand_init_zemm_produktiv Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
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, 10100079) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100079) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100079) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview 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 species = 1 AND fate = 5 AND alive = 't' AND deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-03-09 10:21:43 Duration: 713ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
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, 10100079) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100079) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100079) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview 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 species = 1 AND fate = 5 AND alive = 't' AND deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-03-09 13:28:40 Duration: 703ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 26s795ms 27s19ms 26s907ms 2 53s815ms select distinct * from ( select animals_search_mview.*, b.unbreeding_date, fates.loc as fate_name, 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, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, string_agg(l."application_id" || ? || l."title" || ? || date(lh."timestamp")::varchar, ?) as licensehistory, case when not exists ( select ? from scoresheet_diary sd where sd.animals_id = animals_search_mview.id) then ? else ? end as isscored from animals_search_mview inner join fates on fates.id = animals_search_mview.fate left join strains on strains.name = animals_search_mview.strain left join license_history lh on lh.anid = animals_search_mview.id left join licenses l on l.id = lh.licid left join breedings b on b.id = animals_search_mview.last_mating group by animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data where data.deleted = ? and (is_owner or is_editor or is_tourist) and (data.straindeleted = ? or data.straindeleted is null) order by data.cage_name, data.animal_id, data.name;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 09 11 2 53s815ms 26s907ms [ User: labanimal - Total duration: 53s815ms - Times executed: 2 ]
[ Application: _desktop_index.php_command_tasks_subcommand_open_zemm_produktiv - Total duration: 53s815ms - Times executed: 2 ]
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 332) AS is_owner, user_is_tgm (animals_search_mview.editor, 332) AS is_editor, user_is_tgm (animals_search_mview.tourist, 332) AS is_tourist, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, STRING_AGG(l."application_id" || ':' || l."title" || ' - ' || Date(lh."timestamp")::varchar, '; ') AS licensehistory, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview INNER JOIN fates ON fates.id = animals_search_mview.fate LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN licenses l ON l.id = lh.licid left join breedings b ON b.id = animals_search_mview.last_mating GROUP BY animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data WHERE data.deleted = 'f' AND (is_owner OR is_editor OR is_tourist) and (data.straindeleted = 'f' or data.straindeleted is null) ORDER BY data.cage_name, data.animal_id, data.name;
Date: 2026-03-09 11:26:31 Duration: 27s19ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_command_tasks_subcommand_open_zemm_produktiv Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 332) AS is_owner, user_is_tgm (animals_search_mview.editor, 332) AS is_editor, user_is_tgm (animals_search_mview.tourist, 332) AS is_tourist, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, STRING_AGG(l."application_id" || ':' || l."title" || ' - ' || Date(lh."timestamp")::varchar, '; ') AS licensehistory, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview INNER JOIN fates ON fates.id = animals_search_mview.fate LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN licenses l ON l.id = lh.licid left join breedings b ON b.id = animals_search_mview.last_mating GROUP BY animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data WHERE data.deleted = 'f' AND (is_owner OR is_editor OR is_tourist) and (data.straindeleted = 'f' or data.straindeleted is null) ORDER BY data.cage_name, data.animal_id, data.name;
Date: 2026-03-09 11:27:30 Duration: 26s795ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_command_tasks_subcommand_open_zemm_produktiv Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 332) AS is_owner, user_is_tgm (animals_search_mview.editor, 332) AS is_editor, user_is_tgm (animals_search_mview.tourist, 332) AS is_tourist, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, STRING_AGG(l."application_id" || ':' || l."title" || ' - ' || Date(lh."timestamp")::varchar, '; ') AS licensehistory, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview INNER JOIN fates ON fates.id = animals_search_mview.fate LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN licenses l ON l.id = lh.licid left join breedings b ON b.id = animals_search_mview.last_mating GROUP BY animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data WHERE data.deleted = 'f' AND (is_owner OR is_editor OR is_tourist) and (data.straindeleted = 'f' or data.straindeleted is null) ORDER BY data.cage_name, data.animal_id, data.name;
Date: 2026-03-09 11:26:31 Duration: 0ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_command_tasks_subcommand_open_zemm_produktiv
2 23s619ms 23s619ms 23s619ms 1 23s619ms 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 not exists ( select ? from scoresheet_diary sd where sd.animals_id = animals_search_mview.id) 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 species = ? and deleted = ? and (is_owner or is_editor or is_tourist);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 09 20 1 23s619ms 23s619ms [ User: labanimal - Total duration: 23s619ms - Times executed: 1 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 23s619ms - 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, 1) AS is_owner, user_is_tgm (animals_search_mview.editor, 1) AS is_editor, user_is_tgm (animals_search_mview.tourist, 1) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview 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 species = 1 AND deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-03-09 20:59:13 Duration: 23s619ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
3 23s461ms 23s694ms 23s577ms 2 47s155ms 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 not exists ( select ? from scoresheet_diary sd where sd.animals_id = animals_search_mview.id) 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 deleted = ? and (is_owner or is_editor or is_tourist);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 09 11 2 47s155ms 23s577ms [ User: labanimal - Total duration: 47s155ms - Times executed: 2 ]
[ Application: _desktop_index.php_command_tasks_subcommand_open_zemm_produktiv - Total duration: 47s155ms - Times executed: 2 ]
-
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, 332) AS is_owner, user_is_tgm (animals_search_mview.editor, 332) AS is_editor, user_is_tgm (animals_search_mview.tourist, 332) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview 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 deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-03-09 11:27:03 Duration: 23s694ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_command_tasks_subcommand_open_zemm_produktiv Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
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, 332) AS is_owner, user_is_tgm (animals_search_mview.editor, 332) AS is_editor, user_is_tgm (animals_search_mview.tourist, 332) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview 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 deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-03-09 11:26:04 Duration: 23s461ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_command_tasks_subcommand_open_zemm_produktiv Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
4 4s738ms 8s399ms 6s569ms 2 13s138ms 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 not exists ( select ? from scoresheet_diary sd where sd.animals_id = animals_search_mview.id) 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 birth_date >= ? and birth_date <= ? and deleted = ? and (is_owner or is_editor or is_tourist);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 09 21 2 13s138ms 6s569ms [ User: labanimal - Total duration: 13s138ms - Times executed: 2 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 13s138ms - Times executed: 2 ]
-
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, 1) AS is_owner, user_is_tgm (animals_search_mview.editor, 1) AS is_editor, user_is_tgm (animals_search_mview.tourist, 1) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview 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 birth_date >= '2010-03-09' AND birth_date <= '2018-03-09' AND deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-03-09 21:13:35 Duration: 8s399ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
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, 1) AS is_owner, user_is_tgm (animals_search_mview.editor, 1) AS is_editor, user_is_tgm (animals_search_mview.tourist, 1) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview 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 birth_date >= '2010-03-09' AND birth_date <= '2016-03-09' AND deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-03-09 21:14:53 Duration: 4s738ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
5 3s581ms 3s601ms 3s591ms 2 7s183ms select * from litters_search_mview l where not (deleted) and case when user_is_tgm (l.owner, ?) then true when user_is_tgm (l.editor, ?) then true when user_is_tgm (l.tourist, ?) then true else false end and (offspring - case when male_wean is null then ? else male_wean end - case when female_wean is null then ? else female_wean end - case when male_dead is null then ? else male_dead end - case when female_dead is null then ? else female_dead end - case when female_deceased is null then ? else female_deceased end - case when male_deceased is null then ? else male_deceased end) <= ? order by bday desc, dam_name, sire_name;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Mar 09 14 2 7s183ms 3s591ms [ User: labanimal - Total duration: 7s183ms - Times executed: 2 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 7s183ms - Times executed: 2 ]
-
SELECT * FROM litters_search_mview l WHERE NOT (deleted) AND CASE WHEN user_is_tgm (l.owner, 145) THEN TRUE WHEN user_is_tgm (l.editor, 145) THEN TRUE WHEN user_is_tgm (l.tourist, 145) THEN TRUE ELSE FALSE END AND (offspring - CASE WHEN male_wean IS NULL THEN 0 ELSE male_wean END - CASE WHEN female_wean IS NULL THEN 0 ELSE female_wean END - CASE WHEN male_dead IS NULL THEN 0 ELSE male_dead END - CASE WHEN female_dead IS NULL THEN 0 ELSE female_dead END - CASE WHEN female_deceased IS NULL THEN 0 ELSE female_deceased END - CASE WHEN male_deceased IS NULL THEN 0 ELSE male_deceased END) <= 0 ORDER BY bday DESC, dam_name, sire_name;
Date: 2026-03-09 14:44:03 Duration: 3s601ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
SELECT * FROM litters_search_mview l WHERE NOT (deleted) AND CASE WHEN user_is_tgm (l.owner, 145) THEN TRUE WHEN user_is_tgm (l.editor, 145) THEN TRUE WHEN user_is_tgm (l.tourist, 145) THEN TRUE ELSE FALSE END AND (offspring - CASE WHEN male_wean IS NULL THEN 0 ELSE male_wean END - CASE WHEN female_wean IS NULL THEN 0 ELSE female_wean END - CASE WHEN male_dead IS NULL THEN 0 ELSE male_dead END - CASE WHEN female_dead IS NULL THEN 0 ELSE female_dead END - CASE WHEN female_deceased IS NULL THEN 0 ELSE female_deceased END - CASE WHEN male_deceased IS NULL THEN 0 ELSE male_deceased END) <= 0 ORDER BY bday DESC, dam_name, sire_name;
Date: 2026-03-09 14:43:59 Duration: 3s581ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
6 546ms 27s19ms 1s739ms 1,440 41m44s 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 #6
Day Hour Count Duration Avg duration Mar 09 00 60 0ms 0ms 01 60 31s733ms 528ms 02 60 1m5s 1s94ms 03 60 1m5s 1s94ms 04 60 1m5s 1s94ms 05 60 1m5s 1s94ms 06 60 1m2s 1s49ms 07 60 59s763ms 996ms 08 60 2m37s 2s628ms 09 60 1m7s 1s116ms 10 60 46s552ms 775ms 11 60 1m5s 1s97ms 12 60 49s549ms 825ms 13 60 42s479ms 707ms 14 60 1m17s 1s286ms 15 60 49s171ms 819ms 16 60 1m6s 1s109ms 17 60 2m8s 2s136ms 18 60 2m8s 2s136ms 19 60 1m4s 1s75ms 20 60 37s261ms 621ms 21 60 9m12s 9s205ms 22 60 4m44s 4s738ms 23 60 4m30s 4s511ms [ User: labanimal - Total duration: 41m44s - 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-09 11:27:01 Duration: 27s19ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_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-09 21:13:02 Duration: 23s619ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_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-09 08:26:01 Duration: 8s563ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
7 546ms 27s19ms 1s739ms 1,440 41m44s 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 #7
Day Hour Count Duration Avg duration Mar 09 00 60 0ms 0ms 01 60 31s733ms 528ms 02 60 1m5s 1s94ms 03 60 1m5s 1s94ms 04 60 1m5s 1s94ms 05 60 1m5s 1s94ms 06 60 1m2s 1s49ms 07 60 59s763ms 996ms 08 60 2m37s 2s628ms 09 60 1m7s 1s116ms 10 60 46s552ms 775ms 11 60 1m5s 1s97ms 12 60 49s549ms 825ms 13 60 42s479ms 707ms 14 60 1m17s 1s286ms 15 60 49s171ms 819ms 16 60 1m6s 1s109ms 17 60 2m8s 2s136ms 18 60 2m8s 2s136ms 19 60 1m4s 1s75ms 20 60 37s261ms 621ms 21 60 9m12s 9s205ms 22 60 4m44s 4s738ms 23 60 4m30s 4s511ms [ User: labanimal - Total duration: 41m44s - 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-09 11:27:01 Duration: 27s19ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_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-09 21:13:02 Duration: 23s619ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_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-09 08:26:01 Duration: 8s563ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
8 546ms 27s19ms 1s739ms 1,440 41m44s create index if not exists idx_app_events_type on observability.app_events (event_type);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Mar 09 00 60 0ms 0ms 01 60 31s733ms 528ms 02 60 1m5s 1s94ms 03 60 1m5s 1s94ms 04 60 1m5s 1s94ms 05 60 1m5s 1s94ms 06 60 1m2s 1s49ms 07 60 59s763ms 996ms 08 60 2m37s 2s628ms 09 60 1m7s 1s116ms 10 60 46s552ms 775ms 11 60 1m5s 1s97ms 12 60 49s549ms 825ms 13 60 42s479ms 707ms 14 60 1m17s 1s286ms 15 60 49s171ms 819ms 16 60 1m6s 1s109ms 17 60 2m8s 2s136ms 18 60 2m8s 2s136ms 19 60 1m4s 1s75ms 20 60 37s261ms 621ms 21 60 9m12s 9s205ms 22 60 4m44s 4s738ms 23 60 4m30s 4s511ms [ User: labanimal - Total duration: 41m44s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-09 11:27:01 Duration: 27s19ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-09 21:13:02 Duration: 23s619ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-09 08:26:01 Duration: 8s563ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
9 546ms 27s19ms 1s739ms 1,440 41m44s create index if not exists idx_metrics_timeseries_bucket on observability.metrics_timeseries (bucket_start);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Mar 09 00 60 0ms 0ms 01 60 31s733ms 528ms 02 60 1m5s 1s94ms 03 60 1m5s 1s94ms 04 60 1m5s 1s94ms 05 60 1m5s 1s94ms 06 60 1m2s 1s49ms 07 60 59s763ms 996ms 08 60 2m37s 2s628ms 09 60 1m7s 1s116ms 10 60 46s552ms 775ms 11 60 1m5s 1s97ms 12 60 49s549ms 825ms 13 60 42s479ms 707ms 14 60 1m17s 1s286ms 15 60 49s171ms 819ms 16 60 1m6s 1s109ms 17 60 2m8s 2s136ms 18 60 2m8s 2s136ms 19 60 1m4s 1s75ms 20 60 37s261ms 621ms 21 60 9m12s 9s205ms 22 60 4m44s 4s738ms 23 60 4m30s 4s511ms [ User: labanimal - Total duration: 41m44s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-09 11:27:01 Duration: 27s19ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-09 21:13:02 Duration: 23s619ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-09 08:26:01 Duration: 8s563ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
10 546ms 27s19ms 1s739ms 1,440 41m44s 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 #10
Day Hour Count Duration Avg duration Mar 09 00 60 0ms 0ms 01 60 31s733ms 528ms 02 60 1m5s 1s94ms 03 60 1m5s 1s94ms 04 60 1m5s 1s94ms 05 60 1m5s 1s94ms 06 60 1m2s 1s49ms 07 60 59s763ms 996ms 08 60 2m37s 2s628ms 09 60 1m7s 1s116ms 10 60 46s552ms 775ms 11 60 1m5s 1s97ms 12 60 49s549ms 825ms 13 60 42s479ms 707ms 14 60 1m17s 1s286ms 15 60 49s171ms 819ms 16 60 1m6s 1s109ms 17 60 2m8s 2s136ms 18 60 2m8s 2s136ms 19 60 1m4s 1s75ms 20 60 37s261ms 621ms 21 60 9m12s 9s205ms 22 60 4m44s 4s738ms 23 60 4m30s 4s511ms [ User: labanimal - Total duration: 41m44s - 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-09 11:27:01 Duration: 27s19ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_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-09 21:13:02 Duration: 23s619ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_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-09 08:26:01 Duration: 8s563ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
11 546ms 27s19ms 1s739ms 1,440 41m44s create schema if not exists observability;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Mar 09 00 60 0ms 0ms 01 60 31s733ms 528ms 02 60 1m5s 1s94ms 03 60 1m5s 1s94ms 04 60 1m5s 1s94ms 05 60 1m5s 1s94ms 06 60 1m2s 1s49ms 07 60 59s763ms 996ms 08 60 2m37s 2s628ms 09 60 1m7s 1s116ms 10 60 46s552ms 775ms 11 60 1m5s 1s97ms 12 60 49s549ms 825ms 13 60 42s479ms 707ms 14 60 1m17s 1s286ms 15 60 49s171ms 819ms 16 60 1m6s 1s109ms 17 60 2m8s 2s136ms 18 60 2m8s 2s136ms 19 60 1m4s 1s75ms 20 60 37s261ms 621ms 21 60 9m12s 9s205ms 22 60 4m44s 4s738ms 23 60 4m30s 4s511ms [ User: labanimal - Total duration: 41m44s - Times executed: 1349 ]
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-09 11:27:01 Duration: 27s19ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-09 21:13:02 Duration: 23s619ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-09 08:26:01 Duration: 8s563ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
12 546ms 27s19ms 1s739ms 1,440 41m44s 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 #12
Day Hour Count Duration Avg duration Mar 09 00 60 0ms 0ms 01 60 31s733ms 528ms 02 60 1m5s 1s94ms 03 60 1m5s 1s94ms 04 60 1m5s 1s94ms 05 60 1m5s 1s94ms 06 60 1m2s 1s49ms 07 60 59s763ms 996ms 08 60 2m37s 2s628ms 09 60 1m7s 1s116ms 10 60 46s552ms 775ms 11 60 1m5s 1s97ms 12 60 49s549ms 825ms 13 60 42s479ms 707ms 14 60 1m17s 1s286ms 15 60 49s171ms 819ms 16 60 1m6s 1s109ms 17 60 2m8s 2s136ms 18 60 2m8s 2s136ms 19 60 1m4s 1s75ms 20 60 37s261ms 621ms 21 60 9m12s 9s205ms 22 60 4m44s 4s738ms 23 60 4m30s 4s511ms [ User: labanimal - Total duration: 41m44s - 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-09 11:27:01 Duration: 27s19ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_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-09 21:13:02 Duration: 23s619ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_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-09 08:26:01 Duration: 8s563ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
13 546ms 27s19ms 1s739ms 1,440 41m44s create index if not exists idx_metrics_timeseries_metric on observability.metrics_timeseries (metric_name);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Mar 09 00 60 0ms 0ms 01 60 31s733ms 528ms 02 60 1m5s 1s94ms 03 60 1m5s 1s94ms 04 60 1m5s 1s94ms 05 60 1m5s 1s94ms 06 60 1m2s 1s49ms 07 60 59s763ms 996ms 08 60 2m37s 2s628ms 09 60 1m7s 1s116ms 10 60 46s552ms 775ms 11 60 1m5s 1s97ms 12 60 49s549ms 825ms 13 60 42s479ms 707ms 14 60 1m17s 1s286ms 15 60 49s171ms 819ms 16 60 1m6s 1s109ms 17 60 2m8s 2s136ms 18 60 2m8s 2s136ms 19 60 1m4s 1s75ms 20 60 37s261ms 621ms 21 60 9m12s 9s205ms 22 60 4m44s 4s738ms 23 60 4m30s 4s511ms [ User: labanimal - Total duration: 41m44s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-09 11:27:01 Duration: 27s19ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-09 21:13:02 Duration: 23s619ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-09 08:26:01 Duration: 8s563ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
14 546ms 27s19ms 1s739ms 1,440 41m44s 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 09 00 60 0ms 0ms 01 60 31s733ms 528ms 02 60 1m5s 1s94ms 03 60 1m5s 1s94ms 04 60 1m5s 1s94ms 05 60 1m5s 1s94ms 06 60 1m2s 1s49ms 07 60 59s763ms 996ms 08 60 2m37s 2s628ms 09 60 1m7s 1s116ms 10 60 46s552ms 775ms 11 60 1m5s 1s97ms 12 60 49s549ms 825ms 13 60 42s479ms 707ms 14 60 1m17s 1s286ms 15 60 49s171ms 819ms 16 60 1m6s 1s109ms 17 60 2m8s 2s136ms 18 60 2m8s 2s136ms 19 60 1m4s 1s75ms 20 60 37s261ms 621ms 21 60 9m12s 9s205ms 22 60 4m44s 4s738ms 23 60 4m30s 4s511ms [ User: labanimal - Total duration: 41m44s - 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-09 11:27:01 Duration: 27s19ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_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-09 21:13:02 Duration: 23s619ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_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-09 08:26:01 Duration: 8s563ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
15 546ms 27s19ms 1s739ms 1,440 41m44s 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 09 00 60 0ms 0ms 01 60 31s733ms 528ms 02 60 1m5s 1s94ms 03 60 1m5s 1s94ms 04 60 1m5s 1s94ms 05 60 1m5s 1s94ms 06 60 1m2s 1s49ms 07 60 59s763ms 996ms 08 60 2m37s 2s628ms 09 60 1m7s 1s116ms 10 60 46s552ms 775ms 11 60 1m5s 1s97ms 12 60 49s549ms 825ms 13 60 42s479ms 707ms 14 60 1m17s 1s286ms 15 60 49s171ms 819ms 16 60 1m6s 1s109ms 17 60 2m8s 2s136ms 18 60 2m8s 2s136ms 19 60 1m4s 1s75ms 20 60 37s261ms 621ms 21 60 9m12s 9s205ms 22 60 4m44s 4s738ms 23 60 4m30s 4s511ms [ User: labanimal - Total duration: 41m44s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-09 11:27:01 Duration: 27s19ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-09 21:13:02 Duration: 23s619ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-09 08:26:01 Duration: 8s563ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
16 546ms 27s19ms 1s739ms 1,440 41m44s 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 #16
Day Hour Count Duration Avg duration Mar 09 00 60 0ms 0ms 01 60 31s733ms 528ms 02 60 1m5s 1s94ms 03 60 1m5s 1s94ms 04 60 1m5s 1s94ms 05 60 1m5s 1s94ms 06 60 1m2s 1s49ms 07 60 59s763ms 996ms 08 60 2m37s 2s628ms 09 60 1m7s 1s116ms 10 60 46s552ms 775ms 11 60 1m5s 1s97ms 12 60 49s549ms 825ms 13 60 42s479ms 707ms 14 60 1m17s 1s286ms 15 60 49s171ms 819ms 16 60 1m6s 1s109ms 17 60 2m8s 2s136ms 18 60 2m8s 2s136ms 19 60 1m4s 1s75ms 20 60 37s261ms 621ms 21 60 9m12s 9s205ms 22 60 4m44s 4s738ms 23 60 4m30s 4s511ms [ User: labanimal - Total duration: 41m44s - 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-09 11:27:01 Duration: 27s19ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_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-09 21:13:02 Duration: 23s619ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_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-09 08:26:01 Duration: 8s563ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
17 546ms 27s19ms 1s739ms 1,440 41m44s 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 #17
Day Hour Count Duration Avg duration Mar 09 00 60 0ms 0ms 01 60 31s733ms 528ms 02 60 1m5s 1s94ms 03 60 1m5s 1s94ms 04 60 1m5s 1s94ms 05 60 1m5s 1s94ms 06 60 1m2s 1s49ms 07 60 59s763ms 996ms 08 60 2m37s 2s628ms 09 60 1m7s 1s116ms 10 60 46s552ms 775ms 11 60 1m5s 1s97ms 12 60 49s549ms 825ms 13 60 42s479ms 707ms 14 60 1m17s 1s286ms 15 60 49s171ms 819ms 16 60 1m6s 1s109ms 17 60 2m8s 2s136ms 18 60 2m8s 2s136ms 19 60 1m4s 1s75ms 20 60 37s261ms 621ms 21 60 9m12s 9s205ms 22 60 4m44s 4s738ms 23 60 4m30s 4s511ms [ User: labanimal - Total duration: 41m44s - 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-09 11:27:01 Duration: 27s19ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_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-09 21:13:02 Duration: 23s619ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_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-09 08:26:01 Duration: 8s563ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
18 782ms 2s186ms 1s503ms 19 28s560ms 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 #18
Day Hour Count Duration Avg duration Mar 09 07 1 2s186ms 2s186ms 08 7 12s287ms 1s755ms 09 4 5s845ms 1s461ms 10 4 3s159ms 789ms 11 1 791ms 791ms 13 1 2s152ms 2s152ms 16 1 2s136ms 2s136ms [ User: labanimal - Total duration: 28s560ms - Times executed: 19 ]
[ Application: _desktop_index.php_command_animals_breedings_subcommand_select_ - Total duration: 7s144ms - Times executed: 9 ]
[ Application: _desktop_index.php_command_animals_litters_subcommand_init_zemm - Total duration: 6s386ms - Times executed: 3 ]
[ Application: _desktop_index.php_command_login_subcommand_init_zemm_produktiv - Total duration: 4s338ms - Times executed: 2 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 4s288ms - Times executed: 2 ]
[ Application: _desktop_index.php_command_reports_subcommand_task_status_zemm_ - Total duration: 2s137ms - Times executed: 1 ]
[ Application: _desktop_index.php_command_tasks_subcommand_init_zemm_produktiv - Total duration: 2s133ms - Times executed: 1 ]
[ Application: _desktop_index.php_command_animals_breedings_subcommand_init_ze - Total duration: 2s131ms - Times executed: 1 ]
-
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, 228) THEN TRUE WHEN user_is_tgm (dam.editor, 228) THEN TRUE WHEN user_is_tgm (dam.tourist, 228) 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, 228) THEN TRUE WHEN user_is_tgm (sire.editor, 228) THEN TRUE WHEN user_is_tgm (sire.tourist, 228) 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-09 07:36:37 Duration: 2s186ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_command_login_subcommand_init_zemm_produktiv Log file: /var/log/postgresql/postgresql-2026-03-09_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, 10100178) THEN TRUE WHEN user_is_tgm (dam.editor, 10100178) THEN TRUE WHEN user_is_tgm (dam.tourist, 10100178) 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, 10100178) THEN TRUE WHEN user_is_tgm (sire.editor, 10100178) THEN TRUE WHEN user_is_tgm (sire.tourist, 10100178) 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-09 13:57:59 Duration: 2s152ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-09_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, 10100116) THEN TRUE WHEN user_is_tgm (dam.editor, 10100116) THEN TRUE WHEN user_is_tgm (dam.tourist, 10100116) 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, 10100116) THEN TRUE WHEN user_is_tgm (sire.editor, 10100116) THEN TRUE WHEN user_is_tgm (sire.tourist, 10100116) 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-09 08:12:58 Duration: 2s151ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_command_login_subcommand_init_zemm_produktiv Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
19 763ms 979ms 909ms 6 5s458ms select p_update_breedings (?, null, ?, ?::date, null, ?::text, ?::text, null) as id;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 09 06 1 943ms 943ms 12 1 939ms 939ms 13 3 2s596ms 865ms 15 1 979ms 979ms [ User: labanimal - Total duration: 5s458ms - Times executed: 6 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 4s515ms - Times executed: 5 ]
[ Application: _desktop_index.php_command_tasks_subcommand_open_zemm_produktiv - Total duration: 943ms - Times executed: 1 ]
-
SELECT p_update_breedings (456, NULL, 13374, '2026-03-09'::date, NULL, '10288360'::text, '10281356'::text, NULL) AS id;
Date: 2026-03-09 15:30:15 Duration: 979ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
SELECT p_update_breedings (343, NULL, 10101174, '2026-03-09'::date, NULL, '10289401'::text, '10289404'::text, NULL) AS id;
Date: 2026-03-09 06:53:27 Duration: 943ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_command_tasks_subcommand_open_zemm_produktiv Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
SELECT p_update_breedings (343, NULL, 8258, '2026-03-09'::date, NULL, '10284298'::text, '10296930;10296931'::text, NULL) AS id;
Date: 2026-03-09 12:59:54 Duration: 939ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
20 655ms 7s954ms 906ms 60 54s385ms 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 not exists ( select ? from scoresheet_diary sd where sd.animals_id = animals_search_mview.id) 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 09 07 5 3s365ms 673ms 08 7 19s152ms 2s736ms 09 3 1s973ms 657ms 11 9 5s949ms 661ms 12 13 8s638ms 664ms 13 4 2s654ms 663ms 14 8 5s324ms 665ms 15 2 1s331ms 665ms 16 7 4s668ms 666ms 19 2 1s327ms 663ms [ User: labanimal - Total duration: 54s385ms - Times executed: 60 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 25s267ms - Times executed: 38 ]
[ Application: _desktop_index.php_command_animals_subcommand_task_status_zemm_ - Total duration: 15s855ms - Times executed: 2 ]
[ Application: _desktop_index.php_command_login_subcommand_init_zemm_produktiv - Total duration: 7s257ms - Times executed: 11 ]
[ Application: _desktop_index.php_command_reports_subcommand_init_zemm_produkt - Total duration: 3s365ms - Times executed: 5 ]
[ Application: _desktop_index.php_command_tasks_subcommand_open_zemm_produktiv - Total duration: 1s325ms - Times executed: 2 ]
[ Application: _desktop_index.php_command_home_subcommand_task_status_zemm_pro - Total duration: 659ms - Times executed: 1 ]
[ Application: _desktop_index.php_command_home_subcommand_init_zemm_produktiv_ - Total duration: 656ms - 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, 10100113) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100113) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100113) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview 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 = 6 AND alive = 't' AND deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-03-09 08:25:47 Duration: 7s954ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_command_animals_subcommand_task_status_zemm_ Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
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, 10100113) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100113) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100113) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview 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 = 6 AND alive = 't' AND deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-03-09 08:26:03 Duration: 7s901ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_command_animals_subcommand_task_status_zemm_ Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
-
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, 540) AS is_owner, user_is_tgm (animals_search_mview.editor, 540) AS is_editor, user_is_tgm (animals_search_mview.tourist, 540) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview 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-09 14:03:39 Duration: 685ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-09_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
- 133,147 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 16 FATAL entries
- 21 ERROR entries
- 4 WARNING entries
- 9 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 12 Max number of times the same event was reported
- 50 Total events found
Rank Times reported Error 1 12 FATAL: password authentication failed for user "..."
Times Reported Most Frequent Error / Event #1
Day Hour Count Mar 09 10 8 11 2 12 2 - FATAL: password authentication failed for user "labanimal"
- FATAL: password authentication failed for user "labanimal"
- FATAL: password authentication failed for user "deploy"
Detail: Connection matched file "/etc/postgresql/18/main/pg_hba.conf" line 27: "host all all ::1/128 scram-sha-256"
Date: 2026-03-09 10:12:34 Database: zemm_produktiv_8 Application: User: labanimal Remote: ::1 Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
Detail: Connection matched file "/etc/postgresql/18/main/pg_hba.conf" line 27: "host all all ::1/128 scram-sha-256"
Date: 2026-03-09 10:12:34 Database: zemm_produktiv_8 Application: User: labanimal Remote: ::1 Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
Detail: User "deploy" has no password assigned. Connection matched file "/etc/postgresql/18/main/pg_hba.conf" line 27: "host all all ::1/128 scram-sha-256"
Date: 2026-03-09 10:37:02 Database: user='labanimal' Application: User: deploy Remote: ::1 Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
2 10 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Mar 09 05 2 10 2 13 4 16 2 - FATAL: database "monitoring" does not exist
- FATAL: database "monitoring" does not exist
- FATAL: database "monitoring" does not exist
Date: 2026-03-09 05:18:09 Database: monitoring Application: User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
Date: 2026-03-09 05:18:09 Database: monitoring Application: User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
Date: 2026-03-09 10:37:26 Database: monitoring Application: User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
3 5 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count Mar 09 08 3 10 2 - ERROR: column l.cage does not exist
- ERROR: column "name" does not exist
- ERROR: column "link_type" does not exist
Statement: select l.id, c.name, coalesce(l."maleCount",0), coalesce(l."femaleCount",0), coalesce(l.offspring,0) from litters l join cages c on c.id=l.cage where c.name in ('17-001','17-002') order by l.id desc limit 10;
Date: 2026-03-09 08:14:20 Database: zemm_produktiv_7 Application: psql User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
Statement: select id, name from cages where name in ('17-001','17-002');
Date: 2026-03-09 08:14:32 Database: zemm_produktiv_7 Application: psql User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
Statement: select id,name,link,link_type,link_content from tasks where id=10141484;
Date: 2026-03-09 08:54:08 Database: zemm_produktiv_8 Application: psql User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
4 4 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Mar 09 07 1 08 3 - ERROR: syntax error at or near ";"
- ERROR: syntax error at or near ";"
- ERROR: syntax error at or near "SQL"
Statement: SELECT a.id, a.name, a.species, a."animalID", a.species as "species", a.sex as "sex" , a.sterile, a."birthDate", a."arrivalDate", a.alive, a."outgoingDate", a."deathDate" , a.fate, a.comments, cages."cageName", a."homeCage", a.project , a.breeding AS breeding, cages.breeding AS breeding_cage, a.dummy_line_info, a.dummy_strain_info , a.dummy_gen_info as gene_1, a.gen_1_typ as gene_1_type, a.gen_2_info as gene_2, a.gen_2_typ as gene_2_type, a.gen_3_info as gene_3, a.gen_3_typ as gene_3_type, a.gen_4_info as gene_4, a.gen_4_typ as gene_4_type, a.gen_5_info as gene_5, a.gen_5_typ as gene_5_type , a.generation, a.dummy_backcross_info, a.cohort, a.litter, a.genecomment , fat.name as sire_name , fat.id as sire_db_id , fat."animalID" as sire_id , mot.name as dam_name , mot.id as dam_db_id , mot."animalID" as dam_id , tr.rfid as rfid , tr.insertion_date as transpondered_at , owner.is_owner AS is_owner , editor.is_editor AS is_editor , tourist.is_tourist AS is_tourist FROM animals AS a LEFT OUTER JOIN cages ON cages.id=a."homeCage" LEFT OUTER JOIN fates ON fates.id=a.fate LEFT OUTER JOIN animals fat ON CAST(a."parentMale" AS BIGINT) = fat.id LEFT OUTER JOIN animals mot ON CAST(a."parentFemale" AS BIGINT) = mot.id LEFT OUTER JOIN transponders tr ON tr.maps_to = a.id AND tr.extraction_date IS NULL LEFT JOIN (SELECT animals.id AS animal, MAX(CASE WHEN ow.user = 183 OR owg.user = 183 THEN 1 ELSE 0 END) AS is_owner FROM animals LEFT OUTER JOIN "targetgroupMembers" ow ON ow.targetgroup = animals.owner LEFT OUTER JOIN "groupMembers" owg ON owg.group = ow.group GROUP BY animals.id) owner ON owner.animal = a.id LEFT JOIN (SELECT animals.id AS animal, MAX(CASE WHEN ed.user = 183 OR edg.user = 183 THEN 1 ELSE 0 END) AS is_editor FROM animals LEFT OUTER JOIN "targetgroupMembers" ed ON ed.targetgroup = animals.editor LEFT OUTER JOIN "groupMembers" edg ON edg.group = ed.group GROUP BY animals.id) editor ON editor.animal = a.id LEFT JOIN (SELECT animals.id AS animal, MAX(CASE WHEN tou.user = 183 OR toug.user = 183 THEN 1 ELSE 0 END) AS is_tourist FROM animals LEFT OUTER JOIN "targetgroupMembers" tou ON tou.targetgroup = animals.tourist LEFT OUTER JOIN "groupMembers" toug ON toug.group = tou.group GROUP BY animals.id) tourist ON tourist.animal = a.id WHERE a.id= ;
Date: 2026-03-09 07:14:27 Database: zemm_produktiv_8 Application: _desktop_index.php_command_animals_edit_subcommand_init_zemm_pr User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
Statement: SELECT a.id, a.name, a.species, a."animalID", a.species as "species", a.sex as "sex" , a.sterile, a."birthDate", a."arrivalDate", a.alive, a."outgoingDate", a."deathDate" , a.fate, a.comments, cages."cageName", a."homeCage", a.project , a.breeding AS breeding, cages.breeding AS breeding_cage, a.dummy_line_info, a.dummy_strain_info , a.dummy_gen_info as gene_1, a.gen_1_typ as gene_1_type, a.gen_2_info as gene_2, a.gen_2_typ as gene_2_type, a.gen_3_info as gene_3, a.gen_3_typ as gene_3_type, a.gen_4_info as gene_4, a.gen_4_typ as gene_4_type, a.gen_5_info as gene_5, a.gen_5_typ as gene_5_type , a.generation, a.dummy_backcross_info, a.cohort, a.litter, a.genecomment , fat.name as sire_name , fat.id as sire_db_id , fat."animalID" as sire_id , mot.name as dam_name , mot.id as dam_db_id , mot."animalID" as dam_id , tr.rfid as rfid , tr.insertion_date as transpondered_at , owner.is_owner AS is_owner , editor.is_editor AS is_editor , tourist.is_tourist AS is_tourist FROM animals AS a LEFT OUTER JOIN cages ON cages.id=a."homeCage" LEFT OUTER JOIN fates ON fates.id=a.fate LEFT OUTER JOIN animals fat ON CAST(a."parentMale" AS BIGINT) = fat.id LEFT OUTER JOIN animals mot ON CAST(a."parentFemale" AS BIGINT) = mot.id LEFT OUTER JOIN transponders tr ON tr.maps_to = a.id AND tr.extraction_date IS NULL LEFT JOIN (SELECT animals.id AS animal, MAX(CASE WHEN ow.user = 10100118 OR owg.user = 10100118 THEN 1 ELSE 0 END) AS is_owner FROM animals LEFT OUTER JOIN "targetgroupMembers" ow ON ow.targetgroup = animals.owner LEFT OUTER JOIN "groupMembers" owg ON owg.group = ow.group GROUP BY animals.id) owner ON owner.animal = a.id LEFT JOIN (SELECT animals.id AS animal, MAX(CASE WHEN ed.user = 10100118 OR edg.user = 10100118 THEN 1 ELSE 0 END) AS is_editor FROM animals LEFT OUTER JOIN "targetgroupMembers" ed ON ed.targetgroup = animals.editor LEFT OUTER JOIN "groupMembers" edg ON edg.group = ed.group GROUP BY animals.id) editor ON editor.animal = a.id LEFT JOIN (SELECT animals.id AS animal, MAX(CASE WHEN tou.user = 10100118 OR toug.user = 10100118 THEN 1 ELSE 0 END) AS is_tourist FROM animals LEFT OUTER JOIN "targetgroupMembers" tou ON tou.targetgroup = animals.tourist LEFT OUTER JOIN "groupMembers" toug ON toug.group = tou.group GROUP BY animals.id) tourist ON tourist.animal = a.id WHERE a.id= ;
Date: 2026-03-09 08:00:18 Database: zemm_produktiv_8 Application: _desktop_index.php_command_animals_edit_subcommand_open_zemm_pr User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
Statement: SQL
Date: 2026-03-09 08:18:38 Database: zemm_produktiv_8 Application: psql User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
5 3 ERROR: operator does not exist: bigint = character varying
Times Reported Most Frequent Error / Event #5
Day Hour Count Mar 09 09 3 - ERROR: operator does not exist: bigint = character varying
- ERROR: operator does not exist: bigint = character varying
- ERROR: operator does not exist: bigint = character varying
Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT a.*, (SELECT COALESCE(a1."name", '') || ' ' || COALESCE(a1."animalID", '') FROM animals a1 WHERE a1."id" = a."parentMale") AS "parentMaleName", (SELECT COALESCE(a2."name", '') || ' ' || COALESCE(a2."animalID", '') FROM animals a2 WHERE a2."id" = a."parentFemale") AS "parentFemaleName" FROM ( SELECT a.* FROM animals a WHERE a."homeCage" = 10869 AND (a."alive" = TRUE OR a."fate" = 5 ) AND NOT(a.deleted) UNION ALL SELECT a.* FROM animals a WHERE a."curCage" = 10869 AND (a."homeCage" IS NULL OR a."homeCage" <> 10869) AND (a."alive" = TRUE OR a."fate" = 5 ) AND NOT(a.deleted) ) a ORDER BY a."parentMale", a."parentFemale", a."sex", a."animalID", a."name"Date: 2026-03-09 09:11:10 Database: zemm_produktiv_8 Application: backend:zemm_produktiv_8@localhost User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT a.*, (SELECT COALESCE(a1."name", '') || ' ' || COALESCE(a1."animalID", '') FROM animals a1 WHERE a1."id" = a."parentMale") AS "parentMaleName", (SELECT COALESCE(a2."name", '') || ' ' || COALESCE(a2."animalID", '') FROM animals a2 WHERE a2."id" = a."parentFemale") AS "parentFemaleName" FROM ( SELECT a.* FROM animals a WHERE a."homeCage" = 10869 AND (a."alive" = TRUE OR a."fate" = 5 ) AND NOT(a.deleted) UNION ALL SELECT a.* FROM animals a WHERE a."curCage" = 10869 AND (a."homeCage" IS NULL OR a."homeCage" <> 10869) AND (a."alive" = TRUE OR a."fate" = 5 ) AND NOT(a.deleted) ) a ORDER BY a."parentMale", a."parentFemale", a."sex", a."animalID", a."name"Date: 2026-03-09 09:11:16 Database: zemm_produktiv_8 Application: backend:zemm_produktiv_8@localhost User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT a.*, (SELECT COALESCE(a1."name", '') || ' ' || COALESCE(a1."animalID", '') FROM animals a1 WHERE a1."id" = a."parentMale") AS "parentMaleName", (SELECT COALESCE(a2."name", '') || ' ' || COALESCE(a2."animalID", '') FROM animals a2 WHERE a2."id" = a."parentFemale") AS "parentFemaleName" FROM ( SELECT a.* FROM animals a WHERE a."homeCage" = 10869 AND (a."alive" = TRUE OR a."fate" = 5 ) AND NOT(a.deleted) UNION ALL SELECT a.* FROM animals a WHERE a."curCage" = 10869 AND (a."homeCage" IS NULL OR a."homeCage" <> 10869) AND (a."alive" = TRUE OR a."fate" = 5 ) AND NOT(a.deleted) ) a ORDER BY a."parentMale", a."parentFemale", a."sex", a."animalID", a."name"Date: 2026-03-09 09:11:44 Database: zemm_produktiv_8 Application: backend:zemm_produktiv_8@localhost User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
6 2 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #6
Day Hour Count Mar 09 12 2 - LOG: could not receive data from client: Connection reset by peer
- LOG: could not receive data from client: Connection reset by peer
Date: 2026-03-09 12:51:43 Database: zemm_monitoring Application: User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
Date: 2026-03-09 12:51:44 Database: zemm_produktiv_8 Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
7 2 ERROR: function p_wean_males(...) does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Mar 09 07 2 - ERROR: function p_wean_males(integer, bigint, integer, integer, unknown, character varying, character varying, text, date, character varying, character varying, character varying, character varying, character varying, character varying, character varying, character varying, character varying, character varying, character varying, text, text, bigint) does not exist
- ERROR: function p_wean_males(integer, bigint, integer, integer, unknown, character varying, character varying, text, date, character varying, character varying, character varying, character varying, character varying, character varying, character varying, character varying, character varying, character varying, character varying, text, text, bigint) does not exist
Context: PL/pgSQL function p_wean_litter(bigint,date,bigint,bigint,integer,integer,integer,integer,integer,text,timestamp without time zone,bigint,text) line 190 at FOR over SELECT rows
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT public.p_wean_litter($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13) AS payloadDate: 2026-03-09 07:33:55 Database: zemm_produktiv_7 Application: zemm_produktiv_7_localhost_5432 User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
Context: PL/pgSQL function p_wean_litter(bigint,date,bigint,bigint,integer,integer,integer,integer,integer,text,timestamp without time zone,bigint,text) line 190 at FOR over SELECT rows
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT public.p_wean_litter($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13) AS payloadDate: 2026-03-09 07:36:13 Database: zemm_produktiv_7 Application: zemm_produktiv_7_localhost_5432 User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
8 2 WARNING: there is no transaction in progress
Times Reported Most Frequent Error / Event #8
Day Hour Count Mar 09 07 2 - WARNING: there is no transaction in progress
- WARNING: there is no transaction in progress
Date: 2026-03-09 07:38:08 Database: zemm_produktiv_7 Application: zemm_produktiv_7_localhost_5432 User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
Date: 2026-03-09 07:39:25 Database: zemm_produktiv_7 Application: zemm_produktiv_7_localhost_5432 User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
9 2 WARNING: there is already a transaction in progress
Times Reported Most Frequent Error / Event #9
Day Hour Count Mar 09 07 2 - WARNING: there is already a transaction in progress
- WARNING: there is already a transaction in progress
Date: 2026-03-09 07:38:07 Database: zemm_produktiv_7 Application: zemm_produktiv_7_localhost_5432 User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
Date: 2026-03-09 07:39:25 Database: zemm_produktiv_7 Application: zemm_produktiv_7_localhost_5432 User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
10 1 ERROR: date/time field value out of range: "..."
Times Reported Most Frequent Error / Event #10
Day Hour Count Mar 09 05 1 - ERROR: date/time field value out of range: "20245-01-0"
Hint: Perhaps you need a different "DateStyle" setting.
Statement: SELECT tk.id, tk.name, tk.active, tk.task_status, tk.done, tk.prio_agent, tk.deadline, tk.link, STRING_AGG(DISTINCT issuer_user."fullName", ';') AS issued_by, tk.time_issued, STRING_AGG(DISTINCT agent_user."fullName" ,';')AS completed_by, tk.time_completed FROM tasks tk INNER JOIN "targetgroupMembers" issuer ON issuer.targetgroup = tk.owner INNER JOIN (SELECT "targetgroupMembers".targetgroup, users.* FROM "targetgroupMembers" INNER JOIN users ON users.id = "targetgroupMembers"."user") issuer_user ON issuer_user.targetgroup = tk.owner LEFT JOIN "targetgroupMembers" agent ON agent.targetgroup = tk.agent LEFT JOIN (SELECT "targetgroupMembers".targetgroup, users.* FROM "targetgroupMembers" INNER JOIN users ON users.id = "targetgroupMembers"."user") agent_user ON agent_user.targetgroup = tk.agent WHERE TRUE AND tk.task_status LIKE '2' AND tk.deadline >= '2027-01-01' AND tk.deadline <= '20245-01-0' GROUP BY tk.idDate: 2026-03-09 05:33:51 Database: zemm_produktiv_8 Application: _desktop_index.php_command_tasks_subcommand_init_zemm_produktiv User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
11 1 ERROR: Zu viele Maennchen zum Absetzen angegeben.
Times Reported Most Frequent Error / Event #11
Day Hour Count Mar 09 07 1 - ERROR: Zu viele Maennchen zum Absetzen angegeben.
Context: PL/pgSQL function p_wean_litter(bigint,date,bigint,bigint,integer,integer,integer,integer,integer,text,timestamp without time zone,bigint,text) line 141 at RAISE
Statement: SELECT public.p_wean_litter($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13) AS payloadDate: 2026-03-09 07:34:08 Database: zemm_produktiv_7 Application: zemm_produktiv_7_localhost_5432 User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
12 1 ERROR: value too long for type character varying(...)
Times Reported Most Frequent Error / Event #12
Day Hour Count Mar 09 08 1 - ERROR: value too long for type character varying(45)
Context: SQL statement "INSERT INTO tasks (id, "owner", "agent", "name", "parent", "order", "active") VALUES ( taskID , tgOwner , tgAgent , taskName , taskParent , taskOrder , false )" PL/pgSQL function task_create(character varying,bigint,smallint) line 45 at SQL statement SQL statement "SELECT task_create(v_task_name::varchar, NULL::bigint, v_order)" PL/pgSQL function inline_code_block line 15 at SQL statement
Statement: DO $$ DECLARE v_user_id bigint := 1; v_task_id bigint; v_task_name text := 'Prüfung Käfigkarten 54-111/112/116/117/129/130'; v_task_comment text := 'Temporäre Prüfaufgabe: enthält genau die Tiere aus dem Käfigkarten-PDF vom 09.03.2026 zur Kontrolle des Haltungskartendrucks.'; v_order smallint; v_animal_list text; BEGIN SELECT COALESCE(MAX("order"), 0) + 1 INTO v_order FROM tasks WHERE parent IS NULL; SELECT task_create(v_task_name::varchar, NULL::bigint, v_order) INTO v_task_id; UPDATE tasks SET active = true, task_status = '2', issuer = v_user_id, time_issued = DATE_TRUNC('minute', NOW()), "comment" = v_task_comment, instructions = 'Bitte die an dieser Aufgabe angehängten Tiere für den Käfigkartendruck prüfen.' WHERE id = v_task_id; INSERT INTO "targetgroupMembers" (targetgroup, "user") SELECT t.owner, v_user_id FROM tasks t WHERE t.id = v_task_id AND NOT EXISTS ( SELECT 1 FROM "targetgroupMembers" m WHERE m.targetgroup = t.owner AND m."user" = v_user_id ); INSERT INTO "targetgroupMembers" (targetgroup, "user") SELECT t.agent, v_user_id FROM tasks t WHERE t.id = v_task_id AND NOT EXISTS ( SELECT 1 FROM "targetgroupMembers" m WHERE m.targetgroup = t.agent AND m."user" = v_user_id ); SELECT 'animals:' || string_agg(a.id::text, ':' ORDER BY c."cageName", a.sex, a."animalID", a."name") INTO v_animal_list FROM cages c JOIN animals a ON ( a."homeCage" = c.id OR (a."curCage" = c.id AND (a."homeCage" IS NULL OR a."homeCage" <> c.id)) ) WHERE c.id IN (10869,10870,10874,10875,10887,10888) AND NOT c.deleted AND NOT a.deleted AND (a.alive = TRUE OR a.fate = 5); PERFORM p_update_animals_tasks(v_user_id, v_task_id, v_animal_list); RAISE NOTICE 'created task id=%', v_task_id; END $$;Date: 2026-03-09 08:50:19 Database: zemm_produktiv_8 Application: psql User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
13 1 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #13
Day Hour Count Mar 09 12 1 - ERROR: relation "observability.app_events" does not exist
Statement: SELECT created_at, tenant_key, event_type, severity, COALESCE(payload->>'job_name','') AS job_name, COALESCE(payload->>'status','') AS status, COALESCE(payload->>'details','') AS details FROM observability.app_events WHERE event_type = 'cron_run' AND COALESCE(payload->>'job_name','') = 'notification' ORDER BY created_at DESC LIMIT 10;
Date: 2026-03-09 12:33:04 Database: zemm_produktiv_7 Application: User: mcp_ro Remote: Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
14 1 ERROR: Zielkaefig fuer Maennchen nicht gefunden.
Times Reported Most Frequent Error / Event #14
Day Hour Count Mar 09 07 1 - ERROR: Zielkaefig fuer Maennchen nicht gefunden.
Context: PL/pgSQL function p_wean_litter(bigint,date,bigint,bigint,integer,integer,integer,integer,integer,text,timestamp without time zone,bigint,text) line 87 at RAISE
Statement: SELECT public.p_wean_litter($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13) AS payloadDate: 2026-03-09 07:32:55 Database: zemm_produktiv_7 Application: zemm_produktiv_7_localhost_5432 User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
15 1 ERROR: function p_update_animals_tasks(...) does not exist
Times Reported Most Frequent Error / Event #15
Day Hour Count Mar 09 08 1 - ERROR: function p_update_animals_tasks(bigint, bigint, text) does not exist
Context: PL/pgSQL function inline_code_block line 56 at PERFORM
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: DO $$ DECLARE v_user_id bigint := 1; v_task_id bigint; v_task_name text := 'Prüfung Käfigkarten 54-111 bis 54-130'; v_task_comment text := 'Temporäre Prüfaufgabe: enthält genau die Tiere aus dem Käfigkarten-PDF vom 09.03.2026 zur Kontrolle des Haltungskartendrucks.'; v_order smallint; v_animal_list text; BEGIN SELECT COALESCE(MAX("order"), 0) + 1 INTO v_order FROM tasks WHERE parent IS NULL; SELECT task_create(v_task_name::varchar, NULL::bigint, v_order) INTO v_task_id; UPDATE tasks SET active = true, task_status = '2', issuer = v_user_id, time_issued = DATE_TRUNC('minute', NOW()), "comment" = v_task_comment, instructions = 'Bitte die an dieser Aufgabe angehängten Tiere für den Käfigkartendruck prüfen.' WHERE id = v_task_id; INSERT INTO "targetgroupMembers" (targetgroup, "user") SELECT t.owner, v_user_id FROM tasks t WHERE t.id = v_task_id AND NOT EXISTS ( SELECT 1 FROM "targetgroupMembers" m WHERE m.targetgroup = t.owner AND m."user" = v_user_id ); INSERT INTO "targetgroupMembers" (targetgroup, "user") SELECT t.agent, v_user_id FROM tasks t WHERE t.id = v_task_id AND NOT EXISTS ( SELECT 1 FROM "targetgroupMembers" m WHERE m.targetgroup = t.agent AND m."user" = v_user_id ); SELECT 'animals:' || string_agg(a.id::text, ':' ORDER BY c."cageName", a.sex, a."animalID", a."name") INTO v_animal_list FROM cages c JOIN animals a ON ( a."homeCage" = c.id OR (a."curCage" = c.id AND (a."homeCage" IS NULL OR a."homeCage" <> c.id)) ) WHERE c.id IN (10869,10870,10874,10875,10887,10888) AND NOT c.deleted AND NOT a.deleted AND (a.alive = TRUE OR a.fate = 5); PERFORM p_update_animals_tasks(v_user_id, v_task_id, v_animal_list); RAISE NOTICE 'created task id=%', v_task_id; END $$;Date: 2026-03-09 08:50:36 Database: zemm_produktiv_8 Application: psql User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
16 1 ERROR: invalid input syntax for type timestamp: ...
Times Reported Most Frequent Error / Event #16
Day Hour Count Mar 09 14 1 - ERROR: invalid input syntax for type timestamp: "2026-0309"
Statement: SELECT tk.id, tk.name, tk.active, tk.task_status, tk.done, tk.prio_agent, tk.deadline, tk.link, STRING_AGG(DISTINCT issuer_user."fullName", ';') AS issued_by, tk.time_issued, STRING_AGG(DISTINCT agent_user."fullName" ,';')AS completed_by, tk.time_completed FROM tasks tk INNER JOIN "targetgroupMembers" issuer ON issuer.targetgroup = tk.owner INNER JOIN (SELECT "targetgroupMembers".targetgroup, users.* FROM "targetgroupMembers" INNER JOIN users ON users.id = "targetgroupMembers"."user") issuer_user ON issuer_user.targetgroup = tk.owner LEFT JOIN "targetgroupMembers" agent ON agent.targetgroup = tk.agent LEFT JOIN (SELECT "targetgroupMembers".targetgroup, users.* FROM "targetgroupMembers" INNER JOIN users ON users.id = "targetgroupMembers"."user") agent_user ON agent_user.targetgroup = tk.agent WHERE (user_is_tgm(tk.owner, 183) OR user_is_tgm(tk.agent, 183)) AND tk.task_status LIKE '2' AND ((issuer_user.id = 183)) AND ((agent_user.id = 425)) AND tk.time_completed >= '2026-0309' GROUP BY tk.id
Date: 2026-03-09 14:44:21 Database: zemm_produktiv_8 Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv
17 1 ERROR: invalid input syntax for type date: ...
Times Reported Most Frequent Error / Event #17
Day Hour Count Mar 09 07 1 - ERROR: invalid input syntax for type date: "2023-096-1"
Statement: SELECT tk.id, tk.name, tk.active, tk.task_status, tk.done, tk.prio_agent, tk.deadline, tk.link, STRING_AGG(DISTINCT issuer_user."fullName", ';') AS issued_by, tk.time_issued, STRING_AGG(DISTINCT agent_user."fullName" ,';')AS completed_by, tk.time_completed FROM tasks tk INNER JOIN "targetgroupMembers" issuer ON issuer.targetgroup = tk.owner INNER JOIN (SELECT "targetgroupMembers".targetgroup, users.* FROM "targetgroupMembers" INNER JOIN users ON users.id = "targetgroupMembers"."user") issuer_user ON issuer_user.targetgroup = tk.owner LEFT JOIN "targetgroupMembers" agent ON agent.targetgroup = tk.agent LEFT JOIN (SELECT "targetgroupMembers".targetgroup, users.* FROM "targetgroupMembers" INNER JOIN users ON users.id = "targetgroupMembers"."user") agent_user ON agent_user.targetgroup = tk.agent WHERE (user_is_tgm(tk.owner, 412) OR user_is_tgm(tk.agent, 412)) AND tk.task_status LIKE '2' AND tk.deadline >= '2023-06-19' AND tk.deadline <= '2023-096-1' GROUP BY tk.id
Date: 2026-03-09 07:08:40 Database: zemm_produktiv_8 Application: _desktop_index.php_command_login_subcommand_init_zemm_produktiv User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-09_000000.csv