ZEMM PG Report-
Global information
- Generated on Thu Apr 30 06:05:28 2026
- Log file: /var/log/postgresql/postgresql-2026-03-25_000000.csv, ..., /var/log/postgresql/postgresql-2026-04-30_000000.csv
- Parsed 237,724 log entries in 5m27s
- Log start from 2026-04-01 00:00:01 to 2026-04-01 23:59:03
-
Overview
Global Stats
- 41 Number of unique normalized queries
- 18,813 Number of queries
- 1d13h39m12s Total query duration
- 2026-04-01 00:00:01 First query
- 2026-04-01 23:59:01 Last query
- 14 queries/s at 2026-04-01 01:30:02 Query peak
- 1d13h39m12s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 1d13h39m12s Execute total duration
- 157 Number of events
- 4 Number of unique normalized events
- 152 Max number of times the same event was reported
- 0 Number of cancellation
- 68 Total number of automatic vacuums
- 131 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 22,294 Total number of sessions
- 4 sessions at 2026-04-01 12:54:33 Session peak
- 1h8m36s Total duration of sessions
- 184ms Average duration of sessions
- 0 Average queries per session
- 6s80ms Average queries duration per session
- 0ms Average idle time per session
- 22,446 Total number of connections
- 44 connections/s at 2026-04-01 23:18:26 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 14 queries/s Query Peak
- 2026-04-01 01:30:02 Date
SELECT Traffic
Key values
- 2 queries/s Query Peak
- 2026-04-01 17:16:29 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 14 queries/s Query Peak
- 2026-04-01 01:30:02 Date
Queries duration
Key values
- 1d13h39m12s 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) Apr 01 00 780 0ms 0ms 0ms 0ms 0ms 0ms 01 781 0ms 977ms 473ms 12s706ms 12s706ms 12s706ms 02 780 977ms 977ms 977ms 12s706ms 12s706ms 12s706ms 03 780 977ms 977ms 977ms 12s706ms 12s706ms 12s706ms 04 780 977ms 977ms 977ms 12s706ms 12s706ms 12s706ms 05 784 723ms 977ms 859ms 12s706ms 12s706ms 15s622ms 06 780 726ms 726ms 726ms 9s445ms 9s445ms 9s445ms 07 781 726ms 823ms 818ms 10s704ms 10s704ms 10s704ms 08 799 508ms 1s616ms 780ms 12s605ms 14s164ms 22s641ms 09 788 508ms 1s707ms 604ms 8s985ms 9s969ms 11s459ms 10 785 639ms 720ms 639ms 8s322ms 8s322ms 11s31ms 11 781 639ms 1s611ms 705ms 8s309ms 20s950ms 20s950ms 12 791 649ms 1s738ms 962ms 12s538ms 14s340ms 21s914ms 13 787 652ms 1s646ms 696ms 10s380ms 11s918ms 12s943ms 14 786 502ms 916ms 910ms 11s918ms 11s918ms 16s48ms 15 792 649ms 770ms 741ms 10s15ms 10s15ms 14s175ms 16 780 656ms 656ms 656ms 8s528ms 8s528ms 8s528ms 17 788 647ms 739ms 652ms 8s528ms 8s528ms 14s37ms 18 781 651ms 798ms 665ms 10s382ms 10s382ms 11s180ms 19 781 798ms 846ms 836ms 11s5ms 11s5ms 11s228ms 20 781 846ms 1s163ms 883ms 15s129ms 15s129ms 15s129ms 21 781 801ms 1s163ms 933ms 15s129ms 15s129ms 15s930ms 22 780 801ms 801ms 801ms 10s413ms 10s413ms 10s413ms 23 786 552ms 2m56s 2m35s 38m16s 38m16s 38m23s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Apr 01 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 4 0 728ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 12 0 805ms 0ms 969ms 1s628ms 09 7 0 733ms 0ms 0ms 1s348ms 10 4 0 677ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 9 0 793ms 0ms 0ms 1s709ms 13 5 0 749ms 0ms 0ms 1s397ms 14 6 0 688ms 0ms 0ms 0ms 15 12 0 690ms 0ms 0ms 2s763ms 16 0 0 0ms 0ms 0ms 0ms 17 8 0 688ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 1 5 30s516ms 0ms 0ms 6s430ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Apr 01 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 1 0 0 977ms 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 Apr 01 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 Apr 01 00 505 0.14/s 01 247 0.07/s 02 250 0.07/s 03 245 0.07/s 04 251 0.07/s 05 359 0.10/s 06 552 0.15/s 07 1,234 0.34/s 08 1,869 0.52/s 09 989 0.27/s 10 1,215 0.34/s 11 1,605 0.45/s 12 1,445 0.40/s 13 2,282 0.63/s 14 1,674 0.47/s 15 1,608 0.45/s 16 1,155 0.32/s 17 905 0.25/s 18 986 0.27/s 19 939 0.26/s 20 830 0.23/s 21 756 0.21/s 22 249 0.07/s 23 296 0.08/s Day Hour Count Average Duration Average idle time Apr 01 00 497 250ms 250ms 01 247 298ms 0ms 02 248 290ms 0ms 03 244 296ms 0ms 04 251 285ms 0ms 05 304 286ms 0ms 06 552 160ms 0ms 07 1,227 140ms 0ms 08 1,825 220ms 0ms 09 982 165ms 0ms 10 1,207 208ms 0ms 11 1,588 135ms 0ms 12 1,445 174ms 0ms 13 2,282 138ms 0ms 14 1,674 147ms 0ms 15 1,608 168ms 0ms 16 1,155 135ms 0ms 17 905 159ms 0ms 18 986 143ms 0ms 19 939 151ms 0ms 20 827 186ms 0ms 21 756 190ms 0ms 22 249 311ms 0ms 23 296 922ms 0ms -
Connections
Established Connections
Key values
- 44 connections Connection Peak
- 2026-04-01 23:18:26 Date
Connections per database
Key values
- zemm_monitoring Main Database
- 22,446 connections Total
Connections per user
Key values
- labanimal Main User
- 22,446 connections Total
-
Sessions
Simultaneous sessions
Key values
- 4 sessions Session Peak
- 2026-04-01 12:54:33 Date
Histogram of session times
Key values
- 19,994 0-500ms duration
Sessions per database
Key values
- zemm_monitoring Main Database
- 22,294 sessions Total
Sessions per user
Key values
- labanimal Main User
- 22,294 sessions Total
Sessions per host
Key values
- ::1 Main Host
- 22,294 sessions Total
Sessions per application
Key values
- Main Application
- 22,294 sessions Total
Application Count Total Duration Average Duration 18,946 52m23s 165ms DBeaver 24.3.2 - Main 'zemm_produktiv_7' 2 24s445ms 12s222ms DBeaver 24.3.2 - Main 'zemm_produktiv_8' 1 12s816ms 12s816ms _backend_cage_autocomplete_api.php_q_2025_limit_12_zemm_produkt 6 159ms 26ms _backend_cage_autocomplete_api.php_q_55-065_limit_12_zemm_produ 6 173ms 28ms _backend_wean_api.php_litter_id_10130227_zemm_produktiv_7_local 30 4s285ms 142ms _backend_wean_api.php_litter_id_10130236_zemm_produktiv_7_local 30 4s413ms 147ms _backend_wean_api.php_litter_id_10130257_zemm_produktiv_7_local 36 5s259ms 146ms _backend_wean_api.php_litter_id_10131606_zemm_produktiv_8_local 2 275ms 137ms _backend_wean_api.php_litter_id_10131607_zemm_produktiv_8_local 2 280ms 140ms _backend_wean_api.php_litter_id_10131767_zemm_produktiv_8_local 2 283ms 141ms _backend_wean_api.php_litter_id_10131948_zemm_produktiv_8_local 2 279ms 139ms _backend_wean_api.php_litter_id_10131979_zemm_produktiv_8_local 2 280ms 140ms _desktop__zemm_produktiv_7_localhost_5432 7 466ms 66ms _desktop__zemm_produktiv_8_localhost_5432 18 1s127ms 62ms _desktop_index.php_animal_name_24_animal_id_2025_2F002_2F5751_s 1 47ms 47ms _desktop_index.php_cages_name_28_cages_empty__25_val4_cages_sea 1 58ms 58ms _desktop_index.php_cages_name_71_2A_cages_empty__25_val4_cages_ 1 502ms 502ms _desktop_index.php_cages_name_A15_2A_cages_empty__25_val4_cages 11 13s325ms 1s211ms _desktop_index.php_command_animals_breedings_subcommand_select_ 6 334ms 55ms _desktop_index.php_command_animals_create_subcommand_init_zemm_ 6 400ms 66ms _desktop_index.php_command_animals_edit_subcommand_init_id_1028 2 219ms 109ms _desktop_index.php_command_animals_edit_subcommand_init_id_1030 1 103ms 103ms _desktop_index.php_command_animals_edit_subcommand_link_init_va 6 662ms 110ms _desktop_index.php_command_animals_edit_subcommand_m_init_scree 6 739ms 123ms _desktop_index.php_command_animals_litters_edit_subcommand_init 6 684ms 114ms _desktop_index.php_command_animals_litters_edit_subcommand_m_in 6 1s912ms 318ms _desktop_index.php_command_animals_litters_subcommand_select_ze 6 308ms 51ms _desktop_index.php_command_animals_subcommand_init_zemm_produkt 24 1s102ms 45ms _desktop_index.php_command_animals_subcommand_select_zemm_produ 6 416ms 69ms _desktop_index.php_command_cages_edit_subcommand_init_id_101015 1 62ms 62ms _desktop_index.php_command_cages_edit_subcommand_init_id_101017 1 69ms 69ms _desktop_index.php_command_cages_subcommand_init_zemm_produktiv 7 296ms 42ms _desktop_index.php_command_home_subcommand_init_zemm_produktiv_ 1 93ms 93ms _desktop_index.php_command_licences_subcommand_edit_species_id_ 1 49ms 49ms _desktop_index.php_command_login_subcommand_init_zemm_produktiv 279 8s588ms 30ms _desktop_index.php_command_reports_subcommand_animals_per_room_ 4 526ms 131ms _desktop_index.php_command_reports_subcommand_animals_per_user_ 9 987ms 109ms _desktop_index.php_command_reports_subcommand_fates_zemm_produk 6 682ms 113ms _desktop_index.php_command_reports_subcommand_init_zemm_produkt 15 3s937ms 262ms _desktop_index.php_command_reports_subcommand_task_status_zemm_ 2 219ms 109ms _desktop_index.php_command_tasks_subcommand_edit_id_10134267_ze 6 533ms 88ms _desktop_index.php_command_tasks_subcommand_init_search_zemm_pr 6 293ms 48ms _desktop_index.php_command_tasks_subcommand_open_zemm_produktiv 51 4s538ms 88ms _desktop_index.php_command_tasks_subcommand_search_zemm_produkt 6 300ms 50ms _desktop_index.php_m_action_animals_edit_3Alink_init_row_animal 1 54ms 54ms _desktop_index.php_m_action_cages_3Am_delete_command_animals_su 6 276ms 46ms _desktop_index.php_view_animal_id_on_breeding__25_sex__25_in_br 1 465ms 465ms _desktop_index.php_view_animal_name_on_animal_name_2026_2F000_2 1 257ms 257ms _desktop_index.php_view_animal_name_on_view_animal_id_on_animal 1 235ms 235ms _desktop_index.php_view_animal_name_on_view_animal_id_on_specie 1 1s911ms 1s911ms _desktop_index.php_view_animal_name_on_view_animal_id_on_view_b 18 7s732ms 429ms _desktop_index.php_view_animal_name_on_view_animal_id_on_view_s 13 9s635ms 741ms _desktop_index.php_zemm_produktiv_7_localhost_5432 152 42s709ms 280ms _desktop_index.php_zemm_produktiv_8_localhost_5432 2,382 9m39s 243ms backend:zemm_produktiv_8@localhost 53 4s69ms 76ms expire_tasks:zemm_produktiv_8@h2940066.stratoserver.net:5432 1 1s2ms 1s2ms pg_dump 1 14s513ms 14s513ms psql 38 30s333ms 798ms strainscron:zemm_produktiv_8@h2940066.stratoserver.net:5432 1 2m57s 2m57s taskscron:zemm_produktiv_7@zemm.fbiscience.eu 24 606ms 25ms taskscron:zemm_produktiv_8@h2940066.stratoserver.net:5432 24 6s151ms 256ms -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 18,504 buffers Checkpoint Peak
- 2026-04-01 01:34:44 Date
- 269.965 seconds Highest write time
- 0.047 seconds Sync time
Checkpoints Wal files
Key values
- 5 files Wal files usage Peak
- 2026-04-01 09:29:50 Date
Checkpoints distance
Key values
- 170.91 Mo Distance Peak
- 2026-04-01 01:34:44 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Apr 01 00 2,475 248.131s 0.073s 248.266s 01 20,844 504.186s 0.075s 504.344s 02 2,268 227.466s 0.071s 227.591s 03 2,027 203.311s 0.073s 203.436s 04 2,025 203.118s 0.073s 203.249s 05 2,078 208.435s 0.077s 208.568s 06 6,359 550.911s 0.116s 551.076s 07 6,655 666.484s 0.133s 666.676s 08 47,676 1,430.908s 0.242s 1,431.216s 09 16,691 614.934s 0.182s 615.173s 10 5,978 599.007s 0.135s 599.19s 11 5,223 523.124s 0.183s 523.361s 12 29,696 952.079s 0.203s 952.352s 13 16,174 828.75s 0.213s 829.047s 14 18,218 733.658s 0.153s 733.87s 15 5,251 525.997s 0.149s 526.2s 16 3,338 334.732s 0.122s 334.904s 17 2,816 282.436s 0.089s 282.582s 18 3,256 326.46s 0.081s 326.598s 19 4,700 470.511s 0.086s 470.65s 20 5,690 551.803s 0.078s 551.938s 21 3,085 309.207s 0.116s 309.381s 22 2,484 249.109s 0.072s 249.227s 23 3,170 317.511s 0.071s 317.631s Day Hour Added Removed Recycled Synced files Longest sync Average sync Apr 01 00 0 1 0 354 0.001s 0.012s 01 0 3 5 380 0.001s 0.012s 02 0 0 1 352 0.001s 0.012s 03 0 0 1 350 0.002s 0.012s 04 0 0 0 347 0.002s 0.012s 05 0 0 1 384 0.002s 0.012s 06 0 0 2 615 0.002s 0.012s 07 0 0 1 733 0.002s 0.012s 08 0 0 14 1,435 0.002s 0.012s 09 0 0 6 915 0.005s 0.012s 10 0 0 2 733 0.003s 0.012s 11 0 0 2 974 0.004s 0.012s 12 0 0 9 1,157 0.002s 0.012s 13 0 0 7 1,003 0.005s 0.012s 14 0 0 5 815 0.002s 0.012s 15 0 0 2 774 0.004s 0.012s 16 0 0 1 648 0.003s 0.012s 17 0 0 1 459 0.002s 0.012s 18 0 0 1 397 0.002s 0.012s 19 0 0 1 417 0.001s 0.012s 20 0 0 2 374 0.002s 0.012s 21 0 0 1 364 0.028s 0.013s 22 0 0 1 332 0.002s 0.012s 23 0 0 1 347 0.002s 0.012s Day Hour Count Avg time (sec) Apr 01 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 Apr 01 00 1,127.92 kB 3,488.92 kB 01 11,314.50 kB 36,520.33 kB 02 1,059.08 kB 29,813.08 kB 03 1,013.67 kB 9,174.92 kB 04 1,016.42 kB 3,318.92 kB 05 1,030.83 kB 1,673.67 kB 06 2,094.00 kB 4,235.08 kB 07 2,322.92 kB 7,411.33 kB 08 18,914.25 kB 39,481.33 kB 09 7,811.17 kB 49,959.33 kB 10 2,716.83 kB 23,797.75 kB 11 2,178.00 kB 8,048.75 kB 12 12,810.67 kB 38,502.92 kB 13 9,125.67 kB 49,191.17 kB 14 7,321.50 kB 36,426.25 kB 15 2,844.00 kB 12,777.50 kB 16 1,355.58 kB 4,701.08 kB 17 1,216.92 kB 2,242.00 kB 18 1,403.92 kB 1,717.67 kB 19 1,826.08 kB 4,112.92 kB 20 2,130.50 kB 6,550.00 kB 21 1,388.17 kB 3,363.83 kB 22 1,135.58 kB 1,832.75 kB 23 1,327.25 kB 2,324.92 kB -
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Apr 01 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.84 sec Highest CPU-cost vacuum
Table public.tasks
Database zemm_produktiv_8 - 2026-04-01 01:30:22 Date
- 0 sec Highest CPU-cost analyze
Table
Database zemm_produktiv_8 - Date
Average Autovacuum Duration
Key values
- 0.84 sec Highest CPU-cost vacuum
Table public.tasks
Database zemm_produktiv_8 - 2026-04-01 01:30:22 Date
Analyzes per table
Key values
- pg_catalog.pg_type (31) Main table analyzed (database zemm_produktiv_8)
- 131 analyzes Total
Table Number of analyzes zemm_produktiv_8.pg_catalog.pg_type 31 zemm_produktiv_8.pg_catalog.pg_attribute 22 zemm_produktiv_8.pg_catalog.pg_class 16 zemm_produktiv_8.pg_catalog.pg_depend 14 zemm_produktiv_8.public.breedingsdams 12 zemm_produktiv_8.public.breedingssires 12 zemm_produktiv_8.public.cages_search_mview 4 zemm_test_3.pg_catalog.pg_shdepend 3 zemm_monitoring.pg_catalog.pg_shdepend 2 zemm_monitoring.observability.metrics_timeseries 2 zemm_produktiv_8.public.users 2 zemm_produktiv_8.public.tmptasks 2 zemm_monitoring.observability.app_events 1 zemm_produktiv_7.pg_catalog.pg_class 1 zemm_produktiv_8.public.cages 1 zemm_produktiv_7.pg_catalog.pg_type 1 zemm_produktiv_7.pg_catalog.pg_depend 1 zemm_produktiv_8.public.tasks 1 zemm_monitoring.observability.db_top_queries 1 labanimal.pg_catalog.pg_shdepend 1 zemm_monitoring.observability.system_metrics 1 Total 131 Vacuums per table
Key values
- public.breedingssires (12) Main table vacuumed on database zemm_produktiv_8
- 68 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.public.breedingssires 12 0 0 0 0 0 0 1,777 194 613,102 0 0 zemm_produktiv_8.public.breedingsdams 12 0 0 0 0 0 0 2,376 243 821,095 0 0 zemm_produktiv_8.pg_catalog.pg_type 10 10 0 0 0 0 0 526 110 111,664 0 0 zemm_produktiv_8.pg_catalog.pg_attribute 7 7 0 0 0 0 0 897 307 206,523 0 0 zemm_produktiv_8.pg_catalog.pg_class 6 6 0 0 0 0 0 592 197 237,934 2 2 zemm_monitoring.pg_toast.pg_toast_67431 6 0 0 0 0 0 0 4,233 1,420 3,226,098 1,396 8,376 zemm_produktiv_8.pg_catalog.pg_depend 4 4 0 0 0 0 0 494 140 164,524 0 0 zemm_produktiv_8.pg_toast.pg_toast_2619 3 3 0 0 0 0 0 566 130 666,228 29 87 zemm_produktiv_8.public.cages_search_mview 2 2 0 0 0 0 0 1,136 586 1,974,605 34 693 zemm_produktiv_8.public.tasks 1 1 0 0 0 0 0 43,800 18,357 37,224,296 14,972 46,679 zemm_produktiv_7.public.cages_search_mview 1 1 0 0 0 0 0 151 47 49,875 0 0 zemm_monitoring.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 114 19 129,975 8 25 zemm_produktiv_8.public.tmptasks 1 1 0 0 0 0 0 56 20 11,947 0 0 zemm_produktiv_8.public.users 1 1 0 0 0 0 0 191 86 211,297 52 118 zemm_test_3.pg_catalog.pg_shdepend 1 1 0 0 0 0 0 89 21 45,520 0 0 Total 68 38 0 0 0 0 0 56,998 21,877 45,694,683 16,493 55,980 Vacuum throughput per table
Key values
- public.tasks (0.84) Max CPU elapsed for vacuum on database zemm_produktiv_8
- public.cages_search_mview (0.14 ms) Max I/O read time for vacuum on database zemm_produktiv_8
- public.breedingssires (0.312 ms) Max I/O write time for vacuum on database zemm_produktiv_8
I/O timing (ms) CPU (s) Table read write elapsed zemm_produktiv_8.public.breedingssires 0 0.312 0 zemm_produktiv_8.public.breedingsdams 0 0.19 0 zemm_produktiv_8.pg_catalog.pg_type 0 0 0 zemm_produktiv_8.pg_catalog.pg_attribute 0 0 0.06 zemm_produktiv_8.pg_catalog.pg_class 0 0 0.01 zemm_monitoring.pg_toast.pg_toast_67431 0 0 0.3 zemm_produktiv_8.pg_catalog.pg_depend 0 0 0.02 zemm_produktiv_8.pg_toast.pg_toast_2619 0 0 0.02 zemm_produktiv_8.public.cages_search_mview 0 0 0.15 zemm_produktiv_8.public.tasks 0 0 0.84 zemm_produktiv_7.public.cages_search_mview 0.14 0 0.01 zemm_monitoring.pg_toast.pg_toast_2619 0 0 0 zemm_produktiv_8.public.tmptasks 0 0 0 zemm_produktiv_8.public.users 0 0 0.02 zemm_test_3.pg_catalog.pg_shdepend 0 0 0 Total 0.14 0.502 1.43 Tuples removed per table
Key values
- public.tasks (53531) Main table with removed tuples on database zemm_produktiv_8
- 68733 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain zemm_produktiv_8.public.tasks 1 1 53,531 56,626 0 0 16,661 zemm_produktiv_8.pg_catalog.pg_attribute 7 7 7,061 40,196 0 0 1,288 zemm_produktiv_8.pg_catalog.pg_depend 4 4 3,491 16,684 0 0 220 zemm_produktiv_8.pg_catalog.pg_type 10 10 2,000 8,310 0 0 310 zemm_produktiv_8.pg_catalog.pg_class 6 6 891 5,364 0 0 252 zemm_test_3.pg_catalog.pg_shdepend 1 1 517 3,849 0 0 38 zemm_produktiv_7.public.cages_search_mview 1 1 476 11,623 0 0 249 zemm_produktiv_8.pg_toast.pg_toast_2619 3 3 338 843 0 0 318 zemm_produktiv_8.public.users 1 1 179 755 0 0 108 zemm_produktiv_8.public.cages_search_mview 2 2 117 27,258 0 0 453 zemm_produktiv_8.public.tmptasks 1 1 68 853 0 0 115 zemm_monitoring.pg_toast.pg_toast_2619 1 1 64 81 0 0 37 zemm_produktiv_8.public.breedingssires 12 0 0 269,809 0 0 1,728 zemm_monitoring.pg_toast.pg_toast_67431 6 0 0 1,605,144 0 0 268,526 zemm_produktiv_8.public.breedingsdams 12 0 0 364,542 0 0 2,328 Total 68 38 68,733 2,411,937 0 0 292,631 Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Pages removed per tables
NO DATASET
Table Number of vacuums Index scans Tuples removed Pages removed zemm_produktiv_8.public.breedingssires 12 0 0 0 zemm_produktiv_8.public.cages_search_mview 2 2 117 0 zemm_produktiv_8.public.tasks 1 1 53531 0 zemm_produktiv_7.public.cages_search_mview 1 1 476 0 zemm_produktiv_8.pg_catalog.pg_class 6 6 891 0 zemm_monitoring.pg_toast.pg_toast_2619 1 1 64 0 zemm_produktiv_8.public.tmptasks 1 1 68 0 zemm_produktiv_8.pg_catalog.pg_type 10 10 2000 0 zemm_produktiv_8.public.users 1 1 179 0 zemm_monitoring.pg_toast.pg_toast_67431 6 0 0 0 zemm_produktiv_8.pg_catalog.pg_attribute 7 7 7061 0 zemm_test_3.pg_catalog.pg_shdepend 1 1 517 0 zemm_produktiv_8.pg_toast.pg_toast_2619 3 3 338 0 zemm_produktiv_8.pg_catalog.pg_depend 4 4 3491 0 zemm_produktiv_8.public.breedingsdams 12 0 0 0 Total 68 38 68,733 0 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Apr 01 00 0 0 01 2 1 02 1 0 03 0 0 04 0 0 05 0 0 06 3 2 07 2 9 08 19 40 09 5 7 10 1 6 11 7 13 12 13 19 13 7 12 14 3 7 15 1 3 16 1 7 17 0 0 18 1 3 19 1 2 20 0 0 21 0 0 22 1 0 23 0 0 - 0.84 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
- 68 Total read queries
- 18,745 Total write queries
Queries by database
Key values
- zemm_monitoring Main database
- 18,720 Requests
- 1d13h34m58s (zemm_monitoring)
- Main time consuming database
Queries by user
Key values
- labanimal Main user
- 169,352 Requests
User Request type Count Duration deploy Total 11 8s527ms ddl 9 6s902ms others 2 1s624ms labanimal Total 169,352 3d8h41m9s copy from 8 18s286ms copy to 40 1m50s cte 99 2m32s ddl 168,314 3d8h18m56s others 164 1m26s select 705 15m40s tcl 2 1s129ms update 9 9s714ms postgres Total 45 58s258ms copy to 45 58s258ms Duration by user
Key values
- 3d8h41m9s (labanimal) Main time consuming user
User Request type Count Duration deploy Total 11 8s527ms ddl 9 6s902ms others 2 1s624ms labanimal Total 169,352 3d8h41m9s copy from 8 18s286ms copy to 40 1m50s cte 99 2m32s ddl 168,314 3d8h18m56s others 164 1m26s select 705 15m40s tcl 2 1s129ms update 9 9s714ms postgres Total 45 58s258ms copy to 45 58s258ms Queries by host
Key values
- unknown Main host
- 169,342 Requests
- 3d8h38m2s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 18,720 Requests
- 1d13h34m58s (unknown)
- Main time consuming application
Application Request type Count Duration _desktop_index.php_view_animal_name_on_view_animal_id_on_specie Total 2 1s558ms select 2 1s558ms _desktop_index.php_zemm_produktiv_7_localhost_5432 Total 10 8s147ms cte 6 5s231ms select 4 2s915ms _desktop_index.php_zemm_produktiv_8_localhost_5432 Total 67 54s766ms cte 6 9s996ms select 61 44s769ms expire_tasks:zemm_produktiv_8@h2940066.stratoserver.net:5432 Total 1 977ms update 1 977ms pg_dump Total 5 6s430ms copy to 5 6s430ms psql Total 7 5s278ms ddl 7 5s278ms strainscron:zemm_produktiv_8@h2940066.stratoserver.net:5432 Total 1 2m56s select 1 2m56s unknown Total 18,720 1d13h34m58s ddl 18,720 1d13h34m58s Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-04-01 09:24:55 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 71 500-1000ms duration
Slowest individual queries
Rank Duration Query 1 2m56s SELECT str.name AS Linie, str.comments AS Eigentuemer, ( SELECT COUNT(a.animal_id) FROM animals_search_mview a WHERE a.alive = 't' AND a.deleted = 'f' AND a.strain = str.name AND a.outgoing_date IS NULL AND a.death_date IS NULL) AS tiere_lebend, ( SELECT MAX(a.death_date) FROM animals_search_mview a WHERE a.deleted = 'f' AND a.strain = str.name) AS zuletzt_gestorbenes_tier, ( SELECT MAX(a.outgoing_date) FROM animals_search_mview a WHERE a.alive = 't' AND a.deleted = 'f' AND a.strain = str.name) AS zuletzt_lebend_verlassenes_Tier FROM strains str WHERE str.deleted = '0' AND str.active = '1' GROUP BY str.name, str.comments;[ Date: 2026-04-01 23:02:57 - Database: zemm_produktiv_8 - User: labanimal - Remote: 81.169.238.237 - Application: strainscron:zemm_produktiv_8@h2940066.stratoserver.net:5432 ]
2 2m56s CREATE SCHEMA IF NOT EXISTS observability;[ Date: 2026-04-01 23:03:01 - Database: zemm_monitoring - User: labanimal ]
3 2m56s 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-04-01 23:03:01 - Database: zemm_monitoring - User: labanimal ]
4 2m56s CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);[ Date: 2026-04-01 23:03:01 - Database: zemm_monitoring - User: labanimal ]
5 2m56s CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);[ Date: 2026-04-01 23:03:01 - Database: zemm_monitoring - User: labanimal ]
6 2m56s 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-04-01 23:03:01 - Database: zemm_monitoring - User: labanimal ]
7 2m56s CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);[ Date: 2026-04-01 23:03:01 - Database: zemm_monitoring - User: labanimal ]
8 2m56s CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);[ Date: 2026-04-01 23:03:01 - Database: zemm_monitoring - User: labanimal ]
9 2m56s 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-04-01 23:03:01 - Database: zemm_monitoring - User: labanimal ]
10 2m56s CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);[ Date: 2026-04-01 23:03:01 - Database: zemm_monitoring - User: labanimal ]
11 2m56s 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-04-01 23:03:01 - Database: zemm_monitoring - User: labanimal ]
12 2m56s 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-04-01 23:03:01 - Database: zemm_monitoring - User: labanimal ]
13 2m56s CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );[ Date: 2026-04-01 23:03:01 - Database: zemm_monitoring - User: labanimal ]
14 2m56s 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-04-01 23:03:01 - Database: zemm_monitoring - User: labanimal ]
15 2m56s CREATE SCHEMA IF NOT EXISTS observability;[ Date: 2026-04-01 23:04:01 - Database: zemm_monitoring - User: labanimal ]
16 2m56s 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-04-01 23:04:01 - Database: zemm_monitoring - User: labanimal ]
17 2m56s CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);[ Date: 2026-04-01 23:04:01 - Database: zemm_monitoring - User: labanimal ]
18 2m56s CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);[ Date: 2026-04-01 23:04:01 - Database: zemm_monitoring - User: labanimal ]
19 2m56s 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-04-01 23:04:01 - Database: zemm_monitoring - User: labanimal ]
20 2m56s CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);[ Date: 2026-04-01 23:04:01 - Database: zemm_monitoring - User: labanimal ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 2h53m27s 1,440 508ms 2m56s 7s227ms create index if not exists idx_app_events_tenant on observability.app_events (tenant_key, occurred_at desc);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Apr 01 01 60 0ms 0ms 02 60 28s345ms 472ms 03 60 58s645ms 977ms 04 60 58s645ms 977ms 05 60 58s645ms 977ms 06 60 51s621ms 860ms 07 60 43s594ms 726ms 08 60 49s114ms 818ms 09 60 46s748ms 779ms 10 60 36s117ms 601ms 11 60 38s366ms 639ms 12 60 42s239ms 703ms 13 60 57s755ms 962ms 14 60 41s664ms 694ms 15 60 54s716ms 911ms 16 60 44s519ms 741ms 17 60 39s362ms 656ms 18 60 39s148ms 652ms 19 60 39s949ms 665ms 20 60 50s172ms 836ms 21 60 53s17ms 883ms 22 60 56s42ms 934ms 23 60 48s60ms 801ms 00 60 2h36m11s 2m36s [ User: labanimal - Total duration: 2h53m27s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-04-01 23:55:01 Duration: 2m56s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-04-01 08:22:01 Duration: 1s616ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-04-01 12:00:01 Duration: 1s611ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
2 2h53m27s 1,440 508ms 2m56s 7s227ms 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 #2
Day Hour Count Duration Avg duration Apr 01 01 60 0ms 0ms 02 60 28s345ms 472ms 03 60 58s645ms 977ms 04 60 58s645ms 977ms 05 60 58s645ms 977ms 06 60 51s621ms 860ms 07 60 43s594ms 726ms 08 60 49s114ms 818ms 09 60 46s748ms 779ms 10 60 36s117ms 601ms 11 60 38s366ms 639ms 12 60 42s239ms 703ms 13 60 57s755ms 962ms 14 60 41s664ms 694ms 15 60 54s716ms 911ms 16 60 44s519ms 741ms 17 60 39s362ms 656ms 18 60 39s148ms 652ms 19 60 39s949ms 665ms 20 60 50s172ms 836ms 21 60 53s17ms 883ms 22 60 56s42ms 934ms 23 60 48s60ms 801ms 00 60 2h36m11s 2m36s [ User: labanimal - Total duration: 2h53m27s - 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-04-01 23:55:01 Duration: 2m56s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_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-04-01 08:22:01 Duration: 1s616ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_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-04-01 12:00:01 Duration: 1s611ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
3 2h53m27s 1,440 508ms 2m56s 7s227ms 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 Apr 01 01 60 0ms 0ms 02 60 28s345ms 472ms 03 60 58s645ms 977ms 04 60 58s645ms 977ms 05 60 58s645ms 977ms 06 60 51s621ms 860ms 07 60 43s594ms 726ms 08 60 49s114ms 818ms 09 60 46s748ms 779ms 10 60 36s117ms 601ms 11 60 38s366ms 639ms 12 60 42s239ms 703ms 13 60 57s755ms 962ms 14 60 41s664ms 694ms 15 60 54s716ms 911ms 16 60 44s519ms 741ms 17 60 39s362ms 656ms 18 60 39s148ms 652ms 19 60 39s949ms 665ms 20 60 50s172ms 836ms 21 60 53s17ms 883ms 22 60 56s42ms 934ms 23 60 48s60ms 801ms 00 60 2h36m11s 2m36s [ User: labanimal - Total duration: 2h53m27s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-04-01 23:55:01 Duration: 2m56s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-04-01 08:22:01 Duration: 1s616ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-04-01 12:00:01 Duration: 1s611ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
4 2h53m27s 1,440 508ms 2m56s 7s227ms 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 #4
Day Hour Count Duration Avg duration Apr 01 01 60 0ms 0ms 02 60 28s345ms 472ms 03 60 58s645ms 977ms 04 60 58s645ms 977ms 05 60 58s645ms 977ms 06 60 51s621ms 860ms 07 60 43s594ms 726ms 08 60 49s114ms 818ms 09 60 46s748ms 779ms 10 60 36s117ms 601ms 11 60 38s366ms 639ms 12 60 42s239ms 703ms 13 60 57s755ms 962ms 14 60 41s664ms 694ms 15 60 54s716ms 911ms 16 60 44s519ms 741ms 17 60 39s362ms 656ms 18 60 39s148ms 652ms 19 60 39s949ms 665ms 20 60 50s172ms 836ms 21 60 53s17ms 883ms 22 60 56s42ms 934ms 23 60 48s60ms 801ms 00 60 2h36m11s 2m36s [ User: labanimal - Total duration: 2h53m27s - 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-04-01 23:55:01 Duration: 2m56s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_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-04-01 08:22:01 Duration: 1s616ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_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-04-01 12:00:01 Duration: 1s611ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
5 2h53m27s 1,440 508ms 2m56s 7s227ms create table if not exists observability.system_metrics ( id bigserial primary key, payload jsonb not null, collected_at timestamptz not null default now() );Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Apr 01 01 60 0ms 0ms 02 60 28s345ms 472ms 03 60 58s645ms 977ms 04 60 58s645ms 977ms 05 60 58s645ms 977ms 06 60 51s621ms 860ms 07 60 43s594ms 726ms 08 60 49s114ms 818ms 09 60 46s748ms 779ms 10 60 36s117ms 601ms 11 60 38s366ms 639ms 12 60 42s239ms 703ms 13 60 57s755ms 962ms 14 60 41s664ms 694ms 15 60 54s716ms 911ms 16 60 44s519ms 741ms 17 60 39s362ms 656ms 18 60 39s148ms 652ms 19 60 39s949ms 665ms 20 60 50s172ms 836ms 21 60 53s17ms 883ms 22 60 56s42ms 934ms 23 60 48s60ms 801ms 00 60 2h36m11s 2m36s [ User: labanimal - Total duration: 2h53m27s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-01 23:55:01 Duration: 2m56s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-01 08:22:01 Duration: 1s616ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-01 12:00:01 Duration: 1s611ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
6 2h53m27s 1,440 508ms 2m56s 7s227ms 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 #6
Day Hour Count Duration Avg duration Apr 01 01 60 0ms 0ms 02 60 28s345ms 472ms 03 60 58s645ms 977ms 04 60 58s645ms 977ms 05 60 58s645ms 977ms 06 60 51s621ms 860ms 07 60 43s594ms 726ms 08 60 49s114ms 818ms 09 60 46s748ms 779ms 10 60 36s117ms 601ms 11 60 38s366ms 639ms 12 60 42s239ms 703ms 13 60 57s755ms 962ms 14 60 41s664ms 694ms 15 60 54s716ms 911ms 16 60 44s519ms 741ms 17 60 39s362ms 656ms 18 60 39s148ms 652ms 19 60 39s949ms 665ms 20 60 50s172ms 836ms 21 60 53s17ms 883ms 22 60 56s42ms 934ms 23 60 48s60ms 801ms 00 60 2h36m11s 2m36s [ User: labanimal - Total duration: 2h53m27s - 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-04-01 23:55:01 Duration: 2m56s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_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-04-01 08:22:01 Duration: 1s616ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_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-04-01 12:00:01 Duration: 1s611ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
7 2h53m27s 1,440 508ms 2m56s 7s227ms create schema if not exists observability;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Apr 01 01 60 0ms 0ms 02 60 28s345ms 472ms 03 60 58s645ms 977ms 04 60 58s645ms 977ms 05 60 58s645ms 977ms 06 60 51s621ms 860ms 07 60 43s594ms 726ms 08 60 49s114ms 818ms 09 60 46s748ms 779ms 10 60 36s117ms 601ms 11 60 38s366ms 639ms 12 60 42s239ms 703ms 13 60 57s755ms 962ms 14 60 41s664ms 694ms 15 60 54s716ms 911ms 16 60 44s519ms 741ms 17 60 39s362ms 656ms 18 60 39s148ms 652ms 19 60 39s949ms 665ms 20 60 50s172ms 836ms 21 60 53s17ms 883ms 22 60 56s42ms 934ms 23 60 48s60ms 801ms 00 60 2h36m11s 2m36s [ User: labanimal - Total duration: 2h53m27s - Times executed: 1349 ]
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-04-01 23:55:01 Duration: 2m56s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-04-01 08:22:01 Duration: 1s616ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-04-01 12:00:01 Duration: 1s611ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
8 2h53m27s 1,440 508ms 2m56s 7s227ms 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 #8
Day Hour Count Duration Avg duration Apr 01 01 60 0ms 0ms 02 60 28s345ms 472ms 03 60 58s645ms 977ms 04 60 58s645ms 977ms 05 60 58s645ms 977ms 06 60 51s621ms 860ms 07 60 43s594ms 726ms 08 60 49s114ms 818ms 09 60 46s748ms 779ms 10 60 36s117ms 601ms 11 60 38s366ms 639ms 12 60 42s239ms 703ms 13 60 57s755ms 962ms 14 60 41s664ms 694ms 15 60 54s716ms 911ms 16 60 44s519ms 741ms 17 60 39s362ms 656ms 18 60 39s148ms 652ms 19 60 39s949ms 665ms 20 60 50s172ms 836ms 21 60 53s17ms 883ms 22 60 56s42ms 934ms 23 60 48s60ms 801ms 00 60 2h36m11s 2m36s [ User: labanimal - Total duration: 2h53m27s - 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-04-01 23:55:01 Duration: 2m56s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_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-04-01 08:22:01 Duration: 1s616ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_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-04-01 12:00:01 Duration: 1s611ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
9 2h53m27s 1,440 508ms 2m56s 7s227ms 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 #9
Day Hour Count Duration Avg duration Apr 01 01 60 0ms 0ms 02 60 28s345ms 472ms 03 60 58s645ms 977ms 04 60 58s645ms 977ms 05 60 58s645ms 977ms 06 60 51s621ms 860ms 07 60 43s594ms 726ms 08 60 49s114ms 818ms 09 60 46s748ms 779ms 10 60 36s117ms 601ms 11 60 38s366ms 639ms 12 60 42s239ms 703ms 13 60 57s755ms 962ms 14 60 41s664ms 694ms 15 60 54s716ms 911ms 16 60 44s519ms 741ms 17 60 39s362ms 656ms 18 60 39s148ms 652ms 19 60 39s949ms 665ms 20 60 50s172ms 836ms 21 60 53s17ms 883ms 22 60 56s42ms 934ms 23 60 48s60ms 801ms 00 60 2h36m11s 2m36s [ User: labanimal - Total duration: 2h53m27s - 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-04-01 23:55:01 Duration: 2m56s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_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-04-01 08:22:01 Duration: 1s616ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_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-04-01 12:00:01 Duration: 1s611ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
10 2h53m27s 1,440 508ms 2m56s 7s227ms 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 #10
Day Hour Count Duration Avg duration Apr 01 01 60 0ms 0ms 02 60 28s345ms 472ms 03 60 58s645ms 977ms 04 60 58s645ms 977ms 05 60 58s645ms 977ms 06 60 51s621ms 860ms 07 60 43s594ms 726ms 08 60 49s114ms 818ms 09 60 46s748ms 779ms 10 60 36s117ms 601ms 11 60 38s366ms 639ms 12 60 42s239ms 703ms 13 60 57s755ms 962ms 14 60 41s664ms 694ms 15 60 54s716ms 911ms 16 60 44s519ms 741ms 17 60 39s362ms 656ms 18 60 39s148ms 652ms 19 60 39s949ms 665ms 20 60 50s172ms 836ms 21 60 53s17ms 883ms 22 60 56s42ms 934ms 23 60 48s60ms 801ms 00 60 2h36m11s 2m36s [ User: labanimal - Total duration: 2h53m27s - 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-04-01 23:55:01 Duration: 2m56s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-04-01 08:22:01 Duration: 1s616ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-04-01 12:00:01 Duration: 1s611ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
11 2h53m27s 1,440 508ms 2m56s 7s227ms create index if not exists idx_metrics_timeseries_bucket on observability.metrics_timeseries (bucket_start);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Apr 01 01 60 0ms 0ms 02 60 28s345ms 472ms 03 60 58s645ms 977ms 04 60 58s645ms 977ms 05 60 58s645ms 977ms 06 60 51s621ms 860ms 07 60 43s594ms 726ms 08 60 49s114ms 818ms 09 60 46s748ms 779ms 10 60 36s117ms 601ms 11 60 38s366ms 639ms 12 60 42s239ms 703ms 13 60 57s755ms 962ms 14 60 41s664ms 694ms 15 60 54s716ms 911ms 16 60 44s519ms 741ms 17 60 39s362ms 656ms 18 60 39s148ms 652ms 19 60 39s949ms 665ms 20 60 50s172ms 836ms 21 60 53s17ms 883ms 22 60 56s42ms 934ms 23 60 48s60ms 801ms 00 60 2h36m11s 2m36s [ User: labanimal - Total duration: 2h53m27s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-04-01 23:55:01 Duration: 2m56s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-04-01 08:22:01 Duration: 1s616ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-04-01 12:00:01 Duration: 1s611ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
12 2h53m27s 1,440 508ms 2m56s 7s227ms create index if not exists idx_metrics_timeseries_metric on observability.metrics_timeseries (metric_name);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Apr 01 01 60 0ms 0ms 02 60 28s345ms 472ms 03 60 58s645ms 977ms 04 60 58s645ms 977ms 05 60 58s645ms 977ms 06 60 51s621ms 860ms 07 60 43s594ms 726ms 08 60 49s114ms 818ms 09 60 46s748ms 779ms 10 60 36s117ms 601ms 11 60 38s366ms 639ms 12 60 42s239ms 703ms 13 60 57s755ms 962ms 14 60 41s664ms 694ms 15 60 54s716ms 911ms 16 60 44s519ms 741ms 17 60 39s362ms 656ms 18 60 39s148ms 652ms 19 60 39s949ms 665ms 20 60 50s172ms 836ms 21 60 53s17ms 883ms 22 60 56s42ms 934ms 23 60 48s60ms 801ms 00 60 2h36m11s 2m36s [ User: labanimal - Total duration: 2h53m27s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-04-01 23:55:01 Duration: 2m56s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-04-01 08:22:01 Duration: 1s616ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-04-01 12:00:01 Duration: 1s611ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
13 2h53m27s 1,440 508ms 2m56s 7s227ms 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 #13
Day Hour Count Duration Avg duration Apr 01 01 60 0ms 0ms 02 60 28s345ms 472ms 03 60 58s645ms 977ms 04 60 58s645ms 977ms 05 60 58s645ms 977ms 06 60 51s621ms 860ms 07 60 43s594ms 726ms 08 60 49s114ms 818ms 09 60 46s748ms 779ms 10 60 36s117ms 601ms 11 60 38s366ms 639ms 12 60 42s239ms 703ms 13 60 57s755ms 962ms 14 60 41s664ms 694ms 15 60 54s716ms 911ms 16 60 44s519ms 741ms 17 60 39s362ms 656ms 18 60 39s148ms 652ms 19 60 39s949ms 665ms 20 60 50s172ms 836ms 21 60 53s17ms 883ms 22 60 56s42ms 934ms 23 60 48s60ms 801ms 00 60 2h36m11s 2m36s [ User: labanimal - Total duration: 2h53m27s - 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-04-01 23:55:01 Duration: 2m56s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_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-04-01 08:22:01 Duration: 1s616ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_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-04-01 12:00:01 Duration: 1s611ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
14 2m56s 1 2m56s 2m56s 2m56s select str.name as linie, str.comments as eigentuemer, ( select count(a.animal_id) from animals_search_mview a where a.alive = ? and a.deleted = ? and a.strain = str.name and a.outgoing_date is null and a.death_date is null) as tiere_lebend, ( select max(a.death_date) from animals_search_mview a where a.deleted = ? and a.strain = str.name) as zuletzt_gestorbenes_tier, ( select max(a.outgoing_date) from animals_search_mview a where a.alive = ? and a.deleted = ? and a.strain = str.name) as zuletzt_lebend_verlassenes_tier from strains str where str.deleted = ? and str.active = ? group by str.name, str.comments;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Apr 01 00 1 2m56s 2m56s [ User: labanimal - Total duration: 2m56s - Times executed: 1 ]
[ Application: strainscron:zemm_produktiv_8@h2940066.stratoserver.net:5432 - Total duration: 2m56s - Times executed: 1 ]
-
SELECT str.name AS Linie, str.comments AS Eigentuemer, ( SELECT COUNT(a.animal_id) FROM animals_search_mview a WHERE a.alive = 't' AND a.deleted = 'f' AND a.strain = str.name AND a.outgoing_date IS NULL AND a.death_date IS NULL) AS tiere_lebend, ( SELECT MAX(a.death_date) FROM animals_search_mview a WHERE a.deleted = 'f' AND a.strain = str.name) AS zuletzt_gestorbenes_tier, ( SELECT MAX(a.outgoing_date) FROM animals_search_mview a WHERE a.alive = 't' AND a.deleted = 'f' AND a.strain = str.name) AS zuletzt_lebend_verlassenes_Tier FROM strains str WHERE str.deleted = '0' AND str.active = '1' GROUP BY str.name, str.comments;
Date: 2026-04-01 23:02:57 Duration: 2m56s Database: zemm_produktiv_8 User: labanimal Remote: 81.169.238.237 Application: strainscron:zemm_produktiv_8@h2940066.stratoserver.net:5432 Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
15 11s540ms 16 701ms 743ms 721ms 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 #15
Day Hour Count Duration Avg duration Apr 01 06 2 1s465ms 732ms 11 2 1s421ms 710ms 13 2 1s431ms 715ms 16 6 4s338ms 723ms 18 4 2s882ms 720ms [ User: labanimal - Total duration: 11s540ms - Times executed: 16 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 10s75ms - Times executed: 14 ]
[ Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 - Total duration: 1s465ms - 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, 490) AS is_owner, user_is_tgm (animals_search_mview.editor, 490) AS is_editor, user_is_tgm (animals_search_mview.tourist, 490) 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-04-01 15:45:20 Duration: 743ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_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, 10100000) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100000) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100000) 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-04-01 17:16:40 Duration: 739ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_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, 8) AS is_owner, user_is_tgm (animals_search_mview.editor, 8) AS is_editor, user_is_tgm (animals_search_mview.tourist, 8) 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-04-01 05:31:32 Duration: 735ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
16 10s618ms 16 639ms 726ms 663ms 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 #16
Day Hour Count Duration Avg duration Apr 01 06 2 1s450ms 725ms 11 2 1s286ms 643ms 13 2 1s302ms 651ms 16 6 3s953ms 658ms 18 4 2s626ms 656ms [ User: labanimal - Total duration: 10s618ms - Times executed: 16 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 9s168ms - Times executed: 14 ]
[ Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 - Total duration: 1s450ms - 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, 8) AS is_owner, user_is_tgm (animals_search_mview.editor, 8) AS is_editor, user_is_tgm (animals_search_mview.tourist, 8) 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-04-01 05:31:37 Duration: 726ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 8) AS is_owner, user_is_tgm (animals_search_mview.editor, 8) AS is_editor, user_is_tgm (animals_search_mview.tourist, 8) 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-04-01 05:31:33 Duration: 723ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 490) AS is_owner, user_is_tgm (animals_search_mview.editor, 490) AS is_editor, user_is_tgm (animals_search_mview.tourist, 490) 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-04-01 15:45:21 Duration: 676ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
17 9s996ms 6 1s611ms 1s738ms 1s666ms 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 cagess."cageName" like (?) 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 Apr 01 09 1 1s616ms 1s616ms 10 1 1s707ms 1s707ms 12 1 1s611ms 1s611ms 13 2 3s414ms 1s707ms 14 1 1s646ms 1s646ms [ User: labanimal - Total duration: 9s996ms - Times executed: 6 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 9s996ms - Times executed: 6 ]
-
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, 452) THEN TRUE WHEN user_is_tgm (dam.editor, 452) THEN TRUE WHEN user_is_tgm (dam.tourist, 452) 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, 452) THEN TRUE WHEN user_is_tgm (sire.editor, 452) THEN TRUE WHEN user_is_tgm (sire.tourist, 452) 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 cagess."cageName" like ('30-089') 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-04-01 12:54:45 Duration: 1s738ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_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, 457) THEN TRUE WHEN user_is_tgm (dam.editor, 457) THEN TRUE WHEN user_is_tgm (dam.tourist, 457) 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, 457) THEN TRUE WHEN user_is_tgm (sire.editor, 457) THEN TRUE WHEN user_is_tgm (sire.tourist, 457) 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 cagess."cageName" like ('49-204') 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-04-01 09:24:31 Duration: 1s707ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_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, 452) THEN TRUE WHEN user_is_tgm (dam.editor, 452) THEN TRUE WHEN user_is_tgm (dam.tourist, 452) 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, 452) THEN TRUE WHEN user_is_tgm (sire.editor, 452) THEN TRUE WHEN user_is_tgm (sire.tourist, 452) 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 cagess."cageName" like ('30-089') 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-04-01 12:54:17 Duration: 1s676ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
18 6s482ms 7 772ms 1s30ms 926ms select p_update_breedings (?, null, ?, ?::date, null, ?::text, ?::text, null) as id;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Apr 01 09 4 3s743ms 935ms 10 1 982ms 982ms 13 2 1s756ms 878ms [ User: labanimal - Total duration: 6s482ms - Times executed: 7 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 6s482ms - Times executed: 7 ]
-
SELECT p_update_breedings (270, NULL, 16076, '2026-04-01'::date, NULL, '10294322'::text, '10290943'::text, NULL) AS id;
Date: 2026-04-01 08:22:14 Duration: 1s30ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
SELECT p_update_breedings (142, NULL, 7339, '2026-04-01'::date, NULL, '10294690'::text, '10294695'::text, NULL) AS id;
Date: 2026-04-01 09:20:26 Duration: 982ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
SELECT p_update_breedings (457, NULL, 9697, '2026-04-01'::date, NULL, '10289434'::text, '10289436'::text, NULL) AS id;
Date: 2026-04-01 08:47:07 Duration: 969ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
19 5s231ms 6 798ms 1s163ms 871ms with damdam as ( select breedingid, string_agg(cast(dam as text), ?) as dam from breedingsdams inner join ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" from animals) as dam on dam.id = breedingsdams.dam and case when user_is_tgm (dam.owner, ?) then true when user_is_tgm (dam.editor, ?) then true when user_is_tgm (dam.tourist, ?) then true else false end group by breedingid ), siresire as ( select breedingid, string_agg(cast(sire as text), ?) as sire from breedingssires inner join ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" from animals) as sire on sire.id = breedingssires.sire and case when user_is_tgm (sire.owner, ?) then true when user_is_tgm (sire.editor, ?) then true when user_is_tgm (sire.tourist, ?) then true else false end group by breedingid ), cagess as ( select id, "cageName" from cages) ( select breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire from damdam, siresire, cagess, breedings where breedings.deleted != true and cagess.id = breedings.cage and damdam.breedingid = breedings.id and siresire.breedingid = breedings.id and breedings."unbreeding_date" is null group by breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire order by breeding_date, plug_date);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Apr 01 08 1 823ms 823ms 14 1 798ms 798ms 19 1 798ms 798ms 20 1 846ms 846ms 21 1 1s163ms 1s163ms 22 1 801ms 801ms [ User: labanimal - Total duration: 5s231ms - Times executed: 6 ]
[ Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 - Total duration: 5s231ms - Times executed: 6 ]
-
WITH damdam AS ( SELECT breedingid, string_agg(cast(dam as text), ';') AS dam FROM breedingsdams INNER JOIN ( SELECT id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS dam ON dam.id = breedingsdams.dam AND CASE WHEN user_is_tgm (dam.owner, 1) THEN TRUE WHEN user_is_tgm (dam.editor, 1) THEN TRUE WHEN user_is_tgm (dam.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), siresire AS ( SELECT breedingid, string_agg(cast(sire as text), ';') AS sire FROM breedingssires INNER JOIN ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS sire ON sire.id = breedingssires.sire AND CASE WHEN user_is_tgm (sire.owner, 1) THEN TRUE WHEN user_is_tgm (sire.editor, 1) THEN TRUE WHEN user_is_tgm (sire.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-04-01 20:52:34 Duration: 1s163ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
WITH damdam AS ( SELECT breedingid, string_agg(cast(dam as text), ';') AS dam FROM breedingsdams INNER JOIN ( SELECT id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS dam ON dam.id = breedingsdams.dam AND CASE WHEN user_is_tgm (dam.owner, 1) THEN TRUE WHEN user_is_tgm (dam.editor, 1) THEN TRUE WHEN user_is_tgm (dam.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), siresire AS ( SELECT breedingid, string_agg(cast(sire as text), ';') AS sire FROM breedingssires INNER JOIN ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS sire ON sire.id = breedingssires.sire AND CASE WHEN user_is_tgm (sire.owner, 1) THEN TRUE WHEN user_is_tgm (sire.editor, 1) THEN TRUE WHEN user_is_tgm (sire.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-04-01 19:12:43 Duration: 846ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
WITH damdam AS ( SELECT breedingid, string_agg(cast(dam as text), ';') AS dam FROM breedingsdams INNER JOIN ( SELECT id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS dam ON dam.id = breedingsdams.dam AND CASE WHEN user_is_tgm (dam.owner, 1) THEN TRUE WHEN user_is_tgm (dam.editor, 1) THEN TRUE WHEN user_is_tgm (dam.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), siresire AS ( SELECT breedingid, string_agg(cast(sire as text), ';') AS sire FROM breedingssires INNER JOIN ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS sire ON sire.id = breedingssires.sire AND CASE WHEN user_is_tgm (sire.owner, 1) THEN TRUE WHEN user_is_tgm (sire.editor, 1) THEN TRUE WHEN user_is_tgm (sire.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-04-01 07:02:04 Duration: 823ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
20 3s603ms 5 702ms 749ms 720ms 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 #20
Day Hour Count Duration Avg duration Apr 01 09 1 715ms 715ms 10 2 1s405ms 702ms 14 2 1s483ms 741ms [ User: labanimal - Total duration: 3s603ms - Times executed: 5 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 3s603ms - Times executed: 5 ]
-
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, 10100129) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100129) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100129) 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-04-01 13:37:45 Duration: 749ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_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, 10100129) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100129) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100129) 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-04-01 13:38:17 Duration: 734ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_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-04-01 08:11:31 Duration: 715ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,440 2h53m27s 508ms 2m56s 7s227ms create index if not exists idx_app_events_tenant on observability.app_events (tenant_key, occurred_at desc);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Apr 01 01 60 0ms 0ms 02 60 28s345ms 472ms 03 60 58s645ms 977ms 04 60 58s645ms 977ms 05 60 58s645ms 977ms 06 60 51s621ms 860ms 07 60 43s594ms 726ms 08 60 49s114ms 818ms 09 60 46s748ms 779ms 10 60 36s117ms 601ms 11 60 38s366ms 639ms 12 60 42s239ms 703ms 13 60 57s755ms 962ms 14 60 41s664ms 694ms 15 60 54s716ms 911ms 16 60 44s519ms 741ms 17 60 39s362ms 656ms 18 60 39s148ms 652ms 19 60 39s949ms 665ms 20 60 50s172ms 836ms 21 60 53s17ms 883ms 22 60 56s42ms 934ms 23 60 48s60ms 801ms 00 60 2h36m11s 2m36s [ User: labanimal - Total duration: 2h53m27s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-04-01 23:55:01 Duration: 2m56s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-04-01 08:22:01 Duration: 1s616ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-04-01 12:00:01 Duration: 1s611ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
2 1,440 2h53m27s 508ms 2m56s 7s227ms 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 #2
Day Hour Count Duration Avg duration Apr 01 01 60 0ms 0ms 02 60 28s345ms 472ms 03 60 58s645ms 977ms 04 60 58s645ms 977ms 05 60 58s645ms 977ms 06 60 51s621ms 860ms 07 60 43s594ms 726ms 08 60 49s114ms 818ms 09 60 46s748ms 779ms 10 60 36s117ms 601ms 11 60 38s366ms 639ms 12 60 42s239ms 703ms 13 60 57s755ms 962ms 14 60 41s664ms 694ms 15 60 54s716ms 911ms 16 60 44s519ms 741ms 17 60 39s362ms 656ms 18 60 39s148ms 652ms 19 60 39s949ms 665ms 20 60 50s172ms 836ms 21 60 53s17ms 883ms 22 60 56s42ms 934ms 23 60 48s60ms 801ms 00 60 2h36m11s 2m36s [ User: labanimal - Total duration: 2h53m27s - 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-04-01 23:55:01 Duration: 2m56s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_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-04-01 08:22:01 Duration: 1s616ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_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-04-01 12:00:01 Duration: 1s611ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
3 1,440 2h53m27s 508ms 2m56s 7s227ms 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 Apr 01 01 60 0ms 0ms 02 60 28s345ms 472ms 03 60 58s645ms 977ms 04 60 58s645ms 977ms 05 60 58s645ms 977ms 06 60 51s621ms 860ms 07 60 43s594ms 726ms 08 60 49s114ms 818ms 09 60 46s748ms 779ms 10 60 36s117ms 601ms 11 60 38s366ms 639ms 12 60 42s239ms 703ms 13 60 57s755ms 962ms 14 60 41s664ms 694ms 15 60 54s716ms 911ms 16 60 44s519ms 741ms 17 60 39s362ms 656ms 18 60 39s148ms 652ms 19 60 39s949ms 665ms 20 60 50s172ms 836ms 21 60 53s17ms 883ms 22 60 56s42ms 934ms 23 60 48s60ms 801ms 00 60 2h36m11s 2m36s [ User: labanimal - Total duration: 2h53m27s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-04-01 23:55:01 Duration: 2m56s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-04-01 08:22:01 Duration: 1s616ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-04-01 12:00:01 Duration: 1s611ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
4 1,440 2h53m27s 508ms 2m56s 7s227ms 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 #4
Day Hour Count Duration Avg duration Apr 01 01 60 0ms 0ms 02 60 28s345ms 472ms 03 60 58s645ms 977ms 04 60 58s645ms 977ms 05 60 58s645ms 977ms 06 60 51s621ms 860ms 07 60 43s594ms 726ms 08 60 49s114ms 818ms 09 60 46s748ms 779ms 10 60 36s117ms 601ms 11 60 38s366ms 639ms 12 60 42s239ms 703ms 13 60 57s755ms 962ms 14 60 41s664ms 694ms 15 60 54s716ms 911ms 16 60 44s519ms 741ms 17 60 39s362ms 656ms 18 60 39s148ms 652ms 19 60 39s949ms 665ms 20 60 50s172ms 836ms 21 60 53s17ms 883ms 22 60 56s42ms 934ms 23 60 48s60ms 801ms 00 60 2h36m11s 2m36s [ User: labanimal - Total duration: 2h53m27s - 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-04-01 23:55:01 Duration: 2m56s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_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-04-01 08:22:01 Duration: 1s616ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_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-04-01 12:00:01 Duration: 1s611ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
5 1,440 2h53m27s 508ms 2m56s 7s227ms create table if not exists observability.system_metrics ( id bigserial primary key, payload jsonb not null, collected_at timestamptz not null default now() );Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Apr 01 01 60 0ms 0ms 02 60 28s345ms 472ms 03 60 58s645ms 977ms 04 60 58s645ms 977ms 05 60 58s645ms 977ms 06 60 51s621ms 860ms 07 60 43s594ms 726ms 08 60 49s114ms 818ms 09 60 46s748ms 779ms 10 60 36s117ms 601ms 11 60 38s366ms 639ms 12 60 42s239ms 703ms 13 60 57s755ms 962ms 14 60 41s664ms 694ms 15 60 54s716ms 911ms 16 60 44s519ms 741ms 17 60 39s362ms 656ms 18 60 39s148ms 652ms 19 60 39s949ms 665ms 20 60 50s172ms 836ms 21 60 53s17ms 883ms 22 60 56s42ms 934ms 23 60 48s60ms 801ms 00 60 2h36m11s 2m36s [ User: labanimal - Total duration: 2h53m27s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-01 23:55:01 Duration: 2m56s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-01 08:22:01 Duration: 1s616ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-01 12:00:01 Duration: 1s611ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
6 1,440 2h53m27s 508ms 2m56s 7s227ms 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 #6
Day Hour Count Duration Avg duration Apr 01 01 60 0ms 0ms 02 60 28s345ms 472ms 03 60 58s645ms 977ms 04 60 58s645ms 977ms 05 60 58s645ms 977ms 06 60 51s621ms 860ms 07 60 43s594ms 726ms 08 60 49s114ms 818ms 09 60 46s748ms 779ms 10 60 36s117ms 601ms 11 60 38s366ms 639ms 12 60 42s239ms 703ms 13 60 57s755ms 962ms 14 60 41s664ms 694ms 15 60 54s716ms 911ms 16 60 44s519ms 741ms 17 60 39s362ms 656ms 18 60 39s148ms 652ms 19 60 39s949ms 665ms 20 60 50s172ms 836ms 21 60 53s17ms 883ms 22 60 56s42ms 934ms 23 60 48s60ms 801ms 00 60 2h36m11s 2m36s [ User: labanimal - Total duration: 2h53m27s - 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-04-01 23:55:01 Duration: 2m56s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_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-04-01 08:22:01 Duration: 1s616ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_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-04-01 12:00:01 Duration: 1s611ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
7 1,440 2h53m27s 508ms 2m56s 7s227ms create schema if not exists observability;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Apr 01 01 60 0ms 0ms 02 60 28s345ms 472ms 03 60 58s645ms 977ms 04 60 58s645ms 977ms 05 60 58s645ms 977ms 06 60 51s621ms 860ms 07 60 43s594ms 726ms 08 60 49s114ms 818ms 09 60 46s748ms 779ms 10 60 36s117ms 601ms 11 60 38s366ms 639ms 12 60 42s239ms 703ms 13 60 57s755ms 962ms 14 60 41s664ms 694ms 15 60 54s716ms 911ms 16 60 44s519ms 741ms 17 60 39s362ms 656ms 18 60 39s148ms 652ms 19 60 39s949ms 665ms 20 60 50s172ms 836ms 21 60 53s17ms 883ms 22 60 56s42ms 934ms 23 60 48s60ms 801ms 00 60 2h36m11s 2m36s [ User: labanimal - Total duration: 2h53m27s - Times executed: 1349 ]
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-04-01 23:55:01 Duration: 2m56s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-04-01 08:22:01 Duration: 1s616ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-04-01 12:00:01 Duration: 1s611ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
8 1,440 2h53m27s 508ms 2m56s 7s227ms 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 #8
Day Hour Count Duration Avg duration Apr 01 01 60 0ms 0ms 02 60 28s345ms 472ms 03 60 58s645ms 977ms 04 60 58s645ms 977ms 05 60 58s645ms 977ms 06 60 51s621ms 860ms 07 60 43s594ms 726ms 08 60 49s114ms 818ms 09 60 46s748ms 779ms 10 60 36s117ms 601ms 11 60 38s366ms 639ms 12 60 42s239ms 703ms 13 60 57s755ms 962ms 14 60 41s664ms 694ms 15 60 54s716ms 911ms 16 60 44s519ms 741ms 17 60 39s362ms 656ms 18 60 39s148ms 652ms 19 60 39s949ms 665ms 20 60 50s172ms 836ms 21 60 53s17ms 883ms 22 60 56s42ms 934ms 23 60 48s60ms 801ms 00 60 2h36m11s 2m36s [ User: labanimal - Total duration: 2h53m27s - 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-04-01 23:55:01 Duration: 2m56s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_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-04-01 08:22:01 Duration: 1s616ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_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-04-01 12:00:01 Duration: 1s611ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
9 1,440 2h53m27s 508ms 2m56s 7s227ms 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 #9
Day Hour Count Duration Avg duration Apr 01 01 60 0ms 0ms 02 60 28s345ms 472ms 03 60 58s645ms 977ms 04 60 58s645ms 977ms 05 60 58s645ms 977ms 06 60 51s621ms 860ms 07 60 43s594ms 726ms 08 60 49s114ms 818ms 09 60 46s748ms 779ms 10 60 36s117ms 601ms 11 60 38s366ms 639ms 12 60 42s239ms 703ms 13 60 57s755ms 962ms 14 60 41s664ms 694ms 15 60 54s716ms 911ms 16 60 44s519ms 741ms 17 60 39s362ms 656ms 18 60 39s148ms 652ms 19 60 39s949ms 665ms 20 60 50s172ms 836ms 21 60 53s17ms 883ms 22 60 56s42ms 934ms 23 60 48s60ms 801ms 00 60 2h36m11s 2m36s [ User: labanimal - Total duration: 2h53m27s - 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-04-01 23:55:01 Duration: 2m56s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_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-04-01 08:22:01 Duration: 1s616ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_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-04-01 12:00:01 Duration: 1s611ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
10 1,440 2h53m27s 508ms 2m56s 7s227ms 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 #10
Day Hour Count Duration Avg duration Apr 01 01 60 0ms 0ms 02 60 28s345ms 472ms 03 60 58s645ms 977ms 04 60 58s645ms 977ms 05 60 58s645ms 977ms 06 60 51s621ms 860ms 07 60 43s594ms 726ms 08 60 49s114ms 818ms 09 60 46s748ms 779ms 10 60 36s117ms 601ms 11 60 38s366ms 639ms 12 60 42s239ms 703ms 13 60 57s755ms 962ms 14 60 41s664ms 694ms 15 60 54s716ms 911ms 16 60 44s519ms 741ms 17 60 39s362ms 656ms 18 60 39s148ms 652ms 19 60 39s949ms 665ms 20 60 50s172ms 836ms 21 60 53s17ms 883ms 22 60 56s42ms 934ms 23 60 48s60ms 801ms 00 60 2h36m11s 2m36s [ User: labanimal - Total duration: 2h53m27s - 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-04-01 23:55:01 Duration: 2m56s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-04-01 08:22:01 Duration: 1s616ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-04-01 12:00:01 Duration: 1s611ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
11 1,440 2h53m27s 508ms 2m56s 7s227ms create index if not exists idx_metrics_timeseries_bucket on observability.metrics_timeseries (bucket_start);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Apr 01 01 60 0ms 0ms 02 60 28s345ms 472ms 03 60 58s645ms 977ms 04 60 58s645ms 977ms 05 60 58s645ms 977ms 06 60 51s621ms 860ms 07 60 43s594ms 726ms 08 60 49s114ms 818ms 09 60 46s748ms 779ms 10 60 36s117ms 601ms 11 60 38s366ms 639ms 12 60 42s239ms 703ms 13 60 57s755ms 962ms 14 60 41s664ms 694ms 15 60 54s716ms 911ms 16 60 44s519ms 741ms 17 60 39s362ms 656ms 18 60 39s148ms 652ms 19 60 39s949ms 665ms 20 60 50s172ms 836ms 21 60 53s17ms 883ms 22 60 56s42ms 934ms 23 60 48s60ms 801ms 00 60 2h36m11s 2m36s [ User: labanimal - Total duration: 2h53m27s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-04-01 23:55:01 Duration: 2m56s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-04-01 08:22:01 Duration: 1s616ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-04-01 12:00:01 Duration: 1s611ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
12 1,440 2h53m27s 508ms 2m56s 7s227ms create index if not exists idx_metrics_timeseries_metric on observability.metrics_timeseries (metric_name);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Apr 01 01 60 0ms 0ms 02 60 28s345ms 472ms 03 60 58s645ms 977ms 04 60 58s645ms 977ms 05 60 58s645ms 977ms 06 60 51s621ms 860ms 07 60 43s594ms 726ms 08 60 49s114ms 818ms 09 60 46s748ms 779ms 10 60 36s117ms 601ms 11 60 38s366ms 639ms 12 60 42s239ms 703ms 13 60 57s755ms 962ms 14 60 41s664ms 694ms 15 60 54s716ms 911ms 16 60 44s519ms 741ms 17 60 39s362ms 656ms 18 60 39s148ms 652ms 19 60 39s949ms 665ms 20 60 50s172ms 836ms 21 60 53s17ms 883ms 22 60 56s42ms 934ms 23 60 48s60ms 801ms 00 60 2h36m11s 2m36s [ User: labanimal - Total duration: 2h53m27s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-04-01 23:55:01 Duration: 2m56s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-04-01 08:22:01 Duration: 1s616ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-04-01 12:00:01 Duration: 1s611ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
13 1,440 2h53m27s 508ms 2m56s 7s227ms 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 #13
Day Hour Count Duration Avg duration Apr 01 01 60 0ms 0ms 02 60 28s345ms 472ms 03 60 58s645ms 977ms 04 60 58s645ms 977ms 05 60 58s645ms 977ms 06 60 51s621ms 860ms 07 60 43s594ms 726ms 08 60 49s114ms 818ms 09 60 46s748ms 779ms 10 60 36s117ms 601ms 11 60 38s366ms 639ms 12 60 42s239ms 703ms 13 60 57s755ms 962ms 14 60 41s664ms 694ms 15 60 54s716ms 911ms 16 60 44s519ms 741ms 17 60 39s362ms 656ms 18 60 39s148ms 652ms 19 60 39s949ms 665ms 20 60 50s172ms 836ms 21 60 53s17ms 883ms 22 60 56s42ms 934ms 23 60 48s60ms 801ms 00 60 2h36m11s 2m36s [ User: labanimal - Total duration: 2h53m27s - 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-04-01 23:55:01 Duration: 2m56s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_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-04-01 08:22:01 Duration: 1s616ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_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-04-01 12:00:01 Duration: 1s611ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
14 16 11s540ms 701ms 743ms 721ms 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 #14
Day Hour Count Duration Avg duration Apr 01 06 2 1s465ms 732ms 11 2 1s421ms 710ms 13 2 1s431ms 715ms 16 6 4s338ms 723ms 18 4 2s882ms 720ms [ User: labanimal - Total duration: 11s540ms - Times executed: 16 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 10s75ms - Times executed: 14 ]
[ Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 - Total duration: 1s465ms - 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, 490) AS is_owner, user_is_tgm (animals_search_mview.editor, 490) AS is_editor, user_is_tgm (animals_search_mview.tourist, 490) 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-04-01 15:45:20 Duration: 743ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_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, 10100000) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100000) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100000) 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-04-01 17:16:40 Duration: 739ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_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, 8) AS is_owner, user_is_tgm (animals_search_mview.editor, 8) AS is_editor, user_is_tgm (animals_search_mview.tourist, 8) 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-04-01 05:31:32 Duration: 735ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
15 16 10s618ms 639ms 726ms 663ms 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 Apr 01 06 2 1s450ms 725ms 11 2 1s286ms 643ms 13 2 1s302ms 651ms 16 6 3s953ms 658ms 18 4 2s626ms 656ms [ User: labanimal - Total duration: 10s618ms - Times executed: 16 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 9s168ms - Times executed: 14 ]
[ Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 - Total duration: 1s450ms - 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, 8) AS is_owner, user_is_tgm (animals_search_mview.editor, 8) AS is_editor, user_is_tgm (animals_search_mview.tourist, 8) 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-04-01 05:31:37 Duration: 726ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 8) AS is_owner, user_is_tgm (animals_search_mview.editor, 8) AS is_editor, user_is_tgm (animals_search_mview.tourist, 8) 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-04-01 05:31:33 Duration: 723ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 490) AS is_owner, user_is_tgm (animals_search_mview.editor, 490) AS is_editor, user_is_tgm (animals_search_mview.tourist, 490) 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-04-01 15:45:21 Duration: 676ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
16 7 6s482ms 772ms 1s30ms 926ms select p_update_breedings (?, null, ?, ?::date, null, ?::text, ?::text, null) as id;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Apr 01 09 4 3s743ms 935ms 10 1 982ms 982ms 13 2 1s756ms 878ms [ User: labanimal - Total duration: 6s482ms - Times executed: 7 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 6s482ms - Times executed: 7 ]
-
SELECT p_update_breedings (270, NULL, 16076, '2026-04-01'::date, NULL, '10294322'::text, '10290943'::text, NULL) AS id;
Date: 2026-04-01 08:22:14 Duration: 1s30ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
SELECT p_update_breedings (142, NULL, 7339, '2026-04-01'::date, NULL, '10294690'::text, '10294695'::text, NULL) AS id;
Date: 2026-04-01 09:20:26 Duration: 982ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
SELECT p_update_breedings (457, NULL, 9697, '2026-04-01'::date, NULL, '10289434'::text, '10289436'::text, NULL) AS id;
Date: 2026-04-01 08:47:07 Duration: 969ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
17 6 9s996ms 1s611ms 1s738ms 1s666ms 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 cagess."cageName" like (?) 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 Apr 01 09 1 1s616ms 1s616ms 10 1 1s707ms 1s707ms 12 1 1s611ms 1s611ms 13 2 3s414ms 1s707ms 14 1 1s646ms 1s646ms [ User: labanimal - Total duration: 9s996ms - Times executed: 6 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 9s996ms - Times executed: 6 ]
-
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, 452) THEN TRUE WHEN user_is_tgm (dam.editor, 452) THEN TRUE WHEN user_is_tgm (dam.tourist, 452) 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, 452) THEN TRUE WHEN user_is_tgm (sire.editor, 452) THEN TRUE WHEN user_is_tgm (sire.tourist, 452) 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 cagess."cageName" like ('30-089') 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-04-01 12:54:45 Duration: 1s738ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_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, 457) THEN TRUE WHEN user_is_tgm (dam.editor, 457) THEN TRUE WHEN user_is_tgm (dam.tourist, 457) 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, 457) THEN TRUE WHEN user_is_tgm (sire.editor, 457) THEN TRUE WHEN user_is_tgm (sire.tourist, 457) 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 cagess."cageName" like ('49-204') 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-04-01 09:24:31 Duration: 1s707ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_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, 452) THEN TRUE WHEN user_is_tgm (dam.editor, 452) THEN TRUE WHEN user_is_tgm (dam.tourist, 452) 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, 452) THEN TRUE WHEN user_is_tgm (sire.editor, 452) THEN TRUE WHEN user_is_tgm (sire.tourist, 452) 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 cagess."cageName" like ('30-089') 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-04-01 12:54:17 Duration: 1s676ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
18 6 5s231ms 798ms 1s163ms 871ms 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 Apr 01 08 1 823ms 823ms 14 1 798ms 798ms 19 1 798ms 798ms 20 1 846ms 846ms 21 1 1s163ms 1s163ms 22 1 801ms 801ms [ User: labanimal - Total duration: 5s231ms - Times executed: 6 ]
[ Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 - Total duration: 5s231ms - Times executed: 6 ]
-
WITH damdam AS ( SELECT breedingid, string_agg(cast(dam as text), ';') AS dam FROM breedingsdams INNER JOIN ( SELECT id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS dam ON dam.id = breedingsdams.dam AND CASE WHEN user_is_tgm (dam.owner, 1) THEN TRUE WHEN user_is_tgm (dam.editor, 1) THEN TRUE WHEN user_is_tgm (dam.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), siresire AS ( SELECT breedingid, string_agg(cast(sire as text), ';') AS sire FROM breedingssires INNER JOIN ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS sire ON sire.id = breedingssires.sire AND CASE WHEN user_is_tgm (sire.owner, 1) THEN TRUE WHEN user_is_tgm (sire.editor, 1) THEN TRUE WHEN user_is_tgm (sire.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-04-01 20:52:34 Duration: 1s163ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
WITH damdam AS ( SELECT breedingid, string_agg(cast(dam as text), ';') AS dam FROM breedingsdams INNER JOIN ( SELECT id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS dam ON dam.id = breedingsdams.dam AND CASE WHEN user_is_tgm (dam.owner, 1) THEN TRUE WHEN user_is_tgm (dam.editor, 1) THEN TRUE WHEN user_is_tgm (dam.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), siresire AS ( SELECT breedingid, string_agg(cast(sire as text), ';') AS sire FROM breedingssires INNER JOIN ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS sire ON sire.id = breedingssires.sire AND CASE WHEN user_is_tgm (sire.owner, 1) THEN TRUE WHEN user_is_tgm (sire.editor, 1) THEN TRUE WHEN user_is_tgm (sire.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-04-01 19:12:43 Duration: 846ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
WITH damdam AS ( SELECT breedingid, string_agg(cast(dam as text), ';') AS dam FROM breedingsdams INNER JOIN ( SELECT id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS dam ON dam.id = breedingsdams.dam AND CASE WHEN user_is_tgm (dam.owner, 1) THEN TRUE WHEN user_is_tgm (dam.editor, 1) THEN TRUE WHEN user_is_tgm (dam.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), siresire AS ( SELECT breedingid, string_agg(cast(sire as text), ';') AS sire FROM breedingssires INNER JOIN ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS sire ON sire.id = breedingssires.sire AND CASE WHEN user_is_tgm (sire.owner, 1) THEN TRUE WHEN user_is_tgm (sire.editor, 1) THEN TRUE WHEN user_is_tgm (sire.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-04-01 07:02:04 Duration: 823ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
19 5 3s603ms 702ms 749ms 720ms 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 #19
Day Hour Count Duration Avg duration Apr 01 09 1 715ms 715ms 10 2 1s405ms 702ms 14 2 1s483ms 741ms [ User: labanimal - Total duration: 3s603ms - Times executed: 5 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 3s603ms - Times executed: 5 ]
-
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, 10100129) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100129) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100129) 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-04-01 13:37:45 Duration: 749ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_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, 10100129) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100129) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100129) 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-04-01 13:38:17 Duration: 734ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_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-04-01 08:11:31 Duration: 715ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
20 5 3s284ms 640ms 684ms 656ms 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 #20
Day Hour Count Duration Avg duration Apr 01 09 1 650ms 650ms 10 2 1s286ms 643ms 14 2 1s347ms 673ms [ User: labanimal - Total duration: 3s284ms - Times executed: 5 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 3s284ms - Times executed: 5 ]
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 10100129) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100129) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100129) 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-04-01 13:37:46 Duration: 684ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 10100129) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100129) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100129) 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-04-01 13:38:18 Duration: 663ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_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-04-01 08:11:32 Duration: 650ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m56s 2m56s 2m56s 1 2m56s select str.name as linie, str.comments as eigentuemer, ( select count(a.animal_id) from animals_search_mview a where a.alive = ? and a.deleted = ? and a.strain = str.name and a.outgoing_date is null and a.death_date is null) as tiere_lebend, ( select max(a.death_date) from animals_search_mview a where a.deleted = ? and a.strain = str.name) as zuletzt_gestorbenes_tier, ( select max(a.outgoing_date) from animals_search_mview a where a.alive = ? and a.deleted = ? and a.strain = str.name) as zuletzt_lebend_verlassenes_tier from strains str where str.deleted = ? and str.active = ? group by str.name, str.comments;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Apr 01 00 1 2m56s 2m56s [ User: labanimal - Total duration: 2m56s - Times executed: 1 ]
[ Application: strainscron:zemm_produktiv_8@h2940066.stratoserver.net:5432 - Total duration: 2m56s - Times executed: 1 ]
-
SELECT str.name AS Linie, str.comments AS Eigentuemer, ( SELECT COUNT(a.animal_id) FROM animals_search_mview a WHERE a.alive = 't' AND a.deleted = 'f' AND a.strain = str.name AND a.outgoing_date IS NULL AND a.death_date IS NULL) AS tiere_lebend, ( SELECT MAX(a.death_date) FROM animals_search_mview a WHERE a.deleted = 'f' AND a.strain = str.name) AS zuletzt_gestorbenes_tier, ( SELECT MAX(a.outgoing_date) FROM animals_search_mview a WHERE a.alive = 't' AND a.deleted = 'f' AND a.strain = str.name) AS zuletzt_lebend_verlassenes_Tier FROM strains str WHERE str.deleted = '0' AND str.active = '1' GROUP BY str.name, str.comments;
Date: 2026-04-01 23:02:57 Duration: 2m56s Database: zemm_produktiv_8 User: labanimal Remote: 81.169.238.237 Application: strainscron:zemm_produktiv_8@h2940066.stratoserver.net:5432 Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
2 508ms 2m56s 7s227ms 1,440 2h53m27s create index if not exists idx_app_events_tenant on observability.app_events (tenant_key, occurred_at desc);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Apr 01 01 60 0ms 0ms 02 60 28s345ms 472ms 03 60 58s645ms 977ms 04 60 58s645ms 977ms 05 60 58s645ms 977ms 06 60 51s621ms 860ms 07 60 43s594ms 726ms 08 60 49s114ms 818ms 09 60 46s748ms 779ms 10 60 36s117ms 601ms 11 60 38s366ms 639ms 12 60 42s239ms 703ms 13 60 57s755ms 962ms 14 60 41s664ms 694ms 15 60 54s716ms 911ms 16 60 44s519ms 741ms 17 60 39s362ms 656ms 18 60 39s148ms 652ms 19 60 39s949ms 665ms 20 60 50s172ms 836ms 21 60 53s17ms 883ms 22 60 56s42ms 934ms 23 60 48s60ms 801ms 00 60 2h36m11s 2m36s [ User: labanimal - Total duration: 2h53m27s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-04-01 23:55:01 Duration: 2m56s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-04-01 08:22:01 Duration: 1s616ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-04-01 12:00:01 Duration: 1s611ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
3 508ms 2m56s 7s227ms 1,440 2h53m27s 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 #3
Day Hour Count Duration Avg duration Apr 01 01 60 0ms 0ms 02 60 28s345ms 472ms 03 60 58s645ms 977ms 04 60 58s645ms 977ms 05 60 58s645ms 977ms 06 60 51s621ms 860ms 07 60 43s594ms 726ms 08 60 49s114ms 818ms 09 60 46s748ms 779ms 10 60 36s117ms 601ms 11 60 38s366ms 639ms 12 60 42s239ms 703ms 13 60 57s755ms 962ms 14 60 41s664ms 694ms 15 60 54s716ms 911ms 16 60 44s519ms 741ms 17 60 39s362ms 656ms 18 60 39s148ms 652ms 19 60 39s949ms 665ms 20 60 50s172ms 836ms 21 60 53s17ms 883ms 22 60 56s42ms 934ms 23 60 48s60ms 801ms 00 60 2h36m11s 2m36s [ User: labanimal - Total duration: 2h53m27s - 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-04-01 23:55:01 Duration: 2m56s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_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-04-01 08:22:01 Duration: 1s616ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_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-04-01 12:00:01 Duration: 1s611ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
4 508ms 2m56s 7s227ms 1,440 2h53m27s create index if not exists idx_app_events_type on observability.app_events (event_type);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Apr 01 01 60 0ms 0ms 02 60 28s345ms 472ms 03 60 58s645ms 977ms 04 60 58s645ms 977ms 05 60 58s645ms 977ms 06 60 51s621ms 860ms 07 60 43s594ms 726ms 08 60 49s114ms 818ms 09 60 46s748ms 779ms 10 60 36s117ms 601ms 11 60 38s366ms 639ms 12 60 42s239ms 703ms 13 60 57s755ms 962ms 14 60 41s664ms 694ms 15 60 54s716ms 911ms 16 60 44s519ms 741ms 17 60 39s362ms 656ms 18 60 39s148ms 652ms 19 60 39s949ms 665ms 20 60 50s172ms 836ms 21 60 53s17ms 883ms 22 60 56s42ms 934ms 23 60 48s60ms 801ms 00 60 2h36m11s 2m36s [ User: labanimal - Total duration: 2h53m27s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-04-01 23:55:01 Duration: 2m56s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-04-01 08:22:01 Duration: 1s616ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-04-01 12:00:01 Duration: 1s611ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
5 508ms 2m56s 7s227ms 1,440 2h53m27s 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 #5
Day Hour Count Duration Avg duration Apr 01 01 60 0ms 0ms 02 60 28s345ms 472ms 03 60 58s645ms 977ms 04 60 58s645ms 977ms 05 60 58s645ms 977ms 06 60 51s621ms 860ms 07 60 43s594ms 726ms 08 60 49s114ms 818ms 09 60 46s748ms 779ms 10 60 36s117ms 601ms 11 60 38s366ms 639ms 12 60 42s239ms 703ms 13 60 57s755ms 962ms 14 60 41s664ms 694ms 15 60 54s716ms 911ms 16 60 44s519ms 741ms 17 60 39s362ms 656ms 18 60 39s148ms 652ms 19 60 39s949ms 665ms 20 60 50s172ms 836ms 21 60 53s17ms 883ms 22 60 56s42ms 934ms 23 60 48s60ms 801ms 00 60 2h36m11s 2m36s [ User: labanimal - Total duration: 2h53m27s - 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-04-01 23:55:01 Duration: 2m56s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_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-04-01 08:22:01 Duration: 1s616ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_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-04-01 12:00:01 Duration: 1s611ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
6 508ms 2m56s 7s227ms 1,440 2h53m27s create table if not exists observability.system_metrics ( id bigserial primary key, payload jsonb not null, collected_at timestamptz not null default now() );Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Apr 01 01 60 0ms 0ms 02 60 28s345ms 472ms 03 60 58s645ms 977ms 04 60 58s645ms 977ms 05 60 58s645ms 977ms 06 60 51s621ms 860ms 07 60 43s594ms 726ms 08 60 49s114ms 818ms 09 60 46s748ms 779ms 10 60 36s117ms 601ms 11 60 38s366ms 639ms 12 60 42s239ms 703ms 13 60 57s755ms 962ms 14 60 41s664ms 694ms 15 60 54s716ms 911ms 16 60 44s519ms 741ms 17 60 39s362ms 656ms 18 60 39s148ms 652ms 19 60 39s949ms 665ms 20 60 50s172ms 836ms 21 60 53s17ms 883ms 22 60 56s42ms 934ms 23 60 48s60ms 801ms 00 60 2h36m11s 2m36s [ User: labanimal - Total duration: 2h53m27s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-01 23:55:01 Duration: 2m56s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-01 08:22:01 Duration: 1s616ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-01 12:00:01 Duration: 1s611ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
7 508ms 2m56s 7s227ms 1,440 2h53m27s create table if not exists observability.nginx_counters ( id bigserial primary key, payload jsonb not null, collected_at timestamptz not null default now() );Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Apr 01 01 60 0ms 0ms 02 60 28s345ms 472ms 03 60 58s645ms 977ms 04 60 58s645ms 977ms 05 60 58s645ms 977ms 06 60 51s621ms 860ms 07 60 43s594ms 726ms 08 60 49s114ms 818ms 09 60 46s748ms 779ms 10 60 36s117ms 601ms 11 60 38s366ms 639ms 12 60 42s239ms 703ms 13 60 57s755ms 962ms 14 60 41s664ms 694ms 15 60 54s716ms 911ms 16 60 44s519ms 741ms 17 60 39s362ms 656ms 18 60 39s148ms 652ms 19 60 39s949ms 665ms 20 60 50s172ms 836ms 21 60 53s17ms 883ms 22 60 56s42ms 934ms 23 60 48s60ms 801ms 00 60 2h36m11s 2m36s [ User: labanimal - Total duration: 2h53m27s - 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-04-01 23:55:01 Duration: 2m56s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_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-04-01 08:22:01 Duration: 1s616ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_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-04-01 12:00:01 Duration: 1s611ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
8 508ms 2m56s 7s227ms 1,440 2h53m27s create schema if not exists observability;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Apr 01 01 60 0ms 0ms 02 60 28s345ms 472ms 03 60 58s645ms 977ms 04 60 58s645ms 977ms 05 60 58s645ms 977ms 06 60 51s621ms 860ms 07 60 43s594ms 726ms 08 60 49s114ms 818ms 09 60 46s748ms 779ms 10 60 36s117ms 601ms 11 60 38s366ms 639ms 12 60 42s239ms 703ms 13 60 57s755ms 962ms 14 60 41s664ms 694ms 15 60 54s716ms 911ms 16 60 44s519ms 741ms 17 60 39s362ms 656ms 18 60 39s148ms 652ms 19 60 39s949ms 665ms 20 60 50s172ms 836ms 21 60 53s17ms 883ms 22 60 56s42ms 934ms 23 60 48s60ms 801ms 00 60 2h36m11s 2m36s [ User: labanimal - Total duration: 2h53m27s - Times executed: 1349 ]
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-04-01 23:55:01 Duration: 2m56s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-04-01 08:22:01 Duration: 1s616ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-04-01 12:00:01 Duration: 1s611ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
9 508ms 2m56s 7s227ms 1,440 2h53m27s 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 #9
Day Hour Count Duration Avg duration Apr 01 01 60 0ms 0ms 02 60 28s345ms 472ms 03 60 58s645ms 977ms 04 60 58s645ms 977ms 05 60 58s645ms 977ms 06 60 51s621ms 860ms 07 60 43s594ms 726ms 08 60 49s114ms 818ms 09 60 46s748ms 779ms 10 60 36s117ms 601ms 11 60 38s366ms 639ms 12 60 42s239ms 703ms 13 60 57s755ms 962ms 14 60 41s664ms 694ms 15 60 54s716ms 911ms 16 60 44s519ms 741ms 17 60 39s362ms 656ms 18 60 39s148ms 652ms 19 60 39s949ms 665ms 20 60 50s172ms 836ms 21 60 53s17ms 883ms 22 60 56s42ms 934ms 23 60 48s60ms 801ms 00 60 2h36m11s 2m36s [ User: labanimal - Total duration: 2h53m27s - 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-04-01 23:55:01 Duration: 2m56s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_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-04-01 08:22:01 Duration: 1s616ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_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-04-01 12:00:01 Duration: 1s611ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
10 508ms 2m56s 7s227ms 1,440 2h53m27s 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 Apr 01 01 60 0ms 0ms 02 60 28s345ms 472ms 03 60 58s645ms 977ms 04 60 58s645ms 977ms 05 60 58s645ms 977ms 06 60 51s621ms 860ms 07 60 43s594ms 726ms 08 60 49s114ms 818ms 09 60 46s748ms 779ms 10 60 36s117ms 601ms 11 60 38s366ms 639ms 12 60 42s239ms 703ms 13 60 57s755ms 962ms 14 60 41s664ms 694ms 15 60 54s716ms 911ms 16 60 44s519ms 741ms 17 60 39s362ms 656ms 18 60 39s148ms 652ms 19 60 39s949ms 665ms 20 60 50s172ms 836ms 21 60 53s17ms 883ms 22 60 56s42ms 934ms 23 60 48s60ms 801ms 00 60 2h36m11s 2m36s [ User: labanimal - Total duration: 2h53m27s - 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-04-01 23:55:01 Duration: 2m56s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_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-04-01 08:22:01 Duration: 1s616ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_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-04-01 12:00:01 Duration: 1s611ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
11 508ms 2m56s 7s227ms 1,440 2h53m27s 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 #11
Day Hour Count Duration Avg duration Apr 01 01 60 0ms 0ms 02 60 28s345ms 472ms 03 60 58s645ms 977ms 04 60 58s645ms 977ms 05 60 58s645ms 977ms 06 60 51s621ms 860ms 07 60 43s594ms 726ms 08 60 49s114ms 818ms 09 60 46s748ms 779ms 10 60 36s117ms 601ms 11 60 38s366ms 639ms 12 60 42s239ms 703ms 13 60 57s755ms 962ms 14 60 41s664ms 694ms 15 60 54s716ms 911ms 16 60 44s519ms 741ms 17 60 39s362ms 656ms 18 60 39s148ms 652ms 19 60 39s949ms 665ms 20 60 50s172ms 836ms 21 60 53s17ms 883ms 22 60 56s42ms 934ms 23 60 48s60ms 801ms 00 60 2h36m11s 2m36s [ User: labanimal - Total duration: 2h53m27s - 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-04-01 23:55:01 Duration: 2m56s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-04-01 08:22:01 Duration: 1s616ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-04-01 12:00:01 Duration: 1s611ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
12 508ms 2m56s 7s227ms 1,440 2h53m27s create index if not exists idx_metrics_timeseries_bucket on observability.metrics_timeseries (bucket_start);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Apr 01 01 60 0ms 0ms 02 60 28s345ms 472ms 03 60 58s645ms 977ms 04 60 58s645ms 977ms 05 60 58s645ms 977ms 06 60 51s621ms 860ms 07 60 43s594ms 726ms 08 60 49s114ms 818ms 09 60 46s748ms 779ms 10 60 36s117ms 601ms 11 60 38s366ms 639ms 12 60 42s239ms 703ms 13 60 57s755ms 962ms 14 60 41s664ms 694ms 15 60 54s716ms 911ms 16 60 44s519ms 741ms 17 60 39s362ms 656ms 18 60 39s148ms 652ms 19 60 39s949ms 665ms 20 60 50s172ms 836ms 21 60 53s17ms 883ms 22 60 56s42ms 934ms 23 60 48s60ms 801ms 00 60 2h36m11s 2m36s [ User: labanimal - Total duration: 2h53m27s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-04-01 23:55:01 Duration: 2m56s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-04-01 08:22:01 Duration: 1s616ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-04-01 12:00:01 Duration: 1s611ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
13 508ms 2m56s 7s227ms 1,440 2h53m27s 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 Apr 01 01 60 0ms 0ms 02 60 28s345ms 472ms 03 60 58s645ms 977ms 04 60 58s645ms 977ms 05 60 58s645ms 977ms 06 60 51s621ms 860ms 07 60 43s594ms 726ms 08 60 49s114ms 818ms 09 60 46s748ms 779ms 10 60 36s117ms 601ms 11 60 38s366ms 639ms 12 60 42s239ms 703ms 13 60 57s755ms 962ms 14 60 41s664ms 694ms 15 60 54s716ms 911ms 16 60 44s519ms 741ms 17 60 39s362ms 656ms 18 60 39s148ms 652ms 19 60 39s949ms 665ms 20 60 50s172ms 836ms 21 60 53s17ms 883ms 22 60 56s42ms 934ms 23 60 48s60ms 801ms 00 60 2h36m11s 2m36s [ User: labanimal - Total duration: 2h53m27s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-04-01 23:55:01 Duration: 2m56s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-04-01 08:22:01 Duration: 1s616ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-04-01 12:00:01 Duration: 1s611ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
14 508ms 2m56s 7s227ms 1,440 2h53m27s 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 #14
Day Hour Count Duration Avg duration Apr 01 01 60 0ms 0ms 02 60 28s345ms 472ms 03 60 58s645ms 977ms 04 60 58s645ms 977ms 05 60 58s645ms 977ms 06 60 51s621ms 860ms 07 60 43s594ms 726ms 08 60 49s114ms 818ms 09 60 46s748ms 779ms 10 60 36s117ms 601ms 11 60 38s366ms 639ms 12 60 42s239ms 703ms 13 60 57s755ms 962ms 14 60 41s664ms 694ms 15 60 54s716ms 911ms 16 60 44s519ms 741ms 17 60 39s362ms 656ms 18 60 39s148ms 652ms 19 60 39s949ms 665ms 20 60 50s172ms 836ms 21 60 53s17ms 883ms 22 60 56s42ms 934ms 23 60 48s60ms 801ms 00 60 2h36m11s 2m36s [ User: labanimal - Total duration: 2h53m27s - 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-04-01 23:55:01 Duration: 2m56s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_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-04-01 08:22:01 Duration: 1s616ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_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-04-01 12:00:01 Duration: 1s611ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
15 1s611ms 1s738ms 1s666ms 6 9s996ms 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 cagess."cageName" like (?) 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 Apr 01 09 1 1s616ms 1s616ms 10 1 1s707ms 1s707ms 12 1 1s611ms 1s611ms 13 2 3s414ms 1s707ms 14 1 1s646ms 1s646ms [ User: labanimal - Total duration: 9s996ms - Times executed: 6 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 9s996ms - Times executed: 6 ]
-
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, 452) THEN TRUE WHEN user_is_tgm (dam.editor, 452) THEN TRUE WHEN user_is_tgm (dam.tourist, 452) 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, 452) THEN TRUE WHEN user_is_tgm (sire.editor, 452) THEN TRUE WHEN user_is_tgm (sire.tourist, 452) 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 cagess."cageName" like ('30-089') 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-04-01 12:54:45 Duration: 1s738ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_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, 457) THEN TRUE WHEN user_is_tgm (dam.editor, 457) THEN TRUE WHEN user_is_tgm (dam.tourist, 457) 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, 457) THEN TRUE WHEN user_is_tgm (sire.editor, 457) THEN TRUE WHEN user_is_tgm (sire.tourist, 457) 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 cagess."cageName" like ('49-204') 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-04-01 09:24:31 Duration: 1s707ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_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, 452) THEN TRUE WHEN user_is_tgm (dam.editor, 452) THEN TRUE WHEN user_is_tgm (dam.tourist, 452) 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, 452) THEN TRUE WHEN user_is_tgm (sire.editor, 452) THEN TRUE WHEN user_is_tgm (sire.tourist, 452) 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 cagess."cageName" like ('30-089') 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-04-01 12:54:17 Duration: 1s676ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
16 772ms 1s30ms 926ms 7 6s482ms select p_update_breedings (?, null, ?, ?::date, null, ?::text, ?::text, null) as id;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Apr 01 09 4 3s743ms 935ms 10 1 982ms 982ms 13 2 1s756ms 878ms [ User: labanimal - Total duration: 6s482ms - Times executed: 7 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 6s482ms - Times executed: 7 ]
-
SELECT p_update_breedings (270, NULL, 16076, '2026-04-01'::date, NULL, '10294322'::text, '10290943'::text, NULL) AS id;
Date: 2026-04-01 08:22:14 Duration: 1s30ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
SELECT p_update_breedings (142, NULL, 7339, '2026-04-01'::date, NULL, '10294690'::text, '10294695'::text, NULL) AS id;
Date: 2026-04-01 09:20:26 Duration: 982ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
SELECT p_update_breedings (457, NULL, 9697, '2026-04-01'::date, NULL, '10289434'::text, '10289436'::text, NULL) AS id;
Date: 2026-04-01 08:47:07 Duration: 969ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
17 798ms 1s163ms 871ms 6 5s231ms 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 Apr 01 08 1 823ms 823ms 14 1 798ms 798ms 19 1 798ms 798ms 20 1 846ms 846ms 21 1 1s163ms 1s163ms 22 1 801ms 801ms [ User: labanimal - Total duration: 5s231ms - Times executed: 6 ]
[ Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 - Total duration: 5s231ms - Times executed: 6 ]
-
WITH damdam AS ( SELECT breedingid, string_agg(cast(dam as text), ';') AS dam FROM breedingsdams INNER JOIN ( SELECT id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS dam ON dam.id = breedingsdams.dam AND CASE WHEN user_is_tgm (dam.owner, 1) THEN TRUE WHEN user_is_tgm (dam.editor, 1) THEN TRUE WHEN user_is_tgm (dam.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), siresire AS ( SELECT breedingid, string_agg(cast(sire as text), ';') AS sire FROM breedingssires INNER JOIN ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS sire ON sire.id = breedingssires.sire AND CASE WHEN user_is_tgm (sire.owner, 1) THEN TRUE WHEN user_is_tgm (sire.editor, 1) THEN TRUE WHEN user_is_tgm (sire.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-04-01 20:52:34 Duration: 1s163ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
WITH damdam AS ( SELECT breedingid, string_agg(cast(dam as text), ';') AS dam FROM breedingsdams INNER JOIN ( SELECT id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS dam ON dam.id = breedingsdams.dam AND CASE WHEN user_is_tgm (dam.owner, 1) THEN TRUE WHEN user_is_tgm (dam.editor, 1) THEN TRUE WHEN user_is_tgm (dam.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), siresire AS ( SELECT breedingid, string_agg(cast(sire as text), ';') AS sire FROM breedingssires INNER JOIN ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS sire ON sire.id = breedingssires.sire AND CASE WHEN user_is_tgm (sire.owner, 1) THEN TRUE WHEN user_is_tgm (sire.editor, 1) THEN TRUE WHEN user_is_tgm (sire.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-04-01 19:12:43 Duration: 846ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
WITH damdam AS ( SELECT breedingid, string_agg(cast(dam as text), ';') AS dam FROM breedingsdams INNER JOIN ( SELECT id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS dam ON dam.id = breedingsdams.dam AND CASE WHEN user_is_tgm (dam.owner, 1) THEN TRUE WHEN user_is_tgm (dam.editor, 1) THEN TRUE WHEN user_is_tgm (dam.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), siresire AS ( SELECT breedingid, string_agg(cast(sire as text), ';') AS sire FROM breedingssires INNER JOIN ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS sire ON sire.id = breedingssires.sire AND CASE WHEN user_is_tgm (sire.owner, 1) THEN TRUE WHEN user_is_tgm (sire.editor, 1) THEN TRUE WHEN user_is_tgm (sire.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-04-01 07:02:04 Duration: 823ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
18 701ms 743ms 721ms 16 11s540ms 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 #18
Day Hour Count Duration Avg duration Apr 01 06 2 1s465ms 732ms 11 2 1s421ms 710ms 13 2 1s431ms 715ms 16 6 4s338ms 723ms 18 4 2s882ms 720ms [ User: labanimal - Total duration: 11s540ms - Times executed: 16 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 10s75ms - Times executed: 14 ]
[ Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 - Total duration: 1s465ms - 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, 490) AS is_owner, user_is_tgm (animals_search_mview.editor, 490) AS is_editor, user_is_tgm (animals_search_mview.tourist, 490) 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-04-01 15:45:20 Duration: 743ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_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, 10100000) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100000) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100000) 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-04-01 17:16:40 Duration: 739ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_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, 8) AS is_owner, user_is_tgm (animals_search_mview.editor, 8) AS is_editor, user_is_tgm (animals_search_mview.tourist, 8) 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-04-01 05:31:32 Duration: 735ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
19 702ms 749ms 720ms 5 3s603ms 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 #19
Day Hour Count Duration Avg duration Apr 01 09 1 715ms 715ms 10 2 1s405ms 702ms 14 2 1s483ms 741ms [ User: labanimal - Total duration: 3s603ms - Times executed: 5 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 3s603ms - Times executed: 5 ]
-
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, 10100129) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100129) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100129) 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-04-01 13:37:45 Duration: 749ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_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, 10100129) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100129) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100129) 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-04-01 13:38:17 Duration: 734ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_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-04-01 08:11:31 Duration: 715ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
20 639ms 726ms 663ms 16 10s618ms 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 #20
Day Hour Count Duration Avg duration Apr 01 06 2 1s450ms 725ms 11 2 1s286ms 643ms 13 2 1s302ms 651ms 16 6 3s953ms 658ms 18 4 2s626ms 656ms [ User: labanimal - Total duration: 10s618ms - Times executed: 16 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 9s168ms - Times executed: 14 ]
[ Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 - Total duration: 1s450ms - 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, 8) AS is_owner, user_is_tgm (animals_search_mview.editor, 8) AS is_editor, user_is_tgm (animals_search_mview.tourist, 8) 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-04-01 05:31:37 Duration: 726ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 8) AS is_owner, user_is_tgm (animals_search_mview.editor, 8) AS is_editor, user_is_tgm (animals_search_mview.tourist, 8) 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-04-01 05:31:33 Duration: 723ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 490) AS is_owner, user_is_tgm (animals_search_mview.editor, 490) AS is_editor, user_is_tgm (animals_search_mview.tourist, 490) 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-04-01 15:45:21 Duration: 676ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-01_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
- 109,377 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 152 FATAL entries
- 5 ERROR entries
- 0 WARNING entries
- 0 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 152 Max number of times the same event was reported
- 157 Total events found
Rank Times reported Error 1 152 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Apr 01 01 8 03 2 04 1 06 55 08 7 09 44 10 7 11 8 12 17 21 3 - FATAL: database "monitoring" does not exist
- FATAL: database "monitoring" does not exist
- FATAL: database "monitoring" does not exist
Date: 2026-04-01 00:02:29 Database: monitoring Application: User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
Date: 2026-04-01 00:02:30 Database: monitoring Application: User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
Date: 2026-04-01 00:11:40 Database: monitoring Application: User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
2 3 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Apr 01 12 3 - ERROR: column "animalid" does not exist
- ERROR: column "animalid" does not exist
- ERROR: column "animalid" does not exist
Hint: Perhaps you meant to reference the column "a.animalID".
Statement: SELECT animalID, s."commonName" AS species, dummy_strain_info, dummy_line_info, comments FROM animals a JOIN species s ON s.id = a.species WHERE a.deleted = false AND a.comments LIKE '%[DZHI-IMPORT-v1 row=%' AND s."commonName" = 'Maus' AND a.dummy_strain_info = 'B6.Ttn' ORDER BY a."animalID" LIMIT 3;Date: 2026-04-01 11:30:16 Database: zemm_produktiv_8 Application: psql User: deploy Remote: [local] Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
Hint: Perhaps you meant to reference the column "a.animalID".
Statement: SELECT animalID, s."commonName" AS species, dummy_strain_info, dummy_line_info, comments FROM animals a JOIN species s ON s.id = a.species WHERE a.deleted = false AND a.comments LIKE '%[DZHI-IMPORT-v1 row=%' AND s."commonName" = 'Maus' AND a.dummy_strain_info = 'B10.mdx' ORDER BY a."animalID" LIMIT 3;Date: 2026-04-01 11:30:16 Database: zemm_produktiv_8 Application: psql User: deploy Remote: [local] Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
Hint: Perhaps you meant to reference the column "a.animalID".
Statement: SELECT animalID, s."commonName" AS species, dummy_strain_info, dummy_line_info, comments FROM animals a JOIN species s ON s.id = a.species WHERE a.deleted = false AND a.comments LIKE '%[DZHI-IMPORT-v1 row=%' AND s."commonName" = 'Zebrafisch' ORDER BY a."animalID" LIMIT 10;Date: 2026-04-01 11:30:16 Database: zemm_produktiv_8 Application: psql User: deploy Remote: [local] Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
3 1 ERROR: invalid regular expression: parentheses () not balanced
Times Reported Most Frequent Error / Event #3
Day Hour Count Apr 01 11 1 - ERROR: invalid regular expression: parentheses () not balanced
Statement: SELECT COUNT(DISTINCT substring(comments from '\\[DZHI-IMPORT-v1 row=([0-9]+)\\]')) FROM animals WHERE deleted = false AND comments LIKE '%[DZHI-IMPORT-v1 row=%';
Date: 2026-04-01 10:03:06 Database: zemm_produktiv_8 Application: psql User: deploy Remote: [local] Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv
4 1 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Apr 01 09 1 - ERROR: syntax error at or near ")"
Statement: UPDATE breedings SET id = id, unbreeding_date = '2026-04-01'::DATE WHERE id IN ();
Date: 2026-04-01 08:21:34 Database: zemm_produktiv_8 Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-04-01_000000.csv