pgBadger-
Global information
- Generated on Sat May 30 23:50:04 2026
- Log file: /usr/local/pgsql/data/log/serverlog-04.log, ..., /usr/local/pgsql/data/log/serverlog-30.log
- Parsed 13,325 log entries in 3s
- Log start from 2026-05-30 00:00:30 to 2026-05-30 23:49:28
-
Overview
Global Stats
- 153 Number of unique normalized queries
- 730 Number of queries
- 2h31m3s Total query duration
- 2026-05-30 00:02:13 First query
- 2026-05-30 23:45:02 Last query
- 5 queries/s at 2026-05-30 23:41:46 Query peak
- 2h31m3s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 2h31m3s Execute total duration
- 1,934 Number of events
- 7 Number of unique normalized events
- 1,503 Max number of times the same event was reported
- 0 Number of cancellation
- 33 Total number of automatic vacuums
- 72 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 176 Total number of sessions
- 5 sessions at 2026-05-30 09:05:01 Session peak
- 6d17h3m43s Total duration of sessions
- 54m54s Average duration of sessions
- 4 Average queries per session
- 51s499ms Average queries duration per session
- 54m2s Average idle time per session
- 596 Total number of connections
- 4 connections/s at 2026-05-30 23:45:02 Connection peak
- 2 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-05-30 23:41:46 Date
SELECT Traffic
Key values
- 3 queries/s Query Peak
- 2026-05-30 23:10:02 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-05-30 23:41:46 Date
Queries duration
Key values
- 2h31m3s 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 30 00 18 0ms 19s393ms 5s89ms 3s766ms 4s727ms 56s646ms 01 12 0ms 3s912ms 2s70ms 3s307ms 3s804ms 6s509ms 02 12 0ms 2s672ms 1s643ms 2s756ms 3s265ms 3s908ms 03 16 0ms 3s486ms 1s445ms 2s655ms 3s691ms 4s886ms 04 35 0ms 2s452ms 743ms 2s700ms 3s948ms 4s343ms 05 23 0ms 7m12s 25s361ms 3s169ms 6s959ms 7m12s 06 10 0ms 9s381ms 4s257ms 2s220ms 2s698ms 17s891ms 07 17 0ms 7m14s 30s595ms 2s374ms 16s431ms 7m14s 08 16 0ms 5m12s 22s646ms 2s412ms 2s738ms 5m39s 09 39 0ms 5m31s 10s96ms 2s452ms 2s859ms 5m58s 10 24 0ms 5m2s 14s758ms 2s270ms 2s662ms 5m33s 11 39 0ms 5m14s 9s514ms 2s636ms 3s99ms 5m41s 12 13 0ms 5m2s 26s761ms 2s410ms 2s595ms 5m29s 13 40 0ms 5m10s 9s234ms 2s206ms 3s373ms 5m40s 14 27 0ms 5m4s 13s71ms 2s191ms 2s446ms 5m32s 15 13 0ms 5m5s 26s918ms 2s165ms 2s249ms 5m33s 16 13 0ms 4m56s 26s113ms 2s197ms 2s478ms 4m56s 17 13 0ms 5m33s 29s372ms 2s514ms 3s15ms 5m33s 18 14 0ms 5m8s 25s251ms 2s203ms 2s493ms 5m35s 19 13 0ms 4m55s 26s112ms 2s314ms 2s660ms 4m55s 20 65 0ms 5m1s 11s788ms 48s407ms 1m32s 5m29s 21 13 0ms 5m2s 26s727ms 2s209ms 2s434ms 5m30s 22 13 0ms 5m16s 28s367ms 2s487ms 3s232ms 5m42s 23 232 0ms 1m48s 8s337ms 1m16s 1m31s 1m51s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 30 00 4 0 3s891ms 0ms 0ms 942ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 4 0 333ms 0ms 0ms 240ms 04 23 0 221ms 179ms 208ms 425ms 05 9 0 392ms 0ms 188ms 915ms 06 2 0 6s298ms 0ms 0ms 0ms 07 10 0 50s512ms 0ms 0ms 53s460ms 08 6 0 56s732ms 0ms 0ms 866ms 09 25 0 14s890ms 468ms 862ms 2s682ms 10 15 0 22s482ms 0ms 339ms 934ms 11 30 0 11s725ms 397ms 568ms 1s645ms 12 4 0 1m22s 0ms 0ms 0ms 13 28 0 12s450ms 429ms 659ms 856ms 14 18 0 18s681ms 0ms 430ms 941ms 15 4 0 1m23s 0ms 0ms 0ms 16 4 0 1m20s 0ms 0ms 26s615ms 17 4 0 1m30s 0ms 0ms 29s137ms 18 5 0 1m7s 0ms 0ms 384ms 19 4 0 1m20s 0ms 0ms 27s44ms 20 6 50 13s374ms 0ms 48s407ms 2m3s 21 4 0 1m22s 0ms 0ms 0ms 22 4 0 1m26s 0ms 0ms 1s715ms 23 12 220 8s337ms 1m6s 1m16s 1m51s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 30 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 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 30 00 0 1 1.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 1 1.00 0.00% 04 0 1 1.00 0.00% 05 0 3 3.00 0.00% 06 0 0 0.00 0.00% 07 0 2 2.00 0.00% 08 0 1 1.00 0.00% 09 0 2 2.00 0.00% 10 0 1 1.00 0.00% 11 0 2 2.00 0.00% 12 0 0 0.00 0.00% 13 0 2 2.00 0.00% 14 0 2 2.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 3 3.00 0.00% Day Hour Count Average / Second May 30 00 25 0.01/s 01 19 0.01/s 02 19 0.01/s 03 27 0.01/s 04 21 0.01/s 05 27 0.01/s 06 24 0.01/s 07 25 0.01/s 08 27 0.01/s 09 30 0.01/s 10 27 0.01/s 11 29 0.01/s 12 24 0.01/s 13 29 0.01/s 14 28 0.01/s 15 24 0.01/s 16 25 0.01/s 17 26 0.01/s 18 26 0.01/s 19 25 0.01/s 20 28 0.01/s 21 25 0.01/s 22 25 0.01/s 23 11 0.00/s Day Hour Count Average Duration Average idle time May 30 00 5 54m 53m41s 01 9 1h40s 1h37s 02 5 1h 59m56s 03 10 16m17s 16m15s 04 7 1h2m46s 1h2m42s 05 6 51m58s 50m21s 06 7 1h26s 1h19s 07 9 55m6s 54m9s 08 8 59m7s 58m22s 09 8 53m45s 52m56s 10 10 1h2m18s 1h1m43s 11 8 56m15s 55m28s 12 10 1h30s 59m55s 13 5 1h1s 58m47s 14 10 1h2m18s 1h1m43s 15 9 1h54s 1h15s 16 6 51m40s 50m43s 17 5 1h 58m43s 18 7 53m17s 52m26s 19 6 51m40s 50m43s 20 7 43m9s 41m20s 21 6 1h1m20s 1h22s 22 5 1h 58m46s 23 8 49m47s 45m45s -
Connections
Established Connections
Key values
- 4 connections Connection Peak
- 2026-05-30 23:45:02 Date
Connections per database
Key values
- brasilia Main Database
- 596 connections Total
Connections per user
Key values
- intelifix Main User
- 596 connections Total
-
Sessions
Simultaneous sessions
Key values
- 5 sessions Session Peak
- 2026-05-30 09:05:01 Date
Histogram of session times
Key values
- 151 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 176 sessions Total
Sessions per user
Key values
- intelifix Main User
- 176 sessions Total
Sessions per host
Key values
- [local] Main Host
- 176 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 9,235 buffers Checkpoint Peak
- 2026-05-30 00:19:44 Date
- 269.942 seconds Highest write time
- 0.010 seconds Sync time
Checkpoints Wal files
Key values
- 3 files Wal files usage Peak
- 2026-05-30 00:19:44 Date
Checkpoints distance
Key values
- 110.20 Mo Distance Peak
- 2026-05-30 00:19:44 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time May 30 00 16,977 670.147s 0.014s 670.197s 01 1,634 164.088s 0.024s 164.147s 02 1,334 133.965s 0.023s 134.013s 03 2,317 232.278s 0.025s 232.338s 04 4,553 456.703s 0.032s 456.778s 05 8,016 786.304s 0.039s 786.381s 06 5,028 269.668s 0.001s 269.675s 07 1,137 114.111s 0.011s 114.139s 08 97 9.749s 0.002s 9.755s 09 3,477 349.836s 0.056s 349.94s 10 2,200 220.927s 0.033s 220.992s 11 3,520 353.611s 0.058s 353.713s 12 62 6.331s 0.013s 6.368s 13 3,199 321.012s 0.042s 321.11s 14 1,936 194.232s 0.024s 194.287s 15 28 2.847s 0.005s 2.86s 16 21 2.136s 0.005s 2.148s 17 21 2.128s 0.003s 2.134s 18 194 19.523s 0.008s 19.541s 19 27 2.738s 0.005s 2.751s 20 565 56.72s 0.006s 56.74s 21 82 8.308s 0.009s 8.331s 22 23 2.347s 0.004s 2.359s 23 131 13.216s 0.012s 13.244s Day Hour Added Removed Recycled Synced files Longest sync Average sync May 30 00 0 0 6 470 0.003s 0.006s 01 0 0 0 431 0.004s 0.01s 02 0 0 1 396 0.003s 0.006s 03 0 0 0 400 0.003s 0.009s 04 0 0 2 731 0.002s 0.011s 05 0 0 3 922 0.004s 0.009s 06 0 0 1 9 0.001s 0.001s 07 0 0 0 69 0.003s 0.006s 08 0 0 0 5 0.001s 0.001s 09 0 0 1 1,509 0.003s 0.012s 10 0 0 1 956 0.002s 0.008s 11 0 0 1 1,481 0.004s 0.01s 12 0 0 0 38 0.002s 0.009s 13 0 0 1 1,107 0.003s 0.011s 14 0 0 1 700 0.003s 0.008s 15 0 0 0 9 0.002s 0.002s 16 0 0 0 5 0.002s 0.002s 17 0 0 0 3 0.002s 0.001s 18 0 0 0 28 0.002s 0.003s 19 0 0 0 6 0.002s 0.003s 20 0 0 0 38 0.002s 0.003s 21 0 0 0 30 0.002s 0.004s 22 0 0 0 6 0.002s 0.002s 23 0 0 0 63 0.003s 0.005s Day Hour Count Avg time (sec) May 30 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 30 00 16,646.50 kB 44,855.83 kB 01 1,032.88 kB 24,441.75 kB 02 1,086.17 kB 12,099.50 kB 03 1,245.33 kB 2,924.56 kB 04 2,123.00 kB 3,306.73 kB 05 6,441.56 kB 19,298.78 kB 06 11,041.00 kB 14,423.00 kB 07 1,187.40 kB 11,075.20 kB 08 252.00 kB 8,062.00 kB 09 1,407.75 kB 4,972.33 kB 10 1,252.62 kB 2,576.75 kB 11 1,747.00 kB 2,508.50 kB 12 48.00 kB 1,660.00 kB 13 1,533.73 kB 1,944.64 kB 14 1,078.38 kB 1,997.75 kB 15 87.50 kB 2,277.50 kB 16 81.00 kB 1,863.50 kB 17 159.00 kB 1,607.00 kB 18 430.33 kB 1,413.00 kB 19 87.50 kB 1,109.00 kB 20 477.67 kB 954.67 kB 21 72.50 kB 709.50 kB 22 82.00 kB 531.00 kB 23 315.75 kB 609.00 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 30 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
- 0.32 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database rio - 2026-05-30 05:07:49 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 0.32 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database rio - 2026-05-30 05:07:49 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (18) Main table analyzed (database contagem)
- 72 analyzes Total
Table Number of analyzes contagem.pg_catalog.pg_attribute 18 contagem.pg_catalog.pg_class 13 contagem.pg_catalog.pg_type 10 rio.public.temp0000281309 7 contagem.pg_catalog.pg_index 6 contagem.public.temp0000226296 5 contagem.pg_catalog.pg_depend 4 rio.public.temp0000281307 3 contagem.public.usuarios 3 rio.pg_catalog.pg_attribute 1 rio.pg_catalog.pg_class 1 contagem.pg_catalog.pg_shdepend 1 Total 72 Vacuums per table
Key values
- pg_catalog.pg_attribute (6) Main table vacuumed on database contagem
- 33 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples contagem.pg_catalog.pg_attribute 6 6 0 0 0 0 0 3,513 1,200 2,053,974 1 50 contagem.public.temp0000226296 5 0 0 0 0 0 0 257 30 19,372 0 0 contagem.pg_catalog.pg_class 4 4 0 0 0 0 0 475 173 247,403 2 4 contagem.pg_catalog.pg_type 3 3 0 0 0 0 0 155 67 93,302 0 0 rio.public.logs 3 0 0 0 0 0 0 570 283 355,972 125 3,121 contagem.public.usuarios 2 0 0 0 0 0 0 6 4 3,428 0 0 contagem.pg_catalog.pg_depend 2 2 0 0 0 0 0 415 154 320,419 0 0 contagem.pg_catalog.pg_index 1 1 0 0 0 0 0 23 15 12,249 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 133 2 10,507 0 0 rio.pg_catalog.pg_statistic 1 1 0 0 0 0 0 4,148 874 3,576,415 729 4,443 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,660 5 179,012 0 0 rio.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 789 162 724,335 74 334 rio.pg_catalog.pg_attribute 1 1 0 0 0 0 0 722 254 223,577 0 0 rio.pg_catalog.pg_depend 1 1 0 0 0 0 0 607 219 248,417 1 6 template1.pg_catalog.pg_shdepend 1 1 0 0 0 0 0 232 85 101,876 4 4 Total 33 23 0 0 0 0 0 14,705 3,527 8,170,258 936 7,962 Vacuum throughput per table
Key values
- pg_catalog.pg_attribute (0.42) Max CPU elapsed for vacuum on database contagem
- unknown (0 ms) Max I/O read time for vacuum on database contagem
- unknown (0 ms) Max I/O write time for vacuum on database contagem
I/O timing (ms) CPU (s) Table read write elapsed contagem.pg_catalog.pg_attribute 0 0 0.42 contagem.public.temp0000226296 0 0 0.05 contagem.pg_catalog.pg_class 0 0 0.05 contagem.pg_catalog.pg_type 0 0 0.02 rio.public.logs 0 0 0.25 contagem.public.usuarios 0 0 0 contagem.pg_catalog.pg_depend 0 0 0.07 contagem.pg_catalog.pg_index 0 0 0.02 contagem.pg_toast.pg_toast_2619 0 0 0 rio.pg_catalog.pg_statistic 0 0 0.32 contagem.pg_catalog.pg_statistic 0 0 0.04 rio.pg_toast.pg_toast_2619 0 0 0.03 rio.pg_catalog.pg_attribute 0 0 0.12 rio.pg_catalog.pg_depend 0 0 0.13 template1.pg_catalog.pg_shdepend 0 0 0.03 Total 0 0 1.55 Tuples removed per table
Key values
- pg_catalog.pg_attribute (16078) Main table with removed tuples on database contagem
- 32211 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain contagem.pg_catalog.pg_attribute 6 6 16,078 142,602 0 0 3,120 rio.pg_catalog.pg_statistic 1 1 4,491 7,492 0 0 1,286 contagem.pg_catalog.pg_statistic 1 1 4,013 7,274 0 0 1,011 rio.pg_catalog.pg_attribute 1 1 2,127 19,567 0 111 508 rio.pg_catalog.pg_depend 1 1 1,843 18,885 0 0 180 template1.pg_catalog.pg_shdepend 1 1 1,150 9,224 0 0 101 contagem.pg_catalog.pg_depend 2 2 993 37,718 0 0 346 rio.pg_toast.pg_toast_2619 1 1 616 675 0 0 274 contagem.pg_catalog.pg_class 4 4 521 13,377 0 0 456 contagem.pg_catalog.pg_type 3 3 131 6,723 0 6 180 contagem.public.usuarios 2 0 114 42 0 0 4 contagem.pg_toast.pg_toast_2619 1 1 109 111 0 0 54 contagem.pg_catalog.pg_index 1 1 25 1,837 0 0 45 contagem.public.temp0000226296 5 0 0 5,732 0 103 217 rio.public.logs 3 0 0 47,304,682 0 0 1,890,070 Total 33 23 32,211 47,575,941 0 220 1,897,852 Pages removed per table
Key values
- pg_catalog.pg_attribute (111) Main table with removed pages on database rio
- 220 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.pg_catalog.pg_attribute 1 1 2127 111 contagem.public.temp0000226296 5 0 0 103 contagem.pg_catalog.pg_type 3 3 131 6 contagem.pg_catalog.pg_attribute 6 6 16078 0 contagem.public.usuarios 2 0 114 0 contagem.pg_catalog.pg_index 1 1 25 0 contagem.pg_toast.pg_toast_2619 1 1 109 0 contagem.pg_catalog.pg_class 4 4 521 0 rio.pg_catalog.pg_statistic 1 1 4491 0 contagem.pg_catalog.pg_statistic 1 1 4013 0 rio.public.logs 3 0 0 0 rio.pg_toast.pg_toast_2619 1 1 616 0 rio.pg_catalog.pg_depend 1 1 1843 0 template1.pg_catalog.pg_shdepend 1 1 1150 0 contagem.pg_catalog.pg_depend 2 2 993 0 Total 33 23 32,211 220 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs May 30 00 0 0 01 0 0 02 0 0 03 0 0 04 0 4 05 6 7 06 0 0 07 0 0 08 1 0 09 7 9 10 1 8 11 5 17 12 0 0 13 8 18 14 4 8 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 1 0 21 0 0 22 0 0 23 0 1 - 0.32 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 225 Total read queries
- 281 Total write queries
Queries by database
Key values
- rio Main database
- 459 Requests
- 2h24m29s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 704 Requests
User Request type Count Duration etiquetas Total 4 1s202ms select 4 1s202ms intelifix Total 704 2h30m28s copy to 270 39m9s ddl 11 10s215ms others 224 17m38s select 199 1h33m29s lenon Total 22 34s378ms select 22 34s378ms Duration by user
Key values
- 2h30m28s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 4 1s202ms select 4 1s202ms intelifix Total 704 2h30m28s copy to 270 39m9s ddl 11 10s215ms others 224 17m38s select 199 1h33m29s lenon Total 22 34s378ms select 22 34s378ms Queries by host
Key values
- [local] Main host
- 730 Requests
- 2h31m3s ([local])
- Main time consuming host
Queries by application
Key values
- psql Main application
- 295 Requests
- 1h50m30s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-05-30 17:09:31 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 248 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 7m14s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-30 07:12:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 7m12s analyze verbose;[ Date: 2026-05-30 05:07:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 5m33s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-30 17:10:34 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 5m31s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-30 09:10:32 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 5m16s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-30 22:10:18 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 5m14s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-30 11:10:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 5m12s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-30 08:10:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 5m10s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-30 13:10:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 5m8s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-30 18:10:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 5m5s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-30 15:10:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 5m4s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-30 14:10:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m2s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-30 21:10:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 5m2s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-30 10:10:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m2s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-30 12:10:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m1s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-30 20:10:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 4m56s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-30 16:09:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 4m55s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-30 19:09:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 2m3s analyze verbose;[ Date: 2026-05-30 05:09:17 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
19 1m48s COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;[ Date: 2026-05-30 23:15:55 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
20 1m36s COPY auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;[ Date: 2026-05-30 23:12:50 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1h24m52s 32 877ms 7m14s 2m39s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 30 07 2 7m17s 3m38s 08 2 5m13s 2m36s 09 2 5m32s 2m46s 10 2 5m5s 2m32s 11 2 5m15s 2m37s 12 2 5m2s 2m31s 13 2 5m11s 2m35s 14 2 5m5s 2m32s 15 2 5m6s 2m33s 16 2 4m57s 2m28s 17 2 5m34s 2m47s 18 2 5m9s 2m34s 19 2 4m56s 2m28s 20 2 5m2s 2m31s 21 2 5m4s 2m32s 22 2 5m17s 2m38s [ User: intelifix - Total duration: 1h24m52s - Times executed: 32 ]
[ Application: psql - Total duration: 1h24m52s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-30 07:12:15 Duration: 7m14s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-30 17:10:34 Duration: 5m33s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-30 09:10:32 Duration: 5m31s Database: rio User: intelifix Remote: [local] Application: psql
2 9m15s 2 2m3s 7m12s 4m37s analyze verbose;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 30 05 2 9m15s 4m37s [ User: intelifix - Total duration: 9m15s - Times executed: 2 ]
[ Application: psql - Total duration: 9m15s - Times executed: 2 ]
-
analyze verbose;
Date: 2026-05-30 05:07:13 Duration: 7m12s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-05-30 05:09:17 Duration: 2m3s Database: contagem User: intelifix Remote: [local] Application: psql
3 7m30s 32 405ms 49s539ms 14s83ms select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 30 07 2 50s789ms 25s394ms 08 2 26s14ms 13s7ms 09 2 26s733ms 13s366ms 10 2 27s732ms 13s866ms 11 2 26s274ms 13s137ms 12 2 27s30ms 13s515ms 13 2 27s504ms 13s752ms 14 2 25s997ms 12s998ms 15 2 26s888ms 13s444ms 16 2 25s570ms 12s785ms 17 2 28s87ms 14s43ms 18 2 26s259ms 13s129ms 19 2 25s858ms 12s929ms 20 2 27s223ms 13s611ms 21 2 26s437ms 13s218ms 22 2 26s260ms 13s130ms [ User: intelifix - Total duration: 7m30s - Times executed: 32 ]
[ Application: psql - Total duration: 7m30s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-30 07:13:05 Duration: 49s539ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-30 17:11:02 Duration: 27s436ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-30 10:10:30 Duration: 27s111ms Database: rio User: intelifix Remote: [local] Application: psql
4 5m42s 138 2s49ms 7s525ms 2s484ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration May 30 00 6 20s217ms 3s369ms 01 6 17s450ms 2s908ms 02 6 14s841ms 2s473ms 03 6 14s921ms 2s486ms 04 6 13s782ms 2s297ms 05 6 14s204ms 2s367ms 06 6 14s504ms 2s417ms 07 6 14s532ms 2s422ms 08 6 15s2ms 2s500ms 09 6 15s42ms 2s507ms 10 6 14s386ms 2s397ms 11 6 15s556ms 2s592ms 12 6 15s103ms 2s517ms 13 6 14s180ms 2s363ms 14 6 13s892ms 2s315ms 15 6 13s406ms 2s234ms 16 6 13s387ms 2s231ms 17 6 15s932ms 2s655ms 18 6 14s496ms 2s416ms 19 6 13s882ms 2s313ms 20 6 14s432ms 2s405ms 21 6 14s47ms 2s341ms 22 6 15s720ms 2s620ms [ User: intelifix - Total duration: 5m42s - Times executed: 138 ]
[ Application: psql - Total duration: 5m42s - Times executed: 138 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-30 00:05:20 Duration: 7s525ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-30 01:35:08 Duration: 3s912ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-30 03:05:20 Duration: 3s486ms Database: rio User: intelifix Remote: [local] Application: psql
5 2m50s 2 1m21s 1m28s 1m25s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration May 30 20 1 1m21s 1m21s 23 1 1m28s 1m28s [ User: intelifix - Total duration: 2m50s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m50s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-30 23:39:43 Duration: 1m28s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-30 20:08:14 Duration: 1m21s Database: rio User: intelifix Remote: [local] Application: pg_dump
6 2m10s 2 22s2ms 1m48s 1m5s copy auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration May 30 23 2 2m10s 1m5s [ User: intelifix - Total duration: 2m10s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m10s - Times executed: 2 ]
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-30 23:15:55 Duration: 1m48s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-30 23:41:26 Duration: 22s2ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
7 1m55s 2 19s222ms 1m36s 57s929ms copy auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration May 30 23 2 1m55s 57s929ms [ User: intelifix - Total duration: 1m55s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m55s - Times executed: 2 ]
-
COPY auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-30 23:12:50 Duration: 1m36s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-30 23:40:46 Duration: 19s222ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
8 1m55s 2 57s395ms 57s680ms 57s537ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration May 30 20 1 57s680ms 57s680ms 23 1 57s395ms 57s395ms [ User: intelifix - Total duration: 1m55s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m55s - Times executed: 2 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-30 20:05:19 Duration: 57s680ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-30 23:19:11 Duration: 57s395ms Database: rio User: intelifix Remote: [local] Application: pg_dump
9 1m34s 2 17s685ms 1m16s 47s226ms copy auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration May 30 23 2 1m34s 47s226ms [ User: intelifix - Total duration: 1m34s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m34s - Times executed: 2 ]
-
COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-30 23:14:07 Duration: 1m16s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-30 23:41:04 Duration: 17s685ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
10 1m25s 2 15s442ms 1m9s 42s704ms copy auditor.auditor_2026_02 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration May 30 23 2 1m25s 42s704ms [ User: intelifix - Total duration: 1m25s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m25s - Times executed: 2 ]
-
COPY auditor.auditor_2026_02 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-30 23:11:14 Duration: 1m9s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_02 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-30 23:40:27 Duration: 15s442ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
11 1m2s 4 2s182ms 29s564ms 15s629ms copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration May 30 20 2 30s668ms 15s334ms 23 2 31s849ms 15s924ms [ User: intelifix - Total duration: 1m2s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m2s - Times executed: 4 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-05-30 23:19:42 Duration: 29s564ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-05-30 20:05:48 Duration: 28s485ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-05-30 23:41:42 Duration: 2s285ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
12 57s16ms 4 1s564ms 27s309ms 14s254ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration May 30 20 2 28s142ms 14s71ms 23 2 28s873ms 14s436ms [ User: intelifix - Total duration: 57s16ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 57s16ms - Times executed: 4 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-30 23:20:13 Duration: 27s309ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-30 20:06:18 Duration: 26s524ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-30 20:08:58 Duration: 1s617ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
13 55s294ms 4 2s672ms 25s298ms 13s823ms copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration May 30 20 2 27s323ms 13s661ms 23 2 27s971ms 13s985ms [ User: intelifix - Total duration: 55s294ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 55s294ms - Times executed: 4 ]
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-05-30 23:40:08 Duration: 25s298ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-05-30 20:08:38 Duration: 24s178ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-05-30 20:09:05 Duration: 3s144ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
14 53s599ms 34 310ms 11s116ms 1s576ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration May 30 00 6 17s831ms 2s971ms 01 6 7s390ms 1s231ms 02 6 4s879ms 813ms 03 5 6s657ms 1s331ms 04 6 7s143ms 1s190ms 05 5 9s697ms 1s939ms [ User: intelifix - Total duration: 53s599ms - Times executed: 34 ]
[ Application: psql - Total duration: 53s599ms - Times executed: 34 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-05-30 00:05:12 Duration: 11s116ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-05-30 05:05:05 Duration: 3s944ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-05-30 05:15:04 Duration: 3s819ms Database: rio User: intelifix Remote: [local] Application: psql
15 53s476ms 4 7s642ms 19s393ms 13s369ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration May 30 00 2 38s4ms 19s2ms 06 2 15s471ms 7s735ms [ User: intelifix - Total duration: 53s476ms - Times executed: 4 ]
[ Application: psql - Total duration: 53s476ms - Times executed: 4 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-05-30 00:05:21 Duration: 19s393ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-05-30 00:05:54 Duration: 18s611ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-05-30 06:05:24 Duration: 7s829ms Database: contagem User: intelifix Remote: [local] Application: psql
16 52s717ms 45 711ms 6s943ms 1s171ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 30 08 3 4s149ms 1s383ms 09 3 3s309ms 1s103ms 10 3 2s574ms 858ms 11 3 3s763ms 1s254ms 12 3 2s809ms 936ms 13 3 2s947ms 982ms 14 3 2s764ms 921ms 15 3 3s174ms 1s58ms 16 3 2s799ms 933ms 17 3 3s316ms 1s105ms 18 3 3s37ms 1s12ms 19 3 3s329ms 1s109ms 20 3 2s810ms 936ms 21 3 2s925ms 975ms 22 3 9s3ms 3s1ms [ User: intelifix - Total duration: 52s717ms - Times executed: 45 ]
[ Application: psql - Total duration: 52s717ms - Times executed: 45 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-05-30 22:40:08 Duration: 6s943ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-05-30 11:20:03 Duration: 2s111ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-05-30 08:00:03 Duration: 1s791ms Database: rio User: intelifix Remote: [local] Application: psql
17 43s207ms 4 1s119ms 20s566ms 10s801ms copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration May 30 20 2 21s686ms 10s843ms 23 2 21s521ms 10s760ms [ User: intelifix - Total duration: 43s207ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 43s207ms - Times executed: 4 ]
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-05-30 20:04:03 Duration: 20s566ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-05-30 23:17:57 Duration: 20s308ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-05-30 23:41:39 Duration: 1s212ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
18 39s667ms 4 1s572ms 18s225ms 9s916ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 30 20 2 19s498ms 9s749ms 23 2 20s169ms 10s84ms [ User: intelifix - Total duration: 39s667ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 39s667ms - Times executed: 4 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-30 23:16:33 Duration: 18s225ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-30 20:02:39 Duration: 17s925ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-30 23:41:33 Duration: 1s944ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
19 39s410ms 4 1s434ms 18s468ms 9s852ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration May 30 20 2 19s508ms 9s754ms 23 2 19s902ms 9s951ms [ User: intelifix - Total duration: 39s410ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 39s410ms - Times executed: 4 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-30 23:17:05 Duration: 18s468ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-30 20:03:12 Duration: 18s51ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-30 20:08:50 Duration: 1s457ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
20 34s873ms 2 16s766ms 18s106ms 17s436ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 30 20 1 18s106ms 18s106ms 23 1 16s766ms 16s766ms [ User: intelifix - Total duration: 34s873ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 34s873ms - Times executed: 2 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-05-30 20:04:21 Duration: 18s106ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-05-30 23:18:14 Duration: 16s766ms Database: rio User: intelifix Remote: [local] Application: pg_dump
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 138 5m42s 2s49ms 7s525ms 2s484ms call rs_giga_triagem (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 30 00 6 20s217ms 3s369ms 01 6 17s450ms 2s908ms 02 6 14s841ms 2s473ms 03 6 14s921ms 2s486ms 04 6 13s782ms 2s297ms 05 6 14s204ms 2s367ms 06 6 14s504ms 2s417ms 07 6 14s532ms 2s422ms 08 6 15s2ms 2s500ms 09 6 15s42ms 2s507ms 10 6 14s386ms 2s397ms 11 6 15s556ms 2s592ms 12 6 15s103ms 2s517ms 13 6 14s180ms 2s363ms 14 6 13s892ms 2s315ms 15 6 13s406ms 2s234ms 16 6 13s387ms 2s231ms 17 6 15s932ms 2s655ms 18 6 14s496ms 2s416ms 19 6 13s882ms 2s313ms 20 6 14s432ms 2s405ms 21 6 14s47ms 2s341ms 22 6 15s720ms 2s620ms [ User: intelifix - Total duration: 5m42s - Times executed: 138 ]
[ Application: psql - Total duration: 5m42s - Times executed: 138 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-30 00:05:20 Duration: 7s525ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-30 01:35:08 Duration: 3s912ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-30 03:05:20 Duration: 3s486ms Database: rio User: intelifix Remote: [local] Application: psql
2 74 33s711ms 151ms 2s323ms 455ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 30 09 15 10s789ms 719ms 10 9 3s269ms 363ms 11 20 8s354ms 417ms 13 20 8s343ms 417ms 14 10 2s954ms 295ms [ User: intelifix - Total duration: 33s711ms - Times executed: 74 ]
[ Application: [unknown] - Total duration: 33s711ms - Times executed: 74 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (39641, 407, '919071184094,981E19B0C16E,A86ABBC95E25,A86ABBD094D8,3093BCB7E804,981E19B0B8B5,F08175279C5E,ECBEDDBA4EDB,D06EDE98AE46,ECBEDDADF85E,B866851AC1A1,B866851D32FD,F8084F7A6B12', '',0129,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""}]','$$$$$$$$$$$','', 00);
Date: 2026-05-30 09:03:22 Duration: 2s323ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (39654, 407, '733079091555,B4F26761FD73,B4F26736E15E,B4F2676C38CD,B4F267636648,B4F267636618,B4F26769C765', '',0300,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""}]','$$$$$','', 00);
Date: 2026-05-30 10:03:54 Duration: 934ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (39662, 407, 'ZTE3ANNR4N17861,4896D956FDB6,4896D956FDB7,ZTEGD97F658A$ZTE3ANNRCP00125,6C11BA692DBD,6C11BA692DBE,ZTEGDC6F4110$ZTE3ANNR8C28029,3891485117F5,3891485117F6,ZTEGDB08EDED$ZTE3ANNT3H23751,D8313998F042,D8313998F043,ZTEGDD322D66$ZTE3ANNRCP76400,6C11BA70296F,6C11BA702970,ZTEGDC706B03', '',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""}]','$$$$','', 00);
Date: 2026-05-30 09:15:25 Duration: 865ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
3 45 52s717ms 711ms 6s943ms 1s171ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 30 08 3 4s149ms 1s383ms 09 3 3s309ms 1s103ms 10 3 2s574ms 858ms 11 3 3s763ms 1s254ms 12 3 2s809ms 936ms 13 3 2s947ms 982ms 14 3 2s764ms 921ms 15 3 3s174ms 1s58ms 16 3 2s799ms 933ms 17 3 3s316ms 1s105ms 18 3 3s37ms 1s12ms 19 3 3s329ms 1s109ms 20 3 2s810ms 936ms 21 3 2s925ms 975ms 22 3 9s3ms 3s1ms [ User: intelifix - Total duration: 52s717ms - Times executed: 45 ]
[ Application: psql - Total duration: 52s717ms - Times executed: 45 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-05-30 22:40:08 Duration: 6s943ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-05-30 11:20:03 Duration: 2s111ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-05-30 08:00:03 Duration: 1s791ms Database: rio User: intelifix Remote: [local] Application: psql
4 34 53s599ms 310ms 11s116ms 1s576ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration May 30 00 6 17s831ms 2s971ms 01 6 7s390ms 1s231ms 02 6 4s879ms 813ms 03 5 6s657ms 1s331ms 04 6 7s143ms 1s190ms 05 5 9s697ms 1s939ms [ User: intelifix - Total duration: 53s599ms - Times executed: 34 ]
[ Application: psql - Total duration: 53s599ms - Times executed: 34 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-05-30 00:05:12 Duration: 11s116ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-05-30 05:05:05 Duration: 3s944ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-05-30 05:15:04 Duration: 3s819ms Database: rio User: intelifix Remote: [local] Application: psql
5 32 1h24m52s 877ms 7m14s 2m39s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration May 30 07 2 7m17s 3m38s 08 2 5m13s 2m36s 09 2 5m32s 2m46s 10 2 5m5s 2m32s 11 2 5m15s 2m37s 12 2 5m2s 2m31s 13 2 5m11s 2m35s 14 2 5m5s 2m32s 15 2 5m6s 2m33s 16 2 4m57s 2m28s 17 2 5m34s 2m47s 18 2 5m9s 2m34s 19 2 4m56s 2m28s 20 2 5m2s 2m31s 21 2 5m4s 2m32s 22 2 5m17s 2m38s [ User: intelifix - Total duration: 1h24m52s - Times executed: 32 ]
[ Application: psql - Total duration: 1h24m52s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-30 07:12:15 Duration: 7m14s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-30 17:10:34 Duration: 5m33s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-30 09:10:32 Duration: 5m31s Database: rio User: intelifix Remote: [local] Application: psql
6 32 7m30s 405ms 49s539ms 14s83ms select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration May 30 07 2 50s789ms 25s394ms 08 2 26s14ms 13s7ms 09 2 26s733ms 13s366ms 10 2 27s732ms 13s866ms 11 2 26s274ms 13s137ms 12 2 27s30ms 13s515ms 13 2 27s504ms 13s752ms 14 2 25s997ms 12s998ms 15 2 26s888ms 13s444ms 16 2 25s570ms 12s785ms 17 2 28s87ms 14s43ms 18 2 26s259ms 13s129ms 19 2 25s858ms 12s929ms 20 2 27s223ms 13s611ms 21 2 26s437ms 13s218ms 22 2 26s260ms 13s130ms [ User: intelifix - Total duration: 7m30s - Times executed: 32 ]
[ Application: psql - Total duration: 7m30s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-30 07:13:05 Duration: 49s539ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-30 17:11:02 Duration: 27s436ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-30 10:10:30 Duration: 27s111ms Database: rio User: intelifix Remote: [local] Application: psql
7 25 4s846ms 151ms 340ms 193ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration May 30 03 1 240ms 240ms 04 21 3s883ms 184ms 05 3 722ms 240ms [ User: intelifix - Total duration: 4s846ms - Times executed: 25 ]
[ Application: [unknown] - Total duration: 4s846ms - Times executed: 25 ]
-
SELECT * FROM RS_TRIAGEM (429, 5, '113', 3, '241727650624,241708537691,241716681719,241716661717,241621021317,241706773939,241679472734,241603245171,241699942532,241679460814,241730313947,241694579113,241657203849,241651057895,241637764466,241646636476,241661394561,241634709510,241706610310,241651060422,241603168193,241675856174,241614797476,241730420524,241645657682,241699719300,241637771313,241651055673,241716676263,241679474148,241666428295,241708346685,241709754971,241607450408', NULL, NULL, 0320, 00);
Date: 2026-05-30 05:17:58 Duration: 340ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (429, 5, '113', 3, '230032398807,230052736369,230032479094,230006161230,230031776669,229976039715,230017264849,229966094760,230006364964,229971743134,229977970409,230047070722,230038074355,229975304963', NULL, NULL, 0295, 00);
Date: 2026-05-30 04:50:30 Duration: 243ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (428, 5, '108', 2, '229999841219,229930590005,230002515677,229953368691,229997615468,230003424464,229991924565,229929205155,229957080615', NULL, NULL, 0287, 00);
Date: 2026-05-30 03:30:24 Duration: 240ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 18 7s159ms 324ms 542ms 397ms select pro_id, pgp_sym_decrypt(nome, ?)::varchar, pgp_sym_decrypt(descricao, ?)::varchar, pgp_sym_decrypt(classe, ?)::varchar, pgp_sym_decrypt(php, ?)::varchar, pgp_sym_decrypt(extras, ?)::varchar from progs order by pro_id;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration May 30 00 1 381ms 381ms 03 1 382ms 382ms 04 1 542ms 542ms 05 3 1s221ms 407ms 07 2 889ms 444ms 08 1 350ms 350ms 09 2 720ms 360ms 10 1 357ms 357ms 11 2 721ms 360ms 13 2 672ms 336ms 14 2 919ms 459ms [ User: lenon - Total duration: 7s159ms - Times executed: 18 ]
[ Application: [unknown] - Total duration: 7s159ms - Times executed: 18 ]
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-05-30 04:16:54 Duration: 542ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-05-30 05:35:15 Duration: 498ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-05-30 07:22:03 Duration: 493ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
9 14 7s415ms 438ms 667ms 529ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration May 30 00 1 561ms 561ms 03 1 516ms 516ms 04 1 667ms 667ms 05 3 1s587ms 529ms 07 1 617ms 617ms 09 1 438ms 438ms 10 1 478ms 478ms 11 2 978ms 489ms 13 1 455ms 455ms 14 2 1s114ms 557ms [ User: intelifix - Total duration: 7s415ms - Times executed: 14 ]
[ Application: [unknown] - Total duration: 7s415ms - Times executed: 14 ]
-
select * from rs_menu_grants (499, 19, 1);
Date: 2026-05-30 04:16:54 Duration: 667ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (503, 18, 1);
Date: 2026-05-30 07:22:03 Duration: 617ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (417, 18, 1);
Date: 2026-05-30 14:10:48 Duration: 609ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
10 8 6s767ms 161ms 1s370ms 845ms create table temp0000226296 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration May 30 09 5 3s131ms 626ms 13 3 3s635ms 1s211ms [ User: intelifix - Total duration: 6s767ms - Times executed: 8 ]
[ Application: [unknown] - Total duration: 6s767ms - Times executed: 8 ]
-
CREATE TABLE temp0000226296 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"25-05-2026", "ate" :"30-05-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-05-30 09:34:02 Duration: 1s370ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000226296 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"25-05-2026", "ate" :"30-05-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-05-30 13:10:52 Duration: 1s268ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000226296 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"25-05-2026", "ate" :"30-05-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-05-30 09:39:00 Duration: 1s263ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
11 4 1m2s 2s182ms 29s564ms 15s629ms copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration May 30 20 2 30s668ms 15s334ms 23 2 31s849ms 15s924ms [ User: intelifix - Total duration: 1m2s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m2s - Times executed: 4 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-05-30 23:19:42 Duration: 29s564ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-05-30 20:05:48 Duration: 28s485ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-05-30 23:41:42 Duration: 2s285ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
12 4 57s16ms 1s564ms 27s309ms 14s254ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration May 30 20 2 28s142ms 14s71ms 23 2 28s873ms 14s436ms [ User: intelifix - Total duration: 57s16ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 57s16ms - Times executed: 4 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-30 23:20:13 Duration: 27s309ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-30 20:06:18 Duration: 26s524ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-30 20:08:58 Duration: 1s617ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
13 4 55s294ms 2s672ms 25s298ms 13s823ms copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration May 30 20 2 27s323ms 13s661ms 23 2 27s971ms 13s985ms [ User: intelifix - Total duration: 55s294ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 55s294ms - Times executed: 4 ]
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-05-30 23:40:08 Duration: 25s298ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-05-30 20:08:38 Duration: 24s178ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-05-30 20:09:05 Duration: 3s144ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
14 4 53s476ms 7s642ms 19s393ms 13s369ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration May 30 00 2 38s4ms 19s2ms 06 2 15s471ms 7s735ms [ User: intelifix - Total duration: 53s476ms - Times executed: 4 ]
[ Application: psql - Total duration: 53s476ms - Times executed: 4 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-05-30 00:05:21 Duration: 19s393ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-05-30 00:05:54 Duration: 18s611ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-05-30 06:05:24 Duration: 7s829ms Database: contagem User: intelifix Remote: [local] Application: psql
15 4 43s207ms 1s119ms 20s566ms 10s801ms copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration May 30 20 2 21s686ms 10s843ms 23 2 21s521ms 10s760ms [ User: intelifix - Total duration: 43s207ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 43s207ms - Times executed: 4 ]
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-05-30 20:04:03 Duration: 20s566ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-05-30 23:17:57 Duration: 20s308ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-05-30 23:41:39 Duration: 1s212ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
16 4 39s667ms 1s572ms 18s225ms 9s916ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 30 20 2 19s498ms 9s749ms 23 2 20s169ms 10s84ms [ User: intelifix - Total duration: 39s667ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 39s667ms - Times executed: 4 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-30 23:16:33 Duration: 18s225ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-30 20:02:39 Duration: 17s925ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-30 23:41:33 Duration: 1s944ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
17 4 39s410ms 1s434ms 18s468ms 9s852ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration May 30 20 2 19s508ms 9s754ms 23 2 19s902ms 9s951ms [ User: intelifix - Total duration: 39s410ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 39s410ms - Times executed: 4 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-30 23:17:05 Duration: 18s468ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-30 20:03:12 Duration: 18s51ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-30 20:08:50 Duration: 1s457ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
18 4 32s95ms 1s279ms 15s530ms 8s23ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 30 20 2 15s284ms 7s642ms 23 2 16s810ms 8s405ms [ User: intelifix - Total duration: 32s95ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 32s95ms - Times executed: 4 ]
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-05-30 23:17:21 Duration: 15s530ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-05-30 20:03:26 Duration: 13s722ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-05-30 20:08:52 Duration: 1s562ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
19 4 29s487ms 835ms 14s169ms 7s371ms copy public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration May 30 20 2 15s187ms 7s593ms 23 2 14s299ms 7s149ms [ User: intelifix - Total duration: 29s487ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 29s487ms - Times executed: 4 ]
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-05-30 20:02:54 Duration: 14s169ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-05-30 23:16:47 Duration: 13s464ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-05-30 20:08:48 Duration: 1s18ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
20 4 27s218ms 3s215ms 11s131ms 6s804ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 30 00 2 14s621ms 7s310ms 06 2 12s596ms 6s298ms [ User: lenon - Total duration: 27s218ms - Times executed: 4 ]
[ Application: psql - Total duration: 27s218ms - Times executed: 4 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-05-30 00:02:13 Duration: 11s131ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-05-30 06:02:11 Duration: 9s381ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-05-30 00:02:16 Duration: 3s490ms Database: contagem User: lenon Remote: [local] Application: psql
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m3s 7m12s 4m37s 2 9m15s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 30 05 2 9m15s 4m37s [ User: intelifix - Total duration: 9m15s - Times executed: 2 ]
[ Application: psql - Total duration: 9m15s - Times executed: 2 ]
-
analyze verbose;
Date: 2026-05-30 05:07:13 Duration: 7m12s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-05-30 05:09:17 Duration: 2m3s Database: contagem User: intelifix Remote: [local] Application: psql
2 877ms 7m14s 2m39s 32 1h24m52s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 30 07 2 7m17s 3m38s 08 2 5m13s 2m36s 09 2 5m32s 2m46s 10 2 5m5s 2m32s 11 2 5m15s 2m37s 12 2 5m2s 2m31s 13 2 5m11s 2m35s 14 2 5m5s 2m32s 15 2 5m6s 2m33s 16 2 4m57s 2m28s 17 2 5m34s 2m47s 18 2 5m9s 2m34s 19 2 4m56s 2m28s 20 2 5m2s 2m31s 21 2 5m4s 2m32s 22 2 5m17s 2m38s [ User: intelifix - Total duration: 1h24m52s - Times executed: 32 ]
[ Application: psql - Total duration: 1h24m52s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-30 07:12:15 Duration: 7m14s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-30 17:10:34 Duration: 5m33s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-30 09:10:32 Duration: 5m31s Database: rio User: intelifix Remote: [local] Application: psql
3 1m21s 1m28s 1m25s 2 2m50s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 30 20 1 1m21s 1m21s 23 1 1m28s 1m28s [ User: intelifix - Total duration: 2m50s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m50s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-30 23:39:43 Duration: 1m28s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-30 20:08:14 Duration: 1m21s Database: rio User: intelifix Remote: [local] Application: pg_dump
4 22s2ms 1m48s 1m5s 2 2m10s copy auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration May 30 23 2 2m10s 1m5s [ User: intelifix - Total duration: 2m10s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m10s - Times executed: 2 ]
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-30 23:15:55 Duration: 1m48s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-30 23:41:26 Duration: 22s2ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
5 19s222ms 1m36s 57s929ms 2 1m55s copy auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration May 30 23 2 1m55s 57s929ms [ User: intelifix - Total duration: 1m55s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m55s - Times executed: 2 ]
-
COPY auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-30 23:12:50 Duration: 1m36s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-30 23:40:46 Duration: 19s222ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
6 57s395ms 57s680ms 57s537ms 2 1m55s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration May 30 20 1 57s680ms 57s680ms 23 1 57s395ms 57s395ms [ User: intelifix - Total duration: 1m55s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m55s - Times executed: 2 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-30 20:05:19 Duration: 57s680ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-30 23:19:11 Duration: 57s395ms Database: rio User: intelifix Remote: [local] Application: pg_dump
7 17s685ms 1m16s 47s226ms 2 1m34s copy auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration May 30 23 2 1m34s 47s226ms [ User: intelifix - Total duration: 1m34s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m34s - Times executed: 2 ]
-
COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-30 23:14:07 Duration: 1m16s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-30 23:41:04 Duration: 17s685ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
8 15s442ms 1m9s 42s704ms 2 1m25s copy auditor.auditor_2026_02 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration May 30 23 2 1m25s 42s704ms [ User: intelifix - Total duration: 1m25s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m25s - Times executed: 2 ]
-
COPY auditor.auditor_2026_02 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-30 23:11:14 Duration: 1m9s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_02 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-30 23:40:27 Duration: 15s442ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
9 16s766ms 18s106ms 17s436ms 2 34s873ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration May 30 20 1 18s106ms 18s106ms 23 1 16s766ms 16s766ms [ User: intelifix - Total duration: 34s873ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 34s873ms - Times executed: 2 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-05-30 20:04:21 Duration: 18s106ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-05-30 23:18:14 Duration: 16s766ms Database: rio User: intelifix Remote: [local] Application: pg_dump
10 2s182ms 29s564ms 15s629ms 4 1m2s copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration May 30 20 2 30s668ms 15s334ms 23 2 31s849ms 15s924ms [ User: intelifix - Total duration: 1m2s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m2s - Times executed: 4 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-05-30 23:19:42 Duration: 29s564ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-05-30 20:05:48 Duration: 28s485ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-05-30 23:41:42 Duration: 2s285ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
11 1s564ms 27s309ms 14s254ms 4 57s16ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration May 30 20 2 28s142ms 14s71ms 23 2 28s873ms 14s436ms [ User: intelifix - Total duration: 57s16ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 57s16ms - Times executed: 4 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-30 23:20:13 Duration: 27s309ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-30 20:06:18 Duration: 26s524ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-30 20:08:58 Duration: 1s617ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
12 405ms 49s539ms 14s83ms 32 7m30s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration May 30 07 2 50s789ms 25s394ms 08 2 26s14ms 13s7ms 09 2 26s733ms 13s366ms 10 2 27s732ms 13s866ms 11 2 26s274ms 13s137ms 12 2 27s30ms 13s515ms 13 2 27s504ms 13s752ms 14 2 25s997ms 12s998ms 15 2 26s888ms 13s444ms 16 2 25s570ms 12s785ms 17 2 28s87ms 14s43ms 18 2 26s259ms 13s129ms 19 2 25s858ms 12s929ms 20 2 27s223ms 13s611ms 21 2 26s437ms 13s218ms 22 2 26s260ms 13s130ms [ User: intelifix - Total duration: 7m30s - Times executed: 32 ]
[ Application: psql - Total duration: 7m30s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-30 07:13:05 Duration: 49s539ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-30 17:11:02 Duration: 27s436ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-30 10:10:30 Duration: 27s111ms Database: rio User: intelifix Remote: [local] Application: psql
13 2s672ms 25s298ms 13s823ms 4 55s294ms copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration May 30 20 2 27s323ms 13s661ms 23 2 27s971ms 13s985ms [ User: intelifix - Total duration: 55s294ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 55s294ms - Times executed: 4 ]
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-05-30 23:40:08 Duration: 25s298ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-05-30 20:08:38 Duration: 24s178ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-05-30 20:09:05 Duration: 3s144ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
14 7s642ms 19s393ms 13s369ms 4 53s476ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration May 30 00 2 38s4ms 19s2ms 06 2 15s471ms 7s735ms [ User: intelifix - Total duration: 53s476ms - Times executed: 4 ]
[ Application: psql - Total duration: 53s476ms - Times executed: 4 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-05-30 00:05:21 Duration: 19s393ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-05-30 00:05:54 Duration: 18s611ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-05-30 06:05:24 Duration: 7s829ms Database: contagem User: intelifix Remote: [local] Application: psql
15 1s119ms 20s566ms 10s801ms 4 43s207ms copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration May 30 20 2 21s686ms 10s843ms 23 2 21s521ms 10s760ms [ User: intelifix - Total duration: 43s207ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 43s207ms - Times executed: 4 ]
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-05-30 20:04:03 Duration: 20s566ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-05-30 23:17:57 Duration: 20s308ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-05-30 23:41:39 Duration: 1s212ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
16 1s572ms 18s225ms 9s916ms 4 39s667ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 30 20 2 19s498ms 9s749ms 23 2 20s169ms 10s84ms [ User: intelifix - Total duration: 39s667ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 39s667ms - Times executed: 4 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-30 23:16:33 Duration: 18s225ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-30 20:02:39 Duration: 17s925ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-30 23:41:33 Duration: 1s944ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
17 1s434ms 18s468ms 9s852ms 4 39s410ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration May 30 20 2 19s508ms 9s754ms 23 2 19s902ms 9s951ms [ User: intelifix - Total duration: 39s410ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 39s410ms - Times executed: 4 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-30 23:17:05 Duration: 18s468ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-30 20:03:12 Duration: 18s51ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-30 20:08:50 Duration: 1s457ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
18 1s279ms 15s530ms 8s23ms 4 32s95ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 30 20 2 15s284ms 7s642ms 23 2 16s810ms 8s405ms [ User: intelifix - Total duration: 32s95ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 32s95ms - Times executed: 4 ]
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-05-30 23:17:21 Duration: 15s530ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-05-30 20:03:26 Duration: 13s722ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-05-30 20:08:52 Duration: 1s562ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
19 835ms 14s169ms 7s371ms 4 29s487ms copy public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration May 30 20 2 15s187ms 7s593ms 23 2 14s299ms 7s149ms [ User: intelifix - Total duration: 29s487ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 29s487ms - Times executed: 4 ]
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-05-30 20:02:54 Duration: 14s169ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-05-30 23:16:47 Duration: 13s464ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-05-30 20:08:48 Duration: 1s18ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
20 3s215ms 11s131ms 6s804ms 4 27s218ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 30 00 2 14s621ms 7s310ms 06 2 12s596ms 6s298ms [ User: lenon - Total duration: 27s218ms - Times executed: 4 ]
[ Application: psql - Total duration: 27s218ms - Times executed: 4 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-05-30 00:02:13 Duration: 11s131ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-05-30 06:02:11 Duration: 9s381ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-05-30 00:02:16 Duration: 3s490ms Database: contagem User: lenon Remote: [local] Application: psql
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 1 0ms 4 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration May 30 17 2 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms [ User: intelifix - Total duration: 10s173ms - Times executed: 4 ]
[ Application: psql - Total duration: 10s173ms - Times executed: 4 ]
-
;
Date: Duration: 0ms Database: postgres User: rio Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 6,542 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 426 FATAL entries
- 1507 ERROR entries
- 0 WARNING entries
- 1 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 1,503 Max number of times the same event was reported
- 1,934 Total events found
Rank Times reported Error 1 1,503 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count May 30 00 58 01 56 02 59 03 57 04 57 05 59 06 60 07 59 08 59 09 84 10 69 11 84 12 60 13 85 14 72 15 60 16 59 17 60 18 59 19 60 20 59 21 60 22 59 23 49 - ERROR: prepared statement "_PLAN000000001BEB35F0" does not exist
- ERROR: prepared statement "_PLAN0000000029C6A210" does not exist
- ERROR: prepared statement "_PLAN000000001BEB4CC0" does not exist
Statement: DEALLOCATE "_PLAN000000001BEB35F0"
Date: 2026-05-30 00:00:30 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029C6A210"
Date: 2026-05-30 00:01:30 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN000000001BEB4CC0"
Date: 2026-05-30 00:02:31 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 419 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count May 30 00 16 01 14 02 14 03 15 04 16 05 19 06 16 07 16 08 19 09 20 10 19 11 19 12 19 13 19 14 19 15 19 16 19 17 20 18 20 19 19 20 20 21 20 22 19 23 3 - FATAL: database "brasilia" does not exist
- FATAL: database "testes" does not exist
- FATAL: database "brasilia" does not exist
Date: 2026-05-30 00:02:13 Database: brasilia Application: [unknown] User: lenon Remote: [local]
Date: 2026-05-30 00:02:16 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-05-30 00:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
3 5 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #3
Day Hour Count May 30 03 5 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-05-30 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-05-30 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-05-30 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
4 2 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count May 30 05 2 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-05-30 05:30:17 Database: contagem Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-05-30 05:30:17 Database: contagem Application: psql User: intelifix Remote: [local]
5 2 ERROR: could not connect to server "..."
Times Reported Most Frequent Error / Event #5
Day Hour Count May 30 05 2 - ERROR: could not connect to server "Brasilia"
- ERROR: could not connect to server "Brasilia"
Detail: connection to server at "localhost" (127.0.0.1), port 9276 failed: FATAL: database "brasilia" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;Date: 2026-05-30 05:30:02 Database: rio Application: psql User: intelifix Remote: [local]
Detail: connection to server at "localhost" (127.0.0.1), port 9276 failed: FATAL: database "brasilia" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;Date: 2026-05-30 05:30:02 Database: rio Application: psql User: intelifix Remote: [local]
6 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #6
Day Hour Count May 30 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-05-30 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-05-30 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
7 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #7
Day Hour Count May 30 03 1 - LOG: database system was shut down at 2026-05-30 03:05:01 -03
Date: 2026-05-30 03:05:03