ZEMM PG Report-
Global information
- Generated on Thu Apr 30 06:05:31 2026
- Log file: /var/log/postgresql/postgresql-2026-03-25_000000.csv, ..., /var/log/postgresql/postgresql-2026-04-30_000000.csv
- Parsed 195,096 log entries in 5m30s
- Log start from 2026-04-02 00:00:01 to 2026-04-02 23:59:02
-
Overview
Global Stats
- 91 Number of unique normalized queries
- 18,878 Number of queries
- 18h39m28s Total query duration
- 2026-04-02 00:00:01 First query
- 2026-04-02 23:59:01 Last query
- 15 queries/s at 2026-04-02 14:21:01 Query peak
- 18h39m28s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 18h39m28s Execute total duration
- 176 Number of events
- 8 Number of unique normalized events
- 160 Max number of times the same event was reported
- 0 Number of cancellation
- 49 Total number of automatic vacuums
- 94 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 16,943 Total number of sessions
- 10 sessions at 2026-04-02 10:20:14 Session peak
- 1h16m56s Total duration of sessions
- 272ms Average duration of sessions
- 1 Average queries per session
- 3s964ms Average queries duration per session
- 0ms Average idle time per session
- 17,103 Total number of connections
- 43 connections/s at 2026-04-02 13:46:52 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 15 queries/s Query Peak
- 2026-04-02 14:21:01 Date
SELECT Traffic
Key values
- 2 queries/s Query Peak
- 2026-04-02 14:21:01 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 13 queries/s Query Peak
- 2026-04-02 09:04:01 Date
Queries duration
Key values
- 18h39m28s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Apr 02 00 780 0ms 0ms 0ms 0ms 0ms 0ms 01 781 0ms 1s22ms 494ms 13s289ms 13s289ms 13s289ms 02 780 1s22ms 1s22ms 1s22ms 13s289ms 13s289ms 13s289ms 03 780 1s22ms 1s22ms 1s22ms 13s289ms 13s289ms 13s289ms 04 780 1s22ms 1s22ms 1s22ms 13s289ms 13s289ms 13s289ms 05 780 1s22ms 1s22ms 1s22ms 13s289ms 13s289ms 13s289ms 06 812 508ms 1s824ms 854ms 15s855ms 17s728ms 21s183ms 07 815 515ms 25s401ms 2s742ms 33s483ms 6m41s 7m31s 08 799 508ms 3s284ms 1s311ms 42s692ms 42s692ms 45s313ms 09 792 508ms 1s315ms 721ms 16s126ms 17s95ms 18s674ms 10 795 511ms 1m23s 40s516ms 17m29s 17m29s 19m32s 11 786 656ms 1m20s 24s500ms 17m29s 17m29s 17m30s 12 786 661ms 1s808ms 803ms 13s859ms 15s663ms 24s578ms 13 803 528ms 6s714ms 1s219ms 19s42ms 19s652ms 33s689ms 14 784 572ms 1s468ms 879ms 13s886ms 19s88ms 19s88ms 15 780 746ms 746ms 746ms 9s699ms 9s699ms 9s699ms 16 780 746ms 746ms 746ms 9s699ms 9s699ms 9s699ms 17 780 746ms 746ms 746ms 9s699ms 9s699ms 9s699ms 18 780 746ms 746ms 746ms 9s699ms 9s699ms 9s699ms 19 780 746ms 746ms 746ms 9s699ms 9s699ms 9s699ms 20 780 746ms 746ms 746ms 9s699ms 9s699ms 9s699ms 21 780 746ms 746ms 746ms 9s699ms 9s699ms 9s699ms 22 780 746ms 746ms 746ms 9s699ms 9s699ms 9s699ms 23 785 544ms 1s975ms 789ms 9s699ms 17s560ms 17s560ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Apr 02 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 32 0 933ms 1s332ms 1s827ms 3s396ms 07 0 16 2s815ms 0ms 0ms 19s363ms 08 15 0 1s156ms 0ms 1s748ms 2s829ms 09 12 0 834ms 0ms 1s240ms 1s579ms 10 13 0 28s202ms 0ms 1s817ms 1m25s 11 6 0 770ms 0ms 0ms 1s370ms 12 6 0 1s10ms 0ms 0ms 1s803ms 13 8 8 1s920ms 0ms 758ms 2s535ms 14 4 0 1s25ms 0ms 0ms 2s41ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 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 0 5 1s286ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Apr 02 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 1 0 0 1s22ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Apr 02 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Apr 02 00 244 0.07/s 01 253 0.07/s 02 244 0.07/s 03 250 0.07/s 04 244 0.07/s 05 376 0.10/s 06 1,934 0.54/s 07 1,279 0.36/s 08 1,464 0.41/s 09 1,797 0.50/s 10 1,402 0.39/s 11 1,123 0.31/s 12 1,153 0.32/s 13 1,159 0.32/s 14 1,188 0.33/s 15 541 0.15/s 16 477 0.13/s 17 268 0.07/s 18 257 0.07/s 19 247 0.07/s 20 304 0.08/s 21 244 0.07/s 22 244 0.07/s 23 411 0.11/s Day Hour Count Average Duration Average idle time Apr 02 00 244 308ms 308ms 01 249 304ms 0ms 02 244 308ms 0ms 03 248 304ms 0ms 04 244 307ms 0ms 05 375 259ms 0ms 06 1,929 181ms 0ms 07 1,266 385ms 0ms 08 1,439 199ms 0ms 09 1,795 168ms 0ms 10 1,404 730ms 0ms 11 1,032 160ms 0ms 12 1,135 170ms 0ms 13 1,159 264ms 0ms 14 1,188 167ms 0ms 15 541 187ms 0ms 16 477 204ms 0ms 17 267 288ms 0ms 18 257 306ms 0ms 19 247 346ms 0ms 20 304 319ms 0ms 21 244 348ms 0ms 22 244 348ms 0ms 23 411 282ms 0ms -
Connections
Established Connections
Key values
- 43 connections Connection Peak
- 2026-04-02 13:46:52 Date
Connections per database
Key values
- zemm_monitoring Main Database
- 17,103 connections Total
Connections per user
Key values
- labanimal Main User
- 17,103 connections Total
-
Sessions
Simultaneous sessions
Key values
- 10 sessions Session Peak
- 2026-04-02 10:20:14 Date
Histogram of session times
Key values
- 14,834 0-500ms duration
Sessions per database
Key values
- zemm_monitoring Main Database
- 16,943 sessions Total
Sessions per user
Key values
- labanimal Main User
- 16,943 sessions Total
Sessions per host
Key values
- ::1 Main Host
- 16,943 sessions Total
Sessions per application
Key values
- Main Application
- 16,943 sessions Total
Application Count Total Duration Average Duration 13,482 49m24s 219ms _backend_wean_api.php_litter_id_10131563_zemm_produktiv_8_local 20 2s772ms 138ms _backend_wean_api.php_litter_id_10131670_zemm_produktiv_8_local 20 2s792ms 139ms _backend_wean_api.php_litter_id_10131687_zemm_produktiv_8_local 36 4s995ms 138ms _backend_wean_api.php_litter_id_10131689_zemm_produktiv_8_local 35 4s885ms 139ms _backend_wean_api.php_litter_id_10131690_zemm_produktiv_8_local 35 4s912ms 140ms _backend_wean_api.php_litter_id_10131699_zemm_produktiv_8_local 12 1s681ms 140ms _backend_wean_api.php_litter_id_10131700_zemm_produktiv_8_local 35 4s904ms 140ms _backend_wean_api.php_litter_id_10131702_zemm_produktiv_8_local 35 4s881ms 139ms _backend_wean_api.php_litter_id_10131707_zemm_produktiv_8_local 3 427ms 142ms _backend_wean_api.php_litter_id_10131708_zemm_produktiv_8_local 5 704ms 140ms _backend_wean_api.php_litter_id_10131710_zemm_produktiv_8_local 2 280ms 140ms _backend_wean_api.php_litter_id_10131726_zemm_produktiv_8_local 4 564ms 141ms _backend_wean_api.php_litter_id_10131727_zemm_produktiv_8_local 2 278ms 139ms _backend_wean_api.php_litter_id_10131728_zemm_produktiv_8_local 3 421ms 140ms _backend_wean_api.php_litter_id_10131729_zemm_produktiv_8_local 4 550ms 137ms _backend_wean_api.php_litter_id_10131732_zemm_produktiv_8_local 2 280ms 140ms _backend_wean_api.php_litter_id_10131752_zemm_produktiv_8_local 20 2s794ms 139ms _backend_wean_api.php_litter_id_10131753_zemm_produktiv_8_local 20 2s782ms 139ms _backend_wean_api.php_litter_id_10131754_zemm_produktiv_8_local 20 2s790ms 139ms _backend_wean_api.php_litter_id_10131756_zemm_produktiv_8_local 2 280ms 140ms _backend_wean_api.php_litter_id_10131758_zemm_produktiv_8_local 20 2s809ms 140ms _backend_wean_api.php_litter_id_10131761_zemm_produktiv_8_local 20 2s812ms 140ms _backend_wean_api.php_litter_id_10131762_zemm_produktiv_8_local 20 2s787ms 139ms _backend_wean_api.php_litter_id_10131765_zemm_produktiv_8_local 20 2s803ms 140ms _backend_wean_api.php_litter_id_10131769_zemm_produktiv_8_local 2 284ms 142ms _backend_wean_api.php_litter_id_10131770_zemm_produktiv_8_local 2 282ms 141ms _backend_wean_api.php_litter_id_10131771_zemm_produktiv_8_local 2 275ms 137ms _backend_wean_api.php_litter_id_10131772_zemm_produktiv_8_local 2 281ms 140ms _backend_wean_api.php_litter_id_10131773_zemm_produktiv_8_local 2 281ms 140ms _backend_wean_api.php_litter_id_10131774_zemm_produktiv_8_local 2 281ms 140ms _backend_wean_api.php_litter_id_10131775_zemm_produktiv_8_local 2 285ms 142ms _backend_wean_api.php_litter_id_10131777_zemm_produktiv_8_local 2 283ms 141ms _backend_wean_api.php_litter_id_10131779_zemm_produktiv_8_local 2 273ms 136ms _backend_wean_api.php_litter_id_10131782_zemm_produktiv_8_local 10 1s386ms 138ms _backend_wean_api.php_litter_id_10131783_zemm_produktiv_8_local 10 1s406ms 140ms _backend_wean_api.php_litter_id_10131791_zemm_produktiv_8_local 35 4s892ms 139ms _backend_wean_api.php_litter_id_10131796_zemm_produktiv_8_local 35 4s877ms 139ms _backend_wean_api.php_litter_id_10131797_zemm_produktiv_8_local 35 4s874ms 139ms _backend_wean_api.php_litter_id_10131798_zemm_produktiv_8_local 35 4s891ms 139ms _backend_wean_api.php_litter_id_10131839_zemm_produktiv_8_local 3 424ms 141ms _backend_wean_api.php_litter_id_10131845_zemm_produktiv_8_local 3 425ms 141ms _backend_wean_api.php_litter_id_10131846_zemm_produktiv_8_local 2 277ms 138ms _backend_wean_api.php_litter_id_10131866_zemm_produktiv_8_local 2 282ms 141ms _backend_wean_api.php_litter_id_10131882_zemm_produktiv_8_local 35 4s891ms 139ms _backend_wean_api.php_litter_id_10131993_zemm_produktiv_8_local 1 140ms 140ms _backend_wean_api.php_litter_id_10131998_zemm_produktiv_8_local 1 142ms 142ms _backend_wean_api.php_litter_id_10132009_zemm_produktiv_8_local 2 279ms 139ms _backend_wean_api.php_litter_id_10132010_zemm_produktiv_8_local 2 279ms 139ms _backend_wean_api.php_litter_id_10132018_zemm_produktiv_8_local 1 130ms 130ms _backend_wean_api.php_litter_id_10132019_zemm_produktiv_8_local 3 424ms 141ms _desktop__zemm_produktiv_8_localhost_5432 15 1s221ms 81ms _desktop_index.php_breeding__25_sex__25_in_breeding__25_fate_5_ 2 89ms 44ms _desktop_index.php_cages_name_A15.415-1_2A_cages_empty__25_val4 1 323ms 323ms _desktop_index.php_cages_name_A15.415_2A_cages_empty__25_val4_c 2 1s925ms 962ms _desktop_index.php_cages_name_A15_2A_cages_empty__25_val4_cages 3 4s403ms 1s467ms _desktop_index.php_command_animals_edit_subcommand_init_id_1027 1 119ms 119ms _desktop_index.php_command_animals_edit_subcommand_init_id_1028 2 223ms 111ms _desktop_index.php_command_animals_edit_subcommand_init_id_1029 1 116ms 116ms _desktop_index.php_command_animals_edit_subcommand_init_id_1030 2 238ms 119ms _desktop_index.php_command_animals_litters_create_subcommand_se 2 351ms 175ms _desktop_index.php_command_animals_subcommand_init_zemm_produkt 2 93ms 46ms _desktop_index.php_command_cages_edit_subcommand_init_id_101014 1 74ms 74ms _desktop_index.php_command_facility_subcommand_init_zemm_produk 1 45ms 45ms _desktop_index.php_command_login_subcommand_init_zemm_produktiv 178 5s511ms 30ms _desktop_index.php_command_reports_subcommand_animals_per_room_ 7 901ms 128ms _desktop_index.php_command_reports_subcommand_animals_per_user_ 9 1s16ms 112ms _desktop_index.php_command_reports_subcommand_cage_utilisation_ 1 116ms 116ms _desktop_index.php_command_reports_subcommand_fates_zemm_produk 1 109ms 109ms _desktop_index.php_command_reports_subcommand_init_zemm_produkt 1 271ms 271ms _desktop_index.php_command_reports_subcommand_scoresheet_per_li 1 883ms 883ms _desktop_index.php_command_reports_subcommand_task_status_zemm_ 2 232ms 116ms _desktop_index.php_command_tasks_subcommand_edit_id_10141374_ze 1 81ms 81ms _desktop_index.php_command_tasks_subcommand_edit_id_10141607_ze 1 76ms 76ms _desktop_index.php_command_tasks_subcommand_edit_id_10141943_ze 1 87ms 87ms _desktop_index.php_command_tasks_subcommand_edit_id_10141945_ze 1 82ms 82ms _desktop_index.php_command_tasks_subcommand_edit_id_10141953_ze 1 82ms 82ms _desktop_index.php_command_tasks_subcommand_edit_id_10142050_ze 1 85ms 85ms _desktop_index.php_command_tasks_subcommand_edit_id_10142052_ze 2 158ms 79ms _desktop_index.php_command_tasks_subcommand_edit_id_10142053_ze 1 81ms 81ms _desktop_index.php_command_tasks_subcommand_open_zemm_produktiv 44 4s171ms 94ms _desktop_index.php_id_0_command_licences_subcommand_init_zemm_p 1 49ms 49ms _desktop_index.php_lic_filter_1_command_facility_subcommand_ini 1 47ms 47ms _desktop_index.php_lic_filter_1_command_licences_subcommand_sel 1 48ms 48ms _desktop_index.php_m_action_animals_edit_3Alink_init_row_animal 1 107ms 107ms _desktop_index.php_name_Neue_20Aufgabe_instructions_Bitte_20bei 2 132ms 66ms _desktop_index.php_name_Tiertransport_20durch_20das_20ZEMM_20-_ 5 341ms 68ms _desktop_index.php_search_name_Verpaarungen_20f_C3_BCr_20Versuc 2 296ms 148ms _desktop_index.php_search_status_2_no_subtasks_true_command_cag 1 44ms 44ms _desktop_index.php_search_status__25_issuer_user_name_Cuenca_20 4 297ms 74ms _desktop_index.php_view_animal_name_on_view_animal_id_on_view_b 25 8s779ms 351ms _desktop_index.php_zemm_produktiv_7_localhost_5432 58 12s939ms 223ms _desktop_index.php_zemm_produktiv_8_localhost_5432 2,188 8m31s 233ms backend:zemm_produktiv_8@localhost 47 4s823ms 102ms expire_tasks:zemm_produktiv_8@h2940066.stratoserver.net:5432 1 1s45ms 1s45ms pg_dump 4 1m31s 22s991ms psql 156 15m 5s772ms taskscron:zemm_produktiv_7@zemm.fbiscience.eu 24 624ms 26ms taskscron:zemm_produktiv_8@h2940066.stratoserver.net:5432 24 7s2ms 291ms -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 18,587 buffers Checkpoint Peak
- 2026-04-02 01:35:06 Date
- 270.020 seconds Highest write time
- 0.030 seconds Sync time
Checkpoints Wal files
Key values
- 7 files Wal files usage Peak
- 2026-04-02 01:35:06 Date
Checkpoints distance
Key values
- 212.65 Mo Distance Peak
- 2026-04-02 01:35:06 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Apr 02 00 2,097 210.345s 0.072s 210.473s 01 20,459 457.766s 0.074s 457.892s 02 2,339 234.58s 0.074s 234.703s 03 2,114 212.02s 0.069s 212.143s 04 2,094 210.029s 0.073s 210.155s 05 3,426 343.412s 0.096s 343.564s 06 5,425 543.247s 0.201s 543.499s 07 12,744 966.048s 0.167s 966.274s 08 46,317 1,323.316s 0.204s 1,323.584s 09 5,119 512.555s 0.213s 512.819s 10 6,713 672.304s 0.208s 672.569s 11 3,931 393.907s 0.18s 394.14s 12 5,312 532.462s 0.178s 532.693s 13 13,887 1,093.069s 0.184s 1,093.314s 14 7,916 662.933s 0.156s 663.135s 15 3,528 353.784s 0.129s 353.963s 16 2,581 258.884s 0.116s 259.055s 17 2,400 240.724s 0.105s 240.877s 18 2,518 252.45s 0.096s 252.597s 19 2,203 220.983s 0.092s 221.126s 20 5,031 472.88s 0.079s 473.016s 21 2,377 238.393s 0.08s 238.529s 22 2,407 241.392s 0.083s 241.53s 23 3,761 376.685s 0.076s 376.812s Day Hour Added Removed Recycled Synced files Longest sync Average sync Apr 02 00 0 0 1 342 0.001s 0.012s 01 0 0 7 336 0.005s 0.011s 02 0 0 1 349 0.002s 0.012s 03 0 0 0 343 0.002s 0.012s 04 0 0 1 343 0.001s 0.012s 05 0 0 2 442 0.002s 0.012s 06 0 0 1 1,092 0.002s 0.012s 07 0 0 4 856 0.002s 0.012s 08 0 0 16 1,070 0.002s 0.011s 09 0 0 2 1,150 0.004s 0.012s 10 0 0 2 1,166 0.003s 0.012s 11 0 0 1 845 0.007s 0.012s 12 0 0 1 966 0.002s 0.012s 13 0 0 5 948 0.005s 0.012s 14 0 0 1 813 0.002s 0.011s 15 0 0 1 585 0.003s 0.012s 16 0 0 1 530 0.002s 0.012s 17 0 0 1 449 0.002s 0.012s 18 0 0 1 406 0.002s 0.012s 19 0 0 1 361 0.002s 0.012s 20 0 0 1 326 0.002s 0.011s 21 0 0 1 359 0.002s 0.012s 22 0 0 1 353 0.002s 0.012s 23 0 0 1 372 0.002s 0.012s Day Hour Count Avg time (sec) Apr 02 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Apr 02 00 1,050.83 kB 1,710.75 kB 01 10,935.45 kB 41,352.18 kB 02 1,100.67 kB 39,181.17 kB 03 1,060.83 kB 11,839.42 kB 04 1,057.08 kB 4,102.83 kB 05 2,003.00 kB 4,264.83 kB 06 2,259.92 kB 3,952.92 kB 07 5,285.17 kB 15,291.50 kB 08 23,392.27 kB 58,037.27 kB 09 2,218.50 kB 28,476.92 kB 10 2,782.00 kB 10,007.75 kB 11 1,677.67 kB 4,250.42 kB 12 2,209.67 kB 3,279.17 kB 13 5,787.67 kB 10,636.08 kB 14 2,630.09 kB 11,076.18 kB 15 1,414.00 kB 4,586.25 kB 16 1,158.42 kB 2,206.67 kB 17 1,123.67 kB 1,452.50 kB 18 1,129.50 kB 1,341.25 kB 19 1,051.50 kB 1,310.67 kB 20 1,942.36 kB 3,278.64 kB 21 1,090.58 kB 4,913.58 kB 22 1,091.33 kB 2,165.42 kB 23 1,461.42 kB 3,185.75 kB -
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Apr 02 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 1.45 sec Highest CPU-cost vacuum
Table public.cost_history
Database zemm_produktiv_8 - 2026-04-02 13:41:50 Date
- 0 sec Highest CPU-cost analyze
Table
Database zemm_produktiv_8 - Date
Average Autovacuum Duration
Key values
- 1.45 sec Highest CPU-cost vacuum
Table public.cost_history
Database zemm_produktiv_8 - 2026-04-02 13:41:50 Date
Analyzes per table
Key values
- pg_catalog.pg_type (25) Main table analyzed (database zemm_produktiv_8)
- 94 analyzes Total
Table Number of analyzes zemm_produktiv_8.pg_catalog.pg_type 25 zemm_produktiv_8.pg_catalog.pg_attribute 19 zemm_produktiv_8.pg_catalog.pg_class 13 zemm_produktiv_8.pg_catalog.pg_depend 12 zemm_produktiv_8.public.breedingssires 6 zemm_produktiv_8.public.breedingsdams 5 zemm_produktiv_8.public.cages_search_mview 2 zemm_monitoring.observability.metrics_timeseries 2 zemm_produktiv_8.public.cost_history 1 invdb.pg_catalog.pg_shdepend 1 zemm_monitoring.observability.app_events 1 zemm_monitoring.pg_catalog.pg_shdepend 1 zemm_produktiv_7.pg_catalog.pg_attribute 1 zemm_produktiv_8.public.tasks 1 zemm_produktiv_8.public.users 1 zemm_produktiv_8.public.tmptasks 1 template0.pg_catalog.pg_shdepend 1 zemm_produktiv_8.pg_catalog.pg_shdepend 1 Total 94 Vacuums per table
Key values
- pg_catalog.pg_type (9) Main table vacuumed on database zemm_produktiv_8
- 49 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 9 9 0 0 0 0 0 468 121 108,998 0 0 zemm_produktiv_8.pg_catalog.pg_attribute 7 7 0 0 0 0 0 933 326 219,768 0 0 zemm_monitoring.pg_toast.pg_toast_67431 6 0 0 0 0 0 0 4,294 1,441 3,274,396 1,413 8,478 zemm_produktiv_8.public.breedingssires 6 0 0 0 0 0 0 888 24 56,352 0 0 zemm_produktiv_8.public.breedingsdams 5 0 0 0 0 0 0 990 20 61,710 0 0 zemm_produktiv_8.pg_catalog.pg_class 4 4 0 0 0 0 0 393 132 155,871 0 0 zemm_produktiv_8.pg_catalog.pg_depend 3 3 0 0 0 0 0 360 110 112,439 0 0 zemm_produktiv_8.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 406 110 599,251 28 99 fbi_ci_db.pg_catalog.pg_shdepend 2 2 0 0 0 0 0 204 71 137,314 1 127 zemm_produktiv_8.public.cost_history 1 1 0 0 0 0 0 9,809 5,248 12,542,674 364 10,006 zemm_produktiv_8.pg_catalog.pg_statistic 1 1 0 0 0 0 0 208 63 195,621 34 90 zemm_monitoring.observability.metrics_timeseries 1 1 0 0 0 0 0 8,997 3,868 8,038,925 815 16,383 zemm_monitoring.pg_toast.pg_toast_67411 1 0 0 0 0 0 0 4,082 1,099 8,543,144 1,095 4,380 zemm_produktiv_8.public.tasks 1 1 0 0 0 0 0 48,416 70 3,715,282 4 6 Total 49 31 0 0 0 0 0 80,448 12,703 37,761,745 3,754 39,569 Vacuum throughput per table
Key values
- public.cost_history (1.45) Max CPU elapsed for vacuum on database zemm_produktiv_8
- public.cost_history (21.965 ms) Max I/O read time for vacuum on database zemm_produktiv_8
- public.cost_history (2.401 ms) Max I/O write time for vacuum on database zemm_produktiv_8
I/O timing (ms) CPU (s) Table read write elapsed zemm_produktiv_8.pg_catalog.pg_type 0 0 0 zemm_produktiv_8.pg_catalog.pg_attribute 0 0 0.07 zemm_monitoring.pg_toast.pg_toast_67431 0 0 0.31 zemm_produktiv_8.public.breedingssires 0 0.149 0 zemm_produktiv_8.public.breedingsdams 0 0.086 0 zemm_produktiv_8.pg_catalog.pg_class 0 0 0.01 zemm_produktiv_8.pg_catalog.pg_depend 0 0 0.02 zemm_produktiv_8.pg_toast.pg_toast_2619 0 0 0.02 fbi_ci_db.pg_catalog.pg_shdepend 0 0 0.02 zemm_produktiv_8.public.cost_history 21.965 2.401 1.45 zemm_produktiv_8.pg_catalog.pg_statistic 0 0 0.01 zemm_monitoring.observability.metrics_timeseries 5.756 0.87 1.2 zemm_monitoring.pg_toast.pg_toast_67411 0.95 0 0.29 zemm_produktiv_8.public.tasks 0 0 0.63 Total 28.671 3.506 4.03 Tuples removed per table
Key values
- public.tasks (53505) Main table with removed tuples on database zemm_produktiv_8
- 107816 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain zemm_produktiv_8.public.tasks 1 1 53,505 56,644 0 0 16,661 zemm_monitoring.observability.metrics_timeseries 1 1 32,338 285,535 0 0 6,155 zemm_produktiv_8.public.cost_history 1 1 8,479 668,987 0 0 11,117 zemm_produktiv_8.pg_catalog.pg_attribute 7 7 7,102 39,770 0 0 1,288 zemm_produktiv_8.pg_catalog.pg_depend 3 3 2,597 12,513 0 0 165 zemm_produktiv_8.pg_catalog.pg_type 9 9 1,776 7,479 0 0 279 fbi_ci_db.pg_catalog.pg_shdepend 2 2 909 7,698 0 0 76 zemm_produktiv_8.pg_catalog.pg_class 4 4 632 3,576 0 0 168 zemm_produktiv_8.pg_catalog.pg_statistic 1 1 266 1,271 0 0 144 zemm_produktiv_8.pg_toast.pg_toast_2619 2 2 212 584 0 0 212 zemm_produktiv_8.public.breedingsdams 5 0 0 151,924 0 0 970 zemm_monitoring.pg_toast.pg_toast_67431 6 0 0 1,656,546 0 0 277,117 zemm_monitoring.pg_toast.pg_toast_67411 1 0 0 69,265 0 0 16,664 zemm_produktiv_8.public.breedingssires 6 0 0 134,932 0 0 864 Total 49 31 107,816 3,096,724 0 0 331,880 Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Pages removed per tables
NO DATASET
Table Number of vacuums Index scans Tuples removed Pages removed zemm_produktiv_8.public.breedingsdams 5 0 0 0 zemm_produktiv_8.public.cost_history 1 1 8479 0 zemm_produktiv_8.pg_catalog.pg_depend 3 3 2597 0 zemm_produktiv_8.pg_toast.pg_toast_2619 2 2 212 0 zemm_produktiv_8.pg_catalog.pg_attribute 7 7 7102 0 zemm_produktiv_8.pg_catalog.pg_statistic 1 1 266 0 fbi_ci_db.pg_catalog.pg_shdepend 2 2 909 0 zemm_monitoring.pg_toast.pg_toast_67431 6 0 0 0 zemm_produktiv_8.pg_catalog.pg_type 9 9 1776 0 zemm_produktiv_8.pg_catalog.pg_class 4 4 632 0 zemm_monitoring.observability.metrics_timeseries 1 1 32338 0 zemm_monitoring.pg_toast.pg_toast_67411 1 0 0 0 zemm_produktiv_8.public.tasks 1 1 53505 0 zemm_produktiv_8.public.breedingssires 6 0 0 0 Total 49 31 107,816 0 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Apr 02 00 0 0 01 1 1 02 1 0 03 0 0 04 0 0 05 0 0 06 7 18 07 2 6 08 17 20 09 2 12 10 4 9 11 2 6 12 3 5 13 3 4 14 3 6 15 0 1 16 2 4 17 0 0 18 1 1 19 0 0 20 0 0 21 0 1 22 1 0 23 0 0 - 1.45 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
- 96 Total read queries
- 18,776 Total write queries
Queries by database
Key values
- zemm_monitoring Main database
- 18,720 Requests
- 18h22m34s (zemm_monitoring)
- Main time consuming database
Queries by user
Key values
- labanimal Main user
- 188,188 Requests
User Request type Count Duration deploy Total 48 14m17s cte 4 1m18s ddl 27 4m22s others 2 1s624ms select 9 6m3s labanimal Total 188,188 4d3h6m22s copy from 8 18s286ms copy to 64 2m58s cte 103 2m39s ddl 187,034 4d2h41m30s others 164 1m26s select 792 17m4s tcl 2 1s129ms update 10 10s737ms postgres Total 50 1m4s copy to 50 1m4s Duration by user
Key values
- 4d3h6m22s (labanimal) Main time consuming user
User Request type Count Duration deploy Total 48 14m17s cte 4 1m18s ddl 27 4m22s others 2 1s624ms select 9 6m3s labanimal Total 188,188 4d3h6m22s copy from 8 18s286ms copy to 64 2m58s cte 103 2m39s ddl 187,034 4d2h41m30s others 164 1m26s select 792 17m4s tcl 2 1s129ms update 10 10s737ms postgres Total 50 1m4s copy to 50 1m4s Queries by host
Key values
- unknown Main host
- 188,177 Requests
- 4d3h3m15s (unknown)
- Main time consuming host
Host Request type Count Duration 81.169.238.237 Total 11 3m7s select 1 2m56s update 10 10s737ms [local] Total 98 15m21s copy to 50 1m4s cte 4 1m18s ddl 27 4m22s others 2 1s624ms select 9 6m3s unknown Total 188,177 4d3h3m15s copy from 8 18s286ms copy to 64 2m58s cte 103 2m39s ddl 187,034 4d2h41m30s others 164 1m26s select 791 14m7s tcl 2 1s129ms Queries by application
Key values
- unknown Main application
- 18,720 Requests
- 18h22m34s (unknown)
- Main time consuming application
Application Request type Count Duration _desktop_index.php_zemm_produktiv_7_localhost_5432 Total 4 3s199ms select 4 3s199ms _desktop_index.php_zemm_produktiv_8_localhost_5432 Total 87 1m26s cte 4 6s549ms select 83 1m20s expire_tasks:zemm_produktiv_8@h2940066.stratoserver.net:5432 Total 1 1s22ms update 1 1s22ms pg_dump Total 29 1m13s copy to 29 1m13s psql Total 37 14m8s cte 4 1m18s ddl 18 4m15s select 9 6m3s unknown Total 18,720 18h22m34s ddl 18,720 18h22m34s Number of cancelled queries
Key values
- 1 per second Cancelled query Peak
- 2026-04-02 10:32:30 Date
Number of cancelled queries (5 minutes period)
NO DATASET
Queries generating the most cancellation (N)
Rank Count Query 1 1 with recent_users as ( select distinct on (lt."user") lt."user" as user_id, max(lt.timestamp) over (partition by lt."user") as last_seen from login_tracker lt join users u on u.id = lt."user" where lt.timestamp >= now() - interval ? and coalesce(u.deleted, false) = false order by lt."user", max(lt.timestamp) over (partition by lt."user") desc ), top_users as ( select user_id, last_seen from recent_users order by last_seen desc limit ? ) select tu.user_id, to_char(tu.last_seen, ?) as last_seen, min(u.role) as role, count(*) filter (where a.comments ilike ? and animal_readable (a.id, tu.user_id)) as readable_contains, count(*) filter (where a.comments like ? and animal_readable (a.id, tu.user_id)) as readable_bracket from top_users tu join users u on u.id = tu.user_id join animals a on true group by tu.user_id, tu.last_seen order by tu.last_seen desc; -
Top Queries
Histogram of query times
Key values
- 66 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 1m23s SELECT count(*) FILTER (WHERE comments LIKE '%[DZHI-IMPORT-v1 row%' AND animal_readable (id, 10100134)) AS u10100134_ui_contains, count(*) FILTER (WHERE comments LIKE '[%' AND animal_readable (id, 10100134)) AS u10100134_ui_bracket, count(*) FILTER (WHERE comments LIKE '%[DZHI-IMPORT-v1 row%' AND animal_readable (id, 10100205)) AS u10100205_ui_contains, count(*) FILTER (WHERE comments LIKE '[%' AND animal_readable (id, 10100205)) AS u10100205_ui_bracket FROM animals;[ Date: 2026-04-02 10:32:11 - Database: zemm_produktiv_7 - User: deploy - Remote: [local] - Application: psql ]
2 1m23s CREATE SCHEMA IF NOT EXISTS observability;[ Date: 2026-04-02 10:33:01 - Database: zemm_monitoring - User: labanimal ]
3 1m23s CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );[ Date: 2026-04-02 10:33:01 - Database: zemm_monitoring - User: labanimal ]
4 1m23s CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);[ Date: 2026-04-02 10:33:01 - Database: zemm_monitoring - User: labanimal ]
5 1m23s CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);[ Date: 2026-04-02 10:33:01 - Database: zemm_monitoring - User: labanimal ]
6 1m23s CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );[ Date: 2026-04-02 10:33:01 - Database: zemm_monitoring - User: labanimal ]
7 1m23s CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);[ Date: 2026-04-02 10:33:01 - Database: zemm_monitoring - User: labanimal ]
8 1m23s CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);[ Date: 2026-04-02 10:33:01 - Database: zemm_monitoring - User: labanimal ]
9 1m23s CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );[ Date: 2026-04-02 10:33:01 - Database: zemm_monitoring - User: labanimal ]
10 1m23s CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);[ Date: 2026-04-02 10:33:01 - Database: zemm_monitoring - User: labanimal ]
11 1m23s CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );[ Date: 2026-04-02 10:33:01 - Database: zemm_monitoring - User: labanimal ]
12 1m23s CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );[ Date: 2026-04-02 10:33:01 - Database: zemm_monitoring - User: labanimal ]
13 1m23s CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );[ Date: 2026-04-02 10:33:01 - Database: zemm_monitoring - User: labanimal ]
14 1m23s CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );[ Date: 2026-04-02 10:33:01 - Database: zemm_monitoring - User: labanimal ]
15 1m20s SELECT count(*) FILTER (WHERE comments LIKE '%[DZHI-IMPORT-v1 row%' AND animal_readable (id, 10100134)) AS u10100134_ui_contains, count(*) FILTER (WHERE comments LIKE '[%' AND animal_readable (id, 10100134)) AS u10100134_ui_bracket, count(*) FILTER (WHERE comments LIKE '%[DZHI-IMPORT-v1 row%' AND animal_readable (id, 10100205)) AS u10100205_ui_contains, count(*) FILTER (WHERE comments LIKE '[%' AND animal_readable (id, 10100205)) AS u10100205_ui_bracket FROM animals;[ Date: 2026-04-02 10:33:07 - Database: zemm_produktiv_7 - User: deploy - Remote: [local] - Application: psql ]
16 1m20s CREATE SCHEMA IF NOT EXISTS observability;[ Date: 2026-04-02 10:34:01 - Database: zemm_monitoring - User: labanimal ]
17 1m20s CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );[ Date: 2026-04-02 10:34:01 - Database: zemm_monitoring - User: labanimal ]
18 1m20s CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);[ Date: 2026-04-02 10:34:01 - Database: zemm_monitoring - User: labanimal ]
19 1m20s CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);[ Date: 2026-04-02 10:34:01 - Database: zemm_monitoring - User: labanimal ]
20 1m20s CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );[ Date: 2026-04-02 10:34:01 - Database: zemm_monitoring - User: labanimal ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1h24m48s 1,440 508ms 1m23s 3s533ms 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 #1
Day Hour Count Duration Avg duration Apr 02 01 60 0ms 0ms 02 60 29s646ms 494ms 03 60 1m1s 1s22ms 04 60 1m1s 1s22ms 05 60 1m1s 1s22ms 06 60 1m1s 1s22ms 07 60 51s81ms 851ms 08 60 2m17s 2s289ms 09 60 1m18s 1s313ms 10 60 43s182ms 719ms 11 60 40m43s 40s727ms 12 60 24m40s 24s683ms 13 60 48s109ms 801ms 14 60 1m12s 1s210ms 15 60 52s729ms 878ms 16 60 44s765ms 746ms 17 60 44s765ms 746ms 18 60 44s765ms 746ms 19 60 44s765ms 746ms 20 60 44s765ms 746ms 21 60 44s765ms 746ms 22 60 44s765ms 746ms 23 60 44s765ms 746ms 00 60 47s184ms 786ms [ User: labanimal - Total duration: 1h24m48s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-02 10:33:01 Duration: 1m23s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-02 11:17:01 Duration: 1m20s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-02 10:27:01 Duration: 1m7s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
2 1h24m48s 1,440 508ms 1m23s 3s533ms 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 #2
Day Hour Count Duration Avg duration Apr 02 01 60 0ms 0ms 02 60 29s646ms 494ms 03 60 1m1s 1s22ms 04 60 1m1s 1s22ms 05 60 1m1s 1s22ms 06 60 1m1s 1s22ms 07 60 51s81ms 851ms 08 60 2m17s 2s289ms 09 60 1m18s 1s313ms 10 60 43s182ms 719ms 11 60 40m43s 40s727ms 12 60 24m40s 24s683ms 13 60 48s109ms 801ms 14 60 1m12s 1s210ms 15 60 52s729ms 878ms 16 60 44s765ms 746ms 17 60 44s765ms 746ms 18 60 44s765ms 746ms 19 60 44s765ms 746ms 20 60 44s765ms 746ms 21 60 44s765ms 746ms 22 60 44s765ms 746ms 23 60 44s765ms 746ms 00 60 47s184ms 786ms [ User: labanimal - Total duration: 1h24m48s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-04-02 10:33:01 Duration: 1m23s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-04-02 11:17:01 Duration: 1m20s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-04-02 10:27:01 Duration: 1m7s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
3 1h24m48s 1,440 508ms 1m23s 3s533ms create index if not exists idx_app_events_tenant on observability.app_events (tenant_key, occurred_at desc);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Apr 02 01 60 0ms 0ms 02 60 29s646ms 494ms 03 60 1m1s 1s22ms 04 60 1m1s 1s22ms 05 60 1m1s 1s22ms 06 60 1m1s 1s22ms 07 60 51s81ms 851ms 08 60 2m17s 2s289ms 09 60 1m18s 1s313ms 10 60 43s182ms 719ms 11 60 40m43s 40s727ms 12 60 24m40s 24s683ms 13 60 48s109ms 801ms 14 60 1m12s 1s210ms 15 60 52s729ms 878ms 16 60 44s765ms 746ms 17 60 44s765ms 746ms 18 60 44s765ms 746ms 19 60 44s765ms 746ms 20 60 44s765ms 746ms 21 60 44s765ms 746ms 22 60 44s765ms 746ms 23 60 44s765ms 746ms 00 60 47s184ms 786ms [ User: labanimal - Total duration: 1h24m48s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-04-02 10:33:01 Duration: 1m23s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-04-02 11:17:01 Duration: 1m20s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-04-02 10:27:01 Duration: 1m7s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
4 1h24m48s 1,440 508ms 1m23s 3s533ms create index if not exists idx_app_events_type on observability.app_events (event_type);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Apr 02 01 60 0ms 0ms 02 60 29s646ms 494ms 03 60 1m1s 1s22ms 04 60 1m1s 1s22ms 05 60 1m1s 1s22ms 06 60 1m1s 1s22ms 07 60 51s81ms 851ms 08 60 2m17s 2s289ms 09 60 1m18s 1s313ms 10 60 43s182ms 719ms 11 60 40m43s 40s727ms 12 60 24m40s 24s683ms 13 60 48s109ms 801ms 14 60 1m12s 1s210ms 15 60 52s729ms 878ms 16 60 44s765ms 746ms 17 60 44s765ms 746ms 18 60 44s765ms 746ms 19 60 44s765ms 746ms 20 60 44s765ms 746ms 21 60 44s765ms 746ms 22 60 44s765ms 746ms 23 60 44s765ms 746ms 00 60 47s184ms 786ms [ User: labanimal - Total duration: 1h24m48s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-04-02 10:33:01 Duration: 1m23s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-04-02 11:17:01 Duration: 1m20s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-04-02 10:27:01 Duration: 1m7s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
5 1h24m48s 1,440 508ms 1m23s 3s533ms create table if not exists observability.app_events ( id bigserial primary key, tenant_key text not null, event_type text not null, severity text not null, message text not null, payload jsonb, occurred_at timestamptz not null default now(), created_at timestamptz not null default now() );Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Apr 02 01 60 0ms 0ms 02 60 29s646ms 494ms 03 60 1m1s 1s22ms 04 60 1m1s 1s22ms 05 60 1m1s 1s22ms 06 60 1m1s 1s22ms 07 60 51s81ms 851ms 08 60 2m17s 2s289ms 09 60 1m18s 1s313ms 10 60 43s182ms 719ms 11 60 40m43s 40s727ms 12 60 24m40s 24s683ms 13 60 48s109ms 801ms 14 60 1m12s 1s210ms 15 60 52s729ms 878ms 16 60 44s765ms 746ms 17 60 44s765ms 746ms 18 60 44s765ms 746ms 19 60 44s765ms 746ms 20 60 44s765ms 746ms 21 60 44s765ms 746ms 22 60 44s765ms 746ms 23 60 44s765ms 746ms 00 60 47s184ms 786ms [ User: labanimal - Total duration: 1h24m48s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-02 10:33:01 Duration: 1m23s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-02 11:17:01 Duration: 1m20s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-02 10:27:01 Duration: 1m7s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
6 1h24m48s 1,440 508ms 1m23s 3s533ms create table if not exists observability.nginx_counters ( id bigserial primary key, payload jsonb not null, collected_at timestamptz not null default now() );Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Apr 02 01 60 0ms 0ms 02 60 29s646ms 494ms 03 60 1m1s 1s22ms 04 60 1m1s 1s22ms 05 60 1m1s 1s22ms 06 60 1m1s 1s22ms 07 60 51s81ms 851ms 08 60 2m17s 2s289ms 09 60 1m18s 1s313ms 10 60 43s182ms 719ms 11 60 40m43s 40s727ms 12 60 24m40s 24s683ms 13 60 48s109ms 801ms 14 60 1m12s 1s210ms 15 60 52s729ms 878ms 16 60 44s765ms 746ms 17 60 44s765ms 746ms 18 60 44s765ms 746ms 19 60 44s765ms 746ms 20 60 44s765ms 746ms 21 60 44s765ms 746ms 22 60 44s765ms 746ms 23 60 44s765ms 746ms 00 60 47s184ms 786ms [ User: labanimal - Total duration: 1h24m48s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-02 10:33:01 Duration: 1m23s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-02 11:17:01 Duration: 1m20s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-02 10:27:01 Duration: 1m7s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
7 1h24m48s 1,440 508ms 1m23s 3s533ms create table if not exists observability.phpfpm_counters ( id bigserial primary key, payload jsonb not null, collected_at timestamptz not null default now() );Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Apr 02 01 60 0ms 0ms 02 60 29s646ms 494ms 03 60 1m1s 1s22ms 04 60 1m1s 1s22ms 05 60 1m1s 1s22ms 06 60 1m1s 1s22ms 07 60 51s81ms 851ms 08 60 2m17s 2s289ms 09 60 1m18s 1s313ms 10 60 43s182ms 719ms 11 60 40m43s 40s727ms 12 60 24m40s 24s683ms 13 60 48s109ms 801ms 14 60 1m12s 1s210ms 15 60 52s729ms 878ms 16 60 44s765ms 746ms 17 60 44s765ms 746ms 18 60 44s765ms 746ms 19 60 44s765ms 746ms 20 60 44s765ms 746ms 21 60 44s765ms 746ms 22 60 44s765ms 746ms 23 60 44s765ms 746ms 00 60 47s184ms 786ms [ User: labanimal - Total duration: 1h24m48s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-02 10:33:01 Duration: 1m23s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-02 11:17:01 Duration: 1m20s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-02 10:27:01 Duration: 1m7s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
8 1h24m48s 1,440 508ms 1m23s 3s533ms create index if not exists idx_metrics_timeseries_bucket on observability.metrics_timeseries (bucket_start);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Apr 02 01 60 0ms 0ms 02 60 29s646ms 494ms 03 60 1m1s 1s22ms 04 60 1m1s 1s22ms 05 60 1m1s 1s22ms 06 60 1m1s 1s22ms 07 60 51s81ms 851ms 08 60 2m17s 2s289ms 09 60 1m18s 1s313ms 10 60 43s182ms 719ms 11 60 40m43s 40s727ms 12 60 24m40s 24s683ms 13 60 48s109ms 801ms 14 60 1m12s 1s210ms 15 60 52s729ms 878ms 16 60 44s765ms 746ms 17 60 44s765ms 746ms 18 60 44s765ms 746ms 19 60 44s765ms 746ms 20 60 44s765ms 746ms 21 60 44s765ms 746ms 22 60 44s765ms 746ms 23 60 44s765ms 746ms 00 60 47s184ms 786ms [ User: labanimal - Total duration: 1h24m48s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-04-02 10:33:01 Duration: 1m23s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-04-02 11:17:01 Duration: 1m20s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-04-02 10:27:01 Duration: 1m7s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
9 1h24m48s 1,440 508ms 1m23s 3s533ms 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 #9
Day Hour Count Duration Avg duration Apr 02 01 60 0ms 0ms 02 60 29s646ms 494ms 03 60 1m1s 1s22ms 04 60 1m1s 1s22ms 05 60 1m1s 1s22ms 06 60 1m1s 1s22ms 07 60 51s81ms 851ms 08 60 2m17s 2s289ms 09 60 1m18s 1s313ms 10 60 43s182ms 719ms 11 60 40m43s 40s727ms 12 60 24m40s 24s683ms 13 60 48s109ms 801ms 14 60 1m12s 1s210ms 15 60 52s729ms 878ms 16 60 44s765ms 746ms 17 60 44s765ms 746ms 18 60 44s765ms 746ms 19 60 44s765ms 746ms 20 60 44s765ms 746ms 21 60 44s765ms 746ms 22 60 44s765ms 746ms 23 60 44s765ms 746ms 00 60 47s184ms 786ms [ User: labanimal - Total duration: 1h24m48s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-02 10:33:01 Duration: 1m23s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-02 11:17:01 Duration: 1m20s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-02 10:27:01 Duration: 1m7s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
10 1h24m48s 1,440 508ms 1m23s 3s533ms 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 #10
Day Hour Count Duration Avg duration Apr 02 01 60 0ms 0ms 02 60 29s646ms 494ms 03 60 1m1s 1s22ms 04 60 1m1s 1s22ms 05 60 1m1s 1s22ms 06 60 1m1s 1s22ms 07 60 51s81ms 851ms 08 60 2m17s 2s289ms 09 60 1m18s 1s313ms 10 60 43s182ms 719ms 11 60 40m43s 40s727ms 12 60 24m40s 24s683ms 13 60 48s109ms 801ms 14 60 1m12s 1s210ms 15 60 52s729ms 878ms 16 60 44s765ms 746ms 17 60 44s765ms 746ms 18 60 44s765ms 746ms 19 60 44s765ms 746ms 20 60 44s765ms 746ms 21 60 44s765ms 746ms 22 60 44s765ms 746ms 23 60 44s765ms 746ms 00 60 47s184ms 786ms [ User: labanimal - Total duration: 1h24m48s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-02 10:33:01 Duration: 1m23s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-02 11:17:01 Duration: 1m20s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-02 10:27:01 Duration: 1m7s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
11 1h24m48s 1,440 508ms 1m23s 3s533ms create index if not exists idx_metrics_timeseries_metric on observability.metrics_timeseries (metric_name);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Apr 02 01 60 0ms 0ms 02 60 29s646ms 494ms 03 60 1m1s 1s22ms 04 60 1m1s 1s22ms 05 60 1m1s 1s22ms 06 60 1m1s 1s22ms 07 60 51s81ms 851ms 08 60 2m17s 2s289ms 09 60 1m18s 1s313ms 10 60 43s182ms 719ms 11 60 40m43s 40s727ms 12 60 24m40s 24s683ms 13 60 48s109ms 801ms 14 60 1m12s 1s210ms 15 60 52s729ms 878ms 16 60 44s765ms 746ms 17 60 44s765ms 746ms 18 60 44s765ms 746ms 19 60 44s765ms 746ms 20 60 44s765ms 746ms 21 60 44s765ms 746ms 22 60 44s765ms 746ms 23 60 44s765ms 746ms 00 60 47s184ms 786ms [ User: labanimal - Total duration: 1h24m48s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-04-02 10:33:01 Duration: 1m23s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-04-02 11:17:01 Duration: 1m20s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-04-02 10:27:01 Duration: 1m7s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
12 1h24m48s 1,440 508ms 1m23s 3s533ms 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 #12
Day Hour Count Duration Avg duration Apr 02 01 60 0ms 0ms 02 60 29s646ms 494ms 03 60 1m1s 1s22ms 04 60 1m1s 1s22ms 05 60 1m1s 1s22ms 06 60 1m1s 1s22ms 07 60 51s81ms 851ms 08 60 2m17s 2s289ms 09 60 1m18s 1s313ms 10 60 43s182ms 719ms 11 60 40m43s 40s727ms 12 60 24m40s 24s683ms 13 60 48s109ms 801ms 14 60 1m12s 1s210ms 15 60 52s729ms 878ms 16 60 44s765ms 746ms 17 60 44s765ms 746ms 18 60 44s765ms 746ms 19 60 44s765ms 746ms 20 60 44s765ms 746ms 21 60 44s765ms 746ms 22 60 44s765ms 746ms 23 60 44s765ms 746ms 00 60 47s184ms 786ms [ User: labanimal - Total duration: 1h24m48s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-04-02 10:33:01 Duration: 1m23s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-04-02 11:17:01 Duration: 1m20s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-04-02 10:27:01 Duration: 1m7s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
13 1h24m48s 1,440 508ms 1m23s 3s533ms create schema if not exists observability;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Apr 02 01 60 0ms 0ms 02 60 29s646ms 494ms 03 60 1m1s 1s22ms 04 60 1m1s 1s22ms 05 60 1m1s 1s22ms 06 60 1m1s 1s22ms 07 60 51s81ms 851ms 08 60 2m17s 2s289ms 09 60 1m18s 1s313ms 10 60 43s182ms 719ms 11 60 40m43s 40s727ms 12 60 24m40s 24s683ms 13 60 48s109ms 801ms 14 60 1m12s 1s210ms 15 60 52s729ms 878ms 16 60 44s765ms 746ms 17 60 44s765ms 746ms 18 60 44s765ms 746ms 19 60 44s765ms 746ms 20 60 44s765ms 746ms 21 60 44s765ms 746ms 22 60 44s765ms 746ms 23 60 44s765ms 746ms 00 60 47s184ms 786ms [ User: labanimal - Total duration: 1h24m48s - Times executed: 1349 ]
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-04-02 10:33:01 Duration: 1m23s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-04-02 11:17:01 Duration: 1m20s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-04-02 10:27:01 Duration: 1m7s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
14 2m44s 2 1m20s 1m23s 1m22s select count(*) filter (where comments like ? and animal_readable (id, ?)) as u10100134_ui_contains, count(*) filter (where comments like ? and animal_readable (id, ?)) as u10100134_ui_bracket, count(*) filter (where comments like ? and animal_readable (id, ?)) as u10100205_ui_contains, count(*) filter (where comments like ? and animal_readable (id, ?)) as u10100205_ui_bracket from animals;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Apr 02 11 2 2m44s 1m22s [ User: deploy - Total duration: 2m44s - Times executed: 2 ]
[ Application: psql - Total duration: 2m44s - Times executed: 2 ]
-
SELECT count(*) FILTER (WHERE comments LIKE '%[DZHI-IMPORT-v1 row%' AND animal_readable (id, 10100134)) AS u10100134_ui_contains, count(*) FILTER (WHERE comments LIKE '[%' AND animal_readable (id, 10100134)) AS u10100134_ui_bracket, count(*) FILTER (WHERE comments LIKE '%[DZHI-IMPORT-v1 row%' AND animal_readable (id, 10100205)) AS u10100205_ui_contains, count(*) FILTER (WHERE comments LIKE '[%' AND animal_readable (id, 10100205)) AS u10100205_ui_bracket FROM animals;
Date: 2026-04-02 10:32:11 Duration: 1m23s Database: zemm_produktiv_7 User: deploy Remote: [local] Application: psql Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
SELECT count(*) FILTER (WHERE comments LIKE '%[DZHI-IMPORT-v1 row%' AND animal_readable (id, 10100134)) AS u10100134_ui_contains, count(*) FILTER (WHERE comments LIKE '[%' AND animal_readable (id, 10100134)) AS u10100134_ui_bracket, count(*) FILTER (WHERE comments LIKE '%[DZHI-IMPORT-v1 row%' AND animal_readable (id, 10100205)) AS u10100205_ui_contains, count(*) FILTER (WHERE comments LIKE '[%' AND animal_readable (id, 10100205)) AS u10100205_ui_bracket FROM animals;
Date: 2026-04-02 10:33:07 Duration: 1m20s Database: zemm_produktiv_7 User: deploy Remote: [local] Application: psql Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
15 2m6s 6 564ms 25s401ms 21s65ms create temp table _dzhi_fix_animals as select f.row_num, f.workgroup_name, f.tourist_group, a.id as animal_id, a.owner, a.editor, a.tourist, a."animalID" from _dzhi_permission_fix f join animals a on a.deleted = false and a.comments like (? || f.row_num::text || ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Apr 02 08 6 2m6s 21s65ms [ User: deploy - Total duration: 2m6s - Times executed: 6 ]
[ Application: psql - Total duration: 2m6s - Times executed: 6 ]
-
CREATE TEMP TABLE _dzhi_fix_animals AS SELECT f.row_num, f.workgroup_name, f.tourist_group, a.id AS animal_id, a.owner, a.editor, a.tourist, a."animalID" FROM _dzhi_permission_fix f JOIN animals a ON a.deleted = false AND a.comments LIKE ('%[DZHI-IMPORT-v1 row=' || f.row_num::text || ']%');
Date: 2026-04-02 07:29:41 Duration: 25s401ms Database: zemm_produktiv_7 User: deploy Remote: [local] Application: psql Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE TEMP TABLE _dzhi_fix_animals AS SELECT f.row_num, f.workgroup_name, f.tourist_group, a.id AS animal_id, a.owner, a.editor, a.tourist, a."animalID" FROM _dzhi_permission_fix f JOIN animals a ON a.deleted = false AND a.comments LIKE ('%[DZHI-IMPORT-v1 row=' || f.row_num::text || ']%');
Date: 2026-04-02 07:30:26 Duration: 25s306ms Database: zemm_produktiv_7 User: deploy Remote: [local] Application: psql Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE TEMP TABLE _dzhi_fix_animals AS SELECT f.row_num, f.workgroup_name, f.tourist_group, a.id AS animal_id, a.owner, a.editor, a.tourist, a."animalID" FROM _dzhi_permission_fix f JOIN animals a ON a.deleted = false AND a.comments LIKE ('%[DZHI-IMPORT-v1 row=' || f.row_num::text || ']%');
Date: 2026-04-02 07:28:08 Duration: 25s110ms Database: zemm_produktiv_7 User: deploy Remote: [local] Application: psql Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
16 2m6s 6 564ms 25s401ms 21s65ms create temp table _dzhi_permission_fix ( row_num integer primary key, workgroup_name text not null, tourist_group integer not null );Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Apr 02 08 6 2m6s 21s65ms [ User: deploy - Total duration: 2m6s - Times executed: 6 ]
[ Application: psql - Total duration: 2m6s - Times executed: 6 ]
-
CREATE TEMP TABLE _dzhi_permission_fix ( row_num integer PRIMARY KEY, workgroup_name text NOT NULL, tourist_group integer NOT NULL );
Date: 2026-04-02 07:29:41 Duration: 25s401ms Database: zemm_produktiv_7 User: deploy Remote: [local] Application: psql Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE TEMP TABLE _dzhi_permission_fix ( row_num integer PRIMARY KEY, workgroup_name text NOT NULL, tourist_group integer NOT NULL );
Date: 2026-04-02 07:30:26 Duration: 25s306ms Database: zemm_produktiv_7 User: deploy Remote: [local] Application: psql Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE TEMP TABLE _dzhi_permission_fix ( row_num integer PRIMARY KEY, workgroup_name text NOT NULL, tourist_group integer NOT NULL );
Date: 2026-04-02 07:28:08 Duration: 25s110ms Database: zemm_produktiv_7 User: deploy Remote: [local] Application: psql Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
17 1m8s 1 1m8s 1m8s 1m8s select count(*) filter (where animal_readable (a.id, ?)) as readable_any, count(*) filter (where a.comments ilike ? and animal_readable (a.id, ?)) as readable_dzhi_contains, count(*) filter (where a.comments like ? and animal_readable (a.id, ?)) as readable_dzhi_bracket from animals a;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Apr 02 11 1 1m8s 1m8s [ User: deploy - Total duration: 1m8s - Times executed: 1 ]
[ Application: psql - Total duration: 1m8s - Times executed: 1 ]
-
SELECT count(*) FILTER (WHERE animal_readable (a.id, 10100134)) AS readable_any, count(*) FILTER (WHERE a.comments ILIKE '%DZHI-IMPORT-v1 row%' AND animal_readable (a.id, 10100134)) AS readable_dzhi_contains, count(*) FILTER (WHERE a.comments LIKE '[%' AND animal_readable (a.id, 10100134)) AS readable_dzhi_bracket FROM animals a;
Date: 2026-04-02 10:27:20 Duration: 1m8s Database: zemm_produktiv_7 User: deploy Remote: [local] Application: psql Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
18 1m7s 1 1m7s 1m7s 1m7s with recent_users as ( select distinct on (lt."user") lt."user" as user_id, max(lt.timestamp) over (partition by lt."user") as last_seen from login_tracker lt join users u on u.id = lt."user" where lt.timestamp >= now() - interval ? and coalesce(u.deleted, false) = false order by lt."user", max(lt.timestamp) over (partition by lt."user") desc ), top_users as ( select user_id, last_seen from recent_users order by last_seen desc limit ? ) select tu.user_id, to_char(tu.last_seen, ?) as last_seen, count(*) filter (where a.comments ilike ? and user_is_tgm (a.owner, tu.user_id) or false) as dummy from top_users tu cross join lateral ( select ?) s join animals a on true group by tu.user_id, tu.last_seen order by tu.last_seen desc;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Apr 02 11 1 1m7s 1m7s [ User: deploy - Total duration: 1m7s - Times executed: 1 ]
[ Application: psql - Total duration: 1m7s - Times executed: 1 ]
-
WITH recent_users AS ( SELECT DISTINCT ON (lt."user") lt."user" AS user_id, max(lt.timestamp) OVER (PARTITION BY lt."user") AS last_seen FROM login_tracker lt JOIN users u ON u.id = lt."user" WHERE lt.timestamp >= now() - interval '90 days' AND COALESCE(u.deleted, false) = false ORDER BY lt."user", max(lt.timestamp) OVER (PARTITION BY lt."user") DESC ), top_users AS ( SELECT user_id, last_seen FROM recent_users ORDER BY last_seen DESC LIMIT 12 ) SELECT tu.user_id, to_char(tu.last_seen, 'YYYY-MM-DD HH24:MI') AS last_seen, count(*) FILTER (WHERE a.comments ILIKE '%DZHI-IMPORT-v1 row%' AND user_is_tgm (a.owner, tu.user_id) OR false) AS dummy FROM top_users tu CROSS JOIN LATERAL ( SELECT 1) s JOIN animals a ON true GROUP BY tu.user_id, tu.last_seen ORDER BY tu.last_seen DESC;
Date: 2026-04-02 10:25:34 Duration: 1m7s Database: zemm_produktiv_7 User: deploy Remote: [local] Application: psql Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
19 47s803ms 1 47s803ms 47s803ms 47s803ms select count(*) filter (where a.comments ilike ? and animal_readable (a.id, ?)) as readable_contains_10100134, count(*) filter (where a.comments like ? and animal_readable (a.id, ?)) as readable_bracket_10100134, count(*) filter (where a.comments ilike ? and a.species = ? and animal_readable (a.id, ?)) as readable_contains_species11_10100134 from animals a;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Apr 02 11 1 47s803ms 47s803ms [ User: deploy - Total duration: 47s803ms - Times executed: 1 ]
[ Application: psql - Total duration: 47s803ms - Times executed: 1 ]
-
SELECT count(*) FILTER (WHERE a.comments ILIKE '%DZHI-IMPORT-v1 row%' AND animal_readable (a.id, 10100134)) AS readable_contains_10100134, count(*) FILTER (WHERE a.comments LIKE '[%' AND animal_readable (a.id, 10100134)) AS readable_bracket_10100134, count(*) FILTER (WHERE a.comments ILIKE '%DZHI-IMPORT-v1 row%' AND a.species = 11 AND animal_readable (a.id, 10100134)) AS readable_contains_species11_10100134 FROM animals a;
Date: 2026-04-02 10:25:14 Duration: 47s803ms Database: zemm_produktiv_7 User: deploy Remote: [local] Application: psql Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
20 37s342ms 1 37s342ms 37s342ms 37s342ms select count(*) filter (where a.comments ilike ? and animal_readable (a.id, ?)) as readable_contains_10100205, count(*) filter (where a.comments like ? and animal_readable (a.id, ?)) as readable_bracket_10100205, count(*) filter (where a.comments ilike ? and a.species = ? and animal_readable (a.id, ?)) as readable_contains_species11_10100205 from animals a;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Apr 02 11 1 37s342ms 37s342ms [ User: deploy - Total duration: 37s342ms - Times executed: 1 ]
[ Application: psql - Total duration: 37s342ms - Times executed: 1 ]
-
SELECT count(*) FILTER (WHERE a.comments ILIKE '%DZHI-IMPORT-v1 row%' AND animal_readable (a.id, 10100205)) AS readable_contains_10100205, count(*) FILTER (WHERE a.comments LIKE '[%' AND animal_readable (a.id, 10100205)) AS readable_bracket_10100205, count(*) FILTER (WHERE a.comments ILIKE '%DZHI-IMPORT-v1 row%' AND a.species = 11 AND animal_readable (a.id, 10100205)) AS readable_contains_species11_10100205 FROM animals a;
Date: 2026-04-02 10:25:03 Duration: 37s342ms Database: zemm_produktiv_7 User: deploy Remote: [local] Application: psql Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,440 1h24m48s 508ms 1m23s 3s533ms 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 #1
Day Hour Count Duration Avg duration Apr 02 01 60 0ms 0ms 02 60 29s646ms 494ms 03 60 1m1s 1s22ms 04 60 1m1s 1s22ms 05 60 1m1s 1s22ms 06 60 1m1s 1s22ms 07 60 51s81ms 851ms 08 60 2m17s 2s289ms 09 60 1m18s 1s313ms 10 60 43s182ms 719ms 11 60 40m43s 40s727ms 12 60 24m40s 24s683ms 13 60 48s109ms 801ms 14 60 1m12s 1s210ms 15 60 52s729ms 878ms 16 60 44s765ms 746ms 17 60 44s765ms 746ms 18 60 44s765ms 746ms 19 60 44s765ms 746ms 20 60 44s765ms 746ms 21 60 44s765ms 746ms 22 60 44s765ms 746ms 23 60 44s765ms 746ms 00 60 47s184ms 786ms [ User: labanimal - Total duration: 1h24m48s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-02 10:33:01 Duration: 1m23s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-02 11:17:01 Duration: 1m20s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-02 10:27:01 Duration: 1m7s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
2 1,440 1h24m48s 508ms 1m23s 3s533ms 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 #2
Day Hour Count Duration Avg duration Apr 02 01 60 0ms 0ms 02 60 29s646ms 494ms 03 60 1m1s 1s22ms 04 60 1m1s 1s22ms 05 60 1m1s 1s22ms 06 60 1m1s 1s22ms 07 60 51s81ms 851ms 08 60 2m17s 2s289ms 09 60 1m18s 1s313ms 10 60 43s182ms 719ms 11 60 40m43s 40s727ms 12 60 24m40s 24s683ms 13 60 48s109ms 801ms 14 60 1m12s 1s210ms 15 60 52s729ms 878ms 16 60 44s765ms 746ms 17 60 44s765ms 746ms 18 60 44s765ms 746ms 19 60 44s765ms 746ms 20 60 44s765ms 746ms 21 60 44s765ms 746ms 22 60 44s765ms 746ms 23 60 44s765ms 746ms 00 60 47s184ms 786ms [ User: labanimal - Total duration: 1h24m48s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-04-02 10:33:01 Duration: 1m23s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-04-02 11:17:01 Duration: 1m20s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-04-02 10:27:01 Duration: 1m7s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
3 1,440 1h24m48s 508ms 1m23s 3s533ms create index if not exists idx_app_events_tenant on observability.app_events (tenant_key, occurred_at desc);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Apr 02 01 60 0ms 0ms 02 60 29s646ms 494ms 03 60 1m1s 1s22ms 04 60 1m1s 1s22ms 05 60 1m1s 1s22ms 06 60 1m1s 1s22ms 07 60 51s81ms 851ms 08 60 2m17s 2s289ms 09 60 1m18s 1s313ms 10 60 43s182ms 719ms 11 60 40m43s 40s727ms 12 60 24m40s 24s683ms 13 60 48s109ms 801ms 14 60 1m12s 1s210ms 15 60 52s729ms 878ms 16 60 44s765ms 746ms 17 60 44s765ms 746ms 18 60 44s765ms 746ms 19 60 44s765ms 746ms 20 60 44s765ms 746ms 21 60 44s765ms 746ms 22 60 44s765ms 746ms 23 60 44s765ms 746ms 00 60 47s184ms 786ms [ User: labanimal - Total duration: 1h24m48s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-04-02 10:33:01 Duration: 1m23s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-04-02 11:17:01 Duration: 1m20s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-04-02 10:27:01 Duration: 1m7s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
4 1,440 1h24m48s 508ms 1m23s 3s533ms create index if not exists idx_app_events_type on observability.app_events (event_type);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Apr 02 01 60 0ms 0ms 02 60 29s646ms 494ms 03 60 1m1s 1s22ms 04 60 1m1s 1s22ms 05 60 1m1s 1s22ms 06 60 1m1s 1s22ms 07 60 51s81ms 851ms 08 60 2m17s 2s289ms 09 60 1m18s 1s313ms 10 60 43s182ms 719ms 11 60 40m43s 40s727ms 12 60 24m40s 24s683ms 13 60 48s109ms 801ms 14 60 1m12s 1s210ms 15 60 52s729ms 878ms 16 60 44s765ms 746ms 17 60 44s765ms 746ms 18 60 44s765ms 746ms 19 60 44s765ms 746ms 20 60 44s765ms 746ms 21 60 44s765ms 746ms 22 60 44s765ms 746ms 23 60 44s765ms 746ms 00 60 47s184ms 786ms [ User: labanimal - Total duration: 1h24m48s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-04-02 10:33:01 Duration: 1m23s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-04-02 11:17:01 Duration: 1m20s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-04-02 10:27:01 Duration: 1m7s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
5 1,440 1h24m48s 508ms 1m23s 3s533ms create table if not exists observability.app_events ( id bigserial primary key, tenant_key text not null, event_type text not null, severity text not null, message text not null, payload jsonb, occurred_at timestamptz not null default now(), created_at timestamptz not null default now() );Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Apr 02 01 60 0ms 0ms 02 60 29s646ms 494ms 03 60 1m1s 1s22ms 04 60 1m1s 1s22ms 05 60 1m1s 1s22ms 06 60 1m1s 1s22ms 07 60 51s81ms 851ms 08 60 2m17s 2s289ms 09 60 1m18s 1s313ms 10 60 43s182ms 719ms 11 60 40m43s 40s727ms 12 60 24m40s 24s683ms 13 60 48s109ms 801ms 14 60 1m12s 1s210ms 15 60 52s729ms 878ms 16 60 44s765ms 746ms 17 60 44s765ms 746ms 18 60 44s765ms 746ms 19 60 44s765ms 746ms 20 60 44s765ms 746ms 21 60 44s765ms 746ms 22 60 44s765ms 746ms 23 60 44s765ms 746ms 00 60 47s184ms 786ms [ User: labanimal - Total duration: 1h24m48s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-02 10:33:01 Duration: 1m23s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-02 11:17:01 Duration: 1m20s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-02 10:27:01 Duration: 1m7s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
6 1,440 1h24m48s 508ms 1m23s 3s533ms create table if not exists observability.nginx_counters ( id bigserial primary key, payload jsonb not null, collected_at timestamptz not null default now() );Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Apr 02 01 60 0ms 0ms 02 60 29s646ms 494ms 03 60 1m1s 1s22ms 04 60 1m1s 1s22ms 05 60 1m1s 1s22ms 06 60 1m1s 1s22ms 07 60 51s81ms 851ms 08 60 2m17s 2s289ms 09 60 1m18s 1s313ms 10 60 43s182ms 719ms 11 60 40m43s 40s727ms 12 60 24m40s 24s683ms 13 60 48s109ms 801ms 14 60 1m12s 1s210ms 15 60 52s729ms 878ms 16 60 44s765ms 746ms 17 60 44s765ms 746ms 18 60 44s765ms 746ms 19 60 44s765ms 746ms 20 60 44s765ms 746ms 21 60 44s765ms 746ms 22 60 44s765ms 746ms 23 60 44s765ms 746ms 00 60 47s184ms 786ms [ User: labanimal - Total duration: 1h24m48s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-02 10:33:01 Duration: 1m23s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-02 11:17:01 Duration: 1m20s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-02 10:27:01 Duration: 1m7s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
7 1,440 1h24m48s 508ms 1m23s 3s533ms create table if not exists observability.phpfpm_counters ( id bigserial primary key, payload jsonb not null, collected_at timestamptz not null default now() );Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Apr 02 01 60 0ms 0ms 02 60 29s646ms 494ms 03 60 1m1s 1s22ms 04 60 1m1s 1s22ms 05 60 1m1s 1s22ms 06 60 1m1s 1s22ms 07 60 51s81ms 851ms 08 60 2m17s 2s289ms 09 60 1m18s 1s313ms 10 60 43s182ms 719ms 11 60 40m43s 40s727ms 12 60 24m40s 24s683ms 13 60 48s109ms 801ms 14 60 1m12s 1s210ms 15 60 52s729ms 878ms 16 60 44s765ms 746ms 17 60 44s765ms 746ms 18 60 44s765ms 746ms 19 60 44s765ms 746ms 20 60 44s765ms 746ms 21 60 44s765ms 746ms 22 60 44s765ms 746ms 23 60 44s765ms 746ms 00 60 47s184ms 786ms [ User: labanimal - Total duration: 1h24m48s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-02 10:33:01 Duration: 1m23s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-02 11:17:01 Duration: 1m20s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-02 10:27:01 Duration: 1m7s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
8 1,440 1h24m48s 508ms 1m23s 3s533ms create index if not exists idx_metrics_timeseries_bucket on observability.metrics_timeseries (bucket_start);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Apr 02 01 60 0ms 0ms 02 60 29s646ms 494ms 03 60 1m1s 1s22ms 04 60 1m1s 1s22ms 05 60 1m1s 1s22ms 06 60 1m1s 1s22ms 07 60 51s81ms 851ms 08 60 2m17s 2s289ms 09 60 1m18s 1s313ms 10 60 43s182ms 719ms 11 60 40m43s 40s727ms 12 60 24m40s 24s683ms 13 60 48s109ms 801ms 14 60 1m12s 1s210ms 15 60 52s729ms 878ms 16 60 44s765ms 746ms 17 60 44s765ms 746ms 18 60 44s765ms 746ms 19 60 44s765ms 746ms 20 60 44s765ms 746ms 21 60 44s765ms 746ms 22 60 44s765ms 746ms 23 60 44s765ms 746ms 00 60 47s184ms 786ms [ User: labanimal - Total duration: 1h24m48s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-04-02 10:33:01 Duration: 1m23s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-04-02 11:17:01 Duration: 1m20s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-04-02 10:27:01 Duration: 1m7s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
9 1,440 1h24m48s 508ms 1m23s 3s533ms 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 #9
Day Hour Count Duration Avg duration Apr 02 01 60 0ms 0ms 02 60 29s646ms 494ms 03 60 1m1s 1s22ms 04 60 1m1s 1s22ms 05 60 1m1s 1s22ms 06 60 1m1s 1s22ms 07 60 51s81ms 851ms 08 60 2m17s 2s289ms 09 60 1m18s 1s313ms 10 60 43s182ms 719ms 11 60 40m43s 40s727ms 12 60 24m40s 24s683ms 13 60 48s109ms 801ms 14 60 1m12s 1s210ms 15 60 52s729ms 878ms 16 60 44s765ms 746ms 17 60 44s765ms 746ms 18 60 44s765ms 746ms 19 60 44s765ms 746ms 20 60 44s765ms 746ms 21 60 44s765ms 746ms 22 60 44s765ms 746ms 23 60 44s765ms 746ms 00 60 47s184ms 786ms [ User: labanimal - Total duration: 1h24m48s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-02 10:33:01 Duration: 1m23s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-02 11:17:01 Duration: 1m20s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-02 10:27:01 Duration: 1m7s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
10 1,440 1h24m48s 508ms 1m23s 3s533ms 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 #10
Day Hour Count Duration Avg duration Apr 02 01 60 0ms 0ms 02 60 29s646ms 494ms 03 60 1m1s 1s22ms 04 60 1m1s 1s22ms 05 60 1m1s 1s22ms 06 60 1m1s 1s22ms 07 60 51s81ms 851ms 08 60 2m17s 2s289ms 09 60 1m18s 1s313ms 10 60 43s182ms 719ms 11 60 40m43s 40s727ms 12 60 24m40s 24s683ms 13 60 48s109ms 801ms 14 60 1m12s 1s210ms 15 60 52s729ms 878ms 16 60 44s765ms 746ms 17 60 44s765ms 746ms 18 60 44s765ms 746ms 19 60 44s765ms 746ms 20 60 44s765ms 746ms 21 60 44s765ms 746ms 22 60 44s765ms 746ms 23 60 44s765ms 746ms 00 60 47s184ms 786ms [ User: labanimal - Total duration: 1h24m48s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-02 10:33:01 Duration: 1m23s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-02 11:17:01 Duration: 1m20s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-02 10:27:01 Duration: 1m7s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
11 1,440 1h24m48s 508ms 1m23s 3s533ms create index if not exists idx_metrics_timeseries_metric on observability.metrics_timeseries (metric_name);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Apr 02 01 60 0ms 0ms 02 60 29s646ms 494ms 03 60 1m1s 1s22ms 04 60 1m1s 1s22ms 05 60 1m1s 1s22ms 06 60 1m1s 1s22ms 07 60 51s81ms 851ms 08 60 2m17s 2s289ms 09 60 1m18s 1s313ms 10 60 43s182ms 719ms 11 60 40m43s 40s727ms 12 60 24m40s 24s683ms 13 60 48s109ms 801ms 14 60 1m12s 1s210ms 15 60 52s729ms 878ms 16 60 44s765ms 746ms 17 60 44s765ms 746ms 18 60 44s765ms 746ms 19 60 44s765ms 746ms 20 60 44s765ms 746ms 21 60 44s765ms 746ms 22 60 44s765ms 746ms 23 60 44s765ms 746ms 00 60 47s184ms 786ms [ User: labanimal - Total duration: 1h24m48s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-04-02 10:33:01 Duration: 1m23s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-04-02 11:17:01 Duration: 1m20s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-04-02 10:27:01 Duration: 1m7s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
12 1,440 1h24m48s 508ms 1m23s 3s533ms 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 #12
Day Hour Count Duration Avg duration Apr 02 01 60 0ms 0ms 02 60 29s646ms 494ms 03 60 1m1s 1s22ms 04 60 1m1s 1s22ms 05 60 1m1s 1s22ms 06 60 1m1s 1s22ms 07 60 51s81ms 851ms 08 60 2m17s 2s289ms 09 60 1m18s 1s313ms 10 60 43s182ms 719ms 11 60 40m43s 40s727ms 12 60 24m40s 24s683ms 13 60 48s109ms 801ms 14 60 1m12s 1s210ms 15 60 52s729ms 878ms 16 60 44s765ms 746ms 17 60 44s765ms 746ms 18 60 44s765ms 746ms 19 60 44s765ms 746ms 20 60 44s765ms 746ms 21 60 44s765ms 746ms 22 60 44s765ms 746ms 23 60 44s765ms 746ms 00 60 47s184ms 786ms [ User: labanimal - Total duration: 1h24m48s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-04-02 10:33:01 Duration: 1m23s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-04-02 11:17:01 Duration: 1m20s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-04-02 10:27:01 Duration: 1m7s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
13 1,440 1h24m48s 508ms 1m23s 3s533ms create schema if not exists observability;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Apr 02 01 60 0ms 0ms 02 60 29s646ms 494ms 03 60 1m1s 1s22ms 04 60 1m1s 1s22ms 05 60 1m1s 1s22ms 06 60 1m1s 1s22ms 07 60 51s81ms 851ms 08 60 2m17s 2s289ms 09 60 1m18s 1s313ms 10 60 43s182ms 719ms 11 60 40m43s 40s727ms 12 60 24m40s 24s683ms 13 60 48s109ms 801ms 14 60 1m12s 1s210ms 15 60 52s729ms 878ms 16 60 44s765ms 746ms 17 60 44s765ms 746ms 18 60 44s765ms 746ms 19 60 44s765ms 746ms 20 60 44s765ms 746ms 21 60 44s765ms 746ms 22 60 44s765ms 746ms 23 60 44s765ms 746ms 00 60 47s184ms 786ms [ User: labanimal - Total duration: 1h24m48s - Times executed: 1349 ]
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-04-02 10:33:01 Duration: 1m23s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-04-02 11:17:01 Duration: 1m20s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-04-02 10:27:01 Duration: 1m7s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
14 6 2m6s 564ms 25s401ms 21s65ms create temp table _dzhi_fix_animals as select f.row_num, f.workgroup_name, f.tourist_group, a.id as animal_id, a.owner, a.editor, a.tourist, a."animalID" from _dzhi_permission_fix f join animals a on a.deleted = false and a.comments like (? || f.row_num::text || ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Apr 02 08 6 2m6s 21s65ms [ User: deploy - Total duration: 2m6s - Times executed: 6 ]
[ Application: psql - Total duration: 2m6s - Times executed: 6 ]
-
CREATE TEMP TABLE _dzhi_fix_animals AS SELECT f.row_num, f.workgroup_name, f.tourist_group, a.id AS animal_id, a.owner, a.editor, a.tourist, a."animalID" FROM _dzhi_permission_fix f JOIN animals a ON a.deleted = false AND a.comments LIKE ('%[DZHI-IMPORT-v1 row=' || f.row_num::text || ']%');
Date: 2026-04-02 07:29:41 Duration: 25s401ms Database: zemm_produktiv_7 User: deploy Remote: [local] Application: psql Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE TEMP TABLE _dzhi_fix_animals AS SELECT f.row_num, f.workgroup_name, f.tourist_group, a.id AS animal_id, a.owner, a.editor, a.tourist, a."animalID" FROM _dzhi_permission_fix f JOIN animals a ON a.deleted = false AND a.comments LIKE ('%[DZHI-IMPORT-v1 row=' || f.row_num::text || ']%');
Date: 2026-04-02 07:30:26 Duration: 25s306ms Database: zemm_produktiv_7 User: deploy Remote: [local] Application: psql Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE TEMP TABLE _dzhi_fix_animals AS SELECT f.row_num, f.workgroup_name, f.tourist_group, a.id AS animal_id, a.owner, a.editor, a.tourist, a."animalID" FROM _dzhi_permission_fix f JOIN animals a ON a.deleted = false AND a.comments LIKE ('%[DZHI-IMPORT-v1 row=' || f.row_num::text || ']%');
Date: 2026-04-02 07:28:08 Duration: 25s110ms Database: zemm_produktiv_7 User: deploy Remote: [local] Application: psql Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
15 6 2m6s 564ms 25s401ms 21s65ms create temp table _dzhi_permission_fix ( row_num integer primary key, workgroup_name text not null, tourist_group integer not null );Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Apr 02 08 6 2m6s 21s65ms [ User: deploy - Total duration: 2m6s - Times executed: 6 ]
[ Application: psql - Total duration: 2m6s - Times executed: 6 ]
-
CREATE TEMP TABLE _dzhi_permission_fix ( row_num integer PRIMARY KEY, workgroup_name text NOT NULL, tourist_group integer NOT NULL );
Date: 2026-04-02 07:29:41 Duration: 25s401ms Database: zemm_produktiv_7 User: deploy Remote: [local] Application: psql Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE TEMP TABLE _dzhi_permission_fix ( row_num integer PRIMARY KEY, workgroup_name text NOT NULL, tourist_group integer NOT NULL );
Date: 2026-04-02 07:30:26 Duration: 25s306ms Database: zemm_produktiv_7 User: deploy Remote: [local] Application: psql Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE TEMP TABLE _dzhi_permission_fix ( row_num integer PRIMARY KEY, workgroup_name text NOT NULL, tourist_group integer NOT NULL );
Date: 2026-04-02 07:28:08 Duration: 25s110ms Database: zemm_produktiv_7 User: deploy Remote: [local] Application: psql Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
16 6 6s677ms 570ms 1s824ms 1s112ms select * from p_wean_males (?, ?, ?, null, ?, ?, null, ?, ?, ?, ?, null, null, null, null, null, null, null, null, null, ?, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Apr 02 07 5 6s107ms 1s221ms 10 1 570ms 570ms [ User: labanimal - Total duration: 6s677ms - Times executed: 6 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 6s677ms - Times executed: 6 ]
-
SELECT * FROM p_wean_males (270, 10131775, 7, NULL, '52-161', 'B6J.Ldlr ko', NULL, 'F8', '2026-03-14', 'Ldlr(tg/tg)', 'tgtg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '56', 43);
Date: 2026-04-02 06:24:03 Duration: 1s824ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
SELECT * FROM p_wean_males (270, 10131773, 5, NULL, '52-164', 'B6J.Ldlr ko', NULL, 'F8', '2026-03-12', 'Ldlr(tg/tg)', 'tgtg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '56', 53);
Date: 2026-04-02 06:29:58 Duration: 1s332ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
SELECT * FROM p_wean_males (270, 10131769, 5, NULL, '52-270', 'B6.FSP1', NULL, 'F6', '2026-03-11', 'AIFM2(tg/tg)', 'tgtg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '56', 16);
Date: 2026-04-02 06:39:42 Duration: 1s314ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
17 5 5s933ms 758ms 1s475ms 1s186ms select * from p_wean_females (?, ?, ?, null, ?, ?, ?, ?, ?, ?, null, ?, null, ?, null, null, null, null, null, null, ?, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Apr 02 10 1 1s240ms 1s240ms 11 2 2s465ms 1s232ms 14 1 758ms 758ms 15 1 1s468ms 1s468ms [ User: labanimal - Total duration: 5s933ms - Times executed: 5 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 5s933ms - Times executed: 5 ]
-
SELECT * FROM p_wean_females (142, 10131798, 6, NULL, '48-124', 'B6.IL5cre.tdTom', 'Il5tm1.1(cre)Lky x B6.Cg-Gt(ROSA)26Sortm9(CAG-tdTomato)Hze/J', 'F1', '2026-03-14', 'IL5cre(tg/wt)', NULL, 'tdTom(tg/tg)', NULL, ' ', NULL, NULL, NULL, NULL, NULL, NULL, '', '371', 45);
Date: 2026-04-02 10:16:31 Duration: 1s475ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
SELECT * FROM p_wean_females (183, 10131708, 6, NULL, '54-217', 'B6.Postn-MCM', 'B6.129S-Postntm2.1(cre/Esr1*)Jmol/J', 'F6', '2026-03-16', 'Postn-MCM ', NULL, ' ', NULL, ' ', NULL, NULL, NULL, NULL, NULL, NULL, '', '434', 3);
Date: 2026-04-02 14:17:55 Duration: 1s468ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
SELECT * FROM p_wean_females (142, 10131700, 5, NULL, '48-170', 'B6.Rosa-tdTom', 'B6.Cg-Gt(ROSA)26Sortm14(CAG-tdTomato)Hze/J ', 'F1', '2026-03-11', 'tdTom(tg/tg)', NULL, ' ', NULL, ' ', NULL, NULL, NULL, NULL, NULL, NULL, '', '371', 93);
Date: 2026-04-02 09:43:06 Duration: 1s240ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
18 4 21s484ms 1s350ms 6s722ms 5s371ms copy public."targetgroupMembers" (id, targetgroup, "user", "group") to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Apr 02 08 2 13s419ms 6s709ms 14 1 6s714ms 6s714ms 00 1 1s350ms 1s350ms [ User: labanimal - Total duration: 20s133ms - Times executed: 3 ]
[ User: postgres - Total duration: 1s350ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 21s484ms - Times executed: 4 ]
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-04-02 07:44:40 Duration: 6s722ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-04-02 13:52:34 Duration: 6s714ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-04-02 07:31:17 Duration: 6s696ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
19 4 16s127ms 1s323ms 4s939ms 4s31ms 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 #19
Day Hour Count Duration Avg duration Apr 02 08 2 9s872ms 4s936ms 14 1 4s931ms 4s931ms 00 1 1s323ms 1s323ms [ User: labanimal - Total duration: 14s804ms - Times executed: 3 ]
[ User: postgres - Total duration: 1s323ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 16s127ms - Times executed: 4 ]
-
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-04-02 07:31:03 Duration: 4s939ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-04-02_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-04-02 07:44:26 Duration: 4s933ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-04-02_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-04-02 13:52:20 Duration: 4s931ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
20 4 12s363ms 1s975ms 3s557ms 3s90ms 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 #20
Day Hour Count Duration Avg duration Apr 02 08 2 7s35ms 3s517ms 14 1 3s351ms 3s351ms 00 1 1s975ms 1s975ms [ User: labanimal - Total duration: 10s387ms - Times executed: 3 ]
[ User: postgres - Total duration: 1s975ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 12s363ms - Times executed: 4 ]
-
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-04-02 07:44:31 Duration: 3s557ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-04-02_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-04-02 07:31:08 Duration: 3s478ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-04-02_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-04-02 13:52:25 Duration: 3s351ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 1m20s 1m23s 1m22s 2 2m44s select count(*) filter (where comments like ? and animal_readable (id, ?)) as u10100134_ui_contains, count(*) filter (where comments like ? and animal_readable (id, ?)) as u10100134_ui_bracket, count(*) filter (where comments like ? and animal_readable (id, ?)) as u10100205_ui_contains, count(*) filter (where comments like ? and animal_readable (id, ?)) as u10100205_ui_bracket from animals;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Apr 02 11 2 2m44s 1m22s [ User: deploy - Total duration: 2m44s - Times executed: 2 ]
[ Application: psql - Total duration: 2m44s - Times executed: 2 ]
-
SELECT count(*) FILTER (WHERE comments LIKE '%[DZHI-IMPORT-v1 row%' AND animal_readable (id, 10100134)) AS u10100134_ui_contains, count(*) FILTER (WHERE comments LIKE '[%' AND animal_readable (id, 10100134)) AS u10100134_ui_bracket, count(*) FILTER (WHERE comments LIKE '%[DZHI-IMPORT-v1 row%' AND animal_readable (id, 10100205)) AS u10100205_ui_contains, count(*) FILTER (WHERE comments LIKE '[%' AND animal_readable (id, 10100205)) AS u10100205_ui_bracket FROM animals;
Date: 2026-04-02 10:32:11 Duration: 1m23s Database: zemm_produktiv_7 User: deploy Remote: [local] Application: psql Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
SELECT count(*) FILTER (WHERE comments LIKE '%[DZHI-IMPORT-v1 row%' AND animal_readable (id, 10100134)) AS u10100134_ui_contains, count(*) FILTER (WHERE comments LIKE '[%' AND animal_readable (id, 10100134)) AS u10100134_ui_bracket, count(*) FILTER (WHERE comments LIKE '%[DZHI-IMPORT-v1 row%' AND animal_readable (id, 10100205)) AS u10100205_ui_contains, count(*) FILTER (WHERE comments LIKE '[%' AND animal_readable (id, 10100205)) AS u10100205_ui_bracket FROM animals;
Date: 2026-04-02 10:33:07 Duration: 1m20s Database: zemm_produktiv_7 User: deploy Remote: [local] Application: psql Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
2 1m8s 1m8s 1m8s 1 1m8s select count(*) filter (where animal_readable (a.id, ?)) as readable_any, count(*) filter (where a.comments ilike ? and animal_readable (a.id, ?)) as readable_dzhi_contains, count(*) filter (where a.comments like ? and animal_readable (a.id, ?)) as readable_dzhi_bracket from animals a;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Apr 02 11 1 1m8s 1m8s [ User: deploy - Total duration: 1m8s - Times executed: 1 ]
[ Application: psql - Total duration: 1m8s - Times executed: 1 ]
-
SELECT count(*) FILTER (WHERE animal_readable (a.id, 10100134)) AS readable_any, count(*) FILTER (WHERE a.comments ILIKE '%DZHI-IMPORT-v1 row%' AND animal_readable (a.id, 10100134)) AS readable_dzhi_contains, count(*) FILTER (WHERE a.comments LIKE '[%' AND animal_readable (a.id, 10100134)) AS readable_dzhi_bracket FROM animals a;
Date: 2026-04-02 10:27:20 Duration: 1m8s Database: zemm_produktiv_7 User: deploy Remote: [local] Application: psql Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
3 1m7s 1m7s 1m7s 1 1m7s with recent_users as ( select distinct on (lt."user") lt."user" as user_id, max(lt.timestamp) over (partition by lt."user") as last_seen from login_tracker lt join users u on u.id = lt."user" where lt.timestamp >= now() - interval ? and coalesce(u.deleted, false) = false order by lt."user", max(lt.timestamp) over (partition by lt."user") desc ), top_users as ( select user_id, last_seen from recent_users order by last_seen desc limit ? ) select tu.user_id, to_char(tu.last_seen, ?) as last_seen, count(*) filter (where a.comments ilike ? and user_is_tgm (a.owner, tu.user_id) or false) as dummy from top_users tu cross join lateral ( select ?) s join animals a on true group by tu.user_id, tu.last_seen order by tu.last_seen desc;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Apr 02 11 1 1m7s 1m7s [ User: deploy - Total duration: 1m7s - Times executed: 1 ]
[ Application: psql - Total duration: 1m7s - Times executed: 1 ]
-
WITH recent_users AS ( SELECT DISTINCT ON (lt."user") lt."user" AS user_id, max(lt.timestamp) OVER (PARTITION BY lt."user") AS last_seen FROM login_tracker lt JOIN users u ON u.id = lt."user" WHERE lt.timestamp >= now() - interval '90 days' AND COALESCE(u.deleted, false) = false ORDER BY lt."user", max(lt.timestamp) OVER (PARTITION BY lt."user") DESC ), top_users AS ( SELECT user_id, last_seen FROM recent_users ORDER BY last_seen DESC LIMIT 12 ) SELECT tu.user_id, to_char(tu.last_seen, 'YYYY-MM-DD HH24:MI') AS last_seen, count(*) FILTER (WHERE a.comments ILIKE '%DZHI-IMPORT-v1 row%' AND user_is_tgm (a.owner, tu.user_id) OR false) AS dummy FROM top_users tu CROSS JOIN LATERAL ( SELECT 1) s JOIN animals a ON true GROUP BY tu.user_id, tu.last_seen ORDER BY tu.last_seen DESC;
Date: 2026-04-02 10:25:34 Duration: 1m7s Database: zemm_produktiv_7 User: deploy Remote: [local] Application: psql Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
4 47s803ms 47s803ms 47s803ms 1 47s803ms select count(*) filter (where a.comments ilike ? and animal_readable (a.id, ?)) as readable_contains_10100134, count(*) filter (where a.comments like ? and animal_readable (a.id, ?)) as readable_bracket_10100134, count(*) filter (where a.comments ilike ? and a.species = ? and animal_readable (a.id, ?)) as readable_contains_species11_10100134 from animals a;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Apr 02 11 1 47s803ms 47s803ms [ User: deploy - Total duration: 47s803ms - Times executed: 1 ]
[ Application: psql - Total duration: 47s803ms - Times executed: 1 ]
-
SELECT count(*) FILTER (WHERE a.comments ILIKE '%DZHI-IMPORT-v1 row%' AND animal_readable (a.id, 10100134)) AS readable_contains_10100134, count(*) FILTER (WHERE a.comments LIKE '[%' AND animal_readable (a.id, 10100134)) AS readable_bracket_10100134, count(*) FILTER (WHERE a.comments ILIKE '%DZHI-IMPORT-v1 row%' AND a.species = 11 AND animal_readable (a.id, 10100134)) AS readable_contains_species11_10100134 FROM animals a;
Date: 2026-04-02 10:25:14 Duration: 47s803ms Database: zemm_produktiv_7 User: deploy Remote: [local] Application: psql Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
5 37s342ms 37s342ms 37s342ms 1 37s342ms select count(*) filter (where a.comments ilike ? and animal_readable (a.id, ?)) as readable_contains_10100205, count(*) filter (where a.comments like ? and animal_readable (a.id, ?)) as readable_bracket_10100205, count(*) filter (where a.comments ilike ? and a.species = ? and animal_readable (a.id, ?)) as readable_contains_species11_10100205 from animals a;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Apr 02 11 1 37s342ms 37s342ms [ User: deploy - Total duration: 37s342ms - Times executed: 1 ]
[ Application: psql - Total duration: 37s342ms - Times executed: 1 ]
-
SELECT count(*) FILTER (WHERE a.comments ILIKE '%DZHI-IMPORT-v1 row%' AND animal_readable (a.id, 10100205)) AS readable_contains_10100205, count(*) FILTER (WHERE a.comments LIKE '[%' AND animal_readable (a.id, 10100205)) AS readable_bracket_10100205, count(*) FILTER (WHERE a.comments ILIKE '%DZHI-IMPORT-v1 row%' AND a.species = 11 AND animal_readable (a.id, 10100205)) AS readable_contains_species11_10100205 FROM animals a;
Date: 2026-04-02 10:25:03 Duration: 37s342ms Database: zemm_produktiv_7 User: deploy Remote: [local] Application: psql Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
6 564ms 25s401ms 21s65ms 6 2m6s create temp table _dzhi_fix_animals as select f.row_num, f.workgroup_name, f.tourist_group, a.id as animal_id, a.owner, a.editor, a.tourist, a."animalID" from _dzhi_permission_fix f join animals a on a.deleted = false and a.comments like (? || f.row_num::text || ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Apr 02 08 6 2m6s 21s65ms [ User: deploy - Total duration: 2m6s - Times executed: 6 ]
[ Application: psql - Total duration: 2m6s - Times executed: 6 ]
-
CREATE TEMP TABLE _dzhi_fix_animals AS SELECT f.row_num, f.workgroup_name, f.tourist_group, a.id AS animal_id, a.owner, a.editor, a.tourist, a."animalID" FROM _dzhi_permission_fix f JOIN animals a ON a.deleted = false AND a.comments LIKE ('%[DZHI-IMPORT-v1 row=' || f.row_num::text || ']%');
Date: 2026-04-02 07:29:41 Duration: 25s401ms Database: zemm_produktiv_7 User: deploy Remote: [local] Application: psql Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE TEMP TABLE _dzhi_fix_animals AS SELECT f.row_num, f.workgroup_name, f.tourist_group, a.id AS animal_id, a.owner, a.editor, a.tourist, a."animalID" FROM _dzhi_permission_fix f JOIN animals a ON a.deleted = false AND a.comments LIKE ('%[DZHI-IMPORT-v1 row=' || f.row_num::text || ']%');
Date: 2026-04-02 07:30:26 Duration: 25s306ms Database: zemm_produktiv_7 User: deploy Remote: [local] Application: psql Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE TEMP TABLE _dzhi_fix_animals AS SELECT f.row_num, f.workgroup_name, f.tourist_group, a.id AS animal_id, a.owner, a.editor, a.tourist, a."animalID" FROM _dzhi_permission_fix f JOIN animals a ON a.deleted = false AND a.comments LIKE ('%[DZHI-IMPORT-v1 row=' || f.row_num::text || ']%');
Date: 2026-04-02 07:28:08 Duration: 25s110ms Database: zemm_produktiv_7 User: deploy Remote: [local] Application: psql Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
7 564ms 25s401ms 21s65ms 6 2m6s create temp table _dzhi_permission_fix ( row_num integer primary key, workgroup_name text not null, tourist_group integer not null );Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Apr 02 08 6 2m6s 21s65ms [ User: deploy - Total duration: 2m6s - Times executed: 6 ]
[ Application: psql - Total duration: 2m6s - Times executed: 6 ]
-
CREATE TEMP TABLE _dzhi_permission_fix ( row_num integer PRIMARY KEY, workgroup_name text NOT NULL, tourist_group integer NOT NULL );
Date: 2026-04-02 07:29:41 Duration: 25s401ms Database: zemm_produktiv_7 User: deploy Remote: [local] Application: psql Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE TEMP TABLE _dzhi_permission_fix ( row_num integer PRIMARY KEY, workgroup_name text NOT NULL, tourist_group integer NOT NULL );
Date: 2026-04-02 07:30:26 Duration: 25s306ms Database: zemm_produktiv_7 User: deploy Remote: [local] Application: psql Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE TEMP TABLE _dzhi_permission_fix ( row_num integer PRIMARY KEY, workgroup_name text NOT NULL, tourist_group integer NOT NULL );
Date: 2026-04-02 07:28:08 Duration: 25s110ms Database: zemm_produktiv_7 User: deploy Remote: [local] Application: psql Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
8 1s350ms 6s722ms 5s371ms 4 21s484ms copy public."targetgroupMembers" (id, targetgroup, "user", "group") to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Apr 02 08 2 13s419ms 6s709ms 14 1 6s714ms 6s714ms 00 1 1s350ms 1s350ms [ User: labanimal - Total duration: 20s133ms - Times executed: 3 ]
[ User: postgres - Total duration: 1s350ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 21s484ms - Times executed: 4 ]
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-04-02 07:44:40 Duration: 6s722ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-04-02 13:52:34 Duration: 6s714ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-04-02 07:31:17 Duration: 6s696ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
9 1s323ms 4s939ms 4s31ms 4 16s127ms 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 #9
Day Hour Count Duration Avg duration Apr 02 08 2 9s872ms 4s936ms 14 1 4s931ms 4s931ms 00 1 1s323ms 1s323ms [ User: labanimal - Total duration: 14s804ms - Times executed: 3 ]
[ User: postgres - Total duration: 1s323ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 16s127ms - Times executed: 4 ]
-
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-04-02 07:31:03 Duration: 4s939ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-04-02_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-04-02 07:44:26 Duration: 4s933ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-04-02_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-04-02 13:52:20 Duration: 4s931ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
10 508ms 1m23s 3s533ms 1,440 1h24m48s create table if not exists observability.db_top_queries ( id bigserial primary key, tenant_key text not null, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz not null default now() );Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Apr 02 01 60 0ms 0ms 02 60 29s646ms 494ms 03 60 1m1s 1s22ms 04 60 1m1s 1s22ms 05 60 1m1s 1s22ms 06 60 1m1s 1s22ms 07 60 51s81ms 851ms 08 60 2m17s 2s289ms 09 60 1m18s 1s313ms 10 60 43s182ms 719ms 11 60 40m43s 40s727ms 12 60 24m40s 24s683ms 13 60 48s109ms 801ms 14 60 1m12s 1s210ms 15 60 52s729ms 878ms 16 60 44s765ms 746ms 17 60 44s765ms 746ms 18 60 44s765ms 746ms 19 60 44s765ms 746ms 20 60 44s765ms 746ms 21 60 44s765ms 746ms 22 60 44s765ms 746ms 23 60 44s765ms 746ms 00 60 47s184ms 786ms [ User: labanimal - Total duration: 1h24m48s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-02 10:33:01 Duration: 1m23s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-02 11:17:01 Duration: 1m20s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-02 10:27:01 Duration: 1m7s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
11 508ms 1m23s 3s533ms 1,440 1h24m48s create index if not exists idx_db_top_queries_tenant on observability.db_top_queries (tenant_key, collected_at desc);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Apr 02 01 60 0ms 0ms 02 60 29s646ms 494ms 03 60 1m1s 1s22ms 04 60 1m1s 1s22ms 05 60 1m1s 1s22ms 06 60 1m1s 1s22ms 07 60 51s81ms 851ms 08 60 2m17s 2s289ms 09 60 1m18s 1s313ms 10 60 43s182ms 719ms 11 60 40m43s 40s727ms 12 60 24m40s 24s683ms 13 60 48s109ms 801ms 14 60 1m12s 1s210ms 15 60 52s729ms 878ms 16 60 44s765ms 746ms 17 60 44s765ms 746ms 18 60 44s765ms 746ms 19 60 44s765ms 746ms 20 60 44s765ms 746ms 21 60 44s765ms 746ms 22 60 44s765ms 746ms 23 60 44s765ms 746ms 00 60 47s184ms 786ms [ User: labanimal - Total duration: 1h24m48s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-04-02 10:33:01 Duration: 1m23s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-04-02 11:17:01 Duration: 1m20s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-04-02 10:27:01 Duration: 1m7s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
12 508ms 1m23s 3s533ms 1,440 1h24m48s 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 Apr 02 01 60 0ms 0ms 02 60 29s646ms 494ms 03 60 1m1s 1s22ms 04 60 1m1s 1s22ms 05 60 1m1s 1s22ms 06 60 1m1s 1s22ms 07 60 51s81ms 851ms 08 60 2m17s 2s289ms 09 60 1m18s 1s313ms 10 60 43s182ms 719ms 11 60 40m43s 40s727ms 12 60 24m40s 24s683ms 13 60 48s109ms 801ms 14 60 1m12s 1s210ms 15 60 52s729ms 878ms 16 60 44s765ms 746ms 17 60 44s765ms 746ms 18 60 44s765ms 746ms 19 60 44s765ms 746ms 20 60 44s765ms 746ms 21 60 44s765ms 746ms 22 60 44s765ms 746ms 23 60 44s765ms 746ms 00 60 47s184ms 786ms [ User: labanimal - Total duration: 1h24m48s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-04-02 10:33:01 Duration: 1m23s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-04-02 11:17:01 Duration: 1m20s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-04-02 10:27:01 Duration: 1m7s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
13 508ms 1m23s 3s533ms 1,440 1h24m48s create index if not exists idx_app_events_type on observability.app_events (event_type);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Apr 02 01 60 0ms 0ms 02 60 29s646ms 494ms 03 60 1m1s 1s22ms 04 60 1m1s 1s22ms 05 60 1m1s 1s22ms 06 60 1m1s 1s22ms 07 60 51s81ms 851ms 08 60 2m17s 2s289ms 09 60 1m18s 1s313ms 10 60 43s182ms 719ms 11 60 40m43s 40s727ms 12 60 24m40s 24s683ms 13 60 48s109ms 801ms 14 60 1m12s 1s210ms 15 60 52s729ms 878ms 16 60 44s765ms 746ms 17 60 44s765ms 746ms 18 60 44s765ms 746ms 19 60 44s765ms 746ms 20 60 44s765ms 746ms 21 60 44s765ms 746ms 22 60 44s765ms 746ms 23 60 44s765ms 746ms 00 60 47s184ms 786ms [ User: labanimal - Total duration: 1h24m48s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-04-02 10:33:01 Duration: 1m23s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-04-02 11:17:01 Duration: 1m20s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-04-02 10:27:01 Duration: 1m7s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
14 508ms 1m23s 3s533ms 1,440 1h24m48s 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 #14
Day Hour Count Duration Avg duration Apr 02 01 60 0ms 0ms 02 60 29s646ms 494ms 03 60 1m1s 1s22ms 04 60 1m1s 1s22ms 05 60 1m1s 1s22ms 06 60 1m1s 1s22ms 07 60 51s81ms 851ms 08 60 2m17s 2s289ms 09 60 1m18s 1s313ms 10 60 43s182ms 719ms 11 60 40m43s 40s727ms 12 60 24m40s 24s683ms 13 60 48s109ms 801ms 14 60 1m12s 1s210ms 15 60 52s729ms 878ms 16 60 44s765ms 746ms 17 60 44s765ms 746ms 18 60 44s765ms 746ms 19 60 44s765ms 746ms 20 60 44s765ms 746ms 21 60 44s765ms 746ms 22 60 44s765ms 746ms 23 60 44s765ms 746ms 00 60 47s184ms 786ms [ User: labanimal - Total duration: 1h24m48s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-02 10:33:01 Duration: 1m23s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-02 11:17:01 Duration: 1m20s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-02 10:27:01 Duration: 1m7s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
15 508ms 1m23s 3s533ms 1,440 1h24m48s 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 Apr 02 01 60 0ms 0ms 02 60 29s646ms 494ms 03 60 1m1s 1s22ms 04 60 1m1s 1s22ms 05 60 1m1s 1s22ms 06 60 1m1s 1s22ms 07 60 51s81ms 851ms 08 60 2m17s 2s289ms 09 60 1m18s 1s313ms 10 60 43s182ms 719ms 11 60 40m43s 40s727ms 12 60 24m40s 24s683ms 13 60 48s109ms 801ms 14 60 1m12s 1s210ms 15 60 52s729ms 878ms 16 60 44s765ms 746ms 17 60 44s765ms 746ms 18 60 44s765ms 746ms 19 60 44s765ms 746ms 20 60 44s765ms 746ms 21 60 44s765ms 746ms 22 60 44s765ms 746ms 23 60 44s765ms 746ms 00 60 47s184ms 786ms [ User: labanimal - Total duration: 1h24m48s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-02 10:33:01 Duration: 1m23s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-02 11:17:01 Duration: 1m20s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-02 10:27:01 Duration: 1m7s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
16 508ms 1m23s 3s533ms 1,440 1h24m48s 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 #16
Day Hour Count Duration Avg duration Apr 02 01 60 0ms 0ms 02 60 29s646ms 494ms 03 60 1m1s 1s22ms 04 60 1m1s 1s22ms 05 60 1m1s 1s22ms 06 60 1m1s 1s22ms 07 60 51s81ms 851ms 08 60 2m17s 2s289ms 09 60 1m18s 1s313ms 10 60 43s182ms 719ms 11 60 40m43s 40s727ms 12 60 24m40s 24s683ms 13 60 48s109ms 801ms 14 60 1m12s 1s210ms 15 60 52s729ms 878ms 16 60 44s765ms 746ms 17 60 44s765ms 746ms 18 60 44s765ms 746ms 19 60 44s765ms 746ms 20 60 44s765ms 746ms 21 60 44s765ms 746ms 22 60 44s765ms 746ms 23 60 44s765ms 746ms 00 60 47s184ms 786ms [ User: labanimal - Total duration: 1h24m48s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-02 10:33:01 Duration: 1m23s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-02 11:17:01 Duration: 1m20s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-02 10:27:01 Duration: 1m7s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
17 508ms 1m23s 3s533ms 1,440 1h24m48s 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 Apr 02 01 60 0ms 0ms 02 60 29s646ms 494ms 03 60 1m1s 1s22ms 04 60 1m1s 1s22ms 05 60 1m1s 1s22ms 06 60 1m1s 1s22ms 07 60 51s81ms 851ms 08 60 2m17s 2s289ms 09 60 1m18s 1s313ms 10 60 43s182ms 719ms 11 60 40m43s 40s727ms 12 60 24m40s 24s683ms 13 60 48s109ms 801ms 14 60 1m12s 1s210ms 15 60 52s729ms 878ms 16 60 44s765ms 746ms 17 60 44s765ms 746ms 18 60 44s765ms 746ms 19 60 44s765ms 746ms 20 60 44s765ms 746ms 21 60 44s765ms 746ms 22 60 44s765ms 746ms 23 60 44s765ms 746ms 00 60 47s184ms 786ms [ User: labanimal - Total duration: 1h24m48s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-04-02 10:33:01 Duration: 1m23s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-04-02 11:17:01 Duration: 1m20s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-04-02 10:27:01 Duration: 1m7s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
18 508ms 1m23s 3s533ms 1,440 1h24m48s 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 #18
Day Hour Count Duration Avg duration Apr 02 01 60 0ms 0ms 02 60 29s646ms 494ms 03 60 1m1s 1s22ms 04 60 1m1s 1s22ms 05 60 1m1s 1s22ms 06 60 1m1s 1s22ms 07 60 51s81ms 851ms 08 60 2m17s 2s289ms 09 60 1m18s 1s313ms 10 60 43s182ms 719ms 11 60 40m43s 40s727ms 12 60 24m40s 24s683ms 13 60 48s109ms 801ms 14 60 1m12s 1s210ms 15 60 52s729ms 878ms 16 60 44s765ms 746ms 17 60 44s765ms 746ms 18 60 44s765ms 746ms 19 60 44s765ms 746ms 20 60 44s765ms 746ms 21 60 44s765ms 746ms 22 60 44s765ms 746ms 23 60 44s765ms 746ms 00 60 47s184ms 786ms [ User: labanimal - Total duration: 1h24m48s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-02 10:33:01 Duration: 1m23s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-02 11:17:01 Duration: 1m20s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-02 10:27:01 Duration: 1m7s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
19 508ms 1m23s 3s533ms 1,440 1h24m48s 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 #19
Day Hour Count Duration Avg duration Apr 02 01 60 0ms 0ms 02 60 29s646ms 494ms 03 60 1m1s 1s22ms 04 60 1m1s 1s22ms 05 60 1m1s 1s22ms 06 60 1m1s 1s22ms 07 60 51s81ms 851ms 08 60 2m17s 2s289ms 09 60 1m18s 1s313ms 10 60 43s182ms 719ms 11 60 40m43s 40s727ms 12 60 24m40s 24s683ms 13 60 48s109ms 801ms 14 60 1m12s 1s210ms 15 60 52s729ms 878ms 16 60 44s765ms 746ms 17 60 44s765ms 746ms 18 60 44s765ms 746ms 19 60 44s765ms 746ms 20 60 44s765ms 746ms 21 60 44s765ms 746ms 22 60 44s765ms 746ms 23 60 44s765ms 746ms 00 60 47s184ms 786ms [ User: labanimal - Total duration: 1h24m48s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-02 10:33:01 Duration: 1m23s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-02 11:17:01 Duration: 1m20s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-02 10:27:01 Duration: 1m7s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
20 508ms 1m23s 3s533ms 1,440 1h24m48s create index if not exists idx_metrics_timeseries_metric on observability.metrics_timeseries (metric_name);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Apr 02 01 60 0ms 0ms 02 60 29s646ms 494ms 03 60 1m1s 1s22ms 04 60 1m1s 1s22ms 05 60 1m1s 1s22ms 06 60 1m1s 1s22ms 07 60 51s81ms 851ms 08 60 2m17s 2s289ms 09 60 1m18s 1s313ms 10 60 43s182ms 719ms 11 60 40m43s 40s727ms 12 60 24m40s 24s683ms 13 60 48s109ms 801ms 14 60 1m12s 1s210ms 15 60 52s729ms 878ms 16 60 44s765ms 746ms 17 60 44s765ms 746ms 18 60 44s765ms 746ms 19 60 44s765ms 746ms 20 60 44s765ms 746ms 21 60 44s765ms 746ms 22 60 44s765ms 746ms 23 60 44s765ms 746ms 00 60 47s184ms 786ms [ User: labanimal - Total duration: 1h24m48s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-04-02 10:33:01 Duration: 1m23s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-04-02 11:17:01 Duration: 1m20s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-04-02 10:27:01 Duration: 1m7s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-02_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
- 88,021 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 160 FATAL entries
- 16 ERROR entries
- 0 WARNING entries
- 0 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 160 Max number of times the same event was reported
- 176 Total events found
Rank Times reported Error 1 160 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Apr 02 02 4 04 2 06 1 07 5 08 13 09 25 12 91 13 18 18 1 - FATAL: database "monitoring" does not exist
- FATAL: database "monitoring" does not exist
- FATAL: database "monitoring" does not exist
Date: 2026-04-02 01:01:16 Database: monitoring Application: User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
Date: 2026-04-02 01:01:16 Database: monitoring Application: User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
Date: 2026-04-02 01:01:37 Database: monitoring Application: User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
2 6 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Apr 02 08 3 09 3 - ERROR: column "animalid" does not exist
- ERROR: column "homecage" does not exist
- ERROR: column "firstname" does not exist
Hint: Perhaps you meant to reference the column "animals.animalID".
Statement: SELECT id, animalid, owner, editor, tourist, project, homecage, name, comments FROM animals WHERE deleted = false AND comments LIKE '%[DZHI-IMPORT-v1%' ORDER BY id DESC LIMIT 12;Date: 2026-04-02 07:16:59 Database: zemm_produktiv_7 Application: psql User: deploy Remote: [local] Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
Hint: Perhaps you meant to reference the column "animals.homeCage".
Statement: SELECT id, "animalID", owner, editor, tourist, project, homecage, name, comments FROM animals WHERE deleted = false AND comments LIKE '%[DZHI-IMPORT-v1%' ORDER BY id DESC LIMIT 12;Date: 2026-04-02 07:17:09 Database: zemm_produktiv_7 Application: psql User: deploy Remote: [local] Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
Statement: SELECT id, username, firstname, lastname FROM users WHERE id IN (1,111,374,425,451,10100222) ORDER BY id;
Date: 2026-04-02 07:17:31 Database: zemm_produktiv_7 Application: psql User: deploy Remote: [local] Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
3 4 ERROR: invalid regular expression: brackets [] not balanced
Times Reported Most Frequent Error / Event #3
Day Hour Count Apr 02 09 4 - ERROR: invalid regular expression: brackets [] not balanced
- ERROR: invalid regular expression: brackets [] not balanced
- ERROR: invalid regular expression: brackets [] not balanced
Statement: SELECT count(*) FILTER (WHERE comments ILIKE '%DZHI-IMPORT-v1 row%' AND comments ~ '^[^[]+\[DZHI-IMPORT-v1 row') AS prefixed_before_bracket, count(*) FILTER (WHERE comments ILIKE '%DZHI-IMPORT-v1 row%' AND comments ~ E'\n\[DZHI-IMPORT-v1 row') AS newline_before_bracket, count(*) FILTER (WHERE comments ILIKE '%DZHI-IMPORT-v1 row%' AND comments NOT LIKE '[DZHI-IMPORT-v1 row%') AS missing_82 FROM animals;
Date: 2026-04-02 08:19:46 Database: zemm_produktiv_8 Application: psql User: deploy Remote: [local] Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
Statement: SELECT count(*) FILTER (WHERE comments ILIKE '%DZHI-IMPORT-v1 row%' AND comments ~ '^[^[]+\[DZHI-IMPORT-v1 row') AS prefixed_before_bracket, count(*) FILTER (WHERE comments ILIKE '%DZHI-IMPORT-v1 row%' AND comments ~ E'\n\[DZHI-IMPORT-v1 row') AS newline_before_bracket, count(*) FILTER (WHERE comments ILIKE '%DZHI-IMPORT-v1 row%' AND comments NOT LIKE '[DZHI-IMPORT-v1 row%') AS missing_82 FROM animals;
Date: 2026-04-02 08:19:46 Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
Statement: SELECT count(*) FILTER (WHERE comments ILIKE '%DZHI-IMPORT-v1 row%' AND comments ~ '^[^[]+\[DZHI-IMPORT-v1 row') AS prefixed_before_bracket, count(*) FILTER (WHERE comments ILIKE '%DZHI-IMPORT-v1 row%' AND comments ~ E'\n\[DZHI-IMPORT-v1 row') AS newline_before_bracket, count(*) FILTER (WHERE comments ILIKE '%DZHI-IMPORT-v1 row%' AND comments NOT LIKE '[DZHI-IMPORT-v1 row%') AS missing_82 FROM animals;
Date: 2026-04-02 08:19:46 Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
4 2 ERROR: column "..." is of type bigint but expression is of type text
Times Reported Most Frequent Error / Event #4
Day Hour Count Apr 02 08 2 - ERROR: column "user" is of type bigint but expression is of type text
- ERROR: column "user" is of type bigint but expression is of type text
Hint: You will need to rewrite or cast the expression.
Statement: INSERT INTO "targetgroupMembers" (targetgroup, "user", "group") SELECT owner, NULL, 1 FROM _dzhi_fix_animals UNION ALL SELECT editor, NULL, 9 FROM _dzhi_fix_animals UNION ALL SELECT editor, NULL, 10 FROM _dzhi_fix_animals UNION ALL SELECT editor, NULL, 11 FROM _dzhi_fix_animals UNION ALL SELECT tourist, NULL, tourist_group FROM _dzhi_fix_animals;Date: 2026-04-02 07:26:29 Database: zemm_produktiv_7 Application: psql User: deploy Remote: [local] Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
Hint: You will need to rewrite or cast the expression.
Statement: INSERT INTO "targetgroupMembers" (targetgroup, "user", "group") SELECT owner, NULL, 1 FROM _dzhi_fix_animals UNION ALL SELECT editor, NULL, 9 FROM _dzhi_fix_animals UNION ALL SELECT editor, NULL, 10 FROM _dzhi_fix_animals UNION ALL SELECT editor, NULL, 11 FROM _dzhi_fix_animals UNION ALL SELECT tourist, NULL, tourist_group FROM _dzhi_fix_animals;Date: 2026-04-02 07:27:27 Database: zemm_produktiv_7 Application: psql User: deploy Remote: [local] Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
5 1 ERROR: invalid UNION/INTERSECT/EXCEPT ORDER BY clause
Times Reported Most Frequent Error / Event #5
Day Hour Count Apr 02 09 1 - ERROR: invalid UNION/INTERSECT/EXCEPT ORDER BY clause
Detail: Only result column names can be used, not expressions or functions.
Hint: Add the expression/function to every SELECT, or move the UNION into a FROM clause.
Statement: SELECT 'all_476' AS bucket, a.deleted, a.alive, a.fate, f.loc, count(*) FROM animals a LEFT JOIN fates f ON f.id = a.fate WHERE a.comments ILIKE '%DZHI-IMPORT-v1 row%' GROUP BY bucket, a.deleted, a.alive, a.fate, f.loc UNION ALL SELECT 'missing_82' AS bucket, a.deleted, a.alive, a.fate, f.loc, count(*) FROM animals a LEFT JOIN fates f ON f.id = a.fate WHERE a.comments ILIKE '%DZHI-IMPORT-v1 row%' AND a.comments NOT LIKE '[DZHI-IMPORT-v1 row%' GROUP BY bucket, a.deleted, a.alive, a.fate, f.loc ORDER BY bucket, count(*) DESC, fate;Date: 2026-04-02 08:19:25 Database: zemm_produktiv_8 Application: psql User: deploy Remote: [local] Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
6 1 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #6
Day Hour Count Apr 02 11 1 - ERROR: relation "logintracker" does not exist
Statement: SELECT DISTINCT lt.user, u.username, u.role, max(lt.timestamp) AS last_seen FROM logintracker lt JOIN users u ON u.id = lt.user WHERE lt.timestamp >= now() - interval '90 days' AND COALESCE(u.deleted, false) = false GROUP BY lt.user, u.username, u.role ORDER BY last_seen DESC LIMIT 20;
Date: 2026-04-02 10:23:32 Database: zemm_produktiv_7 Application: psql User: deploy Remote: [local] Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
7 1 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #7
Day Hour Count Apr 02 14 1 - ERROR: syntax error at or near "BEGIN"
Statement: DO BEGIN;
Date: 2026-04-02 13:52:52 Database: zemm_produktiv_8 Application: psql User: deploy Remote: [local] Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv
8 1 ERROR: canceling statement due to statement timeout
Times Reported Most Frequent Error / Event #8
Day Hour Count Apr 02 11 1 - ERROR: canceling statement due to statement timeout
Context: SQL statement "SELECT COUNT("targetgroupMembers".id) FROM "targetgroupMembers" LEFT JOIN "groupMembers" ON "groupMembers"."group" = "targetgroupMembers"."group" WHERE "targetgroupMembers"."targetgroup" = tgID AND ("targetgroupMembers"."user" = userID OR "groupMembers"."user" = userID)" PL/pgSQL function user_is_tgm(bigint,bigint) line 6 at SQL statement PL/pgSQL function animal_readable(bigint,bigint) line 33 at IF
Statement: WITH recent_users AS ( SELECT DISTINCT ON (lt."user") lt."user" AS user_id, max(lt.timestamp) OVER (PARTITION BY lt."user") AS last_seen FROM login_tracker lt JOIN users u ON u.id = lt."user" WHERE lt.timestamp >= now() - interval '90 days' AND COALESCE(u.deleted,false)=false ORDER BY lt."user", max(lt.timestamp) OVER (PARTITION BY lt."user") DESC ), top_users AS ( SELECT user_id, last_seen FROM recent_users ORDER BY last_seen DESC LIMIT 12 ) SELECT tu.user_id, to_char(tu.last_seen, 'YYYY-MM-DD HH24:MI') AS last_seen, min(u.role) AS role, count(*) FILTER (WHERE a.comments ILIKE '%DZHI-IMPORT-v1 row%' AND animal_readable(a.id, tu.user_id)) AS readable_contains, count(*) FILTER (WHERE a.comments LIKE '[%' AND animal_readable(a.id, tu.user_id)) AS readable_bracket FROM top_users tu JOIN users u ON u.id = tu.user_id JOIN animals a ON true GROUP BY tu.user_id, tu.last_seen ORDER BY tu.last_seen DESC;Date: 2026-04-02 10:32:30 Database: zemm_produktiv_7 Application: psql User: deploy Remote: [local] Log file: /var/log/postgresql/postgresql-2026-04-02_000000.csv