ZEMM PG Report-
Global information
- Generated on Thu Apr 30 06:05:18 2026
- Log file: /var/log/postgresql/postgresql-2026-03-25_000000.csv, ..., /var/log/postgresql/postgresql-2026-04-30_000000.csv
- Parsed 113,666 log entries in 5m17s
- Log start from 2026-03-29 00:00:01 to 2026-03-29 23:59:37
-
Overview
Global Stats
- 25 Number of unique normalized queries
- 17,955 Number of queries
- 4h33m44s Total query duration
- 2026-03-29 00:00:01 First query
- 2026-03-29 23:59:01 Last query
- 13 queries/s at 2026-03-29 06:17:01 Query peak
- 4h33m44s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 4h33m44s Execute total duration
- 13 Number of events
- 4 Number of unique normalized events
- 6 Max number of times the same event was reported
- 0 Number of cancellation
- 20 Total number of automatic vacuums
- 21 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 7,318 Total number of sessions
- 3 sessions at 2026-03-29 20:57:05 Session peak
- 30m49s Total duration of sessions
- 252ms Average duration of sessions
- 2 Average queries per session
- 2s244ms Average queries duration per session
- 0ms Average idle time per session
- 7,324 Total number of connections
- 15 connections/s at 2026-03-29 20:57:05 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 13 queries/s Query Peak
- 2026-03-29 06:17:01 Date
SELECT Traffic
Key values
- 2 queries/s Query Peak
- 2026-03-29 13:06:38 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 13 queries/s Query Peak
- 2026-03-29 06:17:01 Date
Queries duration
Key values
- 4h33m44s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 29 00 780 0ms 0ms 0ms 0ms 0ms 0ms 01 781 0ms 1s281ms 620ms 16s653ms 16s653ms 16s653ms 03 780 1s281ms 1s281ms 1s281ms 16s653ms 16s653ms 16s653ms 04 780 1s281ms 1s281ms 1s281ms 16s653ms 16s653ms 16s653ms 05 780 1s281ms 1s281ms 1s281ms 16s653ms 16s653ms 16s653ms 06 780 1s281ms 1s281ms 1s281ms 16s653ms 16s653ms 16s653ms 07 780 1s281ms 1s281ms 1s281ms 16s653ms 16s653ms 16s653ms 08 780 1s281ms 1s281ms 1s281ms 16s653ms 16s653ms 16s653ms 09 780 1s281ms 1s281ms 1s281ms 16s653ms 16s653ms 16s653ms 10 780 1s281ms 1s281ms 1s281ms 16s653ms 16s653ms 16s653ms 11 780 1s281ms 1s281ms 1s281ms 16s653ms 16s653ms 16s653ms 12 780 1s281ms 1s281ms 1s281ms 16s653ms 16s653ms 16s653ms 13 782 695ms 1s281ms 764ms 16s653ms 16s653ms 18s112ms 14 780 695ms 695ms 695ms 9s47ms 9s47ms 9s47ms 15 780 695ms 695ms 695ms 9s47ms 9s47ms 9s47ms 16 780 695ms 695ms 695ms 9s47ms 9s47ms 9s47ms 17 780 695ms 695ms 695ms 9s47ms 9s47ms 9s47ms 18 780 695ms 695ms 695ms 9s47ms 9s47ms 9s47ms 19 780 695ms 695ms 695ms 9s47ms 9s47ms 9s47ms 20 783 515ms 8s463ms 765ms 13s501ms 13s501ms 22s481ms 21 784 515ms 955ms 669ms 10s725ms 12s422ms 13s926ms 22 780 588ms 588ms 588ms 7s656ms 7s656ms 7s656ms 23 785 543ms 1s981ms 649ms 7s656ms 18s649ms 18s649ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 29 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 2 0 729ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 2 0 777ms 0ms 0ms 515ms 21 3 0 819ms 0ms 0ms 955ms 22 0 0 0ms 0ms 0ms 0ms 23 0 5 1s296ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 29 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 1 0 0 1s281ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Mar 29 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Mar 29 00 281 0.08/s 01 250 0.07/s 03 244 0.07/s 04 244 0.07/s 05 244 0.07/s 06 254 0.07/s 07 252 0.07/s 08 247 0.07/s 09 280 0.08/s 10 342 0.10/s 11 316 0.09/s 12 435 0.12/s 13 384 0.11/s 14 262 0.07/s 15 256 0.07/s 16 251 0.07/s 17 275 0.08/s 18 247 0.07/s 19 273 0.08/s 20 619 0.17/s 21 694 0.19/s 22 335 0.09/s 23 339 0.09/s Day Hour Count Average Duration Average idle time Mar 29 00 280 272ms 272ms 01 250 295ms 0ms 03 244 297ms 0ms 04 244 291ms 0ms 05 244 294ms 0ms 06 254 287ms 0ms 07 252 287ms 0ms 08 247 292ms 0ms 09 278 265ms 0ms 10 342 232ms 0ms 11 316 236ms 0ms 12 435 198ms 0ms 13 384 223ms 0ms 14 262 273ms 0ms 15 256 278ms 0ms 16 251 288ms 0ms 17 275 267ms 0ms 18 247 289ms 0ms 19 273 266ms 0ms 20 616 228ms 0ms 21 694 183ms 0ms 22 335 222ms 0ms 23 339 262ms 0ms -
Connections
Established Connections
Key values
- 15 connections Connection Peak
- 2026-03-29 20:57:05 Date
Connections per database
Key values
- zemm_produktiv_7 Main Database
- 7,324 connections Total
Connections per user
Key values
- labanimal Main User
- 7,324 connections Total
-
Sessions
Simultaneous sessions
Key values
- 3 sessions Session Peak
- 2026-03-29 20:57:05 Date
Histogram of session times
Key values
- 5,891 0-500ms duration
Sessions per database
Key values
- zemm_produktiv_7 Main Database
- 7,318 sessions Total
Sessions per user
Key values
- labanimal Main User
- 7,318 sessions Total
Sessions per host
Key values
- ::1 Main Host
- 7,318 sessions Total
Sessions per application
Key values
- Main Application
- 7,318 sessions Total
Application Count Total Duration Average Duration 6,713 29m20s 262ms _backend_cage_autocomplete_api.php_q_2025_limit_12_zemm_produkt 2 50ms 25ms _backend_cage_autocomplete_api.php_q_55-065_limit_12_zemm_produ 2 46ms 23ms _backend_wean_api.php_litter_id_10130227_zemm_produktiv_7_local 10 1s438ms 143ms _backend_wean_api.php_litter_id_10130236_zemm_produktiv_7_local 9 1s296ms 144ms _backend_wean_api.php_litter_id_10130257_zemm_produktiv_7_local 12 1s737ms 144ms _desktop__zemm_produktiv_7_localhost_5432 4 282ms 70ms _desktop_index.php_command_animals_breedings_subcommand_select_ 2 111ms 55ms _desktop_index.php_command_animals_create_subcommand_init_zemm_ 2 118ms 59ms _desktop_index.php_command_animals_edit_subcommand_link_init_va 2 234ms 117ms _desktop_index.php_command_animals_edit_subcommand_m_init_scree 2 286ms 143ms _desktop_index.php_command_animals_litters_edit_subcommand_init 2 222ms 111ms _desktop_index.php_command_animals_litters_edit_subcommand_m_in 2 661ms 330ms _desktop_index.php_command_animals_litters_subcommand_select_ze 2 96ms 48ms _desktop_index.php_command_animals_subcommand_select_zemm_produ 2 159ms 79ms _desktop_index.php_command_documents_subcommand_edit_id_1010000 1 50ms 50ms _desktop_index.php_command_documents_subcommand_edit_id_21_zemm 1 50ms 50ms _desktop_index.php_command_documents_subcommand_select_zemm_pro 6 284ms 47ms _desktop_index.php_command_licences_subcommand_create_zemm_prod 10 703ms 70ms _desktop_index.php_command_licences_subcommand_edit_id_10100119 1 74ms 74ms _desktop_index.php_command_licences_subcommand_edit_id_1_zemm_p 1 62ms 62ms _desktop_index.php_command_licences_subcommand_init_zemm_produk 1 72ms 72ms _desktop_index.php_command_licences_subcommand_search_zemm_prod 1 66ms 66ms _desktop_index.php_command_licences_subcommand_select_zemm_prod 4 352ms 88ms _desktop_index.php_command_login_subcommand_init_zemm_produktiv 55 1s664ms 30ms _desktop_index.php_command_reports_subcommand_animals_per_room_ 1 135ms 135ms _desktop_index.php_command_reports_subcommand_animals_per_user_ 2 236ms 118ms _desktop_index.php_command_reports_subcommand_fates_zemm_produk 2 261ms 130ms _desktop_index.php_command_reports_subcommand_init_zemm_produkt 4 1s239ms 309ms _desktop_index.php_command_strains_subcommand_init_zemm_produkt 4 331ms 82ms _desktop_index.php_command_tasks_subcommand_edit_id_10134267_ze 2 169ms 84ms _desktop_index.php_command_tasks_subcommand_edit_id_10141778_ze 1 87ms 87ms _desktop_index.php_command_tasks_subcommand_edit_id_10141809_ze 1 87ms 87ms _desktop_index.php_command_tasks_subcommand_edit_id_10141977_ze 1 85ms 85ms _desktop_index.php_command_tasks_subcommand_edit_id_10141978_ze 2 165ms 82ms _desktop_index.php_command_tasks_subcommand_init_search_zemm_pr 2 96ms 48ms _desktop_index.php_command_tasks_subcommand_open_zemm_produktiv 17 1s666ms 98ms _desktop_index.php_command_tasks_subcommand_search_zemm_produkt 2 82ms 41ms _desktop_index.php_m_action_animals_3Am_delete_val4_animals_lis 4 332ms 83ms _desktop_index.php_m_action_documents_3Am_delete_val4_documents 1 49ms 49ms _desktop_index.php_name_Genotypisierungsproben_20genommen_instr 1 57ms 57ms _desktop_index.php_type_1_id_0_parent_0_facility_creator_1_enri 1 43ms 43ms _desktop_index.php_zemm_produktiv_7_localhost_5432 41 17s850ms 435ms _desktop_index.php_zemm_produktiv_8_localhost_5432 269 34s294ms 127ms expire_tasks:zemm_produktiv_8@h2940066.stratoserver.net:5432 1 1s306ms 1s306ms pg_dump 1 13s58ms 13s58ms psql 63 5s27ms 79ms taskscron:zemm_produktiv_7@zemm.fbiscience.eu 23 557ms 24ms taskscron:zemm_produktiv_8@h2940066.stratoserver.net:5432 23 1s865ms 81ms -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 18,566 buffers Checkpoint Peak
- 2026-03-29 01:38:44 Date
- 269.999 seconds Highest write time
- 0.026 seconds Sync time
Checkpoints Wal files
Key values
- 7 files Wal files usage Peak
- 2026-03-29 01:38:44 Date
Checkpoints distance
Key values
- 216.54 Mo Distance Peak
- 2026-03-29 01:38:44 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Mar 29 00 1,930 193.609s 0.067s 193.723s 01 21,938 607.68s 0.083s 607.827s 03 2,162 216.881s 0.072s 217.009s 04 2,072 207.844s 0.072s 207.975s 05 2,091 209.742s 0.074s 209.868s 06 2,444 245.121s 0.075s 245.25s 07 2,155 216.155s 0.074s 216.285s 08 2,156 216.26s 0.072s 216.387s 09 2,180 218.686s 0.075s 218.814s 10 2,467 247.343s 0.084s 247.481s 11 2,166 217.259s 0.074s 217.39s 12 4,319 432.641s 0.097s 432.793s 13 3,683 368.944s 0.088s 369.097s 14 2,127 213.375s 0.071s 213.507s 15 5,530 465.358s 0.075s 465.491s 16 2,203 220.994s 0.075s 221.122s 17 2,451 245.865s 0.076s 246s 18 2,942 294.795s 0.069s 294.917s 19 2,133 213.949s 0.07s 214.074s 20 15,169 465.39s 0.09s 465.527s 21 23,277 830.124s 0.136s 830.317s 22 2,263 227.012s 0.078s 227.144s 23 2,025 203.105s 0.064s 203.218s Day Hour Added Removed Recycled Synced files Longest sync Average sync Mar 29 00 0 0 1 319 0.001s 0.011s 01 0 0 7 408 0.002s 0.013s 03 0 0 1 343 0.001s 0.012s 04 0 0 1 340 0.001s 0.012s 05 0 0 1 344 0.002s 0.012s 06 0 0 1 366 0.002s 0.012s 07 0 0 0 351 0.001s 0.012s 08 0 0 1 349 0.001s 0.012s 09 0 0 1 359 0.002s 0.012s 10 0 0 1 409 0.002s 0.012s 11 0 0 0 379 0.001s 0.012s 12 0 0 2 485 0.002s 0.012s 13 0 0 1 433 0.002s 0.012s 14 0 0 1 355 0.001s 0.012s 15 0 0 1 365 0.002s 0.012s 16 0 0 1 358 0.002s 0.012s 17 0 0 1 381 0.002s 0.012s 18 0 0 1 350 0.001s 0.012s 19 0 0 1 352 0.001s 0.012s 20 0 0 4 476 0.002s 0.01s 21 0 0 8 757 0.003s 0.012s 22 0 0 1 385 0.001s 0.012s 23 0 0 0 326 0.001s 0.011s Day Hour Count Avg time (sec) Mar 29 00 0 0s 01 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Mar 29 00 1,024.82 kB 1,067.73 kB 01 9,666.92 kB 41,396.69 kB 03 1,054.17 kB 35,974.83 kB 04 1,032.42 kB 10,902.83 kB 05 1,023.67 kB 3,816.42 kB 06 1,109.00 kB 1,855.33 kB 07 1,055.25 kB 1,288.17 kB 08 1,052.33 kB 1,122.75 kB 09 1,055.92 kB 1,082.75 kB 10 1,100.08 kB 1,336.83 kB 11 1,036.25 kB 1,142.08 kB 12 2,127.08 kB 4,914.00 kB 13 1,554.33 kB 5,329.83 kB 14 1,046.58 kB 2,336.25 kB 15 1,991.17 kB 5,177.17 kB 16 1,072.67 kB 5,057.33 kB 17 1,107.33 kB 2,217.00 kB 18 1,201.75 kB 2,131.67 kB 19 1,046.75 kB 1,478.50 kB 20 6,979.50 kB 11,925.70 kB 21 11,025.08 kB 43,815.83 kB 22 1,083.17 kB 17,364.00 kB 23 1,062.00 kB 5,870.55 kB -
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Mar 29 00 0 0 0 01 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.63 sec Highest CPU-cost vacuum
Table public.tasks
Database zemm_produktiv_8 - 2026-03-29 01:30:08 Date
- 0 sec Highest CPU-cost analyze
Table
Database zemm_produktiv_8 - Date
Average Autovacuum Duration
Key values
- 0.63 sec Highest CPU-cost vacuum
Table public.tasks
Database zemm_produktiv_8 - 2026-03-29 01:30:08 Date
Analyzes per table
Key values
- pg_catalog.pg_type (4) Main table analyzed (database zemm_produktiv_8)
- 21 analyzes Total
Table Number of analyzes zemm_produktiv_8.pg_catalog.pg_type 4 zemm_produktiv_8.public.breedingsdams 3 zemm_produktiv_8.public.breedingssires 3 zemm_produktiv_8.pg_catalog.pg_attribute 2 zemm_produktiv_8.pg_catalog.pg_class 2 zemm_monitoring.observability.metrics_timeseries 2 zemm_produktiv_8.pg_catalog.pg_depend 1 zemm_produktiv_7.pg_catalog.pg_shdepend 1 zemm_produktiv_8.public.tasks 1 zemm_monitoring.observability.db_top_queries 1 zemm_monitoring.observability.system_metrics 1 Total 21 Vacuums per table
Key values
- pg_toast.pg_toast_67431 (6) Main table vacuumed on database zemm_monitoring
- 20 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples zemm_monitoring.pg_toast.pg_toast_67431 6 0 0 0 0 0 0 4,003 1,344 3,050,604 1,320 7,920 zemm_produktiv_8.public.breedingsdams 3 0 0 0 0 0 0 594 207 709,793 0 0 zemm_produktiv_8.public.breedingssires 3 0 0 0 0 0 0 444 157 525,977 0 0 zemm_produktiv_8.pg_catalog.pg_statistic 1 1 0 0 0 0 0 211 79 254,538 43 145 zemm_produktiv_7.pg_catalog.pg_type 1 1 0 0 0 0 0 31 10 6,134 0 0 bucardo.pg_catalog.pg_shdepend 1 1 0 0 0 0 0 91 30 59,557 0 0 zemm_produktiv_8.public.tasks 1 1 0 0 0 0 0 48,269 27 3,600,029 0 0 zemm_produktiv_8.pg_catalog.pg_type 1 1 0 0 0 0 0 49 5 10,391 0 0 zemm_monitoring.pg_toast.pg_toast_67411 1 0 0 0 0 0 0 4,405 1,381 8,737,520 1,377 6,098 zemm_produktiv_8.pg_catalog.pg_class 1 1 0 0 0 0 0 100 26 28,943 0 0 zemm_monitoring.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 118 28 195,608 13 31 Total 20 7 0 0 0 0 0 58,315 3,294 17,179,094 2,753 14,194 Vacuum throughput per table
Key values
- public.tasks (0.63) Max CPU elapsed for vacuum on database zemm_produktiv_8
- pg_catalog.pg_type (0.313 ms) Max I/O read time for vacuum on database zemm_produktiv_8
- public.breedingssires (0.101 ms) Max I/O write time for vacuum on database zemm_produktiv_8
I/O timing (ms) CPU (s) Table read write elapsed zemm_monitoring.pg_toast.pg_toast_67431 0 0 0.3 zemm_produktiv_8.public.breedingsdams 0 0.046 0 zemm_produktiv_8.public.breedingssires 0 0.101 0 zemm_produktiv_8.pg_catalog.pg_statistic 0 0 0.02 zemm_produktiv_7.pg_catalog.pg_type 0.313 0 0 bucardo.pg_catalog.pg_shdepend 0 0 0 zemm_produktiv_8.public.tasks 0 0 0.63 zemm_produktiv_8.pg_catalog.pg_type 0 0 0 zemm_monitoring.pg_toast.pg_toast_67411 0 0 0.34 zemm_produktiv_8.pg_catalog.pg_class 0 0 0 zemm_monitoring.pg_toast.pg_toast_2619 0 0 0 Total 0.313 0.147 1.29 Tuples removed per table
Key values
- public.tasks (53493) Main table with removed tuples on database zemm_produktiv_8
- 54735 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain zemm_produktiv_8.public.tasks 1 1 53,493 56,567 0 0 16,643 bucardo.pg_catalog.pg_shdepend 1 1 349 3,849 0 0 38 zemm_produktiv_8.pg_catalog.pg_statistic 1 1 289 1,271 0 0 144 zemm_produktiv_8.pg_catalog.pg_type 1 1 198 831 0 0 31 zemm_produktiv_7.pg_catalog.pg_type 1 1 180 831 0 0 27 zemm_produktiv_8.pg_catalog.pg_class 1 1 153 894 0 0 42 zemm_monitoring.pg_toast.pg_toast_2619 1 1 73 81 0 0 37 zemm_monitoring.pg_toast.pg_toast_67431 6 0 0 1,448,472 0 0 242,338 zemm_produktiv_8.public.breedingsdams 3 0 0 91,098 0 0 582 zemm_produktiv_8.public.breedingssires 3 0 0 67,422 0 0 432 zemm_monitoring.pg_toast.pg_toast_67411 1 0 0 55,731 0 0 13,381 Total 20 7 54,735 1,727,047 0 0 273,695 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.pg_catalog.pg_statistic 1 1 289 0 zemm_produktiv_7.pg_catalog.pg_type 1 1 180 0 zemm_monitoring.pg_toast.pg_toast_67431 6 0 0 0 zemm_produktiv_8.public.breedingsdams 3 0 0 0 bucardo.pg_catalog.pg_shdepend 1 1 349 0 zemm_produktiv_8.public.breedingssires 3 0 0 0 zemm_produktiv_8.public.tasks 1 1 53493 0 zemm_produktiv_8.pg_catalog.pg_type 1 1 198 0 zemm_monitoring.pg_toast.pg_toast_67411 1 0 0 0 zemm_produktiv_8.pg_catalog.pg_class 1 1 153 0 zemm_monitoring.pg_toast.pg_toast_2619 1 1 73 0 Total 20 7 54,735 0 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Mar 29 00 0 1 01 2 1 03 0 0 04 0 0 05 0 0 06 1 0 07 0 0 08 0 0 09 0 0 10 1 0 11 0 0 12 1 1 13 1 0 14 0 0 15 0 1 16 0 0 17 1 0 18 1 1 19 0 0 20 4 6 21 8 10 22 0 0 23 0 0 - 0.63 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
- 7 Total read queries
- 17,948 Total write queries
Queries by database
Key values
- zemm_monitoring Main database
- 17,940 Requests
- 4h33m22s (zemm_monitoring)
- Main time consuming database
Queries by user
Key values
- labanimal Main user
- 93,307 Requests
User Request type Count Duration labanimal Total 93,307 1d1h29m55s copy to 8 22s174ms cte 43 1m10s ddl 92,820 1d1h20m1s select 431 8m16s update 5 5s349ms postgres Total 25 32s354ms copy to 25 32s354ms Duration by user
Key values
- 1d1h29m55s (labanimal) Main time consuming user
User Request type Count Duration labanimal Total 93,307 1d1h29m55s copy to 8 22s174ms cte 43 1m10s ddl 92,820 1d1h20m1s select 431 8m16s update 5 5s349ms postgres Total 25 32s354ms copy to 25 32s354ms Queries by host
Key values
- unknown Main host
- 93,302 Requests
- 1d1h29m50s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 17,940 Requests
- 4h33m22s (unknown)
- Main time consuming application
Application Request type Count Duration _desktop_index.php_zemm_produktiv_7_localhost_5432 Total 3 9s804ms cte 2 9s288ms select 1 515ms _desktop_index.php_zemm_produktiv_8_localhost_5432 Total 6 4s957ms select 6 4s957ms expire_tasks:zemm_produktiv_8@h2940066.stratoserver.net:5432 Total 1 1s281ms update 1 1s281ms pg_dump Total 5 6s483ms copy to 5 6s483ms unknown Total 17,940 4h33m22s ddl 17,940 4h33m22s Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-03-29 05:41:02 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 8 500-1000ms duration
Slowest individual queries
Rank Duration Query 1 8s463ms WITH damdam AS ( SELECT breedingid, string_agg(cast(dam as text), ';') AS dam FROM breedingsdams INNER JOIN ( SELECT id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS dam ON dam.id = breedingsdams.dam AND CASE WHEN user_is_tgm (dam.owner, 1) THEN TRUE WHEN user_is_tgm (dam.editor, 1) THEN TRUE WHEN user_is_tgm (dam.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), siresire AS ( SELECT breedingid, string_agg(cast(sire as text), ';') AS sire FROM breedingssires INNER JOIN ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS sire ON sire.id = breedingssires.sire AND CASE WHEN user_is_tgm (sire.owner, 1) THEN TRUE WHEN user_is_tgm (sire.editor, 1) THEN TRUE WHEN user_is_tgm (sire.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);[ Date: 2026-03-29 20:56:27 - Database: zemm_produktiv_7 - User: labanimal - Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 ]
2 1s981ms COPY public.diary (id, "animalID", date, "entrybyID", "cageID", weight, temperature, "fDeprivation", "wDeprivation", "sDeprivation", "feedingClass", health, comments, "breedingInfo", deleted, "inOutDate", "inOutFlag", text, sdesc, treatment, tailcut_id, tailcut_result, file_name, file_content, file_type, upload_name, old_gene_type, old_gene_info, old_gene2_type, old_gene2_info, old_gene3_info, old_gene3_type, old_gene4_info, old_gene4_type, old_gene5_info, old_gene5_type) TO stdout;[ Date: 2026-03-29 23:55:08 - Database: zemm_produktiv_8 - User: postgres - Remote: [local] - Application: pg_dump ]
3 1s434ms COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;[ Date: 2026-03-29 23:55:10 - Database: zemm_produktiv_8 - User: postgres - Remote: [local] - Application: pg_dump ]
4 1s434ms CREATE SCHEMA IF NOT EXISTS observability;[ Date: 2026-03-29 23:56:01 - Database: zemm_monitoring - User: labanimal ]
5 1s434ms CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );[ Date: 2026-03-29 23:56:01 - Database: zemm_monitoring - User: labanimal ]
6 1s434ms CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);[ Date: 2026-03-29 23:56:01 - Database: zemm_monitoring - User: labanimal ]
7 1s434ms CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);[ Date: 2026-03-29 23:56:01 - Database: zemm_monitoring - User: labanimal ]
8 1s434ms CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );[ Date: 2026-03-29 23:56:01 - Database: zemm_monitoring - User: labanimal ]
9 1s434ms CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);[ Date: 2026-03-29 23:56:01 - Database: zemm_monitoring - User: labanimal ]
10 1s434ms CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);[ Date: 2026-03-29 23:56:01 - Database: zemm_monitoring - User: labanimal ]
11 1s434ms CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );[ Date: 2026-03-29 23:56:01 - Database: zemm_monitoring - User: labanimal ]
12 1s434ms CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);[ Date: 2026-03-29 23:56:01 - Database: zemm_monitoring - User: labanimal ]
13 1s434ms CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );[ Date: 2026-03-29 23:56:01 - Database: zemm_monitoring - User: labanimal ]
14 1s434ms CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );[ Date: 2026-03-29 23:56:01 - Database: zemm_monitoring - User: labanimal ]
15 1s434ms CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );[ Date: 2026-03-29 23:56:01 - Database: zemm_monitoring - User: labanimal ]
16 1s434ms CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );[ Date: 2026-03-29 23:56:01 - Database: zemm_monitoring - User: labanimal ]
17 1s434ms CREATE SCHEMA IF NOT EXISTS observability;[ Date: 2026-03-29 23:57:01 - Database: zemm_monitoring - User: labanimal ]
18 1s434ms CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );[ Date: 2026-03-29 23:57:01 - Database: zemm_monitoring - User: labanimal ]
19 1s434ms CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);[ Date: 2026-03-29 23:57:01 - Database: zemm_monitoring - User: labanimal ]
20 1s434ms CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);[ Date: 2026-03-29 23:57:01 - Database: zemm_monitoring - User: labanimal ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 21m1s 1,380 515ms 1s434ms 914ms create schema if not exists observability;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 29 00 60 0ms 0ms 01 60 37s149ms 619ms 04 60 1m16s 1s281ms 05 60 1m16s 1s281ms 06 60 1m16s 1s281ms 07 60 1m16s 1s281ms 08 60 1m16s 1s281ms 09 60 1m16s 1s281ms 10 60 1m16s 1s281ms 11 60 1m16s 1s281ms 12 60 1m16s 1s281ms 13 60 1m16s 1s281ms 14 60 45s854ms 764ms 15 60 41s759ms 695ms 16 60 41s759ms 695ms 17 60 41s759ms 695ms 18 60 41s759ms 695ms 19 60 41s759ms 695ms 20 60 41s759ms 695ms 21 60 45s329ms 755ms 22 60 40s125ms 668ms 23 60 35s338ms 588ms 00 60 38s720ms 645ms [ User: labanimal - Total duration: 21m1s - Times executed: 1289 ]
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-29 23:59:01 Duration: 1s434ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-29 13:06:01 Duration: 1s281ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-29 20:56:01 Duration: 1s38ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
2 21m1s 1,380 515ms 1s434ms 914ms 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 #2
Day Hour Count Duration Avg duration Mar 29 00 60 0ms 0ms 01 60 37s149ms 619ms 04 60 1m16s 1s281ms 05 60 1m16s 1s281ms 06 60 1m16s 1s281ms 07 60 1m16s 1s281ms 08 60 1m16s 1s281ms 09 60 1m16s 1s281ms 10 60 1m16s 1s281ms 11 60 1m16s 1s281ms 12 60 1m16s 1s281ms 13 60 1m16s 1s281ms 14 60 45s854ms 764ms 15 60 41s759ms 695ms 16 60 41s759ms 695ms 17 60 41s759ms 695ms 18 60 41s759ms 695ms 19 60 41s759ms 695ms 20 60 41s759ms 695ms 21 60 45s329ms 755ms 22 60 40s125ms 668ms 23 60 35s338ms 588ms 00 60 38s720ms 645ms [ User: labanimal - Total duration: 21m1s - Times executed: 1289 ]
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-29 23:59:01 Duration: 1s434ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-29 13:06:01 Duration: 1s281ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-29 20:56:01 Duration: 1s38ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
3 21m1s 1,380 515ms 1s434ms 914ms 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 #3
Day Hour Count Duration Avg duration Mar 29 00 60 0ms 0ms 01 60 37s149ms 619ms 04 60 1m16s 1s281ms 05 60 1m16s 1s281ms 06 60 1m16s 1s281ms 07 60 1m16s 1s281ms 08 60 1m16s 1s281ms 09 60 1m16s 1s281ms 10 60 1m16s 1s281ms 11 60 1m16s 1s281ms 12 60 1m16s 1s281ms 13 60 1m16s 1s281ms 14 60 45s854ms 764ms 15 60 41s759ms 695ms 16 60 41s759ms 695ms 17 60 41s759ms 695ms 18 60 41s759ms 695ms 19 60 41s759ms 695ms 20 60 41s759ms 695ms 21 60 45s329ms 755ms 22 60 40s125ms 668ms 23 60 35s338ms 588ms 00 60 38s720ms 645ms [ User: labanimal - Total duration: 21m1s - Times executed: 1289 ]
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-29 23:59:01 Duration: 1s434ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-29 13:06:01 Duration: 1s281ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-29 20:56:01 Duration: 1s38ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
4 21m1s 1,380 515ms 1s434ms 914ms 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 #4
Day Hour Count Duration Avg duration Mar 29 00 60 0ms 0ms 01 60 37s149ms 619ms 04 60 1m16s 1s281ms 05 60 1m16s 1s281ms 06 60 1m16s 1s281ms 07 60 1m16s 1s281ms 08 60 1m16s 1s281ms 09 60 1m16s 1s281ms 10 60 1m16s 1s281ms 11 60 1m16s 1s281ms 12 60 1m16s 1s281ms 13 60 1m16s 1s281ms 14 60 45s854ms 764ms 15 60 41s759ms 695ms 16 60 41s759ms 695ms 17 60 41s759ms 695ms 18 60 41s759ms 695ms 19 60 41s759ms 695ms 20 60 41s759ms 695ms 21 60 45s329ms 755ms 22 60 40s125ms 668ms 23 60 35s338ms 588ms 00 60 38s720ms 645ms [ User: labanimal - Total duration: 21m1s - Times executed: 1289 ]
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-03-29 23:59:01 Duration: 1s434ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-03-29 13:06:01 Duration: 1s281ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-03-29 20:56:01 Duration: 1s38ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
5 21m1s 1,380 515ms 1s434ms 914ms create index if not exists idx_app_events_type on observability.app_events (event_type);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Mar 29 00 60 0ms 0ms 01 60 37s149ms 619ms 04 60 1m16s 1s281ms 05 60 1m16s 1s281ms 06 60 1m16s 1s281ms 07 60 1m16s 1s281ms 08 60 1m16s 1s281ms 09 60 1m16s 1s281ms 10 60 1m16s 1s281ms 11 60 1m16s 1s281ms 12 60 1m16s 1s281ms 13 60 1m16s 1s281ms 14 60 45s854ms 764ms 15 60 41s759ms 695ms 16 60 41s759ms 695ms 17 60 41s759ms 695ms 18 60 41s759ms 695ms 19 60 41s759ms 695ms 20 60 41s759ms 695ms 21 60 45s329ms 755ms 22 60 40s125ms 668ms 23 60 35s338ms 588ms 00 60 38s720ms 645ms [ User: labanimal - Total duration: 21m1s - Times executed: 1289 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-29 23:59:01 Duration: 1s434ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-29 13:06:01 Duration: 1s281ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-29 20:56:01 Duration: 1s38ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
6 21m1s 1,380 515ms 1s434ms 914ms 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 #6
Day Hour Count Duration Avg duration Mar 29 00 60 0ms 0ms 01 60 37s149ms 619ms 04 60 1m16s 1s281ms 05 60 1m16s 1s281ms 06 60 1m16s 1s281ms 07 60 1m16s 1s281ms 08 60 1m16s 1s281ms 09 60 1m16s 1s281ms 10 60 1m16s 1s281ms 11 60 1m16s 1s281ms 12 60 1m16s 1s281ms 13 60 1m16s 1s281ms 14 60 45s854ms 764ms 15 60 41s759ms 695ms 16 60 41s759ms 695ms 17 60 41s759ms 695ms 18 60 41s759ms 695ms 19 60 41s759ms 695ms 20 60 41s759ms 695ms 21 60 45s329ms 755ms 22 60 40s125ms 668ms 23 60 35s338ms 588ms 00 60 38s720ms 645ms [ User: labanimal - Total duration: 21m1s - Times executed: 1289 ]
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-29 23:59:01 Duration: 1s434ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-29 13:06:01 Duration: 1s281ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-29 20:56:01 Duration: 1s38ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
7 21m1s 1,380 515ms 1s434ms 914ms create index if not exists idx_app_events_tenant on observability.app_events (tenant_key, occurred_at desc);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Mar 29 00 60 0ms 0ms 01 60 37s149ms 619ms 04 60 1m16s 1s281ms 05 60 1m16s 1s281ms 06 60 1m16s 1s281ms 07 60 1m16s 1s281ms 08 60 1m16s 1s281ms 09 60 1m16s 1s281ms 10 60 1m16s 1s281ms 11 60 1m16s 1s281ms 12 60 1m16s 1s281ms 13 60 1m16s 1s281ms 14 60 45s854ms 764ms 15 60 41s759ms 695ms 16 60 41s759ms 695ms 17 60 41s759ms 695ms 18 60 41s759ms 695ms 19 60 41s759ms 695ms 20 60 41s759ms 695ms 21 60 45s329ms 755ms 22 60 40s125ms 668ms 23 60 35s338ms 588ms 00 60 38s720ms 645ms [ User: labanimal - Total duration: 21m1s - Times executed: 1289 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-29 23:59:01 Duration: 1s434ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-29 13:06:01 Duration: 1s281ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-29 20:56:01 Duration: 1s38ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
8 21m1s 1,380 515ms 1s434ms 914ms 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 Mar 29 00 60 0ms 0ms 01 60 37s149ms 619ms 04 60 1m16s 1s281ms 05 60 1m16s 1s281ms 06 60 1m16s 1s281ms 07 60 1m16s 1s281ms 08 60 1m16s 1s281ms 09 60 1m16s 1s281ms 10 60 1m16s 1s281ms 11 60 1m16s 1s281ms 12 60 1m16s 1s281ms 13 60 1m16s 1s281ms 14 60 45s854ms 764ms 15 60 41s759ms 695ms 16 60 41s759ms 695ms 17 60 41s759ms 695ms 18 60 41s759ms 695ms 19 60 41s759ms 695ms 20 60 41s759ms 695ms 21 60 45s329ms 755ms 22 60 40s125ms 668ms 23 60 35s338ms 588ms 00 60 38s720ms 645ms [ User: labanimal - Total duration: 21m1s - Times executed: 1289 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-29 23:59:01 Duration: 1s434ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-29 13:06:01 Duration: 1s281ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-29 20:56:01 Duration: 1s38ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
9 21m1s 1,380 515ms 1s434ms 914ms create index if not exists idx_metrics_timeseries_metric on observability.metrics_timeseries (metric_name);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Mar 29 00 60 0ms 0ms 01 60 37s149ms 619ms 04 60 1m16s 1s281ms 05 60 1m16s 1s281ms 06 60 1m16s 1s281ms 07 60 1m16s 1s281ms 08 60 1m16s 1s281ms 09 60 1m16s 1s281ms 10 60 1m16s 1s281ms 11 60 1m16s 1s281ms 12 60 1m16s 1s281ms 13 60 1m16s 1s281ms 14 60 45s854ms 764ms 15 60 41s759ms 695ms 16 60 41s759ms 695ms 17 60 41s759ms 695ms 18 60 41s759ms 695ms 19 60 41s759ms 695ms 20 60 41s759ms 695ms 21 60 45s329ms 755ms 22 60 40s125ms 668ms 23 60 35s338ms 588ms 00 60 38s720ms 645ms [ User: labanimal - Total duration: 21m1s - Times executed: 1289 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-29 23:59:01 Duration: 1s434ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-29 13:06:01 Duration: 1s281ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-29 20:56:01 Duration: 1s38ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
10 21m1s 1,380 515ms 1s434ms 914ms create table if not exists observability.uptime_checks ( id bigserial primary key, endpoint text not null, status text not null, latency_ms double precision, checked_at timestamptz not null default now() );Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Mar 29 00 60 0ms 0ms 01 60 37s149ms 619ms 04 60 1m16s 1s281ms 05 60 1m16s 1s281ms 06 60 1m16s 1s281ms 07 60 1m16s 1s281ms 08 60 1m16s 1s281ms 09 60 1m16s 1s281ms 10 60 1m16s 1s281ms 11 60 1m16s 1s281ms 12 60 1m16s 1s281ms 13 60 1m16s 1s281ms 14 60 45s854ms 764ms 15 60 41s759ms 695ms 16 60 41s759ms 695ms 17 60 41s759ms 695ms 18 60 41s759ms 695ms 19 60 41s759ms 695ms 20 60 41s759ms 695ms 21 60 45s329ms 755ms 22 60 40s125ms 668ms 23 60 35s338ms 588ms 00 60 38s720ms 645ms [ User: labanimal - Total duration: 21m1s - Times executed: 1289 ]
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-29 23:59:01 Duration: 1s434ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-29 13:06:01 Duration: 1s281ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-29 20:56:01 Duration: 1s38ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
11 21m1s 1,380 515ms 1s434ms 914ms 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 Mar 29 00 60 0ms 0ms 01 60 37s149ms 619ms 04 60 1m16s 1s281ms 05 60 1m16s 1s281ms 06 60 1m16s 1s281ms 07 60 1m16s 1s281ms 08 60 1m16s 1s281ms 09 60 1m16s 1s281ms 10 60 1m16s 1s281ms 11 60 1m16s 1s281ms 12 60 1m16s 1s281ms 13 60 1m16s 1s281ms 14 60 45s854ms 764ms 15 60 41s759ms 695ms 16 60 41s759ms 695ms 17 60 41s759ms 695ms 18 60 41s759ms 695ms 19 60 41s759ms 695ms 20 60 41s759ms 695ms 21 60 45s329ms 755ms 22 60 40s125ms 668ms 23 60 35s338ms 588ms 00 60 38s720ms 645ms [ User: labanimal - Total duration: 21m1s - Times executed: 1289 ]
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-03-29 23:59:01 Duration: 1s434ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-03-29 13:06:01 Duration: 1s281ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-03-29 20:56:01 Duration: 1s38ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
12 21m1s 1,380 515ms 1s434ms 914ms 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 #12
Day Hour Count Duration Avg duration Mar 29 00 60 0ms 0ms 01 60 37s149ms 619ms 04 60 1m16s 1s281ms 05 60 1m16s 1s281ms 06 60 1m16s 1s281ms 07 60 1m16s 1s281ms 08 60 1m16s 1s281ms 09 60 1m16s 1s281ms 10 60 1m16s 1s281ms 11 60 1m16s 1s281ms 12 60 1m16s 1s281ms 13 60 1m16s 1s281ms 14 60 45s854ms 764ms 15 60 41s759ms 695ms 16 60 41s759ms 695ms 17 60 41s759ms 695ms 18 60 41s759ms 695ms 19 60 41s759ms 695ms 20 60 41s759ms 695ms 21 60 45s329ms 755ms 22 60 40s125ms 668ms 23 60 35s338ms 588ms 00 60 38s720ms 645ms [ User: labanimal - Total duration: 21m1s - Times executed: 1289 ]
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-29 23:59:01 Duration: 1s434ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-29 13:06:01 Duration: 1s281ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-29 20:56:01 Duration: 1s38ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
13 21m1s 1,380 515ms 1s434ms 914ms create table if not exists observability.phpfpm_counters ( id bigserial primary key, payload jsonb not null, collected_at timestamptz not null default now() );Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Mar 29 00 60 0ms 0ms 01 60 37s149ms 619ms 04 60 1m16s 1s281ms 05 60 1m16s 1s281ms 06 60 1m16s 1s281ms 07 60 1m16s 1s281ms 08 60 1m16s 1s281ms 09 60 1m16s 1s281ms 10 60 1m16s 1s281ms 11 60 1m16s 1s281ms 12 60 1m16s 1s281ms 13 60 1m16s 1s281ms 14 60 45s854ms 764ms 15 60 41s759ms 695ms 16 60 41s759ms 695ms 17 60 41s759ms 695ms 18 60 41s759ms 695ms 19 60 41s759ms 695ms 20 60 41s759ms 695ms 21 60 45s329ms 755ms 22 60 40s125ms 668ms 23 60 35s338ms 588ms 00 60 38s720ms 645ms [ User: labanimal - Total duration: 21m1s - Times executed: 1289 ]
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-29 23:59:01 Duration: 1s434ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-29 13:06:01 Duration: 1s281ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-29 20:56:01 Duration: 1s38ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
14 9s288ms 2 825ms 8s463ms 4s644ms with damdam as ( select breedingid, string_agg(cast(dam as text), ?) as dam from breedingsdams inner join ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" from animals) as dam on dam.id = breedingsdams.dam and case when user_is_tgm (dam.owner, ?) then true when user_is_tgm (dam.editor, ?) then true when user_is_tgm (dam.tourist, ?) then true else false end group by breedingid ), siresire as ( select breedingid, string_agg(cast(sire as text), ?) as sire from breedingssires inner join ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" from animals) as sire on sire.id = breedingssires.sire and case when user_is_tgm (sire.owner, ?) then true when user_is_tgm (sire.editor, ?) then true when user_is_tgm (sire.tourist, ?) then true else false end group by breedingid ), cagess as ( select id, "cageName" from cages) ( select breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire from damdam, siresire, cagess, breedings where breedings.deleted != true and cagess.id = breedings.cage and damdam.breedingid = breedings.id and siresire.breedingid = breedings.id and breedings."unbreeding_date" is null group by breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire order by breeding_date, plug_date);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Mar 29 21 1 8s463ms 8s463ms 22 1 825ms 825ms [ User: labanimal - Total duration: 9s288ms - Times executed: 2 ]
[ Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 - Total duration: 9s288ms - Times executed: 2 ]
-
WITH damdam AS ( SELECT breedingid, string_agg(cast(dam as text), ';') AS dam FROM breedingsdams INNER JOIN ( SELECT id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS dam ON dam.id = breedingsdams.dam AND CASE WHEN user_is_tgm (dam.owner, 1) THEN TRUE WHEN user_is_tgm (dam.editor, 1) THEN TRUE WHEN user_is_tgm (dam.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), siresire AS ( SELECT breedingid, string_agg(cast(sire as text), ';') AS sire FROM breedingssires INNER JOIN ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS sire ON sire.id = breedingssires.sire AND CASE WHEN user_is_tgm (sire.owner, 1) THEN TRUE WHEN user_is_tgm (sire.editor, 1) THEN TRUE WHEN user_is_tgm (sire.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-03-29 20:56:27 Duration: 8s463ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
WITH damdam AS ( SELECT breedingid, string_agg(cast(dam as text), ';') AS dam FROM breedingsdams INNER JOIN ( SELECT id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS dam ON dam.id = breedingsdams.dam AND CASE WHEN user_is_tgm (dam.owner, 1) THEN TRUE WHEN user_is_tgm (dam.editor, 1) THEN TRUE WHEN user_is_tgm (dam.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), siresire AS ( SELECT breedingid, string_agg(cast(sire as text), ';') AS sire FROM breedingssires INNER JOIN ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS sire ON sire.id = breedingssires.sire AND CASE WHEN user_is_tgm (sire.owner, 1) THEN TRUE WHEN user_is_tgm (sire.editor, 1) THEN TRUE WHEN user_is_tgm (sire.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-03-29 21:03:00 Duration: 825ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
15 2s909ms 3 915ms 1s38ms 969ms select p_update_breedings (?, null, ?, ?::date, null, ?::text, ?::text, null) as id;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Mar 29 21 1 1s38ms 1s38ms 22 2 1s870ms 935ms [ User: labanimal - Total duration: 2s909ms - Times executed: 3 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 2s909ms - Times executed: 3 ]
-
SELECT p_update_breedings (456, NULL, 16033, '2026-03-27'::date, NULL, '10294343'::text, '10296206'::text, NULL) AS id;
Date: 2026-03-29 20:44:20 Duration: 1s38ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
SELECT p_update_breedings (456, NULL, 10384, '2026-03-29'::date, NULL, '10293011'::text, '10293010'::text, NULL) AS id;
Date: 2026-03-29 21:18:00 Duration: 955ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
SELECT p_update_breedings (456, NULL, 10346, '2026-03-29'::date, NULL, '10293019'::text, '10293020'::text, NULL) AS id;
Date: 2026-03-29 21:21:55 Duration: 915ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
16 1s981ms 1 1s981ms 1s981ms 1s981ms 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 #16
Day Hour Count Duration Avg duration Mar 29 00 1 1s981ms 1s981ms [ User: postgres - Total duration: 1s981ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s981ms - Times executed: 1 ]
-
COPY public.diary (id, "animalID", date, "entrybyID", "cageID", weight, temperature, "fDeprivation", "wDeprivation", "sDeprivation", "feedingClass", health, comments, "breedingInfo", deleted, "inOutDate", "inOutFlag", text, sdesc, treatment, tailcut_id, tailcut_result, file_name, file_content, file_type, upload_name, old_gene_type, old_gene_info, old_gene2_type, old_gene2_info, old_gene3_info, old_gene3_type, old_gene4_info, old_gene4_type, old_gene5_info, old_gene5_type) TO stdout;
Date: 2026-03-29 23:55:08 Duration: 1s981ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
17 1s434ms 1 1s434ms 1s434ms 1s434ms copy public."targetgroupMembers" (id, targetgroup, "user", "group") to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Mar 29 00 1 1s434ms 1s434ms [ User: postgres - Total duration: 1s434ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s434ms - Times executed: 1 ]
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-03-29 23:55:10 Duration: 1s434ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
18 1s309ms 1 1s309ms 1s309ms 1s309ms copy public.animals_search_mview (id, name, animal_id, deleted, alive, birth_date, arrival_date, death_date, outgoing_date, cage, comments, sterile, breeding, fate, last_mating, last_mating_date, breeding_cage, sex, strain, line, gene_1_info, gene_1_type, gene_2_info, gene_2_type, gene_3_info, gene_3_type, gene_4_info, gene_4_type, gene_5_info, gene_5_type, backcross, generation, project, project_name, species, species_name, cage_name, location, location_name, dam, dam_name, dam_id, sire, sire_name, sire_id, cohort, litter, rfid, owner, editor, tourist, breeding_status, workgroup_infos, experiment, experiment_name) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Mar 29 00 1 1s309ms 1s309ms [ User: postgres - Total duration: 1s309ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s309ms - Times executed: 1 ]
-
COPY public.animals_search_mview (id, name, animal_id, deleted, alive, birth_date, arrival_date, death_date, outgoing_date, cage, comments, sterile, breeding, fate, last_mating, last_mating_date, breeding_cage, sex, strain, line, gene_1_info, gene_1_type, gene_2_info, gene_2_type, gene_3_info, gene_3_type, gene_4_info, gene_4_type, gene_5_info, gene_5_type, backcross, generation, project, project_name, species, species_name, cage_name, location, location_name, dam, dam_name, dam_id, sire, sire_name, sire_id, cohort, litter, rfid, owner, editor, tourist, breeding_status, workgroup_infos, experiment, experiment_name) TO stdout;
Date: 2026-03-29 23:55:05 Duration: 1s309ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
19 1s281ms 1 1s281ms 1s281ms 1s281ms update tasks set task_status = ? where time_completed < now() - interval ? month;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 29 01 1 1s281ms 1s281ms [ User: labanimal - Total duration: 1s281ms - Times executed: 1 ]
[ Application: expire_tasks:zemm_produktiv_8@h2940066.stratoserver.net:5432 - Total duration: 1s281ms - Times executed: 1 ]
-
UPDATE tasks SET task_status = '7' WHERE time_completed < now() - interval '1' month;
Date: 2026-03-29 01:30:03 Duration: 1s281ms Database: zemm_produktiv_8 User: labanimal Remote: 81.169.238.237 Application: expire_tasks:zemm_produktiv_8@h2940066.stratoserver.net:5432 Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
20 1s214ms 1 1s214ms 1s214ms 1s214ms copy public.animals (id, species, transgen, "homeCage", tourist, editor, owner, comments, pregnant, name, sex, "standardDescription", "parentFemale", "parentMale", "parentFoster", colour, "plannedUseFor", deleted, generation, chimare, "birthDate", "arrivalDate", "outgoingDate", "deathDate", breedstatus_2, "healthState", breeder, restrictions, "geneStatus", "geneFlanking", "geneDeleted", "fromOrder_2", "group", "fromOrder", strain, "breedStatus", "FEMnumber", genotype, inbreeding, identification, jax, "KOgene", "feedingClass", dummy_gen_info, breeding, sterile, project, dummy_line_info, dummy_strain_info, "bredWith", "curCage", dummy_backcross_info, fate, "fateComment", alive, reciever, "animalID", litter, weight_at_arrival, cohort, gen_2_info, gen_3_info, gen_4_info, gen_5_info, gen_1_typ, gen_2_typ, gen_3_typ, gen_4_typ, gen_5_typ, "latestMatingDate", "latestMating", genecomment, recycle) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 29 00 1 1s214ms 1s214ms [ User: postgres - Total duration: 1s214ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s214ms - Times executed: 1 ]
-
COPY public.animals (id, species, transgen, "homeCage", tourist, editor, owner, comments, pregnant, name, sex, "standardDescription", "parentFemale", "parentMale", "parentFoster", colour, "plannedUseFor", deleted, generation, chimare, "birthDate", "arrivalDate", "outgoingDate", "deathDate", breedstatus_2, "healthState", breeder, restrictions, "geneStatus", "geneFlanking", "geneDeleted", "fromOrder_2", "group", "fromOrder", strain, "breedStatus", "FEMnumber", genotype, inbreeding, identification, jax, "KOgene", "feedingClass", dummy_gen_info, breeding, sterile, project, dummy_line_info, dummy_strain_info, "bredWith", "curCage", dummy_backcross_info, fate, "fateComment", alive, reciever, "animalID", litter, weight_at_arrival, cohort, gen_2_info, gen_3_info, gen_4_info, gen_5_info, gen_1_typ, gen_2_typ, gen_3_typ, gen_4_typ, gen_5_typ, "latestMatingDate", "latestMating", genecomment, recycle) TO stdout;
Date: 2026-03-29 23:55:03 Duration: 1s214ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,380 21m1s 515ms 1s434ms 914ms create schema if not exists observability;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 29 00 60 0ms 0ms 01 60 37s149ms 619ms 04 60 1m16s 1s281ms 05 60 1m16s 1s281ms 06 60 1m16s 1s281ms 07 60 1m16s 1s281ms 08 60 1m16s 1s281ms 09 60 1m16s 1s281ms 10 60 1m16s 1s281ms 11 60 1m16s 1s281ms 12 60 1m16s 1s281ms 13 60 1m16s 1s281ms 14 60 45s854ms 764ms 15 60 41s759ms 695ms 16 60 41s759ms 695ms 17 60 41s759ms 695ms 18 60 41s759ms 695ms 19 60 41s759ms 695ms 20 60 41s759ms 695ms 21 60 45s329ms 755ms 22 60 40s125ms 668ms 23 60 35s338ms 588ms 00 60 38s720ms 645ms [ User: labanimal - Total duration: 21m1s - Times executed: 1289 ]
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-29 23:59:01 Duration: 1s434ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-29 13:06:01 Duration: 1s281ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-29 20:56:01 Duration: 1s38ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
2 1,380 21m1s 515ms 1s434ms 914ms 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 #2
Day Hour Count Duration Avg duration Mar 29 00 60 0ms 0ms 01 60 37s149ms 619ms 04 60 1m16s 1s281ms 05 60 1m16s 1s281ms 06 60 1m16s 1s281ms 07 60 1m16s 1s281ms 08 60 1m16s 1s281ms 09 60 1m16s 1s281ms 10 60 1m16s 1s281ms 11 60 1m16s 1s281ms 12 60 1m16s 1s281ms 13 60 1m16s 1s281ms 14 60 45s854ms 764ms 15 60 41s759ms 695ms 16 60 41s759ms 695ms 17 60 41s759ms 695ms 18 60 41s759ms 695ms 19 60 41s759ms 695ms 20 60 41s759ms 695ms 21 60 45s329ms 755ms 22 60 40s125ms 668ms 23 60 35s338ms 588ms 00 60 38s720ms 645ms [ User: labanimal - Total duration: 21m1s - Times executed: 1289 ]
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-29 23:59:01 Duration: 1s434ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-29 13:06:01 Duration: 1s281ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-29 20:56:01 Duration: 1s38ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
3 1,380 21m1s 515ms 1s434ms 914ms 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 #3
Day Hour Count Duration Avg duration Mar 29 00 60 0ms 0ms 01 60 37s149ms 619ms 04 60 1m16s 1s281ms 05 60 1m16s 1s281ms 06 60 1m16s 1s281ms 07 60 1m16s 1s281ms 08 60 1m16s 1s281ms 09 60 1m16s 1s281ms 10 60 1m16s 1s281ms 11 60 1m16s 1s281ms 12 60 1m16s 1s281ms 13 60 1m16s 1s281ms 14 60 45s854ms 764ms 15 60 41s759ms 695ms 16 60 41s759ms 695ms 17 60 41s759ms 695ms 18 60 41s759ms 695ms 19 60 41s759ms 695ms 20 60 41s759ms 695ms 21 60 45s329ms 755ms 22 60 40s125ms 668ms 23 60 35s338ms 588ms 00 60 38s720ms 645ms [ User: labanimal - Total duration: 21m1s - Times executed: 1289 ]
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-29 23:59:01 Duration: 1s434ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-29 13:06:01 Duration: 1s281ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-29 20:56:01 Duration: 1s38ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
4 1,380 21m1s 515ms 1s434ms 914ms 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 #4
Day Hour Count Duration Avg duration Mar 29 00 60 0ms 0ms 01 60 37s149ms 619ms 04 60 1m16s 1s281ms 05 60 1m16s 1s281ms 06 60 1m16s 1s281ms 07 60 1m16s 1s281ms 08 60 1m16s 1s281ms 09 60 1m16s 1s281ms 10 60 1m16s 1s281ms 11 60 1m16s 1s281ms 12 60 1m16s 1s281ms 13 60 1m16s 1s281ms 14 60 45s854ms 764ms 15 60 41s759ms 695ms 16 60 41s759ms 695ms 17 60 41s759ms 695ms 18 60 41s759ms 695ms 19 60 41s759ms 695ms 20 60 41s759ms 695ms 21 60 45s329ms 755ms 22 60 40s125ms 668ms 23 60 35s338ms 588ms 00 60 38s720ms 645ms [ User: labanimal - Total duration: 21m1s - Times executed: 1289 ]
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-03-29 23:59:01 Duration: 1s434ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-03-29 13:06:01 Duration: 1s281ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-03-29 20:56:01 Duration: 1s38ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
5 1,380 21m1s 515ms 1s434ms 914ms create index if not exists idx_app_events_type on observability.app_events (event_type);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Mar 29 00 60 0ms 0ms 01 60 37s149ms 619ms 04 60 1m16s 1s281ms 05 60 1m16s 1s281ms 06 60 1m16s 1s281ms 07 60 1m16s 1s281ms 08 60 1m16s 1s281ms 09 60 1m16s 1s281ms 10 60 1m16s 1s281ms 11 60 1m16s 1s281ms 12 60 1m16s 1s281ms 13 60 1m16s 1s281ms 14 60 45s854ms 764ms 15 60 41s759ms 695ms 16 60 41s759ms 695ms 17 60 41s759ms 695ms 18 60 41s759ms 695ms 19 60 41s759ms 695ms 20 60 41s759ms 695ms 21 60 45s329ms 755ms 22 60 40s125ms 668ms 23 60 35s338ms 588ms 00 60 38s720ms 645ms [ User: labanimal - Total duration: 21m1s - Times executed: 1289 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-29 23:59:01 Duration: 1s434ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-29 13:06:01 Duration: 1s281ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-29 20:56:01 Duration: 1s38ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
6 1,380 21m1s 515ms 1s434ms 914ms 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 #6
Day Hour Count Duration Avg duration Mar 29 00 60 0ms 0ms 01 60 37s149ms 619ms 04 60 1m16s 1s281ms 05 60 1m16s 1s281ms 06 60 1m16s 1s281ms 07 60 1m16s 1s281ms 08 60 1m16s 1s281ms 09 60 1m16s 1s281ms 10 60 1m16s 1s281ms 11 60 1m16s 1s281ms 12 60 1m16s 1s281ms 13 60 1m16s 1s281ms 14 60 45s854ms 764ms 15 60 41s759ms 695ms 16 60 41s759ms 695ms 17 60 41s759ms 695ms 18 60 41s759ms 695ms 19 60 41s759ms 695ms 20 60 41s759ms 695ms 21 60 45s329ms 755ms 22 60 40s125ms 668ms 23 60 35s338ms 588ms 00 60 38s720ms 645ms [ User: labanimal - Total duration: 21m1s - Times executed: 1289 ]
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-29 23:59:01 Duration: 1s434ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-29 13:06:01 Duration: 1s281ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-29 20:56:01 Duration: 1s38ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
7 1,380 21m1s 515ms 1s434ms 914ms create index if not exists idx_app_events_tenant on observability.app_events (tenant_key, occurred_at desc);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Mar 29 00 60 0ms 0ms 01 60 37s149ms 619ms 04 60 1m16s 1s281ms 05 60 1m16s 1s281ms 06 60 1m16s 1s281ms 07 60 1m16s 1s281ms 08 60 1m16s 1s281ms 09 60 1m16s 1s281ms 10 60 1m16s 1s281ms 11 60 1m16s 1s281ms 12 60 1m16s 1s281ms 13 60 1m16s 1s281ms 14 60 45s854ms 764ms 15 60 41s759ms 695ms 16 60 41s759ms 695ms 17 60 41s759ms 695ms 18 60 41s759ms 695ms 19 60 41s759ms 695ms 20 60 41s759ms 695ms 21 60 45s329ms 755ms 22 60 40s125ms 668ms 23 60 35s338ms 588ms 00 60 38s720ms 645ms [ User: labanimal - Total duration: 21m1s - Times executed: 1289 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-29 23:59:01 Duration: 1s434ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-29 13:06:01 Duration: 1s281ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-29 20:56:01 Duration: 1s38ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
8 1,380 21m1s 515ms 1s434ms 914ms 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 Mar 29 00 60 0ms 0ms 01 60 37s149ms 619ms 04 60 1m16s 1s281ms 05 60 1m16s 1s281ms 06 60 1m16s 1s281ms 07 60 1m16s 1s281ms 08 60 1m16s 1s281ms 09 60 1m16s 1s281ms 10 60 1m16s 1s281ms 11 60 1m16s 1s281ms 12 60 1m16s 1s281ms 13 60 1m16s 1s281ms 14 60 45s854ms 764ms 15 60 41s759ms 695ms 16 60 41s759ms 695ms 17 60 41s759ms 695ms 18 60 41s759ms 695ms 19 60 41s759ms 695ms 20 60 41s759ms 695ms 21 60 45s329ms 755ms 22 60 40s125ms 668ms 23 60 35s338ms 588ms 00 60 38s720ms 645ms [ User: labanimal - Total duration: 21m1s - Times executed: 1289 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-29 23:59:01 Duration: 1s434ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-29 13:06:01 Duration: 1s281ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-29 20:56:01 Duration: 1s38ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
9 1,380 21m1s 515ms 1s434ms 914ms create index if not exists idx_metrics_timeseries_metric on observability.metrics_timeseries (metric_name);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Mar 29 00 60 0ms 0ms 01 60 37s149ms 619ms 04 60 1m16s 1s281ms 05 60 1m16s 1s281ms 06 60 1m16s 1s281ms 07 60 1m16s 1s281ms 08 60 1m16s 1s281ms 09 60 1m16s 1s281ms 10 60 1m16s 1s281ms 11 60 1m16s 1s281ms 12 60 1m16s 1s281ms 13 60 1m16s 1s281ms 14 60 45s854ms 764ms 15 60 41s759ms 695ms 16 60 41s759ms 695ms 17 60 41s759ms 695ms 18 60 41s759ms 695ms 19 60 41s759ms 695ms 20 60 41s759ms 695ms 21 60 45s329ms 755ms 22 60 40s125ms 668ms 23 60 35s338ms 588ms 00 60 38s720ms 645ms [ User: labanimal - Total duration: 21m1s - Times executed: 1289 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-29 23:59:01 Duration: 1s434ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-29 13:06:01 Duration: 1s281ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-29 20:56:01 Duration: 1s38ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
10 1,380 21m1s 515ms 1s434ms 914ms create table if not exists observability.uptime_checks ( id bigserial primary key, endpoint text not null, status text not null, latency_ms double precision, checked_at timestamptz not null default now() );Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Mar 29 00 60 0ms 0ms 01 60 37s149ms 619ms 04 60 1m16s 1s281ms 05 60 1m16s 1s281ms 06 60 1m16s 1s281ms 07 60 1m16s 1s281ms 08 60 1m16s 1s281ms 09 60 1m16s 1s281ms 10 60 1m16s 1s281ms 11 60 1m16s 1s281ms 12 60 1m16s 1s281ms 13 60 1m16s 1s281ms 14 60 45s854ms 764ms 15 60 41s759ms 695ms 16 60 41s759ms 695ms 17 60 41s759ms 695ms 18 60 41s759ms 695ms 19 60 41s759ms 695ms 20 60 41s759ms 695ms 21 60 45s329ms 755ms 22 60 40s125ms 668ms 23 60 35s338ms 588ms 00 60 38s720ms 645ms [ User: labanimal - Total duration: 21m1s - Times executed: 1289 ]
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-29 23:59:01 Duration: 1s434ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-29 13:06:01 Duration: 1s281ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-29 20:56:01 Duration: 1s38ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
11 1,380 21m1s 515ms 1s434ms 914ms 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 Mar 29 00 60 0ms 0ms 01 60 37s149ms 619ms 04 60 1m16s 1s281ms 05 60 1m16s 1s281ms 06 60 1m16s 1s281ms 07 60 1m16s 1s281ms 08 60 1m16s 1s281ms 09 60 1m16s 1s281ms 10 60 1m16s 1s281ms 11 60 1m16s 1s281ms 12 60 1m16s 1s281ms 13 60 1m16s 1s281ms 14 60 45s854ms 764ms 15 60 41s759ms 695ms 16 60 41s759ms 695ms 17 60 41s759ms 695ms 18 60 41s759ms 695ms 19 60 41s759ms 695ms 20 60 41s759ms 695ms 21 60 45s329ms 755ms 22 60 40s125ms 668ms 23 60 35s338ms 588ms 00 60 38s720ms 645ms [ User: labanimal - Total duration: 21m1s - Times executed: 1289 ]
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-03-29 23:59:01 Duration: 1s434ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-03-29 13:06:01 Duration: 1s281ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-03-29 20:56:01 Duration: 1s38ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
12 1,380 21m1s 515ms 1s434ms 914ms 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 #12
Day Hour Count Duration Avg duration Mar 29 00 60 0ms 0ms 01 60 37s149ms 619ms 04 60 1m16s 1s281ms 05 60 1m16s 1s281ms 06 60 1m16s 1s281ms 07 60 1m16s 1s281ms 08 60 1m16s 1s281ms 09 60 1m16s 1s281ms 10 60 1m16s 1s281ms 11 60 1m16s 1s281ms 12 60 1m16s 1s281ms 13 60 1m16s 1s281ms 14 60 45s854ms 764ms 15 60 41s759ms 695ms 16 60 41s759ms 695ms 17 60 41s759ms 695ms 18 60 41s759ms 695ms 19 60 41s759ms 695ms 20 60 41s759ms 695ms 21 60 45s329ms 755ms 22 60 40s125ms 668ms 23 60 35s338ms 588ms 00 60 38s720ms 645ms [ User: labanimal - Total duration: 21m1s - Times executed: 1289 ]
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-29 23:59:01 Duration: 1s434ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-29 13:06:01 Duration: 1s281ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-29 20:56:01 Duration: 1s38ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
13 1,380 21m1s 515ms 1s434ms 914ms create table if not exists observability.phpfpm_counters ( id bigserial primary key, payload jsonb not null, collected_at timestamptz not null default now() );Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Mar 29 00 60 0ms 0ms 01 60 37s149ms 619ms 04 60 1m16s 1s281ms 05 60 1m16s 1s281ms 06 60 1m16s 1s281ms 07 60 1m16s 1s281ms 08 60 1m16s 1s281ms 09 60 1m16s 1s281ms 10 60 1m16s 1s281ms 11 60 1m16s 1s281ms 12 60 1m16s 1s281ms 13 60 1m16s 1s281ms 14 60 45s854ms 764ms 15 60 41s759ms 695ms 16 60 41s759ms 695ms 17 60 41s759ms 695ms 18 60 41s759ms 695ms 19 60 41s759ms 695ms 20 60 41s759ms 695ms 21 60 45s329ms 755ms 22 60 40s125ms 668ms 23 60 35s338ms 588ms 00 60 38s720ms 645ms [ User: labanimal - Total duration: 21m1s - Times executed: 1289 ]
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-29 23:59:01 Duration: 1s434ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-29 13:06:01 Duration: 1s281ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-29 20:56:01 Duration: 1s38ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
14 3 2s909ms 915ms 1s38ms 969ms select p_update_breedings (?, null, ?, ?::date, null, ?::text, ?::text, null) as id;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Mar 29 21 1 1s38ms 1s38ms 22 2 1s870ms 935ms [ User: labanimal - Total duration: 2s909ms - Times executed: 3 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 2s909ms - Times executed: 3 ]
-
SELECT p_update_breedings (456, NULL, 16033, '2026-03-27'::date, NULL, '10294343'::text, '10296206'::text, NULL) AS id;
Date: 2026-03-29 20:44:20 Duration: 1s38ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
SELECT p_update_breedings (456, NULL, 10384, '2026-03-29'::date, NULL, '10293011'::text, '10293010'::text, NULL) AS id;
Date: 2026-03-29 21:18:00 Duration: 955ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
SELECT p_update_breedings (456, NULL, 10346, '2026-03-29'::date, NULL, '10293019'::text, '10293020'::text, NULL) AS id;
Date: 2026-03-29 21:21:55 Duration: 915ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
15 2 9s288ms 825ms 8s463ms 4s644ms with damdam as ( select breedingid, string_agg(cast(dam as text), ?) as dam from breedingsdams inner join ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" from animals) as dam on dam.id = breedingsdams.dam and case when user_is_tgm (dam.owner, ?) then true when user_is_tgm (dam.editor, ?) then true when user_is_tgm (dam.tourist, ?) then true else false end group by breedingid ), siresire as ( select breedingid, string_agg(cast(sire as text), ?) as sire from breedingssires inner join ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" from animals) as sire on sire.id = breedingssires.sire and case when user_is_tgm (sire.owner, ?) then true when user_is_tgm (sire.editor, ?) then true when user_is_tgm (sire.tourist, ?) then true else false end group by breedingid ), cagess as ( select id, "cageName" from cages) ( select breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire from damdam, siresire, cagess, breedings where breedings.deleted != true and cagess.id = breedings.cage and damdam.breedingid = breedings.id and siresire.breedingid = breedings.id and breedings."unbreeding_date" is null group by breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire order by breeding_date, plug_date);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Mar 29 21 1 8s463ms 8s463ms 22 1 825ms 825ms [ User: labanimal - Total duration: 9s288ms - Times executed: 2 ]
[ Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 - Total duration: 9s288ms - Times executed: 2 ]
-
WITH damdam AS ( SELECT breedingid, string_agg(cast(dam as text), ';') AS dam FROM breedingsdams INNER JOIN ( SELECT id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS dam ON dam.id = breedingsdams.dam AND CASE WHEN user_is_tgm (dam.owner, 1) THEN TRUE WHEN user_is_tgm (dam.editor, 1) THEN TRUE WHEN user_is_tgm (dam.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), siresire AS ( SELECT breedingid, string_agg(cast(sire as text), ';') AS sire FROM breedingssires INNER JOIN ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS sire ON sire.id = breedingssires.sire AND CASE WHEN user_is_tgm (sire.owner, 1) THEN TRUE WHEN user_is_tgm (sire.editor, 1) THEN TRUE WHEN user_is_tgm (sire.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-03-29 20:56:27 Duration: 8s463ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
WITH damdam AS ( SELECT breedingid, string_agg(cast(dam as text), ';') AS dam FROM breedingsdams INNER JOIN ( SELECT id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS dam ON dam.id = breedingsdams.dam AND CASE WHEN user_is_tgm (dam.owner, 1) THEN TRUE WHEN user_is_tgm (dam.editor, 1) THEN TRUE WHEN user_is_tgm (dam.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), siresire AS ( SELECT breedingid, string_agg(cast(sire as text), ';') AS sire FROM breedingssires INNER JOIN ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS sire ON sire.id = breedingssires.sire AND CASE WHEN user_is_tgm (sire.owner, 1) THEN TRUE WHEN user_is_tgm (sire.editor, 1) THEN TRUE WHEN user_is_tgm (sire.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-03-29 21:03:00 Duration: 825ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
16 1 1s981ms 1s981ms 1s981ms 1s981ms 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 #16
Day Hour Count Duration Avg duration Mar 29 00 1 1s981ms 1s981ms [ User: postgres - Total duration: 1s981ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s981ms - Times executed: 1 ]
-
COPY public.diary (id, "animalID", date, "entrybyID", "cageID", weight, temperature, "fDeprivation", "wDeprivation", "sDeprivation", "feedingClass", health, comments, "breedingInfo", deleted, "inOutDate", "inOutFlag", text, sdesc, treatment, tailcut_id, tailcut_result, file_name, file_content, file_type, upload_name, old_gene_type, old_gene_info, old_gene2_type, old_gene2_info, old_gene3_info, old_gene3_type, old_gene4_info, old_gene4_type, old_gene5_info, old_gene5_type) TO stdout;
Date: 2026-03-29 23:55:08 Duration: 1s981ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
17 1 1s434ms 1s434ms 1s434ms 1s434ms copy public."targetgroupMembers" (id, targetgroup, "user", "group") to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Mar 29 00 1 1s434ms 1s434ms [ User: postgres - Total duration: 1s434ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s434ms - Times executed: 1 ]
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-03-29 23:55:10 Duration: 1s434ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
18 1 1s309ms 1s309ms 1s309ms 1s309ms copy public.animals_search_mview (id, name, animal_id, deleted, alive, birth_date, arrival_date, death_date, outgoing_date, cage, comments, sterile, breeding, fate, last_mating, last_mating_date, breeding_cage, sex, strain, line, gene_1_info, gene_1_type, gene_2_info, gene_2_type, gene_3_info, gene_3_type, gene_4_info, gene_4_type, gene_5_info, gene_5_type, backcross, generation, project, project_name, species, species_name, cage_name, location, location_name, dam, dam_name, dam_id, sire, sire_name, sire_id, cohort, litter, rfid, owner, editor, tourist, breeding_status, workgroup_infos, experiment, experiment_name) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Mar 29 00 1 1s309ms 1s309ms [ User: postgres - Total duration: 1s309ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s309ms - Times executed: 1 ]
-
COPY public.animals_search_mview (id, name, animal_id, deleted, alive, birth_date, arrival_date, death_date, outgoing_date, cage, comments, sterile, breeding, fate, last_mating, last_mating_date, breeding_cage, sex, strain, line, gene_1_info, gene_1_type, gene_2_info, gene_2_type, gene_3_info, gene_3_type, gene_4_info, gene_4_type, gene_5_info, gene_5_type, backcross, generation, project, project_name, species, species_name, cage_name, location, location_name, dam, dam_name, dam_id, sire, sire_name, sire_id, cohort, litter, rfid, owner, editor, tourist, breeding_status, workgroup_infos, experiment, experiment_name) TO stdout;
Date: 2026-03-29 23:55:05 Duration: 1s309ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
19 1 1s281ms 1s281ms 1s281ms 1s281ms update tasks set task_status = ? where time_completed < now() - interval ? month;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 29 01 1 1s281ms 1s281ms [ User: labanimal - Total duration: 1s281ms - Times executed: 1 ]
[ Application: expire_tasks:zemm_produktiv_8@h2940066.stratoserver.net:5432 - Total duration: 1s281ms - Times executed: 1 ]
-
UPDATE tasks SET task_status = '7' WHERE time_completed < now() - interval '1' month;
Date: 2026-03-29 01:30:03 Duration: 1s281ms Database: zemm_produktiv_8 User: labanimal Remote: 81.169.238.237 Application: expire_tasks:zemm_produktiv_8@h2940066.stratoserver.net:5432 Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
20 1 1s214ms 1s214ms 1s214ms 1s214ms copy public.animals (id, species, transgen, "homeCage", tourist, editor, owner, comments, pregnant, name, sex, "standardDescription", "parentFemale", "parentMale", "parentFoster", colour, "plannedUseFor", deleted, generation, chimare, "birthDate", "arrivalDate", "outgoingDate", "deathDate", breedstatus_2, "healthState", breeder, restrictions, "geneStatus", "geneFlanking", "geneDeleted", "fromOrder_2", "group", "fromOrder", strain, "breedStatus", "FEMnumber", genotype, inbreeding, identification, jax, "KOgene", "feedingClass", dummy_gen_info, breeding, sterile, project, dummy_line_info, dummy_strain_info, "bredWith", "curCage", dummy_backcross_info, fate, "fateComment", alive, reciever, "animalID", litter, weight_at_arrival, cohort, gen_2_info, gen_3_info, gen_4_info, gen_5_info, gen_1_typ, gen_2_typ, gen_3_typ, gen_4_typ, gen_5_typ, "latestMatingDate", "latestMating", genecomment, recycle) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 29 00 1 1s214ms 1s214ms [ User: postgres - Total duration: 1s214ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s214ms - Times executed: 1 ]
-
COPY public.animals (id, species, transgen, "homeCage", tourist, editor, owner, comments, pregnant, name, sex, "standardDescription", "parentFemale", "parentMale", "parentFoster", colour, "plannedUseFor", deleted, generation, chimare, "birthDate", "arrivalDate", "outgoingDate", "deathDate", breedstatus_2, "healthState", breeder, restrictions, "geneStatus", "geneFlanking", "geneDeleted", "fromOrder_2", "group", "fromOrder", strain, "breedStatus", "FEMnumber", genotype, inbreeding, identification, jax, "KOgene", "feedingClass", dummy_gen_info, breeding, sterile, project, dummy_line_info, dummy_strain_info, "bredWith", "curCage", dummy_backcross_info, fate, "fateComment", alive, reciever, "animalID", litter, weight_at_arrival, cohort, gen_2_info, gen_3_info, gen_4_info, gen_5_info, gen_1_typ, gen_2_typ, gen_3_typ, gen_4_typ, gen_5_typ, "latestMatingDate", "latestMating", genecomment, recycle) TO stdout;
Date: 2026-03-29 23:55:03 Duration: 1s214ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 825ms 8s463ms 4s644ms 2 9s288ms with damdam as ( select breedingid, string_agg(cast(dam as text), ?) as dam from breedingsdams inner join ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" from animals) as dam on dam.id = breedingsdams.dam and case when user_is_tgm (dam.owner, ?) then true when user_is_tgm (dam.editor, ?) then true when user_is_tgm (dam.tourist, ?) then true else false end group by breedingid ), siresire as ( select breedingid, string_agg(cast(sire as text), ?) as sire from breedingssires inner join ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" from animals) as sire on sire.id = breedingssires.sire and case when user_is_tgm (sire.owner, ?) then true when user_is_tgm (sire.editor, ?) then true when user_is_tgm (sire.tourist, ?) then true else false end group by breedingid ), cagess as ( select id, "cageName" from cages) ( select breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire from damdam, siresire, cagess, breedings where breedings.deleted != true and cagess.id = breedings.cage and damdam.breedingid = breedings.id and siresire.breedingid = breedings.id and breedings."unbreeding_date" is null group by breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire order by breeding_date, plug_date);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 29 21 1 8s463ms 8s463ms 22 1 825ms 825ms [ User: labanimal - Total duration: 9s288ms - Times executed: 2 ]
[ Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 - Total duration: 9s288ms - Times executed: 2 ]
-
WITH damdam AS ( SELECT breedingid, string_agg(cast(dam as text), ';') AS dam FROM breedingsdams INNER JOIN ( SELECT id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS dam ON dam.id = breedingsdams.dam AND CASE WHEN user_is_tgm (dam.owner, 1) THEN TRUE WHEN user_is_tgm (dam.editor, 1) THEN TRUE WHEN user_is_tgm (dam.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), siresire AS ( SELECT breedingid, string_agg(cast(sire as text), ';') AS sire FROM breedingssires INNER JOIN ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS sire ON sire.id = breedingssires.sire AND CASE WHEN user_is_tgm (sire.owner, 1) THEN TRUE WHEN user_is_tgm (sire.editor, 1) THEN TRUE WHEN user_is_tgm (sire.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-03-29 20:56:27 Duration: 8s463ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
WITH damdam AS ( SELECT breedingid, string_agg(cast(dam as text), ';') AS dam FROM breedingsdams INNER JOIN ( SELECT id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS dam ON dam.id = breedingsdams.dam AND CASE WHEN user_is_tgm (dam.owner, 1) THEN TRUE WHEN user_is_tgm (dam.editor, 1) THEN TRUE WHEN user_is_tgm (dam.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), siresire AS ( SELECT breedingid, string_agg(cast(sire as text), ';') AS sire FROM breedingssires INNER JOIN ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS sire ON sire.id = breedingssires.sire AND CASE WHEN user_is_tgm (sire.owner, 1) THEN TRUE WHEN user_is_tgm (sire.editor, 1) THEN TRUE WHEN user_is_tgm (sire.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-03-29 21:03:00 Duration: 825ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
2 1s981ms 1s981ms 1s981ms 1 1s981ms 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 #2
Day Hour Count Duration Avg duration Mar 29 00 1 1s981ms 1s981ms [ User: postgres - Total duration: 1s981ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s981ms - Times executed: 1 ]
-
COPY public.diary (id, "animalID", date, "entrybyID", "cageID", weight, temperature, "fDeprivation", "wDeprivation", "sDeprivation", "feedingClass", health, comments, "breedingInfo", deleted, "inOutDate", "inOutFlag", text, sdesc, treatment, tailcut_id, tailcut_result, file_name, file_content, file_type, upload_name, old_gene_type, old_gene_info, old_gene2_type, old_gene2_info, old_gene3_info, old_gene3_type, old_gene4_info, old_gene4_type, old_gene5_info, old_gene5_type) TO stdout;
Date: 2026-03-29 23:55:08 Duration: 1s981ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
3 1s434ms 1s434ms 1s434ms 1 1s434ms copy public."targetgroupMembers" (id, targetgroup, "user", "group") to stdout;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 29 00 1 1s434ms 1s434ms [ User: postgres - Total duration: 1s434ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s434ms - Times executed: 1 ]
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-03-29 23:55:10 Duration: 1s434ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
4 1s309ms 1s309ms 1s309ms 1 1s309ms 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 #4
Day Hour Count Duration Avg duration Mar 29 00 1 1s309ms 1s309ms [ User: postgres - Total duration: 1s309ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s309ms - Times executed: 1 ]
-
COPY public.animals_search_mview (id, name, animal_id, deleted, alive, birth_date, arrival_date, death_date, outgoing_date, cage, comments, sterile, breeding, fate, last_mating, last_mating_date, breeding_cage, sex, strain, line, gene_1_info, gene_1_type, gene_2_info, gene_2_type, gene_3_info, gene_3_type, gene_4_info, gene_4_type, gene_5_info, gene_5_type, backcross, generation, project, project_name, species, species_name, cage_name, location, location_name, dam, dam_name, dam_id, sire, sire_name, sire_id, cohort, litter, rfid, owner, editor, tourist, breeding_status, workgroup_infos, experiment, experiment_name) TO stdout;
Date: 2026-03-29 23:55:05 Duration: 1s309ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
5 1s281ms 1s281ms 1s281ms 1 1s281ms update tasks set task_status = ? where time_completed < now() - interval ? month;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Mar 29 01 1 1s281ms 1s281ms [ User: labanimal - Total duration: 1s281ms - Times executed: 1 ]
[ Application: expire_tasks:zemm_produktiv_8@h2940066.stratoserver.net:5432 - Total duration: 1s281ms - Times executed: 1 ]
-
UPDATE tasks SET task_status = '7' WHERE time_completed < now() - interval '1' month;
Date: 2026-03-29 01:30:03 Duration: 1s281ms Database: zemm_produktiv_8 User: labanimal Remote: 81.169.238.237 Application: expire_tasks:zemm_produktiv_8@h2940066.stratoserver.net:5432 Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
6 1s214ms 1s214ms 1s214ms 1 1s214ms copy public.animals (id, species, transgen, "homeCage", tourist, editor, owner, comments, pregnant, name, sex, "standardDescription", "parentFemale", "parentMale", "parentFoster", colour, "plannedUseFor", deleted, generation, chimare, "birthDate", "arrivalDate", "outgoingDate", "deathDate", breedstatus_2, "healthState", breeder, restrictions, "geneStatus", "geneFlanking", "geneDeleted", "fromOrder_2", "group", "fromOrder", strain, "breedStatus", "FEMnumber", genotype, inbreeding, identification, jax, "KOgene", "feedingClass", dummy_gen_info, breeding, sterile, project, dummy_line_info, dummy_strain_info, "bredWith", "curCage", dummy_backcross_info, fate, "fateComment", alive, reciever, "animalID", litter, weight_at_arrival, cohort, gen_2_info, gen_3_info, gen_4_info, gen_5_info, gen_1_typ, gen_2_typ, gen_3_typ, gen_4_typ, gen_5_typ, "latestMatingDate", "latestMating", genecomment, recycle) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Mar 29 00 1 1s214ms 1s214ms [ User: postgres - Total duration: 1s214ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s214ms - Times executed: 1 ]
-
COPY public.animals (id, species, transgen, "homeCage", tourist, editor, owner, comments, pregnant, name, sex, "standardDescription", "parentFemale", "parentMale", "parentFoster", colour, "plannedUseFor", deleted, generation, chimare, "birthDate", "arrivalDate", "outgoingDate", "deathDate", breedstatus_2, "healthState", breeder, restrictions, "geneStatus", "geneFlanking", "geneDeleted", "fromOrder_2", "group", "fromOrder", strain, "breedStatus", "FEMnumber", genotype, inbreeding, identification, jax, "KOgene", "feedingClass", dummy_gen_info, breeding, sterile, project, dummy_line_info, dummy_strain_info, "bredWith", "curCage", dummy_backcross_info, fate, "fateComment", alive, reciever, "animalID", litter, weight_at_arrival, cohort, gen_2_info, gen_3_info, gen_4_info, gen_5_info, gen_1_typ, gen_2_typ, gen_3_typ, gen_4_typ, gen_5_typ, "latestMatingDate", "latestMating", genecomment, recycle) TO stdout;
Date: 2026-03-29 23:55:03 Duration: 1s214ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
7 915ms 1s38ms 969ms 3 2s909ms select p_update_breedings (?, null, ?, ?::date, null, ?::text, ?::text, null) as id;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Mar 29 21 1 1s38ms 1s38ms 22 2 1s870ms 935ms [ User: labanimal - Total duration: 2s909ms - Times executed: 3 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 2s909ms - Times executed: 3 ]
-
SELECT p_update_breedings (456, NULL, 16033, '2026-03-27'::date, NULL, '10294343'::text, '10296206'::text, NULL) AS id;
Date: 2026-03-29 20:44:20 Duration: 1s38ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
SELECT p_update_breedings (456, NULL, 10384, '2026-03-29'::date, NULL, '10293011'::text, '10293010'::text, NULL) AS id;
Date: 2026-03-29 21:18:00 Duration: 955ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
SELECT p_update_breedings (456, NULL, 10346, '2026-03-29'::date, NULL, '10293019'::text, '10293020'::text, NULL) AS id;
Date: 2026-03-29 21:21:55 Duration: 915ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
8 515ms 1s434ms 914ms 1,380 21m1s create schema if not exists observability;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Mar 29 00 60 0ms 0ms 01 60 37s149ms 619ms 04 60 1m16s 1s281ms 05 60 1m16s 1s281ms 06 60 1m16s 1s281ms 07 60 1m16s 1s281ms 08 60 1m16s 1s281ms 09 60 1m16s 1s281ms 10 60 1m16s 1s281ms 11 60 1m16s 1s281ms 12 60 1m16s 1s281ms 13 60 1m16s 1s281ms 14 60 45s854ms 764ms 15 60 41s759ms 695ms 16 60 41s759ms 695ms 17 60 41s759ms 695ms 18 60 41s759ms 695ms 19 60 41s759ms 695ms 20 60 41s759ms 695ms 21 60 45s329ms 755ms 22 60 40s125ms 668ms 23 60 35s338ms 588ms 00 60 38s720ms 645ms [ User: labanimal - Total duration: 21m1s - Times executed: 1289 ]
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-29 23:59:01 Duration: 1s434ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-29 13:06:01 Duration: 1s281ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-29 20:56:01 Duration: 1s38ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
9 515ms 1s434ms 914ms 1,380 21m1s 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 #9
Day Hour Count Duration Avg duration Mar 29 00 60 0ms 0ms 01 60 37s149ms 619ms 04 60 1m16s 1s281ms 05 60 1m16s 1s281ms 06 60 1m16s 1s281ms 07 60 1m16s 1s281ms 08 60 1m16s 1s281ms 09 60 1m16s 1s281ms 10 60 1m16s 1s281ms 11 60 1m16s 1s281ms 12 60 1m16s 1s281ms 13 60 1m16s 1s281ms 14 60 45s854ms 764ms 15 60 41s759ms 695ms 16 60 41s759ms 695ms 17 60 41s759ms 695ms 18 60 41s759ms 695ms 19 60 41s759ms 695ms 20 60 41s759ms 695ms 21 60 45s329ms 755ms 22 60 40s125ms 668ms 23 60 35s338ms 588ms 00 60 38s720ms 645ms [ User: labanimal - Total duration: 21m1s - Times executed: 1289 ]
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-29 23:59:01 Duration: 1s434ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-29 13:06:01 Duration: 1s281ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-29 20:56:01 Duration: 1s38ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
10 515ms 1s434ms 914ms 1,380 21m1s 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 #10
Day Hour Count Duration Avg duration Mar 29 00 60 0ms 0ms 01 60 37s149ms 619ms 04 60 1m16s 1s281ms 05 60 1m16s 1s281ms 06 60 1m16s 1s281ms 07 60 1m16s 1s281ms 08 60 1m16s 1s281ms 09 60 1m16s 1s281ms 10 60 1m16s 1s281ms 11 60 1m16s 1s281ms 12 60 1m16s 1s281ms 13 60 1m16s 1s281ms 14 60 45s854ms 764ms 15 60 41s759ms 695ms 16 60 41s759ms 695ms 17 60 41s759ms 695ms 18 60 41s759ms 695ms 19 60 41s759ms 695ms 20 60 41s759ms 695ms 21 60 45s329ms 755ms 22 60 40s125ms 668ms 23 60 35s338ms 588ms 00 60 38s720ms 645ms [ User: labanimal - Total duration: 21m1s - Times executed: 1289 ]
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-29 23:59:01 Duration: 1s434ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-29 13:06:01 Duration: 1s281ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-29 20:56:01 Duration: 1s38ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
11 515ms 1s434ms 914ms 1,380 21m1s 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 #11
Day Hour Count Duration Avg duration Mar 29 00 60 0ms 0ms 01 60 37s149ms 619ms 04 60 1m16s 1s281ms 05 60 1m16s 1s281ms 06 60 1m16s 1s281ms 07 60 1m16s 1s281ms 08 60 1m16s 1s281ms 09 60 1m16s 1s281ms 10 60 1m16s 1s281ms 11 60 1m16s 1s281ms 12 60 1m16s 1s281ms 13 60 1m16s 1s281ms 14 60 45s854ms 764ms 15 60 41s759ms 695ms 16 60 41s759ms 695ms 17 60 41s759ms 695ms 18 60 41s759ms 695ms 19 60 41s759ms 695ms 20 60 41s759ms 695ms 21 60 45s329ms 755ms 22 60 40s125ms 668ms 23 60 35s338ms 588ms 00 60 38s720ms 645ms [ User: labanimal - Total duration: 21m1s - Times executed: 1289 ]
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-03-29 23:59:01 Duration: 1s434ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-03-29 13:06:01 Duration: 1s281ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-03-29 20:56:01 Duration: 1s38ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
12 515ms 1s434ms 914ms 1,380 21m1s create index if not exists idx_app_events_type on observability.app_events (event_type);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Mar 29 00 60 0ms 0ms 01 60 37s149ms 619ms 04 60 1m16s 1s281ms 05 60 1m16s 1s281ms 06 60 1m16s 1s281ms 07 60 1m16s 1s281ms 08 60 1m16s 1s281ms 09 60 1m16s 1s281ms 10 60 1m16s 1s281ms 11 60 1m16s 1s281ms 12 60 1m16s 1s281ms 13 60 1m16s 1s281ms 14 60 45s854ms 764ms 15 60 41s759ms 695ms 16 60 41s759ms 695ms 17 60 41s759ms 695ms 18 60 41s759ms 695ms 19 60 41s759ms 695ms 20 60 41s759ms 695ms 21 60 45s329ms 755ms 22 60 40s125ms 668ms 23 60 35s338ms 588ms 00 60 38s720ms 645ms [ User: labanimal - Total duration: 21m1s - Times executed: 1289 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-29 23:59:01 Duration: 1s434ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-29 13:06:01 Duration: 1s281ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-29 20:56:01 Duration: 1s38ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
13 515ms 1s434ms 914ms 1,380 21m1s 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 #13
Day Hour Count Duration Avg duration Mar 29 00 60 0ms 0ms 01 60 37s149ms 619ms 04 60 1m16s 1s281ms 05 60 1m16s 1s281ms 06 60 1m16s 1s281ms 07 60 1m16s 1s281ms 08 60 1m16s 1s281ms 09 60 1m16s 1s281ms 10 60 1m16s 1s281ms 11 60 1m16s 1s281ms 12 60 1m16s 1s281ms 13 60 1m16s 1s281ms 14 60 45s854ms 764ms 15 60 41s759ms 695ms 16 60 41s759ms 695ms 17 60 41s759ms 695ms 18 60 41s759ms 695ms 19 60 41s759ms 695ms 20 60 41s759ms 695ms 21 60 45s329ms 755ms 22 60 40s125ms 668ms 23 60 35s338ms 588ms 00 60 38s720ms 645ms [ User: labanimal - Total duration: 21m1s - Times executed: 1289 ]
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-29 23:59:01 Duration: 1s434ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-29 13:06:01 Duration: 1s281ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-29 20:56:01 Duration: 1s38ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
14 515ms 1s434ms 914ms 1,380 21m1s create index if not exists idx_app_events_tenant on observability.app_events (tenant_key, occurred_at desc);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Mar 29 00 60 0ms 0ms 01 60 37s149ms 619ms 04 60 1m16s 1s281ms 05 60 1m16s 1s281ms 06 60 1m16s 1s281ms 07 60 1m16s 1s281ms 08 60 1m16s 1s281ms 09 60 1m16s 1s281ms 10 60 1m16s 1s281ms 11 60 1m16s 1s281ms 12 60 1m16s 1s281ms 13 60 1m16s 1s281ms 14 60 45s854ms 764ms 15 60 41s759ms 695ms 16 60 41s759ms 695ms 17 60 41s759ms 695ms 18 60 41s759ms 695ms 19 60 41s759ms 695ms 20 60 41s759ms 695ms 21 60 45s329ms 755ms 22 60 40s125ms 668ms 23 60 35s338ms 588ms 00 60 38s720ms 645ms [ User: labanimal - Total duration: 21m1s - Times executed: 1289 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-29 23:59:01 Duration: 1s434ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-29 13:06:01 Duration: 1s281ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-29 20:56:01 Duration: 1s38ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
15 515ms 1s434ms 914ms 1,380 21m1s create index if not exists idx_metrics_timeseries_bucket on observability.metrics_timeseries (bucket_start);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Mar 29 00 60 0ms 0ms 01 60 37s149ms 619ms 04 60 1m16s 1s281ms 05 60 1m16s 1s281ms 06 60 1m16s 1s281ms 07 60 1m16s 1s281ms 08 60 1m16s 1s281ms 09 60 1m16s 1s281ms 10 60 1m16s 1s281ms 11 60 1m16s 1s281ms 12 60 1m16s 1s281ms 13 60 1m16s 1s281ms 14 60 45s854ms 764ms 15 60 41s759ms 695ms 16 60 41s759ms 695ms 17 60 41s759ms 695ms 18 60 41s759ms 695ms 19 60 41s759ms 695ms 20 60 41s759ms 695ms 21 60 45s329ms 755ms 22 60 40s125ms 668ms 23 60 35s338ms 588ms 00 60 38s720ms 645ms [ User: labanimal - Total duration: 21m1s - Times executed: 1289 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-29 23:59:01 Duration: 1s434ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-29 13:06:01 Duration: 1s281ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-29 20:56:01 Duration: 1s38ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
16 515ms 1s434ms 914ms 1,380 21m1s create index if not exists idx_metrics_timeseries_metric on observability.metrics_timeseries (metric_name);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Mar 29 00 60 0ms 0ms 01 60 37s149ms 619ms 04 60 1m16s 1s281ms 05 60 1m16s 1s281ms 06 60 1m16s 1s281ms 07 60 1m16s 1s281ms 08 60 1m16s 1s281ms 09 60 1m16s 1s281ms 10 60 1m16s 1s281ms 11 60 1m16s 1s281ms 12 60 1m16s 1s281ms 13 60 1m16s 1s281ms 14 60 45s854ms 764ms 15 60 41s759ms 695ms 16 60 41s759ms 695ms 17 60 41s759ms 695ms 18 60 41s759ms 695ms 19 60 41s759ms 695ms 20 60 41s759ms 695ms 21 60 45s329ms 755ms 22 60 40s125ms 668ms 23 60 35s338ms 588ms 00 60 38s720ms 645ms [ User: labanimal - Total duration: 21m1s - Times executed: 1289 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-29 23:59:01 Duration: 1s434ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-29 13:06:01 Duration: 1s281ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-29 20:56:01 Duration: 1s38ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
17 515ms 1s434ms 914ms 1,380 21m1s create table if not exists observability.uptime_checks ( id bigserial primary key, endpoint text not null, status text not null, latency_ms double precision, checked_at timestamptz not null default now() );Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Mar 29 00 60 0ms 0ms 01 60 37s149ms 619ms 04 60 1m16s 1s281ms 05 60 1m16s 1s281ms 06 60 1m16s 1s281ms 07 60 1m16s 1s281ms 08 60 1m16s 1s281ms 09 60 1m16s 1s281ms 10 60 1m16s 1s281ms 11 60 1m16s 1s281ms 12 60 1m16s 1s281ms 13 60 1m16s 1s281ms 14 60 45s854ms 764ms 15 60 41s759ms 695ms 16 60 41s759ms 695ms 17 60 41s759ms 695ms 18 60 41s759ms 695ms 19 60 41s759ms 695ms 20 60 41s759ms 695ms 21 60 45s329ms 755ms 22 60 40s125ms 668ms 23 60 35s338ms 588ms 00 60 38s720ms 645ms [ User: labanimal - Total duration: 21m1s - Times executed: 1289 ]
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-29 23:59:01 Duration: 1s434ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-29 13:06:01 Duration: 1s281ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-29 20:56:01 Duration: 1s38ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
18 515ms 1s434ms 914ms 1,380 21m1s create index if not exists idx_db_top_queries_tenant on observability.db_top_queries (tenant_key, collected_at desc);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Mar 29 00 60 0ms 0ms 01 60 37s149ms 619ms 04 60 1m16s 1s281ms 05 60 1m16s 1s281ms 06 60 1m16s 1s281ms 07 60 1m16s 1s281ms 08 60 1m16s 1s281ms 09 60 1m16s 1s281ms 10 60 1m16s 1s281ms 11 60 1m16s 1s281ms 12 60 1m16s 1s281ms 13 60 1m16s 1s281ms 14 60 45s854ms 764ms 15 60 41s759ms 695ms 16 60 41s759ms 695ms 17 60 41s759ms 695ms 18 60 41s759ms 695ms 19 60 41s759ms 695ms 20 60 41s759ms 695ms 21 60 45s329ms 755ms 22 60 40s125ms 668ms 23 60 35s338ms 588ms 00 60 38s720ms 645ms [ User: labanimal - Total duration: 21m1s - Times executed: 1289 ]
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-03-29 23:59:01 Duration: 1s434ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-03-29 13:06:01 Duration: 1s281ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-03-29 20:56:01 Duration: 1s38ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
19 515ms 1s434ms 914ms 1,380 21m1s 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 #19
Day Hour Count Duration Avg duration Mar 29 00 60 0ms 0ms 01 60 37s149ms 619ms 04 60 1m16s 1s281ms 05 60 1m16s 1s281ms 06 60 1m16s 1s281ms 07 60 1m16s 1s281ms 08 60 1m16s 1s281ms 09 60 1m16s 1s281ms 10 60 1m16s 1s281ms 11 60 1m16s 1s281ms 12 60 1m16s 1s281ms 13 60 1m16s 1s281ms 14 60 45s854ms 764ms 15 60 41s759ms 695ms 16 60 41s759ms 695ms 17 60 41s759ms 695ms 18 60 41s759ms 695ms 19 60 41s759ms 695ms 20 60 41s759ms 695ms 21 60 45s329ms 755ms 22 60 40s125ms 668ms 23 60 35s338ms 588ms 00 60 38s720ms 645ms [ User: labanimal - Total duration: 21m1s - Times executed: 1289 ]
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-29 23:59:01 Duration: 1s434ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-29 13:06:01 Duration: 1s281ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-29 20:56:01 Duration: 1s38ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
20 515ms 1s434ms 914ms 1,380 21m1s 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 #20
Day Hour Count Duration Avg duration Mar 29 00 60 0ms 0ms 01 60 37s149ms 619ms 04 60 1m16s 1s281ms 05 60 1m16s 1s281ms 06 60 1m16s 1s281ms 07 60 1m16s 1s281ms 08 60 1m16s 1s281ms 09 60 1m16s 1s281ms 10 60 1m16s 1s281ms 11 60 1m16s 1s281ms 12 60 1m16s 1s281ms 13 60 1m16s 1s281ms 14 60 45s854ms 764ms 15 60 41s759ms 695ms 16 60 41s759ms 695ms 17 60 41s759ms 695ms 18 60 41s759ms 695ms 19 60 41s759ms 695ms 20 60 41s759ms 695ms 21 60 45s329ms 755ms 22 60 40s125ms 668ms 23 60 35s338ms 588ms 00 60 38s720ms 645ms [ User: labanimal - Total duration: 21m1s - Times executed: 1289 ]
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-29 23:59:01 Duration: 1s434ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-29 13:06:01 Duration: 1s281ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-29 20:56:01 Duration: 1s38ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-29_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
- 47,849 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 7 FATAL entries
- 6 ERROR entries
- 0 WARNING entries
- 0 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 6 Max number of times the same event was reported
- 13 Total events found
Rank Times reported Error 1 6 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Mar 29 00 1 10 2 21 3 - FATAL: database "deploy" does not exist
- FATAL: database "monitoring" does not exist
- FATAL: database "monitoring" does not exist
Date: 2026-03-29 00:02:24 Database: deploy Application: psql User: deploy Remote: [local] Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
Date: 2026-03-29 09:17:14 Database: monitoring Application: User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
Date: 2026-03-29 09:17:14 Database: monitoring Application: User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
2 4 ERROR: missing FROM-clause entry for table "..."
Times Reported Most Frequent Error / Event #2
Day Hour Count Mar 29 00 4 - ERROR: missing FROM-clause entry for table "public"
- ERROR: missing FROM-clause entry for table "public"
- ERROR: missing FROM-clause entry for table "public"
Statement: select to_regclass(public.documents), to_regclass(public.taskattachment)
Date: 2026-03-29 00:03:06 Database: zemm_produktiv_7 Application: psql User: deploy Remote: [local] Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
Statement: select to_regclass(public.documents), to_regclass(public.taskattachment)
Date: 2026-03-29 00:03:06 Database: zemm_produktiv_8 Application: psql User: deploy Remote: [local] Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
Statement: select to_regclass(public.documents), to_regclass(public.taskattachment)
Date: 2026-03-29 00:03:15 Database: zemm_produktiv_8 Application: psql User: deploy Remote: [local] Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
3 2 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count Mar 29 23 2 - ERROR: column "created_on" does not exist
- ERROR: column t.description does not exist
Statement: copy ( select id as attachment_id, taskid, file_name, file_upload, created_on, created_by from taskattachment where file_upload in ( select file_upload from taskattachment where coalesce(file_upload,'') <> '' ) order by id desc limit 20 ) to stdout with csv header
Date: 2026-03-29 22:53:17 Database: zemm_produktiv_8 Application: psql User: deploy Remote: [local] Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
Statement: copy ( select a.id as attachment_id, a.taskid, a.file_name, a.file_upload, t.time_issued, regexp_replace(coalesce(t.description,''), E'[\r\n\t]+', ' ', 'g') as task_description from taskattachment a left join tasks t on t.id = a.taskid where a.id in (1975,3161,3162,3163,3164,3165,3166,3167,3168,3170,3172,3173,3174,3176,10108333,10108334,10108335,10108336,10108337,10108338,10108339,10108341,10108342,10108343,10108344,10108345,10108347,10108348,10108350,10108351,10108352,10108353,10108354,10108355) order by a.id ) to stdout with csv header
Date: 2026-03-29 22:53:34 Database: zemm_produktiv_8 Application: psql User: deploy Remote: [local] Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv
4 1 FATAL: Peer authentication failed for user "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Mar 29 00 1 - FATAL: Peer authentication failed for user "datname"
Detail: Connection matched file "/etc/postgresql/18/main/pg_hba.conf" line 18: "local all all peer"
Date: 2026-03-29 00:02:39 Database: postgres Application: User: datname Remote: [local] Log file: /var/log/postgresql/postgresql-2026-03-29_000000.csv