pgBadger-
Global information
- Generated on Thu Oct 15 23:50:10 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 18,524 log entries in 9s
- Log start from 2026-10-15 00:00:26 to 2026-10-15 23:49:47
-
Overview
Global Stats
- 229 Number of unique normalized queries
- 2,204 Number of queries
- 4h14m24s Total query duration
- 2026-10-15 00:02:11 First query
- 2026-10-15 23:42:58 Last query
- 5 queries/s at 2026-10-15 23:42:35 Query peak
- 4h14m24s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 4h14m24s Execute total duration
- 2,189 Number of events
- 10 Number of unique normalized events
- 2,154 Max number of times the same event was reported
- 0 Number of cancellation
- 85 Total number of automatic vacuums
- 283 Total number of automatic analyzes
- 21 Number temporary file
- 250.47 MiB Max size of temporary file
- 69.85 MiB Average size of temporary file
- 286 Total number of sessions
- 7 sessions at 2026-10-15 06:45:03 Session peak
- 10d23h23m38s Total duration of sessions
- 55m15s Average duration of sessions
- 7 Average queries per session
- 53s373ms Average queries duration per session
- 54m22s Average idle time per session
- 296 Total number of connections
- 5 connections/s at 2026-10-15 03:05:16 Connection peak
- 4 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-10-15 23:42:35 Date
SELECT Traffic
Key values
- 3 queries/s Query Peak
- 2026-10-15 17:11:18 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-10-15 23:42:35 Date
Queries duration
Key values
- 4h14m24s 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) Oct 15 00 21 0ms 13s348ms 3s717ms 2s813ms 3s174ms 49s845ms 01 12 0ms 2s660ms 1s408ms 2s695ms 2s844ms 2s902ms 02 12 0ms 2s758ms 1s420ms 2s677ms 2s873ms 3s35ms 03 11 0ms 2s635ms 1s341ms 503ms 2s829ms 2s948ms 04 12 0ms 2s796ms 1s447ms 2s705ms 2s911ms 3s87ms 05 22 0ms 10m24s 1m2s 3s90ms 2m51s 10m24s 06 19 0ms 9s519ms 2s708ms 2s839ms 2s971ms 26s85ms 07 37 0ms 7m13s 20s283ms 4s445ms 21s917ms 7m56s 08 159 0ms 5m29s 4s881ms 12s895ms 45s998ms 5m29s 09 184 0ms 5m57s 4s163ms 7s998ms 48s713ms 5m57s 10 205 0ms 5m41s 3s746ms 11s862ms 1m4s 5m43s 11 150 0ms 6m2s 5s55ms 5s598ms 9s535ms 6m58s 12 56 0ms 5m56s 11s988ms 4s698ms 49s865ms 5m56s 13 109 0ms 5m22s 6s113ms 4s451ms 19s977ms 5m51s 14 215 0ms 5m26s 3s475ms 16s259ms 25s659ms 5m56s 15 103 0ms 5m26s 6s536ms 4s181ms 30s525ms 5m56s 16 104 0ms 5m22s 6s348ms 11s541ms 16s524ms 5m54s 17 140 0ms 5m32s 5s597ms 29s824ms 59s399ms 5m32s 18 121 0ms 5m35s 5s402ms 3s985ms 45s210ms 5m35s 19 24 0ms 5m15s 24s699ms 2s907ms 15s138ms 5m46s 20 109 0ms 6m34s 11s548ms 1m3s 1m11s 6m56s 21 26 0ms 5m50s 23s782ms 2s859ms 43s543ms 5m50s 22 24 0ms 5m14s 24s651ms 2s872ms 15s687ms 5m44s 23 329 0ms 1m2s 5s975ms 1m5s 1m6s 1m14s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 15 00 4 0 3s346ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 4 0 2s748ms 0ms 0ms 0ms 07 19 0 38s144ms 0ms 1s52ms 3m40s 08 111 0 6s187ms 1s971ms 6s421ms 3m31s 09 149 0 4s860ms 3s165ms 5s523ms 3m36s 10 163 0 4s427ms 2s72ms 6s861ms 3m36s 11 120 0 5s996ms 2s602ms 4s156ms 3m43s 12 21 0 30s53ms 0ms 699ms 3m39s 13 77 0 8s252ms 1s727ms 3s776ms 3m24s 14 181 0 3s972ms 3s431ms 14s630ms 3m28s 15 81 0 8s17ms 1s179ms 2s608ms 3m26s 16 81 0 7s847ms 1s190ms 8s663ms 3m28s 17 114 0 6s143ms 1s839ms 3s65ms 3m28s 18 97 0 6s276ms 1s70ms 2s508ms 3m24s 19 6 0 1m35s 0ms 0ms 3m29s 20 10 80 13s528ms 43s214ms 1m1s 3m33s 21 8 0 1m14s 0ms 0ms 3m21s 22 6 0 1m34s 0ms 0ms 3m29s 23 10 319 5s975ms 1m3s 1m5s 1m14s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 15 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 Oct 15 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 3 3.00 0.00% 08 0 6 6.00 0.00% 09 0 7 7.00 0.00% 10 0 8 8.00 0.00% 11 0 6 6.00 0.00% 12 0 3 3.00 0.00% 13 0 5 5.00 0.00% 14 0 6 6.00 0.00% 15 0 6 6.00 0.00% 16 0 6 6.00 0.00% 17 0 5 5.00 0.00% 18 0 4 4.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 1 1.00 0.00% Day Hour Count Average / Second Oct 15 00 18 0.01/s 01 8 0.00/s 02 9 0.00/s 03 12 0.00/s 04 7 0.00/s 05 10 0.00/s 06 15 0.00/s 07 12 0.00/s 08 16 0.00/s 09 19 0.01/s 10 21 0.01/s 11 15 0.00/s 12 11 0.00/s 13 14 0.00/s 14 15 0.00/s 15 12 0.00/s 16 13 0.00/s 17 14 0.00/s 18 12 0.00/s 19 10 0.00/s 20 12 0.00/s 21 7 0.00/s 22 7 0.00/s 23 7 0.00/s Day Hour Count Average Duration Average idle time Oct 15 00 4 55m54s 55m35s 01 17 1h1m44s 1h1m43s 02 7 1h26s 1h23s 03 13 24m15s 24m13s 04 7 1h3m 1h2m57s 05 8 53m49s 50m58s 06 9 58m25s 58m19s 07 16 58m59s 58m12s 08 10 58m18s 57m 09 21 51m40s 51m3s 10 18 47m46s 47m3s 11 18 57m52s 57m10s 12 13 1h46s 59m55s 13 10 1h18s 59m11s 14 13 1h2m 1h1m3s 15 15 1h53s 1h8s 16 12 1h57s 1h2s 17 12 1h16s 59m10s 18 13 1h40s 59m50s 19 11 1h29s 59m35s 20 12 46m16s 44m31s 21 8 1h22s 59m5s 22 7 1h46s 59m21s 23 12 32m59s 30m16s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-10-15 03:05:16 Date
Connections per database
Key values
- brasilia Main Database
- 296 connections Total
Connections per user
Key values
- intelifix Main User
- 296 connections Total
-
Sessions
Simultaneous sessions
Key values
- 7 sessions Session Peak
- 2026-10-15 06:45:03 Date
Histogram of session times
Key values
- 245 3600000-28800000ms duration
Sessions per database
Key values
- brasilia Main Database
- 286 sessions Total
Sessions per user
Key values
- intelifix Main User
- 286 sessions Total
Sessions per host
Key values
- [local] Main Host
- 286 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 27,400 buffers Checkpoint Peak
- 2026-10-15 00:09:51 Date
- 270.021 seconds Highest write time
- 0.049 seconds Sync time
Checkpoints Wal files
Key values
- 4 files Wal files usage Peak
- 2026-10-15 00:09:51 Date
Checkpoints distance
Key values
- 137.11 Mo Distance Peak
- 2026-10-15 00:09:51 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Oct 15 00 27,400 270.021s 0.002s 270.027s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 8,075 0.182s 0.05s 0.239s 04 0 0s 0s 0s 05 7,019 707.566s 0.032s 707.632s 06 3,912 269.566s 0.002s 269.57s 07 2,578 257.957s 0.022s 257.997s 08 16,386 1,435.031s 0.059s 1,435.129s 09 25,132 2,320.132s 0.071s 2,320.251s 10 19,247 1,952.789s 0.089s 1,952.928s 11 16,602 1,679.797s 0.082s 1,679.925s 12 3,283 329.5s 0.029s 329.557s 13 8,520 853.916s 0.046s 854s 14 16,242 1,650.803s 0.08s 1,650.922s 15 4,587 462.687s 0.046s 462.762s 16 9,284 931.753s 0.045s 931.828s 17 9,089 909.923s 0.053s 910.013s 18 4,626 464.493s 0.025s 464.548s 19 307 30.779s 0.002s 30.783s 20 216 23.474s 0.008s 23.492s 21 395 39.505s 0.004s 39.516s 22 118 11.851s 0.008s 11.864s 23 178 17.889s 0.008s 17.907s Day Hour Added Removed Recycled Synced files Longest sync Average sync Oct 15 00 0 0 4 34 0.001s 0.001s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 3 27 0.045s 0.004s 04 0 0 0 0 0s 0s 05 0 0 4 200 0.008s 0.007s 06 0 0 0 10 0.001s 0.001s 07 0 0 1 532 0.002s 0.007s 08 0 0 6 2,949 0.002s 0.012s 09 0 0 9 3,954 0.003s 0.012s 10 0 0 7 4,371 0.003s 0.012s 11 0 0 5 3,969 0.002s 0.012s 12 0 0 1 1,154 0.002s 0.009s 13 0 0 3 2,708 0.002s 0.012s 14 0 0 6 3,675 0.002s 0.012s 15 0 0 1 1,622 0.002s 0.012s 16 0 0 3 2,104 0.003s 0.012s 17 0 0 5 2,255 0.002s 0.012s 18 0 0 2 920 0.002s 0.011s 19 0 0 0 55 0.002s 0.001s 20 0 0 0 71 0.001s 0.004s 21 0 0 0 43 0.002s 0.002s 22 0 0 0 19 0.002s 0.003s 23 0 0 0 28 0.003s 0.005s Day Hour Count Avg time (sec) Oct 15 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 Oct 15 00 70,202.00 kB 70,202.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 24,655.50 kB 34,056.50 kB 04 0.00 kB 0.00 kB 05 7,674.29 kB 11,338.57 kB 06 9,090.00 kB 12,968.00 kB 07 2,016.00 kB 9,445.43 kB 08 8,378.75 kB 11,799.00 kB 09 12,695.67 kB 26,642.92 kB 10 8,834.58 kB 18,437.42 kB 11 7,576.00 kB 13,449.17 kB 12 1,870.44 kB 7,261.11 kB 13 3,626.50 kB 4,538.83 kB 14 7,782.75 kB 9,812.25 kB 15 1,937.92 kB 8,571.50 kB 16 3,375.67 kB 4,694.33 kB 17 7,381.08 kB 30,694.50 kB 18 2,398.91 kB 13,887.36 kB 19 1,611.00 kB 7,645.00 kB 20 585.75 kB 6,063.25 kB 21 833.00 kB 4,546.50 kB 22 123.33 kB 3,587.00 kB 23 122.75 kB 2,527.25 kB -
Temporary Files
Size of temporary files
Key values
- 500.94 MiB Temp Files size Peak
- 2026-10-15 05:32:02 Date
Number of temporary files
Key values
- 4 per second Temp Files Peak
- 2026-10-15 05:32:09 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Oct 15 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 20 1.33 GiB 68.14 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 1 104.00 MiB 104.00 MiB 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 16 1.03 GiB 37.35 MiB 250.47 MiB 65.74 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-15 05:32:11 Duration: 1m25s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-15 05:32:02 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 4 311.04 MiB 57.81 MiB 95.14 MiB 77.76 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-15 05:30:45 Duration: 44s286ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-15 05:30:42 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
3 1 104.00 MiB 104.00 MiB 104.00 MiB 104.00 MiB select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');
Date: 2026-10-15 17:06:43 Duration: 53s479ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_seriais_expedidos(7,DATE(''2026-10-01''),DATE(''2026-10-14'')) ;', '/var/www/html/tmp/temp_54.xlsx');
Date: 2026-10-15 08:17:44 Duration: 30s910ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_seriais_expedidos(7,DATE(''2026-10-05''),DATE(''2026-10-15'')) ;', '/var/www/html/tmp/temp_54.xlsx');
Date: 2026-10-15 10:36:34 Duration: 14s14ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
Queries generating the largest temporary files
Rank Size Query 1 250.47 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-15 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 250.47 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-15 05:32:02 - 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-10-15 17:06:42 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 95.14 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-15 05:30:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 95.14 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-15 05:30:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 62.95 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-15 05:30:45 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 57.81 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-15 05:30:45 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 41.39 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-15 05:32:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 41.33 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-15 05:32:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 41.33 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-15 05:32:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 41.32 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-15 05:32:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 41.32 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-15 05:32:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 41.32 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-15 05:32:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 41.32 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-15 05:32:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 37.42 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-15 05:32:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 37.36 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-15 05:32:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 37.36 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-15 05:32:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 37.36 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-15 05:32:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 37.36 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-15 05:32:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 37.36 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-15 05:32:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.25 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database brasilia - 2026-10-15 05:17:53 Date
- 0 sec Highest CPU-cost analyze
Table
Database brasilia - Date
Average Autovacuum Duration
Key values
- 0.25 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database brasilia - 2026-10-15 05:17:53 Date
Analyzes per table
Key values
- public.temp0000227550 (57) Main table analyzed (database contagem)
- 283 analyzes Total
Table Number of analyzes contagem.public.temp0000227550 57 brasilia.pg_catalog.pg_attribute 33 contagem.pg_catalog.pg_attribute 26 contagem.public.usuarios 16 brasilia.pg_catalog.pg_class 15 brasilia.pg_catalog.pg_type 12 brasilia.public.temp0000242236 12 brasilia.public.temp0000242240 11 contagem.pg_catalog.pg_class 11 contagem.pg_catalog.pg_type 10 brasilia.public.usuarios 9 brasilia.public.temp0000242196 8 brasilia.pg_catalog.pg_index 7 contagem.pg_catalog.pg_index 6 contagem.pg_catalog.pg_depend 5 contagem.public.temp0000227540 5 brasilia.pg_catalog.pg_depend 5 rio.pg_catalog.pg_attribute 3 brasilia.public.temp0000242200 3 brasilia.public.temp0000242218 3 brasilia.public.temp0000242206 3 contagem.public.nf_entrada 2 rio.public.temp0000294102 2 contagem.public.temp0000227546 2 contagem.pg_catalog.pg_shdepend 1 brasilia.public.temp0000242220 1 rio.public.temp0000294086 1 brasilia.public.temp0000242266 1 brasilia.public.temp0000242226 1 brasilia.public.temp0000242202 1 rio.public.temp0000294046 1 brasilia.public.temp0000242254 1 brasilia.public.temp0000242248 1 contagem.public.temp0000227556 1 rio.pg_catalog.pg_type 1 rio.public.temp0000294096 1 brasilia.public.temp0000242222 1 rio.pg_catalog.pg_class 1 brasilia.public.temp0000242250 1 contagem.public.temp0000227544 1 rio.pg_catalog.pg_shdepend 1 Total 283 Vacuums per table
Key values
- public.usuarios (15) Main table vacuumed on database contagem
- 85 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples contagem.public.usuarios 15 0 0 0 0 0 0 80 63 30,981 0 0 brasilia.pg_catalog.pg_attribute 9 9 0 0 0 0 0 4,484 1,331 2,172,876 48 1,402 contagem.pg_catalog.pg_attribute 9 9 0 0 0 0 0 6,107 1,654 2,954,695 20 611 contagem.public.temp0000227540 5 0 0 0 0 0 0 595 30 40,000 0 0 contagem.pg_catalog.pg_class 4 4 0 0 0 0 0 794 127 212,597 5 16 brasilia.pg_catalog.pg_class 4 4 0 0 0 0 0 753 291 471,243 21 66 contagem.pg_catalog.pg_type 4 4 0 0 0 0 0 395 70 122,470 7 14 brasilia.pg_catalog.pg_type 4 4 0 0 0 0 0 358 135 208,961 12 36 brasilia.public.temp0000242206 3 0 0 0 0 0 0 780 268 447,283 0 0 brasilia.pg_catalog.pg_index 3 3 0 0 0 0 0 168 49 43,638 15 26 contagem.pg_catalog.pg_index 3 3 0 0 0 0 0 205 50 53,951 4 5 contagem.pg_catalog.pg_depend 3 3 0 0 0 0 0 889 196 422,765 6 36 rio.public.temp0000294102 2 0 0 0 0 0 0 8 6 1,548 0 0 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 376 81 401,516 39 108 testes.pg_catalog.pg_shdepend 2 2 0 0 0 0 0 528 154 349,940 23 34 brasilia.pg_catalog.pg_statistic 2 2 0 0 0 0 0 3,661 739 3,059,970 618 4,141 contagem.pg_catalog.pg_statistic 2 2 0 0 0 0 0 3,161 960 3,100,802 827 5,533 rio.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 855 256 1,096,391 102 411 brasilia.public.temp0000242200 1 0 0 0 0 0 0 260 4 15,943 0 0 brasilia.pg_catalog.pg_depend 1 1 0 0 0 0 0 449 150 238,814 2 17 rio.pg_catalog.pg_type 1 1 0 0 0 0 0 118 54 68,885 4 8 brasilia.public.temp0000242222 1 0 0 0 0 0 0 260 4 15,943 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 176 39 106,553 20 58 rio.pg_catalog.pg_attribute 1 1 0 0 0 0 0 413 154 221,445 1 17 rio.pg_catalog.pg_statistic 1 1 0 0 0 0 0 3,296 1,088 3,875,113 1,041 6,273 rio.public.temp0000294086 1 0 0 0 0 0 0 1,864 4 110,579 0 0 Total 85 57 0 0 0 0 0 31,033 7,957 19,844,902 2,815 18,812 Vacuum throughput per table
Key values
- pg_catalog.pg_attribute (0.78) Max CPU elapsed for vacuum on database contagem
- unknown (0 ms) Max I/O read time for vacuum on database contagem
- unknown (0 ms) Max I/O write time for vacuum on database contagem
I/O timing (ms) CPU (s) Table read write elapsed contagem.public.usuarios 0 0 0 brasilia.pg_catalog.pg_attribute 0 0 0.54 contagem.pg_catalog.pg_attribute 0 0 0.78 contagem.public.temp0000227540 0 0 0 contagem.pg_catalog.pg_class 0 0 0.17 brasilia.pg_catalog.pg_class 0 0 0.11 contagem.pg_catalog.pg_type 0 0 0.13 brasilia.pg_catalog.pg_type 0 0 0.11 brasilia.public.temp0000242206 0 0 0.01 brasilia.pg_catalog.pg_index 0 0 0.01 contagem.pg_catalog.pg_index 0 0 0.08 contagem.pg_catalog.pg_depend 0 0 0.17 rio.public.temp0000294102 0 0 0.09 brasilia.pg_toast.pg_toast_2619 0 0 0.02 testes.pg_catalog.pg_shdepend 0 0 0.1 brasilia.pg_catalog.pg_statistic 0 0 0.39 contagem.pg_catalog.pg_statistic 0 0 0.24 rio.pg_toast.pg_toast_2619 0 0 0.06 brasilia.public.temp0000242200 0 0 0 brasilia.pg_catalog.pg_depend 0 0 0.12 rio.pg_catalog.pg_type 0 0 0.08 brasilia.public.temp0000242222 0 0 0 contagem.pg_toast.pg_toast_2619 0 0 0 rio.pg_catalog.pg_attribute 0 0 0.2 rio.pg_catalog.pg_statistic 0 0 0.21 rio.public.temp0000294086 0 0 0.05 Total 0 0 3.67 Tuples removed per table
Key values
- pg_catalog.pg_attribute (38632) Main table with removed tuples on database contagem
- 96135 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain contagem.pg_catalog.pg_attribute 9 9 38,632 222,888 0 196 4,987 brasilia.pg_catalog.pg_attribute 9 9 30,920 203,596 0 0 4,906 contagem.pg_catalog.pg_statistic 2 2 5,572 14,965 0 0 2,022 brasilia.pg_catalog.pg_statistic 2 2 5,125 15,267 0 0 2,142 rio.pg_catalog.pg_statistic 1 1 4,599 7,464 0 0 1,286 contagem.pg_catalog.pg_type 4 4 2,064 8,998 0 26 270 testes.pg_catalog.pg_shdepend 2 2 1,501 35,995 1 0 302 contagem.pg_catalog.pg_index 3 3 1,108 5,689 0 0 168 rio.pg_catalog.pg_attribute 1 1 1,033 21,563 0 0 562 contagem.pg_catalog.pg_depend 3 3 1,022 56,093 0 14 531 contagem.public.usuarios 15 0 899 360 0 0 30 brasilia.pg_catalog.pg_type 4 4 712 8,864 12 0 251 brasilia.pg_catalog.pg_class 4 4 672 13,520 0 0 484 rio.pg_toast.pg_toast_2619 1 1 632 669 0 123 169 brasilia.pg_catalog.pg_index 3 3 532 5,653 5 0 162 brasilia.pg_catalog.pg_depend 1 1 344 18,166 0 0 174 contagem.pg_catalog.pg_class 4 4 342 14,344 0 24 603 brasilia.pg_toast.pg_toast_2619 2 2 191 278 0 11 108 contagem.pg_toast.pg_toast_2619 1 1 151 116 0 0 63 rio.pg_catalog.pg_type 1 1 84 2,219 8 0 73 brasilia.public.temp0000242206 3 0 0 10,230 0 0 768 rio.public.temp0000294102 2 0 0 52,989 0 0 3,840 brasilia.public.temp0000242200 1 0 0 3,410 0 0 256 brasilia.public.temp0000242222 1 0 0 3,411 0 0 256 contagem.public.temp0000227540 5 0 0 7,101 0 85 555 rio.public.temp0000294086 1 0 0 26,494 0 0 1,920 Total 85 57 96,135 760,342 26 479 26,888 Pages removed per table
Key values
- pg_catalog.pg_attribute (196) Main table with removed pages on database contagem
- 479 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed contagem.pg_catalog.pg_attribute 9 9 38632 196 rio.pg_toast.pg_toast_2619 1 1 632 123 contagem.public.temp0000227540 5 0 0 85 contagem.pg_catalog.pg_type 4 4 2064 26 contagem.pg_catalog.pg_class 4 4 342 24 contagem.pg_catalog.pg_depend 3 3 1022 14 brasilia.pg_toast.pg_toast_2619 2 2 191 11 contagem.public.usuarios 15 0 899 0 brasilia.public.temp0000242206 3 0 0 0 rio.public.temp0000294102 2 0 0 0 brasilia.public.temp0000242200 1 0 0 0 brasilia.pg_catalog.pg_depend 1 1 344 0 brasilia.pg_catalog.pg_index 3 3 532 0 brasilia.pg_catalog.pg_class 4 4 672 0 testes.pg_catalog.pg_shdepend 2 2 1501 0 contagem.pg_catalog.pg_index 3 3 1108 0 rio.pg_catalog.pg_type 1 1 84 0 brasilia.public.temp0000242222 1 0 0 0 contagem.pg_toast.pg_toast_2619 1 1 151 0 brasilia.pg_catalog.pg_attribute 9 9 30920 0 brasilia.pg_catalog.pg_statistic 2 2 5125 0 rio.pg_catalog.pg_attribute 1 1 1033 0 contagem.pg_catalog.pg_statistic 2 2 5572 0 rio.pg_catalog.pg_statistic 1 1 4599 0 rio.public.temp0000294086 1 0 0 0 brasilia.pg_catalog.pg_type 4 4 712 0 Total 85 57 96,135 479 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Oct 15 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 6 0 06 0 0 07 0 0 08 13 25 09 19 32 10 14 40 11 5 23 12 1 3 13 6 19 14 5 34 15 1 21 16 5 23 17 9 47 18 1 14 19 0 0 20 0 0 21 0 2 22 0 0 23 0 0 - 0.25 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 1,262 Total read queries
- 519 Total write queries
Queries by database
Key values
- brasilia Main database
- 1,082 Requests
- 2h35m54s (rio)
- Main time consuming database
Database Request type Count Duration brasilia Total 1,082 1h27m37s copy to 139 10m54s cursor 5 3s921ms ddl 87 49s381ms others 229 10m2s select 622 1h5m46s contagem Total 628 10m51s copy to 115 1m24s ddl 13 9s499ms others 3 3m5s select 497 6m11s rio Total 491 2h35m54s copy to 145 29m33s ddl 15 1m45s others 191 20m6s select 140 1h44m29s testes Total 3 1s101ms select 3 1s101ms Queries by user
Key values
- intelifix Main user
- 2,125 Requests
User Request type Count Duration etiquetas Total 2 634ms select 2 634ms intelifix Total 2,125 4h13m35s copy to 399 41m52s ddl 115 2m44s others 423 33m15s select 1,188 2h55m42s lenon Total 77 49s200ms cursor 5 3s921ms select 72 45s278ms Duration by user
Key values
- 4h13m35s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 2 634ms select 2 634ms intelifix Total 2,125 4h13m35s copy to 399 41m52s ddl 115 2m44s others 423 33m15s select 1,188 2h55m42s lenon Total 77 49s200ms cursor 5 3s921ms select 72 45s278ms Queries by host
Key values
- [local] Main host
- 2,199 Requests
- 4h14m21s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 1,248 Requests
- 3h15m33s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-10-15 21:50:21 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 1,199 100-500ms duration
Slowest individual queries
Rank Duration Query 1 10m24s analyze verbose;[ Date: 2026-10-15 05:10:26 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 7m13s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-15 07:12:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 6m59s analyze verbose;[ Date: 2026-10-15 05:17:25 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
4 6m34s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-15 20:11:36 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 6m2s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-15 11:11:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 5m57s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-15 09:10:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 5m56s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-15 12:10:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 5m50s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-15 21:10:51 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 5m41s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-15 10:10:43 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 5m35s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-15 18:10:36 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 5m32s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-15 17:10:33 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m29s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-15 08:10:30 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 5m26s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-15 14:10:28 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m26s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-15 15:10:27 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m22s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-15 16:10:24 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m22s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-15 13:10:24 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m15s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-15 19:10:17 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 5m14s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-15 22:10:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 3m39s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-10-15 11:15:34 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
20 3m36s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-10-15 12:15:22 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1h37m12s 48 2s388ms 7m13s 2m1s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 15 07 3 7m41s 2m33s 08 3 5m47s 1m55s 09 3 6m15s 2m5s 10 3 6m2s 2m 11 3 6m22s 2m7s 12 3 6m15s 2m5s 13 3 5m40s 1m53s 14 3 5m44s 1m54s 15 3 5m43s 1m54s 16 3 5m40s 1m53s 17 3 5m53s 1m57s 18 3 5m52s 1m57s 19 3 5m33s 1m51s 20 3 6m56s 2m18s 21 3 6m7s 2m2s 22 3 5m33s 1m51s [ User: intelifix - Total duration: 1h37m12s - Times executed: 48 ]
[ Application: psql - Total duration: 1h37m12s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-15 07:12:14 Duration: 7m13s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-15 20:11:36 Duration: 6m34s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-15 11:11:03 Duration: 6m2s Database: rio User: intelifix Remote: [local] Application: psql
2 1h4m24s 48 273ms 3m39s 1m20s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 15 07 3 4m17s 1m25s 08 3 3m58s 1m19s 09 3 4m5s 1m21s 10 3 4m17s 1m25s 11 3 4m14s 1m24s 12 3 4m8s 1m22s 13 3 3m50s 1m16s 14 3 3m55s 1m18s 15 3 3m52s 1m17s 16 3 3m55s 1m18s 17 3 4m4s 1m21s 18 3 3m51s 1m17s 19 3 3m57s 1m19s 20 3 4m10s 1m23s 21 3 3m48s 1m16s 22 3 3m56s 1m18s [ User: intelifix - Total duration: 1h4m24s - Times executed: 48 ]
[ Application: psql - Total duration: 1h4m24s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-15 11:15:34 Duration: 3m39s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-15 12:15:22 Duration: 3m36s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-15 09:15:20 Duration: 3m33s Database: brasilia User: intelifix Remote: [local] Application: psql
3 20m15s 3 2m51s 10m24s 6m45s analyze verbose;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 15 05 3 20m15s 6m45s [ User: intelifix - Total duration: 20m15s - Times executed: 3 ]
[ Application: psql - Total duration: 20m15s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-10-15 05:10:26 Duration: 10m24s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-15 05:17:25 Duration: 6m59s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-15 05:20:17 Duration: 2m51s Database: contagem User: intelifix Remote: [local] Application: psql
4 7m15s 275 234ms 12s763ms 1s582ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 15 00 12 29s288ms 2s440ms 01 12 16s902ms 1s408ms 02 12 17s41ms 1s420ms 03 11 14s756ms 1s341ms 04 12 17s375ms 1s447ms 05 12 17s775ms 1s481ms 06 12 17s532ms 1s461ms 07 12 17s704ms 1s475ms 08 12 18s116ms 1s509ms 09 12 17s862ms 1s488ms 10 12 19s158ms 1s596ms 11 12 20s875ms 1s739ms 12 12 18s248ms 1s520ms 13 12 17s73ms 1s422ms 14 12 17s439ms 1s453ms 15 12 17s836ms 1s486ms 16 12 17s798ms 1s483ms 17 12 18s22ms 1s501ms 18 12 17s25ms 1s418ms 19 12 17s399ms 1s449ms 20 12 35s453ms 2s954ms 21 12 17s31ms 1s419ms 22 12 17s450ms 1s454ms [ User: intelifix - Total duration: 7m15s - Times executed: 275 ]
[ Application: psql - Total duration: 7m15s - Times executed: 275 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-15 00:05:14 Duration: 12s763ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-15 20:15:12 Duration: 10s476ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-15 20:05:12 Duration: 10s453ms Database: rio User: intelifix Remote: [local] Application: psql
5 3m56s 349 152ms 4s225ms 677ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 15 08 37 27s662ms 747ms 09 69 56s120ms 813ms 10 80 41s726ms 521ms 11 70 48s771ms 696ms 12 1 177ms 177ms 13 32 17s368ms 542ms 14 39 27s9ms 692ms 15 12 12s48ms 1s4ms 16 9 5s595ms 621ms [ User: intelifix - Total duration: 3m56s - Times executed: 349 ]
[ Application: [unknown] - Total duration: 3m56s - Times executed: 349 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (61953, 406, 'ZTEAH7VQ6H04887,6877DA61C99B$ZTEAH7VQ6H01700,6877DA6197CF$ZTEEH7VM1905317,304240910110$ZTEKH7VP3E09291,D8E8448D5C96$ZTEAH7VQ5H07779,6877DA6107BB$ZTEAH7VQ6L10085,6877DA62D21B$ZTEAH7VQ8P09757,802D1A1EF3B0$ZTEKH7VP3C13992,D8E8448CB6FA$ZTEEH7VM1911816,30424091669C$ZTEKH7VP3C14335,D8E8448CBC56$ZTEAH7VQ6H01502,6877DA6194B7$ZTEKH7VP3E01257,D8E8448CDF0E$ZTEKH7VP3E02909,D8E8448CF8DE$ZTEKH7VP3811692,D8E8448AB99A$ZTEAH7VQAQ27318,203AEBA72FC6$ZTEAH7VQ5H08071,6877DA610C4B$ZTEAH7VQ6L10123,6877DA62D2B3$ZTEAH7VQ1Y14889,6877DA590F43$ZTEKH7VP2V04877,CC29BDEDF9F9$ZTEAH7VQ6L02775,6877DA625FE3$ZTEAH7VPBU17759,F42D0645C103$ZTEAH7VQ1Y14471,6877DA5908BB$ZTEKH7VP2P06076,CC29BDED6D55$ZTEAH7VQ8P09626,802D1A1EF1A4$ZTEAH7VPBU17761,F42D0645C10B$ZTEAH7VQAQ28476,203AEBA741DE$ZTEAH7VQAQ23901,203AEBA6FA62$ZTEAH7VQAQ16782,203AEBA68B26$ZTEAH7VQAQ23815,203AEBA6F90A$ZTEAH7VQAQ27360,203AEBA7306E$ZTEAH7VQ3L01566,6877DA5EC887$ZTEAH7VQ6L02781,6877DA625FFB$ZTEKH7VP3714293,D8E84489F7DE$ZTEKH7VP3U00505,CC29BDEB78D9$ZTEAH7VQ6H01716,6877DA61980F$ZTEAH7VQA318217,802D1A20B6A0$ZTEAH7VQAQ26590,203AEBA72466$ZTEAH7VQAQ27439,203AEBA731AA$ZTEAH7VQ5A00986,6877DA5FAE87$ZTEAH7VQAQ29220,203AEBA74D7E$ZTEAH7VQ8P09749,802D1A1EF390$ZTEKH7VP3E09338,D8E8448D5D52$ZTEEH7VM1900040,30424090AE9C$ZTEAH7VQA318325,802D1A20B850$ZTEAH7VQAQ23701,203AEBA6F742$ZTEAH7VQ5H07962,6877DA610A97$ZTEAH7VQ3E10063,6877DA5E5E3B$ZTEEH7VP3H04103,D8E844AA8AF2$ZTEAH7VQAQ29058,203AEBA74AF6$ZTEKH7VP3C13929,D8E8448CB5FE', '',0301,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-15 08:41:25 Duration: 4s225ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (61956, 406, 'ZTE3A8TR7905231,E44E12B136CD$ZTE3A8TRCB19829,7C7D21EDC6D7$ZTE3A8TT3C20588,14200455A322$ZTE3A8TRCP00317,7C7D21EE2467$ZTE3A8TT7P16839,C492D9465473$ZTE3A8TT7P16481,C492D9464EDB$ZTE3A8TT7P18755,C492D9467263$ZTE3A8TT2L04209,7C7D21F17E17$ZTE3A8TRB719241,7C7D21EC2F37$ZTE3A8TR4708187,DC5193DB8872$ZTE3A8TT3C20612,14200455A382$ZTE3A8TR8U20666,B47CA608F38A$ZTE3A8TT7P17214,C492D9465A4F$ZTE3A8TT7P18657,C492D94670DB$ZTE3A8TR6D17364,E44E12B065F1$ZTE3A8TT3C20548,14200455A282$ZTE3A8TR7R17784,E44E12B38961$ZTE3A8TR7R04803,E44E12B2BE8D$ZTE3A8TR1M18618,DC5193DAECAE$ZTE3A8TRCP05591,7C7D21EE76CF$ZTE3A8TR7R17977,E44E12B38C65$ZTE3A8TRCB05484,7C7D21ECE6B3$ZTE3A8TT3C20551,14200455A28E$ZTE3A8TT7P16486,C492D9464EEF$ZTE3A8TT4725048,1420045905B2$ZTE3A8TR4H13696,38165A47F9F0$ZTE3A8TT4725129,1420045906F6$ZTE3A8TT4723066,14200458E6BA$ZTE3A8TT2L04211,7C7D21F17E1F$ZTE3A8TR7R25008,E44E12B3FA41$ZTE3A8TR5U24676,E44E1292DFD7$ZTE3A8TR8U08526,B47CA60835DA$ZTE3A8TR5U06684,E44E1291C6B7$ZTE3A8TR7R19966,E44E12B3AB79$ZTE3A8TT7P16469,C492D9464EAB$ZTE3A8TR7R02767,E44E12B29EBD$ZTE3A8TQCH13618,DC5193D95FCE$ZTE3A8TR7R20109,E44E12B3ADB5$ZTE3A8TT7P07225,C492D945BE3B$ZTE3A8TRCB09218,7C7D21ED210B$ZTE3A8TT3R18085,142004570A76$ZTE3A8TR7R25020,E44E12B3FA71$ZTE3A8TT3C20461,14200455A126$ZTE3A8TR6D00387,E44E12AF5CAD$ZTE3A8TT7P07233,C492D945BE5B$ZTE3A8TR4H13735,38165A47FA8C$ZTE3A8TT7P17129,C492D94658FB$ZTE3A8TR6D00304,E44E12AF5B61$ZTE3A8TT3R18712,142004571442$ZTE3A8TT3C20539,14200455A25E', '',05,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-15 09:24:41 Duration: 4s188ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (62003, 407, 'ZTE3ANNR9F16447,D89A0DA45F5D,D89A0DA45F5E,ZTEGDB15678A$ZTE3ANNQ4N06169,3CF9F0A92244,3CF9F0A92245,ZTEGD6411B14$ZTE3ANNR7B15974,3891484A630B,3891484A630C,ZTEGDB07CFC6$ZTE3ANNR6R54959,48D6823A8CDC,48D6823A8CDD,ZTEGDB020182$ZTE3ANNR9W41877,D89A0DAC31A1,D89A0DAC31A2,ZTEGDB16B540$ZTE3ANNRCB62323,D831392383B0,D831392383B1,ZTEGDD2AA908$ZTE3ANNR3Y13470,4896D950FC6C,4896D950FC6D,ZTEGD97E6553$ZTE3ANNT2V87080,D831399387C8,D831399387C9,ZTEGDD3146A7$ZTE3ANNR9F16453,D89A0DA45F81,D89A0DA45F82,ZTEGDB156790$ZTE3ANNR5W17728,48D68230234A,48D68230234B,ZTEGDB00453F$ZTE3ANNQ7T01129,C4EBFF8F05B6,C4EBFF8F05B7,ZTEGD70AFC5F$ZTE3ANNRCP46575,6C11BA6D6E69,6C11BA6D6E6A,ZTEGDC6FF682$ZTE3ANNT2V87102,D8313993884C,D8313993884D,ZTEGDD3146BD$ZTE3ANNRCP46510,6C11BA6D6CE3,6C11BA6D6CE4,ZTEGDC6FF641$ZTE3ANNT2V87027,D8313993868A,D8313993868B,ZTEGDD314672$ZTE3ANNR3J00349,F4E84F86568E,F4E84F86568F,ZTEGD97B6327$ZTE3ANNR8C33774,389148519E9B,389148519E9C,ZTEGDB09045E$ZTE3ANNRC550486,6C11BA66C91B,6C11BA66C91C,ZTEGDC6EDAF5$ZTE3ANNR5W14491,48D6822FD76C,48D6822FD76D,ZTEGDB00389A$ZTE3ANNQ6M07531,C4EBFF891252,C4EBFF891253,ZTEGD709FE79$ZTE3ANNQ8M44305,843C9922D651,843C9922D652,ZTEGD7BAF47E$ZTE3ANNT2V87130,D831399388F4,D831399388F5,ZTEGDD3146D9$ZTE3ANNR3J00182,F4E84F8652A4,F4E84F8652A5,ZTEGD97B6280$ZTE3ANNT3H69040,D831399D15B8,D831399D15B9,ZTEGDD32DE4F$ZTE3ANNR5W25539,48D68230DA5C,48D68230DA5D,ZTEGDB0063C2', '',0323,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-15 09:09:27 Duration: 2s485ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
6 3m47s 60 174ms 53s479ms 3s789ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 15 08 8 41s68ms 5s133ms 09 3 7s478ms 2s492ms 10 7 19s415ms 2s773ms 11 9 10s545ms 1s171ms 12 1 303ms 303ms 13 6 14s616ms 2s436ms 14 7 36s812ms 5s258ms 15 1 373ms 373ms 16 5 22s838ms 4s567ms 17 10 1m9s 6s980ms 18 3 4s100ms 1s366ms [ User: intelifix - Total duration: 3m47s - Times executed: 60 ]
[ Application: [unknown] - Total duration: 3m47s - Times executed: 60 ]
-
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-10-15 17:06:43 Duration: 53s479ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_seriais_expedidos(7,DATE(''2026-10-01''),DATE(''2026-10-14'')) ;', '/var/www/html/tmp/temp_54.xlsx');
Date: 2026-10-15 08:17:44 Duration: 30s910ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_seriais_expedidos(7,DATE(''2026-10-05''),DATE(''2026-10-15'')) ;', '/var/www/html/tmp/temp_54.xlsx');
Date: 2026-10-15 10:36:34 Duration: 14s14ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
7 2m14s 4 4s324ms 1m2s 33s566ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 15 20 2 1m6s 33s490ms 23 2 1m7s 33s641ms [ User: intelifix - Total duration: 2m14s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m14s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-15 23:16:43 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-15 20:08:40 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-15 20:10:40 Duration: 4s444ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 1m48s 6 3s327ms 40s506ms 18s135ms copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 15 20 3 54s471ms 18s157ms 23 3 54s338ms 18s112ms [ User: intelifix - Total duration: 1m48s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m48s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-15 20:06:27 Duration: 40s506ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-15 23:14:29 Duration: 40s360ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-15 20:10:16 Duration: 10s638ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
9 1m47s 4 352ms 53s650ms 26s911ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 15 20 2 53s638ms 26s819ms 23 2 54s6ms 27s3ms [ User: intelifix - Total duration: 1m47s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m47s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-15 23:13:46 Duration: 53s650ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-15 20:05:44 Duration: 53s285ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-15 23:33:24 Duration: 355ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 1m25s 1 1m25s 1m25s 1m25s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 15 05 1 1m25s 1m25s [ User: intelifix - Total duration: 1m25s - Times executed: 1 ]
[ Application: psql - Total duration: 1m25s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-15 05:32:11 Duration: 1m25s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-15 05:32:02 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
11 1m24s 296 150ms 1s803ms 285ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 15 14 98 37s373ms 381ms 15 41 9s601ms 234ms 16 21 4s780ms 227ms 17 63 16s588ms 263ms 18 73 16s302ms 223ms [ User: intelifix - Total duration: 1m24s - Times executed: 296 ]
[ Application: [unknown] - Total duration: 1m24s - Times executed: 296 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"140781","seriais":"241794705360,241720326485,241720329718,241720328405,241720319616,241749093737,241749103839,241720454455,241754173436,241754306580,241789369193,241722041524,241789385862,241789328102,241789423644,241789387377,241722903336,241789337698,241756744046,241754300217,241789320930,241782109204,241753722427,241722040918,241789326586,241722402446,241720322950,241789325273,241720320829,241789324263,241797964455,241736949701,241789604144,241720344141,241753777078,241758225874","usuario":"399","observacao":""}');
Date: 2026-10-15 14:44:13 Duration: 1s803ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"140781","seriais":"241732917186,241689722242,241635380923,241694155457,241674206574,241675309701,241700914355,241697346161,241706975474,241628158589,241638266568,241631571819,241616746780,241631567373,241694152427,241602703345,241675311318,241710921213,241620598794,241674163641,241706995476,241663206679,241713100921,241631404350,241674158993,241620644355,241635369002,241620544547,241674212838,241638252022,241672699716,241677392834,241694562849,241671935567,241694570123,241712720424,241628171622,241645695161,241691698797,241617104649","usuario":"399","observacao":""}');
Date: 2026-10-15 14:39:46 Duration: 1s428ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"140781","seriais":"241764408295,241772759919,241763492337,241820479705,241764402740,241820411416,241772768506,241820600627,241771181920,241747438907,241771855476,241764409710,241772770426,241771226671,241763502540,241764386374,241764496688,241744349402,241767960304,241740571840,241763486982,241767956565,241814043544,241772576163,241740589393","usuario":"399","observacao":""}');
Date: 2026-10-15 14:43:35 Duration: 1s374ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
12 1m23s 6 2s325ms 31s887ms 13s983ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 15 20 3 42s81ms 14s27ms 23 3 41s819ms 13s939ms [ User: intelifix - Total duration: 1m23s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m23s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-15 20:07:01 Duration: 31s887ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-15 23:15:03 Duration: 31s775ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-15 20:10:24 Duration: 7s868ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 1m22s 6 2s972ms 31s933ms 13s807ms copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 15 20 3 41s568ms 13s856ms 23 3 41s279ms 13s759ms [ User: intelifix - Total duration: 1m22s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m22s - Times executed: 6 ]
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-15 20:09:13 Duration: 31s933ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-15 23:17:15 Duration: 31s825ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-15 20:10:47 Duration: 6s600ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 1m12s 6 2s551ms 24s32ms 12s33ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 15 20 3 35s864ms 11s954ms 23 3 36s334ms 12s111ms [ User: intelifix - Total duration: 1m12s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m12s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-15 23:10:48 Duration: 24s32ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-15 20:02:47 Duration: 23s503ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-15 20:09:33 Duration: 9s797ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 1m11s 6 2s241ms 24s208ms 11s888ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 15 20 3 35s638ms 11s879ms 23 3 35s691ms 11s897ms [ User: intelifix - Total duration: 1m11s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m11s - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-15 23:11:30 Duration: 24s208ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-15 20:03:28 Duration: 24s201ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-15 23:33:04 Duration: 9s208ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 1m9s 53 568ms 22s389ms 1s309ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 15 08 3 2s768ms 922ms 09 3 5s202ms 1s734ms 10 4 5s150ms 1s287ms 11 3 2s444ms 814ms 12 4 3s85ms 771ms 13 4 3s401ms 850ms 14 5 4s22ms 804ms 15 3 2s515ms 838ms 16 3 2s415ms 805ms 17 3 3s279ms 1s93ms 18 5 25s258ms 5s51ms 19 3 2s485ms 828ms 20 3 2s186ms 728ms 21 4 3s219ms 804ms 22 3 1s988ms 662ms [ User: intelifix - Total duration: 1m9s - Times executed: 53 ]
[ Application: psql - Total duration: 1m9s - Times executed: 53 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-15 18:00:24 Duration: 22s389ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-15 09:40:06 Duration: 3s599ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-15 10:40:05 Duration: 3s29ms Database: brasilia User: intelifix Remote: [local] Application: psql
17 1m8s 182 152ms 1s19ms 374ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 15 07 3 1s919ms 639ms 08 20 7s964ms 398ms 09 35 14s633ms 418ms 10 40 16s107ms 402ms 11 13 4s481ms 344ms 12 5 2s327ms 465ms 13 13 4s438ms 341ms 14 11 3s930ms 357ms 15 6 2s201ms 366ms 16 19 5s420ms 285ms 17 16 4s577ms 286ms 18 1 161ms 161ms [ User: intelifix - Total duration: 1m8s - Times executed: 182 ]
[ Application: [unknown] - Total duration: 1m8s - Times executed: 182 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "140738", "modelo" : "323", "itens" : "48D6823A379E,6C11BA6BF331,14CA56D2C15B,C4EBFF895E3C,843C99200015,F4E84F88DFF6,843C99227C1B,843C9935D5B7,48D68237EDCC,843C99340F55,843C9932F73B,48D68237D962,C4EBFF8C3316,843C9934170B,D8313992A54E,6C11BA64AAA5,843C9935D6D7,6C11BA68A765,14CA56CFD847,843C993336E9", "usuario" : "427", "caixa" : "0", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-15 10:35:34 Duration: 1s19ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "140745", "modelo" : "298", "itens" : "D4925EFA29EA,08C7F52EA097,D4925EE387F2,D4925E1961A8,08C7F52BBB25,A0B53CC39659,D4925E0897BC,D4925E196D03", "usuario" : "428", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "elisa[[tela]]" }');
Date: 2026-10-15 13:18:56 Duration: 905ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "140738", "modelo" : "338", "itens" : "C04E8ADA6C1E,48575443594737B8,485754438AD4C1B6,48575443F0B06CB7,4857544377B10FB8,48575443F0B17CB7,48575443368FA9B8,4857544359186CB8,485754434EE4E3BA,68962E0A3928,2C9452D7D4C0,9025F2991C23", "usuario" : "427", "caixa" : "0", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-15 10:24:18 Duration: 897ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
18 1m8s 18 1s334ms 16s724ms 3s781ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 15 08 2 6s131ms 3s65ms 09 2 6s545ms 3s272ms 10 5 13s878ms 2s775ms 11 1 3s185ms 3s185ms 13 2 6s747ms 3s373ms 14 2 4s781ms 2s390ms 15 1 16s724ms 16s724ms 16 1 5s164ms 5s164ms 17 2 4s904ms 2s452ms [ User: intelifix - Total duration: 1m8s - Times executed: 18 ]
[ Application: [unknown] - Total duration: 1m8s - Times executed: 18 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-13', 0302, '', '', 0, 6, '2026-10-13');
Date: 2026-10-15 15:50:12 Duration: 16s724ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-15', 0404, '', '', 0, 7, '2026-10-01');
Date: 2026-10-15 16:45:21 Duration: 5s164ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-15', 0399, '', '', 0, 7, '2026-10-01');
Date: 2026-10-15 08:19:57 Duration: 3s547ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
19 1m4s 6 1s723ms 25s330ms 10s743ms copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 15 20 3 31s953ms 10s651ms 23 3 32s507ms 10s835ms [ User: intelifix - Total duration: 1m4s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m4s - Times executed: 6 ]
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-10-15 23:12:29 Duration: 25s330ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-10-15 20:04:27 Duration: 25s183ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-10-15 23:33:19 Duration: 5s359ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 1m2s 15 388ms 14s630ms 4s141ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 15 10 1 1s948ms 1s948ms 11 6 9s974ms 1s662ms 13 2 16s312ms 8s156ms 14 3 24s168ms 8s56ms 15 1 388ms 388ms 16 2 9s332ms 4s666ms [ User: intelifix - Total duration: 1m2s - Times executed: 15 ]
[ Application: [unknown] - Total duration: 1m2s - Times executed: 15 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (059277) LIMIT 1;
Date: 2026-10-15 14:00:59 Duration: 14s630ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (059276) LIMIT 1;
Date: 2026-10-15 13:32:31 Duration: 11s612ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (059276) LIMIT 1;
Date: 2026-10-15 16:20:29 Duration: 7s370ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 349 3m56s 152ms 4s225ms 677ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 15 08 37 27s662ms 747ms 09 69 56s120ms 813ms 10 80 41s726ms 521ms 11 70 48s771ms 696ms 12 1 177ms 177ms 13 32 17s368ms 542ms 14 39 27s9ms 692ms 15 12 12s48ms 1s4ms 16 9 5s595ms 621ms [ User: intelifix - Total duration: 3m56s - Times executed: 349 ]
[ Application: [unknown] - Total duration: 3m56s - Times executed: 349 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (61953, 406, 'ZTEAH7VQ6H04887,6877DA61C99B$ZTEAH7VQ6H01700,6877DA6197CF$ZTEEH7VM1905317,304240910110$ZTEKH7VP3E09291,D8E8448D5C96$ZTEAH7VQ5H07779,6877DA6107BB$ZTEAH7VQ6L10085,6877DA62D21B$ZTEAH7VQ8P09757,802D1A1EF3B0$ZTEKH7VP3C13992,D8E8448CB6FA$ZTEEH7VM1911816,30424091669C$ZTEKH7VP3C14335,D8E8448CBC56$ZTEAH7VQ6H01502,6877DA6194B7$ZTEKH7VP3E01257,D8E8448CDF0E$ZTEKH7VP3E02909,D8E8448CF8DE$ZTEKH7VP3811692,D8E8448AB99A$ZTEAH7VQAQ27318,203AEBA72FC6$ZTEAH7VQ5H08071,6877DA610C4B$ZTEAH7VQ6L10123,6877DA62D2B3$ZTEAH7VQ1Y14889,6877DA590F43$ZTEKH7VP2V04877,CC29BDEDF9F9$ZTEAH7VQ6L02775,6877DA625FE3$ZTEAH7VPBU17759,F42D0645C103$ZTEAH7VQ1Y14471,6877DA5908BB$ZTEKH7VP2P06076,CC29BDED6D55$ZTEAH7VQ8P09626,802D1A1EF1A4$ZTEAH7VPBU17761,F42D0645C10B$ZTEAH7VQAQ28476,203AEBA741DE$ZTEAH7VQAQ23901,203AEBA6FA62$ZTEAH7VQAQ16782,203AEBA68B26$ZTEAH7VQAQ23815,203AEBA6F90A$ZTEAH7VQAQ27360,203AEBA7306E$ZTEAH7VQ3L01566,6877DA5EC887$ZTEAH7VQ6L02781,6877DA625FFB$ZTEKH7VP3714293,D8E84489F7DE$ZTEKH7VP3U00505,CC29BDEB78D9$ZTEAH7VQ6H01716,6877DA61980F$ZTEAH7VQA318217,802D1A20B6A0$ZTEAH7VQAQ26590,203AEBA72466$ZTEAH7VQAQ27439,203AEBA731AA$ZTEAH7VQ5A00986,6877DA5FAE87$ZTEAH7VQAQ29220,203AEBA74D7E$ZTEAH7VQ8P09749,802D1A1EF390$ZTEKH7VP3E09338,D8E8448D5D52$ZTEEH7VM1900040,30424090AE9C$ZTEAH7VQA318325,802D1A20B850$ZTEAH7VQAQ23701,203AEBA6F742$ZTEAH7VQ5H07962,6877DA610A97$ZTEAH7VQ3E10063,6877DA5E5E3B$ZTEEH7VP3H04103,D8E844AA8AF2$ZTEAH7VQAQ29058,203AEBA74AF6$ZTEKH7VP3C13929,D8E8448CB5FE', '',0301,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-15 08:41:25 Duration: 4s225ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (61956, 406, 'ZTE3A8TR7905231,E44E12B136CD$ZTE3A8TRCB19829,7C7D21EDC6D7$ZTE3A8TT3C20588,14200455A322$ZTE3A8TRCP00317,7C7D21EE2467$ZTE3A8TT7P16839,C492D9465473$ZTE3A8TT7P16481,C492D9464EDB$ZTE3A8TT7P18755,C492D9467263$ZTE3A8TT2L04209,7C7D21F17E17$ZTE3A8TRB719241,7C7D21EC2F37$ZTE3A8TR4708187,DC5193DB8872$ZTE3A8TT3C20612,14200455A382$ZTE3A8TR8U20666,B47CA608F38A$ZTE3A8TT7P17214,C492D9465A4F$ZTE3A8TT7P18657,C492D94670DB$ZTE3A8TR6D17364,E44E12B065F1$ZTE3A8TT3C20548,14200455A282$ZTE3A8TR7R17784,E44E12B38961$ZTE3A8TR7R04803,E44E12B2BE8D$ZTE3A8TR1M18618,DC5193DAECAE$ZTE3A8TRCP05591,7C7D21EE76CF$ZTE3A8TR7R17977,E44E12B38C65$ZTE3A8TRCB05484,7C7D21ECE6B3$ZTE3A8TT3C20551,14200455A28E$ZTE3A8TT7P16486,C492D9464EEF$ZTE3A8TT4725048,1420045905B2$ZTE3A8TR4H13696,38165A47F9F0$ZTE3A8TT4725129,1420045906F6$ZTE3A8TT4723066,14200458E6BA$ZTE3A8TT2L04211,7C7D21F17E1F$ZTE3A8TR7R25008,E44E12B3FA41$ZTE3A8TR5U24676,E44E1292DFD7$ZTE3A8TR8U08526,B47CA60835DA$ZTE3A8TR5U06684,E44E1291C6B7$ZTE3A8TR7R19966,E44E12B3AB79$ZTE3A8TT7P16469,C492D9464EAB$ZTE3A8TR7R02767,E44E12B29EBD$ZTE3A8TQCH13618,DC5193D95FCE$ZTE3A8TR7R20109,E44E12B3ADB5$ZTE3A8TT7P07225,C492D945BE3B$ZTE3A8TRCB09218,7C7D21ED210B$ZTE3A8TT3R18085,142004570A76$ZTE3A8TR7R25020,E44E12B3FA71$ZTE3A8TT3C20461,14200455A126$ZTE3A8TR6D00387,E44E12AF5CAD$ZTE3A8TT7P07233,C492D945BE5B$ZTE3A8TR4H13735,38165A47FA8C$ZTE3A8TT7P17129,C492D94658FB$ZTE3A8TR6D00304,E44E12AF5B61$ZTE3A8TT3R18712,142004571442$ZTE3A8TT3C20539,14200455A25E', '',05,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-15 09:24:41 Duration: 4s188ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (62003, 407, 'ZTE3ANNR9F16447,D89A0DA45F5D,D89A0DA45F5E,ZTEGDB15678A$ZTE3ANNQ4N06169,3CF9F0A92244,3CF9F0A92245,ZTEGD6411B14$ZTE3ANNR7B15974,3891484A630B,3891484A630C,ZTEGDB07CFC6$ZTE3ANNR6R54959,48D6823A8CDC,48D6823A8CDD,ZTEGDB020182$ZTE3ANNR9W41877,D89A0DAC31A1,D89A0DAC31A2,ZTEGDB16B540$ZTE3ANNRCB62323,D831392383B0,D831392383B1,ZTEGDD2AA908$ZTE3ANNR3Y13470,4896D950FC6C,4896D950FC6D,ZTEGD97E6553$ZTE3ANNT2V87080,D831399387C8,D831399387C9,ZTEGDD3146A7$ZTE3ANNR9F16453,D89A0DA45F81,D89A0DA45F82,ZTEGDB156790$ZTE3ANNR5W17728,48D68230234A,48D68230234B,ZTEGDB00453F$ZTE3ANNQ7T01129,C4EBFF8F05B6,C4EBFF8F05B7,ZTEGD70AFC5F$ZTE3ANNRCP46575,6C11BA6D6E69,6C11BA6D6E6A,ZTEGDC6FF682$ZTE3ANNT2V87102,D8313993884C,D8313993884D,ZTEGDD3146BD$ZTE3ANNRCP46510,6C11BA6D6CE3,6C11BA6D6CE4,ZTEGDC6FF641$ZTE3ANNT2V87027,D8313993868A,D8313993868B,ZTEGDD314672$ZTE3ANNR3J00349,F4E84F86568E,F4E84F86568F,ZTEGD97B6327$ZTE3ANNR8C33774,389148519E9B,389148519E9C,ZTEGDB09045E$ZTE3ANNRC550486,6C11BA66C91B,6C11BA66C91C,ZTEGDC6EDAF5$ZTE3ANNR5W14491,48D6822FD76C,48D6822FD76D,ZTEGDB00389A$ZTE3ANNQ6M07531,C4EBFF891252,C4EBFF891253,ZTEGD709FE79$ZTE3ANNQ8M44305,843C9922D651,843C9922D652,ZTEGD7BAF47E$ZTE3ANNT2V87130,D831399388F4,D831399388F5,ZTEGDD3146D9$ZTE3ANNR3J00182,F4E84F8652A4,F4E84F8652A5,ZTEGD97B6280$ZTE3ANNT3H69040,D831399D15B8,D831399D15B9,ZTEGDD32DE4F$ZTE3ANNR5W25539,48D68230DA5C,48D68230DA5D,ZTEGDB0063C2', '',0323,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-15 09:09:27 Duration: 2s485ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
2 296 1m24s 150ms 1s803ms 285ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 15 14 98 37s373ms 381ms 15 41 9s601ms 234ms 16 21 4s780ms 227ms 17 63 16s588ms 263ms 18 73 16s302ms 223ms [ User: intelifix - Total duration: 1m24s - Times executed: 296 ]
[ Application: [unknown] - Total duration: 1m24s - Times executed: 296 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"140781","seriais":"241794705360,241720326485,241720329718,241720328405,241720319616,241749093737,241749103839,241720454455,241754173436,241754306580,241789369193,241722041524,241789385862,241789328102,241789423644,241789387377,241722903336,241789337698,241756744046,241754300217,241789320930,241782109204,241753722427,241722040918,241789326586,241722402446,241720322950,241789325273,241720320829,241789324263,241797964455,241736949701,241789604144,241720344141,241753777078,241758225874","usuario":"399","observacao":""}');
Date: 2026-10-15 14:44:13 Duration: 1s803ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"140781","seriais":"241732917186,241689722242,241635380923,241694155457,241674206574,241675309701,241700914355,241697346161,241706975474,241628158589,241638266568,241631571819,241616746780,241631567373,241694152427,241602703345,241675311318,241710921213,241620598794,241674163641,241706995476,241663206679,241713100921,241631404350,241674158993,241620644355,241635369002,241620544547,241674212838,241638252022,241672699716,241677392834,241694562849,241671935567,241694570123,241712720424,241628171622,241645695161,241691698797,241617104649","usuario":"399","observacao":""}');
Date: 2026-10-15 14:39:46 Duration: 1s428ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"140781","seriais":"241764408295,241772759919,241763492337,241820479705,241764402740,241820411416,241772768506,241820600627,241771181920,241747438907,241771855476,241764409710,241772770426,241771226671,241763502540,241764386374,241764496688,241744349402,241767960304,241740571840,241763486982,241767956565,241814043544,241772576163,241740589393","usuario":"399","observacao":""}');
Date: 2026-10-15 14:43:35 Duration: 1s374ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
3 275 7m15s 234ms 12s763ms 1s582ms call rs_giga_triagem (?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 15 00 12 29s288ms 2s440ms 01 12 16s902ms 1s408ms 02 12 17s41ms 1s420ms 03 11 14s756ms 1s341ms 04 12 17s375ms 1s447ms 05 12 17s775ms 1s481ms 06 12 17s532ms 1s461ms 07 12 17s704ms 1s475ms 08 12 18s116ms 1s509ms 09 12 17s862ms 1s488ms 10 12 19s158ms 1s596ms 11 12 20s875ms 1s739ms 12 12 18s248ms 1s520ms 13 12 17s73ms 1s422ms 14 12 17s439ms 1s453ms 15 12 17s836ms 1s486ms 16 12 17s798ms 1s483ms 17 12 18s22ms 1s501ms 18 12 17s25ms 1s418ms 19 12 17s399ms 1s449ms 20 12 35s453ms 2s954ms 21 12 17s31ms 1s419ms 22 12 17s450ms 1s454ms [ User: intelifix - Total duration: 7m15s - Times executed: 275 ]
[ Application: psql - Total duration: 7m15s - Times executed: 275 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-15 00:05:14 Duration: 12s763ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-15 20:15:12 Duration: 10s476ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-15 20:05:12 Duration: 10s453ms Database: rio User: intelifix Remote: [local] Application: psql
4 182 1m8s 152ms 1s19ms 374ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 15 07 3 1s919ms 639ms 08 20 7s964ms 398ms 09 35 14s633ms 418ms 10 40 16s107ms 402ms 11 13 4s481ms 344ms 12 5 2s327ms 465ms 13 13 4s438ms 341ms 14 11 3s930ms 357ms 15 6 2s201ms 366ms 16 19 5s420ms 285ms 17 16 4s577ms 286ms 18 1 161ms 161ms [ User: intelifix - Total duration: 1m8s - Times executed: 182 ]
[ Application: [unknown] - Total duration: 1m8s - Times executed: 182 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "140738", "modelo" : "323", "itens" : "48D6823A379E,6C11BA6BF331,14CA56D2C15B,C4EBFF895E3C,843C99200015,F4E84F88DFF6,843C99227C1B,843C9935D5B7,48D68237EDCC,843C99340F55,843C9932F73B,48D68237D962,C4EBFF8C3316,843C9934170B,D8313992A54E,6C11BA64AAA5,843C9935D6D7,6C11BA68A765,14CA56CFD847,843C993336E9", "usuario" : "427", "caixa" : "0", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-15 10:35:34 Duration: 1s19ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "140745", "modelo" : "298", "itens" : "D4925EFA29EA,08C7F52EA097,D4925EE387F2,D4925E1961A8,08C7F52BBB25,A0B53CC39659,D4925E0897BC,D4925E196D03", "usuario" : "428", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "elisa[[tela]]" }');
Date: 2026-10-15 13:18:56 Duration: 905ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "140738", "modelo" : "338", "itens" : "C04E8ADA6C1E,48575443594737B8,485754438AD4C1B6,48575443F0B06CB7,4857544377B10FB8,48575443F0B17CB7,48575443368FA9B8,4857544359186CB8,485754434EE4E3BA,68962E0A3928,2C9452D7D4C0,9025F2991C23", "usuario" : "427", "caixa" : "0", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-15 10:24:18 Duration: 897ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
5 64 20s900ms 301ms 600ms 326ms 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 #5
Day Hour Count Duration Avg duration Oct 15 07 3 1s228ms 409ms 08 6 1s937ms 322ms 09 7 2s421ms 345ms 10 8 2s606ms 325ms 11 6 2s88ms 348ms 12 3 1s4ms 334ms 13 5 1s550ms 310ms 14 6 1s904ms 317ms 15 5 1s546ms 309ms 16 6 1s843ms 307ms 17 5 1s540ms 308ms 18 4 1s229ms 307ms [ User: lenon - Total duration: 20s900ms - Times executed: 64 ]
[ Application: [unknown] - Total duration: 20s900ms - Times executed: 64 ]
-
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-10-15 07:09:39 Duration: 600ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-10-15 11:17:02 Duration: 468ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-10-15 09:52:01 Duration: 428ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes
6 60 3m47s 174ms 53s479ms 3s789ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 15 08 8 41s68ms 5s133ms 09 3 7s478ms 2s492ms 10 7 19s415ms 2s773ms 11 9 10s545ms 1s171ms 12 1 303ms 303ms 13 6 14s616ms 2s436ms 14 7 36s812ms 5s258ms 15 1 373ms 373ms 16 5 22s838ms 4s567ms 17 10 1m9s 6s980ms 18 3 4s100ms 1s366ms [ User: intelifix - Total duration: 3m47s - Times executed: 60 ]
[ Application: [unknown] - Total duration: 3m47s - Times executed: 60 ]
-
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-10-15 17:06:43 Duration: 53s479ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_seriais_expedidos(7,DATE(''2026-10-01''),DATE(''2026-10-14'')) ;', '/var/www/html/tmp/temp_54.xlsx');
Date: 2026-10-15 08:17:44 Duration: 30s910ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_seriais_expedidos(7,DATE(''2026-10-05''),DATE(''2026-10-15'')) ;', '/var/www/html/tmp/temp_54.xlsx');
Date: 2026-10-15 10:36:34 Duration: 14s14ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
7 55 20s863ms 335ms 514ms 379ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 15 07 1 342ms 342ms 08 5 1s980ms 396ms 09 5 1s973ms 394ms 10 8 3s117ms 389ms 11 6 2s468ms 411ms 12 1 383ms 383ms 13 5 1s831ms 366ms 14 5 1s854ms 370ms 15 4 1s497ms 374ms 16 6 2s134ms 355ms 17 5 1s860ms 372ms 18 4 1s420ms 355ms [ User: intelifix - Total duration: 20s863ms - Times executed: 55 ]
[ Application: [unknown] - Total duration: 20s863ms - Times executed: 55 ]
-
select * from rs_menu_grants (399, 18, 1);
Date: 2026-10-15 11:17:02 Duration: 514ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (428, 19, 1);
Date: 2026-10-15 09:52:01 Duration: 496ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (407, 18, 1);
Date: 2026-10-15 08:17:12 Duration: 439ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
8 53 1m9s 568ms 22s389ms 1s309ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 15 08 3 2s768ms 922ms 09 3 5s202ms 1s734ms 10 4 5s150ms 1s287ms 11 3 2s444ms 814ms 12 4 3s85ms 771ms 13 4 3s401ms 850ms 14 5 4s22ms 804ms 15 3 2s515ms 838ms 16 3 2s415ms 805ms 17 3 3s279ms 1s93ms 18 5 25s258ms 5s51ms 19 3 2s485ms 828ms 20 3 2s186ms 728ms 21 4 3s219ms 804ms 22 3 1s988ms 662ms [ User: intelifix - Total duration: 1m9s - Times executed: 53 ]
[ Application: psql - Total duration: 1m9s - Times executed: 53 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-15 18:00:24 Duration: 22s389ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-15 09:40:06 Duration: 3s599ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-15 10:40:05 Duration: 3s29ms Database: brasilia User: intelifix Remote: [local] Application: psql
9 48 1h37m12s 2s388ms 7m13s 2m1s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 15 07 3 7m41s 2m33s 08 3 5m47s 1m55s 09 3 6m15s 2m5s 10 3 6m2s 2m 11 3 6m22s 2m7s 12 3 6m15s 2m5s 13 3 5m40s 1m53s 14 3 5m44s 1m54s 15 3 5m43s 1m54s 16 3 5m40s 1m53s 17 3 5m53s 1m57s 18 3 5m52s 1m57s 19 3 5m33s 1m51s 20 3 6m56s 2m18s 21 3 6m7s 2m2s 22 3 5m33s 1m51s [ User: intelifix - Total duration: 1h37m12s - Times executed: 48 ]
[ Application: psql - Total duration: 1h37m12s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-15 07:12:14 Duration: 7m13s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-15 20:11:36 Duration: 6m34s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-15 11:11:03 Duration: 6m2s Database: rio User: intelifix Remote: [local] Application: psql
10 48 1h4m24s 273ms 3m39s 1m20s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 15 07 3 4m17s 1m25s 08 3 3m58s 1m19s 09 3 4m5s 1m21s 10 3 4m17s 1m25s 11 3 4m14s 1m24s 12 3 4m8s 1m22s 13 3 3m50s 1m16s 14 3 3m55s 1m18s 15 3 3m52s 1m17s 16 3 3m55s 1m18s 17 3 4m4s 1m21s 18 3 3m51s 1m17s 19 3 3m57s 1m19s 20 3 4m10s 1m23s 21 3 3m48s 1m16s 22 3 3m56s 1m18s [ User: intelifix - Total duration: 1h4m24s - Times executed: 48 ]
[ Application: psql - Total duration: 1h4m24s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-15 11:15:34 Duration: 3m39s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-15 12:15:22 Duration: 3m36s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-15 09:15:20 Duration: 3m33s Database: brasilia User: intelifix Remote: [local] Application: psql
11 45 54s366ms 166ms 3s299ms 1s208ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 15 00 1 313ms 313ms 07 5 7s364ms 1s472ms 08 6 5s790ms 965ms 09 6 11s640ms 1s940ms 10 6 10s208ms 1s701ms 11 5 4s791ms 958ms 12 5 6s640ms 1s328ms 13 6 5s938ms 989ms 14 2 849ms 424ms 16 1 166ms 166ms 18 1 308ms 308ms 20 1 354ms 354ms [ User: intelifix - Total duration: 54s366ms - Times executed: 45 ]
[ Application: psql - Total duration: 54s366ms - Times executed: 45 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-15 09:25:07 Duration: 3s299ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-15 09:05:07 Duration: 2s676ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-15 12:05:06 Duration: 2s623ms Database: brasilia User: intelifix Remote: [local] Application: psql
12 35 31s69ms 583ms 2s127ms 887ms call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 15 08 3 3s315ms 1s105ms 09 2 1s635ms 817ms 10 1 877ms 877ms 11 3 2s418ms 806ms 12 2 1s915ms 957ms 13 2 1s453ms 726ms 14 1 862ms 862ms 15 3 2s456ms 818ms 16 3 2s181ms 727ms 17 3 3s442ms 1s147ms 18 1 726ms 726ms 19 3 2s296ms 765ms 20 3 3s303ms 1s101ms 21 2 1s550ms 775ms 22 3 2s632ms 877ms [ User: intelifix - Total duration: 31s69ms - Times executed: 35 ]
[ Application: psql - Total duration: 31s69ms - Times executed: 35 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-15 20:20:03 Duration: 2s127ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-15 17:20:03 Duration: 2s26ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-15 08:00:03 Duration: 1s714ms Database: rio User: intelifix Remote: [local] Application: psql
13 31 10s205ms 189ms 617ms 329ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 15 07 2 920ms 460ms 08 16 5s104ms 319ms 09 13 4s179ms 321ms [ User: intelifix - Total duration: 10s205ms - Times executed: 31 ]
[ Application: [unknown] - Total duration: 10s205ms - Times executed: 31 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '7C7D21F11227,E44E12AF7055,E44E12B28FD5,7C7D21EC06BF,E44E12930283,1420045A354A,DC5193DC1B16,38165A47DD04,E44E1293E9AF,14200455D2D2,DC5193DC3F02,7C7D21EFFDEB,E44E12B2D879,14200458657E,E44E1292FFEB,14200454FA16,E44E1293E683,14200454F7CE,14200455E5DA', '','DEFAULT',09,0329,'', '','', 00);
Date: 2026-10-15 09:02:35 Duration: 617ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, 'D89A0D8569B3,843C992C3D8F,C4EBFF89FB3E,3CF9F0AD4A6C,843C99202D1B,C4EBFF89FFE8,D8313920B96E,5872C98AEADD,6C11BA687C2D,3CF9F0AD4994,F4E84F897C8C,C4EBFF8C2140,5872C98D2C03,843C99219005,D8313993ACDC,48D68233DE2E,6C11BA687E13,5872C98D27A7,5872C98D2693,D831399B161A', '138;1', 'DEFAULT', 09, 0323, '','', '', 00);
Date: 2026-10-15 08:51:19 Duration: 499ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '534164025863,534171044555,531151049308,534337000620,531110083147,531181112639,534166075561,531176080710', '138;1', 'DEFAULT', 09, 0211, '','', '', 00);
Date: 2026-10-15 07:53:35 Duration: 492ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
14 31 9s78ms 261ms 385ms 292ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 15 08 6 1s817ms 302ms 09 2 566ms 283ms 10 5 1s535ms 307ms 11 2 632ms 316ms 12 1 273ms 273ms 13 6 1s625ms 270ms 14 1 280ms 280ms 16 3 957ms 319ms 17 4 1s115ms 278ms 18 1 273ms 273ms [ User: intelifix - Total duration: 9s78ms - Times executed: 31 ]
[ Application: [unknown] - Total duration: 9s78ms - Times executed: 31 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-10-15 16:47:33 Duration: 385ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-10-15 08:31:02 Duration: 371ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 054;
Date: 2026-10-15 10:36:10 Duration: 350ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
15 18 1m8s 1s334ms 16s724ms 3s781ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 15 08 2 6s131ms 3s65ms 09 2 6s545ms 3s272ms 10 5 13s878ms 2s775ms 11 1 3s185ms 3s185ms 13 2 6s747ms 3s373ms 14 2 4s781ms 2s390ms 15 1 16s724ms 16s724ms 16 1 5s164ms 5s164ms 17 2 4s904ms 2s452ms [ User: intelifix - Total duration: 1m8s - Times executed: 18 ]
[ Application: [unknown] - Total duration: 1m8s - Times executed: 18 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-13', 0302, '', '', 0, 6, '2026-10-13');
Date: 2026-10-15 15:50:12 Duration: 16s724ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-15', 0404, '', '', 0, 7, '2026-10-01');
Date: 2026-10-15 16:45:21 Duration: 5s164ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-15', 0399, '', '', 0, 7, '2026-10-01');
Date: 2026-10-15 08:19:57 Duration: 3s547ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
16 15 1m2s 388ms 14s630ms 4s141ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 15 10 1 1s948ms 1s948ms 11 6 9s974ms 1s662ms 13 2 16s312ms 8s156ms 14 3 24s168ms 8s56ms 15 1 388ms 388ms 16 2 9s332ms 4s666ms [ User: intelifix - Total duration: 1m2s - Times executed: 15 ]
[ Application: [unknown] - Total duration: 1m2s - Times executed: 15 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (059277) LIMIT 1;
Date: 2026-10-15 14:00:59 Duration: 14s630ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (059276) LIMIT 1;
Date: 2026-10-15 13:32:31 Duration: 11s612ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (059276) LIMIT 1;
Date: 2026-10-15 16:20:29 Duration: 7s370ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
17 9 3s938ms 353ms 763ms 437ms select * from rs_menu (?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 15 07 2 1s117ms 558ms 08 1 429ms 429ms 09 2 841ms 420ms 12 2 812ms 406ms 14 1 365ms 365ms 15 1 371ms 371ms [ User: intelifix - Total duration: 3s938ms - Times executed: 9 ]
[ Application: [unknown] - Total duration: 3s938ms - Times executed: 9 ]
-
SELECT * FROM RS_MENU (404, 1);
Date: 2026-10-15 07:09:39 Duration: 763ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MENU (434, 1);
Date: 2026-10-15 08:41:02 Duration: 429ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MENU (503, 1);
Date: 2026-10-15 12:05:08 Duration: 428ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 8 24s377ms 422ms 9s362ms 3s47ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 15 00 4 13s385ms 3s346ms 06 4 10s992ms 2s748ms [ User: lenon - Total duration: 24s377ms - Times executed: 8 ]
[ Application: psql - Total duration: 24s377ms - Times executed: 8 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-10-15 00:02:11 Duration: 9s362ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-10-15 06:02:09 Duration: 7s722ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-10-15 00:02:13 Duration: 1s981ms Database: brasilia User: lenon Remote: [local] Application: psql
19 6 1m48s 3s327ms 40s506ms 18s135ms copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 15 20 3 54s471ms 18s157ms 23 3 54s338ms 18s112ms [ User: intelifix - Total duration: 1m48s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m48s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-15 20:06:27 Duration: 40s506ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-15 23:14:29 Duration: 40s360ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-15 20:10:16 Duration: 10s638ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 6 1m23s 2s325ms 31s887ms 13s983ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 15 20 3 42s81ms 14s27ms 23 3 41s819ms 13s939ms [ User: intelifix - Total duration: 1m23s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m23s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-15 20:07:01 Duration: 31s887ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-15 23:15:03 Duration: 31s775ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-15 20:10:24 Duration: 7s868ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m51s 10m24s 6m45s 3 20m15s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 15 05 3 20m15s 6m45s [ User: intelifix - Total duration: 20m15s - Times executed: 3 ]
[ Application: psql - Total duration: 20m15s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-10-15 05:10:26 Duration: 10m24s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-15 05:17:25 Duration: 6m59s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-15 05:20:17 Duration: 2m51s Database: contagem User: intelifix Remote: [local] Application: psql
2 2s388ms 7m13s 2m1s 48 1h37m12s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 15 07 3 7m41s 2m33s 08 3 5m47s 1m55s 09 3 6m15s 2m5s 10 3 6m2s 2m 11 3 6m22s 2m7s 12 3 6m15s 2m5s 13 3 5m40s 1m53s 14 3 5m44s 1m54s 15 3 5m43s 1m54s 16 3 5m40s 1m53s 17 3 5m53s 1m57s 18 3 5m52s 1m57s 19 3 5m33s 1m51s 20 3 6m56s 2m18s 21 3 6m7s 2m2s 22 3 5m33s 1m51s [ User: intelifix - Total duration: 1h37m12s - Times executed: 48 ]
[ Application: psql - Total duration: 1h37m12s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-15 07:12:14 Duration: 7m13s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-15 20:11:36 Duration: 6m34s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-15 11:11:03 Duration: 6m2s Database: rio User: intelifix Remote: [local] Application: psql
3 1m25s 1m25s 1m25s 1 1m25s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 15 05 1 1m25s 1m25s [ User: intelifix - Total duration: 1m25s - Times executed: 1 ]
[ Application: psql - Total duration: 1m25s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-15 05:32:11 Duration: 1m25s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-15 05:32:02 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
4 273ms 3m39s 1m20s 48 1h4m24s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 15 07 3 4m17s 1m25s 08 3 3m58s 1m19s 09 3 4m5s 1m21s 10 3 4m17s 1m25s 11 3 4m14s 1m24s 12 3 4m8s 1m22s 13 3 3m50s 1m16s 14 3 3m55s 1m18s 15 3 3m52s 1m17s 16 3 3m55s 1m18s 17 3 4m4s 1m21s 18 3 3m51s 1m17s 19 3 3m57s 1m19s 20 3 4m10s 1m23s 21 3 3m48s 1m16s 22 3 3m56s 1m18s [ User: intelifix - Total duration: 1h4m24s - Times executed: 48 ]
[ Application: psql - Total duration: 1h4m24s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-15 11:15:34 Duration: 3m39s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-15 12:15:22 Duration: 3m36s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-15 09:15:20 Duration: 3m33s Database: brasilia User: intelifix Remote: [local] Application: psql
5 4s324ms 1m2s 33s566ms 4 2m14s 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 Oct 15 20 2 1m6s 33s490ms 23 2 1m7s 33s641ms [ User: intelifix - Total duration: 2m14s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m14s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-15 23:16:43 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-15 20:08:40 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-15 20:10:40 Duration: 4s444ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 352ms 53s650ms 26s911ms 4 1m47s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 15 20 2 53s638ms 26s819ms 23 2 54s6ms 27s3ms [ User: intelifix - Total duration: 1m47s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m47s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-15 23:13:46 Duration: 53s650ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-15 20:05:44 Duration: 53s285ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-15 23:33:24 Duration: 355ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 3s327ms 40s506ms 18s135ms 6 1m48s copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 15 20 3 54s471ms 18s157ms 23 3 54s338ms 18s112ms [ User: intelifix - Total duration: 1m48s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m48s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-15 20:06:27 Duration: 40s506ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-15 23:14:29 Duration: 40s360ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-15 20:10:16 Duration: 10s638ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 2s325ms 31s887ms 13s983ms 6 1m23s copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 15 20 3 42s81ms 14s27ms 23 3 41s819ms 13s939ms [ User: intelifix - Total duration: 1m23s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m23s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-15 20:07:01 Duration: 31s887ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-15 23:15:03 Duration: 31s775ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-15 20:10:24 Duration: 7s868ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
9 2s972ms 31s933ms 13s807ms 6 1m22s copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 15 20 3 41s568ms 13s856ms 23 3 41s279ms 13s759ms [ User: intelifix - Total duration: 1m22s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m22s - Times executed: 6 ]
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-15 20:09:13 Duration: 31s933ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-15 23:17:15 Duration: 31s825ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-15 20:10:47 Duration: 6s600ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 2s551ms 24s32ms 12s33ms 6 1m12s copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 15 20 3 35s864ms 11s954ms 23 3 36s334ms 12s111ms [ User: intelifix - Total duration: 1m12s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m12s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-15 23:10:48 Duration: 24s32ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-15 20:02:47 Duration: 23s503ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-15 20:09:33 Duration: 9s797ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 2s241ms 24s208ms 11s888ms 6 1m11s copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 15 20 3 35s638ms 11s879ms 23 3 35s691ms 11s897ms [ User: intelifix - Total duration: 1m11s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m11s - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-15 23:11:30 Duration: 24s208ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-15 20:03:28 Duration: 24s201ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-15 23:33:04 Duration: 9s208ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 1s723ms 25s330ms 10s743ms 6 1m4s copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 15 20 3 31s953ms 10s651ms 23 3 32s507ms 10s835ms [ User: intelifix - Total duration: 1m4s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m4s - Times executed: 6 ]
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-10-15 23:12:29 Duration: 25s330ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-10-15 20:04:27 Duration: 25s183ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-10-15 23:33:19 Duration: 5s359ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 388ms 14s630ms 4s141ms 15 1m2s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 15 10 1 1s948ms 1s948ms 11 6 9s974ms 1s662ms 13 2 16s312ms 8s156ms 14 3 24s168ms 8s56ms 15 1 388ms 388ms 16 2 9s332ms 4s666ms [ User: intelifix - Total duration: 1m2s - Times executed: 15 ]
[ Application: [unknown] - Total duration: 1m2s - Times executed: 15 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (059277) LIMIT 1;
Date: 2026-10-15 14:00:59 Duration: 14s630ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (059276) LIMIT 1;
Date: 2026-10-15 13:32:31 Duration: 11s612ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (059276) LIMIT 1;
Date: 2026-10-15 16:20:29 Duration: 7s370ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
14 174ms 53s479ms 3s789ms 60 3m47s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 15 08 8 41s68ms 5s133ms 09 3 7s478ms 2s492ms 10 7 19s415ms 2s773ms 11 9 10s545ms 1s171ms 12 1 303ms 303ms 13 6 14s616ms 2s436ms 14 7 36s812ms 5s258ms 15 1 373ms 373ms 16 5 22s838ms 4s567ms 17 10 1m9s 6s980ms 18 3 4s100ms 1s366ms [ User: intelifix - Total duration: 3m47s - Times executed: 60 ]
[ Application: [unknown] - Total duration: 3m47s - Times executed: 60 ]
-
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-10-15 17:06:43 Duration: 53s479ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_seriais_expedidos(7,DATE(''2026-10-01''),DATE(''2026-10-14'')) ;', '/var/www/html/tmp/temp_54.xlsx');
Date: 2026-10-15 08:17:44 Duration: 30s910ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_seriais_expedidos(7,DATE(''2026-10-05''),DATE(''2026-10-15'')) ;', '/var/www/html/tmp/temp_54.xlsx');
Date: 2026-10-15 10:36:34 Duration: 14s14ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
15 1s334ms 16s724ms 3s781ms 18 1m8s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 15 08 2 6s131ms 3s65ms 09 2 6s545ms 3s272ms 10 5 13s878ms 2s775ms 11 1 3s185ms 3s185ms 13 2 6s747ms 3s373ms 14 2 4s781ms 2s390ms 15 1 16s724ms 16s724ms 16 1 5s164ms 5s164ms 17 2 4s904ms 2s452ms [ User: intelifix - Total duration: 1m8s - Times executed: 18 ]
[ Application: [unknown] - Total duration: 1m8s - Times executed: 18 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-13', 0302, '', '', 0, 6, '2026-10-13');
Date: 2026-10-15 15:50:12 Duration: 16s724ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-15', 0404, '', '', 0, 7, '2026-10-01');
Date: 2026-10-15 16:45:21 Duration: 5s164ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-15', 0399, '', '', 0, 7, '2026-10-01');
Date: 2026-10-15 08:19:57 Duration: 3s547ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
16 422ms 9s362ms 3s47ms 8 24s377ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 15 00 4 13s385ms 3s346ms 06 4 10s992ms 2s748ms [ User: lenon - Total duration: 24s377ms - Times executed: 8 ]
[ Application: psql - Total duration: 24s377ms - Times executed: 8 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-10-15 00:02:11 Duration: 9s362ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-10-15 06:02:09 Duration: 7s722ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-10-15 00:02:13 Duration: 1s981ms Database: brasilia User: lenon Remote: [local] Application: psql
17 234ms 12s763ms 1s582ms 275 7m15s call rs_giga_triagem (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 15 00 12 29s288ms 2s440ms 01 12 16s902ms 1s408ms 02 12 17s41ms 1s420ms 03 11 14s756ms 1s341ms 04 12 17s375ms 1s447ms 05 12 17s775ms 1s481ms 06 12 17s532ms 1s461ms 07 12 17s704ms 1s475ms 08 12 18s116ms 1s509ms 09 12 17s862ms 1s488ms 10 12 19s158ms 1s596ms 11 12 20s875ms 1s739ms 12 12 18s248ms 1s520ms 13 12 17s73ms 1s422ms 14 12 17s439ms 1s453ms 15 12 17s836ms 1s486ms 16 12 17s798ms 1s483ms 17 12 18s22ms 1s501ms 18 12 17s25ms 1s418ms 19 12 17s399ms 1s449ms 20 12 35s453ms 2s954ms 21 12 17s31ms 1s419ms 22 12 17s450ms 1s454ms [ User: intelifix - Total duration: 7m15s - Times executed: 275 ]
[ Application: psql - Total duration: 7m15s - Times executed: 275 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-15 00:05:14 Duration: 12s763ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-15 20:15:12 Duration: 10s476ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-15 20:05:12 Duration: 10s453ms Database: rio User: intelifix Remote: [local] Application: psql
18 568ms 22s389ms 1s309ms 53 1m9s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 15 08 3 2s768ms 922ms 09 3 5s202ms 1s734ms 10 4 5s150ms 1s287ms 11 3 2s444ms 814ms 12 4 3s85ms 771ms 13 4 3s401ms 850ms 14 5 4s22ms 804ms 15 3 2s515ms 838ms 16 3 2s415ms 805ms 17 3 3s279ms 1s93ms 18 5 25s258ms 5s51ms 19 3 2s485ms 828ms 20 3 2s186ms 728ms 21 4 3s219ms 804ms 22 3 1s988ms 662ms [ User: intelifix - Total duration: 1m9s - Times executed: 53 ]
[ Application: psql - Total duration: 1m9s - Times executed: 53 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-15 18:00:24 Duration: 22s389ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-15 09:40:06 Duration: 3s599ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-15 10:40:05 Duration: 3s29ms Database: brasilia User: intelifix Remote: [local] Application: psql
19 166ms 3s299ms 1s208ms 45 54s366ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 15 00 1 313ms 313ms 07 5 7s364ms 1s472ms 08 6 5s790ms 965ms 09 6 11s640ms 1s940ms 10 6 10s208ms 1s701ms 11 5 4s791ms 958ms 12 5 6s640ms 1s328ms 13 6 5s938ms 989ms 14 2 849ms 424ms 16 1 166ms 166ms 18 1 308ms 308ms 20 1 354ms 354ms [ User: intelifix - Total duration: 54s366ms - Times executed: 45 ]
[ Application: psql - Total duration: 54s366ms - Times executed: 45 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-15 09:25:07 Duration: 3s299ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-15 09:05:07 Duration: 2s676ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-15 12:05:06 Duration: 2s623ms Database: brasilia User: intelifix Remote: [local] Application: psql
20 583ms 2s127ms 887ms 35 31s69ms call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 15 08 3 3s315ms 1s105ms 09 2 1s635ms 817ms 10 1 877ms 877ms 11 3 2s418ms 806ms 12 2 1s915ms 957ms 13 2 1s453ms 726ms 14 1 862ms 862ms 15 3 2s456ms 818ms 16 3 2s181ms 727ms 17 3 3s442ms 1s147ms 18 1 726ms 726ms 19 3 2s296ms 765ms 20 3 3s303ms 1s101ms 21 2 1s550ms 775ms 22 3 2s632ms 877ms [ User: intelifix - Total duration: 31s69ms - Times executed: 35 ]
[ Application: psql - Total duration: 31s69ms - Times executed: 35 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-15 20:20:03 Duration: 2s127ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-15 17:20:03 Duration: 2s26ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-15 08:00:03 Duration: 1s714ms Database: rio User: intelifix Remote: [local] Application: psql
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 5 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Oct 15 10 1 0ms 0ms 12 1 0ms 0ms 14 1 0ms 0ms 19 1 0ms 0ms 22 1 0ms 0ms [ User: intelifix - Total duration: 1s479ms - Times executed: 4 ]
[ User: lenon - Total duration: 315ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 1s68ms - Times executed: 3 ]
[ Application: psql - Total duration: 726ms - Times executed: 2 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 8,564 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 23 FATAL entries
- 2165 ERROR entries
- 0 WARNING entries
- 1 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 2,154 Max number of times the same event was reported
- 2,189 Total events found
Rank Times reported Error 1 2,154 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Oct 15 00 58 01 58 02 51 03 53 04 57 05 54 06 58 07 60 08 146 09 195 10 219 11 187 12 77 13 111 14 142 15 100 16 116 17 81 18 57 19 57 20 57 21 56 22 56 23 48 - ERROR: prepared statement "_PLAN000000003D4C2720" does not exist
- ERROR: prepared statement "_PLAN000000003D4BC2C0" does not exist
- ERROR: prepared statement "_PLAN000000003D4C9010" does not exist
Statement: DEALLOCATE "_PLAN000000003D4C2720"
Date: 2026-10-15 00:00:26 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN000000003D4BC2C0"
Date: 2026-10-15 00:01:28 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN000000003D4C9010"
Date: 2026-10-15 00:02:29 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
2 12 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Oct 15 00 1 01 1 02 1 11 2 12 1 13 1 16 1 17 1 18 1 19 1 20 1 - FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-10-15 00:42:33 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-15 01:53:58 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-15 02:27:12 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
3 8 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #3
Day Hour Count Oct 15 03 8 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-10-15 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-10-15 03:05:01 Database: testes Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-15 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
4 4 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Oct 15 10 4 - ERROR: syntax error at or near "821118917000371" at character 32
- ERROR: syntax error at or near "821118917000371" at character 80
- ERROR: syntax error at or near "821118917000371" at character 47
Statement: SELECT RS_SERIAL_TEMPORARIO( ''821118917000371' ) OR RS_SERIAL_TEMPORARIO_VIVO( ''821118917000371' )
Date: 2026-10-15 10:58:06 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_LOTE_CONSISTE_SERIAL( '{"lote":"62036","seriais":[{"serial":"'821118917000371"},{"serial":"229858972847"}]}')
Date: 2026-10-15 10:58:08 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_PRE_ALERTA_TELA('{"barra1":"'821118917000371","barra2":"229858972847","barra3":"246649131527","lote":"62036"}');
Date: 2026-10-15 10:58:08 Database: contagem Application: [unknown] User: intelifix Remote: [local]
5 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Oct 15 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-10-15 05:32:11 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-15 05:32:11 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-15 05:32:11 Database: contagem Application: psql User: intelifix Remote: [local]
6 3 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #6
Day Hour Count Oct 15 03 3 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-10-15 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-15 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-15 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
7 1 ERROR: prepared statement "..." does not existNOTICE: table "..." does not exist, skipping
Times Reported Most Frequent Error / Event #7
Day Hour Count Oct 15 17 1 - ERROR: prepared statement "_PLAN000000003D4C5030" does not existNOTICE: table "tmp_entrada" does not exist, skipping
Statement: DEALLOCATE "_PLAN000000003D4C5030"
Date: 2026-10-15 17:07:48 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
8 1 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #8
Day Hour Count Oct 15 17 1 - ERROR: column "pas_id" does not exist at character 66 2026-10-15 17:47:31 -03 [3157470]: [35-1] user=intelifix,db=brasilia,app=[unknown],client=[local] QUERY: SELECT * FROM PARTE_MOVIMENTOS WHERE PM_ID = ANY( aPMs ) AND PAS_ID = nPasso
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 87 at assignment
Hint: Perhaps you meant to reference the column "parte_movimentos.ps_id".
Statement: SELECT * FROM RS_LOTE_SAIDA_EXCLUI(0140786);Date: 2026-10-15 17:47:31 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
9 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #9
Day Hour Count Oct 15 03 1 - LOG: database system was shut down at 2026-10-15 03:05:01 -03
Date: 2026-10-15 03:05:02
10 1 ERROR: prepared statement "..." does not exist/usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn(
Times Reported Most Frequent Error / Event #10
Day Hour Count Oct 15 14 1 - ERROR: prepared statement "_PLAN000000003D4C9930" does not exist/usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn(
Statement: DEALLOCATE "_PLAN000000003D4C9930"
Date: 2026-10-15 14:40:03 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]