pgBadger-
Global information
- Generated on Tue Jun 30 23:50:10 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 45,096 log entries in 8s
- Log start from 2026-06-30 00:00:04 to 2026-06-30 23:49:11
-
Overview
Global Stats
- 410 Number of unique normalized queries
- 6,454 Number of queries
- 8h48m52s Total query duration
- 2026-06-30 00:02:21 First query
- 2026-06-30 23:48:50 Last query
- 5 queries/s at 2026-06-30 08:51:54 Query peak
- 8h48m52s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 8h48m52s Execute total duration
- 4,636 Number of events
- 15 Number of unique normalized events
- 4,465 Max number of times the same event was reported
- 0 Number of cancellation
- 431 Total number of automatic vacuums
- 955 Total number of automatic analyzes
- 23 Number temporary file
- 232.45 MiB Max size of temporary file
- 105.78 MiB Average size of temporary file
- 352 Total number of sessions
- 7 sessions at 2026-06-30 07:48:32 Session peak
- 13d7h56m1s Total duration of sessions
- 54m32s Average duration of sessions
- 18 Average queries per session
- 1m30s Average queries duration per session
- 53m1s Average idle time per session
- 354 Total number of connections
- 7 connections/s at 2026-06-30 03:05:16 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-06-30 08:51:54 Date
SELECT Traffic
Key values
- 4 queries/s Query Peak
- 2026-06-30 17:14:31 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-06-30 23:48:16 Date
Queries duration
Key values
- 8h48m52s 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 30 00 26 0ms 20s468ms 4s972ms 3s320ms 5s403ms 1m20s 01 26 0ms 2s844ms 1s55ms 2s540ms 4s135ms 5s85ms 02 11 0ms 3s608ms 2s189ms 2s100ms 4s387ms 5s854ms 03 20 0ms 3s700ms 1s374ms 3s173ms 4s46ms 7s221ms 04 26 0ms 2s939ms 1s102ms 2s928ms 4s155ms 5s828ms 05 18 0ms 8m47s 59s45ms 6s250ms 2m24s 8m47s 06 17 0ms 20s377ms 4s240ms 2s386ms 3s510ms 30s832ms 07 244 0ms 8m23s 9s672ms 1m22s 5m17s 8m32s 08 766 150ms 7m50s 3s 54s524ms 4m53s 8m11s 09 670 150ms 8m32s 4s831ms 3m30s 5m15s 9m1s 10 569 0ms 9m2s 4s900ms 1m46s 5m15s 10m6s 11 683 150ms 8m18s 3s624ms 1m31s 4m44s 8m26s 12 186 0ms 8m17s 8s928ms 52s246ms 4m53s 8m22s 13 317 0ms 6m58s 3s582ms 34s78ms 1m1s 6m58s 14 624 150ms 8m19s 4s62ms 1m32s 4m54s 8m25s 15 751 150ms 8m42s 2s979ms 1m31s 4m28s 8m46s 16 634 150ms 7m21s 4s20ms 2m18s 5m4s 8m 17 331 0ms 7m26s 3s397ms 30s382ms 1m11s 7m27s 18 26 0ms 6m36s 27s424ms 3s196ms 1m4s 6m36s 19 16 0ms 5m27s 36s518ms 2s426ms 47s245ms 5m27s 20 109 0ms 5m52s 10s709ms 59s740ms 1m59s 6m32s 21 25 0ms 5m32s 23s829ms 4s847ms 44s532ms 5m32s 22 22 0ms 5m17s 26s312ms 3s414ms 14s327ms 5m47s 23 337 0ms 1m26s 6s878ms 1m19s 1m24s 2m3s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 30 00 7 0 3s945ms 0ms 0ms 1s219ms 01 15 0 264ms 158ms 193ms 808ms 02 0 0 0ms 0ms 0ms 0ms 03 5 0 373ms 0ms 0ms 480ms 04 11 0 327ms 0ms 243ms 848ms 05 3 0 333ms 0ms 0ms 0ms 06 6 0 4s640ms 0ms 0ms 891ms 07 158 0 12s292ms 8s75ms 1m5s 6m30s 08 600 0 3s4ms 12s362ms 54s524ms 5m11s 09 547 0 5s105ms 42s369ms 3m30s 8m37s 10 451 0 5s174ms 37s299ms 1m46s 5m22s 11 532 0 3s834ms 11s426ms 1m27s 4m44s 12 141 0 10s906ms 4s539ms 10s869ms 5m1s 13 264 0 3s994ms 11s14ms 30s520ms 4m17s 14 484 0 4s236ms 25s951ms 1m 4m55s 15 579 0 3s76ms 13s188ms 1m7s 5m41s 16 503 0 4s181ms 22s45ms 1m22s 5m23s 17 262 0 3s992ms 8s197ms 30s382ms 4m5s 18 12 0 57s893ms 0ms 1s453ms 3m11s 19 6 0 1m34s 0ms 0ms 3m11s 20 14 83 11s807ms 16s963ms 59s740ms 3m31s 21 11 0 51s588ms 0ms 205ms 3m8s 22 6 0 1m32s 0ms 0ms 3m13s 23 11 326 6s878ms 1m3s 1m19s 2m3s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 30 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 30 00 0 1 1.00 0.00% 01 0 2 2.00 0.00% 02 0 0 0.00 0.00% 03 0 2 2.00 0.00% 04 0 2 2.00 0.00% 05 0 1 1.00 0.00% 06 0 2 2.00 0.00% 07 0 15 15.00 0.00% 08 0 15 15.00 0.00% 09 0 13 13.00 0.00% 10 0 15 15.00 0.00% 11 0 15 15.00 0.00% 12 0 7 7.00 0.00% 13 0 10 10.00 0.00% 14 0 13 13.00 0.00% 15 0 15 15.00 0.00% 16 0 9 9.00 0.00% 17 0 7 7.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 1 1.00 0.00% 21 0 1 1.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Jun 30 00 13 0.00/s 01 6 0.00/s 02 7 0.00/s 03 17 0.00/s 04 9 0.00/s 05 9 0.00/s 06 14 0.00/s 07 22 0.01/s 08 23 0.01/s 09 21 0.01/s 10 20 0.01/s 11 23 0.01/s 12 15 0.00/s 13 18 0.01/s 14 24 0.01/s 15 23 0.01/s 16 22 0.01/s 17 16 0.00/s 18 7 0.00/s 19 8 0.00/s 20 11 0.00/s 21 8 0.00/s 22 6 0.00/s 23 12 0.00/s Day Hour Count Average Duration Average idle time Jun 30 00 10 1h54s 1h41s 01 12 1h1m 1h57s 02 6 1h30s 1h26s 03 15 23m15s 23m13s 04 9 1h2m40s 1h2m36s 05 10 55m37s 53m50s 06 8 58m8s 57m59s 07 15 54m1s 51m23s 08 22 58m14s 56m30s 09 23 55m21s 53m1s 10 20 54m59s 52m39s 11 24 52m49s 51m6s 12 20 56m36s 55m13s 13 13 59m41s 58m13s 14 21 52m45s 50m44s 15 24 54m6s 52m33s 16 24 53m10s 51m24s 17 19 57m28s 56m29s 18 14 1h 59m9s 19 7 1h25s 59m2s 20 11 45m14s 43m28s 21 7 1h1m33s 1h7s 22 9 1h1m16s 1h12s 23 9 44m18s 40m1s -
Connections
Established Connections
Key values
- 7 connections Connection Peak
- 2026-06-30 03:05:16 Date
Connections per database
Key values
- rio Main Database
- 354 connections Total
Connections per user
Key values
- intelifix Main User
- 354 connections Total
-
Sessions
Simultaneous sessions
Key values
- 7 sessions Session Peak
- 2026-06-30 07:48:32 Date
Histogram of session times
Key values
- 289 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 352 sessions Total
Sessions per user
Key values
- intelifix Main User
- 352 sessions Total
Sessions per host
Key values
- [local] Main Host
- 352 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 16,183 buffers Checkpoint Peak
- 2026-06-30 10:44:35 Date
- 270.004 seconds Highest write time
- 0.091 seconds Sync time
Checkpoints Wal files
Key values
- 15 files Wal files usage Peak
- 2026-06-30 16:09:35 Date
Checkpoints distance
Key values
- 475.47 Mo Distance Peak
- 2026-06-30 16:09:35 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jun 30 00 22,143 653.102s 0.067s 653.228s 01 2,464 247.479s 0.063s 247.601s 02 2,034 204.092s 0.051s 204.178s 03 2,205 221.276s 0.081s 221.43s 04 3,520 354.254s 0.119s 354.444s 05 9,112 912.967s 0.094s 913.126s 06 5,382 417.337s 0.012s 417.373s 07 50,907 2,452.565s 0.331s 2,453.064s 08 49,834 3,174.892s 0.612s 3,175.73s 09 76,992 3,238.85s 0.6s 3,239.699s 10 70,815 3,221.727s 0.593s 3,222.55s 11 66,754 3,212.899s 0.623s 3,213.76s 12 37,846 2,380.094s 0.232s 2,380.467s 13 18,472 1,883.216s 0.396s 1,883.763s 14 62,168 3,086.864s 0.593s 3,087.671s 15 72,051 3,238.796s 0.638s 3,239.676s 16 77,390 3,238.866s 0.599s 3,239.71s 17 28,708 2,300.74s 0.29s 2,301.162s 18 1,979 198.455s 0.019s 198.509s 19 73 7.388s 0.008s 7.416s 20 667 99.511s 0.019s 99.547s 21 3,049 305.92s 0.082s 306.097s 22 1,719 172.84s 0.066s 172.957s 23 2,374 296.727s 0.047s 296.81s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jun 30 00 0 0 7 559 0.008s 0.007s 01 0 0 1 475 0.008s 0.01s 02 0 0 0 377 0.010s 0.005s 03 0 0 1 457 0.007s 0.014s 04 0 0 1 775 0.009s 0.011s 05 0 0 4 654 0.008s 0.008s 06 0 0 1 62 0.003s 0.003s 07 0 0 35 3,473 0.007s 0.012s 08 0 0 30 6,061 0.006s 0.012s 09 0 0 48 6,670 0.007s 0.012s 10 0 0 37 6,639 0.005s 0.012s 11 0 0 43 7,104 0.007s 0.012s 12 0 0 19 2,685 0.007s 0.012s 13 0 0 10 4,447 0.008s 0.012s 14 0 0 40 6,454 0.008s 0.012s 15 0 0 44 6,623 0.010s 0.012s 16 0 0 54 6,189 0.007s 0.012s 17 0 0 11 4,205 0.006s 0.012s 18 0 0 1 298 0.002s 0.005s 19 0 0 0 16 0.004s 0.003s 20 0 0 0 75 0.004s 0.003s 21 0 0 1 496 0.024s 0.008s 22 0 0 1 437 0.011s 0.007s 23 0 0 4 94 0.011s 0.008s Day Hour Count Avg time (sec) Jun 30 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 30 00 16,223.29 kB 47,219.86 kB 01 1,538.75 kB 29,089.75 kB 02 2,242.40 kB 15,274.80 kB 03 1,165.00 kB 3,990.70 kB 04 1,811.40 kB 2,545.30 kB 05 7,770.00 kB 14,150.12 kB 06 4,094.67 kB 11,754.67 kB 07 48,808.92 kB 72,274.92 kB 08 40,292.00 kB 75,650.83 kB 09 65,357.08 kB 105,940.58 kB 10 50,564.08 kB 94,090.58 kB 11 58,562.33 kB 106,884.58 kB 12 26,432.92 kB 72,712.92 kB 13 13,179.58 kB 33,346.17 kB 14 54,387.33 kB 69,856.58 kB 15 60,828.83 kB 111,914.92 kB 16 73,280.08 kB 166,352.58 kB 17 15,443.75 kB 73,296.33 kB 18 1,614.20 kB 31,554.80 kB 19 117.67 kB 20,809.00 kB 20 3,922.67 kB 16,106.00 kB 21 1,818.00 kB 9,957.62 kB 22 1,313.86 kB 5,348.43 kB 23 16,987.25 kB 28,382.00 kB -
Temporary Files
Size of temporary files
Key values
- 464.89 MiB Temp Files size Peak
- 2026-06-30 05:32:00 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-06-30 05:32:05 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jun 30 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 10 1.06 GiB 108.10 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 2 208.00 MiB 104.00 MiB 10 1 104.00 MiB 104.00 MiB 11 3 312.00 MiB 104.00 MiB 12 0 0 0 13 0 0 0 14 3 312.00 MiB 104.00 MiB 15 3 312.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 13 1.32 GiB 104.00 MiB 104.00 MiB 104.00 MiB select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026385, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-30 15:11:34 Duration: 5m39s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026391, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-30 16:07:24 Duration: 5m19s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026363, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-30 10:13:05 Duration: 5m16s Database: rio User: intelifix Remote: [local] Application: [unknown]
2 8 903.14 MiB 69.33 MiB 232.45 MiB 112.89 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-06-30 05:32:07 Duration: 1m25s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-06-30 05:32:00 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
3 2 177.89 MiB 88.95 MiB 88.95 MiB 88.95 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-06-30 05:30:42 Duration: 40s486ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-06-30 05:30:39 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 232.45 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-06-30 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 232.45 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-06-30 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,404,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-30 15:57:09 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,452,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-30 16:49:30 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,508,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-30 14:21:41 - 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-30 09:00:21 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
7 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-30 14:57:20 - 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-30 15:00:31 - 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-30 15:04:13 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 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-30 14:47:59 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
11 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-30 11:24:36 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
12 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,404,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-30 11:26:51 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-30 11:17:12 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 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-30 09:56:19 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
15 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,503,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-30 10:00:14 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
16 88.95 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-06-30 05:30:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 88.95 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-06-30 05:30:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 76.78 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-06-30 05:32:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 76.70 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-06-30 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 76.69 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-06-30 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 2.74 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_06
Database brasilia - 2026-06-30 09:41:09 Date
- 0 sec Highest CPU-cost analyze
Table
Database brasilia - Date
Average Autovacuum Duration
Key values
- 2.74 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_06
Database brasilia - 2026-06-30 09:41:09 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (107) Main table analyzed (database rio)
- 955 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 107 rio.pg_catalog.pg_class 57 rio.public.usuarios 48 rio.pg_catalog.pg_type 48 brasilia.pg_catalog.pg_attribute 40 rio.public.temp0000283966 37 rio.public.temp0000283962 34 rio.public.temp0000283958 31 rio.pg_catalog.pg_index 31 contagem.pg_catalog.pg_attribute 31 rio.public.temp0000281789 28 rio.pg_catalog.pg_depend 22 contagem.pg_catalog.pg_class 22 brasilia.pg_catalog.pg_class 20 brasilia.pg_catalog.pg_type 18 rio.public.temp0000284066 18 contagem.pg_catalog.pg_type 17 rio.public.temp0000284050 16 rio.public.temp0000284032 16 rio.public.temp0000283956 15 rio.public.temp0000283986 15 rio.public.temp0000283976 14 brasilia.pg_catalog.pg_index 13 rio.public.temp0000283952 13 contagem.public.temp0000226520 12 rio.public.temp0000283996 12 rio.public.temp0000283932 11 contagem.public.usuarios 11 contagem.pg_catalog.pg_index 10 rio.public.temp0000283998 10 rio.public.temp0000283968 9 brasilia.pg_catalog.pg_depend 9 rio.public.temp0000284012 8 rio.public.temp0000283990 8 rio.public.temp0000284076 8 brasilia.public.usuarios 7 contagem.pg_catalog.pg_depend 7 rio.public.temp0000283970 6 rio.public.temp0000284078 6 rio.public.temp0000284034 5 rio.public.temp0000283982 5 rio.public.temp0000283972 5 rio.public.tmp_drill_0302 5 rio.public.temp0000283974 4 contagem.pg_catalog.pg_shdepend 4 brasilia.public.temp0000234986 4 brasilia.public.nf_entrada 3 brasilia.pg_catalog.pg_shdepend 3 template1.pg_catalog.pg_shdepend 3 rio.public.tmp_drill_0175 3 brasilia.public.temp0000234938 3 rio.public.temp0000284082 3 brasilia.public.temp0000234920 2 brasilia.public.temp0000234922 2 rio.public.temp0000284074 2 rio.public.temp0000284026 2 rio.public.temp0000284040 2 brasilia.public.temp0000234968 2 brasilia.public.temp0000234960 2 rio.public.temp0000284002 2 rio.public.temp0000284052 2 brasilia.public.temp0000234976 2 brasilia.public.temp0000234964 2 rio.public.temp0000284058 2 rio.public.temp0000283948 2 brasilia.public.temp0000234954 2 brasilia.public.temp0000234974 1 brasilia.public.temp0000234956 1 rio.public.temp0000284046 1 brasilia.public.temp0000234908 1 rio.public.temp0000284010 1 contagem.public.parametros 1 brasilia.public.temp0000234958 1 rio.public.temp0000283872 1 rio.public.temp0000284000 1 rio.public.temp0000284070 1 brasilia.auditor.auditor_2026_06 1 brasilia.public.temp0000234902 1 rio.public.temp0000284056 1 contagem.public.tmp_dias_226522 1 brasilia.public.temp0000234926 1 rio.public.temp0000283964 1 brasilia.public.temp0000234948 1 rio.public.temp0000284008 1 rio.public.temp0000284014 1 rio.public.temp0000284062 1 rio.pg_catalog.pg_shdepend 1 rio.public.temp0000283992 1 brasilia.public.temp0000234982 1 brasilia.public.temp0000234914 1 rio.public.temp0000284080 1 brasilia.public.temp0000234900 1 brasilia.public.temp0000234918 1 rio.public.temp0000283808 1 rio.public.temp0000284060 1 postgres.pg_catalog.pg_shdepend 1 rio.public.temp0000283994 1 rio.public.temp0000283954 1 Total 955 Vacuums per table
Key values
- public.temp0000283966 (37) Main table vacuumed on database rio
- 431 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.public.temp0000283966 37 0 0 0 0 0 0 20,653 3,547 5,658,707 0 0 rio.pg_catalog.pg_attribute 34 34 0 0 0 0 0 19,728 5,815 8,279,799 370 8,984 rio.pg_catalog.pg_class 20 19 0 0 0 0 0 3,590 1,410 2,021,849 94 377 rio.public.temp0000284066 18 0 0 0 0 0 0 24,267 1,682 3,505,287 0 0 rio.public.temp0000281789 17 0 0 0 0 0 0 1,045 99 75,249 0 0 rio.pg_catalog.pg_type 17 17 0 0 0 0 0 1,686 536 647,002 70 267 brasilia.pg_catalog.pg_attribute 16 14 0 0 0 0 0 7,883 1,986 3,206,849 76 2,049 rio.public.temp0000284032 16 0 0 0 0 0 0 17,965 1,677 3,131,482 0 0 rio.public.temp0000283986 15 0 0 0 0 0 0 1,229 79 85,325 0 0 rio.public.temp0000283932 11 0 0 0 0 0 0 1,157 288 467,385 0 0 contagem.public.usuarios 11 0 0 0 0 0 0 50 40 24,410 0 0 brasilia.pg_catalog.pg_type 10 8 0 0 0 0 0 677 173 244,298 19 103 contagem.pg_catalog.pg_attribute 10 10 0 0 0 0 0 5,199 1,691 2,901,639 14 457 rio.pg_catalog.pg_index 10 10 0 0 0 0 0 649 160 152,544 48 110 rio.public.temp0000283996 10 0 0 0 0 0 0 769 149 206,460 0 0 brasilia.pg_catalog.pg_class 10 8 0 0 0 0 0 1,641 313 610,353 21 119 rio.public.tmp_drill_0175 8 1 0 0 0 0 0 45 7 10,489 0 0 rio.pg_catalog.pg_depend 8 8 0 0 0 0 0 2,765 1,145 1,693,474 70 710 brasilia.pg_catalog.pg_index 8 6 0 0 0 0 0 297 75 88,005 16 36 rio.public.temp0000284012 8 0 0 0 0 0 0 4,868 27 291,711 0 0 rio.public.temp0000283990 7 0 0 0 0 0 0 440 40 32,119 0 0 rio.pg_catalog.pg_statistic 7 7 0 0 0 0 0 9,501 1,964 8,961,477 985 3,982 rio.public.temp0000284050 7 0 0 0 0 0 0 855 38 56,458 0 0 rio.public.usuarios 6 4 0 0 0 0 0 95 37 81,617 0 0 rio.public.temp0000284078 6 0 0 0 0 0 0 3,340 25 201,103 0 0 rio.pg_toast.pg_toast_2619 5 5 0 0 0 0 0 2,113 425 2,106,769 97 307 rio.public.temp0000283982 5 0 0 0 0 0 0 4,856 18 289,389 0 0 contagem.pg_catalog.pg_class 5 5 0 0 0 0 0 745 286 400,139 6 20 brasilia.pg_catalog.pg_depend 5 4 0 0 0 0 0 936 225 395,533 10 88 rio.public.tmp_drill_0302 5 5 0 0 0 0 0 1,586 15 281,169 0 0 contagem.pg_catalog.pg_type 5 5 0 0 0 0 0 445 175 249,057 2 4 brasilia.pg_catalog.pg_shdepend 4 4 0 0 0 0 0 555 203 390,202 31 60 brasilia.public.temp0000234986 4 0 0 0 0 0 0 945 253 418,592 0 0 rio.public.temp0000283974 4 0 0 0 0 0 0 3,242 16 193,843 0 0 rio.public.temp0000283972 4 0 0 0 0 0 0 4,849 15 288,438 0 0 contagem.pg_catalog.pg_index 3 3 0 0 0 0 0 104 43 33,213 2 4 template1.pg_catalog.pg_shdepend 3 3 0 0 0 0 0 451 157 323,568 39 97 contagem.pg_catalog.pg_depend 3 3 0 0 0 0 0 826 320 619,720 5 37 rio.public.temp0000284026 2 0 0 0 0 0 0 1,624 1,622 2,159,839 0 0 rio.public.temp0000284058 2 0 0 0 0 0 0 1,620 7 96,721 0 0 brasilia.public.nf_entrada 2 2 0 0 0 0 0 196 58 132,226 6 6 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 247 58 223,534 11 23 brasilia.public.temp0000234964 2 0 0 0 0 0 0 472 12 30,102 0 0 brasilia.public.temp0000234976 2 0 0 0 0 0 0 16 11 3,653 0 0 rio.public.temp0000284052 2 0 0 0 0 0 0 94 11 7,292 0 0 brasilia.public.temp0000234954 2 0 0 0 0 0 0 472 241 387,291 0 0 rio.public.temp0000284034 2 0 0 0 0 0 0 105 11 7,926 0 0 rio.public.temp0000284002 2 0 0 0 0 0 0 1,621 1,620 2,159,622 0 0 brasilia.pg_catalog.pg_statistic 2 2 0 0 0 0 0 3,386 325 1,303,541 225 1,781 rio.public.temp0000284040 2 0 0 0 0 0 0 3,232 8 191,894 0 0 rio.public.temp0000283948 2 0 0 0 0 0 0 3,234 8 192,057 0 0 rio.public.temp0000283998 2 0 0 0 0 0 0 62 11 5,248 0 0 brasilia.auditor.auditor_2026_06 1 0 0 0 0 0 0 8,722 6,670 8,414,557 1,117 22,138 rio.public.temp0000284000 1 0 0 0 0 0 0 80 79 143,236 0 0 rio.public.temp0000284074 1 0 0 0 0 0 0 88 6 6,110 0 0 rio.public.temp0000284010 1 0 0 0 0 0 0 8 5 1,293 0 0 brasilia.public.temp0000234922 1 0 0 0 0 0 0 236 6 15,052 0 0 brasilia.public.temp0000234920 1 0 0 0 0 0 0 236 235 372,400 0 0 rio.public.temp0000284080 1 0 0 0 0 0 0 152 6 9,990 0 0 brasilia.public.temp0000234974 1 0 0 0 0 0 0 236 6 15,051 0 0 brasilia.public.nf_entrada_arquivo_erros 1 0 0 0 0 0 0 102 46 143,796 28 1,013 brasilia.public.temp0000234914 1 0 0 0 0 0 0 236 234 371,038 0 0 rio.public.temp0000283994 1 0 0 0 0 0 0 84 6 5,866 0 0 rio.public.temp0000283992 1 0 0 0 0 0 0 8 5 1,290 0 0 rio.public.temp0000284060 1 0 0 0 0 0 0 86 6 5,988 0 0 rio.public.temp0000284062 1 0 0 0 0 0 0 8 5 1,304 0 0 rio.public.caixa_itens_exclusao 1 0 0 0 0 0 0 114 99 378,397 7 717 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 163 38 114,291 26 51 rio.public.temp0000284008 1 0 0 0 0 0 0 80 6 5,622 0 0 brasilia.public.temp0000234948 1 0 0 0 0 0 0 236 6 15,051 0 0 rio.public.temp0000283964 1 0 0 0 0 0 0 8 5 1,290 0 0 rio.public.temp0000284056 1 0 0 0 0 0 0 86 6 5,988 0 0 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,411 849 2,663,341 811 5,768 Total 431 191 0 0 0 0 0 181,808 37,481 68,216,620 4,206 49,308 Vacuum throughput per table
Key values
- pg_catalog.pg_attribute (3.02) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.public.temp0000283966 0 0 1.34 rio.pg_catalog.pg_attribute 0 0 3.02 rio.pg_catalog.pg_class 0 0 0.8 rio.public.temp0000284066 0 0 0.9 rio.public.temp0000281789 0 0 0.26 rio.pg_catalog.pg_type 0 0 0.25 brasilia.pg_catalog.pg_attribute 0 0 0.96 rio.public.temp0000284032 0 0 0.75 rio.public.temp0000283986 0 0 0.2 rio.public.temp0000283932 0 0 0.16 contagem.public.usuarios 0 0 0 brasilia.pg_catalog.pg_type 0 0 0.13 contagem.pg_catalog.pg_attribute 0 0 0.91 rio.pg_catalog.pg_index 0 0 0.33 rio.public.temp0000283996 0 0 0.18 brasilia.pg_catalog.pg_class 0 0 0.23 rio.public.tmp_drill_0175 0 0 0.03 rio.pg_catalog.pg_depend 0 0 1.02 brasilia.pg_catalog.pg_index 0 0 0.11 rio.public.temp0000284012 0 0 0.41 rio.public.temp0000283990 0 0 0.1 rio.pg_catalog.pg_statistic 0 0 1.07 rio.public.temp0000284050 0 0 0.08 rio.public.usuarios 0 0 0 rio.public.temp0000284078 0 0 0.23 rio.pg_toast.pg_toast_2619 0 0 0.25 rio.public.temp0000283982 0 0 0.25 contagem.pg_catalog.pg_class 0 0 0.18 brasilia.pg_catalog.pg_depend 0 0 0.18 rio.public.tmp_drill_0302 0 0 0.06 contagem.pg_catalog.pg_type 0 0 0.22 brasilia.pg_catalog.pg_shdepend 0 0 0.18 brasilia.public.temp0000234986 0 0 0.1 rio.public.temp0000283974 0 0 0.17 rio.public.temp0000283972 0 0 0.2 contagem.pg_catalog.pg_index 0 0 0.1 template1.pg_catalog.pg_shdepend 0 0 0.23 contagem.pg_catalog.pg_depend 0 0 0.21 rio.public.temp0000284026 0 0 0.09 rio.public.temp0000284058 0 0 0.1 brasilia.public.nf_entrada 0 0 0.06 brasilia.pg_toast.pg_toast_2619 0 0 0.02 brasilia.public.temp0000234964 0 0 0.04 brasilia.public.temp0000234976 0 0 0.03 rio.public.temp0000284052 0 0 0.04 brasilia.public.temp0000234954 0 0 0.05 rio.public.temp0000284034 0 0 0.04 rio.public.temp0000284002 0 0 0.11 brasilia.pg_catalog.pg_statistic 0 0 0.25 rio.public.temp0000284040 0 0 0.1 rio.public.temp0000283948 0 0 0.1 rio.public.temp0000283998 0 0 0.02 brasilia.auditor.auditor_2026_06 0 0 2.74 rio.public.temp0000284000 0 0 0.01 rio.public.temp0000284074 0 0 0.02 rio.public.temp0000284010 0 0 0.01 brasilia.public.temp0000234922 0 0 0.01 brasilia.public.temp0000234920 0 0 0.03 rio.public.temp0000284080 0 0 0.02 brasilia.public.temp0000234974 0 0 0.02 brasilia.public.nf_entrada_arquivo_erros 0 0 0.07 brasilia.public.temp0000234914 0 0 0.02 rio.public.temp0000283994 0 0 0.03 rio.public.temp0000283992 0 0 0.01 rio.public.temp0000284060 0 0 0.01 rio.public.temp0000284062 0 0 0.02 rio.public.caixa_itens_exclusao 0 0 0.1 contagem.pg_toast.pg_toast_2619 0 0 0 rio.public.temp0000284008 0 0 0.01 brasilia.public.temp0000234948 0 0 0.02 rio.public.temp0000283964 0 0 0.01 rio.public.temp0000284056 0 0 0.02 contagem.pg_catalog.pg_statistic 0 0 0.13 Total 0 0 20.16 Tuples removed per table
Key values
- pg_catalog.pg_attribute (127455) Main table with removed tuples on database rio
- 319906 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 34 34 127,455 824,564 10,096 138 19,732 brasilia.pg_catalog.pg_attribute 16 14 75,280 384,841 39,532 218 10,123 contagem.pg_catalog.pg_attribute 10 10 29,690 237,690 0 55 5,214 rio.public.tmp_drill_0302 5 5 22,022 23,812 0 0 600 rio.pg_catalog.pg_statistic 7 7 13,052 57,588 0 0 9,002 rio.pg_catalog.pg_depend 8 8 9,006 153,445 326 0 1,448 rio.pg_catalog.pg_type 17 17 4,986 39,225 478 4 1,237 brasilia.pg_catalog.pg_statistic 2 2 4,965 14,999 0 0 2,144 brasilia.pg_catalog.pg_type 10 8 4,330 26,124 3,896 28 764 contagem.pg_catalog.pg_statistic 1 1 4,243 7,274 0 0 1,011 rio.pg_catalog.pg_class 20 19 3,296 71,523 1,590 9 2,103 brasilia.pg_catalog.pg_shdepend 4 4 3,220 54,410 34 0 460 rio.pg_catalog.pg_index 10 10 2,833 19,272 8 0 590 brasilia.pg_catalog.pg_index 8 6 2,158 16,984 1,960 9 447 template1.pg_catalog.pg_shdepend 3 3 2,052 40,631 3 0 345 brasilia.auditor.auditor_2026_06 1 0 1,883 1,025,578 0 0 45,153 contagem.pg_catalog.pg_depend 3 3 1,799 57,065 0 0 516 rio.pg_toast.pg_toast_2619 5 5 1,362 2,699 6 0 1,430 brasilia.public.nf_entrada 2 2 1,341 6,309 1,299 0 182 brasilia.pg_catalog.pg_depend 5 4 1,238 99,217 9,036 0 905 contagem.pg_catalog.pg_class 5 5 742 16,167 0 0 590 contagem.public.usuarios 11 0 663 253 0 0 22 brasilia.pg_catalog.pg_class 10 8 595 44,845 9,695 65 1,421 contagem.pg_catalog.pg_type 5 5 539 11,233 0 7 305 rio.public.tmp_drill_0175 8 1 442 50,540 25,049 0 647 contagem.pg_catalog.pg_index 3 3 255 5,688 0 3 141 brasilia.pg_toast.pg_toast_2619 2 2 192 284 1 0 130 contagem.pg_toast.pg_toast_2619 1 1 136 114 0 0 60 rio.public.usuarios 6 4 124 3,945 897 0 102 rio.public.caixa_itens_exclusao 1 0 7 1,284,798 0 0 10,736 rio.public.temp0000283986 15 0 0 71,771 0 365 1,619 rio.public.temp0000284026 2 0 0 24,130 0 53 1,739 rio.public.temp0000284058 2 0 0 45,470 0 0 3,328 rio.public.temp0000284000 1 0 0 1,380 0 56 72 rio.public.temp0000283982 5 0 0 113,627 0 0 8,320 rio.public.temp0000284074 1 0 0 1,452 0 48 80 rio.public.temp0000283990 7 0 0 25,636 0 195 573 rio.public.temp0000284010 1 0 0 1,387 0 56 72 brasilia.public.temp0000234922 1 0 0 3,040 0 28 228 brasilia.public.temp0000234920 1 0 0 3,040 0 28 228 rio.public.temp0000284080 1 0 0 6,388 0 48 144 brasilia.public.temp0000234974 1 0 0 3,041 0 28 228 rio.public.temp0000281789 17 0 0 53,620 0 536 1,128 brasilia.public.temp0000234986 4 0 0 12,180 0 112 912 brasilia.public.nf_entrada_arquivo_erros 1 0 0 1,635,754 17 0 29,221 brasilia.public.temp0000234914 1 0 0 3,040 0 28 228 rio.public.temp0000283966 37 0 0 478,106 0 929 34,527 rio.public.temp0000283994 1 0 0 1,417 0 52 76 rio.public.temp0000284066 18 0 0 409,301 0 0 29,952 brasilia.public.temp0000234964 2 0 0 6,082 0 56 456 rio.public.temp0000283996 10 0 0 36,364 0 339 813 rio.public.temp0000283992 1 0 0 1,378 0 56 72 rio.public.temp0000283974 4 0 0 69,514 0 56 5,064 rio.public.temp0000283932 11 0 0 55,826 0 348 1,252 brasilia.public.temp0000234976 2 0 0 6,088 0 56 456 rio.public.temp0000284052 2 0 0 2,866 0 100 156 rio.public.temp0000284060 1 0 0 1,433 0 50 78 rio.public.temp0000284062 1 0 0 1,433 0 50 78 brasilia.public.temp0000234954 2 0 0 6,082 0 56 456 rio.public.temp0000284034 2 0 0 7,644 0 85 171 rio.public.temp0000284008 1 0 0 1,387 0 56 72 brasilia.public.temp0000234948 1 0 0 3,041 0 28 228 rio.public.temp0000283964 1 0 0 1,339 0 57 71 rio.public.temp0000283972 4 0 0 90,845 0 0 6,656 rio.public.temp0000284002 2 0 0 45,488 0 0 3,328 rio.public.temp0000284050 7 0 0 35,947 0 84 812 rio.public.temp0000284032 16 0 0 321,144 0 101 23,451 rio.public.temp0000284078 6 0 0 93,961 0 92 6,820 rio.public.temp0000284012 8 0 0 181,770 0 0 13,312 rio.public.temp0000284056 1 0 0 1,433 0 50 78 rio.public.temp0000284040 2 0 0 45,460 0 0 3,328 rio.public.temp0000283948 2 0 0 45,462 0 0 3,328 rio.public.temp0000283998 2 0 0 4,287 0 33 95 Total 431 191 319,906 8,541,171 103,923 4,851 300,866 Pages removed per table
Key values
- public.temp0000283966 (929) Main table with removed pages on database rio
- 4851 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000283966 37 0 0 929 rio.public.temp0000281789 17 0 0 536 rio.public.temp0000283986 15 0 0 365 rio.public.temp0000283932 11 0 0 348 rio.public.temp0000283996 10 0 0 339 brasilia.pg_catalog.pg_attribute 16 14 75280 218 rio.public.temp0000283990 7 0 0 195 rio.pg_catalog.pg_attribute 34 34 127455 138 brasilia.public.temp0000234986 4 0 0 112 rio.public.temp0000284032 16 0 0 101 rio.public.temp0000284052 2 0 0 100 rio.public.temp0000284078 6 0 0 92 rio.public.temp0000284034 2 0 0 85 rio.public.temp0000284050 7 0 0 84 brasilia.pg_catalog.pg_class 10 8 595 65 rio.public.temp0000283964 1 0 0 57 rio.public.temp0000284000 1 0 0 56 rio.public.temp0000284010 1 0 0 56 brasilia.public.temp0000234964 2 0 0 56 rio.public.temp0000283992 1 0 0 56 rio.public.temp0000283974 4 0 0 56 brasilia.public.temp0000234976 2 0 0 56 brasilia.public.temp0000234954 2 0 0 56 rio.public.temp0000284008 1 0 0 56 contagem.pg_catalog.pg_attribute 10 10 29690 55 rio.public.temp0000284026 2 0 0 53 rio.public.temp0000283994 1 0 0 52 rio.public.temp0000284060 1 0 0 50 rio.public.temp0000284062 1 0 0 50 rio.public.temp0000284056 1 0 0 50 rio.public.temp0000284074 1 0 0 48 rio.public.temp0000284080 1 0 0 48 rio.public.temp0000283998 2 0 0 33 brasilia.pg_catalog.pg_type 10 8 4330 28 brasilia.public.temp0000234922 1 0 0 28 brasilia.public.temp0000234920 1 0 0 28 brasilia.public.temp0000234974 1 0 0 28 brasilia.public.temp0000234914 1 0 0 28 brasilia.public.temp0000234948 1 0 0 28 rio.pg_catalog.pg_class 20 19 3296 9 brasilia.pg_catalog.pg_index 8 6 2158 9 contagem.pg_catalog.pg_type 5 5 539 7 rio.pg_catalog.pg_type 17 17 4986 4 contagem.pg_catalog.pg_index 3 3 255 3 brasilia.auditor.auditor_2026_06 1 0 1883 0 rio.pg_toast.pg_toast_2619 5 5 1362 0 rio.public.temp0000284058 2 0 0 0 brasilia.pg_catalog.pg_shdepend 4 4 3220 0 rio.public.temp0000283982 5 0 0 0 brasilia.public.nf_entrada 2 2 1341 0 brasilia.pg_toast.pg_toast_2619 2 2 192 0 contagem.pg_catalog.pg_class 5 5 742 0 rio.public.tmp_drill_0175 8 1 442 0 rio.pg_catalog.pg_statistic 7 7 13052 0 rio.public.usuarios 6 4 124 0 brasilia.pg_catalog.pg_depend 5 4 1238 0 brasilia.public.nf_entrada_arquivo_erros 1 0 0 0 rio.pg_catalog.pg_index 10 10 2833 0 rio.public.temp0000284066 18 0 0 0 template1.pg_catalog.pg_shdepend 3 3 2052 0 contagem.pg_catalog.pg_depend 3 3 1799 0 contagem.public.usuarios 11 0 663 0 rio.pg_catalog.pg_depend 8 8 9006 0 rio.public.caixa_itens_exclusao 1 0 7 0 contagem.pg_toast.pg_toast_2619 1 1 136 0 rio.public.tmp_drill_0302 5 5 22022 0 rio.public.temp0000283972 4 0 0 0 rio.public.temp0000284002 2 0 0 0 rio.public.temp0000284012 8 0 0 0 brasilia.pg_catalog.pg_statistic 2 2 4965 0 rio.public.temp0000284040 2 0 0 0 rio.public.temp0000283948 2 0 0 0 contagem.pg_catalog.pg_statistic 1 1 4243 0 Total 431 191 319,906 4,851 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jun 30 00 0 0 01 0 0 02 0 0 03 1 2 04 0 13 05 6 1 06 0 0 07 26 42 08 58 123 09 50 111 10 42 109 11 38 105 12 6 21 13 31 59 14 52 106 15 48 114 16 54 101 17 15 43 18 0 0 19 0 0 20 0 0 21 4 5 22 0 0 23 0 0 - 2.74 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 4,628 Total read queries
- 1,453 Total write queries
Queries by database
Key values
- rio Main database
- 4,769 Requests
- 6h49m14s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 6,302 Requests
User Request type Count Duration etiquetas Total 37 7s6ms select 37 7s6ms intelifix Total 6,302 8h46m59s copy to 409 47m4s ddl 1,044 53m35s others 373 35m19s select 4,476 6h31m lenon Total 115 1m45s select 115 1m45s Duration by user
Key values
- 8h46m59s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 37 7s6ms select 37 7s6ms intelifix Total 6,302 8h46m59s copy to 409 47m4s ddl 1,044 53m35s others 373 35m19s select 4,476 6h31m lenon Total 115 1m45s select 115 1m45s Queries by host
Key values
- [local] Main host
- 6,454 Requests
- 8h48m52s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 5,458 Requests
- 4h58s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-06-30 14:28:52 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 3,372 100-500ms duration
Slowest individual queries
Rank Duration Query 1 9m2s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-30 10:14:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 8m47s analyze verbose;[ Date: 2026-06-30 05:08:49 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 8m42s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-30 15:13:44 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 8m32s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-30 09:13:34 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 8m23s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-30 07:13:25 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 8m19s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-30 14:13:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 8m18s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-30 11:13:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 8m17s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-30 12:13:18 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 7m50s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-30 08:12:52 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 7m26s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-30 17:12:28 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 7m21s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-30 16:12:23 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 6m58s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-30 13:11:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 6m36s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-30 18:11:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m52s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-30 20:10:53 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m39s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026385, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-06-30 15:11:34 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
16 5m32s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-30 21:10:34 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m27s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-30 19:10:29 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 5m19s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026391, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-06-30 16:07:24 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 5m17s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-30 22:10:18 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 5m16s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026363, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-06-30 10:13:05 - 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 2h10m35s 292 150ms 5m39s 26s834ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 30 07 12 15m4s 1m15s 08 41 10m36s 15s527ms 09 42 26m23s 37s701ms 10 23 14m41s 38s331ms 11 21 14m41s 41s982ms 12 3 9m25s 3m8s 13 29 1m22s 2s834ms 14 32 13m39s 25s621ms 15 38 9m4s 14s326ms 16 35 14m33s 24s959ms 17 13 21s159ms 1s627ms 18 3 40s796ms 13s598ms [ User: intelifix - Total duration: 2h10m35s - Times executed: 292 ]
[ Application: [unknown] - Total duration: 2h10m35s - Times executed: 292 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026385, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-30 15:11:34 Duration: 5m39s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026391, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-30 16:07:24 Duration: 5m19s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026363, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-30 10:13:05 Duration: 5m16s Database: rio User: intelifix Remote: [local] Application: [unknown]
2 2h4m56s 48 1s283ms 9m2s 2m36s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 30 07 3 9m3s 3m1s 08 3 8m20s 2m46s 09 3 9m6s 3m2s 10 3 9m39s 3m13s 11 3 8m51s 2m57s 12 3 8m45s 2m55s 13 3 7m18s 2m26s 14 3 8m49s 2m56s 15 3 9m9s 3m3s 16 3 7m47s 2m35s 17 3 7m51s 2m37s 18 3 6m57s 2m19s 19 3 5m44s 1m54s 20 3 6m12s 2m4s 21 3 5m48s 1m56s 22 3 5m32s 1m50s [ User: intelifix - Total duration: 2h4m56s - Times executed: 48 ]
[ Application: psql - Total duration: 2h4m56s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-30 10:14:03 Duration: 9m2s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-30 15:13:44 Duration: 8m42s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-30 09:13:34 Duration: 8m32s Database: rio User: intelifix Remote: [local] Application: psql
3 1h15m21s 48 248ms 4m45s 1m34s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 30 07 3 4m59s 1m39s 08 3 5m3s 1m41s 09 3 5m5s 1m41s 10 3 5m15s 1m45s 11 3 5m16s 1m45s 12 3 5m44s 1m54s 13 3 4m53s 1m37s 14 3 5m21s 1m47s 15 3 5m4s 1m41s 16 3 4m40s 1m33s 17 3 4m38s 1m32s 18 3 3m54s 1m18s 19 3 3m42s 1m14s 20 3 4m21s 1m27s 21 3 3m37s 1m12s 22 3 3m42s 1m14s [ User: intelifix - Total duration: 1h15m21s - Times executed: 48 ]
[ Application: psql - Total duration: 1h15m21s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-30 12:19:26 Duration: 4m45s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-30 14:19:06 Duration: 4m21s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-30 11:19:03 Duration: 4m20s Database: brasilia User: intelifix Remote: [local] Application: psql
4 21m3s 1,411 150ms 6s551ms 895ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 30 07 36 40s990ms 1s138ms 08 89 1m28s 996ms 09 185 2m23s 775ms 10 162 2m16s 841ms 11 196 2m23s 730ms 12 74 1m6s 897ms 13 40 38s15ms 950ms 14 200 2m52s 864ms 15 199 3m6s 939ms 16 170 2m49s 999ms 17 60 1m16s 1s269ms [ User: intelifix - Total duration: 21m3s - Times executed: 1411 ]
[ Application: [unknown] - Total duration: 21m3s - Times executed: 1411 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (260010, 450, 'F200011341B1574,84011293633D$F200013244B33C1,1834AF9B7F7D$F200010281B6586,743AEFAC98A0$F200013244B02E8,1834AF9B6A1B$F200010287B7C23,743AEFADE161$F200010154182C2,743AEF34A140$F20001019611C2E,743AEF75A8EA$F200012271B1065,1834AF603716$F200011015B532D,9877E7095750$F20001019012326,743AEF74ACA4$F200012026B3CB9,840112BEEF62$F200012054B69A3,840112C12669$F200012010B5487,84011296F13D$F200011127B3253,9877E7B924EF$F200011257B3E92,84011238195F$F200011274B0D23,8401125E1CC2$F200011272B0D7E,84011239A269$F200012311B31FE,1834AF6162C6$F200010356B3899,9877E7069B81$F200012353BCE84,1834AF986E7A$F200011118BC078,9877E7B81833$F200012154B4623,840112EB9C9E$F200011082B99E7,9877E74B9FFF$F20001014717185,743AEF330398$F200011272B2B7F,84011239AF89$F200011294B4122,84011260E40D$F200010345B6DAD,9877E70253A0$F200012234B68A7,1834AF271F9E$F200011200B8949,840112057AD0$F200010284B51FE,743AEFAD76BD$F200011315B7C4B,840112811822$F200011329B1B33,84011283AE27$F200011134B4223,9877E7BA6C67$F200011168B3F15,9877E7BDAC10$F200012102B35F9,840112E119AD$F200012151B506A,840112EAD83C$F200013235B0D66,1834AF9A47E1$F200013244B3802,1834AF9B8159$F200011134B2833,9877E7BA610E', '',0153,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-30 15:30:39 Duration: 6s551ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (44223, 407, '226209592648', '',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-30 15:24:33 Duration: 5s308ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (259585, 452, 'ZTE3QJRP8K03350,E466AB519E02,E466AB519E03,ZTEGD3965214$ZTE3QJRP2E43905,8493B2E3F239,8493B2E3F23A,ZTEGD1574AE7$ZTE3QJRP6V26642,E466AB593E2A,E466AB593E2B,ZTEGD3979770$ZTE3QJRP6V27550,E466AB595372,E466AB595373,ZTEGD3979AFC$ZTE3QJRQ2L23616,3CF9F06A4013,3CF9F06A4014,ZTEGD4E75AED$ZTE3QJRQ2L23071,3CF9F06A334D,3CF9F06A334E,ZTEGD4E758CC$ZTE3QJRQ2212344,3CF9F06DE333,3CF9F06DE334,ZTEGD4E7F61D$ZTE3QJRP6V28193,E466AB596284,E466AB596285,ZTEGD3979D7F$ZTE3QJRQ2212380,3CF9F06DE40B,3CF9F06DE40C,ZTEGD4E7F641$ZTE3QJRP6V03463,E466AB571EE8,E466AB571EE9,ZTEGD3973CE5$ZTE3QJRP8K02882,E466AB51930A,E466AB51930B,ZTEGD3965040$ZTE3QJRP6V14596,E466AB5823D6,E466AB5823D7,ZTEGD3976862$ZTE3QJRPA451106,9C635B87F4DE,9C635B87F4DF,ZTEGD3A74E5B$ZTE3QJRPA400241,9C635B834CB8,9C635B834CB9,ZTEGD3A687AA$ZTE3QJRP2E03230,8493B2E038E7,8493B2E038E8,ZTEGD156AC04$ZTE3QJRPA406743,9C635B83E51C,9C635B83E51D,ZTEGD3A6A110$ZTE3QJRPA442010,9C635B871FAE,9C635B871FAF,ZTEGD3A72AD3$ZTE3QJRQ2206720,3CF9F06D5F63,3CF9F06D5F64,ZTEGD4E7E025$ZTE3QJRP8K04447,E466AB51B7B8,E466AB51B7B9,ZTEGD396565D$ZTE3QJRQ2L13012,3CF9F069478B,3CF9F069478C,ZTEGD4E73181$ZTE3QJRP6V23870,E466AB58FD32,E466AB58FD33,ZTEGD3978C9C$ZTE3QJRQ2L03548,3CF9F06869BB,3CF9F06869BC,ZTEGD4E70C89$ZTE3QJRQ2L40262,3CF9F06BC637,3CF9F06BC638,ZTEGD4E79BF3$ZTE3QJRPA446492,9C635B8788BA,9C635B8788BB,ZTEGD3A73C55$ZTE3QJRQ2L19721,3CF9F069E4C9,3CF9F069E4CA,ZTEGD4E74BB6$ZTE3QJRQ2L03700,3CF9F0686D4B,3CF9F0686D4C,ZTEGD4E70D21$ZTE3QJRQ2L19245,3CF9F069D9A1,3CF9F069D9A2,ZTEGD4E749DA$ZTE3QJRPA444304,9C635B875572,9C635B875573,ZTEGD3A733C9$ZTE3QJRP6V28087,E466AB596008,E466AB596009,ZTEGD3979D15$ZTE3QJRQ2208384,3CF9F06D8663,3CF9F06D8664,ZTEGD4E7E6A5$ZTE3QJRQ2208535,3CF9F06D89ED,3CF9F06D89EE,ZTEGD4E7E73C$ZTE3QJRP6V29989,E466AB598C9C,E466AB598C9D,ZTEGD397A483$ZTE3QJRQ2L35428,3CF9F06B54EB,3CF9F06B54EC,ZTEGD4E78911$ZTE3QJRP6V30659,E466AB599C50,E466AB599C51,ZTEGD397A721$ZTE3QJRP6V14920,E466AB582B6E,E466AB582B6F,ZTEGD39769A6$ZTE3QJRPA409158,9C635B841DB6,9C635B841DB7,ZTEGD3A6AA7F$ZTE3QJRPA447092,9C635B8796CA,9C635B8796CB,ZTEGD3A73EAD$ZTE3QJRP8K20200,E466AB5328EE,E466AB5328EF,ZTEGD39693E6$ZTE3QJRPA417193,9C635B84DA08,9C635B84DA09,ZTEGD3A6C9E2', '',0303,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-30 16:47:01 Duration: 4s962ms Database: rio User: intelifix Remote: [local] Application: [unknown]
5 15m10s 3 2m20s 8m47s 5m3s analyze verbose;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 30 05 3 15m10s 5m3s [ User: intelifix - Total duration: 15m10s - Times executed: 3 ]
[ Application: psql - Total duration: 15m10s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-06-30 05:08:49 Duration: 8m47s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-30 05:12:51 Duration: 4m1s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-30 05:15:11 Duration: 2m20s Database: contagem User: intelifix Remote: [local] Application: psql
6 12m40s 77 821ms 51s898ms 9s882ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 30 07 5 26s309ms 5s261ms 08 1 51s898ms 51s898ms 09 10 1m20s 8s76ms 10 5 16s380ms 3s276ms 11 4 15s900ms 3s975ms 12 3 14s161ms 4s720ms 13 5 1m55s 23s144ms 14 8 1m34s 11s860ms 15 16 1m2s 3s922ms 16 11 2m36s 14s257ms 17 9 2m5s 13s925ms [ User: intelifix - Total duration: 12m40s - Times executed: 77 ]
[ Application: [unknown] - Total duration: 12m40s - Times executed: 77 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-30', 0395, '', '', 0, 6, '2026-06-01');
Date: 2026-06-30 08:52:17 Duration: 51s898ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-30', 0175, '', '', 0, 6, '2026-06-01');
Date: 2026-06-30 16:00:29 Duration: 49s11ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-30', 0175, '', '', 0, 6, '2026-06-01');
Date: 2026-06-30 13:23:28 Duration: 47s247ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 11m11s 56 9s478ms 35s729ms 11s996ms create table temp0000283966 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 30 07 14 3m 12s875ms 08 16 3m16s 12s279ms 09 14 2m36s 11s165ms 10 12 2m18s 11s561ms [ User: intelifix - Total duration: 11m11s - Times executed: 56 ]
[ Application: [unknown] - Total duration: 11m11s - Times executed: 56 ]
-
CREATE TABLE temp0000283966 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-30 07:07:58 Duration: 35s729ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283966 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-30 07:32:12 Duration: 14s279ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283966 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-30 08:40:28 Duration: 13s951ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 10m43s 54 9s29ms 24s884ms 11s907ms create table temp0000284032 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 30 10 5 53s174ms 10s634ms 11 17 3m15s 11s502ms 12 3 35s908ms 11s969ms 14 15 3m10s 12s676ms 15 5 57s901ms 11s580ms 16 9 1m50s 12s257ms [ User: intelifix - Total duration: 10m43s - Times executed: 54 ]
[ Application: [unknown] - Total duration: 10m43s - Times executed: 54 ]
-
CREATE TABLE temp0000284032 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-30 14:18:19 Duration: 24s884ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284032 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-30 14:42:40 Duration: 15s364ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284032 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-30 14:42:57 Duration: 14s944ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 9m22s 1,150 150ms 3s162ms 489ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 30 07 1 595ms 595ms 08 194 1m57s 606ms 09 135 59s901ms 443ms 10 101 50s240ms 497ms 11 144 1m16s 529ms 12 6 4s334ms 722ms 13 103 43s212ms 419ms 14 96 46s395ms 483ms 15 149 1m2s 416ms 16 144 58s144ms 403ms 17 77 43s625ms 566ms [ User: intelifix - Total duration: 9m22s - Times executed: 1150 ]
[ Application: [unknown] - Total duration: 9m22s - Times executed: 1150 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "108194", "modelo" : "263", "itens" : "229911108293,229914284148,229871926063,229877117389,229909253040,229908021315,229893444561,229897925256,229893575561,229901842732,229896445269,229895289713,229912940819,229900254754,229914924547,229915678391,229920614261,229897169212,229916052020,229896499214,229908558493,229907998507,229899357483,229909748700,229896292224,229896463554,229909324663,229901167076,229896404053,229902753438,229902747073,229902408601,229912366486,229897352541,229911883353,229908256668,229919256586,229899165568", "usuario" : "414", "caixa" : "1299095", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-30 17:05:41 Duration: 3s162ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "260043", "modelo" : "320", "itens" : "241689327881,241679395880,230048514566,241609924263,241655428805,241691379495,241649738585,241618560112,241658080815,241700033046,241658188097,241694310524,241603082529,241631464255,241672621426,241656477683,241661194362,241651507490,241634748403,241658313845,241706567476,241701771117,241595484144,241726187988,241694455565,241675318085,241716686971,241620786972,241710913131,241658924365,241714737589,241703911427,241669995355,241707356678,241603583139,241658952022,241714875560,241708384949,241654403542,241658097482,241649800209,241712261232,241730413250,241728876264,241656470815,241593902127,241591958705,241610090722", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-30 08:01:47 Duration: 2s896ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "104485", "modelo" : "34", "itens" : "216571938789,216455827278,216420802929,216574643555,216600973947,216716655966,216656184958", "usuario" : "414", "caixa" : "1221150", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-30 10:06:08 Duration: 2s892ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 7m10s 148 169ms 13s627ms 2s910ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 30 00 6 22s343ms 3s723ms 01 4 7s868ms 1s967ms 02 5 10s88ms 2s17ms 03 5 9s117ms 1s823ms 04 6 8s918ms 1s486ms 05 4 9s185ms 2s296ms 06 2 1s317ms 658ms 07 5 26s325ms 5s265ms 08 6 29s356ms 4s892ms 09 9 39s155ms 4s350ms 10 12 48s601ms 4s50ms 11 12 49s444ms 4s120ms 12 12 37s883ms 3s156ms 13 11 10s189ms 926ms 14 10 37s887ms 3s788ms 15 12 37s255ms 3s104ms 16 11 24s727ms 2s247ms 17 5 3s367ms 673ms 21 5 10s130ms 2s26ms 22 6 7s594ms 1s265ms [ User: intelifix - Total duration: 7m10s - Times executed: 148 ]
[ Application: psql - Total duration: 7m10s - Times executed: 148 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-30 00:05:14 Duration: 13s627ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-30 11:35:09 Duration: 8s519ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-30 10:25:09 Duration: 7s757ms Database: rio User: intelifix Remote: [local] Application: psql
11 6m23s 166 150ms 8s946ms 2s307ms call rs_giga_triagem (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 30 00 8 21s832ms 2s729ms 01 7 15s603ms 2s229ms 02 6 13s997ms 2s332ms 03 8 16s36ms 2s4ms 04 8 15s396ms 1s924ms 05 6 16s422ms 2s737ms 06 6 14s282ms 2s380ms 07 8 16s142ms 2s17ms 08 6 18s278ms 3s46ms 09 8 20s278ms 2s534ms 10 9 23s963ms 2s662ms 11 6 16s651ms 2s775ms 12 8 17s463ms 2s182ms 13 6 17s67ms 2s844ms 14 7 16s870ms 2s410ms 15 7 16s683ms 2s383ms 16 7 15s950ms 2s278ms 17 7 16s19ms 2s288ms 18 9 13s852ms 1s539ms 19 7 14s697ms 2s99ms 20 9 17s592ms 1s954ms 21 6 14s651ms 2s441ms 22 7 13s371ms 1s910ms [ User: intelifix - Total duration: 6m23s - Times executed: 166 ]
[ Application: psql - Total duration: 6m23s - Times executed: 166 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-30 00:05:23 Duration: 8s946ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-30 10:25:14 Duration: 5s573ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-30 10:05:11 Duration: 5s249ms Database: rio User: intelifix Remote: [local] Application: psql
12 6m 30 8s978ms 34s876ms 12s30ms create table temp0000284066 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 30 14 7 1m15s 10s798ms 15 18 3m25s 11s428ms 16 5 1m19s 15s924ms [ User: intelifix - Total duration: 6m - Times executed: 30 ]
[ Application: [unknown] - Total duration: 6m - Times executed: 30 ]
-
CREATE TABLE temp0000284066 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-30 16:31:16 Duration: 34s876ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284066 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-30 15:07:55 Duration: 14s660ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284066 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-30 15:07:15 Duration: 13s112ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 4m54s 1 4m54s 4m54s 4m54s 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 #13
Day Hour Count Duration Avg duration Jun 30 10 1 4m54s 4m54s [ User: intelifix - Total duration: 4m54s - Times executed: 1 ]
[ Application: [unknown] - Total duration: 4m54s - Times executed: 1 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026365, 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-30 10:40:03 Duration: 4m54s Database: rio User: intelifix Remote: [local] Application: [unknown]
14 2m58s 4 4s260ms 1m26s 44s732ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 30 20 2 1m31s 45s891ms 23 2 1m27s 43s572ms [ 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-30 20:08:23 Duration: 1m26s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-30 23:36:31 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-30 20:10:06 Duration: 5s98ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 2m39s 43 2s744ms 4s699ms 3s720ms create table temp0000283966 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 30 07 2 7s439ms 3s719ms 08 19 1m10s 3s708ms 09 6 21s375ms 3s562ms 10 16 1m 3s794ms [ User: intelifix - Total duration: 2m39s - Times executed: 43 ]
[ Application: [unknown] - Total duration: 2m39s - Times executed: 43 ]
-
CREATE TABLE temp0000283966 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"25-06-2026", "ate" :"30-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-30 09:21:02 Duration: 4s699ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283966 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"25-06-2026", "ate" :"30-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-30 08:47:00 Duration: 4s518ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283966 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"25-06-2026", "ate" :"30-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-30 10:22:53 Duration: 4s481ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 2m27s 37 668ms 12s455ms 3s984ms 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 30 08 2 6s784ms 3s392ms 09 3 13s89ms 4s363ms 10 3 13s944ms 4s648ms 11 3 20s29ms 6s676ms 12 3 11s20ms 3s673ms 13 2 3s569ms 1s784ms 14 3 9s787ms 3s262ms 15 3 23s785ms 7s928ms 16 2 13s920ms 6s960ms 17 2 18s382ms 9s191ms 18 2 2s356ms 1s178ms 19 2 2s493ms 1s246ms 20 3 4s409ms 1s469ms 21 2 2s395ms 1s197ms 22 2 1s451ms 725ms [ User: intelifix - Total duration: 2m27s - Times executed: 37 ]
[ Application: psql - Total duration: 2m27s - Times executed: 37 ]
-
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-30 17:00:13 Duration: 12s455ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-06-30 15:00:13 Duration: 11s453ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-06-30 11:40:11 Duration: 9s490ms Database: rio User: intelifix Remote: [local] Application: psql
17 2m14s 12 9s267ms 16s119ms 11s178ms create table temp0000284078 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 30 15 3 34s708ms 11s569ms 16 9 1m39s 11s48ms [ User: intelifix - Total duration: 2m14s - Times executed: 12 ]
[ Application: [unknown] - Total duration: 2m14s - Times executed: 12 ]
-
CREATE TABLE temp0000284078 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-30 16:02:02 Duration: 16s119ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284078 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-30 15:57:06 Duration: 12s276ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284078 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-30 15:51:03 Duration: 11s775ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 1m59s 10 9s303ms 14s170ms 11s931ms create table temp0000284012 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 30 09 5 57s383ms 11s476ms 10 3 40s137ms 13s379ms 11 2 21s795ms 10s897ms [ User: intelifix - Total duration: 1m59s - Times executed: 10 ]
[ Application: [unknown] - Total duration: 1m59s - Times executed: 10 ]
-
CREATE TABLE temp0000284012 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-30 10:00:36 Duration: 14s170ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284012 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-30 10:01:47 Duration: 13s202ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284012 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-30 09:09:59 Duration: 12s882ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 1m52s 54 290ms 58s182ms 2s92ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 30 07 9 1m4s 7s119ms 08 6 3s917ms 652ms 09 6 6s398ms 1s66ms 10 6 4s434ms 739ms 11 8 7s935ms 991ms 12 1 487ms 487ms 14 7 5s261ms 751ms 15 6 10s936ms 1s822ms 16 5 9s541ms 1s908ms [ User: intelifix - Total duration: 1m52s - Times executed: 54 ]
[ Application: psql - Total duration: 1m52s - Times executed: 54 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 305); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026346);
Date: 2026-06-30 07:40:57 Duration: 58s182ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 452); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026394);
Date: 2026-06-30 16:50:38 Duration: 4s531ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026383);
Date: 2026-06-30 15:01:06 Duration: 4s232ms Database: rio User: intelifix Remote: [local] Application: psql
20 1m52s 3 6s229ms 1m26s 37s500ms copy auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 30 23 3 1m52s 37s500ms [ User: intelifix - Total duration: 1m52s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 1m52s - Times executed: 3 ]
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-30 23:15:16 Duration: 1m26s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-30 23:47:55 Duration: 19s660ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-30 23:37:05 Duration: 6s229ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,411 21m3s 150ms 6s551ms 895ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 30 07 36 40s990ms 1s138ms 08 89 1m28s 996ms 09 185 2m23s 775ms 10 162 2m16s 841ms 11 196 2m23s 730ms 12 74 1m6s 897ms 13 40 38s15ms 950ms 14 200 2m52s 864ms 15 199 3m6s 939ms 16 170 2m49s 999ms 17 60 1m16s 1s269ms [ User: intelifix - Total duration: 21m3s - Times executed: 1411 ]
[ Application: [unknown] - Total duration: 21m3s - Times executed: 1411 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (260010, 450, 'F200011341B1574,84011293633D$F200013244B33C1,1834AF9B7F7D$F200010281B6586,743AEFAC98A0$F200013244B02E8,1834AF9B6A1B$F200010287B7C23,743AEFADE161$F200010154182C2,743AEF34A140$F20001019611C2E,743AEF75A8EA$F200012271B1065,1834AF603716$F200011015B532D,9877E7095750$F20001019012326,743AEF74ACA4$F200012026B3CB9,840112BEEF62$F200012054B69A3,840112C12669$F200012010B5487,84011296F13D$F200011127B3253,9877E7B924EF$F200011257B3E92,84011238195F$F200011274B0D23,8401125E1CC2$F200011272B0D7E,84011239A269$F200012311B31FE,1834AF6162C6$F200010356B3899,9877E7069B81$F200012353BCE84,1834AF986E7A$F200011118BC078,9877E7B81833$F200012154B4623,840112EB9C9E$F200011082B99E7,9877E74B9FFF$F20001014717185,743AEF330398$F200011272B2B7F,84011239AF89$F200011294B4122,84011260E40D$F200010345B6DAD,9877E70253A0$F200012234B68A7,1834AF271F9E$F200011200B8949,840112057AD0$F200010284B51FE,743AEFAD76BD$F200011315B7C4B,840112811822$F200011329B1B33,84011283AE27$F200011134B4223,9877E7BA6C67$F200011168B3F15,9877E7BDAC10$F200012102B35F9,840112E119AD$F200012151B506A,840112EAD83C$F200013235B0D66,1834AF9A47E1$F200013244B3802,1834AF9B8159$F200011134B2833,9877E7BA610E', '',0153,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-30 15:30:39 Duration: 6s551ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (44223, 407, '226209592648', '',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-30 15:24:33 Duration: 5s308ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (259585, 452, 'ZTE3QJRP8K03350,E466AB519E02,E466AB519E03,ZTEGD3965214$ZTE3QJRP2E43905,8493B2E3F239,8493B2E3F23A,ZTEGD1574AE7$ZTE3QJRP6V26642,E466AB593E2A,E466AB593E2B,ZTEGD3979770$ZTE3QJRP6V27550,E466AB595372,E466AB595373,ZTEGD3979AFC$ZTE3QJRQ2L23616,3CF9F06A4013,3CF9F06A4014,ZTEGD4E75AED$ZTE3QJRQ2L23071,3CF9F06A334D,3CF9F06A334E,ZTEGD4E758CC$ZTE3QJRQ2212344,3CF9F06DE333,3CF9F06DE334,ZTEGD4E7F61D$ZTE3QJRP6V28193,E466AB596284,E466AB596285,ZTEGD3979D7F$ZTE3QJRQ2212380,3CF9F06DE40B,3CF9F06DE40C,ZTEGD4E7F641$ZTE3QJRP6V03463,E466AB571EE8,E466AB571EE9,ZTEGD3973CE5$ZTE3QJRP8K02882,E466AB51930A,E466AB51930B,ZTEGD3965040$ZTE3QJRP6V14596,E466AB5823D6,E466AB5823D7,ZTEGD3976862$ZTE3QJRPA451106,9C635B87F4DE,9C635B87F4DF,ZTEGD3A74E5B$ZTE3QJRPA400241,9C635B834CB8,9C635B834CB9,ZTEGD3A687AA$ZTE3QJRP2E03230,8493B2E038E7,8493B2E038E8,ZTEGD156AC04$ZTE3QJRPA406743,9C635B83E51C,9C635B83E51D,ZTEGD3A6A110$ZTE3QJRPA442010,9C635B871FAE,9C635B871FAF,ZTEGD3A72AD3$ZTE3QJRQ2206720,3CF9F06D5F63,3CF9F06D5F64,ZTEGD4E7E025$ZTE3QJRP8K04447,E466AB51B7B8,E466AB51B7B9,ZTEGD396565D$ZTE3QJRQ2L13012,3CF9F069478B,3CF9F069478C,ZTEGD4E73181$ZTE3QJRP6V23870,E466AB58FD32,E466AB58FD33,ZTEGD3978C9C$ZTE3QJRQ2L03548,3CF9F06869BB,3CF9F06869BC,ZTEGD4E70C89$ZTE3QJRQ2L40262,3CF9F06BC637,3CF9F06BC638,ZTEGD4E79BF3$ZTE3QJRPA446492,9C635B8788BA,9C635B8788BB,ZTEGD3A73C55$ZTE3QJRQ2L19721,3CF9F069E4C9,3CF9F069E4CA,ZTEGD4E74BB6$ZTE3QJRQ2L03700,3CF9F0686D4B,3CF9F0686D4C,ZTEGD4E70D21$ZTE3QJRQ2L19245,3CF9F069D9A1,3CF9F069D9A2,ZTEGD4E749DA$ZTE3QJRPA444304,9C635B875572,9C635B875573,ZTEGD3A733C9$ZTE3QJRP6V28087,E466AB596008,E466AB596009,ZTEGD3979D15$ZTE3QJRQ2208384,3CF9F06D8663,3CF9F06D8664,ZTEGD4E7E6A5$ZTE3QJRQ2208535,3CF9F06D89ED,3CF9F06D89EE,ZTEGD4E7E73C$ZTE3QJRP6V29989,E466AB598C9C,E466AB598C9D,ZTEGD397A483$ZTE3QJRQ2L35428,3CF9F06B54EB,3CF9F06B54EC,ZTEGD4E78911$ZTE3QJRP6V30659,E466AB599C50,E466AB599C51,ZTEGD397A721$ZTE3QJRP6V14920,E466AB582B6E,E466AB582B6F,ZTEGD39769A6$ZTE3QJRPA409158,9C635B841DB6,9C635B841DB7,ZTEGD3A6AA7F$ZTE3QJRPA447092,9C635B8796CA,9C635B8796CB,ZTEGD3A73EAD$ZTE3QJRP8K20200,E466AB5328EE,E466AB5328EF,ZTEGD39693E6$ZTE3QJRPA417193,9C635B84DA08,9C635B84DA09,ZTEGD3A6C9E2', '',0303,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-30 16:47:01 Duration: 4s962ms Database: rio User: intelifix Remote: [local] Application: [unknown]
2 1,150 9m22s 150ms 3s162ms 489ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 30 07 1 595ms 595ms 08 194 1m57s 606ms 09 135 59s901ms 443ms 10 101 50s240ms 497ms 11 144 1m16s 529ms 12 6 4s334ms 722ms 13 103 43s212ms 419ms 14 96 46s395ms 483ms 15 149 1m2s 416ms 16 144 58s144ms 403ms 17 77 43s625ms 566ms [ User: intelifix - Total duration: 9m22s - Times executed: 1150 ]
[ Application: [unknown] - Total duration: 9m22s - Times executed: 1150 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "108194", "modelo" : "263", "itens" : "229911108293,229914284148,229871926063,229877117389,229909253040,229908021315,229893444561,229897925256,229893575561,229901842732,229896445269,229895289713,229912940819,229900254754,229914924547,229915678391,229920614261,229897169212,229916052020,229896499214,229908558493,229907998507,229899357483,229909748700,229896292224,229896463554,229909324663,229901167076,229896404053,229902753438,229902747073,229902408601,229912366486,229897352541,229911883353,229908256668,229919256586,229899165568", "usuario" : "414", "caixa" : "1299095", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-30 17:05:41 Duration: 3s162ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "260043", "modelo" : "320", "itens" : "241689327881,241679395880,230048514566,241609924263,241655428805,241691379495,241649738585,241618560112,241658080815,241700033046,241658188097,241694310524,241603082529,241631464255,241672621426,241656477683,241661194362,241651507490,241634748403,241658313845,241706567476,241701771117,241595484144,241726187988,241694455565,241675318085,241716686971,241620786972,241710913131,241658924365,241714737589,241703911427,241669995355,241707356678,241603583139,241658952022,241714875560,241708384949,241654403542,241658097482,241649800209,241712261232,241730413250,241728876264,241656470815,241593902127,241591958705,241610090722", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-30 08:01:47 Duration: 2s896ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "104485", "modelo" : "34", "itens" : "216571938789,216455827278,216420802929,216574643555,216600973947,216716655966,216656184958", "usuario" : "414", "caixa" : "1221150", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-30 10:06:08 Duration: 2s892ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 292 2h10m35s 150ms 5m39s 26s834ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 30 07 12 15m4s 1m15s 08 41 10m36s 15s527ms 09 42 26m23s 37s701ms 10 23 14m41s 38s331ms 11 21 14m41s 41s982ms 12 3 9m25s 3m8s 13 29 1m22s 2s834ms 14 32 13m39s 25s621ms 15 38 9m4s 14s326ms 16 35 14m33s 24s959ms 17 13 21s159ms 1s627ms 18 3 40s796ms 13s598ms [ User: intelifix - Total duration: 2h10m35s - Times executed: 292 ]
[ Application: [unknown] - Total duration: 2h10m35s - Times executed: 292 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026385, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-30 15:11:34 Duration: 5m39s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026391, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-30 16:07:24 Duration: 5m19s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026363, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-30 10:13:05 Duration: 5m16s Database: rio User: intelifix Remote: [local] Application: [unknown]
4 247 41s86ms 150ms 208ms 166ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 30 01 2 374ms 187ms 07 9 1s472ms 163ms 08 52 8s547ms 164ms 09 24 3s886ms 161ms 10 30 4s997ms 166ms 11 34 5s714ms 168ms 12 11 1s784ms 162ms 13 9 1s508ms 167ms 14 17 2s846ms 167ms 15 36 6s99ms 169ms 16 14 2s300ms 164ms 17 9 1s555ms 172ms [ User: intelifix - Total duration: 41s86ms - Times executed: 247 ]
[ Application: [unknown] - Total duration: 41s86ms - Times executed: 247 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0153;
Date: 2026-06-30 14:43:59 Duration: 208ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-06-30 09:51:38 Duration: 205ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0190;
Date: 2026-06-30 15:08:29 Duration: 201ms Database: rio User: intelifix Remote: [local] Application: [unknown]
5 166 6m23s 150ms 8s946ms 2s307ms call rs_giga_triagem (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 30 00 8 21s832ms 2s729ms 01 7 15s603ms 2s229ms 02 6 13s997ms 2s332ms 03 8 16s36ms 2s4ms 04 8 15s396ms 1s924ms 05 6 16s422ms 2s737ms 06 6 14s282ms 2s380ms 07 8 16s142ms 2s17ms 08 6 18s278ms 3s46ms 09 8 20s278ms 2s534ms 10 9 23s963ms 2s662ms 11 6 16s651ms 2s775ms 12 8 17s463ms 2s182ms 13 6 17s67ms 2s844ms 14 7 16s870ms 2s410ms 15 7 16s683ms 2s383ms 16 7 15s950ms 2s278ms 17 7 16s19ms 2s288ms 18 9 13s852ms 1s539ms 19 7 14s697ms 2s99ms 20 9 17s592ms 1s954ms 21 6 14s651ms 2s441ms 22 7 13s371ms 1s910ms [ User: intelifix - Total duration: 6m23s - Times executed: 166 ]
[ Application: psql - Total duration: 6m23s - Times executed: 166 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-30 00:05:23 Duration: 8s946ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-30 10:25:14 Duration: 5s573ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-30 10:05:11 Duration: 5s249ms Database: rio User: intelifix Remote: [local] Application: psql
6 148 7m10s 169ms 13s627ms 2s910ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 30 00 6 22s343ms 3s723ms 01 4 7s868ms 1s967ms 02 5 10s88ms 2s17ms 03 5 9s117ms 1s823ms 04 6 8s918ms 1s486ms 05 4 9s185ms 2s296ms 06 2 1s317ms 658ms 07 5 26s325ms 5s265ms 08 6 29s356ms 4s892ms 09 9 39s155ms 4s350ms 10 12 48s601ms 4s50ms 11 12 49s444ms 4s120ms 12 12 37s883ms 3s156ms 13 11 10s189ms 926ms 14 10 37s887ms 3s788ms 15 12 37s255ms 3s104ms 16 11 24s727ms 2s247ms 17 5 3s367ms 673ms 21 5 10s130ms 2s26ms 22 6 7s594ms 1s265ms [ User: intelifix - Total duration: 7m10s - Times executed: 148 ]
[ Application: psql - Total duration: 7m10s - Times executed: 148 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-30 00:05:14 Duration: 13s627ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-30 11:35:09 Duration: 8s519ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-30 10:25:09 Duration: 7s757ms Database: rio User: intelifix Remote: [local] Application: psql
7 109 52s604ms 263ms 805ms 482ms 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 #7
Day Hour Count Duration Avg duration Jun 30 00 1 515ms 515ms 01 2 854ms 427ms 03 1 443ms 443ms 04 2 763ms 381ms 05 1 312ms 312ms 06 1 379ms 379ms 07 12 5s507ms 458ms 08 11 4s869ms 442ms 09 9 5s51ms 561ms 10 8 4s279ms 534ms 11 10 4s885ms 488ms 12 5 2s351ms 470ms 13 9 4s48ms 449ms 14 9 4s599ms 511ms 15 12 5s906ms 492ms 16 8 4s58ms 507ms 17 6 2s937ms 489ms 20 1 471ms 471ms 21 1 369ms 369ms [ User: lenon - Total duration: 52s604ms - Times executed: 109 ]
[ Application: [unknown] - Total duration: 52s604ms - Times executed: 109 ]
-
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-30 09:17:12 Duration: 805ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-06-30 15:26:23 Duration: 788ms Database: contagem User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-06-30 09:14:02 Duration: 705ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
8 106 42s799ms 202ms 999ms 403ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 30 07 7 2s764ms 394ms 08 13 5s32ms 387ms 09 19 7s623ms 401ms 10 13 5s22ms 386ms 11 13 5s448ms 419ms 12 1 325ms 325ms 14 14 6s893ms 492ms 15 8 3s316ms 414ms 16 10 3s350ms 335ms 17 7 2s730ms 390ms 18 1 292ms 292ms [ User: intelifix - Total duration: 42s799ms - Times executed: 106 ]
[ Application: [unknown] - Total duration: 42s799ms - Times executed: 106 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-06-30 14:15:12 Duration: 999ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-06-30 09:10:00 Duration: 724ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-06-30 14:17:25 Duration: 617ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
9 103 20s823ms 151ms 423ms 202ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 30 01 8 1s423ms 177ms 04 5 1s424ms 284ms 05 1 209ms 209ms 07 14 3s64ms 218ms 08 13 2s664ms 204ms 09 8 1s449ms 181ms 10 7 1s377ms 196ms 11 11 1s951ms 177ms 12 10 1s936ms 193ms 14 9 2s100ms 233ms 15 11 2s82ms 189ms 16 6 1s137ms 189ms [ User: intelifix - Total duration: 20s823ms - Times executed: 103 ]
[ Application: [unknown] - Total duration: 20s823ms - Times executed: 103 ]
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '229919090712,229910289011,229916595058,229898053754,229894820925,229919798591,229892653440,229871217273,229892185964,229910576367,229912152627,229877165576,229894822440,229901850006,229916596876,229910155462,229896323439,229913521515,229915047892,229899337885,229876316974,229913183648,229918138687,229897971019,229898145861,229876738889,229908238989,229910143138,229900993244,229918571638,229914413555,229910366773,229910321921,229915738600,229900971626,229896535053,229919030729,229898046379', NULL, NULL, 0263, 00);
Date: 2026-06-30 04:54:54 Duration: 423ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (405, 5, '63', 2, '229733135268,229678143145,229715949517,229678157388,229678156176,229732910522,229732917390,229707649010,229712017595,229703902236,229702010817', NULL, NULL, 0137, 00);
Date: 2026-06-30 14:18:42 Duration: 321ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (405, 5, '63', 2, '229700408190,229706554952,229693725563,229699044758,229708605152,229674798485,216949575555,229827210926,229792972040,229830153244,229829881321,229827240828', NULL, NULL, 0137, 00);
Date: 2026-06-30 10:51:58 Duration: 315ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 100 1m 340ms 976ms 608ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 30 00 1 704ms 704ms 01 2 1s166ms 583ms 03 1 727ms 727ms 04 2 987ms 493ms 05 1 479ms 479ms 07 10 5s688ms 568ms 08 10 5s670ms 567ms 09 8 5s515ms 689ms 10 8 5s426ms 678ms 11 10 5s897ms 589ms 12 4 2s384ms 596ms 13 9 5s257ms 584ms 14 9 5s552ms 616ms 15 11 6s991ms 635ms 16 8 5s3ms 625ms 17 5 2s988ms 597ms 21 1 453ms 453ms [ User: intelifix - Total duration: 1m - Times executed: 100 ]
[ Application: [unknown] - Total duration: 1m - Times executed: 100 ]
-
select * from rs_menu_grants (407, 18, 1);
Date: 2026-06-30 15:26:23 Duration: 976ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (415, 21, 1);
Date: 2026-06-30 09:14:02 Duration: 886ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (414, 19, 1);
Date: 2026-06-30 09:17:12 Duration: 884ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 100 20s708ms 153ms 343ms 207ms select * from rs_lote_manutencao (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 30 07 1 281ms 281ms 08 10 2s395ms 239ms 09 20 4s7ms 200ms 10 24 5s419ms 225ms 11 15 2s789ms 185ms 13 10 2s38ms 203ms 14 20 3s776ms 188ms [ User: intelifix - Total duration: 20s708ms - Times executed: 100 ]
[ Application: [unknown] - Total duration: 20s708ms - Times executed: 100 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"298", "usuario" :"507", "tipo" :"N", "itens" :"001", "nota-fiscal" :"1563", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-06-30 09:21:10 Duration: 343ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"2", "cliente" :"1", "modelo" :"77", "usuario" :"407", "tipo" :"N", "itens" :"02", "nota-fiscal" :"10406", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-06-30 08:33:11 Duration: 328ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"313", "usuario" :"507", "tipo" :"N", "itens" :"003", "nota-fiscal" :"1563", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-06-30 10:19:59 Duration: 322ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 98 1m5s 169ms 2s599ms 669ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 30 07 2 3s386ms 1s693ms 08 26 15s853ms 609ms 09 8 2s546ms 318ms 10 1 330ms 330ms 11 1 1s594ms 1s594ms 13 19 10s352ms 544ms 14 9 5s578ms 619ms 15 13 11s404ms 877ms 16 12 9s533ms 794ms 17 6 4s292ms 715ms 18 1 753ms 753ms [ User: intelifix - Total duration: 1m5s - Times executed: 98 ]
[ Application: [unknown] - Total duration: 1m5s - Times executed: 98 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0124220) LIMIT 1;
Date: 2026-06-30 15:52:58 Duration: 2s599ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0124912) LIMIT 1;
Date: 2026-06-30 15:51:11 Duration: 2s496ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0259792) LIMIT 1;
Date: 2026-06-30 16:28:39 Duration: 2s464ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 95 47s397ms 150ms 1s257ms 498ms select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 30 08 46 21s82ms 458ms 09 20 12s661ms 633ms 10 10 6s639ms 663ms 11 7 3s761ms 537ms 17 12 3s253ms 271ms [ User: intelifix - Total duration: 47s397ms - Times executed: 95 ]
[ Application: [unknown] - Total duration: 47s397ms - Times executed: 95 ]
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (0103107);
Date: 2026-06-30 08:19:21 Duration: 1s257ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (103107);
Date: 2026-06-30 09:51:06 Duration: 1s30ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (104485);
Date: 2026-06-30 10:05:30 Duration: 956ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 85 15s98ms 150ms 384ms 177ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 30 01 1 156ms 156ms 07 1 384ms 384ms 10 1 184ms 184ms 11 7 1s153ms 164ms 12 3 505ms 168ms 13 5 924ms 184ms 14 11 1s765ms 160ms 15 17 3s11ms 177ms 16 18 3s365ms 186ms 17 21 3s646ms 173ms [ User: intelifix - Total duration: 15s98ms - Times executed: 85 ]
[ Application: [unknown] - Total duration: 15s98ms - Times executed: 85 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "364", "data-de" : "2026-06-29", "data-ate" : "2026-06-29", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 366 }');
Date: 2026-06-30 07:48:42 Duration: 384ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "364", "data-de" : "2026-06-30", "data-ate" : "2026-06-30", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 366 }');
Date: 2026-06-30 16:49:33 Duration: 249ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "431", "data-de" : "2026-06-30", "data-ate" : "2026-06-30", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 504 }');
Date: 2026-06-30 16:39:56 Duration: 246ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 77 12m40s 821ms 51s898ms 9s882ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 30 07 5 26s309ms 5s261ms 08 1 51s898ms 51s898ms 09 10 1m20s 8s76ms 10 5 16s380ms 3s276ms 11 4 15s900ms 3s975ms 12 3 14s161ms 4s720ms 13 5 1m55s 23s144ms 14 8 1m34s 11s860ms 15 16 1m2s 3s922ms 16 11 2m36s 14s257ms 17 9 2m5s 13s925ms [ User: intelifix - Total duration: 12m40s - Times executed: 77 ]
[ Application: [unknown] - Total duration: 12m40s - Times executed: 77 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-30', 0395, '', '', 0, 6, '2026-06-01');
Date: 2026-06-30 08:52:17 Duration: 51s898ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-30', 0175, '', '', 0, 6, '2026-06-01');
Date: 2026-06-30 16:00:29 Duration: 49s11ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-30', 0175, '', '', 0, 6, '2026-06-01');
Date: 2026-06-30 13:23:28 Duration: 47s247ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 61 21s788ms 152ms 1s206ms 357ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 30 07 1 918ms 918ms 08 12 6s219ms 518ms 09 7 2s838ms 405ms 10 3 1s597ms 532ms 11 2 480ms 240ms 12 3 558ms 186ms 13 1 174ms 174ms 14 2 402ms 201ms 15 7 2s274ms 324ms 16 9 2s380ms 264ms 17 14 3s943ms 281ms [ User: intelifix - Total duration: 21s788ms - Times executed: 61 ]
[ Application: [unknown] - Total duration: 21s788ms - Times executed: 61 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '4896D956765C,3891484F3561,D831399C7AA2,3CF9F0AB2908,843C993613DF,C4EBFF8D90F6,3891484C122D,48D682383242,14CA56D52AB3,6C11BA6BBEDB,5872C9946EFB,48D682310F96,D8313990323C,D89A0DA87B49,D89A0DAC660F,C4EBFF903252,843C9922C4BD,48D68232A74E,48D682330718,4896D956BC8E', '138;1', 'DEFAULT', 09, 0323, '','', '', 00);
Date: 2026-06-30 08:31:10 Duration: 1s206ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 1, 26, '216674746365,216659382936,216577186889,184293299498,466207107587,216575005363,216807252833,216381507982,216486813939,216758157895,216595272437,216588204564,216432242138,216436913637,216594540413,216786572229,216709919898,216652006873,216459235557,216577722430,216711502950,216657184663,216437293046,216595120021,216762748298,216659394149,184290902846,216476173956,216787035562,216717628294,216711055375,216575140506,216497683036,216458940322,216491180505,216461070507,216493843043,216382411820,216493852539,216570317980,216582492626,216329494444,216600445758,216762561738,216758612845,216481986767,216658367494,216721521425,216574122337,216692045966,216692002932,216597447272,216786667288,216455365258,216569038697,216674177488,216808240315,216494610627,216438802329,216463921122,216592506577,216781335769,216577507380,216786310307,216707993954,216573559902,216474861516,216377885665,216426910316,216760132735,216489434756,216465777688', '','DEFAULT',051,034,'', '','', 00);
Date: 2026-06-30 10:54:38 Duration: 1s97ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 1, 26, '216655074457,216748997899,216593797477,216379810422,216579872741,216588637086,216421076973,216439325567,216690887076,216777759113,216470799402,216678853254,216676359092,216656265673,216476808596,216653608387,216785356666,216494336783,216723030708,216716519915,216493961517,216599133745,216386917590,216774452135,216741265360,216807514856,216465486773,216571609510,216570697692,216570790609,216778600015,216482589307,216331549617,216569393839,216654317783,216474306882,216599680825,216574816175,216481310406,216573895367', '','DEFAULT',051,034,'', '','', 00);
Date: 2026-06-30 08:25:40 Duration: 999ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 56 11m11s 9s478ms 35s729ms 11s996ms create table temp0000283966 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 30 07 14 3m 12s875ms 08 16 3m16s 12s279ms 09 14 2m36s 11s165ms 10 12 2m18s 11s561ms [ User: intelifix - Total duration: 11m11s - Times executed: 56 ]
[ Application: [unknown] - Total duration: 11m11s - Times executed: 56 ]
-
CREATE TABLE temp0000283966 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-30 07:07:58 Duration: 35s729ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283966 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-30 07:32:12 Duration: 14s279ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283966 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-30 08:40:28 Duration: 13s951ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 54 10m43s 9s29ms 24s884ms 11s907ms create table temp0000284032 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 30 10 5 53s174ms 10s634ms 11 17 3m15s 11s502ms 12 3 35s908ms 11s969ms 14 15 3m10s 12s676ms 15 5 57s901ms 11s580ms 16 9 1m50s 12s257ms [ User: intelifix - Total duration: 10m43s - Times executed: 54 ]
[ Application: [unknown] - Total duration: 10m43s - Times executed: 54 ]
-
CREATE TABLE temp0000284032 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-30 14:18:19 Duration: 24s884ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284032 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-30 14:42:40 Duration: 15s364ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284032 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-30 14:42:57 Duration: 14s944ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 54 1m52s 290ms 58s182ms 2s92ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 30 07 9 1m4s 7s119ms 08 6 3s917ms 652ms 09 6 6s398ms 1s66ms 10 6 4s434ms 739ms 11 8 7s935ms 991ms 12 1 487ms 487ms 14 7 5s261ms 751ms 15 6 10s936ms 1s822ms 16 5 9s541ms 1s908ms [ User: intelifix - Total duration: 1m52s - Times executed: 54 ]
[ Application: psql - Total duration: 1m52s - Times executed: 54 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 305); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026346);
Date: 2026-06-30 07:40:57 Duration: 58s182ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 452); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026394);
Date: 2026-06-30 16:50:38 Duration: 4s531ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026383);
Date: 2026-06-30 15:01:06 Duration: 4s232ms Database: rio User: intelifix Remote: [local] Application: psql
20 52 8s663ms 151ms 208ms 166ms select * from rs_modelos_lista (?, ?) where mod_id = ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 30 07 5 861ms 172ms 08 13 2s127ms 163ms 09 2 336ms 168ms 10 6 981ms 163ms 11 6 988ms 164ms 13 1 160ms 160ms 14 1 176ms 176ms 15 8 1s297ms 162ms 16 7 1s225ms 175ms 17 3 507ms 169ms [ User: intelifix - Total duration: 8s663ms - Times executed: 52 ]
[ Application: [unknown] - Total duration: 8s663ms - Times executed: 52 ]
-
SELECT * FROM RS_MODELOS_LISTA (0, '') WHERE MOD_ID = 287;
Date: 2026-06-30 16:52:31 Duration: 208ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (0, '') WHERE MOD_ID = 318;
Date: 2026-06-30 16:01:13 Duration: 192ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (0, '') WHERE MOD_ID = 159;
Date: 2026-06-30 10:20:30 Duration: 186ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m20s 8m47s 5m3s 3 15m10s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 30 05 3 15m10s 5m3s [ User: intelifix - Total duration: 15m10s - Times executed: 3 ]
[ Application: psql - Total duration: 15m10s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-06-30 05:08:49 Duration: 8m47s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-30 05:12:51 Duration: 4m1s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-30 05:15:11 Duration: 2m20s Database: contagem User: intelifix Remote: [local] Application: psql
2 4m54s 4m54s 4m54s 1 4m54s 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 #2
Day Hour Count Duration Avg duration Jun 30 10 1 4m54s 4m54s [ User: intelifix - Total duration: 4m54s - Times executed: 1 ]
[ Application: [unknown] - Total duration: 4m54s - Times executed: 1 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026365, 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-30 10:40:03 Duration: 4m54s Database: rio User: intelifix Remote: [local] Application: [unknown]
3 1s283ms 9m2s 2m36s 48 2h4m56s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 30 07 3 9m3s 3m1s 08 3 8m20s 2m46s 09 3 9m6s 3m2s 10 3 9m39s 3m13s 11 3 8m51s 2m57s 12 3 8m45s 2m55s 13 3 7m18s 2m26s 14 3 8m49s 2m56s 15 3 9m9s 3m3s 16 3 7m47s 2m35s 17 3 7m51s 2m37s 18 3 6m57s 2m19s 19 3 5m44s 1m54s 20 3 6m12s 2m4s 21 3 5m48s 1m56s 22 3 5m32s 1m50s [ User: intelifix - Total duration: 2h4m56s - Times executed: 48 ]
[ Application: psql - Total duration: 2h4m56s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-30 10:14:03 Duration: 9m2s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-30 15:13:44 Duration: 8m42s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-30 09:13:34 Duration: 8m32s Database: rio User: intelifix Remote: [local] Application: psql
4 248ms 4m45s 1m34s 48 1h15m21s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 30 07 3 4m59s 1m39s 08 3 5m3s 1m41s 09 3 5m5s 1m41s 10 3 5m15s 1m45s 11 3 5m16s 1m45s 12 3 5m44s 1m54s 13 3 4m53s 1m37s 14 3 5m21s 1m47s 15 3 5m4s 1m41s 16 3 4m40s 1m33s 17 3 4m38s 1m32s 18 3 3m54s 1m18s 19 3 3m42s 1m14s 20 3 4m21s 1m27s 21 3 3m37s 1m12s 22 3 3m42s 1m14s [ User: intelifix - Total duration: 1h15m21s - Times executed: 48 ]
[ Application: psql - Total duration: 1h15m21s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-30 12:19:26 Duration: 4m45s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-30 14:19:06 Duration: 4m21s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-30 11:19:03 Duration: 4m20s Database: brasilia User: intelifix Remote: [local] Application: psql
5 4s260ms 1m26s 44s732ms 4 2m58s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 30 20 2 1m31s 45s891ms 23 2 1m27s 43s572ms [ 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-30 20:08:23 Duration: 1m26s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-30 23:36:31 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-30 20:10:06 Duration: 5s98ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 6s229ms 1m26s 37s500ms 3 1m52s copy auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 30 23 3 1m52s 37s500ms [ User: intelifix - Total duration: 1m52s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 1m52s - Times executed: 3 ]
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-30 23:15:16 Duration: 1m26s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-30 23:47:55 Duration: 19s660ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-30 23:37:05 Duration: 6s229ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 150ms 5m39s 26s834ms 292 2h10m35s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 30 07 12 15m4s 1m15s 08 41 10m36s 15s527ms 09 42 26m23s 37s701ms 10 23 14m41s 38s331ms 11 21 14m41s 41s982ms 12 3 9m25s 3m8s 13 29 1m22s 2s834ms 14 32 13m39s 25s621ms 15 38 9m4s 14s326ms 16 35 14m33s 24s959ms 17 13 21s159ms 1s627ms 18 3 40s796ms 13s598ms [ User: intelifix - Total duration: 2h10m35s - Times executed: 292 ]
[ Application: [unknown] - Total duration: 2h10m35s - Times executed: 292 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026385, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-30 15:11:34 Duration: 5m39s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026391, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-30 16:07:24 Duration: 5m19s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026363, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-30 10:13:05 Duration: 5m16s Database: rio User: intelifix Remote: [local] Application: [unknown]
8 8s978ms 34s876ms 12s30ms 30 6m create table temp0000284066 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 30 14 7 1m15s 10s798ms 15 18 3m25s 11s428ms 16 5 1m19s 15s924ms [ User: intelifix - Total duration: 6m - Times executed: 30 ]
[ Application: [unknown] - Total duration: 6m - Times executed: 30 ]
-
CREATE TABLE temp0000284066 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-30 16:31:16 Duration: 34s876ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284066 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-30 15:07:55 Duration: 14s660ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284066 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-30 15:07:15 Duration: 13s112ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 9s478ms 35s729ms 11s996ms 56 11m11s create table temp0000283966 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 30 07 14 3m 12s875ms 08 16 3m16s 12s279ms 09 14 2m36s 11s165ms 10 12 2m18s 11s561ms [ User: intelifix - Total duration: 11m11s - Times executed: 56 ]
[ Application: [unknown] - Total duration: 11m11s - Times executed: 56 ]
-
CREATE TABLE temp0000283966 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-30 07:07:58 Duration: 35s729ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283966 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-30 07:32:12 Duration: 14s279ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283966 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-30 08:40:28 Duration: 13s951ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 9s303ms 14s170ms 11s931ms 10 1m59s create table temp0000284012 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 30 09 5 57s383ms 11s476ms 10 3 40s137ms 13s379ms 11 2 21s795ms 10s897ms [ User: intelifix - Total duration: 1m59s - Times executed: 10 ]
[ Application: [unknown] - Total duration: 1m59s - Times executed: 10 ]
-
CREATE TABLE temp0000284012 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-30 10:00:36 Duration: 14s170ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284012 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-30 10:01:47 Duration: 13s202ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284012 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-30 09:09:59 Duration: 12s882ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 9s29ms 24s884ms 11s907ms 54 10m43s create table temp0000284032 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 30 10 5 53s174ms 10s634ms 11 17 3m15s 11s502ms 12 3 35s908ms 11s969ms 14 15 3m10s 12s676ms 15 5 57s901ms 11s580ms 16 9 1m50s 12s257ms [ User: intelifix - Total duration: 10m43s - Times executed: 54 ]
[ Application: [unknown] - Total duration: 10m43s - Times executed: 54 ]
-
CREATE TABLE temp0000284032 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-30 14:18:19 Duration: 24s884ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284032 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-30 14:42:40 Duration: 15s364ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284032 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-30 14:42:57 Duration: 14s944ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 9s267ms 16s119ms 11s178ms 12 2m14s create table temp0000284078 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 30 15 3 34s708ms 11s569ms 16 9 1m39s 11s48ms [ User: intelifix - Total duration: 2m14s - Times executed: 12 ]
[ Application: [unknown] - Total duration: 2m14s - Times executed: 12 ]
-
CREATE TABLE temp0000284078 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-30 16:02:02 Duration: 16s119ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284078 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-30 15:57:06 Duration: 12s276ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284078 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-30 15:51:03 Duration: 11s775ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 821ms 51s898ms 9s882ms 77 12m40s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 30 07 5 26s309ms 5s261ms 08 1 51s898ms 51s898ms 09 10 1m20s 8s76ms 10 5 16s380ms 3s276ms 11 4 15s900ms 3s975ms 12 3 14s161ms 4s720ms 13 5 1m55s 23s144ms 14 8 1m34s 11s860ms 15 16 1m2s 3s922ms 16 11 2m36s 14s257ms 17 9 2m5s 13s925ms [ User: intelifix - Total duration: 12m40s - Times executed: 77 ]
[ Application: [unknown] - Total duration: 12m40s - Times executed: 77 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-30', 0395, '', '', 0, 6, '2026-06-01');
Date: 2026-06-30 08:52:17 Duration: 51s898ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-30', 0175, '', '', 0, 6, '2026-06-01');
Date: 2026-06-30 16:00:29 Duration: 49s11ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-30', 0175, '', '', 0, 6, '2026-06-01');
Date: 2026-06-30 13:23:28 Duration: 47s247ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 668ms 12s455ms 3s984ms 37 2m27s call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 30 08 2 6s784ms 3s392ms 09 3 13s89ms 4s363ms 10 3 13s944ms 4s648ms 11 3 20s29ms 6s676ms 12 3 11s20ms 3s673ms 13 2 3s569ms 1s784ms 14 3 9s787ms 3s262ms 15 3 23s785ms 7s928ms 16 2 13s920ms 6s960ms 17 2 18s382ms 9s191ms 18 2 2s356ms 1s178ms 19 2 2s493ms 1s246ms 20 3 4s409ms 1s469ms 21 2 2s395ms 1s197ms 22 2 1s451ms 725ms [ User: intelifix - Total duration: 2m27s - Times executed: 37 ]
[ Application: psql - Total duration: 2m27s - Times executed: 37 ]
-
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-30 17:00:13 Duration: 12s455ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-06-30 15:00:13 Duration: 11s453ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-06-30 11:40:11 Duration: 9s490ms Database: rio User: intelifix Remote: [local] Application: psql
15 2s744ms 4s699ms 3s720ms 43 2m39s create table temp0000283966 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 30 07 2 7s439ms 3s719ms 08 19 1m10s 3s708ms 09 6 21s375ms 3s562ms 10 16 1m 3s794ms [ User: intelifix - Total duration: 2m39s - Times executed: 43 ]
[ Application: [unknown] - Total duration: 2m39s - Times executed: 43 ]
-
CREATE TABLE temp0000283966 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"25-06-2026", "ate" :"30-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-30 09:21:02 Duration: 4s699ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283966 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"25-06-2026", "ate" :"30-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-30 08:47:00 Duration: 4s518ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000283966 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"25-06-2026", "ate" :"30-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-30 10:22:53 Duration: 4s481ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 169ms 13s627ms 2s910ms 148 7m10s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 30 00 6 22s343ms 3s723ms 01 4 7s868ms 1s967ms 02 5 10s88ms 2s17ms 03 5 9s117ms 1s823ms 04 6 8s918ms 1s486ms 05 4 9s185ms 2s296ms 06 2 1s317ms 658ms 07 5 26s325ms 5s265ms 08 6 29s356ms 4s892ms 09 9 39s155ms 4s350ms 10 12 48s601ms 4s50ms 11 12 49s444ms 4s120ms 12 12 37s883ms 3s156ms 13 11 10s189ms 926ms 14 10 37s887ms 3s788ms 15 12 37s255ms 3s104ms 16 11 24s727ms 2s247ms 17 5 3s367ms 673ms 21 5 10s130ms 2s26ms 22 6 7s594ms 1s265ms [ User: intelifix - Total duration: 7m10s - Times executed: 148 ]
[ Application: psql - Total duration: 7m10s - Times executed: 148 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-30 00:05:14 Duration: 13s627ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-30 11:35:09 Duration: 8s519ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-30 10:25:09 Duration: 7s757ms Database: rio User: intelifix Remote: [local] Application: psql
17 150ms 8s946ms 2s307ms 166 6m23s call rs_giga_triagem (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 30 00 8 21s832ms 2s729ms 01 7 15s603ms 2s229ms 02 6 13s997ms 2s332ms 03 8 16s36ms 2s4ms 04 8 15s396ms 1s924ms 05 6 16s422ms 2s737ms 06 6 14s282ms 2s380ms 07 8 16s142ms 2s17ms 08 6 18s278ms 3s46ms 09 8 20s278ms 2s534ms 10 9 23s963ms 2s662ms 11 6 16s651ms 2s775ms 12 8 17s463ms 2s182ms 13 6 17s67ms 2s844ms 14 7 16s870ms 2s410ms 15 7 16s683ms 2s383ms 16 7 15s950ms 2s278ms 17 7 16s19ms 2s288ms 18 9 13s852ms 1s539ms 19 7 14s697ms 2s99ms 20 9 17s592ms 1s954ms 21 6 14s651ms 2s441ms 22 7 13s371ms 1s910ms [ User: intelifix - Total duration: 6m23s - Times executed: 166 ]
[ Application: psql - Total duration: 6m23s - Times executed: 166 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-30 00:05:23 Duration: 8s946ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-30 10:25:14 Duration: 5s573ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-30 10:05:11 Duration: 5s249ms Database: rio User: intelifix Remote: [local] Application: psql
18 290ms 58s182ms 2s92ms 54 1m52s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 30 07 9 1m4s 7s119ms 08 6 3s917ms 652ms 09 6 6s398ms 1s66ms 10 6 4s434ms 739ms 11 8 7s935ms 991ms 12 1 487ms 487ms 14 7 5s261ms 751ms 15 6 10s936ms 1s822ms 16 5 9s541ms 1s908ms [ User: intelifix - Total duration: 1m52s - Times executed: 54 ]
[ Application: psql - Total duration: 1m52s - Times executed: 54 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 305); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026346);
Date: 2026-06-30 07:40:57 Duration: 58s182ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 452); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026394);
Date: 2026-06-30 16:50:38 Duration: 4s531ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026383);
Date: 2026-06-30 15:01:06 Duration: 4s232ms Database: rio User: intelifix Remote: [local] Application: psql
19 150ms 6s551ms 895ms 1,411 21m3s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 30 07 36 40s990ms 1s138ms 08 89 1m28s 996ms 09 185 2m23s 775ms 10 162 2m16s 841ms 11 196 2m23s 730ms 12 74 1m6s 897ms 13 40 38s15ms 950ms 14 200 2m52s 864ms 15 199 3m6s 939ms 16 170 2m49s 999ms 17 60 1m16s 1s269ms [ User: intelifix - Total duration: 21m3s - Times executed: 1411 ]
[ Application: [unknown] - Total duration: 21m3s - Times executed: 1411 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (260010, 450, 'F200011341B1574,84011293633D$F200013244B33C1,1834AF9B7F7D$F200010281B6586,743AEFAC98A0$F200013244B02E8,1834AF9B6A1B$F200010287B7C23,743AEFADE161$F200010154182C2,743AEF34A140$F20001019611C2E,743AEF75A8EA$F200012271B1065,1834AF603716$F200011015B532D,9877E7095750$F20001019012326,743AEF74ACA4$F200012026B3CB9,840112BEEF62$F200012054B69A3,840112C12669$F200012010B5487,84011296F13D$F200011127B3253,9877E7B924EF$F200011257B3E92,84011238195F$F200011274B0D23,8401125E1CC2$F200011272B0D7E,84011239A269$F200012311B31FE,1834AF6162C6$F200010356B3899,9877E7069B81$F200012353BCE84,1834AF986E7A$F200011118BC078,9877E7B81833$F200012154B4623,840112EB9C9E$F200011082B99E7,9877E74B9FFF$F20001014717185,743AEF330398$F200011272B2B7F,84011239AF89$F200011294B4122,84011260E40D$F200010345B6DAD,9877E70253A0$F200012234B68A7,1834AF271F9E$F200011200B8949,840112057AD0$F200010284B51FE,743AEFAD76BD$F200011315B7C4B,840112811822$F200011329B1B33,84011283AE27$F200011134B4223,9877E7BA6C67$F200011168B3F15,9877E7BDAC10$F200012102B35F9,840112E119AD$F200012151B506A,840112EAD83C$F200013235B0D66,1834AF9A47E1$F200013244B3802,1834AF9B8159$F200011134B2833,9877E7BA610E', '',0153,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-30 15:30:39 Duration: 6s551ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (44223, 407, '226209592648', '',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-30 15:24:33 Duration: 5s308ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (259585, 452, 'ZTE3QJRP8K03350,E466AB519E02,E466AB519E03,ZTEGD3965214$ZTE3QJRP2E43905,8493B2E3F239,8493B2E3F23A,ZTEGD1574AE7$ZTE3QJRP6V26642,E466AB593E2A,E466AB593E2B,ZTEGD3979770$ZTE3QJRP6V27550,E466AB595372,E466AB595373,ZTEGD3979AFC$ZTE3QJRQ2L23616,3CF9F06A4013,3CF9F06A4014,ZTEGD4E75AED$ZTE3QJRQ2L23071,3CF9F06A334D,3CF9F06A334E,ZTEGD4E758CC$ZTE3QJRQ2212344,3CF9F06DE333,3CF9F06DE334,ZTEGD4E7F61D$ZTE3QJRP6V28193,E466AB596284,E466AB596285,ZTEGD3979D7F$ZTE3QJRQ2212380,3CF9F06DE40B,3CF9F06DE40C,ZTEGD4E7F641$ZTE3QJRP6V03463,E466AB571EE8,E466AB571EE9,ZTEGD3973CE5$ZTE3QJRP8K02882,E466AB51930A,E466AB51930B,ZTEGD3965040$ZTE3QJRP6V14596,E466AB5823D6,E466AB5823D7,ZTEGD3976862$ZTE3QJRPA451106,9C635B87F4DE,9C635B87F4DF,ZTEGD3A74E5B$ZTE3QJRPA400241,9C635B834CB8,9C635B834CB9,ZTEGD3A687AA$ZTE3QJRP2E03230,8493B2E038E7,8493B2E038E8,ZTEGD156AC04$ZTE3QJRPA406743,9C635B83E51C,9C635B83E51D,ZTEGD3A6A110$ZTE3QJRPA442010,9C635B871FAE,9C635B871FAF,ZTEGD3A72AD3$ZTE3QJRQ2206720,3CF9F06D5F63,3CF9F06D5F64,ZTEGD4E7E025$ZTE3QJRP8K04447,E466AB51B7B8,E466AB51B7B9,ZTEGD396565D$ZTE3QJRQ2L13012,3CF9F069478B,3CF9F069478C,ZTEGD4E73181$ZTE3QJRP6V23870,E466AB58FD32,E466AB58FD33,ZTEGD3978C9C$ZTE3QJRQ2L03548,3CF9F06869BB,3CF9F06869BC,ZTEGD4E70C89$ZTE3QJRQ2L40262,3CF9F06BC637,3CF9F06BC638,ZTEGD4E79BF3$ZTE3QJRPA446492,9C635B8788BA,9C635B8788BB,ZTEGD3A73C55$ZTE3QJRQ2L19721,3CF9F069E4C9,3CF9F069E4CA,ZTEGD4E74BB6$ZTE3QJRQ2L03700,3CF9F0686D4B,3CF9F0686D4C,ZTEGD4E70D21$ZTE3QJRQ2L19245,3CF9F069D9A1,3CF9F069D9A2,ZTEGD4E749DA$ZTE3QJRPA444304,9C635B875572,9C635B875573,ZTEGD3A733C9$ZTE3QJRP6V28087,E466AB596008,E466AB596009,ZTEGD3979D15$ZTE3QJRQ2208384,3CF9F06D8663,3CF9F06D8664,ZTEGD4E7E6A5$ZTE3QJRQ2208535,3CF9F06D89ED,3CF9F06D89EE,ZTEGD4E7E73C$ZTE3QJRP6V29989,E466AB598C9C,E466AB598C9D,ZTEGD397A483$ZTE3QJRQ2L35428,3CF9F06B54EB,3CF9F06B54EC,ZTEGD4E78911$ZTE3QJRP6V30659,E466AB599C50,E466AB599C51,ZTEGD397A721$ZTE3QJRP6V14920,E466AB582B6E,E466AB582B6F,ZTEGD39769A6$ZTE3QJRPA409158,9C635B841DB6,9C635B841DB7,ZTEGD3A6AA7F$ZTE3QJRPA447092,9C635B8796CA,9C635B8796CB,ZTEGD3A73EAD$ZTE3QJRP8K20200,E466AB5328EE,E466AB5328EF,ZTEGD39693E6$ZTE3QJRPA417193,9C635B84DA08,9C635B84DA09,ZTEGD3A6C9E2', '',0303,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-30 16:47:01 Duration: 4s962ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 169ms 2s599ms 669ms 98 1m5s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 30 07 2 3s386ms 1s693ms 08 26 15s853ms 609ms 09 8 2s546ms 318ms 10 1 330ms 330ms 11 1 1s594ms 1s594ms 13 19 10s352ms 544ms 14 9 5s578ms 619ms 15 13 11s404ms 877ms 16 12 9s533ms 794ms 17 6 4s292ms 715ms 18 1 753ms 753ms [ User: intelifix - Total duration: 1m5s - Times executed: 98 ]
[ Application: [unknown] - Total duration: 1m5s - Times executed: 98 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0124220) LIMIT 1;
Date: 2026-06-30 15:52:58 Duration: 2s599ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0124912) LIMIT 1;
Date: 2026-06-30 15:51:11 Duration: 2s496ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0259792) LIMIT 1;
Date: 2026-06-30 16:28:39 Duration: 2s464ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 2 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jun 30 12 1 0ms 0ms 22 1 0ms 0ms [ User: intelifix - Total duration: 1s151ms - Times executed: 2 ]
[ Application: [unknown] - Total duration: 981ms - Times executed: 1 ]
[ Application: psql - Total duration: 169ms - Times executed: 1 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 19,274 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 13 FATAL entries
- 4622 ERROR entries
- 0 WARNING entries
- 1 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 4,465 Max number of times the same event was reported
- 4,636 Total events found
Rank Times reported Error 1 4,465 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jun 30 00 60 01 60 02 59 03 60 04 59 05 60 06 66 07 328 08 382 09 476 10 535 11 384 12 228 13 182 14 359 15 369 16 274 17 167 18 70 19 59 20 59 21 60 22 60 23 49 - ERROR: prepared statement "_PLAN0000000029C3F240" does not exist
- ERROR: prepared statement "_PLAN0000000029C42470" does not exist
- ERROR: prepared statement "_PLAN0000000029F1B2D0" does not exist
Statement: DEALLOCATE "_PLAN0000000029C3F240"
Date: 2026-06-30 00:00:04 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029C42470"
Date: 2026-06-30 00:01:05 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029F1B2D0"
Date: 2026-06-30 00:02:05 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 46 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #2
Day Hour Count Jun 30 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-30 00:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-06-30 00:35:02 Database: brasilia Application: psql User: intelifix Remote: [local]
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-06-30 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
3 45 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #3
Day Hour Count Jun 30 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-30 08:00:05 Database: brasilia Application: psql User: intelifix Remote: [local]
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-30 08:20:13 Database: brasilia Application: psql User: intelifix Remote: [local]
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-30 08:40:06 Database: brasilia Application: psql User: intelifix Remote: [local]
4 26 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Jun 30 07 3 08 7 09 3 11 13 - ERROR: column "a0c562282b48" does not exist at character 27
- ERROR: column "a0c562282b48" does not exist at character 27
- ERROR: column "a0c562282b48" does not exist at character 27
Statement: SELECT * FROM RS_ETIQUETA(A0C562282B48)
Date: 2026-06-30 07:25:13 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(A0C562282B48)
Date: 2026-06-30 07:25:13 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(A0C562282B48)
Date: 2026-06-30 07:25:13 Database: rio Application: [unknown] User: etiquetas Remote: [local]
5 24 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #5
Day Hour Count Jun 30 07 6 08 7 11 5 14 3 15 3 - ERROR: trailing junk after numeric literal at or near "7C26349E63D2" at character 27
- ERROR: trailing junk after numeric literal at or near "7C26349E63D2" at character 27
- ERROR: trailing junk after numeric literal at or near "7C26349E63D2" at character 27
Statement: SELECT * FROM RS_ETIQUETA(7C26349E63D2)
Date: 2026-06-30 07:04:23 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(7C26349E63D2)
Date: 2026-06-30 07:04:23 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(7C26349E63D2)
Date: 2026-06-30 07:04:23 Database: rio Application: [unknown] User: etiquetas Remote: [local]
6 7 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #6
Day Hour Count Jun 30 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-30 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-06-30 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Context: PL/pgSQL expression "RS_BASE_TESTES()" PL/pgSQL function rs_giga_processa_arquivos() line 32 during statement block local variable initialization
Statement: CALL RS_GIGA_PROCESSA_ARQUIVOS()Date: 2026-06-30 03:05:01 Database: rio Application: psql User: intelifix Remote: [local]
7 4 ERROR: function rs_caixa_qr(...) does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Jun 30 15 4 - ERROR: function rs_caixa_qr(numeric) does not exist at character 15
- ERROR: function rs_caixa_qr(numeric) does not exist at character 15
- ERROR: function rs_caixa_qr(numeric) does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: select * from rs_caixa_qr(0.)Date: 2026-06-30 15:01:32 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: select * from rs_caixa_qr(0.)Date: 2026-06-30 15:01:32 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: select * from rs_caixa_qr(375512.)Date: 2026-06-30 15:30:24 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
8 4 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #8
Day Hour Count Jun 30 07 2 13 2 - ERROR: syntax error at or near ")" at character 28
- ERROR: syntax error at or near ")" at character 28
- ERROR: syntax error at or near "[" at character 35
Statement: select * from rs_caixa_qr(-)
Date: 2026-06-30 07:13:21 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(-)
Date: 2026-06-30 07:13:21 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(3188999 [)
Date: 2026-06-30 13:38:15 Database: rio Application: [unknown] User: etiquetas Remote: [local]
9 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #9
Day Hour Count Jun 30 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-30 05:32:07 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-06-30 05:32:07 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-06-30 05:32:07 Database: contagem Application: psql User: intelifix Remote: [local]
10 4 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #10
Day Hour Count Jun 30 00 1 06 1 17 1 23 1 - FATAL: database "testes" does not exist
- FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-06-30 00:02:28 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-06-30 06:02:29 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-06-30 17:17:47 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
11 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #11
Day Hour Count Jun 30 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-06-30 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-30 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
12 2 ERROR: function rs_etiqueta(...) does not exist
Times Reported Most Frequent Error / Event #12
Day Hour Count Jun 30 15 2 - ERROR: function rs_etiqueta(numeric) does not exist at character 15
- ERROR: function rs_etiqueta(numeric) does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_ETIQUETA(73900285850063606006)Date: 2026-06-30 15:12:48 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_ETIQUETA(73900285850063606006)Date: 2026-06-30 15:12:49 Database: rio Application: [unknown] User: etiquetas Remote: [local]
13 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #13
Day Hour Count Jun 30 03 1 - LOG: database system was shut down at 2026-06-30 03:05:01 -03
Date: 2026-06-30 03:05:02
14 1 ERROR: unterminated quoted identifier at or near ""..."
Times Reported Most Frequent Error / Event #14
Day Hour Count Jun 30 16 1 - ERROR: unterminated quoted identifier at or near ""}')" at character 76
Statement: SELECT * FROM RS_NOME_DEFEITO('{"oficina":"6","modelo":"287","codigo":"509'"}')
Date: 2026-06-30 16:30:29 Database: rio Application: [unknown] User: intelifix Remote: [local]
15 1 ERROR: trailing junk after parameter at or near "..."
Times Reported Most Frequent Error / Event #15
Day Hour Count Jun 30 17 1 - ERROR: trailing junk after parameter at or near "N_CAIXA" at character 27
Statement: select * from rs_caixa_qr($1N_CAIXA)
Date: 2026-06-30 17:23:18 Database: rio Application: [unknown] User: etiquetas Remote: [local]