ZEMM PG Report-
Global information
- Generated on Mon Jun 15 06:04:57 2026
- Log file: /var/log/postgresql/postgresql-2026-05-13_000000.csv, ..., /var/log/postgresql/postgresql-2026-06-15_000000.csv
- Parsed 302,099 log entries in 4m56s
- Log start from 2026-05-20 00:00:01 to 2026-05-20 23:59:04
-
Overview
Global Stats
- 39 Number of unique normalized queries
- 24,841 Number of queries
- 7h49m9s Total query duration
- 2026-05-20 00:00:01 First query
- 2026-05-20 23:59:01 Last query
- 18 queries/s at 2026-05-20 11:05:01 Query peak
- 7h49m9s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 7h49m9s Execute total duration
- 4 Number of events
- 2 Number of unique normalized events
- 3 Max number of times the same event was reported
- 0 Number of cancellation
- 66 Total number of automatic vacuums
- 158 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 28,246 Total number of sessions
- 6 sessions at 2026-05-20 16:46:29 Session peak
- 1h38m35s Total duration of sessions
- 209ms Average duration of sessions
- 0 Average queries per session
- 996ms Average queries duration per session
- 0ms Average idle time per session
- 28,246 Total number of connections
- 31 connections/s at 2026-05-20 18:16:36 Connection peak
- 2 Total number of databases
SQL Traffic
Key values
- 18 queries/s Query Peak
- 2026-05-20 11:05:01 Date
SELECT Traffic
Key values
- 2 queries/s Query Peak
- 2026-05-20 20:56:19 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 18 queries/s Query Peak
- 2026-05-20 13:10:01 Date
Queries duration
Key values
- 7h49m9s 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) May 20 00 1,020 0ms 0ms 0ms 0ms 0ms 0ms 01 1,021 0ms 1s129ms 546ms 19s204ms 19s204ms 19s204ms 02 1,020 1s129ms 1s129ms 1s129ms 19s204ms 19s204ms 19s204ms 03 1,020 1s129ms 1s129ms 1s129ms 19s204ms 19s204ms 19s204ms 04 1,020 1s129ms 1s129ms 1s129ms 19s204ms 19s204ms 19s204ms 05 1,020 1s129ms 1s129ms 1s129ms 19s204ms 19s204ms 19s204ms 06 1,020 1s129ms 1s129ms 1s129ms 19s204ms 19s204ms 19s204ms 07 1,025 739ms 11s856ms 2s716ms 3m21s 3m21s 3m22s 08 1,035 518ms 11s832ms 917ms 13s483ms 13s912ms 3m21s 09 1,032 713ms 764ms 737ms 13s189ms 13s462ms 13s698ms 10 1,039 502ms 1s998ms 689ms 12s994ms 14s947ms 16s131ms 11 1,069 500ms 2s24ms 1s34ms 35s938ms 36s233ms 37s224ms 12 1,032 715ms 776ms 745ms 13s385ms 13s646ms 13s956ms 13 1,072 625ms 1s967ms 868ms 25s105ms 31s160ms 32s993ms 14 1,036 724ms 1s440ms 1s73ms 24s482ms 25s18ms 25s253ms 15 1,042 718ms 1s485ms 1s236ms 25s387ms 27s77ms 27s490ms 16 1,040 726ms 1s478ms 1s77ms 25s134ms 25s305ms 27s84ms 17 1,038 735ms 1s482ms 1s103ms 25s202ms 25s470ms 25s961ms 18 1,042 726ms 1s459ms 1s96ms 24s966ms 25s559ms 27s833ms 19 1,038 726ms 1s466ms 1s96ms 24s937ms 25s227ms 25s723ms 20 1,040 757ms 2s435ms 1s469ms 41s401ms 41s401ms 42s650ms 21 1,038 759ms 2s460ms 1s660ms 41s825ms 42s63ms 42s651ms 22 1,038 966ms 2s471ms 1s716ms 41s799ms 42s18ms 42s985ms 23 1,044 869ms 3s351ms 1s754ms 41s929ms 41s929ms 43s145ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 20 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 3 0 748ms 0ms 0ms 741ms 08 15 0 732ms 720ms 751ms 776ms 09 12 0 739ms 713ms 745ms 761ms 10 17 0 743ms 0ms 502ms 3s812ms 11 29 0 644ms 728ms 758ms 1s515ms 12 12 0 744ms 715ms 743ms 763ms 13 45 0 759ms 757ms 2s277ms 3s82ms 14 11 0 760ms 0ms 760ms 792ms 15 13 0 759ms 726ms 772ms 781ms 16 14 0 782ms 737ms 777ms 803ms 17 12 0 766ms 735ms 767ms 784ms 18 16 0 776ms 729ms 790ms 812ms 19 12 0 780ms 726ms 787ms 828ms 20 14 0 1s37ms 757ms 1s299ms 1s352ms 21 12 0 1s192ms 759ms 1s310ms 1s345ms 22 12 0 1s248ms 966ms 1s326ms 1s371ms 23 12 6 1s523ms 1s216ms 1s331ms 1s468ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 20 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 1 0 0 1s129ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 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 May 20 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 5 5.00 0.00% 08 0 12 12.00 0.00% 09 0 12 12.00 0.00% 10 0 3 3.00 0.00% 11 0 12 12.00 0.00% 12 0 12 12.00 0.00% 13 0 14 14.00 0.00% 14 0 16 16.00 0.00% 15 0 22 22.00 0.00% 16 0 18 18.00 0.00% 17 0 18 18.00 0.00% 18 0 18 18.00 0.00% 19 0 18 18.00 0.00% 20 0 18 18.00 0.00% 21 0 18 18.00 0.00% 22 0 18 18.00 0.00% 23 0 18 18.00 0.00% Day Hour Count Average / Second May 20 00 559 0.16/s 01 558 0.15/s 02 549 0.15/s 03 549 0.15/s 04 544 0.15/s 05 701 0.19/s 06 1,180 0.33/s 07 1,425 0.40/s 08 2,193 0.61/s 09 1,678 0.47/s 10 2,056 0.57/s 11 1,835 0.51/s 12 1,139 0.32/s 13 2,290 0.64/s 14 1,462 0.41/s 15 1,119 0.31/s 16 1,332 0.37/s 17 962 0.27/s 18 1,137 0.32/s 19 1,027 0.29/s 20 1,017 0.28/s 21 1,040 0.29/s 22 953 0.26/s 23 941 0.26/s Day Hour Count Average Duration Average idle time May 20 00 559 238ms 238ms 01 558 240ms 0ms 02 549 241ms 0ms 03 549 241ms 0ms 04 544 243ms 0ms 05 701 208ms 0ms 06 1,180 181ms 0ms 07 1,425 331ms 0ms 08 2,193 149ms 0ms 09 1,678 145ms 0ms 10 2,056 184ms 0ms 11 1,835 228ms 0ms 12 1,139 178ms 0ms 13 2,290 174ms 0ms 14 1,462 167ms 0ms 15 1,119 241ms 0ms 16 1,332 171ms 0ms 17 962 200ms 0ms 18 1,137 188ms 0ms 19 1,027 193ms 0ms 20 1,017 250ms 0ms 21 1,040 267ms 0ms 22 953 286ms 0ms 23 941 312ms 0ms -
Connections
Established Connections
Key values
- 31 connections Connection Peak
- 2026-05-20 18:16:36 Date
Connections per database
Key values
- zemm_monitoring Main Database
- 28,246 connections Total
Connections per user
Key values
- labanimal Main User
- 28,246 connections Total
-
Sessions
Simultaneous sessions
Key values
- 6 sessions Session Peak
- 2026-05-20 16:46:29 Date
Histogram of session times
Key values
- 25,623 0-500ms duration
Sessions per database
Key values
- zemm_monitoring Main Database
- 28,246 sessions Total
Sessions per user
Key values
- labanimal Main User
- 28,246 sessions Total
Sessions per host
Key values
- ::1 Main Host
- 28,246 sessions Total
Sessions per application
Key values
- Main Application
- 28,246 sessions Total
Application Count Total Duration Average Duration 23,575 1h25m47s 218ms _desktop__zemm_produktiv_8_localhost_5432 13 778ms 59ms _desktop_index.php_cage_name_51-_2A_current_only_true_val4_anim 1 82ms 82ms _desktop_index.php_cage_name_51_2A_current_only_true_val4_anima 5 401ms 80ms _desktop_index.php_command_admin_subcommand_strains_management_ 1 78ms 78ms _desktop_index.php_command_animals_breedings_subcommand_add_bre 1 46ms 46ms _desktop_index.php_command_animals_breedings_subcommand_edit_id 2 1s496ms 748ms _desktop_index.php_command_animals_breedings_subcommand_init_ze 2 92ms 46ms _desktop_index.php_command_animals_edit_subcommand_init_id_1028 1 98ms 98ms _desktop_index.php_command_animals_subcommand_init_zemm_produkt 6 285ms 47ms _desktop_index.php_command_documents_subcommand_init_zemm_produ 3 133ms 44ms _desktop_index.php_command_facility_subcommand_init_zemm_produk 1 45ms 45ms _desktop_index.php_command_home_subcommand_init_zemm_produktiv_ 2 193ms 96ms _desktop_index.php_command_login_subcommand_init_zemm_dev_local 7 210ms 30ms _desktop_index.php_command_login_subcommand_init_zemm_produktiv 1,755 52s440ms 29ms _desktop_index.php_command_login_subcommand_init_zemm_test_loca 9 286ms 31ms _desktop_index.php_command_reports_subcommand_animals_per_room_ 7 815ms 116ms _desktop_index.php_command_reports_subcommand_animals_per_user_ 6 681ms 113ms _desktop_index.php_command_reports_subcommand_init_zemm_produkt 1 129ms 129ms _desktop_index.php_command_strains_subcommand_view_id_1433_zemm 1 48ms 48ms _desktop_index.php_command_tasks_subcommand_edit_id_10142199_ze 1 82ms 82ms _desktop_index.php_command_tasks_subcommand_edit_id_10142825_ze 1 91ms 91ms _desktop_index.php_command_tasks_subcommand_edit_id_10142977_ze 2 170ms 85ms _desktop_index.php_command_tasks_subcommand_edit_id_10143092_ze 1 86ms 86ms _desktop_index.php_command_tasks_subcommand_edit_id_10143094_ze 1 91ms 91ms _desktop_index.php_command_tasks_subcommand_edit_id_10143097_ze 1 77ms 77ms _desktop_index.php_command_tasks_subcommand_init_template_zemm_ 9 385ms 42ms _desktop_index.php_command_tasks_subcommand_init_zemm_produktiv 54 4s366ms 80ms _desktop_index.php_command_tasks_subcommand_open_legacy_1_id_10 18 1s169ms 64ms _desktop_index.php_m_action_animals_3Am_delete_val4_animals_lis 2 116ms 58ms _desktop_index.php_m_action_animals_edit_3Alink_init_row_animal 5 287ms 57ms _desktop_index.php_name_Genotypisierungsproben_20genommen_instr 4 399ms 99ms _desktop_index.php_name_Neue_20Aufgabe_add_link_animals_task_st 2 90ms 45ms _desktop_index.php_name_Re-Homing_20von_20Zebrafischen_instruct 1 47ms 47ms _desktop_index.php_name_Verpaarungen_20f_C3_BCr_20Versuchsvorha 1 61ms 61ms _desktop_index.php_name_Verpaarungen_20zur_20Zucht_instructions 2 125ms 62ms _desktop_index.php_view_animal_name_on_view_animal_id_on_breedi 1 449ms 449ms _desktop_index.php_view_animal_name_on_view_animal_id_on_view_b 20 5s749ms 287ms _desktop_index.php_zemm_dev_localhost_5432 1 89ms 89ms _desktop_index.php_zemm_produktiv_8_localhost_5432 2,654 11m6s 251ms backend:zemm_produktiv_8@localhost 36 3s82ms 85ms bounces:zemm_produktiv_8@h2940066.stratoserver.net:5432 1 466ms 466ms expire_tasks:zemm_produktiv_8@h2940066.stratoserver.net:5432 1 1s153ms 1s153ms pg_dump 1 16s680ms 16s680ms psql 3 37ms 12ms taskscron:zemm_produktiv_8@h2940066.stratoserver.net:5432 24 8s130ms 338ms -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 19,359 buffers Checkpoint Peak
- 2026-05-20 01:34:56 Date
- 269.891 seconds Highest write time
- 0.027 seconds Sync time
Checkpoints Wal files
Key values
- 6 files Wal files usage Peak
- 2026-05-20 01:34:56 Date
Checkpoints distance
Key values
- 193.45 Mo Distance Peak
- 2026-05-20 01:34:56 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time May 20 00 6,999 700.734s 0.099s 700.887s 01 25,853 920.019s 0.101s 920.18s 02 7,642 765.027s 0.097s 765.174s 03 7,137 714.156s 0.094s 714.313s 04 6,952 696.113s 0.09s 696.263s 05 7,229 723.67s 0.112s 723.839s 06 8,913 892.434s 0.19s 892.679s 07 17,859 1,154.126s 0.2s 1,154.378s 08 14,863 1,246.996s 0.213s 1,247.261s 09 9,357 936.655s 0.174s 936.884s 10 9,677 968.981s 0.216s 969.253s 11 9,661 966.571s 0.199s 966.823s 12 14,987 982.961s 0.13s 983.145s 13 9,998 1,000.356s 0.225s 1,000.629s 14 9,083 908.422s 0.186s 908.663s 15 8,175 818.117s 0.125s 818.294s 16 7,876 788.183s 0.142s 788.378s 17 8,220 822.621s 0.109s 822.781s 18 8,435 843.975s 0.126s 844.154s 19 8,201 820.75s 0.107s 820.915s 20 7,561 757.156s 0.125s 757.358s 21 8,083 809.901s 0.111s 810.112s 22 7,978 799.432s 0.121s 799.632s 23 8,129 814.453s 0.114s 814.662s Day Hour Added Removed Recycled Synced files Longest sync Average sync May 20 00 0 0 1 477 0.008s 0.012s 01 0 0 8 512 0.002s 0.012s 02 0 0 1 485 0.002s 0.012s 03 0 0 2 484 0.002s 0.012s 04 0 0 1 477 0.001s 0.012s 05 0 0 2 595 0.004s 0.012s 06 0 0 2 1,068 0.003s 0.012s 07 0 0 3 1,165 0.002s 0.012s 08 0 0 4 1,227 0.002s 0.012s 09 0 0 2 1,002 0.002s 0.012s 10 0 0 2 1,254 0.002s 0.012s 11 0 0 2 1,126 0.003s 0.012s 12 0 0 3 727 0.001s 0.011s 13 0 0 2 1,322 0.003s 0.012s 14 0 0 2 1,047 0.002s 0.012s 15 0 0 1 689 0.006s 0.012s 16 0 0 2 804 0.001s 0.012s 17 0 0 1 567 0.004s 0.012s 18 0 0 2 664 0.004s 0.012s 19 0 0 2 568 0.002s 0.012s 20 0 0 1 588 0.003s 0.012s 21 0 0 2 522 0.005s 0.012s 22 0 0 2 550 0.005s 0.012s 23 0 0 1 492 0.004s 0.012s Day Hour Count Avg time (sec) May 20 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 May 20 00 2,009.50 kB 2,736.67 kB 01 10,131.08 kB 40,136.17 kB 02 2,161.67 kB 32,884.58 kB 03 2,067.67 kB 10,868.25 kB 04 1,953.58 kB 4,527.00 kB 05 2,053.00 kB 3,044.58 kB 06 2,604.25 kB 3,287.67 kB 07 5,109.25 kB 10,264.92 kB 08 4,616.08 kB 15,263.42 kB 09 2,633.92 kB 6,583.50 kB 10 2,885.00 kB 4,117.50 kB 11 2,859.67 kB 4,012.58 kB 12 3,991.00 kB 9,389.36 kB 13 2,899.58 kB 8,840.67 kB 14 2,556.17 kB 4,444.83 kB 15 2,201.75 kB 3,000.75 kB 16 2,132.50 kB 2,963.58 kB 17 2,240.42 kB 2,887.42 kB 18 2,364.67 kB 3,179.42 kB 19 2,279.92 kB 2,843.25 kB 20 2,101.08 kB 2,917.42 kB 21 2,149.67 kB 2,858.50 kB 22 2,178.00 kB 3,012.67 kB 23 2,290.83 kB 2,833.75 kB -
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size May 20 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 2.20 sec Highest CPU-cost vacuum
Table observability.metrics_timeseries
Database zemm_monitoring - 2026-05-20 12:26:08 Date
- 0 sec Highest CPU-cost analyze
Table
Database zemm_monitoring - Date
Average Autovacuum Duration
Key values
- 2.20 sec Highest CPU-cost vacuum
Table observability.metrics_timeseries
Database zemm_monitoring - 2026-05-20 12:26:08 Date
Analyzes per table
Key values
- pg_catalog.pg_type (48) Main table analyzed (database zemm_produktiv_8)
- 158 analyzes Total
Table Number of analyzes zemm_produktiv_8.pg_catalog.pg_type 48 zemm_produktiv_8.pg_catalog.pg_attribute 37 zemm_produktiv_8.pg_catalog.pg_class 27 zemm_produktiv_8.pg_catalog.pg_depend 24 invdb.pg_catalog.pg_shdepend 3 zemm_produktiv_8.public.cages_search_mview 3 labanimal.pg_catalog.pg_shdepend 2 zemm_monitoring.observability.metrics_timeseries 2 zemm_produktiv_8.public.tmptasks 2 zemm_produktiv_8.public.users 2 fbi_unire.pg_catalog.pg_shdepend 1 zemm_monitoring.pg_catalog.pg_shdepend 1 zemm_monitoring.observability.db_top_queries 1 zemm_produktiv_8.public.tasks 1 zemm_produktiv_8.public.cages 1 zemm_monitoring.observability.nginx_counters 1 zemm_produktiv_8.pg_catalog.pg_shdepend 1 fbi_unibi.pg_catalog.pg_shdepend 1 Total 158 Vacuums per table
Key values
- pg_catalog.pg_type (18) Main table vacuumed on database zemm_produktiv_8
- 66 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples zemm_produktiv_8.pg_catalog.pg_type 18 18 0 0 0 0 0 895 159 199,162 0 0 zemm_produktiv_8.pg_catalog.pg_attribute 14 14 0 0 0 0 0 1,712 518 393,654 0 0 zemm_produktiv_8.pg_catalog.pg_class 10 10 0 0 0 0 0 808 257 295,264 0 0 zemm_produktiv_8.pg_catalog.pg_depend 8 8 0 0 0 0 0 851 216 288,044 0 0 zemm_produktiv_8.pg_toast.pg_toast_2619 4 4 0 0 0 0 0 736 195 1,045,528 46 143 zemm_monitoring.pg_toast.pg_toast_67431 4 0 0 0 0 0 0 4,561 1,531 3,484,519 1,511 9,066 zemm_monitoring.pg_catalog.pg_shdepend 2 2 0 0 0 0 0 140 50 101,921 0 0 invdb.pg_catalog.pg_shdepend 2 2 0 0 0 0 0 136 53 107,287 0 0 zemm_monitoring.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 94 24 132,871 8 19 zemm_monitoring.observability.metrics_timeseries 1 1 0 0 0 0 0 15,960 7,415 18,175,365 1,671 31,904 zemm_produktiv_8.public.cages_search_mview 1 1 0 0 0 0 0 736 447 1,469,057 52 339 zemm_produktiv_8.public.tasks 1 1 0 0 0 0 0 48,362 41 3,560,067 3 6 Total 66 62 0 0 0 0 0 74,991 10,906 29,252,739 3,291 41,477 Vacuum throughput per table
Key values
- observability.metrics_timeseries (2.2) Max CPU elapsed for vacuum on database zemm_monitoring
- observability.metrics_timeseries (2.492 ms) Max I/O read time for vacuum on database zemm_monitoring
- observability.metrics_timeseries (0.578 ms) Max I/O write time for vacuum on database zemm_monitoring
I/O timing (ms) CPU (s) Table read write elapsed zemm_produktiv_8.pg_catalog.pg_type 0 0 0 zemm_produktiv_8.pg_catalog.pg_attribute 0 0 0.12 zemm_produktiv_8.pg_catalog.pg_class 0 0 0.01 zemm_produktiv_8.pg_catalog.pg_depend 0 0 0.04 zemm_produktiv_8.pg_toast.pg_toast_2619 0 0 0.04 zemm_monitoring.pg_toast.pg_toast_67431 0 0 0.36 zemm_monitoring.pg_catalog.pg_shdepend 0 0 0 invdb.pg_catalog.pg_shdepend 0 0 0 zemm_monitoring.pg_toast.pg_toast_2619 0 0 0 zemm_monitoring.observability.metrics_timeseries 2.492 0.578 2.2 zemm_produktiv_8.public.cages_search_mview 0 0 0.1 zemm_produktiv_8.public.tasks 0 0 0.62 Total 2.492 0.578 3.49 Tuples removed per table
Key values
- public.tasks (54518) Main table with removed tuples on database zemm_produktiv_8
- 114168 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain zemm_produktiv_8.public.tasks 1 1 54,518 57,678 0 0 17,004 zemm_monitoring.observability.metrics_timeseries 1 1 36,428 383,515 0 0 8,322 zemm_produktiv_8.pg_catalog.pg_attribute 14 14 11,988 76,733 0 0 2,576 zemm_produktiv_8.pg_catalog.pg_depend 8 8 5,266 34,964 0 0 440 zemm_produktiv_8.pg_catalog.pg_type 18 18 3,142 14,958 0 0 558 zemm_produktiv_8.pg_catalog.pg_class 10 10 1,247 9,030 0 0 420 invdb.pg_catalog.pg_shdepend 2 2 506 9,410 0 0 76 zemm_produktiv_8.pg_toast.pg_toast_2619 4 4 440 1,145 0 0 424 zemm_monitoring.pg_catalog.pg_shdepend 2 2 302 9,410 0 0 76 zemm_produktiv_8.public.cages_search_mview 1 1 273 13,885 0 0 234 zemm_monitoring.pg_toast.pg_toast_2619 1 1 58 85 0 0 38 zemm_monitoring.pg_toast.pg_toast_67431 4 0 0 2,715,684 0 0 460,788 Total 66 62 114,168 3,326,497 0 0 490,956 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_monitoring.pg_catalog.pg_shdepend 2 2 302 0 zemm_monitoring.pg_toast.pg_toast_2619 1 1 58 0 zemm_monitoring.observability.metrics_timeseries 1 1 36428 0 zemm_produktiv_8.pg_toast.pg_toast_2619 4 4 440 0 invdb.pg_catalog.pg_shdepend 2 2 506 0 zemm_produktiv_8.public.cages_search_mview 1 1 273 0 zemm_produktiv_8.pg_catalog.pg_class 10 10 1247 0 zemm_produktiv_8.public.tasks 1 1 54518 0 zemm_produktiv_8.pg_catalog.pg_depend 8 8 5266 0 zemm_produktiv_8.pg_catalog.pg_attribute 14 14 11988 0 zemm_monitoring.pg_toast.pg_toast_67431 4 0 0 0 zemm_produktiv_8.pg_catalog.pg_type 18 18 3142 0 Total 66 62 114,168 0 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs May 20 00 0 0 01 2 1 02 1 0 03 1 1 04 0 0 05 0 4 06 5 11 07 7 21 08 17 33 09 2 10 10 5 18 11 4 3 12 1 3 13 8 22 14 5 11 15 1 2 16 2 5 17 0 2 18 1 4 19 0 3 20 3 3 21 1 1 22 0 0 23 0 0 - 2.20 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
- 261 Total read queries
- 24,580 Total write queries
Queries by database
Key values
- zemm_monitoring Main database
- 24,732 Requests
- 7h47m17s (zemm_monitoring)
- Main time consuming database
Queries by user
Key values
- monitoring_admin Main user
- 196,622 Requests
User Request type Count Duration labanimal Total 728 20m32s cte 111 2m21s select 609 18m2s update 8 8s619ms monitoring_admin Total 196,622 4d6h46m20s cte 237 44m59s ddl 195,853 4d5h54m10s select 532 7m10s postgres Total 41 1m copy to 41 1m Duration by user
Key values
- 4d6h46m20s (monitoring_admin) Main time consuming user
User Request type Count Duration labanimal Total 728 20m32s cte 111 2m21s select 609 18m2s update 8 8s619ms monitoring_admin Total 196,622 4d6h46m20s cte 237 44m59s ddl 195,853 4d5h54m10s select 532 7m10s postgres Total 41 1m copy to 41 1m Queries by host
Key values
- unknown Main host
- 197,342 Requests
- 4d7h6m43s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 24,732 Requests
- 7h47m17s (unknown)
- Main time consuming application
Application Request type Count Duration _desktop_index.php_command_animals_breedings_subcommand_edit_id Total 1 506ms select 1 506ms _desktop_index.php_zemm_produktiv_8_localhost_5432 Total 101 1m38s cte 27 45s219ms select 74 53s384ms expire_tasks:zemm_produktiv_8@h2940066.stratoserver.net:5432 Total 1 1s129ms update 1 1s129ms pg_dump Total 6 11s848ms copy to 6 11s848ms unknown Total 24,732 7h47m17s cte 66 2m12s ddl 24,480 7h42m22s select 186 2m42s Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-05-20 22:27:22 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 230 500-1000ms duration
Slowest individual queries
Rank Duration Query 1 11s856ms WITH start_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at >= '2026-05-18 01:45:29+02' AND collected_at <= '2026-05-20 01:45:29+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), fallback_start AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-05-20 01:45:29+02' AND '2026-05-20 07:45:29+02' ORDER BY tenant_key, fingerprint, collected_at ASC ), end_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, query, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-05-20 01:45:29+02' AND '2026-05-20 07:45:29+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), deltas AS ( SELECT e.tenant_key, e.fingerprint, e.query, e.collected_at AS last_seen, GREATEST (COALESCE(e.total_time_ms, 0) - COALESCE(s.total_time_ms, fs.total_time_ms, 0), 0) AS total_time_ms, GREATEST (COALESCE(e.calls, 0) - COALESCE(s.calls, fs.calls, 0), 0) AS calls, GREATEST (COALESCE(e.rows_returned, 0) - COALESCE(s.rows_returned, fs.rows_returned, 0), 0) AS rows_returned FROM end_snap e LEFT JOIN start_snap s ON s.tenant_key = e.tenant_key AND s.fingerprint = e.fingerprint LEFT JOIN fallback_start fs ON fs.tenant_key = e.tenant_key AND fs.fingerprint = e.fingerprint AND s.tenant_key IS NULL ) SELECT fingerprint, MAX(query) AS query, MAX(last_seen) AS last_seen, SUM(total_time_ms) AS total_time_ms, SUM(calls) AS calls, SUM(rows_returned) AS rows_returned, CASE WHEN SUM(calls) > 0 THEN SUM(total_time_ms) / SUM(calls) ELSE 0 END AS mean_time_ms, array_agg(DISTINCT tenant_key ORDER BY tenant_key) AS tenant_keys FROM deltas WHERE total_time_ms > 0 OR calls > 0 GROUP BY fingerprint ORDER BY total_time_ms DESC, calls DESC LIMIT '20' OFFSET '0';[ Date: 2026-05-20 07:45:41 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
2 11s856ms CREATE SCHEMA IF NOT EXISTS observability;[ Date: 2026-05-20 07:46:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
3 11s856ms 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-05-20 07:46:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
4 11s856ms CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);[ Date: 2026-05-20 07:46:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
5 11s856ms CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);[ Date: 2026-05-20 07:46:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
6 11s856ms 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-05-20 07:46:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
7 11s856ms CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);[ Date: 2026-05-20 07:46:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
8 11s856ms CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);[ Date: 2026-05-20 07:46:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
9 11s856ms 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-05-20 07:46:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
10 11s856ms CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);[ Date: 2026-05-20 07:46:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
11 11s856ms 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-05-20 07:46:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
12 11s856ms 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-05-20 07:46:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
13 11s856ms 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-05-20 07:46:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
14 11s856ms 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-05-20 07:46:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
15 11s856ms ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS label text;[ Date: 2026-05-20 07:46:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
16 11s856ms ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS payload jsonb;[ Date: 2026-05-20 07:46:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
17 11s856ms CREATE INDEX IF NOT EXISTS idx_uptime_checks_endpoint ON observability.uptime_checks (endpoint, checked_at DESC);[ Date: 2026-05-20 07:46:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
18 11s856ms CREATE INDEX IF NOT EXISTS idx_uptime_checks_key ON observability.uptime_checks (check_key, checked_at DESC);[ Date: 2026-05-20 07:46:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
19 11s856ms CREATE SCHEMA IF NOT EXISTS observability;[ Date: 2026-05-20 07:47:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
20 11s856ms 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-05-20 07:47:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 27m11s 1,440 502ms 11s856ms 1s133ms alter table observability.uptime_checks add column if not exists payload jsonb;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 20 01 60 0ms 0ms 02 60 32s760ms 546ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 2m42s 2s704ms 09 60 55s201ms 920ms 10 60 44s221ms 737ms 11 60 41s163ms 686ms 12 60 1m1s 1s32ms 13 60 44s754ms 745ms 14 60 52s175ms 869ms 15 60 1m4s 1s75ms 16 60 1m14s 1s240ms 17 60 1m4s 1s79ms 18 60 1m6s 1s104ms 19 60 1m5s 1s99ms 20 60 1m5s 1s97ms 21 60 1m28s 1s473ms 22 60 1m39s 1s662ms 23 60 1m43s 1s718ms 00 60 1m45s 1s755ms [ User: monitoring_admin - Total duration: 27m11s - Times executed: 1349 ]
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS payload jsonb;
Date: 2026-05-20 07:50:01 Duration: 11s856ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS payload jsonb;
Date: 2026-05-20 08:00:01 Duration: 11s832ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS payload jsonb;
Date: 2026-05-20 22:21:01 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
2 27m11s 1,440 502ms 11s856ms 1s133ms create index if not exists idx_uptime_checks_key on observability.uptime_checks (check_key, checked_at desc);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 20 01 60 0ms 0ms 02 60 32s760ms 546ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 2m42s 2s704ms 09 60 55s201ms 920ms 10 60 44s221ms 737ms 11 60 41s163ms 686ms 12 60 1m1s 1s32ms 13 60 44s754ms 745ms 14 60 52s175ms 869ms 15 60 1m4s 1s75ms 16 60 1m14s 1s240ms 17 60 1m4s 1s79ms 18 60 1m6s 1s104ms 19 60 1m5s 1s99ms 20 60 1m5s 1s97ms 21 60 1m28s 1s473ms 22 60 1m39s 1s662ms 23 60 1m43s 1s718ms 00 60 1m45s 1s755ms [ User: monitoring_admin - Total duration: 27m11s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_key ON observability.uptime_checks (check_key, checked_at DESC);
Date: 2026-05-20 07:50:01 Duration: 11s856ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_key ON observability.uptime_checks (check_key, checked_at DESC);
Date: 2026-05-20 08:00:01 Duration: 11s832ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_key ON observability.uptime_checks (check_key, checked_at DESC);
Date: 2026-05-20 22:21:01 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
3 27m11s 1,440 502ms 11s856ms 1s133ms create index if not exists idx_uptime_checks_endpoint on observability.uptime_checks (endpoint, checked_at desc);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 20 01 60 0ms 0ms 02 60 32s760ms 546ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 2m42s 2s704ms 09 60 55s201ms 920ms 10 60 44s221ms 737ms 11 60 41s163ms 686ms 12 60 1m1s 1s32ms 13 60 44s754ms 745ms 14 60 52s175ms 869ms 15 60 1m4s 1s75ms 16 60 1m14s 1s240ms 17 60 1m4s 1s79ms 18 60 1m6s 1s104ms 19 60 1m5s 1s99ms 20 60 1m5s 1s97ms 21 60 1m28s 1s473ms 22 60 1m39s 1s662ms 23 60 1m43s 1s718ms 00 60 1m45s 1s755ms [ User: monitoring_admin - Total duration: 27m11s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_endpoint ON observability.uptime_checks (endpoint, checked_at DESC);
Date: 2026-05-20 07:50:01 Duration: 11s856ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_endpoint ON observability.uptime_checks (endpoint, checked_at DESC);
Date: 2026-05-20 08:00:01 Duration: 11s832ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_endpoint ON observability.uptime_checks (endpoint, checked_at DESC);
Date: 2026-05-20 22:21:01 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
4 27m11s 1,440 502ms 11s856ms 1s133ms 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 #4
Day Hour Count Duration Avg duration May 20 01 60 0ms 0ms 02 60 32s760ms 546ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 2m42s 2s704ms 09 60 55s201ms 920ms 10 60 44s221ms 737ms 11 60 41s163ms 686ms 12 60 1m1s 1s32ms 13 60 44s754ms 745ms 14 60 52s175ms 869ms 15 60 1m4s 1s74ms 16 60 1m14s 1s240ms 17 60 1m4s 1s79ms 18 60 1m6s 1s104ms 19 60 1m5s 1s99ms 20 60 1m5s 1s97ms 21 60 1m28s 1s473ms 22 60 1m39s 1s662ms 23 60 1m43s 1s718ms 00 60 1m45s 1s755ms [ User: monitoring_admin - Total duration: 27m11s - 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-05-20 07:50:01 Duration: 11s856ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_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-05-20 08:00:01 Duration: 11s832ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_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-05-20 22:21:01 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
5 27m11s 1,440 502ms 11s856ms 1s133ms 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 #5
Day Hour Count Duration Avg duration May 20 01 60 0ms 0ms 02 60 32s760ms 546ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 2m42s 2s704ms 09 60 55s201ms 920ms 10 60 44s221ms 737ms 11 60 41s163ms 686ms 12 60 1m1s 1s32ms 13 60 44s754ms 745ms 14 60 52s175ms 869ms 15 60 1m4s 1s74ms 16 60 1m14s 1s240ms 17 60 1m4s 1s79ms 18 60 1m6s 1s104ms 19 60 1m5s 1s99ms 20 60 1m5s 1s97ms 21 60 1m28s 1s473ms 22 60 1m39s 1s662ms 23 60 1m43s 1s718ms 00 60 1m45s 1s755ms [ User: monitoring_admin - Total duration: 27m11s - 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-05-20 07:50:01 Duration: 11s856ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_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-05-20 08:00:01 Duration: 11s832ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_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-05-20 22:21:01 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
6 27m11s 1,440 502ms 11s856ms 1s133ms 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 #6
Day Hour Count Duration Avg duration May 20 01 60 0ms 0ms 02 60 32s760ms 546ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 2m42s 2s704ms 09 60 55s201ms 920ms 10 60 44s221ms 737ms 11 60 41s163ms 686ms 12 60 1m1s 1s32ms 13 60 44s754ms 745ms 14 60 52s175ms 869ms 15 60 1m4s 1s74ms 16 60 1m14s 1s240ms 17 60 1m4s 1s79ms 18 60 1m6s 1s104ms 19 60 1m5s 1s99ms 20 60 1m5s 1s97ms 21 60 1m28s 1s473ms 22 60 1m39s 1s662ms 23 60 1m43s 1s718ms 00 60 1m45s 1s755ms [ User: monitoring_admin - Total duration: 27m11s - 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-05-20 07:50:01 Duration: 11s856ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_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-05-20 08:00:01 Duration: 11s832ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_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-05-20 22:21:01 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
7 27m11s 1,440 502ms 11s856ms 1s133ms alter table observability.uptime_checks add column if not exists label text;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration May 20 01 60 0ms 0ms 02 60 32s760ms 546ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 2m42s 2s704ms 09 60 55s201ms 920ms 10 60 44s221ms 737ms 11 60 41s163ms 686ms 12 60 1m1s 1s32ms 13 60 44s754ms 745ms 14 60 52s175ms 869ms 15 60 1m4s 1s74ms 16 60 1m14s 1s240ms 17 60 1m4s 1s79ms 18 60 1m6s 1s104ms 19 60 1m5s 1s99ms 20 60 1m5s 1s97ms 21 60 1m28s 1s473ms 22 60 1m39s 1s662ms 23 60 1m43s 1s718ms 00 60 1m45s 1s755ms [ User: monitoring_admin - Total duration: 27m11s - Times executed: 1349 ]
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS label text;
Date: 2026-05-20 07:50:01 Duration: 11s856ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS label text;
Date: 2026-05-20 08:00:01 Duration: 11s832ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS label text;
Date: 2026-05-20 22:21:01 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
8 27m11s 1,440 502ms 11s856ms 1s133ms 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 May 20 01 60 0ms 0ms 02 60 32s760ms 546ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 2m42s 2s704ms 09 60 55s201ms 920ms 10 60 44s221ms 737ms 11 60 41s163ms 686ms 12 60 1m1s 1s32ms 13 60 44s754ms 745ms 14 60 52s175ms 869ms 15 60 1m4s 1s74ms 16 60 1m14s 1s240ms 17 60 1m4s 1s79ms 18 60 1m6s 1s104ms 19 60 1m5s 1s99ms 20 60 1m5s 1s97ms 21 60 1m28s 1s473ms 22 60 1m39s 1s662ms 23 60 1m43s 1s718ms 00 60 1m45s 1s755ms [ User: monitoring_admin - Total duration: 27m11s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-05-20 07:50:01 Duration: 11s856ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-05-20 08:00:01 Duration: 11s832ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-05-20 22:21:01 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
9 27m11s 1,440 502ms 11s856ms 1s133ms create table if not exists observability.phpfpm_counters ( id bigserial primary key, payload jsonb not null, collected_at timestamptz not null default now() );Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration May 20 01 60 0ms 0ms 02 60 32s760ms 546ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 2m42s 2s704ms 09 60 55s201ms 920ms 10 60 44s221ms 737ms 11 60 41s163ms 686ms 12 60 1m1s 1s32ms 13 60 44s754ms 745ms 14 60 52s175ms 869ms 15 60 1m4s 1s74ms 16 60 1m14s 1s240ms 17 60 1m4s 1s79ms 18 60 1m6s 1s104ms 19 60 1m5s 1s99ms 20 60 1m5s 1s97ms 21 60 1m28s 1s473ms 22 60 1m39s 1s662ms 23 60 1m43s 1s718ms 00 60 1m45s 1s755ms [ User: monitoring_admin - Total duration: 27m11s - 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-05-20 07:50:01 Duration: 11s856ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_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-05-20 08:00:01 Duration: 11s832ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_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-05-20 22:21:01 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
10 27m11s 1,440 502ms 11s856ms 1s133ms create index if not exists idx_metrics_timeseries_bucket on observability.metrics_timeseries (bucket_start);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration May 20 01 60 0ms 0ms 02 60 32s760ms 546ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 2m42s 2s704ms 09 60 55s201ms 920ms 10 60 44s221ms 737ms 11 60 41s163ms 686ms 12 60 1m1s 1s32ms 13 60 44s754ms 745ms 14 60 52s175ms 869ms 15 60 1m4s 1s74ms 16 60 1m14s 1s240ms 17 60 1m4s 1s79ms 18 60 1m6s 1s104ms 19 60 1m5s 1s99ms 20 60 1m5s 1s97ms 21 60 1m28s 1s473ms 22 60 1m39s 1s662ms 23 60 1m43s 1s718ms 00 60 1m45s 1s755ms [ User: monitoring_admin - Total duration: 27m11s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-05-20 07:50:01 Duration: 11s856ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-05-20 08:00:01 Duration: 11s832ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-05-20 22:21:01 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
11 27m11s 1,440 502ms 11s856ms 1s133ms 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 #11
Day Hour Count Duration Avg duration May 20 01 60 0ms 0ms 02 60 32s760ms 546ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 2m42s 2s704ms 09 60 55s201ms 920ms 10 60 44s221ms 737ms 11 60 41s163ms 686ms 12 60 1m1s 1s32ms 13 60 44s754ms 745ms 14 60 52s175ms 869ms 15 60 1m4s 1s74ms 16 60 1m14s 1s240ms 17 60 1m4s 1s79ms 18 60 1m6s 1s104ms 19 60 1m5s 1s99ms 20 60 1m5s 1s97ms 21 60 1m28s 1s473ms 22 60 1m39s 1s662ms 23 60 1m43s 1s718ms 00 60 1m45s 1s755ms [ User: monitoring_admin - Total duration: 27m11s - 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-05-20 07:50:01 Duration: 11s856ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_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-05-20 08:00:01 Duration: 11s832ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_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-05-20 22:21:01 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
12 27m11s 1,440 502ms 11s856ms 1s133ms create index if not exists idx_metrics_timeseries_metric on observability.metrics_timeseries (metric_name);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration May 20 01 60 0ms 0ms 02 60 32s760ms 546ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 2m42s 2s704ms 09 60 55s201ms 920ms 10 60 44s221ms 737ms 11 60 41s163ms 686ms 12 60 1m1s 1s32ms 13 60 44s754ms 745ms 14 60 52s175ms 869ms 15 60 1m4s 1s74ms 16 60 1m14s 1s240ms 17 60 1m4s 1s79ms 18 60 1m6s 1s104ms 19 60 1m5s 1s99ms 20 60 1m5s 1s97ms 21 60 1m28s 1s473ms 22 60 1m39s 1s662ms 23 60 1m43s 1s718ms 00 60 1m45s 1s755ms [ User: monitoring_admin - Total duration: 27m11s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-05-20 07:50:01 Duration: 11s856ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-05-20 08:00:01 Duration: 11s832ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-05-20 22:21:01 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
13 27m11s 1,440 502ms 11s856ms 1s133ms 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 #13
Day Hour Count Duration Avg duration May 20 01 60 0ms 0ms 02 60 32s760ms 546ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 2m42s 2s704ms 09 60 55s201ms 920ms 10 60 44s221ms 737ms 11 60 41s163ms 686ms 12 60 1m1s 1s32ms 13 60 44s754ms 745ms 14 60 52s175ms 869ms 15 60 1m4s 1s74ms 16 60 1m14s 1s240ms 17 60 1m4s 1s79ms 18 60 1m6s 1s104ms 19 60 1m5s 1s99ms 20 60 1m5s 1s97ms 21 60 1m28s 1s473ms 22 60 1m39s 1s662ms 23 60 1m43s 1s718ms 00 60 1m45s 1s755ms [ User: monitoring_admin - Total duration: 27m11s - 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-05-20 07:50:01 Duration: 11s856ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_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-05-20 08:00:01 Duration: 11s832ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_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-05-20 22:21:01 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
14 27m11s 1,440 502ms 11s856ms 1s133ms create schema if not exists observability;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration May 20 01 60 0ms 0ms 02 60 32s760ms 546ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 2m42s 2s704ms 09 60 55s201ms 920ms 10 60 44s221ms 737ms 11 60 41s163ms 686ms 12 60 1m1s 1s32ms 13 60 44s754ms 745ms 14 60 52s175ms 869ms 15 60 1m4s 1s74ms 16 60 1m14s 1s240ms 17 60 1m4s 1s79ms 18 60 1m6s 1s104ms 19 60 1m5s 1s99ms 20 60 1m5s 1s97ms 21 60 1m28s 1s473ms 22 60 1m39s 1s662ms 23 60 1m43s 1s718ms 00 60 1m45s 1s755ms [ User: monitoring_admin - Total duration: 27m11s - Times executed: 1349 ]
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-05-20 07:50:01 Duration: 11s856ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-05-20 08:00:01 Duration: 11s832ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-05-20 22:21:01 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
15 27m11s 1,440 502ms 11s856ms 1s133ms 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 #15
Day Hour Count Duration Avg duration May 20 01 60 0ms 0ms 02 60 32s760ms 546ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 2m42s 2s704ms 09 60 55s201ms 920ms 10 60 44s221ms 737ms 11 60 41s163ms 686ms 12 60 1m1s 1s32ms 13 60 44s754ms 745ms 14 60 52s175ms 869ms 15 60 1m4s 1s74ms 16 60 1m14s 1s240ms 17 60 1m4s 1s79ms 18 60 1m6s 1s104ms 19 60 1m5s 1s99ms 20 60 1m5s 1s97ms 21 60 1m28s 1s473ms 22 60 1m39s 1s662ms 23 60 1m43s 1s718ms 00 60 1m45s 1s755ms [ User: monitoring_admin - Total duration: 27m11s - 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-05-20 07:50:01 Duration: 11s856ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-05-20 08:00:01 Duration: 11s832ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-05-20 22:21:01 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
16 27m11s 1,440 502ms 11s856ms 1s133ms 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 #16
Day Hour Count Duration Avg duration May 20 01 60 0ms 0ms 02 60 32s760ms 546ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 2m42s 2s704ms 09 60 55s201ms 920ms 10 60 44s221ms 737ms 11 60 41s163ms 686ms 12 60 1m1s 1s32ms 13 60 44s754ms 745ms 14 60 52s175ms 869ms 15 60 1m4s 1s74ms 16 60 1m14s 1s240ms 17 60 1m4s 1s79ms 18 60 1m6s 1s104ms 19 60 1m5s 1s99ms 20 60 1m5s 1s97ms 21 60 1m28s 1s473ms 22 60 1m39s 1s662ms 23 60 1m43s 1s718ms 00 60 1m45s 1s755ms [ User: monitoring_admin - Total duration: 27m11s - 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-05-20 07:50:01 Duration: 11s856ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_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-05-20 08:00:01 Duration: 11s832ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_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-05-20 22:21:01 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
17 27m11s 1,440 502ms 11s856ms 1s133ms create index if not exists idx_app_events_tenant on observability.app_events (tenant_key, occurred_at desc);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration May 20 01 60 0ms 0ms 02 60 32s760ms 546ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 2m42s 2s704ms 09 60 55s201ms 920ms 10 60 44s221ms 737ms 11 60 41s163ms 686ms 12 60 1m1s 1s32ms 13 60 44s754ms 745ms 14 60 52s175ms 869ms 15 60 1m4s 1s74ms 16 60 1m14s 1s240ms 17 60 1m4s 1s79ms 18 60 1m6s 1s104ms 19 60 1m5s 1s99ms 20 60 1m5s 1s97ms 21 60 1m28s 1s473ms 22 60 1m39s 1s662ms 23 60 1m43s 1s718ms 00 60 1m45s 1s755ms [ User: monitoring_admin - Total duration: 27m11s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-05-20 07:50:01 Duration: 11s856ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-05-20 08:00:01 Duration: 11s832ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-05-20 22:21:01 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
18 2m42s 186 708ms 1s468ms 872ms select distinct on (coalesce(check_key, endpoint) ) check_key, label, endpoint, status, latency_ms, payload, checked_at from observability.uptime_checks order by coalesce(check_key, endpoint), checked_at desc;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 20 08 3 2s244ms 748ms 09 12 8s919ms 743ms 10 12 8s874ms 739ms 11 3 2s198ms 732ms 12 12 8s856ms 738ms 13 12 8s935ms 744ms 14 12 9s59ms 754ms 15 11 8s369ms 760ms 16 13 9s875ms 759ms 17 12 9s280ms 773ms 18 12 9s195ms 766ms 19 12 9s323ms 776ms 20 12 9s371ms 780ms 21 12 12s876ms 1s73ms 22 12 14s315ms 1s192ms 23 12 14s981ms 1s248ms 00 12 15s575ms 1s297ms [ User: monitoring_admin - Total duration: 2m42s - Times executed: 186 ]
-
SELECT DISTINCT ON (COALESCE(check_key, endpoint) ) check_key, label, endpoint, status, latency_ms, payload, checked_at FROM observability.uptime_checks ORDER BY COALESCE(check_key, endpoint), checked_at DESC;
Date: 2026-05-20 23:56:58 Duration: 1s468ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
SELECT DISTINCT ON (COALESCE(check_key, endpoint) ) check_key, label, endpoint, status, latency_ms, payload, checked_at FROM observability.uptime_checks ORDER BY COALESCE(check_key, endpoint), checked_at DESC;
Date: 2026-05-20 23:16:57 Duration: 1s435ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
SELECT DISTINCT ON (COALESCE(check_key, endpoint) ) check_key, label, endpoint, status, latency_ms, payload, checked_at FROM observability.uptime_checks ORDER BY COALESCE(check_key, endpoint), checked_at DESC;
Date: 2026-05-20 22:16:53 Duration: 1s396ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
19 2m12s 66 1s402ms 11s856ms 2s6ms with start_snap as ( select distinct on (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at from observability.db_top_queries where tenant_key in (...) and collected_at >= ? and collected_at <= ? order by tenant_key, fingerprint, collected_at desc ), fallback_start as ( select distinct on (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at from observability.db_top_queries where tenant_key in (...) and collected_at between ? and ? order by tenant_key, fingerprint, collected_at asc ), end_snap as ( select distinct on (tenant_key, fingerprint) tenant_key, fingerprint, query, total_time_ms, calls, rows_returned, collected_at from observability.db_top_queries where tenant_key in (...) and collected_at between ? and ? order by tenant_key, fingerprint, collected_at desc ), deltas as ( select e.tenant_key, e.fingerprint, e.query, e.collected_at as last_seen, greatest (coalesce(e.total_time_ms, ?) - coalesce(s.total_time_ms, fs.total_time_ms, ?), ?) as total_time_ms, greatest (coalesce(e.calls, ?) - coalesce(s.calls, fs.calls, ?), ?) as calls, greatest (coalesce(e.rows_returned, ?) - coalesce(s.rows_returned, fs.rows_returned, ?), ?) as rows_returned from end_snap e left join start_snap s on s.tenant_key = e.tenant_key and s.fingerprint = e.fingerprint left join fallback_start fs on fs.tenant_key = e.tenant_key and fs.fingerprint = e.fingerprint and s.tenant_key is null ) select fingerprint, max(query) as query, max(last_seen) as last_seen, sum(total_time_ms) as total_time_ms, sum(calls) as calls, sum(rows_returned) as rows_returned, case when sum(calls) > ? then sum(total_time_ms) / sum(calls) else ? end as mean_time_ms, array_agg(distinct tenant_key order by tenant_key) as tenant_keys from deltas where total_time_ms > ? or calls > ? group by fingerprint order by total_time_ms desc, calls desc limit ? offset ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration May 20 08 2 23s688ms 11s844ms 14 2 2s861ms 1s430ms 15 5 7s140ms 1s428ms 16 9 13s93ms 1s454ms 17 6 8s642ms 1s440ms 18 6 8s679ms 1s446ms 19 6 8s603ms 1s433ms 20 6 8s662ms 1s443ms 21 6 11s111ms 1s851ms 22 6 13s59ms 2s176ms 23 6 13s345ms 2s224ms 00 6 13s507ms 2s251ms [ User: monitoring_admin - Total duration: 2m12s - Times executed: 66 ]
-
WITH start_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at >= '2026-05-18 01:45:29+02' AND collected_at <= '2026-05-20 01:45:29+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), fallback_start AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-05-20 01:45:29+02' AND '2026-05-20 07:45:29+02' ORDER BY tenant_key, fingerprint, collected_at ASC ), end_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, query, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-05-20 01:45:29+02' AND '2026-05-20 07:45:29+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), deltas AS ( SELECT e.tenant_key, e.fingerprint, e.query, e.collected_at AS last_seen, GREATEST (COALESCE(e.total_time_ms, 0) - COALESCE(s.total_time_ms, fs.total_time_ms, 0), 0) AS total_time_ms, GREATEST (COALESCE(e.calls, 0) - COALESCE(s.calls, fs.calls, 0), 0) AS calls, GREATEST (COALESCE(e.rows_returned, 0) - COALESCE(s.rows_returned, fs.rows_returned, 0), 0) AS rows_returned FROM end_snap e LEFT JOIN start_snap s ON s.tenant_key = e.tenant_key AND s.fingerprint = e.fingerprint LEFT JOIN fallback_start fs ON fs.tenant_key = e.tenant_key AND fs.fingerprint = e.fingerprint AND s.tenant_key IS NULL ) SELECT fingerprint, MAX(query) AS query, MAX(last_seen) AS last_seen, SUM(total_time_ms) AS total_time_ms, SUM(calls) AS calls, SUM(rows_returned) AS rows_returned, CASE WHEN SUM(calls) > 0 THEN SUM(total_time_ms) / SUM(calls) ELSE 0 END AS mean_time_ms, array_agg(DISTINCT tenant_key ORDER BY tenant_key) AS tenant_keys FROM deltas WHERE total_time_ms > 0 OR calls > 0 GROUP BY fingerprint ORDER BY total_time_ms DESC, calls DESC LIMIT '20' OFFSET '0';
Date: 2026-05-20 07:45:41 Duration: 11s856ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
WITH start_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at >= '2026-05-18 01:55:33+02' AND collected_at <= '2026-05-20 01:55:33+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), fallback_start AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-05-20 01:55:33+02' AND '2026-05-20 07:55:33+02' ORDER BY tenant_key, fingerprint, collected_at ASC ), end_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, query, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-05-20 01:55:33+02' AND '2026-05-20 07:55:33+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), deltas AS ( SELECT e.tenant_key, e.fingerprint, e.query, e.collected_at AS last_seen, GREATEST (COALESCE(e.total_time_ms, 0) - COALESCE(s.total_time_ms, fs.total_time_ms, 0), 0) AS total_time_ms, GREATEST (COALESCE(e.calls, 0) - COALESCE(s.calls, fs.calls, 0), 0) AS calls, GREATEST (COALESCE(e.rows_returned, 0) - COALESCE(s.rows_returned, fs.rows_returned, 0), 0) AS rows_returned FROM end_snap e LEFT JOIN start_snap s ON s.tenant_key = e.tenant_key AND s.fingerprint = e.fingerprint LEFT JOIN fallback_start fs ON fs.tenant_key = e.tenant_key AND fs.fingerprint = e.fingerprint AND s.tenant_key IS NULL ) SELECT fingerprint, MAX(query) AS query, MAX(last_seen) AS last_seen, SUM(total_time_ms) AS total_time_ms, SUM(calls) AS calls, SUM(rows_returned) AS rows_returned, CASE WHEN SUM(calls) > 0 THEN SUM(total_time_ms) / SUM(calls) ELSE 0 END AS mean_time_ms, array_agg(DISTINCT tenant_key ORDER BY tenant_key) AS tenant_keys FROM deltas WHERE total_time_ms > 0 OR calls > 0 GROUP BY fingerprint ORDER BY total_time_ms DESC, calls DESC LIMIT '20' OFFSET '0';
Date: 2026-05-20 07:55:45 Duration: 11s832ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
WITH start_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at >= '2026-05-18 16:16:51+02' AND collected_at <= '2026-05-20 16:16:51+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), fallback_start AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-05-20 16:16:51+02' AND '2026-05-20 22:16:51+02' ORDER BY tenant_key, fingerprint, collected_at ASC ), end_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, query, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-05-20 16:16:51+02' AND '2026-05-20 22:16:51+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), deltas AS ( SELECT e.tenant_key, e.fingerprint, e.query, e.collected_at AS last_seen, GREATEST (COALESCE(e.total_time_ms, 0) - COALESCE(s.total_time_ms, fs.total_time_ms, 0), 0) AS total_time_ms, GREATEST (COALESCE(e.calls, 0) - COALESCE(s.calls, fs.calls, 0), 0) AS calls, GREATEST (COALESCE(e.rows_returned, 0) - COALESCE(s.rows_returned, fs.rows_returned, 0), 0) AS rows_returned FROM end_snap e LEFT JOIN start_snap s ON s.tenant_key = e.tenant_key AND s.fingerprint = e.fingerprint LEFT JOIN fallback_start fs ON fs.tenant_key = e.tenant_key AND fs.fingerprint = e.fingerprint AND s.tenant_key IS NULL ) SELECT fingerprint, MAX(query) AS query, MAX(last_seen) AS last_seen, SUM(total_time_ms) AS total_time_ms, SUM(calls) AS calls, SUM(rows_returned) AS rows_returned, CASE WHEN SUM(calls) > 0 THEN SUM(total_time_ms) / SUM(calls) ELSE 0 END AS mean_time_ms, array_agg(DISTINCT tenant_key ORDER BY tenant_key) AS tenant_keys FROM deltas WHERE total_time_ms > 0 OR calls > 0 GROUP BY fingerprint ORDER BY total_time_ms DESC, calls DESC LIMIT '20' OFFSET '0';
Date: 2026-05-20 22:16:53 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
20 37s391ms 19 1s832ms 2s24ms 1s967ms 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 #20
Day Hour Count Duration Avg duration May 20 11 1 1s998ms 1s998ms 12 15 29s646ms 1s976ms 14 3 5s745ms 1s915ms [ User: labanimal - Total duration: 37s391ms - Times executed: 19 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 37s391ms - Times executed: 19 ]
-
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, 456) THEN TRUE WHEN user_is_tgm (dam.editor, 456) THEN TRUE WHEN user_is_tgm (dam.tourist, 456) 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, 456) THEN TRUE WHEN user_is_tgm (sire.editor, 456) THEN TRUE WHEN user_is_tgm (sire.tourist, 456) 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 ('51%') 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-05-20 11:24:34 Duration: 2s24ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_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, 456) THEN TRUE WHEN user_is_tgm (dam.editor, 456) THEN TRUE WHEN user_is_tgm (dam.tourist, 456) 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, 456) THEN TRUE WHEN user_is_tgm (sire.editor, 456) THEN TRUE WHEN user_is_tgm (sire.tourist, 456) 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 ('51%') 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-05-20 11:15:17 Duration: 2s6ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_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, 492) THEN TRUE WHEN user_is_tgm (dam.editor, 492) THEN TRUE WHEN user_is_tgm (dam.tourist, 492) 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, 492) THEN TRUE WHEN user_is_tgm (sire.editor, 492) THEN TRUE WHEN user_is_tgm (sire.tourist, 492) 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 ('48-317') 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-05-20 10:39:03 Duration: 1s998ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,440 27m11s 502ms 11s856ms 1s133ms alter table observability.uptime_checks add column if not exists payload jsonb;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 20 01 60 0ms 0ms 02 60 32s760ms 546ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 2m42s 2s704ms 09 60 55s201ms 920ms 10 60 44s221ms 737ms 11 60 41s163ms 686ms 12 60 1m1s 1s32ms 13 60 44s754ms 745ms 14 60 52s175ms 869ms 15 60 1m4s 1s75ms 16 60 1m14s 1s240ms 17 60 1m4s 1s79ms 18 60 1m6s 1s104ms 19 60 1m5s 1s99ms 20 60 1m5s 1s97ms 21 60 1m28s 1s473ms 22 60 1m39s 1s662ms 23 60 1m43s 1s718ms 00 60 1m45s 1s755ms [ User: monitoring_admin - Total duration: 27m11s - Times executed: 1349 ]
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS payload jsonb;
Date: 2026-05-20 07:50:01 Duration: 11s856ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS payload jsonb;
Date: 2026-05-20 08:00:01 Duration: 11s832ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS payload jsonb;
Date: 2026-05-20 22:21:01 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
2 1,440 27m11s 502ms 11s856ms 1s133ms create index if not exists idx_uptime_checks_key on observability.uptime_checks (check_key, checked_at desc);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 20 01 60 0ms 0ms 02 60 32s760ms 546ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 2m42s 2s704ms 09 60 55s201ms 920ms 10 60 44s221ms 737ms 11 60 41s163ms 686ms 12 60 1m1s 1s32ms 13 60 44s754ms 745ms 14 60 52s175ms 869ms 15 60 1m4s 1s75ms 16 60 1m14s 1s240ms 17 60 1m4s 1s79ms 18 60 1m6s 1s104ms 19 60 1m5s 1s99ms 20 60 1m5s 1s97ms 21 60 1m28s 1s473ms 22 60 1m39s 1s662ms 23 60 1m43s 1s718ms 00 60 1m45s 1s755ms [ User: monitoring_admin - Total duration: 27m11s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_key ON observability.uptime_checks (check_key, checked_at DESC);
Date: 2026-05-20 07:50:01 Duration: 11s856ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_key ON observability.uptime_checks (check_key, checked_at DESC);
Date: 2026-05-20 08:00:01 Duration: 11s832ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_key ON observability.uptime_checks (check_key, checked_at DESC);
Date: 2026-05-20 22:21:01 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
3 1,440 27m11s 502ms 11s856ms 1s133ms create index if not exists idx_uptime_checks_endpoint on observability.uptime_checks (endpoint, checked_at desc);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 20 01 60 0ms 0ms 02 60 32s760ms 546ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 2m42s 2s704ms 09 60 55s201ms 920ms 10 60 44s221ms 737ms 11 60 41s163ms 686ms 12 60 1m1s 1s32ms 13 60 44s754ms 745ms 14 60 52s175ms 869ms 15 60 1m4s 1s75ms 16 60 1m14s 1s240ms 17 60 1m4s 1s79ms 18 60 1m6s 1s104ms 19 60 1m5s 1s99ms 20 60 1m5s 1s97ms 21 60 1m28s 1s473ms 22 60 1m39s 1s662ms 23 60 1m43s 1s718ms 00 60 1m45s 1s755ms [ User: monitoring_admin - Total duration: 27m11s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_endpoint ON observability.uptime_checks (endpoint, checked_at DESC);
Date: 2026-05-20 07:50:01 Duration: 11s856ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_endpoint ON observability.uptime_checks (endpoint, checked_at DESC);
Date: 2026-05-20 08:00:01 Duration: 11s832ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_endpoint ON observability.uptime_checks (endpoint, checked_at DESC);
Date: 2026-05-20 22:21:01 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
4 1,440 27m11s 502ms 11s856ms 1s133ms 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 #4
Day Hour Count Duration Avg duration May 20 01 60 0ms 0ms 02 60 32s760ms 546ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 2m42s 2s704ms 09 60 55s201ms 920ms 10 60 44s221ms 737ms 11 60 41s163ms 686ms 12 60 1m1s 1s32ms 13 60 44s754ms 745ms 14 60 52s175ms 869ms 15 60 1m4s 1s74ms 16 60 1m14s 1s240ms 17 60 1m4s 1s79ms 18 60 1m6s 1s104ms 19 60 1m5s 1s99ms 20 60 1m5s 1s97ms 21 60 1m28s 1s473ms 22 60 1m39s 1s662ms 23 60 1m43s 1s718ms 00 60 1m45s 1s755ms [ User: monitoring_admin - Total duration: 27m11s - 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-05-20 07:50:01 Duration: 11s856ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_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-05-20 08:00:01 Duration: 11s832ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_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-05-20 22:21:01 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
5 1,440 27m11s 502ms 11s856ms 1s133ms 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 #5
Day Hour Count Duration Avg duration May 20 01 60 0ms 0ms 02 60 32s760ms 546ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 2m42s 2s704ms 09 60 55s201ms 920ms 10 60 44s221ms 737ms 11 60 41s163ms 686ms 12 60 1m1s 1s32ms 13 60 44s754ms 745ms 14 60 52s175ms 869ms 15 60 1m4s 1s74ms 16 60 1m14s 1s240ms 17 60 1m4s 1s79ms 18 60 1m6s 1s104ms 19 60 1m5s 1s99ms 20 60 1m5s 1s97ms 21 60 1m28s 1s473ms 22 60 1m39s 1s662ms 23 60 1m43s 1s718ms 00 60 1m45s 1s755ms [ User: monitoring_admin - Total duration: 27m11s - 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-05-20 07:50:01 Duration: 11s856ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_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-05-20 08:00:01 Duration: 11s832ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_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-05-20 22:21:01 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
6 1,440 27m11s 502ms 11s856ms 1s133ms 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 #6
Day Hour Count Duration Avg duration May 20 01 60 0ms 0ms 02 60 32s760ms 546ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 2m42s 2s704ms 09 60 55s201ms 920ms 10 60 44s221ms 737ms 11 60 41s163ms 686ms 12 60 1m1s 1s32ms 13 60 44s754ms 745ms 14 60 52s175ms 869ms 15 60 1m4s 1s74ms 16 60 1m14s 1s240ms 17 60 1m4s 1s79ms 18 60 1m6s 1s104ms 19 60 1m5s 1s99ms 20 60 1m5s 1s97ms 21 60 1m28s 1s473ms 22 60 1m39s 1s662ms 23 60 1m43s 1s718ms 00 60 1m45s 1s755ms [ User: monitoring_admin - Total duration: 27m11s - 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-05-20 07:50:01 Duration: 11s856ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_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-05-20 08:00:01 Duration: 11s832ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_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-05-20 22:21:01 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
7 1,440 27m11s 502ms 11s856ms 1s133ms alter table observability.uptime_checks add column if not exists label text;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration May 20 01 60 0ms 0ms 02 60 32s760ms 546ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 2m42s 2s704ms 09 60 55s201ms 920ms 10 60 44s221ms 737ms 11 60 41s163ms 686ms 12 60 1m1s 1s32ms 13 60 44s754ms 745ms 14 60 52s175ms 869ms 15 60 1m4s 1s74ms 16 60 1m14s 1s240ms 17 60 1m4s 1s79ms 18 60 1m6s 1s104ms 19 60 1m5s 1s99ms 20 60 1m5s 1s97ms 21 60 1m28s 1s473ms 22 60 1m39s 1s662ms 23 60 1m43s 1s718ms 00 60 1m45s 1s755ms [ User: monitoring_admin - Total duration: 27m11s - Times executed: 1349 ]
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS label text;
Date: 2026-05-20 07:50:01 Duration: 11s856ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS label text;
Date: 2026-05-20 08:00:01 Duration: 11s832ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS label text;
Date: 2026-05-20 22:21:01 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
8 1,440 27m11s 502ms 11s856ms 1s133ms 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 May 20 01 60 0ms 0ms 02 60 32s760ms 546ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 2m42s 2s704ms 09 60 55s201ms 920ms 10 60 44s221ms 737ms 11 60 41s163ms 686ms 12 60 1m1s 1s32ms 13 60 44s754ms 745ms 14 60 52s175ms 869ms 15 60 1m4s 1s74ms 16 60 1m14s 1s240ms 17 60 1m4s 1s79ms 18 60 1m6s 1s104ms 19 60 1m5s 1s99ms 20 60 1m5s 1s97ms 21 60 1m28s 1s473ms 22 60 1m39s 1s662ms 23 60 1m43s 1s718ms 00 60 1m45s 1s755ms [ User: monitoring_admin - Total duration: 27m11s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-05-20 07:50:01 Duration: 11s856ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-05-20 08:00:01 Duration: 11s832ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-05-20 22:21:01 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
9 1,440 27m11s 502ms 11s856ms 1s133ms create table if not exists observability.phpfpm_counters ( id bigserial primary key, payload jsonb not null, collected_at timestamptz not null default now() );Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration May 20 01 60 0ms 0ms 02 60 32s760ms 546ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 2m42s 2s704ms 09 60 55s201ms 920ms 10 60 44s221ms 737ms 11 60 41s163ms 686ms 12 60 1m1s 1s32ms 13 60 44s754ms 745ms 14 60 52s175ms 869ms 15 60 1m4s 1s74ms 16 60 1m14s 1s240ms 17 60 1m4s 1s79ms 18 60 1m6s 1s104ms 19 60 1m5s 1s99ms 20 60 1m5s 1s97ms 21 60 1m28s 1s473ms 22 60 1m39s 1s662ms 23 60 1m43s 1s718ms 00 60 1m45s 1s755ms [ User: monitoring_admin - Total duration: 27m11s - 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-05-20 07:50:01 Duration: 11s856ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_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-05-20 08:00:01 Duration: 11s832ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_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-05-20 22:21:01 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
10 1,440 27m11s 502ms 11s856ms 1s133ms create index if not exists idx_metrics_timeseries_bucket on observability.metrics_timeseries (bucket_start);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration May 20 01 60 0ms 0ms 02 60 32s760ms 546ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 2m42s 2s704ms 09 60 55s201ms 920ms 10 60 44s221ms 737ms 11 60 41s163ms 686ms 12 60 1m1s 1s32ms 13 60 44s754ms 745ms 14 60 52s175ms 869ms 15 60 1m4s 1s74ms 16 60 1m14s 1s240ms 17 60 1m4s 1s79ms 18 60 1m6s 1s104ms 19 60 1m5s 1s99ms 20 60 1m5s 1s97ms 21 60 1m28s 1s473ms 22 60 1m39s 1s662ms 23 60 1m43s 1s718ms 00 60 1m45s 1s755ms [ User: monitoring_admin - Total duration: 27m11s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-05-20 07:50:01 Duration: 11s856ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-05-20 08:00:01 Duration: 11s832ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-05-20 22:21:01 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
11 1,440 27m11s 502ms 11s856ms 1s133ms 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 #11
Day Hour Count Duration Avg duration May 20 01 60 0ms 0ms 02 60 32s760ms 546ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 2m42s 2s704ms 09 60 55s201ms 920ms 10 60 44s221ms 737ms 11 60 41s163ms 686ms 12 60 1m1s 1s32ms 13 60 44s754ms 745ms 14 60 52s175ms 869ms 15 60 1m4s 1s74ms 16 60 1m14s 1s240ms 17 60 1m4s 1s79ms 18 60 1m6s 1s104ms 19 60 1m5s 1s99ms 20 60 1m5s 1s97ms 21 60 1m28s 1s473ms 22 60 1m39s 1s662ms 23 60 1m43s 1s718ms 00 60 1m45s 1s755ms [ User: monitoring_admin - Total duration: 27m11s - 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-05-20 07:50:01 Duration: 11s856ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_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-05-20 08:00:01 Duration: 11s832ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_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-05-20 22:21:01 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
12 1,440 27m11s 502ms 11s856ms 1s133ms create index if not exists idx_metrics_timeseries_metric on observability.metrics_timeseries (metric_name);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration May 20 01 60 0ms 0ms 02 60 32s760ms 546ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 2m42s 2s704ms 09 60 55s201ms 920ms 10 60 44s221ms 737ms 11 60 41s163ms 686ms 12 60 1m1s 1s32ms 13 60 44s754ms 745ms 14 60 52s175ms 869ms 15 60 1m4s 1s74ms 16 60 1m14s 1s240ms 17 60 1m4s 1s79ms 18 60 1m6s 1s104ms 19 60 1m5s 1s99ms 20 60 1m5s 1s97ms 21 60 1m28s 1s473ms 22 60 1m39s 1s662ms 23 60 1m43s 1s718ms 00 60 1m45s 1s755ms [ User: monitoring_admin - Total duration: 27m11s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-05-20 07:50:01 Duration: 11s856ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-05-20 08:00:01 Duration: 11s832ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-05-20 22:21:01 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
13 1,440 27m11s 502ms 11s856ms 1s133ms 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 #13
Day Hour Count Duration Avg duration May 20 01 60 0ms 0ms 02 60 32s760ms 546ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 2m42s 2s704ms 09 60 55s201ms 920ms 10 60 44s221ms 737ms 11 60 41s163ms 686ms 12 60 1m1s 1s32ms 13 60 44s754ms 745ms 14 60 52s175ms 869ms 15 60 1m4s 1s74ms 16 60 1m14s 1s240ms 17 60 1m4s 1s79ms 18 60 1m6s 1s104ms 19 60 1m5s 1s99ms 20 60 1m5s 1s97ms 21 60 1m28s 1s473ms 22 60 1m39s 1s662ms 23 60 1m43s 1s718ms 00 60 1m45s 1s755ms [ User: monitoring_admin - Total duration: 27m11s - 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-05-20 07:50:01 Duration: 11s856ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_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-05-20 08:00:01 Duration: 11s832ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_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-05-20 22:21:01 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
14 1,440 27m11s 502ms 11s856ms 1s133ms create schema if not exists observability;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration May 20 01 60 0ms 0ms 02 60 32s760ms 546ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 2m42s 2s704ms 09 60 55s201ms 920ms 10 60 44s221ms 737ms 11 60 41s163ms 686ms 12 60 1m1s 1s32ms 13 60 44s754ms 745ms 14 60 52s175ms 869ms 15 60 1m4s 1s74ms 16 60 1m14s 1s240ms 17 60 1m4s 1s79ms 18 60 1m6s 1s104ms 19 60 1m5s 1s99ms 20 60 1m5s 1s97ms 21 60 1m28s 1s473ms 22 60 1m39s 1s662ms 23 60 1m43s 1s718ms 00 60 1m45s 1s755ms [ User: monitoring_admin - Total duration: 27m11s - Times executed: 1349 ]
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-05-20 07:50:01 Duration: 11s856ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-05-20 08:00:01 Duration: 11s832ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-05-20 22:21:01 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
15 1,440 27m11s 502ms 11s856ms 1s133ms 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 #15
Day Hour Count Duration Avg duration May 20 01 60 0ms 0ms 02 60 32s760ms 546ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 2m42s 2s704ms 09 60 55s201ms 920ms 10 60 44s221ms 737ms 11 60 41s163ms 686ms 12 60 1m1s 1s32ms 13 60 44s754ms 745ms 14 60 52s175ms 869ms 15 60 1m4s 1s74ms 16 60 1m14s 1s240ms 17 60 1m4s 1s79ms 18 60 1m6s 1s104ms 19 60 1m5s 1s99ms 20 60 1m5s 1s97ms 21 60 1m28s 1s473ms 22 60 1m39s 1s662ms 23 60 1m43s 1s718ms 00 60 1m45s 1s755ms [ User: monitoring_admin - Total duration: 27m11s - 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-05-20 07:50:01 Duration: 11s856ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-05-20 08:00:01 Duration: 11s832ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-05-20 22:21:01 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
16 1,440 27m11s 502ms 11s856ms 1s133ms 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 #16
Day Hour Count Duration Avg duration May 20 01 60 0ms 0ms 02 60 32s760ms 546ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 2m42s 2s704ms 09 60 55s201ms 920ms 10 60 44s221ms 737ms 11 60 41s163ms 686ms 12 60 1m1s 1s32ms 13 60 44s754ms 745ms 14 60 52s175ms 869ms 15 60 1m4s 1s74ms 16 60 1m14s 1s240ms 17 60 1m4s 1s79ms 18 60 1m6s 1s104ms 19 60 1m5s 1s99ms 20 60 1m5s 1s97ms 21 60 1m28s 1s473ms 22 60 1m39s 1s662ms 23 60 1m43s 1s718ms 00 60 1m45s 1s755ms [ User: monitoring_admin - Total duration: 27m11s - 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-05-20 07:50:01 Duration: 11s856ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_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-05-20 08:00:01 Duration: 11s832ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_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-05-20 22:21:01 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
17 1,440 27m11s 502ms 11s856ms 1s133ms create index if not exists idx_app_events_tenant on observability.app_events (tenant_key, occurred_at desc);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration May 20 01 60 0ms 0ms 02 60 32s760ms 546ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 2m42s 2s704ms 09 60 55s201ms 920ms 10 60 44s221ms 737ms 11 60 41s163ms 686ms 12 60 1m1s 1s32ms 13 60 44s754ms 745ms 14 60 52s175ms 869ms 15 60 1m4s 1s74ms 16 60 1m14s 1s240ms 17 60 1m4s 1s79ms 18 60 1m6s 1s104ms 19 60 1m5s 1s99ms 20 60 1m5s 1s97ms 21 60 1m28s 1s473ms 22 60 1m39s 1s662ms 23 60 1m43s 1s718ms 00 60 1m45s 1s755ms [ User: monitoring_admin - Total duration: 27m11s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-05-20 07:50:01 Duration: 11s856ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-05-20 08:00:01 Duration: 11s832ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-05-20 22:21:01 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
18 186 2m42s 708ms 1s468ms 872ms select distinct on (coalesce(check_key, endpoint) ) check_key, label, endpoint, status, latency_ms, payload, checked_at from observability.uptime_checks order by coalesce(check_key, endpoint), checked_at desc;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 20 08 3 2s244ms 748ms 09 12 8s919ms 743ms 10 12 8s874ms 739ms 11 3 2s198ms 732ms 12 12 8s856ms 738ms 13 12 8s935ms 744ms 14 12 9s59ms 754ms 15 11 8s369ms 760ms 16 13 9s875ms 759ms 17 12 9s280ms 773ms 18 12 9s195ms 766ms 19 12 9s323ms 776ms 20 12 9s371ms 780ms 21 12 12s876ms 1s73ms 22 12 14s315ms 1s192ms 23 12 14s981ms 1s248ms 00 12 15s575ms 1s297ms [ User: monitoring_admin - Total duration: 2m42s - Times executed: 186 ]
-
SELECT DISTINCT ON (COALESCE(check_key, endpoint) ) check_key, label, endpoint, status, latency_ms, payload, checked_at FROM observability.uptime_checks ORDER BY COALESCE(check_key, endpoint), checked_at DESC;
Date: 2026-05-20 23:56:58 Duration: 1s468ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
SELECT DISTINCT ON (COALESCE(check_key, endpoint) ) check_key, label, endpoint, status, latency_ms, payload, checked_at FROM observability.uptime_checks ORDER BY COALESCE(check_key, endpoint), checked_at DESC;
Date: 2026-05-20 23:16:57 Duration: 1s435ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
SELECT DISTINCT ON (COALESCE(check_key, endpoint) ) check_key, label, endpoint, status, latency_ms, payload, checked_at FROM observability.uptime_checks ORDER BY COALESCE(check_key, endpoint), checked_at DESC;
Date: 2026-05-20 22:16:53 Duration: 1s396ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
19 66 2m12s 1s402ms 11s856ms 2s6ms with start_snap as ( select distinct on (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at from observability.db_top_queries where tenant_key in (...) and collected_at >= ? and collected_at <= ? order by tenant_key, fingerprint, collected_at desc ), fallback_start as ( select distinct on (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at from observability.db_top_queries where tenant_key in (...) and collected_at between ? and ? order by tenant_key, fingerprint, collected_at asc ), end_snap as ( select distinct on (tenant_key, fingerprint) tenant_key, fingerprint, query, total_time_ms, calls, rows_returned, collected_at from observability.db_top_queries where tenant_key in (...) and collected_at between ? and ? order by tenant_key, fingerprint, collected_at desc ), deltas as ( select e.tenant_key, e.fingerprint, e.query, e.collected_at as last_seen, greatest (coalesce(e.total_time_ms, ?) - coalesce(s.total_time_ms, fs.total_time_ms, ?), ?) as total_time_ms, greatest (coalesce(e.calls, ?) - coalesce(s.calls, fs.calls, ?), ?) as calls, greatest (coalesce(e.rows_returned, ?) - coalesce(s.rows_returned, fs.rows_returned, ?), ?) as rows_returned from end_snap e left join start_snap s on s.tenant_key = e.tenant_key and s.fingerprint = e.fingerprint left join fallback_start fs on fs.tenant_key = e.tenant_key and fs.fingerprint = e.fingerprint and s.tenant_key is null ) select fingerprint, max(query) as query, max(last_seen) as last_seen, sum(total_time_ms) as total_time_ms, sum(calls) as calls, sum(rows_returned) as rows_returned, case when sum(calls) > ? then sum(total_time_ms) / sum(calls) else ? end as mean_time_ms, array_agg(distinct tenant_key order by tenant_key) as tenant_keys from deltas where total_time_ms > ? or calls > ? group by fingerprint order by total_time_ms desc, calls desc limit ? offset ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration May 20 08 2 23s688ms 11s844ms 14 2 2s861ms 1s430ms 15 5 7s140ms 1s428ms 16 9 13s93ms 1s454ms 17 6 8s642ms 1s440ms 18 6 8s679ms 1s446ms 19 6 8s603ms 1s433ms 20 6 8s662ms 1s443ms 21 6 11s111ms 1s851ms 22 6 13s59ms 2s176ms 23 6 13s345ms 2s224ms 00 6 13s507ms 2s251ms [ User: monitoring_admin - Total duration: 2m12s - Times executed: 66 ]
-
WITH start_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at >= '2026-05-18 01:45:29+02' AND collected_at <= '2026-05-20 01:45:29+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), fallback_start AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-05-20 01:45:29+02' AND '2026-05-20 07:45:29+02' ORDER BY tenant_key, fingerprint, collected_at ASC ), end_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, query, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-05-20 01:45:29+02' AND '2026-05-20 07:45:29+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), deltas AS ( SELECT e.tenant_key, e.fingerprint, e.query, e.collected_at AS last_seen, GREATEST (COALESCE(e.total_time_ms, 0) - COALESCE(s.total_time_ms, fs.total_time_ms, 0), 0) AS total_time_ms, GREATEST (COALESCE(e.calls, 0) - COALESCE(s.calls, fs.calls, 0), 0) AS calls, GREATEST (COALESCE(e.rows_returned, 0) - COALESCE(s.rows_returned, fs.rows_returned, 0), 0) AS rows_returned FROM end_snap e LEFT JOIN start_snap s ON s.tenant_key = e.tenant_key AND s.fingerprint = e.fingerprint LEFT JOIN fallback_start fs ON fs.tenant_key = e.tenant_key AND fs.fingerprint = e.fingerprint AND s.tenant_key IS NULL ) SELECT fingerprint, MAX(query) AS query, MAX(last_seen) AS last_seen, SUM(total_time_ms) AS total_time_ms, SUM(calls) AS calls, SUM(rows_returned) AS rows_returned, CASE WHEN SUM(calls) > 0 THEN SUM(total_time_ms) / SUM(calls) ELSE 0 END AS mean_time_ms, array_agg(DISTINCT tenant_key ORDER BY tenant_key) AS tenant_keys FROM deltas WHERE total_time_ms > 0 OR calls > 0 GROUP BY fingerprint ORDER BY total_time_ms DESC, calls DESC LIMIT '20' OFFSET '0';
Date: 2026-05-20 07:45:41 Duration: 11s856ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
WITH start_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at >= '2026-05-18 01:55:33+02' AND collected_at <= '2026-05-20 01:55:33+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), fallback_start AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-05-20 01:55:33+02' AND '2026-05-20 07:55:33+02' ORDER BY tenant_key, fingerprint, collected_at ASC ), end_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, query, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-05-20 01:55:33+02' AND '2026-05-20 07:55:33+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), deltas AS ( SELECT e.tenant_key, e.fingerprint, e.query, e.collected_at AS last_seen, GREATEST (COALESCE(e.total_time_ms, 0) - COALESCE(s.total_time_ms, fs.total_time_ms, 0), 0) AS total_time_ms, GREATEST (COALESCE(e.calls, 0) - COALESCE(s.calls, fs.calls, 0), 0) AS calls, GREATEST (COALESCE(e.rows_returned, 0) - COALESCE(s.rows_returned, fs.rows_returned, 0), 0) AS rows_returned FROM end_snap e LEFT JOIN start_snap s ON s.tenant_key = e.tenant_key AND s.fingerprint = e.fingerprint LEFT JOIN fallback_start fs ON fs.tenant_key = e.tenant_key AND fs.fingerprint = e.fingerprint AND s.tenant_key IS NULL ) SELECT fingerprint, MAX(query) AS query, MAX(last_seen) AS last_seen, SUM(total_time_ms) AS total_time_ms, SUM(calls) AS calls, SUM(rows_returned) AS rows_returned, CASE WHEN SUM(calls) > 0 THEN SUM(total_time_ms) / SUM(calls) ELSE 0 END AS mean_time_ms, array_agg(DISTINCT tenant_key ORDER BY tenant_key) AS tenant_keys FROM deltas WHERE total_time_ms > 0 OR calls > 0 GROUP BY fingerprint ORDER BY total_time_ms DESC, calls DESC LIMIT '20' OFFSET '0';
Date: 2026-05-20 07:55:45 Duration: 11s832ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
WITH start_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at >= '2026-05-18 16:16:51+02' AND collected_at <= '2026-05-20 16:16:51+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), fallback_start AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-05-20 16:16:51+02' AND '2026-05-20 22:16:51+02' ORDER BY tenant_key, fingerprint, collected_at ASC ), end_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, query, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-05-20 16:16:51+02' AND '2026-05-20 22:16:51+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), deltas AS ( SELECT e.tenant_key, e.fingerprint, e.query, e.collected_at AS last_seen, GREATEST (COALESCE(e.total_time_ms, 0) - COALESCE(s.total_time_ms, fs.total_time_ms, 0), 0) AS total_time_ms, GREATEST (COALESCE(e.calls, 0) - COALESCE(s.calls, fs.calls, 0), 0) AS calls, GREATEST (COALESCE(e.rows_returned, 0) - COALESCE(s.rows_returned, fs.rows_returned, 0), 0) AS rows_returned FROM end_snap e LEFT JOIN start_snap s ON s.tenant_key = e.tenant_key AND s.fingerprint = e.fingerprint LEFT JOIN fallback_start fs ON fs.tenant_key = e.tenant_key AND fs.fingerprint = e.fingerprint AND s.tenant_key IS NULL ) SELECT fingerprint, MAX(query) AS query, MAX(last_seen) AS last_seen, SUM(total_time_ms) AS total_time_ms, SUM(calls) AS calls, SUM(rows_returned) AS rows_returned, CASE WHEN SUM(calls) > 0 THEN SUM(total_time_ms) / SUM(calls) ELSE 0 END AS mean_time_ms, array_agg(DISTINCT tenant_key ORDER BY tenant_key) AS tenant_keys FROM deltas WHERE total_time_ms > 0 OR calls > 0 GROUP BY fingerprint ORDER BY total_time_ms DESC, calls DESC LIMIT '20' OFFSET '0';
Date: 2026-05-20 22:16:53 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
20 27 22s 798ms 834ms 814ms select count(distinct animal_id) AS "count" from ( select animals_search_mview.*, b.unbreeding_date, a.id as animal, user_is_tgm (animals_search_mview.owner, ?) as is_owner, user_is_tgm (animals_search_mview.editor, ?) as is_editor, user_is_tgm (animals_search_mview.tourist, ?) as is_tourist, case when not exists ( select ? from scoresheet_diary sd where sd.animals_id = animals_search_mview.id) then ? else ? end as isscored from animals_search_mview left join strains on strains.name = animals_search_mview.strain left join license_history lh on lh.anid = animals_search_mview.id left join animals a on a."animalID" = animals_search_mview.animal_id left join breedings b on b.id = animals_search_mview.last_mating) data where fate = ? and alive = ? and deleted = ? and (is_owner or is_editor or is_tourist);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 20 09 1 817ms 817ms 11 6 4s875ms 812ms 12 2 1s625ms 812ms 14 15 12s202ms 813ms 19 2 1s644ms 822ms 21 1 834ms 834ms [ User: labanimal - Total duration: 22s - Times executed: 27 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 22s - Times executed: 27 ]
-
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, 64) AS is_owner, user_is_tgm (animals_search_mview.editor, 64) AS is_editor, user_is_tgm (animals_search_mview.tourist, 64) 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-05-20 20:56:19 Duration: 834ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_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-05-20 18:11:33 Duration: 831ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_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, 10100002) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100002) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100002) 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-05-20 13:27:13 Duration: 825ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 1s402ms 11s856ms 2s6ms 66 2m12s with start_snap as ( select distinct on (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at from observability.db_top_queries where tenant_key in (...) and collected_at >= ? and collected_at <= ? order by tenant_key, fingerprint, collected_at desc ), fallback_start as ( select distinct on (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at from observability.db_top_queries where tenant_key in (...) and collected_at between ? and ? order by tenant_key, fingerprint, collected_at asc ), end_snap as ( select distinct on (tenant_key, fingerprint) tenant_key, fingerprint, query, total_time_ms, calls, rows_returned, collected_at from observability.db_top_queries where tenant_key in (...) and collected_at between ? and ? order by tenant_key, fingerprint, collected_at desc ), deltas as ( select e.tenant_key, e.fingerprint, e.query, e.collected_at as last_seen, greatest (coalesce(e.total_time_ms, ?) - coalesce(s.total_time_ms, fs.total_time_ms, ?), ?) as total_time_ms, greatest (coalesce(e.calls, ?) - coalesce(s.calls, fs.calls, ?), ?) as calls, greatest (coalesce(e.rows_returned, ?) - coalesce(s.rows_returned, fs.rows_returned, ?), ?) as rows_returned from end_snap e left join start_snap s on s.tenant_key = e.tenant_key and s.fingerprint = e.fingerprint left join fallback_start fs on fs.tenant_key = e.tenant_key and fs.fingerprint = e.fingerprint and s.tenant_key is null ) select fingerprint, max(query) as query, max(last_seen) as last_seen, sum(total_time_ms) as total_time_ms, sum(calls) as calls, sum(rows_returned) as rows_returned, case when sum(calls) > ? then sum(total_time_ms) / sum(calls) else ? end as mean_time_ms, array_agg(distinct tenant_key order by tenant_key) as tenant_keys from deltas where total_time_ms > ? or calls > ? group by fingerprint order by total_time_ms desc, calls desc limit ? offset ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 20 08 2 23s688ms 11s844ms 14 2 2s861ms 1s430ms 15 5 7s140ms 1s428ms 16 9 13s93ms 1s454ms 17 6 8s642ms 1s440ms 18 6 8s679ms 1s446ms 19 6 8s603ms 1s433ms 20 6 8s662ms 1s443ms 21 6 11s111ms 1s851ms 22 6 13s59ms 2s176ms 23 6 13s345ms 2s224ms 00 6 13s507ms 2s251ms [ User: monitoring_admin - Total duration: 2m12s - Times executed: 66 ]
-
WITH start_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at >= '2026-05-18 01:45:29+02' AND collected_at <= '2026-05-20 01:45:29+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), fallback_start AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-05-20 01:45:29+02' AND '2026-05-20 07:45:29+02' ORDER BY tenant_key, fingerprint, collected_at ASC ), end_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, query, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-05-20 01:45:29+02' AND '2026-05-20 07:45:29+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), deltas AS ( SELECT e.tenant_key, e.fingerprint, e.query, e.collected_at AS last_seen, GREATEST (COALESCE(e.total_time_ms, 0) - COALESCE(s.total_time_ms, fs.total_time_ms, 0), 0) AS total_time_ms, GREATEST (COALESCE(e.calls, 0) - COALESCE(s.calls, fs.calls, 0), 0) AS calls, GREATEST (COALESCE(e.rows_returned, 0) - COALESCE(s.rows_returned, fs.rows_returned, 0), 0) AS rows_returned FROM end_snap e LEFT JOIN start_snap s ON s.tenant_key = e.tenant_key AND s.fingerprint = e.fingerprint LEFT JOIN fallback_start fs ON fs.tenant_key = e.tenant_key AND fs.fingerprint = e.fingerprint AND s.tenant_key IS NULL ) SELECT fingerprint, MAX(query) AS query, MAX(last_seen) AS last_seen, SUM(total_time_ms) AS total_time_ms, SUM(calls) AS calls, SUM(rows_returned) AS rows_returned, CASE WHEN SUM(calls) > 0 THEN SUM(total_time_ms) / SUM(calls) ELSE 0 END AS mean_time_ms, array_agg(DISTINCT tenant_key ORDER BY tenant_key) AS tenant_keys FROM deltas WHERE total_time_ms > 0 OR calls > 0 GROUP BY fingerprint ORDER BY total_time_ms DESC, calls DESC LIMIT '20' OFFSET '0';
Date: 2026-05-20 07:45:41 Duration: 11s856ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
WITH start_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at >= '2026-05-18 01:55:33+02' AND collected_at <= '2026-05-20 01:55:33+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), fallback_start AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-05-20 01:55:33+02' AND '2026-05-20 07:55:33+02' ORDER BY tenant_key, fingerprint, collected_at ASC ), end_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, query, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-05-20 01:55:33+02' AND '2026-05-20 07:55:33+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), deltas AS ( SELECT e.tenant_key, e.fingerprint, e.query, e.collected_at AS last_seen, GREATEST (COALESCE(e.total_time_ms, 0) - COALESCE(s.total_time_ms, fs.total_time_ms, 0), 0) AS total_time_ms, GREATEST (COALESCE(e.calls, 0) - COALESCE(s.calls, fs.calls, 0), 0) AS calls, GREATEST (COALESCE(e.rows_returned, 0) - COALESCE(s.rows_returned, fs.rows_returned, 0), 0) AS rows_returned FROM end_snap e LEFT JOIN start_snap s ON s.tenant_key = e.tenant_key AND s.fingerprint = e.fingerprint LEFT JOIN fallback_start fs ON fs.tenant_key = e.tenant_key AND fs.fingerprint = e.fingerprint AND s.tenant_key IS NULL ) SELECT fingerprint, MAX(query) AS query, MAX(last_seen) AS last_seen, SUM(total_time_ms) AS total_time_ms, SUM(calls) AS calls, SUM(rows_returned) AS rows_returned, CASE WHEN SUM(calls) > 0 THEN SUM(total_time_ms) / SUM(calls) ELSE 0 END AS mean_time_ms, array_agg(DISTINCT tenant_key ORDER BY tenant_key) AS tenant_keys FROM deltas WHERE total_time_ms > 0 OR calls > 0 GROUP BY fingerprint ORDER BY total_time_ms DESC, calls DESC LIMIT '20' OFFSET '0';
Date: 2026-05-20 07:55:45 Duration: 11s832ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
WITH start_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at >= '2026-05-18 16:16:51+02' AND collected_at <= '2026-05-20 16:16:51+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), fallback_start AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-05-20 16:16:51+02' AND '2026-05-20 22:16:51+02' ORDER BY tenant_key, fingerprint, collected_at ASC ), end_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, query, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-05-20 16:16:51+02' AND '2026-05-20 22:16:51+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), deltas AS ( SELECT e.tenant_key, e.fingerprint, e.query, e.collected_at AS last_seen, GREATEST (COALESCE(e.total_time_ms, 0) - COALESCE(s.total_time_ms, fs.total_time_ms, 0), 0) AS total_time_ms, GREATEST (COALESCE(e.calls, 0) - COALESCE(s.calls, fs.calls, 0), 0) AS calls, GREATEST (COALESCE(e.rows_returned, 0) - COALESCE(s.rows_returned, fs.rows_returned, 0), 0) AS rows_returned FROM end_snap e LEFT JOIN start_snap s ON s.tenant_key = e.tenant_key AND s.fingerprint = e.fingerprint LEFT JOIN fallback_start fs ON fs.tenant_key = e.tenant_key AND fs.fingerprint = e.fingerprint AND s.tenant_key IS NULL ) SELECT fingerprint, MAX(query) AS query, MAX(last_seen) AS last_seen, SUM(total_time_ms) AS total_time_ms, SUM(calls) AS calls, SUM(rows_returned) AS rows_returned, CASE WHEN SUM(calls) > 0 THEN SUM(total_time_ms) / SUM(calls) ELSE 0 END AS mean_time_ms, array_agg(DISTINCT tenant_key ORDER BY tenant_key) AS tenant_keys FROM deltas WHERE total_time_ms > 0 OR calls > 0 GROUP BY fingerprint ORDER BY total_time_ms DESC, calls DESC LIMIT '20' OFFSET '0';
Date: 2026-05-20 22:16:53 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
2 1s832ms 2s24ms 1s967ms 19 37s391ms 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 May 20 11 1 1s998ms 1s998ms 12 15 29s646ms 1s976ms 14 3 5s745ms 1s915ms [ User: labanimal - Total duration: 37s391ms - Times executed: 19 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 37s391ms - Times executed: 19 ]
-
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, 456) THEN TRUE WHEN user_is_tgm (dam.editor, 456) THEN TRUE WHEN user_is_tgm (dam.tourist, 456) 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, 456) THEN TRUE WHEN user_is_tgm (sire.editor, 456) THEN TRUE WHEN user_is_tgm (sire.tourist, 456) 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 ('51%') 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-05-20 11:24:34 Duration: 2s24ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_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, 456) THEN TRUE WHEN user_is_tgm (dam.editor, 456) THEN TRUE WHEN user_is_tgm (dam.tourist, 456) 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, 456) THEN TRUE WHEN user_is_tgm (sire.editor, 456) THEN TRUE WHEN user_is_tgm (sire.tourist, 456) 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 ('51%') 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-05-20 11:15:17 Duration: 2s6ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_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, 492) THEN TRUE WHEN user_is_tgm (dam.editor, 492) THEN TRUE WHEN user_is_tgm (dam.tourist, 492) 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, 492) THEN TRUE WHEN user_is_tgm (sire.editor, 492) THEN TRUE WHEN user_is_tgm (sire.tourist, 492) 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 ('48-317') 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-05-20 10:39:03 Duration: 1s998ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
3 502ms 11s856ms 1s133ms 1,440 27m11s alter table observability.uptime_checks add column if not exists payload jsonb;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 20 01 60 0ms 0ms 02 60 32s760ms 546ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 2m42s 2s704ms 09 60 55s201ms 920ms 10 60 44s221ms 737ms 11 60 41s163ms 686ms 12 60 1m1s 1s32ms 13 60 44s754ms 745ms 14 60 52s175ms 869ms 15 60 1m4s 1s75ms 16 60 1m14s 1s240ms 17 60 1m4s 1s79ms 18 60 1m6s 1s104ms 19 60 1m5s 1s99ms 20 60 1m5s 1s97ms 21 60 1m28s 1s473ms 22 60 1m39s 1s662ms 23 60 1m43s 1s718ms 00 60 1m45s 1s755ms [ User: monitoring_admin - Total duration: 27m11s - Times executed: 1349 ]
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS payload jsonb;
Date: 2026-05-20 07:50:01 Duration: 11s856ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS payload jsonb;
Date: 2026-05-20 08:00:01 Duration: 11s832ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS payload jsonb;
Date: 2026-05-20 22:21:01 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
4 502ms 11s856ms 1s133ms 1,440 27m11s create index if not exists idx_uptime_checks_key on observability.uptime_checks (check_key, checked_at desc);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration May 20 01 60 0ms 0ms 02 60 32s760ms 546ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 2m42s 2s704ms 09 60 55s201ms 920ms 10 60 44s221ms 737ms 11 60 41s163ms 686ms 12 60 1m1s 1s32ms 13 60 44s754ms 745ms 14 60 52s175ms 869ms 15 60 1m4s 1s75ms 16 60 1m14s 1s240ms 17 60 1m4s 1s79ms 18 60 1m6s 1s104ms 19 60 1m5s 1s99ms 20 60 1m5s 1s97ms 21 60 1m28s 1s473ms 22 60 1m39s 1s662ms 23 60 1m43s 1s718ms 00 60 1m45s 1s755ms [ User: monitoring_admin - Total duration: 27m11s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_key ON observability.uptime_checks (check_key, checked_at DESC);
Date: 2026-05-20 07:50:01 Duration: 11s856ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_key ON observability.uptime_checks (check_key, checked_at DESC);
Date: 2026-05-20 08:00:01 Duration: 11s832ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_key ON observability.uptime_checks (check_key, checked_at DESC);
Date: 2026-05-20 22:21:01 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
5 502ms 11s856ms 1s133ms 1,440 27m11s create index if not exists idx_uptime_checks_endpoint on observability.uptime_checks (endpoint, checked_at desc);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration May 20 01 60 0ms 0ms 02 60 32s760ms 546ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 2m42s 2s704ms 09 60 55s201ms 920ms 10 60 44s221ms 737ms 11 60 41s163ms 686ms 12 60 1m1s 1s32ms 13 60 44s754ms 745ms 14 60 52s175ms 869ms 15 60 1m4s 1s75ms 16 60 1m14s 1s240ms 17 60 1m4s 1s79ms 18 60 1m6s 1s104ms 19 60 1m5s 1s99ms 20 60 1m5s 1s97ms 21 60 1m28s 1s473ms 22 60 1m39s 1s662ms 23 60 1m43s 1s718ms 00 60 1m45s 1s755ms [ User: monitoring_admin - Total duration: 27m11s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_endpoint ON observability.uptime_checks (endpoint, checked_at DESC);
Date: 2026-05-20 07:50:01 Duration: 11s856ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_endpoint ON observability.uptime_checks (endpoint, checked_at DESC);
Date: 2026-05-20 08:00:01 Duration: 11s832ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_endpoint ON observability.uptime_checks (endpoint, checked_at DESC);
Date: 2026-05-20 22:21:01 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
6 502ms 11s856ms 1s133ms 1,440 27m11s create table if not exists observability.system_metrics ( id bigserial primary key, payload jsonb not null, collected_at timestamptz not null default now() );Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration May 20 01 60 0ms 0ms 02 60 32s760ms 546ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 2m42s 2s704ms 09 60 55s201ms 920ms 10 60 44s221ms 737ms 11 60 41s163ms 686ms 12 60 1m1s 1s32ms 13 60 44s754ms 745ms 14 60 52s175ms 869ms 15 60 1m4s 1s74ms 16 60 1m14s 1s240ms 17 60 1m4s 1s79ms 18 60 1m6s 1s104ms 19 60 1m5s 1s99ms 20 60 1m5s 1s97ms 21 60 1m28s 1s473ms 22 60 1m39s 1s662ms 23 60 1m43s 1s718ms 00 60 1m45s 1s755ms [ User: monitoring_admin - Total duration: 27m11s - 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-05-20 07:50:01 Duration: 11s856ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_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-05-20 08:00:01 Duration: 11s832ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_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-05-20 22:21:01 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
7 502ms 11s856ms 1s133ms 1,440 27m11s 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 #7
Day Hour Count Duration Avg duration May 20 01 60 0ms 0ms 02 60 32s760ms 546ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 2m42s 2s704ms 09 60 55s201ms 920ms 10 60 44s221ms 737ms 11 60 41s163ms 686ms 12 60 1m1s 1s32ms 13 60 44s754ms 745ms 14 60 52s175ms 869ms 15 60 1m4s 1s74ms 16 60 1m14s 1s240ms 17 60 1m4s 1s79ms 18 60 1m6s 1s104ms 19 60 1m5s 1s99ms 20 60 1m5s 1s97ms 21 60 1m28s 1s473ms 22 60 1m39s 1s662ms 23 60 1m43s 1s718ms 00 60 1m45s 1s755ms [ User: monitoring_admin - Total duration: 27m11s - 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-05-20 07:50:01 Duration: 11s856ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_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-05-20 08:00:01 Duration: 11s832ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_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-05-20 22:21:01 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
8 502ms 11s856ms 1s133ms 1,440 27m11s 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 #8
Day Hour Count Duration Avg duration May 20 01 60 0ms 0ms 02 60 32s760ms 546ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 2m42s 2s704ms 09 60 55s201ms 920ms 10 60 44s221ms 737ms 11 60 41s163ms 686ms 12 60 1m1s 1s32ms 13 60 44s754ms 745ms 14 60 52s175ms 869ms 15 60 1m4s 1s74ms 16 60 1m14s 1s240ms 17 60 1m4s 1s79ms 18 60 1m6s 1s104ms 19 60 1m5s 1s99ms 20 60 1m5s 1s97ms 21 60 1m28s 1s473ms 22 60 1m39s 1s662ms 23 60 1m43s 1s718ms 00 60 1m45s 1s755ms [ User: monitoring_admin - Total duration: 27m11s - 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-05-20 07:50:01 Duration: 11s856ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_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-05-20 08:00:01 Duration: 11s832ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_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-05-20 22:21:01 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
9 502ms 11s856ms 1s133ms 1,440 27m11s alter table observability.uptime_checks add column if not exists label text;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration May 20 01 60 0ms 0ms 02 60 32s760ms 546ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 2m42s 2s704ms 09 60 55s201ms 920ms 10 60 44s221ms 737ms 11 60 41s163ms 686ms 12 60 1m1s 1s32ms 13 60 44s754ms 745ms 14 60 52s175ms 869ms 15 60 1m4s 1s74ms 16 60 1m14s 1s240ms 17 60 1m4s 1s79ms 18 60 1m6s 1s104ms 19 60 1m5s 1s99ms 20 60 1m5s 1s97ms 21 60 1m28s 1s473ms 22 60 1m39s 1s662ms 23 60 1m43s 1s718ms 00 60 1m45s 1s755ms [ User: monitoring_admin - Total duration: 27m11s - Times executed: 1349 ]
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS label text;
Date: 2026-05-20 07:50:01 Duration: 11s856ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS label text;
Date: 2026-05-20 08:00:01 Duration: 11s832ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS label text;
Date: 2026-05-20 22:21:01 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
10 502ms 11s856ms 1s133ms 1,440 27m11s create index if not exists idx_app_events_type on observability.app_events (event_type);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration May 20 01 60 0ms 0ms 02 60 32s760ms 546ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 2m42s 2s704ms 09 60 55s201ms 920ms 10 60 44s221ms 737ms 11 60 41s163ms 686ms 12 60 1m1s 1s32ms 13 60 44s754ms 745ms 14 60 52s175ms 869ms 15 60 1m4s 1s74ms 16 60 1m14s 1s240ms 17 60 1m4s 1s79ms 18 60 1m6s 1s104ms 19 60 1m5s 1s99ms 20 60 1m5s 1s97ms 21 60 1m28s 1s473ms 22 60 1m39s 1s662ms 23 60 1m43s 1s718ms 00 60 1m45s 1s755ms [ User: monitoring_admin - Total duration: 27m11s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-05-20 07:50:01 Duration: 11s856ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-05-20 08:00:01 Duration: 11s832ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-05-20 22:21:01 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
11 502ms 11s856ms 1s133ms 1,440 27m11s 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 #11
Day Hour Count Duration Avg duration May 20 01 60 0ms 0ms 02 60 32s760ms 546ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 2m42s 2s704ms 09 60 55s201ms 920ms 10 60 44s221ms 737ms 11 60 41s163ms 686ms 12 60 1m1s 1s32ms 13 60 44s754ms 745ms 14 60 52s175ms 869ms 15 60 1m4s 1s74ms 16 60 1m14s 1s240ms 17 60 1m4s 1s79ms 18 60 1m6s 1s104ms 19 60 1m5s 1s99ms 20 60 1m5s 1s97ms 21 60 1m28s 1s473ms 22 60 1m39s 1s662ms 23 60 1m43s 1s718ms 00 60 1m45s 1s755ms [ User: monitoring_admin - Total duration: 27m11s - 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-05-20 07:50:01 Duration: 11s856ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_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-05-20 08:00:01 Duration: 11s832ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_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-05-20 22:21:01 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
12 502ms 11s856ms 1s133ms 1,440 27m11s create index if not exists idx_metrics_timeseries_bucket on observability.metrics_timeseries (bucket_start);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration May 20 01 60 0ms 0ms 02 60 32s760ms 546ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 2m42s 2s704ms 09 60 55s201ms 920ms 10 60 44s221ms 737ms 11 60 41s163ms 686ms 12 60 1m1s 1s32ms 13 60 44s754ms 745ms 14 60 52s175ms 869ms 15 60 1m4s 1s74ms 16 60 1m14s 1s240ms 17 60 1m4s 1s79ms 18 60 1m6s 1s104ms 19 60 1m5s 1s99ms 20 60 1m5s 1s97ms 21 60 1m28s 1s473ms 22 60 1m39s 1s662ms 23 60 1m43s 1s718ms 00 60 1m45s 1s755ms [ User: monitoring_admin - Total duration: 27m11s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-05-20 07:50:01 Duration: 11s856ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-05-20 08:00:01 Duration: 11s832ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-05-20 22:21:01 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
13 502ms 11s856ms 1s133ms 1,440 27m11s 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 May 20 01 60 0ms 0ms 02 60 32s760ms 546ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 2m42s 2s704ms 09 60 55s201ms 920ms 10 60 44s221ms 737ms 11 60 41s163ms 686ms 12 60 1m1s 1s32ms 13 60 44s754ms 745ms 14 60 52s175ms 869ms 15 60 1m4s 1s74ms 16 60 1m14s 1s240ms 17 60 1m4s 1s79ms 18 60 1m6s 1s104ms 19 60 1m5s 1s99ms 20 60 1m5s 1s97ms 21 60 1m28s 1s473ms 22 60 1m39s 1s662ms 23 60 1m43s 1s718ms 00 60 1m45s 1s755ms [ User: monitoring_admin - Total duration: 27m11s - 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-05-20 07:50:01 Duration: 11s856ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_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-05-20 08:00:01 Duration: 11s832ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_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-05-20 22:21:01 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
14 502ms 11s856ms 1s133ms 1,440 27m11s create index if not exists idx_metrics_timeseries_metric on observability.metrics_timeseries (metric_name);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration May 20 01 60 0ms 0ms 02 60 32s760ms 546ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 2m42s 2s704ms 09 60 55s201ms 920ms 10 60 44s221ms 737ms 11 60 41s163ms 686ms 12 60 1m1s 1s32ms 13 60 44s754ms 745ms 14 60 52s175ms 869ms 15 60 1m4s 1s74ms 16 60 1m14s 1s240ms 17 60 1m4s 1s79ms 18 60 1m6s 1s104ms 19 60 1m5s 1s99ms 20 60 1m5s 1s97ms 21 60 1m28s 1s473ms 22 60 1m39s 1s662ms 23 60 1m43s 1s718ms 00 60 1m45s 1s755ms [ User: monitoring_admin - Total duration: 27m11s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-05-20 07:50:01 Duration: 11s856ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-05-20 08:00:01 Duration: 11s832ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-05-20 22:21:01 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
15 502ms 11s856ms 1s133ms 1,440 27m11s 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 #15
Day Hour Count Duration Avg duration May 20 01 60 0ms 0ms 02 60 32s760ms 546ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 2m42s 2s704ms 09 60 55s201ms 920ms 10 60 44s221ms 737ms 11 60 41s163ms 686ms 12 60 1m1s 1s32ms 13 60 44s754ms 745ms 14 60 52s175ms 869ms 15 60 1m4s 1s74ms 16 60 1m14s 1s240ms 17 60 1m4s 1s79ms 18 60 1m6s 1s104ms 19 60 1m5s 1s99ms 20 60 1m5s 1s97ms 21 60 1m28s 1s473ms 22 60 1m39s 1s662ms 23 60 1m43s 1s718ms 00 60 1m45s 1s755ms [ User: monitoring_admin - Total duration: 27m11s - 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-05-20 07:50:01 Duration: 11s856ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_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-05-20 08:00:01 Duration: 11s832ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_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-05-20 22:21:01 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
16 502ms 11s856ms 1s133ms 1,440 27m11s create schema if not exists observability;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 20 01 60 0ms 0ms 02 60 32s760ms 546ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 2m42s 2s704ms 09 60 55s201ms 920ms 10 60 44s221ms 737ms 11 60 41s163ms 686ms 12 60 1m1s 1s32ms 13 60 44s754ms 745ms 14 60 52s175ms 869ms 15 60 1m4s 1s74ms 16 60 1m14s 1s240ms 17 60 1m4s 1s79ms 18 60 1m6s 1s104ms 19 60 1m5s 1s99ms 20 60 1m5s 1s97ms 21 60 1m28s 1s473ms 22 60 1m39s 1s662ms 23 60 1m43s 1s718ms 00 60 1m45s 1s755ms [ User: monitoring_admin - Total duration: 27m11s - Times executed: 1349 ]
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-05-20 07:50:01 Duration: 11s856ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-05-20 08:00:01 Duration: 11s832ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-05-20 22:21:01 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
17 502ms 11s856ms 1s133ms 1,440 27m11s 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 #17
Day Hour Count Duration Avg duration May 20 01 60 0ms 0ms 02 60 32s760ms 546ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 2m42s 2s704ms 09 60 55s201ms 920ms 10 60 44s221ms 737ms 11 60 41s163ms 686ms 12 60 1m1s 1s32ms 13 60 44s754ms 745ms 14 60 52s175ms 869ms 15 60 1m4s 1s74ms 16 60 1m14s 1s240ms 17 60 1m4s 1s79ms 18 60 1m6s 1s104ms 19 60 1m5s 1s99ms 20 60 1m5s 1s97ms 21 60 1m28s 1s473ms 22 60 1m39s 1s662ms 23 60 1m43s 1s718ms 00 60 1m45s 1s755ms [ User: monitoring_admin - Total duration: 27m11s - 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-05-20 07:50:01 Duration: 11s856ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-05-20 08:00:01 Duration: 11s832ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-05-20 22:21:01 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
18 502ms 11s856ms 1s133ms 1,440 27m11s 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 #18
Day Hour Count Duration Avg duration May 20 01 60 0ms 0ms 02 60 32s760ms 546ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 2m42s 2s704ms 09 60 55s201ms 920ms 10 60 44s221ms 737ms 11 60 41s163ms 686ms 12 60 1m1s 1s32ms 13 60 44s754ms 745ms 14 60 52s175ms 869ms 15 60 1m4s 1s74ms 16 60 1m14s 1s240ms 17 60 1m4s 1s79ms 18 60 1m6s 1s104ms 19 60 1m5s 1s99ms 20 60 1m5s 1s97ms 21 60 1m28s 1s473ms 22 60 1m39s 1s662ms 23 60 1m43s 1s718ms 00 60 1m45s 1s755ms [ User: monitoring_admin - Total duration: 27m11s - 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-05-20 07:50:01 Duration: 11s856ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_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-05-20 08:00:01 Duration: 11s832ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_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-05-20 22:21:01 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
19 502ms 11s856ms 1s133ms 1,440 27m11s create index if not exists idx_app_events_tenant on observability.app_events (tenant_key, occurred_at desc);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration May 20 01 60 0ms 0ms 02 60 32s760ms 546ms 03 60 1m7s 1s129ms 04 60 1m7s 1s129ms 05 60 1m7s 1s129ms 06 60 1m7s 1s129ms 07 60 1m7s 1s129ms 08 60 2m42s 2s704ms 09 60 55s201ms 920ms 10 60 44s221ms 737ms 11 60 41s163ms 686ms 12 60 1m1s 1s32ms 13 60 44s754ms 745ms 14 60 52s175ms 869ms 15 60 1m4s 1s74ms 16 60 1m14s 1s240ms 17 60 1m4s 1s79ms 18 60 1m6s 1s104ms 19 60 1m5s 1s99ms 20 60 1m5s 1s97ms 21 60 1m28s 1s473ms 22 60 1m39s 1s662ms 23 60 1m43s 1s718ms 00 60 1m45s 1s755ms [ User: monitoring_admin - Total duration: 27m11s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-05-20 07:50:01 Duration: 11s856ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-05-20 08:00:01 Duration: 11s832ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-05-20 22:21:01 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
20 708ms 1s468ms 872ms 186 2m42s select distinct on (coalesce(check_key, endpoint) ) check_key, label, endpoint, status, latency_ms, payload, checked_at from observability.uptime_checks order by coalesce(check_key, endpoint), checked_at desc;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 20 08 3 2s244ms 748ms 09 12 8s919ms 743ms 10 12 8s874ms 739ms 11 3 2s198ms 732ms 12 12 8s856ms 738ms 13 12 8s935ms 744ms 14 12 9s59ms 754ms 15 11 8s369ms 760ms 16 13 9s875ms 759ms 17 12 9s280ms 773ms 18 12 9s195ms 766ms 19 12 9s323ms 776ms 20 12 9s371ms 780ms 21 12 12s876ms 1s73ms 22 12 14s315ms 1s192ms 23 12 14s981ms 1s248ms 00 12 15s575ms 1s297ms [ User: monitoring_admin - Total duration: 2m42s - Times executed: 186 ]
-
SELECT DISTINCT ON (COALESCE(check_key, endpoint) ) check_key, label, endpoint, status, latency_ms, payload, checked_at FROM observability.uptime_checks ORDER BY COALESCE(check_key, endpoint), checked_at DESC;
Date: 2026-05-20 23:56:58 Duration: 1s468ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
SELECT DISTINCT ON (COALESCE(check_key, endpoint) ) check_key, label, endpoint, status, latency_ms, payload, checked_at FROM observability.uptime_checks ORDER BY COALESCE(check_key, endpoint), checked_at DESC;
Date: 2026-05-20 23:16:57 Duration: 1s435ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
-
SELECT DISTINCT ON (COALESCE(check_key, endpoint) ) check_key, label, endpoint, status, latency_ms, payload, checked_at FROM observability.uptime_checks ORDER BY COALESCE(check_key, endpoint), checked_at DESC;
Date: 2026-05-20 22:16:53 Duration: 1s396ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-20_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
- 138,627 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 0 FATAL entries
- 4 ERROR entries
- 0 WARNING entries
- 0 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 3 Max number of times the same event was reported
- 4 Total events found
Rank Times reported Error 1 3 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #1
Day Hour Count May 20 17 3 - ERROR: syntax error at or near "lebend"
- ERROR: syntax error at or near "lebend"
- ERROR: syntax error at or near "lebend"
Statement: INSERT INTO tmptasks VALUES( 10312606,0,true,true,true,'574','','','','10100206,10100205','','','','','','','',NULL,'Re-Homing von Zebrafischen',0,0,NULL,'','',NULL,false,'2026-05-20','','Zebrabärblinge der Linie Tüpfel longfin (TL-1), genetisch nicht veränderte Wildtypen, wurden am 20.05.2026 in private Hände im Zuge eines Rehomings lebend abgegeben. Tiere als 'lebend verlassen' (oder ähnliches) aus dem FBI austragen.','',NULL,NULL,true,$1,'2',2,0,2,NULL::TIMESTAMP, NULL, NULL::TIMESTAMP, NULL)
Date: 2026-05-20 16:25:05 Database: zemm_produktiv_8 Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
Statement: INSERT INTO tmptasks VALUES( 10312607,0,true,true,true,'574','','','','10100206,10100205','10100026','','','','','','',NULL,'Re-Homing von Zebrafischen',0,0,NULL,'','',NULL,false,'2026-05-20','','Zebrabärblinge der Linie Tüpfel longfin (TL-1), genetisch nicht veränderte Wildtypen, wurden am 20.05.2026 in private Hände im Zuge eines Rehomings lebend abgegeben. Tiere als 'lebend verlassen' (oder ähnliches) aus dem FBI austragen.','',NULL,NULL,true,$1,'2',2,0,2,NULL::TIMESTAMP, NULL, NULL::TIMESTAMP, NULL)
Date: 2026-05-20 16:25:31 Database: zemm_produktiv_8 Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
Statement: INSERT INTO tmptasks VALUES( 10312608,0,true,true,true,'574','127','','','10100206,10100205','10100026','','','','','','',NULL,'Re-Homing von Zebrafischen',0,0,NULL,'','',NULL,false,'2026-05-21','','Zebrabärblinge der Linie Tüpfel longfin (TL-1), genetisch nicht veränderte Wildtypen, wurden am 20.05.2026 in private Hände im Zuge eines Rehomings lebend abgegeben. Tiere als 'lebend verlassen' (oder ähnliches) aus dem FBI austragen.','',NULL,NULL,true,$1,'2',2,0,2,NULL::TIMESTAMP, NULL, NULL::TIMESTAMP, NULL)
Date: 2026-05-20 16:27:09 Database: zemm_produktiv_8 Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv
2 1 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count May 20 17 1 - ERROR: column "idle" does not exist
Statement: SELECT current_database(), version(); SELECT pid, state, wait_event_type, now() - query_start AS age, left(query,80) FROM pg_stat_activity WHERE state <> idle ORDER BY query_start;
Date: 2026-05-20 16:02:08 Database: zemm_produktiv_8 Application: psql User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-05-20_000000.csv