pgBadger-
Global information
- Generated on Tue Jul 28 23:50:10 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 39,171 log entries in 8s
- Log start from 2026-07-28 00:00:08 to 2026-07-28 23:45:45
-
Overview
Global Stats
- 374 Number of unique normalized queries
- 5,911 Number of queries
- 8h32m8s Total query duration
- 2026-07-28 00:02:31 First query
- 2026-07-28 23:45:45 Last query
- 5 queries/s at 2026-07-28 10:18:32 Query peak
- 8h32m8s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 8h32m8s Execute total duration
- 3,557 Number of events
- 19 Number of unique normalized events
- 3,340 Max number of times the same event was reported
- 0 Number of cancellation
- 384 Total number of automatic vacuums
- 888 Total number of automatic analyzes
- 14 Number temporary file
- 237.30 MiB Max size of temporary file
- 108.53 MiB Average size of temporary file
- 353 Total number of sessions
- 8 sessions at 2026-07-28 13:35:31 Session peak
- 13d1h27m52s Total duration of sessions
- 53m16s Average duration of sessions
- 16 Average queries per session
- 1m27s Average queries duration per session
- 51m49s Average idle time per session
- 361 Total number of connections
- 4 connections/s at 2026-07-28 03:05:17 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-07-28 10:18:32 Date
SELECT Traffic
Key values
- 5 queries/s Query Peak
- 2026-07-28 10:18:32 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-07-28 23:45:18 Date
Queries duration
Key values
- 8h32m8s 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) Jul 28 00 27 0ms 28s825ms 5s203ms 4s669ms 5s978ms 1m17s 01 18 0ms 3s627ms 1s632ms 3s732ms 5s483ms 6s39ms 02 17 0ms 3s432ms 1s624ms 3s306ms 4s445ms 6s402ms 03 18 0ms 3s702ms 1s583ms 3s686ms 4s499ms 6s918ms 04 22 0ms 4s198ms 1s489ms 4s252ms 5s110ms 6s340ms 05 40 0ms 8m47s 27s1ms 10s390ms 2m21s 8m48s 06 26 0ms 37s864ms 4s817ms 3s730ms 28s503ms 37s864ms 07 165 0ms 7m33s 8s594ms 35s70ms 3m51s 7m33s 08 512 0ms 6m58s 4s61ms 44s929ms 4m51s 7m54s 09 618 150ms 8m52s 4s278ms 1m17s 4m47s 10m2s 10 613 150ms 8m22s 4s435ms 1m34s 5m8s 8m24s 11 512 150ms 8m6s 5s802ms 4m40s 6m22s 9m26s 12 143 0ms 7m1s 9s807ms 39s658ms 3m54s 7m45s 13 392 0ms 7m18s 3s12ms 22s51ms 1m12s 7m18s 14 482 150ms 7m28s 4s347ms 1m1s 5m4s 7m40s 15 586 0ms 8m22s 5s180ms 4m56s 6m21s 8m28s 16 655 150ms 8m21s 3s463ms 1m12s 4m24s 8m32s 17 513 0ms 8m15s 3s148ms 42s838ms 1m41s 8m48s 18 22 0ms 5m43s 27s944ms 3m16s 5m43s 5m43s 19 21 0ms 5m44s 29s495ms 3m23s 5m44s 5m44s 20 112 0ms 5m44s 10s558ms 1m50s 3m44s 6m35s 21 36 0ms 5m49s 18s38ms 3m41s 5m50s 5m50s 22 29 0ms 5m40s 21s850ms 3m32s 5m40s 5m40s 23 332 0ms 1m27s 6s429ms 1m9s 1m21s 1m27s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 28 00 5 0 7s550ms 0ms 0ms 1s177ms 01 0 0 0ms 0ms 0ms 0ms 02 1 0 169ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 4 0 323ms 0ms 0ms 256ms 05 21 0 248ms 156ms 340ms 1s59ms 06 9 0 4s475ms 0ms 0ms 2s36ms 07 109 0 10s737ms 3s146ms 14s297ms 5m13s 08 378 0 4s170ms 6s895ms 12s565ms 4m52s 09 483 0 4s417ms 14s735ms 1m11s 8m58s 10 490 0 4s754ms 25s146ms 1m17s 6m19s 11 367 0 7s72ms 9s115ms 4m39s 8m8s 12 85 0 14s399ms 2s457ms 39s322ms 5m8s 13 305 0 3s513ms 8s811ms 18s252ms 4m5s 14 381 0 4s725ms 11s4ms 27s514ms 5m43s 15 409 0 6s307ms 15s845ms 4m55s 6m40s 16 510 0 3s631ms 18s20ms 1m10s 4m58s 17 325 0 3s572ms 8s299ms 26s823ms 8m42s 18 7 0 1m24s 1s506ms 3m16s 5m43s 19 6 0 1m38s 45s892ms 3m23s 5m44s 20 9 88 11s862ms 1m7s 1m50s 5m45s 21 15 0 40s884ms 1s55ms 3m35s 5m50s 22 8 0 1m14s 883ms 3m32s 5m40s 23 8 324 6s429ms 1m4s 1m9s 1m27s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 28 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 Jul 28 00 0 1 1.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 1 1.00 0.00% 05 0 2 2.00 0.00% 06 0 2 2.00 0.00% 07 0 9 9.00 0.00% 08 0 11 11.00 0.00% 09 0 14 14.00 0.00% 10 0 14 14.00 0.00% 11 0 11 11.00 0.00% 12 0 8 8.00 0.00% 13 0 12 12.00 0.00% 14 0 10 10.00 0.00% 15 0 15 15.00 0.00% 16 0 13 13.00 0.00% 17 0 8 8.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 3 3.00 0.00% 22 0 1 1.00 0.00% 23 0 1 1.00 0.00% Day Hour Count Average / Second Jul 28 00 16 0.00/s 01 8 0.00/s 02 9 0.00/s 03 18 0.01/s 04 9 0.00/s 05 8 0.00/s 06 14 0.00/s 07 16 0.00/s 08 22 0.01/s 09 22 0.01/s 10 23 0.01/s 11 21 0.01/s 12 15 0.00/s 13 20 0.01/s 14 20 0.01/s 15 22 0.01/s 16 21 0.01/s 17 15 0.00/s 18 7 0.00/s 19 7 0.00/s 20 11 0.00/s 21 11 0.00/s 22 11 0.00/s 23 15 0.00/s Day Hour Count Average Duration Average idle time Jul 28 00 8 1h25s 1h8s 01 15 1h58s 1h57s 02 8 1h 59m56s 03 20 20m42s 20m41s 04 7 1h3m 1h2m55s 05 8 1h22s 58m7s 06 9 57m9s 56m55s 07 14 57m5s 55m23s 08 16 55m9s 52m59s 09 26 49m38s 47m56s 10 19 57m3s 54m40s 11 21 58m11s 55m49s 12 22 53m44s 52m41s 13 15 54m6s 52m47s 14 18 59m24s 57m28s 15 20 55m6s 52m34s 16 22 56m55s 55m12s 17 23 53m31s 52m21s 18 12 1h2s 59m11s 19 8 53m45s 52m28s 20 9 41m57s 39m46s 21 9 54m47s 53m35s 22 10 1h36s 59m32s 23 14 37m16s 34m43s -
Connections
Established Connections
Key values
- 4 connections Connection Peak
- 2026-07-28 03:05:17 Date
Connections per database
Key values
- rio Main Database
- 361 connections Total
Connections per user
Key values
- intelifix Main User
- 361 connections Total
-
Sessions
Simultaneous sessions
Key values
- 8 sessions Session Peak
- 2026-07-28 13:35:31 Date
Histogram of session times
Key values
- 286 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 353 sessions Total
Sessions per user
Key values
- intelifix Main User
- 353 sessions Total
Sessions per host
Key values
- [local] Main Host
- 353 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 80,214 buffers Checkpoint Peak
- 2026-07-28 00:09:42 Date
- 270.007 seconds Highest write time
- 0.362 seconds Sync time
Checkpoints Wal files
Key values
- 12 files Wal files usage Peak
- 2026-07-28 12:44:38 Date
Checkpoints distance
Key values
- 398.40 Mo Distance Peak
- 2026-07-28 12:44:38 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 28 00 97,030 691.514s 0.032s 691.609s 01 2,159 216.869s 0.028s 216.937s 02 1,440 144.769s 0.028s 144.834s 03 1,255 126.367s 0.032s 126.447s 04 2,093 210.108s 0.029s 210.184s 05 9,676 931.436s 0.075s 931.583s 06 8,150 539.222s 0.013s 539.255s 07 18,826 1,526.777s 0.158s 1,527.045s 08 50,203 3,013.933s 0.556s 3,014.701s 09 81,648 3,238.668s 0.824s 3,239.744s 10 63,940 3,213.841s 0.627s 3,214.667s 11 82,234 3,214.854s 0.633s 3,215.708s 12 58,017 2,402.066s 0.715s 2,402.949s 13 42,102 2,885.084s 0.517s 2,885.784s 14 64,385 3,239.053s 0.592s 3,239.845s 15 78,245 3,184.011s 0.749s 3,184.989s 16 62,926 3,238.407s 0.692s 3,239.328s 17 24,444 1,983.907s 0.489s 1,984.557s 18 1,888 189.358s 0.016s 189.404s 19 37 3.754s 0.007s 3.781s 20 1,033 118.029s 0.034s 118.081s 21 2,721 273.233s 0.037s 273.349s 22 1,779 178.779s 0.027s 178.853s 23 552 55.489s 0.013s 55.539s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 28 00 0 0 12 482 0.003s 0.006s 01 0 0 1 443 0.003s 0.006s 02 0 0 0 391 0.003s 0.006s 03 0 0 1 404 0.003s 0.006s 04 0 0 1 447 0.002s 0.007s 05 0 0 4 720 0.008s 0.007s 06 0 0 1 95 0.002s 0.002s 07 0 0 17 2,030 0.004s 0.012s 08 0 0 37 5,555 0.006s 0.012s 09 0 0 48 6,920 0.010s 0.012s 10 0 0 32 6,516 0.007s 0.012s 11 0 0 45 6,138 0.016s 0.012s 12 0 0 35 3,675 0.337s 0.013s 13 0 0 17 5,234 0.013s 0.012s 14 0 0 29 6,204 0.005s 0.012s 15 0 0 46 6,492 0.019s 0.012s 16 0 0 44 6,425 0.038s 0.012s 17 0 0 31 4,535 0.004s 0.01s 18 0 0 1 303 0.003s 0.005s 19 0 0 0 12 0.002s 0.004s 20 0 0 1 90 0.005s 0.003s 21 0 0 1 461 0.003s 0.009s 22 0 0 0 502 0.003s 0.008s 23 0 0 0 97 0.002s 0.006s Day Hour Count Avg time (sec) Jul 28 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 Jul 28 00 34,100.67 kB 98,488.00 kB 01 1,882.67 kB 54,003.50 kB 02 1,223.50 kB 29,329.33 kB 03 956.43 kB 4,271.43 kB 04 1,553.57 kB 2,635.71 kB 05 9,545.29 kB 18,410.43 kB 06 14,578.00 kB 18,743.00 kB 07 23,113.00 kB 41,430.83 kB 08 50,010.08 kB 87,909.33 kB 09 65,922.67 kB 101,168.83 kB 10 43,864.92 kB 81,601.08 kB 11 61,344.83 kB 128,554.25 kB 12 47,409.08 kB 151,254.25 kB 13 23,177.17 kB 91,435.08 kB 14 39,485.25 kB 61,025.75 kB 15 62,486.75 kB 116,952.67 kB 16 61,147.00 kB 105,789.50 kB 17 50,808.70 kB 89,386.60 kB 18 1,587.40 kB 49,875.20 kB 19 73.00 kB 32,705.33 kB 20 5,206.33 kB 25,149.00 kB 21 1,468.78 kB 14,436.33 kB 22 1,156.75 kB 6,643.88 kB 23 239.50 kB 3,468.17 kB -
Temporary Files
Size of temporary files
Key values
- 474.61 MiB Temp Files size Peak
- 2026-07-28 05:31:57 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-07-28 05:31:57 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 28 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 10 1.08 GiB 110.34 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 0 0 0 12 1 104.00 MiB 104.00 MiB 13 0 0 0 14 0 0 0 15 0 0 0 16 2 208.00 MiB 104.00 MiB 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 8 921.93 MiB 70.78 MiB 237.30 MiB 115.24 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-28 05:32:05 Duration: 1m25s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-28 05:31:57 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 4 416.00 MiB 104.00 MiB 104.00 MiB 104.00 MiB select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-07-01''),DATE(''2026-07-27'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-07-28 15:42:46 Duration: 6m17s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027695, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-28 10:25:24 Duration: 6m12s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027704, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');
Date: 2026-07-28 11:37:22 Duration: 6m5s Database: rio User: intelifix Remote: [local] Application: [unknown]
3 2 181.42 MiB 90.71 MiB 90.71 MiB 90.71 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-28 05:30:40 Duration: 38s472ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-28 05:30:36 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 237.30 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-28 05:31:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 237.30 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-28 05:31:57 - 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-07-28 16:24:17 - 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-07-28 16:51:39 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 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-07-28 09:43:26 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
6 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-07-28 12:07:56 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
7 90.71 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-28 05:30:36 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 90.71 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-28 05:30:36 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 78.35 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-28 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 78.27 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-28 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 78.27 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-28 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 70.85 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-28 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 70.79 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-28 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 70.78 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-28 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 45.93 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_07
Database rio - 2026-07-28 12:39:55 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 45.93 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_07
Database rio - 2026-07-28 12:39:55 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (110) Main table analyzed (database rio)
- 888 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 110 rio.pg_catalog.pg_class 59 rio.public.usuarios 50 brasilia.pg_catalog.pg_attribute 49 rio.public.temp0000286664 49 rio.pg_catalog.pg_type 48 rio.pg_catalog.pg_index 33 contagem.public.usuarios 28 rio.public.temp0000286660 23 rio.pg_catalog.pg_depend 23 rio.public.temp0000286672 22 rio.public.temp0000286572 22 brasilia.pg_catalog.pg_class 22 brasilia.pg_catalog.pg_type 18 rio.public.temp0000286750 17 rio.public.temp0000286684 16 contagem.pg_catalog.pg_attribute 16 rio.public.temp0000286666 15 brasilia.public.temp0000237016 14 rio.public.temp0000286690 14 rio.public.temp0000286776 14 rio.public.temp0000285404 14 brasilia.pg_catalog.pg_index 13 rio.public.temp0000286662 12 rio.public.temp0000286708 11 brasilia.pg_catalog.pg_depend 8 brasilia.public.usuarios 8 rio.public.temp0000286112 7 rio.public.temp0000286518 7 brasilia.public.temp0000237008 6 contagem.pg_catalog.pg_class 6 rio.public.temp0000286682 6 rio.public.temp0000286746 6 rio.public.temp0000286536 5 contagem.pg_catalog.pg_type 5 rio.public.temp0000286494 5 rio.public.temp0000286712 5 rio.public.temp0000286652 5 rio.public.temp0000286702 4 rio.public.temp0000286766 4 brasilia.public.temp0000236962 3 rio.public.temp0000286680 3 contagem.pg_catalog.pg_index 3 rio.public.temp0000286714 3 rio.public.temp0000286728 3 rio.public.temp0000286734 3 rio.public.temp0000286760 3 brasilia.public.nf_entrada 3 rio.public.tmp_drill_0302 3 brasilia.pg_catalog.pg_shdepend 2 rio.public.tmp_drill_0175 2 rio.public.temp0000286778 2 brasilia.public.temp0000237024 2 brasilia.public.temp0000237032 2 rio.public.temp0000286772 2 contagem.pg_catalog.pg_depend 2 rio.public.temp0000286654 2 template1.pg_catalog.pg_shdepend 2 postgres.pg_catalog.pg_shdepend 2 contagem.pg_catalog.pg_shdepend 2 brasilia.public.temp0000236976 2 brasilia.public.temp0000237018 2 brasilia.public.temp0000236974 2 rio.pg_catalog.pg_shdepend 2 rio.public.temp0000286698 1 brasilia.public.temp0000236970 1 brasilia.public.temp0000236960 1 rio.public.temp0000286780 1 rio.public.temp0000286744 1 brasilia.public.temp0000236988 1 rio.public.temp0000286754 1 rio.public.temp0000286696 1 rio.public.temp0000286674 1 rio.public.temp0000286774 1 contagem.public.temp0000226620 1 rio.public.temp0000286758 1 rio.public.temp0000286670 1 rio.public.temp0000286742 1 rio.public.temp0000286692 1 brasilia.public.temp0000237046 1 rio.public.temp0000286630 1 brasilia.public.temp0000237030 1 rio.public.temp0000286784 1 brasilia.public.temp0000236992 1 contagem.public.temp0000226704 1 rio.public.temp0000286752 1 brasilia.public.temp0000237044 1 rio.public.temp0000286740 1 brasilia.public.temp0000236968 1 rio.public.temp0000286732 1 rio.public.temp0000286658 1 contagem.public.temp0000226698 1 brasilia.public.temp0000237042 1 rio.public.temp0000286756 1 brasilia.public.temp0000236964 1 rio.public.temp0000286688 1 Total 888 Vacuums per table
Key values
- public.temp0000286664 (50) Main table vacuumed on database rio
- 384 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.public.temp0000286664 50 0 0 0 0 0 0 40,404 5,879 9,839,869 0 0 rio.pg_catalog.pg_attribute 38 38 0 0 0 0 0 20,639 5,971 8,616,955 364 8,342 contagem.public.usuarios 26 0 0 0 0 0 0 138 108 50,697 0 0 rio.pg_catalog.pg_class 23 21 0 0 0 0 0 4,060 1,471 2,201,417 84 325 rio.pg_catalog.pg_type 18 18 0 0 0 0 0 1,959 671 843,634 91 314 brasilia.pg_catalog.pg_attribute 16 16 0 0 0 0 0 8,782 1,706 3,087,771 73 1,547 rio.public.temp0000286776 13 0 0 0 0 0 0 2,706 216 427,015 0 0 rio.pg_catalog.pg_index 12 12 0 0 0 0 0 886 259 215,127 55 143 rio.public.temp0000286684 11 0 0 0 0 0 0 894 325 519,305 0 0 rio.public.temp0000285404 11 0 0 0 0 0 0 565 298 448,266 0 0 rio.public.temp0000286708 10 0 0 0 0 0 0 10,134 1,720 2,770,335 0 0 rio.public.usuarios 9 6 0 0 0 0 0 193 71 165,286 20 59 rio.pg_catalog.pg_depend 8 8 0 0 0 0 0 2,754 1,029 1,294,234 72 568 rio.public.temp0000286112 7 0 0 0 0 0 0 132 37 13,511 0 0 rio.pg_catalog.pg_statistic 7 7 0 0 0 0 0 9,165 1,822 8,067,115 880 3,821 brasilia.pg_catalog.pg_type 7 7 0 0 0 0 0 645 181 286,209 15 44 brasilia.pg_catalog.pg_class 7 7 0 0 0 0 0 1,487 409 699,646 22 75 postgres.pg_catalog.pg_shdepend 6 6 0 0 0 0 0 868 286 440,882 45 105 rio.public.temp0000286750 6 0 0 0 0 0 0 2,163 118 309,276 0 0 rio.public.temp0000286746 6 0 0 0 0 0 0 6,848 1,710 2,576,118 0 0 rio.public.temp0000286712 5 0 0 0 0 0 0 5,068 1,703 2,469,355 0 0 brasilia.public.temp0000237008 5 0 0 0 0 0 0 1,221 30 77,728 0 0 rio.public.tmp_drill_0302 5 3 0 0 0 0 0 300 148 169,004 2 122 contagem.pg_catalog.pg_attribute 5 5 0 0 0 0 0 2,582 852 1,453,547 4 112 rio.public.temp0000286682 5 0 0 0 0 0 0 421 370 614,021 0 0 brasilia.pg_catalog.pg_index 4 4 0 0 0 0 0 224 39 51,658 14 22 rio.public.temp0000286702 4 0 0 0 0 0 0 6,746 16 400,426 0 0 brasilia.pg_catalog.pg_depend 4 4 0 0 0 0 0 1,152 343 562,969 13 109 rio.public.temp0000286572 4 0 0 0 0 0 0 309 154 249,379 0 0 rio.public.temp0000286680 3 0 0 0 0 0 0 256 94 169,510 0 0 rio.pg_toast.pg_toast_2619 3 3 0 0 0 0 0 1,767 356 2,047,525 138 441 rio.public.temp0000286714 3 0 0 0 0 0 0 1,695 11 102,268 0 0 rio.public.temp0000286766 3 0 0 0 0 0 0 5,064 12 300,585 0 0 brasilia.public.temp0000237024 2 0 0 0 0 0 0 490 12 31,222 0 0 rio.public.temp0000286778 2 0 0 0 0 0 0 3,376 1,692 2,366,843 0 0 rio.public.tmp_drill_0175 2 2 0 0 0 0 0 89 6 20,043 0 0 rio.public.temp0000286690 2 0 0 0 0 0 0 152 12 10,709 0 0 rio.public.temp0000286728 2 0 0 0 0 0 0 3,374 8 200,272 0 0 brasilia.pg_catalog.pg_statistic 2 2 0 0 0 0 0 3,380 355 1,590,172 270 2,379 rio.public.temp0000286734 2 0 0 0 0 0 0 3,374 8 200,272 0 0 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 356 65 243,028 22 45 rio.public.temp0000286696 1 0 0 0 0 0 0 83 6 5,804 0 0 rio.public.temp0000286754 1 0 0 0 0 0 0 141 6 9,288 0 0 rio.auditor.auditor_2026_07 1 0 0 0 0 0 0 196,398 137,434 171,536,196 33,474 698,896 contagem.pg_catalog.pg_index 1 1 0 0 0 0 0 49 21 11,212 0 0 brasilia.public.temp0000236962 1 0 0 0 0 0 0 37 6 2,964 0 0 rio.public.temp0000286630 1 0 0 0 0 0 0 4 4 2,677 0 0 contagem.pg_catalog.pg_type 1 1 0 0 0 0 0 84 35 46,845 0 0 brasilia.public.temp0000237030 1 0 0 0 0 0 0 244 6 15,534 0 0 rio.public.temp0000286780 1 0 0 0 0 0 0 97 6 6,658 0 0 rio.public.temp0000286772 1 0 0 0 0 0 0 92 6 6,355 0 0 rio.public.temp0000286536 1 0 0 0 0 0 0 1,689 4 100,254 0 0 rio.public.temp0000286692 1 0 0 0 0 0 0 83 6 5,804 0 0 rio.public.temp0000286688 1 0 0 0 0 0 0 8 5 1,295 0 0 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,402 641 2,121,381 606 4,369 rio.public.temp0000286774 1 0 0 0 0 0 0 8 5 1,318 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 144 35 115,422 11 27 contagem.pg_catalog.pg_shdepend 1 1 0 0 0 0 0 134 41 74,548 2 3 contagem.pg_catalog.pg_depend 1 1 0 0 0 0 0 291 117 229,054 0 0 brasilia.public.temp0000237042 1 0 0 0 0 0 0 244 6 15,534 0 0 rio.public.temp0000286670 1 0 0 0 0 0 0 8 5 1,297 0 0 rio.public.temp0000286658 1 0 0 0 0 0 0 1,686 4 100,077 0 0 contagem.pg_catalog.pg_class 1 1 0 0 0 0 0 106 40 60,837 0 0 rio.public.temp0000286494 1 0 0 0 0 0 0 8 6 3,500 0 0 rio.public.temp0000286758 1 0 0 0 0 0 0 92 6 6,354 0 0 Total 384 178 0 0 0 0 0 360,950 169,024 230,683,412 36,277 721,868 Vacuum throughput per table
Key values
- auditor.auditor_2026_07 (45.93) 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.public.temp0000286664 0 0 1.91 rio.pg_catalog.pg_attribute 0 0 2.78 contagem.public.usuarios 0 0 0.01 rio.pg_catalog.pg_class 0 0 0.68 rio.pg_catalog.pg_type 0 0 0.35 brasilia.pg_catalog.pg_attribute 0 0 1.21 rio.public.temp0000286776 0 0 0.32 rio.pg_catalog.pg_index 0 0 0.25 rio.public.temp0000286684 0 0 0.21 rio.public.temp0000285404 0 0 0.14 rio.public.temp0000286708 0 0 0.53 rio.public.usuarios 0 0 0.01 rio.pg_catalog.pg_depend 0 0 0.71 rio.public.temp0000286112 0 0 0.11 rio.pg_catalog.pg_statistic 0 0 1.18 brasilia.pg_catalog.pg_type 0 0 0.27 brasilia.pg_catalog.pg_class 0 0 0.35 postgres.pg_catalog.pg_shdepend 0 0 0.51 rio.public.temp0000286750 0 0 0.15 rio.public.temp0000286746 0 0 0.29 rio.public.temp0000286712 0 0 0.32 brasilia.public.temp0000237008 0 0 0.12 rio.public.tmp_drill_0302 0 0 0 contagem.pg_catalog.pg_attribute 0 0 0.52 rio.public.temp0000286682 0 0 0.09 brasilia.pg_catalog.pg_index 0 0 0.04 rio.public.temp0000286702 0 0 0.22 brasilia.pg_catalog.pg_depend 0 0 0.24 rio.public.temp0000286572 0 0 0.08 rio.public.temp0000286680 0 0 0.06 rio.pg_toast.pg_toast_2619 0 0 0.26 rio.public.temp0000286714 0 0 0.15 rio.public.temp0000286766 0 0 0.17 brasilia.public.temp0000237024 0 0 0.04 rio.public.temp0000286778 0 0 0.16 rio.public.tmp_drill_0175 0 0 0 rio.public.temp0000286690 0 0 0.03 rio.public.temp0000286728 0 0 0.1 brasilia.pg_catalog.pg_statistic 0 0 0.28 rio.public.temp0000286734 0 0 0.1 brasilia.pg_toast.pg_toast_2619 0 0 0.02 rio.public.temp0000286696 0 0 0.01 rio.public.temp0000286754 0 0 0.02 rio.auditor.auditor_2026_07 0 0 45.93 contagem.pg_catalog.pg_index 0 0 0.06 brasilia.public.temp0000236962 0 0 0.01 rio.public.temp0000286630 0 0 0.04 contagem.pg_catalog.pg_type 0 0 0.07 brasilia.public.temp0000237030 0 0 0.02 rio.public.temp0000286780 0 0 0.01 rio.public.temp0000286772 0 0 0.02 rio.public.temp0000286536 0 0 0.05 rio.public.temp0000286692 0 0 0.01 rio.public.temp0000286688 0 0 0 contagem.pg_catalog.pg_statistic 0 0 0.11 rio.public.temp0000286774 0 0 0.01 contagem.pg_toast.pg_toast_2619 0 0 0 contagem.pg_catalog.pg_shdepend 0 0 0.07 contagem.pg_catalog.pg_depend 0 0 0.08 brasilia.public.temp0000237042 0 0 0.01 rio.public.temp0000286670 0 0 0.02 rio.public.temp0000286658 0 0 0.05 contagem.pg_catalog.pg_class 0 0 0.07 rio.public.temp0000286494 0 0 0.02 rio.public.temp0000286758 0 0 0.02 Total 0 0 61.68 Tuples removed per table
Key values
- pg_catalog.pg_attribute (152127) Main table with removed tuples on database rio
- 400299 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 38 38 152,127 939,980 21,786 273 22,294 rio.auditor.auditor_2026_07 1 0 95,654 19,620,404 0 0 920,304 brasilia.pg_catalog.pg_attribute 16 16 74,640 360,430 0 275 8,989 contagem.pg_catalog.pg_attribute 5 5 14,838 114,969 0 0 2,640 rio.pg_catalog.pg_statistic 7 7 12,861 57,649 0 0 9,002 rio.pg_catalog.pg_depend 8 8 6,955 149,681 1,846 12 1,420 rio.pg_catalog.pg_type 18 18 6,461 41,424 298 14 1,338 brasilia.pg_catalog.pg_statistic 2 2 5,133 15,719 0 0 2,144 postgres.pg_catalog.pg_shdepend 6 6 4,362 81,501 27 0 714 contagem.pg_catalog.pg_statistic 1 1 4,166 7,274 0 0 1,011 rio.public.tmp_drill_0302 5 3 3,766 11,689 3,758 0 199 rio.pg_catalog.pg_index 12 12 3,436 23,326 280 11 697 rio.pg_catalog.pg_class 23 21 3,059 83,941 3,680 6 3,005 brasilia.pg_catalog.pg_type 7 7 2,634 15,571 48 25 442 contagem.public.usuarios 26 0 1,759 598 0 0 52 brasilia.pg_catalog.pg_depend 4 4 1,620 71,990 0 0 708 brasilia.pg_catalog.pg_index 4 4 1,526 7,514 0 9 228 rio.pg_toast.pg_toast_2619 3 3 974 2,155 1 0 783 contagem.pg_catalog.pg_shdepend 1 1 974 13,613 0 0 119 rio.public.usuarios 9 6 795 5,229 648 0 162 brasilia.pg_catalog.pg_class 7 7 773 25,799 0 14 961 contagem.pg_catalog.pg_depend 1 1 647 19,063 0 0 171 rio.public.tmp_drill_0175 2 2 423 1,115 0 0 30 brasilia.pg_toast.pg_toast_2619 2 2 218 278 0 0 134 contagem.pg_catalog.pg_class 1 1 153 3,561 0 0 131 contagem.pg_catalog.pg_type 1 1 125 2,243 0 0 62 contagem.pg_toast.pg_toast_2619 1 1 120 116 0 0 56 contagem.pg_catalog.pg_index 1 1 100 1,894 0 11 46 rio.public.temp0000286696 1 0 0 1,303 0 53 75 rio.public.temp0000286112 7 0 0 23,146 0 256 512 rio.public.temp0000286754 1 0 0 5,988 0 59 133 rio.public.temp0000286664 50 0 0 723,018 0 1,014 51,850 rio.public.temp0000286680 3 0 0 4,020 0 152 232 rio.public.temp0000286684 11 0 0 48,437 0 397 1,107 brasilia.public.temp0000236962 1 0 0 1,398 0 3 29 rio.public.temp0000286776 13 0 0 100,324 0 453 4,859 brasilia.public.temp0000237024 2 0 0 6,296 0 40 472 rio.public.temp0000286750 6 0 0 44,547 0 267 2,293 rio.public.temp0000286630 1 0 0 23,762 0 0 1,728 rio.public.temp0000286712 5 0 0 118,800 0 0 8,640 rio.public.temp0000286778 2 0 0 47,559 0 0 3,456 brasilia.public.temp0000237030 1 0 0 3,148 0 20 236 rio.public.temp0000286780 1 0 0 1,536 0 39 89 rio.public.temp0000286772 1 0 0 1,453 0 44 84 brasilia.public.temp0000237008 5 0 0 15,738 0 100 1,180 rio.public.temp0000286536 1 0 0 23,783 0 0 1,728 rio.public.temp0000286708 10 0 0 237,536 0 0 17,280 rio.public.temp0000286690 2 0 0 6,136 0 56 136 rio.public.temp0000286702 4 0 0 95,013 0 0 6,912 rio.public.temp0000286728 2 0 0 47,532 0 0 3,456 rio.public.temp0000286714 3 0 0 71,294 0 0 5,184 rio.public.temp0000286692 1 0 0 1,302 0 53 75 rio.public.temp0000286734 2 0 0 47,535 0 0 3,456 rio.public.temp0000286688 1 0 0 1,301 0 53 75 rio.public.temp0000286766 3 0 0 71,309 0 0 5,184 rio.public.temp0000286774 1 0 0 1,455 0 43 85 rio.public.temp0000286682 5 0 0 22,330 0 143 497 brasilia.public.temp0000237042 1 0 0 3,148 0 20 236 rio.public.temp0000285404 11 0 0 32,108 0 251 709 rio.public.temp0000286670 1 0 0 1,297 0 53 75 rio.public.temp0000286658 1 0 0 23,742 0 0 1,728 rio.public.temp0000286494 1 0 0 1,453 0 44 84 rio.public.temp0000286572 4 0 0 22,788 0 197 507 rio.public.temp0000286746 6 0 0 120,343 0 44 8,724 rio.public.temp0000286758 1 0 0 1,452 0 44 84 Total 384 178 400,299 23,682,056 32,372 4,548 1,111,032 Pages removed per table
Key values
- public.temp0000286664 (1014) Main table with removed pages on database rio
- 4548 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000286664 50 0 0 1014 rio.public.temp0000286776 13 0 0 453 rio.public.temp0000286684 11 0 0 397 brasilia.pg_catalog.pg_attribute 16 16 74640 275 rio.pg_catalog.pg_attribute 38 38 152127 273 rio.public.temp0000286750 6 0 0 267 rio.public.temp0000286112 7 0 0 256 rio.public.temp0000285404 11 0 0 251 rio.public.temp0000286572 4 0 0 197 rio.public.temp0000286680 3 0 0 152 rio.public.temp0000286682 5 0 0 143 brasilia.public.temp0000237008 5 0 0 100 rio.public.temp0000286754 1 0 0 59 rio.public.temp0000286690 2 0 0 56 rio.public.temp0000286696 1 0 0 53 rio.public.temp0000286692 1 0 0 53 rio.public.temp0000286688 1 0 0 53 rio.public.temp0000286670 1 0 0 53 rio.public.temp0000286772 1 0 0 44 rio.public.temp0000286494 1 0 0 44 rio.public.temp0000286746 6 0 0 44 rio.public.temp0000286758 1 0 0 44 rio.public.temp0000286774 1 0 0 43 brasilia.public.temp0000237024 2 0 0 40 rio.public.temp0000286780 1 0 0 39 brasilia.pg_catalog.pg_type 7 7 2634 25 brasilia.public.temp0000237030 1 0 0 20 brasilia.public.temp0000237042 1 0 0 20 rio.pg_catalog.pg_type 18 18 6461 14 brasilia.pg_catalog.pg_class 7 7 773 14 rio.pg_catalog.pg_depend 8 8 6955 12 rio.pg_catalog.pg_index 12 12 3436 11 contagem.pg_catalog.pg_index 1 1 100 11 brasilia.pg_catalog.pg_index 4 4 1526 9 rio.pg_catalog.pg_class 23 21 3059 6 brasilia.public.temp0000236962 1 0 0 3 rio.auditor.auditor_2026_07 1 0 95654 0 postgres.pg_catalog.pg_shdepend 6 6 4362 0 rio.pg_catalog.pg_statistic 7 7 12861 0 rio.public.temp0000286630 1 0 0 0 rio.public.temp0000286712 5 0 0 0 rio.public.temp0000286778 2 0 0 0 rio.public.tmp_drill_0175 2 2 423 0 contagem.pg_catalog.pg_type 1 1 125 0 rio.public.temp0000286536 1 0 0 0 rio.pg_toast.pg_toast_2619 3 3 974 0 rio.public.temp0000286708 10 0 0 0 rio.public.usuarios 9 6 795 0 rio.public.temp0000286702 4 0 0 0 rio.public.temp0000286728 2 0 0 0 rio.public.temp0000286714 3 0 0 0 contagem.public.usuarios 26 0 1759 0 brasilia.pg_catalog.pg_depend 4 4 1620 0 brasilia.pg_catalog.pg_statistic 2 2 5133 0 rio.public.temp0000286734 2 0 0 0 contagem.pg_catalog.pg_statistic 1 1 4166 0 rio.public.tmp_drill_0302 5 3 3766 0 rio.public.temp0000286766 3 0 0 0 contagem.pg_catalog.pg_attribute 5 5 14838 0 contagem.pg_toast.pg_toast_2619 1 1 120 0 contagem.pg_catalog.pg_shdepend 1 1 974 0 contagem.pg_catalog.pg_depend 1 1 647 0 rio.public.temp0000286658 1 0 0 0 contagem.pg_catalog.pg_class 1 1 153 0 brasilia.pg_toast.pg_toast_2619 2 2 218 0 Total 384 178 400,299 4,548 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 28 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 6 7 06 1 1 07 9 19 08 41 88 09 62 110 10 31 78 11 33 89 12 17 44 13 33 74 14 24 82 15 45 107 16 56 114 17 24 67 18 0 0 19 0 0 20 0 0 21 2 7 22 0 0 23 0 1 - 45.93 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- AccessExclusiveLock Main Lock Type
- 4 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 1 1m36s 1m36s 1m36s 1m36s select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-07-01''),DATE(''2026-07-27'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-07-28 15:42:46 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027695, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-28 10:25:24 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027704, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');
Date: 2026-07-28 11:37:22 Database: rio User: intelifix Remote: [local] Application: [unknown]
2 1 1s677ms 1s677ms 1s677ms 1s677ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (48175, 407, '270911020057102061,229787774753,229661271925,229743101819,229813876885,229747692525,229809469205,229755127683,229808990517,229808539507,229746116366,229742237783,229691431726,229742445559,229807210725,229745417375,229860161919,229809307494,229817078095,229755717191,229689923352,229865565667,229684432345,229669949921,229786224759,229686648699,229749238905,229691533150,229748428791,229859992733,229663790409,229690805267,229813330211,229663024666,229812976483,216935954462,229786927992,229812698195,229933312021,229690061121,229737512239,216940443239,229690348702,216944823543,229813528893,229837171011,229688601416,229726564245,229836869208,229735815765,229663788286', '246599052038,246457198383,246547866469,246628939713,246548565763,246628676376,246559036280,246619158387,246619226980,246568874457,246531217392,246517024851,246569460306,246580697800,246539575559,246651803134,246628672235,246631375764,246560886180,246515422125,246649075864,246524870814,246515120222,246601986274,246491499194,246566190223,246506716269,246549501422,246648709510,246468955053,246514144862,246627377798,246491763037,246627997993,246439791321,246597725252,246629632138,246052133757,246516214660,246527639400,246463855577,246521428591,246468023638,246636014354,246639358585,246513870414,246523811126,246639747692,246545036889,246471690203', 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":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-07-28 10:50:57 Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (48208, 406, '835120918003490,241673372139,241711111333,241622613537,241663852534,241659752235,241678332735,241618262630,241610024149,230048002541,241672196883,241659740517,241680350104,241700953854,241692663853,241620794953,241692689613,241704219212,241622621619,241695505151,241635757782,241647236770,241629137787,241656766578,241620860011,241673332741,241664810922,241711214956,241731249100,241645800223,241695570310,241676719502,241732062446,241713726772,241676716370,241731202429,241646239614,241703551010,241713701821,241656767790,241692661833,241692665166,241659661620,241673333650,241617429204,241732063860,241637745676,241700930014,241680407684,241614550506,241636120524', '',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":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-28 13:34:28 Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (48210, 418, 'ZTE3ANNT2V86514,D83139937A84,D83139937A85,ZTEGDD314471$ZTE3ANNQ8F13506,689E29FD5F69,689E29FD5F6A,ZTEGD7BA3192$ZTE3ANNT2V12177,D831398CAC3E,D831398CAC3F,ZTEGDD302210$ZTE3ANNR9F18235,D89A0DA48945,D89A0DA48946,ZTEGDB156E86$ZTE3ANNQ4N01105,3CF9F0A8AB94,3CF9F0A8AB95,ZTEGD641074C$ZTE3ANNT3F09322,D83139960644,D83139960645,ZTEGDD31B111$ZTE3ANNT3H26867,D8313999394A,D8313999394B,ZTEGDD323992$ZTE3ANNRC575652,6C11BA6916EF,6C11BA6916F0,ZTEGDC6F3D43$ZTE3ANNQ7506311,C4EBFF8B8726,C4EBFF8B8727,ZTEGD70A6747$ZTE3ANNR7B32772,3891484BECBF,3891484BECC0,ZTEGDB081164$ZTE3ANNT2V71503,D83139921AB2,D83139921AB3,ZTEGDD3109CE$ZTE3ANNQ4N02041,3CF9F0A8C184,3CF9F0A8C185,ZTEGD6410AF4$ZTE3ANNR5W76379,48D6823581EC,48D6823581ED,ZTEGDB012A5A$ZTE3ANNR7B33016,3891484BF277,3891484BF278,ZTEGDB081258$ZTE3ANNQCA06665,14CA56D2E111,14CA56D2E112,ZTEGD9717F74$ZTE3ANNR3Y45871,4896D953F3D2,4896D953F3D3,ZTEGD97EE3E4$ZTE3ANNR6R24547,48D68237C414,48D68237C415,ZTEGDB018AB6$ZTE3ANNR3Y03781,4896D9501956,4896D9501957,ZTEGD97E3F7A$ZTE3ANNR5W07722,48D6822F38C6,48D6822F38C7,ZTEGDB001E29$ZTE3ANNR1Y02243,14CA56CCDF0D,14CA56CCDF0E,ZTEGD9707F1E$ZTE3ANNR5W69143,48D68234D854,48D68234D855,ZTEGDB010E16$ZTE3ANNRCB71290,D831392455DA,D831392455DB,ZTEGDD2ACC0F$ZTE3ANNR3Y22505,4896D951D02E,4896D951D02F,ZTEGD97E889E$ZTE3ANNR3J30130,F4E84F89108C,F4E84F89108D,ZTEGD97BD77C$ZTE3ANNQ3611397,3CF9F0A5E08C,3CF9F0A5E08D,ZTEGD6409020$ZTE3ANNRC565508,6C11BA68292F,6C11BA682930,ZTEGDC6F15A3$ZTE3ANNRB737565,5872C991A99F,5872C991A9A0,ZTEGDC61BD90$ZTE3ANNR5W00896,48D6822E98CA,48D6822E98CB,ZTEGDB00037F$ZTE3ANNQ8F09274,689E29FCFC39,689E29FCFC3A,ZTEGD7BA210A$ZTE3ANNRB725227,5872C9908873,5872C9908874,ZTEGDC618D5E$ZTE3ANNT4P14342,F00C514CF6C2,F00C514CF6C3,ZTEGDE342E9C$ZTE3ANNRCB23956,D83139200076,D83139200077,ZTEGDD2A1329$ZTE3ANNR6R28468,48D682381FFA,48D682381FFB,ZTEGDB019A07$ZTE3ANNT3H23543,D8313998EB62,D8313998EB63,ZTEGDD322C96$ZTE3ANNR2Q58697,F4E84F8613B6,F4E84F8613B7,ZTEGD97B5803$ZTE3ANNR5W18059,48D682302B0C,48D682302B0D,ZTEGDB00468A$ZTE3ANNRC551367,6C11BA66DDC1,6C11BA66DDC2,ZTEGDC6EDE66$ZTE3ANNT4P16711,F00C514D2E48,F00C514D2E49,ZTEGDE3437DD$ZTE3ANNRCB67026,D8313923F1EA,D8313923F1EB,ZTEGDD2ABB67$ZTE3ANNRCB61191,D83139236928,D83139236929,ZTEGDD2AA49C$ZTE3ANNR9W44423,D89A0DAC6D4D,D89A0DAC6D4E,ZTEGDB16BF32$ZTE3ANNR5W72135,48D682351E74,48D682351E75,ZTEGDB0119C6$ZTE3ANNRCB23865,D831391FFE54,D831391FFE55,ZTEGDD2A12CE$ZTE3ANNR7B17093,3891484A7D45,3891484A7D46,ZTEGDB07D425$ZTE3ANNRAD25079,D89A0DB0262D,D89A0DB0262E,ZTEGDB175E02$ZTE3ANNR8C25909,38914850E645,38914850E646,ZTEGDB08E5A5$ZTE3ANNQ7T04143,C4EBFF8F4C5A,C4EBFF8F4C5B,ZTEGD70B0825', '',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":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-28 16:22:32 Database: contagem User: intelifix Remote: [local] Application: [unknown]
3 1 1s52ms 1s52ms 1s52ms 1s52ms drop table if exists temp0000286664;-
DROP TABLE IF EXISTS temp0000286664;
Date: 2026-07-28 10:45:09 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000286664;
Date: 2026-07-28 10:57:09 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000286664;
Date: 2026-07-28 11:13:10 Database: rio User: intelifix Remote: [local] Application: [unknown]
4 1 1s 1s 1s 1s drop table if exists temp0000286776;-
DROP TABLE IF EXISTS temp0000286776;
Date: 2026-07-28 17:07:37 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000286776;
Date: 2026-07-28 17:07:37 Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries that waited the most
Rank Wait time Query 1 1m36s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027704, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');[ Date: 2026-07-28 11:32:55 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 1s677ms SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (48367, 417, '11813085850053401537,E820E27B6A14$11932985850072705073,8C444FA73AB1$11834485850063011056,8C444F1BC222$11930985850071707282,8C444F9ABC36', '',039,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""}]','$$$$$$$$','', 00);[ Date: 2026-07-28 15:29:50 - Database: contagem - User: intelifix - Remote: [local] - Application: [unknown] ]
3 1s52ms DROP TABLE IF EXISTS temp0000286664;[ Date: 2026-07-28 10:45:09 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 1s DROP TABLE IF EXISTS temp0000286776;[ Date: 2026-07-28 17:07:37 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 3,935 Total read queries
- 1,483 Total write queries
Queries by database
Key values
- rio Main database
- 4,285 Requests
- 6h38m40s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 5,769 Requests
User Request type Count Duration etiquetas Total 34 6s638ms select 34 6s638ms intelifix Total 5,769 8h30m copy to 412 44m12s ddl 1,071 51m36s others 491 39m32s select 3,793 6h14m37s lenon Total 108 2m1s select 108 2m1s Duration by user
Key values
- 8h30m (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 34 6s638ms select 34 6s638ms intelifix Total 5,769 8h30m copy to 412 44m12s ddl 1,071 51m36s others 491 39m32s select 3,793 6h14m37s lenon Total 108 2m1s select 108 2m1s Queries by host
Key values
- [local] Main host
- 5,911 Requests
- 8h32m8s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 4,789 Requests
- 4h4m26s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-28 14:53:50 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 3,102 100-500ms duration
Slowest individual queries
Rank Duration Query 1 8m52s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-28 09:13:53 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 8m47s analyze verbose;[ Date: 2026-07-28 05:08:49 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 8m22s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-28 10:13:24 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 8m22s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-28 15:13:23 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 8m21s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-28 16:13:23 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 8m15s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-28 17:13:17 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 8m6s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-28 11:13:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 7m33s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-28 07:12:34 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 7m28s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-28 14:12:29 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 7m18s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-28 13:12:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 7m1s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-28 12:12:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 6m58s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-28 08:12:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 6m17s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-07-01''),DATE(''2026-07-27'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');[ Date: 2026-07-28 15:42:46 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 6m12s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027695, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-28 10:25:24 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
15 6m5s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027704, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');[ Date: 2026-07-28 11:37:22 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
16 5m49s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-28 21:10:51 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m44s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-28 20:10:45 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 5m44s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-28 19:10:46 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 5m43s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-28 18:10:45 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 5m40s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027709, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-28 14:42:25 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 2h4m50s 283 157ms 6m17s 26s469ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 28 07 29 5m36s 11s613ms 08 12 9m55s 49s651ms 09 32 15m3s 28s231ms 10 44 17m58s 24s518ms 11 15 25m36s 1m42s 12 3 6m4s 2m1s 13 24 55s829ms 2s326ms 14 12 10m52s 54s383ms 15 40 23m5s 34s633ms 16 32 8m57s 16s790ms 17 40 43s774ms 1s94ms [ User: intelifix - Total duration: 2h4m50s - Times executed: 283 ]
[ Application: [unknown] - Total duration: 2h4m50s - Times executed: 283 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-07-01''),DATE(''2026-07-27'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-07-28 15:42:46 Duration: 6m17s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027695, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-28 10:25:24 Duration: 6m12s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027704, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');
Date: 2026-07-28 11:37:22 Duration: 6m5s Database: rio User: intelifix Remote: [local] Application: [unknown]
2 2h3m5s 48 1s408ms 8m52s 2m33s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 28 07 3 8m9s 2m43s 08 3 7m17s 2m25s 09 3 9m33s 3m11s 10 3 8m50s 2m56s 11 3 8m49s 2m56s 12 3 7m28s 2m29s 13 3 7m50s 2m36s 14 3 7m50s 2m36s 15 3 9m2s 3m 16 3 8m56s 2m58s 17 3 9m2s 3m 18 3 6m2s 2m 19 3 6m1s 2m 20 3 6m6s 2m2s 21 3 6m6s 2m2s 22 3 5m57s 1m59s [ User: intelifix - Total duration: 2h3m5s - Times executed: 48 ]
[ Application: psql - Total duration: 2h3m5s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-28 09:13:53 Duration: 8m52s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-28 10:13:24 Duration: 8m22s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-28 15:13:23 Duration: 8m22s Database: rio User: intelifix Remote: [local] Application: psql
3 1h11m42s 47 255ms 4m34s 1m31s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 28 07 3 4m45s 1m35s 08 3 4m41s 1m33s 09 2 1m10s 35s7ms 10 3 5m22s 1m47s 11 3 5m20s 1m46s 12 3 4m29s 1m29s 13 3 4m36s 1m32s 14 3 5m12s 1m44s 15 3 5m16s 1m45s 16 3 5m13s 1m44s 17 3 5m31s 1m50s 18 3 3m45s 1m15s 19 3 3m52s 1m17s 20 3 4m22s 1m27s 21 3 4m3s 1m21s 22 3 4m 1m20s [ User: intelifix - Total duration: 1h11m42s - Times executed: 47 ]
[ Application: psql - Total duration: 1h11m42s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-28 10:19:09 Duration: 4m34s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-28 17:19:25 Duration: 4m32s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-28 15:19:10 Duration: 4m24s Database: brasilia User: intelifix Remote: [local] Application: psql
4 19m32s 1,181 150ms 5s937ms 993ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 28 07 7 5s264ms 752ms 08 94 1m27s 935ms 09 142 2m14s 946ms 10 133 1m56s 874ms 11 146 1m43s 711ms 12 23 6s971ms 303ms 13 92 1m46s 1s154ms 14 140 3m1s 1s296ms 15 119 2m49s 1s420ms 16 153 3m8s 1s234ms 17 132 1m12s 549ms [ User: intelifix - Total duration: 19m32s - Times executed: 1181 ]
[ Application: [unknown] - Total duration: 19m32s - Times executed: 1181 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (48175, 407, '270911020057102061,229787774753,229661271925,229743101819,229813876885,229747692525,229809469205,229755127683,229808990517,229808539507,229746116366,229742237783,229691431726,229742445559,229807210725,229745417375,229860161919,229809307494,229817078095,229755717191,229689923352,229865565667,229684432345,229669949921,229786224759,229686648699,229749238905,229691533150,229748428791,229859992733,229663790409,229690805267,229813330211,229663024666,229812976483,216935954462,229786927992,229812698195,229933312021,229690061121,229737512239,216940443239,229690348702,216944823543,229813528893,229837171011,229688601416,229726564245,229836869208,229735815765,229663788286', '246599052038,246457198383,246547866469,246628939713,246548565763,246628676376,246559036280,246619158387,246619226980,246568874457,246531217392,246517024851,246569460306,246580697800,246539575559,246651803134,246628672235,246631375764,246560886180,246515422125,246649075864,246524870814,246515120222,246601986274,246491499194,246566190223,246506716269,246549501422,246648709510,246468955053,246514144862,246627377798,246491763037,246627997993,246439791321,246597725252,246629632138,246052133757,246516214660,246527639400,246463855577,246521428591,246468023638,246636014354,246639358585,246513870414,246523811126,246639747692,246545036889,246471690203', 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":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-07-28 10:50:57 Duration: 5s937ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (48208, 406, '835120918003490,241673372139,241711111333,241622613537,241663852534,241659752235,241678332735,241618262630,241610024149,230048002541,241672196883,241659740517,241680350104,241700953854,241692663853,241620794953,241692689613,241704219212,241622621619,241695505151,241635757782,241647236770,241629137787,241656766578,241620860011,241673332741,241664810922,241711214956,241731249100,241645800223,241695570310,241676719502,241732062446,241713726772,241676716370,241731202429,241646239614,241703551010,241713701821,241656767790,241692661833,241692665166,241659661620,241673333650,241617429204,241732063860,241637745676,241700930014,241680407684,241614550506,241636120524', '',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":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-28 13:34:28 Duration: 5s323ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (48210, 418, 'ZTE3ANNT2V86514,D83139937A84,D83139937A85,ZTEGDD314471$ZTE3ANNQ8F13506,689E29FD5F69,689E29FD5F6A,ZTEGD7BA3192$ZTE3ANNT2V12177,D831398CAC3E,D831398CAC3F,ZTEGDD302210$ZTE3ANNR9F18235,D89A0DA48945,D89A0DA48946,ZTEGDB156E86$ZTE3ANNQ4N01105,3CF9F0A8AB94,3CF9F0A8AB95,ZTEGD641074C$ZTE3ANNT3F09322,D83139960644,D83139960645,ZTEGDD31B111$ZTE3ANNT3H26867,D8313999394A,D8313999394B,ZTEGDD323992$ZTE3ANNRC575652,6C11BA6916EF,6C11BA6916F0,ZTEGDC6F3D43$ZTE3ANNQ7506311,C4EBFF8B8726,C4EBFF8B8727,ZTEGD70A6747$ZTE3ANNR7B32772,3891484BECBF,3891484BECC0,ZTEGDB081164$ZTE3ANNT2V71503,D83139921AB2,D83139921AB3,ZTEGDD3109CE$ZTE3ANNQ4N02041,3CF9F0A8C184,3CF9F0A8C185,ZTEGD6410AF4$ZTE3ANNR5W76379,48D6823581EC,48D6823581ED,ZTEGDB012A5A$ZTE3ANNR7B33016,3891484BF277,3891484BF278,ZTEGDB081258$ZTE3ANNQCA06665,14CA56D2E111,14CA56D2E112,ZTEGD9717F74$ZTE3ANNR3Y45871,4896D953F3D2,4896D953F3D3,ZTEGD97EE3E4$ZTE3ANNR6R24547,48D68237C414,48D68237C415,ZTEGDB018AB6$ZTE3ANNR3Y03781,4896D9501956,4896D9501957,ZTEGD97E3F7A$ZTE3ANNR5W07722,48D6822F38C6,48D6822F38C7,ZTEGDB001E29$ZTE3ANNR1Y02243,14CA56CCDF0D,14CA56CCDF0E,ZTEGD9707F1E$ZTE3ANNR5W69143,48D68234D854,48D68234D855,ZTEGDB010E16$ZTE3ANNRCB71290,D831392455DA,D831392455DB,ZTEGDD2ACC0F$ZTE3ANNR3Y22505,4896D951D02E,4896D951D02F,ZTEGD97E889E$ZTE3ANNR3J30130,F4E84F89108C,F4E84F89108D,ZTEGD97BD77C$ZTE3ANNQ3611397,3CF9F0A5E08C,3CF9F0A5E08D,ZTEGD6409020$ZTE3ANNRC565508,6C11BA68292F,6C11BA682930,ZTEGDC6F15A3$ZTE3ANNRB737565,5872C991A99F,5872C991A9A0,ZTEGDC61BD90$ZTE3ANNR5W00896,48D6822E98CA,48D6822E98CB,ZTEGDB00037F$ZTE3ANNQ8F09274,689E29FCFC39,689E29FCFC3A,ZTEGD7BA210A$ZTE3ANNRB725227,5872C9908873,5872C9908874,ZTEGDC618D5E$ZTE3ANNT4P14342,F00C514CF6C2,F00C514CF6C3,ZTEGDE342E9C$ZTE3ANNRCB23956,D83139200076,D83139200077,ZTEGDD2A1329$ZTE3ANNR6R28468,48D682381FFA,48D682381FFB,ZTEGDB019A07$ZTE3ANNT3H23543,D8313998EB62,D8313998EB63,ZTEGDD322C96$ZTE3ANNR2Q58697,F4E84F8613B6,F4E84F8613B7,ZTEGD97B5803$ZTE3ANNR5W18059,48D682302B0C,48D682302B0D,ZTEGDB00468A$ZTE3ANNRC551367,6C11BA66DDC1,6C11BA66DDC2,ZTEGDC6EDE66$ZTE3ANNT4P16711,F00C514D2E48,F00C514D2E49,ZTEGDE3437DD$ZTE3ANNRCB67026,D8313923F1EA,D8313923F1EB,ZTEGDD2ABB67$ZTE3ANNRCB61191,D83139236928,D83139236929,ZTEGDD2AA49C$ZTE3ANNR9W44423,D89A0DAC6D4D,D89A0DAC6D4E,ZTEGDB16BF32$ZTE3ANNR5W72135,48D682351E74,48D682351E75,ZTEGDB0119C6$ZTE3ANNRCB23865,D831391FFE54,D831391FFE55,ZTEGDD2A12CE$ZTE3ANNR7B17093,3891484A7D45,3891484A7D46,ZTEGDB07D425$ZTE3ANNRAD25079,D89A0DB0262D,D89A0DB0262E,ZTEGDB175E02$ZTE3ANNR8C25909,38914850E645,38914850E646,ZTEGDB08E5A5$ZTE3ANNQ7T04143,C4EBFF8F4C5A,C4EBFF8F4C5B,ZTEGD70B0825', '',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":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-28 16:22:32 Duration: 5s274ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
5 18m12s 89 9s302ms 38s800ms 12s272ms create table temp0000286664 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 28 07 9 1m31s 10s213ms 08 18 3m31s 11s759ms 09 9 1m46s 11s781ms 10 17 3m32s 12s497ms 11 8 1m34s 11s831ms 14 5 1m31s 18s206ms 15 16 3m17s 12s373ms 16 7 1m26s 12s362ms [ User: intelifix - Total duration: 18m12s - Times executed: 89 ]
[ Application: [unknown] - Total duration: 18m12s - Times executed: 89 ]
-
CREATE TABLE temp0000286664 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-28 14:34:21 Duration: 38s800ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286664 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-28 10:37:28 Duration: 23s160ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286664 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-28 15:09:22 Duration: 15s93ms Database: rio User: intelifix Remote: [local] Application: [unknown]
6 15m22s 3 2m18s 8m47s 5m7s analyze verbose;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 28 05 3 15m22s 5m7s [ User: intelifix - Total duration: 15m22s - Times executed: 3 ]
[ Application: psql - Total duration: 15m22s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-28 05:08:49 Duration: 8m47s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-28 05:13:05 Duration: 4m16s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-28 05:15:23 Duration: 2m18s Database: contagem User: intelifix Remote: [local] Application: psql
7 11m31s 56 1s40ms 47s51ms 12s339ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 28 07 2 14s297ms 7s148ms 08 2 49s917ms 24s958ms 09 4 28s187ms 7s46ms 10 6 2m26s 24s404ms 11 2 14s574ms 7s287ms 12 5 59s794ms 11s958ms 13 5 54s307ms 10s861ms 14 5 1m6s 13s227ms 15 7 36s963ms 5s280ms 16 9 2m2s 13s557ms 17 9 1m38s 10s934ms [ User: intelifix - Total duration: 11m31s - Times executed: 56 ]
[ Application: [unknown] - Total duration: 11m31s - Times executed: 56 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-28', 0175, '', '', 0, 6, '2026-07-01');
Date: 2026-07-28 16:32:54 Duration: 47s51ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-28', 0320, '', '', 0, 6, '2026-07-01');
Date: 2026-07-28 10:15:09 Duration: 46s184ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-28', 0320, '', '', 0, 6, '2026-07-01');
Date: 2026-07-28 08:59:32 Duration: 41s726ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 10m6s 274 199ms 9s313ms 2s213ms call rs_giga_triagem (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 28 00 12 27s944ms 2s328ms 01 12 19s443ms 1s620ms 02 12 20s325ms 1s693ms 03 12 21s445ms 1s787ms 04 12 21s910ms 1s825ms 05 12 23s3ms 1s916ms 06 12 21s322ms 1s776ms 07 12 24s927ms 2s77ms 08 12 23s822ms 1s985ms 09 12 38s31ms 3s169ms 10 12 40s419ms 3s368ms 11 12 26s535ms 2s211ms 12 12 27s289ms 2s274ms 13 12 26s60ms 2s171ms 14 12 28s874ms 2s406ms 15 12 31s30ms 2s585ms 16 12 36s156ms 3s13ms 17 12 26s410ms 2s200ms 18 12 22s828ms 1s902ms 19 11 22s737ms 2s67ms 20 11 27s233ms 2s475ms 21 12 25s70ms 2s89ms 22 12 23s706ms 1s975ms [ User: intelifix - Total duration: 10m6s - Times executed: 274 ]
[ Application: psql - Total duration: 10m6s - Times executed: 274 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-28 00:05:24 Duration: 9s313ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-28 16:25:12 Duration: 8s412ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-28 10:25:16 Duration: 8s93ms Database: rio User: intelifix Remote: [local] Application: psql
9 8m59s 1,079 151ms 6s605ms 499ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 28 08 143 1m17s 539ms 09 165 1m12s 440ms 10 157 1m10s 446ms 11 98 49s27ms 500ms 12 17 11s457ms 673ms 13 94 52s7ms 553ms 14 124 1m9s 557ms 15 103 49s241ms 478ms 16 153 1m13s 478ms 17 25 15s42ms 601ms [ User: intelifix - Total duration: 8m59s - Times executed: 1079 ]
[ Application: [unknown] - Total duration: 8m59s - Times executed: 1079 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "104675", "modelo" : "295", "itens" : "230023142337,230038200002,229971975053,230051967596,230023218203,230041298901,230011127886,229989848099,230034411731,230038189494,230006137287,230029349407,230038237580,230053198086,230001302035,229977561222", "usuario" : "414", "caixa" : "1227084", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-28 08:10:19 Duration: 6s605ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "229989", "modelo" : "295", "itens" : "229971701739,230019636270,230027893945,230033425663,229991149405,230038138705,230038139513,230027511428,230035376381,230034262951,230041262736,230010221828,230010226979,230023242324,229975715564,230038123754,229968469818,229970595659,229990053249,230050052135,230014812736", "usuario" : "414", "caixa" : "2755903", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-28 08:06:11 Duration: 2s482ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "271626", "modelo" : "141", "itens" : "229749878192,229813801121,229783263550,229743447587,229866094260,229806053047,229667497380,216943611113,229751796887,229691270521,229745775267,229745373556,229814918490,216941805964,216943697787,229686805662,229748675157,229665260418,229745794663,229836639208,229781359806,229755745151,229673138504,229865836883,229850376777,229808204749,229747397995,229813385266", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "246532177272,246628266785,246587595375,246527652533,246653406769,246581647274,246469831739,246468638097,246531802837,246506745161,246548504444,246547370103,246631015471,246482048990,246483922227,246524680313,246551181328,246467916882,246551573947,246640352937,246587296782,246557672444,246517837691,246653608305,246638082233,246605551718,246570371719,246628607884,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-28 13:19:21 Duration: 2s354ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 7m33s 156 199ms 13s352ms 2s907ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 28 00 6 21s896ms 3s649ms 01 6 9s937ms 1s656ms 02 4 7s112ms 1s778ms 03 5 6s803ms 1s360ms 04 6 9s553ms 1s592ms 05 2 5s604ms 2s802ms 06 1 947ms 947ms 07 9 34s68ms 3s785ms 08 12 40s87ms 3s340ms 09 12 50s71ms 4s172ms 10 12 47s834ms 3s986ms 11 12 49s128ms 4s94ms 12 11 40s140ms 3s649ms 13 10 10s565ms 1s56ms 14 12 41s930ms 3s494ms 15 12 38s567ms 3s213ms 16 9 18s617ms 2s68ms 17 4 3s579ms 894ms 21 5 8s266ms 1s653ms 22 6 8s919ms 1s486ms [ User: intelifix - Total duration: 7m33s - Times executed: 156 ]
[ Application: psql - Total duration: 7m33s - Times executed: 156 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-28 00:05:14 Duration: 13s352ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-28 10:15:11 Duration: 9s681ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-28 11:35:10 Duration: 8s823ms Database: rio User: intelifix Remote: [local] Application: psql
11 4m59s 25 9s345ms 13s976ms 11s974ms create table temp0000286776 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 28 17 25 4m59s 11s974ms [ User: intelifix - Total duration: 4m59s - Times executed: 25 ]
[ Application: [unknown] - Total duration: 4m59s - Times executed: 25 ]
-
CREATE TABLE temp0000286776 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-28 17:02:33 Duration: 13s976ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286776 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-28 17:16:09 Duration: 13s912ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286776 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-28 17:15:47 Duration: 13s620ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 4m32s 1 4m32s 4m32s 4m32s select * from rs_smart_fiscal_saida () / 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 #12
Day Hour Count Duration Avg duration Jul 28 09 1 4m32s 4m32s [ User: intelifix - Total duration: 4m32s - Times executed: 1 ]
[ Application: psql - Total duration: 4m32s - Times executed: 1 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-28 09:20:10 Duration: 4m32s Database: brasilia User: intelifix Remote: [local] Application: psql
13 3m 4 4s230ms 1m27s 45s22ms 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 Jul 28 20 2 1m27s 43s699ms 23 2 1m32s 46s344ms [ User: intelifix - Total duration: 3m - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-28 23:16:41 Duration: 1m27s 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-07-28 20:08:27 Duration: 1m23s 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-07-28 23:35:35 Duration: 4s725ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 2m44s 13 11s51ms 14s825ms 12s646ms create table temp0000286708 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 28 09 13 2m44s 12s646ms [ User: intelifix - Total duration: 2m44s - Times executed: 13 ]
[ Application: [unknown] - Total duration: 2m44s - Times executed: 13 ]
-
CREATE TABLE temp0000286708 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-28 09:42:21 Duration: 14s825ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286708 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-28 09:44:43 Duration: 13s909ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286708 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-28 09:10:57 Duration: 13s846ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 2m42s 41 2s432ms 9s445ms 3s969ms create table temp0000286664 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 28 07 6 18s120ms 3s20ms 08 16 58s393ms 3s649ms 09 6 20s737ms 3s456ms 11 4 20s969ms 5s242ms 14 2 13s786ms 6s893ms 16 7 30s723ms 4s389ms [ User: intelifix - Total duration: 2m42s - Times executed: 41 ]
[ Application: [unknown] - Total duration: 2m42s - Times executed: 41 ]
-
CREATE TABLE temp0000286664 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"23-07-2026", "ate" :"28-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-28 14:44:53 Duration: 9s445ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286664 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"23-07-2026", "ate" :"28-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-28 11:33:35 Duration: 8s955ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286664 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"23-07-2026", "ate" :"28-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-28 16:29:15 Duration: 4s683ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 1m59s 38 234ms 10s658ms 3s153ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 28 07 2 12s478ms 6s239ms 08 4 6s475ms 1s618ms 09 3 13s372ms 4s457ms 10 4 17s361ms 4s340ms 11 4 9s66ms 2s266ms 12 2 3s44ms 1s522ms 13 2 1s191ms 595ms 14 2 13s195ms 6s597ms 15 6 21s821ms 3s636ms 16 4 13s32ms 3s258ms 17 5 8s803ms 1s760ms [ User: intelifix - Total duration: 1m59s - Times executed: 38 ]
[ Application: psql - Total duration: 1m59s - Times executed: 38 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027675);
Date: 2026-07-28 07:35:33 Duration: 10s658ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027709);
Date: 2026-07-28 14:36:10 Duration: 10s205ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027695);
Date: 2026-07-28 10:18:48 Duration: 6s486ms Database: rio User: intelifix Remote: [local] Application: psql
17 1m56s 29 758ms 13s11ms 4s14ms 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 Jul 28 08 3 11s71ms 3s690ms 09 2 14s860ms 7s430ms 10 2 11s483ms 5s741ms 11 1 4s827ms 4s827ms 12 3 8s943ms 2s981ms 13 1 3s602ms 3s602ms 14 2 19s671ms 9s835ms 15 1 5s223ms 5s223ms 16 2 15s147ms 7s573ms 17 2 12s214ms 6s107ms 18 2 1s723ms 861ms 19 2 1s590ms 795ms 20 1 1s278ms 1s278ms 21 2 1s860ms 930ms 22 3 2s916ms 972ms [ User: intelifix - Total duration: 1m56s - Times executed: 29 ]
[ Application: psql - Total duration: 1m56s - Times executed: 29 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-28 14:40:14 Duration: 13s11ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-28 17:00:12 Duration: 10s422ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-28 16:00:09 Duration: 8s745ms Database: rio User: intelifix Remote: [local] Application: psql
18 1m55s 10 9s723ms 13s247ms 11s535ms create table temp0000286664 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?) notice: table "tmp_entrada" does not exist, skipping;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 28 07 3 30s580ms 10s193ms 08 1 13s239ms 13s239ms 10 1 13s247ms 13s247ms 11 1 10s184ms 10s184ms 14 1 12s990ms 12s990ms 15 1 12s111ms 12s111ms 16 2 23s1ms 11s500ms [ User: intelifix - Total duration: 1m55s - Times executed: 10 ]
[ Application: [unknown] - Total duration: 1m55s - Times executed: 10 ]
-
CREATE TABLE temp0000286664 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06) NOTICE: table "tmp_entrada" does not exist, skipping;
Date: 2026-07-28 10:44:45 Duration: 13s247ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286664 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06) NOTICE: table "tmp_entrada" does not exist, skipping;
Date: 2026-07-28 08:50:34 Duration: 13s239ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286664 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06) NOTICE: table "tmp_entrada" does not exist, skipping;
Date: 2026-07-28 14:35:52 Duration: 12s990ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 1m55s 66 203ms 48s244ms 1s746ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 28 07 4 2s79ms 519ms 08 7 8s982ms 1s283ms 09 10 24s595ms 2s459ms 10 6 2s557ms 426ms 11 5 2s42ms 408ms 12 2 48s628ms 24s314ms 14 3 2s284ms 761ms 15 8 4s253ms 531ms 16 6 16s75ms 2s679ms 17 15 3s755ms 250ms [ User: intelifix - Total duration: 1m55s - Times executed: 66 ]
[ Application: psql - Total duration: 1m55s - Times executed: 66 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027706);
Date: 2026-07-28 12:09:19 Duration: 48s244ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027694);
Date: 2026-07-28 09:51:26 Duration: 10s745ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027722);
Date: 2026-07-28 16:25:30 Duration: 10s662ms Database: rio User: intelifix Remote: [local] Application: psql
20 1m51s 4 319ms 56s815ms 27s948ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 28 20 2 54s649ms 27s324ms 23 2 57s144ms 28s572ms [ User: intelifix - Total duration: 1m51s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m51s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-28 23:13:31 Duration: 56s815ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-28 20:05:25 Duration: 54s330ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-28 23:35:01 Duration: 329ms 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,181 19m32s 150ms 5s937ms 993ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 28 07 7 5s264ms 752ms 08 94 1m27s 935ms 09 142 2m14s 946ms 10 133 1m56s 874ms 11 146 1m43s 711ms 12 23 6s971ms 303ms 13 92 1m46s 1s154ms 14 140 3m1s 1s296ms 15 119 2m49s 1s420ms 16 153 3m8s 1s234ms 17 132 1m12s 549ms [ User: intelifix - Total duration: 19m32s - Times executed: 1181 ]
[ Application: [unknown] - Total duration: 19m32s - Times executed: 1181 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (48175, 407, '270911020057102061,229787774753,229661271925,229743101819,229813876885,229747692525,229809469205,229755127683,229808990517,229808539507,229746116366,229742237783,229691431726,229742445559,229807210725,229745417375,229860161919,229809307494,229817078095,229755717191,229689923352,229865565667,229684432345,229669949921,229786224759,229686648699,229749238905,229691533150,229748428791,229859992733,229663790409,229690805267,229813330211,229663024666,229812976483,216935954462,229786927992,229812698195,229933312021,229690061121,229737512239,216940443239,229690348702,216944823543,229813528893,229837171011,229688601416,229726564245,229836869208,229735815765,229663788286', '246599052038,246457198383,246547866469,246628939713,246548565763,246628676376,246559036280,246619158387,246619226980,246568874457,246531217392,246517024851,246569460306,246580697800,246539575559,246651803134,246628672235,246631375764,246560886180,246515422125,246649075864,246524870814,246515120222,246601986274,246491499194,246566190223,246506716269,246549501422,246648709510,246468955053,246514144862,246627377798,246491763037,246627997993,246439791321,246597725252,246629632138,246052133757,246516214660,246527639400,246463855577,246521428591,246468023638,246636014354,246639358585,246513870414,246523811126,246639747692,246545036889,246471690203', 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":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-07-28 10:50:57 Duration: 5s937ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (48208, 406, '835120918003490,241673372139,241711111333,241622613537,241663852534,241659752235,241678332735,241618262630,241610024149,230048002541,241672196883,241659740517,241680350104,241700953854,241692663853,241620794953,241692689613,241704219212,241622621619,241695505151,241635757782,241647236770,241629137787,241656766578,241620860011,241673332741,241664810922,241711214956,241731249100,241645800223,241695570310,241676719502,241732062446,241713726772,241676716370,241731202429,241646239614,241703551010,241713701821,241656767790,241692661833,241692665166,241659661620,241673333650,241617429204,241732063860,241637745676,241700930014,241680407684,241614550506,241636120524', '',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":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-28 13:34:28 Duration: 5s323ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (48210, 418, 'ZTE3ANNT2V86514,D83139937A84,D83139937A85,ZTEGDD314471$ZTE3ANNQ8F13506,689E29FD5F69,689E29FD5F6A,ZTEGD7BA3192$ZTE3ANNT2V12177,D831398CAC3E,D831398CAC3F,ZTEGDD302210$ZTE3ANNR9F18235,D89A0DA48945,D89A0DA48946,ZTEGDB156E86$ZTE3ANNQ4N01105,3CF9F0A8AB94,3CF9F0A8AB95,ZTEGD641074C$ZTE3ANNT3F09322,D83139960644,D83139960645,ZTEGDD31B111$ZTE3ANNT3H26867,D8313999394A,D8313999394B,ZTEGDD323992$ZTE3ANNRC575652,6C11BA6916EF,6C11BA6916F0,ZTEGDC6F3D43$ZTE3ANNQ7506311,C4EBFF8B8726,C4EBFF8B8727,ZTEGD70A6747$ZTE3ANNR7B32772,3891484BECBF,3891484BECC0,ZTEGDB081164$ZTE3ANNT2V71503,D83139921AB2,D83139921AB3,ZTEGDD3109CE$ZTE3ANNQ4N02041,3CF9F0A8C184,3CF9F0A8C185,ZTEGD6410AF4$ZTE3ANNR5W76379,48D6823581EC,48D6823581ED,ZTEGDB012A5A$ZTE3ANNR7B33016,3891484BF277,3891484BF278,ZTEGDB081258$ZTE3ANNQCA06665,14CA56D2E111,14CA56D2E112,ZTEGD9717F74$ZTE3ANNR3Y45871,4896D953F3D2,4896D953F3D3,ZTEGD97EE3E4$ZTE3ANNR6R24547,48D68237C414,48D68237C415,ZTEGDB018AB6$ZTE3ANNR3Y03781,4896D9501956,4896D9501957,ZTEGD97E3F7A$ZTE3ANNR5W07722,48D6822F38C6,48D6822F38C7,ZTEGDB001E29$ZTE3ANNR1Y02243,14CA56CCDF0D,14CA56CCDF0E,ZTEGD9707F1E$ZTE3ANNR5W69143,48D68234D854,48D68234D855,ZTEGDB010E16$ZTE3ANNRCB71290,D831392455DA,D831392455DB,ZTEGDD2ACC0F$ZTE3ANNR3Y22505,4896D951D02E,4896D951D02F,ZTEGD97E889E$ZTE3ANNR3J30130,F4E84F89108C,F4E84F89108D,ZTEGD97BD77C$ZTE3ANNQ3611397,3CF9F0A5E08C,3CF9F0A5E08D,ZTEGD6409020$ZTE3ANNRC565508,6C11BA68292F,6C11BA682930,ZTEGDC6F15A3$ZTE3ANNRB737565,5872C991A99F,5872C991A9A0,ZTEGDC61BD90$ZTE3ANNR5W00896,48D6822E98CA,48D6822E98CB,ZTEGDB00037F$ZTE3ANNQ8F09274,689E29FCFC39,689E29FCFC3A,ZTEGD7BA210A$ZTE3ANNRB725227,5872C9908873,5872C9908874,ZTEGDC618D5E$ZTE3ANNT4P14342,F00C514CF6C2,F00C514CF6C3,ZTEGDE342E9C$ZTE3ANNRCB23956,D83139200076,D83139200077,ZTEGDD2A1329$ZTE3ANNR6R28468,48D682381FFA,48D682381FFB,ZTEGDB019A07$ZTE3ANNT3H23543,D8313998EB62,D8313998EB63,ZTEGDD322C96$ZTE3ANNR2Q58697,F4E84F8613B6,F4E84F8613B7,ZTEGD97B5803$ZTE3ANNR5W18059,48D682302B0C,48D682302B0D,ZTEGDB00468A$ZTE3ANNRC551367,6C11BA66DDC1,6C11BA66DDC2,ZTEGDC6EDE66$ZTE3ANNT4P16711,F00C514D2E48,F00C514D2E49,ZTEGDE3437DD$ZTE3ANNRCB67026,D8313923F1EA,D8313923F1EB,ZTEGDD2ABB67$ZTE3ANNRCB61191,D83139236928,D83139236929,ZTEGDD2AA49C$ZTE3ANNR9W44423,D89A0DAC6D4D,D89A0DAC6D4E,ZTEGDB16BF32$ZTE3ANNR5W72135,48D682351E74,48D682351E75,ZTEGDB0119C6$ZTE3ANNRCB23865,D831391FFE54,D831391FFE55,ZTEGDD2A12CE$ZTE3ANNR7B17093,3891484A7D45,3891484A7D46,ZTEGDB07D425$ZTE3ANNRAD25079,D89A0DB0262D,D89A0DB0262E,ZTEGDB175E02$ZTE3ANNR8C25909,38914850E645,38914850E646,ZTEGDB08E5A5$ZTE3ANNQ7T04143,C4EBFF8F4C5A,C4EBFF8F4C5B,ZTEGD70B0825', '',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":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-28 16:22:32 Duration: 5s274ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
2 1,079 8m59s 151ms 6s605ms 499ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 28 08 143 1m17s 539ms 09 165 1m12s 440ms 10 157 1m10s 446ms 11 98 49s27ms 500ms 12 17 11s457ms 673ms 13 94 52s7ms 553ms 14 124 1m9s 557ms 15 103 49s241ms 478ms 16 153 1m13s 478ms 17 25 15s42ms 601ms [ User: intelifix - Total duration: 8m59s - Times executed: 1079 ]
[ Application: [unknown] - Total duration: 8m59s - Times executed: 1079 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "104675", "modelo" : "295", "itens" : "230023142337,230038200002,229971975053,230051967596,230023218203,230041298901,230011127886,229989848099,230034411731,230038189494,230006137287,230029349407,230038237580,230053198086,230001302035,229977561222", "usuario" : "414", "caixa" : "1227084", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-28 08:10:19 Duration: 6s605ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "229989", "modelo" : "295", "itens" : "229971701739,230019636270,230027893945,230033425663,229991149405,230038138705,230038139513,230027511428,230035376381,230034262951,230041262736,230010221828,230010226979,230023242324,229975715564,230038123754,229968469818,229970595659,229990053249,230050052135,230014812736", "usuario" : "414", "caixa" : "2755903", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-28 08:06:11 Duration: 2s482ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "271626", "modelo" : "141", "itens" : "229749878192,229813801121,229783263550,229743447587,229866094260,229806053047,229667497380,216943611113,229751796887,229691270521,229745775267,229745373556,229814918490,216941805964,216943697787,229686805662,229748675157,229665260418,229745794663,229836639208,229781359806,229755745151,229673138504,229865836883,229850376777,229808204749,229747397995,229813385266", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "246532177272,246628266785,246587595375,246527652533,246653406769,246581647274,246469831739,246468638097,246531802837,246506745161,246548504444,246547370103,246631015471,246482048990,246483922227,246524680313,246551181328,246467916882,246551573947,246640352937,246587296782,246557672444,246517837691,246653608305,246638082233,246605551718,246570371719,246628607884,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-28 13:19:21 Duration: 2s354ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 283 2h4m50s 157ms 6m17s 26s469ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 28 07 29 5m36s 11s613ms 08 12 9m55s 49s651ms 09 32 15m3s 28s231ms 10 44 17m58s 24s518ms 11 15 25m36s 1m42s 12 3 6m4s 2m1s 13 24 55s829ms 2s326ms 14 12 10m52s 54s383ms 15 40 23m5s 34s633ms 16 32 8m57s 16s790ms 17 40 43s774ms 1s94ms [ User: intelifix - Total duration: 2h4m50s - Times executed: 283 ]
[ Application: [unknown] - Total duration: 2h4m50s - Times executed: 283 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-07-01''),DATE(''2026-07-27'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-07-28 15:42:46 Duration: 6m17s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027695, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-28 10:25:24 Duration: 6m12s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027704, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');
Date: 2026-07-28 11:37:22 Duration: 6m5s Database: rio User: intelifix Remote: [local] Application: [unknown]
4 274 10m6s 199ms 9s313ms 2s213ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 28 00 12 27s944ms 2s328ms 01 12 19s443ms 1s620ms 02 12 20s325ms 1s693ms 03 12 21s445ms 1s787ms 04 12 21s910ms 1s825ms 05 12 23s3ms 1s916ms 06 12 21s322ms 1s776ms 07 12 24s927ms 2s77ms 08 12 23s822ms 1s985ms 09 12 38s31ms 3s169ms 10 12 40s419ms 3s368ms 11 12 26s535ms 2s211ms 12 12 27s289ms 2s274ms 13 12 26s60ms 2s171ms 14 12 28s874ms 2s406ms 15 12 31s30ms 2s585ms 16 12 36s156ms 3s13ms 17 12 26s410ms 2s200ms 18 12 22s828ms 1s902ms 19 11 22s737ms 2s67ms 20 11 27s233ms 2s475ms 21 12 25s70ms 2s89ms 22 12 23s706ms 1s975ms [ User: intelifix - Total duration: 10m6s - Times executed: 274 ]
[ Application: psql - Total duration: 10m6s - Times executed: 274 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-28 00:05:24 Duration: 9s313ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-28 16:25:12 Duration: 8s412ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-28 10:25:16 Duration: 8s93ms Database: rio User: intelifix Remote: [local] Application: psql
5 156 7m33s 199ms 13s352ms 2s907ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 28 00 6 21s896ms 3s649ms 01 6 9s937ms 1s656ms 02 4 7s112ms 1s778ms 03 5 6s803ms 1s360ms 04 6 9s553ms 1s592ms 05 2 5s604ms 2s802ms 06 1 947ms 947ms 07 9 34s68ms 3s785ms 08 12 40s87ms 3s340ms 09 12 50s71ms 4s172ms 10 12 47s834ms 3s986ms 11 12 49s128ms 4s94ms 12 11 40s140ms 3s649ms 13 10 10s565ms 1s56ms 14 12 41s930ms 3s494ms 15 12 38s567ms 3s213ms 16 9 18s617ms 2s68ms 17 4 3s579ms 894ms 21 5 8s266ms 1s653ms 22 6 8s919ms 1s486ms [ User: intelifix - Total duration: 7m33s - Times executed: 156 ]
[ Application: psql - Total duration: 7m33s - Times executed: 156 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-28 00:05:14 Duration: 13s352ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-28 10:15:11 Duration: 9s681ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-28 11:35:10 Duration: 8s823ms Database: rio User: intelifix Remote: [local] Application: psql
6 134 28s926ms 150ms 403ms 215ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 28 04 2 460ms 230ms 05 15 3s31ms 202ms 07 8 1s955ms 244ms 08 6 1s243ms 207ms 09 17 3s420ms 201ms 10 25 5s678ms 227ms 11 10 2s116ms 211ms 12 5 1s217ms 243ms 14 16 3s391ms 211ms 15 15 3s419ms 227ms 16 10 2s10ms 201ms 17 5 980ms 196ms [ User: intelifix - Total duration: 28s926ms - Times executed: 134 ]
[ Application: [unknown] - Total duration: 28s926ms - Times executed: 134 ]
-
SELECT * FROM RS_TRIAGEM (310, 5, '77', 2, 'C85D3857A1D3,D86C5A40673D,D86C5A535DF1,C85D38769D37,D86C5A0106F9,C85D38606147,C85D38A81CFA,C85D38D807E3,C85D38EF3A51,C85D38D82E08,C85D385FCAEA,C85D38F3A76A,C85D38A10BC7,C85D3807DF2D,D86C5A001AB9,C85D38D81BE7,D86C5A658B07,8C444FD587C7,C85D38F00EDC,C85D38F7614E,C85D38079601,8C444FD8FE5F,C85D38FB7BB7,C85D3871E21B,D86C5A511E51,C85D38A21D06', NULL, NULL, 0151, 00);
Date: 2026-07-28 10:35:25 Duration: 403ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (430, 5, '138', 6, '9877E77D6DE3,743AEF1417A1,840112291375,9877E749DC0F,743AEF759001,9877E70A7FF0,9877E77CB360,9877E70A7C4D,9877E77CFBF9,840112DD9F17,9877E70AD302,9877E77D3E17,743AEF5E1DE6,1834AF257C0E,743AEFAEF689,9877E77C6B4C,840112EC78A7,9877E749DCA9,9877E7002AF4,743AEF3310BF,9877E7074A03,9877E749B469,743AEF72FEB0,8401122ADFA0,84011238B4D2,8401125FAC16,9877E77CD381,9877E7BCEE37,9877E7BBD002,84011295BE39,84011238D91B,84011295C8F8,9877E7B90D3A', NULL, NULL, 0153, 00);
Date: 2026-07-28 15:01:31 Duration: 398ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (310, 5, '87', 2, '9877E77C3712,743AEF74D22F,8401129600B9,9877E709388D,743AEFC55778,8401127F7510,743AEF71E3B5,1834AF9A181C,743AEF961BFC,84011280577F,1834AF28837F,84011205C0DE,9877E74EB507,84011281EC44,84011206F7E0,743AEF9A73EF,9877E77DBC33,840112083EB7,743AEF5D789B,84011227B07B,9877E74CE586,743AEFDC6882,743AEF957F9B,9877E74E5BEA,9877E74944A8', NULL, NULL, 0153, 00);
Date: 2026-07-28 10:11:46 Duration: 388ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 126 20s667ms 150ms 244ms 164ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 28 05 1 156ms 156ms 08 15 2s492ms 166ms 09 23 3s765ms 163ms 10 20 3s268ms 163ms 11 7 1s140ms 162ms 13 10 1s640ms 164ms 14 15 2s396ms 159ms 15 16 2s630ms 164ms 16 18 3s16ms 167ms 17 1 161ms 161ms [ User: intelifix - Total duration: 20s667ms - Times executed: 126 ]
[ Application: [unknown] - Total duration: 20s667ms - Times executed: 126 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0141;
Date: 2026-07-28 15:31:34 Duration: 244ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0155;
Date: 2026-07-28 09:51:56 Duration: 222ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0318;
Date: 2026-07-28 16:08:28 Duration: 206ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 105 1m1s 151ms 3s29ms 581ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 28 07 25 13s119ms 524ms 09 2 5s507ms 2s753ms 10 20 9s162ms 458ms 11 4 2s166ms 541ms 13 15 7s731ms 515ms 14 2 3s732ms 1s866ms 15 12 6s959ms 579ms 16 7 4s606ms 658ms 17 18 8s95ms 449ms [ User: intelifix - Total duration: 1m1s - Times executed: 105 ]
[ Application: [unknown] - Total duration: 1m1s - Times executed: 105 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0121922) LIMIT 1;
Date: 2026-07-28 09:29:16 Duration: 3s29ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0271589) LIMIT 1;
Date: 2026-07-28 14:57:49 Duration: 2s557ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0127497) LIMIT 1;
Date: 2026-07-28 09:33:05 Duration: 2s477ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
9 102 47s540ms 274ms 810ms 466ms 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 #9
Day Hour Count Duration Avg duration Jul 28 00 1 472ms 472ms 04 1 340ms 340ms 05 2 796ms 398ms 06 1 395ms 395ms 07 7 2s714ms 387ms 08 9 3s978ms 442ms 09 10 4s235ms 423ms 10 11 5s302ms 482ms 11 7 3s403ms 486ms 12 6 2s516ms 419ms 13 8 3s768ms 471ms 14 8 4s170ms 521ms 15 11 5s984ms 544ms 16 9 4s563ms 507ms 17 6 2s828ms 471ms 21 3 1s113ms 371ms 22 1 373ms 373ms 23 1 582ms 582ms [ User: lenon - Total duration: 47s540ms - Times executed: 102 ]
[ Application: [unknown] - Total duration: 47s540ms - Times executed: 102 ]
-
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-07-28 15:31:31 Duration: 810ms 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-07-28 15:28:02 Duration: 808ms 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-07-28 10:05:30 Duration: 751ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
10 94 55s468ms 347ms 913ms 590ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 28 00 1 704ms 704ms 04 1 493ms 493ms 05 2 1s53ms 526ms 07 5 2s398ms 479ms 08 9 5s5ms 556ms 09 10 5s283ms 528ms 10 11 6s540ms 594ms 11 7 4s361ms 623ms 12 5 2s838ms 567ms 13 7 4s172ms 596ms 14 8 5s58ms 632ms 15 11 7s371ms 670ms 16 9 5s546ms 616ms 17 6 3s382ms 563ms 21 1 347ms 347ms 23 1 909ms 909ms [ User: intelifix - Total duration: 55s468ms - Times executed: 94 ]
[ Application: [unknown] - Total duration: 55s468ms - Times executed: 94 ]
-
select * from rs_menu_grants (417, 18, 1);
Date: 2026-07-28 15:27:48 Duration: 913ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (477, 19, 1);
Date: 2026-07-28 23:29:00 Duration: 909ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (414, 21, 1);
Date: 2026-07-28 10:05:30 Duration: 905ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 92 38s235ms 159ms 824ms 415ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 28 07 3 1s83ms 361ms 08 9 3s204ms 356ms 09 16 6s841ms 427ms 10 9 3s768ms 418ms 11 4 1s634ms 408ms 12 3 1s107ms 369ms 13 6 2s473ms 412ms 14 4 1s675ms 418ms 15 11 4s478ms 407ms 16 16 7s360ms 460ms 17 11 4s608ms 418ms [ User: intelifix - Total duration: 38s235ms - Times executed: 92 ]
[ Application: [unknown] - Total duration: 38s235ms - Times executed: 92 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 085;
Date: 2026-07-28 13:29:57 Duration: 824ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-07-28 16:50:30 Duration: 712ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-07-28 09:40:59 Duration: 687ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 89 18m12s 9s302ms 38s800ms 12s272ms create table temp0000286664 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 28 07 9 1m31s 10s213ms 08 18 3m31s 11s759ms 09 9 1m46s 11s781ms 10 17 3m32s 12s497ms 11 8 1m34s 11s831ms 14 5 1m31s 18s206ms 15 16 3m17s 12s373ms 16 7 1m26s 12s362ms [ User: intelifix - Total duration: 18m12s - Times executed: 89 ]
[ Application: [unknown] - Total duration: 18m12s - Times executed: 89 ]
-
CREATE TABLE temp0000286664 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-28 14:34:21 Duration: 38s800ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286664 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-28 10:37:28 Duration: 23s160ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286664 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-28 15:09:22 Duration: 15s93ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 75 15s628ms 152ms 409ms 208ms create table temp0000286536 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 28 07 2 364ms 182ms 08 2 306ms 153ms 09 6 1s185ms 197ms 10 12 2s378ms 198ms 11 33 6s374ms 193ms 12 6 1s170ms 195ms 16 7 1s786ms 255ms 17 7 2s61ms 294ms [ User: intelifix - Total duration: 15s628ms - Times executed: 75 ]
[ Application: [unknown] - Total duration: 15s628ms - Times executed: 75 ]
-
CREATE TABLE temp0000286536 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"23-07-2026", "ate" :"28-07-2026", "nota-fiscal":"441", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-28 16:58:31 Duration: 409ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286536 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"23-07-2026", "ate" :"28-07-2026", "nota-fiscal":"441", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-28 17:02:23 Duration: 376ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286536 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"23-07-2026", "ate" :"28-07-2026", "nota-fiscal":"441", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-28 17:05:24 Duration: 345ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 71 12s568ms 150ms 251ms 177ms create table temp0000286572 as select * from rs_baixas_lista (?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 28 13 4 692ms 173ms 15 49 8s692ms 177ms 16 18 3s183ms 176ms [ User: intelifix - Total duration: 12s568ms - Times executed: 71 ]
[ Application: [unknown] - Total duration: 12s568ms - Times executed: 71 ]
-
CREATE TABLE temp0000286572 AS SELECT * FROM RS_BAIXAS_LISTA (06, 00, 00, 0310, 00, '', '2026-07-26', '2026-07-28');
Date: 2026-07-28 16:12:45 Duration: 251ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286572 AS SELECT * FROM RS_BAIXAS_LISTA (06, 00, 00, 0310, 00, '', '2026-07-26', '2026-07-28');
Date: 2026-07-28 15:25:07 Duration: 228ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286572 AS SELECT * FROM RS_BAIXAS_LISTA (06, 00, 00, 0310, 00, '', '2026-07-26', '2026-07-28');
Date: 2026-07-28 16:01:59 Duration: 219ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 66 1m55s 203ms 48s244ms 1s746ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 28 07 4 2s79ms 519ms 08 7 8s982ms 1s283ms 09 10 24s595ms 2s459ms 10 6 2s557ms 426ms 11 5 2s42ms 408ms 12 2 48s628ms 24s314ms 14 3 2s284ms 761ms 15 8 4s253ms 531ms 16 6 16s75ms 2s679ms 17 15 3s755ms 250ms [ User: intelifix - Total duration: 1m55s - Times executed: 66 ]
[ Application: psql - Total duration: 1m55s - Times executed: 66 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027706);
Date: 2026-07-28 12:09:19 Duration: 48s244ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027694);
Date: 2026-07-28 09:51:26 Duration: 10s745ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027722);
Date: 2026-07-28 16:25:30 Duration: 10s662ms Database: rio User: intelifix Remote: [local] Application: psql
16 64 12s814ms 150ms 841ms 200ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 28 06 3 2s36ms 678ms 07 1 154ms 154ms 08 1 259ms 259ms 10 2 318ms 159ms 11 3 488ms 162ms 13 4 768ms 192ms 14 2 339ms 169ms 15 8 1s313ms 164ms 16 28 4s904ms 175ms 17 12 2s231ms 185ms [ User: intelifix - Total duration: 12s814ms - Times executed: 64 ]
[ Application: [unknown] - Total duration: 12s814ms - Times executed: 64 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "362", "data-de" : "2026-07-27", "data-ate" : "2026-07-27", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 416 }');
Date: 2026-07-28 06:55:33 Duration: 841ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "364", "data-de" : "2026-07-27", "data-ate" : "2026-07-27", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 416 }');
Date: 2026-07-28 06:55:47 Duration: 608ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "363", "data-de" : "2026-07-27", "data-ate" : "2026-07-27", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 416 }');
Date: 2026-07-28 06:55:39 Duration: 585ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 56 11m31s 1s40ms 47s51ms 12s339ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 28 07 2 14s297ms 7s148ms 08 2 49s917ms 24s958ms 09 4 28s187ms 7s46ms 10 6 2m26s 24s404ms 11 2 14s574ms 7s287ms 12 5 59s794ms 11s958ms 13 5 54s307ms 10s861ms 14 5 1m6s 13s227ms 15 7 36s963ms 5s280ms 16 9 2m2s 13s557ms 17 9 1m38s 10s934ms [ User: intelifix - Total duration: 11m31s - Times executed: 56 ]
[ Application: [unknown] - Total duration: 11m31s - Times executed: 56 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-28', 0175, '', '', 0, 6, '2026-07-01');
Date: 2026-07-28 16:32:54 Duration: 47s51ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-28', 0320, '', '', 0, 6, '2026-07-01');
Date: 2026-07-28 10:15:09 Duration: 46s184ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-28', 0320, '', '', 0, 6, '2026-07-01');
Date: 2026-07-28 08:59:32 Duration: 41s726ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 52 16s721ms 150ms 2s808ms 321ms create table temp0000236964 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 28 07 1 2s808ms 2s808ms 08 1 157ms 157ms 09 4 644ms 161ms 10 3 482ms 160ms 11 1 154ms 154ms 12 1 192ms 192ms 13 3 2s924ms 974ms 14 5 867ms 173ms 15 12 4s467ms 372ms 16 3 549ms 183ms 17 18 3s472ms 192ms [ User: intelifix - Total duration: 16s721ms - Times executed: 52 ]
[ Application: [unknown] - Total duration: 16s721ms - Times executed: 52 ]
-
CREATE TABLE temp0000236964 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"7", "cliente" :"0", "desde" :"23-07-2026", "ate" :"28-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-28 07:56:17 Duration: 2s808ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000236964 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"7", "cliente" :"0", "desde" :"23-07-2026", "ate" :"28-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-28 15:32:29 Duration: 2s516ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000236964 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"7", "cliente" :"0", "desde" :"23-07-2026", "ate" :"28-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-28 13:11:09 Duration: 1s391ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
19 49 13s173ms 151ms 1s68ms 268ms create table temp0000226620 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 28 09 4 707ms 176ms 10 7 1s354ms 193ms 11 3 650ms 216ms 13 7 2s821ms 403ms 14 14 3s858ms 275ms 15 4 1s57ms 264ms 16 6 1s658ms 276ms 17 4 1s64ms 266ms [ User: intelifix - Total duration: 13s173ms - Times executed: 49 ]
[ Application: [unknown] - Total duration: 13s173ms - Times executed: 49 ]
-
CREATE TABLE temp0000226620 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"23-07-2026", "ate" :"28-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-28 13:14:07 Duration: 1s68ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000226620 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"23-07-2026", "ate" :"28-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-28 14:04:29 Duration: 667ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000226620 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"23-07-2026", "ate" :"28-07-2026", "nota-fiscal":"2826", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-28 13:05:03 Duration: 468ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
20 48 2h3m5s 1s408ms 8m52s 2m33s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 28 07 3 8m9s 2m43s 08 3 7m17s 2m25s 09 3 9m33s 3m11s 10 3 8m50s 2m56s 11 3 8m49s 2m56s 12 3 7m28s 2m29s 13 3 7m50s 2m36s 14 3 7m50s 2m36s 15 3 9m2s 3m 16 3 8m56s 2m58s 17 3 9m2s 3m 18 3 6m2s 2m 19 3 6m1s 2m 20 3 6m6s 2m2s 21 3 6m6s 2m2s 22 3 5m57s 1m59s [ User: intelifix - Total duration: 2h3m5s - Times executed: 48 ]
[ Application: psql - Total duration: 2h3m5s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-28 09:13:53 Duration: 8m52s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-28 10:13:24 Duration: 8m22s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-28 15:13:23 Duration: 8m22s Database: rio User: intelifix Remote: [local] Application: psql
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m18s 8m47s 5m7s 3 15m22s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 28 05 3 15m22s 5m7s [ User: intelifix - Total duration: 15m22s - Times executed: 3 ]
[ Application: psql - Total duration: 15m22s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-28 05:08:49 Duration: 8m47s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-28 05:13:05 Duration: 4m16s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-28 05:15:23 Duration: 2m18s Database: contagem User: intelifix Remote: [local] Application: psql
2 4m32s 4m32s 4m32s 1 4m32s select * from rs_smart_fiscal_saida () / 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 #2
Day Hour Count Duration Avg duration Jul 28 09 1 4m32s 4m32s [ User: intelifix - Total duration: 4m32s - Times executed: 1 ]
[ Application: psql - Total duration: 4m32s - Times executed: 1 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-28 09:20:10 Duration: 4m32s Database: brasilia User: intelifix Remote: [local] Application: psql
3 1s408ms 8m52s 2m33s 48 2h3m5s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 28 07 3 8m9s 2m43s 08 3 7m17s 2m25s 09 3 9m33s 3m11s 10 3 8m50s 2m56s 11 3 8m49s 2m56s 12 3 7m28s 2m29s 13 3 7m50s 2m36s 14 3 7m50s 2m36s 15 3 9m2s 3m 16 3 8m56s 2m58s 17 3 9m2s 3m 18 3 6m2s 2m 19 3 6m1s 2m 20 3 6m6s 2m2s 21 3 6m6s 2m2s 22 3 5m57s 1m59s [ User: intelifix - Total duration: 2h3m5s - Times executed: 48 ]
[ Application: psql - Total duration: 2h3m5s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-28 09:13:53 Duration: 8m52s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-28 10:13:24 Duration: 8m22s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-28 15:13:23 Duration: 8m22s Database: rio User: intelifix Remote: [local] Application: psql
4 255ms 4m34s 1m31s 47 1h11m42s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 28 07 3 4m45s 1m35s 08 3 4m41s 1m33s 09 2 1m10s 35s7ms 10 3 5m22s 1m47s 11 3 5m20s 1m46s 12 3 4m29s 1m29s 13 3 4m36s 1m32s 14 3 5m12s 1m44s 15 3 5m16s 1m45s 16 3 5m13s 1m44s 17 3 5m31s 1m50s 18 3 3m45s 1m15s 19 3 3m52s 1m17s 20 3 4m22s 1m27s 21 3 4m3s 1m21s 22 3 4m 1m20s [ User: intelifix - Total duration: 1h11m42s - Times executed: 47 ]
[ Application: psql - Total duration: 1h11m42s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-28 10:19:09 Duration: 4m34s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-28 17:19:25 Duration: 4m32s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-28 15:19:10 Duration: 4m24s Database: brasilia User: intelifix Remote: [local] Application: psql
5 4s230ms 1m27s 45s22ms 4 3m copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 28 20 2 1m27s 43s699ms 23 2 1m32s 46s344ms [ User: intelifix - Total duration: 3m - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-28 23:16:41 Duration: 1m27s 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-07-28 20:08:27 Duration: 1m23s 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-07-28 23:35:35 Duration: 4s725ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 319ms 56s815ms 27s948ms 4 1m51s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 28 20 2 54s649ms 27s324ms 23 2 57s144ms 28s572ms [ User: intelifix - Total duration: 1m51s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m51s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-28 23:13:31 Duration: 56s815ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-28 20:05:25 Duration: 54s330ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-28 23:35:01 Duration: 329ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 157ms 6m17s 26s469ms 283 2h4m50s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 28 07 29 5m36s 11s613ms 08 12 9m55s 49s651ms 09 32 15m3s 28s231ms 10 44 17m58s 24s518ms 11 15 25m36s 1m42s 12 3 6m4s 2m1s 13 24 55s829ms 2s326ms 14 12 10m52s 54s383ms 15 40 23m5s 34s633ms 16 32 8m57s 16s790ms 17 40 43s774ms 1s94ms [ User: intelifix - Total duration: 2h4m50s - Times executed: 283 ]
[ Application: [unknown] - Total duration: 2h4m50s - Times executed: 283 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-07-01''),DATE(''2026-07-27'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-07-28 15:42:46 Duration: 6m17s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027695, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-28 10:25:24 Duration: 6m12s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027704, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');
Date: 2026-07-28 11:37:22 Duration: 6m5s Database: rio User: intelifix Remote: [local] Application: [unknown]
8 11s51ms 14s825ms 12s646ms 13 2m44s create table temp0000286708 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 28 09 13 2m44s 12s646ms [ User: intelifix - Total duration: 2m44s - Times executed: 13 ]
[ Application: [unknown] - Total duration: 2m44s - Times executed: 13 ]
-
CREATE TABLE temp0000286708 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-28 09:42:21 Duration: 14s825ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286708 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-28 09:44:43 Duration: 13s909ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286708 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-28 09:10:57 Duration: 13s846ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 1s40ms 47s51ms 12s339ms 56 11m31s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 28 07 2 14s297ms 7s148ms 08 2 49s917ms 24s958ms 09 4 28s187ms 7s46ms 10 6 2m26s 24s404ms 11 2 14s574ms 7s287ms 12 5 59s794ms 11s958ms 13 5 54s307ms 10s861ms 14 5 1m6s 13s227ms 15 7 36s963ms 5s280ms 16 9 2m2s 13s557ms 17 9 1m38s 10s934ms [ User: intelifix - Total duration: 11m31s - Times executed: 56 ]
[ Application: [unknown] - Total duration: 11m31s - Times executed: 56 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-28', 0175, '', '', 0, 6, '2026-07-01');
Date: 2026-07-28 16:32:54 Duration: 47s51ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-28', 0320, '', '', 0, 6, '2026-07-01');
Date: 2026-07-28 10:15:09 Duration: 46s184ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-28', 0320, '', '', 0, 6, '2026-07-01');
Date: 2026-07-28 08:59:32 Duration: 41s726ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 9s302ms 38s800ms 12s272ms 89 18m12s create table temp0000286664 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 28 07 9 1m31s 10s213ms 08 18 3m31s 11s759ms 09 9 1m46s 11s781ms 10 17 3m32s 12s497ms 11 8 1m34s 11s831ms 14 5 1m31s 18s206ms 15 16 3m17s 12s373ms 16 7 1m26s 12s362ms [ User: intelifix - Total duration: 18m12s - Times executed: 89 ]
[ Application: [unknown] - Total duration: 18m12s - Times executed: 89 ]
-
CREATE TABLE temp0000286664 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-28 14:34:21 Duration: 38s800ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286664 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-28 10:37:28 Duration: 23s160ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286664 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-28 15:09:22 Duration: 15s93ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 9s345ms 13s976ms 11s974ms 25 4m59s create table temp0000286776 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 28 17 25 4m59s 11s974ms [ User: intelifix - Total duration: 4m59s - Times executed: 25 ]
[ Application: [unknown] - Total duration: 4m59s - Times executed: 25 ]
-
CREATE TABLE temp0000286776 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-28 17:02:33 Duration: 13s976ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286776 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-28 17:16:09 Duration: 13s912ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286776 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-28 17:15:47 Duration: 13s620ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 9s723ms 13s247ms 11s535ms 10 1m55s create table temp0000286664 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?) notice: table "tmp_entrada" does not exist, skipping;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 28 07 3 30s580ms 10s193ms 08 1 13s239ms 13s239ms 10 1 13s247ms 13s247ms 11 1 10s184ms 10s184ms 14 1 12s990ms 12s990ms 15 1 12s111ms 12s111ms 16 2 23s1ms 11s500ms [ User: intelifix - Total duration: 1m55s - Times executed: 10 ]
[ Application: [unknown] - Total duration: 1m55s - Times executed: 10 ]
-
CREATE TABLE temp0000286664 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06) NOTICE: table "tmp_entrada" does not exist, skipping;
Date: 2026-07-28 10:44:45 Duration: 13s247ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286664 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06) NOTICE: table "tmp_entrada" does not exist, skipping;
Date: 2026-07-28 08:50:34 Duration: 13s239ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286664 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06) NOTICE: table "tmp_entrada" does not exist, skipping;
Date: 2026-07-28 14:35:52 Duration: 12s990ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 758ms 13s11ms 4s14ms 29 1m56s 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 #13
Day Hour Count Duration Avg duration Jul 28 08 3 11s71ms 3s690ms 09 2 14s860ms 7s430ms 10 2 11s483ms 5s741ms 11 1 4s827ms 4s827ms 12 3 8s943ms 2s981ms 13 1 3s602ms 3s602ms 14 2 19s671ms 9s835ms 15 1 5s223ms 5s223ms 16 2 15s147ms 7s573ms 17 2 12s214ms 6s107ms 18 2 1s723ms 861ms 19 2 1s590ms 795ms 20 1 1s278ms 1s278ms 21 2 1s860ms 930ms 22 3 2s916ms 972ms [ User: intelifix - Total duration: 1m56s - Times executed: 29 ]
[ Application: psql - Total duration: 1m56s - Times executed: 29 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-28 14:40:14 Duration: 13s11ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-28 17:00:12 Duration: 10s422ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-28 16:00:09 Duration: 8s745ms Database: rio User: intelifix Remote: [local] Application: psql
14 2s432ms 9s445ms 3s969ms 41 2m42s create table temp0000286664 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 28 07 6 18s120ms 3s20ms 08 16 58s393ms 3s649ms 09 6 20s737ms 3s456ms 11 4 20s969ms 5s242ms 14 2 13s786ms 6s893ms 16 7 30s723ms 4s389ms [ User: intelifix - Total duration: 2m42s - Times executed: 41 ]
[ Application: [unknown] - Total duration: 2m42s - Times executed: 41 ]
-
CREATE TABLE temp0000286664 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"23-07-2026", "ate" :"28-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-28 14:44:53 Duration: 9s445ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286664 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"23-07-2026", "ate" :"28-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-28 11:33:35 Duration: 8s955ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286664 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"23-07-2026", "ate" :"28-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-28 16:29:15 Duration: 4s683ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 234ms 10s658ms 3s153ms 38 1m59s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 28 07 2 12s478ms 6s239ms 08 4 6s475ms 1s618ms 09 3 13s372ms 4s457ms 10 4 17s361ms 4s340ms 11 4 9s66ms 2s266ms 12 2 3s44ms 1s522ms 13 2 1s191ms 595ms 14 2 13s195ms 6s597ms 15 6 21s821ms 3s636ms 16 4 13s32ms 3s258ms 17 5 8s803ms 1s760ms [ User: intelifix - Total duration: 1m59s - Times executed: 38 ]
[ Application: psql - Total duration: 1m59s - Times executed: 38 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027675);
Date: 2026-07-28 07:35:33 Duration: 10s658ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027709);
Date: 2026-07-28 14:36:10 Duration: 10s205ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027695);
Date: 2026-07-28 10:18:48 Duration: 6s486ms Database: rio User: intelifix Remote: [local] Application: psql
16 199ms 13s352ms 2s907ms 156 7m33s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 28 00 6 21s896ms 3s649ms 01 6 9s937ms 1s656ms 02 4 7s112ms 1s778ms 03 5 6s803ms 1s360ms 04 6 9s553ms 1s592ms 05 2 5s604ms 2s802ms 06 1 947ms 947ms 07 9 34s68ms 3s785ms 08 12 40s87ms 3s340ms 09 12 50s71ms 4s172ms 10 12 47s834ms 3s986ms 11 12 49s128ms 4s94ms 12 11 40s140ms 3s649ms 13 10 10s565ms 1s56ms 14 12 41s930ms 3s494ms 15 12 38s567ms 3s213ms 16 9 18s617ms 2s68ms 17 4 3s579ms 894ms 21 5 8s266ms 1s653ms 22 6 8s919ms 1s486ms [ User: intelifix - Total duration: 7m33s - Times executed: 156 ]
[ Application: psql - Total duration: 7m33s - Times executed: 156 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-28 00:05:14 Duration: 13s352ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-28 10:15:11 Duration: 9s681ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-28 11:35:10 Duration: 8s823ms Database: rio User: intelifix Remote: [local] Application: psql
17 199ms 9s313ms 2s213ms 274 10m6s call rs_giga_triagem (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 28 00 12 27s944ms 2s328ms 01 12 19s443ms 1s620ms 02 12 20s325ms 1s693ms 03 12 21s445ms 1s787ms 04 12 21s910ms 1s825ms 05 12 23s3ms 1s916ms 06 12 21s322ms 1s776ms 07 12 24s927ms 2s77ms 08 12 23s822ms 1s985ms 09 12 38s31ms 3s169ms 10 12 40s419ms 3s368ms 11 12 26s535ms 2s211ms 12 12 27s289ms 2s274ms 13 12 26s60ms 2s171ms 14 12 28s874ms 2s406ms 15 12 31s30ms 2s585ms 16 12 36s156ms 3s13ms 17 12 26s410ms 2s200ms 18 12 22s828ms 1s902ms 19 11 22s737ms 2s67ms 20 11 27s233ms 2s475ms 21 12 25s70ms 2s89ms 22 12 23s706ms 1s975ms [ User: intelifix - Total duration: 10m6s - Times executed: 274 ]
[ Application: psql - Total duration: 10m6s - Times executed: 274 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-28 00:05:24 Duration: 9s313ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-28 16:25:12 Duration: 8s412ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-28 10:25:16 Duration: 8s93ms Database: rio User: intelifix Remote: [local] Application: psql
18 203ms 48s244ms 1s746ms 66 1m55s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 28 07 4 2s79ms 519ms 08 7 8s982ms 1s283ms 09 10 24s595ms 2s459ms 10 6 2s557ms 426ms 11 5 2s42ms 408ms 12 2 48s628ms 24s314ms 14 3 2s284ms 761ms 15 8 4s253ms 531ms 16 6 16s75ms 2s679ms 17 15 3s755ms 250ms [ User: intelifix - Total duration: 1m55s - Times executed: 66 ]
[ Application: psql - Total duration: 1m55s - Times executed: 66 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027706);
Date: 2026-07-28 12:09:19 Duration: 48s244ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027694);
Date: 2026-07-28 09:51:26 Duration: 10s745ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027722);
Date: 2026-07-28 16:25:30 Duration: 10s662ms Database: rio User: intelifix Remote: [local] Application: psql
19 150ms 5s937ms 993ms 1,181 19m32s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 28 07 7 5s264ms 752ms 08 94 1m27s 935ms 09 142 2m14s 946ms 10 133 1m56s 874ms 11 146 1m43s 711ms 12 23 6s971ms 303ms 13 92 1m46s 1s154ms 14 140 3m1s 1s296ms 15 119 2m49s 1s420ms 16 153 3m8s 1s234ms 17 132 1m12s 549ms [ User: intelifix - Total duration: 19m32s - Times executed: 1181 ]
[ Application: [unknown] - Total duration: 19m32s - Times executed: 1181 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (48175, 407, '270911020057102061,229787774753,229661271925,229743101819,229813876885,229747692525,229809469205,229755127683,229808990517,229808539507,229746116366,229742237783,229691431726,229742445559,229807210725,229745417375,229860161919,229809307494,229817078095,229755717191,229689923352,229865565667,229684432345,229669949921,229786224759,229686648699,229749238905,229691533150,229748428791,229859992733,229663790409,229690805267,229813330211,229663024666,229812976483,216935954462,229786927992,229812698195,229933312021,229690061121,229737512239,216940443239,229690348702,216944823543,229813528893,229837171011,229688601416,229726564245,229836869208,229735815765,229663788286', '246599052038,246457198383,246547866469,246628939713,246548565763,246628676376,246559036280,246619158387,246619226980,246568874457,246531217392,246517024851,246569460306,246580697800,246539575559,246651803134,246628672235,246631375764,246560886180,246515422125,246649075864,246524870814,246515120222,246601986274,246491499194,246566190223,246506716269,246549501422,246648709510,246468955053,246514144862,246627377798,246491763037,246627997993,246439791321,246597725252,246629632138,246052133757,246516214660,246527639400,246463855577,246521428591,246468023638,246636014354,246639358585,246513870414,246523811126,246639747692,246545036889,246471690203', 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":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-07-28 10:50:57 Duration: 5s937ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (48208, 406, '835120918003490,241673372139,241711111333,241622613537,241663852534,241659752235,241678332735,241618262630,241610024149,230048002541,241672196883,241659740517,241680350104,241700953854,241692663853,241620794953,241692689613,241704219212,241622621619,241695505151,241635757782,241647236770,241629137787,241656766578,241620860011,241673332741,241664810922,241711214956,241731249100,241645800223,241695570310,241676719502,241732062446,241713726772,241676716370,241731202429,241646239614,241703551010,241713701821,241656767790,241692661833,241692665166,241659661620,241673333650,241617429204,241732063860,241637745676,241700930014,241680407684,241614550506,241636120524', '',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":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-28 13:34:28 Duration: 5s323ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (48210, 418, 'ZTE3ANNT2V86514,D83139937A84,D83139937A85,ZTEGDD314471$ZTE3ANNQ8F13506,689E29FD5F69,689E29FD5F6A,ZTEGD7BA3192$ZTE3ANNT2V12177,D831398CAC3E,D831398CAC3F,ZTEGDD302210$ZTE3ANNR9F18235,D89A0DA48945,D89A0DA48946,ZTEGDB156E86$ZTE3ANNQ4N01105,3CF9F0A8AB94,3CF9F0A8AB95,ZTEGD641074C$ZTE3ANNT3F09322,D83139960644,D83139960645,ZTEGDD31B111$ZTE3ANNT3H26867,D8313999394A,D8313999394B,ZTEGDD323992$ZTE3ANNRC575652,6C11BA6916EF,6C11BA6916F0,ZTEGDC6F3D43$ZTE3ANNQ7506311,C4EBFF8B8726,C4EBFF8B8727,ZTEGD70A6747$ZTE3ANNR7B32772,3891484BECBF,3891484BECC0,ZTEGDB081164$ZTE3ANNT2V71503,D83139921AB2,D83139921AB3,ZTEGDD3109CE$ZTE3ANNQ4N02041,3CF9F0A8C184,3CF9F0A8C185,ZTEGD6410AF4$ZTE3ANNR5W76379,48D6823581EC,48D6823581ED,ZTEGDB012A5A$ZTE3ANNR7B33016,3891484BF277,3891484BF278,ZTEGDB081258$ZTE3ANNQCA06665,14CA56D2E111,14CA56D2E112,ZTEGD9717F74$ZTE3ANNR3Y45871,4896D953F3D2,4896D953F3D3,ZTEGD97EE3E4$ZTE3ANNR6R24547,48D68237C414,48D68237C415,ZTEGDB018AB6$ZTE3ANNR3Y03781,4896D9501956,4896D9501957,ZTEGD97E3F7A$ZTE3ANNR5W07722,48D6822F38C6,48D6822F38C7,ZTEGDB001E29$ZTE3ANNR1Y02243,14CA56CCDF0D,14CA56CCDF0E,ZTEGD9707F1E$ZTE3ANNR5W69143,48D68234D854,48D68234D855,ZTEGDB010E16$ZTE3ANNRCB71290,D831392455DA,D831392455DB,ZTEGDD2ACC0F$ZTE3ANNR3Y22505,4896D951D02E,4896D951D02F,ZTEGD97E889E$ZTE3ANNR3J30130,F4E84F89108C,F4E84F89108D,ZTEGD97BD77C$ZTE3ANNQ3611397,3CF9F0A5E08C,3CF9F0A5E08D,ZTEGD6409020$ZTE3ANNRC565508,6C11BA68292F,6C11BA682930,ZTEGDC6F15A3$ZTE3ANNRB737565,5872C991A99F,5872C991A9A0,ZTEGDC61BD90$ZTE3ANNR5W00896,48D6822E98CA,48D6822E98CB,ZTEGDB00037F$ZTE3ANNQ8F09274,689E29FCFC39,689E29FCFC3A,ZTEGD7BA210A$ZTE3ANNRB725227,5872C9908873,5872C9908874,ZTEGDC618D5E$ZTE3ANNT4P14342,F00C514CF6C2,F00C514CF6C3,ZTEGDE342E9C$ZTE3ANNRCB23956,D83139200076,D83139200077,ZTEGDD2A1329$ZTE3ANNR6R28468,48D682381FFA,48D682381FFB,ZTEGDB019A07$ZTE3ANNT3H23543,D8313998EB62,D8313998EB63,ZTEGDD322C96$ZTE3ANNR2Q58697,F4E84F8613B6,F4E84F8613B7,ZTEGD97B5803$ZTE3ANNR5W18059,48D682302B0C,48D682302B0D,ZTEGDB00468A$ZTE3ANNRC551367,6C11BA66DDC1,6C11BA66DDC2,ZTEGDC6EDE66$ZTE3ANNT4P16711,F00C514D2E48,F00C514D2E49,ZTEGDE3437DD$ZTE3ANNRCB67026,D8313923F1EA,D8313923F1EB,ZTEGDD2ABB67$ZTE3ANNRCB61191,D83139236928,D83139236929,ZTEGDD2AA49C$ZTE3ANNR9W44423,D89A0DAC6D4D,D89A0DAC6D4E,ZTEGDB16BF32$ZTE3ANNR5W72135,48D682351E74,48D682351E75,ZTEGDB0119C6$ZTE3ANNRCB23865,D831391FFE54,D831391FFE55,ZTEGDD2A12CE$ZTE3ANNR7B17093,3891484A7D45,3891484A7D46,ZTEGDB07D425$ZTE3ANNRAD25079,D89A0DB0262D,D89A0DB0262E,ZTEGDB175E02$ZTE3ANNR8C25909,38914850E645,38914850E646,ZTEGDB08E5A5$ZTE3ANNQ7T04143,C4EBFF8F4C5A,C4EBFF8F4C5B,ZTEGD70B0825', '',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":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-28 16:22:32 Duration: 5s274ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
20 347ms 913ms 590ms 94 55s468ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 28 00 1 704ms 704ms 04 1 493ms 493ms 05 2 1s53ms 526ms 07 5 2s398ms 479ms 08 9 5s5ms 556ms 09 10 5s283ms 528ms 10 11 6s540ms 594ms 11 7 4s361ms 623ms 12 5 2s838ms 567ms 13 7 4s172ms 596ms 14 8 5s58ms 632ms 15 11 7s371ms 670ms 16 9 5s546ms 616ms 17 6 3s382ms 563ms 21 1 347ms 347ms 23 1 909ms 909ms [ User: intelifix - Total duration: 55s468ms - Times executed: 94 ]
[ Application: [unknown] - Total duration: 55s468ms - Times executed: 94 ]
-
select * from rs_menu_grants (417, 18, 1);
Date: 2026-07-28 15:27:48 Duration: 913ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (477, 19, 1);
Date: 2026-07-28 23:29:00 Duration: 909ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (414, 21, 1);
Date: 2026-07-28 10:05:30 Duration: 905ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 5 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jul 28 13 1 0ms 0ms 20 3 0ms 0ms 21 1 0ms 0ms [ User: intelifix - Total duration: 6s259ms - Times executed: 5 ]
[ Application: psql - Total duration: 5s699ms - Times executed: 4 ]
[ Application: [unknown] - Total duration: 560ms - Times executed: 1 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 16,594 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 19 FATAL entries
- 3531 ERROR entries
- 0 WARNING entries
- 7 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 3,340 Max number of times the same event was reported
- 3,557 Total events found
Rank Times reported Error 1 3,340 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 28 00 60 01 59 02 57 03 53 04 57 05 59 06 61 07 211 08 380 09 333 10 348 11 317 12 176 13 100 14 363 15 311 16 282 17 113 - ERROR: prepared statement "_PLAN000000002ED04E10" does not exist
- ERROR: prepared statement "_PLAN000000002ED032B0" does not exist
- ERROR: prepared statement "_PLAN000000002ED04E10" does not exist
Statement: DEALLOCATE "_PLAN000000002ED04E10"
Date: 2026-07-28 00:00:08 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN000000002ED032B0"
Date: 2026-07-28 00:01:08 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN000000002ED04E10"
Date: 2026-07-28 00:02:09 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 75 ERROR: update or delete on table "..." violates foreign key constraint "..." on table "..."
Times Reported Most Frequent Error / Event #2
Day Hour Count Jul 28 12 71 13 4 - ERROR: update or delete on table "lote_itens" violates foreign key constraint "nf_entrada_itens_li_id_fkey" on table "nf_entrada_itens"
- ERROR: update or delete on table "lote_itens" violates foreign key constraint "nf_entrada_itens_li_id_fkey" on table "nf_entrada_itens"
- ERROR: update or delete on table "lote_itens" violates foreign key constraint "nf_entrada_itens_li_id_fkey" on table "nf_entrada_itens"
Detail: Key (li_id)=(1760280) is still referenced from table "nf_entrada_itens".
Context: SQL statement "DELETE FROM LOTE_ITENS WHERE EQ_ID = REC.EQ_ID" PL/pgSQL function rs_lote_exclui(integer) line 82 at SQL statement
Statement: SELECT * FROM RS_LOTE_EXCLUI(0130188);Date: 2026-07-28 12:53:12 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Detail: Key (li_id)=(1760280) is still referenced from table "nf_entrada_itens".
Context: SQL statement "DELETE FROM LOTE_ITENS WHERE EQ_ID = REC.EQ_ID" PL/pgSQL function rs_lote_exclui(integer) line 82 at SQL statement
Statement: SELECT * FROM RS_LOTE_EXCLUI(0130188);Date: 2026-07-28 12:54:03 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Detail: Key (li_id)=(1760280) is still referenced from table "nf_entrada_itens".
Context: SQL statement "DELETE FROM LOTE_ITENS WHERE EQ_ID = REC.EQ_ID" PL/pgSQL function rs_lote_exclui(integer) line 82 at SQL statement
Statement: SELECT * FROM RS_LOTE_EXCLUI(0130188);Date: 2026-07-28 12:54:05 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
3 44 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #3
Day Hour Count Jul 28 00 2 01 2 02 2 03 2 04 2 05 2 06 2 07 2 08 2 09 2 10 2 11 2 12 2 13 2 14 2 15 2 16 2 17 2 18 2 19 2 20 1 21 1 22 2 - ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-28 00:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-28 00:35:01 Database: brasilia Application: psql User: intelifix Remote: [local]
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-28 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
4 44 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #4
Day Hour Count Jul 28 08 3 09 3 10 3 11 3 12 3 13 3 14 3 15 3 16 3 17 3 18 3 19 3 20 2 21 3 22 3 - ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-28 08:00:05 Database: brasilia Application: psql User: intelifix Remote: [local]
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-28 08:20:10 Database: brasilia Application: psql User: intelifix Remote: [local]
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-28 08:40:03 Database: brasilia Application: psql User: intelifix Remote: [local]
5 9 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #5
Day Hour Count Jul 28 09 2 10 2 11 2 16 3 - ERROR: trailing junk after numeric literal at or near "5CFA25AC79F5" at character 27
- ERROR: trailing junk after numeric literal at or near "5CFA25AC79F5" at character 27
- ERROR: trailing junk after numeric literal at or near "80D04ABFD9C0" at character 27
Statement: select * from rs_caixa_qr(5CFA25AC79F5)
Date: 2026-07-28 09:24:11 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(5CFA25AC79F5)
Date: 2026-07-28 09:24:12 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(80D04ABFD9C0)
Date: 2026-07-28 10:52:50 Database: rio Application: [unknown] User: etiquetas Remote: [local]
6 9 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #6
Day Hour Count Jul 28 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-07-28 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-07-28 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-07-28 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
7 7 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Jul 28 00 1 06 1 08 1 14 1 22 2 23 1 - FATAL: database "testes" does not exist
- FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-07-28 00:02:39 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-07-28 06:02:39 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-07-28 08:48:30 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
8 4 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #8
Day Hour Count Jul 28 09 1 12 1 13 2 - ERROR: syntax error at or near "]" at character 35
- ERROR: syntax error at or near "229974579202" at character 41
- ERROR: syntax error at or near "\" at character 35
Statement: select * from rs_caixa_qr(3351040 ])
Date: 2026-07-28 09:12:08 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''229974579202');
Date: 2026-07-28 12:11:59 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: select * from rs_caixa_qr(3356643 \)
Date: 2026-07-28 13:54:13 Database: rio Application: [unknown] User: etiquetas Remote: [local]
9 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #9
Day Hour Count Jul 28 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-07-28 05:32:05 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-28 05:32:05 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-28 05:32:05 Database: contagem Application: psql User: intelifix Remote: [local]
10 4 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #10
Day Hour Count Jul 28 11 3 15 1 - LOG: process 2912580 still waiting for ShareLock on transaction 3435229 after 1000.079 ms
- LOG: process 2912580 still waiting for ShareLock on transaction 3435229 after 7652.424 ms
- LOG: process 2912580 still waiting for ShareLock on transaction 3435229 after 84749.918 ms
Detail: Process holding the lock: 2883941. Wait queue: 2912580.
Context: while deleting tuple (69445,143) in relation "codigos_barra" SQL statement "DELETE FROM CODIGOS_BARRA WHERE EQ_ID = cRet.ID" PL/pgSQL function rs_equipamento_manutencao(integer,integer,integer,integer,integer,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying) line 655 at SQL statement SQL statement "SELECT * FROM RS_EQUIPAMENTO_MANUTENCAO( 0,5,34,6,502,'465043426372','','465043426372','216475549292',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);" PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 920 at EXECUTE PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 027704, 0502 )' , '/var/www/html/tmp/nf_carga_lotes_0502.xlsx' )Date: 2026-07-28 11:31:20 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 2883941. Wait queue: 2912580.
Context: while deleting tuple (69445,143) in relation "codigos_barra" SQL statement "DELETE FROM CODIGOS_BARRA WHERE EQ_ID = cRet.ID" PL/pgSQL function rs_equipamento_manutencao(integer,integer,integer,integer,integer,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying) line 655 at SQL statement SQL statement "SELECT * FROM RS_EQUIPAMENTO_MANUTENCAO( 0,5,34,6,502,'465043426372','','465043426372','216475549292',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);" PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 920 at EXECUTE PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 027704, 0502 )' , '/var/www/html/tmp/nf_carga_lotes_0502.xlsx' )Date: 2026-07-28 11:31:26 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 2883941. Wait queue: 2912580.
Context: while deleting tuple (69445,143) in relation "codigos_barra" SQL statement "DELETE FROM CODIGOS_BARRA WHERE EQ_ID = cRet.ID" PL/pgSQL function rs_equipamento_manutencao(integer,integer,integer,integer,integer,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying) line 655 at SQL statement SQL statement "SELECT * FROM RS_EQUIPAMENTO_MANUTENCAO( 0,5,34,6,502,'465043426372','','465043426372','216475549292',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);" PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 920 at EXECUTE PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 027704, 0502 )' , '/var/www/html/tmp/nf_carga_lotes_0502.xlsx' )Date: 2026-07-28 11:32:44 Database: rio Application: [unknown] User: intelifix Remote: [local]
11 3 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #11
Day Hour Count Jul 28 15 1 16 2 - ERROR: column "pas_id" does not exist at character 66 2026-07-28 15:16:41 -03 [3038418]: [41-1] user=intelifix,db=brasilia,app=[unknown],client=[local] QUERY: SELECT * FROM PARTE_MOVIMENTOS WHERE PM_ID = ANY( aPMs ) AND PAS_ID = nPasso
- ERROR: column "v" does not exist at character 27
- ERROR: column "v" does not exist at character 27
Context: PL/pgSQL function rs_caixa_kits_exclui(integer,integer) line 46 at FOR over SELECT rows PL/pgSQL function rs_lote_saida_exclui(integer) line 87 at assignment
Hint: Perhaps you meant to reference the column "parte_movimentos.ps_id".
Statement: SELECT * FROM RS_LOTE_SAIDA_EXCLUI(0119119);Date: 2026-07-28 15:16:41 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Statement: select * from rs_caixa_qr(V)
Date: 2026-07-28 16:40:33 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(V)
Date: 2026-07-28 16:40:34 Database: rio Application: [unknown] User: etiquetas Remote: [local]
12 3 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #12
Day Hour Count Jul 28 03 3 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-07-28 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-07-28 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-07-28 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
13 2 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv' PL/Python function "...", line 21, in <module> os.chmod(...) PL/Python function "..." PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Times Reported Most Frequent Error / Event #13
Day Hour Count Jul 28 20 1 21 1 - ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv' PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv' PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Context: Traceback (most recent call last):
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-28 20:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
Context: Traceback (most recent call last):
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-28 21:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
14 2 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #14
Day Hour Count Jul 28 10 1 17 1 - LOG: process 2884042 still waiting for AccessExclusiveLock on relation 3028367 of database 358220 after 1000.109 ms
- LOG: process 3203585 still waiting for AccessExclusiveLock on relation 3057122 of database 358220 after 1000.170 ms
Detail: Process holding the lock: 2893689. Wait queue: 2884042.
Statement: DROP TABLE IF EXISTS temp0000286664;Date: 2026-07-28 10:45:09 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 3204101. Wait queue: 3203585.
Statement: DROP TABLE IF EXISTS temp0000286776;Date: 2026-07-28 17:07:37 Database: rio Application: [unknown] User: intelifix Remote: [local]
15 2 ERROR: function rs_etiqueta(...) does not exist
Times Reported Most Frequent Error / Event #15
Day Hour Count Jul 28 10 2 - ERROR: function rs_etiqueta(numeric) does not exist at character 15
- ERROR: function rs_etiqueta(numeric) does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_ETIQUETA(73900485850063805338)Date: 2026-07-28 10:37:28 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_ETIQUETA(73900485850063805338)Date: 2026-07-28 10:37:29 Database: rio Application: [unknown] User: etiquetas Remote: [local]
16 2 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #16
Day Hour Count Jul 28 10 1 17 1 - ERROR: canceling autovacuum task
- ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000286664"
Date: 2026-07-28 10:45:09
Context: automatic vacuum of table "rio.public.temp0000286776"
Date: 2026-07-28 17:07:37
17 1 ERROR: unterminated quoted string at or near "..."
Times Reported Most Frequent Error / Event #17
Day Hour Count Jul 28 14 1 - ERROR: unterminated quoted string at or near "''');" at character 39
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''');
Date: 2026-07-28 14:37:20 Database: rio Application: [unknown] User: intelifix Remote: [local]
18 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #18
Day Hour Count Jul 28 03 1 - LOG: database system was shut down at 2026-07-28 03:05:01 -03
Date: 2026-07-28 03:05:03
19 1 ERROR: invalid input syntax for type json PL/pgSQL function rs_resumo_tcia(...) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(...) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(...) line 48 at assignment
Times Reported Most Frequent Error / Event #19
Day Hour Count Jul 28 20 1 - ERROR: invalid input syntax for type json PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936...
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-28 20:00:04 Database: brasilia Application: psql User: intelifix Remote: [local]