pgBadger-
Global information
- Generated on Thu Aug 20 23:50:14 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 42,524 log entries in 12s
- Log start from 2026-08-19 00:02:02 to 2026-08-19 23:59:29
-
Overview
Global Stats
- 355 Number of unique normalized queries
- 6,421 Number of queries
- 8h40m28s Total query duration
- 2026-08-19 00:02:14 First query
- 2026-08-19 23:52:25 Last query
- 5 queries/s at 2026-08-19 07:45:12 Query peak
- 8h40m28s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 8h40m28s Execute total duration
- 3,810 Number of events
- 13 Number of unique normalized events
- 3,640 Max number of times the same event was reported
- 0 Number of cancellation
- 426 Total number of automatic vacuums
- 993 Total number of automatic analyzes
- 18 Number temporary file
- 241.45 MiB Max size of temporary file
- 104.62 MiB Average size of temporary file
- 359 Total number of sessions
- 7 sessions at 2026-08-19 22:08:23 Session peak
- 12d23h44m58s Total duration of sessions
- 52m6s Average duration of sessions
- 17 Average queries per session
- 1m26s Average queries duration per session
- 50m39s Average idle time per session
- 370 Total number of connections
- 4 connections/s at 2026-08-19 00:05:01 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-08-19 07:45:12 Date
SELECT Traffic
Key values
- 5 queries/s Query Peak
- 2026-08-19 16:21:56 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-08-19 23:52:16 Date
Queries duration
Key values
- 8h40m28s 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) Aug 19 00 24 0ms 19s321ms 5s509ms 18s589ms 1m28s 1m28s 01 38 0ms 4s48ms 986ms 5s237ms 6s280ms 7s167ms 02 18 0ms 4s43ms 1s890ms 7s468ms 7s468ms 7s468ms 03 20 0ms 10s221ms 2s211ms 12s472ms 12s472ms 12s472ms 04 29 0ms 4s128ms 1s339ms 6s651ms 6s668ms 6s668ms 05 35 0ms 9m4s 34s801ms 1m24s 5m40s 9m4s 06 37 0ms 12s756ms 2s813ms 16s175ms 34s172ms 34s172ms 07 156 0ms 8m12s 12s772ms 1m 5m31s 8m20s 08 547 150ms 6m23s 3s905ms 1m13s 5m8s 6m24s 09 892 150ms 9m44s 3s350ms 1m1s 6m26s 11m34s 10 630 150ms 9m40s 3s962ms 1m59s 5m5s 9m49s 11 523 0ms 9m22s 3s906ms 45s442ms 5m36s 9m32s 12 155 0ms 7m13s 5s939ms 9s283ms 1m40s 7m15s 13 436 151ms 6m13s 3s268ms 43s598ms 1m8s 6m19s 14 599 150ms 8m9s 3s187ms 38s907ms 4m47s 8m14s 15 734 150ms 8m38s 4s210ms 1m41s 6m36s 9m43s 16 601 150ms 8m44s 3s462ms 53s962ms 5m16s 8m49s 17 427 0ms 8m34s 4s868ms 1m10s 4m46s 8m48s 18 26 0ms 7m11s 30s255ms 7s960ms 28s612ms 7m54s 19 24 0ms 5m44s 26s245ms 7s204ms 48s356ms 5m44s 20 128 0ms 6m34s 9s993ms 1m8s 1m31s 6m56s 21 34 0ms 6m1s 20s141ms 7s408ms 7s862ms 6m53s 22 30 0ms 5m47s 21s726ms 6s887ms 48s942ms 5m47s 23 278 0ms 1m38s 8s726ms 1m7s 1m10s 1m53s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 19 00 3 0 6s196ms 0ms 0ms 18s589ms 01 20 0 261ms 208ms 324ms 1s520ms 02 2 0 417ms 0ms 834ms 834ms 03 2 0 482ms 0ms 965ms 965ms 04 10 0 276ms 229ms 832ms 898ms 05 14 0 335ms 176ms 598ms 1s99ms 06 10 0 1s901ms 959ms 1s680ms 16s175ms 07 95 0 17s278ms 3s953ms 35s11ms 6m21s 08 382 0 4s523ms 24s272ms 48s653ms 5m6s 09 676 0 3s650ms 17s13ms 44s2ms 8m28s 10 480 0 4s223ms 18s932ms 1m15s 7m29s 11 407 0 4s565ms 11s45ms 30s762ms 7m44s 12 113 0 7s524ms 2s1ms 4s109ms 4m 13 304 0 3s263ms 12s870ms 23s818ms 3m38s 14 440 0 3s841ms 12s183ms 17s685ms 7m12s 15 541 0 4s712ms 23s660ms 1m21s 8m45s 16 469 0 3s956ms 11s748ms 44s131ms 7m12s 17 292 0 6s121ms 16s520ms 57s169ms 5m39s 18 9 0 1m21s 0ms 0ms 3m52s 19 6 0 1m36s 0ms 0ms 3m7s 20 21 89 11s106ms 22s36ms 1m7s 3m27s 21 12 0 52s169ms 0ms 0ms 3m31s 22 6 0 1m38s 0ms 0ms 3m16s 23 12 266 8s726ms 1m2s 1m7s 1m38s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 19 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 Aug 19 00 0 0 0.00 0.00% 01 0 1 1.00 0.00% 02 0 1 1.00 0.00% 03 0 1 1.00 0.00% 04 0 2 2.00 0.00% 05 0 3 3.00 0.00% 06 0 3 3.00 0.00% 07 0 10 10.00 0.00% 08 0 15 15.00 0.00% 09 0 17 17.00 0.00% 10 0 16 16.00 0.00% 11 0 15 15.00 0.00% 12 0 5 5.00 0.00% 13 0 13 13.00 0.00% 14 0 11 11.00 0.00% 15 0 13 13.00 0.00% 16 0 14 14.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 3 3.00 0.00% 21 0 1 1.00 0.00% 22 0 0 0.00 0.00% 23 0 5 5.00 0.00% Day Hour Count Average / Second Aug 19 00 13 0.00/s 01 7 0.00/s 02 7 0.00/s 03 14 0.00/s 04 7 0.00/s 05 8 0.00/s 06 12 0.00/s 07 19 0.01/s 08 25 0.01/s 09 25 0.01/s 10 25 0.01/s 11 23 0.01/s 12 12 0.00/s 13 22 0.01/s 14 21 0.01/s 15 26 0.01/s 16 21 0.01/s 17 17 0.00/s 18 12 0.00/s 19 9 0.00/s 20 15 0.00/s 21 9 0.00/s 22 9 0.00/s 23 12 0.00/s Day Hour Count Average Duration Average idle time Aug 19 00 3 44m20s 43m36s 01 11 1h1m22s 1h1m18s 02 7 1h25s 1h21s 03 13 26m5s 26m2s 04 8 1h1m7s 1h1m2s 05 7 1h51s 57m57s 06 7 56m25s 56m10s 07 16 48m52s 46m48s 08 15 55m3s 52m40s 09 30 46m18s 44m39s 10 23 48m40s 46m52s 11 25 51m59s 50m38s 12 19 57m14s 56m26s 13 13 51m37s 49m47s 14 23 56m13s 54m50s 15 24 46m9s 44m 16 23 56m1s 54m30s 17 20 55m10s 53m26s 18 16 56m52s 56m3s 19 10 1h1m3s 1h 20 13 43m6s 41m28s 21 10 1h1s 58m53s 22 10 1h18s 59m13s 23 13 43m58s 40m51s -
Connections
Established Connections
Key values
- 4 connections Connection Peak
- 2026-08-19 00:05:01 Date
Connections per database
Key values
- rio Main Database
- 370 connections Total
Connections per user
Key values
- intelifix Main User
- 370 connections Total
-
Sessions
Simultaneous sessions
Key values
- 7 sessions Session Peak
- 2026-08-19 22:08:23 Date
Histogram of session times
Key values
- 282 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 359 sessions Total
Sessions per user
Key values
- intelifix Main User
- 359 sessions Total
Sessions per host
Key values
- [local] Main Host
- 359 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 28,637 buffers Checkpoint Peak
- 2026-08-19 00:09:40 Date
- 270.041 seconds Highest write time
- 0.146 seconds Sync time
Checkpoints Wal files
Key values
- 9 files Wal files usage Peak
- 2026-08-19 17:54:35 Date
Checkpoints distance
Key values
- 296.34 Mo Distance Peak
- 2026-08-19 15:44:35 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Aug 19 00 44,361 618.897s 0.026s 618.967s 01 3,302 332.04s 0.038s 332.131s 02 1,592 159.921s 0.02s 159.969s 03 1,668 167.477s 0.037s 167.567s 04 2,763 278.157s 0.047s 278.242s 05 10,324 1,037.377s 0.083s 1,037.516s 06 6,809 426.606s 0.009s 426.639s 07 33,564 2,018.717s 0.14s 2,018.961s 08 58,747 3,239.031s 0.559s 3,239.77s 09 70,968 3,238.611s 0.909s 3,239.74s 10 77,462 3,238.834s 0.629s 3,239.668s 11 54,957 3,238.757s 0.736s 3,239.689s 12 14,838 1,460.118s 0.13s 1,460.339s 13 38,425 2,434.624s 0.441s 2,435.207s 14 58,050 3,207.805s 0.677s 3,208.678s 15 76,350 3,231.387s 0.929s 3,232.559s 16 71,679 3,238.625s 0.833s 3,239.719s 17 62,196 2,832.199s 0.633s 2,833.121s 18 1,925 192.935s 0.014s 192.984s 19 28 2.833s 0.002s 2.841s 20 1,225 127.332s 0.016s 127.362s 21 2,658 266.514s 0.042s 266.633s 22 2,324 233.208s 0.027s 233.275s 23 455 45.748s 0.014s 45.802s Day Hour Added Removed Recycled Synced files Longest sync Average sync Aug 19 00 0 0 8 391 0.003s 0.005s 01 0 0 1 700 0.002s 0.009s 02 0 0 1 367 0.003s 0.005s 03 0 0 1 335 0.002s 0.006s 04 0 0 0 652 0.003s 0.007s 05 0 0 5 941 0.014s 0.009s 06 0 0 1 62 0.002s 0.002s 07 0 0 20 2,314 0.006s 0.011s 08 0 0 40 5,658 0.031s 0.012s 09 0 0 35 7,603 0.031s 0.012s 10 0 0 35 7,095 0.010s 0.012s 11 0 0 23 7,172 0.010s 0.012s 12 0 0 5 3,179 0.002s 0.012s 13 0 0 24 5,368 0.008s 0.012s 14 0 0 26 7,082 0.008s 0.012s 15 0 0 47 7,523 0.039s 0.012s 16 0 0 35 6,714 0.021s 0.012s 17 0 0 32 5,689 0.010s 0.012s 18 0 0 0 100 0.002s 0.007s 19 0 0 0 5 0.002s 0.001s 20 0 0 1 86 0.002s 0.003s 21 0 0 1 418 0.016s 0.007s 22 0 0 0 415 0.003s 0.007s 23 0 0 0 47 0.004s 0.006s Day Hour Count Avg time (sec) Aug 19 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 Aug 19 00 27,451.60 kB 66,582.80 kB 01 1,811.67 kB 37,338.00 kB 02 1,707.40 kB 18,337.80 kB 03 1,338.00 kB 3,725.86 kB 04 1,930.29 kB 2,574.71 kB 05 8,352.33 kB 17,286.56 kB 06 9,151.00 kB 14,813.00 kB 07 29,480.82 kB 43,462.82 kB 08 55,168.00 kB 91,044.25 kB 09 47,001.83 kB 101,749.25 kB 10 48,580.25 kB 77,648.83 kB 11 31,007.92 kB 82,392.58 kB 12 6,279.83 kB 33,491.58 kB 13 33,994.50 kB 51,429.08 kB 14 34,325.17 kB 78,939.00 kB 15 65,153.83 kB 96,553.67 kB 16 46,801.50 kB 95,987.25 kB 17 43,819.83 kB 74,997.75 kB 18 1,130.50 kB 87,607.00 kB 19 200.00 kB 59,722.00 kB 20 3,744.33 kB 49,396.00 kB 21 1,908.57 kB 30,453.29 kB 22 1,825.14 kB 15,529.86 kB 23 137.17 kB 8,230.67 kB -
Temporary Files
Size of temporary files
Key values
- 482.89 MiB Temp Files size Peak
- 2026-08-19 05:31:57 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-08-19 05:30:37 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Aug 19 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 10 1.10 GiB 112.21 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 2 208.00 MiB 104.00 MiB 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 3 312.00 MiB 104.00 MiB 16 0 0 0 17 3 241.04 MiB 80.35 MiB 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 8 937.86 MiB 72.02 MiB 241.45 MiB 117.23 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-19 05:32:05 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-19 05:31:57 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 6 624.01 MiB 104.00 MiB 104.00 MiB 104.00 MiB select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028682, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-19 09:18:11 Duration: 8m26s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028702, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');
Date: 2026-08-19 15:29:45 Duration: 7m44s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028689, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-19 11:35:45 Duration: 7m37s Database: rio User: intelifix Remote: [local] Application: [unknown]
3 2 184.19 MiB 92.09 MiB 92.09 MiB 92.09 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-19 05:30:40 Duration: 38s695ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-19 05:30:37 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
4 2 137.04 MiB 66.20 MiB 70.84 MiB 68.52 MiB select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-19', 099, '', '', 0, 6, '2025-08-25');
Date: 2026-08-19 17:42:50 Duration: 5m31s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-19', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-19 16:27:33 Duration: 39s69ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-19', 0302, '', '', 0, 6, '2026-08-01');
Date: 2026-08-19 08:42:18 Duration: 30s891ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries generating the largest temporary files
Rank Size Query 1 241.45 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-19 05:31:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 241.45 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-19 05:31:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-08-19 15:56:55 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-08-19 17:43:43 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-08-19 10:32:50 - 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-08-19 10:41:26 - 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-08-19 15:36:22 - 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-08-19 15:29:03 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
9 92.09 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-19 05:30:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 92.09 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-19 05:30:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 79.67 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-19 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 79.59 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-19 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 79.59 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-19 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 72.09 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-19 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 72.02 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-19 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 72.02 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-19 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 70.84 MiB SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-19', 099, '', '', 0, 6, '2025-08-25');[ Date: 2026-08-19 17:42:04 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
18 66.20 MiB SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-19', 099, '', '', 0, 6, '2025-08-25');[ Date: 2026-08-19 17:40:00 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 20.18 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_08
Database rio - 2026-08-19 16:23:06 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 20.18 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_08
Database rio - 2026-08-19 16:23:06 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (106) Main table analyzed (database rio)
- 993 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 106 rio.public.temp0000288972 54 rio.pg_catalog.pg_class 50 brasilia.pg_catalog.pg_attribute 48 rio.public.usuarios 45 contagem.pg_catalog.pg_attribute 44 rio.pg_catalog.pg_type 43 contagem.public.usuarios 31 rio.pg_catalog.pg_index 27 rio.public.temp0000288888 24 brasilia.pg_catalog.pg_class 23 contagem.public.temp0000226856 21 rio.pg_catalog.pg_depend 20 brasilia.pg_catalog.pg_type 19 contagem.pg_catalog.pg_class 19 contagem.pg_catalog.pg_type 16 rio.public.temp0000288920 15 contagem.public.temp0000226876 15 brasilia.public.temp0000238472 14 rio.public.temp0000288870 14 rio.public.temp0000288964 13 rio.public.temp0000288886 13 rio.public.temp0000288868 11 contagem.pg_catalog.pg_index 11 rio.public.temp0000289008 11 brasilia.pg_catalog.pg_index 11 rio.public.temp0000288894 10 rio.public.temp0000288986 10 rio.public.temp0000288976 10 rio.public.temp0000288882 10 contagem.public.temp0000226870 9 contagem.pg_catalog.pg_depend 9 brasilia.public.usuarios 9 rio.public.tmp_drill_0302 8 rio.public.temp0000288994 8 brasilia.public.temp0000238500 8 rio.public.temp0000289000 8 brasilia.pg_catalog.pg_depend 8 rio.public.temp0000288866 7 brasilia.public.temp0000238464 7 rio.public.temp0000289010 6 rio.public.temp0000288916 6 rio.public.temp0000288896 6 rio.public.temp0000288968 6 rio.public.temp0000288974 6 rio.public.temp0000288878 5 rio.public.temp0000288872 5 rio.public.temp0000288984 5 template1.pg_catalog.pg_shdepend 5 contagem.public.temp0000226881 5 rio.public.temp0000288954 4 contagem.public.nf_entrada 4 rio.public.temp0000288942 4 rio.public.temp0000288922 3 brasilia.pg_catalog.pg_shdepend 3 rio.public.temp0000288960 3 rio.public.temp0000288962 3 brasilia.public.temp0000238476 3 rio.pg_catalog.pg_shdepend 3 rio.public.temp0000288884 3 rio.public.temp0000289012 3 rio.public.temp0000288876 3 rio.public.temp0000288908 3 brasilia.public.temp0000238514 3 brasilia.public.temp0000238494 2 rio.public.temp0000289016 2 rio.public.temp0000288982 2 rio.public.temp0000289014 2 brasilia.public.temp0000238486 2 brasilia.public.temp0000238518 2 rio.public.temp0000288880 2 brasilia.public.temp0000238484 2 brasilia.public.parametros 2 rio.public.temp0000288992 2 brasilia.public.temp0000238510 2 rio.public.temp0000288910 2 brasilia.public.temp0000238490 2 contagem.public.temp0000226879 2 rio.public.temp0000288852 2 brasilia.public.temp0000238530 2 brasilia.public.temp0000238524 2 rio.public.temp0000288970 2 rio.public.temp0000288874 2 rio.public.temp0000289020 1 rio.public.temp0000288952 1 rio.public.temp0000289004 1 postgres.pg_catalog.pg_shdepend 1 rio.public.temp0000288918 1 rio.public.temp0000288946 1 rio.public.temp0000288980 1 contagem.public.temp0000226858 1 brasilia.public.temp0000238468 1 brasilia.public.temp0000238470 1 brasilia.public.temp0000238462 1 rio.public.temp0000289002 1 brasilia.public.temp0000238478 1 rio.public.temp0000289006 1 brasilia.public.temp0000238498 1 rio.public.temp0000288958 1 Total 993 Vacuums per table
Key values
- pg_catalog.pg_attribute (40) Main table vacuumed on database rio
- 426 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.pg_catalog.pg_attribute 40 34 0 0 0 0 0 18,874 5,330 7,729,938 332 8,033 contagem.public.usuarios 30 0 0 0 0 0 0 135 95 55,746 0 0 rio.public.temp0000288972 27 0 0 0 0 0 0 11,227 255 902,630 0 0 rio.pg_catalog.pg_class 24 19 0 0 0 0 0 3,815 1,227 1,936,204 74 330 rio.pg_catalog.pg_type 21 16 0 0 0 0 0 1,657 501 660,150 62 199 rio.public.usuarios 19 8 0 0 0 0 0 224 79 173,001 10 22 contagem.pg_catalog.pg_attribute 18 18 0 0 0 0 0 17,004 2,318 5,520,561 27 860 rio.public.temp0000288888 13 0 0 0 0 0 0 20,867 1,786 3,476,227 0 0 brasilia.pg_catalog.pg_attribute 13 13 0 0 0 0 0 5,981 1,813 2,821,765 59 1,495 rio.public.temp0000288964 12 0 0 0 0 0 0 875 98 106,809 0 0 rio.public.tmp_drill_0302 10 6 0 0 0 0 0 2,044 58 398,575 1 26 rio.pg_catalog.pg_index 10 10 0 0 0 0 0 683 178 199,114 41 72 contagem.pg_catalog.pg_type 9 9 0 0 0 0 0 1,643 155 371,210 8 19 rio.public.temp0000288894 9 0 0 0 0 0 0 564 52 41,024 0 0 rio.public.temp0000288976 9 0 0 0 0 0 0 819 172 278,624 0 0 contagem.pg_catalog.pg_class 9 9 0 0 0 0 0 3,577 199 630,196 7 20 rio.pg_catalog.pg_depend 9 9 0 0 0 0 0 2,797 898 1,365,866 53 460 contagem.pg_catalog.pg_index 8 8 0 0 0 0 0 778 87 170,950 6 7 rio.public.temp0000288994 8 0 0 0 0 0 0 13,920 32 826,104 0 0 rio.public.temp0000289000 8 0 0 0 0 0 0 12,185 1,767 2,962,765 0 0 rio.pg_catalog.pg_statistic 7 7 0 0 0 0 0 9,563 2,073 9,861,605 952 4,233 postgres.pg_catalog.pg_shdepend 7 7 0 0 0 0 0 1,108 323 526,494 46 105 contagem.pg_catalog.pg_depend 7 7 0 0 0 0 0 3,505 320 1,038,929 6 39 brasilia.pg_catalog.pg_class 6 6 0 0 0 0 0 1,084 444 662,417 26 83 rio.public.temp0000288968 6 0 0 0 0 0 0 533 148 240,643 0 0 contagem.public.temp0000226881 5 0 0 0 0 0 0 452 29 31,401 0 0 contagem.public.temp0000226876 5 0 0 0 0 0 0 702 28 45,873 0 0 brasilia.pg_catalog.pg_type 5 5 0 0 0 0 0 435 176 218,975 10 24 rio.public.temp0000288974 4 0 0 0 0 0 0 505 24 33,597 0 0 rio.public.temp0000288896 4 0 0 0 0 0 0 137 22 11,318 0 0 rio.public.temp0000288942 4 0 0 0 0 0 0 1,751 13 105,526 0 0 brasilia.pg_catalog.pg_statistic 3 3 0 0 0 0 0 3,902 1,479 4,959,417 1,254 7,790 brasilia.pg_catalog.pg_index 3 3 0 0 0 0 0 132 47 38,014 5 15 rio.public.temp0000288876 3 0 0 0 0 0 0 163 17 12,171 0 0 rio.public.temp0000289012 3 0 0 0 0 0 0 137 10 9,762 0 0 rio.public.temp0000288962 3 0 0 0 0 0 0 20 13 3,288 0 0 rio.public.temp0000288866 3 0 0 0 0 0 0 171 17 12,630 0 0 rio.pg_toast.pg_toast_2619 3 3 0 0 0 0 0 1,785 336 1,934,081 131 491 rio.public.temp0000288922 3 0 0 0 0 0 0 5,217 12 309,612 0 0 rio.public.temp0000288878 3 0 0 0 0 0 0 106 16 8,786 0 0 rio.public.temp0000288992 2 0 0 0 0 0 0 3,480 8 206,526 0 0 brasilia.pg_catalog.pg_depend 2 2 0 0 0 0 0 612 235 301,634 13 120 brasilia.public.temp0000238484 2 0 0 0 0 0 0 492 251 408,128 0 0 rio.public.temp0000288852 2 0 0 0 0 0 0 113 11 8,411 0 0 contagem.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 354 53 260,454 32 70 brasilia.public.temp0000238486 2 0 0 0 0 0 0 492 8 30,234 0 0 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 400 118 509,053 41 107 contagem.pg_catalog.pg_statistic 2 2 0 0 0 0 0 2,868 163 764,973 122 1,033 brasilia.public.temp0000238530 2 0 0 0 0 0 0 251 250 395,380 0 0 brasilia.public.temp0000238494 2 0 0 0 0 0 0 492 8 30,234 0 0 rio.public.temp0000288920 2 0 0 0 0 0 0 148 67 97,986 0 0 rio.public.temp0000288908 1 0 0 0 0 0 0 1,740 4 103,263 0 0 contagem.public.equip_defeitos 1 1 0 0 0 0 0 3,635 2,344 7,331,308 216 8,979 rio.auditor.auditor_2026_08 1 0 0 0 0 0 0 130,946 55,940 74,849,668 37,481 742,678 brasilia.public.temp0000238510 1 0 0 0 0 0 0 246 4 15,117 0 0 contagem.public.nf_entrada 1 1 0 0 0 0 0 180 84 134,801 4 8 template1.pg_catalog.pg_shdepend 1 1 0 0 0 0 0 103 4 13,631 16 26 rio.public.temp0000289020 1 0 0 0 0 0 0 64 6 4,644 0 0 brasilia.pg_catalog.pg_shdepend 1 1 0 0 0 0 0 167 12 56,863 2 2 rio.public.temp0000288952 1 0 0 0 0 0 0 114 6 7,637 0 0 rio.public.temp0000289016 1 0 0 0 0 0 0 130 4 8,273 0 0 rio.public.temp0000288986 1 0 0 0 0 0 0 1,740 4 103,263 0 0 Total 426 212 0 0 0 0 0 299,844 82,231 136,333,479 41,037 777,346 Vacuum throughput per table
Key values
- auditor.auditor_2026_08 (20.18) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.pg_catalog.pg_attribute 0 0 2.99 contagem.public.usuarios 0 0 0 rio.public.temp0000288972 0 0 0.6 rio.pg_catalog.pg_class 0 0 1.04 rio.pg_catalog.pg_type 0 0 0.32 rio.public.usuarios 0 0 0 contagem.pg_catalog.pg_attribute 0 0 1.83 rio.public.temp0000288888 0 0 0.69 brasilia.pg_catalog.pg_attribute 0 0 1.1 rio.public.temp0000288964 0 0 0.17 rio.public.tmp_drill_0302 0 0 0.1 rio.pg_catalog.pg_index 0 0 0.33 contagem.pg_catalog.pg_type 0 0 0.33 rio.public.temp0000288894 0 0 0.22 rio.public.temp0000288976 0 0 0.1 contagem.pg_catalog.pg_class 0 0 0.44 rio.pg_catalog.pg_depend 0 0 0.91 contagem.pg_catalog.pg_index 0 0 0.24 rio.public.temp0000288994 0 0 0.45 rio.public.temp0000289000 0 0 0.41 rio.pg_catalog.pg_statistic 0 0 1.64 postgres.pg_catalog.pg_shdepend 0 0 0.43 contagem.pg_catalog.pg_depend 0 0 0.48 brasilia.pg_catalog.pg_class 0 0 0.44 rio.public.temp0000288968 0 0 0.08 contagem.public.temp0000226881 0 0 0.08 contagem.public.temp0000226876 0 0 0.04 brasilia.pg_catalog.pg_type 0 0 0.11 rio.public.temp0000288974 0 0 0.07 rio.public.temp0000288896 0 0 0.05 rio.public.temp0000288942 0 0 0.21 brasilia.pg_catalog.pg_statistic 0 0 0.34 brasilia.pg_catalog.pg_index 0 0 0.06 rio.public.temp0000288876 0 0 0.05 rio.public.temp0000289012 0 0 0.01 rio.public.temp0000288962 0 0 0.02 rio.public.temp0000288866 0 0 0.04 rio.pg_toast.pg_toast_2619 0 0 0.25 rio.public.temp0000288922 0 0 0.16 rio.public.temp0000288878 0 0 0.05 rio.public.temp0000288992 0 0 0.12 brasilia.pg_catalog.pg_depend 0 0 0.25 brasilia.public.temp0000238484 0 0 0.01 rio.public.temp0000288852 0 0 0.03 contagem.pg_toast.pg_toast_2619 0 0 0.03 brasilia.public.temp0000238486 0 0 0 brasilia.pg_toast.pg_toast_2619 0 0 0.05 contagem.pg_catalog.pg_statistic 0 0 0.15 brasilia.public.temp0000238530 0 0 0.01 brasilia.public.temp0000238494 0 0 0 rio.public.temp0000288920 0 0 0.03 rio.public.temp0000288908 0 0 0.06 contagem.public.equip_defeitos 0 0 1.71 rio.auditor.auditor_2026_08 0 0 20.18 brasilia.public.temp0000238510 0 0 0 contagem.public.nf_entrada 0 0 0.09 template1.pg_catalog.pg_shdepend 0 0 0.02 rio.public.temp0000289020 0 0 0.02 brasilia.pg_catalog.pg_shdepend 0 0 0.02 rio.public.temp0000288952 0 0 0.02 rio.public.temp0000289016 0 0 0 rio.public.temp0000288986 0 0 0.05 Total 0 0 39.73 Tuples removed per table
Key values
- pg_catalog.pg_attribute (151592) Main table with removed tuples on database contagem
- 473330 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain contagem.pg_catalog.pg_attribute 18 18 151,592 430,356 223 1,428 11,271 rio.pg_catalog.pg_attribute 40 34 136,222 989,182 65,218 245 23,615 brasilia.pg_catalog.pg_attribute 13 13 43,245 288,086 0 88 6,978 rio.public.tmp_drill_0302 10 6 29,780 71,946 20,527 0 1,297 rio.pg_catalog.pg_statistic 7 7 13,001 58,313 17 0 9,002 contagem.pg_catalog.pg_depend 7 7 10,843 134,587 24 199 1,387 contagem.pg_catalog.pg_type 9 9 10,729 21,776 8 185 804 postgres.pg_catalog.pg_shdepend 7 7 8,276 95,193 100 0 868 contagem.pg_catalog.pg_class 9 9 8,259 35,039 16 322 1,985 rio.pg_catalog.pg_depend 9 9 6,744 169,072 2,488 0 1,608 rio.auditor.auditor_2026_08 1 0 6,341 12,220,146 0 0 587,140 brasilia.pg_catalog.pg_statistic 3 3 6,134 23,725 0 0 3,216 rio.pg_catalog.pg_type 21 16 6,053 52,249 4,418 12 1,521 contagem.pg_catalog.pg_index 8 8 5,864 15,186 4 86 507 contagem.pg_catalog.pg_statistic 2 2 5,618 14,989 0 0 2,022 contagem.public.equip_defeitos 1 1 4,609 457,515 0 0 4,155 rio.pg_catalog.pg_class 24 19 3,182 97,703 12,051 33 3,083 rio.pg_catalog.pg_index 10 10 2,909 19,273 37 0 580 brasilia.pg_catalog.pg_depend 2 2 2,865 36,083 0 0 352 brasilia.pg_catalog.pg_shdepend 1 1 2,805 13,563 8 0 124 contagem.public.usuarios 30 0 1,814 720 0 0 60 brasilia.pg_catalog.pg_class 6 6 1,579 20,226 0 0 762 rio.pg_toast.pg_toast_2619 3 3 1,003 2,055 3 92 603 brasilia.pg_catalog.pg_type 5 5 947 11,085 60 6 325 template1.pg_catalog.pg_shdepend 1 1 845 14,918 1,364 0 124 rio.public.usuarios 19 8 719 12,240 2,569 0 399 contagem.public.nf_entrada 1 1 569 1,017 0 0 79 brasilia.pg_catalog.pg_index 3 3 318 5,636 0 4 144 contagem.pg_toast.pg_toast_2619 2 2 241 232 0 0 132 brasilia.pg_toast.pg_toast_2619 2 2 224 268 0 0 132 contagem.public.temp0000226881 5 0 0 6,676 0 125 515 rio.public.temp0000288908 1 0 0 24,543 0 0 1,792 rio.public.temp0000288974 4 0 0 21,128 0 39 473 rio.public.temp0000288894 9 0 0 30,811 0 338 686 rio.public.temp0000288992 2 0 0 49,065 0 0 3,584 brasilia.public.temp0000238510 1 0 0 3,223 0 0 256 rio.public.temp0000288976 9 0 0 49,555 0 162 1,118 rio.public.temp0000288964 12 0 0 56,993 0 123 1,285 rio.public.temp0000288972 27 0 0 283,458 0 477 15,075 rio.public.temp0000288968 6 0 0 33,313 0 144 752 rio.public.temp0000288876 3 0 0 8,408 0 69 187 brasilia.public.temp0000238484 2 0 0 6,446 0 0 512 rio.public.temp0000289012 3 0 0 16,455 0 0 384 rio.public.temp0000288852 2 0 0 8,606 0 64 192 brasilia.public.temp0000238486 2 0 0 6,446 0 0 512 rio.public.temp0000288962 3 0 0 7,500 0 15 241 rio.public.temp0000288888 13 0 0 318,726 0 0 23,296 rio.public.temp0000288866 3 0 0 9,174 0 52 204 brasilia.public.temp0000238530 2 0 0 6,446 0 0 512 rio.public.temp0000288922 3 0 0 73,569 0 0 5,376 contagem.public.temp0000226876 5 0 0 7,221 0 100 668 rio.public.temp0000288994 8 0 0 196,305 0 0 14,336 rio.public.temp0000289020 1 0 0 1,007 0 8 56 brasilia.public.temp0000238494 2 0 0 6,446 0 0 512 rio.public.temp0000289000 8 0 0 196,327 0 0 14,336 rio.public.temp0000288920 2 0 0 5,910 0 60 132 rio.public.temp0000288952 1 0 0 4,731 0 22 106 rio.public.temp0000288896 4 0 0 10,092 0 95 225 rio.public.temp0000289016 1 0 0 5,602 0 0 128 rio.public.temp0000288878 3 0 0 11,832 0 120 264 rio.public.temp0000288986 1 0 0 24,543 0 0 1,792 rio.public.temp0000288942 4 0 0 98,090 0 0 7,168 Total 426 212 473,330 16,901,026 109,135 4,713 760,950 Pages removed per table
Key values
- pg_catalog.pg_attribute (1428) Main table with removed pages on database contagem
- 4713 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed contagem.pg_catalog.pg_attribute 18 18 151592 1428 rio.public.temp0000288972 27 0 0 477 rio.public.temp0000288894 9 0 0 338 contagem.pg_catalog.pg_class 9 9 8259 322 rio.pg_catalog.pg_attribute 40 34 136222 245 contagem.pg_catalog.pg_depend 7 7 10843 199 contagem.pg_catalog.pg_type 9 9 10729 185 rio.public.temp0000288976 9 0 0 162 rio.public.temp0000288968 6 0 0 144 contagem.public.temp0000226881 5 0 0 125 rio.public.temp0000288964 12 0 0 123 rio.public.temp0000288878 3 0 0 120 contagem.public.temp0000226876 5 0 0 100 rio.public.temp0000288896 4 0 0 95 rio.pg_toast.pg_toast_2619 3 3 1003 92 brasilia.pg_catalog.pg_attribute 13 13 43245 88 contagem.pg_catalog.pg_index 8 8 5864 86 rio.public.temp0000288876 3 0 0 69 rio.public.temp0000288852 2 0 0 64 rio.public.temp0000288920 2 0 0 60 rio.public.temp0000288866 3 0 0 52 rio.public.temp0000288974 4 0 0 39 rio.pg_catalog.pg_class 24 19 3182 33 rio.public.temp0000288952 1 0 0 22 rio.public.temp0000288962 3 0 0 15 rio.pg_catalog.pg_type 21 16 6053 12 rio.public.temp0000289020 1 0 0 8 brasilia.pg_catalog.pg_type 5 5 947 6 brasilia.pg_catalog.pg_index 3 3 318 4 rio.public.temp0000288908 1 0 0 0 rio.pg_catalog.pg_statistic 7 7 13001 0 contagem.public.equip_defeitos 1 1 4609 0 brasilia.pg_catalog.pg_class 6 6 1579 0 rio.public.temp0000288992 2 0 0 0 rio.auditor.auditor_2026_08 1 0 6341 0 brasilia.pg_catalog.pg_depend 2 2 2865 0 brasilia.public.temp0000238510 1 0 0 0 rio.public.usuarios 19 8 719 0 contagem.public.nf_entrada 1 1 569 0 brasilia.pg_catalog.pg_statistic 3 3 6134 0 postgres.pg_catalog.pg_shdepend 7 7 8276 0 brasilia.public.temp0000238484 2 0 0 0 rio.public.temp0000289012 3 0 0 0 template1.pg_catalog.pg_shdepend 1 1 845 0 rio.public.tmp_drill_0302 10 6 29780 0 contagem.pg_toast.pg_toast_2619 2 2 241 0 brasilia.public.temp0000238486 2 0 0 0 brasilia.pg_toast.pg_toast_2619 2 2 224 0 rio.public.temp0000288888 13 0 0 0 contagem.pg_catalog.pg_statistic 2 2 5618 0 brasilia.public.temp0000238530 2 0 0 0 rio.public.temp0000288922 3 0 0 0 rio.pg_catalog.pg_index 10 10 2909 0 rio.public.temp0000288994 8 0 0 0 brasilia.public.temp0000238494 2 0 0 0 contagem.public.usuarios 30 0 1814 0 rio.public.temp0000289000 8 0 0 0 rio.pg_catalog.pg_depend 9 9 6744 0 brasilia.pg_catalog.pg_shdepend 1 1 2805 0 rio.public.temp0000289016 1 0 0 0 rio.public.temp0000288986 1 0 0 0 rio.public.temp0000288942 4 0 0 0 Total 426 212 473,330 4,713 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Aug 19 00 0 0 01 0 3 02 0 0 03 0 0 04 0 6 05 6 4 06 0 3 07 8 23 08 50 111 09 32 125 10 55 99 11 37 98 12 3 23 13 27 73 14 36 83 15 62 133 16 50 113 17 60 95 18 0 0 19 0 0 20 0 0 21 0 1 22 0 0 23 0 0 - 20.18 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 3 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 3 6m15s 1m35s 2m53s 2m5s call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-19 09:18:14 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-19 10:47:00 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-19 07:26:46 Database: rio User: intelifix Remote: [local] Application: psql
Queries that waited the most
Rank Wait time Query 1 2m53s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-08-19 09:18:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 1m46s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-08-19 10:46:58 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 1m35s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-08-19 07:26:45 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Queries
Queries by type
Key values
- 4,326 Total read queries
- 1,586 Total write queries
Queries by database
Key values
- rio Main database
- 3,852 Requests
- 6h25m45s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 6,259 Requests
User Request type Count Duration etiquetas Total 37 8s858ms select 37 8s858ms intelifix Total 6,259 8h38m50s copy to 355 49m24s ddl 1,231 40m52s others 509 51m30s select 4,164 6h17m1s lenon Total 125 1m29s select 125 1m29s Duration by user
Key values
- 8h38m50s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 37 8s858ms select 37 8s858ms intelifix Total 6,259 8h38m50s copy to 355 49m24s ddl 1,231 40m52s others 509 51m30s select 4,164 6h17m1s lenon Total 125 1m29s select 125 1m29s Queries by host
Key values
- [local] Main host
- 6,421 Requests
- 8h40m28s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 5,364 Requests
- 4h32m45s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-08-19 20:03:16 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 3,147 100-500ms duration
Slowest individual queries
Rank Duration Query 1 9m44s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-19 09:14:45 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 9m40s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-19 10:14:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 9m22s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-19 11:14:24 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 9m4s analyze verbose;[ Date: 2026-08-19 05:09:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 8m44s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-19 16:13:46 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 8m38s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-19 15:13:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 8m34s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-19 17:13:35 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 8m26s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028682, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-19 09:18:11 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
9 8m12s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-19 07:13:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 8m9s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-19 14:13:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 7m44s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028702, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');[ Date: 2026-08-19 15:29:45 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
12 7m37s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028689, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-19 11:35:45 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 7m23s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028686, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-19 10:46:58 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 7m13s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-19 12:12:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 7m12s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028697, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-19 14:26:14 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
16 7m11s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-19 18:12:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 7m4s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028709, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');[ Date: 2026-08-19 16:05:41 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
18 6m34s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-19 20:11:36 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 6m31s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028708, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');[ Date: 2026-08-19 15:53:38 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 6m23s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-19 08:11:24 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 2h11m48s 48 1s531ms 9m44s 2m44s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 19 07 3 8m54s 2m58s 08 3 6m52s 2m17s 09 3 10m34s 3m31s 10 3 10m31s 3m30s 11 3 10m12s 3m24s 12 3 7m55s 2m38s 13 3 6m35s 2m11s 14 3 8m56s 2m58s 15 3 9m20s 3m6s 16 3 9m33s 3m11s 17 3 9m12s 3m4s 18 3 7m43s 2m34s 19 3 6m1s 2m 20 3 6m58s 2m19s 21 3 6m20s 2m6s 22 3 6m5s 2m1s [ User: intelifix - Total duration: 2h11m48s - Times executed: 48 ]
[ Application: psql - Total duration: 2h11m48s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-19 09:14:45 Duration: 9m44s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-19 10:14:42 Duration: 9m40s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-19 11:14:24 Duration: 9m22s Database: rio User: intelifix Remote: [local] Application: psql
2 1h38m56s 275 152ms 8m26s 21s588ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 19 07 6 11m58s 1m59s 08 32 12m2s 22s583ms 09 32 15m26s 28s942ms 10 25 10m6s 24s265ms 11 25 8m20s 20s15ms 12 6 2s980ms 496ms 13 30 47s934ms 1s597ms 14 36 8m10s 13s614ms 15 27 19m 42s226ms 16 21 7m34s 21s629ms 17 35 5m26s 9s331ms [ User: intelifix - Total duration: 1h38m56s - Times executed: 275 ]
[ Application: [unknown] - Total duration: 1h38m56s - Times executed: 275 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028682, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-19 09:18:11 Duration: 8m26s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028702, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');
Date: 2026-08-19 15:29:45 Duration: 7m44s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028689, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-19 11:35:45 Duration: 7m37s Database: rio User: intelifix Remote: [local] Application: [unknown]
3 1h22m21s 48 287ms 5m21s 1m42s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 19 07 3 5m14s 1m44s 08 3 4m35s 1m31s 09 3 6m47s 2m15s 10 3 6m32s 2m10s 11 3 6m44s 2m14s 12 3 5m5s 1m41s 13 3 4m20s 1m26s 14 3 5m34s 1m51s 15 3 5m50s 1m56s 16 3 6m1s 2m 17 3 5m20s 1m46s 18 3 4m31s 1m30s 19 3 3m39s 1m13s 20 3 4m13s 1m24s 21 3 4m3s 1m21s 22 3 3m47s 1m15s [ User: intelifix - Total duration: 1h22m21s - Times executed: 48 ]
[ Application: psql - Total duration: 1h22m21s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-19 09:22:12 Duration: 5m21s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-19 11:21:48 Duration: 5m20s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-19 10:21:54 Duration: 5m3s Database: brasilia User: intelifix Remote: [local] Application: psql
4 23m58s 1,563 150ms 5s537ms 920ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 19 08 101 1m24s 833ms 09 259 3m15s 755ms 10 185 2m22s 771ms 11 139 2m32s 1s99ms 12 33 22s385ms 678ms 13 111 1m49s 984ms 14 200 2m57s 888ms 15 244 4m14s 1s41ms 16 180 3m21s 1s117ms 17 111 1m38s 888ms [ User: intelifix - Total duration: 23m58s - Times executed: 1563 ]
[ Application: [unknown] - Total duration: 23m58s - Times executed: 1563 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (133219, 397, 'ZTE3ANNT4P86423,F00C51539028,F00C51539029,ZTEGDE35482D$ZTE3ANNR9W48218,D89A0DACC63F,D89A0DACC640,ZTEGDB16CE05$ZTE3ANNQ8M12337,843C991FE911,843C991FE912,ZTEGD7BA779E$ZTE3ANNT3J16253,D83139A16840,D83139A16841,ZTEGDD3396BB$ZTE3ANNR2Q61060,F4E84F864B18,F4E84F864B19,ZTEGD97B613E$ZTE3ANNR9W04221,D89A0DA8BF11,D89A0DA8BF12,ZTEGDB162228$ZTE3ANNR1Y09344,14CA56CD857B,14CA56CD857C,ZTEGD9709ADB$ZTE3ANNQ6300876,3CF9F06FB8B3,3CF9F06FB8B4,ZTEGD52E3A03$ZTE3ANNQ8M15210,843C99202C67,843C99202C68,ZTEGD7BA82D7$ZTE3ANNRCB42173,D8313921AB6C,D8313921AB6D,ZTEGDD2A5A52$ZTE3ANNR5W50822,48D682332AEE,48D682332AEF,ZTEGDB00C685$ZTE3ANNRC510671,6C11BA6323F1,6C11BA6323F2,ZTEGDC6E3F6E$ZTE3ANNQ9J39979,843C992F7A37,843C992F7A38,ZTEGD7BBA4D6$ZTE3ANNT3H19816,D83139989408,D83139989409,ZTEGDD321E07$ZTE3ANNQ7111430,C4EBFF8AD44C,C4EBFF8AD44D,ZTEGD70A4978$ZTE3ANNQ3611569,3CF9F0A5E494,3CF9F0A5E495,ZTEGD64090CC$ZTE3ANNT3H16502,D8313998465C,D8313998465D,ZTEGDD321115$ZTE3ANNR9F42106,D89A0DA6B8BF,D89A0DA6B8C0,ZTEGDB15CBC5$ZTE3ANNQCA53200,14CA56D723BB,14CA56D723BC,ZTEGD972353B$ZTE3ANNR3J35306,F4E84F8989DC,F4E84F8989DD,ZTEGD97BEBB4$ZTE3ANNQ9310983,843C993396A7,843C993396A8,ZTEGD7BBE6DE$ZTE3ANNR9F48168,D89A0DA746D3,D89A0DA746D4,ZTEGDB15E373$ZTE3ANNR6R27403,48D682380704,48D682380705,ZTEGDB0195DE$ZTE3ANNR1Y45724,14CA56D0DA23,14CA56D0DA24,ZTEGD97128F7$ZTE3ANNR9F18170,D89A0DA487BF,D89A0DA487C0,ZTEGDB156E45$ZTE3ANNR6R30596,48D6823851DA,48D6823851DB,ZTEGDB01A257$ZTE3ANNR5W28881,48D6823128B0,48D6823128B1,ZTEGDB0070D0$ZTE3ANNR8C30500,3891485151DF,3891485151E0,ZTEGDB08F794$ZTE3ANNR2Q42452,F4E84F8496F8,F4E84F8496F9,ZTEGD97B188E', '',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-19 14:03:49 Duration: 5s537ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (278962, 304, '835162924005725,241689115762,241676710613,241730911436,241676762234,241727085562,241652016687,241673086577,241649685573,241678311319,241663850918,241708787390,241609877995,241632281821,241604324255,241713345164,241606694767,241617412132,241680302344,241704657088,241664784757,241604312537,241618289602,241668196167,241620688905,241676704753,241635782129,241673347691,241607229397,241676706975,241704341424,241704222546,241614545656,241730907293,241663841321,241676788802,241647346074,241676675558,241711232231,241689377583,241620735475', '',0320,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-19 16:03:55 Duration: 5s278ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (278179, 450, '835177926003838,241693217374,241665933343,241616032435,241693188203,241654311132,241631817476,241713684748,241617467591,241661511217,241629921434,241710269195,241631080930,241656458085,241715641023,241734191621,241689003855,241609346776,241694903746,241637464560,241689420720,241649177184,241653898183,241703526484,241699282535,241703504462,241660992951,241665931222,241713074453,241656477178,241699239702,241689413648,241656454651,241703744867,241677818890,241696810420,241701263031,241677507188,241728273546,241667095869,241669721435', '',0320,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-19 15:09:04 Duration: 5s209ms Database: rio User: intelifix Remote: [local] Application: [unknown]
5 17m35s 3 2m50s 9m4s 5m51s analyze verbose;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 19 05 3 17m35s 5m51s [ User: intelifix - Total duration: 17m35s - Times executed: 3 ]
[ Application: psql - Total duration: 17m35s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-19 05:09:05 Duration: 9m4s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-19 05:14:45 Duration: 5m39s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-19 05:17:36 Duration: 2m50s Database: contagem User: intelifix Remote: [local] Application: psql
6 17m9s 272 151ms 3m1s 3s786ms call rs_giga_triagem (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 19 00 12 33s625ms 2s802ms 01 12 23s315ms 1s942ms 02 11 24s213ms 2s201ms 03 12 32s853ms 2s737ms 04 12 24s417ms 2s34ms 05 12 22s896ms 1s908ms 06 11 24s7ms 2s182ms 07 12 2m 10s2ms 08 12 27s113ms 2s259ms 09 12 3m28s 17s410ms 10 12 2m20s 11s744ms 11 12 32s816ms 2s734ms 12 12 25s174ms 2s97ms 13 12 29s308ms 2s442ms 14 12 28s192ms 2s349ms 15 12 26s427ms 2s202ms 16 12 34s333ms 2s861ms 17 12 38s376ms 3s198ms 18 11 25s728ms 2s338ms 19 12 25s174ms 2s97ms 20 12 33s386ms 2s782ms 21 11 24s278ms 2s207ms 22 12 24s323ms 2s26ms [ User: intelifix - Total duration: 17m9s - Times executed: 272 ]
[ Application: psql - Total duration: 17m9s - Times executed: 272 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-19 09:18:14 Duration: 3m1s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-19 10:47:00 Duration: 1m51s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-19 07:26:46 Duration: 1m40s Database: rio User: intelifix Remote: [local] Application: psql
7 15m32s 66 1s195ms 5m31s 14s127ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 19 07 3 16s497ms 5s499ms 08 8 1m25s 10s743ms 09 8 1m10s 8s808ms 10 4 39s525ms 9s881ms 11 4 58s9ms 14s502ms 12 2 12s809ms 6s404ms 13 9 1m4s 7s218ms 14 6 40s402ms 6s733ms 15 5 27s689ms 5s537ms 16 11 2m21s 12s824ms 17 6 6m15s 1m2s [ User: intelifix - Total duration: 15m32s - Times executed: 66 ]
[ Application: [unknown] - Total duration: 15m32s - Times executed: 66 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-19', 099, '', '', 0, 6, '2025-08-25');
Date: 2026-08-19 17:42:50 Duration: 5m31s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-19', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-19 16:27:33 Duration: 39s69ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-19', 0302, '', '', 0, 6, '2026-08-01');
Date: 2026-08-19 08:42:18 Duration: 30s891ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 9m47s 45 9s845ms 34s697ms 13s62ms create table temp0000288888 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 19 07 12 2m39s 13s312ms 08 18 3m36s 12s28ms 09 9 2m9s 14s439ms 10 3 40s894ms 13s631ms 11 3 40s701ms 13s567ms [ User: intelifix - Total duration: 9m47s - Times executed: 45 ]
[ Application: [unknown] - Total duration: 9m47s - Times executed: 45 ]
-
CREATE TABLE temp0000288888 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-19 07:18:05 Duration: 34s697ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288888 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-19 09:26:11 Duration: 17s310ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288888 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-19 09:24:15 Duration: 16s639ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 9m26s 1,078 150ms 4s14ms 525ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 19 07 22 16s163ms 734ms 08 130 59s668ms 458ms 09 167 1m24s 508ms 10 124 1m8s 553ms 11 128 1m11s 558ms 12 32 19s919ms 622ms 13 67 34s427ms 513ms 14 99 1m 608ms 15 132 1m2s 469ms 16 132 1m8s 519ms 17 45 20s591ms 457ms [ User: intelifix - Total duration: 9m26s - Times executed: 1078 ]
[ Application: [unknown] - Total duration: 9m26s - Times executed: 1078 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "242688", "modelo" : "46", "itens" : "1062D0C6F3B5,54A65C90940B,9058514383EB,14B7F8DE8F9E,5C7695966CE8,BC9B689744AF,80D04A9431ED,087E6484AE73,383FB3A860F2,905851A8176F,905851456F50,A456CCE297E0", "usuario" : "414", "caixa" : "2901446", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-19 14:52:09 Duration: 4s14ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "279176", "modelo" : "464", "itens" : "241742564559,241774104158,241767424763,241776318694,241742565872,241747668402,241760180308,241760773755,241739616078,241760836465,241759658203,241776750006,241814383050,241778997373,241764153647,241747531217,241742951320,241745705965,241759922931,241777902733,241743365254,241764548185,241764628193,241743321536,241761334853,241776683860,241761363846,241738868092,241739444849,241775238398,241762344862,241775301335,241738849606,241747422340,241746647583,241738701231,241778776667,241814596987,241764595463,241742403758,241762474953,241744889410,241767636882,241743259408,241775620311,241744135767,241743279410,241738790308,241743347171,241738682239", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-19 11:29:11 Duration: 2s605ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "279044", "modelo" : "464", "itens" : "241746879907,241778568184,241739677475,241762613149,241761213046,241814145170,241778615765,241776791323,241778993636,241778992828,241813926383,241813927999,241812918293,241764826473,241778877384,241747531621,241778616068,241775311212,241814596482,241767948406,241747515659,241745343248,241747510609,241738373140,241687511117,241738576874,241744550915,241814377493,241778632838,241813983841,241742838806,241759951318,241771369211,241738862739,241764394153,241742865677,241776657897,241778765656,241739608603,241815775475,241747342635,241759667901,241778712038,241738840212,241742792337,241775876676,241765532738,241813907492,241762578802,241778898598", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-19 11:30:21 Duration: 1s911ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 7m38s 133 222ms 1m5s 3s445ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 19 00 5 23s429ms 4s685ms 01 6 8s955ms 1s492ms 02 5 8s983ms 1s796ms 03 5 9s878ms 1s975ms 04 6 11s458ms 1s909ms 05 4 11s503ms 2s875ms 07 10 31s714ms 3s171ms 08 12 46s638ms 3s886ms 09 12 46s878ms 3s906ms 10 12 46s654ms 3s887ms 11 12 41s86ms 3s423ms 12 3 3s319ms 1s106ms 13 6 44s521ms 7s420ms 14 6 9s278ms 1s546ms 15 6 11s38ms 1s839ms 16 5 9s274ms 1s854ms 17 7 1m8s 9s847ms 21 5 12s64ms 2s412ms 22 6 12s694ms 2s115ms [ User: intelifix - Total duration: 7m38s - Times executed: 133 ]
[ Application: psql - Total duration: 7m38s - Times executed: 133 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-19 17:46:06 Duration: 1m5s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-19 13:15:38 Duration: 37s573ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-19 00:05:18 Duration: 17s611ms Database: rio User: intelifix Remote: [local] Application: psql
11 5m42s 23 11s914ms 39s170ms 14s896ms create table temp0000288972 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 19 13 14 3m44s 16s23ms 15 9 1m58s 13s145ms [ User: intelifix - Total duration: 5m42s - Times executed: 23 ]
[ Application: [unknown] - Total duration: 5m42s - Times executed: 23 ]
-
CREATE TABLE temp0000288972 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-19 13:36:34 Duration: 39s170ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288972 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-19 13:43:23 Duration: 15s732ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288972 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-19 13:46:37 Duration: 15s339ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 3m47s 63 209ms 5s219ms 3s614ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 19 08 3 10s156ms 3s385ms 09 4 14s830ms 3s707ms 10 4 13s638ms 3s409ms 11 5 17s514ms 3s502ms 12 3 11s202ms 3s734ms 13 3 10s199ms 3s399ms 14 4 13s696ms 3s424ms 15 6 17s580ms 2s930ms 16 6 22s662ms 3s777ms 17 5 18s280ms 3s656ms 18 4 15s204ms 3s801ms 19 4 15s445ms 3s861ms 20 5 20s737ms 4s147ms 21 3 11s741ms 3s913ms 22 4 14s834ms 3s708ms [ User: intelifix - Total duration: 3m47s - Times executed: 63 ]
[ Application: psql - Total duration: 3m47s - Times executed: 63 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-19 20:20:10 Duration: 5s219ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-19 19:00:10 Duration: 4s559ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-19 21:20:09 Duration: 4s327ms Database: brasilia User: intelifix Remote: [local] Application: psql
13 3m18s 4 5s198ms 1m38s 49s721ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 19 20 2 1m34s 47s358ms 23 2 1m44s 52s85ms [ User: intelifix - Total duration: 3m18s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m18s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-19 23:17:48 Duration: 1m38s 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-08-19 20:08:44 Duration: 1m29s 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-08-19 23:40:50 Duration: 5s540ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 3m10s 12 11s708ms 47s274ms 15s915ms create table temp0000289000 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 19 15 8 1m48s 13s516ms 16 1 12s124ms 12s124ms 17 3 1m10s 23s579ms [ User: intelifix - Total duration: 3m10s - Times executed: 12 ]
[ Application: [unknown] - Total duration: 3m10s - Times executed: 12 ]
-
CREATE TABLE temp0000289000 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-19 17:45:02 Duration: 47s274ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000289000 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-19 15:29:24 Duration: 16s46ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000289000 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-19 15:32:53 Duration: 14s468ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 2m44s 28 385ms 17s178ms 5s871ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 19 07 2 20s733ms 10s366ms 08 5 11s873ms 2s374ms 09 2 13s967ms 6s983ms 10 3 21s273ms 7s91ms 11 1 14s741ms 14s741ms 13 3 18s934ms 6s311ms 14 1 2s369ms 2s369ms 15 7 38s775ms 5s539ms 16 1 15s779ms 15s779ms 17 3 5s949ms 1s983ms [ User: intelifix - Total duration: 2m44s - Times executed: 28 ]
[ Application: psql - Total duration: 2m44s - Times executed: 28 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028673);
Date: 2026-08-19 07:20:18 Duration: 17s178ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028710);
Date: 2026-08-19 16:28:31 Duration: 15s779ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028689);
Date: 2026-08-19 11:27:46 Duration: 14s741ms Database: rio User: intelifix Remote: [local] Application: psql
16 2m27s 40 197ms 37s352ms 3s676ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 19 07 4 2s655ms 663ms 08 6 3s351ms 558ms 09 3 2s200ms 733ms 10 4 1m14s 18s509ms 11 1 1s127ms 1s127ms 13 7 2s362ms 337ms 14 2 1s494ms 747ms 15 11 50s446ms 4s586ms 16 1 452ms 452ms 17 1 8s927ms 8s927ms [ User: intelifix - Total duration: 2m27s - Times executed: 40 ]
[ Application: psql - Total duration: 2m27s - Times executed: 40 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028687);
Date: 2026-08-19 10:42:52 Duration: 37s352ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028685);
Date: 2026-08-19 10:34:48 Duration: 22s582ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028709);
Date: 2026-08-19 15:58:18 Duration: 20s646ms Database: rio User: intelifix Remote: [local] Application: psql
17 2m24s 11 10s983ms 15s21ms 13s131ms create table temp0000288994 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 19 15 11 2m24s 13s131ms [ User: intelifix - Total duration: 2m24s - Times executed: 11 ]
[ Application: [unknown] - Total duration: 2m24s - Times executed: 11 ]
-
CREATE TABLE temp0000288994 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-19 15:45:22 Duration: 15s21ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288994 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-19 15:46:25 Duration: 14s171ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288994 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-19 15:46:53 Duration: 14s77ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 2m21s 86 150ms 21s795ms 1s640ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 19 08 17 8s399ms 494ms 09 12 42s317ms 3s526ms 10 1 3s378ms 3s378ms 11 5 3s319ms 663ms 13 21 37s551ms 1s788ms 14 9 11s877ms 1s319ms 15 4 24s411ms 6s102ms 16 4 3s188ms 797ms 17 13 6s610ms 508ms [ User: intelifix - Total duration: 2m21s - Times executed: 86 ]
[ Application: [unknown] - Total duration: 2m21s - Times executed: 86 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (052752) LIMIT 1;
Date: 2026-08-19 15:32:47 Duration: 21s795ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (051812) LIMIT 1;
Date: 2026-08-19 09:13:22 Duration: 21s198ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (052752) LIMIT 1;
Date: 2026-08-19 13:58:59 Duration: 18s678ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
19 2m12s 4 465ms 1m12s 33s60ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 19 20 2 59s332ms 29s666ms 23 2 1m12s 36s454ms [ User: intelifix - Total duration: 2m12s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m12s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-19 23:14:07 Duration: 1m12s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-19 20:05:28 Duration: 58s866ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-19 23:40:09 Duration: 528ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 2m2s 7 12s261ms 39s750ms 17s462ms create table temp0000288942 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 19 10 7 2m2s 17s462ms [ User: intelifix - Total duration: 2m2s - Times executed: 7 ]
[ Application: [unknown] - Total duration: 2m2s - Times executed: 7 ]
-
CREATE TABLE temp0000288942 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-19 10:33:46 Duration: 39s750ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288942 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-19 10:41:52 Duration: 15s863ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288942 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-19 10:34:40 Duration: 14s555ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,563 23m58s 150ms 5s537ms 920ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 19 08 101 1m24s 833ms 09 259 3m15s 755ms 10 185 2m22s 771ms 11 139 2m32s 1s99ms 12 33 22s385ms 678ms 13 111 1m49s 984ms 14 200 2m57s 888ms 15 244 4m14s 1s41ms 16 180 3m21s 1s117ms 17 111 1m38s 888ms [ User: intelifix - Total duration: 23m58s - Times executed: 1563 ]
[ Application: [unknown] - Total duration: 23m58s - Times executed: 1563 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (133219, 397, 'ZTE3ANNT4P86423,F00C51539028,F00C51539029,ZTEGDE35482D$ZTE3ANNR9W48218,D89A0DACC63F,D89A0DACC640,ZTEGDB16CE05$ZTE3ANNQ8M12337,843C991FE911,843C991FE912,ZTEGD7BA779E$ZTE3ANNT3J16253,D83139A16840,D83139A16841,ZTEGDD3396BB$ZTE3ANNR2Q61060,F4E84F864B18,F4E84F864B19,ZTEGD97B613E$ZTE3ANNR9W04221,D89A0DA8BF11,D89A0DA8BF12,ZTEGDB162228$ZTE3ANNR1Y09344,14CA56CD857B,14CA56CD857C,ZTEGD9709ADB$ZTE3ANNQ6300876,3CF9F06FB8B3,3CF9F06FB8B4,ZTEGD52E3A03$ZTE3ANNQ8M15210,843C99202C67,843C99202C68,ZTEGD7BA82D7$ZTE3ANNRCB42173,D8313921AB6C,D8313921AB6D,ZTEGDD2A5A52$ZTE3ANNR5W50822,48D682332AEE,48D682332AEF,ZTEGDB00C685$ZTE3ANNRC510671,6C11BA6323F1,6C11BA6323F2,ZTEGDC6E3F6E$ZTE3ANNQ9J39979,843C992F7A37,843C992F7A38,ZTEGD7BBA4D6$ZTE3ANNT3H19816,D83139989408,D83139989409,ZTEGDD321E07$ZTE3ANNQ7111430,C4EBFF8AD44C,C4EBFF8AD44D,ZTEGD70A4978$ZTE3ANNQ3611569,3CF9F0A5E494,3CF9F0A5E495,ZTEGD64090CC$ZTE3ANNT3H16502,D8313998465C,D8313998465D,ZTEGDD321115$ZTE3ANNR9F42106,D89A0DA6B8BF,D89A0DA6B8C0,ZTEGDB15CBC5$ZTE3ANNQCA53200,14CA56D723BB,14CA56D723BC,ZTEGD972353B$ZTE3ANNR3J35306,F4E84F8989DC,F4E84F8989DD,ZTEGD97BEBB4$ZTE3ANNQ9310983,843C993396A7,843C993396A8,ZTEGD7BBE6DE$ZTE3ANNR9F48168,D89A0DA746D3,D89A0DA746D4,ZTEGDB15E373$ZTE3ANNR6R27403,48D682380704,48D682380705,ZTEGDB0195DE$ZTE3ANNR1Y45724,14CA56D0DA23,14CA56D0DA24,ZTEGD97128F7$ZTE3ANNR9F18170,D89A0DA487BF,D89A0DA487C0,ZTEGDB156E45$ZTE3ANNR6R30596,48D6823851DA,48D6823851DB,ZTEGDB01A257$ZTE3ANNR5W28881,48D6823128B0,48D6823128B1,ZTEGDB0070D0$ZTE3ANNR8C30500,3891485151DF,3891485151E0,ZTEGDB08F794$ZTE3ANNR2Q42452,F4E84F8496F8,F4E84F8496F9,ZTEGD97B188E', '',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-19 14:03:49 Duration: 5s537ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (278962, 304, '835162924005725,241689115762,241676710613,241730911436,241676762234,241727085562,241652016687,241673086577,241649685573,241678311319,241663850918,241708787390,241609877995,241632281821,241604324255,241713345164,241606694767,241617412132,241680302344,241704657088,241664784757,241604312537,241618289602,241668196167,241620688905,241676704753,241635782129,241673347691,241607229397,241676706975,241704341424,241704222546,241614545656,241730907293,241663841321,241676788802,241647346074,241676675558,241711232231,241689377583,241620735475', '',0320,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-19 16:03:55 Duration: 5s278ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (278179, 450, '835177926003838,241693217374,241665933343,241616032435,241693188203,241654311132,241631817476,241713684748,241617467591,241661511217,241629921434,241710269195,241631080930,241656458085,241715641023,241734191621,241689003855,241609346776,241694903746,241637464560,241689420720,241649177184,241653898183,241703526484,241699282535,241703504462,241660992951,241665931222,241713074453,241656477178,241699239702,241689413648,241656454651,241703744867,241677818890,241696810420,241701263031,241677507188,241728273546,241667095869,241669721435', '',0320,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-19 15:09:04 Duration: 5s209ms Database: rio User: intelifix Remote: [local] Application: [unknown]
2 1,078 9m26s 150ms 4s14ms 525ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 19 07 22 16s163ms 734ms 08 130 59s668ms 458ms 09 167 1m24s 508ms 10 124 1m8s 553ms 11 128 1m11s 558ms 12 32 19s919ms 622ms 13 67 34s427ms 513ms 14 99 1m 608ms 15 132 1m2s 469ms 16 132 1m8s 519ms 17 45 20s591ms 457ms [ User: intelifix - Total duration: 9m26s - Times executed: 1078 ]
[ Application: [unknown] - Total duration: 9m26s - Times executed: 1078 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "242688", "modelo" : "46", "itens" : "1062D0C6F3B5,54A65C90940B,9058514383EB,14B7F8DE8F9E,5C7695966CE8,BC9B689744AF,80D04A9431ED,087E6484AE73,383FB3A860F2,905851A8176F,905851456F50,A456CCE297E0", "usuario" : "414", "caixa" : "2901446", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-19 14:52:09 Duration: 4s14ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "279176", "modelo" : "464", "itens" : "241742564559,241774104158,241767424763,241776318694,241742565872,241747668402,241760180308,241760773755,241739616078,241760836465,241759658203,241776750006,241814383050,241778997373,241764153647,241747531217,241742951320,241745705965,241759922931,241777902733,241743365254,241764548185,241764628193,241743321536,241761334853,241776683860,241761363846,241738868092,241739444849,241775238398,241762344862,241775301335,241738849606,241747422340,241746647583,241738701231,241778776667,241814596987,241764595463,241742403758,241762474953,241744889410,241767636882,241743259408,241775620311,241744135767,241743279410,241738790308,241743347171,241738682239", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-19 11:29:11 Duration: 2s605ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "279044", "modelo" : "464", "itens" : "241746879907,241778568184,241739677475,241762613149,241761213046,241814145170,241778615765,241776791323,241778993636,241778992828,241813926383,241813927999,241812918293,241764826473,241778877384,241747531621,241778616068,241775311212,241814596482,241767948406,241747515659,241745343248,241747510609,241738373140,241687511117,241738576874,241744550915,241814377493,241778632838,241813983841,241742838806,241759951318,241771369211,241738862739,241764394153,241742865677,241776657897,241778765656,241739608603,241815775475,241747342635,241759667901,241778712038,241738840212,241742792337,241775876676,241765532738,241813907492,241762578802,241778898598", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-19 11:30:21 Duration: 1s911ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 275 1h38m56s 152ms 8m26s 21s588ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 19 07 6 11m58s 1m59s 08 32 12m2s 22s583ms 09 32 15m26s 28s942ms 10 25 10m6s 24s265ms 11 25 8m20s 20s15ms 12 6 2s980ms 496ms 13 30 47s934ms 1s597ms 14 36 8m10s 13s614ms 15 27 19m 42s226ms 16 21 7m34s 21s629ms 17 35 5m26s 9s331ms [ User: intelifix - Total duration: 1h38m56s - Times executed: 275 ]
[ Application: [unknown] - Total duration: 1h38m56s - Times executed: 275 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028682, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-19 09:18:11 Duration: 8m26s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028702, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');
Date: 2026-08-19 15:29:45 Duration: 7m44s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028689, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-19 11:35:45 Duration: 7m37s Database: rio User: intelifix Remote: [local] Application: [unknown]
4 272 17m9s 151ms 3m1s 3s786ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 19 00 12 33s625ms 2s802ms 01 12 23s315ms 1s942ms 02 11 24s213ms 2s201ms 03 12 32s853ms 2s737ms 04 12 24s417ms 2s34ms 05 12 22s896ms 1s908ms 06 11 24s7ms 2s182ms 07 12 2m 10s2ms 08 12 27s113ms 2s259ms 09 12 3m28s 17s410ms 10 12 2m20s 11s744ms 11 12 32s816ms 2s734ms 12 12 25s174ms 2s97ms 13 12 29s308ms 2s442ms 14 12 28s192ms 2s349ms 15 12 26s427ms 2s202ms 16 12 34s333ms 2s861ms 17 12 38s376ms 3s198ms 18 11 25s728ms 2s338ms 19 12 25s174ms 2s97ms 20 12 33s386ms 2s782ms 21 11 24s278ms 2s207ms 22 12 24s323ms 2s26ms [ User: intelifix - Total duration: 17m9s - Times executed: 272 ]
[ Application: psql - Total duration: 17m9s - Times executed: 272 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-19 09:18:14 Duration: 3m1s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-19 10:47:00 Duration: 1m51s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-19 07:26:46 Duration: 1m40s Database: rio User: intelifix Remote: [local] Application: psql
5 156 32s890ms 150ms 598ms 210ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 19 01 15 2s914ms 194ms 04 6 1s33ms 172ms 05 7 1s670ms 238ms 07 21 4s637ms 220ms 08 15 2s880ms 192ms 09 21 4s716ms 224ms 10 18 3s436ms 190ms 11 9 1s905ms 211ms 12 13 3s24ms 232ms 15 3 667ms 222ms 16 24 5s217ms 217ms 17 4 786ms 196ms [ User: intelifix - Total duration: 32s890ms - Times executed: 156 ]
[ Application: [unknown] - Total duration: 32s890ms - Times executed: 156 ]
-
SELECT * FROM RS_TRIAGEM (429, 5, '113', 3, '241738413043,241760833031,241763328808,241764559500,241776650625,241763508601,241768777487,241779105364,241746008093,241742694044,241765569206,241746879907,241778568184,241739677475,241738682239,241743347171,241738790308,241743279410,241744135767,241775620311,241743259408,241767636882,241744889410,241813899815,241762474953,241761213046,241760065672,241779069401,241741281819,241762613149,241775313535,241764648600,241764671330,241770139001,241742660001,241813923151,241764829807,241763982037,241777988903', NULL, NULL, 0464, 00);
Date: 2026-08-19 05:14:31 Duration: 598ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (405, 5, '113', 3, '229699564461,216931334258,229834743647,229773874766,229800385759,229710057381,229712764548,229826958498,229710341125,229699004350,229836205069,229715150618,216925187092', NULL, NULL, 0137, 00);
Date: 2026-08-19 12:35:59 Duration: 433ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (405, 5, '113', 3, '229799653960,229704767987,229714287390,229774369113,229645712539,229765986880,229765817593,216927687392,216922099911,229707809609,229643799703', NULL, NULL, 0137, 00);
Date: 2026-08-19 07:12:15 Duration: 403ms Database: rio User: intelifix Remote: [local] Application: [unknown]
6 133 7m38s 222ms 1m5s 3s445ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 19 00 5 23s429ms 4s685ms 01 6 8s955ms 1s492ms 02 5 8s983ms 1s796ms 03 5 9s878ms 1s975ms 04 6 11s458ms 1s909ms 05 4 11s503ms 2s875ms 07 10 31s714ms 3s171ms 08 12 46s638ms 3s886ms 09 12 46s878ms 3s906ms 10 12 46s654ms 3s887ms 11 12 41s86ms 3s423ms 12 3 3s319ms 1s106ms 13 6 44s521ms 7s420ms 14 6 9s278ms 1s546ms 15 6 11s38ms 1s839ms 16 5 9s274ms 1s854ms 17 7 1m8s 9s847ms 21 5 12s64ms 2s412ms 22 6 12s694ms 2s115ms [ User: intelifix - Total duration: 7m38s - Times executed: 133 ]
[ Application: psql - Total duration: 7m38s - Times executed: 133 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-19 17:46:06 Duration: 1m5s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-19 13:15:38 Duration: 37s573ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-19 00:05:18 Duration: 17s611ms Database: rio User: intelifix Remote: [local] Application: psql
7 119 55s15ms 268ms 860ms 462ms 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 Aug 19 01 1 608ms 608ms 02 1 346ms 346ms 03 1 413ms 413ms 04 2 733ms 366ms 05 3 1s299ms 433ms 06 3 1s117ms 372ms 07 8 3s410ms 426ms 08 12 4s974ms 414ms 09 12 5s445ms 453ms 10 9 4s590ms 510ms 11 11 4s591ms 417ms 12 5 2s234ms 446ms 13 12 5s169ms 430ms 14 9 4s983ms 553ms 15 11 5s211ms 473ms 16 11 5s576ms 506ms 17 5 2s874ms 574ms 20 1 424ms 424ms 21 1 413ms 413ms 23 1 595ms 595ms [ User: lenon - Total duration: 55s15ms - Times executed: 119 ]
[ Application: [unknown] - Total duration: 55s15ms - Times executed: 119 ]
-
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-08-19 17:02:42 Duration: 860ms 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-08-19 09:51:45 Duration: 747ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-08-19 10:02:55 Duration: 746ms Database: contagem User: lenon Remote: [local] Application: [unknown] Bind query: yes
8 107 1m1s 322ms 968ms 577ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 19 01 1 911ms 911ms 02 1 488ms 488ms 03 1 551ms 551ms 04 2 997ms 498ms 05 2 999ms 499ms 07 7 3s717ms 531ms 08 11 5s681ms 516ms 09 11 6s294ms 572ms 10 9 5s591ms 621ms 11 11 5s668ms 515ms 12 5 2s847ms 569ms 13 10 5s258ms 525ms 14 9 6s95ms 677ms 15 11 6s469ms 588ms 16 11 6s706ms 609ms 17 5 3s564ms 712ms [ User: intelifix - Total duration: 1m1s - Times executed: 107 ]
[ Application: [unknown] - Total duration: 1m1s - Times executed: 107 ]
-
select * from rs_menu_grants (508, 18, 1);
Date: 2026-08-19 14:37:36 Duration: 968ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (417, 19, 1);
Date: 2026-08-19 17:02:42 Duration: 949ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (499, 19, 1);
Date: 2026-08-19 01:08:28 Duration: 911ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 86 2m21s 150ms 21s795ms 1s640ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 19 08 17 8s399ms 494ms 09 12 42s317ms 3s526ms 10 1 3s378ms 3s378ms 11 5 3s319ms 663ms 13 21 37s551ms 1s788ms 14 9 11s877ms 1s319ms 15 4 24s411ms 6s102ms 16 4 3s188ms 797ms 17 13 6s610ms 508ms [ User: intelifix - Total duration: 2m21s - Times executed: 86 ]
[ Application: [unknown] - Total duration: 2m21s - Times executed: 86 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (052752) LIMIT 1;
Date: 2026-08-19 15:32:47 Duration: 21s795ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (051812) LIMIT 1;
Date: 2026-08-19 09:13:22 Duration: 21s198ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (052752) LIMIT 1;
Date: 2026-08-19 13:58:59 Duration: 18s678ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
10 82 47s945ms 176ms 1s320ms 584ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 19 09 50 28s932ms 578ms 10 14 8s574ms 612ms 11 18 10s437ms 579ms [ User: intelifix - Total duration: 47s945ms - Times executed: 82 ]
[ Application: [unknown] - Total duration: 47s945ms - Times executed: 82 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"53989","seriais":"241653137290,241672175467,241620813541,241599249506,241597911026,241667036267,241668262437,241732106770,241668269811,241695522123","usuario":"416","observacao":""}');
Date: 2026-08-19 09:34:17 Duration: 1s320ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"53989","seriais":"14CA56CE48B7,4896D95504D8,D831392471DC,4896D95AEF60,3CF9F0A28FEC,5872C98A6FA1,6C11BA68FECB,D83139935C42,F4E84F87A496,3CF9F0A86C10,3891484A6947,48D68234D1E8,843C992C8B05,D83139246E0A,843C9935BD63,F4E84F86A6B0,48D6823A59DC,C4EBFF8B4DA2,4896D956FB82,3891484D447B,14CA56D20FBF,3CF9F0A6C762,3891484BDC27,D831398C9BCA","usuario":"416","observacao":""}');
Date: 2026-08-19 09:33:03 Duration: 1s234ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"53989","seriais":"241676799005,241617613947,241654351214,241663112327,241599386971,241689161525,241593413538,241678301823,241711259304,241659700311,241676657475,241646257999,241700944257,241646272850,241679930209,241679930613,241599235666,241629999701,241664864260,241689172435,241659790825,241593178082,241637728806,241727002244,241679756072,241647333144,241708847878","usuario":"416","observacao":""}');
Date: 2026-08-19 09:34:11 Duration: 946ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
11 76 32s34ms 153ms 1s47ms 421ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 19 08 8 4s378ms 547ms 09 24 10s868ms 452ms 10 20 9s237ms 461ms 11 10 4s135ms 413ms 12 2 318ms 159ms 14 1 388ms 388ms 15 1 160ms 160ms 16 10 2s546ms 254ms [ User: intelifix - Total duration: 32s34ms - Times executed: 76 ]
[ Application: [unknown] - Total duration: 32s34ms - Times executed: 76 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '5C7D7D6F61E4,A0FF70822D14,A0FF7087ECDC,484BD495B43C,484BD48EEF2C,484BD4A2E63C,5C7D7D5A09AC,484BD4A2E534,484BD49608CC,484BD493B5F4,484BD4A21EA4,6C55E8CDE41C,484BD4A12334,A0FF70D2857C,A0FF702B4D04,A0FF7024D5C4,484BD49BCC3C,484BD47CE794,484BD49F3A4C,6C55E8C9B5C4', '138;1', 'DEFAULT', 09, 0154, '','', '', 00);
Date: 2026-08-19 10:18:27 Duration: 1s47ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '4896D958B9FE,843C99227BAF,D89A0DA692BB,F4E84F81C2D8,D831399AE6D4,3891484AC8F9,14CA56CE2115,5872C98CAA31,3CF9F0AC0F2A,5872C98D26CF,D831398FCB40,843C992C3A7D,843C99332EB5,F00C514D6274,3CF9F0ABD600,48D682333C1C,F4E84F821E52,5872C98D0E57,6C11BA6F6C5D,C4EBFF903EFA', '138;1', 'DEFAULT', 09, 0323, '','', '', 00);
Date: 2026-08-19 08:52:20 Duration: 1s35ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, 'F4E84F8665B2,F4E84F83B994,3CF9F0ADAB92,5872C98B2D8B,4896D952839E,3CF9F0AA453E,D89A0DA46F41,4896D95605F4,F4E84F88CE3E,3CF9F0ABF316,4896D954BA50,F4E84F81D106,48D6823880F6,843C992E0937,6C11BA66D1CD,C4EBFF8AACF2,843C992FC429,C4EBFF8A922E,C4EBFF8B44D8,843C9922B7B5', '138;1', 'DEFAULT', 09, 0323, '','', '', 00);
Date: 2026-08-19 10:48:40 Duration: 1s2ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
12 68 25s689ms 191ms 3s31ms 377ms create table temp0000238496 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 19 12 4 3s827ms 956ms 13 17 4s999ms 294ms 14 11 3s814ms 346ms 15 14 4s458ms 318ms 16 11 4s803ms 436ms 17 11 3s785ms 344ms [ User: intelifix - Total duration: 25s689ms - Times executed: 68 ]
[ Application: [unknown] - Total duration: 25s689ms - Times executed: 68 ]
-
CREATE TABLE temp0000238496 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"7", "cliente" :"0", "desde" :"14-08-2026", "ate" :"19-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-19 12:50:08 Duration: 3s31ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000238496 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"7", "cliente" :"0", "desde" :"14-08-2026", "ate" :"19-08-2026", "nota-fiscal":"2030", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-19 13:54:47 Duration: 792ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000238496 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"7", "cliente" :"0", "desde" :"14-08-2026", "ate" :"19-08-2026", "nota-fiscal":"2030", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-19 16:26:54 Duration: 699ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
13 68 14s374ms 150ms 454ms 211ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 19 01 1 203ms 203ms 09 1 337ms 337ms 10 5 983ms 196ms 11 4 674ms 168ms 12 1 176ms 176ms 13 4 883ms 220ms 14 5 858ms 171ms 15 16 3s652ms 228ms 16 17 3s464ms 203ms 17 14 3s138ms 224ms [ User: intelifix - Total duration: 14s374ms - Times executed: 68 ]
[ Application: [unknown] - Total duration: 14s374ms - Times executed: 68 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "434", "data-de" : "2026-08-19", "data-ate" : "2026-08-19", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 508 }');
Date: 2026-08-19 17:16:28 Duration: 454ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "434", "data-de" : "2026-08-19", "data-ate" : "2026-08-19", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 508 }');
Date: 2026-08-19 15:15:44 Duration: 425ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "434", "data-de" : "2026-08-19", "data-ate" : "2026-08-19", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 508 }');
Date: 2026-08-19 16:59:30 Duration: 421ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 67 31s278ms 194ms 1s341ms 466ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 19 07 3 1s41ms 347ms 08 7 2s733ms 390ms 09 10 4s342ms 434ms 10 9 4s984ms 553ms 11 7 3s86ms 440ms 12 1 416ms 416ms 13 4 1s931ms 482ms 14 4 2s173ms 543ms 15 10 4s939ms 493ms 16 3 1s171ms 390ms 17 9 4s457ms 495ms [ User: intelifix - Total duration: 31s278ms - Times executed: 67 ]
[ Application: [unknown] - Total duration: 31s278ms - Times executed: 67 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-08-19 17:41:05 Duration: 1s341ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-08-19 15:55:43 Duration: 780ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-08-19 10:15:19 Duration: 722ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
15 66 15m32s 1s195ms 5m31s 14s127ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 19 07 3 16s497ms 5s499ms 08 8 1m25s 10s743ms 09 8 1m10s 8s808ms 10 4 39s525ms 9s881ms 11 4 58s9ms 14s502ms 12 2 12s809ms 6s404ms 13 9 1m4s 7s218ms 14 6 40s402ms 6s733ms 15 5 27s689ms 5s537ms 16 11 2m21s 12s824ms 17 6 6m15s 1m2s [ User: intelifix - Total duration: 15m32s - Times executed: 66 ]
[ Application: [unknown] - Total duration: 15m32s - Times executed: 66 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-19', 099, '', '', 0, 6, '2025-08-25');
Date: 2026-08-19 17:42:50 Duration: 5m31s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-19', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-19 16:27:33 Duration: 39s69ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-19', 0302, '', '', 0, 6, '2026-08-01');
Date: 2026-08-19 08:42:18 Duration: 30s891ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 65 40s864ms 156ms 7s287ms 628ms create table temp0000288908 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 19 08 8 8s770ms 1s96ms 09 12 2s787ms 232ms 10 3 630ms 210ms 11 7 1s461ms 208ms 12 2 535ms 267ms 13 7 1s398ms 199ms 14 20 17s131ms 856ms 15 5 5s507ms 1s101ms 16 1 2s641ms 2s641ms [ User: intelifix - Total duration: 40s864ms - Times executed: 65 ]
[ Application: [unknown] - Total duration: 40s864ms - Times executed: 65 ]
-
CREATE TABLE temp0000288908 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"14-08-2026", "ate" :"19-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-19 08:06:56 Duration: 7s287ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288908 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"01-08-2026", "ate" :"19-08-2026", "nota-fiscal":"82953", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-19 16:44:15 Duration: 2s641ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288908 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"01-08-2026", "ate" :"19-08-2026", "nota-fiscal":"82953", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-19 14:06:06 Duration: 2s150ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 63 3m47s 209ms 5s219ms 3s614ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 19 08 3 10s156ms 3s385ms 09 4 14s830ms 3s707ms 10 4 13s638ms 3s409ms 11 5 17s514ms 3s502ms 12 3 11s202ms 3s734ms 13 3 10s199ms 3s399ms 14 4 13s696ms 3s424ms 15 6 17s580ms 2s930ms 16 6 22s662ms 3s777ms 17 5 18s280ms 3s656ms 18 4 15s204ms 3s801ms 19 4 15s445ms 3s861ms 20 5 20s737ms 4s147ms 21 3 11s741ms 3s913ms 22 4 14s834ms 3s708ms [ User: intelifix - Total duration: 3m47s - Times executed: 63 ]
[ Application: psql - Total duration: 3m47s - Times executed: 63 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-19 20:20:10 Duration: 5s219ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-19 19:00:10 Duration: 4s559ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-19 21:20:09 Duration: 4s327ms Database: brasilia User: intelifix Remote: [local] Application: psql
18 56 30s449ms 152ms 6s151ms 543ms select * from rs_lote_saida_manutencao (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 19 06 1 195ms 195ms 07 1 174ms 174ms 09 9 16s779ms 1s864ms 10 6 1s237ms 206ms 11 4 1s710ms 427ms 12 3 1s367ms 455ms 13 2 674ms 337ms 14 7 2s244ms 320ms 15 5 1s129ms 225ms 16 9 2s750ms 305ms 17 9 2s183ms 242ms [ User: intelifix - Total duration: 30s449ms - Times executed: 56 ]
[ Application: [unknown] - Total duration: 30s449ms - Times executed: 56 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "51323", "oficina" : "2", "cliente" : "1", "usuario" : "409", "nf" : "000083431", "data-saida" : "2026-08-14", "sucata" : "D", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "N", "valorado" : "", "motivo" : "0", "obs" : "PRIORIDADE ECO -LOTE 26", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-08-19 09:08:40 Duration: 6s151ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "51812", "oficina" : "2", "cliente" : "1", "usuario" : "409", "nf" : "000083431", "data-saida" : "2026-08-14", "sucata" : "D", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "N", "valorado" : "", "motivo" : "0", "obs" : "PRIORIDADE PAPEL -LOTE 26", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-08-19 09:14:39 Duration: 4s393ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "51815", "oficina" : "2", "cliente" : "1", "usuario" : "409", "nf" : "000083414", "data-saida" : "2026-08-14", "sucata" : "D", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "N", "valorado" : "", "motivo" : "0", "obs" : "CARDS - LOTE 26", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-08-19 09:15:55 Duration: 2s544ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
19 56 16s867ms 155ms 723ms 301ms create table temp0000238502 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 19 13 9 2s730ms 303ms 14 22 7s394ms 336ms 15 25 6s742ms 269ms [ User: intelifix - Total duration: 16s867ms - Times executed: 56 ]
[ Application: [unknown] - Total duration: 16s867ms - Times executed: 56 ]
-
CREATE TABLE temp0000238502 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"7", "cliente" :"0", "desde" :"14-08-2026", "ate" :"19-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-19 13:11:06 Duration: 723ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000238502 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"7", "cliente" :"0", "desde" :"14-08-2026", "ate" :"19-08-2026", "nota-fiscal":"2030", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-19 14:44:22 Duration: 589ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000238502 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"7", "cliente" :"0", "desde" :"14-08-2026", "ate" :"19-08-2026", "nota-fiscal":"2030", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-19 15:34:22 Duration: 479ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
20 53 8s568ms 150ms 212ms 161ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 19 07 1 153ms 153ms 08 1 207ms 207ms 09 15 2s421ms 161ms 10 6 1s11ms 168ms 11 6 986ms 164ms 12 1 150ms 150ms 13 3 474ms 158ms 14 4 647ms 161ms 15 7 1s82ms 154ms 16 7 1s99ms 157ms 17 2 334ms 167ms [ User: intelifix - Total duration: 8s568ms - Times executed: 53 ]
[ Application: [unknown] - Total duration: 8s568ms - Times executed: 53 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0155;
Date: 2026-08-19 10:08:55 Duration: 212ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0153;
Date: 2026-08-19 08:54:38 Duration: 207ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0155;
Date: 2026-08-19 09:49:44 Duration: 178ms 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 2m50s 9m4s 5m51s 3 17m35s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 19 05 3 17m35s 5m51s [ User: intelifix - Total duration: 17m35s - Times executed: 3 ]
[ Application: psql - Total duration: 17m35s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-19 05:09:05 Duration: 9m4s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-19 05:14:45 Duration: 5m39s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-19 05:17:36 Duration: 2m50s Database: contagem User: intelifix Remote: [local] Application: psql
2 1s531ms 9m44s 2m44s 48 2h11m48s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 19 07 3 8m54s 2m58s 08 3 6m52s 2m17s 09 3 10m34s 3m31s 10 3 10m31s 3m30s 11 3 10m12s 3m24s 12 3 7m55s 2m38s 13 3 6m35s 2m11s 14 3 8m56s 2m58s 15 3 9m20s 3m6s 16 3 9m33s 3m11s 17 3 9m12s 3m4s 18 3 7m43s 2m34s 19 3 6m1s 2m 20 3 6m58s 2m19s 21 3 6m20s 2m6s 22 3 6m5s 2m1s [ User: intelifix - Total duration: 2h11m48s - Times executed: 48 ]
[ Application: psql - Total duration: 2h11m48s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-19 09:14:45 Duration: 9m44s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-19 10:14:42 Duration: 9m40s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-19 11:14:24 Duration: 9m22s Database: rio User: intelifix Remote: [local] Application: psql
3 287ms 5m21s 1m42s 48 1h22m21s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 19 07 3 5m14s 1m44s 08 3 4m35s 1m31s 09 3 6m47s 2m15s 10 3 6m32s 2m10s 11 3 6m44s 2m14s 12 3 5m5s 1m41s 13 3 4m20s 1m26s 14 3 5m34s 1m51s 15 3 5m50s 1m56s 16 3 6m1s 2m 17 3 5m20s 1m46s 18 3 4m31s 1m30s 19 3 3m39s 1m13s 20 3 4m13s 1m24s 21 3 4m3s 1m21s 22 3 3m47s 1m15s [ User: intelifix - Total duration: 1h22m21s - Times executed: 48 ]
[ Application: psql - Total duration: 1h22m21s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-19 09:22:12 Duration: 5m21s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-19 11:21:48 Duration: 5m20s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-19 10:21:54 Duration: 5m3s Database: brasilia User: intelifix Remote: [local] Application: psql
4 5s198ms 1m38s 49s721ms 4 3m18s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 19 20 2 1m34s 47s358ms 23 2 1m44s 52s85ms [ User: intelifix - Total duration: 3m18s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m18s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-19 23:17:48 Duration: 1m38s 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-08-19 20:08:44 Duration: 1m29s 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-08-19 23:40:50 Duration: 5s540ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
5 465ms 1m12s 33s60ms 4 2m12s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 19 20 2 59s332ms 29s666ms 23 2 1m12s 36s454ms [ User: intelifix - Total duration: 2m12s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m12s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-19 23:14:07 Duration: 1m12s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-19 20:05:28 Duration: 58s866ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-19 23:40:09 Duration: 528ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 152ms 8m26s 21s588ms 275 1h38m56s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 19 07 6 11m58s 1m59s 08 32 12m2s 22s583ms 09 32 15m26s 28s942ms 10 25 10m6s 24s265ms 11 25 8m20s 20s15ms 12 6 2s980ms 496ms 13 30 47s934ms 1s597ms 14 36 8m10s 13s614ms 15 27 19m 42s226ms 16 21 7m34s 21s629ms 17 35 5m26s 9s331ms [ User: intelifix - Total duration: 1h38m56s - Times executed: 275 ]
[ Application: [unknown] - Total duration: 1h38m56s - Times executed: 275 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028682, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-19 09:18:11 Duration: 8m26s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028702, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');
Date: 2026-08-19 15:29:45 Duration: 7m44s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028689, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-19 11:35:45 Duration: 7m37s Database: rio User: intelifix Remote: [local] Application: [unknown]
7 12s261ms 39s750ms 17s462ms 7 2m2s create table temp0000288942 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 19 10 7 2m2s 17s462ms [ User: intelifix - Total duration: 2m2s - Times executed: 7 ]
[ Application: [unknown] - Total duration: 2m2s - Times executed: 7 ]
-
CREATE TABLE temp0000288942 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-19 10:33:46 Duration: 39s750ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288942 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-19 10:41:52 Duration: 15s863ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288942 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-19 10:34:40 Duration: 14s555ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 11s708ms 47s274ms 15s915ms 12 3m10s create table temp0000289000 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 19 15 8 1m48s 13s516ms 16 1 12s124ms 12s124ms 17 3 1m10s 23s579ms [ User: intelifix - Total duration: 3m10s - Times executed: 12 ]
[ Application: [unknown] - Total duration: 3m10s - Times executed: 12 ]
-
CREATE TABLE temp0000289000 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-19 17:45:02 Duration: 47s274ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000289000 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-19 15:29:24 Duration: 16s46ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000289000 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-19 15:32:53 Duration: 14s468ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 11s914ms 39s170ms 14s896ms 23 5m42s create table temp0000288972 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 19 13 14 3m44s 16s23ms 15 9 1m58s 13s145ms [ User: intelifix - Total duration: 5m42s - Times executed: 23 ]
[ Application: [unknown] - Total duration: 5m42s - Times executed: 23 ]
-
CREATE TABLE temp0000288972 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-19 13:36:34 Duration: 39s170ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288972 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-19 13:43:23 Duration: 15s732ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288972 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-19 13:46:37 Duration: 15s339ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 1s195ms 5m31s 14s127ms 66 15m32s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 19 07 3 16s497ms 5s499ms 08 8 1m25s 10s743ms 09 8 1m10s 8s808ms 10 4 39s525ms 9s881ms 11 4 58s9ms 14s502ms 12 2 12s809ms 6s404ms 13 9 1m4s 7s218ms 14 6 40s402ms 6s733ms 15 5 27s689ms 5s537ms 16 11 2m21s 12s824ms 17 6 6m15s 1m2s [ User: intelifix - Total duration: 15m32s - Times executed: 66 ]
[ Application: [unknown] - Total duration: 15m32s - Times executed: 66 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-19', 099, '', '', 0, 6, '2025-08-25');
Date: 2026-08-19 17:42:50 Duration: 5m31s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-19', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-19 16:27:33 Duration: 39s69ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-19', 0302, '', '', 0, 6, '2026-08-01');
Date: 2026-08-19 08:42:18 Duration: 30s891ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 10s983ms 15s21ms 13s131ms 11 2m24s create table temp0000288994 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 19 15 11 2m24s 13s131ms [ User: intelifix - Total duration: 2m24s - Times executed: 11 ]
[ Application: [unknown] - Total duration: 2m24s - Times executed: 11 ]
-
CREATE TABLE temp0000288994 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-19 15:45:22 Duration: 15s21ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288994 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-19 15:46:25 Duration: 14s171ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288994 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-19 15:46:53 Duration: 14s77ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 9s845ms 34s697ms 13s62ms 45 9m47s create table temp0000288888 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 19 07 12 2m39s 13s312ms 08 18 3m36s 12s28ms 09 9 2m9s 14s439ms 10 3 40s894ms 13s631ms 11 3 40s701ms 13s567ms [ User: intelifix - Total duration: 9m47s - Times executed: 45 ]
[ Application: [unknown] - Total duration: 9m47s - Times executed: 45 ]
-
CREATE TABLE temp0000288888 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-19 07:18:05 Duration: 34s697ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288888 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-19 09:26:11 Duration: 17s310ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288888 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-19 09:24:15 Duration: 16s639ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 385ms 17s178ms 5s871ms 28 2m44s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 19 07 2 20s733ms 10s366ms 08 5 11s873ms 2s374ms 09 2 13s967ms 6s983ms 10 3 21s273ms 7s91ms 11 1 14s741ms 14s741ms 13 3 18s934ms 6s311ms 14 1 2s369ms 2s369ms 15 7 38s775ms 5s539ms 16 1 15s779ms 15s779ms 17 3 5s949ms 1s983ms [ User: intelifix - Total duration: 2m44s - Times executed: 28 ]
[ Application: psql - Total duration: 2m44s - Times executed: 28 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028673);
Date: 2026-08-19 07:20:18 Duration: 17s178ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028710);
Date: 2026-08-19 16:28:31 Duration: 15s779ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028689);
Date: 2026-08-19 11:27:46 Duration: 14s741ms Database: rio User: intelifix Remote: [local] Application: psql
14 151ms 3m1s 3s786ms 272 17m9s call rs_giga_triagem (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 19 00 12 33s625ms 2s802ms 01 12 23s315ms 1s942ms 02 11 24s213ms 2s201ms 03 12 32s853ms 2s737ms 04 12 24s417ms 2s34ms 05 12 22s896ms 1s908ms 06 11 24s7ms 2s182ms 07 12 2m 10s2ms 08 12 27s113ms 2s259ms 09 12 3m28s 17s410ms 10 12 2m20s 11s744ms 11 12 32s816ms 2s734ms 12 12 25s174ms 2s97ms 13 12 29s308ms 2s442ms 14 12 28s192ms 2s349ms 15 12 26s427ms 2s202ms 16 12 34s333ms 2s861ms 17 12 38s376ms 3s198ms 18 11 25s728ms 2s338ms 19 12 25s174ms 2s97ms 20 12 33s386ms 2s782ms 21 11 24s278ms 2s207ms 22 12 24s323ms 2s26ms [ User: intelifix - Total duration: 17m9s - Times executed: 272 ]
[ Application: psql - Total duration: 17m9s - Times executed: 272 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-19 09:18:14 Duration: 3m1s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-19 10:47:00 Duration: 1m51s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-19 07:26:46 Duration: 1m40s Database: rio User: intelifix Remote: [local] Application: psql
15 197ms 37s352ms 3s676ms 40 2m27s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 19 07 4 2s655ms 663ms 08 6 3s351ms 558ms 09 3 2s200ms 733ms 10 4 1m14s 18s509ms 11 1 1s127ms 1s127ms 13 7 2s362ms 337ms 14 2 1s494ms 747ms 15 11 50s446ms 4s586ms 16 1 452ms 452ms 17 1 8s927ms 8s927ms [ User: intelifix - Total duration: 2m27s - Times executed: 40 ]
[ Application: psql - Total duration: 2m27s - Times executed: 40 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028687);
Date: 2026-08-19 10:42:52 Duration: 37s352ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028685);
Date: 2026-08-19 10:34:48 Duration: 22s582ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028709);
Date: 2026-08-19 15:58:18 Duration: 20s646ms Database: rio User: intelifix Remote: [local] Application: psql
16 209ms 5s219ms 3s614ms 63 3m47s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 19 08 3 10s156ms 3s385ms 09 4 14s830ms 3s707ms 10 4 13s638ms 3s409ms 11 5 17s514ms 3s502ms 12 3 11s202ms 3s734ms 13 3 10s199ms 3s399ms 14 4 13s696ms 3s424ms 15 6 17s580ms 2s930ms 16 6 22s662ms 3s777ms 17 5 18s280ms 3s656ms 18 4 15s204ms 3s801ms 19 4 15s445ms 3s861ms 20 5 20s737ms 4s147ms 21 3 11s741ms 3s913ms 22 4 14s834ms 3s708ms [ User: intelifix - Total duration: 3m47s - Times executed: 63 ]
[ Application: psql - Total duration: 3m47s - Times executed: 63 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-19 20:20:10 Duration: 5s219ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-19 19:00:10 Duration: 4s559ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-19 21:20:09 Duration: 4s327ms Database: brasilia User: intelifix Remote: [local] Application: psql
17 222ms 1m5s 3s445ms 133 7m38s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 19 00 5 23s429ms 4s685ms 01 6 8s955ms 1s492ms 02 5 8s983ms 1s796ms 03 5 9s878ms 1s975ms 04 6 11s458ms 1s909ms 05 4 11s503ms 2s875ms 07 10 31s714ms 3s171ms 08 12 46s638ms 3s886ms 09 12 46s878ms 3s906ms 10 12 46s654ms 3s887ms 11 12 41s86ms 3s423ms 12 3 3s319ms 1s106ms 13 6 44s521ms 7s420ms 14 6 9s278ms 1s546ms 15 6 11s38ms 1s839ms 16 5 9s274ms 1s854ms 17 7 1m8s 9s847ms 21 5 12s64ms 2s412ms 22 6 12s694ms 2s115ms [ User: intelifix - Total duration: 7m38s - Times executed: 133 ]
[ Application: psql - Total duration: 7m38s - Times executed: 133 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-19 17:46:06 Duration: 1m5s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-19 13:15:38 Duration: 37s573ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-19 00:05:18 Duration: 17s611ms Database: rio User: intelifix Remote: [local] Application: psql
18 150ms 21s795ms 1s640ms 86 2m21s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 19 08 17 8s399ms 494ms 09 12 42s317ms 3s526ms 10 1 3s378ms 3s378ms 11 5 3s319ms 663ms 13 21 37s551ms 1s788ms 14 9 11s877ms 1s319ms 15 4 24s411ms 6s102ms 16 4 3s188ms 797ms 17 13 6s610ms 508ms [ User: intelifix - Total duration: 2m21s - Times executed: 86 ]
[ Application: [unknown] - Total duration: 2m21s - Times executed: 86 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (052752) LIMIT 1;
Date: 2026-08-19 15:32:47 Duration: 21s795ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (051812) LIMIT 1;
Date: 2026-08-19 09:13:22 Duration: 21s198ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (052752) LIMIT 1;
Date: 2026-08-19 13:58:59 Duration: 18s678ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
19 150ms 5s537ms 920ms 1,563 23m58s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 19 08 101 1m24s 833ms 09 259 3m15s 755ms 10 185 2m22s 771ms 11 139 2m32s 1s99ms 12 33 22s385ms 678ms 13 111 1m49s 984ms 14 200 2m57s 888ms 15 244 4m14s 1s41ms 16 180 3m21s 1s117ms 17 111 1m38s 888ms [ User: intelifix - Total duration: 23m58s - Times executed: 1563 ]
[ Application: [unknown] - Total duration: 23m58s - Times executed: 1563 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (133219, 397, 'ZTE3ANNT4P86423,F00C51539028,F00C51539029,ZTEGDE35482D$ZTE3ANNR9W48218,D89A0DACC63F,D89A0DACC640,ZTEGDB16CE05$ZTE3ANNQ8M12337,843C991FE911,843C991FE912,ZTEGD7BA779E$ZTE3ANNT3J16253,D83139A16840,D83139A16841,ZTEGDD3396BB$ZTE3ANNR2Q61060,F4E84F864B18,F4E84F864B19,ZTEGD97B613E$ZTE3ANNR9W04221,D89A0DA8BF11,D89A0DA8BF12,ZTEGDB162228$ZTE3ANNR1Y09344,14CA56CD857B,14CA56CD857C,ZTEGD9709ADB$ZTE3ANNQ6300876,3CF9F06FB8B3,3CF9F06FB8B4,ZTEGD52E3A03$ZTE3ANNQ8M15210,843C99202C67,843C99202C68,ZTEGD7BA82D7$ZTE3ANNRCB42173,D8313921AB6C,D8313921AB6D,ZTEGDD2A5A52$ZTE3ANNR5W50822,48D682332AEE,48D682332AEF,ZTEGDB00C685$ZTE3ANNRC510671,6C11BA6323F1,6C11BA6323F2,ZTEGDC6E3F6E$ZTE3ANNQ9J39979,843C992F7A37,843C992F7A38,ZTEGD7BBA4D6$ZTE3ANNT3H19816,D83139989408,D83139989409,ZTEGDD321E07$ZTE3ANNQ7111430,C4EBFF8AD44C,C4EBFF8AD44D,ZTEGD70A4978$ZTE3ANNQ3611569,3CF9F0A5E494,3CF9F0A5E495,ZTEGD64090CC$ZTE3ANNT3H16502,D8313998465C,D8313998465D,ZTEGDD321115$ZTE3ANNR9F42106,D89A0DA6B8BF,D89A0DA6B8C0,ZTEGDB15CBC5$ZTE3ANNQCA53200,14CA56D723BB,14CA56D723BC,ZTEGD972353B$ZTE3ANNR3J35306,F4E84F8989DC,F4E84F8989DD,ZTEGD97BEBB4$ZTE3ANNQ9310983,843C993396A7,843C993396A8,ZTEGD7BBE6DE$ZTE3ANNR9F48168,D89A0DA746D3,D89A0DA746D4,ZTEGDB15E373$ZTE3ANNR6R27403,48D682380704,48D682380705,ZTEGDB0195DE$ZTE3ANNR1Y45724,14CA56D0DA23,14CA56D0DA24,ZTEGD97128F7$ZTE3ANNR9F18170,D89A0DA487BF,D89A0DA487C0,ZTEGDB156E45$ZTE3ANNR6R30596,48D6823851DA,48D6823851DB,ZTEGDB01A257$ZTE3ANNR5W28881,48D6823128B0,48D6823128B1,ZTEGDB0070D0$ZTE3ANNR8C30500,3891485151DF,3891485151E0,ZTEGDB08F794$ZTE3ANNR2Q42452,F4E84F8496F8,F4E84F8496F9,ZTEGD97B188E', '',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-19 14:03:49 Duration: 5s537ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (278962, 304, '835162924005725,241689115762,241676710613,241730911436,241676762234,241727085562,241652016687,241673086577,241649685573,241678311319,241663850918,241708787390,241609877995,241632281821,241604324255,241713345164,241606694767,241617412132,241680302344,241704657088,241664784757,241604312537,241618289602,241668196167,241620688905,241676704753,241635782129,241673347691,241607229397,241676706975,241704341424,241704222546,241614545656,241730907293,241663841321,241676788802,241647346074,241676675558,241711232231,241689377583,241620735475', '',0320,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-19 16:03:55 Duration: 5s278ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (278179, 450, '835177926003838,241693217374,241665933343,241616032435,241693188203,241654311132,241631817476,241713684748,241617467591,241661511217,241629921434,241710269195,241631080930,241656458085,241715641023,241734191621,241689003855,241609346776,241694903746,241637464560,241689420720,241649177184,241653898183,241703526484,241699282535,241703504462,241660992951,241665931222,241713074453,241656477178,241699239702,241689413648,241656454651,241703744867,241677818890,241696810420,241701263031,241677507188,241728273546,241667095869,241669721435', '',0320,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-19 15:09:04 Duration: 5s209ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 156ms 7s287ms 628ms 65 40s864ms create table temp0000288908 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 19 08 8 8s770ms 1s96ms 09 12 2s787ms 232ms 10 3 630ms 210ms 11 7 1s461ms 208ms 12 2 535ms 267ms 13 7 1s398ms 199ms 14 20 17s131ms 856ms 15 5 5s507ms 1s101ms 16 1 2s641ms 2s641ms [ User: intelifix - Total duration: 40s864ms - Times executed: 65 ]
[ Application: [unknown] - Total duration: 40s864ms - Times executed: 65 ]
-
CREATE TABLE temp0000288908 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"14-08-2026", "ate" :"19-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-19 08:06:56 Duration: 7s287ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288908 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"01-08-2026", "ate" :"19-08-2026", "nota-fiscal":"82953", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-19 16:44:15 Duration: 2s641ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288908 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"01-08-2026", "ate" :"19-08-2026", "nota-fiscal":"82953", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-19 14:06:06 Duration: 2s150ms 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 7 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Aug 19 09 1 0ms 0ms 10 1 0ms 0ms 13 1 0ms 0ms 19 1 0ms 0ms 20 2 0ms 0ms 21 1 0ms 0ms [ User: intelifix - Total duration: 12s972ms - Times executed: 6 ]
[ User: etiquetas - Total duration: 171ms - Times executed: 1 ]
[ Application: psql - Total duration: 12s972ms - Times executed: 6 ]
[ Application: [unknown] - Total duration: 171ms - Times executed: 1 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 17,652 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 14 FATAL entries
- 3788 ERROR entries
- 0 WARNING entries
- 8 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 3,640 Max number of times the same event was reported
- 3,810 Total events found
Rank Times reported Error 1 3,640 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Aug 19 07 98 08 306 09 378 10 386 11 428 12 144 13 195 14 248 15 265 16 255 17 228 18 118 19 119 20 120 21 118 22 120 23 114 - ERROR: prepared statement "_PLAN00000000363BA5C0" does not exist
- ERROR: prepared statement "_PLAN0000000053D019A0" does not exist
- ERROR: prepared statement "_PLAN0000000053D09960" does not exist
Statement: DEALLOCATE "_PLAN00000000363BA5C0"
Date: 2026-08-19 07:15:42 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000053D019A0"
Date: 2026-08-19 07:17:17 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000053D09960"
Date: 2026-08-19 07:17:56 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 56 ERROR: out of shared memory
Times Reported Most Frequent Error / Event #2
Day Hour Count Aug 19 08 56 - ERROR: out of shared memory at character 61
- ERROR: out of shared memory
- ERROR: out of shared memory at character 61
Hint: You might need to increase "max_locks_per_transaction".
Statement: SELECT pg_encoding_to_char(encoding) FROM pg_database WHERE datname = current_database();Date: 2026-08-19 08:48:25 Database: rio Application: [unknown] User: intelifix Remote: [local]
Hint: You might need to increase "max_locks_per_transaction".
Statement: DISCARD ALLDate: 2026-08-19 08:48:25 Database: rio Application: [unknown] User: intelifix Remote: [local]
Hint: You might need to increase "max_locks_per_transaction".
Statement: SELECT pg_encoding_to_char(encoding) FROM pg_database WHERE datname = current_database();Date: 2026-08-19 08:48:25 Database: rio Application: [unknown] User: intelifix Remote: [local]
3 46 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #3
Day Hour Count Aug 19 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-08-19 00:05: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-08-19 00:35:01 Database: brasilia Application: psql User: intelifix Remote: [local]
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-08-19 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
4 21 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Aug 19 10 2 11 13 13 2 16 2 17 2 - ERROR: trailing junk after numeric literal at or near "3491303b" at character 27
- ERROR: trailing junk after numeric literal at or near "3491303b" at character 27
- ERROR: trailing junk after numeric literal at or near "30C50FB6FEAA" at character 27
Statement: select * from rs_caixa_qr(3491303b)
Date: 2026-08-19 10:24:45 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(3491303b)
Date: 2026-08-19 10:24:45 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(30C50FB6FEAA)
Date: 2026-08-19 11:03:27 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
5 17 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #5
Day Hour Count Aug 19 08 14 10 3 - ERROR: syntax error at or near "1" at character 95
- ERROR: syntax error at or near "12" at character 95
- ERROR: syntax error at or near "129" at character 95
Statement: SELECT MOD_ID AS ID, MOD_LEGADO || ' | ' || TCN_NOME AS NOME FROM RS_MODELOS_LISTA('{"nome":"'1","cliente":"0","status":"S","grupo":0,"tipo":0}')
Date: 2026-08-19 08:43:50 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT MOD_ID AS ID, MOD_LEGADO || ' | ' || TCN_NOME AS NOME FROM RS_MODELOS_LISTA('{"nome":"'12","cliente":"0","status":"S","grupo":0,"tipo":0}')
Date: 2026-08-19 08:43:51 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT MOD_ID AS ID, MOD_LEGADO || ' | ' || TCN_NOME AS NOME FROM RS_MODELOS_LISTA('{"nome":"'129","cliente":"0","status":"S","grupo":0,"tipo":0}')
Date: 2026-08-19 08:43:52 Database: rio Application: [unknown] User: intelifix Remote: [local]
6 7 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #6
Day Hour Count Aug 19 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-08-19 03:05:01 Database: rio Application: [unknown] User: lenon Remote: [local]
Date: 2026-08-19 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-19 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
7 7 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #7
Day Hour Count Aug 19 07 2 09 2 10 3 - LOG: process 239601 still waiting for ShareLock on transaction 4654738 after 1000.066 ms
- LOG: process 239601 still waiting for ShareLock on transaction 4654738 after 5882.264 ms
- LOG: process 309530 still waiting for ShareLock on transaction 4662581 after 1001.139 ms
Detail: Process holding the lock: 239600. Wait queue: 239601.
Context: while updating tuple (77048,26) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-08-19 07:25:10 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 239600. Wait queue: 239601.
Context: while updating tuple (77048,26) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-08-19 07:25:15 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 311453. Wait queue: 309530.
Context: while updating tuple (77052,85) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-08-19 09:15:18 Database: rio Application: psql User: intelifix Remote: [local]
8 5 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #8
Day Hour Count Aug 19 00 1 05 1 06 1 07 1 18 1 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "testes" does not exist
Date: 2026-08-19 00:02:21 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-08-19 05:49:02 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-19 06:02:18 Database: testes Application: [unknown] User: lenon Remote: [local]
9 5 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #9
Day Hour Count Aug 19 05 4 08 1 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-19 05:32:05 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-19 05:32:05 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-19 05:32:05 Database: contagem Application: psql User: intelifix Remote: [local]
10 2 ERROR: spiexceptions.OutOfMemory: out of shared memory
Times Reported Most Frequent Error / Event #10
Day Hour Count Aug 19 08 2 - ERROR: spiexceptions.OutOfMemory: out of shared memory
- ERROR: spiexceptions.OutOfMemory: out of shared memory
Context: Traceback (most recent call last): PL/Python function "rs_fast_excel", line 135, in <module> rows = dados.fetch(1000) PL/Python function "rs_fast_excel"
Hint: You might need to increase "max_locks_per_transaction".
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM rs_lotes_cria(2,409,''/var/www/html/uploads/799, 800, 801, 608, 609, 1192, 160 - 29.xlsx'') ;' , '/var/www/html/tmp/temp_29.xlsx' )Date: 2026-08-19 08:48:30 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Context: Traceback (most recent call last): PL/Python function "rs_fast_excel", line 135, in <module> rows = dados.fetch(1000) PL/Python function "rs_fast_excel"
Hint: You might need to increase "max_locks_per_transaction".
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM rs_lotes_cria(2,409,''/var/www/html/uploads/799, 800, 801, 608, 609, 1192, 160 - 29.xlsx'') ;' , '/var/www/html/tmp/temp_29.xlsx' )Date: 2026-08-19 08:49:05 Database: contagem 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 Aug 19 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-08-19 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-19 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
12 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #12
Day Hour Count Aug 19 03 1 - LOG: database system was shut down at 2026-08-19 03:05:01 -03
Date: 2026-08-19 03:05:02
13 1 ERROR: unterminated quoted string at or near "..."
Times Reported Most Frequent Error / Event #13
Day Hour Count Aug 19 16 1 - ERROR: unterminated quoted string at or near "'WIFIÇTÇWPAÇSÇCLARO_949769ÇPÇKA=NMC7WDMÇÇ6CB7E2949769'');" at character 39
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA('WIFIÇTÇWPAÇSÇCLARO_949769ÇPÇKA=NMC7WDMÇÇ6CB7E2949769'');
Date: 2026-08-19 16:09:29 Database: rio Application: [unknown] User: intelifix Remote: [local]