pgBadger-
Global information
- Generated on Thu Jun 18 23:50:08 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 33,050 log entries in 6s
- Log start from 2026-06-18 00:02:13 to 2026-06-18 23:45:04
-
Overview
Global Stats
- 292 Number of unique normalized queries
- 4,597 Number of queries
- 6h18m16s Total query duration
- 2026-06-18 00:02:13 First query
- 2026-06-18 23:43:29 Last query
- 6 queries/s at 2026-06-18 16:25:06 Query peak
- 6h18m16s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 6h18m16s Execute total duration
- 3,492 Number of events
- 21 Number of unique normalized events
- 2,656 Max number of times the same event was reported
- 0 Number of cancellation
- 355 Total number of automatic vacuums
- 742 Total number of automatic analyzes
- 11 Number temporary file
- 104.00 MiB Max size of temporary file
- 104.00 MiB Average size of temporary file
- 254 Total number of sessions
- 6 sessions at 2026-06-18 16:21:48 Session peak
- 9d8h34m56s Total duration of sessions
- 53m3s Average duration of sessions
- 18 Average queries per session
- 1m29s Average queries duration per session
- 51m33s Average idle time per session
- 257 Total number of connections
- 4 connections/s at 2026-06-18 03:05:16 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 6 queries/s Query Peak
- 2026-06-18 16:25:06 Date
SELECT Traffic
Key values
- 4 queries/s Query Peak
- 2026-06-18 15:05:03 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-06-18 23:42:49 Date
Queries duration
Key values
- 6h18m16s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 18 00 16 0ms 19s89ms 5s696ms 13s562ms 56s709ms 56s709ms 01 12 0ms 2s907ms 2s90ms 5s70ms 5s70ms 5s70ms 02 11 0ms 3s575ms 2s112ms 5s389ms 5s389ms 5s389ms 03 12 0ms 3s5ms 1s992ms 4s801ms 4s801ms 4s801ms 04 26 0ms 2s937ms 1s32ms 4s198ms 4s778ms 4s778ms 05 43 0ms 8m7s 15s237ms 5s706ms 2m12s 8m8s 06 15 0ms 12s68ms 3s670ms 14s526ms 19s995ms 19s995ms 07 157 0ms 8m44s 11s851ms 1m9s 3m52s 8m44s 08 433 150ms 5m38s 3s593ms 35s525ms 3m52s 5m41s 09 596 150ms 7m35s 3s177ms 1m1s 4m5s 7m38s 10 502 150ms 9m28s 3s17ms 1m4s 1m37s 9m31s 11 467 0ms 6m46s 3s396ms 1m6s 1m31s 6m51s 12 89 0ms 6m15s 9s621ms 24s399ms 55s105ms 6m51s 13 272 0ms 5m54s 2s633ms 18s565ms 33s423ms 5m54s 14 417 0ms 6m26s 4s978ms 51s83ms 4m18s 6m28s 15 514 150ms 8m38s 4s133ms 1m1s 4m30s 8m42s 16 470 150ms 7m31s 4s48ms 59s34ms 4m20s 11m3s 17 180 0ms 6m19s 4s709ms 23s592ms 59s515ms 6m51s 18 12 0ms 5m43s 32s952ms 33s680ms 5m43s 5m43s 19 10 0ms 5m31s 37s686ms 29s170ms 5m31s 5m31s 20 71 0ms 6m31s 13s47ms 1m35s 6m31s 6m31s 21 22 0ms 5m41s 19s655ms 25s658ms 33s77ms 5m41s 22 21 0ms 10m27s 34s719ms 4s950ms 1m14s 10m32s 23 229 0ms 1m51s 8s737ms 1m25s 1m38s 1m51s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 18 00 2 0 6s781ms 0ms 0ms 13s562ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 14 0 226ms 306ms 404ms 823ms 05 28 0 261ms 377ms 409ms 1s353ms 06 4 0 3s882ms 0ms 1s5ms 14s526ms 07 116 0 13s726ms 2s311ms 1m9s 4m16s 08 364 0 3s590ms 4s827ms 35s525ms 3m52s 09 491 0 3s125ms 15s75ms 59s237ms 4m16s 10 416 0 3s35ms 6s514ms 45s298ms 3m52s 11 365 0 3s239ms 8s734ms 51s426ms 3m40s 12 59 0 12s213ms 1s777ms 3s271ms 3m41s 13 227 0 2s541ms 4s850ms 7s148ms 31s880ms 14 338 0 5s53ms 11s378ms 46s240ms 4m27s 15 410 0 4s173ms 17s523ms 34s104ms 4m35s 16 359 0 4s385ms 9s808ms 33s94ms 4m28s 17 144 0 5s151ms 4s590ms 22s703ms 6m51s 18 6 0 1m2s 0ms 33s680ms 5m43s 19 4 0 1m30s 0ms 29s170ms 5m31s 20 6 57 14s325ms 1m8s 1m35s 6m31s 21 12 0 31s597ms 965ms 2s163ms 5m41s 22 8 0 1m28s 0ms 1s201ms 10m27s 23 8 221 8s737ms 1m12s 1m25s 1m51s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 18 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jun 18 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 1 1.00 0.00% 05 0 3 3.00 0.00% 06 0 1 1.00 0.00% 07 0 6 6.00 0.00% 08 0 7 7.00 0.00% 09 0 8 8.00 0.00% 10 0 9 9.00 0.00% 11 0 7 7.00 0.00% 12 0 5 5.00 0.00% 13 0 6 6.00 0.00% 14 0 7 7.00 0.00% 15 0 8 8.00 0.00% 16 0 7 7.00 0.00% 17 0 3 3.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 2 2.00 0.00% 22 0 2 2.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Jun 18 00 9 0.00/s 01 4 0.00/s 02 5 0.00/s 03 8 0.00/s 04 6 0.00/s 05 5 0.00/s 06 12 0.00/s 07 15 0.00/s 08 16 0.00/s 09 15 0.00/s 10 17 0.00/s 11 18 0.01/s 12 10 0.00/s 13 15 0.00/s 14 18 0.01/s 15 17 0.00/s 16 14 0.00/s 17 11 0.00/s 18 3 0.00/s 19 4 0.00/s 20 9 0.00/s 21 16 0.00/s 22 6 0.00/s 23 4 0.00/s Day Hour Count Average Duration Average idle time Jun 18 00 4 59m47s 59m24s 01 8 1h43s 1h39s 02 4 1h45s 1h39s 03 9 30m45s 30m42s 04 4 1h45s 1h38s 05 6 58m50s 57m1s 06 6 47m30s 47m21s 07 10 1h54s 57m48s 08 16 59m20s 57m42s 09 17 55m35s 53m44s 10 17 50m50s 49m21s 11 14 57m13s 55m20s 12 18 48m24s 47m36s 13 9 55m39s 54m20s 14 17 53m19s 51m17s 15 17 56m35s 54m30s 16 19 51m24s 49m44s 17 10 1h24s 59m 18 11 1h33s 59m57s 19 3 1h 57m54s 20 8 32m51s 30m55s 21 11 41m1s 40m22s 22 7 57m23s 55m39s 23 9 44m3s 40m21s -
Connections
Established Connections
Key values
- 4 connections Connection Peak
- 2026-06-18 03:05:16 Date
Connections per database
Key values
- rio Main Database
- 257 connections Total
Connections per user
Key values
- intelifix Main User
- 257 connections Total
-
Sessions
Simultaneous sessions
Key values
- 6 sessions Session Peak
- 2026-06-18 16:21:48 Date
Histogram of session times
Key values
- 200 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 254 sessions Total
Sessions per user
Key values
- intelifix Main User
- 254 sessions Total
Sessions per host
Key values
- [local] Main Host
- 254 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 16,717 buffers Checkpoint Peak
- 2026-06-18 10:19:38 Date
- 270.042 seconds Highest write time
- 0.056 seconds Sync time
Checkpoints Wal files
Key values
- 24 files Wal files usage Peak
- 2026-06-18 15:04:40 Date
Checkpoints distance
Key values
- 772.71 Mo Distance Peak
- 2026-06-18 15:04:40 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jun 18 00 14,987 628.474s 0.023s 628.529s 01 1,896 190.41s 0.018s 190.455s 02 1,319 132.475s 0.017s 132.513s 03 1,744 175.063s 0.034s 175.128s 04 2,966 297.66s 0.025s 297.719s 05 8,870 845.342s 0.048s 845.446s 06 7,069 458.047s 0.014s 458.079s 07 47,789 2,424.286s 0.094s 2,424.465s 08 54,242 3,101.293s 0.108s 3,101.512s 09 74,995 3,239.339s 0.191s 3,239.67s 10 60,864 3,129.313s 0.161s 3,129.599s 11 71,108 3,180.31s 0.173s 3,180.612s 12 33,721 1,811.673s 0.059s 1,811.804s 13 21,108 1,925.951s 0.13s 1,926.179s 14 62,624 3,182.041s 0.142s 3,182.318s 15 80,363 3,202.21s 0.229s 3,202.606s 16 51,424 2,975.922s 0.219s 2,976.279s 17 21,550 1,492.905s 0.094s 1,493.079s 18 1,371 137.399s 0.013s 137.445s 19 44 4.436s 0.003s 4.443s 20 1,395 167.885s 0.011s 167.91s 21 7,197 373.556s 0.072s 373.693s 22 2,753 276.358s 0.075s 276.593s 23 861 88.587s 0.052s 88.741s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jun 18 00 0 0 5 427 0.003s 0.008s 01 0 0 1 388 0.002s 0.006s 02 0 0 0 325 0.003s 0.005s 03 0 0 1 335 0.004s 0.006s 04 0 0 1 554 0.002s 0.008s 05 0 0 4 823 0.006s 0.011s 06 0 0 1 253 0.004s 0.004s 07 0 0 28 2,663 0.004s 0.012s 08 0 0 26 3,886 0.004s 0.012s 09 0 0 41 5,265 0.004s 0.012s 10 0 0 33 4,492 0.007s 0.012s 11 0 0 49 4,614 0.005s 0.012s 12 0 0 17 1,777 0.004s 0.012s 13 0 0 9 3,431 0.003s 0.012s 14 0 0 45 4,867 0.005s 0.012s 15 0 0 66 5,004 0.007s 0.012s 16 0 0 35 4,994 0.006s 0.012s 17 0 0 13 2,782 0.005s 0.01s 18 0 0 0 72 0.003s 0.009s 19 0 0 0 4 0.002s 0.001s 20 0 0 1 61 0.003s 0.004s 21 0 0 1 165 0.035s 0.008s 22 0 0 1 515 0.021s 0.013s 23 0 0 2 33 0.017s 0.024s Day Hour Count Avg time (sec) Jun 18 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Jun 18 00 12,208.14 kB 35,992.29 kB 01 1,743.67 kB 19,927.00 kB 02 1,406.20 kB 11,747.00 kB 03 1,396.43 kB 2,761.71 kB 04 1,896.88 kB 2,809.00 kB 05 6,738.90 kB 20,157.50 kB 06 4,728.00 kB 13,666.50 kB 07 37,209.08 kB 55,168.83 kB 08 36,629.25 kB 85,225.83 kB 09 55,030.50 kB 74,991.42 kB 10 46,087.50 kB 108,333.33 kB 11 66,814.92 kB 91,351.83 kB 12 22,706.83 kB 74,426.00 kB 13 12,493.33 kB 33,870.00 kB 14 61,083.92 kB 97,991.75 kB 15 90,957.92 kB 266,438.92 kB 16 47,774.42 kB 131,469.67 kB 17 20,501.50 kB 64,673.20 kB 18 616.29 kB 30,222.29 kB 19 204.00 kB 19,439.00 kB 20 4,677.00 kB 16,968.33 kB 21 3,265.17 kB 11,860.33 kB 22 1,672.44 kB 8,969.67 kB 23 4,714.67 kB 17,571.33 kB -
Temporary Files
Size of temporary files
Key values
- 104.00 MiB Temp Files size Peak
- 2026-06-18 11:53:16 Date
Number of temporary files
Key values
- 1 per second Temp Files Peak
- 2026-06-18 09:48:47 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jun 18 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 3 312.00 MiB 104.00 MiB 10 2 208.00 MiB 104.00 MiB 11 5 520.00 MiB 104.00 MiB 12 1 104.00 MiB 104.00 MiB 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 11 1.12 GiB 104.00 MiB 104.00 MiB 104.00 MiB select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025831, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-18 16:16:47 Duration: 4m27s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025823, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-18 15:05:55 Duration: 4m25s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025821, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-18 14:56:42 Duration: 4m24s Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries generating the largest temporary files
Rank Size Query 1 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-18 11:53:16 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-18 12:00:48 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
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-06-18 10:09:34 - 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-06-18 09:48:47 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-18 10:25:14 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
6 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,449,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-18 09:01:31 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
7 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-18 11:17:53 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
8 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-18 11:35:02 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
9 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-18 09:39:09 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-18 11:09:40 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
11 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-18 11:02:31 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 44.31 sec Highest CPU-cost vacuum
Table public.codigos_barra
Database rio - 2026-06-18 14:57:30 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 44.31 sec Highest CPU-cost vacuum
Table public.codigos_barra
Database rio - 2026-06-18 14:57:30 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (93) Main table analyzed (database rio)
- 742 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 93 rio.pg_catalog.pg_class 52 rio.public.temp0000282890 45 rio.public.usuarios 44 rio.pg_catalog.pg_type 41 contagem.pg_catalog.pg_attribute 35 rio.pg_catalog.pg_index 29 rio.public.temp0000282882 27 rio.public.temp0000282880 25 rio.public.temp0000282968 23 contagem.pg_catalog.pg_class 23 rio.pg_catalog.pg_depend 22 contagem.public.usuarios 20 contagem.pg_catalog.pg_type 18 rio.public.temp0000282944 18 rio.public.temp0000282940 17 rio.public.temp0000282980 16 rio.public.temp0000282888 15 rio.public.temp0000282848 13 rio.public.temp0000282942 13 rio.public.temp0000282884 11 contagem.pg_catalog.pg_index 11 rio.public.temp0000282689 9 contagem.pg_catalog.pg_depend 9 rio.public.temp0000282858 8 rio.public.temp0000282918 8 rio.public.temp0000282517 8 contagem.public.temp0000226438 6 rio.public.temp0000282906 6 rio.public.temp0000282509 6 rio.pg_catalog.pg_shdepend 5 contagem.public.temp0000226448 4 rio.public.temp0000282954 4 rio.public.temp0000282643 4 rio.public.temp0000282876 4 rio.public.temp0000282896 3 rio.public.tmp_drill_0175 3 contagem.public.temp0000226412 3 contagem.public.temp0000226442 3 rio.public.temp0000282988 3 rio.public.temp0000283004 2 rio.public.temp0000282537 2 contagem.pg_catalog.pg_shdepend 2 rio.public.temp0000282970 2 rio.public.temp0000282998 2 rio.public.temp0000282874 2 template1.pg_catalog.pg_shdepend 2 contagem.public.temp0000226434 2 rio.public.temp0000282996 2 brasilia.pg_catalog.pg_shdepend 2 rio.public.temp0000282936 1 rio.public.temp0000282966 1 rio.public.temp0000282912 1 contagem.public.temp0000226446 1 rio.public.temp0000282902 1 contagem.public.nf_entrada 1 rio.public.temp0000282914 1 rio.public.temp0000282908 1 rio.public.temp0000282958 1 rio.public.temp0000282922 1 rio.public.temp0000282960 1 rio.public.temp0000282894 1 rio.public.temp0000282900 1 rio.public.tmp_drill_0302 1 rio.public.temp0000282950 1 Total 742 Vacuums per table
Key values
- public.temp0000282890 (44) Main table vacuumed on database rio
- 355 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.public.temp0000282890 44 0 0 0 0 0 0 48,327 1,827 5,031,823 0 0 rio.pg_catalog.pg_attribute 35 32 0 0 0 0 0 17,583 5,220 7,280,118 312 7,808 rio.pg_catalog.pg_class 29 22 0 0 0 0 0 4,133 1,409 1,945,132 98 321 rio.public.temp0000282968 22 0 0 0 0 0 0 23,824 1,665 3,437,888 0 0 contagem.public.usuarios 20 0 0 0 0 0 0 89 63 35,206 0 0 rio.pg_catalog.pg_type 19 19 0 0 0 0 0 1,490 461 588,615 63 235 contagem.pg_catalog.pg_attribute 13 13 0 0 0 0 0 7,761 2,435 4,148,742 30 872 rio.public.temp0000282942 13 0 0 0 0 0 0 19,024 51 1,130,190 0 0 rio.public.temp0000282848 12 0 0 0 0 0 0 1,062 306 470,022 0 0 rio.pg_catalog.pg_index 11 11 0 0 0 0 0 744 168 164,336 42 91 rio.public.temp0000282944 11 0 0 0 0 0 0 11,116 1,622 2,678,307 0 0 rio.public.temp0000282689 9 0 0 0 0 0 0 1,390 54 90,979 0 0 rio.public.temp0000282918 8 0 0 0 0 0 0 11,094 1,611 2,672,911 0 0 rio.pg_catalog.pg_depend 8 8 0 0 0 0 0 2,786 1,049 1,341,963 62 609 rio.public.temp0000282517 7 0 0 0 0 0 0 627 152 227,526 0 0 contagem.pg_catalog.pg_class 7 7 0 0 0 0 0 1,166 329 480,768 13 37 rio.public.temp0000282858 7 0 0 0 0 0 0 1,300 30 81,352 0 0 rio.pg_catalog.pg_statistic 6 6 0 0 0 0 0 8,822 1,749 8,197,897 797 4,518 contagem.public.temp0000226438 6 0 0 0 0 0 0 576 36 39,572 0 0 contagem.pg_catalog.pg_type 5 5 0 0 0 0 0 499 152 218,583 6 16 rio.public.temp0000282980 4 0 0 0 0 0 0 549 202 344,903 0 0 contagem.pg_catalog.pg_depend 4 4 0 0 0 0 0 1,087 347 624,476 8 48 rio.public.temp0000282509 4 0 0 0 0 0 0 244 20 17,750 0 0 rio.public.usuarios 4 4 0 0 0 0 0 139 53 124,579 16 83 rio.public.temp0000282643 4 0 0 0 0 0 0 551 22 35,954 0 0 contagem.pg_catalog.pg_index 4 4 0 0 0 0 0 200 70 54,643 4 6 rio.pg_toast.pg_toast_2619 4 4 0 0 0 0 0 1,898 397 2,139,240 140 462 rio.pg_catalog.pg_shdepend 4 4 0 0 0 0 0 636 208 238,551 50 94 rio.public.temp0000282988 3 0 0 0 0 0 0 1,595 10 95,784 0 0 rio.public.temp0000282896 3 0 0 0 0 0 0 136 11 9,768 0 0 rio.public.tmp_drill_0175 3 2 0 0 0 0 0 70 8 16,489 0 0 rio.public.temp0000282970 2 0 0 0 0 0 0 158 12 11,116 0 0 rio.public.temp0000282996 2 0 0 0 0 0 0 91 11 7,102 0 0 rio.public.temp0000282537 2 0 0 0 0 0 0 3,170 8 188,236 0 0 rio.public.codigos_barra 1 1 0 0 0 0 0 78,287 67,342 324,860,683 257 16,249 rio.public.temp0000282922 1 0 0 0 0 0 0 67 4 4,556 0 0 brasilia.pg_catalog.pg_statistic 1 1 0 0 0 0 0 81 2 7,559 0 0 contagem.auditor.auditor_2026_06 1 0 0 0 0 0 0 25,296 19,633 24,214,215 2,762 48,157 rio.public.equipamentos_referencia 1 0 0 0 0 0 0 137 101 338,419 17 3,145 rio.public.giga_testes 1 1 0 0 0 0 0 21,643 17,479 60,095,874 296 3,040 rio.auditor.auditor_2026_06 1 0 0 0 0 0 0 117,122 64,426 81,539,971 26,353 528,651 rio.public.temp0000282950 1 0 0 0 0 0 0 84 6 5,862 0 0 rio.public.tmp_drill_0302 1 1 0 0 0 0 0 1,129 3 198,829 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 161 35 117,413 8 17 rio.public.caixa_itens_exclusao 1 0 0 0 0 0 0 66 62 208,247 5 354 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,554 711 2,261,087 669 4,727 rio.public.temp0000282902 1 0 0 0 0 0 0 1,586 4 94,177 0 0 contagem.public.temp0000226446 1 0 0 0 0 0 0 96 6 6,596 0 0 rio.public.temp0000282908 1 0 0 0 0 0 0 67 4 4,556 0 0 rio.public.temp0000282914 1 0 0 0 0 0 0 67 4 4,556 0 0 Total 355 151 0 0 0 0 0 422,380 191,590 538,133,121 32,008 619,540 Vacuum throughput per table
Key values
- public.codigos_barra (44.31) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.public.temp0000282890 0 0 1.64 rio.pg_catalog.pg_attribute 0 0 2.53 rio.pg_catalog.pg_class 0 0 0.6 rio.public.temp0000282968 0 0 1.12 contagem.public.usuarios 0 0 0 rio.pg_catalog.pg_type 0 0 0.21 contagem.pg_catalog.pg_attribute 0 0 1.07 rio.public.temp0000282942 0 0 0.98 rio.public.temp0000282848 0 0 0.15 rio.pg_catalog.pg_index 0 0 0.11 rio.public.temp0000282944 0 0 0.6 rio.public.temp0000282689 0 0 0.16 rio.public.temp0000282918 0 0 0.44 rio.pg_catalog.pg_depend 0 0 0.5 rio.public.temp0000282517 0 0 0.1 contagem.pg_catalog.pg_class 0 0 0.19 rio.public.temp0000282858 0 0 0.03 rio.pg_catalog.pg_statistic 0 0 0.92 contagem.public.temp0000226438 0 0 0.08 contagem.pg_catalog.pg_type 0 0 0.06 rio.public.temp0000282980 0 0 0.06 contagem.pg_catalog.pg_depend 0 0 0.19 rio.public.temp0000282509 0 0 0.05 rio.public.usuarios 0 0 0 rio.public.temp0000282643 0 0 0.04 contagem.pg_catalog.pg_index 0 0 0.06 rio.pg_toast.pg_toast_2619 0 0 0.21 rio.pg_catalog.pg_shdepend 0 0 0.09 rio.public.temp0000282988 0 0 0.13 rio.public.temp0000282896 0 0 0 rio.public.tmp_drill_0175 0 0 0 rio.public.temp0000282970 0 0 0.02 rio.public.temp0000282996 0 0 0.02 rio.public.temp0000282537 0 0 0.09 rio.public.codigos_barra 0 0 44.31 rio.public.temp0000282922 0 0 0 brasilia.pg_catalog.pg_statistic 0 0 0 contagem.auditor.auditor_2026_06 0 0 6.36 rio.public.equipamentos_referencia 0 0 0.03 rio.public.giga_testes 0 0 13.83 rio.auditor.auditor_2026_06 0 0 20.81 rio.public.temp0000282950 0 0 0.02 rio.public.tmp_drill_0302 0 0 0.03 contagem.pg_toast.pg_toast_2619 0 0 0.02 rio.public.caixa_itens_exclusao 0 0 0.05 contagem.pg_catalog.pg_statistic 0 0 0.11 rio.public.temp0000282902 0 0 0.05 contagem.public.temp0000226446 0 0 0.01 rio.public.temp0000282908 0 0 0 rio.public.temp0000282914 0 0 0 Total 0 0 98.08 Tuples removed per table
Key values
- pg_catalog.pg_attribute (121684) Main table with removed tuples on database rio
- 229094 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 35 32 121,684 866,607 32,371 168 20,484 contagem.pg_catalog.pg_attribute 13 13 34,428 336,991 0 82 7,660 rio.public.tmp_drill_0302 1 1 17,066 17,066 0 0 428 rio.pg_catalog.pg_statistic 6 6 11,338 50,162 244 0 7,716 rio.pg_catalog.pg_depend 8 8 7,705 153,733 888 0 1,472 rio.pg_catalog.pg_type 19 19 5,162 44,701 1,238 10 1,260 rio.pg_catalog.pg_shdepend 4 4 4,551 34,192 224 0 404 contagem.pg_catalog.pg_statistic 1 1 4,314 7,274 0 0 1,011 rio.public.codigos_barra 1 1 4,242 9,609,480 0 0 65,174 rio.pg_catalog.pg_class 29 22 3,595 112,036 10,603 25 3,764 rio.pg_catalog.pg_index 11 11 3,050 21,289 113 0 649 rio.auditor.auditor_2026_06 1 0 2,648 14,280,721 0 0 677,621 contagem.pg_catalog.pg_depend 4 4 2,418 75,462 0 0 704 contagem.pg_catalog.pg_type 5 5 1,537 11,273 0 9 357 contagem.public.usuarios 20 0 1,212 460 0 0 40 rio.pg_toast.pg_toast_2619 4 4 1,203 2,211 0 0 1,152 contagem.pg_catalog.pg_class 7 7 1,017 24,680 0 0 907 rio.public.giga_testes 1 1 750 3,651,118 43 0 96,850 rio.public.usuarios 4 4 504 2,128 100 0 64 contagem.pg_catalog.pg_index 4 4 315 7,593 0 5 202 brasilia.pg_catalog.pg_statistic 1 1 175 449 0 0 36 contagem.pg_toast.pg_toast_2619 1 1 122 119 0 5 54 rio.public.caixa_itens_exclusao 1 0 58 1,276,043 0 0 10,664 rio.public.temp0000282970 2 0 0 3,023 0 114 142 rio.public.temp0000282922 1 0 0 1,329 0 0 64 rio.public.temp0000282980 4 0 0 30,196 0 63 705 rio.public.temp0000282848 12 0 0 69,855 0 327 1,593 contagem.auditor.auditor_2026_06 1 0 0 2,337,370 0 0 104,418 rio.public.temp0000282890 44 0 0 750,673 0 183 53,513 rio.public.equipamentos_referencia 1 0 0 5,081,710 0 0 27,470 rio.public.temp0000282509 4 0 0 24,975 0 128 576 rio.public.temp0000282996 2 0 0 3,148 0 106 150 rio.public.temp0000282517 7 0 0 32,269 0 235 725 rio.public.temp0000282918 8 0 0 178,312 0 0 12,800 rio.public.temp0000282643 4 0 0 23,085 0 44 532 rio.public.temp0000282944 11 0 0 245,388 0 0 17,600 rio.public.temp0000282988 3 0 0 66,955 0 0 4,800 rio.public.temp0000282950 1 0 0 1,582 0 52 76 rio.public.temp0000282942 13 0 0 289,874 0 0 20,800 rio.public.temp0000282968 22 0 0 490,945 0 0 35,200 rio.public.temp0000282858 7 0 0 55,898 0 20 1,324 rio.public.temp0000282896 3 0 0 3,942 0 0 192 rio.public.temp0000282537 2 0 0 44,607 0 0 3,200 rio.public.temp0000282902 1 0 0 22,308 0 0 1,600 contagem.public.temp0000226446 1 0 0 1,147 0 40 88 rio.public.temp0000282689 9 0 0 58,026 0 346 1,318 rio.public.temp0000282908 1 0 0 1,314 0 0 64 rio.public.temp0000282914 1 0 0 1,317 0 0 64 contagem.public.temp0000226438 6 0 0 6,866 0 240 528 rio.public.tmp_drill_0175 3 2 0 1,558 362 0 32 Total 355 151 229,094 40,413,460 46,186 2,202 1,188,247 Pages removed per table
Key values
- public.temp0000282689 (346) Main table with removed pages on database rio
- 2202 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000282689 9 0 0 346 rio.public.temp0000282848 12 0 0 327 contagem.public.temp0000226438 6 0 0 240 rio.public.temp0000282517 7 0 0 235 rio.public.temp0000282890 44 0 0 183 rio.pg_catalog.pg_attribute 35 32 121684 168 rio.public.temp0000282509 4 0 0 128 rio.public.temp0000282970 2 0 0 114 rio.public.temp0000282996 2 0 0 106 contagem.pg_catalog.pg_attribute 13 13 34428 82 rio.public.temp0000282980 4 0 0 63 rio.public.temp0000282950 1 0 0 52 rio.public.temp0000282643 4 0 0 44 contagem.public.temp0000226446 1 0 0 40 rio.pg_catalog.pg_class 29 22 3595 25 rio.public.temp0000282858 7 0 0 20 rio.pg_catalog.pg_type 19 19 5162 10 contagem.pg_catalog.pg_type 5 5 1537 9 contagem.pg_catalog.pg_index 4 4 315 5 contagem.pg_toast.pg_toast_2619 1 1 122 5 rio.public.codigos_barra 1 1 4242 0 rio.public.temp0000282922 1 0 0 0 rio.pg_catalog.pg_index 11 11 3050 0 contagem.pg_catalog.pg_depend 4 4 2418 0 brasilia.pg_catalog.pg_statistic 1 1 175 0 contagem.auditor.auditor_2026_06 1 0 0 0 rio.public.equipamentos_referencia 1 0 0 0 rio.public.giga_testes 1 1 750 0 rio.auditor.auditor_2026_06 1 0 2648 0 rio.public.usuarios 4 4 504 0 rio.public.temp0000282918 8 0 0 0 rio.public.temp0000282944 11 0 0 0 contagem.pg_catalog.pg_class 7 7 1017 0 rio.public.temp0000282988 3 0 0 0 contagem.public.usuarios 20 0 1212 0 rio.public.tmp_drill_0302 1 1 17066 0 rio.public.temp0000282942 13 0 0 0 rio.public.temp0000282968 22 0 0 0 rio.pg_toast.pg_toast_2619 4 4 1203 0 rio.public.caixa_itens_exclusao 1 0 58 0 rio.pg_catalog.pg_depend 8 8 7705 0 rio.public.temp0000282896 3 0 0 0 rio.pg_catalog.pg_statistic 6 6 11338 0 contagem.pg_catalog.pg_statistic 1 1 4314 0 rio.public.temp0000282537 2 0 0 0 rio.public.temp0000282902 1 0 0 0 rio.public.temp0000282908 1 0 0 0 rio.public.temp0000282914 1 0 0 0 rio.public.tmp_drill_0175 3 2 0 0 rio.pg_catalog.pg_shdepend 4 4 4551 0 Total 355 151 229,094 2,202 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jun 18 00 0 0 01 0 0 02 0 0 03 0 0 04 0 1 05 5 5 06 0 0 07 13 22 08 25 61 09 46 102 10 38 75 11 40 91 12 11 25 13 21 51 14 40 84 15 43 86 16 55 96 17 17 38 18 0 0 19 0 0 20 0 0 21 1 3 22 0 2 23 0 0 - 44.31 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 3,381 Total read queries
- 968 Total write queries
Queries by database
Key values
- rio Main database
- 4,006 Requests
- 6h6m38s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 4,510 Requests
User Request type Count Duration etiquetas Total 5 867ms select 5 867ms intelifix Total 4,510 6h17m11s copy to 278 41m ddl 690 42m38s others 248 24m21s select 3,294 4h29m10s lenon Total 82 1m4s select 82 1m4s Duration by user
Key values
- 6h17m11s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 5 867ms select 5 867ms intelifix Total 4,510 6h17m11s copy to 278 41m ddl 690 42m38s others 248 24m21s select 3,294 4h29m10s lenon Total 82 1m4s select 82 1m4s Queries by host
Key values
- [local] Main host
- 4,597 Requests
- 6h18m16s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 3,894 Requests
- 3h4m47s ([unknown])
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-06-18 23:23:55 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 2,570 100-500ms duration
Slowest individual queries
Rank Duration Query 1 10m27s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-18 22:15:29 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 9m28s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-18 10:14:29 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 8m44s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-18 07:13:46 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 8m38s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-18 15:13:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 8m7s analyze verbose;[ Date: 2026-06-18 05:08:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 7m35s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-18 09:12:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 7m31s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-18 16:12:32 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 6m46s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-18 11:11:47 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 6m31s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-18 20:11:33 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 6m26s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-18 14:11:28 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 6m19s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-18 17:11:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 6m15s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-18 12:11:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 5m54s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-18 13:10:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m43s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-18 18:10:45 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m41s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-18 21:10:43 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m38s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-18 08:10:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m31s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-18 19:10:32 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 4m27s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025831, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-06-18 16:16:47 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 4m25s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025823, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-06-18 15:05:55 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 4m24s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025821, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-06-18 14:56:42 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1h53m50s 32 1s148ms 10m27s 3m33s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 18 07 2 8m47s 4m23s 08 2 5m39s 2m49s 09 2 7m38s 3m49s 10 2 9m32s 4m46s 11 2 6m48s 3m24s 12 2 6m17s 3m8s 13 2 5m55s 2m57s 14 2 6m29s 3m14s 15 2 8m40s 4m20s 16 2 7m32s 3m46s 17 2 6m21s 3m10s 18 2 5m44s 2m52s 19 2 5m32s 2m46s 20 2 6m34s 3m17s 21 2 5m42s 2m51s 22 2 10m33s 5m16s [ User: intelifix - Total duration: 1h53m50s - Times executed: 32 ]
[ Application: psql - Total duration: 1h53m50s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-18 22:15:29 Duration: 10m27s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-18 10:14:29 Duration: 9m28s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-18 07:13:46 Duration: 8m44s Database: rio User: intelifix Remote: [local] Application: psql
2 1h43m34s 167 150ms 4m27s 37s211ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 18 07 8 15m46s 1m58s 08 9 11m28s 1m16s 09 16 11m42s 43s914ms 10 13 5m52s 27s142ms 11 15 7m55s 31s694ms 12 3 4m36s 1m32s 13 11 13s244ms 1s204ms 14 23 16m53s 44s76ms 15 26 13m30s 31s169ms 16 23 12m40s 33s56ms 17 20 2m53s 8s681ms [ User: intelifix - Total duration: 1h43m34s - Times executed: 167 ]
[ Application: [unknown] - Total duration: 1h43m34s - Times executed: 167 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025831, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-18 16:16:47 Duration: 4m27s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025823, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-18 15:05:55 Duration: 4m25s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025821, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-18 14:56:42 Duration: 4m24s Database: rio User: intelifix Remote: [local] Application: [unknown]
3 18m19s 102 8s508ms 31s497ms 10s779ms create table temp0000282890 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 18 07 17 3m2s 10s730ms 08 12 2m12s 11s12ms 09 12 2m8s 10s687ms 10 8 1m29s 11s182ms 11 6 1m1s 10s170ms 12 6 1m 10s146ms 14 21 3m36s 10s321ms 15 8 1m34s 11s837ms 16 12 2m13s 11s154ms [ User: intelifix - Total duration: 18m19s - Times executed: 102 ]
[ Application: [unknown] - Total duration: 18m19s - Times executed: 102 ]
-
CREATE TABLE temp0000282890 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-18 07:17:16 Duration: 31s497ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282890 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-18 08:55:06 Duration: 14s303ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282890 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-18 08:54:22 Duration: 14s250ms Database: rio User: intelifix Remote: [local] Application: [unknown]
4 13m53s 1,085 150ms 4s363ms 768ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 18 07 12 9s924ms 827ms 08 85 1m10s 826ms 09 191 2m32s 800ms 10 131 1m41s 776ms 11 129 1m49s 846ms 12 22 19s109ms 868ms 13 48 40s179ms 837ms 14 147 1m38s 672ms 15 154 1m48s 705ms 16 117 1m32s 790ms 17 49 29s948ms 611ms [ User: intelifix - Total duration: 13m53s - Times executed: 1085 ]
[ Application: [unknown] - Total duration: 13m53s - Times executed: 1085 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (42756, 407, '833237934003009,230020906888,229989745261,230034439612,229975035363,229991300004,230045050424,230015021320,229981799615,229981427479,229990702639,229971435068,230022284868,230005537071,229981451220,229981822850,230027749711,230006661739,230007767188,229966093144,229974580314,230032963138,230027188084,229989210406,230014689514,230006686061,230049683737,230042259006,230045132328,229981443239,229990641219,230030619901,229990428189,230022320102,229981809515,230034499820,230034392234,230030627982,230035377896,229991358392,230034436783,229974206483,230006662648', '',0295,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-18 16:57:54 Duration: 4s363ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (42622, 413, '226400554247', '',0172,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-18 08:51:03 Duration: 4s325ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (253912, 504, '834348950001445,241645907684,241619418791,241730730206,241707038891,241691521127,241667896284,241658648704,241645675159,241650518796,241645875964,241673602543,241638189614,241732841927,241663179808,241730730913,241709276787,241651621520,241691381012,241706458397,241709377178,241657216173,241652048182,241630882021,241700359800,241649521416,241638366376,241595379005,241635409006,241667812943,241677430010,241658537278,241616240615,241603389506,241689292121,241620599097,241732919308,241710913131,241707096271,241658484243,241602914050', '',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-06-18 08:45:15 Duration: 4s180ms Database: rio User: intelifix Remote: [local] Application: [unknown]
5 12m56s 33 19s739ms 46s141ms 23s538ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 18 08 2 1m6s 33s443ms 09 3 1m6s 22s29ms 10 1 24s368ms 24s368ms 11 3 1m3s 21s317ms 13 3 1m9s 23s110ms 14 4 1m21s 20s445ms 15 6 2m24s 24s123ms 16 6 2m33s 25s643ms 17 5 1m45s 21s151ms [ User: intelifix - Total duration: 12m56s - Times executed: 33 ]
[ Application: [unknown] - Total duration: 12m56s - Times executed: 33 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-17', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-18 08:50:30 Duration: 46s141ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-18', 0366, '', '', 0, 6, '2026-06-01');
Date: 2026-06-18 16:19:42 Duration: 30s302ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-18', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-18 16:20:49 Duration: 29s402ms Database: rio User: intelifix Remote: [local] Application: [unknown]
6 10m39s 32 339ms 1m7s 19s980ms select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 18 07 2 1m1s 30s586ms 08 2 29s487ms 14s743ms 09 2 45s345ms 22s672ms 10 2 53s972ms 26s986ms 11 2 35s2ms 17s501ms 12 2 31s992ms 15s996ms 13 2 30s732ms 15s366ms 14 2 35s962ms 17s981ms 15 2 40s146ms 20s73ms 16 2 39s317ms 19s658ms 17 2 30s26ms 15s13ms 18 2 32s298ms 16s149ms 19 2 27s821ms 13s910ms 20 2 45s404ms 22s702ms 21 2 31s916ms 15s958ms 22 2 1m8s 34s394ms [ User: intelifix - Total duration: 10m39s - Times executed: 32 ]
[ Application: psql - Total duration: 10m39s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-18 22:16:37 Duration: 1m7s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-18 07:14:46 Duration: 1m Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-18 10:15:21 Duration: 52s705ms Database: rio User: intelifix Remote: [local] Application: psql
7 10m20s 3 362ms 8m7s 3m26s analyze verbose;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 18 05 3 10m20s 3m26s [ User: intelifix - Total duration: 10m20s - Times executed: 3 ]
[ Application: psql - Total duration: 10m20s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-06-18 05:08:09 Duration: 8m7s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-18 05:10:21 Duration: 2m12s Database: contagem User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-18 05:08:09 Duration: 362ms Database: brasilia User: intelifix Remote: [local] Application: psql
8 7m 1,034 150ms 2s17ms 406ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 18 07 41 19s318ms 471ms 08 188 1m25s 454ms 09 163 1m 373ms 10 175 1m12s 414ms 11 128 43s273ms 338ms 13 103 43s725ms 424ms 14 59 24s815ms 420ms 15 88 37s704ms 428ms 16 85 30s744ms 361ms 17 4 1s714ms 428ms [ User: intelifix - Total duration: 7m - Times executed: 1034 ]
[ Application: [unknown] - Total duration: 7m - Times executed: 1034 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "255455", "modelo" : "464", "itens" : "241776507680,241759982735,241765141028,241762619311,241744258709,241764049595,241747432038,241765368097,241746374650,241742802742,241769271835,241765608098,241765407899,241765311729,241764657489,241744531216,241742829916,241742207576,241768952331,241764083741,241747375971,241740752138,241759930508,241761026888,241762850928,241765401637,241747453151,241762491521,241762845977,241742307889,241759818599,241744779499,241762639414,241744714769,241747238910,241765488490,241759916970,241744775358,241759939700,241747486363,241745711724,241740807294,241762851736,241777893136,241765062232,241742818602,241765510716,241768043443,241745662830,241746650716,241747452848,241759922022,241744323339,241742827087,241747326471,241768927378,241747392539,241759662749,241776685476,241759816478", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-18 10:17:20 Duration: 2s17ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "255357", "modelo" : "320", "itens" : "241690168503,241731101432,241669946787,241708334058,241716689698,241629295861,241711414650,241655540511,241694463142,241694582424,241631824851,241679165375,241673051625,241657146469,241671939406,241667984351,241706745070,241694575779,241694594041,241635965659,241671553050,241708838608,241682739102,241676783246,241629325157,241651104062,241656983951,241712139704,241631410008,241717152124,241646260324,241715038304,230048414051,241630725260,241730294248,241637802730,241694330728,241592870018,241651281027,241617753860,241592887493,241631403441,241712144452,241660087676,241731875558,241608996686,241703466074,241677631421", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-18 10:20:44 Duration: 1s965ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "255456", "modelo" : "320", "itens" : "241646643548,241668131313,241649851426,241658119202,241706599398,241668726174,241657162431,241651744259,241716676465,241620338993,241709629504,241668301936,241706619704,241598595873,241677374044,241672108995,241672099095,241730313139,241619716374,241668694959,241667781223,241634558585,241675630822,241617831320,241699848202,241732101922,241731028797,241680376570,241732151018,241708354868,241651665463,241694281127,241675578795,241727379205,241658067883,241646125158,241708525165,241675829000,241727085158,241709791518,241615596275,241708530419,241673274856,241730302027,241694573961,241657152531,241666445267,241709748910", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-18 10:19:40 Duration: 1s546ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 6m57s 137 2s225ms 10s98ms 3s49ms call rs_giga_triagem (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 18 00 6 23s773ms 3s962ms 01 6 16s317ms 2s719ms 02 6 17s484ms 2s914ms 03 6 15s317ms 2s552ms 04 6 15s548ms 2s591ms 05 6 16s76ms 2s679ms 06 6 17s458ms 2s909ms 07 6 16s184ms 2s697ms 08 6 19s237ms 3s206ms 09 6 20s667ms 3s444ms 10 6 18s655ms 3s109ms 11 6 19s60ms 3s176ms 12 6 17s257ms 2s876ms 13 6 18s974ms 3s162ms 14 6 17s276ms 2s879ms 15 6 18s127ms 3s21ms 16 6 17s671ms 2s945ms 17 6 17s364ms 2s894ms 18 6 17s514ms 2s919ms 19 6 16s489ms 2s748ms 20 6 23s329ms 3s888ms 21 5 21s579ms 4s315ms 22 6 16s379ms 2s729ms [ User: intelifix - Total duration: 6m57s - Times executed: 137 ]
[ Application: psql - Total duration: 6m57s - Times executed: 137 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-18 21:45:12 Duration: 10s98ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-18 00:05:22 Duration: 9s143ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-18 20:05:10 Duration: 7s799ms Database: rio User: intelifix Remote: [local] Application: psql
10 5m46s 100 207ms 11s907ms 3s463ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 18 00 6 18s145ms 3s24ms 01 6 8s769ms 1s461ms 02 5 5s751ms 1s150ms 03 5 8s388ms 1s677ms 04 6 8s135ms 1s355ms 05 5 10s896ms 2s179ms 06 3 5s261ms 1s753ms 07 6 36s810ms 6s135ms 08 6 37s842ms 6s307ms 09 6 44s417ms 7s402ms 10 6 35s95ms 5s849ms 11 6 33s892ms 5s648ms 12 6 26s21ms 4s336ms 13 2 2s809ms 1s404ms 14 6 20s481ms 3s413ms 15 6 19s118ms 3s186ms 16 5 8s428ms 1s685ms 20 1 223ms 223ms 21 3 8s178ms 2s726ms 22 5 7s661ms 1s532ms [ User: intelifix - Total duration: 5m46s - Times executed: 100 ]
[ Application: psql - Total duration: 5m46s - Times executed: 100 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-18 00:05:13 Duration: 11s907ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-18 08:25:10 Duration: 8s736ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-18 07:25:09 Duration: 8s571ms Database: rio User: intelifix Remote: [local] Application: psql
11 5m33s 32 8s959ms 12s946ms 10s425ms create table temp0000282968 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 18 13 1 10s425ms 10s425ms 14 6 1m3s 10s504ms 15 9 1m38s 10s927ms 16 11 1m52s 10s218ms 17 5 49s395ms 9s879ms [ User: intelifix - Total duration: 5m33s - Times executed: 32 ]
[ Application: [unknown] - Total duration: 5m33s - Times executed: 32 ]
-
CREATE TABLE temp0000282968 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-18 14:59:20 Duration: 12s946ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282968 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-18 15:43:39 Duration: 12s200ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282968 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-18 15:00:20 Duration: 12s130ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 3m39s 22 8s604ms 11s415ms 9s966ms create table temp0000282942 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 18 10 1 10s709ms 10s709ms 11 18 3m 10s5ms 12 3 28s470ms 9s490ms [ User: intelifix - Total duration: 3m39s - Times executed: 22 ]
[ Application: [unknown] - Total duration: 3m39s - Times executed: 22 ]
-
CREATE TABLE temp0000282942 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-18 11:09:55 Duration: 11s415ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282942 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-18 11:19:24 Duration: 11s338ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282942 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-18 11:19:03 Duration: 11s295ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 3m5s 2 1m30s 1m34s 1m32s 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 Jun 18 20 1 1m34s 1m34s 23 1 1m30s 1m30s [ User: intelifix - Total duration: 3m5s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 3m5s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-18 20:08:52 Duration: 1m34s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-18 23:40:32 Duration: 1m30s Database: rio User: intelifix Remote: [local] Application: pg_dump
14 2m43s 15 8s631ms 14s212ms 10s875ms create table temp0000282944 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 18 11 7 1m11s 10s161ms 15 8 1m31s 11s499ms [ User: intelifix - Total duration: 2m43s - Times executed: 15 ]
[ Application: [unknown] - Total duration: 2m43s - Times executed: 15 ]
-
CREATE TABLE temp0000282944 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-18 15:22:32 Duration: 14s212ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282944 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-18 15:24:03 Duration: 13s98ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282944 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-18 15:23:36 Duration: 12s688ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 2m33s 14 8s776ms 15s288ms 10s941ms create table temp0000282918 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 18 09 7 1m21s 11s633ms 10 7 1m11s 10s250ms [ User: intelifix - Total duration: 2m33s - Times executed: 14 ]
[ Application: [unknown] - Total duration: 2m33s - Times executed: 14 ]
-
CREATE TABLE temp0000282918 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-18 09:41:05 Duration: 15s288ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282918 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-18 09:41:22 Duration: 14s720ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282918 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-18 10:11:03 Duration: 11s215ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 2m14s 2 22s979ms 1m51s 1m7s copy auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 18 23 2 2m14s 1m7s [ User: intelifix - Total duration: 2m14s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m14s - Times executed: 2 ]
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-18 23:14:34 Duration: 1m51s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-18 23:42:12 Duration: 22s979ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
17 2m7s 2 1m1s 1m6s 1m3s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 18 20 1 1m6s 1m6s 23 1 1m1s 1m1s [ User: intelifix - Total duration: 2m7s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m7s - Times executed: 2 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-18 20:05:35 Duration: 1m6s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-18 23:19:07 Duration: 1m1s Database: rio User: intelifix Remote: [local] Application: pg_dump
18 1m48s 2 23s148ms 1m25s 54s466ms copy auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 18 23 2 1m48s 54s466ms [ User: intelifix - Total duration: 1m48s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m48s - Times executed: 2 ]
-
COPY auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-18 23:11:29 Duration: 1m25s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-18 23:41:28 Duration: 23s148ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
19 1m42s 58 161ms 42s95ms 1s759ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 18 07 6 3s8ms 501ms 08 4 2s419ms 604ms 09 7 11s256ms 1s608ms 10 4 44s964ms 11s241ms 11 8 16s763ms 2s95ms 12 3 5s44ms 1s681ms 13 2 1s109ms 554ms 14 9 4s126ms 458ms 15 6 2s648ms 441ms 16 7 8s550ms 1s221ms 17 2 2s183ms 1s91ms [ User: intelifix - Total duration: 1m42s - Times executed: 58 ]
[ Application: psql - Total duration: 1m42s - Times executed: 58 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025796);
Date: 2026-06-18 10:11:23 Duration: 42s95ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025808);
Date: 2026-06-18 11:53:54 Duration: 7s259ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025795);
Date: 2026-06-18 09:49:27 Duration: 4s307ms Database: rio User: intelifix Remote: [local] Application: psql
20 1m33s 2 20s947ms 1m12s 46s934ms copy auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 18 23 2 1m33s 46s934ms [ User: intelifix - Total duration: 1m33s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m33s - Times executed: 2 ]
-
COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-18 23:12:42 Duration: 1m12s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-18 23:41:49 Duration: 20s947ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,085 13m53s 150ms 4s363ms 768ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 18 07 12 9s924ms 827ms 08 85 1m10s 826ms 09 191 2m32s 800ms 10 131 1m41s 776ms 11 129 1m49s 846ms 12 22 19s109ms 868ms 13 48 40s179ms 837ms 14 147 1m38s 672ms 15 154 1m48s 705ms 16 117 1m32s 790ms 17 49 29s948ms 611ms [ User: intelifix - Total duration: 13m53s - Times executed: 1085 ]
[ Application: [unknown] - Total duration: 13m53s - Times executed: 1085 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (42756, 407, '833237934003009,230020906888,229989745261,230034439612,229975035363,229991300004,230045050424,230015021320,229981799615,229981427479,229990702639,229971435068,230022284868,230005537071,229981451220,229981822850,230027749711,230006661739,230007767188,229966093144,229974580314,230032963138,230027188084,229989210406,230014689514,230006686061,230049683737,230042259006,230045132328,229981443239,229990641219,230030619901,229990428189,230022320102,229981809515,230034499820,230034392234,230030627982,230035377896,229991358392,230034436783,229974206483,230006662648', '',0295,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-18 16:57:54 Duration: 4s363ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (42622, 413, '226400554247', '',0172,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-18 08:51:03 Duration: 4s325ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (253912, 504, '834348950001445,241645907684,241619418791,241730730206,241707038891,241691521127,241667896284,241658648704,241645675159,241650518796,241645875964,241673602543,241638189614,241732841927,241663179808,241730730913,241709276787,241651621520,241691381012,241706458397,241709377178,241657216173,241652048182,241630882021,241700359800,241649521416,241638366376,241595379005,241635409006,241667812943,241677430010,241658537278,241616240615,241603389506,241689292121,241620599097,241732919308,241710913131,241707096271,241658484243,241602914050', '',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-06-18 08:45:15 Duration: 4s180ms Database: rio User: intelifix Remote: [local] Application: [unknown]
2 1,034 7m 150ms 2s17ms 406ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 18 07 41 19s318ms 471ms 08 188 1m25s 454ms 09 163 1m 373ms 10 175 1m12s 414ms 11 128 43s273ms 338ms 13 103 43s725ms 424ms 14 59 24s815ms 420ms 15 88 37s704ms 428ms 16 85 30s744ms 361ms 17 4 1s714ms 428ms [ User: intelifix - Total duration: 7m - Times executed: 1034 ]
[ Application: [unknown] - Total duration: 7m - Times executed: 1034 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "255455", "modelo" : "464", "itens" : "241776507680,241759982735,241765141028,241762619311,241744258709,241764049595,241747432038,241765368097,241746374650,241742802742,241769271835,241765608098,241765407899,241765311729,241764657489,241744531216,241742829916,241742207576,241768952331,241764083741,241747375971,241740752138,241759930508,241761026888,241762850928,241765401637,241747453151,241762491521,241762845977,241742307889,241759818599,241744779499,241762639414,241744714769,241747238910,241765488490,241759916970,241744775358,241759939700,241747486363,241745711724,241740807294,241762851736,241777893136,241765062232,241742818602,241765510716,241768043443,241745662830,241746650716,241747452848,241759922022,241744323339,241742827087,241747326471,241768927378,241747392539,241759662749,241776685476,241759816478", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-18 10:17:20 Duration: 2s17ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "255357", "modelo" : "320", "itens" : "241690168503,241731101432,241669946787,241708334058,241716689698,241629295861,241711414650,241655540511,241694463142,241694582424,241631824851,241679165375,241673051625,241657146469,241671939406,241667984351,241706745070,241694575779,241694594041,241635965659,241671553050,241708838608,241682739102,241676783246,241629325157,241651104062,241656983951,241712139704,241631410008,241717152124,241646260324,241715038304,230048414051,241630725260,241730294248,241637802730,241694330728,241592870018,241651281027,241617753860,241592887493,241631403441,241712144452,241660087676,241731875558,241608996686,241703466074,241677631421", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-18 10:20:44 Duration: 1s965ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "255456", "modelo" : "320", "itens" : "241646643548,241668131313,241649851426,241658119202,241706599398,241668726174,241657162431,241651744259,241716676465,241620338993,241709629504,241668301936,241706619704,241598595873,241677374044,241672108995,241672099095,241730313139,241619716374,241668694959,241667781223,241634558585,241675630822,241617831320,241699848202,241732101922,241731028797,241680376570,241732151018,241708354868,241651665463,241694281127,241675578795,241727379205,241658067883,241646125158,241708525165,241675829000,241727085158,241709791518,241615596275,241708530419,241673274856,241730302027,241694573961,241657152531,241666445267,241709748910", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-18 10:19:40 Duration: 1s546ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 167 1h43m34s 150ms 4m27s 37s211ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 18 07 8 15m46s 1m58s 08 9 11m28s 1m16s 09 16 11m42s 43s914ms 10 13 5m52s 27s142ms 11 15 7m55s 31s694ms 12 3 4m36s 1m32s 13 11 13s244ms 1s204ms 14 23 16m53s 44s76ms 15 26 13m30s 31s169ms 16 23 12m40s 33s56ms 17 20 2m53s 8s681ms [ User: intelifix - Total duration: 1h43m34s - Times executed: 167 ]
[ Application: [unknown] - Total duration: 1h43m34s - Times executed: 167 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025831, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-18 16:16:47 Duration: 4m27s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025823, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-18 15:05:55 Duration: 4m25s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025821, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-18 14:56:42 Duration: 4m24s Database: rio User: intelifix Remote: [local] Application: [unknown]
4 137 6m57s 2s225ms 10s98ms 3s49ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 18 00 6 23s773ms 3s962ms 01 6 16s317ms 2s719ms 02 6 17s484ms 2s914ms 03 6 15s317ms 2s552ms 04 6 15s548ms 2s591ms 05 6 16s76ms 2s679ms 06 6 17s458ms 2s909ms 07 6 16s184ms 2s697ms 08 6 19s237ms 3s206ms 09 6 20s667ms 3s444ms 10 6 18s655ms 3s109ms 11 6 19s60ms 3s176ms 12 6 17s257ms 2s876ms 13 6 18s974ms 3s162ms 14 6 17s276ms 2s879ms 15 6 18s127ms 3s21ms 16 6 17s671ms 2s945ms 17 6 17s364ms 2s894ms 18 6 17s514ms 2s919ms 19 6 16s489ms 2s748ms 20 6 23s329ms 3s888ms 21 5 21s579ms 4s315ms 22 6 16s379ms 2s729ms [ User: intelifix - Total duration: 6m57s - Times executed: 137 ]
[ Application: psql - Total duration: 6m57s - Times executed: 137 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-18 21:45:12 Duration: 10s98ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-18 00:05:22 Duration: 9s143ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-18 20:05:10 Duration: 7s799ms Database: rio User: intelifix Remote: [local] Application: psql
5 121 23s2ms 150ms 321ms 190ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 18 04 10 1s986ms 198ms 05 19 3s841ms 202ms 07 16 3s253ms 203ms 08 10 1s942ms 194ms 09 10 1s810ms 181ms 10 15 2s771ms 184ms 11 11 1s869ms 169ms 12 7 1s134ms 162ms 14 8 1s446ms 180ms 15 12 2s372ms 197ms 16 3 573ms 191ms [ User: intelifix - Total duration: 23s2ms - Times executed: 121 ]
[ Application: [unknown] - Total duration: 23s2ms - Times executed: 121 ]
-
SELECT * FROM RS_TRIAGEM (402, 5, '113', 3, '216825863841,216566891519,216890620016,216854755067,216768175259,216848216168,216670082039,216665285476,216882556781', NULL, NULL, 064, 00);
Date: 2026-06-18 07:02:35 Duration: 321ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (405, 5, '113', 3, '216599640922,216579716687,216746222848,216469436575,216385744760,216715458082,216569961527,184296526772,184297596888,216716236980,216774915771', NULL, NULL, 034, 00);
Date: 2026-06-18 15:24:43 Duration: 312ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '241645524763,241672728608,241726140409,241660544646,241709107376,241658317683,241630022431,241706764062,241646629405,241593154646,241673266673,241657081638,241651249508,241619605656,241694278803,241699351128,241606173246,241598139106,241655198502,241729507796', NULL, NULL, 0320, 00);
Date: 2026-06-18 04:46:56 Duration: 306ms Database: rio User: intelifix Remote: [local] Application: [unknown]
6 102 18m19s 8s508ms 31s497ms 10s779ms create table temp0000282890 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 18 07 17 3m2s 10s730ms 08 12 2m12s 11s12ms 09 12 2m8s 10s687ms 10 8 1m29s 11s182ms 11 6 1m1s 10s170ms 12 6 1m 10s146ms 14 21 3m36s 10s321ms 15 8 1m34s 11s837ms 16 12 2m13s 11s154ms [ User: intelifix - Total duration: 18m19s - Times executed: 102 ]
[ Application: [unknown] - Total duration: 18m19s - Times executed: 102 ]
-
CREATE TABLE temp0000282890 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-18 07:17:16 Duration: 31s497ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282890 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-18 08:55:06 Duration: 14s303ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282890 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-18 08:54:22 Duration: 14s250ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 100 5m46s 207ms 11s907ms 3s463ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 18 00 6 18s145ms 3s24ms 01 6 8s769ms 1s461ms 02 5 5s751ms 1s150ms 03 5 8s388ms 1s677ms 04 6 8s135ms 1s355ms 05 5 10s896ms 2s179ms 06 3 5s261ms 1s753ms 07 6 36s810ms 6s135ms 08 6 37s842ms 6s307ms 09 6 44s417ms 7s402ms 10 6 35s95ms 5s849ms 11 6 33s892ms 5s648ms 12 6 26s21ms 4s336ms 13 2 2s809ms 1s404ms 14 6 20s481ms 3s413ms 15 6 19s118ms 3s186ms 16 5 8s428ms 1s685ms 20 1 223ms 223ms 21 3 8s178ms 2s726ms 22 5 7s661ms 1s532ms [ User: intelifix - Total duration: 5m46s - Times executed: 100 ]
[ Application: psql - Total duration: 5m46s - Times executed: 100 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-18 00:05:13 Duration: 11s907ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-18 08:25:10 Duration: 8s736ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-18 07:25:09 Duration: 8s571ms Database: rio User: intelifix Remote: [local] Application: psql
8 82 13s284ms 150ms 255ms 162ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 18 04 1 154ms 154ms 05 2 322ms 161ms 07 1 160ms 160ms 08 10 1s620ms 162ms 09 18 2s881ms 160ms 10 14 2s269ms 162ms 11 5 803ms 160ms 12 3 502ms 167ms 13 2 305ms 152ms 14 7 1s98ms 156ms 15 7 1s155ms 165ms 16 11 1s835ms 166ms 17 1 172ms 172ms [ User: intelifix - Total duration: 13s284ms - Times executed: 82 ]
[ Application: [unknown] - Total duration: 13s284ms - Times executed: 82 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 034;
Date: 2026-06-18 16:02:19 Duration: 255ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 039;
Date: 2026-06-18 15:34:26 Duration: 198ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 064;
Date: 2026-06-18 12:14:44 Duration: 198ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 80 38s177ms 154ms 1s826ms 477ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 18 10 11 6s226ms 566ms 11 5 3s402ms 680ms 13 8 4s997ms 624ms 14 10 4s874ms 487ms 15 11 7s47ms 640ms 16 8 3s138ms 392ms 17 27 8s491ms 314ms [ User: intelifix - Total duration: 38s177ms - Times executed: 80 ]
[ Application: [unknown] - Total duration: 38s177ms - Times executed: 80 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0255328) LIMIT 1;
Date: 2026-06-18 15:25:50 Duration: 1s826ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0255355) LIMIT 1;
Date: 2026-06-18 15:42:27 Duration: 1s738ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0255355) LIMIT 1;
Date: 2026-06-18 14:42:26 Duration: 1s717ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 77 34s352ms 263ms 844ms 446ms select pro_id, pgp_sym_decrypt(nome, ?)::varchar, pgp_sym_decrypt(descricao, ?)::varchar, pgp_sym_decrypt(classe, ?)::varchar, pgp_sym_decrypt(php, ?)::varchar, pgp_sym_decrypt(extras, ?)::varchar from progs order by pro_id;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 18 04 1 343ms 343ms 05 3 1s337ms 445ms 06 1 430ms 430ms 07 5 1s814ms 362ms 08 7 3s131ms 447ms 09 7 3s211ms 458ms 10 7 3s618ms 516ms 11 7 3s43ms 434ms 12 4 1s409ms 352ms 13 6 2s937ms 489ms 14 7 3s170ms 452ms 15 8 4s26ms 503ms 16 7 3s134ms 447ms 17 3 1s32ms 344ms 21 2 844ms 422ms 22 2 863ms 431ms [ User: lenon - Total duration: 34s352ms - Times executed: 77 ]
[ Application: [unknown] - Total duration: 34s352ms - Times executed: 77 ]
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-06-18 11:26:09 Duration: 844ms Database: contagem User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-06-18 10:25:11 Duration: 813ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-06-18 13:26:36 Duration: 731ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
11 71 39s310ms 327ms 922ms 553ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 18 04 1 479ms 479ms 05 3 1s640ms 546ms 07 4 1s909ms 477ms 08 7 3s906ms 558ms 09 7 3s873ms 553ms 10 7 4s373ms 624ms 11 7 3s778ms 539ms 12 4 1s793ms 448ms 13 6 3s619ms 603ms 14 6 3s377ms 562ms 15 7 4s282ms 611ms 16 7 3s680ms 525ms 17 3 1s423ms 474ms 22 2 1s173ms 586ms [ User: intelifix - Total duration: 39s310ms - Times executed: 71 ]
[ Application: [unknown] - Total duration: 39s310ms - Times executed: 71 ]
-
select * from rs_menu_grants (418, 18, 1);
Date: 2026-06-18 11:26:09 Duration: 922ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (502, 19, 1);
Date: 2026-06-18 10:25:11 Duration: 890ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (320, 21, 1);
Date: 2026-06-18 13:26:36 Duration: 887ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 67 18s912ms 152ms 1s506ms 282ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 18 08 11 2s357ms 214ms 09 14 3s7ms 214ms 10 6 1s676ms 279ms 11 4 1s78ms 269ms 15 20 8s474ms 423ms 16 9 1s752ms 194ms 17 3 565ms 188ms [ User: intelifix - Total duration: 18s912ms - Times executed: 67 ]
[ Application: [unknown] - Total duration: 18s912ms - Times executed: 67 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 1, 7, '229987734560,230026185372,229991179711,230035389413,230032370522,230026093141,230014028608,230023112132,229976975777,230029455253,230044200307,230026078694,229971243355,230027067489,229963747583,230005306768,230041962333,230053987288,229986997080,230035275866,230053250820,230052649010,230027749105,230042112527,229977050106,230006169816,229975675358,230031583542,230029274248,230010851721,229972458287,230022071335,230006875373,230029339103,229989600422,230044509304,230006237577,229967338406,230044317893,230014069396,230023271216,230041928894,230029987381,230047278698,230006222223,230028041233,230014230121,229977360619,230006242124,230041984961,230012023339,230053243849,230035416890,230052862241,230032827490,230041990316,230009757079,230009992838,230014093440,230050900916,229988789904,229989534758,230042131620,229987836466,230044168484,229977376276,229966019196,230044196568,230031528182,230028705472,230007887985,229977676283,230023095059,229977443859,230044117997,229968275657,230035301728,230026241416,229989679294,230042229710,230029147591,229988711940,230034786671,229975193437,230015031927,229967864551,229975191518,230044480211,230006336173,230035611332,229977320716,229968299497,230027616162,230027491527,230044151436,229987852125', '113;1', 'DEFAULT', 00, 0295, '','', '', 00);
Date: 2026-06-18 15:22:49 Duration: 1s506ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 1, 7, '230013461123,229953213245,229958018090,229946876262,229925780108,229936927693,229948949898,230003635876,229995866666,230008612636,229962295556,229950399603,229931619712,229957877089,230002516485,229954698484,229953229307,229926597594,230013622833,229906811231,229992700814,229963955763,230008775558,230000657089,229948862540,230008741919,229952753245,229995734656,229949410708,229954864057,229958659904,229937052431,230003216082,230000784049,229996242843,229931017677,229926614263,230009123752,229926526981,230002908195,229959122733,229947326183,229995840324,229995725766,230013627984,230008823442,229948049496,230013529210,229996842531,230000746368,230012412648,229945644762,229936903045,229995867979,229954865774,229958660309,229995716977,229958400003,229930223246,229928720810,230008831120,229936882033,229946388909,229998032838,229935593456', '113;1', 'DEFAULT', 00, 0287, '','', '', 00);
Date: 2026-06-18 15:31:22 Duration: 981ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (373, 5, 3, 7, '230053987288,229986997080,230041962333,230005306768,229963747583,230027067489,229971243355,230026078694,230044200307,230029455253,230023112132,229976975777,230014028608,230026093141,230032370522,230035389413,229991179711,230026185372,229987734560,230029274248,230031583542,229975675358,230006169816,229977050106,230042112527,230027749105,230052649010,230053250820,230035275866,229977360619,230006242124,230014230121,230028041233,230006222223,230047278698,230029987381,230041928894,230023271216,230014069396,229967338406,230044317893,230006237577,230044509304,229989600422,230029339103,230006875373,230022071335,229972458287,230010851721,230014093440,230050900916,230009992838,230009757079,230041990316,230032827490,230052862241,230035416890,230053243849,230012023339,230041984961,230028705472,230044196568,230031528182,229966019196,229977376276,230044168484,229987836466,230042131620,229989534758,229988789904,229989679294,230026241416,230035301728,229968275657,230044117997,229977443859,230023095059,229977676283,230007887985,230006336173,230035611332,230044480211,229975191518,229967864551,230015031927,229975193437,230034786671,229988711940,230029147591,230042229710,229987852125,230044151436,230027491527,230027616162,229968299497,229977320716', '','DEFAULT',00,0295,'', '','', 00);
Date: 2026-06-18 15:24:43 Duration: 855ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 64 24s680ms 232ms 616ms 385ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 18 07 4 1s349ms 337ms 08 4 1s311ms 327ms 09 9 4s194ms 466ms 10 5 1s991ms 398ms 11 10 3s781ms 378ms 12 1 456ms 456ms 13 3 1s244ms 414ms 14 9 3s3ms 333ms 15 8 3s59ms 382ms 16 6 2s463ms 410ms 17 5 1s824ms 364ms [ User: intelifix - Total duration: 24s680ms - Times executed: 64 ]
[ Application: [unknown] - Total duration: 24s680ms - Times executed: 64 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-06-18 15:05:42 Duration: 616ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 085;
Date: 2026-06-18 09:24:44 Duration: 610ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-06-18 09:00:30 Duration: 580ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 64 10s837ms 150ms 281ms 169ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 18 04 1 207ms 207ms 08 1 170ms 170ms 11 1 173ms 173ms 13 4 714ms 178ms 14 8 1s275ms 159ms 15 18 3s67ms 170ms 16 27 4s532ms 167ms 17 4 695ms 173ms [ User: intelifix - Total duration: 10s837ms - Times executed: 64 ]
[ Application: [unknown] - Total duration: 10s837ms - Times executed: 64 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "395", "data-de" : "2026-06-18", "data-ate" : "2026-06-18", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 449 }');
Date: 2026-06-18 15:18:21 Duration: 281ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "364", "data-de" : "2026-06-18", "data-ate" : "2026-06-18", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 416 }');
Date: 2026-06-18 13:45:05 Duration: 240ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "398", "data-de" : "2026-06-18", "data-ate" : "2026-06-18", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 452 }');
Date: 2026-06-18 16:09:47 Duration: 237ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 61 11s848ms 150ms 405ms 194ms select * from rs_lote_manutencao (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 18 08 3 916ms 305ms 09 4 1s275ms 318ms 10 1 256ms 256ms 11 1 272ms 272ms 13 9 1s488ms 165ms 14 10 1s887ms 188ms 15 13 2s333ms 179ms 16 12 2s60ms 171ms 17 8 1s358ms 169ms [ User: intelifix - Total duration: 11s848ms - Times executed: 61 ]
[ Application: [unknown] - Total duration: 11s848ms - Times executed: 61 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"189", "usuario" :"507", "tipo" :"N", "itens" :"005", "nota-fiscal" :"1563", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-06-18 09:40:27 Duration: 405ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"298", "usuario" :"507", "tipo" :"N", "itens" :"005", "nota-fiscal" :"1563", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-06-18 08:21:43 Duration: 330ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"318", "usuario" :"507", "tipo" :"N", "itens" :"001", "nota-fiscal" :"1563", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-06-18 09:13:31 Duration: 326ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 58 1m42s 161ms 42s95ms 1s759ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 18 07 6 3s8ms 501ms 08 4 2s419ms 604ms 09 7 11s256ms 1s608ms 10 4 44s964ms 11s241ms 11 8 16s763ms 2s95ms 12 3 5s44ms 1s681ms 13 2 1s109ms 554ms 14 9 4s126ms 458ms 15 6 2s648ms 441ms 16 7 8s550ms 1s221ms 17 2 2s183ms 1s91ms [ User: intelifix - Total duration: 1m42s - Times executed: 58 ]
[ Application: psql - Total duration: 1m42s - Times executed: 58 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025796);
Date: 2026-06-18 10:11:23 Duration: 42s95ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025808);
Date: 2026-06-18 11:53:54 Duration: 7s259ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025795);
Date: 2026-06-18 09:49:27 Duration: 4s307ms Database: rio User: intelifix Remote: [local] Application: psql
17 56 14s128ms 151ms 456ms 252ms create table temp0000282535 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 18 08 10 2s90ms 209ms 09 12 2s793ms 232ms 10 8 1s813ms 226ms 11 5 1s210ms 242ms 12 4 1s162ms 290ms 13 1 247ms 247ms 14 7 1s834ms 262ms 15 8 2s663ms 332ms 16 1 313ms 313ms [ User: intelifix - Total duration: 14s128ms - Times executed: 56 ]
[ Application: [unknown] - Total duration: 14s128ms - Times executed: 56 ]
-
CREATE TABLE temp0000282535 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"13-06-2026", "ate" :"18-06-2026", "nota-fiscal":"68571", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-18 15:45:20 Duration: 456ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282535 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"13-06-2026", "ate" :"18-06-2026", "nota-fiscal":"68571", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-18 15:21:00 Duration: 437ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282535 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"13-06-2026", "ate" :"18-06-2026", "nota-fiscal":"68571", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-18 12:21:49 Duration: 418ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 42 11s378ms 153ms 3s267ms 270ms create table temp0000282898 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 18 07 1 3s267ms 3s267ms 08 3 519ms 173ms 09 13 2s374ms 182ms 10 12 2s535ms 211ms 11 11 2s340ms 212ms 12 2 341ms 170ms [ User: intelifix - Total duration: 11s378ms - Times executed: 42 ]
[ Application: [unknown] - Total duration: 11s378ms - Times executed: 42 ]
-
CREATE TABLE temp0000282898 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"13-06-2026", "ate" :"18-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-18 07:55:53 Duration: 3s267ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282898 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"13-06-2026", "ate" :"18-06-2026", "nota-fiscal":"1525", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-18 11:28:46 Duration: 321ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282898 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"13-06-2026", "ate" :"18-06-2026", "nota-fiscal":"1525", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-18 10:31:14 Duration: 260ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 37 1m1s 151ms 7s919ms 1s663ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 18 07 4 12s16ms 3s4ms 08 3 4s220ms 1s406ms 09 6 6s969ms 1s161ms 10 4 7s615ms 1s903ms 11 6 5s504ms 917ms 12 2 4s505ms 2s252ms 14 5 8s951ms 1s790ms 15 3 5s598ms 1s866ms 16 4 6s186ms 1s546ms [ User: intelifix - Total duration: 1m1s - Times executed: 37 ]
[ Application: psql - Total duration: 1m1s - Times executed: 37 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (025780);
Date: 2026-06-18 07:18:40 Duration: 7s919ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (025816);
Date: 2026-06-18 14:23:29 Duration: 5s576ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (025811);
Date: 2026-06-18 12:25:03 Duration: 4s256ms Database: rio User: intelifix Remote: [local] Application: psql
20 33 12m56s 19s739ms 46s141ms 23s538ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 18 08 2 1m6s 33s443ms 09 3 1m6s 22s29ms 10 1 24s368ms 24s368ms 11 3 1m3s 21s317ms 13 3 1m9s 23s110ms 14 4 1m21s 20s445ms 15 6 2m24s 24s123ms 16 6 2m33s 25s643ms 17 5 1m45s 21s151ms [ User: intelifix - Total duration: 12m56s - Times executed: 33 ]
[ Application: [unknown] - Total duration: 12m56s - Times executed: 33 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-17', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-18 08:50:30 Duration: 46s141ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-18', 0366, '', '', 0, 6, '2026-06-01');
Date: 2026-06-18 16:19:42 Duration: 30s302ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-18', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-18 16:20:49 Duration: 29s402ms 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 1s148ms 10m27s 3m33s 32 1h53m50s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 18 07 2 8m47s 4m23s 08 2 5m39s 2m49s 09 2 7m38s 3m49s 10 2 9m32s 4m46s 11 2 6m48s 3m24s 12 2 6m17s 3m8s 13 2 5m55s 2m57s 14 2 6m29s 3m14s 15 2 8m40s 4m20s 16 2 7m32s 3m46s 17 2 6m21s 3m10s 18 2 5m44s 2m52s 19 2 5m32s 2m46s 20 2 6m34s 3m17s 21 2 5m42s 2m51s 22 2 10m33s 5m16s [ User: intelifix - Total duration: 1h53m50s - Times executed: 32 ]
[ Application: psql - Total duration: 1h53m50s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-18 22:15:29 Duration: 10m27s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-18 10:14:29 Duration: 9m28s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-18 07:13:46 Duration: 8m44s Database: rio User: intelifix Remote: [local] Application: psql
2 362ms 8m7s 3m26s 3 10m20s analyze verbose;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 18 05 3 10m20s 3m26s [ User: intelifix - Total duration: 10m20s - Times executed: 3 ]
[ Application: psql - Total duration: 10m20s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-06-18 05:08:09 Duration: 8m7s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-18 05:10:21 Duration: 2m12s Database: contagem User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-18 05:08:09 Duration: 362ms Database: brasilia User: intelifix Remote: [local] Application: psql
3 1m30s 1m34s 1m32s 2 3m5s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 18 20 1 1m34s 1m34s 23 1 1m30s 1m30s [ User: intelifix - Total duration: 3m5s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 3m5s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-18 20:08:52 Duration: 1m34s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-18 23:40:32 Duration: 1m30s Database: rio User: intelifix Remote: [local] Application: pg_dump
4 22s979ms 1m51s 1m7s 2 2m14s copy auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 18 23 2 2m14s 1m7s [ User: intelifix - Total duration: 2m14s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m14s - Times executed: 2 ]
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-18 23:14:34 Duration: 1m51s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-18 23:42:12 Duration: 22s979ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
5 1m1s 1m6s 1m3s 2 2m7s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 18 20 1 1m6s 1m6s 23 1 1m1s 1m1s [ User: intelifix - Total duration: 2m7s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m7s - Times executed: 2 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-18 20:05:35 Duration: 1m6s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-18 23:19:07 Duration: 1m1s Database: rio User: intelifix Remote: [local] Application: pg_dump
6 23s148ms 1m25s 54s466ms 2 1m48s copy auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 18 23 2 1m48s 54s466ms [ User: intelifix - Total duration: 1m48s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m48s - Times executed: 2 ]
-
COPY auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-18 23:11:29 Duration: 1m25s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-18 23:41:28 Duration: 23s148ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
7 20s947ms 1m12s 46s934ms 2 1m33s copy auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 18 23 2 1m33s 46s934ms [ User: intelifix - Total duration: 1m33s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m33s - Times executed: 2 ]
-
COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-18 23:12:42 Duration: 1m12s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-18 23:41:49 Duration: 20s947ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
8 150ms 4m27s 37s211ms 167 1h43m34s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 18 07 8 15m46s 1m58s 08 9 11m28s 1m16s 09 16 11m42s 43s914ms 10 13 5m52s 27s142ms 11 15 7m55s 31s694ms 12 3 4m36s 1m32s 13 11 13s244ms 1s204ms 14 23 16m53s 44s76ms 15 26 13m30s 31s169ms 16 23 12m40s 33s56ms 17 20 2m53s 8s681ms [ User: intelifix - Total duration: 1h43m34s - Times executed: 167 ]
[ Application: [unknown] - Total duration: 1h43m34s - Times executed: 167 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025831, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-18 16:16:47 Duration: 4m27s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025823, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-18 15:05:55 Duration: 4m25s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025821, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-18 14:56:42 Duration: 4m24s Database: rio User: intelifix Remote: [local] Application: [unknown]
9 19s739ms 46s141ms 23s538ms 33 12m56s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 18 08 2 1m6s 33s443ms 09 3 1m6s 22s29ms 10 1 24s368ms 24s368ms 11 3 1m3s 21s317ms 13 3 1m9s 23s110ms 14 4 1m21s 20s445ms 15 6 2m24s 24s123ms 16 6 2m33s 25s643ms 17 5 1m45s 21s151ms [ User: intelifix - Total duration: 12m56s - Times executed: 33 ]
[ Application: [unknown] - Total duration: 12m56s - Times executed: 33 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-17', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-18 08:50:30 Duration: 46s141ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-18', 0366, '', '', 0, 6, '2026-06-01');
Date: 2026-06-18 16:19:42 Duration: 30s302ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-18', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-18 16:20:49 Duration: 29s402ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 339ms 1m7s 19s980ms 32 10m39s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 18 07 2 1m1s 30s586ms 08 2 29s487ms 14s743ms 09 2 45s345ms 22s672ms 10 2 53s972ms 26s986ms 11 2 35s2ms 17s501ms 12 2 31s992ms 15s996ms 13 2 30s732ms 15s366ms 14 2 35s962ms 17s981ms 15 2 40s146ms 20s73ms 16 2 39s317ms 19s658ms 17 2 30s26ms 15s13ms 18 2 32s298ms 16s149ms 19 2 27s821ms 13s910ms 20 2 45s404ms 22s702ms 21 2 31s916ms 15s958ms 22 2 1m8s 34s394ms [ User: intelifix - Total duration: 10m39s - Times executed: 32 ]
[ Application: psql - Total duration: 10m39s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-18 22:16:37 Duration: 1m7s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-18 07:14:46 Duration: 1m Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-18 10:15:21 Duration: 52s705ms Database: rio User: intelifix Remote: [local] Application: psql
11 8s776ms 15s288ms 10s941ms 14 2m33s create table temp0000282918 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 18 09 7 1m21s 11s633ms 10 7 1m11s 10s250ms [ User: intelifix - Total duration: 2m33s - Times executed: 14 ]
[ Application: [unknown] - Total duration: 2m33s - Times executed: 14 ]
-
CREATE TABLE temp0000282918 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-18 09:41:05 Duration: 15s288ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282918 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-18 09:41:22 Duration: 14s720ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282918 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-18 10:11:03 Duration: 11s215ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 8s631ms 14s212ms 10s875ms 15 2m43s create table temp0000282944 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 18 11 7 1m11s 10s161ms 15 8 1m31s 11s499ms [ User: intelifix - Total duration: 2m43s - Times executed: 15 ]
[ Application: [unknown] - Total duration: 2m43s - Times executed: 15 ]
-
CREATE TABLE temp0000282944 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-18 15:22:32 Duration: 14s212ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282944 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-18 15:24:03 Duration: 13s98ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282944 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-18 15:23:36 Duration: 12s688ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 8s508ms 31s497ms 10s779ms 102 18m19s create table temp0000282890 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 18 07 17 3m2s 10s730ms 08 12 2m12s 11s12ms 09 12 2m8s 10s687ms 10 8 1m29s 11s182ms 11 6 1m1s 10s170ms 12 6 1m 10s146ms 14 21 3m36s 10s321ms 15 8 1m34s 11s837ms 16 12 2m13s 11s154ms [ User: intelifix - Total duration: 18m19s - Times executed: 102 ]
[ Application: [unknown] - Total duration: 18m19s - Times executed: 102 ]
-
CREATE TABLE temp0000282890 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-18 07:17:16 Duration: 31s497ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282890 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-18 08:55:06 Duration: 14s303ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282890 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-18 08:54:22 Duration: 14s250ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 8s959ms 12s946ms 10s425ms 32 5m33s create table temp0000282968 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 18 13 1 10s425ms 10s425ms 14 6 1m3s 10s504ms 15 9 1m38s 10s927ms 16 11 1m52s 10s218ms 17 5 49s395ms 9s879ms [ User: intelifix - Total duration: 5m33s - Times executed: 32 ]
[ Application: [unknown] - Total duration: 5m33s - Times executed: 32 ]
-
CREATE TABLE temp0000282968 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-18 14:59:20 Duration: 12s946ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282968 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-18 15:43:39 Duration: 12s200ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282968 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-18 15:00:20 Duration: 12s130ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 8s604ms 11s415ms 9s966ms 22 3m39s create table temp0000282942 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 18 10 1 10s709ms 10s709ms 11 18 3m 10s5ms 12 3 28s470ms 9s490ms [ User: intelifix - Total duration: 3m39s - Times executed: 22 ]
[ Application: [unknown] - Total duration: 3m39s - Times executed: 22 ]
-
CREATE TABLE temp0000282942 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-18 11:09:55 Duration: 11s415ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282942 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-18 11:19:24 Duration: 11s338ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000282942 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-18 11:19:03 Duration: 11s295ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 207ms 11s907ms 3s463ms 100 5m46s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 18 00 6 18s145ms 3s24ms 01 6 8s769ms 1s461ms 02 5 5s751ms 1s150ms 03 5 8s388ms 1s677ms 04 6 8s135ms 1s355ms 05 5 10s896ms 2s179ms 06 3 5s261ms 1s753ms 07 6 36s810ms 6s135ms 08 6 37s842ms 6s307ms 09 6 44s417ms 7s402ms 10 6 35s95ms 5s849ms 11 6 33s892ms 5s648ms 12 6 26s21ms 4s336ms 13 2 2s809ms 1s404ms 14 6 20s481ms 3s413ms 15 6 19s118ms 3s186ms 16 5 8s428ms 1s685ms 20 1 223ms 223ms 21 3 8s178ms 2s726ms 22 5 7s661ms 1s532ms [ User: intelifix - Total duration: 5m46s - Times executed: 100 ]
[ Application: psql - Total duration: 5m46s - Times executed: 100 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-18 00:05:13 Duration: 11s907ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-18 08:25:10 Duration: 8s736ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-18 07:25:09 Duration: 8s571ms Database: rio User: intelifix Remote: [local] Application: psql
17 2s225ms 10s98ms 3s49ms 137 6m57s call rs_giga_triagem (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 18 00 6 23s773ms 3s962ms 01 6 16s317ms 2s719ms 02 6 17s484ms 2s914ms 03 6 15s317ms 2s552ms 04 6 15s548ms 2s591ms 05 6 16s76ms 2s679ms 06 6 17s458ms 2s909ms 07 6 16s184ms 2s697ms 08 6 19s237ms 3s206ms 09 6 20s667ms 3s444ms 10 6 18s655ms 3s109ms 11 6 19s60ms 3s176ms 12 6 17s257ms 2s876ms 13 6 18s974ms 3s162ms 14 6 17s276ms 2s879ms 15 6 18s127ms 3s21ms 16 6 17s671ms 2s945ms 17 6 17s364ms 2s894ms 18 6 17s514ms 2s919ms 19 6 16s489ms 2s748ms 20 6 23s329ms 3s888ms 21 5 21s579ms 4s315ms 22 6 16s379ms 2s729ms [ User: intelifix - Total duration: 6m57s - Times executed: 137 ]
[ Application: psql - Total duration: 6m57s - Times executed: 137 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-18 21:45:12 Duration: 10s98ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-18 00:05:22 Duration: 9s143ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-18 20:05:10 Duration: 7s799ms Database: rio User: intelifix Remote: [local] Application: psql
18 161ms 42s95ms 1s759ms 58 1m42s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 18 07 6 3s8ms 501ms 08 4 2s419ms 604ms 09 7 11s256ms 1s608ms 10 4 44s964ms 11s241ms 11 8 16s763ms 2s95ms 12 3 5s44ms 1s681ms 13 2 1s109ms 554ms 14 9 4s126ms 458ms 15 6 2s648ms 441ms 16 7 8s550ms 1s221ms 17 2 2s183ms 1s91ms [ User: intelifix - Total duration: 1m42s - Times executed: 58 ]
[ Application: psql - Total duration: 1m42s - Times executed: 58 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025796);
Date: 2026-06-18 10:11:23 Duration: 42s95ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025808);
Date: 2026-06-18 11:53:54 Duration: 7s259ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025795);
Date: 2026-06-18 09:49:27 Duration: 4s307ms Database: rio User: intelifix Remote: [local] Application: psql
19 151ms 7s919ms 1s663ms 37 1m1s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 18 07 4 12s16ms 3s4ms 08 3 4s220ms 1s406ms 09 6 6s969ms 1s161ms 10 4 7s615ms 1s903ms 11 6 5s504ms 917ms 12 2 4s505ms 2s252ms 14 5 8s951ms 1s790ms 15 3 5s598ms 1s866ms 16 4 6s186ms 1s546ms [ User: intelifix - Total duration: 1m1s - Times executed: 37 ]
[ Application: psql - Total duration: 1m1s - Times executed: 37 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (025780);
Date: 2026-06-18 07:18:40 Duration: 7s919ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (025816);
Date: 2026-06-18 14:23:29 Duration: 5s576ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (025811);
Date: 2026-06-18 12:25:03 Duration: 4s256ms Database: rio User: intelifix Remote: [local] Application: psql
20 150ms 4s363ms 768ms 1,085 13m53s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 18 07 12 9s924ms 827ms 08 85 1m10s 826ms 09 191 2m32s 800ms 10 131 1m41s 776ms 11 129 1m49s 846ms 12 22 19s109ms 868ms 13 48 40s179ms 837ms 14 147 1m38s 672ms 15 154 1m48s 705ms 16 117 1m32s 790ms 17 49 29s948ms 611ms [ User: intelifix - Total duration: 13m53s - Times executed: 1085 ]
[ Application: [unknown] - Total duration: 13m53s - Times executed: 1085 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (42756, 407, '833237934003009,230020906888,229989745261,230034439612,229975035363,229991300004,230045050424,230015021320,229981799615,229981427479,229990702639,229971435068,230022284868,230005537071,229981451220,229981822850,230027749711,230006661739,230007767188,229966093144,229974580314,230032963138,230027188084,229989210406,230014689514,230006686061,230049683737,230042259006,230045132328,229981443239,229990641219,230030619901,229990428189,230022320102,229981809515,230034499820,230034392234,230030627982,230035377896,229991358392,230034436783,229974206483,230006662648', '',0295,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-18 16:57:54 Duration: 4s363ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (42622, 413, '226400554247', '',0172,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-18 08:51:03 Duration: 4s325ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (253912, 504, '834348950001445,241645907684,241619418791,241730730206,241707038891,241691521127,241667896284,241658648704,241645675159,241650518796,241645875964,241673602543,241638189614,241732841927,241663179808,241730730913,241709276787,241651621520,241691381012,241706458397,241709377178,241657216173,241652048182,241630882021,241700359800,241649521416,241638366376,241595379005,241635409006,241667812943,241677430010,241658537278,241616240615,241603389506,241689292121,241620599097,241732919308,241710913131,241707096271,241658484243,241602914050', '',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-06-18 08:45:15 Duration: 4s180ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 2 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jun 18 19 1 0ms 0ms 20 1 0ms 0ms [ User: intelifix - Total duration: 5m31s - Times executed: 2 ]
[ Application: psql - Total duration: 5m31s - Times executed: 2 ]
-
;
Date: Duration: 0ms Database: postgres User: rio Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 14,728 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 20 FATAL entries
- 3470 ERROR entries
- 0 WARNING entries
- 2 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 2,656 Max number of times the same event was reported
- 3,492 Total events found
Rank Times reported Error 1 2,656 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jun 18 07 231 08 283 09 437 10 366 11 321 12 145 13 81 14 252 15 360 16 156 17 24 - ERROR: prepared statement "_PLAN000000002C36AE90" does not exist
- ERROR: prepared statement "_PLAN000000002BAD3390" does not exist
- ERROR: prepared statement "_PLAN000000002BAD3390" does not exist
Statement: DEALLOCATE "_PLAN000000002C36AE90"
Date: 2026-06-18 07:07:58 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN000000002BAD3390"
Date: 2026-06-18 07:07:59 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN000000002BAD3390"
Date: 2026-06-18 07:08:27 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 189 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #2
Day Hour Count Jun 18 07 19 08 48 09 40 10 29 11 3 12 6 14 23 15 21 - ERROR: trailing junk after numeric literal at or near "8A" at character 36
- ERROR: trailing junk after numeric literal at or near "8A" at character 36
- ERROR: trailing junk after numeric literal at or near "8A" at character 36
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-8A-B7-D8)
Date: 2026-06-18 07:09:18 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-8A-B7-D8)
Date: 2026-06-18 07:09:18 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-8A-B7-D8)
Date: 2026-06-18 07:09:18 Database: rio Application: [unknown] User: etiquetas Remote: [local]
3 140 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count Jun 18 07 12 08 30 09 30 10 3 11 9 12 18 14 3 15 35 - ERROR: column "dc" does not exist at character 27
- ERROR: column "dc" does not exist at character 27
- ERROR: column "dc" does not exist at character 27
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-A2-92-39)
Date: 2026-06-18 07:11:00 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-A2-92-39)
Date: 2026-06-18 07:11:00 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-A2-92-39)
Date: 2026-06-18 07:11:00 Database: rio Application: [unknown] User: etiquetas Remote: [local]
4 137 ERROR: procedure rs_giga_processa_arquivos() does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Jun 18 00 6 01 6 02 6 03 6 04 6 05 6 06 6 07 6 08 6 09 6 10 6 11 6 12 6 13 6 14 6 15 6 16 6 17 6 18 6 19 6 20 6 21 5 22 6 - ERROR: procedure rs_giga_processa_arquivos() does not exist at character 6
- ERROR: procedure rs_giga_processa_arquivos() does not exist at character 6
- ERROR: procedure rs_giga_processa_arquivos() does not exist at character 6
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_PROCESSA_ARQUIVOS()Date: 2026-06-18 00:05:22 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_PROCESSA_ARQUIVOS()Date: 2026-06-18 00:15:07 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_PROCESSA_ARQUIVOS()Date: 2026-06-18 00:25:04 Database: brasilia Application: psql User: intelifix Remote: [local]
5 137 ERROR: procedure rs_giga_triagem(...) does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Jun 18 00 6 01 6 02 6 03 6 04 6 05 6 06 6 07 6 08 6 09 6 10 6 11 6 12 6 13 6 14 6 15 6 16 6 17 6 18 6 19 6 20 6 21 5 22 6 - ERROR: procedure rs_giga_triagem(unknown) does not exist at character 6
- ERROR: procedure rs_giga_triagem(unknown) does not exist at character 6
- ERROR: procedure rs_giga_triagem(unknown) does not exist at character 6
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-06-18 00:05:22 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-06-18 00:15:07 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-06-18 00:25:04 Database: brasilia Application: psql User: intelifix Remote: [local]
6 45 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #6
Day Hour Count Jun 18 08 3 09 3 10 3 11 3 12 3 13 3 14 3 15 3 16 3 17 3 18 3 19 3 20 3 21 3 22 3 - ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
Detail: Character with value 0x09 must be escaped.
Context: JSON data, line 22503: "nrSerie":"ZTEEH7VM1L08287... PL/pgSQL function rs_resumo_tcia(integer) line 139 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-18 08:00:26 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Character with value 0x09 must be escaped.
Context: JSON data, line 22503: "nrSerie":"ZTEEH7VM1L08287... PL/pgSQL function rs_resumo_tcia(integer) line 139 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-18 08:20:07 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Character with value 0x09 must be escaped.
Context: JSON data, line 22503: "nrSerie":"ZTEEH7VM1L08287... PL/pgSQL function rs_resumo_tcia(integer) line 139 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-18 08:40:05 Database: rio Application: psql User: intelifix Remote: [local]
7 45 ERROR: procedure rs_tcia_processa_lotes() does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Jun 18 08 3 09 3 10 3 11 3 12 3 13 3 14 3 15 3 16 3 17 3 18 3 19 3 20 3 21 3 22 3 - ERROR: procedure rs_tcia_processa_lotes() does not exist at character 6
- ERROR: procedure rs_tcia_processa_lotes() does not exist at character 6
- ERROR: procedure rs_tcia_processa_lotes() does not exist at character 6
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-18 08:00:26 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-18 08:20:07 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-18 08:40:05 Database: brasilia Application: psql User: intelifix Remote: [local]
8 45 ERROR: procedure rs_giga_tecnicos() does not exist
Times Reported Most Frequent Error / Event #8
Day Hour Count Jun 18 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 1 22 2 - ERROR: procedure rs_giga_tecnicos() does not exist at character 6
- ERROR: procedure rs_giga_tecnicos() does not exist at character 6
- ERROR: procedure rs_giga_tecnicos() does not exist at character 6
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-06-18 00:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-06-18 00:35:01 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-06-18 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
9 18 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #9
Day Hour Count Jun 18 08 1 09 2 10 4 11 3 12 4 15 1 16 3 - ERROR: syntax error at or near "11722085850043009869" at character 32
- ERROR: syntax error at or near ":" at character 32
- ERROR: syntax error at or near ":" at character 32
Statement: SELECT RS_SERIAL_TEMPORARIO( ''11722085850043009869' ) OR RS_SERIAL_TEMPORARIO_VIVO( ''11722085850043009869' )
Date: 2026-06-18 08:23:07 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: select * from rs_caixa_qr(https://a2techcon.ddns.net/recepcao_lote_carrega.php$1lote=42701&erro=&itens=0#:~:text=Carregados%201%20%2D%3E%3E%20Caixa-,110729,-Dados%20do%20Lote)
Date: 2026-06-18 09:59:01 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(https://a2techcon.ddns.net/recepcao_lote_carrega.php$1lote=42701&erro=&itens=0#:~:text=Carregados%201%20%2D%3E%3E%20Caixa-,110729,-Dados%20do%20Lote)
Date: 2026-06-18 09:59:01 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
10 16 ERROR: function rs_smart_fiscal_entrada() does not exist
Times Reported Most Frequent Error / Event #10
Day Hour Count Jun 18 07 1 08 1 09 1 10 1 11 1 12 1 13 1 14 1 15 1 16 1 17 1 18 1 19 1 20 1 21 1 22 1 - ERROR: function rs_smart_fiscal_entrada() does not exist at character 15
- ERROR: function rs_smart_fiscal_entrada() does not exist at character 15
- ERROR: function rs_smart_fiscal_entrada() does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_SMART_FISCAL_ENTRADA()Date: 2026-06-18 07:14:46 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_SMART_FISCAL_ENTRADA()Date: 2026-06-18 08:11:09 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_SMART_FISCAL_ENTRADA()Date: 2026-06-18 09:13:22 Database: brasilia Application: psql User: intelifix Remote: [local]
11 16 ERROR: function rs_smart_fiscal_saida() does not exist
Times Reported Most Frequent Error / Event #11
Day Hour Count Jun 18 07 1 08 1 09 1 10 1 11 1 12 1 13 1 14 1 15 1 16 1 17 1 18 1 19 1 20 1 21 1 22 1 - ERROR: function rs_smart_fiscal_saida() does not exist at character 15
- ERROR: function rs_smart_fiscal_saida() does not exist at character 15
- ERROR: function rs_smart_fiscal_saida() does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_SMART_FISCAL_SAIDA()Date: 2026-06-18 07:14:46 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_SMART_FISCAL_SAIDA()Date: 2026-06-18 08:11:09 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_SMART_FISCAL_SAIDA()Date: 2026-06-18 09:13:22 Database: brasilia Application: psql User: intelifix Remote: [local]
12 12 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #12
Day Hour Count Jun 18 03 5 21 7 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-06-18 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-18 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-18 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
13 12 ERROR: invalid binary integer at or near "..."
Times Reported Most Frequent Error / Event #13
Day Hour Count Jun 18 08 6 15 6 - ERROR: invalid binary integer at or near "0B" at character 42
- ERROR: invalid binary integer at or near "0B" at character 42
- ERROR: invalid binary integer at or near "0B" at character 42
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-98-B6-0B)
Date: 2026-06-18 08:11:39 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-98-B6-0B)
Date: 2026-06-18 08:11:39 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-98-B6-0B)
Date: 2026-06-18 08:11:39 Database: rio Application: [unknown] User: etiquetas Remote: [local]
14 8 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #14
Day Hour Count Jun 18 05 8 - ERROR: relation "public.equipamentos" does not exist at character 49
- ERROR: relation "public.equipamentos" does not exist
- ERROR: relation "public.codigos_barra" does not exist at character 70
Statement: DECLARE c1 CURSOR FOR SELECT eq_id, mod_id FROM public.equipamentos
Date: 2026-06-18 05:30:01 Database: brasilia Application: postgres_fdw User: lenon Remote: 127.0.0.1
Context: remote SQL command: SELECT eq_id, mod_id FROM public.equipamentos
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;Date: 2026-06-18 05:30:01 Database: rio Application: psql User: intelifix Remote: [local]
Statement: DECLARE c1 CURSOR FOR SELECT eq_id, eq_seq, eq_codigo, eq_extra FROM public.codigos_barra
Date: 2026-06-18 05:30:01 Database: brasilia Application: postgres_fdw User: lenon Remote: 127.0.0.1
15 6 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #15
Day Hour Count Jun 18 00 1 06 1 11 1 21 3 - FATAL: database "testes" does not exist
- FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-06-18 00:02:15 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-06-18 06:02:15 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-06-18 11:52:14 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
16 3 ERROR: procedure rs_atualiza_estoque_automatico() does not exist
Times Reported Most Frequent Error / Event #16
Day Hour Count Jun 18 00 1 06 1 21 1 - ERROR: procedure rs_atualiza_estoque_automatico() does not exist at character 6
- ERROR: procedure rs_atualiza_estoque_automatico() does not exist at character 6
- ERROR: procedure rs_atualiza_estoque_automatico() does not exist at character 6
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO()Date: 2026-06-18 00:05:20 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO()Date: 2026-06-18 06:05:10 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO()Date: 2026-06-18 21:39:31 Database: brasilia Application: psql User: intelifix Remote: [local]
17 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #17
Day Hour Count Jun 18 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-06-18 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-18 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
18 2 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #18
Day Hour Count Jun 18 03 1 21 1 - LOG: database system was shut down at 2026-06-18 03:05:01 -03
- LOG: database system was shut down at 2026-06-18 21:34:05 -03
Date: 2026-06-18 03:05:02
Date: 2026-06-18 21:39:18
19 1 ERROR: unterminated quoted string at or near "..."
Times Reported Most Frequent Error / Event #19
Day Hour Count Jun 18 15 1 - ERROR: unterminated quoted string at or near "'229958431723'');" at character 39
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA('229958431723'');
Date: 2026-06-18 15:19:45 Database: rio Application: [unknown] User: intelifix Remote: [local]
20 1 ERROR: function rs_lote_entrada_fechar_automatico() does not exist
Times Reported Most Frequent Error / Event #20
Day Hour Count Jun 18 18 1 - ERROR: function rs_lote_entrada_fechar_automatico() does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_LOTE_ENTRADA_FECHAR_AUTOMATICO() /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn(Date: 2026-06-18 18:00:02 Database: brasilia Application: psql User: intelifix Remote: [local]
21 1 ERROR: function rs_del_temporario() does not exist
Times Reported Most Frequent Error / Event #21
Day Hour Count Jun 18 21 1 - ERROR: function rs_del_temporario() does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_DEL_TEMPORARIO()Date: 2026-06-18 21:25:01 Database: brasilia Application: psql User: intelifix Remote: [local]