pgBadger-
Global information
- Generated on Sat Jun 27 23:50:10 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 44,999 log entries in 8s
- Log start from 2026-06-26 00:00:07 to 2026-06-26 23:59:46
-
Overview
Global Stats
- 420 Number of unique normalized queries
- 6,972 Number of queries
- 9h49m7s Total query duration
- 2026-06-26 00:01:38 First query
- 2026-06-26 23:51:11 Last query
- 5 queries/s at 2026-06-26 16:07:24 Query peak
- 9h49m7s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 9h49m7s Execute total duration
- 3,980 Number of events
- 17 Number of unique normalized events
- 3,730 Max number of times the same event was reported
- 0 Number of cancellation
- 514 Total number of automatic vacuums
- 1,112 Total number of automatic analyzes
- 38 Number temporary file
- 232.16 MiB Max size of temporary file
- 107.78 MiB Average size of temporary file
- 354 Total number of sessions
- 8 sessions at 2026-06-26 08:19:20 Session peak
- 13d37m39s Total duration of sessions
- 52m59s Average duration of sessions
- 19 Average queries per session
- 1m39s Average queries duration per session
- 51m19s Average idle time per session
- 356 Total number of connections
- 5 connections/s at 2026-06-26 03:05:16 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-06-26 16:07:24 Date
SELECT Traffic
Key values
- 5 queries/s Query Peak
- 2026-06-26 15:28:53 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-06-26 23:51:00 Date
Queries duration
Key values
- 9h49m7s 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 26 00 23 0ms 19s604ms 5s588ms 4s308ms 6s112ms 1m19s 01 18 0ms 3s601ms 1s704ms 3s580ms 5s274ms 5s947ms 02 12 0ms 3s869ms 2s277ms 3s488ms 4s802ms 5s676ms 03 15 0ms 4s38ms 1s984ms 3s656ms 4s661ms 5s873ms 04 34 0ms 3s825ms 1s1ms 3s432ms 5s19ms 5s487ms 05 31 0ms 8m42s 34s709ms 6s35ms 2m36s 8m42s 06 22 0ms 19s87ms 4s241ms 3s369ms 20s207ms 30s610ms 07 488 0ms 8m3s 5s451ms 1m27s 5m55s 8m10s 08 936 150ms 8m46s 3s974ms 2m25s 5m32s 9m38s 09 839 150ms 9m29s 3s212ms 1m36s 5m37s 9m40s 10 854 150ms 8m58s 3s958ms 1m37s 5m37s 9m50s 11 789 150ms 8m50s 4s212ms 4m29s 6m3s 8m59s 12 162 0ms 7m17s 7s976ms 32s591ms 4m15s 7m54s 13 339 0ms 5m52s 3s239ms 39s132ms 1m15s 5m52s 14 627 150ms 8m18s 4s5ms 1m27s 4m18s 8m36s 15 825 150ms 8m2s 4s572ms 1m49s 6m34s 12m32s 16 332 0ms 7m9s 5s181ms 44s297ms 4m4s 8m10s 17 146 0ms 6m15s 5s169ms 6s397ms 20s715ms 7m 18 23 0ms 5m49s 26s742ms 2s948ms 43s463ms 5m49s 19 16 0ms 5m26s 35s783ms 2s914ms 14s313ms 5m56s 20 107 0ms 6m12s 11s330ms 1m4s 1m57s 6m12s 21 28 0ms 5m52s 22s657ms 5s106ms 47s332ms 5m52s 22 25 0ms 5m24s 23s813ms 5s117ms 14s347ms 5m52s 23 281 0ms 16m1s 11s991ms 1m14s 1m43s 18m5s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 26 00 4 0 6s287ms 0ms 0ms 337ms 01 5 0 433ms 0ms 0ms 796ms 02 0 0 0ms 0ms 0ms 0ms 03 2 0 475ms 0ms 0ms 0ms 04 21 0 331ms 280ms 441ms 1s159ms 05 16 0 352ms 0ms 304ms 944ms 06 8 0 3s264ms 0ms 0ms 1s119ms 07 361 0 5s560ms 12s80ms 1m26s 4m57s 08 668 0 3s867ms 38s655ms 1m38s 5m31s 09 620 0 3s719ms 13s235ms 1m12s 5m51s 10 622 0 4s652ms 40s388ms 1m17s 6m43s 11 593 0 4s878ms 31s789ms 4m12s 6m31s 12 102 0 10s804ms 4s397ms 12s330ms 4m14s 13 256 0 3s619ms 9s134ms 38s487ms 3m23s 14 476 0 4s285ms 17s820ms 1m13s 5m51s 15 653 0 4s269ms 54s29ms 1m35s 8m57s 16 261 0 5s631ms 9s815ms 33s278ms 4m39s 17 90 0 7s954ms 3s567ms 5s683ms 3m19s 18 11 0 53s864ms 0ms 287ms 3m16s 19 6 0 1m32s 0ms 0ms 3m1s 20 9 87 12s358ms 4s962ms 1m4s 3m34s 21 13 0 46s630ms 0ms 150ms 3m25s 22 8 0 1m10s 0ms 0ms 3m15s 23 23 255 8s658ms 1m2s 1m14s 2m3s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 26 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 26 00 0 1 1.00 0.00% 01 0 2 2.00 0.00% 02 0 0 0.00 0.00% 03 0 1 1.00 0.00% 04 0 2 2.00 0.00% 05 0 3 3.00 0.00% 06 0 1 1.00 0.00% 07 0 13 13.00 0.00% 08 0 16 16.00 0.00% 09 0 18 18.00 0.00% 10 0 16 16.00 0.00% 11 0 14 14.00 0.00% 12 0 9 9.00 0.00% 13 0 12 12.00 0.00% 14 0 14 14.00 0.00% 15 0 20 20.00 0.00% 16 0 5 5.00 0.00% 17 0 5 5.00 0.00% 18 0 1 1.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 1 1.00 0.00% 22 0 1 1.00 0.00% 23 0 3 3.00 0.00% Day Hour Count Average / Second Jun 26 00 12 0.00/s 01 8 0.00/s 02 7 0.00/s 03 17 0.00/s 04 7 0.00/s 05 10 0.00/s 06 14 0.00/s 07 20 0.01/s 08 21 0.01/s 09 20 0.01/s 10 24 0.01/s 11 20 0.01/s 12 14 0.00/s 13 22 0.01/s 14 24 0.01/s 15 30 0.01/s 16 11 0.00/s 17 15 0.00/s 18 9 0.00/s 19 9 0.00/s 20 11 0.00/s 21 10 0.00/s 22 9 0.00/s 23 12 0.00/s Day Hour Count Average Duration Average idle time Jun 26 00 9 1h46s 1h32s 01 11 1h33s 1h30s 02 8 1h22s 1h19s 03 15 13m51s 13m49s 04 9 1h2m40s 1h2m36s 05 7 1h25s 57m52s 06 10 57m48s 57m38s 07 16 52m38s 49m52s 08 17 57m27s 53m48s 09 23 55m19s 53m22s 10 21 53m21s 50m40s 11 24 54m53s 52m34s 12 23 47m53s 46m57s 13 9 54m26s 52m24s 14 24 55m20s 53m35s 15 28 45m58s 43m43s 16 23 58m53s 57m38s 17 13 51m39s 50m41s 18 13 1h1m28s 1h40s 19 10 55m18s 54m21s 20 11 45m 43m10s 21 8 1h24s 59m4s 22 10 1h1m8s 1h8s 23 12 48m41s 44m -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-06-26 03:05:16 Date
Connections per database
Key values
- rio Main Database
- 356 connections Total
Connections per user
Key values
- intelifix Main User
- 356 connections Total
-
Sessions
Simultaneous sessions
Key values
- 8 sessions Session Peak
- 2026-06-26 08:19:20 Date
Histogram of session times
Key values
- 285 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 354 sessions Total
Sessions per user
Key values
- intelifix Main User
- 354 sessions Total
Sessions per host
Key values
- [local] Main Host
- 354 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 19,886 buffers Checkpoint Peak
- 2026-06-26 16:04:37 Date
- 270.011 seconds Highest write time
- 0.130 seconds Sync time
Checkpoints Wal files
Key values
- 15 files Wal files usage Peak
- 2026-06-26 16:04:37 Date
Checkpoints distance
Key values
- 464.53 Mo Distance Peak
- 2026-06-26 16:04:37 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jun 26 00 21,287 664.275s 0.042s 664.383s 01 2,002 201.134s 0.035s 201.245s 02 1,637 164.708s 0.028s 164.781s 03 1,873 188.173s 0.032s 188.268s 04 4,202 421.737s 0.043s 421.841s 05 9,698 932.679s 0.095s 932.855s 06 6,320 421.239s 0.012s 421.286s 07 47,136 2,640.694s 0.554s 2,641.467s 08 73,710 3,238.654s 0.809s 3,239.755s 09 79,612 3,238.493s 0.879s 3,239.646s 10 79,617 3,238.66s 0.857s 3,239.773s 11 91,420 3,238.605s 0.738s 3,239.621s 12 29,585 2,000.872s 0.209s 2,001.194s 13 23,256 1,833.01s 0.284s 1,833.425s 14 71,915 3,175.862s 0.562s 3,176.642s 15 73,579 3,238.647s 0.768s 3,239.684s 16 47,403 2,231.928s 0.345s 2,232.454s 17 9,979 1,002.29s 0.181s 1,002.558s 18 1,443 144.634s 0.017s 144.684s 19 23 2.332s 0.004s 2.343s 20 425 90.149s 0.041s 90.208s 21 3,449 349.147s 0.09s 349.359s 22 3,056 306.718s 0.075s 306.848s 23 1,596 380.328s 0.041s 380.413s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jun 26 00 0 0 6 487 0.003s 0.009s 01 0 0 1 449 0.004s 0.01s 02 0 0 0 404 0.003s 0.007s 03 0 0 1 365 0.003s 0.009s 04 0 0 1 587 0.003s 0.008s 05 0 0 4 870 0.014s 0.01s 06 0 0 1 107 0.002s 0.003s 07 0 0 29 4,182 0.018s 0.012s 08 0 0 76 6,720 0.009s 0.012s 09 0 0 36 7,620 0.010s 0.012s 10 0 0 46 7,442 0.024s 0.012s 11 0 0 55 7,463 0.007s 0.012s 12 0 0 18 2,774 0.003s 0.011s 13 0 0 11 3,899 0.004s 0.012s 14 0 0 43 6,184 0.007s 0.012s 15 0 0 66 7,332 0.009s 0.012s 16 0 0 33 4,412 0.006s 0.012s 17 0 0 3 2,414 0.009s 0.011s 18 0 0 1 151 0.002s 0.005s 19 0 0 0 4 0.002s 0.001s 20 0 0 1 89 0.007s 0.003s 21 0 0 1 488 0.015s 0.011s 22 0 0 1 448 0.019s 0.008s 23 0 0 3 236 0.003s 0.006s Day Hour Count Avg time (sec) Jun 26 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 26 00 13,688.75 kB 53,543.12 kB 01 1,007.80 kB 28,732.10 kB 02 1,198.29 kB 12,102.29 kB 03 1,102.33 kB 3,625.67 kB 04 2,527.88 kB 3,222.75 kB 05 6,757.70 kB 15,682.10 kB 06 5,366.67 kB 11,545.67 kB 07 39,376.58 kB 62,177.33 kB 08 103,263.50 kB 165,468.17 kB 09 49,826.58 kB 101,017.58 kB 10 62,006.67 kB 102,150.83 kB 11 75,607.17 kB 138,731.58 kB 12 27,247.55 kB 88,709.45 kB 13 14,466.75 kB 44,910.58 kB 14 58,522.75 kB 106,004.33 kB 15 90,414.00 kB 135,840.83 kB 16 45,331.42 kB 157,643.58 kB 17 4,421.45 kB 51,448.73 kB 18 1,166.00 kB 22,959.80 kB 19 167.00 kB 16,669.00 kB 20 5,401.67 kB 14,886.67 kB 21 1,886.75 kB 9,250.38 kB 22 1,973.12 kB 5,166.12 kB 23 10,648.33 kB 39,705.17 kB -
Temporary Files
Size of temporary files
Key values
- 464.33 MiB Temp Files size Peak
- 2026-06-26 05:32:00 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-06-26 05:32:06 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jun 26 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.95 MiB 06 0 0 0 07 1 104.00 MiB 104.00 MiB 08 4 416.00 MiB 104.00 MiB 09 1 104.00 MiB 104.00 MiB 10 4 416.00 MiB 104.00 MiB 11 3 416.25 MiB 138.75 MiB 12 0 0 0 13 1 104.00 MiB 104.00 MiB 14 5 520.00 MiB 104.00 MiB 15 8 832.00 MiB 104.00 MiB 16 1 104.00 MiB 104.00 MiB 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 26 2.64 GiB 104.00 MiB 104.00 MiB 104.00 MiB select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-06-01''),DATE(''2026-06-25'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-06-26 10:26:49 Duration: 6m24s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026237, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-26 09:26:15 Duration: 5m48s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026263, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-26 14:35:16 Duration: 5m41s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
2 8 901.83 MiB 69.25 MiB 232.16 MiB 112.73 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-06-26 05:32:08 Duration: 1m27s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-06-26 05:32:00 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
3 2 177.62 MiB 88.81 MiB 88.81 MiB 88.81 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-06-26 05:30:41 Duration: 38s939ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-06-26 05:30:38 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
4 2 312.25 MiB 104.00 MiB 208.24 MiB 156.12 MiB select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026248);
Date: 2026-06-26 11:04:05 Duration: 1m49s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026279);
Date: 2026-06-26 15:58:07 Duration: 1m7s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026250);
Date: 2026-06-26 11:15:12 Duration: 13s479ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
Queries generating the largest temporary files
Rank Size Query 1 232.16 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-06-26 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 232.16 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-06-26 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 208.24 MiB SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026248);[ Date: 2026-06-26 11:03:28 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,504,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-26 14:26:29 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-26 15:15:42 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
6 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-26 15:34:30 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
7 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-26 08:55:24 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
8 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-26 14:41:47 - 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-26 15:56:05 - 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-26 14:47:52 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
11 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,317,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-26 10:45:12 - 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-26 15:22:24 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 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-26 16:05:37 - 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-26 15:28:14 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
15 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-26 11:01:39 - 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-26 15:03:38 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
17 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-26 10:36:53 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
18 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,504,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-26 14:14:39 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 104.00 MiB SELECT RS_SETGLOBAL ('USUARIO', 504); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026259);[ Date: 2026-06-26 14:16:27 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 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-26 13:51:37 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 9.90 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_06
Database contagem - 2026-06-26 15:19:08 Date
- 0 sec Highest CPU-cost analyze
Table
Database contagem - Date
Average Autovacuum Duration
Key values
- 9.90 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_06
Database contagem - 2026-06-26 15:19:08 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (151) Main table analyzed (database rio)
- 1,112 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 151 rio.pg_catalog.pg_class 83 rio.pg_catalog.pg_type 68 rio.public.usuarios 48 rio.pg_catalog.pg_index 46 rio.pg_catalog.pg_depend 38 rio.public.temp0000283696 33 brasilia.pg_catalog.pg_attribute 32 rio.public.temp0000283746 26 rio.public.temp0000283704 26 contagem.public.usuarios 25 rio.public.temp0000283666 24 rio.public.temp0000283306 24 rio.public.temp0000283708 23 rio.public.temp0000283178 23 contagem.public.temp0000226462 18 rio.public.temp0000283736 17 brasilia.pg_catalog.pg_class 17 rio.public.temp0000283658 17 rio.public.temp0000283420 16 rio.public.temp0000283652 15 rio.public.temp0000283660 15 rio.public.temp0000283390 15 contagem.pg_catalog.pg_attribute 14 rio.public.temp0000283672 14 brasilia.pg_catalog.pg_type 14 rio.public.temp0000283752 14 rio.public.temp0000283686 11 contagem.public.temp0000226498 11 rio.public.temp0000283642 10 rio.public.temp0000283676 10 rio.public.temp0000283102 9 rio.public.temp0000283662 9 brasilia.pg_catalog.pg_index 8 rio.public.temp0000283690 8 rio.public.temp0000283650 7 brasilia.public.usuarios 7 contagem.public.temp0000226464 7 rio.public.temp0000283670 7 rio.public.temp0000283656 7 brasilia.pg_catalog.pg_depend 6 rio.public.temp0000283706 6 rio.public.temp0000283644 6 rio.public.temp0000283290 5 rio.pg_catalog.pg_shdepend 5 rio.public.temp0000283726 5 rio.public.temp0000283700 5 contagem.pg_catalog.pg_class 5 rio.public.temp0000283524 5 rio.public.temp0000281789 4 brasilia.public.temp0000234800 4 rio.public.temp0000283730 4 contagem.pg_catalog.pg_type 4 rio.public.temp0000283780 4 rio.public.temp0000283198 4 rio.public.temp0000283770 4 rio.public.temp0000283744 3 rio.public.tmp_drill_0175 3 rio.public.temp0000283728 3 brasilia.pg_catalog.pg_shdepend 3 brasilia.public.temp0000234706 3 rio.public.temp0000283758 3 contagem.pg_catalog.pg_shdepend 3 rio.public.temp0000283764 3 template1.pg_catalog.pg_shdepend 2 brasilia.public.temp0000234762 2 rio.public.temp0000283694 2 rio.public.tmp_drill_0302 2 brasilia.public.temp0000234712 2 contagem.pg_catalog.pg_index 2 contagem.public.temp0000226506 2 brasilia.auditor.auditor_2026_06 2 brasilia.public.temp0000234814 2 brasilia.public.temp0000234788 1 rio.public.temp0000283674 1 contagem.pg_catalog.pg_depend 1 brasilia.public.temp0000234778 1 brasilia.public.temp0000234782 1 brasilia.public.temp0000234750 1 rio.public.temp0000283702 1 rio.public.temp0000282507 1 brasilia.public.temp0000234724 1 brasilia.public.temp0000234796 1 brasilia.public.temp0000234804 1 rio.public.temp0000283692 1 rio.public.temp0000283714 1 brasilia.public.temp0000234738 1 brasilia.public.temp0000234720 1 brasilia.public.temp0000234768 1 rio.public.temp0000283776 1 brasilia.public.temp0000234710 1 rio.public.temp0000283680 1 brasilia.public.temp0000234716 1 brasilia.public.temp0000234708 1 rio.public.temp0000283754 1 rio.public.temp0000283698 1 rio.public.temp0000283748 1 rio.public.temp0000283778 1 rio.public.temp0000283654 1 rio.public.temp0000283740 1 Total 1,112 Vacuums per table
Key values
- pg_catalog.pg_attribute (68) Main table vacuumed on database rio
- 514 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 68 56 0 0 0 0 0 30,759 7,458 10,987,339 489 11,639 rio.pg_catalog.pg_class 49 39 0 0 0 0 0 7,390 2,225 2,998,931 111 509 rio.pg_catalog.pg_type 33 30 0 0 0 0 0 2,830 823 1,068,334 81 291 rio.public.temp0000283746 25 0 0 0 0 0 0 27,413 92 1,631,917 0 0 rio.public.temp0000283704 25 0 0 0 0 0 0 20,960 88 1,250,935 0 0 rio.public.temp0000283666 25 0 0 0 0 0 0 27,502 1,703 3,691,667 0 0 contagem.public.usuarios 24 0 0 0 0 0 0 125 96 47,811 0 0 rio.public.temp0000283178 22 0 0 0 0 0 0 1,610 226 300,708 0 0 rio.pg_catalog.pg_index 19 19 0 0 0 0 0 1,325 337 295,516 71 148 rio.public.temp0000283708 15 0 0 0 0 0 0 2,576 79 164,266 0 0 rio.public.temp0000283752 14 0 0 0 0 0 0 13,418 56 800,376 0 0 rio.public.temp0000283390 12 0 0 0 0 0 0 660 95 96,576 0 0 rio.pg_catalog.pg_depend 12 12 0 0 0 0 0 4,507 1,679 2,339,766 80 706 rio.pg_catalog.pg_statistic 11 11 0 0 0 0 0 13,231 2,933 13,175,093 1,240 4,893 rio.public.temp0000283672 11 0 0 0 0 0 0 1,861 53 118,443 0 0 rio.public.usuarios 11 5 0 0 0 0 0 153 63 144,732 7 12 brasilia.pg_catalog.pg_attribute 10 10 0 0 0 0 0 4,729 1,470 2,154,553 70 2,006 rio.public.temp0000283102 9 0 0 0 0 0 0 324 125 161,428 0 0 rio.public.temp0000283690 8 0 0 0 0 0 0 341 44 26,693 0 0 rio.public.temp0000283652 8 0 0 0 0 0 0 5,094 37 306,688 0 0 rio.pg_toast.pg_toast_2619 6 6 0 0 0 0 0 2,301 522 2,634,777 106 353 brasilia.pg_catalog.pg_class 6 6 0 0 0 0 0 1,128 382 578,120 25 84 brasilia.pg_catalog.pg_type 5 5 0 0 0 0 0 297 113 164,751 13 85 postgres.pg_catalog.pg_shdepend 5 5 0 0 0 0 0 698 247 442,501 33 91 rio.public.temp0000283706 5 0 0 0 0 0 0 209 26 15,955 0 0 rio.public.temp0000283524 5 0 0 0 0 0 0 6,436 21 383,040 0 0 contagem.pg_catalog.pg_attribute 4 4 0 0 0 0 0 2,081 761 1,207,236 16 447 rio.public.tmp_drill_0175 4 2 0 0 0 0 0 75 29 41,375 1 10 rio.public.temp0000283420 3 0 0 0 0 0 0 3,224 11 191,960 0 0 rio.public.temp0000283744 3 0 0 0 0 0 0 3,225 1,617 2,244,884 0 0 rio.public.temp0000283730 3 0 0 0 0 0 0 3,224 1,617 2,244,623 0 0 brasilia.pg_catalog.pg_index 3 3 0 0 0 0 0 115 40 32,536 6 17 rio.public.temp0000283764 3 0 0 0 0 0 0 12 9 2,322 0 0 brasilia.pg_catalog.pg_statistic 2 2 0 0 0 0 0 3,428 364 1,381,485 262 1,892 rio.public.temp0000283728 2 0 0 0 0 0 0 216 12 14,614 0 0 brasilia.public.temp0000234814 2 0 0 0 0 0 0 472 12 30,096 0 0 rio.public.tmp_drill_0302 2 2 0 0 0 0 0 443 6 86,540 0 0 contagem.pg_catalog.pg_statistic 2 2 0 0 0 0 0 2,771 841 2,704,710 746 5,139 rio.public.temp0000283700 2 0 0 0 0 0 0 1,728 10 103,534 0 0 brasilia.pg_catalog.pg_depend 2 2 0 0 0 0 0 691 278 342,706 15 170 rio.public.temp0000281789 2 0 0 0 0 0 0 55 11 4,780 0 0 rio.pg_catalog.pg_shdepend 2 2 0 0 0 0 0 347 132 207,369 8 28 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 279 60 253,005 24 51 brasilia.public.temp0000234778 1 0 0 0 0 0 0 236 7 15,495 0 0 brasilia.public.temp0000234720 1 0 0 0 0 0 0 236 6 15,048 0 0 brasilia.auditor.auditor_2026_06 1 0 0 0 0 0 0 12,665 5,446 7,326,999 3,550 65,720 rio.public.temp0000283674 1 0 0 0 0 0 0 1,609 4 95,534 0 0 rio.public.temp0000283696 1 0 0 0 0 0 0 120 6 8,057 0 0 contagem.auditor.auditor_2026_06 1 0 0 0 0 0 0 37,591 28,424 35,462,067 4,511 76,858 rio.public.temp0000283736 1 0 0 0 0 0 0 110 6 7,429 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 130 35 116,480 18 33 rio.public.temp0000283670 1 0 0 0 0 0 0 8 5 1,370 0 0 rio.public.temp0000283686 1 0 0 0 0 0 0 8 5 1,381 0 0 rio.public.temp0000283714 1 0 0 0 0 0 0 125 6 8,363 0 0 brasilia.public.temp0000234738 1 0 0 0 0 0 0 8 5 1,514 0 0 rio.public.temp0000283692 1 0 0 0 0 0 0 120 6 8,057 0 0 contagem.pg_catalog.pg_class 1 1 0 0 0 0 0 188 80 89,140 2 4 contagem.pg_catalog.pg_index 1 1 0 0 0 0 0 63 28 26,672 0 0 rio.public.temp0000283650 1 0 0 0 0 0 0 120 6 8,061 0 0 rio.public.temp0000283748 1 0 0 0 0 0 0 4 3 774 0 0 rio.public.temp0000283754 1 0 0 0 0 0 0 4 3 774 0 0 rio.public.temp0000283680 1 0 0 0 0 0 0 120 6 8,059 0 0 rio.public.temp0000283740 1 0 0 0 0 0 0 125 4 7,978 0 0 rio.public.temp0000283654 1 0 0 0 0 0 0 125 6 8,366 0 0 rio.public.temp0000283758 1 0 0 0 0 0 0 126 6 8,409 0 0 rio.public.temp0000283726 1 0 0 0 0 0 0 8 5 1,277 0 0 rio.public.temp0000283702 1 0 0 0 0 0 0 49 6 3,721 0 0 rio.public.temp0000283306 1 0 0 0 0 0 0 120 6 8,061 0 0 contagem.pg_catalog.pg_type 1 1 0 0 0 0 0 107 47 56,068 3 6 rio.public.temp0000283676 1 0 0 0 0 0 0 126 4 8,037 0 0 rio.public.temp0000282507 1 0 0 0 0 0 0 65 6 4,706 0 0 Total 514 229 0 0 0 0 0 254,579 60,980 100,382,588 11,488 171,192 Vacuum throughput per table
Key values
- auditor.auditor_2026_06 (9.9) Max CPU elapsed for vacuum on database contagem
- unknown (0 ms) Max I/O read time for vacuum on database contagem
- unknown (0 ms) Max I/O write time for vacuum on database contagem
I/O timing (ms) CPU (s) Table read write elapsed rio.pg_catalog.pg_attribute 0 0 4.14 rio.pg_catalog.pg_class 0 0 1.19 rio.pg_catalog.pg_type 0 0 0.37 rio.public.temp0000283746 0 0 1.22 rio.public.temp0000283704 0 0 1.48 rio.public.temp0000283666 0 0 1.16 contagem.public.usuarios 0 0 0 rio.public.temp0000283178 0 0 0.31 rio.pg_catalog.pg_index 0 0 0.36 rio.public.temp0000283708 0 0 0.28 rio.public.temp0000283752 0 0 0.49 rio.public.temp0000283390 0 0 0.16 rio.pg_catalog.pg_depend 0 0 0.83 rio.pg_catalog.pg_statistic 0 0 1.81 rio.public.temp0000283672 0 0 0.25 rio.public.usuarios 0 0 0.01 brasilia.pg_catalog.pg_attribute 0 0 0.82 rio.public.temp0000283102 0 0 0.13 rio.public.temp0000283690 0 0 0.14 rio.public.temp0000283652 0 0 0.24 rio.pg_toast.pg_toast_2619 0 0 0.37 brasilia.pg_catalog.pg_class 0 0 0.21 brasilia.pg_catalog.pg_type 0 0 0.1 postgres.pg_catalog.pg_shdepend 0 0 0.31 rio.public.temp0000283706 0 0 0.06 rio.public.temp0000283524 0 0 0.21 contagem.pg_catalog.pg_attribute 0 0 0.43 rio.public.tmp_drill_0175 0 0 0.02 rio.public.temp0000283420 0 0 0.16 rio.public.temp0000283744 0 0 0.19 rio.public.temp0000283730 0 0 0.18 brasilia.pg_catalog.pg_index 0 0 0.05 rio.public.temp0000283764 0 0 0.17 brasilia.pg_catalog.pg_statistic 0 0 0.23 rio.public.temp0000283728 0 0 0.03 brasilia.public.temp0000234814 0 0 0.04 rio.public.tmp_drill_0302 0 0 0.02 contagem.pg_catalog.pg_statistic 0 0 0.22 rio.public.temp0000283700 0 0 0.08 brasilia.pg_catalog.pg_depend 0 0 0.17 rio.public.temp0000281789 0 0 0.03 rio.pg_catalog.pg_shdepend 0 0 0.11 brasilia.pg_toast.pg_toast_2619 0 0 0.01 brasilia.public.temp0000234778 0 0 0.02 brasilia.public.temp0000234720 0 0 0.02 brasilia.auditor.auditor_2026_06 0 0 2.05 rio.public.temp0000283674 0 0 0.05 rio.public.temp0000283696 0 0 0.02 contagem.auditor.auditor_2026_06 0 0 9.9 rio.public.temp0000283736 0 0 0.02 contagem.pg_toast.pg_toast_2619 0 0 0 rio.public.temp0000283670 0 0 0.01 rio.public.temp0000283686 0 0 0.02 rio.public.temp0000283714 0 0 0.02 brasilia.public.temp0000234738 0 0 0.03 rio.public.temp0000283692 0 0 0.02 contagem.pg_catalog.pg_class 0 0 0.07 contagem.pg_catalog.pg_index 0 0 0.05 rio.public.temp0000283650 0 0 0.02 rio.public.temp0000283748 0 0 0 rio.public.temp0000283754 0 0 0 rio.public.temp0000283680 0 0 0.02 rio.public.temp0000283740 0 0 0 rio.public.temp0000283654 0 0 0.02 rio.public.temp0000283758 0 0 0.02 rio.public.temp0000283726 0 0 0.01 rio.public.temp0000283702 0 0 0.02 rio.public.temp0000283306 0 0 0.01 contagem.pg_catalog.pg_type 0 0 0.04 rio.public.temp0000283676 0 0 0 rio.public.temp0000282507 0 0 0.02 Total 0 0 31.27 Tuples removed per table
Key values
- pg_catalog.pg_attribute (232452) Main table with removed tuples on database rio
- 355646 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 68 56 232,452 1,716,095 126,041 148 41,141 brasilia.pg_catalog.pg_attribute 10 10 31,576 212,171 80 0 5,602 rio.pg_catalog.pg_statistic 11 11 18,941 95,415 253 0 14,146 rio.pg_catalog.pg_depend 12 12 10,535 231,140 575 0 2,172 contagem.pg_catalog.pg_attribute 4 4 10,333 94,477 0 0 2,100 rio.pg_catalog.pg_type 33 30 8,725 79,459 3,720 16 2,311 rio.pg_catalog.pg_class 49 39 6,065 187,732 17,209 40 6,017 rio.public.tmp_drill_0302 2 2 5,929 6,369 0 0 161 contagem.pg_catalog.pg_statistic 2 2 5,285 14,828 0 0 2,022 brasilia.pg_catalog.pg_statistic 2 2 4,904 14,703 0 0 2,144 rio.pg_catalog.pg_index 19 19 4,898 37,698 936 3 1,133 postgres.pg_catalog.pg_shdepend 5 5 3,662 68,110 155 0 575 brasilia.pg_catalog.pg_depend 2 2 1,662 36,520 0 22 316 brasilia.pg_catalog.pg_class 6 6 1,613 20,211 0 0 684 brasilia.auditor.auditor_2026_06 1 0 1,575 763,035 0 0 33,089 contagem.public.usuarios 24 0 1,574 552 0 0 48 rio.pg_toast.pg_toast_2619 6 6 1,428 3,353 1 0 1,680 rio.pg_catalog.pg_shdepend 2 2 1,244 27,127 25 0 230 brasilia.pg_catalog.pg_type 5 5 949 11,069 10 6 292 rio.public.usuarios 11 5 483 6,863 1,280 0 187 rio.public.tmp_drill_0175 4 2 440 32,325 15,727 0 419 brasilia.pg_catalog.pg_index 3 3 348 5,632 0 3 144 contagem.auditor.auditor_2026_06 1 0 324 3,436,378 0 0 151,295 contagem.pg_catalog.pg_type 1 1 223 2,249 0 0 66 brasilia.pg_toast.pg_toast_2619 2 2 184 270 0 0 120 contagem.pg_catalog.pg_class 1 1 152 3,309 0 0 115 contagem.pg_toast.pg_toast_2619 1 1 103 116 0 0 51 contagem.pg_catalog.pg_index 1 1 39 1,895 0 0 51 brasilia.public.temp0000234778 1 0 0 3,036 0 28 228 rio.public.temp0000283672 11 0 0 83,584 0 162 5,662 rio.public.temp0000283728 2 0 0 8,908 0 56 200 brasilia.public.temp0000234720 1 0 0 3,036 0 28 228 rio.public.temp0000283752 14 0 0 216,522 0 60 15,620 rio.public.temp0000283178 22 0 0 84,866 0 540 1,924 brasilia.public.temp0000234814 2 0 0 6,076 0 56 456 rio.public.temp0000283674 1 0 0 22,629 0 0 1,664 rio.public.temp0000283420 3 0 0 67,957 0 0 4,992 rio.public.temp0000283744 3 0 0 67,955 0 0 4,992 rio.public.temp0000283696 1 0 0 2,187 0 16 112 rio.public.temp0000283690 8 0 0 21,152 0 133 475 rio.public.temp0000283736 1 0 0 4,511 0 26 102 rio.public.temp0000283670 1 0 0 2,187 0 16 112 rio.public.temp0000283686 1 0 0 2,250 0 11 117 rio.public.temp0000283714 1 0 0 2,255 0 11 117 brasilia.public.temp0000234738 1 0 0 3,036 0 28 228 rio.public.temp0000283746 25 0 0 566,372 0 0 41,600 rio.public.temp0000283692 1 0 0 2,187 0 16 112 rio.public.temp0000283102 9 0 0 29,252 0 204 660 rio.public.temp0000283706 5 0 0 13,846 0 130 286 rio.public.temp0000283524 5 0 0 92,635 0 13 6,771 rio.public.temp0000283704 25 0 0 565,688 0 0 41,600 rio.public.temp0000283650 1 0 0 2,187 0 16 112 rio.public.temp0000283748 1 0 0 2,345 0 0 128 rio.public.temp0000283754 1 0 0 2,418 0 0 128 rio.public.temp0000283680 1 0 0 2,187 0 16 112 rio.public.temp0000283730 3 0 0 67,925 0 0 4,992 rio.public.temp0000283740 1 0 0 2,333 0 0 128 rio.public.temp0000283654 1 0 0 2,255 0 11 117 rio.public.temp0000283764 3 0 0 67,992 0 0 4,992 rio.public.temp0000283700 2 0 0 24,803 0 16 1,776 rio.public.temp0000283390 12 0 0 35,153 0 292 860 rio.public.temp0000283758 1 0 0 5,234 0 10 118 rio.public.temp0000283652 8 0 0 99,650 0 43 7,125 rio.public.temp0000281789 2 0 0 3,840 0 45 83 rio.public.temp0000283726 1 0 0 3,343 0 53 75 rio.public.temp0000283708 15 0 0 74,454 0 174 4,370 rio.public.temp0000283702 1 0 0 1,854 0 23 41 rio.public.temp0000283666 25 0 0 524,803 0 27 38,501 rio.public.temp0000283306 1 0 0 2,187 0 16 112 rio.public.temp0000283676 1 0 0 2,356 0 0 128 rio.public.temp0000282507 1 0 0 1,098 0 7 57 Total 514 229 355,646 9,909,645 166,012 2,521 460,524 Pages removed per table
Key values
- public.temp0000283178 (540) Main table with removed pages on database rio
- 2521 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000283178 22 0 0 540 rio.public.temp0000283390 12 0 0 292 rio.public.temp0000283102 9 0 0 204 rio.public.temp0000283708 15 0 0 174 rio.public.temp0000283672 11 0 0 162 rio.pg_catalog.pg_attribute 68 56 232452 148 rio.public.temp0000283690 8 0 0 133 rio.public.temp0000283706 5 0 0 130 rio.public.temp0000283752 14 0 0 60 rio.public.temp0000283728 2 0 0 56 brasilia.public.temp0000234814 2 0 0 56 rio.public.temp0000283726 1 0 0 53 rio.public.temp0000281789 2 0 0 45 rio.public.temp0000283652 8 0 0 43 rio.pg_catalog.pg_class 49 39 6065 40 brasilia.public.temp0000234778 1 0 0 28 brasilia.public.temp0000234720 1 0 0 28 brasilia.public.temp0000234738 1 0 0 28 rio.public.temp0000283666 25 0 0 27 rio.public.temp0000283736 1 0 0 26 rio.public.temp0000283702 1 0 0 23 brasilia.pg_catalog.pg_depend 2 2 1662 22 rio.pg_catalog.pg_type 33 30 8725 16 rio.public.temp0000283696 1 0 0 16 rio.public.temp0000283670 1 0 0 16 rio.public.temp0000283692 1 0 0 16 rio.public.temp0000283650 1 0 0 16 rio.public.temp0000283680 1 0 0 16 rio.public.temp0000283700 2 0 0 16 rio.public.temp0000283306 1 0 0 16 rio.public.temp0000283524 5 0 0 13 rio.public.temp0000283686 1 0 0 11 rio.public.temp0000283714 1 0 0 11 rio.public.temp0000283654 1 0 0 11 rio.public.temp0000283758 1 0 0 10 rio.public.temp0000282507 1 0 0 7 brasilia.pg_catalog.pg_type 5 5 949 6 rio.pg_catalog.pg_index 19 19 4898 3 brasilia.pg_catalog.pg_index 3 3 348 3 brasilia.pg_catalog.pg_statistic 2 2 4904 0 rio.pg_catalog.pg_statistic 11 11 18941 0 rio.pg_toast.pg_toast_2619 6 6 1428 0 brasilia.pg_catalog.pg_class 6 6 1613 0 brasilia.auditor.auditor_2026_06 1 0 1575 0 contagem.pg_catalog.pg_attribute 4 4 10333 0 brasilia.pg_catalog.pg_attribute 10 10 31576 0 rio.public.temp0000283674 1 0 0 0 rio.public.temp0000283420 3 0 0 0 rio.public.temp0000283744 3 0 0 0 rio.public.tmp_drill_0302 2 2 5929 0 contagem.auditor.auditor_2026_06 1 0 324 0 contagem.pg_toast.pg_toast_2619 1 1 103 0 rio.public.temp0000283746 25 0 0 0 rio.public.tmp_drill_0175 4 2 440 0 contagem.pg_catalog.pg_class 1 1 152 0 postgres.pg_catalog.pg_shdepend 5 5 3662 0 contagem.pg_catalog.pg_index 1 1 39 0 rio.public.temp0000283704 25 0 0 0 contagem.public.usuarios 24 0 1574 0 rio.public.temp0000283748 1 0 0 0 contagem.pg_catalog.pg_statistic 2 2 5285 0 rio.public.temp0000283754 1 0 0 0 rio.public.usuarios 11 5 483 0 rio.public.temp0000283730 3 0 0 0 rio.public.temp0000283740 1 0 0 0 rio.public.temp0000283764 3 0 0 0 rio.pg_catalog.pg_depend 12 12 10535 0 rio.pg_catalog.pg_shdepend 2 2 1244 0 contagem.pg_catalog.pg_type 1 1 223 0 rio.public.temp0000283676 1 0 0 0 brasilia.pg_toast.pg_toast_2619 2 2 184 0 Total 514 229 355,646 2,521 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jun 26 00 0 1 01 0 0 02 0 0 03 0 0 04 1 8 05 6 10 06 1 1 07 40 83 08 91 160 09 54 145 10 56 145 11 53 127 12 7 33 13 20 53 14 48 103 15 85 151 16 37 56 17 6 22 18 1 1 19 0 0 20 0 0 21 7 8 22 0 1 23 1 4 - 9.90 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 8 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 1 16m1s 16m1s 16m1s 16m1s drop table if exists temp0000283780;-
DROP TABLE IF EXISTS temp0000283780;
Date: 2026-06-26 23:39:38 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
DROP TABLE IF EXISTS temp0000283780;
Date: 2026-06-26 23:39:38 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
2 5 9m8s 7s605ms 3m10s 1m49s call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-26 07:38:20 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-26 15:18:06 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-26 08:17:21 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
3 1 1s1ms 1s1ms 1s1ms 1s1ms drop table if exists temp0000283666;-
DROP TABLE IF EXISTS temp0000283666;
Date: 2026-06-26 07:31:44 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
DROP TABLE IF EXISTS temp0000283666;
Date: 2026-06-26 07:32:44 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
DROP TABLE IF EXISTS temp0000283666;
Date: 2026-06-26 07:31:44 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
4 1 1s 1s 1s 1s drop table if exists temp0000283700;-
DROP TABLE IF EXISTS temp0000283700;
Date: 2026-06-26 08:22:44 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
DROP TABLE IF EXISTS temp0000283700;
Date: 2026-06-26 08:22:44 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
Queries that waited the most
Rank Wait time Query 1 16m1s DROP TABLE IF EXISTS temp0000283780;[ Date: 2026-06-26 23:39:38 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 3m10s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-06-26 07:38:19 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 2m58s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-06-26 15:18:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 2m8s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-06-26 08:17:19 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 44s353ms CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-06-26 07:15:51 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 7s605ms CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-06-26 14:35:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 1s1ms DROP TABLE IF EXISTS temp0000283666;[ Date: 2026-06-26 07:31:44 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
8 1s DROP TABLE IF EXISTS temp0000283700;[ Date: 2026-06-26 08:22:44 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 4,828 Total read queries
- 1,756 Total write queries
Queries by database
Key values
- rio Main database
- 5,486 Requests
- 7h47m34s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 6,808 Requests
User Request type Count Duration etiquetas Total 45 9s278ms select 45 9s278ms intelifix Total 6,808 9h47m17s copy to 342 48m43s ddl 1,414 1h22m30s others 387 44m56s select 4,664 6h51m6s lenon Total 119 1m40s select 119 1m40s Duration by user
Key values
- 9h47m17s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 45 9s278ms select 45 9s278ms intelifix Total 6,808 9h47m17s copy to 342 48m43s ddl 1,414 1h22m30s others 387 44m56s select 4,664 6h51m6s lenon Total 119 1m40s select 119 1m40s Queries by host
Key values
- [local] Main host
- 6,972 Requests
- 9h49m7s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 6,000 Requests
- 4h51m54s ([unknown])
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-06-26 07:33:59 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 3,713 100-500ms duration
Slowest individual queries
Rank Duration Query 1 16m1s DROP TABLE IF EXISTS temp0000283780;[ Date: 2026-06-26 23:39:38 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 9m29s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-26 09:14:31 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 8m58s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-26 10:14:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 8m50s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-26 11:13:51 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 8m46s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-26 08:13:48 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 8m42s analyze verbose;[ Date: 2026-06-26 05:08:43 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 8m18s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-26 14:13:19 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 8m3s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-26 07:13:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 8m2s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-26 15:13:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 7m17s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-26 12:12:18 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 7m9s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-26 16:12:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 6m24s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-06-01''),DATE(''2026-06-25'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');[ Date: 2026-06-26 10:26:49 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 6m15s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-26 17:11:17 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 6m12s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-26 20:11:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m52s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-26 21:10:54 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m52s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-26 13:10:53 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m49s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-26 18:10:50 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 5m48s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026237, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-06-26 09:26:15 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 5m41s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026263, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-06-26 14:35:16 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 5m29s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026238, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-06-26 09:37:59 - 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 2h11m23s 313 150ms 6m24s 25s186ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 26 06 1 509ms 509ms 07 24 15m5s 37s725ms 08 44 20m59s 28s633ms 09 30 14m19s 28s665ms 10 48 17m42s 22s125ms 11 33 20m53s 37s994ms 12 6 4m21s 43s601ms 13 16 1m9s 4s327ms 14 34 10m16s 18s121ms 15 38 18m38s 29s435ms 16 27 7m46s 17s280ms 17 11 9s413ms 855ms 18 1 287ms 287ms [ User: intelifix - Total duration: 2h11m23s - Times executed: 313 ]
[ Application: [unknown] - Total duration: 2h11m23s - Times executed: 313 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-06-01''),DATE(''2026-06-25'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-06-26 10:26:49 Duration: 6m24s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026237, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-26 09:26:15 Duration: 5m48s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026263, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-26 14:35:16 Duration: 5m41s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
2 2h3m18s 48 1s303ms 9m29s 2m34s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 26 07 3 8m40s 2m53s 08 3 9m25s 3m8s 09 3 10m5s 3m21s 10 3 9m38s 3m12s 11 3 9m41s 3m13s 12 3 7m46s 2m35s 13 3 6m11s 2m3s 14 3 8m46s 2m55s 15 3 8m32s 2m50s 16 3 7m43s 2m34s 17 3 6m33s 2m11s 18 3 6m5s 2m1s 19 3 5m42s 1m54s 20 3 6m35s 2m11s 21 3 6m8s 2m2s 22 3 5m40s 1m53s [ User: intelifix - Total duration: 2h3m18s - Times executed: 48 ]
[ Application: psql - Total duration: 2h3m18s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-26 09:14:31 Duration: 9m29s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-26 10:14:00 Duration: 8m58s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-26 11:13:51 Duration: 8m50s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
3 1h7m34s 47 192ms 4m28s 1m26s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 26 07 3 5m3s 1m41s 08 3 5m23s 1m47s 09 3 5m23s 1m47s 10 3 5m2s 1m40s 11 2 55s314ms 27s657ms 12 3 4m42s 1m34s 13 3 3m51s 1m17s 14 3 4m39s 1m33s 15 3 4m39s 1m33s 16 3 4m44s 1m34s 17 3 3m53s 1m17s 18 3 3m43s 1m14s 19 3 3m29s 1m9s 20 3 4m26s 1m28s 21 3 3m54s 1m18s 22 3 3m41s 1m13s [ User: intelifix - Total duration: 1h7m34s - Times executed: 47 ]
[ Application: psql - Total duration: 1h7m34s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-26 08:19:44 Duration: 4m28s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-26 09:20:25 Duration: 4m25s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-26 10:19:34 Duration: 4m18s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
4 31m11s 168 1s435ms 58s412ms 11s140ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 26 07 5 1m48s 21s712ms 08 4 1m37s 24s286ms 09 7 2m2s 17s505ms 10 29 3m55s 8s120ms 11 30 4m39s 9s329ms 12 6 30s157ms 5s26ms 13 6 1m36s 16s78ms 14 34 5m19s 9s391ms 15 30 6m53s 13s787ms 16 7 2m1s 17s351ms 17 10 47s51ms 4s705ms [ User: intelifix - Total duration: 31m11s - Times executed: 168 ]
[ Application: [unknown] - Total duration: 31m11s - Times executed: 168 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-26', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-26 14:47:58 Duration: 58s412ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-26', 0173, '', '', 0, 6, '2026-06-01');
Date: 2026-06-26 07:24:39 Duration: 57s465ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-26', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-26 11:20:53 Duration: 55s907ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
5 22m51s 1,563 150ms 5s784ms 877ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 26 07 125 1m7s 539ms 08 234 2m34s 658ms 09 263 3m40s 838ms 10 250 4m16s 1s25ms 11 161 2m29s 929ms 12 38 41s553ms 1s93ms 13 50 57s172ms 1s143ms 14 153 2m54s 1s138ms 15 191 2m42s 849ms 16 73 1m12s 989ms 17 25 16s128ms 645ms [ User: intelifix - Total duration: 22m51s - Times executed: 1563 ]
[ Application: [unknown] - Total duration: 22m51s - Times executed: 1563 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (43991, 413, 'ZTE3A8TRB719416,7C7D21EC31F3$ZTE3A8TT3302140,14200452F472$ZTE3A8TRCB15114,7C7D21ED7D2B$ZTE3A8TRCS07131,7C7D21F01D4F$ZTE3A8TR4H00242,38165A4727B8$ZTE3A8TT3302203,14200452F56E$ZTE3A8TR7907521,E44E12B15A95$ZTE3A8TR4718405,DC5193DC281A$ZTE3A8TT3302085,14200452F396$ZTE3A8TR8U05838,B47CA6080BDA$ZTE3A8TR1M17381,DC5193DAD95A$ZTE3A8TT3305467,14200453286E$ZTE3A8TRCS06031,7C7D21F00C1F$ZTE3A8TR1M18606,DC5193DAEC7E$ZTE3A8TR7R18159,E44E12B38F3D$ZTE3A8TR5U25373,E44E1292EABB$ZTE3A8TR7R18119,E44E12B38E9D$ZTE3A8TT3C03049,142004549116$ZTE3A8TT3R11264,142004569FE2$ZTE3A8TT3C03384,142004549652$ZTE3A8TR6D21752,E44E12B0AA81$ZTE3A8TR6D23528,E44E12B0C641$ZTE3A8TRCS24497,7C7D21F12CA7$ZTE3A8TT3C17699,1420045575FE$ZTE3A8TR6D24205,E44E12B0D0D5$ZTE3A8TR4706146,DC5193DB688E$ZTE3A8TR6D23060,E44E12B0BEF1$ZTE3A8TT3C17701,142004557606$ZTE3A8TT3R11342,14200456A11A$ZTE3A8TT3C17683,1420045575BE$ZTE3A8TR5U24029,E44E1292D5BB$ZTE3A8TQCH14067,DC5193D966D2$ZTE3A8TQCH13890,DC5193D9640E$ZTE3A8TT3302196,14200452F552$ZTE3A8TT3301827,14200452EF8E$ZTE3A8TT3304209,1420045314C6$ZTE3A8TR5U25392,E44E1292EB07$ZTE3A8TR7R06085,E44E12B2D295$ZTE3A8TR6D00089,E44E12AF5805$ZTE3A8TT4724444,14200458FC42$ZTE3A8TRB719448,7C7D21EC3273$ZTE3A8TR8U07765,B47CA60829F6', '',05,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-26 15:49:50 Duration: 5s784ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (43987, 413, 'ZTE3ANNR7B16808,3891484A7697,3891484A7698,ZTEGDB07D308$ZTE3ANNR5W73900,48D6823547D2,48D6823547D3,ZTEGDB0120AB$ZTE3ANNR1Y02198,14CA56CCDDFF,14CA56CCDE00,ZTEGD9707EF1$ZTE3ANNR9F17725,D89A0DA47D51,D89A0DA47D52,ZTEGDB156C88$ZTE3ANNR1Y18011,14CA56CE509D,14CA56CE509E,ZTEGD970BCB6$ZTE3ANNRC552545,6C11BA66F95D,6C11BA66F95E,ZTEGDC6EE300$ZTE3ANNR5W76099,48D682357B5C,48D682357B5D,ZTEGDB012942$ZTE3ANNRAD30241,D89A0DB09F29,D89A0DB09F2A,ZTEGDB17722C$ZTE3ANNR3Y45725,4896D953F066,4896D953F067,ZTEGD97EE352$ZTE3ANNR2Q05980,F4E84F814028,F4E84F814029,ZTEGD97A8A16$ZTE3ANNQ8M42020,843C9922A0C3,843C9922A0C4,ZTEGD7BAEB91$ZTE3ANNR3J07664,F4E84F870200,F4E84F870201,ZTEGD97B7FBA$ZTE3ANNQ7506303,C4EBFF8B86F6,C4EBFF8B86F7,ZTEGD70A673F$ZTE3ANNRB720988,5872C9902519,5872C990251A,ZTEGDC617CCF$ZTE3ANNQ8M44727,843C9922E035,843C9922E036,ZTEGD7BAF624$ZTE3ANNR4N12587,4896D956821A,4896D956821B,ZTEGD97F50F0$ZTE3ANNR7B16984,3891484A7AB7,3891484A7AB8,ZTEGDB07D3B8$ZTE3ANNT2V51970,D831399050E4,D831399050E5,ZTEGDD30BD81$ZTE3ANNQ8M44668,843C9922DED3,843C9922DED4,ZTEGD7BAF5E9$ZTE3ANNQ6305691,3CF9F070298D,3CF9F070298E,ZTEGD52E4CD2$ZTE3ANNRCB24812,D83139201486,D83139201487,ZTEGDD2A1681$ZTE3ANNT2V84790,D8313993521C,D8313993521D,ZTEGDD313DB5$ZTE3ANNR6R28404,48D682381E7A,48D682381E7B,ZTEGDB0199C7$ZTE3ANNRCP67206,6C11BA6F51F3,6C11BA6F51F4,ZTEGDC704719$ZTE3ANNR9W07873,D89A0DA914A9,D89A0DA914AA,ZTEGDB16306C$ZTE3ANNRCP35700,6C11BA6C6F87,6C11BA6C6F88,ZTEGDC6FCC07$ZTE3ANNR9F16604,D89A0DA4630B,D89A0DA4630C,ZTEGDB156827$ZTE3ANNRB713835,5872C98F7D73,5872C98F7D74,ZTEGDC6160DE$ZTE3ANNRCP49416,6C11BA6DB0FF,6C11BA6DB100,ZTEGDC70019B$ZTE3ANNR9344293,D89A0D866E29,D89A0D866E2A,ZTEGDB152104$ZTE3ANNQ3624442,3CF9F0A7124A,3CF9F0A7124B,ZTEGD640C315$ZTE3ANNQ9J21177,843C992DC18B,843C992DC18C,ZTEGD7BB5B64$ZTE3ANNR5W76201,48D682357DC0,48D682357DC1,ZTEGDB0129A8$ZTE3ANNRAD23519,D89A0DB0019D,D89A0DB0019E,ZTEGDB1757EA$ZTE3ANNRC554278,6C11BA6721FB,6C11BA6721FC,ZTEGDC6EE9C5$ZTE3ANNR3Y35525,4896D9530156,4896D9530157,ZTEGD97EBB7A$ZTE3ANNR3J12284,F4E84F876E48,F4E84F876E49,ZTEGD97B91C6$ZTE3ANNR4N10556,4896D9565280,4896D9565281,ZTEGD97F4901$ZTE3ANNQCA03501,14CA56D296E9,14CA56D296EA,ZTEGD9717318', '',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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-26 09:45:53 Duration: 5s615ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (125711, 397, '226307561132', '',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-26 10:38:55 Duration: 5s291ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
6 16m51s 172 154ms 3m15s 5s877ms call rs_giga_triagem (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 26 00 8 27s802ms 3s475ms 01 7 19s532ms 2s790ms 02 6 19s937ms 3s322ms 03 7 20s674ms 2s953ms 04 7 19s692ms 2s813ms 05 6 19s757ms 3s292ms 06 8 20s36ms 2s504ms 07 7 4m18s 36s999ms 08 7 2m31s 21s624ms 09 9 21s931ms 2s436ms 10 8 22s453ms 2s806ms 11 10 19s41ms 1s904ms 12 8 15s343ms 1s917ms 13 7 18s324ms 2s617ms 14 9 26s715ms 2s968ms 15 8 3m19s 24s972ms 16 7 20s20ms 2s860ms 17 6 17s787ms 2s964ms 18 7 17s810ms 2s544ms 19 7 17s735ms 2s533ms 20 8 22s702ms 2s837ms 21 7 16s833ms 2s404ms 22 8 16s728ms 2s91ms [ User: intelifix - Total duration: 16m51s - Times executed: 172 ]
[ Application: psql - Total duration: 16m51s - Times executed: 172 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-26 07:38:20 Duration: 3m15s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-26 15:18:06 Duration: 3m1s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-26 08:17:21 Duration: 2m14s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
7 16m1s 1 16m1s 16m1s 16m1s drop table if exists temp0000283780;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 26 23 1 16m1s 16m1s [ User: intelifix - Total duration: 16m1s - Times executed: 1 ]
[ Application: [unknown] - Total duration: 16m1s - Times executed: 1 ]
-
DROP TABLE IF EXISTS temp0000283780;
Date: 2026-06-26 23:39:38 Duration: 16m1s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
DROP TABLE IF EXISTS temp0000283780;
Date: 2026-06-26 23:39:38 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
8 15m18s 3 2m30s 8m42s 5m6s analyze verbose;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 26 05 3 15m18s 5m6s [ User: intelifix - Total duration: 15m18s - Times executed: 3 ]
[ Application: psql - Total duration: 15m18s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-06-26 05:08:43 Duration: 8m42s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
analyze verbose;
Date: 2026-06-26 05:12:50 Duration: 4m6s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
analyze verbose;
Date: 2026-06-26 05:15:20 Duration: 2m30s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
9 12m38s 62 9s302ms 32s805ms 12s229ms create table temp0000283666 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 26 07 13 2m33s 11s795ms 08 18 3m28s 11s575ms 09 8 2m2s 15s350ms 10 12 2m32s 12s691ms 11 5 55s415ms 11s83ms 12 6 1m5s 10s997ms [ User: intelifix - Total duration: 12m38s - Times executed: 62 ]
[ Application: [unknown] - Total duration: 12m38s - Times executed: 62 ]
-
CREATE TABLE temp0000283666 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-26 09:19:43 Duration: 32s805ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CREATE TABLE temp0000283666 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-26 10:10:16 Duration: 15s16ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CREATE TABLE temp0000283666 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-26 10:34:19 Duration: 14s826ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
10 9m36s 49 9s368ms 13s989ms 11s757ms create table temp0000283746 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 26 13 3 34s999ms 11s666ms 14 17 3m23s 11s972ms 15 25 4m54s 11s776ms 16 4 43s155ms 10s788ms [ User: intelifix - Total duration: 9m36s - Times executed: 49 ]
[ Application: [unknown] - Total duration: 9m36s - Times executed: 49 ]
-
CREATE TABLE temp0000283746 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-26 15:35:47 Duration: 13s989ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CREATE TABLE temp0000283746 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-26 14:48:14 Duration: 13s545ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CREATE TABLE temp0000283746 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-26 14:27:14 Duration: 13s541ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
11 9m29s 1,161 150ms 3s538ms 490ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 26 07 89 36s323ms 408ms 08 148 1m17s 522ms 09 142 1m15s 534ms 10 127 1m6s 524ms 11 204 1m38s 481ms 12 1 530ms 530ms 13 99 38s968ms 393ms 14 118 57s185ms 484ms 15 152 1m21s 539ms 16 69 29s877ms 433ms 17 12 6s55ms 504ms [ User: intelifix - Total duration: 9m29s - Times executed: 1161 ]
[ Application: [unknown] - Total duration: 9m29s - Times executed: 1161 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "241493", "modelo" : "34", "itens" : "216571411332,216574385572,216656066484,184294874647,216484573238,216651245172,216741936570,216569981731,216715332235,216715138703,216742574343", "usuario" : "405", "caixa" : "2878627", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-26 09:39:55 Duration: 3s538ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "227013", "modelo" : "302", "itens" : "CC58300056C3,5447CCE3C3AC,441524E55B9E,9C2472305089,CC58300097EC,20354320F5ED,CC5830FDAAAF,2035435A6D49,D8CF615F485A", "usuario" : "405", "caixa" : "2727539", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-26 10:31:14 Duration: 3s266ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "106328", "modelo" : "454", "itens" : "241632654966,241626489920,241613712938,241625471123,241627303950,241624956874,241626302528,241600597785,241626373848,241611437081,241613379516,241611751636,241612577383,241626635669,241613672631,241613920815,241613295265,241600501335,241613284658,241611305576,241613443136,241613450612,241627146886,241627150625,241627129814,241612778592,241626508888,241627150726,241626505959,241613221420,241624427193,241611323434,241614405867,241600595664,241624425981,241633698692,241613232835,241624629312,241634288201", "usuario" : "405", "caixa" : "1241944", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-26 08:56:54 Duration: 2s704ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
12 7m56s 40 9s867ms 14s659ms 11s920ms create table temp0000283704 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 26 08 14 2m40s 11s466ms 09 2 25s474ms 12s737ms 10 12 2m23s 11s923ms 11 12 2m27s 12s309ms [ User: intelifix - Total duration: 7m56s - Times executed: 40 ]
[ Application: [unknown] - Total duration: 7m56s - Times executed: 40 ]
-
CREATE TABLE temp0000283704 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-26 11:15:13 Duration: 14s659ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CREATE TABLE temp0000283704 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-26 11:11:52 Duration: 14s512ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CREATE TABLE temp0000283704 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-26 10:20:21 Duration: 14s437ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
13 6m11s 155 151ms 11s853ms 2s395ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 26 00 6 19s574ms 3s262ms 01 6 8s983ms 1s497ms 02 6 7s388ms 1s231ms 03 5 7s893ms 1s578ms 04 5 7s231ms 1s446ms 05 4 5s346ms 1s336ms 06 1 1s11ms 1s11ms 07 10 27s549ms 2s754ms 08 12 34s960ms 2s913ms 09 12 33s530ms 2s794ms 10 12 36s65ms 3s5ms 11 12 40s104ms 3s342ms 12 8 22s436ms 2s804ms 13 9 8s984ms 998ms 14 12 37s376ms 3s114ms 15 12 33s346ms 2s778ms 16 8 16s436ms 2s54ms 17 5 2s838ms 567ms 21 4 8s23ms 2s5ms 22 6 12s146ms 2s24ms [ User: intelifix - Total duration: 6m11s - Times executed: 155 ]
[ Application: psql - Total duration: 6m11s - Times executed: 155 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-26 00:05:13 Duration: 11s853ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-26 11:45:09 Duration: 7s752ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-26 16:05:08 Duration: 6s802ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
14 5m35s 27 9s643ms 14s698ms 12s432ms create table temp0000283752 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 26 14 6 1m17s 12s921ms 15 19 3m53s 12s304ms 16 2 24s368ms 12s184ms [ User: intelifix - Total duration: 5m35s - Times executed: 27 ]
[ Application: [unknown] - Total duration: 5m35s - Times executed: 27 ]
-
CREATE TABLE temp0000283752 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-26 15:11:37 Duration: 14s698ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CREATE TABLE temp0000283752 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-26 15:12:43 Duration: 14s625ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CREATE TABLE temp0000283752 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-26 14:28:38 Duration: 14s82ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
15 5m3s 2 790ms 5m2s 2m31s 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 #15
Day Hour Count Duration Avg duration Jun 26 10 1 5m2s 5m2s 17 1 790ms 790ms [ User: intelifix - Total duration: 5m3s - Times executed: 2 ]
[ Application: [unknown] - Total duration: 5m3s - Times executed: 2 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026243, 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-26 10:40:04 Duration: 5m2s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_seriais_expedidos(7,DATE(''2026-06-26''),DATE(''2026-06-26'')) ;', '/var/www/html/tmp/temp_54.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-26 17:39:33 Duration: 790ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
16 4m46s 76 178ms 1m49s 3s775ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 26 07 7 4s767ms 681ms 08 23 15s319ms 666ms 09 4 2s456ms 614ms 10 7 6s510ms 930ms 11 6 2m5s 20s922ms 12 4 1s650ms 412ms 13 1 6s844ms 6s844ms 14 6 17s839ms 2s973ms 15 16 1m42s 6s436ms 16 2 3s45ms 1s522ms [ User: intelifix - Total duration: 4m46s - Times executed: 76 ]
[ Application: psql - Total duration: 4m46s - Times executed: 76 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026248);
Date: 2026-06-26 11:04:05 Duration: 1m49s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026279);
Date: 2026-06-26 15:58:07 Duration: 1m7s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026250);
Date: 2026-06-26 11:15:12 Duration: 13s479ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
17 4m38s 1 4m38s 4m38s 4m38s select * from rs_smart_fiscal_saida () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ 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 26 11 1 4m38s 4m38s [ User: intelifix - Total duration: 4m38s - Times executed: 1 ]
[ Application: psql - Total duration: 4m38s - Times executed: 1 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ 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-26 11:20:01 Duration: 4m38s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
18 3m22s 18 9s881ms 12s441ms 11s276ms create table temp0000283708 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 26 08 18 3m22s 11s276ms [ User: intelifix - Total duration: 3m22s - Times executed: 18 ]
[ Application: [unknown] - Total duration: 3m22s - Times executed: 18 ]
-
CREATE TABLE temp0000283708 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-26 08:34:58 Duration: 12s441ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CREATE TABLE temp0000283708 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-26 08:30:24 Duration: 12s196ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CREATE TABLE temp0000283708 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-26 08:21:20 Duration: 12s178ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
19 2m58s 4 4s940ms 1m27s 44s634ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 26 20 2 1m32s 46s155ms 23 2 1m26s 43s112ms [ User: intelifix - Total duration: 2m58s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m58s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-26 20:08:26 Duration: 1m27s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-26 23:39:13 Duration: 1m21s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-26 23:48:57 Duration: 4s975ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
20 2m11s 32 812ms 13s359ms 4s115ms call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 26 08 2 6s857ms 3s428ms 09 2 7s165ms 3s582ms 10 2 12s432ms 6s216ms 11 3 25s526ms 8s508ms 12 3 4s705ms 1s568ms 13 2 5s178ms 2s589ms 14 1 7s967ms 7s967ms 15 3 23s139ms 7s713ms 16 3 27s600ms 9s200ms 17 2 2s179ms 1s89ms 18 2 2s510ms 1s255ms 19 1 814ms 814ms 20 2 1s754ms 877ms 21 2 1s741ms 870ms 22 2 2s125ms 1s62ms [ User: intelifix - Total duration: 2m11s - Times executed: 32 ]
[ Application: psql - Total duration: 2m11s - Times executed: 32 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-06-26 16:00:15 Duration: 13s359ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-06-26 15:40:14 Duration: 12s133ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-06-26 11:40:12 Duration: 10s492ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,563 22m51s 150ms 5s784ms 877ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 26 07 125 1m7s 539ms 08 234 2m34s 658ms 09 263 3m40s 838ms 10 250 4m16s 1s25ms 11 161 2m29s 929ms 12 38 41s553ms 1s93ms 13 50 57s172ms 1s143ms 14 153 2m54s 1s138ms 15 191 2m42s 849ms 16 73 1m12s 989ms 17 25 16s128ms 645ms [ User: intelifix - Total duration: 22m51s - Times executed: 1563 ]
[ Application: [unknown] - Total duration: 22m51s - Times executed: 1563 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (43991, 413, 'ZTE3A8TRB719416,7C7D21EC31F3$ZTE3A8TT3302140,14200452F472$ZTE3A8TRCB15114,7C7D21ED7D2B$ZTE3A8TRCS07131,7C7D21F01D4F$ZTE3A8TR4H00242,38165A4727B8$ZTE3A8TT3302203,14200452F56E$ZTE3A8TR7907521,E44E12B15A95$ZTE3A8TR4718405,DC5193DC281A$ZTE3A8TT3302085,14200452F396$ZTE3A8TR8U05838,B47CA6080BDA$ZTE3A8TR1M17381,DC5193DAD95A$ZTE3A8TT3305467,14200453286E$ZTE3A8TRCS06031,7C7D21F00C1F$ZTE3A8TR1M18606,DC5193DAEC7E$ZTE3A8TR7R18159,E44E12B38F3D$ZTE3A8TR5U25373,E44E1292EABB$ZTE3A8TR7R18119,E44E12B38E9D$ZTE3A8TT3C03049,142004549116$ZTE3A8TT3R11264,142004569FE2$ZTE3A8TT3C03384,142004549652$ZTE3A8TR6D21752,E44E12B0AA81$ZTE3A8TR6D23528,E44E12B0C641$ZTE3A8TRCS24497,7C7D21F12CA7$ZTE3A8TT3C17699,1420045575FE$ZTE3A8TR6D24205,E44E12B0D0D5$ZTE3A8TR4706146,DC5193DB688E$ZTE3A8TR6D23060,E44E12B0BEF1$ZTE3A8TT3C17701,142004557606$ZTE3A8TT3R11342,14200456A11A$ZTE3A8TT3C17683,1420045575BE$ZTE3A8TR5U24029,E44E1292D5BB$ZTE3A8TQCH14067,DC5193D966D2$ZTE3A8TQCH13890,DC5193D9640E$ZTE3A8TT3302196,14200452F552$ZTE3A8TT3301827,14200452EF8E$ZTE3A8TT3304209,1420045314C6$ZTE3A8TR5U25392,E44E1292EB07$ZTE3A8TR7R06085,E44E12B2D295$ZTE3A8TR6D00089,E44E12AF5805$ZTE3A8TT4724444,14200458FC42$ZTE3A8TRB719448,7C7D21EC3273$ZTE3A8TR8U07765,B47CA60829F6', '',05,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-26 15:49:50 Duration: 5s784ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (43987, 413, 'ZTE3ANNR7B16808,3891484A7697,3891484A7698,ZTEGDB07D308$ZTE3ANNR5W73900,48D6823547D2,48D6823547D3,ZTEGDB0120AB$ZTE3ANNR1Y02198,14CA56CCDDFF,14CA56CCDE00,ZTEGD9707EF1$ZTE3ANNR9F17725,D89A0DA47D51,D89A0DA47D52,ZTEGDB156C88$ZTE3ANNR1Y18011,14CA56CE509D,14CA56CE509E,ZTEGD970BCB6$ZTE3ANNRC552545,6C11BA66F95D,6C11BA66F95E,ZTEGDC6EE300$ZTE3ANNR5W76099,48D682357B5C,48D682357B5D,ZTEGDB012942$ZTE3ANNRAD30241,D89A0DB09F29,D89A0DB09F2A,ZTEGDB17722C$ZTE3ANNR3Y45725,4896D953F066,4896D953F067,ZTEGD97EE352$ZTE3ANNR2Q05980,F4E84F814028,F4E84F814029,ZTEGD97A8A16$ZTE3ANNQ8M42020,843C9922A0C3,843C9922A0C4,ZTEGD7BAEB91$ZTE3ANNR3J07664,F4E84F870200,F4E84F870201,ZTEGD97B7FBA$ZTE3ANNQ7506303,C4EBFF8B86F6,C4EBFF8B86F7,ZTEGD70A673F$ZTE3ANNRB720988,5872C9902519,5872C990251A,ZTEGDC617CCF$ZTE3ANNQ8M44727,843C9922E035,843C9922E036,ZTEGD7BAF624$ZTE3ANNR4N12587,4896D956821A,4896D956821B,ZTEGD97F50F0$ZTE3ANNR7B16984,3891484A7AB7,3891484A7AB8,ZTEGDB07D3B8$ZTE3ANNT2V51970,D831399050E4,D831399050E5,ZTEGDD30BD81$ZTE3ANNQ8M44668,843C9922DED3,843C9922DED4,ZTEGD7BAF5E9$ZTE3ANNQ6305691,3CF9F070298D,3CF9F070298E,ZTEGD52E4CD2$ZTE3ANNRCB24812,D83139201486,D83139201487,ZTEGDD2A1681$ZTE3ANNT2V84790,D8313993521C,D8313993521D,ZTEGDD313DB5$ZTE3ANNR6R28404,48D682381E7A,48D682381E7B,ZTEGDB0199C7$ZTE3ANNRCP67206,6C11BA6F51F3,6C11BA6F51F4,ZTEGDC704719$ZTE3ANNR9W07873,D89A0DA914A9,D89A0DA914AA,ZTEGDB16306C$ZTE3ANNRCP35700,6C11BA6C6F87,6C11BA6C6F88,ZTEGDC6FCC07$ZTE3ANNR9F16604,D89A0DA4630B,D89A0DA4630C,ZTEGDB156827$ZTE3ANNRB713835,5872C98F7D73,5872C98F7D74,ZTEGDC6160DE$ZTE3ANNRCP49416,6C11BA6DB0FF,6C11BA6DB100,ZTEGDC70019B$ZTE3ANNR9344293,D89A0D866E29,D89A0D866E2A,ZTEGDB152104$ZTE3ANNQ3624442,3CF9F0A7124A,3CF9F0A7124B,ZTEGD640C315$ZTE3ANNQ9J21177,843C992DC18B,843C992DC18C,ZTEGD7BB5B64$ZTE3ANNR5W76201,48D682357DC0,48D682357DC1,ZTEGDB0129A8$ZTE3ANNRAD23519,D89A0DB0019D,D89A0DB0019E,ZTEGDB1757EA$ZTE3ANNRC554278,6C11BA6721FB,6C11BA6721FC,ZTEGDC6EE9C5$ZTE3ANNR3Y35525,4896D9530156,4896D9530157,ZTEGD97EBB7A$ZTE3ANNR3J12284,F4E84F876E48,F4E84F876E49,ZTEGD97B91C6$ZTE3ANNR4N10556,4896D9565280,4896D9565281,ZTEGD97F4901$ZTE3ANNQCA03501,14CA56D296E9,14CA56D296EA,ZTEGD9717318', '',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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-26 09:45:53 Duration: 5s615ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (125711, 397, '226307561132', '',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-26 10:38:55 Duration: 5s291ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
2 1,161 9m29s 150ms 3s538ms 490ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 26 07 89 36s323ms 408ms 08 148 1m17s 522ms 09 142 1m15s 534ms 10 127 1m6s 524ms 11 204 1m38s 481ms 12 1 530ms 530ms 13 99 38s968ms 393ms 14 118 57s185ms 484ms 15 152 1m21s 539ms 16 69 29s877ms 433ms 17 12 6s55ms 504ms [ User: intelifix - Total duration: 9m29s - Times executed: 1161 ]
[ Application: [unknown] - Total duration: 9m29s - Times executed: 1161 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "241493", "modelo" : "34", "itens" : "216571411332,216574385572,216656066484,184294874647,216484573238,216651245172,216741936570,216569981731,216715332235,216715138703,216742574343", "usuario" : "405", "caixa" : "2878627", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-26 09:39:55 Duration: 3s538ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "227013", "modelo" : "302", "itens" : "CC58300056C3,5447CCE3C3AC,441524E55B9E,9C2472305089,CC58300097EC,20354320F5ED,CC5830FDAAAF,2035435A6D49,D8CF615F485A", "usuario" : "405", "caixa" : "2727539", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-26 10:31:14 Duration: 3s266ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "106328", "modelo" : "454", "itens" : "241632654966,241626489920,241613712938,241625471123,241627303950,241624956874,241626302528,241600597785,241626373848,241611437081,241613379516,241611751636,241612577383,241626635669,241613672631,241613920815,241613295265,241600501335,241613284658,241611305576,241613443136,241613450612,241627146886,241627150625,241627129814,241612778592,241626508888,241627150726,241626505959,241613221420,241624427193,241611323434,241614405867,241600595664,241624425981,241633698692,241613232835,241624629312,241634288201", "usuario" : "405", "caixa" : "1241944", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-26 08:56:54 Duration: 2s704ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
3 313 2h11m23s 150ms 6m24s 25s186ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 26 06 1 509ms 509ms 07 24 15m5s 37s725ms 08 44 20m59s 28s633ms 09 30 14m19s 28s665ms 10 48 17m42s 22s125ms 11 33 20m53s 37s994ms 12 6 4m21s 43s601ms 13 16 1m9s 4s327ms 14 34 10m16s 18s121ms 15 38 18m38s 29s435ms 16 27 7m46s 17s280ms 17 11 9s413ms 855ms 18 1 287ms 287ms [ User: intelifix - Total duration: 2h11m23s - Times executed: 313 ]
[ Application: [unknown] - Total duration: 2h11m23s - Times executed: 313 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-06-01''),DATE(''2026-06-25'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-06-26 10:26:49 Duration: 6m24s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026237, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-26 09:26:15 Duration: 5m48s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026263, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-26 14:35:16 Duration: 5m41s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
4 172 16m51s 154ms 3m15s 5s877ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 26 00 8 27s802ms 3s475ms 01 7 19s532ms 2s790ms 02 6 19s937ms 3s322ms 03 7 20s674ms 2s953ms 04 7 19s692ms 2s813ms 05 6 19s757ms 3s292ms 06 8 20s36ms 2s504ms 07 7 4m18s 36s999ms 08 7 2m31s 21s624ms 09 9 21s931ms 2s436ms 10 8 22s453ms 2s806ms 11 10 19s41ms 1s904ms 12 8 15s343ms 1s917ms 13 7 18s324ms 2s617ms 14 9 26s715ms 2s968ms 15 8 3m19s 24s972ms 16 7 20s20ms 2s860ms 17 6 17s787ms 2s964ms 18 7 17s810ms 2s544ms 19 7 17s735ms 2s533ms 20 8 22s702ms 2s837ms 21 7 16s833ms 2s404ms 22 8 16s728ms 2s91ms [ User: intelifix - Total duration: 16m51s - Times executed: 172 ]
[ Application: psql - Total duration: 16m51s - Times executed: 172 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-26 07:38:20 Duration: 3m15s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-26 15:18:06 Duration: 3m1s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-26 08:17:21 Duration: 2m14s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
5 168 31m11s 1s435ms 58s412ms 11s140ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 26 07 5 1m48s 21s712ms 08 4 1m37s 24s286ms 09 7 2m2s 17s505ms 10 29 3m55s 8s120ms 11 30 4m39s 9s329ms 12 6 30s157ms 5s26ms 13 6 1m36s 16s78ms 14 34 5m19s 9s391ms 15 30 6m53s 13s787ms 16 7 2m1s 17s351ms 17 10 47s51ms 4s705ms [ User: intelifix - Total duration: 31m11s - Times executed: 168 ]
[ Application: [unknown] - Total duration: 31m11s - Times executed: 168 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-26', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-26 14:47:58 Duration: 58s412ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-26', 0173, '', '', 0, 6, '2026-06-01');
Date: 2026-06-26 07:24:39 Duration: 57s465ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-26', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-26 11:20:53 Duration: 55s907ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
6 155 6m11s 151ms 11s853ms 2s395ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 26 00 6 19s574ms 3s262ms 01 6 8s983ms 1s497ms 02 6 7s388ms 1s231ms 03 5 7s893ms 1s578ms 04 5 7s231ms 1s446ms 05 4 5s346ms 1s336ms 06 1 1s11ms 1s11ms 07 10 27s549ms 2s754ms 08 12 34s960ms 2s913ms 09 12 33s530ms 2s794ms 10 12 36s65ms 3s5ms 11 12 40s104ms 3s342ms 12 8 22s436ms 2s804ms 13 9 8s984ms 998ms 14 12 37s376ms 3s114ms 15 12 33s346ms 2s778ms 16 8 16s436ms 2s54ms 17 5 2s838ms 567ms 21 4 8s23ms 2s5ms 22 6 12s146ms 2s24ms [ User: intelifix - Total duration: 6m11s - Times executed: 155 ]
[ Application: psql - Total duration: 6m11s - Times executed: 155 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-26 00:05:13 Duration: 11s853ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-26 11:45:09 Duration: 7s752ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-26 16:05:08 Duration: 6s802ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
7 143 23s471ms 150ms 232ms 164ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 26 04 2 317ms 158ms 07 17 2s761ms 162ms 08 11 1s794ms 163ms 09 24 4s74ms 169ms 10 10 1s578ms 157ms 11 19 3s66ms 161ms 12 3 494ms 164ms 13 13 2s132ms 164ms 14 12 1s941ms 161ms 15 26 4s310ms 165ms 16 6 1s 166ms [ User: intelifix - Total duration: 23s471ms - Times executed: 143 ]
[ Application: [unknown] - Total duration: 23s471ms - Times executed: 143 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0295;
Date: 2026-06-26 09:06:19 Duration: 232ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0287;
Date: 2026-06-26 09:08:03 Duration: 199ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0154;
Date: 2026-06-26 15:39:17 Duration: 195ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
8 119 34s721ms 150ms 13s160ms 291ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 26 04 1 154ms 154ms 06 1 679ms 679ms 07 1 314ms 314ms 08 1 168ms 168ms 09 2 376ms 188ms 10 5 938ms 187ms 11 11 1s815ms 165ms 12 9 1s519ms 168ms 13 4 707ms 176ms 14 17 2s867ms 168ms 15 46 21s239ms 461ms 16 20 3s733ms 186ms 17 1 208ms 208ms [ User: intelifix - Total duration: 34s721ms - Times executed: 119 ]
[ Application: [unknown] - Total duration: 34s721ms - Times executed: 119 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "0", "data-de" : "2026-06-26", "data-ate" : "2026-06-26", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "0", "usuario" : 506 }');
Date: 2026-06-26 15:51:44 Duration: 13s160ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "362", "data-de" : "2026-06-25", "data-ate" : "2026-06-25", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 415 }');
Date: 2026-06-26 06:58:54 Duration: 679ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
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-26 07:13:23 Duration: 314ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
9 118 47s587ms 217ms 905ms 403ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 26 07 6 2s141ms 356ms 08 21 8s215ms 391ms 09 7 3s153ms 450ms 10 13 4s744ms 364ms 11 21 9s186ms 437ms 12 3 1s492ms 497ms 13 3 1s206ms 402ms 14 11 4s261ms 387ms 15 22 8s579ms 389ms 16 4 1s965ms 491ms 17 7 2s641ms 377ms [ User: intelifix - Total duration: 47s587ms - Times executed: 118 ]
[ Application: [unknown] - Total duration: 47s587ms - Times executed: 118 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-06-26 09:18:08 Duration: 905ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-06-26 12:16:39 Duration: 746ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 054;
Date: 2026-06-26 11:40:19 Duration: 718ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
10 113 52s71ms 265ms 763ms 460ms 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 #10
Day Hour Count Duration Avg duration Jun 26 01 2 766ms 383ms 03 1 396ms 396ms 04 2 778ms 389ms 05 3 1s352ms 450ms 06 1 358ms 358ms 07 10 4s446ms 444ms 08 11 5s298ms 481ms 09 12 5s873ms 489ms 10 10 4s678ms 467ms 11 9 4s56ms 450ms 12 4 1s787ms 446ms 13 10 4s717ms 471ms 14 11 5s801ms 527ms 15 14 6s56ms 432ms 16 4 1s920ms 480ms 17 4 1s805ms 451ms 18 1 383ms 383ms 21 1 404ms 404ms 22 1 378ms 378ms 23 2 807ms 403ms [ User: lenon - Total duration: 52s71ms - Times executed: 113 ]
[ Application: [unknown] - Total duration: 52s71ms - Times executed: 113 ]
-
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-26 14:52:41 Duration: 763ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-06-26 09:56:31 Duration: 761ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-06-26 14:15:31 Duration: 741ms Database: contagem User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-26.log
11 112 24s157ms 150ms 474ms 215ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 26 04 13 4s516ms 347ms 05 9 2s391ms 265ms 07 15 2s827ms 188ms 08 10 2s105ms 210ms 09 12 2s527ms 210ms 10 13 2s330ms 179ms 11 8 1s389ms 173ms 12 4 624ms 156ms 13 3 550ms 183ms 14 8 1s532ms 191ms 15 12 2s422ms 201ms 16 4 759ms 189ms 17 1 179ms 179ms [ User: intelifix - Total duration: 24s157ms - Times executed: 112 ]
[ Application: [unknown] - Total duration: 24s157ms - Times executed: 112 ]
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '229874702833,229894975866,229905359203,229875342424,229863392829,229907716380,229869226069,229863105573,229907829499,229863366990,229869812749,229885850723,229873945071,229874974352,229877199798,229869727588,229885780312,229869913645,229874872850,229885349203', NULL, NULL, 0190, 00);
Date: 2026-06-26 04:24:38 Duration: 474ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_TRIAGEM (428, 5, '73', 2, '229875231224,229874960412,229877517989,229872147981,229913303839,229875501531,229905057983,229874937681,229907926883,229895172025,229884970929,229863529610,229863804564,229905697395,229876893451,229905615670', NULL, NULL, 0190, 00);
Date: 2026-06-26 04:15:57 Duration: 450ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_TRIAGEM (428, 5, '73', 2, '229913304546,229874404970,229877201719,229875662837,229862581830,229872128888,229894982534,229872287692,229877007782,229885914870,229875810203,229873121523,229905512024,229863523145,229863161920,229862543846', NULL, NULL, 0190, 00);
Date: 2026-06-26 04:14:00 Duration: 441ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
12 109 1m31s 162ms 13s677ms 842ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 26 07 11 4s614ms 419ms 08 12 5s195ms 432ms 09 9 37s548ms 4s172ms 10 20 12s478ms 623ms 11 5 4s729ms 945ms 13 12 6s862ms 571ms 14 18 9s477ms 526ms 15 6 2s689ms 448ms 16 15 7s545ms 503ms 17 1 739ms 739ms [ User: intelifix - Total duration: 1m31s - Times executed: 109 ]
[ Application: [unknown] - Total duration: 1m31s - Times executed: 109 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (042960) LIMIT 1;
Date: 2026-06-26 09:43:23 Duration: 13s677ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (042959) LIMIT 1;
Date: 2026-06-26 09:43:00 Duration: 10s660ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (043764) LIMIT 1;
Date: 2026-06-26 09:43:58 Duration: 3s675ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
13 103 58s287ms 182ms 936ms 565ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 26 01 2 1s233ms 616ms 03 1 554ms 554ms 04 2 1s35ms 517ms 05 3 1s720ms 573ms 07 8 4s439ms 554ms 08 9 4s723ms 524ms 09 12 6s922ms 576ms 10 10 5s733ms 573ms 11 8 4s275ms 534ms 12 4 2s147ms 536ms 13 9 5s333ms 592ms 14 10 6s327ms 632ms 15 14 7s411ms 529ms 16 4 2s351ms 587ms 17 4 2s280ms 570ms 18 1 548ms 548ms 22 1 523ms 523ms 23 1 724ms 724ms [ User: intelifix - Total duration: 58s287ms - Times executed: 103 ]
[ Application: [unknown] - Total duration: 58s287ms - Times executed: 103 ]
-
select * from rs_menu_grants (404, 57, 1);
Date: 2026-06-26 14:52:41 Duration: 936ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
select * from rs_menu_grants (418, 18, 1);
Date: 2026-06-26 14:15:31 Duration: 921ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
select * from rs_menu_grants (418, 19, 1);
Date: 2026-06-26 09:56:31 Duration: 843ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
14 86 48s603ms 167ms 5s448ms 565ms create table temp0000283306 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 26 07 6 7s245ms 1s207ms 08 11 3s855ms 350ms 09 16 8s437ms 527ms 10 5 2s754ms 550ms 11 13 6s662ms 512ms 12 5 2s926ms 585ms 13 5 2s545ms 509ms 14 24 14s9ms 583ms 15 1 167ms 167ms [ User: intelifix - Total duration: 48s603ms - Times executed: 86 ]
[ Application: [unknown] - Total duration: 48s603ms - Times executed: 86 ]
-
CREATE TABLE temp0000283306 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"21-06-2026", "ate" :"26-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-26 07:02:29 Duration: 5s448ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CREATE TABLE temp0000283306 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"21-06-2026", "ate" :"26-06-2026", "nota-fiscal":"80242", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-26 10:30:24 Duration: 759ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CREATE TABLE temp0000283306 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"21-06-2026", "ate" :"26-06-2026", "nota-fiscal":"80242", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-26 12:01:41 Duration: 754ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
15 85 42s596ms 151ms 14s119ms 501ms create table temp0000283676 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 26 07 3 4s856ms 1s618ms 08 7 1s834ms 262ms 09 22 4s808ms 218ms 10 29 6s617ms 228ms 11 8 1s793ms 224ms 14 6 20s887ms 3s481ms 15 10 1s796ms 179ms [ User: intelifix - Total duration: 42s596ms - Times executed: 85 ]
[ Application: [unknown] - Total duration: 42s596ms - Times executed: 85 ]
-
CREATE TABLE temp0000283676 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"21-06-2026", "ate" :"26-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-26 14:21:21 Duration: 14s119ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CREATE TABLE temp0000283676 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"21-06-2026", "ate" :"26-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-26 14:22:04 Duration: 6s9ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CREATE TABLE temp0000283676 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"21-06-2026", "ate" :"26-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-26 07:16:42 Duration: 4s553ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
16 85 39s783ms 154ms 1s97ms 468ms select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 26 08 33 19s1ms 575ms 09 31 13s112ms 422ms 10 11 3s841ms 349ms 15 10 3s827ms 382ms [ User: intelifix - Total duration: 39s783ms - Times executed: 85 ]
[ Application: [unknown] - Total duration: 39s783ms - Times executed: 85 ]
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (103107);
Date: 2026-06-26 08:57:51 Duration: 1s97ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (103107);
Date: 2026-06-26 08:58:27 Duration: 1s9ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (103107);
Date: 2026-06-26 08:58:49 Duration: 931ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
17 76 4m46s 178ms 1m49s 3s775ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 26 07 7 4s767ms 681ms 08 23 15s319ms 666ms 09 4 2s456ms 614ms 10 7 6s510ms 930ms 11 6 2m5s 20s922ms 12 4 1s650ms 412ms 13 1 6s844ms 6s844ms 14 6 17s839ms 2s973ms 15 16 1m42s 6s436ms 16 2 3s45ms 1s522ms [ User: intelifix - Total duration: 4m46s - Times executed: 76 ]
[ Application: psql - Total duration: 4m46s - Times executed: 76 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026248);
Date: 2026-06-26 11:04:05 Duration: 1m49s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026279);
Date: 2026-06-26 15:58:07 Duration: 1m7s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026250);
Date: 2026-06-26 11:15:12 Duration: 13s479ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
18 69 1m1s 154ms 15s445ms 885ms create table temp0000283652 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 26 07 6 7s711ms 1s285ms 08 28 13s10ms 464ms 09 12 13s924ms 1s160ms 10 15 2s868ms 191ms 11 7 16s757ms 2s393ms 12 1 6s838ms 6s838ms [ User: intelifix - Total duration: 1m1s - Times executed: 69 ]
[ Application: [unknown] - Total duration: 1m1s - Times executed: 69 ]
-
CREATE TABLE temp0000283652 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"21-06-2026", "ate" :"26-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-26 11:36:11 Duration: 15s445ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CREATE TABLE temp0000283652 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"21-06-2026", "ate" :"26-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-26 12:12:27 Duration: 6s838ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CREATE TABLE temp0000283652 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"21-06-2026", "ate" :"26-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-26 09:27:09 Duration: 6s100ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
19 67 13s967ms 152ms 345ms 208ms create table temp0000283420 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 26 07 11 2s267ms 206ms 08 3 571ms 190ms 09 17 3s669ms 215ms 10 8 1s662ms 207ms 11 4 1s97ms 274ms 12 3 831ms 277ms 13 3 601ms 200ms 14 8 1s450ms 181ms 15 10 1s814ms 181ms [ User: intelifix - Total duration: 13s967ms - Times executed: 67 ]
[ Application: [unknown] - Total duration: 13s967ms - Times executed: 67 ]
-
CREATE TABLE temp0000283420 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"21-06-2026", "ate" :"26-06-2026", "nota-fiscal":"1534", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-26 11:39:22 Duration: 345ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CREATE TABLE temp0000283420 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"21-06-2026", "ate" :"26-06-2026", "nota-fiscal":"1534", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-26 12:04:43 Duration: 306ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CREATE TABLE temp0000283420 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"21-06-2026", "ate" :"26-06-2026", "nota-fiscal":"1534", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-26 14:02:49 Duration: 300ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
20 64 51s69ms 307ms 19s87ms 797ms create table temp0000283650 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 26 06 1 19s87ms 19s87ms 07 10 4s158ms 415ms 08 5 2s44ms 408ms 09 7 3s565ms 509ms 10 17 8s622ms 507ms 11 22 12s758ms 579ms 12 2 832ms 416ms [ User: intelifix - Total duration: 51s69ms - Times executed: 64 ]
[ Application: [unknown] - Total duration: 51s69ms - Times executed: 64 ]
-
CREATE TABLE temp0000283650 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"21-06-2026", "ate" :"26-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-26 06:51:49 Duration: 19s87ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CREATE TABLE temp0000283650 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"21-06-2026", "ate" :"26-06-2026", "nota-fiscal":"80242", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-26 11:26:20 Duration: 969ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CREATE TABLE temp0000283650 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"21-06-2026", "ate" :"26-06-2026", "nota-fiscal":"80242", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-26 11:05:26 Duration: 825ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 16m1s 16m1s 16m1s 1 16m1s drop table if exists temp0000283780;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 26 23 1 16m1s 16m1s [ User: intelifix - Total duration: 16m1s - Times executed: 1 ]
[ Application: [unknown] - Total duration: 16m1s - Times executed: 1 ]
-
DROP TABLE IF EXISTS temp0000283780;
Date: 2026-06-26 23:39:38 Duration: 16m1s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
DROP TABLE IF EXISTS temp0000283780;
Date: 2026-06-26 23:39:38 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
2 2m30s 8m42s 5m6s 3 15m18s analyze verbose;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 26 05 3 15m18s 5m6s [ User: intelifix - Total duration: 15m18s - Times executed: 3 ]
[ Application: psql - Total duration: 15m18s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-06-26 05:08:43 Duration: 8m42s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
analyze verbose;
Date: 2026-06-26 05:12:50 Duration: 4m6s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
analyze verbose;
Date: 2026-06-26 05:15:20 Duration: 2m30s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
3 4m38s 4m38s 4m38s 1 4m38s select * from rs_smart_fiscal_saida () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ 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 #3
Day Hour Count Duration Avg duration Jun 26 11 1 4m38s 4m38s [ User: intelifix - Total duration: 4m38s - Times executed: 1 ]
[ Application: psql - Total duration: 4m38s - Times executed: 1 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ 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-26 11:20:01 Duration: 4m38s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
4 1s303ms 9m29s 2m34s 48 2h3m18s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 26 07 3 8m40s 2m53s 08 3 9m25s 3m8s 09 3 10m5s 3m21s 10 3 9m38s 3m12s 11 3 9m41s 3m13s 12 3 7m46s 2m35s 13 3 6m11s 2m3s 14 3 8m46s 2m55s 15 3 8m32s 2m50s 16 3 7m43s 2m34s 17 3 6m33s 2m11s 18 3 6m5s 2m1s 19 3 5m42s 1m54s 20 3 6m35s 2m11s 21 3 6m8s 2m2s 22 3 5m40s 1m53s [ User: intelifix - Total duration: 2h3m18s - Times executed: 48 ]
[ Application: psql - Total duration: 2h3m18s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-26 09:14:31 Duration: 9m29s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-26 10:14:00 Duration: 8m58s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-26 11:13:51 Duration: 8m50s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
5 790ms 5m2s 2m31s 2 5m3s 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 #5
Day Hour Count Duration Avg duration Jun 26 10 1 5m2s 5m2s 17 1 790ms 790ms [ User: intelifix - Total duration: 5m3s - Times executed: 2 ]
[ Application: [unknown] - Total duration: 5m3s - Times executed: 2 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026243, 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-26 10:40:04 Duration: 5m2s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_seriais_expedidos(7,DATE(''2026-06-26''),DATE(''2026-06-26'')) ;', '/var/www/html/tmp/temp_54.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-26 17:39:33 Duration: 790ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
6 192ms 4m28s 1m26s 47 1h7m34s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 26 07 3 5m3s 1m41s 08 3 5m23s 1m47s 09 3 5m23s 1m47s 10 3 5m2s 1m40s 11 2 55s314ms 27s657ms 12 3 4m42s 1m34s 13 3 3m51s 1m17s 14 3 4m39s 1m33s 15 3 4m39s 1m33s 16 3 4m44s 1m34s 17 3 3m53s 1m17s 18 3 3m43s 1m14s 19 3 3m29s 1m9s 20 3 4m26s 1m28s 21 3 3m54s 1m18s 22 3 3m41s 1m13s [ User: intelifix - Total duration: 1h7m34s - Times executed: 47 ]
[ Application: psql - Total duration: 1h7m34s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-26 08:19:44 Duration: 4m28s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-26 09:20:25 Duration: 4m25s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-26 10:19:34 Duration: 4m18s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
7 4s940ms 1m27s 44s634ms 4 2m58s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 26 20 2 1m32s 46s155ms 23 2 1m26s 43s112ms [ User: intelifix - Total duration: 2m58s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m58s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-26 20:08:26 Duration: 1m27s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-26 23:39:13 Duration: 1m21s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-26 23:48:57 Duration: 4s975ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-26.log
8 150ms 6m24s 25s186ms 313 2h11m23s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 26 06 1 509ms 509ms 07 24 15m5s 37s725ms 08 44 20m59s 28s633ms 09 30 14m19s 28s665ms 10 48 17m42s 22s125ms 11 33 20m53s 37s994ms 12 6 4m21s 43s601ms 13 16 1m9s 4s327ms 14 34 10m16s 18s121ms 15 38 18m38s 29s435ms 16 27 7m46s 17s280ms 17 11 9s413ms 855ms 18 1 287ms 287ms [ User: intelifix - Total duration: 2h11m23s - Times executed: 313 ]
[ Application: [unknown] - Total duration: 2h11m23s - Times executed: 313 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-06-01''),DATE(''2026-06-25'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-06-26 10:26:49 Duration: 6m24s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026237, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-26 09:26:15 Duration: 5m48s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026263, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-26 14:35:16 Duration: 5m41s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
9 9s643ms 14s698ms 12s432ms 27 5m35s create table temp0000283752 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 26 14 6 1m17s 12s921ms 15 19 3m53s 12s304ms 16 2 24s368ms 12s184ms [ User: intelifix - Total duration: 5m35s - Times executed: 27 ]
[ Application: [unknown] - Total duration: 5m35s - Times executed: 27 ]
-
CREATE TABLE temp0000283752 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-26 15:11:37 Duration: 14s698ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CREATE TABLE temp0000283752 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-26 15:12:43 Duration: 14s625ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CREATE TABLE temp0000283752 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-26 14:28:38 Duration: 14s82ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
10 9s302ms 32s805ms 12s229ms 62 12m38s create table temp0000283666 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 26 07 13 2m33s 11s795ms 08 18 3m28s 11s575ms 09 8 2m2s 15s350ms 10 12 2m32s 12s691ms 11 5 55s415ms 11s83ms 12 6 1m5s 10s997ms [ User: intelifix - Total duration: 12m38s - Times executed: 62 ]
[ Application: [unknown] - Total duration: 12m38s - Times executed: 62 ]
-
CREATE TABLE temp0000283666 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-26 09:19:43 Duration: 32s805ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CREATE TABLE temp0000283666 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-26 10:10:16 Duration: 15s16ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CREATE TABLE temp0000283666 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-26 10:34:19 Duration: 14s826ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
11 9s867ms 14s659ms 11s920ms 40 7m56s create table temp0000283704 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 26 08 14 2m40s 11s466ms 09 2 25s474ms 12s737ms 10 12 2m23s 11s923ms 11 12 2m27s 12s309ms [ User: intelifix - Total duration: 7m56s - Times executed: 40 ]
[ Application: [unknown] - Total duration: 7m56s - Times executed: 40 ]
-
CREATE TABLE temp0000283704 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-26 11:15:13 Duration: 14s659ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CREATE TABLE temp0000283704 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-26 11:11:52 Duration: 14s512ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CREATE TABLE temp0000283704 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-26 10:20:21 Duration: 14s437ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
12 9s368ms 13s989ms 11s757ms 49 9m36s create table temp0000283746 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 26 13 3 34s999ms 11s666ms 14 17 3m23s 11s972ms 15 25 4m54s 11s776ms 16 4 43s155ms 10s788ms [ User: intelifix - Total duration: 9m36s - Times executed: 49 ]
[ Application: [unknown] - Total duration: 9m36s - Times executed: 49 ]
-
CREATE TABLE temp0000283746 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-26 15:35:47 Duration: 13s989ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CREATE TABLE temp0000283746 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-26 14:48:14 Duration: 13s545ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CREATE TABLE temp0000283746 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-26 14:27:14 Duration: 13s541ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
13 9s881ms 12s441ms 11s276ms 18 3m22s create table temp0000283708 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 26 08 18 3m22s 11s276ms [ User: intelifix - Total duration: 3m22s - Times executed: 18 ]
[ Application: [unknown] - Total duration: 3m22s - Times executed: 18 ]
-
CREATE TABLE temp0000283708 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-26 08:34:58 Duration: 12s441ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CREATE TABLE temp0000283708 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-26 08:30:24 Duration: 12s196ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CREATE TABLE temp0000283708 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-26 08:21:20 Duration: 12s178ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
14 1s435ms 58s412ms 11s140ms 168 31m11s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 26 07 5 1m48s 21s712ms 08 4 1m37s 24s286ms 09 7 2m2s 17s505ms 10 29 3m55s 8s120ms 11 30 4m39s 9s329ms 12 6 30s157ms 5s26ms 13 6 1m36s 16s78ms 14 34 5m19s 9s391ms 15 30 6m53s 13s787ms 16 7 2m1s 17s351ms 17 10 47s51ms 4s705ms [ User: intelifix - Total duration: 31m11s - Times executed: 168 ]
[ Application: [unknown] - Total duration: 31m11s - Times executed: 168 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-26', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-26 14:47:58 Duration: 58s412ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-26', 0173, '', '', 0, 6, '2026-06-01');
Date: 2026-06-26 07:24:39 Duration: 57s465ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-26', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-26 11:20:53 Duration: 55s907ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
15 154ms 3m15s 5s877ms 172 16m51s call rs_giga_triagem (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 26 00 8 27s802ms 3s475ms 01 7 19s532ms 2s790ms 02 6 19s937ms 3s322ms 03 7 20s674ms 2s953ms 04 7 19s692ms 2s813ms 05 6 19s757ms 3s292ms 06 8 20s36ms 2s504ms 07 7 4m18s 36s999ms 08 7 2m31s 21s624ms 09 9 21s931ms 2s436ms 10 8 22s453ms 2s806ms 11 10 19s41ms 1s904ms 12 8 15s343ms 1s917ms 13 7 18s324ms 2s617ms 14 9 26s715ms 2s968ms 15 8 3m19s 24s972ms 16 7 20s20ms 2s860ms 17 6 17s787ms 2s964ms 18 7 17s810ms 2s544ms 19 7 17s735ms 2s533ms 20 8 22s702ms 2s837ms 21 7 16s833ms 2s404ms 22 8 16s728ms 2s91ms [ User: intelifix - Total duration: 16m51s - Times executed: 172 ]
[ Application: psql - Total duration: 16m51s - Times executed: 172 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-26 07:38:20 Duration: 3m15s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-26 15:18:06 Duration: 3m1s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-26 08:17:21 Duration: 2m14s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
16 812ms 13s359ms 4s115ms 32 2m11s call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 26 08 2 6s857ms 3s428ms 09 2 7s165ms 3s582ms 10 2 12s432ms 6s216ms 11 3 25s526ms 8s508ms 12 3 4s705ms 1s568ms 13 2 5s178ms 2s589ms 14 1 7s967ms 7s967ms 15 3 23s139ms 7s713ms 16 3 27s600ms 9s200ms 17 2 2s179ms 1s89ms 18 2 2s510ms 1s255ms 19 1 814ms 814ms 20 2 1s754ms 877ms 21 2 1s741ms 870ms 22 2 2s125ms 1s62ms [ User: intelifix - Total duration: 2m11s - Times executed: 32 ]
[ Application: psql - Total duration: 2m11s - Times executed: 32 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-06-26 16:00:15 Duration: 13s359ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-06-26 15:40:14 Duration: 12s133ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-06-26 11:40:12 Duration: 10s492ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
17 178ms 1m49s 3s775ms 76 4m46s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 26 07 7 4s767ms 681ms 08 23 15s319ms 666ms 09 4 2s456ms 614ms 10 7 6s510ms 930ms 11 6 2m5s 20s922ms 12 4 1s650ms 412ms 13 1 6s844ms 6s844ms 14 6 17s839ms 2s973ms 15 16 1m42s 6s436ms 16 2 3s45ms 1s522ms [ User: intelifix - Total duration: 4m46s - Times executed: 76 ]
[ Application: psql - Total duration: 4m46s - Times executed: 76 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026248);
Date: 2026-06-26 11:04:05 Duration: 1m49s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026279);
Date: 2026-06-26 15:58:07 Duration: 1m7s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026250);
Date: 2026-06-26 11:15:12 Duration: 13s479ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
18 151ms 11s853ms 2s395ms 155 6m11s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 26 00 6 19s574ms 3s262ms 01 6 8s983ms 1s497ms 02 6 7s388ms 1s231ms 03 5 7s893ms 1s578ms 04 5 7s231ms 1s446ms 05 4 5s346ms 1s336ms 06 1 1s11ms 1s11ms 07 10 27s549ms 2s754ms 08 12 34s960ms 2s913ms 09 12 33s530ms 2s794ms 10 12 36s65ms 3s5ms 11 12 40s104ms 3s342ms 12 8 22s436ms 2s804ms 13 9 8s984ms 998ms 14 12 37s376ms 3s114ms 15 12 33s346ms 2s778ms 16 8 16s436ms 2s54ms 17 5 2s838ms 567ms 21 4 8s23ms 2s5ms 22 6 12s146ms 2s24ms [ User: intelifix - Total duration: 6m11s - Times executed: 155 ]
[ Application: psql - Total duration: 6m11s - Times executed: 155 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-26 00:05:13 Duration: 11s853ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-26 11:45:09 Duration: 7s752ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-26 16:05:08 Duration: 6s802ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-26.log
19 154ms 15s445ms 885ms 69 1m1s create table temp0000283652 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 26 07 6 7s711ms 1s285ms 08 28 13s10ms 464ms 09 12 13s924ms 1s160ms 10 15 2s868ms 191ms 11 7 16s757ms 2s393ms 12 1 6s838ms 6s838ms [ User: intelifix - Total duration: 1m1s - Times executed: 69 ]
[ Application: [unknown] - Total duration: 1m1s - Times executed: 69 ]
-
CREATE TABLE temp0000283652 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"21-06-2026", "ate" :"26-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-26 11:36:11 Duration: 15s445ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CREATE TABLE temp0000283652 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"21-06-2026", "ate" :"26-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-26 12:12:27 Duration: 6s838ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
CREATE TABLE temp0000283652 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"21-06-2026", "ate" :"26-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-26 09:27:09 Duration: 6s100ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
20 150ms 5s784ms 877ms 1,563 22m51s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 26 07 125 1m7s 539ms 08 234 2m34s 658ms 09 263 3m40s 838ms 10 250 4m16s 1s25ms 11 161 2m29s 929ms 12 38 41s553ms 1s93ms 13 50 57s172ms 1s143ms 14 153 2m54s 1s138ms 15 191 2m42s 849ms 16 73 1m12s 989ms 17 25 16s128ms 645ms [ User: intelifix - Total duration: 22m51s - Times executed: 1563 ]
[ Application: [unknown] - Total duration: 22m51s - Times executed: 1563 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (43991, 413, 'ZTE3A8TRB719416,7C7D21EC31F3$ZTE3A8TT3302140,14200452F472$ZTE3A8TRCB15114,7C7D21ED7D2B$ZTE3A8TRCS07131,7C7D21F01D4F$ZTE3A8TR4H00242,38165A4727B8$ZTE3A8TT3302203,14200452F56E$ZTE3A8TR7907521,E44E12B15A95$ZTE3A8TR4718405,DC5193DC281A$ZTE3A8TT3302085,14200452F396$ZTE3A8TR8U05838,B47CA6080BDA$ZTE3A8TR1M17381,DC5193DAD95A$ZTE3A8TT3305467,14200453286E$ZTE3A8TRCS06031,7C7D21F00C1F$ZTE3A8TR1M18606,DC5193DAEC7E$ZTE3A8TR7R18159,E44E12B38F3D$ZTE3A8TR5U25373,E44E1292EABB$ZTE3A8TR7R18119,E44E12B38E9D$ZTE3A8TT3C03049,142004549116$ZTE3A8TT3R11264,142004569FE2$ZTE3A8TT3C03384,142004549652$ZTE3A8TR6D21752,E44E12B0AA81$ZTE3A8TR6D23528,E44E12B0C641$ZTE3A8TRCS24497,7C7D21F12CA7$ZTE3A8TT3C17699,1420045575FE$ZTE3A8TR6D24205,E44E12B0D0D5$ZTE3A8TR4706146,DC5193DB688E$ZTE3A8TR6D23060,E44E12B0BEF1$ZTE3A8TT3C17701,142004557606$ZTE3A8TT3R11342,14200456A11A$ZTE3A8TT3C17683,1420045575BE$ZTE3A8TR5U24029,E44E1292D5BB$ZTE3A8TQCH14067,DC5193D966D2$ZTE3A8TQCH13890,DC5193D9640E$ZTE3A8TT3302196,14200452F552$ZTE3A8TT3301827,14200452EF8E$ZTE3A8TT3304209,1420045314C6$ZTE3A8TR5U25392,E44E1292EB07$ZTE3A8TR7R06085,E44E12B2D295$ZTE3A8TR6D00089,E44E12AF5805$ZTE3A8TT4724444,14200458FC42$ZTE3A8TRB719448,7C7D21EC3273$ZTE3A8TR8U07765,B47CA60829F6', '',05,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-26 15:49:50 Duration: 5s784ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (43987, 413, 'ZTE3ANNR7B16808,3891484A7697,3891484A7698,ZTEGDB07D308$ZTE3ANNR5W73900,48D6823547D2,48D6823547D3,ZTEGDB0120AB$ZTE3ANNR1Y02198,14CA56CCDDFF,14CA56CCDE00,ZTEGD9707EF1$ZTE3ANNR9F17725,D89A0DA47D51,D89A0DA47D52,ZTEGDB156C88$ZTE3ANNR1Y18011,14CA56CE509D,14CA56CE509E,ZTEGD970BCB6$ZTE3ANNRC552545,6C11BA66F95D,6C11BA66F95E,ZTEGDC6EE300$ZTE3ANNR5W76099,48D682357B5C,48D682357B5D,ZTEGDB012942$ZTE3ANNRAD30241,D89A0DB09F29,D89A0DB09F2A,ZTEGDB17722C$ZTE3ANNR3Y45725,4896D953F066,4896D953F067,ZTEGD97EE352$ZTE3ANNR2Q05980,F4E84F814028,F4E84F814029,ZTEGD97A8A16$ZTE3ANNQ8M42020,843C9922A0C3,843C9922A0C4,ZTEGD7BAEB91$ZTE3ANNR3J07664,F4E84F870200,F4E84F870201,ZTEGD97B7FBA$ZTE3ANNQ7506303,C4EBFF8B86F6,C4EBFF8B86F7,ZTEGD70A673F$ZTE3ANNRB720988,5872C9902519,5872C990251A,ZTEGDC617CCF$ZTE3ANNQ8M44727,843C9922E035,843C9922E036,ZTEGD7BAF624$ZTE3ANNR4N12587,4896D956821A,4896D956821B,ZTEGD97F50F0$ZTE3ANNR7B16984,3891484A7AB7,3891484A7AB8,ZTEGDB07D3B8$ZTE3ANNT2V51970,D831399050E4,D831399050E5,ZTEGDD30BD81$ZTE3ANNQ8M44668,843C9922DED3,843C9922DED4,ZTEGD7BAF5E9$ZTE3ANNQ6305691,3CF9F070298D,3CF9F070298E,ZTEGD52E4CD2$ZTE3ANNRCB24812,D83139201486,D83139201487,ZTEGDD2A1681$ZTE3ANNT2V84790,D8313993521C,D8313993521D,ZTEGDD313DB5$ZTE3ANNR6R28404,48D682381E7A,48D682381E7B,ZTEGDB0199C7$ZTE3ANNRCP67206,6C11BA6F51F3,6C11BA6F51F4,ZTEGDC704719$ZTE3ANNR9W07873,D89A0DA914A9,D89A0DA914AA,ZTEGDB16306C$ZTE3ANNRCP35700,6C11BA6C6F87,6C11BA6C6F88,ZTEGDC6FCC07$ZTE3ANNR9F16604,D89A0DA4630B,D89A0DA4630C,ZTEGDB156827$ZTE3ANNRB713835,5872C98F7D73,5872C98F7D74,ZTEGDC6160DE$ZTE3ANNRCP49416,6C11BA6DB0FF,6C11BA6DB100,ZTEGDC70019B$ZTE3ANNR9344293,D89A0D866E29,D89A0D866E2A,ZTEGDB152104$ZTE3ANNQ3624442,3CF9F0A7124A,3CF9F0A7124B,ZTEGD640C315$ZTE3ANNQ9J21177,843C992DC18B,843C992DC18C,ZTEGD7BB5B64$ZTE3ANNR5W76201,48D682357DC0,48D682357DC1,ZTEGDB0129A8$ZTE3ANNRAD23519,D89A0DB0019D,D89A0DB0019E,ZTEGDB1757EA$ZTE3ANNRC554278,6C11BA6721FB,6C11BA6721FC,ZTEGDC6EE9C5$ZTE3ANNR3Y35525,4896D9530156,4896D9530157,ZTEGD97EBB7A$ZTE3ANNR3J12284,F4E84F876E48,F4E84F876E49,ZTEGD97B91C6$ZTE3ANNR4N10556,4896D9565280,4896D9565281,ZTEGD97F4901$ZTE3ANNQCA03501,14CA56D296E9,14CA56D296EA,ZTEGD9717318', '',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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-26 09:45:53 Duration: 5s615ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (125711, 397, '226307561132', '',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-26 10:38:55 Duration: 5s291ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-26.log
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 8 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jun 26 08 1 0ms 0ms 09 1 0ms 0ms 17 1 0ms 0ms 18 2 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms [ User: intelifix - Total duration: 6m21s - Times executed: 8 ]
[ Application: psql - Total duration: 6m19s - Times executed: 6 ]
[ Application: [unknown] - Total duration: 1s312ms - Times executed: 2 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 18,838 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 12 FATAL entries
- 3948 ERROR entries
- 0 WARNING entries
- 20 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 3,730 Max number of times the same event was reported
- 3,980 Total events found
Rank Times reported Error 1 3,730 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jun 26 00 59 01 58 02 59 03 57 04 59 05 59 06 64 07 209 08 252 09 308 10 331 11 306 12 124 13 92 14 224 15 352 16 219 17 186 18 118 19 120 20 120 21 118 22 118 23 118 - ERROR: prepared statement "_PLAN000000002A0BEE20" does not exist
- ERROR: prepared statement "_PLAN000000002A034170" does not exist
- ERROR: prepared statement "_PLAN0000000029E751C0" does not exist
Statement: DEALLOCATE "_PLAN000000002A0BEE20"
Date: 2026-06-26 00:00:37 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
Statement: DEALLOCATE "_PLAN000000002A034170"
Date: 2026-06-26 00:01:38 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
Statement: DEALLOCATE "_PLAN0000000029E751C0"
Date: 2026-06-26 00:02:38 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
2 74 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #2
Day Hour Count Jun 26 07 11 08 9 09 18 10 9 11 6 12 9 13 3 14 3 15 6 - ERROR: trailing junk after numeric literal at or near "80D04AC14F58" at character 27
- ERROR: trailing junk after numeric literal at or near "80D04AC14F58" at character 27
- ERROR: trailing junk after numeric literal at or near "8C" at character 36
Statement: SELECT * FROM RS_ETIQUETA(80D04AC14F58)
Date: 2026-06-26 07:42:18 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
Statement: SELECT * FROM RS_ETIQUETA(80D04AC14F58)
Date: 2026-06-26 07:42:18 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-8C-2B-60)
Date: 2026-06-26 07:52:47 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
3 46 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #3
Day Hour Count Jun 26 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 2 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-26 00:05:02 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
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-26 00:35:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
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-26 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
4 45 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #4
Day Hour Count Jun 26 08 3 09 3 10 3 11 3 12 3 13 3 14 3 15 3 16 3 17 3 18 3 19 3 20 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-26 08:00:12 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
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-26 08:20:06 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
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-26 08:40:05 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
5 26 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Jun 26 07 12 09 3 10 5 11 6 - ERROR: column "dc" does not exist at character 27
- ERROR: column "dc" does not exist at character 27
- ERROR: column "dc" does not exist at character 27
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-AA-F2-52)
Date: 2026-06-26 07:53:27 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-AA-F2-52)
Date: 2026-06-26 07:53:27 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-AA-F2-52)
Date: 2026-06-26 07:53:27 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
6 17 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #6
Day Hour Count Jun 26 07 1 08 4 13 2 14 4 16 2 17 4 - ERROR: syntax error at or near "216722392329" at character 32
- ERROR: syntax error at or near "114177" at character 37
- ERROR: syntax error at or near "114177" at character 37
Statement: SELECT RS_SERIAL_TEMPORARIO( ''216722392329' ) OR RS_SERIAL_TEMPORARIO_VIVO( ''216722392329' )
Date: 2026-06-26 07:58:46 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
Statement: select * from rs_caixa_qr(->> Caixa 114177)
Date: 2026-06-26 08:58:51 Database: contagem Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
Statement: select * from rs_caixa_qr(->> Caixa 114177)
Date: 2026-06-26 08:58:51 Database: contagem Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
7 11 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #7
Day Hour Count Jun 26 07 4 08 3 14 2 15 2 - LOG: process 960688 still waiting for ShareLock on transaction 1676636 after 1000.107 ms
- LOG: process 966809 still waiting for ShareLock on transaction 1678141 after 1000.171 ms
- LOG: process 966809 still waiting for ShareLock on transaction 1678141 after 5055.569 ms
Detail: Process holding the lock: 965870. Wait queue: 960688.
Context: while updating tuple (71671,25) 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-26 07:15:08 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
Detail: Process holding the lock: 965870. Wait queue: 966809.
Context: while updating tuple (71673,14) 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-26 07:35:10 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
Detail: Process holding the lock: 965870. Wait queue: 966809.
Context: while updating tuple (71673,14) 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-26 07:35:14 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
8 7 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #8
Day Hour Count Jun 26 03 7 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-06-26 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
Date: 2026-06-26 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
Date: 2026-06-26 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
9 4 ERROR: process ... detected deadlock while waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #9
Day Hour Count Jun 26 07 4 - ERROR: process 965870 detected deadlock while waiting for ShareLock on transaction 1678371 after 1000.203 ms
- ERROR: process 965870 detected deadlock while waiting for ShareLock on transaction 1678371 after 1000.220 ms
- ERROR: process 965870 detected deadlock while waiting for ShareLock on transaction 1678371 after 1000.231 ms
Detail: Process holding the lock: 966809. Wait queue: .
Context: while updating tuple (71673,18) 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,character varying,integer) line 1012 at assignment PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 026209, 0507 )' , '/var/www/html/tmp/nf_carga_lotes_0507.xlsx' )Date: 2026-06-26 07:37:33 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
Detail: Process holding the lock: 966809. Wait queue: .
Context: while updating tuple (18738,63) in relation "nf_entrada_modelos" SQL statement "UPDATE NF_ENTRADA_MODELOS SET QTD_RECEBIDA = QTD_RECEBIDA + 1 WHERE NEM_ID = nNEM" PL/pgSQL function rs_nf_associa_equipamento(integer) line 135 at SQL statement PL/pgSQL assignment "cRetAux := RS_NF_ASSOCIA_EQUIPAMENTO( nLI )" PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1012 at assignment PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 026209, 0507 )' , '/var/www/html/tmp/nf_carga_lotes_0507.xlsx' )Date: 2026-06-26 07:37:35 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
Detail: Process holding the lock: 966809. Wait queue: .
Context: while updating tuple (18738,63) in relation "nf_entrada_modelos" SQL statement "UPDATE NF_ENTRADA_MODELOS SET QTD_RECEBIDA = QTD_RECEBIDA + 1 WHERE NEM_ID = nNEM" PL/pgSQL function rs_nf_associa_equipamento(integer) line 135 at SQL statement PL/pgSQL assignment "cRetAux := RS_NF_ASSOCIA_EQUIPAMENTO( nLI )" PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1012 at assignment PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 026209, 0507 )' , '/var/www/html/tmp/nf_carga_lotes_0507.xlsx' )Date: 2026-06-26 07:37:38 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
10 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #10
Day Hour Count Jun 26 05 4 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-06-26 05:32:08 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-06-26 05:32:08 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-06-26 05:32:08 Database: contagem Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
11 4 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #11
Day Hour Count Jun 26 07 1 08 1 23 2 - LOG: process 965870 still waiting for AccessExclusiveLock on relation 1654265 of database 358220 after 1000.159 ms
- LOG: process 1000791 still waiting for AccessExclusiveLock on relation 1658284 of database 358220 after 1000.122 ms
- LOG: process 1566541 still waiting for AccessExclusiveLock on relation 1701415 of database 358220 after 1000.181 ms
Detail: Process holding the lock: 982083. Wait queue: 965870.
Statement: DROP TABLE IF EXISTS temp0000283666;Date: 2026-06-26 07:31:44 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
Detail: Process holding the lock: 1037051. Wait queue: 1000791.
Statement: DROP TABLE IF EXISTS temp0000283700;Date: 2026-06-26 08:22:44 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
Detail: Process holding the lock: 1562526. Wait queue: 1566541.
Statement: DROP TABLE IF EXISTS temp0000283780;Date: 2026-06-26 23:23:37 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
12 3 ERROR: function rs_etiqueta(...) does not exist
Times Reported Most Frequent Error / Event #12
Day Hour Count Jun 26 15 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(21669343333333333333333333333)Date: 2026-06-26 15:34:36 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_ETIQUETA(21669343333333333333333333333)Date: 2026-06-26 15:34:36 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_ETIQUETA(21669343333333333333333333333)Date: 2026-06-26 15:34:37 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
13 3 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #13
Day Hour Count Jun 26 00 1 06 1 23 1 - FATAL: database "testes" does not exist
- FATAL: database "testes" does not exist
- FATAL: database "testes" does not exist
Date: 2026-06-26 00:02:27 Database: testes Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
Date: 2026-06-26 06:02:25 Database: testes Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
Date: 2026-06-26 23:45:02 Database: testes Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
14 2 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #14
Day Hour Count Jun 26 07 1 08 1 - ERROR: canceling autovacuum task
- ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000283666"
Date: 2026-06-26 07:31:44 Log file: /usr/local/pgsql/data/log/serverlog-26.log
Context: automatic vacuum of table "rio.public.temp0000283700"
Date: 2026-06-26 08:22:44 Log file: /usr/local/pgsql/data/log/serverlog-26.log
15 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #15
Day Hour Count Jun 26 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-06-26 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
Date: 2026-06-26 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
16 1 ERROR: null value in column "..." of relation "..." violates not-null constraint
Times Reported Most Frequent Error / Event #16
Day Hour Count Jun 26 14 1 - ERROR: null value in column "serie" of relation "nf_entrada_itens" violates not-null constraint
Detail: Failing row contains (6452307, null, 1, null, A, 26259, 1, null, null, null).
Context: SQL statement "INSERT INTO NF_ENTRADA_ITENS ( NEM_ID, SERIE, VALOR, NEA_ID, TIPO_LOCAL ) VALUES ( REC.NEM_ID, REC.SERIAL, REC.VALOR, nID, REC.TIPO_LOCAL )" PL/pgSQL function rs_nf_entrada_carrega_daniel_rio(integer) line 385 at SQL statement
Statement: SELECT RS_SETGLOBAL('USUARIO',504);SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO( 026259 ); ERROR: null value in column "serie" of relation "nf_entrada_itens" violates not-null constraint DETAIL: Failing row contains (6452307, null, 1, null, A, 26259, 1, null, null, null). CONTEXT: SQL statement "INSERT INTO NF_ENTRADA_ITENS ( NEM_ID, SERIE, VALOR, NEA_ID, TIPO_LOCAL ) VALUES ( REC.NEM_ID, REC.SERIAL, REC.VALOR, nID, REC.TIPO_LOCAL )" PL/pgSQL function rs_nf_entrada_carrega_daniel_rio(integer) line 385 at SQL statementDate: 2026-06-26 14:16:27 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-26.log
17 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #17
Day Hour Count Jun 26 03 1 - LOG: database system was shut down at 2026-06-26 03:05:01 -03
Date: 2026-06-26 03:05:03 Log file: /usr/local/pgsql/data/log/serverlog-26.log