pgBadger-
Global information
- Generated on Sat Jul 18 23:50:07 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 9,972 log entries in 5s
- Log start from 2026-07-18 00:00:24 to 2026-07-18 23:49:09
-
Overview
Global Stats
- 151 Number of unique normalized queries
- 951 Number of queries
- 4h7m38s Total query duration
- 2026-07-18 00:02:17 First query
- 2026-07-18 23:48:16 Last query
- 4 queries/s at 2026-07-18 23:48:09 Query peak
- 4h7m38s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 4h7m38s Execute total duration
- 1,521 Number of events
- 9 Number of unique normalized events
- 1,409 Max number of times the same event was reported
- 0 Number of cancellation
- 11 Total number of automatic vacuums
- 19 Total number of automatic analyzes
- 10 Number temporary file
- 236.02 MiB Max size of temporary file
- 109.75 MiB Average size of temporary file
- 226 Total number of sessions
- 8 sessions at 2026-07-18 00:49:04 Session peak
- 8d12h30m19s Total duration of sessions
- 54m17s Average duration of sessions
- 4 Average queries per session
- 1m5s Average queries duration per session
- 53m11s Average idle time per session
- 227 Total number of connections
- 7 connections/s at 2026-07-18 03:05:17 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 4 queries/s Query Peak
- 2026-07-18 23:48:09 Date
SELECT Traffic
Key values
- 3 queries/s Query Peak
- 2026-07-18 23:10:02 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-07-18 23:48:09 Date
Queries duration
Key values
- 4h7m38s 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 18 00 29 0ms 17s142ms 4s182ms 5s183ms 5s900ms 1m12s 01 27 0ms 4s342ms 1s278ms 4s67ms 5s401ms 7s740ms 02 18 0ms 4s317ms 1s838ms 4s73ms 5s445ms 6s689ms 03 20 0ms 4s825ms 1s723ms 4s127ms 5s756ms 7s72ms 04 24 0ms 5s300ms 1s682ms 5s263ms 6s492ms 7s888ms 05 44 0ms 7m51s 23s727ms 8s995ms 2m22s 7m51s 06 18 0ms 8s455ms 3s546ms 4s269ms 5s80ms 28s957ms 07 18 0ms 7m46s 46s542ms 5s731ms 1m2s 7m46s 08 21 0ms 5m58s 31s479ms 5s542ms 53s154ms 5m58s 09 23 0ms 5m53s 28s109ms 5s22ms 48s404ms 5m53s 10 20 0ms 5m41s 30s816ms 4s284ms 45s869ms 5m41s 11 21 0ms 5m51s 30s803ms 4s510ms 48s496ms 5m51s 12 19 0ms 5m38s 32s291ms 4s604ms 45s45ms 5m38s 13 25 0ms 5m48s 27s229ms 4s867ms 48s419ms 5m48s 14 26 0ms 6m14s 28s206ms 5s162ms 41s606ms 6m47s 15 21 0ms 5m54s 30s23ms 5s305ms 45s166ms 5m54s 16 21 0ms 5m47s 30s651ms 4s662ms 48s445ms 5m47s 17 20 0ms 5m44s 30s709ms 4s668ms 43s836ms 5m44s 18 23 0ms 6m4s 28s437ms 4s636ms 5s731ms 6m49s 19 21 0ms 5m53s 30s656ms 4s520ms 48s10ms 5m53s 20 104 0ms 7m27s 12s678ms 1m15s 1m27s 7m27s 21 23 0ms 6m12s 27s801ms 4s73ms 4s627ms 6m56s 22 21 0ms 5m23s 29s649ms 4s733ms 14s333ms 5m52s 23 344 0ms 1m30s 6s640ms 1m5s 1m11s 2m11s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 18 00 7 0 3s262ms 0ms 0ms 1s125ms 01 11 0 238ms 0ms 164ms 343ms 02 0 0 0ms 0ms 0ms 0ms 03 2 0 588ms 0ms 0ms 0ms 04 6 0 289ms 0ms 0ms 765ms 05 24 0 277ms 209ms 374ms 1s120ms 06 3 0 4s385ms 0ms 0ms 0ms 07 6 0 2m14s 0ms 0ms 4m5s 08 6 0 1m44s 0ms 0ms 3m33s 09 8 0 1m16s 0ms 0ms 3m31s 10 6 0 1m37s 0ms 0ms 3m20s 11 6 0 1m42s 0ms 0ms 3m36s 12 6 0 1m37s 0ms 0ms 3m18s 13 9 0 1m8s 0ms 0ms 3m40s 14 8 0 1m24s 0ms 0ms 3m30s 15 6 0 1m39s 0ms 0ms 3m18s 16 6 0 1m41s 0ms 0ms 3m33s 17 6 0 1m37s 0ms 0ms 3m14s 18 8 0 1m17s 0ms 0ms 3m30s 19 6 0 1m41s 0ms 0ms 3m30s 20 10 79 14s390ms 12s935ms 1m15s 3m39s 21 8 0 1m16s 0ms 0ms 3m14s 22 6 0 1m38s 0ms 0ms 3m44s 23 20 324 6s640ms 1m3s 1m5s 2m10s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 18 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 18 00 0 2 2.00 0.00% 01 0 1 1.00 0.00% 02 0 0 0.00 0.00% 03 0 1 1.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 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 1 1.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 1 1.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 0 0.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 18 00 18 0.01/s 01 11 0.00/s 02 10 0.00/s 03 21 0.01/s 04 9 0.00/s 05 8 0.00/s 06 15 0.00/s 07 8 0.00/s 08 7 0.00/s 09 10 0.00/s 10 7 0.00/s 11 8 0.00/s 12 7 0.00/s 13 10 0.00/s 14 7 0.00/s 15 7 0.00/s 16 7 0.00/s 17 7 0.00/s 18 7 0.00/s 19 8 0.00/s 20 10 0.00/s 21 8 0.00/s 22 7 0.00/s 23 10 0.00/s Day Hour Count Average Duration Average idle time Jul 18 00 6 1h30s 1h10s 01 16 1h1m5s 1h1m3s 02 11 1h16s 1h13s 03 21 21m12s 21m10s 04 10 1h2m23s 1h2m19s 05 9 1h40s 58m44s 06 8 56m29s 56m21s 07 14 1h39s 59m39s 08 8 1h 58m37s 09 8 53m45s 52m24s 10 9 1h20s 59m11s 11 7 57m8s 55m36s 12 8 1h1m3s 59m47s 13 7 1h25s 58m48s 14 9 1h41s 59m20s 15 8 1h22s 59m3s 16 7 1h25s 58m54s 17 7 1h1m14s 59m46s 18 7 1h5s 58m31s 19 7 1h51s 59m19s 20 11 44m35s 42m35s 21 7 1h53s 59m22s 22 8 1h24s 59m6s 23 13 35m15s 32m19s -
Connections
Established Connections
Key values
- 7 connections Connection Peak
- 2026-07-18 03:05:17 Date
Connections per database
Key values
- rio Main Database
- 227 connections Total
Connections per user
Key values
- intelifix Main User
- 227 connections Total
-
Sessions
Simultaneous sessions
Key values
- 8 sessions Session Peak
- 2026-07-18 00:49:04 Date
Histogram of session times
Key values
- 193 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 226 sessions Total
Sessions per user
Key values
- intelifix Main User
- 226 sessions Total
Sessions per host
Key values
- [local] Main Host
- 226 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 66,025 buffers Checkpoint Peak
- 2026-07-18 01:14:48 Date
- 269.831 seconds Highest write time
- 0.045 seconds Sync time
Checkpoints Wal files
Key values
- 7 files Wal files usage Peak
- 2026-07-18 00:09:47 Date
Checkpoints distance
Key values
- 203.85 Mo Distance Peak
- 2026-07-18 00:09:47 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 18 00 77,145 638.218s 0.079s 638.363s 01 69,380 606.195s 0.088s 606.355s 02 1,761 177.006s 0.06s 177.103s 03 1,545 155.536s 0.069s 155.668s 04 2,174 218.461s 0.052s 218.554s 05 9,934 978.03s 0.137s 978.247s 06 5,453 376.205s 0.006s 376.226s 07 191 19.265s 0.006s 19.289s 08 21 2.129s 0.004s 2.137s 09 33 3.368s 0.007s 3.386s 10 21 2.131s 0.003s 2.142s 11 22 2.228s 0.003s 2.236s 12 21 2.13s 0.004s 2.139s 13 21 2.13s 0.004s 2.139s 14 743 216.848s 0.014s 216.885s 15 21 2.134s 0.004s 2.145s 16 21 2.13s 0.004s 2.139s 17 22 2.235s 0.004s 2.244s 18 567 57.001s 0.007s 57.02s 19 37 3.741s 0.005s 3.755s 20 98 9.892s 0.019s 9.93s 21 278 27.995s 0.012s 28.035s 22 21 2.132s 0.004s 2.143s 23 78 7.848s 0.005s 7.865s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 18 00 0 0 11 457 0.008s 0.007s 01 0 0 6 571 0.011s 0.01s 02 0 0 1 402 0.008s 0.006s 03 0 0 0 377 0.007s 0.009s 04 0 0 1 464 0.007s 0.006s 05 0 0 4 834 0.008s 0.009s 06 0 0 1 22 0.001s 0.002s 07 0 0 0 10 0.002s 0.004s 08 0 0 0 3 0.002s 0.002s 09 0 0 0 16 0.002s 0.002s 10 0 0 0 3 0.002s 0.001s 11 0 0 0 3 0.002s 0.001s 12 0 0 0 3 0.002s 0.002s 13 0 0 0 3 0.002s 0.002s 14 0 0 1 126 0.002s 0.003s 15 0 0 0 3 0.003s 0.002s 16 0 0 0 3 0.002s 0.001s 17 0 0 0 3 0.002s 0.002s 18 0 0 0 48 0.002s 0.002s 19 0 0 0 6 0.003s 0.001s 20 0 0 0 20 0.005s 0.005s 21 0 0 0 30 0.003s 0.005s 22 0 0 0 3 0.002s 0.002s 23 0 0 0 6 0.003s 0.003s Day Hour Count Avg time (sec) Jul 18 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 18 00 24,861.29 kB 82,329.71 kB 01 9,790.70 kB 56,457.40 kB 02 1,520.17 kB 26,165.17 kB 03 875.50 kB 4,741.90 kB 04 1,926.33 kB 2,304.83 kB 05 7,439.89 kB 15,125.22 kB 06 7,146.50 kB 11,450.50 kB 07 253.00 kB 9,094.67 kB 08 168.00 kB 7,396.00 kB 09 102.00 kB 6,341.00 kB 10 168.00 kB 5,425.00 kB 11 169.00 kB 4,900.00 kB 12 168.00 kB 4,426.00 kB 13 168.00 kB 4,001.00 kB 14 5,898.67 kB 12,640.33 kB 15 168.00 kB 10,342.00 kB 16 168.00 kB 9,325.00 kB 17 169.00 kB 8,409.00 kB 18 1,372.00 kB 7,439.50 kB 19 216.00 kB 6,376.00 kB 20 358.67 kB 5,248.33 kB 21 152.75 kB 3,710.25 kB 22 168.00 kB 2,866.00 kB 23 56.00 kB 2,458.00 kB -
Temporary Files
Size of temporary files
Key values
- 472.03 MiB Temp Files size Peak
- 2026-07-18 05:32:09 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-07-18 05:32:15 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 18 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 10 1.07 GiB 109.75 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 916.87 MiB 70.40 MiB 236.02 MiB 114.61 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-18 05:32:17 Duration: 1m30s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-18 05:32:09 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 2 180.58 MiB 90.29 MiB 90.29 MiB 90.29 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-18 05:30:46 Duration: 44s450ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-18 05:30:42 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 236.02 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-18 05:32:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 236.02 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-18 05:32:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 90.29 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-18 05:30:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 90.29 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-18 05:30:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 77.91 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-18 05:32:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 77.83 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-18 05:32:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 77.83 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-18 05:32:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 70.47 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-18 05:32:17 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 70.40 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-18 05:32:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 70.40 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-18 05:32:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 18.37 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_07
Database rio - 2026-07-18 01:06:11 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 18.37 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_07
Database rio - 2026-07-18 01:06:11 Date
Analyzes per table
Key values
- public.temp0000285774 (12) Main table analyzed (database rio)
- 19 analyzes Total
Vacuums per table
Key values
- public.temp0000285784 (2) Main table vacuumed on database rio
- 11 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.public.temp0000285784 2 0 0 0 0 0 0 1,785 10 106,901 0 0 brasilia.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,553 204 892,004 184 1,271 rio.pg_catalog.pg_statistic 1 1 0 0 0 0 0 3,343 412 1,892,027 364 2,254 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 132 5 11,867 0 0 rio.auditor.auditor_2026_07 1 0 0 0 0 0 0 68,872 66,025 84,095,413 1,559 38,216 rio.pg_catalog.pg_index 1 1 0 0 0 0 0 114 43 23,293 0 0 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,265 6 160,975 0 0 rio.pg_catalog.pg_attribute 1 1 0 0 0 0 0 764 283 263,665 0 0 brasilia.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 163 26 71,171 7 16 rio.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 938 168 1,090,769 119 393 Total 11 8 0 0 0 0 0 80,929 67,182 88,608,085 2,233 42,150 Vacuum throughput per table
Key values
- auditor.auditor_2026_07 (18.37) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.public.temp0000285784 0 0 0.07 brasilia.pg_catalog.pg_statistic 0 0 0.13 rio.pg_catalog.pg_statistic 0 0 0.28 contagem.pg_toast.pg_toast_2619 0 0 0.02 rio.auditor.auditor_2026_07 0 0 18.37 rio.pg_catalog.pg_index 0 0 0.02 contagem.pg_catalog.pg_statistic 0 0 0.04 rio.pg_catalog.pg_attribute 0 0 0.41 brasilia.pg_toast.pg_toast_2619 0 0 0 rio.pg_toast.pg_toast_2619 0 0 0.06 Total 0 0 19.4 Tuples removed per table
Key values
- pg_catalog.pg_statistic (4474) Main table with removed tuples on database contagem
- 18907 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain contagem.pg_catalog.pg_statistic 1 1 4,474 7,274 0 0 1,011 rio.pg_catalog.pg_statistic 1 1 4,100 7,489 0 0 1,286 brasilia.pg_catalog.pg_statistic 1 1 3,837 7,332 0 0 1,072 rio.auditor.auditor_2026_07 1 0 3,265 12,892,425 0 0 594,679 rio.pg_catalog.pg_attribute 1 1 2,154 20,400 0 48 559 rio.pg_toast.pg_toast_2619 1 1 690 677 0 0 284 rio.pg_catalog.pg_index 1 1 161 1,879 0 0 61 brasilia.pg_toast.pg_toast_2619 1 1 125 137 0 0 66 contagem.pg_toast.pg_toast_2619 1 1 101 113 0 19 43 rio.public.temp0000285784 2 0 0 25,642 0 14 1,778 Total 11 8 18,907 12,963,368 0 81 600,839 Pages removed per table
Key values
- pg_catalog.pg_attribute (48) Main table with removed pages on database rio
- 81 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.pg_catalog.pg_attribute 1 1 2154 48 contagem.pg_toast.pg_toast_2619 1 1 101 19 rio.public.temp0000285784 2 0 0 14 brasilia.pg_catalog.pg_statistic 1 1 3837 0 rio.pg_catalog.pg_statistic 1 1 4100 0 rio.auditor.auditor_2026_07 1 0 3265 0 rio.pg_catalog.pg_index 1 1 161 0 contagem.pg_catalog.pg_statistic 1 1 4474 0 brasilia.pg_toast.pg_toast_2619 1 1 125 0 rio.pg_toast.pg_toast_2619 1 1 690 0 Total 11 8 18,907 81 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 18 00 0 0 01 1 1 02 0 0 03 0 0 04 0 2 05 7 12 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 1 1 14 1 2 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 1 1 22 0 0 23 0 0 - 18.37 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
- 184 Total read queries
- 407 Total write queries
Queries by database
Key values
- rio Main database
- 474 Requests
- 2h44m7s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 928 Requests
User Request type Count Duration etiquetas Total 8 3s54ms select 8 3s54ms intelifix Total 928 4h6m57s copy to 403 46m43s ddl 4 56s82ms others 360 30m33s select 161 2h48m44s lenon Total 15 38s333ms select 15 38s333ms Duration by user
Key values
- 4h6m57s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 8 3s54ms select 8 3s54ms intelifix Total 928 4h6m57s copy to 403 46m43s ddl 4 56s82ms others 360 30m33s select 161 2h48m44s lenon Total 15 38s333ms select 15 38s333ms Queries by host
Key values
- [local] Main host
- 951 Requests
- 4h7m38s ([local])
- Main time consuming host
Queries by application
Key values
- psql Main application
- 465 Requests
- 3h18m54s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-18 19:36:36 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 371 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 7m51s analyze verbose;[ Date: 2026-07-18 05:07:53 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 7m46s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-18 07:12:47 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 7m27s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-18 20:12:29 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 6m14s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-18 14:11:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 6m12s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-18 21:11:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 6m4s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-18 18:11:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 5m58s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-18 08:10:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 5m54s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-18 15:10:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 5m53s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-18 19:10:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 5m53s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-18 09:10:54 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 5m51s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-18 11:10:52 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m48s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-18 13:10:49 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 5m47s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-18 16:10:49 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m44s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-18 17:10:46 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m41s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-18 10:10:43 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m38s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-18 12:10:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m23s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-18 22:10:25 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 4m9s analyze verbose;[ Date: 2026-07-18 05:12:03 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
19 3m58s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-07-18 07:18:20 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
20 3m42s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-07-18 22:14:50 - 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 1h42m32s 48 1s418ms 7m46s 2m8s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 18 07 3 8m24s 2m48s 08 3 6m17s 2m5s 09 3 6m12s 2m4s 10 3 5m59s 1m59s 11 3 6m7s 2m2s 12 3 5m54s 1m58s 13 3 6m7s 2m2s 14 3 6m34s 2m11s 15 3 6m11s 2m3s 16 3 6m7s 2m2s 17 3 6m 2m 18 3 6m21s 2m7s 19 3 6m9s 2m3s 20 3 7m55s 2m38s 21 3 6m28s 2m9s 22 3 5m40s 1m53s [ User: intelifix - Total duration: 1h42m32s - Times executed: 48 ]
[ Application: psql - Total duration: 1h42m32s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-18 07:12:47 Duration: 7m46s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-18 20:12:29 Duration: 7m27s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-18 14:11:16 Duration: 6m14s Database: rio User: intelifix Remote: [local] Application: psql
2 1h5m12s 48 262ms 3m58s 1m21s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 18 07 3 5m2s 1m40s 08 3 4m7s 1m22s 09 3 4m1s 1m20s 10 3 3m48s 1m16s 11 3 4m8s 1m22s 12 3 3m48s 1m16s 13 3 4m9s 1m23s 14 3 4m1s 1m20s 15 3 3m45s 1m15s 16 3 4m2s 1m20s 17 3 3m42s 1m14s 18 3 3m58s 1m19s 19 3 4m1s 1m20s 20 3 4m39s 1m33s 21 3 3m43s 1m14s 22 3 4m11s 1m23s [ User: intelifix - Total duration: 1h5m12s - Times executed: 48 ]
[ Application: psql - Total duration: 1h5m12s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-18 07:18:20 Duration: 3m58s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-18 22:14:50 Duration: 3m42s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-18 13:15:16 Duration: 3m38s Database: brasilia User: intelifix Remote: [local] Application: psql
3 14m24s 3 2m22s 7m51s 4m48s analyze verbose;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 18 05 3 14m24s 4m48s [ User: intelifix - Total duration: 14m24s - Times executed: 3 ]
[ Application: psql - Total duration: 14m24s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-18 05:07:53 Duration: 7m51s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-18 05:12:03 Duration: 4m9s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-18 05:14:26 Duration: 2m22s Database: contagem User: intelifix Remote: [local] Application: psql
4 10m54s 270 150ms 10s814ms 2s423ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 18 00 12 32s627ms 2s718ms 01 11 24s510ms 2s228ms 02 12 25s429ms 2s119ms 03 12 25s813ms 2s151ms 04 12 28s163ms 2s346ms 05 11 31s505ms 2s864ms 06 12 26s98ms 2s174ms 07 12 31s351ms 2s612ms 08 12 31s515ms 2s626ms 09 12 29s265ms 2s438ms 10 11 24s612ms 2s237ms 11 12 26s768ms 2s230ms 12 10 27s703ms 2s770ms 13 12 27s779ms 2s314ms 14 12 28s763ms 2s396ms 15 12 29s875ms 2s489ms 16 12 28s831ms 2s402ms 17 11 28s89ms 2s553ms 18 12 29s601ms 2s466ms 19 12 29s124ms 2s427ms 20 12 34s340ms 2s861ms 21 12 24s532ms 2s44ms 22 12 27s971ms 2s330ms [ User: intelifix - Total duration: 10m54s - Times executed: 270 ]
[ Application: psql - Total duration: 10m54s - Times executed: 270 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-18 00:05:21 Duration: 10s814ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-18 20:15:10 Duration: 8s796ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-18 08:05:07 Duration: 6s230ms Database: rio User: intelifix Remote: [local] Application: psql
5 3m3s 4 4s255ms 1m30s 45s771ms 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 18 20 2 1m28s 44s51ms 23 2 1m34s 47s491ms [ User: intelifix - Total duration: 3m3s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m3s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-18 23:17:06 Duration: 1m30s 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-18 20:08:36 Duration: 1m23s 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-18 23:37:04 Duration: 4s938ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 2m4s 4 333ms 1m3s 31s97ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 18 20 2 1m 30s259ms 23 2 1m3s 31s936ms [ User: intelifix - Total duration: 2m4s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m4s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-18 23:13:40 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-18 20:05:32 Duration: 1m Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-18 23:36:30 Duration: 457ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 1m31s 6 2s184ms 36s280ms 15s296ms copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 18 20 3 43s750ms 14s583ms 23 3 48s28ms 16s9ms [ User: intelifix - Total duration: 1m31s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m31s - 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-18 23:14:18 Duration: 36s280ms 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-18 20:06:06 Duration: 32s655ms 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-18 23:36:40 Duration: 9s213ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 1m30s 1 1m30s 1m30s 1m30s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 18 05 1 1m30s 1m30s [ User: intelifix - Total duration: 1m30s - Times executed: 1 ]
[ Application: psql - Total duration: 1m30s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-18 05:32:17 Duration: 1m30s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-18 05:32:09 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
9 1m15s 6 1s684ms 30s873ms 12s544ms 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 18 20 3 35s462ms 11s820ms 23 3 39s805ms 13s268ms [ User: intelifix - Total duration: 1m15s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m15s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-18 23:14:53 Duration: 30s873ms 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-18 20:06:38 Duration: 27s21ms 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-18 23:36:47 Duration: 6s993ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 1m14s 6 8s18ms 17s142ms 12s495ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 18 00 3 50s398ms 16s799ms 06 3 24s576ms 8s192ms [ User: intelifix - Total duration: 1m14s - Times executed: 6 ]
[ Application: psql - Total duration: 1m14s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-18 00:05:19 Duration: 17s142ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-18 00:05:52 Duration: 17s35ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-18 00:05:35 Duration: 16s220ms Database: brasilia User: intelifix Remote: [local] Application: psql
11 1m8s 6 2s689ms 27s461ms 11s496ms 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 18 20 3 32s746ms 10s915ms 23 3 36s230ms 12s76ms [ User: intelifix - Total duration: 1m8s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m8s - 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-18 23:17:33 Duration: 27s461ms 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-18 20:09:01 Duration: 24s812ms 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-18 23:37:10 Duration: 5s877ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 59s7ms 6 1s615ms 20s306ms 9s834ms 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 18 20 3 29s100ms 9s700ms 23 3 29s906ms 9s968ms [ User: intelifix - Total duration: 59s7ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 59s7ms - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-18 20:03:19 Duration: 20s306ms 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-18 23:11:19 Duration: 20s305ms 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-18 23:36:14 Duration: 7s770ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 58s524ms 6 2s115ms 19s408ms 9s754ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 18 20 3 28s832ms 9s610ms 23 3 29s692ms 9s897ms [ User: intelifix - Total duration: 58s524ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 58s524ms - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-18 23:10:45 Duration: 19s408ms 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-18 20:02:43 Duration: 18s788ms 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-18 23:36:03 Duration: 7s952ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 57s808ms 6 1s442ms 23s536ms 9s634ms 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 #14
Day Hour Count Duration Avg duration Jul 18 20 3 28s629ms 9s543ms 23 3 29s179ms 9s726ms [ User: intelifix - Total duration: 57s808ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 57s808ms - 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-18 23:12:15 Duration: 23s536ms 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-18 20:04:12 Duration: 23s372ms 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-18 23:36:26 Duration: 3s899ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 54s154ms 32 326ms 9s407ms 1s692ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 18 00 6 15s256ms 2s542ms 01 5 7s387ms 1s477ms 02 6 7s662ms 1s277ms 03 5 7s244ms 1s448ms 04 6 10s472ms 1s745ms 05 4 6s131ms 1s532ms [ User: intelifix - Total duration: 54s154ms - Times executed: 32 ]
[ Application: psql - Total duration: 54s154ms - Times executed: 32 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-18 00:05:11 Duration: 9s407ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-18 03:15:04 Duration: 3s90ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-18 01:35:04 Duration: 2s688ms Database: rio User: intelifix Remote: [local] Application: psql
16 47s651ms 4 3s208ms 21s778ms 11s912ms 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 18 20 2 22s664ms 11s332ms 23 2 24s986ms 12s493ms [ User: intelifix - Total duration: 47s651ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 47s651ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-07-18 23:12:37 Duration: 21s778ms 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-18 20:04:32 Duration: 19s274ms 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-18 20:09:45 Duration: 3s390ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 44s450ms 1 44s450ms 44s450ms 44s450ms refresh materialized view concurrently rs_mv_equipamentos;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 18 05 1 44s450ms 44s450ms [ User: intelifix - Total duration: 44s450ms - Times executed: 1 ]
[ Application: psql - Total duration: 44s450ms - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-18 05:30:46 Duration: 44s450ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-18 05:30:42 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
18 43s191ms 6 1s407ms 14s897ms 7s198ms 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 18 20 3 20s692ms 6s897ms 23 3 22s499ms 7s499ms [ User: intelifix - Total duration: 43s191ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 43s191ms - 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-18 23:11:34 Duration: 14s897ms 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-18 20:03:32 Duration: 13s635ms 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-18 23:36:20 Duration: 5s933ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 41s606ms 1 41s606ms 41s606ms 41s606ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 18 14 1 41s606ms 41s606ms [ User: intelifix - Total duration: 41s606ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 41s606ms - Times executed: 1 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-18', 0449, '', '', 0, 6, '2026-07-01');
Date: 2026-07-18 14:03:53 Duration: 41s606ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 41s64ms 36 661ms 3s204ms 1s140ms call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 18 08 3 4s430ms 1s476ms 09 1 816ms 816ms 10 3 3s786ms 1s262ms 11 3 4s201ms 1s400ms 12 3 2s875ms 958ms 13 2 1s986ms 993ms 14 3 2s945ms 981ms 15 3 2s965ms 988ms 16 3 4s744ms 1s581ms 17 2 1s812ms 906ms 18 1 1s124ms 1s124ms 19 3 3s42ms 1s14ms 20 3 3s513ms 1s171ms 21 1 816ms 816ms 22 2 2s3ms 1s1ms [ User: intelifix - Total duration: 41s64ms - Times executed: 36 ]
[ Application: psql - Total duration: 41s64ms - Times executed: 36 ]
-
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-18 16:20:04 Duration: 3s204ms 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-18 11:20:03 Duration: 2s261ms 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-18 10:20:03 Duration: 2s39ms Database: rio User: intelifix Remote: [local] Application: psql
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 270 10m54s 150ms 10s814ms 2s423ms call rs_giga_triagem (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 18 00 12 32s627ms 2s718ms 01 11 24s510ms 2s228ms 02 12 25s429ms 2s119ms 03 12 25s813ms 2s151ms 04 12 28s163ms 2s346ms 05 11 31s505ms 2s864ms 06 12 26s98ms 2s174ms 07 12 31s351ms 2s612ms 08 12 31s515ms 2s626ms 09 12 29s265ms 2s438ms 10 11 24s612ms 2s237ms 11 12 26s768ms 2s230ms 12 10 27s703ms 2s770ms 13 12 27s779ms 2s314ms 14 12 28s763ms 2s396ms 15 12 29s875ms 2s489ms 16 12 28s831ms 2s402ms 17 11 28s89ms 2s553ms 18 12 29s601ms 2s466ms 19 12 29s124ms 2s427ms 20 12 34s340ms 2s861ms 21 12 24s532ms 2s44ms 22 12 27s971ms 2s330ms [ User: intelifix - Total duration: 10m54s - Times executed: 270 ]
[ Application: psql - Total duration: 10m54s - Times executed: 270 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-18 00:05:21 Duration: 10s814ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-18 20:15:10 Duration: 8s796ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-18 08:05:07 Duration: 6s230ms Database: rio User: intelifix Remote: [local] Application: psql
2 48 1h42m32s 1s418ms 7m46s 2m8s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 18 07 3 8m24s 2m48s 08 3 6m17s 2m5s 09 3 6m12s 2m4s 10 3 5m59s 1m59s 11 3 6m7s 2m2s 12 3 5m54s 1m58s 13 3 6m7s 2m2s 14 3 6m34s 2m11s 15 3 6m11s 2m3s 16 3 6m7s 2m2s 17 3 6m 2m 18 3 6m21s 2m7s 19 3 6m9s 2m3s 20 3 7m55s 2m38s 21 3 6m28s 2m9s 22 3 5m40s 1m53s [ User: intelifix - Total duration: 1h42m32s - Times executed: 48 ]
[ Application: psql - Total duration: 1h42m32s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-18 07:12:47 Duration: 7m46s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-18 20:12:29 Duration: 7m27s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-18 14:11:16 Duration: 6m14s Database: rio User: intelifix Remote: [local] Application: psql
3 48 1h5m12s 262ms 3m58s 1m21s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 18 07 3 5m2s 1m40s 08 3 4m7s 1m22s 09 3 4m1s 1m20s 10 3 3m48s 1m16s 11 3 4m8s 1m22s 12 3 3m48s 1m16s 13 3 4m9s 1m23s 14 3 4m1s 1m20s 15 3 3m45s 1m15s 16 3 4m2s 1m20s 17 3 3m42s 1m14s 18 3 3m58s 1m19s 19 3 4m1s 1m20s 20 3 4m39s 1m33s 21 3 3m43s 1m14s 22 3 4m11s 1m23s [ User: intelifix - Total duration: 1h5m12s - Times executed: 48 ]
[ Application: psql - Total duration: 1h5m12s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-18 07:18:20 Duration: 3m58s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-18 22:14:50 Duration: 3m42s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-18 13:15:16 Duration: 3m38s Database: brasilia User: intelifix Remote: [local] Application: psql
4 36 41s64ms 661ms 3s204ms 1s140ms 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 #4
Day Hour Count Duration Avg duration Jul 18 08 3 4s430ms 1s476ms 09 1 816ms 816ms 10 3 3s786ms 1s262ms 11 3 4s201ms 1s400ms 12 3 2s875ms 958ms 13 2 1s986ms 993ms 14 3 2s945ms 981ms 15 3 2s965ms 988ms 16 3 4s744ms 1s581ms 17 2 1s812ms 906ms 18 1 1s124ms 1s124ms 19 3 3s42ms 1s14ms 20 3 3s513ms 1s171ms 21 1 816ms 816ms 22 2 2s3ms 1s1ms [ User: intelifix - Total duration: 41s64ms - Times executed: 36 ]
[ Application: psql - Total duration: 41s64ms - Times executed: 36 ]
-
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-18 16:20:04 Duration: 3s204ms 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-18 11:20:03 Duration: 2s261ms 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-18 10:20:03 Duration: 2s39ms Database: rio User: intelifix Remote: [local] Application: psql
5 32 54s154ms 326ms 9s407ms 1s692ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 18 00 6 15s256ms 2s542ms 01 5 7s387ms 1s477ms 02 6 7s662ms 1s277ms 03 5 7s244ms 1s448ms 04 6 10s472ms 1s745ms 05 4 6s131ms 1s532ms [ User: intelifix - Total duration: 54s154ms - Times executed: 32 ]
[ Application: psql - Total duration: 54s154ms - Times executed: 32 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-18 00:05:11 Duration: 9s407ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-18 03:15:04 Duration: 3s90ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-18 01:35:04 Duration: 2s688ms Database: rio User: intelifix Remote: [local] Application: psql
6 25 5s544ms 155ms 441ms 221ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 18 01 7 1s279ms 182ms 04 2 599ms 299ms 05 16 3s664ms 229ms [ User: intelifix - Total duration: 5s544ms - Times executed: 25 ]
[ Application: [unknown] - Total duration: 5s544ms - Times executed: 25 ]
-
SELECT * FROM RS_TRIAGEM (428, 5, '73', 2, '229919763841,229874492835,229913537071,229898779616,229914920002,229914832440,229909849595,229871920003,229915775876,229910021634,229915891623,229916129299,229893774043,229900496068,229897498289,229876641732,229914213434,229900515969,229896295658,229913633950', NULL, NULL, 0263, 00);
Date: 2026-07-18 04:57:08 Duration: 441ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '229908223557,229876274849,229919265981,229910491231,229908390016,229910750022,229897362946,229902882340,229902202341,229911866179,229908533946', NULL, NULL, 0263, 00);
Date: 2026-07-18 05:08:32 Duration: 375ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '229918631217,229870688805,229912833030,229899733132,229910635262,229897923135,229919233150,229913497898,229912066681,229896834454,229896242343,229900439496', NULL, NULL, 0263, 00);
Date: 2026-07-18 05:11:09 Duration: 357ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 9 8s992ms 830ms 1s256ms 999ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 18 09 2 1s739ms 869ms 13 1 1s75ms 1s75ms 17 1 832ms 832ms 18 2 2s307ms 1s153ms 21 2 2s19ms 1s9ms 22 1 1s18ms 1s18ms [ User: intelifix - Total duration: 8s992ms - Times executed: 9 ]
[ Application: psql - Total duration: 8s992ms - Times executed: 9 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-07-18 18:00:02 Duration: 1s256ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-07-18 13:20:02 Duration: 1s75ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-07-18 21:20:02 Duration: 1s50ms Database: rio User: intelifix Remote: [local] Application: psql
8 9 3s848ms 338ms 514ms 427ms 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 #8
Day Hour Count Duration Avg duration Jul 18 00 1 472ms 472ms 01 1 444ms 444ms 03 1 514ms 514ms 04 1 338ms 338ms 05 3 1s203ms 401ms 09 1 457ms 457ms 13 1 418ms 418ms [ User: lenon - Total duration: 3s848ms - Times executed: 9 ]
[ Application: [unknown] - Total duration: 3s848ms - Times executed: 9 ]
-
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-18 03:16:47 Duration: 514ms 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-18 00:50:42 Duration: 472ms 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-18 05:05:06 Duration: 470ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
9 6 1m31s 2s184ms 36s280ms 15s296ms copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 18 20 3 43s750ms 14s583ms 23 3 48s28ms 16s9ms [ User: intelifix - Total duration: 1m31s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m31s - 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-18 23:14:18 Duration: 36s280ms 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-18 20:06:06 Duration: 32s655ms 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-18 23:36:40 Duration: 9s213ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 6 1m15s 1s684ms 30s873ms 12s544ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 18 20 3 35s462ms 11s820ms 23 3 39s805ms 13s268ms [ User: intelifix - Total duration: 1m15s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m15s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-18 23:14:53 Duration: 30s873ms 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-18 20:06:38 Duration: 27s21ms 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-18 23:36:47 Duration: 6s993ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 6 1m14s 8s18ms 17s142ms 12s495ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 18 00 3 50s398ms 16s799ms 06 3 24s576ms 8s192ms [ User: intelifix - Total duration: 1m14s - Times executed: 6 ]
[ Application: psql - Total duration: 1m14s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-18 00:05:19 Duration: 17s142ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-18 00:05:52 Duration: 17s35ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-18 00:05:35 Duration: 16s220ms Database: brasilia User: intelifix Remote: [local] Application: psql
12 6 1m8s 2s689ms 27s461ms 11s496ms 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 18 20 3 32s746ms 10s915ms 23 3 36s230ms 12s76ms [ User: intelifix - Total duration: 1m8s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m8s - 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-18 23:17:33 Duration: 27s461ms 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-18 20:09:01 Duration: 24s812ms 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-18 23:37:10 Duration: 5s877ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 6 59s7ms 1s615ms 20s306ms 9s834ms 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 18 20 3 29s100ms 9s700ms 23 3 29s906ms 9s968ms [ User: intelifix - Total duration: 59s7ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 59s7ms - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-18 20:03:19 Duration: 20s306ms 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-18 23:11:19 Duration: 20s305ms 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-18 23:36:14 Duration: 7s770ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 6 58s524ms 2s115ms 19s408ms 9s754ms 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 18 20 3 28s832ms 9s610ms 23 3 29s692ms 9s897ms [ User: intelifix - Total duration: 58s524ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 58s524ms - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-18 23:10:45 Duration: 19s408ms 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-18 20:02:43 Duration: 18s788ms 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-18 23:36:03 Duration: 7s952ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 6 57s808ms 1s442ms 23s536ms 9s634ms 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 18 20 3 28s629ms 9s543ms 23 3 29s179ms 9s726ms [ User: intelifix - Total duration: 57s808ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 57s808ms - 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-18 23:12:15 Duration: 23s536ms 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-18 20:04:12 Duration: 23s372ms 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-18 23:36:26 Duration: 3s899ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 6 43s191ms 1s407ms 14s897ms 7s198ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 18 20 3 20s692ms 6s897ms 23 3 22s499ms 7s499ms [ User: intelifix - Total duration: 43s191ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 43s191ms - 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-18 23:11:34 Duration: 14s897ms 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-18 20:03:32 Duration: 13s635ms 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-18 23:36:20 Duration: 5s933ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 6 36s303ms 3s260ms 8s889ms 6s50ms 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 #17
Day Hour Count Duration Avg duration Jul 18 20 3 17s886ms 5s962ms 23 3 18s417ms 6s139ms [ User: intelifix - Total duration: 36s303ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 36s303ms - 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-18 23:15:21 Duration: 8s889ms 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-18 20:10:15 Duration: 8s134ms 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-18 20:06:59 Duration: 6s431ms Database: rio User: intelifix Remote: [local] Application: pg_dump
18 6 35s176ms 834ms 14s902ms 5s862ms copy public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 18 20 3 17s887ms 5s962ms 23 3 17s289ms 5s763ms [ User: intelifix - Total duration: 35s176ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 35s176ms - Times executed: 6 ]
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-07-18 20:02:58 Duration: 14s902ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-07-18 23:10:59 Duration: 13s929ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-07-18 23:36:06 Duration: 2s466ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 6 34s485ms 2s384ms 14s927ms 5s747ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 18 00 3 21s328ms 7s109ms 06 3 13s156ms 4s385ms [ User: lenon - Total duration: 34s485ms - Times executed: 6 ]
[ Application: psql - Total duration: 34s485ms - Times executed: 6 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-07-18 00:02:17 Duration: 14s927ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-07-18 06:02:09 Duration: 6s769ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-07-18 06:02:13 Duration: 4s2ms Database: brasilia User: lenon Remote: [local] Application: psql
20 6 28s977ms 926ms 11s308ms 4s829ms copy public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 18 20 3 14s231ms 4s743ms 23 3 14s746ms 4s915ms [ User: intelifix - Total duration: 28s977ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 28s977ms - Times executed: 6 ]
-
COPY public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) TO stdout;
Date: 2026-07-18 23:10:21 Duration: 11s308ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) TO stdout;
Date: 2026-07-18 20:02:21 Duration: 10s723ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) TO stdout;
Date: 2026-07-18 20:09:11 Duration: 2s581ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m22s 7m51s 4m48s 3 14m24s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 18 05 3 14m24s 4m48s [ User: intelifix - Total duration: 14m24s - Times executed: 3 ]
[ Application: psql - Total duration: 14m24s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-18 05:07:53 Duration: 7m51s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-18 05:12:03 Duration: 4m9s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-18 05:14:26 Duration: 2m22s Database: contagem User: intelifix Remote: [local] Application: psql
2 1s418ms 7m46s 2m8s 48 1h42m32s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 18 07 3 8m24s 2m48s 08 3 6m17s 2m5s 09 3 6m12s 2m4s 10 3 5m59s 1m59s 11 3 6m7s 2m2s 12 3 5m54s 1m58s 13 3 6m7s 2m2s 14 3 6m34s 2m11s 15 3 6m11s 2m3s 16 3 6m7s 2m2s 17 3 6m 2m 18 3 6m21s 2m7s 19 3 6m9s 2m3s 20 3 7m55s 2m38s 21 3 6m28s 2m9s 22 3 5m40s 1m53s [ User: intelifix - Total duration: 1h42m32s - Times executed: 48 ]
[ Application: psql - Total duration: 1h42m32s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-18 07:12:47 Duration: 7m46s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-18 20:12:29 Duration: 7m27s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-18 14:11:16 Duration: 6m14s Database: rio User: intelifix Remote: [local] Application: psql
3 1m30s 1m30s 1m30s 1 1m30s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 18 05 1 1m30s 1m30s [ User: intelifix - Total duration: 1m30s - Times executed: 1 ]
[ Application: psql - Total duration: 1m30s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-18 05:32:17 Duration: 1m30s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-18 05:32:09 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
4 262ms 3m58s 1m21s 48 1h5m12s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 18 07 3 5m2s 1m40s 08 3 4m7s 1m22s 09 3 4m1s 1m20s 10 3 3m48s 1m16s 11 3 4m8s 1m22s 12 3 3m48s 1m16s 13 3 4m9s 1m23s 14 3 4m1s 1m20s 15 3 3m45s 1m15s 16 3 4m2s 1m20s 17 3 3m42s 1m14s 18 3 3m58s 1m19s 19 3 4m1s 1m20s 20 3 4m39s 1m33s 21 3 3m43s 1m14s 22 3 4m11s 1m23s [ User: intelifix - Total duration: 1h5m12s - Times executed: 48 ]
[ Application: psql - Total duration: 1h5m12s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-18 07:18:20 Duration: 3m58s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-18 22:14:50 Duration: 3m42s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-18 13:15:16 Duration: 3m38s Database: brasilia User: intelifix Remote: [local] Application: psql
5 4s255ms 1m30s 45s771ms 4 3m3s 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 18 20 2 1m28s 44s51ms 23 2 1m34s 47s491ms [ User: intelifix - Total duration: 3m3s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m3s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-18 23:17:06 Duration: 1m30s 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-18 20:08:36 Duration: 1m23s 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-18 23:37:04 Duration: 4s938ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 44s450ms 44s450ms 44s450ms 1 44s450ms refresh materialized view concurrently rs_mv_equipamentos;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 18 05 1 44s450ms 44s450ms [ User: intelifix - Total duration: 44s450ms - Times executed: 1 ]
[ Application: psql - Total duration: 44s450ms - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-18 05:30:46 Duration: 44s450ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-18 05:30:42 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
7 41s606ms 41s606ms 41s606ms 1 41s606ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 18 14 1 41s606ms 41s606ms [ User: intelifix - Total duration: 41s606ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 41s606ms - Times executed: 1 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-18', 0449, '', '', 0, 6, '2026-07-01');
Date: 2026-07-18 14:03:53 Duration: 41s606ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 333ms 1m3s 31s97ms 4 2m4s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 18 20 2 1m 30s259ms 23 2 1m3s 31s936ms [ User: intelifix - Total duration: 2m4s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m4s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-18 23:13:40 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-18 20:05:32 Duration: 1m Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-18 23:36:30 Duration: 457ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
9 2s184ms 36s280ms 15s296ms 6 1m31s copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 18 20 3 43s750ms 14s583ms 23 3 48s28ms 16s9ms [ User: intelifix - Total duration: 1m31s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m31s - 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-18 23:14:18 Duration: 36s280ms 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-18 20:06:06 Duration: 32s655ms 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-18 23:36:40 Duration: 9s213ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 1s684ms 30s873ms 12s544ms 6 1m15s copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 18 20 3 35s462ms 11s820ms 23 3 39s805ms 13s268ms [ User: intelifix - Total duration: 1m15s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m15s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-07-18 23:14:53 Duration: 30s873ms 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-18 20:06:38 Duration: 27s21ms 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-18 23:36:47 Duration: 6s993ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 8s18ms 17s142ms 12s495ms 6 1m14s call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 18 00 3 50s398ms 16s799ms 06 3 24s576ms 8s192ms [ User: intelifix - Total duration: 1m14s - Times executed: 6 ]
[ Application: psql - Total duration: 1m14s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-18 00:05:19 Duration: 17s142ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-18 00:05:52 Duration: 17s35ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-07-18 00:05:35 Duration: 16s220ms Database: brasilia User: intelifix Remote: [local] Application: psql
12 3s208ms 21s778ms 11s912ms 4 47s651ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 18 20 2 22s664ms 11s332ms 23 2 24s986ms 12s493ms [ User: intelifix - Total duration: 47s651ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 47s651ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-07-18 23:12:37 Duration: 21s778ms 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-18 20:04:32 Duration: 19s274ms 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-18 20:09:45 Duration: 3s390ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 2s689ms 27s461ms 11s496ms 6 1m8s copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 18 20 3 32s746ms 10s915ms 23 3 36s230ms 12s76ms [ User: intelifix - Total duration: 1m8s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m8s - 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-18 23:17:33 Duration: 27s461ms 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-18 20:09:01 Duration: 24s812ms 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-18 23:37:10 Duration: 5s877ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 1s615ms 20s306ms 9s834ms 6 59s7ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 18 20 3 29s100ms 9s700ms 23 3 29s906ms 9s968ms [ User: intelifix - Total duration: 59s7ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 59s7ms - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-18 20:03:19 Duration: 20s306ms 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-18 23:11:19 Duration: 20s305ms 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-18 23:36:14 Duration: 7s770ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 2s115ms 19s408ms 9s754ms 6 58s524ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 18 20 3 28s832ms 9s610ms 23 3 29s692ms 9s897ms [ User: intelifix - Total duration: 58s524ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 58s524ms - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-07-18 23:10:45 Duration: 19s408ms 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-18 20:02:43 Duration: 18s788ms 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-18 23:36:03 Duration: 7s952ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 1s442ms 23s536ms 9s634ms 6 57s808ms 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 #16
Day Hour Count Duration Avg duration Jul 18 20 3 28s629ms 9s543ms 23 3 29s179ms 9s726ms [ User: intelifix - Total duration: 57s808ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 57s808ms - 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-18 23:12:15 Duration: 23s536ms 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-18 20:04:12 Duration: 23s372ms 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-18 23:36:26 Duration: 3s899ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 1s407ms 14s897ms 7s198ms 6 43s191ms 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 18 20 3 20s692ms 6s897ms 23 3 22s499ms 7s499ms [ User: intelifix - Total duration: 43s191ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 43s191ms - 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-18 23:11:34 Duration: 14s897ms 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-18 20:03:32 Duration: 13s635ms 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-18 23:36:20 Duration: 5s933ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 3s260ms 8s889ms 6s50ms 6 36s303ms 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 18 20 3 17s886ms 5s962ms 23 3 18s417ms 6s139ms [ User: intelifix - Total duration: 36s303ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 36s303ms - 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-18 23:15:21 Duration: 8s889ms 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-18 20:10:15 Duration: 8s134ms 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-18 20:06:59 Duration: 6s431ms Database: rio User: intelifix Remote: [local] Application: pg_dump
19 834ms 14s902ms 5s862ms 6 35s176ms copy public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 18 20 3 17s887ms 5s962ms 23 3 17s289ms 5s763ms [ User: intelifix - Total duration: 35s176ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 35s176ms - Times executed: 6 ]
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-07-18 20:02:58 Duration: 14s902ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-07-18 23:10:59 Duration: 13s929ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-07-18 23:36:06 Duration: 2s466ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 2s384ms 14s927ms 5s747ms 6 34s485ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 18 00 3 21s328ms 7s109ms 06 3 13s156ms 4s385ms [ User: lenon - Total duration: 34s485ms - Times executed: 6 ]
[ Application: psql - Total duration: 34s485ms - Times executed: 6 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-07-18 00:02:17 Duration: 14s927ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-07-18 06:02:09 Duration: 6s769ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-07-18 06:02:13 Duration: 4s2ms Database: brasilia User: lenon Remote: [local] Application: psql
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 5 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jul 18 09 1 0ms 0ms 10 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 22 1 0ms 0ms [ User: intelifix - Total duration: 1s898ms - Times executed: 5 ]
[ Application: psql - Total duration: 1s898ms - Times executed: 5 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 5,262 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 16 FATAL entries
- 1504 ERROR entries
- 0 WARNING entries
- 1 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 1,409 Max number of times the same event was reported
- 1,521 Total events found
Rank Times reported Error 1 1,409 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 18 00 59 01 60 02 59 03 54 04 59 05 59 06 60 07 59 08 60 09 59 10 59 11 60 12 59 13 60 14 59 15 60 16 59 17 60 18 59 19 60 20 59 21 59 22 59 23 49 - ERROR: prepared statement "_PLAN0000000029A66A10" does not exist
- ERROR: prepared statement "_PLAN0000000029A82170" does not exist
- ERROR: prepared statement "_PLAN0000000029A81850" does not exist
Statement: DEALLOCATE "_PLAN0000000029A66A10"
Date: 2026-07-18 00:00:24 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029A82170"
Date: 2026-07-18 00:01:25 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029A81850"
Date: 2026-07-18 00:02:26 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 45 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #2
Day Hour Count Jul 18 00 2 01 2 02 2 03 2 04 2 05 2 06 2 07 2 08 2 09 2 10 1 11 2 12 2 13 2 14 2 15 2 16 2 17 2 18 2 19 2 20 2 21 2 22 2 - ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-18 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-18 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-18 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
3 45 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #3
Day Hour Count Jul 18 08 3 09 3 10 3 11 3 12 3 13 3 14 3 15 3 16 3 17 3 18 3 19 3 20 3 21 3 22 3 - ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-18 08:00:05 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-18 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-18 08:40:04 Database: brasilia Application: psql User: intelifix Remote: [local]
4 10 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #4
Day Hour Count Jul 18 03 10 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-07-18 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-07-18 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-07-18 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
5 4 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Jul 18 00 2 06 1 23 1 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "testes" does not exist
Date: 2026-07-18 00:02:23 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-07-18 00:24:33 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-07-18 06:02:15 Database: testes Application: [unknown] User: lenon Remote: [local]
6 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #6
Day Hour Count Jul 18 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-18 05:32:17 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-18 05:32:17 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-18 05:32:17 Database: contagem Application: psql User: intelifix Remote: [local]
7 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #7
Day Hour Count Jul 18 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-07-18 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-07-18 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
8 1 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv' PL/Python function "...", line 21, in <module> os.chmod(...) PL/Python function "..." PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Times Reported Most Frequent Error / Event #8
Day Hour Count Jul 18 10 1 - ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv' PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Context: Traceback (most recent call last):
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-18 10:05: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 18 03 1 - LOG: database system was shut down at 2026-07-18 03:05:02 -03
Date: 2026-07-18 03:05:03