pgBadger-
Global information
- Generated on Fri Jun 26 23:50:11 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 54,332 log entries in 10s
- Log start from 2026-06-25 00:00:11 to 2026-06-25 23:59:37
-
Overview
Global Stats
- 422 Number of unique normalized queries
- 8,179 Number of queries
- 9h58m37s Total query duration
- 2026-06-25 00:00:22 First query
- 2026-06-25 23:53:59 Last query
- 5 queries/s at 2026-06-25 14:20:05 Query peak
- 9h58m37s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 9h58m37s Execute total duration
- 5,092 Number of events
- 23 Number of unique normalized events
- 4,822 Max number of times the same event was reported
- 0 Number of cancellation
- 581 Total number of automatic vacuums
- 1,233 Total number of automatic analyzes
- 41 Number temporary file
- 231.88 MiB Max size of temporary file
- 108.70 MiB Average size of temporary file
- 398 Total number of sessions
- 13 sessions at 2026-06-25 23:39:12 Session peak
- 14d5h54m48s Total duration of sessions
- 51m32s Average duration of sessions
- 20 Average queries per session
- 1m30s Average queries duration per session
- 50m2s Average idle time per session
- 409 Total number of connections
- 11 connections/s at 2026-06-25 23:39:12 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-06-25 14:20:05 Date
SELECT Traffic
Key values
- 4 queries/s Query Peak
- 2026-06-25 14:45:06 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 3 queries/s Query Peak
- 2026-06-25 20:08:38 Date
Queries duration
Key values
- 9h58m37s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 25 00 35 0ms 24s421ms 4s232ms 4s899ms 19s921ms 1m10s 01 12 0ms 3s218ms 2s208ms 3s775ms 4s666ms 4s993ms 02 14 0ms 3s292ms 1s752ms 3s8ms 3s634ms 5s651ms 03 14 0ms 4s356ms 2s292ms 4s606ms 5s238ms 6s529ms 04 25 0ms 3s847ms 1s432ms 4s187ms 5s565ms 6s815ms 05 37 0ms 8m49s 29s611ms 6s177ms 2m41s 8m49s 06 17 0ms 21s636ms 4s279ms 2s936ms 3s528ms 29s527ms 07 126 0ms 7m42s 15s746ms 50s29ms 4m46s 8m2s 08 504 0ms 5m56s 5s967ms 3m59s 4m56s 7m20s 09 835 150ms 8m34s 3s558ms 1m59s 5m19s 8m58s 10 878 150ms 8m37s 3s792ms 2m 4m45s 8m41s 11 727 150ms 8m34s 4s155ms 1m38s 5m44s 8m35s 12 327 0ms 8m3s 6s571ms 1m29s 4m6s 9m1s 13 551 0ms 7m7s 3s437ms 53s286ms 4m13s 7m54s 14 1,087 150ms 7m17s 1s503ms 33s519ms 1m8s 8m2s 15 1,132 150ms 7m56s 3s958ms 5m8s 6m30s 8m53s 16 999 150ms 7m23s 2s334ms 1m20s 2m41s 7m36s 17 401 0ms 7m40s 3s867ms 57s461ms 1m43s 8m12s 18 17 0ms 6m17s 38s590ms 3s314ms 16s709ms 6m46s 19 17 0ms 5m47s 36s43ms 3s577ms 42s919ms 5m47s 20 108 0ms 6m8s 11s108ms 1m4s 1m28s 6m54s 21 27 0ms 6m2s 23s996ms 4s315ms 7s570ms 6m49s 22 26 0ms 5m54s 25s217ms 5s492ms 44s584ms 5m54s 23 263 0ms 1m29s 8s957ms 1m9s 1m27s 1m44s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 25 00 17 0 2s2ms 0ms 309ms 1s665ms 01 0 0 0ms 0ms 0ms 0ms 02 2 0 459ms 0ms 0ms 0ms 03 1 0 170ms 0ms 0ms 0ms 04 12 0 292ms 0ms 218ms 812ms 05 21 0 283ms 239ms 351ms 809ms 06 7 0 3s903ms 0ms 0ms 858ms 07 86 0 18s83ms 2s949ms 50s29ms 4m18s 08 374 0 6s372ms 28s531ms 3m55s 4m47s 09 586 0 3s586ms 31s371ms 1m31s 5m26s 10 673 0 3s842ms 59s258ms 1m46s 5m2s 11 530 0 4s581ms 26s469ms 1m25s 5m38s 12 200 0 8s988ms 7s481ms 1m18s 4m5s 13 392 0 3s698ms 8s990ms 39s270ms 4m45s 14 908 0 1s447ms 15s393ms 26s836ms 3m57s 15 905 0 3s953ms 1m8s 4m53s 6m10s 16 786 0 2s450ms 41s204ms 1m10s 4m10s 17 274 0 4s799ms 21s696ms 34s877ms 3m59s 18 8 0 1m18s 0ms 0ms 3m27s 19 6 0 1m38s 0ms 0ms 3m18s 20 12 86 11s952ms 10s868ms 1m 3m34s 21 11 0 55s818ms 0ms 0ms 3m22s 22 11 0 56s421ms 0ms 942ms 3m22s 23 15 247 8s990ms 1m1s 1m9s 1m29s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 25 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jun 25 00 0 3 3.00 0.00% 01 0 0 0.00 0.00% 02 0 1 1.00 0.00% 03 0 1 1.00 0.00% 04 0 2 2.00 0.00% 05 0 2 2.00 0.00% 06 0 3 3.00 0.00% 07 0 8 8.00 0.00% 08 0 12 12.00 0.00% 09 0 15 15.00 0.00% 10 0 20 20.00 0.00% 11 0 13 13.00 0.00% 12 0 8 8.00 0.00% 13 0 12 12.00 0.00% 14 0 14 14.00 0.00% 15 0 18 18.00 0.00% 16 0 14 14.00 0.00% 17 0 9 9.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 1 1.00 0.00% 22 0 3 3.00 0.00% 23 0 1 1.00 0.00% Day Hour Count Average / Second Jun 25 00 17 0.00/s 01 9 0.00/s 02 12 0.00/s 03 17 0.00/s 04 9 0.00/s 05 8 0.00/s 06 14 0.00/s 07 16 0.00/s 08 22 0.01/s 09 24 0.01/s 10 28 0.01/s 11 22 0.01/s 12 11 0.00/s 13 21 0.01/s 14 25 0.01/s 15 37 0.01/s 16 25 0.01/s 17 19 0.01/s 18 12 0.00/s 19 10 0.00/s 20 12 0.00/s 21 10 0.00/s 22 8 0.00/s 23 21 0.01/s Day Hour Count Average Duration Average idle time Jun 25 00 4 1h 59m23s 01 16 1h1m7s 1h1m6s 02 9 1h 59m57s 03 22 30m17s 30m16s 04 7 1h3m 1h2m55s 05 9 1h40s 58m38s 06 8 56m26s 56m17s 07 15 55m33s 53m21s 08 18 50m38s 47m51s 09 21 51m14s 48m53s 10 27 49m27s 47m24s 11 22 58m8s 55m50s 12 21 55m29s 53m47s 13 11 55m9s 52m16s 14 23 53m16s 52m5s 15 37 37m10s 35m9s 16 26 49m41s 48m11s 17 20 51m27s 50m10s 18 18 57m39s 57m2s 19 14 1h29m36s 1h28m52s 20 13 42m59s 41m27s 21 8 1h23s 59m2s 22 10 57m48s 56m42s 23 19 32m5s 30m1s -
Connections
Established Connections
Key values
- 11 connections Connection Peak
- 2026-06-25 23:39:12 Date
Connections per database
Key values
- rio Main Database
- 409 connections Total
Connections per user
Key values
- intelifix Main User
- 409 connections Total
-
Sessions
Simultaneous sessions
Key values
- 13 sessions Session Peak
- 2026-06-25 23:39:12 Date
Histogram of session times
Key values
- 299 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 398 sessions Total
Sessions per user
Key values
- intelifix Main User
- 398 sessions Total
Sessions per host
Key values
- [local] Main Host
- 398 sessions Total
Sessions per application
Key values
- [unknown] Main Application
- 398 sessions Total
Application Count Total Duration Average Duration [unknown] 362 13d3h10m45s 52m14s pgAdmin 4 - CONN:3842073 2 3h42m40s 1h51m20s pgAdmin 4 - CONN:6796652 2 4s710ms 2s355ms pgAdmin 4 - CONN:8054972 3 9s38ms 3s12ms pgAdmin 4 - CONN:963289 1 38s234ms 38s234ms pgAdmin 4 - DB:brasilia 3 3h43m4s 1h14m21s pgAdmin 4 - DB:contagem 1 9s921ms 9s921ms pgAdmin 4 - DB:postgres 2 3h43m45s 1h51m52s pgAdmin 4 - DB:rio 1 14s125ms 14s125ms pg_dump 6 50m34s 8m25s postgres_fdw 1 31m26s 31m26s psql 14 14h11m15s 1h48s -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 20,845 buffers Checkpoint Peak
- 2026-06-25 00:19:40 Date
- 270.023 seconds Highest write time
- 0.246 seconds Sync time
Checkpoints Wal files
Key values
- 12 files Wal files usage Peak
- 2026-06-25 15:34:36 Date
Checkpoints distance
Key values
- 363.54 Mo Distance Peak
- 2026-06-25 10:19:35 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jun 25 00 26,709 774.603s 0.146s 774.825s 01 2,121 213.071s 0.054s 213.168s 02 1,156 116.129s 0.039s 116.197s 03 2,314 232.227s 0.061s 232.337s 04 2,836 284.71s 0.076s 284.834s 05 11,761 1,136.57s 0.134s 1,136.776s 06 6,236 433.12s 0.012s 433.154s 07 30,854 1,916.771s 0.22s 1,917.118s 08 75,543 3,238.81s 0.618s 3,239.653s 09 71,020 3,238.273s 1.162s 3,239.757s 10 88,729 3,238.105s 1.262s 3,239.687s 11 90,568 3,238.472s 0.849s 3,239.605s 12 55,124 2,755.45s 0.468s 2,756.085s 13 30,879 2,690.008s 0.623s 2,690.806s 14 56,840 3,174.527s 0.886s 3,175.652s 15 106,566 3,238.269s 1.233s 3,239.812s 16 75,672 3,238.588s 0.814s 3,239.686s 17 41,355 2,275.008s 0.458s 2,275.637s 18 1,178 118.292s 0.016s 118.345s 19 24 2.438s 0.004s 2.45s 20 634 66.848s 0.04s 66.926s 21 2,475 248.997s 0.029s 249.095s 22 2,359 237.05s 0.035s 237.146s 23 677 231.464s 0.031s 231.546s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jun 25 00 0 0 7 783 0.030s 0.009s 01 0 0 1 417 0.007s 0.006s 02 0 0 1 274 0.008s 0.004s 03 0 0 0 461 0.010s 0.006s 04 0 0 1 579 0.011s 0.006s 05 0 0 5 1,075 0.009s 0.009s 06 0 0 1 65 0.003s 0.003s 07 0 0 21 1,780 0.015s 0.011s 08 0 0 50 5,627 0.018s 0.012s 09 0 0 67 8,113 0.033s 0.012s 10 0 0 58 8,221 0.032s 0.012s 11 0 0 65 7,232 0.036s 0.012s 12 0 0 33 4,487 0.016s 0.012s 13 0 0 25 5,364 0.031s 0.012s 14 0 0 36 6,967 0.019s 0.012s 15 0 0 76 8,568 0.028s 0.012s 16 0 0 47 7,469 0.013s 0.012s 17 0 0 31 5,384 0.026s 0.011s 18 0 0 1 184 0.003s 0.007s 19 0 0 0 6 0.002s 0.001s 20 0 0 1 107 0.010s 0.003s 21 0 0 1 367 0.003s 0.007s 22 0 0 0 432 0.003s 0.008s 23 0 0 4 183 0.004s 0.006s Day Hour Count Avg time (sec) Jun 25 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Jun 25 00 13,934.00 kB 66,894.44 kB 01 1,835.17 kB 33,968.67 kB 02 1,547.00 kB 20,607.75 kB 03 1,805.71 kB 4,622.57 kB 04 2,440.17 kB 3,323.67 kB 05 8,560.22 kB 17,510.89 kB 06 4,718.33 kB 13,493.67 kB 07 31,163.55 kB 70,426.00 kB 08 69,201.42 kB 105,385.25 kB 09 91,128.25 kB 140,710.17 kB 10 79,324.08 kB 143,054.33 kB 11 87,949.58 kB 153,365.42 kB 12 45,266.17 kB 97,647.33 kB 13 34,061.50 kB 68,962.92 kB 14 49,498.00 kB 85,068.17 kB 15 103,294.08 kB 132,230.67 kB 16 64,059.08 kB 116,915.17 kB 17 47,448.91 kB 91,697.73 kB 18 951.83 kB 45,755.50 kB 19 172.00 kB 31,219.00 kB 20 6,721.67 kB 27,058.33 kB 21 1,641.86 kB 16,907.14 kB 22 1,549.38 kB 8,588.75 kB 23 8,511.83 kB 23,388.00 kB -
Temporary Files
Size of temporary files
Key values
- 463.77 MiB Temp Files size Peak
- 2026-06-25 05:31:55 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-06-25 05:32:00 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jun 25 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 10 1.05 GiB 107.83 MiB 06 0 0 0 07 0 0 0 08 2 208.00 MiB 104.00 MiB 09 2 312.03 MiB 156.01 MiB 10 5 520.00 MiB 104.00 MiB 11 3 312.00 MiB 104.00 MiB 12 3 312.00 MiB 104.00 MiB 13 1 104.00 MiB 104.00 MiB 14 0 0 0 15 6 624.01 MiB 104.00 MiB 16 7 778.40 MiB 111.20 MiB 17 2 208.00 MiB 104.00 MiB 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 29 2.95 GiB 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( 026184, 0433 )', '/var/www/html/tmp/nf_carga_lotes_0433.xlsx');
Date: 2026-06-25 15:27:36 Duration: 5m34s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026157, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-25 11:40:54 Duration: 5m31s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026183, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-25 15:14:46 Duration: 5m23s Database: rio User: intelifix Remote: [local] Application: [unknown]
2 8 900.84 MiB 69.16 MiB 231.88 MiB 112.61 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-06-25 05:32:02 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-06-25 05:31:55 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
3 2 177.44 MiB 88.72 MiB 88.72 MiB 88.72 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-06-25 05:30:39 Duration: 37s757ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-06-25 05:30:36 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
4 2 362.42 MiB 154.39 MiB 208.03 MiB 181.21 MiB select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);-
SELECT RS_SETGLOBAL ('USUARIO', 503); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026123);
Date: 2026-06-25 09:06:12 Duration: 1m Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 503); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026195);
Date: 2026-06-25 16:11:17 Duration: 32s622ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026154);
Date: 2026-06-25 11:27:44 Duration: 20s54ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 231.88 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-06-25 05:31:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 231.88 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-06-25 05:31:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 208.03 MiB SELECT RS_SETGLOBAL ('USUARIO', 503); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026123);[ Date: 2026-06-25 09:06:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 154.39 MiB SELECT RS_SETGLOBAL ('USUARIO', 503); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026195);[ Date: 2026-06-25 16:11:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_exclui_seriais(''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_83.xlsx');[ Date: 2026-06-25 15:14:19 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
6 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,433,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-25 15:20:49 - 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-06-25 16:35:08 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
8 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,503,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-25 16:09:45 - 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-06-25 17:02:22 - 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-06-25 11:26:28 - 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-06-25 08:21:18 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
12 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-06-25 16:56:32 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 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-06-25 08:31:06 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 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-06-25 17:07:16 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
15 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,503,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-25 09:03:24 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
16 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-06-25 16:46:41 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
17 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,404,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-25 10:39:30 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
18 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,404,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-25 15:46:39 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_exclui_seriais(''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_83.xlsx');[ Date: 2026-06-25 10:20:00 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,449,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-25 10:28:05 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 34.95 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_06
Database rio - 2026-06-25 11:21:19 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 34.95 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_06
Database rio - 2026-06-25 11:21:19 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (140) Main table analyzed (database rio)
- 1,233 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 140 rio.pg_catalog.pg_class 78 contagem.public.temp0000226464 74 rio.pg_catalog.pg_type 65 rio.public.usuarios 50 rio.pg_catalog.pg_index 45 rio.public.temp0000283596 41 brasilia.pg_catalog.pg_attribute 38 rio.pg_catalog.pg_depend 38 rio.public.temp0000283570 36 rio.public.temp0000283420 36 rio.public.temp0000283548 35 contagem.pg_catalog.pg_attribute 32 rio.public.temp0000283540 31 rio.public.temp0000283608 27 rio.public.temp0000283558 26 contagem.public.usuarios 22 contagem.pg_catalog.pg_class 20 contagem.pg_catalog.pg_type 18 brasilia.pg_catalog.pg_class 17 rio.public.temp0000283546 17 brasilia.public.temp0000234650 17 brasilia.pg_catalog.pg_type 16 rio.public.temp0000283306 13 rio.public.temp0000283600 13 rio.public.temp0000283290 13 brasilia.public.temp0000234586 13 contagem.pg_catalog.pg_index 12 contagem.public.temp0000226500 11 brasilia.pg_catalog.pg_index 10 rio.public.temp0000283536 10 rio.public.temp0000283534 10 rio.public.temp0000283390 9 contagem.pg_catalog.pg_depend 9 rio.public.temp0000283178 9 rio.public.temp0000283204 9 rio.public.temp0000283538 9 rio.public.temp0000283552 8 postgres.pg_catalog.pg_shdepend 8 rio.public.temp0000283628 8 rio.public.temp0000283638 8 brasilia.public.usuarios 8 rio.public.temp0000281789 7 brasilia.pg_catalog.pg_depend 6 contagem.public.nf_entrada 6 rio.public.temp0000283562 6 rio.public.temp0000283560 5 brasilia.public.temp0000234664 5 rio.public.temp0000283618 5 contagem.public.temp0000226494 5 rio.public.temp0000283102 4 rio.public.temp0000283532 4 brasilia.auditor.auditor_2026_06 4 rio.pg_catalog.pg_shdepend 3 contagem.pg_catalog.pg_shdepend 3 rio.public.temp0000283626 3 rio.public.tmp_drill_0175 3 rio.public.temp0000283604 3 rio.public.temp0000283620 3 rio.public.temp0000283556 3 rio.public.temp0000283606 3 rio.public.tmp_drill_0302 3 rio.public.temp0000283624 2 brasilia.public.temp0000234648 2 brasilia.public.nf_entrada 2 brasilia.public.temp0000234654 2 brasilia.pg_catalog.pg_shdepend 2 brasilia.public.temp0000234614 2 brasilia.public.temp0000234698 2 rio.public.temp0000283602 2 rio.public.temp0000283544 2 contagem.public.temp0000226498 1 rio.public.temp0000283636 1 contagem.public.temp0000226470 1 rio.public.temp0000283550 1 rio.public.temp0000283598 1 brasilia.public.temp0000234596 1 brasilia.public.temp0000234678 1 template1.pg_catalog.pg_shdepend 1 brasilia.public.temp0000234612 1 brasilia.public.temp0000234668 1 rio.public.temp0000283576 1 brasilia.public.temp0000234670 1 rio.public.temp0000283588 1 brasilia.public.temp0000234594 1 rio.public.temp0000283642 1 brasilia.public.temp0000234584 1 brasilia.public.temp0000234656 1 brasilia.public.temp0000234610 1 brasilia.public.temp0000234630 1 rio.public.temp0000283566 1 brasilia.public.temp0000234644 1 brasilia.public.temp0000234686 1 Total 1,233 Vacuums per table
Key values
- pg_catalog.pg_attribute (66) Main table vacuumed on database rio
- 581 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 66 55 0 0 0 0 0 31,119 7,946 12,190,310 467 11,689 rio.pg_catalog.pg_class 45 37 0 0 0 0 0 7,058 2,032 3,030,204 96 336 rio.pg_catalog.pg_type 36 30 0 0 0 0 0 2,883 775 1,075,025 69 274 rio.public.temp0000283548 35 0 0 0 0 0 0 42,083 145 2,505,283 0 0 rio.public.temp0000283608 27 0 0 0 0 0 0 32,148 101 1,912,651 0 0 rio.public.temp0000283558 25 0 0 0 0 0 0 20,977 1,692 3,299,327 0 0 rio.public.temp0000283570 24 0 0 0 0 0 0 5,874 242 557,093 0 0 contagem.public.usuarios 23 0 0 0 0 0 0 121 98 53,114 1 1 rio.public.temp0000283596 22 0 0 0 0 0 0 6,791 125 420,435 0 0 rio.pg_catalog.pg_index 19 19 0 0 0 0 0 1,447 395 335,656 74 169 rio.pg_catalog.pg_depend 16 16 0 0 0 0 0 5,333 1,698 2,823,687 106 1,226 contagem.pg_catalog.pg_attribute 15 15 0 0 0 0 0 8,349 1,871 3,569,155 25 441 brasilia.pg_catalog.pg_attribute 14 11 0 0 0 0 0 5,215 1,498 2,261,365 78 1,983 brasilia.pg_catalog.pg_class 11 7 0 0 0 0 0 1,384 436 671,402 30 104 brasilia.pg_catalog.pg_type 10 7 0 0 0 0 0 532 164 230,069 12 118 rio.pg_catalog.pg_statistic 10 10 0 0 0 0 0 11,874 2,802 12,072,918 1,421 4,972 contagem.pg_catalog.pg_class 9 9 0 0 0 0 0 1,720 294 502,439 10 21 rio.public.temp0000283204 9 0 0 0 0 0 0 719 170 268,263 0 0 rio.public.temp0000283390 9 0 0 0 0 0 0 675 50 47,527 0 0 rio.public.temp0000283638 8 0 0 0 0 0 0 12,856 32 763,328 0 0 contagem.pg_catalog.pg_type 8 8 0 0 0 0 0 831 239 371,901 5 15 rio.public.temp0000283178 8 0 0 0 0 0 0 853 45 57,560 0 0 rio.public.temp0000283628 8 0 0 0 0 0 0 6,634 34 396,784 0 0 contagem.public.temp0000226500 8 0 0 0 0 0 0 784 48 53,756 0 0 rio.public.temp0000281789 7 0 0 0 0 0 0 782 38 51,911 0 0 postgres.pg_catalog.pg_shdepend 7 7 0 0 0 0 0 783 299 484,409 29 96 contagem.pg_catalog.pg_depend 6 6 0 0 0 0 0 1,606 448 962,585 6 150 contagem.pg_catalog.pg_index 5 5 0 0 0 0 0 219 63 61,655 6 7 rio.pg_toast.pg_toast_2619 5 5 0 0 0 0 0 2,715 595 3,302,515 149 544 brasilia.auditor.auditor_2026_06 4 0 0 0 0 0 0 22,142 13,144 18,071,190 4,001 96,177 rio.public.usuarios 4 4 0 0 0 0 0 105 32 83,970 3 5 rio.public.temp0000283562 4 0 0 0 0 0 0 3,219 16 192,492 0 0 rio.public.temp0000283618 4 0 0 0 0 0 0 4,822 15 286,845 0 0 rio.public.temp0000283420 4 0 0 0 0 0 0 3,218 14 192,144 0 0 brasilia.pg_catalog.pg_index 4 4 0 0 0 0 0 204 71 55,514 13 37 rio.public.temp0000283102 4 0 0 0 0 0 0 445 22 29,665 0 0 brasilia.pg_catalog.pg_depend 3 3 0 0 0 0 0 750 261 336,477 25 1,266 rio.public.tmp_drill_0302 3 3 0 0 0 0 0 93 27 40,440 0 0 rio.public.tmp_drill_0175 3 3 0 0 0 0 0 86 9 19,006 0 0 rio.public.temp0000283604 3 0 0 0 0 0 0 1,708 13 102,852 0 0 brasilia.pg_catalog.pg_shdepend 3 3 0 0 0 0 0 371 136 287,584 14 58 brasilia.public.nf_entrada 3 1 0 0 0 0 0 209 76 170,168 2 3 rio.public.temp0000283552 3 0 0 0 0 0 0 3,292 14 196,342 0 0 contagem.pg_catalog.pg_statistic 3 3 0 0 0 0 0 3,624 721 2,657,247 470 3,305 contagem.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 285 64 258,579 18 45 contagem.public.temp0000226494 2 0 0 0 0 0 0 106 11 8,043 0 0 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 307 69 300,059 21 61 rio.public.temp0000283556 2 0 0 0 0 0 0 95 11 7,348 0 0 rio.public.temp0000283602 2 0 0 0 0 0 0 199 12 13,621 0 0 rio.public.temp0000283560 2 0 0 0 0 0 0 16 10 2,598 0 0 rio.public.temp0000283600 2 0 0 0 0 0 0 104 9 7,615 0 0 brasilia.pg_catalog.pg_statistic 2 2 0 0 0 0 0 3,701 375 1,518,516 271 1,934 brasilia.public.temp0000234648 2 0 0 0 0 0 0 472 12 30,100 0 0 rio.public.temp0000283620 1 0 0 0 0 0 0 144 6 9,502 0 0 rio.public.temp0000283606 1 0 0 0 0 0 0 99 6 6,778 0 0 brasilia.public.nf_entrada_arquivo_erros 1 0 0 0 0 0 0 54 8 20,571 4 218 brasilia.public.temp0000234612 1 0 0 0 0 0 0 235 234 371,246 0 0 brasilia.public.fluxos 1 1 0 0 0 0 0 2,401 1,887 7,794,194 53 2,409 rio.public.nf_entrada_arquivo_erros 1 0 0 0 0 0 0 760 623 1,747,551 83 3,985 rio.public.temp0000283576 1 0 0 0 0 0 0 1,603 4 95,180 0 0 brasilia.public.temp0000234614 1 0 0 0 0 0 0 236 6 15,050 0 0 brasilia.public.temp0000234610 1 0 0 0 0 0 0 236 6 15,050 0 0 rio.public.temp0000283566 1 0 0 0 0 0 0 8 5 1,299 0 0 brasilia.public.temp0000234664 1 0 0 0 0 0 0 236 6 15,050 0 0 rio.auditor.auditor_2026_06 1 0 0 0 0 0 0 147,908 102,369 129,453,081 22,787 457,820 rio.public.temp0000283306 1 0 0 0 0 0 0 99 6 6,780 0 0 contagem.public.nf_entrada 1 1 0 0 0 0 0 108 31 71,944 3 7 rio.public.temp0000283636 1 0 0 0 0 0 0 144 6 9,502 0 0 rio.public.temp0000283624 1 0 0 0 0 0 0 100 6 6,840 0 0 Total 581 279 0 0 0 0 0 418,309 144,728 218,840,360 30,352 589,476 Vacuum throughput per table
Key values
- auditor.auditor_2026_06 (34.95) 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 4.46 rio.pg_catalog.pg_class 0 0 1.07 rio.pg_catalog.pg_type 0 0 0.43 rio.public.temp0000283548 0 0 1.51 rio.public.temp0000283608 0 0 1.31 rio.public.temp0000283558 0 0 1.19 rio.public.temp0000283570 0 0 0.56 contagem.public.usuarios 0 0 0 rio.public.temp0000283596 0 0 0.45 rio.pg_catalog.pg_index 0 0 0.23 rio.pg_catalog.pg_depend 0 0 0.88 contagem.pg_catalog.pg_attribute 0 0 1.08 brasilia.pg_catalog.pg_attribute 0 0 1.34 brasilia.pg_catalog.pg_class 0 0 0.38 brasilia.pg_catalog.pg_type 0 0 0.16 rio.pg_catalog.pg_statistic 0 0 1.42 contagem.pg_catalog.pg_class 0 0 0.3 rio.public.temp0000283204 0 0 0.13 rio.public.temp0000283390 0 0 0.11 rio.public.temp0000283638 0 0 0.38 contagem.pg_catalog.pg_type 0 0 0.25 rio.public.temp0000283178 0 0 0.13 rio.public.temp0000283628 0 0 0.32 contagem.public.temp0000226500 0 0 0.13 rio.public.temp0000281789 0 0 0.09 postgres.pg_catalog.pg_shdepend 0 0 0.29 contagem.pg_catalog.pg_depend 0 0 0.31 contagem.pg_catalog.pg_index 0 0 0.18 rio.pg_toast.pg_toast_2619 0 0 0.37 brasilia.auditor.auditor_2026_06 0 0 4.25 rio.public.usuarios 0 0 0.02 rio.public.temp0000283562 0 0 0.16 rio.public.temp0000283618 0 0 0.17 rio.public.temp0000283420 0 0 0.18 brasilia.pg_catalog.pg_index 0 0 0.09 rio.public.temp0000283102 0 0 0.04 brasilia.pg_catalog.pg_depend 0 0 0.24 rio.public.tmp_drill_0302 0 0 0.01 rio.public.tmp_drill_0175 0 0 0 rio.public.temp0000283604 0 0 0.11 brasilia.pg_catalog.pg_shdepend 0 0 0.09 brasilia.public.nf_entrada 0 0 0.04 rio.public.temp0000283552 0 0 0.12 contagem.pg_catalog.pg_statistic 0 0 0.28 contagem.pg_toast.pg_toast_2619 0 0 0.03 contagem.public.temp0000226494 0 0 0.04 brasilia.pg_toast.pg_toast_2619 0 0 0.04 rio.public.temp0000283556 0 0 0.02 rio.public.temp0000283602 0 0 0.03 rio.public.temp0000283560 0 0 0.03 rio.public.temp0000283600 0 0 0.05 brasilia.pg_catalog.pg_statistic 0 0 0.28 brasilia.public.temp0000234648 0 0 0.03 rio.public.temp0000283620 0 0 0.02 rio.public.temp0000283606 0 0 0.02 brasilia.public.nf_entrada_arquivo_erros 0 0 0.02 brasilia.public.temp0000234612 0 0 0.04 brasilia.public.fluxos 0 0 1.77 rio.public.nf_entrada_arquivo_erros 0 0 0.32 rio.public.temp0000283576 0 0 0.05 brasilia.public.temp0000234614 0 0 0.03 brasilia.public.temp0000234610 0 0 0.03 rio.public.temp0000283566 0 0 0.01 brasilia.public.temp0000234664 0 0 0.02 rio.auditor.auditor_2026_06 0 0 34.95 rio.public.temp0000283306 0 0 0.02 contagem.public.nf_entrada 0 0 0.02 rio.public.temp0000283636 0 0 0.02 rio.public.temp0000283624 0 0 0.02 Total 0 0 63.17 Tuples removed per table
Key values
- pg_catalog.pg_attribute (226572) Main table with removed tuples on database rio
- 425707 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 66 55 226,572 1,674,065 125,974 572 39,452 contagem.pg_catalog.pg_attribute 15 15 60,088 352,647 580 168 8,005 brasilia.pg_catalog.pg_attribute 14 11 43,079 306,555 24,698 155 8,028 rio.pg_catalog.pg_statistic 10 10 17,642 83,820 17 0 12,860 rio.pg_catalog.pg_depend 16 16 12,010 309,692 2,716 0 2,888 rio.pg_catalog.pg_type 36 30 11,691 88,082 5,732 30 2,636 contagem.pg_catalog.pg_statistic 3 3 6,596 22,701 0 0 3,033 rio.pg_catalog.pg_index 19 19 5,558 37,121 493 0 1,178 brasilia.pg_catalog.pg_statistic 2 2 5,208 15,325 0 0 2,140 rio.pg_catalog.pg_class 45 37 5,127 180,668 18,910 61 5,950 postgres.pg_catalog.pg_shdepend 7 7 4,267 88,890 131 10 770 contagem.pg_catalog.pg_type 8 8 3,184 18,014 2 28 512 contagem.pg_catalog.pg_class 9 9 3,031 30,603 0 27 1,039 rio.auditor.auditor_2026_06 1 0 2,534 19,467,815 0 0 924,059 brasilia.pg_catalog.pg_type 10 7 2,532 19,954 2,306 33 639 contagem.pg_catalog.pg_depend 6 6 2,193 114,660 0 0 1,026 brasilia.public.nf_entrada 3 1 2,002 13,581 1,322 0 273 brasilia.pg_catalog.pg_shdepend 3 3 1,719 41,282 464 0 330 brasilia.pg_catalog.pg_class 11 7 1,419 43,019 5,713 29 1,338 rio.pg_toast.pg_toast_2619 5 5 1,408 4,139 4 3 1,403 contagem.public.usuarios 23 0 1,376 584 3 0 46 contagem.pg_catalog.pg_index 5 5 1,280 9,493 0 4 250 brasilia.pg_catalog.pg_depend 3 3 1,226 52,324 0 19 493 brasilia.public.fluxos 1 1 910 1,144,719 0 0 13,754 brasilia.pg_catalog.pg_index 4 4 885 7,502 0 3 210 brasilia.auditor.auditor_2026_06 4 0 870 2,062,380 0 0 89,796 rio.public.usuarios 4 4 308 2,327 299 0 68 rio.public.tmp_drill_0302 3 3 258 898 0 0 25 contagem.public.nf_entrada 1 1 224 893 0 0 69 brasilia.pg_toast.pg_toast_2619 2 2 200 243 0 29 82 contagem.pg_toast.pg_toast_2619 2 2 193 218 0 12 100 rio.public.nf_entrada_arquivo_erros 1 0 117 8,357,766 0 0 149,461 rio.public.temp0000283620 1 0 0 6,052 0 56 136 rio.public.temp0000283606 1 0 0 1,793 0 37 91 rio.public.temp0000283548 35 0 0 684,892 0 213 48,427 contagem.public.temp0000226494 2 0 0 2,341 0 76 180 rio.public.tmp_drill_0175 3 3 0 875 0 0 24 brasilia.public.nf_entrada_arquivo_erros 1 0 0 1,632,680 0 0 29,165 rio.public.temp0000283562 4 0 0 69,183 0 52 4,876 rio.public.temp0000283604 3 0 0 46,961 0 37 3,419 brasilia.public.temp0000234612 1 0 0 3,032 0 29 227 rio.public.temp0000283556 2 0 0 3,115 0 101 155 rio.public.temp0000283576 1 0 0 22,551 0 0 1,600 brasilia.public.temp0000234614 1 0 0 3,034 0 28 228 rio.public.temp0000283638 8 0 0 180,804 0 0 13,312 brasilia.public.temp0000234610 1 0 0 3,035 0 28 228 rio.public.temp0000283566 1 0 0 1,522 0 52 76 rio.public.temp0000283618 4 0 0 90,349 0 0 6,656 rio.public.temp0000283570 24 0 0 131,085 0 716 7,796 rio.public.temp0000283608 27 0 0 609,935 0 0 44,928 rio.public.temp0000283602 2 0 0 3,597 0 73 183 rio.public.temp0000283560 2 0 0 3,044 0 104 152 rio.public.temp0000283600 2 0 0 24,392 0 36 1,756 rio.public.temp0000283420 4 0 0 90,289 0 0 6,528 rio.public.temp0000283178 8 0 0 37,125 0 316 836 brasilia.public.temp0000234664 1 0 0 3,035 0 28 228 rio.public.temp0000283628 8 0 0 139,137 0 70 10,170 rio.public.temp0000283552 3 0 0 46,644 0 52 3,276 rio.public.temp0000281789 7 0 0 32,911 0 223 737 rio.public.temp0000283558 25 0 0 542,799 0 50 38,478 contagem.public.temp0000226500 8 0 0 9,385 0 304 720 brasilia.public.temp0000234648 2 0 0 6,070 0 56 456 rio.public.temp0000283306 1 0 0 1,791 0 37 91 rio.public.temp0000283204 9 0 0 45,878 0 242 1,038 rio.public.temp0000283636 1 0 0 6,048 0 56 136 rio.public.temp0000283624 1 0 0 1,807 0 36 92 rio.public.temp0000283596 22 0 0 127,878 0 646 6,906 rio.public.temp0000283102 4 0 0 18,604 0 89 423 rio.public.temp0000283390 9 0 0 32,020 0 370 718 Total 581 279 425,707 39,217,673 189,364 5,396 1,506,361 Pages removed per table
Key values
- public.temp0000283570 (716) Main table with removed pages on database rio
- 5396 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000283570 24 0 0 716 rio.public.temp0000283596 22 0 0 646 rio.pg_catalog.pg_attribute 66 55 226572 572 rio.public.temp0000283390 9 0 0 370 rio.public.temp0000283178 8 0 0 316 contagem.public.temp0000226500 8 0 0 304 rio.public.temp0000283204 9 0 0 242 rio.public.temp0000281789 7 0 0 223 rio.public.temp0000283548 35 0 0 213 contagem.pg_catalog.pg_attribute 15 15 60088 168 brasilia.pg_catalog.pg_attribute 14 11 43079 155 rio.public.temp0000283560 2 0 0 104 rio.public.temp0000283556 2 0 0 101 rio.public.temp0000283102 4 0 0 89 contagem.public.temp0000226494 2 0 0 76 rio.public.temp0000283602 2 0 0 73 rio.public.temp0000283628 8 0 0 70 rio.pg_catalog.pg_class 45 37 5127 61 rio.public.temp0000283620 1 0 0 56 brasilia.public.temp0000234648 2 0 0 56 rio.public.temp0000283636 1 0 0 56 rio.public.temp0000283562 4 0 0 52 rio.public.temp0000283566 1 0 0 52 rio.public.temp0000283552 3 0 0 52 rio.public.temp0000283558 25 0 0 50 rio.public.temp0000283606 1 0 0 37 rio.public.temp0000283604 3 0 0 37 rio.public.temp0000283306 1 0 0 37 rio.public.temp0000283600 2 0 0 36 rio.public.temp0000283624 1 0 0 36 brasilia.pg_catalog.pg_type 10 7 2532 33 rio.pg_catalog.pg_type 36 30 11691 30 brasilia.pg_toast.pg_toast_2619 2 2 200 29 brasilia.public.temp0000234612 1 0 0 29 brasilia.pg_catalog.pg_class 11 7 1419 29 brasilia.public.temp0000234614 1 0 0 28 brasilia.public.temp0000234610 1 0 0 28 contagem.pg_catalog.pg_type 8 8 3184 28 brasilia.public.temp0000234664 1 0 0 28 contagem.pg_catalog.pg_class 9 9 3031 27 brasilia.pg_catalog.pg_depend 3 3 1226 19 contagem.pg_toast.pg_toast_2619 2 2 193 12 postgres.pg_catalog.pg_shdepend 7 7 4267 10 contagem.pg_catalog.pg_index 5 5 1280 4 rio.pg_toast.pg_toast_2619 5 5 1408 3 brasilia.pg_catalog.pg_index 4 4 885 3 rio.pg_catalog.pg_index 19 19 5558 0 brasilia.auditor.auditor_2026_06 4 0 870 0 rio.public.usuarios 4 4 308 0 rio.public.tmp_drill_0302 3 3 258 0 rio.public.tmp_drill_0175 3 3 0 0 brasilia.public.nf_entrada_arquivo_erros 1 0 0 0 contagem.public.usuarios 23 0 1376 0 brasilia.public.fluxos 1 1 910 0 rio.public.nf_entrada_arquivo_erros 1 0 117 0 rio.public.temp0000283576 1 0 0 0 brasilia.pg_catalog.pg_shdepend 3 3 1719 0 rio.pg_catalog.pg_statistic 10 10 17642 0 rio.public.temp0000283638 8 0 0 0 brasilia.public.nf_entrada 3 1 2002 0 rio.public.temp0000283618 4 0 0 0 rio.public.temp0000283608 27 0 0 0 brasilia.pg_catalog.pg_statistic 2 2 5208 0 rio.public.temp0000283420 4 0 0 0 rio.pg_catalog.pg_depend 16 16 12010 0 contagem.pg_catalog.pg_depend 6 6 2193 0 rio.auditor.auditor_2026_06 1 0 2534 0 contagem.public.nf_entrada 1 1 224 0 contagem.pg_catalog.pg_statistic 3 3 6596 0 Total 581 279 425,707 5,396 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jun 25 00 1 6 01 0 0 02 0 0 03 0 0 04 1 3 05 6 6 06 0 0 07 10 18 08 53 84 09 74 153 10 51 133 11 40 125 12 28 70 13 39 81 14 36 115 15 86 173 16 93 171 17 60 91 18 0 0 19 0 0 20 0 0 21 3 3 22 0 0 23 0 1 - 34.95 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 11 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 7 11m8s 4s707ms 2m25s 1m35s call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-25 15:27:39 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-25 08:47:36 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-25 10:17:29 Database: rio User: intelifix Remote: [local] Application: psql
2 1 48s399ms 48s399ms 48s399ms 48s399ms select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026184, 0433 )', '/var/www/html/tmp/nf_carga_lotes_0433.xlsx');
Date: 2026-06-25 15:27:36 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026157, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-25 11:40:54 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026183, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-25 15:14:46 Database: rio User: intelifix Remote: [local] Application: [unknown]
3 1 1s648ms 1s648ms 1s648ms 1s648ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (256950, 504, 'E44E12B31CB5,ZTE3A8TR7R10829C7D21ED7BD3,ZTE3A8TRCB15028C7D21EFD0B7,ZTE3A8TRCS02229$B47CA60824CE,ZTE3A8TR8U07435C7D21ED6FF3,ZTE3A8TRCB14268EA,ZTE3A8TT3306074$B47CA6082F9A,ZTE3A8TR8U08126$E44E12AF964D,ZTE3A8TR6D04075$E44E1292843B,ZTE3A8TR5U18813E,ZTE3A8TT3306475C7D21ED6FC3,ZTE3A8TRCB14256C7D21EFD1B3,ZTE3A8TRCS02292$E44E12935B4B,ZTE3A8TR6507077C7D21F0B03B,ZTE3A8TRCS16534C7D21EB4A1F,ZTE3A8TRB704579$B47CA60826C6,ZTE3A8TR8U07561C7D21EFACE3,ZTE3A8TRCP25436$B47CA6082B4E,ZTE3A8TR8U07851C7D21EEAC3F,ZTE3A8TRCP09011C7D21EEAC43,ZTE3A8TRCP09012C7D21EEAD2F,ZTE3A8TRCP09071A4788FC,ZTE3A8TR4H06467$E44E12AFA69D,ZTE3A8TR6D05119B292,ZTE3A8TT4703344B16A,ZTE3A8TT4703270B2C6,ZTE3A8TT4703357$E44E12AF76FD,ZTE3A8TR6D02071$E44E12AF76F9,ZTE3A8TR6D02070,ZTE3A8TT3C16872$E44E12AFA955,ZTE3A8TR6D05293D46A,ZTE3A8TT4705510$E44E12AF95F9,ZTE3A8TR6D04054C7D21F0E877,ZTE3A8TRCS20133C7D21EFACB7,ZTE3A8TRCP25425D69A,ZTE3A8TT4705650$E44E129211E7,ZTE3A8TR5U11496$B47CA60863BE,ZTE3A8TR8U11463B0E,ZTE3A8TT3R21195B1FE,ZTE3A8TT4703307$E44E12AFA8C1,ZTE3A8TR6D05256', '',0461,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-25 10:23:12 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (43385, 413, 'ZTE3ANNT3H84994,D831399E8BA4,D831399E8BA5,ZTEGDD331CA1$ZTE3ANNRB710381,5872C98F2C7F,5872C98F2C80,ZTEGDC615360$ZTE3ANNRCB66824,D8313923ED2E,D8313923ED2F,ZTEGDD2ABA9D$ZTE3ANNRC553105,6C11BA67067D,6C11BA67067E,ZTEGDC6EE530$ZTE3ANNR3J30214,F4E84F891284,F4E84F891285,ZTEGD97BD7D0$ZTE3ANNRCB24128,D8313920047E,D8313920047F,ZTEGDD2A13D5$ZTE3ANNRC501485,6C11BA624CA5,6C11BA624CA6,ZTEGDC6E1B8C$ZTE3ANNRCP04067,6C11BA698A21,6C11BA698A22,ZTEGDC6F5076$ZTE3ANNR6R51071,48D6823A31BC,48D6823A31BD,ZTEGDB01F252$ZTE3ANNR7B16817,3891484A76CD,3891484A76CE,ZTEGDB07D311$ZTE3ANNQ9J07881,843C992C89EB,843C992C89EC,ZTEGD7BB2774$ZTE3ANNT3H83335,D831399E64C2,D831399E64C3,ZTEGDD331626$ZTE3ANNR3Y38290,4896D9534224,4896D9534225,ZTEGD97EC647$ZTE3ANNRCP46879,6C11BA6D7589,6C11BA6D758A,ZTEGDC6FF7B2$ZTE3ANNR9F20502,D89A0DA4BE67,D89A0DA4BE68,ZTEGDB157761$ZTE3ANNT2V84660,D83139934F10,D83139934F11,ZTEGDD313D33$ZTE3ANNR3Y01214,4896D94FDD2C,4896D94FDD2D,ZTEGD97E3573$ZTE3ANNT3H44244,D831399AD090,D831399AD091,ZTEGDD327D73$ZTE3ANNR7B33377,3891484BFAED,3891484BFAEE,ZTEGDB0813C1$ZTE3ANNR1Y30992,14CA56CF80DB,14CA56CF80DC,ZTEGD970EF6B$ZTE3ANNQ9J21762,843C992DCF41,843C992DCF42,ZTEGD7BB5DAD$ZTE3ANNQ3R19637,3CF9F0A44C04,3CF9F0A44C05,ZTEGD6404CB4$ZTE3ANNR9W44463,D89A0DAC6E3D,D89A0DAC6E3E,ZTEGDB16BF5A$ZTE3ANNR9W00201,D89A0DA860D9,D89A0DA860DA,ZTEGDB161274$ZTE3ANNT3H44837,D831399ADE76,D831399ADE77,ZTEGDD327FC4$ZTE3ANNR9W03871,D89A0DA8B6DD,D89A0DA8B6DE,ZTEGDB1620CA$ZTE3ANNRC552601,6C11BA66FAAD,6C11BA66FAAE,ZTEGDC6EE338$ZTE3ANNQ4407812,3CF9F0AC15F6,3CF9F0AC15F7,ZTEGD6419907$ZTE3ANNQ6M08360,C4EBFF8925C0,C4EBFF8925C1,ZTEGD70A01B6$ZTE3ANNR7B55539,3891484E0259,3891484E025A,ZTEGDB086A53$ZTE3ANNRAD24215,D89A0DB011ED,D89A0DB011EE,ZTEGDB175AA2$ZTE3ANNRAM42373,5872C98B1957,5872C98B1958,ZTEGDC60A584$ZTE3ANNR4N26707,4896D957CD0A,4896D957CD0B,ZTEGD97F8818$ZTE3ANNT3H01502,D8313996E6CC,D8313996E6CD,ZTEGDD31D67D$ZTE3ANNR9W44791,D89A0DAC75ED,D89A0DAC75EE,ZTEGDB16C0A2$ZTE3ANNR7B33332,3891484BF9DF,3891484BF9E0,ZTEGDB081394$ZTE3ANNR2Q01303,F4E84F80D28A,F4E84F80D28B,ZTEGD97A77D1$ZTE3ANNR8C08909,3891484F57D5,3891484F57D6,ZTEGDB08A33D$ZTE3ANNRAD30063,D89A0DB09AFD,D89A0DB09AFE,ZTEGDB17717A$ZTE3ANNT2V71524,D83139921B30,D83139921B31,ZTEGDD3109E3$ZTE3ANNRC536205,6C11BA657A65,6C11BA657A66,ZTEGDC6EA32C$ZTE3ANNRCP44066,6C11BA6D339B,6C11BA6D339C,219677788789$ZTE3ANNQ9311821,843C9933AA4B,843C9933AA4C,ZTEGD7BBEA24$ZTE3ANNQ9J21695,843C992DCDAF,843C992DCDB0,ZTEGD7BB5D6A', '',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-25 11:00:23 Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (43479, 413, '226304298197', '',0172,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-25 15:01:36 Database: contagem User: intelifix Remote: [local] Application: [unknown]
4 1 1s1ms 1s1ms 1s1ms 1s1ms drop table if exists temp0000283570;-
DROP TABLE IF EXISTS temp0000283570;
Date: 2026-06-25 09:28:44 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000283570;
Date: 2026-06-25 09:28:44 Database: rio User: intelifix Remote: [local] Application: [unknown]
5 1 1s 1s 1s 1s drop table if exists temp0000283596;-
DROP TABLE IF EXISTS temp0000283596;
Date: 2026-06-25 13:54:46 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000283596;
Date: 2026-06-25 13:54:46 Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries that waited the most
Rank Wait time Query 1 2m25s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-06-25 08:47:33 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 2m23s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-06-25 15:27:36 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 2m16s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-06-25 10:17:27 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 1m53s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-06-25 11:57:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 1m25s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-06-25 07:16:33 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 48s399ms SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026188, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');[ Date: 2026-06-25 15:33:06 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
7 39s214ms CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-06-25 07:25:48 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 4s707ms CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-06-25 08:35:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 1s648ms SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (258282, 449, '517248333438,B0935BED3061$517290567788,BC644BC6658B$517163028289,B0DAF964289D$517271194153,BC644BC46ACE$510042009091,CC75E2BF25ED$517334768293,BC644BC94981', '',042,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""}]','$$$$$$$$$$$$$$$','', 00);[ Date: 2026-06-25 09:01:07 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 1s1ms DROP TABLE IF EXISTS temp0000283570;[ Date: 2026-06-25 09:28:44 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
11 1s DROP TABLE IF EXISTS temp0000283596;[ Date: 2026-06-25 13:54:46 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 5,837 Total read queries
- 1,977 Total write queries
Queries by database
Key values
- rio Main database
- 5,180 Requests
- 7h51m5s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 8,012 Requests
User Request type Count Duration etiquetas Total 42 25s614ms select 42 25s614ms intelifix Total 8,012 9h56m22s copy to 333 47m50s ddl 1,643 1h13m55s others 365 49m52s select 5,671 7h4m44s lenon Total 125 1m49s ddl 1 162ms select 124 1m49s Duration by user
Key values
- 9h56m22s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 42 25s614ms select 42 25s614ms intelifix Total 8,012 9h56m22s copy to 333 47m50s ddl 1,643 1h13m55s others 365 49m52s select 5,671 7h4m44s lenon Total 125 1m49s ddl 1 162ms select 124 1m49s Queries by host
Key values
- [local] Main host
- 8,178 Requests
- 9h58m37s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 7,189 Requests
- 4h57m10s ([unknown])
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-06-25 11:23:50 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 4,566 100-500ms duration
Slowest individual queries
Rank Duration Query 1 8m49s analyze verbose;[ Date: 2026-06-25 05:08:51 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 8m37s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-25 10:13:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 8m34s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-25 11:13:36 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 8m34s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-25 09:13:36 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 8m3s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-25 12:13:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 7m56s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-25 15:12:58 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 7m42s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-25 07:12:43 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 7m40s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-25 17:12:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 7m23s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-25 16:12:24 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 7m17s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-25 14:12:19 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 7m7s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-25 13:12:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 6m17s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-25 18:11:18 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 6m8s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-25 20:11:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 6m2s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-25 21:11:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m56s SELECT * FROM RS_SMART_FISCAL_ENTRADA () NOTICE: table "tmp_entrada" does not exist, skipping;[ Date: 2026-06-25 08:10:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m54s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-25 22:10:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m47s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-25 19:10:49 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 5m34s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026184, 0433 )', '/var/www/html/tmp/nf_carga_lotes_0433.xlsx');[ Date: 2026-06-25 15:27:36 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 5m31s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026157, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-06-25 11:40:54 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 5m23s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026183, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-06-25 15:14:46 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 2h32m26s 408 157ms 5m34s 22s417ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 25 07 18 12m30s 41s687ms 08 31 24m33s 47s544ms 09 49 11m16s 13s796ms 10 47 20m52s 26s651ms 11 42 18m47s 26s847ms 12 23 10m36s 27s661ms 13 30 6m31s 13s60ms 14 19 20s371ms 1s72ms 15 67 34m45s 31s128ms 16 46 8m46s 11s455ms 17 36 3m24s 5s692ms [ User: intelifix - Total duration: 2h32m26s - Times executed: 408 ]
[ Application: [unknown] - Total duration: 2h32m26s - Times executed: 408 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026184, 0433 )', '/var/www/html/tmp/nf_carga_lotes_0433.xlsx');
Date: 2026-06-25 15:27:36 Duration: 5m34s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026157, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-25 11:40:54 Duration: 5m31s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026183, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-25 15:14:46 Duration: 5m23s Database: rio User: intelifix Remote: [local] Application: [unknown]
2 1h56m37s 47 1s200ms 8m37s 2m28s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 25 07 3 8m17s 2m45s 08 2 19s431ms 9s715ms 09 3 9m12s 3m4s 10 3 9m14s 3m4s 11 3 9m23s 3m7s 12 3 8m36s 2m52s 13 3 7m42s 2m34s 14 3 7m43s 2m34s 15 3 8m23s 2m47s 16 3 7m48s 2m36s 17 3 8m9s 2m43s 18 3 6m36s 2m12s 19 3 6m4s 2m1s 20 3 6m31s 2m10s 21 3 6m20s 2m6s 22 3 6m12s 2m4s [ User: intelifix - Total duration: 1h56m37s - Times executed: 47 ]
[ Application: psql - Total duration: 1h56m37s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-25 10:13:38 Duration: 8m37s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-25 11:13:36 Duration: 8m34s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-25 09:13:36 Duration: 8m34s Database: rio User: intelifix Remote: [local] Application: psql
3 1h12m16s 48 195ms 4m42s 1m30s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 25 07 3 4m24s 1m28s 08 3 4m5s 1m21s 09 3 5m9s 1m43s 10 3 5m9s 1m43s 11 3 5m19s 1m46s 12 3 4m48s 1m36s 13 3 4m46s 1m35s 14 3 4m23s 1m27s 15 3 5m30s 1m50s 16 3 4m35s 1m31s 17 3 4m27s 1m29s 18 3 3m53s 1m17s 19 3 3m44s 1m14s 20 3 4m17s 1m25s 21 3 3m51s 1m17s 22 3 3m48s 1m16s [ User: intelifix - Total duration: 1h12m16s - Times executed: 48 ]
[ Application: psql - Total duration: 1h12m16s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-25 15:18:50 Duration: 4m42s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-25 11:19:27 Duration: 4m32s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-25 10:19:17 Duration: 4m19s Database: brasilia User: intelifix Remote: [local] Application: psql
4 20m47s 100 1s174ms 53s205ms 12s470ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 25 08 9 1m20s 8s974ms 09 8 2m44s 20s503ms 10 7 1m37s 13s869ms 11 10 1m47s 10s703ms 12 5 14s704ms 2s940ms 13 7 1m40s 14s400ms 14 9 1m52s 12s522ms 15 15 2m52s 11s516ms 16 18 3m55s 13s86ms 17 12 2m41s 13s465ms [ User: intelifix - Total duration: 20m47s - Times executed: 100 ]
[ Application: [unknown] - Total duration: 20m47s - Times executed: 100 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-25', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-25 08:43:01 Duration: 53s205ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-25', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-25 09:42:36 Duration: 44s649ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-25', 0175, '', '', 0, 6, '2026-06-01');
Date: 2026-06-25 15:21:04 Duration: 44s294ms Database: rio User: intelifix Remote: [local] Application: [unknown]
5 20m12s 160 151ms 2m31s 7s578ms call rs_giga_triagem (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 25 00 7 29s988ms 4s284ms 01 6 17s642ms 2s940ms 02 8 18s71ms 2s258ms 03 7 18s602ms 2s657ms 04 7 19s176ms 2s739ms 05 6 18s897ms 3s149ms 06 7 19s41ms 2s720ms 07 6 2m26s 24s439ms 08 6 2m59s 29s846ms 09 7 31s974ms 4s567ms 10 7 2m45s 23s603ms 11 7 2m24s 20s642ms 12 6 24s429ms 4s71ms 13 8 25s11ms 3s126ms 14 6 25s496ms 4s249ms 15 8 2m53s 21s712ms 16 8 26s9ms 3s251ms 17 7 21s79ms 3s11ms 18 6 20s703ms 3s450ms 19 8 20s954ms 2s619ms 20 7 24s101ms 3s443ms 21 9 21s213ms 2s357ms 22 6 21s28ms 3s504ms [ User: intelifix - Total duration: 20m12s - Times executed: 160 ]
[ Application: psql - Total duration: 20m12s - Times executed: 160 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-25 15:27:39 Duration: 2m31s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-25 08:47:36 Duration: 2m30s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-25 10:17:29 Duration: 2m22s Database: rio User: intelifix Remote: [local] Application: psql
6 20m7s 1,555 150ms 5s72ms 776ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 25 08 145 1m31s 632ms 09 204 2m23s 701ms 10 191 2m36s 817ms 11 168 2m36s 933ms 12 98 1m9s 712ms 13 104 1m26s 832ms 14 165 2m4s 753ms 15 196 2m43s 833ms 16 195 2m35s 797ms 17 89 1m 684ms [ User: intelifix - Total duration: 20m7s - Times executed: 1555 ]
[ Application: [unknown] - Total duration: 20m7s - Times executed: 1555 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (256950, 504, 'E44E12B31CB5,ZTE3A8TR7R10829C7D21ED7BD3,ZTE3A8TRCB15028C7D21EFD0B7,ZTE3A8TRCS02229$B47CA60824CE,ZTE3A8TR8U07435C7D21ED6FF3,ZTE3A8TRCB14268EA,ZTE3A8TT3306074$B47CA6082F9A,ZTE3A8TR8U08126$E44E12AF964D,ZTE3A8TR6D04075$E44E1292843B,ZTE3A8TR5U18813E,ZTE3A8TT3306475C7D21ED6FC3,ZTE3A8TRCB14256C7D21EFD1B3,ZTE3A8TRCS02292$E44E12935B4B,ZTE3A8TR6507077C7D21F0B03B,ZTE3A8TRCS16534C7D21EB4A1F,ZTE3A8TRB704579$B47CA60826C6,ZTE3A8TR8U07561C7D21EFACE3,ZTE3A8TRCP25436$B47CA6082B4E,ZTE3A8TR8U07851C7D21EEAC3F,ZTE3A8TRCP09011C7D21EEAC43,ZTE3A8TRCP09012C7D21EEAD2F,ZTE3A8TRCP09071A4788FC,ZTE3A8TR4H06467$E44E12AFA69D,ZTE3A8TR6D05119B292,ZTE3A8TT4703344B16A,ZTE3A8TT4703270B2C6,ZTE3A8TT4703357$E44E12AF76FD,ZTE3A8TR6D02071$E44E12AF76F9,ZTE3A8TR6D02070,ZTE3A8TT3C16872$E44E12AFA955,ZTE3A8TR6D05293D46A,ZTE3A8TT4705510$E44E12AF95F9,ZTE3A8TR6D04054C7D21F0E877,ZTE3A8TRCS20133C7D21EFACB7,ZTE3A8TRCP25425D69A,ZTE3A8TT4705650$E44E129211E7,ZTE3A8TR5U11496$B47CA60863BE,ZTE3A8TR8U11463B0E,ZTE3A8TT3R21195B1FE,ZTE3A8TT4703307$E44E12AFA8C1,ZTE3A8TR6D05256', '',0461,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-25 10:23:12 Duration: 5s72ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (43385, 413, 'ZTE3ANNT3H84994,D831399E8BA4,D831399E8BA5,ZTEGDD331CA1$ZTE3ANNRB710381,5872C98F2C7F,5872C98F2C80,ZTEGDC615360$ZTE3ANNRCB66824,D8313923ED2E,D8313923ED2F,ZTEGDD2ABA9D$ZTE3ANNRC553105,6C11BA67067D,6C11BA67067E,ZTEGDC6EE530$ZTE3ANNR3J30214,F4E84F891284,F4E84F891285,ZTEGD97BD7D0$ZTE3ANNRCB24128,D8313920047E,D8313920047F,ZTEGDD2A13D5$ZTE3ANNRC501485,6C11BA624CA5,6C11BA624CA6,ZTEGDC6E1B8C$ZTE3ANNRCP04067,6C11BA698A21,6C11BA698A22,ZTEGDC6F5076$ZTE3ANNR6R51071,48D6823A31BC,48D6823A31BD,ZTEGDB01F252$ZTE3ANNR7B16817,3891484A76CD,3891484A76CE,ZTEGDB07D311$ZTE3ANNQ9J07881,843C992C89EB,843C992C89EC,ZTEGD7BB2774$ZTE3ANNT3H83335,D831399E64C2,D831399E64C3,ZTEGDD331626$ZTE3ANNR3Y38290,4896D9534224,4896D9534225,ZTEGD97EC647$ZTE3ANNRCP46879,6C11BA6D7589,6C11BA6D758A,ZTEGDC6FF7B2$ZTE3ANNR9F20502,D89A0DA4BE67,D89A0DA4BE68,ZTEGDB157761$ZTE3ANNT2V84660,D83139934F10,D83139934F11,ZTEGDD313D33$ZTE3ANNR3Y01214,4896D94FDD2C,4896D94FDD2D,ZTEGD97E3573$ZTE3ANNT3H44244,D831399AD090,D831399AD091,ZTEGDD327D73$ZTE3ANNR7B33377,3891484BFAED,3891484BFAEE,ZTEGDB0813C1$ZTE3ANNR1Y30992,14CA56CF80DB,14CA56CF80DC,ZTEGD970EF6B$ZTE3ANNQ9J21762,843C992DCF41,843C992DCF42,ZTEGD7BB5DAD$ZTE3ANNQ3R19637,3CF9F0A44C04,3CF9F0A44C05,ZTEGD6404CB4$ZTE3ANNR9W44463,D89A0DAC6E3D,D89A0DAC6E3E,ZTEGDB16BF5A$ZTE3ANNR9W00201,D89A0DA860D9,D89A0DA860DA,ZTEGDB161274$ZTE3ANNT3H44837,D831399ADE76,D831399ADE77,ZTEGDD327FC4$ZTE3ANNR9W03871,D89A0DA8B6DD,D89A0DA8B6DE,ZTEGDB1620CA$ZTE3ANNRC552601,6C11BA66FAAD,6C11BA66FAAE,ZTEGDC6EE338$ZTE3ANNQ4407812,3CF9F0AC15F6,3CF9F0AC15F7,ZTEGD6419907$ZTE3ANNQ6M08360,C4EBFF8925C0,C4EBFF8925C1,ZTEGD70A01B6$ZTE3ANNR7B55539,3891484E0259,3891484E025A,ZTEGDB086A53$ZTE3ANNRAD24215,D89A0DB011ED,D89A0DB011EE,ZTEGDB175AA2$ZTE3ANNRAM42373,5872C98B1957,5872C98B1958,ZTEGDC60A584$ZTE3ANNR4N26707,4896D957CD0A,4896D957CD0B,ZTEGD97F8818$ZTE3ANNT3H01502,D8313996E6CC,D8313996E6CD,ZTEGDD31D67D$ZTE3ANNR9W44791,D89A0DAC75ED,D89A0DAC75EE,ZTEGDB16C0A2$ZTE3ANNR7B33332,3891484BF9DF,3891484BF9E0,ZTEGDB081394$ZTE3ANNR2Q01303,F4E84F80D28A,F4E84F80D28B,ZTEGD97A77D1$ZTE3ANNR8C08909,3891484F57D5,3891484F57D6,ZTEGDB08A33D$ZTE3ANNRAD30063,D89A0DB09AFD,D89A0DB09AFE,ZTEGDB17717A$ZTE3ANNT2V71524,D83139921B30,D83139921B31,ZTEGDD3109E3$ZTE3ANNRC536205,6C11BA657A65,6C11BA657A66,ZTEGDC6EA32C$ZTE3ANNRCP44066,6C11BA6D339B,6C11BA6D339C,219677788789$ZTE3ANNQ9311821,843C9933AA4B,843C9933AA4C,ZTEGD7BBEA24$ZTE3ANNQ9J21695,843C992DCDAF,843C992DCDB0,ZTEGD7BB5D6A', '',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-25 11:00:23 Duration: 4s683ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (43479, 413, '226304298197', '',0172,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-25 15:01:36 Duration: 4s669ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
7 17m10s 90 8s922ms 29s783ms 11s448ms create table temp0000283548 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 25 07 18 3m20s 11s148ms 08 22 4m12s 11s487ms 09 5 57s380ms 11s476ms 10 21 4m4s 11s631ms 11 12 2m30s 12s537ms 12 12 2m4s 10s407ms [ User: intelifix - Total duration: 17m10s - Times executed: 90 ]
[ Application: [unknown] - Total duration: 17m10s - Times executed: 90 ]
-
CREATE TABLE temp0000283548 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-25 07:11:37 Duration: 29s783ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283548 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-25 11:50:40 Duration: 14s455ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283548 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-25 11:52:05 Duration: 14s169ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 15m41s 3 2m35s 8m49s 5m13s analyze verbose;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 25 05 3 15m41s 5m13s [ User: intelifix - Total duration: 15m41s - Times executed: 3 ]
[ Application: psql - Total duration: 15m41s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-06-25 05:08:51 Duration: 8m49s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-25 05:13:07 Duration: 4m15s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-25 05:15:43 Duration: 2m35s Database: contagem User: intelifix Remote: [local] Application: psql
9 9m30s 1,147 150ms 4s94ms 497ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 25 07 7 4s334ms 619ms 08 87 50s318ms 578ms 09 137 1m9s 510ms 10 149 1m13s 492ms 11 117 57s591ms 492ms 12 12 8s633ms 719ms 13 96 42s692ms 444ms 14 165 1m20s 486ms 15 167 1m16s 457ms 16 178 1m28s 498ms 17 32 17s900ms 559ms [ User: intelifix - Total duration: 9m30s - Times executed: 1147 ]
[ Application: [unknown] - Total duration: 9m30s - Times executed: 1147 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "230007", "modelo" : "320", "itens" : "241649690524,241689163444,241597528181,241708972942,241622554867,241647364561,241669661530,241677356567,241708821940,241637708298,241668192228,241717160105,241713370521,241693221416,241654646674,230048450217,230048424658,241664775665,241692651327,241676807894,241708756781,241646269011,241616232331,241708804665,241677737794,241673135875,241680363337,241717141315,241630184343,241711188286,241704272528,241714893239,241680471732,241654476983,241696821835,241664836681,241593825374,241649180822,241631279512,241602548807,241698752124,230043694062,241713047379,241713739703,241667103042,241596232433,241696841433", "usuario" : "414", "caixa" : "2756829", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-25 16:19:02 Duration: 4s94ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "258707", "modelo" : "320", "itens" : "241658563948,241663213650,241629411530,241675327278,241671546483,241715473251,241650255157,241629893653,241603267193,241698480729,241734211724,241689413446,241715584047,241599580527,241700855561,241693075868,241698482143,241703569192,241661382237,241682571129,241631469508,241638390117,241649527577,241680394350,241691093049,241725877374,241646546770,241691763855,241616811434,241620281335,241637585761,241593423135,241652856982,241610151233,241659635152,241621186686,241679394264,241712591926,241655184258,241621207800,241649640822,241655667896,241709089697,241673411234,241660135459,241628225061,241679605575,241645618991", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-25 15:50:25 Duration: 2s554ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "258259", "modelo" : "263", "itens" : "229910765656,229902352636,229919101723,229893147887,229911855572,229912600303,229899896279,229897073950,229898095576,229910585661,229902425774,229897372442,229892408993,229916321317,229915528399,229898796082,229900710108,229910306767,229910312425,229895383639,229901388388,229918707587,229918909201,229870778891,229919161426,229897780215,229902024646,229893404456,229899142233,229918697586,229898821315,229913242644,229916453855,229896958406,229899229211,229902668301,229871410223,229910064163,229912200107,229918539816,229916205469,229918198693,229896423651,229902644965,229876622841,229901770324,229874075364,229896639508", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-25 08:00:25 Duration: 2s172ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 8m45s 46 9s446ms 14s854ms 11s419ms create table temp0000283608 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 25 13 2 21s498ms 10s749ms 15 19 3m42s 11s714ms 16 20 3m44s 11s243ms 17 5 56s336ms 11s267ms [ User: intelifix - Total duration: 8m45s - Times executed: 46 ]
[ Application: [unknown] - Total duration: 8m45s - Times executed: 46 ]
-
CREATE TABLE temp0000283608 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-25 15:47:22 Duration: 14s854ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283608 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-25 15:33:42 Duration: 14s206ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283608 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-25 16:42:04 Duration: 13s375ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 7m45s 40 9s403ms 13s594ms 11s646ms create table temp0000283558 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 25 08 6 1m3s 10s527ms 09 4 47s145ms 11s786ms 10 14 2m45s 11s790ms 11 9 1m50s 12s280ms 12 7 1m19s 11s422ms [ User: intelifix - Total duration: 7m45s - Times executed: 40 ]
[ Application: [unknown] - Total duration: 7m45s - Times executed: 40 ]
-
CREATE TABLE temp0000283558 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-25 11:24:23 Duration: 13s594ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283558 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-25 10:43:44 Duration: 13s571ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283558 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-25 09:06:47 Duration: 13s389ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 7m17s 144 244ms 17s765ms 3s37ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 25 00 6 24s507ms 4s84ms 01 6 8s856ms 1s476ms 02 4 5s547ms 1s386ms 03 5 13s76ms 2s615ms 04 6 13s115ms 2s185ms 05 5 9s8ms 1s801ms 07 5 29s98ms 5s819ms 08 10 43s655ms 4s365ms 09 10 42s652ms 4s265ms 10 12 44s992ms 3s749ms 11 12 41s819ms 3s484ms 12 11 36s495ms 3s317ms 13 8 7s402ms 925ms 14 10 34s176ms 3s417ms 15 12 39s773ms 3s314ms 16 9 21s612ms 2s401ms 17 3 2s695ms 898ms 21 4 8s433ms 2s108ms 22 6 10s425ms 1s737ms [ User: intelifix - Total duration: 7m17s - Times executed: 144 ]
[ Application: psql - Total duration: 7m17s - Times executed: 144 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-25 00:05:18 Duration: 17s765ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-25 12:25:11 Duration: 9s565ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-25 15:35:09 Duration: 8s606ms Database: rio User: intelifix Remote: [local] Application: psql
13 7m6s 1,063 150ms 2s454ms 401ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 25 09 28 14s114ms 504ms 10 142 40s249ms 283ms 11 64 17s527ms 273ms 13 48 18s789ms 391ms 14 422 3m11s 453ms 15 247 1m44s 422ms 16 112 40s545ms 362ms [ User: intelifix - Total duration: 7m6s - Times executed: 1063 ]
[ Application: [unknown] - Total duration: 7m6s - Times executed: 1063 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"125752","seriais":"241771182223,241762563043,241742841635,241770520509,241775273857,241762525362,241743248699,241765613049,241778774445,241742963442,241775300022,241765608806,241771165678,241778593743,241744171327,241768011117,241767948709,241746657281,241762511422,241739441617,241776850521,241743295674,241764106066,241777832244,241744203653,241777485767,241744200421,241765425454,241764422338,241765416082,241739559002,241762348094,241771254856,241767939112,241778614957,241768082437,241745706874,241740528906,241775325859,241746638693","usuario":"398","observacao":""}');
Date: 2026-06-25 14:55:27 Duration: 2s454ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"125752","seriais":"241737871419,241784603948,241751216570,241784608594,241737942537,241750436483,241780524459,241720499005,241723032945,241753547179,241757294156,241720378487,241754149113,241784467290,241757300218,241780590527,241784695270,241754166869,241722319205,241757263648,241755699006,241705026574,241722391031,241784692745,241750014141,241783259507,241749975170,241722343652,241748961727,241754288699,241734594668,241725796076,241749063151,241736935659,241750363042,241780567493,241751833556,241724328895,241784686784,241784742828","usuario":"398","observacao":""}');
Date: 2026-06-25 15:32:13 Duration: 2s293ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"125752","seriais":"241739682325,241759734652,241742378604,241759640121,241739614866,241759646484,241742349308,241743107496,241764540509,241760824141,241764549802,241764542024,241742243540,241743096283,241743091233,241763970521,241763989007,241760823737,241759644666,241763968803,241759659112,241760873338,241778079797","usuario":"398","observacao":""}');
Date: 2026-06-25 14:46:42 Duration: 2s72ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
14 6m7s 32 9s831ms 14s302ms 11s485ms create table temp0000283570 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 25 09 32 6m7s 11s485ms [ User: intelifix - Total duration: 6m7s - Times executed: 32 ]
[ Application: [unknown] - Total duration: 6m7s - Times executed: 32 ]
-
CREATE TABLE temp0000283570 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-25 09:28:33 Duration: 14s302ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283570 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-25 09:34:28 Duration: 13s334ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283570 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-25 09:28:05 Duration: 12s858ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 5m56s 1 5m56s 5m56s 5m56s select * from rs_smart_fiscal_entrada () notice: table "tmp_entrada" does not exist, skipping;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 25 08 1 5m56s 5m56s [ User: intelifix - Total duration: 5m56s - Times executed: 1 ]
[ Application: psql - Total duration: 5m56s - Times executed: 1 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA () NOTICE: table "tmp_entrada" does not exist, skipping;
Date: 2026-06-25 08:10:57 Duration: 5m56s Database: rio User: intelifix Remote: [local] Application: psql
16 5m7s 27 8s927ms 21s635ms 11s391ms create table temp0000283596 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 25 13 17 3m21s 11s826ms 14 10 1m46s 10s653ms [ User: intelifix - Total duration: 5m7s - Times executed: 27 ]
[ Application: [unknown] - Total duration: 5m7s - Times executed: 27 ]
-
CREATE TABLE temp0000283596 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-25 13:33:15 Duration: 21s635ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283596 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-25 14:26:28 Duration: 13s604ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283596 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-25 13:52:28 Duration: 13s500ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 4m3s 2 6s156ms 3m57s 2m1s 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 (;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 25 12 1 3m57s 3m57s 14 1 6s156ms 6s156ms [ User: intelifix - Total duration: 4m3s - Times executed: 2 ]
[ Application: [unknown] - Total duration: 4m3s - Times executed: 2 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026165, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx') / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-06-25 12:39:56 Duration: 3m57s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_modelo_recebimento(6,''1530'') ;', '/var/www/html/tmp/RECEBIMENTO_ATOP - RIO DE JANEIRO_NF_1530.xlsx') / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-06-25 14:20:05 Duration: 6s156ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 4m1s 99 166ms 1m 2s440ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 25 07 7 4s39ms 577ms 08 10 17s115ms 1s711ms 09 20 1m10s 3s516ms 10 10 6s634ms 663ms 11 6 29s92ms 4s848ms 12 6 6s420ms 1s70ms 13 12 4s14ms 334ms 14 4 1s18ms 254ms 15 13 24s72ms 1s851ms 16 6 52s983ms 8s830ms 17 5 25s880ms 5s176ms [ User: intelifix - Total duration: 4m1s - Times executed: 99 ]
[ Application: psql - Total duration: 4m1s - Times executed: 99 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 503); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026123);
Date: 2026-06-25 09:06:12 Duration: 1m Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 503); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026195);
Date: 2026-06-25 16:11:17 Duration: 32s622ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026154);
Date: 2026-06-25 11:27:44 Duration: 20s54ms Database: rio User: intelifix Remote: [local] Application: psql
19 3m36s 18 9s534ms 14s181ms 12s8ms create table temp0000283628 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 25 15 18 3m36s 12s8ms [ User: intelifix - Total duration: 3m36s - Times executed: 18 ]
[ Application: [unknown] - Total duration: 3m36s - Times executed: 18 ]
-
CREATE TABLE temp0000283628 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-25 15:27:29 Duration: 14s181ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283628 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-25 15:07:34 Duration: 13s565ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283628 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-25 15:51:07 Duration: 13s546ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 3m4s 4 5s342ms 1m27s 46s160ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 25 20 2 1m32s 46s237ms 23 2 1m32s 46s83ms [ User: intelifix - Total duration: 3m4s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m4s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-25 20:08:37 Duration: 1m27s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-25 23:37:59 Duration: 1m26s 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-06-25 23:49:43 Duration: 5s351ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,555 20m7s 150ms 5s72ms 776ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 25 08 145 1m31s 632ms 09 204 2m23s 701ms 10 191 2m36s 817ms 11 168 2m36s 933ms 12 98 1m9s 712ms 13 104 1m26s 832ms 14 165 2m4s 753ms 15 196 2m43s 833ms 16 195 2m35s 797ms 17 89 1m 684ms [ User: intelifix - Total duration: 20m7s - Times executed: 1555 ]
[ Application: [unknown] - Total duration: 20m7s - Times executed: 1555 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (256950, 504, 'E44E12B31CB5,ZTE3A8TR7R10829C7D21ED7BD3,ZTE3A8TRCB15028C7D21EFD0B7,ZTE3A8TRCS02229$B47CA60824CE,ZTE3A8TR8U07435C7D21ED6FF3,ZTE3A8TRCB14268EA,ZTE3A8TT3306074$B47CA6082F9A,ZTE3A8TR8U08126$E44E12AF964D,ZTE3A8TR6D04075$E44E1292843B,ZTE3A8TR5U18813E,ZTE3A8TT3306475C7D21ED6FC3,ZTE3A8TRCB14256C7D21EFD1B3,ZTE3A8TRCS02292$E44E12935B4B,ZTE3A8TR6507077C7D21F0B03B,ZTE3A8TRCS16534C7D21EB4A1F,ZTE3A8TRB704579$B47CA60826C6,ZTE3A8TR8U07561C7D21EFACE3,ZTE3A8TRCP25436$B47CA6082B4E,ZTE3A8TR8U07851C7D21EEAC3F,ZTE3A8TRCP09011C7D21EEAC43,ZTE3A8TRCP09012C7D21EEAD2F,ZTE3A8TRCP09071A4788FC,ZTE3A8TR4H06467$E44E12AFA69D,ZTE3A8TR6D05119B292,ZTE3A8TT4703344B16A,ZTE3A8TT4703270B2C6,ZTE3A8TT4703357$E44E12AF76FD,ZTE3A8TR6D02071$E44E12AF76F9,ZTE3A8TR6D02070,ZTE3A8TT3C16872$E44E12AFA955,ZTE3A8TR6D05293D46A,ZTE3A8TT4705510$E44E12AF95F9,ZTE3A8TR6D04054C7D21F0E877,ZTE3A8TRCS20133C7D21EFACB7,ZTE3A8TRCP25425D69A,ZTE3A8TT4705650$E44E129211E7,ZTE3A8TR5U11496$B47CA60863BE,ZTE3A8TR8U11463B0E,ZTE3A8TT3R21195B1FE,ZTE3A8TT4703307$E44E12AFA8C1,ZTE3A8TR6D05256', '',0461,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-25 10:23:12 Duration: 5s72ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (43385, 413, 'ZTE3ANNT3H84994,D831399E8BA4,D831399E8BA5,ZTEGDD331CA1$ZTE3ANNRB710381,5872C98F2C7F,5872C98F2C80,ZTEGDC615360$ZTE3ANNRCB66824,D8313923ED2E,D8313923ED2F,ZTEGDD2ABA9D$ZTE3ANNRC553105,6C11BA67067D,6C11BA67067E,ZTEGDC6EE530$ZTE3ANNR3J30214,F4E84F891284,F4E84F891285,ZTEGD97BD7D0$ZTE3ANNRCB24128,D8313920047E,D8313920047F,ZTEGDD2A13D5$ZTE3ANNRC501485,6C11BA624CA5,6C11BA624CA6,ZTEGDC6E1B8C$ZTE3ANNRCP04067,6C11BA698A21,6C11BA698A22,ZTEGDC6F5076$ZTE3ANNR6R51071,48D6823A31BC,48D6823A31BD,ZTEGDB01F252$ZTE3ANNR7B16817,3891484A76CD,3891484A76CE,ZTEGDB07D311$ZTE3ANNQ9J07881,843C992C89EB,843C992C89EC,ZTEGD7BB2774$ZTE3ANNT3H83335,D831399E64C2,D831399E64C3,ZTEGDD331626$ZTE3ANNR3Y38290,4896D9534224,4896D9534225,ZTEGD97EC647$ZTE3ANNRCP46879,6C11BA6D7589,6C11BA6D758A,ZTEGDC6FF7B2$ZTE3ANNR9F20502,D89A0DA4BE67,D89A0DA4BE68,ZTEGDB157761$ZTE3ANNT2V84660,D83139934F10,D83139934F11,ZTEGDD313D33$ZTE3ANNR3Y01214,4896D94FDD2C,4896D94FDD2D,ZTEGD97E3573$ZTE3ANNT3H44244,D831399AD090,D831399AD091,ZTEGDD327D73$ZTE3ANNR7B33377,3891484BFAED,3891484BFAEE,ZTEGDB0813C1$ZTE3ANNR1Y30992,14CA56CF80DB,14CA56CF80DC,ZTEGD970EF6B$ZTE3ANNQ9J21762,843C992DCF41,843C992DCF42,ZTEGD7BB5DAD$ZTE3ANNQ3R19637,3CF9F0A44C04,3CF9F0A44C05,ZTEGD6404CB4$ZTE3ANNR9W44463,D89A0DAC6E3D,D89A0DAC6E3E,ZTEGDB16BF5A$ZTE3ANNR9W00201,D89A0DA860D9,D89A0DA860DA,ZTEGDB161274$ZTE3ANNT3H44837,D831399ADE76,D831399ADE77,ZTEGDD327FC4$ZTE3ANNR9W03871,D89A0DA8B6DD,D89A0DA8B6DE,ZTEGDB1620CA$ZTE3ANNRC552601,6C11BA66FAAD,6C11BA66FAAE,ZTEGDC6EE338$ZTE3ANNQ4407812,3CF9F0AC15F6,3CF9F0AC15F7,ZTEGD6419907$ZTE3ANNQ6M08360,C4EBFF8925C0,C4EBFF8925C1,ZTEGD70A01B6$ZTE3ANNR7B55539,3891484E0259,3891484E025A,ZTEGDB086A53$ZTE3ANNRAD24215,D89A0DB011ED,D89A0DB011EE,ZTEGDB175AA2$ZTE3ANNRAM42373,5872C98B1957,5872C98B1958,ZTEGDC60A584$ZTE3ANNR4N26707,4896D957CD0A,4896D957CD0B,ZTEGD97F8818$ZTE3ANNT3H01502,D8313996E6CC,D8313996E6CD,ZTEGDD31D67D$ZTE3ANNR9W44791,D89A0DAC75ED,D89A0DAC75EE,ZTEGDB16C0A2$ZTE3ANNR7B33332,3891484BF9DF,3891484BF9E0,ZTEGDB081394$ZTE3ANNR2Q01303,F4E84F80D28A,F4E84F80D28B,ZTEGD97A77D1$ZTE3ANNR8C08909,3891484F57D5,3891484F57D6,ZTEGDB08A33D$ZTE3ANNRAD30063,D89A0DB09AFD,D89A0DB09AFE,ZTEGDB17717A$ZTE3ANNT2V71524,D83139921B30,D83139921B31,ZTEGDD3109E3$ZTE3ANNRC536205,6C11BA657A65,6C11BA657A66,ZTEGDC6EA32C$ZTE3ANNRCP44066,6C11BA6D339B,6C11BA6D339C,219677788789$ZTE3ANNQ9311821,843C9933AA4B,843C9933AA4C,ZTEGD7BBEA24$ZTE3ANNQ9J21695,843C992DCDAF,843C992DCDB0,ZTEGD7BB5D6A', '',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-25 11:00:23 Duration: 4s683ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (43479, 413, '226304298197', '',0172,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-25 15:01:36 Duration: 4s669ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
2 1,147 9m30s 150ms 4s94ms 497ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 25 07 7 4s334ms 619ms 08 87 50s318ms 578ms 09 137 1m9s 510ms 10 149 1m13s 492ms 11 117 57s591ms 492ms 12 12 8s633ms 719ms 13 96 42s692ms 444ms 14 165 1m20s 486ms 15 167 1m16s 457ms 16 178 1m28s 498ms 17 32 17s900ms 559ms [ User: intelifix - Total duration: 9m30s - Times executed: 1147 ]
[ Application: [unknown] - Total duration: 9m30s - Times executed: 1147 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "230007", "modelo" : "320", "itens" : "241649690524,241689163444,241597528181,241708972942,241622554867,241647364561,241669661530,241677356567,241708821940,241637708298,241668192228,241717160105,241713370521,241693221416,241654646674,230048450217,230048424658,241664775665,241692651327,241676807894,241708756781,241646269011,241616232331,241708804665,241677737794,241673135875,241680363337,241717141315,241630184343,241711188286,241704272528,241714893239,241680471732,241654476983,241696821835,241664836681,241593825374,241649180822,241631279512,241602548807,241698752124,230043694062,241713047379,241713739703,241667103042,241596232433,241696841433", "usuario" : "414", "caixa" : "2756829", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-25 16:19:02 Duration: 4s94ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "258707", "modelo" : "320", "itens" : "241658563948,241663213650,241629411530,241675327278,241671546483,241715473251,241650255157,241629893653,241603267193,241698480729,241734211724,241689413446,241715584047,241599580527,241700855561,241693075868,241698482143,241703569192,241661382237,241682571129,241631469508,241638390117,241649527577,241680394350,241691093049,241725877374,241646546770,241691763855,241616811434,241620281335,241637585761,241593423135,241652856982,241610151233,241659635152,241621186686,241679394264,241712591926,241655184258,241621207800,241649640822,241655667896,241709089697,241673411234,241660135459,241628225061,241679605575,241645618991", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-25 15:50:25 Duration: 2s554ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "258259", "modelo" : "263", "itens" : "229910765656,229902352636,229919101723,229893147887,229911855572,229912600303,229899896279,229897073950,229898095576,229910585661,229902425774,229897372442,229892408993,229916321317,229915528399,229898796082,229900710108,229910306767,229910312425,229895383639,229901388388,229918707587,229918909201,229870778891,229919161426,229897780215,229902024646,229893404456,229899142233,229918697586,229898821315,229913242644,229916453855,229896958406,229899229211,229902668301,229871410223,229910064163,229912200107,229918539816,229916205469,229918198693,229896423651,229902644965,229876622841,229901770324,229874075364,229896639508", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-25 08:00:25 Duration: 2s172ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 1,063 7m6s 150ms 2s454ms 401ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 25 09 28 14s114ms 504ms 10 142 40s249ms 283ms 11 64 17s527ms 273ms 13 48 18s789ms 391ms 14 422 3m11s 453ms 15 247 1m44s 422ms 16 112 40s545ms 362ms [ User: intelifix - Total duration: 7m6s - Times executed: 1063 ]
[ Application: [unknown] - Total duration: 7m6s - Times executed: 1063 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"125752","seriais":"241771182223,241762563043,241742841635,241770520509,241775273857,241762525362,241743248699,241765613049,241778774445,241742963442,241775300022,241765608806,241771165678,241778593743,241744171327,241768011117,241767948709,241746657281,241762511422,241739441617,241776850521,241743295674,241764106066,241777832244,241744203653,241777485767,241744200421,241765425454,241764422338,241765416082,241739559002,241762348094,241771254856,241767939112,241778614957,241768082437,241745706874,241740528906,241775325859,241746638693","usuario":"398","observacao":""}');
Date: 2026-06-25 14:55:27 Duration: 2s454ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"125752","seriais":"241737871419,241784603948,241751216570,241784608594,241737942537,241750436483,241780524459,241720499005,241723032945,241753547179,241757294156,241720378487,241754149113,241784467290,241757300218,241780590527,241784695270,241754166869,241722319205,241757263648,241755699006,241705026574,241722391031,241784692745,241750014141,241783259507,241749975170,241722343652,241748961727,241754288699,241734594668,241725796076,241749063151,241736935659,241750363042,241780567493,241751833556,241724328895,241784686784,241784742828","usuario":"398","observacao":""}');
Date: 2026-06-25 15:32:13 Duration: 2s293ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"125752","seriais":"241739682325,241759734652,241742378604,241759640121,241739614866,241759646484,241742349308,241743107496,241764540509,241760824141,241764549802,241764542024,241742243540,241743096283,241743091233,241763970521,241763989007,241760823737,241759644666,241763968803,241759659112,241760873338,241778079797","usuario":"398","observacao":""}');
Date: 2026-06-25 14:46:42 Duration: 2s72ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
4 408 2h32m26s 157ms 5m34s 22s417ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 25 07 18 12m30s 41s687ms 08 31 24m33s 47s544ms 09 49 11m16s 13s796ms 10 47 20m52s 26s651ms 11 42 18m47s 26s847ms 12 23 10m36s 27s661ms 13 30 6m31s 13s60ms 14 19 20s371ms 1s72ms 15 67 34m45s 31s128ms 16 46 8m46s 11s455ms 17 36 3m24s 5s692ms [ User: intelifix - Total duration: 2h32m26s - Times executed: 408 ]
[ Application: [unknown] - Total duration: 2h32m26s - Times executed: 408 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026184, 0433 )', '/var/www/html/tmp/nf_carga_lotes_0433.xlsx');
Date: 2026-06-25 15:27:36 Duration: 5m34s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026157, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-25 11:40:54 Duration: 5m31s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026183, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-25 15:14:46 Duration: 5m23s Database: rio User: intelifix Remote: [local] Application: [unknown]
5 160 20m12s 151ms 2m31s 7s578ms call rs_giga_triagem (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 25 00 7 29s988ms 4s284ms 01 6 17s642ms 2s940ms 02 8 18s71ms 2s258ms 03 7 18s602ms 2s657ms 04 7 19s176ms 2s739ms 05 6 18s897ms 3s149ms 06 7 19s41ms 2s720ms 07 6 2m26s 24s439ms 08 6 2m59s 29s846ms 09 7 31s974ms 4s567ms 10 7 2m45s 23s603ms 11 7 2m24s 20s642ms 12 6 24s429ms 4s71ms 13 8 25s11ms 3s126ms 14 6 25s496ms 4s249ms 15 8 2m53s 21s712ms 16 8 26s9ms 3s251ms 17 7 21s79ms 3s11ms 18 6 20s703ms 3s450ms 19 8 20s954ms 2s619ms 20 7 24s101ms 3s443ms 21 9 21s213ms 2s357ms 22 6 21s28ms 3s504ms [ User: intelifix - Total duration: 20m12s - Times executed: 160 ]
[ Application: psql - Total duration: 20m12s - Times executed: 160 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-25 15:27:39 Duration: 2m31s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-25 08:47:36 Duration: 2m30s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-25 10:17:29 Duration: 2m22s Database: rio User: intelifix Remote: [local] Application: psql
6 144 7m17s 244ms 17s765ms 3s37ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 25 00 6 24s507ms 4s84ms 01 6 8s856ms 1s476ms 02 4 5s547ms 1s386ms 03 5 13s76ms 2s615ms 04 6 13s115ms 2s185ms 05 5 9s8ms 1s801ms 07 5 29s98ms 5s819ms 08 10 43s655ms 4s365ms 09 10 42s652ms 4s265ms 10 12 44s992ms 3s749ms 11 12 41s819ms 3s484ms 12 11 36s495ms 3s317ms 13 8 7s402ms 925ms 14 10 34s176ms 3s417ms 15 12 39s773ms 3s314ms 16 9 21s612ms 2s401ms 17 3 2s695ms 898ms 21 4 8s433ms 2s108ms 22 6 10s425ms 1s737ms [ User: intelifix - Total duration: 7m17s - Times executed: 144 ]
[ Application: psql - Total duration: 7m17s - Times executed: 144 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-25 00:05:18 Duration: 17s765ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-25 12:25:11 Duration: 9s565ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-25 15:35:09 Duration: 8s606ms Database: rio User: intelifix Remote: [local] Application: psql
7 144 58s64ms 218ms 812ms 403ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 25 07 4 1s296ms 324ms 08 9 3s633ms 403ms 09 23 8s994ms 391ms 10 22 9s324ms 423ms 11 10 4s171ms 417ms 12 10 4s20ms 402ms 13 9 3s712ms 412ms 14 11 4s956ms 450ms 15 22 8s772ms 398ms 16 12 5s220ms 435ms 17 12 3s959ms 329ms [ User: intelifix - Total duration: 58s64ms - Times executed: 144 ]
[ Application: [unknown] - Total duration: 58s64ms - Times executed: 144 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-06-25 16:21:15 Duration: 812ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-06-25 10:37:49 Duration: 651ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-06-25 11:48:17 Duration: 647ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 143 25s483ms 150ms 290ms 178ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 25 00 1 253ms 253ms 05 1 168ms 168ms 07 1 170ms 170ms 09 1 166ms 166ms 10 3 507ms 169ms 11 11 1s903ms 173ms 12 8 1s375ms 171ms 13 6 1s79ms 179ms 14 12 2s145ms 178ms 15 28 4s945ms 176ms 16 46 7s962ms 173ms 17 25 4s805ms 192ms [ User: intelifix - Total duration: 25s483ms - Times executed: 143 ]
[ Application: [unknown] - Total duration: 25s483ms - Times executed: 143 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "432", "data-de" : "2026-06-25", "data-ate" : "2026-06-25", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 503 }');
Date: 2026-06-25 17:10:00 Duration: 290ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "395", "data-de" : "2026-06-25", "data-ate" : "2026-06-25", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 449 }');
Date: 2026-06-25 15:32:38 Duration: 270ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "307", "data-de" : "2026-06-25", "data-ate" : "2026-06-25", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 304 }');
Date: 2026-06-25 17:13:57 Duration: 266ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 118 54s277ms 271ms 795ms 459ms select pro_id, pgp_sym_decrypt(nome, ?)::varchar, pgp_sym_decrypt(descricao, ?)::varchar, pgp_sym_decrypt(classe, ?)::varchar, pgp_sym_decrypt(php, ?)::varchar, pgp_sym_decrypt(extras, ?)::varchar from progs order by pro_id;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 25 00 2 997ms 498ms 02 1 385ms 385ms 04 2 703ms 351ms 05 2 731ms 365ms 06 1 361ms 361ms 07 7 2s825ms 403ms 08 12 5s174ms 431ms 09 10 5s93ms 509ms 10 14 6s981ms 498ms 11 10 4s659ms 465ms 12 4 1s584ms 396ms 13 11 4s939ms 449ms 14 10 4s640ms 464ms 15 11 5s430ms 493ms 16 10 4s534ms 453ms 17 7 3s449ms 492ms 21 1 471ms 471ms 22 2 873ms 436ms 23 1 438ms 438ms [ User: lenon - Total duration: 54s277ms - Times executed: 118 ]
[ Application: [unknown] - Total duration: 54s277ms - Times executed: 118 ]
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-06-25 10:05:07 Duration: 795ms 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-06-25 11:06:21 Duration: 766ms 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-06-25 08:25:48 Duration: 749ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
10 111 1m2s 317ms 917ms 566ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 25 00 2 1s332ms 666ms 02 1 534ms 534ms 04 2 918ms 459ms 05 2 880ms 440ms 07 6 3s52ms 508ms 08 12 6s310ms 525ms 09 9 5s411ms 601ms 10 13 7s793ms 599ms 11 9 5s370ms 596ms 12 4 1s914ms 478ms 13 11 6s234ms 566ms 14 10 5s748ms 574ms 15 10 5s866ms 586ms 16 10 5s549ms 554ms 17 7 4s206ms 600ms 22 2 1s102ms 551ms 23 1 680ms 680ms [ User: intelifix - Total duration: 1m2s - Times executed: 111 ]
[ Application: [unknown] - Total duration: 1m2s - Times executed: 111 ]
-
select * from rs_menu_grants (397, 18, 1);
Date: 2026-06-25 13:50:43 Duration: 917ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (449, 18, 1);
Date: 2026-06-25 10:05:07 Duration: 899ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (404, 18, 1);
Date: 2026-06-25 11:06:21 Duration: 845ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 105 2m2s 152ms 16s218ms 1s163ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 25 07 10 5s957ms 595ms 08 9 11s941ms 1s326ms 09 1 7s28ms 7s28ms 10 5 3s942ms 788ms 11 16 8s464ms 529ms 13 9 5s416ms 601ms 14 1 1s212ms 1s212ms 15 23 27s986ms 1s216ms 16 18 9s834ms 546ms 17 13 40s393ms 3s107ms [ User: intelifix - Total duration: 2m2s - Times executed: 105 ]
[ Application: [unknown] - Total duration: 2m2s - Times executed: 105 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0125752) LIMIT 1;
Date: 2026-06-25 15:44:57 Duration: 16s218ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (042960) LIMIT 1;
Date: 2026-06-25 17:07:46 Duration: 14s589ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (042959) LIMIT 1;
Date: 2026-06-25 08:40:41 Duration: 8s217ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
12 100 20m47s 1s174ms 53s205ms 12s470ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 25 08 9 1m20s 8s974ms 09 8 2m44s 20s503ms 10 7 1m37s 13s869ms 11 10 1m47s 10s703ms 12 5 14s704ms 2s940ms 13 7 1m40s 14s400ms 14 9 1m52s 12s522ms 15 15 2m52s 11s516ms 16 18 3m55s 13s86ms 17 12 2m41s 13s465ms [ User: intelifix - Total duration: 20m47s - Times executed: 100 ]
[ Application: [unknown] - Total duration: 20m47s - Times executed: 100 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-25', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-25 08:43:01 Duration: 53s205ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-25', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-25 09:42:36 Duration: 44s649ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-25', 0175, '', '', 0, 6, '2026-06-01');
Date: 2026-06-25 15:21:04 Duration: 44s294ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 99 4m1s 166ms 1m 2s440ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 25 07 7 4s39ms 577ms 08 10 17s115ms 1s711ms 09 20 1m10s 3s516ms 10 10 6s634ms 663ms 11 6 29s92ms 4s848ms 12 6 6s420ms 1s70ms 13 12 4s14ms 334ms 14 4 1s18ms 254ms 15 13 24s72ms 1s851ms 16 6 52s983ms 8s830ms 17 5 25s880ms 5s176ms [ User: intelifix - Total duration: 4m1s - Times executed: 99 ]
[ Application: psql - Total duration: 4m1s - Times executed: 99 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 503); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026123);
Date: 2026-06-25 09:06:12 Duration: 1m Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 503); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026195);
Date: 2026-06-25 16:11:17 Duration: 32s622ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026154);
Date: 2026-06-25 11:27:44 Duration: 20s54ms Database: rio User: intelifix Remote: [local] Application: psql
14 92 28s709ms 155ms 4s975ms 312ms create table temp0000283556 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 25 08 2 8s564ms 4s282ms 09 1 158ms 158ms 10 9 2s525ms 280ms 11 18 3s703ms 205ms 12 12 2s314ms 192ms 13 2 401ms 200ms 14 15 3s686ms 245ms 15 13 3s219ms 247ms 16 17 3s456ms 203ms 17 3 679ms 226ms [ User: intelifix - Total duration: 28s709ms - Times executed: 92 ]
[ Application: [unknown] - Total duration: 28s709ms - Times executed: 92 ]
-
CREATE TABLE temp0000283556 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"20-06-2026", "ate" :"25-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-25 08:49:34 Duration: 4s975ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283556 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"20-06-2026", "ate" :"25-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-25 08:02:23 Duration: 3s589ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283556 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"20-06-2026", "ate" :"25-06-2026", "nota-fiscal":"783", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-25 10:27:04 Duration: 678ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 91 14s862ms 150ms 213ms 163ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 25 07 1 203ms 203ms 08 3 492ms 164ms 09 7 1s214ms 173ms 10 5 792ms 158ms 11 12 1s911ms 159ms 12 2 327ms 163ms 13 5 841ms 168ms 14 20 3s228ms 161ms 15 17 2s691ms 158ms 16 14 2s351ms 167ms 17 5 807ms 161ms [ User: intelifix - Total duration: 14s862ms - Times executed: 91 ]
[ Application: [unknown] - Total duration: 14s862ms - Times executed: 91 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-06-25 16:33:13 Duration: 213ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-06-25 07:10:46 Duration: 203ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-06-25 13:15:46 Duration: 201ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 90 17m10s 8s922ms 29s783ms 11s448ms create table temp0000283548 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 25 07 18 3m20s 11s148ms 08 22 4m12s 11s487ms 09 5 57s380ms 11s476ms 10 21 4m4s 11s631ms 11 12 2m30s 12s537ms 12 12 2m4s 10s407ms [ User: intelifix - Total duration: 17m10s - Times executed: 90 ]
[ Application: [unknown] - Total duration: 17m10s - Times executed: 90 ]
-
CREATE TABLE temp0000283548 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-25 07:11:37 Duration: 29s783ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283548 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-25 11:50:40 Duration: 14s455ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283548 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-25 11:52:05 Duration: 14s169ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 90 19s702ms 152ms 617ms 218ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 25 00 7 2s251ms 321ms 04 8 1s888ms 236ms 05 14 3s710ms 265ms 07 8 1s598ms 199ms 08 8 1s837ms 229ms 09 8 1s363ms 170ms 10 5 895ms 179ms 11 7 1s371ms 195ms 12 4 664ms 166ms 14 5 927ms 185ms 15 14 2s742ms 195ms 16 2 451ms 225ms [ User: intelifix - Total duration: 19s702ms - Times executed: 90 ]
[ Application: [unknown] - Total duration: 19s702ms - Times executed: 90 ]
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '229848230508,229845216565,229842522532,229839025759,229845692426,229856584555,229855934458,229852631723,229841876778,229852177076,229843038193,229856170217,229851803550,229845465355,229854345874,229862213657,229839013435,229842349911,229856382538,229855983655,229841021028,229852701326,229848266369,229842067784,229855596265,229838799395,229842400321,229846495568,229852740825,229838578790,229839580113,229854418686,229861791618,229843454149,229855624551,229862039699,229853753134,229852335072,229853560411,229856046769,229853225776,229847994749,229847546871,229839019596,229862060309,229840465664', NULL, NULL, 0160, 00);
Date: 2026-06-25 00:37:01 Duration: 617ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (404, 5, '113', 3, '216896870828,229724242122,216888668084,229647978797,229718639005,216917925059,216948540012,229725009705,216947752325,216903923143,229721530814', NULL, NULL, 0131, 00);
Date: 2026-06-25 08:46:54 Duration: 453ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (429, 5, '113', 3, '229910614957,229900099913,229913467390,229911372641,229916498607,229892417075,229912626567,229899395265,229896946889,229918707587,229918909201,229870778891,229900539204,229910631222', NULL, NULL, 0263, 00);
Date: 2026-06-25 04:59:39 Duration: 449ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 67 41s86ms 197ms 4s378ms 613ms create table temp0000283600 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 25 13 12 15s721ms 1s310ms 14 9 7s75ms 786ms 15 27 10s558ms 391ms 16 11 4s710ms 428ms 17 8 3s20ms 377ms [ User: intelifix - Total duration: 41s86ms - Times executed: 67 ]
[ Application: [unknown] - Total duration: 41s86ms - Times executed: 67 ]
-
CREATE TABLE temp0000283600 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"20-06-2026", "ate" :"25-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-25 13:34:14 Duration: 4s378ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283600 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"20-06-2026", "ate" :"25-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-25 13:34:18 Duration: 4s126ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283600 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"20-06-2026", "ate" :"25-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-25 14:18:08 Duration: 3s911ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 63 21s947ms 187ms 834ms 348ms create table temp0000283420 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 25 08 1 259ms 259ms 10 11 4s432ms 402ms 11 16 5s830ms 364ms 12 11 3s879ms 352ms 13 5 1s669ms 333ms 14 5 1s966ms 393ms 15 2 795ms 397ms 16 12 3s113ms 259ms [ User: intelifix - Total duration: 21s947ms - Times executed: 63 ]
[ Application: [unknown] - Total duration: 21s947ms - Times executed: 63 ]
-
CREATE TABLE temp0000283420 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"20-06-2026", "ate" :"25-06-2026", "nota-fiscal":"64739", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-25 16:26:29 Duration: 834ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283420 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"20-06-2026", "ate" :"25-06-2026", "nota-fiscal":"80242", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-25 10:18:25 Duration: 732ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283420 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"20-06-2026", "ate" :"25-06-2026", "nota-fiscal":"80242", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-25 11:47:52 Duration: 515ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 62 11s972ms 150ms 293ms 193ms create table temp0000226464 as select * from rs_caixas_lista (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 25 08 4 836ms 209ms 09 15 2s819ms 187ms 10 4 805ms 201ms 11 16 2s797ms 174ms 13 4 698ms 174ms 14 5 1s57ms 211ms 15 4 817ms 204ms 16 10 2s138ms 213ms [ User: intelifix - Total duration: 11s972ms - Times executed: 62 ]
[ Application: [unknown] - Total duration: 11s972ms - Times executed: 62 ]
-
CREATE TABLE temp0000226464 AS SELECT * FROM RS_CAIXAS_LISTA (42321);
Date: 2026-06-25 09:26:25 Duration: 293ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000226464 AS SELECT * FROM RS_CAIXAS_LISTA (42044);
Date: 2026-06-25 10:16:17 Duration: 286ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000226464 AS SELECT * FROM RS_CAIXAS_LISTA (42044);
Date: 2026-06-25 08:17:14 Duration: 284ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 5m56s 5m56s 5m56s 1 5m56s select * from rs_smart_fiscal_entrada () notice: table "tmp_entrada" does not exist, skipping;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 25 08 1 5m56s 5m56s [ User: intelifix - Total duration: 5m56s - Times executed: 1 ]
[ Application: psql - Total duration: 5m56s - Times executed: 1 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA () NOTICE: table "tmp_entrada" does not exist, skipping;
Date: 2026-06-25 08:10:57 Duration: 5m56s Database: rio User: intelifix Remote: [local] Application: psql
2 2m35s 8m49s 5m13s 3 15m41s analyze verbose;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 25 05 3 15m41s 5m13s [ User: intelifix - Total duration: 15m41s - Times executed: 3 ]
[ Application: psql - Total duration: 15m41s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-06-25 05:08:51 Duration: 8m49s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-25 05:13:07 Duration: 4m15s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-25 05:15:43 Duration: 2m35s Database: contagem User: intelifix Remote: [local] Application: psql
3 1s200ms 8m37s 2m28s 47 1h56m37s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 25 07 3 8m17s 2m45s 08 2 19s431ms 9s715ms 09 3 9m12s 3m4s 10 3 9m14s 3m4s 11 3 9m23s 3m7s 12 3 8m36s 2m52s 13 3 7m42s 2m34s 14 3 7m43s 2m34s 15 3 8m23s 2m47s 16 3 7m48s 2m36s 17 3 8m9s 2m43s 18 3 6m36s 2m12s 19 3 6m4s 2m1s 20 3 6m31s 2m10s 21 3 6m20s 2m6s 22 3 6m12s 2m4s [ User: intelifix - Total duration: 1h56m37s - Times executed: 47 ]
[ Application: psql - Total duration: 1h56m37s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-25 10:13:38 Duration: 8m37s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-25 11:13:36 Duration: 8m34s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-25 09:13:36 Duration: 8m34s Database: rio User: intelifix Remote: [local] Application: psql
4 6s156ms 3m57s 2m1s 2 4m3s 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 (;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 25 12 1 3m57s 3m57s 14 1 6s156ms 6s156ms [ User: intelifix - Total duration: 4m3s - Times executed: 2 ]
[ Application: [unknown] - Total duration: 4m3s - Times executed: 2 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026165, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx') / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-06-25 12:39:56 Duration: 3m57s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_modelo_recebimento(6,''1530'') ;', '/var/www/html/tmp/RECEBIMENTO_ATOP - RIO DE JANEIRO_NF_1530.xlsx') / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-06-25 14:20:05 Duration: 6s156ms Database: rio User: intelifix Remote: [local] Application: [unknown]
5 195ms 4m42s 1m30s 48 1h12m16s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 25 07 3 4m24s 1m28s 08 3 4m5s 1m21s 09 3 5m9s 1m43s 10 3 5m9s 1m43s 11 3 5m19s 1m46s 12 3 4m48s 1m36s 13 3 4m46s 1m35s 14 3 4m23s 1m27s 15 3 5m30s 1m50s 16 3 4m35s 1m31s 17 3 4m27s 1m29s 18 3 3m53s 1m17s 19 3 3m44s 1m14s 20 3 4m17s 1m25s 21 3 3m51s 1m17s 22 3 3m48s 1m16s [ User: intelifix - Total duration: 1h12m16s - Times executed: 48 ]
[ Application: psql - Total duration: 1h12m16s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-25 15:18:50 Duration: 4m42s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-25 11:19:27 Duration: 4m32s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-25 10:19:17 Duration: 4m19s Database: brasilia User: intelifix Remote: [local] Application: psql
6 5s342ms 1m27s 46s160ms 4 3m4s 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 Jun 25 20 2 1m32s 46s237ms 23 2 1m32s 46s83ms [ User: intelifix - Total duration: 3m4s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m4s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-25 20:08:37 Duration: 1m27s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-25 23:37:59 Duration: 1m26s 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-06-25 23:49:43 Duration: 5s351ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 157ms 5m34s 22s417ms 408 2h32m26s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 25 07 18 12m30s 41s687ms 08 31 24m33s 47s544ms 09 49 11m16s 13s796ms 10 47 20m52s 26s651ms 11 42 18m47s 26s847ms 12 23 10m36s 27s661ms 13 30 6m31s 13s60ms 14 19 20s371ms 1s72ms 15 67 34m45s 31s128ms 16 46 8m46s 11s455ms 17 36 3m24s 5s692ms [ User: intelifix - Total duration: 2h32m26s - Times executed: 408 ]
[ Application: [unknown] - Total duration: 2h32m26s - Times executed: 408 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026184, 0433 )', '/var/www/html/tmp/nf_carga_lotes_0433.xlsx');
Date: 2026-06-25 15:27:36 Duration: 5m34s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026157, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-25 11:40:54 Duration: 5m31s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026183, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-25 15:14:46 Duration: 5m23s Database: rio User: intelifix Remote: [local] Application: [unknown]
8 1s174ms 53s205ms 12s470ms 100 20m47s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 25 08 9 1m20s 8s974ms 09 8 2m44s 20s503ms 10 7 1m37s 13s869ms 11 10 1m47s 10s703ms 12 5 14s704ms 2s940ms 13 7 1m40s 14s400ms 14 9 1m52s 12s522ms 15 15 2m52s 11s516ms 16 18 3m55s 13s86ms 17 12 2m41s 13s465ms [ User: intelifix - Total duration: 20m47s - Times executed: 100 ]
[ Application: [unknown] - Total duration: 20m47s - Times executed: 100 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-25', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-25 08:43:01 Duration: 53s205ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-25', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-25 09:42:36 Duration: 44s649ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-25', 0175, '', '', 0, 6, '2026-06-01');
Date: 2026-06-25 15:21:04 Duration: 44s294ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 9s534ms 14s181ms 12s8ms 18 3m36s create table temp0000283628 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 25 15 18 3m36s 12s8ms [ User: intelifix - Total duration: 3m36s - Times executed: 18 ]
[ Application: [unknown] - Total duration: 3m36s - Times executed: 18 ]
-
CREATE TABLE temp0000283628 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-25 15:27:29 Duration: 14s181ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283628 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-25 15:07:34 Duration: 13s565ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283628 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-25 15:51:07 Duration: 13s546ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 9s403ms 13s594ms 11s646ms 40 7m45s create table temp0000283558 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 25 08 6 1m3s 10s527ms 09 4 47s145ms 11s786ms 10 14 2m45s 11s790ms 11 9 1m50s 12s280ms 12 7 1m19s 11s422ms [ User: intelifix - Total duration: 7m45s - Times executed: 40 ]
[ Application: [unknown] - Total duration: 7m45s - Times executed: 40 ]
-
CREATE TABLE temp0000283558 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-25 11:24:23 Duration: 13s594ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283558 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-25 10:43:44 Duration: 13s571ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283558 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-25 09:06:47 Duration: 13s389ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 9s831ms 14s302ms 11s485ms 32 6m7s create table temp0000283570 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 25 09 32 6m7s 11s485ms [ User: intelifix - Total duration: 6m7s - Times executed: 32 ]
[ Application: [unknown] - Total duration: 6m7s - Times executed: 32 ]
-
CREATE TABLE temp0000283570 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-25 09:28:33 Duration: 14s302ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283570 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-25 09:34:28 Duration: 13s334ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283570 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-25 09:28:05 Duration: 12s858ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 8s922ms 29s783ms 11s448ms 90 17m10s create table temp0000283548 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 25 07 18 3m20s 11s148ms 08 22 4m12s 11s487ms 09 5 57s380ms 11s476ms 10 21 4m4s 11s631ms 11 12 2m30s 12s537ms 12 12 2m4s 10s407ms [ User: intelifix - Total duration: 17m10s - Times executed: 90 ]
[ Application: [unknown] - Total duration: 17m10s - Times executed: 90 ]
-
CREATE TABLE temp0000283548 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-25 07:11:37 Duration: 29s783ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283548 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-25 11:50:40 Duration: 14s455ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283548 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-25 11:52:05 Duration: 14s169ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 9s446ms 14s854ms 11s419ms 46 8m45s create table temp0000283608 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 25 13 2 21s498ms 10s749ms 15 19 3m42s 11s714ms 16 20 3m44s 11s243ms 17 5 56s336ms 11s267ms [ User: intelifix - Total duration: 8m45s - Times executed: 46 ]
[ Application: [unknown] - Total duration: 8m45s - Times executed: 46 ]
-
CREATE TABLE temp0000283608 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-25 15:47:22 Duration: 14s854ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283608 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-25 15:33:42 Duration: 14s206ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283608 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-25 16:42:04 Duration: 13s375ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 8s927ms 21s635ms 11s391ms 27 5m7s create table temp0000283596 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 25 13 17 3m21s 11s826ms 14 10 1m46s 10s653ms [ User: intelifix - Total duration: 5m7s - Times executed: 27 ]
[ Application: [unknown] - Total duration: 5m7s - Times executed: 27 ]
-
CREATE TABLE temp0000283596 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-25 13:33:15 Duration: 21s635ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283596 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-25 14:26:28 Duration: 13s604ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283596 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-25 13:52:28 Duration: 13s500ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 151ms 2m31s 7s578ms 160 20m12s call rs_giga_triagem (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 25 00 7 29s988ms 4s284ms 01 6 17s642ms 2s940ms 02 8 18s71ms 2s258ms 03 7 18s602ms 2s657ms 04 7 19s176ms 2s739ms 05 6 18s897ms 3s149ms 06 7 19s41ms 2s720ms 07 6 2m26s 24s439ms 08 6 2m59s 29s846ms 09 7 31s974ms 4s567ms 10 7 2m45s 23s603ms 11 7 2m24s 20s642ms 12 6 24s429ms 4s71ms 13 8 25s11ms 3s126ms 14 6 25s496ms 4s249ms 15 8 2m53s 21s712ms 16 8 26s9ms 3s251ms 17 7 21s79ms 3s11ms 18 6 20s703ms 3s450ms 19 8 20s954ms 2s619ms 20 7 24s101ms 3s443ms 21 9 21s213ms 2s357ms 22 6 21s28ms 3s504ms [ User: intelifix - Total duration: 20m12s - Times executed: 160 ]
[ Application: psql - Total duration: 20m12s - Times executed: 160 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-25 15:27:39 Duration: 2m31s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-25 08:47:36 Duration: 2m30s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-25 10:17:29 Duration: 2m22s Database: rio User: intelifix Remote: [local] Application: psql
16 244ms 17s765ms 3s37ms 144 7m17s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 25 00 6 24s507ms 4s84ms 01 6 8s856ms 1s476ms 02 4 5s547ms 1s386ms 03 5 13s76ms 2s615ms 04 6 13s115ms 2s185ms 05 5 9s8ms 1s801ms 07 5 29s98ms 5s819ms 08 10 43s655ms 4s365ms 09 10 42s652ms 4s265ms 10 12 44s992ms 3s749ms 11 12 41s819ms 3s484ms 12 11 36s495ms 3s317ms 13 8 7s402ms 925ms 14 10 34s176ms 3s417ms 15 12 39s773ms 3s314ms 16 9 21s612ms 2s401ms 17 3 2s695ms 898ms 21 4 8s433ms 2s108ms 22 6 10s425ms 1s737ms [ User: intelifix - Total duration: 7m17s - Times executed: 144 ]
[ Application: psql - Total duration: 7m17s - Times executed: 144 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-25 00:05:18 Duration: 17s765ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-25 12:25:11 Duration: 9s565ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-25 15:35:09 Duration: 8s606ms Database: rio User: intelifix Remote: [local] Application: psql
17 166ms 1m 2s440ms 99 4m1s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 25 07 7 4s39ms 577ms 08 10 17s115ms 1s711ms 09 20 1m10s 3s516ms 10 10 6s634ms 663ms 11 6 29s92ms 4s848ms 12 6 6s420ms 1s70ms 13 12 4s14ms 334ms 14 4 1s18ms 254ms 15 13 24s72ms 1s851ms 16 6 52s983ms 8s830ms 17 5 25s880ms 5s176ms [ User: intelifix - Total duration: 4m1s - Times executed: 99 ]
[ Application: psql - Total duration: 4m1s - Times executed: 99 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 503); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026123);
Date: 2026-06-25 09:06:12 Duration: 1m Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 503); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026195);
Date: 2026-06-25 16:11:17 Duration: 32s622ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026154);
Date: 2026-06-25 11:27:44 Duration: 20s54ms Database: rio User: intelifix Remote: [local] Application: psql
18 152ms 16s218ms 1s163ms 105 2m2s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 25 07 10 5s957ms 595ms 08 9 11s941ms 1s326ms 09 1 7s28ms 7s28ms 10 5 3s942ms 788ms 11 16 8s464ms 529ms 13 9 5s416ms 601ms 14 1 1s212ms 1s212ms 15 23 27s986ms 1s216ms 16 18 9s834ms 546ms 17 13 40s393ms 3s107ms [ User: intelifix - Total duration: 2m2s - Times executed: 105 ]
[ Application: [unknown] - Total duration: 2m2s - Times executed: 105 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0125752) LIMIT 1;
Date: 2026-06-25 15:44:57 Duration: 16s218ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (042960) LIMIT 1;
Date: 2026-06-25 17:07:46 Duration: 14s589ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (042959) LIMIT 1;
Date: 2026-06-25 08:40:41 Duration: 8s217ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
19 150ms 5s72ms 776ms 1,555 20m7s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 25 08 145 1m31s 632ms 09 204 2m23s 701ms 10 191 2m36s 817ms 11 168 2m36s 933ms 12 98 1m9s 712ms 13 104 1m26s 832ms 14 165 2m4s 753ms 15 196 2m43s 833ms 16 195 2m35s 797ms 17 89 1m 684ms [ User: intelifix - Total duration: 20m7s - Times executed: 1555 ]
[ Application: [unknown] - Total duration: 20m7s - Times executed: 1555 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (256950, 504, 'E44E12B31CB5,ZTE3A8TR7R10829C7D21ED7BD3,ZTE3A8TRCB15028C7D21EFD0B7,ZTE3A8TRCS02229$B47CA60824CE,ZTE3A8TR8U07435C7D21ED6FF3,ZTE3A8TRCB14268EA,ZTE3A8TT3306074$B47CA6082F9A,ZTE3A8TR8U08126$E44E12AF964D,ZTE3A8TR6D04075$E44E1292843B,ZTE3A8TR5U18813E,ZTE3A8TT3306475C7D21ED6FC3,ZTE3A8TRCB14256C7D21EFD1B3,ZTE3A8TRCS02292$E44E12935B4B,ZTE3A8TR6507077C7D21F0B03B,ZTE3A8TRCS16534C7D21EB4A1F,ZTE3A8TRB704579$B47CA60826C6,ZTE3A8TR8U07561C7D21EFACE3,ZTE3A8TRCP25436$B47CA6082B4E,ZTE3A8TR8U07851C7D21EEAC3F,ZTE3A8TRCP09011C7D21EEAC43,ZTE3A8TRCP09012C7D21EEAD2F,ZTE3A8TRCP09071A4788FC,ZTE3A8TR4H06467$E44E12AFA69D,ZTE3A8TR6D05119B292,ZTE3A8TT4703344B16A,ZTE3A8TT4703270B2C6,ZTE3A8TT4703357$E44E12AF76FD,ZTE3A8TR6D02071$E44E12AF76F9,ZTE3A8TR6D02070,ZTE3A8TT3C16872$E44E12AFA955,ZTE3A8TR6D05293D46A,ZTE3A8TT4705510$E44E12AF95F9,ZTE3A8TR6D04054C7D21F0E877,ZTE3A8TRCS20133C7D21EFACB7,ZTE3A8TRCP25425D69A,ZTE3A8TT4705650$E44E129211E7,ZTE3A8TR5U11496$B47CA60863BE,ZTE3A8TR8U11463B0E,ZTE3A8TT3R21195B1FE,ZTE3A8TT4703307$E44E12AFA8C1,ZTE3A8TR6D05256', '',0461,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-25 10:23:12 Duration: 5s72ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (43385, 413, 'ZTE3ANNT3H84994,D831399E8BA4,D831399E8BA5,ZTEGDD331CA1$ZTE3ANNRB710381,5872C98F2C7F,5872C98F2C80,ZTEGDC615360$ZTE3ANNRCB66824,D8313923ED2E,D8313923ED2F,ZTEGDD2ABA9D$ZTE3ANNRC553105,6C11BA67067D,6C11BA67067E,ZTEGDC6EE530$ZTE3ANNR3J30214,F4E84F891284,F4E84F891285,ZTEGD97BD7D0$ZTE3ANNRCB24128,D8313920047E,D8313920047F,ZTEGDD2A13D5$ZTE3ANNRC501485,6C11BA624CA5,6C11BA624CA6,ZTEGDC6E1B8C$ZTE3ANNRCP04067,6C11BA698A21,6C11BA698A22,ZTEGDC6F5076$ZTE3ANNR6R51071,48D6823A31BC,48D6823A31BD,ZTEGDB01F252$ZTE3ANNR7B16817,3891484A76CD,3891484A76CE,ZTEGDB07D311$ZTE3ANNQ9J07881,843C992C89EB,843C992C89EC,ZTEGD7BB2774$ZTE3ANNT3H83335,D831399E64C2,D831399E64C3,ZTEGDD331626$ZTE3ANNR3Y38290,4896D9534224,4896D9534225,ZTEGD97EC647$ZTE3ANNRCP46879,6C11BA6D7589,6C11BA6D758A,ZTEGDC6FF7B2$ZTE3ANNR9F20502,D89A0DA4BE67,D89A0DA4BE68,ZTEGDB157761$ZTE3ANNT2V84660,D83139934F10,D83139934F11,ZTEGDD313D33$ZTE3ANNR3Y01214,4896D94FDD2C,4896D94FDD2D,ZTEGD97E3573$ZTE3ANNT3H44244,D831399AD090,D831399AD091,ZTEGDD327D73$ZTE3ANNR7B33377,3891484BFAED,3891484BFAEE,ZTEGDB0813C1$ZTE3ANNR1Y30992,14CA56CF80DB,14CA56CF80DC,ZTEGD970EF6B$ZTE3ANNQ9J21762,843C992DCF41,843C992DCF42,ZTEGD7BB5DAD$ZTE3ANNQ3R19637,3CF9F0A44C04,3CF9F0A44C05,ZTEGD6404CB4$ZTE3ANNR9W44463,D89A0DAC6E3D,D89A0DAC6E3E,ZTEGDB16BF5A$ZTE3ANNR9W00201,D89A0DA860D9,D89A0DA860DA,ZTEGDB161274$ZTE3ANNT3H44837,D831399ADE76,D831399ADE77,ZTEGDD327FC4$ZTE3ANNR9W03871,D89A0DA8B6DD,D89A0DA8B6DE,ZTEGDB1620CA$ZTE3ANNRC552601,6C11BA66FAAD,6C11BA66FAAE,ZTEGDC6EE338$ZTE3ANNQ4407812,3CF9F0AC15F6,3CF9F0AC15F7,ZTEGD6419907$ZTE3ANNQ6M08360,C4EBFF8925C0,C4EBFF8925C1,ZTEGD70A01B6$ZTE3ANNR7B55539,3891484E0259,3891484E025A,ZTEGDB086A53$ZTE3ANNRAD24215,D89A0DB011ED,D89A0DB011EE,ZTEGDB175AA2$ZTE3ANNRAM42373,5872C98B1957,5872C98B1958,ZTEGDC60A584$ZTE3ANNR4N26707,4896D957CD0A,4896D957CD0B,ZTEGD97F8818$ZTE3ANNT3H01502,D8313996E6CC,D8313996E6CD,ZTEGDD31D67D$ZTE3ANNR9W44791,D89A0DAC75ED,D89A0DAC75EE,ZTEGDB16C0A2$ZTE3ANNR7B33332,3891484BF9DF,3891484BF9E0,ZTEGDB081394$ZTE3ANNR2Q01303,F4E84F80D28A,F4E84F80D28B,ZTEGD97A77D1$ZTE3ANNR8C08909,3891484F57D5,3891484F57D6,ZTEGDB08A33D$ZTE3ANNRAD30063,D89A0DB09AFD,D89A0DB09AFE,ZTEGDB17717A$ZTE3ANNT2V71524,D83139921B30,D83139921B31,ZTEGDD3109E3$ZTE3ANNRC536205,6C11BA657A65,6C11BA657A66,ZTEGDC6EA32C$ZTE3ANNRCP44066,6C11BA6D339B,6C11BA6D339C,219677788789$ZTE3ANNQ9311821,843C9933AA4B,843C9933AA4C,ZTEGD7BBEA24$ZTE3ANNQ9J21695,843C992DCDAF,843C992DCDB0,ZTEGD7BB5D6A', '',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-25 11:00:23 Duration: 4s683ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (43479, 413, '226304298197', '',0172,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-25 15:01:36 Duration: 4s669ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
20 197ms 4s378ms 613ms 67 41s86ms create table temp0000283600 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 25 13 12 15s721ms 1s310ms 14 9 7s75ms 786ms 15 27 10s558ms 391ms 16 11 4s710ms 428ms 17 8 3s20ms 377ms [ User: intelifix - Total duration: 41s86ms - Times executed: 67 ]
[ Application: [unknown] - Total duration: 41s86ms - Times executed: 67 ]
-
CREATE TABLE temp0000283600 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"20-06-2026", "ate" :"25-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-25 13:34:14 Duration: 4s378ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283600 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"20-06-2026", "ate" :"25-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-25 13:34:18 Duration: 4s126ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283600 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"20-06-2026", "ate" :"25-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-25 14:18:08 Duration: 3s911ms 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 Jun 25 10 1 0ms 0ms 15 1 0ms 0ms 19 1 0ms 0ms 20 2 0ms 0ms [ User: intelifix - Total duration: 6m9s - Times executed: 4 ]
[ User: lenon - Total duration: 288ms - Times executed: 1 ]
[ Application: psql - Total duration: 6m8s - Times executed: 3 ]
[ Application: [unknown] - Total duration: 732ms - Times executed: 2 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 22,664 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 21 FATAL entries
- 5048 ERROR entries
- 0 WARNING entries
- 23 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 4,822 Max number of times the same event was reported
- 5,092 Total events found
Rank Times reported Error 1 4,822 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jun 25 00 59 01 59 02 58 03 51 04 58 05 59 06 73 07 199 08 312 09 378 10 429 11 424 12 296 13 187 14 486 15 580 16 484 17 195 18 116 19 84 20 59 21 60 22 58 23 58 - ERROR: prepared statement "_PLAN0000000029EED600" does not exist
- ERROR: prepared statement "_PLAN0000000029E7A3E0" does not exist
- ERROR: prepared statement "_PLAN0000000029E75F70" does not exist
Statement: DEALLOCATE "_PLAN0000000029EED600"
Date: 2026-06-25 00:00:24 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029E7A3E0"
Date: 2026-06-25 00:01:25 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029E75F70"
Date: 2026-06-25 00:02:26 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 73 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #2
Day Hour Count Jun 25 06 4 08 18 10 3 11 21 12 15 14 12 - ERROR: trailing junk after numeric literal at or near "08952A70DE94" at character 27
- ERROR: trailing junk after numeric literal at or near "08952A70DE94" at character 27
- ERROR: trailing junk after numeric literal at or near "08952A70DE94" at character 27
Statement: SELECT * FROM RS_ETIQUETA(08952A70DE94)
Date: 2026-06-25 06:57:25 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(08952A70DE94)
Date: 2026-06-25 06:57:25 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(08952A70DE94)
Date: 2026-06-25 06:57:41 Database: rio Application: [unknown] User: etiquetas Remote: [local]
3 45 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #3
Day Hour Count Jun 25 00 2 01 2 02 2 03 2 04 2 05 2 06 2 07 2 08 2 09 2 10 2 11 2 12 2 13 2 14 2 15 2 16 2 17 2 18 2 19 2 20 1 21 2 22 2 - ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-06-25 00:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-06-25 00:35:01 Database: brasilia Application: psql User: intelifix Remote: [local]
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-06-25 01:05:02 Database: brasilia Application: psql User: intelifix Remote: [local]
4 44 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #4
Day Hour Count Jun 25 08 3 09 3 10 3 11 3 12 3 13 3 14 3 15 3 16 3 17 3 18 3 19 2 20 3 21 3 22 3 - ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-25 08:00:06 Database: brasilia Application: psql User: intelifix Remote: [local]
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-25 08:20:09 Database: brasilia Application: psql User: intelifix Remote: [local]
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-25 08:40:06 Database: brasilia Application: psql User: intelifix Remote: [local]
5 35 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Jun 25 06 2 07 10 08 3 09 4 11 3 12 3 14 3 15 2 16 5 - ERROR: column "cc03fa943064" does not exist at character 27
- ERROR: column "cc03fa943064" does not exist at character 27
- ERROR: column "mf51115161313000" does not exist at character 27
Statement: SELECT * FROM RS_ETIQUETA(CC03FA943064)
Date: 2026-06-25 06:58:12 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(CC03FA943064)
Date: 2026-06-25 06:58:12 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(MF51115161313000)
Date: 2026-06-25 07:23:57 Database: rio Application: [unknown] User: etiquetas Remote: [local]
6 20 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #6
Day Hour Count Jun 25 07 3 08 4 09 1 10 3 11 3 15 6 - LOG: process 4041697 still waiting for ShareLock on transaction 1596959 after 1000.187 ms
- LOG: process 4038409 still waiting for ShareLock on transaction 1597531 after 1000.131 ms
- LOG: process 4038409 still waiting for ShareLock on transaction 1597531 after 7888.930 ms
Detail: Process holding the lock: 4038409. Wait queue: 4041697.
Context: while updating tuple (71523,87) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-06-25 07:15:08 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 4041697. Wait queue: 4038409.
Context: while updating tuple (71524,27) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-06-25 07:25:10 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 4041697. Wait queue: 4038409.
Context: while updating tuple (71524,27) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-06-25 07:25:16 Database: rio Application: psql User: intelifix Remote: [local]
7 12 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #7
Day Hour Count Jun 25 03 12 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-06-25 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-25 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-06-25 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
8 8 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #8
Day Hour Count Jun 25 09 2 14 1 15 2 16 3 - ERROR: syntax error at or near "]" at character 33
- ERROR: syntax error at or near "]" at character 33
- ERROR: syntax error at or near ")" at character 242
Statement: select * from rs_caixa_qr(113131])
Date: 2026-06-25 09:11:12 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(113131])
Date: 2026-06-25 09:11:12 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_MODELO_MANUTENCAO(0327,'41001592',022,04,'99,12,12,12',080,00,'',09,'','41001592',',,,',09,09,'41001592',00,055,'7,6,2,8,10,9,3','','','S','S',09, 'S/n,Mac - EP,Emta mac,Pon id,,,,,1,2,2,3',0,'N','','','',)
Date: 2026-06-25 14:43:24 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
9 6 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #9
Day Hour Count Jun 25 00 1 06 1 10 1 12 1 18 1 23 1 - FATAL: database "testes" does not exist
- FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-06-25 00:02:31 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-06-25 06:02:28 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-06-25 10:48:47 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
10 5 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #10
Day Hour Count Jun 25 05 4 08 1 - 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-06-25 05:32:02 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-06-25 05:32:02 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-06-25 05:32:02 Database: contagem Application: psql User: intelifix Remote: [local]
11 3 ERROR: value overflows numeric format
Times Reported Most Frequent Error / Event #11
Day Hour Count Jun 25 10 3 - ERROR: value overflows numeric format at character 27
- ERROR: value overflows numeric format at character 27
- ERROR: value overflows numeric format at character 27
Statement: SELECT * FROM RS_ETIQUETA(84E058240168)
Date: 2026-06-25 10:24:59 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(84E058240168)
Date: 2026-06-25 10:24:59 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(84E058240168)
Date: 2026-06-25 10:25:00 Database: rio Application: [unknown] User: etiquetas Remote: [local]
12 3 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #12
Day Hour Count Jun 25 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-06-25 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-25 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-06-25 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
13 3 ERROR: function rs_etiqueta(...) does not exist
Times Reported Most Frequent Error / Event #13
Day Hour Count Jun 25 10 3 - ERROR: function rs_etiqueta(numeric) does not exist at character 15
- ERROR: function rs_etiqueta(numeric) does not exist at character 15
- ERROR: function rs_etiqueta(numeric) does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_ETIQUETA(023676E31815)Date: 2026-06-25 10:04:20 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_ETIQUETA(023676E31815)Date: 2026-06-25 10:04:20 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_ETIQUETA(023676E31815)Date: 2026-06-25 10:04:20 Database: rio Application: [unknown] User: etiquetas Remote: [local]
14 2 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #14
Day Hour Count Jun 25 09 1 13 1 - LOG: process 4106712 still waiting for AccessExclusiveLock on relation 1590660 of database 358220 after 1000.173 ms
- LOG: process 153083 still waiting for AccessExclusiveLock on relation 1613516 of database 358220 after 1000.118 ms
Detail: Process holding the lock: 4133567. Wait queue: 4106712.
Statement: DROP TABLE IF EXISTS temp0000283570;Date: 2026-06-25 09:28:44 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 172023. Wait queue: 153083.
Statement: DROP TABLE IF EXISTS temp0000283596;Date: 2026-06-25 13:54:46 Database: rio Application: [unknown] User: intelifix Remote: [local]
15 2 ERROR: function rs_lote_manutencao_itens(...) does not exist
Times Reported Most Frequent Error / Event #15
Day Hour Count Jun 25 10 1 14 1 - ERROR: function rs_lote_manutencao_itens(integer, integer, unknown, unknown, integer, integer, unknown, unknown, unknown, bigint) does not exist at character 15
- ERROR: function rs_lote_manutencao_itens(integer, integer, unknown, unknown, integer, integer, unknown, unknown, unknown, 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_LOTE_MANUTENCAO_ITENS(125657,399,'919041128035,981E19155C0B$918481213394,D06EDE98C522$919121079082,8020DA4CEFE5$919401158177,34495B8AD29A$919151045614,8020DA5BCAF2$919151143668,D0579475C20C$919491085065,3093BCB5E919$918381100296,E8ADA6BC8604','',0129,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":""}]','$$$$$$$','',0919041128035);Date: 2026-06-25 10:49:36 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(125586,401,'3A8TRCJ00881,7C7D21ED0D0F,ZTE3A8TRCB07939$3A8TT2R02763,7C7D21F1EC5B,ZTE3A8TT2L11266$3A8TT3P00532,142004557A3E,ZTE3A8TT3C17971$3A8TT2E00302,7C7D21F0D46F,ZTE3A8TRCS18851$3A8TT2K00946,7C7D21F0EF07,ZTE3A8TRCS20553$3A8TR1H00712,DC5193D99F62,ZTE3A8TQCH17687$3A8TR1400050,DC5193D8CA8A,ZTE3A8TQCH04065$3A8TT4E01935,14200457C85A,ZTE3A8TT4704738$3A8TR1400021,DC5193D8CA82,ZTE3A8TQCH04063$3A8TT3400607,14200452EBA2,ZTE3A8TT3301576$3A8TT2A00695,7C7D21F003D7,ZTE3A8TRCS05501$3A8TR1800465,DC5193D90AD6,ZTE3A8TQCH08180$3A8TRCH01118,7C7D21ECF80B,ZTE3A8TRCB06594$3A8TR6201430,E44E129227CF,ZTE3A8TR5U12898$3A8TT3400608,14200452E616,ZTE3A8TT3301221$3A8TT3R00358,14200455E24E,ZTE3A8TT3C24631$3A8TT2K00947,7C7D21F0EE7F,ZTE3A8TRCS20519$3A8TR6201432,E44E12922AFF,ZTE3A8TR5U13102$3A8TT3R00355,14200455E08A,ZTE3A8TT3C24518$3A8TT2K00945,7C7D21F0F71B,ZTE3A8TRCS21070$3A8TT3J00355,14200454EAAE,ZTE3A8TT3C08783$3A8TT4E01942,14200457C8C2,ZTE3A8TT4704764$3A8TRCH01360,7C7D21ECFBDB,ZTE3A8TRCB06838$3A8TT2A00698,7C7D21F001E3,ZTE3A8TRCS05376$3A8TR6C03429,E44E1293E153,ZTE3A8TR6515655$3A8TRCJ00887,7C7D21ED0D23,ZTE3A8TRCB07944','',0329,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','',077211E5);Date: 2026-06-25 14:03:53 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
16 2 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #16
Day Hour Count Jun 25 09 1 13 1 - ERROR: canceling autovacuum task
- ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000283570"
Date: 2026-06-25 09:28:44
Context: automatic vacuum of table "rio.public.temp0000283596"
Date: 2026-06-25 13:54:46
17 1 ERROR: function rs_fluxos_lista(...) does not exist
Times Reported Most Frequent Error / Event #17
Day Hour Count Jun 25 14 1 - ERROR: function rs_fluxos_lista(integer, integer, integer, unknown, unknown, bigint, unknown, integer) does not exist at character 46
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: CREATE TABLE temp0000283622 AS SELECT * FROM RS_FLUXOS_LISTA(06,00,00,'25-06-2026','25-06-2026',0246489166161,'',00);Date: 2026-06-25 14:39:36 Database: rio Application: [unknown] User: intelifix Remote: [local]
18 1 ERROR: unterminated quoted string at or near "..."
Times Reported Most Frequent Error / Event #18
Day Hour Count Jun 25 13 1 - ERROR: unterminated quoted string at or near "''');" at character 39
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''');
Date: 2026-06-25 13:19:22 Database: contagem Application: [unknown] User: intelifix Remote: [local]
19 1 ERROR: trailing junk after parameter at or near "..."
Times Reported Most Frequent Error / Event #19
Day Hour Count Jun 25 07 1 - ERROR: trailing junk after parameter at or near "Serial" at character 27
Statement: SELECT * FROM RS_ETIQUETA($1Serial)
Date: 2026-06-25 07:59:47 Database: rio Application: [unknown] User: etiquetas Remote: [local]
20 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #20
Day Hour Count Jun 25 03 1 - LOG: database system was shut down at 2026-06-25 03:05:01 -03
Date: 2026-06-25 03:05:02
21 1 ERROR: invalid input syntax for type date: ...
Times Reported Most Frequent Error / Event #21
Day Hour Count Jun 25 08 1 - ERROR: invalid input syntax for type date: "N-Na--N-Na" at character 40
Statement: SELECT * FROM RS_RESUMO_PERIODO_GERAL( 'N-Na--N-Na', 0404 ,'', '',0,7,'N-Na--N-Na');
Date: 2026-06-25 08:10:07 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
22 1 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv' PL/Python function "...", line 21, in <module> os.chmod(...) PL/Python function "..." PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Times Reported Most Frequent Error / Event #22
Day Hour Count Jun 25 20 1 - ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv' PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Context: Traceback (most recent call last):
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-06-25 20:35:02 Database: brasilia Application: psql User: intelifix Remote: [local]
23 1 ERROR: invalid input syntax for type json PL/pgSQL function rs_resumo_tcia(...) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(...) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(...) line 48 at assignment
Times Reported Most Frequent Error / Event #23
Day Hour Count Jun 25 19 1 - ERROR: invalid input syntax for type json PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936...
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-25 19:20:03 Database: brasilia Application: psql User: intelifix Remote: [local]