pgBadger-
Global information
- Generated on Fri Oct 2 23:50:10 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 37,186 log entries in 8s
- Log start from 2026-10-02 00:00:10 to 2026-10-02 23:49:45
-
Overview
Global Stats
- 311 Number of unique normalized queries
- 3,465 Number of queries
- 6h1m28s Total query duration
- 2026-10-02 00:02:03 First query
- 2026-10-02 23:42:34 Last query
- 6 queries/s at 2026-10-02 09:38:16 Query peak
- 6h1m28s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 6h1m28s Execute total duration
- 5,179 Number of events
- 13 Number of unique normalized events
- 4,975 Max number of times the same event was reported
- 0 Number of cancellation
- 366 Total number of automatic vacuums
- 810 Total number of automatic analyzes
- 29 Number temporary file
- 248.68 MiB Max size of temporary file
- 78.94 MiB Average size of temporary file
- 358 Total number of sessions
- 8 sessions at 2026-10-02 22:21:12 Session peak
- 13d12h50m31s Total duration of sessions
- 54m26s Average duration of sessions
- 9 Average queries per session
- 1m Average queries duration per session
- 53m25s Average idle time per session
- 405 Total number of connections
- 6 connections/s at 2026-10-02 03:05:16 Connection peak
- 4 Total number of databases
SQL Traffic
Key values
- 6 queries/s Query Peak
- 2026-10-02 09:38:16 Date
SELECT Traffic
Key values
- 5 queries/s Query Peak
- 2026-10-02 09:38:16 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-10-02 23:42:11 Date
Queries duration
Key values
- 6h1m28s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 02 00 31 0ms 11s303ms 2s369ms 4s30ms 4s638ms 47s924ms 01 31 0ms 3s203ms 945ms 3s593ms 4s749ms 5s195ms 02 18 0ms 3s7ms 1s362ms 3s306ms 4s120ms 5s77ms 03 17 0ms 3s112ms 1s429ms 3s380ms 4s79ms 5s114ms 04 18 0ms 2s985ms 1s411ms 3s705ms 4s66ms 5s399ms 05 33 0ms 8m59s 37s431ms 6s503ms 2m34s 8m59s 06 57 0ms 15s68ms 2s154ms 6s208ms 17s869ms 30s556ms 07 242 0ms 6m5s 7s23ms 48s389ms 5m28s 6m54s 08 324 0ms 5m34s 3s785ms 18s167ms 3m36s 5m57s 09 404 150ms 5m36s 4s193ms 49s749ms 3m40s 6m2s 10 364 0ms 5m32s 5s569ms 1m7s 5m30s 5m56s 11 354 0ms 7m6s 7s380ms 2m24s 5m56s 7m8s 12 84 0ms 5m21s 7s497ms 5s898ms 15s476ms 5m51s 13 148 0ms 5m18s 4s705ms 7s113ms 16s879ms 5m48s 14 347 0ms 5m30s 4s579ms 31s613ms 3m37s 7m59s 15 266 0ms 5m30s 4s763ms 56s88ms 2m10s 5m33s 16 121 0ms 5m13s 5s269ms 5s100ms 15s548ms 5m43s 17 63 0ms 5m15s 9s678ms 3s813ms 14s432ms 5m44s 18 30 0ms 5m12s 20s207ms 3s165ms 20s396ms 5m56s 19 24 0ms 5m19s 24s819ms 3s150ms 14s798ms 5m49s 20 107 0ms 5m16s 10s643ms 1m1s 1m15s 6m46s 21 31 0ms 5m9s 19s40ms 3s960ms 5s207ms 5m54s 22 30 0ms 5m12s 19s662ms 4s704ms 5s413ms 5m56s 23 321 0ms 1m1s 6s52ms 1m5s 1m13s 1m24s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 02 00 7 0 474ms 0ms 0ms 735ms 01 12 0 253ms 0ms 180ms 674ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 10 0 281ms 0ms 0ms 721ms 06 11 0 381ms 0ms 0ms 1s37ms 07 179 0 8s125ms 3s791ms 17s913ms 5m53s 08 240 0 4s352ms 4s151ms 8s648ms 5m37s 09 275 0 4s210ms 7s918ms 18s469ms 5m39s 10 256 0 6s456ms 9s422ms 58s384ms 5m32s 11 266 0 8s360ms 13s954ms 2m19s 5m52s 12 52 0 11s393ms 929ms 1s717ms 3m21s 13 114 0 5s807ms 2s730ms 7s113ms 3m28s 14 267 0 4s416ms 6s393ms 18s34ms 5m31s 15 201 0 5s391ms 10s957ms 55s929ms 3m27s 16 87 0 6s936ms 1s357ms 2s233ms 3m28s 17 37 0 15s748ms 674ms 2s53ms 3m23s 18 11 0 51s253ms 0ms 0ms 3m24s 19 6 0 1m35s 0ms 0ms 3m28s 20 7 81 12s642ms 15s741ms 1m1s 3m26s 21 7 0 1m19s 0ms 0ms 3m24s 22 6 0 1m32s 0ms 0ms 3m20s 23 2 319 6s52ms 1m3s 1m5s 1m24s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 02 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Oct 02 00 0 1 1.00 0.00% 01 0 2 2.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 3 3.00 0.00% 06 0 3 3.00 0.00% 07 0 7 7.00 0.00% 08 0 10 10.00 0.00% 09 0 11 11.00 0.00% 10 0 10 10.00 0.00% 11 0 6 6.00 0.00% 12 0 5 5.00 0.00% 13 0 6 6.00 0.00% 14 0 9 9.00 0.00% 15 0 9 9.00 0.00% 16 0 3 3.00 0.00% 17 0 2 2.00 0.00% 18 0 1 1.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 1 1.00 0.00% Day Hour Count Average / Second Oct 02 00 16 0.00/s 01 11 0.00/s 02 10 0.00/s 03 17 0.00/s 04 8 0.00/s 05 12 0.00/s 06 17 0.00/s 07 15 0.00/s 08 24 0.01/s 09 18 0.01/s 10 24 0.01/s 11 23 0.01/s 12 58 0.02/s 13 19 0.01/s 14 19 0.01/s 15 20 0.01/s 16 15 0.00/s 17 13 0.00/s 18 13 0.00/s 19 8 0.00/s 20 13 0.00/s 21 11 0.00/s 22 9 0.00/s 23 12 0.00/s Day Hour Count Average Duration Average idle time Oct 02 00 9 1h2m 1h1m52s 01 16 1h1m41s 1h1m39s 02 11 1h16s 1h14s 03 20 24m32s 24m31s 04 7 1h3m 1h2m56s 05 9 54m47s 52m29s 06 10 59m 58m47s 07 17 59m18s 57m38s 08 15 54m38s 53m16s 09 24 54m53s 53m42s 10 21 49m35s 47m59s 11 21 55m56s 53m51s 12 18 1h3s 59m28s 13 17 58m49s 58m8s 14 19 54m18s 52m55s 15 21 51m36s 50m36s 16 17 59m 58m22s 17 15 1h21s 59m40s 18 13 1h49s 1h2s 19 11 59m49s 58m55s 20 11 45m5s 43m21s 21 10 1h31s 59m32s 22 11 1h1m22s 1h28s 23 15 38m22s 36m12s -
Connections
Established Connections
Key values
- 6 connections Connection Peak
- 2026-10-02 03:05:16 Date
Connections per database
Key values
- rio Main Database
- 405 connections Total
Connections per user
Key values
- intelifix Main User
- 405 connections Total
-
Sessions
Simultaneous sessions
Key values
- 8 sessions Session Peak
- 2026-10-02 22:21:12 Date
Histogram of session times
Key values
- 297 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 358 sessions Total
Sessions per user
Key values
- intelifix Main User
- 358 sessions Total
Sessions per host
Key values
- [local] Main Host
- 358 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 16,543 buffers Checkpoint Peak
- 2026-10-02 10:39:38 Date
- 270.066 seconds Highest write time
- 0.138 seconds Sync time
Checkpoints Wal files
Key values
- 13 files Wal files usage Peak
- 2026-10-02 11:24:38 Date
Checkpoints distance
Key values
- 416.00 Mo Distance Peak
- 2026-10-02 11:24:38 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Oct 02 00 24,869 701.466s 0.013s 701.495s 01 3,989 399.697s 0.025s 399.752s 02 1,990 199.412s 0.012s 199.441s 03 1,878 187.287s 0.016s 187.333s 04 2,345 234.901s 0.016s 234.935s 05 10,476 1,047.966s 0.032s 1,048.023s 06 4,597 454.539s 0.005s 454.55s 07 33,624 2,305.892s 0.085s 2,306.037s 08 45,224 3,006.382s 0.164s 3,006.608s 09 56,644 3,162.359s 0.153s 3,162.604s 10 59,456 3,085.411s 0.118s 3,085.606s 11 53,603 3,176.008s 0.307s 3,176.4s 12 9,409 945.296s 0.031s 945.359s 13 14,218 1,444.65s 0.066s 1,444.757s 14 48,571 3,221.524s 0.185s 3,221.786s 15 42,497 3,068.444s 0.099s 3,068.606s 16 13,795 1,288.836s 0.056s 1,288.928s 17 6,621 663.509s 0.04s 663.597s 18 696 69.714s 0.01s 69.737s 19 23 2.312s 0.002s 2.316s 20 968 135.753s 0.009s 135.77s 21 3,364 336.906s 0.017s 336.947s 22 2,838 284.073s 0.011s 284.11s 23 269 26.983s 0.007s 27s Day Hour Added Removed Recycled Synced files Longest sync Average sync Oct 02 00 0 0 7 603 0.003s 0.006s 01 0 0 1 796 0.002s 0.01s 02 0 0 1 394 0.002s 0.006s 03 0 0 1 347 0.003s 0.007s 04 0 0 0 420 0.003s 0.006s 05 0 0 5 658 0.008s 0.009s 06 0 0 1 228 0.002s 0.002s 07 0 0 24 3,793 0.002s 0.012s 08 0 0 20 5,325 0.043s 0.012s 09 0 0 50 7,261 0.003s 0.012s 10 0 0 49 6,633 0.002s 0.012s 11 0 0 56 6,499 0.016s 0.012s 12 0 0 3 2,117 0.002s 0.012s 13 0 0 5 3,801 0.002s 0.012s 14 0 0 34 7,019 0.004s 0.012s 15 0 0 26 5,671 0.003s 0.012s 16 0 0 7 3,284 0.003s 0.011s 17 0 0 2 1,899 0.002s 0.012s 18 0 0 1 139 0.002s 0.005s 19 0 0 0 3 0.002s 0.001s 20 0 0 0 84 0.002s 0.003s 21 0 0 1 476 0.003s 0.007s 22 0 0 1 414 0.002s 0.007s 23 0 0 0 29 0.002s 0.005s Day Hour Count Avg time (sec) Oct 02 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Oct 02 00 20,475.00 kB 52,108.00 kB 01 2,065.90 kB 25,593.10 kB 02 1,783.17 kB 11,887.50 kB 03 1,534.14 kB 3,517.29 kB 04 2,208.17 kB 2,804.83 kB 05 8,362.56 kB 15,806.44 kB 06 10,732.00 kB 13,863.00 kB 07 32,189.00 kB 39,524.08 kB 08 27,507.25 kB 62,822.08 kB 09 68,846.67 kB 102,906.67 kB 10 66,775.17 kB 129,780.00 kB 11 75,690.67 kB 155,653.25 kB 12 4,055.67 kB 70,462.75 kB 13 6,675.67 kB 23,240.50 kB 14 46,642.50 kB 82,007.92 kB 15 35,265.25 kB 71,433.42 kB 16 11,193.73 kB 42,306.18 kB 17 2,878.33 kB 15,520.00 kB 18 771.40 kB 7,227.00 kB 19 188.00 kB 5,272.00 kB 20 3,828.67 kB 6,757.33 kB 21 2,262.14 kB 4,794.86 kB 22 2,191.43 kB 3,540.14 kB 23 201.80 kB 2,428.80 kB -
Temporary Files
Size of temporary files
Key values
- 497.36 MiB Temp Files size Peak
- 2026-10-02 05:31:56 Date
Number of temporary files
Key values
- 4 per second Temp Files Peak
- 2026-10-02 05:32:04 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Oct 02 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 20 1.32 GiB 67.66 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 3 311.99 MiB 104.00 MiB 11 3 311.99 MiB 104.00 MiB 12 0 0 0 13 0 0 0 14 1 104.00 MiB 104.00 MiB 15 2 207.99 MiB 104.00 MiB 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 16 1.02 GiB 37.09 MiB 248.68 MiB 65.26 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-02 05:32:05 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-02 05:31:56 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 9 935.97 MiB 104.00 MiB 104.00 MiB 104.00 MiB select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030683, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-02 07:41:17 Duration: 5m52s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030704, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-02 09:50:32 Duration: 5m36s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030690, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-02 08:50:51 Duration: 5m34s Database: rio User: intelifix Remote: [local] Application: [unknown]
3 4 309.04 MiB 57.45 MiB 94.54 MiB 77.26 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-02 05:30:41 Duration: 39s347ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-02 05:30:38 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 248.68 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-02 05:31:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 248.68 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-02 05:31:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-10-02 11:16:39 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-10-02 10:51:02 - 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-10-02 11:07:53 - 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-10-02 15:55:13 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
7 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-10-02 11:04:01 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
8 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-10-02 10:31:14 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
9 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-10-02 15:38:33 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-10-02 10:57:30 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
11 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-10-02 14:35:27 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
12 94.54 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-02 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 94.54 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-02 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 62.52 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-02 05:30:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 57.45 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-02 05:30:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 41.07 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-02 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 41.01 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-02 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 41.00 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-02 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 41.00 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-02 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 41.00 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-02 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 3.25 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_10
Database rio - 2026-10-02 11:40:40 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 3.25 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_10
Database rio - 2026-10-02 11:40:40 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (91) Main table analyzed (database rio)
- 810 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 91 rio.public.usuarios 46 rio.pg_catalog.pg_class 46 rio.pg_catalog.pg_type 41 brasilia.pg_catalog.pg_attribute 37 rio.public.temp0000293166 35 rio.public.temp0000293000 31 contagem.public.usuarios 29 rio.public.temp0000293178 28 contagem.public.temp0000227396 27 rio.pg_catalog.pg_index 26 contagem.pg_catalog.pg_attribute 22 brasilia.pg_catalog.pg_class 21 rio.public.temp0000292986 21 rio.pg_catalog.pg_depend 19 brasilia.pg_catalog.pg_type 18 rio.public.temp0000293210 15 brasilia.public.temp0000241452 12 brasilia.pg_catalog.pg_index 12 brasilia.pg_catalog.pg_depend 10 rio.public.temp0000293082 9 contagem.pg_catalog.pg_class 8 rio.public.temp0000292760 8 rio.public.temp0000293222 7 rio.public.temp0000292754 7 brasilia.public.usuarios 7 rio.public.temp0000293156 7 contagem.pg_catalog.pg_type 7 rio.public.temp0000293246 7 rio.public.temp0000293278 7 rio.public.temp0000293184 7 rio.public.temp0000293270 6 brasilia.public.temp0000241460 6 rio.public.temp0000293266 6 rio.auditor.auditor_2026_10 6 rio.public.temp0000293194 5 rio.public.temp0000293274 5 contagem.auditor.auditor_2026_10 5 rio.public.temp0000293182 5 brasilia.auditor.auditor_2026_10 5 brasilia.public.temp0000241446 4 rio.public.temp0000293162 4 contagem.pg_catalog.pg_index 4 rio.public.tmp_drill_0320 4 brasilia.public.temp0000241456 4 brasilia.public.nf_entrada 4 rio.public.temp0000293238 4 rio.public.temp0000293232 3 contagem.pg_catalog.pg_depend 3 rio.public.tmp_drill_0302 3 rio.public.temp0000293256 3 rio.public.temp0000293066 3 brasilia.public.temp0000241496 2 rio.public.temp0000293286 2 rio.public.temp0000293282 2 brasilia.public.temp0000241426 2 rio.public.temp0000293252 2 brasilia.public.temp0000241430 2 brasilia.public.temp0000241474 2 contagem.pg_catalog.pg_shdepend 2 rio.public.temp0000293242 2 brasilia.public.temp0000241516 2 rio.public.temp0000293264 2 testes.pg_catalog.pg_shdepend 2 rio.public.temp0000293176 1 rio.public.temp0000293272 1 brasilia.public.temp0000241478 1 brasilia.public.temp0000241468 1 brasilia.public.temp0000241438 1 contagem.public.temp0000227416 1 brasilia.public.temp0000241454 1 brasilia.public.temp0000241432 1 brasilia.public.temp0000241464 1 brasilia.public.temp0000241494 1 brasilia.pg_catalog.pg_shdepend 1 rio.public.temp0000293180 1 brasilia.public.temp0000241488 1 rio.public.temp0000293160 1 rio.public.temp0000293168 1 postgres.pg_catalog.pg_shdepend 1 rio.public.temp0000293172 1 rio.public.temp0000293224 1 template1.pg_catalog.pg_shdepend 1 contagem.public.temp0000227400 1 brasilia.public.temp0000241440 1 contagem.public.nf_entrada 1 rio.pg_catalog.pg_shdepend 1 contagem.public.temp0000227394 1 rio.public.temp0000293268 1 rio.public.temp0000293170 1 Total 810 Vacuums per table
Key values
- pg_catalog.pg_attribute (33) Main table vacuumed on database rio
- 366 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.pg_catalog.pg_attribute 33 32 0 0 0 0 0 18,202 4,909 7,683,009 234 5,899 contagem.public.usuarios 30 0 0 0 0 0 0 148 112 53,585 1 1 rio.public.temp0000293000 29 0 0 0 0 0 0 1,685 287 328,088 0 0 rio.public.temp0000293178 28 0 0 0 0 0 0 28,391 1,969 4,079,474 0 0 rio.pg_catalog.pg_class 21 19 0 0 0 0 0 3,651 1,060 1,608,051 59 210 rio.pg_catalog.pg_type 18 17 0 0 0 0 0 1,767 498 732,516 58 222 rio.public.temp0000293166 15 0 0 0 0 0 0 6,181 233 667,452 0 0 brasilia.pg_catalog.pg_attribute 13 13 0 0 0 0 0 7,534 2,061 3,533,399 59 1,591 rio.pg_catalog.pg_index 10 10 0 0 0 0 0 609 169 185,617 36 70 rio.pg_catalog.pg_depend 9 9 0 0 0 0 0 2,933 988 1,608,968 51 382 brasilia.pg_catalog.pg_class 9 9 0 0 0 0 0 1,736 459 782,052 22 68 rio.public.temp0000292760 8 0 0 0 0 0 0 454 208 314,975 0 0 rio.public.temp0000293222 8 0 0 0 0 0 0 7,392 28 440,692 0 0 rio.public.temp0000293266 7 0 0 0 0 0 0 7,673 1,875 2,841,479 0 0 rio.public.temp0000293278 7 0 0 0 0 0 0 12,911 1,868 3,148,047 0 0 contagem.pg_catalog.pg_attribute 7 7 0 0 0 0 0 4,567 1,220 2,164,819 23 650 brasilia.pg_catalog.pg_type 7 7 0 0 0 0 0 707 173 297,487 15 114 rio.public.temp0000292754 6 0 0 0 0 0 0 393 34 28,455 0 0 rio.public.usuarios 6 4 0 0 0 0 0 128 52 119,287 8 12 rio.pg_catalog.pg_statistic 6 6 0 0 0 0 0 7,693 1,551 6,577,968 870 3,652 rio.public.temp0000293082 5 0 0 0 0 0 0 452 30 31,284 0 0 brasilia.pg_catalog.pg_index 5 5 0 0 0 0 0 264 82 73,711 15 43 testes.pg_catalog.pg_shdepend 4 4 0 0 0 0 0 1,040 375 815,771 35 48 rio.auditor.auditor_2026_10 4 0 0 0 0 0 0 62,410 34,077 44,814,119 14,164 287,454 rio.public.tmp_drill_0320 4 4 0 0 0 0 0 176 12 35,933 0 0 brasilia.public.temp0000241456 4 0 0 0 0 0 0 775 15 48,072 0 0 brasilia.public.temp0000241446 4 0 0 0 0 0 0 1,028 16 63,064 0 0 rio.public.temp0000292986 4 0 0 0 0 0 0 373 119 189,857 0 0 rio.public.tmp_drill_0302 3 3 0 0 0 0 0 160 81 96,331 1 27 brasilia.auditor.auditor_2026_10 3 0 0 0 0 0 0 11,626 6,665 9,241,343 2,330 44,710 contagem.auditor.auditor_2026_10 3 0 0 0 0 0 0 10,879 5,641 6,847,068 2,145 35,493 rio.pg_toast.pg_toast_2619 3 3 0 0 0 0 0 1,704 329 1,852,167 124 384 brasilia.pg_catalog.pg_depend 3 3 0 0 0 0 0 1,029 266 490,278 9 193 rio.public.temp0000293252 2 0 0 0 0 0 0 198 12 13,564 0 0 rio.public.temp0000293238 2 0 0 0 0 0 0 16 10 2,658 0 0 rio.public.temp0000293242 2 0 0 0 0 0 0 1,848 7 110,173 0 0 brasilia.pg_catalog.pg_statistic 2 2 0 0 0 0 0 3,623 1,307 4,655,205 1,117 7,297 contagem.pg_catalog.pg_index 2 2 0 0 0 0 0 135 40 50,132 2 7 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 403 115 558,627 44 106 rio.public.temp0000293286 2 0 0 0 0 0 0 3,688 8 218,798 0 0 postgres.pg_catalog.pg_shdepend 2 2 0 0 0 0 0 498 163 356,497 20 32 contagem.pg_catalog.pg_statistic 2 2 0 0 0 0 0 3,018 187 756,191 150 1,301 contagem.pg_catalog.pg_type 2 2 0 0 0 0 0 229 41 71,940 2 4 contagem.pg_catalog.pg_class 2 2 0 0 0 0 0 455 65 111,690 0 0 rio.public.temp0000293194 2 0 0 0 0 0 0 1,848 7 110,173 0 0 rio.public.temp0000293268 1 0 0 0 0 0 0 99 6 6,782 0 0 brasilia.public.temp0000241494 1 0 0 0 0 0 0 257 4 15,766 0 0 contagem.public.temp0000227400 1 0 0 0 0 0 0 118 6 7,940 0 0 contagem.pg_catalog.pg_depend 1 1 0 0 0 0 0 397 52 111,267 0 0 brasilia.public.temp0000241464 1 0 0 0 0 0 0 1,229 4 73,114 0 0 rio.public.temp0000293224 1 0 0 0 0 0 0 91 6 6,293 0 0 rio.public.temp0000293232 1 0 0 0 0 0 0 97 6 6,684 0 0 brasilia.public.temp0000241460 1 0 0 0 0 0 0 257 4 15,766 0 0 rio.public.temp0000293274 1 0 0 0 0 0 0 99 6 6,782 0 0 brasilia.public.temp0000241430 1 0 0 0 0 0 0 109 6 7,392 0 0 rio.public.temp0000293172 1 0 0 0 0 0 0 8 5 1,309 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 129 4 10,491 0 0 rio.public.temp0000293160 1 0 0 0 0 0 0 89 6 6,171 0 0 rio.public.temp0000293168 1 0 0 0 0 0 0 8 5 1,309 0 0 rio.public.temp0000293176 1 0 0 0 0 0 0 8 6 2,740 0 0 rio.public.temp0000293270 1 0 0 0 0 0 0 8 5 1,330 0 0 Total 366 171 0 0 0 0 0 225,633 69,555 109,091,202 21,594 389,970 Vacuum throughput per table
Key values
- auditor.auditor_2026_10 (9.3) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.pg_catalog.pg_attribute 0 0 2.2 contagem.public.usuarios 0 0 0 rio.public.temp0000293000 0 0 0.05 rio.public.temp0000293178 0 0 0.77 rio.pg_catalog.pg_class 0 0 0.64 rio.pg_catalog.pg_type 0 0 0.15 rio.public.temp0000293166 0 0 0.13 brasilia.pg_catalog.pg_attribute 0 0 0.99 rio.pg_catalog.pg_index 0 0 0.11 rio.pg_catalog.pg_depend 0 0 0.57 brasilia.pg_catalog.pg_class 0 0 0.24 rio.public.temp0000292760 0 0 0.01 rio.public.temp0000293222 0 0 0.34 rio.public.temp0000293266 0 0 0.18 rio.public.temp0000293278 0 0 0.32 contagem.pg_catalog.pg_attribute 0 0 0.7 brasilia.pg_catalog.pg_type 0 0 0.12 rio.public.temp0000292754 0 0 0 rio.public.usuarios 0 0 0 rio.pg_catalog.pg_statistic 0 0 0.83 rio.public.temp0000293082 0 0 0 brasilia.pg_catalog.pg_index 0 0 0.06 testes.pg_catalog.pg_shdepend 0 0 0.37 rio.auditor.auditor_2026_10 0 0 9.3 rio.public.tmp_drill_0320 0 0 0 brasilia.public.temp0000241456 0 0 0 brasilia.public.temp0000241446 0 0 0 rio.public.temp0000292986 0 0 0.01 rio.public.tmp_drill_0302 0 0 0 brasilia.auditor.auditor_2026_10 0 0 1.59 contagem.auditor.auditor_2026_10 0 0 1.43 rio.pg_toast.pg_toast_2619 0 0 0.13 brasilia.pg_catalog.pg_depend 0 0 0.26 rio.public.temp0000293252 0 0 0 rio.public.temp0000293238 0 0 0 rio.public.temp0000293242 0 0 0.09 brasilia.pg_catalog.pg_statistic 0 0 0.29 contagem.pg_catalog.pg_index 0 0 0.03 brasilia.pg_toast.pg_toast_2619 0 0 0.06 rio.public.temp0000293286 0 0 0.08 postgres.pg_catalog.pg_shdepend 0 0 0.06 contagem.pg_catalog.pg_statistic 0 0 0.14 contagem.pg_catalog.pg_type 0 0 0.06 contagem.pg_catalog.pg_class 0 0 0.16 rio.public.temp0000293194 0 0 0.08 rio.public.temp0000293268 0 0 0 brasilia.public.temp0000241494 0 0 0 contagem.public.temp0000227400 0 0 0 contagem.pg_catalog.pg_depend 0 0 0.09 brasilia.public.temp0000241464 0 0 0.03 rio.public.temp0000293224 0 0 0 rio.public.temp0000293232 0 0 0 brasilia.public.temp0000241460 0 0 0 rio.public.temp0000293274 0 0 0.01 brasilia.public.temp0000241430 0 0 0 rio.public.temp0000293172 0 0 0 contagem.pg_toast.pg_toast_2619 0 0 0 rio.public.temp0000293160 0 0 0 rio.public.temp0000293168 0 0 0 rio.public.temp0000293176 0 0 0 rio.public.temp0000293270 0 0 0 Total 0 0 22.68 Tuples removed per table
Key values
- pg_catalog.pg_attribute (132734) Main table with removed tuples on database rio
- 280182 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 33 32 132,734 800,814 25,981 159 20,027 brasilia.pg_catalog.pg_attribute 13 13 58,899 300,176 34 272 7,585 contagem.pg_catalog.pg_attribute 7 7 28,390 177,850 0 396 3,677 rio.pg_catalog.pg_statistic 6 6 11,241 49,133 24 0 7,716 rio.pg_catalog.pg_type 18 17 5,770 42,684 1,932 8 1,298 rio.pg_catalog.pg_depend 9 9 5,618 172,481 2,763 0 1,647 contagem.pg_catalog.pg_statistic 2 2 5,605 14,873 0 0 2,022 brasilia.pg_catalog.pg_statistic 2 2 4,879 15,522 0 0 2,142 rio.pg_catalog.pg_class 21 19 3,051 87,671 5,634 49 2,824 testes.pg_catalog.pg_shdepend 4 4 2,862 72,236 199 0 600 rio.pg_catalog.pg_index 10 10 2,607 19,697 557 4 558 brasilia.pg_catalog.pg_class 9 9 2,260 30,409 4 24 1,121 brasilia.pg_catalog.pg_type 7 7 2,233 15,459 2 5 457 brasilia.auditor.auditor_2026_10 3 0 1,980 1,120,744 0 0 48,002 contagem.public.usuarios 30 0 1,875 720 0 0 60 postgres.pg_catalog.pg_shdepend 2 2 1,481 36,099 1 0 300 rio.auditor.auditor_2026_10 4 0 1,470 4,089,134 0 0 200,335 contagem.pg_catalog.pg_type 2 2 1,399 4,504 0 34 118 brasilia.pg_catalog.pg_index 5 5 1,389 9,401 4 8 259 brasilia.pg_catalog.pg_depend 3 3 1,085 54,758 0 0 524 rio.pg_toast.pg_toast_2619 3 3 1,039 1,962 0 0 837 rio.public.tmp_drill_0302 3 3 768 2,105 0 0 56 contagem.pg_catalog.pg_index 2 2 701 3,800 0 17 92 rio.public.usuarios 6 4 232 3,824 770 0 114 brasilia.pg_toast.pg_toast_2619 2 2 224 297 0 0 146 contagem.pg_catalog.pg_class 2 2 172 7,165 0 25 312 contagem.pg_catalog.pg_depend 1 1 114 18,187 0 24 169 contagem.pg_toast.pg_toast_2619 1 1 104 115 0 20 39 rio.public.temp0000293252 2 0 0 3,346 0 74 182 rio.public.temp0000293238 2 0 0 3,332 0 74 182 rio.public.temp0000293268 1 0 0 1,666 0 37 91 rio.public.temp0000293082 5 0 0 7,417 0 228 412 rio.public.temp0000293266 7 0 0 109,676 0 111 7,697 rio.public.temp0000293166 15 0 0 109,475 0 428 6,356 rio.public.tmp_drill_0320 4 4 0 2,373 0 0 62 brasilia.public.temp0000241456 4 0 0 13,492 0 0 1,024 contagem.auditor.auditor_2026_10 3 0 0 746,480 0 0 32,958 brasilia.public.temp0000241494 1 0 0 3,374 0 0 256 contagem.public.temp0000227400 1 0 0 1,405 0 18 110 rio.public.temp0000293242 2 0 0 52,326 0 0 3,712 rio.public.temp0000292754 6 0 0 23,438 0 182 522 rio.public.temp0000292760 8 0 0 29,148 0 242 654 rio.public.temp0000293178 28 0 0 485,334 0 463 34,225 brasilia.public.temp0000241464 1 0 0 10,746 0 0 1,280 rio.public.temp0000293224 1 0 0 1,483 0 45 83 rio.public.temp0000293278 7 0 0 183,172 0 0 12,992 rio.public.temp0000293232 1 0 0 1,613 0 40 88 rio.public.temp0000293286 2 0 0 52,334 0 0 3,712 rio.public.temp0000293000 29 0 0 92,729 0 693 2,059 brasilia.public.temp0000241460 1 0 0 3,374 0 0 256 rio.public.temp0000293222 8 0 0 209,267 0 0 14,848 brasilia.public.temp0000241446 4 0 0 13,481 0 0 1,024 rio.public.temp0000293274 1 0 0 1,666 0 37 91 brasilia.public.temp0000241430 1 0 0 1,694 0 27 101 rio.public.temp0000293172 1 0 0 1,451 0 47 81 rio.public.temp0000292986 4 0 0 19,682 0 137 439 rio.public.temp0000293160 1 0 0 1,451 0 47 81 rio.public.temp0000293168 1 0 0 1,451 0 47 81 rio.public.temp0000293176 1 0 0 1,451 0 47 81 rio.public.temp0000293270 1 0 0 1,666 0 37 91 rio.public.temp0000293194 2 0 0 52,325 0 0 3,712 Total 366 171 280,182 9,395,138 37,905 4,106 432,580 Pages removed per table
Key values
- public.temp0000293000 (693) Main table with removed pages on database rio
- 4106 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000293000 29 0 0 693 rio.public.temp0000293178 28 0 0 463 rio.public.temp0000293166 15 0 0 428 contagem.pg_catalog.pg_attribute 7 7 28390 396 brasilia.pg_catalog.pg_attribute 13 13 58899 272 rio.public.temp0000292760 8 0 0 242 rio.public.temp0000293082 5 0 0 228 rio.public.temp0000292754 6 0 0 182 rio.pg_catalog.pg_attribute 33 32 132734 159 rio.public.temp0000292986 4 0 0 137 rio.public.temp0000293266 7 0 0 111 rio.public.temp0000293252 2 0 0 74 rio.public.temp0000293238 2 0 0 74 rio.pg_catalog.pg_class 21 19 3051 49 rio.public.temp0000293172 1 0 0 47 rio.public.temp0000293160 1 0 0 47 rio.public.temp0000293168 1 0 0 47 rio.public.temp0000293176 1 0 0 47 rio.public.temp0000293224 1 0 0 45 rio.public.temp0000293232 1 0 0 40 rio.public.temp0000293268 1 0 0 37 rio.public.temp0000293274 1 0 0 37 rio.public.temp0000293270 1 0 0 37 contagem.pg_catalog.pg_type 2 2 1399 34 brasilia.public.temp0000241430 1 0 0 27 contagem.pg_catalog.pg_class 2 2 172 25 contagem.pg_catalog.pg_depend 1 1 114 24 brasilia.pg_catalog.pg_class 9 9 2260 24 contagem.pg_toast.pg_toast_2619 1 1 104 20 contagem.public.temp0000227400 1 0 0 18 contagem.pg_catalog.pg_index 2 2 701 17 brasilia.pg_catalog.pg_index 5 5 1389 8 rio.pg_catalog.pg_type 18 17 5770 8 brasilia.pg_catalog.pg_type 7 7 2233 5 rio.pg_catalog.pg_index 10 10 2607 4 rio.public.tmp_drill_0302 3 3 768 0 testes.pg_catalog.pg_shdepend 4 4 2862 0 rio.auditor.auditor_2026_10 4 0 1470 0 brasilia.auditor.auditor_2026_10 3 0 1980 0 rio.public.tmp_drill_0320 4 4 0 0 brasilia.public.temp0000241456 4 0 0 0 contagem.auditor.auditor_2026_10 3 0 0 0 brasilia.public.temp0000241494 1 0 0 0 rio.public.temp0000293242 2 0 0 0 brasilia.pg_catalog.pg_statistic 2 2 4879 0 brasilia.public.temp0000241464 1 0 0 0 rio.public.usuarios 6 4 232 0 brasilia.pg_toast.pg_toast_2619 2 2 224 0 rio.public.temp0000293278 7 0 0 0 rio.pg_catalog.pg_depend 9 9 5618 0 rio.public.temp0000293286 2 0 0 0 rio.pg_catalog.pg_statistic 6 6 11241 0 brasilia.public.temp0000241460 1 0 0 0 postgres.pg_catalog.pg_shdepend 2 2 1481 0 rio.public.temp0000293222 8 0 0 0 brasilia.public.temp0000241446 4 0 0 0 rio.pg_toast.pg_toast_2619 3 3 1039 0 brasilia.pg_catalog.pg_depend 3 3 1085 0 contagem.pg_catalog.pg_statistic 2 2 5605 0 contagem.public.usuarios 30 0 1875 0 rio.public.temp0000293194 2 0 0 0 Total 366 171 280,182 4,106 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Oct 02 00 2 3 01 0 7 02 0 0 03 0 0 04 0 0 05 6 2 06 4 9 07 24 53 08 38 79 09 71 140 10 58 112 11 58 116 12 3 6 13 14 41 14 44 108 15 36 86 16 5 30 17 2 15 18 0 0 19 0 0 20 0 0 21 1 3 22 0 0 23 0 0 - 3.25 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 4 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 1 2m22s 2m22s 2m22s 2m22s call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-02 14:17:30 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-02 00:05:18 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-02 09:15:10 Database: rio User: intelifix Remote: [local] Application: psql
2 1 1m34s 1m34s 1m34s 1m34s select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030683, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-02 07:41:17 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030704, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-02 09:50:32 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030690, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-02 08:50:51 Database: rio User: intelifix Remote: [local] Application: [unknown]
3 1 1s557ms 1s557ms 1s557ms 1s557ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (60009, 407, '835120918003117,241673336175,230043631228,241680311638,241654553456,241608686981,241607183434,241655231637,241674084868,241593304459,241607182626,230043618600,241713750816,241670019701,241607182424,241704326876,241668204552,241708968800,241679862929,241711220513,241622605051,241671508398,241602649400,241650443739,241732101316,241695590514,241660118487,241692684461,241689394050,241695489314,241709240724,241694340628,241609911838,241704736871,241695588997,241659687884,241668206168,241730934142,241728637778,241656745768,241614511636,241730938586,241713725560,241617324749,241711196267,230047921018,241659721828,241649660420,241620793438,241619827597,241728683440', '',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-10-02 09:24:57 Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (60012, 406, 'ZTE3ANNT3H44751,D831399ADC72,D831399ADC73,ZTEGDD327F6E$ZTE3ANNQ8110956,689E29BCDF93,689E29BCDF94,ZTEGD7B7655C$ZTE3ANNR9316781,D89A0D83E959,D89A0D83E95A,ZTEGDB14B58C$ZTE3ANNR7B55033,3891484DF67D,3891484DF67E,ZTEGDB086859$ZTE3ANNR9W45039,D89A0DAC7BBD,D89A0DAC7BBE,ZTEGDB16C19A$ZTE3ANNT7U14599,589204015624,589204015625,ZTEGDF0325FB$ZTE3ANNR3J39831,F4E84F89F3EA,F4E84F89F3EB,ZTEGD97BFD61$ZTE3ANNQ9J19209,843C992D936B,843C992D936C,ZTEGD7BB53B4$ZTE3ANNR3J30265,F4E84F8913B6,F4E84F8913B7,ZTEGD97BD803$ZTE3ANNRB747522,5872C99292FD,5872C99292FE,ZTEGDC61E475$ZTE3ANNQ8M08086,843C991F856F,843C991F8570,ZTEGD7BA6703$ZTE3ANNR5W25171,48D68230D1BC,48D68230D1BD,ZTEGDB006252$ZTE3ANNR1Y02227,14CA56CCDEAD,14CA56CCDEAE,ZTEGD9707F0E$ZTE3ANNRCB61973,D83139237B7C,D83139237B7D,ZTEGDD2AA7AA$ZTE3ANNRCB71291,D831392455E0,D831392455E1,ZTEGDD2ACC10$ZTE3ANNRB708416,5872C98EFE71,5872C98EFE72,ZTEGDC614BB3$ZTE3ANNR3J04836,F4E84F86BFB8,F4E84F86BFB9,ZTEGD97B74AE$ZTE3ANNR3Y22471,4896D951CF62,4896D951CF63,ZTEGD97E887C$ZTE3ANNT7U14627,5892040156CC,5892040156CD,ZTEGDF032617$ZTE3ANNRCB71381,D831392457FC,D831392457FD,ZTEGDD2ACC6A$ZTE3ANNR3Y01544,4896D94FE4E8,4896D94FE4E9,ZTEGD97E36BD$ZTE3ANNQ8F08972,689E29FCF525,689E29FCF526,ZTEGD7BA1FDC$ZTE3ANNR6R27817,48D6823810B8,48D6823810B9,ZTEGDB01977C$ZTE3ANNR3Y13230,4896D950F6CC,4896D950F6CD,ZTEZD97E6463$ZTE3ANNQ4N04307,3CF9F0A8F6A0,3CF9F0A8F6A1,ZTEGD64113CE$ZTE3ANNR2Q36682,F4E84F840FBC,F4E84F840FBD,ZTEGD97B0204$ZTE3ANNR8C09355,3891484F6249,3891484F624A,ZTEGDB08A4FB$ZTE3ANNT4Q05352,F00C51554BC8,F00C51554BC9,ZTEGDE35921D$ZTE3ANNR3J06971,F4E84F86F1C2,F4E84F86F1C3,ZTEGD97B7D05$ZTE3ANNR6R23296,48D68237A6C2,48D68237A6C3,ZTEGDB0185D3$ZTE3ANNQ8127213,689E29BE5C99,689E29BE5C9A,ZTEGD7B7A4DD$ZTE3ANNRAD24305,D89A0DB01409,D89A0DB0140A,ZTEGDB175AFC$ZTE3ANNT7U23020,589204021B82,589204021B83,ZTEGDF0346E0$ZTE3ANNT3J12706,D83139A1151E,D83139A1151F,ZTEGDD3388E0$ZTE3ANNR4N39501,4896D958F8E6,4896D958F8E7,ZTEGD97FBA12$ZTE3ANNR9W44778,D89A0DAC759F,D89A0DAC75A0,ZTEGDB16C095$ZTE3ANNR6R23023,48D68237A05C,48D68237A05D,ZTEGDB0184C2$ZTE3ANNR5W00850,48D6822E97B6,48D6822E97B7,ZTEGDB000351$ZTE3ANNT2V85365,D83139935F96,D83139935F97,ZTEGDD313FF4$ZTE3ANNR5W69082,48D68234D6E6,48D68234D6E7,ZTEGDB010DD9$ZTE3ANNR3J05863,F4E84F86D7CA,F4E84F86D7CB,ZTEGD97B78B1$ZTE3ANNR3Y22347,4896D951CC7A,4896D951CC7B,ZTEGD97E8800', '',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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-02 08:54:01 Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (60014, 407, 'ZTE3A8TT2L04222,7C7D21F17E4B$ZTE3A8TQCH13962,DC5193D9652E$ZTE3A8TRCB04596,7C7D21ECD8D3$ZTE3A8TRCB04627,7C7D21ECD94F$ZTE3A8TT4724652,14200458FF82$ZTE3A8TT3304101,142004531316$ZTE3A8TT4724408,14200458FBB2$ZTE3A8TT4X00698,1420045917AA$ZTE3A8TR6D23832,E44E12B0CB01$ZTE3A8TR6D23402,E44E12B0C449$ZTE3A8TR6D25002,E44E12B0DD49$ZTE3A8TT3R18868,1420045716B2$ZTE3A8TT3304124,142004531372$ZTE3A8TT3C03359,1420045495EE$ZTE3A8TR5U23573,E44E1292CE9B$ZTE3A8TR5U17632,E44E129271C7$ZTE3A8TR5U25327,E44E1292EA03$ZTE3A8TT4724179,14200458F81E$ZTE3A8TT4723615,14200458EF4E$ZTE3A8TQCH14068,DC5193D966D6$ZTE3A8TT7P17236,C492D9465AA7$ZTE3A8TR5U25343,E44E1292EA43$ZTE3A8TT3C03438,14200454972A$ZTE3A8TR6D24872,E44E12B0DB41$ZTE3A8TT2L03613,7C7D21F174C7$ZTE3A8TT3R18877,1420045716D6$ZTE3A8TT4723078,14200458E6EA$ZTE3A8TT2L04215,7C7D21F17E2F$ZTE3A8TT2L04189,7C7D21F17DC7$ZTE3A8TR5U17638,E44E129271DF$ZTE3A8TR4708126,DC5193DB877E$ZTE3A8TT2L03527,7C7D21F1736F$ZTE3A8TT3C03379,14200454963E', '',05,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-02 14:13:35 Database: contagem User: intelifix Remote: [local] Application: [unknown]
4 1 1s 1s 1s 1s drop table if exists temp0000293222;-
DROP TABLE IF EXISTS temp0000293222;
Date: 2026-10-02 10:58:38 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000293222;
Date: 2026-10-02 10:58:38 Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries that waited the most
Rank Wait time Query 1 2m22s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-10-02 14:17:29 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 1m34s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030720, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');[ Date: 2026-10-02 11:34:25 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
3 1s557ms SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (60032, 413, '71731085850047306862,216816828908$71706985850035903104,216752322433$7151678787H010905275,216563230612$7152038787H010928643,216607482439$71427485850006021528,216348025669$71502085850010823395,216412277798$7152458787H010955656,216631340615$71731785850047709199,216818062631$71731785850047704264,216817569192$71503785850011538753,216512819091$71719985850041810842,216799577392$71505585850012101182,216519196381$71817985850055300133,216864898504$71803785850050505656,216834085676$71425585850004940434,216333394567', '',062,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":""}]','$$$$$$$$$$$$$$','', 00);[ Date: 2026-10-02 10:35:29 - Database: contagem - User: intelifix - Remote: [local] - Application: [unknown] ]
4 1s DROP TABLE IF EXISTS temp0000293222;[ Date: 2026-10-02 10:58:38 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 2,053 Total read queries
- 879 Total write queries
Queries by database
Key values
- rio Main database
- 1,940 Requests
- 4h24m16s (rio)
- Main time consuming database
Database Request type Count Duration brasilia Total 1,107 1h28m23s copy to 139 10m49s ddl 145 2m50s others 250 9m20s select 573 1h5m23s contagem Total 416 8m48s copy to 115 1m22s ddl 14 13s759ms others 5 2m47s select 282 4m24s rio Total 1,940 4h24m16s copy to 146 29m14s ddl 320 27m41s others 278 25m56s select 1,196 3h1m24s testes Total 2 466ms select 2 466ms Queries by user
Key values
- intelifix Main user
- 3,369 Requests
User Request type Count Duration etiquetas Total 5 1s68ms select 5 1s68ms intelifix Total 3,369 6h58s copy to 400 41m26s ddl 479 30m45s others 533 38m4s select 1,957 4h10m41s lenon Total 91 29s548ms select 91 29s548ms Duration by user
Key values
- 6h58s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 5 1s68ms select 5 1s68ms intelifix Total 3,369 6h58s copy to 400 41m26s ddl 479 30m45s others 533 38m4s select 1,957 4h10m41s lenon Total 91 29s548ms select 91 29s548ms Queries by host
Key values
- [local] Main host
- 3,465 Requests
- 6h1m28s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 2,360 Requests
- 3h15m46s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-10-02 17:10:16 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 1,769 100-500ms duration
Slowest individual queries
Rank Duration Query 1 8m59s analyze verbose;[ Date: 2026-10-02 05:09:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 7m6s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030720, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx') / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;[ Date: 2026-10-02 11:39:57 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
3 6m28s analyze verbose;[ Date: 2026-10-02 05:15:29 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
4 6m5s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-02 07:11:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 5m52s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030683, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-02 07:41:17 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
6 5m36s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030704, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-02 09:50:32 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
7 5m34s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030690, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-02 08:50:51 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
8 5m33s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030720, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');[ Date: 2026-10-02 11:34:25 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
9 5m32s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030708, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-02 10:34:16 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 5m30s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030721, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-02 14:17:29 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
11 5m30s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-02 15:10:31 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m30s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030711, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-02 10:50:52 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 5m28s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030719, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-02 11:23:59 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 5m26s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030689, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-02 07:54:29 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
15 5m24s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-02 09:10:26 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m24s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-02 08:10:25 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m21s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-02 10:10:22 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 5m21s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-02 12:10:22 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 5m20s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-02 11:10:21 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 5m19s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-02 19:10:21 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1h30m42s 48 2s104ms 6m5s 1m53s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 02 07 3 6m34s 2m11s 08 3 5m45s 1m55s 09 3 5m45s 1m55s 10 3 5m41s 1m53s 11 3 5m39s 1m53s 12 3 5m39s 1m53s 13 3 5m36s 1m52s 14 3 5m31s 1m50s 15 3 5m48s 1m56s 16 3 5m31s 1m50s 17 3 5m32s 1m50s 18 3 5m29s 1m49s 19 3 5m36s 1m52s 20 3 5m33s 1m51s 21 3 5m26s 1m48s 22 3 5m29s 1m49s [ User: intelifix - Total duration: 1h30m42s - Times executed: 48 ]
[ Application: psql - Total duration: 1h30m42s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-02 07:11:07 Duration: 6m5s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-02 15:10:31 Duration: 5m30s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-02 09:10:26 Duration: 5m24s Database: rio User: intelifix Remote: [local] Application: psql
2 1h6m16s 179 151ms 5m52s 22s216ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 02 07 22 11m34s 31s589ms 08 19 5m53s 18s582ms 09 31 6m19s 12s231ms 10 25 14m35s 35s27ms 11 27 16m34s 36s822ms 12 9 6s103ms 678ms 13 6 4s91ms 681ms 14 24 7m20s 18s352ms 15 12 3m43s 18s664ms 16 1 417ms 417ms 17 2 3s 1s500ms 18 1 1s523ms 1s523ms [ User: intelifix - Total duration: 1h6m16s - Times executed: 179 ]
[ Application: [unknown] - Total duration: 1h6m16s - Times executed: 179 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030683, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-02 07:41:17 Duration: 5m52s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030704, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-02 09:50:32 Duration: 5m36s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030690, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-02 08:50:51 Duration: 5m34s Database: rio User: intelifix Remote: [local] Application: [unknown]
3 1h3m18s 48 245ms 3m39s 1m19s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 02 07 3 4m29s 1m29s 08 3 4m 1m20s 09 3 4m1s 1m20s 10 3 3m58s 1m19s 11 3 4m1s 1m20s 12 3 3m48s 1m16s 13 3 3m55s 1m18s 14 3 3m59s 1m19s 15 3 3m55s 1m18s 16 3 3m56s 1m18s 17 3 3m50s 1m16s 18 3 3m51s 1m17s 19 3 3m56s 1m18s 20 3 3m54s 1m18s 21 3 3m52s 1m17s 22 3 3m47s 1m15s [ User: intelifix - Total duration: 1h3m18s - Times executed: 48 ]
[ Application: psql - Total duration: 1h3m18s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-02 07:16:00 Duration: 3m39s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-02 11:14:38 Duration: 3m30s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-02 09:14:43 Duration: 3m29s Database: brasilia User: intelifix Remote: [local] Application: psql
4 18m2s 3 2m34s 8m59s 6m analyze verbose;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 02 05 3 18m2s 6m [ User: intelifix - Total duration: 18m2s - Times executed: 3 ]
[ Application: psql - Total duration: 18m2s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-10-02 05:09:00 Duration: 8m59s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-02 05:15:29 Duration: 6m28s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-02 05:18:04 Duration: 2m34s Database: contagem User: intelifix Remote: [local] Application: psql
5 9m50s 276 190ms 2m26s 2s139ms call rs_giga_triagem (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 02 00 12 22s487ms 1s873ms 01 12 19s231ms 1s602ms 02 12 18s808ms 1s567ms 03 12 18s999ms 1s583ms 04 12 18s488ms 1s540ms 05 12 18s888ms 1s574ms 06 12 19s61ms 1s588ms 07 12 18s963ms 1s580ms 08 12 19s792ms 1s649ms 09 12 21s949ms 1s829ms 10 12 22s538ms 1s878ms 11 12 19s747ms 1s645ms 12 12 18s553ms 1s546ms 13 12 18s352ms 1s529ms 14 12 2m42s 13s555ms 15 12 18s583ms 1s548ms 16 12 18s733ms 1s561ms 17 12 18s757ms 1s563ms 18 12 18s885ms 1s573ms 19 12 18s800ms 1s566ms 20 12 21s12ms 1s751ms 21 12 18s512ms 1s542ms 22 12 18s718ms 1s559ms [ User: intelifix - Total duration: 9m50s - Times executed: 276 ]
[ Application: psql - Total duration: 9m50s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-02 14:17:30 Duration: 2m26s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-02 00:05:18 Duration: 5s502ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-02 09:15:10 Duration: 5s317ms Database: rio User: intelifix Remote: [local] Application: psql
6 8m38s 45 10s683ms 22s518ms 11s514ms create table temp0000293178 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 02 07 6 1m17s 12s948ms 08 6 1m8s 11s338ms 09 14 2m39s 11s369ms 10 14 2m35s 11s132ms 11 5 57s405ms 11s481ms [ User: intelifix - Total duration: 8m38s - Times executed: 45 ]
[ Application: [unknown] - Total duration: 8m38s - Times executed: 45 ]
-
CREATE TABLE temp0000293178 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-02 07:34:41 Duration: 22s518ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293178 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-02 09:12:52 Duration: 12s589ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293178 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-02 11:16:36 Duration: 12s356ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 7m6s 1 7m6s 7m6s 7m6s select * from rs_fast_excel (?, ?) / 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 (/ 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 (/ 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 (/ 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 (/ 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 (/ 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 (/ 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 #7
Day Hour Count Duration Avg duration Oct 02 11 1 7m6s 7m6s [ User: intelifix - Total duration: 7m6s - Times executed: 1 ]
[ Application: [unknown] - Total duration: 7m6s - Times executed: 1 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030720, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx') / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-02 11:39:57 Duration: 7m6s Database: rio User: intelifix Remote: [local] Application: [unknown]
8 5m33s 521 150ms 3s498ms 640ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 02 07 20 11s896ms 594ms 08 44 29s606ms 672ms 09 66 55s35ms 833ms 10 39 44s513ms 1s141ms 11 80 46s539ms 581ms 12 7 4s879ms 697ms 13 36 19s869ms 551ms 14 110 1m2s 566ms 15 81 38s375ms 473ms 16 34 16s656ms 489ms 17 4 4s21ms 1s5ms [ User: intelifix - Total duration: 5m33s - Times executed: 521 ]
[ Application: [unknown] - Total duration: 5m33s - Times executed: 521 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (60009, 407, '835120918003117,241673336175,230043631228,241680311638,241654553456,241608686981,241607183434,241655231637,241674084868,241593304459,241607182626,230043618600,241713750816,241670019701,241607182424,241704326876,241668204552,241708968800,241679862929,241711220513,241622605051,241671508398,241602649400,241650443739,241732101316,241695590514,241660118487,241692684461,241689394050,241695489314,241709240724,241694340628,241609911838,241704736871,241695588997,241659687884,241668206168,241730934142,241728637778,241656745768,241614511636,241730938586,241713725560,241617324749,241711196267,230047921018,241659721828,241649660420,241620793438,241619827597,241728683440', '',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-10-02 09:24:57 Duration: 3s498ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (60012, 406, 'ZTE3ANNT3H44751,D831399ADC72,D831399ADC73,ZTEGDD327F6E$ZTE3ANNQ8110956,689E29BCDF93,689E29BCDF94,ZTEGD7B7655C$ZTE3ANNR9316781,D89A0D83E959,D89A0D83E95A,ZTEGDB14B58C$ZTE3ANNR7B55033,3891484DF67D,3891484DF67E,ZTEGDB086859$ZTE3ANNR9W45039,D89A0DAC7BBD,D89A0DAC7BBE,ZTEGDB16C19A$ZTE3ANNT7U14599,589204015624,589204015625,ZTEGDF0325FB$ZTE3ANNR3J39831,F4E84F89F3EA,F4E84F89F3EB,ZTEGD97BFD61$ZTE3ANNQ9J19209,843C992D936B,843C992D936C,ZTEGD7BB53B4$ZTE3ANNR3J30265,F4E84F8913B6,F4E84F8913B7,ZTEGD97BD803$ZTE3ANNRB747522,5872C99292FD,5872C99292FE,ZTEGDC61E475$ZTE3ANNQ8M08086,843C991F856F,843C991F8570,ZTEGD7BA6703$ZTE3ANNR5W25171,48D68230D1BC,48D68230D1BD,ZTEGDB006252$ZTE3ANNR1Y02227,14CA56CCDEAD,14CA56CCDEAE,ZTEGD9707F0E$ZTE3ANNRCB61973,D83139237B7C,D83139237B7D,ZTEGDD2AA7AA$ZTE3ANNRCB71291,D831392455E0,D831392455E1,ZTEGDD2ACC10$ZTE3ANNRB708416,5872C98EFE71,5872C98EFE72,ZTEGDC614BB3$ZTE3ANNR3J04836,F4E84F86BFB8,F4E84F86BFB9,ZTEGD97B74AE$ZTE3ANNR3Y22471,4896D951CF62,4896D951CF63,ZTEGD97E887C$ZTE3ANNT7U14627,5892040156CC,5892040156CD,ZTEGDF032617$ZTE3ANNRCB71381,D831392457FC,D831392457FD,ZTEGDD2ACC6A$ZTE3ANNR3Y01544,4896D94FE4E8,4896D94FE4E9,ZTEGD97E36BD$ZTE3ANNQ8F08972,689E29FCF525,689E29FCF526,ZTEGD7BA1FDC$ZTE3ANNR6R27817,48D6823810B8,48D6823810B9,ZTEGDB01977C$ZTE3ANNR3Y13230,4896D950F6CC,4896D950F6CD,ZTEZD97E6463$ZTE3ANNQ4N04307,3CF9F0A8F6A0,3CF9F0A8F6A1,ZTEGD64113CE$ZTE3ANNR2Q36682,F4E84F840FBC,F4E84F840FBD,ZTEGD97B0204$ZTE3ANNR8C09355,3891484F6249,3891484F624A,ZTEGDB08A4FB$ZTE3ANNT4Q05352,F00C51554BC8,F00C51554BC9,ZTEGDE35921D$ZTE3ANNR3J06971,F4E84F86F1C2,F4E84F86F1C3,ZTEGD97B7D05$ZTE3ANNR6R23296,48D68237A6C2,48D68237A6C3,ZTEGDB0185D3$ZTE3ANNQ8127213,689E29BE5C99,689E29BE5C9A,ZTEGD7B7A4DD$ZTE3ANNRAD24305,D89A0DB01409,D89A0DB0140A,ZTEGDB175AFC$ZTE3ANNT7U23020,589204021B82,589204021B83,ZTEGDF0346E0$ZTE3ANNT3J12706,D83139A1151E,D83139A1151F,ZTEGDD3388E0$ZTE3ANNR4N39501,4896D958F8E6,4896D958F8E7,ZTEGD97FBA12$ZTE3ANNR9W44778,D89A0DAC759F,D89A0DAC75A0,ZTEGDB16C095$ZTE3ANNR6R23023,48D68237A05C,48D68237A05D,ZTEGDB0184C2$ZTE3ANNR5W00850,48D6822E97B6,48D6822E97B7,ZTEGDB000351$ZTE3ANNT2V85365,D83139935F96,D83139935F97,ZTEGDD313FF4$ZTE3ANNR5W69082,48D68234D6E6,48D68234D6E7,ZTEGDB010DD9$ZTE3ANNR3J05863,F4E84F86D7CA,F4E84F86D7CB,ZTEGD97B78B1$ZTE3ANNR3Y22347,4896D951CC7A,4896D951CC7B,ZTEGD97E8800', '',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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-02 08:54:01 Duration: 3s407ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (60014, 407, 'ZTE3A8TT2L04222,7C7D21F17E4B$ZTE3A8TQCH13962,DC5193D9652E$ZTE3A8TRCB04596,7C7D21ECD8D3$ZTE3A8TRCB04627,7C7D21ECD94F$ZTE3A8TT4724652,14200458FF82$ZTE3A8TT3304101,142004531316$ZTE3A8TT4724408,14200458FBB2$ZTE3A8TT4X00698,1420045917AA$ZTE3A8TR6D23832,E44E12B0CB01$ZTE3A8TR6D23402,E44E12B0C449$ZTE3A8TR6D25002,E44E12B0DD49$ZTE3A8TT3R18868,1420045716B2$ZTE3A8TT3304124,142004531372$ZTE3A8TT3C03359,1420045495EE$ZTE3A8TR5U23573,E44E1292CE9B$ZTE3A8TR5U17632,E44E129271C7$ZTE3A8TR5U25327,E44E1292EA03$ZTE3A8TT4724179,14200458F81E$ZTE3A8TT4723615,14200458EF4E$ZTE3A8TQCH14068,DC5193D966D6$ZTE3A8TT7P17236,C492D9465AA7$ZTE3A8TR5U25343,E44E1292EA43$ZTE3A8TT3C03438,14200454972A$ZTE3A8TR6D24872,E44E12B0DB41$ZTE3A8TT2L03613,7C7D21F174C7$ZTE3A8TT3R18877,1420045716D6$ZTE3A8TT4723078,14200458E6EA$ZTE3A8TT2L04215,7C7D21F17E2F$ZTE3A8TT2L04189,7C7D21F17DC7$ZTE3A8TR5U17638,E44E129271DF$ZTE3A8TR4708126,DC5193DB877E$ZTE3A8TT2L03527,7C7D21F1736F$ZTE3A8TT3C03379,14200454963E', '',05,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-02 14:13:35 Duration: 2s918ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
9 5m9s 66 1s683ms 11s125ms 4s696ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 02 07 3 7s492ms 2s497ms 08 3 8s64ms 2s688ms 09 4 30s80ms 7s520ms 10 4 14s997ms 3s749ms 11 14 1m19s 5s651ms 12 2 4s340ms 2s170ms 13 10 44s726ms 4s472ms 14 7 39s427ms 5s632ms 15 13 1m9s 5s315ms 16 3 6s480ms 2s160ms 17 3 6s116ms 2s38ms [ User: intelifix - Total duration: 5m9s - Times executed: 66 ]
[ Application: [unknown] - Total duration: 5m9s - Times executed: 66 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-02', 0320, '', '', 0, 6, '2026-10-01');
Date: 2026-10-02 09:07:02 Duration: 11s125ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-01', 099, '', '', 0, 6, '2026-10-01');
Date: 2026-10-02 11:12:26 Duration: 9s537ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-02', 0173, '', '', 0, 6, '2026-10-01');
Date: 2026-10-02 15:13:39 Duration: 8s721ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 4m35s 667 150ms 1s520ms 412ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 02 06 1 1s37ms 1s37ms 07 81 34s741ms 428ms 08 114 40s467ms 354ms 09 78 29s250ms 375ms 10 118 57s804ms 489ms 11 80 41s320ms 516ms 12 7 2s878ms 411ms 13 38 15s105ms 397ms 14 69 27s640ms 400ms 15 40 12s265ms 306ms 16 27 8s174ms 302ms 17 14 4s449ms 317ms [ User: intelifix - Total duration: 4m35s - Times executed: 667 ]
[ Application: [unknown] - Total duration: 4m35s - Times executed: 667 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "293217", "modelo" : "464", "itens" : "241813982932,241771275767,241762340216,241814247076,241814539204,241762333447,241743349393,241771298193,241813040102,241826747185,241739840927,241814372645,241738783135,241771230511,241762630828,241742717177,241812884553,241820506374,241761026888,241776753743,241688054559,241776679718,241813336471,241764598998,241812948600,241815567777,241815578687,241770170015,241738519898,241772578991,241814363856,241742671921,241820226268,241813044445,241819013535,241819419411,241744780814,241777659195,241814141130,241771365574,241747666381,241819418401,241814097084,241779009697,241776392339,241777657680,241817771630,241826005968,241819297580,241770062125,241759665577,241776786574,241813341321,241814568803,241761346571,241765507280,241774229602,241767688706,241776344455,241778923147", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-02 11:25:22 Duration: 1s520ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "293231", "modelo" : "464", "itens" : "241767875166,241740678089,241739163049,241738361826,241739204646,241768933541,241819816172,241818862432,241818438495,241778184354,241814045968,241743214151,241775635261,241739746068,241812739107,241777799311,241819257475,241770935779,241767540106,241826287286,241815746684,241767410520,241772664657,241765391333,241819821931,241775678295,241745453135,241760876469,241775273453,241763335576,241764392032,241760841214,241739700812,241818997899,241740755774,241745925964,241744709011,241818949208,241765403657,241814567287,241765411133,241814335873,241771197678,241742634263,241819907797,241688049205,241812902838,241770062024,241760014455,241742635778,241812878390,241819419714,241779224343,241759981725,241765325265,241768950008,241765359612,241738321216,241742873355,241745602645", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-02 14:30:04 Duration: 1s519ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "293023", "modelo" : "464", "itens" : "241742850424,241778744869,241748169618,241771153354,241813979092,241766441525,241818943551,241687257477,241774216974,241820098197,241819019595,241761058080,241815560303,241815557395,863400614611329,241778719715,241765627393,241762554961,241746634956,241742969806,241777668994,241773864359,241774217479,241815835256,241762764656,241742757080,241772713046,241777649902,241779111123,241738923856,241762348701,241768082336,241762599612,241820665155,241776813951,241774091531,241761397889,241777803958,241761567580,241820488998,241775879909,241826171720,241819638804,241777851213,241746105656,241738682542,241765617291,241744544348,241742824259,241747589000,241771206871,241814238085,241778706077,241814545669,241770252929", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-02 10:40:38 Duration: 1s438ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 4m5s 22 10s849ms 11s694ms 11s148ms create table temp0000293166 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 02 07 7 1m17s 11s54ms 09 15 2m47s 11s192ms [ User: intelifix - Total duration: 4m5s - Times executed: 22 ]
[ Application: [unknown] - Total duration: 4m5s - Times executed: 22 ]
-
CREATE TABLE temp0000293166 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-02 09:17:05 Duration: 11s694ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293166 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-02 09:05:39 Duration: 11s542ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293166 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-02 09:21:36 Duration: 11s340ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 4m1s 152 160ms 11s303ms 1s590ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 02 00 6 17s827ms 2s971ms 01 6 6s823ms 1s137ms 02 6 5s714ms 952ms 03 5 5s307ms 1s61ms 04 6 6s923ms 1s153ms 05 5 6s831ms 1s366ms 07 10 20s676ms 2s67ms 08 13 27s914ms 2s147ms 09 12 26s251ms 2s187ms 10 12 25s119ms 2s93ms 11 12 25s836ms 2s153ms 12 10 12s151ms 1s215ms 13 6 4s37ms 672ms 14 12 18s316ms 1s526ms 15 9 6s811ms 756ms 16 6 5s903ms 983ms 17 4 1s832ms 458ms 21 6 8s15ms 1s335ms 22 6 9s402ms 1s567ms [ User: intelifix - Total duration: 4m1s - Times executed: 152 ]
[ Application: psql - Total duration: 4m1s - Times executed: 152 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-02 00:05:12 Duration: 11s303ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-02 08:45:06 Duration: 4s852ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-02 07:45:05 Duration: 4s295ms Database: rio User: intelifix Remote: [local] Application: psql
13 3m11s 17 11s8ms 12s735ms 11s258ms create table temp0000293222 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 02 10 6 1m8s 11s443ms 11 11 2m2s 11s158ms [ User: intelifix - Total duration: 3m11s - Times executed: 17 ]
[ Application: [unknown] - Total duration: 3m11s - Times executed: 17 ]
-
CREATE TABLE temp0000293222 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-02 10:58:24 Duration: 12s735ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293222 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-02 11:04:42 Duration: 11s539ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293222 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-02 10:58:49 Duration: 11s337ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 2m12s 4 4s63ms 1m2s 33s9ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 02 20 2 1m6s 33s159ms 23 2 1m5s 32s859ms [ User: intelifix - Total duration: 2m12s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m12s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-02 20:08:37 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-02 23:16:33 Duration: 1m1s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-02 23:33:39 Duration: 4s160ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 2m2s 2 2s686ms 2m 1m1s select * from rs_fast_excel (?, ?) / 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 (/ 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 (/ 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 #15
Day Hour Count Duration Avg duration Oct 02 10 1 2s686ms 2s686ms 15 1 2m 2m [ User: intelifix - Total duration: 2m2s - Times executed: 2 ]
[ Application: [unknown] - Total duration: 2m2s - Times executed: 2 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030725, 0508 )', '/var/www/html/tmp/nf_carga_lotes_0508.xlsx') / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-02 15:20:04 Duration: 2m Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_seriais_expedidos(7,DATE(''2026-10-01''),DATE(''2026-10-01'')) ;', '/var/www/html/tmp/temp_54.xlsx') / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-02 10:00:02 Duration: 2s686ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
16 1m50s 10 10s775ms 11s700ms 11s84ms create table temp0000293278 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 02 14 4 44s603ms 11s150ms 15 6 1m6s 11s39ms [ User: intelifix - Total duration: 1m50s - Times executed: 10 ]
[ Application: [unknown] - Total duration: 1m50s - Times executed: 10 ]
-
CREATE TABLE temp0000293278 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-02 15:39:25 Duration: 11s700ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293278 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-02 14:36:03 Duration: 11s479ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293278 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-02 14:35:42 Duration: 11s212ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 1m47s 6 3s194ms 39s964ms 17s842ms copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 02 20 3 53s637ms 17s879ms 23 3 53s415ms 17s805ms [ User: intelifix - Total duration: 1m47s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m47s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-02 20:06:25 Duration: 39s964ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-02 23:14:21 Duration: 39s722ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-02 23:33:15 Duration: 10s489ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 1m46s 4 330ms 53s124ms 26s521ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 02 20 2 53s457ms 26s728ms 23 2 52s626ms 26s313ms [ User: intelifix - Total duration: 1m46s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m46s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-02 20:05:43 Duration: 53s124ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-02 23:13:40 Duration: 52s296ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-02 20:10:00 Duration: 332ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 1m44s 9 10s837ms 13s304ms 11s600ms create table temp0000293266 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 02 14 9 1m44s 11s600ms [ User: intelifix - Total duration: 1m44s - Times executed: 9 ]
[ Application: [unknown] - Total duration: 1m44s - Times executed: 9 ]
-
CREATE TABLE temp0000293266 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-02 14:34:44 Duration: 13s304ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293266 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-02 14:33:18 Duration: 12s67ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293266 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-02 14:09:48 Duration: 11s925ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 1m40s 34 586ms 14s46ms 2s961ms 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 #20
Day Hour Count Duration Avg duration Oct 02 08 3 16s712ms 5s570ms 09 1 10s272ms 10s272ms 10 1 8s613ms 8s613ms 11 2 14s541ms 7s270ms 12 2 1s457ms 728ms 13 2 1s607ms 803ms 14 3 13s308ms 4s436ms 15 2 20s138ms 10s69ms 16 2 1s490ms 745ms 17 3 2s339ms 779ms 18 2 1s644ms 822ms 19 3 2s79ms 693ms 20 3 2s693ms 897ms 21 3 2s366ms 788ms 22 2 1s437ms 718ms [ User: intelifix - Total duration: 1m40s - Times executed: 34 ]
[ Application: psql - Total duration: 1m40s - Times executed: 34 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-02 15:00:15 Duration: 14s46ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-02 08:00:14 Duration: 13s301ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-02 09:20:11 Duration: 10s272ms Database: rio User: intelifix Remote: [local] Application: psql
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 667 4m35s 150ms 1s520ms 412ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 02 06 1 1s37ms 1s37ms 07 81 34s741ms 428ms 08 114 40s467ms 354ms 09 78 29s250ms 375ms 10 118 57s804ms 489ms 11 80 41s320ms 516ms 12 7 2s878ms 411ms 13 38 15s105ms 397ms 14 69 27s640ms 400ms 15 40 12s265ms 306ms 16 27 8s174ms 302ms 17 14 4s449ms 317ms [ User: intelifix - Total duration: 4m35s - Times executed: 667 ]
[ Application: [unknown] - Total duration: 4m35s - Times executed: 667 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "293217", "modelo" : "464", "itens" : "241813982932,241771275767,241762340216,241814247076,241814539204,241762333447,241743349393,241771298193,241813040102,241826747185,241739840927,241814372645,241738783135,241771230511,241762630828,241742717177,241812884553,241820506374,241761026888,241776753743,241688054559,241776679718,241813336471,241764598998,241812948600,241815567777,241815578687,241770170015,241738519898,241772578991,241814363856,241742671921,241820226268,241813044445,241819013535,241819419411,241744780814,241777659195,241814141130,241771365574,241747666381,241819418401,241814097084,241779009697,241776392339,241777657680,241817771630,241826005968,241819297580,241770062125,241759665577,241776786574,241813341321,241814568803,241761346571,241765507280,241774229602,241767688706,241776344455,241778923147", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-02 11:25:22 Duration: 1s520ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "293231", "modelo" : "464", "itens" : "241767875166,241740678089,241739163049,241738361826,241739204646,241768933541,241819816172,241818862432,241818438495,241778184354,241814045968,241743214151,241775635261,241739746068,241812739107,241777799311,241819257475,241770935779,241767540106,241826287286,241815746684,241767410520,241772664657,241765391333,241819821931,241775678295,241745453135,241760876469,241775273453,241763335576,241764392032,241760841214,241739700812,241818997899,241740755774,241745925964,241744709011,241818949208,241765403657,241814567287,241765411133,241814335873,241771197678,241742634263,241819907797,241688049205,241812902838,241770062024,241760014455,241742635778,241812878390,241819419714,241779224343,241759981725,241765325265,241768950008,241765359612,241738321216,241742873355,241745602645", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-02 14:30:04 Duration: 1s519ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "293023", "modelo" : "464", "itens" : "241742850424,241778744869,241748169618,241771153354,241813979092,241766441525,241818943551,241687257477,241774216974,241820098197,241819019595,241761058080,241815560303,241815557395,863400614611329,241778719715,241765627393,241762554961,241746634956,241742969806,241777668994,241773864359,241774217479,241815835256,241762764656,241742757080,241772713046,241777649902,241779111123,241738923856,241762348701,241768082336,241762599612,241820665155,241776813951,241774091531,241761397889,241777803958,241761567580,241820488998,241775879909,241826171720,241819638804,241777851213,241746105656,241738682542,241765617291,241744544348,241742824259,241747589000,241771206871,241814238085,241778706077,241814545669,241770252929", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-02 10:40:38 Duration: 1s438ms Database: rio User: intelifix Remote: [local] Application: [unknown]
2 521 5m33s 150ms 3s498ms 640ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 02 07 20 11s896ms 594ms 08 44 29s606ms 672ms 09 66 55s35ms 833ms 10 39 44s513ms 1s141ms 11 80 46s539ms 581ms 12 7 4s879ms 697ms 13 36 19s869ms 551ms 14 110 1m2s 566ms 15 81 38s375ms 473ms 16 34 16s656ms 489ms 17 4 4s21ms 1s5ms [ User: intelifix - Total duration: 5m33s - Times executed: 521 ]
[ Application: [unknown] - Total duration: 5m33s - Times executed: 521 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (60009, 407, '835120918003117,241673336175,230043631228,241680311638,241654553456,241608686981,241607183434,241655231637,241674084868,241593304459,241607182626,230043618600,241713750816,241670019701,241607182424,241704326876,241668204552,241708968800,241679862929,241711220513,241622605051,241671508398,241602649400,241650443739,241732101316,241695590514,241660118487,241692684461,241689394050,241695489314,241709240724,241694340628,241609911838,241704736871,241695588997,241659687884,241668206168,241730934142,241728637778,241656745768,241614511636,241730938586,241713725560,241617324749,241711196267,230047921018,241659721828,241649660420,241620793438,241619827597,241728683440', '',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-10-02 09:24:57 Duration: 3s498ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (60012, 406, 'ZTE3ANNT3H44751,D831399ADC72,D831399ADC73,ZTEGDD327F6E$ZTE3ANNQ8110956,689E29BCDF93,689E29BCDF94,ZTEGD7B7655C$ZTE3ANNR9316781,D89A0D83E959,D89A0D83E95A,ZTEGDB14B58C$ZTE3ANNR7B55033,3891484DF67D,3891484DF67E,ZTEGDB086859$ZTE3ANNR9W45039,D89A0DAC7BBD,D89A0DAC7BBE,ZTEGDB16C19A$ZTE3ANNT7U14599,589204015624,589204015625,ZTEGDF0325FB$ZTE3ANNR3J39831,F4E84F89F3EA,F4E84F89F3EB,ZTEGD97BFD61$ZTE3ANNQ9J19209,843C992D936B,843C992D936C,ZTEGD7BB53B4$ZTE3ANNR3J30265,F4E84F8913B6,F4E84F8913B7,ZTEGD97BD803$ZTE3ANNRB747522,5872C99292FD,5872C99292FE,ZTEGDC61E475$ZTE3ANNQ8M08086,843C991F856F,843C991F8570,ZTEGD7BA6703$ZTE3ANNR5W25171,48D68230D1BC,48D68230D1BD,ZTEGDB006252$ZTE3ANNR1Y02227,14CA56CCDEAD,14CA56CCDEAE,ZTEGD9707F0E$ZTE3ANNRCB61973,D83139237B7C,D83139237B7D,ZTEGDD2AA7AA$ZTE3ANNRCB71291,D831392455E0,D831392455E1,ZTEGDD2ACC10$ZTE3ANNRB708416,5872C98EFE71,5872C98EFE72,ZTEGDC614BB3$ZTE3ANNR3J04836,F4E84F86BFB8,F4E84F86BFB9,ZTEGD97B74AE$ZTE3ANNR3Y22471,4896D951CF62,4896D951CF63,ZTEGD97E887C$ZTE3ANNT7U14627,5892040156CC,5892040156CD,ZTEGDF032617$ZTE3ANNRCB71381,D831392457FC,D831392457FD,ZTEGDD2ACC6A$ZTE3ANNR3Y01544,4896D94FE4E8,4896D94FE4E9,ZTEGD97E36BD$ZTE3ANNQ8F08972,689E29FCF525,689E29FCF526,ZTEGD7BA1FDC$ZTE3ANNR6R27817,48D6823810B8,48D6823810B9,ZTEGDB01977C$ZTE3ANNR3Y13230,4896D950F6CC,4896D950F6CD,ZTEZD97E6463$ZTE3ANNQ4N04307,3CF9F0A8F6A0,3CF9F0A8F6A1,ZTEGD64113CE$ZTE3ANNR2Q36682,F4E84F840FBC,F4E84F840FBD,ZTEGD97B0204$ZTE3ANNR8C09355,3891484F6249,3891484F624A,ZTEGDB08A4FB$ZTE3ANNT4Q05352,F00C51554BC8,F00C51554BC9,ZTEGDE35921D$ZTE3ANNR3J06971,F4E84F86F1C2,F4E84F86F1C3,ZTEGD97B7D05$ZTE3ANNR6R23296,48D68237A6C2,48D68237A6C3,ZTEGDB0185D3$ZTE3ANNQ8127213,689E29BE5C99,689E29BE5C9A,ZTEGD7B7A4DD$ZTE3ANNRAD24305,D89A0DB01409,D89A0DB0140A,ZTEGDB175AFC$ZTE3ANNT7U23020,589204021B82,589204021B83,ZTEGDF0346E0$ZTE3ANNT3J12706,D83139A1151E,D83139A1151F,ZTEGDD3388E0$ZTE3ANNR4N39501,4896D958F8E6,4896D958F8E7,ZTEGD97FBA12$ZTE3ANNR9W44778,D89A0DAC759F,D89A0DAC75A0,ZTEGDB16C095$ZTE3ANNR6R23023,48D68237A05C,48D68237A05D,ZTEGDB0184C2$ZTE3ANNR5W00850,48D6822E97B6,48D6822E97B7,ZTEGDB000351$ZTE3ANNT2V85365,D83139935F96,D83139935F97,ZTEGDD313FF4$ZTE3ANNR5W69082,48D68234D6E6,48D68234D6E7,ZTEGDB010DD9$ZTE3ANNR3J05863,F4E84F86D7CA,F4E84F86D7CB,ZTEGD97B78B1$ZTE3ANNR3Y22347,4896D951CC7A,4896D951CC7B,ZTEGD97E8800', '',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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-02 08:54:01 Duration: 3s407ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (60014, 407, 'ZTE3A8TT2L04222,7C7D21F17E4B$ZTE3A8TQCH13962,DC5193D9652E$ZTE3A8TRCB04596,7C7D21ECD8D3$ZTE3A8TRCB04627,7C7D21ECD94F$ZTE3A8TT4724652,14200458FF82$ZTE3A8TT3304101,142004531316$ZTE3A8TT4724408,14200458FBB2$ZTE3A8TT4X00698,1420045917AA$ZTE3A8TR6D23832,E44E12B0CB01$ZTE3A8TR6D23402,E44E12B0C449$ZTE3A8TR6D25002,E44E12B0DD49$ZTE3A8TT3R18868,1420045716B2$ZTE3A8TT3304124,142004531372$ZTE3A8TT3C03359,1420045495EE$ZTE3A8TR5U23573,E44E1292CE9B$ZTE3A8TR5U17632,E44E129271C7$ZTE3A8TR5U25327,E44E1292EA03$ZTE3A8TT4724179,14200458F81E$ZTE3A8TT4723615,14200458EF4E$ZTE3A8TQCH14068,DC5193D966D6$ZTE3A8TT7P17236,C492D9465AA7$ZTE3A8TR5U25343,E44E1292EA43$ZTE3A8TT3C03438,14200454972A$ZTE3A8TR6D24872,E44E12B0DB41$ZTE3A8TT2L03613,7C7D21F174C7$ZTE3A8TT3R18877,1420045716D6$ZTE3A8TT4723078,14200458E6EA$ZTE3A8TT2L04215,7C7D21F17E2F$ZTE3A8TT2L04189,7C7D21F17DC7$ZTE3A8TR5U17638,E44E129271DF$ZTE3A8TR4708126,DC5193DB877E$ZTE3A8TT2L03527,7C7D21F1736F$ZTE3A8TT3C03379,14200454963E', '',05,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-02 14:13:35 Duration: 2s918ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
3 276 9m50s 190ms 2m26s 2s139ms call rs_giga_triagem (?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 02 00 12 22s487ms 1s873ms 01 12 19s231ms 1s602ms 02 12 18s808ms 1s567ms 03 12 18s999ms 1s583ms 04 12 18s488ms 1s540ms 05 12 18s888ms 1s574ms 06 12 19s61ms 1s588ms 07 12 18s963ms 1s580ms 08 12 19s792ms 1s649ms 09 12 21s949ms 1s829ms 10 12 22s538ms 1s878ms 11 12 19s747ms 1s645ms 12 12 18s553ms 1s546ms 13 12 18s352ms 1s529ms 14 12 2m42s 13s555ms 15 12 18s583ms 1s548ms 16 12 18s733ms 1s561ms 17 12 18s757ms 1s563ms 18 12 18s885ms 1s573ms 19 12 18s800ms 1s566ms 20 12 21s12ms 1s751ms 21 12 18s512ms 1s542ms 22 12 18s718ms 1s559ms [ User: intelifix - Total duration: 9m50s - Times executed: 276 ]
[ Application: psql - Total duration: 9m50s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-02 14:17:30 Duration: 2m26s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-02 00:05:18 Duration: 5s502ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-02 09:15:10 Duration: 5s317ms Database: rio User: intelifix Remote: [local] Application: psql
4 179 1h6m16s 151ms 5m52s 22s216ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 02 07 22 11m34s 31s589ms 08 19 5m53s 18s582ms 09 31 6m19s 12s231ms 10 25 14m35s 35s27ms 11 27 16m34s 36s822ms 12 9 6s103ms 678ms 13 6 4s91ms 681ms 14 24 7m20s 18s352ms 15 12 3m43s 18s664ms 16 1 417ms 417ms 17 2 3s 1s500ms 18 1 1s523ms 1s523ms [ User: intelifix - Total duration: 1h6m16s - Times executed: 179 ]
[ Application: [unknown] - Total duration: 1h6m16s - Times executed: 179 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030683, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-02 07:41:17 Duration: 5m52s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030704, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-02 09:50:32 Duration: 5m36s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030690, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-02 08:50:51 Duration: 5m34s Database: rio User: intelifix Remote: [local] Application: [unknown]
5 152 4m1s 160ms 11s303ms 1s590ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 02 00 6 17s827ms 2s971ms 01 6 6s823ms 1s137ms 02 6 5s714ms 952ms 03 5 5s307ms 1s61ms 04 6 6s923ms 1s153ms 05 5 6s831ms 1s366ms 07 10 20s676ms 2s67ms 08 13 27s914ms 2s147ms 09 12 26s251ms 2s187ms 10 12 25s119ms 2s93ms 11 12 25s836ms 2s153ms 12 10 12s151ms 1s215ms 13 6 4s37ms 672ms 14 12 18s316ms 1s526ms 15 9 6s811ms 756ms 16 6 5s903ms 983ms 17 4 1s832ms 458ms 21 6 8s15ms 1s335ms 22 6 9s402ms 1s567ms [ User: intelifix - Total duration: 4m1s - Times executed: 152 ]
[ Application: psql - Total duration: 4m1s - Times executed: 152 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-02 00:05:12 Duration: 11s303ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-02 08:45:06 Duration: 4s852ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-02 07:45:05 Duration: 4s295ms Database: rio User: intelifix Remote: [local] Application: psql
6 84 26s290ms 298ms 342ms 312ms select pro_id, pgp_sym_decrypt(nome, ?)::varchar, pgp_sym_decrypt(descricao, ?)::varchar, pgp_sym_decrypt(classe, ?)::varchar, pgp_sym_decrypt(php, ?)::varchar, pgp_sym_decrypt(extras, ?)::varchar from progs order by pro_id;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 02 00 1 307ms 307ms 01 2 614ms 307ms 05 3 918ms 306ms 06 3 947ms 315ms 07 6 1s908ms 318ms 08 9 2s807ms 311ms 09 9 2s859ms 317ms 10 10 3s165ms 316ms 11 6 1s889ms 314ms 12 5 1s536ms 307ms 13 6 1s844ms 307ms 14 9 2s840ms 315ms 15 9 2s784ms 309ms 16 3 934ms 311ms 17 2 615ms 307ms 18 1 317ms 317ms [ User: lenon - Total duration: 26s290ms - Times executed: 84 ]
[ Application: [unknown] - Total duration: 26s290ms - Times executed: 84 ]
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-10-02 10:38:24 Duration: 342ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-10-02 09:48:08 Duration: 338ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-10-02 14:05:05 Duration: 337ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
7 80 34s551ms 151ms 1s996ms 431ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 02 07 18 8s226ms 457ms 08 11 4s46ms 367ms 09 12 7s360ms 613ms 10 6 2s681ms 446ms 11 14 5s623ms 401ms 12 10 2s794ms 279ms 13 3 1s167ms 389ms 14 6 2s653ms 442ms [ User: intelifix - Total duration: 34s551ms - Times executed: 80 ]
[ Application: [unknown] - Total duration: 34s551ms - Times executed: 80 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0292662) LIMIT 1;
Date: 2026-10-02 07:21:48 Duration: 1s996ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0292688) LIMIT 1;
Date: 2026-10-02 09:32:05 Duration: 1s820ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0139219) LIMIT 1;
Date: 2026-10-02 09:19:50 Duration: 1s561ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
8 75 27s528ms 331ms 484ms 367ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 02 01 2 743ms 371ms 05 3 1s128ms 376ms 07 4 1s454ms 363ms 08 8 2s893ms 361ms 09 8 2s966ms 370ms 10 10 3s791ms 379ms 11 6 2s217ms 369ms 12 5 1s841ms 368ms 13 6 2s137ms 356ms 14 9 3s272ms 363ms 15 9 3s240ms 360ms 16 3 1s96ms 365ms 17 2 744ms 372ms [ User: intelifix - Total duration: 27s528ms - Times executed: 75 ]
[ Application: [unknown] - Total duration: 27s528ms - Times executed: 75 ]
-
select * from rs_menu_grants (397, 18, 1);
Date: 2026-10-02 10:38:24 Duration: 484ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (184, 20, 1);
Date: 2026-10-02 08:00:14 Duration: 421ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (499, 19, 1);
Date: 2026-10-02 05:22:41 Duration: 413ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 73 20s416ms 258ms 351ms 279ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 02 07 4 1s151ms 287ms 08 5 1s434ms 286ms 09 20 5s596ms 279ms 10 12 3s399ms 283ms 11 10 2s809ms 280ms 12 1 272ms 272ms 13 2 531ms 265ms 14 7 1s939ms 277ms 15 7 1s932ms 276ms 16 2 531ms 265ms 17 2 549ms 274ms 18 1 267ms 267ms [ User: intelifix - Total duration: 20s416ms - Times executed: 73 ]
[ Application: [unknown] - Total duration: 20s416ms - Times executed: 73 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-10-02 09:11:34 Duration: 351ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-10-02 10:42:27 Duration: 331ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-10-02 08:55:25 Duration: 329ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 66 5m9s 1s683ms 11s125ms 4s696ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 02 07 3 7s492ms 2s497ms 08 3 8s64ms 2s688ms 09 4 30s80ms 7s520ms 10 4 14s997ms 3s749ms 11 14 1m19s 5s651ms 12 2 4s340ms 2s170ms 13 10 44s726ms 4s472ms 14 7 39s427ms 5s632ms 15 13 1m9s 5s315ms 16 3 6s480ms 2s160ms 17 3 6s116ms 2s38ms [ User: intelifix - Total duration: 5m9s - Times executed: 66 ]
[ Application: [unknown] - Total duration: 5m9s - Times executed: 66 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-02', 0320, '', '', 0, 6, '2026-10-01');
Date: 2026-10-02 09:07:02 Duration: 11s125ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-01', 099, '', '', 0, 6, '2026-10-01');
Date: 2026-10-02 11:12:26 Duration: 9s537ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-02', 0173, '', '', 0, 6, '2026-10-01');
Date: 2026-10-02 15:13:39 Duration: 8s721ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 54 1m26s 570ms 19s221ms 1s608ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 02 08 3 2s282ms 760ms 09 4 9s128ms 2s282ms 10 5 11s718ms 2s343ms 11 4 11s944ms 2s986ms 12 4 2s945ms 736ms 13 4 4s494ms 1s123ms 14 3 2s225ms 741ms 15 3 4s765ms 1s588ms 16 4 3s101ms 775ms 17 3 2s502ms 834ms 18 4 21s636ms 5s409ms 19 3 2s163ms 721ms 20 3 2s355ms 785ms 21 3 2s312ms 770ms 22 4 3s264ms 816ms [ User: intelifix - Total duration: 1m26s - Times executed: 54 ]
[ Application: psql - Total duration: 1m26s - Times executed: 54 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-02 18:00:22 Duration: 19s221ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-02 11:40:10 Duration: 9s498ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-02 10:00:05 Duration: 4s433ms Database: rio User: intelifix Remote: [local] Application: psql
12 48 1h30m42s 2s104ms 6m5s 1m53s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 02 07 3 6m34s 2m11s 08 3 5m45s 1m55s 09 3 5m45s 1m55s 10 3 5m41s 1m53s 11 3 5m39s 1m53s 12 3 5m39s 1m53s 13 3 5m36s 1m52s 14 3 5m31s 1m50s 15 3 5m48s 1m56s 16 3 5m31s 1m50s 17 3 5m32s 1m50s 18 3 5m29s 1m49s 19 3 5m36s 1m52s 20 3 5m33s 1m51s 21 3 5m26s 1m48s 22 3 5m29s 1m49s [ User: intelifix - Total duration: 1h30m42s - Times executed: 48 ]
[ Application: psql - Total duration: 1h30m42s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-02 07:11:07 Duration: 6m5s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-02 15:10:31 Duration: 5m30s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-02 09:10:26 Duration: 5m24s Database: rio User: intelifix Remote: [local] Application: psql
13 48 1h3m18s 245ms 3m39s 1m19s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 02 07 3 4m29s 1m29s 08 3 4m 1m20s 09 3 4m1s 1m20s 10 3 3m58s 1m19s 11 3 4m1s 1m20s 12 3 3m48s 1m16s 13 3 3m55s 1m18s 14 3 3m59s 1m19s 15 3 3m55s 1m18s 16 3 3m56s 1m18s 17 3 3m50s 1m16s 18 3 3m51s 1m17s 19 3 3m56s 1m18s 20 3 3m54s 1m18s 21 3 3m52s 1m17s 22 3 3m47s 1m15s [ User: intelifix - Total duration: 1h3m18s - Times executed: 48 ]
[ Application: psql - Total duration: 1h3m18s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-02 07:16:00 Duration: 3m39s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-02 11:14:38 Duration: 3m30s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-02 09:14:43 Duration: 3m29s Database: brasilia User: intelifix Remote: [local] Application: psql
14 45 8m38s 10s683ms 22s518ms 11s514ms create table temp0000293178 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 02 07 6 1m17s 12s948ms 08 6 1m8s 11s338ms 09 14 2m39s 11s369ms 10 14 2m35s 11s132ms 11 5 57s405ms 11s481ms [ User: intelifix - Total duration: 8m38s - Times executed: 45 ]
[ Application: [unknown] - Total duration: 8m38s - Times executed: 45 ]
-
CREATE TABLE temp0000293178 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-02 07:34:41 Duration: 22s518ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293178 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-02 09:12:52 Duration: 12s589ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293178 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-02 11:16:36 Duration: 12s356ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 34 1m40s 586ms 14s46ms 2s961ms 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 #15
Day Hour Count Duration Avg duration Oct 02 08 3 16s712ms 5s570ms 09 1 10s272ms 10s272ms 10 1 8s613ms 8s613ms 11 2 14s541ms 7s270ms 12 2 1s457ms 728ms 13 2 1s607ms 803ms 14 3 13s308ms 4s436ms 15 2 20s138ms 10s69ms 16 2 1s490ms 745ms 17 3 2s339ms 779ms 18 2 1s644ms 822ms 19 3 2s79ms 693ms 20 3 2s693ms 897ms 21 3 2s366ms 788ms 22 2 1s437ms 718ms [ User: intelifix - Total duration: 1m40s - Times executed: 34 ]
[ Application: psql - Total duration: 1m40s - Times executed: 34 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-02 15:00:15 Duration: 14s46ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-02 08:00:14 Duration: 13s301ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-02 09:20:11 Duration: 10s272ms Database: rio User: intelifix Remote: [local] Application: psql
16 30 1m30s 220ms 15s523ms 3s8ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 02 07 3 24s895ms 8s298ms 08 3 6s18ms 2s6ms 09 9 18s58ms 2s6ms 10 5 18s692ms 3s738ms 11 5 11s864ms 2s372ms 14 3 8s740ms 2s913ms 15 2 1s981ms 990ms [ User: intelifix - Total duration: 1m30s - Times executed: 30 ]
[ Application: psql - Total duration: 1m30s - Times executed: 30 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030683);
Date: 2026-10-02 07:35:04 Duration: 15s523ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030685);
Date: 2026-10-02 07:44:34 Duration: 5s928ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030704);
Date: 2026-10-02 09:44:42 Duration: 5s363ms Database: rio User: intelifix Remote: [local] Application: psql
17 27 1m21s 165ms 39s299ms 3s34ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 02 07 3 1s24ms 341ms 08 2 364ms 182ms 09 6 1s160ms 193ms 10 5 41s623ms 8s324ms 11 5 24s684ms 4s936ms 14 4 5s991ms 1s497ms 15 2 7s79ms 3s539ms [ User: intelifix - Total duration: 1m21s - Times executed: 27 ]
[ Application: psql - Total duration: 1m21s - Times executed: 27 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030709);
Date: 2026-10-02 10:32:40 Duration: 39s299ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030716);
Date: 2026-10-02 11:11:05 Duration: 13s104ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030724);
Date: 2026-10-02 14:35:57 Duration: 5s393ms Database: rio User: intelifix Remote: [local] Application: psql
18 26 53s486ms 1s647ms 9s789ms 2s57ms create table temp0000293162 as select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 02 06 26 53s486ms 2s57ms [ User: intelifix - Total duration: 53s486ms - Times executed: 26 ]
[ Application: [unknown] - Total duration: 53s486ms - Times executed: 26 ]
-
CREATE TABLE temp0000293162 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "6", "cliente" : "0", "nf" : "", "data-de" : "27-09-2026", "data-ate" : "02-10-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-10-02 06:53:21 Duration: 9s789ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293162 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "6", "cliente" : "5", "nf" : "", "data-de" : "27-09-2026", "data-ate" : "02-10-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-10-02 06:55:06 Duration: 2s65ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293162 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "6", "cliente" : "5", "nf" : "", "data-de" : "27-09-2026", "data-ate" : "02-10-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-10-02 06:55:19 Duration: 1s898ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 26 6s209ms 150ms 362ms 238ms create table temp0000293000 as select * from rs_fluxos_lista (?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 02 08 9 1s564ms 173ms 09 3 581ms 193ms 10 7 1s774ms 253ms 11 3 903ms 301ms 13 2 660ms 330ms 14 2 724ms 362ms [ User: intelifix - Total duration: 6s209ms - Times executed: 26 ]
[ Application: [unknown] - Total duration: 6s209ms - Times executed: 26 ]
-
CREATE TABLE temp0000293000 AS SELECT * FROM RS_FLUXOS_LISTA (06, 00, 00, '02-10-2026', '02-10-2026', 0, '', 00);
Date: 2026-10-02 14:15:16 Duration: 362ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293000 AS SELECT * FROM RS_FLUXOS_LISTA (06, 00, 00, '02-10-2026', '02-10-2026', 0, '', 00);
Date: 2026-10-02 14:08:12 Duration: 362ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293000 AS SELECT * FROM RS_FLUXOS_LISTA (06, 00, 00, '02-10-2026', '02-10-2026', 0, '', 00);
Date: 2026-10-02 13:42:26 Duration: 334ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 24 5s779ms 151ms 470ms 240ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 02 07 1 335ms 335ms 10 1 151ms 151ms 11 4 757ms 189ms 14 2 349ms 174ms 15 8 2s254ms 281ms 16 8 1s930ms 241ms [ User: intelifix - Total duration: 5s779ms - Times executed: 24 ]
[ Application: [unknown] - Total duration: 5s779ms - Times executed: 24 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '843C992C092D,5872C98F6489,48D682306ED4,D831398EF034,D831399B0DB0,843C9935FB37,4896D9504FF2,C4EBFF8950F2,843C9935D5FF,3CF9F0A542E8,14CA56CFB06F,843C9932A52D,D89A0DA98595,C4EBFF897A86,5872C98D7553', '138;1', 'DEFAULT', 09, 0323, '','', '', 00);
Date: 2026-10-02 15:56:17 Duration: 470ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '4896D957584C,5872C98F74D9,3CF9F0A5F92E,3891484ACE3F,C4EBFF89CA30,689E29BD9591,4896D957581C,F4E84F8644D6,D831399AE6A4,D8313998AC62,3CF9F0A5FA54,843C99225E51,5872C98D5D17,D83139901F82,3CF9F0A5F9A0,3CF9F0AAD970,48D6823A80AC,3CF9F0A5F6D0,3CF9F0AE170E,843C9922570D', '138;1', 'DEFAULT', 09, 0323, '','', '', 00);
Date: 2026-10-02 15:52:55 Duration: 438ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '14CA56D4FB3D,4896D95248DC,843C99226187,D831398E86B0,4896D956752A,843C9932DBC3,48D682389BCC,843C992028A1,F00C5154443A,D8313992E78A,843C9921D39D,48D68230E45E,5872C98F9741,C4EBFF89AE6A,D831398ECED4,843C9922456D,D831391E6078,3CF9F0707F19,14CA56CCD98B', '138;1', 'DEFAULT', 09, 0323, '','', '', 00);
Date: 2026-10-02 16:13:18 Duration: 431ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 7m6s 7m6s 7m6s 1 7m6s select * from rs_fast_excel (?, ?) / 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 (/ 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 (/ 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 (/ 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 (/ 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 (/ 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 (/ 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 #1
Day Hour Count Duration Avg duration Oct 02 11 1 7m6s 7m6s [ User: intelifix - Total duration: 7m6s - Times executed: 1 ]
[ Application: [unknown] - Total duration: 7m6s - Times executed: 1 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030720, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx') / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-02 11:39:57 Duration: 7m6s Database: rio User: intelifix Remote: [local] Application: [unknown]
2 2m34s 8m59s 6m 3 18m2s analyze verbose;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 02 05 3 18m2s 6m [ User: intelifix - Total duration: 18m2s - Times executed: 3 ]
[ Application: psql - Total duration: 18m2s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-10-02 05:09:00 Duration: 8m59s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-02 05:15:29 Duration: 6m28s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-02 05:18:04 Duration: 2m34s Database: contagem User: intelifix Remote: [local] Application: psql
3 2s104ms 6m5s 1m53s 48 1h30m42s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 02 07 3 6m34s 2m11s 08 3 5m45s 1m55s 09 3 5m45s 1m55s 10 3 5m41s 1m53s 11 3 5m39s 1m53s 12 3 5m39s 1m53s 13 3 5m36s 1m52s 14 3 5m31s 1m50s 15 3 5m48s 1m56s 16 3 5m31s 1m50s 17 3 5m32s 1m50s 18 3 5m29s 1m49s 19 3 5m36s 1m52s 20 3 5m33s 1m51s 21 3 5m26s 1m48s 22 3 5m29s 1m49s [ User: intelifix - Total duration: 1h30m42s - Times executed: 48 ]
[ Application: psql - Total duration: 1h30m42s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-02 07:11:07 Duration: 6m5s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-02 15:10:31 Duration: 5m30s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-02 09:10:26 Duration: 5m24s Database: rio User: intelifix Remote: [local] Application: psql
4 245ms 3m39s 1m19s 48 1h3m18s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 02 07 3 4m29s 1m29s 08 3 4m 1m20s 09 3 4m1s 1m20s 10 3 3m58s 1m19s 11 3 4m1s 1m20s 12 3 3m48s 1m16s 13 3 3m55s 1m18s 14 3 3m59s 1m19s 15 3 3m55s 1m18s 16 3 3m56s 1m18s 17 3 3m50s 1m16s 18 3 3m51s 1m17s 19 3 3m56s 1m18s 20 3 3m54s 1m18s 21 3 3m52s 1m17s 22 3 3m47s 1m15s [ User: intelifix - Total duration: 1h3m18s - Times executed: 48 ]
[ Application: psql - Total duration: 1h3m18s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-02 07:16:00 Duration: 3m39s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-02 11:14:38 Duration: 3m30s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-02 09:14:43 Duration: 3m29s Database: brasilia User: intelifix Remote: [local] Application: psql
5 2s686ms 2m 1m1s 2 2m2s select * from rs_fast_excel (?, ?) / 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 (/ 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 (/ 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 #5
Day Hour Count Duration Avg duration Oct 02 10 1 2s686ms 2s686ms 15 1 2m 2m [ User: intelifix - Total duration: 2m2s - Times executed: 2 ]
[ Application: [unknown] - Total duration: 2m2s - Times executed: 2 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030725, 0508 )', '/var/www/html/tmp/nf_carga_lotes_0508.xlsx') / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-02 15:20:04 Duration: 2m Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_seriais_expedidos(7,DATE(''2026-10-01''),DATE(''2026-10-01'')) ;', '/var/www/html/tmp/temp_54.xlsx') / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-02 10:00:02 Duration: 2s686ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
6 4s63ms 1m2s 33s9ms 4 2m12s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 02 20 2 1m6s 33s159ms 23 2 1m5s 32s859ms [ User: intelifix - Total duration: 2m12s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m12s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-02 20:08:37 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-02 23:16:33 Duration: 1m1s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-02 23:33:39 Duration: 4s160ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 330ms 53s124ms 26s521ms 4 1m46s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 02 20 2 53s457ms 26s728ms 23 2 52s626ms 26s313ms [ User: intelifix - Total duration: 1m46s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m46s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-02 20:05:43 Duration: 53s124ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-02 23:13:40 Duration: 52s296ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-02 20:10:00 Duration: 332ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 151ms 5m52s 22s216ms 179 1h6m16s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 02 07 22 11m34s 31s589ms 08 19 5m53s 18s582ms 09 31 6m19s 12s231ms 10 25 14m35s 35s27ms 11 27 16m34s 36s822ms 12 9 6s103ms 678ms 13 6 4s91ms 681ms 14 24 7m20s 18s352ms 15 12 3m43s 18s664ms 16 1 417ms 417ms 17 2 3s 1s500ms 18 1 1s523ms 1s523ms [ User: intelifix - Total duration: 1h6m16s - Times executed: 179 ]
[ Application: [unknown] - Total duration: 1h6m16s - Times executed: 179 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030683, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-02 07:41:17 Duration: 5m52s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030704, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-02 09:50:32 Duration: 5m36s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030690, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-02 08:50:51 Duration: 5m34s Database: rio User: intelifix Remote: [local] Application: [unknown]
9 3s194ms 39s964ms 17s842ms 6 1m47s copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 02 20 3 53s637ms 17s879ms 23 3 53s415ms 17s805ms [ User: intelifix - Total duration: 1m47s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m47s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-02 20:06:25 Duration: 39s964ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-02 23:14:21 Duration: 39s722ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-02 23:33:15 Duration: 10s489ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 10s837ms 13s304ms 11s600ms 9 1m44s create table temp0000293266 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 02 14 9 1m44s 11s600ms [ User: intelifix - Total duration: 1m44s - Times executed: 9 ]
[ Application: [unknown] - Total duration: 1m44s - Times executed: 9 ]
-
CREATE TABLE temp0000293266 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-02 14:34:44 Duration: 13s304ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293266 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-02 14:33:18 Duration: 12s67ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293266 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-02 14:09:48 Duration: 11s925ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 10s683ms 22s518ms 11s514ms 45 8m38s create table temp0000293178 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 02 07 6 1m17s 12s948ms 08 6 1m8s 11s338ms 09 14 2m39s 11s369ms 10 14 2m35s 11s132ms 11 5 57s405ms 11s481ms [ User: intelifix - Total duration: 8m38s - Times executed: 45 ]
[ Application: [unknown] - Total duration: 8m38s - Times executed: 45 ]
-
CREATE TABLE temp0000293178 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-02 07:34:41 Duration: 22s518ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293178 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-02 09:12:52 Duration: 12s589ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293178 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-02 11:16:36 Duration: 12s356ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 11s8ms 12s735ms 11s258ms 17 3m11s create table temp0000293222 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 02 10 6 1m8s 11s443ms 11 11 2m2s 11s158ms [ User: intelifix - Total duration: 3m11s - Times executed: 17 ]
[ Application: [unknown] - Total duration: 3m11s - Times executed: 17 ]
-
CREATE TABLE temp0000293222 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-02 10:58:24 Duration: 12s735ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293222 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-02 11:04:42 Duration: 11s539ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293222 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-02 10:58:49 Duration: 11s337ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 10s849ms 11s694ms 11s148ms 22 4m5s create table temp0000293166 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 02 07 7 1m17s 11s54ms 09 15 2m47s 11s192ms [ User: intelifix - Total duration: 4m5s - Times executed: 22 ]
[ Application: [unknown] - Total duration: 4m5s - Times executed: 22 ]
-
CREATE TABLE temp0000293166 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-02 09:17:05 Duration: 11s694ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293166 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-02 09:05:39 Duration: 11s542ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293166 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-02 09:21:36 Duration: 11s340ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 10s775ms 11s700ms 11s84ms 10 1m50s create table temp0000293278 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 02 14 4 44s603ms 11s150ms 15 6 1m6s 11s39ms [ User: intelifix - Total duration: 1m50s - Times executed: 10 ]
[ Application: [unknown] - Total duration: 1m50s - Times executed: 10 ]
-
CREATE TABLE temp0000293278 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-02 15:39:25 Duration: 11s700ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293278 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-02 14:36:03 Duration: 11s479ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293278 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-02 14:35:42 Duration: 11s212ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 1s683ms 11s125ms 4s696ms 66 5m9s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 02 07 3 7s492ms 2s497ms 08 3 8s64ms 2s688ms 09 4 30s80ms 7s520ms 10 4 14s997ms 3s749ms 11 14 1m19s 5s651ms 12 2 4s340ms 2s170ms 13 10 44s726ms 4s472ms 14 7 39s427ms 5s632ms 15 13 1m9s 5s315ms 16 3 6s480ms 2s160ms 17 3 6s116ms 2s38ms [ User: intelifix - Total duration: 5m9s - Times executed: 66 ]
[ Application: [unknown] - Total duration: 5m9s - Times executed: 66 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-02', 0320, '', '', 0, 6, '2026-10-01');
Date: 2026-10-02 09:07:02 Duration: 11s125ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-01', 099, '', '', 0, 6, '2026-10-01');
Date: 2026-10-02 11:12:26 Duration: 9s537ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-02', 0173, '', '', 0, 6, '2026-10-01');
Date: 2026-10-02 15:13:39 Duration: 8s721ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 165ms 39s299ms 3s34ms 27 1m21s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 02 07 3 1s24ms 341ms 08 2 364ms 182ms 09 6 1s160ms 193ms 10 5 41s623ms 8s324ms 11 5 24s684ms 4s936ms 14 4 5s991ms 1s497ms 15 2 7s79ms 3s539ms [ User: intelifix - Total duration: 1m21s - Times executed: 27 ]
[ Application: psql - Total duration: 1m21s - Times executed: 27 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030709);
Date: 2026-10-02 10:32:40 Duration: 39s299ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030716);
Date: 2026-10-02 11:11:05 Duration: 13s104ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030724);
Date: 2026-10-02 14:35:57 Duration: 5s393ms Database: rio User: intelifix Remote: [local] Application: psql
17 220ms 15s523ms 3s8ms 30 1m30s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 02 07 3 24s895ms 8s298ms 08 3 6s18ms 2s6ms 09 9 18s58ms 2s6ms 10 5 18s692ms 3s738ms 11 5 11s864ms 2s372ms 14 3 8s740ms 2s913ms 15 2 1s981ms 990ms [ User: intelifix - Total duration: 1m30s - Times executed: 30 ]
[ Application: psql - Total duration: 1m30s - Times executed: 30 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030683);
Date: 2026-10-02 07:35:04 Duration: 15s523ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030685);
Date: 2026-10-02 07:44:34 Duration: 5s928ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030704);
Date: 2026-10-02 09:44:42 Duration: 5s363ms Database: rio User: intelifix Remote: [local] Application: psql
18 586ms 14s46ms 2s961ms 34 1m40s 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 #18
Day Hour Count Duration Avg duration Oct 02 08 3 16s712ms 5s570ms 09 1 10s272ms 10s272ms 10 1 8s613ms 8s613ms 11 2 14s541ms 7s270ms 12 2 1s457ms 728ms 13 2 1s607ms 803ms 14 3 13s308ms 4s436ms 15 2 20s138ms 10s69ms 16 2 1s490ms 745ms 17 3 2s339ms 779ms 18 2 1s644ms 822ms 19 3 2s79ms 693ms 20 3 2s693ms 897ms 21 3 2s366ms 788ms 22 2 1s437ms 718ms [ User: intelifix - Total duration: 1m40s - Times executed: 34 ]
[ Application: psql - Total duration: 1m40s - Times executed: 34 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-02 15:00:15 Duration: 14s46ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-02 08:00:14 Duration: 13s301ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-02 09:20:11 Duration: 10s272ms Database: rio User: intelifix Remote: [local] Application: psql
19 190ms 2m26s 2s139ms 276 9m50s call rs_giga_triagem (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 02 00 12 22s487ms 1s873ms 01 12 19s231ms 1s602ms 02 12 18s808ms 1s567ms 03 12 18s999ms 1s583ms 04 12 18s488ms 1s540ms 05 12 18s888ms 1s574ms 06 12 19s61ms 1s588ms 07 12 18s963ms 1s580ms 08 12 19s792ms 1s649ms 09 12 21s949ms 1s829ms 10 12 22s538ms 1s878ms 11 12 19s747ms 1s645ms 12 12 18s553ms 1s546ms 13 12 18s352ms 1s529ms 14 12 2m42s 13s555ms 15 12 18s583ms 1s548ms 16 12 18s733ms 1s561ms 17 12 18s757ms 1s563ms 18 12 18s885ms 1s573ms 19 12 18s800ms 1s566ms 20 12 21s12ms 1s751ms 21 12 18s512ms 1s542ms 22 12 18s718ms 1s559ms [ User: intelifix - Total duration: 9m50s - Times executed: 276 ]
[ Application: psql - Total duration: 9m50s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-02 14:17:30 Duration: 2m26s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-02 00:05:18 Duration: 5s502ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-02 09:15:10 Duration: 5s317ms Database: rio User: intelifix Remote: [local] Application: psql
20 1s647ms 9s789ms 2s57ms 26 53s486ms create table temp0000293162 as select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 02 06 26 53s486ms 2s57ms [ User: intelifix - Total duration: 53s486ms - Times executed: 26 ]
[ Application: [unknown] - Total duration: 53s486ms - Times executed: 26 ]
-
CREATE TABLE temp0000293162 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "6", "cliente" : "0", "nf" : "", "data-de" : "27-09-2026", "data-ate" : "02-10-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-10-02 06:53:21 Duration: 9s789ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293162 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "6", "cliente" : "5", "nf" : "", "data-de" : "27-09-2026", "data-ate" : "02-10-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-10-02 06:55:06 Duration: 2s65ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293162 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "6", "cliente" : "5", "nf" : "", "data-de" : "27-09-2026", "data-ate" : "02-10-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-10-02 06:55:19 Duration: 1s898ms 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 Oct 02 12 1 0ms 0ms 14 1 0ms 0ms 16 1 0ms 0ms 18 2 0ms 0ms [ User: intelifix - Total duration: 4s511ms - Times executed: 5 ]
[ Application: psql - Total duration: 2s968ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 1s542ms - Times executed: 4 ]
-
;
Date: Duration: 0ms Database: postgres User: rio Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 17,131 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 63 FATAL entries
- 5106 ERROR entries
- 0 WARNING entries
- 10 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 4,975 Max number of times the same event was reported
- 5,179 Total events found
Rank Times reported Error 1 4,975 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Oct 02 00 120 01 118 02 120 03 108 04 120 05 118 06 121 07 292 08 407 09 507 10 411 11 366 12 187 13 237 14 418 15 239 16 200 17 180 18 130 19 118 20 120 21 118 22 120 23 100 - ERROR: prepared statement "_PLAN0000000029B63FE0" does not exist
- ERROR: prepared statement "_PLAN0000000029CDA610" does not exist
- ERROR: prepared statement "_PLAN0000000029B64470" does not exist
Statement: DEALLOCATE "_PLAN0000000029B63FE0"
Date: 2026-10-02 00:00:10 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029CDA610"
Date: 2026-10-02 00:00:10 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029B64470"
Date: 2026-10-02 00:01:11 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 113 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #2
Day Hour Count Oct 02 07 2 08 1 10 110 - ERROR: syntax error at or near "]" at character 35
- ERROR: syntax error at or near "]" at character 35
- ERROR: syntax error at or near "241668697787" at character 41
Statement: select * from rs_caixa_qr(3752199 ])
Date: 2026-10-02 07:14:13 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(3752199 ])
Date: 2026-10-02 07:14:14 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''241668697787');
Date: 2026-10-02 08:28:56 Database: rio Application: [unknown] User: intelifix Remote: [local]
3 50 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count Oct 02 05 1 06 1 11 4 12 42 18 2 - FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-10-02 05:15:30 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-02 06:42:45 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-02 11:24:40 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
4 11 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Oct 02 09 3 10 2 14 4 16 2 - ERROR: column "seig607099132cd8ae5097f9" does not exist at character 27
- ERROR: column "seig607099132cd8ae5097f9" does not exist at character 27
- ERROR: column "seig607099132cd8ae5097f9" does not exist at character 27
Statement: select * from rs_caixa_qr(SEIG607099132CD8AE5097F9)
Date: 2026-10-02 09:58:53 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(SEIG607099132CD8AE5097F9)
Date: 2026-10-02 09:58:53 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(SEIG607099132CD8AE5097F9)
Date: 2026-10-02 09:59:09 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
5 10 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #5
Day Hour Count Oct 02 03 10 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-10-02 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-10-02 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-02 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
6 7 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #6
Day Hour Count Oct 02 10 1 11 3 14 3 - LOG: process 2511696 still waiting for ShareLock on transaction 7145994 after 1000.078 ms
- LOG: process 2571114 still waiting for ShareLock on transaction 7152436 after 1000.113 ms
- LOG: process 2571114 still waiting for ShareLock on transaction 7152436 after 9455.350 ms
Detail: Process holding the lock: 2522607. Wait queue: 2511696.
Context: while updating tuple (1,20) in relation "usuarios" SQL statement "UPDATE USUARIOS SET EQ_CODIGO = NULL, USU_CHECK_IN = NULL WHERE USU_ID = nUser" PL/pgSQL function rs_tecnico_check_out(integer) line 28 at SQL statement SQL statement "SELECT RS_TECNICO_CHECK_OUT( nTecnico )" PL/pgSQL function rs_baixa(integer,integer,integer,integer,character varying,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1129 at PERFORM PL/pgSQL function rs_fluxo_encerra(integer,integer,boolean) line 169 at assignment PL/pgSQL function rs_cria_fluxo_fechado(integer,character varying,integer,boolean) line 94 at assignment PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1130 at assignment
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(60032,413,'71731085850047306862,216816828908$71706985850035903104,216752322433$7151678787H010905275,216563230612$7152038787H010928643,216607482439$71427485850006021528,216348025669$71502085850010823395,216412277798$7152458787H010955656,216631340615$71731785850047709199,216818062631$71731785850047704264,216817569192$71503785850011538753,216512819091$71719985850041810842,216799577392$71505585850012101182,216519196381$71817985850055300133,216864898504$71803785850050505656,216834085676$71425585850004940434,216333394567','',062,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":""}]','$$$$$$$$$$$$$$','',00);Date: 2026-10-02 10:35:28 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 2547880. Wait queue: 2571114.
Context: while deleting tuple (73279,63) 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 952 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( 030720, 0502 )' , '/var/www/html/tmp/nf_carga_lotes_0502.xlsx' )Date: 2026-10-02 11:32:52 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 2547880. Wait queue: 2571114.
Context: while deleting tuple (73279,63) 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 952 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( 030720, 0502 )' , '/var/www/html/tmp/nf_carga_lotes_0502.xlsx' )Date: 2026-10-02 11:33:00 Database: rio Application: [unknown] User: intelifix Remote: [local]
7 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Oct 02 05 4 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-02 05:32:05 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-02 05:32:05 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-02 05:32:05 Database: contagem Application: psql User: intelifix Remote: [local]
8 3 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #8
Day Hour Count Oct 02 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-10-02 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-02 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-02 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
9 2 ERROR: function rs_caixa_qr(...) does not exist
Times Reported Most Frequent Error / Event #9
Day Hour Count Oct 02 10 2 - ERROR: function rs_caixa_qr(numeric) does not exist at character 15
- ERROR: function rs_caixa_qr(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_caixa_qr(71426085850005321429)Date: 2026-10-02 10:24:12 Database: contagem 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_caixa_qr(71426085850005321429)Date: 2026-10-02 10:24:12 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
10 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #10
Day Hour Count Oct 02 03 1 - LOG: database system was shut down at 2026-10-02 03:05:01 -03
Date: 2026-10-02 03:05:01
11 1 LOG: skipping analyze of "..." --- lock not available
Times Reported Most Frequent Error / Event #11
Day Hour Count Oct 02 14 1 - LOG: skipping analyze of "temp0000293266" --- lock not available
Date: 2026-10-02 14:35:38
12 1 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #12
Day Hour Count Oct 02 10 1 - LOG: process 2549616 still waiting for AccessExclusiveLock on relation 5696052 of database 358220 after 1000.117 ms
Detail: Process holding the lock: 2564297. Wait queue: 2549616.
Statement: DROP TABLE IF EXISTS temp0000293222;Date: 2026-10-02 10:58:38 Database: rio Application: [unknown] User: intelifix Remote: [local]
13 1 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #13
Day Hour Count Oct 02 10 1 - ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000293222"
Date: 2026-10-02 10:58:38