pgBadger-
Global information
- Generated on Tue Oct 6 23:50:10 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 39,838 log entries in 9s
- Log start from 2026-10-06 00:00:41 to 2026-10-06 23:50:08
-
Overview
Global Stats
- 302 Number of unique normalized queries
- 4,141 Number of queries
- 5h39m31s Total query duration
- 2026-10-06 00:02:05 First query
- 2026-10-06 23:43:10 Last query
- 5 queries/s at 2026-10-06 20:08:47 Query peak
- 5h39m31s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 5h39m31s Execute total duration
- 5,151 Number of events
- 12 Number of unique normalized events
- 5,090 Max number of times the same event was reported
- 0 Number of cancellation
- 283 Total number of automatic vacuums
- 853 Total number of automatic analyzes
- 22 Number temporary file
- 249.08 MiB Max size of temporary file
- 71.06 MiB Average size of temporary file
- 391 Total number of sessions
- 9 sessions at 2026-10-06 00:46:46 Session peak
- 13d11h31m54s Total duration of sessions
- 49m38s Average duration of sessions
- 10 Average queries per session
- 52s101ms Average queries duration per session
- 48m46s Average idle time per session
- 397 Total number of connections
- 7 connections/s at 2026-10-06 03:05:16 Connection peak
- 4 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-10-06 20:08:47 Date
SELECT Traffic
Key values
- 4 queries/s Query Peak
- 2026-10-06 14:10:34 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-10-06 20:08:47 Date
Queries duration
Key values
- 5h39m31s 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) Oct 06 00 28 0ms 15s183ms 3s123ms 4s177ms 5s20ms 58s915ms 01 31 0ms 2s963ms 931ms 3s580ms 4s162ms 5s398ms 02 17 0ms 2s840ms 1s510ms 2s964ms 5s88ms 5s186ms 03 18 0ms 3s20ms 1s486ms 3s583ms 4s325ms 5s859ms 04 30 0ms 2s946ms 1s71ms 4s75ms 5s333ms 5s682ms 05 29 0ms 9m33s 44s677ms 6s611ms 2m42s 9m33s 06 24 0ms 11s276ms 2s621ms 3s294ms 4s845ms 28s838ms 07 124 0ms 6m34s 10s874ms 29s683ms 3m48s 6m34s 08 304 0ms 5m39s 3s248ms 27s26ms 56s398ms 5m45s 09 463 150ms 6m2s 4s894ms 44s888ms 5m58s 8m31s 10 445 151ms 5m45s 2s381ms 25s568ms 59s933ms 5m50s 11 377 0ms 5m52s 4s561ms 1m 4m1s 5m58s 12 132 0ms 5m38s 6s522ms 32s9ms 52s435ms 5m39s 13 247 0ms 5m30s 3s866ms 27s116ms 49s168ms 5m36s 14 429 150ms 5m36s 2s749ms 25s72ms 1m18s 5m52s 15 410 151ms 5m50s 2s408ms 13s689ms 59s320ms 6m13s 16 343 0ms 5m51s 2s841ms 15s830ms 57s239ms 5m53s 17 141 0ms 5m58s 5s872ms 11s236ms 22s425ms 6m57s 18 28 0ms 5m30s 23s48ms 3s456ms 45s439ms 5m30s 19 24 0ms 5m25s 25s198ms 3s253ms 15s103ms 5m55s 20 111 0ms 5m31s 10s635ms 1m5s 1m16s 6m28s 21 34 0ms 5m24s 18s214ms 5s359ms 15s469ms 5m55s 22 30 0ms 5m25s 20s538ms 4s854ms 14s967ms 5m55s 23 322 0ms 1m3s 6s144ms 1m4s 1m6s 1m8s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 06 00 4 0 1s255ms 0ms 0ms 0ms 01 13 0 247ms 0ms 201ms 665ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 12 0 283ms 0ms 183ms 874ms 05 6 0 308ms 0ms 0ms 670ms 06 8 0 776ms 0ms 0ms 1s365ms 07 62 0 18s657ms 1s580ms 22s426ms 6m20s 08 222 0 3s569ms 4s372ms 11s699ms 3m45s 09 362 0 4s826ms 9s29ms 24s242ms 5m59s 10 383 0 2s333ms 6s859ms 14s930ms 3m53s 11 312 0 4s764ms 20s474ms 52s635ms 5m54s 12 94 0 8s351ms 2s566ms 32s9ms 3m30s 13 196 0 4s520ms 6s431ms 27s116ms 3m40s 14 343 0 2s949ms 9s37ms 18s112ms 3m55s 15 323 0 2s727ms 7s226ms 8s975ms 3m56s 16 268 0 3s354ms 8s653ms 14s588ms 4m14s 17 107 0 7s262ms 2s921ms 6s875ms 3m59s 18 9 0 1m6s 0ms 296ms 3m37s 19 6 0 1m36s 0ms 0ms 3m30s 20 9 83 12s489ms 42s789ms 1m2s 3m32s 21 11 0 53s218ms 0ms 0ms 3m32s 22 6 0 1m37s 0ms 0ms 3m32s 23 2 320 6s144ms 1m2s 1m4s 1m7s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 06 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 Oct 06 00 0 0 0.00 0.00% 01 0 2 2.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 3 3.00 0.00% 05 0 2 2.00 0.00% 06 0 2 2.00 0.00% 07 0 6 6.00 0.00% 08 0 11 11.00 0.00% 09 0 12 12.00 0.00% 10 0 9 9.00 0.00% 11 0 10 10.00 0.00% 12 0 8 8.00 0.00% 13 0 7 7.00 0.00% 14 0 13 13.00 0.00% 15 0 10 10.00 0.00% 16 0 12 12.00 0.00% 17 0 5 5.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 1 1.00 0.00% 22 0 0 0.00 0.00% 23 0 1 1.00 0.00% Day Hour Count Average / Second Oct 06 00 20 0.01/s 01 11 0.00/s 02 8 0.00/s 03 20 0.01/s 04 9 0.00/s 05 12 0.00/s 06 18 0.01/s 07 13 0.00/s 08 19 0.01/s 09 25 0.01/s 10 20 0.01/s 11 25 0.01/s 12 19 0.01/s 13 20 0.01/s 14 36 0.01/s 15 23 0.01/s 16 23 0.01/s 17 14 0.00/s 18 11 0.00/s 19 9 0.00/s 20 11 0.00/s 21 12 0.00/s 22 8 0.00/s 23 11 0.00/s Day Hour Count Average Duration Average idle time Oct 06 00 8 1h 59m49s 01 18 1h1m30s 1h1m28s 02 11 1h16s 1h14s 03 19 17m5s 17m4s 04 9 1h3m40s 1h3m36s 05 10 55m36s 53m26s 06 11 59m44s 59m38s 07 17 55m1s 53m42s 08 13 53m4s 51m48s 09 22 45m6s 43m23s 10 22 56m43s 55m55s 11 21 50m38s 49m16s 12 25 52m9s 51m35s 13 17 54m9s 53m13s 14 33 31m39s 31m3s 15 26 44m12s 43m34s 16 20 55m6s 54m17s 17 21 54m40s 54m1s 18 14 56m39s 55m52s 19 10 55m30s 54m29s 20 11 44m29s 42m42s 21 8 1h1m3s 59m45s 22 12 56m5s 55m13s 23 13 34m51s 32m19s -
Connections
Established Connections
Key values
- 7 connections Connection Peak
- 2026-10-06 03:05:16 Date
Connections per database
Key values
- rio Main Database
- 397 connections Total
Connections per user
Key values
- intelifix Main User
- 397 connections Total
-
Sessions
Simultaneous sessions
Key values
- 9 sessions Session Peak
- 2026-10-06 00:46:46 Date
Histogram of session times
Key values
- 293 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 391 sessions Total
Sessions per user
Key values
- intelifix Main User
- 391 sessions Total
Sessions per host
Key values
- [local] Main Host
- 391 sessions Total
Sessions per application
Key values
- [unknown] Main Application
- 391 sessions Total
Application Count Total Duration Average Duration [unknown] 359 12d22h52m38s 51m57s pgAdmin 4 - CONN:3843907 2 4s222ms 2s111ms pgAdmin 4 - CONN:7140829 3 4s222ms 1s407ms pgAdmin 4 - CONN:8072475 1 8m13s 8m13s pgAdmin 4 - DB:brasilia 1 8s277ms 8s277ms pgAdmin 4 - DB:contagem 1 8m21s 8m21s pgAdmin 4 - DB:postgres 1 8m30s 8m30s pgAdmin 4 - DB:rio 1 10s119ms 10s119ms pg_dump 9 42m36s 4m44s postgres_fdw 1 54m1s 54m1s psql 12 10h37m4s 53m5s -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 31,108 buffers Checkpoint Peak
- 2026-10-06 00:11:16 Date
- 270.067 seconds Highest write time
- 0.031 seconds Sync time
Checkpoints Wal files
Key values
- 9 files Wal files usage Peak
- 2026-10-06 09:34:34 Date
Checkpoints distance
Key values
- 294.80 Mo Distance Peak
- 2026-10-06 09:34:34 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Oct 06 00 32,599 418.857s 0.01s 418.883s 01 2,843 285.649s 0.023s 285.698s 02 1,513 151.614s 0.014s 151.643s 03 1,548 155.248s 0.018s 155.292s 04 3,812 381.865s 0.039s 381.934s 05 9,948 995.939s 0.067s 996.035s 06 3,271 269.048s 0.002s 269.053s 07 19,662 1,703.428s 0.046s 1,703.522s 08 36,577 2,974.055s 0.094s 2,974.212s 09 69,979 3,239.596s 0.187s 3,239.864s 10 55,435 3,239.43s 0.148s 3,239.653s 11 71,373 3,239.415s 0.174s 3,239.683s 12 18,599 1,953.745s 0.049s 1,953.842s 13 34,616 2,579.706s 0.098s 2,579.86s 14 78,705 3,239.589s 0.137s 3,239.797s 15 57,798 3,239.488s 0.147s 3,239.707s 16 38,211 3,186.371s 0.139s 3,186.579s 17 17,376 1,694.508s 0.089s 1,694.655s 18 1,147 114.917s 0.009s 114.94s 19 23 2.313s 0.002s 2.317s 20 424 116.894s 0.003s 116.913s 21 3,409 341.682s 0.015s 341.723s 22 2,025 203.061s 0.015s 203.101s 23 261 26.191s 0.008s 26.208s Day Hour Added Removed Recycled Synced files Longest sync Average sync Oct 06 00 0 0 7 537 0.002s 0.006s 01 0 0 1 709 0.002s 0.01s 02 0 0 1 331 0.002s 0.007s 03 0 0 0 348 0.002s 0.007s 04 0 0 1 675 0.003s 0.01s 05 0 0 5 750 0.025s 0.01s 06 0 0 0 11 0.001s 0.001s 07 0 0 13 1,885 0.003s 0.012s 08 0 0 20 4,575 0.004s 0.012s 09 0 0 45 7,176 0.003s 0.012s 10 0 0 21 6,922 0.003s 0.012s 11 0 0 43 6,784 0.006s 0.012s 12 0 0 8 3,154 0.003s 0.012s 13 0 0 14 5,110 0.003s 0.012s 14 0 0 33 6,704 0.003s 0.012s 15 0 0 22 6,706 0.003s 0.012s 16 0 0 14 6,292 0.003s 0.012s 17 0 0 8 3,995 0.003s 0.012s 18 0 0 0 120 0.002s 0.005s 19 0 0 0 3 0.001s 0.001s 20 0 0 1 60 0.001s 0.002s 21 0 0 1 485 0.002s 0.008s 22 0 0 0 413 0.002s 0.008s 23 0 0 0 36 0.002s 0.005s Day Hour Count Avg time (sec) Oct 06 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 Oct 06 00 20,304.50 kB 89,838.67 kB 01 1,348.00 kB 40,581.20 kB 02 1,080.57 kB 16,852.86 kB 03 992.88 kB 2,936.12 kB 04 2,075.10 kB 2,828.40 kB 05 8,016.78 kB 13,788.11 kB 06 6,557.00 kB 11,991.00 kB 07 16,776.50 kB 29,722.17 kB 08 28,249.00 kB 64,706.67 kB 09 61,307.33 kB 107,367.92 kB 10 27,948.00 kB 71,772.58 kB 11 58,683.67 kB 97,847.83 kB 12 11,523.75 kB 70,740.17 kB 13 18,594.83 kB 41,148.67 kB 14 44,931.58 kB 61,134.33 kB 15 31,124.08 kB 68,629.08 kB 16 18,269.92 kB 36,552.75 kB 17 11,080.08 kB 27,821.08 kB 18 1,078.20 kB 14,455.80 kB 19 187.00 kB 10,496.00 kB 20 4,298.50 kB 9,609.00 kB 21 1,985.12 kB 6,716.88 kB 22 1,344.38 kB 3,706.12 kB 23 169.20 kB 2,268.20 kB -
Temporary Files
Size of temporary files
Key values
- 498.16 MiB Temp Files size Peak
- 2026-10-06 05:31:56 Date
Number of temporary files
Key values
- 4 per second Temp Files Peak
- 2026-10-06 05:32:02 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Oct 06 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 20 1.32 GiB 67.77 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 1 104.00 MiB 104.00 MiB 10 0 0 0 11 1 104.00 MiB 104.00 MiB 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 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 16 1.02 GiB 37.15 MiB 249.08 MiB 65.36 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-06 05:32:05 Duration: 1m23s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-06 05:31:56 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 4 309.52 MiB 57.53 MiB 94.69 MiB 77.38 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-06 05:30:41 Duration: 39s609ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-06 05:30:38 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
3 2 207.99 MiB 104.00 MiB 104.00 MiB 104.00 MiB select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030765, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-06 07:51:15 Duration: 6m20s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030770, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-06 09:11:21 Duration: 6m2s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030775, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-06 09:37:35 Duration: 5m55s Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries generating the largest temporary files
Rank Size Query 1 249.08 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-06 05:31:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 249.08 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-06 05:31:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-10-06 11:48:56 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-10-06 09:26:53 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 94.69 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-06 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 94.69 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-06 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 62.62 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-06 05:30:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 57.53 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-06 05:30:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 41.14 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-06 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 41.07 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-06 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 41.07 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-06 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 41.07 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-06 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 41.06 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-06 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 41.06 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-06 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 41.06 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-06 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 37.22 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-06 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 37.15 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-06 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 37.15 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-06 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 37.15 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-06 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 37.15 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-06 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 5.77 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_10
Database rio - 2026-10-06 08:03:39 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 5.77 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_10
Database rio - 2026-10-06 08:03:39 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (85) Main table analyzed (database rio)
- 853 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 85 rio.public.usuarios 45 brasilia.pg_catalog.pg_attribute 40 rio.pg_catalog.pg_class 40 rio.pg_catalog.pg_type 36 contagem.pg_catalog.pg_attribute 31 brasilia.public.temp0000241674 31 rio.public.temp0000293538 29 brasilia.public.temp0000241662 27 contagem.public.usuarios 26 rio.public.temp0000293472 25 brasilia.public.temp0000241698 24 rio.pg_catalog.pg_index 22 brasilia.public.temp0000241626 21 contagem.pg_catalog.pg_class 19 brasilia.pg_catalog.pg_class 19 brasilia.pg_catalog.pg_type 16 rio.pg_catalog.pg_depend 16 contagem.pg_catalog.pg_type 15 rio.public.temp0000293000 12 contagem.public.temp0000227454 11 rio.public.temp0000293510 11 rio.public.temp0000293490 10 brasilia.public.usuarios 10 rio.public.temp0000293458 10 contagem.pg_catalog.pg_index 10 rio.public.temp0000293546 10 brasilia.pg_catalog.pg_index 10 rio.public.temp0000293492 8 brasilia.pg_catalog.pg_depend 8 rio.public.temp0000293532 8 rio.public.temp0000292986 8 rio.public.temp0000293470 8 contagem.pg_catalog.pg_depend 7 brasilia.public.temp0000241672 6 rio.public.temp0000293484 6 rio.public.temp0000293524 6 brasilia.public.temp0000241624 6 rio.public.temp0000293462 5 rio.public.temp0000293480 5 rio.public.temp0000292760 5 rio.public.temp0000293474 5 rio.public.temp0000292754 4 rio.public.temp0000293542 4 rio.public.temp0000293478 4 rio.public.tmp_drill_0320 4 contagem.auditor.auditor_2026_10 4 rio.public.tmp_drill_0175 4 rio.public.temp0000293544 4 brasilia.auditor.auditor_2026_10 3 rio.public.temp0000293496 3 contagem.public.temp0000227448 3 contagem.public.temp0000227458 3 brasilia.public.temp0000241680 3 rio.public.temp0000293556 3 rio.public.temp0000293468 3 brasilia.public.nf_entrada 2 brasilia.public.temp0000241644 2 postgres.pg_catalog.pg_shdepend 2 rio.auditor.auditor_2026_10 2 brasilia.public.temp0000241668 2 rio.public.temp0000293482 2 rio.pg_catalog.pg_shdepend 2 brasilia.public.temp0000241678 2 rio.public.temp0000293506 2 rio.public.temp0000293494 2 contagem.public.temp0000227450 2 contagem.public.nf_entrada 2 brasilia.pg_catalog.pg_shdepend 2 brasilia.public.temp0000241646 2 brasilia.public.temp0000241700 2 brasilia.public.temp0000241692 2 rio.public.temp0000293522 1 rio.public.temp0000293464 1 rio.public.temp0000293460 1 rio.public.temp0000293564 1 brasilia.public.temp0000241664 1 rio.public.temp0000293530 1 template1.pg_catalog.pg_shdepend 1 rio.public.temp0000293456 1 brasilia.public.temp0000241648 1 rio.public.temp0000293552 1 brasilia.public.temp0000241642 1 brasilia.public.temp0000241650 1 rio.public.temp0000293518 1 contagem.public.temp0000227456 1 brasilia.public.temp0000241654 1 brasilia.public.temp0000241652 1 brasilia.public.temp0000241682 1 rio.public.temp0000293466 1 rio.public.temp0000293540 1 brasilia.public.temp0000241702 1 Total 853 Vacuums per table
Key values
- pg_catalog.pg_attribute (27) Main table vacuumed on database rio
- 283 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 27 27 0 0 0 0 0 16,207 4,340 6,329,156 219 5,495 contagem.public.usuarios 25 0 0 0 0 0 0 120 94 51,413 0 0 rio.public.temp0000293472 15 0 0 0 0 0 0 25,862 5,589 8,694,937 0 0 rio.pg_catalog.pg_class 14 14 0 0 0 0 0 2,982 911 1,328,384 50 223 brasilia.pg_catalog.pg_attribute 13 13 0 0 0 0 0 7,066 1,692 2,926,033 47 1,239 rio.pg_catalog.pg_type 12 12 0 0 0 0 0 1,301 354 549,791 50 150 contagem.pg_catalog.pg_attribute 11 11 0 0 0 0 0 7,053 1,859 3,404,574 15 372 rio.public.temp0000293000 11 0 0 0 0 0 0 1,094 114 154,667 0 0 rio.pg_catalog.pg_index 9 9 0 0 0 0 0 465 150 178,732 27 83 rio.public.temp0000293532 8 0 0 0 0 0 0 1,049 44 68,943 0 0 rio.public.temp0000293492 8 0 0 0 0 0 0 11,090 30 659,004 0 0 rio.public.temp0000292986 7 0 0 0 0 0 0 794 42 54,949 0 0 brasilia.pg_catalog.pg_type 7 7 0 0 0 0 0 674 167 272,886 11 42 brasilia.pg_catalog.pg_class 7 7 0 0 0 0 0 1,376 331 577,922 15 45 rio.pg_catalog.pg_depend 6 6 0 0 0 0 0 2,212 832 1,261,338 39 368 brasilia.pg_catalog.pg_statistic 6 6 0 0 0 0 0 6,179 1,842 7,013,007 1,308 7,365 contagem.pg_catalog.pg_type 6 6 0 0 0 0 0 555 129 185,124 5 12 contagem.pg_catalog.pg_class 6 6 0 0 0 0 0 1,117 258 410,191 4 14 rio.pg_catalog.pg_statistic 6 6 0 0 0 0 0 7,537 2,499 9,652,906 1,824 8,741 rio.public.tmp_drill_0320 6 4 0 0 0 0 0 1,632 49 322,445 0 0 rio.public.usuarios 5 1 0 0 0 0 0 53 23 37,602 9 19 brasilia.pg_catalog.pg_index 5 5 0 0 0 0 0 250 54 55,272 6 11 postgres.pg_catalog.pg_shdepend 5 5 0 0 0 0 0 1,336 493 1,078,189 55 133 rio.public.temp0000292760 5 0 0 0 0 0 0 416 108 156,921 0 0 contagem.pg_catalog.pg_depend 4 4 0 0 0 0 0 1,082 266 541,175 6 32 rio.public.tmp_drill_0175 4 4 0 0 0 0 0 396 12 79,397 0 0 rio.public.temp0000293538 4 0 0 0 0 0 0 478 22 31,633 0 0 brasilia.pg_catalog.pg_depend 4 4 0 0 0 0 0 1,396 466 831,807 16 278 contagem.pg_catalog.pg_index 4 4 0 0 0 0 0 213 65 72,633 5 5 rio.public.temp0000292754 4 0 0 0 0 0 0 361 22 24,625 0 0 contagem.public.temp0000227458 3 0 0 0 0 0 0 354 18 23,814 0 0 rio.pg_toast.pg_toast_2619 3 3 0 0 0 0 0 1,743 507 2,486,048 193 549 brasilia.public.temp0000241680 2 0 0 0 0 0 0 516 8 31,650 0 0 rio.auditor.auditor_2026_10 2 0 0 0 0 0 0 72,088 38,947 49,862,250 16,391 328,529 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 353 82 373,509 34 83 contagem.auditor.auditor_2026_10 2 0 0 0 0 0 0 18,971 9,811 12,371,401 4,434 82,654 brasilia.auditor.auditor_2026_10 2 0 0 0 0 0 0 19,287 11,578 15,358,604 3,362 67,810 rio.public.temp0000293506 2 0 0 0 0 0 0 3,694 8 219,152 0 0 brasilia.public.temp0000241702 1 0 0 0 0 0 0 258 4 15,825 0 0 rio.public.temp0000293556 1 0 0 0 0 0 0 1,848 4 109,635 0 0 contagem.public.temp0000227454 1 0 0 0 0 0 0 118 6 7,936 0 0 brasilia.public.temp0000241646 1 0 0 0 0 0 0 258 4 15,825 0 0 brasilia.public.temp0000241664 1 0 0 0 0 0 0 258 4 15,825 0 0 rio.public.temp0000293530 1 0 0 0 0 0 0 1,848 4 109,635 0 0 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,218 2 152,379 0 0 contagem.public.temp0000227456 1 0 0 0 0 0 0 118 6 7,940 0 0 rio.public.temp0000293564 1 0 0 0 0 0 0 1,848 4 109,635 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 125 3 15,832 0 0 rio.public.temp0000293464 1 0 0 0 0 0 0 38 6 3,041 0 0 Total 283 168 0 0 0 0 0 228,287 83,863 128,295,592 28,125 504,252 Vacuum throughput per table
Key values
- auditor.auditor_2026_10 (10.67) 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 2.05 contagem.public.usuarios 0 0 0 rio.public.temp0000293472 0 0 0.69 rio.pg_catalog.pg_class 0 0 0.54 brasilia.pg_catalog.pg_attribute 0 0 0.85 rio.pg_catalog.pg_type 0 0 0.13 contagem.pg_catalog.pg_attribute 0 0 1.33 rio.public.temp0000293000 0 0 0.03 rio.pg_catalog.pg_index 0 0 0.22 rio.public.temp0000293532 0 0 0.04 rio.public.temp0000293492 0 0 0.33 rio.public.temp0000292986 0 0 0.05 brasilia.pg_catalog.pg_type 0 0 0.25 brasilia.pg_catalog.pg_class 0 0 0.4 rio.pg_catalog.pg_depend 0 0 0.45 brasilia.pg_catalog.pg_statistic 0 0 0.77 contagem.pg_catalog.pg_type 0 0 0.47 contagem.pg_catalog.pg_class 0 0 0.69 rio.pg_catalog.pg_statistic 0 0 1.1 rio.public.tmp_drill_0320 0 0 0.04 rio.public.usuarios 0 0 0.07 brasilia.pg_catalog.pg_index 0 0 0.11 postgres.pg_catalog.pg_shdepend 0 0 0.56 rio.public.temp0000292760 0 0 0.01 contagem.pg_catalog.pg_depend 0 0 0.46 rio.public.tmp_drill_0175 0 0 0 rio.public.temp0000293538 0 0 0.02 brasilia.pg_catalog.pg_depend 0 0 0.45 contagem.pg_catalog.pg_index 0 0 0.26 rio.public.temp0000292754 0 0 0.01 contagem.public.temp0000227458 0 0 0 rio.pg_toast.pg_toast_2619 0 0 0.24 brasilia.public.temp0000241680 0 0 0 rio.auditor.auditor_2026_10 0 0 10.67 brasilia.pg_toast.pg_toast_2619 0 0 0.04 contagem.auditor.auditor_2026_10 0 0 2.77 brasilia.auditor.auditor_2026_10 0 0 3.68 rio.public.temp0000293506 0 0 0.09 brasilia.public.temp0000241702 0 0 0 rio.public.temp0000293556 0 0 0.04 contagem.public.temp0000227454 0 0 0 brasilia.public.temp0000241646 0 0 0 brasilia.public.temp0000241664 0 0 0 rio.public.temp0000293530 0 0 0.05 contagem.pg_catalog.pg_statistic 0 0 0.04 contagem.public.temp0000227456 0 0 0.01 rio.public.temp0000293564 0 0 0.05 contagem.pg_toast.pg_toast_2619 0 0 0 rio.public.temp0000293464 0 0 0 Total 0 0 30.06 Tuples removed per table
Key values
- pg_catalog.pg_attribute (107101) Main table with removed tuples on database rio
- 298938 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 27 27 107,101 636,131 68 184 15,989 brasilia.pg_catalog.pg_attribute 13 13 54,859 308,042 8,886 2 8,111 contagem.pg_catalog.pg_attribute 11 11 46,428 281,437 0 253 6,278 rio.public.tmp_drill_0320 6 4 23,786 27,840 1,680 0 662 rio.pg_catalog.pg_statistic 6 6 10,491 49,364 0 0 7,716 brasilia.pg_catalog.pg_statistic 6 6 9,069 51,707 0 0 6,426 brasilia.pg_catalog.pg_depend 4 4 5,490 74,019 2,878 0 736 rio.pg_catalog.pg_depend 6 6 4,600 113,960 24 0 1,128 postgres.pg_catalog.pg_shdepend 5 5 4,208 90,602 440 0 750 contagem.pg_catalog.pg_statistic 1 1 4,205 7,274 0 0 1,011 rio.pg_catalog.pg_type 12 12 4,203 27,280 4 5 856 brasilia.pg_catalog.pg_class 7 7 2,904 26,902 2,212 0 955 brasilia.pg_catalog.pg_type 7 7 2,465 16,415 898 6 495 brasilia.auditor.auditor_2026_10 2 0 2,388 1,799,992 0 0 78,185 contagem.pg_catalog.pg_type 6 6 2,203 13,510 0 31 397 rio.pg_catalog.pg_class 14 14 2,075 48,491 67 42 1,606 rio.public.tmp_drill_0175 4 4 1,787 5,598 0 0 148 rio.pg_catalog.pg_index 9 9 1,710 17,255 9 4 465 rio.auditor.auditor_2026_10 2 0 1,681 5,910,837 0 0 286,080 contagem.public.usuarios 25 0 1,611 600 0 0 50 contagem.pg_catalog.pg_depend 4 4 1,316 75,527 0 0 704 brasilia.pg_catalog.pg_index 5 5 1,150 9,856 443 3 267 rio.pg_toast.pg_toast_2619 3 3 977 2,015 0 0 798 contagem.pg_catalog.pg_index 4 4 949 7,591 0 5 205 contagem.pg_catalog.pg_class 6 6 694 20,392 20 30 747 rio.public.usuarios 5 1 274 3,156 611 0 95 brasilia.pg_toast.pg_toast_2619 2 2 213 283 0 0 138 contagem.pg_toast.pg_toast_2619 1 1 101 113 0 0 53 brasilia.public.temp0000241702 1 0 0 3,387 0 0 256 rio.public.temp0000292986 7 0 0 39,012 0 283 869 rio.public.temp0000293532 8 0 0 44,608 0 277 1,003 rio.public.temp0000293556 1 0 0 26,215 0 0 1,856 brasilia.public.temp0000241680 2 0 0 6,773 0 0 512 rio.public.temp0000293472 15 0 0 393,064 0 0 27,840 contagem.public.temp0000227454 1 0 0 1,409 0 18 110 contagem.auditor.auditor_2026_10 2 0 0 1,309,769 0 0 58,877 brasilia.public.temp0000241646 1 0 0 3,384 0 0 256 brasilia.public.temp0000241664 1 0 0 3,384 0 0 256 rio.public.temp0000293530 1 0 0 26,214 0 0 1,856 rio.public.temp0000293538 4 0 0 20,156 0 57 455 rio.public.temp0000293000 11 0 0 45,303 0 461 1,011 rio.public.temp0000293492 8 0 0 209,658 0 0 14,848 contagem.public.temp0000227456 1 0 0 1,407 0 18 110 rio.public.temp0000293564 1 0 0 26,215 0 0 1,856 rio.public.temp0000292760 5 0 0 19,580 0 140 436 rio.public.temp0000292754 4 0 0 14,967 0 114 334 contagem.public.temp0000227458 3 0 0 4,224 0 54 330 rio.public.temp0000293464 1 0 0 1,340 0 2 30 rio.public.temp0000293506 2 0 0 52,409 0 0 3,712 Total 283 168 298,938 11,878,667 18,240 1,989 537,864 Pages removed per table
Key values
- public.temp0000293000 (461) Main table with removed pages on database rio
- 1989 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000293000 11 0 0 461 rio.public.temp0000292986 7 0 0 283 rio.public.temp0000293532 8 0 0 277 contagem.pg_catalog.pg_attribute 11 11 46428 253 rio.pg_catalog.pg_attribute 27 27 107101 184 rio.public.temp0000292760 5 0 0 140 rio.public.temp0000292754 4 0 0 114 rio.public.temp0000293538 4 0 0 57 contagem.public.temp0000227458 3 0 0 54 rio.pg_catalog.pg_class 14 14 2075 42 contagem.pg_catalog.pg_type 6 6 2203 31 contagem.pg_catalog.pg_class 6 6 694 30 contagem.public.temp0000227454 1 0 0 18 contagem.public.temp0000227456 1 0 0 18 brasilia.pg_catalog.pg_type 7 7 2465 6 rio.pg_catalog.pg_type 12 12 4203 5 contagem.pg_catalog.pg_index 4 4 949 5 rio.pg_catalog.pg_index 9 9 1710 4 brasilia.pg_catalog.pg_index 5 5 1150 3 brasilia.pg_catalog.pg_attribute 13 13 54859 2 rio.public.temp0000293464 1 0 0 2 brasilia.public.temp0000241702 1 0 0 0 rio.pg_catalog.pg_depend 6 6 4600 0 rio.public.usuarios 5 1 274 0 contagem.pg_catalog.pg_depend 4 4 1316 0 rio.public.temp0000293556 1 0 0 0 brasilia.public.temp0000241680 2 0 0 0 rio.public.temp0000293472 15 0 0 0 rio.public.tmp_drill_0175 4 4 1787 0 rio.auditor.auditor_2026_10 2 0 1681 0 brasilia.pg_toast.pg_toast_2619 2 2 213 0 contagem.auditor.auditor_2026_10 2 0 0 0 brasilia.public.temp0000241646 1 0 0 0 brasilia.public.temp0000241664 1 0 0 0 rio.public.temp0000293530 1 0 0 0 brasilia.pg_catalog.pg_statistic 6 6 9069 0 postgres.pg_catalog.pg_shdepend 5 5 4208 0 brasilia.auditor.auditor_2026_10 2 0 2388 0 contagem.pg_catalog.pg_statistic 1 1 4205 0 brasilia.pg_catalog.pg_depend 4 4 5490 0 rio.public.temp0000293492 8 0 0 0 brasilia.pg_catalog.pg_class 7 7 2904 0 rio.public.temp0000293564 1 0 0 0 contagem.pg_toast.pg_toast_2619 1 1 101 0 rio.pg_catalog.pg_statistic 6 6 10491 0 rio.public.tmp_drill_0320 6 4 23786 0 rio.public.temp0000293506 2 0 0 0 contagem.public.usuarios 25 0 1611 0 rio.pg_toast.pg_toast_2619 3 3 977 0 Total 283 168 298,938 1,989 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Oct 06 00 0 1 01 1 8 02 0 0 03 0 0 04 0 1 05 7 3 06 0 1 07 6 18 08 19 58 09 39 102 10 28 85 11 38 86 12 9 28 13 27 75 14 39 124 15 21 98 16 29 106 17 16 55 18 0 1 19 0 0 20 0 0 21 4 3 22 0 0 23 0 0 - 5.77 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 1 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 1 2m27s 2m27s 2m27s 2m27s call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-06 09:37:36 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-06 20:05:08 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-06 20:15:07 Database: rio User: intelifix Remote: [local] Application: psql
Queries that waited the most
Rank Wait time Query 1 2m27s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-10-06 09:37:35 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Queries
Queries by type
Key values
- 2,758 Total read queries
- 842 Total write queries
Queries by database
Key values
- rio Main database
- 2,190 Requests
- 3h46m18s (rio)
- Main time consuming database
Database Request type Count Duration brasilia Total 1,339 1h35m33s copy to 140 11m3s ddl 124 1m56s others 249 10m6s select 826 1h12m27s contagem Total 609 17m39s copy to 115 1m25s ddl 34 31s262ms others 6 2m59s select 454 12m43s rio Total 2,190 3h46m18s copy to 148 29m46s ddl 281 15m34s others 286 28m14s select 1,475 2h32m42s testes Total 3 726ms select 3 726ms Queries by user
Key values
- intelifix Main user
- 4,018 Requests
User Request type Count Duration etiquetas Total 10 2s126ms select 10 2s126ms intelifix Total 4,018 5h38m41s copy to 403 42m15s ddl 439 18m2s others 541 41m20s select 2,635 3h57m2s lenon Total 113 48s32ms select 113 48s32ms Duration by user
Key values
- 5h38m41s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 10 2s126ms select 10 2s126ms intelifix Total 4,018 5h38m41s copy to 403 42m15s ddl 439 18m2s others 541 41m20s select 2,635 3h57m2s lenon Total 113 48s32ms select 113 48s32ms Queries by host
Key values
- [local] Main host
- 4,140 Requests
- 5h39m27s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 3,040 Requests
- 3h30m16s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-10-06 08:33:01 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 1,929 100-500ms duration
Slowest individual queries
Rank Duration Query 1 9m33s analyze verbose;[ Date: 2026-10-06 05:09:35 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 6m43s analyze verbose;[ Date: 2026-10-06 05:16:18 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
3 6m34s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-06 07:11:36 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 6m20s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030765, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-06 07:51:15 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 6m2s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030770, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-06 09:11:21 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
6 5m58s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-06 17:11:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 5m55s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030775, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-06 09:37:35 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
8 5m54s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-06 09:10:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 5m52s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030782, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-06 11:22:42 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 5m51s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-06 11:10:53 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 5m51s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-06 16:10:52 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m50s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-06 15:10:51 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 5m45s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-06 10:10:47 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m39s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-06 08:10:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m38s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-06 12:10:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m36s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-06 14:10:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m31s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-06 20:10:33 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 5m30s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-06 13:10:32 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 5m30s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-06 18:10:32 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 5m25s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-06 22:10:26 - 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 1h37m15s 48 2s156ms 6m34s 2m1s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 06 07 3 7m9s 2m23s 08 3 6m1s 2m 09 3 6m20s 2m6s 10 3 6m8s 2m2s 11 3 6m17s 2m5s 12 3 5m59s 1m59s 13 3 5m50s 1m56s 14 3 5m56s 1m58s 15 3 6m11s 2m3s 16 3 6m13s 2m4s 17 3 6m19s 2m6s 18 3 5m48s 1m56s 19 3 5m42s 1m54s 20 3 5m49s 1m56s 21 3 5m42s 1m54s 22 3 5m43s 1m54s [ User: intelifix - Total duration: 1h37m15s - Times executed: 48 ]
[ Application: psql - Total duration: 1h37m15s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-06 07:11:36 Duration: 6m34s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-06 17:11:00 Duration: 5m58s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-06 09:10:56 Duration: 5m54s Database: rio User: intelifix Remote: [local] Application: psql
2 1h7m42s 48 232ms 3m52s 1m24s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 06 07 3 4m52s 1m37s 08 3 4m7s 1m22s 09 3 4m36s 1m32s 10 3 4m15s 1m25s 11 3 4m14s 1m24s 12 3 3m59s 1m19s 13 3 4m4s 1m21s 14 3 4m12s 1m24s 15 3 4m19s 1m26s 16 3 4m26s 1m28s 17 3 4m27s 1m29s 18 3 4m5s 1m21s 19 3 3m57s 1m19s 20 3 4m1s 1m20s 21 3 4m1s 1m20s 22 3 3m59s 1m19s [ User: intelifix - Total duration: 1h7m42s - Times executed: 48 ]
[ Application: psql - Total duration: 1h7m42s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-06 17:15:45 Duration: 3m52s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-06 16:15:38 Duration: 3m52s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-06 07:16:56 Duration: 3m48s Database: brasilia User: intelifix Remote: [local] Application: psql
3 37m15s 162 151ms 6m20s 13s799ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 06 07 10 6m25s 38s530ms 08 12 47s56ms 3s921ms 09 21 14m13s 40s640ms 10 14 36s60ms 2s575ms 11 26 8m52s 20s477ms 12 6 2m19s 23s288ms 13 15 1m31s 6s85ms 14 24 1m 2s508ms 15 17 21s98ms 1s241ms 16 10 19s959ms 1s995ms 17 6 47s146ms 7s857ms 18 1 1s855ms 1s855ms [ User: intelifix - Total duration: 37m15s - Times executed: 162 ]
[ Application: [unknown] - Total duration: 37m15s - Times executed: 162 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030765, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-06 07:51:15 Duration: 6m20s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030770, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-06 09:11:21 Duration: 6m2s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030775, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-06 09:37:35 Duration: 5m55s Database: rio User: intelifix Remote: [local] Application: [unknown]
4 18m59s 3 2m42s 9m33s 6m19s analyze verbose;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 06 05 3 18m59s 6m19s [ User: intelifix - Total duration: 18m59s - Times executed: 3 ]
[ Application: psql - Total duration: 18m59s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-10-06 05:09:35 Duration: 9m33s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-06 05:16:18 Duration: 6m43s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-06 05:19:00 Duration: 2m42s Database: contagem User: intelifix Remote: [local] Application: psql
5 14m11s 1,055 150ms 4s141ms 807ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 06 07 12 9s564ms 797ms 08 67 46s491ms 693ms 09 165 2m10s 791ms 10 166 2m12s 795ms 11 106 1m5s 616ms 12 34 18s557ms 545ms 13 73 1m8s 932ms 14 165 2m50s 1s32ms 15 139 1m56s 835ms 16 96 1m14s 774ms 17 32 20s507ms 640ms [ User: intelifix - Total duration: 14m11s - Times executed: 1055 ]
[ Application: [unknown] - Total duration: 14m11s - Times executed: 1055 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (60208, 407, '270911028446100246,216937812747,229925404156,229805812945,229836930909,229685906371,229673286071,229671978604,229816811325,229733847593,229736390828,229808939399,229672444665,229745672631,229850159001,229850166577,229879517073,229662468292,229812433748,229903248592,229865270005,216939921617,216943353658,229865456363,229808677174,229690188911,229748522943,229808844262,229741448706,229860334360,229673690107,229736727178,229811607999,216939740511,229808331631,229691627378,229837155173,229690982939,229742535568,229786790303,216944995355,216943909402,216944352835,229780002233', '246440069709,246089091730,246596241730,246640076770,246519296565,246617917896,246494759603,246630377799,246546757281,246544071128,246618665152,246601504353,246545969921,246642191018,246642190311,246652872442,246542612029,246536781516,246527323859,246648238397,246465040104,246482687998,246652586274,246619372427,246524858791,246551793037,246612965662,246569329103,246648604449,246548082832,246539877586,246612585973,246464380107,246612575770,246507129800,246641428484,246513879505,246548731010,246598582441,246498166063,246484087293,246468171128,246570789818,,,,,,,', 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":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-10-06 10:45:15 Duration: 4s141ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (60280, 406, 'ZTE3ANNR7B32751,3891484BEC41,3891484BEC42,ZTEGDB08114F$ZTE3ANNR1Y02123,14CA56CCDC3D,14CA56CCDC3E,ZTEGD9707EA6$ZTE3ANNRC506238,6C11BA62BC0B,6C11BA62BC0C,ZTEGDC6E2E1D$ZTE3ANNT2V71619,D83139921D6A,D83139921D6B,ZTEGDD310A42$ZTE3ANNQ7102023,C4EBFF89F7D2,C4EBFF89F7D3,ZTEGD70A24B9$ZTE3ANNRCP46872,6C11BA6D755F,6C11BA6D7560,ZTEGDC6FF7AB$ZTE3ANNT3H17838,D831399865AC,D831399865AD,ZTEGDD32164D$ZTE3ANNQ4A00430,3CF9F0AA025A,3CF9F0AA025B,ZTEGD641406D$ZTE3ANNT4P40145,F00C514F5384,F00C514F5385,ZTEGDE349367$ZTE3ANNT2V49430,D8313990155C,D8313990155D,ZTEGDD30B395$ZTE3ANNR3Y01366,4896D94FE0BC,4896D94FE0BD,ZTEGD97E360B$ZTE3ANNT4P16984,F00C514D34AE,F00C514D34AF,ZTEGDE3438EE$ZTE3ANNQ9J07834,843C992C88D1,843C992C88D2,ZTEGD7BB2745$ZTE3ANNR3J04261,F4E84F86B23E,F4E84F86B23F,ZTEGD97B726F$ZTE3ANNRC530771,6C11BA64FB09,6C11BA64FB0A,ZTEGDC6E8DF2$ZTE3ANNQ9J15474,843C992D3BE1,843C992D3BE2,ZTEGD7BB451D$ZTE3ANNQ9J21845,843C992DD133,843C992DD134,ZTEGD7BB5E00$ZTE3ANNQ8111646,689E29BCEFBF,689E29BCEFC0,ZTEGD7B7680E$ZTE3ANNR3Y27611,4896D95247DA,4896D95247DB,ZTEGD97E9C90$ZTE3ANNQCA03387,14CA56D2943D,14CA56D2943E,ZTEGD97172A6$ZTE3ANNQ4A00609,3CF9F0AA068C,3CF9F0AA068D,ZTEGD6414120$ZTE3ANNQ9J41947,843C992FA857,843C992FA858,ZTEGD7BBAC86$ZTE3ANNR7B15326,3891484A53DB,3891484A53DC,ZTEGDB07CD3E$ZTE3ANNQ6307291,3CF9F0704F0D,3CF9F0704F0E,ZTEGD52E5312$ZTE3ANNR8C28203,389148511C09,389148511C0A,ZTEGDB08EE9B$ZTE3ANNQ9J21773,843C992DCF83,843C992DCF84,ZTEGD7BB5DB8$ZTE3ANNR8C09206,3891484F5ECB,3891484F5ECC,ZTEGDB08A466$ZTE3ANNRB708766,5872C98F06A5,5872C98F06A6,ZTEGDC614D11$ZTE3ANNRAM61832,5872C98CE169,5872C98CE16A,ZTEGDC60F187$ZTE3ANNRCB03463,D831391E2028,D831391E2029,ZTEGDD29C31C$ZTE3ANNQ8M18373,843C99207689,843C9920768A,ZTEGD7BA8F32$ZTE3ANNRB705526,5872C98EBAB5,5872C98EBAB6,ZTEGDC614069$ZTE3ANNQ5N16789,3CF9F0AE4EF4,3CF9F0AE4EF5,ZTEGD641F7DC$ZTE3ANNQCA03578,14CA56D298B7,14CA56D298B8,ZTEGD9717365$ZTE3ANNR7B32278,3891484BE12B,3891484BE12C,ZTEGDB080F76$ZTE3ANNR8C09222,3891484F5F2B,3891484F5F2C,ZTEGDB08A476', '',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-06 10:06:52 Duration: 3s830ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (60249, 407, 'ZTE3A8TT3305984,142004533082$ZTE3A8TRB719022,7C7D21EC2BCB$ZTE3A8TRB719411,7C7D21EC31DF$ZTE3A8TT4X13312,14200459DCC2$ZTE3A8TR7917153,E44E12B1F115$ZTE3A8TT4X16649,1420045A10E6$ZTE3A8TT4723625,14200458EF76$ZTE3A8TT4723911,14200458F3EE$ZTE3A8TT7P18853,C492D94673EB$ZTE3A8TR6D11573,E44E12B00B75$ZTE3A8TT3304016,1420045311C2$ZTE3A8TR8U05620,B47CA6080872$ZTE3A8TT3307633,142004534A46$ZTE3A8TT4X15907,1420045A054E$ZTE3A8TR7919121,E44E12B20FD5$ZTE3A8TR7922191,E44E12B23FCD$ZTE3A8TQCH14011,DC5193D965F2$ZTE3A8TT7P06102,C492D945ACAF$ZTE3A8TT4723652,14200458EFE2$ZTE3A8TT7P16656,C492D9465197$ZTE3A8TT4723413,14200458EC26$ZTE3A8TT4724992,1420045904D2$ZTE3A8TT3C14130,142004553E3A$ZTE3A8TT4X12878,14200459D5FA$ZTE3A8TT4723682,14200458F05A$ZTE3A8TT7P18571,C492D9466F83$ZTE3A8TT3305892,142004532F12$ZTE3A8TR7R11261,E44E12B32375$ZTE3A8TT3305911,142004532F5E$ZTE3A8TT4724457,14200458FC76$ZTE3A8TT3C20382,142004559FEA$ZTE3A8TT7P18558,C492D9466F4F$ZTE3A8TR7919271,E44E12B2122D$ZTE3A8TT7P18406,C492D9466CEF$ZTE3A8TR4H13850,38165A47FC58$ZTE3A8TT7P16650,C492D946517F$ZTE3A8TT3303860,142004530F52$ZTE3A8TT4X15780,1420045A0352$ZTE3A8TT7P18607,C492D9467013$ZTE3A8TT4X17756,1420045A2232$ZTE3A8TR4X19896,38165A49E940$ZTE3A8TR4H13931,38165A47FD9C$ZTE3A8TT4X13299,14200459DC8E', '',05,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-06 10:37:56 Duration: 3s685ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
6 10m19s 276 189ms 2m31s 2s243ms call rs_giga_triagem (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 06 00 12 23s398ms 1s949ms 01 12 18s678ms 1s556ms 02 12 18s17ms 1s501ms 03 12 18s844ms 1s570ms 04 12 18s341ms 1s528ms 05 12 18s713ms 1s559ms 06 12 19s796ms 1s649ms 07 12 19s427ms 1s618ms 08 12 20s552ms 1s712ms 09 12 2m49s 14s159ms 10 12 20s680ms 1s723ms 11 12 22s65ms 1s838ms 12 12 19s985ms 1s665ms 13 12 19s902ms 1s658ms 14 12 22s184ms 1s848ms 15 12 20s351ms 1s695ms 16 12 21s140ms 1s761ms 17 12 22s384ms 1s865ms 18 12 20s169ms 1s680ms 19 12 19s532ms 1s627ms 20 12 26s301ms 2s191ms 21 12 19s598ms 1s633ms 22 12 19s198ms 1s599ms [ User: intelifix - Total duration: 10m19s - Times executed: 276 ]
[ Application: psql - Total duration: 10m19s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-06 09:37:36 Duration: 2m31s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-06 20:05:08 Duration: 6s380ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-06 20:15:07 Duration: 5s865ms Database: rio User: intelifix Remote: [local] Application: psql
7 6m51s 35 10s816ms 12s933ms 11s764ms create table temp0000293472 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 06 07 5 55s337ms 11s67ms 08 6 1m10s 11s780ms 09 12 2m24s 12s5ms 10 6 1m9s 11s628ms 11 6 1m11s 11s980ms [ User: intelifix - Total duration: 6m51s - Times executed: 35 ]
[ Application: [unknown] - Total duration: 6m51s - Times executed: 35 ]
-
CREATE TABLE temp0000293472 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-06 11:16:12 Duration: 12s933ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293472 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-06 09:30:57 Duration: 12s921ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293472 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-06 08:32:53 Duration: 12s333ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 5m53s 671 151ms 8s716ms 526ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 06 07 1 1s24ms 1s24ms 08 79 58s981ms 746ms 09 77 44s399ms 576ms 10 94 44s917ms 477ms 11 109 54s406ms 499ms 12 23 11s585ms 503ms 13 57 31s597ms 554ms 14 59 30s552ms 517ms 15 67 30s684ms 457ms 16 82 35s853ms 437ms 17 23 9s353ms 406ms [ User: intelifix - Total duration: 5m53s - Times executed: 671 ]
[ Application: [unknown] - Total duration: 5m53s - Times executed: 671 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "293721", "modelo" : "185", "itens" : "B85E71C46E18,B85E71D06C18,,C4509CAE7A94,B85E710EEB64,C4509CBCBD34,B85E71E6D6D8,08A7C06A0C04,B85E71B7B0FC,3C82C08AE46C,B85E71E599F8,B85E71E728A4,B85E71D30428,D4E2CB1FABEC,B85E71D1D7EC", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-06 08:28:48 Duration: 8s716ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "293945", "modelo" : "454", "itens" : "241624428002,241623644760,241600486888,241626494870,241610960515,241600698199,241641343749,241626289798,241600564045,241624480308,241626665571,241632479416,241627334155,241613120423,241600429307,241633021119,241633664851,241633594665,241611545375,241640782325,241600358592,241627071728,241611028400,241633011724,241627523545,241633711826,241612235678,241612254950,241633381839,241612573040,241624729804,241640528305,241600599098,241600474160,241614262038,241611555050,241611375358,241611449305,241633205659,241633239804,241600642942,241624598602,241642141717,241640320204,241633992538,241612404763,241643727393,241626908401", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-06 13:29:21 Duration: 2s60ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "293718", "modelo" : "464", "itens" : "241776639512,241778745374,241742639819,241738675571,241762561023,241779296673,241747400015,241738807379,241776661535,241739600421,241775863645,241771314054,241827266383,241813225675,241777723849,241768822240,241779156076,241819626277,241815844348,241776363447,241761384757,241745473238,241779079907,241742572237,241820618204,241776385267,241812864046,241741282122,241762869919,241819248686,241764606070,241763905867,241765370725,241764860821,241813622740,241764583947,241738753233,241746465669,241778969616,241740873339,241813914564,241768675457,241738414861,241760028193,241747938810,241762488489,241760109919,241743222334,241742943743,241745510515,241744310611,241760066076,241776303744,241813931839,241814093852,241826205763,241819632541,241820211015,241815545071,241814119814", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-06 08:03:20 Duration: 2s19ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 5m35s 160 150ms 15s183ms 2s98ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 06 00 6 22s723ms 3s787ms 01 6 6s994ms 1s165ms 02 5 7s668ms 1s533ms 03 5 7s368ms 1s473ms 04 6 10s409ms 1s734ms 05 5 11s553ms 2s310ms 07 10 28s421ms 2s842ms 08 13 31s537ms 2s425ms 09 12 28s228ms 2s352ms 10 12 26s380ms 2s198ms 11 12 27s170ms 2s264ms 12 12 21s754ms 1s812ms 13 6 4s930ms 821ms 14 12 26s927ms 2s243ms 15 12 34s822ms 2s901ms 16 10 17s38ms 1s703ms 17 4 2s728ms 682ms 20 1 192ms 192ms 21 5 9s604ms 1s920ms 22 6 9s358ms 1s559ms [ User: intelifix - Total duration: 5m35s - Times executed: 160 ]
[ Application: psql - Total duration: 5m35s - Times executed: 160 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-06 00:05:17 Duration: 15s183ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-06 07:45:07 Duration: 6s574ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-06 08:35:06 Duration: 5s44ms Database: rio User: intelifix Remote: [local] Application: psql
10 5m5s 70 1s192ms 9s33ms 4s362ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 06 07 1 5s354ms 5s354ms 08 3 9s488ms 3s162ms 09 2 7s644ms 3s822ms 10 3 18s380ms 6s126ms 11 4 13s635ms 3s408ms 12 1 1s951ms 1s951ms 13 5 10s181ms 2s36ms 14 9 55s57ms 6s117ms 15 8 35s483ms 4s435ms 16 17 1m48s 6s391ms 17 17 39s507ms 2s323ms [ User: intelifix - Total duration: 5m5s - Times executed: 70 ]
[ Application: [unknown] - Total duration: 5m5s - Times executed: 70 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-06', 099, '', '', 0, 6, '2026-10-01');
Date: 2026-10-06 14:10:34 Duration: 9s33ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-05', 099, '', '', 0, 6, '2026-10-01');
Date: 2026-10-06 10:13:11 Duration: 8s284ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-06', 099, '', '', 0, 6, '2026-10-01');
Date: 2026-10-06 16:23:12 Duration: 7s856ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 2m29s 88 150ms 16s38ms 1s698ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 06 07 14 5s862ms 418ms 08 4 1s517ms 379ms 09 1 799ms 799ms 10 5 2s221ms 444ms 11 21 1m10s 3s360ms 13 7 43s930ms 6s275ms 14 13 8s982ms 690ms 15 14 10s865ms 776ms 16 9 4s755ms 528ms [ User: intelifix - Total duration: 2m29s - Times executed: 88 ]
[ Application: [unknown] - Total duration: 2m29s - Times executed: 88 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (059277) LIMIT 1;
Date: 2026-10-06 13:07:54 Duration: 16s38ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (059277) LIMIT 1;
Date: 2026-10-06 11:30:07 Duration: 16s6ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (059276) LIMIT 1;
Date: 2026-10-06 13:07:16 Duration: 12s828ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
12 2m28s 12 11s538ms 15s670ms 12s393ms create table temp0000293492 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 06 08 2 23s412ms 11s706ms 09 7 1m27s 12s507ms 10 1 13s542ms 13s542ms 11 1 12s282ms 12s282ms 12 1 11s933ms 11s933ms [ User: intelifix - Total duration: 2m28s - Times executed: 12 ]
[ Application: [unknown] - Total duration: 2m28s - Times executed: 12 ]
-
CREATE TABLE temp0000293492 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-06 09:23:48 Duration: 15s670ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293492 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-06 10:24:07 Duration: 13s542ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293492 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-06 09:24:14 Duration: 12s320ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 2m17s 4 4s363ms 1m4s 34s339ms 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 Oct 06 20 2 1m9s 34s581ms 23 2 1m8s 34s98ms [ User: intelifix - Total duration: 2m17s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m17s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-06 20:08:47 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-06 23:16:44 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-06 20:10:47 Duration: 4s384ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 1m49s 36 594ms 7s999ms 3s38ms call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 06 08 3 12s341ms 4s113ms 09 1 2s934ms 2s934ms 10 3 18s940ms 6s313ms 11 2 8s788ms 4s394ms 12 3 4s621ms 1s540ms 13 3 8s939ms 2s979ms 14 2 10s526ms 5s263ms 15 2 7s687ms 3s843ms 16 3 14s540ms 4s846ms 17 3 11s15ms 3s671ms 18 2 1s192ms 596ms 19 2 1s794ms 897ms 20 2 1s958ms 979ms 21 3 2s396ms 798ms 22 2 1s723ms 861ms [ User: intelifix - Total duration: 1m49s - Times executed: 36 ]
[ Application: psql - Total duration: 1m49s - Times executed: 36 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: 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-10-06 17:00:09 Duration: 7s999ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: 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-10-06 10:40:08 Duration: 7s523ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: 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-10-06 13:40:09 Duration: 7s364ms Database: rio User: intelifix Remote: [local] Application: psql
15 1m48s 4 334ms 54s363ms 27s227ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 06 20 2 54s211ms 27s105ms 23 2 54s697ms 27s348ms [ User: intelifix - Total duration: 1m48s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m48s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-06 23:13:46 Duration: 54s363ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-06 20:05:47 Duration: 53s823ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-06 20:10:12 Duration: 387ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 1m48s 6 3s238ms 40s485ms 18s106ms copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 06 20 3 53s972ms 17s990ms 23 3 54s666ms 18s222ms [ User: intelifix - Total duration: 1m48s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m48s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-06 23:14:28 Duration: 40s485ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-06 20:06:30 Duration: 40s187ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-06 23:33:39 Duration: 10s715ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 1m29s 22 209ms 41s998ms 4s61ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 06 07 2 918ms 459ms 08 3 2s394ms 798ms 09 9 12s422ms 1s380ms 10 3 1s361ms 453ms 11 4 1m11s 17s991ms 14 1 283ms 283ms [ User: intelifix - Total duration: 1m29s - Times executed: 22 ]
[ Application: psql - Total duration: 1m29s - Times executed: 22 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030784);
Date: 2026-10-06 11:50:06 Duration: 41s998ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030783);
Date: 2026-10-06 11:30:51 Duration: 29s451ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030777);
Date: 2026-10-06 09:53:06 Duration: 5s51ms Database: rio User: intelifix Remote: [local] Application: psql
18 1m26s 53 569ms 24s881ms 1s629ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 06 08 3 2s512ms 837ms 09 5 7s216ms 1s443ms 10 3 2s206ms 735ms 11 3 6s60ms 2s20ms 12 3 6s459ms 2s153ms 13 3 2s352ms 784ms 14 4 6s194ms 1s548ms 15 4 10s427ms 2s606ms 16 3 1s888ms 629ms 17 3 2s255ms 751ms 18 4 27s488ms 6s872ms 19 4 2s852ms 713ms 20 4 3s92ms 773ms 21 3 2s280ms 760ms 22 4 3s64ms 766ms [ User: intelifix - Total duration: 1m26s - Times executed: 53 ]
[ Application: psql - Total duration: 1m26s - Times executed: 53 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-06 18:00:27 Duration: 24s881ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-06 15:40:09 Duration: 8s51ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-06 12:20:07 Duration: 4s996ms Database: brasilia User: intelifix Remote: [local] Application: psql
19 1m25s 6 2s330ms 32s324ms 14s166ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 06 20 3 42s497ms 14s165ms 23 3 42s504ms 14s168ms [ User: intelifix - Total duration: 1m25s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m25s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-06 23:15:03 Duration: 32s324ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-06 20:07:05 Duration: 32s263ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-06 23:33:47 Duration: 7s849ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 1m23s 6 3s107ms 32s225ms 13s947ms copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 06 20 3 42s13ms 14s4ms 23 3 41s673ms 13s891ms [ User: intelifix - Total duration: 1m23s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m23s - Times executed: 6 ]
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-06 20:09:20 Duration: 32s225ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-06 23:17:16 Duration: 32s9ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-06 20:10:54 Duration: 6s586ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,055 14m11s 150ms 4s141ms 807ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 06 07 12 9s564ms 797ms 08 67 46s491ms 693ms 09 165 2m10s 791ms 10 166 2m12s 795ms 11 106 1m5s 616ms 12 34 18s557ms 545ms 13 73 1m8s 932ms 14 165 2m50s 1s32ms 15 139 1m56s 835ms 16 96 1m14s 774ms 17 32 20s507ms 640ms [ User: intelifix - Total duration: 14m11s - Times executed: 1055 ]
[ Application: [unknown] - Total duration: 14m11s - Times executed: 1055 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (60208, 407, '270911028446100246,216937812747,229925404156,229805812945,229836930909,229685906371,229673286071,229671978604,229816811325,229733847593,229736390828,229808939399,229672444665,229745672631,229850159001,229850166577,229879517073,229662468292,229812433748,229903248592,229865270005,216939921617,216943353658,229865456363,229808677174,229690188911,229748522943,229808844262,229741448706,229860334360,229673690107,229736727178,229811607999,216939740511,229808331631,229691627378,229837155173,229690982939,229742535568,229786790303,216944995355,216943909402,216944352835,229780002233', '246440069709,246089091730,246596241730,246640076770,246519296565,246617917896,246494759603,246630377799,246546757281,246544071128,246618665152,246601504353,246545969921,246642191018,246642190311,246652872442,246542612029,246536781516,246527323859,246648238397,246465040104,246482687998,246652586274,246619372427,246524858791,246551793037,246612965662,246569329103,246648604449,246548082832,246539877586,246612585973,246464380107,246612575770,246507129800,246641428484,246513879505,246548731010,246598582441,246498166063,246484087293,246468171128,246570789818,,,,,,,', 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":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-10-06 10:45:15 Duration: 4s141ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (60280, 406, 'ZTE3ANNR7B32751,3891484BEC41,3891484BEC42,ZTEGDB08114F$ZTE3ANNR1Y02123,14CA56CCDC3D,14CA56CCDC3E,ZTEGD9707EA6$ZTE3ANNRC506238,6C11BA62BC0B,6C11BA62BC0C,ZTEGDC6E2E1D$ZTE3ANNT2V71619,D83139921D6A,D83139921D6B,ZTEGDD310A42$ZTE3ANNQ7102023,C4EBFF89F7D2,C4EBFF89F7D3,ZTEGD70A24B9$ZTE3ANNRCP46872,6C11BA6D755F,6C11BA6D7560,ZTEGDC6FF7AB$ZTE3ANNT3H17838,D831399865AC,D831399865AD,ZTEGDD32164D$ZTE3ANNQ4A00430,3CF9F0AA025A,3CF9F0AA025B,ZTEGD641406D$ZTE3ANNT4P40145,F00C514F5384,F00C514F5385,ZTEGDE349367$ZTE3ANNT2V49430,D8313990155C,D8313990155D,ZTEGDD30B395$ZTE3ANNR3Y01366,4896D94FE0BC,4896D94FE0BD,ZTEGD97E360B$ZTE3ANNT4P16984,F00C514D34AE,F00C514D34AF,ZTEGDE3438EE$ZTE3ANNQ9J07834,843C992C88D1,843C992C88D2,ZTEGD7BB2745$ZTE3ANNR3J04261,F4E84F86B23E,F4E84F86B23F,ZTEGD97B726F$ZTE3ANNRC530771,6C11BA64FB09,6C11BA64FB0A,ZTEGDC6E8DF2$ZTE3ANNQ9J15474,843C992D3BE1,843C992D3BE2,ZTEGD7BB451D$ZTE3ANNQ9J21845,843C992DD133,843C992DD134,ZTEGD7BB5E00$ZTE3ANNQ8111646,689E29BCEFBF,689E29BCEFC0,ZTEGD7B7680E$ZTE3ANNR3Y27611,4896D95247DA,4896D95247DB,ZTEGD97E9C90$ZTE3ANNQCA03387,14CA56D2943D,14CA56D2943E,ZTEGD97172A6$ZTE3ANNQ4A00609,3CF9F0AA068C,3CF9F0AA068D,ZTEGD6414120$ZTE3ANNQ9J41947,843C992FA857,843C992FA858,ZTEGD7BBAC86$ZTE3ANNR7B15326,3891484A53DB,3891484A53DC,ZTEGDB07CD3E$ZTE3ANNQ6307291,3CF9F0704F0D,3CF9F0704F0E,ZTEGD52E5312$ZTE3ANNR8C28203,389148511C09,389148511C0A,ZTEGDB08EE9B$ZTE3ANNQ9J21773,843C992DCF83,843C992DCF84,ZTEGD7BB5DB8$ZTE3ANNR8C09206,3891484F5ECB,3891484F5ECC,ZTEGDB08A466$ZTE3ANNRB708766,5872C98F06A5,5872C98F06A6,ZTEGDC614D11$ZTE3ANNRAM61832,5872C98CE169,5872C98CE16A,ZTEGDC60F187$ZTE3ANNRCB03463,D831391E2028,D831391E2029,ZTEGDD29C31C$ZTE3ANNQ8M18373,843C99207689,843C9920768A,ZTEGD7BA8F32$ZTE3ANNRB705526,5872C98EBAB5,5872C98EBAB6,ZTEGDC614069$ZTE3ANNQ5N16789,3CF9F0AE4EF4,3CF9F0AE4EF5,ZTEGD641F7DC$ZTE3ANNQCA03578,14CA56D298B7,14CA56D298B8,ZTEGD9717365$ZTE3ANNR7B32278,3891484BE12B,3891484BE12C,ZTEGDB080F76$ZTE3ANNR8C09222,3891484F5F2B,3891484F5F2C,ZTEGDB08A476', '',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-06 10:06:52 Duration: 3s830ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (60249, 407, 'ZTE3A8TT3305984,142004533082$ZTE3A8TRB719022,7C7D21EC2BCB$ZTE3A8TRB719411,7C7D21EC31DF$ZTE3A8TT4X13312,14200459DCC2$ZTE3A8TR7917153,E44E12B1F115$ZTE3A8TT4X16649,1420045A10E6$ZTE3A8TT4723625,14200458EF76$ZTE3A8TT4723911,14200458F3EE$ZTE3A8TT7P18853,C492D94673EB$ZTE3A8TR6D11573,E44E12B00B75$ZTE3A8TT3304016,1420045311C2$ZTE3A8TR8U05620,B47CA6080872$ZTE3A8TT3307633,142004534A46$ZTE3A8TT4X15907,1420045A054E$ZTE3A8TR7919121,E44E12B20FD5$ZTE3A8TR7922191,E44E12B23FCD$ZTE3A8TQCH14011,DC5193D965F2$ZTE3A8TT7P06102,C492D945ACAF$ZTE3A8TT4723652,14200458EFE2$ZTE3A8TT7P16656,C492D9465197$ZTE3A8TT4723413,14200458EC26$ZTE3A8TT4724992,1420045904D2$ZTE3A8TT3C14130,142004553E3A$ZTE3A8TT4X12878,14200459D5FA$ZTE3A8TT4723682,14200458F05A$ZTE3A8TT7P18571,C492D9466F83$ZTE3A8TT3305892,142004532F12$ZTE3A8TR7R11261,E44E12B32375$ZTE3A8TT3305911,142004532F5E$ZTE3A8TT4724457,14200458FC76$ZTE3A8TT3C20382,142004559FEA$ZTE3A8TT7P18558,C492D9466F4F$ZTE3A8TR7919271,E44E12B2122D$ZTE3A8TT7P18406,C492D9466CEF$ZTE3A8TR4H13850,38165A47FC58$ZTE3A8TT7P16650,C492D946517F$ZTE3A8TT3303860,142004530F52$ZTE3A8TT4X15780,1420045A0352$ZTE3A8TT7P18607,C492D9467013$ZTE3A8TT4X17756,1420045A2232$ZTE3A8TR4X19896,38165A49E940$ZTE3A8TR4H13931,38165A47FD9C$ZTE3A8TT4X13299,14200459DC8E', '',05,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-06 10:37:56 Duration: 3s685ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
2 671 5m53s 151ms 8s716ms 526ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 06 07 1 1s24ms 1s24ms 08 79 58s981ms 746ms 09 77 44s399ms 576ms 10 94 44s917ms 477ms 11 109 54s406ms 499ms 12 23 11s585ms 503ms 13 57 31s597ms 554ms 14 59 30s552ms 517ms 15 67 30s684ms 457ms 16 82 35s853ms 437ms 17 23 9s353ms 406ms [ User: intelifix - Total duration: 5m53s - Times executed: 671 ]
[ Application: [unknown] - Total duration: 5m53s - Times executed: 671 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "293721", "modelo" : "185", "itens" : "B85E71C46E18,B85E71D06C18,,C4509CAE7A94,B85E710EEB64,C4509CBCBD34,B85E71E6D6D8,08A7C06A0C04,B85E71B7B0FC,3C82C08AE46C,B85E71E599F8,B85E71E728A4,B85E71D30428,D4E2CB1FABEC,B85E71D1D7EC", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-06 08:28:48 Duration: 8s716ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "293945", "modelo" : "454", "itens" : "241624428002,241623644760,241600486888,241626494870,241610960515,241600698199,241641343749,241626289798,241600564045,241624480308,241626665571,241632479416,241627334155,241613120423,241600429307,241633021119,241633664851,241633594665,241611545375,241640782325,241600358592,241627071728,241611028400,241633011724,241627523545,241633711826,241612235678,241612254950,241633381839,241612573040,241624729804,241640528305,241600599098,241600474160,241614262038,241611555050,241611375358,241611449305,241633205659,241633239804,241600642942,241624598602,241642141717,241640320204,241633992538,241612404763,241643727393,241626908401", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-06 13:29:21 Duration: 2s60ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "293718", "modelo" : "464", "itens" : "241776639512,241778745374,241742639819,241738675571,241762561023,241779296673,241747400015,241738807379,241776661535,241739600421,241775863645,241771314054,241827266383,241813225675,241777723849,241768822240,241779156076,241819626277,241815844348,241776363447,241761384757,241745473238,241779079907,241742572237,241820618204,241776385267,241812864046,241741282122,241762869919,241819248686,241764606070,241763905867,241765370725,241764860821,241813622740,241764583947,241738753233,241746465669,241778969616,241740873339,241813914564,241768675457,241738414861,241760028193,241747938810,241762488489,241760109919,241743222334,241742943743,241745510515,241744310611,241760066076,241776303744,241813931839,241814093852,241826205763,241819632541,241820211015,241815545071,241814119814", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-06 08:03:20 Duration: 2s19ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 276 10m19s 189ms 2m31s 2s243ms call rs_giga_triagem (?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 06 00 12 23s398ms 1s949ms 01 12 18s678ms 1s556ms 02 12 18s17ms 1s501ms 03 12 18s844ms 1s570ms 04 12 18s341ms 1s528ms 05 12 18s713ms 1s559ms 06 12 19s796ms 1s649ms 07 12 19s427ms 1s618ms 08 12 20s552ms 1s712ms 09 12 2m49s 14s159ms 10 12 20s680ms 1s723ms 11 12 22s65ms 1s838ms 12 12 19s985ms 1s665ms 13 12 19s902ms 1s658ms 14 12 22s184ms 1s848ms 15 12 20s351ms 1s695ms 16 12 21s140ms 1s761ms 17 12 22s384ms 1s865ms 18 12 20s169ms 1s680ms 19 12 19s532ms 1s627ms 20 12 26s301ms 2s191ms 21 12 19s598ms 1s633ms 22 12 19s198ms 1s599ms [ User: intelifix - Total duration: 10m19s - Times executed: 276 ]
[ Application: psql - Total duration: 10m19s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-06 09:37:36 Duration: 2m31s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-06 20:05:08 Duration: 6s380ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-06 20:15:07 Duration: 5s865ms Database: rio User: intelifix Remote: [local] Application: psql
4 162 37m15s 151ms 6m20s 13s799ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 06 07 10 6m25s 38s530ms 08 12 47s56ms 3s921ms 09 21 14m13s 40s640ms 10 14 36s60ms 2s575ms 11 26 8m52s 20s477ms 12 6 2m19s 23s288ms 13 15 1m31s 6s85ms 14 24 1m 2s508ms 15 17 21s98ms 1s241ms 16 10 19s959ms 1s995ms 17 6 47s146ms 7s857ms 18 1 1s855ms 1s855ms [ User: intelifix - Total duration: 37m15s - Times executed: 162 ]
[ Application: [unknown] - Total duration: 37m15s - Times executed: 162 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030765, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-06 07:51:15 Duration: 6m20s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030770, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-06 09:11:21 Duration: 6m2s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030775, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-06 09:37:35 Duration: 5m55s Database: rio User: intelifix Remote: [local] Application: [unknown]
5 160 5m35s 150ms 15s183ms 2s98ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 06 00 6 22s723ms 3s787ms 01 6 6s994ms 1s165ms 02 5 7s668ms 1s533ms 03 5 7s368ms 1s473ms 04 6 10s409ms 1s734ms 05 5 11s553ms 2s310ms 07 10 28s421ms 2s842ms 08 13 31s537ms 2s425ms 09 12 28s228ms 2s352ms 10 12 26s380ms 2s198ms 11 12 27s170ms 2s264ms 12 12 21s754ms 1s812ms 13 6 4s930ms 821ms 14 12 26s927ms 2s243ms 15 12 34s822ms 2s901ms 16 10 17s38ms 1s703ms 17 4 2s728ms 682ms 20 1 192ms 192ms 21 5 9s604ms 1s920ms 22 6 9s358ms 1s559ms [ User: intelifix - Total duration: 5m35s - Times executed: 160 ]
[ Application: psql - Total duration: 5m35s - Times executed: 160 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-06 00:05:17 Duration: 15s183ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-06 07:45:07 Duration: 6s574ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-06 08:35:06 Duration: 5s44ms Database: rio User: intelifix Remote: [local] Application: psql
6 104 33s832ms 299ms 420ms 325ms 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 #6
Day Hour Count Duration Avg duration Oct 06 01 2 605ms 302ms 04 3 935ms 311ms 05 2 636ms 318ms 06 2 633ms 316ms 07 5 1s590ms 318ms 08 8 2s543ms 317ms 09 12 3s854ms 321ms 10 8 2s695ms 336ms 11 10 3s173ms 317ms 12 7 2s222ms 317ms 13 7 2s299ms 328ms 14 13 4s234ms 325ms 15 9 3s55ms 339ms 16 11 3s730ms 339ms 17 4 1s314ms 328ms 21 1 308ms 308ms [ User: lenon - Total duration: 33s832ms - Times executed: 104 ]
[ Application: [unknown] - Total duration: 33s832ms - Times executed: 104 ]
-
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-10-06 15:35:11 Duration: 420ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-10-06 09:24:57 Duration: 376ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-10-06 17:15:39 Duration: 365ms Database: contagem User: lenon Remote: [local] Application: [unknown] Bind query: yes
7 96 36s655ms 335ms 494ms 381ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 06 01 2 834ms 417ms 04 3 1s93ms 364ms 05 2 764ms 382ms 07 4 1s446ms 361ms 08 5 1s920ms 384ms 09 12 4s515ms 376ms 10 8 3s81ms 385ms 11 10 3s704ms 370ms 12 7 2s551ms 364ms 13 7 2s823ms 403ms 14 12 4s440ms 370ms 15 9 3s569ms 396ms 16 11 4s405ms 400ms 17 4 1s505ms 376ms [ User: intelifix - Total duration: 36s655ms - Times executed: 96 ]
[ Application: [unknown] - Total duration: 36s655ms - Times executed: 96 ]
-
select * from rs_menu_grants (404, 57, 1);
Date: 2026-10-06 15:35:11 Duration: 494ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (499, 19, 1);
Date: 2026-10-06 01:21:33 Duration: 471ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (406, 18, 1);
Date: 2026-10-06 13:03:58 Duration: 467ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
8 88 2m29s 150ms 16s38ms 1s698ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 06 07 14 5s862ms 418ms 08 4 1s517ms 379ms 09 1 799ms 799ms 10 5 2s221ms 444ms 11 21 1m10s 3s360ms 13 7 43s930ms 6s275ms 14 13 8s982ms 690ms 15 14 10s865ms 776ms 16 9 4s755ms 528ms [ User: intelifix - Total duration: 2m29s - Times executed: 88 ]
[ Application: [unknown] - Total duration: 2m29s - Times executed: 88 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (059277) LIMIT 1;
Date: 2026-10-06 13:07:54 Duration: 16s38ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (059277) LIMIT 1;
Date: 2026-10-06 11:30:07 Duration: 16s6ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (059276) LIMIT 1;
Date: 2026-10-06 13:07:16 Duration: 12s828ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
9 83 33s258ms 154ms 860ms 400ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 06 09 6 1s495ms 249ms 10 51 17s300ms 339ms 15 26 14s462ms 556ms [ User: intelifix - Total duration: 33s258ms - Times executed: 83 ]
[ Application: [unknown] - Total duration: 33s258ms - Times executed: 83 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"60204","seriais":"C03C047FE76E,ACD75BB6E397,D833B7C9CBBD,44D45460D0E1,E4C0E29808EF,E4C0E29800A6,6CFFCE692942,841EA397DA5A,E4C0E2983BD2,E4C0E298009F,8CFDDE87D5EF,44D45460CC73,8CFDDE87CF6D,841EA38E2451,3453D2A88A50,209A7DBBA369,E4C0E2980BC0","usuario":"416","observacao":""}');
Date: 2026-10-06 15:09:52 Duration: 860ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"60204","seriais":"6802B8A0CCC6,B4F2673256CD,6802B8F00A5E,6802B8A23CDF,6802B82408BE,6802B86217BC,B4F2670C34C2,6802B8625764,6802B8F89A8C,6802B8F059F0,B4F2676B03A5,6802B85B2BFA,6802B814D838,6802B8F84F7A,6802B8F05C90,6802B85B9515","usuario":"416","observacao":""}');
Date: 2026-10-06 15:12:01 Duration: 807ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"60204","seriais":"104121096FE0,104121314890,90AAC3A8A0E0,10412112F040,104121380050,104121375230,1041210258C0,104121260340,104121189F10,104121055A60,104121104410,1041212BE9A0,1041211AD370,104121257E40,10412133AA90","usuario":"416","observacao":""}');
Date: 2026-10-06 15:10:55 Duration: 759ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
10 70 5m5s 1s192ms 9s33ms 4s362ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 06 07 1 5s354ms 5s354ms 08 3 9s488ms 3s162ms 09 2 7s644ms 3s822ms 10 3 18s380ms 6s126ms 11 4 13s635ms 3s408ms 12 1 1s951ms 1s951ms 13 5 10s181ms 2s36ms 14 9 55s57ms 6s117ms 15 8 35s483ms 4s435ms 16 17 1m48s 6s391ms 17 17 39s507ms 2s323ms [ User: intelifix - Total duration: 5m5s - Times executed: 70 ]
[ Application: [unknown] - Total duration: 5m5s - Times executed: 70 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-06', 099, '', '', 0, 6, '2026-10-01');
Date: 2026-10-06 14:10:34 Duration: 9s33ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-05', 099, '', '', 0, 6, '2026-10-01');
Date: 2026-10-06 10:13:11 Duration: 8s284ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-06', 099, '', '', 0, 6, '2026-10-01');
Date: 2026-10-06 16:23:12 Duration: 7s856ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 55 22s903ms 151ms 890ms 416ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 06 08 8 3s876ms 484ms 09 12 5s717ms 476ms 10 6 2s251ms 375ms 13 6 1s885ms 314ms 14 10 4s609ms 460ms 15 5 1s830ms 366ms 16 8 2s733ms 341ms [ User: intelifix - Total duration: 22s903ms - Times executed: 55 ]
[ Application: [unknown] - Total duration: 22s903ms - Times executed: 55 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '802D1A0076C8,D8E84489B5C6,6877DA5F51A7,6877DA5A2EA3,F42D06472AC7,6877DA591B67,D8E8448D493A,6877DA61033B,6877DA597FD7,6877DA5BCE8F,802D1A1EF58C,D8E8448AEBBA,F42D064677FF,CC29BDEB3929,6877DA59320B,D8E8448945AE,802D1A1EC2C0,CC29BD2174B7', '138;1', 'DEFAULT', 09, 0301, '','', '', 00);
Date: 2026-10-06 09:41:51 Duration: 890ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 1, 26, '241652856477,241651592224,241637607076,241679443842,241717153134,241673303142,241676516272,241713501622,241660458397,241698507677,241704245757,241709592430,241669939514,241639060216,241672732626,241658131931,241734315067,241711807898,241632765964,241661421736,241595265054,241666814955,241645911726,241653407698,241697138789,241676608807,241655275153,241702898992,241603988385,241707004343,241713064149,241694710518,241708600123,241701778591,241694962338,241652104855,241712578186,241676431618,241622032235,241594031231,241677380611,241595757077,241707287378,241646616878,241655589707,241709674862,230043721517,241661129103,241726241126,241658199311,241635907090', '','DEFAULT',056,0320,'', '','', 00);
Date: 2026-10-06 14:22:28 Duration: 715ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, 'C4EBFF8AC1AA,C4EBFF8AEC40,843C99224C57,14CA56CFD343,5872C98B1D95,843C9921422F,843C99203477,3CF9F0A9BB20,D89A0DA69C03,48D682385114,3891484AD2CB,4896D9547628,48D682306058,3CF9F0AC6EA6,14CA56D0128B,D89A0DA8F9B5,6C11BA69CF8D,C4EBFF89704E', '138;1', 'DEFAULT', 09, 0323, '','', '', 00);
Date: 2026-10-06 08:36:31 Duration: 701ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
12 53 1m26s 569ms 24s881ms 1s629ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 06 08 3 2s512ms 837ms 09 5 7s216ms 1s443ms 10 3 2s206ms 735ms 11 3 6s60ms 2s20ms 12 3 6s459ms 2s153ms 13 3 2s352ms 784ms 14 4 6s194ms 1s548ms 15 4 10s427ms 2s606ms 16 3 1s888ms 629ms 17 3 2s255ms 751ms 18 4 27s488ms 6s872ms 19 4 2s852ms 713ms 20 4 3s92ms 773ms 21 3 2s280ms 760ms 22 4 3s64ms 766ms [ User: intelifix - Total duration: 1m26s - Times executed: 53 ]
[ Application: psql - Total duration: 1m26s - Times executed: 53 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-06 18:00:27 Duration: 24s881ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-06 15:40:09 Duration: 8s51ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-06 12:20:07 Duration: 4s996ms Database: brasilia User: intelifix Remote: [local] Application: psql
13 53 15s917ms 269ms 404ms 300ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 06 07 1 281ms 281ms 08 9 2s543ms 282ms 09 13 4s18ms 309ms 10 6 1s872ms 312ms 11 3 915ms 305ms 12 1 301ms 301ms 13 3 846ms 282ms 14 6 1s762ms 293ms 15 2 611ms 305ms 16 3 974ms 324ms 17 5 1s493ms 298ms 18 1 296ms 296ms [ User: intelifix - Total duration: 15s917ms - Times executed: 53 ]
[ Application: [unknown] - Total duration: 15s917ms - Times executed: 53 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-10-06 10:55:52 Duration: 404ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-10-06 09:23:02 Duration: 385ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 073;
Date: 2026-10-06 17:22:08 Duration: 362ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
14 51 11s930ms 152ms 360ms 233ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 06 01 8 1s588ms 198ms 04 6 1s374ms 229ms 05 2 449ms 224ms 08 5 1s254ms 250ms 09 11 2s823ms 256ms 10 6 1s597ms 266ms 14 6 1s613ms 268ms 15 5 888ms 177ms 16 2 341ms 170ms [ User: intelifix - Total duration: 11s930ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 11s930ms - Times executed: 51 ]
-
SELECT * FROM RS_TRIAGEM (430, 5, '138', 6, '8401125F34B4,840112801AFC,9877E70904E6,1834AF25DF50,9877E74D3963,743AEF304FCC,840112045857,743AEFC4CEEA,84011229237B,9877E7BD1C2E,9877E7BD74FE,743AEF5CCFEC,84011205192B,743AEFC4C909,1834AF254859,840112C2592E,743AEFAF95D0,840112291558,840112931B29,743AEF326109,9877E7003D85,84011261AAE5,84011260384E,9877E7BD904F,743AEFD9A7E1,9877E7497CE7,9877E74DEE3D,9877E70A964E,1834AF99BB47,743AEFC5B28D,1834AF99C71E,840112ECE512,9877E77CFF48,9877E7076B58,743AEFC4DA97,9877E7BF1B35,1834AF99977C,9877E7483A8C,840112BCD947,1834AF99CB15,84011228F61E,743AEF7569DC,840112055C53,9877E7B9135A,743AEF30E39E,743AEF313774,743AEFD96679,9877E70A8DE9', NULL, NULL, 0153, 00);
Date: 2026-10-06 09:39:54 Duration: 360ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (409, 5, '113', 3, '230049983744,229971661735,230027555977,230026105263,230005344853,229971709719,230014480931,229976894557,229962679511,230000948991', NULL, NULL, 0295, 00);
Date: 2026-10-06 08:40:44 Duration: 359ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (430, 5, '138', 6, '743AEFAC209D,84011282B42D,1834AF9A5CF6,8401125FDB5D,1834AF995E25,840112C255E6,8401120556C6,84011238F920,743AEF34D9B0,9877E749EFE9,1834AF99A146,743AEF34E5AA,1834AF255A2D,1834AF25D28B,9877E7BD38D6,9877E7BD10AB,9877E7002131,743AEF7481C4,743AEF70B84B,84011284C09A,8401128018EF,8401122A55EC,9877E74AF439,743AEFACD1AA,1834AF257E68,9877E7075ABF,9877E74B3301,84011283D969,84011295CB36,1834AF25FBF8,9877E77CC2B0,8401122A457D,743AEF95FF2A,9877E7008A3F,743AEF74531E,9877E700B8C2,743AEF73B703,743AEF743FF3,743AEF30D1DF,743AEF319052,743AEFD9A318,743AEFD98718,743AEFC4DF7C,840112C25920,9877E749AB7F,84011204D737,743AEF5CD6C2,9877E77DF8A1', NULL, NULL, 0153, 00);
Date: 2026-10-06 10:14:40 Duration: 334ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 48 1h37m15s 2s156ms 6m34s 2m1s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 06 07 3 7m9s 2m23s 08 3 6m1s 2m 09 3 6m20s 2m6s 10 3 6m8s 2m2s 11 3 6m17s 2m5s 12 3 5m59s 1m59s 13 3 5m50s 1m56s 14 3 5m56s 1m58s 15 3 6m11s 2m3s 16 3 6m13s 2m4s 17 3 6m19s 2m6s 18 3 5m48s 1m56s 19 3 5m42s 1m54s 20 3 5m49s 1m56s 21 3 5m42s 1m54s 22 3 5m43s 1m54s [ User: intelifix - Total duration: 1h37m15s - Times executed: 48 ]
[ Application: psql - Total duration: 1h37m15s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-06 07:11:36 Duration: 6m34s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-06 17:11:00 Duration: 5m58s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-06 09:10:56 Duration: 5m54s Database: rio User: intelifix Remote: [local] Application: psql
16 48 1h7m42s 232ms 3m52s 1m24s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 06 07 3 4m52s 1m37s 08 3 4m7s 1m22s 09 3 4m36s 1m32s 10 3 4m15s 1m25s 11 3 4m14s 1m24s 12 3 3m59s 1m19s 13 3 4m4s 1m21s 14 3 4m12s 1m24s 15 3 4m19s 1m26s 16 3 4m26s 1m28s 17 3 4m27s 1m29s 18 3 4m5s 1m21s 19 3 3m57s 1m19s 20 3 4m1s 1m20s 21 3 4m1s 1m20s 22 3 3m59s 1m19s [ User: intelifix - Total duration: 1h7m42s - Times executed: 48 ]
[ Application: psql - Total duration: 1h7m42s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-06 17:15:45 Duration: 3m52s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-06 16:15:38 Duration: 3m52s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-06 07:16:56 Duration: 3m48s Database: brasilia User: intelifix Remote: [local] Application: psql
17 36 1m49s 594ms 7s999ms 3s38ms call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 06 08 3 12s341ms 4s113ms 09 1 2s934ms 2s934ms 10 3 18s940ms 6s313ms 11 2 8s788ms 4s394ms 12 3 4s621ms 1s540ms 13 3 8s939ms 2s979ms 14 2 10s526ms 5s263ms 15 2 7s687ms 3s843ms 16 3 14s540ms 4s846ms 17 3 11s15ms 3s671ms 18 2 1s192ms 596ms 19 2 1s794ms 897ms 20 2 1s958ms 979ms 21 3 2s396ms 798ms 22 2 1s723ms 861ms [ User: intelifix - Total duration: 1m49s - Times executed: 36 ]
[ Application: psql - Total duration: 1m49s - Times executed: 36 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: 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-10-06 17:00:09 Duration: 7s999ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: 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-10-06 10:40:08 Duration: 7s523ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: 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-10-06 13:40:09 Duration: 7s364ms Database: rio User: intelifix Remote: [local] Application: psql
18 35 6m51s 10s816ms 12s933ms 11s764ms create table temp0000293472 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 06 07 5 55s337ms 11s67ms 08 6 1m10s 11s780ms 09 12 2m24s 12s5ms 10 6 1m9s 11s628ms 11 6 1m11s 11s980ms [ User: intelifix - Total duration: 6m51s - Times executed: 35 ]
[ Application: [unknown] - Total duration: 6m51s - Times executed: 35 ]
-
CREATE TABLE temp0000293472 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-06 11:16:12 Duration: 12s933ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293472 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-06 09:30:57 Duration: 12s921ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293472 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-06 08:32:53 Duration: 12s333ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 30 7s403ms 154ms 1s912ms 246ms create table temp0000293490 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 06 08 1 1s912ms 1s912ms 09 2 530ms 265ms 14 2 316ms 158ms 15 8 1s312ms 164ms 16 17 3s331ms 195ms [ User: intelifix - Total duration: 7s403ms - Times executed: 30 ]
[ Application: [unknown] - Total duration: 7s403ms - Times executed: 30 ]
-
CREATE TABLE temp0000293490 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"01-10-2026", "ate" :"06-10-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-06 08:17:12 Duration: 1s912ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293490 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"01-10-2026", "ate" :"06-10-2026", "nota-fiscal":"69010", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-06 09:55:27 Duration: 296ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293490 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"01-10-2026", "ate" :"06-10-2026", "nota-fiscal":"69010", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-06 09:16:34 Duration: 234ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 27 40s887ms 1s338ms 2s697ms 1s514ms create table temp0000293478 as select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 06 07 26 38s189ms 1s468ms 15 1 2s697ms 2s697ms [ User: intelifix - Total duration: 40s887ms - Times executed: 27 ]
[ Application: [unknown] - Total duration: 40s887ms - Times executed: 27 ]
-
CREATE TABLE temp0000293478 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "6", "cliente" : "0", "nf" : "", "data-de" : "01-10-2026", "data-ate" : "06-10-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-10-06 15:31:29 Duration: 2s697ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293478 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "6", "cliente" : "0", "nf" : "", "data-de" : "01-10-2026", "data-ate" : "06-10-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-10-06 07:51:52 Duration: 1s935ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293478 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "6", "cliente" : "5", "nf" : "", "data-de" : "01-10-2026", "data-ate" : "06-10-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-10-06 07:52:53 Duration: 1s584ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m42s 9m33s 6m19s 3 18m59s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 06 05 3 18m59s 6m19s [ User: intelifix - Total duration: 18m59s - Times executed: 3 ]
[ Application: psql - Total duration: 18m59s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-10-06 05:09:35 Duration: 9m33s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-06 05:16:18 Duration: 6m43s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-06 05:19:00 Duration: 2m42s Database: contagem User: intelifix Remote: [local] Application: psql
2 2s156ms 6m34s 2m1s 48 1h37m15s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 06 07 3 7m9s 2m23s 08 3 6m1s 2m 09 3 6m20s 2m6s 10 3 6m8s 2m2s 11 3 6m17s 2m5s 12 3 5m59s 1m59s 13 3 5m50s 1m56s 14 3 5m56s 1m58s 15 3 6m11s 2m3s 16 3 6m13s 2m4s 17 3 6m19s 2m6s 18 3 5m48s 1m56s 19 3 5m42s 1m54s 20 3 5m49s 1m56s 21 3 5m42s 1m54s 22 3 5m43s 1m54s [ User: intelifix - Total duration: 1h37m15s - Times executed: 48 ]
[ Application: psql - Total duration: 1h37m15s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-06 07:11:36 Duration: 6m34s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-06 17:11:00 Duration: 5m58s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-06 09:10:56 Duration: 5m54s Database: rio User: intelifix Remote: [local] Application: psql
3 232ms 3m52s 1m24s 48 1h7m42s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 06 07 3 4m52s 1m37s 08 3 4m7s 1m22s 09 3 4m36s 1m32s 10 3 4m15s 1m25s 11 3 4m14s 1m24s 12 3 3m59s 1m19s 13 3 4m4s 1m21s 14 3 4m12s 1m24s 15 3 4m19s 1m26s 16 3 4m26s 1m28s 17 3 4m27s 1m29s 18 3 4m5s 1m21s 19 3 3m57s 1m19s 20 3 4m1s 1m20s 21 3 4m1s 1m20s 22 3 3m59s 1m19s [ User: intelifix - Total duration: 1h7m42s - Times executed: 48 ]
[ Application: psql - Total duration: 1h7m42s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-06 17:15:45 Duration: 3m52s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-06 16:15:38 Duration: 3m52s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-06 07:16:56 Duration: 3m48s Database: brasilia User: intelifix Remote: [local] Application: psql
4 4s363ms 1m4s 34s339ms 4 2m17s 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 Oct 06 20 2 1m9s 34s581ms 23 2 1m8s 34s98ms [ User: intelifix - Total duration: 2m17s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m17s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-06 20:08:47 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-06 23:16:44 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-06 20:10:47 Duration: 4s384ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
5 334ms 54s363ms 27s227ms 4 1m48s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 06 20 2 54s211ms 27s105ms 23 2 54s697ms 27s348ms [ User: intelifix - Total duration: 1m48s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m48s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-06 23:13:46 Duration: 54s363ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-06 20:05:47 Duration: 53s823ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-06 20:10:12 Duration: 387ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 3s238ms 40s485ms 18s106ms 6 1m48s copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 06 20 3 53s972ms 17s990ms 23 3 54s666ms 18s222ms [ User: intelifix - Total duration: 1m48s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m48s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-06 23:14:28 Duration: 40s485ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-06 20:06:30 Duration: 40s187ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-06 23:33:39 Duration: 10s715ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 2s330ms 32s324ms 14s166ms 6 1m25s copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 06 20 3 42s497ms 14s165ms 23 3 42s504ms 14s168ms [ User: intelifix - Total duration: 1m25s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m25s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-06 23:15:03 Duration: 32s324ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-06 20:07:05 Duration: 32s263ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-06 23:33:47 Duration: 7s849ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 3s107ms 32s225ms 13s947ms 6 1m23s copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 06 20 3 42s13ms 14s4ms 23 3 41s673ms 13s891ms [ User: intelifix - Total duration: 1m23s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m23s - Times executed: 6 ]
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-06 20:09:20 Duration: 32s225ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-06 23:17:16 Duration: 32s9ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-06 20:10:54 Duration: 6s586ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
9 151ms 6m20s 13s799ms 162 37m15s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 06 07 10 6m25s 38s530ms 08 12 47s56ms 3s921ms 09 21 14m13s 40s640ms 10 14 36s60ms 2s575ms 11 26 8m52s 20s477ms 12 6 2m19s 23s288ms 13 15 1m31s 6s85ms 14 24 1m 2s508ms 15 17 21s98ms 1s241ms 16 10 19s959ms 1s995ms 17 6 47s146ms 7s857ms 18 1 1s855ms 1s855ms [ User: intelifix - Total duration: 37m15s - Times executed: 162 ]
[ Application: [unknown] - Total duration: 37m15s - Times executed: 162 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030765, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-06 07:51:15 Duration: 6m20s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030770, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-06 09:11:21 Duration: 6m2s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030775, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-06 09:37:35 Duration: 5m55s Database: rio User: intelifix Remote: [local] Application: [unknown]
10 11s538ms 15s670ms 12s393ms 12 2m28s create table temp0000293492 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 06 08 2 23s412ms 11s706ms 09 7 1m27s 12s507ms 10 1 13s542ms 13s542ms 11 1 12s282ms 12s282ms 12 1 11s933ms 11s933ms [ User: intelifix - Total duration: 2m28s - Times executed: 12 ]
[ Application: [unknown] - Total duration: 2m28s - Times executed: 12 ]
-
CREATE TABLE temp0000293492 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-06 09:23:48 Duration: 15s670ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293492 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-06 10:24:07 Duration: 13s542ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293492 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-06 09:24:14 Duration: 12s320ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 10s816ms 12s933ms 11s764ms 35 6m51s create table temp0000293472 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 06 07 5 55s337ms 11s67ms 08 6 1m10s 11s780ms 09 12 2m24s 12s5ms 10 6 1m9s 11s628ms 11 6 1m11s 11s980ms [ User: intelifix - Total duration: 6m51s - Times executed: 35 ]
[ Application: [unknown] - Total duration: 6m51s - Times executed: 35 ]
-
CREATE TABLE temp0000293472 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-06 11:16:12 Duration: 12s933ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293472 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-06 09:30:57 Duration: 12s921ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293472 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-06 08:32:53 Duration: 12s333ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 1s192ms 9s33ms 4s362ms 70 5m5s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 06 07 1 5s354ms 5s354ms 08 3 9s488ms 3s162ms 09 2 7s644ms 3s822ms 10 3 18s380ms 6s126ms 11 4 13s635ms 3s408ms 12 1 1s951ms 1s951ms 13 5 10s181ms 2s36ms 14 9 55s57ms 6s117ms 15 8 35s483ms 4s435ms 16 17 1m48s 6s391ms 17 17 39s507ms 2s323ms [ User: intelifix - Total duration: 5m5s - Times executed: 70 ]
[ Application: [unknown] - Total duration: 5m5s - Times executed: 70 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-06', 099, '', '', 0, 6, '2026-10-01');
Date: 2026-10-06 14:10:34 Duration: 9s33ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-05', 099, '', '', 0, 6, '2026-10-01');
Date: 2026-10-06 10:13:11 Duration: 8s284ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-06', 099, '', '', 0, 6, '2026-10-01');
Date: 2026-10-06 16:23:12 Duration: 7s856ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 209ms 41s998ms 4s61ms 22 1m29s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 06 07 2 918ms 459ms 08 3 2s394ms 798ms 09 9 12s422ms 1s380ms 10 3 1s361ms 453ms 11 4 1m11s 17s991ms 14 1 283ms 283ms [ User: intelifix - Total duration: 1m29s - Times executed: 22 ]
[ Application: psql - Total duration: 1m29s - Times executed: 22 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030784);
Date: 2026-10-06 11:50:06 Duration: 41s998ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030783);
Date: 2026-10-06 11:30:51 Duration: 29s451ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030777);
Date: 2026-10-06 09:53:06 Duration: 5s51ms Database: rio User: intelifix Remote: [local] Application: psql
14 594ms 7s999ms 3s38ms 36 1m49s call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 06 08 3 12s341ms 4s113ms 09 1 2s934ms 2s934ms 10 3 18s940ms 6s313ms 11 2 8s788ms 4s394ms 12 3 4s621ms 1s540ms 13 3 8s939ms 2s979ms 14 2 10s526ms 5s263ms 15 2 7s687ms 3s843ms 16 3 14s540ms 4s846ms 17 3 11s15ms 3s671ms 18 2 1s192ms 596ms 19 2 1s794ms 897ms 20 2 1s958ms 979ms 21 3 2s396ms 798ms 22 2 1s723ms 861ms [ User: intelifix - Total duration: 1m49s - Times executed: 36 ]
[ Application: psql - Total duration: 1m49s - Times executed: 36 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: 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-10-06 17:00:09 Duration: 7s999ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: 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-10-06 10:40:08 Duration: 7s523ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: 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-10-06 13:40:09 Duration: 7s364ms Database: rio User: intelifix Remote: [local] Application: psql
15 189ms 2m31s 2s243ms 276 10m19s call rs_giga_triagem (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 06 00 12 23s398ms 1s949ms 01 12 18s678ms 1s556ms 02 12 18s17ms 1s501ms 03 12 18s844ms 1s570ms 04 12 18s341ms 1s528ms 05 12 18s713ms 1s559ms 06 12 19s796ms 1s649ms 07 12 19s427ms 1s618ms 08 12 20s552ms 1s712ms 09 12 2m49s 14s159ms 10 12 20s680ms 1s723ms 11 12 22s65ms 1s838ms 12 12 19s985ms 1s665ms 13 12 19s902ms 1s658ms 14 12 22s184ms 1s848ms 15 12 20s351ms 1s695ms 16 12 21s140ms 1s761ms 17 12 22s384ms 1s865ms 18 12 20s169ms 1s680ms 19 12 19s532ms 1s627ms 20 12 26s301ms 2s191ms 21 12 19s598ms 1s633ms 22 12 19s198ms 1s599ms [ User: intelifix - Total duration: 10m19s - Times executed: 276 ]
[ Application: psql - Total duration: 10m19s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-06 09:37:36 Duration: 2m31s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-06 20:05:08 Duration: 6s380ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-06 20:15:07 Duration: 5s865ms Database: rio User: intelifix Remote: [local] Application: psql
16 150ms 15s183ms 2s98ms 160 5m35s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 06 00 6 22s723ms 3s787ms 01 6 6s994ms 1s165ms 02 5 7s668ms 1s533ms 03 5 7s368ms 1s473ms 04 6 10s409ms 1s734ms 05 5 11s553ms 2s310ms 07 10 28s421ms 2s842ms 08 13 31s537ms 2s425ms 09 12 28s228ms 2s352ms 10 12 26s380ms 2s198ms 11 12 27s170ms 2s264ms 12 12 21s754ms 1s812ms 13 6 4s930ms 821ms 14 12 26s927ms 2s243ms 15 12 34s822ms 2s901ms 16 10 17s38ms 1s703ms 17 4 2s728ms 682ms 20 1 192ms 192ms 21 5 9s604ms 1s920ms 22 6 9s358ms 1s559ms [ User: intelifix - Total duration: 5m35s - Times executed: 160 ]
[ Application: psql - Total duration: 5m35s - Times executed: 160 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-06 00:05:17 Duration: 15s183ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-06 07:45:07 Duration: 6s574ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-06 08:35:06 Duration: 5s44ms Database: rio User: intelifix Remote: [local] Application: psql
17 150ms 16s38ms 1s698ms 88 2m29s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 06 07 14 5s862ms 418ms 08 4 1s517ms 379ms 09 1 799ms 799ms 10 5 2s221ms 444ms 11 21 1m10s 3s360ms 13 7 43s930ms 6s275ms 14 13 8s982ms 690ms 15 14 10s865ms 776ms 16 9 4s755ms 528ms [ User: intelifix - Total duration: 2m29s - Times executed: 88 ]
[ Application: [unknown] - Total duration: 2m29s - Times executed: 88 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (059277) LIMIT 1;
Date: 2026-10-06 13:07:54 Duration: 16s38ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (059277) LIMIT 1;
Date: 2026-10-06 11:30:07 Duration: 16s6ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (059276) LIMIT 1;
Date: 2026-10-06 13:07:16 Duration: 12s828ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
18 569ms 24s881ms 1s629ms 53 1m26s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 06 08 3 2s512ms 837ms 09 5 7s216ms 1s443ms 10 3 2s206ms 735ms 11 3 6s60ms 2s20ms 12 3 6s459ms 2s153ms 13 3 2s352ms 784ms 14 4 6s194ms 1s548ms 15 4 10s427ms 2s606ms 16 3 1s888ms 629ms 17 3 2s255ms 751ms 18 4 27s488ms 6s872ms 19 4 2s852ms 713ms 20 4 3s92ms 773ms 21 3 2s280ms 760ms 22 4 3s64ms 766ms [ User: intelifix - Total duration: 1m26s - Times executed: 53 ]
[ Application: psql - Total duration: 1m26s - Times executed: 53 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-06 18:00:27 Duration: 24s881ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-06 15:40:09 Duration: 8s51ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-06 12:20:07 Duration: 4s996ms Database: brasilia User: intelifix Remote: [local] Application: psql
19 1s338ms 2s697ms 1s514ms 27 40s887ms create table temp0000293478 as select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 06 07 26 38s189ms 1s468ms 15 1 2s697ms 2s697ms [ User: intelifix - Total duration: 40s887ms - Times executed: 27 ]
[ Application: [unknown] - Total duration: 40s887ms - Times executed: 27 ]
-
CREATE TABLE temp0000293478 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "6", "cliente" : "0", "nf" : "", "data-de" : "01-10-2026", "data-ate" : "06-10-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-10-06 15:31:29 Duration: 2s697ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293478 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "6", "cliente" : "0", "nf" : "", "data-de" : "01-10-2026", "data-ate" : "06-10-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-10-06 07:51:52 Duration: 1s935ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293478 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "6", "cliente" : "5", "nf" : "", "data-de" : "01-10-2026", "data-ate" : "06-10-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-10-06 07:52:53 Duration: 1s584ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 150ms 4s141ms 807ms 1,055 14m11s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 06 07 12 9s564ms 797ms 08 67 46s491ms 693ms 09 165 2m10s 791ms 10 166 2m12s 795ms 11 106 1m5s 616ms 12 34 18s557ms 545ms 13 73 1m8s 932ms 14 165 2m50s 1s32ms 15 139 1m56s 835ms 16 96 1m14s 774ms 17 32 20s507ms 640ms [ User: intelifix - Total duration: 14m11s - Times executed: 1055 ]
[ Application: [unknown] - Total duration: 14m11s - Times executed: 1055 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (60208, 407, '270911028446100246,216937812747,229925404156,229805812945,229836930909,229685906371,229673286071,229671978604,229816811325,229733847593,229736390828,229808939399,229672444665,229745672631,229850159001,229850166577,229879517073,229662468292,229812433748,229903248592,229865270005,216939921617,216943353658,229865456363,229808677174,229690188911,229748522943,229808844262,229741448706,229860334360,229673690107,229736727178,229811607999,216939740511,229808331631,229691627378,229837155173,229690982939,229742535568,229786790303,216944995355,216943909402,216944352835,229780002233', '246440069709,246089091730,246596241730,246640076770,246519296565,246617917896,246494759603,246630377799,246546757281,246544071128,246618665152,246601504353,246545969921,246642191018,246642190311,246652872442,246542612029,246536781516,246527323859,246648238397,246465040104,246482687998,246652586274,246619372427,246524858791,246551793037,246612965662,246569329103,246648604449,246548082832,246539877586,246612585973,246464380107,246612575770,246507129800,246641428484,246513879505,246548731010,246598582441,246498166063,246484087293,246468171128,246570789818,,,,,,,', 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":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-10-06 10:45:15 Duration: 4s141ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (60280, 406, 'ZTE3ANNR7B32751,3891484BEC41,3891484BEC42,ZTEGDB08114F$ZTE3ANNR1Y02123,14CA56CCDC3D,14CA56CCDC3E,ZTEGD9707EA6$ZTE3ANNRC506238,6C11BA62BC0B,6C11BA62BC0C,ZTEGDC6E2E1D$ZTE3ANNT2V71619,D83139921D6A,D83139921D6B,ZTEGDD310A42$ZTE3ANNQ7102023,C4EBFF89F7D2,C4EBFF89F7D3,ZTEGD70A24B9$ZTE3ANNRCP46872,6C11BA6D755F,6C11BA6D7560,ZTEGDC6FF7AB$ZTE3ANNT3H17838,D831399865AC,D831399865AD,ZTEGDD32164D$ZTE3ANNQ4A00430,3CF9F0AA025A,3CF9F0AA025B,ZTEGD641406D$ZTE3ANNT4P40145,F00C514F5384,F00C514F5385,ZTEGDE349367$ZTE3ANNT2V49430,D8313990155C,D8313990155D,ZTEGDD30B395$ZTE3ANNR3Y01366,4896D94FE0BC,4896D94FE0BD,ZTEGD97E360B$ZTE3ANNT4P16984,F00C514D34AE,F00C514D34AF,ZTEGDE3438EE$ZTE3ANNQ9J07834,843C992C88D1,843C992C88D2,ZTEGD7BB2745$ZTE3ANNR3J04261,F4E84F86B23E,F4E84F86B23F,ZTEGD97B726F$ZTE3ANNRC530771,6C11BA64FB09,6C11BA64FB0A,ZTEGDC6E8DF2$ZTE3ANNQ9J15474,843C992D3BE1,843C992D3BE2,ZTEGD7BB451D$ZTE3ANNQ9J21845,843C992DD133,843C992DD134,ZTEGD7BB5E00$ZTE3ANNQ8111646,689E29BCEFBF,689E29BCEFC0,ZTEGD7B7680E$ZTE3ANNR3Y27611,4896D95247DA,4896D95247DB,ZTEGD97E9C90$ZTE3ANNQCA03387,14CA56D2943D,14CA56D2943E,ZTEGD97172A6$ZTE3ANNQ4A00609,3CF9F0AA068C,3CF9F0AA068D,ZTEGD6414120$ZTE3ANNQ9J41947,843C992FA857,843C992FA858,ZTEGD7BBAC86$ZTE3ANNR7B15326,3891484A53DB,3891484A53DC,ZTEGDB07CD3E$ZTE3ANNQ6307291,3CF9F0704F0D,3CF9F0704F0E,ZTEGD52E5312$ZTE3ANNR8C28203,389148511C09,389148511C0A,ZTEGDB08EE9B$ZTE3ANNQ9J21773,843C992DCF83,843C992DCF84,ZTEGD7BB5DB8$ZTE3ANNR8C09206,3891484F5ECB,3891484F5ECC,ZTEGDB08A466$ZTE3ANNRB708766,5872C98F06A5,5872C98F06A6,ZTEGDC614D11$ZTE3ANNRAM61832,5872C98CE169,5872C98CE16A,ZTEGDC60F187$ZTE3ANNRCB03463,D831391E2028,D831391E2029,ZTEGDD29C31C$ZTE3ANNQ8M18373,843C99207689,843C9920768A,ZTEGD7BA8F32$ZTE3ANNRB705526,5872C98EBAB5,5872C98EBAB6,ZTEGDC614069$ZTE3ANNQ5N16789,3CF9F0AE4EF4,3CF9F0AE4EF5,ZTEGD641F7DC$ZTE3ANNQCA03578,14CA56D298B7,14CA56D298B8,ZTEGD9717365$ZTE3ANNR7B32278,3891484BE12B,3891484BE12C,ZTEGDB080F76$ZTE3ANNR8C09222,3891484F5F2B,3891484F5F2C,ZTEGDB08A476', '',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-06 10:06:52 Duration: 3s830ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (60249, 407, 'ZTE3A8TT3305984,142004533082$ZTE3A8TRB719022,7C7D21EC2BCB$ZTE3A8TRB719411,7C7D21EC31DF$ZTE3A8TT4X13312,14200459DCC2$ZTE3A8TR7917153,E44E12B1F115$ZTE3A8TT4X16649,1420045A10E6$ZTE3A8TT4723625,14200458EF76$ZTE3A8TT4723911,14200458F3EE$ZTE3A8TT7P18853,C492D94673EB$ZTE3A8TR6D11573,E44E12B00B75$ZTE3A8TT3304016,1420045311C2$ZTE3A8TR8U05620,B47CA6080872$ZTE3A8TT3307633,142004534A46$ZTE3A8TT4X15907,1420045A054E$ZTE3A8TR7919121,E44E12B20FD5$ZTE3A8TR7922191,E44E12B23FCD$ZTE3A8TQCH14011,DC5193D965F2$ZTE3A8TT7P06102,C492D945ACAF$ZTE3A8TT4723652,14200458EFE2$ZTE3A8TT7P16656,C492D9465197$ZTE3A8TT4723413,14200458EC26$ZTE3A8TT4724992,1420045904D2$ZTE3A8TT3C14130,142004553E3A$ZTE3A8TT4X12878,14200459D5FA$ZTE3A8TT4723682,14200458F05A$ZTE3A8TT7P18571,C492D9466F83$ZTE3A8TT3305892,142004532F12$ZTE3A8TR7R11261,E44E12B32375$ZTE3A8TT3305911,142004532F5E$ZTE3A8TT4724457,14200458FC76$ZTE3A8TT3C20382,142004559FEA$ZTE3A8TT7P18558,C492D9466F4F$ZTE3A8TR7919271,E44E12B2122D$ZTE3A8TT7P18406,C492D9466CEF$ZTE3A8TR4H13850,38165A47FC58$ZTE3A8TT7P16650,C492D946517F$ZTE3A8TT3303860,142004530F52$ZTE3A8TT4X15780,1420045A0352$ZTE3A8TT7P18607,C492D9467013$ZTE3A8TT4X17756,1420045A2232$ZTE3A8TR4X19896,38165A49E940$ZTE3A8TR4H13931,38165A47FD9C$ZTE3A8TT4X13299,14200459DC8E', '',05,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-06 10:37:56 Duration: 3s685ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 4 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Oct 06 14 1 0ms 0ms 18 1 0ms 0ms 20 2 0ms 0ms [ User: intelifix - Total duration: 18s911ms - Times executed: 3 ]
[ User: lenon - Total duration: 354ms - Times executed: 1 ]
[ Application: psql - Total duration: 18s911ms - Times executed: 3 ]
[ Application: [unknown] - Total duration: 354ms - Times executed: 1 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 17,778 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 21 FATAL entries
- 5126 ERROR entries
- 0 WARNING entries
- 4 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 5,090 Max number of times the same event was reported
- 5,151 Total events found
Rank Times reported Error 1 5,090 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Oct 06 00 118 01 120 02 120 03 108 04 120 05 118 06 120 07 187 08 330 09 409 10 433 11 404 12 222 13 236 14 407 15 382 16 334 17 226 18 118 19 120 20 118 21 120 22 120 23 100 - ERROR: prepared statement "_PLAN0000000029A35F60" does not exist
- ERROR: prepared statement "_PLAN0000000029EFBF40" does not exist
- ERROR: prepared statement "_PLAN0000000029F00840" does not exist
Statement: DEALLOCATE "_PLAN0000000029A35F60"
Date: 2026-10-06 00:00:41 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029EFBF40"
Date: 2026-10-06 00:00:41 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029F00840"
Date: 2026-10-06 00:01:42 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 12 ERROR: function rs_lote_manutencao_itens(...) does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Oct 06 14 7 15 3 16 1 17 1 - ERROR: function rs_lote_manutencao_itens(integer, integer, unknown, unknown, integer, integer, unknown, unknown, unknown, bigint) does not exist at character 15
- ERROR: function rs_lote_manutencao_itens(integer, integer, unknown, unknown, integer, integer, unknown, unknown, unknown, bigint) does not exist at character 15
- ERROR: function rs_lote_manutencao_itens(integer, integer, unknown, unknown, integer, integer, unknown, unknown, unknown, bigint) 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_LOTE_MANUTENCAO_ITENS(139591,399,'833500603616769,241758323336,DC97E6B6E328$83350060852513D,241786625054,DC97E6BCBFDC$833500607519979,241783265063,DC97E6BADBAD$833500608525167,241786624650,DC97E6BCBFEE$83350052720030B,241721364858,DC97E6ABD0BB$833500607519957,241783265164,DC97E6BADB9B$83350060752072C,241783270721,DC97E6BADCE2$83350061800401C,241797240109,DC97E6C1E96E$83350052810551A,241723062241,DC97E6ACCC85$83350052650551C,241720483751,DC97E6AB025A','',0334,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":""}]','$$$$$$$$$','',0241786625054);Date: 2026-10-06 14:04:59 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(139591,399,'833500603616769,241758323336,DC97E6B6E328$83350060852513D,241786625054,DC97E6BCBFDC$833500607519979,241783265063,DC97E6BADBAD$833500608525167,241786624650,DC97E6BCBFEE$83350052720030B,241721364858,DC97E6ABD0BB$833500607519957,241783265164,DC97E6BADB9B$83350060752072C,241783270721,DC97E6BADCE2$83350061800401C,241797240109,DC97E6C1E96E$83350052810551A,241723062241,DC97E6ACCC85$83350052650551C,241720483751,DC97E6AB025A','',0334,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":""}]','$$$$$$$$$','',0241786625054);Date: 2026-10-06 14:05:24 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(139654,401,'835099915004254,241667677070$834201929001162,241616265566$835239935005157,241709811318$834033905000074,230040257676$836073911001036,241733015759$835091914000437,241664943437$835066910001305,241658333847$834282941001572,241631019913$834121918001402,241598131025$834218932000758,241619343656$835195929001615,241694491933$835314946001132,241715515353$834158923003705,241606063841$835091914000150,241664915454$834033905000084,230040258383$836073911000079,241732922238$834201929001236,241616273446$835165924000394,241688683139$835244936003163,241710895576$835170925000012,241691408387','',0321,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','',0241667677070);Date: 2026-10-06 14:30:38 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
3 10 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count Oct 06 00 2 06 3 10 1 13 1 18 1 21 1 23 1 - FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-10-06 00:40:58 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-06 00:42:36 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-06 06:24:43 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
4 9 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #4
Day Hour Count Oct 06 03 9 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-10-06 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-06 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-06 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
5 7 ERROR: spiexceptions.UndefinedColumn: record "..." has no field "..."
Times Reported Most Frequent Error / Event #5
Day Hour Count Oct 06 10 6 11 1 - ERROR: spiexceptions.UndefinedColumn: record "rec" has no field "row_num"
- ERROR: spiexceptions.UndefinedColumn: record "rec" has no field "row_num"
- ERROR: spiexceptions.UndefinedColumn: record "rec" has no field "row_num"
Context: Traceback (most recent call last): PL/Python function "rs_fast_excel", line 135, in <module> rows = dados.fetch(1000) PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM rs_exclui_seriais(''/var/www/html/uploads/NAtlas_Relatorio_Posicao_Equipamento_20261006_103047.xls'') ;' , '/var/www/html/tmp/temp_83.xlsx' )Date: 2026-10-06 10:32:10 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Context: Traceback (most recent call last): PL/Python function "rs_fast_excel", line 135, in <module> rows = dados.fetch(1000) PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM rs_exclui_seriais(''/var/www/html/uploads/NAtlas_Relatorio_Posicao_Equipamento_20261006_103047.xls'') ;' , '/var/www/html/tmp/temp_83.xlsx' )Date: 2026-10-06 10:32:18 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Context: Traceback (most recent call last): PL/Python function "rs_fast_excel", line 135, in <module> rows = dados.fetch(1000) PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM rs_exclui_seriais(''/var/www/html/uploads/NAtlas_Relatorio_Posicao_Equipamento_20261006_103047.xls'') ;' , '/var/www/html/tmp/temp_83.xlsx' )Date: 2026-10-06 10:32:23 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
6 7 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #6
Day Hour Count Oct 06 10 1 13 6 - ERROR: syntax error at or near ""},{"" at character 81
- ERROR: syntax error at or near "518094149303" at character 32
- ERROR: syntax error at or near "518094149303" at character 71
Statement: SELECT * FROM RS_LOTE_CONSISTE_SERIAL( '{"lote":"139637","seriais":[{"serial":"'"},{"serial":"ACD75BB7DC95"}]}')
Date: 2026-10-06 10:03:22 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT RS_SERIAL_TEMPORARIO( ''518094149303' ) OR RS_SERIAL_TEMPORARIO_VIVO( ''518094149303' )
Date: 2026-10-06 13:42:40 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_CASA_MASCARAS('{"modelo":"42","seriais":[{"serial":"'518094149303"},{"serial":""}]}');
Date: 2026-10-06 13:42:43 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
7 5 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #7
Day Hour Count Oct 06 09 1 14 2 16 2 - ERROR: trailing junk after numeric literal at or near "8401125F34B4" at character 79
- ERROR: trailing junk after numeric literal at or near "4829524597BB" at character 27
- ERROR: trailing junk after numeric literal at or near "4829524597BB" at character 27
Statement: SELECT RS_SERIAL_TEMPORARIO( '8401125F34B4'' ) OR RS_SERIAL_TEMPORARIO_VIVO( '8401125F34B4'' )
Date: 2026-10-06 09:36:48 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: select * from rs_caixa_qr(4829524597BB)
Date: 2026-10-06 14:28:13 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(4829524597BB)
Date: 2026-10-06 14:28:13 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
8 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #8
Day Hour Count Oct 06 05 4 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-06 05:32:05 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-06 05:32:05 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-06 05:32:05 Database: contagem Application: psql User: intelifix Remote: [local]
9 3 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #9
Day Hour Count Oct 06 09 3 - LOG: process 2135289 still waiting for ShareLock on transaction 7304958 after 1000.167 ms
- LOG: process 2135289 still waiting for ShareLock on transaction 7304958 after 6683.773 ms
- LOG: process 2135289 still waiting for ShareLock on transaction 7304958 after 88341.023 ms
Detail: Process holding the lock: 2131757. Wait queue: 2135289.
Context: while updating tuple (82008,101) 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,boolean) line 139 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-10-06 09:35:09 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 2131757. Wait queue: 2135289.
Context: while updating tuple (82008,101) 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,boolean) line 139 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-10-06 09:35:14 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 2131757. Wait queue: 2135289.
Context: while updating tuple (82008,101) 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,boolean) line 139 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-10-06 09:36:36 Database: rio Application: psql User: intelifix Remote: [local]
10 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #10
Day Hour Count Oct 06 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-10-06 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-06 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
11 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #11
Day Hour Count Oct 06 03 1 - LOG: database system was shut down at 2026-10-06 03:05:01 -03
Date: 2026-10-06 03:05:01
12 1 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #12
Day Hour Count Oct 06 14 1 - ERROR: column i.men_id does not exist at character 1163
Hint: Perhaps you meant to reference the column "i.nem_id" or the column "i.nea_id".
Statement: SELECT A.LOT_NOTAFISCAL,E.CLI_NOME,D.MOD_NOME,B.LI_DATA,B.EQ_ID,D.MOD_LEGADO,B.LI_ID, B.LI_OBS,B.CAI_ID, D.MOD_OBS, D.MOD_LEGADO, B.FLU_ID, F.FLU_CRIACAO, F.FLU_STATUS, H.USU_NOME , K.LC_ID, L.ACE_SERIE, B.LI_DATAHORA, M.USU_NOME USU_ENTRADA,I.NEM_id FROM LOTES A INNER JOIN LOTE_ITENS B ON B.LOT_ID = A.LOT_ID INNER JOIN EQUIPAMENTOS C ON C.EQ_ID = B.EQ_ID INNER JOIN MODELOS D ON D.MOD_ID = C.MOD_ID INNER JOIN CLIENTES E ON E.CLI_ID = A.CLI_ID LEFT JOIN FLUXOS F ON F.FLU_ID = B.FLU_ID LEFT JOIN TECNICOS G ON G.TEC_ID = F.TEC_ID LEFT JOIN USUARIOS H ON H.USU_ID = G.USU_ID LEFT JOIN NF_ENTRADA_ITENS I ON I.LI_ID = B.LI_ID LEFT JOIN NF_ENTRADA_MODELOS J ON J.NEM_ID = I.NEM_ID AND COALESCE( J.MOD_ID , 0 ) = A.MOD_ID LEFT JOIN NF_ENTRADA K ON K.NF_ID = J.NF_ID LEFT JOIN ACESSORIOS L ON L.ACE_ID = B.ACE_ID INNER JOIN USUARIOS M ON M.USU_ID = B.USU_ID WHERE A.OFI_ID = 2 AND A.CLI_ID = 1 AND A.LOT_NOTAFISCAL = '11854' AND ( J.MOD_ID IS NOT NULL OR I.MEN_ID IS NULL )Date: 2026-10-06 14:21:42 Database: contagem Application: pgAdmin 4 - CONN:8072475 User: lenon Remote: 172.20.0.3