pgBadger-
Global information
- Generated on Sun Aug 16 23:50:16 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 12,646 log entries in 14s
- Log start from 2026-08-16 00:00:23 to 2026-08-16 23:49:58
-
Overview
Global Stats
- 157 Number of unique normalized queries
- 1,045 Number of queries
- 4h33m23s Total query duration
- 2026-08-16 00:02:12 First query
- 2026-08-16 23:44:09 Last query
- 4 queries/s at 2026-08-16 23:44:03 Query peak
- 4h33m23s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 4h33m23s Execute total duration
- 2,288 Number of events
- 8 Number of unique normalized events
- 2,223 Max number of times the same event was reported
- 0 Number of cancellation
- 9 Total number of automatic vacuums
- 3 Total number of automatic analyzes
- 10 Number temporary file
- 240.82 MiB Max size of temporary file
- 111.95 MiB Average size of temporary file
- 267 Total number of sessions
- 7 sessions at 2026-08-16 14:05:07 Session peak
- 8d8m20s Total duration of sessions
- 43m10s Average duration of sessions
- 3 Average queries per session
- 1m1s Average queries duration per session
- 42m9s Average idle time per session
- 272 Total number of connections
- 7 connections/s at 2026-08-16 03:05:17 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 4 queries/s Query Peak
- 2026-08-16 23:44:03 Date
SELECT Traffic
Key values
- 3 queries/s Query Peak
- 2026-08-16 20:02:03 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-08-16 23:44:03 Date
Queries duration
Key values
- 4h33m23s 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) Aug 16 00 21 0ms 22s882ms 6s448ms 5s414ms 17s18ms 1m10s 01 12 0ms 6s106ms 2s864ms 5s318ms 5s736ms 6s504ms 02 12 0ms 6s99ms 2s859ms 5s158ms 5s678ms 6s715ms 03 15 0ms 6s852ms 2s642ms 5s615ms 6s212ms 9s6ms 04 12 0ms 5s955ms 2s764ms 4s750ms 5s494ms 6s600ms 05 17 0ms 11m59s 1m35s 6s547ms 3m29s 11m59s 06 18 0ms 13s277ms 4s482ms 4s782ms 7s21ms 34s712ms 07 18 0ms 14m23s 1m15s 5s620ms 2m12s 14m23s 08 24 0ms 5m38s 25s947ms 6s224ms 46s862ms 5m38s 09 24 0ms 5m38s 25s995ms 6s297ms 48s892ms 5m38s 10 55 0ms 5m33s 12s450ms 7s310ms 50s98ms 5m33s 11 42 0ms 6m 16s53ms 6s433ms 7s477ms 6m49s 12 24 0ms 5m47s 26s586ms 7s90ms 49s313ms 5m47s 13 41 0ms 5m42s 15s697ms 7s632ms 46s923ms 5m42s 14 43 0ms 5m56s 15s834ms 6s142ms 50s387ms 6m 15 33 0ms 5m41s 19s243ms 6s408ms 44s927ms 5m41s 16 24 0ms 5m54s 26s951ms 6s574ms 51s76ms 5m54s 17 24 0ms 5m51s 27s105ms 6s196ms 50s801ms 5m51s 18 27 0ms 5m50s 24s124ms 6s596ms 49s810ms 5m50s 19 24 0ms 5m56s 27s185ms 6s743ms 49s321ms 5m56s 20 127 0ms 9m8s 13s12ms 1m9s 2m23s 9m9s 21 26 0ms 9m2s 33s66ms 6s385ms 6s984ms 9m57s 22 24 0ms 6m15s 29s921ms 6s240ms 16s472ms 6m50s 23 358 0ms 1m23s 5s681ms 1m6s 1m11s 1m23s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 16 00 3 0 5s672ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 1 0 181ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 3 0 5s745ms 0ms 0ms 0ms 07 6 0 3m40s 0ms 0ms 4m20s 08 6 0 1m35s 0ms 0ms 3m5s 09 6 0 1m35s 0ms 0ms 3m4s 10 33 0 17s702ms 1s119ms 1s507ms 3m3s 11 21 0 29s329ms 231ms 808ms 3m17s 12 6 0 1m37s 0ms 0ms 3m7s 13 19 0 31s28ms 357ms 1s480ms 3m7s 14 21 0 29s964ms 1s279ms 3s248ms 3m12s 15 13 0 44s915ms 0ms 1s513ms 3m9s 16 6 0 1m38s 0ms 0ms 3m6s 17 6 0 1m39s 0ms 0ms 3m14s 18 9 0 1m6s 0ms 0ms 3m12s 19 6 0 1m39s 0ms 0ms 3m11s 20 24 83 14s784ms 41s768ms 1m9s 4m21s 21 7 0 1m55s 0ms 0ms 3m28s 22 6 0 1m50s 0ms 0ms 3m58s 23 32 326 5s681ms 1m2s 1m6s 1m23s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 16 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 Aug 16 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 1 1.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 3 3.00 0.00% 11 0 3 3.00 0.00% 12 0 0 0.00 0.00% 13 0 1 1.00 0.00% 14 0 1 1.00 0.00% 15 0 1 1.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 1 1.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 4 4.00 0.00% Day Hour Count Average / Second Aug 16 00 16 0.00/s 01 8 0.00/s 02 10 0.00/s 03 20 0.01/s 04 12 0.00/s 05 11 0.00/s 06 17 0.00/s 07 9 0.00/s 08 11 0.00/s 09 10 0.00/s 10 13 0.00/s 11 12 0.00/s 12 10 0.00/s 13 12 0.00/s 14 10 0.00/s 15 13 0.00/s 16 8 0.00/s 17 11 0.00/s 18 8 0.00/s 19 9 0.00/s 20 14 0.00/s 21 12 0.00/s 22 8 0.00/s 23 8 0.00/s Day Hour Count Average Duration Average idle time Aug 16 00 2 30m25s 29m18s 01 15 57m34s 57m32s 02 10 46m33s 46m30s 03 20 18m41s 18m39s 04 10 43m55s 43m51s 05 11 44m52s 42m24s 06 11 44m40s 44m32s 07 14 54m58s 53m21s 08 11 44m29s 43m32s 09 10 44m24s 43m22s 10 11 34m57s 33m55s 11 11 44m38s 43m37s 12 14 43m55s 43m10s 13 8 41m41s 40m21s 14 13 49m30s 48m38s 15 11 37m49s 36m51s 16 9 57m7s 55m56s 17 12 43m48s 42m54s 18 8 52m9s 50m47s 19 8 50m58s 49m37s 20 14 36m26s 34m28s 21 13 37m59s 36m53s 22 7 52m24s 50m42s 23 14 36m56s 34m31s -
Connections
Established Connections
Key values
- 7 connections Connection Peak
- 2026-08-16 03:05:17 Date
Connections per database
Key values
- rio Main Database
- 272 connections Total
Connections per user
Key values
- intelifix Main User
- 272 connections Total
-
Sessions
Simultaneous sessions
Key values
- 7 sessions Session Peak
- 2026-08-16 14:05:07 Date
Histogram of session times
Key values
- 156 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 267 sessions Total
Sessions per user
Key values
- intelifix Main User
- 267 sessions Total
Sessions per host
Key values
- [local] Main Host
- 267 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 23,456 buffers Checkpoint Peak
- 2026-08-16 03:05:03 Date
- 269.265 seconds Highest write time
- 0.097 seconds Sync time
Checkpoints Wal files
Key values
- 4 files Wal files usage Peak
- 2026-08-16 03:05:03 Date
Checkpoints distance
Key values
- 139.42 Mo Distance Peak
- 2026-08-16 03:05:03 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Aug 16 00 6,401 269.265s 0.016s 269.295s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 23,456 1.071s 0.026s 1.151s 04 0 0s 0s 0s 05 7,626 764.565s 0.14s 764.801s 06 2,688 268.738s 0.004s 268.755s 07 1,084 108.414s 0.005s 108.426s 08 40 4.034s 0.003s 4.043s 09 23 2.329s 0.005s 2.341s 10 1,351 136.006s 0.142s 136.21s 11 1,904 191.316s 0.131s 191.515s 12 443 44.609s 0.026s 44.664s 13 1,080 108.916s 0.167s 109.138s 14 3,605 361.839s 0.274s 362.194s 15 869 87.285s 0.018s 87.324s 16 23 2.33s 0.006s 2.343s 17 24 2.434s 0.005s 2.446s 18 1,344 134.982s 0.081s 135.097s 19 23 2.345s 0.011s 2.379s 20 141 14.222s 0.031s 14.285s 21 50 5.064s 0.043s 5.122s 22 24 2.432s 0.025s 2.465s 23 50 5.044s 0.007s 5.099s Day Hour Added Removed Recycled Synced files Longest sync Average sync Aug 16 00 0 0 2 29 0.007s 0.001s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 4 31 0.016s 0.003s 04 0 0 0 0 0s 0s 05 0 0 3 155 0.064s 0.013s 06 0 0 1 9 0.001s 0.001s 07 0 0 0 13 0.003s 0.001s 08 0 0 0 3 0.002s 0.001s 09 0 0 0 3 0.003s 0.002s 10 0 0 1 572 0.058s 0.011s 11 0 0 0 531 0.031s 0.007s 12 0 0 0 179 0.009s 0.004s 13 0 0 0 326 0.064s 0.012s 14 0 0 1 617 0.062s 0.014s 15 0 0 1 166 0.003s 0.003s 16 0 0 0 3 0.004s 0.002s 17 0 0 0 3 0.003s 0.002s 18 0 0 0 79 0.062s 0.034s 19 0 0 0 3 0.009s 0.004s 20 0 0 0 22 0.017s 0.007s 21 0 0 0 14 0.029s 0.013s 22 0 0 0 3 0.022s 0.009s 23 0 0 0 5 0.004s 0.004s Day Hour Count Avg time (sec) Aug 16 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 Aug 16 00 32,062.00 kB 32,062.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 35,692.00 kB 35,692.00 kB 04 0.00 kB 0.00 kB 05 6,496.50 kB 9,986.38 kB 06 7,357.00 kB 9,852.00 kB 07 5,495.00 kB 9,416.00 kB 08 347.00 kB 8,509.00 kB 09 187.00 kB 7,677.00 kB 10 662.67 kB 4,940.33 kB 11 1,377.71 kB 3,274.57 kB 12 500.25 kB 2,521.75 kB 13 643.71 kB 1,750.00 kB 14 1,453.55 kB 2,630.55 kB 15 1,310.67 kB 2,424.67 kB 16 187.00 kB 2,059.00 kB 17 188.00 kB 1,872.00 kB 18 1,051.25 kB 3,276.50 kB 19 187.00 kB 2,546.00 kB 20 227.25 kB 2,023.00 kB 21 134.50 kB 1,515.50 kB 22 187.00 kB 1,315.00 kB 23 43.00 kB 1,129.50 kB -
Temporary Files
Size of temporary files
Key values
- 481.64 MiB Temp Files size Peak
- 2026-08-16 05:32:10 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-08-16 05:32:10 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Aug 16 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 10 1.09 GiB 111.95 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 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 8 935.74 MiB 71.83 MiB 240.82 MiB 116.97 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-16 05:32:18 Duration: 1m32s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-16 05:32:10 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 2 183.78 MiB 91.89 MiB 91.89 MiB 91.89 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-16 05:30:45 Duration: 43s119ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-16 05:30:42 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 240.82 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-16 05:32:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 240.82 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-16 05:32:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 91.89 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-16 05:30:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 91.89 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-16 05:30:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 79.57 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-16 05:32:17 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 79.48 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-16 05:32:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 79.48 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-16 05:32:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 71.91 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-16 05:32:18 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 71.83 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-16 05:32:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 71.83 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-16 05:32:17 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 4.14 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_08
Database contagem - 2026-08-16 00:07:07 Date
- 0 sec Highest CPU-cost analyze
Table
Database contagem - Date
Average Autovacuum Duration
Key values
- 4.14 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_08
Database contagem - 2026-08-16 00:07:07 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (1) Main table analyzed (database rio)
- 3 analyzes Total
Vacuums per table
Key values
- pg_toast.pg_toast_2619 (1) Main table vacuumed on database brasilia
- 9 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples brasilia.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 195 63 292,863 32 84 rio.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 894 188 1,190,335 131 408 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 132 4 10,656 0 0 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,111 3 150,414 0 0 rio.public.temp0000288558 1 0 0 0 0 0 0 92 91 180,474 0 0 rio.public.temp0000288556 1 0 0 0 0 0 0 92 6 6,350 0 0 contagem.auditor.auditor_2026_08 1 0 0 0 0 0 0 14,134 13,377 16,518,479 0 0 brasilia.pg_catalog.pg_statistic 1 1 0 0 0 0 0 3,067 1,044 3,988,613 1,007 7,013 rio.pg_catalog.pg_statistic 1 1 0 0 0 0 0 3,405 669 3,026,042 626 3,992 Total 9 6 0 0 0 0 0 24,122 15,445 25,364,226 1,796 11,497 Vacuum throughput per table
Key values
- auditor.auditor_2026_08 (4.14) 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 brasilia.pg_toast.pg_toast_2619 0 0 0.03 rio.pg_toast.pg_toast_2619 0 0 0.12 contagem.pg_toast.pg_toast_2619 0 0 0.01 contagem.pg_catalog.pg_statistic 0 0 0.04 rio.public.temp0000288558 0 0 0.04 rio.public.temp0000288556 0 0 0.02 contagem.auditor.auditor_2026_08 0 0 4.14 brasilia.pg_catalog.pg_statistic 0 0 0.29 rio.pg_catalog.pg_statistic 0 0 0.32 Total 0 0 5.01 Tuples removed per table
Key values
- pg_catalog.pg_statistic (4534) Main table with removed tuples on database contagem
- 13648 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain contagem.pg_catalog.pg_statistic 1 1 4,534 7,274 0 0 1,011 rio.pg_catalog.pg_statistic 1 1 4,468 7,472 0 0 1,286 brasilia.pg_catalog.pg_statistic 1 1 3,810 7,346 0 0 1,072 rio.pg_toast.pg_toast_2619 1 1 609 678 0 27 260 brasilia.pg_toast.pg_toast_2619 1 1 119 141 0 8 60 contagem.pg_toast.pg_toast_2619 1 1 108 111 0 11 51 rio.public.temp0000288558 1 0 0 1,579 0 44 84 rio.public.temp0000288556 1 0 0 1,579 0 44 84 contagem.auditor.auditor_2026_08 1 0 0 2,036,241 0 0 92,750 Total 9 6 13,648 2,062,421 0 134 96,658 Pages removed per table
Key values
- public.temp0000288558 (44) Main table with removed pages on database rio
- 134 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000288558 1 0 0 44 rio.public.temp0000288556 1 0 0 44 rio.pg_toast.pg_toast_2619 1 1 609 27 contagem.pg_toast.pg_toast_2619 1 1 108 11 brasilia.pg_toast.pg_toast_2619 1 1 119 8 contagem.pg_catalog.pg_statistic 1 1 4534 0 contagem.auditor.auditor_2026_08 1 0 0 0 brasilia.pg_catalog.pg_statistic 1 1 3810 0 rio.pg_catalog.pg_statistic 1 1 4468 0 Total 9 6 13,648 134 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Aug 16 00 1 0 01 0 0 02 0 0 03 0 0 04 0 0 05 6 0 06 0 0 07 0 0 08 0 0 09 0 0 10 1 1 11 1 1 12 0 0 13 0 1 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 - 4.14 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
- 234 Total read queries
- 426 Total write queries
Queries by database
Key values
- rio Main database
- 492 Requests
- 3h3m52s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 2,047 Requests
User Request type Count Duration etiquetas Total 18 8s738ms select 18 8s738ms intelifix Total 2,047 9h19m35s copy to 811 1h34m57s ddl 20 1m46s others 805 1h31m40s select 411 6h11m10s lenon Total 33 1m16s select 33 1m16s Duration by user
Key values
- 9h19m35s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 18 8s738ms select 18 8s738ms intelifix Total 2,047 9h19m35s copy to 811 1h34m57s ddl 20 1m46s others 805 1h31m40s select 411 6h11m10s lenon Total 33 1m16s select 33 1m16s Queries by host
Key values
- [local] Main host
- 2,098 Requests
- 9h21m1s ([local])
- Main time consuming host
Queries by application
Key values
- psql Main application
- 491 Requests
- 3h47m29s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-08-16 09:35:01 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 455 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 14m23s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-16 07:19:24 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 11m59s analyze verbose;[ Date: 2026-08-16 05:12:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 9m8s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-16 20:14:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 9m2s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-16 21:14:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 8m45s analyze verbose;[ Date: 2026-08-16 05:20:45 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
6 6m15s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-16 22:11:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 6m SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-16 11:11:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 5m56s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-16 14:10:58 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 5m56s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-16 19:10:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 5m54s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-16 16:10:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 5m51s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-16 17:10:53 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m50s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-16 18:10:51 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 5m47s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-16 12:10:49 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m42s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-16 13:10:44 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m41s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-16 15:10:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m38s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-16 08:10:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m38s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-16 09:10:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 5m33s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-16 10:10:35 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 4m20s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-08-16 07:26:54 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
20 4m12s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-08-16 20:21:30 - 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 1h54m28s 48 1s276ms 14m23s 2m23s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 16 07 3 15m27s 5m9s 08 3 5m55s 1m58s 09 3 5m55s 1m58s 10 3 5m52s 1m57s 11 3 6m18s 2m6s 12 3 6m5s 2m1s 13 3 5m59s 1m59s 14 3 6m14s 2m4s 15 3 5m58s 1m59s 16 3 6m11s 2m3s 17 3 6m10s 2m3s 18 3 6m8s 2m2s 19 3 6m15s 2m5s 20 3 9m59s 3m19s 21 3 9m21s 3m7s 22 3 6m33s 2m11s [ User: intelifix - Total duration: 1h54m28s - Times executed: 48 ]
[ Application: psql - Total duration: 1h54m28s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-16 07:19:24 Duration: 14m23s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-16 20:14:10 Duration: 9m8s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-16 21:14:04 Duration: 9m2s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
2 1h5m58s 48 193ms 4m20s 1m22s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 16 07 3 6m36s 2m12s 08 3 3m35s 1m11s 09 3 3m36s 1m12s 10 3 3m33s 1m11s 11 3 3m49s 1m16s 12 3 3m38s 1m12s 13 3 3m37s 1m12s 14 3 3m44s 1m14s 15 3 3m37s 1m12s 16 3 3m40s 1m13s 17 3 3m48s 1m16s 18 3 3m44s 1m14s 19 3 3m41s 1m13s 20 3 6m39s 2m13s 21 3 4m4s 1m21s 22 3 4m31s 1m30s [ User: intelifix - Total duration: 1h5m58s - Times executed: 48 ]
[ Application: psql - Total duration: 1h5m58s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-16 07:26:54 Duration: 4m20s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-16 20:21:30 Duration: 4m12s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-16 22:16:04 Duration: 3m55s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
3 24m13s 3 3m29s 11m59s 8m4s analyze verbose;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 16 05 3 24m13s 8m4s [ User: intelifix - Total duration: 24m13s - Times executed: 3 ]
[ Application: psql - Total duration: 24m13s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-16 05:12:00 Duration: 11m59s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
analyze verbose;
Date: 2026-08-16 05:20:45 Duration: 8m45s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
analyze verbose;
Date: 2026-08-16 05:24:15 Duration: 3m29s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
4 13m13s 277 156ms 22s882ms 2s864ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 16 00 12 54s411ms 4s534ms 01 12 34s368ms 2s864ms 02 12 34s317ms 2s859ms 03 13 38s393ms 2s953ms 04 12 33s177ms 2s764ms 05 12 32s459ms 2s704ms 06 12 34s4ms 2s833ms 07 12 30s527ms 2s543ms 08 12 31s140ms 2s595ms 09 12 31s163ms 2s596ms 10 12 30s280ms 2s523ms 11 12 33s955ms 2s829ms 12 12 31s200ms 2s600ms 13 12 32s588ms 2s715ms 14 12 31s817ms 2s651ms 15 12 31s307ms 2s608ms 16 12 34s266ms 2s855ms 17 12 32s364ms 2s697ms 18 12 35s536ms 2s961ms 19 12 34s366ms 2s863ms 20 12 44s925ms 3s743ms 21 12 33s126ms 2s760ms 22 12 33s683ms 2s806ms [ User: intelifix - Total duration: 13m13s - Times executed: 277 ]
[ Application: psql - Total duration: 13m13s - Times executed: 277 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-16 00:05:24 Duration: 22s882ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-16 20:15:17 Duration: 14s909ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-16 19:35:08 Duration: 6s967ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
5 3m7s 4 4s389ms 1m34s 46s928ms 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 Aug 16 20 2 1m39s 49s784ms 23 2 1m28s 44s72ms [ User: intelifix - Total duration: 3m7s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m7s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-16 20:09:15 Duration: 1m34s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-16 23:16:39 Duration: 1m23s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-16 20:11:12 Duration: 4s988ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
6 3m7s 55 2s815ms 8s117ms 3s411ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 16 08 3 9s325ms 3s108ms 09 5 16s807ms 3s361ms 10 6 19s593ms 3s265ms 11 3 9s903ms 3s301ms 12 3 10s181ms 3s393ms 13 4 13s88ms 3s272ms 14 3 9s381ms 3s127ms 15 4 12s906ms 3s226ms 16 3 10s380ms 3s460ms 17 4 12s993ms 3s248ms 18 3 10s173ms 3s391ms 19 4 14s687ms 3s671ms 20 4 18s609ms 4s652ms 21 3 10s211ms 3s403ms 22 3 9s394ms 3s131ms [ User: intelifix - Total duration: 3m7s - Times executed: 55 ]
[ Application: psql - Total duration: 3m7s - Times executed: 55 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-16 20:00:12 Duration: 8s117ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-16 19:20:06 Duration: 5s118ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-16 10:00:04 Duration: 3s820ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
7 2m2s 4 479ms 1m3s 30s667ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 16 20 2 58s726ms 29s363ms 23 2 1m3s 31s972ms [ User: intelifix - Total duration: 2m2s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m2s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-16 23:13:34 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-16 20:05:45 Duration: 58s246ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-16 23:34:07 Duration: 551ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
8 1m59s 35 2s865ms 4s622ms 3s409ms 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 #8
Day Hour Count Duration Avg duration Aug 16 08 3 11s245ms 3s748ms 09 1 3s756ms 3s756ms 11 3 9s755ms 3s251ms 12 3 12s283ms 4s94ms 13 2 7s484ms 3s742ms 14 3 9s496ms 3s165ms 15 2 6s508ms 3s254ms 16 3 10s176ms 3s392ms 17 2 6s194ms 3s97ms 18 3 9s190ms 3s63ms 19 2 6s503ms 3s251ms 20 2 6s865ms 3s432ms 21 3 9s713ms 3s237ms 22 3 10s151ms 3s383ms [ User: intelifix - Total duration: 1m59s - Times executed: 35 ]
[ Application: psql - Total duration: 1m59s - 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-08-16 12:40:05 Duration: 4s622ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
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-08-16 08:00:06 Duration: 4s437ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
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-08-16 13:20:06 Duration: 4s402ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
9 1m34s 6 3s584ms 36s2ms 15s801ms 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 #9
Day Hour Count Duration Avg duration Aug 16 20 3 48s389ms 16s129ms 23 3 46s422ms 15s474ms [ User: intelifix - Total duration: 1m34s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m34s - 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-08-16 20:06:24 Duration: 36s2ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
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-08-16 23:14:10 Duration: 33s847ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
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-08-16 23:34:17 Duration: 8s990ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
10 1m32s 1 1m32s 1m32s 1m32s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 16 05 1 1m32s 1m32s [ User: intelifix - Total duration: 1m32s - Times executed: 1 ]
[ Application: psql - Total duration: 1m32s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-16 05:32:18 Duration: 1m32s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-16 05:32:10 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
11 1m32s 6 8s711ms 22s852ms 15s445ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 16 00 3 1m3s 21s76ms 06 3 29s440ms 9s813ms [ User: intelifix - Total duration: 1m32s - Times executed: 6 ]
[ Application: psql - Total duration: 1m32s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-16 00:05:24 Duration: 22s852ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-16 00:06:04 Duration: 21s34ms Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-16 00:05:43 Duration: 19s343ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
12 1m14s 6 1s919ms 30s440ms 12s438ms 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 Aug 16 20 3 39s161ms 13s53ms 23 3 35s467ms 11s822ms [ User: intelifix - Total duration: 1m14s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m14s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-16 20:06:58 Duration: 30s440ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-16 23:14:41 Duration: 26s854ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-16 23:34:24 Duration: 6s693ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
13 1m13s 6 2s715ms 27s514ms 12s270ms 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 Aug 16 20 3 37s919ms 12s639ms 23 3 35s704ms 11s901ms [ User: intelifix - Total duration: 1m13s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m13s - 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-08-16 23:17:06 Duration: 27s514ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
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-08-16 20:09:43 Duration: 27s265ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
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-08-16 20:11:19 Duration: 6s769ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
14 1m6s 54 195ms 4s243ms 1s231ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 16 10 19 14s668ms 772ms 11 8 4s49ms 506ms 13 9 10s675ms 1s186ms 14 13 29s860ms 2s296ms 15 5 7s223ms 1s444ms [ User: intelifix - Total duration: 1m6s - Times executed: 54 ]
[ Application: [unknown] - Total duration: 1m6s - Times executed: 54 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (277752, 317, '71428685850006808208,216351046884,216724847394,216519563948,216355472244,216520717180,216559002646,216406608793,216875462038,216837679102,216560051727,216545911234,216700779703,216508266369,216516061317,216519302026,216553470120,216700611427,216405601637,216637331828,216518727794,216874336282,216345937687,216516625670,216513848193,216394236576,216639679408,216542806272', '',062,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-16 14:54:22 Duration: 4s243ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (277751, 317, '254272117427790,216366789093,216842115573,216768470418,216449303556,216853300515,216853304454,216642360512,216440163034,216757693855,216666753644,216772199008,216417093858,216673737187,216687349111,216416845270,216566998195,216840227184,216536729898,216933069297,216882460106,216757467289,216729781625,216604398590,216645129704,216769963739,216645529697,216444100613', '',064,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-16 14:37:06 Duration: 4s82ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (277769, 317, '835099915003544,241667618704,241694185258,241646425569,241646486686,241713845976,241628248396,241630904952,241616730315,241595331122,241732476178,241732490827,241616730214,241638215475,241659516274,241677207787,241671402934,241727546370,241731196367', '',0320,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-16 13:55:28 Duration: 3s506ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-16.log
15 1m2s 6 1s731ms 26s906ms 10s478ms 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 #15
Day Hour Count Duration Avg duration Aug 16 20 3 33s206ms 11s68ms 23 3 29s664ms 9s888ms [ User: intelifix - Total duration: 1m2s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m2s - 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-08-16 20:04:25 Duration: 26s906ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
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-08-16 23:12:08 Duration: 22s695ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
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-08-16 23:34:03 Duration: 5s203ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
16 1m 6 1s854ms 22s245ms 10s164ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 16 20 3 31s663ms 10s554ms 23 3 29s322ms 9s774ms [ User: intelifix - Total duration: 1m - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-16 20:03:25 Duration: 22s245ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-16 23:11:17 Duration: 20s44ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-16 20:10:17 Duration: 7s563ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
17 58s125ms 6 1s991ms 19s233ms 9s687ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 16 20 3 29s877ms 9s959ms 23 3 28s248ms 9s416ms [ User: intelifix - Total duration: 58s125ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 58s125ms - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-16 20:02:48 Duration: 19s233ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-16 23:10:42 Duration: 18s343ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-16 20:10:07 Duration: 8s504ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
18 51s229ms 6 195ms 50s98ms 8s538ms create table temp0000288556 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 16 10 4 50s728ms 12s682ms 11 2 500ms 250ms [ User: intelifix - Total duration: 51s229ms - Times executed: 6 ]
[ Application: [unknown] - Total duration: 51s229ms - Times executed: 6 ]
-
CREATE TABLE temp0000288556 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"11-08-2026", "ate" :"16-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-16 10:19:23 Duration: 50s98ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
CREATE TABLE temp0000288556 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"11-08-2026", "ate" :"16-08-2026", "nota-fiscal":"71326", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-16 11:10:49 Duration: 298ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
CREATE TABLE temp0000288556 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"11-08-2026", "ate" :"16-08-2026", "nota-fiscal":"71326", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-16 10:23:18 Duration: 230ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-16.log
19 51s27ms 4 3s386ms 22s210ms 12s756ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 16 20 2 25s230ms 12s615ms 23 2 25s797ms 12s898ms [ User: intelifix - Total duration: 51s27ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 51s27ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-08-16 23:12:31 Duration: 22s210ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-08-16 20:04:47 Duration: 21s843ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-08-16 23:34:07 Duration: 3s586ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
20 43s533ms 6 1s487ms 14s737ms 7s255ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 16 20 3 22s283ms 7s427ms 23 3 21s250ms 7s83ms [ User: intelifix - Total duration: 43s533ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 43s533ms - Times executed: 6 ]
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-08-16 20:03:40 Duration: 14s737ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-08-16 23:11:31 Duration: 13s328ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-08-16 23:33:54 Duration: 6s434ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 277 13m13s 156ms 22s882ms 2s864ms call rs_giga_triagem (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 16 00 12 54s411ms 4s534ms 01 12 34s368ms 2s864ms 02 12 34s317ms 2s859ms 03 13 38s393ms 2s953ms 04 12 33s177ms 2s764ms 05 12 32s459ms 2s704ms 06 12 34s4ms 2s833ms 07 12 30s527ms 2s543ms 08 12 31s140ms 2s595ms 09 12 31s163ms 2s596ms 10 12 30s280ms 2s523ms 11 12 33s955ms 2s829ms 12 12 31s200ms 2s600ms 13 12 32s588ms 2s715ms 14 12 31s817ms 2s651ms 15 12 31s307ms 2s608ms 16 12 34s266ms 2s855ms 17 12 32s364ms 2s697ms 18 12 35s536ms 2s961ms 19 12 34s366ms 2s863ms 20 12 44s925ms 3s743ms 21 12 33s126ms 2s760ms 22 12 33s683ms 2s806ms [ User: intelifix - Total duration: 13m13s - Times executed: 277 ]
[ Application: psql - Total duration: 13m13s - Times executed: 277 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-16 00:05:24 Duration: 22s882ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-16 20:15:17 Duration: 14s909ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-16 19:35:08 Duration: 6s967ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
2 55 3m7s 2s815ms 8s117ms 3s411ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 16 08 3 9s325ms 3s108ms 09 5 16s807ms 3s361ms 10 6 19s593ms 3s265ms 11 3 9s903ms 3s301ms 12 3 10s181ms 3s393ms 13 4 13s88ms 3s272ms 14 3 9s381ms 3s127ms 15 4 12s906ms 3s226ms 16 3 10s380ms 3s460ms 17 4 12s993ms 3s248ms 18 3 10s173ms 3s391ms 19 4 14s687ms 3s671ms 20 4 18s609ms 4s652ms 21 3 10s211ms 3s403ms 22 3 9s394ms 3s131ms [ User: intelifix - Total duration: 3m7s - Times executed: 55 ]
[ Application: psql - Total duration: 3m7s - Times executed: 55 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-16 20:00:12 Duration: 8s117ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-16 19:20:06 Duration: 5s118ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-16 10:00:04 Duration: 3s820ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
3 54 1m6s 195ms 4s243ms 1s231ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 16 10 19 14s668ms 772ms 11 8 4s49ms 506ms 13 9 10s675ms 1s186ms 14 13 29s860ms 2s296ms 15 5 7s223ms 1s444ms [ User: intelifix - Total duration: 1m6s - Times executed: 54 ]
[ Application: [unknown] - Total duration: 1m6s - Times executed: 54 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (277752, 317, '71428685850006808208,216351046884,216724847394,216519563948,216355472244,216520717180,216559002646,216406608793,216875462038,216837679102,216560051727,216545911234,216700779703,216508266369,216516061317,216519302026,216553470120,216700611427,216405601637,216637331828,216518727794,216874336282,216345937687,216516625670,216513848193,216394236576,216639679408,216542806272', '',062,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-16 14:54:22 Duration: 4s243ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (277751, 317, '254272117427790,216366789093,216842115573,216768470418,216449303556,216853300515,216853304454,216642360512,216440163034,216757693855,216666753644,216772199008,216417093858,216673737187,216687349111,216416845270,216566998195,216840227184,216536729898,216933069297,216882460106,216757467289,216729781625,216604398590,216645129704,216769963739,216645529697,216444100613', '',064,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-16 14:37:06 Duration: 4s82ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (277769, 317, '835099915003544,241667618704,241694185258,241646425569,241646486686,241713845976,241628248396,241630904952,241616730315,241595331122,241732476178,241732490827,241616730214,241638215475,241659516274,241677207787,241671402934,241727546370,241731196367', '',0320,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-16 13:55:28 Duration: 3s506ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-16.log
4 48 1h54m28s 1s276ms 14m23s 2m23s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 16 07 3 15m27s 5m9s 08 3 5m55s 1m58s 09 3 5m55s 1m58s 10 3 5m52s 1m57s 11 3 6m18s 2m6s 12 3 6m5s 2m1s 13 3 5m59s 1m59s 14 3 6m14s 2m4s 15 3 5m58s 1m59s 16 3 6m11s 2m3s 17 3 6m10s 2m3s 18 3 6m8s 2m2s 19 3 6m15s 2m5s 20 3 9m59s 3m19s 21 3 9m21s 3m7s 22 3 6m33s 2m11s [ User: intelifix - Total duration: 1h54m28s - Times executed: 48 ]
[ Application: psql - Total duration: 1h54m28s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-16 07:19:24 Duration: 14m23s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-16 20:14:10 Duration: 9m8s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-16 21:14:04 Duration: 9m2s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
5 48 1h5m58s 193ms 4m20s 1m22s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 16 07 3 6m36s 2m12s 08 3 3m35s 1m11s 09 3 3m36s 1m12s 10 3 3m33s 1m11s 11 3 3m49s 1m16s 12 3 3m38s 1m12s 13 3 3m37s 1m12s 14 3 3m44s 1m14s 15 3 3m37s 1m12s 16 3 3m40s 1m13s 17 3 3m48s 1m16s 18 3 3m44s 1m14s 19 3 3m41s 1m13s 20 3 6m39s 2m13s 21 3 4m4s 1m21s 22 3 4m31s 1m30s [ User: intelifix - Total duration: 1h5m58s - Times executed: 48 ]
[ Application: psql - Total duration: 1h5m58s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-16 07:26:54 Duration: 4m20s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-16 20:21:30 Duration: 4m12s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-16 22:16:04 Duration: 3m55s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
6 35 1m59s 2s865ms 4s622ms 3s409ms 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 #6
Day Hour Count Duration Avg duration Aug 16 08 3 11s245ms 3s748ms 09 1 3s756ms 3s756ms 11 3 9s755ms 3s251ms 12 3 12s283ms 4s94ms 13 2 7s484ms 3s742ms 14 3 9s496ms 3s165ms 15 2 6s508ms 3s254ms 16 3 10s176ms 3s392ms 17 2 6s194ms 3s97ms 18 3 9s190ms 3s63ms 19 2 6s503ms 3s251ms 20 2 6s865ms 3s432ms 21 3 9s713ms 3s237ms 22 3 10s151ms 3s383ms [ User: intelifix - Total duration: 1m59s - Times executed: 35 ]
[ Application: psql - Total duration: 1m59s - 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-08-16 12:40:05 Duration: 4s622ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
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-08-16 08:00:06 Duration: 4s437ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
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-08-16 13:20:06 Duration: 4s402ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
7 11 6s467ms 183ms 4s238ms 587ms create table temp0000288558 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 16 11 1 4s238ms 4s238ms 13 4 887ms 221ms 14 4 927ms 231ms 15 2 414ms 207ms [ User: intelifix - Total duration: 6s467ms - Times executed: 11 ]
[ Application: [unknown] - Total duration: 6s467ms - Times executed: 11 ]
-
CREATE TABLE temp0000288558 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"11-08-2026", "ate" :"16-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-16 11:49:59 Duration: 4s238ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
CREATE TABLE temp0000288558 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"11-08-2026", "ate" :"16-08-2026", "nota-fiscal":"71326", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-16 13:46:08 Duration: 276ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
CREATE TABLE temp0000288558 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"11-08-2026", "ate" :"16-08-2026", "nota-fiscal":"71326", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-16 14:18:11 Duration: 267ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-16.log
8 7 4s455ms 154ms 2s428ms 636ms select * from rs_etiqueta (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 16 10 1 383ms 383ms 11 1 231ms 231ms 20 1 579ms 579ms 23 4 3s261ms 815ms [ User: etiquetas - Total duration: 4s455ms - Times executed: 7 ]
[ Application: [unknown] - Total duration: 4s455ms - Times executed: 7 ]
-
SELECT * FROM RS_ETIQUETA ('');
Date: 2026-08-16 23:34:53 Duration: 2s428ms Database: rio User: etiquetas Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
SELECT * FROM RS_ETIQUETA ('');
Date: 2026-08-16 20:14:43 Duration: 579ms Database: rio User: etiquetas Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
SELECT * FROM RS_ETIQUETA ('');
Date: 2026-08-16 23:37:55 Duration: 515ms Database: rio User: etiquetas Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-16.log
9 7 3s315ms 334ms 586ms 473ms 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 #9
Day Hour Count Duration Avg duration Aug 16 10 2 939ms 469ms 11 2 989ms 494ms 13 1 334ms 334ms 14 1 465ms 465ms 15 1 586ms 586ms [ User: lenon - Total duration: 3s315ms - Times executed: 7 ]
[ Application: [unknown] - Total duration: 3s315ms - Times executed: 7 ]
-
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-08-16 15:05:53 Duration: 586ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-08-16 11:55:07 Duration: 538ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-08-16 10:18:29 Duration: 498ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-16.log
10 7 2s723ms 155ms 890ms 389ms select seqrelid, format_type(seqtypid, null), seqstart, seqincrement, seqmax, seqmin, seqcache, seqcycle, last_value, is_called from pg_catalog.pg_sequence, pg_get_sequence_data (seqrelid) order by seqrelid;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 16 20 3 857ms 285ms 23 4 1s865ms 466ms [ User: intelifix - Total duration: 2s723ms - Times executed: 7 ]
[ Application: pg_dump - Total duration: 2s723ms - Times executed: 7 ]
-
SELECT seqrelid, format_type(seqtypid, NULL), seqstart, seqincrement, seqmax, seqmin, seqcache, seqcycle, last_value, is_called FROM pg_catalog.pg_sequence, pg_get_sequence_data (seqrelid) ORDER BY seqrelid;
Date: 2026-08-16 23:43:04 Duration: 890ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
SELECT seqrelid, format_type(seqtypid, NULL), seqstart, seqincrement, seqmax, seqmin, seqcache, seqcycle, last_value, is_called FROM pg_catalog.pg_sequence, pg_get_sequence_data (seqrelid) ORDER BY seqrelid;
Date: 2026-08-16 23:33:21 Duration: 629ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
SELECT seqrelid, format_type(seqtypid, NULL), seqstart, seqincrement, seqmax, seqmin, seqcache, seqcycle, last_value, is_called FROM pg_catalog.pg_sequence, pg_get_sequence_data (seqrelid) ORDER BY seqrelid;
Date: 2026-08-16 20:11:24 Duration: 460ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
11 7 2s599ms 259ms 484ms 371ms select p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, p.proacl, acldefault(?, p.proowner) as acldefault, p.pronamespace, p.proowner from pg_proc p left join pg_init_privs pip on (p.oid = pip.objoid and pip.classoid = ?::regclass and pip.objsubid = ?) where p.prokind <> ? and not exists ( select ? from pg_depend where classid = ?::regclass and objid = p.oid and deptype = ?) and (pronamespace != ( select oid from pg_namespace where nspname = ?) or exists ( select ? from pg_cast where pg_cast.oid > ? and p.oid = pg_cast.castfunc) or exists ( select ? from pg_transform where pg_transform.oid > ? and (p.oid = pg_transform.trffromsql or p.oid = pg_transform.trftosql)) or p.proacl is distinct from pip.initprivs);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 16 20 3 1s32ms 344ms 23 4 1s566ms 391ms [ User: intelifix - Total duration: 2s599ms - Times executed: 7 ]
[ Application: pg_dump - Total duration: 2s599ms - Times executed: 7 ]
-
SELECT p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, p.proacl, acldefault('f', p.proowner) AS acldefault, p.pronamespace, p.proowner FROM pg_proc p LEFT JOIN pg_init_privs pip ON (p.oid = pip.objoid AND pip.classoid = 'pg_proc'::regclass AND pip.objsubid = 0) WHERE p.prokind <> 'a' AND NOT EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_proc'::regclass AND objid = p.oid AND deptype = 'i') AND (pronamespace != ( SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog') OR EXISTS ( SELECT 1 FROM pg_cast WHERE pg_cast.oid > 16383 AND p.oid = pg_cast.castfunc) OR EXISTS ( SELECT 1 FROM pg_transform WHERE pg_transform.oid > 16383 AND (p.oid = pg_transform.trffromsql OR p.oid = pg_transform.trftosql)) OR p.proacl IS DISTINCT FROM pip.initprivs);
Date: 2026-08-16 23:10:02 Duration: 484ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
SELECT p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, p.proacl, acldefault('f', p.proowner) AS acldefault, p.pronamespace, p.proowner FROM pg_proc p LEFT JOIN pg_init_privs pip ON (p.oid = pip.objoid AND pip.classoid = 'pg_proc'::regclass AND pip.objsubid = 0) WHERE p.prokind <> 'a' AND NOT EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_proc'::regclass AND objid = p.oid AND deptype = 'i') AND (pronamespace != ( SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog') OR EXISTS ( SELECT 1 FROM pg_cast WHERE pg_cast.oid > 16383 AND p.oid = pg_cast.castfunc) OR EXISTS ( SELECT 1 FROM pg_transform WHERE pg_transform.oid > 16383 AND (p.oid = pg_transform.trffromsql OR p.oid = pg_transform.trftosql)) OR p.proacl IS DISTINCT FROM pip.initprivs);
Date: 2026-08-16 23:33:18 Duration: 417ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
SELECT p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, p.proacl, acldefault('f', p.proowner) AS acldefault, p.pronamespace, p.proowner FROM pg_proc p LEFT JOIN pg_init_privs pip ON (p.oid = pip.objoid AND pip.classoid = 'pg_proc'::regclass AND pip.objsubid = 0) WHERE p.prokind <> 'a' AND NOT EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_proc'::regclass AND objid = p.oid AND deptype = 'i') AND (pronamespace != ( SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog') OR EXISTS ( SELECT 1 FROM pg_cast WHERE pg_cast.oid > 16383 AND p.oid = pg_cast.castfunc) OR EXISTS ( SELECT 1 FROM pg_transform WHERE pg_transform.oid > 16383 AND (p.oid = pg_transform.trffromsql OR p.oid = pg_transform.trftosql)) OR p.proacl IS DISTINCT FROM pip.initprivs);
Date: 2026-08-16 20:02:03 Duration: 406ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
12 7 2s172ms 238ms 421ms 310ms select c.tableoid, c.oid, c.relname, c.relnamespace, c.relkind, c.reltype, c.relowner, c.relchecks, c.relhasindex, c.relhasrules, c.relpages, c.reltuples, c.relallvisible, c.relallfrozen, c.relhastriggers, c.relpersistence, c.reloftype, c.relacl, acldefault( case when c.relkind = ? then ?::"char" else ?::"char" end, c.relowner) as acldefault, case when c.relkind = ? then ( select ftserver from pg_catalog.pg_foreign_table where ftrelid = c.oid) else ? end as foreignserver, c.relfrozenxid, tc.relfrozenxid as tfrozenxid, tc.oid as toid, tc.relpages as toastpages, tc.reloptions as toast_reloptions, d.refobjid as owning_tab, d.refobjsubid as owning_col, tsp.spcname as reltablespace, false as relhasoids, c.relispopulated, c.relreplident, c.relrowsecurity, c.relforcerowsecurity, c.relminmxid, tc.relminmxid as tminmxid, array_remove(array_remove(c.reloptions, ?), ?) as reloptions, case when ? = any (c.reloptions) then ?::text when ? = any (c.reloptions) then ?::text else null end as checkoption, am.amname, (d.deptype = ?) is true as is_identity_sequence, c.relispartition as ispartition from pg_class c left join pg_depend d on (c.relkind = ? and d.classid = ?::regclass and d.objid = c.oid and d.objsubid = ? and d.refclassid = ?::regclass and d.deptype in (...)) left join pg_tablespace tsp on (tsp.oid = c.reltablespace) left join pg_am am on (c.relam = am.oid) left join pg_class tc on (c.reltoastrelid = tc.oid and tc.relkind = ? and c.relkind <> ?) where c.relkind in (...) order by c.oid;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 16 20 3 788ms 262ms 23 4 1s383ms 345ms [ User: intelifix - Total duration: 2s172ms - Times executed: 7 ]
[ Application: pg_dump - Total duration: 2s172ms - Times executed: 7 ]
-
SELECT c.tableoid, c.oid, c.relname, c.relnamespace, c.relkind, c.reltype, c.relowner, c.relchecks, c.relhasindex, c.relhasrules, c.relpages, c.reltuples, c.relallvisible, c.relallfrozen, c.relhastriggers, c.relpersistence, c.reloftype, c.relacl, acldefault( CASE WHEN c.relkind = 'S' THEN 's'::"char" ELSE 'r'::"char" END, c.relowner) AS acldefault, CASE WHEN c.relkind = 'f' THEN ( SELECT ftserver FROM pg_catalog.pg_foreign_table WHERE ftrelid = c.oid) ELSE 0 END AS foreignserver, c.relfrozenxid, tc.relfrozenxid AS tfrozenxid, tc.oid AS toid, tc.relpages AS toastpages, tc.reloptions AS toast_reloptions, d.refobjid AS owning_tab, d.refobjsubid AS owning_col, tsp.spcname AS reltablespace, false AS relhasoids, c.relispopulated, c.relreplident, c.relrowsecurity, c.relforcerowsecurity, c.relminmxid, tc.relminmxid AS tminmxid, array_remove(array_remove(c.reloptions, 'check_option=local'), 'check_option=cascaded') AS reloptions, CASE WHEN 'check_option=local' = ANY (c.reloptions) THEN 'LOCAL'::text WHEN 'check_option=cascaded' = ANY (c.reloptions) THEN 'CASCADED'::text ELSE NULL END AS checkoption, am.amname, (d.deptype = 'i') IS TRUE AS is_identity_sequence, c.relispartition AS ispartition FROM pg_class c LEFT JOIN pg_depend d ON (c.relkind = 'S' AND d.classid = 'pg_class'::regclass AND d.objid = c.oid AND d.objsubid = 0 AND d.refclassid = 'pg_class'::regclass AND d.deptype IN ('a', 'i')) LEFT JOIN pg_tablespace tsp ON (tsp.oid = c.reltablespace) LEFT JOIN pg_am am ON (c.relam = am.oid) LEFT JOIN pg_class tc ON (c.reltoastrelid = tc.oid AND tc.relkind = 't' AND c.relkind <> 'p') WHERE c.relkind IN ('r', 'S', 'v', 'c', 'm', 'f', 'p') ORDER BY c.oid;
Date: 2026-08-16 23:10:02 Duration: 421ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
SELECT c.tableoid, c.oid, c.relname, c.relnamespace, c.relkind, c.reltype, c.relowner, c.relchecks, c.relhasindex, c.relhasrules, c.relpages, c.reltuples, c.relallvisible, c.relallfrozen, c.relhastriggers, c.relpersistence, c.reloftype, c.relacl, acldefault( CASE WHEN c.relkind = 'S' THEN 's'::"char" ELSE 'r'::"char" END, c.relowner) AS acldefault, CASE WHEN c.relkind = 'f' THEN ( SELECT ftserver FROM pg_catalog.pg_foreign_table WHERE ftrelid = c.oid) ELSE 0 END AS foreignserver, c.relfrozenxid, tc.relfrozenxid AS tfrozenxid, tc.oid AS toid, tc.relpages AS toastpages, tc.reloptions AS toast_reloptions, d.refobjid AS owning_tab, d.refobjsubid AS owning_col, tsp.spcname AS reltablespace, false AS relhasoids, c.relispopulated, c.relreplident, c.relrowsecurity, c.relforcerowsecurity, c.relminmxid, tc.relminmxid AS tminmxid, array_remove(array_remove(c.reloptions, 'check_option=local'), 'check_option=cascaded') AS reloptions, CASE WHEN 'check_option=local' = ANY (c.reloptions) THEN 'LOCAL'::text WHEN 'check_option=cascaded' = ANY (c.reloptions) THEN 'CASCADED'::text ELSE NULL END AS checkoption, am.amname, (d.deptype = 'i') IS TRUE AS is_identity_sequence, c.relispartition AS ispartition FROM pg_class c LEFT JOIN pg_depend d ON (c.relkind = 'S' AND d.classid = 'pg_class'::regclass AND d.objid = c.oid AND d.objsubid = 0 AND d.refclassid = 'pg_class'::regclass AND d.deptype IN ('a', 'i')) LEFT JOIN pg_tablespace tsp ON (tsp.oid = c.reltablespace) LEFT JOIN pg_am am ON (c.relam = am.oid) LEFT JOIN pg_class tc ON (c.reltoastrelid = tc.oid AND tc.relkind = 't' AND c.relkind <> 'p') WHERE c.relkind IN ('r', 'S', 'v', 'c', 'm', 'f', 'p') ORDER BY c.oid;
Date: 2026-08-16 23:17:07 Duration: 382ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
SELECT c.tableoid, c.oid, c.relname, c.relnamespace, c.relkind, c.reltype, c.relowner, c.relchecks, c.relhasindex, c.relhasrules, c.relpages, c.reltuples, c.relallvisible, c.relallfrozen, c.relhastriggers, c.relpersistence, c.reloftype, c.relacl, acldefault( CASE WHEN c.relkind = 'S' THEN 's'::"char" ELSE 'r'::"char" END, c.relowner) AS acldefault, CASE WHEN c.relkind = 'f' THEN ( SELECT ftserver FROM pg_catalog.pg_foreign_table WHERE ftrelid = c.oid) ELSE 0 END AS foreignserver, c.relfrozenxid, tc.relfrozenxid AS tfrozenxid, tc.oid AS toid, tc.relpages AS toastpages, tc.reloptions AS toast_reloptions, d.refobjid AS owning_tab, d.refobjsubid AS owning_col, tsp.spcname AS reltablespace, false AS relhasoids, c.relispopulated, c.relreplident, c.relrowsecurity, c.relforcerowsecurity, c.relminmxid, tc.relminmxid AS tminmxid, array_remove(array_remove(c.reloptions, 'check_option=local'), 'check_option=cascaded') AS reloptions, CASE WHEN 'check_option=local' = ANY (c.reloptions) THEN 'LOCAL'::text WHEN 'check_option=cascaded' = ANY (c.reloptions) THEN 'CASCADED'::text ELSE NULL END AS checkoption, am.amname, (d.deptype = 'i') IS TRUE AS is_identity_sequence, c.relispartition AS ispartition FROM pg_class c LEFT JOIN pg_depend d ON (c.relkind = 'S' AND d.classid = 'pg_class'::regclass AND d.objid = c.oid AND d.objsubid = 0 AND d.refclassid = 'pg_class'::regclass AND d.deptype IN ('a', 'i')) LEFT JOIN pg_tablespace tsp ON (tsp.oid = c.reltablespace) LEFT JOIN pg_am am ON (c.relam = am.oid) LEFT JOIN pg_class tc ON (c.reltoastrelid = tc.oid AND tc.relkind = 't' AND c.relkind <> 'p') WHERE c.relkind IN ('r', 'S', 'v', 'c', 'm', 'f', 'p') ORDER BY c.oid;
Date: 2026-08-16 23:43:01 Duration: 328ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
13 6 1m34s 3s584ms 36s2ms 15s801ms 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 #13
Day Hour Count Duration Avg duration Aug 16 20 3 48s389ms 16s129ms 23 3 46s422ms 15s474ms [ User: intelifix - Total duration: 1m34s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m34s - 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-08-16 20:06:24 Duration: 36s2ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
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-08-16 23:14:10 Duration: 33s847ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
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-08-16 23:34:17 Duration: 8s990ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
14 6 1m32s 8s711ms 22s852ms 15s445ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 16 00 3 1m3s 21s76ms 06 3 29s440ms 9s813ms [ User: intelifix - Total duration: 1m32s - Times executed: 6 ]
[ Application: psql - Total duration: 1m32s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-16 00:05:24 Duration: 22s852ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-16 00:06:04 Duration: 21s34ms Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-16 00:05:43 Duration: 19s343ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
15 6 1m14s 1s919ms 30s440ms 12s438ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 16 20 3 39s161ms 13s53ms 23 3 35s467ms 11s822ms [ User: intelifix - Total duration: 1m14s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m14s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-16 20:06:58 Duration: 30s440ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-16 23:14:41 Duration: 26s854ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-16 23:34:24 Duration: 6s693ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
16 6 1m13s 2s715ms 27s514ms 12s270ms 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 #16
Day Hour Count Duration Avg duration Aug 16 20 3 37s919ms 12s639ms 23 3 35s704ms 11s901ms [ User: intelifix - Total duration: 1m13s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m13s - 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-08-16 23:17:06 Duration: 27s514ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
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-08-16 20:09:43 Duration: 27s265ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
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-08-16 20:11:19 Duration: 6s769ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
17 6 1m2s 1s731ms 26s906ms 10s478ms 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 #17
Day Hour Count Duration Avg duration Aug 16 20 3 33s206ms 11s68ms 23 3 29s664ms 9s888ms [ User: intelifix - Total duration: 1m2s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m2s - 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-08-16 20:04:25 Duration: 26s906ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
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-08-16 23:12:08 Duration: 22s695ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
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-08-16 23:34:03 Duration: 5s203ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
18 6 1m 1s854ms 22s245ms 10s164ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 16 20 3 31s663ms 10s554ms 23 3 29s322ms 9s774ms [ User: intelifix - Total duration: 1m - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-16 20:03:25 Duration: 22s245ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-16 23:11:17 Duration: 20s44ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-16 20:10:17 Duration: 7s563ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
19 6 58s125ms 1s991ms 19s233ms 9s687ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 16 20 3 29s877ms 9s959ms 23 3 28s248ms 9s416ms [ User: intelifix - Total duration: 58s125ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 58s125ms - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-16 20:02:48 Duration: 19s233ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-16 23:10:42 Duration: 18s343ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-16 20:10:07 Duration: 8s504ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
20 6 51s229ms 195ms 50s98ms 8s538ms create table temp0000288556 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 16 10 4 50s728ms 12s682ms 11 2 500ms 250ms [ User: intelifix - Total duration: 51s229ms - Times executed: 6 ]
[ Application: [unknown] - Total duration: 51s229ms - Times executed: 6 ]
-
CREATE TABLE temp0000288556 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"11-08-2026", "ate" :"16-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-16 10:19:23 Duration: 50s98ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
CREATE TABLE temp0000288556 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"11-08-2026", "ate" :"16-08-2026", "nota-fiscal":"71326", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-16 11:10:49 Duration: 298ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
CREATE TABLE temp0000288556 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"11-08-2026", "ate" :"16-08-2026", "nota-fiscal":"71326", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-16 10:23:18 Duration: 230ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-16.log
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 3m29s 11m59s 8m4s 3 24m13s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 16 05 3 24m13s 8m4s [ User: intelifix - Total duration: 24m13s - Times executed: 3 ]
[ Application: psql - Total duration: 24m13s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-16 05:12:00 Duration: 11m59s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
analyze verbose;
Date: 2026-08-16 05:20:45 Duration: 8m45s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
analyze verbose;
Date: 2026-08-16 05:24:15 Duration: 3m29s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
2 1s276ms 14m23s 2m23s 48 1h54m28s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 16 07 3 15m27s 5m9s 08 3 5m55s 1m58s 09 3 5m55s 1m58s 10 3 5m52s 1m57s 11 3 6m18s 2m6s 12 3 6m5s 2m1s 13 3 5m59s 1m59s 14 3 6m14s 2m4s 15 3 5m58s 1m59s 16 3 6m11s 2m3s 17 3 6m10s 2m3s 18 3 6m8s 2m2s 19 3 6m15s 2m5s 20 3 9m59s 3m19s 21 3 9m21s 3m7s 22 3 6m33s 2m11s [ User: intelifix - Total duration: 1h54m28s - Times executed: 48 ]
[ Application: psql - Total duration: 1h54m28s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-16 07:19:24 Duration: 14m23s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-16 20:14:10 Duration: 9m8s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-16 21:14:04 Duration: 9m2s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
3 1m32s 1m32s 1m32s 1 1m32s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 16 05 1 1m32s 1m32s [ User: intelifix - Total duration: 1m32s - Times executed: 1 ]
[ Application: psql - Total duration: 1m32s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-16 05:32:18 Duration: 1m32s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-16 05:32:10 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
4 193ms 4m20s 1m22s 48 1h5m58s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 16 07 3 6m36s 2m12s 08 3 3m35s 1m11s 09 3 3m36s 1m12s 10 3 3m33s 1m11s 11 3 3m49s 1m16s 12 3 3m38s 1m12s 13 3 3m37s 1m12s 14 3 3m44s 1m14s 15 3 3m37s 1m12s 16 3 3m40s 1m13s 17 3 3m48s 1m16s 18 3 3m44s 1m14s 19 3 3m41s 1m13s 20 3 6m39s 2m13s 21 3 4m4s 1m21s 22 3 4m31s 1m30s [ User: intelifix - Total duration: 1h5m58s - Times executed: 48 ]
[ Application: psql - Total duration: 1h5m58s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-16 07:26:54 Duration: 4m20s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-16 20:21:30 Duration: 4m12s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-16 22:16:04 Duration: 3m55s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
5 4s389ms 1m34s 46s928ms 4 3m7s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 16 20 2 1m39s 49s784ms 23 2 1m28s 44s72ms [ User: intelifix - Total duration: 3m7s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m7s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-16 20:09:15 Duration: 1m34s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-16 23:16:39 Duration: 1m23s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-16 20:11:12 Duration: 4s988ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
6 479ms 1m3s 30s667ms 4 2m2s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 16 20 2 58s726ms 29s363ms 23 2 1m3s 31s972ms [ User: intelifix - Total duration: 2m2s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m2s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-16 23:13:34 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-16 20:05:45 Duration: 58s246ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-16 23:34:07 Duration: 551ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
7 3s584ms 36s2ms 15s801ms 6 1m34s 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 Aug 16 20 3 48s389ms 16s129ms 23 3 46s422ms 15s474ms [ User: intelifix - Total duration: 1m34s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m34s - 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-08-16 20:06:24 Duration: 36s2ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
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-08-16 23:14:10 Duration: 33s847ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
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-08-16 23:34:17 Duration: 8s990ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
8 8s711ms 22s852ms 15s445ms 6 1m32s call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 16 00 3 1m3s 21s76ms 06 3 29s440ms 9s813ms [ User: intelifix - Total duration: 1m32s - Times executed: 6 ]
[ Application: psql - Total duration: 1m32s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-16 00:05:24 Duration: 22s852ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-16 00:06:04 Duration: 21s34ms Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-16 00:05:43 Duration: 19s343ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
9 3s386ms 22s210ms 12s756ms 4 51s27ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 16 20 2 25s230ms 12s615ms 23 2 25s797ms 12s898ms [ User: intelifix - Total duration: 51s27ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 51s27ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-08-16 23:12:31 Duration: 22s210ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-08-16 20:04:47 Duration: 21s843ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-08-16 23:34:07 Duration: 3s586ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
10 1s919ms 30s440ms 12s438ms 6 1m14s copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 16 20 3 39s161ms 13s53ms 23 3 35s467ms 11s822ms [ User: intelifix - Total duration: 1m14s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m14s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-16 20:06:58 Duration: 30s440ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-16 23:14:41 Duration: 26s854ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-16 23:34:24 Duration: 6s693ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
11 2s715ms 27s514ms 12s270ms 6 1m13s 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 #11
Day Hour Count Duration Avg duration Aug 16 20 3 37s919ms 12s639ms 23 3 35s704ms 11s901ms [ User: intelifix - Total duration: 1m13s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m13s - 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-08-16 23:17:06 Duration: 27s514ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
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-08-16 20:09:43 Duration: 27s265ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
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-08-16 20:11:19 Duration: 6s769ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
12 1s731ms 26s906ms 10s478ms 6 1m2s 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 Aug 16 20 3 33s206ms 11s68ms 23 3 29s664ms 9s888ms [ User: intelifix - Total duration: 1m2s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m2s - 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-08-16 20:04:25 Duration: 26s906ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
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-08-16 23:12:08 Duration: 22s695ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
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-08-16 23:34:03 Duration: 5s203ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
13 1s854ms 22s245ms 10s164ms 6 1m copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 16 20 3 31s663ms 10s554ms 23 3 29s322ms 9s774ms [ User: intelifix - Total duration: 1m - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-16 20:03:25 Duration: 22s245ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-16 23:11:17 Duration: 20s44ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-16 20:10:17 Duration: 7s563ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
14 1s991ms 19s233ms 9s687ms 6 58s125ms 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 Aug 16 20 3 29s877ms 9s959ms 23 3 28s248ms 9s416ms [ User: intelifix - Total duration: 58s125ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 58s125ms - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-16 20:02:48 Duration: 19s233ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-16 23:10:42 Duration: 18s343ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-16 20:10:07 Duration: 8s504ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
15 195ms 50s98ms 8s538ms 6 51s229ms create table temp0000288556 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 16 10 4 50s728ms 12s682ms 11 2 500ms 250ms [ User: intelifix - Total duration: 51s229ms - Times executed: 6 ]
[ Application: [unknown] - Total duration: 51s229ms - Times executed: 6 ]
-
CREATE TABLE temp0000288556 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"11-08-2026", "ate" :"16-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-16 10:19:23 Duration: 50s98ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
CREATE TABLE temp0000288556 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"11-08-2026", "ate" :"16-08-2026", "nota-fiscal":"71326", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-16 11:10:49 Duration: 298ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
CREATE TABLE temp0000288556 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"11-08-2026", "ate" :"16-08-2026", "nota-fiscal":"71326", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-16 10:23:18 Duration: 230ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-16.log
16 1s487ms 14s737ms 7s255ms 6 43s533ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 16 20 3 22s283ms 7s427ms 23 3 21s250ms 7s83ms [ User: intelifix - Total duration: 43s533ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 43s533ms - Times executed: 6 ]
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-08-16 20:03:40 Duration: 14s737ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-08-16 23:11:31 Duration: 13s328ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-08-16 23:33:54 Duration: 6s434ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-16.log
17 2s815ms 8s117ms 3s411ms 55 3m7s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 16 08 3 9s325ms 3s108ms 09 5 16s807ms 3s361ms 10 6 19s593ms 3s265ms 11 3 9s903ms 3s301ms 12 3 10s181ms 3s393ms 13 4 13s88ms 3s272ms 14 3 9s381ms 3s127ms 15 4 12s906ms 3s226ms 16 3 10s380ms 3s460ms 17 4 12s993ms 3s248ms 18 3 10s173ms 3s391ms 19 4 14s687ms 3s671ms 20 4 18s609ms 4s652ms 21 3 10s211ms 3s403ms 22 3 9s394ms 3s131ms [ User: intelifix - Total duration: 3m7s - Times executed: 55 ]
[ Application: psql - Total duration: 3m7s - Times executed: 55 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-16 20:00:12 Duration: 8s117ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-16 19:20:06 Duration: 5s118ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-16 10:00:04 Duration: 3s820ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
18 2s865ms 4s622ms 3s409ms 35 1m59s 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 #18
Day Hour Count Duration Avg duration Aug 16 08 3 11s245ms 3s748ms 09 1 3s756ms 3s756ms 11 3 9s755ms 3s251ms 12 3 12s283ms 4s94ms 13 2 7s484ms 3s742ms 14 3 9s496ms 3s165ms 15 2 6s508ms 3s254ms 16 3 10s176ms 3s392ms 17 2 6s194ms 3s97ms 18 3 9s190ms 3s63ms 19 2 6s503ms 3s251ms 20 2 6s865ms 3s432ms 21 3 9s713ms 3s237ms 22 3 10s151ms 3s383ms [ User: intelifix - Total duration: 1m59s - Times executed: 35 ]
[ Application: psql - Total duration: 1m59s - 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-08-16 12:40:05 Duration: 4s622ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
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-08-16 08:00:06 Duration: 4s437ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
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-08-16 13:20:06 Duration: 4s402ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
19 156ms 22s882ms 2s864ms 277 13m13s call rs_giga_triagem (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 16 00 12 54s411ms 4s534ms 01 12 34s368ms 2s864ms 02 12 34s317ms 2s859ms 03 13 38s393ms 2s953ms 04 12 33s177ms 2s764ms 05 12 32s459ms 2s704ms 06 12 34s4ms 2s833ms 07 12 30s527ms 2s543ms 08 12 31s140ms 2s595ms 09 12 31s163ms 2s596ms 10 12 30s280ms 2s523ms 11 12 33s955ms 2s829ms 12 12 31s200ms 2s600ms 13 12 32s588ms 2s715ms 14 12 31s817ms 2s651ms 15 12 31s307ms 2s608ms 16 12 34s266ms 2s855ms 17 12 32s364ms 2s697ms 18 12 35s536ms 2s961ms 19 12 34s366ms 2s863ms 20 12 44s925ms 3s743ms 21 12 33s126ms 2s760ms 22 12 33s683ms 2s806ms [ User: intelifix - Total duration: 13m13s - Times executed: 277 ]
[ Application: psql - Total duration: 13m13s - Times executed: 277 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-16 00:05:24 Duration: 22s882ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-16 20:15:17 Duration: 14s909ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-16 19:35:08 Duration: 6s967ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-16.log
20 195ms 4s243ms 1s231ms 54 1m6s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 16 10 19 14s668ms 772ms 11 8 4s49ms 506ms 13 9 10s675ms 1s186ms 14 13 29s860ms 2s296ms 15 5 7s223ms 1s444ms [ User: intelifix - Total duration: 1m6s - Times executed: 54 ]
[ Application: [unknown] - Total duration: 1m6s - Times executed: 54 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (277752, 317, '71428685850006808208,216351046884,216724847394,216519563948,216355472244,216520717180,216559002646,216406608793,216875462038,216837679102,216560051727,216545911234,216700779703,216508266369,216516061317,216519302026,216553470120,216700611427,216405601637,216637331828,216518727794,216874336282,216345937687,216516625670,216513848193,216394236576,216639679408,216542806272', '',062,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-16 14:54:22 Duration: 4s243ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (277751, 317, '254272117427790,216366789093,216842115573,216768470418,216449303556,216853300515,216853304454,216642360512,216440163034,216757693855,216666753644,216772199008,216417093858,216673737187,216687349111,216416845270,216566998195,216840227184,216536729898,216933069297,216882460106,216757467289,216729781625,216604398590,216645129704,216769963739,216645529697,216444100613', '',064,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-16 14:37:06 Duration: 4s82ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-16.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (277769, 317, '835099915003544,241667618704,241694185258,241646425569,241646486686,241713845976,241628248396,241630904952,241616730315,241595331122,241732476178,241732490827,241616730214,241638215475,241659516274,241677207787,241671402934,241727546370,241731196367', '',0320,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-16 13:55:28 Duration: 3s506ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-16.log
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 19 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Aug 15 08 1 0ms 0ms 09 3 0ms 0ms 12 1 0ms 0ms 16 1 0ms 0ms 17 2 0ms 0ms 18 1 0ms 0ms 22 2 0ms 0ms Aug 16 09 3 0ms 0ms 10 1 0ms 0ms 13 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms 21 1 0ms 0ms [ User: intelifix - Total duration: 12m50s - Times executed: 19 ]
[ Application: psql - Total duration: 12m50s - Times executed: 18 ]
[ Application: [unknown] - Total duration: 185ms - Times executed: 1 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 6,943 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 14 FATAL entries
- 2273 ERROR entries
- 0 WARNING entries
- 1 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 2,223 Max number of times the same event was reported
- 2,288 Total events found
Rank Times reported Error 1 2,223 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Aug 16 00 117 01 117 02 116 03 113 04 115 05 116 06 116 07 117 08 114 09 116 10 113 11 117 12 115 13 115 14 108 15 53 16 59 17 54 18 58 19 57 20 56 21 53 22 58 23 50 - ERROR: prepared statement "_PLAN0000000029B80C60" does not exist
- ERROR: prepared statement "_PLAN000000002A5D37A0" does not exist
- ERROR: prepared statement "_PLAN0000000029B83E90" does not exist
Statement: DEALLOCATE "_PLAN0000000029B80C60"
Date: 2026-08-16 00:00:24 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-16.log
Statement: DEALLOCATE "_PLAN000000002A5D37A0"
Date: 2026-08-16 00:00:33 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-16.log
Statement: DEALLOCATE "_PLAN0000000029B83E90"
Date: 2026-08-16 00:01:24 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-16.log
2 45 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #2
Day Hour Count Aug 16 00 2 01 2 02 2 03 2 04 2 05 2 06 2 07 2 08 2 09 2 10 2 11 2 12 2 13 2 14 2 15 2 16 2 17 2 18 2 19 1 20 2 21 2 22 2 - ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-08-16 00:05:02 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-16.log
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-08-16 00:35:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-16.log
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-08-16 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-16.log
3 7 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #3
Day Hour Count Aug 16 03 7 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-08-16 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-16.log
Date: 2026-08-16 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-16.log
Date: 2026-08-16 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-16.log
4 4 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Aug 16 00 1 04 1 06 1 08 1 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "testes" does not exist
Date: 2026-08-16 00:02:20 Database: testes Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-16.log
Date: 2026-08-16 04:58:04 Database: jaboatao Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-16.log
Date: 2026-08-16 06:02:19 Database: testes Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-16.log
5 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Aug 16 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-08-16 05:32:18 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-16.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-16 05:32:18 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-16.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-16 05:32:18 Database: contagem Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-16.log
6 3 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #6
Day Hour Count Aug 16 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-08-16 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-16.log
Date: 2026-08-16 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-16.log
Date: 2026-08-16 03:05:02 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-16.log
7 1 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv' PL/Python function "...", line 21, in <module> os.chmod(...) PL/Python function "..." PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Times Reported Most Frequent Error / Event #7
Day Hour Count Aug 16 19 1 - ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv' PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Context: Traceback (most recent call last):
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-08-16 19:35:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-16.log
8 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #8
Day Hour Count Aug 16 03 1 - LOG: database system was shut down at 2026-08-16 03:05:03 -03
Date: 2026-08-16 03:05:04 Log file: /usr/local/pgsql/data/log/serverlog-16.log