pgBadger-
Global information
- Generated on Mon Jun 29 23:50:12 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 30,976 log entries in 11s
- Log start from 2026-06-29 00:00:35 to 2026-06-29 23:50:00
-
Overview
Global Stats
- 325 Number of unique normalized queries
- 4,631 Number of queries
- 7h39m12s Total query duration
- 2026-06-29 00:02:43 First query
- 2026-06-29 23:48:56 Last query
- 4 queries/s at 2026-06-29 23:48:26 Query peak
- 7h39m12s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 7h39m12s Execute total duration
- 3,090 Number of events
- 16 Number of unique normalized events
- 2,921 Max number of times the same event was reported
- 0 Number of cancellation
- 280 Total number of automatic vacuums
- 589 Total number of automatic analyzes
- 17 Number temporary file
- 232.38 MiB Max size of temporary file
- 106.40 MiB Average size of temporary file
- 299 Total number of sessions
- 9 sessions at 2026-06-29 08:26:42 Session peak
- 11d9h30m43s Total duration of sessions
- 54m53s Average duration of sessions
- 15 Average queries per session
- 1m32s Average queries duration per session
- 53m20s Average idle time per session
- 306 Total number of connections
- 5 connections/s at 2026-06-29 03:05:16 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 4 queries/s Query Peak
- 2026-06-29 23:48:26 Date
SELECT Traffic
Key values
- 4 queries/s Query Peak
- 2026-06-29 07:57:35 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-06-29 23:48:26 Date
Queries duration
Key values
- 7h39m12s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 29 00 18 0ms 40s985ms 8s595ms 3s682ms 24s657ms 1m3s 01 7 0ms 4s120ms 3s233ms 3s283ms 3s772ms 4s300ms 02 8 0ms 4s378ms 2s622ms 3s131ms 3s403ms 4s378ms 03 14 0ms 3s888ms 1s662ms 3s20ms 3s980ms 4s632ms 04 7 0ms 4s175ms 2s903ms 2s913ms 3s203ms 4s343ms 05 14 0ms 9m22s 1m21s 4s204ms 2m39s 9m22s 06 50 0ms 1m32s 5s598ms 6s875ms 40s364ms 1m53s 07 612 0ms 15m18s 4s434ms 1m8s 4m35s 15m53s 08 830 150ms 8m49s 3s263ms 1m25s 4m56s 8m55s 09 885 150ms 13m31s 4s204ms 2m15s 5m9s 13m54s 10 798 150ms 12m6s 3s898ms 1m49s 5m38s 12m20s 11 496 0ms 11m58s 5s916ms 1m19s 6m32s 12m1s 12 92 0ms 10m54s 11s576ms 5s108ms 1m42s 10m58s 13 18 0ms 6m3s 34s919ms 2s360ms 3s88ms 6m46s 14 17 0ms 5m32s 34s445ms 2s722ms 43s506ms 5m32s 15 16 0ms 6m 39s528ms 2s600ms 3s148ms 6m44s 16 115 0ms 5m34s 6s98ms 13s439ms 45s198ms 5m34s 17 86 0ms 5m48s 7s706ms 3s718ms 48s270ms 5m48s 18 18 0ms 5m43s 34s85ms 2s646ms 46s202ms 5m43s 19 16 0ms 5m34s 37s138ms 3s194ms 47s992ms 5m34s 20 115 0ms 11m39s 14s300ms 1m6s 2m20s 11m39s 21 30 0ms 5m46s 20s66ms 4s576ms 42s568ms 5m46s 22 23 0ms 6m15s 28s175ms 4s439ms 17s292ms 6m46s 23 346 0ms 1m34s 6s726ms 1m22s 1m32s 1m39s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 29 00 4 0 11s985ms 0ms 0ms 466ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 2 0 201ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 34 0 5s464ms 0ms 3s118ms 43s269ms 07 534 0 4s482ms 15s443ms 31s421ms 7m55s 08 695 0 3s216ms 18s631ms 1m21s 6m56s 09 700 0 4s90ms 48s961ms 1m53s 6m34s 10 649 0 3s894ms 36s514ms 54s4ms 7m17s 11 409 0 6s425ms 30s200ms 1m17s 7m55s 12 66 0 15s609ms 1s557ms 3s368ms 3m51s 13 6 0 1m41s 0ms 0ms 3m21s 14 6 0 1m34s 0ms 0ms 3m11s 15 6 0 1m42s 0ms 0ms 3m27s 16 73 0 9s4ms 1s519ms 11s112ms 3m11s 17 67 0 9s531ms 1s548ms 2s681ms 3m26s 18 8 0 1m14s 0ms 0ms 3m23s 19 6 0 1m35s 0ms 0ms 3m10s 20 21 84 15s387ms 36s457ms 1m6s 3m52s 21 15 0 38s411ms 0ms 927ms 3m3s 22 6 0 1m43s 0ms 0ms 3m14s 23 19 327 6s726ms 1m6s 1m22s 1m34s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 29 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jun 29 00 0 1 1.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 4 4.00 0.00% 07 0 21 21.00 0.00% 08 0 20 20.00 0.00% 09 0 19 19.00 0.00% 10 0 20 20.00 0.00% 11 0 11 11.00 0.00% 12 0 2 2.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 7 7.00 0.00% 17 0 2 2.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 1 1.00 0.00% 21 0 2 2.00 0.00% 22 0 0 0.00 0.00% 23 0 2 2.00 0.00% Day Hour Count Average / Second Jun 29 00 13 0.00/s 01 6 0.00/s 02 5 0.00/s 03 15 0.00/s 04 9 0.00/s 05 9 0.00/s 06 15 0.00/s 07 23 0.01/s 08 25 0.01/s 09 22 0.01/s 10 20 0.01/s 11 21 0.01/s 12 12 0.00/s 13 8 0.00/s 14 8 0.00/s 15 8 0.00/s 16 19 0.01/s 17 12 0.00/s 18 8 0.00/s 19 7 0.00/s 20 9 0.00/s 21 10 0.00/s 22 8 0.00/s 23 14 0.00/s Day Hour Count Average Duration Average idle time Jun 29 00 8 57m 56m41s 01 12 1h45s 1h43s 02 6 1h30s 1h26s 03 12 21m19s 21m17s 04 8 1h2m37s 1h2m35s 05 9 54m47s 52m41s 06 8 59m23s 58m48s 07 16 54m27s 51m38s 08 24 52m46s 50m53s 09 25 52m47s 50m18s 10 19 1h1m10s 58m27s 11 22 56m 53m47s 12 19 57m24s 56m28s 13 13 56m23s 55m35s 14 7 1h47s 59m24s 15 9 54m26s 53m16s 16 9 52m23s 51m5s 17 16 1h2m37s 1h1m55s 18 13 56m37s 55m50s 19 7 1h48s 59m23s 20 10 43m16s 40m31s 21 6 57m10s 55m29s 22 10 1h1m13s 1h9s 23 11 47m27s 43m55s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-06-29 03:05:16 Date
Connections per database
Key values
- rio Main Database
- 306 connections Total
Connections per user
Key values
- intelifix Main User
- 306 connections Total
-
Sessions
Simultaneous sessions
Key values
- 9 sessions Session Peak
- 2026-06-29 08:26:42 Date
Histogram of session times
Key values
- 254 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 299 sessions Total
Sessions per user
Key values
- intelifix Main User
- 299 sessions Total
Sessions per host
Key values
- [local] Main Host
- 299 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 19,058 buffers Checkpoint Peak
- 2026-06-29 08:34:38 Date
- 270.021 seconds Highest write time
- 0.120 seconds Sync time
Checkpoints Wal files
Key values
- 21 files Wal files usage Peak
- 2026-06-29 08:34:38 Date
Checkpoints distance
Key values
- 647.11 Mo Distance Peak
- 2026-06-29 08:34:38 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jun 29 00 4,018 269.665s 0.01s 269.685s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 13,143 0.823s 0.015s 0.863s 04 0 0s 0s 0s 05 6,169 617.795s 0.027s 617.867s 06 3,831 384.154s 0.032s 384.236s 07 40,310 2,428.751s 0.466s 2,429.396s 08 69,725 3,238.992s 0.495s 3,239.735s 09 73,825 3,238.639s 0.741s 3,239.674s 10 54,521 3,238.849s 0.583s 3,239.669s 11 74,591 3,081.226s 0.498s 3,081.93s 12 7,694 778.496s 0.177s 778.767s 13 204 20.589s 0.01s 20.626s 14 25 2.537s 0.003s 2.55s 15 21 2.116s 0.004s 2.124s 16 12,414 1,079.637s 0.161s 1,079.876s 17 5,339 536.96s 0.165s 537.212s 18 969 97.357s 0.015s 97.416s 19 24 2.432s 0.003s 2.443s 20 843 153.243s 0.026s 153.296s 21 2,093 210.369s 0.061s 210.498s 22 2,052 206.158s 0.07s 206.282s 23 398 95.761s 0.018s 95.816s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jun 29 00 0 0 1 34 0.002s 0.001s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 5 37 0.009s 0.005s 04 0 0 0 0 0s 0s 05 0 0 2 140 0.002s 0.006s 06 0 0 1 240 0.004s 0.005s 07 0 0 18 4,516 0.025s 0.012s 08 0 0 43 5,989 0.007s 0.012s 09 0 0 63 7,935 0.011s 0.012s 10 0 0 38 7,152 0.011s 0.012s 11 0 0 37 5,793 0.009s 0.012s 12 0 0 4 2,211 0.006s 0.012s 13 0 0 0 67 0.002s 0.004s 14 0 0 0 4 0.002s 0.001s 15 0 0 0 3 0.002s 0.002s 16 0 0 7 1,814 0.009s 0.008s 17 0 0 1 1,960 0.006s 0.011s 18 0 0 0 61 0.002s 0.01s 19 0 0 0 4 0.002s 0.001s 20 0 0 1 76 0.003s 0.004s 21 0 0 1 415 0.007s 0.009s 22 0 0 1 416 0.011s 0.008s 23 0 0 2 99 0.002s 0.006s Day Hour Count Avg time (sec) Jun 29 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Jun 29 00 18,075.00 kB 18,075.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 35,055.50 kB 35,055.50 kB 04 0.00 kB 0.00 kB 05 6,808.50 kB 10,204.83 kB 06 2,447.40 kB 9,616.40 kB 07 24,727.17 kB 53,343.58 kB 08 58,764.08 kB 162,621.75 kB 09 86,349.67 kB 156,209.75 kB 10 51,907.00 kB 94,125.42 kB 11 50,615.83 kB 86,408.33 kB 12 4,743.08 kB 38,448.92 kB 13 240.50 kB 17,425.50 kB 14 173.00 kB 13,323.00 kB 15 166.00 kB 12,008.00 kB 16 13,866.88 kB 23,950.12 kB 17 2,311.91 kB 17,371.73 kB 18 455.14 kB 7,295.57 kB 19 172.00 kB 4,710.00 kB 20 3,493.00 kB 9,435.00 kB 21 1,153.67 kB 5,397.11 kB 22 1,395.25 kB 2,965.38 kB 23 5,376.67 kB 19,655.67 kB -
Temporary Files
Size of temporary files
Key values
- 464.77 MiB Temp Files size Peak
- 2026-06-29 05:32:00 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-06-29 05:32:05 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jun 29 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.08 MiB 06 0 0 0 07 0 0 0 08 1 104.00 MiB 104.00 MiB 09 3 312.00 MiB 104.00 MiB 10 2 208.00 MiB 104.00 MiB 11 1 104.00 MiB 104.00 MiB 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 8 902.96 MiB 69.31 MiB 232.38 MiB 112.87 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-06-29 05:32:08 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-06-29 05:32:00 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 7 728.00 MiB 104.00 MiB 104.00 MiB 104.00 MiB select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026306, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-29 07:32:09 Duration: 7m38s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026331, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-29 10:33:59 Duration: 7m9s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026338, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-29 11:32:18 Duration: 6m58s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
3 2 177.84 MiB 88.92 MiB 88.92 MiB 88.92 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-06-29 05:30:43 Duration: 41s102ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-06-29 05:30:40 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 232.38 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-06-29 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 232.38 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-06-29 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-29 09:41:49 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_exclui_seriais(''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_83.xlsx');[ Date: 2026-06-29 10:42:21 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-29 08:22:54 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
6 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,317,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-29 11:32:19 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
7 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,449,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-29 09:55:09 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
8 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-29 09:07:20 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
9 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,404,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-29 10:16:56 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 88.92 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-06-29 05:30:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 88.92 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-06-29 05:30:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 76.78 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-06-29 05:32:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 76.70 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-06-29 05:32:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 76.69 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-06-29 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 69.39 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-06-29 05:32:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 69.32 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-06-29 05:32:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 69.31 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-06-29 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 42.66 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_06
Database rio - 2026-06-29 08:28:26 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 42.66 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_06
Database rio - 2026-06-29 08:28:26 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (65) Main table analyzed (database rio)
- 589 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 65 rio.public.temp0000283882 38 contagem.pg_catalog.pg_attribute 36 rio.pg_catalog.pg_class 33 contagem.pg_catalog.pg_class 31 rio.public.usuarios 27 rio.pg_catalog.pg_type 26 contagem.pg_catalog.pg_type 24 rio.public.temp0000283914 22 rio.public.temp0000283908 21 rio.pg_catalog.pg_index 17 brasilia.pg_catalog.pg_attribute 17 rio.public.temp0000283886 17 contagem.pg_catalog.pg_index 16 contagem.pg_catalog.pg_depend 13 rio.public.temp0000283868 12 contagem.public.temp0000226514 12 rio.public.temp0000283872 12 rio.pg_catalog.pg_depend 12 contagem.public.usuarios 9 brasilia.pg_catalog.pg_class 9 rio.public.temp0000283870 8 brasilia.pg_catalog.pg_type 7 rio.public.temp0000283864 7 rio.public.temp0000281789 7 contagem.public.nf_entrada 6 rio.public.temp0000283390 6 rio.public.temp0000283906 5 brasilia.pg_catalog.pg_shdepend 5 brasilia.public.temp0000234848 5 brasilia.pg_catalog.pg_index 4 rio.public.temp0000283900 4 rio.public.temp0000283866 4 brasilia.pg_catalog.pg_depend 3 brasilia.public.usuarios 3 rio.public.temp0000283894 3 rio.public.temp0000283932 3 brasilia.public.temp0000234844 3 brasilia.public.temp0000234870 3 contagem.public.temp0000226510 3 rio.public.temp0000283876 2 brasilia.public.temp0000234836 2 contagem.pg_catalog.pg_shdepend 2 rio.public.temp0000283936 2 brasilia.public.temp0000234846 2 contagem.public.temp0000226508 2 brasilia.public.temp0000234850 1 rio.public.temp0000283890 1 brasilia.public.temp0000234858 1 contagem.public.temp0000226516 1 rio.public.temp0000283920 1 rio.public.temp0000283896 1 contagem.public.temp0000226518 1 rio.public.temp0000283916 1 template1.pg_catalog.pg_shdepend 1 contagem.public.parametros 1 brasilia.public.temp0000234862 1 brasilia.public.temp0000234842 1 rio.public.temp0000283880 1 rio.public.temp0000283910 1 rio.public.temp0000283892 1 rio.public.temp0000283888 1 brasilia.public.temp0000234876 1 rio.public.temp0000283898 1 brasilia.public.temp0000234884 1 Total 589 Vacuums per table
Key values
- pg_catalog.pg_attribute (29) Main table vacuumed on database rio
- 280 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.pg_catalog.pg_attribute 29 20 0 0 0 0 0 10,872 3,018 4,273,661 205 4,833 rio.public.temp0000283882 24 0 0 0 0 0 0 4,191 119 265,672 0 0 rio.public.temp0000283914 21 0 0 0 0 0 0 21,014 3,297 5,369,710 0 0 rio.public.temp0000283886 17 0 0 0 0 0 0 14,757 72 882,133 0 0 rio.pg_catalog.pg_class 16 12 0 0 0 0 0 2,224 737 1,035,453 40 163 contagem.pg_catalog.pg_attribute 16 16 0 0 0 0 0 9,235 1,931 3,665,879 11 251 rio.pg_catalog.pg_type 14 10 0 0 0 0 0 911 272 354,765 48 159 contagem.pg_catalog.pg_class 13 13 0 0 0 0 0 2,222 441 725,325 4 10 rio.public.temp0000283908 10 0 0 0 0 0 0 438 57 33,486 0 0 contagem.pg_catalog.pg_type 10 10 0 0 0 0 0 1,034 265 434,920 9 16 contagem.public.usuarios 8 0 0 0 0 0 0 49 36 16,786 0 0 contagem.pg_catalog.pg_index 7 7 0 0 0 0 0 301 84 92,847 4 4 rio.public.usuarios 7 4 0 0 0 0 0 85 29 52,601 1 1 contagem.pg_catalog.pg_depend 7 7 0 0 0 0 0 1,861 467 988,115 4 24 rio.public.temp0000283906 6 0 0 0 0 0 0 8,074 1,633 2,538,532 0 0 rio.pg_catalog.pg_index 6 6 0 0 0 0 0 401 105 89,886 28 49 rio.pg_catalog.pg_depend 5 5 0 0 0 0 0 1,731 586 939,234 27 234 rio.public.temp0000281789 5 0 0 0 0 0 0 129 26 11,336 0 0 rio.pg_catalog.pg_statistic 5 5 0 0 0 0 0 6,899 1,457 6,779,534 635 3,286 rio.public.temp0000283872 5 0 0 0 0 0 0 142 26 12,138 0 0 brasilia.pg_catalog.pg_attribute 4 4 0 0 0 0 0 1,674 499 806,419 23 685 rio.public.temp0000283390 4 0 0 0 0 0 0 168 21 12,975 0 0 rio.public.temp0000283866 4 0 0 0 0 0 0 4,846 1,625 2,345,930 0 0 contagem.public.temp0000226514 4 0 0 0 0 0 0 395 24 27,058 0 0 template1.pg_catalog.pg_shdepend 3 3 0 0 0 0 0 445 162 339,715 35 96 rio.public.temp0000283932 3 0 0 0 0 0 0 157 18 11,779 0 0 rio.public.temp0000283936 2 0 0 0 0 0 0 1,618 7 96,603 0 0 brasilia.pg_catalog.pg_class 2 2 0 0 0 0 0 297 134 207,021 12 31 brasilia.pg_catalog.pg_shdepend 2 2 0 0 0 0 0 266 80 170,590 9 15 brasilia.pg_catalog.pg_type 2 2 0 0 0 0 0 100 45 62,340 7 30 brasilia.pg_catalog.pg_index 2 2 0 0 0 0 0 66 25 21,885 8 22 rio.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 1,255 252 1,445,193 117 444 rio.public.temp0000283916 1 0 0 0 0 0 0 8 5 1,320 0 0 rio.public.temp0000283880 1 0 0 0 0 0 0 94 6 6,475 0 0 brasilia.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,509 29 255,393 24 247 rio.public.temp0000283910 1 0 0 0 0 0 0 94 6 6,476 0 0 rio.public.temp0000283892 1 0 0 0 0 0 0 8 5 1,318 0 0 rio.public.temp0000283888 1 0 0 0 0 0 0 8 5 1,320 0 0 rio.public.temp0000283884 1 0 0 0 0 0 0 1,614 4 95,829 0 0 rio.public.temp0000283898 1 0 0 0 0 0 0 8 5 1,319 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 138 19 45,751 2 4 brasilia.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 186 27 139,006 11 52 brasilia.pg_catalog.pg_depend 1 1 0 0 0 0 0 157 82 103,579 7 84 rio.auditor.auditor_2026_06 1 0 0 0 0 0 0 132,716 119,800 147,833,185 5,837 108,935 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,181 93 449,832 80 751 contagem.public.nf_entrada 1 1 0 0 0 0 0 114 36 105,375 3 8 rio.public.temp0000283896 1 0 0 0 0 0 0 8 5 1,319 0 0 Total 280 138 0 0 0 0 0 237,700 137,677 183,157,018 7,191 120,434 Vacuum throughput per table
Key values
- auditor.auditor_2026_06 (42.66) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.pg_catalog.pg_attribute 0 0 2.07 rio.public.temp0000283882 0 0 0.47 rio.public.temp0000283914 0 0 1.12 rio.public.temp0000283886 0 0 0.69 rio.pg_catalog.pg_class 0 0 0.64 contagem.pg_catalog.pg_attribute 0 0 1.26 rio.pg_catalog.pg_type 0 0 0.38 contagem.pg_catalog.pg_class 0 0 0.62 rio.public.temp0000283908 0 0 0.17 contagem.pg_catalog.pg_type 0 0 0.28 contagem.public.usuarios 0 0 0 contagem.pg_catalog.pg_index 0 0 0.3 rio.public.usuarios 0 0 0 contagem.pg_catalog.pg_depend 0 0 0.39 rio.public.temp0000283906 0 0 0.34 rio.pg_catalog.pg_index 0 0 0.23 rio.pg_catalog.pg_depend 0 0 0.6 rio.public.temp0000281789 0 0 0.07 rio.pg_catalog.pg_statistic 0 0 1.08 rio.public.temp0000283872 0 0 0.05 brasilia.pg_catalog.pg_attribute 0 0 0.63 rio.public.temp0000283390 0 0 0.03 rio.public.temp0000283866 0 0 0.24 contagem.public.temp0000226514 0 0 0.06 template1.pg_catalog.pg_shdepend 0 0 0.19 rio.public.temp0000283932 0 0 0.04 rio.public.temp0000283936 0 0 0.1 brasilia.pg_catalog.pg_class 0 0 0.19 brasilia.pg_catalog.pg_shdepend 0 0 0.22 brasilia.pg_catalog.pg_type 0 0 0.15 brasilia.pg_catalog.pg_index 0 0 0.04 rio.pg_toast.pg_toast_2619 0 0 0.15 rio.public.temp0000283916 0 0 0.01 rio.public.temp0000283880 0 0 0.02 brasilia.pg_catalog.pg_statistic 0 0 0.11 rio.public.temp0000283910 0 0 0.02 rio.public.temp0000283892 0 0 0.02 rio.public.temp0000283888 0 0 0.02 rio.public.temp0000283884 0 0 0.05 rio.public.temp0000283898 0 0 0.02 contagem.pg_toast.pg_toast_2619 0 0 0 brasilia.pg_toast.pg_toast_2619 0 0 0.03 brasilia.pg_catalog.pg_depend 0 0 0.24 rio.auditor.auditor_2026_06 0 0 42.66 contagem.pg_catalog.pg_statistic 0 0 0.1 contagem.public.nf_entrada 0 0 0.03 rio.public.temp0000283896 0 0 0.01 Total 0 0 56.14 Tuples removed per table
Key values
- pg_catalog.pg_attribute (83517) Main table with removed tuples on database rio
- 216695 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 29 20 83,517 734,342 69,014 56 16,751 contagem.pg_catalog.pg_attribute 16 16 66,233 383,679 464 33 9,184 brasilia.pg_catalog.pg_attribute 4 4 12,459 87,065 0 0 2,126 rio.pg_catalog.pg_statistic 5 5 9,691 40,807 544 0 6,430 rio.auditor.auditor_2026_06 1 0 9,290 21,999,798 0 0 1,041,210 rio.pg_catalog.pg_depend 5 5 4,768 97,041 1,938 0 905 contagem.pg_catalog.pg_statistic 1 1 4,201 7,274 0 0 1,011 brasilia.pg_catalog.pg_statistic 1 1 3,812 7,318 0 0 1,072 contagem.pg_catalog.pg_type 10 10 3,306 22,482 0 8 667 rio.pg_catalog.pg_type 14 10 3,064 34,562 2,796 0 1,006 contagem.pg_catalog.pg_depend 7 7 2,567 133,201 0 0 1,204 template1.pg_catalog.pg_shdepend 3 3 2,295 40,703 0 0 345 contagem.pg_catalog.pg_class 13 13 1,983 43,040 0 17 1,510 rio.pg_catalog.pg_index 6 6 1,832 11,466 7 0 354 rio.pg_catalog.pg_class 16 12 1,749 59,976 6,954 35 1,810 brasilia.pg_catalog.pg_shdepend 2 2 1,613 27,242 151 0 230 contagem.pg_catalog.pg_index 7 7 1,523 13,277 0 4 354 rio.pg_toast.pg_toast_2619 2 2 776 1,448 0 0 516 contagem.public.usuarios 8 0 476 184 0 0 16 brasilia.pg_catalog.pg_class 2 2 372 6,819 113 0 228 contagem.public.nf_entrada 1 1 242 1,299 0 0 69 brasilia.pg_catalog.pg_index 2 2 242 3,734 0 0 96 brasilia.pg_catalog.pg_type 2 2 167 4,420 0 0 114 brasilia.pg_catalog.pg_depend 1 1 156 18,899 0 0 159 rio.public.usuarios 7 4 151 4,614 1,058 0 119 brasilia.pg_toast.pg_toast_2619 1 1 111 130 0 32 35 contagem.pg_toast.pg_toast_2619 1 1 99 115 0 0 53 rio.public.temp0000283936 2 0 0 45,410 0 0 3,328 rio.public.temp0000283916 1 0 0 1,717 0 41 87 rio.public.temp0000283880 1 0 0 1,692 0 42 86 rio.public.temp0000281789 5 0 0 16,002 0 144 336 rio.public.temp0000283908 10 0 0 25,554 0 307 525 rio.public.temp0000283910 1 0 0 1,692 0 42 86 rio.public.temp0000283892 1 0 0 1,692 0 42 86 rio.public.temp0000283888 1 0 0 1,692 0 42 86 rio.public.temp0000283884 1 0 0 22,704 0 0 1,664 rio.public.temp0000283886 17 0 0 281,047 0 192 20,416 rio.public.temp0000283898 1 0 0 1,692 0 42 86 rio.public.temp0000283390 4 0 0 9,083 0 52 204 rio.public.temp0000283866 4 0 0 90,797 0 0 6,656 rio.public.temp0000283906 6 0 0 136,226 0 0 9,984 contagem.public.temp0000226514 4 0 0 4,735 0 149 363 rio.public.temp0000283914 21 0 0 476,632 0 0 34,944 rio.public.temp0000283896 1 0 0 1,692 0 42 86 rio.public.temp0000283872 5 0 0 8,101 0 106 182 rio.public.temp0000283932 3 0 0 5,920 0 59 133 rio.public.temp0000283882 24 0 0 145,274 0 494 9,490 Total 280 138 216,695 25,064,289 83,039 1,981 1,176,402 Pages removed per table
Key values
- public.temp0000283882 (494) Main table with removed pages on database rio
- 1981 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000283882 24 0 0 494 rio.public.temp0000283908 10 0 0 307 rio.public.temp0000283886 17 0 0 192 contagem.public.temp0000226514 4 0 0 149 rio.public.temp0000281789 5 0 0 144 rio.public.temp0000283872 5 0 0 106 rio.public.temp0000283932 3 0 0 59 rio.pg_catalog.pg_attribute 29 20 83517 56 rio.public.temp0000283390 4 0 0 52 rio.public.temp0000283880 1 0 0 42 rio.public.temp0000283910 1 0 0 42 rio.public.temp0000283892 1 0 0 42 rio.public.temp0000283888 1 0 0 42 rio.public.temp0000283898 1 0 0 42 rio.public.temp0000283896 1 0 0 42 rio.public.temp0000283916 1 0 0 41 rio.pg_catalog.pg_class 16 12 1749 35 contagem.pg_catalog.pg_attribute 16 16 66233 33 brasilia.pg_toast.pg_toast_2619 1 1 111 32 contagem.pg_catalog.pg_class 13 13 1983 17 contagem.pg_catalog.pg_type 10 10 3306 8 contagem.pg_catalog.pg_index 7 7 1523 4 rio.public.temp0000283936 2 0 0 0 template1.pg_catalog.pg_shdepend 3 3 2295 0 brasilia.pg_catalog.pg_class 2 2 372 0 brasilia.pg_catalog.pg_shdepend 2 2 1613 0 rio.pg_catalog.pg_depend 5 5 4768 0 brasilia.pg_catalog.pg_statistic 1 1 3812 0 brasilia.pg_catalog.pg_attribute 4 4 12459 0 rio.public.temp0000283884 1 0 0 0 rio.public.temp0000283866 4 0 0 0 rio.pg_catalog.pg_type 14 10 3064 0 contagem.pg_toast.pg_toast_2619 1 1 99 0 rio.public.temp0000283906 6 0 0 0 brasilia.pg_catalog.pg_type 2 2 167 0 brasilia.pg_catalog.pg_depend 1 1 156 0 rio.auditor.auditor_2026_06 1 0 9290 0 contagem.pg_catalog.pg_statistic 1 1 4201 0 contagem.public.nf_entrada 1 1 242 0 rio.pg_catalog.pg_statistic 5 5 9691 0 rio.pg_catalog.pg_index 6 6 1832 0 brasilia.pg_catalog.pg_index 2 2 242 0 rio.public.temp0000283914 21 0 0 0 rio.public.usuarios 7 4 151 0 contagem.public.usuarios 8 0 476 0 contagem.pg_catalog.pg_depend 7 7 2567 0 rio.pg_toast.pg_toast_2619 2 2 776 0 Total 280 138 216,695 1,981 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jun 29 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 6 0 06 0 3 07 25 63 08 42 107 09 83 151 10 47 118 11 39 67 12 12 25 13 0 0 14 0 0 15 0 0 16 20 33 17 6 19 18 0 0 19 0 0 20 0 0 21 0 3 22 0 0 23 0 0 - 42.66 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- AccessExclusiveLock Main Lock Type
- 3 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 1 1s34ms 1s34ms 1s34ms 1s34ms drop table if exists temp0000283882;-
DROP TABLE IF EXISTS temp0000283882;
Date: 2026-06-29 09:17:44 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
DROP TABLE IF EXISTS temp0000283882;
Date: 2026-06-29 09:17:44 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
2 1 1s 1s 1s 1s drop table if exists temp0000283884;-
DROP TABLE IF EXISTS temp0000283884;
Date: 2026-06-29 10:48:44 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
DROP TABLE IF EXISTS temp0000283884;
Date: 2026-06-29 10:48:44 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
3 1 1s 1s 1s 1s drop table if exists temp0000283906;-
DROP TABLE IF EXISTS temp0000283906;
Date: 2026-06-29 10:45:45 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
DROP TABLE IF EXISTS temp0000283906;
Date: 2026-06-29 10:54:44 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
DROP TABLE IF EXISTS temp0000283906;
Date: 2026-06-29 10:45:45 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
Queries that waited the most
Rank Wait time Query 1 1s34ms DROP TABLE IF EXISTS temp0000283882;[ Date: 2026-06-29 09:17:44 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 1s DROP TABLE IF EXISTS temp0000283884;[ Date: 2026-06-29 10:48:44 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
3 1s DROP TABLE IF EXISTS temp0000283906;[ Date: 2026-06-29 10:45:45 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 3,326 Total read queries
- 996 Total write queries
Queries by database
Key values
- rio Main database
- 3,183 Requests
- 5h50m37s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 5,269 Requests
User Request type Count Duration etiquetas Total 53 13s947ms select 53 13s947ms intelifix Total 5,269 11h40m9s copy to 824 1h40m4s ddl 585 34m27s others 532 1h4m41s select 3,328 8h20m56s lenon Total 80 3m13s select 80 3m13s Duration by user
Key values
- 11h40m9s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 53 13s947ms select 53 13s947ms intelifix Total 5,269 11h40m9s copy to 824 1h40m4s ddl 585 34m27s others 532 1h4m41s select 3,328 8h20m56s lenon Total 80 3m13s select 80 3m13s Queries by host
Key values
- [local] Main host
- 5,402 Requests
- 11h43m37s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 3,706 Requests
- 4h22m2s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-06-29 00:06:05 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 2,213 100-500ms duration
Slowest individual queries
Rank Duration Query 1 15m18s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-29 07:20:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 13m31s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-29 09:18:33 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 12m6s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-29 10:17:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 11m58s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-29 11:17:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 11m39s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-29 20:16:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 10m54s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-29 12:15:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 9m22s analyze verbose;[ Date: 2026-06-29 05:09:23 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 8m49s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-29 08:13:51 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 7m38s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026306, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-06-29 07:32:09 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 7m9s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026331, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-06-29 10:33:59 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
11 6m58s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026338, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-06-29 11:32:18 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
12 6m50s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026310, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-06-29 08:37:43 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 6m28s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026339, 0317 )', '/var/www/html/tmp/nf_carga_lotes_0317.xlsx');[ Date: 2026-06-29 11:41:50 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 6m23s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026316, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-06-29 09:23:04 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
15 6m15s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-29 22:11:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 6m3s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-29 13:11:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 6m SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-29 15:11:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 5m48s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-29 17:10:49 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 5m46s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-29 21:10:48 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 5m43s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-29 18:10:45 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 2h23m4s 48 1s314ms 15m18s 2m58s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 29 07 3 16m7s 5m22s 08 3 9m14s 3m4s 09 3 14m7s 4m42s 10 3 12m44s 4m14s 11 3 12m31s 4m10s 12 3 11m25s 3m48s 13 3 6m18s 2m6s 14 3 5m48s 1m56s 15 3 6m17s 2m5s 16 3 5m49s 1m56s 17 3 6m4s 2m1s 18 3 6m 2m 19 3 5m51s 1m57s 20 3 12m5s 4m1s 21 3 6m2s 2m 22 3 6m34s 2m11s [ User: intelifix - Total duration: 2h23m4s - Times executed: 48 ]
[ Application: psql - Total duration: 2h23m4s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-29 07:20:20 Duration: 15m18s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-29 09:18:33 Duration: 13m31s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-29 10:17:08 Duration: 12m6s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
2 1h13m46s 48 244ms 4m45s 1m32s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 29 07 3 5m44s 1m54s 08 3 5m22s 1m47s 09 3 6m4s 2m1s 10 3 6m24s 2m8s 11 3 5m55s 1m58s 12 3 5m 1m40s 13 3 3m49s 1m16s 14 3 3m38s 1m12s 15 3 3m55s 1m18s 16 3 3m39s 1m13s 17 3 3m56s 1m18s 18 3 3m52s 1m17s 19 3 3m41s 1m13s 20 3 5m25s 1m48s 21 3 3m29s 1m9s 22 3 3m44s 1m14s [ User: intelifix - Total duration: 1h13m46s - Times executed: 48 ]
[ Application: psql - Total duration: 1h13m46s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-29 10:24:01 Duration: 4m45s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-29 09:25:04 Duration: 4m21s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-29 11:23:17 Duration: 4m20s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
3 1h5m52s 180 156ms 7m38s 21s956ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 29 07 32 8m40s 16s263ms 08 26 12m45s 29s445ms 09 55 15m5s 16s460ms 10 31 11m30s 22s258ms 11 21 17m23s 49s709ms 12 6 5s995ms 999ms 16 4 16s802ms 4s200ms 17 5 4s128ms 825ms [ User: intelifix - Total duration: 1h5m52s - Times executed: 180 ]
[ Application: [unknown] - Total duration: 1h5m52s - Times executed: 180 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026306, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-29 07:32:09 Duration: 7m38s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026331, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-29 10:33:59 Duration: 7m9s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026338, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-29 11:32:18 Duration: 6m58s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
4 16m30s 3 2m39s 9m22s 5m30s analyze verbose;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 29 05 3 16m30s 5m30s [ User: intelifix - Total duration: 16m30s - Times executed: 3 ]
[ Application: psql - Total duration: 16m30s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-06-29 05:09:23 Duration: 9m22s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
analyze verbose;
Date: 2026-06-29 05:13:52 Duration: 4m28s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
analyze verbose;
Date: 2026-06-29 05:16:31 Duration: 2m39s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
5 16m23s 723 150ms 10s94ms 1s359ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 29 06 2 5s730ms 2s865ms 07 85 2m32s 1s795ms 08 123 3m17s 1s603ms 09 196 4m25s 1s354ms 10 145 3m1s 1s254ms 11 94 1m57s 1s253ms 12 26 25s14ms 962ms 16 22 16s155ms 734ms 17 30 21s178ms 705ms [ User: intelifix - Total duration: 16m23s - Times executed: 723 ]
[ Application: [unknown] - Total duration: 16m23s - Times executed: 723 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (259581, 503, '733122090351,B4F26767F65C,6802B8FECA31,6802B8FEAF19,B4F26767D3BB,B4F26768000A,B4F267631E5A,B4F267682A0D,B4F26768263E,B4F267681570,B4F26759FE14,B4F26734FD83,B4F267682A16,B4F2676C718B,B4F267621849,B4F267683F85,B4F26755803C,B4F2676812B2,B4F2676C716A,B4F2674B81A7,B4F2676836A0,B4F26767F320,B4F267362E15,B4F26735DB29,B4F2674AE8BC,B4F2676C5A2A,B4F26754F9B4,B4F26768BE78,B4F2676BFF9D,6802B8FEB801,B4F2675972D0,B4F2676C71B8,B4F267365F9E,B4F2676C6FB4,B4F267513074,B4F2670D2C05,B4F2676812D6', '',0300,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-29 07:37:47 Duration: 10s94ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (259254, 450, 'ZTE3ANNQ8M00030,843C991EC89F,843C991EC8A0,ZTEGD7BA478B$ZTE3ANNR5W23223,48D68230A414,48D68230A415,ZTEGDB005AB6$ZTE3ANNQ8122118,689E29BDE52F,689E29BDE530,ZTEGD7B790F6$ZTE3ANNR7B52700,3891484DBFCF,3891484DBFD0,ZTEGDB085F3C$ZTE3ANNQCA29200,14CA56D4F13B,14CA56D4F13C,ZTEGD971D77B$ZTE3ANNQ8M24555,843C9921076D,843C9921076E,ZTEGD7BAA758$ZTE3ANNR3Y40000,4896D9536A38,4896D9536A39,ZTEGD97ECCF5$ZTE3ANNRC524763,6C11BA646E39,6C11BA646E3A,ZTEGDC6E767A$ZTE3ANNR3Y02114,4896D94FF244,4896D94FF245,ZTEGD97E38F7$ZTE3ANNRAM49697,5872C98BC4FF,5872C98BC500,ZTEGDC60C220$ZTE3ANNRC522507,6C11BA643959,6C11BA64395A,ZTEGDC6E6DAA$ZTE3ANNR6R15741,48D68236F5B0,48D68236F5B1,ZTEGDB016850$ZTE3ANNRC522173,6C11BA643185,6C11BA643186,ZTEGDC6E6C5C$ZTE3ANNRCP47771,6C11BA6D8A71,6C11BA6D8A72,ZTEGDC6FFB2E$ZTE3ANNQ4A14219,3CF9F0AB4588,3CF9F0AB4589,ZTEGD641764A$ZTE3ANNRAM21694,5872C98934AD,5872C98934AE,ZTEGDC6054BD$ZTE3ANNR7B52535,3891484DBBF1,3891484DBBF2,ZTEGDB085E97$ZTE3ANNQ9342641,843C99367CA3,843C99367CA4,ZTEGD7BC6288$ZTE3ANNR9W57872,D89A0DADA883,D89A0DADA884,ZTEGDB16F3BB$ZTE3ANNR8C11883,3891484F9D89,3891484F9D8A,ZTEGDB08AEDB$ZTE3ANNR3J13920,F4E84F8794A0,F4E84F8794A1,ZTEGD97B982A$ZTE3ANNQ8129355,689E29BE8ECD,689E29BE8ECE,ZTEGD7B7AD3B$ZTE3ANNRCP48101,6C11BA6D922D,6C11BA6D922E,ZTEGDC6FFC78$ZTE3ANNQ9J25659,843C992E2A97,843C992E2A98,ZTEGD7BB6CE6$ZTE3ANNR5W23185,48D68230A330,48D68230A331,ZTEGDB005A90$ZTE3ANNRB723389,5872C9905D5F,5872C9905D60,ZTEGDC618630$ZTE3ANNQ8M24711,843C99210B15,843C99210B16,ZTEGD7BAA7F4', '',0318,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-29 11:48:06 Duration: 8s743ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (259582, 504, '834054908000165,230050413943,230027589011,230009877798,230010935668,230014007797,229968216381,229982708503,230053313452,230042119092,229971357787,230035442628,229979449812,230007964761,230035672426,230027631619,229977483941,230014033131,229977517378,230044557086,230032968390,230011640923,230029385471,229962721637,230027722133,230027683947,229990929204,229975496575,230034526466,230052199213,229985243150,230042057695,230035461216,229972825473,230015138199,230028389908,229977038487,230053330828,229977499699', '',0295,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-29 07:54:00 Duration: 8s58ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
6 15m6s 120 794ms 1m33s 7s550ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 29 06 3 2m1s 40s613ms 07 49 3m3s 3s737ms 08 4 21s377ms 5s344ms 09 13 2m57s 13s667ms 10 19 3m24s 10s786ms 11 30 3m10s 6s365ms 17 2 6s121ms 3s60ms [ User: intelifix - Total duration: 15m6s - Times executed: 120 ]
[ Application: [unknown] - Total duration: 15m6s - Times executed: 120 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-29', 0395, '', '', 0, 6, '2026-06-01');
Date: 2026-06-29 09:26:22 Duration: 1m33s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-29', 0173, '', '', 0, 6, '2026-06-01');
Date: 2026-06-29 06:28:27 Duration: 1m32s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-29', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-29 09:50:10 Duration: 44s882ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
7 8m20s 179 150ms 21s96ms 2s797ms call rs_giga_triagem (?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 29 00 8 41s443ms 5s180ms 01 7 22s635ms 3s233ms 02 8 20s983ms 2s622ms 03 11 22s378ms 2s34ms 04 7 20s321ms 2s903ms 05 8 21s488ms 2s686ms 06 8 21s264ms 2s658ms 07 6 22s713ms 3s785ms 08 7 22s160ms 3s165ms 09 8 30s74ms 3s759ms 10 10 42s67ms 4s206ms 11 9 24s102ms 2s678ms 12 8 16s928ms 2s116ms 13 9 16s363ms 1s818ms 14 8 15s861ms 1s982ms 15 7 16s58ms 2s294ms 16 6 17s107ms 2s851ms 17 8 17s105ms 2s138ms 18 7 16s155ms 2s307ms 19 7 17s507ms 2s501ms 20 7 25s471ms 3s638ms 21 7 14s594ms 2s84ms 22 8 16s34ms 2s4ms [ User: intelifix - Total duration: 8m20s - Times executed: 179 ]
[ Application: psql - Total duration: 8m20s - Times executed: 179 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-29 00:05:23 Duration: 21s96ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-29 10:25:23 Duration: 11s807ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-29 20:15:12 Duration: 10s615ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
8 8m16s 654 151ms 18s923ms 758ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 29 06 8 7s628ms 953ms 07 116 1m47s 926ms 08 180 2m33s 853ms 09 132 1m21s 621ms 10 123 1m27s 709ms 11 95 58s337ms 614ms [ User: intelifix - Total duration: 8m16s - Times executed: 654 ]
[ Application: [unknown] - Total duration: 8m16s - Times executed: 654 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "243112", "modelo" : "287", "itens" : "229985062324,229992671619,229949711018,229994635974,229956743758,229920949804,229957125568,229996898596,229926894245,229992473036,229992474147,229992633759,229992622041,229992695560,229992573450,229994548187,229961374950,229906847294,229961567494,229961571233", "usuario" : "417", "caixa" : "2912632", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-29 08:39:02 Duration: 18s923ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "259766", "modelo" : "263", "itens" : "229895305674,229901859703,229870835160,229870721031,229916125461,229871620120,229897893334,229908637390,229871741826,229916158494,229898853338,229918618790,229897596885,229916351825,229870653953,229895900514,229900419292,229914788394,229916218399,229876642641,229896788994,229916215975,229894140219,229896635568,229918290825,229919009413,229901027590,229916457390,229871674849,229899383244,229902189208,229912287993,229898659301,229913641325,229908099099,229911249597,229905539602,229913173243,229874060919,229896417791,229896807481,229901191019,229910464056,229902252020,229919224159,229913648395,229896631023,229896630619", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-29 07:04:11 Duration: 5s397ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "104485", "modelo" : "263", "itens" : "229914957075,229898096081,229911969500,229915051530,229916321014,229893138189,229871292736,229896280607,229918516581,229916054545,229901030723,229897102135,229871635979,229910244158,229920610928", "usuario" : "414", "caixa" : "1218793", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-29 07:28:24 Duration: 4s261ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
9 6m14s 29 9s396ms 47s713ms 12s911ms create table temp0000283886 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 29 07 7 1m50s 15s743ms 08 7 1m32s 13s220ms 09 6 1m8s 11s496ms 10 3 33s523ms 11s174ms 11 6 1m9s 11s531ms [ User: intelifix - Total duration: 6m14s - Times executed: 29 ]
[ Application: [unknown] - Total duration: 6m14s - Times executed: 29 ]
-
CREATE TABLE temp0000283886 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-29 07:22:37 Duration: 47s713ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CREATE TABLE temp0000283886 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-29 08:00:28 Duration: 18s697ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CREATE TABLE temp0000283886 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-29 07:59:43 Duration: 13s478ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
10 5m39s 71 153ms 15s487ms 4s782ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 29 00 1 756ms 756ms 05 1 153ms 153ms 06 1 2s282ms 2s282ms 07 10 57s400ms 5s740ms 08 12 1m18s 6s579ms 09 12 1m13s 6s129ms 10 11 55s171ms 5s15ms 11 12 53s392ms 4s449ms 21 5 8s476ms 1s695ms 22 6 9s414ms 1s569ms [ User: intelifix - Total duration: 5m39s - Times executed: 71 ]
[ Application: psql - Total duration: 5m39s - Times executed: 71 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-29 11:25:17 Duration: 15s487ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-29 09:25:16 Duration: 14s634ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-29 08:15:15 Duration: 13s677ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
11 5m26s 29 9s624ms 14s275ms 11s246ms create table temp0000283914 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 29 08 4 49s520ms 12s380ms 09 14 2m35s 11s99ms 10 9 1m39s 11s54ms 11 2 21s746ms 10s873ms [ User: intelifix - Total duration: 5m26s - Times executed: 29 ]
[ Application: [unknown] - Total duration: 5m26s - Times executed: 29 ]
-
CREATE TABLE temp0000283914 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-29 08:27:03 Duration: 14s275ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CREATE TABLE temp0000283914 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-29 09:43:14 Duration: 13s410ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CREATE TABLE temp0000283914 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-29 10:24:15 Duration: 12s922ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
12 4m54s 26 9s284ms 13s934ms 11s338ms create table temp0000283882 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 29 09 26 4m54s 11s338ms [ User: intelifix - Total duration: 4m54s - Times executed: 26 ]
[ Application: [unknown] - Total duration: 4m54s - Times executed: 26 ]
-
CREATE TABLE temp0000283882 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-29 09:30:38 Duration: 13s934ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CREATE TABLE temp0000283882 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-29 09:23:33 Duration: 13s724ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CREATE TABLE temp0000283882 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-29 09:11:02 Duration: 13s701ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
13 3m23s 35 165ms 1m14s 5s816ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 29 07 3 3s852ms 1s284ms 08 3 1m16s 25s513ms 09 18 1m7s 3s759ms 10 7 20s400ms 2s914ms 11 4 35s121ms 8s780ms [ User: intelifix - Total duration: 3m23s - Times executed: 35 ]
[ Application: psql - Total duration: 3m23s - Times executed: 35 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026308);
Date: 2026-06-29 08:26:59 Duration: 1m14s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026327);
Date: 2026-06-29 09:43:28 Duration: 57s182ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT RS_SETGLOBAL ('USUARIO', 309); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026336);
Date: 2026-06-29 11:12:44 Duration: 23s872ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
14 3m6s 4 4s866ms 1m33s 46s703ms 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 Jun 29 20 2 1m38s 49s438ms 23 2 1m27s 43s969ms [ User: intelifix - Total duration: 3m6s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m6s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-29 20:09:02 Duration: 1m33s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-29 23:36:58 Duration: 1m23s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-29 20:10:57 Duration: 5s788ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
15 2m56s 28 167ms 21s599ms 6s287ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 29 07 2 25s141ms 12s570ms 08 3 20s8ms 6s669ms 09 12 51s513ms 4s292ms 10 5 55s837ms 11s167ms 11 2 20s940ms 10s470ms 12 1 167ms 167ms 16 3 2s448ms 816ms [ User: intelifix - Total duration: 2m56s - Times executed: 28 ]
[ Application: psql - Total duration: 2m56s - Times executed: 28 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (026306);
Date: 2026-06-29 07:24:29 Duration: 21s599ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT RS_SETGLOBAL ('USUARIO', 502); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (026333);
Date: 2026-06-29 10:45:48 Duration: 20s499ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (026338);
Date: 2026-06-29 11:25:10 Duration: 20s284ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
16 2m12s 48 159ms 22s726ms 2s764ms create table temp0000283908 as select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 29 07 8 18s925ms 2s365ms 08 38 1m51s 2s936ms 09 2 2s182ms 1s91ms [ User: intelifix - Total duration: 2m12s - Times executed: 48 ]
[ Application: [unknown] - Total duration: 2m12s - Times executed: 48 ]
-
CREATE TABLE temp0000283908 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "229989", "oficina" : "6", "cliente" : "5", "nf" : "", "data-de" : "24-06-2026", "data-ate" : "29-06-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-06-29 08:03:32 Duration: 22s726ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CREATE TABLE temp0000283908 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "103107", "oficina" : "6", "cliente" : "5", "nf" : "", "data-de" : "24-06-2026", "data-ate" : "29-06-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-06-29 08:31:48 Duration: 19s227ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CREATE TABLE temp0000283908 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "243112", "oficina" : "6", "cliente" : "5", "nf" : "", "data-de" : "24-06-2026", "data-ate" : "29-06-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-06-29 08:36:32 Duration: 12s583ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
17 2m1s 25 3s858ms 6s605ms 4s863ms create table temp0000283882 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 29 09 25 2m1s 4s863ms [ User: intelifix - Total duration: 2m1s - Times executed: 25 ]
[ Application: [unknown] - Total duration: 2m1s - Times executed: 25 ]
-
CREATE TABLE temp0000283882 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"24-06-2026", "ate" :"29-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-29 09:11:12 Duration: 6s605ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CREATE TABLE temp0000283882 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"24-06-2026", "ate" :"29-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-29 09:39:21 Duration: 6s121ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CREATE TABLE temp0000283882 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"24-06-2026", "ate" :"29-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-29 09:36:01 Duration: 5s601ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
18 1m57s 3 4s408ms 1m34s 39s146ms copy auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 29 23 3 1m57s 39s146ms [ User: intelifix - Total duration: 1m57s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 1m57s - Times executed: 3 ]
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-29 23:15:49 Duration: 1m34s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.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-06-29 23:48:02 Duration: 18s341ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.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-06-29 23:37:30 Duration: 4s408ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
19 1m55s 4 332ms 1m4s 28s880ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 29 20 2 1m4s 32s439ms 23 2 50s642ms 25s321ms [ User: intelifix - Total duration: 1m55s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m55s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-29 20:05:38 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-29 23:19:02 Duration: 50s309ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-29 20:10:20 Duration: 362ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
20 1m53s 2 18s129ms 1m34s 56s540ms copy auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 29 23 2 1m53s 56s540ms [ User: intelifix - Total duration: 1m53s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m53s - Times executed: 2 ]
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-29 23:14:15 Duration: 1m34s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-29 23:47:44 Duration: 18s129ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 723 16m23s 150ms 10s94ms 1s359ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 29 06 2 5s730ms 2s865ms 07 85 2m32s 1s795ms 08 123 3m17s 1s603ms 09 196 4m25s 1s354ms 10 145 3m1s 1s254ms 11 94 1m57s 1s253ms 12 26 25s14ms 962ms 16 22 16s155ms 734ms 17 30 21s178ms 705ms [ User: intelifix - Total duration: 16m23s - Times executed: 723 ]
[ Application: [unknown] - Total duration: 16m23s - Times executed: 723 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (259581, 503, '733122090351,B4F26767F65C,6802B8FECA31,6802B8FEAF19,B4F26767D3BB,B4F26768000A,B4F267631E5A,B4F267682A0D,B4F26768263E,B4F267681570,B4F26759FE14,B4F26734FD83,B4F267682A16,B4F2676C718B,B4F267621849,B4F267683F85,B4F26755803C,B4F2676812B2,B4F2676C716A,B4F2674B81A7,B4F2676836A0,B4F26767F320,B4F267362E15,B4F26735DB29,B4F2674AE8BC,B4F2676C5A2A,B4F26754F9B4,B4F26768BE78,B4F2676BFF9D,6802B8FEB801,B4F2675972D0,B4F2676C71B8,B4F267365F9E,B4F2676C6FB4,B4F267513074,B4F2670D2C05,B4F2676812D6', '',0300,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-29 07:37:47 Duration: 10s94ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (259254, 450, 'ZTE3ANNQ8M00030,843C991EC89F,843C991EC8A0,ZTEGD7BA478B$ZTE3ANNR5W23223,48D68230A414,48D68230A415,ZTEGDB005AB6$ZTE3ANNQ8122118,689E29BDE52F,689E29BDE530,ZTEGD7B790F6$ZTE3ANNR7B52700,3891484DBFCF,3891484DBFD0,ZTEGDB085F3C$ZTE3ANNQCA29200,14CA56D4F13B,14CA56D4F13C,ZTEGD971D77B$ZTE3ANNQ8M24555,843C9921076D,843C9921076E,ZTEGD7BAA758$ZTE3ANNR3Y40000,4896D9536A38,4896D9536A39,ZTEGD97ECCF5$ZTE3ANNRC524763,6C11BA646E39,6C11BA646E3A,ZTEGDC6E767A$ZTE3ANNR3Y02114,4896D94FF244,4896D94FF245,ZTEGD97E38F7$ZTE3ANNRAM49697,5872C98BC4FF,5872C98BC500,ZTEGDC60C220$ZTE3ANNRC522507,6C11BA643959,6C11BA64395A,ZTEGDC6E6DAA$ZTE3ANNR6R15741,48D68236F5B0,48D68236F5B1,ZTEGDB016850$ZTE3ANNRC522173,6C11BA643185,6C11BA643186,ZTEGDC6E6C5C$ZTE3ANNRCP47771,6C11BA6D8A71,6C11BA6D8A72,ZTEGDC6FFB2E$ZTE3ANNQ4A14219,3CF9F0AB4588,3CF9F0AB4589,ZTEGD641764A$ZTE3ANNRAM21694,5872C98934AD,5872C98934AE,ZTEGDC6054BD$ZTE3ANNR7B52535,3891484DBBF1,3891484DBBF2,ZTEGDB085E97$ZTE3ANNQ9342641,843C99367CA3,843C99367CA4,ZTEGD7BC6288$ZTE3ANNR9W57872,D89A0DADA883,D89A0DADA884,ZTEGDB16F3BB$ZTE3ANNR8C11883,3891484F9D89,3891484F9D8A,ZTEGDB08AEDB$ZTE3ANNR3J13920,F4E84F8794A0,F4E84F8794A1,ZTEGD97B982A$ZTE3ANNQ8129355,689E29BE8ECD,689E29BE8ECE,ZTEGD7B7AD3B$ZTE3ANNRCP48101,6C11BA6D922D,6C11BA6D922E,ZTEGDC6FFC78$ZTE3ANNQ9J25659,843C992E2A97,843C992E2A98,ZTEGD7BB6CE6$ZTE3ANNR5W23185,48D68230A330,48D68230A331,ZTEGDB005A90$ZTE3ANNRB723389,5872C9905D5F,5872C9905D60,ZTEGDC618630$ZTE3ANNQ8M24711,843C99210B15,843C99210B16,ZTEGD7BAA7F4', '',0318,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-29 11:48:06 Duration: 8s743ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (259582, 504, '834054908000165,230050413943,230027589011,230009877798,230010935668,230014007797,229968216381,229982708503,230053313452,230042119092,229971357787,230035442628,229979449812,230007964761,230035672426,230027631619,229977483941,230014033131,229977517378,230044557086,230032968390,230011640923,230029385471,229962721637,230027722133,230027683947,229990929204,229975496575,230034526466,230052199213,229985243150,230042057695,230035461216,229972825473,230015138199,230028389908,229977038487,230053330828,229977499699', '',0295,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-29 07:54:00 Duration: 8s58ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
2 654 8m16s 151ms 18s923ms 758ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 29 06 8 7s628ms 953ms 07 116 1m47s 926ms 08 180 2m33s 853ms 09 132 1m21s 621ms 10 123 1m27s 709ms 11 95 58s337ms 614ms [ User: intelifix - Total duration: 8m16s - Times executed: 654 ]
[ Application: [unknown] - Total duration: 8m16s - Times executed: 654 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "243112", "modelo" : "287", "itens" : "229985062324,229992671619,229949711018,229994635974,229956743758,229920949804,229957125568,229996898596,229926894245,229992473036,229992474147,229992633759,229992622041,229992695560,229992573450,229994548187,229961374950,229906847294,229961567494,229961571233", "usuario" : "417", "caixa" : "2912632", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-29 08:39:02 Duration: 18s923ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "259766", "modelo" : "263", "itens" : "229895305674,229901859703,229870835160,229870721031,229916125461,229871620120,229897893334,229908637390,229871741826,229916158494,229898853338,229918618790,229897596885,229916351825,229870653953,229895900514,229900419292,229914788394,229916218399,229876642641,229896788994,229916215975,229894140219,229896635568,229918290825,229919009413,229901027590,229916457390,229871674849,229899383244,229902189208,229912287993,229898659301,229913641325,229908099099,229911249597,229905539602,229913173243,229874060919,229896417791,229896807481,229901191019,229910464056,229902252020,229919224159,229913648395,229896631023,229896630619", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-29 07:04:11 Duration: 5s397ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "104485", "modelo" : "263", "itens" : "229914957075,229898096081,229911969500,229915051530,229916321014,229893138189,229871292736,229896280607,229918516581,229916054545,229901030723,229897102135,229871635979,229910244158,229920610928", "usuario" : "414", "caixa" : "1218793", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-29 07:28:24 Duration: 4s261ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
3 185 30s649ms 150ms 345ms 165ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 29 06 1 165ms 165ms 07 56 9s154ms 163ms 08 57 9s458ms 165ms 09 25 4s229ms 169ms 10 28 4s699ms 167ms 11 18 2s941ms 163ms [ User: intelifix - Total duration: 30s649ms - Times executed: 185 ]
[ Application: [unknown] - Total duration: 30s649ms - Times executed: 185 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-06-29 10:26:22 Duration: 345ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0318;
Date: 2026-06-29 07:42:11 Duration: 209ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0303;
Date: 2026-06-29 08:56:32 Duration: 206ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
4 180 1h5m52s 156ms 7m38s 21s956ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 29 07 32 8m40s 16s263ms 08 26 12m45s 29s445ms 09 55 15m5s 16s460ms 10 31 11m30s 22s258ms 11 21 17m23s 49s709ms 12 6 5s995ms 999ms 16 4 16s802ms 4s200ms 17 5 4s128ms 825ms [ User: intelifix - Total duration: 1h5m52s - Times executed: 180 ]
[ Application: [unknown] - Total duration: 1h5m52s - Times executed: 180 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026306, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-29 07:32:09 Duration: 7m38s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026331, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-29 10:33:59 Duration: 7m9s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026338, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-29 11:32:18 Duration: 6m58s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
5 179 8m20s 150ms 21s96ms 2s797ms call rs_giga_triagem (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 29 00 8 41s443ms 5s180ms 01 7 22s635ms 3s233ms 02 8 20s983ms 2s622ms 03 11 22s378ms 2s34ms 04 7 20s321ms 2s903ms 05 8 21s488ms 2s686ms 06 8 21s264ms 2s658ms 07 6 22s713ms 3s785ms 08 7 22s160ms 3s165ms 09 8 30s74ms 3s759ms 10 10 42s67ms 4s206ms 11 9 24s102ms 2s678ms 12 8 16s928ms 2s116ms 13 9 16s363ms 1s818ms 14 8 15s861ms 1s982ms 15 7 16s58ms 2s294ms 16 6 17s107ms 2s851ms 17 8 17s105ms 2s138ms 18 7 16s155ms 2s307ms 19 7 17s507ms 2s501ms 20 7 25s471ms 3s638ms 21 7 14s594ms 2s84ms 22 8 16s34ms 2s4ms [ User: intelifix - Total duration: 8m20s - Times executed: 179 ]
[ Application: psql - Total duration: 8m20s - Times executed: 179 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-29 00:05:23 Duration: 21s96ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-29 10:25:23 Duration: 11s807ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-29 20:15:12 Duration: 10s615ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
6 177 1m18s 161ms 926ms 446ms select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 29 07 52 27s685ms 532ms 08 104 39s705ms 381ms 10 21 11s562ms 550ms [ User: intelifix - Total duration: 1m18s - Times executed: 177 ]
[ Application: [unknown] - Total duration: 1m18s - Times executed: 177 ]
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (0103107);
Date: 2026-06-29 10:36:20 Duration: 926ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (0103107);
Date: 2026-06-29 08:51:31 Duration: 894ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (0103107);
Date: 2026-06-29 08:51:42 Duration: 836ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
7 164 47s486ms 150ms 644ms 289ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 29 07 32 8s472ms 264ms 08 34 11s208ms 329ms 09 43 12s562ms 292ms 10 24 6s773ms 282ms 11 31 8s470ms 273ms [ User: intelifix - Total duration: 47s486ms - Times executed: 164 ]
[ Application: [unknown] - Total duration: 47s486ms - Times executed: 164 ]
-
SELECT * FROM RS_TRIAGEM (404, 5, '113', 3, '216658253544,216745053755,216492807475,216437238191,216474395353,216654905271,216788526987,216723427188,216723176176,216677731618,216482089404', NULL, NULL, 034, 00);
Date: 2026-06-29 09:18:44 Duration: 644ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_TRIAGEM (402, 5, '113', 3, '216583336883,216435791115,216597526977,216649493946,216436077180,216571013032,216745526180,216763650419,216598741833', NULL, NULL, 034, 00);
Date: 2026-06-29 07:14:16 Duration: 640ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_TRIAGEM (410, 5, '113', 3, '230017201331,229937219696,229994489999,229993028499,229931512732,229985093034,229931895979,230009398807', NULL, NULL, 0287, 00);
Date: 2026-06-29 08:52:00 Duration: 624ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
8 127 29s167ms 158ms 555ms 229ms select * from rs_lote_manutencao (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 29 08 7 2s84ms 297ms 09 31 8s353ms 269ms 10 31 7s131ms 230ms 11 10 2s457ms 245ms 12 13 2s443ms 187ms 16 17 3s238ms 190ms 17 18 3s458ms 192ms [ User: intelifix - Total duration: 29s167ms - Times executed: 127 ]
[ Application: [unknown] - Total duration: 29s167ms - Times executed: 127 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"34", "usuario" :"507", "tipo" :"N", "itens" :"001", "nota-fiscal" :"1563", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-06-29 08:06:51 Duration: 555ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"7", "cliente" :"11", "modelo" :"156", "usuario" :"428", "tipo" :"N", "itens" :"01", "nota-fiscal" :"2022", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-06-29 08:43:03 Duration: 478ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"2", "cliente" :"1", "modelo" :"64", "usuario" :"407", "tipo" :"N", "itens" :"002", "nota-fiscal" :"10625", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-06-29 09:26:31 Duration: 451ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
9 120 15m6s 794ms 1m33s 7s550ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 29 06 3 2m1s 40s613ms 07 49 3m3s 3s737ms 08 4 21s377ms 5s344ms 09 13 2m57s 13s667ms 10 19 3m24s 10s786ms 11 30 3m10s 6s365ms 17 2 6s121ms 3s60ms [ User: intelifix - Total duration: 15m6s - Times executed: 120 ]
[ Application: [unknown] - Total duration: 15m6s - Times executed: 120 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-29', 0395, '', '', 0, 6, '2026-06-01');
Date: 2026-06-29 09:26:22 Duration: 1m33s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-29', 0173, '', '', 0, 6, '2026-06-01');
Date: 2026-06-29 06:28:27 Duration: 1m32s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-29', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-29 09:50:10 Duration: 44s882ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
10 85 1m9s 160ms 3s368ms 812ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 29 07 25 17s658ms 706ms 08 15 10s677ms 711ms 09 25 23s563ms 942ms 10 12 10s272ms 856ms 11 8 6s872ms 859ms [ User: intelifix - Total duration: 1m9s - Times executed: 85 ]
[ Application: [unknown] - Total duration: 1m9s - Times executed: 85 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0259641) LIMIT 1;
Date: 2026-06-29 07:16:56 Duration: 3s368ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0259691) LIMIT 1;
Date: 2026-06-29 09:01:29 Duration: 3s145ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0259636) LIMIT 1;
Date: 2026-06-29 08:35:10 Duration: 2s694ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
11 84 49s691ms 157ms 2s657ms 591ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 29 10 84 49s691ms 591ms [ User: intelifix - Total duration: 49s691ms - Times executed: 84 ]
[ Application: [unknown] - Total duration: 49s691ms - Times executed: 84 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"44094","seriais":"3891484A7697,48D6823547D2,14CA56CCDDFF,D89A0DA47D51,14CA56CE509D,6C11BA66F95D,48D682357B5C,D89A0DB09F29,4896D953F066,F4E84F814028,843C9922A0C3,F4E84F870200,C4EBFF8B86F6,5872C9902519,843C9922E035,4896D956821A,3891484A7AB7,D831399050E4,843C9922DED3,3CF9F070298D,D83139201486,D8313993521C,48D682381E7A,6C11BA6F51F3,D89A0DA914A9,6C11BA6C6F87,D89A0DA4630B,5872C98F7D73,6C11BA6DB0FF,D89A0D866E29,3CF9F0A7124A,843C992DC18B,48D682357DC0,D89A0DB0019D,6C11BA6721FB,4896D9530156,F4E84F876E48,4896D9565280,14CA56D296E9","usuario":"416","observacao":""}');
Date: 2026-06-29 10:03:22 Duration: 2s657ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"44094","seriais":"241654359799,241729493048,241668194046,241659697279,241676700612,241636056173,241599299309,241704737780,241594984668,241711208086,241700944762,241713698486,241676733948,241676719704,241728679297,241728548601,241704267981,241714952639,241622591919,241676825270,241614463146,241704235476,241673331933,241728671823,241729499412,241712508708,241729513353,241604746978,241731013645,241618222323,241663840513,241728677681,241660140612,241692606473,241604665051,241666919309,241728704856,241727050711,241614465368,241712528585,241646337984,241619592648,241664780313,241695610920,241695638194,241592970207,241654357274,241654488601,241727046871,241680324141,241671516985,241654448394,241654470721,241622639296,241649699211","usuario":"416","observacao":""}');
Date: 2026-06-29 10:46:38 Duration: 2s276ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"44094","seriais":"942CB3AA9303,8C444FAEDB6F,942CB3A61711,E820E26719D0,8C444F4B1AFA,E820E25F5B33,E820E207E82F,8C444FCFB5B0,942CB3727090,E820E2731E9E,E820E23E21BB,E820E2687855,8C444FC7E4DD,E820E277A4E6,E820E20F01C0,8C444FD30734,E820E253FA1B","usuario":"416","observacao":""}');
Date: 2026-06-29 10:24:04 Duration: 2s82ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
12 71 5m39s 153ms 15s487ms 4s782ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 29 00 1 756ms 756ms 05 1 153ms 153ms 06 1 2s282ms 2s282ms 07 10 57s400ms 5s740ms 08 12 1m18s 6s579ms 09 12 1m13s 6s129ms 10 11 55s171ms 5s15ms 11 12 53s392ms 4s449ms 21 5 8s476ms 1s695ms 22 6 9s414ms 1s569ms [ User: intelifix - Total duration: 5m39s - Times executed: 71 ]
[ Application: psql - Total duration: 5m39s - Times executed: 71 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-29 11:25:17 Duration: 15s487ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-29 09:25:16 Duration: 14s634ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-29 08:15:15 Duration: 13s677ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
13 71 15s100ms 150ms 1s 212ms select * from rs_equipamento_consulta (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 29 06 4 1s268ms 317ms 07 6 1s65ms 177ms 08 11 2s100ms 190ms 09 14 2s675ms 191ms 10 14 2s459ms 175ms 11 14 2s506ms 179ms 12 2 734ms 367ms 21 1 290ms 290ms 23 5 2s 400ms [ User: intelifix - Total duration: 15s100ms - Times executed: 71 ]
[ Application: [unknown] - Total duration: 15s100ms - Times executed: 71 ]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('230016613237');
Date: 2026-06-29 23:21:24 Duration: 1s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('70037E9CEAB6');
Date: 2026-06-29 06:54:10 Duration: 612ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('BC644BE10701');
Date: 2026-06-29 12:12:04 Duration: 377ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
14 68 30s109ms 299ms 713ms 442ms 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 #14
Day Hour Count Duration Avg duration Jun 29 06 4 1s851ms 462ms 07 11 4s747ms 431ms 08 10 4s760ms 476ms 09 11 4s769ms 433ms 10 10 4s295ms 429ms 11 8 3s735ms 466ms 12 2 844ms 422ms 16 7 3s14ms 430ms 17 2 771ms 385ms 21 2 875ms 437ms 23 1 443ms 443ms [ User: lenon - Total duration: 30s109ms - Times executed: 68 ]
[ Application: [unknown] - Total duration: 30s109ms - Times executed: 68 ]
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-06-29 11:26:32 Duration: 713ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-29.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-06-29 08:51:41 Duration: 680ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-29.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-06-29 08:26:50 Duration: 656ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-29.log
15 63 25s297ms 215ms 888ms 401ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 29 07 3 1s600ms 533ms 08 6 2s539ms 423ms 09 28 10s847ms 387ms 10 11 4s938ms 448ms 11 11 4s56ms 368ms 12 1 301ms 301ms 16 2 715ms 357ms 17 1 299ms 299ms [ User: intelifix - Total duration: 25s297ms - Times executed: 63 ]
[ Application: [unknown] - Total duration: 25s297ms - Times executed: 63 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 054;
Date: 2026-06-29 07:18:14 Duration: 888ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-06-29 10:36:32 Duration: 563ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-06-29 09:13:27 Duration: 556ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
16 59 34s27ms 397ms 825ms 576ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 29 06 2 1s40ms 520ms 07 9 4s971ms 552ms 08 8 4s911ms 613ms 09 10 5s610ms 561ms 10 10 5s725ms 572ms 11 8 4s923ms 615ms 12 2 1s241ms 620ms 16 6 3s187ms 531ms 17 2 1s15ms 507ms 21 1 577ms 577ms 23 1 823ms 823ms [ User: intelifix - Total duration: 34s27ms - Times executed: 59 ]
[ Application: [unknown] - Total duration: 34s27ms - Times executed: 59 ]
-
select * from rs_menu_grants (418, 21, 1);
Date: 2026-06-29 08:51:41 Duration: 825ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
select * from rs_menu_grants (499, 0, 1);
Date: 2026-06-29 23:47:45 Duration: 823ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
select * from rs_menu_grants (450, 18, 1);
Date: 2026-06-29 09:53:46 Duration: 815ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
17 48 2h23m4s 1s314ms 15m18s 2m58s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 29 07 3 16m7s 5m22s 08 3 9m14s 3m4s 09 3 14m7s 4m42s 10 3 12m44s 4m14s 11 3 12m31s 4m10s 12 3 11m25s 3m48s 13 3 6m18s 2m6s 14 3 5m48s 1m56s 15 3 6m17s 2m5s 16 3 5m49s 1m56s 17 3 6m4s 2m1s 18 3 6m 2m 19 3 5m51s 1m57s 20 3 12m5s 4m1s 21 3 6m2s 2m 22 3 6m34s 2m11s [ User: intelifix - Total duration: 2h23m4s - Times executed: 48 ]
[ Application: psql - Total duration: 2h23m4s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-29 07:20:20 Duration: 15m18s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-29 09:18:33 Duration: 13m31s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-29 10:17:08 Duration: 12m6s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
18 48 1h13m46s 244ms 4m45s 1m32s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 29 07 3 5m44s 1m54s 08 3 5m22s 1m47s 09 3 6m4s 2m1s 10 3 6m24s 2m8s 11 3 5m55s 1m58s 12 3 5m 1m40s 13 3 3m49s 1m16s 14 3 3m38s 1m12s 15 3 3m55s 1m18s 16 3 3m39s 1m13s 17 3 3m56s 1m18s 18 3 3m52s 1m17s 19 3 3m41s 1m13s 20 3 5m25s 1m48s 21 3 3m29s 1m9s 22 3 3m44s 1m14s [ User: intelifix - Total duration: 1h13m46s - Times executed: 48 ]
[ Application: psql - Total duration: 1h13m46s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-29 10:24:01 Duration: 4m45s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-29 09:25:04 Duration: 4m21s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-29 11:23:17 Duration: 4m20s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
19 48 2m12s 159ms 22s726ms 2s764ms create table temp0000283908 as select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 29 07 8 18s925ms 2s365ms 08 38 1m51s 2s936ms 09 2 2s182ms 1s91ms [ User: intelifix - Total duration: 2m12s - Times executed: 48 ]
[ Application: [unknown] - Total duration: 2m12s - Times executed: 48 ]
-
CREATE TABLE temp0000283908 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "229989", "oficina" : "6", "cliente" : "5", "nf" : "", "data-de" : "24-06-2026", "data-ate" : "29-06-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-06-29 08:03:32 Duration: 22s726ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CREATE TABLE temp0000283908 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "103107", "oficina" : "6", "cliente" : "5", "nf" : "", "data-de" : "24-06-2026", "data-ate" : "29-06-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-06-29 08:31:48 Duration: 19s227ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CREATE TABLE temp0000283908 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "243112", "oficina" : "6", "cliente" : "5", "nf" : "", "data-de" : "24-06-2026", "data-ate" : "29-06-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-06-29 08:36:32 Duration: 12s583ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
20 42 21s343ms 153ms 1s616ms 508ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 29 07 1 153ms 153ms 08 16 3s971ms 248ms 09 8 2s872ms 359ms 10 9 7s231ms 803ms 11 8 7s112ms 889ms [ User: intelifix - Total duration: 21s343ms - Times executed: 42 ]
[ Application: [unknown] - Total duration: 21s343ms - Times executed: 42 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, 'D8313998734A,F4E84F82EDD0,3891484C2DE1,6C11BA631E51,14CA56D564FD,48D6823368AA,14CA56CD7BFD,D89A0DA89F07,389148539893,D89A0DA4CB39,4896D95071D6,14CA56CD9667,48D68233D6A2,5872C98D23ED,14CA56D4FDEF,4896D95721BC,D89A0DAD0A25,C4EBFF8C2B12,48D68231BB62,3891484F08C7', '138;1', 'DEFAULT', 09, 0323, '','', '', 00);
Date: 2026-06-29 11:19:15 Duration: 1s616ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '843C99203537,C4EBFF8AE682,D831399B3F96,843C992C141F,3CF9F0AD2A80,689E29BCD28B,C4EBFF8C1EB8,3CF9F0AD875C,C4EBFF90307E,D89A0D82A7CF,D83139A04006,4896D956029A,3CF9F0AA3FA4,F4E84F8693F0,D8313993068C,843C99333C05,3891484C2D45,3891484C2F37,C4EBFF902F22,C4EBFF89AAFE', '138;1', 'DEFAULT', 09, 0323, '','', '', 00);
Date: 2026-06-29 10:52:08 Duration: 1s591ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '843C992C7251,D89A0DACDAD9,843C992E3757,C4EBFF8A99F6,D89A0DAD256D,C4EBFF8BE384,843C99224417,3891484C30ED,3891484AC281,14CA56D561F7,843C992024C3,843C99332867,3CF9F0A43DE8,14CA56D6CA69,3891484ACB99,3CF9F0ACD21E,843C992C66E1,48D68233DB70,843C992F5193,D89A0DA47ADB', '138;1', 'DEFAULT', 09, 0323, '','', '', 00);
Date: 2026-06-29 10:40:38 Duration: 1s450ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m39s 9m22s 5m30s 3 16m30s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 29 05 3 16m30s 5m30s [ User: intelifix - Total duration: 16m30s - Times executed: 3 ]
[ Application: psql - Total duration: 16m30s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-06-29 05:09:23 Duration: 9m22s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
analyze verbose;
Date: 2026-06-29 05:13:52 Duration: 4m28s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
analyze verbose;
Date: 2026-06-29 05:16:31 Duration: 2m39s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
2 1s314ms 15m18s 2m58s 48 2h23m4s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 29 07 3 16m7s 5m22s 08 3 9m14s 3m4s 09 3 14m7s 4m42s 10 3 12m44s 4m14s 11 3 12m31s 4m10s 12 3 11m25s 3m48s 13 3 6m18s 2m6s 14 3 5m48s 1m56s 15 3 6m17s 2m5s 16 3 5m49s 1m56s 17 3 6m4s 2m1s 18 3 6m 2m 19 3 5m51s 1m57s 20 3 12m5s 4m1s 21 3 6m2s 2m 22 3 6m34s 2m11s [ User: intelifix - Total duration: 2h23m4s - Times executed: 48 ]
[ Application: psql - Total duration: 2h23m4s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-29 07:20:20 Duration: 15m18s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-29 09:18:33 Duration: 13m31s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-29 10:17:08 Duration: 12m6s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
3 244ms 4m45s 1m32s 48 1h13m46s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 29 07 3 5m44s 1m54s 08 3 5m22s 1m47s 09 3 6m4s 2m1s 10 3 6m24s 2m8s 11 3 5m55s 1m58s 12 3 5m 1m40s 13 3 3m49s 1m16s 14 3 3m38s 1m12s 15 3 3m55s 1m18s 16 3 3m39s 1m13s 17 3 3m56s 1m18s 18 3 3m52s 1m17s 19 3 3m41s 1m13s 20 3 5m25s 1m48s 21 3 3m29s 1m9s 22 3 3m44s 1m14s [ User: intelifix - Total duration: 1h13m46s - Times executed: 48 ]
[ Application: psql - Total duration: 1h13m46s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-29 10:24:01 Duration: 4m45s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-29 09:25:04 Duration: 4m21s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-29 11:23:17 Duration: 4m20s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
4 18s129ms 1m34s 56s540ms 2 1m53s copy auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 29 23 2 1m53s 56s540ms [ User: intelifix - Total duration: 1m53s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m53s - Times executed: 2 ]
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-29 23:14:15 Duration: 1m34s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-29 23:47:44 Duration: 18s129ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
5 4s866ms 1m33s 46s703ms 4 3m6s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 29 20 2 1m38s 49s438ms 23 2 1m27s 43s969ms [ User: intelifix - Total duration: 3m6s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m6s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-29 20:09:02 Duration: 1m33s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-29 23:36:58 Duration: 1m23s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-29 20:10:57 Duration: 5s788ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
6 4s408ms 1m34s 39s146ms 3 1m57s copy auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 29 23 3 1m57s 39s146ms [ User: intelifix - Total duration: 1m57s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 1m57s - Times executed: 3 ]
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-29 23:15:49 Duration: 1m34s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.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-06-29 23:48:02 Duration: 18s341ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.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-06-29 23:37:30 Duration: 4s408ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
7 332ms 1m4s 28s880ms 4 1m55s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 29 20 2 1m4s 32s439ms 23 2 50s642ms 25s321ms [ User: intelifix - Total duration: 1m55s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m55s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-29 20:05:38 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-29 23:19:02 Duration: 50s309ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-29 20:10:20 Duration: 362ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-29.log
8 156ms 7m38s 21s956ms 180 1h5m52s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 29 07 32 8m40s 16s263ms 08 26 12m45s 29s445ms 09 55 15m5s 16s460ms 10 31 11m30s 22s258ms 11 21 17m23s 49s709ms 12 6 5s995ms 999ms 16 4 16s802ms 4s200ms 17 5 4s128ms 825ms [ User: intelifix - Total duration: 1h5m52s - Times executed: 180 ]
[ Application: [unknown] - Total duration: 1h5m52s - Times executed: 180 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026306, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-29 07:32:09 Duration: 7m38s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026331, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-29 10:33:59 Duration: 7m9s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026338, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-29 11:32:18 Duration: 6m58s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
9 9s396ms 47s713ms 12s911ms 29 6m14s create table temp0000283886 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 29 07 7 1m50s 15s743ms 08 7 1m32s 13s220ms 09 6 1m8s 11s496ms 10 3 33s523ms 11s174ms 11 6 1m9s 11s531ms [ User: intelifix - Total duration: 6m14s - Times executed: 29 ]
[ Application: [unknown] - Total duration: 6m14s - Times executed: 29 ]
-
CREATE TABLE temp0000283886 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-29 07:22:37 Duration: 47s713ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CREATE TABLE temp0000283886 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-29 08:00:28 Duration: 18s697ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CREATE TABLE temp0000283886 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-29 07:59:43 Duration: 13s478ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
10 9s284ms 13s934ms 11s338ms 26 4m54s create table temp0000283882 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 29 09 26 4m54s 11s338ms [ User: intelifix - Total duration: 4m54s - Times executed: 26 ]
[ Application: [unknown] - Total duration: 4m54s - Times executed: 26 ]
-
CREATE TABLE temp0000283882 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-29 09:30:38 Duration: 13s934ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CREATE TABLE temp0000283882 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-29 09:23:33 Duration: 13s724ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CREATE TABLE temp0000283882 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-29 09:11:02 Duration: 13s701ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
11 9s624ms 14s275ms 11s246ms 29 5m26s create table temp0000283914 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 29 08 4 49s520ms 12s380ms 09 14 2m35s 11s99ms 10 9 1m39s 11s54ms 11 2 21s746ms 10s873ms [ User: intelifix - Total duration: 5m26s - Times executed: 29 ]
[ Application: [unknown] - Total duration: 5m26s - Times executed: 29 ]
-
CREATE TABLE temp0000283914 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-29 08:27:03 Duration: 14s275ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CREATE TABLE temp0000283914 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-29 09:43:14 Duration: 13s410ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CREATE TABLE temp0000283914 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-29 10:24:15 Duration: 12s922ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
12 794ms 1m33s 7s550ms 120 15m6s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 29 06 3 2m1s 40s613ms 07 49 3m3s 3s737ms 08 4 21s377ms 5s344ms 09 13 2m57s 13s667ms 10 19 3m24s 10s786ms 11 30 3m10s 6s365ms 17 2 6s121ms 3s60ms [ User: intelifix - Total duration: 15m6s - Times executed: 120 ]
[ Application: [unknown] - Total duration: 15m6s - Times executed: 120 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-29', 0395, '', '', 0, 6, '2026-06-01');
Date: 2026-06-29 09:26:22 Duration: 1m33s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-29', 0173, '', '', 0, 6, '2026-06-01');
Date: 2026-06-29 06:28:27 Duration: 1m32s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-29', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-06-29 09:50:10 Duration: 44s882ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
13 167ms 21s599ms 6s287ms 28 2m56s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 29 07 2 25s141ms 12s570ms 08 3 20s8ms 6s669ms 09 12 51s513ms 4s292ms 10 5 55s837ms 11s167ms 11 2 20s940ms 10s470ms 12 1 167ms 167ms 16 3 2s448ms 816ms [ User: intelifix - Total duration: 2m56s - Times executed: 28 ]
[ Application: psql - Total duration: 2m56s - Times executed: 28 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (026306);
Date: 2026-06-29 07:24:29 Duration: 21s599ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT RS_SETGLOBAL ('USUARIO', 502); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (026333);
Date: 2026-06-29 10:45:48 Duration: 20s499ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (026338);
Date: 2026-06-29 11:25:10 Duration: 20s284ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
14 165ms 1m14s 5s816ms 35 3m23s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 29 07 3 3s852ms 1s284ms 08 3 1m16s 25s513ms 09 18 1m7s 3s759ms 10 7 20s400ms 2s914ms 11 4 35s121ms 8s780ms [ User: intelifix - Total duration: 3m23s - Times executed: 35 ]
[ Application: psql - Total duration: 3m23s - Times executed: 35 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026308);
Date: 2026-06-29 08:26:59 Duration: 1m14s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026327);
Date: 2026-06-29 09:43:28 Duration: 57s182ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT RS_SETGLOBAL ('USUARIO', 309); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026336);
Date: 2026-06-29 11:12:44 Duration: 23s872ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
15 3s858ms 6s605ms 4s863ms 25 2m1s create table temp0000283882 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 29 09 25 2m1s 4s863ms [ User: intelifix - Total duration: 2m1s - Times executed: 25 ]
[ Application: [unknown] - Total duration: 2m1s - Times executed: 25 ]
-
CREATE TABLE temp0000283882 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"24-06-2026", "ate" :"29-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-29 09:11:12 Duration: 6s605ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CREATE TABLE temp0000283882 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"24-06-2026", "ate" :"29-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-29 09:39:21 Duration: 6s121ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CREATE TABLE temp0000283882 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"24-06-2026", "ate" :"29-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-29 09:36:01 Duration: 5s601ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
16 153ms 15s487ms 4s782ms 71 5m39s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 29 00 1 756ms 756ms 05 1 153ms 153ms 06 1 2s282ms 2s282ms 07 10 57s400ms 5s740ms 08 12 1m18s 6s579ms 09 12 1m13s 6s129ms 10 11 55s171ms 5s15ms 11 12 53s392ms 4s449ms 21 5 8s476ms 1s695ms 22 6 9s414ms 1s569ms [ User: intelifix - Total duration: 5m39s - Times executed: 71 ]
[ Application: psql - Total duration: 5m39s - Times executed: 71 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-29 11:25:17 Duration: 15s487ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-29 09:25:16 Duration: 14s634ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-29 08:15:15 Duration: 13s677ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
17 150ms 21s96ms 2s797ms 179 8m20s call rs_giga_triagem (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 29 00 8 41s443ms 5s180ms 01 7 22s635ms 3s233ms 02 8 20s983ms 2s622ms 03 11 22s378ms 2s34ms 04 7 20s321ms 2s903ms 05 8 21s488ms 2s686ms 06 8 21s264ms 2s658ms 07 6 22s713ms 3s785ms 08 7 22s160ms 3s165ms 09 8 30s74ms 3s759ms 10 10 42s67ms 4s206ms 11 9 24s102ms 2s678ms 12 8 16s928ms 2s116ms 13 9 16s363ms 1s818ms 14 8 15s861ms 1s982ms 15 7 16s58ms 2s294ms 16 6 17s107ms 2s851ms 17 8 17s105ms 2s138ms 18 7 16s155ms 2s307ms 19 7 17s507ms 2s501ms 20 7 25s471ms 3s638ms 21 7 14s594ms 2s84ms 22 8 16s34ms 2s4ms [ User: intelifix - Total duration: 8m20s - Times executed: 179 ]
[ Application: psql - Total duration: 8m20s - Times executed: 179 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-29 00:05:23 Duration: 21s96ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-29 10:25:23 Duration: 11s807ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-29 20:15:12 Duration: 10s615ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-29.log
18 159ms 22s726ms 2s764ms 48 2m12s create table temp0000283908 as select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 29 07 8 18s925ms 2s365ms 08 38 1m51s 2s936ms 09 2 2s182ms 1s91ms [ User: intelifix - Total duration: 2m12s - Times executed: 48 ]
[ Application: [unknown] - Total duration: 2m12s - Times executed: 48 ]
-
CREATE TABLE temp0000283908 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "229989", "oficina" : "6", "cliente" : "5", "nf" : "", "data-de" : "24-06-2026", "data-ate" : "29-06-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-06-29 08:03:32 Duration: 22s726ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CREATE TABLE temp0000283908 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "103107", "oficina" : "6", "cliente" : "5", "nf" : "", "data-de" : "24-06-2026", "data-ate" : "29-06-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-06-29 08:31:48 Duration: 19s227ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
CREATE TABLE temp0000283908 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "243112", "oficina" : "6", "cliente" : "5", "nf" : "", "data-de" : "24-06-2026", "data-ate" : "29-06-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-06-29 08:36:32 Duration: 12s583ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
19 150ms 10s94ms 1s359ms 723 16m23s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 29 06 2 5s730ms 2s865ms 07 85 2m32s 1s795ms 08 123 3m17s 1s603ms 09 196 4m25s 1s354ms 10 145 3m1s 1s254ms 11 94 1m57s 1s253ms 12 26 25s14ms 962ms 16 22 16s155ms 734ms 17 30 21s178ms 705ms [ User: intelifix - Total duration: 16m23s - Times executed: 723 ]
[ Application: [unknown] - Total duration: 16m23s - Times executed: 723 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (259581, 503, '733122090351,B4F26767F65C,6802B8FECA31,6802B8FEAF19,B4F26767D3BB,B4F26768000A,B4F267631E5A,B4F267682A0D,B4F26768263E,B4F267681570,B4F26759FE14,B4F26734FD83,B4F267682A16,B4F2676C718B,B4F267621849,B4F267683F85,B4F26755803C,B4F2676812B2,B4F2676C716A,B4F2674B81A7,B4F2676836A0,B4F26767F320,B4F267362E15,B4F26735DB29,B4F2674AE8BC,B4F2676C5A2A,B4F26754F9B4,B4F26768BE78,B4F2676BFF9D,6802B8FEB801,B4F2675972D0,B4F2676C71B8,B4F267365F9E,B4F2676C6FB4,B4F267513074,B4F2670D2C05,B4F2676812D6', '',0300,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-29 07:37:47 Duration: 10s94ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (259254, 450, 'ZTE3ANNQ8M00030,843C991EC89F,843C991EC8A0,ZTEGD7BA478B$ZTE3ANNR5W23223,48D68230A414,48D68230A415,ZTEGDB005AB6$ZTE3ANNQ8122118,689E29BDE52F,689E29BDE530,ZTEGD7B790F6$ZTE3ANNR7B52700,3891484DBFCF,3891484DBFD0,ZTEGDB085F3C$ZTE3ANNQCA29200,14CA56D4F13B,14CA56D4F13C,ZTEGD971D77B$ZTE3ANNQ8M24555,843C9921076D,843C9921076E,ZTEGD7BAA758$ZTE3ANNR3Y40000,4896D9536A38,4896D9536A39,ZTEGD97ECCF5$ZTE3ANNRC524763,6C11BA646E39,6C11BA646E3A,ZTEGDC6E767A$ZTE3ANNR3Y02114,4896D94FF244,4896D94FF245,ZTEGD97E38F7$ZTE3ANNRAM49697,5872C98BC4FF,5872C98BC500,ZTEGDC60C220$ZTE3ANNRC522507,6C11BA643959,6C11BA64395A,ZTEGDC6E6DAA$ZTE3ANNR6R15741,48D68236F5B0,48D68236F5B1,ZTEGDB016850$ZTE3ANNRC522173,6C11BA643185,6C11BA643186,ZTEGDC6E6C5C$ZTE3ANNRCP47771,6C11BA6D8A71,6C11BA6D8A72,ZTEGDC6FFB2E$ZTE3ANNQ4A14219,3CF9F0AB4588,3CF9F0AB4589,ZTEGD641764A$ZTE3ANNRAM21694,5872C98934AD,5872C98934AE,ZTEGDC6054BD$ZTE3ANNR7B52535,3891484DBBF1,3891484DBBF2,ZTEGDB085E97$ZTE3ANNQ9342641,843C99367CA3,843C99367CA4,ZTEGD7BC6288$ZTE3ANNR9W57872,D89A0DADA883,D89A0DADA884,ZTEGDB16F3BB$ZTE3ANNR8C11883,3891484F9D89,3891484F9D8A,ZTEGDB08AEDB$ZTE3ANNR3J13920,F4E84F8794A0,F4E84F8794A1,ZTEGD97B982A$ZTE3ANNQ8129355,689E29BE8ECD,689E29BE8ECE,ZTEGD7B7AD3B$ZTE3ANNRCP48101,6C11BA6D922D,6C11BA6D922E,ZTEGDC6FFC78$ZTE3ANNQ9J25659,843C992E2A97,843C992E2A98,ZTEGD7BB6CE6$ZTE3ANNR5W23185,48D68230A330,48D68230A331,ZTEGDB005A90$ZTE3ANNRB723389,5872C9905D5F,5872C9905D60,ZTEGDC618630$ZTE3ANNQ8M24711,843C99210B15,843C99210B16,ZTEGD7BAA7F4', '',0318,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-29 11:48:06 Duration: 8s743ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (259582, 504, '834054908000165,230050413943,230027589011,230009877798,230010935668,230014007797,229968216381,229982708503,230053313452,230042119092,229971357787,230035442628,229979449812,230007964761,230035672426,230027631619,229977483941,230014033131,229977517378,230044557086,230032968390,230011640923,230029385471,229962721637,230027722133,230027683947,229990929204,229975496575,230034526466,230052199213,229985243150,230042057695,230035461216,229972825473,230015138199,230028389908,229977038487,230053330828,229977499699', '',0295,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-29 07:54:00 Duration: 8s58ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
20 160ms 3s368ms 812ms 85 1m9s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 29 07 25 17s658ms 706ms 08 15 10s677ms 711ms 09 25 23s563ms 942ms 10 12 10s272ms 856ms 11 8 6s872ms 859ms [ User: intelifix - Total duration: 1m9s - Times executed: 85 ]
[ Application: [unknown] - Total duration: 1m9s - Times executed: 85 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0259641) LIMIT 1;
Date: 2026-06-29 07:16:56 Duration: 3s368ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0259691) LIMIT 1;
Date: 2026-06-29 09:01:29 Duration: 3s145ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0259636) LIMIT 1;
Date: 2026-06-29 08:35:10 Duration: 2s694ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-29.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 19 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jun 28 10 2 0ms 0ms 12 1 0ms 0ms 13 2 0ms 0ms 15 1 0ms 0ms 18 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms Jun 29 13 1 0ms 0ms 14 2 0ms 0ms 15 2 0ms 0ms 16 3 0ms 0ms 22 1 0ms 0ms [ User: intelifix - Total duration: 12m26s - Times executed: 19 ]
[ Application: psql - Total duration: 12m25s - Times executed: 17 ]
[ Application: [unknown] - Total duration: 1s11ms - Times executed: 2 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 13,457 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 12 FATAL entries
- 3074 ERROR entries
- 0 WARNING entries
- 4 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 2,921 Max number of times the same event was reported
- 3,090 Total events found
Rank Times reported Error 1 2,921 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jun 29 00 59 01 60 02 60 03 59 04 60 05 60 06 59 07 318 08 406 09 410 10 336 11 237 12 84 13 60 14 60 15 59 16 82 17 104 18 60 19 59 20 60 21 59 22 60 23 50 - ERROR: prepared statement "_PLAN0000000029F209D0" does not exist
- ERROR: prepared statement "_PLAN0000000029C41B50" does not exist
- ERROR: prepared statement "_PLAN0000000029F229C0" does not exist
Statement: DEALLOCATE "_PLAN0000000029F209D0"
Date: 2026-06-29 00:00:35 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-29.log
Statement: DEALLOCATE "_PLAN0000000029C41B50"
Date: 2026-06-29 00:01:36 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-29.log
Statement: DEALLOCATE "_PLAN0000000029F229C0"
Date: 2026-06-29 00:02:36 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-29.log
2 45 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #2
Day Hour Count Jun 29 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 1 - 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-06-29 00:05:02 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-29.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-06-29 00:35:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-29.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-06-29 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-29.log
3 43 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #3
Day Hour Count Jun 29 08 3 09 3 10 3 11 3 12 3 13 3 14 3 15 3 16 2 17 3 18 3 19 3 20 3 21 3 22 2 - 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-06-29 08:00:18 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-29.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-06-29 08:20:08 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-29.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-06-29 08:40:06 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-29.log
4 25 ERROR: invalid input syntax for type date: ...
Times Reported Most Frequent Error / Event #4
Day Hour Count Jun 29 07 24 09 1 - ERROR: invalid input syntax for type date: "N-Na--N-Na" at character 40
- ERROR: invalid input syntax for type date: "N-Na--N-Na" at character 40
- ERROR: invalid input syntax for type date: "N-Na--N-Na" at character 40
Statement: SELECT * FROM RS_RESUMO_PERIODO_GERAL( 'N-Na--N-Na', 0404 ,'', '',0,7,'2026-06-01');
Date: 2026-06-29 07:05:25 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-29.log
Statement: SELECT * FROM RS_RESUMO_PERIODO_GERAL( 'N-Na--N-Na', 0404 ,'', '',0,7,'N-Na--N-Na');
Date: 2026-06-29 07:14:37 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-29.log
Statement: SELECT * FROM RS_RESUMO_PERIODO_GERAL( 'N-Na--N-Na', 0404 ,'', '',0,7,'2026-06-01');
Date: 2026-06-29 07:15:18 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-29.log
5 15 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #5
Day Hour Count Jun 29 08 9 10 6 - ERROR: trailing junk after numeric literal at or near "446AB71777B4" at character 27
- ERROR: trailing junk after numeric literal at or near "446AB71777B4" at character 27
- ERROR: trailing junk after numeric literal at or near "446AB71777B4" at character 27
Statement: SELECT * FROM RS_ETIQUETA(446AB71777B4)
Date: 2026-06-29 08:23:03 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-29.log
Statement: SELECT * FROM RS_ETIQUETA(446AB71777B4)
Date: 2026-06-29 08:23:03 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-29.log
Statement: SELECT * FROM RS_ETIQUETA(446AB71777B4)
Date: 2026-06-29 08:23:03 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-29.log
6 9 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #6
Day Hour Count Jun 29 08 3 10 4 12 2 - ERROR: syntax error at or near "229981143535" at character 41
- ERROR: syntax error at or near "229981143535" at character 41
- ERROR: syntax error at or near "216773257988" at character 79
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''229981143535');
Date: 2026-06-29 08:20:28 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-29.log
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''229981143535');
Date: 2026-06-29 08:20:34 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-29.log
Statement: SELECT RS_SERIAL_TEMPORARIO( '216773257988'' ) OR RS_SERIAL_TEMPORARIO_VIVO( '216773257988'' )
Date: 2026-06-29 08:20:58 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-29.log
7 6 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Jun 29 07 1 10 3 17 2 - ERROR: column "pas_id" does not exist at character 66 2026-06-29 07:58:13 -03 [3430343]: [114-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 "a0c5622848c0" does not exist at character 27
- ERROR: column "a0c5622848c0" 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(0259806);Date: 2026-06-29 07:58:13 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-29.log
Statement: SELECT * FROM RS_ETIQUETA(A0C5622848C0)
Date: 2026-06-29 10:20:17 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-29.log
Statement: SELECT * FROM RS_ETIQUETA(A0C5622848C0)
Date: 2026-06-29 10:20:17 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-29.log
8 5 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #8
Day Hour Count Jun 29 00 1 04 1 06 1 16 1 23 1 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "testes" does not exist
Date: 2026-06-29 00:02:50 Database: testes Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-29.log
Date: 2026-06-29 04:57:27 Database: jaboatao Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-29.log
Date: 2026-06-29 06:02:45 Database: testes Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-29.log
9 5 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #9
Day Hour Count Jun 29 03 5 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-06-29 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-29.log
Statement: CALL RS_GIGA_PROCESSA_ARQUIVOS()
Date: 2026-06-29 03:05:01 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-29.log
Date: 2026-06-29 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-29.log
10 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #10
Day Hour Count Jun 29 05 4 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-06-29 05:32:08 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-29.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-06-29 05:32:08 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-29.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-06-29 05:32:08 Database: contagem Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-29.log
11 3 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #11
Day Hour Count Jun 29 09 1 10 2 - ERROR: canceling autovacuum task
- ERROR: canceling autovacuum task
- ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000283882"
Date: 2026-06-29 09:17:44 Log file: /usr/local/pgsql/data/log/serverlog-29.log
Context: automatic vacuum of table "rio.public.temp0000283906"
Date: 2026-06-29 10:45:45 Log file: /usr/local/pgsql/data/log/serverlog-29.log
Context: automatic vacuum of table "rio.public.temp0000283884"
Date: 2026-06-29 10:48:44 Log file: /usr/local/pgsql/data/log/serverlog-29.log
12 3 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #12
Day Hour Count Jun 29 09 1 10 2 - LOG: process 3500826 still waiting for AccessExclusiveLock on relation 1723180 of database 358220 after 1000.637 ms
- LOG: process 3632477 still waiting for AccessExclusiveLock on relation 1732470 of database 358220 after 1000.217 ms
- LOG: process 3621163 still waiting for AccessExclusiveLock on relation 1732693 of database 358220 after 1000.195 ms
Detail: Process holding the lock: 3556848. Wait queue: 3500826.
Statement: DROP TABLE IF EXISTS temp0000283882;Date: 2026-06-29 09:17:44 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-29.log
Detail: Process holding the lock: 3654579. Wait queue: 3632477.
Statement: DROP TABLE IF EXISTS temp0000283906;Date: 2026-06-29 10:45:45 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-29.log
Detail: Process holding the lock: 3657417. Wait queue: 3621163.
Statement: DROP TABLE IF EXISTS temp0000283884;Date: 2026-06-29 10:48:44 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-29.log
13 2 ERROR: invalid input syntax for type json PL/pgSQL function rs_resumo_tcia(...) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(...) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(...) line 48 at assignment
Times Reported Most Frequent Error / Event #13
Day Hour Count Jun 29 16 1 22 1 - ERROR: invalid input syntax for type json PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
- ERROR: invalid input syntax for type json PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936...
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-29 16:40:07 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-29.log
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936...
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-29 22:00:05 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-29.log
14 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #14
Day Hour Count Jun 29 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-06-29 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-29.log
Date: 2026-06-29 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-29.log
15 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #15
Day Hour Count Jun 29 03 1 - LOG: database system was shut down at 2026-06-29 03:05:01 -03
Date: 2026-06-29 03:05:02 Log file: /usr/local/pgsql/data/log/serverlog-29.log
16 1 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv' PL/Python function "...", line 21, in <module> os.chmod(...) PL/Python function "..." PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Times Reported Most Frequent Error / Event #16
Day Hour Count Jun 29 22 1 - ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv' PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Context: Traceback (most recent call last):
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-06-29 22:05:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-29.log