ZEMM PG Report-
Global information
- Generated on Thu Apr 30 06:05:33 2026
- Log file: /var/log/postgresql/postgresql-2026-03-25_000000.csv, ..., /var/log/postgresql/postgresql-2026-04-30_000000.csv
- Parsed 196,855 log entries in 5m32s
- Log start from 2026-04-03 00:00:01 to 2026-04-03 23:59:02
-
Overview
Global Stats
- 25 Number of unique normalized queries
- 18,770 Number of queries
- 5h25m9s Total query duration
- 2026-04-03 00:00:01 First query
- 2026-04-03 23:59:01 Last query
- 14 queries/s at 2026-04-03 17:58:01 Query peak
- 5h25m9s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 5h25m9s Execute total duration
- 15 Number of events
- 2 Number of unique normalized events
- 14 Max number of times the same event was reported
- 0 Number of cancellation
- 17 Total number of automatic vacuums
- 19 Total number of automatic analyzes
- 44 Number temporary file
- 125.55 MiB Max size of temporary file
- 62.73 MiB Average size of temporary file
- 17,390 Total number of sessions
- 3 sessions at 2026-04-03 14:41:58 Session peak
- 54m30s Total duration of sessions
- 188ms Average duration of sessions
- 1 Average queries per session
- 1s121ms Average queries duration per session
- 0ms Average idle time per session
- 17,404 Total number of connections
- 52 connections/s at 2026-04-03 09:41:42 Connection peak
- 2 Total number of databases
SQL Traffic
Key values
- 14 queries/s Query Peak
- 2026-04-03 17:58:01 Date
SELECT Traffic
Key values
- 2 queries/s Query Peak
- 2026-04-03 17:41:13 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 13 queries/s Query Peak
- 2026-04-03 05:58:01 Date
Queries duration
Key values
- 5h25m9s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Apr 03 00 780 0ms 0ms 0ms 0ms 0ms 0ms 01 781 0ms 922ms 446ms 11s990ms 11s990ms 11s990ms 02 780 922ms 922ms 922ms 11s990ms 11s990ms 11s990ms 03 780 922ms 922ms 922ms 11s990ms 11s990ms 11s990ms 04 780 922ms 922ms 922ms 11s990ms 11s990ms 11s990ms 05 780 922ms 922ms 922ms 11s990ms 11s990ms 11s990ms 06 780 922ms 922ms 922ms 11s990ms 11s990ms 11s990ms 07 780 922ms 922ms 922ms 11s990ms 11s990ms 11s990ms 08 781 922ms 928ms 923ms 12s73ms 12s73ms 12s919ms 09 787 562ms 1s724ms 1s163ms 21s264ms 21s264ms 24s722ms 10 780 1s635ms 1s635ms 1s635ms 21s264ms 21s264ms 21s264ms 11 780 1s635ms 1s635ms 1s635ms 21s264ms 21s264ms 21s264ms 12 780 1s635ms 1s635ms 1s635ms 21s264ms 21s264ms 21s264ms 13 780 1s635ms 1s635ms 1s635ms 21s264ms 21s264ms 21s264ms 14 780 1s635ms 1s635ms 1s635ms 21s264ms 21s264ms 21s264ms 15 780 1s635ms 1s635ms 1s635ms 21s264ms 21s264ms 21s264ms 16 780 1s635ms 1s635ms 1s635ms 21s264ms 21s264ms 21s264ms 17 812 662ms 1s635ms 1s320ms 21s264ms 21s264ms 24s110ms 18 784 662ms 729ms 674ms 8s780ms 8s780ms 11s419ms 19 780 675ms 675ms 675ms 8s780ms 8s780ms 8s780ms 20 780 675ms 675ms 675ms 8s780ms 8s780ms 8s780ms 21 780 675ms 675ms 675ms 8s780ms 8s780ms 8s780ms 22 780 675ms 675ms 675ms 8s780ms 8s780ms 8s780ms 23 785 547ms 1s981ms 724ms 8s780ms 17s592ms 17s592ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Apr 03 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 1 0 928ms 0ms 0ms 0ms 09 3 0 704ms 0ms 0ms 564ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 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 32 0 705ms 0ms 1s391ms 4s211ms 18 4 0 701ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 5 1s293ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Apr 03 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 1 0 0 922ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Apr 03 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Apr 03 00 247 0.07/s 01 259 0.07/s 02 247 0.07/s 03 244 0.07/s 04 247 0.07/s 05 252 0.07/s 06 245 0.07/s 07 423 0.12/s 08 1,041 0.29/s 09 640 0.18/s 10 1,013 0.28/s 11 904 0.25/s 12 923 0.26/s 13 916 0.25/s 14 943 0.26/s 15 949 0.26/s 16 928 0.26/s 17 1,076 0.30/s 18 1,158 0.32/s 19 952 0.26/s 20 973 0.27/s 21 936 0.26/s 22 1,003 0.28/s 23 885 0.25/s Day Hour Count Average Duration Average idle time Apr 03 00 247 348ms 348ms 01 255 345ms 0ms 02 247 351ms 0ms 03 244 356ms 0ms 04 247 352ms 0ms 05 252 346ms 0ms 06 245 353ms 0ms 07 423 249ms 0ms 08 1,041 157ms 0ms 09 640 238ms 0ms 10 1,013 151ms 0ms 11 904 160ms 0ms 12 923 160ms 0ms 13 916 161ms 0ms 14 943 163ms 0ms 15 939 157ms 0ms 16 928 165ms 0ms 17 1,076 188ms 0ms 18 1,158 153ms 0ms 19 952 157ms 0ms 20 973 158ms 0ms 21 936 161ms 0ms 22 1,003 187ms 0ms 23 885 187ms 0ms -
Connections
Established Connections
Key values
- 52 connections Connection Peak
- 2026-04-03 09:41:42 Date
Connections per database
Key values
- zemm_monitoring Main Database
- 17,404 connections Total
Connections per user
Key values
- labanimal Main User
- 17,404 connections Total
-
Sessions
Simultaneous sessions
Key values
- 3 sessions Session Peak
- 2026-04-03 14:41:58 Date
Histogram of session times
Key values
- 15,464 0-500ms duration
Sessions per database
Key values
- zemm_monitoring Main Database
- 17,390 sessions Total
Sessions per user
Key values
- labanimal Main User
- 17,390 sessions Total
Sessions per host
Key values
- ::1 Main Host
- 17,390 sessions Total
Sessions per application
Key values
- Main Application
- 17,390 sessions Total
Application Count Total Duration Average Duration 17,059 53m5s 186ms _desktop__zemm_produktiv_8_localhost_5432 1 92ms 92ms _desktop_index.php_command_login_subcommand_init_zemm_produktiv 34 1s75ms 31ms _desktop_index.php_command_reports_subcommand_animals_per_user_ 1 111ms 111ms _desktop_index.php_view_animal_name_on_view_animal_id_on_view_b 1 1s472ms 1s472ms _desktop_index.php_zemm_produktiv_8_localhost_5432 243 1m6s 273ms backend:zemm_produktiv_8@localhost 1 39ms 39ms expire_tasks:zemm_produktiv_8@h2940066.stratoserver.net:5432 1 939ms 939ms pg_dump 1 12s816ms 12s816ms taskscron:zemm_produktiv_7@zemm.fbiscience.eu 24 648ms 27ms taskscron:zemm_produktiv_8@h2940066.stratoserver.net:5432 24 1s818ms 75ms -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 96,315 buffers Checkpoint Peak
- 2026-04-03 13:55:34 Date
- 270.010 seconds Highest write time
- 0.025 seconds Sync time
Checkpoints Wal files
Key values
- 20 files Wal files usage Peak
- 2026-04-03 13:55:34 Date
Checkpoints distance
Key values
- 640.98 Mo Distance Peak
- 2026-04-03 13:55:34 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Apr 03 00 2,189 219.598s 0.088s 219.74s 01 20,571 467.007s 0.083s 467.145s 02 2,447 245.406s 0.076s 245.541s 03 2,294 230.107s 0.084s 230.245s 04 2,278 228.492s 0.078s 228.627s 05 2,258 226.505s 0.093s 226.655s 06 2,472 247.917s 0.083s 248.053s 07 6,404 483.541s 0.076s 483.665s 08 2,414 242.008s 0.082s 242.14s 09 29,000 797.129s 0.119s 797.306s 10 3,081 308.92s 0.077s 309.052s 11 3,309 331.642s 0.073s 331.766s 12 3,042 305.003s 0.075s 305.132s 13 99,102 549.207s 0.077s 549.352s 14 3,865 387.231s 0.077s 387.368s 15 4,900 490.873s 0.074s 491.001s 16 3,546 355.605s 0.076s 355.739s 17 3,400 340.851s 0.088s 340.993s 18 3,609 361.739s 0.117s 361.909s 19 3,349 335.682s 0.078s 335.831s 20 3,163 317.17s 0.074s 317.299s 21 3,106 311.455s 0.079s 311.586s 22 2,842 285.006s 0.074s 285.135s 23 3,097 310.533s 0.078s 310.668s Day Hour Added Removed Recycled Synced files Longest sync Average sync Apr 03 00 0 0 1 355 0.002s 0.012s 01 0 0 6 355 0.002s 0.011s 02 0 0 1 362 0.002s 0.012s 03 0 0 0 365 0.002s 0.012s 04 0 0 1 368 0.002s 0.012s 05 0 0 1 365 0.002s 0.012s 06 0 0 1 368 0.002s 0.012s 07 0 0 1 338 0.002s 0.011s 08 0 0 1 377 0.002s 0.011s 09 0 0 8 611 0.003s 0.011s 10 0 0 1 398 0.002s 0.012s 11 0 0 1 366 0.001s 0.012s 12 0 0 1 368 0.002s 0.012s 13 0 0 21 366 0.002s 0.012s 14 0 0 1 387 0.002s 0.012s 15 0 0 1 361 0.002s 0.012s 16 0 0 1 367 0.002s 0.012s 17 0 0 1 450 0.002s 0.012s 18 0 0 1 598 0.004s 0.012s 19 0 0 1 365 0.003s 0.012s 20 0 0 1 367 0.002s 0.012s 21 0 0 1 364 0.002s 0.012s 22 0 0 1 364 0.002s 0.012s 23 0 0 1 384 0.002s 0.012s Day Hour Count Avg time (sec) Apr 03 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Apr 03 00 1,078.67 kB 2,353.92 kB 01 9,360.18 kB 34,939.82 kB 02 1,115.92 kB 32,967.58 kB 03 1,102.75 kB 10,107.83 kB 04 1,115.42 kB 3,657.67 kB 05 1,103.33 kB 1,828.08 kB 06 1,139.58 kB 1,373.58 kB 07 2,344.18 kB 4,367.64 kB 08 1,147.73 kB 6,754.73 kB 09 11,668.64 kB 44,307.45 kB 10 1,271.75 kB 25,762.00 kB 11 1,326.50 kB 8,221.83 kB 12 1,276.42 kB 3,239.33 kB 13 28,492.83 kB 53,518.17 kB 14 1,447.00 kB 159,734.67 kB 15 1,595.00 kB 46,220.58 kB 16 1,399.75 kB 14,091.58 kB 17 1,357.42 kB 4,952.92 kB 18 1,418.17 kB 2,437.58 kB 19 1,318.42 kB 1,675.83 kB 20 1,301.83 kB 1,406.83 kB 21 1,289.17 kB 1,353.42 kB 22 1,220.83 kB 1,275.08 kB 23 1,275.42 kB 1,426.00 kB -
Temporary Files
Size of temporary files
Key values
- 125.55 MiB Temp Files size Peak
- 2026-04-03 23:57:33 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-04-03 23:22:31 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Apr 03 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 22 1.35 GiB 62.70 MiB 23 22 1.35 GiB 62.76 MiB -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 26.32 sec Highest CPU-cost vacuum
Table observability.db_top_queries
Database zemm_monitoring - 2026-04-03 13:48:39 Date
- 0 sec Highest CPU-cost analyze
Table
Database zemm_monitoring - Date
Average Autovacuum Duration
Key values
- 26.32 sec Highest CPU-cost vacuum
Table observability.db_top_queries
Database zemm_monitoring - 2026-04-03 13:48:39 Date
Analyzes per table
Key values
- pg_catalog.pg_type (3) Main table analyzed (database zemm_produktiv_8)
- 19 analyzes Total
Table Number of analyzes zemm_produktiv_8.pg_catalog.pg_type 3 zemm_produktiv_8.pg_catalog.pg_class 2 zemm_produktiv_8.public.breedingssires 2 zemm_produktiv_8.pg_catalog.pg_attribute 2 zemm_produktiv_8.pg_catalog.pg_depend 2 zemm_produktiv_8.public.breedingsdams 2 zemm_monitoring.observability.metrics_timeseries 1 fbi_unibi.pg_catalog.pg_shdepend 1 zemm_produktiv_8.public.tasks 1 zemm_monitoring.observability.system_metrics 1 zemm_monitoring.observability.nginx_counters 1 zemm_monitoring.observability.phpfpm_counters 1 Total 19 Vacuums per table
Key values
- pg_toast.pg_toast_67431 (6) Main table vacuumed on database zemm_monitoring
- 17 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,409 1,483 3,369,496 1,453 8,718 zemm_produktiv_8.public.breedingsdams 2 0 0 0 0 0 0 396 8 24,684 0 0 zemm_produktiv_8.public.breedingssires 2 0 0 0 0 0 0 296 8 18,784 0 0 zemm_produktiv_8.pg_catalog.pg_attribute 1 1 0 0 0 0 0 136 48 30,944 0 0 zemm_monitoring.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 111 26 161,727 8 22 zemm_produktiv_8.pg_catalog.pg_class 1 1 0 0 0 0 0 100 35 42,279 1 1 zemm_produktiv_8.pg_catalog.pg_depend 1 1 0 0 0 0 0 119 44 42,659 0 0 zemm_produktiv_8.pg_catalog.pg_type 1 1 0 0 0 0 0 51 16 13,016 0 0 zemm_monitoring.observability.db_top_queries 1 0 0 0 0 0 0 198,796 96,129 333,061,160 51,303 433,628 zemm_produktiv_8.public.tasks 1 1 0 0 0 0 0 43,658 47 3,214,127 4 6 Total 17 6 0 0 0 0 0 248,072 97,844 339,978,876 52,769 442,375 Vacuum throughput per table
Key values
- observability.db_top_queries (26.32) Max CPU elapsed for vacuum on database zemm_monitoring
- observability.db_top_queries (16.238 ms) Max I/O read time for vacuum on database zemm_monitoring
- observability.db_top_queries (0.122 ms) Max I/O write time for vacuum on database zemm_monitoring
I/O timing (ms) CPU (s) Table read write elapsed zemm_monitoring.pg_toast.pg_toast_67431 0 0 0.33 zemm_produktiv_8.public.breedingsdams 0 0.035 0 zemm_produktiv_8.public.breedingssires 0 0.048 0 zemm_produktiv_8.pg_catalog.pg_attribute 0 0 0.01 zemm_monitoring.pg_toast.pg_toast_2619 0 0 0 zemm_produktiv_8.pg_catalog.pg_class 0 0 0.01 zemm_produktiv_8.pg_catalog.pg_depend 0 0 0.01 zemm_produktiv_8.pg_catalog.pg_type 0 0 0 zemm_monitoring.observability.db_top_queries 16.238 0.122 26.32 zemm_produktiv_8.public.tasks 0 0 0.58 Total 16.238 0.205 27.26 Tuples removed per table
Key values
- public.tasks (53525) Main table with removed tuples on database zemm_produktiv_8
- 55805 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain zemm_produktiv_8.public.tasks 1 1 53,525 56,665 0 0 16,667 zemm_produktiv_8.pg_catalog.pg_attribute 1 1 1,035 5,651 0 0 184 zemm_produktiv_8.pg_catalog.pg_depend 1 1 846 4,171 0 0 55 zemm_produktiv_8.pg_catalog.pg_type 1 1 186 831 0 0 31 zemm_produktiv_8.pg_catalog.pg_class 1 1 150 894 0 0 42 zemm_monitoring.pg_toast.pg_toast_2619 1 1 63 80 0 0 37 zemm_produktiv_8.public.breedingsdams 2 0 0 60,778 0 0 388 zemm_produktiv_8.public.breedingssires 2 0 0 44,984 0 0 288 zemm_monitoring.observability.db_top_queries 1 0 0 7,513,693 0 0 822,758 zemm_monitoring.pg_toast.pg_toast_67431 6 0 0 1,709,130 0 0 285,905 Total 17 6 55,805 9,396,877 0 0 1,126,355 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_attribute 1 1 1035 0 zemm_monitoring.pg_toast.pg_toast_2619 1 1 63 0 zemm_produktiv_8.pg_catalog.pg_class 1 1 150 0 zemm_produktiv_8.pg_catalog.pg_depend 1 1 846 0 zemm_produktiv_8.pg_catalog.pg_type 1 1 186 0 zemm_produktiv_8.public.breedingsdams 2 0 0 0 zemm_produktiv_8.public.breedingssires 2 0 0 0 zemm_monitoring.observability.db_top_queries 1 0 0 0 zemm_monitoring.pg_toast.pg_toast_67431 6 0 0 0 zemm_produktiv_8.public.tasks 1 1 53525 0 Total 17 6 55,805 0 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Apr 03 00 0 0 01 1 1 02 1 0 03 0 0 04 0 0 05 0 0 06 1 0 07 0 0 08 3 4 09 2 3 10 1 2 11 0 1 12 0 0 13 1 0 14 1 2 15 1 0 16 0 0 17 1 2 18 2 4 19 1 0 20 0 0 21 0 0 22 0 0 23 1 0 - 26.32 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
- 40 Total read queries
- 18,730 Total write queries
Queries by database
Key values
- zemm_monitoring Main database
- 18,720 Requests
- 5h24m27s (zemm_monitoring)
- Main time consuming database
Queries by user
Key values
- labanimal Main user
- 206,953 Requests
User Request type Count Duration deploy Total 48 14m17s cte 4 1m18s ddl 27 4m22s others 2 1s624ms select 9 6m3s labanimal Total 206,953 4d8h31m26s copy from 8 18s286ms copy to 64 2m58s cte 107 2m46s ddl 205,754 4d8h5m58s others 164 1m26s select 832 17m32s tcl 2 1s129ms update 11 11s659ms postgres Total 55 1m11s copy to 55 1m11s Duration by user
Key values
- 4d8h31m26s (labanimal) Main time consuming user
User Request type Count Duration deploy Total 48 14m17s cte 4 1m18s ddl 27 4m22s others 2 1s624ms select 9 6m3s labanimal Total 206,953 4d8h31m26s copy from 8 18s286ms copy to 64 2m58s cte 107 2m46s ddl 205,754 4d8h5m58s others 164 1m26s select 832 17m32s tcl 2 1s129ms update 11 11s659ms postgres Total 55 1m11s copy to 55 1m11s Queries by host
Key values
- unknown Main host
- 206,941 Requests
- 4d8h28m17s (unknown)
- Main time consuming host
Host Request type Count Duration 81.169.238.237 Total 12 3m8s select 1 2m56s update 11 11s659ms [local] Total 103 15m28s copy to 55 1m11s cte 4 1m18s ddl 27 4m22s others 2 1s624ms select 9 6m3s unknown Total 206,941 4d8h28m17s copy from 8 18s286ms copy to 64 2m58s cte 107 2m46s ddl 205,754 4d8h5m58s others 164 1m26s select 831 14m35s tcl 2 1s129ms Queries by application
Key values
- unknown Main application
- 18,720 Requests
- 5h24m27s (unknown)
- Main time consuming application
Application Request type Count Duration _desktop_index.php_view_animal_name_on_view_animal_id_on_view_b Total 2 1s416ms select 2 1s416ms _desktop_index.php_zemm_produktiv_8_localhost_5432 Total 42 33s636ms cte 4 6s630ms select 38 27s6ms expire_tasks:zemm_produktiv_8@h2940066.stratoserver.net:5432 Total 1 922ms update 1 922ms pg_dump Total 5 6s466ms copy to 5 6s466ms unknown Total 18,720 5h24m27s ddl 18,720 5h24m27s Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-04-03 09:59:02 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 42 500-1000ms duration
Slowest individual queries
Rank Duration Query 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;[ Date: 2026-04-03 23:55:07 - Database: zemm_produktiv_8 - User: postgres - Remote: [local] - Application: pg_dump ]
2 1s724ms 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, 270) THEN TRUE WHEN user_is_tgm (dam.editor, 270) THEN TRUE WHEN user_is_tgm (dam.tourist, 270) 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, 270) THEN TRUE WHEN user_is_tgm (sire.editor, 270) THEN TRUE WHEN user_is_tgm (sire.tourist, 270) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND cagess."cageName" like ('49%') AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);[ Date: 2026-04-03 09:35:38 - Database: zemm_produktiv_8 - User: labanimal - Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 ]
3 1s724ms CREATE SCHEMA IF NOT EXISTS observability;[ Date: 2026-04-03 09:36:01 - Database: zemm_monitoring - User: labanimal ]
4 1s724ms CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );[ Date: 2026-04-03 09:36:01 - Database: zemm_monitoring - User: labanimal ]
5 1s724ms CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);[ Date: 2026-04-03 09:36:01 - Database: zemm_monitoring - User: labanimal ]
6 1s724ms CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);[ Date: 2026-04-03 09:36:01 - Database: zemm_monitoring - User: labanimal ]
7 1s724ms CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );[ Date: 2026-04-03 09:36:01 - Database: zemm_monitoring - User: labanimal ]
8 1s724ms CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);[ Date: 2026-04-03 09:36:01 - Database: zemm_monitoring - User: labanimal ]
9 1s724ms CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);[ Date: 2026-04-03 09:36:01 - Database: zemm_monitoring - User: labanimal ]
10 1s724ms CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );[ Date: 2026-04-03 09:36:01 - Database: zemm_monitoring - User: labanimal ]
11 1s724ms CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);[ Date: 2026-04-03 09:36:01 - Database: zemm_monitoring - User: labanimal ]
12 1s724ms CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );[ Date: 2026-04-03 09:36:01 - Database: zemm_monitoring - User: labanimal ]
13 1s724ms CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );[ Date: 2026-04-03 09:36:01 - Database: zemm_monitoring - User: labanimal ]
14 1s724ms CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );[ Date: 2026-04-03 09:36:01 - Database: zemm_monitoring - User: labanimal ]
15 1s724ms CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );[ Date: 2026-04-03 09:36:01 - Database: zemm_monitoring - User: labanimal ]
16 1s649ms 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, 270) THEN TRUE WHEN user_is_tgm (dam.editor, 270) THEN TRUE WHEN user_is_tgm (dam.tourist, 270) 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, 270) THEN TRUE WHEN user_is_tgm (sire.editor, 270) THEN TRUE WHEN user_is_tgm (sire.tourist, 270) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND cagess."cageName" like ('49-212') AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);[ Date: 2026-04-03 09:41:00 - Database: zemm_produktiv_8 - User: labanimal - Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 ]
17 1s649ms CREATE SCHEMA IF NOT EXISTS observability;[ Date: 2026-04-03 09:41:01 - Database: zemm_monitoring - User: labanimal ]
18 1s649ms CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );[ Date: 2026-04-03 09:41:01 - Database: zemm_monitoring - User: labanimal ]
19 1s649ms CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);[ Date: 2026-04-03 09:41:01 - Database: zemm_monitoring - User: labanimal ]
20 1s649ms CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);[ Date: 2026-04-03 09:41:01 - Database: zemm_monitoring - User: labanimal ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 24m57s 1,440 562ms 1s724ms 1s39ms create table if not exists observability.db_top_queries ( id bigserial primary key, tenant_key text not null, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz not null default now() );Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Apr 03 01 60 0ms 0ms 02 60 26s747ms 445ms 03 60 55s340ms 922ms 04 60 55s340ms 922ms 05 60 55s340ms 922ms 06 60 55s340ms 922ms 07 60 55s340ms 922ms 08 60 55s340ms 922ms 09 60 55s385ms 923ms 10 60 1m9s 1s162ms 11 60 1m38s 1s635ms 12 60 1m38s 1s635ms 13 60 1m38s 1s635ms 14 60 1m38s 1s635ms 15 60 1m38s 1s635ms 16 60 1m38s 1s635ms 17 60 1m38s 1s635ms 18 60 1m20s 1s345ms 19 60 40s450ms 674ms 20 60 40s526ms 675ms 21 60 40s526ms 675ms 22 60 40s526ms 675ms 23 60 40s526ms 675ms 00 60 43s238ms 720ms [ User: labanimal - Total duration: 24m57s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-03 09:36:01 Duration: 1s724ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-03 09:41:01 Duration: 1s649ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-03 17:41:01 Duration: 1s635ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
2 24m57s 1,440 562ms 1s724ms 1s39ms 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 #2
Day Hour Count Duration Avg duration Apr 03 01 60 0ms 0ms 02 60 26s747ms 445ms 03 60 55s340ms 922ms 04 60 55s340ms 922ms 05 60 55s340ms 922ms 06 60 55s340ms 922ms 07 60 55s340ms 922ms 08 60 55s340ms 922ms 09 60 55s385ms 923ms 10 60 1m9s 1s162ms 11 60 1m38s 1s635ms 12 60 1m38s 1s635ms 13 60 1m38s 1s635ms 14 60 1m38s 1s635ms 15 60 1m38s 1s635ms 16 60 1m38s 1s635ms 17 60 1m38s 1s635ms 18 60 1m20s 1s345ms 19 60 40s450ms 674ms 20 60 40s526ms 675ms 21 60 40s526ms 675ms 22 60 40s526ms 675ms 23 60 40s526ms 675ms 00 60 43s238ms 720ms [ User: labanimal - Total duration: 24m57s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-03 09:36:01 Duration: 1s724ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-03 09:41:01 Duration: 1s649ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-03 17:41:01 Duration: 1s635ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
3 24m57s 1,440 562ms 1s724ms 1s39ms create index if not exists idx_metrics_timeseries_bucket on observability.metrics_timeseries (bucket_start);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Apr 03 01 60 0ms 0ms 02 60 26s747ms 445ms 03 60 55s340ms 922ms 04 60 55s340ms 922ms 05 60 55s340ms 922ms 06 60 55s340ms 922ms 07 60 55s340ms 922ms 08 60 55s340ms 922ms 09 60 55s385ms 923ms 10 60 1m9s 1s162ms 11 60 1m38s 1s635ms 12 60 1m38s 1s635ms 13 60 1m38s 1s635ms 14 60 1m38s 1s635ms 15 60 1m38s 1s635ms 16 60 1m38s 1s635ms 17 60 1m38s 1s635ms 18 60 1m20s 1s345ms 19 60 40s450ms 674ms 20 60 40s526ms 675ms 21 60 40s526ms 675ms 22 60 40s526ms 675ms 23 60 40s526ms 675ms 00 60 43s238ms 720ms [ User: labanimal - Total duration: 24m57s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-04-03 09:36:01 Duration: 1s724ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-04-03 09:41:01 Duration: 1s649ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-04-03 17:41:01 Duration: 1s635ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
4 24m57s 1,440 562ms 1s724ms 1s39ms create index if not exists idx_metrics_timeseries_metric on observability.metrics_timeseries (metric_name);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Apr 03 01 60 0ms 0ms 02 60 26s747ms 445ms 03 60 55s340ms 922ms 04 60 55s340ms 922ms 05 60 55s340ms 922ms 06 60 55s340ms 922ms 07 60 55s340ms 922ms 08 60 55s340ms 922ms 09 60 55s385ms 923ms 10 60 1m9s 1s162ms 11 60 1m38s 1s635ms 12 60 1m38s 1s635ms 13 60 1m38s 1s635ms 14 60 1m38s 1s635ms 15 60 1m38s 1s635ms 16 60 1m38s 1s635ms 17 60 1m38s 1s635ms 18 60 1m20s 1s345ms 19 60 40s450ms 674ms 20 60 40s526ms 675ms 21 60 40s526ms 675ms 22 60 40s526ms 675ms 23 60 40s526ms 675ms 00 60 43s238ms 720ms [ User: labanimal - Total duration: 24m57s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-04-03 09:36:01 Duration: 1s724ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-04-03 09:41:01 Duration: 1s649ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-04-03 17:41:01 Duration: 1s635ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
5 24m57s 1,440 562ms 1s724ms 1s39ms 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 #5
Day Hour Count Duration Avg duration Apr 03 01 60 0ms 0ms 02 60 26s747ms 445ms 03 60 55s340ms 922ms 04 60 55s340ms 922ms 05 60 55s340ms 922ms 06 60 55s340ms 922ms 07 60 55s340ms 922ms 08 60 55s340ms 922ms 09 60 55s385ms 923ms 10 60 1m9s 1s162ms 11 60 1m38s 1s635ms 12 60 1m38s 1s635ms 13 60 1m38s 1s635ms 14 60 1m38s 1s635ms 15 60 1m38s 1s635ms 16 60 1m38s 1s635ms 17 60 1m38s 1s635ms 18 60 1m20s 1s345ms 19 60 40s450ms 674ms 20 60 40s526ms 675ms 21 60 40s526ms 675ms 22 60 40s526ms 675ms 23 60 40s526ms 675ms 00 60 43s238ms 720ms [ User: labanimal - Total duration: 24m57s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-03 09:36:01 Duration: 1s724ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-03 09:41:01 Duration: 1s649ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-03 17:41:01 Duration: 1s635ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
6 24m57s 1,440 562ms 1s724ms 1s39ms 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 #6
Day Hour Count Duration Avg duration Apr 03 01 60 0ms 0ms 02 60 26s747ms 445ms 03 60 55s340ms 922ms 04 60 55s340ms 922ms 05 60 55s340ms 922ms 06 60 55s340ms 922ms 07 60 55s340ms 922ms 08 60 55s340ms 922ms 09 60 55s385ms 923ms 10 60 1m9s 1s162ms 11 60 1m38s 1s635ms 12 60 1m38s 1s635ms 13 60 1m38s 1s635ms 14 60 1m38s 1s635ms 15 60 1m38s 1s635ms 16 60 1m38s 1s635ms 17 60 1m38s 1s635ms 18 60 1m20s 1s345ms 19 60 40s450ms 674ms 20 60 40s526ms 675ms 21 60 40s526ms 675ms 22 60 40s526ms 675ms 23 60 40s526ms 675ms 00 60 43s238ms 720ms [ User: labanimal - Total duration: 24m57s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-04-03 09:36:01 Duration: 1s724ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-04-03 09:41:01 Duration: 1s649ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-04-03 17:41:01 Duration: 1s635ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
7 24m57s 1,440 562ms 1s724ms 1s39ms 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 #7
Day Hour Count Duration Avg duration Apr 03 01 60 0ms 0ms 02 60 26s747ms 445ms 03 60 55s340ms 922ms 04 60 55s340ms 922ms 05 60 55s340ms 922ms 06 60 55s340ms 922ms 07 60 55s340ms 922ms 08 60 55s340ms 922ms 09 60 55s385ms 923ms 10 60 1m9s 1s162ms 11 60 1m38s 1s635ms 12 60 1m38s 1s635ms 13 60 1m38s 1s635ms 14 60 1m38s 1s635ms 15 60 1m38s 1s635ms 16 60 1m38s 1s635ms 17 60 1m38s 1s635ms 18 60 1m20s 1s345ms 19 60 40s450ms 674ms 20 60 40s526ms 675ms 21 60 40s526ms 675ms 22 60 40s526ms 675ms 23 60 40s526ms 675ms 00 60 43s238ms 720ms [ User: labanimal - Total duration: 24m57s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-04-03 09:36:01 Duration: 1s724ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-04-03 09:41:01 Duration: 1s649ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-04-03 17:41:01 Duration: 1s635ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
8 24m57s 1,440 562ms 1s724ms 1s39ms create index if not exists idx_app_events_type on observability.app_events (event_type);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Apr 03 01 60 0ms 0ms 02 60 26s747ms 445ms 03 60 55s340ms 922ms 04 60 55s340ms 922ms 05 60 55s340ms 922ms 06 60 55s340ms 922ms 07 60 55s340ms 922ms 08 60 55s340ms 922ms 09 60 55s385ms 923ms 10 60 1m9s 1s162ms 11 60 1m38s 1s635ms 12 60 1m38s 1s635ms 13 60 1m38s 1s635ms 14 60 1m38s 1s635ms 15 60 1m38s 1s635ms 16 60 1m38s 1s635ms 17 60 1m38s 1s635ms 18 60 1m20s 1s345ms 19 60 40s450ms 674ms 20 60 40s526ms 675ms 21 60 40s526ms 675ms 22 60 40s526ms 675ms 23 60 40s526ms 675ms 00 60 43s238ms 720ms [ User: labanimal - Total duration: 24m57s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-04-03 09:36:01 Duration: 1s724ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-04-03 09:41:01 Duration: 1s649ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-04-03 17:41:01 Duration: 1s635ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
9 24m57s 1,440 562ms 1s724ms 1s39ms 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 #9
Day Hour Count Duration Avg duration Apr 03 01 60 0ms 0ms 02 60 26s747ms 445ms 03 60 55s340ms 922ms 04 60 55s340ms 922ms 05 60 55s340ms 922ms 06 60 55s340ms 922ms 07 60 55s340ms 922ms 08 60 55s340ms 922ms 09 60 55s385ms 923ms 10 60 1m9s 1s162ms 11 60 1m38s 1s635ms 12 60 1m38s 1s635ms 13 60 1m38s 1s635ms 14 60 1m38s 1s635ms 15 60 1m38s 1s635ms 16 60 1m38s 1s635ms 17 60 1m38s 1s635ms 18 60 1m20s 1s345ms 19 60 40s450ms 674ms 20 60 40s526ms 675ms 21 60 40s526ms 675ms 22 60 40s526ms 675ms 23 60 40s526ms 675ms 00 60 43s238ms 720ms [ User: labanimal - Total duration: 24m57s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-03 09:36:01 Duration: 1s724ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-03 09:41:01 Duration: 1s649ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-03 17:41:01 Duration: 1s635ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
10 24m57s 1,440 562ms 1s724ms 1s39ms create index if not exists idx_app_events_tenant on observability.app_events (tenant_key, occurred_at desc);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Apr 03 01 60 0ms 0ms 02 60 26s747ms 445ms 03 60 55s340ms 922ms 04 60 55s340ms 922ms 05 60 55s340ms 922ms 06 60 55s340ms 922ms 07 60 55s340ms 922ms 08 60 55s340ms 922ms 09 60 55s385ms 923ms 10 60 1m9s 1s162ms 11 60 1m38s 1s635ms 12 60 1m38s 1s635ms 13 60 1m38s 1s635ms 14 60 1m38s 1s635ms 15 60 1m38s 1s635ms 16 60 1m38s 1s635ms 17 60 1m38s 1s635ms 18 60 1m20s 1s345ms 19 60 40s450ms 674ms 20 60 40s526ms 675ms 21 60 40s526ms 675ms 22 60 40s526ms 675ms 23 60 40s526ms 675ms 00 60 43s238ms 720ms [ User: labanimal - Total duration: 24m57s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-04-03 09:36:01 Duration: 1s724ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-04-03 09:41:01 Duration: 1s649ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-04-03 17:41:01 Duration: 1s635ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
11 24m57s 1,440 562ms 1s724ms 1s39ms create schema if not exists observability;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Apr 03 01 60 0ms 0ms 02 60 26s747ms 445ms 03 60 55s340ms 922ms 04 60 55s340ms 922ms 05 60 55s340ms 922ms 06 60 55s340ms 922ms 07 60 55s340ms 922ms 08 60 55s340ms 922ms 09 60 55s385ms 923ms 10 60 1m9s 1s162ms 11 60 1m38s 1s635ms 12 60 1m38s 1s635ms 13 60 1m38s 1s635ms 14 60 1m38s 1s635ms 15 60 1m38s 1s635ms 16 60 1m38s 1s635ms 17 60 1m38s 1s635ms 18 60 1m20s 1s345ms 19 60 40s450ms 674ms 20 60 40s526ms 675ms 21 60 40s526ms 675ms 22 60 40s526ms 675ms 23 60 40s526ms 675ms 00 60 43s238ms 720ms [ User: labanimal - Total duration: 24m57s - Times executed: 1349 ]
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-04-03 09:36:01 Duration: 1s724ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-04-03 09:41:01 Duration: 1s649ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-04-03 17:41:01 Duration: 1s635ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
12 24m57s 1,440 562ms 1s724ms 1s39ms 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 #12
Day Hour Count Duration Avg duration Apr 03 01 60 0ms 0ms 02 60 26s747ms 445ms 03 60 55s340ms 922ms 04 60 55s340ms 922ms 05 60 55s340ms 922ms 06 60 55s340ms 922ms 07 60 55s340ms 922ms 08 60 55s340ms 922ms 09 60 55s385ms 923ms 10 60 1m9s 1s162ms 11 60 1m38s 1s635ms 12 60 1m38s 1s635ms 13 60 1m38s 1s635ms 14 60 1m38s 1s635ms 15 60 1m38s 1s635ms 16 60 1m38s 1s635ms 17 60 1m38s 1s635ms 18 60 1m20s 1s345ms 19 60 40s450ms 674ms 20 60 40s526ms 675ms 21 60 40s526ms 675ms 22 60 40s526ms 675ms 23 60 40s526ms 675ms 00 60 43s238ms 720ms [ User: labanimal - Total duration: 24m57s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-03 09:36:01 Duration: 1s724ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-03 09:41:01 Duration: 1s649ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-03 17:41:01 Duration: 1s635ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
13 24m57s 1,440 562ms 1s724ms 1s39ms 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 #13
Day Hour Count Duration Avg duration Apr 03 01 60 0ms 0ms 02 60 26s747ms 445ms 03 60 55s340ms 922ms 04 60 55s340ms 922ms 05 60 55s340ms 922ms 06 60 55s340ms 922ms 07 60 55s340ms 922ms 08 60 55s340ms 922ms 09 60 55s385ms 923ms 10 60 1m9s 1s162ms 11 60 1m38s 1s635ms 12 60 1m38s 1s635ms 13 60 1m38s 1s635ms 14 60 1m38s 1s635ms 15 60 1m38s 1s635ms 16 60 1m38s 1s635ms 17 60 1m38s 1s635ms 18 60 1m20s 1s345ms 19 60 40s450ms 674ms 20 60 40s526ms 675ms 21 60 40s526ms 675ms 22 60 40s526ms 675ms 23 60 40s526ms 675ms 00 60 43s238ms 720ms [ User: labanimal - Total duration: 24m57s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-03 09:36:01 Duration: 1s724ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-03 09:41:01 Duration: 1s649ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-03 17:41:01 Duration: 1s635ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
14 13s251ms 18 722ms 752ms 736ms select count(distinct animal_id) AS "count" from ( select animals_search_mview.*, b.unbreeding_date, a.id as animal, user_is_tgm (animals_search_mview.owner, ?) as is_owner, user_is_tgm (animals_search_mview.editor, ?) as is_editor, user_is_tgm (animals_search_mview.tourist, ?) as is_tourist, case when not exists ( select ? from scoresheet_diary sd where sd.animals_id = animals_search_mview.id) then ? else ? end as isscored from animals_search_mview left join strains on strains.name = animals_search_mview.strain left join license_history lh on lh.anid = animals_search_mview.id left join animals a on a."animalID" = animals_search_mview.animal_id left join breedings b on b.id = animals_search_mview.last_mating) data where fate = ? and alive = ? and deleted = ? and (is_owner or is_editor or is_tourist);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Apr 03 18 16 11s795ms 737ms 19 2 1s456ms 728ms [ User: labanimal - Total duration: 13s251ms - Times executed: 18 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 12s510ms - Times executed: 17 ]
[ Application: _desktop_index.php_view_animal_name_on_view_animal_id_on_view_b - Total duration: 741ms - Times executed: 1 ]
-
SELECT COUNT(DISTINCT animal_id) AS "count" FROM ( SELECT animals_search_mview.*, b.unbreeding_date, a.id as animal, user_is_tgm (animals_search_mview.owner, 10100000) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100000) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100000) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN animals a ON a."animalID" = animals_search_mview.animal_id LEFT JOIN breedings b ON b.id = animals_search_mview.last_mating) data WHERE fate = 5 AND alive = 't' AND deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-04-03 17:41:09 Duration: 752ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
SELECT COUNT(DISTINCT animal_id) AS "count" FROM ( SELECT animals_search_mview.*, b.unbreeding_date, a.id as animal, user_is_tgm (animals_search_mview.owner, 10100000) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100000) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100000) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN animals a ON a."animalID" = animals_search_mview.animal_id LEFT JOIN breedings b ON b.id = animals_search_mview.last_mating) data WHERE fate = 5 AND alive = 't' AND deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-04-03 17:51:07 Duration: 746ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
SELECT COUNT(DISTINCT animal_id) AS "count" FROM ( SELECT animals_search_mview.*, b.unbreeding_date, a.id as animal, user_is_tgm (animals_search_mview.owner, 490) AS is_owner, user_is_tgm (animals_search_mview.editor, 490) AS is_editor, user_is_tgm (animals_search_mview.tourist, 490) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN animals a ON a."animalID" = animals_search_mview.animal_id LEFT JOIN breedings b ON b.id = animals_search_mview.last_mating) data WHERE fate = 5 AND alive = 't' AND deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-04-03 17:51:08 Duration: 745ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
15 12s129ms 18 662ms 692ms 673ms select distinct * from ( select animals_search_mview.*, b.unbreeding_date, fates.loc as fate_name, user_is_tgm (animals_search_mview.owner, ?) as is_owner, user_is_tgm (animals_search_mview.editor, ?) as is_editor, user_is_tgm (animals_search_mview.tourist, ?) as is_tourist, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, string_agg(l."application_id" || ? || l."title" || ? || date(lh."timestamp")::varchar, ?) as licensehistory, case when not exists ( select ? from scoresheet_diary sd where sd.animals_id = animals_search_mview.id) then ? else ? end as isscored from animals_search_mview inner join fates on fates.id = animals_search_mview.fate left join strains on strains.name = animals_search_mview.strain left join license_history lh on lh.anid = animals_search_mview.id left join licenses l on l.id = lh.licid left join breedings b on b.id = animals_search_mview.last_mating group by animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data where data.fate = ? and data.alive = ? and data.deleted = ? and (is_owner or is_editor or is_tourist) and (data.straindeleted = ? or data.straindeleted is null) order by data.cage_name, data.animal_id, data.name;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Apr 03 18 16 10s780ms 673ms 19 2 1s348ms 674ms [ User: labanimal - Total duration: 12s129ms - Times executed: 18 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 11s453ms - Times executed: 17 ]
[ Application: _desktop_index.php_view_animal_name_on_view_animal_id_on_view_b - Total duration: 675ms - Times executed: 1 ]
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 10100000) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100000) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100000) AS is_tourist, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, STRING_AGG(l."application_id" || ':' || l."title" || ' - ' || Date(lh."timestamp")::varchar, '; ') AS licensehistory, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview INNER JOIN fates ON fates.id = animals_search_mview.fate LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN licenses l ON l.id = lh.licid left join breedings b ON b.id = animals_search_mview.last_mating GROUP BY animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data WHERE data.fate = 5 AND data.alive = 't' AND data.deleted = 'f' AND (is_owner OR is_editor OR is_tourist) and (data.straindeleted = 'f' or data.straindeleted is null) ORDER BY data.cage_name, data.animal_id, data.name;
Date: 2026-04-03 17:41:10 Duration: 692ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 10100000) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100000) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100000) AS is_tourist, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, STRING_AGG(l."application_id" || ':' || l."title" || ' - ' || Date(lh."timestamp")::varchar, '; ') AS licensehistory, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview INNER JOIN fates ON fates.id = animals_search_mview.fate LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN licenses l ON l.id = lh.licid left join breedings b ON b.id = animals_search_mview.last_mating GROUP BY animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data WHERE data.fate = 5 AND data.alive = 't' AND data.deleted = 'f' AND (is_owner OR is_editor OR is_tourist) and (data.straindeleted = 'f' or data.straindeleted is null) ORDER BY data.cage_name, data.animal_id, data.name;
Date: 2026-04-03 17:51:08 Duration: 688ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 490) AS is_owner, user_is_tgm (animals_search_mview.editor, 490) AS is_editor, user_is_tgm (animals_search_mview.tourist, 490) AS is_tourist, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, STRING_AGG(l."application_id" || ':' || l."title" || ' - ' || Date(lh."timestamp")::varchar, '; ') AS licensehistory, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview INNER JOIN fates ON fates.id = animals_search_mview.fate LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN licenses l ON l.id = lh.licid left join breedings b ON b.id = animals_search_mview.last_mating GROUP BY animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data WHERE data.fate = 5 AND data.alive = 't' AND data.deleted = 'f' AND (is_owner OR is_editor OR is_tourist) and (data.straindeleted = 'f' or data.straindeleted is null) ORDER BY data.cage_name, data.animal_id, data.name;
Date: 2026-04-03 17:50:39 Duration: 684ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
16 6s630ms 4 1s621ms 1s724ms 1s657ms with damdam as ( select breedingid, string_agg(cast(dam as text), ?) as dam from breedingsdams inner join ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" from animals) as dam on dam.id = breedingsdams.dam and case when user_is_tgm (dam.owner, ?) then true when user_is_tgm (dam.editor, ?) then true when user_is_tgm (dam.tourist, ?) then true else false end group by breedingid ), siresire as ( select breedingid, string_agg(cast(sire as text), ?) as sire from breedingssires inner join ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" from animals) as sire on sire.id = breedingssires.sire and case when user_is_tgm (sire.owner, ?) then true when user_is_tgm (sire.editor, ?) then true when user_is_tgm (sire.tourist, ?) then true else false end group by breedingid ), cagess as ( select id, "cageName" from cages) ( select breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire from damdam, siresire, cagess, breedings where breedings.deleted != true and cagess.id = breedings.cage and cagess."cageName" like (?) and damdam.breedingid = breedings.id and siresire.breedingid = breedings.id and breedings."unbreeding_date" is null group by breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire order by breeding_date, plug_date);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Apr 03 10 4 6s630ms 1s657ms [ User: labanimal - Total duration: 6s630ms - Times executed: 4 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 6s630ms - Times executed: 4 ]
-
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, 270) THEN TRUE WHEN user_is_tgm (dam.editor, 270) THEN TRUE WHEN user_is_tgm (dam.tourist, 270) 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, 270) THEN TRUE WHEN user_is_tgm (sire.editor, 270) THEN TRUE WHEN user_is_tgm (sire.tourist, 270) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND cagess."cageName" like ('49%') AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-04-03 09:35:38 Duration: 1s724ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-03_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, 270) THEN TRUE WHEN user_is_tgm (dam.editor, 270) THEN TRUE WHEN user_is_tgm (dam.tourist, 270) 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, 270) THEN TRUE WHEN user_is_tgm (sire.editor, 270) THEN TRUE WHEN user_is_tgm (sire.tourist, 270) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND cagess."cageName" like ('49-212') AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-04-03 09:41:00 Duration: 1s649ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-03_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, 270) THEN TRUE WHEN user_is_tgm (dam.editor, 270) THEN TRUE WHEN user_is_tgm (dam.tourist, 270) 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, 270) THEN TRUE WHEN user_is_tgm (sire.editor, 270) THEN TRUE WHEN user_is_tgm (sire.tourist, 270) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND cagess."cageName" like ('49-212') AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-04-03 09:41:50 Duration: 1s635ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
17 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 #17
Day Hour Count Duration Avg duration Apr 03 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-04-03 23:55:07 Duration: 1s981ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
18 1s353ms 1 1s353ms 1s353ms 1s353ms copy public."targetgroupMembers" (id, targetgroup, "user", "group") to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Apr 03 00 1 1s353ms 1s353ms [ User: postgres - Total duration: 1s353ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s353ms - Times executed: 1 ]
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-04-03 23:55:10 Duration: 1s353ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
19 1s316ms 1 1s316ms 1s316ms 1s316ms copy public.animals_search_mview (id, name, animal_id, deleted, alive, birth_date, arrival_date, death_date, outgoing_date, cage, comments, sterile, breeding, fate, last_mating, last_mating_date, breeding_cage, sex, strain, line, gene_1_info, gene_1_type, gene_2_info, gene_2_type, gene_3_info, gene_3_type, gene_4_info, gene_4_type, gene_5_info, gene_5_type, backcross, generation, project, project_name, species, species_name, cage_name, location, location_name, dam, dam_name, dam_id, sire, sire_name, sire_id, cohort, litter, rfid, owner, editor, tourist, breeding_status, workgroup_infos, experiment, experiment_name) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Apr 03 00 1 1s316ms 1s316ms [ User: postgres - Total duration: 1s316ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s316ms - 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-04-03 23:55:04 Duration: 1s316ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
20 1s268ms 1 1s268ms 1s268ms 1s268ms 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 Apr 03 00 1 1s268ms 1s268ms [ User: postgres - Total duration: 1s268ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s268ms - 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-04-03 23:55:03 Duration: 1s268ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,440 24m57s 562ms 1s724ms 1s39ms create table if not exists observability.db_top_queries ( id bigserial primary key, tenant_key text not null, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz not null default now() );Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Apr 03 01 60 0ms 0ms 02 60 26s747ms 445ms 03 60 55s340ms 922ms 04 60 55s340ms 922ms 05 60 55s340ms 922ms 06 60 55s340ms 922ms 07 60 55s340ms 922ms 08 60 55s340ms 922ms 09 60 55s385ms 923ms 10 60 1m9s 1s162ms 11 60 1m38s 1s635ms 12 60 1m38s 1s635ms 13 60 1m38s 1s635ms 14 60 1m38s 1s635ms 15 60 1m38s 1s635ms 16 60 1m38s 1s635ms 17 60 1m38s 1s635ms 18 60 1m20s 1s345ms 19 60 40s450ms 674ms 20 60 40s526ms 675ms 21 60 40s526ms 675ms 22 60 40s526ms 675ms 23 60 40s526ms 675ms 00 60 43s238ms 720ms [ User: labanimal - Total duration: 24m57s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-03 09:36:01 Duration: 1s724ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-03 09:41:01 Duration: 1s649ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-03 17:41:01 Duration: 1s635ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
2 1,440 24m57s 562ms 1s724ms 1s39ms 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 #2
Day Hour Count Duration Avg duration Apr 03 01 60 0ms 0ms 02 60 26s747ms 445ms 03 60 55s340ms 922ms 04 60 55s340ms 922ms 05 60 55s340ms 922ms 06 60 55s340ms 922ms 07 60 55s340ms 922ms 08 60 55s340ms 922ms 09 60 55s385ms 923ms 10 60 1m9s 1s162ms 11 60 1m38s 1s635ms 12 60 1m38s 1s635ms 13 60 1m38s 1s635ms 14 60 1m38s 1s635ms 15 60 1m38s 1s635ms 16 60 1m38s 1s635ms 17 60 1m38s 1s635ms 18 60 1m20s 1s345ms 19 60 40s450ms 674ms 20 60 40s526ms 675ms 21 60 40s526ms 675ms 22 60 40s526ms 675ms 23 60 40s526ms 675ms 00 60 43s238ms 720ms [ User: labanimal - Total duration: 24m57s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-03 09:36:01 Duration: 1s724ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-03 09:41:01 Duration: 1s649ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-03 17:41:01 Duration: 1s635ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
3 1,440 24m57s 562ms 1s724ms 1s39ms create index if not exists idx_metrics_timeseries_bucket on observability.metrics_timeseries (bucket_start);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Apr 03 01 60 0ms 0ms 02 60 26s747ms 445ms 03 60 55s340ms 922ms 04 60 55s340ms 922ms 05 60 55s340ms 922ms 06 60 55s340ms 922ms 07 60 55s340ms 922ms 08 60 55s340ms 922ms 09 60 55s385ms 923ms 10 60 1m9s 1s162ms 11 60 1m38s 1s635ms 12 60 1m38s 1s635ms 13 60 1m38s 1s635ms 14 60 1m38s 1s635ms 15 60 1m38s 1s635ms 16 60 1m38s 1s635ms 17 60 1m38s 1s635ms 18 60 1m20s 1s345ms 19 60 40s450ms 674ms 20 60 40s526ms 675ms 21 60 40s526ms 675ms 22 60 40s526ms 675ms 23 60 40s526ms 675ms 00 60 43s238ms 720ms [ User: labanimal - Total duration: 24m57s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-04-03 09:36:01 Duration: 1s724ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-04-03 09:41:01 Duration: 1s649ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-04-03 17:41:01 Duration: 1s635ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
4 1,440 24m57s 562ms 1s724ms 1s39ms create index if not exists idx_metrics_timeseries_metric on observability.metrics_timeseries (metric_name);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Apr 03 01 60 0ms 0ms 02 60 26s747ms 445ms 03 60 55s340ms 922ms 04 60 55s340ms 922ms 05 60 55s340ms 922ms 06 60 55s340ms 922ms 07 60 55s340ms 922ms 08 60 55s340ms 922ms 09 60 55s385ms 923ms 10 60 1m9s 1s162ms 11 60 1m38s 1s635ms 12 60 1m38s 1s635ms 13 60 1m38s 1s635ms 14 60 1m38s 1s635ms 15 60 1m38s 1s635ms 16 60 1m38s 1s635ms 17 60 1m38s 1s635ms 18 60 1m20s 1s345ms 19 60 40s450ms 674ms 20 60 40s526ms 675ms 21 60 40s526ms 675ms 22 60 40s526ms 675ms 23 60 40s526ms 675ms 00 60 43s238ms 720ms [ User: labanimal - Total duration: 24m57s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-04-03 09:36:01 Duration: 1s724ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-04-03 09:41:01 Duration: 1s649ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-04-03 17:41:01 Duration: 1s635ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
5 1,440 24m57s 562ms 1s724ms 1s39ms 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 #5
Day Hour Count Duration Avg duration Apr 03 01 60 0ms 0ms 02 60 26s747ms 445ms 03 60 55s340ms 922ms 04 60 55s340ms 922ms 05 60 55s340ms 922ms 06 60 55s340ms 922ms 07 60 55s340ms 922ms 08 60 55s340ms 922ms 09 60 55s385ms 923ms 10 60 1m9s 1s162ms 11 60 1m38s 1s635ms 12 60 1m38s 1s635ms 13 60 1m38s 1s635ms 14 60 1m38s 1s635ms 15 60 1m38s 1s635ms 16 60 1m38s 1s635ms 17 60 1m38s 1s635ms 18 60 1m20s 1s345ms 19 60 40s450ms 674ms 20 60 40s526ms 675ms 21 60 40s526ms 675ms 22 60 40s526ms 675ms 23 60 40s526ms 675ms 00 60 43s238ms 720ms [ User: labanimal - Total duration: 24m57s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-03 09:36:01 Duration: 1s724ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-03 09:41:01 Duration: 1s649ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-03 17:41:01 Duration: 1s635ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
6 1,440 24m57s 562ms 1s724ms 1s39ms 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 #6
Day Hour Count Duration Avg duration Apr 03 01 60 0ms 0ms 02 60 26s747ms 445ms 03 60 55s340ms 922ms 04 60 55s340ms 922ms 05 60 55s340ms 922ms 06 60 55s340ms 922ms 07 60 55s340ms 922ms 08 60 55s340ms 922ms 09 60 55s385ms 923ms 10 60 1m9s 1s162ms 11 60 1m38s 1s635ms 12 60 1m38s 1s635ms 13 60 1m38s 1s635ms 14 60 1m38s 1s635ms 15 60 1m38s 1s635ms 16 60 1m38s 1s635ms 17 60 1m38s 1s635ms 18 60 1m20s 1s345ms 19 60 40s450ms 674ms 20 60 40s526ms 675ms 21 60 40s526ms 675ms 22 60 40s526ms 675ms 23 60 40s526ms 675ms 00 60 43s238ms 720ms [ User: labanimal - Total duration: 24m57s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-04-03 09:36:01 Duration: 1s724ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-04-03 09:41:01 Duration: 1s649ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-04-03 17:41:01 Duration: 1s635ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
7 1,440 24m57s 562ms 1s724ms 1s39ms 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 #7
Day Hour Count Duration Avg duration Apr 03 01 60 0ms 0ms 02 60 26s747ms 445ms 03 60 55s340ms 922ms 04 60 55s340ms 922ms 05 60 55s340ms 922ms 06 60 55s340ms 922ms 07 60 55s340ms 922ms 08 60 55s340ms 922ms 09 60 55s385ms 923ms 10 60 1m9s 1s162ms 11 60 1m38s 1s635ms 12 60 1m38s 1s635ms 13 60 1m38s 1s635ms 14 60 1m38s 1s635ms 15 60 1m38s 1s635ms 16 60 1m38s 1s635ms 17 60 1m38s 1s635ms 18 60 1m20s 1s345ms 19 60 40s450ms 674ms 20 60 40s526ms 675ms 21 60 40s526ms 675ms 22 60 40s526ms 675ms 23 60 40s526ms 675ms 00 60 43s238ms 720ms [ User: labanimal - Total duration: 24m57s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-04-03 09:36:01 Duration: 1s724ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-04-03 09:41:01 Duration: 1s649ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-04-03 17:41:01 Duration: 1s635ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
8 1,440 24m57s 562ms 1s724ms 1s39ms create index if not exists idx_app_events_type on observability.app_events (event_type);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Apr 03 01 60 0ms 0ms 02 60 26s747ms 445ms 03 60 55s340ms 922ms 04 60 55s340ms 922ms 05 60 55s340ms 922ms 06 60 55s340ms 922ms 07 60 55s340ms 922ms 08 60 55s340ms 922ms 09 60 55s385ms 923ms 10 60 1m9s 1s162ms 11 60 1m38s 1s635ms 12 60 1m38s 1s635ms 13 60 1m38s 1s635ms 14 60 1m38s 1s635ms 15 60 1m38s 1s635ms 16 60 1m38s 1s635ms 17 60 1m38s 1s635ms 18 60 1m20s 1s345ms 19 60 40s450ms 674ms 20 60 40s526ms 675ms 21 60 40s526ms 675ms 22 60 40s526ms 675ms 23 60 40s526ms 675ms 00 60 43s238ms 720ms [ User: labanimal - Total duration: 24m57s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-04-03 09:36:01 Duration: 1s724ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-04-03 09:41:01 Duration: 1s649ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-04-03 17:41:01 Duration: 1s635ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
9 1,440 24m57s 562ms 1s724ms 1s39ms 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 #9
Day Hour Count Duration Avg duration Apr 03 01 60 0ms 0ms 02 60 26s747ms 445ms 03 60 55s340ms 922ms 04 60 55s340ms 922ms 05 60 55s340ms 922ms 06 60 55s340ms 922ms 07 60 55s340ms 922ms 08 60 55s340ms 922ms 09 60 55s385ms 923ms 10 60 1m9s 1s162ms 11 60 1m38s 1s635ms 12 60 1m38s 1s635ms 13 60 1m38s 1s635ms 14 60 1m38s 1s635ms 15 60 1m38s 1s635ms 16 60 1m38s 1s635ms 17 60 1m38s 1s635ms 18 60 1m20s 1s345ms 19 60 40s450ms 674ms 20 60 40s526ms 675ms 21 60 40s526ms 675ms 22 60 40s526ms 675ms 23 60 40s526ms 675ms 00 60 43s238ms 720ms [ User: labanimal - Total duration: 24m57s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-03 09:36:01 Duration: 1s724ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-03 09:41:01 Duration: 1s649ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-03 17:41:01 Duration: 1s635ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
10 1,440 24m57s 562ms 1s724ms 1s39ms create index if not exists idx_app_events_tenant on observability.app_events (tenant_key, occurred_at desc);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Apr 03 01 60 0ms 0ms 02 60 26s747ms 445ms 03 60 55s340ms 922ms 04 60 55s340ms 922ms 05 60 55s340ms 922ms 06 60 55s340ms 922ms 07 60 55s340ms 922ms 08 60 55s340ms 922ms 09 60 55s385ms 923ms 10 60 1m9s 1s162ms 11 60 1m38s 1s635ms 12 60 1m38s 1s635ms 13 60 1m38s 1s635ms 14 60 1m38s 1s635ms 15 60 1m38s 1s635ms 16 60 1m38s 1s635ms 17 60 1m38s 1s635ms 18 60 1m20s 1s345ms 19 60 40s450ms 674ms 20 60 40s526ms 675ms 21 60 40s526ms 675ms 22 60 40s526ms 675ms 23 60 40s526ms 675ms 00 60 43s238ms 720ms [ User: labanimal - Total duration: 24m57s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-04-03 09:36:01 Duration: 1s724ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-04-03 09:41:01 Duration: 1s649ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-04-03 17:41:01 Duration: 1s635ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
11 1,440 24m57s 562ms 1s724ms 1s39ms create schema if not exists observability;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Apr 03 01 60 0ms 0ms 02 60 26s747ms 445ms 03 60 55s340ms 922ms 04 60 55s340ms 922ms 05 60 55s340ms 922ms 06 60 55s340ms 922ms 07 60 55s340ms 922ms 08 60 55s340ms 922ms 09 60 55s385ms 923ms 10 60 1m9s 1s162ms 11 60 1m38s 1s635ms 12 60 1m38s 1s635ms 13 60 1m38s 1s635ms 14 60 1m38s 1s635ms 15 60 1m38s 1s635ms 16 60 1m38s 1s635ms 17 60 1m38s 1s635ms 18 60 1m20s 1s345ms 19 60 40s450ms 674ms 20 60 40s526ms 675ms 21 60 40s526ms 675ms 22 60 40s526ms 675ms 23 60 40s526ms 675ms 00 60 43s238ms 720ms [ User: labanimal - Total duration: 24m57s - Times executed: 1349 ]
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-04-03 09:36:01 Duration: 1s724ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-04-03 09:41:01 Duration: 1s649ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-04-03 17:41:01 Duration: 1s635ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
12 1,440 24m57s 562ms 1s724ms 1s39ms 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 #12
Day Hour Count Duration Avg duration Apr 03 01 60 0ms 0ms 02 60 26s747ms 445ms 03 60 55s340ms 922ms 04 60 55s340ms 922ms 05 60 55s340ms 922ms 06 60 55s340ms 922ms 07 60 55s340ms 922ms 08 60 55s340ms 922ms 09 60 55s385ms 923ms 10 60 1m9s 1s162ms 11 60 1m38s 1s635ms 12 60 1m38s 1s635ms 13 60 1m38s 1s635ms 14 60 1m38s 1s635ms 15 60 1m38s 1s635ms 16 60 1m38s 1s635ms 17 60 1m38s 1s635ms 18 60 1m20s 1s345ms 19 60 40s450ms 674ms 20 60 40s526ms 675ms 21 60 40s526ms 675ms 22 60 40s526ms 675ms 23 60 40s526ms 675ms 00 60 43s238ms 720ms [ User: labanimal - Total duration: 24m57s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-03 09:36:01 Duration: 1s724ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-03 09:41:01 Duration: 1s649ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-03 17:41:01 Duration: 1s635ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
13 1,440 24m57s 562ms 1s724ms 1s39ms 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 #13
Day Hour Count Duration Avg duration Apr 03 01 60 0ms 0ms 02 60 26s747ms 445ms 03 60 55s340ms 922ms 04 60 55s340ms 922ms 05 60 55s340ms 922ms 06 60 55s340ms 922ms 07 60 55s340ms 922ms 08 60 55s340ms 922ms 09 60 55s385ms 923ms 10 60 1m9s 1s162ms 11 60 1m38s 1s635ms 12 60 1m38s 1s635ms 13 60 1m38s 1s635ms 14 60 1m38s 1s635ms 15 60 1m38s 1s635ms 16 60 1m38s 1s635ms 17 60 1m38s 1s635ms 18 60 1m20s 1s345ms 19 60 40s450ms 674ms 20 60 40s526ms 675ms 21 60 40s526ms 675ms 22 60 40s526ms 675ms 23 60 40s526ms 675ms 00 60 43s238ms 720ms [ User: labanimal - Total duration: 24m57s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-03 09:36:01 Duration: 1s724ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-03 09:41:01 Duration: 1s649ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-03 17:41:01 Duration: 1s635ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
14 18 13s251ms 722ms 752ms 736ms select count(distinct animal_id) AS "count" from ( select animals_search_mview.*, b.unbreeding_date, a.id as animal, user_is_tgm (animals_search_mview.owner, ?) as is_owner, user_is_tgm (animals_search_mview.editor, ?) as is_editor, user_is_tgm (animals_search_mview.tourist, ?) as is_tourist, case when not exists ( select ? from scoresheet_diary sd where sd.animals_id = animals_search_mview.id) then ? else ? end as isscored from animals_search_mview left join strains on strains.name = animals_search_mview.strain left join license_history lh on lh.anid = animals_search_mview.id left join animals a on a."animalID" = animals_search_mview.animal_id left join breedings b on b.id = animals_search_mview.last_mating) data where fate = ? and alive = ? and deleted = ? and (is_owner or is_editor or is_tourist);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Apr 03 18 16 11s795ms 737ms 19 2 1s456ms 728ms [ User: labanimal - Total duration: 13s251ms - Times executed: 18 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 12s510ms - Times executed: 17 ]
[ Application: _desktop_index.php_view_animal_name_on_view_animal_id_on_view_b - Total duration: 741ms - Times executed: 1 ]
-
SELECT COUNT(DISTINCT animal_id) AS "count" FROM ( SELECT animals_search_mview.*, b.unbreeding_date, a.id as animal, user_is_tgm (animals_search_mview.owner, 10100000) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100000) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100000) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN animals a ON a."animalID" = animals_search_mview.animal_id LEFT JOIN breedings b ON b.id = animals_search_mview.last_mating) data WHERE fate = 5 AND alive = 't' AND deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-04-03 17:41:09 Duration: 752ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
SELECT COUNT(DISTINCT animal_id) AS "count" FROM ( SELECT animals_search_mview.*, b.unbreeding_date, a.id as animal, user_is_tgm (animals_search_mview.owner, 10100000) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100000) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100000) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN animals a ON a."animalID" = animals_search_mview.animal_id LEFT JOIN breedings b ON b.id = animals_search_mview.last_mating) data WHERE fate = 5 AND alive = 't' AND deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-04-03 17:51:07 Duration: 746ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
SELECT COUNT(DISTINCT animal_id) AS "count" FROM ( SELECT animals_search_mview.*, b.unbreeding_date, a.id as animal, user_is_tgm (animals_search_mview.owner, 490) AS is_owner, user_is_tgm (animals_search_mview.editor, 490) AS is_editor, user_is_tgm (animals_search_mview.tourist, 490) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN animals a ON a."animalID" = animals_search_mview.animal_id LEFT JOIN breedings b ON b.id = animals_search_mview.last_mating) data WHERE fate = 5 AND alive = 't' AND deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-04-03 17:51:08 Duration: 745ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
15 18 12s129ms 662ms 692ms 673ms select distinct * from ( select animals_search_mview.*, b.unbreeding_date, fates.loc as fate_name, user_is_tgm (animals_search_mview.owner, ?) as is_owner, user_is_tgm (animals_search_mview.editor, ?) as is_editor, user_is_tgm (animals_search_mview.tourist, ?) as is_tourist, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, string_agg(l."application_id" || ? || l."title" || ? || date(lh."timestamp")::varchar, ?) as licensehistory, case when not exists ( select ? from scoresheet_diary sd where sd.animals_id = animals_search_mview.id) then ? else ? end as isscored from animals_search_mview inner join fates on fates.id = animals_search_mview.fate left join strains on strains.name = animals_search_mview.strain left join license_history lh on lh.anid = animals_search_mview.id left join licenses l on l.id = lh.licid left join breedings b on b.id = animals_search_mview.last_mating group by animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data where data.fate = ? and data.alive = ? and data.deleted = ? and (is_owner or is_editor or is_tourist) and (data.straindeleted = ? or data.straindeleted is null) order by data.cage_name, data.animal_id, data.name;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Apr 03 18 16 10s780ms 673ms 19 2 1s348ms 674ms [ User: labanimal - Total duration: 12s129ms - Times executed: 18 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 11s453ms - Times executed: 17 ]
[ Application: _desktop_index.php_view_animal_name_on_view_animal_id_on_view_b - Total duration: 675ms - Times executed: 1 ]
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 10100000) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100000) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100000) AS is_tourist, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, STRING_AGG(l."application_id" || ':' || l."title" || ' - ' || Date(lh."timestamp")::varchar, '; ') AS licensehistory, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview INNER JOIN fates ON fates.id = animals_search_mview.fate LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN licenses l ON l.id = lh.licid left join breedings b ON b.id = animals_search_mview.last_mating GROUP BY animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data WHERE data.fate = 5 AND data.alive = 't' AND data.deleted = 'f' AND (is_owner OR is_editor OR is_tourist) and (data.straindeleted = 'f' or data.straindeleted is null) ORDER BY data.cage_name, data.animal_id, data.name;
Date: 2026-04-03 17:41:10 Duration: 692ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 10100000) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100000) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100000) AS is_tourist, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, STRING_AGG(l."application_id" || ':' || l."title" || ' - ' || Date(lh."timestamp")::varchar, '; ') AS licensehistory, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview INNER JOIN fates ON fates.id = animals_search_mview.fate LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN licenses l ON l.id = lh.licid left join breedings b ON b.id = animals_search_mview.last_mating GROUP BY animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data WHERE data.fate = 5 AND data.alive = 't' AND data.deleted = 'f' AND (is_owner OR is_editor OR is_tourist) and (data.straindeleted = 'f' or data.straindeleted is null) ORDER BY data.cage_name, data.animal_id, data.name;
Date: 2026-04-03 17:51:08 Duration: 688ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 490) AS is_owner, user_is_tgm (animals_search_mview.editor, 490) AS is_editor, user_is_tgm (animals_search_mview.tourist, 490) AS is_tourist, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, STRING_AGG(l."application_id" || ':' || l."title" || ' - ' || Date(lh."timestamp")::varchar, '; ') AS licensehistory, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview INNER JOIN fates ON fates.id = animals_search_mview.fate LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN licenses l ON l.id = lh.licid left join breedings b ON b.id = animals_search_mview.last_mating GROUP BY animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data WHERE data.fate = 5 AND data.alive = 't' AND data.deleted = 'f' AND (is_owner OR is_editor OR is_tourist) and (data.straindeleted = 'f' or data.straindeleted is null) ORDER BY data.cage_name, data.animal_id, data.name;
Date: 2026-04-03 17:50:39 Duration: 684ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
16 4 6s630ms 1s621ms 1s724ms 1s657ms with damdam as ( select breedingid, string_agg(cast(dam as text), ?) as dam from breedingsdams inner join ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" from animals) as dam on dam.id = breedingsdams.dam and case when user_is_tgm (dam.owner, ?) then true when user_is_tgm (dam.editor, ?) then true when user_is_tgm (dam.tourist, ?) then true else false end group by breedingid ), siresire as ( select breedingid, string_agg(cast(sire as text), ?) as sire from breedingssires inner join ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" from animals) as sire on sire.id = breedingssires.sire and case when user_is_tgm (sire.owner, ?) then true when user_is_tgm (sire.editor, ?) then true when user_is_tgm (sire.tourist, ?) then true else false end group by breedingid ), cagess as ( select id, "cageName" from cages) ( select breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire from damdam, siresire, cagess, breedings where breedings.deleted != true and cagess.id = breedings.cage and cagess."cageName" like (?) and damdam.breedingid = breedings.id and siresire.breedingid = breedings.id and breedings."unbreeding_date" is null group by breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire order by breeding_date, plug_date);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Apr 03 10 4 6s630ms 1s657ms [ User: labanimal - Total duration: 6s630ms - Times executed: 4 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 6s630ms - Times executed: 4 ]
-
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, 270) THEN TRUE WHEN user_is_tgm (dam.editor, 270) THEN TRUE WHEN user_is_tgm (dam.tourist, 270) 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, 270) THEN TRUE WHEN user_is_tgm (sire.editor, 270) THEN TRUE WHEN user_is_tgm (sire.tourist, 270) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND cagess."cageName" like ('49%') AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-04-03 09:35:38 Duration: 1s724ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-03_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, 270) THEN TRUE WHEN user_is_tgm (dam.editor, 270) THEN TRUE WHEN user_is_tgm (dam.tourist, 270) 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, 270) THEN TRUE WHEN user_is_tgm (sire.editor, 270) THEN TRUE WHEN user_is_tgm (sire.tourist, 270) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND cagess."cageName" like ('49-212') AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-04-03 09:41:00 Duration: 1s649ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-03_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, 270) THEN TRUE WHEN user_is_tgm (dam.editor, 270) THEN TRUE WHEN user_is_tgm (dam.tourist, 270) 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, 270) THEN TRUE WHEN user_is_tgm (sire.editor, 270) THEN TRUE WHEN user_is_tgm (sire.tourist, 270) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND cagess."cageName" like ('49-212') AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-04-03 09:41:50 Duration: 1s635ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
17 2 1s126ms 562ms 564ms 563ms select breedings.id, cages.id as cage_db_id, cages."cageName" as cage_name, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, breedings.sires, breedings.dams from breedings inner join ( select id, name, "animalID", "homeCage", tourist, editor, owner from animals) as dam on position((?| | dam.id || ?) in (?| | breedings.dams || ?)) > ? inner join ( select id, name, "animalID" from animals) as sire on position((?| | sire.id || ?) in (?| | breedings.sires || ?)) > ? inner join cages on cages.id = breedings.cage where breedings.id = ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Apr 03 10 2 1s126ms 563ms [ User: labanimal - Total duration: 1s126ms - Times executed: 2 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 1s126ms - Times executed: 2 ]
-
SELECT breedings.id, cages.id as cage_db_id, cages."cageName" as cage_name, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, breedings.sires, breedings.dams FROM breedings INNER JOIN ( select id, name, "animalID", "homeCage", tourist, editor, owner from animals) AS dam ON POSITION((';' || dam.id || ';') IN (';' || breedings.dams || ';')) > 0 INNER JOIN ( select id, name, "animalID" from animals) AS sire ON POSITION((';' || sire.id || ';') IN (';' || breedings.sires || ';')) > 0 INNER JOIN cages ON cages.id = breedings.cage WHERE breedings.id = 10111163;
Date: 2026-04-03 09:36:39 Duration: 564ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
SELECT breedings.id, cages.id as cage_db_id, cages."cageName" as cage_name, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, breedings.sires, breedings.dams FROM breedings INNER JOIN ( select id, name, "animalID", "homeCage", tourist, editor, owner from animals) AS dam ON POSITION((';' || dam.id || ';') IN (';' || breedings.dams || ';')) > 0 INNER JOIN ( select id, name, "animalID" from animals) AS sire ON POSITION((';' || sire.id || ';') IN (';' || breedings.sires || ';')) > 0 INNER JOIN cages ON cages.id = breedings.cage WHERE breedings.id = 10111163;
Date: 2026-04-03 09:37:00 Duration: 562ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
18 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 #18
Day Hour Count Duration Avg duration Apr 03 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-04-03 23:55:07 Duration: 1s981ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
19 1 1s353ms 1s353ms 1s353ms 1s353ms copy public."targetgroupMembers" (id, targetgroup, "user", "group") to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Apr 03 00 1 1s353ms 1s353ms [ User: postgres - Total duration: 1s353ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s353ms - Times executed: 1 ]
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-04-03 23:55:10 Duration: 1s353ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
20 1 1s316ms 1s316ms 1s316ms 1s316ms 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 #20
Day Hour Count Duration Avg duration Apr 03 00 1 1s316ms 1s316ms [ User: postgres - Total duration: 1s316ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s316ms - 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-04-03 23:55:04 Duration: 1s316ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 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 #1
Day Hour Count Duration Avg duration Apr 03 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-04-03 23:55:07 Duration: 1s981ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
2 1s621ms 1s724ms 1s657ms 4 6s630ms with damdam as ( select breedingid, string_agg(cast(dam as text), ?) as dam from breedingsdams inner join ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" from animals) as dam on dam.id = breedingsdams.dam and case when user_is_tgm (dam.owner, ?) then true when user_is_tgm (dam.editor, ?) then true when user_is_tgm (dam.tourist, ?) then true else false end group by breedingid ), siresire as ( select breedingid, string_agg(cast(sire as text), ?) as sire from breedingssires inner join ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" from animals) as sire on sire.id = breedingssires.sire and case when user_is_tgm (sire.owner, ?) then true when user_is_tgm (sire.editor, ?) then true when user_is_tgm (sire.tourist, ?) then true else false end group by breedingid ), cagess as ( select id, "cageName" from cages) ( select breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire from damdam, siresire, cagess, breedings where breedings.deleted != true and cagess.id = breedings.cage and cagess."cageName" like (?) and damdam.breedingid = breedings.id and siresire.breedingid = breedings.id and breedings."unbreeding_date" is null group by breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire order by breeding_date, plug_date);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Apr 03 10 4 6s630ms 1s657ms [ User: labanimal - Total duration: 6s630ms - Times executed: 4 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 6s630ms - Times executed: 4 ]
-
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, 270) THEN TRUE WHEN user_is_tgm (dam.editor, 270) THEN TRUE WHEN user_is_tgm (dam.tourist, 270) 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, 270) THEN TRUE WHEN user_is_tgm (sire.editor, 270) THEN TRUE WHEN user_is_tgm (sire.tourist, 270) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND cagess."cageName" like ('49%') AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-04-03 09:35:38 Duration: 1s724ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-03_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, 270) THEN TRUE WHEN user_is_tgm (dam.editor, 270) THEN TRUE WHEN user_is_tgm (dam.tourist, 270) 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, 270) THEN TRUE WHEN user_is_tgm (sire.editor, 270) THEN TRUE WHEN user_is_tgm (sire.tourist, 270) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND cagess."cageName" like ('49-212') AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-04-03 09:41:00 Duration: 1s649ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-03_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, 270) THEN TRUE WHEN user_is_tgm (dam.editor, 270) THEN TRUE WHEN user_is_tgm (dam.tourist, 270) 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, 270) THEN TRUE WHEN user_is_tgm (sire.editor, 270) THEN TRUE WHEN user_is_tgm (sire.tourist, 270) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND cagess."cageName" like ('49-212') AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-04-03 09:41:50 Duration: 1s635ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
3 1s353ms 1s353ms 1s353ms 1 1s353ms copy public."targetgroupMembers" (id, targetgroup, "user", "group") to stdout;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Apr 03 00 1 1s353ms 1s353ms [ User: postgres - Total duration: 1s353ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s353ms - Times executed: 1 ]
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-04-03 23:55:10 Duration: 1s353ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
4 1s316ms 1s316ms 1s316ms 1 1s316ms 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 Apr 03 00 1 1s316ms 1s316ms [ User: postgres - Total duration: 1s316ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s316ms - 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-04-03 23:55:04 Duration: 1s316ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
5 1s268ms 1s268ms 1s268ms 1 1s268ms 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 #5
Day Hour Count Duration Avg duration Apr 03 00 1 1s268ms 1s268ms [ User: postgres - Total duration: 1s268ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s268ms - 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-04-03 23:55:03 Duration: 1s268ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
6 562ms 1s724ms 1s39ms 1,440 24m57s 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 #6
Day Hour Count Duration Avg duration Apr 03 01 60 0ms 0ms 02 60 26s747ms 445ms 03 60 55s340ms 922ms 04 60 55s340ms 922ms 05 60 55s340ms 922ms 06 60 55s340ms 922ms 07 60 55s340ms 922ms 08 60 55s340ms 922ms 09 60 55s385ms 923ms 10 60 1m9s 1s162ms 11 60 1m38s 1s635ms 12 60 1m38s 1s635ms 13 60 1m38s 1s635ms 14 60 1m38s 1s635ms 15 60 1m38s 1s635ms 16 60 1m38s 1s635ms 17 60 1m38s 1s635ms 18 60 1m20s 1s345ms 19 60 40s450ms 674ms 20 60 40s526ms 675ms 21 60 40s526ms 675ms 22 60 40s526ms 675ms 23 60 40s526ms 675ms 00 60 43s238ms 720ms [ User: labanimal - Total duration: 24m57s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-03 09:36:01 Duration: 1s724ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-03 09:41:01 Duration: 1s649ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-03 17:41:01 Duration: 1s635ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
7 562ms 1s724ms 1s39ms 1,440 24m57s create table if not exists observability.phpfpm_counters ( id bigserial primary key, payload jsonb not null, collected_at timestamptz not null default now() );Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Apr 03 01 60 0ms 0ms 02 60 26s747ms 445ms 03 60 55s340ms 922ms 04 60 55s340ms 922ms 05 60 55s340ms 922ms 06 60 55s340ms 922ms 07 60 55s340ms 922ms 08 60 55s340ms 922ms 09 60 55s385ms 923ms 10 60 1m9s 1s162ms 11 60 1m38s 1s635ms 12 60 1m38s 1s635ms 13 60 1m38s 1s635ms 14 60 1m38s 1s635ms 15 60 1m38s 1s635ms 16 60 1m38s 1s635ms 17 60 1m38s 1s635ms 18 60 1m20s 1s345ms 19 60 40s450ms 674ms 20 60 40s526ms 675ms 21 60 40s526ms 675ms 22 60 40s526ms 675ms 23 60 40s526ms 675ms 00 60 43s238ms 720ms [ User: labanimal - Total duration: 24m57s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-03 09:36:01 Duration: 1s724ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-03 09:41:01 Duration: 1s649ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-03 17:41:01 Duration: 1s635ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
8 562ms 1s724ms 1s39ms 1,440 24m57s create index if not exists idx_metrics_timeseries_bucket on observability.metrics_timeseries (bucket_start);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Apr 03 01 60 0ms 0ms 02 60 26s747ms 445ms 03 60 55s340ms 922ms 04 60 55s340ms 922ms 05 60 55s340ms 922ms 06 60 55s340ms 922ms 07 60 55s340ms 922ms 08 60 55s340ms 922ms 09 60 55s385ms 923ms 10 60 1m9s 1s162ms 11 60 1m38s 1s635ms 12 60 1m38s 1s635ms 13 60 1m38s 1s635ms 14 60 1m38s 1s635ms 15 60 1m38s 1s635ms 16 60 1m38s 1s635ms 17 60 1m38s 1s635ms 18 60 1m20s 1s345ms 19 60 40s450ms 674ms 20 60 40s526ms 675ms 21 60 40s526ms 675ms 22 60 40s526ms 675ms 23 60 40s526ms 675ms 00 60 43s238ms 720ms [ User: labanimal - Total duration: 24m57s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-04-03 09:36:01 Duration: 1s724ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-04-03 09:41:01 Duration: 1s649ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-04-03 17:41:01 Duration: 1s635ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
9 562ms 1s724ms 1s39ms 1,440 24m57s 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 Apr 03 01 60 0ms 0ms 02 60 26s747ms 445ms 03 60 55s340ms 922ms 04 60 55s340ms 922ms 05 60 55s340ms 922ms 06 60 55s340ms 922ms 07 60 55s340ms 922ms 08 60 55s340ms 922ms 09 60 55s385ms 923ms 10 60 1m9s 1s162ms 11 60 1m38s 1s635ms 12 60 1m38s 1s635ms 13 60 1m38s 1s635ms 14 60 1m38s 1s635ms 15 60 1m38s 1s635ms 16 60 1m38s 1s635ms 17 60 1m38s 1s635ms 18 60 1m20s 1s345ms 19 60 40s450ms 674ms 20 60 40s526ms 675ms 21 60 40s526ms 675ms 22 60 40s526ms 675ms 23 60 40s526ms 675ms 00 60 43s238ms 720ms [ User: labanimal - Total duration: 24m57s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-04-03 09:36:01 Duration: 1s724ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-04-03 09:41:01 Duration: 1s649ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-04-03 17:41:01 Duration: 1s635ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
10 562ms 1s724ms 1s39ms 1,440 24m57s 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 Apr 03 01 60 0ms 0ms 02 60 26s747ms 445ms 03 60 55s340ms 922ms 04 60 55s340ms 922ms 05 60 55s340ms 922ms 06 60 55s340ms 922ms 07 60 55s340ms 922ms 08 60 55s340ms 922ms 09 60 55s385ms 923ms 10 60 1m9s 1s162ms 11 60 1m38s 1s635ms 12 60 1m38s 1s635ms 13 60 1m38s 1s635ms 14 60 1m38s 1s635ms 15 60 1m38s 1s635ms 16 60 1m38s 1s635ms 17 60 1m38s 1s635ms 18 60 1m20s 1s345ms 19 60 40s450ms 674ms 20 60 40s526ms 675ms 21 60 40s526ms 675ms 22 60 40s526ms 675ms 23 60 40s526ms 675ms 00 60 43s238ms 720ms [ User: labanimal - Total duration: 24m57s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-03 09:36:01 Duration: 1s724ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-03 09:41:01 Duration: 1s649ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-03 17:41:01 Duration: 1s635ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
11 562ms 1s724ms 1s39ms 1,440 24m57s create index if not exists idx_db_top_queries_tenant on observability.db_top_queries (tenant_key, collected_at desc);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Apr 03 01 60 0ms 0ms 02 60 26s747ms 445ms 03 60 55s340ms 922ms 04 60 55s340ms 922ms 05 60 55s340ms 922ms 06 60 55s340ms 922ms 07 60 55s340ms 922ms 08 60 55s340ms 922ms 09 60 55s385ms 923ms 10 60 1m9s 1s162ms 11 60 1m38s 1s635ms 12 60 1m38s 1s635ms 13 60 1m38s 1s635ms 14 60 1m38s 1s635ms 15 60 1m38s 1s635ms 16 60 1m38s 1s635ms 17 60 1m38s 1s635ms 18 60 1m20s 1s345ms 19 60 40s450ms 674ms 20 60 40s526ms 675ms 21 60 40s526ms 675ms 22 60 40s526ms 675ms 23 60 40s526ms 675ms 00 60 43s238ms 720ms [ User: labanimal - Total duration: 24m57s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-04-03 09:36:01 Duration: 1s724ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-04-03 09:41:01 Duration: 1s649ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-04-03 17:41:01 Duration: 1s635ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
12 562ms 1s724ms 1s39ms 1,440 24m57s create table if not exists observability.metrics_timeseries ( id bigserial primary key, tenant_key text not null, metric_name text not null, bucket_start timestamptz not null, bucket_width_seconds integer not null default ?, sum_value double precision not null default ?, count_value bigint not null default ?, histogram jsonb, created_at timestamptz not null default now(), updated_at timestamptz not null default now(), unique (tenant_key, metric_name, bucket_start, bucket_width_seconds) );Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Apr 03 01 60 0ms 0ms 02 60 26s747ms 445ms 03 60 55s340ms 922ms 04 60 55s340ms 922ms 05 60 55s340ms 922ms 06 60 55s340ms 922ms 07 60 55s340ms 922ms 08 60 55s340ms 922ms 09 60 55s385ms 923ms 10 60 1m9s 1s162ms 11 60 1m38s 1s635ms 12 60 1m38s 1s635ms 13 60 1m38s 1s635ms 14 60 1m38s 1s635ms 15 60 1m38s 1s635ms 16 60 1m38s 1s635ms 17 60 1m38s 1s635ms 18 60 1m20s 1s345ms 19 60 40s450ms 674ms 20 60 40s526ms 675ms 21 60 40s526ms 675ms 22 60 40s526ms 675ms 23 60 40s526ms 675ms 00 60 43s238ms 720ms [ User: labanimal - Total duration: 24m57s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-04-03 09:36:01 Duration: 1s724ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-04-03 09:41:01 Duration: 1s649ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-04-03 17:41:01 Duration: 1s635ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
13 562ms 1s724ms 1s39ms 1,440 24m57s create index if not exists idx_app_events_type on observability.app_events (event_type);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Apr 03 01 60 0ms 0ms 02 60 26s747ms 445ms 03 60 55s340ms 922ms 04 60 55s340ms 922ms 05 60 55s340ms 922ms 06 60 55s340ms 922ms 07 60 55s340ms 922ms 08 60 55s340ms 922ms 09 60 55s385ms 923ms 10 60 1m9s 1s162ms 11 60 1m38s 1s635ms 12 60 1m38s 1s635ms 13 60 1m38s 1s635ms 14 60 1m38s 1s635ms 15 60 1m38s 1s635ms 16 60 1m38s 1s635ms 17 60 1m38s 1s635ms 18 60 1m20s 1s345ms 19 60 40s450ms 674ms 20 60 40s526ms 675ms 21 60 40s526ms 675ms 22 60 40s526ms 675ms 23 60 40s526ms 675ms 00 60 43s238ms 720ms [ User: labanimal - Total duration: 24m57s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-04-03 09:36:01 Duration: 1s724ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-04-03 09:41:01 Duration: 1s649ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-04-03 17:41:01 Duration: 1s635ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
14 562ms 1s724ms 1s39ms 1,440 24m57s create table if not exists observability.app_events ( id bigserial primary key, tenant_key text not null, event_type text not null, severity text not null, message text not null, payload jsonb, occurred_at timestamptz not null default now(), created_at timestamptz not null default now() );Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Apr 03 01 60 0ms 0ms 02 60 26s747ms 445ms 03 60 55s340ms 922ms 04 60 55s340ms 922ms 05 60 55s340ms 922ms 06 60 55s340ms 922ms 07 60 55s340ms 922ms 08 60 55s340ms 922ms 09 60 55s385ms 923ms 10 60 1m9s 1s162ms 11 60 1m38s 1s635ms 12 60 1m38s 1s635ms 13 60 1m38s 1s635ms 14 60 1m38s 1s635ms 15 60 1m38s 1s635ms 16 60 1m38s 1s635ms 17 60 1m38s 1s635ms 18 60 1m20s 1s345ms 19 60 40s450ms 674ms 20 60 40s526ms 675ms 21 60 40s526ms 675ms 22 60 40s526ms 675ms 23 60 40s526ms 675ms 00 60 43s238ms 720ms [ User: labanimal - Total duration: 24m57s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-03 09:36:01 Duration: 1s724ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-03 09:41:01 Duration: 1s649ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-03 17:41:01 Duration: 1s635ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
15 562ms 1s724ms 1s39ms 1,440 24m57s create index if not exists idx_app_events_tenant on observability.app_events (tenant_key, occurred_at desc);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Apr 03 01 60 0ms 0ms 02 60 26s747ms 445ms 03 60 55s340ms 922ms 04 60 55s340ms 922ms 05 60 55s340ms 922ms 06 60 55s340ms 922ms 07 60 55s340ms 922ms 08 60 55s340ms 922ms 09 60 55s385ms 923ms 10 60 1m9s 1s162ms 11 60 1m38s 1s635ms 12 60 1m38s 1s635ms 13 60 1m38s 1s635ms 14 60 1m38s 1s635ms 15 60 1m38s 1s635ms 16 60 1m38s 1s635ms 17 60 1m38s 1s635ms 18 60 1m20s 1s345ms 19 60 40s450ms 674ms 20 60 40s526ms 675ms 21 60 40s526ms 675ms 22 60 40s526ms 675ms 23 60 40s526ms 675ms 00 60 43s238ms 720ms [ User: labanimal - Total duration: 24m57s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-04-03 09:36:01 Duration: 1s724ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-04-03 09:41:01 Duration: 1s649ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-04-03 17:41:01 Duration: 1s635ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
16 562ms 1s724ms 1s39ms 1,440 24m57s create schema if not exists observability;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Apr 03 01 60 0ms 0ms 02 60 26s747ms 445ms 03 60 55s340ms 922ms 04 60 55s340ms 922ms 05 60 55s340ms 922ms 06 60 55s340ms 922ms 07 60 55s340ms 922ms 08 60 55s340ms 922ms 09 60 55s385ms 923ms 10 60 1m9s 1s162ms 11 60 1m38s 1s635ms 12 60 1m38s 1s635ms 13 60 1m38s 1s635ms 14 60 1m38s 1s635ms 15 60 1m38s 1s635ms 16 60 1m38s 1s635ms 17 60 1m38s 1s635ms 18 60 1m20s 1s345ms 19 60 40s450ms 674ms 20 60 40s526ms 675ms 21 60 40s526ms 675ms 22 60 40s526ms 675ms 23 60 40s526ms 675ms 00 60 43s238ms 720ms [ User: labanimal - Total duration: 24m57s - Times executed: 1349 ]
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-04-03 09:36:01 Duration: 1s724ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-04-03 09:41:01 Duration: 1s649ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-04-03 17:41:01 Duration: 1s635ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
17 562ms 1s724ms 1s39ms 1,440 24m57s 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 #17
Day Hour Count Duration Avg duration Apr 03 01 60 0ms 0ms 02 60 26s747ms 445ms 03 60 55s340ms 922ms 04 60 55s340ms 922ms 05 60 55s340ms 922ms 06 60 55s340ms 922ms 07 60 55s340ms 922ms 08 60 55s340ms 922ms 09 60 55s385ms 923ms 10 60 1m9s 1s162ms 11 60 1m38s 1s635ms 12 60 1m38s 1s635ms 13 60 1m38s 1s635ms 14 60 1m38s 1s635ms 15 60 1m38s 1s635ms 16 60 1m38s 1s635ms 17 60 1m38s 1s635ms 18 60 1m20s 1s345ms 19 60 40s450ms 674ms 20 60 40s526ms 675ms 21 60 40s526ms 675ms 22 60 40s526ms 675ms 23 60 40s526ms 675ms 00 60 43s238ms 720ms [ User: labanimal - Total duration: 24m57s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-03 09:36:01 Duration: 1s724ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-03 09:41:01 Duration: 1s649ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-03 17:41:01 Duration: 1s635ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
18 562ms 1s724ms 1s39ms 1,440 24m57s 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 #18
Day Hour Count Duration Avg duration Apr 03 01 60 0ms 0ms 02 60 26s747ms 445ms 03 60 55s340ms 922ms 04 60 55s340ms 922ms 05 60 55s340ms 922ms 06 60 55s340ms 922ms 07 60 55s340ms 922ms 08 60 55s340ms 922ms 09 60 55s385ms 923ms 10 60 1m9s 1s162ms 11 60 1m38s 1s635ms 12 60 1m38s 1s635ms 13 60 1m38s 1s635ms 14 60 1m38s 1s635ms 15 60 1m38s 1s635ms 16 60 1m38s 1s635ms 17 60 1m38s 1s635ms 18 60 1m20s 1s345ms 19 60 40s450ms 674ms 20 60 40s526ms 675ms 21 60 40s526ms 675ms 22 60 40s526ms 675ms 23 60 40s526ms 675ms 00 60 43s238ms 720ms [ User: labanimal - Total duration: 24m57s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-03 09:36:01 Duration: 1s724ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-03 09:41:01 Duration: 1s649ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-03 17:41:01 Duration: 1s635ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
19 722ms 752ms 736ms 18 13s251ms select count(distinct animal_id) AS "count" from ( select animals_search_mview.*, b.unbreeding_date, a.id as animal, user_is_tgm (animals_search_mview.owner, ?) as is_owner, user_is_tgm (animals_search_mview.editor, ?) as is_editor, user_is_tgm (animals_search_mview.tourist, ?) as is_tourist, case when not exists ( select ? from scoresheet_diary sd where sd.animals_id = animals_search_mview.id) then ? else ? end as isscored from animals_search_mview left join strains on strains.name = animals_search_mview.strain left join license_history lh on lh.anid = animals_search_mview.id left join animals a on a."animalID" = animals_search_mview.animal_id left join breedings b on b.id = animals_search_mview.last_mating) data where fate = ? and alive = ? and deleted = ? and (is_owner or is_editor or is_tourist);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Apr 03 18 16 11s795ms 737ms 19 2 1s456ms 728ms [ User: labanimal - Total duration: 13s251ms - Times executed: 18 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 12s510ms - Times executed: 17 ]
[ Application: _desktop_index.php_view_animal_name_on_view_animal_id_on_view_b - Total duration: 741ms - Times executed: 1 ]
-
SELECT COUNT(DISTINCT animal_id) AS "count" FROM ( SELECT animals_search_mview.*, b.unbreeding_date, a.id as animal, user_is_tgm (animals_search_mview.owner, 10100000) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100000) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100000) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN animals a ON a."animalID" = animals_search_mview.animal_id LEFT JOIN breedings b ON b.id = animals_search_mview.last_mating) data WHERE fate = 5 AND alive = 't' AND deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-04-03 17:41:09 Duration: 752ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
SELECT COUNT(DISTINCT animal_id) AS "count" FROM ( SELECT animals_search_mview.*, b.unbreeding_date, a.id as animal, user_is_tgm (animals_search_mview.owner, 10100000) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100000) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100000) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN animals a ON a."animalID" = animals_search_mview.animal_id LEFT JOIN breedings b ON b.id = animals_search_mview.last_mating) data WHERE fate = 5 AND alive = 't' AND deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-04-03 17:51:07 Duration: 746ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
SELECT COUNT(DISTINCT animal_id) AS "count" FROM ( SELECT animals_search_mview.*, b.unbreeding_date, a.id as animal, user_is_tgm (animals_search_mview.owner, 490) AS is_owner, user_is_tgm (animals_search_mview.editor, 490) AS is_editor, user_is_tgm (animals_search_mview.tourist, 490) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN animals a ON a."animalID" = animals_search_mview.animal_id LEFT JOIN breedings b ON b.id = animals_search_mview.last_mating) data WHERE fate = 5 AND alive = 't' AND deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-04-03 17:51:08 Duration: 745ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
20 662ms 692ms 673ms 18 12s129ms select distinct * from ( select animals_search_mview.*, b.unbreeding_date, fates.loc as fate_name, user_is_tgm (animals_search_mview.owner, ?) as is_owner, user_is_tgm (animals_search_mview.editor, ?) as is_editor, user_is_tgm (animals_search_mview.tourist, ?) as is_tourist, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, string_agg(l."application_id" || ? || l."title" || ? || date(lh."timestamp")::varchar, ?) as licensehistory, case when not exists ( select ? from scoresheet_diary sd where sd.animals_id = animals_search_mview.id) then ? else ? end as isscored from animals_search_mview inner join fates on fates.id = animals_search_mview.fate left join strains on strains.name = animals_search_mview.strain left join license_history lh on lh.anid = animals_search_mview.id left join licenses l on l.id = lh.licid left join breedings b on b.id = animals_search_mview.last_mating group by animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data where data.fate = ? and data.alive = ? and data.deleted = ? and (is_owner or is_editor or is_tourist) and (data.straindeleted = ? or data.straindeleted is null) order by data.cage_name, data.animal_id, data.name;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Apr 03 18 16 10s780ms 673ms 19 2 1s348ms 674ms [ User: labanimal - Total duration: 12s129ms - Times executed: 18 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 11s453ms - Times executed: 17 ]
[ Application: _desktop_index.php_view_animal_name_on_view_animal_id_on_view_b - Total duration: 675ms - Times executed: 1 ]
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 10100000) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100000) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100000) AS is_tourist, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, STRING_AGG(l."application_id" || ':' || l."title" || ' - ' || Date(lh."timestamp")::varchar, '; ') AS licensehistory, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview INNER JOIN fates ON fates.id = animals_search_mview.fate LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN licenses l ON l.id = lh.licid left join breedings b ON b.id = animals_search_mview.last_mating GROUP BY animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data WHERE data.fate = 5 AND data.alive = 't' AND data.deleted = 'f' AND (is_owner OR is_editor OR is_tourist) and (data.straindeleted = 'f' or data.straindeleted is null) ORDER BY data.cage_name, data.animal_id, data.name;
Date: 2026-04-03 17:41:10 Duration: 692ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 10100000) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100000) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100000) AS is_tourist, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, STRING_AGG(l."application_id" || ':' || l."title" || ' - ' || Date(lh."timestamp")::varchar, '; ') AS licensehistory, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview INNER JOIN fates ON fates.id = animals_search_mview.fate LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN licenses l ON l.id = lh.licid left join breedings b ON b.id = animals_search_mview.last_mating GROUP BY animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data WHERE data.fate = 5 AND data.alive = 't' AND data.deleted = 'f' AND (is_owner OR is_editor OR is_tourist) and (data.straindeleted = 'f' or data.straindeleted is null) ORDER BY data.cage_name, data.animal_id, data.name;
Date: 2026-04-03 17:51:08 Duration: 688ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 490) AS is_owner, user_is_tgm (animals_search_mview.editor, 490) AS is_editor, user_is_tgm (animals_search_mview.tourist, 490) AS is_tourist, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, STRING_AGG(l."application_id" || ':' || l."title" || ' - ' || Date(lh."timestamp")::varchar, '; ') AS licensehistory, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview INNER JOIN fates ON fates.id = animals_search_mview.fate LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN licenses l ON l.id = lh.licid left join breedings b ON b.id = animals_search_mview.last_mating GROUP BY animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data WHERE data.fate = 5 AND data.alive = 't' AND data.deleted = 'f' AND (is_owner OR is_editor OR is_tourist) and (data.straindeleted = 'f' or data.straindeleted is null) ORDER BY data.cage_name, data.animal_id, data.name;
Date: 2026-04-03 17:50:39 Duration: 684ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-04-03_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
- 89,035 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 14 FATAL entries
- 1 ERROR entries
- 0 WARNING entries
- 0 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 14 Max number of times the same event was reported
- 15 Total events found
Rank Times reported Error 1 14 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Apr 03 02 4 16 10 - FATAL: database "monitoring" does not exist
- FATAL: database "monitoring" does not exist
- FATAL: database "monitoring" does not exist
Date: 2026-04-03 01:40:55 Database: monitoring Application: User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
Date: 2026-04-03 01:40:55 Database: monitoring Application: User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
Date: 2026-04-03 01:40:55 Database: monitoring Application: User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv
2 1 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #2
Day Hour Count Apr 03 10 1 - ERROR: syntax error at or near ")"
Statement: UPDATE breedings SET id = id, unbreeding_date = '2026-04-03'::DATE WHERE id IN ();
Date: 2026-04-03 09:41:12 Database: zemm_produktiv_8 Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-04-03_000000.csv