pgBadger-
Global information
- Generated on Tue Jul 7 23:50:12 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 48,042 log entries in 10s
- Log start from 2026-07-06 00:00:02 to 2026-07-06 23:59:27
-
Overview
Global Stats
- 382 Number of unique normalized queries
- 6,567 Number of queries
- 9h29m16s Total query duration
- 2026-07-06 00:02:06 First query
- 2026-07-06 23:54:14 Last query
- 5 queries/s at 2026-07-06 11:57:03 Query peak
- 9h29m16s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 9h29m16s Execute total duration
- 4,926 Number of events
- 15 Number of unique normalized events
- 4,783 Max number of times the same event was reported
- 0 Number of cancellation
- 451 Total number of automatic vacuums
- 1,065 Total number of automatic analyzes
- 22 Number temporary file
- 233.36 MiB Max size of temporary file
- 148.61 MiB Average size of temporary file
- 374 Total number of sessions
- 8 sessions at 2026-07-06 18:40:11 Session peak
- 14d8m37s Total duration of sessions
- 53m55s Average duration of sessions
- 17 Average queries per session
- 1m31s Average queries duration per session
- 52m24s Average idle time per session
- 377 Total number of connections
- 5 connections/s at 2026-07-06 00:05:02 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-07-06 11:57:03 Date
SELECT Traffic
Key values
- 5 queries/s Query Peak
- 2026-07-06 11:57:03 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-07-06 23:53:58 Date
Queries duration
Key values
- 9h29m16s 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 06 00 24 0ms 21s72ms 4s177ms 2s933ms 3s572ms 1m18s 01 12 0ms 3s254ms 1s611ms 2s902ms 3s324ms 3s605ms 02 11 0ms 3s49ms 1s612ms 2s693ms 2s991ms 3s353ms 03 14 0ms 3s357ms 1s418ms 2s723ms 3s239ms 4s698ms 04 12 0ms 3s566ms 1s726ms 3s142ms 3s523ms 3s764ms 05 16 0ms 8m42s 1m4s 3s692ms 2m22s 8m42s 06 34 0ms 9s892ms 1s973ms 4s186ms 6s289ms 30s148ms 07 190 0ms 12m58s 13s353ms 46s899ms 4m34s 13m41s 08 514 150ms 6m2s 4s413ms 2m 4m28s 6m50s 09 712 150ms 13m28s 4s375ms 1m59s 5m21s 13m38s 10 678 150ms 9m53s 4s60ms 1m56s 6m34s 10m4s 11 654 150ms 9m5s 3s220ms 1m56s 2m43s 9m13s 12 313 150ms 8m24s 6s984ms 1m22s 4m36s 8m27s 13 350 0ms 6m48s 3s920ms 34s9ms 58s797ms 8m22s 14 724 150ms 9m57s 3s573ms 1m5s 5m17s 10m 15 958 150ms 10m9s 4s158ms 5m13s 5m44s 10m30s 16 574 150ms 8m52s 3s802ms 43s730ms 3m10s 13m59s 17 302 0ms 7m38s 4s444ms 34s235ms 1m22s 7m40s 18 23 0ms 6m57s 33s241ms 3s728ms 1m23s 6m57s 19 16 0ms 5m42s 37s933ms 2s908ms 45s770ms 5m42s 20 109 0ms 7m26s 12s665ms 1m2s 1m34s 7m26s 21 32 0ms 5m43s 19s683ms 4s482ms 46s303ms 5m43s 22 22 0ms 5m46s 28s365ms 4s416ms 46s25ms 5m46s 23 273 0ms 1m54s 8s903ms 1m7s 1m54s 2m25s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 06 00 6 0 1s15ms 0ms 0ms 566ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 1 0 395ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 14 0 615ms 0ms 0ms 2s513ms 07 132 0 16s538ms 2s796ms 32s330ms 10m32s 08 391 0 4s687ms 22s938ms 1m57s 4m28s 09 553 0 4s839ms 17s235ms 1m57s 7m45s 10 559 0 4s378ms 11s522ms 1m53s 6m34s 11 514 0 3s525ms 15s204ms 1m53s 5m9s 12 233 0 7s997ms 7s574ms 1m9s 7m2s 13 271 0 4s174ms 9s334ms 26s466ms 3m45s 14 583 0 3s580ms 18s332ms 32s583ms 7m39s 15 781 0 4s136ms 23s633ms 5m1s 8m23s 16 461 0 4s109ms 15s618ms 26s49ms 4m46s 17 198 0 5s265ms 9s216ms 15s178ms 4m 18 11 0 1m7s 0ms 0ms 3m55s 19 6 0 1m37s 0ms 0ms 3m18s 20 13 86 13s623ms 28s324ms 1m2s 3m57s 21 17 0 35s257ms 0ms 821ms 3m25s 22 6 0 1m39s 0ms 0ms 3m22s 23 6 267 8s903ms 1m3s 1m7s 2m22s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 06 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 06 00 0 2 2.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 1 1.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 2 2.00 0.00% 07 0 13 13.00 0.00% 08 0 17 17.00 0.00% 09 0 14 14.00 0.00% 10 0 11 11.00 0.00% 11 0 10 10.00 0.00% 12 0 11 11.00 0.00% 13 0 9 9.00 0.00% 14 0 21 21.00 0.00% 15 0 28 28.00 0.00% 16 0 14 14.00 0.00% 17 0 4 4.00 0.00% 18 0 1 1.00 0.00% 19 0 0 0.00 0.00% 20 0 1 1.00 0.00% 21 0 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 06 00 18 0.01/s 01 10 0.00/s 02 9 0.00/s 03 19 0.01/s 04 9 0.00/s 05 10 0.00/s 06 17 0.00/s 07 16 0.00/s 08 21 0.01/s 09 23 0.01/s 10 23 0.01/s 11 18 0.01/s 12 14 0.00/s 13 20 0.01/s 14 25 0.01/s 15 28 0.01/s 16 21 0.01/s 17 16 0.00/s 18 12 0.00/s 19 9 0.00/s 20 14 0.00/s 21 11 0.00/s 22 8 0.00/s 23 6 0.00/s Day Hour Count Average Duration Average idle time Jul 06 00 5 50m 49m40s 01 16 1h1m7s 1h1m6s 02 10 1h11s 1h10s 03 19 21m29s 21m28s 04 9 1h4m 1h3m57s 05 9 1h 58m4s 06 10 57m30s 57m23s 07 17 58m18s 55m49s 08 18 52m57s 50m51s 09 20 57m19s 54m44s 10 23 54m5s 52m5s 11 22 57m56s 56m20s 12 19 52m15s 50m20s 13 11 56m22s 54m17s 14 23 55m4s 53m12s 15 30 48m38s 46m26s 16 22 57m7s 55m27s 17 20 56m29s 55m21s 18 15 59m5s 58m14s 19 12 1h58s 1h8s 20 13 43m2s 41m16s 21 10 1h 58m57s 22 12 56m5s 55m13s 23 9 50m19s 45m48s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-07-06 00:05:02 Date
Connections per database
Key values
- rio Main Database
- 377 connections Total
Connections per user
Key values
- intelifix Main User
- 377 connections Total
-
Sessions
Simultaneous sessions
Key values
- 8 sessions Session Peak
- 2026-07-06 18:40:11 Date
Histogram of session times
Key values
- 305 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 374 sessions Total
Sessions per user
Key values
- intelifix Main User
- 374 sessions Total
Sessions per host
Key values
- [local] Main Host
- 374 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 18,358 buffers Checkpoint Peak
- 2026-07-06 11:34:39 Date
- 270.027 seconds Highest write time
- 0.129 seconds Sync time
Checkpoints Wal files
Key values
- 11 files Wal files usage Peak
- 2026-07-06 15:39:41 Date
Checkpoints distance
Key values
- 355.15 Mo Distance Peak
- 2026-07-06 15:39:41 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 06 00 5,666 269.756s 0.006s 269.773s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 10,861 0.654s 0.007s 0.679s 04 0 0s 0s 0s 05 6,340 634.893s 0.024s 634.979s 06 3,984 399.133s 0.024s 399.19s 07 34,372 2,101.074s 0.174s 2,101.389s 08 65,826 3,062.011s 0.499s 3,062.693s 09 62,616 3,234.972s 0.606s 3,235.8s 10 63,921 3,238.866s 0.55s 3,239.649s 11 73,198 3,238.845s 0.675s 3,239.745s 12 49,158 2,934.063s 0.284s 2,934.509s 13 26,209 2,136.668s 0.363s 2,137.194s 14 71,836 3,227.773s 0.648s 3,228.634s 15 100,092 3,238.55s 0.796s 3,239.624s 16 56,965 3,238.843s 0.723s 3,239.774s 17 28,657 2,699.314s 0.26s 2,699.714s 18 860 86.594s 0.028s 86.666s 19 26 2.651s 0.004s 2.666s 20 1,424 216.226s 0.019s 216.262s 21 2,382 239.193s 0.031s 239.297s 22 1,631 164.123s 0.027s 164.198s 23 425 78.613s 0.023s 78.684s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 06 00 0 0 2 32 0.001s 0.001s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 3 29 0.002s 0.003s 04 0 0 0 0 0s 0s 05 0 0 3 121 0.002s 0.006s 06 0 0 1 278 0.002s 0.005s 07 0 0 24 2,426 0.006s 0.012s 08 0 0 37 4,993 0.013s 0.012s 09 0 0 34 6,362 0.015s 0.012s 10 0 0 32 6,814 0.010s 0.012s 11 0 0 32 7,383 0.009s 0.012s 12 0 0 30 3,917 0.010s 0.012s 13 0 0 22 4,550 0.008s 0.012s 14 0 0 39 7,107 0.007s 0.012s 15 0 0 66 7,624 0.022s 0.012s 16 0 0 27 6,391 0.031s 0.012s 17 0 0 27 4,536 0.005s 0.01s 18 0 0 0 245 0.006s 0.007s 19 0 0 0 7 0.002s 0.002s 20 0 0 1 86 0.003s 0.003s 21 0 0 1 397 0.003s 0.009s 22 0 0 0 404 0.003s 0.007s 23 0 0 2 33 0.008s 0.006s Day Hour Count Avg time (sec) Jul 06 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 06 00 29,583.00 kB 29,583.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 27,091.00 kB 27,091.00 kB 04 0.00 kB 0.00 kB 05 7,103.33 kB 11,009.50 kB 06 3,120.60 kB 10,410.00 kB 07 33,359.83 kB 57,479.00 kB 08 50,454.75 kB 93,737.33 kB 09 45,433.92 kB 80,221.42 kB 10 43,653.92 kB 90,562.08 kB 11 44,153.33 kB 102,269.75 kB 12 41,307.33 kB 96,346.25 kB 13 29,184.08 kB 72,600.50 kB 14 54,315.50 kB 85,008.67 kB 15 88,963.67 kB 126,403.83 kB 16 37,632.67 kB 100,859.25 kB 17 44,012.20 kB 62,533.70 kB 18 605.71 kB 40,720.57 kB 19 90.50 kB 24,905.00 kB 20 5,157.67 kB 20,406.33 kB 21 1,412.50 kB 12,291.75 kB 22 1,271.29 kB 6,348.43 kB 23 4,579.00 kB 12,864.40 kB -
Temporary Files
Size of temporary files
Key values
- 466.72 MiB Temp Files size Peak
- 2026-07-06 05:31:54 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-07-06 05:31:54 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 06 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.52 MiB 06 0 0 0 07 0 0 0 08 2 364.01 MiB 182.01 MiB 09 4 728.01 MiB 182.00 MiB 10 2 364.00 MiB 182.00 MiB 11 3 546.09 MiB 182.03 MiB 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 1 182.00 MiB 182.00 MiB 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 11 1.96 GiB 181.98 MiB 182.06 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 (01500);
Date: 2026-07-06 11:28:39 Duration: 2m21s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01499);
Date: 2026-07-06 11:16:20 Duration: 1m59s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01492);
Date: 2026-07-06 08:50:15 Duration: 1m57s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
2 8 906.76 MiB 69.61 MiB 233.36 MiB 113.35 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-06 05:32:02 Duration: 1m23s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-06 05:31:54 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
3 2 178.47 MiB 89.23 MiB 89.23 MiB 89.23 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-06 05:30:39 Duration: 37s397ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-06 05:30:35 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
4 1 182.01 MiB 182.01 MiB 182.01 MiB 182.01 MiB select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026673, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-06 15:29:03 Duration: 7m53s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026644, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-06 09:29:23 Duration: 7m37s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026666, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-06 14:29:15 Duration: 7m34s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
Queries generating the largest temporary files
Rank Size Query 1 233.36 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-06 05:31:54 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 233.36 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-06 05:31:54 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 182.06 MiB SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01500);[ Date: 2026-07-06 11:28:25 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
4 182.02 MiB SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01498);[ Date: 2026-07-06 11:06:44 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
5 182.01 MiB SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01492);[ Date: 2026-07-06 08:50:10 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
6 182.01 MiB SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01493);[ Date: 2026-07-06 09:10:38 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
7 182.01 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(2,406,''/var/www/html/uploads/HABLE POÇOS DE CALDAS NF- 533 Pré-Alerta -.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-07-06 09:23:49 - Database: contagem - User: intelifix - Remote: [local] - Application: [unknown] ]
8 182.01 MiB SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01499);[ Date: 2026-07-06 11:16:18 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
9 182.00 MiB SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01501);[ Date: 2026-07-06 16:35:11 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
10 182.00 MiB SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01496);[ Date: 2026-07-06 10:04:08 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
11 182.00 MiB SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01495);[ Date: 2026-07-06 09:54:44 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
12 182.00 MiB SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01491);[ Date: 2026-07-06 08:40:31 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
13 182.00 MiB SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01497);[ Date: 2026-07-06 10:13:58 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
14 181.98 MiB SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01494);[ Date: 2026-07-06 09:43:06 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
15 89.23 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-06 05:30:35 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 89.23 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-06 05:30:35 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 77.10 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-06 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 77.03 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-06 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 77.02 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-06 05:31:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 69.68 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-06 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 6.99 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_07
Database rio - 2026-07-06 14:30:05 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 6.99 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_07
Database rio - 2026-07-06 14:30:05 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (114) Main table analyzed (database rio)
- 1,065 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 114 rio.pg_catalog.pg_class 61 rio.pg_catalog.pg_type 52 rio.public.temp0000284552 46 rio.public.usuarios 44 rio.public.temp0000284534 41 brasilia.public.temp0000235418 40 brasilia.pg_catalog.pg_attribute 38 rio.pg_catalog.pg_index 36 rio.public.temp0000284548 36 rio.public.temp0000284524 36 contagem.public.temp0000226561 31 rio.pg_catalog.pg_depend 28 rio.public.temp0000284536 25 contagem.pg_catalog.pg_attribute 25 rio.public.temp0000284538 23 brasilia.pg_catalog.pg_class 21 rio.public.temp0000284526 20 rio.public.temp0000281789 19 brasilia.public.temp0000235392 19 brasilia.pg_catalog.pg_type 18 contagem.public.usuarios 17 contagem.public.temp0000226520 16 contagem.pg_catalog.pg_class 14 contagem.pg_catalog.pg_type 14 brasilia.pg_catalog.pg_index 12 rio.public.temp0000284562 10 rio.public.temp0000284556 10 rio.public.temp0000284586 10 brasilia.public.usuarios 10 brasilia.pg_catalog.pg_depend 9 contagem.pg_catalog.pg_index 9 rio.public.temp0000283956 9 rio.public.temp0000284544 8 rio.public.temp0000284560 8 contagem.pg_catalog.pg_depend 8 rio.public.temp0000284530 8 brasilia.public.temp0000235408 8 rio.public.temp0000284620 7 brasilia.public.nf_entrada 6 rio.public.temp0000284588 6 brasilia.pg_catalog.pg_shdepend 5 rio.public.temp0000284622 5 rio.public.temp0000284532 5 brasilia.public.temp0000235356 4 rio.public.temp0000284582 4 contagem.public.nf_entrada 4 brasilia.public.temp0000235414 3 rio.pg_catalog.pg_shdepend 3 rio.public.temp0000284554 3 rio.public.tmp_drill_0175 3 rio.public.temp0000284626 3 brasilia.public.temp0000235380 2 brasilia.public.temp0000235412 2 brasilia.auditor.auditor_2026_07 2 brasilia.public.temp0000235358 2 contagem.public.temp0000226553 2 contagem.pg_catalog.pg_shdepend 2 brasilia.public.temp0000235420 2 rio.public.temp0000284244 2 rio.public.temp0000284574 2 rio.auditor.auditor_2026_07 2 template1.pg_catalog.pg_shdepend 2 rio.public.temp0000283932 1 brasilia.public.temp0000235386 1 rio.public.temp0000284614 1 contagem.public.temp0000226571 1 brasilia.public.temp0000235394 1 brasilia.public.temp0000235390 1 rio.public.temp0000284566 1 rio.public.temp0000284600 1 brasilia.public.temp0000235406 1 rio.public.temp0000284630 1 brasilia.public.temp0000235374 1 brasilia.public.temp0000235364 1 rio.public.temp0000284042 1 contagem.auditor.auditor_2026_07 1 postgres.pg_catalog.pg_shdepend 1 rio.public.temp0000284590 1 rio.public.temp0000284568 1 brasilia.public.temp0000235402 1 rio.public.temp0000284598 1 brasilia.public.temp0000235398 1 rio.public.temp0000284558 1 brasilia.public.temp0000235368 1 rio.public.temp0000284602 1 rio.public.temp0000284550 1 rio.public.temp0000284612 1 brasilia.public.temp0000235416 1 rio.public.temp0000284470 1 rio.public.temp0000284564 1 rio.public.temp0000284592 1 Total 1,065 Vacuums per table
Key values
- public.temp0000284552 (46) Main table vacuumed on database rio
- 451 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.public.temp0000284552 46 0 0 0 0 0 0 57,235 6,683 11,736,825 0 0 rio.public.temp0000284534 41 0 0 0 0 0 0 33,502 360 2,378,621 0 0 rio.pg_catalog.pg_attribute 41 38 0 0 0 0 0 20,421 5,972 8,412,359 367 8,745 contagem.public.temp0000226561 31 0 0 0 0 0 0 1,844 266 295,197 0 0 rio.pg_catalog.pg_class 29 25 0 0 0 0 0 4,770 1,678 2,353,362 96 334 rio.pg_catalog.pg_type 23 20 0 0 0 0 0 1,785 540 717,658 75 257 contagem.public.usuarios 17 0 0 0 0 0 0 87 67 35,738 0 0 brasilia.pg_catalog.pg_attribute 13 13 0 0 0 0 0 6,787 1,429 2,612,468 68 1,813 rio.pg_catalog.pg_index 13 13 0 0 0 0 0 794 234 223,820 53 103 rio.public.temp0000281789 13 0 0 0 0 0 0 417 112 99,842 0 0 rio.public.usuarios 13 7 0 0 0 0 0 181 54 95,025 5 15 contagem.pg_catalog.pg_attribute 11 11 0 0 0 0 0 6,822 1,368 2,658,584 18 421 rio.pg_catalog.pg_depend 10 10 0 0 0 0 0 3,319 1,347 1,956,031 67 574 brasilia.pg_catalog.pg_class 9 9 0 0 0 0 0 1,673 345 643,816 24 115 brasilia.pg_catalog.pg_type 8 8 0 0 0 0 0 743 180 248,927 15 77 rio.pg_catalog.pg_statistic 8 8 0 0 0 0 0 10,966 2,552 11,863,124 1,229 4,802 rio.public.temp0000284548 7 0 0 0 0 0 0 6,629 1,655 2,479,259 0 0 template1.pg_catalog.pg_shdepend 7 7 0 0 0 0 0 907 285 586,208 90 211 rio.public.temp0000284556 7 0 0 0 0 0 0 286 37 22,583 0 0 contagem.pg_catalog.pg_class 7 7 0 0 0 0 0 1,522 209 383,042 3 9 rio.public.temp0000284588 6 0 0 0 0 0 0 8,159 23 484,934 0 0 contagem.pg_catalog.pg_type 6 6 0 0 0 0 0 733 175 266,169 4 8 rio.pg_toast.pg_toast_2619 4 4 0 0 0 0 0 1,745 388 2,022,556 105 353 brasilia.pg_catalog.pg_index 4 4 0 0 0 0 0 230 37 47,455 11 19 contagem.pg_catalog.pg_index 4 4 0 0 0 0 0 226 54 61,168 2 2 contagem.pg_catalog.pg_depend 3 3 0 0 0 0 0 956 244 523,129 0 0 rio.public.temp0000284560 3 0 0 0 0 0 0 3,360 1,640 2,282,404 0 0 rio.public.tmp_drill_0175 3 3 0 0 0 0 0 123 9 26,285 0 0 brasilia.pg_catalog.pg_depend 3 3 0 0 0 0 0 936 234 346,260 7 54 rio.public.temp0000284562 3 0 0 0 0 0 0 106 12 8,271 0 0 brasilia.pg_catalog.pg_statistic 3 3 0 0 0 0 0 4,101 589 2,585,483 397 2,587 contagem.pg_catalog.pg_statistic 2 2 0 0 0 0 0 3,442 1,360 4,606,195 1,097 7,446 contagem.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 264 87 315,925 20 42 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 281 57 205,660 19 32 brasilia.public.temp0000235358 2 0 0 0 0 0 0 476 12 30,327 0 0 rio.auditor.auditor_2026_07 2 0 0 0 0 0 0 87,464 35,818 48,561,426 25,450 516,087 rio.public.temp0000284544 2 0 0 0 0 0 0 1,729 10 103,552 0 0 contagem.auditor.auditor_2026_07 2 0 0 0 0 0 0 12,466 6,813 9,065,538 2,381 40,337 rio.public.temp0000284622 2 0 0 0 0 0 0 252 8 16,074 0 0 rio.public.temp0000284626 2 0 0 0 0 0 0 3,264 8 193,782 0 0 rio.public.temp0000284244 2 0 0 0 0 0 0 161 12 11,270 0 0 rio.public.temp0000284586 2 0 0 0 0 0 0 116 111 175,930 0 0 brasilia.public.temp0000235412 2 0 0 0 0 0 0 477 243 390,086 0 0 brasilia.public.temp0000235414 2 0 0 0 0 0 0 477 12 30,418 0 0 rio.public.temp0000284574 2 0 0 0 0 0 0 202 12 13,804 0 0 rio.public.temp0000284620 1 0 0 0 0 0 0 8 5 1,343 0 0 rio.public.temp0000284554 1 0 0 0 0 0 0 104 6 7,062 0 0 brasilia.public.nf_entrada_arquivo_erros 1 0 0 0 0 0 0 181 96 307,180 40 2,223 brasilia.public.temp0000235390 1 0 0 0 0 0 0 238 6 15,166 0 0 rio.public.temp0000284602 1 0 0 0 0 0 0 106 6 7,207 0 0 rio.public.temp0000284566 1 0 0 0 0 0 0 101 6 6,902 0 0 rio.public.temp0000284600 1 0 0 0 0 0 0 96 6 6,575 0 0 brasilia.auditor.auditor_2026_07 1 0 0 0 0 0 0 8,391 5,320 7,400,140 1,525 35,629 rio.public.temp0000284550 1 0 0 0 0 0 0 98 6 6,721 0 0 brasilia.public.temp0000235374 1 0 0 0 0 0 0 238 6 15,165 0 0 rio.public.temp0000284630 1 0 0 0 0 0 0 128 4 8,155 0 0 rio.public.temp0000284582 1 0 0 0 0 0 0 67 66 106,333 0 0 rio.public.temp0000284470 1 0 0 0 0 0 0 98 6 6,720 0 0 rio.public.temp0000284042 1 0 0 0 0 0 0 83 6 5,784 0 0 rio.public.temp0000284564 1 0 0 0 0 0 0 98 6 6,723 0 0 rio.public.temp0000284592 1 0 0 0 0 0 0 105 6 7,149 0 0 rio.public.temp0000283932 1 0 0 0 0 0 0 75 73 114,532 0 0 postgres.pg_catalog.pg_shdepend 1 1 0 0 0 0 0 144 56 83,865 10 30 rio.public.temp0000284590 1 0 0 0 0 0 0 105 6 7,149 0 0 brasilia.public.temp0000235386 1 0 0 0 0 0 0 238 6 15,165 0 0 contagem.public.nf_entrada_arquivos 1 1 0 0 0 0 0 67 41 101,713 6 104 rio.public.temp0000284598 1 0 0 0 0 0 0 1,631 4 96,832 0 0 contagem.public.temp0000226571 1 0 0 0 0 0 0 102 6 6,964 0 0 rio.public.temp0000284558 1 0 0 0 0 0 0 98 6 6,721 0 0 rio.public.acessos 1 0 0 0 0 0 0 21 22 53,826 0 0 brasilia.public.temp0000235368 1 0 0 0 0 0 0 238 6 15,165 0 0 brasilia.public.nf_entrada 1 1 0 0 0 0 0 171 91 202,352 3 4 Total 451 215 0 0 0 0 0 305,466 79,215 130,795,199 33,187 622,433 Vacuum throughput per table
Key values
- auditor.auditor_2026_07 (11.95) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.public.temp0000284552 0 0 2.4 rio.public.temp0000284534 0 0 1.6 rio.pg_catalog.pg_attribute 0 0 3.25 contagem.public.temp0000226561 0 0 0.52 rio.pg_catalog.pg_class 0 0 1.17 rio.pg_catalog.pg_type 0 0 0.4 contagem.public.usuarios 0 0 0.01 brasilia.pg_catalog.pg_attribute 0 0 0.95 rio.pg_catalog.pg_index 0 0 0.38 rio.public.temp0000281789 0 0 0.19 rio.public.usuarios 0 0 0.01 contagem.pg_catalog.pg_attribute 0 0 0.89 rio.pg_catalog.pg_depend 0 0 1.23 brasilia.pg_catalog.pg_class 0 0 0.22 brasilia.pg_catalog.pg_type 0 0 0.17 rio.pg_catalog.pg_statistic 0 0 1.58 rio.public.temp0000284548 0 0 0.33 template1.pg_catalog.pg_shdepend 0 0 0.24 rio.public.temp0000284556 0 0 0.1 contagem.pg_catalog.pg_class 0 0 0.36 rio.public.temp0000284588 0 0 0.3 contagem.pg_catalog.pg_type 0 0 0.1 rio.pg_toast.pg_toast_2619 0 0 0.28 brasilia.pg_catalog.pg_index 0 0 0.02 contagem.pg_catalog.pg_index 0 0 0.13 contagem.pg_catalog.pg_depend 0 0 0.18 rio.public.temp0000284560 0 0 0.16 rio.public.tmp_drill_0175 0 0 0 brasilia.pg_catalog.pg_depend 0 0 0.2 rio.public.temp0000284562 0 0 0.1 brasilia.pg_catalog.pg_statistic 0 0 0.36 contagem.pg_catalog.pg_statistic 0 0 0.34 contagem.pg_toast.pg_toast_2619 0 0 0.02 brasilia.pg_toast.pg_toast_2619 0 0 0.02 brasilia.public.temp0000235358 0 0 0.02 rio.auditor.auditor_2026_07 0 0 11.95 rio.public.temp0000284544 0 0 0.07 contagem.auditor.auditor_2026_07 0 0 2.29 rio.public.temp0000284622 0 0 0 rio.public.temp0000284626 0 0 0.12 rio.public.temp0000284244 0 0 0.04 rio.public.temp0000284586 0 0 0.03 brasilia.public.temp0000235412 0 0 0.04 brasilia.public.temp0000235414 0 0 0.04 rio.public.temp0000284574 0 0 0.04 rio.public.temp0000284620 0 0 0.01 rio.public.temp0000284554 0 0 0.02 brasilia.public.nf_entrada_arquivo_erros 0 0 0.13 brasilia.public.temp0000235390 0 0 0.02 rio.public.temp0000284602 0 0 0.02 rio.public.temp0000284566 0 0 0.02 rio.public.temp0000284600 0 0 0.01 brasilia.auditor.auditor_2026_07 0 0 1.65 rio.public.temp0000284550 0 0 0.02 brasilia.public.temp0000235374 0 0 0.02 rio.public.temp0000284630 0 0 0 rio.public.temp0000284582 0 0 0 rio.public.temp0000284470 0 0 0.02 rio.public.temp0000284042 0 0 0.02 rio.public.temp0000284564 0 0 0.02 rio.public.temp0000284592 0 0 0.02 rio.public.temp0000283932 0 0 0.03 postgres.pg_catalog.pg_shdepend 0 0 0.03 rio.public.temp0000284590 0 0 0.02 brasilia.public.temp0000235386 0 0 0.02 contagem.public.nf_entrada_arquivos 0 0 0.02 rio.public.temp0000284598 0 0 0.05 contagem.public.temp0000226571 0 0 0.02 rio.public.temp0000284558 0 0 0.02 rio.public.acessos 0 0 0.03 brasilia.public.temp0000235368 0 0 0.03 brasilia.public.nf_entrada 0 0 0.09 Total 0 0 35.2100000000001 Tuples removed per table
Key values
- pg_catalog.pg_attribute (154963) Main table with removed tuples on database rio
- 346359 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 41 38 154,963 999,172 48,952 145 24,081 brasilia.pg_catalog.pg_attribute 13 13 64,699 287,603 68 85 7,645 contagem.pg_catalog.pg_attribute 11 11 50,573 261,010 272 233 6,059 rio.pg_catalog.pg_statistic 8 8 14,291 67,182 72 0 10,288 rio.pg_catalog.pg_depend 10 10 10,183 188,877 4,606 0 1,870 brasilia.pg_catalog.pg_statistic 3 3 6,433 23,745 0 0 3,216 rio.pg_catalog.pg_type 23 20 5,655 56,059 3,568 0 1,621 contagem.pg_catalog.pg_statistic 2 2 5,554 14,948 0 0 2,022 template1.pg_catalog.pg_shdepend 7 7 5,117 96,020 1,082 0 805 rio.pg_catalog.pg_class 29 25 4,825 110,170 9,304 0 3,770 brasilia.pg_catalog.pg_type 8 8 3,795 17,620 4 28 535 rio.pg_catalog.pg_index 13 13 3,211 25,231 321 11 720 contagem.pg_catalog.pg_type 6 6 3,048 13,494 12 10 429 brasilia.pg_catalog.pg_class 9 9 2,255 30,389 32 9 1,059 brasilia.pg_catalog.pg_index 4 4 1,551 7,497 0 0 224 rio.auditor.auditor_2026_07 2 0 1,421 6,998,060 0 0 321,670 contagem.pg_catalog.pg_class 7 7 1,327 23,854 32 19 847 contagem.pg_catalog.pg_index 4 4 1,205 7,591 10 4 212 contagem.public.usuarios 17 0 1,095 391 0 0 34 rio.pg_toast.pg_toast_2619 4 4 1,078 2,057 1 21 996 brasilia.pg_catalog.pg_depend 3 3 1,030 54,376 0 18 506 brasilia.auditor.auditor_2026_07 1 0 825 850,022 0 0 35,976 postgres.pg_catalog.pg_shdepend 1 1 573 13,603 0 0 115 rio.public.usuarios 13 7 513 8,407 1,790 0 221 contagem.pg_catalog.pg_depend 3 3 508 56,762 18 0 529 brasilia.public.nf_entrada 1 1 231 4,019 967 0 91 contagem.pg_toast.pg_toast_2619 2 2 171 231 0 0 104 brasilia.pg_toast.pg_toast_2619 2 2 171 267 0 0 118 contagem.public.nf_entrada_arquivos 1 1 58 1,221 0 0 32 rio.public.temp0000284620 1 0 0 4,793 0 20 108 rio.public.temp0000284588 6 0 0 137,649 0 0 9,984 rio.public.temp0000284554 1 0 0 4,285 0 32 96 rio.public.temp0000284560 3 0 0 47,789 0 36 3,420 brasilia.public.nf_entrada_arquivo_erros 1 0 0 1,641,354 0 0 29,367 brasilia.public.temp0000235390 1 0 0 3,069 0 26 230 rio.public.temp0000284602 1 0 0 2,003 0 30 98 rio.public.temp0000284566 1 0 0 1,942 0 35 93 rio.public.temp0000284600 1 0 0 3,923 0 40 88 rio.public.temp0000284550 1 0 0 1,897 0 38 90 brasilia.public.temp0000235374 1 0 0 3,068 0 26 230 brasilia.public.temp0000235358 2 0 0 6,131 0 52 460 rio.public.temp0000284630 1 0 0 5,530 0 0 128 rio.public.temp0000284582 1 0 0 2,767 0 0 64 rio.public.temp0000284548 7 0 0 139,544 0 38 10,074 rio.public.temp0000284470 1 0 0 1,897 0 38 90 rio.public.tmp_drill_0175 3 3 0 1,566 0 0 43 rio.public.temp0000284042 1 0 0 3,336 0 53 75 rio.public.temp0000284564 1 0 0 1,913 0 38 90 rio.public.temp0000284592 1 0 0 1,991 0 31 97 rio.public.temp0000284534 41 0 0 751,738 0 284 54,116 rio.public.temp0000284562 3 0 0 47,784 0 38 3,418 rio.public.temp0000284552 46 0 0 1,034,359 0 33 74,975 rio.public.temp0000283932 1 0 0 2,985 0 61 67 rio.public.temp0000284544 2 0 0 24,841 0 38 1,754 rio.public.temp0000284590 1 0 0 1,991 0 31 97 contagem.auditor.auditor_2026_07 2 0 0 1,150,147 0 0 45,401 brasilia.public.temp0000235386 1 0 0 3,068 0 26 230 rio.public.temp0000281789 13 0 0 34,195 0 338 750 rio.public.temp0000284598 1 0 0 22,939 0 0 1,664 contagem.public.temp0000226561 31 0 0 37,857 0 1,077 2,891 rio.public.temp0000284622 2 0 0 10,862 0 0 256 rio.public.temp0000284556 7 0 0 22,984 0 122 518 rio.public.temp0000284626 2 0 0 45,914 0 0 3,328 contagem.public.temp0000226571 1 0 0 1,227 0 34 94 rio.public.temp0000284244 2 0 0 6,480 0 47 145 rio.public.temp0000284586 2 0 0 9,221 0 48 208 rio.public.temp0000284558 1 0 0 1,897 0 38 90 brasilia.public.temp0000235412 2 0 0 6,143 0 51 461 brasilia.public.temp0000235414 2 0 0 6,143 0 51 461 rio.public.temp0000284574 2 0 0 3,884 0 70 186 rio.public.acessos 1 0 0 103,845 0 0 872 brasilia.public.temp0000235368 1 0 0 3,068 0 26 230 Total 451 215 346,359 15,569,897 71,111 3,529 672,932 Pages removed per table
Key values
- public.temp0000226561 (1077) Main table with removed pages on database contagem
- 3529 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed contagem.public.temp0000226561 31 0 0 1077 rio.public.temp0000281789 13 0 0 338 rio.public.temp0000284534 41 0 0 284 contagem.pg_catalog.pg_attribute 11 11 50573 233 rio.pg_catalog.pg_attribute 41 38 154963 145 rio.public.temp0000284556 7 0 0 122 brasilia.pg_catalog.pg_attribute 13 13 64699 85 rio.public.temp0000284574 2 0 0 70 rio.public.temp0000283932 1 0 0 61 rio.public.temp0000284042 1 0 0 53 brasilia.public.temp0000235358 2 0 0 52 brasilia.public.temp0000235412 2 0 0 51 brasilia.public.temp0000235414 2 0 0 51 rio.public.temp0000284586 2 0 0 48 rio.public.temp0000284244 2 0 0 47 rio.public.temp0000284600 1 0 0 40 rio.public.temp0000284550 1 0 0 38 rio.public.temp0000284548 7 0 0 38 rio.public.temp0000284470 1 0 0 38 rio.public.temp0000284564 1 0 0 38 rio.public.temp0000284562 3 0 0 38 rio.public.temp0000284544 2 0 0 38 rio.public.temp0000284558 1 0 0 38 rio.public.temp0000284560 3 0 0 36 rio.public.temp0000284566 1 0 0 35 contagem.public.temp0000226571 1 0 0 34 rio.public.temp0000284552 46 0 0 33 rio.public.temp0000284554 1 0 0 32 rio.public.temp0000284592 1 0 0 31 rio.public.temp0000284590 1 0 0 31 rio.public.temp0000284602 1 0 0 30 brasilia.pg_catalog.pg_type 8 8 3795 28 brasilia.public.temp0000235390 1 0 0 26 brasilia.public.temp0000235374 1 0 0 26 brasilia.public.temp0000235386 1 0 0 26 brasilia.public.temp0000235368 1 0 0 26 rio.pg_toast.pg_toast_2619 4 4 1078 21 rio.public.temp0000284620 1 0 0 20 contagem.pg_catalog.pg_class 7 7 1327 19 brasilia.pg_catalog.pg_depend 3 3 1030 18 rio.pg_catalog.pg_index 13 13 3211 11 contagem.pg_catalog.pg_type 6 6 3048 10 brasilia.pg_catalog.pg_class 9 9 2255 9 contagem.pg_catalog.pg_index 4 4 1205 4 rio.public.temp0000284588 6 0 0 0 contagem.pg_catalog.pg_depend 3 3 508 0 contagem.pg_catalog.pg_statistic 2 2 5554 0 brasilia.public.nf_entrada_arquivo_erros 1 0 0 0 rio.pg_catalog.pg_statistic 8 8 14291 0 brasilia.auditor.auditor_2026_07 1 0 825 0 contagem.pg_toast.pg_toast_2619 2 2 171 0 brasilia.pg_toast.pg_toast_2619 2 2 171 0 rio.public.temp0000284630 1 0 0 0 rio.auditor.auditor_2026_07 2 0 1421 0 rio.public.temp0000284582 1 0 0 0 template1.pg_catalog.pg_shdepend 7 7 5117 0 rio.public.tmp_drill_0175 3 3 0 0 rio.pg_catalog.pg_class 29 25 4825 0 contagem.public.usuarios 17 0 1095 0 postgres.pg_catalog.pg_shdepend 1 1 573 0 contagem.auditor.auditor_2026_07 2 0 0 0 contagem.public.nf_entrada_arquivos 1 1 58 0 rio.public.temp0000284598 1 0 0 0 rio.public.temp0000284622 2 0 0 0 brasilia.pg_catalog.pg_index 4 4 1551 0 rio.pg_catalog.pg_type 23 20 5655 0 rio.public.temp0000284626 2 0 0 0 brasilia.pg_catalog.pg_statistic 3 3 6433 0 rio.pg_catalog.pg_depend 10 10 10183 0 rio.public.acessos 1 0 0 0 brasilia.public.nf_entrada 1 1 231 0 rio.public.usuarios 13 7 513 0 Total 451 215 346,359 3,529 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 06 00 1 0 01 0 0 02 0 0 03 0 0 04 0 0 05 6 0 06 0 0 07 17 22 08 48 100 09 46 111 10 34 89 11 57 125 12 17 54 13 27 56 14 51 123 15 82 158 16 29 128 17 32 94 18 0 0 19 0 0 20 0 0 21 4 5 22 0 0 23 0 0 - 6.99 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- AccessExclusiveLock Main Lock Type
- 2 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 1 8s624ms 8s624ms 8s624ms 8s624ms call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-06 00:05:23 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-06 10:55:24 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-06 15:25:21 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
2 1 1s1ms 1s1ms 1s1ms 1s1ms drop table if exists temp0000284552;-
DROP TABLE IF EXISTS temp0000284552;
Date: 2026-07-06 17:37:02 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
DROP TABLE IF EXISTS temp0000284552;
Date: 2026-07-06 08:53:43 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
Queries that waited the most
Rank Wait time Query 1 8s624ms CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-07-06 10:55:23 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 1s1ms DROP TABLE IF EXISTS temp0000284552;[ Date: 2026-07-06 17:37:01 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 4,756 Total read queries
- 1,412 Total write queries
Queries by database
Key values
- rio Main database
- 4,677 Requests
- 7h9m55s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 6,396 Requests
User Request type Count Duration etiquetas Total 60 12s245ms select 60 12s245ms intelifix Total 6,396 9h28m6s copy to 353 49m40s ddl 1,059 53m31s others 397 40m27s select 4,585 7h4m26s lenon Total 111 57s606ms select 111 57s606ms Duration by user
Key values
- 9h28m6s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 60 12s245ms select 60 12s245ms intelifix Total 6,396 9h28m6s copy to 353 49m40s ddl 1,059 53m31s others 397 40m27s select 4,585 7h4m26s lenon Total 111 57s606ms select 111 57s606ms Queries by host
Key values
- [local] Main host
- 6,567 Requests
- 9h29m16s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 5,578 Requests
- 4h54m36s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-06 06:52:21 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 3,052 100-500ms duration
Slowest individual queries
Rank Duration Query 1 13m28s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-06 09:18:30 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 12m58s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-06 07:17:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 10m9s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-06 15:15:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 9m57s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-06 14:14:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 9m53s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-06 10:14:54 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 9m5s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-06 11:14:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 8m52s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-06 16:13:53 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 8m42s analyze verbose;[ Date: 2026-07-06 05:08:43 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 8m24s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-06 12:13:26 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 7m53s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026673, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-06 15:29:03 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
11 7m38s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-06 17:12:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 7m37s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026644, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-06 09:29:23 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 7m34s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026666, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-06 14:29:15 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 7m26s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-06 20:12:28 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 7m1s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026657, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-06 12:31:30 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
16 6m57s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-06 18:11:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 6m48s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-06 13:11:49 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 6m43s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026632, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-06 07:23:58 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 6m29s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026650, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-06 10:09:28 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 6m16s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026652, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-06 10:55:23 - 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 2h22m14s 48 1s506ms 13m28s 2m57s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 06 07 3 13m37s 4m32s 08 3 6m20s 2m6s 09 3 14m10s 4m43s 10 3 10m24s 3m28s 11 3 9m33s 3m11s 12 3 8m54s 2m58s 13 3 7m8s 2m22s 14 3 10m25s 3m28s 15 3 10m46s 3m35s 16 3 9m35s 3m11s 17 3 8m 2m40s 18 3 7m20s 2m26s 19 3 5m59s 1m59s 20 3 7m51s 2m37s 21 3 6m 2m 22 3 6m2s 2m [ User: intelifix - Total duration: 2h22m14s - Times executed: 48 ]
[ Application: psql - Total duration: 2h22m14s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-06 09:18:30 Duration: 13m28s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-06 07:17:59 Duration: 12m58s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-06 15:15:11 Duration: 10m9s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
2 1h53m59s 310 153ms 7m53s 22s63ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 06 07 8 15m52s 1m59s 08 26 11m38s 26s863ms 09 42 11m15s 16s79ms 10 24 13m13s 33s42ms 11 26 1m42s 3s942ms 12 24 13m50s 34s615ms 13 16 3m13s 12s86ms 14 45 10m23s 13s866ms 15 50 25m22s 30s448ms 16 27 6m9s 13s699ms 17 22 1m17s 3s526ms [ User: intelifix - Total duration: 1h53m59s - Times executed: 310 ]
[ Application: [unknown] - Total duration: 1h53m59s - Times executed: 310 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026673, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-06 15:29:03 Duration: 7m53s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026644, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-06 09:29:23 Duration: 7m37s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026666, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-06 14:29:15 Duration: 7m34s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
3 1h23m12s 48 276ms 4m58s 1m44s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 06 07 3 5m19s 1m46s 08 3 3m57s 1m19s 09 3 6m39s 2m13s 10 3 6m44s 2m14s 11 3 6m5s 2m1s 12 3 5m27s 1m49s 13 3 4m39s 1m33s 14 3 5m39s 1m53s 15 3 6m6s 2m2s 16 3 5m56s 1m58s 17 3 4m43s 1m34s 18 3 4m53s 1m37s 19 3 3m46s 1m15s 20 3 5m24s 1m48s 21 3 3m54s 1m18s 22 3 3m52s 1m17s [ User: intelifix - Total duration: 1h23m12s - Times executed: 48 ]
[ Application: psql - Total duration: 1h23m12s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-06 10:22:06 Duration: 4m58s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-06 11:20:32 Duration: 4m56s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-06 09:25:45 Duration: 4m47s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
4 27m52s 1,456 151ms 7s501ms 1s148ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 06 07 7 5s934ms 847ms 08 98 1m13s 746ms 09 185 3m23s 1s101ms 10 235 3m53s 993ms 11 169 2m27s 869ms 12 95 1m32s 968ms 13 65 1m22s 1s267ms 14 188 4m32s 1s447ms 15 210 4m45s 1s358ms 16 133 3m30s 1s579ms 17 71 1m6s 943ms [ User: intelifix - Total duration: 27m52s - Times executed: 1456 ]
[ Application: [unknown] - Total duration: 27m52s - Times executed: 1456 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (262649, 450, 'CP2310322B7,D4925E33C670,544D42420065B9CA,D4925E33C673$CP240932QMJ,08C7F52EEE64,544D424200786831,08C7F52EEE67$CP234532ASB,08C7F503702F,544D424200735FEC,08C7F5037032$CP234232UZE,D4925EF9CD62,544D424200725C8F,D4925EF9CD65$CP234232YYQ,D4925EFA3F6E,544D42420072693B,D4925EFA3F71$CP24043222G,08C7F5253C6D,544D424200771F56,08C7F5253C70$CP2317320TH,D4925E947E4C,544D424200681C4E,D4925E947E4F$CP2303324HP,D4925E1442B1,544D42420062C67A,D4925E1442B4$CP232032056,D4925EA38930,544D42420069B0D6,D4925EA38933$CP2233325K6,A0B53C971F8B,544D4242005C306A,A0B53C971F8E$CP23013223U,D4925E01B40D,544D4242006118E4,D4925E01B410$CP240432C4N,08C7F526BDCF,544D424200774A28,08C7F526BDD2$CP2303322CU,D4925E13F0B5,544D42420062BD5E,D4925E13F0B8$CP2409324Z4,08C7F52BFCF5,544D42420078147A,08C7F52BFCF8$CP240932QBV,08C7F52EE32D,544D4242007866F2,08C7F52EE330$CP230232L9U,D4925E0929EA,544D42420061EC5F,D4925E0929ED$CP232232ECL,D4925EBD9539,544D4242006BC8EC,D4925EBD953C$CP2345324LF,08C7F50283A7,544D4242007345A4,08C7F50283AA$CP230232QNL,D4925E09D1DB,544D42420061FF08,D4925E09D1DE$CP2310327ZK,D4925E349ECA,544D42420065D1D4,D4925E349ECD$CP234232S6V,D4925EF9635A,544D4242007250C7,D4925EF9635D$CP2317322C0,D4925E94B8DE,544D4242006822D0,D4925E94B8E1$CP22393242E,A0B53CC0B373,544D4242005E7E58,A0B53CC0B376$CP230232EPN,D4925E08543C,544D42420061D4A1,D4925E08543F$CP240932RJA,08C7F52F10EA,544D424200786C07,08C7F52F10ED$CP240932R1K,08C7F52EFD82,544D4242007869DF,08C7F52EFD85$CP23023208B,D4925E062A8F,544D42420061971C,D4925E062A92$CP2302321EJ,D4925E065882,544D424200619C37,D4925E065885$CP240932813,08C7F52C7219,544D42420078217E,08C7F52C721C$CP24073272D,08C7F52A3883,544D42420077EB04,08C7F52A3886$CP234532FV2,08C7F50432C6,544D42420073758B,08C7F50432C9$CP230232CAB,D4925E07F84D,544D42420061CA6A,$CP2409326AE,08C7F52C305B,544D424200781A30,08C7F52C305E$CP234532DJL,08C7F503DA13,544D424200736BB0,08C7F503DA16$CP2411324E4,08C7F53029EB,544D424200788B40,08C7F53029EE$CP232532MBP,D4925ECEC406,544D4242006D6E2C,D4925ECEC409$CP230232QJV,D4925E09CD88,544D42420061FE8D,D4925E09CD8B$CP2345326D4,08C7F502C7B7,544D424200734D34,08C7F502C7BA$CP23453214G,08C7F501FE45,544D4242007336D2,08C7F501FE48$CP2317320EM,D4925E946F5B,544D424200681AA5,D4925E946F5E', '',0298,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-06 14:43:00 Duration: 7s501ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (262649, 504, 'CP230132RMQ,D4925E0539A2,544D424200617D11,D4925E0539A5$CP2407326JK,08C7F52A2500,544D42420077E8D9,08C7F52A2503$CP2325327S1,D4925ECBD249,544D4242006D3477,D4925ECBD24C$CP2305322G3,D4925E18E999,544D4242006381EC,D4925E18E99C$CP234532EJA,08C7F5040002,544D424200736FE7,08C7F5040005$CP230232K8H,D4925E090215,544D42420061E7F2,D4925E090218$CP232032BH0,D4925EA53C09,544D42420069E127,D4925EA53C0C$CP230232T2Y,D4925E0A2DE5,544D424200620942,D4925E0A2DE8$CP2305324G2,D4925E193610,544D424200638A6B,D4925E193613$CP2301325AA,D4925E022EC8,544D424200612687,D4925E022ECB$CP23463210Q,08C7F506F35B,544D42420073BB26,08C7F506F35E$CP2310327BJ,D4925E348640,544D42420065CF1A,D4925E348643$CP230232ETZ,D4925E08593A,544D42420061D52F,D4925E08593D$CP230132RTF,D4925E054059,544D424200617DD0,D4925E05405C$CP2310325UY,D4925E344DE5,544D42420065C8D7,D4925E344DE8$CP2305322DP,D4925E18E6D2,544D42420063819D,D4925E18E6D5$CP23053232Y,D4925E1900A0,544D42420063847B,D4925E1900A3$CP232532JT1,D4925ECE62F5,544D4242006D6363,D4925ECE62F8$CP234532VKK,08C7F5063FC3,544D42420073AFE0,08C7F5063FC6$CP2409328M1,08C7F52C893B,544D424200782410,08C7F52C893E$CP234232QR4,D4925EF92BC5,544D424200724A9A,D4925EF92BC8$CP2301321U8,D4925E01AAAA,544D4242006117D9,D4925E01AAAD$CP23173226J,D4925E94B28A,544D42420068221C,D4925E94B28D$CP232532KS6,D4925ECE8842,544D4242006D6788,D4925ECE8845$CP232532PW0,D4925ECF25D4,544D4242006D790A,D4925ECF25D7$CP230132RMU,D4925E0539C6,544D424200617D15,D4925E0539C9$CP2241323AW,A0B53CC2B9EC,544D4242005E9E43,A0B53CC2B9EF$CP2411328NS,08C7F530CD1D,544D424200789D62,08C7F530CD20$CP240432P4M,08C7F52862E9,544D4242007778F2,08C7F52862EC$CP234232KDG,D4925EF85ED8,544D4242007233D5,D4925EF85EDB$CP2303326Y7,D4925E149F0C,544D42420062D0BD,D4925E149F0F$CP240932RHC,08C7F52F0FD3,544D424200786BE8,08C7F52F0FD6$CP23053255Z,D4925E1950A4,544D424200638D5F,D4925E1950A7$CP23173243K,D4925E94FBAA,544D424200682A3C,D4925E94FBAD$CP230132WJQ,D4925E05F5AF,544D4242006191F6,D4925E05F5B2$CP231932009,D4925E9F84FA,544D4242006988B4,D4925E9F84FD$CP234532R12,08C7F5059124,544D424200739C79,08C7F5059127$CP2409329WV,08C7F52CBAF1,544D424200782996,08C7F52CBAF4$CP22393283S,A0B53CC14E86,544D4242005E8F93,A0B53CC14E89$CP2303321A3,D4925E13C703,544D42420062B8BC,D4925E13C706', '',0298,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-06 13:52:28 Duration: 7s459ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (44824, 418, '835178926000162,241693231215,241728679601,241659869596,241659753447,241676173658,241695528789,241676739807,241659655053,241728530721,241700957086,241603742526,241731197074,241673344156,241620734061,241728694552,241671551434,241731238290,241707514752,241645681221,241731234351,241654643644,241727017979,241631500522,241704277780,241675553238,241617399807,241659758700,241659824464,241727094149,241695609404,241695516768,241618000304,241607229600,241676711724,241656698187,241636027180,241728672126,241713336072,241646324044,241670287886,241649637083,241659674348,241695551116,241595012224,241659675459,241668207986,241618250912,241654562626,241663842937,241730924242', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"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-06 15:10:40 Duration: 7s237ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
5 22m23s 20 3s201ms 2m21s 1m7s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 06 08 5 4m23s 52s662ms 09 3 5m38s 1m52s 10 2 3m42s 1m51s 11 4 6m11s 1m32s 15 5 32s160ms 6s432ms 16 1 1m54s 1m54s [ User: intelifix - Total duration: 22m23s - Times executed: 20 ]
[ Application: psql - Total duration: 22m23s - Times executed: 20 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01500);
Date: 2026-07-06 11:28:39 Duration: 2m21s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01499);
Date: 2026-07-06 11:16:20 Duration: 1m59s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01492);
Date: 2026-07-06 08:50:15 Duration: 1m57s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
6 18m51s 92 8s980ms 46s352ms 12s299ms create table temp0000284534 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 06 07 17 3m31s 12s465ms 08 8 1m25s 10s720ms 09 6 1m15s 12s592ms 10 12 2m37s 13s121ms 12 10 1m50s 11s10ms 14 6 1m16s 12s751ms 15 27 5m48s 12s904ms 16 6 1m5s 10s972ms [ User: intelifix - Total duration: 18m51s - Times executed: 92 ]
[ Application: [unknown] - Total duration: 18m51s - Times executed: 92 ]
-
CREATE TABLE temp0000284534 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-06 07:13:49 Duration: 46s352ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CREATE TABLE temp0000284534 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-06 10:00:51 Duration: 15s927ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CREATE TABLE temp0000284534 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-06 09:20:10 Duration: 15s677ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
7 14m59s 3 2m19s 8m42s 4m59s analyze verbose;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 06 05 3 14m59s 4m59s [ User: intelifix - Total duration: 14m59s - Times executed: 3 ]
[ Application: psql - Total duration: 14m59s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-06 05:08:43 Duration: 8m42s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
analyze verbose;
Date: 2026-07-06 05:12:40 Duration: 3m57s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
analyze verbose;
Date: 2026-07-06 05:15:00 Duration: 2m19s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
8 13m8s 66 9s421ms 14s430ms 11s945ms create table temp0000284552 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 06 08 7 1m23s 11s946ms 09 4 50s761ms 12s690ms 11 6 1m15s 12s568ms 12 6 1m6s 11s30ms 13 6 1m10s 11s725ms 14 11 2m25s 13s208ms 15 5 1m3s 12s631ms 16 3 36s88ms 12s29ms 17 18 3m17s 10s972ms [ User: intelifix - Total duration: 13m8s - Times executed: 66 ]
[ Application: [unknown] - Total duration: 13m8s - Times executed: 66 ]
-
CREATE TABLE temp0000284552 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-06 14:35:21 Duration: 14s430ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CREATE TABLE temp0000284552 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-06 14:03:04 Duration: 14s359ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CREATE TABLE temp0000284552 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-06 14:57:01 Duration: 14s280ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
9 13m 1,154 151ms 17s931ms 676ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 06 07 8 11s82ms 1s385ms 08 97 1m15s 782ms 09 134 1m25s 634ms 10 160 1m37s 608ms 11 152 1m41s 669ms 12 8 5s169ms 646ms 13 108 1m 555ms 14 171 1m46s 623ms 15 192 2m37s 820ms 16 113 1m11s 636ms 17 11 8s263ms 751ms [ User: intelifix - Total duration: 13m - Times executed: 1154 ]
[ Application: [unknown] - Total duration: 13m - Times executed: 1154 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "243120", "modelo" : "190", "itens" : "229874730816,229885011819,229872266983,229872644450,229872424148,229872430715,229872452939,229873047979,229872295269,229872539210,229870467391,229872609597,229872700618,229872729509,229872430614,229872433947,229872472133,229874357793,229873538285,229874397090,229874405273,229873591524,229873551419,229875437382,229875515774,229894196183,229874364158,229874427878,229873625466,229873171730,229873174154,229874315365,229873525355,229877059000,229877324357,229875368587,229875370508,229875372124,229875385155,229875438089,229875453445,229877227983,229877323751,229875272036,229875152428,229875154044,229877391940", "usuario" : "414", "caixa" : "2915276", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-06 15:46:33 Duration: 17s931ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "262761", "modelo" : "263", "itens" : "229897923741,229902068286,229895394347,229896854254,229897286776,229914938083,229896816775,229905002345,229898793355,229893470524,229898095071,229905543744,229915149899,229910741536,229897440406,229910791417,229910176474,229911912626,229896912644,229892851720,229900809814,229894846078,229908164460,229908404158,229916440218,229910808791,229908111223,229915097392,229893705675,229902767176,229870752526,229897304960,229900373554,229913482746,229913994445,229915088200,229900697075,229911271621,229871795669,229870965476,229910750224,229893088083,225858160909,229914653152,229893146170,229899761418,229870576975,229897242025", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-06 15:08:14 Duration: 3s947ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "262761", "modelo" : "263", "itens" : "229900918084,225769286679,229912116282,229898040723,229898032540,229897106781,229913684359,229892905361,229910788688,229896150516,229910056081,229898740421,229898846064,229902395367,229911138701,229910096870,229897242429,229916001533,229902059295,229871583550,229892936980,229919672037,229896891632,229892812446,229915099918,229896797783,229912218087,229901961229,229918555575,229902119302,229897961523,229920563044,229914845471,229902060711,229910055879,229898462638,229913627686,229913534950,229897835270,229892861418,229910563639,229911691718,229918927384,229915565575,229908026365,229876554046,229897487682,229896774852", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-06 15:03:07 Duration: 3s881ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
10 10m24s 127 160ms 16s213ms 4s920ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 06 00 1 469ms 469ms 06 4 11s607ms 2s901ms 07 12 57s845ms 4s820ms 08 12 1m19s 6s614ms 09 12 1m12s 6s58ms 10 11 1m2s 5s686ms 11 11 1m15s 6s898ms 12 8 59s244ms 7s405ms 13 8 13s632ms 1s704ms 14 12 53s132ms 4s427ms 15 11 1m7s 6s146ms 16 10 49s583ms 4s958ms 17 5 5s252ms 1s50ms 21 4 7s908ms 1s977ms 22 6 8s76ms 1s346ms [ User: intelifix - Total duration: 10m24s - Times executed: 127 ]
[ Application: psql - Total duration: 10m24s - Times executed: 127 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-06 09:25:17 Duration: 16s213ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-06 11:05:16 Duration: 15s638ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-06 07:35:15 Duration: 14s394ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
11 8m43s 208 150ms 21s72ms 2s517ms call rs_giga_triagem (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 06 00 12 38s660ms 3s221ms 01 12 19s338ms 1s611ms 02 11 17s733ms 1s612ms 03 12 18s956ms 1s579ms 04 12 20s721ms 1s726ms 05 11 19s790ms 1s799ms 06 12 20s124ms 1s677ms 07 12 21s118ms 1s759ms 08 12 22s328ms 1s860ms 09 9 20s890ms 2s321ms 10 6 32s979ms 5s496ms 11 7 22s526ms 3s218ms 12 7 24s633ms 3s519ms 13 6 22s652ms 3s775ms 14 9 26s554ms 2s950ms 15 8 30s335ms 3s791ms 16 8 24s921ms 3s115ms 17 7 18s110ms 2s587ms 18 7 20s304ms 2s900ms 19 7 17s285ms 2s469ms 20 7 26s361ms 3s765ms 21 7 19s134ms 2s733ms 22 7 18s280ms 2s611ms [ User: intelifix - Total duration: 8m43s - Times executed: 208 ]
[ Application: psql - Total duration: 8m43s - Times executed: 208 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-06 00:05:23 Duration: 21s72ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-06 10:55:24 Duration: 13s546ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-06 15:25:21 Duration: 10s686ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
12 7m22s 95 1s36ms 32s501ms 4s659ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 06 07 2 5s621ms 2s810ms 08 2 35s313ms 17s656ms 09 10 36s580ms 3s658ms 10 3 8s224ms 2s741ms 11 6 37s310ms 6s218ms 12 5 10s34ms 2s6ms 13 11 31s78ms 2s825ms 14 7 28s715ms 4s102ms 15 10 1m14s 7s411ms 16 19 1m37s 5s116ms 17 19 1m15s 3s975ms 18 1 2s885ms 2s885ms [ User: intelifix - Total duration: 7m22s - Times executed: 95 ]
[ Application: [unknown] - Total duration: 7m22s - Times executed: 95 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-03', 0302, '', '', 0, 6, '2026-07-03');
Date: 2026-07-06 08:35:00 Duration: 32s501ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-06', 099, '', '', 0, 6, '2026-07-01');
Date: 2026-07-06 11:57:21 Duration: 24s578ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-06', 099, '', '', 0, 6, '2026-07-01');
Date: 2026-07-06 15:02:06 Duration: 17s883ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
13 3m44s 45 206ms 31s961ms 4s995ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 06 07 3 35s640ms 11s880ms 08 8 13s369ms 1s671ms 09 3 31s460ms 10s486ms 10 4 21s318ms 5s329ms 11 5 12s732ms 2s546ms 12 2 28s287ms 14s143ms 13 1 2s523ms 2s523ms 14 1 21s608ms 21s608ms 15 9 34s53ms 3s783ms 16 3 9s773ms 3s257ms 17 6 14s38ms 2s339ms [ User: intelifix - Total duration: 3m44s - Times executed: 45 ]
[ Application: psql - Total duration: 3m44s - Times executed: 45 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (026632);
Date: 2026-07-06 07:17:19 Duration: 31s961ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (026644);
Date: 2026-07-06 09:21:44 Duration: 28s724ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (026657);
Date: 2026-07-06 12:23:02 Duration: 26s281ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
14 3m8s 3 5s494ms 1m33s 1m2s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 06 20 2 1m38s 49s433ms 23 1 1m29s 1m29s [ User: intelifix - Total duration: 3m8s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 3m8s - Times executed: 3 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-06 20:08:50 Duration: 1m33s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-06 23:40:03 Duration: 1m29s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-06 20:10:44 Duration: 5s494ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
15 2m23s 60 178ms 53s730ms 2s386ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 06 07 6 5s915ms 985ms 08 6 10s115ms 1s685ms 09 6 4s881ms 813ms 10 4 2s907ms 726ms 11 2 55s763ms 27s881ms 12 6 8s594ms 1s432ms 13 2 3s526ms 1s763ms 14 7 9s574ms 1s367ms 15 10 9s878ms 987ms 16 3 16s253ms 5s417ms 17 8 15s781ms 1s972ms [ User: intelifix - Total duration: 2m23s - Times executed: 60 ]
[ Application: psql - Total duration: 2m23s - Times executed: 60 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026653);
Date: 2026-07-06 11:29:50 Duration: 53s730ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026682);
Date: 2026-07-06 16:35:57 Duration: 14s689ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026687);
Date: 2026-07-06 17:26:24 Duration: 4s192ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
16 2m3s 30 774ms 14s796ms 4s103ms 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 06 08 2 7s703ms 3s851ms 09 2 12s223ms 6s111ms 10 3 13s432ms 4s477ms 11 3 26s339ms 8s779ms 12 2 6s632ms 3s316ms 13 1 4s81ms 4s81ms 14 2 13s218ms 6s609ms 15 2 18s740ms 9s370ms 16 1 5s826ms 5s826ms 17 2 4s563ms 2s281ms 18 2 2s326ms 1s163ms 19 1 831ms 831ms 20 2 2s167ms 1s83ms 21 2 2s111ms 1s55ms 22 3 2s912ms 970ms [ User: intelifix - Total duration: 2m3s - Times executed: 30 ]
[ Application: psql - Total duration: 2m3s - 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-06 11:20:15 Duration: 14s796ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.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-06 15:20:11 Duration: 9s588ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.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-06 15:40:10 Duration: 9s151ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
17 1m54s 1 1m54s 1m54s 1m54s 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 #17
Day Hour Count Duration Avg duration Jul 06 23 1 1m54s 1m54s [ User: intelifix - Total duration: 1m54s - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1m54s - 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-06 23:13:19 Duration: 1m54s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
18 1m54s 4 373ms 58s17ms 28s633ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 06 20 2 56s140ms 28s70ms 23 2 58s391ms 29s195ms [ User: intelifix - Total duration: 1m54s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m54s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-06 23:18:49 Duration: 58s17ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-06 20:05:28 Duration: 55s635ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-06 20:10:06 Duration: 505ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
19 1m52s 2 6s880ms 1m45s 56s257ms copy auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 06 23 2 1m52s 56s257ms [ User: intelifix - Total duration: 1m52s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m52s - Times executed: 2 ]
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-06 23:15:04 Duration: 1m45s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-06 23:40:38 Duration: 6s880ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
20 1m50s 9 9s928ms 14s524ms 12s262ms create table temp0000284548 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 06 08 3 35s497ms 11s832ms 11 1 13s618ms 13s618ms 15 3 40s675ms 13s558ms 17 2 20s570ms 10s285ms [ User: intelifix - Total duration: 1m50s - Times executed: 9 ]
[ Application: [unknown] - Total duration: 1m50s - Times executed: 9 ]
-
CREATE TABLE temp0000284548 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-06 15:38:28 Duration: 14s524ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CREATE TABLE temp0000284548 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-06 15:38:57 Duration: 13s725ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CREATE TABLE temp0000284548 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-06 11:30:52 Duration: 13s618ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,456 27m52s 151ms 7s501ms 1s148ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 06 07 7 5s934ms 847ms 08 98 1m13s 746ms 09 185 3m23s 1s101ms 10 235 3m53s 993ms 11 169 2m27s 869ms 12 95 1m32s 968ms 13 65 1m22s 1s267ms 14 188 4m32s 1s447ms 15 210 4m45s 1s358ms 16 133 3m30s 1s579ms 17 71 1m6s 943ms [ User: intelifix - Total duration: 27m52s - Times executed: 1456 ]
[ Application: [unknown] - Total duration: 27m52s - Times executed: 1456 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (262649, 450, 'CP2310322B7,D4925E33C670,544D42420065B9CA,D4925E33C673$CP240932QMJ,08C7F52EEE64,544D424200786831,08C7F52EEE67$CP234532ASB,08C7F503702F,544D424200735FEC,08C7F5037032$CP234232UZE,D4925EF9CD62,544D424200725C8F,D4925EF9CD65$CP234232YYQ,D4925EFA3F6E,544D42420072693B,D4925EFA3F71$CP24043222G,08C7F5253C6D,544D424200771F56,08C7F5253C70$CP2317320TH,D4925E947E4C,544D424200681C4E,D4925E947E4F$CP2303324HP,D4925E1442B1,544D42420062C67A,D4925E1442B4$CP232032056,D4925EA38930,544D42420069B0D6,D4925EA38933$CP2233325K6,A0B53C971F8B,544D4242005C306A,A0B53C971F8E$CP23013223U,D4925E01B40D,544D4242006118E4,D4925E01B410$CP240432C4N,08C7F526BDCF,544D424200774A28,08C7F526BDD2$CP2303322CU,D4925E13F0B5,544D42420062BD5E,D4925E13F0B8$CP2409324Z4,08C7F52BFCF5,544D42420078147A,08C7F52BFCF8$CP240932QBV,08C7F52EE32D,544D4242007866F2,08C7F52EE330$CP230232L9U,D4925E0929EA,544D42420061EC5F,D4925E0929ED$CP232232ECL,D4925EBD9539,544D4242006BC8EC,D4925EBD953C$CP2345324LF,08C7F50283A7,544D4242007345A4,08C7F50283AA$CP230232QNL,D4925E09D1DB,544D42420061FF08,D4925E09D1DE$CP2310327ZK,D4925E349ECA,544D42420065D1D4,D4925E349ECD$CP234232S6V,D4925EF9635A,544D4242007250C7,D4925EF9635D$CP2317322C0,D4925E94B8DE,544D4242006822D0,D4925E94B8E1$CP22393242E,A0B53CC0B373,544D4242005E7E58,A0B53CC0B376$CP230232EPN,D4925E08543C,544D42420061D4A1,D4925E08543F$CP240932RJA,08C7F52F10EA,544D424200786C07,08C7F52F10ED$CP240932R1K,08C7F52EFD82,544D4242007869DF,08C7F52EFD85$CP23023208B,D4925E062A8F,544D42420061971C,D4925E062A92$CP2302321EJ,D4925E065882,544D424200619C37,D4925E065885$CP240932813,08C7F52C7219,544D42420078217E,08C7F52C721C$CP24073272D,08C7F52A3883,544D42420077EB04,08C7F52A3886$CP234532FV2,08C7F50432C6,544D42420073758B,08C7F50432C9$CP230232CAB,D4925E07F84D,544D42420061CA6A,$CP2409326AE,08C7F52C305B,544D424200781A30,08C7F52C305E$CP234532DJL,08C7F503DA13,544D424200736BB0,08C7F503DA16$CP2411324E4,08C7F53029EB,544D424200788B40,08C7F53029EE$CP232532MBP,D4925ECEC406,544D4242006D6E2C,D4925ECEC409$CP230232QJV,D4925E09CD88,544D42420061FE8D,D4925E09CD8B$CP2345326D4,08C7F502C7B7,544D424200734D34,08C7F502C7BA$CP23453214G,08C7F501FE45,544D4242007336D2,08C7F501FE48$CP2317320EM,D4925E946F5B,544D424200681AA5,D4925E946F5E', '',0298,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-06 14:43:00 Duration: 7s501ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (262649, 504, 'CP230132RMQ,D4925E0539A2,544D424200617D11,D4925E0539A5$CP2407326JK,08C7F52A2500,544D42420077E8D9,08C7F52A2503$CP2325327S1,D4925ECBD249,544D4242006D3477,D4925ECBD24C$CP2305322G3,D4925E18E999,544D4242006381EC,D4925E18E99C$CP234532EJA,08C7F5040002,544D424200736FE7,08C7F5040005$CP230232K8H,D4925E090215,544D42420061E7F2,D4925E090218$CP232032BH0,D4925EA53C09,544D42420069E127,D4925EA53C0C$CP230232T2Y,D4925E0A2DE5,544D424200620942,D4925E0A2DE8$CP2305324G2,D4925E193610,544D424200638A6B,D4925E193613$CP2301325AA,D4925E022EC8,544D424200612687,D4925E022ECB$CP23463210Q,08C7F506F35B,544D42420073BB26,08C7F506F35E$CP2310327BJ,D4925E348640,544D42420065CF1A,D4925E348643$CP230232ETZ,D4925E08593A,544D42420061D52F,D4925E08593D$CP230132RTF,D4925E054059,544D424200617DD0,D4925E05405C$CP2310325UY,D4925E344DE5,544D42420065C8D7,D4925E344DE8$CP2305322DP,D4925E18E6D2,544D42420063819D,D4925E18E6D5$CP23053232Y,D4925E1900A0,544D42420063847B,D4925E1900A3$CP232532JT1,D4925ECE62F5,544D4242006D6363,D4925ECE62F8$CP234532VKK,08C7F5063FC3,544D42420073AFE0,08C7F5063FC6$CP2409328M1,08C7F52C893B,544D424200782410,08C7F52C893E$CP234232QR4,D4925EF92BC5,544D424200724A9A,D4925EF92BC8$CP2301321U8,D4925E01AAAA,544D4242006117D9,D4925E01AAAD$CP23173226J,D4925E94B28A,544D42420068221C,D4925E94B28D$CP232532KS6,D4925ECE8842,544D4242006D6788,D4925ECE8845$CP232532PW0,D4925ECF25D4,544D4242006D790A,D4925ECF25D7$CP230132RMU,D4925E0539C6,544D424200617D15,D4925E0539C9$CP2241323AW,A0B53CC2B9EC,544D4242005E9E43,A0B53CC2B9EF$CP2411328NS,08C7F530CD1D,544D424200789D62,08C7F530CD20$CP240432P4M,08C7F52862E9,544D4242007778F2,08C7F52862EC$CP234232KDG,D4925EF85ED8,544D4242007233D5,D4925EF85EDB$CP2303326Y7,D4925E149F0C,544D42420062D0BD,D4925E149F0F$CP240932RHC,08C7F52F0FD3,544D424200786BE8,08C7F52F0FD6$CP23053255Z,D4925E1950A4,544D424200638D5F,D4925E1950A7$CP23173243K,D4925E94FBAA,544D424200682A3C,D4925E94FBAD$CP230132WJQ,D4925E05F5AF,544D4242006191F6,D4925E05F5B2$CP231932009,D4925E9F84FA,544D4242006988B4,D4925E9F84FD$CP234532R12,08C7F5059124,544D424200739C79,08C7F5059127$CP2409329WV,08C7F52CBAF1,544D424200782996,08C7F52CBAF4$CP22393283S,A0B53CC14E86,544D4242005E8F93,A0B53CC14E89$CP2303321A3,D4925E13C703,544D42420062B8BC,D4925E13C706', '',0298,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-06 13:52:28 Duration: 7s459ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (44824, 418, '835178926000162,241693231215,241728679601,241659869596,241659753447,241676173658,241695528789,241676739807,241659655053,241728530721,241700957086,241603742526,241731197074,241673344156,241620734061,241728694552,241671551434,241731238290,241707514752,241645681221,241731234351,241654643644,241727017979,241631500522,241704277780,241675553238,241617399807,241659758700,241659824464,241727094149,241695609404,241695516768,241618000304,241607229600,241676711724,241656698187,241636027180,241728672126,241713336072,241646324044,241670287886,241649637083,241659674348,241695551116,241595012224,241659675459,241668207986,241618250912,241654562626,241663842937,241730924242', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"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-06 15:10:40 Duration: 7s237ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
2 1,154 13m 151ms 17s931ms 676ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 06 07 8 11s82ms 1s385ms 08 97 1m15s 782ms 09 134 1m25s 634ms 10 160 1m37s 608ms 11 152 1m41s 669ms 12 8 5s169ms 646ms 13 108 1m 555ms 14 171 1m46s 623ms 15 192 2m37s 820ms 16 113 1m11s 636ms 17 11 8s263ms 751ms [ User: intelifix - Total duration: 13m - Times executed: 1154 ]
[ Application: [unknown] - Total duration: 13m - Times executed: 1154 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "243120", "modelo" : "190", "itens" : "229874730816,229885011819,229872266983,229872644450,229872424148,229872430715,229872452939,229873047979,229872295269,229872539210,229870467391,229872609597,229872700618,229872729509,229872430614,229872433947,229872472133,229874357793,229873538285,229874397090,229874405273,229873591524,229873551419,229875437382,229875515774,229894196183,229874364158,229874427878,229873625466,229873171730,229873174154,229874315365,229873525355,229877059000,229877324357,229875368587,229875370508,229875372124,229875385155,229875438089,229875453445,229877227983,229877323751,229875272036,229875152428,229875154044,229877391940", "usuario" : "414", "caixa" : "2915276", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-06 15:46:33 Duration: 17s931ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "262761", "modelo" : "263", "itens" : "229897923741,229902068286,229895394347,229896854254,229897286776,229914938083,229896816775,229905002345,229898793355,229893470524,229898095071,229905543744,229915149899,229910741536,229897440406,229910791417,229910176474,229911912626,229896912644,229892851720,229900809814,229894846078,229908164460,229908404158,229916440218,229910808791,229908111223,229915097392,229893705675,229902767176,229870752526,229897304960,229900373554,229913482746,229913994445,229915088200,229900697075,229911271621,229871795669,229870965476,229910750224,229893088083,225858160909,229914653152,229893146170,229899761418,229870576975,229897242025", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-06 15:08:14 Duration: 3s947ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "262761", "modelo" : "263", "itens" : "229900918084,225769286679,229912116282,229898040723,229898032540,229897106781,229913684359,229892905361,229910788688,229896150516,229910056081,229898740421,229898846064,229902395367,229911138701,229910096870,229897242429,229916001533,229902059295,229871583550,229892936980,229919672037,229896891632,229892812446,229915099918,229896797783,229912218087,229901961229,229918555575,229902119302,229897961523,229920563044,229914845471,229902060711,229910055879,229898462638,229913627686,229913534950,229897835270,229892861418,229910563639,229911691718,229918927384,229915565575,229908026365,229876554046,229897487682,229896774852", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-06 15:03:07 Duration: 3s881ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
3 310 1h53m59s 153ms 7m53s 22s63ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 06 07 8 15m52s 1m59s 08 26 11m38s 26s863ms 09 42 11m15s 16s79ms 10 24 13m13s 33s42ms 11 26 1m42s 3s942ms 12 24 13m50s 34s615ms 13 16 3m13s 12s86ms 14 45 10m23s 13s866ms 15 50 25m22s 30s448ms 16 27 6m9s 13s699ms 17 22 1m17s 3s526ms [ User: intelifix - Total duration: 1h53m59s - Times executed: 310 ]
[ Application: [unknown] - Total duration: 1h53m59s - Times executed: 310 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026673, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-06 15:29:03 Duration: 7m53s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026644, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-06 09:29:23 Duration: 7m37s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026666, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-06 14:29:15 Duration: 7m34s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
4 227 1m11s 151ms 1s231ms 316ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 06 07 34 12s267ms 360ms 08 36 11s439ms 317ms 09 27 8s64ms 298ms 10 21 7s405ms 352ms 11 26 8s441ms 324ms 12 22 6s529ms 296ms 14 20 7s439ms 371ms 15 27 6s491ms 240ms 16 14 3s659ms 261ms [ User: intelifix - Total duration: 1m11s - Times executed: 227 ]
[ Application: [unknown] - Total duration: 1m11s - Times executed: 227 ]
-
SELECT * FROM RS_TRIAGEM (310, 5, '95', 2, 'F8D2AC14E8E8,F8D2AC14EE9C,F8D2AC155E7C,4075C3BA6278,F8D2AC14E8C0,08A7C0759A34,B85E71D299AC,00CB7AE1CD34,B85E710A5CAC,C4509CE87564,400FC182373C,80DAC2CC04EC,C4509CAD1D2C,B85E71E35094,80DAC2CC4B50,400FC18259BC,4075C39AD624,CCF3C847F744,400FC182E32C,C4509CE8B6EC,4075C3B9ED98,F8D2AC155454,484BD49F69A4,C4509CAC5BDC,ECA81F245E34,3C82C069E7F4,3C82C08F7428,B85E71D38B78,B85E71DA9FD0,C4509CAC6E24,CCF3C8474344,B85E71C7ADBC,3C82C069896C,C4509CE84F54,B85E71BC0C00,3C82C06A228C,B85E710AF5B8,4075C39B0644,B85E71C8DA84,B85E71EED20C,400FC182BD7C,400FC17F898C,B85E71D36864,C4509CAC218C,CCF3C8487B5C,B85E71EED180,B85E71C8C6E8,B85E71CFC448,3C82C09118F0,484BD499200C,B85E71D0E7C4,C4509CAFCF14,B85E71DA84DC,B85E71C8CBC0,B85E71C7D92C,00CB7ADD1C80,4075C3C08A7C,B85E71EE8090,4075C3BBF688,08A7C06E7BE4,B85E71D9F06C,B85E71C8E0EC,80DAC2CF23C0,C4509CF420EC,ECA81FF9BD9C,4075C3BBD734,F8D2AC95CE94', NULL, NULL, 0185, 00);
Date: 2026-07-06 14:07:30 Duration: 1s231ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_TRIAGEM (405, 5, '113', 3, '216564104243,216752355062,216702820610,216332945353,216725698903,216555591213,216877607274,216877893139,216699085071,216880237789', NULL, NULL, 062, 00);
Date: 2026-07-06 07:02:16 Duration: 1s14ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_TRIAGEM (410, 5, '113', 3, '229927794142,230002658597,229962304143,229955041628,229930699409,230018205861,229985482545,229991979294,230013556384,230008659913,229936624050', NULL, NULL, 0287, 00);
Date: 2026-07-06 08:55:48 Duration: 695ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
5 208 8m43s 150ms 21s72ms 2s517ms call rs_giga_triagem (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 06 00 12 38s660ms 3s221ms 01 12 19s338ms 1s611ms 02 11 17s733ms 1s612ms 03 12 18s956ms 1s579ms 04 12 20s721ms 1s726ms 05 11 19s790ms 1s799ms 06 12 20s124ms 1s677ms 07 12 21s118ms 1s759ms 08 12 22s328ms 1s860ms 09 9 20s890ms 2s321ms 10 6 32s979ms 5s496ms 11 7 22s526ms 3s218ms 12 7 24s633ms 3s519ms 13 6 22s652ms 3s775ms 14 9 26s554ms 2s950ms 15 8 30s335ms 3s791ms 16 8 24s921ms 3s115ms 17 7 18s110ms 2s587ms 18 7 20s304ms 2s900ms 19 7 17s285ms 2s469ms 20 7 26s361ms 3s765ms 21 7 19s134ms 2s733ms 22 7 18s280ms 2s611ms [ User: intelifix - Total duration: 8m43s - Times executed: 208 ]
[ Application: psql - Total duration: 8m43s - Times executed: 208 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-06 00:05:23 Duration: 21s72ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-06 10:55:24 Duration: 13s546ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-06 15:25:21 Duration: 10s686ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
6 192 36s704ms 150ms 661ms 191ms select * from rs_equipamento_consulta (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 06 06 6 2s124ms 354ms 07 22 4s372ms 198ms 08 24 4s271ms 177ms 09 19 3s486ms 183ms 10 23 4s219ms 183ms 11 31 5s954ms 192ms 12 19 3s426ms 180ms 13 8 1s604ms 200ms 14 5 828ms 165ms 15 12 2s380ms 198ms 16 18 3s149ms 174ms 17 3 517ms 172ms 21 2 368ms 184ms [ User: intelifix - Total duration: 36s704ms - Times executed: 192 ]
[ Application: [unknown] - Total duration: 36s704ms - Times executed: 192 ]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('216516003051');
Date: 2026-07-06 06:58:59 Duration: 661ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('216503242131');
Date: 2026-07-06 06:59:42 Duration: 453ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('839037906000461');
Date: 2026-07-06 11:04:23 Duration: 346ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
7 181 29s772ms 150ms 222ms 164ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 06 07 3 500ms 166ms 08 14 2s221ms 158ms 09 21 3s367ms 160ms 10 17 2s823ms 166ms 11 22 3s590ms 163ms 12 6 968ms 161ms 13 7 1s121ms 160ms 14 30 4s921ms 164ms 15 39 6s583ms 168ms 16 18 3s14ms 167ms 17 4 657ms 164ms [ User: intelifix - Total duration: 29s772ms - Times executed: 181 ]
[ Application: [unknown] - Total duration: 29s772ms - Times executed: 181 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-07-06 15:36:41 Duration: 222ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 039;
Date: 2026-07-06 15:54:00 Duration: 210ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0294;
Date: 2026-07-06 15:56:36 Duration: 210ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
8 127 10m24s 160ms 16s213ms 4s920ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 06 00 1 469ms 469ms 06 4 11s607ms 2s901ms 07 12 57s845ms 4s820ms 08 12 1m19s 6s614ms 09 12 1m12s 6s58ms 10 11 1m2s 5s686ms 11 11 1m15s 6s898ms 12 8 59s244ms 7s405ms 13 8 13s632ms 1s704ms 14 12 53s132ms 4s427ms 15 11 1m7s 6s146ms 16 10 49s583ms 4s958ms 17 5 5s252ms 1s50ms 21 4 7s908ms 1s977ms 22 6 8s76ms 1s346ms [ User: intelifix - Total duration: 10m24s - Times executed: 127 ]
[ Application: psql - Total duration: 10m24s - Times executed: 127 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-06 09:25:17 Duration: 16s213ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-06 11:05:16 Duration: 15s638ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-06 07:35:15 Duration: 14s394ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
9 107 42s632ms 214ms 692ms 398ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 06 07 3 1s41ms 347ms 08 16 5s909ms 369ms 09 14 6s14ms 429ms 10 4 1s865ms 466ms 11 7 3s149ms 449ms 12 6 2s368ms 394ms 13 5 1s739ms 347ms 14 15 6s198ms 413ms 15 17 6s514ms 383ms 16 6 2s542ms 423ms 17 13 4s945ms 380ms 18 1 341ms 341ms [ User: intelifix - Total duration: 42s632ms - Times executed: 107 ]
[ Application: [unknown] - Total duration: 42s632ms - Times executed: 107 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-07-06 09:56:14 Duration: 692ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-07-06 14:43:22 Duration: 632ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-07-06 09:31:19 Duration: 602ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
10 105 48s58ms 264ms 753ms 457ms 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 06 06 2 891ms 445ms 07 5 2s585ms 517ms 08 12 5s376ms 448ms 09 11 5s329ms 484ms 10 9 4s51ms 450ms 11 6 3s5ms 500ms 12 6 2s98ms 349ms 13 9 4s444ms 493ms 14 12 5s779ms 481ms 15 16 6s667ms 416ms 16 9 4s369ms 485ms 17 4 1s760ms 440ms 18 1 394ms 394ms 21 3 1s302ms 434ms [ User: lenon - Total duration: 48s58ms - Times executed: 105 ]
[ Application: [unknown] - Total duration: 48s58ms - Times executed: 105 ]
-
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-06 08:59:11 Duration: 753ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-06.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-06 11:26:20 Duration: 737ms Database: contagem User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-06.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-06 16:35:57 Duration: 681ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-06.log
11 96 43s904ms 150ms 12s143ms 457ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 06 07 2 450ms 225ms 08 1 269ms 269ms 09 1 318ms 318ms 10 2 728ms 364ms 11 6 2s98ms 349ms 12 4 1s777ms 444ms 13 4 696ms 174ms 14 12 4s243ms 353ms 15 33 7s747ms 234ms 16 22 23s723ms 1s78ms 17 9 1s850ms 205ms [ User: intelifix - Total duration: 43s904ms - Times executed: 96 ]
[ Application: [unknown] - Total duration: 43s904ms - Times executed: 96 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "0", "data-de" : "2026-07-06", "data-ate" : "2026-07-06", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "0", "usuario" : 406 }');
Date: 2026-07-06 16:28:16 Duration: 12s143ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "0", "data-de" : "2026-07-06", "data-ate" : "2026-07-06", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "0", "usuario" : 406 }');
Date: 2026-07-06 16:49:34 Duration: 4s745ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "0", "data-de" : "2026-07-06", "data-ate" : "2026-07-06", "passos" : "-2" , "modelo" : "0" , "tipo" : 1, "departamento": "0", "usuario" : 406 }');
Date: 2026-07-06 16:28:22 Duration: 1s211ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
12 95 7m22s 1s36ms 32s501ms 4s659ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 06 07 2 5s621ms 2s810ms 08 2 35s313ms 17s656ms 09 10 36s580ms 3s658ms 10 3 8s224ms 2s741ms 11 6 37s310ms 6s218ms 12 5 10s34ms 2s6ms 13 11 31s78ms 2s825ms 14 7 28s715ms 4s102ms 15 10 1m14s 7s411ms 16 19 1m37s 5s116ms 17 19 1m15s 3s975ms 18 1 2s885ms 2s885ms [ User: intelifix - Total duration: 7m22s - Times executed: 95 ]
[ Application: [unknown] - Total duration: 7m22s - Times executed: 95 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-03', 0302, '', '', 0, 6, '2026-07-03');
Date: 2026-07-06 08:35:00 Duration: 32s501ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-06', 099, '', '', 0, 6, '2026-07-01');
Date: 2026-07-06 11:57:21 Duration: 24s578ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-06', 099, '', '', 0, 6, '2026-07-01');
Date: 2026-07-06 15:02:06 Duration: 17s883ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
13 94 53s91ms 333ms 913ms 564ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 06 07 3 1s700ms 566ms 08 11 6s143ms 558ms 09 11 6s419ms 583ms 10 9 5s170ms 574ms 11 6 3s774ms 629ms 12 6 2s600ms 433ms 13 6 3s463ms 577ms 14 12 7s86ms 590ms 15 15 7s791ms 519ms 16 9 5s511ms 612ms 17 4 2s293ms 573ms 18 1 530ms 530ms 21 1 605ms 605ms [ User: intelifix - Total duration: 53s91ms - Times executed: 94 ]
[ Application: [unknown] - Total duration: 53s91ms - Times executed: 94 ]
-
select * from rs_menu_grants (406, 72, 1);
Date: 2026-07-06 11:26:20 Duration: 913ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
select * from rs_menu_grants (428, 21, 1);
Date: 2026-07-06 08:59:11 Duration: 853ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
select * from rs_menu_grants (418, 81, 1);
Date: 2026-07-06 16:35:57 Duration: 825ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
14 92 18m51s 8s980ms 46s352ms 12s299ms create table temp0000284534 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 06 07 17 3m31s 12s465ms 08 8 1m25s 10s720ms 09 6 1m15s 12s592ms 10 12 2m37s 13s121ms 12 10 1m50s 11s10ms 14 6 1m16s 12s751ms 15 27 5m48s 12s904ms 16 6 1m5s 10s972ms [ User: intelifix - Total duration: 18m51s - Times executed: 92 ]
[ Application: [unknown] - Total duration: 18m51s - Times executed: 92 ]
-
CREATE TABLE temp0000284534 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-06 07:13:49 Duration: 46s352ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CREATE TABLE temp0000284534 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-06 10:00:51 Duration: 15s927ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CREATE TABLE temp0000284534 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-06 09:20:10 Duration: 15s677ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
15 84 47s900ms 352ms 2s733ms 570ms create table temp0000226561 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 06 08 15 10s377ms 691ms 09 27 14s731ms 545ms 10 18 9s863ms 547ms 11 24 12s928ms 538ms [ User: intelifix - Total duration: 47s900ms - Times executed: 84 ]
[ Application: [unknown] - Total duration: 47s900ms - Times executed: 84 ]
-
CREATE TABLE temp0000226561 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 02);
Date: 2026-07-06 08:38:14 Duration: 2s733ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CREATE TABLE temp0000226561 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 02);
Date: 2026-07-06 09:09:11 Duration: 787ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CREATE TABLE temp0000226561 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 02);
Date: 2026-07-06 08:39:29 Duration: 758ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
16 72 20s177ms 173ms 1s184ms 280ms create table temp0000235392 as select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 06 12 1 1s184ms 1s184ms 13 9 2s654ms 294ms 14 10 2s841ms 284ms 15 11 3s312ms 301ms 16 11 2s709ms 246ms 17 30 7s475ms 249ms [ User: intelifix - Total duration: 20s177ms - Times executed: 72 ]
[ Application: [unknown] - Total duration: 20s177ms - Times executed: 72 ]
-
CREATE TABLE temp0000235392 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "01-07-2026", "data-ate" : "06-07-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-07-06 12:55:47 Duration: 1s184ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CREATE TABLE temp0000235392 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "01-07-2026", "data-ate" : "06-07-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-07-06 13:27:15 Duration: 840ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CREATE TABLE temp0000235392 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "06-07-2026", "data-ate" : "06-07-2026", "grupo" : "0", "status" : "-1", "tipo" : "N", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-07-06 15:26:39 Duration: 408ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
17 67 18s614ms 155ms 3s399ms 277ms create table temp0000284548 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 06 07 1 3s399ms 3s399ms 08 5 1s44ms 208ms 09 13 3s115ms 239ms 10 7 1s527ms 218ms 11 8 1s932ms 241ms 12 13 2s891ms 222ms 13 2 378ms 189ms 14 5 1s294ms 258ms 15 13 3s30ms 233ms [ User: intelifix - Total duration: 18s614ms - Times executed: 67 ]
[ Application: [unknown] - Total duration: 18s614ms - Times executed: 67 ]
-
CREATE TABLE temp0000284548 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"01-07-2026", "ate" :"06-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-06 07:58:35 Duration: 3s399ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CREATE TABLE temp0000284548 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"01-07-2026", "ate" :"06-07-2026", "nota-fiscal":"2123", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-06 09:37:07 Duration: 333ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CREATE TABLE temp0000284548 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"01-07-2026", "ate" :"06-07-2026", "nota-fiscal":"2123", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-06 15:24:02 Duration: 332ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
18 66 13m8s 9s421ms 14s430ms 11s945ms create table temp0000284552 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 06 08 7 1m23s 11s946ms 09 4 50s761ms 12s690ms 11 6 1m15s 12s568ms 12 6 1m6s 11s30ms 13 6 1m10s 11s725ms 14 11 2m25s 13s208ms 15 5 1m3s 12s631ms 16 3 36s88ms 12s29ms 17 18 3m17s 10s972ms [ User: intelifix - Total duration: 13m8s - Times executed: 66 ]
[ Application: [unknown] - Total duration: 13m8s - Times executed: 66 ]
-
CREATE TABLE temp0000284552 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-06 14:35:21 Duration: 14s430ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CREATE TABLE temp0000284552 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-06 14:03:04 Duration: 14s359ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CREATE TABLE temp0000284552 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-06 14:57:01 Duration: 14s280ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
19 64 16s793ms 150ms 3s279ms 262ms create table temp0000284544 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 06 07 2 3s570ms 1s785ms 08 6 1s712ms 285ms 09 5 1s271ms 254ms 10 5 822ms 164ms 11 12 2s403ms 200ms 12 13 2s514ms 193ms 13 9 1s732ms 192ms 14 6 1s455ms 242ms 16 2 403ms 201ms 17 4 907ms 226ms [ User: intelifix - Total duration: 16s793ms - Times executed: 64 ]
[ Application: [unknown] - Total duration: 16s793ms - Times executed: 64 ]
-
CREATE TABLE temp0000284544 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"01-07-2026", "ate" :"06-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-06 07:46:35 Duration: 3s279ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CREATE TABLE temp0000284544 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"01-07-2026", "ate" :"06-07-2026", "nota-fiscal":"1065334", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-06 08:20:05 Duration: 397ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CREATE TABLE temp0000284544 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"01-07-2026", "ate" :"06-07-2026", "nota-fiscal":"1065334", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-06 09:18:31 Duration: 324ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
20 60 2m23s 178ms 53s730ms 2s386ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 06 07 6 5s915ms 985ms 08 6 10s115ms 1s685ms 09 6 4s881ms 813ms 10 4 2s907ms 726ms 11 2 55s763ms 27s881ms 12 6 8s594ms 1s432ms 13 2 3s526ms 1s763ms 14 7 9s574ms 1s367ms 15 10 9s878ms 987ms 16 3 16s253ms 5s417ms 17 8 15s781ms 1s972ms [ User: intelifix - Total duration: 2m23s - Times executed: 60 ]
[ Application: psql - Total duration: 2m23s - Times executed: 60 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026653);
Date: 2026-07-06 11:29:50 Duration: 53s730ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026682);
Date: 2026-07-06 16:35:57 Duration: 14s689ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026687);
Date: 2026-07-06 17:26:24 Duration: 4s192ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m19s 8m42s 4m59s 3 14m59s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 06 05 3 14m59s 4m59s [ User: intelifix - Total duration: 14m59s - Times executed: 3 ]
[ Application: psql - Total duration: 14m59s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-06 05:08:43 Duration: 8m42s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
analyze verbose;
Date: 2026-07-06 05:12:40 Duration: 3m57s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
analyze verbose;
Date: 2026-07-06 05:15:00 Duration: 2m19s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
2 1s506ms 13m28s 2m57s 48 2h22m14s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 06 07 3 13m37s 4m32s 08 3 6m20s 2m6s 09 3 14m10s 4m43s 10 3 10m24s 3m28s 11 3 9m33s 3m11s 12 3 8m54s 2m58s 13 3 7m8s 2m22s 14 3 10m25s 3m28s 15 3 10m46s 3m35s 16 3 9m35s 3m11s 17 3 8m 2m40s 18 3 7m20s 2m26s 19 3 5m59s 1m59s 20 3 7m51s 2m37s 21 3 6m 2m 22 3 6m2s 2m [ User: intelifix - Total duration: 2h22m14s - Times executed: 48 ]
[ Application: psql - Total duration: 2h22m14s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-06 09:18:30 Duration: 13m28s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-06 07:17:59 Duration: 12m58s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-06 15:15:11 Duration: 10m9s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
3 1m54s 1m54s 1m54s 1 1m54s 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 06 23 1 1m54s 1m54s [ User: intelifix - Total duration: 1m54s - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1m54s - 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-06 23:13:19 Duration: 1m54s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
4 276ms 4m58s 1m44s 48 1h23m12s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 06 07 3 5m19s 1m46s 08 3 3m57s 1m19s 09 3 6m39s 2m13s 10 3 6m44s 2m14s 11 3 6m5s 2m1s 12 3 5m27s 1m49s 13 3 4m39s 1m33s 14 3 5m39s 1m53s 15 3 6m6s 2m2s 16 3 5m56s 1m58s 17 3 4m43s 1m34s 18 3 4m53s 1m37s 19 3 3m46s 1m15s 20 3 5m24s 1m48s 21 3 3m54s 1m18s 22 3 3m52s 1m17s [ User: intelifix - Total duration: 1h23m12s - Times executed: 48 ]
[ Application: psql - Total duration: 1h23m12s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-06 10:22:06 Duration: 4m58s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-06 11:20:32 Duration: 4m56s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-06 09:25:45 Duration: 4m47s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
5 3s201ms 2m21s 1m7s 20 22m23s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 06 08 5 4m23s 52s662ms 09 3 5m38s 1m52s 10 2 3m42s 1m51s 11 4 6m11s 1m32s 15 5 32s160ms 6s432ms 16 1 1m54s 1m54s [ User: intelifix - Total duration: 22m23s - Times executed: 20 ]
[ Application: psql - Total duration: 22m23s - Times executed: 20 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01500);
Date: 2026-07-06 11:28:39 Duration: 2m21s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01499);
Date: 2026-07-06 11:16:20 Duration: 1m59s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01492);
Date: 2026-07-06 08:50:15 Duration: 1m57s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
6 5s494ms 1m33s 1m2s 3 3m8s 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 06 20 2 1m38s 49s433ms 23 1 1m29s 1m29s [ User: intelifix - Total duration: 3m8s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 3m8s - Times executed: 3 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-06 20:08:50 Duration: 1m33s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-06 23:40:03 Duration: 1m29s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-06 20:10:44 Duration: 5s494ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
7 6s880ms 1m45s 56s257ms 2 1m52s copy auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 06 23 2 1m52s 56s257ms [ User: intelifix - Total duration: 1m52s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m52s - Times executed: 2 ]
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-06 23:15:04 Duration: 1m45s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-06 23:40:38 Duration: 6s880ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
8 373ms 58s17ms 28s633ms 4 1m54s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 06 20 2 56s140ms 28s70ms 23 2 58s391ms 29s195ms [ User: intelifix - Total duration: 1m54s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m54s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-06 23:18:49 Duration: 58s17ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-06 20:05:28 Duration: 55s635ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-06 20:10:06 Duration: 505ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-06.log
9 153ms 7m53s 22s63ms 310 1h53m59s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 06 07 8 15m52s 1m59s 08 26 11m38s 26s863ms 09 42 11m15s 16s79ms 10 24 13m13s 33s42ms 11 26 1m42s 3s942ms 12 24 13m50s 34s615ms 13 16 3m13s 12s86ms 14 45 10m23s 13s866ms 15 50 25m22s 30s448ms 16 27 6m9s 13s699ms 17 22 1m17s 3s526ms [ User: intelifix - Total duration: 1h53m59s - Times executed: 310 ]
[ Application: [unknown] - Total duration: 1h53m59s - Times executed: 310 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026673, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-06 15:29:03 Duration: 7m53s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026644, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-06 09:29:23 Duration: 7m37s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026666, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-06 14:29:15 Duration: 7m34s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
10 8s980ms 46s352ms 12s299ms 92 18m51s create table temp0000284534 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 06 07 17 3m31s 12s465ms 08 8 1m25s 10s720ms 09 6 1m15s 12s592ms 10 12 2m37s 13s121ms 12 10 1m50s 11s10ms 14 6 1m16s 12s751ms 15 27 5m48s 12s904ms 16 6 1m5s 10s972ms [ User: intelifix - Total duration: 18m51s - Times executed: 92 ]
[ Application: [unknown] - Total duration: 18m51s - Times executed: 92 ]
-
CREATE TABLE temp0000284534 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-06 07:13:49 Duration: 46s352ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CREATE TABLE temp0000284534 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-06 10:00:51 Duration: 15s927ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CREATE TABLE temp0000284534 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-06 09:20:10 Duration: 15s677ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
11 9s928ms 14s524ms 12s262ms 9 1m50s create table temp0000284548 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 06 08 3 35s497ms 11s832ms 11 1 13s618ms 13s618ms 15 3 40s675ms 13s558ms 17 2 20s570ms 10s285ms [ User: intelifix - Total duration: 1m50s - Times executed: 9 ]
[ Application: [unknown] - Total duration: 1m50s - Times executed: 9 ]
-
CREATE TABLE temp0000284548 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-06 15:38:28 Duration: 14s524ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CREATE TABLE temp0000284548 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-06 15:38:57 Duration: 13s725ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CREATE TABLE temp0000284548 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-06 11:30:52 Duration: 13s618ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
12 9s421ms 14s430ms 11s945ms 66 13m8s create table temp0000284552 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 06 08 7 1m23s 11s946ms 09 4 50s761ms 12s690ms 11 6 1m15s 12s568ms 12 6 1m6s 11s30ms 13 6 1m10s 11s725ms 14 11 2m25s 13s208ms 15 5 1m3s 12s631ms 16 3 36s88ms 12s29ms 17 18 3m17s 10s972ms [ User: intelifix - Total duration: 13m8s - Times executed: 66 ]
[ Application: [unknown] - Total duration: 13m8s - Times executed: 66 ]
-
CREATE TABLE temp0000284552 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-06 14:35:21 Duration: 14s430ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CREATE TABLE temp0000284552 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-06 14:03:04 Duration: 14s359ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CREATE TABLE temp0000284552 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-06 14:57:01 Duration: 14s280ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
13 206ms 31s961ms 4s995ms 45 3m44s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 06 07 3 35s640ms 11s880ms 08 8 13s369ms 1s671ms 09 3 31s460ms 10s486ms 10 4 21s318ms 5s329ms 11 5 12s732ms 2s546ms 12 2 28s287ms 14s143ms 13 1 2s523ms 2s523ms 14 1 21s608ms 21s608ms 15 9 34s53ms 3s783ms 16 3 9s773ms 3s257ms 17 6 14s38ms 2s339ms [ User: intelifix - Total duration: 3m44s - Times executed: 45 ]
[ Application: psql - Total duration: 3m44s - Times executed: 45 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (026632);
Date: 2026-07-06 07:17:19 Duration: 31s961ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (026644);
Date: 2026-07-06 09:21:44 Duration: 28s724ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (026657);
Date: 2026-07-06 12:23:02 Duration: 26s281ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
14 160ms 16s213ms 4s920ms 127 10m24s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 06 00 1 469ms 469ms 06 4 11s607ms 2s901ms 07 12 57s845ms 4s820ms 08 12 1m19s 6s614ms 09 12 1m12s 6s58ms 10 11 1m2s 5s686ms 11 11 1m15s 6s898ms 12 8 59s244ms 7s405ms 13 8 13s632ms 1s704ms 14 12 53s132ms 4s427ms 15 11 1m7s 6s146ms 16 10 49s583ms 4s958ms 17 5 5s252ms 1s50ms 21 4 7s908ms 1s977ms 22 6 8s76ms 1s346ms [ User: intelifix - Total duration: 10m24s - Times executed: 127 ]
[ Application: psql - Total duration: 10m24s - Times executed: 127 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-06 09:25:17 Duration: 16s213ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-06 11:05:16 Duration: 15s638ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-06 07:35:15 Duration: 14s394ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
15 1s36ms 32s501ms 4s659ms 95 7m22s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 06 07 2 5s621ms 2s810ms 08 2 35s313ms 17s656ms 09 10 36s580ms 3s658ms 10 3 8s224ms 2s741ms 11 6 37s310ms 6s218ms 12 5 10s34ms 2s6ms 13 11 31s78ms 2s825ms 14 7 28s715ms 4s102ms 15 10 1m14s 7s411ms 16 19 1m37s 5s116ms 17 19 1m15s 3s975ms 18 1 2s885ms 2s885ms [ User: intelifix - Total duration: 7m22s - Times executed: 95 ]
[ Application: [unknown] - Total duration: 7m22s - Times executed: 95 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-03', 0302, '', '', 0, 6, '2026-07-03');
Date: 2026-07-06 08:35:00 Duration: 32s501ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-06', 099, '', '', 0, 6, '2026-07-01');
Date: 2026-07-06 11:57:21 Duration: 24s578ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-06', 099, '', '', 0, 6, '2026-07-01');
Date: 2026-07-06 15:02:06 Duration: 17s883ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
16 774ms 14s796ms 4s103ms 30 2m3s 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 06 08 2 7s703ms 3s851ms 09 2 12s223ms 6s111ms 10 3 13s432ms 4s477ms 11 3 26s339ms 8s779ms 12 2 6s632ms 3s316ms 13 1 4s81ms 4s81ms 14 2 13s218ms 6s609ms 15 2 18s740ms 9s370ms 16 1 5s826ms 5s826ms 17 2 4s563ms 2s281ms 18 2 2s326ms 1s163ms 19 1 831ms 831ms 20 2 2s167ms 1s83ms 21 2 2s111ms 1s55ms 22 3 2s912ms 970ms [ User: intelifix - Total duration: 2m3s - Times executed: 30 ]
[ Application: psql - Total duration: 2m3s - 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-06 11:20:15 Duration: 14s796ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.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-06 15:20:11 Duration: 9s588ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.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-06 15:40:10 Duration: 9s151ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
17 150ms 21s72ms 2s517ms 208 8m43s call rs_giga_triagem (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 06 00 12 38s660ms 3s221ms 01 12 19s338ms 1s611ms 02 11 17s733ms 1s612ms 03 12 18s956ms 1s579ms 04 12 20s721ms 1s726ms 05 11 19s790ms 1s799ms 06 12 20s124ms 1s677ms 07 12 21s118ms 1s759ms 08 12 22s328ms 1s860ms 09 9 20s890ms 2s321ms 10 6 32s979ms 5s496ms 11 7 22s526ms 3s218ms 12 7 24s633ms 3s519ms 13 6 22s652ms 3s775ms 14 9 26s554ms 2s950ms 15 8 30s335ms 3s791ms 16 8 24s921ms 3s115ms 17 7 18s110ms 2s587ms 18 7 20s304ms 2s900ms 19 7 17s285ms 2s469ms 20 7 26s361ms 3s765ms 21 7 19s134ms 2s733ms 22 7 18s280ms 2s611ms [ User: intelifix - Total duration: 8m43s - Times executed: 208 ]
[ Application: psql - Total duration: 8m43s - Times executed: 208 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-06 00:05:23 Duration: 21s72ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-06 10:55:24 Duration: 13s546ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-06 15:25:21 Duration: 10s686ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
18 178ms 53s730ms 2s386ms 60 2m23s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 06 07 6 5s915ms 985ms 08 6 10s115ms 1s685ms 09 6 4s881ms 813ms 10 4 2s907ms 726ms 11 2 55s763ms 27s881ms 12 6 8s594ms 1s432ms 13 2 3s526ms 1s763ms 14 7 9s574ms 1s367ms 15 10 9s878ms 987ms 16 3 16s253ms 5s417ms 17 8 15s781ms 1s972ms [ User: intelifix - Total duration: 2m23s - Times executed: 60 ]
[ Application: psql - Total duration: 2m23s - Times executed: 60 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026653);
Date: 2026-07-06 11:29:50 Duration: 53s730ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026682);
Date: 2026-07-06 16:35:57 Duration: 14s689ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026687);
Date: 2026-07-06 17:26:24 Duration: 4s192ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-06.log
19 151ms 7s501ms 1s148ms 1,456 27m52s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 06 07 7 5s934ms 847ms 08 98 1m13s 746ms 09 185 3m23s 1s101ms 10 235 3m53s 993ms 11 169 2m27s 869ms 12 95 1m32s 968ms 13 65 1m22s 1s267ms 14 188 4m32s 1s447ms 15 210 4m45s 1s358ms 16 133 3m30s 1s579ms 17 71 1m6s 943ms [ User: intelifix - Total duration: 27m52s - Times executed: 1456 ]
[ Application: [unknown] - Total duration: 27m52s - Times executed: 1456 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (262649, 450, 'CP2310322B7,D4925E33C670,544D42420065B9CA,D4925E33C673$CP240932QMJ,08C7F52EEE64,544D424200786831,08C7F52EEE67$CP234532ASB,08C7F503702F,544D424200735FEC,08C7F5037032$CP234232UZE,D4925EF9CD62,544D424200725C8F,D4925EF9CD65$CP234232YYQ,D4925EFA3F6E,544D42420072693B,D4925EFA3F71$CP24043222G,08C7F5253C6D,544D424200771F56,08C7F5253C70$CP2317320TH,D4925E947E4C,544D424200681C4E,D4925E947E4F$CP2303324HP,D4925E1442B1,544D42420062C67A,D4925E1442B4$CP232032056,D4925EA38930,544D42420069B0D6,D4925EA38933$CP2233325K6,A0B53C971F8B,544D4242005C306A,A0B53C971F8E$CP23013223U,D4925E01B40D,544D4242006118E4,D4925E01B410$CP240432C4N,08C7F526BDCF,544D424200774A28,08C7F526BDD2$CP2303322CU,D4925E13F0B5,544D42420062BD5E,D4925E13F0B8$CP2409324Z4,08C7F52BFCF5,544D42420078147A,08C7F52BFCF8$CP240932QBV,08C7F52EE32D,544D4242007866F2,08C7F52EE330$CP230232L9U,D4925E0929EA,544D42420061EC5F,D4925E0929ED$CP232232ECL,D4925EBD9539,544D4242006BC8EC,D4925EBD953C$CP2345324LF,08C7F50283A7,544D4242007345A4,08C7F50283AA$CP230232QNL,D4925E09D1DB,544D42420061FF08,D4925E09D1DE$CP2310327ZK,D4925E349ECA,544D42420065D1D4,D4925E349ECD$CP234232S6V,D4925EF9635A,544D4242007250C7,D4925EF9635D$CP2317322C0,D4925E94B8DE,544D4242006822D0,D4925E94B8E1$CP22393242E,A0B53CC0B373,544D4242005E7E58,A0B53CC0B376$CP230232EPN,D4925E08543C,544D42420061D4A1,D4925E08543F$CP240932RJA,08C7F52F10EA,544D424200786C07,08C7F52F10ED$CP240932R1K,08C7F52EFD82,544D4242007869DF,08C7F52EFD85$CP23023208B,D4925E062A8F,544D42420061971C,D4925E062A92$CP2302321EJ,D4925E065882,544D424200619C37,D4925E065885$CP240932813,08C7F52C7219,544D42420078217E,08C7F52C721C$CP24073272D,08C7F52A3883,544D42420077EB04,08C7F52A3886$CP234532FV2,08C7F50432C6,544D42420073758B,08C7F50432C9$CP230232CAB,D4925E07F84D,544D42420061CA6A,$CP2409326AE,08C7F52C305B,544D424200781A30,08C7F52C305E$CP234532DJL,08C7F503DA13,544D424200736BB0,08C7F503DA16$CP2411324E4,08C7F53029EB,544D424200788B40,08C7F53029EE$CP232532MBP,D4925ECEC406,544D4242006D6E2C,D4925ECEC409$CP230232QJV,D4925E09CD88,544D42420061FE8D,D4925E09CD8B$CP2345326D4,08C7F502C7B7,544D424200734D34,08C7F502C7BA$CP23453214G,08C7F501FE45,544D4242007336D2,08C7F501FE48$CP2317320EM,D4925E946F5B,544D424200681AA5,D4925E946F5E', '',0298,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-06 14:43:00 Duration: 7s501ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (262649, 504, 'CP230132RMQ,D4925E0539A2,544D424200617D11,D4925E0539A5$CP2407326JK,08C7F52A2500,544D42420077E8D9,08C7F52A2503$CP2325327S1,D4925ECBD249,544D4242006D3477,D4925ECBD24C$CP2305322G3,D4925E18E999,544D4242006381EC,D4925E18E99C$CP234532EJA,08C7F5040002,544D424200736FE7,08C7F5040005$CP230232K8H,D4925E090215,544D42420061E7F2,D4925E090218$CP232032BH0,D4925EA53C09,544D42420069E127,D4925EA53C0C$CP230232T2Y,D4925E0A2DE5,544D424200620942,D4925E0A2DE8$CP2305324G2,D4925E193610,544D424200638A6B,D4925E193613$CP2301325AA,D4925E022EC8,544D424200612687,D4925E022ECB$CP23463210Q,08C7F506F35B,544D42420073BB26,08C7F506F35E$CP2310327BJ,D4925E348640,544D42420065CF1A,D4925E348643$CP230232ETZ,D4925E08593A,544D42420061D52F,D4925E08593D$CP230132RTF,D4925E054059,544D424200617DD0,D4925E05405C$CP2310325UY,D4925E344DE5,544D42420065C8D7,D4925E344DE8$CP2305322DP,D4925E18E6D2,544D42420063819D,D4925E18E6D5$CP23053232Y,D4925E1900A0,544D42420063847B,D4925E1900A3$CP232532JT1,D4925ECE62F5,544D4242006D6363,D4925ECE62F8$CP234532VKK,08C7F5063FC3,544D42420073AFE0,08C7F5063FC6$CP2409328M1,08C7F52C893B,544D424200782410,08C7F52C893E$CP234232QR4,D4925EF92BC5,544D424200724A9A,D4925EF92BC8$CP2301321U8,D4925E01AAAA,544D4242006117D9,D4925E01AAAD$CP23173226J,D4925E94B28A,544D42420068221C,D4925E94B28D$CP232532KS6,D4925ECE8842,544D4242006D6788,D4925ECE8845$CP232532PW0,D4925ECF25D4,544D4242006D790A,D4925ECF25D7$CP230132RMU,D4925E0539C6,544D424200617D15,D4925E0539C9$CP2241323AW,A0B53CC2B9EC,544D4242005E9E43,A0B53CC2B9EF$CP2411328NS,08C7F530CD1D,544D424200789D62,08C7F530CD20$CP240432P4M,08C7F52862E9,544D4242007778F2,08C7F52862EC$CP234232KDG,D4925EF85ED8,544D4242007233D5,D4925EF85EDB$CP2303326Y7,D4925E149F0C,544D42420062D0BD,D4925E149F0F$CP240932RHC,08C7F52F0FD3,544D424200786BE8,08C7F52F0FD6$CP23053255Z,D4925E1950A4,544D424200638D5F,D4925E1950A7$CP23173243K,D4925E94FBAA,544D424200682A3C,D4925E94FBAD$CP230132WJQ,D4925E05F5AF,544D4242006191F6,D4925E05F5B2$CP231932009,D4925E9F84FA,544D4242006988B4,D4925E9F84FD$CP234532R12,08C7F5059124,544D424200739C79,08C7F5059127$CP2409329WV,08C7F52CBAF1,544D424200782996,08C7F52CBAF4$CP22393283S,A0B53CC14E86,544D4242005E8F93,A0B53CC14E89$CP2303321A3,D4925E13C703,544D42420062B8BC,D4925E13C706', '',0298,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-06 13:52:28 Duration: 7s459ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (44824, 418, '835178926000162,241693231215,241728679601,241659869596,241659753447,241676173658,241695528789,241676739807,241659655053,241728530721,241700957086,241603742526,241731197074,241673344156,241620734061,241728694552,241671551434,241731238290,241707514752,241645681221,241731234351,241654643644,241727017979,241631500522,241704277780,241675553238,241617399807,241659758700,241659824464,241727094149,241695609404,241695516768,241618000304,241607229600,241676711724,241656698187,241636027180,241728672126,241713336072,241646324044,241670287886,241649637083,241659674348,241695551116,241595012224,241659675459,241668207986,241618250912,241654562626,241663842937,241730924242', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"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-06 15:10:40 Duration: 7s237ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
20 151ms 17s931ms 676ms 1,154 13m select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 06 07 8 11s82ms 1s385ms 08 97 1m15s 782ms 09 134 1m25s 634ms 10 160 1m37s 608ms 11 152 1m41s 669ms 12 8 5s169ms 646ms 13 108 1m 555ms 14 171 1m46s 623ms 15 192 2m37s 820ms 16 113 1m11s 636ms 17 11 8s263ms 751ms [ User: intelifix - Total duration: 13m - Times executed: 1154 ]
[ Application: [unknown] - Total duration: 13m - Times executed: 1154 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "243120", "modelo" : "190", "itens" : "229874730816,229885011819,229872266983,229872644450,229872424148,229872430715,229872452939,229873047979,229872295269,229872539210,229870467391,229872609597,229872700618,229872729509,229872430614,229872433947,229872472133,229874357793,229873538285,229874397090,229874405273,229873591524,229873551419,229875437382,229875515774,229894196183,229874364158,229874427878,229873625466,229873171730,229873174154,229874315365,229873525355,229877059000,229877324357,229875368587,229875370508,229875372124,229875385155,229875438089,229875453445,229877227983,229877323751,229875272036,229875152428,229875154044,229877391940", "usuario" : "414", "caixa" : "2915276", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-06 15:46:33 Duration: 17s931ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "262761", "modelo" : "263", "itens" : "229897923741,229902068286,229895394347,229896854254,229897286776,229914938083,229896816775,229905002345,229898793355,229893470524,229898095071,229905543744,229915149899,229910741536,229897440406,229910791417,229910176474,229911912626,229896912644,229892851720,229900809814,229894846078,229908164460,229908404158,229916440218,229910808791,229908111223,229915097392,229893705675,229902767176,229870752526,229897304960,229900373554,229913482746,229913994445,229915088200,229900697075,229911271621,229871795669,229870965476,229910750224,229893088083,225858160909,229914653152,229893146170,229899761418,229870576975,229897242025", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-06 15:08:14 Duration: 3s947ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "262761", "modelo" : "263", "itens" : "229900918084,225769286679,229912116282,229898040723,229898032540,229897106781,229913684359,229892905361,229910788688,229896150516,229910056081,229898740421,229898846064,229902395367,229911138701,229910096870,229897242429,229916001533,229902059295,229871583550,229892936980,229919672037,229896891632,229892812446,229915099918,229896797783,229912218087,229901961229,229918555575,229902119302,229897961523,229920563044,229914845471,229902060711,229910055879,229898462638,229913627686,229913534950,229897835270,229892861418,229910563639,229911691718,229918927384,229915565575,229908026365,229876554046,229897487682,229896774852", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-06 15:03:07 Duration: 3s881ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-06.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 9 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jul 06 09 1 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms [ User: intelifix - Total duration: 8m59s - Times executed: 8 ]
[ User: lenon - Total duration: 539ms - Times executed: 1 ]
[ Application: psql - Total duration: 8m58s - Times executed: 6 ]
[ Application: [unknown] - Total duration: 1s590ms - Times executed: 3 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 20,118 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 14 FATAL entries
- 4908 ERROR entries
- 0 WARNING entries
- 4 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 4,783 Max number of times the same event was reported
- 4,926 Total events found
Rank Times reported Error 1 4,783 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 06 00 117 01 117 02 115 03 117 04 118 05 116 06 118 07 210 08 326 09 419 10 432 11 410 12 304 13 247 14 429 15 392 16 290 17 153 18 59 19 60 20 59 21 60 22 59 23 56 - ERROR: prepared statement "_PLAN0000000029F730F0" does not exist
- ERROR: prepared statement "_PLAN000000003D334260" does not exist
- ERROR: prepared statement "_PLAN0000000029D31ED0" does not exist
Statement: DEALLOCATE "_PLAN0000000029F730F0"
Date: 2026-07-06 00:00:02 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-06.log
Statement: DEALLOCATE "_PLAN000000003D334260"
Date: 2026-07-06 00:00:43 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-06.log
Statement: DEALLOCATE "_PLAN0000000029D31ED0"
Date: 2026-07-06 00:01:02 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-06.log
2 46 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #2
Day Hour Count Jul 06 00 2 01 2 02 2 03 2 04 2 05 2 06 2 07 2 08 2 09 2 10 2 11 2 12 2 13 2 14 2 15 2 16 2 17 2 18 2 19 2 20 2 21 2 22 2 - ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-06 00:05:02 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-06.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-06 00:35:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-06.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-06 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-06.log
3 45 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #3
Day Hour Count Jul 06 08 3 09 3 10 3 11 3 12 3 13 3 14 3 15 3 16 3 17 3 18 3 19 3 20 3 21 3 22 3 - ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-06 08:00:07 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-06.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-06 08:20:05 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-06.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-06 08:40:06 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-06.log
4 12 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Jul 06 07 2 10 1 11 5 15 4 - ERROR: syntax error at or near ")" at character 41
- ERROR: syntax error at or near ")" at character 41
- ERROR: syntax error at or near "[" at character 35
Statement: SELECT * FROM RS_ETIQUETA(2296899899612,)
Date: 2026-07-06 07:12:51 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-06.log
Statement: SELECT * FROM RS_ETIQUETA(2296899899612,)
Date: 2026-07-06 07:12:51 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-06.log
Statement: select * from rs_caixa_qr(3220546 [)
Date: 2026-07-06 10:45:57 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-06.log
5 9 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #5
Day Hour Count Jul 06 03 9 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-07-06 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-06.log
Date: 2026-07-06 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-06.log
Date: 2026-07-06 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-06.log
6 8 ERROR: function rs_etiqueta(...) does not exist
Times Reported Most Frequent Error / Event #6
Day Hour Count Jul 06 14 8 - 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(73901885850064401080)Date: 2026-07-06 14:23:28 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-06.log
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_ETIQUETA(73901885850064401080)Date: 2026-07-06 14:23:28 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-06.log
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_ETIQUETA(73901885850064401080)Date: 2026-07-06 14:23:40 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-06.log
7 7 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Jul 06 05 4 09 1 16 2 - 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-06 05:32:02 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-06.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-06 05:32:02 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-06.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-06 05:32:02 Database: contagem Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-06.log
8 3 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #8
Day Hour Count Jul 06 00 1 06 1 12 1 - FATAL: database "testes" does not exist
- FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-07-06 00:02:07 Database: testes Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-06.log
Date: 2026-07-06 06:02:06 Database: testes Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-06.log
Date: 2026-07-06 12:29:24 Database: jaboatao Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-06.log
9 3 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #9
Day Hour Count Jul 06 11 1 15 2 - ERROR: column "pas_id" does not exist at character 66 2026-07-06 11:24:42 -03 [1562743]: [72-1] user=intelifix,db=rio,app=[unknown],client=[local] QUERY: SELECT * FROM PARTE_MOVIMENTOS WHERE PM_ID = ANY( aPMs ) AND PAS_ID = nPasso
- ERROR: column "cc03fae1aea0" does not exist at character 27
- ERROR: column "cc03fae1aea0" does not exist at character 27
Context: PL/pgSQL function rs_caixa_kits_exclui(integer,integer) line 46 at FOR over SELECT rows PL/pgSQL function rs_lote_saida_exclui(integer) line 80 at assignment
Hint: Perhaps you meant to reference the column "parte_movimentos.ps_id".
Statement: SELECT * FROM RS_LOTE_SAIDA_EXCLUI(0262632);Date: 2026-07-06 11:24:42 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-06.log
Statement: SELECT * FROM RS_ETIQUETA(CC03FAE1AEA0)
Date: 2026-07-06 15:48:32 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-06.log
Statement: SELECT * FROM RS_ETIQUETA(CC03FAE1AEA0)
Date: 2026-07-06 15:48:32 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-06.log
10 3 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #10
Day Hour Count Jul 06 08 3 - ERROR: trailing junk after numeric literal at or near "2C1DB8287E1C" at character 27
- ERROR: trailing junk after numeric literal at or near "2C1DB8287E1C" at character 27
- ERROR: trailing junk after numeric literal at or near "2C1DB8287E1C" at character 27
Statement: SELECT * FROM RS_ETIQUETA(2C1DB8287E1C)
Date: 2026-07-06 08:15:47 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-06.log
Statement: SELECT * FROM RS_ETIQUETA(2C1DB8287E1C)
Date: 2026-07-06 08:15:47 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-06.log
Statement: SELECT * FROM RS_ETIQUETA(2C1DB8287E1C)
Date: 2026-07-06 08:15:47 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-06.log
11 2 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #11
Day Hour Count Jul 06 10 2 - LOG: process 1570965 still waiting for ShareLock on transaction 2186085 after 1000.135 ms
- LOG: process 1570965 still waiting for ShareLock on transaction 2186085 after 6236.618 ms
Detail: Process holding the lock: 1562743. Wait queue: 1570965.
Context: while updating tuple (72657,67) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-07-06 10:55:15 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-06.log
Detail: Process holding the lock: 1562743. Wait queue: 1570965.
Context: while updating tuple (72657,67) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-07-06 10:55:20 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-06.log
12 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #12
Day Hour Count Jul 06 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-07-06 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-06.log
Date: 2026-07-06 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-06.log
13 1 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #13
Day Hour Count Jul 06 17 1 - LOG: process 1880496 still waiting for AccessExclusiveLock on relation 2062930 of database 358220 after 1000.079 ms
Detail: Process holding the lock: 1918853. Wait queue: 1880496.
Statement: DROP TABLE IF EXISTS temp0000284552;Date: 2026-07-06 17:37:01 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-06.log
14 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #14
Day Hour Count Jul 06 03 1 - LOG: database system was shut down at 2026-07-06 03:05:01 -03
Date: 2026-07-06 03:05:02 Log file: /usr/local/pgsql/data/log/serverlog-06.log
15 1 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #15
Day Hour Count Jul 06 17 1 - ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000284552"
Date: 2026-07-06 17:37:01 Log file: /usr/local/pgsql/data/log/serverlog-06.log