pgBadger-
Global information
- Generated on Sat Aug 1 23:50:08 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 10,287 log entries in 7s
- Log start from 2026-08-01 00:00:07 to 2026-08-01 23:49:06
-
Overview
Global Stats
- 145 Number of unique normalized queries
- 1,247 Number of queries
- 4h54m45s Total query duration
- 2026-08-01 00:00:07 First query
- 2026-08-01 23:45:01 Last query
- 5 queries/s at 2026-08-01 23:44:34 Query peak
- 4h54m45s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 4h54m45s Execute total duration
- 1,435 Number of events
- 10 Number of unique normalized events
- 1,324 Max number of times the same event was reported
- 0 Number of cancellation
- 15 Total number of automatic vacuums
- 19 Total number of automatic analyzes
- 10 Number temporary file
- 238.45 MiB Max size of temporary file
- 110.83 MiB Average size of temporary file
- 218 Total number of sessions
- 7 sessions at 2026-08-01 06:04:38 Session peak
- 7d23h16m51s Total duration of sessions
- 52m38s Average duration of sessions
- 5 Average queries per session
- 1m21s Average queries duration per session
- 51m17s Average idle time per session
- 217 Total number of connections
- 7 connections/s at 2026-08-01 03:05:16 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-08-01 23:44:34 Date
SELECT Traffic
Key values
- 3 queries/s Query Peak
- 2026-08-01 23:44:02 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-08-01 23:44:34 Date
Queries duration
Key values
- 4h54m45s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 01 00 329 0ms 1m32s 7s41ms 1m13s 1m23s 2m19s 01 35 0ms 4s980ms 1s190ms 5s349ms 6s430ms 7s442ms 02 17 0ms 4s225ms 1s985ms 3s974ms 5s817ms 6s691ms 03 25 0ms 13s326ms 1s972ms 4s417ms 6s825ms 14s627ms 04 31 0ms 5s8ms 1s344ms 4s553ms 7s386ms 7s960ms 05 27 0ms 8m10s 38s539ms 9s158ms 2m17s 8m10s 06 15 0ms 8s837ms 3s609ms 4s303ms 4s723ms 31s253ms 07 21 0ms 8m27s 42s565ms 4s997ms 1m5s 8m27s 08 21 0ms 5m44s 29s867ms 4s311ms 47s612ms 5m44s 09 21 0ms 5m52s 30s206ms 4s87ms 49s154ms 5m52s 10 21 0ms 5m43s 30s228ms 4s512ms 47s536ms 5m43s 11 21 0ms 5m50s 30s840ms 4s387ms 48s309ms 5m50s 12 21 0ms 5m52s 30s814ms 4s341ms 47s999ms 5m52s 13 21 0ms 6m24s 33s420ms 4s868ms 52s333ms 6m24s 14 21 0ms 6m9s 32s803ms 4s819ms 16s490ms 6m43s 15 21 0ms 6m10s 32s290ms 4s610ms 18s488ms 6m45s 16 21 0ms 5m58s 31s740ms 4s906ms 52s91ms 5m58s 17 21 0ms 6m25s 33s668ms 4s736ms 53s486ms 6m25s 18 23 0ms 6m12s 31s47ms 4s880ms 17s357ms 6m45s 19 21 0ms 6m20s 33s536ms 4s954ms 21s623ms 6m55s 20 109 0ms 7m54s 13s797ms 1m5s 1m46s 8m29s 21 22 0ms 8m10s 38s717ms 4s935ms 49s83ms 8m45s 22 21 0ms 6m36s 34s282ms 4s450ms 58s905ms 6m36s 23 341 0ms 1m28s 6s116ms 1m9s 1m15s 1m31s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 01 00 6 299 7s137ms 1m2s 1m6s 1m12s 01 16 0 251ms 152ms 182ms 977ms 02 0 0 0ms 0ms 0ms 0ms 03 7 0 248ms 0ms 151ms 213ms 04 13 0 296ms 0ms 172ms 1s83ms 05 7 0 252ms 0ms 159ms 200ms 06 0 0 0ms 0ms 0ms 0ms 07 8 0 1m44s 0ms 0ms 3m48s 08 6 0 1m39s 0ms 0ms 3m25s 09 6 0 1m41s 0ms 0ms 3m25s 10 6 0 1m40s 0ms 0ms 3m34s 11 6 0 1m42s 0ms 0ms 3m38s 12 6 0 1m42s 0ms 0ms 3m37s 13 6 0 1m51s 0ms 0ms 3m53s 14 6 0 1m49s 0ms 0ms 3m57s 15 6 0 1m47s 0ms 0ms 3m42s 16 6 0 1m46s 0ms 0ms 3m45s 17 6 0 1m52s 0ms 0ms 3m57s 18 8 0 1m25s 0ms 0ms 4m18s 19 6 0 1m52s 0ms 0ms 3m55s 20 10 83 15s635ms 34s775ms 1m5s 4m17s 21 7 0 1m50s 0ms 0ms 3m45s 22 6 0 1m55s 0ms 0ms 3m55s 23 16 325 6s116ms 1m3s 1m9s 1m31s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 01 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Aug 01 00 0 1 1.00 0.00% 01 0 2 2.00 0.00% 02 0 0 0.00 0.00% 03 0 1 1.00 0.00% 04 0 3 3.00 0.00% 05 0 1 1.00 0.00% 06 0 0 0.00 0.00% 07 0 1 1.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 2 2.00 0.00% Day Hour Count Average / Second Aug 01 00 18 0.01/s 01 9 0.00/s 02 6 0.00/s 03 18 0.01/s 04 8 0.00/s 05 12 0.00/s 06 11 0.00/s 07 10 0.00/s 08 8 0.00/s 09 7 0.00/s 10 7 0.00/s 11 9 0.00/s 12 8 0.00/s 13 7 0.00/s 14 8 0.00/s 15 7 0.00/s 16 8 0.00/s 17 8 0.00/s 18 8 0.00/s 19 7 0.00/s 20 11 0.00/s 21 7 0.00/s 22 7 0.00/s 23 8 0.00/s Day Hour Count Average Duration Average idle time Aug 01 00 13 35m55s 32m57s 01 12 1h45s 1h41s 02 9 1h40s 1h36s 03 14 15m3s 15m 04 10 1h2m24s 1h2m20s 05 9 54m46s 52m51s 06 10 58m31s 58m25s 07 11 55m46s 54m25s 08 9 59m14s 58m4s 09 7 1h 58m29s 10 7 1h49s 59m18s 11 8 53m45s 52m24s 12 8 56m17s 54m56s 13 8 1h1m12s 59m44s 14 7 1h1m24s 59m46s 15 7 1h5s 58m28s 16 7 1h32s 58m57s 17 9 54m29s 53m10s 18 7 57m11s 55m29s 19 8 1h52s 59m24s 20 10 43m59s 41m29s 21 8 1h22s 58m36s 22 7 1h1m17s 59m34s 23 13 35m 32m19s -
Connections
Established Connections
Key values
- 7 connections Connection Peak
- 2026-08-01 03:05:16 Date
Connections per database
Key values
- brasilia Main Database
- 217 connections Total
Connections per user
Key values
- intelifix Main User
- 217 connections Total
-
Sessions
Simultaneous sessions
Key values
- 7 sessions Session Peak
- 2026-08-01 06:04:38 Date
Histogram of session times
Key values
- 181 3600000-28800000ms duration
Sessions per database
Key values
- brasilia Main Database
- 218 sessions Total
Sessions per user
Key values
- intelifix Main User
- 218 sessions Total
Sessions per host
Key values
- [local] Main Host
- 218 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 6,141 buffers Checkpoint Peak
- 2026-08-01 00:09:50 Date
- 269.850 seconds Highest write time
- 0.088 seconds Sync time
Checkpoints Wal files
Key values
- 3 files Wal files usage Peak
- 2026-08-01 00:09:50 Date
Checkpoints distance
Key values
- 96.79 Mo Distance Peak
- 2026-08-01 00:16:08 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Aug 01 00 8,116 468.06s 0.166s 468.287s 01 4,277 428.991s 0.077s 429.124s 02 2,303 231.044s 0.047s 231.125s 03 3,098 310.194s 0.089s 310.343s 04 4,341 435.604s 0.074s 435.75s 05 9,478 869.039s 0.106s 869.212s 06 2,199 220.106s 0.003s 220.127s 07 3,323 333.007s 0.009s 333.039s 08 23 2.33s 0.003s 2.338s 09 22 2.229s 0.004s 2.239s 10 22 2.229s 0.002s 2.236s 11 23 2.33s 0.003s 2.339s 12 22 2.237s 0.004s 2.248s 13 22 2.218s 0.003s 2.225s 14 23 2.328s 0.004s 2.338s 15 22 2.229s 0.003s 2.237s 16 22 2.218s 0.004s 2.226s 17 23 2.32s 0.004s 2.328s 18 397 39.824s 0.008s 39.851s 19 22 2.235s 0.004s 2.245s 20 266 26.71s 0.015s 26.749s 21 109 11.029s 0.018s 11.074s 22 22 2.248s 0.004s 2.258s 23 33 6.25s 0.004s 6.267s Day Hour Added Removed Recycled Synced files Longest sync Average sync Aug 01 00 0 0 6 653 0.009s 0.008s 01 0 0 2 572 0.007s 0.008s 02 0 0 0 384 0.006s 0.006s 03 0 0 1 443 0.006s 0.009s 04 0 0 2 693 0.006s 0.011s 05 0 0 4 579 0.010s 0.008s 06 0 0 0 9 0.002s 0.001s 07 0 0 2 63 0.002s 0.003s 08 0 0 0 3 0.002s 0.001s 09 0 0 0 3 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.001s 14 0 0 0 3 0.002s 0.002s 15 0 0 0 3 0.002s 0.001s 16 0 0 0 3 0.002s 0.002s 17 0 0 0 3 0.002s 0.002s 18 0 0 0 51 0.002s 0.003s 19 0 0 0 3 0.002s 0.002s 20 0 0 0 21 0.005s 0.004s 21 0 0 0 21 0.007s 0.007s 22 0 0 0 3 0.002s 0.002s 23 0 0 0 8 0.002s 0.003s Day Hour Count Avg time (sec) Aug 01 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Aug 01 00 14,032.43 kB 35,343.43 kB 01 2,281.00 kB 22,017.25 kB 02 1,957.83 kB 11,506.33 kB 03 1,476.33 kB 3,124.44 kB 04 2,153.27 kB 3,070.45 kB 05 8,768.62 kB 19,741.75 kB 06 6,582.00 kB 16,956.00 kB 07 7,196.67 kB 14,930.33 kB 08 178.00 kB 12,958.00 kB 09 177.00 kB 11,680.00 kB 10 177.00 kB 10,530.00 kB 11 178.00 kB 9,495.00 kB 12 177.00 kB 8,563.00 kB 13 178.00 kB 7,724.00 kB 14 178.00 kB 6,970.00 kB 15 177.00 kB 6,290.00 kB 16 178.00 kB 5,679.00 kB 17 178.00 kB 5,129.00 kB 18 613.33 kB 4,329.00 kB 19 178.00 kB 3,519.00 kB 20 507.67 kB 2,959.00 kB 21 93.50 kB 2,118.25 kB 22 178.00 kB 1,640.00 kB 23 56.00 kB 1,409.50 kB -
Temporary Files
Size of temporary files
Key values
- 476.91 MiB Temp Files size Peak
- 2026-08-01 05:32:02 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-08-01 05:30:38 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Aug 01 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 10 1.08 GiB 110.83 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 926.15 MiB 71.12 MiB 238.45 MiB 115.77 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-01 05:32:11 Duration: 1m29s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-01 05:32:02 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 2 182.17 MiB 91.09 MiB 91.09 MiB 91.09 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-01 05:30:41 Duration: 39s781ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-01 05:30:38 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 238.45 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-01 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 238.45 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-01 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 91.09 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-01 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 91.09 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-01 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 78.66 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-01 05:32:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 78.57 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-01 05:32:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 78.57 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-01 05:32:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 71.20 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-01 05:32:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 71.12 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-01 05:32:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 71.12 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-01 05:32:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.44 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_08
Database rio - 2026-08-01 01:34:53 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 0.44 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_08
Database rio - 2026-08-01 01:34:53 Date
Analyzes per table
Key values
- auditor.auditor_2026_08 (7) Main table analyzed (database rio)
- 19 analyzes Total
Vacuums per table
Key values
- auditor.auditor_2026_08 (4) Main table vacuumed on database rio
- 15 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.auditor.auditor_2026_08 4 0 0 0 0 0 0 3,937 2,849 3,576,610 464 8,264 brasilia.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 167 28 81,822 7 17 contagem.pg_catalog.pg_class 1 1 0 0 0 0 0 134 61 88,117 3 11 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 173 7 19,933 0 0 rio.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 901 125 808,076 86 354 rio.pg_catalog.pg_index 1 1 0 0 0 0 0 111 46 51,677 1 5 brasilia.auditor.auditor_2026_08 1 0 0 0 0 0 0 654 76 136,796 0 0 brasilia.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,467 165 725,819 144 1,031 rio.pg_catalog.pg_statistic 1 1 0 0 0 0 0 3,270 326 1,541,746 293 1,772 rio.public.temp0000287212 1 0 0 0 0 0 0 1,698 4 100,785 0 0 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,326 9 172,394 0 0 contagem.auditor.auditor_2026_08 1 0 0 0 0 0 0 762 4 47,043 0 0 Total 15 8 0 0 0 0 0 16,600 3,700 7,350,818 998 11,454 Vacuum throughput per table
Key values
- auditor.auditor_2026_08 (0.83) 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.auditor.auditor_2026_08 0 0 0.83 brasilia.pg_toast.pg_toast_2619 0 0 0 contagem.pg_catalog.pg_class 0 0 0.06 contagem.pg_toast.pg_toast_2619 0 0 0.02 rio.pg_toast.pg_toast_2619 0 0 0.08 rio.pg_catalog.pg_index 0 0 0.15 brasilia.auditor.auditor_2026_08 0 0 0.05 brasilia.pg_catalog.pg_statistic 0 0 0.13 rio.pg_catalog.pg_statistic 0 0 0.23 rio.public.temp0000287212 0 0 0.05 contagem.pg_catalog.pg_statistic 0 0 0.04 contagem.auditor.auditor_2026_08 0 0 0.04 Total 0 0 1.68 Tuples removed per table
Key values
- pg_catalog.pg_statistic (4218) Main table with removed tuples on database rio
- 13646 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_statistic 1 1 4,218 7,506 0 0 1,286 contagem.pg_catalog.pg_statistic 1 1 4,068 7,274 0 0 1,011 brasilia.pg_catalog.pg_statistic 1 1 3,982 7,346 0 0 1,072 rio.pg_toast.pg_toast_2619 1 1 703 674 0 32 257 rio.pg_catalog.pg_index 1 1 242 1,878 0 9 48 contagem.pg_catalog.pg_class 1 1 161 3,629 0 0 133 brasilia.pg_toast.pg_toast_2619 1 1 145 133 0 0 68 contagem.pg_toast.pg_toast_2619 1 1 127 117 0 7 54 brasilia.auditor.auditor_2026_08 1 0 0 22,752 0 0 651 rio.auditor.auditor_2026_08 4 0 0 185,436 0 0 7,741 rio.public.temp0000287212 1 0 0 23,930 0 0 1,728 contagem.auditor.auditor_2026_08 1 0 0 26,544 0 0 759 Total 15 8 13,646 287,219 0 48 14,808 Pages removed per table
Key values
- pg_toast.pg_toast_2619 (32) Main table with removed pages on database rio
- 48 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.pg_toast.pg_toast_2619 1 1 703 32 rio.pg_catalog.pg_index 1 1 242 9 contagem.pg_toast.pg_toast_2619 1 1 127 7 brasilia.pg_toast.pg_toast_2619 1 1 145 0 contagem.pg_catalog.pg_class 1 1 161 0 brasilia.auditor.auditor_2026_08 1 0 0 0 brasilia.pg_catalog.pg_statistic 1 1 3982 0 rio.auditor.auditor_2026_08 4 0 0 0 rio.pg_catalog.pg_statistic 1 1 4218 0 rio.public.temp0000287212 1 0 0 0 contagem.pg_catalog.pg_statistic 1 1 4068 0 contagem.auditor.auditor_2026_08 1 0 0 0 Total 15 8 13,646 48 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Aug 01 00 3 4 01 1 3 02 0 1 03 1 2 04 1 4 05 7 4 06 0 0 07 1 1 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 1 0 22 0 0 23 0 0 - 0.44 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- AccessExclusiveLock Main Lock Type
- 1 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 1 20s141ms 20s141ms 20s141ms 20s141ms select * from rs_auditor_novas_tabelas ();-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-08-01 00:02:23 Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-08-01 00:02:23 Database: contagem User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-08-01 00:02:22 Database: rio User: lenon Remote: [local] Application: psql
Queries that waited the most
Rank Wait time Query 1 20s141ms SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();[ Date: 2026-08-01 00:02:22 - Database: rio - User: lenon - Remote: [local] - Application: psql ]
-
Queries
Queries by type
Key values
- 170 Total read queries
- 709 Total write queries
Queries by database
Key values
- rio Main database
- 547 Requests
- 3h13m41s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 1,234 Requests
User Request type Count Duration etiquetas Total 3 1s283ms select 3 1s283ms intelifix Total 1,234 4h54m19s copy to 707 1h20m59s ddl 2 34s470ms others 368 32m19s select 157 3h26s lenon Total 10 23s818ms select 10 23s818ms Duration by user
Key values
- 4h54m19s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 3 1s283ms select 3 1s283ms intelifix Total 1,234 4h54m19s copy to 707 1h20m59s ddl 2 34s470ms others 368 32m19s select 157 3h26s lenon Total 10 23s818ms select 10 23s818ms Queries by host
Key values
- [local] Main host
- 1,247 Requests
- 4h54m45s ([local])
- Main time consuming host
Queries by application
Key values
- pg_dump Main application
- 728 Requests
- 3h32m51s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-08-01 07:25:19 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 479 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 8m27s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-01 07:13:28 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 8m10s analyze verbose;[ Date: 2026-08-01 05:08:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 8m10s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-01 21:13:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 7m54s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-01 20:12:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 6m36s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-01 22:11:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 6m25s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-01 17:11:27 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 6m24s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-01 13:11:25 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 6m20s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-01 19:11:22 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 6m12s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-01 18:11:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 6m10s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-01 15:11:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 6m9s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-01 14:11:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m58s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-01 16:10:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 5m52s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-01 12:10:54 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m52s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-01 09:10:53 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m50s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-01 11:10:51 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m44s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-01 08:10:46 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m43s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-01 10:10:44 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 4m16s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-08-01 18:16:21 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
19 4m12s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-08-01 20:18:46 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
20 4m8s analyze verbose;[ Date: 2026-08-01 05:12:20 - 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 1h49m32s 48 1s244ms 8m27s 2m16s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 01 07 3 9m5s 3m1s 08 3 6m2s 2m 09 3 6m10s 2m3s 10 3 6m1s 2m 11 3 6m7s 2m2s 12 3 6m11s 2m3s 13 3 6m43s 2m14s 14 3 6m27s 2m9s 15 3 6m30s 2m10s 16 3 6m16s 2m5s 17 3 6m44s 2m14s 18 3 6m31s 2m10s 19 3 6m44s 2m14s 20 3 8m25s 2m48s 21 3 8m30s 2m50s 22 3 6m58s 2m19s [ User: intelifix - Total duration: 1h49m32s - Times executed: 48 ]
[ Application: psql - Total duration: 1h49m32s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-01 07:13:28 Duration: 8m27s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-01 21:13:12 Duration: 8m10s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-01 20:12:55 Duration: 7m54s Database: rio User: intelifix Remote: [local] Application: psql
2 1h10m38s 48 181ms 4m16s 1m28s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 01 07 3 4m48s 1m36s 08 3 3m55s 1m18s 09 3 3m56s 1m18s 10 3 4m3s 1m21s 11 3 4m9s 1m23s 12 3 4m6s 1m22s 13 3 4m26s 1m28s 14 3 4m29s 1m29s 15 3 4m16s 1m25s 16 3 4m19s 1m26s 17 3 4m32s 1m30s 18 3 4m49s 1m36s 19 3 4m27s 1m29s 20 3 5m23s 1m47s 21 3 4m19s 1m26s 22 3 4m32s 1m30s [ User: intelifix - Total duration: 1h10m38s - Times executed: 48 ]
[ Application: psql - Total duration: 1h10m38s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-01 18:16:21 Duration: 4m16s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-01 20:18:46 Duration: 4m12s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-01 14:15:57 Duration: 3m55s Database: brasilia User: intelifix Remote: [local] Application: psql
3 14m36s 3 2m17s 8m10s 4m52s analyze verbose;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 01 05 3 14m36s 4m52s [ User: intelifix - Total duration: 14m36s - Times executed: 3 ]
[ Application: psql - Total duration: 14m36s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-01 05:08:12 Duration: 8m10s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-01 05:12:20 Duration: 4m8s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-01 05:14:38 Duration: 2m17s Database: contagem User: intelifix Remote: [local] Application: psql
4 11m33s 276 172ms 14s206ms 2s513ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 01 00 12 1m7s 5s662ms 01 12 27s874ms 2s322ms 02 12 24s630ms 2s52ms 03 12 36s536ms 3s44ms 04 12 27s235ms 2s269ms 05 12 25s821ms 2s151ms 06 12 28s276ms 2s356ms 07 12 25s452ms 2s121ms 08 12 25s445ms 2s120ms 09 12 25s 2s83ms 10 12 26s712ms 2s226ms 11 12 27s255ms 2s271ms 12 12 26s565ms 2s213ms 13 12 28s374ms 2s364ms 14 12 28s339ms 2s361ms 15 12 27s785ms 2s315ms 16 12 27s874ms 2s322ms 17 12 27s702ms 2s308ms 18 12 28s961ms 2s413ms 19 12 28s946ms 2s412ms 20 12 45s409ms 3s784ms 21 12 29s483ms 2s456ms 22 12 26s96ms 2s174ms [ User: intelifix - Total duration: 11m33s - Times executed: 276 ]
[ Application: psql - Total duration: 11m33s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-01 00:35:18 Duration: 14s206ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-01 20:05:15 Duration: 13s949ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-01 00:15:18 Duration: 13s553ms Database: rio User: intelifix Remote: [local] Application: psql
5 4m57s 6 4s607ms 1m41s 49s634ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 01 00 2 1m38s 49s82ms 20 2 1m46s 53s362ms 23 2 1m32s 46s459ms [ User: intelifix - Total duration: 4m57s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 4m57s - Times executed: 6 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-01 20:09:50 Duration: 1m41s 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-08-01 00:01:54 Duration: 1m32s 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-08-01 23:16:40 Duration: 1m28s Database: rio User: intelifix Remote: [local] Application: pg_dump
6 2m1s 5 333ms 1m6s 24s228ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 01 00 1 452ms 452ms 20 2 1m7s 33s555ms 23 2 53s580ms 26s790ms [ User: intelifix - Total duration: 2m1s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 2m1s - Times executed: 5 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-01 20:06:08 Duration: 1m6s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-01 23:13:25 Duration: 53s247ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-01 00:22:45 Duration: 452ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 1m50s 9 2s753ms 28s47ms 12s325ms 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 #7
Day Hour Count Duration Avg duration Aug 01 00 3 37s864ms 12s621ms 20 3 38s491ms 12s830ms 23 3 34s576ms 11s525ms [ User: intelifix - Total duration: 1m50s - Times executed: 9 ]
[ Application: pg_dump - Total duration: 1m50s - Times executed: 9 ]
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-08-01 20:10:18 Duration: 28s47ms 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-08-01 00:02:22 Duration: 27s720ms 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-08-01 23:17:07 Duration: 26s655ms Database: rio User: intelifix Remote: [local] Application: pg_dump
8 1m43s 8 2s764ms 33s170ms 12s967ms copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 01 00 2 11s842ms 5s921ms 20 3 46s307ms 15s435ms 23 3 45s587ms 15s195ms [ User: intelifix - Total duration: 1m43s - Times executed: 8 ]
[ Application: pg_dump - Total duration: 1m43s - Times executed: 8 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-08-01 20:06:43 Duration: 33s170ms 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-08-01 23:14:00 Duration: 33s151ms 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-08-01 20:11:20 Duration: 9s674ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
9 1m29s 1 1m29s 1m29s 1m29s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 01 05 1 1m29s 1m29s [ User: intelifix - Total duration: 1m29s - Times executed: 1 ]
[ Application: psql - Total duration: 1m29s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-01 05:32:11 Duration: 1m29s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-01 05:32:02 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
10 1m27s 8 1s924ms 31s819ms 10s881ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 01 00 2 8s537ms 4s268ms 20 3 40s609ms 13s536ms 23 3 37s907ms 12s635ms [ User: intelifix - Total duration: 1m27s - Times executed: 8 ]
[ Application: pg_dump - Total duration: 1m27s - Times executed: 8 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-01 20:07:20 Duration: 31s819ms 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-08-01 23:14:33 Duration: 29s248ms 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-08-01 20:11:28 Duration: 6s801ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 1m23s 33 737ms 49s83ms 2s515ms 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 #11
Day Hour Count Duration Avg duration Aug 01 08 2 2s843ms 1s421ms 09 2 1s748ms 874ms 10 2 1s988ms 994ms 11 3 2s955ms 985ms 12 3 2s540ms 846ms 13 3 3s113ms 1s37ms 14 2 2s145ms 1s72ms 15 2 2s130ms 1s65ms 16 1 1s101ms 1s101ms 17 2 1s905ms 952ms 18 1 1s30ms 1s30ms 19 3 3s29ms 1s9ms 20 3 4s203ms 1s401ms 21 2 50s85ms 25s42ms 22 2 2s187ms 1s93ms [ User: intelifix - Total duration: 1m23s - Times executed: 33 ]
[ Application: psql - Total duration: 1m23s - Times executed: 33 ]
-
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-08-01 21:00:50 Duration: 49s83ms 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-08-01 20:20:03 Duration: 2s396ms 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-08-01 08:00:04 Duration: 2s82ms Database: rio User: intelifix Remote: [local] Application: psql
12 1m14s 8 1s952ms 22s664ms 9s293ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 01 00 2 11s537ms 5s768ms 20 3 32s613ms 10s871ms 23 3 30s196ms 10s65ms [ User: intelifix - Total duration: 1m14s - Times executed: 8 ]
[ Application: pg_dump - Total duration: 1m14s - Times executed: 8 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-01 20:02:53 Duration: 22s664ms 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-08-01 23:10:45 Duration: 19s889ms 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-08-01 00:22:16 Duration: 8s577ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 1m14s 8 1s571ms 24s744ms 9s279ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 01 00 2 10s838ms 5s419ms 20 3 34s380ms 11s460ms 23 3 29s13ms 9s671ms [ User: intelifix - Total duration: 1m14s - Times executed: 8 ]
[ Application: pg_dump - Total duration: 1m14s - Times executed: 8 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-01 20:03:34 Duration: 24s744ms 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-08-01 23:11:20 Duration: 20s380ms 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-08-01 00:22:26 Duration: 7s862ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 1m12s 6 8s291ms 16s63ms 12s89ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 01 00 3 46s676ms 15s558ms 06 3 25s863ms 8s621ms [ User: intelifix - Total duration: 1m12s - Times executed: 6 ]
[ Application: psql - Total duration: 1m12s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-01 00:05:48 Duration: 16s63ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-01 00:05:17 Duration: 15s608ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-01 00:05:32 Duration: 15s4ms Database: brasilia User: intelifix Remote: [local] Application: psql
15 1m11s 32 231ms 12s486ms 2s240ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 01 00 6 24s230ms 4s38ms 01 6 9s593ms 1s598ms 02 5 9s117ms 1s823ms 03 5 10s827ms 2s165ms 04 6 10s590ms 1s765ms 05 3 7s121ms 2s373ms 20 1 231ms 231ms [ User: intelifix - Total duration: 1m11s - Times executed: 32 ]
[ Application: psql - Total duration: 1m11s - Times executed: 32 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-01 00:05:13 Duration: 12s486ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-01 05:05:06 Duration: 5s181ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-01 03:15:05 Duration: 4s95ms Database: rio User: intelifix Remote: [local] Application: psql
16 1m4s 8 1s648ms 23s740ms 8s70ms 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 Aug 01 00 2 6s981ms 3s490ms 20 3 30s725ms 10s241ms 23 3 26s855ms 8s951ms [ User: intelifix - Total duration: 1m4s - Times executed: 8 ]
[ Application: pg_dump - Total duration: 1m4s - Times executed: 8 ]
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-08-01 20:04:38 Duration: 23s740ms 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-08-01 23:12:11 Duration: 20s979ms 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-08-01 00:22:40 Duration: 4s543ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 1m2s 9 3s80ms 9s605ms 6s910ms 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 Aug 01 00 3 20s304ms 6s768ms 20 3 23s87ms 7s695ms 23 3 18s801ms 6s267ms [ User: intelifix - Total duration: 1m2s - Times executed: 9 ]
[ Application: pg_dump - Total duration: 1m2s - Times executed: 9 ]
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-08-01 20:11:42 Duration: 9s605ms 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-08-01 00:00:07 Duration: 8s814ms 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-08-01 20:07:50 Duration: 8s634ms Database: rio User: intelifix Remote: [local] Application: pg_dump
18 58s8ms 8 1s642ms 17s385ms 7s251ms 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 Aug 01 00 2 9s65ms 4s532ms 20 3 27s1ms 9s 23 3 21s941ms 7s313ms [ User: intelifix - Total duration: 58s8ms - Times executed: 8 ]
[ Application: pg_dump - Total duration: 58s8ms - Times executed: 8 ]
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-08-01 20:03:51 Duration: 17s385ms 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-08-01 23:11:34 Duration: 13s593ms 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-08-01 20:10:57 Duration: 7s973ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 55s295ms 5 3s657ms 23s272ms 11s59ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 01 00 1 3s657ms 3s657ms 20 2 27s453ms 13s726ms 23 2 24s185ms 12s92ms [ User: intelifix - Total duration: 55s295ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 55s295ms - Times executed: 5 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-08-01 20:05:01 Duration: 23s272ms 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-08-01 23:12:32 Duration: 20s435ms 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-08-01 20:11:10 Duration: 4s180ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 50s706ms 6 369ms 18s15ms 8s451ms copy public.posicao_estoque47 (ofi_id, ofi_nome, gru_id, gru_nome, cli_id, cli_nome, data_hora, serie, box, temporario, end_principal, barra1, barra2, barra3, barra4, extra1, extra2, extra3, extra4, acessorio1, acessorio2, mod_id, modelo, fornecedor, legado, legado_original, nf_entrada, nfgvt, nf_saida, valor, city, state, sap, data_entrada, data_conserto, data_insp, data_cq, data_expedicao, lot_saida, tipo_lote, status, detalhe, status_id, defeitos, triagem_data, triagem_tec, flu_id, eq_id, flu_status, pas_id, pas_nome, res_id, res_nome, mot_id, mot_nome, tcn_id, tcn_nome, garantia_fab, garantia_niv, oow, li_id, is_id, versao_hard, versao_soft, validado, auditoria, ultimo_evento, ultimo_evento_data, dias, sit_id, situacao) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 01 00 3 26s441ms 8s813ms 23 3 24s265ms 8s88ms [ User: intelifix - Total duration: 50s706ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 50s706ms - Times executed: 6 ]
-
COPY public.posicao_estoque47 (ofi_id, ofi_nome, gru_id, gru_nome, cli_id, cli_nome, data_hora, serie, box, temporario, end_principal, barra1, barra2, barra3, barra4, extra1, extra2, extra3, extra4, acessorio1, acessorio2, mod_id, modelo, fornecedor, legado, legado_original, nf_entrada, nfgvt, nf_saida, valor, city, state, sap, data_entrada, data_conserto, data_insp, data_cq, data_expedicao, lot_saida, tipo_lote, status, detalhe, status_id, defeitos, triagem_data, triagem_tec, flu_id, eq_id, flu_status, pas_id, pas_nome, res_id, res_nome, mot_id, mot_nome, tcn_id, tcn_nome, garantia_fab, garantia_niv, oow, li_id, is_id, versao_hard, versao_soft, validado, auditoria, ultimo_evento, ultimo_evento_data, dias, sit_id, situacao) TO stdout;
Date: 2026-08-01 23:27:00 Duration: 18s15ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.posicao_estoque47 (ofi_id, ofi_nome, gru_id, gru_nome, cli_id, cli_nome, data_hora, serie, box, temporario, end_principal, barra1, barra2, barra3, barra4, extra1, extra2, extra3, extra4, acessorio1, acessorio2, mod_id, modelo, fornecedor, legado, legado_original, nf_entrada, nfgvt, nf_saida, valor, city, state, sap, data_entrada, data_conserto, data_insp, data_cq, data_expedicao, lot_saida, tipo_lote, status, detalhe, status_id, defeitos, triagem_data, triagem_tec, flu_id, eq_id, flu_status, pas_id, pas_nome, res_id, res_nome, mot_id, mot_nome, tcn_id, tcn_nome, garantia_fab, garantia_niv, oow, li_id, is_id, versao_hard, versao_soft, validado, auditoria, ultimo_evento, ultimo_evento_data, dias, sit_id, situacao) TO stdout;
Date: 2026-08-01 00:13:10 Duration: 17s726ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.posicao_estoque47 (ofi_id, ofi_nome, gru_id, gru_nome, cli_id, cli_nome, data_hora, serie, box, temporario, end_principal, barra1, barra2, barra3, barra4, extra1, extra2, extra3, extra4, acessorio1, acessorio2, mod_id, modelo, fornecedor, legado, legado_original, nf_entrada, nfgvt, nf_saida, valor, city, state, sap, data_entrada, data_conserto, data_insp, data_cq, data_expedicao, lot_saida, tipo_lote, status, detalhe, status_id, defeitos, triagem_data, triagem_tec, flu_id, eq_id, flu_status, pas_id, pas_nome, res_id, res_nome, mot_id, mot_nome, tcn_id, tcn_nome, garantia_fab, garantia_niv, oow, li_id, is_id, versao_hard, versao_soft, validado, auditoria, ultimo_evento, ultimo_evento_data, dias, sit_id, situacao) TO stdout;
Date: 2026-08-01 00:30:10 Duration: 8s199ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 276 11m33s 172ms 14s206ms 2s513ms call rs_giga_triagem (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 01 00 12 1m7s 5s662ms 01 12 27s874ms 2s322ms 02 12 24s630ms 2s52ms 03 12 36s536ms 3s44ms 04 12 27s235ms 2s269ms 05 12 25s821ms 2s151ms 06 12 28s276ms 2s356ms 07 12 25s452ms 2s121ms 08 12 25s445ms 2s120ms 09 12 25s 2s83ms 10 12 26s712ms 2s226ms 11 12 27s255ms 2s271ms 12 12 26s565ms 2s213ms 13 12 28s374ms 2s364ms 14 12 28s339ms 2s361ms 15 12 27s785ms 2s315ms 16 12 27s874ms 2s322ms 17 12 27s702ms 2s308ms 18 12 28s961ms 2s413ms 19 12 28s946ms 2s412ms 20 12 45s409ms 3s784ms 21 12 29s483ms 2s456ms 22 12 26s96ms 2s174ms [ User: intelifix - Total duration: 11m33s - Times executed: 276 ]
[ Application: psql - Total duration: 11m33s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-01 00:35:18 Duration: 14s206ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-01 20:05:15 Duration: 13s949ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-01 00:15:18 Duration: 13s553ms Database: rio User: intelifix Remote: [local] Application: psql
2 48 1h49m32s 1s244ms 8m27s 2m16s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 01 07 3 9m5s 3m1s 08 3 6m2s 2m 09 3 6m10s 2m3s 10 3 6m1s 2m 11 3 6m7s 2m2s 12 3 6m11s 2m3s 13 3 6m43s 2m14s 14 3 6m27s 2m9s 15 3 6m30s 2m10s 16 3 6m16s 2m5s 17 3 6m44s 2m14s 18 3 6m31s 2m10s 19 3 6m44s 2m14s 20 3 8m25s 2m48s 21 3 8m30s 2m50s 22 3 6m58s 2m19s [ User: intelifix - Total duration: 1h49m32s - Times executed: 48 ]
[ Application: psql - Total duration: 1h49m32s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-01 07:13:28 Duration: 8m27s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-01 21:13:12 Duration: 8m10s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-01 20:12:55 Duration: 7m54s Database: rio User: intelifix Remote: [local] Application: psql
3 48 1h10m38s 181ms 4m16s 1m28s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 01 07 3 4m48s 1m36s 08 3 3m55s 1m18s 09 3 3m56s 1m18s 10 3 4m3s 1m21s 11 3 4m9s 1m23s 12 3 4m6s 1m22s 13 3 4m26s 1m28s 14 3 4m29s 1m29s 15 3 4m16s 1m25s 16 3 4m19s 1m26s 17 3 4m32s 1m30s 18 3 4m49s 1m36s 19 3 4m27s 1m29s 20 3 5m23s 1m47s 21 3 4m19s 1m26s 22 3 4m32s 1m30s [ User: intelifix - Total duration: 1h10m38s - Times executed: 48 ]
[ Application: psql - Total duration: 1h10m38s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-01 18:16:21 Duration: 4m16s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-01 20:18:46 Duration: 4m12s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-01 14:15:57 Duration: 3m55s Database: brasilia User: intelifix Remote: [local] Application: psql
4 33 1m23s 737ms 49s83ms 2s515ms 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 Aug 01 08 2 2s843ms 1s421ms 09 2 1s748ms 874ms 10 2 1s988ms 994ms 11 3 2s955ms 985ms 12 3 2s540ms 846ms 13 3 3s113ms 1s37ms 14 2 2s145ms 1s72ms 15 2 2s130ms 1s65ms 16 1 1s101ms 1s101ms 17 2 1s905ms 952ms 18 1 1s30ms 1s30ms 19 3 3s29ms 1s9ms 20 3 4s203ms 1s401ms 21 2 50s85ms 25s42ms 22 2 2s187ms 1s93ms [ User: intelifix - Total duration: 1m23s - Times executed: 33 ]
[ Application: psql - Total duration: 1m23s - Times executed: 33 ]
-
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-08-01 21:00:50 Duration: 49s83ms 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-08-01 20:20:03 Duration: 2s396ms 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-08-01 08:00:04 Duration: 2s82ms Database: rio User: intelifix Remote: [local] Application: psql
5 32 1m11s 231ms 12s486ms 2s240ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 01 00 6 24s230ms 4s38ms 01 6 9s593ms 1s598ms 02 5 9s117ms 1s823ms 03 5 10s827ms 2s165ms 04 6 10s590ms 1s765ms 05 3 7s121ms 2s373ms 20 1 231ms 231ms [ User: intelifix - Total duration: 1m11s - Times executed: 32 ]
[ Application: psql - Total duration: 1m11s - Times executed: 32 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-01 00:05:13 Duration: 12s486ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-01 05:05:06 Duration: 5s181ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-01 03:15:05 Duration: 4s95ms Database: rio User: intelifix Remote: [local] Application: psql
6 27 4s748ms 151ms 247ms 175ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 01 01 10 1s724ms 172ms 03 5 839ms 167ms 04 7 1s322ms 188ms 05 5 862ms 172ms [ User: intelifix - Total duration: 4s748ms - Times executed: 27 ]
[ Application: [unknown] - Total duration: 4s748ms - Times executed: 27 ]
-
SELECT * FROM RS_TRIAGEM (429, 5, '113', 3, '241768399011,241759836076,241760698898,241743669908,241766197785,241763734863,241760875055,241770764348,241772168895,241767099905', NULL, NULL, 0464, 00);
Date: 2026-08-01 04:18:42 Duration: 247ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (429, 5, '113', 3, '241768338702,241762420830,241747928102,241743589394,241762447475,241743999716,241743653341,241748002632,241766831619,241748132544,241766987896,241744008303,241763652734,241766119292,241766365860,241762137591,241766430817,241743833134,241766198189,241766582425', NULL, NULL, 0464, 00);
Date: 2026-08-01 03:51:17 Duration: 213ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (429, 5, '113', 3, '241766578585,241767170519,241767097379,241762294150,241747013052,241747052528,241741250324,241767035252,241766239608,241741023152,241759761221,241739691316,241767162942,241739022025,241766008193', NULL, NULL, 0464, 00);
Date: 2026-08-01 04:05:40 Duration: 204ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 12 10s971ms 751ms 1s131ms 914ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 01 08 1 1s93ms 1s93ms 09 1 818ms 818ms 10 1 1s113ms 1s113ms 14 1 833ms 833ms 15 1 779ms 779ms 16 2 1s509ms 754ms 17 1 757ms 757ms 18 2 1s873ms 936ms 21 1 1s60ms 1s60ms 22 1 1s131ms 1s131ms [ User: intelifix - Total duration: 10s971ms - Times executed: 12 ]
[ Application: psql - Total duration: 10s971ms - Times executed: 12 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-01 22:20:02 Duration: 1s131ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-01 10:00:02 Duration: 1s113ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-01 08:40:03 Duration: 1s93ms Database: rio User: intelifix Remote: [local] Application: psql
8 9 1m50s 2s753ms 28s47ms 12s325ms 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 #8
Day Hour Count Duration Avg duration Aug 01 00 3 37s864ms 12s621ms 20 3 38s491ms 12s830ms 23 3 34s576ms 11s525ms [ User: intelifix - Total duration: 1m50s - Times executed: 9 ]
[ Application: pg_dump - Total duration: 1m50s - Times executed: 9 ]
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-08-01 20:10:18 Duration: 28s47ms 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-08-01 00:02:22 Duration: 27s720ms 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-08-01 23:17:07 Duration: 26s655ms Database: rio User: intelifix Remote: [local] Application: pg_dump
9 9 1m2s 3s80ms 9s605ms 6s910ms 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 #9
Day Hour Count Duration Avg duration Aug 01 00 3 20s304ms 6s768ms 20 3 23s87ms 7s695ms 23 3 18s801ms 6s267ms [ User: intelifix - Total duration: 1m2s - Times executed: 9 ]
[ Application: pg_dump - Total duration: 1m2s - Times executed: 9 ]
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-08-01 20:11:42 Duration: 9s605ms 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-08-01 00:00:07 Duration: 8s814ms 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-08-01 20:07:50 Duration: 8s634ms Database: rio User: intelifix Remote: [local] Application: pg_dump
10 8 1m43s 2s764ms 33s170ms 12s967ms 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 #10
Day Hour Count Duration Avg duration Aug 01 00 2 11s842ms 5s921ms 20 3 46s307ms 15s435ms 23 3 45s587ms 15s195ms [ User: intelifix - Total duration: 1m43s - Times executed: 8 ]
[ Application: pg_dump - Total duration: 1m43s - Times executed: 8 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-08-01 20:06:43 Duration: 33s170ms 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-08-01 23:14:00 Duration: 33s151ms 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-08-01 20:11:20 Duration: 9s674ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 8 1m27s 1s924ms 31s819ms 10s881ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 01 00 2 8s537ms 4s268ms 20 3 40s609ms 13s536ms 23 3 37s907ms 12s635ms [ User: intelifix - Total duration: 1m27s - Times executed: 8 ]
[ Application: pg_dump - Total duration: 1m27s - Times executed: 8 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-01 20:07:20 Duration: 31s819ms 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-08-01 23:14:33 Duration: 29s248ms 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-08-01 20:11:28 Duration: 6s801ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 8 1m14s 1s952ms 22s664ms 9s293ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 01 00 2 11s537ms 5s768ms 20 3 32s613ms 10s871ms 23 3 30s196ms 10s65ms [ User: intelifix - Total duration: 1m14s - Times executed: 8 ]
[ Application: pg_dump - Total duration: 1m14s - Times executed: 8 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-01 20:02:53 Duration: 22s664ms 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-08-01 23:10:45 Duration: 19s889ms 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-08-01 00:22:16 Duration: 8s577ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 8 1m14s 1s571ms 24s744ms 9s279ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 01 00 2 10s838ms 5s419ms 20 3 34s380ms 11s460ms 23 3 29s13ms 9s671ms [ User: intelifix - Total duration: 1m14s - Times executed: 8 ]
[ Application: pg_dump - Total duration: 1m14s - Times executed: 8 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-01 20:03:34 Duration: 24s744ms 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-08-01 23:11:20 Duration: 20s380ms 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-08-01 00:22:26 Duration: 7s862ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 8 1m4s 1s648ms 23s740ms 8s70ms 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 Aug 01 00 2 6s981ms 3s490ms 20 3 30s725ms 10s241ms 23 3 26s855ms 8s951ms [ User: intelifix - Total duration: 1m4s - Times executed: 8 ]
[ Application: pg_dump - Total duration: 1m4s - Times executed: 8 ]
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-08-01 20:04:38 Duration: 23s740ms 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-08-01 23:12:11 Duration: 20s979ms 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-08-01 00:22:40 Duration: 4s543ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 8 58s8ms 1s642ms 17s385ms 7s251ms 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 #15
Day Hour Count Duration Avg duration Aug 01 00 2 9s65ms 4s532ms 20 3 27s1ms 9s 23 3 21s941ms 7s313ms [ User: intelifix - Total duration: 58s8ms - Times executed: 8 ]
[ Application: pg_dump - Total duration: 58s8ms - Times executed: 8 ]
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-08-01 20:03:51 Duration: 17s385ms 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-08-01 23:11:34 Duration: 13s593ms 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-08-01 20:10:57 Duration: 7s973ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 8 40s941ms 954ms 15s335ms 5s117ms 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 #16
Day Hour Count Duration Avg duration Aug 01 00 2 3s546ms 1s773ms 20 3 18s995ms 6s331ms 23 3 18s399ms 6s133ms [ User: intelifix - Total duration: 40s941ms - Times executed: 8 ]
[ Application: pg_dump - Total duration: 40s941ms - Times executed: 8 ]
-
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-08-01 20:03:09 Duration: 15s335ms 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-08-01 23:11:00 Duration: 15s108ms 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-08-01 20:10:41 Duration: 2s685ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 8 39s997ms 765ms 16s224ms 4s999ms 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 #17
Day Hour Count Duration Avg duration Aug 01 00 2 4s515ms 2s257ms 20 3 21s428ms 7s142ms 23 3 14s53ms 4s684ms [ User: intelifix - Total duration: 39s997ms - Times executed: 8 ]
[ Application: pg_dump - Total duration: 39s997ms - Times executed: 8 ]
-
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-08-01 20:02:26 Duration: 16s224ms 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-08-01 23:10:21 Duration: 10s586ms 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-08-01 20:10:30 Duration: 3s616ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 8 32s450ms 732ms 14s834ms 4s56ms copy public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 01 00 2 1s936ms 968ms 20 3 16s748ms 5s582ms 23 3 13s765ms 4s588ms [ User: intelifix - Total duration: 32s450ms - Times executed: 8 ]
[ Application: pg_dump - Total duration: 32s450ms - Times executed: 8 ]
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-08-01 20:04:14 Duration: 14s834ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-08-01 23:11:50 Duration: 12s200ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-08-01 00:35:04 Duration: 1s46ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
19 8 21s235ms 2s113ms 3s438ms 2s654ms copy ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 01 00 2 6s100ms 3s50ms 20 3 8s93ms 2s697ms 23 3 7s41ms 2s347ms [ User: intelifix - Total duration: 21s235ms - Times executed: 8 ]
[ Application: pg_dump - Total duration: 21s235ms - Times executed: 8 ]
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-08-01 00:34:51 Duration: 3s438ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-08-01 20:10:26 Duration: 2s833ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-08-01 20:12:06 Duration: 2s795ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
20 8 21s153ms 545ms 8s143ms 2s644ms copy public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 01 00 2 2s481ms 1s240ms 20 3 12s35ms 4s11ms 23 3 6s636ms 2s212ms [ User: intelifix - Total duration: 21s153ms - Times executed: 8 ]
[ Application: pg_dump - Total duration: 21s153ms - Times executed: 8 ]
-
COPY public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) TO stdout;
Date: 2026-08-01 20:03:59 Duration: 8s143ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) TO stdout;
Date: 2026-08-01 23:11:38 Duration: 4s144ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) TO stdout;
Date: 2026-08-01 20:11:00 Duration: 3s263ms 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 2m17s 8m10s 4m52s 3 14m36s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 01 05 3 14m36s 4m52s [ User: intelifix - Total duration: 14m36s - Times executed: 3 ]
[ Application: psql - Total duration: 14m36s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-01 05:08:12 Duration: 8m10s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-01 05:12:20 Duration: 4m8s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-01 05:14:38 Duration: 2m17s Database: contagem User: intelifix Remote: [local] Application: psql
2 1s244ms 8m27s 2m16s 48 1h49m32s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 01 07 3 9m5s 3m1s 08 3 6m2s 2m 09 3 6m10s 2m3s 10 3 6m1s 2m 11 3 6m7s 2m2s 12 3 6m11s 2m3s 13 3 6m43s 2m14s 14 3 6m27s 2m9s 15 3 6m30s 2m10s 16 3 6m16s 2m5s 17 3 6m44s 2m14s 18 3 6m31s 2m10s 19 3 6m44s 2m14s 20 3 8m25s 2m48s 21 3 8m30s 2m50s 22 3 6m58s 2m19s [ User: intelifix - Total duration: 1h49m32s - Times executed: 48 ]
[ Application: psql - Total duration: 1h49m32s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-01 07:13:28 Duration: 8m27s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-01 21:13:12 Duration: 8m10s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-01 20:12:55 Duration: 7m54s Database: rio User: intelifix Remote: [local] Application: psql
3 1m29s 1m29s 1m29s 1 1m29s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 01 05 1 1m29s 1m29s [ User: intelifix - Total duration: 1m29s - Times executed: 1 ]
[ Application: psql - Total duration: 1m29s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-01 05:32:11 Duration: 1m29s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-01 05:32:02 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
4 181ms 4m16s 1m28s 48 1h10m38s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 01 07 3 4m48s 1m36s 08 3 3m55s 1m18s 09 3 3m56s 1m18s 10 3 4m3s 1m21s 11 3 4m9s 1m23s 12 3 4m6s 1m22s 13 3 4m26s 1m28s 14 3 4m29s 1m29s 15 3 4m16s 1m25s 16 3 4m19s 1m26s 17 3 4m32s 1m30s 18 3 4m49s 1m36s 19 3 4m27s 1m29s 20 3 5m23s 1m47s 21 3 4m19s 1m26s 22 3 4m32s 1m30s [ User: intelifix - Total duration: 1h10m38s - Times executed: 48 ]
[ Application: psql - Total duration: 1h10m38s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-01 18:16:21 Duration: 4m16s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-01 20:18:46 Duration: 4m12s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-01 14:15:57 Duration: 3m55s Database: brasilia User: intelifix Remote: [local] Application: psql
5 4s607ms 1m41s 49s634ms 6 4m57s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 01 00 2 1m38s 49s82ms 20 2 1m46s 53s362ms 23 2 1m32s 46s459ms [ User: intelifix - Total duration: 4m57s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 4m57s - Times executed: 6 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-01 20:09:50 Duration: 1m41s 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-08-01 00:01:54 Duration: 1m32s 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-08-01 23:16:40 Duration: 1m28s Database: rio User: intelifix Remote: [local] Application: pg_dump
6 333ms 1m6s 24s228ms 5 2m1s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 01 00 1 452ms 452ms 20 2 1m7s 33s555ms 23 2 53s580ms 26s790ms [ User: intelifix - Total duration: 2m1s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 2m1s - Times executed: 5 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-01 20:06:08 Duration: 1m6s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-01 23:13:25 Duration: 53s247ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-01 00:22:45 Duration: 452ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 2s764ms 33s170ms 12s967ms 8 1m43s copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 01 00 2 11s842ms 5s921ms 20 3 46s307ms 15s435ms 23 3 45s587ms 15s195ms [ User: intelifix - Total duration: 1m43s - Times executed: 8 ]
[ Application: pg_dump - Total duration: 1m43s - Times executed: 8 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-08-01 20:06:43 Duration: 33s170ms 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-08-01 23:14:00 Duration: 33s151ms 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-08-01 20:11:20 Duration: 9s674ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 2s753ms 28s47ms 12s325ms 9 1m50s 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 #8
Day Hour Count Duration Avg duration Aug 01 00 3 37s864ms 12s621ms 20 3 38s491ms 12s830ms 23 3 34s576ms 11s525ms [ User: intelifix - Total duration: 1m50s - Times executed: 9 ]
[ Application: pg_dump - Total duration: 1m50s - Times executed: 9 ]
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-08-01 20:10:18 Duration: 28s47ms 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-08-01 00:02:22 Duration: 27s720ms 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-08-01 23:17:07 Duration: 26s655ms Database: rio User: intelifix Remote: [local] Application: pg_dump
9 8s291ms 16s63ms 12s89ms 6 1m12s call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 01 00 3 46s676ms 15s558ms 06 3 25s863ms 8s621ms [ User: intelifix - Total duration: 1m12s - Times executed: 6 ]
[ Application: psql - Total duration: 1m12s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-01 00:05:48 Duration: 16s63ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-01 00:05:17 Duration: 15s608ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-01 00:05:32 Duration: 15s4ms Database: brasilia User: intelifix Remote: [local] Application: psql
10 3s657ms 23s272ms 11s59ms 5 55s295ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 01 00 1 3s657ms 3s657ms 20 2 27s453ms 13s726ms 23 2 24s185ms 12s92ms [ User: intelifix - Total duration: 55s295ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 55s295ms - Times executed: 5 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-08-01 20:05:01 Duration: 23s272ms 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-08-01 23:12:32 Duration: 20s435ms 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-08-01 20:11:10 Duration: 4s180ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 1s924ms 31s819ms 10s881ms 8 1m27s copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 01 00 2 8s537ms 4s268ms 20 3 40s609ms 13s536ms 23 3 37s907ms 12s635ms [ User: intelifix - Total duration: 1m27s - Times executed: 8 ]
[ Application: pg_dump - Total duration: 1m27s - Times executed: 8 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-01 20:07:20 Duration: 31s819ms 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-08-01 23:14:33 Duration: 29s248ms 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-08-01 20:11:28 Duration: 6s801ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 1s952ms 22s664ms 9s293ms 8 1m14s copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 01 00 2 11s537ms 5s768ms 20 3 32s613ms 10s871ms 23 3 30s196ms 10s65ms [ User: intelifix - Total duration: 1m14s - Times executed: 8 ]
[ Application: pg_dump - Total duration: 1m14s - Times executed: 8 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-01 20:02:53 Duration: 22s664ms 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-08-01 23:10:45 Duration: 19s889ms 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-08-01 00:22:16 Duration: 8s577ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 1s571ms 24s744ms 9s279ms 8 1m14s copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 01 00 2 10s838ms 5s419ms 20 3 34s380ms 11s460ms 23 3 29s13ms 9s671ms [ User: intelifix - Total duration: 1m14s - Times executed: 8 ]
[ Application: pg_dump - Total duration: 1m14s - Times executed: 8 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-01 20:03:34 Duration: 24s744ms 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-08-01 23:11:20 Duration: 20s380ms 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-08-01 00:22:26 Duration: 7s862ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 369ms 18s15ms 8s451ms 6 50s706ms copy public.posicao_estoque47 (ofi_id, ofi_nome, gru_id, gru_nome, cli_id, cli_nome, data_hora, serie, box, temporario, end_principal, barra1, barra2, barra3, barra4, extra1, extra2, extra3, extra4, acessorio1, acessorio2, mod_id, modelo, fornecedor, legado, legado_original, nf_entrada, nfgvt, nf_saida, valor, city, state, sap, data_entrada, data_conserto, data_insp, data_cq, data_expedicao, lot_saida, tipo_lote, status, detalhe, status_id, defeitos, triagem_data, triagem_tec, flu_id, eq_id, flu_status, pas_id, pas_nome, res_id, res_nome, mot_id, mot_nome, tcn_id, tcn_nome, garantia_fab, garantia_niv, oow, li_id, is_id, versao_hard, versao_soft, validado, auditoria, ultimo_evento, ultimo_evento_data, dias, sit_id, situacao) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 01 00 3 26s441ms 8s813ms 23 3 24s265ms 8s88ms [ User: intelifix - Total duration: 50s706ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 50s706ms - Times executed: 6 ]
-
COPY public.posicao_estoque47 (ofi_id, ofi_nome, gru_id, gru_nome, cli_id, cli_nome, data_hora, serie, box, temporario, end_principal, barra1, barra2, barra3, barra4, extra1, extra2, extra3, extra4, acessorio1, acessorio2, mod_id, modelo, fornecedor, legado, legado_original, nf_entrada, nfgvt, nf_saida, valor, city, state, sap, data_entrada, data_conserto, data_insp, data_cq, data_expedicao, lot_saida, tipo_lote, status, detalhe, status_id, defeitos, triagem_data, triagem_tec, flu_id, eq_id, flu_status, pas_id, pas_nome, res_id, res_nome, mot_id, mot_nome, tcn_id, tcn_nome, garantia_fab, garantia_niv, oow, li_id, is_id, versao_hard, versao_soft, validado, auditoria, ultimo_evento, ultimo_evento_data, dias, sit_id, situacao) TO stdout;
Date: 2026-08-01 23:27:00 Duration: 18s15ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.posicao_estoque47 (ofi_id, ofi_nome, gru_id, gru_nome, cli_id, cli_nome, data_hora, serie, box, temporario, end_principal, barra1, barra2, barra3, barra4, extra1, extra2, extra3, extra4, acessorio1, acessorio2, mod_id, modelo, fornecedor, legado, legado_original, nf_entrada, nfgvt, nf_saida, valor, city, state, sap, data_entrada, data_conserto, data_insp, data_cq, data_expedicao, lot_saida, tipo_lote, status, detalhe, status_id, defeitos, triagem_data, triagem_tec, flu_id, eq_id, flu_status, pas_id, pas_nome, res_id, res_nome, mot_id, mot_nome, tcn_id, tcn_nome, garantia_fab, garantia_niv, oow, li_id, is_id, versao_hard, versao_soft, validado, auditoria, ultimo_evento, ultimo_evento_data, dias, sit_id, situacao) TO stdout;
Date: 2026-08-01 00:13:10 Duration: 17s726ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.posicao_estoque47 (ofi_id, ofi_nome, gru_id, gru_nome, cli_id, cli_nome, data_hora, serie, box, temporario, end_principal, barra1, barra2, barra3, barra4, extra1, extra2, extra3, extra4, acessorio1, acessorio2, mod_id, modelo, fornecedor, legado, legado_original, nf_entrada, nfgvt, nf_saida, valor, city, state, sap, data_entrada, data_conserto, data_insp, data_cq, data_expedicao, lot_saida, tipo_lote, status, detalhe, status_id, defeitos, triagem_data, triagem_tec, flu_id, eq_id, flu_status, pas_id, pas_nome, res_id, res_nome, mot_id, mot_nome, tcn_id, tcn_nome, garantia_fab, garantia_niv, oow, li_id, is_id, versao_hard, versao_soft, validado, auditoria, ultimo_evento, ultimo_evento_data, dias, sit_id, situacao) TO stdout;
Date: 2026-08-01 00:30:10 Duration: 8s199ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 1s648ms 23s740ms 8s70ms 8 1m4s copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 01 00 2 6s981ms 3s490ms 20 3 30s725ms 10s241ms 23 3 26s855ms 8s951ms [ User: intelifix - Total duration: 1m4s - Times executed: 8 ]
[ Application: pg_dump - Total duration: 1m4s - Times executed: 8 ]
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-08-01 20:04:38 Duration: 23s740ms 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-08-01 23:12:11 Duration: 20s979ms 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-08-01 00:22:40 Duration: 4s543ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 1s642ms 17s385ms 7s251ms 8 58s8ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 01 00 2 9s65ms 4s532ms 20 3 27s1ms 9s 23 3 21s941ms 7s313ms [ User: intelifix - Total duration: 58s8ms - Times executed: 8 ]
[ Application: pg_dump - Total duration: 58s8ms - Times executed: 8 ]
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-08-01 20:03:51 Duration: 17s385ms 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-08-01 23:11:34 Duration: 13s593ms 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-08-01 20:10:57 Duration: 7s973ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 3s80ms 9s605ms 6s910ms 9 1m2s 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 Aug 01 00 3 20s304ms 6s768ms 20 3 23s87ms 7s695ms 23 3 18s801ms 6s267ms [ User: intelifix - Total duration: 1m2s - Times executed: 9 ]
[ Application: pg_dump - Total duration: 1m2s - Times executed: 9 ]
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-08-01 20:11:42 Duration: 9s605ms 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-08-01 00:00:07 Duration: 8s814ms 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-08-01 20:07:50 Duration: 8s634ms Database: rio User: intelifix Remote: [local] Application: pg_dump
18 954ms 15s335ms 5s117ms 8 40s941ms 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 Aug 01 00 2 3s546ms 1s773ms 20 3 18s995ms 6s331ms 23 3 18s399ms 6s133ms [ User: intelifix - Total duration: 40s941ms - Times executed: 8 ]
[ Application: pg_dump - Total duration: 40s941ms - Times executed: 8 ]
-
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-08-01 20:03:09 Duration: 15s335ms 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-08-01 23:11:00 Duration: 15s108ms 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-08-01 20:10:41 Duration: 2s685ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 765ms 16s224ms 4s999ms 8 39s997ms 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 #19
Day Hour Count Duration Avg duration Aug 01 00 2 4s515ms 2s257ms 20 3 21s428ms 7s142ms 23 3 14s53ms 4s684ms [ User: intelifix - Total duration: 39s997ms - Times executed: 8 ]
[ Application: pg_dump - Total duration: 39s997ms - Times executed: 8 ]
-
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-08-01 20:02:26 Duration: 16s224ms 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-08-01 23:10:21 Duration: 10s586ms 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-08-01 20:10:30 Duration: 3s616ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 732ms 14s834ms 4s56ms 8 32s450ms copy public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 01 00 2 1s936ms 968ms 20 3 16s748ms 5s582ms 23 3 13s765ms 4s588ms [ User: intelifix - Total duration: 32s450ms - Times executed: 8 ]
[ Application: pg_dump - Total duration: 32s450ms - Times executed: 8 ]
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-08-01 20:04:14 Duration: 14s834ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-08-01 23:11:50 Duration: 12s200ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-08-01 00:35:04 Duration: 1s46ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
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 13 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Aug 01 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 14 1 0ms 0ms 15 2 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 2 0ms 0ms 19 1 0ms 0ms 22 2 0ms 0ms [ User: intelifix - Total duration: 14m - Times executed: 13 ]
[ Application: psql - Total duration: 14m - Times executed: 13 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 5,355 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 14 FATAL entries
- 1419 ERROR entries
- 0 WARNING entries
- 2 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 1,324 Max number of times the same event was reported
- 1,435 Total events found
Rank Times reported Error 1 1,324 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Aug 01 00 54 01 55 02 54 03 51 04 58 05 57 06 56 07 57 08 57 09 55 10 56 11 56 12 57 13 56 14 57 15 57 16 56 17 57 18 56 19 54 20 56 21 56 22 51 23 45 - ERROR: prepared statement "_PLAN0000000041163960" does not exist
- ERROR: prepared statement "_PLAN0000000041163960" does not exist
- ERROR: prepared statement "_PLAN0000000041169010" does not exist
Statement: DEALLOCATE "_PLAN0000000041163960"
Date: 2026-08-01 00:00:56 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000041163960"
Date: 2026-08-01 00:01:59 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000041169010"
Date: 2026-08-01 00:03:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
2 45 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #2
Day Hour Count Aug 01 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-08-01 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-08-01 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-08-01 08:40:03 Database: brasilia Application: psql User: intelifix Remote: [local]
3 44 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #3
Day Hour Count Aug 01 00 2 01 2 02 2 03 2 04 2 05 2 06 2 07 2 08 2 09 2 10 2 11 2 12 2 13 2 14 2 15 2 16 2 17 1 18 1 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-08-01 00:05: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-08-01 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-08-01 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
4 6 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #4
Day Hour Count Aug 01 03 6 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-08-01 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-01 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-01 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
5 5 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Aug 01 00 1 05 1 06 1 08 1 14 1 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "testes" does not exist
Date: 2026-08-01 00:02:23 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-08-01 05:38:54 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-01 06:02:02 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 Aug 01 05 4 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-01 05:32:11 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-01 05:32:11 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-01 05:32:11 Database: contagem Application: psql User: intelifix Remote: [local]
7 3 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #7
Day Hour Count Aug 01 03 3 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-08-01 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-01 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-01 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
8 2 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 Aug 01 17 1 18 1 - ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv' PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv' PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Context: Traceback (most recent call last):
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-08-01 17:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
Context: Traceback (most recent call last):
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-08-01 18:05:02 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 Aug 01 03 1 - LOG: database system was shut down at 2026-08-01 03:05:01 -03
Date: 2026-08-01 03:05:02
10 1 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #10
Day Hour Count Aug 01 00 1 - LOG: process 2272020 still waiting for AccessExclusiveLock on relation 362305 of database 358220 after 1000.125 ms
Detail: Process holding the lock: 2269137. Wait queue: 2272020.
Context: SQL statement "DROP TABLE IF EXISTS auditor.AUDITOR_2026_04" PL/pgSQL function rs_auditor_novas_tabelas(date) line 75 at EXECUTE
Statement: SELECT * FROM RS_AUDITOR_NOVAS_TABELAS()Date: 2026-08-01 00:02:03 Database: rio Application: psql User: lenon Remote: [local]