pgBadger-
Global information
- Generated on Fri May 29 23:50:07 2026
- Log file: /usr/local/pgsql/data/log/serverlog-04.log, ..., /usr/local/pgsql/data/log/serverlog-29.log
- Parsed 42,133 log entries in 5s
- Log start from 2026-05-29 00:00:45 to 2026-05-29 23:49:44
-
Overview
Global Stats
- 299 Number of unique normalized queries
- 6,070 Number of queries
- 6h28m40s Total query duration
- 2026-05-29 00:02:11 First query
- 2026-05-29 23:45:02 Last query
- 5 queries/s at 2026-05-29 08:35:02 Query peak
- 6h28m40s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 6h28m40s Execute total duration
- 3,856 Number of events
- 12 Number of unique normalized events
- 3,382 Max number of times the same event was reported
- 0 Number of cancellation
- 479 Total number of automatic vacuums
- 974 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 248 Total number of sessions
- 6 sessions at 2026-05-29 15:35:31 Session peak
- 9d5h52m28s Total duration of sessions
- 53m40s Average duration of sessions
- 24 Average queries per session
- 1m34s Average queries duration per session
- 52m6s Average idle time per session
- 673 Total number of connections
- 4 connections/s at 2026-05-29 23:45:02 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-05-29 08:35:02 Date
SELECT Traffic
Key values
- 4 queries/s Query Peak
- 2026-05-29 08:35:02 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-05-29 23:44:03 Date
Queries duration
Key values
- 6h28m40s 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 29 00 17 0ms 19s602ms 5s208ms 2s847ms 5s162ms 59s831ms 01 11 0ms 3s561ms 2s435ms 2s739ms 4s936ms 5s997ms 02 11 0ms 2s788ms 1s995ms 2s638ms 3s779ms 4s882ms 03 25 0ms 3s543ms 1s161ms 3s349ms 4s191ms 5s542ms 04 40 0ms 19s756ms 1s276ms 3s259ms 4s453ms 25s181ms 05 16 0ms 7m43s 39s617ms 3s840ms 6s579ms 7m43s 06 26 0ms 16s111ms 3s188ms 4s925ms 11s411ms 20s550ms 07 470 0ms 8m23s 4s306ms 53s9ms 4m36s 8m44s 08 661 150ms 6m34s 2s834ms 46s408ms 3m55s 6m44s 09 840 150ms 6m20s 2s415ms 1m9s 4m14s 6m52s 10 699 150ms 8m49s 3s217ms 1m19s 4m8s 9m7s 11 635 150ms 7m28s 3s2ms 44s149ms 3m50s 7m30s 12 97 0ms 6m15s 7s425ms 8s79ms 10s885ms 6m49s 13 260 0ms 6m14s 3s113ms 27s110ms 46s408ms 6m44s 14 702 150ms 6m14s 2s607ms 54s895ms 1m16s 7m25s 15 813 150ms 8m 3s95ms 1m19s 4m37s 8m50s 16 331 0ms 6m39s 4s613ms 46s967ms 3m55s 7m57s 17 57 0ms 6m9s 7s979ms 2s953ms 4s145ms 6m47s 18 14 0ms 5m44s 28s175ms 2s505ms 3s283ms 5m44s 19 13 0ms 5m36s 29s798ms 2s869ms 3s101ms 5m36s 20 68 0ms 5m28s 11s876ms 47s261ms 1m37s 5m28s 21 22 0ms 5m27s 17s598ms 3s611ms 4s205ms 5m57s 22 19 0ms 6m5s 22s203ms 3s831ms 4s769ms 6m33s 23 223 0ms 1m45s 9s185ms 1m12s 1m31s 2m4s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 29 00 2 0 5s9ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 13 0 285ms 0ms 184ms 814ms 04 27 0 266ms 194ms 354ms 835ms 05 3 0 335ms 0ms 0ms 191ms 06 6 0 2s221ms 0ms 0ms 1s116ms 07 327 0 4s453ms 4s540ms 9s466ms 4m28s 08 489 0 2s859ms 7s659ms 35s546ms 3m51s 09 625 0 2s638ms 13s933ms 58s903ms 4m20s 10 520 0 3s486ms 14s405ms 59s790ms 4m8s 11 481 0 3s147ms 12s251ms 39s34ms 3m56s 12 74 0 9s106ms 1s694ms 2s850ms 3m44s 13 202 0 3s563ms 5s239ms 17s579ms 1m2s 14 565 0 2s282ms 11s805ms 46s349ms 4m46s 15 665 0 3s54ms 20s641ms 56s5ms 4m47s 16 275 0 4s837ms 10s377ms 44s980ms 4m22s 17 27 0 15s947ms 329ms 2s380ms 5s451ms 18 5 0 1m14s 0ms 0ms 29s58ms 19 4 0 1m31s 0ms 0ms 30s957ms 20 7 52 13s368ms 0ms 47s261ms 2m1s 21 8 0 45s131ms 0ms 0ms 1s464ms 22 4 0 1m38s 0ms 0ms 0ms 23 7 216 9s185ms 1m6s 1m12s 2m3s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 29 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 29 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 2 2.00 0.00% 04 0 3 3.00 0.00% 05 0 1 1.00 0.00% 06 0 2 2.00 0.00% 07 0 7 7.00 0.00% 08 0 9 9.00 0.00% 09 0 8 8.00 0.00% 10 0 10 10.00 0.00% 11 0 7 7.00 0.00% 12 0 2 2.00 0.00% 13 0 9 9.00 0.00% 14 0 9 9.00 0.00% 15 0 9 9.00 0.00% 16 0 7 7.00 0.00% 17 0 1 1.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 1 1.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second May 29 00 27 0.01/s 01 19 0.01/s 02 21 0.01/s 03 27 0.01/s 04 22 0.01/s 05 25 0.01/s 06 26 0.01/s 07 29 0.01/s 08 38 0.01/s 09 35 0.01/s 10 39 0.01/s 11 35 0.01/s 12 26 0.01/s 13 30 0.01/s 14 37 0.01/s 15 36 0.01/s 16 36 0.01/s 17 26 0.01/s 18 27 0.01/s 19 24 0.01/s 20 27 0.01/s 21 28 0.01/s 22 24 0.01/s 23 9 0.00/s Day Hour Count Average Duration Average idle time May 29 00 5 54m 53m42s 01 9 1h40s 1h37s 02 5 1h 59m55s 03 11 22m28s 22m25s 04 8 58m52s 58m46s 05 8 54m7s 52m48s 06 5 1h 59m43s 07 11 52m54s 49m50s 08 13 54m19s 51m55s 09 16 58m49s 56m42s 10 21 45m6s 43m19s 11 16 55m13s 53m14s 12 14 1h1m 1h8s 13 7 56m8s 54m13s 14 13 55m14s 52m54s 15 17 56m4s 53m36s 16 18 50m25s 49m 17 13 59m54s 59m19s 18 6 55m50s 54m44s 19 6 1h30s 59m25s 20 7 44m40s 42m44s 21 5 1h1m41s 1h23s 22 8 1h22s 59m30s 23 6 46m12s 40m31s -
Connections
Established Connections
Key values
- 4 connections Connection Peak
- 2026-05-29 23:45:02 Date
Connections per database
Key values
- brasilia Main Database
- 673 connections Total
Connections per user
Key values
- intelifix Main User
- 673 connections Total
-
Sessions
Simultaneous sessions
Key values
- 6 sessions Session Peak
- 2026-05-29 15:35:31 Date
Histogram of session times
Key values
- 195 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 248 sessions Total
Sessions per user
Key values
- intelifix Main User
- 248 sessions Total
Sessions per host
Key values
- [local] Main Host
- 248 sessions Total
Sessions per application
Key values
- [unknown] Main Application
- 248 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 19,712 buffers Checkpoint Peak
- 2026-05-29 07:44:34 Date
- 270.078 seconds Highest write time
- 0.046 seconds Sync time
Checkpoints Wal files
Key values
- 16 files Wal files usage Peak
- 2026-05-29 10:49:34 Date
Checkpoints distance
Key values
- 494.35 Mo Distance Peak
- 2026-05-29 10:49:34 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time May 29 00 18,120 916.926s 0.016s 916.975s 01 2,246 225.312s 0.015s 225.349s 02 1,885 189.264s 0.012s 189.299s 03 2,953 296.098s 0.042s 296.176s 04 5,400 542.718s 0.035s 542.801s 05 8,747 794.385s 0.026s 794.45s 06 7,241 646.593s 0.018s 646.639s 07 55,055 2,522.713s 0.149s 2,522.97s 08 69,441 3,130.284s 0.196s 3,130.638s 09 70,634 3,239.341s 0.238s 3,239.755s 10 76,428 3,187.208s 0.263s 3,187.652s 11 97,343 3,239.216s 0.249s 3,239.655s 12 29,708 1,614.428s 0.05s 1,614.545s 13 19,632 1,872.829s 0.095s 1,873.019s 14 56,964 3,115.152s 0.241s 3,115.557s 15 81,858 3,239.288s 0.281s 3,239.759s 16 27,015 1,908.099s 0.13s 1,908.348s 17 5,700 580.589s 0.045s 580.688s 18 409 41.013s 0.006s 41.033s 19 102 10.254s 0.003s 10.261s 20 1,363 136.717s 0.005s 136.73s 21 2,085 209.293s 0.02s 209.35s 22 2,296 230.375s 0.02s 230.433s 23 8,992 348.47s 0.01s 348.491s Day Hour Added Removed Recycled Synced files Longest sync Average sync May 29 00 0 0 6 445 0.003s 0.006s 01 0 0 0 441 0.002s 0.006s 02 0 0 1 374 0.003s 0.005s 03 0 0 1 443 0.005s 0.007s 04 0 0 1 937 0.002s 0.011s 05 0 0 4 758 0.003s 0.008s 06 0 0 2 442 0.003s 0.006s 07 0 0 34 3,482 0.005s 0.012s 08 0 0 45 5,121 0.004s 0.012s 09 0 0 39 6,373 0.003s 0.012s 10 0 0 51 6,360 0.005s 0.012s 11 0 0 49 6,202 0.003s 0.012s 12 0 0 13 1,583 0.003s 0.01s 13 0 0 7 2,929 0.003s 0.012s 14 0 0 36 5,578 0.012s 0.012s 15 0 0 54 6,099 0.007s 0.012s 16 0 0 24 3,543 0.003s 0.012s 17 0 0 2 1,222 0.003s 0.011s 18 0 0 0 32 0.002s 0.004s 19 0 0 0 5 0.002s 0.001s 20 0 0 1 51 0.002s 0.002s 21 0 0 0 393 0.003s 0.007s 22 0 0 1 472 0.003s 0.01s 23 0 0 1 64 0.003s 0.003s Day Hour Count Avg time (sec) May 29 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 29 00 16,059.50 kB 37,652.33 kB 01 1,975.50 kB 21,372.17 kB 02 1,876.80 kB 12,680.60 kB 03 1,782.50 kB 3,831.50 kB 04 2,590.18 kB 3,791.36 kB 05 7,605.62 kB 21,156.25 kB 06 4,817.17 kB 15,353.50 kB 07 45,815.92 kB 68,999.83 kB 08 61,654.25 kB 107,640.25 kB 09 53,668.42 kB 106,175.67 kB 10 69,161.75 kB 122,131.42 kB 11 67,673.08 kB 150,530.83 kB 12 20,477.50 kB 75,582.40 kB 13 10,287.83 kB 29,069.25 kB 14 49,417.17 kB 86,596.92 kB 15 73,493.33 kB 115,209.75 kB 16 31,916.92 kB 103,899.92 kB 17 3,051.36 kB 35,032.09 kB 18 473.33 kB 16,847.00 kB 19 268.00 kB 13,629.00 kB 20 7,183.50 kB 12,903.50 kB 21 1,395.00 kB 8,690.86 kB 22 1,331.44 kB 4,551.56 kB 23 3,869.00 kB 5,259.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 29 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
- 4.97 sec Highest CPU-cost vacuum
Table public.usuarios
Database rio - 2026-05-29 07:24:55 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 4.97 sec Highest CPU-cost vacuum
Table public.usuarios
Database rio - 2026-05-29 07:24:55 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (141) Main table analyzed (database rio)
- 974 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 141 rio.pg_catalog.pg_class 75 rio.pg_catalog.pg_type 63 rio.public.usuarios 52 contagem.pg_catalog.pg_attribute 45 rio.pg_catalog.pg_index 41 rio.public.temp0000281251 41 rio.public.temp0000281201 37 contagem.public.temp0000226308 35 contagem.public.usuarios 32 rio.pg_catalog.pg_depend 31 rio.public.temp0000281211 26 rio.public.temp0000281227 24 rio.public.temp0000281273 24 contagem.pg_catalog.pg_class 21 contagem.pg_catalog.pg_type 20 rio.public.temp0000281213 17 rio.public.temp0000281195 16 rio.public.temp0000281191 16 rio.public.temp0000281219 14 contagem.public.temp0000226310 13 contagem.pg_catalog.pg_index 12 rio.public.temp0000281183 11 rio.public.temp0000281047 11 rio.public.temp0000281197 9 rio.public.temp0000281045 9 rio.public.temp0000281093 9 contagem.pg_catalog.pg_depend 9 rio.public.tmp_drill_0175 9 rio.public.temp0000281119 8 rio.public.temp0000281225 7 rio.public.temp0000281217 6 rio.public.temp0000281209 6 rio.public.temp0000281233 6 rio.public.temp0000281229 6 contagem.public.temp0000226296 5 rio.public.temp0000281173 5 contagem.pg_catalog.pg_shdepend 5 rio.pg_catalog.pg_shdepend 5 rio.public.temp0000281223 5 postgres.pg_catalog.pg_shdepend 5 contagem.public.nf_entrada 4 rio.public.temp0000281189 4 rio.public.temp0000281109 4 rio.public.temp0000281171 4 rio.public.temp0000281271 3 template1.pg_catalog.pg_shdepend 2 rio.public.temp0000281245 2 rio.public.temp0000281265 2 rio.public.temp0000281293 2 rio.public.temp0000281277 2 rio.public.temp0000281181 2 rio.public.temp0000281187 1 rio.public.temp0000281205 1 rio.public.temp0000281207 1 rio.public.temp0000281193 1 rio.public.temp0000281289 1 rio.public.temp0000281243 1 rio.public.temp0000281285 1 rio.public.temp0000281281 1 rio.public.temp0000281279 1 rio.public.temp0000281269 1 rio.public.temp0000281253 1 Total 974 Vacuums per table
Key values
- pg_catalog.pg_attribute (57) Main table vacuumed on database rio
- 479 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.pg_catalog.pg_attribute 57 51 0 0 0 0 0 28,254 6,847 10,067,335 465 11,487 rio.public.temp0000281251 39 0 0 0 0 0 0 26,644 1,698 3,546,840 0 0 rio.pg_catalog.pg_class 34 29 0 0 0 0 0 5,892 1,871 2,472,835 117 528 contagem.public.usuarios 32 0 0 0 0 0 0 143 108 60,007 2 2 rio.public.temp0000281211 26 0 0 0 0 0 0 25,471 121 1,522,063 0 0 rio.pg_catalog.pg_type 26 24 0 0 0 0 0 1,948 516 628,339 77 247 rio.public.temp0000281227 23 0 0 0 0 0 0 23,093 1,616 3,322,056 0 0 rio.public.tmp_drill_0175 21 8 0 0 0 0 0 1,134 571 833,168 3 80 contagem.pg_catalog.pg_attribute 19 19 0 0 0 0 0 12,752 3,496 6,254,223 48 1,473 rio.pg_catalog.pg_index 16 16 0 0 0 0 0 992 275 213,295 53 116 rio.pg_catalog.pg_statistic 12 12 0 0 0 0 0 9,333 2,297 8,452,282 1,313 6,526 rio.pg_catalog.pg_depend 12 12 0 0 0 0 0 4,246 1,570 2,131,886 82 848 rio.auditor.auditor_2026_05 12 0 0 0 0 0 0 145,658 52,621 72,822,168 44,995 920,763 contagem.public.temp0000226310 12 0 0 0 0 0 0 1,081 322 491,378 0 0 rio.public.temp0000281047 11 0 0 0 0 0 0 911 134 193,232 0 0 rio.public.temp0000281213 10 0 0 0 0 0 0 486 58 36,419 0 0 rio.public.temp0000281045 9 0 0 0 0 0 0 1,013 212 365,965 0 0 rio.public.temp0000281093 9 0 0 0 0 0 0 513 136 195,442 0 0 contagem.pg_catalog.pg_class 8 8 0 0 0 0 0 1,626 283 484,857 13 30 rio.public.temp0000281119 8 0 0 0 0 0 0 911 44 60,556 0 0 contagem.pg_catalog.pg_type 8 8 0 0 0 0 0 761 158 264,658 4 39 rio.public.temp0000281201 7 0 0 0 0 0 0 400 40 29,564 0 0 contagem.pg_catalog.pg_depend 6 6 0 0 0 0 0 1,669 439 922,553 8 189 contagem.pg_catalog.pg_index 6 6 0 0 0 0 0 286 81 94,621 2 2 rio.pg_toast.pg_toast_2619 5 5 0 0 0 0 0 1,885 433 2,080,866 110 386 rio.pg_catalog.pg_shdepend 5 5 0 0 0 0 0 1,038 347 504,192 49 71 rio.public.usuarios 5 5 0 0 0 0 0 134 57 102,465 8 88 rio.public.temp0000281109 3 0 0 0 0 0 0 156 16 12,021 0 0 rio.public.nf_entrada_arquivo_erros 3 0 0 0 0 0 0 584 291 799,219 113 5,611 rio.public.logs 3 0 0 0 0 0 0 627 198 264,866 187 4,527 rio.public.equipamentos_referencia 2 0 0 0 0 0 0 31 25 72,147 3 555 rio.public.temp0000281209 2 0 0 0 0 0 0 126 11 9,314 0 0 rio.public.temp0000281245 2 0 0 0 0 0 0 481 12 30,802 0 0 contagem.pg_catalog.pg_statistic 2 2 0 0 0 0 0 3,491 1,092 3,671,294 827 5,646 rio.public.temp0000281293 2 0 0 0 0 0 0 3,076 8 182,690 0 0 postgres.pg_catalog.pg_shdepend 2 2 0 0 0 0 0 378 116 207,446 12 15 contagem.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 230 65 192,118 6 17 rio.public.temp0000281271 2 0 0 0 0 0 0 50 11 4,437 0 0 rio.public.temp0000281187 1 0 0 0 0 0 0 78 6 5,495 0 0 rio.public.temp0000281205 1 0 0 0 0 0 0 81 6 5,677 0 0 rio.public.giga_testes 1 0 0 0 0 0 0 288 290 750,209 24 395 rio.public.temp0000281189 1 0 0 0 0 0 0 118 6 7,943 0 0 rio.public.temp0000281193 1 0 0 0 0 0 0 118 6 7,941 0 0 contagem.public.nf_entrada 1 1 0 0 0 0 0 73 25 71,663 5 180 rio.public.temp0000281207 1 0 0 0 0 0 0 8 5 1,287 0 0 rio.public.temp0000281289 1 0 0 0 0 0 0 4 3 774 0 0 rio.public.temp0000281191 1 0 0 0 0 0 0 118 6 7,943 0 0 rio.public.temp0000281285 1 0 0 0 0 0 0 4 3 774 0 0 rio.public.temp0000281225 1 0 0 0 0 0 0 118 6 7,943 0 0 rio.public.temp0000281273 1 0 0 0 0 0 0 8 5 1,433 0 0 rio.public.temp0000281281 1 0 0 0 0 0 0 131 4 8,332 0 0 rio.public.temp0000281269 1 0 0 0 0 0 0 8 5 1,383 0 0 rio.public.caixa_itens_exclusao 1 0 0 0 0 0 0 37 19 60,332 8 836 rio.public.temp0000281279 1 0 0 0 0 0 0 137 6 9,099 0 0 Total 479 221 0 0 0 0 0 308,833 78,597 124,547,847 48,534 960,657 Vacuum throughput per table
Key values
- auditor.auditor_2026_05 (16.78) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.pg_catalog.pg_attribute 0 0 3.02 rio.public.temp0000281251 0 0 1.16 rio.pg_catalog.pg_class 0 0 0.78 contagem.public.usuarios 0 0 0 rio.public.temp0000281211 0 0 0.72 rio.pg_catalog.pg_type 0 0 0.21 rio.public.temp0000281227 0 0 1.01 rio.public.tmp_drill_0175 0 0 0.09 contagem.pg_catalog.pg_attribute 0 0 1.49 rio.pg_catalog.pg_index 0 0 0.1 rio.pg_catalog.pg_statistic 0 0 1.05 rio.pg_catalog.pg_depend 0 0 0.86 rio.auditor.auditor_2026_05 0 0 16.78 contagem.public.temp0000226310 0 0 0.14 rio.public.temp0000281047 0 0 0.19 rio.public.temp0000281213 0 0 0.1 rio.public.temp0000281045 0 0 0.1 rio.public.temp0000281093 0 0 0.09 contagem.pg_catalog.pg_class 0 0 0.22 rio.public.temp0000281119 0 0 0.08 contagem.pg_catalog.pg_type 0 0 0.1 rio.public.temp0000281201 0 0 0.05 contagem.pg_catalog.pg_depend 0 0 0.25 contagem.pg_catalog.pg_index 0 0 0.13 rio.pg_toast.pg_toast_2619 0 0 0.19 rio.pg_catalog.pg_shdepend 0 0 0.18 rio.public.usuarios 0 0 5.09 rio.public.temp0000281109 0 0 0.04 rio.public.nf_entrada_arquivo_erros 0 0 0.16 rio.public.logs 0 0 0.3 rio.public.equipamentos_referencia 0 0 0.02 rio.public.temp0000281209 0 0 0.02 rio.public.temp0000281245 0 0 0.03 contagem.pg_catalog.pg_statistic 0 0 0.23 rio.public.temp0000281293 0 0 0.09 postgres.pg_catalog.pg_shdepend 0 0 0.04 contagem.pg_toast.pg_toast_2619 0 0 0.01 rio.public.temp0000281271 0 0 0.02 rio.public.temp0000281187 0 0 0.01 rio.public.temp0000281205 0 0 0.02 rio.public.giga_testes 0 0 0.61 rio.public.temp0000281189 0 0 0.01 rio.public.temp0000281193 0 0 0.01 contagem.public.nf_entrada 0 0 0.02 rio.public.temp0000281207 0 0 0.01 rio.public.temp0000281289 0 0 0 rio.public.temp0000281191 0 0 0.01 rio.public.temp0000281285 0 0 0 rio.public.temp0000281225 0 0 0.01 rio.public.temp0000281273 0 0 0.01 rio.public.temp0000281281 0 0 0 rio.public.temp0000281269 0 0 0.01 rio.public.caixa_itens_exclusao 0 0 0.01 rio.public.temp0000281279 0 0 0.02 Total 0 0 35.9 Tuples removed per table
Key values
- pg_catalog.pg_attribute (221430) Main table with removed tuples on database rio
- 380964 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 57 51 221,430 1,350,776 67,757 483 34,934 contagem.pg_catalog.pg_attribute 19 19 71,356 459,491 68 270 10,308 rio.pg_catalog.pg_statistic 12 12 18,862 77,256 332 0 15,432 rio.public.tmp_drill_0175 21 8 14,954 189,255 86,523 0 2,586 rio.pg_catalog.pg_depend 12 12 9,740 232,029 3,977 13 2,238 rio.pg_catalog.pg_type 26 24 8,156 61,822 2,412 19 1,788 rio.pg_catalog.pg_class 34 29 5,160 128,716 9,726 67 4,242 contagem.pg_catalog.pg_statistic 2 2 5,094 14,495 0 0 2,022 rio.pg_catalog.pg_shdepend 5 5 4,634 46,317 6 0 505 rio.pg_catalog.pg_index 16 16 4,296 31,299 538 0 912 contagem.pg_catalog.pg_type 8 8 3,044 17,992 4 16 527 contagem.pg_catalog.pg_depend 6 6 2,778 112,761 12 0 1,038 postgres.pg_catalog.pg_shdepend 2 2 2,580 18,563 0 0 202 contagem.pg_catalog.pg_class 8 8 2,274 27,340 7 33 948 contagem.public.usuarios 32 0 1,910 672 0 0 64 contagem.pg_catalog.pg_index 6 6 1,520 10,247 2 15 297 rio.pg_toast.pg_toast_2619 5 5 1,203 2,190 11 0 1,365 rio.auditor.auditor_2026_05 12 0 1,153 280,941,323 0 0 12,583,531 rio.public.usuarios 5 5 403 2,899 369 2 84 contagem.pg_toast.pg_toast_2619 2 2 171 226 0 0 106 contagem.public.nf_entrada 1 1 106 829 0 0 20 rio.public.giga_testes 1 0 102 3,650,414 0 0 94,338 rio.public.nf_entrada_arquivo_erros 3 0 26 24,591,444 0 0 436,099 rio.public.caixa_itens_exclusao 1 0 12 1,229,845 0 0 10,252 rio.public.temp0000281201 7 0 0 13,814 0 135 441 rio.public.temp0000281227 23 0 0 497,880 0 0 35,328 rio.public.temp0000281187 1 0 0 1,329 0 58 70 rio.public.temp0000281251 39 0 0 535,905 0 502 37,386 rio.public.temp0000281211 26 0 0 367,369 0 132 25,724 rio.public.temp0000281205 1 0 0 1,383 0 55 73 rio.public.temp0000281189 1 0 0 2,018 0 18 110 rio.public.temp0000281193 1 0 0 2,018 0 18 110 rio.public.temp0000281207 1 0 0 1,338 0 57 71 rio.public.temp0000281289 1 0 0 2,338 0 0 128 rio.public.equipamentos_referencia 2 0 0 9,975,948 0 0 53,927 rio.public.temp0000281209 2 0 0 4,101 0 33 223 rio.public.temp0000281109 3 0 0 17,527 0 180 396 rio.public.temp0000281245 2 0 0 8,035 0 111 465 rio.public.temp0000281213 10 0 0 28,329 0 312 584 rio.public.temp0000281045 9 0 0 48,158 0 192 1,088 rio.public.temp0000281191 1 0 0 2,018 0 18 110 rio.public.temp0000281285 1 0 0 2,338 0 0 128 rio.public.temp0000281225 1 0 0 2,018 0 18 110 rio.public.temp0000281093 9 0 0 38,283 0 223 865 contagem.public.temp0000226310 12 0 0 12,771 0 552 984 rio.public.temp0000281293 2 0 0 43,321 0 0 3,072 rio.public.temp0000281273 1 0 0 7,575 0 21 171 rio.public.logs 3 0 0 47,285,439 0 0 1,889,219 rio.public.temp0000281281 1 0 0 2,338 0 0 128 rio.public.temp0000281047 11 0 0 68,557 0 435 1,549 rio.public.temp0000281269 1 0 0 5,838 0 60 132 rio.public.temp0000281271 2 0 0 3,106 0 32 64 rio.public.temp0000281119 8 0 0 37,763 0 233 855 rio.public.temp0000281279 1 0 0 2,390 0 63 129 Total 479 221 380,964 372,219,446 171,744 4,376 15,257,478 Pages removed per table
Key values
- public.temp0000226310 (552) Main table with removed pages on database contagem
- 4376 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed contagem.public.temp0000226310 12 0 0 552 rio.public.temp0000281251 39 0 0 502 rio.pg_catalog.pg_attribute 57 51 221430 483 rio.public.temp0000281047 11 0 0 435 rio.public.temp0000281213 10 0 0 312 contagem.pg_catalog.pg_attribute 19 19 71356 270 rio.public.temp0000281119 8 0 0 233 rio.public.temp0000281093 9 0 0 223 rio.public.temp0000281045 9 0 0 192 rio.public.temp0000281109 3 0 0 180 rio.public.temp0000281201 7 0 0 135 rio.public.temp0000281211 26 0 0 132 rio.public.temp0000281245 2 0 0 111 rio.pg_catalog.pg_class 34 29 5160 67 rio.public.temp0000281279 1 0 0 63 rio.public.temp0000281269 1 0 0 60 rio.public.temp0000281187 1 0 0 58 rio.public.temp0000281207 1 0 0 57 rio.public.temp0000281205 1 0 0 55 rio.public.temp0000281209 2 0 0 33 contagem.pg_catalog.pg_class 8 8 2274 33 rio.public.temp0000281271 2 0 0 32 rio.public.temp0000281273 1 0 0 21 rio.pg_catalog.pg_type 26 24 8156 19 rio.public.temp0000281189 1 0 0 18 rio.public.temp0000281193 1 0 0 18 rio.public.temp0000281191 1 0 0 18 rio.public.temp0000281225 1 0 0 18 contagem.pg_catalog.pg_type 8 8 3044 16 contagem.pg_catalog.pg_index 6 6 1520 15 rio.pg_catalog.pg_depend 12 12 9740 13 rio.public.usuarios 5 5 403 2 rio.public.temp0000281227 23 0 0 0 rio.pg_catalog.pg_index 16 16 4296 0 rio.pg_catalog.pg_statistic 12 12 18862 0 rio.public.giga_testes 1 0 102 0 contagem.public.nf_entrada 1 1 106 0 rio.public.temp0000281289 1 0 0 0 rio.public.equipamentos_referencia 2 0 0 0 rio.auditor.auditor_2026_05 12 0 1153 0 rio.public.temp0000281285 1 0 0 0 rio.pg_toast.pg_toast_2619 5 5 1203 0 rio.public.nf_entrada_arquivo_erros 3 0 26 0 rio.pg_catalog.pg_shdepend 5 5 4634 0 contagem.pg_catalog.pg_statistic 2 2 5094 0 contagem.pg_catalog.pg_depend 6 6 2778 0 rio.public.temp0000281293 2 0 0 0 rio.public.logs 3 0 0 0 postgres.pg_catalog.pg_shdepend 2 2 2580 0 contagem.pg_toast.pg_toast_2619 2 2 171 0 contagem.public.usuarios 32 0 1910 0 rio.public.temp0000281281 1 0 0 0 rio.public.tmp_drill_0175 21 8 14954 0 rio.public.caixa_itens_exclusao 1 0 12 0 Total 479 221 380,964 4,376 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs May 29 00 2 0 01 0 0 02 0 0 03 0 1 04 1 9 05 4 1 06 2 3 07 34 73 08 57 104 09 64 140 10 67 131 11 73 118 12 2 16 13 27 60 14 50 112 15 63 121 16 26 65 17 5 18 18 0 0 19 1 0 20 0 0 21 1 2 22 0 0 23 0 0 - 4.97 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 2 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 1 2m30s 2m30s 2m30s 2m30s call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-29 07:27:38 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-29 00:05:21 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-29 13:05:08 Database: rio User: intelifix Remote: [local] Application: psql
2 1 1s879ms 1s879ms 1s879ms 1s879ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (39190, 413, '215704856973', '',077,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":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-05-29 11:24:03 Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (39548, 407, 'ZTE3ANNQ4410390,3CF9F0AC5262,3CF9F0AC5263,ZTEGD641A319$ZTE3ANNQ7L06042,C4EBFF8E1244,C4EBFF8E1245,ZTEGD70AD3CC$ZTE3ANNR3J07640,F4E84F870170,F4E84F870171,ZTEGD97B7FA2$ZTE3ANNQ7T01794,C4EBFF8F154C,C4EBFF8F154D,ZTEGD70AFEF8$ZTE3ANNRB737590,5872C991AA35,5872C991AA36,ZTEGDC61BDA9$ZTE3ANNT2V85886,D83139936BCC,D83139936BCD,ZTEGDD3141FD$ZTE3ANNT2V85838,D83139936AAC,D83139936AAD,ZTEGDD3141CD$ZTE3ANNR8C10135,3891484F7491,3891484F7492,ZTEGDB08A807$ZTE3ANNQ7T01224,C4EBFF8F07F0,C4EBFF8F07F1,ZTEGD70AFCBE$ZTE3ANNQ7501278,C4EBFF8B1130,C4EBFF8B1131,ZTEGD70A539E$ZTE3ANNQ9J31475,843C992EB2E7,843C992EB2E8,ZTEGD7BB839E$ZTE3ANNRAD30527,D89A0DB0A5DD,D89A0DB0A5DE,ZTEGDB17734A$ZTE3ANNQ8M35247,843C99220205,843C99220206,ZTEGD7BAD11C$ZTE3ANNQ9J35645,843C992F14A3,843C992F14A4,ZTEGD7BB93E8$ZTE3ANNR7B14992,3891484A4C07,3891484A4C08,ZTEGDB07CBF0$ZTE3ANNR3J07348,F4E84F86FA98,F4E84F86FA99,ZTEGD97B7E7E$ZTE3ANNR1Y18106,14CA56CE52D7,14CA56CE52D8,ZTEGD970BD15$ZTE3ANNQ9334656,843C9935C17D,843C9935C17E,ZTEGD7BC4357$ZTE3ANNRCP63941,6C11BA6F056D,6C11BA6F056E,ZTEGDC703A58$ZTE3ANNR9W20576,D89A0DAA3E63,D89A0DAA3E64,ZTEGDB16620B$ZTE3ANNQ6M07006,C4EBFF890604,C4EBFF890605,ZTEGD709FC6C$ZTE3ANNR9W39230,D89A0DABF397,D89A0DABF398,ZTEGDB16AAE9$ZTE3ANNRAM41463,5872C98B0403,5872C98B0404,ZTEGDC60A1F6$ZTE3ANNQ5N12893,3CF9F0ADF3A4,3CF9F0ADF3A5,ZTEGD641E8A4$ZTE3ANNRCP61987,6C11BA6ED7A1,6C11BA6ED7A2,ZTEGDC7032B6$ZTE3ANNR8C09861,3891484F6E25,3891484F6E26,ZTEGDB08A6F5$ZTE3ANNQ4N15093,3CF9F0A9F36C,3CF9F0A9F36D,ZTEGD6413DF0$ZTE3ANNR9W45636,D89A0DAC89BB,D89A0DAC89BC,ZTEGDB16C3EF$ZTE3ANNQ4410034,3CF9F0AC4A0A,3CF9F0AC4A0B,ZTEGD641A1B5', '',0323,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":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-05-29 14:58:17 Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (39193, 413, '246126577385', '',0172,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":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-05-29 11:26:09 Database: contagem User: intelifix Remote: [local] Application: [unknown]
Queries that waited the most
Rank Wait time Query 1 2m30s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-05-29 07:27:36 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 1s879ms SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (39513, 407, '249154841,24767DA8984C', '',035,00,'[{"item":"0","qrcode":""}]','', '', 00);[ Date: 2026-05-29 14:58:17 - Database: contagem - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 4,336 Total read queries
- 1,438 Total write queries
Queries by database
Key values
- rio Main database
- 5,274 Requests
- 6h10m47s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 5,976 Requests
User Request type Count Duration etiquetas Total 6 1s128ms select 6 1s128ms intelifix Total 5,976 6h27m41s copy to 268 41m9s ddl 1,170 47m9s others 295 30m17s select 4,243 4h29m5s lenon Total 88 58s152ms others 1 167ms select 87 57s985ms Duration by user
Key values
- 6h27m41s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 6 1s128ms select 6 1s128ms intelifix Total 5,976 6h27m41s copy to 268 41m9s ddl 1,170 47m9s others 295 30m17s select 4,243 4h29m5s lenon Total 88 58s152ms others 1 167ms select 87 57s985ms Queries by host
Key values
- [local] Main host
- 6,067 Requests
- 6h28m40s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 5,315 Requests
- 3h15m59s ([unknown])
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-05-29 09:25:13 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 3,606 100-500ms duration
Slowest individual queries
Rank Duration Query 1 8m49s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-29 10:13:50 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 8m23s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-29 07:13:25 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 8m SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-29 15:13:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 7m43s analyze verbose;[ Date: 2026-05-29 05:07:44 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 7m28s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-29 11:12:29 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 6m39s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-29 16:11:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 6m34s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-29 08:11:35 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 6m20s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-29 09:11:21 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 6m15s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-29 12:11:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 6m14s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-29 13:11:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 6m14s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-29 14:11:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 6m9s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-29 17:11:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 6m5s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-29 22:11:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m44s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-29 18:10:45 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m36s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-29 19:10:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m28s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-29 20:10:30 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m27s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-29 21:10:29 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 4m41s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 024948, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');[ Date: 2026-05-29 15:20:58 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 4m39s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 024941, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');[ Date: 2026-05-29 14:22:46 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 4m26s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 024899, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');[ Date: 2026-05-29 07:27:36 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1h46m8s 32 1s9ms 8m49s 3m19s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 29 07 2 8m26s 4m13s 08 2 6m36s 3m18s 09 2 6m21s 3m10s 10 2 8m53s 4m26s 11 2 7m34s 3m47s 12 2 6m16s 3m8s 13 2 6m16s 3m8s 14 2 6m15s 3m7s 15 2 8m5s 4m2s 16 2 6m42s 3m21s 17 2 6m11s 3m5s 18 2 5m45s 2m52s 19 2 5m37s 2m48s 20 2 5m30s 2m45s 21 2 5m28s 2m44s 22 2 6m6s 3m3s [ User: intelifix - Total duration: 1h46m8s - Times executed: 32 ]
[ Application: psql - Total duration: 1h46m8s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-29 10:13:50 Duration: 8m49s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-29 07:13:25 Duration: 8m23s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-29 15:13:02 Duration: 8m Database: rio User: intelifix Remote: [local] Application: psql
2 1h34m15s 256 154ms 4m41s 22s90ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 29 07 27 12m30s 27s783ms 08 29 12m20s 25s535ms 09 29 12m27s 25s759ms 10 32 12m33s 23s560ms 11 38 12m5s 19s103ms 12 2 3m43s 1m51s 13 4 26s713ms 6s678ms 14 24 5m 12s513ms 15 43 14m5s 19s664ms 16 27 9m 20s32ms 17 1 620ms 620ms [ User: intelifix - Total duration: 1h34m15s - Times executed: 256 ]
[ Application: [unknown] - Total duration: 1h34m15s - Times executed: 256 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 024948, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-05-29 15:20:58 Duration: 4m41s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 024941, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-05-29 14:22:46 Duration: 4m39s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 024899, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-05-29 07:27:36 Duration: 4m26s Database: rio User: intelifix Remote: [local] Application: [unknown]
3 18m54s 27 33s424ms 1m12s 42s15ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 29 09 1 1m12s 1m12s 10 3 2m1s 40s391ms 13 4 2m58s 44s728ms 14 7 4m30s 38s660ms 15 6 4m27s 44s505ms 16 6 3m44s 37s421ms [ User: intelifix - Total duration: 18m54s - Times executed: 27 ]
[ Application: [unknown] - Total duration: 18m54s - Times executed: 27 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-05-29', 0175, '', '', 0, 6, '2026-05-01');
Date: 2026-05-29 09:17:47 Duration: 1m12s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-05-29', 0395, '', '', 0, 6, '2026-05-01');
Date: 2026-05-29 13:04:28 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-05-29', 0173, '', '', 0, 6, '2026-05-01');
Date: 2026-05-29 15:05:24 Duration: 48s290ms Database: rio User: intelifix Remote: [local] Application: [unknown]
4 17m50s 1,354 150ms 4s964ms 790ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration May 29 07 114 54s668ms 479ms 08 214 2m14s 627ms 09 236 2m41s 686ms 10 200 2m19s 697ms 11 137 2m11s 958ms 12 49 31s891ms 650ms 13 31 38s338ms 1s236ms 14 130 2m18s 1s66ms 15 149 2m44s 1s105ms 16 75 53s902ms 718ms 17 19 20s976ms 1s104ms [ User: intelifix - Total duration: 17m50s - Times executed: 1354 ]
[ Application: [unknown] - Total duration: 17m50s - Times executed: 1354 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (39190, 413, '215704856973', '',077,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":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-05-29 11:24:03 Duration: 4s964ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (39548, 407, 'ZTE3ANNQ4410390,3CF9F0AC5262,3CF9F0AC5263,ZTEGD641A319$ZTE3ANNQ7L06042,C4EBFF8E1244,C4EBFF8E1245,ZTEGD70AD3CC$ZTE3ANNR3J07640,F4E84F870170,F4E84F870171,ZTEGD97B7FA2$ZTE3ANNQ7T01794,C4EBFF8F154C,C4EBFF8F154D,ZTEGD70AFEF8$ZTE3ANNRB737590,5872C991AA35,5872C991AA36,ZTEGDC61BDA9$ZTE3ANNT2V85886,D83139936BCC,D83139936BCD,ZTEGDD3141FD$ZTE3ANNT2V85838,D83139936AAC,D83139936AAD,ZTEGDD3141CD$ZTE3ANNR8C10135,3891484F7491,3891484F7492,ZTEGDB08A807$ZTE3ANNQ7T01224,C4EBFF8F07F0,C4EBFF8F07F1,ZTEGD70AFCBE$ZTE3ANNQ7501278,C4EBFF8B1130,C4EBFF8B1131,ZTEGD70A539E$ZTE3ANNQ9J31475,843C992EB2E7,843C992EB2E8,ZTEGD7BB839E$ZTE3ANNRAD30527,D89A0DB0A5DD,D89A0DB0A5DE,ZTEGDB17734A$ZTE3ANNQ8M35247,843C99220205,843C99220206,ZTEGD7BAD11C$ZTE3ANNQ9J35645,843C992F14A3,843C992F14A4,ZTEGD7BB93E8$ZTE3ANNR7B14992,3891484A4C07,3891484A4C08,ZTEGDB07CBF0$ZTE3ANNR3J07348,F4E84F86FA98,F4E84F86FA99,ZTEGD97B7E7E$ZTE3ANNR1Y18106,14CA56CE52D7,14CA56CE52D8,ZTEGD970BD15$ZTE3ANNQ9334656,843C9935C17D,843C9935C17E,ZTEGD7BC4357$ZTE3ANNRCP63941,6C11BA6F056D,6C11BA6F056E,ZTEGDC703A58$ZTE3ANNR9W20576,D89A0DAA3E63,D89A0DAA3E64,ZTEGDB16620B$ZTE3ANNQ6M07006,C4EBFF890604,C4EBFF890605,ZTEGD709FC6C$ZTE3ANNR9W39230,D89A0DABF397,D89A0DABF398,ZTEGDB16AAE9$ZTE3ANNRAM41463,5872C98B0403,5872C98B0404,ZTEGDC60A1F6$ZTE3ANNQ5N12893,3CF9F0ADF3A4,3CF9F0ADF3A5,ZTEGD641E8A4$ZTE3ANNRCP61987,6C11BA6ED7A1,6C11BA6ED7A2,ZTEGDC7032B6$ZTE3ANNR8C09861,3891484F6E25,3891484F6E26,ZTEGDB08A6F5$ZTE3ANNQ4N15093,3CF9F0A9F36C,3CF9F0A9F36D,ZTEGD6413DF0$ZTE3ANNR9W45636,D89A0DAC89BB,D89A0DAC89BC,ZTEGDB16C3EF$ZTE3ANNQ4410034,3CF9F0AC4A0A,3CF9F0AC4A0B,ZTEGD641A1B5', '',0323,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":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-05-29 14:58:17 Duration: 4s688ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (39193, 413, '246126577385', '',0172,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":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-05-29 11:26:09 Duration: 4s661ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
5 14m51s 83 8s255ms 34s245ms 10s742ms create table temp0000281251 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration May 29 10 15 2m26s 9s749ms 11 20 3m14s 9s714ms 14 18 3m53s 12s947ms 15 25 4m30s 10s838ms 16 5 47s127ms 9s425ms [ User: intelifix - Total duration: 14m51s - Times executed: 83 ]
[ Application: [unknown] - Total duration: 14m51s - Times executed: 83 ]
-
CREATE TABLE temp0000281251 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-29 14:15:52 Duration: 34s245ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281251 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-29 14:56:41 Duration: 14s774ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281251 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-29 14:57:42 Duration: 14s438ms Database: rio User: intelifix Remote: [local] Application: [unknown]
6 10m6s 2 2m22s 7m43s 5m3s analyze verbose;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration May 29 05 2 10m6s 5m3s [ User: intelifix - Total duration: 10m6s - Times executed: 2 ]
[ Application: psql - Total duration: 10m6s - Times executed: 2 ]
-
analyze verbose;
Date: 2026-05-29 05:07:44 Duration: 7m43s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-05-29 05:10:07 Duration: 2m22s Database: contagem User: intelifix Remote: [local] Application: psql
7 9m26s 32 443ms 56s791ms 17s688ms select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration May 29 07 2 58s193ms 29s96ms 08 2 31s177ms 15s588ms 09 2 30s331ms 15s165ms 10 2 51s608ms 25s804ms 11 2 35s674ms 17s837ms 12 2 32s640ms 16s320ms 13 2 31s113ms 15s556ms 14 2 35s279ms 17s639ms 15 2 37s898ms 18s949ms 16 2 34s616ms 17s308ms 17 2 36s771ms 18s385ms 18 2 27s524ms 13s762ms 19 2 29s688ms 14s844ms 20 2 35s225ms 17s612ms 21 2 30s582ms 15s291ms 22 2 27s710ms 13s855ms [ User: intelifix - Total duration: 9m26s - Times executed: 32 ]
[ Application: psql - Total duration: 9m26s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-29 07:14:22 Duration: 56s791ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-29 10:14:40 Duration: 49s887ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-29 15:13:39 Duration: 36s942ms Database: rio User: intelifix Remote: [local] Application: psql
8 9m22s 138 2s141ms 2m33s 4s74ms call rs_giga_triagem (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration May 29 00 6 21s164ms 3s527ms 01 6 17s268ms 2s878ms 02 6 14s896ms 2s482ms 03 6 16s424ms 2s737ms 04 6 15s634ms 2s605ms 05 6 15s68ms 2s511ms 06 6 14s534ms 2s422ms 07 6 2m48s 28s129ms 08 6 15s520ms 2s586ms 09 6 18s502ms 3s83ms 10 6 21s558ms 3s593ms 11 6 18s240ms 3s40ms 12 6 17s941ms 2s990ms 13 6 22s608ms 3s768ms 14 6 24s182ms 4s30ms 15 6 21s534ms 3s589ms 16 6 20s825ms 3s470ms 17 6 16s322ms 2s720ms 18 6 16s409ms 2s734ms 19 6 16s996ms 2s832ms 20 6 16s10ms 2s668ms 21 6 16s602ms 2s767ms 22 6 15s211ms 2s535ms [ User: intelifix - Total duration: 9m22s - Times executed: 138 ]
[ Application: psql - Total duration: 9m22s - Times executed: 138 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-29 07:27:38 Duration: 2m33s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-29 00:05:21 Duration: 8s435ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-29 13:05:08 Duration: 7s548ms Database: rio User: intelifix Remote: [local] Application: psql
9 8m14s 1,090 150ms 5s676ms 453ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration May 29 07 80 30s778ms 384ms 08 119 39s560ms 332ms 09 127 1m17s 608ms 10 119 53s207ms 447ms 11 124 51s953ms 418ms 13 89 42s835ms 481ms 14 215 1m24s 394ms 15 178 1m34s 532ms 16 39 18s916ms 485ms [ User: intelifix - Total duration: 8m14s - Times executed: 1090 ]
[ Application: [unknown] - Total duration: 8m14s - Times executed: 1090 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "243120", "modelo" : "189", "itens" : "44E9680089A8,44E9680133CA,44E96801352F,6CE87455C6C8,04E7959511F6,B0ECDD4B16B4,B0ECDD4B3D3B,6CE87400FE12,68E2094A02CE,345840EAD577,44E96800B2F6,30C50FB823D9,6CE8745774A1,B0ECDD4B4A53,FC73FB04AEB7", "usuario" : "405", "caixa" : "2916475", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-05-29 15:44:02 Duration: 5s676ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "227013", "modelo" : "295", "itens" : "229970955975,230052401433,229982838189,229978110221,229988646882,230005491333,229970615762,230035540214,230027717889,230001146789,229971512831,229980245254,230026318089,230029264045,229990002234,229976893951,229991203956,230031587885,229982725575,229973155662", "usuario" : "405", "caixa" : "2725837", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-05-29 09:40:09 Duration: 2s695ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "104485", "modelo" : "34", "itens" : "216654457090,216488655050,216330311326,216575043246,216373964351,216325418591,216656120407,216593233450,216325875561", "usuario" : "405", "caixa" : "1220626", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-05-29 10:47:04 Duration: 2s588ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 7m4s 42 7s832ms 30s458ms 10s104ms create table temp0000281211 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration May 29 07 17 3m4s 10s873ms 08 16 2m32s 9s530ms 09 9 1m27s 9s673ms [ User: intelifix - Total duration: 7m4s - Times executed: 42 ]
[ Application: [unknown] - Total duration: 7m4s - Times executed: 42 ]
-
CREATE TABLE temp0000281211 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-29 07:21:32 Duration: 30s458ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281211 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-29 08:00:12 Duration: 12s854ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281211 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-29 09:18:26 Duration: 11s459ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 6m13s 104 179ms 12s172ms 3s587ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration May 29 00 6 18s144ms 3s24ms 01 5 9s522ms 1s904ms 02 5 7s49ms 1s409ms 03 5 8s707ms 1s741ms 04 6 8s456ms 1s409ms 05 5 11s797ms 2s359ms 06 5 10s703ms 2s140ms 07 6 28s178ms 4s696ms 08 6 29s807ms 4s967ms 09 6 30s922ms 5s153ms 10 6 32s513ms 5s418ms 11 6 40s776ms 6s796ms 12 6 21s56ms 3s509ms 13 5 12s311ms 2s462ms 14 6 36s907ms 6s151ms 15 6 41s786ms 6s964ms 16 3 8s444ms 2s814ms 21 5 6s399ms 1s279ms 22 6 9s625ms 1s604ms [ User: intelifix - Total duration: 6m13s - Times executed: 104 ]
[ Application: psql - Total duration: 6m13s - Times executed: 104 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-05-29 00:05:13 Duration: 12s172ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-05-29 11:35:10 Duration: 8s851ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-05-29 11:15:10 Duration: 8s509ms Database: rio User: intelifix Remote: [local] Application: psql
12 5m56s 37 7s936ms 11s877ms 9s634ms create table temp0000281227 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration May 29 07 3 28s546ms 9s515ms 08 6 58s102ms 9s683ms 09 10 1m36s 9s692ms 10 12 1m58s 9s851ms 11 6 54s668ms 9s111ms [ User: intelifix - Total duration: 5m56s - Times executed: 37 ]
[ Application: [unknown] - Total duration: 5m56s - Times executed: 37 ]
-
CREATE TABLE temp0000281227 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-29 09:25:32 Duration: 11s877ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281227 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-29 10:40:24 Duration: 11s732ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281227 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-29 09:24:42 Duration: 11s655ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 3m38s 45 834ms 18s288ms 4s854ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration May 29 08 3 25s163ms 8s387ms 09 3 19s778ms 6s592ms 10 3 24s308ms 8s102ms 11 3 28s833ms 9s611ms 12 3 5s920ms 1s973ms 13 3 9s451ms 3s150ms 14 3 20s686ms 6s895ms 15 3 36s402ms 12s134ms 16 3 28s138ms 9s379ms 17 3 2s925ms 975ms 18 3 4s556ms 1s518ms 19 3 3s144ms 1s48ms 20 3 2s838ms 946ms 21 3 3s121ms 1s40ms 22 3 3s198ms 1s66ms [ User: intelifix - Total duration: 3m38s - Times executed: 45 ]
[ Application: psql - Total duration: 3m38s - Times executed: 45 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-05-29 15:40:19 Duration: 18s288ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-05-29 16:20:14 Duration: 13s475ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-05-29 16:00:14 Duration: 13s10ms Database: rio User: intelifix Remote: [local] Application: psql
14 3m22s 59 199ms 1m11s 3s433ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration May 29 07 8 15s975ms 1s996ms 08 9 12s317ms 1s368ms 09 6 9s671ms 1s611ms 10 9 1m33s 10s363ms 11 9 39s461ms 4s384ms 14 7 26s815ms 3s830ms 15 9 4s385ms 487ms 16 2 684ms 342ms [ User: intelifix - Total duration: 3m22s - Times executed: 59 ]
[ Application: psql - Total duration: 3m22s - Times executed: 59 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 506); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (024927);
Date: 2026-05-29 10:41:44 Duration: 1m11s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 452); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (024937);
Date: 2026-05-29 11:41:24 Duration: 34s729ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 506); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (024942);
Date: 2026-05-29 14:28:37 Duration: 23s845ms Database: rio User: intelifix Remote: [local] Application: psql
15 3m1s 2 1m23s 1m37s 1m30s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration May 29 20 1 1m23s 1m23s 23 1 1m37s 1m37s [ User: intelifix - Total duration: 3m1s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 3m1s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-29 23:41:31 Duration: 1m37s 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-29 20:08:17 Duration: 1m23s Database: rio User: intelifix Remote: [local] Application: pg_dump
16 2m59s 26 5s95ms 18s186ms 6s915ms create table temp0000281251 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 29 10 4 23s972ms 5s993ms 14 12 1m19s 6s619ms 15 4 28s345ms 7s86ms 16 6 48s56ms 8s9ms [ User: intelifix - Total duration: 2m59s - Times executed: 26 ]
[ Application: [unknown] - Total duration: 2m59s - Times executed: 26 ]
-
CREATE TABLE temp0000281251 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"24-05-2026", "ate" :"29-05-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-05-29 16:18:31 Duration: 18s186ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281251 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"24-05-2026", "ate" :"29-05-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-05-29 14:58:31 Duration: 8s670ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281251 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"24-05-2026", "ate" :"29-05-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-05-29 15:38:32 Duration: 7s890ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 2m20s 178 151ms 19s290ms 790ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration May 29 07 22 6s907ms 313ms 08 20 7s59ms 352ms 09 14 1m16s 5s455ms 10 20 9s353ms 467ms 11 27 10s163ms 376ms 13 1 338ms 338ms 14 15 5s588ms 372ms 15 32 14s511ms 453ms 16 27 10s346ms 383ms [ User: intelifix - Total duration: 2m20s - Times executed: 178 ]
[ Application: [unknown] - Total duration: 2m20s - Times executed: 178 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (037595) LIMIT 1;
Date: 2026-05-29 09:35:35 Duration: 19s290ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (037949) LIMIT 1;
Date: 2026-05-29 09:34:23 Duration: 10s241ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (037951) LIMIT 1;
Date: 2026-05-29 09:35:05 Duration: 10s96ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
18 2m7s 2 21s973ms 1m45s 1m3s 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 #18
Day Hour Count Duration Avg duration May 29 23 2 2m7s 1m3s [ User: intelifix - Total duration: 2m7s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m7s - 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-29 23:15:44 Duration: 1m45s 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-29 23:43:21 Duration: 21s973ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
19 1m59s 2 58s397ms 1m 59s618ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration May 29 20 1 1m 1m 23 1 58s397ms 58s397ms [ User: intelifix - Total duration: 1m59s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m59s - Times executed: 2 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-29 20:05:21 Duration: 1m Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-29 23:18:53 Duration: 58s397ms Database: rio User: intelifix Remote: [local] Application: pg_dump
20 1m52s 2 20s311ms 1m31s 56s147ms 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 #20
Day Hour Count Duration Avg duration May 29 23 2 1m52s 56s147ms [ User: intelifix - Total duration: 1m52s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m52s - 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-29 23:12:45 Duration: 1m31s 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-29 23:42:39 Duration: 20s311ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,354 17m50s 150ms 4s964ms 790ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 29 07 114 54s668ms 479ms 08 214 2m14s 627ms 09 236 2m41s 686ms 10 200 2m19s 697ms 11 137 2m11s 958ms 12 49 31s891ms 650ms 13 31 38s338ms 1s236ms 14 130 2m18s 1s66ms 15 149 2m44s 1s105ms 16 75 53s902ms 718ms 17 19 20s976ms 1s104ms [ User: intelifix - Total duration: 17m50s - Times executed: 1354 ]
[ Application: [unknown] - Total duration: 17m50s - Times executed: 1354 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (39190, 413, '215704856973', '',077,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":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-05-29 11:24:03 Duration: 4s964ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (39548, 407, 'ZTE3ANNQ4410390,3CF9F0AC5262,3CF9F0AC5263,ZTEGD641A319$ZTE3ANNQ7L06042,C4EBFF8E1244,C4EBFF8E1245,ZTEGD70AD3CC$ZTE3ANNR3J07640,F4E84F870170,F4E84F870171,ZTEGD97B7FA2$ZTE3ANNQ7T01794,C4EBFF8F154C,C4EBFF8F154D,ZTEGD70AFEF8$ZTE3ANNRB737590,5872C991AA35,5872C991AA36,ZTEGDC61BDA9$ZTE3ANNT2V85886,D83139936BCC,D83139936BCD,ZTEGDD3141FD$ZTE3ANNT2V85838,D83139936AAC,D83139936AAD,ZTEGDD3141CD$ZTE3ANNR8C10135,3891484F7491,3891484F7492,ZTEGDB08A807$ZTE3ANNQ7T01224,C4EBFF8F07F0,C4EBFF8F07F1,ZTEGD70AFCBE$ZTE3ANNQ7501278,C4EBFF8B1130,C4EBFF8B1131,ZTEGD70A539E$ZTE3ANNQ9J31475,843C992EB2E7,843C992EB2E8,ZTEGD7BB839E$ZTE3ANNRAD30527,D89A0DB0A5DD,D89A0DB0A5DE,ZTEGDB17734A$ZTE3ANNQ8M35247,843C99220205,843C99220206,ZTEGD7BAD11C$ZTE3ANNQ9J35645,843C992F14A3,843C992F14A4,ZTEGD7BB93E8$ZTE3ANNR7B14992,3891484A4C07,3891484A4C08,ZTEGDB07CBF0$ZTE3ANNR3J07348,F4E84F86FA98,F4E84F86FA99,ZTEGD97B7E7E$ZTE3ANNR1Y18106,14CA56CE52D7,14CA56CE52D8,ZTEGD970BD15$ZTE3ANNQ9334656,843C9935C17D,843C9935C17E,ZTEGD7BC4357$ZTE3ANNRCP63941,6C11BA6F056D,6C11BA6F056E,ZTEGDC703A58$ZTE3ANNR9W20576,D89A0DAA3E63,D89A0DAA3E64,ZTEGDB16620B$ZTE3ANNQ6M07006,C4EBFF890604,C4EBFF890605,ZTEGD709FC6C$ZTE3ANNR9W39230,D89A0DABF397,D89A0DABF398,ZTEGDB16AAE9$ZTE3ANNRAM41463,5872C98B0403,5872C98B0404,ZTEGDC60A1F6$ZTE3ANNQ5N12893,3CF9F0ADF3A4,3CF9F0ADF3A5,ZTEGD641E8A4$ZTE3ANNRCP61987,6C11BA6ED7A1,6C11BA6ED7A2,ZTEGDC7032B6$ZTE3ANNR8C09861,3891484F6E25,3891484F6E26,ZTEGDB08A6F5$ZTE3ANNQ4N15093,3CF9F0A9F36C,3CF9F0A9F36D,ZTEGD6413DF0$ZTE3ANNR9W45636,D89A0DAC89BB,D89A0DAC89BC,ZTEGDB16C3EF$ZTE3ANNQ4410034,3CF9F0AC4A0A,3CF9F0AC4A0B,ZTEGD641A1B5', '',0323,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":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-05-29 14:58:17 Duration: 4s688ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (39193, 413, '246126577385', '',0172,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":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-05-29 11:26:09 Duration: 4s661ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
2 1,090 8m14s 150ms 5s676ms 453ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 29 07 80 30s778ms 384ms 08 119 39s560ms 332ms 09 127 1m17s 608ms 10 119 53s207ms 447ms 11 124 51s953ms 418ms 13 89 42s835ms 481ms 14 215 1m24s 394ms 15 178 1m34s 532ms 16 39 18s916ms 485ms [ User: intelifix - Total duration: 8m14s - Times executed: 1090 ]
[ Application: [unknown] - Total duration: 8m14s - Times executed: 1090 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "243120", "modelo" : "189", "itens" : "44E9680089A8,44E9680133CA,44E96801352F,6CE87455C6C8,04E7959511F6,B0ECDD4B16B4,B0ECDD4B3D3B,6CE87400FE12,68E2094A02CE,345840EAD577,44E96800B2F6,30C50FB823D9,6CE8745774A1,B0ECDD4B4A53,FC73FB04AEB7", "usuario" : "405", "caixa" : "2916475", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-05-29 15:44:02 Duration: 5s676ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "227013", "modelo" : "295", "itens" : "229970955975,230052401433,229982838189,229978110221,229988646882,230005491333,229970615762,230035540214,230027717889,230001146789,229971512831,229980245254,230026318089,230029264045,229990002234,229976893951,229991203956,230031587885,229982725575,229973155662", "usuario" : "405", "caixa" : "2725837", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-05-29 09:40:09 Duration: 2s695ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "104485", "modelo" : "34", "itens" : "216654457090,216488655050,216330311326,216575043246,216373964351,216325418591,216656120407,216593233450,216325875561", "usuario" : "405", "caixa" : "1220626", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-05-29 10:47:04 Duration: 2s588ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 256 1h34m15s 154ms 4m41s 22s90ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 29 07 27 12m30s 27s783ms 08 29 12m20s 25s535ms 09 29 12m27s 25s759ms 10 32 12m33s 23s560ms 11 38 12m5s 19s103ms 12 2 3m43s 1m51s 13 4 26s713ms 6s678ms 14 24 5m 12s513ms 15 43 14m5s 19s664ms 16 27 9m 20s32ms 17 1 620ms 620ms [ User: intelifix - Total duration: 1h34m15s - Times executed: 256 ]
[ Application: [unknown] - Total duration: 1h34m15s - Times executed: 256 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 024948, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-05-29 15:20:58 Duration: 4m41s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 024941, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-05-29 14:22:46 Duration: 4m39s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 024899, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-05-29 07:27:36 Duration: 4m26s Database: rio User: intelifix Remote: [local] Application: [unknown]
4 184 32s341ms 150ms 395ms 175ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration May 29 04 1 187ms 187ms 07 1 171ms 171ms 09 2 325ms 162ms 10 7 1s393ms 199ms 11 14 2s400ms 171ms 12 6 987ms 164ms 13 6 972ms 162ms 14 25 4s617ms 184ms 15 90 15s854ms 176ms 16 32 5s429ms 169ms [ User: intelifix - Total duration: 32s341ms - Times executed: 184 ]
[ Application: [unknown] - Total duration: 32s341ms - Times executed: 184 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "312", "data-de" : "2026-05-29", "data-ate" : "2026-05-29", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 320 }');
Date: 2026-05-29 14:31:00 Duration: 395ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "312", "data-de" : "2026-05-29", "data-ate" : "2026-05-29", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 320 }');
Date: 2026-05-29 15:12:53 Duration: 366ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "312", "data-de" : "2026-05-29", "data-ate" : "2026-05-29", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 320 }');
Date: 2026-05-29 15:50:08 Duration: 288ms Database: rio User: intelifix Remote: [local] Application: [unknown]
5 178 2m20s 151ms 19s290ms 790ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration May 29 07 22 6s907ms 313ms 08 20 7s59ms 352ms 09 14 1m16s 5s455ms 10 20 9s353ms 467ms 11 27 10s163ms 376ms 13 1 338ms 338ms 14 15 5s588ms 372ms 15 32 14s511ms 453ms 16 27 10s346ms 383ms [ User: intelifix - Total duration: 2m20s - Times executed: 178 ]
[ Application: [unknown] - Total duration: 2m20s - Times executed: 178 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (037595) LIMIT 1;
Date: 2026-05-29 09:35:35 Duration: 19s290ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (037949) LIMIT 1;
Date: 2026-05-29 09:34:23 Duration: 10s241ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (037951) LIMIT 1;
Date: 2026-05-29 09:35:05 Duration: 10s96ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
6 164 1m3s 152ms 1s79ms 388ms select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration May 29 09 92 42s387ms 460ms 10 19 7s164ms 377ms 11 26 7s176ms 276ms 13 8 1s690ms 211ms 15 9 2s968ms 329ms 16 9 2s98ms 233ms 17 1 155ms 155ms [ User: intelifix - Total duration: 1m3s - Times executed: 164 ]
[ Application: [unknown] - Total duration: 1m3s - Times executed: 164 ]
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (103107);
Date: 2026-05-29 09:25:25 Duration: 1s79ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (103107);
Date: 2026-05-29 09:25:59 Duration: 818ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (37951);
Date: 2026-05-29 10:40:11 Duration: 812ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
7 164 26s798ms 150ms 245ms 163ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration May 29 04 1 198ms 198ms 07 8 1s291ms 161ms 08 12 1s941ms 161ms 09 13 2s176ms 167ms 10 18 2s807ms 155ms 11 16 2s544ms 159ms 12 2 323ms 161ms 13 19 3s175ms 167ms 14 34 5s673ms 166ms 15 35 5s684ms 162ms 16 6 981ms 163ms [ User: intelifix - Total duration: 26s798ms - Times executed: 164 ]
[ Application: [unknown] - Total duration: 26s798ms - Times executed: 164 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 034;
Date: 2026-05-29 14:05:29 Duration: 245ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-05-29 14:01:00 Duration: 215ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 034;
Date: 2026-05-29 09:58:07 Duration: 210ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 138 9m22s 2s141ms 2m33s 4s74ms call rs_giga_triagem (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration May 29 00 6 21s164ms 3s527ms 01 6 17s268ms 2s878ms 02 6 14s896ms 2s482ms 03 6 16s424ms 2s737ms 04 6 15s634ms 2s605ms 05 6 15s68ms 2s511ms 06 6 14s534ms 2s422ms 07 6 2m48s 28s129ms 08 6 15s520ms 2s586ms 09 6 18s502ms 3s83ms 10 6 21s558ms 3s593ms 11 6 18s240ms 3s40ms 12 6 17s941ms 2s990ms 13 6 22s608ms 3s768ms 14 6 24s182ms 4s30ms 15 6 21s534ms 3s589ms 16 6 20s825ms 3s470ms 17 6 16s322ms 2s720ms 18 6 16s409ms 2s734ms 19 6 16s996ms 2s832ms 20 6 16s10ms 2s668ms 21 6 16s602ms 2s767ms 22 6 15s211ms 2s535ms [ User: intelifix - Total duration: 9m22s - Times executed: 138 ]
[ Application: psql - Total duration: 9m22s - Times executed: 138 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-29 07:27:38 Duration: 2m33s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-29 00:05:21 Duration: 8s435ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-29 13:05:08 Duration: 7s548ms Database: rio User: intelifix Remote: [local] Application: psql
9 138 25s743ms 150ms 379ms 186ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration May 29 03 8 1s621ms 202ms 04 19 3s778ms 198ms 05 1 191ms 191ms 07 13 2s425ms 186ms 08 8 1s406ms 175ms 09 20 3s679ms 183ms 10 8 1s423ms 177ms 11 17 2s991ms 175ms 12 2 374ms 187ms 14 21 3s769ms 179ms 15 15 3s58ms 203ms 16 6 1s23ms 170ms [ User: intelifix - Total duration: 25s743ms - Times executed: 138 ]
[ Application: [unknown] - Total duration: 25s743ms - Times executed: 138 ]
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '241647364056,241602684252,241668260215,241731236270,241727009517,241664801830,241671515066,241664803648,241729515878,241667583448,241667215757,241654334444,230048905165,241713741926,241680328080,241610945664,241619744761,241620655164,241632316268,241730944143,241654595962,241673277482,241673342540', NULL, NULL, 0320, 00);
Date: 2026-05-29 04:19:08 Duration: 379ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (407, 5, '113', 3, '241692710525,241681228405,241655613649,241703507088,241714664451,241712051436,241656356482,241695092833,241607894042,241676570420,241667081929,241661553039,241667177897,241712054567,241693050008,241620245371,241667788091,241715634456,241664247072,241604517281,241603435571,241697121415', NULL, NULL, 0320, 00);
Date: 2026-05-29 15:30:07 Duration: 364ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (405, 5, '113', 3, '216595358910,216465544153,216433580821,216325223848,216677358191,216490565764,216421712749,216466257690,216598554665,216493910323,216491724755,216595066681,216495309011,216578685868', NULL, NULL, 034, 00);
Date: 2026-05-29 15:25:25 Duration: 351ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 104 6m13s 179ms 12s172ms 3s587ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration May 29 00 6 18s144ms 3s24ms 01 5 9s522ms 1s904ms 02 5 7s49ms 1s409ms 03 5 8s707ms 1s741ms 04 6 8s456ms 1s409ms 05 5 11s797ms 2s359ms 06 5 10s703ms 2s140ms 07 6 28s178ms 4s696ms 08 6 29s807ms 4s967ms 09 6 30s922ms 5s153ms 10 6 32s513ms 5s418ms 11 6 40s776ms 6s796ms 12 6 21s56ms 3s509ms 13 5 12s311ms 2s462ms 14 6 36s907ms 6s151ms 15 6 41s786ms 6s964ms 16 3 8s444ms 2s814ms 21 5 6s399ms 1s279ms 22 6 9s625ms 1s604ms [ User: intelifix - Total duration: 6m13s - Times executed: 104 ]
[ Application: psql - Total duration: 6m13s - Times executed: 104 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-05-29 00:05:13 Duration: 12s172ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-05-29 11:35:10 Duration: 8s851ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-05-29 11:15:10 Duration: 8s509ms Database: rio User: intelifix Remote: [local] Application: psql
11 86 23s320ms 151ms 4s800ms 271ms create table temp0000281189 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration May 29 07 3 5s591ms 1s863ms 08 13 5s64ms 389ms 09 15 2s815ms 187ms 10 24 4s144ms 172ms 11 25 4s645ms 185ms 12 6 1s59ms 176ms [ User: intelifix - Total duration: 23s320ms - Times executed: 86 ]
[ Application: [unknown] - Total duration: 23s320ms - Times executed: 86 ]
-
CREATE TABLE temp0000281189 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"24-05-2026", "ate" :"29-05-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-05-29 07:02:23 Duration: 4s800ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281189 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"24-05-2026", "ate" :"29-05-2026", "nota-fiscal":"1081", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-05-29 08:13:11 Duration: 508ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281189 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"24-05-2026", "ate" :"29-05-2026", "nota-fiscal":"1081", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-05-29 09:03:59 Duration: 485ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 83 14m51s 8s255ms 34s245ms 10s742ms create table temp0000281251 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration May 29 10 15 2m26s 9s749ms 11 20 3m14s 9s714ms 14 18 3m53s 12s947ms 15 25 4m30s 10s838ms 16 5 47s127ms 9s425ms [ User: intelifix - Total duration: 14m51s - Times executed: 83 ]
[ Application: [unknown] - Total duration: 14m51s - Times executed: 83 ]
-
CREATE TABLE temp0000281251 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-29 14:15:52 Duration: 34s245ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281251 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-29 14:56:41 Duration: 14s774ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281251 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-29 14:57:42 Duration: 14s438ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 81 36s227ms 263ms 768ms 447ms 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 #13
Day Hour Count Duration Avg duration May 29 03 2 807ms 403ms 04 3 1s355ms 451ms 05 1 339ms 339ms 06 2 854ms 427ms 07 7 3s414ms 487ms 08 8 3s950ms 493ms 09 7 2s792ms 398ms 10 10 3s967ms 396ms 11 6 2s537ms 422ms 12 2 920ms 460ms 13 7 3s251ms 464ms 14 8 3s213ms 401ms 15 9 4s547ms 505ms 16 7 3s385ms 483ms 17 1 390ms 390ms 21 1 497ms 497ms [ User: lenon - Total duration: 36s227ms - Times executed: 81 ]
[ Application: [unknown] - Total duration: 36s227ms - Times executed: 81 ]
-
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-29 08:05:39 Duration: 768ms 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-29 15:07:01 Duration: 737ms Database: contagem 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-29 07:35:33 Duration: 712ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
14 75 41s346ms 341ms 836ms 551ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration May 29 03 1 647ms 647ms 04 3 1s672ms 557ms 05 1 476ms 476ms 06 1 595ms 595ms 07 7 4s19ms 574ms 08 8 4s698ms 587ms 09 7 3s441ms 491ms 10 9 4s341ms 482ms 11 6 3s146ms 524ms 12 1 620ms 620ms 13 7 3s977ms 568ms 14 8 4s183ms 522ms 15 9 5s453ms 605ms 16 6 3s608ms 601ms 17 1 463ms 463ms [ User: intelifix - Total duration: 41s346ms - Times executed: 75 ]
[ Application: [unknown] - Total duration: 41s346ms - Times executed: 75 ]
-
select * from rs_menu_grants (433, 18, 1);
Date: 2026-05-29 08:05:39 Duration: 836ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (406, 72, 1);
Date: 2026-05-29 15:07:01 Duration: 830ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (433, 18, 1);
Date: 2026-05-29 07:35:33 Duration: 808ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 74 22s652ms 153ms 867ms 306ms select (rs_fast_barras (b.eq_id)).* from caixa_itens a inner join fluxos b on b.flu_id = a.flu_id where a.cai_id = ? order by a.cai_ordem;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration May 29 07 4 826ms 206ms 08 2 502ms 251ms 09 9 3s287ms 365ms 10 9 2s201ms 244ms 11 11 3s74ms 279ms 13 7 1s816ms 259ms 14 18 5s287ms 293ms 15 12 4s682ms 390ms 16 2 973ms 486ms [ User: intelifix - Total duration: 22s652ms - Times executed: 74 ]
[ Application: [unknown] - Total duration: 22s652ms - Times executed: 74 ]
-
SELECT (RS_FAST_BARRAS (B.EQ_ID)).* FROM CAIXA_ITENS A INNER JOIN FLUXOS B ON B.FLU_ID = A.FLU_ID WHERE A.CAI_ID = 2981120 ORDER BY A.CAI_ORDEM;
Date: 2026-05-29 15:16:02 Duration: 867ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT (RS_FAST_BARRAS (B.EQ_ID)).* FROM CAIXA_ITENS A INNER JOIN FLUXOS B ON B.FLU_ID = A.FLU_ID WHERE A.CAI_ID = 2879975 ORDER BY A.CAI_ORDEM;
Date: 2026-05-29 16:15:51 Duration: 776ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT (RS_FAST_BARRAS (B.EQ_ID)).* FROM CAIXA_ITENS A INNER JOIN FLUXOS B ON B.FLU_ID = A.FLU_ID WHERE A.CAI_ID = 2755088 ORDER BY A.CAI_ORDEM;
Date: 2026-05-29 09:44:27 Duration: 767ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 65 23s508ms 159ms 4s278ms 361ms create table temp0000281191 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 29 07 12 10s622ms 885ms 08 10 2s258ms 225ms 09 20 4s783ms 239ms 10 22 5s564ms 252ms 11 1 279ms 279ms [ User: intelifix - Total duration: 23s508ms - Times executed: 65 ]
[ Application: [unknown] - Total duration: 23s508ms - Times executed: 65 ]
-
CREATE TABLE temp0000281191 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"24-05-2026", "ate" :"29-05-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-05-29 07:38:42 Duration: 4s278ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281191 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"24-05-2026", "ate" :"29-05-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-05-29 07:03:02 Duration: 4s223ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281191 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"24-05-2026", "ate" :"29-05-2026", "nota-fiscal":"98", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-05-29 10:36:49 Duration: 365ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 63 19s614ms 161ms 4s918ms 311ms create table temp0000281223 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration May 29 07 5 5s708ms 1s141ms 08 8 1s785ms 223ms 09 35 8s382ms 239ms 10 15 3s738ms 249ms [ User: intelifix - Total duration: 19s614ms - Times executed: 63 ]
[ Application: [unknown] - Total duration: 19s614ms - Times executed: 63 ]
-
CREATE TABLE temp0000281223 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"24-05-2026", "ate" :"29-05-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-05-29 07:33:56 Duration: 4s918ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281223 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"24-05-2026", "ate" :"29-05-2026", "nota-fiscal":"98", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-05-29 10:09:26 Duration: 327ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281223 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"24-05-2026", "ate" :"29-05-2026", "nota-fiscal":"98", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-05-29 09:39:26 Duration: 312ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 59 3m22s 199ms 1m11s 3s433ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 29 07 8 15s975ms 1s996ms 08 9 12s317ms 1s368ms 09 6 9s671ms 1s611ms 10 9 1m33s 10s363ms 11 9 39s461ms 4s384ms 14 7 26s815ms 3s830ms 15 9 4s385ms 487ms 16 2 684ms 342ms [ User: intelifix - Total duration: 3m22s - Times executed: 59 ]
[ Application: psql - Total duration: 3m22s - Times executed: 59 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 506); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (024927);
Date: 2026-05-29 10:41:44 Duration: 1m11s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 452); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (024937);
Date: 2026-05-29 11:41:24 Duration: 34s729ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 506); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (024942);
Date: 2026-05-29 14:28:37 Duration: 23s845ms Database: rio User: intelifix Remote: [local] Application: psql
19 57 11s239ms 152ms 318ms 197ms create table temp0000281201 as select * from rs_baixas_lista (?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration May 29 07 9 1s890ms 210ms 08 14 2s731ms 195ms 09 9 1s786ms 198ms 10 8 1s573ms 196ms 11 17 3s257ms 191ms [ User: intelifix - Total duration: 11s239ms - Times executed: 57 ]
[ Application: [unknown] - Total duration: 11s239ms - Times executed: 57 ]
-
CREATE TABLE temp0000281201 AS SELECT * FROM RS_BAIXAS_LISTA (06, 00, 00, 0173, 00, '', '2026-05-27', '2026-05-29');
Date: 2026-05-29 07:17:06 Duration: 318ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281201 AS SELECT * FROM RS_BAIXAS_LISTA (06, 00, 00, 0173, 00, '', '2026-05-27', '2026-05-29');
Date: 2026-05-29 10:00:40 Duration: 258ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281201 AS SELECT * FROM RS_BAIXAS_LISTA (06, 00, 00, 0173, 00, '', '2026-05-27', '2026-05-29');
Date: 2026-05-29 09:25:44 Duration: 250ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 53 21s25ms 229ms 760ms 396ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 29 07 7 2s424ms 346ms 08 8 3s72ms 384ms 09 7 3s286ms 469ms 10 9 3s798ms 422ms 11 6 2s664ms 444ms 13 2 737ms 368ms 14 4 1s301ms 325ms 15 6 2s216ms 369ms 16 4 1s524ms 381ms [ User: intelifix - Total duration: 21s25ms - Times executed: 53 ]
[ Application: [unknown] - Total duration: 21s25ms - Times executed: 53 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-05-29 09:24:12 Duration: 760ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-05-29 11:56:33 Duration: 601ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-05-29 08:11:36 Duration: 578ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m22s 7m43s 5m3s 2 10m6s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 29 05 2 10m6s 5m3s [ User: intelifix - Total duration: 10m6s - Times executed: 2 ]
[ Application: psql - Total duration: 10m6s - Times executed: 2 ]
-
analyze verbose;
Date: 2026-05-29 05:07:44 Duration: 7m43s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-05-29 05:10:07 Duration: 2m22s Database: contagem User: intelifix Remote: [local] Application: psql
2 1s9ms 8m49s 3m19s 32 1h46m8s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 29 07 2 8m26s 4m13s 08 2 6m36s 3m18s 09 2 6m21s 3m10s 10 2 8m53s 4m26s 11 2 7m34s 3m47s 12 2 6m16s 3m8s 13 2 6m16s 3m8s 14 2 6m15s 3m7s 15 2 8m5s 4m2s 16 2 6m42s 3m21s 17 2 6m11s 3m5s 18 2 5m45s 2m52s 19 2 5m37s 2m48s 20 2 5m30s 2m45s 21 2 5m28s 2m44s 22 2 6m6s 3m3s [ User: intelifix - Total duration: 1h46m8s - Times executed: 32 ]
[ Application: psql - Total duration: 1h46m8s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-29 10:13:50 Duration: 8m49s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-29 07:13:25 Duration: 8m23s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-29 15:13:02 Duration: 8m Database: rio User: intelifix Remote: [local] Application: psql
3 1m23s 1m37s 1m30s 2 3m1s 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 29 20 1 1m23s 1m23s 23 1 1m37s 1m37s [ User: intelifix - Total duration: 3m1s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 3m1s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-29 23:41:31 Duration: 1m37s 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-29 20:08:17 Duration: 1m23s Database: rio User: intelifix Remote: [local] Application: pg_dump
4 21s973ms 1m45s 1m3s 2 2m7s 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 29 23 2 2m7s 1m3s [ User: intelifix - Total duration: 2m7s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m7s - 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-29 23:15:44 Duration: 1m45s 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-29 23:43:21 Duration: 21s973ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
5 58s397ms 1m 59s618ms 2 1m59s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration May 29 20 1 1m 1m 23 1 58s397ms 58s397ms [ User: intelifix - Total duration: 1m59s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m59s - Times executed: 2 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-29 20:05:21 Duration: 1m Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-29 23:18:53 Duration: 58s397ms Database: rio User: intelifix Remote: [local] Application: pg_dump
6 20s311ms 1m31s 56s147ms 2 1m52s 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 #6
Day Hour Count Duration Avg duration May 29 23 2 1m52s 56s147ms [ User: intelifix - Total duration: 1m52s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m52s - 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-29 23:12:45 Duration: 1m31s 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-29 23:42:39 Duration: 20s311ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
7 33s424ms 1m12s 42s15ms 27 18m54s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration May 29 09 1 1m12s 1m12s 10 3 2m1s 40s391ms 13 4 2m58s 44s728ms 14 7 4m30s 38s660ms 15 6 4m27s 44s505ms 16 6 3m44s 37s421ms [ User: intelifix - Total duration: 18m54s - Times executed: 27 ]
[ Application: [unknown] - Total duration: 18m54s - Times executed: 27 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-05-29', 0175, '', '', 0, 6, '2026-05-01');
Date: 2026-05-29 09:17:47 Duration: 1m12s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-05-29', 0395, '', '', 0, 6, '2026-05-01');
Date: 2026-05-29 13:04:28 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-05-29', 0173, '', '', 0, 6, '2026-05-01');
Date: 2026-05-29 15:05:24 Duration: 48s290ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 154ms 4m41s 22s90ms 256 1h34m15s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration May 29 07 27 12m30s 27s783ms 08 29 12m20s 25s535ms 09 29 12m27s 25s759ms 10 32 12m33s 23s560ms 11 38 12m5s 19s103ms 12 2 3m43s 1m51s 13 4 26s713ms 6s678ms 14 24 5m 12s513ms 15 43 14m5s 19s664ms 16 27 9m 20s32ms 17 1 620ms 620ms [ User: intelifix - Total duration: 1h34m15s - Times executed: 256 ]
[ Application: [unknown] - Total duration: 1h34m15s - Times executed: 256 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 024948, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-05-29 15:20:58 Duration: 4m41s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 024941, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-05-29 14:22:46 Duration: 4m39s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 024899, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-05-29 07:27:36 Duration: 4m26s Database: rio User: intelifix Remote: [local] Application: [unknown]
9 443ms 56s791ms 17s688ms 32 9m26s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration May 29 07 2 58s193ms 29s96ms 08 2 31s177ms 15s588ms 09 2 30s331ms 15s165ms 10 2 51s608ms 25s804ms 11 2 35s674ms 17s837ms 12 2 32s640ms 16s320ms 13 2 31s113ms 15s556ms 14 2 35s279ms 17s639ms 15 2 37s898ms 18s949ms 16 2 34s616ms 17s308ms 17 2 36s771ms 18s385ms 18 2 27s524ms 13s762ms 19 2 29s688ms 14s844ms 20 2 35s225ms 17s612ms 21 2 30s582ms 15s291ms 22 2 27s710ms 13s855ms [ User: intelifix - Total duration: 9m26s - Times executed: 32 ]
[ Application: psql - Total duration: 9m26s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-29 07:14:22 Duration: 56s791ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-29 10:14:40 Duration: 49s887ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-29 15:13:39 Duration: 36s942ms Database: rio User: intelifix Remote: [local] Application: psql
10 8s255ms 34s245ms 10s742ms 83 14m51s create table temp0000281251 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration May 29 10 15 2m26s 9s749ms 11 20 3m14s 9s714ms 14 18 3m53s 12s947ms 15 25 4m30s 10s838ms 16 5 47s127ms 9s425ms [ User: intelifix - Total duration: 14m51s - Times executed: 83 ]
[ Application: [unknown] - Total duration: 14m51s - Times executed: 83 ]
-
CREATE TABLE temp0000281251 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-29 14:15:52 Duration: 34s245ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281251 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-29 14:56:41 Duration: 14s774ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281251 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-29 14:57:42 Duration: 14s438ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 7s832ms 30s458ms 10s104ms 42 7m4s create table temp0000281211 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration May 29 07 17 3m4s 10s873ms 08 16 2m32s 9s530ms 09 9 1m27s 9s673ms [ User: intelifix - Total duration: 7m4s - Times executed: 42 ]
[ Application: [unknown] - Total duration: 7m4s - Times executed: 42 ]
-
CREATE TABLE temp0000281211 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-29 07:21:32 Duration: 30s458ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281211 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-29 08:00:12 Duration: 12s854ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281211 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-29 09:18:26 Duration: 11s459ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 7s936ms 11s877ms 9s634ms 37 5m56s create table temp0000281227 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration May 29 07 3 28s546ms 9s515ms 08 6 58s102ms 9s683ms 09 10 1m36s 9s692ms 10 12 1m58s 9s851ms 11 6 54s668ms 9s111ms [ User: intelifix - Total duration: 5m56s - Times executed: 37 ]
[ Application: [unknown] - Total duration: 5m56s - Times executed: 37 ]
-
CREATE TABLE temp0000281227 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-29 09:25:32 Duration: 11s877ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281227 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-29 10:40:24 Duration: 11s732ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281227 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-29 09:24:42 Duration: 11s655ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 5s95ms 18s186ms 6s915ms 26 2m59s create table temp0000281251 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration May 29 10 4 23s972ms 5s993ms 14 12 1m19s 6s619ms 15 4 28s345ms 7s86ms 16 6 48s56ms 8s9ms [ User: intelifix - Total duration: 2m59s - Times executed: 26 ]
[ Application: [unknown] - Total duration: 2m59s - Times executed: 26 ]
-
CREATE TABLE temp0000281251 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"24-05-2026", "ate" :"29-05-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-05-29 16:18:31 Duration: 18s186ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281251 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"24-05-2026", "ate" :"29-05-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-05-29 14:58:31 Duration: 8s670ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281251 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"24-05-2026", "ate" :"29-05-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-05-29 15:38:32 Duration: 7s890ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 834ms 18s288ms 4s854ms 45 3m38s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration May 29 08 3 25s163ms 8s387ms 09 3 19s778ms 6s592ms 10 3 24s308ms 8s102ms 11 3 28s833ms 9s611ms 12 3 5s920ms 1s973ms 13 3 9s451ms 3s150ms 14 3 20s686ms 6s895ms 15 3 36s402ms 12s134ms 16 3 28s138ms 9s379ms 17 3 2s925ms 975ms 18 3 4s556ms 1s518ms 19 3 3s144ms 1s48ms 20 3 2s838ms 946ms 21 3 3s121ms 1s40ms 22 3 3s198ms 1s66ms [ User: intelifix - Total duration: 3m38s - Times executed: 45 ]
[ Application: psql - Total duration: 3m38s - Times executed: 45 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-05-29 15:40:19 Duration: 18s288ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-05-29 16:20:14 Duration: 13s475ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-05-29 16:00:14 Duration: 13s10ms Database: rio User: intelifix Remote: [local] Application: psql
15 2s141ms 2m33s 4s74ms 138 9m22s call rs_giga_triagem (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration May 29 00 6 21s164ms 3s527ms 01 6 17s268ms 2s878ms 02 6 14s896ms 2s482ms 03 6 16s424ms 2s737ms 04 6 15s634ms 2s605ms 05 6 15s68ms 2s511ms 06 6 14s534ms 2s422ms 07 6 2m48s 28s129ms 08 6 15s520ms 2s586ms 09 6 18s502ms 3s83ms 10 6 21s558ms 3s593ms 11 6 18s240ms 3s40ms 12 6 17s941ms 2s990ms 13 6 22s608ms 3s768ms 14 6 24s182ms 4s30ms 15 6 21s534ms 3s589ms 16 6 20s825ms 3s470ms 17 6 16s322ms 2s720ms 18 6 16s409ms 2s734ms 19 6 16s996ms 2s832ms 20 6 16s10ms 2s668ms 21 6 16s602ms 2s767ms 22 6 15s211ms 2s535ms [ User: intelifix - Total duration: 9m22s - Times executed: 138 ]
[ Application: psql - Total duration: 9m22s - Times executed: 138 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-29 07:27:38 Duration: 2m33s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-29 00:05:21 Duration: 8s435ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-29 13:05:08 Duration: 7s548ms Database: rio User: intelifix Remote: [local] Application: psql
16 179ms 12s172ms 3s587ms 104 6m13s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 29 00 6 18s144ms 3s24ms 01 5 9s522ms 1s904ms 02 5 7s49ms 1s409ms 03 5 8s707ms 1s741ms 04 6 8s456ms 1s409ms 05 5 11s797ms 2s359ms 06 5 10s703ms 2s140ms 07 6 28s178ms 4s696ms 08 6 29s807ms 4s967ms 09 6 30s922ms 5s153ms 10 6 32s513ms 5s418ms 11 6 40s776ms 6s796ms 12 6 21s56ms 3s509ms 13 5 12s311ms 2s462ms 14 6 36s907ms 6s151ms 15 6 41s786ms 6s964ms 16 3 8s444ms 2s814ms 21 5 6s399ms 1s279ms 22 6 9s625ms 1s604ms [ User: intelifix - Total duration: 6m13s - Times executed: 104 ]
[ Application: psql - Total duration: 6m13s - Times executed: 104 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-05-29 00:05:13 Duration: 12s172ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-05-29 11:35:10 Duration: 8s851ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-05-29 11:15:10 Duration: 8s509ms Database: rio User: intelifix Remote: [local] Application: psql
17 199ms 1m11s 3s433ms 59 3m22s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration May 29 07 8 15s975ms 1s996ms 08 9 12s317ms 1s368ms 09 6 9s671ms 1s611ms 10 9 1m33s 10s363ms 11 9 39s461ms 4s384ms 14 7 26s815ms 3s830ms 15 9 4s385ms 487ms 16 2 684ms 342ms [ User: intelifix - Total duration: 3m22s - Times executed: 59 ]
[ Application: psql - Total duration: 3m22s - Times executed: 59 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 506); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (024927);
Date: 2026-05-29 10:41:44 Duration: 1m11s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 452); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (024937);
Date: 2026-05-29 11:41:24 Duration: 34s729ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 506); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (024942);
Date: 2026-05-29 14:28:37 Duration: 23s845ms Database: rio User: intelifix Remote: [local] Application: psql
18 150ms 4s964ms 790ms 1,354 17m50s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 29 07 114 54s668ms 479ms 08 214 2m14s 627ms 09 236 2m41s 686ms 10 200 2m19s 697ms 11 137 2m11s 958ms 12 49 31s891ms 650ms 13 31 38s338ms 1s236ms 14 130 2m18s 1s66ms 15 149 2m44s 1s105ms 16 75 53s902ms 718ms 17 19 20s976ms 1s104ms [ User: intelifix - Total duration: 17m50s - Times executed: 1354 ]
[ Application: [unknown] - Total duration: 17m50s - Times executed: 1354 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (39190, 413, '215704856973', '',077,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":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-05-29 11:24:03 Duration: 4s964ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (39548, 407, 'ZTE3ANNQ4410390,3CF9F0AC5262,3CF9F0AC5263,ZTEGD641A319$ZTE3ANNQ7L06042,C4EBFF8E1244,C4EBFF8E1245,ZTEGD70AD3CC$ZTE3ANNR3J07640,F4E84F870170,F4E84F870171,ZTEGD97B7FA2$ZTE3ANNQ7T01794,C4EBFF8F154C,C4EBFF8F154D,ZTEGD70AFEF8$ZTE3ANNRB737590,5872C991AA35,5872C991AA36,ZTEGDC61BDA9$ZTE3ANNT2V85886,D83139936BCC,D83139936BCD,ZTEGDD3141FD$ZTE3ANNT2V85838,D83139936AAC,D83139936AAD,ZTEGDD3141CD$ZTE3ANNR8C10135,3891484F7491,3891484F7492,ZTEGDB08A807$ZTE3ANNQ7T01224,C4EBFF8F07F0,C4EBFF8F07F1,ZTEGD70AFCBE$ZTE3ANNQ7501278,C4EBFF8B1130,C4EBFF8B1131,ZTEGD70A539E$ZTE3ANNQ9J31475,843C992EB2E7,843C992EB2E8,ZTEGD7BB839E$ZTE3ANNRAD30527,D89A0DB0A5DD,D89A0DB0A5DE,ZTEGDB17734A$ZTE3ANNQ8M35247,843C99220205,843C99220206,ZTEGD7BAD11C$ZTE3ANNQ9J35645,843C992F14A3,843C992F14A4,ZTEGD7BB93E8$ZTE3ANNR7B14992,3891484A4C07,3891484A4C08,ZTEGDB07CBF0$ZTE3ANNR3J07348,F4E84F86FA98,F4E84F86FA99,ZTEGD97B7E7E$ZTE3ANNR1Y18106,14CA56CE52D7,14CA56CE52D8,ZTEGD970BD15$ZTE3ANNQ9334656,843C9935C17D,843C9935C17E,ZTEGD7BC4357$ZTE3ANNRCP63941,6C11BA6F056D,6C11BA6F056E,ZTEGDC703A58$ZTE3ANNR9W20576,D89A0DAA3E63,D89A0DAA3E64,ZTEGDB16620B$ZTE3ANNQ6M07006,C4EBFF890604,C4EBFF890605,ZTEGD709FC6C$ZTE3ANNR9W39230,D89A0DABF397,D89A0DABF398,ZTEGDB16AAE9$ZTE3ANNRAM41463,5872C98B0403,5872C98B0404,ZTEGDC60A1F6$ZTE3ANNQ5N12893,3CF9F0ADF3A4,3CF9F0ADF3A5,ZTEGD641E8A4$ZTE3ANNRCP61987,6C11BA6ED7A1,6C11BA6ED7A2,ZTEGDC7032B6$ZTE3ANNR8C09861,3891484F6E25,3891484F6E26,ZTEGDB08A6F5$ZTE3ANNQ4N15093,3CF9F0A9F36C,3CF9F0A9F36D,ZTEGD6413DF0$ZTE3ANNR9W45636,D89A0DAC89BB,D89A0DAC89BC,ZTEGDB16C3EF$ZTE3ANNQ4410034,3CF9F0AC4A0A,3CF9F0AC4A0B,ZTEGD641A1B5', '',0323,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":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-05-29 14:58:17 Duration: 4s688ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (39193, 413, '246126577385', '',0172,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":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-05-29 11:26:09 Duration: 4s661ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
19 151ms 19s290ms 790ms 178 2m20s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration May 29 07 22 6s907ms 313ms 08 20 7s59ms 352ms 09 14 1m16s 5s455ms 10 20 9s353ms 467ms 11 27 10s163ms 376ms 13 1 338ms 338ms 14 15 5s588ms 372ms 15 32 14s511ms 453ms 16 27 10s346ms 383ms [ User: intelifix - Total duration: 2m20s - Times executed: 178 ]
[ Application: [unknown] - Total duration: 2m20s - Times executed: 178 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (037595) LIMIT 1;
Date: 2026-05-29 09:35:35 Duration: 19s290ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (037949) LIMIT 1;
Date: 2026-05-29 09:34:23 Duration: 10s241ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (037951) LIMIT 1;
Date: 2026-05-29 09:35:05 Duration: 10s96ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
20 341ms 836ms 551ms 75 41s346ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 29 03 1 647ms 647ms 04 3 1s672ms 557ms 05 1 476ms 476ms 06 1 595ms 595ms 07 7 4s19ms 574ms 08 8 4s698ms 587ms 09 7 3s441ms 491ms 10 9 4s341ms 482ms 11 6 3s146ms 524ms 12 1 620ms 620ms 13 7 3s977ms 568ms 14 8 4s183ms 522ms 15 9 5s453ms 605ms 16 6 3s608ms 601ms 17 1 463ms 463ms [ User: intelifix - Total duration: 41s346ms - Times executed: 75 ]
[ Application: [unknown] - Total duration: 41s346ms - Times executed: 75 ]
-
select * from rs_menu_grants (433, 18, 1);
Date: 2026-05-29 08:05:39 Duration: 836ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (406, 72, 1);
Date: 2026-05-29 15:07:01 Duration: 830ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (433, 18, 1);
Date: 2026-05-29 07:35:33 Duration: 808ms Database: rio User: intelifix Remote: [local] Application: [unknown]
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 2 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration May 29 16 1 0ms 0ms 18 1 0ms 0ms [ User: intelifix - Total duration: 1s979ms - Times executed: 2 ]
[ Application: psql - Total duration: 1s297ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 681ms - Times executed: 1 ]
-
;
Date: Duration: 0ms Database: postgres User: rio Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 17,593 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 432 FATAL entries
- 3419 ERROR entries
- 0 WARNING entries
- 5 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 3,382 Max number of times the same event was reported
- 3,856 Total events found
Rank Times reported Error 1 3,382 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count May 29 00 59 01 55 02 58 03 58 04 59 05 60 06 59 07 159 08 249 09 300 10 389 11 296 12 113 13 147 14 365 15 324 16 210 17 79 18 59 19 60 20 59 21 60 22 56 23 49 - ERROR: prepared statement "_PLAN0000000029CA7930" does not exist
- ERROR: prepared statement "_PLAN0000000029CA7930" does not exist
- ERROR: prepared statement "_PLAN0000000029CA7DC0" does not exist
Statement: DEALLOCATE "_PLAN0000000029CA7930"
Date: 2026-05-29 00:00:45 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029CA7930"
Date: 2026-05-29 00:01:46 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029CA7DC0"
Date: 2026-05-29 00:02:46 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 425 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count May 29 00 18 01 14 02 16 03 14 04 14 05 19 06 17 07 16 08 21 09 19 10 19 11 19 12 19 13 19 14 21 15 19 16 19 17 20 18 21 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-29 00:02:11 Database: brasilia Application: [unknown] User: lenon Remote: [local]
Date: 2026-05-29 00:02:12 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-05-29 00:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
3 18 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #3
Day Hour Count May 29 08 3 09 3 10 3 12 3 15 3 16 3 - ERROR: trailing junk after numeric literal at or near "7E2634E186D9" at character 27
- ERROR: trailing junk after numeric literal at or near "7E2634E186D9" at character 27
- ERROR: trailing junk after numeric literal at or near "7E2634E186D9" at character 27
Statement: SELECT * FROM RS_ETIQUETA(7E2634E186D9)
Date: 2026-05-29 08:18:08 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(7E2634E186D9)
Date: 2026-05-29 08:18:09 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(7E2634E186D9)
Date: 2026-05-29 08:18:09 Database: rio Application: [unknown] User: etiquetas Remote: [local]
4 12 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count May 29 09 3 13 6 17 3 - ERROR: column "d825225544f6" does not exist at character 27
- ERROR: column "d825225544f6" does not exist at character 27
- ERROR: column "d825225544f6" does not exist at character 27
Statement: SELECT * FROM RS_ETIQUETA(D825225544F6)
Date: 2026-05-29 09:09:35 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(D825225544F6)
Date: 2026-05-29 09:09:43 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(D825225544F6)
Date: 2026-05-29 09:09:52 Database: rio Application: [unknown] User: etiquetas Remote: [local]
5 5 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #5
Day Hour Count May 29 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-29 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-05-29 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Context: SQL statement "SELECT PAR_VALOR FROM PARAMETROS WHERE PAR_NOME = cParam" PL/pgSQL function rs_parametro(character varying) line 20 at SQL statement PL/pgSQL function rs_giga_tecnicos() line 16 during statement block local variable initialization
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-05-29 03:05:01 Database: rio Application: psql User: intelifix Remote: [local]
6 4 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #6
Day Hour Count May 29 07 3 14 1 - LOG: process 842035 still waiting for ShareLock on transaction 246705 after 1000.077 ms
- LOG: process 842035 still waiting for ShareLock on transaction 246705 after 7886.483 ms
- LOG: process 842035 still waiting for ShareLock on transaction 246705 after 96690.506 ms
Detail: Process holding the lock: 834606. Wait queue: 842035.
Context: while updating tuple (68609,65) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-05-29 07:25:07 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 834606. Wait queue: 842035.
Context: while updating tuple (68609,65) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-05-29 07:25:14 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 834606. Wait queue: 842035.
Context: while updating tuple (68609,65) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-05-29 07:26:43 Database: rio Application: psql User: intelifix Remote: [local]
7 2 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count May 29 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-29 05:30:16 Database: contagem Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-05-29 05:30:16 Database: contagem Application: psql User: intelifix Remote: [local]
8 2 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #8
Day Hour Count May 29 13 2 - ERROR: syntax error at or near "[" at character 35
- ERROR: syntax error at or near "[" at character 35
Statement: select * from rs_caixa_qr(2981145 [)
Date: 2026-05-29 13:57:16 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(2981145 [)
Date: 2026-05-29 13:57:17 Database: rio Application: [unknown] User: etiquetas Remote: [local]
9 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #9
Day Hour Count May 29 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-05-29 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-05-29 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
10 2 ERROR: could not connect to server "..."
Times Reported Most Frequent Error / Event #10
Day Hour Count May 29 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-29 05:30:01 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-29 05:30:01 Database: rio Application: psql User: intelifix Remote: [local]
11 1 ERROR: unterminated quoted string at or near "..."
Times Reported Most Frequent Error / Event #11
Day Hour Count May 29 21 1 - ERROR: unterminated quoted string at or near "''', 00, 06 );" at character 34
Statement: SELECT * FROM RS_BARRA_DETALHES( ''', 00, 06 );
Date: 2026-05-29 21:36:33 Database: rio Application: [unknown] User: intelifix Remote: [local]
12 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #12
Day Hour Count May 29 03 1 - LOG: database system was shut down at 2026-05-29 03:05:01 -03
Date: 2026-05-29 03:05:02