pgBadger-
Global information
- Generated on Sat Jul 11 23:50:10 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 40,895 log entries in 8s
- Log start from 2026-07-10 00:00:41 to 2026-07-10 23:59:51
-
Overview
Global Stats
- 368 Number of unique normalized queries
- 6,010 Number of queries
- 7h43m54s Total query duration
- 2026-07-10 00:02:09 First query
- 2026-07-10 23:53:53 Last query
- 7 queries/s at 2026-07-10 10:36:38 Query peak
- 7h43m54s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 7h43m54s Execute total duration
- 3,769 Number of events
- 19 Number of unique normalized events
- 3,614 Max number of times the same event was reported
- 0 Number of cancellation
- 461 Total number of automatic vacuums
- 916 Total number of automatic analyzes
- 17 Number temporary file
- 234.27 MiB Max size of temporary file
- 137.49 MiB Average size of temporary file
- 396 Total number of sessions
- 8 sessions at 2026-07-10 10:56:44 Session peak
- 13d7h20m44s Total duration of sessions
- 48m23s Average duration of sessions
- 15 Average queries per session
- 1m10s Average queries duration per session
- 47m12s Average idle time per session
- 404 Total number of connections
- 5 connections/s at 2026-07-10 03:05:16 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 7 queries/s Query Peak
- 2026-07-10 10:36:38 Date
SELECT Traffic
Key values
- 7 queries/s Query Peak
- 2026-07-10 10:36:38 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-07-10 20:09:47 Date
Queries duration
Key values
- 7h43m54s 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 10 00 27 0ms 18s75ms 4s47ms 4s880ms 6s930ms 1m13s 01 29 0ms 4s216ms 1s186ms 4s45ms 5s556ms 5s829ms 02 19 0ms 4s401ms 1s761ms 3s963ms 5s710ms 6s332ms 03 26 0ms 4s909ms 1s530ms 5s12ms 6s49ms 8s931ms 04 30 0ms 4s561ms 1s382ms 4s821ms 6s162ms 10s163ms 05 30 0ms 9m1s 36s851ms 10s437ms 2m25s 9m1s 06 18 0ms 9s418ms 3s508ms 3s892ms 5s36ms 31s327ms 07 164 0ms 8m57s 6s574ms 19s132ms 1m44s 8m57s 08 577 151ms 7m1s 2s956ms 29s793ms 3m47s 7m47s 09 791 150ms 10m1s 3s420ms 1m53s 5m5s 10m15s 10 995 150ms 8m46s 2s848ms 1m56s 5m13s 8m52s 11 735 150ms 20m8s 6s355ms 1m56s 5m28s 34m55s 12 191 0ms 9m2s 8s282ms 27s884ms 4m20s 9m25s 13 476 0ms 7m 2s699ms 33s340ms 2m12s 7m56s 14 889 150ms 8m18s 1s683ms 33s249ms 1m31s 8m29s 15 225 0ms 8m4s 4s641ms 9s854ms 31s648ms 8m59s 16 133 0ms 5m49s 5s827ms 7s641ms 46s146ms 5m49s 17 184 0ms 6m45s 4s667ms 11s358ms 58s515ms 6m45s 18 23 0ms 6m10s 28s916ms 4s475ms 5s221ms 6m57s 19 21 0ms 5m48s 30s12ms 4s343ms 48s155ms 5m48s 20 117 0ms 7m23s 11s819ms 1m4s 1m52s 7m41s 21 34 0ms 6m14s 19s660ms 6s613ms 14s638ms 6m44s 22 27 0ms 5m36s 22s829ms 6s565ms 41s707ms 5m36s 23 249 0ms 1m47s 9s669ms 1m11s 1m27s 1m47s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 10 00 4 0 2s245ms 0ms 0ms 241ms 01 11 0 231ms 0ms 184ms 310ms 02 2 0 684ms 0ms 0ms 0ms 03 8 0 476ms 0ms 0ms 1s17ms 04 12 0 409ms 0ms 166ms 1s27ms 05 9 0 414ms 0ms 0ms 1s352ms 06 3 0 3s425ms 0ms 0ms 0ms 07 105 0 9s48ms 1s823ms 2s906ms 4m22s 08 445 0 3s139ms 8s797ms 16s461ms 5m59s 09 590 0 3s524ms 14s43ms 1m36s 5m59s 10 802 0 2s966ms 15s813ms 1m56s 7m20s 11 593 0 6s442ms 15s5ms 1m56s 9m8s 12 109 0 12s73ms 3s561ms 25s464ms 4m51s 13 362 0 2s842ms 5s899ms 9s481ms 3m55s 14 704 0 1s808ms 10s28ms 20s365ms 4m32s 15 168 0 5s813ms 4s704ms 6s726ms 4m22s 16 88 0 8s305ms 4s780ms 6s695ms 3m41s 17 109 0 7s384ms 4s123ms 8s439ms 3m47s 18 8 0 1m19s 0ms 0ms 3m35s 19 6 0 1m40s 0ms 0ms 3m24s 20 10 92 13s165ms 17s863ms 1m4s 3m43s 21 15 0 41s911ms 0ms 925ms 3m25s 22 6 0 1m35s 0ms 0ms 3m14s 23 17 232 9s669ms 1m3s 1m11s 1m33s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 10 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 10 00 0 0 0.00 0.00% 01 0 1 1.00 0.00% 02 0 1 1.00 0.00% 03 0 3 3.00 0.00% 04 0 3 3.00 0.00% 05 0 2 2.00 0.00% 06 0 0 0.00 0.00% 07 0 10 10.00 0.00% 08 0 13 13.00 0.00% 09 0 13 13.00 0.00% 10 0 17 17.00 0.00% 11 0 13 13.00 0.00% 12 0 9 9.00 0.00% 13 0 13 13.00 0.00% 14 0 14 14.00 0.00% 15 0 5 5.00 0.00% 16 0 4 4.00 0.00% 17 0 7 7.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 3 3.00 0.00% 22 0 0 0.00 0.00% 23 0 1 1.00 0.00% Day Hour Count Average / Second Jul 10 00 15 0.00/s 01 9 0.00/s 02 7 0.00/s 03 20 0.01/s 04 10 0.00/s 05 8 0.00/s 06 14 0.00/s 07 18 0.01/s 08 43 0.01/s 09 25 0.01/s 10 37 0.01/s 11 24 0.01/s 12 14 0.00/s 13 22 0.01/s 14 23 0.01/s 15 16 0.00/s 16 17 0.00/s 17 20 0.01/s 18 11 0.00/s 19 8 0.00/s 20 12 0.00/s 21 12 0.00/s 22 10 0.00/s 23 9 0.00/s Day Hour Count Average Duration Average idle time Jul 10 00 2 1h 59m5s 01 14 1h1m16s 1h1m13s 02 9 1h40s 1h36s 03 17 16m4s 16m1s 04 10 1h2m21s 1h2m17s 05 10 1h56s 59m5s 06 8 56m53s 56m45s 07 13 1h42s 59m19s 08 42 26m39s 25m58s 09 23 51m6s 49m8s 10 33 34m13s 32m47s 11 26 1h6m8s 1h3m8s 12 22 55m57s 54m45s 13 18 51m48s 50m37s 14 24 47m51s 46m49s 15 17 57m57s 56m55s 16 15 56m50s 55m59s 17 26 38m35s 38m2s 18 12 56m54s 55m58s 19 10 1h18s 59m15s 20 11 45m14s 43m8s 21 10 55m 53m53s 22 12 56m5s 55m13s 23 12 48m31s 45m11s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-07-10 03:05:16 Date
Connections per database
Key values
- rio Main Database
- 404 connections Total
Connections per user
Key values
- intelifix Main User
- 404 connections Total
-
Sessions
Simultaneous sessions
Key values
- 8 sessions Session Peak
- 2026-07-10 10:56:44 Date
Histogram of session times
Key values
- 290 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 396 sessions Total
Sessions per user
Key values
- intelifix Main User
- 396 sessions Total
Sessions per host
Key values
- [local] Main Host
- 396 sessions Total
Sessions per application
Key values
- [unknown] Main Application
- 396 sessions Total
Application Count Total Duration Average Duration [unknown] 333 12d4h43m53s 52m44s pgAdmin 4 - CONN:1234127 2 33s938ms 16s969ms pgAdmin 4 - CONN:1607422 2 34s753ms 17s376ms pgAdmin 4 - CONN:422009 1 2h21m9s 2h21m9s pgAdmin 4 - CONN:5931296 2 12s124ms 6s62ms pgAdmin 4 - CONN:5947888 2 2m21s 1m10s pgAdmin 4 - CONN:6436134 2 4s153ms 2s76ms pgAdmin 4 - CONN:6614787 2 10s575ms 5s287ms pgAdmin 4 - CONN:6696350 2 8s751ms 4s375ms pgAdmin 4 - CONN:6923804 2 6m52s 3m26s pgAdmin 4 - CONN:6999622 2 4s184ms 2s92ms pgAdmin 4 - CONN:8029579 2 1m15s 37s727ms pgAdmin 4 - DB:brasilia 6 3m14s 32s347ms pgAdmin 4 - DB:contagem 3 38s686ms 12s895ms pgAdmin 4 - DB:postgres 4 2h27m28s 36m52s pgAdmin 4 - DB:rio 5 2h33m37s 30m43s pg_dump 6 52m35s 8m45s postgres_fdw 1 35m3s 35m3s psql 17 17h30m45s 1h1m48s -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 28,563 buffers Checkpoint Peak
- 2026-07-10 11:34:34 Date
- 270.020 seconds Highest write time
- 0.143 seconds Sync time
Checkpoints Wal files
Key values
- 13 files Wal files usage Peak
- 2026-07-10 11:34:34 Date
Checkpoints distance
Key values
- 434.08 Mo Distance Peak
- 2026-07-10 11:34:34 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 10 00 18,241 645.849s 0.034s 645.934s 01 2,693 270.956s 0.074s 271.09s 02 1,586 159.638s 0.037s 159.725s 03 2,137 213.689s 0.061s 213.823s 04 2,942 295.983s 0.04s 296.091s 05 9,875 991.141s 0.078s 991.308s 06 4,372 269.338s 0.004s 269.35s 07 9,380 951.991s 0.176s 952.264s 08 43,177 3,025.82s 0.662s 3,026.699s 09 63,491 3,238.774s 0.695s 3,239.74s 10 78,771 3,238.47s 0.913s 3,239.691s 11 129,508 3,238.654s 0.747s 3,239.697s 12 32,869 2,177.401s 0.249s 2,177.823s 13 21,369 2,183.203s 0.517s 2,183.898s 14 48,135 3,238.464s 0.92s 3,239.678s 15 22,879 2,129.476s 0.27s 2,129.882s 16 10,948 1,102.943s 0.109s 1,103.149s 17 9,601 966.741s 0.153s 967.001s 18 821 82.331s 0.015s 82.379s 19 21 2.131s 0.004s 2.141s 20 2,531 333.544s 0.064s 333.631s 21 2,712 271.794s 0.032s 271.923s 22 2,485 249.204s 0.027s 249.283s 23 3,053 557.222s 0.012s 557.275s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 10 00 0 0 6 524 0.003s 0.006s 01 0 0 1 653 0.026s 0.009s 02 0 0 0 502 0.003s 0.009s 03 0 0 1 482 0.004s 0.01s 04 0 0 1 578 0.004s 0.01s 05 0 0 4 846 0.003s 0.009s 06 0 0 0 10 0.001s 0.001s 07 0 0 3 2,601 0.011s 0.011s 08 0 0 20 5,411 0.027s 0.012s 09 0 0 48 6,667 0.005s 0.012s 10 0 0 46 8,444 0.006s 0.012s 11 0 0 67 7,283 0.015s 0.012s 12 0 0 25 3,109 0.012s 0.012s 13 0 0 14 5,066 0.009s 0.012s 14 0 0 21 8,085 0.015s 0.012s 15 0 0 8 3,964 0.003s 0.012s 16 0 0 4 1,775 0.003s 0.012s 17 0 0 3 1,878 0.003s 0.012s 18 0 0 0 92 0.003s 0.006s 19 0 0 0 3 0.002s 0.002s 20 0 0 1 92 0.034s 0.004s 21 0 0 1 397 0.002s 0.009s 22 0 0 1 458 0.003s 0.007s 23 0 0 2 32 0.002s 0.007s Day Hour Count Avg time (sec) Jul 10 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 10 00 16,670.67 kB 48,768.67 kB 01 1,494.22 kB 26,437.89 kB 02 986.25 kB 11,293.62 kB 03 1,116.60 kB 2,386.80 kB 04 1,418.50 kB 2,427.60 kB 05 7,441.00 kB 15,396.11 kB 06 7,683.00 kB 12,327.00 kB 07 4,870.64 kB 9,208.00 kB 08 27,261.92 kB 33,620.25 kB 09 65,448.50 kB 97,608.50 kB 10 62,970.25 kB 111,048.67 kB 11 91,482.67 kB 141,773.17 kB 12 33,554.33 kB 112,802.83 kB 13 18,656.08 kB 48,137.58 kB 14 29,495.17 kB 49,119.67 kB 15 10,675.08 kB 44,335.67 kB 16 4,759.33 kB 16,511.92 kB 17 4,404.67 kB 9,658.92 kB 18 627.60 kB 5,143.80 kB 19 169.00 kB 3,741.00 kB 20 7,388.67 kB 15,832.33 kB 21 1,733.62 kB 9,773.00 kB 22 1,877.71 kB 5,468.29 kB 23 6,488.50 kB 13,010.00 kB -
Temporary Files
Size of temporary files
Key values
- 468.53 MiB Temp Files size Peak
- 2026-07-10 05:32:05 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-07-10 05:32:10 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 10 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.92 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 1 208.06 MiB 208.06 MiB 10 3 546.02 MiB 182.01 MiB 11 2 312.01 MiB 156.01 MiB 12 0 0 0 13 1 182.00 MiB 182.00 MiB 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 8 910.15 MiB 69.88 MiB 234.27 MiB 113.77 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-10 05:32:13 Duration: 1m30s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-10 05:32:05 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 4 728.02 MiB 182.00 MiB 182.01 MiB 182.01 MiB select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel (?);-
SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01522);
Date: 2026-07-10 10:07:26 Duration: 1m57s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01523);
Date: 2026-07-10 10:20:49 Duration: 1m55s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01524);
Date: 2026-07-10 10:31:36 Duration: 1m52s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
3 2 416.07 MiB 208.01 MiB 208.06 MiB 208.04 MiB select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026890);
Date: 2026-07-10 09:38:31 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026913);
Date: 2026-07-10 11:26:28 Duration: 1m15s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026914);
Date: 2026-07-10 11:29:44 Duration: 49s934ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
4 2 179.06 MiB 89.53 MiB 89.53 MiB 89.53 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-10 05:30:42 Duration: 40s957ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-10 05:30:39 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
5 1 104.00 MiB 104.00 MiB 104.00 MiB 104.00 MiB select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026914, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-07-10 11:50:43 Duration: 20m8s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026914, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-07-10 11:50:49 Duration: 8m53s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026887, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-10 08:47:26 Duration: 5m52s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
Queries generating the largest temporary files
Rank Size Query 1 234.27 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-10 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 234.27 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-10 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 208.06 MiB SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026890);[ Date: 2026-07-10 09:38:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 208.01 MiB SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026913);[ Date: 2026-07-10 11:26:25 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 182.01 MiB SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01523);[ Date: 2026-07-10 10:20:46 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
6 182.01 MiB SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01522);[ Date: 2026-07-10 10:07:23 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
7 182.00 MiB SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01524);[ Date: 2026-07-10 10:31:36 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
8 182.00 MiB SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01526);[ Date: 2026-07-10 13:43:41 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
9 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-07-10 11:27:34 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 89.53 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-10 05:30:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 89.53 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-10 05:30:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 77.35 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-10 05:32:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 77.28 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-10 05:32:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 77.27 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-10 05:32:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 69.95 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-10 05:32:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 69.88 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-10 05:32:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 69.88 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-10 05:32:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 12.38 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_07
Database rio - 2026-07-10 10:22:56 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 12.38 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_07
Database rio - 2026-07-10 10:22:56 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (106) Main table analyzed (database rio)
- 916 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 106 rio.pg_catalog.pg_class 53 rio.public.usuarios 49 rio.pg_catalog.pg_type 47 contagem.pg_catalog.pg_attribute 41 contagem.pg_catalog.pg_class 34 brasilia.pg_catalog.pg_attribute 32 rio.pg_catalog.pg_index 32 rio.public.temp0000285026 30 contagem.pg_catalog.pg_type 28 rio.pg_catalog.pg_depend 25 rio.public.temp0000284316 24 contagem.public.temp0000226575 23 rio.public.temp0000285016 22 rio.public.temp0000285004 20 contagem.pg_catalog.pg_index 19 rio.public.temp0000285022 16 contagem.pg_catalog.pg_depend 16 rio.public.temp0000285062 14 brasilia.pg_catalog.pg_class 14 rio.public.temp0000284992 13 rio.public.temp0000285006 13 rio.public.temp0000284996 13 rio.public.temp0000284664 12 brasilia.pg_catalog.pg_type 12 brasilia.public.temp0000235896 11 rio.public.temp0000285028 10 rio.public.temp0000284750 9 rio.public.temp0000285066 9 contagem.public.temp0000226597 8 rio.public.temp0000285080 8 brasilia.public.usuarios 8 brasilia.public.temp0000235910 8 rio.public.temp0000285010 7 brasilia.pg_catalog.pg_index 7 contagem.public.temp0000226599 7 contagem.public.nf_entrada 6 brasilia.public.temp0000235898 6 rio.public.temp0000285084 6 rio.public.temp0000284762 5 brasilia.pg_catalog.pg_depend 5 rio.public.temp0000285082 5 rio.public.temp0000285002 4 contagem.public.usuarios 4 rio.public.temp0000285020 4 rio.pg_catalog.pg_shdepend 4 rio.public.temp0000285030 4 brasilia.public.temp0000235894 4 rio.public.tmp_drill_0175 3 brasilia.public.temp0000235872 3 brasilia.pg_catalog.pg_shdepend 3 contagem.pg_catalog.pg_shdepend 2 template1.pg_catalog.pg_shdepend 2 rio.public.temp0000285068 2 rio.public.temp0000285064 2 contagem.public.temp0000226520 2 brasilia.public.temp0000235864 2 brasilia.public.temp0000235856 2 rio.public.temp0000285056 2 rio.public.temp0000285096 2 brasilia.public.temp0000235908 2 rio.public.temp0000285094 2 rio.public.temp0000285088 2 rio.public.temp0000285052 2 brasilia.public.temp0000235874 1 brasilia.public.temp0000235858 1 rio.public.temp0000285008 1 brasilia.public.temp0000235904 1 contagem.public.temp0000226601 1 rio.public.temp0000285000 1 brasilia.public.temp0000235890 1 rio.public.temp0000285070 1 rio.public.temp0000285046 1 rio.auditor.auditor_2026_07 1 brasilia.public.temp0000235900 1 brasilia.public.temp0000235924 1 postgres.pg_catalog.pg_shdepend 1 brasilia.public.temp0000235920 1 brasilia.public.temp0000235876 1 brasilia.public.temp0000235842 1 rio.public.temp0000285018 1 rio.public.temp0000285014 1 rio.public.temp0000284898 1 contagem.public.tmp_dias_226603 1 rio.public.temp0000285072 1 contagem.public.parametros 1 contagem.public.temp0000226553 1 rio.public.temp0000284994 1 Total 916 Vacuums per table
Key values
- pg_catalog.pg_attribute (65) Main table vacuumed on database rio
- 461 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 65 39 0 0 0 0 0 20,665 5,009 7,784,110 242 5,795 rio.pg_catalog.pg_class 47 20 0 0 0 0 0 3,630 1,042 1,582,113 59 223 rio.pg_catalog.pg_type 46 19 0 0 0 0 0 1,944 581 777,943 54 249 rio.pg_catalog.pg_index 25 12 0 0 0 0 0 736 203 192,924 33 76 rio.public.temp0000285016 22 0 0 0 0 0 0 17,200 101 1,030,837 0 0 contagem.pg_catalog.pg_attribute 18 18 0 0 0 0 0 10,764 2,104 4,125,055 22 519 rio.public.temp0000285026 17 0 0 0 0 0 0 4,367 181 412,195 0 0 rio.public.usuarios 17 6 0 0 0 0 0 132 56 125,918 2 4 contagem.pg_catalog.pg_class 14 14 0 0 0 0 0 2,639 490 815,181 12 33 rio.public.temp0000285062 14 0 0 0 0 0 0 8,261 47 495,256 0 0 rio.public.temp0000284664 12 0 0 0 0 0 0 315 66 27,817 0 0 contagem.pg_catalog.pg_type 11 11 0 0 0 0 0 1,052 286 462,392 11 28 rio.pg_catalog.pg_depend 10 10 0 0 0 0 0 2,780 1,125 1,586,209 61 672 brasilia.pg_catalog.pg_attribute 9 9 0 0 0 0 0 4,769 1,647 2,244,451 57 1,519 rio.public.temp0000284996 9 0 0 0 0 0 0 456 51 34,194 0 0 rio.public.tmp_drill_0175 9 3 0 0 0 0 0 699 38 168,330 1 47 contagem.pg_catalog.pg_index 8 8 0 0 0 0 0 418 119 125,671 7 10 rio.pg_catalog.pg_statistic 8 8 0 0 0 0 0 9,369 2,292 10,062,349 998 3,960 contagem.public.temp0000226597 7 0 0 0 0 0 0 721 137 208,589 0 0 contagem.public.temp0000226599 7 0 0 0 0 0 0 341 38 26,409 0 0 rio.public.temp0000284750 6 0 0 0 0 0 0 366 33 26,446 0 0 contagem.pg_catalog.pg_depend 6 6 0 0 0 0 0 1,613 447 905,859 9 80 contagem.public.usuarios 5 0 0 0 0 0 0 20 13 9,257 0 0 brasilia.pg_catalog.pg_class 4 4 0 0 0 0 0 791 325 473,145 22 61 rio.public.temp0000285030 4 0 0 0 0 0 0 90 50 53,172 0 0 rio.public.temp0000284762 4 0 0 0 0 0 0 372 24 25,590 0 0 template1.pg_catalog.pg_shdepend 3 3 0 0 0 0 0 534 216 440,423 43 110 postgres.pg_catalog.pg_shdepend 3 3 0 0 0 0 0 525 201 393,748 29 171 rio.pg_toast.pg_toast_2619 3 3 0 0 0 0 0 1,661 328 1,787,130 112 348 rio.public.temp0000285080 3 0 0 0 0 0 0 309 18 21,036 0 0 brasilia.pg_catalog.pg_type 3 3 0 0 0 0 0 321 138 177,453 20 93 rio.public.temp0000285064 2 0 0 0 0 0 0 1,649 7 98,432 0 0 rio.public.temp0000285096 2 0 0 0 0 0 0 3,292 8 195,434 0 0 rio.public.temp0000285056 2 0 0 0 0 0 0 3,288 8 195,198 0 0 rio.public.temp0000285068 2 0 0 0 0 0 0 1,649 7 98,432 0 0 rio.public.temp0000285094 2 0 0 0 0 0 0 3,292 8 195,434 0 0 brasilia.pg_catalog.pg_index 2 2 0 0 0 0 0 148 52 31,757 15 27 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 330 71 231,244 22 42 brasilia.public.temp0000235864 2 0 0 0 0 0 0 483 12 30,798 0 0 contagem.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 294 70 231,449 11 24 brasilia.pg_catalog.pg_statistic 2 2 0 0 0 0 0 3,339 286 1,224,071 201 1,860 contagem.pg_catalog.pg_statistic 2 2 0 0 0 0 0 3,249 696 2,481,742 535 3,652 rio.public.temp0000285052 2 0 0 0 0 0 0 3,288 8 195,198 0 0 brasilia.auditor.auditor_2026_07 1 0 0 0 0 0 0 16,680 11,159 15,402,732 2,728 50,553 contagem.public.nf_entrada 1 1 0 0 0 0 0 69 25 76,579 0 0 brasilia.public.temp0000235904 1 0 0 0 0 0 0 240 239 379,481 0 0 brasilia.public.temp0000235874 1 0 0 0 0 0 0 240 6 15,289 0 0 rio.public.temp0000285008 1 0 0 0 0 0 0 103 6 7,023 0 0 rio.public.temp0000285020 1 0 0 0 0 0 0 101 6 6,882 0 0 rio.public.temp0000285014 1 0 0 0 0 0 0 103 6 7,023 0 0 rio.public.temp0000285018 1 0 0 0 0 0 0 103 6 7,023 0 0 contagem.auditor.auditor_2026_07 1 0 0 0 0 0 0 9,625 8,796 10,708,766 388 10,344 brasilia.pg_catalog.pg_depend 1 1 0 0 0 0 0 490 212 248,241 18 338 rio.public.temp0000285084 1 0 0 0 0 0 0 117 6 7,880 0 0 contagem.public.temp0000226601 1 0 0 0 0 0 0 8 5 1,335 0 0 rio.public.temp0000285000 1 0 0 0 0 0 0 4 3 774 0 0 rio.public.temp0000285006 1 0 0 0 0 0 0 103 6 7,023 0 0 rio.public.temp0000285072 1 0 0 0 0 0 0 61 6 4,460 0 0 rio.public.temp0000285070 1 0 0 0 0 0 0 4 3 774 0 0 rio.public.temp0000285088 1 0 0 0 0 0 0 117 6 7,878 0 0 rio.auditor.auditor_2026_07 1 0 0 0 0 0 0 57,594 36,963 46,790,137 10,272 221,339 Total 461 211 0 0 0 0 0 207,923 76,098 115,489,691 15,984 302,177 Vacuum throughput per table
Key values
- auditor.auditor_2026_07 (12.38) 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.09 rio.pg_catalog.pg_class 0 0 0.62 rio.pg_catalog.pg_type 0 0 0.25 rio.pg_catalog.pg_index 0 0 0.13 rio.public.temp0000285016 0 0 0.79 contagem.pg_catalog.pg_attribute 0 0 1.42 rio.public.temp0000285026 0 0 0.37 rio.public.usuarios 0 0 0 contagem.pg_catalog.pg_class 0 0 0.55 rio.public.temp0000285062 0 0 0.69 rio.public.temp0000284664 0 0 0.15 contagem.pg_catalog.pg_type 0 0 0.31 rio.pg_catalog.pg_depend 0 0 0.84 brasilia.pg_catalog.pg_attribute 0 0 0.88 rio.public.temp0000284996 0 0 0.12 rio.public.tmp_drill_0175 0 0 0.03 contagem.pg_catalog.pg_index 0 0 0.21 rio.pg_catalog.pg_statistic 0 0 1.33 contagem.public.temp0000226597 0 0 0.1 contagem.public.temp0000226599 0 0 0.11 rio.public.temp0000284750 0 0 0.08 contagem.pg_catalog.pg_depend 0 0 0.27 contagem.public.usuarios 0 0 0 brasilia.pg_catalog.pg_class 0 0 0.2 rio.public.temp0000285030 0 0 0.06 rio.public.temp0000284762 0 0 0.08 template1.pg_catalog.pg_shdepend 0 0 0.2 postgres.pg_catalog.pg_shdepend 0 0 0.15 rio.pg_toast.pg_toast_2619 0 0 0.3 rio.public.temp0000285080 0 0 0.05 brasilia.pg_catalog.pg_type 0 0 0.08 rio.public.temp0000285064 0 0 0.11 rio.public.temp0000285096 0 0 0.1 rio.public.temp0000285056 0 0 0.11 rio.public.temp0000285068 0 0 0.1 rio.public.temp0000285094 0 0 0.1 brasilia.pg_catalog.pg_index 0 0 0.05 brasilia.pg_toast.pg_toast_2619 0 0 0.02 brasilia.public.temp0000235864 0 0 0.04 contagem.pg_toast.pg_toast_2619 0 0 0.01 brasilia.pg_catalog.pg_statistic 0 0 0.24 contagem.pg_catalog.pg_statistic 0 0 0.29 rio.public.temp0000285052 0 0 0.1 brasilia.auditor.auditor_2026_07 0 0 3.7 contagem.public.nf_entrada 0 0 0.02 brasilia.public.temp0000235904 0 0 0.04 brasilia.public.temp0000235874 0 0 0.02 rio.public.temp0000285008 0 0 0.02 rio.public.temp0000285020 0 0 0.02 rio.public.temp0000285014 0 0 0.01 rio.public.temp0000285018 0 0 0.02 contagem.auditor.auditor_2026_07 0 0 2.92 brasilia.pg_catalog.pg_depend 0 0 0.12 rio.public.temp0000285084 0 0 0.02 contagem.public.temp0000226601 0 0 0.02 rio.public.temp0000285000 0 0 0.05 rio.public.temp0000285006 0 0 0.02 rio.public.temp0000285072 0 0 0.02 rio.public.temp0000285070 0 0 0.05 rio.public.temp0000285088 0 0 0.02 rio.auditor.auditor_2026_07 0 0 12.38 Total 0 0 34.2 Tuples removed per table
Key values
- pg_catalog.pg_attribute (160919) Main table with removed tuples on database rio
- 353277 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 65 39 160,919 1,780,137 291,905 163 42,454 contagem.pg_catalog.pg_attribute 18 18 79,396 429,994 368 419 9,594 brasilia.pg_catalog.pg_attribute 9 9 30,763 201,577 0 173 5,049 rio.pg_catalog.pg_statistic 8 8 13,494 66,988 628 0 10,288 rio.public.tmp_drill_0175 9 3 9,811 16,770 3,324 0 348 rio.pg_catalog.pg_depend 10 10 8,684 198,092 8,750 0 1,870 rio.pg_catalog.pg_type 46 19 6,732 129,680 24,626 0 3,507 contagem.pg_catalog.pg_statistic 2 2 5,605 14,921 0 0 2,022 brasilia.pg_catalog.pg_statistic 2 2 4,992 15,501 0 0 2,144 contagem.pg_catalog.pg_depend 6 6 4,563 110,343 0 24 1,028 contagem.pg_catalog.pg_type 11 11 3,768 25,573 806 34 739 contagem.pg_catalog.pg_class 14 14 3,573 48,458 4 43 1,745 rio.pg_catalog.pg_index 25 12 3,516 55,386 7,292 0 1,425 rio.pg_catalog.pg_class 47 20 3,182 223,683 60,433 44 6,157 template1.pg_catalog.pg_shdepend 3 3 2,478 41,169 395 0 345 postgres.pg_catalog.pg_shdepend 3 3 2,357 41,484 781 0 345 contagem.pg_catalog.pg_index 8 8 2,262 15,185 0 8 416 brasilia.pg_catalog.pg_depend 1 1 1,600 17,607 0 0 187 rio.auditor.auditor_2026_07 1 0 1,140 7,217,895 0 0 338,630 rio.pg_toast.pg_toast_2619 3 3 1,027 2,007 6 10 859 brasilia.pg_catalog.pg_class 4 4 943 17,444 0 0 580 brasilia.pg_catalog.pg_type 3 3 753 6,665 4 17 201 brasilia.pg_catalog.pg_index 2 2 453 3,770 0 5 112 contagem.public.nf_entrada 1 1 293 924 0 0 69 contagem.public.usuarios 5 0 278 115 0 0 10 rio.public.usuarios 17 6 236 12,175 3,522 0 289 contagem.pg_toast.pg_toast_2619 2 2 232 248 0 0 128 brasilia.pg_toast.pg_toast_2619 2 2 227 274 0 0 140 brasilia.auditor.auditor_2026_07 1 0 0 1,777,607 0 0 75,820 rio.public.temp0000285064 2 0 0 46,273 0 0 3,328 brasilia.public.temp0000235904 1 0 0 3,092 0 24 232 contagem.public.temp0000226597 7 0 0 8,690 0 231 665 rio.public.temp0000285096 2 0 0 46,297 0 0 3,328 rio.public.temp0000285056 2 0 0 46,259 0 0 3,328 rio.public.temp0000285068 2 0 0 46,278 0 0 3,328 brasilia.public.temp0000235874 1 0 0 3,092 0 24 232 rio.public.temp0000285008 1 0 0 1,818 0 33 95 rio.public.temp0000285020 1 0 0 4,118 0 35 93 rio.public.temp0000285014 1 0 0 1,818 0 33 95 rio.public.temp0000284664 12 0 0 18,643 0 124 420 rio.public.temp0000285080 3 0 0 9,958 0 99 285 rio.public.temp0000285062 14 0 0 323,922 0 0 23,296 rio.public.temp0000285018 1 0 0 1,818 0 33 95 rio.public.temp0000284996 9 0 0 17,720 0 148 428 rio.public.temp0000285026 17 0 0 78,903 0 473 4,455 contagem.auditor.auditor_2026_07 1 0 0 1,035,867 0 0 45,781 rio.public.temp0000285094 2 0 0 46,300 0 0 3,328 rio.public.temp0000284750 6 0 0 16,055 0 188 356 contagem.public.temp0000226599 7 0 0 8,712 0 231 665 rio.public.temp0000285084 1 0 0 2,104 0 19 109 contagem.public.temp0000226601 1 0 0 1,248 0 33 95 rio.public.temp0000285030 4 0 0 5,706 0 64 128 rio.public.temp0000285000 1 0 0 23,128 0 0 1,664 rio.public.temp0000284762 4 0 0 15,079 0 172 340 rio.public.temp0000285006 1 0 0 1,818 0 33 95 rio.public.temp0000285072 1 0 0 1,018 0 11 53 brasilia.public.temp0000235864 2 0 0 6,184 0 48 464 rio.public.temp0000285016 22 0 0 317,387 0 284 22,500 rio.public.temp0000285070 1 0 0 23,139 0 0 1,664 rio.public.temp0000285088 1 0 0 2,105 0 19 109 rio.public.temp0000285052 2 0 0 46,234 0 0 3,328 Total 461 211 353,277 14,682,455 402,844 3,299 630,883 Pages removed per table
Key values
- public.temp0000285026 (473) Main table with removed pages on database rio
- 3299 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000285026 17 0 0 473 contagem.pg_catalog.pg_attribute 18 18 79396 419 rio.public.temp0000285016 22 0 0 284 contagem.public.temp0000226597 7 0 0 231 contagem.public.temp0000226599 7 0 0 231 rio.public.temp0000284750 6 0 0 188 brasilia.pg_catalog.pg_attribute 9 9 30763 173 rio.public.temp0000284762 4 0 0 172 rio.pg_catalog.pg_attribute 65 39 160919 163 rio.public.temp0000284996 9 0 0 148 rio.public.temp0000284664 12 0 0 124 rio.public.temp0000285080 3 0 0 99 rio.public.temp0000285030 4 0 0 64 brasilia.public.temp0000235864 2 0 0 48 rio.pg_catalog.pg_class 47 20 3182 44 contagem.pg_catalog.pg_class 14 14 3573 43 rio.public.temp0000285020 1 0 0 35 contagem.pg_catalog.pg_type 11 11 3768 34 rio.public.temp0000285008 1 0 0 33 rio.public.temp0000285014 1 0 0 33 rio.public.temp0000285018 1 0 0 33 contagem.public.temp0000226601 1 0 0 33 rio.public.temp0000285006 1 0 0 33 brasilia.public.temp0000235904 1 0 0 24 brasilia.public.temp0000235874 1 0 0 24 contagem.pg_catalog.pg_depend 6 6 4563 24 rio.public.temp0000285084 1 0 0 19 rio.public.temp0000285088 1 0 0 19 brasilia.pg_catalog.pg_type 3 3 753 17 rio.public.temp0000285072 1 0 0 11 rio.pg_toast.pg_toast_2619 3 3 1027 10 contagem.pg_catalog.pg_index 8 8 2262 8 brasilia.pg_catalog.pg_index 2 2 453 5 brasilia.auditor.auditor_2026_07 1 0 0 0 rio.public.temp0000285064 2 0 0 0 contagem.public.nf_entrada 1 1 293 0 rio.public.temp0000285096 2 0 0 0 template1.pg_catalog.pg_shdepend 3 3 2478 0 rio.public.temp0000285056 2 0 0 0 rio.public.temp0000285068 2 0 0 0 postgres.pg_catalog.pg_shdepend 3 3 2357 0 contagem.public.usuarios 5 0 278 0 rio.pg_catalog.pg_statistic 8 8 13494 0 rio.public.temp0000285062 14 0 0 0 rio.pg_catalog.pg_type 46 19 6732 0 rio.pg_catalog.pg_depend 10 10 8684 0 contagem.auditor.auditor_2026_07 1 0 0 0 brasilia.pg_catalog.pg_depend 1 1 1600 0 rio.public.temp0000285094 2 0 0 0 rio.public.tmp_drill_0175 9 3 9811 0 brasilia.pg_catalog.pg_class 4 4 943 0 rio.public.temp0000285000 1 0 0 0 rio.public.usuarios 17 6 236 0 brasilia.pg_toast.pg_toast_2619 2 2 227 0 contagem.pg_toast.pg_toast_2619 2 2 232 0 brasilia.pg_catalog.pg_statistic 2 2 4992 0 contagem.pg_catalog.pg_statistic 2 2 5605 0 rio.pg_catalog.pg_index 25 12 3516 0 rio.public.temp0000285070 1 0 0 0 rio.public.temp0000285052 2 0 0 0 rio.auditor.auditor_2026_07 1 0 1140 0 Total 461 211 353,277 3,299 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 10 00 0 0 01 0 4 02 0 0 03 0 0 04 0 4 05 6 7 06 0 0 07 5 13 08 40 101 09 62 138 10 78 172 11 149 143 12 39 39 13 20 77 14 42 144 15 10 35 16 5 13 17 2 23 18 0 1 19 0 0 20 0 0 21 3 2 22 0 0 23 0 0 - 12.38 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 2 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 1 8m45s 8m45s 8m45s 8m45s select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026914, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-07-10 11:50:43 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026914, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-07-10 11:50:49 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026887, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-10 08:47:26 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
2 1 5m36s 5m36s 5m36s 5m36s call rs_giga_processa_arquivos ();-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-10 11:50:43 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-10 00:05:11 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-10 11:35:10 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
Queries that waited the most
Rank Wait time Query 1 8m45s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026914, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');[ Date: 2026-07-10 11:50:43 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 5m36s CALL RS_GIGA_PROCESSA_ARQUIVOS ();[ Date: 2026-07-10 11:50:43 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Queries
Queries by type
Key values
- 4,186 Total read queries
- 1,354 Total write queries
Queries by database
Key values
- rio Main database
- 3,917 Requests
- 5h40m19s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 5,866 Requests
User Request type Count Duration etiquetas Total 34 6s470ms select 34 6s470ms intelifix Total 5,866 7h42m38s copy to 324 50m5s ddl 1,027 36m43s others 464 44m5s select 4,048 5h31m42s lenon Total 110 1m9s ddl 3 939ms others 3 3s66ms select 104 1m5s Duration by user
Key values
- 7h42m38s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 34 6s470ms select 34 6s470ms intelifix Total 5,866 7h42m38s copy to 324 50m5s ddl 1,027 36m43s others 464 44m5s select 4,048 5h31m42s lenon Total 110 1m9s ddl 3 939ms others 3 3s66ms select 104 1m5s Queries by host
Key values
- [local] Main host
- 6,004 Requests
- 7h43m50s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 5,016 Requests
- 4h21m18s (psql)
- Main time consuming application
Application Request type Count Duration [unknown] Total 5,016 2h32m23s ddl 1,027 36m43s select 3,986 1h55m38s pgAdmin 4 - CONN:1234127 Total 1 325ms ddl 1 325ms pgAdmin 4 - CONN:422009 Total 3 3s66ms others 3 3s66ms pgAdmin 4 - CONN:6696350 Total 1 328ms ddl 1 328ms pgAdmin 4 - CONN:6923804 Total 1 286ms ddl 1 286ms pg_dump Total 340 50m8s copy to 324 50m5s select 16 3s466ms psql Total 648 4h21m18s others 464 44m5s select 184 3h37m12s Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-10 14:14:23 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 3,369 100-500ms duration
Slowest individual queries
Rank Duration Query 1 20m8s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026914, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');[ Date: 2026-07-10 11:50:43 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 10m1s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-10 09:15:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 9m2s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-10 12:14:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 9m1s analyze verbose;[ Date: 2026-07-10 05:09:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 8m57s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-10 07:13:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 8m53s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026914, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');[ Date: 2026-07-10 11:50:49 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
7 8m52s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-10 11:13:54 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 8m46s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-10 10:13:47 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 8m18s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-10 14:13:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 8m4s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-10 15:13:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 7m23s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-10 20:12:24 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 7m1s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-10 08:12:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 7m SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-10 13:12:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 6m45s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-10 17:11:47 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 6m14s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-10 21:11:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 6m10s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-10 18:11:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m52s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026887, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-10 08:47:26 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
18 5m49s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-10 16:10:50 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 5m48s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-10 19:10:49 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 5m46s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026889, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-10 09:34:28 - 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 2h7m9s 48 1s230ms 10m1s 2m38s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 10 07 3 9m38s 3m12s 08 3 7m22s 2m27s 09 3 10m42s 3m34s 10 3 9m24s 3m8s 11 3 9m31s 3m10s 12 3 9m41s 3m13s 13 3 7m19s 2m26s 14 3 8m53s 2m57s 15 3 8m38s 2m52s 16 3 6m6s 2m2s 17 3 7m4s 2m21s 18 3 6m29s 2m9s 19 3 6m6s 2m2s 20 3 7m47s 2m35s 21 3 6m30s 2m10s 22 3 5m52s 1m57s [ User: intelifix - Total duration: 2h7m9s - Times executed: 48 ]
[ Application: psql - Total duration: 2h7m9s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-10 09:15:02 Duration: 10m1s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-10 12:14:03 Duration: 9m2s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-10 07:13:59 Duration: 8m57s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
2 1h16m1s 48 336ms 4m55s 1m35s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 10 07 3 5m10s 1m43s 08 3 4m22s 1m27s 09 3 6m6s 2m2s 10 3 5m51s 1m57s 11 3 5m58s 1m59s 12 3 5m9s 1m43s 13 3 4m27s 1m29s 14 3 5m18s 1m46s 15 3 5m7s 1m42s 16 3 4m9s 1m23s 17 3 4m15s 1m25s 18 3 4m3s 1m21s 19 3 3m54s 1m18s 20 3 4m31s 1m30s 21 3 3m53s 1m17s 22 3 3m40s 1m13s [ User: intelifix - Total duration: 1h16m1s - Times executed: 48 ]
[ Application: psql - Total duration: 1h16m1s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-10 11:20:22 Duration: 4m55s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-10 09:21:45 Duration: 4m53s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-10 10:20:12 Duration: 4m50s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
3 1h15m33s 243 154ms 20m8s 18s658ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 10 08 19 6m34s 20s740ms 09 39 10m1s 15s422ms 10 62 11m38s 11s260ms 11 32 40m46s 1m16s 12 8 5m7s 38s384ms 13 20 13s510ms 675ms 14 37 44s541ms 1s203ms 15 10 6s196ms 619ms 16 8 8s734ms 1s91ms 17 8 13s900ms 1s737ms [ User: intelifix - Total duration: 1h15m33s - Times executed: 243 ]
[ Application: [unknown] - Total duration: 1h15m33s - Times executed: 243 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026914, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-07-10 11:50:43 Duration: 20m8s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026914, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-07-10 11:50:49 Duration: 8m53s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026887, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-10 08:47:26 Duration: 5m52s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
4 15m37s 3 2m21s 9m1s 5m12s analyze verbose;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 10 05 3 15m37s 5m12s [ User: intelifix - Total duration: 15m37s - Times executed: 3 ]
[ Application: psql - Total duration: 15m37s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-10 05:09:03 Duration: 9m1s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
analyze verbose;
Date: 2026-07-10 05:13:18 Duration: 4m14s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
analyze verbose;
Date: 2026-07-10 05:15:39 Duration: 2m21s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
5 13m43s 1,166 151ms 4s905ms 706ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 10 07 23 12s724ms 553ms 08 99 1m37s 988ms 09 170 2m5s 736ms 10 192 2m3s 645ms 11 127 1m5s 518ms 12 30 29s319ms 977ms 13 132 1m23s 634ms 14 279 2m47s 599ms 15 81 1m14s 918ms 16 17 27s317ms 1s606ms 17 16 15s824ms 989ms [ User: intelifix - Total duration: 13m43s - Times executed: 1166 ]
[ Application: [unknown] - Total duration: 13m43s - Times executed: 1166 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (127617, 399, '225832679296', '',077,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-10 12:26:10 Duration: 4s905ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (263245, 503, '73009185850078312661,229823409296,229793467272,229704985360,229678393349,229798877082,229836025657,229709138593,216921865466,229711011022,229731244758,229711629094,229708462232,229733166382,229823837374,229832417987,229829504763,229715037878,229766442335,229880714048,229767201837,229676296477,229832381621,229676359413,229709109702,216928331227,229699539206,229729799498,229733430202,229777911120,229643904259,216949686475,229832798686,229822113952', '246622224355,246600249719,246508355262,246459445270,246617500909,246585834047,246540794152,246438766989,246535838809,246558835879,246544294965,246530451628,,246625886878,246248879298,246634148492,246551232545,246553576768,226272459602,246556752242,246493794144,226111746375,246499902743,246530451527,,246523767686,246550580304,246567286176,246592074555,246524298502,246448180423,246319792337,246625636472,,,,,,,', 0137, 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":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-07-10 08:31:33 Duration: 4s560ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (127617, 399, '215678823030', '',077,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-10 14:58:52 Duration: 4s101ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
6 11m36s 270 156ms 47s47ms 2s579ms call rs_giga_triagem (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 10 00 12 31s87ms 2s590ms 01 12 24s705ms 2s58ms 02 11 24s486ms 2s226ms 03 12 26s572ms 2s214ms 04 12 24s213ms 2s17ms 05 11 26s489ms 2s408ms 06 12 25s871ms 2s155ms 07 12 28s692ms 2s391ms 08 12 32s608ms 2s717ms 09 12 33s535ms 2s794ms 10 12 33s404ms 2s783ms 11 11 1m10s 6s444ms 12 12 27s972ms 2s331ms 13 12 28s838ms 2s403ms 14 11 29s706ms 2s700ms 15 12 29s387ms 2s448ms 16 11 25s744ms 2s340ms 17 12 27s6ms 2s250ms 18 11 27s84ms 2s462ms 19 12 26s738ms 2s228ms 20 12 36s289ms 3s24ms 21 12 26s869ms 2s239ms 22 12 28s229ms 2s352ms [ User: intelifix - Total duration: 11m36s - Times executed: 270 ]
[ Application: psql - Total duration: 11m36s - Times executed: 270 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-10 11:35:57 Duration: 47s47ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-10 20:05:11 Duration: 10s782ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-10 00:05:21 Duration: 9s733ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
7 10m29s 136 151ms 5m41s 4s627ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 10 00 6 16s825ms 2s804ms 01 6 7s148ms 1s191ms 02 6 7s609ms 1s268ms 03 5 9s198ms 1s839ms 04 6 12s347ms 2s57ms 05 5 5s807ms 1s161ms 07 4 4s171ms 1s42ms 08 6 18s127ms 3s21ms 09 14 36s767ms 2s626ms 10 12 37s755ms 3s146ms 11 11 6m10s 33s679ms 12 12 31s306ms 2s608ms 13 6 5s133ms 855ms 14 10 17s887ms 1s788ms 15 6 13s398ms 2s233ms 16 6 7s794ms 1s299ms 17 5 5s165ms 1s33ms 21 4 9s846ms 2s461ms 22 6 12s510ms 2s85ms [ User: intelifix - Total duration: 10m26s - Times executed: 133 ]
[ User: lenon - Total duration: 3s66ms - Times executed: 3 ]
[ Application: psql - Total duration: 10m26s - Times executed: 133 ]
[ Application: pgAdmin 4 - CONN:422009 - Total duration: 3s66ms - Times executed: 3 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-10 11:50:43 Duration: 5m41s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-10 00:05:11 Duration: 10s212ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-10 11:35:10 Duration: 8s817ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
8 8m54s 101 1s698ms 24s325ms 5s290ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 10 07 2 9s856ms 4s928ms 08 5 32s658ms 6s531ms 09 9 1m33s 10s396ms 10 5 42s304ms 8s460ms 11 18 1m6s 3s709ms 12 4 32s522ms 8s130ms 13 5 26s145ms 5s229ms 14 5 58s813ms 11s762ms 15 10 41s855ms 4s185ms 16 17 57s467ms 3s380ms 17 21 1m12s 3s447ms [ User: intelifix - Total duration: 8m54s - Times executed: 101 ]
[ Application: [unknown] - Total duration: 8m54s - Times executed: 101 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-10', 0320, '', '', 0, 6, '2026-07-01');
Date: 2026-07-10 10:50:20 Duration: 24s325ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-10', 0173, '', '', 0, 6, '2026-07-01');
Date: 2026-07-10 09:23:40 Duration: 23s793ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-10', 0395, '', '', 0, 6, '2026-07-01');
Date: 2026-07-10 12:18:23 Duration: 23s398ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
9 8m44s 973 150ms 6s807ms 538ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 10 07 46 26s748ms 581ms 08 159 1m43s 650ms 09 143 1m20s 566ms 10 176 1m22s 468ms 11 137 1m5s 477ms 12 4 1s740ms 435ms 13 82 47s884ms 583ms 14 153 1m18s 511ms 15 23 12s465ms 541ms 16 22 12s128ms 551ms 17 28 12s763ms 455ms [ User: intelifix - Total duration: 8m44s - Times executed: 973 ]
[ Application: [unknown] - Total duration: 8m44s - Times executed: 973 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "104675", "modelo" : "320", "itens" : "241619375555,241618310615,241618190626,241620631526,241618196080,241609333139,241628320627,241628236476,241597377078,241620557982,241599445967,241619800222,241629544348,241603567985,241593957081,241618170826,241628300322,241593088400,241607654546,241618295764,241630913135,241619412024,241619225866,241619295267,241628183744,241594106366,241631039208,241604000509,241608834852,241616118403,241593045365,241603984951,241594141724,241603577683,241593831032,241603993942,241618307381,241595333849,241598138500", "usuario" : "414", "caixa" : "1226793", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-10 08:49:04 Duration: 6s807ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "265154", "modelo" : "454", "itens" : "241624556880,241642239403,241626567581,241614368489,241624443132,241632704365,241641434061,241624945156,241613351029,241613413335,241627202728,241632660624,241627546375,241644867594,241614409706,241613871416,241644158097,241613366181,241624962027,241633754153,241642261931,241612958082,241626622638,241625033549,241624937983,241641880929,241640661326,241633664548,241642553149,241640540102,241633719199,241627014146,241624641031,241626777377,241644791325,241642552745,241613267181,241633664043,241633359513,241623701029,241627147795,241641890728,241632647490,241633958796,241611766485,241643831018,241626320611,241644152037", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-10 13:33:36 Duration: 2s61ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "264824", "modelo" : "320", "itens" : "241715485474,241631458294,241603064042,241622605354,241653474753,241677624955,241677757897,241654971230,241596231827,241679563551,230040444968,241689036585,241610018794,241604720512,241730393854,241703965674,241655017294,241598129206,241710309705,241607387696,230048376471,241669512222,241726978706,241620874557,241654292443,241646438904,241677671122,241594077575,241703833338,241665816990,241676828200,241654491430,241653216770,241676546073,241673341025,241703746988,241677680719,241635578090,230048991212,241649236988,241637494462,241673244247,241700029308,241637492341,241658203251,241667021216,230048896073,241701730406", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-10 08:45:27 Duration: 1s975ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
10 7m56s 9 1s189ms 1m57s 52s958ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 10 08 1 1s943ms 1s943ms 09 2 6s725ms 3s362ms 10 5 6m 1m12s 13 1 1m47s 1m47s [ User: intelifix - Total duration: 7m56s - Times executed: 9 ]
[ Application: psql - Total duration: 7m56s - Times executed: 9 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01522);
Date: 2026-07-10 10:07:26 Duration: 1m57s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01523);
Date: 2026-07-10 10:20:49 Duration: 1m55s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01524);
Date: 2026-07-10 10:31:36 Duration: 1m52s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
11 7m42s 35 9s499ms 36s675ms 13s212ms create table temp0000285016 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 10 08 6 1m35s 15s992ms 09 6 1m26s 14s400ms 10 15 3m4s 12s323ms 11 3 41s344ms 13s781ms 12 5 53s903ms 10s780ms [ User: intelifix - Total duration: 7m42s - Times executed: 35 ]
[ Application: [unknown] - Total duration: 7m42s - Times executed: 35 ]
-
CREATE TABLE temp0000285016 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-10 08:38:40 Duration: 36s675ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
CREATE TABLE temp0000285016 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-10 09:26:44 Duration: 22s773ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
CREATE TABLE temp0000285016 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-10 11:23:31 Duration: 15s368ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
12 4m34s 42 218ms 1m24s 6s541ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 10 08 2 1s401ms 700ms 09 14 1m28s 6s318ms 10 7 3s588ms 512ms 11 8 2m24s 18s86ms 12 5 32s937ms 6s587ms 13 4 1s393ms 348ms 14 2 2s252ms 1s126ms [ User: intelifix - Total duration: 4m34s - Times executed: 42 ]
[ Application: psql - Total duration: 4m34s - Times executed: 42 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026890);
Date: 2026-07-10 09:38:31 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026913);
Date: 2026-07-10 11:26:28 Duration: 1m15s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026914);
Date: 2026-07-10 11:29:44 Duration: 49s934ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
13 4m15s 21 9s735ms 14s78ms 12s153ms create table temp0000285062 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 10 11 12 2m23s 11s924ms 12 9 1m52s 12s458ms [ User: intelifix - Total duration: 4m15s - Times executed: 21 ]
[ Application: [unknown] - Total duration: 4m15s - Times executed: 21 ]
-
CREATE TABLE temp0000285062 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-10 12:01:29 Duration: 14s78ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
CREATE TABLE temp0000285062 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-10 12:02:10 Duration: 13s877ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
CREATE TABLE temp0000285062 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-10 11:21:10 Duration: 13s434ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
14 3m56s 19 10s516ms 14s990ms 12s434ms create table temp0000285026 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 10 09 17 3m34s 12s612ms 11 2 21s847ms 10s923ms [ User: intelifix - Total duration: 3m56s - Times executed: 19 ]
[ Application: [unknown] - Total duration: 3m56s - Times executed: 19 ]
-
CREATE TABLE temp0000285026 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-10 09:53:45 Duration: 14s990ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
CREATE TABLE temp0000285026 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-10 09:51:29 Duration: 13s720ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
CREATE TABLE temp0000285026 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-10 09:38:25 Duration: 13s607ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
15 3m21s 4 4s380ms 1m44s 50s359ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 10 20 2 1m49s 54s737ms 23 2 1m31s 45s980ms [ User: intelifix - Total duration: 3m21s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m21s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-10 20:09:45 Duration: 1m44s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-10 23:38:59 Duration: 1m27s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-10 20:11:38 Duration: 5s213ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-10.log
16 2m6s 4 408ms 1m14s 31s602ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 10 20 2 1m14s 37s415ms 23 2 51s576ms 25s788ms [ User: intelifix - Total duration: 2m6s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m6s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-10 20:06:07 Duration: 1m14s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-10 23:18:31 Duration: 51s168ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-10 20:11:05 Duration: 548ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-10.log
17 1m58s 30 770ms 12s869ms 3s933ms call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 10 08 2 14s842ms 7s421ms 09 2 18s839ms 9s419ms 10 2 10s312ms 5s156ms 11 1 12s869ms 12s869ms 12 2 11s45ms 5s522ms 13 1 1s97ms 1s97ms 14 3 23s215ms 7s738ms 15 3 10s759ms 3s586ms 16 2 2s199ms 1s99ms 17 3 3s53ms 1s17ms 18 1 1s128ms 1s128ms 19 2 1s546ms 773ms 20 1 2s16ms 2s16ms 21 2 2s272ms 1s136ms 22 3 2s801ms 933ms [ User: intelifix - Total duration: 1m58s - Times executed: 30 ]
[ Application: psql - Total duration: 1m58s - Times executed: 30 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-10 11:00:14 Duration: 12s869ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-10 09:40:13 Duration: 12s71ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-10 14:40:10 Duration: 9s462ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
18 1m54s 87 162ms 8s848ms 1s313ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 10 08 3 1s509ms 503ms 09 9 2s700ms 300ms 10 28 49s136ms 1s754ms 11 9 20s79ms 2s231ms 13 8 8s372ms 1s46ms 14 22 21s769ms 989ms 15 3 5s592ms 1s864ms 16 3 3s671ms 1s223ms 17 2 1s462ms 731ms [ User: intelifix - Total duration: 1m54s - Times executed: 87 ]
[ Application: [unknown] - Total duration: 1m54s - Times executed: 87 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (045285) LIMIT 1;
Date: 2026-07-10 10:23:58 Duration: 8s848ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (045286) LIMIT 1;
Date: 2026-07-10 10:55:59 Duration: 5s510ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (045288) LIMIT 1;
Date: 2026-07-10 10:11:11 Duration: 4s706ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
19 1m47s 1 1m47s 1m47s 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 #19
Day Hour Count Duration Avg duration Jul 10 23 1 1m47s 1m47s [ User: intelifix - Total duration: 1m47s - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1m47s - Times executed: 1 ]
-
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-10 23:13:08 Duration: 1m47s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-10.log
20 1m42s 17 4s546ms 7s469ms 6s15ms create table temp0000285016 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 10 08 6 36s309ms 6s51ms 09 4 25s43ms 6s260ms 10 7 40s918ms 5s845ms [ User: intelifix - Total duration: 1m42s - Times executed: 17 ]
[ Application: [unknown] - Total duration: 1m42s - Times executed: 17 ]
-
CREATE TABLE temp0000285016 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-07-2026", "ate" :"10-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-10 09:43:12 Duration: 7s469ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
CREATE TABLE temp0000285016 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-07-2026", "ate" :"10-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-10 10:00:22 Duration: 6s951ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
CREATE TABLE temp0000285016 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-07-2026", "ate" :"10-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-10 08:55:44 Duration: 6s941ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,166 13m43s 151ms 4s905ms 706ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 10 07 23 12s724ms 553ms 08 99 1m37s 988ms 09 170 2m5s 736ms 10 192 2m3s 645ms 11 127 1m5s 518ms 12 30 29s319ms 977ms 13 132 1m23s 634ms 14 279 2m47s 599ms 15 81 1m14s 918ms 16 17 27s317ms 1s606ms 17 16 15s824ms 989ms [ User: intelifix - Total duration: 13m43s - Times executed: 1166 ]
[ Application: [unknown] - Total duration: 13m43s - Times executed: 1166 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (127617, 399, '225832679296', '',077,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-10 12:26:10 Duration: 4s905ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (263245, 503, '73009185850078312661,229823409296,229793467272,229704985360,229678393349,229798877082,229836025657,229709138593,216921865466,229711011022,229731244758,229711629094,229708462232,229733166382,229823837374,229832417987,229829504763,229715037878,229766442335,229880714048,229767201837,229676296477,229832381621,229676359413,229709109702,216928331227,229699539206,229729799498,229733430202,229777911120,229643904259,216949686475,229832798686,229822113952', '246622224355,246600249719,246508355262,246459445270,246617500909,246585834047,246540794152,246438766989,246535838809,246558835879,246544294965,246530451628,,246625886878,246248879298,246634148492,246551232545,246553576768,226272459602,246556752242,246493794144,226111746375,246499902743,246530451527,,246523767686,246550580304,246567286176,246592074555,246524298502,246448180423,246319792337,246625636472,,,,,,,', 0137, 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":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-07-10 08:31:33 Duration: 4s560ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (127617, 399, '215678823030', '',077,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-10 14:58:52 Duration: 4s101ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
2 973 8m44s 150ms 6s807ms 538ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 10 07 46 26s748ms 581ms 08 159 1m43s 650ms 09 143 1m20s 566ms 10 176 1m22s 468ms 11 137 1m5s 477ms 12 4 1s740ms 435ms 13 82 47s884ms 583ms 14 153 1m18s 511ms 15 23 12s465ms 541ms 16 22 12s128ms 551ms 17 28 12s763ms 455ms [ User: intelifix - Total duration: 8m44s - Times executed: 973 ]
[ Application: [unknown] - Total duration: 8m44s - Times executed: 973 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "104675", "modelo" : "320", "itens" : "241619375555,241618310615,241618190626,241620631526,241618196080,241609333139,241628320627,241628236476,241597377078,241620557982,241599445967,241619800222,241629544348,241603567985,241593957081,241618170826,241628300322,241593088400,241607654546,241618295764,241630913135,241619412024,241619225866,241619295267,241628183744,241594106366,241631039208,241604000509,241608834852,241616118403,241593045365,241603984951,241594141724,241603577683,241593831032,241603993942,241618307381,241595333849,241598138500", "usuario" : "414", "caixa" : "1226793", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-10 08:49:04 Duration: 6s807ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "265154", "modelo" : "454", "itens" : "241624556880,241642239403,241626567581,241614368489,241624443132,241632704365,241641434061,241624945156,241613351029,241613413335,241627202728,241632660624,241627546375,241644867594,241614409706,241613871416,241644158097,241613366181,241624962027,241633754153,241642261931,241612958082,241626622638,241625033549,241624937983,241641880929,241640661326,241633664548,241642553149,241640540102,241633719199,241627014146,241624641031,241626777377,241644791325,241642552745,241613267181,241633664043,241633359513,241623701029,241627147795,241641890728,241632647490,241633958796,241611766485,241643831018,241626320611,241644152037", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-10 13:33:36 Duration: 2s61ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "264824", "modelo" : "320", "itens" : "241715485474,241631458294,241603064042,241622605354,241653474753,241677624955,241677757897,241654971230,241596231827,241679563551,230040444968,241689036585,241610018794,241604720512,241730393854,241703965674,241655017294,241598129206,241710309705,241607387696,230048376471,241669512222,241726978706,241620874557,241654292443,241646438904,241677671122,241594077575,241703833338,241665816990,241676828200,241654491430,241653216770,241676546073,241673341025,241703746988,241677680719,241635578090,230048991212,241649236988,241637494462,241673244247,241700029308,241637492341,241658203251,241667021216,230048896073,241701730406", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-10 08:45:27 Duration: 1s975ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
3 270 11m36s 156ms 47s47ms 2s579ms call rs_giga_triagem (?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 10 00 12 31s87ms 2s590ms 01 12 24s705ms 2s58ms 02 11 24s486ms 2s226ms 03 12 26s572ms 2s214ms 04 12 24s213ms 2s17ms 05 11 26s489ms 2s408ms 06 12 25s871ms 2s155ms 07 12 28s692ms 2s391ms 08 12 32s608ms 2s717ms 09 12 33s535ms 2s794ms 10 12 33s404ms 2s783ms 11 11 1m10s 6s444ms 12 12 27s972ms 2s331ms 13 12 28s838ms 2s403ms 14 11 29s706ms 2s700ms 15 12 29s387ms 2s448ms 16 11 25s744ms 2s340ms 17 12 27s6ms 2s250ms 18 11 27s84ms 2s462ms 19 12 26s738ms 2s228ms 20 12 36s289ms 3s24ms 21 12 26s869ms 2s239ms 22 12 28s229ms 2s352ms [ User: intelifix - Total duration: 11m36s - Times executed: 270 ]
[ Application: psql - Total duration: 11m36s - Times executed: 270 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-10 11:35:57 Duration: 47s47ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-10 20:05:11 Duration: 10s782ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-10 00:05:21 Duration: 9s733ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
4 243 1h15m33s 154ms 20m8s 18s658ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 10 08 19 6m34s 20s740ms 09 39 10m1s 15s422ms 10 62 11m38s 11s260ms 11 32 40m46s 1m16s 12 8 5m7s 38s384ms 13 20 13s510ms 675ms 14 37 44s541ms 1s203ms 15 10 6s196ms 619ms 16 8 8s734ms 1s91ms 17 8 13s900ms 1s737ms [ User: intelifix - Total duration: 1h15m33s - Times executed: 243 ]
[ Application: [unknown] - Total duration: 1h15m33s - Times executed: 243 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026914, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-07-10 11:50:43 Duration: 20m8s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026914, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-07-10 11:50:49 Duration: 8m53s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026887, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-10 08:47:26 Duration: 5m52s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
5 229 37s504ms 150ms 202ms 163ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 10 01 1 186ms 186ms 04 1 156ms 156ms 05 1 157ms 157ms 07 1 167ms 167ms 08 39 6s561ms 168ms 09 63 10s274ms 163ms 10 32 5s132ms 160ms 11 35 5s651ms 161ms 12 9 1s532ms 170ms 13 22 3s601ms 163ms 14 25 4s84ms 163ms [ User: intelifix - Total duration: 37s504ms - Times executed: 229 ]
[ Application: [unknown] - Total duration: 37s504ms - Times executed: 229 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 046;
Date: 2026-07-10 08:53:05 Duration: 202ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-07-10 08:45:18 Duration: 201ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0211;
Date: 2026-07-10 14:58:21 Duration: 198ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
6 227 1m8s 150ms 1s622ms 303ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 10 09 15 10s441ms 696ms 10 120 32s651ms 272ms 11 91 25s371ms 278ms 13 1 343ms 343ms [ User: intelifix - Total duration: 1m8s - Times executed: 227 ]
[ Application: [unknown] - Total duration: 1m8s - Times executed: 227 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"45717","seriais":"246185121315","usuario":"416","observacao":""}');
Date: 2026-07-10 09:56:42 Duration: 1s622ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"45717","seriais":"246206278586","usuario":"416","observacao":""}');
Date: 2026-07-10 09:57:09 Duration: 1s347ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"45717","seriais":"246338040123,246203569096,246250831028,226309287887,246273809914,226272284759,246075776883,246077644866,246320328304,226412361730,246074494345,246059557174,226276775051,246296823047,246273911013,246195115365,226171636485,226274855167,246107975065,246306929207,226415966166,246262773854,226248024142,246029899498,246323988908,246111898400,246268487890,246280106364,226322435164,226348876476,226152533858,246246115460","usuario":"416","observacao":""}');
Date: 2026-07-10 09:56:40 Duration: 1s73ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
7 141 30s584ms 150ms 431ms 216ms select * from rs_lote_manutencao (?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 10 08 3 971ms 323ms 09 6 1s918ms 319ms 10 30 6s587ms 219ms 11 29 6s99ms 210ms 13 10 2s351ms 235ms 14 43 8s525ms 198ms 15 18 3s561ms 197ms 17 2 569ms 284ms [ User: intelifix - Total duration: 30s584ms - Times executed: 141 ]
[ Application: [unknown] - Total duration: 30s584ms - Times executed: 141 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"316", "usuario" :"507", "tipo" :"N", "itens" :"008", "nota-fiscal" :"1563", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-07-10 09:47:18 Duration: 431ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"7", "cliente" :"11", "modelo" :"151", "usuario" :"428", "tipo" :"N", "itens" :"01", "nota-fiscal" :"2022", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-07-10 14:20:16 Duration: 415ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"298", "usuario" :"507", "tipo" :"N", "itens" :"008", "nota-fiscal" :"1563", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-07-10 08:54:12 Duration: 399ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
8 136 10m29s 151ms 5m41s 4s627ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 10 00 6 16s825ms 2s804ms 01 6 7s148ms 1s191ms 02 6 7s609ms 1s268ms 03 5 9s198ms 1s839ms 04 6 12s347ms 2s57ms 05 5 5s807ms 1s161ms 07 4 4s171ms 1s42ms 08 6 18s127ms 3s21ms 09 14 36s767ms 2s626ms 10 12 37s755ms 3s146ms 11 11 6m10s 33s679ms 12 12 31s306ms 2s608ms 13 6 5s133ms 855ms 14 10 17s887ms 1s788ms 15 6 13s398ms 2s233ms 16 6 7s794ms 1s299ms 17 5 5s165ms 1s33ms 21 4 9s846ms 2s461ms 22 6 12s510ms 2s85ms [ User: intelifix - Total duration: 10m26s - Times executed: 133 ]
[ User: lenon - Total duration: 3s66ms - Times executed: 3 ]
[ Application: psql - Total duration: 10m26s - Times executed: 133 ]
[ Application: pgAdmin 4 - CONN:422009 - Total duration: 3s66ms - Times executed: 3 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-10 11:50:43 Duration: 5m41s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-10 00:05:11 Duration: 10s212ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-10 11:35:10 Duration: 8s817ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
9 101 8m54s 1s698ms 24s325ms 5s290ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 10 07 2 9s856ms 4s928ms 08 5 32s658ms 6s531ms 09 9 1m33s 10s396ms 10 5 42s304ms 8s460ms 11 18 1m6s 3s709ms 12 4 32s522ms 8s130ms 13 5 26s145ms 5s229ms 14 5 58s813ms 11s762ms 15 10 41s855ms 4s185ms 16 17 57s467ms 3s380ms 17 21 1m12s 3s447ms [ User: intelifix - Total duration: 8m54s - Times executed: 101 ]
[ Application: [unknown] - Total duration: 8m54s - Times executed: 101 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-10', 0320, '', '', 0, 6, '2026-07-01');
Date: 2026-07-10 10:50:20 Duration: 24s325ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-10', 0173, '', '', 0, 6, '2026-07-01');
Date: 2026-07-10 09:23:40 Duration: 23s793ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-10', 0395, '', '', 0, 6, '2026-07-01');
Date: 2026-07-10 12:18:23 Duration: 23s398ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
10 98 46s599ms 264ms 874ms 475ms select pro_id, pgp_sym_decrypt(nome, ?)::varchar, pgp_sym_decrypt(descricao, ?)::varchar, pgp_sym_decrypt(classe, ?)::varchar, pgp_sym_decrypt(php, ?)::varchar, pgp_sym_decrypt(extras, ?)::varchar from progs order by pro_id;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 10 01 1 396ms 396ms 02 1 639ms 639ms 03 3 1s511ms 503ms 04 3 1s570ms 523ms 05 2 1s210ms 605ms 07 9 3s696ms 410ms 08 10 5s965ms 596ms 09 8 3s513ms 439ms 10 13 5s599ms 430ms 11 10 4s437ms 443ms 12 4 1s765ms 441ms 13 12 5s642ms 470ms 14 8 4s220ms 527ms 15 5 2s375ms 475ms 16 3 1s274ms 424ms 17 3 1s443ms 481ms 21 3 1s338ms 446ms [ User: lenon - Total duration: 46s599ms - Times executed: 98 ]
[ Application: [unknown] - Total duration: 46s599ms - Times executed: 98 ]
-
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-10 08:24:09 Duration: 874ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-10.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-10 08:59:04 Duration: 873ms Database: contagem User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-10.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-10 14:37:14 Duration: 779ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-10.log
11 90 54s109ms 335ms 1s34ms 601ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 10 01 1 618ms 618ms 02 1 730ms 730ms 03 3 1s914ms 638ms 04 3 1s906ms 635ms 05 2 1s365ms 682ms 07 6 3s248ms 541ms 08 10 7s211ms 721ms 09 8 4s406ms 550ms 10 12 6s453ms 537ms 11 10 5s667ms 566ms 12 4 2s299ms 574ms 13 11 6s540ms 594ms 14 8 5s184ms 648ms 15 5 3s85ms 617ms 16 2 1s174ms 587ms 17 3 1s698ms 566ms 21 1 602ms 602ms [ User: intelifix - Total duration: 54s109ms - Times executed: 90 ]
[ Application: [unknown] - Total duration: 54s109ms - Times executed: 90 ]
-
select * from rs_menu_grants (416, 19, 1);
Date: 2026-07-10 08:24:09 Duration: 1s34ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
select * from rs_menu_grants (408, 72, 1);
Date: 2026-07-10 08:59:04 Duration: 969ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
select * from rs_menu_grants (499, 19, 1);
Date: 2026-07-10 04:55:06 Duration: 906ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
12 87 1m54s 162ms 8s848ms 1s313ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 10 08 3 1s509ms 503ms 09 9 2s700ms 300ms 10 28 49s136ms 1s754ms 11 9 20s79ms 2s231ms 13 8 8s372ms 1s46ms 14 22 21s769ms 989ms 15 3 5s592ms 1s864ms 16 3 3s671ms 1s223ms 17 2 1s462ms 731ms [ User: intelifix - Total duration: 1m54s - Times executed: 87 ]
[ Application: [unknown] - Total duration: 1m54s - Times executed: 87 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (045285) LIMIT 1;
Date: 2026-07-10 10:23:58 Duration: 8s848ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (045286) LIMIT 1;
Date: 2026-07-10 10:55:59 Duration: 5s510ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (045288) LIMIT 1;
Date: 2026-07-10 10:11:11 Duration: 4s706ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
13 86 16s993ms 153ms 492ms 197ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 10 01 8 1s349ms 168ms 04 3 944ms 314ms 05 4 993ms 248ms 08 14 2s926ms 209ms 09 21 4s7ms 190ms 10 13 2s290ms 176ms 11 7 1s418ms 202ms 12 13 2s511ms 193ms 14 3 551ms 183ms [ User: intelifix - Total duration: 16s993ms - Times executed: 86 ]
[ Application: [unknown] - Total duration: 16s993ms - Times executed: 86 ]
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '229898099617,229897319911,229911850118,229896366877,229916612535,229918495872,229893181629,229915673846,229910380210,229876090915,229901681022,229920610625,229896344653,229896155465,229896641125,229912526580,229920622343,229892886571,229914658203,229909400608,229893220320,229900197677,229877137088,229895683545,229914891739,229915178892,229895936072,229915815880,229896919917,229892880915,229898935366,229899105764', NULL, NULL, 0263, 00);
Date: 2026-07-10 04:57:07 Duration: 492ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '229861335557,229854924247,229861348184,229847870215,229852167782,229856095764,229846836364,229847887690,229852653139,229840744356,229853141223,229847315356,229838450216,229853812837,229853718406,229861657990,229762960918', NULL, NULL, 0160, 00);
Date: 2026-07-10 05:02:56 Duration: 430ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT * FROM RS_TRIAGEM (404, 5, '113', 3, '229647901619,229724645068,216886634553,229647749606,229658040914,216946602325,216898477897,216888601435,229719091732,216888430004', NULL, NULL, 0131, 00);
Date: 2026-07-10 12:31:29 Duration: 305ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
14 83 19s288ms 150ms 4s841ms 232ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 10 07 2 372ms 186ms 09 1 154ms 154ms 10 7 1s169ms 167ms 11 13 7s8ms 539ms 12 4 664ms 166ms 13 13 2s137ms 164ms 14 40 7s301ms 182ms 15 2 322ms 161ms 17 1 158ms 158ms [ User: intelifix - Total duration: 19s288ms - Times executed: 83 ]
[ Application: [unknown] - Total duration: 19s288ms - Times executed: 83 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "0", "data-de" : "2026-07-10", "data-ate" : "2026-07-10", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "0", "usuario" : 509 }');
Date: 2026-07-10 11:49:30 Duration: 4s841ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "328", "data-de" : "2026-07-10", "data-ate" : "2026-07-10", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 397 }');
Date: 2026-07-10 14:06:55 Duration: 286ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "431", "data-de" : "2026-07-10", "data-ate" : "2026-07-10", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 504 }');
Date: 2026-07-10 14:49:42 Duration: 273ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
15 65 16s193ms 153ms 1s6ms 249ms create table temp0000235898 as select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 10 14 10 3s267ms 326ms 15 10 1s925ms 192ms 16 12 3s541ms 295ms 17 33 7s458ms 226ms [ User: intelifix - Total duration: 16s193ms - Times executed: 65 ]
[ Application: [unknown] - Total duration: 16s193ms - Times executed: 65 ]
-
CREATE TABLE temp0000235898 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "05-07-2026", "data-ate" : "10-07-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-07-10 14:12:38 Duration: 1s6ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
CREATE TABLE temp0000235898 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "05-07-2026", "data-ate" : "10-07-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-07-10 16:54:11 Duration: 965ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
CREATE TABLE temp0000235898 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "05-07-2026", "data-ate" : "10-07-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-07-10 17:04:02 Duration: 820ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
16 64 35s597ms 152ms 4s757ms 556ms create table temp0000285004 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 10 07 2 4s982ms 2s491ms 08 8 3s499ms 437ms 09 15 8s227ms 548ms 10 9 5s490ms 610ms 11 5 2s349ms 469ms 12 15 6s264ms 417ms 13 1 379ms 379ms 14 9 4s403ms 489ms [ User: intelifix - Total duration: 35s597ms - Times executed: 64 ]
[ Application: [unknown] - Total duration: 35s597ms - Times executed: 64 ]
-
CREATE TABLE temp0000285004 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-07-2026", "ate" :"10-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-10 07:57:57 Duration: 4s757ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
CREATE TABLE temp0000285004 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-07-2026", "ate" :"10-07-2026", "nota-fiscal":"81475", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-10 10:00:41 Duration: 886ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
CREATE TABLE temp0000285004 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-07-2026", "ate" :"10-07-2026", "nota-fiscal":"81475", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-10 08:58:30 Duration: 785ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
17 64 25s503ms 257ms 648ms 398ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 10 07 1 373ms 373ms 08 4 1s397ms 349ms 09 10 4s115ms 411ms 10 13 5s502ms 423ms 11 10 3s750ms 375ms 12 4 1s665ms 416ms 13 4 1s634ms 408ms 14 8 3s309ms 413ms 15 1 369ms 369ms 16 4 1s399ms 349ms 17 5 1s985ms 397ms [ User: intelifix - Total duration: 25s503ms - Times executed: 64 ]
[ Application: [unknown] - Total duration: 25s503ms - Times executed: 64 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-07-10 09:52:07 Duration: 648ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-07-10 10:03:03 Duration: 616ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-07-10 09:10:58 Duration: 589ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
18 64 10s395ms 150ms 185ms 162ms select * from rs_modelo_barra_smartcard (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 10 08 4 628ms 157ms 09 13 2s134ms 164ms 10 15 2s473ms 164ms 11 5 796ms 159ms 13 7 1s175ms 167ms 14 20 3s186ms 159ms [ User: intelifix - Total duration: 10s395ms - Times executed: 64 ]
[ Application: [unknown] - Total duration: 10s395ms - Times executed: 64 ]
-
SELECT * FROM RS_MODELO_BARRA_SMARTCARD (0454);
Date: 2026-07-10 10:43:04 Duration: 185ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT * FROM RS_MODELO_BARRA_SMARTCARD (0141);
Date: 2026-07-10 13:24:05 Duration: 179ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT * FROM RS_MODELO_BARRA_SMARTCARD (042);
Date: 2026-07-10 09:58:03 Duration: 178ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
19 63 19s766ms 151ms 927ms 313ms create table temp0000284316 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 10 07 1 223ms 223ms 08 5 919ms 183ms 09 11 2s176ms 197ms 10 14 2s871ms 205ms 11 8 2s701ms 337ms 13 4 1s765ms 441ms 14 20 9s108ms 455ms [ User: intelifix - Total duration: 19s766ms - Times executed: 63 ]
[ Application: [unknown] - Total duration: 19s766ms - Times executed: 63 ]
-
CREATE TABLE temp0000284316 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-07-2026", "ate" :"10-07-2026", "nota-fiscal":"81475", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-10 11:23:15 Duration: 927ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
CREATE TABLE temp0000284316 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-07-2026", "ate" :"10-07-2026", "nota-fiscal":"81475", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-10 14:07:11 Duration: 768ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
CREATE TABLE temp0000284316 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-07-2026", "ate" :"10-07-2026", "nota-fiscal":"81475", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-10 14:21:42 Duration: 625ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
20 48 2h7m9s 1s230ms 10m1s 2m38s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 10 07 3 9m38s 3m12s 08 3 7m22s 2m27s 09 3 10m42s 3m34s 10 3 9m24s 3m8s 11 3 9m31s 3m10s 12 3 9m41s 3m13s 13 3 7m19s 2m26s 14 3 8m53s 2m57s 15 3 8m38s 2m52s 16 3 6m6s 2m2s 17 3 7m4s 2m21s 18 3 6m29s 2m9s 19 3 6m6s 2m2s 20 3 7m47s 2m35s 21 3 6m30s 2m10s 22 3 5m52s 1m57s [ User: intelifix - Total duration: 2h7m9s - Times executed: 48 ]
[ Application: psql - Total duration: 2h7m9s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-10 09:15:02 Duration: 10m1s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-10 12:14:03 Duration: 9m2s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-10 07:13:59 Duration: 8m57s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m21s 9m1s 5m12s 3 15m37s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 10 05 3 15m37s 5m12s [ User: intelifix - Total duration: 15m37s - Times executed: 3 ]
[ Application: psql - Total duration: 15m37s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-10 05:09:03 Duration: 9m1s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
analyze verbose;
Date: 2026-07-10 05:13:18 Duration: 4m14s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
analyze verbose;
Date: 2026-07-10 05:15:39 Duration: 2m21s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
2 1s230ms 10m1s 2m38s 48 2h7m9s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 10 07 3 9m38s 3m12s 08 3 7m22s 2m27s 09 3 10m42s 3m34s 10 3 9m24s 3m8s 11 3 9m31s 3m10s 12 3 9m41s 3m13s 13 3 7m19s 2m26s 14 3 8m53s 2m57s 15 3 8m38s 2m52s 16 3 6m6s 2m2s 17 3 7m4s 2m21s 18 3 6m29s 2m9s 19 3 6m6s 2m2s 20 3 7m47s 2m35s 21 3 6m30s 2m10s 22 3 5m52s 1m57s [ User: intelifix - Total duration: 2h7m9s - Times executed: 48 ]
[ Application: psql - Total duration: 2h7m9s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-10 09:15:02 Duration: 10m1s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-10 12:14:03 Duration: 9m2s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-10 07:13:59 Duration: 8m57s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
3 1m47s 1m47s 1m47s 1 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 #3
Day Hour Count Duration Avg duration Jul 10 23 1 1m47s 1m47s [ User: intelifix - Total duration: 1m47s - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1m47s - Times executed: 1 ]
-
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-10 23:13:08 Duration: 1m47s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-10.log
4 336ms 4m55s 1m35s 48 1h16m1s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 10 07 3 5m10s 1m43s 08 3 4m22s 1m27s 09 3 6m6s 2m2s 10 3 5m51s 1m57s 11 3 5m58s 1m59s 12 3 5m9s 1m43s 13 3 4m27s 1m29s 14 3 5m18s 1m46s 15 3 5m7s 1m42s 16 3 4m9s 1m23s 17 3 4m15s 1m25s 18 3 4m3s 1m21s 19 3 3m54s 1m18s 20 3 4m31s 1m30s 21 3 3m53s 1m17s 22 3 3m40s 1m13s [ User: intelifix - Total duration: 1h16m1s - Times executed: 48 ]
[ Application: psql - Total duration: 1h16m1s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-10 11:20:22 Duration: 4m55s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-10 09:21:45 Duration: 4m53s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-10 10:20:12 Duration: 4m50s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
5 1s189ms 1m57s 52s958ms 9 7m56s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 10 08 1 1s943ms 1s943ms 09 2 6s725ms 3s362ms 10 5 6m 1m12s 13 1 1m47s 1m47s [ User: intelifix - Total duration: 7m56s - Times executed: 9 ]
[ Application: psql - Total duration: 7m56s - Times executed: 9 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01522);
Date: 2026-07-10 10:07:26 Duration: 1m57s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01523);
Date: 2026-07-10 10:20:49 Duration: 1m55s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01524);
Date: 2026-07-10 10:31:36 Duration: 1m52s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
6 4s380ms 1m44s 50s359ms 4 3m21s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 10 20 2 1m49s 54s737ms 23 2 1m31s 45s980ms [ User: intelifix - Total duration: 3m21s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m21s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-10 20:09:45 Duration: 1m44s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-10 23:38:59 Duration: 1m27s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-10 20:11:38 Duration: 5s213ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-10.log
7 408ms 1m14s 31s602ms 4 2m6s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 10 20 2 1m14s 37s415ms 23 2 51s576ms 25s788ms [ User: intelifix - Total duration: 2m6s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m6s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-10 20:06:07 Duration: 1m14s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-10 23:18:31 Duration: 51s168ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-10 20:11:05 Duration: 548ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-10.log
8 154ms 20m8s 18s658ms 243 1h15m33s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 10 08 19 6m34s 20s740ms 09 39 10m1s 15s422ms 10 62 11m38s 11s260ms 11 32 40m46s 1m16s 12 8 5m7s 38s384ms 13 20 13s510ms 675ms 14 37 44s541ms 1s203ms 15 10 6s196ms 619ms 16 8 8s734ms 1s91ms 17 8 13s900ms 1s737ms [ User: intelifix - Total duration: 1h15m33s - Times executed: 243 ]
[ Application: [unknown] - Total duration: 1h15m33s - Times executed: 243 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026914, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-07-10 11:50:43 Duration: 20m8s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026914, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-07-10 11:50:49 Duration: 8m53s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026887, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-10 08:47:26 Duration: 5m52s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
9 9s499ms 36s675ms 13s212ms 35 7m42s create table temp0000285016 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 10 08 6 1m35s 15s992ms 09 6 1m26s 14s400ms 10 15 3m4s 12s323ms 11 3 41s344ms 13s781ms 12 5 53s903ms 10s780ms [ User: intelifix - Total duration: 7m42s - Times executed: 35 ]
[ Application: [unknown] - Total duration: 7m42s - Times executed: 35 ]
-
CREATE TABLE temp0000285016 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-10 08:38:40 Duration: 36s675ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
CREATE TABLE temp0000285016 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-10 09:26:44 Duration: 22s773ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
CREATE TABLE temp0000285016 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-10 11:23:31 Duration: 15s368ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
10 10s516ms 14s990ms 12s434ms 19 3m56s create table temp0000285026 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 10 09 17 3m34s 12s612ms 11 2 21s847ms 10s923ms [ User: intelifix - Total duration: 3m56s - Times executed: 19 ]
[ Application: [unknown] - Total duration: 3m56s - Times executed: 19 ]
-
CREATE TABLE temp0000285026 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-10 09:53:45 Duration: 14s990ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
CREATE TABLE temp0000285026 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-10 09:51:29 Duration: 13s720ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
CREATE TABLE temp0000285026 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-10 09:38:25 Duration: 13s607ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
11 9s735ms 14s78ms 12s153ms 21 4m15s create table temp0000285062 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 10 11 12 2m23s 11s924ms 12 9 1m52s 12s458ms [ User: intelifix - Total duration: 4m15s - Times executed: 21 ]
[ Application: [unknown] - Total duration: 4m15s - Times executed: 21 ]
-
CREATE TABLE temp0000285062 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-10 12:01:29 Duration: 14s78ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
CREATE TABLE temp0000285062 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-10 12:02:10 Duration: 13s877ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
CREATE TABLE temp0000285062 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-10 11:21:10 Duration: 13s434ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
12 218ms 1m24s 6s541ms 42 4m34s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 10 08 2 1s401ms 700ms 09 14 1m28s 6s318ms 10 7 3s588ms 512ms 11 8 2m24s 18s86ms 12 5 32s937ms 6s587ms 13 4 1s393ms 348ms 14 2 2s252ms 1s126ms [ User: intelifix - Total duration: 4m34s - Times executed: 42 ]
[ Application: psql - Total duration: 4m34s - Times executed: 42 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026890);
Date: 2026-07-10 09:38:31 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026913);
Date: 2026-07-10 11:26:28 Duration: 1m15s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026914);
Date: 2026-07-10 11:29:44 Duration: 49s934ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
13 4s546ms 7s469ms 6s15ms 17 1m42s create table temp0000285016 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 10 08 6 36s309ms 6s51ms 09 4 25s43ms 6s260ms 10 7 40s918ms 5s845ms [ User: intelifix - Total duration: 1m42s - Times executed: 17 ]
[ Application: [unknown] - Total duration: 1m42s - Times executed: 17 ]
-
CREATE TABLE temp0000285016 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-07-2026", "ate" :"10-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-10 09:43:12 Duration: 7s469ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
CREATE TABLE temp0000285016 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-07-2026", "ate" :"10-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-10 10:00:22 Duration: 6s951ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
CREATE TABLE temp0000285016 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-07-2026", "ate" :"10-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-10 08:55:44 Duration: 6s941ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
14 1s698ms 24s325ms 5s290ms 101 8m54s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 10 07 2 9s856ms 4s928ms 08 5 32s658ms 6s531ms 09 9 1m33s 10s396ms 10 5 42s304ms 8s460ms 11 18 1m6s 3s709ms 12 4 32s522ms 8s130ms 13 5 26s145ms 5s229ms 14 5 58s813ms 11s762ms 15 10 41s855ms 4s185ms 16 17 57s467ms 3s380ms 17 21 1m12s 3s447ms [ User: intelifix - Total duration: 8m54s - Times executed: 101 ]
[ Application: [unknown] - Total duration: 8m54s - Times executed: 101 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-10', 0320, '', '', 0, 6, '2026-07-01');
Date: 2026-07-10 10:50:20 Duration: 24s325ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-10', 0173, '', '', 0, 6, '2026-07-01');
Date: 2026-07-10 09:23:40 Duration: 23s793ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-10', 0395, '', '', 0, 6, '2026-07-01');
Date: 2026-07-10 12:18:23 Duration: 23s398ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
15 151ms 5m41s 4s627ms 136 10m29s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 10 00 6 16s825ms 2s804ms 01 6 7s148ms 1s191ms 02 6 7s609ms 1s268ms 03 5 9s198ms 1s839ms 04 6 12s347ms 2s57ms 05 5 5s807ms 1s161ms 07 4 4s171ms 1s42ms 08 6 18s127ms 3s21ms 09 14 36s767ms 2s626ms 10 12 37s755ms 3s146ms 11 11 6m10s 33s679ms 12 12 31s306ms 2s608ms 13 6 5s133ms 855ms 14 10 17s887ms 1s788ms 15 6 13s398ms 2s233ms 16 6 7s794ms 1s299ms 17 5 5s165ms 1s33ms 21 4 9s846ms 2s461ms 22 6 12s510ms 2s85ms [ User: intelifix - Total duration: 10m26s - Times executed: 133 ]
[ User: lenon - Total duration: 3s66ms - Times executed: 3 ]
[ Application: psql - Total duration: 10m26s - Times executed: 133 ]
[ Application: pgAdmin 4 - CONN:422009 - Total duration: 3s66ms - Times executed: 3 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-10 11:50:43 Duration: 5m41s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-10 00:05:11 Duration: 10s212ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-10 11:35:10 Duration: 8s817ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
16 770ms 12s869ms 3s933ms 30 1m58s call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 10 08 2 14s842ms 7s421ms 09 2 18s839ms 9s419ms 10 2 10s312ms 5s156ms 11 1 12s869ms 12s869ms 12 2 11s45ms 5s522ms 13 1 1s97ms 1s97ms 14 3 23s215ms 7s738ms 15 3 10s759ms 3s586ms 16 2 2s199ms 1s99ms 17 3 3s53ms 1s17ms 18 1 1s128ms 1s128ms 19 2 1s546ms 773ms 20 1 2s16ms 2s16ms 21 2 2s272ms 1s136ms 22 3 2s801ms 933ms [ User: intelifix - Total duration: 1m58s - Times executed: 30 ]
[ Application: psql - Total duration: 1m58s - Times executed: 30 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-10 11:00:14 Duration: 12s869ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-10 09:40:13 Duration: 12s71ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-10 14:40:10 Duration: 9s462ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
17 156ms 47s47ms 2s579ms 270 11m36s call rs_giga_triagem (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 10 00 12 31s87ms 2s590ms 01 12 24s705ms 2s58ms 02 11 24s486ms 2s226ms 03 12 26s572ms 2s214ms 04 12 24s213ms 2s17ms 05 11 26s489ms 2s408ms 06 12 25s871ms 2s155ms 07 12 28s692ms 2s391ms 08 12 32s608ms 2s717ms 09 12 33s535ms 2s794ms 10 12 33s404ms 2s783ms 11 11 1m10s 6s444ms 12 12 27s972ms 2s331ms 13 12 28s838ms 2s403ms 14 11 29s706ms 2s700ms 15 12 29s387ms 2s448ms 16 11 25s744ms 2s340ms 17 12 27s6ms 2s250ms 18 11 27s84ms 2s462ms 19 12 26s738ms 2s228ms 20 12 36s289ms 3s24ms 21 12 26s869ms 2s239ms 22 12 28s229ms 2s352ms [ User: intelifix - Total duration: 11m36s - Times executed: 270 ]
[ Application: psql - Total duration: 11m36s - Times executed: 270 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-10 11:35:57 Duration: 47s47ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-10 20:05:11 Duration: 10s782ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-10 00:05:21 Duration: 9s733ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-10.log
18 162ms 8s848ms 1s313ms 87 1m54s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 10 08 3 1s509ms 503ms 09 9 2s700ms 300ms 10 28 49s136ms 1s754ms 11 9 20s79ms 2s231ms 13 8 8s372ms 1s46ms 14 22 21s769ms 989ms 15 3 5s592ms 1s864ms 16 3 3s671ms 1s223ms 17 2 1s462ms 731ms [ User: intelifix - Total duration: 1m54s - Times executed: 87 ]
[ Application: [unknown] - Total duration: 1m54s - Times executed: 87 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (045285) LIMIT 1;
Date: 2026-07-10 10:23:58 Duration: 8s848ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (045286) LIMIT 1;
Date: 2026-07-10 10:55:59 Duration: 5s510ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (045288) LIMIT 1;
Date: 2026-07-10 10:11:11 Duration: 4s706ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
19 151ms 4s905ms 706ms 1,166 13m43s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 10 07 23 12s724ms 553ms 08 99 1m37s 988ms 09 170 2m5s 736ms 10 192 2m3s 645ms 11 127 1m5s 518ms 12 30 29s319ms 977ms 13 132 1m23s 634ms 14 279 2m47s 599ms 15 81 1m14s 918ms 16 17 27s317ms 1s606ms 17 16 15s824ms 989ms [ User: intelifix - Total duration: 13m43s - Times executed: 1166 ]
[ Application: [unknown] - Total duration: 13m43s - Times executed: 1166 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (127617, 399, '225832679296', '',077,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-10 12:26:10 Duration: 4s905ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (263245, 503, '73009185850078312661,229823409296,229793467272,229704985360,229678393349,229798877082,229836025657,229709138593,216921865466,229711011022,229731244758,229711629094,229708462232,229733166382,229823837374,229832417987,229829504763,229715037878,229766442335,229880714048,229767201837,229676296477,229832381621,229676359413,229709109702,216928331227,229699539206,229729799498,229733430202,229777911120,229643904259,216949686475,229832798686,229822113952', '246622224355,246600249719,246508355262,246459445270,246617500909,246585834047,246540794152,246438766989,246535838809,246558835879,246544294965,246530451628,,246625886878,246248879298,246634148492,246551232545,246553576768,226272459602,246556752242,246493794144,226111746375,246499902743,246530451527,,246523767686,246550580304,246567286176,246592074555,246524298502,246448180423,246319792337,246625636472,,,,,,,', 0137, 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":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-07-10 08:31:33 Duration: 4s560ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (127617, 399, '215678823030', '',077,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-10 14:58:52 Duration: 4s101ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
20 335ms 1s34ms 601ms 90 54s109ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 10 01 1 618ms 618ms 02 1 730ms 730ms 03 3 1s914ms 638ms 04 3 1s906ms 635ms 05 2 1s365ms 682ms 07 6 3s248ms 541ms 08 10 7s211ms 721ms 09 8 4s406ms 550ms 10 12 6s453ms 537ms 11 10 5s667ms 566ms 12 4 2s299ms 574ms 13 11 6s540ms 594ms 14 8 5s184ms 648ms 15 5 3s85ms 617ms 16 2 1s174ms 587ms 17 3 1s698ms 566ms 21 1 602ms 602ms [ User: intelifix - Total duration: 54s109ms - Times executed: 90 ]
[ Application: [unknown] - Total duration: 54s109ms - Times executed: 90 ]
-
select * from rs_menu_grants (416, 19, 1);
Date: 2026-07-10 08:24:09 Duration: 1s34ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
select * from rs_menu_grants (408, 72, 1);
Date: 2026-07-10 08:59:04 Duration: 969ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
-
select * from rs_menu_grants (499, 19, 1);
Date: 2026-07-10 04:55:06 Duration: 906ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-10.log
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 8 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jul 10 13 2 0ms 0ms 16 2 0ms 0ms 20 2 0ms 0ms 21 2 0ms 0ms [ User: intelifix - Total duration: 5m57s - Times executed: 8 ]
[ Application: psql - Total duration: 5m56s - Times executed: 7 ]
[ Application: [unknown] - Total duration: 668ms - Times executed: 1 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 17,265 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 13 FATAL entries
- 3746 ERROR entries
- 0 WARNING entries
- 10 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 3,614 Max number of times the same event was reported
- 3,769 Total events found
Rank Times reported Error 1 3,614 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 10 00 59 01 60 02 60 03 59 04 60 05 60 06 59 07 94 08 368 09 422 10 341 11 449 12 268 13 174 14 356 15 139 16 99 17 132 18 59 19 60 20 59 21 60 22 59 23 58 - ERROR: prepared statement "_PLAN0000000029C41B50" does not exist
- ERROR: prepared statement "_PLAN0000000029E9F3F0" does not exist
- ERROR: prepared statement "_PLAN0000000029F4DB80" does not exist
Statement: DEALLOCATE "_PLAN0000000029C41B50"
Date: 2026-07-10 00:00:41 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-10.log
Statement: DEALLOCATE "_PLAN0000000029E9F3F0"
Date: 2026-07-10 00:01:42 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-10.log
Statement: DEALLOCATE "_PLAN0000000029F4DB80"
Date: 2026-07-10 00:02:42 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-10.log
2 44 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #2
Day Hour Count Jul 10 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 1 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-10 00:05:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-10.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-10 00:35:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-10.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-10 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-10.log
3 43 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #3
Day Hour Count Jul 10 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 2 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-10 08:00:12 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-10.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-10 08:20:09 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-10.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-10 08:40:12 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-10.log
4 12 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Jul 10 09 2 11 1 12 9 - ERROR: trailing junk after numeric literal at or near "480033E7CCD8" at character 27
- ERROR: trailing junk after numeric literal at or near "480033E7CCD8" at character 27
- ERROR: trailing junk after numeric literal at or near "48575443E2222CA7" at character 83
Statement: SELECT * FROM RS_ETIQUETA(480033E7CCD8)
Date: 2026-07-10 09:00:05 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-10.log
Statement: SELECT * FROM RS_ETIQUETA(480033E7CCD8) /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-10 09:00:05 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-10.log
Statement: SELECT RS_SERIAL_TEMPORARIO( '48575443E2222CA7'' ) OR RS_SERIAL_TEMPORARIO_VIVO( '48575443E2222CA7'' )
Date: 2026-07-10 11:26:47 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-10.log
5 11 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #5
Day Hour Count Jul 10 08 2 11 7 16 2 - ERROR: syntax error at or near "RETURN" at character 294
- ERROR: syntax error at or near "*/" at character 1
- ERROR: syntax error at or near ""},{"" at character 95
Statement: SELECT STRING_AGG( C.LI_SERIE , ',') FROM LOTE_CAIXAS A INNER JOIN CAIXA_ITENS B ON B.CAI_ID = A.CAI_ID INNER JOIN LOTE_ITENS C ON C.FLU_ID = B.FLU_ID WHERE A.LOT_ID = nLote AND EXISTS ( SELECT 1 FROM LOTE_ITENS D WHERE D.EQ_ID = C.EQ_ID AND D.LI_ID > C.LI_ID LIMIT 1 ); RETURN ( COALESCE( nQtd , 0 ) > 0 );
Date: 2026-07-10 08:49:44 Database: rio Application: pgAdmin 4 - CONN:6923804 User: lenon Remote: 172.20.0.3 Log file: /usr/local/pgsql/data/log/serverlog-10.log
Statement: */ DROP FUNCTION RS_LOTE_COM_RETORNO( INTEGER ); CREATE OR REPLACE FUNCTION RS_LOTE_COM_RETORNO( nLote INTEGER ) RETURNS TEXT AS $BODY$ /* ==================================================================================================== ROTINA : RS_LOTE_COM_RETORNO AUTOR : LENILDO BARBOZA OBJETIVO : CHECA SE ALGUM EQUIPAMENTO DO LOTE DE SAÍDA JÁ RETORNOU À OFICINA ==================================================================================================== DATA USUARIO ALTERAÇÃO ----------- --------------- ---------- 30/JUN/2026 LENILDO BARBOZA IMPLANTAÇÃO INSERT INTO PARAMETROS VALUES ( 'LOTE-SAIDA-CONSISTE-EQUIPAMENTOS-COM-RETORNO' , 'S', 'SE É POSSÍVEL EDITAR LOTES DE SAÍDA COM EQUIPAMENTOS JÁ RETORNADOS!' ); ==================================================================================================== */ DECLARE cRoutine CONSTANT TEXT := 'RS_LOTE_COM_RETORNO'; cVersion CONSTANT TEXT := 'V 1.0 (c)'; cConsiste CONSTANT TEXT := RS_PARAMETRO( 'LOTE-SAIDA-CONSISTE-EQUIPAMENTOS-COM-RETORNO' ); cRet TEXT; BEGIN IF cConsiste = 'N' THEN RETURN FALSE; END IF; SELECT STRING_AGG( DISTINCT C.LI_SERIE , ', ') INTO cRet FROM LOTE_CAIXAS A INNER JOIN CAIXA_ITENS B ON B.CAI_ID = A.CAI_ID INNER JOIN LOTE_ITENS C ON C.FLU_ID = B.FLU_ID WHERE A.LOT_ID = nLote AND EXISTS ( SELECT 1 FROM LOTE_ITENS D WHERE D.EQ_ID = C.EQ_ID AND D.LI_ID > C.LI_ID LIMIT 1 ); RETURN COALESCE( cRet , '' ); END; $BODY$ LANGUAGE PLPGSQL STABLE PARALLEL SAFE;
Date: 2026-07-10 08:54:27 Database: rio Application: pgAdmin 4 - CONN:6923804 User: lenon Remote: 172.20.0.3 Log file: /usr/local/pgsql/data/log/serverlog-10.log
Statement: SELECT * FROM RS_LOTE_CONSISTE_SERIAL( '{"lote":"263266","seriais":[{"serial":""},{"serial":"'"},{"serial":"4857544387C438A8"},{"serial":"04E7959B0A50"}]}')
Date: 2026-07-10 11:15:04 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-10.log
6 7 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #6
Day Hour Count Jul 10 03 7 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-07-10 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-10.log
Date: 2026-07-10 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-10.log
Date: 2026-07-10 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-10.log
7 6 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #7
Day Hour Count Jul 10 11 6 - LOG: process 1613683 still waiting for ShareLock on transaction 2461686 after 1000.163 ms
- LOG: process 1613683 still waiting for ShareLock on transaction 2461686 after 9413.713 ms
- LOG: process 1613683 still waiting for ShareLock on transaction 2461686 after 62850.132 ms
Detail: Process holding the lock: 1612931. Wait queue: 1613683.
Context: while updating tuple (73288,61) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1012 at assignment PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 026914, 0434 )' , '/var/www/html/tmp/nf_carga_lotes_0434.xlsx' )Date: 2026-07-10 11:41:58 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-10.log
Detail: Process holding the lock: 1612931. Wait queue: 1613683.
Context: while updating tuple (73288,61) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1012 at assignment PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 026914, 0434 )' , '/var/www/html/tmp/nf_carga_lotes_0434.xlsx' )Date: 2026-07-10 11:42:06 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-10.log
Detail: Process holding the lock: 1612931. Wait queue: 1613683.
Context: while updating tuple (73288,61) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1012 at assignment PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 026914, 0434 )' , '/var/www/html/tmp/nf_carga_lotes_0434.xlsx' )Date: 2026-07-10 11:43:00 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-10.log
8 5 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #8
Day Hour Count Jul 10 08 3 14 2 - ERROR: column "nlote" does not exist at character 185
- ERROR: column "b0c287cd31a9" does not exist at character 27
- ERROR: column "b0c287cd31a9" does not exist at character 27
Statement: SELECT STRING_AGG( C.LI_SERIE , ',') FROM LOTE_CAIXAS A INNER JOIN CAIXA_ITENS B ON B.CAI_ID = A.CAI_ID INNER JOIN LOTE_ITENS C ON C.FLU_ID = B.FLU_ID WHERE A.LOT_ID = nLote AND EXISTS ( SELECT 1 FROM LOTE_ITENS D WHERE D.EQ_ID = C.EQ_ID AND D.LI_ID > C.LI_ID LIMIT 1 );
Date: 2026-07-10 08:49:50 Database: rio Application: pgAdmin 4 - CONN:6923804 User: lenon Remote: 172.20.0.3 Log file: /usr/local/pgsql/data/log/serverlog-10.log
Statement: SELECT * FROM RS_ETIQUETA(B0C287CD31A9)
Date: 2026-07-10 08:58:47 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-10.log
Statement: SELECT * FROM RS_ETIQUETA(B0C287CD31A9)
Date: 2026-07-10 08:58:47 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-10.log
9 4 ERROR: function rs_etiqueta(...) does not exist
Times Reported Most Frequent Error / Event #9
Day Hour Count Jul 10 11 4 - ERROR: function rs_etiqueta(numeric) does not exist at character 15
- ERROR: function rs_etiqueta(numeric) does not exist at character 15
- ERROR: function rs_etiqueta(numeric) does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_ETIQUETA(73007185850077508570)Date: 2026-07-10 11:53:25 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-10.log
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_ETIQUETA(73007185850077508570)Date: 2026-07-10 11:53:25 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-10.log
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_ETIQUETA(73007185850077508570)Date: 2026-07-10 11:53:33 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-10.log
10 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #10
Day Hour Count Jul 10 05 4 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-10 05:32:13 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-10.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-10 05:32:13 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-10.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-10 05:32:13 Database: contagem Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-10.log
11 4 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #11
Day Hour Count Jul 10 00 1 06 1 09 1 15 1 - FATAL: database "testes" does not exist
- FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-07-10 00:02:11 Database: testes Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-10.log
Date: 2026-07-10 06:02:12 Database: testes Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-10.log
Date: 2026-07-10 09:24:57 Database: jaboatao Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-10.log
12 3 LOG: could not receive data from client: Connection timed out
Times Reported Most Frequent Error / Event #12
Day Hour Count Jul 10 11 3 - LOG: could not receive data from client: Connection timed out
- LOG: could not receive data from client: Connection timed out
- LOG: could not receive data from client: Connection timed out
Date: 2026-07-10 11:25:14 Database: postgres Application: pgAdmin 4 - DB:postgres User: lenon Remote: 172.20.0.3 Log file: /usr/local/pgsql/data/log/serverlog-10.log
Date: 2026-07-10 11:32:53 Database: rio Application: pgAdmin 4 - CONN:422009 User: lenon Remote: 172.20.0.3 Log file: /usr/local/pgsql/data/log/serverlog-10.log
Date: 2026-07-10 11:35:37 Database: rio Application: pgAdmin 4 - DB:rio User: lenon Remote: 172.20.0.3 Log file: /usr/local/pgsql/data/log/serverlog-10.log
13 2 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 #13
Day Hour Count Jul 10 20 1 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
- 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-10 20:05:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-10.log
Context: Traceback (most recent call last):
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-10 21:05:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-10.log
14 2 ERROR: function rs_caixa_qr(...) does not exist
Times Reported Most Frequent Error / Event #14
Day Hour Count Jul 10 08 2 - ERROR: function rs_caixa_qr(numeric) does not exist at character 15
- ERROR: function rs_caixa_qr(numeric) does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: select * from rs_caixa_qr(.378945)Date: 2026-07-10 08:05:41 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-10.log
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: select * from rs_caixa_qr(.378945)Date: 2026-07-10 08:05:41 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-10.log
15 2 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 #15
Day Hour Count Jul 10 20 1 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
- 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-10 20:00:03 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-10.log
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936...
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-10 21:00:04 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-10.log
16 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #16
Day Hour Count Jul 10 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-07-10 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-10.log
Date: 2026-07-10 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-10.log
17 2 ERROR: invalid byte sequence for encoding
Times Reported Most Frequent Error / Event #17
Day Hour Count Jul 10 08 2 - ERROR: invalid byte sequence for encoding "UTF8": 0xd7 0x42
- ERROR: invalid byte sequence for encoding "UTF8": 0xd7 0x42
Date: 2026-07-10 08:07:56 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-10.log
Date: 2026-07-10 08:07:56 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-10.log
18 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #18
Day Hour Count Jul 10 03 1 - LOG: database system was shut down at 2026-07-10 03:05:01 -03
Date: 2026-07-10 03:05:02 Log file: /usr/local/pgsql/data/log/serverlog-10.log
19 1 ERROR: trailing junk after parameter at or near "..."
Times Reported Most Frequent Error / Event #19
Day Hour Count Jul 10 09 1 - ERROR: trailing junk after parameter at or near "N_CAIXA" at character 27
Statement: select * from rs_caixa_qr($1N_CAIXA)
Date: 2026-07-10 09:03:05 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-10.log