pgBadger-
Global information
- Generated on Thu Jul 2 23:50:13 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 51,824 log entries in 12s
- Log start from 2026-07-02 00:00:53 to 2026-07-02 23:50:09
-
Overview
Global Stats
- 444 Number of unique normalized queries
- 7,642 Number of queries
- 8h11m45s Total query duration
- 2026-07-02 00:02:02 First query
- 2026-07-02 23:48:40 Last query
- 5 queries/s at 2026-07-02 12:08:28 Query peak
- 8h11m45s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 8h11m45s Execute total duration
- 5,019 Number of events
- 23 Number of unique normalized events
- 4,854 Max number of times the same event was reported
- 0 Number of cancellation
- 524 Total number of automatic vacuums
- 1,186 Total number of automatic analyzes
- 36 Number temporary file
- 232.94 MiB Max size of temporary file
- 105.20 MiB Average size of temporary file
- 411 Total number of sessions
- 8 sessions at 2026-07-02 09:02:17 Session peak
- 13d21h43m36s Total duration of sessions
- 48m43s Average duration of sessions
- 18 Average queries per session
- 1m11s Average queries duration per session
- 47m31s Average idle time per session
- 409 Total number of connections
- 7 connections/s at 2026-07-02 03:05:16 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-07-02 12:08:28 Date
SELECT Traffic
Key values
- 5 queries/s Query Peak
- 2026-07-02 12:08:28 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-07-02 23:48:27 Date
Queries duration
Key values
- 8h11m45s 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) Jul 02 00 33 0ms 18s272ms 2s973ms 3s782ms 4s673ms 1m10s 01 36 0ms 2s585ms 805ms 3s400ms 4s134ms 5s877ms 02 16 0ms 2s522ms 1s401ms 2s545ms 4s297ms 5s32ms 03 27 0ms 8s505ms 1s347ms 3s307ms 4s574ms 10s371ms 04 26 0ms 3s1ms 1s46ms 3s116ms 4s118ms 5s734ms 05 25 0ms 8m5s 39s20ms 4s135ms 2m5s 8m5s 06 27 0ms 10s716ms 2s74ms 2s707ms 4s607ms 31s584ms 07 163 0ms 7m42s 10s42ms 48s12ms 4m7s 7m45s 08 475 150ms 6m16s 3s142ms 38s963ms 3m25s 6m54s 09 821 150ms 8m32s 3s341ms 1m18s 5m14s 8m37s 10 719 150ms 8m14s 2s825ms 1m16s 4m42s 8m29s 11 748 150ms 8m10s 2s611ms 44s768ms 4m56s 8m23s 12 268 0ms 7m25s 4s126ms 20s625ms 1m23s 7m45s 13 629 0ms 6m16s 2s271ms 45s317ms 1m47s 6m48s 14 991 150ms 8m2s 3s531ms 4m37s 5m4s 10m21s 15 802 150ms 8m4s 2s892ms 1m21s 5m3s 8m54s 16 800 150ms 7m47s 3s111ms 1m14s 4m36s 12m50s 17 491 0ms 7m51s 2s995ms 50s513ms 1m14s 8m14s 18 30 0ms 5m36s 20s716ms 3s634ms 47s125ms 5m36s 19 16 0ms 5m43s 38s127ms 3s54ms 44s73ms 5m43s 20 109 0ms 6m22s 11s672ms 1m8s 2m20s 6m59s 21 29 0ms 6m3s 21s946ms 3s928ms 5s648ms 6m50s 22 22 0ms 6m8s 29s113ms 3s976ms 4s973ms 6m53s 23 339 0ms 1m30s 6s806ms 1m8s 1m27s 2m16s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 02 00 12 0 376ms 0ms 384ms 1s296ms 01 18 0 293ms 157ms 312ms 1s68ms 02 0 0 0ms 0ms 0ms 0ms 03 8 0 440ms 0ms 0ms 1s194ms 04 10 0 232ms 0ms 203ms 338ms 05 3 0 411ms 0ms 0ms 160ms 06 6 0 513ms 0ms 0ms 874ms 07 101 0 13s495ms 2s112ms 32s35ms 4m46s 08 348 0 3s280ms 5s610ms 17s291ms 4m17s 09 626 0 3s597ms 14s982ms 1m2s 7m41s 10 575 0 2s876ms 10s676ms 1m4s 4m44s 11 587 0 2s727ms 10s635ms 18s184ms 6m9s 12 188 0 4s762ms 3s576ms 9s782ms 3m48s 13 499 0 2s165ms 11s364ms 24s846ms 3m35s 14 751 0 3s745ms 36s844ms 4m26s 5m24s 15 643 0 2s972ms 19s404ms 1m8s 5m2s 16 599 0 3s593ms 10s847ms 58s946ms 5m16s 17 354 0 3s648ms 13s651ms 48s828ms 4m30s 18 15 0 39s761ms 0ms 999ms 3m25s 19 6 0 1m38s 0ms 0ms 3m20s 20 10 89 12s566ms 36s44ms 1m5s 3m48s 21 13 0 46s636ms 0ms 0ms 3m14s 22 6 0 1m41s 0ms 0ms 3m13s 23 10 329 6s806ms 1m3s 1m8s 2m5s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 02 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 Jul 02 00 0 1 1.00 0.00% 01 0 2 2.00 0.00% 02 0 0 0.00 0.00% 03 0 3 3.00 0.00% 04 0 1 1.00 0.00% 05 0 1 1.00 0.00% 06 0 2 2.00 0.00% 07 0 8 8.00 0.00% 08 0 15 15.00 0.00% 09 0 18 18.00 0.00% 10 0 13 13.00 0.00% 11 0 13 13.00 0.00% 12 0 8 8.00 0.00% 13 0 9 9.00 0.00% 14 0 15 15.00 0.00% 15 0 16 16.00 0.00% 16 0 12 12.00 0.00% 17 0 5 5.00 0.00% 18 0 1 1.00 0.00% 19 0 0 0.00 0.00% 20 0 1 1.00 0.00% 21 0 2 2.00 0.00% 22 0 0 0.00 0.00% 23 0 1 1.00 0.00% Day Hour Count Average / Second Jul 02 00 15 0.00/s 01 11 0.00/s 02 10 0.00/s 03 20 0.01/s 04 9 0.00/s 05 10 0.00/s 06 13 0.00/s 07 16 0.00/s 08 43 0.01/s 09 37 0.01/s 10 18 0.01/s 11 23 0.01/s 12 15 0.00/s 13 19 0.01/s 14 26 0.01/s 15 24 0.01/s 16 22 0.01/s 17 19 0.01/s 18 9 0.00/s 19 9 0.00/s 20 13 0.00/s 21 11 0.00/s 22 10 0.00/s 23 7 0.00/s Day Hour Count Average Duration Average idle time Jul 02 00 8 1h45s 1h32s 01 14 1h50s 1h48s 02 11 1h16s 1h14s 03 20 23m25s 23m23s 04 10 1h2m42s 1h2m39s 05 11 52m21s 50m53s 06 8 58m7s 58m 07 13 58m23s 56m18s 08 36 25m24s 24m42s 09 38 37m20s 36m7s 10 24 52m28s 51m3s 11 18 50m4s 48m16s 12 22 52m6s 51m15s 13 13 1h 58m10s 14 24 51m29s 49m4s 15 26 48m28s 46m59s 16 23 51m10s 49m22s 17 21 53m44s 52m34s 18 16 1h52s 1h13s 19 10 55m 53m59s 20 11 41m59s 40m3s 21 10 1h47s 59m43s 22 11 1h1m6s 1h7s 23 13 49m7s 46m10s -
Connections
Established Connections
Key values
- 7 connections Connection Peak
- 2026-07-02 03:05:16 Date
Connections per database
Key values
- rio Main Database
- 409 connections Total
Connections per user
Key values
- intelifix Main User
- 409 connections Total
-
Sessions
Simultaneous sessions
Key values
- 8 sessions Session Peak
- 2026-07-02 09:02:17 Date
Histogram of session times
Key values
- 301 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 411 sessions Total
Sessions per user
Key values
- intelifix Main User
- 411 sessions Total
Sessions per host
Key values
- [local] Main Host
- 411 sessions Total
Sessions per application
Key values
- [unknown] Main Application
- 411 sessions Total
Application Count Total Duration Average Duration [unknown] 361 13d6h37m12s 52m57s pgAdmin 4 - CONN:2338459 2 20s896ms 10s448ms pgAdmin 4 - CONN:3340075 2 4s328ms 2s164ms pgAdmin 4 - CONN:3440992 2 1m7s 33s578ms pgAdmin 4 - CONN:3639784 2 5s269ms 2s634ms pgAdmin 4 - CONN:4845356 2 4s556ms 2s278ms pgAdmin 4 - CONN:5586610 2 1m55s 57s955ms pgAdmin 4 - CONN:6994117 2 59s603ms 29s801ms pgAdmin 4 - CONN:7152688 2 12s105ms 6s52ms pgAdmin 4 - CONN:8653369 2 3s923ms 1s961ms pgAdmin 4 - DB:brasilia 3 2m27s 49s87ms pgAdmin 4 - DB:contagem 3 1m24s 28s25ms pgAdmin 4 - DB:postgres 3 9m28s 3m9s pgAdmin 4 - DB:rio 3 5m9s 1m43s pg_dump 6 48m11s 8m1s postgres_fdw 1 44m59s 44m59s psql 13 13h9m48s 1h45s -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 14,003 buffers Checkpoint Peak
- 2026-07-02 00:19:44 Date
- 270.009 seconds Highest write time
- 0.129 seconds Sync time
Checkpoints Wal files
Key values
- 11 files Wal files usage Peak
- 2026-07-02 14:29:35 Date
Checkpoints distance
Key values
- 370.71 Mo Distance Peak
- 2026-07-02 14:29:35 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 02 00 21,518 771.402s 0.09s 771.587s 01 3,376 339.819s 0.055s 339.941s 02 1,682 169.038s 0.026s 169.101s 03 1,856 185.338s 0.064s 185.453s 04 3,564 358.26s 0.048s 358.381s 05 8,707 870.814s 0.079s 870.963s 06 4,356 436.489s 0.028s 436.565s 07 27,640 2,178.318s 0.185s 2,178.626s 08 49,419 2,961.082s 0.404s 2,961.645s 09 92,322 3,238.406s 1.083s 3,239.803s 10 63,082 3,238.623s 0.7s 3,239.562s 11 70,829 3,238.837s 0.682s 3,239.747s 12 33,104 2,441.743s 0.259s 2,442.144s 13 23,898 2,165.853s 0.486s 2,166.529s 14 82,860 3,238.539s 0.851s 3,239.691s 15 82,458 3,238.636s 0.763s 3,239.687s 16 58,582 3,238.86s 0.675s 3,239.751s 17 33,133 2,568.6s 0.412s 2,569.174s 18 1,435 144.026s 0.024s 144.087s 19 28 2.837s 0.005s 2.849s 20 936 195.151s 0.027s 195.204s 21 3,314 334.113s 0.048s 334.241s 22 1,986 199.528s 0.034s 199.607s 23 81 276.957s 0.029s 277.015s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 02 00 0 0 7 787 0.015s 0.009s 01 0 0 1 671 0.003s 0.011s 02 0 0 1 343 0.003s 0.005s 03 0 0 0 433 0.005s 0.009s 04 0 0 1 697 0.003s 0.01s 05 0 0 4 643 0.007s 0.009s 06 0 0 1 373 0.003s 0.007s 07 0 0 21 2,177 0.013s 0.012s 08 0 0 20 4,851 0.004s 0.012s 09 0 0 54 8,575 0.015s 0.012s 10 0 0 41 7,283 0.034s 0.012s 11 0 0 35 6,994 0.011s 0.012s 12 0 0 20 4,034 0.003s 0.012s 13 0 0 26 5,391 0.005s 0.012s 14 0 0 64 7,954 0.023s 0.012s 15 0 0 49 7,940 0.017s 0.012s 16 0 0 33 6,807 0.016s 0.012s 17 0 0 17 5,009 0.019s 0.012s 18 0 0 1 318 0.003s 0.005s 19 0 0 0 7 0.004s 0.001s 20 0 0 1 87 0.003s 0.003s 21 0 0 1 496 0.006s 0.008s 22 0 0 0 440 0.005s 0.007s 23 0 0 1 25 0.011s 0.005s Day Hour Count Avg time (sec) Jul 02 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 Jul 02 00 13,385.00 kB 48,118.50 kB 01 1,778.70 kB 22,393.10 kB 02 1,679.40 kB 10,765.60 kB 03 1,361.00 kB 3,111.50 kB 04 1,801.70 kB 3,105.90 kB 05 6,450.33 kB 14,965.67 kB 06 2,392.86 kB 9,306.00 kB 07 28,261.00 kB 43,585.92 kB 08 27,250.92 kB 78,167.92 kB 09 74,129.58 kB 127,472.42 kB 10 56,373.92 kB 107,738.08 kB 11 48,114.25 kB 72,412.08 kB 12 26,599.00 kB 72,133.25 kB 13 36,064.75 kB 71,602.67 kB 14 87,047.67 kB 131,458.75 kB 15 66,390.67 kB 131,773.83 kB 16 45,402.75 kB 95,565.83 kB 17 23,948.25 kB 62,292.92 kB 18 1,400.00 kB 31,177.80 kB 19 183.00 kB 22,624.00 kB 20 4,634.33 kB 19,458.67 kB 21 2,037.00 kB 12,007.50 kB 22 1,505.86 kB 6,384.14 kB 23 4,620.00 kB 8,554.67 kB -
Temporary Files
Size of temporary files
Key values
- 465.88 MiB Temp Files size Peak
- 2026-07-02 05:31:57 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-07-02 05:32:02 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 02 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 10 1.06 GiB 108.31 MiB 06 0 0 0 07 0 0 0 08 1 104.00 MiB 104.00 MiB 09 4 416.00 MiB 104.00 MiB 10 2 208.00 MiB 104.00 MiB 11 3 312.00 MiB 104.00 MiB 12 1 104.00 MiB 104.00 MiB 13 1 104.00 MiB 104.00 MiB 14 5 520.00 MiB 104.00 MiB 15 5 520.00 MiB 104.00 MiB 16 0 0 0 17 4 416.00 MiB 104.00 MiB 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 25 2.54 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( 026459, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-02 09:14:24 Duration: 5m33s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026504, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-02 14:43:04 Duration: 5m20s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026518, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-02 16:43:45 Duration: 5m15s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
2 8 904.86 MiB 69.48 MiB 232.94 MiB 113.11 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-02 05:32:04 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-02 05:31:57 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
3 2 178.20 MiB 89.10 MiB 89.10 MiB 89.10 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-02 05:30:42 Duration: 40s6ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-02 05:30:39 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
4 1 104.00 MiB 104.00 MiB 104.00 MiB 104.00 MiB select * from rs_fast_excel (?, ?) / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_modelo_recebimento(6,''23981'') ;', '/var/www/html/tmp/RECEBIMENTO_ATOP - RIO DE JANEIRO_NF_23981.xlsx') / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-02 12:19:56 Duration: 288ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT NF_ENTRADA "NF DE ENTRADA CD Contagem", LOTE "LOTE_SAIDA", CAIXA "CAIXA", NOTA_FISCAL "NF_SAIDA",LEGADO "SAP", MODELO "MODELO", TECNOLOGIA "TECNOLOGIA", MODELO_OBS "OBSERVACAO", SERIE "SERIAL1",END_PRINCIPAL "END PRINCIPAL",BARRA3 "SERIAL3", BARRA4 "SERIAL4", ACESSORIO2 "SMART" FROM RS_LOTE_SAIDA_LISTA(042961);' , '/var/www/html/tmp/CONTAGEM-Lote-42961.xlsx') / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-02 14:20:17 Duration: 260ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_modelo_recebimento(6,''23989'') ;', '/var/www/html/tmp/RECEBIMENTO_ATOP - RIO DE JANEIRO_NF_23989.xlsx') / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-02 11:20:03 Duration: 201ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
Queries generating the largest temporary files
Rank Size Query 1 232.94 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-02 05:31:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 232.94 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-02 05:31:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-07-02 09:34:23 - 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-07-02 11:02:31 - 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-07-02 14:54:26 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
6 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-07-02 15:07:30 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
7 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,404,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-07-02 14:40:02 - 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-07-02 15:36:23 - 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') / 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-07-02 15:40:04 - 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-07-02 08:57:58 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
11 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,508,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-07-02 14:13:07 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
12 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,508,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-07-02 17:30:31 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,508,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-07-02 17:31:19 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-07-02 09:05:47 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
15 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-07-02 10:31:05 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
16 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,404,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-07-02 14:24:42 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
17 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-07-02 09:13:58 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
18 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-07-02 12:07:46 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 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-07-02 11:18:51 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,503,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-07-02 14:02:11 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 3.76 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_07
Database rio - 2026-07-02 14:27:49 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 3.76 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_07
Database rio - 2026-07-02 14:27:49 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (133) Main table analyzed (database rio)
- 1,186 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 133 rio.pg_catalog.pg_class 72 rio.pg_catalog.pg_type 63 contagem.public.temp0000226514 57 brasilia.pg_catalog.pg_attribute 51 rio.public.temp0000284232 48 rio.public.usuarios 44 rio.pg_catalog.pg_index 39 rio.pg_catalog.pg_depend 31 rio.public.temp0000284248 29 contagem.pg_catalog.pg_attribute 27 rio.public.temp0000284216 25 rio.public.temp0000284222 25 brasilia.pg_catalog.pg_class 23 rio.public.temp0000283956 22 rio.public.temp0000281789 21 rio.public.temp0000284272 21 brasilia.pg_catalog.pg_type 20 rio.public.temp0000284228 16 rio.public.temp0000284330 16 rio.public.temp0000284310 16 contagem.public.usuarios 16 contagem.pg_catalog.pg_class 14 contagem.public.temp0000226535 12 contagem.pg_catalog.pg_type 12 rio.public.temp0000284218 12 contagem.public.temp0000226531 12 brasilia.public.temp0000235122 11 brasilia.public.usuarios 11 rio.public.temp0000283932 11 brasilia.pg_catalog.pg_index 11 brasilia.public.temp0000235144 10 rio.public.temp0000284256 10 rio.public.temp0000284244 9 brasilia.pg_catalog.pg_depend 9 rio.public.temp0000284354 9 contagem.pg_catalog.pg_index 8 brasilia.public.temp0000235166 8 rio.public.temp0000283996 8 contagem.auditor.auditor_2026_07 7 brasilia.auditor.auditor_2026_07 7 rio.public.temp0000284224 7 rio.public.temp0000284366 6 brasilia.public.temp0000235206 6 contagem.pg_catalog.pg_depend 6 rio.auditor.auditor_2026_07 6 rio.public.temp0000284314 5 contagem.public.nf_entrada 5 rio.public.temp0000284234 5 brasilia.public.temp0000235174 5 rio.public.temp0000284214 4 brasilia.public.temp0000235212 4 rio.public.tmp_drill_0175 4 brasilia.public.temp0000235178 4 rio.public.temp0000284242 4 rio.public.tmp_drill_0302 3 brasilia.public.temp0000235200 3 rio.pg_catalog.pg_shdepend 3 rio.public.temp0000284254 3 brasilia.public.temp0000235164 3 postgres.pg_catalog.pg_shdepend 3 rio.public.temp0000284318 3 rio.public.temp0000284276 3 brasilia.public.temp0000235104 3 rio.public.temp0000284230 3 brasilia.public.temp0000235140 3 brasilia.pg_catalog.pg_shdepend 3 brasilia.public.temp0000235208 3 brasilia.public.temp0000235160 2 rio.public.temp0000284324 2 contagem.pg_catalog.pg_shdepend 2 rio.public.temp0000284258 2 contagem.public.temp0000226529 2 brasilia.public.temp0000235100 2 rio.public.temp0000284348 2 brasilia.public.temp0000235188 2 contagem.public.temp0000226533 2 rio.public.temp0000284270 2 brasilia.public.temp0000235196 2 brasilia.public.nf_entrada 2 template1.pg_catalog.pg_shdepend 2 rio.public.temp0000284042 2 rio.public.temp0000284336 2 brasilia.public.temp0000235218 1 contagem.public.temp0000226541 1 rio.public.temp0000284252 1 brasilia.public.temp0000235106 1 rio.public.temp0000284292 1 rio.public.temp0000284288 1 rio.public.temp0000284278 1 brasilia.public.temp0000235216 1 brasilia.public.temp0000235110 1 contagem.public.temp0000226527 1 rio.public.temp0000284362 1 contagem.public.temp0000226520 1 rio.public.temp0000284334 1 rio.public.temp0000284364 1 rio.public.temp0000284300 1 rio.public.temp0000284342 1 rio.public.temp0000284240 1 rio.public.temp0000284306 1 rio.public.temp0000284286 1 brasilia.public.temp0000235162 1 brasilia.public.temp0000235126 1 rio.public.temp0000284236 1 rio.public.temp0000284338 1 rio.public.temp0000284368 1 rio.public.temp0000284332 1 brasilia.public.temp0000235114 1 rio.public.temp0000284290 1 rio.public.temp0000284226 1 rio.public.temp0000284360 1 rio.public.temp0000284356 1 rio.public.temp0000284358 1 rio.public.temp0000284352 1 rio.public.temp0000284304 1 brasilia.public.temp0000235156 1 brasilia.public.temp0000235214 1 rio.public.temp0000284322 1 rio.public.temp0000284326 1 brasilia.public.temp0000235210 1 rio.public.temp0000284246 1 rio.public.temp0000284320 1 Total 1,186 Vacuums per table
Key values
- pg_catalog.pg_attribute (62) Main table vacuumed on database rio
- 524 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.pg_catalog.pg_attribute 62 52 0 0 0 0 0 26,916 6,937 10,158,856 411 10,566 rio.pg_catalog.pg_class 48 32 0 0 0 0 0 5,926 1,875 2,604,112 110 445 rio.public.temp0000284232 39 0 0 0 0 0 0 34,745 1,781 4,146,901 0 0 rio.pg_catalog.pg_type 37 28 0 0 0 0 0 2,756 864 1,073,776 99 323 rio.public.temp0000284272 22 0 0 0 0 0 0 27,580 3,317 5,776,387 0 0 rio.pg_catalog.pg_index 21 17 0 0 0 0 0 1,094 297 266,185 69 146 rio.public.temp0000284330 16 0 0 0 0 0 0 17,874 1,678 3,135,110 0 0 contagem.public.usuarios 15 0 0 0 0 0 0 78 58 32,151 0 0 brasilia.pg_catalog.pg_attribute 15 15 0 0 0 0 0 7,326 2,255 3,349,215 95 2,681 rio.public.temp0000281789 14 0 0 0 0 0 0 635 110 89,544 0 0 rio.public.temp0000284248 13 0 0 0 0 0 0 3,812 160 391,654 0 0 rio.pg_catalog.pg_depend 12 12 0 0 0 0 0 4,496 1,665 2,386,938 112 897 rio.public.temp0000283932 11 0 0 0 0 0 0 1,368 60 90,091 0 0 contagem.pg_catalog.pg_attribute 11 11 0 0 0 0 0 6,506 1,456 2,678,294 27 664 rio.public.temp0000284310 10 0 0 0 0 0 0 3,856 174 432,560 0 0 rio.pg_catalog.pg_statistic 9 9 0 0 0 0 0 13,000 3,194 14,739,112 1,365 5,582 rio.public.temp0000283996 8 0 0 0 0 0 0 430 183 262,657 0 0 contagem.public.temp0000226531 8 0 0 0 0 0 0 801 48 54,798 0 0 rio.public.temp0000284244 8 0 0 0 0 0 0 621 45 43,410 0 0 rio.public.temp0000284256 8 0 0 0 0 0 0 369 38 27,768 0 0 brasilia.pg_catalog.pg_class 7 7 0 0 0 0 0 1,178 370 635,104 32 123 brasilia.pg_catalog.pg_type 6 6 0 0 0 0 0 537 158 170,925 23 84 rio.public.usuarios 6 5 0 0 0 0 0 116 49 122,526 1 1 contagem.pg_catalog.pg_type 5 5 0 0 0 0 0 593 116 203,508 6 12 rio.pg_toast.pg_toast_2619 5 5 0 0 0 0 0 1,980 456 2,437,119 134 367 rio.public.temp0000284366 5 0 0 0 0 0 0 8,120 20 482,095 0 0 contagem.pg_catalog.pg_class 5 5 0 0 0 0 0 1,245 203 354,617 8 28 rio.public.temp0000284314 5 0 0 0 0 0 0 3,330 20 199,642 0 0 brasilia.pg_catalog.pg_statistic 4 4 0 0 0 0 0 4,655 866 3,372,636 495 2,974 brasilia.auditor.auditor_2026_07 4 0 0 0 0 0 0 16,689 10,500 13,707,993 2,569 50,771 rio.public.tmp_drill_0175 4 4 0 0 0 0 0 214 12 41,876 0 0 rio.public.temp0000284242 4 0 0 0 0 0 0 6,485 16 385,027 0 0 contagem.auditor.auditor_2026_07 4 0 0 0 0 0 0 11,579 6,343 8,229,075 1,748 43,103 brasilia.pg_catalog.pg_index 4 4 0 0 0 0 0 252 82 56,888 19 33 contagem.pg_catalog.pg_shdepend 4 4 0 0 0 0 0 513 193 315,515 27 76 rio.auditor.auditor_2026_07 3 0 0 0 0 0 0 71,037 31,935 42,537,960 19,236 381,806 contagem.pg_catalog.pg_index 3 3 0 0 0 0 0 153 32 49,523 1 1 brasilia.pg_toast.pg_toast_2619 3 3 0 0 0 0 0 456 107 388,256 18 45 rio.public.temp0000284318 3 0 0 0 0 0 0 162 17 12,170 0 0 rio.public.temp0000284354 3 0 0 0 0 0 0 490 18 31,961 0 0 contagem.pg_catalog.pg_depend 3 3 0 0 0 0 0 1,030 233 554,230 2 8 brasilia.public.temp0000235140 3 0 0 0 0 0 0 483 17 31,834 0 0 contagem.pg_catalog.pg_statistic 3 3 0 0 0 0 0 3,537 390 1,501,371 248 1,802 brasilia.pg_catalog.pg_depend 3 3 0 0 0 0 0 826 284 353,003 28 268 rio.public.temp0000284336 2 0 0 0 0 0 0 1,631 9 97,646 0 0 contagem.public.nf_entrada 2 2 0 0 0 0 0 200 49 98,450 8 15 rio.public.temp0000284042 2 0 0 0 0 0 0 304 12 19,946 0 0 postgres.pg_catalog.pg_shdepend 2 2 0 0 0 0 0 310 99 156,669 16 27 rio.public.temp0000284324 2 0 0 0 0 0 0 3,246 8 192,720 0 0 rio.public.temp0000284276 2 0 0 0 0 0 0 8 6 1,548 0 0 contagem.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 272 33 149,620 13 32 rio.public.tmp_drill_0302 2 2 0 0 0 0 0 79 6 16,943 0 0 contagem.public.temp0000226535 2 0 0 0 0 0 0 208 12 14,266 0 0 rio.public.temp0000284254 2 0 0 0 0 0 0 3,245 8 192,661 0 0 rio.public.temp0000284304 1 0 0 0 0 0 0 1,622 4 96,301 0 0 rio.public.temp0000284352 1 0 0 0 0 0 0 1,623 4 96,360 0 0 brasilia.public.giga_testes 1 1 0 0 0 0 0 4,027 3,336 11,756,197 41 505 rio.public.temp0000284364 1 0 0 0 0 0 0 1,624 4 96,419 0 0 rio.public.temp0000284300 1 0 0 0 0 0 0 8 5 1,276 0 0 rio.public.temp0000284322 1 0 0 0 0 0 0 77 6 5,440 0 0 rio.public.temp0000284334 1 0 0 0 0 0 0 4 3 774 0 0 rio.public.temp0000284326 1 0 0 0 0 0 0 77 6 5,436 0 0 brasilia.public.temp0000235162 1 0 0 0 0 0 0 8 5 1,516 0 0 brasilia.public.temp0000235126 1 0 0 0 0 0 0 238 6 15,210 0 0 brasilia.public.temp0000235218 1 0 0 0 0 0 0 238 237 375,394 0 0 rio.public.temp0000284240 1 0 0 0 0 0 0 43 6 3,357 0 0 rio.public.temp0000284306 1 0 0 0 0 0 0 1,622 4 96,301 0 0 brasilia.public.temp0000235114 1 0 0 0 0 0 0 237 6 15,108 0 0 rio.public.temp0000284288 1 0 0 0 0 0 0 73 6 5,194 0 0 rio.public.temp0000284332 1 0 0 0 0 0 0 128 6 8,506 0 0 contagem.public.temp0000226529 1 0 0 0 0 0 0 100 6 6,839 0 0 rio.public.temp0000284338 1 0 0 0 0 0 0 4 3 774 0 0 Total 524 249 0 0 0 0 0 317,105 82,527 141,441,244 26,961 503,385 Vacuum throughput per table
Key values
- auditor.auditor_2026_07 (9.88) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.pg_catalog.pg_attribute 0 0 3.8 rio.pg_catalog.pg_class 0 0 0.9 rio.public.temp0000284232 0 0 1.7 rio.pg_catalog.pg_type 0 0 0.41 rio.public.temp0000284272 0 0 1.22 rio.pg_catalog.pg_index 0 0 0.22 rio.public.temp0000284330 0 0 0.85 contagem.public.usuarios 0 0 0 brasilia.pg_catalog.pg_attribute 0 0 1.15 rio.public.temp0000281789 0 0 0.2 rio.public.temp0000284248 0 0 0.3 rio.pg_catalog.pg_depend 0 0 0.93 rio.public.temp0000283932 0 0 0.16 contagem.pg_catalog.pg_attribute 0 0 0.89 rio.public.temp0000284310 0 0 0.25 rio.pg_catalog.pg_statistic 0 0 1.66 rio.public.temp0000283996 0 0 0.17 contagem.public.temp0000226531 0 0 0.1 rio.public.temp0000284244 0 0 0.13 rio.public.temp0000284256 0 0 0.09 brasilia.pg_catalog.pg_class 0 0 0.21 brasilia.pg_catalog.pg_type 0 0 0.09 rio.public.usuarios 0 0 0 contagem.pg_catalog.pg_type 0 0 0.08 rio.pg_toast.pg_toast_2619 0 0 0.26 rio.public.temp0000284366 0 0 0.29 contagem.pg_catalog.pg_class 0 0 0.21 rio.public.temp0000284314 0 0 0.21 brasilia.pg_catalog.pg_statistic 0 0 0.5 brasilia.auditor.auditor_2026_07 0 0 3.4 rio.public.tmp_drill_0175 0 0 0.01 rio.public.temp0000284242 0 0 0.2 contagem.auditor.auditor_2026_07 0 0 2 brasilia.pg_catalog.pg_index 0 0 0.08 contagem.pg_catalog.pg_shdepend 0 0 0.12 rio.auditor.auditor_2026_07 0 0 9.88 contagem.pg_catalog.pg_index 0 0 0.04 brasilia.pg_toast.pg_toast_2619 0 0 0.02 rio.public.temp0000284318 0 0 0.05 rio.public.temp0000284354 0 0 0.06 contagem.pg_catalog.pg_depend 0 0 0.14 brasilia.public.temp0000235140 0 0 0.05 contagem.pg_catalog.pg_statistic 0 0 0.24 brasilia.pg_catalog.pg_depend 0 0 0.17 rio.public.temp0000284336 0 0 0.09 contagem.public.nf_entrada 0 0 0.03 rio.public.temp0000284042 0 0 0.03 postgres.pg_catalog.pg_shdepend 0 0 0.1 rio.public.temp0000284324 0 0 0.1 rio.public.temp0000284276 0 0 0.09 contagem.pg_toast.pg_toast_2619 0 0 0.01 rio.public.tmp_drill_0302 0 0 0 contagem.public.temp0000226535 0 0 0.05 rio.public.temp0000284254 0 0 0.1 rio.public.temp0000284304 0 0 0.05 rio.public.temp0000284352 0 0 0.05 brasilia.public.giga_testes 0 0 2.18 rio.public.temp0000284364 0 0 0.06 rio.public.temp0000284300 0 0 0.02 rio.public.temp0000284322 0 0 0.02 rio.public.temp0000284334 0 0 0 rio.public.temp0000284326 0 0 0.02 brasilia.public.temp0000235162 0 0 0.02 brasilia.public.temp0000235126 0 0 0.02 brasilia.public.temp0000235218 0 0 0.02 rio.public.temp0000284240 0 0 0.02 rio.public.temp0000284306 0 0 0.05 brasilia.public.temp0000235114 0 0 0.02 rio.public.temp0000284288 0 0 0.01 rio.public.temp0000284332 0 0 0.01 contagem.public.temp0000226529 0 0 0.02 rio.public.temp0000284338 0 0 0 Total 0 0 36.63 Tuples removed per table
Key values
- pg_catalog.pg_attribute (189696) Main table with removed tuples on database rio
- 385544 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 62 52 189,696 1,650,994 142,820 232 40,458 brasilia.pg_catalog.pg_attribute 15 15 54,997 336,713 276 48 8,215 contagem.pg_catalog.pg_attribute 11 11 44,083 265,047 0 184 5,994 rio.pg_catalog.pg_statistic 9 9 15,905 77,089 193 0 11,574 rio.pg_catalog.pg_depend 12 12 13,222 233,967 3,410 0 2,180 rio.pg_catalog.pg_type 37 28 9,233 95,087 10,228 24 2,772 brasilia.pg_catalog.pg_statistic 4 4 7,589 32,267 0 0 4,288 contagem.pg_catalog.pg_statistic 3 3 6,518 22,873 0 0 3,033 brasilia.pg_catalog.pg_depend 3 3 4,867 52,915 0 0 552 contagem.pg_catalog.pg_class 5 5 4,050 17,303 0 0 655 rio.pg_catalog.pg_class 48 32 4,027 202,550 32,689 8 6,520 contagem.pg_catalog.pg_depend 3 3 4,012 56,585 0 0 536 rio.pg_catalog.pg_index 21 17 3,773 43,425 2,922 0 1,239 contagem.pg_catalog.pg_shdepend 4 4 3,628 54,691 276 0 460 contagem.pg_catalog.pg_type 5 5 2,667 11,265 0 23 329 brasilia.pg_catalog.pg_class 7 7 2,250 28,382 0 0 1,029 rio.auditor.auditor_2026_07 3 0 2,104 4,241,329 0 0 200,076 brasilia.pg_catalog.pg_type 6 6 1,849 13,386 0 4 414 contagem.public.nf_entrada 2 2 1,725 2,727 0 0 138 rio.public.tmp_drill_0175 4 4 1,666 2,580 0 0 70 postgres.pg_catalog.pg_shdepend 2 2 1,162 27,537 419 0 230 rio.pg_toast.pg_toast_2619 5 5 1,161 2,713 18 0 1,275 contagem.pg_catalog.pg_index 3 3 1,109 5,696 0 0 162 brasilia.pg_catalog.pg_index 4 4 1,102 7,514 0 0 228 contagem.public.usuarios 15 0 910 345 0 0 30 rio.public.tmp_drill_0302 2 2 454 888 0 0 25 rio.public.usuarios 6 5 376 3,696 645 0 102 contagem.auditor.auditor_2026_07 4 0 341 883,645 0 0 38,342 brasilia.public.giga_testes 1 1 298 668,915 0 0 17,800 brasilia.pg_toast.pg_toast_2619 3 3 290 405 1 0 207 brasilia.auditor.auditor_2026_07 4 0 272 1,477,538 0 0 65,194 contagem.pg_toast.pg_toast_2619 2 2 208 226 0 0 124 rio.public.temp0000284330 16 0 0 365,264 0 0 26,624 rio.public.temp0000284310 10 0 0 86,608 0 258 4,286 rio.public.temp0000284304 1 0 0 22,806 0 0 1,664 rio.public.temp0000284352 1 0 0 22,834 0 0 1,664 rio.public.temp0000284336 2 0 0 23,990 0 58 1,734 rio.public.temp0000284042 2 0 0 12,812 0 96 288 rio.public.temp0000283932 11 0 0 57,890 0 229 1,307 rio.public.temp0000284242 4 0 0 91,202 0 0 6,656 rio.public.temp0000284364 1 0 0 22,836 0 0 1,664 rio.public.temp0000284300 1 0 0 1,121 0 62 66 rio.public.temp0000281789 14 0 0 35,160 0 358 762 rio.public.temp0000284272 22 0 0 501,527 0 0 36,608 rio.public.temp0000284322 1 0 0 1,154 0 59 69 rio.public.temp0000284334 1 0 0 5,413 0 0 128 rio.public.temp0000283996 8 0 0 31,252 0 263 697 rio.public.temp0000284326 1 0 0 1,165 0 59 69 rio.public.temp0000284324 2 0 0 45,655 0 0 3,328 brasilia.public.temp0000235162 1 0 0 3,057 0 27 229 rio.public.temp0000284276 2 0 0 45,574 0 0 3,328 rio.public.temp0000284232 39 0 0 717,261 0 430 52,178 brasilia.public.temp0000235126 1 0 0 3,057 0 27 229 contagem.public.temp0000226531 8 0 0 9,619 0 288 736 rio.public.temp0000284318 3 0 0 3,502 0 175 209 brasilia.public.temp0000235218 1 0 0 3,061 0 26 230 rio.public.temp0000284240 1 0 0 1,547 0 29 35 rio.public.temp0000284354 3 0 0 20,761 0 110 466 rio.public.temp0000284306 1 0 0 22,806 0 0 1,664 rio.public.temp0000284248 13 0 0 120,000 0 323 7,421 contagem.public.temp0000226535 2 0 0 2,352 0 66 190 rio.public.temp0000284244 8 0 0 27,653 0 277 619 rio.public.temp0000284366 5 0 0 114,189 0 0 8,320 brasilia.public.temp0000235114 1 0 0 3,057 0 27 229 rio.public.temp0000284288 1 0 0 1,090 0 63 65 rio.public.temp0000284332 1 0 0 5,383 0 8 120 brasilia.public.temp0000235140 3 0 0 9,171 0 81 687 rio.public.temp0000284254 2 0 0 45,634 0 0 3,328 contagem.public.temp0000226529 1 0 0 1,200 0 36 92 rio.public.temp0000284256 8 0 0 32,610 0 224 736 rio.public.temp0000284314 5 0 0 92,472 0 60 6,724 rio.public.temp0000284338 1 0 0 5,415 0 0 128 Total 524 249 385,544 13,139,453 193,897 4,242 589,828 Pages removed per table
Key values
- public.temp0000284232 (430) Main table with removed pages on database rio
- 4242 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000284232 39 0 0 430 rio.public.temp0000281789 14 0 0 358 rio.public.temp0000284248 13 0 0 323 contagem.public.temp0000226531 8 0 0 288 rio.public.temp0000284244 8 0 0 277 rio.public.temp0000283996 8 0 0 263 rio.public.temp0000284310 10 0 0 258 rio.pg_catalog.pg_attribute 62 52 189696 232 rio.public.temp0000283932 11 0 0 229 rio.public.temp0000284256 8 0 0 224 contagem.pg_catalog.pg_attribute 11 11 44083 184 rio.public.temp0000284318 3 0 0 175 rio.public.temp0000284354 3 0 0 110 rio.public.temp0000284042 2 0 0 96 brasilia.public.temp0000235140 3 0 0 81 contagem.public.temp0000226535 2 0 0 66 rio.public.temp0000284288 1 0 0 63 rio.public.temp0000284300 1 0 0 62 rio.public.temp0000284314 5 0 0 60 rio.public.temp0000284322 1 0 0 59 rio.public.temp0000284326 1 0 0 59 rio.public.temp0000284336 2 0 0 58 brasilia.pg_catalog.pg_attribute 15 15 54997 48 contagem.public.temp0000226529 1 0 0 36 rio.public.temp0000284240 1 0 0 29 brasilia.public.temp0000235162 1 0 0 27 brasilia.public.temp0000235126 1 0 0 27 brasilia.public.temp0000235114 1 0 0 27 brasilia.public.temp0000235218 1 0 0 26 rio.pg_catalog.pg_type 37 28 9233 24 contagem.pg_catalog.pg_type 5 5 2667 23 rio.public.temp0000284332 1 0 0 8 rio.pg_catalog.pg_class 48 32 4027 8 brasilia.pg_catalog.pg_type 6 6 1849 4 rio.public.temp0000284330 16 0 0 0 brasilia.pg_catalog.pg_statistic 4 4 7589 0 contagem.public.usuarios 15 0 910 0 rio.public.temp0000284304 1 0 0 0 rio.public.temp0000284352 1 0 0 0 contagem.public.nf_entrada 2 2 1725 0 brasilia.auditor.auditor_2026_07 4 0 272 0 rio.auditor.auditor_2026_07 3 0 2104 0 rio.public.tmp_drill_0175 4 4 1666 0 brasilia.public.giga_testes 1 1 298 0 rio.pg_toast.pg_toast_2619 5 5 1161 0 rio.public.temp0000284242 4 0 0 0 contagem.pg_catalog.pg_index 3 3 1109 0 rio.public.temp0000284364 1 0 0 0 brasilia.pg_toast.pg_toast_2619 3 3 290 0 rio.public.temp0000284272 22 0 0 0 contagem.auditor.auditor_2026_07 4 0 341 0 rio.public.temp0000284334 1 0 0 0 postgres.pg_catalog.pg_shdepend 2 2 1162 0 brasilia.pg_catalog.pg_index 4 4 1102 0 contagem.pg_catalog.pg_shdepend 4 4 3628 0 rio.public.temp0000284324 2 0 0 0 brasilia.pg_catalog.pg_class 7 7 2250 0 rio.public.temp0000284276 2 0 0 0 contagem.pg_toast.pg_toast_2619 2 2 208 0 rio.public.usuarios 6 5 376 0 rio.public.tmp_drill_0302 2 2 454 0 rio.public.temp0000284306 1 0 0 0 rio.pg_catalog.pg_depend 12 12 13222 0 rio.public.temp0000284366 5 0 0 0 contagem.pg_catalog.pg_class 5 5 4050 0 contagem.pg_catalog.pg_depend 3 3 4012 0 rio.public.temp0000284254 2 0 0 0 rio.pg_catalog.pg_index 21 17 3773 0 contagem.pg_catalog.pg_statistic 3 3 6518 0 brasilia.pg_catalog.pg_depend 3 3 4867 0 rio.pg_catalog.pg_statistic 9 9 15905 0 rio.public.temp0000284338 1 0 0 0 Total 524 249 385,544 4,242 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 02 00 2 8 01 1 11 02 0 0 03 0 2 04 0 11 05 7 3 06 0 1 07 13 28 08 21 74 09 104 166 10 44 105 11 43 121 12 21 47 13 36 86 14 100 182 15 69 141 16 31 114 17 27 79 18 0 0 19 0 0 20 0 0 21 5 7 22 0 0 23 0 0 - 3.76 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- AccessExclusiveLock Main Lock Type
- 2 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 1 1s1ms 1s1ms 1s1ms 1s1ms drop table if exists temp0000284248;-
DROP TABLE IF EXISTS temp0000284248;
Date: 2026-07-02 10:24:44 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
DROP TABLE IF EXISTS temp0000284248;
Date: 2026-07-02 12:07:45 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
DROP TABLE IF EXISTS temp0000284248;
Date: 2026-07-02 12:08:47 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
2 1 1s 1s 1s 1s drop table if exists temp0000284272;-
DROP TABLE IF EXISTS temp0000284272;
Date: 2026-07-02 10:32:45 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
DROP TABLE IF EXISTS temp0000284272;
Date: 2026-07-02 10:31:46 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
Queries that waited the most
Rank Wait time Query 1 1s1ms DROP TABLE IF EXISTS temp0000284248;[ Date: 2026-07-02 10:24:44 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 1s DROP TABLE IF EXISTS temp0000284272;[ Date: 2026-07-02 10:32:45 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 5,388 Total read queries
- 1,797 Total write queries
Queries by database
Key values
- rio Main database
- 4,636 Requests
- 6h9m49s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 14,011 Requests
User Request type Count Duration etiquetas Total 70 15s957ms select 70 15s957ms intelifix Total 14,011 16h37m58s copy to 800 1h44m55s ddl 2,599 1h47m52s others 886 1h18m24s select 9,724 11h46m45s lenon Total 233 7m3s select 233 7m3s Duration by user
Key values
- 16h37m58s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 70 15s957ms select 70 15s957ms intelifix Total 14,011 16h37m58s copy to 800 1h44m55s ddl 2,599 1h47m52s others 886 1h18m24s select 9,724 11h46m45s lenon Total 233 7m3s select 233 7m3s Queries by host
Key values
- [local] Main host
- 14,314 Requests
- 16h45m17s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 6,532 Requests
- 3h51m58s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-02 23:43:05 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 4,263 100-500ms duration
Slowest individual queries
Rank Duration Query 1 8m32s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-02 09:13:34 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 8m14s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-02 10:13:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 8m10s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-02 11:13:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 8m5s analyze verbose;[ Date: 2026-07-02 05:08:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 8m4s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-02 15:13:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 8m2s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-02 14:13:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 7m51s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-02 17:12:53 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 7m47s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-02 16:12:49 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 7m42s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-02 07:12:43 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 7m25s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-02 12:12:26 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 6m22s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-02 20:11:24 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 6m16s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-02 08:11:18 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 6m16s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-02 13:11:17 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 6m8s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-02 22:11:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 6m3s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-02 21:11:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m43s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-02 19:10:45 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m36s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-02 18:10:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 5m33s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026459, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-02 09:14:24 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 5m20s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026504, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-02 14:43:04 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 5m15s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026518, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-02 16:43:45 - 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 2h1m25s 48 1s174ms 8m32s 2m31s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 02 07 3 8m16s 2m45s 08 3 6m33s 2m11s 09 3 9m10s 3m3s 10 3 8m41s 2m53s 11 3 8m46s 2m55s 12 3 7m53s 2m37s 13 3 6m33s 2m11s 14 3 8m37s 2m52s 15 3 8m42s 2m54s 16 3 8m19s 2m46s 17 3 8m20s 2m46s 18 3 5m55s 1m58s 19 3 6m 2m 20 3 6m47s 2m15s 21 3 6m20s 2m6s 22 3 6m24s 2m8s [ User: intelifix - Total duration: 2h1m25s - Times executed: 48 ]
[ Application: psql - Total duration: 2h1m25s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-02 09:13:34 Duration: 8m32s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-02 10:13:15 Duration: 8m14s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-02 11:13:12 Duration: 8m10s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-02.log
2 1h45m33s 291 154ms 5m33s 21s764ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 02 07 18 9m10s 30s591ms 08 5 5m20s 1m4s 09 36 15m26s 25s732ms 10 33 7m34s 13s765ms 11 40 8m15s 12s398ms 12 6 59s881ms 9s980ms 13 23 3m11s 8s309ms 14 36 25m38s 42s744ms 15 32 9m43s 18s244ms 16 32 15m39s 29s353ms 17 28 4m28s 9s581ms 18 2 4s305ms 2s152ms [ User: intelifix - Total duration: 1h45m33s - Times executed: 291 ]
[ Application: [unknown] - Total duration: 1h45m33s - Times executed: 291 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026459, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-02 09:14:24 Duration: 5m33s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026504, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-02 14:43:04 Duration: 5m20s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026518, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-02 16:43:45 Duration: 5m15s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
3 1h12m8s 48 272ms 4m35s 1m30s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 02 07 3 4m25s 1m28s 08 3 3m40s 1m13s 09 3 5m19s 1m46s 10 3 5m11s 1m43s 11 3 4m50s 1m36s 12 3 4m27s 1m29s 13 3 4m5s 1m21s 14 3 4m56s 1m38s 15 3 5m24s 1m48s 16 3 5m18s 1m46s 17 3 4m44s 1m34s 18 3 3m53s 1m17s 19 3 3m48s 1m16s 20 3 4m35s 1m31s 21 3 3m43s 1m14s 22 3 3m42s 1m14s [ User: intelifix - Total duration: 1h12m8s - Times executed: 48 ]
[ Application: psql - Total duration: 1h12m8s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-02 15:19:03 Duration: 4m35s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-02 16:18:35 Duration: 4m26s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-02 09:19:26 Duration: 4m22s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-02.log
4 16m22s 1,415 150ms 4s72ms 694ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 02 07 8 5s521ms 690ms 08 93 1m8s 733ms 09 244 3m13s 794ms 10 212 2m21s 666ms 11 178 1m52s 631ms 12 103 43s892ms 426ms 13 76 54s439ms 716ms 14 108 1m13s 679ms 15 152 2m 793ms 16 166 1m50s 668ms 17 75 58s208ms 776ms [ User: intelifix - Total duration: 16m22s - Times executed: 1415 ]
[ Application: [unknown] - Total duration: 16m22s - Times executed: 1415 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (44649, 413, '834165924002271,241607449396,241689091417,241668209906,241712565458,241604730614,241614526586,241676854566,241715478201,241726980525,241676635779,241598883960,241654211324,241649687391,241656710513,241727112232,241593301328,241637733453,241617872738,241668222736,241659831940,241617341620,241689083234,241676826280,241689088890,241726911326,241694974258,241695614657,241598871939,241620761617,241668219705,241620774749', '',0321,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-02 16:17:43 Duration: 4s72ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (260741, 503, '834072911001118,230048942745,241629889915,241674600811,241649146676,241670414667,241649143040,241603057778,241674596971,241596110424,241629250931,241629276263,241596610203,241649284950,241597914662,241669680421,241617966787,230047994257,241734098503,241669597785,241631641725,241616070217,241601028287,241670366480,241674259206,241714001424,230043531622,241695507272,241607747484,241619940112,241609298286,241700696073,241677872028,230040455979,241730550211,241696905355,241661014041,241693006467,241664259093,230043577282,241667255155', '',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-07-02 09:31:11 Duration: 3s798ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (260497, 450, 'ZTE3ANNR9W03441,D89A0DA8ACC9,D89A0DA8ACCA,ZTEGDB161F1C$ZTE3ANNT3F12578,D83139965294,D83139965295,ZTEGDD31BDC9$ZTE3ANNQ3R20718,3CF9F0A4655A,3CF9F0A4655B,ZTEGD64050ED$ZTE3ANNR6R28514,48D68238210E,48D68238210F,ZTEGDB019A35$ZTE3ANNT3J10024,D83139A0D642,D83139A0D643,ZTEGDD337E66$ZTE3ANNQ4N11993,3CF9F0A9AAC4,3CF9F0A9AAC5,ZTEGD64131D4$ZTE3ANNR8C09792,3891484F6C87,3891484F6C88,ZTEGDB08A6B0$ZTE3ANNRC575850,6C11BA691B93,6C11BA691B94,ZTEGDC6F3E09$ZTE3ANNR9F18291,D89A0DA48A95,D89A0DA48A96,ZTEGDB156EBE$ZTE3ANNRAM42290,5872C98B1765,5872C98B1766,ZTEGDC60A531$ZTE3ANNR4N06384,4896D955F0B8,4896D955F0B9,ZTEGD97F38B5$ZTE3ANNR9F36828,D89A0DA63D0B,D89A0DA63D0C,ZTEGDB15B727$ZTE3ANNR8C33798,389148519F2B,389148519F2C,ZTEGDB090476$ZTE3ANNQCA53023,14CA56D71F95,14CA56D71F96,ZTEGD972348A$ZTE3ANNR7B32483,3891484BE5F9,3891484BE5FA,ZTEGDB081043$ZTE3ANNR6R55131,48D6823A90E4,48D6823A90E5,ZTEGDB02022E$ZTE3ANNRCB62520,D8313923884E,D8313923884F,ZTEGDD2AA9CD$ZTE3ANNQ4406896,3CF9F0AC007E,3CF9F0AC007F,ZTEGD6419573$ZTE3ANNT3J12457,D83139A10F48,D83139A10F49,ZTEGDD3387E7$ZTE3ANNR8C26943,38914850FE81,38914850FE82,ZTEGDB08E9AF$ZTE3ANNRB703099,5872C98E81D3,5872C98E81D4,ZTEGDC6136EE$ZTE3ANNT3H17894,D831399866FC,D831399866FD,ZTEGDD321685$ZTE3ANNR3Y38471,4896D9534662,4896D9534663,ZTEGD97EC6FC$ZTE3ANNR1Y33264,14CA56CFB61B,14CA56CFB61C,ZTEGD970F84B$ZTE3ANNQ3R00907,3CF9F0A29508,3CF9F0A29509,ZTEGD640038A$ZTE3ANNQ6M07926,C4EBFF891B94,C4EBFF891B95,ZTEGD70A0004$ZTE3ANNR4N60315,4896D95AE0BA,4896D95AE0BB,ZTEGD9800B60$ZTE3ANNQ3R00778,3CF9F0A29202,3CF9F0A29203,ZTEGD6400309$ZTE3ANNQ8M06949,843C991F6AC9,843C991F6ACA,ZTEGD7BA6292$ZTE3ANNQ3613657,3CF9F0A61584,3CF9F0A61585,ZTEGD64098F4$ZTE3ANNR6R57229,48D6823AC210,48D6823AC211,ZTEGDB020A60$ZTE3ANNT3J12691,D83139A114C4,D83139A114C5,ZTEGDD3388D1$ZTE3ANNQ6M08449,C4EBFF8927D6,C4EBFF8927D7,ZTEGD70A020F$ZTE3ANNR3J06922,F4E84F86F09C,F4E84F86F09D,ZTEGD97B7CD4$ZTE3ANNR3Y21355,4896D951B53A,4896D951B53B,ZTEGD97E8420$ZTE3ANNRB721053,5872C990269F,5872C99026A0,ZTEGDC617D10$ZTE3ANNR4N24042,4896D9578E94,4896D9578E95,ZTEGD97F7DAF$ZTE3ANNT3H01646,D8313996EA2C,D8313996EA2D,ZTEGDD31D70D$ZTE3ANNT3H66951,D831399CE4C2,D831399CE4C3,ZTEGDD32D626$ZTE3ANNR3Y35442,4896D952FF64,4896D952FF65,ZTEGD97EBB27', '',0318,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-07-02 15:08:43 Duration: 3s387ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
5 14m1s 70 9s197ms 32s104ms 12s23ms create table temp0000284232 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 02 07 15 2m54s 11s656ms 08 6 1m10s 11s739ms 09 7 1m24s 12s89ms 10 5 57s912ms 11s582ms 11 3 39s62ms 13s20ms 14 17 3m22s 11s888ms 15 5 55s163ms 11s32ms 16 12 2m37s 13s121ms [ User: intelifix - Total duration: 14m1s - Times executed: 70 ]
[ Application: [unknown] - Total duration: 14m1s - Times executed: 70 ]
-
CREATE TABLE temp0000284232 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-02 07:22:36 Duration: 32s104ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
CREATE TABLE temp0000284232 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-02 16:36:28 Duration: 32s63ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
CREATE TABLE temp0000284232 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-02 14:37:38 Duration: 14s799ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
6 13m52s 3 2m5s 8m5s 4m37s analyze verbose;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 02 05 3 13m52s 4m37s [ User: intelifix - Total duration: 13m52s - Times executed: 3 ]
[ Application: psql - Total duration: 13m52s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-02 05:08:06 Duration: 8m5s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
analyze verbose;
Date: 2026-07-02 05:11:48 Duration: 3m41s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
analyze verbose;
Date: 2026-07-02 05:13:53 Duration: 2m5s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-02.log
7 9m12s 164 1s324ms 11s443ms 3s366ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 02 07 4 7s294ms 1s823ms 08 12 33s100ms 2s758ms 09 28 1m11s 2s570ms 10 41 1m32s 2s259ms 11 8 23s890ms 2s986ms 12 6 19s418ms 3s236ms 13 3 13s89ms 4s363ms 14 11 42s969ms 3s906ms 15 18 1m44s 5s788ms 16 15 1m2s 4s137ms 17 18 1m21s 4s525ms [ User: intelifix - Total duration: 9m12s - Times executed: 164 ]
[ Application: [unknown] - Total duration: 9m12s - Times executed: 164 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-02', 0175, '', '', 0, 6, '2026-07-01');
Date: 2026-07-02 14:30:36 Duration: 11s443ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-02', 0302, '', '', 0, 6, '2026-07-02');
Date: 2026-07-02 08:34:48 Duration: 11s149ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-02', 0302, '', '', 0, 6, '2026-07-02');
Date: 2026-07-02 16:28:02 Duration: 11s80ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
8 9m4s 1,120 150ms 7s888ms 486ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 02 07 5 1s990ms 398ms 08 154 1m11s 465ms 09 164 1m20s 493ms 10 134 1m11s 530ms 11 146 1m2s 427ms 12 6 3s29ms 504ms 13 86 33s667ms 391ms 14 183 1m39s 545ms 15 142 1m6s 465ms 16 51 26s598ms 521ms 17 49 27s244ms 556ms [ User: intelifix - Total duration: 9m4s - Times executed: 1120 ]
[ Application: [unknown] - Total duration: 9m4s - Times executed: 1120 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "243112", "modelo" : "287", "itens" : "230013585152,230008432641,230016939711,229997312229,229994139809,229997261719,230012468892,229959391222,229937721419,230003899516,230017626781,229928259293,229994717676,229993258499,229947162329,229964308604,229938911221,229961229504,229928888806,229947908394,229995300720", "usuario" : "414", "caixa" : "2912539", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-02 17:06:36 Duration: 7s888ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "243120", "modelo" : "287", "itens" : "229965213249,229956368490,230003617793,229985528788,229985513131,230004595274,230004625355,230004591941,230004610607,230004667076,229956871829,229952685662,230008764850,229954453355,229954406986,229952695663,229961131111,229998086681,229970007588,230003706769,230008871023", "usuario" : "414", "caixa" : "2916319", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-02 14:13:28 Duration: 5s784ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "104675", "modelo" : "305", "itens" : "229999600107,229999070628,229999580509,230029676262,230031014564,229999079214,229952242028,229952208286,229998714251", "usuario" : "414", "caixa" : "1227457", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-02 15:38:59 Duration: 5s616ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
9 7m31s 38 9s853ms 19s616ms 11s879ms create table temp0000284272 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 02 08 3 44s178ms 14s726ms 09 16 3m10s 11s910ms 10 7 1m19s 11s349ms 11 9 1m42s 11s414ms 12 3 34s512ms 11s504ms [ User: intelifix - Total duration: 7m31s - Times executed: 38 ]
[ Application: [unknown] - Total duration: 7m31s - Times executed: 38 ]
-
CREATE TABLE temp0000284272 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-02 08:58:26 Duration: 19s616ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
CREATE TABLE temp0000284272 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-02 09:57:36 Duration: 14s163ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
CREATE TABLE temp0000284272 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-02 10:32:00 Duration: 13s911ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
10 7m9s 235 150ms 8s505ms 1s825ms call rs_giga_triagem (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 02 00 11 22s718ms 2s65ms 01 12 15s158ms 1s263ms 02 12 15s595ms 1s299ms 03 12 22s861ms 1s905ms 04 10 14s618ms 1s461ms 05 12 14s895ms 1s241ms 06 11 15s519ms 1s410ms 07 12 16s529ms 1s377ms 08 12 16s556ms 1s379ms 09 12 20s91ms 1s674ms 10 11 19s448ms 1s768ms 11 12 19s339ms 1s611ms 12 10 17s21ms 1s702ms 13 12 16s884ms 1s407ms 14 12 21s35ms 1s752ms 15 11 22s300ms 2s27ms 16 7 21s326ms 3s46ms 17 7 19s183ms 2s740ms 18 9 20s62ms 2s229ms 19 7 18s464ms 2s637ms 20 7 23s905ms 3s415ms 21 7 17s922ms 2s560ms 22 7 17s634ms 2s519ms [ User: intelifix - Total duration: 7m9s - Times executed: 235 ]
[ Application: psql - Total duration: 7m9s - Times executed: 235 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-02 03:05:24 Duration: 8s505ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-02 00:05:20 Duration: 7s895ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-02 20:15:08 Duration: 7s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-02.log
11 7m7s 161 174ms 11s155ms 2s657ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 02 00 6 20s142ms 3s357ms 01 6 8s562ms 1s427ms 02 4 6s827ms 1s706ms 03 5 9s383ms 1s876ms 04 6 10s260ms 1s710ms 05 5 4s669ms 933ms 06 5 6s742ms 1s348ms 07 10 28s986ms 2s898ms 08 12 45s204ms 3s767ms 09 12 50s792ms 4s232ms 10 11 38s928ms 3s538ms 11 12 43s309ms 3s609ms 12 12 36s782ms 3s65ms 13 6 2s742ms 457ms 14 12 35s665ms 2s972ms 15 12 38s980ms 3s248ms 16 10 20s377ms 2s37ms 17 4 2s332ms 583ms 21 5 7s710ms 1s542ms 22 6 9s440ms 1s573ms [ User: intelifix - Total duration: 7m7s - Times executed: 161 ]
[ Application: psql - Total duration: 7m7s - Times executed: 161 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-02 00:05:12 Duration: 11s155ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-02 10:05:10 Duration: 9s791ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-02 09:35:10 Duration: 8s878ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-02.log
12 6m48s 36 9s383ms 13s840ms 11s351ms create table temp0000284330 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 02 13 3 32s279ms 10s759ms 14 18 3m24s 11s357ms 15 15 2m51s 11s463ms [ User: intelifix - Total duration: 6m48s - Times executed: 36 ]
[ Application: [unknown] - Total duration: 6m48s - Times executed: 36 ]
-
CREATE TABLE temp0000284330 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-02 14:44:52 Duration: 13s840ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
CREATE TABLE temp0000284330 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-02 15:17:23 Duration: 13s791ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
CREATE TABLE temp0000284330 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-02 14:54:47 Duration: 13s370ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
13 5m5s 785 150ms 2s220ms 388ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 02 08 1 416ms 416ms 11 82 23s605ms 287ms 13 217 1m34s 433ms 14 105 45s695ms 435ms 15 111 52s729ms 475ms 16 199 1m14s 375ms 17 70 13s828ms 197ms [ User: intelifix - Total duration: 5m5s - Times executed: 785 ]
[ Application: [unknown] - Total duration: 5m5s - Times executed: 785 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"126601","seriais":"241660338284,241648203341,241667622846,241660338688,241603458098,241716554961,241680686477,241602859296,241708993247,241619383031,241660601521,241671928495,241664984754,241616093148,241650480107,241706932743,241650496673,241709231935,241649572734,241691349112,241706917286,241691782241,241650415577,241658678707,241660437082,241634575860,241645720922,241709007086,241712775860,230040199613,241728823959,241716562235,241716550113,241629937900,241629941537,241672702141,241631832630,241628300019,241667894567","usuario":"398","observacao":""}');
Date: 2026-07-02 13:48:17 Duration: 2s220ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"126601","seriais":"241670228890,241599522642,241709352126,241601684042,241604555871,241691408488,241675567885,241707108595,241715215268,241728862425,241667960107,241709217589,241674121617,241706952543,241671995472,241663039514,241634809193,241712616978,241691206976,241619345777,241649513536,241732536464,241631040926,241672747273,241616612020,241604161535,241709379805,241656941321,241694092242,241628141720,241715543841,241618208708,241691522945,241691367575,241597392333,241709319495,241691526480,241671331132,241636947382,241649526668,241676645252,241634781515,241631448192","usuario":"398","observacao":""}');
Date: 2026-07-02 13:47:47 Duration: 2s102ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"126601","seriais":"241747381528,241738837584,241778739818,241762555870,241739532030,241776684365,241744346068,241776519904,241767970608,241776516267,241776669111,241738898803,241761162031,241747222646,241778569497,241761162132,241742101327,241765426464,241761185568,241778563134,241776668404,241778591420,241765413456","usuario":"398","observacao":""}');
Date: 2026-07-02 13:42:50 Duration: 1s852ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
14 3m7s 4 4s535ms 1m33s 46s758ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 02 20 2 1m39s 49s591ms 23 2 1m27s 43s926ms [ User: intelifix - Total duration: 3m7s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m7s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-02 20:09:03 Duration: 1m33s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-02 23:36:09 Duration: 1m23s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-02 20:10:55 Duration: 5s543ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-02.log
15 3m3s 16 9s826ms 13s940ms 11s449ms create table temp0000284248 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 02 10 8 1m35s 11s993ms 11 2 21s868ms 10s934ms 12 6 1m5s 10s897ms [ User: intelifix - Total duration: 3m3s - Times executed: 16 ]
[ Application: [unknown] - Total duration: 3m3s - Times executed: 16 ]
-
CREATE TABLE temp0000284248 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-02 10:24:35 Duration: 13s940ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
CREATE TABLE temp0000284248 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-02 12:07:59 Duration: 13s627ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
CREATE TABLE temp0000284248 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-02 10:20:25 Duration: 12s288ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
16 2m50s 82 158ms 14s89ms 2s74ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 02 07 13 9s480ms 729ms 10 10 5s883ms 588ms 11 12 12s799ms 1s66ms 13 11 11s821ms 1s74ms 14 8 34s952ms 4s369ms 15 6 4s157ms 692ms 16 14 1m7s 4s823ms 17 8 23s452ms 2s931ms [ User: intelifix - Total duration: 2m50s - Times executed: 82 ]
[ Application: [unknown] - Total duration: 2m50s - Times executed: 82 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (042960) LIMIT 1;
Date: 2026-07-02 14:20:33 Duration: 14s89ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0126601) LIMIT 1;
Date: 2026-07-02 16:34:56 Duration: 12s584ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (042959) LIMIT 1;
Date: 2026-07-02 14:20:54 Duration: 8s407ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
17 2m24s 14 9s287ms 11s232ms 10s299ms create table temp0000284310 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 02 13 14 2m24s 10s299ms [ User: intelifix - Total duration: 2m24s - Times executed: 14 ]
[ Application: [unknown] - Total duration: 2m24s - Times executed: 14 ]
-
CREATE TABLE temp0000284310 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-02 13:32:44 Duration: 11s232ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
CREATE TABLE temp0000284310 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-02 13:24:56 Duration: 10s893ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
CREATE TABLE temp0000284310 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-02 13:26:05 Duration: 10s757ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
18 1m54s 3 5s977ms 1m30s 38s143ms copy auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 02 23 3 1m54s 38s143ms [ User: intelifix - Total duration: 1m54s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 1m54s - Times executed: 3 ]
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-02 23:14:06 Duration: 1m30s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-02 23:47:43 Duration: 18s142ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-02 23:36:44 Duration: 5s977ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-02.log
19 1m53s 4 334ms 1m3s 28s496ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 02 20 2 1m4s 32s95ms 23 2 49s797ms 24s898ms [ User: intelifix - Total duration: 1m53s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m53s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-02 20:05:42 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-02 23:17:21 Duration: 49s462ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-02 20:10:19 Duration: 466ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-02.log
20 1m47s 2 20s281ms 1m27s 53s663ms 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 #20
Day Hour Count Duration Avg duration Jul 02 23 2 1m47s 53s663ms [ User: intelifix - Total duration: 1m47s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m47s - 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-07-02 23:12:36 Duration: 1m27s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
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-07-02 23:47:25 Duration: 20s281ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-02.log
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,415 16m22s 150ms 4s72ms 694ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 02 07 8 5s521ms 690ms 08 93 1m8s 733ms 09 244 3m13s 794ms 10 212 2m21s 666ms 11 178 1m52s 631ms 12 103 43s892ms 426ms 13 76 54s439ms 716ms 14 108 1m13s 679ms 15 152 2m 793ms 16 166 1m50s 668ms 17 75 58s208ms 776ms [ User: intelifix - Total duration: 16m22s - Times executed: 1415 ]
[ Application: [unknown] - Total duration: 16m22s - Times executed: 1415 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (44649, 413, '834165924002271,241607449396,241689091417,241668209906,241712565458,241604730614,241614526586,241676854566,241715478201,241726980525,241676635779,241598883960,241654211324,241649687391,241656710513,241727112232,241593301328,241637733453,241617872738,241668222736,241659831940,241617341620,241689083234,241676826280,241689088890,241726911326,241694974258,241695614657,241598871939,241620761617,241668219705,241620774749', '',0321,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-02 16:17:43 Duration: 4s72ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (260741, 503, '834072911001118,230048942745,241629889915,241674600811,241649146676,241670414667,241649143040,241603057778,241674596971,241596110424,241629250931,241629276263,241596610203,241649284950,241597914662,241669680421,241617966787,230047994257,241734098503,241669597785,241631641725,241616070217,241601028287,241670366480,241674259206,241714001424,230043531622,241695507272,241607747484,241619940112,241609298286,241700696073,241677872028,230040455979,241730550211,241696905355,241661014041,241693006467,241664259093,230043577282,241667255155', '',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-07-02 09:31:11 Duration: 3s798ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (260497, 450, 'ZTE3ANNR9W03441,D89A0DA8ACC9,D89A0DA8ACCA,ZTEGDB161F1C$ZTE3ANNT3F12578,D83139965294,D83139965295,ZTEGDD31BDC9$ZTE3ANNQ3R20718,3CF9F0A4655A,3CF9F0A4655B,ZTEGD64050ED$ZTE3ANNR6R28514,48D68238210E,48D68238210F,ZTEGDB019A35$ZTE3ANNT3J10024,D83139A0D642,D83139A0D643,ZTEGDD337E66$ZTE3ANNQ4N11993,3CF9F0A9AAC4,3CF9F0A9AAC5,ZTEGD64131D4$ZTE3ANNR8C09792,3891484F6C87,3891484F6C88,ZTEGDB08A6B0$ZTE3ANNRC575850,6C11BA691B93,6C11BA691B94,ZTEGDC6F3E09$ZTE3ANNR9F18291,D89A0DA48A95,D89A0DA48A96,ZTEGDB156EBE$ZTE3ANNRAM42290,5872C98B1765,5872C98B1766,ZTEGDC60A531$ZTE3ANNR4N06384,4896D955F0B8,4896D955F0B9,ZTEGD97F38B5$ZTE3ANNR9F36828,D89A0DA63D0B,D89A0DA63D0C,ZTEGDB15B727$ZTE3ANNR8C33798,389148519F2B,389148519F2C,ZTEGDB090476$ZTE3ANNQCA53023,14CA56D71F95,14CA56D71F96,ZTEGD972348A$ZTE3ANNR7B32483,3891484BE5F9,3891484BE5FA,ZTEGDB081043$ZTE3ANNR6R55131,48D6823A90E4,48D6823A90E5,ZTEGDB02022E$ZTE3ANNRCB62520,D8313923884E,D8313923884F,ZTEGDD2AA9CD$ZTE3ANNQ4406896,3CF9F0AC007E,3CF9F0AC007F,ZTEGD6419573$ZTE3ANNT3J12457,D83139A10F48,D83139A10F49,ZTEGDD3387E7$ZTE3ANNR8C26943,38914850FE81,38914850FE82,ZTEGDB08E9AF$ZTE3ANNRB703099,5872C98E81D3,5872C98E81D4,ZTEGDC6136EE$ZTE3ANNT3H17894,D831399866FC,D831399866FD,ZTEGDD321685$ZTE3ANNR3Y38471,4896D9534662,4896D9534663,ZTEGD97EC6FC$ZTE3ANNR1Y33264,14CA56CFB61B,14CA56CFB61C,ZTEGD970F84B$ZTE3ANNQ3R00907,3CF9F0A29508,3CF9F0A29509,ZTEGD640038A$ZTE3ANNQ6M07926,C4EBFF891B94,C4EBFF891B95,ZTEGD70A0004$ZTE3ANNR4N60315,4896D95AE0BA,4896D95AE0BB,ZTEGD9800B60$ZTE3ANNQ3R00778,3CF9F0A29202,3CF9F0A29203,ZTEGD6400309$ZTE3ANNQ8M06949,843C991F6AC9,843C991F6ACA,ZTEGD7BA6292$ZTE3ANNQ3613657,3CF9F0A61584,3CF9F0A61585,ZTEGD64098F4$ZTE3ANNR6R57229,48D6823AC210,48D6823AC211,ZTEGDB020A60$ZTE3ANNT3J12691,D83139A114C4,D83139A114C5,ZTEGDD3388D1$ZTE3ANNQ6M08449,C4EBFF8927D6,C4EBFF8927D7,ZTEGD70A020F$ZTE3ANNR3J06922,F4E84F86F09C,F4E84F86F09D,ZTEGD97B7CD4$ZTE3ANNR3Y21355,4896D951B53A,4896D951B53B,ZTEGD97E8420$ZTE3ANNRB721053,5872C990269F,5872C99026A0,ZTEGDC617D10$ZTE3ANNR4N24042,4896D9578E94,4896D9578E95,ZTEGD97F7DAF$ZTE3ANNT3H01646,D8313996EA2C,D8313996EA2D,ZTEGDD31D70D$ZTE3ANNT3H66951,D831399CE4C2,D831399CE4C3,ZTEGDD32D626$ZTE3ANNR3Y35442,4896D952FF64,4896D952FF65,ZTEGD97EBB27', '',0318,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-07-02 15:08:43 Duration: 3s387ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
2 1,120 9m4s 150ms 7s888ms 486ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 02 07 5 1s990ms 398ms 08 154 1m11s 465ms 09 164 1m20s 493ms 10 134 1m11s 530ms 11 146 1m2s 427ms 12 6 3s29ms 504ms 13 86 33s667ms 391ms 14 183 1m39s 545ms 15 142 1m6s 465ms 16 51 26s598ms 521ms 17 49 27s244ms 556ms [ User: intelifix - Total duration: 9m4s - Times executed: 1120 ]
[ Application: [unknown] - Total duration: 9m4s - Times executed: 1120 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "243112", "modelo" : "287", "itens" : "230013585152,230008432641,230016939711,229997312229,229994139809,229997261719,230012468892,229959391222,229937721419,230003899516,230017626781,229928259293,229994717676,229993258499,229947162329,229964308604,229938911221,229961229504,229928888806,229947908394,229995300720", "usuario" : "414", "caixa" : "2912539", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-02 17:06:36 Duration: 7s888ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "243120", "modelo" : "287", "itens" : "229965213249,229956368490,230003617793,229985528788,229985513131,230004595274,230004625355,230004591941,230004610607,230004667076,229956871829,229952685662,230008764850,229954453355,229954406986,229952695663,229961131111,229998086681,229970007588,230003706769,230008871023", "usuario" : "414", "caixa" : "2916319", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-02 14:13:28 Duration: 5s784ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "104675", "modelo" : "305", "itens" : "229999600107,229999070628,229999580509,230029676262,230031014564,229999079214,229952242028,229952208286,229998714251", "usuario" : "414", "caixa" : "1227457", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-02 15:38:59 Duration: 5s616ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
3 785 5m5s 150ms 2s220ms 388ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 02 08 1 416ms 416ms 11 82 23s605ms 287ms 13 217 1m34s 433ms 14 105 45s695ms 435ms 15 111 52s729ms 475ms 16 199 1m14s 375ms 17 70 13s828ms 197ms [ User: intelifix - Total duration: 5m5s - Times executed: 785 ]
[ Application: [unknown] - Total duration: 5m5s - Times executed: 785 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"126601","seriais":"241660338284,241648203341,241667622846,241660338688,241603458098,241716554961,241680686477,241602859296,241708993247,241619383031,241660601521,241671928495,241664984754,241616093148,241650480107,241706932743,241650496673,241709231935,241649572734,241691349112,241706917286,241691782241,241650415577,241658678707,241660437082,241634575860,241645720922,241709007086,241712775860,230040199613,241728823959,241716562235,241716550113,241629937900,241629941537,241672702141,241631832630,241628300019,241667894567","usuario":"398","observacao":""}');
Date: 2026-07-02 13:48:17 Duration: 2s220ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"126601","seriais":"241670228890,241599522642,241709352126,241601684042,241604555871,241691408488,241675567885,241707108595,241715215268,241728862425,241667960107,241709217589,241674121617,241706952543,241671995472,241663039514,241634809193,241712616978,241691206976,241619345777,241649513536,241732536464,241631040926,241672747273,241616612020,241604161535,241709379805,241656941321,241694092242,241628141720,241715543841,241618208708,241691522945,241691367575,241597392333,241709319495,241691526480,241671331132,241636947382,241649526668,241676645252,241634781515,241631448192","usuario":"398","observacao":""}');
Date: 2026-07-02 13:47:47 Duration: 2s102ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"126601","seriais":"241747381528,241738837584,241778739818,241762555870,241739532030,241776684365,241744346068,241776519904,241767970608,241776516267,241776669111,241738898803,241761162031,241747222646,241778569497,241761162132,241742101327,241765426464,241761185568,241778563134,241776668404,241778591420,241765413456","usuario":"398","observacao":""}');
Date: 2026-07-02 13:42:50 Duration: 1s852ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
4 291 1h45m33s 154ms 5m33s 21s764ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 02 07 18 9m10s 30s591ms 08 5 5m20s 1m4s 09 36 15m26s 25s732ms 10 33 7m34s 13s765ms 11 40 8m15s 12s398ms 12 6 59s881ms 9s980ms 13 23 3m11s 8s309ms 14 36 25m38s 42s744ms 15 32 9m43s 18s244ms 16 32 15m39s 29s353ms 17 28 4m28s 9s581ms 18 2 4s305ms 2s152ms [ User: intelifix - Total duration: 1h45m33s - Times executed: 291 ]
[ Application: [unknown] - Total duration: 1h45m33s - Times executed: 291 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026459, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-02 09:14:24 Duration: 5m33s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026504, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-02 14:43:04 Duration: 5m20s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026518, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-02 16:43:45 Duration: 5m15s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
5 235 7m9s 150ms 8s505ms 1s825ms call rs_giga_triagem (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 02 00 11 22s718ms 2s65ms 01 12 15s158ms 1s263ms 02 12 15s595ms 1s299ms 03 12 22s861ms 1s905ms 04 10 14s618ms 1s461ms 05 12 14s895ms 1s241ms 06 11 15s519ms 1s410ms 07 12 16s529ms 1s377ms 08 12 16s556ms 1s379ms 09 12 20s91ms 1s674ms 10 11 19s448ms 1s768ms 11 12 19s339ms 1s611ms 12 10 17s21ms 1s702ms 13 12 16s884ms 1s407ms 14 12 21s35ms 1s752ms 15 11 22s300ms 2s27ms 16 7 21s326ms 3s46ms 17 7 19s183ms 2s740ms 18 9 20s62ms 2s229ms 19 7 18s464ms 2s637ms 20 7 23s905ms 3s415ms 21 7 17s922ms 2s560ms 22 7 17s634ms 2s519ms [ User: intelifix - Total duration: 7m9s - Times executed: 235 ]
[ Application: psql - Total duration: 7m9s - Times executed: 235 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-02 03:05:24 Duration: 8s505ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-02 00:05:20 Duration: 7s895ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-02 20:15:08 Duration: 7s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-02.log
6 164 9m12s 1s324ms 11s443ms 3s366ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 02 07 4 7s294ms 1s823ms 08 12 33s100ms 2s758ms 09 28 1m11s 2s570ms 10 41 1m32s 2s259ms 11 8 23s890ms 2s986ms 12 6 19s418ms 3s236ms 13 3 13s89ms 4s363ms 14 11 42s969ms 3s906ms 15 18 1m44s 5s788ms 16 15 1m2s 4s137ms 17 18 1m21s 4s525ms [ User: intelifix - Total duration: 9m12s - Times executed: 164 ]
[ Application: [unknown] - Total duration: 9m12s - Times executed: 164 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-02', 0175, '', '', 0, 6, '2026-07-01');
Date: 2026-07-02 14:30:36 Duration: 11s443ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-02', 0302, '', '', 0, 6, '2026-07-02');
Date: 2026-07-02 08:34:48 Duration: 11s149ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-02', 0302, '', '', 0, 6, '2026-07-02');
Date: 2026-07-02 16:28:02 Duration: 11s80ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
7 161 7m7s 174ms 11s155ms 2s657ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 02 00 6 20s142ms 3s357ms 01 6 8s562ms 1s427ms 02 4 6s827ms 1s706ms 03 5 9s383ms 1s876ms 04 6 10s260ms 1s710ms 05 5 4s669ms 933ms 06 5 6s742ms 1s348ms 07 10 28s986ms 2s898ms 08 12 45s204ms 3s767ms 09 12 50s792ms 4s232ms 10 11 38s928ms 3s538ms 11 12 43s309ms 3s609ms 12 12 36s782ms 3s65ms 13 6 2s742ms 457ms 14 12 35s665ms 2s972ms 15 12 38s980ms 3s248ms 16 10 20s377ms 2s37ms 17 4 2s332ms 583ms 21 5 7s710ms 1s542ms 22 6 9s440ms 1s573ms [ User: intelifix - Total duration: 7m7s - Times executed: 161 ]
[ Application: psql - Total duration: 7m7s - Times executed: 161 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-02 00:05:12 Duration: 11s155ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-02 10:05:10 Duration: 9s791ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-02 09:35:10 Duration: 8s878ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-02.log
8 143 23s778ms 150ms 229ms 166ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 02 00 1 163ms 163ms 01 1 178ms 178ms 04 1 159ms 159ms 05 1 160ms 160ms 07 3 466ms 155ms 08 11 1s822ms 165ms 09 16 2s631ms 164ms 10 18 3s4ms 166ms 11 14 2s331ms 166ms 12 8 1s412ms 176ms 13 7 1s150ms 164ms 14 28 4s701ms 167ms 15 18 2s888ms 160ms 16 15 2s547ms 169ms 17 1 156ms 156ms [ User: intelifix - Total duration: 23s778ms - Times executed: 143 ]
[ Application: [unknown] - Total duration: 23s778ms - Times executed: 143 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0298;
Date: 2026-07-02 16:10:42 Duration: 229ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0131;
Date: 2026-07-02 12:46:39 Duration: 208ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0156;
Date: 2026-07-02 14:00:08 Duration: 198ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
9 139 28s952ms 150ms 384ms 208ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 02 00 4 1s189ms 297ms 01 12 3s81ms 256ms 04 7 1s361ms 194ms 07 14 2s885ms 206ms 08 13 2s669ms 205ms 09 14 2s738ms 195ms 10 21 4s 190ms 11 12 2s558ms 213ms 12 9 1s712ms 190ms 14 15 3s355ms 223ms 15 14 2s709ms 193ms 16 4 691ms 172ms [ User: intelifix - Total duration: 28s952ms - Times executed: 139 ]
[ Application: [unknown] - Total duration: 28s952ms - Times executed: 139 ]
-
SELECT * FROM RS_TRIAGEM (428, 5, '73', 2, '229855613944,229845383552,229841859807,229847011837,229861803134,229842507277,229862148498,229842635876,229842464647,229846397477,229847269011,229855677384,229855150813', NULL, NULL, 0160, 00);
Date: 2026-07-02 00:18:40 Duration: 384ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '229758625769,229653953848,229654051535,229683055779,229651940016,229680713654,229683079900,229681885777,229654036280,216917110121,229682437985,229683320912,229653159416,229682166365,229653218489,216917416872,229679377193,229759332438', NULL, NULL, 0159, 00);
Date: 2026-07-02 01:00:22 Duration: 353ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT * FROM RS_TRIAGEM (403, 5, '113', 3, '229663781115,229671975270,229740026782,216938977091,216941136673,229809415361,229746453145,229780170813,229736159413,229925275153', NULL, NULL, 0141, 00);
Date: 2026-07-02 11:51:15 Duration: 316ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
10 120 34s767ms 150ms 457ms 289ms select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 02 11 2 335ms 167ms 13 1 170ms 170ms 14 80 23s582ms 294ms 15 14 3s867ms 276ms 16 1 196ms 196ms 17 22 6s615ms 300ms [ User: intelifix - Total duration: 34s767ms - Times executed: 120 ]
[ Application: [unknown] - Total duration: 34s767ms - Times executed: 120 ]
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (229989);
Date: 2026-07-02 14:31:45 Duration: 457ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (229989);
Date: 2026-07-02 14:31:49 Duration: 453ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (243112);
Date: 2026-07-02 17:05:37 Duration: 451ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
11 116 52s268ms 280ms 921ms 450ms 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 #11
Day Hour Count Duration Avg duration Jul 02 00 1 378ms 378ms 01 2 768ms 384ms 03 2 907ms 453ms 04 1 332ms 332ms 05 1 456ms 456ms 06 2 715ms 357ms 07 6 2s720ms 453ms 08 11 4s824ms 438ms 09 13 6s496ms 499ms 10 11 5s171ms 470ms 11 10 4s174ms 417ms 12 5 2s145ms 429ms 13 9 3s880ms 431ms 14 13 5s516ms 424ms 15 11 6s187ms 562ms 16 10 4s462ms 446ms 17 5 1s921ms 384ms 18 1 396ms 396ms 21 2 810ms 405ms [ User: lenon - Total duration: 52s268ms - Times executed: 116 ]
[ Application: [unknown] - Total duration: 52s268ms - Times executed: 116 ]
-
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-07-02 15:14:12 Duration: 921ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-07-02 15:52:38 Duration: 808ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-07-02 15:14:02 Duration: 781ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-02.log
12 110 1m2s 354ms 996ms 569ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 02 00 1 609ms 609ms 01 2 1s40ms 520ms 03 2 1s290ms 645ms 04 1 470ms 470ms 05 1 618ms 618ms 07 6 3s612ms 602ms 08 9 5s46ms 560ms 09 12 7s156ms 596ms 10 11 6s358ms 578ms 11 10 5s322ms 532ms 12 5 2s783ms 556ms 13 9 5s 555ms 14 13 6s912ms 531ms 15 11 7s274ms 661ms 16 10 5s504ms 550ms 17 5 2s638ms 527ms 18 1 473ms 473ms 21 1 529ms 529ms [ User: intelifix - Total duration: 1m2s - Times executed: 110 ]
[ Application: [unknown] - Total duration: 1m2s - Times executed: 110 ]
-
select * from rs_menu_grants (397, 18, 1);
Date: 2026-07-02 15:14:12 Duration: 996ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
select * from rs_menu_grants (418, 81, 1);
Date: 2026-07-02 15:52:38 Duration: 955ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
select * from rs_menu_grants (401, 18, 1);
Date: 2026-07-02 15:14:02 Duration: 829ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
13 108 40s441ms 200ms 699ms 374ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 02 07 2 703ms 351ms 08 3 1s79ms 359ms 09 16 5s636ms 352ms 10 11 4s349ms 395ms 11 17 6s573ms 386ms 12 3 1s578ms 526ms 13 4 1s324ms 331ms 14 17 6s813ms 400ms 15 14 4s988ms 356ms 16 7 2s426ms 346ms 17 12 4s336ms 361ms 18 2 631ms 315ms [ User: intelifix - Total duration: 40s441ms - Times executed: 108 ]
[ Application: [unknown] - Total duration: 40s441ms - Times executed: 108 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-07-02 12:11:25 Duration: 699ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 073;
Date: 2026-07-02 17:11:43 Duration: 585ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-07-02 14:19:42 Duration: 572ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
14 95 49s64ms 150ms 6s68ms 516ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 02 00 1 195ms 195ms 03 1 264ms 264ms 08 1 424ms 424ms 09 2 323ms 161ms 10 7 2s931ms 418ms 11 2 324ms 162ms 12 2 324ms 162ms 13 2 334ms 167ms 14 23 34s241ms 1s488ms 15 12 2s170ms 180ms 16 14 2s392ms 170ms 17 27 4s968ms 184ms 18 1 168ms 168ms [ User: intelifix - Total duration: 49s64ms - Times executed: 95 ]
[ Application: [unknown] - Total duration: 49s64ms - Times executed: 95 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "0", "data-de" : "2026-07-02", "data-ate" : "2026-07-02", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "0", "usuario" : 509 }');
Date: 2026-07-02 14:01:39 Duration: 6s68ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "0", "data-de" : "2026-07-02", "data-ate" : "2026-07-02", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "0", "usuario" : 509 }');
Date: 2026-07-02 14:53:12 Duration: 5s2ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "0", "data-de" : "2026-07-02", "data-ate" : "2026-07-02", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "0", "usuario" : 509 }');
Date: 2026-07-02 14:00:57 Duration: 4s436ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
15 88 35s806ms 151ms 1s3ms 406ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 02 09 9 4s232ms 470ms 10 7 2s497ms 356ms 11 11 5s117ms 465ms 12 4 1s721ms 430ms 14 13 5s430ms 417ms 15 32 12s199ms 381ms 16 9 3s438ms 382ms 17 3 1s168ms 389ms [ User: intelifix - Total duration: 35s806ms - Times executed: 88 ]
[ Application: [unknown] - Total duration: 35s806ms - Times executed: 88 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '38914851AEA9,D89A0D82DA9F,D89A0D82A73F,843C9933FB81,843C9920107D,14CA56CE21F9,D89A0DAD1B71,3891484ACA55,D89A0DAD210B,14CA56D6C7DB,D89A0DAA004D,5872C98ACFA1,48D68237FB2E,48D68233D252,3891484C3471,6C11BA687DB9,3CF9F0AB11FE,D89A0D8499F3,3CF9F0AB186A,D89A0DA47811', '138;1', 'DEFAULT', 09, 0323, '','', '', 00);
Date: 2026-07-02 11:59:12 Duration: 1s3ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '4896D9583D42,4896D94FFAC0,843C9932C363,3CF9F0A4827C,843C992F0E3D,6C11BA6BC37F,6C11BA684D11,C4EBFF8DF01E,C4EBFF8D34EC,3CF9F0AAF2EA,C4EBFF8C4678,D89A0DA4A103,48D682384CB8,14CA56D541AB,3CF9F0A54B64,C4EBFF8AA830,843C992F0E37,48D682384262,3CF9F0AE6AC0,C4EBFF8D91A4', '138;1', 'DEFAULT', 09, 0323, '','', '', 00);
Date: 2026-07-02 15:17:22 Duration: 937ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '48D68231BC0A,5872C98DA39D,5872C98F6573,3CF9F0A69F0C,D89A0D84ADA9,843C992F0FA5,48D682306FE8,3CF9F0AC3CCC,3CF9F0AAC902,14CA56CCF371,14CA56D05FCB,843C992E714D,C4EBFF89DAD4,D89A0DA48C93,3CF9F0AB036A,C4EBFF895FF2,48D682330C28,3CF9F0A5B9E6,C4EBFF8AD860,F4E84F828080', '138;1', 'DEFAULT', 09, 0323, '','', '', 00);
Date: 2026-07-02 15:21:36 Duration: 851ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
16 82 2m50s 158ms 14s89ms 2s74ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 02 07 13 9s480ms 729ms 10 10 5s883ms 588ms 11 12 12s799ms 1s66ms 13 11 11s821ms 1s74ms 14 8 34s952ms 4s369ms 15 6 4s157ms 692ms 16 14 1m7s 4s823ms 17 8 23s452ms 2s931ms [ User: intelifix - Total duration: 2m50s - Times executed: 82 ]
[ Application: [unknown] - Total duration: 2m50s - Times executed: 82 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (042960) LIMIT 1;
Date: 2026-07-02 14:20:33 Duration: 14s89ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0126601) LIMIT 1;
Date: 2026-07-02 16:34:56 Duration: 12s584ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (042959) LIMIT 1;
Date: 2026-07-02 14:20:54 Duration: 8s407ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
17 72 1m24s 196ms 7s720ms 1s179ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 02 07 5 2s641ms 528ms 08 3 8s477ms 2s825ms 09 9 26s521ms 2s946ms 10 9 4s919ms 546ms 11 5 6s697ms 1s339ms 12 5 5s673ms 1s134ms 13 12 3s551ms 295ms 14 11 12s213ms 1s110ms 15 6 9s866ms 1s644ms 16 4 1s956ms 489ms 17 3 2s379ms 793ms [ User: intelifix - Total duration: 1m24s - Times executed: 72 ]
[ Application: psql - Total duration: 1m24s - Times executed: 72 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026457);
Date: 2026-07-02 08:58:44 Duration: 7s720ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026464);
Date: 2026-07-02 09:35:58 Duration: 7s705ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT RS_SETGLOBAL ('USUARIO', 309); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026460);
Date: 2026-07-02 09:08:52 Duration: 6s928ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-02.log
18 70 14m1s 9s197ms 32s104ms 12s23ms create table temp0000284232 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 02 07 15 2m54s 11s656ms 08 6 1m10s 11s739ms 09 7 1m24s 12s89ms 10 5 57s912ms 11s582ms 11 3 39s62ms 13s20ms 14 17 3m22s 11s888ms 15 5 55s163ms 11s32ms 16 12 2m37s 13s121ms [ User: intelifix - Total duration: 14m1s - Times executed: 70 ]
[ Application: [unknown] - Total duration: 14m1s - Times executed: 70 ]
-
CREATE TABLE temp0000284232 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-02 07:22:36 Duration: 32s104ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
CREATE TABLE temp0000284232 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-02 16:36:28 Duration: 32s63ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
CREATE TABLE temp0000284232 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-02 14:37:38 Duration: 14s799ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
19 66 17s829ms 153ms 2s588ms 270ms create table temp0000284252 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 02 08 4 3s239ms 809ms 09 10 2s474ms 247ms 10 10 2s387ms 238ms 11 5 1s275ms 255ms 12 12 2s934ms 244ms 13 1 326ms 326ms 14 8 2s28ms 253ms 15 5 1s53ms 210ms 16 11 2s109ms 191ms [ User: intelifix - Total duration: 17s829ms - Times executed: 66 ]
[ Application: [unknown] - Total duration: 17s829ms - Times executed: 66 ]
-
CREATE TABLE temp0000284252 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"27-06-2026", "ate" :"02-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-02 08:10:27 Duration: 2s588ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
CREATE TABLE temp0000284252 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"27-06-2026", "ate" :"02-07-2026", "nota-fiscal":"80904", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-02 14:32:48 Duration: 524ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
CREATE TABLE temp0000284252 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"27-06-2026", "ate" :"02-07-2026", "nota-fiscal":"81039", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-02 10:45:56 Duration: 365ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
20 65 21s104ms 152ms 928ms 324ms select (rs_fast_barras (b.eq_id)).* from caixa_itens a inner join fluxos b on b.flu_id = a.flu_id where a.cai_id = ? order by a.cai_ordem;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 02 08 1 208ms 208ms 09 6 1s944ms 324ms 10 1 290ms 290ms 11 2 632ms 316ms 13 4 736ms 184ms 14 23 6s954ms 302ms 15 13 3s413ms 262ms 16 9 4s427ms 491ms 17 6 2s496ms 416ms [ User: intelifix - Total duration: 21s104ms - Times executed: 65 ]
[ Application: [unknown] - Total duration: 21s104ms - Times executed: 65 ]
-
SELECT (RS_FAST_BARRAS (B.EQ_ID)).* FROM CAIXA_ITENS A INNER JOIN FLUXOS B ON B.FLU_ID = A.FLU_ID WHERE A.CAI_ID = 114473 ORDER BY A.CAI_ORDEM;
Date: 2026-07-02 16:40:06 Duration: 928ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT (RS_FAST_BARRAS (B.EQ_ID)).* FROM CAIXA_ITENS A INNER JOIN FLUXOS B ON B.FLU_ID = A.FLU_ID WHERE A.CAI_ID = 2494636 ORDER BY A.CAI_ORDEM;
Date: 2026-07-02 14:27:37 Duration: 808ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT (RS_FAST_BARRAS (B.EQ_ID)).* FROM CAIXA_ITENS A INNER JOIN FLUXOS B ON B.FLU_ID = A.FLU_ID WHERE A.CAI_ID = 3195639 ORDER BY A.CAI_ORDEM;
Date: 2026-07-02 16:33:52 Duration: 705ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m5s 8m5s 4m37s 3 13m52s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 02 05 3 13m52s 4m37s [ User: intelifix - Total duration: 13m52s - Times executed: 3 ]
[ Application: psql - Total duration: 13m52s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-02 05:08:06 Duration: 8m5s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
analyze verbose;
Date: 2026-07-02 05:11:48 Duration: 3m41s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
analyze verbose;
Date: 2026-07-02 05:13:53 Duration: 2m5s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-02.log
2 1s174ms 8m32s 2m31s 48 2h1m25s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 02 07 3 8m16s 2m45s 08 3 6m33s 2m11s 09 3 9m10s 3m3s 10 3 8m41s 2m53s 11 3 8m46s 2m55s 12 3 7m53s 2m37s 13 3 6m33s 2m11s 14 3 8m37s 2m52s 15 3 8m42s 2m54s 16 3 8m19s 2m46s 17 3 8m20s 2m46s 18 3 5m55s 1m58s 19 3 6m 2m 20 3 6m47s 2m15s 21 3 6m20s 2m6s 22 3 6m24s 2m8s [ User: intelifix - Total duration: 2h1m25s - Times executed: 48 ]
[ Application: psql - Total duration: 2h1m25s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-02 09:13:34 Duration: 8m32s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-02 10:13:15 Duration: 8m14s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-02 11:13:12 Duration: 8m10s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-02.log
3 272ms 4m35s 1m30s 48 1h12m8s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 02 07 3 4m25s 1m28s 08 3 3m40s 1m13s 09 3 5m19s 1m46s 10 3 5m11s 1m43s 11 3 4m50s 1m36s 12 3 4m27s 1m29s 13 3 4m5s 1m21s 14 3 4m56s 1m38s 15 3 5m24s 1m48s 16 3 5m18s 1m46s 17 3 4m44s 1m34s 18 3 3m53s 1m17s 19 3 3m48s 1m16s 20 3 4m35s 1m31s 21 3 3m43s 1m14s 22 3 3m42s 1m14s [ User: intelifix - Total duration: 1h12m8s - Times executed: 48 ]
[ Application: psql - Total duration: 1h12m8s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-02 15:19:03 Duration: 4m35s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-02 16:18:35 Duration: 4m26s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-02 09:19:26 Duration: 4m22s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-02.log
4 20s281ms 1m27s 53s663ms 2 1m47s 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 Jul 02 23 2 1m47s 53s663ms [ User: intelifix - Total duration: 1m47s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m47s - 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-07-02 23:12:36 Duration: 1m27s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
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-07-02 23:47:25 Duration: 20s281ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-02.log
5 4s535ms 1m33s 46s758ms 4 3m7s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 02 20 2 1m39s 49s591ms 23 2 1m27s 43s926ms [ User: intelifix - Total duration: 3m7s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m7s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-02 20:09:03 Duration: 1m33s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-02 23:36:09 Duration: 1m23s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-02 20:10:55 Duration: 5s543ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-02.log
6 5s977ms 1m30s 38s143ms 3 1m54s copy auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 02 23 3 1m54s 38s143ms [ User: intelifix - Total duration: 1m54s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 1m54s - Times executed: 3 ]
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-02 23:14:06 Duration: 1m30s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-02 23:47:43 Duration: 18s142ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-02 23:36:44 Duration: 5s977ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-02.log
7 334ms 1m3s 28s496ms 4 1m53s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 02 20 2 1m4s 32s95ms 23 2 49s797ms 24s898ms [ User: intelifix - Total duration: 1m53s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m53s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-02 20:05:42 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-02 23:17:21 Duration: 49s462ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-02 20:10:19 Duration: 466ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-02.log
8 154ms 5m33s 21s764ms 291 1h45m33s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 02 07 18 9m10s 30s591ms 08 5 5m20s 1m4s 09 36 15m26s 25s732ms 10 33 7m34s 13s765ms 11 40 8m15s 12s398ms 12 6 59s881ms 9s980ms 13 23 3m11s 8s309ms 14 36 25m38s 42s744ms 15 32 9m43s 18s244ms 16 32 15m39s 29s353ms 17 28 4m28s 9s581ms 18 2 4s305ms 2s152ms [ User: intelifix - Total duration: 1h45m33s - Times executed: 291 ]
[ Application: [unknown] - Total duration: 1h45m33s - Times executed: 291 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026459, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-02 09:14:24 Duration: 5m33s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026504, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-02 14:43:04 Duration: 5m20s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026518, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-02 16:43:45 Duration: 5m15s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
9 9s197ms 32s104ms 12s23ms 70 14m1s create table temp0000284232 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 02 07 15 2m54s 11s656ms 08 6 1m10s 11s739ms 09 7 1m24s 12s89ms 10 5 57s912ms 11s582ms 11 3 39s62ms 13s20ms 14 17 3m22s 11s888ms 15 5 55s163ms 11s32ms 16 12 2m37s 13s121ms [ User: intelifix - Total duration: 14m1s - Times executed: 70 ]
[ Application: [unknown] - Total duration: 14m1s - Times executed: 70 ]
-
CREATE TABLE temp0000284232 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-02 07:22:36 Duration: 32s104ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
CREATE TABLE temp0000284232 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-02 16:36:28 Duration: 32s63ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
CREATE TABLE temp0000284232 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-02 14:37:38 Duration: 14s799ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
10 9s853ms 19s616ms 11s879ms 38 7m31s create table temp0000284272 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 02 08 3 44s178ms 14s726ms 09 16 3m10s 11s910ms 10 7 1m19s 11s349ms 11 9 1m42s 11s414ms 12 3 34s512ms 11s504ms [ User: intelifix - Total duration: 7m31s - Times executed: 38 ]
[ Application: [unknown] - Total duration: 7m31s - Times executed: 38 ]
-
CREATE TABLE temp0000284272 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-02 08:58:26 Duration: 19s616ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
CREATE TABLE temp0000284272 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-02 09:57:36 Duration: 14s163ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
CREATE TABLE temp0000284272 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-02 10:32:00 Duration: 13s911ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
11 9s826ms 13s940ms 11s449ms 16 3m3s create table temp0000284248 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 02 10 8 1m35s 11s993ms 11 2 21s868ms 10s934ms 12 6 1m5s 10s897ms [ User: intelifix - Total duration: 3m3s - Times executed: 16 ]
[ Application: [unknown] - Total duration: 3m3s - Times executed: 16 ]
-
CREATE TABLE temp0000284248 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-02 10:24:35 Duration: 13s940ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
CREATE TABLE temp0000284248 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-02 12:07:59 Duration: 13s627ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
CREATE TABLE temp0000284248 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-02 10:20:25 Duration: 12s288ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
12 9s383ms 13s840ms 11s351ms 36 6m48s create table temp0000284330 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 02 13 3 32s279ms 10s759ms 14 18 3m24s 11s357ms 15 15 2m51s 11s463ms [ User: intelifix - Total duration: 6m48s - Times executed: 36 ]
[ Application: [unknown] - Total duration: 6m48s - Times executed: 36 ]
-
CREATE TABLE temp0000284330 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-02 14:44:52 Duration: 13s840ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
CREATE TABLE temp0000284330 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-02 15:17:23 Duration: 13s791ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
CREATE TABLE temp0000284330 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-02 14:54:47 Duration: 13s370ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
13 9s287ms 11s232ms 10s299ms 14 2m24s create table temp0000284310 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 02 13 14 2m24s 10s299ms [ User: intelifix - Total duration: 2m24s - Times executed: 14 ]
[ Application: [unknown] - Total duration: 2m24s - Times executed: 14 ]
-
CREATE TABLE temp0000284310 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-02 13:32:44 Duration: 11s232ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
CREATE TABLE temp0000284310 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-02 13:24:56 Duration: 10s893ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
CREATE TABLE temp0000284310 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-02 13:26:05 Duration: 10s757ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
14 1s324ms 11s443ms 3s366ms 164 9m12s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 02 07 4 7s294ms 1s823ms 08 12 33s100ms 2s758ms 09 28 1m11s 2s570ms 10 41 1m32s 2s259ms 11 8 23s890ms 2s986ms 12 6 19s418ms 3s236ms 13 3 13s89ms 4s363ms 14 11 42s969ms 3s906ms 15 18 1m44s 5s788ms 16 15 1m2s 4s137ms 17 18 1m21s 4s525ms [ User: intelifix - Total duration: 9m12s - Times executed: 164 ]
[ Application: [unknown] - Total duration: 9m12s - Times executed: 164 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-02', 0175, '', '', 0, 6, '2026-07-01');
Date: 2026-07-02 14:30:36 Duration: 11s443ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-02', 0302, '', '', 0, 6, '2026-07-02');
Date: 2026-07-02 08:34:48 Duration: 11s149ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-02', 0302, '', '', 0, 6, '2026-07-02');
Date: 2026-07-02 16:28:02 Duration: 11s80ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
15 174ms 11s155ms 2s657ms 161 7m7s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 02 00 6 20s142ms 3s357ms 01 6 8s562ms 1s427ms 02 4 6s827ms 1s706ms 03 5 9s383ms 1s876ms 04 6 10s260ms 1s710ms 05 5 4s669ms 933ms 06 5 6s742ms 1s348ms 07 10 28s986ms 2s898ms 08 12 45s204ms 3s767ms 09 12 50s792ms 4s232ms 10 11 38s928ms 3s538ms 11 12 43s309ms 3s609ms 12 12 36s782ms 3s65ms 13 6 2s742ms 457ms 14 12 35s665ms 2s972ms 15 12 38s980ms 3s248ms 16 10 20s377ms 2s37ms 17 4 2s332ms 583ms 21 5 7s710ms 1s542ms 22 6 9s440ms 1s573ms [ User: intelifix - Total duration: 7m7s - Times executed: 161 ]
[ Application: psql - Total duration: 7m7s - Times executed: 161 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-02 00:05:12 Duration: 11s155ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-02 10:05:10 Duration: 9s791ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-02 09:35:10 Duration: 8s878ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-02.log
16 158ms 14s89ms 2s74ms 82 2m50s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 02 07 13 9s480ms 729ms 10 10 5s883ms 588ms 11 12 12s799ms 1s66ms 13 11 11s821ms 1s74ms 14 8 34s952ms 4s369ms 15 6 4s157ms 692ms 16 14 1m7s 4s823ms 17 8 23s452ms 2s931ms [ User: intelifix - Total duration: 2m50s - Times executed: 82 ]
[ Application: [unknown] - Total duration: 2m50s - Times executed: 82 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (042960) LIMIT 1;
Date: 2026-07-02 14:20:33 Duration: 14s89ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0126601) LIMIT 1;
Date: 2026-07-02 16:34:56 Duration: 12s584ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (042959) LIMIT 1;
Date: 2026-07-02 14:20:54 Duration: 8s407ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
17 150ms 8s505ms 1s825ms 235 7m9s call rs_giga_triagem (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 02 00 11 22s718ms 2s65ms 01 12 15s158ms 1s263ms 02 12 15s595ms 1s299ms 03 12 22s861ms 1s905ms 04 10 14s618ms 1s461ms 05 12 14s895ms 1s241ms 06 11 15s519ms 1s410ms 07 12 16s529ms 1s377ms 08 12 16s556ms 1s379ms 09 12 20s91ms 1s674ms 10 11 19s448ms 1s768ms 11 12 19s339ms 1s611ms 12 10 17s21ms 1s702ms 13 12 16s884ms 1s407ms 14 12 21s35ms 1s752ms 15 11 22s300ms 2s27ms 16 7 21s326ms 3s46ms 17 7 19s183ms 2s740ms 18 9 20s62ms 2s229ms 19 7 18s464ms 2s637ms 20 7 23s905ms 3s415ms 21 7 17s922ms 2s560ms 22 7 17s634ms 2s519ms [ User: intelifix - Total duration: 7m9s - Times executed: 235 ]
[ Application: psql - Total duration: 7m9s - Times executed: 235 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-02 03:05:24 Duration: 8s505ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-02 00:05:20 Duration: 7s895ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-02 20:15:08 Duration: 7s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-02.log
18 196ms 7s720ms 1s179ms 72 1m24s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 02 07 5 2s641ms 528ms 08 3 8s477ms 2s825ms 09 9 26s521ms 2s946ms 10 9 4s919ms 546ms 11 5 6s697ms 1s339ms 12 5 5s673ms 1s134ms 13 12 3s551ms 295ms 14 11 12s213ms 1s110ms 15 6 9s866ms 1s644ms 16 4 1s956ms 489ms 17 3 2s379ms 793ms [ User: intelifix - Total duration: 1m24s - Times executed: 72 ]
[ Application: psql - Total duration: 1m24s - Times executed: 72 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026457);
Date: 2026-07-02 08:58:44 Duration: 7s720ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026464);
Date: 2026-07-02 09:35:58 Duration: 7s705ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT RS_SETGLOBAL ('USUARIO', 309); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026460);
Date: 2026-07-02 09:08:52 Duration: 6s928ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-02.log
19 150ms 4s72ms 694ms 1,415 16m22s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 02 07 8 5s521ms 690ms 08 93 1m8s 733ms 09 244 3m13s 794ms 10 212 2m21s 666ms 11 178 1m52s 631ms 12 103 43s892ms 426ms 13 76 54s439ms 716ms 14 108 1m13s 679ms 15 152 2m 793ms 16 166 1m50s 668ms 17 75 58s208ms 776ms [ User: intelifix - Total duration: 16m22s - Times executed: 1415 ]
[ Application: [unknown] - Total duration: 16m22s - Times executed: 1415 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (44649, 413, '834165924002271,241607449396,241689091417,241668209906,241712565458,241604730614,241614526586,241676854566,241715478201,241726980525,241676635779,241598883960,241654211324,241649687391,241656710513,241727112232,241593301328,241637733453,241617872738,241668222736,241659831940,241617341620,241689083234,241676826280,241689088890,241726911326,241694974258,241695614657,241598871939,241620761617,241668219705,241620774749', '',0321,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-02 16:17:43 Duration: 4s72ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (260741, 503, '834072911001118,230048942745,241629889915,241674600811,241649146676,241670414667,241649143040,241603057778,241674596971,241596110424,241629250931,241629276263,241596610203,241649284950,241597914662,241669680421,241617966787,230047994257,241734098503,241669597785,241631641725,241616070217,241601028287,241670366480,241674259206,241714001424,230043531622,241695507272,241607747484,241619940112,241609298286,241700696073,241677872028,230040455979,241730550211,241696905355,241661014041,241693006467,241664259093,230043577282,241667255155', '',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-07-02 09:31:11 Duration: 3s798ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (260497, 450, 'ZTE3ANNR9W03441,D89A0DA8ACC9,D89A0DA8ACCA,ZTEGDB161F1C$ZTE3ANNT3F12578,D83139965294,D83139965295,ZTEGDD31BDC9$ZTE3ANNQ3R20718,3CF9F0A4655A,3CF9F0A4655B,ZTEGD64050ED$ZTE3ANNR6R28514,48D68238210E,48D68238210F,ZTEGDB019A35$ZTE3ANNT3J10024,D83139A0D642,D83139A0D643,ZTEGDD337E66$ZTE3ANNQ4N11993,3CF9F0A9AAC4,3CF9F0A9AAC5,ZTEGD64131D4$ZTE3ANNR8C09792,3891484F6C87,3891484F6C88,ZTEGDB08A6B0$ZTE3ANNRC575850,6C11BA691B93,6C11BA691B94,ZTEGDC6F3E09$ZTE3ANNR9F18291,D89A0DA48A95,D89A0DA48A96,ZTEGDB156EBE$ZTE3ANNRAM42290,5872C98B1765,5872C98B1766,ZTEGDC60A531$ZTE3ANNR4N06384,4896D955F0B8,4896D955F0B9,ZTEGD97F38B5$ZTE3ANNR9F36828,D89A0DA63D0B,D89A0DA63D0C,ZTEGDB15B727$ZTE3ANNR8C33798,389148519F2B,389148519F2C,ZTEGDB090476$ZTE3ANNQCA53023,14CA56D71F95,14CA56D71F96,ZTEGD972348A$ZTE3ANNR7B32483,3891484BE5F9,3891484BE5FA,ZTEGDB081043$ZTE3ANNR6R55131,48D6823A90E4,48D6823A90E5,ZTEGDB02022E$ZTE3ANNRCB62520,D8313923884E,D8313923884F,ZTEGDD2AA9CD$ZTE3ANNQ4406896,3CF9F0AC007E,3CF9F0AC007F,ZTEGD6419573$ZTE3ANNT3J12457,D83139A10F48,D83139A10F49,ZTEGDD3387E7$ZTE3ANNR8C26943,38914850FE81,38914850FE82,ZTEGDB08E9AF$ZTE3ANNRB703099,5872C98E81D3,5872C98E81D4,ZTEGDC6136EE$ZTE3ANNT3H17894,D831399866FC,D831399866FD,ZTEGDD321685$ZTE3ANNR3Y38471,4896D9534662,4896D9534663,ZTEGD97EC6FC$ZTE3ANNR1Y33264,14CA56CFB61B,14CA56CFB61C,ZTEGD970F84B$ZTE3ANNQ3R00907,3CF9F0A29508,3CF9F0A29509,ZTEGD640038A$ZTE3ANNQ6M07926,C4EBFF891B94,C4EBFF891B95,ZTEGD70A0004$ZTE3ANNR4N60315,4896D95AE0BA,4896D95AE0BB,ZTEGD9800B60$ZTE3ANNQ3R00778,3CF9F0A29202,3CF9F0A29203,ZTEGD6400309$ZTE3ANNQ8M06949,843C991F6AC9,843C991F6ACA,ZTEGD7BA6292$ZTE3ANNQ3613657,3CF9F0A61584,3CF9F0A61585,ZTEGD64098F4$ZTE3ANNR6R57229,48D6823AC210,48D6823AC211,ZTEGDB020A60$ZTE3ANNT3J12691,D83139A114C4,D83139A114C5,ZTEGDD3388D1$ZTE3ANNQ6M08449,C4EBFF8927D6,C4EBFF8927D7,ZTEGD70A020F$ZTE3ANNR3J06922,F4E84F86F09C,F4E84F86F09D,ZTEGD97B7CD4$ZTE3ANNR3Y21355,4896D951B53A,4896D951B53B,ZTEGD97E8420$ZTE3ANNRB721053,5872C990269F,5872C99026A0,ZTEGDC617D10$ZTE3ANNR4N24042,4896D9578E94,4896D9578E95,ZTEGD97F7DAF$ZTE3ANNT3H01646,D8313996EA2C,D8313996EA2D,ZTEGDD31D70D$ZTE3ANNT3H66951,D831399CE4C2,D831399CE4C3,ZTEGDD32D626$ZTE3ANNR3Y35442,4896D952FF64,4896D952FF65,ZTEGD97EBB27', '',0318,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-07-02 15:08:43 Duration: 3s387ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
20 354ms 996ms 569ms 110 1m2s select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 02 00 1 609ms 609ms 01 2 1s40ms 520ms 03 2 1s290ms 645ms 04 1 470ms 470ms 05 1 618ms 618ms 07 6 3s612ms 602ms 08 9 5s46ms 560ms 09 12 7s156ms 596ms 10 11 6s358ms 578ms 11 10 5s322ms 532ms 12 5 2s783ms 556ms 13 9 5s 555ms 14 13 6s912ms 531ms 15 11 7s274ms 661ms 16 10 5s504ms 550ms 17 5 2s638ms 527ms 18 1 473ms 473ms 21 1 529ms 529ms [ User: intelifix - Total duration: 1m2s - Times executed: 110 ]
[ Application: [unknown] - Total duration: 1m2s - Times executed: 110 ]
-
select * from rs_menu_grants (397, 18, 1);
Date: 2026-07-02 15:14:12 Duration: 996ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
select * from rs_menu_grants (418, 81, 1);
Date: 2026-07-02 15:52:38 Duration: 955ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
-
select * from rs_menu_grants (401, 18, 1);
Date: 2026-07-02 15:14:02 Duration: 829ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-02.log
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 11 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jul 01 12 1 0ms 0ms 14 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms Jul 02 17 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 2 0ms 0ms 22 1 0ms 0ms [ User: intelifix - Total duration: 6m18s - Times executed: 11 ]
[ Application: psql - Total duration: 6m16s - Times executed: 8 ]
[ Application: [unknown] - Total duration: 1s920ms - Times executed: 3 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 21,850 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 15 FATAL entries
- 5001 ERROR entries
- 0 WARNING entries
- 3 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 4,854 Max number of times the same event was reported
- 5,019 Total events found
Rank Times reported Error 1 4,854 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 02 00 59 01 60 02 59 03 55 04 60 05 59 06 106 07 292 08 443 09 598 10 575 11 580 12 208 13 143 14 394 15 420 16 263 17 133 18 59 19 60 20 59 21 60 22 59 23 50 - ERROR: prepared statement "_PLAN0000000029D52D90" does not exist
- ERROR: prepared statement "_PLAN0000000029C45FC0" does not exist
- ERROR: prepared statement "_PLAN0000000029CC4490" does not exist
Statement: DEALLOCATE "_PLAN0000000029D52D90"
Date: 2026-07-02 00:00:53 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-02.log
Statement: DEALLOCATE "_PLAN0000000029C45FC0"
Date: 2026-07-02 00:01:53 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-02.log
Statement: DEALLOCATE "_PLAN0000000029CC4490"
Date: 2026-07-02 00:02:54 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-02.log
2 45 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #2
Day Hour Count Jul 02 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: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-02 00:05:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-02.log
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-02 00:35:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-02.log
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-02 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-02.log
3 44 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #3
Day Hour Count Jul 02 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 2 22 3 - ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-02 08:00:05 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-02.log
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-02 08:20:09 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-02.log
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-02 08:40:06 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-02.log
4 17 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Jul 02 09 1 10 3 11 4 13 2 14 3 15 4 - ERROR: syntax error at or near ")" at character 88
- ERROR: syntax error at or near ")" at character 246
- ERROR: syntax error at or near ")" at character 246
Statement: SELECT INITCAP(TIPO) AS TIPO, INITCAP(SERIE) AS SERIE FROM RS_EQUIPAMENTO_ACESSORIOS(0,);
Date: 2026-07-02 09:40:49 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-02.log
Statement: SELECT * FROM RS_MODELO_MANUTENCAO(0455,'41001593',022,02,'12,15',0302,00,'',028,'','41001593',',,,',00,00,'TERMINAL EXTENSOR WIFI6 MESH H3621P',00,059,'7,6,2,8,3','','','S','S',030, 'MAC - EP,SN,,,,,,,3,1,0,0',0,'N','','','',)
Date: 2026-07-02 10:16:29 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-02.log
Statement: SELECT * FROM RS_MODELO_MANUTENCAO(0455,'41001593',022,02,'12,15',0302,00,'',028,'','41001593',',,,',00,00,'TERMINAL EXTENSOR WIFI6 MESH H3621P',00,059,'7,6,2,8,3','','','S','S',030, 'MAC - EP,SN,,,,,,,3,1,0,0',0,'N','','','',)
Date: 2026-07-02 10:16:46 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-02.log
5 10 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #5
Day Hour Count Jul 02 03 10 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-07-02 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-02.log
Date: 2026-07-02 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-02.log
Date: 2026-07-02 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-02.log
6 7 ERROR: record "..." has no field "..."
Times Reported Most Frequent Error / Event #6
Day Hour Count Jul 02 09 7 - ERROR: record "cret" has no field "li_id"
- ERROR: record "cret" has no field "li_id"
- ERROR: record "cret" has no field "li_id"
Context: PL/pgSQL function rs_baixa_checa_equipamento(integer,character varying,integer) line 85 at SQL statement
Statement: SELECT * FROM RS_BAIXA_CHECA_EQUIPAMENTO(0358,'D06EDE984569',0129);Date: 2026-07-02 09:40:29 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-02.log
Context: PL/pgSQL function rs_baixa_checa_equipamento(integer,character varying,integer) line 85 at SQL statement
Statement: SELECT * FROM RS_BAIXA_CHECA_EQUIPAMENTO(0358,'D06EDE984569',0129);Date: 2026-07-02 09:40:34 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-02.log
Context: PL/pgSQL function rs_baixa_checa_equipamento(integer,character varying,integer) line 85 at SQL statement
Statement: SELECT * FROM RS_BAIXA_CHECA_EQUIPAMENTO(0358,'D06EDE984569',0129);Date: 2026-07-02 09:40:38 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-02.log
7 5 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #7
Day Hour Count Jul 02 09 3 14 2 - ERROR: trailing junk after numeric literal at or near "905851A23D8A" at character 27
- ERROR: trailing junk after numeric literal at or near "905851A23D8A" at character 27
- ERROR: trailing junk after numeric literal at or near "905851A23D8A" at character 27
Statement: SELECT * FROM RS_ETIQUETA(905851A23D8A)
Date: 2026-07-02 09:39:42 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-02.log
Statement: SELECT * FROM RS_ETIQUETA(905851A23D8A)
Date: 2026-07-02 09:39:42 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-02.log
Statement: SELECT * FROM RS_ETIQUETA(905851A23D8A)
Date: 2026-07-02 09:39:43 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-02.log
8 5 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #8
Day Hour Count Jul 02 05 4 09 1 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-02 05:32:04 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-02.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-02 05:32:04 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-02.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-02 05:32:04 Database: contagem Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-02.log
9 4 ERROR: malformed array literal: "..."
Times Reported Most Frequent Error / Event #9
Day Hour Count Jul 02 09 4 - ERROR: malformed array literal: "{0,0,0,0,}" at character 112
- ERROR: malformed array literal: "{0,0,0,0,}" at character 112
- ERROR: malformed array literal: "{0,0,0,0,}" at character 112
Detail: Unexpected "}" character.
Statement: SELECT WF_ID,WF_NOME FROM WORK_FLOWS WHERE WF_ID IN (SELECT UNNEST(RS_DEFINE_WORKFLOW) FROM RS_DEFINE_WORKFLOW('{0,0,0,0,}', 302 ));Date: 2026-07-02 09:40:25 Database: contagem Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-02.log
Detail: Unexpected "}" character.
Statement: SELECT WF_ID,WF_NOME FROM WORK_FLOWS WHERE WF_ID IN (SELECT UNNEST(RS_DEFINE_WORKFLOW) FROM RS_DEFINE_WORKFLOW('{0,0,0,0,}', 302 ));Date: 2026-07-02 09:40:30 Database: contagem Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-02.log
Detail: Unexpected "}" character.
Statement: SELECT WF_ID,WF_NOME FROM WORK_FLOWS WHERE WF_ID IN (SELECT UNNEST(RS_DEFINE_WORKFLOW) FROM RS_DEFINE_WORKFLOW('{0,0,0,0,}', 302 ));Date: 2026-07-02 09:40:33 Database: contagem Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-02.log
10 4 ERROR: function rs_lote_manutencao_itens(...) does not exist
Times Reported Most Frequent Error / Event #10
Day Hour Count Jul 02 09 4 - ERROR: function rs_lote_manutencao_itens(integer, integer, unknown, unknown, integer, integer, unknown, unknown, unknown, bigint) does not exist at character 15
- ERROR: function rs_lote_manutencao_itens(integer, integer, unknown, unknown, integer, integer, unknown, unknown, unknown, bigint) does not exist at character 15
- ERROR: function rs_lote_manutencao_itens(integer, integer, unknown, unknown, integer, integer, unknown, unknown, unknown, bigint) does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(44665,418,'929240182522,9C24722F5244$929240159099,A4224991DD5B$929240615939,2035431CBAD7$929240164049,A422499264B5$929240471507,D8CF6163FBA4$929240516263,203543121553$929240516293,203543121625$929240688248,20354354AFF8','',0302,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','',09247225244);Date: 2026-07-02 09:42:12 Database: contagem Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-02.log
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(44665,418,'929240182522,9C24722F5244$929240159099,A4224991DD5B$929240615939,2035431CBAD7$929240164049,A422499264B5$929240471507,D8CF6163FBA4$929240516263,203543121553$929240516293,203543121625$929240688248,20354354AFF8','',0302,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','',09247225244);Date: 2026-07-02 09:42:21 Database: contagem Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-02.log
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(44665,418,'929240182522,9C24722F5244$929240159099,A4224991DD5B$929240615939,2035431CBAD7$929240164049,A422499264B5$929240471507,D8CF6163FBA4$929240516263,203543121553$929240516293,203543121625$929240688248,20354354AFF8','',0302,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','',09247225244);Date: 2026-07-02 09:42:25 Database: contagem Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-02.log
11 4 ERROR: function rs_html_campo_checkbox(...) does not exist
Times Reported Most Frequent Error / Event #11
Day Hour Count Jul 02 08 4 - ERROR: function rs_html_campo_checkbox(unknown, unknown, unknown, unknown, integer, unknown) does not exist at character 11 2026-07-02 08:52:25 -03 [2283734]: [20-1] user=intelifix,db=brasilia,app=[unknown],client=[local] QUERY: cCampo := RS_HTML_CAMPO_CHECKBOX( 'check-0' , 'S' , '' , 'Todos', 0 , 'MostraCaixasModelo(0)' )
- ERROR: function rs_html_campo_checkbox(unknown, unknown, unknown, unknown, integer, unknown) does not exist at character 11 2026-07-02 08:52:38 -03 [2276428]: [57-1] user=intelifix,db=rio,app=[unknown],client=[local] QUERY: cCampo := RS_HTML_CAMPO_CHECKBOX( 'check-0' , 'S' , '' , 'Todos', 0 , 'MostraCaixasModelo(0)' )
- ERROR: function rs_html_campo_checkbox(unknown, unknown, unknown, unknown, integer, unknown) does not exist at character 11 2026-07-02 08:53:03 -03 [2276428]: [62-1] user=intelifix,db=rio,app=[unknown],client=[local] QUERY: cCampo := RS_HTML_CAMPO_CHECKBOX( 'check-0' , 'S' , '' , 'Todos', 0 , 'MostraCaixasModelo(0)' )
Context: PL/pgSQL function rs_lote_modelos_selecao(integer) line 25 at assignment
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT RS_LOTE_MODELOS_SELECAO( 126582 )Date: 2026-07-02 08:52:25 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-02.log
Context: PL/pgSQL function rs_lote_modelos_selecao(integer) line 25 at assignment
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT RS_LOTE_MODELOS_SELECAO( 260042 )Date: 2026-07-02 08:52:38 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-02.log
Context: PL/pgSQL function rs_lote_modelos_selecao(integer) line 25 at assignment
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT RS_LOTE_MODELOS_SELECAO( 260042 )Date: 2026-07-02 08:53:03 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-02.log
12 3 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #12
Day Hour Count Jul 02 11 1 17 2 - ERROR: column "cai_id" does not exist at character 39
- ERROR: column "serial" does not exist at character 8
- ERROR: column "serial" does not exist at character 8
Hint: Perhaps you meant to reference the column "temp0000226529.ofi_id".
Statement: SELECT * FROM temp0000226529 ORDER BY CAI_ID DESCDate: 2026-07-02 11:19:37 Database: contagem Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-02.log
Statement: SELECT "serial" FROM "public"."acessorios"
Date: 2026-07-02 17:28:54 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-02.log
Statement: SELECT "serial" FROM "public"."acessorios"
Date: 2026-07-02 17:34:42 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-02.log
13 3 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #13
Day Hour Count Jul 02 03 3 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-07-02 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-02.log
Date: 2026-07-02 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-02.log
Date: 2026-07-02 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-02.log
14 2 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #14
Day Hour Count Jul 02 10 2 - LOG: process 2390926 still waiting for AccessExclusiveLock on relation 1885916 of database 358220 after 1000.140 ms
- LOG: process 2407109 still waiting for AccessExclusiveLock on relation 1886975 of database 358220 after 1000.180 ms
Detail: Process holding the lock: 2407514. Wait queue: 2390926.
Statement: DROP TABLE IF EXISTS temp0000284248;Date: 2026-07-02 10:24:44 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-02.log
Detail: Process holding the lock: 2414517. Wait queue: 2407109.
Statement: DROP TABLE IF EXISTS temp0000284272;Date: 2026-07-02 10:32:45 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-02.log
15 2 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #15
Day Hour Count Jul 02 10 2 - ERROR: canceling autovacuum task
- ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000284248"
Date: 2026-07-02 10:24:44 Log file: /usr/local/pgsql/data/log/serverlog-02.log
Context: automatic vacuum of table "rio.public.temp0000284272"
Date: 2026-07-02 10:32:45 Log file: /usr/local/pgsql/data/log/serverlog-02.log
16 2 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #16
Day Hour Count Jul 02 00 1 06 1 - FATAL: database "testes" does not exist
- FATAL: database "testes" does not exist
Date: 2026-07-02 00:02:03 Database: testes Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-02.log
Date: 2026-07-02 06:02:03 Database: testes Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-02.log
17 2 ERROR: unterminated quoted identifier at or near ""..."
Times Reported Most Frequent Error / Event #17
Day Hour Count Jul 02 10 2 - ERROR: unterminated quoted identifier at or near ""}]}')" at character 95
- ERROR: unterminated quoted identifier at or near ""}]}');" at character 85
Statement: SELECT * FROM RS_LOTE_CONSISTE_SERIAL( '{"lote":"260718","seriais":[{"serial":""},{"serial":"'"}]}')
Date: 2026-07-02 10:33:40 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-02.log
Statement: SELECT * FROM RS_CASA_MASCARAS('{"modelo":"34","seriais":[{"serial":""},{"serial":"'"}]}');
Date: 2026-07-02 10:33:40 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-02.log
18 1 ERROR: invalid input syntax for type json PL/pgSQL function rs_resumo_tcia(...) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(...) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(...) line 48 at assignment
Times Reported Most Frequent Error / Event #18
Day Hour Count Jul 02 21 1 - ERROR: invalid input syntax for type json PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936...
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-02 21:00:09 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-02.log
19 1 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv' PL/Python function "...", line 21, in <module> os.chmod(...) PL/Python function "..." PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Times Reported Most Frequent Error / Event #19
Day Hour Count Jul 02 21 1 - ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv' PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Context: Traceback (most recent call last):
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-02 21:05:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-02.log
20 1 ERROR: unterminated quoted string at or near "..."
Times Reported Most Frequent Error / Event #20
Day Hour Count Jul 02 06 1 - ERROR: unterminated quoted string at or near "''');" at character 39
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''');
Date: 2026-07-02 06:55:57 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-02.log
21 1 ERROR: function rs_equipamento_excecoes() does not exist
Times Reported Most Frequent Error / Event #21
Day Hour Count Jul 02 09 1 - ERROR: function rs_equipamento_excecoes() does not exist at character 8
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT RS_EQUIPAMENTO_EXCECOES()Date: 2026-07-02 09:40:49 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-02.log
22 1 ERROR: invalid byte sequence for encoding
Times Reported Most Frequent Error / Event #22
Day Hour Count Jul 02 10 1 - ERROR: invalid byte sequence for encoding "UTF8": 0x92
Date: 2026-07-02 10:25:49 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-02.log
23 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #23
Day Hour Count Jul 02 03 1 - LOG: database system was shut down at 2026-07-02 03:05:01 -03
Date: 2026-07-02 03:05:02 Log file: /usr/local/pgsql/data/log/serverlog-02.log