pgBadger-
Global information
- Generated on Mon Jun 1 23:50:09 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 39,929 log entries in 8s
- Log start from 2026-06-01 00:00:08 to 2026-06-01 23:40:25
-
Overview
Global Stats
- 298 Number of unique normalized queries
- 5,627 Number of queries
- 7h32m56s Total query duration
- 2026-06-01 00:00:17 First query
- 2026-06-01 23:38:50 Last query
- 8 queries/s at 2026-06-01 15:54:23 Query peak
- 7h32m56s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 7h32m56s Execute total duration
- 3,583 Number of events
- 17 Number of unique normalized events
- 3,107 Max number of times the same event was reported
- 0 Number of cancellation
- 506 Total number of automatic vacuums
- 1,007 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 242 Total number of sessions
- 7 sessions at 2026-06-01 09:24:39 Session peak
- 8d13h40m41s Total duration of sessions
- 50m59s Average duration of sessions
- 23 Average queries per session
- 1m52s Average queries duration per session
- 49m7s Average idle time per session
- 665 Total number of connections
- 5 connections/s at 2026-06-01 00:21:44 Connection peak
- 2 Total number of databases
SQL Traffic
Key values
- 8 queries/s Query Peak
- 2026-06-01 15:54:23 Date
SELECT Traffic
Key values
- 8 queries/s Query Peak
- 2026-06-01 15:54:23 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-06-01 00:23:34 Date
Queries duration
Key values
- 7h32m56s 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) Jun 01 00 229 0ms 19m42s 12s305ms 1m11s 2m4s 21m29s 01 10 0ms 3s571ms 1s565ms 1s912ms 2s219ms 4s722ms 02 6 0ms 2s914ms 2s274ms 1s945ms 2s270ms 2s914ms 03 8 0ms 3s156ms 1s721ms 1s850ms 2s2ms 3s811ms 04 6 0ms 2s393ms 2s95ms 1s907ms 2s122ms 2s393ms 05 8 0ms 8m8s 1m17s 1s975ms 2s128ms 8m8s 06 12 0ms 11s698ms 2s787ms 1s904ms 2s89ms 21s410ms 07 189 0ms 10m16s 10s607ms 51s349ms 3m33s 16m4s 08 603 151ms 5m38s 2s835ms 41s25ms 3m42s 5m40s 09 500 150ms 18m42s 5s957ms 1m48s 4m9s 19m53s 10 432 0ms 12m33s 4s901ms 41s471ms 4m 12m38s 11 700 150ms 5m49s 2s368ms 43s255ms 53s797ms 5m54s 12 148 0ms 6m3s 6s63ms 21s500ms 34s571ms 6m38s 13 272 0ms 5m35s 2s148ms 8s217ms 26s820ms 5m35s 14 511 150ms 6m12s 2s975ms 32s575ms 4m8s 6m48s 15 745 150ms 7m30s 3s580ms 2m17s 4m22s 7m35s 16 631 150ms 9m41s 3s6ms 38s457ms 4m36s 10m19s 17 247 0ms 5m47s 4s798ms 37s484ms 2m25s 5m49s 18 14 0ms 5m14s 26s541ms 4s143ms 5m44s 5m44s 19 13 0ms 5m22s 28s789ms 3s644ms 5m50s 5m50s 20 76 0ms 10m44s 16s44ms 1m51s 10m48s 10m48s 21 27 0ms 5m4s 13s634ms 5s672ms 5m34s 5m34s 22 19 0ms 5m13s 19s558ms 5s830ms 5m41s 5m41s 23 221 0ms 1m33s 7s792ms 1m20s 1m22s 2m11s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 01 00 8 206 12s751ms 1m1s 1m10s 2m2s 01 1 0 445ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 1 0 201ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 4 0 405ms 0ms 0ms 325ms 07 107 0 14s633ms 3s762ms 9s113ms 3m36s 08 486 0 2s551ms 8s446ms 35s504ms 3m52s 09 420 0 6s124ms 8s530ms 38s422ms 7m5s 10 353 0 5s148ms 6s965ms 29s608ms 4m7s 11 549 0 1s850ms 12s796ms 18s993ms 3m39s 12 102 0 6s682ms 2s260ms 3s758ms 3m45s 13 237 0 2s187ms 4s5ms 5s699ms 32s239ms 14 440 0 2s943ms 8s640ms 12s759ms 5m34s 15 612 0 3s497ms 15s155ms 2m17s 4m31s 16 513 0 2s960ms 9s 16s579ms 4m36s 17 182 0 5s55ms 10s479ms 31s35ms 2m20s 18 5 0 1m9s 0ms 2s56ms 5m44s 19 4 0 1m28s 0ms 1s865ms 5m50s 20 9 56 18s204ms 1m30s 1m36s 10m44s 21 13 0 26s3ms 658ms 1s429ms 5m34s 22 4 0 1m25s 0ms 0ms 5m41s 23 5 216 7s792ms 1m9s 1m19s 2m11s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 01 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 Jun 01 00 0 1 1.00 0.00% 01 0 1 1.00 0.00% 02 0 0 0.00 0.00% 03 0 1 1.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 1 1.00 0.00% 07 0 4 4.00 0.00% 08 0 7 7.00 0.00% 09 0 8 8.00 0.00% 10 0 8 8.00 0.00% 11 0 11 11.00 0.00% 12 0 3 3.00 0.00% 13 0 7 7.00 0.00% 14 0 8 8.00 0.00% 15 0 13 13.00 0.00% 16 0 7 7.00 0.00% 17 0 2 2.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 2 2.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Jun 01 00 29 0.01/s 01 22 0.01/s 02 19 0.01/s 03 26 0.01/s 04 19 0.01/s 05 26 0.01/s 06 24 0.01/s 07 26 0.01/s 08 36 0.01/s 09 40 0.01/s 10 38 0.01/s 11 35 0.01/s 12 24 0.01/s 13 33 0.01/s 14 36 0.01/s 15 43 0.01/s 16 34 0.01/s 17 29 0.01/s 18 24 0.01/s 19 23 0.01/s 20 27 0.01/s 21 27 0.01/s 22 22 0.01/s 23 3 0.00/s Day Hour Count Average Duration Average idle time Jun 01 00 7 42m41s 35m58s 01 9 1h40s 1h38s 02 6 1h30s 1h27s 03 11 19m37s 19m36s 04 5 1h3m36s 1h3m33s 05 5 1h 57m56s 06 5 1h 59m53s 07 10 51m4s 47m43s 08 10 50m58s 48m7s 09 23 41m11s 39m1s 10 15 46m22s 44m1s 11 15 57m16s 55m25s 12 14 56m11s 55m7s 13 5 1h 58m3s 14 16 58m39s 57m4s 15 17 51m 48m23s 16 22 49m32s 48m6s 17 15 52m37s 51m18s 18 7 54m39s 53m45s 19 4 1h1m20s 59m47s 20 6 41m46s 38m23s 21 4 1h2m1s 1h29s 22 6 1h59s 59m57s 23 5 42m22s 36m37s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-06-01 00:21:44 Date
Connections per database
Key values
- brasilia Main Database
- 665 connections Total
Connections per user
Key values
- intelifix Main User
- 665 connections Total
-
Sessions
Simultaneous sessions
Key values
- 7 sessions Session Peak
- 2026-06-01 09:24:39 Date
Histogram of session times
Key values
- 183 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 242 sessions Total
Sessions per user
Key values
- intelifix Main User
- 242 sessions Total
Sessions per host
Key values
- [local] Main Host
- 242 sessions Total
Sessions per application
Key values
- [unknown] Main Application
- 242 sessions Total
Application Count Total Duration Average Duration [unknown] 218 8d3h46m22s 53m52s pgAdmin 4 - CONN:7704886 2 25s52ms 12s526ms pgAdmin 4 - CONN:8042287 2 27s338ms 13s669ms pgAdmin 4 - DB:contagem 2 2m10s 1m5s pgAdmin 4 - DB:postgres 2 2m52s 1m26s pgAdmin 4 - DB:rio 1 32s258ms 32s258ms pg_dump 6 1h5m12s 10m52s psql 9 8h42m39s 58m4s -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 18,380 buffers Checkpoint Peak
- 2026-06-01 14:39:41 Date
- 270.044 seconds Highest write time
- 0.033 seconds Sync time
Checkpoints Wal files
Key values
- 12 files Wal files usage Peak
- 2026-06-01 14:39:41 Date
Checkpoints distance
Key values
- 381.32 Mo Distance Peak
- 2026-06-01 14:39:41 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jun 01 00 3,166 286.808s 0.008s 286.826s 01 6 0.622s 0.001s 0.628s 02 0 0s 0s 0s 03 0 0.05s 0.003s 0.061s 04 0 0s 0s 0s 05 4,327 431.922s 0.013s 431.953s 06 1,250 125.446s 0.004s 125.468s 07 36,122 2,376.253s 0.066s 2,376.388s 08 53,156 2,867.357s 0.151s 2,867.632s 09 98,754 3,239.304s 0.194s 3,239.646s 10 61,691 3,184.293s 0.192s 3,184.605s 11 61,604 3,239.397s 0.204s 3,239.741s 12 37,164 2,102.77s 0.062s 2,102.919s 13 26,017 2,128.259s 0.108s 2,128.449s 14 62,242 3,180.205s 0.205s 3,180.543s 15 96,239 3,239.371s 0.24s 3,239.773s 16 67,933 3,236.371s 0.219s 3,236.756s 17 42,381 2,396.789s 0.123s 2,396.996s 18 1,214 121.631s 0.011s 121.656s 19 176 17.675s 0.002s 17.681s 20 1,887 191.339s 0.008s 191.357s 21 2,267 229.534s 0.016s 229.584s 22 2,105 211.077s 0.018s 211.123s 23 777 77.873s 0.009s 77.898s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jun 01 00 0 0 4 152 0.002s 0.002s 01 0 0 0 4 0.001s 0.001s 02 0 0 0 0 0s 0s 03 0 0 0 3 0.002s 0.001s 04 0 0 0 0 0s 0s 05 0 0 2 100 0.004s 0.005s 06 0 0 0 60 0.002s 0.002s 07 0 0 24 2,009 0.003s 0.012s 08 0 0 35 4,578 0.004s 0.012s 09 0 0 50 4,921 0.003s 0.012s 10 0 0 34 4,475 0.009s 0.012s 11 0 0 42 5,915 0.003s 0.012s 12 0 0 26 2,204 0.003s 0.012s 13 0 0 9 4,216 0.003s 0.011s 14 0 0 33 5,443 0.004s 0.012s 15 0 0 52 6,272 0.004s 0.012s 16 0 0 38 5,616 0.004s 0.012s 17 0 0 27 3,669 0.005s 0.011s 18 0 0 1 103 0.002s 0.004s 19 0 0 0 7 0.001s 0.001s 20 0 0 0 67 0.002s 0.003s 21 0 0 1 468 0.002s 0.007s 22 0 0 1 443 0.003s 0.007s 23 0 0 0 30 0.003s 0.004s Day Hour Count Avg time (sec) Jun 01 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 Jun 01 00 31,902.50 kB 31,902.50 kB 01 10.00 kB 30,885.00 kB 02 0.00 kB 0.00 kB 03 0.00 kB 13,898.50 kB 04 0.00 kB 0.00 kB 05 6,302.60 kB 12,166.20 kB 06 3,719.50 kB 13,844.00 kB 07 33,155.67 kB 75,634.58 kB 08 47,199.25 kB 79,258.75 kB 09 69,179.08 kB 141,567.83 kB 10 45,559.25 kB 88,242.83 kB 11 58,202.08 kB 87,683.75 kB 12 34,325.50 kB 113,494.58 kB 13 14,694.27 kB 42,998.55 kB 14 44,534.50 kB 98,416.17 kB 15 70,511.67 kB 120,900.75 kB 16 52,006.83 kB 109,780.58 kB 17 41,178.91 kB 68,003.27 kB 18 1,010.50 kB 44,590.00 kB 19 369.00 kB 34,120.00 kB 20 4,006.33 kB 28,745.00 kB 21 1,644.43 kB 17,835.57 kB 22 1,593.57 kB 9,412.57 kB 23 1,470.25 kB 5,944.25 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 Jun 01 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
- 30.81 sec Highest CPU-cost vacuum
Table public.codigos_barra
Database rio - 2026-06-01 14:33:29 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 30.81 sec Highest CPU-cost vacuum
Table public.codigos_barra
Database rio - 2026-06-01 14:33:29 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (127) Main table analyzed (database rio)
- 1,007 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 127 rio.pg_catalog.pg_class 68 rio.public.temp0000281319 59 rio.pg_catalog.pg_type 58 rio.public.usuarios 53 contagem.pg_catalog.pg_attribute 50 rio.pg_catalog.pg_index 40 contagem.pg_catalog.pg_class 38 contagem.pg_catalog.pg_type 31 rio.pg_catalog.pg_depend 31 rio.public.temp0000281365 30 rio.auditor.auditor_2026_06 27 rio.public.temp0000281327 21 contagem.public.usuarios 19 rio.public.temp0000281425 18 rio.public.temp0000281393 18 contagem.pg_catalog.pg_index 17 rio.public.temp0000281395 17 rio.public.temp0000281321 16 contagem.public.temp0000226294 15 rio.public.temp0000281093 15 rio.public.temp0000281323 15 rio.public.temp0000281401 15 contagem.auditor.auditor_2026_06 14 rio.public.temp0000281359 13 contagem.pg_catalog.pg_depend 13 rio.public.temp0000281339 12 rio.public.temp0000281355 10 contagem.public.temp0000226296 10 rio.public.temp0000281413 8 rio.public.temp0000281343 7 rio.public.temp0000281415 7 rio.public.temp0000281445 7 rio.public.temp0000281335 7 contagem.pg_catalog.pg_shdepend 6 rio.public.temp0000281397 5 rio.public.temp0000281443 5 rio.public.temp0000281313 5 contagem.public.temp0000226312 5 rio.public.temp0000281357 5 contagem.public.temp0000226316 5 rio.public.temp0000281315 5 template1.pg_catalog.pg_shdepend 4 rio.public.temp0000281417 4 rio.public.temp0000281333 4 rio.pg_catalog.pg_shdepend 4 rio.public.temp0000281381 4 rio.public.temp0000281441 3 rio.public.temp0000281331 3 rio.public.temp0000281391 3 rio.public.temp0000281347 3 rio.public.temp0000281403 3 rio.public.temp0000281301 3 contagem.public.parametros 2 rio.public.temp0000281349 2 rio.public.temp0000281363 2 rio.public.temp0000281373 2 rio.public.temp0000281353 2 contagem.public.temp0000226314 2 postgres.pg_catalog.pg_shdepend 2 rio.public.temp0000281451 1 rio.public.temp0000281409 1 rio.public.temp0000281369 1 rio.public.temp0000281345 1 rio.public.temp0000281341 1 rio.public.temp0000281419 1 rio.public.temp0000281437 1 contagem.public.nf_entrada 1 Total 1,007 Vacuums per table
Key values
- pg_catalog.pg_attribute (60) Main table vacuumed on database rio
- 506 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 60 43 0 0 0 0 0 24,707 6,722 9,786,327 427 11,189 rio.public.temp0000281319 59 0 0 0 0 0 0 40,866 535 2,978,809 0 0 rio.pg_catalog.pg_class 41 25 0 0 0 0 0 4,922 1,642 2,370,392 95 374 rio.pg_catalog.pg_type 35 23 0 0 0 0 0 2,204 671 782,523 108 501 rio.public.temp0000281365 27 0 0 0 0 0 0 4,818 146 306,954 0 0 rio.pg_catalog.pg_index 23 15 0 0 0 0 0 992 282 235,878 52 96 rio.public.temp0000281327 20 0 0 0 0 0 0 1,395 116 100,052 0 0 contagem.public.usuarios 20 0 0 0 0 0 0 85 62 37,921 1 1 rio.public.temp0000281425 17 0 0 0 0 0 0 21,607 1,603 3,235,373 0 0 contagem.pg_catalog.pg_attribute 17 17 0 0 0 0 0 10,281 3,058 5,282,136 44 1,314 rio.auditor.auditor_2026_06 17 0 0 0 0 0 0 78,012 45,606 57,471,375 14,347 278,190 rio.public.temp0000281093 15 0 0 0 0 0 0 1,143 228 346,774 0 0 rio.public.temp0000281359 13 0 0 0 0 0 0 12,340 47 735,574 0 0 rio.public.usuarios 13 3 0 0 0 0 0 88 40 86,013 4 6 rio.pg_catalog.pg_depend 11 11 0 0 0 0 0 3,534 1,232 1,849,956 94 1,429 contagem.pg_catalog.pg_type 10 10 0 0 0 0 0 857 269 408,999 5 22 contagem.pg_catalog.pg_class 9 9 0 0 0 0 0 1,473 457 674,747 12 43 rio.pg_catalog.pg_statistic 8 8 0 0 0 0 0 12,705 3,116 14,937,463 1,276 6,537 contagem.auditor.auditor_2026_06 8 0 0 0 0 0 0 10,901 5,458 6,923,404 1,841 33,617 rio.public.temp0000281339 7 0 0 0 0 0 0 236 40 19,260 0 0 rio.public.temp0000281343 7 0 0 0 0 0 0 898 193 328,188 0 0 contagem.pg_catalog.pg_index 6 6 0 0 0 0 0 282 99 97,909 7 42 rio.public.temp0000281335 6 0 0 0 0 0 0 361 30 26,105 0 0 contagem.pg_catalog.pg_depend 5 5 0 0 0 0 0 1,242 397 811,191 6 110 rio.pg_toast.pg_toast_2619 4 4 0 0 0 0 0 2,295 530 2,999,470 143 552 rio.public.temp0000281381 3 0 0 0 0 0 0 1,548 10 93,011 0 0 contagem.pg_catalog.pg_shdepend 3 3 0 0 0 0 0 589 195 355,711 22 66 rio.public.temp0000281403 3 0 0 0 0 0 0 3,090 11 184,054 0 0 rio.public.temp0000281347 3 0 0 0 0 0 0 3,173 14 189,328 0 0 rio.public.temp0000281373 2 0 0 0 0 0 0 96 11 7,427 0 0 rio.public.temp0000281363 2 0 0 0 0 0 0 176 12 12,219 0 0 rio.pg_catalog.pg_shdepend 2 2 0 0 0 0 0 423 152 236,883 27 53 rio.public.temp0000281333 2 0 0 0 0 0 0 175 12 12,159 0 0 rio.public.logs 2 0 0 0 0 0 0 729 284 371,996 204 4,978 rio.public.temp0000281331 2 0 0 0 0 0 0 123 12 8,978 0 0 rio.public.temp0000281313 2 0 0 0 0 0 0 16 10 2,389 0 0 contagem.pg_catalog.pg_statistic 2 2 0 0 0 0 0 3,624 1,169 3,833,771 924 6,438 rio.public.temp0000281401 2 0 0 0 0 0 0 16 10 2,638 0 0 contagem.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 206 68 244,763 12 44 rio.public.equipamentos_referencia 1 0 0 0 0 0 0 74 57 183,466 9 1,665 rio.public.temp0000281451 1 0 0 0 0 0 0 1,543 4 91,640 0 0 rio.public.temp0000281369 1 0 0 0 0 0 0 4 3 774 0 0 rio.public.codigos_barra 1 1 0 0 0 0 0 35,476 30,078 159,581,649 59 4,005 rio.public.temp0000281397 1 0 0 0 0 0 0 1,543 4 91,640 0 0 rio.public.temp0000281409 1 0 0 0 0 0 0 102 6 6,969 0 0 contagem.public.temp0000226312 1 0 0 0 0 0 0 90 6 6,231 0 0 rio.public.temp0000281445 1 0 0 0 0 0 0 8 5 1,406 0 0 rio.public.temp0000281341 1 0 0 0 0 0 0 8 5 1,305 0 0 rio.public.notas_fiscais 1 0 0 0 0 0 0 21 11 30,650 5 925 rio.public.temp0000281345 1 0 0 0 0 0 0 87 6 6,048 0 0 contagem.public.temp0000226314 1 0 0 0 0 0 0 90 6 6,231 0 0 rio.public.nf_entrada_arquivo_erros 1 0 0 0 0 0 0 306 106 330,076 103 5,126 contagem.public.temp0000226296 1 0 0 0 0 0 0 53 6 3,974 0 0 postgres.pg_catalog.pg_shdepend 1 1 0 0 0 0 0 210 71 112,304 13 25 rio.public.temp0000281301 1 0 0 0 0 0 0 8 5 1,420 0 0 Total 506 190 0 0 0 0 0 291,851 104,928 278,843,903 19,840 357,348 Vacuum throughput per table
Key values
- public.codigos_barra (30.81) 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.32 rio.public.temp0000281319 0 0 1.73 rio.pg_catalog.pg_class 0 0 0.85 rio.pg_catalog.pg_type 0 0 0.34 rio.public.temp0000281365 0 0 0.49 rio.pg_catalog.pg_index 0 0 0.27 rio.public.temp0000281327 0 0 0.25 contagem.public.usuarios 0 0 0 rio.public.temp0000281425 0 0 0.91 contagem.pg_catalog.pg_attribute 0 0 1.32 rio.auditor.auditor_2026_06 0 0 13.03 rio.public.temp0000281093 0 0 0.12 rio.public.temp0000281359 0 0 0.52 rio.public.usuarios 0 0 0 rio.pg_catalog.pg_depend 0 0 0.68 contagem.pg_catalog.pg_type 0 0 0.14 contagem.pg_catalog.pg_class 0 0 0.18 rio.pg_catalog.pg_statistic 0 0 1.36 contagem.auditor.auditor_2026_06 0 0 1.56 rio.public.temp0000281339 0 0 0.02 rio.public.temp0000281343 0 0 0.11 contagem.pg_catalog.pg_index 0 0 0.06 rio.public.temp0000281335 0 0 0.05 contagem.pg_catalog.pg_depend 0 0 0.22 rio.pg_toast.pg_toast_2619 0 0 0.29 rio.public.temp0000281381 0 0 0.12 contagem.pg_catalog.pg_shdepend 0 0 0.14 rio.public.temp0000281403 0 0 0.14 rio.public.temp0000281347 0 0 0.1 rio.public.temp0000281373 0 0 0.02 rio.public.temp0000281363 0 0 0.01 rio.pg_catalog.pg_shdepend 0 0 0.07 rio.public.temp0000281333 0 0 0.02 rio.public.logs 0 0 0.35 rio.public.temp0000281331 0 0 0.01 rio.public.temp0000281313 0 0 0.01 contagem.pg_catalog.pg_statistic 0 0 0.29 rio.public.temp0000281401 0 0 0.02 contagem.pg_toast.pg_toast_2619 0 0 0.03 rio.public.equipamentos_referencia 0 0 0.02 rio.public.temp0000281451 0 0 0.05 rio.public.temp0000281369 0 0 0.03 rio.public.codigos_barra 0 0 30.81 rio.public.temp0000281397 0 0 0.05 rio.public.temp0000281409 0 0 0.01 contagem.public.temp0000226312 0 0 0.01 rio.public.temp0000281445 0 0 0.01 rio.public.temp0000281341 0 0 0.01 rio.public.notas_fiscais 0 0 0 rio.public.temp0000281345 0 0 0 contagem.public.temp0000226314 0 0 0 rio.public.nf_entrada_arquivo_erros 0 0 0.1 contagem.public.temp0000226296 0 0 0.01 postgres.pg_catalog.pg_shdepend 0 0 0.09 rio.public.temp0000281301 0 0 0.02 Total 0 0 60.37 Tuples removed per table
Key values
- pg_catalog.pg_attribute (169908) Main table with removed tuples on database rio
- 293275 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 60 43 169,908 1,596,194 199,567 388 38,716 contagem.pg_catalog.pg_attribute 17 17 55,867 414,093 0 83 8,954 rio.pg_catalog.pg_statistic 8 8 14,690 69,464 372 0 10,288 rio.pg_catalog.pg_depend 11 11 11,461 213,015 2,918 0 2,010 rio.pg_catalog.pg_type 35 23 8,768 90,923 11,410 30 2,644 contagem.pg_catalog.pg_statistic 2 2 5,401 15,214 0 0 2,022 rio.pg_catalog.pg_class 41 25 3,796 184,814 30,125 98 5,516 rio.pg_catalog.pg_index 23 15 3,456 48,063 4,059 7 1,339 contagem.pg_catalog.pg_depend 5 5 3,310 94,935 0 0 865 contagem.pg_catalog.pg_shdepend 3 3 3,091 28,231 467 0 303 rio.pg_catalog.pg_shdepend 2 2 2,067 18,554 1 0 202 contagem.pg_catalog.pg_type 10 10 1,682 22,490 0 14 620 rio.auditor.auditor_2026_06 17 0 1,652 5,163,055 0 0 249,545 contagem.pg_catalog.pg_class 9 9 1,492 33,892 0 0 1,212 rio.public.codigos_barra 1 1 1,317 9,464,296 0 0 63,322 postgres.pg_catalog.pg_shdepend 1 1 1,250 9,274 0 0 101 rio.pg_toast.pg_toast_2619 4 4 1,228 3,260 0 8 1,072 contagem.public.usuarios 20 0 1,197 420 0 0 40 contagem.pg_catalog.pg_index 6 6 1,143 11,382 0 0 310 rio.public.usuarios 13 3 319 8,800 2,222 0 208 contagem.pg_toast.pg_toast_2619 2 2 144 222 0 27 61 rio.public.nf_entrada_arquivo_erros 1 0 36 8,195,681 0 0 145,626 rio.public.temp0000281359 13 0 0 281,869 0 0 20,224 rio.public.temp0000281373 2 0 0 3,174 0 93 163 rio.public.temp0000281093 15 0 0 60,327 0 330 1,366 rio.public.temp0000281363 2 0 0 3,083 0 96 160 rio.public.equipamentos_referencia 1 0 0 4,995,334 0 0 27,003 rio.public.temp0000281451 1 0 0 21,724 0 0 1,600 rio.public.temp0000281369 1 0 0 21,677 0 0 1,536 rio.public.temp0000281333 2 0 0 3,056 0 97 159 rio.public.logs 2 0 0 31,571,754 0 0 1,261,223 rio.public.temp0000281331 2 0 0 2,024 0 21 107 rio.public.temp0000281313 2 0 0 2,527 0 7 57 rio.public.temp0000281339 7 0 0 12,043 0 103 249 rio.public.temp0000281425 17 0 0 369,203 0 0 27,200 rio.public.temp0000281397 1 0 0 21,722 0 0 1,600 rio.public.temp0000281409 1 0 0 1,745 0 34 94 rio.public.temp0000281343 7 0 0 37,232 0 310 842 rio.public.temp0000281327 20 0 0 71,199 0 544 1,632 rio.public.temp0000281365 27 0 0 164,958 0 1,014 9,802 contagem.public.temp0000226312 1 0 0 1,070 0 46 82 rio.public.temp0000281319 59 0 0 762,916 0 1,095 53,817 rio.public.temp0000281445 1 0 0 6,506 0 45 147 rio.public.temp0000281341 1 0 0 1,527 0 49 79 rio.public.notas_fiscais 1 0 0 159,579 0 0 865 rio.public.temp0000281345 1 0 0 1,527 0 49 79 contagem.public.temp0000226314 1 0 0 1,070 0 46 82 rio.public.temp0000281335 6 0 0 20,786 0 170 502 contagem.auditor.auditor_2026_06 8 0 0 583,272 0 0 24,695 rio.public.temp0000281401 2 0 0 8,897 0 56 200 rio.public.temp0000281381 3 0 0 65,032 0 0 4,608 contagem.public.temp0000226296 1 0 0 1,156 0 19 45 rio.public.temp0000281403 3 0 0 65,166 0 0 4,800 rio.public.temp0000281301 1 0 0 6,732 0 39 153 rio.public.temp0000281347 3 0 0 44,971 0 49 3,279 Total 506 190 293,275 65,061,130 251,141 4,967 1,983,426 Pages removed per table
Key values
- public.temp0000281319 (1095) Main table with removed pages on database rio
- 4967 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000281319 59 0 0 1095 rio.public.temp0000281365 27 0 0 1014 rio.public.temp0000281327 20 0 0 544 rio.pg_catalog.pg_attribute 60 43 169908 388 rio.public.temp0000281093 15 0 0 330 rio.public.temp0000281343 7 0 0 310 rio.public.temp0000281335 6 0 0 170 rio.public.temp0000281339 7 0 0 103 rio.pg_catalog.pg_class 41 25 3796 98 rio.public.temp0000281333 2 0 0 97 rio.public.temp0000281363 2 0 0 96 rio.public.temp0000281373 2 0 0 93 contagem.pg_catalog.pg_attribute 17 17 55867 83 rio.public.temp0000281401 2 0 0 56 rio.public.temp0000281341 1 0 0 49 rio.public.temp0000281345 1 0 0 49 rio.public.temp0000281347 3 0 0 49 contagem.public.temp0000226312 1 0 0 46 contagem.public.temp0000226314 1 0 0 46 rio.public.temp0000281445 1 0 0 45 rio.public.temp0000281301 1 0 0 39 rio.public.temp0000281409 1 0 0 34 rio.pg_catalog.pg_type 35 23 8768 30 contagem.pg_toast.pg_toast_2619 2 2 144 27 rio.public.temp0000281331 2 0 0 21 contagem.public.temp0000226296 1 0 0 19 contagem.pg_catalog.pg_type 10 10 1682 14 rio.pg_toast.pg_toast_2619 4 4 1228 8 rio.pg_catalog.pg_index 23 15 3456 7 rio.public.temp0000281313 2 0 0 7 rio.public.temp0000281359 13 0 0 0 rio.public.equipamentos_referencia 1 0 0 0 rio.public.temp0000281451 1 0 0 0 contagem.pg_catalog.pg_index 6 6 1143 0 rio.public.temp0000281369 1 0 0 0 rio.pg_catalog.pg_statistic 8 8 14690 0 rio.pg_catalog.pg_shdepend 2 2 2067 0 contagem.pg_catalog.pg_depend 5 5 3310 0 rio.public.codigos_barra 1 1 1317 0 rio.public.logs 2 0 0 0 rio.public.temp0000281425 17 0 0 0 rio.public.temp0000281397 1 0 0 0 contagem.pg_catalog.pg_statistic 2 2 5401 0 contagem.pg_catalog.pg_class 9 9 1492 0 rio.public.usuarios 13 3 319 0 rio.public.notas_fiscais 1 0 0 0 contagem.auditor.auditor_2026_06 8 0 0 0 rio.public.nf_entrada_arquivo_erros 1 0 36 0 rio.public.temp0000281381 3 0 0 0 rio.pg_catalog.pg_depend 11 11 11461 0 contagem.pg_catalog.pg_shdepend 3 3 3091 0 postgres.pg_catalog.pg_shdepend 1 1 1250 0 contagem.public.usuarios 20 0 1197 0 rio.public.temp0000281403 3 0 0 0 rio.auditor.auditor_2026_06 17 0 1652 0 Total 506 190 293,275 4,967 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jun 01 00 2 2 01 0 0 02 0 0 03 0 0 04 0 0 05 4 0 06 0 0 07 25 39 08 57 106 09 72 80 10 61 91 11 64 141 12 13 26 13 26 77 14 34 105 15 57 148 16 41 115 17 48 76 18 0 0 19 1 0 20 0 0 21 1 1 22 0 0 23 0 0 - 30.81 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 5 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 2 21m45s 2m2s 19m42s 10m52s select * from rs_auditor_novas_tabelas ();-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-06-01 00:21:44 Database: rio User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-06-01 00:23:47 Database: contagem User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-06-01 00:21:44 Database: rio User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
2 1 32s337ms 32s337ms 32s337ms 32s337ms call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-01 16:05:48 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-01 09:05:27 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-01 00:05:16 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
3 1 26s230ms 26s230ms 26s230ms 26s230ms call rs_giga_processa_arquivos ();-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-01 09:15:34 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-01 08:05:17 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-01 15:25:15 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
4 1 1s974ms 1s974ms 1s974ms 1s974ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (246983, 450, '270911029484102257,229780780626,229859455778,229785543245,229850572330,229784423955,229744257576,229747917597,229686752829,229688379496,229748636365,229787534954,216943448492,229688159295,229859044346,229755627687,229784415671,229669177488,229784646782,229736378907,229748992136,229806046480,229662814264,229753530817,229686398394,216937329108,229741334250,229736353147,229736517988,216944350512,229850430925,229925251919,229865502631,229686810613,229806009608,229812731836,229687496571,229787667189,229736525262,229816979803,229879788390', '246221011619,246651673952,246586896687,246641304859,246586401735,246547350505,246550149699,246499597583,246517613046,246552998496,246601754254,246468122234,246499578187,246639266175,246571479212,246586387793,246513407180,246597212240,246544703142,246551137282,246581917278,246466782642,246560536976,246499685976,246481991736,246550013952,246538673440,246544540725,246468161329,246642535069,246207520920,246298398396,246524373638,246581310924,246628757596,246564634245,246601738393,246544539512,246626485354,246652213051', 0141, 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":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-06-01 16:02:07 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (247004, 450, '929240558751,203543169F1B,B01FF419CB06,20B82B249D9B,203543175393,B0924A114A2C,20B82B25BC4E,20354320EB97,D8CF61663DEF,9C24722F13E5,2035435941B5,2035435A2F14,B01FF41CDBF4,D8CF6160B915,B01FF41A8F29,2035431F26C0,CC5830FDE0A2,DC92726FBE88,2035431F4DA9,D8CF61664A05,441524E4FEF3,CC5830FDA450,2035435389B9,20354319A607,DC9272736D7B,203543168743,203543158F10,CC5830007149,203543138AC9,203543220F2F,20354358B530,CC5830FDCFED,CC583000A1D9,203543200FD4,94988F2F49D2,CC5830FF66DB,CC5830FF64F1,64FA2B6461C0,441524E4FF78,20354316B94D,CC5830FEC61A', '',0302,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-01 16:34:39 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (246998, 450, '923081019181,CC5830E1F8C8,5CFA257F5480,C03C048724C5,841EA38DF98D,841EA38DA85E,582FF79C54EA,5CFA2515CAAB,841EA38D7432,345D9EB43ECB,209A7DB7C636,94988F930977,8CC5B4E31C64,B0BBE5498750,209A7DB3F895,186A81D58390,E8D2FFAB4F66,5CFA25AD3A3D,5CFA2515EE7D,943C96AD79E9,5CFA25AD1220,E8D2FFA674FE,345D9EB41216,186A81D4C777,ACD75BB74693,E4C0E2980B03,ACD75BB5F18B,C03C048647FF,C03C047FAA20,44D454608363,C4EB42A002EF,5CFA2580273D,D833B7A4438C,44ADB131D95A,C4EB42A33284,64FD965E0B06,64FD965E9B74,5447CC78D532,D833B7A42FC7,94988F30F05D,506F0C3B0F46', '',0155,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-01 14:19:52 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
Queries that waited the most
Rank Wait time Query 1 19m42s SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();[ Date: 2026-06-01 00:21:44 - Database: rio - User: lenon - Remote: [local] - Application: psql ]
2 2m2s SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();[ Date: 2026-06-01 00:23:47 - Database: contagem - User: lenon - Remote: [local] - Application: psql ]
3 32s337ms CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-06-01 16:05:47 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 26s230ms CALL RS_GIGA_PROCESSA_ARQUIVOS ();[ Date: 2026-06-01 09:15:32 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 1s974ms SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (39941, 413, '496215281825,6412692A19D3', '',045,00,'[{"item":"0","qrcode":""}]','', '', 00);[ Date: 2026-06-01 15:46:03 - Database: contagem - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 4,055 Total read queries
- 1,302 Total write queries
Queries by database
Key values
- rio Main database
- 4,759 Requests
- 7h16m14s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 6,094 Requests
User Request type Count Duration etiquetas Total 19 5s28ms select 19 5s28ms intelifix Total 6,094 9h48m46s copy to 754 1h40m15s ddl 824 49m51s others 462 49m51s select 4,053 6h28m47s lenon Total 78 22m45s select 78 22m45s Duration by user
Key values
- 9h48m46s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 19 5s28ms select 19 5s28ms intelifix Total 6,094 9h48m46s copy to 754 1h40m15s ddl 824 49m51s others 462 49m51s select 4,053 6h28m47s lenon Total 78 22m45s select 78 22m45s Queries by host
Key values
- [local] Main host
- 6,191 Requests
- 10h11m36s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 4,676 Requests
- 3h27m3s ([unknown])
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-06-01 16:35:17 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 2,861 100-500ms duration
Slowest individual queries
Rank Duration Query 1 19m42s SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();[ Date: 2026-06-01 00:21:44 - Database: rio - User: lenon - Remote: [local] - Application: psql ]
2 18m42s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 024970, 0506 )', '/var/www/html/tmp/nf_carga_lotes_0506.xlsx');[ Date: 2026-06-01 09:15:32 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
3 12m33s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-01 10:17:35 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 10m44s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-01 20:15:45 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 10m16s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-01 07:15:18 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 9m41s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-01 16:14:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 8m8s analyze verbose;[ Date: 2026-06-01 05:08:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 7m30s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-01 15:12:32 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 6m28s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-01 09:11:29 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 6m12s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-01 14:11:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 6m3s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-01 12:11:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m49s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-01 11:10:51 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 5m47s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-01 17:10:48 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m38s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-01 08:10:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m37s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 024960, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');[ Date: 2026-06-01 07:15:01 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
16 5m35s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-01 13:10:36 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m26s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025006, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');[ Date: 2026-06-01 14:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
18 5m22s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-01 19:10:23 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 5m14s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-01 18:10:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 5m13s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-01 22:10:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1h57m11s 226 150ms 18m42s 31s111ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 01 07 13 13m7s 1m 08 22 7m57s 21s706ms 09 23 30m46s 1m20s 10 19 12m18s 38s884ms 11 33 4m33s 8s300ms 12 4 3m47s 56s776ms 13 3 4s972ms 1s657ms 14 28 9m48s 21s28ms 15 30 19m28s 38s966ms 16 19 8m54s 28s157ms 17 32 6m22s 11s940ms [ User: intelifix - Total duration: 1h57m11s - Times executed: 226 ]
[ Application: [unknown] - Total duration: 1h57m11s - Times executed: 226 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 024970, 0506 )', '/var/www/html/tmp/nf_carga_lotes_0506.xlsx');
Date: 2026-06-01 09:15:32 Duration: 18m42s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 024960, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-06-01 07:15:01 Duration: 5m37s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025006, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-06-01 14:32:02 Duration: 5m26s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
2 1h53m50s 32 994ms 12m33s 3m33s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 01 07 2 10m20s 5m10s 08 2 5m39s 2m49s 09 2 6m34s 3m17s 10 2 12m38s 6m19s 11 2 5m50s 2m55s 12 2 6m4s 3m2s 13 2 5m36s 2m48s 14 2 6m13s 3m6s 15 2 7m32s 3m46s 16 2 9m43s 4m51s 17 2 5m48s 2m54s 18 2 5m15s 2m37s 19 2 5m23s 2m41s 20 2 10m47s 5m23s 21 2 5m5s 2m32s 22 2 5m14s 2m37s [ User: intelifix - Total duration: 1h53m50s - Times executed: 32 ]
[ Application: psql - Total duration: 1h53m50s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-01 10:17:35 Duration: 12m33s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-01 20:15:45 Duration: 10m44s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-01 07:15:18 Duration: 10m16s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
3 21m45s 2 2m2s 19m42s 10m52s select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 01 00 2 21m45s 10m52s [ User: lenon - Total duration: 21m45s - Times executed: 2 ]
[ Application: psql - Total duration: 21m45s - Times executed: 2 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-06-01 00:21:44 Duration: 19m42s Database: rio User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-06-01 00:23:47 Duration: 2m2s Database: contagem User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-06-01 00:21:44 Duration: 0ms Database: rio User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
4 19m40s 1,148 150ms 7s211ms 1s28ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 01 07 10 5s692ms 569ms 08 66 55s593ms 842ms 09 135 2m30s 1s115ms 10 104 1m45s 1s17ms 11 146 2m41s 1s103ms 12 45 42s461ms 943ms 13 74 58s664ms 792ms 14 160 2m40s 1s5ms 15 209 3m29s 1s4ms 16 143 2m41s 1s130ms 17 56 1m7s 1s213ms [ User: intelifix - Total duration: 19m40s - Times executed: 1148 ]
[ Application: [unknown] - Total duration: 19m40s - Times executed: 1148 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (246983, 450, '270911029484102257,229780780626,229859455778,229785543245,229850572330,229784423955,229744257576,229747917597,229686752829,229688379496,229748636365,229787534954,216943448492,229688159295,229859044346,229755627687,229784415671,229669177488,229784646782,229736378907,229748992136,229806046480,229662814264,229753530817,229686398394,216937329108,229741334250,229736353147,229736517988,216944350512,229850430925,229925251919,229865502631,229686810613,229806009608,229812731836,229687496571,229787667189,229736525262,229816979803,229879788390', '246221011619,246651673952,246586896687,246641304859,246586401735,246547350505,246550149699,246499597583,246517613046,246552998496,246601754254,246468122234,246499578187,246639266175,246571479212,246586387793,246513407180,246597212240,246544703142,246551137282,246581917278,246466782642,246560536976,246499685976,246481991736,246550013952,246538673440,246544540725,246468161329,246642535069,246207520920,246298398396,246524373638,246581310924,246628757596,246564634245,246601738393,246544539512,246626485354,246652213051', 0141, 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":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-06-01 16:02:07 Duration: 7s211ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (247004, 450, '929240558751,203543169F1B,B01FF419CB06,20B82B249D9B,203543175393,B0924A114A2C,20B82B25BC4E,20354320EB97,D8CF61663DEF,9C24722F13E5,2035435941B5,2035435A2F14,B01FF41CDBF4,D8CF6160B915,B01FF41A8F29,2035431F26C0,CC5830FDE0A2,DC92726FBE88,2035431F4DA9,D8CF61664A05,441524E4FEF3,CC5830FDA450,2035435389B9,20354319A607,DC9272736D7B,203543168743,203543158F10,CC5830007149,203543138AC9,203543220F2F,20354358B530,CC5830FDCFED,CC583000A1D9,203543200FD4,94988F2F49D2,CC5830FF66DB,CC5830FF64F1,64FA2B6461C0,441524E4FF78,20354316B94D,CC5830FEC61A', '',0302,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-01 16:34:39 Duration: 6s435ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (246998, 450, '923081019181,CC5830E1F8C8,5CFA257F5480,C03C048724C5,841EA38DF98D,841EA38DA85E,582FF79C54EA,5CFA2515CAAB,841EA38D7432,345D9EB43ECB,209A7DB7C636,94988F930977,8CC5B4E31C64,B0BBE5498750,209A7DB3F895,186A81D58390,E8D2FFAB4F66,5CFA25AD3A3D,5CFA2515EE7D,943C96AD79E9,5CFA25AD1220,E8D2FFA674FE,345D9EB41216,186A81D4C777,ACD75BB74693,E4C0E2980B03,ACD75BB5F18B,C03C048647FF,C03C047FAA20,44D454608363,C4EB42A002EF,5CFA2580273D,D833B7A4438C,44ADB131D95A,C4EB42A33284,64FD965E0B06,64FD965E9B74,5447CC78D532,D833B7A42FC7,94988F30F05D,506F0C3B0F46', '',0155,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-01 14:19:52 Duration: 5s536ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
5 17m16s 106 7s568ms 40s788ms 9s777ms create table temp0000281319 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 01 07 17 2m53s 10s219ms 08 12 1m50s 9s206ms 09 13 2m8s 9s868ms 10 14 2m11s 9s394ms 11 12 1m48s 9s43ms 14 7 1m5s 9s304ms 15 20 3m23s 10s188ms 16 11 1m54s 10s449ms [ User: intelifix - Total duration: 17m16s - Times executed: 106 ]
[ Application: [unknown] - Total duration: 17m16s - Times executed: 106 ]
-
CREATE TABLE temp0000281319 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-01 07:05:26 Duration: 40s788ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
CREATE TABLE temp0000281319 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-01 16:13:05 Duration: 13s176ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
CREATE TABLE temp0000281319 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-01 16:13:37 Duration: 11s941ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
6 12m42s 30 436ms 1m29s 25s414ms select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 01 07 2 1m30s 45s468ms 08 2 27s611ms 13s805ms 09 1 28s875ms 28s875ms 10 2 1m31s 45s839ms 11 2 32s93ms 16s46ms 12 2 31s947ms 15s973ms 13 2 30s285ms 15s142ms 14 2 35s490ms 17s745ms 15 2 1m13s 36s828ms 16 2 1m28s 44s444ms 17 2 31s288ms 15s644ms 18 2 30s645ms 15s322ms 19 2 28s695ms 14s347ms 20 1 1m25s 1m25s 21 2 28s259ms 14s129ms 22 2 26s906ms 13s453ms [ User: intelifix - Total duration: 12m42s - Times executed: 30 ]
[ Application: psql - Total duration: 12m42s - Times executed: 30 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-01 10:19:04 Duration: 1m29s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-01 07:16:47 Duration: 1m28s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-01 16:16:09 Duration: 1m27s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
7 10m56s 1,074 150ms 7s365ms 611ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 01 07 1 668ms 668ms 08 176 2m15s 770ms 09 136 1m11s 527ms 10 105 59s690ms 568ms 11 164 1m55s 702ms 13 108 54s258ms 502ms 14 106 50s860ms 479ms 15 177 1m39s 562ms 16 98 1m7s 687ms 17 3 1s368ms 456ms [ User: intelifix - Total duration: 10m56s - Times executed: 1074 ]
[ Application: [unknown] - Total duration: 10m56s - Times executed: 1074 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "229989", "modelo" : "454", "itens" : "241632869510,241611432334,241623988889,241633324358,241632959495,241625442635,241613516476,241613430408,241642656974,241626522931,241627094255,241643974062,241633395577,241626281415,241625021528,241624941823,241624945762,241633891417,241611267491,241627507482,241613352948,241642682331,241640035170,241611639301,241633543751,241632765762,241642538703,241611354548,241640480321,241640760909,241640751739,241640654355,241627528292,241633324964,241611424555,241633379010,241624896464,241642291126,241642268193,241612837386,241611632735,241644592338,241611286281,241623976464,241642316986", "usuario" : "405", "caixa" : "2755501", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-01 11:25:40 Duration: 7s365ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "229989", "modelo" : "320", "itens" : "241608042845,241639366081,241607791530,241670147087,241607944754,241661079603,241635017171,241707084149,241637510525,241655010022,241610321025,241661060511,241649282021,241608057795,241638205575,241703962341,241667823853,241598070514,241635616478,241651287996,241696846382,241597394858,241713030207,241651298604,241691272034,241621301221,241657992344,241702202225,241715728910,241629269595,230049317887,241629219715,241672305356,241674336082,241593934453,241715699614,241674383640,241699158404,241609134152,241664086574,241667147793,241667189010,230048936986,241656424446,241699305264,241629943254,241713986068", "usuario" : "405", "caixa" : "2754382", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-01 08:46:37 Duration: 6s668ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "247723", "modelo" : "141", "itens" : "229808434244,229925424360,229743782828,229751023142,229663207994,216945192749,229807078185,229743182332,229740180412,229813776774,229739571834,216936111122,229860239300,229805551932,229749364147,229786782749,229749654456,229667660506,229753666385,229690483036,229865466667,229733929194,229933907488,229751700212,229745027786,229685479405,229666226987,229665001425", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "246613126183,246542722343,246015906270,246566473437,246470247592,246457096477,246580745155,246547459707,246558991731,246630642831,246526413658,246441200819,226162347789,246596202635,246529402951,246621157898,246551559298,246498444250,246571290103,246520639514,246653208287,246543951318,246581918692,246531377486,246547113860,246498954962,246181022733 ,226260998292,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-01 16:09:14 Duration: 2s702ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
8 10m9s 2 2m1s 8m8s 5m4s analyze verbose;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 01 05 2 10m9s 5m4s [ User: intelifix - Total duration: 10m9s - Times executed: 2 ]
[ Application: psql - Total duration: 10m9s - Times executed: 2 ]
-
analyze verbose;
Date: 2026-06-01 05:08:10 Duration: 8m8s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
analyze verbose;
Date: 2026-06-01 05:10:11 Duration: 2m1s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
9 8m27s 139 206ms 36s139ms 3s650ms call rs_giga_triagem (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 01 00 7 49s122ms 7s17ms 01 6 14s57ms 2s342ms 02 6 13s647ms 2s274ms 03 6 13s120ms 2s186ms 04 6 12s572ms 2s95ms 05 6 12s57ms 2s9ms 06 6 12s455ms 2s75ms 07 6 14s904ms 2s484ms 08 6 15s616ms 2s602ms 09 6 37s323ms 6s220ms 10 6 19s600ms 3s266ms 11 6 21s998ms 3s666ms 12 6 20s344ms 3s390ms 13 6 21s706ms 3s617ms 14 6 21s595ms 3s599ms 15 6 21s591ms 3s598ms 16 6 56s835ms 9s472ms 17 6 19s397ms 3s232ms 18 6 20s791ms 3s465ms 19 6 18s734ms 3s122ms 20 6 31s758ms 5s293ms 21 6 18s975ms 3s162ms 22 6 19s157ms 3s192ms [ User: intelifix - Total duration: 8m27s - Times executed: 139 ]
[ Application: psql - Total duration: 8m27s - Times executed: 139 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-01 16:05:48 Duration: 36s139ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-01 09:05:27 Duration: 20s878ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-01 00:05:16 Duration: 14s885ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
10 8m15s 72 182ms 33s191ms 6s878ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 01 00 3 1s9ms 336ms 01 1 417ms 417ms 07 5 48s88ms 9s617ms 08 6 55s345ms 9s224ms 09 6 1m9s 11s630ms 10 6 37s844ms 6s307ms 11 6 59s151ms 9s858ms 12 6 55s666ms 9s277ms 13 4 11s720ms 2s930ms 14 6 46s39ms 7s673ms 15 6 1m3s 10s574ms 16 5 29s897ms 5s979ms 20 1 494ms 494ms 21 5 8s42ms 1s608ms 22 6 8s334ms 1s389ms [ User: intelifix - Total duration: 8m15s - Times executed: 72 ]
[ Application: psql - Total duration: 8m15s - Times executed: 72 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-01 09:15:34 Duration: 33s191ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-01 08:05:17 Duration: 16s212ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-01 15:25:15 Duration: 14s437ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
11 4m44s 29 7s849ms 11s982ms 9s818ms create table temp0000281425 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 01 15 15 2m32s 10s169ms 16 2 20s720ms 10s360ms 17 12 1m51s 9s288ms [ User: intelifix - Total duration: 4m44s - Times executed: 29 ]
[ Application: [unknown] - Total duration: 4m44s - Times executed: 29 ]
-
CREATE TABLE temp0000281425 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-01 15:56:02 Duration: 11s982ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
CREATE TABLE temp0000281425 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-01 15:02:58 Duration: 11s863ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
CREATE TABLE temp0000281425 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-01 15:33:23 Duration: 11s767ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
12 4m20s 28 7s732ms 11s143ms 9s317ms create table temp0000281365 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 01 11 20 3m8s 9s445ms 12 8 1m11s 8s997ms [ User: intelifix - Total duration: 4m20s - Times executed: 28 ]
[ Application: [unknown] - Total duration: 4m20s - Times executed: 28 ]
-
CREATE TABLE temp0000281365 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-01 12:06:35 Duration: 11s143ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
CREATE TABLE temp0000281365 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-01 11:28:09 Duration: 10s949ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
CREATE TABLE temp0000281365 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-01 11:31:26 Duration: 10s793ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
13 4m12s 3 1m15s 1m34s 1m24s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 01 00 1 1m22s 1m22s 20 1 1m34s 1m34s 23 1 1m15s 1m15s [ User: intelifix - Total duration: 4m12s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 4m12s - Times executed: 3 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-01 20:08:41 Duration: 1m34s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-01 00:21:19 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-01 23:36:37 Duration: 1m15s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-01.log
14 4m6s 26 8s154ms 11s637ms 9s477ms create table temp0000281359 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 01 08 11 1m46s 9s718ms 09 3 28s216ms 9s405ms 10 6 55s217ms 9s202ms 11 6 56s84ms 9s347ms [ User: intelifix - Total duration: 4m6s - Times executed: 26 ]
[ Application: [unknown] - Total duration: 4m6s - Times executed: 26 ]
-
CREATE TABLE temp0000281359 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-01 08:49:13 Duration: 11s637ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
CREATE TABLE temp0000281359 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-01 10:04:32 Duration: 10s517ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
CREATE TABLE temp0000281359 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-01 11:35:13 Duration: 10s492ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
15 4m1s 72 158ms 1m18s 3s352ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 01 07 6 4s920ms 820ms 08 7 1m51s 15s861ms 09 6 22s400ms 3s733ms 10 7 13s151ms 1s878ms 11 16 6s396ms 399ms 12 5 1s179ms 235ms 14 3 2s116ms 705ms 15 12 43s711ms 3s642ms 16 4 5s652ms 1s413ms 17 6 30s816ms 5s136ms [ User: intelifix - Total duration: 4m1s - Times executed: 72 ]
[ Application: psql - Total duration: 4m1s - Times executed: 72 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 506); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (024969);
Date: 2026-06-01 08:50:41 Duration: 1m18s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT RS_SETGLOBAL ('USUARIO', 506); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (024970);
Date: 2026-06-01 08:56:07 Duration: 27s888ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT RS_SETGLOBAL ('USUARIO', 506); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025017);
Date: 2026-06-01 15:50:59 Duration: 19s483ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
16 3m47s 47 3s71ms 26s679ms 4s830ms create table temp0000281319 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 01 07 17 1m25s 5s21ms 08 14 54s824ms 3s916ms 11 4 16s67ms 4s16ms 15 2 10s557ms 5s278ms 16 10 1m 6s22ms [ User: intelifix - Total duration: 3m47s - Times executed: 47 ]
[ Application: [unknown] - Total duration: 3m47s - Times executed: 47 ]
-
CREATE TABLE temp0000281319 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"27-05-2026", "ate" :"01-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-01 07:17:07 Duration: 26s679ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
CREATE TABLE temp0000281319 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"27-05-2026", "ate" :"01-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-01 16:20:48 Duration: 7s9ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
CREATE TABLE temp0000281319 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"27-05-2026", "ate" :"01-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-01 16:21:50 Duration: 6s982ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
17 3m30s 45 800ms 19s986ms 4s682ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 01 08 3 14s87ms 4s695ms 09 3 16s825ms 5s608ms 10 3 23s562ms 7s854ms 11 3 29s585ms 9s861ms 12 3 9s710ms 3s236ms 13 3 8s324ms 2s774ms 14 3 16s886ms 5s628ms 15 3 22s991ms 7s663ms 16 3 42s880ms 14s293ms 17 3 10s285ms 3s428ms 18 3 3s47ms 1s15ms 19 3 3s202ms 1s67ms 20 3 3s497ms 1s165ms 21 3 3s66ms 1s22ms 22 3 2s778ms 926ms [ User: intelifix - Total duration: 3m30s - Times executed: 45 ]
[ Application: psql - Total duration: 3m30s - Times executed: 45 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-06-01 16:00:21 Duration: 19s986ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-06-01 11:40:18 Duration: 17s51ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-06-01 15:20:14 Duration: 12s229ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
18 2m43s 3 48s102ms 1m4s 54s436ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 01 00 1 51s113ms 51s113ms 20 1 1m4s 1m4s 23 1 48s102ms 48s102ms [ User: intelifix - Total duration: 2m43s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 2m43s - Times executed: 3 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-01 20:05:24 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-01 00:02:45 Duration: 51s113ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-01 23:17:12 Duration: 48s102ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-01.log
19 2m11s 3 18s440ms 1m33s 43s711ms 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 #19
Day Hour Count Duration Avg duration Jun 01 00 1 19s346ms 19s346ms 23 2 1m51s 55s893ms [ User: intelifix - Total duration: 2m11s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 2m11s - Times executed: 3 ]
-
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-06-01 23:14:07 Duration: 1m33s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
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-06-01 00:22:53 Duration: 19s346ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
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-06-01 23:37:57 Duration: 18s440ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-01.log
20 1m59s 3 17s473ms 1m22s 39s720ms 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 Jun 01 00 1 17s473ms 17s473ms 23 2 1m41s 50s844ms [ User: intelifix - Total duration: 1m59s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 1m59s - Times executed: 3 ]
-
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-06-01 23:11:26 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
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-06-01 23:37:22 Duration: 18s700ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
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-06-01 00:22:17 Duration: 17s473ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-01.log
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,148 19m40s 150ms 7s211ms 1s28ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 01 07 10 5s692ms 569ms 08 66 55s593ms 842ms 09 135 2m30s 1s115ms 10 104 1m45s 1s17ms 11 146 2m41s 1s103ms 12 45 42s461ms 943ms 13 74 58s664ms 792ms 14 160 2m40s 1s5ms 15 209 3m29s 1s4ms 16 143 2m41s 1s130ms 17 56 1m7s 1s213ms [ User: intelifix - Total duration: 19m40s - Times executed: 1148 ]
[ Application: [unknown] - Total duration: 19m40s - Times executed: 1148 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (246983, 450, '270911029484102257,229780780626,229859455778,229785543245,229850572330,229784423955,229744257576,229747917597,229686752829,229688379496,229748636365,229787534954,216943448492,229688159295,229859044346,229755627687,229784415671,229669177488,229784646782,229736378907,229748992136,229806046480,229662814264,229753530817,229686398394,216937329108,229741334250,229736353147,229736517988,216944350512,229850430925,229925251919,229865502631,229686810613,229806009608,229812731836,229687496571,229787667189,229736525262,229816979803,229879788390', '246221011619,246651673952,246586896687,246641304859,246586401735,246547350505,246550149699,246499597583,246517613046,246552998496,246601754254,246468122234,246499578187,246639266175,246571479212,246586387793,246513407180,246597212240,246544703142,246551137282,246581917278,246466782642,246560536976,246499685976,246481991736,246550013952,246538673440,246544540725,246468161329,246642535069,246207520920,246298398396,246524373638,246581310924,246628757596,246564634245,246601738393,246544539512,246626485354,246652213051', 0141, 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":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-06-01 16:02:07 Duration: 7s211ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (247004, 450, '929240558751,203543169F1B,B01FF419CB06,20B82B249D9B,203543175393,B0924A114A2C,20B82B25BC4E,20354320EB97,D8CF61663DEF,9C24722F13E5,2035435941B5,2035435A2F14,B01FF41CDBF4,D8CF6160B915,B01FF41A8F29,2035431F26C0,CC5830FDE0A2,DC92726FBE88,2035431F4DA9,D8CF61664A05,441524E4FEF3,CC5830FDA450,2035435389B9,20354319A607,DC9272736D7B,203543168743,203543158F10,CC5830007149,203543138AC9,203543220F2F,20354358B530,CC5830FDCFED,CC583000A1D9,203543200FD4,94988F2F49D2,CC5830FF66DB,CC5830FF64F1,64FA2B6461C0,441524E4FF78,20354316B94D,CC5830FEC61A', '',0302,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-01 16:34:39 Duration: 6s435ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (246998, 450, '923081019181,CC5830E1F8C8,5CFA257F5480,C03C048724C5,841EA38DF98D,841EA38DA85E,582FF79C54EA,5CFA2515CAAB,841EA38D7432,345D9EB43ECB,209A7DB7C636,94988F930977,8CC5B4E31C64,B0BBE5498750,209A7DB3F895,186A81D58390,E8D2FFAB4F66,5CFA25AD3A3D,5CFA2515EE7D,943C96AD79E9,5CFA25AD1220,E8D2FFA674FE,345D9EB41216,186A81D4C777,ACD75BB74693,E4C0E2980B03,ACD75BB5F18B,C03C048647FF,C03C047FAA20,44D454608363,C4EB42A002EF,5CFA2580273D,D833B7A4438C,44ADB131D95A,C4EB42A33284,64FD965E0B06,64FD965E9B74,5447CC78D532,D833B7A42FC7,94988F30F05D,506F0C3B0F46', '',0155,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-01 14:19:52 Duration: 5s536ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
2 1,074 10m56s 150ms 7s365ms 611ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 01 07 1 668ms 668ms 08 176 2m15s 770ms 09 136 1m11s 527ms 10 105 59s690ms 568ms 11 164 1m55s 702ms 13 108 54s258ms 502ms 14 106 50s860ms 479ms 15 177 1m39s 562ms 16 98 1m7s 687ms 17 3 1s368ms 456ms [ User: intelifix - Total duration: 10m56s - Times executed: 1074 ]
[ Application: [unknown] - Total duration: 10m56s - Times executed: 1074 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "229989", "modelo" : "454", "itens" : "241632869510,241611432334,241623988889,241633324358,241632959495,241625442635,241613516476,241613430408,241642656974,241626522931,241627094255,241643974062,241633395577,241626281415,241625021528,241624941823,241624945762,241633891417,241611267491,241627507482,241613352948,241642682331,241640035170,241611639301,241633543751,241632765762,241642538703,241611354548,241640480321,241640760909,241640751739,241640654355,241627528292,241633324964,241611424555,241633379010,241624896464,241642291126,241642268193,241612837386,241611632735,241644592338,241611286281,241623976464,241642316986", "usuario" : "405", "caixa" : "2755501", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-01 11:25:40 Duration: 7s365ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "229989", "modelo" : "320", "itens" : "241608042845,241639366081,241607791530,241670147087,241607944754,241661079603,241635017171,241707084149,241637510525,241655010022,241610321025,241661060511,241649282021,241608057795,241638205575,241703962341,241667823853,241598070514,241635616478,241651287996,241696846382,241597394858,241713030207,241651298604,241691272034,241621301221,241657992344,241702202225,241715728910,241629269595,230049317887,241629219715,241672305356,241674336082,241593934453,241715699614,241674383640,241699158404,241609134152,241664086574,241667147793,241667189010,230048936986,241656424446,241699305264,241629943254,241713986068", "usuario" : "405", "caixa" : "2754382", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-01 08:46:37 Duration: 6s668ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "247723", "modelo" : "141", "itens" : "229808434244,229925424360,229743782828,229751023142,229663207994,216945192749,229807078185,229743182332,229740180412,229813776774,229739571834,216936111122,229860239300,229805551932,229749364147,229786782749,229749654456,229667660506,229753666385,229690483036,229865466667,229733929194,229933907488,229751700212,229745027786,229685479405,229666226987,229665001425", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "246613126183,246542722343,246015906270,246566473437,246470247592,246457096477,246580745155,246547459707,246558991731,246630642831,246526413658,246441200819,226162347789,246596202635,246529402951,246621157898,246551559298,246498444250,246571290103,246520639514,246653208287,246543951318,246581918692,246531377486,246547113860,246498954962,246181022733 ,226260998292,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-01 16:09:14 Duration: 2s702ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
3 226 1h57m11s 150ms 18m42s 31s111ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 01 07 13 13m7s 1m 08 22 7m57s 21s706ms 09 23 30m46s 1m20s 10 19 12m18s 38s884ms 11 33 4m33s 8s300ms 12 4 3m47s 56s776ms 13 3 4s972ms 1s657ms 14 28 9m48s 21s28ms 15 30 19m28s 38s966ms 16 19 8m54s 28s157ms 17 32 6m22s 11s940ms [ User: intelifix - Total duration: 1h57m11s - Times executed: 226 ]
[ Application: [unknown] - Total duration: 1h57m11s - Times executed: 226 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 024970, 0506 )', '/var/www/html/tmp/nf_carga_lotes_0506.xlsx');
Date: 2026-06-01 09:15:32 Duration: 18m42s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 024960, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-06-01 07:15:01 Duration: 5m37s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025006, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-06-01 14:32:02 Duration: 5m26s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
4 190 53s610ms 150ms 771ms 282ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 01 07 26 8s762ms 337ms 08 19 5s139ms 270ms 09 25 6s636ms 265ms 10 27 7s519ms 278ms 11 9 2s686ms 298ms 12 13 3s289ms 253ms 14 23 5s988ms 260ms 15 32 9s352ms 292ms 16 16 4s234ms 264ms [ User: intelifix - Total duration: 53s610ms - Times executed: 190 ]
[ Application: [unknown] - Total duration: 53s610ms - Times executed: 190 ]
-
SELECT * FROM RS_TRIAGEM (319, 5, '113', 3, '216930330210,229822769201,229644895960,229777913140,229731811133,229776565062,229708497184,229729211025,229766711531,229801527071,229833342736,229711666977,216926112222', NULL, NULL, 0137, 00);
Date: 2026-06-01 07:43:07 Duration: 771ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT * FROM RS_TRIAGEM (430, 5, '138', 6, '84011228B335,840112932B05,8401122903AE,84011293FC1E,9877E77CA98F,743AEFACCFE3,8401129349C8,840112934A62,9877E7BD0D24,1834AF994956,743AEFC4A5A7,9877E7001BCE,840112C2764D,743AEFC4AD72,840112DFFA28,8401122A5A4C,84011206D622,1834AF280881,743AEF7405BC,84011280194A,743AEF347993,9877E7BCC41B,1834AF295707,8401125FD281,9877E74EB53F,1834AF2642E6,743AEF74438F,743AEF33D170,9877E7098B7C', NULL, NULL, 0153, 00);
Date: 2026-06-01 15:16:47 Duration: 697ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT * FROM RS_TRIAGEM (403, 5, '113', 3, '216651508485,216715815671,216586144666,216582699414', NULL, NULL, 034, 00);
Date: 2026-06-01 07:01:56 Duration: 637ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
5 154 1m32s 151ms 4s491ms 600ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 01 07 9 11s447ms 1s271ms 08 18 7s423ms 412ms 09 12 8s913ms 742ms 10 13 4s685ms 360ms 11 22 8s928ms 405ms 13 2 483ms 241ms 14 26 17s216ms 662ms 15 13 10s936ms 841ms 16 18 7s25ms 390ms 17 21 15s405ms 733ms [ User: intelifix - Total duration: 1m32s - Times executed: 154 ]
[ Application: [unknown] - Total duration: 1m32s - Times executed: 154 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0247463) LIMIT 1;
Date: 2026-06-01 15:04:07 Duration: 4s491ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0247300) LIMIT 1;
Date: 2026-06-01 14:56:06 Duration: 2s896ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0247049) LIMIT 1;
Date: 2026-06-01 07:42:21 Duration: 2s586ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
6 139 8m27s 206ms 36s139ms 3s650ms call rs_giga_triagem (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 01 00 7 49s122ms 7s17ms 01 6 14s57ms 2s342ms 02 6 13s647ms 2s274ms 03 6 13s120ms 2s186ms 04 6 12s572ms 2s95ms 05 6 12s57ms 2s9ms 06 6 12s455ms 2s75ms 07 6 14s904ms 2s484ms 08 6 15s616ms 2s602ms 09 6 37s323ms 6s220ms 10 6 19s600ms 3s266ms 11 6 21s998ms 3s666ms 12 6 20s344ms 3s390ms 13 6 21s706ms 3s617ms 14 6 21s595ms 3s599ms 15 6 21s591ms 3s598ms 16 6 56s835ms 9s472ms 17 6 19s397ms 3s232ms 18 6 20s791ms 3s465ms 19 6 18s734ms 3s122ms 20 6 31s758ms 5s293ms 21 6 18s975ms 3s162ms 22 6 19s157ms 3s192ms [ User: intelifix - Total duration: 8m27s - Times executed: 139 ]
[ Application: psql - Total duration: 8m27s - Times executed: 139 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-01 16:05:48 Duration: 36s139ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-01 09:05:27 Duration: 20s878ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-01 00:05:16 Duration: 14s885ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
7 117 22s762ms 150ms 975ms 194ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 01 07 1 246ms 246ms 08 2 1s160ms 580ms 12 1 184ms 184ms 13 2 417ms 208ms 14 8 1s389ms 173ms 15 25 5s373ms 214ms 16 68 12s209ms 179ms 17 10 1s781ms 178ms [ User: intelifix - Total duration: 22s762ms - Times executed: 117 ]
[ Application: [unknown] - Total duration: 22s762ms - Times executed: 117 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "0", "data-de" : "2026-06-01", "data-ate" : "2026-06-01", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "0", "usuario" : 506 }');
Date: 2026-06-01 08:48:35 Duration: 975ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "307", "data-de" : "2026-06-01", "data-ate" : "2026-06-01", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 304 }');
Date: 2026-06-01 15:05:51 Duration: 783ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "312", "data-de" : "2026-06-01", "data-ate" : "2026-06-01", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 320 }');
Date: 2026-06-01 16:34:15 Duration: 500ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
8 106 17m16s 7s568ms 40s788ms 9s777ms create table temp0000281319 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 01 07 17 2m53s 10s219ms 08 12 1m50s 9s206ms 09 13 2m8s 9s868ms 10 14 2m11s 9s394ms 11 12 1m48s 9s43ms 14 7 1m5s 9s304ms 15 20 3m23s 10s188ms 16 11 1m54s 10s449ms [ User: intelifix - Total duration: 17m16s - Times executed: 106 ]
[ Application: [unknown] - Total duration: 17m16s - Times executed: 106 ]
-
CREATE TABLE temp0000281319 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-01 07:05:26 Duration: 40s788ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
CREATE TABLE temp0000281319 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-01 16:13:05 Duration: 13s176ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
CREATE TABLE temp0000281319 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-01 16:13:37 Duration: 11s941ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
9 105 28s321ms 150ms 481ms 269ms select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 01 08 55 14s568ms 264ms 11 49 13s418ms 273ms 16 1 334ms 334ms [ User: intelifix - Total duration: 28s321ms - Times executed: 105 ]
[ Application: [unknown] - Total duration: 28s321ms - Times executed: 105 ]
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (229989);
Date: 2026-06-01 11:23:07 Duration: 481ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (229989);
Date: 2026-06-01 11:26:15 Duration: 448ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (0229989);
Date: 2026-06-01 08:46:09 Duration: 420ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
10 87 37s63ms 151ms 1s387ms 426ms 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 #10
Day Hour Count Duration Avg duration Jun 01 08 32 20s654ms 645ms 09 7 1s320ms 188ms 10 9 1s965ms 218ms 11 12 6s628ms 552ms 13 6 1s228ms 204ms 14 1 202ms 202ms 15 14 3s336ms 238ms 16 4 1s223ms 305ms 17 2 502ms 251ms [ User: intelifix - Total duration: 37s63ms - Times executed: 87 ]
[ Application: [unknown] - Total duration: 37s63ms - Times executed: 87 ]
-
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 = 2754382 ORDER BY A.CAI_ORDEM;
Date: 2026-06-01 08:46:10 Duration: 1s387ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
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 = 2549988 ORDER BY A.CAI_ORDEM;
Date: 2026-06-01 08:14:34 Duration: 1s346ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
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 = 2426297 ORDER BY A.CAI_ORDEM;
Date: 2026-06-01 08:12:36 Duration: 1s265ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
11 83 33s198ms 150ms 1s194ms 399ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 01 14 27 12s270ms 454ms 16 39 15s819ms 405ms 17 17 5s108ms 300ms [ User: intelifix - Total duration: 33s198ms - Times executed: 83 ]
[ Application: [unknown] - Total duration: 33s198ms - Times executed: 83 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"39875","seriais":"229746453145,229668316080,229748897378,229815423546,229748462129,229933726584,229735499517,229664372441,229751586687,229787128494,229734697283,229812769920,229748296175,229783568002,229813668099,229673257785,216939954751,229780670615,229879721112,229739160526,229737738096,229728476373,229690168606","usuario":"406","observacao":""}');
Date: 2026-06-01 14:12:02 Duration: 1s194ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"39875","seriais":"230043625873,241592449516,241671524663,241703971635,241700940015,241622593838,241672210421,241636045162,241704357283,241668202027,241618245052,241729937490,241654536989,241673393353,241631733451,241658435372,241656937077,241637703248,241654609802,241730917395,241668207784,241668191016,241731247281,241659743648,241676707480,241708962133,241659847597,241693220911,241679928591,241671537593,241728751629,241604781932,241729509110,241728545671,241660134954","usuario":"406","observacao":""}');
Date: 2026-06-01 16:55:53 Duration: 1s153ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"39875","seriais":"203AEBA6F852,CC29BDED3785,CC29BDEDA6D1,6877DA62CE87,6877DA616D9F,D8E8448CC4C2,802D1A20B8CC,802D1A1F9108,F42D064635AB,E0B6680A41C8,F42D0646477B,D8E8448AF716,6877DA61FA9B,D8E8448AFDBA,6877DA58C4B7,D8E8448B3D46,6877DA62CEE3,6877DA59D16F,6877DA58C83F,6877DA5F2407,CC29BDEC4BE9,D8E8448AF72A,203AEBA778F2,D8E844AB4762,F42D0646489B,F42D0645BDE3,802D1A1F90AC,6877DA5BFBFF,D8E8448B6DEE,802D1A20BA60,CC29BDED3739,CC29BDED578D,CC29BDED2259,E0B6680A1050,CC29BDED2755,6877DA620107,203AEBA775AE,6877DA59CAE7,6877DA6200A3,F42D064664DB","usuario":"406","observacao":""}');
Date: 2026-06-01 14:19:49 Duration: 878ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
12 72 8m15s 182ms 33s191ms 6s878ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 01 00 3 1s9ms 336ms 01 1 417ms 417ms 07 5 48s88ms 9s617ms 08 6 55s345ms 9s224ms 09 6 1m9s 11s630ms 10 6 37s844ms 6s307ms 11 6 59s151ms 9s858ms 12 6 55s666ms 9s277ms 13 4 11s720ms 2s930ms 14 6 46s39ms 7s673ms 15 6 1m3s 10s574ms 16 5 29s897ms 5s979ms 20 1 494ms 494ms 21 5 8s42ms 1s608ms 22 6 8s334ms 1s389ms [ User: intelifix - Total duration: 8m15s - Times executed: 72 ]
[ Application: psql - Total duration: 8m15s - Times executed: 72 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-01 09:15:34 Duration: 33s191ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-01 08:05:17 Duration: 16s212ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-01 15:25:15 Duration: 14s437ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
13 72 4m1s 158ms 1m18s 3s352ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 01 07 6 4s920ms 820ms 08 7 1m51s 15s861ms 09 6 22s400ms 3s733ms 10 7 13s151ms 1s878ms 11 16 6s396ms 399ms 12 5 1s179ms 235ms 14 3 2s116ms 705ms 15 12 43s711ms 3s642ms 16 4 5s652ms 1s413ms 17 6 30s816ms 5s136ms [ User: intelifix - Total duration: 4m1s - Times executed: 72 ]
[ Application: psql - Total duration: 4m1s - Times executed: 72 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 506); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (024969);
Date: 2026-06-01 08:50:41 Duration: 1m18s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT RS_SETGLOBAL ('USUARIO', 506); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (024970);
Date: 2026-06-01 08:56:07 Duration: 27s888ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT RS_SETGLOBAL ('USUARIO', 506); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025017);
Date: 2026-06-01 15:50:59 Duration: 19s483ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
14 72 11s714ms 150ms 208ms 162ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 01 07 1 162ms 162ms 08 5 820ms 164ms 09 6 954ms 159ms 10 2 373ms 186ms 11 7 1s102ms 157ms 12 1 185ms 185ms 13 5 805ms 161ms 14 5 805ms 161ms 15 14 2s222ms 158ms 16 26 4s284ms 164ms [ User: intelifix - Total duration: 11s714ms - Times executed: 72 ]
[ Application: [unknown] - Total duration: 11s714ms - Times executed: 72 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-06-01 10:13:16 Duration: 208ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-06-01 16:17:51 Duration: 204ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0155;
Date: 2026-06-01 16:14:38 Duration: 189ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
15 71 30s858ms 282ms 723ms 434ms 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 #15
Day Hour Count Duration Avg duration Jun 01 06 1 369ms 369ms 07 3 1s238ms 412ms 08 7 3s431ms 490ms 09 6 2s899ms 483ms 10 6 2s546ms 424ms 11 9 3s797ms 421ms 12 2 885ms 442ms 13 7 3s44ms 434ms 14 6 2s437ms 406ms 15 13 5s581ms 429ms 16 7 2s890ms 412ms 17 2 815ms 407ms 21 2 920ms 460ms [ User: lenon - Total duration: 30s858ms - Times executed: 71 ]
[ Application: [unknown] - Total duration: 30s858ms - Times executed: 71 ]
-
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-06-01 09:14:35 Duration: 723ms Database: contagem User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
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-06-01 11:19:03 Duration: 705ms Database: contagem User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
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-06-01 08:39:16 Duration: 675ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-01.log
16 70 18s974ms 150ms 799ms 271ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 01 08 5 1s538ms 307ms 09 13 4s169ms 320ms 10 15 3s874ms 258ms 11 10 2s168ms 216ms 12 12 2s898ms 241ms 13 7 1s601ms 228ms 17 8 2s723ms 340ms [ User: intelifix - Total duration: 18s974ms - Times executed: 70 ]
[ Application: [unknown] - Total duration: 18s974ms - Times executed: 70 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 1, 7, '216650232537,216787884747,216579190217,465030260507,216764578196,216601395761,216382827595,216576029818,216657920224,216772982328,216721468590,216572518397,216785245971,216481421629,216571534351,216494725968,216421326571,216742233446,216391760320,216748792021,216807668989,216591183856,216594974046,216380044866,216715212829,216775316371,216432519516,216578344365,216744673942,216599633850,216742672535,216588110515,216469201828,216774351721,216765357879,216658120423,216392113339,216573489110,465034635468,216496124354', '113;1', 'DEFAULT', 00, 034, '','', '', 00);
Date: 2026-06-01 17:21:22 Duration: 799ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 1, 26, '216588110313,216750018290,446AB715E800,216653777192,216326441027,216497009198,216676495167,216482042329,216651826272,216583853051,216579243050,216806053131,216381014848,216695617998,216437311634,216482730208,216471266372,216569462735,216574407493,216653658493,216655080216,216588178400,216577367490,216572867477,216475178392,216574862746,216692800115,216594807991,216776287184,216571689595,184292484257,216471045363,216489065775,216484598694,216594307179,216491375069,216710343252,216485481015,216807240004,216774837076,216678637272,216585103644,216425500818,216388405255,216492145256,216651903452,216467806977,216491866991,216658292942,216475080808,216658324359,216587741938,216775359608,216711457288,216431890308,216471675256,216486679504,216579074346,216591316472,216652274655,216593117579,216778161532,216474808503,184291153959,216585158902,216323863951,216709257275', '','DEFAULT',051,034,'', '','', 00);
Date: 2026-06-01 09:47:19 Duration: 736ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 1, 26, '216588110313,216653777192,216326441027,216497009198,216482042329,216651826272,216583853051,216579243050,216806053131,216695617998,216437311634,216482730208,216471266372,216569462735,216574407493,216653658493,216655080216,216588178400,216577367490,216572867477,216475178392,216574862746,216692800115,216776287184,216571689595,216471045363,216484598694,216594307179,216491375069,216710343252,216485481015,216807240004,216774837076,216678637272,216585103644,216425500818,216388405255,216492145256,216651903452,216467806977,216491866991,216658292942,216658324359,216587741938,216711457288,216431890308,216471675256,216486679504,216579074346,216591316472,216652274655,216593117579,216778161532,216474808503,184291153959,216585158902,216323863951,216709257275', '','DEFAULT',051,034,'', '','', 00);
Date: 2026-06-01 09:47:37 Duration: 606ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
17 69 13s290ms 150ms 473ms 192ms select * from rs_lote_manutencao (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 01 07 8 2s46ms 255ms 08 7 1s440ms 205ms 10 4 853ms 213ms 11 13 2s416ms 185ms 12 4 744ms 186ms 13 1 160ms 160ms 14 13 2s100ms 161ms 15 5 861ms 172ms 16 13 2s496ms 192ms 17 1 170ms 170ms [ User: intelifix - Total duration: 13s290ms - Times executed: 69 ]
[ Application: [unknown] - Total duration: 13s290ms - Times executed: 69 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"316", "usuario" :"320", "tipo" :"N", "itens" :"002", "nota-fiscal" :"1563", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-06-01 07:17:15 Duration: 473ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"2", "cliente" :"1", "modelo" :"302", "usuario" :"407", "tipo" :"N", "itens" :"002", "nota-fiscal" :"9951", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-06-01 10:34:54 Duration: 389ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"137", "usuario" :"320", "tipo" :"N", "itens" :"001", "nota-fiscal" :"1563", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-06-01 16:26:00 Duration: 291ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
18 68 36s737ms 384ms 932ms 540ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 01 07 3 1s515ms 505ms 08 7 4s227ms 603ms 09 5 2s913ms 582ms 10 6 3s128ms 521ms 11 8 4s173ms 521ms 12 2 1s31ms 515ms 13 7 3s728ms 532ms 14 6 3s162ms 527ms 15 13 6s750ms 519ms 16 7 3s731ms 533ms 17 2 950ms 475ms 21 2 1s424ms 712ms [ User: intelifix - Total duration: 36s737ms - Times executed: 68 ]
[ Application: [unknown] - Total duration: 36s737ms - Times executed: 68 ]
-
select * from rs_menu_grants (477, 19, 1);
Date: 2026-06-01 21:02:32 Duration: 932ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
select * from rs_menu_grants (407, 18, 1);
Date: 2026-06-01 09:14:35 Duration: 812ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
select * from rs_menu_grants (407, 18, 1);
Date: 2026-06-01 11:19:03 Duration: 777ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
19 66 1m45s 150ms 23s497ms 1s597ms create table temp0000281339 as select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 01 08 17 52s215ms 3s71ms 09 3 551ms 183ms 10 12 2s451ms 204ms 11 9 45s367ms 5s40ms 13 3 500ms 166ms 14 6 1s149ms 191ms 15 12 2s423ms 201ms 16 4 742ms 185ms [ User: intelifix - Total duration: 1m45s - Times executed: 66 ]
[ Application: [unknown] - Total duration: 1m45s - Times executed: 66 ]
-
CREATE TABLE temp0000281339 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "229989", "oficina" : "6", "cliente" : "0", "nf" : "", "data-de" : "29-05-2026", "data-ate" : "01-07-2026", "grupo" : "0", "status" : "1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-06-01 11:22:42 Duration: 23s497ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
CREATE TABLE temp0000281339 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "241543", "oficina" : "6", "cliente" : "0", "nf" : "", "data-de" : "29-05-2026", "data-ate" : "01-07-2026", "grupo" : "0", "status" : "1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-06-01 08:08:03 Duration: 17s815ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
CREATE TABLE temp0000281339 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "229989", "oficina" : "6", "cliente" : "0", "nf" : "", "data-de" : "29-05-2026", "data-ate" : "01-07-2026", "grupo" : "0", "status" : "1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-06-01 08:43:28 Duration: 15s240ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
20 60 21s359ms 207ms 615ms 355ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 01 07 3 917ms 305ms 08 6 2s660ms 443ms 09 8 3s10ms 376ms 10 4 1s172ms 293ms 11 12 4s339ms 361ms 12 4 1s256ms 314ms 14 2 793ms 396ms 15 11 3s507ms 318ms 16 3 1s257ms 419ms 17 7 2s443ms 349ms [ User: intelifix - Total duration: 21s359ms - Times executed: 60 ]
[ Application: [unknown] - Total duration: 21s359ms - Times executed: 60 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-06-01 16:55:10 Duration: 615ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-06-01 08:29:58 Duration: 569ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-06-01 11:21:16 Duration: 535ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m2s 19m42s 10m52s 2 21m45s select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 01 00 2 21m45s 10m52s [ User: lenon - Total duration: 21m45s - Times executed: 2 ]
[ Application: psql - Total duration: 21m45s - Times executed: 2 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-06-01 00:21:44 Duration: 19m42s Database: rio User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-06-01 00:23:47 Duration: 2m2s Database: contagem User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-06-01 00:21:44 Duration: 0ms Database: rio User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
2 2m1s 8m8s 5m4s 2 10m9s analyze verbose;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 01 05 2 10m9s 5m4s [ User: intelifix - Total duration: 10m9s - Times executed: 2 ]
[ Application: psql - Total duration: 10m9s - Times executed: 2 ]
-
analyze verbose;
Date: 2026-06-01 05:08:10 Duration: 8m8s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
analyze verbose;
Date: 2026-06-01 05:10:11 Duration: 2m1s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
3 994ms 12m33s 3m33s 32 1h53m50s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 01 07 2 10m20s 5m10s 08 2 5m39s 2m49s 09 2 6m34s 3m17s 10 2 12m38s 6m19s 11 2 5m50s 2m55s 12 2 6m4s 3m2s 13 2 5m36s 2m48s 14 2 6m13s 3m6s 15 2 7m32s 3m46s 16 2 9m43s 4m51s 17 2 5m48s 2m54s 18 2 5m15s 2m37s 19 2 5m23s 2m41s 20 2 10m47s 5m23s 21 2 5m5s 2m32s 22 2 5m14s 2m37s [ User: intelifix - Total duration: 1h53m50s - Times executed: 32 ]
[ Application: psql - Total duration: 1h53m50s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-01 10:17:35 Duration: 12m33s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-01 20:15:45 Duration: 10m44s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-01 07:15:18 Duration: 10m16s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
4 1m15s 1m34s 1m24s 3 4m12s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 01 00 1 1m22s 1m22s 20 1 1m34s 1m34s 23 1 1m15s 1m15s [ User: intelifix - Total duration: 4m12s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 4m12s - Times executed: 3 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-01 20:08:41 Duration: 1m34s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-01 00:21:19 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-01 23:36:37 Duration: 1m15s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-01.log
5 48s102ms 1m4s 54s436ms 3 2m43s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 01 00 1 51s113ms 51s113ms 20 1 1m4s 1m4s 23 1 48s102ms 48s102ms [ User: intelifix - Total duration: 2m43s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 2m43s - Times executed: 3 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-01 20:05:24 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-01 00:02:45 Duration: 51s113ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-01 23:17:12 Duration: 48s102ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-01.log
6 18s440ms 1m33s 43s711ms 3 2m11s copy auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 01 00 1 19s346ms 19s346ms 23 2 1m51s 55s893ms [ User: intelifix - Total duration: 2m11s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 2m11s - Times executed: 3 ]
-
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-06-01 23:14:07 Duration: 1m33s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
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-06-01 00:22:53 Duration: 19s346ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
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-06-01 23:37:57 Duration: 18s440ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-01.log
7 17s473ms 1m22s 39s720ms 3 1m59s copy auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 01 00 1 17s473ms 17s473ms 23 2 1m41s 50s844ms [ User: intelifix - Total duration: 1m59s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 1m59s - Times executed: 3 ]
-
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-06-01 23:11:26 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
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-06-01 23:37:22 Duration: 18s700ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
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-06-01 00:22:17 Duration: 17s473ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-01.log
8 150ms 18m42s 31s111ms 226 1h57m11s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 01 07 13 13m7s 1m 08 22 7m57s 21s706ms 09 23 30m46s 1m20s 10 19 12m18s 38s884ms 11 33 4m33s 8s300ms 12 4 3m47s 56s776ms 13 3 4s972ms 1s657ms 14 28 9m48s 21s28ms 15 30 19m28s 38s966ms 16 19 8m54s 28s157ms 17 32 6m22s 11s940ms [ User: intelifix - Total duration: 1h57m11s - Times executed: 226 ]
[ Application: [unknown] - Total duration: 1h57m11s - Times executed: 226 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 024970, 0506 )', '/var/www/html/tmp/nf_carga_lotes_0506.xlsx');
Date: 2026-06-01 09:15:32 Duration: 18m42s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 024960, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-06-01 07:15:01 Duration: 5m37s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025006, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-06-01 14:32:02 Duration: 5m26s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
9 436ms 1m29s 25s414ms 30 12m42s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 01 07 2 1m30s 45s468ms 08 2 27s611ms 13s805ms 09 1 28s875ms 28s875ms 10 2 1m31s 45s839ms 11 2 32s93ms 16s46ms 12 2 31s947ms 15s973ms 13 2 30s285ms 15s142ms 14 2 35s490ms 17s745ms 15 2 1m13s 36s828ms 16 2 1m28s 44s444ms 17 2 31s288ms 15s644ms 18 2 30s645ms 15s322ms 19 2 28s695ms 14s347ms 20 1 1m25s 1m25s 21 2 28s259ms 14s129ms 22 2 26s906ms 13s453ms [ User: intelifix - Total duration: 12m42s - Times executed: 30 ]
[ Application: psql - Total duration: 12m42s - Times executed: 30 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-01 10:19:04 Duration: 1m29s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-01 07:16:47 Duration: 1m28s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-01 16:16:09 Duration: 1m27s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
10 7s849ms 11s982ms 9s818ms 29 4m44s create table temp0000281425 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 01 15 15 2m32s 10s169ms 16 2 20s720ms 10s360ms 17 12 1m51s 9s288ms [ User: intelifix - Total duration: 4m44s - Times executed: 29 ]
[ Application: [unknown] - Total duration: 4m44s - Times executed: 29 ]
-
CREATE TABLE temp0000281425 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-01 15:56:02 Duration: 11s982ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
CREATE TABLE temp0000281425 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-01 15:02:58 Duration: 11s863ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
CREATE TABLE temp0000281425 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-01 15:33:23 Duration: 11s767ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
11 7s568ms 40s788ms 9s777ms 106 17m16s create table temp0000281319 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 01 07 17 2m53s 10s219ms 08 12 1m50s 9s206ms 09 13 2m8s 9s868ms 10 14 2m11s 9s394ms 11 12 1m48s 9s43ms 14 7 1m5s 9s304ms 15 20 3m23s 10s188ms 16 11 1m54s 10s449ms [ User: intelifix - Total duration: 17m16s - Times executed: 106 ]
[ Application: [unknown] - Total duration: 17m16s - Times executed: 106 ]
-
CREATE TABLE temp0000281319 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-01 07:05:26 Duration: 40s788ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
CREATE TABLE temp0000281319 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-01 16:13:05 Duration: 13s176ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
CREATE TABLE temp0000281319 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-01 16:13:37 Duration: 11s941ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
12 8s154ms 11s637ms 9s477ms 26 4m6s create table temp0000281359 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 01 08 11 1m46s 9s718ms 09 3 28s216ms 9s405ms 10 6 55s217ms 9s202ms 11 6 56s84ms 9s347ms [ User: intelifix - Total duration: 4m6s - Times executed: 26 ]
[ Application: [unknown] - Total duration: 4m6s - Times executed: 26 ]
-
CREATE TABLE temp0000281359 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-01 08:49:13 Duration: 11s637ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
CREATE TABLE temp0000281359 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-01 10:04:32 Duration: 10s517ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
CREATE TABLE temp0000281359 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-01 11:35:13 Duration: 10s492ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
13 7s732ms 11s143ms 9s317ms 28 4m20s create table temp0000281365 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 01 11 20 3m8s 9s445ms 12 8 1m11s 8s997ms [ User: intelifix - Total duration: 4m20s - Times executed: 28 ]
[ Application: [unknown] - Total duration: 4m20s - Times executed: 28 ]
-
CREATE TABLE temp0000281365 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-01 12:06:35 Duration: 11s143ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
CREATE TABLE temp0000281365 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-01 11:28:09 Duration: 10s949ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
CREATE TABLE temp0000281365 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-01 11:31:26 Duration: 10s793ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
14 182ms 33s191ms 6s878ms 72 8m15s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 01 00 3 1s9ms 336ms 01 1 417ms 417ms 07 5 48s88ms 9s617ms 08 6 55s345ms 9s224ms 09 6 1m9s 11s630ms 10 6 37s844ms 6s307ms 11 6 59s151ms 9s858ms 12 6 55s666ms 9s277ms 13 4 11s720ms 2s930ms 14 6 46s39ms 7s673ms 15 6 1m3s 10s574ms 16 5 29s897ms 5s979ms 20 1 494ms 494ms 21 5 8s42ms 1s608ms 22 6 8s334ms 1s389ms [ User: intelifix - Total duration: 8m15s - Times executed: 72 ]
[ Application: psql - Total duration: 8m15s - Times executed: 72 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-01 09:15:34 Duration: 33s191ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-01 08:05:17 Duration: 16s212ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-01 15:25:15 Duration: 14s437ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
15 3s71ms 26s679ms 4s830ms 47 3m47s create table temp0000281319 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 01 07 17 1m25s 5s21ms 08 14 54s824ms 3s916ms 11 4 16s67ms 4s16ms 15 2 10s557ms 5s278ms 16 10 1m 6s22ms [ User: intelifix - Total duration: 3m47s - Times executed: 47 ]
[ Application: [unknown] - Total duration: 3m47s - Times executed: 47 ]
-
CREATE TABLE temp0000281319 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"27-05-2026", "ate" :"01-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-01 07:17:07 Duration: 26s679ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
CREATE TABLE temp0000281319 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"27-05-2026", "ate" :"01-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-01 16:20:48 Duration: 7s9ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
CREATE TABLE temp0000281319 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"27-05-2026", "ate" :"01-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-01 16:21:50 Duration: 6s982ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
16 800ms 19s986ms 4s682ms 45 3m30s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 01 08 3 14s87ms 4s695ms 09 3 16s825ms 5s608ms 10 3 23s562ms 7s854ms 11 3 29s585ms 9s861ms 12 3 9s710ms 3s236ms 13 3 8s324ms 2s774ms 14 3 16s886ms 5s628ms 15 3 22s991ms 7s663ms 16 3 42s880ms 14s293ms 17 3 10s285ms 3s428ms 18 3 3s47ms 1s15ms 19 3 3s202ms 1s67ms 20 3 3s497ms 1s165ms 21 3 3s66ms 1s22ms 22 3 2s778ms 926ms [ User: intelifix - Total duration: 3m30s - Times executed: 45 ]
[ Application: psql - Total duration: 3m30s - Times executed: 45 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-06-01 16:00:21 Duration: 19s986ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-06-01 11:40:18 Duration: 17s51ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-06-01 15:20:14 Duration: 12s229ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
17 206ms 36s139ms 3s650ms 139 8m27s call rs_giga_triagem (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 01 00 7 49s122ms 7s17ms 01 6 14s57ms 2s342ms 02 6 13s647ms 2s274ms 03 6 13s120ms 2s186ms 04 6 12s572ms 2s95ms 05 6 12s57ms 2s9ms 06 6 12s455ms 2s75ms 07 6 14s904ms 2s484ms 08 6 15s616ms 2s602ms 09 6 37s323ms 6s220ms 10 6 19s600ms 3s266ms 11 6 21s998ms 3s666ms 12 6 20s344ms 3s390ms 13 6 21s706ms 3s617ms 14 6 21s595ms 3s599ms 15 6 21s591ms 3s598ms 16 6 56s835ms 9s472ms 17 6 19s397ms 3s232ms 18 6 20s791ms 3s465ms 19 6 18s734ms 3s122ms 20 6 31s758ms 5s293ms 21 6 18s975ms 3s162ms 22 6 19s157ms 3s192ms [ User: intelifix - Total duration: 8m27s - Times executed: 139 ]
[ Application: psql - Total duration: 8m27s - Times executed: 139 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-01 16:05:48 Duration: 36s139ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-01 09:05:27 Duration: 20s878ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-01 00:05:16 Duration: 14s885ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
18 158ms 1m18s 3s352ms 72 4m1s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 01 07 6 4s920ms 820ms 08 7 1m51s 15s861ms 09 6 22s400ms 3s733ms 10 7 13s151ms 1s878ms 11 16 6s396ms 399ms 12 5 1s179ms 235ms 14 3 2s116ms 705ms 15 12 43s711ms 3s642ms 16 4 5s652ms 1s413ms 17 6 30s816ms 5s136ms [ User: intelifix - Total duration: 4m1s - Times executed: 72 ]
[ Application: psql - Total duration: 4m1s - Times executed: 72 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 506); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (024969);
Date: 2026-06-01 08:50:41 Duration: 1m18s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT RS_SETGLOBAL ('USUARIO', 506); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (024970);
Date: 2026-06-01 08:56:07 Duration: 27s888ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT RS_SETGLOBAL ('USUARIO', 506); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025017);
Date: 2026-06-01 15:50:59 Duration: 19s483ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-01.log
19 150ms 23s497ms 1s597ms 66 1m45s create table temp0000281339 as select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 01 08 17 52s215ms 3s71ms 09 3 551ms 183ms 10 12 2s451ms 204ms 11 9 45s367ms 5s40ms 13 3 500ms 166ms 14 6 1s149ms 191ms 15 12 2s423ms 201ms 16 4 742ms 185ms [ User: intelifix - Total duration: 1m45s - Times executed: 66 ]
[ Application: [unknown] - Total duration: 1m45s - Times executed: 66 ]
-
CREATE TABLE temp0000281339 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "229989", "oficina" : "6", "cliente" : "0", "nf" : "", "data-de" : "29-05-2026", "data-ate" : "01-07-2026", "grupo" : "0", "status" : "1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-06-01 11:22:42 Duration: 23s497ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
CREATE TABLE temp0000281339 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "241543", "oficina" : "6", "cliente" : "0", "nf" : "", "data-de" : "29-05-2026", "data-ate" : "01-07-2026", "grupo" : "0", "status" : "1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-06-01 08:08:03 Duration: 17s815ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
CREATE TABLE temp0000281339 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "229989", "oficina" : "6", "cliente" : "0", "nf" : "", "data-de" : "29-05-2026", "data-ate" : "01-07-2026", "grupo" : "0", "status" : "1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-06-01 08:43:28 Duration: 15s240ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
20 150ms 7s211ms 1s28ms 1,148 19m40s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 01 07 10 5s692ms 569ms 08 66 55s593ms 842ms 09 135 2m30s 1s115ms 10 104 1m45s 1s17ms 11 146 2m41s 1s103ms 12 45 42s461ms 943ms 13 74 58s664ms 792ms 14 160 2m40s 1s5ms 15 209 3m29s 1s4ms 16 143 2m41s 1s130ms 17 56 1m7s 1s213ms [ User: intelifix - Total duration: 19m40s - Times executed: 1148 ]
[ Application: [unknown] - Total duration: 19m40s - Times executed: 1148 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (246983, 450, '270911029484102257,229780780626,229859455778,229785543245,229850572330,229784423955,229744257576,229747917597,229686752829,229688379496,229748636365,229787534954,216943448492,229688159295,229859044346,229755627687,229784415671,229669177488,229784646782,229736378907,229748992136,229806046480,229662814264,229753530817,229686398394,216937329108,229741334250,229736353147,229736517988,216944350512,229850430925,229925251919,229865502631,229686810613,229806009608,229812731836,229687496571,229787667189,229736525262,229816979803,229879788390', '246221011619,246651673952,246586896687,246641304859,246586401735,246547350505,246550149699,246499597583,246517613046,246552998496,246601754254,246468122234,246499578187,246639266175,246571479212,246586387793,246513407180,246597212240,246544703142,246551137282,246581917278,246466782642,246560536976,246499685976,246481991736,246550013952,246538673440,246544540725,246468161329,246642535069,246207520920,246298398396,246524373638,246581310924,246628757596,246564634245,246601738393,246544539512,246626485354,246652213051', 0141, 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":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-06-01 16:02:07 Duration: 7s211ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (247004, 450, '929240558751,203543169F1B,B01FF419CB06,20B82B249D9B,203543175393,B0924A114A2C,20B82B25BC4E,20354320EB97,D8CF61663DEF,9C24722F13E5,2035435941B5,2035435A2F14,B01FF41CDBF4,D8CF6160B915,B01FF41A8F29,2035431F26C0,CC5830FDE0A2,DC92726FBE88,2035431F4DA9,D8CF61664A05,441524E4FEF3,CC5830FDA450,2035435389B9,20354319A607,DC9272736D7B,203543168743,203543158F10,CC5830007149,203543138AC9,203543220F2F,20354358B530,CC5830FDCFED,CC583000A1D9,203543200FD4,94988F2F49D2,CC5830FF66DB,CC5830FF64F1,64FA2B6461C0,441524E4FF78,20354316B94D,CC5830FEC61A', '',0302,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-01 16:34:39 Duration: 6s435ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (246998, 450, '923081019181,CC5830E1F8C8,5CFA257F5480,C03C048724C5,841EA38DF98D,841EA38DA85E,582FF79C54EA,5CFA2515CAAB,841EA38D7432,345D9EB43ECB,209A7DB7C636,94988F930977,8CC5B4E31C64,B0BBE5498750,209A7DB3F895,186A81D58390,E8D2FFAB4F66,5CFA25AD3A3D,5CFA2515EE7D,943C96AD79E9,5CFA25AD1220,E8D2FFA674FE,345D9EB41216,186A81D4C777,ACD75BB74693,E4C0E2980B03,ACD75BB5F18B,C03C048647FF,C03C047FAA20,44D454608363,C4EB42A002EF,5CFA2580273D,D833B7A4438C,44ADB131D95A,C4EB42A33284,64FD965E0B06,64FD965E9B74,5447CC78D532,D833B7A42FC7,94988F30F05D,506F0C3B0F46', '',0155,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-01 14:19:52 Duration: 5s536ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-01.log
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 3 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration May 31 09 1 0ms 0ms 14 1 0ms 0ms Jun 01 17 1 0ms 0ms [ User: intelifix - Total duration: 5s187ms - Times executed: 3 ]
[ Application: psql - Total duration: 4s735ms - Times executed: 2 ]
[ Application: [unknown] - Total duration: 452ms - Times executed: 1 ]
-
;
Date: Duration: 0ms Database: postgres User: rio Remote: intelifix Application: [local] Queryid: [unknown]
-
Events
Log levels
Key values
- 16,564 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 436 FATAL entries
- 3139 ERROR entries
- 0 WARNING entries
- 8 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 3,107 Max number of times the same event was reported
- 3,583 Total events found
Rank Times reported Error 1 3,107 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jun 01 00 60 01 59 02 60 03 59 04 60 05 60 06 59 07 134 08 295 09 367 10 277 11 288 12 129 13 159 14 368 15 413 16 230 17 30 - ERROR: prepared statement "_PLAN0000000029AFC280" does not exist
- ERROR: prepared statement "_PLAN000000001BEB4CC0" does not exist
- ERROR: prepared statement "_PLAN0000000029CA86E0" does not exist
Statement: DEALLOCATE "_PLAN0000000029AFC280"
Date: 2026-06-01 00:00:08 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-01.log
Statement: DEALLOCATE "_PLAN000000001BEB4CC0"
Date: 2026-06-01 00:01:09 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-01.log
Statement: DEALLOCATE "_PLAN0000000029CA86E0"
Date: 2026-06-01 00:02:09 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-01.log
2 420 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Jun 01 00 19 01 16 02 14 03 15 04 14 05 21 06 16 07 16 08 19 09 20 10 21 11 18 12 19 13 19 14 21 15 19 16 19 17 20 18 17 19 17 20 19 21 21 22 19 23 1 - FATAL: database "brasilia" does not exist
- FATAL: database "brasilia" does not exist
- FATAL: database "brasilia" does not exist
Date: 2026-06-01 00:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-01.log
Date: 2026-06-01 00:05:16 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-01.log
Date: 2026-06-01 00:05:32 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-01.log
3 12 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #3
Day Hour Count Jun 01 08 6 09 3 16 3 - ERROR: syntax error at or near "U" at character 30
- ERROR: syntax error at or near "U" at character 30
- ERROR: syntax error at or near "U" at character 30
Statement: SELECT * FROM RS_ETIQUETA(X U)
Date: 2026-06-01 08:50:22 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-01.log
Statement: SELECT * FROM RS_ETIQUETA(X U)
Date: 2026-06-01 08:50:24 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-01.log
Statement: SELECT * FROM RS_ETIQUETA(X U)
Date: 2026-06-01 08:50:24 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-01.log
4 7 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Jun 01 08 3 09 2 16 2 - ERROR: trailing junk after numeric literal at or near "00367661E9F2" at character 27
- ERROR: trailing junk after numeric literal at or near "00367661E9F2" at character 27
- ERROR: trailing junk after numeric literal at or near "00367661E9F2" at character 27
Statement: SELECT * FROM RS_ETIQUETA(00367661E9F2)
Date: 2026-06-01 08:39:12 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-01.log
Statement: SELECT * FROM RS_ETIQUETA(00367661E9F2)
Date: 2026-06-01 08:39:12 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-01.log
Statement: SELECT * FROM RS_ETIQUETA(00367661E9F2)
Date: 2026-06-01 08:39:12 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-01.log
5 7 FATAL: database "..." does not exist /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn(
Times Reported Most Frequent Error / Event #5
Day Hour Count Jun 01 18 3 19 2 20 2 - FATAL: database "brasilia" does not exist /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn(
- FATAL: database "brasilia" does not exist /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn(
- FATAL: database "brasilia" does not exist /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn(
Date: 2026-06-01 18:15:20 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-01.log
Date: 2026-06-01 18:35:31 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-01.log
Date: 2026-06-01 18:55:19 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-01.log
6 6 ERROR: function rs_etiqueta(...) does not exist
Times Reported Most Frequent Error / Event #6
Day Hour Count Jun 01 16 6 - ERROR: function rs_etiqueta(numeric) does not exist at character 15
- ERROR: function rs_etiqueta(numeric) does not exist at character 15
- ERROR: function rs_etiqueta(numeric) does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_ETIQUETA(73901285850064213129)Date: 2026-06-01 16:14:55 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-01.log
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_ETIQUETA(73901285850064213129)Date: 2026-06-01 16:14:55 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-01.log
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_ETIQUETA(73905885850066201050)Date: 2026-06-01 16:31:03 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-01.log
7 5 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #7
Day Hour Count Jun 01 09 2 15 1 16 2 - LOG: process 2932455 still waiting for ShareLock on transaction 343292 after 1000.105 ms
- LOG: process 2932455 still waiting for ShareLock on transaction 343292 after 4454.985 ms
- LOG: process 3239329 still waiting for ShareLock on transaction 373645 after 1000.097 ms
Detail: Process holding the lock: 2902644. Wait queue: 2932455.
Context: while updating tuple (68828,102) 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,integer) line 128 at assignment SQL statement "CALL RS_GIGA_TRIAGEM( cNome, nAux )" PL/pgSQL function rs_giga_processa_arquivos() line 63 at CALL
Statement: CALL RS_GIGA_PROCESSA_ARQUIVOS()Date: 2026-06-01 09:15:07 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-01.log
Detail: Process holding the lock: 2902644. Wait queue: 2932455.
Context: while updating tuple (68828,102) 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,integer) line 128 at assignment SQL statement "CALL RS_GIGA_TRIAGEM( cNome, nAux )" PL/pgSQL function rs_giga_processa_arquivos() line 63 at CALL
Statement: CALL RS_GIGA_PROCESSA_ARQUIVOS()Date: 2026-06-01 09:15:11 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-01.log
Detail: Process holding the lock: 3261653. Wait queue: 3239329.
Context: while updating tuple (1,33) in relation "usuarios" SQL statement "UPDATE USUARIOS SET EQ_CODIGO = NULL, USU_CHECK_IN = NULL WHERE USU_ID = nUser" PL/pgSQL function rs_tecnico_check_out(integer) line 28 at SQL statement SQL statement "SELECT RS_TECNICO_CHECK_OUT( nTecnico )" PL/pgSQL function rs_baixa(integer,integer,integer,integer,character varying,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1129 at PERFORM PL/pgSQL function rs_fluxo_encerra(integer,integer,boolean) line 169 at assignment PL/pgSQL function rs_cria_fluxo_fechado(integer,character varying,integer,boolean) line 94 at assignment PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1095 at assignment
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(39941,413,'496215281825,6412692A19D3','',045,00,'[{"item":"0","qrcode":""}]','','',00);Date: 2026-06-01 15:46:02 Database: contagem Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-01.log
8 5 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #8
Day Hour Count Jun 01 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-06-01 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-01.log
Date: 2026-06-01 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-01.log
Date: 2026-06-01 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-01.log
9 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #9
Day Hour Count Jun 01 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-06-01 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-01.log
Date: 2026-06-01 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-01.log
10 2 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #10
Day Hour Count Jun 01 00 2 - LOG: process 2439652 still waiting for AccessExclusiveLock on relation 362293 of database 358220 after 1000.090 ms
- LOG: process 2449179 still waiting for AccessExclusiveLock on relation 371943 of database 358222 after 1000.107 ms
Detail: Process holding the lock: 2437013. Wait queue: 2439652.
Context: SQL statement "DROP TABLE IF EXISTS auditor.AUDITOR_2026_02" PL/pgSQL function rs_auditor_novas_tabelas(date) line 75 at EXECUTE
Statement: SELECT * FROM RS_AUDITOR_NOVAS_TABELAS()Date: 2026-06-01 00:02:02 Database: rio Application: psql User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-01.log
Detail: Process holding the lock: 2449175. Wait queue: 2449179.
Context: SQL statement "DROP TABLE IF EXISTS auditor.AUDITOR_2026_02" PL/pgSQL function rs_auditor_novas_tabelas(date) line 75 at EXECUTE
Statement: SELECT * FROM RS_AUDITOR_NOVAS_TABELAS()Date: 2026-06-01 00:21:45 Database: contagem Application: psql User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-01.log
11 2 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #11
Day Hour Count Jun 01 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-06-01 05:30:17 Database: contagem Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-01.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-06-01 05:30:17 Database: contagem Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-01.log
12 2 ERROR: could not connect to server "..."
Times Reported Most Frequent Error / Event #12
Day Hour Count Jun 01 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-06-01 05:30:01 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-01.log
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-06-01 05:30:01 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-01.log
13 2 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #13
Day Hour Count Jun 01 14 2 - ERROR: column "v" does not exist at character 27
- ERROR: column "v" does not exist at character 27
Statement: select * from rs_caixa_qr(V)
Date: 2026-06-01 14:52:59 Database: contagem Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-01.log
Statement: select * from rs_caixa_qr(V)
Date: 2026-06-01 14:52:59 Database: contagem Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-01.log
14 1 FATAL: database "..." does not exist NOTICE: table "..." does not exist, skipping
Times Reported Most Frequent Error / Event #14
Day Hour Count Jun 01 11 1 - FATAL: database "brasilia" does not exist NOTICE: table "tmp_entrada" does not exist, skipping
Date: 2026-06-01 11:55:31 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-01.log
15 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #15
Day Hour Count Jun 01 03 1 - LOG: database system was shut down at 2026-06-01 03:05:01 -03
Date: 2026-06-01 03:05:02 Log file: /usr/local/pgsql/data/log/serverlog-01.log
16 1 ERROR: unterminated quoted string at or near "..."
Times Reported Most Frequent Error / Event #16
Day Hour Count Jun 01 06 1 - ERROR: unterminated quoted string at or near "''', 00, 06 );" at character 34
Statement: SELECT * FROM RS_BARRA_DETALHES( ''', 00, 06 );
Date: 2026-06-01 06:54:42 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-01.log
17 1 FATAL: database "..." does not exist /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn( /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn( /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn( /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn( /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn( /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn(
Times Reported Most Frequent Error / Event #17
Day Hour Count Jun 01 10 1 - FATAL: database "jaboatao" does not exist /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn( /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn( /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn( /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn( /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn( /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn(
Date: 2026-06-01 10:20:00 Database: jaboatao Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-01.log