ZEMM PG Report-
Global information
- Generated on Thu Apr 30 06:05:25 2026
- Log file: /var/log/postgresql/postgresql-2026-03-25_000000.csv, ..., /var/log/postgresql/postgresql-2026-04-30_000000.csv
- Parsed 275,054 log entries in 5m24s
- Log start from 2026-03-31 00:00:01 to 2026-03-31 23:59:03
-
Overview
Global Stats
- 1,632 Number of unique normalized queries
- 20,457 Number of queries
- 5h22m54s Total query duration
- 2026-03-31 00:00:01 First query
- 2026-03-31 23:59:01 Last query
- 991 queries/s at 2026-03-31 11:52:10 Query peak
- 5h22m54s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 5h22m54s Execute total duration
- 633 Number of events
- 14 Number of unique normalized events
- 483 Max number of times the same event was reported
- 0 Number of cancellation
- 117 Total number of automatic vacuums
- 221 Total number of automatic analyzes
- 179 Number temporary file
- 29.31 MiB Max size of temporary file
- 5.01 MiB Average size of temporary file
- 26,110 Total number of sessions
- 17 sessions at 2026-03-31 07:17:12 Session peak
- 5h48m52s Total duration of sessions
- 801ms Average duration of sessions
- 0 Average queries per session
- 742ms Average queries duration per session
- 59ms Average idle time per session
- 26,227 Total number of connections
- 39 connections/s at 2026-03-31 18:20:24 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 991 queries/s Query Peak
- 2026-03-31 11:52:10 Date
SELECT Traffic
Key values
- 3 queries/s Query Peak
- 2026-03-31 09:34:51 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 827 queries/s Query Peak
- 2026-03-31 11:52:10 Date
Queries duration
Key values
- 5h22m54s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 31 00 780 0ms 0ms 0ms 0ms 0ms 0ms 01 781 0ms 1s129ms 546ms 14s679ms 14s679ms 14s679ms 02 780 1s129ms 1s129ms 1s129ms 14s679ms 14s679ms 14s679ms 03 780 1s129ms 1s129ms 1s129ms 14s679ms 14s679ms 14s679ms 04 780 1s129ms 1s129ms 1s129ms 14s679ms 14s679ms 14s679ms 05 780 1s129ms 1s129ms 1s129ms 14s679ms 14s679ms 14s679ms 06 780 1s129ms 1s129ms 1s129ms 14s679ms 14s679ms 14s679ms 07 780 1s129ms 1s129ms 1s129ms 14s679ms 14s679ms 14s679ms 08 803 509ms 1s577ms 1s5ms 19s4ms 19s4ms 22s29ms 09 795 512ms 1s462ms 1s7ms 19s4ms 19s4ms 20s334ms 10 784 643ms 724ms 646ms 8s595ms 8s595ms 11s117ms 11 2,407 512ms 6s735ms 1s129ms 49s719ms 55s166ms 17m26s 12 792 546ms 710ms 591ms 8s500ms 9s823ms 11s866ms 13 788 510ms 992ms 629ms 12s902ms 12s902ms 14s4ms 14 786 550ms 2s277ms 1s363ms 29s367ms 29s367ms 29s367ms 15 793 533ms 2s259ms 1s269ms 29s367ms 29s367ms 32s70ms 16 780 1s355ms 1s355ms 1s355ms 17s621ms 17s621ms 17s621ms 17 790 544ms 1s537ms 1s100ms 19s981ms 19s981ms 21s110ms 18 785 792ms 838ms 820ms 10s902ms 11s162ms 11s461ms 19 781 838ms 838ms 838ms 10s902ms 10s902ms 11s741ms 20 781 812ms 838ms 835ms 10s902ms 10s902ms 11s714ms 21 780 812ms 812ms 812ms 10s559ms 10s559ms 10s559ms 22 780 812ms 812ms 812ms 10s559ms 10s559ms 10s559ms 23 791 550ms 1s976ms 806ms 12s996ms 19s258ms 19s258ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 31 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 22 0 828ms 752ms 1s328ms 2s526ms 09 15 0 868ms 0ms 994ms 2s793ms 10 4 0 683ms 0ms 0ms 0ms 11 19 32 2s822ms 2s591ms 7s251ms 22s306ms 12 12 0 619ms 0ms 0ms 2s702ms 13 6 0 702ms 0ms 0ms 1s561ms 14 4 0 680ms 0ms 0ms 1s334ms 15 12 0 886ms 0ms 0ms 2s703ms 16 0 0 0ms 0ms 0ms 0ms 17 5 0 866ms 0ms 0ms 1s414ms 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 2 5 1s141ms 0ms 0ms 1s442ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 31 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 1 0 0 1s129ms 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 8 2s285ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Mar 31 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Mar 31 00 501 0.14/s 01 255 0.07/s 02 244 0.07/s 03 253 0.07/s 04 265 0.07/s 05 301 0.08/s 06 731 0.20/s 07 880 0.24/s 08 1,718 0.48/s 09 2,172 0.60/s 10 1,544 0.43/s 11 1,852 0.51/s 12 2,284 0.63/s 13 2,273 0.63/s 14 1,308 0.36/s 15 1,764 0.49/s 16 967 0.27/s 17 1,604 0.45/s 18 1,788 0.50/s 19 771 0.21/s 20 1,006 0.28/s 21 618 0.17/s 22 548 0.15/s 23 580 0.16/s Day Hour Count Average Duration Average idle time Mar 31 00 489 193ms 193ms 01 255 287ms 0ms 02 244 292ms 0ms 03 251 285ms 0ms 04 265 272ms 0ms 05 301 252ms 0ms 06 731 176ms 0ms 07 878 185ms 0ms 08 1,718 175ms 0ms 09 2,172 144ms 0ms 10 1,544 157ms 0ms 11 1,828 345ms 0ms 12 2,284 132ms 0ms 13 2,273 177ms 0ms 14 1,308 146ms 0ms 15 1,762 234ms 0ms 16 967 135ms 0ms 17 1,606 10s14ms 9s473ms 18 1,788 140ms 0ms 19 771 128ms 0ms 20 1,000 439ms 0ms 21 604 175ms 0ms 22 535 177ms 0ms 23 536 327ms 0ms -
Connections
Established Connections
Key values
- 39 connections Connection Peak
- 2026-03-31 18:20:24 Date
Connections per database
Key values
- zemm_monitoring Main Database
- 26,227 connections Total
Connections per user
Key values
- labanimal Main User
- 26,227 connections Total
-
Sessions
Simultaneous sessions
Key values
- 17 sessions Session Peak
- 2026-03-31 07:17:12 Date
Histogram of session times
Key values
- 23,762 0-500ms duration
Sessions per database
Key values
- zemm_monitoring Main Database
- 26,110 sessions Total
Sessions per user
Key values
- labanimal Main User
- 26,110 sessions Total
Sessions per host
Key values
- ::1 Main Host
- 26,110 sessions Total
Sessions per application
Key values
- Main Application
- 26,110 sessions Total
Application Count Total Duration Average Duration 21,365 59m1s 165ms DBeaver 22.2.4 - Main 'zemm_produktiv_7' 2 1m26s 43s2ms DBeaver 22.2.4 - Main 'zemm_produktiv_8' 1 41s529ms 41s529ms DBeaver 22.2.4 - Read PostgreSQL database list 2 567ms 283ms DBeaver 24.3.2 - Main 'zemm_produktiv_7' 2 2h15m 1h7m30s DBeaver 24.3.2 - Main 'zemm_produktiv_8' 2 2h14m21s 1h7m10s DBeaver 24.3.2 - Read PostgreSQL database list 2 704ms 352ms _backend_cage_autocomplete_api.php_q_2025_limit_12_zemm_produkt 8 194ms 24ms _backend_cage_autocomplete_api.php_q_55-065_limit_12_zemm_produ 8 233ms 29ms _backend_wean_api.php_litter_id_10130227_zemm_produktiv_7_local 40 5s648ms 141ms _backend_wean_api.php_litter_id_10130236_zemm_produktiv_7_local 40 5s941ms 148ms _backend_wean_api.php_litter_id_10130257_zemm_produktiv_7_local 48 7s78ms 147ms _backend_wean_api.php_litter_id_10130581_zemm_produktiv_8_local 1 140ms 140ms _backend_wean_api.php_litter_id_10131233_zemm_produktiv_8_local 1 142ms 142ms _backend_wean_api.php_litter_id_10131518_zemm_produktiv_8_local 7 976ms 139ms _backend_wean_api.php_litter_id_10131613_zemm_produktiv_8_local 5 702ms 140ms _backend_wean_api.php_litter_id_10131614_zemm_produktiv_8_local 5 694ms 138ms _backend_wean_api.php_litter_id_10131625_zemm_produktiv_8_local 2 282ms 141ms _backend_wean_api.php_litter_id_10131626_zemm_produktiv_8_local 2 282ms 141ms _backend_wean_api.php_litter_id_10131627_zemm_produktiv_8_local 4 560ms 140ms _backend_wean_api.php_litter_id_10131628_zemm_produktiv_8_local 5 692ms 138ms _backend_wean_api.php_litter_id_10131629_zemm_produktiv_8_local 2 281ms 140ms _backend_wean_api.php_litter_id_10131631_zemm_produktiv_8_local 2 281ms 140ms _backend_wean_api.php_litter_id_10131661_zemm_produktiv_8_local 2 283ms 141ms _backend_wean_api.php_litter_id_10131662_zemm_produktiv_8_local 2 281ms 140ms _backend_wean_api.php_litter_id_10131663_zemm_produktiv_8_local 2 285ms 142ms _backend_wean_api.php_litter_id_10131664_zemm_produktiv_8_local 2 281ms 140ms _backend_wean_api.php_litter_id_10131665_zemm_produktiv_8_local 2 290ms 145ms _backend_wean_api.php_litter_id_10131676_zemm_produktiv_8_local 2 281ms 140ms _backend_wean_api.php_litter_id_10131679_zemm_produktiv_8_local 2 285ms 142ms _backend_wean_api.php_litter_id_10131738_zemm_produktiv_8_local 2 282ms 141ms _backend_wean_api.php_litter_id_10131739_zemm_produktiv_8_local 2 284ms 142ms _backend_wean_api.php_litter_id_10131745_zemm_produktiv_8_local 2 278ms 139ms _backend_wean_api.php_litter_id_10131897_zemm_produktiv_8_local 2 284ms 142ms _backend_wean_api.php_litter_id_10131948_zemm_produktiv_8_local 2 281ms 140ms _backend_wean_api.php_litter_id_10131949_zemm_produktiv_8_local 2 281ms 140ms _backend_wean_api.php_litter_id_10131950_zemm_produktiv_8_local 3 418ms 139ms _backend_wean_api.php_litter_id_10131951_zemm_produktiv_8_local 2 281ms 140ms _backend_wean_api.php_litter_id_10131957_zemm_produktiv_8_local 2 275ms 137ms _backend_wean_api.php_litter_id_10131958_zemm_produktiv_8_local 2 283ms 141ms _backend_wean_api.php_litter_id_10131959_zemm_produktiv_8_local 2 281ms 140ms _backend_wean_api.php_litter_id_10131978_zemm_produktiv_8_local 3 425ms 141ms _desktop__command_tasks_command_tasks_subcommand_open_screen__q 1 68ms 68ms _desktop__zemm_produktiv_7_localhost_5432 10 662ms 66ms _desktop__zemm_produktiv_8_localhost_5432 18 1s124ms 62ms _desktop_index.php_animal_name_13_animal_id_2026_2F000_2F1476_s 2 85ms 42ms _desktop_index.php_command_animals_breedings_subcommand_select_ 9 439ms 48ms _desktop_index.php_command_animals_create_subcommand_init_zemm_ 9 549ms 61ms _desktop_index.php_command_animals_edit_subcommand_init_id_1026 2 199ms 99ms _desktop_index.php_command_animals_edit_subcommand_init_id_1027 2 219ms 109ms _desktop_index.php_command_animals_edit_subcommand_init_id_1028 2 194ms 97ms _desktop_index.php_command_animals_edit_subcommand_init_id_1029 1 100ms 100ms _desktop_index.php_command_animals_edit_subcommand_link_init_va 8 917ms 114ms _desktop_index.php_command_animals_edit_subcommand_m_init_scree 8 1s 125ms _desktop_index.php_command_animals_litters_edit_subcommand_init 8 880ms 110ms _desktop_index.php_command_animals_litters_edit_subcommand_m_in 8 2s563ms 320ms _desktop_index.php_command_animals_litters_subcommand_select_ze 9 445ms 49ms _desktop_index.php_command_animals_subcommand_init_zemm_produkt 8 371ms 46ms _desktop_index.php_command_animals_subcommand_select_zemm_produ 9 610ms 67ms _desktop_index.php_command_cages_subcommand_init_zemm_produktiv 1 43ms 43ms _desktop_index.php_command_documents_subcommand_init_zemm_produ 5 227ms 45ms _desktop_index.php_command_login_subcommand_init_zemm_produktiv 331 10s698ms 32ms _desktop_index.php_command_reports_subcommand_animals_per_room_ 4 525ms 131ms _desktop_index.php_command_reports_subcommand_animals_per_user_ 10 1s115ms 111ms _desktop_index.php_command_reports_subcommand_cage_utilisation_ 2 230ms 115ms _desktop_index.php_command_reports_subcommand_fates_zemm_produk 9 1s51ms 116ms _desktop_index.php_command_reports_subcommand_init_zemm_produkt 17 5s64ms 297ms _desktop_index.php_command_reports_subcommand_room_utilisation_ 6 675ms 112ms _desktop_index.php_command_reports_subcommand_task_status_zemm_ 1 114ms 114ms _desktop_index.php_command_tasks_subcommand_edit_id_10134267_ze 8 705ms 88ms _desktop_index.php_command_tasks_subcommand_edit_id_10139885_ze 1 84ms 84ms _desktop_index.php_command_tasks_subcommand_edit_id_10140860_ze 1 86ms 86ms _desktop_index.php_command_tasks_subcommand_edit_id_10141310_ze 2 165ms 82ms _desktop_index.php_command_tasks_subcommand_edit_id_10141663_ze 1 84ms 84ms _desktop_index.php_command_tasks_subcommand_edit_id_10141713_ze 1 85ms 85ms _desktop_index.php_command_tasks_subcommand_edit_id_10141838_ze 1 81ms 81ms _desktop_index.php_command_tasks_subcommand_edit_id_10141941_ze 1 86ms 86ms _desktop_index.php_command_tasks_subcommand_edit_id_10141951_ze 1 84ms 84ms _desktop_index.php_command_tasks_subcommand_edit_id_10141976_ze 3 249ms 83ms _desktop_index.php_command_tasks_subcommand_found_val1_10100176 1 41ms 41ms _desktop_index.php_command_tasks_subcommand_init_search_zemm_pr 8 430ms 53ms _desktop_index.php_command_tasks_subcommand_init_zemm_produktiv 1 69ms 69ms _desktop_index.php_command_tasks_subcommand_open_zemm_produktiv 114 9s691ms 85ms _desktop_index.php_command_tasks_subcommand_owner_tasks_zemm_pr 1 74ms 74ms _desktop_index.php_command_tasks_subcommand_search_zemm_produkt 21 966ms 46ms _desktop_index.php_m_action_animals_edit_3Alink_init_row_animal 1 47ms 47ms _desktop_index.php_m_action_cages_3Am_cage_card_row_7390_7390_r 2 12s418ms 6s209ms _desktop_index.php_name_Genotypisierungsproben_20genommen_instr 2 136ms 68ms _desktop_index.php_name_Projektwechsel_20lebender_20Tiere_instr 1 67ms 67ms _desktop_index.php_name_Tiertransport_20innerhalb_20W_C3_BCrzbu 1 51ms 51ms _desktop_index.php_search_status__25_deadline_from_2025-09-19_d 1 173ms 173ms _desktop_index.php_search_status__25_issued_from_2025-09-19_iss 1 150ms 150ms _desktop_index.php_search_status__25_issued_from_2026-02-01_iss 12 1s186ms 98ms _desktop_index.php_unweaned_only_true_val4_animals_litters_sear 1 141ms 141ms _desktop_index.php_view_animal_name_on_view_animal_id_on_animal 2 463ms 231ms _desktop_index.php_view_animal_name_on_view_animal_id_on_view_b 41 15s999ms 390ms _desktop_index.php_view_animal_name_on_view_animal_id_on_view_s 2 734ms 367ms _desktop_index.php_zemm_produktiv_7_localhost_5432 201 49s492ms 246ms _desktop_index.php_zemm_produktiv_8_localhost_5432 3,302 11m53s 216ms backend:zemm_produktiv_8@localhost 43 2s590ms 60ms expire_tasks:zemm_produktiv_8@h2940066.stratoserver.net:5432 1 1s145ms 1s145ms pg_dump 5 1m58s 23s758ms pg_restore 1 40s174ms 40s174ms psql 180 59s198ms 328ms taskscron:zemm_produktiv_7@zemm.fbiscience.eu 24 1s253ms 52ms taskscron:zemm_produktiv_8@h2940066.stratoserver.net:5432 24 9s761ms 406ms -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 167,626 buffers Checkpoint Peak
- 2026-03-31 11:59:35 Date
- 269.902 seconds Highest write time
- 0.104 seconds Sync time
Checkpoints Wal files
Key values
- 85 files Wal files usage Peak
- 2026-03-31 11:59:35 Date
Checkpoints distance
Key values
- 2,736.72 Mo Distance Peak
- 2026-03-31 11:59:35 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Mar 31 00 6,950 542.113s 0.088s 542.254s 01 20,551 467.782s 0.081s 467.915s 02 1,981 198.72s 0.085s 198.86s 03 2,252 225.855s 0.081s 225.995s 04 2,065 207.159s 0.09s 207.299s 05 84,924 509.849s 0.081s 509.999s 06 7,590 759.882s 0.15s 760.093s 07 5,252 525.957s 0.161s 526.173s 08 31,678 1,155.434s 0.247s 1,155.747s 09 5,726 573.595s 0.227s 573.873s 10 7,560 757.582s 0.191s 757.834s 11 179,684 884.784s 0.301s 885.308s 12 5,820 583.045s 0.202s 583.321s 13 8,469 847.98s 0.219s 848.269s 14 4,447 445.648s 0.169s 445.882s 15 4,386 439.359s 0.169s 439.588s 16 2,999 300.687s 0.101s 300.852s 17 4,133 414.083s 0.117s 414.263s 18 18,787 729.909s 0.203s 730.191s 19 2,947 295.499s 0.077s 295.632s 20 3,133 314.058s 0.088s 314.198s 21 8,001 574.988s 0.074s 575.127s 22 3,187 319.32s 0.076s 319.456s 23 8,721 872.199s 0.116s 874.638s Day Hour Added Removed Recycled Synced files Longest sync Average sync Mar 31 00 0 0 1 372 0.003s 0.012s 01 0 0 8 364 0.002s 0.011s 02 0 0 0 356 0.002s 0.012s 03 0 0 1 357 0.002s 0.012s 04 0 0 1 388 0.002s 0.012s 05 0 0 18 367 0.002s 0.012s 06 0 0 2 823 0.002s 0.012s 07 0 0 1 894 0.003s 0.012s 08 0 0 12 1,447 0.002s 0.012s 09 0 0 1 1,288 0.003s 0.012s 10 0 0 3 1,111 0.002s 0.012s 11 1 2 86 1,790 0.002s 0.012s 12 0 1 1 1,159 0.003s 0.012s 13 0 3 0 1,228 0.003s 0.012s 14 0 2 0 936 0.003s 0.012s 15 0 1 0 970 0.002s 0.012s 16 0 1 0 530 0.002s 0.012s 17 0 1 0 633 0.002s 0.012s 18 0 3 0 630 0.056s 0.013s 19 0 1 0 360 0.002s 0.012s 20 0 1 0 426 0.002s 0.012s 21 0 2 0 353 0.002s 0.012s 22 0 1 0 357 0.002s 0.012s 23 0 2 0 601 0.002s 0.012s Day Hour Count Avg time (sec) Mar 31 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Mar 31 00 1,952.42 kB 6,068.58 kB 01 11,045.91 kB 36,410.27 kB 02 996.25 kB 43,737.33 kB 03 1,035.33 kB 13,076.67 kB 04 1,005.17 kB 4,425.33 kB 05 24,562.25 kB 82,339.67 kB 06 2,964.92 kB 112,408.92 kB 07 1,891.50 kB 33,267.83 kB 08 15,147.42 kB 51,591.75 kB 09 2,343.33 kB 18,497.25 kB 10 3,743.08 kB 12,083.33 kB 11 120,645.42 kB 123,528.75 kB 12 2,312.75 kB 755,163.83 kB 13 4,461.33 kB 216,152.50 kB 14 1,685.92 kB 62,761.92 kB 15 1,584.58 kB 18,897.75 kB 16 1,218.92 kB 6,294.08 kB 17 1,669.08 kB 3,510.75 kB 18 3,839.58 kB 8,920.75 kB 19 1,213.50 kB 8,906.67 kB 20 1,369.92 kB 3,461.00 kB 21 2,719.08 kB 11,070.92 kB 22 1,322.25 kB 4,096.58 kB 23 3,461.25 kB 7,965.08 kB -
Temporary Files
Size of temporary files
Key values
- 181.05 MiB Temp Files size Peak
- 2026-03-31 11:52:32 Date
Number of temporary files
Key values
- 44 per second Temp Files Peak
- 2026-03-31 11:52:30 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Mar 31 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 179 896.13 MiB 5.01 MiB 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 10 42.53 MiB 8.00 KiB 10.10 MiB 4.25 MiB alter table only public.diary add constraint diary_pkey primary key (id);-
ALTER TABLE ONLY public.diary ADD CONSTRAINT diary_pkey PRIMARY KEY (id);
Date: 2026-03-31 11:52:30 Duration: 555ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
2 10 126.63 MiB 8.00 KiB 29.31 MiB 12.66 MiB alter table only public."targetgroupMembers" add constraint "targetgroupMembers_pkey" primary key (id);-
ALTER TABLE ONLY public."targetgroupMembers" ADD CONSTRAINT "targetgroupMembers_pkey" PRIMARY KEY (id);
Date: 2026-03-31 11:52:31 Duration: 555ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
3 8 43.95 MiB 8.00 KiB 13.02 MiB 5.49 MiB alter table only public.targetgroups add constraint targetgroups_pkey primary key (id);-
ALTER TABLE ONLY public.targetgroups ADD CONSTRAINT targetgroups_pkey PRIMARY KEY (id);
Date: 2026-03-31 11:52:32 Duration: 1s144ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
4 8 11.64 MiB 8.00 KiB 4.29 MiB 1.46 MiB alter table only public.animals add constraint animals_pkey primary key (id);-
ALTER TABLE ONLY public.animals ADD CONSTRAINT animals_pkey PRIMARY KEY (id);
Date: 2026-03-31 11:52:29 Duration: 555ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
5 8 13.91 MiB 8.00 KiB 5.81 MiB 1.74 MiB alter table only public.cost_history add constraint cost_history_pkey primary key (id);-
ALTER TABLE ONLY public.cost_history ADD CONSTRAINT cost_history_pkey PRIMARY KEY (id);
Date: 2026-03-31 11:52:30 Duration: 555ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
6 8 11.63 MiB 8.00 KiB 4.01 MiB 1.45 MiB alter table only public.animals_search_mview add constraint animals_search_mview_pkey primary key (id);-
ALTER TABLE ONLY public.animals_search_mview ADD CONSTRAINT animals_search_mview_pkey PRIMARY KEY (id);
Date: 2026-03-31 11:52:29 Duration: 555ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
7 6 3.82 MiB 8.00 KiB 2.55 MiB 652.00 KiB create unique index idxsessionid on public.login_tracker using btree (sessionid);-
CREATE UNIQUE INDEX idxsessionid ON public.login_tracker USING btree (sessionid);
Date: 2026-03-31 11:52:35 Duration: 932ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
8 6 1.75 MiB 8.00 KiB 1.71 MiB 298.67 KiB alter table only public.login_tracker add constraint login_tracker_pkey primary key (id);-
ALTER TABLE ONLY public.login_tracker ADD CONSTRAINT login_tracker_pkey PRIMARY KEY (id);
Date: 2026-03-31 11:52:30 Duration: 555ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
9 6 1.12 MiB 8.00 KiB 1.08 MiB 190.67 KiB alter table only public.tasks add constraint tasks_pkey primary key (id);-
ALTER TABLE ONLY public.tasks ADD CONSTRAINT tasks_pkey PRIMARY KEY (id);
Date: 2026-03-31 11:52:32 Duration: 1s144ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
10 6 9.36 MiB 8.00 KiB 9.20 MiB 1.56 MiB alter table only public.tasks_changes add constraint tasks_changes_index01 primary key (id, task);-
ALTER TABLE ONLY public.tasks_changes ADD CONSTRAINT tasks_changes_index01 PRIMARY KEY (id, task);
Date: 2026-03-31 11:52:32 Duration: 1s144ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
11 5 42.51 MiB 8.04 MiB 10.05 MiB 8.50 MiB create index diary_animalid_idx on public.diary using btree ("animalID");-
CREATE INDEX diary_animalid_idx ON public.diary USING btree ("animalID");
Date: 2026-03-31 11:52:34 Duration: 932ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
12 5 126.59 MiB 23.91 MiB 25.95 MiB 25.32 MiB create index "targetgroupMembers_FKIndex2" on public."targetgroupMembers" using btree ("group");-
CREATE INDEX "targetgroupMembers_FKIndex2" ON public."targetgroupMembers" USING btree ("group");
Date: 2026-03-31 11:52:36 Duration: 1s244ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
13 5 126.59 MiB 24.21 MiB 26.09 MiB 25.32 MiB create index "targetgroupMembers_user_idx" on public."targetgroupMembers" using btree ("user");-
CREATE INDEX "targetgroupMembers_user_idx" ON public."targetgroupMembers" USING btree ("user");
Date: 2026-03-31 11:52:38 Duration: 1s332ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
14 5 126.59 MiB 24.34 MiB 26.46 MiB 25.32 MiB create index "targetgroupMembers_FKIndex1" on public."targetgroupMembers" using btree (targetgroup);-
CREATE INDEX "targetgroupMembers_FKIndex1" ON public."targetgroupMembers" USING btree (targetgroup);
Date: 2026-03-31 11:52:35 Duration: 932ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
15 4 2.34 MiB 8.00 KiB 1.91 MiB 598.00 KiB alter table only public.fem_numbers add constraint pkey primary key (id);-
ALTER TABLE ONLY public.fem_numbers ADD CONSTRAINT pkey PRIMARY KEY (id);
Date: 2026-03-31 11:52:31 Duration: 555ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
16 4 16.23 MiB 3.65 MiB 5.06 MiB 4.06 MiB create index animals_animalid_idx on public.animals using btree ("animalID");-
CREATE INDEX animals_animalid_idx ON public.animals USING btree ("animalID");
Date: 2026-03-31 11:52:33 Duration: 1s144ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
17 4 13.88 MiB 2.88 MiB 4.89 MiB 3.47 MiB create index cost_history_animal_idx on public.cost_history using btree (animal);-
CREATE INDEX cost_history_animal_idx ON public.cost_history USING btree (animal);
Date: 2026-03-31 11:52:34 Duration: 932ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
18 4 25.50 MiB 5.89 MiB 7.52 MiB 6.38 MiB create index animals_mview_idx on public.animals_search_mview using btree (id nulls first, owner nulls first, editor nulls first, tourist nulls first);-
CREATE INDEX animals_mview_idx ON public.animals_search_mview USING btree (id NULLS FIRST, owner NULLS FIRST, editor NULLS FIRST, tourist NULLS FIRST);
Date: 2026-03-31 11:52:34 Duration: 932ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
19 4 11.59 MiB 2.62 MiB 3.71 MiB 2.90 MiB create index animals_curcage_active_idx on public.animals using btree ("curCage") where (not deleted);-
CREATE INDEX animals_curcage_active_idx ON public.animals USING btree ("curCage") WHERE (NOT deleted);
Date: 2026-03-31 11:52:34 Duration: 932ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
20 4 3.26 MiB 8.00 KiB 2.34 MiB 834.00 KiB alter table only public.fem_numbers add constraint main_ukey unique (year, th, num);-
ALTER TABLE ONLY public.fem_numbers ADD CONSTRAINT main_ukey UNIQUE (year, th, num);
Date: 2026-03-31 11:52:30 Duration: 555ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
21 4 11.61 MiB 2.45 MiB 4.13 MiB 2.90 MiB create index "animals_FKIndex11" on public.animals using btree (species);-
CREATE INDEX "animals_FKIndex11" ON public.animals USING btree (species);
Date: 2026-03-31 11:52:33 Duration: 1s144ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
22 4 1.81 MiB 8.00 KiB 1.60 MiB 464.00 KiB alter table only public.litters add constraint litters_pkey primary key (id);-
ALTER TABLE ONLY public.litters ADD CONSTRAINT litters_pkey PRIMARY KEY (id);
Date: 2026-03-31 11:52:30 Duration: 555ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
23 4 11.60 MiB 2.38 MiB 4.17 MiB 2.90 MiB create index "animals_FKIndex2" on public.animals using btree ("homeCage");-
CREATE INDEX "animals_FKIndex2" ON public.animals USING btree ("homeCage");
Date: 2026-03-31 11:52:33 Duration: 1s144ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
24 4 1.82 MiB 8.00 KiB 1.80 MiB 466.00 KiB alter table only public.litters_search_mview add constraint litters_search_mview_pkey primary key (id);-
ALTER TABLE ONLY public.litters_search_mview ADD CONSTRAINT litters_search_mview_pkey PRIMARY KEY (id);
Date: 2026-03-31 11:52:30 Duration: 555ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
25 4 78.62 MiB 18.91 MiB 21.33 MiB 19.65 MiB create index titleindex on public.targetgroups using btree (title);-
CREATE INDEX titleindex ON public.targetgroups USING btree (title);
Date: 2026-03-31 11:52:39 Duration: 1s185ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
26 4 3.49 MiB 8.00 KiB 2.53 MiB 894.00 KiB alter table only public.litter_history add constraint litter_history_pkey primary key (id);-
ALTER TABLE ONLY public.litter_history ADD CONSTRAINT litter_history_pkey PRIMARY KEY (id);
Date: 2026-03-31 11:52:30 Duration: 555ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
27 4 3.81 MiB 8.00 KiB 3.38 MiB 976.00 KiB alter table only public.monitoring_session_activity add constraint monitoring_session_activity_pkey primary key (session_id);-
ALTER TABLE ONLY public.monitoring_session_activity ADD CONSTRAINT monitoring_session_activity_pkey PRIMARY KEY (session_id);
Date: 2026-03-31 11:52:31 Duration: 555ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
28 3 1.09 MiB 120.00 KiB 832.00 KiB 373.33 KiB create index tasks_editor_idx on public.tasks using btree (editor);-
CREATE INDEX tasks_editor_idx ON public.tasks USING btree (editor);
Date: 2026-03-31 11:52:39 Duration: 1s185ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
29 3 1.52 MiB 96.00 KiB 1.33 MiB 520.00 KiB create index tasks_id_parent_idx on public.tasks using btree (id, parent);-
CREATE INDEX tasks_id_parent_idx ON public.tasks USING btree (id, parent);
Date: 2026-03-31 11:52:39 Duration: 1s185ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
30 3 3.06 MiB 544.00 KiB 1.95 MiB 1.02 MiB create index login_tracker_loginname_timestamp_idx on public.login_tracker using btree (loginname, "timestamp" desc);-
CREATE INDEX login_tracker_loginname_timestamp_idx ON public.login_tracker USING btree (loginname, "timestamp" DESC);
Date: 2026-03-31 11:52:35 Duration: 932ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
31 3 1.10 MiB 128.00 KiB 840.00 KiB 376.00 KiB create index tasks_owner_index on public.tasks using btree (owner);-
CREATE INDEX tasks_owner_index ON public.tasks USING btree (owner);
Date: 2026-03-31 11:52:39 Duration: 1s185ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
32 3 1.73 MiB 184.00 KiB 1.31 MiB 589.33 KiB create index login_tracker_user_idx on public.login_tracker using btree ("user");-
CREATE INDEX login_tracker_user_idx ON public.login_tracker USING btree ("user");
Date: 2026-03-31 11:52:35 Duration: 932ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
33 3 1.09 MiB 152.00 KiB 808.00 KiB 373.33 KiB create index tasks_active_index on public.tasks using btree (active);-
CREATE INDEX tasks_active_index ON public.tasks USING btree (active);
Date: 2026-03-31 11:52:39 Duration: 1s185ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
34 3 6.67 MiB 1.85 MiB 2.95 MiB 2.22 MiB create index tasks_changes_deleted_idx on public.tasks_changes using btree (deleted);-
CREATE INDEX tasks_changes_deleted_idx ON public.tasks_changes USING btree (deleted);
Date: 2026-03-31 11:52:39 Duration: 1s185ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
35 3 1.09 MiB 136.00 KiB 816.00 KiB 373.33 KiB create index tasks_task_status_idx on public.tasks using btree (task_status);-
CREATE INDEX tasks_task_status_idx ON public.tasks USING btree (task_status);
Date: 2026-03-31 11:52:39 Duration: 1s185ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
36 3 1.09 MiB 48.00 KiB 992.00 KiB 373.33 KiB create index tasks_done_idx on public.tasks using btree (done);-
CREATE INDEX tasks_done_idx ON public.tasks USING btree (done);
Date: 2026-03-31 11:52:39 Duration: 1s185ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
37 2 1.80 MiB 384.00 KiB 1.43 MiB 924.00 KiB create index litters_dam_index on public.litters using btree (dam);-
CREATE INDEX litters_dam_index ON public.litters USING btree (dam);
Date: 2026-03-31 11:52:35 Duration: 932ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
38 2 1.72 MiB 184.00 KiB 1.54 MiB 880.00 KiB create index monitoring_session_activity_user_idx on public.monitoring_session_activity using btree (user_id);-
CREATE INDEX monitoring_session_activity_user_idx ON public.monitoring_session_activity USING btree (user_id);
Date: 2026-03-31 11:52:35 Duration: 932ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
Queries generating the largest temporary files
Rank Size Query 1 29.31 MiB ALTER TABLE ONLY public."targetgroupMembers" ADD CONSTRAINT "targetgroupMembers_pkey" PRIMARY KEY (id);[ Date: 2026-03-31 11:52:32 - Database: zemm_produktiv_7 - User: labanimal - Application: pg_restore ]
2 26.46 MiB CREATE INDEX "targetgroupMembers_FKIndex1" ON public."targetgroupMembers" USING btree (targetgroup);[ Date: 2026-03-31 11:52:36 - Database: zemm_produktiv_7 - User: labanimal - Application: pg_restore ]
3 26.09 MiB CREATE INDEX "targetgroupMembers_user_idx" ON public."targetgroupMembers" USING btree ("user");[ Date: 2026-03-31 11:52:39 - Database: zemm_produktiv_7 - User: labanimal - Application: pg_restore ]
4 25.95 MiB CREATE INDEX "targetgroupMembers_FKIndex2" ON public."targetgroupMembers" USING btree ("group");[ Date: 2026-03-31 11:52:38 - Database: zemm_produktiv_7 - User: labanimal - Application: pg_restore ]
5 25.92 MiB CREATE INDEX "targetgroupMembers_FKIndex2" ON public."targetgroupMembers" USING btree ("group");[ Date: 2026-03-31 11:52:38 - Database: zemm_produktiv_7 - User: labanimal - Application: pg_restore ]
6 25.70 MiB CREATE INDEX "targetgroupMembers_FKIndex2" ON public."targetgroupMembers" USING btree ("group");[ Date: 2026-03-31 11:52:38 - Database: zemm_produktiv_7 - User: labanimal - Application: pg_restore ]
7 25.69 MiB ALTER TABLE ONLY public."targetgroupMembers" ADD CONSTRAINT "targetgroupMembers_pkey" PRIMARY KEY (id);[ Date: 2026-03-31 11:52:32 - Database: zemm_produktiv_7 - User: labanimal - Application: pg_restore ]
8 25.65 MiB CREATE INDEX "targetgroupMembers_user_idx" ON public."targetgroupMembers" USING btree ("user");[ Date: 2026-03-31 11:52:39 - Database: zemm_produktiv_7 - User: labanimal - Application: pg_restore ]
9 25.49 MiB CREATE INDEX "targetgroupMembers_FKIndex1" ON public."targetgroupMembers" USING btree (targetgroup);[ Date: 2026-03-31 11:52:36 - Database: zemm_produktiv_7 - User: labanimal - Application: pg_restore ]
10 25.38 MiB CREATE INDEX "targetgroupMembers_user_idx" ON public."targetgroupMembers" USING btree ("user");[ Date: 2026-03-31 11:52:39 - Database: zemm_produktiv_7 - User: labanimal - Application: pg_restore ]
11 25.35 MiB CREATE INDEX "targetgroupMembers_FKIndex1" ON public."targetgroupMembers" USING btree (targetgroup);[ Date: 2026-03-31 11:52:36 - Database: zemm_produktiv_7 - User: labanimal - Application: pg_restore ]
12 25.26 MiB CREATE INDEX "targetgroupMembers_user_idx" ON public."targetgroupMembers" USING btree ("user");[ Date: 2026-03-31 11:52:39 - Database: zemm_produktiv_7 - User: labanimal - Application: pg_restore ]
13 25.21 MiB ALTER TABLE ONLY public."targetgroupMembers" ADD CONSTRAINT "targetgroupMembers_pkey" PRIMARY KEY (id);[ Date: 2026-03-31 11:52:32 - Database: zemm_produktiv_7 - User: labanimal - Application: pg_restore ]
14 25.12 MiB CREATE INDEX "targetgroupMembers_FKIndex2" ON public."targetgroupMembers" USING btree ("group");[ Date: 2026-03-31 11:52:38 - Database: zemm_produktiv_7 - User: labanimal - Application: pg_restore ]
15 24.94 MiB CREATE INDEX "targetgroupMembers_FKIndex1" ON public."targetgroupMembers" USING btree (targetgroup);[ Date: 2026-03-31 11:52:36 - Database: zemm_produktiv_7 - User: labanimal - Application: pg_restore ]
16 24.34 MiB CREATE INDEX "targetgroupMembers_FKIndex1" ON public."targetgroupMembers" USING btree (targetgroup);[ Date: 2026-03-31 11:52:36 - Database: zemm_produktiv_7 - User: labanimal - Application: pg_restore ]
17 24.21 MiB CREATE INDEX "targetgroupMembers_user_idx" ON public."targetgroupMembers" USING btree ("user");[ Date: 2026-03-31 11:52:39 - Database: zemm_produktiv_7 - User: labanimal - Application: pg_restore ]
18 23.91 MiB CREATE INDEX "targetgroupMembers_FKIndex2" ON public."targetgroupMembers" USING btree ("group");[ Date: 2026-03-31 11:52:38 - Database: zemm_produktiv_7 - User: labanimal - Application: pg_restore ]
19 23.67 MiB ALTER TABLE ONLY public."targetgroupMembers" ADD CONSTRAINT "targetgroupMembers_pkey" PRIMARY KEY (id);[ Date: 2026-03-31 11:52:32 - Database: zemm_produktiv_7 - User: labanimal - Application: pg_restore ]
20 22.71 MiB ALTER TABLE ONLY public."targetgroupMembers" ADD CONSTRAINT "targetgroupMembers_pkey" PRIMARY KEY (id);[ Date: 2026-03-31 11:52:32 - Database: zemm_produktiv_7 - User: labanimal - Application: pg_restore ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 22.90 sec Highest CPU-cost vacuum
Table observability.db_top_queries
Database zemm_monitoring - 2026-03-31 05:38:32 Date
- 0 sec Highest CPU-cost analyze
Table
Database zemm_monitoring - Date
Average Autovacuum Duration
Key values
- 22.90 sec Highest CPU-cost vacuum
Table observability.db_top_queries
Database zemm_monitoring - 2026-03-31 05:38:32 Date
Analyzes per table
Key values
- pg_catalog.pg_type (49) Main table analyzed (database zemm_produktiv_8)
- 221 analyzes Total
Table Number of analyzes zemm_produktiv_8.pg_catalog.pg_type 49 zemm_produktiv_8.pg_catalog.pg_attribute 37 zemm_produktiv_8.pg_catalog.pg_class 26 zemm_produktiv_8.pg_catalog.pg_depend 24 zemm_produktiv_8.public.breedingssires 4 zemm_produktiv_8.public.breedingsdams 4 bucardo.pg_catalog.pg_shdepend 2 zemm_produktiv_7.public.cages_search_mview 2 zemm_monitoring.observability.metrics_timeseries 2 zemm_produktiv_7.public.users 2 zemm_produktiv_8.public.tmptasks 2 zemm_produktiv_7.pg_catalog.pg_attribute 2 zemm_produktiv_8.public.cages_search_mview 2 zemm_produktiv_7.pg_catalog.pg_type 2 zemm_monitoring.observability.system_metrics 1 zemm_produktiv_7.pg_catalog.pg_index 1 zemm_produktiv_7.public.strains 1 zemm_produktiv_7.public.animals_search_mview 1 zemm_produktiv_7.pg_catalog.pg_depend 1 zemm_produktiv_7.public.user_ui_prefs 1 zemm_produktiv_7.public.diary 1 zemm_produktiv_7.public.monitoring_session_activity 1 fbi_unibi.pg_catalog.pg_shdepend 1 zemm_produktiv_7.public.groupMembers 1 zemm_produktiv_7.pg_catalog.pg_trigger 1 zemm_produktiv_7.public.licenses 1 zemm_produktiv_7.pg_catalog.pg_shdepend 1 zemm_produktiv_7.public.cages 1 zemm_produktiv_7.public.choice 1 zemm_produktiv_7.public.taskattachment 1 zemm_produktiv_7.public.animals 1 zemm_produktiv_7.public.documents 1 zemm_produktiv_7.public.scoresheet_answer 1 zemm_produktiv_7.pg_catalog.pg_description 1 zemm_produktiv_7.public.sys_actions 1 zemm_produktiv_7.pg_catalog.pg_sequence 1 zemm_produktiv_7.public.targetgroups 1 zemm_produktiv_7.public.tasks_changes 1 zemm_produktiv_7.public.stresslevel_response 1 zemm_produktiv_7.public.fem_numbers 1 zemm_produktiv_7.pg_catalog.pg_attrdef 1 zemm_produktiv_7.public.breedingssires 1 zemm_monitoring.pg_catalog.pg_shdepend 1 zemm_produktiv_7.pg_catalog.pg_proc 1 zemm_test_2.pg_catalog.pg_shdepend 1 zemm_produktiv_7.public.litter_history 1 zemm_produktiv_7.public.login_tracker 1 zemm_produktiv_7.public.question 1 fbi_ci_db.pg_catalog.pg_shdepend 1 zemm_produktiv_7.public.breedingsdams 1 zemm_produktiv_7.pg_catalog.pg_rewrite 1 zemm_produktiv_8.public.login_tracker 1 zemm_produktiv_7.public.sys_screens 1 zemm_produktiv_7.public.scoresheet_diary 1 zemm_monitoring.observability.app_events 1 zemm_produktiv_7.pg_catalog.pg_class 1 zemm_produktiv_7.public.groups 1 zemm_produktiv_8.public.tasks 1 zemm_produktiv_7.public.license_history 1 labanimal.pg_catalog.pg_shdepend 1 zemm_produktiv_7.public.roles_users 1 zemm_produktiv_7.public.breedings 1 zemm_produktiv_7.public.tasks 1 zemm_produktiv_8.public.users 1 zemm_produktiv_7.pg_catalog.pg_constraint 1 zemm_produktiv_7.public.locations 1 zemm_produktiv_7.public.litters 1 zemm_produktiv_8.public.monitoring_session_activity 1 zemm_produktiv_7.public.scoresheet_response 1 zemm_produktiv_7.public.tmptasks 1 zemm_produktiv_7.public.litters_search_mview 1 zemm_produktiv_7.public.cost_history 1 postgres.pg_catalog.pg_shdepend 1 zemm_produktiv_7.public.targetgroupMembers 1 zemm_produktiv_8.public.cost_history 1 Total 221 Vacuums per table
Key values
- pg_catalog.pg_type (17) Main table vacuumed on database zemm_produktiv_8
- 117 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples zemm_produktiv_8.pg_catalog.pg_type 17 17 0 0 0 0 0 904 218 231,457 0 0 zemm_produktiv_8.pg_catalog.pg_attribute 13 13 0 0 0 0 0 1,692 583 385,997 0 0 zemm_produktiv_8.pg_catalog.pg_class 8 8 0 0 0 0 0 778 250 300,783 0 0 zemm_produktiv_8.pg_catalog.pg_depend 6 6 0 0 0 0 0 742 197 249,581 0 0 zemm_monitoring.pg_toast.pg_toast_67431 6 0 0 0 0 0 0 4,156 1,405 3,189,420 1,371 8,226 zemm_produktiv_8.public.breedingsdams 4 0 0 0 0 0 0 792 211 722,266 0 0 zemm_produktiv_8.public.breedingssires 4 0 0 0 0 0 0 593 162 537,887 0 0 zemm_produktiv_8.pg_toast.pg_toast_2619 3 3 0 0 0 0 0 559 141 731,456 35 116 zemm_monitoring.pg_catalog.pg_shdepend 2 2 0 0 0 0 0 193 41 91,636 10 479 zemm_produktiv_7.pg_catalog.pg_statistic 2 2 0 0 0 0 0 412 20 71,353 3 25 fbi_ci_db.pg_catalog.pg_shdepend 2 2 0 0 0 0 0 191 66 125,077 0 0 zemm_produktiv_7.pg_toast.pg_toast_1255 1 1 0 0 0 0 0 84 12 69,147 0 0 zemm_produktiv_7.public.targetgroups 1 0 0 0 0 0 0 16,131 7 952,724 0 0 zemm_produktiv_7.public.stresslevel_response 1 0 0 0 0 0 0 16 6 1,754 0 0 zemm_produktiv_7.public.tasks_changes 1 0 0 0 0 0 0 3,786 4 224,030 0 0 zemm_produktiv_7.pg_catalog.pg_attribute 1 1 0 0 0 0 0 488 11 81,283 0 0 zemm_produktiv_7.public.fem_numbers 1 0 0 0 0 0 0 1,012 4 60,369 0 0 zemm_produktiv_7.pg_catalog.pg_attrdef 1 1 0 0 0 0 0 38 1 3,547 0 0 zemm_produktiv_7.public.breedingssires 1 0 0 0 0 0 0 152 6 9,790 0 0 zemm_produktiv_7.pg_catalog.pg_sequence 1 1 0 0 0 0 0 15 6 3,751 0 0 zemm_produktiv_7.public.scoresheet_answer 1 0 0 0 0 0 0 36 6 2,968 0 0 zemm_produktiv_8.public.tmptasks 1 1 0 0 0 0 0 83 33 13,987 0 0 zemm_produktiv_7.public.animals 1 0 0 0 0 0 0 15,948 7 941,927 0 0 zemm_produktiv_7.public.taskattachment 1 0 0 0 0 0 0 298 6 18,816 0 0 zemm_produktiv_7.public.groupMembers 1 0 0 0 0 0 0 9 4 1,187 0 0 zemm_produktiv_7.pg_catalog.pg_trigger 1 1 0 0 0 0 0 57 13 13,325 0 0 zemm_produktiv_7.public.licenses 1 0 0 0 0 0 0 25 6 2,319 0 0 zemm_produktiv_7.public.cages 1 0 0 0 0 0 0 185 6 12,005 0 0 zemm_produktiv_7.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 309 9 62,818 0 0 zemm_produktiv_7.public.users 1 0 0 0 0 0 0 66 6 4,817 0 0 zemm_produktiv_8.pg_catalog.pg_statistic 1 1 0 0 0 0 0 194 59 183,821 36 101 zemm_produktiv_7.public.strains 1 0 0 0 0 0 0 61 6 4,504 0 0 zemm_produktiv_7.public.cages_search_mview 1 0 0 0 0 0 0 209 6 13,442 0 0 zemm_produktiv_7.public.animals_search_mview 1 0 0 0 0 0 0 23,018 9 1,359,283 0 0 zemm_monitoring.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 120 30 208,165 11 32 zemm_produktiv_7.pg_catalog.pg_depend 1 1 0 0 0 0 0 205 24 63,694 0 0 zemm_monitoring.observability.metrics_timeseries 1 1 0 0 0 0 0 9,283 4,228 8,734,793 588 16,535 zemm_produktiv_7.public.diary 1 0 0 0 0 0 0 31,746 11 1,874,461 0 0 zemm_produktiv_7.public.user_ui_prefs 1 0 0 0 0 0 0 117 6 8,122 0 0 zemm_produktiv_7.public.monitoring_session_activity 1 0 0 0 0 0 0 1,074 4 64,022 0 0 zemm_monitoring.observability.db_top_queries 1 0 0 0 0 0 0 145,352 82,398 286,432,873 31,456 242,085 zemm_produktiv_7.pg_catalog.pg_index 1 1 0 0 0 0 0 30 2 5,615 0 0 zemm_monitoring.observability.system_metrics 1 0 0 0 0 0 0 654 654 1,091,691 0 0 zemm_produktiv_7.public.litters_search_mview 1 0 0 0 0 0 0 2,499 4 148,097 0 0 zemm_produktiv_7.public.cost_history 1 0 0 0 0 0 0 9,355 6 552,827 0 0 zemm_produktiv_7.public.targetgroupMembers 1 0 0 0 0 0 0 42,188 5 2,489,817 0 0 zemm_produktiv_7.public.litters 1 0 0 0 0 0 0 1,084 4 64,612 0 0 zemm_produktiv_7.pg_catalog.pg_type 1 1 0 0 0 0 0 53 4 9,018 0 0 zemm_produktiv_7.public.tmptasks 1 0 0 0 0 0 0 107 6 7,324 0 0 zemm_produktiv_7.public.breedings 1 0 0 0 0 0 0 226 6 14,435 0 0 zemm_produktiv_7.public.tasks 1 0 0 0 0 0 0 8,705 6 514,477 0 0 zemm_produktiv_7.pg_catalog.pg_constraint 1 1 0 0 0 0 0 78 15 18,136 0 0 zemm_produktiv_8.public.tasks 1 1 0 0 0 0 0 48,401 69 3,727,937 0 0 zemm_produktiv_7.public.license_history 1 0 0 0 0 0 0 174 6 11,089 0 0 zemm_produktiv_7.public.scoresheet_diary 1 0 0 0 0 0 0 10 4 1,246 0 0 zemm_monitoring.observability.app_events 1 0 0 0 0 0 0 13,901 13,713 17,609,065 0 0 zemm_produktiv_7.pg_catalog.pg_class 1 1 0 0 0 0 0 94 9 19,838 0 0 zemm_produktiv_7.public.breedingsdams 1 0 0 0 0 0 0 202 6 12,741 0 0 zemm_produktiv_7.public.login_tracker 1 0 0 0 0 0 0 3,327 4 196,949 0 0 zemm_produktiv_7.public.litter_history 1 0 0 0 0 0 0 1,680 4 99,776 0 0 zemm_monitoring.pg_toast.pg_toast_67411 1 0 0 0 0 0 0 4,323 1,352 10,397,918 1,350 5,400 Total 117 69 0 0 0 0 0 398,220 106,107 345,057,265 34,860 272,999 Vacuum throughput per table
Key values
- observability.db_top_queries (22.9) Max CPU elapsed for vacuum on database zemm_monitoring
- observability.db_top_queries (15.928 ms) Max I/O read time for vacuum on database zemm_monitoring
- observability.metrics_timeseries (0.991 ms) Max I/O write time for vacuum on database zemm_monitoring
I/O timing (ms) CPU (s) Table read write elapsed zemm_produktiv_8.pg_catalog.pg_type 0 0 0 zemm_produktiv_8.pg_catalog.pg_attribute 0 0 0.13 zemm_produktiv_8.pg_catalog.pg_class 0 0 0.02 zemm_produktiv_8.pg_catalog.pg_depend 0 0 0.04 zemm_monitoring.pg_toast.pg_toast_67431 0 0 0.3 zemm_produktiv_8.public.breedingsdams 0 0.064 0 zemm_produktiv_8.public.breedingssires 0 0.114 0 zemm_produktiv_8.pg_toast.pg_toast_2619 0 0 0.03 zemm_monitoring.pg_catalog.pg_shdepend 0 0 0.01 zemm_produktiv_7.pg_catalog.pg_statistic 0.521 0 0 fbi_ci_db.pg_catalog.pg_shdepend 0 0 0.02 zemm_produktiv_7.pg_toast.pg_toast_1255 0.494 0 0 zemm_produktiv_7.public.targetgroups 0 0.125 3.41 zemm_produktiv_7.public.stresslevel_response 0 0.039 0 zemm_produktiv_7.public.tasks_changes 0.06 0.036 0.47 zemm_produktiv_7.pg_catalog.pg_attribute 0.336 0 0.01 zemm_produktiv_7.public.fem_numbers 0.037 0.035 0.02 zemm_produktiv_7.pg_catalog.pg_attrdef 0 0 0 zemm_produktiv_7.public.breedingssires 0 0.037 0 zemm_produktiv_7.pg_catalog.pg_sequence 0 0 0 zemm_produktiv_7.public.scoresheet_answer 0 0.037 0 zemm_produktiv_8.public.tmptasks 0 0 0.01 zemm_produktiv_7.public.animals 0 0.134 3.27 zemm_produktiv_7.public.taskattachment 0.012 0.036 0.01 zemm_produktiv_7.public.groupMembers 0 0.035 0 zemm_produktiv_7.pg_catalog.pg_trigger 0.288 0.027 0 zemm_produktiv_7.public.licenses 0 0.041 0 zemm_produktiv_7.public.cages 0 0.038 0.01 zemm_produktiv_7.pg_toast.pg_toast_2619 0.491 0 0 zemm_produktiv_7.public.users 0 0.036 0 zemm_produktiv_8.pg_catalog.pg_statistic 0 0 0.01 zemm_produktiv_7.public.strains 0.037 0.035 0 zemm_produktiv_7.public.cages_search_mview 0.047 0.067 0.01 zemm_produktiv_7.public.animals_search_mview 0.056 0.184 9.65 zemm_monitoring.pg_toast.pg_toast_2619 0 0 0 zemm_produktiv_7.pg_catalog.pg_depend 0.842 0 0.01 zemm_monitoring.observability.metrics_timeseries 5.252 0.991 1.29 zemm_produktiv_7.public.diary 0 0.246 6.98 zemm_produktiv_7.public.user_ui_prefs 0 0.054 0.02 zemm_produktiv_7.public.monitoring_session_activity 0 0.039 0.02 zemm_monitoring.observability.db_top_queries 15.928 0.081 22.9 zemm_produktiv_7.pg_catalog.pg_index 0 0 0 zemm_monitoring.observability.system_metrics 0 0 0.16 zemm_produktiv_7.public.litters_search_mview 0.044 0.036 0.16 zemm_produktiv_7.public.cost_history 0 0.099 1.77 zemm_produktiv_7.public.targetgroupMembers 0 0.361 13.75 zemm_produktiv_7.public.litters 0 0.035 0.02 zemm_produktiv_7.pg_catalog.pg_type 0 0 0 zemm_produktiv_7.public.tmptasks 0.014 0.036 0 zemm_produktiv_7.public.breedings 0 0.063 0.01 zemm_produktiv_7.public.tasks 0 0.091 1.57 zemm_produktiv_7.pg_catalog.pg_constraint 0.287 0.026 0 zemm_produktiv_8.public.tasks 0 0 0.63 zemm_produktiv_7.public.license_history 0 0.031 0 zemm_produktiv_7.public.scoresheet_diary 0 0.042 0 zemm_monitoring.observability.app_events 0 0 3.24 zemm_produktiv_7.pg_catalog.pg_class 0.081 0 0 zemm_produktiv_7.public.breedingsdams 0 0.038 0.01 zemm_produktiv_7.public.login_tracker 0 0.039 0.35 zemm_produktiv_7.public.litter_history 0 0.043 0.04 zemm_monitoring.pg_toast.pg_toast_67411 0 0 0.33 Total 24.827 3.471 70.69 Tuples removed per table
Key values
- public.tasks (53507) Main table with removed tuples on database zemm_produktiv_8
- 131369 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain zemm_produktiv_8.public.tasks 1 1 53,507 56,602 0 0 16,648 zemm_monitoring.observability.metrics_timeseries 1 1 43,198 290,908 0 0 6,155 zemm_produktiv_8.pg_catalog.pg_attribute 13 13 12,936 74,350 0 0 2,392 zemm_produktiv_8.pg_catalog.pg_depend 6 6 5,180 25,026 0 0 330 zemm_produktiv_7.pg_catalog.pg_attribute 1 1 3,824 5,733 0 0 190 zemm_produktiv_8.pg_catalog.pg_type 17 17 3,450 14,127 0 0 527 zemm_produktiv_7.pg_catalog.pg_depend 1 1 2,722 4,171 0 0 51 zemm_produktiv_8.pg_catalog.pg_class 8 8 1,249 7,152 0 0 336 zemm_monitoring.pg_catalog.pg_shdepend 2 2 1,223 7,698 0 0 76 zemm_produktiv_7.pg_catalog.pg_statistic 2 2 813 1,512 0 0 192 fbi_ci_db.pg_catalog.pg_shdepend 2 2 701 7,698 0 0 76 zemm_produktiv_7.pg_catalog.pg_constraint 1 1 367 605 0 9 15 zemm_produktiv_7.pg_toast.pg_toast_2619 1 1 344 255 0 0 130 zemm_produktiv_8.pg_toast.pg_toast_2619 3 3 318 840 0 0 318 zemm_produktiv_7.pg_catalog.pg_trigger 1 1 303 323 0 7 7 zemm_produktiv_7.pg_catalog.pg_type 1 1 280 831 0 0 27 zemm_produktiv_8.pg_catalog.pg_statistic 1 1 271 1,271 0 0 144 zemm_produktiv_7.pg_catalog.pg_index 1 1 207 388 0 0 14 zemm_produktiv_7.pg_catalog.pg_attrdef 1 1 141 143 0 0 15 zemm_produktiv_8.public.tmptasks 1 1 96 812 0 7 115 zemm_produktiv_7.pg_catalog.pg_sequence 1 1 90 88 0 1 2 zemm_produktiv_7.pg_toast.pg_toast_1255 1 1 84 45 0 0 30 zemm_monitoring.pg_toast.pg_toast_2619 1 1 65 80 0 0 37 zemm_produktiv_7.public.targetgroups 1 0 0 2,297,054 0 0 16,128 zemm_produktiv_7.public.stresslevel_response 1 0 0 1,663 0 2 8 zemm_produktiv_7.public.tasks_changes 1 0 0 348,474 0 0 3,800 zemm_produktiv_7.public.fem_numbers 1 0 0 120,932 0 0 1,032 zemm_produktiv_7.public.breedingssires 1 0 0 22,479 0 32 144 zemm_produktiv_7.public.scoresheet_answer 1 0 0 3,387 0 4 28 zemm_produktiv_7.public.animals 1 0 0 606,266 0 0 15,968 zemm_produktiv_7.public.taskattachment 1 0 0 16,618 0 54 290 zemm_produktiv_7.public.groupMembers 1 0 0 767 0 0 5 zemm_produktiv_7.public.licenses 1 0 0 633 0 15 17 zemm_produktiv_7.public.cages 1 0 0 13,626 0 47 177 zemm_produktiv_7.public.users 1 0 0 755 0 14 58 zemm_produktiv_7.public.strains 1 0 0 2,264 0 11 53 zemm_produktiv_7.public.cages_search_mview 1 0 0 13,629 0 47 201 zemm_produktiv_7.public.animals_search_mview 1 0 0 606,266 0 0 23,048 zemm_produktiv_7.public.diary 1 0 0 2,222,801 0 0 31,776 zemm_produktiv_7.public.user_ui_prefs 1 0 0 743 0 29 107 zemm_produktiv_7.public.monitoring_session_activity 1 0 0 89,518 0 0 1,096 zemm_monitoring.observability.db_top_queries 1 0 0 6,817,549 0 0 741,429 zemm_monitoring.observability.system_metrics 1 0 0 24,005 0 0 3,002 zemm_produktiv_7.public.litters_search_mview 1 0 0 93,716 0 0 2,512 zemm_produktiv_7.public.cost_history 1 0 0 725,411 0 0 9,392 zemm_produktiv_7.public.targetgroupMembers 1 0 0 6,622,882 0 0 42,224 zemm_produktiv_8.public.breedingsdams 4 0 0 121,482 0 0 776 zemm_produktiv_7.public.litters 1 0 0 93,714 0 0 1,104 zemm_produktiv_7.public.tmptasks 1 0 0 1,004 0 45 99 zemm_produktiv_7.public.breedings 1 0 0 22,467 0 54 218 zemm_produktiv_7.public.tasks 1 0 0 56,614 0 0 8,720 zemm_produktiv_7.public.license_history 1 0 0 22,535 0 26 166 zemm_produktiv_7.public.scoresheet_diary 1 0 0 1,057 0 0 6 zemm_monitoring.observability.app_events 1 0 0 667,267 0 0 55,153 zemm_produktiv_7.pg_catalog.pg_class 1 1 0 894 0 0 39 zemm_monitoring.pg_toast.pg_toast_67431 6 0 0 1,554,696 0 0 260,094 zemm_produktiv_7.public.breedingsdams 1 0 0 30,373 0 46 194 zemm_produktiv_7.public.login_tracker 1 0 0 89,518 0 0 3,336 zemm_produktiv_7.public.litter_history 1 0 0 181,446 0 0 1,680 zemm_monitoring.pg_toast.pg_toast_67411 1 0 0 62,215 0 0 15,002 zemm_produktiv_8.public.breedingssires 4 0 0 89,910 0 0 576 Total 117 69 131,369 24,147,288 0 450 1,267,485 Pages removed per table
Key values
- public.taskattachment (54) Main table with removed pages on database zemm_produktiv_7
- 450 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed zemm_produktiv_7.public.taskattachment 1 0 0 54 zemm_produktiv_7.public.breedings 1 0 0 54 zemm_produktiv_7.public.cages 1 0 0 47 zemm_produktiv_7.public.cages_search_mview 1 0 0 47 zemm_produktiv_7.public.breedingsdams 1 0 0 46 zemm_produktiv_7.public.tmptasks 1 0 0 45 zemm_produktiv_7.public.breedingssires 1 0 0 32 zemm_produktiv_7.public.user_ui_prefs 1 0 0 29 zemm_produktiv_7.public.license_history 1 0 0 26 zemm_produktiv_7.public.licenses 1 0 0 15 zemm_produktiv_7.public.users 1 0 0 14 zemm_produktiv_7.public.strains 1 0 0 11 zemm_produktiv_7.pg_catalog.pg_constraint 1 1 367 9 zemm_produktiv_8.public.tmptasks 1 1 96 7 zemm_produktiv_7.pg_catalog.pg_trigger 1 1 303 7 zemm_produktiv_7.public.scoresheet_answer 1 0 0 4 zemm_produktiv_7.public.stresslevel_response 1 0 0 2 zemm_produktiv_7.pg_catalog.pg_sequence 1 1 90 1 zemm_produktiv_7.pg_toast.pg_toast_1255 1 1 84 0 zemm_produktiv_7.public.targetgroups 1 0 0 0 zemm_produktiv_7.public.tasks_changes 1 0 0 0 zemm_produktiv_7.pg_catalog.pg_attribute 1 1 3824 0 zemm_produktiv_7.public.fem_numbers 1 0 0 0 zemm_produktiv_7.pg_catalog.pg_attrdef 1 1 141 0 zemm_monitoring.pg_catalog.pg_shdepend 2 2 1223 0 zemm_produktiv_7.public.animals 1 0 0 0 zemm_produktiv_7.public.groupMembers 1 0 0 0 zemm_produktiv_7.pg_toast.pg_toast_2619 1 1 344 0 zemm_produktiv_8.pg_toast.pg_toast_2619 3 3 318 0 zemm_produktiv_8.pg_catalog.pg_statistic 1 1 271 0 zemm_produktiv_7.public.animals_search_mview 1 0 0 0 zemm_monitoring.pg_toast.pg_toast_2619 1 1 65 0 zemm_produktiv_7.pg_catalog.pg_depend 1 1 2722 0 zemm_monitoring.observability.metrics_timeseries 1 1 43198 0 zemm_produktiv_7.public.diary 1 0 0 0 zemm_produktiv_8.pg_catalog.pg_type 17 17 3450 0 zemm_produktiv_7.public.monitoring_session_activity 1 0 0 0 zemm_monitoring.observability.db_top_queries 1 0 0 0 zemm_produktiv_7.pg_catalog.pg_index 1 1 207 0 zemm_monitoring.observability.system_metrics 1 0 0 0 zemm_produktiv_7.public.litters_search_mview 1 0 0 0 zemm_produktiv_7.public.cost_history 1 0 0 0 zemm_produktiv_8.pg_catalog.pg_attribute 13 13 12936 0 zemm_produktiv_7.public.targetgroupMembers 1 0 0 0 zemm_produktiv_8.public.breedingsdams 4 0 0 0 zemm_produktiv_7.public.litters 1 0 0 0 zemm_produktiv_7.pg_catalog.pg_type 1 1 280 0 zemm_produktiv_8.pg_catalog.pg_class 8 8 1249 0 zemm_produktiv_7.public.tasks 1 0 0 0 zemm_produktiv_8.public.tasks 1 1 53507 0 zemm_produktiv_7.pg_catalog.pg_statistic 2 2 813 0 zemm_produktiv_7.public.scoresheet_diary 1 0 0 0 zemm_monitoring.observability.app_events 1 0 0 0 zemm_produktiv_8.pg_catalog.pg_depend 6 6 5180 0 zemm_produktiv_7.pg_catalog.pg_class 1 1 0 0 fbi_ci_db.pg_catalog.pg_shdepend 2 2 701 0 zemm_monitoring.pg_toast.pg_toast_67431 6 0 0 0 zemm_produktiv_7.public.login_tracker 1 0 0 0 zemm_produktiv_7.public.litter_history 1 0 0 0 zemm_monitoring.pg_toast.pg_toast_67411 1 0 0 0 zemm_produktiv_8.public.breedingssires 4 0 0 0 Total 117 69 131,369 450 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Mar 31 00 1 0 01 1 2 02 0 0 03 1 0 04 0 1 05 1 0 06 5 11 07 5 16 08 17 27 09 5 16 10 10 22 11 49 66 12 5 16 13 4 12 14 3 9 15 4 11 16 1 4 17 2 5 18 1 1 19 1 0 20 0 1 21 0 0 22 0 0 23 1 1 - 22.90 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
- 101 Total read queries
- 20,179 Total write queries
Queries by database
Key values
- zemm_monitoring Main database
- 18,722 Requests
- 5h2m24s (zemm_monitoring)
- Main time consuming database
Database Request type Count Duration zemm_monitoring Total 18,722 5h2m24s ddl 18,720 5h2m23s tcl 2 1s129ms zemm_produktiv_7 Total 1,608 17m30s copy from 8 18s286ms copy to 16 44s171ms cte 9 7s465ms ddl 1,396 14m37s others 166 1m28s select 2 1s442ms zemm_produktiv_8 Total 127 2m59s copy to 21 50s966ms cte 6 8s546ms select 99 1m58s update 1 1s129ms Queries by user
Key values
- labanimal Main user
- 150,551 Requests
User Request type Count Duration deploy Total 4 3s249ms ddl 2 1s624ms others 2 1s624ms labanimal Total 150,551 1d19h2m8s copy from 8 18s286ms copy to 40 1m50s cte 87 2m17s ddl 149,594 1d18h43m57s others 164 1m26s select 637 11m54s tcl 2 1s129ms update 8 8s737ms postgres Total 40 51s827ms copy to 40 51s827ms Duration by user
Key values
- 1d19h2m8s (labanimal) Main time consuming user
User Request type Count Duration deploy Total 4 3s249ms ddl 2 1s624ms others 2 1s624ms labanimal Total 150,551 1d19h2m8s copy from 8 18s286ms copy to 40 1m50s cte 87 2m17s ddl 149,594 1d18h43m57s others 164 1m26s select 637 11m54s tcl 2 1s129ms update 8 8s737ms postgres Total 40 51s827ms copy to 40 51s827ms Queries by host
Key values
- unknown Main host
- 150,543 Requests
- 1d19h1m59s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 18,722 Requests
- 5h2m24s (unknown)
- Main time consuming application
Application Request type Count Duration _desktop_index.php_m_action_cages_3Am_cage_card_row_7390_7390_r Total 2 1s101ms cte 2 1s101ms _desktop_index.php_zemm_produktiv_7_localhost_5432 Total 11 8s908ms cte 9 7s465ms select 2 1s442ms _desktop_index.php_zemm_produktiv_8_localhost_5432 Total 103 2m6s cte 4 7s444ms select 99 1m58s expire_tasks:zemm_produktiv_8@h2940066.stratoserver.net:5432 Total 1 1s129ms update 1 1s129ms pg_dump Total 37 1m35s copy to 37 1m35s pg_restore Total 1,576 16m33s copy from 8 18s286ms ddl 1,393 14m35s others 164 1m26s psql Total 5 4s87ms ddl 3 2s463ms others 2 1s624ms unknown Total 18,722 5h2m24s ddl 18,720 5h2m23s tcl 2 1s129ms Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-03-31 10:26:56 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 96 500-1000ms duration
Slowest individual queries
Rank Duration Query 1 6s735ms COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;[ Date: 2026-03-31 11:48:55 - Database: zemm_produktiv_8 - User: labanimal - Application: pg_dump ]
2 6s706ms COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;[ Date: 2026-03-31 11:52:05 - Database: zemm_produktiv_7 - User: labanimal - Application: pg_dump ]
3 6s669ms COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;[ Date: 2026-03-31 11:49:22 - Database: zemm_produktiv_7 - User: labanimal - Application: pg_dump ]
4 6s668ms COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;[ Date: 2026-03-31 11:51:38 - Database: zemm_produktiv_8 - User: labanimal - Application: pg_dump ]
5 4s924ms COPY public.animals_search_mview (id, name, animal_id, deleted, alive, birth_date, arrival_date, death_date, outgoing_date, cage, comments, sterile, breeding, fate, last_mating, last_mating_date, breeding_cage, sex, strain, line, gene_1_info, gene_1_type, gene_2_info, gene_2_type, gene_3_info, gene_3_type, gene_4_info, gene_4_type, gene_5_info, gene_5_type, backcross, generation, project, project_name, species, species_name, cage_name, location, location_name, dam, dam_name, dam_id, sire, sire_name, sire_id, cohort, litter, rfid, owner, editor, tourist, breeding_status, workgroup_infos, experiment, experiment_name) TO stdout;[ Date: 2026-03-31 11:48:41 - Database: zemm_produktiv_8 - User: labanimal - Application: pg_dump ]
6 4s902ms COPY public.animals_search_mview (id, name, animal_id, deleted, alive, birth_date, arrival_date, death_date, outgoing_date, cage, comments, sterile, breeding, fate, last_mating, last_mating_date, breeding_cage, sex, strain, line, gene_1_info, gene_1_type, gene_2_info, gene_2_type, gene_3_info, gene_3_type, gene_4_info, gene_4_type, gene_5_info, gene_5_type, backcross, generation, project, project_name, species, species_name, cage_name, location, location_name, dam, dam_name, dam_id, sire, sire_name, sire_id, cohort, litter, rfid, owner, editor, tourist, breeding_status, workgroup_infos, experiment, experiment_name) TO stdout;[ Date: 2026-03-31 11:51:25 - Database: zemm_produktiv_8 - User: labanimal - Application: pg_dump ]
7 4s884ms COPY public.animals_search_mview (id, name, animal_id, deleted, alive, birth_date, arrival_date, death_date, outgoing_date, cage, comments, sterile, breeding, fate, last_mating, last_mating_date, breeding_cage, sex, strain, line, gene_1_info, gene_1_type, gene_2_info, gene_2_type, gene_3_info, gene_3_type, gene_4_info, gene_4_type, gene_5_info, gene_5_type, backcross, generation, project, project_name, species, species_name, cage_name, location, location_name, dam, dam_name, dam_id, sire, sire_name, sire_id, cohort, litter, rfid, owner, editor, tourist, breeding_status, workgroup_infos, experiment, experiment_name) TO stdout;[ Date: 2026-03-31 11:51:51 - Database: zemm_produktiv_7 - User: labanimal - Application: pg_dump ]
8 4s862ms COPY public.animals_search_mview (id, name, animal_id, deleted, alive, birth_date, arrival_date, death_date, outgoing_date, cage, comments, sterile, breeding, fate, last_mating, last_mating_date, breeding_cage, sex, strain, line, gene_1_info, gene_1_type, gene_2_info, gene_2_type, gene_3_info, gene_3_type, gene_4_info, gene_4_type, gene_5_info, gene_5_type, backcross, generation, project, project_name, species, species_name, cage_name, location, location_name, dam, dam_name, dam_id, sire, sire_name, sire_id, cohort, litter, rfid, owner, editor, tourist, breeding_status, workgroup_infos, experiment, experiment_name) TO stdout;[ Date: 2026-03-31 11:49:08 - Database: zemm_produktiv_7 - User: labanimal - Application: pg_dump ]
9 4s428ms COPY public."targetgroupMembers" (id, targetgroup, "user", "group") FROM stdin;[ Date: 2026-03-31 11:52:26 - Database: zemm_produktiv_7 - User: labanimal - Application: pg_restore ]
10 4s318ms COPY public.diary (id, "animalID", date, "entrybyID", "cageID", weight, temperature, "fDeprivation", "wDeprivation", "sDeprivation", "feedingClass", health, comments, "breedingInfo", deleted, "inOutDate", "inOutFlag", text, sdesc, treatment, tailcut_id, tailcut_result, file_name, file_content, file_type, upload_name, old_gene_type, old_gene_info, old_gene2_type, old_gene2_info, old_gene3_info, old_gene3_type, old_gene4_info, old_gene4_type, old_gene5_info, old_gene5_type) FROM stdin;[ Date: 2026-03-31 11:52:21 - Database: zemm_produktiv_7 - User: labanimal - Application: pg_restore ]
11 3s737ms SELECT * FROM litters_search_mview l WHERE NOT (deleted) AND CASE WHEN user_is_tgm (l.owner, 438) THEN TRUE WHEN user_is_tgm (l.editor, 438) THEN TRUE WHEN user_is_tgm (l.tourist, 438) THEN TRUE ELSE FALSE END AND (offspring - CASE WHEN male_wean IS NULL THEN 0 ELSE male_wean END - CASE WHEN female_wean IS NULL THEN 0 ELSE female_wean END - CASE WHEN male_dead IS NULL THEN 0 ELSE male_dead END - CASE WHEN female_dead IS NULL THEN 0 ELSE female_dead END - CASE WHEN female_deceased IS NULL THEN 0 ELSE female_deceased END - CASE WHEN male_deceased IS NULL THEN 0 ELSE male_deceased END) <= 0 ORDER BY bday DESC, dam_name, sire_name;[ Date: 2026-03-31 11:30:19 - Database: zemm_produktiv_8 - User: labanimal - Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 ]
12 3s693ms SELECT * FROM litters_search_mview l WHERE NOT (deleted) AND CASE WHEN user_is_tgm (l.owner, 438) THEN TRUE WHEN user_is_tgm (l.editor, 438) THEN TRUE WHEN user_is_tgm (l.tourist, 438) THEN TRUE ELSE FALSE END AND (offspring - CASE WHEN male_wean IS NULL THEN 0 ELSE male_wean END - CASE WHEN female_wean IS NULL THEN 0 ELSE female_wean END - CASE WHEN male_dead IS NULL THEN 0 ELSE male_dead END - CASE WHEN female_dead IS NULL THEN 0 ELSE female_dead END - CASE WHEN female_deceased IS NULL THEN 0 ELSE female_deceased END - CASE WHEN male_deceased IS NULL THEN 0 ELSE male_deceased END) <= 0 ORDER BY bday DESC, dam_name, sire_name;[ Date: 2026-03-31 11:30:23 - Database: zemm_produktiv_8 - User: labanimal - Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 ]
13 3s681ms CREATE INDEX "users_FKIndex1" ON public.users USING btree ("group");[ Date: 2026-03-31 11:52:43 - Database: zemm_produktiv_7 - User: labanimal - Application: pg_restore ]
14 3s681ms CREATE INDEX "users_FKIndex2" ON public.users USING btree (affiliation);[ Date: 2026-03-31 11:52:43 - Database: zemm_produktiv_7 - User: labanimal - Application: pg_restore ]
15 3s681ms CREATE INDEX "users_has_groups_FKIndex1" ON public."groupMembers" USING btree ("user");[ Date: 2026-03-31 11:52:43 - Database: zemm_produktiv_7 - User: labanimal - Application: pg_restore ]
16 3s681ms CREATE INDEX "users_has_groups_FKIndex2" ON public."groupMembers" USING btree ("group");[ Date: 2026-03-31 11:52:43 - Database: zemm_produktiv_7 - User: labanimal - Application: pg_restore ]
17 3s681ms CREATE TRIGGER insert_animals_search_mview_by_experiment AFTER INSERT OR DELETE OR UPDATE ON public.projects_animals FOR EACH ROW EXECUTE FUNCTION public.insert_search_mviews_by_experiment ();[ Date: 2026-03-31 11:52:43 - Database: zemm_produktiv_7 - User: labanimal - Application: pg_restore ]
18 3s681ms CREATE TRIGGER insert_animals_trigger AFTER INSERT ON public.animals FOR EACH ROW EXECUTE FUNCTION public.insert_search_mviews_by_animals ();[ Date: 2026-03-31 11:52:43 - Database: zemm_produktiv_7 - User: labanimal - Application: pg_restore ]
19 3s681ms CREATE TRIGGER insert_breedings_trigger AFTER INSERT ON public.breedings FOR EACH ROW EXECUTE FUNCTION public.insert_search_mviews_by_breedings ();[ Date: 2026-03-31 11:52:43 - Database: zemm_produktiv_7 - User: labanimal - Application: pg_restore ]
20 3s681ms CREATE TRIGGER insert_licensehistory_trigger AFTER INSERT ON public.animals FOR EACH ROW EXECUTE FUNCTION public.update_license_history ();[ Date: 2026-03-31 11:52:43 - Database: zemm_produktiv_7 - User: labanimal - Application: pg_restore ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 23m15s 1,440 509ms 3s587ms 969ms 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 #1
Day Hour Count Duration Avg duration Mar 31 01 60 0ms 0ms 02 60 32s747ms 545ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 1m7s 1s129ms 09 60 1m 1s9ms 10 60 1m 1s10ms 11 60 38s794ms 646ms 12 60 2m1s 2s28ms 13 60 35s485ms 591ms 14 60 37s774ms 629ms 15 60 1m21s 1s364ms 16 60 1m16s 1s275ms 17 60 1m21s 1s355ms 18 60 1m6s 1s104ms 19 60 49s253ms 820ms 20 60 50s319ms 838ms 21 60 50s134ms 835ms 22 60 48s735ms 812ms 23 60 48s735ms 812ms 00 60 48s188ms 803ms [ User: labanimal - Total duration: 23m15s - 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-03-31 11:48:01 Duration: 3s587ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_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-03-31 11:32:01 Duration: 3s552ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_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-03-31 11:47:01 Duration: 3s550ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
2 23m15s 1,440 509ms 3s587ms 969ms create table if not exists observability.db_top_queries ( id bigserial primary key, tenant_key text not null, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz not null default now() );Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 31 01 60 0ms 0ms 02 60 32s747ms 545ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 1m7s 1s129ms 09 60 1m 1s9ms 10 60 1m 1s10ms 11 60 38s794ms 646ms 12 60 2m1s 2s28ms 13 60 35s485ms 591ms 14 60 37s774ms 629ms 15 60 1m21s 1s364ms 16 60 1m16s 1s275ms 17 60 1m21s 1s355ms 18 60 1m6s 1s104ms 19 60 49s253ms 820ms 20 60 50s319ms 838ms 21 60 50s134ms 835ms 22 60 48s735ms 812ms 23 60 48s735ms 812ms 00 60 48s188ms 803ms [ User: labanimal - Total duration: 23m15s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-31 11:48:01 Duration: 3s587ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-31 11:32:01 Duration: 3s552ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-31 11:47:01 Duration: 3s550ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
3 23m15s 1,440 509ms 3s587ms 969ms create index if not exists idx_app_events_type on observability.app_events (event_type);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 31 01 60 0ms 0ms 02 60 32s747ms 545ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 1m7s 1s129ms 09 60 1m 1s9ms 10 60 1m 1s10ms 11 60 38s794ms 646ms 12 60 2m1s 2s28ms 13 60 35s485ms 591ms 14 60 37s774ms 629ms 15 60 1m21s 1s364ms 16 60 1m16s 1s275ms 17 60 1m21s 1s355ms 18 60 1m6s 1s104ms 19 60 49s253ms 820ms 20 60 50s319ms 838ms 21 60 50s134ms 835ms 22 60 48s735ms 812ms 23 60 48s735ms 812ms 00 60 48s188ms 803ms [ User: labanimal - Total duration: 23m15s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-31 11:48:01 Duration: 3s587ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-31 11:32:01 Duration: 3s552ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-31 11:47:01 Duration: 3s550ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
4 23m15s 1,440 509ms 3s587ms 969ms 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 Mar 31 01 60 0ms 0ms 02 60 32s747ms 545ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 1m7s 1s129ms 09 60 1m 1s9ms 10 60 1m 1s10ms 11 60 38s794ms 646ms 12 60 2m1s 2s28ms 13 60 35s485ms 591ms 14 60 37s774ms 629ms 15 60 1m21s 1s364ms 16 60 1m16s 1s275ms 17 60 1m21s 1s355ms 18 60 1m6s 1s104ms 19 60 49s253ms 820ms 20 60 50s319ms 838ms 21 60 50s134ms 835ms 22 60 48s735ms 812ms 23 60 48s735ms 812ms 00 60 48s188ms 803ms [ User: labanimal - Total duration: 23m15s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-31 11:48:01 Duration: 3s587ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-31 11:32:01 Duration: 3s552ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-31 11:47:01 Duration: 3s550ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
5 23m15s 1,440 509ms 3s587ms 969ms create schema if not exists observability;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Mar 31 01 60 0ms 0ms 02 60 32s747ms 545ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 1m7s 1s129ms 09 60 1m 1s9ms 10 60 1m 1s10ms 11 60 38s794ms 646ms 12 60 2m1s 2s28ms 13 60 35s485ms 591ms 14 60 37s774ms 629ms 15 60 1m21s 1s364ms 16 60 1m16s 1s275ms 17 60 1m21s 1s355ms 18 60 1m6s 1s104ms 19 60 49s253ms 820ms 20 60 50s319ms 838ms 21 60 50s134ms 835ms 22 60 48s735ms 812ms 23 60 48s735ms 812ms 00 60 48s188ms 803ms [ User: labanimal - Total duration: 23m15s - Times executed: 1349 ]
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-31 11:48:01 Duration: 3s587ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-31 11:32:01 Duration: 3s552ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-31 11:47:01 Duration: 3s550ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
6 23m15s 1,440 509ms 3s587ms 969ms create index if not exists idx_app_events_tenant on observability.app_events (tenant_key, occurred_at desc);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Mar 31 01 60 0ms 0ms 02 60 32s747ms 545ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 1m7s 1s129ms 09 60 1m 1s9ms 10 60 1m 1s10ms 11 60 38s794ms 646ms 12 60 2m1s 2s28ms 13 60 35s485ms 591ms 14 60 37s774ms 629ms 15 60 1m21s 1s364ms 16 60 1m16s 1s275ms 17 60 1m21s 1s355ms 18 60 1m6s 1s104ms 19 60 49s253ms 820ms 20 60 50s319ms 838ms 21 60 50s134ms 835ms 22 60 48s735ms 812ms 23 60 48s735ms 812ms 00 60 48s188ms 803ms [ User: labanimal - Total duration: 23m15s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-31 11:48:01 Duration: 3s587ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-31 11:32:01 Duration: 3s552ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-31 11:47:01 Duration: 3s550ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
7 23m15s 1,440 509ms 3s587ms 969ms create index if not exists idx_metrics_timeseries_metric on observability.metrics_timeseries (metric_name);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Mar 31 01 60 0ms 0ms 02 60 32s747ms 545ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 1m7s 1s129ms 09 60 1m 1s9ms 10 60 1m 1s10ms 11 60 38s794ms 646ms 12 60 2m1s 2s28ms 13 60 35s485ms 591ms 14 60 37s774ms 629ms 15 60 1m21s 1s364ms 16 60 1m16s 1s275ms 17 60 1m21s 1s355ms 18 60 1m6s 1s104ms 19 60 49s253ms 820ms 20 60 50s319ms 838ms 21 60 50s134ms 835ms 22 60 48s735ms 812ms 23 60 48s735ms 812ms 00 60 48s188ms 803ms [ User: labanimal - Total duration: 23m15s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-31 11:48:01 Duration: 3s587ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-31 11:32:01 Duration: 3s552ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-31 11:47:01 Duration: 3s550ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
8 23m15s 1,440 509ms 3s587ms 969ms 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 #8
Day Hour Count Duration Avg duration Mar 31 01 60 0ms 0ms 02 60 32s747ms 545ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 1m7s 1s129ms 09 60 1m 1s9ms 10 60 1m 1s10ms 11 60 38s794ms 646ms 12 60 2m1s 2s28ms 13 60 35s485ms 591ms 14 60 37s774ms 629ms 15 60 1m21s 1s364ms 16 60 1m16s 1s275ms 17 60 1m21s 1s355ms 18 60 1m6s 1s104ms 19 60 49s253ms 820ms 20 60 50s319ms 838ms 21 60 50s134ms 835ms 22 60 48s735ms 812ms 23 60 48s735ms 812ms 00 60 48s188ms 803ms [ User: labanimal - Total duration: 23m15s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-03-31 11:48:01 Duration: 3s587ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-03-31 11:32:01 Duration: 3s552ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-03-31 11:47:01 Duration: 3s550ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
9 23m15s 1,440 509ms 3s587ms 969ms 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 #9
Day Hour Count Duration Avg duration Mar 31 01 60 0ms 0ms 02 60 32s747ms 545ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 1m7s 1s129ms 09 60 1m 1s9ms 10 60 1m 1s10ms 11 60 38s794ms 646ms 12 60 2m1s 2s28ms 13 60 35s485ms 591ms 14 60 37s774ms 629ms 15 60 1m21s 1s364ms 16 60 1m16s 1s275ms 17 60 1m21s 1s355ms 18 60 1m6s 1s104ms 19 60 49s253ms 820ms 20 60 50s319ms 838ms 21 60 50s134ms 835ms 22 60 48s735ms 812ms 23 60 48s735ms 812ms 00 60 48s188ms 803ms [ User: labanimal - Total duration: 23m15s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-31 11:48:01 Duration: 3s587ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-31 11:32:01 Duration: 3s552ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-31 11:47:01 Duration: 3s550ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
10 23m15s 1,440 509ms 3s587ms 969ms 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 #10
Day Hour Count Duration Avg duration Mar 31 01 60 0ms 0ms 02 60 32s747ms 545ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 1m7s 1s129ms 09 60 1m 1s9ms 10 60 1m 1s10ms 11 60 38s794ms 646ms 12 60 2m1s 2s28ms 13 60 35s485ms 591ms 14 60 37s774ms 629ms 15 60 1m21s 1s364ms 16 60 1m16s 1s275ms 17 60 1m21s 1s355ms 18 60 1m6s 1s104ms 19 60 49s253ms 820ms 20 60 50s319ms 838ms 21 60 50s134ms 835ms 22 60 48s735ms 812ms 23 60 48s735ms 812ms 00 60 48s188ms 803ms [ User: labanimal - Total duration: 23m15s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-31 11:48:01 Duration: 3s587ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-31 11:32:01 Duration: 3s552ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-31 11:47:01 Duration: 3s550ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
11 23m15s 1,440 509ms 3s587ms 969ms 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 Mar 31 01 60 0ms 0ms 02 60 32s747ms 545ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 1m7s 1s129ms 09 60 1m 1s9ms 10 60 1m 1s10ms 11 60 38s794ms 646ms 12 60 2m1s 2s28ms 13 60 35s485ms 591ms 14 60 37s774ms 629ms 15 60 1m21s 1s364ms 16 60 1m16s 1s275ms 17 60 1m21s 1s355ms 18 60 1m6s 1s104ms 19 60 49s253ms 820ms 20 60 50s319ms 838ms 21 60 50s134ms 835ms 22 60 48s735ms 812ms 23 60 48s735ms 812ms 00 60 48s188ms 803ms [ User: labanimal - Total duration: 23m15s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-31 11:48:01 Duration: 3s587ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-31 11:32:01 Duration: 3s552ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-31 11:47:01 Duration: 3s550ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
12 23m15s 1,440 509ms 3s587ms 969ms 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 #12
Day Hour Count Duration Avg duration Mar 31 01 60 0ms 0ms 02 60 32s747ms 545ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 1m7s 1s129ms 09 60 1m 1s9ms 10 60 1m 1s10ms 11 60 38s794ms 646ms 12 60 2m1s 2s28ms 13 60 35s485ms 591ms 14 60 37s774ms 629ms 15 60 1m21s 1s364ms 16 60 1m16s 1s275ms 17 60 1m21s 1s355ms 18 60 1m6s 1s104ms 19 60 49s253ms 820ms 20 60 50s319ms 838ms 21 60 50s134ms 835ms 22 60 48s735ms 812ms 23 60 48s735ms 812ms 00 60 48s188ms 803ms [ User: labanimal - Total duration: 23m15s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-03-31 11:48:01 Duration: 3s587ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-03-31 11:32:01 Duration: 3s552ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-03-31 11:47:01 Duration: 3s550ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
13 23m15s 1,440 509ms 3s587ms 969ms 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 #13
Day Hour Count Duration Avg duration Mar 31 01 60 0ms 0ms 02 60 32s747ms 545ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 1m7s 1s129ms 09 60 1m 1s9ms 10 60 1m 1s10ms 11 60 38s794ms 646ms 12 60 2m1s 2s28ms 13 60 35s485ms 591ms 14 60 37s774ms 629ms 15 60 1m21s 1s364ms 16 60 1m16s 1s275ms 17 60 1m21s 1s355ms 18 60 1m6s 1s104ms 19 60 49s253ms 820ms 20 60 50s319ms 838ms 21 60 50s134ms 835ms 22 60 48s735ms 812ms 23 60 48s735ms 812ms 00 60 48s188ms 803ms [ User: labanimal - Total duration: 23m15s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-31 11:48:01 Duration: 3s587ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-31 11:32:01 Duration: 3s552ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-31 11:47:01 Duration: 3s550ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
14 35s674ms 10 3s468ms 3s737ms 3s567ms select * from litters_search_mview l where not (deleted) and case when user_is_tgm (l.owner, ?) then true when user_is_tgm (l.editor, ?) then true when user_is_tgm (l.tourist, ?) then true else false end and (offspring - case when male_wean is null then ? else male_wean end - case when female_wean is null then ? else female_wean end - case when male_dead is null then ? else male_dead end - case when female_dead is null then ? else female_dead end - case when female_deceased is null then ? else female_deceased end - case when male_deceased is null then ? else male_deceased end) <= ? order by bday desc, dam_name, sire_name;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Mar 31 12 10 35s674ms 3s567ms [ User: labanimal - Total duration: 35s674ms - Times executed: 10 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 35s674ms - Times executed: 10 ]
-
SELECT * FROM litters_search_mview l WHERE NOT (deleted) AND CASE WHEN user_is_tgm (l.owner, 438) THEN TRUE WHEN user_is_tgm (l.editor, 438) THEN TRUE WHEN user_is_tgm (l.tourist, 438) THEN TRUE ELSE FALSE END AND (offspring - CASE WHEN male_wean IS NULL THEN 0 ELSE male_wean END - CASE WHEN female_wean IS NULL THEN 0 ELSE female_wean END - CASE WHEN male_dead IS NULL THEN 0 ELSE male_dead END - CASE WHEN female_dead IS NULL THEN 0 ELSE female_dead END - CASE WHEN female_deceased IS NULL THEN 0 ELSE female_deceased END - CASE WHEN male_deceased IS NULL THEN 0 ELSE male_deceased END) <= 0 ORDER BY bday DESC, dam_name, sire_name;
Date: 2026-03-31 11:30:19 Duration: 3s737ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
SELECT * FROM litters_search_mview l WHERE NOT (deleted) AND CASE WHEN user_is_tgm (l.owner, 438) THEN TRUE WHEN user_is_tgm (l.editor, 438) THEN TRUE WHEN user_is_tgm (l.tourist, 438) THEN TRUE ELSE FALSE END AND (offspring - CASE WHEN male_wean IS NULL THEN 0 ELSE male_wean END - CASE WHEN female_wean IS NULL THEN 0 ELSE female_wean END - CASE WHEN male_dead IS NULL THEN 0 ELSE male_dead END - CASE WHEN female_dead IS NULL THEN 0 ELSE female_dead END - CASE WHEN female_deceased IS NULL THEN 0 ELSE female_deceased END - CASE WHEN male_deceased IS NULL THEN 0 ELSE male_deceased END) <= 0 ORDER BY bday DESC, dam_name, sire_name;
Date: 2026-03-31 11:30:23 Duration: 3s693ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
SELECT * FROM litters_search_mview l WHERE NOT (deleted) AND CASE WHEN user_is_tgm (l.owner, 438) THEN TRUE WHEN user_is_tgm (l.editor, 438) THEN TRUE WHEN user_is_tgm (l.tourist, 438) THEN TRUE ELSE FALSE END AND (offspring - CASE WHEN male_wean IS NULL THEN 0 ELSE male_wean END - CASE WHEN female_wean IS NULL THEN 0 ELSE female_wean END - CASE WHEN male_dead IS NULL THEN 0 ELSE male_dead END - CASE WHEN female_dead IS NULL THEN 0 ELSE female_dead END - CASE WHEN female_deceased IS NULL THEN 0 ELSE female_deceased END - CASE WHEN male_deceased IS NULL THEN 0 ELSE male_deceased END) <= 0 ORDER BY bday DESC, dam_name, sire_name;
Date: 2026-03-31 11:48:53 Duration: 3s570ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
15 28s261ms 5 1s481ms 6s735ms 5s652ms copy public."targetgroupMembers" (id, targetgroup, "user", "group") to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Mar 31 12 4 26s779ms 6s694ms 00 1 1s481ms 1s481ms [ User: labanimal - Total duration: 26s779ms - Times executed: 4 ]
[ User: postgres - Total duration: 1s481ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 28s261ms - Times executed: 5 ]
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-03-31 11:48:55 Duration: 6s735ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-03-31 11:52:05 Duration: 6s706ms Database: zemm_produktiv_7 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-03-31 11:49:22 Duration: 6s669ms Database: zemm_produktiv_7 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
16 20s889ms 5 1s315ms 4s924ms 4s177ms copy public.animals_search_mview (id, name, animal_id, deleted, alive, birth_date, arrival_date, death_date, outgoing_date, cage, comments, sterile, breeding, fate, last_mating, last_mating_date, breeding_cage, sex, strain, line, gene_1_info, gene_1_type, gene_2_info, gene_2_type, gene_3_info, gene_3_type, gene_4_info, gene_4_type, gene_5_info, gene_5_type, backcross, generation, project, project_name, species, species_name, cage_name, location, location_name, dam, dam_name, dam_id, sire, sire_name, sire_id, cohort, litter, rfid, owner, editor, tourist, breeding_status, workgroup_infos, experiment, experiment_name) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Mar 31 12 4 19s573ms 4s893ms 00 1 1s315ms 1s315ms [ User: labanimal - Total duration: 19s573ms - Times executed: 4 ]
[ User: postgres - Total duration: 1s315ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 20s889ms - Times executed: 5 ]
-
COPY public.animals_search_mview (id, name, animal_id, deleted, alive, birth_date, arrival_date, death_date, outgoing_date, cage, comments, sterile, breeding, fate, last_mating, last_mating_date, breeding_cage, sex, strain, line, gene_1_info, gene_1_type, gene_2_info, gene_2_type, gene_3_info, gene_3_type, gene_4_info, gene_4_type, gene_5_info, gene_5_type, backcross, generation, project, project_name, species, species_name, cage_name, location, location_name, dam, dam_name, dam_id, sire, sire_name, sire_id, cohort, litter, rfid, owner, editor, tourist, breeding_status, workgroup_infos, experiment, experiment_name) TO stdout;
Date: 2026-03-31 11:48:41 Duration: 4s924ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
COPY public.animals_search_mview (id, name, animal_id, deleted, alive, birth_date, arrival_date, death_date, outgoing_date, cage, comments, sterile, breeding, fate, last_mating, last_mating_date, breeding_cage, sex, strain, line, gene_1_info, gene_1_type, gene_2_info, gene_2_type, gene_3_info, gene_3_type, gene_4_info, gene_4_type, gene_5_info, gene_5_type, backcross, generation, project, project_name, species, species_name, cage_name, location, location_name, dam, dam_name, dam_id, sire, sire_name, sire_id, cohort, litter, rfid, owner, editor, tourist, breeding_status, workgroup_infos, experiment, experiment_name) TO stdout;
Date: 2026-03-31 11:51:25 Duration: 4s902ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
COPY public.animals_search_mview (id, name, animal_id, deleted, alive, birth_date, arrival_date, death_date, outgoing_date, cage, comments, sterile, breeding, fate, last_mating, last_mating_date, breeding_cage, sex, strain, line, gene_1_info, gene_1_type, gene_2_info, gene_2_type, gene_3_info, gene_3_type, gene_4_info, gene_4_type, gene_5_info, gene_5_type, backcross, generation, project, project_name, species, species_name, cage_name, location, location_name, dam, dam_name, dam_id, sire, sire_name, sire_id, cohort, litter, rfid, owner, editor, tourist, breeding_status, workgroup_infos, experiment, experiment_name) TO stdout;
Date: 2026-03-31 11:51:51 Duration: 4s884ms Database: zemm_produktiv_7 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
17 15s425ms 5 1s976ms 3s420ms 3s85ms copy public.diary (id, "animalID", date, "entrybyID", "cageID", weight, temperature, "fDeprivation", "wDeprivation", "sDeprivation", "feedingClass", health, comments, "breedingInfo", deleted, "inOutDate", "inOutFlag", text, sdesc, treatment, tailcut_id, tailcut_result, file_name, file_content, file_type, upload_name, old_gene_type, old_gene_info, old_gene2_type, old_gene2_info, old_gene3_info, old_gene3_type, old_gene4_info, old_gene4_type, old_gene5_info, old_gene5_type) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Mar 31 12 4 13s449ms 3s362ms 00 1 1s976ms 1s976ms [ User: labanimal - Total duration: 13s449ms - Times executed: 4 ]
[ User: postgres - Total duration: 1s976ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 15s425ms - Times executed: 5 ]
-
COPY public.diary (id, "animalID", date, "entrybyID", "cageID", weight, temperature, "fDeprivation", "wDeprivation", "sDeprivation", "feedingClass", health, comments, "breedingInfo", deleted, "inOutDate", "inOutFlag", text, sdesc, treatment, tailcut_id, tailcut_result, file_name, file_content, file_type, upload_name, old_gene_type, old_gene_info, old_gene2_type, old_gene2_info, old_gene3_info, old_gene3_type, old_gene4_info, old_gene4_type, old_gene5_info, old_gene5_type) TO stdout;
Date: 2026-03-31 11:48:46 Duration: 3s420ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
COPY public.diary (id, "animalID", date, "entrybyID", "cageID", weight, temperature, "fDeprivation", "wDeprivation", "sDeprivation", "feedingClass", health, comments, "breedingInfo", deleted, "inOutDate", "inOutFlag", text, sdesc, treatment, tailcut_id, tailcut_result, file_name, file_content, file_type, upload_name, old_gene_type, old_gene_info, old_gene2_type, old_gene2_info, old_gene3_info, old_gene3_type, old_gene4_info, old_gene4_type, old_gene5_info, old_gene5_type) TO stdout;
Date: 2026-03-31 11:49:13 Duration: 3s369ms Database: zemm_produktiv_7 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
COPY public.diary (id, "animalID", date, "entrybyID", "cageID", weight, temperature, "fDeprivation", "wDeprivation", "sDeprivation", "feedingClass", health, comments, "breedingInfo", deleted, "inOutDate", "inOutFlag", text, sdesc, treatment, tailcut_id, tailcut_result, file_name, file_content, file_type, upload_name, old_gene_type, old_gene_info, old_gene2_type, old_gene2_info, old_gene3_info, old_gene3_type, old_gene4_info, old_gene4_type, old_gene5_info, old_gene5_type) TO stdout;
Date: 2026-03-31 11:51:29 Duration: 3s331ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
18 14s360ms 4 3s550ms 3s663ms 3s590ms select * from litters_search_mview l where not (deleted) and case when user_is_tgm (l.owner, ?) then true when user_is_tgm (l.editor, ?) then true when user_is_tgm (l.tourist, ?) then true else false end order by bday desc, dam_name, sire_name;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Mar 31 12 4 14s360ms 3s590ms [ User: labanimal - Total duration: 14s360ms - Times executed: 4 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 14s360ms - Times executed: 4 ]
-
SELECT * FROM litters_search_mview l WHERE NOT (deleted) AND CASE WHEN user_is_tgm (l.owner, 438) THEN TRUE WHEN user_is_tgm (l.editor, 438) THEN TRUE WHEN user_is_tgm (l.tourist, 438) THEN TRUE ELSE FALSE END ORDER BY bday DESC, dam_name, sire_name;
Date: 2026-03-31 11:47:24 Duration: 3s663ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
SELECT * FROM litters_search_mview l WHERE NOT (deleted) AND CASE WHEN user_is_tgm (l.owner, 438) THEN TRUE WHEN user_is_tgm (l.editor, 438) THEN TRUE WHEN user_is_tgm (l.tourist, 438) THEN TRUE ELSE FALSE END ORDER BY bday DESC, dam_name, sire_name;
Date: 2026-03-31 11:47:28 Duration: 3s587ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
SELECT * FROM litters_search_mview l WHERE NOT (deleted) AND CASE WHEN user_is_tgm (l.owner, 438) THEN TRUE WHEN user_is_tgm (l.editor, 438) THEN TRUE WHEN user_is_tgm (l.tourist, 438) THEN TRUE ELSE FALSE END ORDER BY bday DESC, dam_name, sire_name;
Date: 2026-03-31 11:46:22 Duration: 3s558ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
19 13s432ms 5 1s221ms 3s58ms 2s686ms copy public.animals (id, species, transgen, "homeCage", tourist, editor, owner, comments, pregnant, name, sex, "standardDescription", "parentFemale", "parentMale", "parentFoster", colour, "plannedUseFor", deleted, generation, chimare, "birthDate", "arrivalDate", "outgoingDate", "deathDate", breedstatus_2, "healthState", breeder, restrictions, "geneStatus", "geneFlanking", "geneDeleted", "fromOrder_2", "group", "fromOrder", strain, "breedStatus", "FEMnumber", genotype, inbreeding, identification, jax, "KOgene", "feedingClass", dummy_gen_info, breeding, sterile, project, dummy_line_info, dummy_strain_info, "bredWith", "curCage", dummy_backcross_info, fate, "fateComment", alive, reciever, "animalID", litter, weight_at_arrival, cohort, gen_2_info, gen_3_info, gen_4_info, gen_5_info, gen_1_typ, gen_2_typ, gen_3_typ, gen_4_typ, gen_5_typ, "latestMatingDate", "latestMating", genecomment, recycle) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 31 12 4 12s211ms 3s52ms 00 1 1s221ms 1s221ms [ User: labanimal - Total duration: 12s211ms - Times executed: 4 ]
[ User: postgres - Total duration: 1s221ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 13s432ms - Times executed: 5 ]
-
COPY public.animals (id, species, transgen, "homeCage", tourist, editor, owner, comments, pregnant, name, sex, "standardDescription", "parentFemale", "parentMale", "parentFoster", colour, "plannedUseFor", deleted, generation, chimare, "birthDate", "arrivalDate", "outgoingDate", "deathDate", breedstatus_2, "healthState", breeder, restrictions, "geneStatus", "geneFlanking", "geneDeleted", "fromOrder_2", "group", "fromOrder", strain, "breedStatus", "FEMnumber", genotype, inbreeding, identification, jax, "KOgene", "feedingClass", dummy_gen_info, breeding, sterile, project, dummy_line_info, dummy_strain_info, "bredWith", "curCage", dummy_backcross_info, fate, "fateComment", alive, reciever, "animalID", litter, weight_at_arrival, cohort, gen_2_info, gen_3_info, gen_4_info, gen_5_info, gen_1_typ, gen_2_typ, gen_3_typ, gen_4_typ, gen_5_typ, "latestMatingDate", "latestMating", genecomment, recycle) TO stdout;
Date: 2026-03-31 11:49:03 Duration: 3s58ms Database: zemm_produktiv_7 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
COPY public.animals (id, species, transgen, "homeCage", tourist, editor, owner, comments, pregnant, name, sex, "standardDescription", "parentFemale", "parentMale", "parentFoster", colour, "plannedUseFor", deleted, generation, chimare, "birthDate", "arrivalDate", "outgoingDate", "deathDate", breedstatus_2, "healthState", breeder, restrictions, "geneStatus", "geneFlanking", "geneDeleted", "fromOrder_2", "group", "fromOrder", strain, "breedStatus", "FEMnumber", genotype, inbreeding, identification, jax, "KOgene", "feedingClass", dummy_gen_info, breeding, sterile, project, dummy_line_info, dummy_strain_info, "bredWith", "curCage", dummy_backcross_info, fate, "fateComment", alive, reciever, "animalID", litter, weight_at_arrival, cohort, gen_2_info, gen_3_info, gen_4_info, gen_5_info, gen_1_typ, gen_2_typ, gen_3_typ, gen_4_typ, gen_5_typ, "latestMatingDate", "latestMating", genecomment, recycle) TO stdout;
Date: 2026-03-31 11:48:36 Duration: 3s55ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
COPY public.animals (id, species, transgen, "homeCage", tourist, editor, owner, comments, pregnant, name, sex, "standardDescription", "parentFemale", "parentMale", "parentFoster", colour, "plannedUseFor", deleted, generation, chimare, "birthDate", "arrivalDate", "outgoingDate", "deathDate", breedstatus_2, "healthState", breeder, restrictions, "geneStatus", "geneFlanking", "geneDeleted", "fromOrder_2", "group", "fromOrder", strain, "breedStatus", "FEMnumber", genotype, inbreeding, identification, jax, "KOgene", "feedingClass", dummy_gen_info, breeding, sterile, project, dummy_line_info, dummy_strain_info, "bredWith", "curCage", dummy_backcross_info, fate, "fateComment", alive, reciever, "animalID", litter, weight_at_arrival, cohort, gen_2_info, gen_3_info, gen_4_info, gen_5_info, gen_1_typ, gen_2_typ, gen_3_typ, gen_4_typ, gen_5_typ, "latestMatingDate", "latestMating", genecomment, recycle) TO stdout;
Date: 2026-03-31 11:51:20 Duration: 3s49ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
20 9s245ms 13 699ms 727ms 711ms select count(distinct animal_id) AS "count" from ( select animals_search_mview.*, b.unbreeding_date, a.id as animal, user_is_tgm (animals_search_mview.owner, ?) as is_owner, user_is_tgm (animals_search_mview.editor, ?) as is_editor, user_is_tgm (animals_search_mview.tourist, ?) as is_tourist, case when not exists ( select ? from scoresheet_diary sd where sd.animals_id = animals_search_mview.id) then ? else ? end as isscored from animals_search_mview left join strains on strains.name = animals_search_mview.strain left join license_history lh on lh.anid = animals_search_mview.id left join animals a on a."animalID" = animals_search_mview.animal_id left join breedings b on b.id = animals_search_mview.last_mating) data where fate = ? and alive = ? and deleted = ? and (is_owner or is_editor or is_tourist);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 31 10 2 1s427ms 713ms 11 2 1s427ms 713ms 12 2 1s420ms 710ms 13 2 1s406ms 703ms 15 2 1s426ms 713ms 16 2 1s407ms 703ms 00 1 727ms 727ms [ User: labanimal - Total duration: 9s245ms - Times executed: 13 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 8s517ms - Times executed: 12 ]
[ Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 - Total duration: 727ms - Times executed: 1 ]
-
SELECT COUNT(DISTINCT animal_id) AS "count" FROM ( SELECT animals_search_mview.*, b.unbreeding_date, a.id as animal, user_is_tgm (animals_search_mview.owner, 1) AS is_owner, user_is_tgm (animals_search_mview.editor, 1) AS is_editor, user_is_tgm (animals_search_mview.tourist, 1) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN animals a ON a."animalID" = animals_search_mview.animal_id LEFT JOIN breedings b ON b.id = animals_search_mview.last_mating) data WHERE fate = 5 AND alive = 't' AND deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-03-31 23:22:31 Duration: 727ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-31_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, 10100187) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100187) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100187) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN animals a ON a."animalID" = animals_search_mview.animal_id LEFT JOIN breedings b ON b.id = animals_search_mview.last_mating) data WHERE fate = 5 AND alive = 't' AND deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-03-31 14:21:45 Duration: 727ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-31_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, 10100176) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100176) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100176) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN animals a ON a."animalID" = animals_search_mview.animal_id LEFT JOIN breedings b ON b.id = animals_search_mview.last_mating) data WHERE fate = 5 AND alive = 't' AND deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-03-31 10:53:20 Duration: 724ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,440 23m15s 509ms 3s587ms 969ms 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 #1
Day Hour Count Duration Avg duration Mar 31 01 60 0ms 0ms 02 60 32s747ms 545ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 1m7s 1s129ms 09 60 1m 1s9ms 10 60 1m 1s10ms 11 60 38s794ms 646ms 12 60 2m1s 2s28ms 13 60 35s485ms 591ms 14 60 37s774ms 629ms 15 60 1m21s 1s364ms 16 60 1m16s 1s275ms 17 60 1m21s 1s355ms 18 60 1m6s 1s104ms 19 60 49s253ms 820ms 20 60 50s319ms 838ms 21 60 50s134ms 835ms 22 60 48s735ms 812ms 23 60 48s735ms 812ms 00 60 48s188ms 803ms [ User: labanimal - Total duration: 23m15s - 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-03-31 11:48:01 Duration: 3s587ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_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-03-31 11:32:01 Duration: 3s552ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_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-03-31 11:47:01 Duration: 3s550ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
2 1,440 23m15s 509ms 3s587ms 969ms create table if not exists observability.db_top_queries ( id bigserial primary key, tenant_key text not null, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz not null default now() );Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 31 01 60 0ms 0ms 02 60 32s747ms 545ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 1m7s 1s129ms 09 60 1m 1s9ms 10 60 1m 1s10ms 11 60 38s794ms 646ms 12 60 2m1s 2s28ms 13 60 35s485ms 591ms 14 60 37s774ms 629ms 15 60 1m21s 1s364ms 16 60 1m16s 1s275ms 17 60 1m21s 1s355ms 18 60 1m6s 1s104ms 19 60 49s253ms 820ms 20 60 50s319ms 838ms 21 60 50s134ms 835ms 22 60 48s735ms 812ms 23 60 48s735ms 812ms 00 60 48s188ms 803ms [ User: labanimal - Total duration: 23m15s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-31 11:48:01 Duration: 3s587ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-31 11:32:01 Duration: 3s552ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-31 11:47:01 Duration: 3s550ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
3 1,440 23m15s 509ms 3s587ms 969ms create index if not exists idx_app_events_type on observability.app_events (event_type);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 31 01 60 0ms 0ms 02 60 32s747ms 545ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 1m7s 1s129ms 09 60 1m 1s9ms 10 60 1m 1s10ms 11 60 38s794ms 646ms 12 60 2m1s 2s28ms 13 60 35s485ms 591ms 14 60 37s774ms 629ms 15 60 1m21s 1s364ms 16 60 1m16s 1s275ms 17 60 1m21s 1s355ms 18 60 1m6s 1s104ms 19 60 49s253ms 820ms 20 60 50s319ms 838ms 21 60 50s134ms 835ms 22 60 48s735ms 812ms 23 60 48s735ms 812ms 00 60 48s188ms 803ms [ User: labanimal - Total duration: 23m15s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-31 11:48:01 Duration: 3s587ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-31 11:32:01 Duration: 3s552ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-31 11:47:01 Duration: 3s550ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
4 1,440 23m15s 509ms 3s587ms 969ms 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 Mar 31 01 60 0ms 0ms 02 60 32s747ms 545ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 1m7s 1s129ms 09 60 1m 1s9ms 10 60 1m 1s10ms 11 60 38s794ms 646ms 12 60 2m1s 2s28ms 13 60 35s485ms 591ms 14 60 37s774ms 629ms 15 60 1m21s 1s364ms 16 60 1m16s 1s275ms 17 60 1m21s 1s355ms 18 60 1m6s 1s104ms 19 60 49s253ms 820ms 20 60 50s319ms 838ms 21 60 50s134ms 835ms 22 60 48s735ms 812ms 23 60 48s735ms 812ms 00 60 48s188ms 803ms [ User: labanimal - Total duration: 23m15s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-31 11:48:01 Duration: 3s587ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-31 11:32:01 Duration: 3s552ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-31 11:47:01 Duration: 3s550ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
5 1,440 23m15s 509ms 3s587ms 969ms create schema if not exists observability;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Mar 31 01 60 0ms 0ms 02 60 32s747ms 545ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 1m7s 1s129ms 09 60 1m 1s9ms 10 60 1m 1s10ms 11 60 38s794ms 646ms 12 60 2m1s 2s28ms 13 60 35s485ms 591ms 14 60 37s774ms 629ms 15 60 1m21s 1s364ms 16 60 1m16s 1s275ms 17 60 1m21s 1s355ms 18 60 1m6s 1s104ms 19 60 49s253ms 820ms 20 60 50s319ms 838ms 21 60 50s134ms 835ms 22 60 48s735ms 812ms 23 60 48s735ms 812ms 00 60 48s188ms 803ms [ User: labanimal - Total duration: 23m15s - Times executed: 1349 ]
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-31 11:48:01 Duration: 3s587ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-31 11:32:01 Duration: 3s552ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-31 11:47:01 Duration: 3s550ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
6 1,440 23m15s 509ms 3s587ms 969ms create index if not exists idx_app_events_tenant on observability.app_events (tenant_key, occurred_at desc);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Mar 31 01 60 0ms 0ms 02 60 32s747ms 545ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 1m7s 1s129ms 09 60 1m 1s9ms 10 60 1m 1s10ms 11 60 38s794ms 646ms 12 60 2m1s 2s28ms 13 60 35s485ms 591ms 14 60 37s774ms 629ms 15 60 1m21s 1s364ms 16 60 1m16s 1s275ms 17 60 1m21s 1s355ms 18 60 1m6s 1s104ms 19 60 49s253ms 820ms 20 60 50s319ms 838ms 21 60 50s134ms 835ms 22 60 48s735ms 812ms 23 60 48s735ms 812ms 00 60 48s188ms 803ms [ User: labanimal - Total duration: 23m15s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-31 11:48:01 Duration: 3s587ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-31 11:32:01 Duration: 3s552ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-31 11:47:01 Duration: 3s550ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
7 1,440 23m15s 509ms 3s587ms 969ms create index if not exists idx_metrics_timeseries_metric on observability.metrics_timeseries (metric_name);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Mar 31 01 60 0ms 0ms 02 60 32s747ms 545ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 1m7s 1s129ms 09 60 1m 1s9ms 10 60 1m 1s10ms 11 60 38s794ms 646ms 12 60 2m1s 2s28ms 13 60 35s485ms 591ms 14 60 37s774ms 629ms 15 60 1m21s 1s364ms 16 60 1m16s 1s275ms 17 60 1m21s 1s355ms 18 60 1m6s 1s104ms 19 60 49s253ms 820ms 20 60 50s319ms 838ms 21 60 50s134ms 835ms 22 60 48s735ms 812ms 23 60 48s735ms 812ms 00 60 48s188ms 803ms [ User: labanimal - Total duration: 23m15s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-31 11:48:01 Duration: 3s587ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-31 11:32:01 Duration: 3s552ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-31 11:47:01 Duration: 3s550ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
8 1,440 23m15s 509ms 3s587ms 969ms 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 #8
Day Hour Count Duration Avg duration Mar 31 01 60 0ms 0ms 02 60 32s747ms 545ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 1m7s 1s129ms 09 60 1m 1s9ms 10 60 1m 1s10ms 11 60 38s794ms 646ms 12 60 2m1s 2s28ms 13 60 35s485ms 591ms 14 60 37s774ms 629ms 15 60 1m21s 1s364ms 16 60 1m16s 1s275ms 17 60 1m21s 1s355ms 18 60 1m6s 1s104ms 19 60 49s253ms 820ms 20 60 50s319ms 838ms 21 60 50s134ms 835ms 22 60 48s735ms 812ms 23 60 48s735ms 812ms 00 60 48s188ms 803ms [ User: labanimal - Total duration: 23m15s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-03-31 11:48:01 Duration: 3s587ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-03-31 11:32:01 Duration: 3s552ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-03-31 11:47:01 Duration: 3s550ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
9 1,440 23m15s 509ms 3s587ms 969ms 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 #9
Day Hour Count Duration Avg duration Mar 31 01 60 0ms 0ms 02 60 32s747ms 545ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 1m7s 1s129ms 09 60 1m 1s9ms 10 60 1m 1s10ms 11 60 38s794ms 646ms 12 60 2m1s 2s28ms 13 60 35s485ms 591ms 14 60 37s774ms 629ms 15 60 1m21s 1s364ms 16 60 1m16s 1s275ms 17 60 1m21s 1s355ms 18 60 1m6s 1s104ms 19 60 49s253ms 820ms 20 60 50s319ms 838ms 21 60 50s134ms 835ms 22 60 48s735ms 812ms 23 60 48s735ms 812ms 00 60 48s188ms 803ms [ User: labanimal - Total duration: 23m15s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-31 11:48:01 Duration: 3s587ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-31 11:32:01 Duration: 3s552ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-31 11:47:01 Duration: 3s550ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
10 1,440 23m15s 509ms 3s587ms 969ms 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 #10
Day Hour Count Duration Avg duration Mar 31 01 60 0ms 0ms 02 60 32s747ms 545ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 1m7s 1s129ms 09 60 1m 1s9ms 10 60 1m 1s10ms 11 60 38s794ms 646ms 12 60 2m1s 2s28ms 13 60 35s485ms 591ms 14 60 37s774ms 629ms 15 60 1m21s 1s364ms 16 60 1m16s 1s275ms 17 60 1m21s 1s355ms 18 60 1m6s 1s104ms 19 60 49s253ms 820ms 20 60 50s319ms 838ms 21 60 50s134ms 835ms 22 60 48s735ms 812ms 23 60 48s735ms 812ms 00 60 48s188ms 803ms [ User: labanimal - Total duration: 23m15s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-31 11:48:01 Duration: 3s587ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-31 11:32:01 Duration: 3s552ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-31 11:47:01 Duration: 3s550ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
11 1,440 23m15s 509ms 3s587ms 969ms 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 Mar 31 01 60 0ms 0ms 02 60 32s747ms 545ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 1m7s 1s129ms 09 60 1m 1s9ms 10 60 1m 1s10ms 11 60 38s794ms 646ms 12 60 2m1s 2s28ms 13 60 35s485ms 591ms 14 60 37s774ms 629ms 15 60 1m21s 1s364ms 16 60 1m16s 1s275ms 17 60 1m21s 1s355ms 18 60 1m6s 1s104ms 19 60 49s253ms 820ms 20 60 50s319ms 838ms 21 60 50s134ms 835ms 22 60 48s735ms 812ms 23 60 48s735ms 812ms 00 60 48s188ms 803ms [ User: labanimal - Total duration: 23m15s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-31 11:48:01 Duration: 3s587ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-31 11:32:01 Duration: 3s552ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-31 11:47:01 Duration: 3s550ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
12 1,440 23m15s 509ms 3s587ms 969ms 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 #12
Day Hour Count Duration Avg duration Mar 31 01 60 0ms 0ms 02 60 32s747ms 545ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 1m7s 1s129ms 09 60 1m 1s9ms 10 60 1m 1s10ms 11 60 38s794ms 646ms 12 60 2m1s 2s28ms 13 60 35s485ms 591ms 14 60 37s774ms 629ms 15 60 1m21s 1s364ms 16 60 1m16s 1s275ms 17 60 1m21s 1s355ms 18 60 1m6s 1s104ms 19 60 49s253ms 820ms 20 60 50s319ms 838ms 21 60 50s134ms 835ms 22 60 48s735ms 812ms 23 60 48s735ms 812ms 00 60 48s188ms 803ms [ User: labanimal - Total duration: 23m15s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-03-31 11:48:01 Duration: 3s587ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-03-31 11:32:01 Duration: 3s552ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-03-31 11:47:01 Duration: 3s550ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
13 1,440 23m15s 509ms 3s587ms 969ms 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 #13
Day Hour Count Duration Avg duration Mar 31 01 60 0ms 0ms 02 60 32s747ms 545ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 1m7s 1s129ms 09 60 1m 1s9ms 10 60 1m 1s10ms 11 60 38s794ms 646ms 12 60 2m1s 2s28ms 13 60 35s485ms 591ms 14 60 37s774ms 629ms 15 60 1m21s 1s364ms 16 60 1m16s 1s275ms 17 60 1m21s 1s355ms 18 60 1m6s 1s104ms 19 60 49s253ms 820ms 20 60 50s319ms 838ms 21 60 50s134ms 835ms 22 60 48s735ms 812ms 23 60 48s735ms 812ms 00 60 48s188ms 803ms [ User: labanimal - Total duration: 23m15s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-31 11:48:01 Duration: 3s587ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-31 11:32:01 Duration: 3s552ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-31 11:47:01 Duration: 3s550ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
14 13 9s245ms 699ms 727ms 711ms 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 Mar 31 10 2 1s427ms 713ms 11 2 1s427ms 713ms 12 2 1s420ms 710ms 13 2 1s406ms 703ms 15 2 1s426ms 713ms 16 2 1s407ms 703ms 00 1 727ms 727ms [ User: labanimal - Total duration: 9s245ms - Times executed: 13 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 8s517ms - Times executed: 12 ]
[ Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 - Total duration: 727ms - Times executed: 1 ]
-
SELECT COUNT(DISTINCT animal_id) AS "count" FROM ( SELECT animals_search_mview.*, b.unbreeding_date, a.id as animal, user_is_tgm (animals_search_mview.owner, 1) AS is_owner, user_is_tgm (animals_search_mview.editor, 1) AS is_editor, user_is_tgm (animals_search_mview.tourist, 1) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN animals a ON a."animalID" = animals_search_mview.animal_id LEFT JOIN breedings b ON b.id = animals_search_mview.last_mating) data WHERE fate = 5 AND alive = 't' AND deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-03-31 23:22:31 Duration: 727ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-31_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, 10100187) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100187) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100187) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN animals a ON a."animalID" = animals_search_mview.animal_id LEFT JOIN breedings b ON b.id = animals_search_mview.last_mating) data WHERE fate = 5 AND alive = 't' AND deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-03-31 14:21:45 Duration: 727ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-31_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, 10100176) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100176) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100176) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN animals a ON a."animalID" = animals_search_mview.animal_id LEFT JOIN breedings b ON b.id = animals_search_mview.last_mating) data WHERE fate = 5 AND alive = 't' AND deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-03-31 10:53:20 Duration: 724ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
15 13 8s507ms 635ms 714ms 654ms select distinct * from ( select animals_search_mview.*, b.unbreeding_date, fates.loc as fate_name, user_is_tgm (animals_search_mview.owner, ?) as is_owner, user_is_tgm (animals_search_mview.editor, ?) as is_editor, user_is_tgm (animals_search_mview.tourist, ?) as is_tourist, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, string_agg(l."application_id" || ? || l."title" || ? || date(lh."timestamp")::varchar, ?) as licensehistory, case when not exists ( select ? from scoresheet_diary sd where sd.animals_id = animals_search_mview.id) then ? else ? end as isscored from animals_search_mview inner join fates on fates.id = animals_search_mview.fate left join strains on strains.name = animals_search_mview.strain left join license_history lh on lh.anid = animals_search_mview.id left join licenses l on l.id = lh.licid left join breedings b on b.id = animals_search_mview.last_mating group by animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data where data.fate = ? and data.alive = ? and data.deleted = ? and (is_owner or is_editor or is_tourist) and (data.straindeleted = ? or data.straindeleted is null) order by data.cage_name, data.animal_id, data.name;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Mar 31 10 2 1s296ms 648ms 11 2 1s305ms 652ms 12 2 1s304ms 652ms 13 2 1s295ms 647ms 15 2 1s295ms 647ms 16 2 1s295ms 647ms 00 1 714ms 714ms [ User: labanimal - Total duration: 8s507ms - Times executed: 13 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 7s792ms - Times executed: 12 ]
[ Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 - Total duration: 714ms - Times executed: 1 ]
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 1) AS is_owner, user_is_tgm (animals_search_mview.editor, 1) AS is_editor, user_is_tgm (animals_search_mview.tourist, 1) AS is_tourist, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, STRING_AGG(l."application_id" || ':' || l."title" || ' - ' || Date(lh."timestamp")::varchar, '; ') AS licensehistory, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview INNER JOIN fates ON fates.id = animals_search_mview.fate LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN licenses l ON l.id = lh.licid left join breedings b ON b.id = animals_search_mview.last_mating GROUP BY animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data WHERE data.fate = 5 AND data.alive = 't' AND data.deleted = 'f' AND (is_owner OR is_editor OR is_tourist) and (data.straindeleted = 'f' or data.straindeleted is null) ORDER BY data.cage_name, data.animal_id, data.name;
Date: 2026-03-31 23:22:32 Duration: 714ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 10100176) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100176) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100176) AS is_tourist, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, STRING_AGG(l."application_id" || ':' || l."title" || ' - ' || Date(lh."timestamp")::varchar, '; ') AS licensehistory, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview INNER JOIN fates ON fates.id = animals_search_mview.fate LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN licenses l ON l.id = lh.licid left join breedings b ON b.id = animals_search_mview.last_mating GROUP BY animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data WHERE data.fate = 5 AND data.alive = 't' AND data.deleted = 'f' AND (is_owner OR is_editor OR is_tourist) and (data.straindeleted = 'f' or data.straindeleted is null) ORDER BY data.cage_name, data.animal_id, data.name;
Date: 2026-03-31 10:53:21 Duration: 661ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 10100187) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100187) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100187) AS is_tourist, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, STRING_AGG(l."application_id" || ':' || l."title" || ' - ' || Date(lh."timestamp")::varchar, '; ') AS licensehistory, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview INNER JOIN fates ON fates.id = animals_search_mview.fate LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN licenses l ON l.id = lh.licid left join breedings b ON b.id = animals_search_mview.last_mating GROUP BY animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data WHERE data.fate = 5 AND data.alive = 't' AND data.deleted = 'f' AND (is_owner OR is_editor OR is_tourist) and (data.straindeleted = 'f' or data.straindeleted is null) ORDER BY data.cage_name, data.animal_id, data.name;
Date: 2026-03-31 14:21:45 Duration: 660ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
16 10 35s674ms 3s468ms 3s737ms 3s567ms select * from litters_search_mview l where not (deleted) and case when user_is_tgm (l.owner, ?) then true when user_is_tgm (l.editor, ?) then true when user_is_tgm (l.tourist, ?) then true else false end and (offspring - case when male_wean is null then ? else male_wean end - case when female_wean is null then ? else female_wean end - case when male_dead is null then ? else male_dead end - case when female_dead is null then ? else female_dead end - case when female_deceased is null then ? else female_deceased end - case when male_deceased is null then ? else male_deceased end) <= ? order by bday desc, dam_name, sire_name;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Mar 31 12 10 35s674ms 3s567ms [ User: labanimal - Total duration: 35s674ms - Times executed: 10 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 35s674ms - Times executed: 10 ]
-
SELECT * FROM litters_search_mview l WHERE NOT (deleted) AND CASE WHEN user_is_tgm (l.owner, 438) THEN TRUE WHEN user_is_tgm (l.editor, 438) THEN TRUE WHEN user_is_tgm (l.tourist, 438) THEN TRUE ELSE FALSE END AND (offspring - CASE WHEN male_wean IS NULL THEN 0 ELSE male_wean END - CASE WHEN female_wean IS NULL THEN 0 ELSE female_wean END - CASE WHEN male_dead IS NULL THEN 0 ELSE male_dead END - CASE WHEN female_dead IS NULL THEN 0 ELSE female_dead END - CASE WHEN female_deceased IS NULL THEN 0 ELSE female_deceased END - CASE WHEN male_deceased IS NULL THEN 0 ELSE male_deceased END) <= 0 ORDER BY bday DESC, dam_name, sire_name;
Date: 2026-03-31 11:30:19 Duration: 3s737ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
SELECT * FROM litters_search_mview l WHERE NOT (deleted) AND CASE WHEN user_is_tgm (l.owner, 438) THEN TRUE WHEN user_is_tgm (l.editor, 438) THEN TRUE WHEN user_is_tgm (l.tourist, 438) THEN TRUE ELSE FALSE END AND (offspring - CASE WHEN male_wean IS NULL THEN 0 ELSE male_wean END - CASE WHEN female_wean IS NULL THEN 0 ELSE female_wean END - CASE WHEN male_dead IS NULL THEN 0 ELSE male_dead END - CASE WHEN female_dead IS NULL THEN 0 ELSE female_dead END - CASE WHEN female_deceased IS NULL THEN 0 ELSE female_deceased END - CASE WHEN male_deceased IS NULL THEN 0 ELSE male_deceased END) <= 0 ORDER BY bday DESC, dam_name, sire_name;
Date: 2026-03-31 11:30:23 Duration: 3s693ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
SELECT * FROM litters_search_mview l WHERE NOT (deleted) AND CASE WHEN user_is_tgm (l.owner, 438) THEN TRUE WHEN user_is_tgm (l.editor, 438) THEN TRUE WHEN user_is_tgm (l.tourist, 438) THEN TRUE ELSE FALSE END AND (offspring - CASE WHEN male_wean IS NULL THEN 0 ELSE male_wean END - CASE WHEN female_wean IS NULL THEN 0 ELSE female_wean END - CASE WHEN male_dead IS NULL THEN 0 ELSE male_dead END - CASE WHEN female_dead IS NULL THEN 0 ELSE female_dead END - CASE WHEN female_deceased IS NULL THEN 0 ELSE female_deceased END - CASE WHEN male_deceased IS NULL THEN 0 ELSE male_deceased END) <= 0 ORDER BY bday DESC, dam_name, sire_name;
Date: 2026-03-31 11:48:53 Duration: 3s570ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
17 9 7s465ms 792ms 928ms 829ms with damdam as ( select breedingid, string_agg(cast(dam as text), ?) as dam from breedingsdams inner join ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" from animals) as dam on dam.id = breedingsdams.dam and case when user_is_tgm (dam.owner, ?) then true when user_is_tgm (dam.editor, ?) then true when user_is_tgm (dam.tourist, ?) then true else false end group by breedingid ), siresire as ( select breedingid, string_agg(cast(sire as text), ?) as sire from breedingssires inner join ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" from animals) as sire on sire.id = breedingssires.sire and case when user_is_tgm (sire.owner, ?) then true when user_is_tgm (sire.editor, ?) then true when user_is_tgm (sire.tourist, ?) then true else false end group by breedingid ), cagess as ( select id, "cageName" from cages) ( select breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire from damdam, siresire, cagess, breedings where breedings.deleted != true and cagess.id = breedings.cage and damdam.breedingid = breedings.id and siresire.breedingid = breedings.id and breedings."unbreeding_date" is null group by breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire order by breeding_date, plug_date);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Mar 31 18 3 2s614ms 871ms 19 5 4s39ms 807ms 21 1 812ms 812ms [ User: labanimal - Total duration: 7s465ms - Times executed: 9 ]
[ Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 - Total duration: 7s465ms - Times executed: 9 ]
-
WITH damdam AS ( SELECT breedingid, string_agg(cast(dam as text), ';') AS dam FROM breedingsdams INNER JOIN ( SELECT id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS dam ON dam.id = breedingsdams.dam AND CASE WHEN user_is_tgm (dam.owner, 1) THEN TRUE WHEN user_is_tgm (dam.editor, 1) THEN TRUE WHEN user_is_tgm (dam.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), siresire AS ( SELECT breedingid, string_agg(cast(sire as text), ';') AS sire FROM breedingssires INNER JOIN ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS sire ON sire.id = breedingssires.sire AND CASE WHEN user_is_tgm (sire.owner, 1) THEN TRUE WHEN user_is_tgm (sire.editor, 1) THEN TRUE WHEN user_is_tgm (sire.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-03-31 17:40:44 Duration: 928ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
WITH damdam AS ( SELECT breedingid, string_agg(cast(dam as text), ';') AS dam FROM breedingsdams INNER JOIN ( SELECT id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS dam ON dam.id = breedingsdams.dam AND CASE WHEN user_is_tgm (dam.owner, 1) THEN TRUE WHEN user_is_tgm (dam.editor, 1) THEN TRUE WHEN user_is_tgm (dam.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), siresire AS ( SELECT breedingid, string_agg(cast(sire as text), ';') AS sire FROM breedingssires INNER JOIN ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS sire ON sire.id = breedingssires.sire AND CASE WHEN user_is_tgm (sire.owner, 1) THEN TRUE WHEN user_is_tgm (sire.editor, 1) THEN TRUE WHEN user_is_tgm (sire.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-03-31 17:41:06 Duration: 874ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
WITH damdam AS ( SELECT breedingid, string_agg(cast(dam as text), ';') AS dam FROM breedingsdams INNER JOIN ( SELECT id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS dam ON dam.id = breedingsdams.dam AND CASE WHEN user_is_tgm (dam.owner, 1) THEN TRUE WHEN user_is_tgm (dam.editor, 1) THEN TRUE WHEN user_is_tgm (dam.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), siresire AS ( SELECT breedingid, string_agg(cast(sire as text), ';') AS sire FROM breedingssires INNER JOIN ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS sire ON sire.id = breedingssires.sire AND CASE WHEN user_is_tgm (sire.owner, 1) THEN TRUE WHEN user_is_tgm (sire.editor, 1) THEN TRUE WHEN user_is_tgm (sire.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-03-31 18:35:27 Duration: 838ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
18 7 5s907ms 572ms 1s513ms 843ms select count(distinct animal_id) AS "count" from ( select animals_search_mview.*, b.unbreeding_date, a.id as animal, user_is_tgm (animals_search_mview.owner, ?) as is_owner, user_is_tgm (animals_search_mview.editor, ?) as is_editor, user_is_tgm (animals_search_mview.tourist, ?) as is_tourist, case when not exists ( select ? from scoresheet_diary sd where sd.animals_id = animals_search_mview.id) then ? else ? end as isscored from animals_search_mview left join strains on strains.name = animals_search_mview.strain left join license_history lh on lh.anid = animals_search_mview.id left join animals a on a."animalID" = animals_search_mview.animal_id left join breedings b on b.id = animals_search_mview.last_mating) data where deleted = ? and strain ilike ? and (is_owner or is_editor or is_tourist);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Mar 31 13 3 1s723ms 574ms 16 4 4s183ms 1s45ms [ User: labanimal - Total duration: 5s907ms - Times executed: 7 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 5s907ms - Times executed: 7 ]
-
SELECT COUNT(DISTINCT animal_id) AS "count" FROM ( SELECT animals_search_mview.*, b.unbreeding_date, a.id as animal, user_is_tgm (animals_search_mview.owner, 332) AS is_owner, user_is_tgm (animals_search_mview.editor, 332) AS is_editor, user_is_tgm (animals_search_mview.tourist, 332) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN animals a ON a."animalID" = animals_search_mview.animal_id LEFT JOIN breedings b ON b.id = animals_search_mview.last_mating) data WHERE deleted = 'f' AND strain ILIKE 'B6/J' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-03-31 15:57:17 Duration: 1s513ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
SELECT COUNT(DISTINCT animal_id) AS "count" FROM ( SELECT animals_search_mview.*, b.unbreeding_date, a.id as animal, user_is_tgm (animals_search_mview.owner, 332) AS is_owner, user_is_tgm (animals_search_mview.editor, 332) AS is_editor, user_is_tgm (animals_search_mview.tourist, 332) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN animals a ON a."animalID" = animals_search_mview.animal_id LEFT JOIN breedings b ON b.id = animals_search_mview.last_mating) data WHERE deleted = 'f' AND strain ILIKE 'B6/J' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-03-31 15:57:13 Duration: 1s498ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
SELECT COUNT(DISTINCT animal_id) AS "count" FROM ( SELECT animals_search_mview.*, b.unbreeding_date, a.id as animal, user_is_tgm (animals_search_mview.owner, 332) AS is_owner, user_is_tgm (animals_search_mview.editor, 332) AS is_editor, user_is_tgm (animals_search_mview.tourist, 332) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN animals a ON a."animalID" = animals_search_mview.animal_id LEFT JOIN breedings b ON b.id = animals_search_mview.last_mating) data WHERE deleted = 'f' AND strain ILIKE '%CD9%' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-03-31 15:53:13 Duration: 587ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
19 7 5s390ms 533ms 1s355ms 770ms select distinct * from ( select animals_search_mview.*, b.unbreeding_date, fates.loc as fate_name, user_is_tgm (animals_search_mview.owner, ?) as is_owner, user_is_tgm (animals_search_mview.editor, ?) as is_editor, user_is_tgm (animals_search_mview.tourist, ?) as is_tourist, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, string_agg(l."application_id" || ? || l."title" || ? || date(lh."timestamp")::varchar, ?) as licensehistory, case when not exists ( select ? from scoresheet_diary sd where sd.animals_id = animals_search_mview.id) then ? else ? end as isscored from animals_search_mview inner join fates on fates.id = animals_search_mview.fate left join strains on strains.name = animals_search_mview.strain left join license_history lh on lh.anid = animals_search_mview.id left join licenses l on l.id = lh.licid left join breedings b on b.id = animals_search_mview.last_mating group by animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data where data.deleted = ? and data.strain ilike ? and (is_owner or is_editor or is_tourist) and (data.straindeleted = ? or data.straindeleted is null) order by data.cage_name, data.animal_id, data.name;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 31 13 3 1s641ms 547ms 16 4 3s748ms 937ms [ User: labanimal - Total duration: 5s390ms - Times executed: 7 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 5s390ms - Times executed: 7 ]
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 332) AS is_owner, user_is_tgm (animals_search_mview.editor, 332) AS is_editor, user_is_tgm (animals_search_mview.tourist, 332) AS is_tourist, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, STRING_AGG(l."application_id" || ':' || l."title" || ' - ' || Date(lh."timestamp")::varchar, '; ') AS licensehistory, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview INNER JOIN fates ON fates.id = animals_search_mview.fate LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN licenses l ON l.id = lh.licid left join breedings b ON b.id = animals_search_mview.last_mating GROUP BY animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data WHERE data.deleted = 'f' AND data.strain ILIKE 'B6/J' AND (is_owner OR is_editor OR is_tourist) and (data.straindeleted = 'f' or data.straindeleted is null) ORDER BY data.cage_name, data.animal_id, data.name;
Date: 2026-03-31 15:57:19 Duration: 1s355ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 332) AS is_owner, user_is_tgm (animals_search_mview.editor, 332) AS is_editor, user_is_tgm (animals_search_mview.tourist, 332) AS is_tourist, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, STRING_AGG(l."application_id" || ':' || l."title" || ' - ' || Date(lh."timestamp")::varchar, '; ') AS licensehistory, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview INNER JOIN fates ON fates.id = animals_search_mview.fate LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN licenses l ON l.id = lh.licid left join breedings b ON b.id = animals_search_mview.last_mating GROUP BY animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data WHERE data.deleted = 'f' AND data.strain ILIKE 'B6/J' AND (is_owner OR is_editor OR is_tourist) and (data.straindeleted = 'f' or data.straindeleted is null) ORDER BY data.cage_name, data.animal_id, data.name;
Date: 2026-03-31 15:57:14 Duration: 1s322ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 10100179) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100179) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100179) AS is_tourist, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, STRING_AGG(l."application_id" || ':' || l."title" || ' - ' || Date(lh."timestamp")::varchar, '; ') AS licensehistory, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview INNER JOIN fates ON fates.id = animals_search_mview.fate LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN licenses l ON l.id = lh.licid left join breedings b ON b.id = animals_search_mview.last_mating GROUP BY animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data WHERE data.deleted = 'f' AND data.strain ILIKE '%gp5-dthr%' AND (is_owner OR is_editor OR is_tourist) and (data.straindeleted = 'f' or data.straindeleted is null) ORDER BY data.cage_name, data.animal_id, data.name;
Date: 2026-03-31 12:12:25 Duration: 547ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
20 5 28s261ms 1s481ms 6s735ms 5s652ms copy public."targetgroupMembers" (id, targetgroup, "user", "group") to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 31 12 4 26s779ms 6s694ms 00 1 1s481ms 1s481ms [ User: labanimal - Total duration: 26s779ms - Times executed: 4 ]
[ User: postgres - Total duration: 1s481ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 28s261ms - Times executed: 5 ]
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-03-31 11:48:55 Duration: 6s735ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-03-31 11:52:05 Duration: 6s706ms Database: zemm_produktiv_7 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-03-31 11:49:22 Duration: 6s669ms Database: zemm_produktiv_7 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 1s481ms 6s735ms 5s652ms 5 28s261ms copy public."targetgroupMembers" (id, targetgroup, "user", "group") to stdout;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 31 12 4 26s779ms 6s694ms 00 1 1s481ms 1s481ms [ User: labanimal - Total duration: 26s779ms - Times executed: 4 ]
[ User: postgres - Total duration: 1s481ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 28s261ms - Times executed: 5 ]
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-03-31 11:48:55 Duration: 6s735ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-03-31 11:52:05 Duration: 6s706ms Database: zemm_produktiv_7 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-03-31 11:49:22 Duration: 6s669ms Database: zemm_produktiv_7 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
2 1s315ms 4s924ms 4s177ms 5 20s889ms copy public.animals_search_mview (id, name, animal_id, deleted, alive, birth_date, arrival_date, death_date, outgoing_date, cage, comments, sterile, breeding, fate, last_mating, last_mating_date, breeding_cage, sex, strain, line, gene_1_info, gene_1_type, gene_2_info, gene_2_type, gene_3_info, gene_3_type, gene_4_info, gene_4_type, gene_5_info, gene_5_type, backcross, generation, project, project_name, species, species_name, cage_name, location, location_name, dam, dam_name, dam_id, sire, sire_name, sire_id, cohort, litter, rfid, owner, editor, tourist, breeding_status, workgroup_infos, experiment, experiment_name) to stdout;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 31 12 4 19s573ms 4s893ms 00 1 1s315ms 1s315ms [ User: labanimal - Total duration: 19s573ms - Times executed: 4 ]
[ User: postgres - Total duration: 1s315ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 20s889ms - Times executed: 5 ]
-
COPY public.animals_search_mview (id, name, animal_id, deleted, alive, birth_date, arrival_date, death_date, outgoing_date, cage, comments, sterile, breeding, fate, last_mating, last_mating_date, breeding_cage, sex, strain, line, gene_1_info, gene_1_type, gene_2_info, gene_2_type, gene_3_info, gene_3_type, gene_4_info, gene_4_type, gene_5_info, gene_5_type, backcross, generation, project, project_name, species, species_name, cage_name, location, location_name, dam, dam_name, dam_id, sire, sire_name, sire_id, cohort, litter, rfid, owner, editor, tourist, breeding_status, workgroup_infos, experiment, experiment_name) TO stdout;
Date: 2026-03-31 11:48:41 Duration: 4s924ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
COPY public.animals_search_mview (id, name, animal_id, deleted, alive, birth_date, arrival_date, death_date, outgoing_date, cage, comments, sterile, breeding, fate, last_mating, last_mating_date, breeding_cage, sex, strain, line, gene_1_info, gene_1_type, gene_2_info, gene_2_type, gene_3_info, gene_3_type, gene_4_info, gene_4_type, gene_5_info, gene_5_type, backcross, generation, project, project_name, species, species_name, cage_name, location, location_name, dam, dam_name, dam_id, sire, sire_name, sire_id, cohort, litter, rfid, owner, editor, tourist, breeding_status, workgroup_infos, experiment, experiment_name) TO stdout;
Date: 2026-03-31 11:51:25 Duration: 4s902ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
COPY public.animals_search_mview (id, name, animal_id, deleted, alive, birth_date, arrival_date, death_date, outgoing_date, cage, comments, sterile, breeding, fate, last_mating, last_mating_date, breeding_cage, sex, strain, line, gene_1_info, gene_1_type, gene_2_info, gene_2_type, gene_3_info, gene_3_type, gene_4_info, gene_4_type, gene_5_info, gene_5_type, backcross, generation, project, project_name, species, species_name, cage_name, location, location_name, dam, dam_name, dam_id, sire, sire_name, sire_id, cohort, litter, rfid, owner, editor, tourist, breeding_status, workgroup_infos, experiment, experiment_name) TO stdout;
Date: 2026-03-31 11:51:51 Duration: 4s884ms Database: zemm_produktiv_7 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
3 3s550ms 3s663ms 3s590ms 4 14s360ms select * from litters_search_mview l where not (deleted) and case when user_is_tgm (l.owner, ?) then true when user_is_tgm (l.editor, ?) then true when user_is_tgm (l.tourist, ?) then true else false end order by bday desc, dam_name, sire_name;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 31 12 4 14s360ms 3s590ms [ User: labanimal - Total duration: 14s360ms - Times executed: 4 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 14s360ms - Times executed: 4 ]
-
SELECT * FROM litters_search_mview l WHERE NOT (deleted) AND CASE WHEN user_is_tgm (l.owner, 438) THEN TRUE WHEN user_is_tgm (l.editor, 438) THEN TRUE WHEN user_is_tgm (l.tourist, 438) THEN TRUE ELSE FALSE END ORDER BY bday DESC, dam_name, sire_name;
Date: 2026-03-31 11:47:24 Duration: 3s663ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
SELECT * FROM litters_search_mview l WHERE NOT (deleted) AND CASE WHEN user_is_tgm (l.owner, 438) THEN TRUE WHEN user_is_tgm (l.editor, 438) THEN TRUE WHEN user_is_tgm (l.tourist, 438) THEN TRUE ELSE FALSE END ORDER BY bday DESC, dam_name, sire_name;
Date: 2026-03-31 11:47:28 Duration: 3s587ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
SELECT * FROM litters_search_mview l WHERE NOT (deleted) AND CASE WHEN user_is_tgm (l.owner, 438) THEN TRUE WHEN user_is_tgm (l.editor, 438) THEN TRUE WHEN user_is_tgm (l.tourist, 438) THEN TRUE ELSE FALSE END ORDER BY bday DESC, dam_name, sire_name;
Date: 2026-03-31 11:46:22 Duration: 3s558ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
4 3s468ms 3s737ms 3s567ms 10 35s674ms select * from litters_search_mview l where not (deleted) and case when user_is_tgm (l.owner, ?) then true when user_is_tgm (l.editor, ?) then true when user_is_tgm (l.tourist, ?) then true else false end and (offspring - case when male_wean is null then ? else male_wean end - case when female_wean is null then ? else female_wean end - case when male_dead is null then ? else male_dead end - case when female_dead is null then ? else female_dead end - case when female_deceased is null then ? else female_deceased end - case when male_deceased is null then ? else male_deceased end) <= ? order by bday desc, dam_name, sire_name;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 31 12 10 35s674ms 3s567ms [ User: labanimal - Total duration: 35s674ms - Times executed: 10 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 35s674ms - Times executed: 10 ]
-
SELECT * FROM litters_search_mview l WHERE NOT (deleted) AND CASE WHEN user_is_tgm (l.owner, 438) THEN TRUE WHEN user_is_tgm (l.editor, 438) THEN TRUE WHEN user_is_tgm (l.tourist, 438) THEN TRUE ELSE FALSE END AND (offspring - CASE WHEN male_wean IS NULL THEN 0 ELSE male_wean END - CASE WHEN female_wean IS NULL THEN 0 ELSE female_wean END - CASE WHEN male_dead IS NULL THEN 0 ELSE male_dead END - CASE WHEN female_dead IS NULL THEN 0 ELSE female_dead END - CASE WHEN female_deceased IS NULL THEN 0 ELSE female_deceased END - CASE WHEN male_deceased IS NULL THEN 0 ELSE male_deceased END) <= 0 ORDER BY bday DESC, dam_name, sire_name;
Date: 2026-03-31 11:30:19 Duration: 3s737ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
SELECT * FROM litters_search_mview l WHERE NOT (deleted) AND CASE WHEN user_is_tgm (l.owner, 438) THEN TRUE WHEN user_is_tgm (l.editor, 438) THEN TRUE WHEN user_is_tgm (l.tourist, 438) THEN TRUE ELSE FALSE END AND (offspring - CASE WHEN male_wean IS NULL THEN 0 ELSE male_wean END - CASE WHEN female_wean IS NULL THEN 0 ELSE female_wean END - CASE WHEN male_dead IS NULL THEN 0 ELSE male_dead END - CASE WHEN female_dead IS NULL THEN 0 ELSE female_dead END - CASE WHEN female_deceased IS NULL THEN 0 ELSE female_deceased END - CASE WHEN male_deceased IS NULL THEN 0 ELSE male_deceased END) <= 0 ORDER BY bday DESC, dam_name, sire_name;
Date: 2026-03-31 11:30:23 Duration: 3s693ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
SELECT * FROM litters_search_mview l WHERE NOT (deleted) AND CASE WHEN user_is_tgm (l.owner, 438) THEN TRUE WHEN user_is_tgm (l.editor, 438) THEN TRUE WHEN user_is_tgm (l.tourist, 438) THEN TRUE ELSE FALSE END AND (offspring - CASE WHEN male_wean IS NULL THEN 0 ELSE male_wean END - CASE WHEN female_wean IS NULL THEN 0 ELSE female_wean END - CASE WHEN male_dead IS NULL THEN 0 ELSE male_dead END - CASE WHEN female_dead IS NULL THEN 0 ELSE female_dead END - CASE WHEN female_deceased IS NULL THEN 0 ELSE female_deceased END - CASE WHEN male_deceased IS NULL THEN 0 ELSE male_deceased END) <= 0 ORDER BY bday DESC, dam_name, sire_name;
Date: 2026-03-31 11:48:53 Duration: 3s570ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
5 1s976ms 3s420ms 3s85ms 5 15s425ms copy public.diary (id, "animalID", date, "entrybyID", "cageID", weight, temperature, "fDeprivation", "wDeprivation", "sDeprivation", "feedingClass", health, comments, "breedingInfo", deleted, "inOutDate", "inOutFlag", text, sdesc, treatment, tailcut_id, tailcut_result, file_name, file_content, file_type, upload_name, old_gene_type, old_gene_info, old_gene2_type, old_gene2_info, old_gene3_info, old_gene3_type, old_gene4_info, old_gene4_type, old_gene5_info, old_gene5_type) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Mar 31 12 4 13s449ms 3s362ms 00 1 1s976ms 1s976ms [ User: labanimal - Total duration: 13s449ms - Times executed: 4 ]
[ User: postgres - Total duration: 1s976ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 15s425ms - Times executed: 5 ]
-
COPY public.diary (id, "animalID", date, "entrybyID", "cageID", weight, temperature, "fDeprivation", "wDeprivation", "sDeprivation", "feedingClass", health, comments, "breedingInfo", deleted, "inOutDate", "inOutFlag", text, sdesc, treatment, tailcut_id, tailcut_result, file_name, file_content, file_type, upload_name, old_gene_type, old_gene_info, old_gene2_type, old_gene2_info, old_gene3_info, old_gene3_type, old_gene4_info, old_gene4_type, old_gene5_info, old_gene5_type) TO stdout;
Date: 2026-03-31 11:48:46 Duration: 3s420ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
COPY public.diary (id, "animalID", date, "entrybyID", "cageID", weight, temperature, "fDeprivation", "wDeprivation", "sDeprivation", "feedingClass", health, comments, "breedingInfo", deleted, "inOutDate", "inOutFlag", text, sdesc, treatment, tailcut_id, tailcut_result, file_name, file_content, file_type, upload_name, old_gene_type, old_gene_info, old_gene2_type, old_gene2_info, old_gene3_info, old_gene3_type, old_gene4_info, old_gene4_type, old_gene5_info, old_gene5_type) TO stdout;
Date: 2026-03-31 11:49:13 Duration: 3s369ms Database: zemm_produktiv_7 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
COPY public.diary (id, "animalID", date, "entrybyID", "cageID", weight, temperature, "fDeprivation", "wDeprivation", "sDeprivation", "feedingClass", health, comments, "breedingInfo", deleted, "inOutDate", "inOutFlag", text, sdesc, treatment, tailcut_id, tailcut_result, file_name, file_content, file_type, upload_name, old_gene_type, old_gene_info, old_gene2_type, old_gene2_info, old_gene3_info, old_gene3_type, old_gene4_info, old_gene4_type, old_gene5_info, old_gene5_type) TO stdout;
Date: 2026-03-31 11:51:29 Duration: 3s331ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
6 1s221ms 3s58ms 2s686ms 5 13s432ms copy public.animals (id, species, transgen, "homeCage", tourist, editor, owner, comments, pregnant, name, sex, "standardDescription", "parentFemale", "parentMale", "parentFoster", colour, "plannedUseFor", deleted, generation, chimare, "birthDate", "arrivalDate", "outgoingDate", "deathDate", breedstatus_2, "healthState", breeder, restrictions, "geneStatus", "geneFlanking", "geneDeleted", "fromOrder_2", "group", "fromOrder", strain, "breedStatus", "FEMnumber", genotype, inbreeding, identification, jax, "KOgene", "feedingClass", dummy_gen_info, breeding, sterile, project, dummy_line_info, dummy_strain_info, "bredWith", "curCage", dummy_backcross_info, fate, "fateComment", alive, reciever, "animalID", litter, weight_at_arrival, cohort, gen_2_info, gen_3_info, gen_4_info, gen_5_info, gen_1_typ, gen_2_typ, gen_3_typ, gen_4_typ, gen_5_typ, "latestMatingDate", "latestMating", genecomment, recycle) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Mar 31 12 4 12s211ms 3s52ms 00 1 1s221ms 1s221ms [ User: labanimal - Total duration: 12s211ms - Times executed: 4 ]
[ User: postgres - Total duration: 1s221ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 13s432ms - Times executed: 5 ]
-
COPY public.animals (id, species, transgen, "homeCage", tourist, editor, owner, comments, pregnant, name, sex, "standardDescription", "parentFemale", "parentMale", "parentFoster", colour, "plannedUseFor", deleted, generation, chimare, "birthDate", "arrivalDate", "outgoingDate", "deathDate", breedstatus_2, "healthState", breeder, restrictions, "geneStatus", "geneFlanking", "geneDeleted", "fromOrder_2", "group", "fromOrder", strain, "breedStatus", "FEMnumber", genotype, inbreeding, identification, jax, "KOgene", "feedingClass", dummy_gen_info, breeding, sterile, project, dummy_line_info, dummy_strain_info, "bredWith", "curCage", dummy_backcross_info, fate, "fateComment", alive, reciever, "animalID", litter, weight_at_arrival, cohort, gen_2_info, gen_3_info, gen_4_info, gen_5_info, gen_1_typ, gen_2_typ, gen_3_typ, gen_4_typ, gen_5_typ, "latestMatingDate", "latestMating", genecomment, recycle) TO stdout;
Date: 2026-03-31 11:49:03 Duration: 3s58ms Database: zemm_produktiv_7 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
COPY public.animals (id, species, transgen, "homeCage", tourist, editor, owner, comments, pregnant, name, sex, "standardDescription", "parentFemale", "parentMale", "parentFoster", colour, "plannedUseFor", deleted, generation, chimare, "birthDate", "arrivalDate", "outgoingDate", "deathDate", breedstatus_2, "healthState", breeder, restrictions, "geneStatus", "geneFlanking", "geneDeleted", "fromOrder_2", "group", "fromOrder", strain, "breedStatus", "FEMnumber", genotype, inbreeding, identification, jax, "KOgene", "feedingClass", dummy_gen_info, breeding, sterile, project, dummy_line_info, dummy_strain_info, "bredWith", "curCage", dummy_backcross_info, fate, "fateComment", alive, reciever, "animalID", litter, weight_at_arrival, cohort, gen_2_info, gen_3_info, gen_4_info, gen_5_info, gen_1_typ, gen_2_typ, gen_3_typ, gen_4_typ, gen_5_typ, "latestMatingDate", "latestMating", genecomment, recycle) TO stdout;
Date: 2026-03-31 11:48:36 Duration: 3s55ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
COPY public.animals (id, species, transgen, "homeCage", tourist, editor, owner, comments, pregnant, name, sex, "standardDescription", "parentFemale", "parentMale", "parentFoster", colour, "plannedUseFor", deleted, generation, chimare, "birthDate", "arrivalDate", "outgoingDate", "deathDate", breedstatus_2, "healthState", breeder, restrictions, "geneStatus", "geneFlanking", "geneDeleted", "fromOrder_2", "group", "fromOrder", strain, "breedStatus", "FEMnumber", genotype, inbreeding, identification, jax, "KOgene", "feedingClass", dummy_gen_info, breeding, sterile, project, dummy_line_info, dummy_strain_info, "bredWith", "curCage", dummy_backcross_info, fate, "fateComment", alive, reciever, "animalID", litter, weight_at_arrival, cohort, gen_2_info, gen_3_info, gen_4_info, gen_5_info, gen_1_typ, gen_2_typ, gen_3_typ, gen_4_typ, gen_5_typ, "latestMatingDate", "latestMating", genecomment, recycle) TO stdout;
Date: 2026-03-31 11:51:20 Duration: 3s49ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
7 509ms 3s587ms 969ms 1,440 23m15s 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 #7
Day Hour Count Duration Avg duration Mar 31 01 60 0ms 0ms 02 60 32s747ms 545ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 1m7s 1s129ms 09 60 1m 1s9ms 10 60 1m 1s10ms 11 60 38s794ms 646ms 12 60 2m1s 2s28ms 13 60 35s485ms 591ms 14 60 37s774ms 629ms 15 60 1m21s 1s364ms 16 60 1m16s 1s275ms 17 60 1m21s 1s355ms 18 60 1m6s 1s104ms 19 60 49s253ms 820ms 20 60 50s319ms 838ms 21 60 50s134ms 835ms 22 60 48s735ms 812ms 23 60 48s735ms 812ms 00 60 48s188ms 803ms [ User: labanimal - Total duration: 23m15s - 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-03-31 11:48:01 Duration: 3s587ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_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-03-31 11:32:01 Duration: 3s552ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_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-03-31 11:47:01 Duration: 3s550ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
8 509ms 3s587ms 969ms 1,440 23m15s create table if not exists observability.db_top_queries ( id bigserial primary key, tenant_key text not null, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz not null default now() );Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Mar 31 01 60 0ms 0ms 02 60 32s747ms 545ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 1m7s 1s129ms 09 60 1m 1s9ms 10 60 1m 1s10ms 11 60 38s794ms 646ms 12 60 2m1s 2s28ms 13 60 35s485ms 591ms 14 60 37s774ms 629ms 15 60 1m21s 1s364ms 16 60 1m16s 1s275ms 17 60 1m21s 1s355ms 18 60 1m6s 1s104ms 19 60 49s253ms 820ms 20 60 50s319ms 838ms 21 60 50s134ms 835ms 22 60 48s735ms 812ms 23 60 48s735ms 812ms 00 60 48s188ms 803ms [ User: labanimal - Total duration: 23m15s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-31 11:48:01 Duration: 3s587ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-31 11:32:01 Duration: 3s552ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-31 11:47:01 Duration: 3s550ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
9 509ms 3s587ms 969ms 1,440 23m15s create index if not exists idx_app_events_type on observability.app_events (event_type);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Mar 31 01 60 0ms 0ms 02 60 32s747ms 545ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 1m7s 1s129ms 09 60 1m 1s9ms 10 60 1m 1s10ms 11 60 38s794ms 646ms 12 60 2m1s 2s28ms 13 60 35s485ms 591ms 14 60 37s774ms 629ms 15 60 1m21s 1s364ms 16 60 1m16s 1s275ms 17 60 1m21s 1s355ms 18 60 1m6s 1s104ms 19 60 49s253ms 820ms 20 60 50s319ms 838ms 21 60 50s134ms 835ms 22 60 48s735ms 812ms 23 60 48s735ms 812ms 00 60 48s188ms 803ms [ User: labanimal - Total duration: 23m15s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-31 11:48:01 Duration: 3s587ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-31 11:32:01 Duration: 3s552ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-31 11:47:01 Duration: 3s550ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
10 509ms 3s587ms 969ms 1,440 23m15s create table if not exists observability.app_events ( id bigserial primary key, tenant_key text not null, event_type text not null, severity text not null, message text not null, payload jsonb, occurred_at timestamptz not null default now(), created_at timestamptz not null default now() );Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Mar 31 01 60 0ms 0ms 02 60 32s747ms 545ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 1m7s 1s129ms 09 60 1m 1s9ms 10 60 1m 1s10ms 11 60 38s794ms 646ms 12 60 2m1s 2s28ms 13 60 35s485ms 591ms 14 60 37s774ms 629ms 15 60 1m21s 1s364ms 16 60 1m16s 1s275ms 17 60 1m21s 1s355ms 18 60 1m6s 1s104ms 19 60 49s253ms 820ms 20 60 50s319ms 838ms 21 60 50s134ms 835ms 22 60 48s735ms 812ms 23 60 48s735ms 812ms 00 60 48s188ms 803ms [ User: labanimal - Total duration: 23m15s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-31 11:48:01 Duration: 3s587ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-31 11:32:01 Duration: 3s552ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-31 11:47:01 Duration: 3s550ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
11 509ms 3s587ms 969ms 1,440 23m15s create schema if not exists observability;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Mar 31 01 60 0ms 0ms 02 60 32s747ms 545ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 1m7s 1s129ms 09 60 1m 1s9ms 10 60 1m 1s10ms 11 60 38s794ms 646ms 12 60 2m1s 2s28ms 13 60 35s485ms 591ms 14 60 37s774ms 629ms 15 60 1m21s 1s364ms 16 60 1m16s 1s275ms 17 60 1m21s 1s355ms 18 60 1m6s 1s104ms 19 60 49s253ms 820ms 20 60 50s319ms 838ms 21 60 50s134ms 835ms 22 60 48s735ms 812ms 23 60 48s735ms 812ms 00 60 48s188ms 803ms [ User: labanimal - Total duration: 23m15s - Times executed: 1349 ]
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-31 11:48:01 Duration: 3s587ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-31 11:32:01 Duration: 3s552ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-31 11:47:01 Duration: 3s550ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
12 509ms 3s587ms 969ms 1,440 23m15s create index if not exists idx_app_events_tenant on observability.app_events (tenant_key, occurred_at desc);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Mar 31 01 60 0ms 0ms 02 60 32s747ms 545ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 1m7s 1s129ms 09 60 1m 1s9ms 10 60 1m 1s10ms 11 60 38s794ms 646ms 12 60 2m1s 2s28ms 13 60 35s485ms 591ms 14 60 37s774ms 629ms 15 60 1m21s 1s364ms 16 60 1m16s 1s275ms 17 60 1m21s 1s355ms 18 60 1m6s 1s104ms 19 60 49s253ms 820ms 20 60 50s319ms 838ms 21 60 50s134ms 835ms 22 60 48s735ms 812ms 23 60 48s735ms 812ms 00 60 48s188ms 803ms [ User: labanimal - Total duration: 23m15s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-31 11:48:01 Duration: 3s587ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-31 11:32:01 Duration: 3s552ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-31 11:47:01 Duration: 3s550ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
13 509ms 3s587ms 969ms 1,440 23m15s create index if not exists idx_metrics_timeseries_metric on observability.metrics_timeseries (metric_name);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Mar 31 01 60 0ms 0ms 02 60 32s747ms 545ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 1m7s 1s129ms 09 60 1m 1s9ms 10 60 1m 1s10ms 11 60 38s794ms 646ms 12 60 2m1s 2s28ms 13 60 35s485ms 591ms 14 60 37s774ms 629ms 15 60 1m21s 1s364ms 16 60 1m16s 1s275ms 17 60 1m21s 1s355ms 18 60 1m6s 1s104ms 19 60 49s253ms 820ms 20 60 50s319ms 838ms 21 60 50s134ms 835ms 22 60 48s735ms 812ms 23 60 48s735ms 812ms 00 60 48s188ms 803ms [ User: labanimal - Total duration: 23m15s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-31 11:48:01 Duration: 3s587ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-31 11:32:01 Duration: 3s552ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-31 11:47:01 Duration: 3s550ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
14 509ms 3s587ms 969ms 1,440 23m15s 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 #14
Day Hour Count Duration Avg duration Mar 31 01 60 0ms 0ms 02 60 32s747ms 545ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 1m7s 1s129ms 09 60 1m 1s9ms 10 60 1m 1s10ms 11 60 38s794ms 646ms 12 60 2m1s 2s28ms 13 60 35s485ms 591ms 14 60 37s774ms 629ms 15 60 1m21s 1s364ms 16 60 1m16s 1s275ms 17 60 1m21s 1s355ms 18 60 1m6s 1s104ms 19 60 49s253ms 820ms 20 60 50s319ms 838ms 21 60 50s134ms 835ms 22 60 48s735ms 812ms 23 60 48s735ms 812ms 00 60 48s188ms 803ms [ User: labanimal - Total duration: 23m15s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-03-31 11:48:01 Duration: 3s587ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-03-31 11:32:01 Duration: 3s552ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-03-31 11:47:01 Duration: 3s550ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
15 509ms 3s587ms 969ms 1,440 23m15s 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 #15
Day Hour Count Duration Avg duration Mar 31 01 60 0ms 0ms 02 60 32s747ms 545ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 1m7s 1s129ms 09 60 1m 1s9ms 10 60 1m 1s10ms 11 60 38s794ms 646ms 12 60 2m1s 2s28ms 13 60 35s485ms 591ms 14 60 37s774ms 629ms 15 60 1m21s 1s364ms 16 60 1m16s 1s275ms 17 60 1m21s 1s355ms 18 60 1m6s 1s104ms 19 60 49s253ms 820ms 20 60 50s319ms 838ms 21 60 50s134ms 835ms 22 60 48s735ms 812ms 23 60 48s735ms 812ms 00 60 48s188ms 803ms [ User: labanimal - Total duration: 23m15s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-31 11:48:01 Duration: 3s587ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-31 11:32:01 Duration: 3s552ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-31 11:47:01 Duration: 3s550ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
16 509ms 3s587ms 969ms 1,440 23m15s 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 #16
Day Hour Count Duration Avg duration Mar 31 01 60 0ms 0ms 02 60 32s747ms 545ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 1m7s 1s129ms 09 60 1m 1s9ms 10 60 1m 1s10ms 11 60 38s794ms 646ms 12 60 2m1s 2s28ms 13 60 35s485ms 591ms 14 60 37s774ms 629ms 15 60 1m21s 1s364ms 16 60 1m16s 1s275ms 17 60 1m21s 1s355ms 18 60 1m6s 1s104ms 19 60 49s253ms 820ms 20 60 50s319ms 838ms 21 60 50s134ms 835ms 22 60 48s735ms 812ms 23 60 48s735ms 812ms 00 60 48s188ms 803ms [ User: labanimal - Total duration: 23m15s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-31 11:48:01 Duration: 3s587ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-31 11:32:01 Duration: 3s552ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-31 11:47:01 Duration: 3s550ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
17 509ms 3s587ms 969ms 1,440 23m15s create index if not exists idx_metrics_timeseries_bucket on observability.metrics_timeseries (bucket_start);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Mar 31 01 60 0ms 0ms 02 60 32s747ms 545ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 1m7s 1s129ms 09 60 1m 1s9ms 10 60 1m 1s10ms 11 60 38s794ms 646ms 12 60 2m1s 2s28ms 13 60 35s485ms 591ms 14 60 37s774ms 629ms 15 60 1m21s 1s364ms 16 60 1m16s 1s275ms 17 60 1m21s 1s355ms 18 60 1m6s 1s104ms 19 60 49s253ms 820ms 20 60 50s319ms 838ms 21 60 50s134ms 835ms 22 60 48s735ms 812ms 23 60 48s735ms 812ms 00 60 48s188ms 803ms [ User: labanimal - Total duration: 23m15s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-31 11:48:01 Duration: 3s587ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-31 11:32:01 Duration: 3s552ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-31 11:47:01 Duration: 3s550ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
18 509ms 3s587ms 969ms 1,440 23m15s 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 #18
Day Hour Count Duration Avg duration Mar 31 01 60 0ms 0ms 02 60 32s747ms 545ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 1m7s 1s129ms 09 60 1m 1s9ms 10 60 1m 1s10ms 11 60 38s794ms 646ms 12 60 2m1s 2s28ms 13 60 35s485ms 591ms 14 60 37s774ms 629ms 15 60 1m21s 1s364ms 16 60 1m16s 1s275ms 17 60 1m21s 1s355ms 18 60 1m6s 1s104ms 19 60 49s253ms 820ms 20 60 50s319ms 838ms 21 60 50s134ms 835ms 22 60 48s735ms 812ms 23 60 48s735ms 812ms 00 60 48s188ms 803ms [ User: labanimal - Total duration: 23m15s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-03-31 11:48:01 Duration: 3s587ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-03-31 11:32:01 Duration: 3s552ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-03-31 11:47:01 Duration: 3s550ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
19 509ms 3s587ms 969ms 1,440 23m15s 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 #19
Day Hour Count Duration Avg duration Mar 31 01 60 0ms 0ms 02 60 32s747ms 545ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 1m7s 1s129ms 09 60 1m 1s9ms 10 60 1m 1s10ms 11 60 38s794ms 646ms 12 60 2m1s 2s28ms 13 60 35s485ms 591ms 14 60 37s774ms 629ms 15 60 1m21s 1s364ms 16 60 1m16s 1s275ms 17 60 1m21s 1s355ms 18 60 1m6s 1s104ms 19 60 49s253ms 820ms 20 60 50s319ms 838ms 21 60 50s134ms 835ms 22 60 48s735ms 812ms 23 60 48s735ms 812ms 00 60 48s188ms 803ms [ User: labanimal - Total duration: 23m15s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-31 11:48:01 Duration: 3s587ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-31 11:32:01 Duration: 3s552ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-31 11:47:01 Duration: 3s550ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
20 572ms 1s513ms 843ms 7 5s907ms select count(distinct animal_id) AS "count" from ( select animals_search_mview.*, b.unbreeding_date, a.id as animal, user_is_tgm (animals_search_mview.owner, ?) as is_owner, user_is_tgm (animals_search_mview.editor, ?) as is_editor, user_is_tgm (animals_search_mview.tourist, ?) as is_tourist, case when not exists ( select ? from scoresheet_diary sd where sd.animals_id = animals_search_mview.id) then ? else ? end as isscored from animals_search_mview left join strains on strains.name = animals_search_mview.strain left join license_history lh on lh.anid = animals_search_mview.id left join animals a on a."animalID" = animals_search_mview.animal_id left join breedings b on b.id = animals_search_mview.last_mating) data where deleted = ? and strain ilike ? and (is_owner or is_editor or is_tourist);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 31 13 3 1s723ms 574ms 16 4 4s183ms 1s45ms [ User: labanimal - Total duration: 5s907ms - Times executed: 7 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 5s907ms - Times executed: 7 ]
-
SELECT COUNT(DISTINCT animal_id) AS "count" FROM ( SELECT animals_search_mview.*, b.unbreeding_date, a.id as animal, user_is_tgm (animals_search_mview.owner, 332) AS is_owner, user_is_tgm (animals_search_mview.editor, 332) AS is_editor, user_is_tgm (animals_search_mview.tourist, 332) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN animals a ON a."animalID" = animals_search_mview.animal_id LEFT JOIN breedings b ON b.id = animals_search_mview.last_mating) data WHERE deleted = 'f' AND strain ILIKE 'B6/J' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-03-31 15:57:17 Duration: 1s513ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
SELECT COUNT(DISTINCT animal_id) AS "count" FROM ( SELECT animals_search_mview.*, b.unbreeding_date, a.id as animal, user_is_tgm (animals_search_mview.owner, 332) AS is_owner, user_is_tgm (animals_search_mview.editor, 332) AS is_editor, user_is_tgm (animals_search_mview.tourist, 332) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN animals a ON a."animalID" = animals_search_mview.animal_id LEFT JOIN breedings b ON b.id = animals_search_mview.last_mating) data WHERE deleted = 'f' AND strain ILIKE 'B6/J' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-03-31 15:57:13 Duration: 1s498ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
-
SELECT COUNT(DISTINCT animal_id) AS "count" FROM ( SELECT animals_search_mview.*, b.unbreeding_date, a.id as animal, user_is_tgm (animals_search_mview.owner, 332) AS is_owner, user_is_tgm (animals_search_mview.editor, 332) AS is_editor, user_is_tgm (animals_search_mview.tourist, 332) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN animals a ON a."animalID" = animals_search_mview.animal_id LEFT JOIN breedings b ON b.id = animals_search_mview.last_mating) data WHERE deleted = 'f' AND strain ILIKE '%CD9%' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-03-31 15:53:13 Duration: 587ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-31_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
- 126,982 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 41 FATAL entries
- 6 ERROR entries
- 0 WARNING entries
- 586 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 483 Max number of times the same event was reported
- 633 Total events found
Rank Times reported Error 1 483 ERROR: current transaction is aborted, commands ignored until end of transaction block
Times Reported Most Frequent Error / Event #1
Day Hour Count Mar 31 00 483 - ERROR: current transaction is aborted, commands ignored until end of transaction block
- ERROR: current transaction is aborted, commands ignored until end of transaction block
- ERROR: current transaction is aborted, commands ignored until end of transaction block
Statement: SELECT p_update_genes(1, (SELECT animal_id FROM _dzhi_import_ids WHERE row_num=3), NULL, 'ZF:TL1-myl7-eGFP', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
Date: 2026-03-31 23:03:33 Database: zemm_produktiv_7 Application: psql User: deploy Remote: [local] Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
Statement: SELECT p_update_genes(1, (SELECT animal_id FROM _dzhi_import_ids WHERE row_num=4), NULL, 'ZF:TL1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
Date: 2026-03-31 23:03:33 Database: zemm_produktiv_7 Application: psql User: deploy Remote: [local] Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
Statement: SELECT p_update_genes(1, (SELECT animal_id FROM _dzhi_import_ids WHERE row_num=5), NULL, 'ZF:TL1-myl7-eGFP', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
Date: 2026-03-31 23:03:33 Database: zemm_produktiv_7 Application: psql User: deploy Remote: [local] Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
2 117 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Mar 31 01 12 04 2 08 2 12 24 21 6 22 14 23 13 00 44 - FATAL: database "monitoring" does not exist
- FATAL: database "monitoring" does not exist
- FATAL: database "monitoring" does not exist
Date: 2026-03-31 00:09:30 Database: monitoring Application: User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
Date: 2026-03-31 00:09:30 Database: monitoring Application: User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
Date: 2026-03-31 00:19:29 Database: monitoring Application: User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
3 14 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count Mar 31 01 3 18 1 20 3 23 4 00 3 - ERROR: column "name" does not exist
- ERROR: column "name" does not exist
- ERROR: column "inactive" does not exist
Statement: SELECT id, name FROM public.species ORDER BY id;
Date: 2026-03-31 00:06:33 Database: zemm_produktiv_7 Application: psql User: deploy Remote: [local] Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
Hint: Perhaps you meant to reference the column "licenses.date".
Statement: SELECT id, name, shortname, species, active, deleted FROM public.licenses ORDER BY id LIMIT 40;Date: 2026-03-31 00:06:33 Database: zemm_produktiv_7 Application: psql User: deploy Remote: [local] Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
Statement: SELECT id, description, inactive FROM public.groups WHERE description IN ('Ag Gerull','Ag Maack','Ag Ramos','Ag Hofmann','Ag Rhode','Gerull,B','Maack,C','Ramos,G','Hofmann,U','Rhode,D') ORDER BY id;
Date: 2026-03-31 00:06:51 Database: zemm_produktiv_7 Application: psql User: deploy Remote: [local] Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
4 4 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #4
Day Hour Count Mar 31 16 1 20 1 21 2 - LOG: could not receive data from client: Connection reset by peer
- LOG: could not receive data from client: Connection reset by peer
- LOG: could not receive data from client: Connection reset by peer
Date: 2026-03-31 15:12:23 Database: zemm_produktiv_7 Application: DBeaver 22.2.4 - Main 'zemm_produktiv_7' User: labanimal Remote: 94.31.109.76 Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
Date: 2026-03-31 19:45:21 Database: zemm_produktiv_7 Application: psql User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
Date: 2026-03-31 20:30:46 Database: zemm_produktiv_7 Application: DBeaver 24.3.2 - Main 'zemm_produktiv_7' User: labanimal Remote: 94.31.109.76 Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
5 3 ERROR: date/time field value out of range: "..."
Times Reported Most Frequent Error / Event #5
Day Hour Count Mar 31 12 1 16 2 - ERROR: date/time field value out of range: "2026-04-31"
- ERROR: date/time field value out of range: "2026/000/1476"
- ERROR: date/time field value out of range: "2026/000/1476"
Statement: SELECT p_update_animals(457, '10302269', NULL, NULL, NULL, false,NULL, NULL, false, NULL, '2026-04-31', NULL, 4, 'R46', 9628, NULL, false,NULL,NULL,NULL, NULL,NULL,NULL,0);
Date: 2026-03-31 11:28:05 Database: zemm_produktiv_8 Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
Hint: Perhaps you need a different "DateStyle" setting.
Statement: SELECT tk.id, tk.name, tk.active, tk.task_status, tk.done, tk.prio_agent, tk.deadline, tk.link, STRING_AGG(DISTINCT issuer_user."fullName", ';') AS issued_by, tk.time_issued, STRING_AGG(DISTINCT agent_user."fullName" ,';')AS completed_by, tk.time_completed FROM tasks tk INNER JOIN "targetgroupMembers" issuer ON issuer.targetgroup = tk.owner INNER JOIN (SELECT "targetgroupMembers".targetgroup, users.* FROM "targetgroupMembers" INNER JOIN users ON users.id = "targetgroupMembers"."user") issuer_user ON issuer_user.targetgroup = tk.owner LEFT JOIN "targetgroupMembers" agent ON agent.targetgroup = tk.agent LEFT JOIN (SELECT "targetgroupMembers".targetgroup, users.* FROM "targetgroupMembers" INNER JOIN users ON users.id = "targetgroupMembers"."user") agent_user ON agent_user.targetgroup = tk.agent WHERE (user_is_tgm(tk.owner, 10100194) OR user_is_tgm(tk.agent, 10100194)) AND tk.task_status LIKE '%' AND tk.time_issued >= '2026/000/1476' GROUP BY tk.idDate: 2026-03-31 15:25:52 Database: zemm_produktiv_8 Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
Hint: Perhaps you need a different "DateStyle" setting.
Statement: SELECT tk.id, tk.name, tk.active, tk.task_status, tk.done, tk.prio_agent, tk.deadline, tk.link, STRING_AGG(DISTINCT issuer_user."fullName", ';') AS issued_by, tk.time_issued, STRING_AGG(DISTINCT agent_user."fullName" ,';')AS completed_by, tk.time_completed FROM tasks tk INNER JOIN "targetgroupMembers" issuer ON issuer.targetgroup = tk.owner INNER JOIN (SELECT "targetgroupMembers".targetgroup, users.* FROM "targetgroupMembers" INNER JOIN users ON users.id = "targetgroupMembers"."user") issuer_user ON issuer_user.targetgroup = tk.owner LEFT JOIN "targetgroupMembers" agent ON agent.targetgroup = tk.agent LEFT JOIN (SELECT "targetgroupMembers".targetgroup, users.* FROM "targetgroupMembers" INNER JOIN users ON users.id = "targetgroupMembers"."user") agent_user ON agent_user.targetgroup = tk.agent WHERE (user_is_tgm(tk.owner, 10100194) OR user_is_tgm(tk.agent, 10100194)) AND tk.name LIKE '2026/000/1476' AND tk.task_status LIKE '%' AND tk.time_issued >= '2026/000/1476' GROUP BY tk.idDate: 2026-03-31 15:26:33 Database: zemm_produktiv_8 Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
6 2 FATAL: password authentication failed for user "..."
Times Reported Most Frequent Error / Event #6
Day Hour Count Mar 31 23 2 - FATAL: password authentication failed for user "deploy"
- FATAL: password authentication failed for user "deploy"
Detail: User "deploy" has no password assigned. Connection matched file "/etc/postgresql/18/main/pg_hba.conf" line 27: "host all all ::1/128 scram-sha-256"
Date: 2026-03-31 22:19:23 Database: zp7 Application: User: deploy Remote: ::1 Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
Detail: User "deploy" has no password assigned. Connection matched file "/etc/postgresql/18/main/pg_hba.conf" line 27: "host all all ::1/128 scram-sha-256"
Date: 2026-03-31 22:19:23 Database: zp7 Application: User: deploy Remote: ::1 Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
7 2 ERROR: "..." is not a materialized view
Times Reported Most Frequent Error / Event #7
Day Hour Count Mar 31 00 2 - ERROR: "animals_search_mview" is not a materialized view
- ERROR: "cages_search_mview" is not a materialized view
Statement: REFRESH MATERIALIZED VIEW animals_search_mview;
Date: 2026-03-31 23:03:33 Database: zemm_produktiv_7 Application: psql User: deploy Remote: [local] Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
Statement: REFRESH MATERIALIZED VIEW cages_search_mview;
Date: 2026-03-31 23:03:33 Database: zemm_produktiv_7 Application: psql User: deploy Remote: [local] Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
8 2 LOG: could not receive data from client: Connection timed out
Times Reported Most Frequent Error / Event #8
Day Hour Count Mar 31 18 2 - LOG: could not receive data from client: Connection timed out
- LOG: could not receive data from client: Connection timed out
Date: 2026-03-31 17:25:27 Database: zemm_produktiv_8 Application: DBeaver 24.3.2 - Main 'zemm_produktiv_8' User: labanimal Remote: 94.31.109.76 Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
Date: 2026-03-31 17:26:03 Database: zemm_produktiv_7 Application: DBeaver 24.3.2 - Main 'zemm_produktiv_7' User: labanimal Remote: 94.31.109.76 Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
9 1 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #9
Day Hour Count Mar 31 01 1 - ERROR: relation "wb" does not exist
Statement: SELECT 'unmatched' AS section, w.cage_name, NULL, NULL FROM wb w LEFT JOIN public.cages c ON c."cageName" = w.cage_name WHERE c.id IS NULL ORDER BY w.cage_name;
Date: 2026-03-31 00:07:54 Database: zemm_produktiv_7 Application: psql User: deploy Remote: [local] Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
10 1 FATAL: Peer authentication failed for user "..."
Times Reported Most Frequent Error / Event #10
Day Hour Count Mar 31 02 1 - FATAL: Peer authentication failed for user "ok"
Detail: Connection matched file "/etc/postgresql/18/main/pg_hba.conf" line 18: "local all all peer"
Date: 2026-03-31 01:00:53 Database: zemm_produktiv_7 Application: User: ok Remote: [local] Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
11 1 ERROR: aggregate functions are not allowed in GROUP BY
Times Reported Most Frequent Error / Event #11
Day Hour Count Mar 31 00 1 - ERROR: aggregate functions are not allowed in GROUP BY
Statement: SELECT animal, COUNT(*) as cnt FROM cost_history WHERE animal BETWEEN 10302842 AND 10303317 GROUP BY cnt ORDER BY cnt
Date: 2026-03-31 23:12:36 Database: zemm_produktiv_7 Application: psql User: deploy Remote: [local] Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
12 1 ERROR: function p_update_genes(...) does not exist
Times Reported Most Frequent Error / Event #12
Day Hour Count Mar 31 00 1 - ERROR: function p_update_genes(integer, bigint, unknown, unknown, unknown, unknown, unknown, unknown, unknown, unknown, unknown, unknown, unknown, unknown, unknown, unknown) does not exist
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT p_update_genes(1, (SELECT animal_id FROM _dzhi_import_ids WHERE row_num=2), NULL, 'ZF:TL1-myl7-eGFP', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);Date: 2026-03-31 23:03:33 Database: zemm_produktiv_7 Application: psql User: deploy Remote: [local] Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
13 1 ERROR: duplicate key value violates unique constraint "..."
Times Reported Most Frequent Error / Event #13
Day Hour Count Mar 31 10 1 - ERROR: duplicate key value violates unique constraint "metrics_timeseries_tenant_key_metric_name_bucket_start_buck_key"
Detail: Key (tenant_key, metric_name, bucket_start, bucket_width_seconds)=(prod, http_requests_total, 2026-03-31 09:35:00+02, 60) already exists.
Statement: INSERT INTO observability.metrics_timeseries (tenant_key, metric_name, bucket_start, bucket_width_seconds, sum_value, count_value, histogram) VALUES ($1, $2, $3, $4, $5, $6, $7)Date: 2026-03-31 09:35:03 Database: zemm_monitoring Application: User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv
14 1 ERROR: UNION types bigint and text cannot be matched
Times Reported Most Frequent Error / Event #14
Day Hour Count Mar 31 23 1 - ERROR: UNION types bigint and text cannot be matched
Statement: SELECT 'GROUP', g.id, g.name FROM groups g WHERE g.name ILIKE ANY(ARRAY['Ag Gerull','Ag Hofmann','Ag Maack','Ag Ramos','AG Rohde','Ag Rhode']) AND g.deleted=false UNION ALL SELECT 'USER', u.id::text, u."fullName" FROM users u WHERE u."fullName" ILIKE ANY(ARRAY['%Gerull%','%Hofmann, U%','%Maack%','%Ramos%','%Rohde%','%Rhode%']) AND u.deleted=false ORDER BY 1,3;
Date: 2026-03-31 22:43:37 Database: zemm_produktiv_7 Application: psql User: deploy Remote: [local] Log file: /var/log/postgresql/postgresql-2026-03-31_000000.csv