pgBadger-
Global information
- Generated on Sun Jul 26 23:50:09 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 11,055 log entries in 7s
- Log start from 2026-07-25 00:00:00 to 2026-07-25 23:59:31
-
Overview
Global Stats
- 150 Number of unique normalized queries
- 954 Number of queries
- 4h28m13s Total query duration
- 2026-07-25 00:02:18 First query
- 2026-07-25 23:55:17 Last query
- 3 queries/s at 2026-07-25 20:09:40 Query peak
- 4h28m13s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 4h28m13s Execute total duration
- 1,861 Number of events
- 10 Number of unique normalized events
- 1,740 Max number of times the same event was reported
- 0 Number of cancellation
- 10 Total number of automatic vacuums
- 10 Total number of automatic analyzes
- 10 Number temporary file
- 237.16 MiB Max size of temporary file
- 110.25 MiB Average size of temporary file
- 223 Total number of sessions
- 7 sessions at 2026-07-25 01:02:18 Session peak
- 8d9h24m45s Total duration of sessions
- 54m11s Average duration of sessions
- 4 Average queries per session
- 1m12s Average queries duration per session
- 52m59s Average idle time per session
- 235 Total number of connections
- 7 connections/s at 2026-07-25 03:05:17 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 3 queries/s Query Peak
- 2026-07-25 20:09:40 Date
SELECT Traffic
Key values
- 2 queries/s Query Peak
- 2026-07-25 23:18:15 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 3 queries/s Query Peak
- 2026-07-25 20:09:40 Date
Queries duration
Key values
- 4h28m13s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 25 00 28 0ms 18s29ms 4s419ms 4s175ms 4s941ms 1m16s 01 26 0ms 3s26ms 1s116ms 4s46ms 4s429ms 4s998ms 02 17 0ms 3s531ms 1s656ms 3s859ms 5s39ms 5s412ms 03 20 0ms 3s644ms 1s543ms 4s114ms 4s791ms 7s481ms 04 19 0ms 3s176ms 1s578ms 4s461ms 4s926ms 5s831ms 05 43 0ms 9m29s 27s98ms 9s283ms 2m36s 9m30s 06 18 0ms 16s414ms 3s961ms 3s405ms 3s997ms 29s450ms 07 21 0ms 9m58s 48s25ms 4s152ms 1m43s 10m3s 08 21 0ms 6m17s 32s763ms 3s686ms 18s486ms 6m52s 09 21 0ms 6m9s 32s752ms 3s806ms 19s506ms 6m45s 10 21 0ms 6m28s 33s132ms 3s303ms 51s393ms 6m28s 11 21 0ms 6m44s 34s283ms 3s776ms 55s861ms 6m44s 12 36 0ms 6m14s 18s375ms 3s569ms 15s738ms 6m47s 13 21 0ms 6m27s 32s702ms 3s440ms 51s133ms 6m27s 14 21 0ms 6m18s 32s298ms 3s788ms 18s571ms 6m53s 15 21 0ms 6m25s 32s976ms 3s779ms 52s735ms 6m25s 16 21 0ms 6m12s 32s327ms 3s426ms 18s412ms 6m45s 17 21 0ms 6m25s 32s543ms 3s347ms 51s720ms 6m25s 18 23 0ms 6m7s 28s501ms 3s36ms 16s189ms 6m45s 19 21 0ms 6m5s 31s208ms 3s237ms 3s589ms 6m56s 20 108 0ms 6m54s 11s817ms 58s447ms 1m51s 6m54s 21 23 0ms 8m22s 34s376ms 3s596ms 17s159ms 8m55s 22 21 0ms 6m32s 33s792ms 3s462ms 56s880ms 6m32s 23 341 0ms 1m44s 7s760ms 1m7s 1m15s 1m50s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 25 00 5 0 5s28ms 0ms 0ms 331ms 01 8 0 305ms 0ms 0ms 868ms 02 0 0 0ms 0ms 0ms 0ms 03 2 0 270ms 0ms 0ms 258ms 04 1 0 207ms 0ms 0ms 0ms 05 19 0 321ms 0ms 215ms 1s84ms 06 3 0 7s977ms 0ms 0ms 0ms 07 8 0 2m 0ms 0ms 4m13s 08 6 0 1m50s 0ms 0ms 3m50s 09 6 0 1m50s 0ms 0ms 3m55s 10 6 0 1m52s 0ms 0ms 3m52s 11 6 0 1m56s 0ms 0ms 3m55s 12 16 0 39s466ms 0ms 579ms 3m24s 13 6 0 1m50s 0ms 0ms 3m43s 14 6 0 1m48s 0ms 0ms 3m40s 15 6 0 1m51s 0ms 0ms 3m47s 16 6 0 1m49s 0ms 0ms 3m50s 17 6 0 1m50s 0ms 0ms 3m42s 18 8 0 1m19s 0ms 0ms 3m30s 19 6 0 1m45s 0ms 0ms 3m35s 20 10 81 13s614ms 23s721ms 58s447ms 3m35s 21 8 0 1m35s 0ms 0ms 3m33s 22 6 0 1m54s 0ms 0ms 3m56s 23 23 318 7s760ms 1m4s 1m7s 1m44s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 25 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jul 25 00 0 2 2.00 0.00% 01 0 3 3.00 0.00% 02 0 0 0.00 0.00% 03 0 2 2.00 0.00% 04 0 1 1.00 0.00% 05 0 3 3.00 0.00% 06 0 0 0.00 0.00% 07 0 1 1.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 1 1.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 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 Jul 25 00 15 0.00/s 01 11 0.00/s 02 8 0.00/s 03 17 0.00/s 04 7 0.00/s 05 11 0.00/s 06 14 0.00/s 07 11 0.00/s 08 7 0.00/s 09 10 0.00/s 10 8 0.00/s 11 7 0.00/s 12 10 0.00/s 13 8 0.00/s 14 9 0.00/s 15 7 0.00/s 16 7 0.00/s 17 9 0.00/s 18 9 0.00/s 19 8 0.00/s 20 13 0.00/s 21 7 0.00/s 22 8 0.00/s 23 14 0.00/s Day Hour Count Average Duration Average idle time Jul 25 00 8 1h45s 1h29s 01 14 1h49s 1h47s 02 11 1h32s 1h30s 03 18 19m23s 19m21s 04 7 1h3m 1h2m55s 05 8 54m13s 51m48s 06 10 58m50s 58m43s 07 12 1h30s 59m6s 08 11 56m16s 55m14s 09 6 55m50s 53m56s 10 9 54m46s 53m29s 11 7 1h58s 59m15s 12 7 1h25s 58m51s 13 10 57m48s 56m39s 14 8 1h47s 59m23s 15 8 1h23s 58m57s 16 7 1h53s 59m16s 17 7 1h35s 58m57s 18 8 1h1m8s 59m46s 19 7 1h1m22s 59m48s 20 11 44m26s 42m30s 21 8 1h1m3s 59m24s 22 7 1h56s 59m14s 23 14 37m31s 34m22s -
Connections
Established Connections
Key values
- 7 connections Connection Peak
- 2026-07-25 03:05:17 Date
Connections per database
Key values
- rio Main Database
- 235 connections Total
Connections per user
Key values
- intelifix Main User
- 235 connections Total
-
Sessions
Simultaneous sessions
Key values
- 7 sessions Session Peak
- 2026-07-25 01:02:18 Date
Histogram of session times
Key values
- 190 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 223 sessions Total
Sessions per user
Key values
- intelifix Main User
- 223 sessions Total
Sessions per host
Key values
- [local] Main Host
- 223 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 62,066 buffers Checkpoint Peak
- 2026-07-25 00:09:44 Date
- 269.851 seconds Highest write time
- 0.039 seconds Sync time
Checkpoints Wal files
Key values
- 6 files Wal files usage Peak
- 2026-07-25 00:09:44 Date
Checkpoints distance
Key values
- 196.36 Mo Distance Peak
- 2026-07-25 00:09:44 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 25 00 76,551 653.735s 0.038s 653.842s 01 2,082 209.549s 0.054s 209.661s 02 1,690 169.903s 0.029s 169.995s 03 1,651 166.106s 0.03s 166.182s 04 1,985 199.541s 0.024s 199.61s 05 9,937 968.056s 0.118s 968.269s 06 5,161 269.763s 0.004s 269.789s 07 1,455 146.08s 0.013s 146.117s 08 22 2.236s 0.003s 2.247s 09 21 2.122s 0.005s 2.133s 10 22 2.231s 0.003s 2.242s 11 22 2.23s 0.004s 2.239s 12 440 44.458s 0.025s 44.51s 13 225 22.727s 0.01s 22.761s 14 27 2.741s 0.004s 2.756s 15 22 2.231s 0.003s 2.24s 16 21 2.13s 0.003s 2.139s 17 22 2.232s 0.003s 2.241s 18 648 65.086s 0.008s 65.113s 19 24 2.442s 0.005s 2.458s 20 126 12.701s 0.01s 12.726s 21 77 7.796s 0.007s 7.824s 22 21 2.118s 0.004s 2.126s 23 179 18.067s 0.01s 18.101s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 25 00 0 0 11 500 0.004s 0.007s 01 0 0 0 626 0.003s 0.01s 02 0 0 1 350 0.003s 0.009s 03 0 0 0 355 0.003s 0.006s 04 0 0 1 448 0.002s 0.006s 05 0 0 4 798 0.012s 0.01s 06 0 0 1 11 0.001s 0.001s 07 0 0 0 84 0.002s 0.004s 08 0 0 0 3 0.002s 0.001s 09 0 0 0 3 0.004s 0.002s 10 0 0 0 3 0.002s 0.001s 11 0 0 0 3 0.002s 0.002s 12 0 0 0 235 0.002s 0.005s 13 0 0 0 118 0.003s 0.004s 14 0 0 0 7 0.002s 0.002s 15 0 0 0 3 0.002s 0.001s 16 0 0 0 3 0.002s 0.001s 17 0 0 0 3 0.002s 0.001s 18 0 0 1 52 0.002s 0.003s 19 0 0 0 4 0.002s 0.003s 20 0 0 0 26 0.002s 0.003s 21 0 0 0 19 0.002s 0.003s 22 0 0 0 3 0.002s 0.002s 23 0 0 0 79 0.003s 0.006s Day Hour Count Avg time (sec) Jul 25 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Jul 25 00 25,020.00 kB 71,686.14 kB 01 1,152.44 kB 39,827.22 kB 02 1,160.88 kB 16,842.00 kB 03 1,268.29 kB 3,096.71 kB 04 1,700.83 kB 2,214.67 kB 05 6,683.80 kB 15,824.20 kB 06 9,249.00 kB 12,763.00 kB 07 1,860.75 kB 10,492.75 kB 08 173.00 kB 8,051.00 kB 09 173.00 kB 7,264.00 kB 10 174.00 kB 6,555.00 kB 11 173.00 kB 5,917.00 kB 12 627.80 kB 4,549.00 kB 13 227.25 kB 2,950.25 kB 14 94.50 kB 2,171.50 kB 15 171.00 kB 1,877.00 kB 16 170.00 kB 1,706.00 kB 17 171.00 kB 1,553.00 kB 18 794.33 kB 1,944.33 kB 19 89.00 kB 1,516.00 kB 20 402.00 kB 1,243.67 kB 21 118.67 kB 966.33 kB 22 171.00 kB 803.00 kB 23 132.50 kB 636.25 kB -
Temporary Files
Size of temporary files
Key values
- 474.31 MiB Temp Files size Peak
- 2026-07-25 05:32:05 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-07-25 05:32:11 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 25 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 10 1.08 GiB 110.25 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 921.21 MiB 70.74 MiB 237.16 MiB 115.15 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-25 05:32:14 Duration: 1m31s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-25 05:32:05 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 2 181.33 MiB 90.66 MiB 90.66 MiB 90.66 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-25 05:30:43 Duration: 41s247ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-25 05:30:40 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 237.16 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-25 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 237.16 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-25 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 90.66 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-25 05:30:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 90.66 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-25 05:30:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 78.25 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-25 05:32:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 78.18 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-25 05:32:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 78.18 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-25 05:32:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 70.81 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-25 05:32:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 70.74 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-25 05:32:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 70.74 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-25 05:32:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.19 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database rio - 2026-07-25 05:09:40 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 0.19 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database rio - 2026-07-25 05:09:40 Date
Analyzes per table
Key values
- public.temp0000286468 (8) Main table analyzed (database rio)
- 10 analyzes Total
Vacuums per table
Key values
- pg_catalog.pg_class (1) Main table vacuumed on database contagem
- 10 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples contagem.pg_catalog.pg_class 1 1 0 0 0 0 0 118 55 73,701 2 4 rio.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 893 138 897,827 102 296 rio.pg_catalog.pg_statistic 1 1 0 0 0 0 0 3,176 297 1,393,863 262 1,591 rio.public.temp0000286478 1 0 0 0 0 0 0 127 126 243,831 0 0 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,250 113 522,341 93 844 rio.public.temp0000286482 1 0 0 0 0 0 0 127 6 8,488 0 0 brasilia.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,477 40 273,500 22 214 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 136 28 75,827 6 13 brasilia.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 168 17 54,405 7 19 brasilia.pg_catalog.pg_attribute 1 1 0 0 0 0 0 599 221 237,566 0 0 Total 10 8 0 0 0 0 0 10,071 1,041 3,781,349 494 2,981 Vacuum throughput per table
Key values
- pg_catalog.pg_statistic (0.19) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed contagem.pg_catalog.pg_class 0 0 0.11 rio.pg_toast.pg_toast_2619 0 0 0.05 rio.pg_catalog.pg_statistic 0 0 0.19 rio.public.temp0000286478 0 0 0.02 contagem.pg_catalog.pg_statistic 0 0 0.1 rio.public.temp0000286482 0 0 0.02 brasilia.pg_catalog.pg_statistic 0 0 0.1 contagem.pg_toast.pg_toast_2619 0 0 0.02 brasilia.pg_toast.pg_toast_2619 0 0 0.02 brasilia.pg_catalog.pg_attribute 0 0 0.17 Total 0 0 0.8 Tuples removed per table
Key values
- pg_catalog.pg_statistic (4269) Main table with removed tuples on database contagem
- 15576 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain contagem.pg_catalog.pg_statistic 1 1 4,269 7,274 0 0 1,011 rio.pg_catalog.pg_statistic 1 1 4,187 7,510 0 0 1,286 brasilia.pg_catalog.pg_statistic 1 1 3,920 7,332 0 0 1,072 brasilia.pg_catalog.pg_attribute 1 1 2,164 21,012 0 65 531 rio.pg_toast.pg_toast_2619 1 1 665 671 0 0 285 contagem.pg_catalog.pg_class 1 1 129 3,982 0 0 221 brasilia.pg_toast.pg_toast_2619 1 1 127 135 0 8 61 contagem.pg_toast.pg_toast_2619 1 1 115 116 0 4 56 rio.public.temp0000286478 1 0 0 2,251 0 9 119 rio.public.temp0000286482 1 0 0 2,251 0 9 119 Total 10 8 15,576 52,534 0 95 4,761 Pages removed per table
Key values
- pg_catalog.pg_attribute (65) Main table with removed pages on database brasilia
- 95 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed brasilia.pg_catalog.pg_attribute 1 1 2164 65 rio.public.temp0000286478 1 0 0 9 rio.public.temp0000286482 1 0 0 9 brasilia.pg_toast.pg_toast_2619 1 1 127 8 contagem.pg_toast.pg_toast_2619 1 1 115 4 contagem.pg_catalog.pg_class 1 1 129 0 rio.pg_toast.pg_toast_2619 1 1 665 0 rio.pg_catalog.pg_statistic 1 1 4187 0 contagem.pg_catalog.pg_statistic 1 1 4269 0 brasilia.pg_catalog.pg_statistic 1 1 3920 0 Total 10 8 15,576 95 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 25 00 0 0 01 0 4 02 0 0 03 0 0 04 0 0 05 7 4 06 0 0 07 1 1 08 0 0 09 0 0 10 0 0 11 0 0 12 1 1 13 0 0 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 1 0 - 0.19 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
- 177 Total read queries
- 405 Total write queries
Queries by database
Key values
- rio Main database
- 473 Requests
- 2h58m17s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 927 Requests
User Request type Count Duration etiquetas Total 14 5s480ms select 14 5s480ms intelifix Total 927 4h27m16s copy to 399 52m33s ddl 6 28s920ms others 372 30m20s select 150 3h3m53s lenon Total 13 51s412ms select 13 51s412ms Duration by user
Key values
- 4h27m16s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 14 5s480ms select 14 5s480ms intelifix Total 927 4h27m16s copy to 399 52m33s ddl 6 28s920ms others 372 30m20s select 150 3h3m53s lenon Total 13 51s412ms select 13 51s412ms Queries by host
Key values
- [local] Main host
- 954 Requests
- 4h28m13s ([local])
- Main time consuming host
Queries by application
Key values
- psql Main application
- 480 Requests
- 3h34m48s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-25 01:05:02 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 367 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 9m58s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-25 07:15:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 9m29s analyze verbose;[ Date: 2026-07-25 05:09:31 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 8m22s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-25 21:13:24 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 6m54s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-25 20:11:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 6m44s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-25 11:11:45 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 6m32s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-25 22:11:33 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 6m28s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-25 10:11:30 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 6m27s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-25 13:11:28 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 6m25s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-25 17:11:27 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 6m25s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-25 15:11:27 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 6m18s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-25 14:11:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 6m17s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-25 08:11:18 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 6m14s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-25 12:11:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 6m12s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-25 16:11:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 6m9s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-25 09:11:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 6m7s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-25 18:11:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 6m5s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-25 19:11:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 4m26s analyze verbose;[ Date: 2026-07-25 05:13:58 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
19 4m13s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-07-25 07:20:56 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
20 3m53s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-07-25 22:16:24 - 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 1h53m23s 48 1s167ms 9m58s 2m21s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 25 07 3 10m36s 3m32s 08 3 6m37s 2m12s 09 3 6m31s 2m10s 10 3 6m48s 2m16s 11 3 7m4s 2m21s 12 3 6m32s 2m10s 13 3 6m45s 2m15s 14 3 6m38s 2m12s 15 3 6m45s 2m15s 16 3 6m33s 2m11s 17 3 6m44s 2m14s 18 3 6m24s 2m8s 19 3 6m25s 2m8s 20 3 7m21s 2m27s 21 3 8m41s 2m53s 22 3 6m51s 2m17s [ User: intelifix - Total duration: 1h53m23s - Times executed: 48 ]
[ Application: psql - Total duration: 1h53m23s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-25 07:15:00 Duration: 9m58s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-25 21:13:24 Duration: 8m22s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-25 20:11:56 Duration: 6m54s Database: rio User: intelifix Remote: [local] Application: psql
2 1h10m11s 48 196ms 4m13s 1m27s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 25 07 3 5m25s 1m48s 08 3 4m23s 1m27s 09 3 4m29s 1m29s 10 3 4m25s 1m28s 11 3 4m31s 1m30s 12 3 3m55s 1m18s 13 3 4m16s 1m25s 14 3 4m13s 1m24s 15 3 4m21s 1m27s 16 3 4m21s 1m27s 17 3 4m15s 1m25s 18 3 4m7s 1m22s 19 3 4m6s 1m22s 20 3 4m39s 1m33s 21 3 4m4s 1m21s 22 3 4m34s 1m31s [ User: intelifix - Total duration: 1h10m11s - Times executed: 48 ]
[ Application: psql - Total duration: 1h10m11s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-25 07:20:56 Duration: 4m13s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-25 22:16:24 Duration: 3m53s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-25 11:16:35 Duration: 3m53s Database: brasilia User: intelifix Remote: [local] Application: psql
3 16m33s 3 2m36s 9m29s 5m31s analyze verbose;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 25 05 3 16m33s 5m31s [ User: intelifix - Total duration: 16m33s - Times executed: 3 ]
[ Application: psql - Total duration: 16m33s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-25 05:09:31 Duration: 9m29s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-25 05:13:58 Duration: 4m26s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-25 05:16:35 Duration: 2m36s Database: contagem User: intelifix Remote: [local] Application: psql
4 8m22s 276 206ms 9s850ms 1s821ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 25 00 12 27s572ms 2s297ms 01 12 19s413ms 1s617ms 02 12 19s996ms 1s666ms 03 12 22s294ms 1s857ms 04 12 19s716ms 1s643ms 05 12 22s444ms 1s870ms 06 12 21s466ms 1s788ms 07 12 22s227ms 1s852ms 08 12 21s767ms 1s813ms 09 12 22s997ms 1s916ms 10 12 19s900ms 1s658ms 11 12 21s502ms 1s791ms 12 12 21s212ms 1s767ms 13 12 20s296ms 1s691ms 14 12 22s613ms 1s884ms 15 12 22s101ms 1s841ms 16 12 20s604ms 1s717ms 17 12 20s119ms 1s676ms 18 12 18s785ms 1s565ms 19 12 20s845ms 1s737ms 20 12 32s716ms 2s726ms 21 12 21s566ms 1s797ms 22 12 20s687ms 1s723ms [ User: intelifix - Total duration: 8m22s - Times executed: 276 ]
[ Application: psql - Total duration: 8m22s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-25 00:05:23 Duration: 9s850ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-25 20:05:10 Duration: 9s26ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-25 20:15:10 Duration: 8s328ms Database: rio User: intelifix Remote: [local] Application: psql
5 3m18s 4 4s297ms 1m44s 49s579ms 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 Jul 25 20 2 1m28s 44s213ms 23 2 1m49s 54s944ms [ User: intelifix - Total duration: 3m18s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m18s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-25 23:17:46 Duration: 1m44s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-25 20:08:27 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-25 23:42:05 Duration: 5s395ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 2m8s 4 330ms 1m10s 32s73ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 25 20 2 57s404ms 28s702ms 23 2 1m10s 35s445ms [ User: intelifix - Total duration: 2m8s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m8s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-25 23:14:03 Duration: 1m10s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-25 20:05:26 Duration: 57s73ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-25 23:41:27 Duration: 475ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 1m31s 1 1m31s 1m31s 1m31s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 25 05 1 1m31s 1m31s [ User: intelifix - Total duration: 1m31s - Times executed: 1 ]
[ Application: psql - Total duration: 1m31s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-25 05:32:14 Duration: 1m31s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-25 05:32:05 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
8 1m30s 6 2s730ms 34s117ms 15s81ms copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 25 20 3 42s671ms 14s223ms 23 3 47s817ms 15s939ms [ User: intelifix - Total duration: 1m30s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m30s - 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-07-25 23:14:39 Duration: 34s117ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-07-25 20:05:58 Duration: 30s626ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-07-25 23:41:38 Duration: 10s126ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
9 1m19s 6 1s771ms 33s912ms 13s236ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 25 20 3 35s647ms 11s882ms 23 3 43s772ms 14s590ms [ User: intelifix - Total duration: 1m19s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m19s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-25 23:15:17 Duration: 33s912ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-25 20:06:29 Duration: 27s746ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-25 23:41:45 Duration: 6s954ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 1m18s 6 8s262ms 18s29ms 13s15ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 25 00 3 52s185ms 17s395ms 06 3 25s904ms 8s634ms [ User: intelifix - Total duration: 1m18s - Times executed: 6 ]
[ Application: psql - Total duration: 1m18s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-25 00:05:54 Duration: 18s29ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-25 00:05:20 Duration: 17s884ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-25 00:05:36 Duration: 16s271ms Database: brasilia User: intelifix Remote: [local] Application: psql
11 1m11s 6 2s853ms 28s29ms 11s994ms 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 Jul 25 20 3 34s155ms 11s385ms 23 3 37s810ms 12s603ms [ User: intelifix - Total duration: 1m11s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m11s - 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-07-25 23:18:14 Duration: 28s29ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-07-25 20:08:53 Duration: 26s144ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-07-25 23:42:11 Duration: 5s641ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 1m2s 6 1s747ms 22s429ms 10s426ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 25 20 3 29s370ms 9s790ms 23 3 33s190ms 11s63ms [ User: intelifix - Total duration: 1m2s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m2s - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-25 23:11:29 Duration: 22s429ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-25 20:03:16 Duration: 19s840ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-25 23:41:06 Duration: 8s370ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 1m2s 34 226ms 12s115ms 1s833ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 25 00 6 18s410ms 3s68ms 01 6 7s163ms 1s193ms 02 5 8s167ms 1s633ms 03 5 7s805ms 1s561ms 04 6 10s70ms 1s678ms 05 6 10s715ms 1s785ms [ User: intelifix - Total duration: 1m2s - Times executed: 34 ]
[ Application: psql - Total duration: 1m2s - Times executed: 34 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-25 00:05:13 Duration: 12s115ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-25 05:35:05 Duration: 4s41ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-25 03:15:04 Duration: 3s177ms Database: rio User: intelifix Remote: [local] Application: psql
14 1m 6 1s724ms 21s577ms 10s127ms 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 Jul 25 20 3 28s818ms 9s606ms 23 3 31s943ms 10s647ms [ User: intelifix - Total duration: 1m - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-25 23:10:50 Duration: 21s577ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-25 20:02:43 Duration: 19s494ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-25 23:40:55 Duration: 8s479ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 59s66ms 6 1s271ms 25s478ms 9s844ms 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 Jul 25 20 3 26s233ms 8s744ms 23 3 32s832ms 10s944ms [ User: intelifix - Total duration: 59s66ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 59s66ms - 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-07-25 23:12:31 Duration: 25s478ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-07-25 20:04:08 Duration: 20s514ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-07-25 23:41:23 Duration: 5s466ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 50s436ms 4 3s646ms 21s776ms 12s609ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 25 20 2 25s13ms 12s506ms 23 2 25s423ms 12s711ms [ User: intelifix - Total duration: 50s436ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 50s436ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-07-25 23:12:53 Duration: 21s776ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-07-25 20:04:29 Duration: 20s495ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-07-25 20:09:40 Duration: 4s518ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 48s580ms 6 3s603ms 16s529ms 8s96ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 25 00 3 24s647ms 8s215ms 06 3 23s932ms 7s977ms [ User: lenon - Total duration: 48s580ms - Times executed: 6 ]
[ Application: psql - Total duration: 48s580ms - Times executed: 6 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-07-25 00:02:18 Duration: 16s529ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-07-25 06:02:18 Duration: 16s414ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-07-25 00:02:22 Duration: 4s298ms Database: brasilia User: lenon Remote: [local] Application: psql
18 48s572ms 6 1s353ms 16s327ms 8s95ms 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 #18
Day Hour Count Duration Avg duration Jul 25 20 3 23s68ms 7s689ms 23 3 25s504ms 8s501ms [ User: intelifix - Total duration: 48s572ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 48s572ms - 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-07-25 23:11:45 Duration: 16s327ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
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-07-25 20:03:31 Duration: 15s81ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
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-07-25 23:41:13 Duration: 7s688ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 41s247ms 1 41s247ms 41s247ms 41s247ms refresh materialized view concurrently rs_mv_equipamentos;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 25 05 1 41s247ms 41s247ms [ User: intelifix - Total duration: 41s247ms - Times executed: 1 ]
[ Application: psql - Total duration: 41s247ms - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-25 05:30:43 Duration: 41s247ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-25 05:30:40 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
20 38s940ms 6 2s882ms 10s22ms 6s490ms copy public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 25 20 3 15s645ms 5s215ms 23 3 23s295ms 7s765ms [ User: intelifix - Total duration: 38s940ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 38s940ms - Times executed: 6 ]
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-07-25 23:15:47 Duration: 10s22ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-07-25 23:41:58 Duration: 8s789ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-07-25 20:06:50 Duration: 6s405ms Database: rio User: intelifix Remote: [local] Application: pg_dump
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 276 8m22s 206ms 9s850ms 1s821ms call rs_giga_triagem (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 25 00 12 27s572ms 2s297ms 01 12 19s413ms 1s617ms 02 12 19s996ms 1s666ms 03 12 22s294ms 1s857ms 04 12 19s716ms 1s643ms 05 12 22s444ms 1s870ms 06 12 21s466ms 1s788ms 07 12 22s227ms 1s852ms 08 12 21s767ms 1s813ms 09 12 22s997ms 1s916ms 10 12 19s900ms 1s658ms 11 12 21s502ms 1s791ms 12 12 21s212ms 1s767ms 13 12 20s296ms 1s691ms 14 12 22s613ms 1s884ms 15 12 22s101ms 1s841ms 16 12 20s604ms 1s717ms 17 12 20s119ms 1s676ms 18 12 18s785ms 1s565ms 19 12 20s845ms 1s737ms 20 12 32s716ms 2s726ms 21 12 21s566ms 1s797ms 22 12 20s687ms 1s723ms [ User: intelifix - Total duration: 8m22s - Times executed: 276 ]
[ Application: psql - Total duration: 8m22s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-25 00:05:23 Duration: 9s850ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-25 20:05:10 Duration: 9s26ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-25 20:15:10 Duration: 8s328ms Database: rio User: intelifix Remote: [local] Application: psql
2 48 1h53m23s 1s167ms 9m58s 2m21s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 25 07 3 10m36s 3m32s 08 3 6m37s 2m12s 09 3 6m31s 2m10s 10 3 6m48s 2m16s 11 3 7m4s 2m21s 12 3 6m32s 2m10s 13 3 6m45s 2m15s 14 3 6m38s 2m12s 15 3 6m45s 2m15s 16 3 6m33s 2m11s 17 3 6m44s 2m14s 18 3 6m24s 2m8s 19 3 6m25s 2m8s 20 3 7m21s 2m27s 21 3 8m41s 2m53s 22 3 6m51s 2m17s [ User: intelifix - Total duration: 1h53m23s - Times executed: 48 ]
[ Application: psql - Total duration: 1h53m23s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-25 07:15:00 Duration: 9m58s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-25 21:13:24 Duration: 8m22s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-25 20:11:56 Duration: 6m54s Database: rio User: intelifix Remote: [local] Application: psql
3 48 1h10m11s 196ms 4m13s 1m27s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 25 07 3 5m25s 1m48s 08 3 4m23s 1m27s 09 3 4m29s 1m29s 10 3 4m25s 1m28s 11 3 4m31s 1m30s 12 3 3m55s 1m18s 13 3 4m16s 1m25s 14 3 4m13s 1m24s 15 3 4m21s 1m27s 16 3 4m21s 1m27s 17 3 4m15s 1m25s 18 3 4m7s 1m22s 19 3 4m6s 1m22s 20 3 4m39s 1m33s 21 3 4m4s 1m21s 22 3 4m34s 1m31s [ User: intelifix - Total duration: 1h10m11s - Times executed: 48 ]
[ Application: psql - Total duration: 1h10m11s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-25 07:20:56 Duration: 4m13s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-25 22:16:24 Duration: 3m53s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-25 11:16:35 Duration: 3m53s Database: brasilia User: intelifix Remote: [local] Application: psql
4 34 1m2s 226ms 12s115ms 1s833ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 25 00 6 18s410ms 3s68ms 01 6 7s163ms 1s193ms 02 5 8s167ms 1s633ms 03 5 7s805ms 1s561ms 04 6 10s70ms 1s678ms 05 6 10s715ms 1s785ms [ User: intelifix - Total duration: 1m2s - Times executed: 34 ]
[ Application: psql - Total duration: 1m2s - Times executed: 34 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-25 00:05:13 Duration: 12s115ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-25 05:35:05 Duration: 4s41ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-25 03:15:04 Duration: 3s177ms Database: rio User: intelifix Remote: [local] Application: psql
5 34 36s588ms 637ms 3s29ms 1s76ms 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 #5
Day Hour Count Duration Avg duration Jul 25 08 2 3s814ms 1s907ms 09 2 2s851ms 1s425ms 10 2 1s832ms 916ms 11 3 2s435ms 811ms 12 2 2s18ms 1s9ms 13 1 1s109ms 1s109ms 14 3 2s869ms 956ms 15 3 3s857ms 1s285ms 16 3 3s727ms 1s242ms 17 2 1s896ms 948ms 18 2 1s974ms 987ms 19 2 1s625ms 812ms 20 2 1s975ms 987ms 21 3 2s766ms 922ms 22 2 1s834ms 917ms [ User: intelifix - Total duration: 36s588ms - Times executed: 34 ]
[ Application: psql - Total duration: 36s588ms - Times executed: 34 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-25 08:00:04 Duration: 3s29ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-25 16:20:03 Duration: 2s137ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-25 15:20:03 Duration: 1s957ms Database: rio User: intelifix Remote: [local] Application: psql
6 11 13s595ms 683ms 2s231ms 1s235ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 25 08 1 1s222ms 1s222ms 09 1 753ms 753ms 10 1 749ms 749ms 12 1 683ms 683ms 13 2 3s527ms 1s763ms 17 1 1s91ms 1s91ms 18 1 1s91ms 1s91ms 19 1 1s110ms 1s110ms 20 1 2s231ms 2s231ms 22 1 1s133ms 1s133ms [ User: intelifix - Total duration: 13s595ms - Times executed: 11 ]
[ Application: psql - Total duration: 13s595ms - Times executed: 11 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-07-25 20:20:04 Duration: 2s231ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-07-25 13:20:03 Duration: 2s88ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-07-25 13:00:02 Duration: 1s438ms Database: rio User: intelifix Remote: [local] Application: psql
7 11 4s848ms 153ms 1s507ms 440ms select * from rs_etiqueta (?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 25 00 2 497ms 248ms 01 1 153ms 153ms 03 2 540ms 270ms 04 1 207ms 207ms 20 1 192ms 192ms 23 4 3s258ms 814ms [ User: etiquetas - Total duration: 4s848ms - Times executed: 11 ]
[ Application: [unknown] - Total duration: 4s848ms - Times executed: 11 ]
-
SELECT * FROM RS_ETIQUETA ('');
Date: 2026-07-25 23:41:17 Duration: 1s507ms Database: rio User: etiquetas Remote: [local] Application: [unknown] Bind query: yes
-
SELECT * FROM RS_ETIQUETA ('');
Date: 2026-07-25 23:26:01 Duration: 1s195ms Database: rio User: etiquetas Remote: [local] Application: [unknown] Bind query: yes
-
SELECT * FROM RS_ETIQUETA ('');
Date: 2026-07-25 23:46:21 Duration: 392ms Database: rio User: etiquetas Remote: [local] Application: [unknown] Bind query: yes
8 9 2s380ms 160ms 717ms 264ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 25 01 1 185ms 185ms 05 8 2s194ms 274ms [ User: intelifix - Total duration: 2s380ms - Times executed: 9 ]
[ Application: [unknown] - Total duration: 2s380ms - Times executed: 9 ]
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '241784090913,241736022832,241783533047,241783390407,241751087085,241736024852,241783519611,241734986479,241755031130,241718998790,241720815556,241757673340,241748196769,241724129909,241757005968,241751073751', NULL, NULL, 0463, 00);
Date: 2026-07-25 05:07:01 Duration: 717ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '241719207980,241781735778,241748759103,241735824754,241724046668,241751807088,241723120709,241753897797,241753895777,241781724666,241737438188,241755566063,241725503242', NULL, NULL, 0463, 00);
Date: 2026-07-25 05:08:09 Duration: 321ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '241755715977,241749972645,241720426977,241720356970,241757253344,241734573656,241734554260,241758244058,241754220815,241750403450,241752388693,241780504356,241749102324,241734548097,241750340818,241752841522,241737870611', NULL, NULL, 0463, 00);
Date: 2026-07-25 05:12:01 Duration: 215ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 8 2s267ms 153ms 579ms 283ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 25 12 8 2s267ms 283ms [ User: intelifix - Total duration: 2s267ms - Times executed: 8 ]
[ Application: [unknown] - Total duration: 2s267ms - Times executed: 8 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (270589, 304, '831277940000564,229902565058,229908940103,229915819719,229915959407,229909988802,229897844059', '',0263,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""}]','$$$$$','', 00);
Date: 2026-07-25 12:24:03 Duration: 579ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (270832, 304, '820079912000670,229804203248', '246600622236', 0145, 00, '[{"item":"0","qrcode":""}]', '','', 00);
Date: 2026-07-25 12:21:31 Duration: 361ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (270570, 304, '270911029142102054,229735106874', '246526551730,,,,,,,,,,,,,,', 0141, 00, '[{"item":"0","qrcode":""}]', '$$$$$$$$$$$$$$', '', 00);
Date: 2026-07-25 12:22:22 Duration: 280ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 7 2s832ms 360ms 489ms 404ms select pro_id, pgp_sym_decrypt(nome, ?)::varchar, pgp_sym_decrypt(descricao, ?)::varchar, pgp_sym_decrypt(classe, ?)::varchar, pgp_sym_decrypt(php, ?)::varchar, pgp_sym_decrypt(extras, ?)::varchar from progs order by pro_id;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 25 01 2 731ms 365ms 05 3 1s214ms 404ms 07 1 396ms 396ms 12 1 489ms 489ms [ User: lenon - Total duration: 2s832ms - Times executed: 7 ]
[ Application: [unknown] - Total duration: 2s832ms - 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-07-25 12:17:02 Duration: 489ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-07-25 05:35:39 Duration: 410ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-07-25 05:06:25 Duration: 407ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
11 6 1m30s 2s730ms 34s117ms 15s81ms 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 #11
Day Hour Count Duration Avg duration Jul 25 20 3 42s671ms 14s223ms 23 3 47s817ms 15s939ms [ User: intelifix - Total duration: 1m30s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m30s - 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-07-25 23:14:39 Duration: 34s117ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-07-25 20:05:58 Duration: 30s626ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-07-25 23:41:38 Duration: 10s126ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 6 1m19s 1s771ms 33s912ms 13s236ms 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 Jul 25 20 3 35s647ms 11s882ms 23 3 43s772ms 14s590ms [ User: intelifix - Total duration: 1m19s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m19s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-25 23:15:17 Duration: 33s912ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-25 20:06:29 Duration: 27s746ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-25 23:41:45 Duration: 6s954ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 6 1m18s 8s262ms 18s29ms 13s15ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 25 00 3 52s185ms 17s395ms 06 3 25s904ms 8s634ms [ User: intelifix - Total duration: 1m18s - Times executed: 6 ]
[ Application: psql - Total duration: 1m18s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-25 00:05:54 Duration: 18s29ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-25 00:05:20 Duration: 17s884ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-25 00:05:36 Duration: 16s271ms Database: brasilia User: intelifix Remote: [local] Application: psql
14 6 1m11s 2s853ms 28s29ms 11s994ms 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 #14
Day Hour Count Duration Avg duration Jul 25 20 3 34s155ms 11s385ms 23 3 37s810ms 12s603ms [ User: intelifix - Total duration: 1m11s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m11s - 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-07-25 23:18:14 Duration: 28s29ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-07-25 20:08:53 Duration: 26s144ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-07-25 23:42:11 Duration: 5s641ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 6 1m2s 1s747ms 22s429ms 10s426ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 25 20 3 29s370ms 9s790ms 23 3 33s190ms 11s63ms [ User: intelifix - Total duration: 1m2s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m2s - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-25 23:11:29 Duration: 22s429ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-25 20:03:16 Duration: 19s840ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-25 23:41:06 Duration: 8s370ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 6 1m 1s724ms 21s577ms 10s127ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 25 20 3 28s818ms 9s606ms 23 3 31s943ms 10s647ms [ User: intelifix - Total duration: 1m - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-25 23:10:50 Duration: 21s577ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-25 20:02:43 Duration: 19s494ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-25 23:40:55 Duration: 8s479ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 6 59s66ms 1s271ms 25s478ms 9s844ms 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 Jul 25 20 3 26s233ms 8s744ms 23 3 32s832ms 10s944ms [ User: intelifix - Total duration: 59s66ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 59s66ms - 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-07-25 23:12:31 Duration: 25s478ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-07-25 20:04:08 Duration: 20s514ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-07-25 23:41:23 Duration: 5s466ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 6 48s580ms 3s603ms 16s529ms 8s96ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 25 00 3 24s647ms 8s215ms 06 3 23s932ms 7s977ms [ User: lenon - Total duration: 48s580ms - Times executed: 6 ]
[ Application: psql - Total duration: 48s580ms - Times executed: 6 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-07-25 00:02:18 Duration: 16s529ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-07-25 06:02:18 Duration: 16s414ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-07-25 00:02:22 Duration: 4s298ms Database: brasilia User: lenon Remote: [local] Application: psql
19 6 48s572ms 1s353ms 16s327ms 8s95ms 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 #19
Day Hour Count Duration Avg duration Jul 25 20 3 23s68ms 7s689ms 23 3 25s504ms 8s501ms [ User: intelifix - Total duration: 48s572ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 48s572ms - 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-07-25 23:11:45 Duration: 16s327ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
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-07-25 20:03:31 Duration: 15s81ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
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-07-25 23:41:13 Duration: 7s688ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 6 38s940ms 2s882ms 10s22ms 6s490ms copy public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 25 20 3 15s645ms 5s215ms 23 3 23s295ms 7s765ms [ User: intelifix - Total duration: 38s940ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 38s940ms - Times executed: 6 ]
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-07-25 23:15:47 Duration: 10s22ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-07-25 23:41:58 Duration: 8s789ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-07-25 20:06:50 Duration: 6s405ms Database: rio User: intelifix Remote: [local] Application: pg_dump
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m36s 9m29s 5m31s 3 16m33s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 25 05 3 16m33s 5m31s [ User: intelifix - Total duration: 16m33s - Times executed: 3 ]
[ Application: psql - Total duration: 16m33s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-25 05:09:31 Duration: 9m29s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-25 05:13:58 Duration: 4m26s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-25 05:16:35 Duration: 2m36s Database: contagem User: intelifix Remote: [local] Application: psql
2 1s167ms 9m58s 2m21s 48 1h53m23s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 25 07 3 10m36s 3m32s 08 3 6m37s 2m12s 09 3 6m31s 2m10s 10 3 6m48s 2m16s 11 3 7m4s 2m21s 12 3 6m32s 2m10s 13 3 6m45s 2m15s 14 3 6m38s 2m12s 15 3 6m45s 2m15s 16 3 6m33s 2m11s 17 3 6m44s 2m14s 18 3 6m24s 2m8s 19 3 6m25s 2m8s 20 3 7m21s 2m27s 21 3 8m41s 2m53s 22 3 6m51s 2m17s [ User: intelifix - Total duration: 1h53m23s - Times executed: 48 ]
[ Application: psql - Total duration: 1h53m23s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-25 07:15:00 Duration: 9m58s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-25 21:13:24 Duration: 8m22s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-25 20:11:56 Duration: 6m54s Database: rio User: intelifix Remote: [local] Application: psql
3 1m31s 1m31s 1m31s 1 1m31s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 25 05 1 1m31s 1m31s [ User: intelifix - Total duration: 1m31s - Times executed: 1 ]
[ Application: psql - Total duration: 1m31s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-25 05:32:14 Duration: 1m31s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-25 05:32:05 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
4 196ms 4m13s 1m27s 48 1h10m11s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 25 07 3 5m25s 1m48s 08 3 4m23s 1m27s 09 3 4m29s 1m29s 10 3 4m25s 1m28s 11 3 4m31s 1m30s 12 3 3m55s 1m18s 13 3 4m16s 1m25s 14 3 4m13s 1m24s 15 3 4m21s 1m27s 16 3 4m21s 1m27s 17 3 4m15s 1m25s 18 3 4m7s 1m22s 19 3 4m6s 1m22s 20 3 4m39s 1m33s 21 3 4m4s 1m21s 22 3 4m34s 1m31s [ User: intelifix - Total duration: 1h10m11s - Times executed: 48 ]
[ Application: psql - Total duration: 1h10m11s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-25 07:20:56 Duration: 4m13s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-25 22:16:24 Duration: 3m53s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-25 11:16:35 Duration: 3m53s Database: brasilia User: intelifix Remote: [local] Application: psql
5 4s297ms 1m44s 49s579ms 4 3m18s 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 Jul 25 20 2 1m28s 44s213ms 23 2 1m49s 54s944ms [ User: intelifix - Total duration: 3m18s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m18s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-25 23:17:46 Duration: 1m44s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-25 20:08:27 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-25 23:42:05 Duration: 5s395ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 41s247ms 41s247ms 41s247ms 1 41s247ms refresh materialized view concurrently rs_mv_equipamentos;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 25 05 1 41s247ms 41s247ms [ User: intelifix - Total duration: 41s247ms - Times executed: 1 ]
[ Application: psql - Total duration: 41s247ms - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-25 05:30:43 Duration: 41s247ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-25 05:30:40 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
7 330ms 1m10s 32s73ms 4 2m8s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 25 20 2 57s404ms 28s702ms 23 2 1m10s 35s445ms [ User: intelifix - Total duration: 2m8s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m8s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-25 23:14:03 Duration: 1m10s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-25 20:05:26 Duration: 57s73ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-25 23:41:27 Duration: 475ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 2s730ms 34s117ms 15s81ms 6 1m30s copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 25 20 3 42s671ms 14s223ms 23 3 47s817ms 15s939ms [ User: intelifix - Total duration: 1m30s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m30s - 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-07-25 23:14:39 Duration: 34s117ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-07-25 20:05:58 Duration: 30s626ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-07-25 23:41:38 Duration: 10s126ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
9 1s771ms 33s912ms 13s236ms 6 1m19s copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 25 20 3 35s647ms 11s882ms 23 3 43s772ms 14s590ms [ User: intelifix - Total duration: 1m19s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m19s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-25 23:15:17 Duration: 33s912ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-25 20:06:29 Duration: 27s746ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-25 23:41:45 Duration: 6s954ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 8s262ms 18s29ms 13s15ms 6 1m18s call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 25 00 3 52s185ms 17s395ms 06 3 25s904ms 8s634ms [ User: intelifix - Total duration: 1m18s - Times executed: 6 ]
[ Application: psql - Total duration: 1m18s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-25 00:05:54 Duration: 18s29ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-25 00:05:20 Duration: 17s884ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-25 00:05:36 Duration: 16s271ms Database: brasilia User: intelifix Remote: [local] Application: psql
11 3s646ms 21s776ms 12s609ms 4 50s436ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 25 20 2 25s13ms 12s506ms 23 2 25s423ms 12s711ms [ User: intelifix - Total duration: 50s436ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 50s436ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-07-25 23:12:53 Duration: 21s776ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-07-25 20:04:29 Duration: 20s495ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-07-25 20:09:40 Duration: 4s518ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 2s853ms 28s29ms 11s994ms 6 1m11s 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 #12
Day Hour Count Duration Avg duration Jul 25 20 3 34s155ms 11s385ms 23 3 37s810ms 12s603ms [ User: intelifix - Total duration: 1m11s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m11s - 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-07-25 23:18:14 Duration: 28s29ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-07-25 20:08:53 Duration: 26s144ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-07-25 23:42:11 Duration: 5s641ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 1s747ms 22s429ms 10s426ms 6 1m2s 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 Jul 25 20 3 29s370ms 9s790ms 23 3 33s190ms 11s63ms [ User: intelifix - Total duration: 1m2s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m2s - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-25 23:11:29 Duration: 22s429ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-25 20:03:16 Duration: 19s840ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-25 23:41:06 Duration: 8s370ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 1s724ms 21s577ms 10s127ms 6 1m 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 Jul 25 20 3 28s818ms 9s606ms 23 3 31s943ms 10s647ms [ User: intelifix - Total duration: 1m - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-25 23:10:50 Duration: 21s577ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-25 20:02:43 Duration: 19s494ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-25 23:40:55 Duration: 8s479ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 1s271ms 25s478ms 9s844ms 6 59s66ms 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 Jul 25 20 3 26s233ms 8s744ms 23 3 32s832ms 10s944ms [ User: intelifix - Total duration: 59s66ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 59s66ms - 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-07-25 23:12:31 Duration: 25s478ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-07-25 20:04:08 Duration: 20s514ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-07-25 23:41:23 Duration: 5s466ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 3s603ms 16s529ms 8s96ms 6 48s580ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 25 00 3 24s647ms 8s215ms 06 3 23s932ms 7s977ms [ User: lenon - Total duration: 48s580ms - Times executed: 6 ]
[ Application: psql - Total duration: 48s580ms - Times executed: 6 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-07-25 00:02:18 Duration: 16s529ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-07-25 06:02:18 Duration: 16s414ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-07-25 00:02:22 Duration: 4s298ms Database: brasilia User: lenon Remote: [local] Application: psql
17 1s353ms 16s327ms 8s95ms 6 48s572ms 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 #17
Day Hour Count Duration Avg duration Jul 25 20 3 23s68ms 7s689ms 23 3 25s504ms 8s501ms [ User: intelifix - Total duration: 48s572ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 48s572ms - 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-07-25 23:11:45 Duration: 16s327ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
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-07-25 20:03:31 Duration: 15s81ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
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-07-25 23:41:13 Duration: 7s688ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 2s882ms 10s22ms 6s490ms 6 38s940ms copy public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 25 20 3 15s645ms 5s215ms 23 3 23s295ms 7s765ms [ User: intelifix - Total duration: 38s940ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 38s940ms - Times executed: 6 ]
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-07-25 23:15:47 Duration: 10s22ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-07-25 23:41:58 Duration: 8s789ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-07-25 20:06:50 Duration: 6s405ms Database: rio User: intelifix Remote: [local] Application: pg_dump
19 226ms 12s115ms 1s833ms 34 1m2s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 25 00 6 18s410ms 3s68ms 01 6 7s163ms 1s193ms 02 5 8s167ms 1s633ms 03 5 7s805ms 1s561ms 04 6 10s70ms 1s678ms 05 6 10s715ms 1s785ms [ User: intelifix - Total duration: 1m2s - Times executed: 34 ]
[ Application: psql - Total duration: 1m2s - Times executed: 34 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-25 00:05:13 Duration: 12s115ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-25 05:35:05 Duration: 4s41ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-25 03:15:04 Duration: 3s177ms Database: rio User: intelifix Remote: [local] Application: psql
20 206ms 9s850ms 1s821ms 276 8m22s call rs_giga_triagem (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 25 00 12 27s572ms 2s297ms 01 12 19s413ms 1s617ms 02 12 19s996ms 1s666ms 03 12 22s294ms 1s857ms 04 12 19s716ms 1s643ms 05 12 22s444ms 1s870ms 06 12 21s466ms 1s788ms 07 12 22s227ms 1s852ms 08 12 21s767ms 1s813ms 09 12 22s997ms 1s916ms 10 12 19s900ms 1s658ms 11 12 21s502ms 1s791ms 12 12 21s212ms 1s767ms 13 12 20s296ms 1s691ms 14 12 22s613ms 1s884ms 15 12 22s101ms 1s841ms 16 12 20s604ms 1s717ms 17 12 20s119ms 1s676ms 18 12 18s785ms 1s565ms 19 12 20s845ms 1s737ms 20 12 32s716ms 2s726ms 21 12 21s566ms 1s797ms 22 12 20s687ms 1s723ms [ User: intelifix - Total duration: 8m22s - Times executed: 276 ]
[ Application: psql - Total duration: 8m22s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-25 00:05:23 Duration: 9s850ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-25 20:05:10 Duration: 9s26ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-25 20:15:10 Duration: 8s328ms Database: rio User: intelifix Remote: [local] Application: psql
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 10 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jul 25 09 2 0ms 0ms 10 1 0ms 0ms 12 2 0ms 0ms 13 1 0ms 0ms 18 1 0ms 0ms 19 2 0ms 0ms 20 1 0ms 0ms [ User: intelifix - Total duration: 9m48s - Times executed: 10 ]
[ Application: psql - Total duration: 9m48s - Times executed: 10 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 5,960 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 25 FATAL entries
- 1835 ERROR entries
- 0 WARNING entries
- 1 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 1,740 Max number of times the same event was reported
- 1,861 Total events found
Rank Times reported Error 1 1,740 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 25 00 117 01 129 02 113 03 111 04 109 05 95 06 59 07 59 08 59 09 59 10 60 11 59 12 59 13 60 14 59 15 59 16 60 17 59 18 60 19 59 20 59 21 60 22 59 23 58 - ERROR: prepared statement "_PLAN000000002A1944A0" does not exist
- ERROR: prepared statement "_PLAN000000002ED02990" does not exist
- ERROR: prepared statement "_PLAN000000002E951820" does not exist
Statement: DEALLOCATE "_PLAN000000002A1944A0"
Date: 2026-07-25 00:00:00 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN000000002ED02990"
Date: 2026-07-25 00:00:16 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN000000002E951820"
Date: 2026-07-25 00:01:17 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 44 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #2
Day Hour Count Jul 25 08 3 09 2 10 3 11 3 12 3 13 3 14 3 15 3 16 3 17 3 18 3 19 3 20 3 21 3 22 3 - ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-25 08:00:06 Database: brasilia Application: psql User: intelifix Remote: [local]
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-25 08:20:03 Database: brasilia Application: psql User: intelifix Remote: [local]
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-25 08:40:03 Database: brasilia Application: psql User: intelifix Remote: [local]
3 43 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #3
Day Hour Count Jul 25 00 2 01 2 02 2 03 2 04 2 05 2 06 2 07 2 08 2 09 1 10 2 11 2 12 1 13 2 14 2 15 2 16 2 17 2 18 2 19 2 20 1 21 2 22 2 - ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-25 00:05:02 Database: brasilia Application: psql User: intelifix Remote: [local]
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-25 00:35:01 Database: brasilia Application: psql User: intelifix Remote: [local]
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-25 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
4 13 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Jul 25 00 1 06 2 07 1 09 2 14 1 17 1 18 2 20 2 23 1 - FATAL: database "testes" does not exist
- FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-07-25 00:02:26 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-07-25 06:02:25 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-07-25 06:55:47 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
5 9 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #5
Day Hour Count Jul 25 03 9 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-07-25 03:05:02 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-07-25 03:05:02 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Context: PL/pgSQL expression "TRIM( TO_CHAR( CURRENT_DATE , 'YYYY' ) )" PL/pgSQL function rs_giga_processa_arquivos() line 28 during statement block local variable initialization
Statement: CALL RS_GIGA_PROCESSA_ARQUIVOS()Date: 2026-07-25 03:05:02 Database: rio Application: psql User: intelifix Remote: [local]
6 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #6
Day Hour Count Jul 25 05 4 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-25 05:32:14 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-25 05:32:14 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-25 05:32:14 Database: contagem Application: psql User: intelifix Remote: [local]
7 3 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #7
Day Hour Count Jul 25 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-07-25 03:05:02 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-07-25 03:05:02 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-07-25 03:05:02 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
8 3 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 #8
Day Hour Count Jul 25 09 1 12 1 20 1 - ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv' PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv' PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv' PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Context: Traceback (most recent call last):
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-25 09:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
Context: Traceback (most recent call last):
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-25 12:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
Context: Traceback (most recent call last):
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-25 20:35:01 Database: brasilia Application: psql User: intelifix Remote: [local]
9 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #9
Day Hour Count Jul 25 03 1 - LOG: database system was shut down at 2026-07-25 03:05:02 -03
Date: 2026-07-25 03:05:03
10 1 ERROR: invalid input syntax for type json PL/pgSQL function rs_resumo_tcia(...) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(...) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(...) line 48 at assignment
Times Reported Most Frequent Error / Event #10
Day Hour Count Jul 25 09 1 - ERROR: invalid input syntax for type json PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936...
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-25 09:00:03 Database: brasilia Application: psql User: intelifix Remote: [local]