pgBadger-
Global information
- Generated on Sun Aug 30 23:50:13 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 7,774 log entries in 11s
- Log start from 2026-08-30 00:00:43 to 2026-08-30 23:46:11
-
Overview
Global Stats
- 158 Number of unique normalized queries
- 1,077 Number of queries
- 4h27m35s Total query duration
- 2026-08-30 00:02:48 First query
- 2026-08-30 23:46:11 Last query
- 4 queries/s at 2026-08-30 23:45:47 Query peak
- 4h27m35s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 4h27m35s Execute total duration
- 879 Number of events
- 6 Number of unique normalized events
- 858 Max number of times the same event was reported
- 0 Number of cancellation
- 12 Total number of automatic vacuums
- 5 Total number of automatic analyzes
- 12 Number temporary file
- 243.33 MiB Max size of temporary file
- 104.05 MiB Average size of temporary file
- 203 Total number of sessions
- 7 sessions at 2026-08-30 06:35:02 Session peak
- 7d13h27m54s Total duration of sessions
- 53m38s Average duration of sessions
- 5 Average queries per session
- 1m19s Average queries duration per session
- 52m19s Average idle time per session
- 209 Total number of connections
- 6 connections/s at 2026-08-30 03:05:16 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 4 queries/s Query Peak
- 2026-08-30 23:45:47 Date
SELECT Traffic
Key values
- 4 queries/s Query Peak
- 2026-08-30 23:45:02 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-08-30 23:45:47 Date
Queries duration
Key values
- 4h27m35s 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 30 00 24 0ms 44s946ms 8s598ms 5s628ms 24s133ms 1m23s 01 12 0ms 6s219ms 2s817ms 4s829ms 5s707ms 6s567ms 02 12 0ms 5s431ms 2s658ms 5s25ms 5s430ms 5s761ms 03 14 0ms 5s548ms 2s414ms 5s171ms 5s494ms 6s659ms 04 12 0ms 5s768ms 2s842ms 5s320ms 5s748ms 6s195ms 05 17 0ms 10m45s 1m22s 6s408ms 2m57s 10m45s 06 18 0ms 41s837ms 7s306ms 4s886ms 15s251ms 52s250ms 07 18 0ms 14m26s 1m16s 5s585ms 2m12s 14m26s 08 32 0ms 5m41s 20s318ms 7s60ms 47s131ms 5m41s 09 39 0ms 5m34s 16s128ms 5s361ms 50s391ms 5m34s 10 40 0ms 5m32s 15s803ms 5s605ms 46s492ms 5m32s 11 48 0ms 5m49s 13s560ms 5s54ms 48s773ms 5m49s 12 24 0ms 5m30s 24s886ms 5s249ms 46s443ms 5m30s 13 47 0ms 5m30s 13s384ms 6s19ms 47s95ms 5m30s 14 59 0ms 5m59s 11s354ms 6s102ms 8s754ms 6m49s 15 24 0ms 5m34s 25s342ms 3m7s 5m34s 5m34s 16 24 230ms 5m36s 25s526ms 3m9s 5m36s 5m36s 17 24 257ms 5m26s 24s865ms 3m4s 5m57s 5m57s 18 27 0ms 5m30s 22s322ms 3m2s 5m30s 5m30s 19 24 0ms 5m28s 25s278ms 3m13s 5m28s 5m28s 20 127 0ms 13m41s 14s936ms 2m59s 4m25s 13m41s 21 26 0ms 6m42s 25s919ms 3m9s 6m42s 6m42s 22 24 217ms 5m26s 25s6ms 3m4s 5m26s 5m26s 23 361 0ms 1m30s 5s968ms 1m7s 1m10s 2m11s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 30 00 4 0 17s605ms 0ms 0ms 15s114ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 3 0 22s500ms 0ms 0ms 15s251ms 07 6 0 3m44s 0ms 0ms 4m50s 08 13 0 44s599ms 0ms 156ms 3m8s 09 19 0 30s835ms 195ms 1s297ms 3m11s 10 17 0 34s348ms 384ms 1s978ms 3m11s 11 27 0 22s700ms 1s437ms 2s390ms 3m10s 12 6 0 1m33s 0ms 0ms 3m4s 13 24 0 24s506ms 1s193ms 3s568ms 3m5s 14 36 0 17s517ms 1s794ms 2s244ms 3m6s 15 6 0 1m34s 0ms 3m7s 5m34s 16 6 0 1m35s 49s231ms 3m9s 5m36s 17 6 0 1m33s 17s319ms 3m4s 5m57s 18 9 0 1m2s 47s949ms 3m2s 5m30s 19 6 0 1m34s 47s659ms 3m13s 5m28s 20 22 82 17s416ms 1m20s 2m59s 13m41s 21 7 0 1m30s 48s124ms 3m4s 6m42s 22 6 0 1m33s 47s553ms 3m4s 5m26s 23 36 325 5s968ms 1m2s 1m5s 2m8s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 30 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 30 00 0 1 1.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 1 1.00 0.00% 09 0 2 2.00 0.00% 10 0 2 2.00 0.00% 11 0 3 3.00 0.00% 12 0 0 0.00 0.00% 13 0 2 2.00 0.00% 14 0 2 2.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 0 0.00 0.00% Day Hour Count Average / Second Aug 30 00 14 0.00/s 01 5 0.00/s 02 7 0.00/s 03 18 0.01/s 04 8 0.00/s 05 9 0.00/s 06 15 0.00/s 07 9 0.00/s 08 9 0.00/s 09 9 0.00/s 10 10 0.00/s 11 11 0.00/s 12 7 0.00/s 13 10 0.00/s 14 9 0.00/s 15 5 0.00/s 16 6 0.00/s 17 5 0.00/s 18 5 0.00/s 19 6 0.00/s 20 9 0.00/s 21 5 0.00/s 22 5 0.00/s 23 13 0.00/s Day Hour Count Average Duration Average idle time Aug 30 00 8 57m 56m34s 01 13 1h42s 1h39s 02 5 1h 59m53s 03 14 18m46s 18m43s 04 8 1h2m37s 1h2m33s 05 9 54m44s 52m9s 06 7 1h 59m42s 07 15 57m38s 56m6s 08 8 57m30s 56m8s 09 9 1h57s 59m47s 10 10 55m 53m57s 11 10 55m18s 54m13s 12 11 55m43s 54m49s 13 6 1h55s 59m10s 14 9 55m53s 54m39s 15 9 1h1m17s 1h10s 16 5 1h41s 58m39s 17 6 1h3s 58m24s 18 5 1h1m6s 59m5s 19 5 1h1m42s 59m41s 20 9 41m7s 37m36s 21 6 1h1m7s 59m15s 22 5 1h1m5s 59m5s 23 11 30m33s 27m17s -
Connections
Established Connections
Key values
- 6 connections Connection Peak
- 2026-08-30 03:05:16 Date
Connections per database
Key values
- rio Main Database
- 209 connections Total
Connections per user
Key values
- intelifix Main User
- 209 connections Total
-
Sessions
Simultaneous sessions
Key values
- 7 sessions Session Peak
- 2026-08-30 06:35:02 Date
Histogram of session times
Key values
- 171 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 203 sessions Total
Sessions per user
Key values
- intelifix Main User
- 203 sessions Total
Sessions per host
Key values
- [local] Main Host
- 203 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 13,626 buffers Checkpoint Peak
- 2026-08-30 03:05:01 Date
- 269.710 seconds Highest write time
- 0.067 seconds Sync time
Checkpoints Wal files
Key values
- 5 files Wal files usage Peak
- 2026-08-30 03:05:01 Date
Checkpoints distance
Key values
- 139.96 Mo Distance Peak
- 2026-08-30 03:05:01 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Aug 30 00 5,500 269.71s 0.008s 269.738s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 13,626 0.59s 0.07s 0.678s 04 0 0s 0s 0s 05 7,264 734.921s 0.097s 735.054s 06 2,664 267.266s 0.003s 267.282s 07 1,289 129.17s 0.029s 129.208s 08 170 17.101s 0.049s 17.166s 09 772 77.526s 0.026s 77.584s 10 1,114 111.854s 0.085s 111.973s 11 2,744 275.221s 0.099s 275.368s 12 281 28.232s 0.038s 28.285s 13 2,103 210.849s 0.098s 210.985s 14 3,027 303.611s 0.099s 303.825s 15 815 81.82s 0.038s 81.882s 16 34 3.439s 0.008s 3.513s 17 23 2.32s 0.012s 2.336s 18 1,248 125.03s 0.086s 125.132s 19 23 2.32s 0.067s 2.393s 20 70 7.08s 0.016s 7.156s 21 41 4.152s 0.022s 4.19s 22 23 2.321s 0.015s 2.343s 23 141 14.182s 0.02s 14.214s Day Hour Added Removed Recycled Synced files Longest sync Average sync Aug 30 00 0 0 1 30 0.006s 0.001s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 5 36 0.050s 0.018s 04 0 0 0 0 0s 0s 05 0 0 3 153 0.019s 0.01s 06 0 0 0 10 0.002s 0.001s 07 0 0 1 19 0.016s 0.005s 08 0 0 0 51 0.027s 0.011s 09 0 0 0 225 0.010s 0.01s 10 0 0 0 328 0.034s 0.008s 11 0 0 1 614 0.060s 0.011s 12 0 0 0 64 0.031s 0.013s 13 0 0 1 422 0.062s 0.009s 14 0 0 0 820 0.036s 0.011s 15 0 0 1 188 0.013s 0.006s 16 0 0 0 10 0.004s 0.003s 17 0 0 0 3 0.009s 0.004s 18 0 0 0 75 0.061s 0.016s 19 0 0 0 3 0.064s 0.023s 20 0 0 0 31 0.003s 0.008s 21 0 0 0 13 0.010s 0.008s 22 0 0 0 3 0.013s 0.005s 23 0 0 0 81 0.011s 0.006s Day Hour Count Avg time (sec) Aug 30 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 30 00 27,719.00 kB 27,719.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 35,828.50 kB 35,828.50 kB 04 0.00 kB 0.00 kB 05 7,116.29 kB 10,175.86 kB 06 5,603.00 kB 11,106.00 kB 07 4,916.00 kB 10,422.50 kB 08 349.00 kB 8,105.67 kB 09 788.00 kB 5,390.33 kB 10 851.57 kB 3,085.00 kB 11 994.18 kB 2,028.91 kB 12 448.00 kB 1,445.33 kB 13 1,198.88 kB 2,006.12 kB 14 1,177.64 kB 1,916.18 kB 15 762.80 kB 1,807.60 kB 16 112.00 kB 1,310.00 kB 17 186.00 kB 1,144.00 kB 18 1,010.75 kB 3,126.25 kB 19 186.00 kB 2,431.00 kB 20 204.20 kB 1,854.80 kB 21 77.33 kB 1,250.33 kB 22 186.00 kB 1,029.00 kB 23 177.33 kB 859.67 kB -
Temporary Files
Size of temporary files
Key values
- 486.66 MiB Temp Files size Peak
- 2026-08-30 05:31:59 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-08-30 05:30:40 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Aug 30 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 12 1.22 GiB 104.05 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 945.47 MiB 72.58 MiB 243.33 MiB 118.18 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-30 05:32:06 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-30 05:31:59 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 4 303.18 MiB 56.35 MiB 92.73 MiB 75.79 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-30 05:30:44 Duration: 41s871ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-30 05:30:40 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 243.33 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-30 05:31:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 243.33 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-30 05:31:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 92.73 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-30 05:30:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 92.73 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-30 05:30:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 80.39 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-30 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 80.31 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-30 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 80.30 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-30 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 72.66 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-30 05:32:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 72.58 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-30 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 72.58 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-30 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 61.38 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-30 05:30:43 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 56.35 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-30 05:30:44 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.41 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database rio - 2026-08-30 05:11:34 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 0.41 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database rio - 2026-08-30 05:11:34 Date
Analyzes per table
Key values
- public.temp0000290018 (2) Main table analyzed (database rio)
- 5 analyzes Total
Vacuums per table
Key values
- public.temp0000290018 (2) Main table vacuumed on database rio
- 12 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.public.temp0000290018 2 0 0 0 0 0 0 174 12 12,088 0 0 rio.public.temp0000290020 2 0 0 0 0 0 0 174 91 175,902 0 0 brasilia.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,602 401 1,692,846 374 2,674 rio.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 810 219 945,856 91 338 rio.pg_catalog.pg_statistic 1 1 0 0 0 0 0 3,622 958 4,069,502 896 5,483 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,369 490 1,774,079 459 3,400 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 112 29 91,327 7 13 rio.pg_catalog.pg_class 1 1 0 0 0 0 0 345 135 146,761 5 9 brasilia.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 155 41 130,996 4 9 rio.pg_catalog.pg_index 1 1 0 0 0 0 0 101 37 25,892 1 1 Total 12 8 0 0 0 0 0 10,464 2,413 9,065,249 1,837 11,927 Vacuum throughput per table
Key values
- pg_catalog.pg_statistic (0.41) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.public.temp0000290018 0 0 0.02 rio.public.temp0000290020 0 0 0.04 brasilia.pg_catalog.pg_statistic 0 0 0.21 rio.pg_toast.pg_toast_2619 0 0 0.07 rio.pg_catalog.pg_statistic 0 0 0.41 contagem.pg_catalog.pg_statistic 0 0 0.11 contagem.pg_toast.pg_toast_2619 0 0 0 rio.pg_catalog.pg_class 0 0 0.4 brasilia.pg_toast.pg_toast_2619 0 0 0.04 rio.pg_catalog.pg_index 0 0 0.18 Total 0 0 1.48 Tuples removed per table
Key values
- pg_catalog.pg_statistic (4579) Main table with removed tuples on database rio
- 13860 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_statistic 1 1 4,579 7,472 0 0 1,286 contagem.pg_catalog.pg_statistic 1 1 4,181 7,274 0 0 1,011 brasilia.pg_catalog.pg_statistic 1 1 3,909 7,346 0 0 1,072 rio.pg_toast.pg_toast_2619 1 1 628 677 0 91 190 rio.pg_catalog.pg_class 1 1 232 3,367 0 0 120 rio.pg_catalog.pg_index 1 1 124 1,880 0 5 52 brasilia.pg_toast.pg_toast_2619 1 1 115 138 0 24 38 contagem.pg_toast.pg_toast_2619 1 1 92 116 0 0 51 rio.public.temp0000290018 2 0 0 2,462 0 98 158 rio.public.temp0000290020 2 0 0 2,462 0 98 158 Total 12 8 13,860 33,194 0 316 4,136 Pages removed per table
Key values
- public.temp0000290018 (98) Main table with removed pages on database rio
- 316 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000290018 2 0 0 98 rio.public.temp0000290020 2 0 0 98 rio.pg_toast.pg_toast_2619 1 1 628 91 brasilia.pg_toast.pg_toast_2619 1 1 115 24 rio.pg_catalog.pg_index 1 1 124 5 brasilia.pg_catalog.pg_statistic 1 1 3909 0 rio.pg_catalog.pg_statistic 1 1 4579 0 contagem.pg_catalog.pg_statistic 1 1 4181 0 contagem.pg_toast.pg_toast_2619 1 1 92 0 rio.pg_catalog.pg_class 1 1 232 0 Total 12 8 13,860 316 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Aug 30 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 6 0 06 0 0 07 0 0 08 1 1 09 1 1 10 2 2 11 1 0 12 0 0 13 1 1 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 - 0.41 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 259 Total read queries
- 428 Total write queries
Queries by database
Key values
- rio Main database
- 517 Requests
- 3h2m30s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 1,058 Requests
User Request type Count Duration etiquetas Total 1 184ms select 1 184ms intelifix Total 1,058 4h25m13s copy to 407 44m46s ddl 21 46s897ms others 390 39m43s select 240 2h59m55s lenon Total 18 2m22s select 18 2m22s Duration by user
Key values
- 4h25m13s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 1 184ms select 1 184ms intelifix Total 1,058 4h25m13s copy to 407 44m46s ddl 21 46s897ms others 390 39m43s select 240 2h59m55s lenon Total 18 2m22s select 18 2m22s Queries by host
Key values
- [local] Main host
- 1,077 Requests
- 4h27m35s ([local])
- Main time consuming host
Queries by application
Key values
- psql Main application
- 499 Requests
- 3h40m (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-08-30 11:11:23 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 406 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 14m26s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-30 07:19:27 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 13m41s SELECT * FROM RS_SMART_FISCAL_ENTRADA () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;[ Date: 2026-08-30 20:18:43 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 10m45s analyze verbose;[ Date: 2026-08-30 05:10:47 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 6m54s analyze verbose;[ Date: 2026-08-30 05:17:41 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
5 6m42s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-30 21:11:44 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 5m59s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-30 14:11:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 5m49s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-30 11:10:51 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 5m41s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-30 08:10:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 5m36s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-30 16:10:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 5m34s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-30 09:10:35 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 5m34s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-30 15:10:35 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m32s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-30 10:10:33 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 5m30s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-30 18:10:32 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m30s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-30 13:10:31 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m30s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-30 12:10:32 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m28s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-30 19:10:29 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m26s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-30 17:10:28 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 5m26s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-30 22:10:28 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 4m38s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-08-30 07:27:16 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
20 4m9s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-08-30 20:25:51 - 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 1h39m56s 47 1s250ms 14m26s 2m7s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 30 07 3 15m31s 5m10s 08 3 5m58s 1m59s 09 3 5m54s 1m58s 10 3 5m49s 1m56s 11 3 6m7s 2m2s 12 3 5m47s 1m55s 13 3 5m47s 1m55s 14 3 6m18s 2m6s 15 3 5m52s 1m57s 16 3 5m55s 1m58s 17 3 5m45s 1m55s 18 3 5m48s 1m56s 19 3 5m45s 1m55s 20 2 48s252ms 24s126ms 21 3 6m59s 2m19s 22 3 5m43s 1m54s [ User: intelifix - Total duration: 1h39m56s - Times executed: 47 ]
[ Application: psql - Total duration: 1h39m56s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-30 07:19:27 Duration: 14m26s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-30 21:11:44 Duration: 6m42s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-30 14:11:01 Duration: 5m59s Database: rio User: intelifix Remote: [local] Application: psql
2 1h4m12s 47 224ms 4m38s 1m21s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 30 07 3 6m54s 2m18s 08 3 3m38s 1m12s 09 3 3m42s 1m14s 10 3 3m41s 1m13s 11 3 3m41s 1m13s 12 3 3m32s 1m10s 13 3 3m34s 1m11s 14 3 3m39s 1m13s 15 3 3m36s 1m12s 16 3 3m39s 1m13s 17 3 3m33s 1m11s 18 3 3m32s 1m10s 19 3 3m43s 1m14s 20 3 6m31s 2m10s 21 2 3m35s 1m47s 22 3 3m35s 1m11s [ User: intelifix - Total duration: 1h4m12s - Times executed: 47 ]
[ Application: psql - Total duration: 1h4m12s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-30 07:27:16 Duration: 4m38s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-30 20:25:51 Duration: 4m9s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-30 19:14:29 Duration: 3m11s Database: brasilia User: intelifix Remote: [local] Application: psql
3 20m37s 3 2m57s 10m45s 6m52s analyze verbose;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 30 05 3 20m37s 6m52s [ User: intelifix - Total duration: 20m37s - Times executed: 3 ]
[ Application: psql - Total duration: 20m37s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-30 05:10:47 Duration: 10m45s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-30 05:17:41 Duration: 6m54s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-30 05:20:39 Duration: 2m57s Database: contagem User: intelifix Remote: [local] Application: psql
4 13m41s 1 13m41s 13m41s 13m41s select * from rs_smart_fiscal_entrada () / 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 30 20 1 13m41s 13m41s [ User: intelifix - Total duration: 13m41s - Times executed: 1 ]
[ Application: psql - Total duration: 13m41s - Times executed: 1 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-30 20:18:43 Duration: 13m41s Database: rio User: intelifix Remote: [local] Application: psql
5 13m39s 262 166ms 29s375ms 3s125ms call rs_giga_triagem (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 30 00 12 1m3s 5s306ms 01 12 33s813ms 2s817ms 02 12 31s902ms 2s658ms 03 12 32s944ms 2s745ms 04 12 34s111ms 2s842ms 05 12 32s533ms 2s711ms 06 12 30s89ms 2s507ms 07 12 31s309ms 2s609ms 08 12 32s856ms 2s738ms 09 12 31s940ms 2s661ms 10 12 32s549ms 2s712ms 11 12 32s187ms 2s682ms 12 12 31s457ms 2s621ms 13 12 32s203ms 2s683ms 14 12 33s523ms 2s793ms 15 10 32s438ms 3s243ms 16 10 32s138ms 3s213ms 17 10 32s2ms 3s200ms 18 10 31s858ms 3s185ms 19 10 31s371ms 3s137ms 20 11 1m15s 6s854ms 21 10 31s811ms 3s181ms 22 11 34s889ms 3s171ms [ User: intelifix - Total duration: 13m39s - Times executed: 262 ]
[ Application: psql - Total duration: 13m39s - Times executed: 262 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-30 00:05:31 Duration: 29s375ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-30 20:05:24 Duration: 22s458ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-30 20:15:23 Duration: 22s110ms Database: rio User: intelifix Remote: [local] Application: psql
6 3m9s 4 6s478ms 1m30s 47s364ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 30 20 2 1m32s 46s23ms 23 2 1m37s 48s705ms [ User: intelifix - Total duration: 3m9s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m9s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-30 23:17:11 Duration: 1m30s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-30 20:08:44 Duration: 1m25s 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-30 23:36:25 Duration: 6s605ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 2m17s 6 10s175ms 44s946ms 22s956ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 30 00 3 1m10s 23s412ms 06 3 1m7s 22s500ms [ User: lenon - Total duration: 2m17s - Times executed: 6 ]
[ Application: psql - Total duration: 2m17s - Times executed: 6 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-08-30 00:02:48 Duration: 44s946ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-08-30 06:02:44 Duration: 41s837ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-08-30 06:03:09 Duration: 15s251ms Database: contagem User: lenon Remote: [local] Application: psql
8 1m53s 4 408ms 56s714ms 28s349ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 30 20 2 57s122ms 28s561ms 23 2 56s276ms 28s138ms [ User: intelifix - Total duration: 1m53s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m53s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-30 20:05:34 Duration: 56s714ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-30 23:13:45 Duration: 55s842ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-30 23:35:50 Duration: 433ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
9 1m42s 6 10s672ms 24s133ms 17s53ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 30 00 3 1m8s 22s800ms 06 3 33s918ms 11s306ms [ User: intelifix - Total duration: 1m42s - Times executed: 6 ]
[ Application: psql - Total duration: 1m42s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-30 00:06:10 Duration: 24s133ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-30 00:05:25 Duration: 23s789ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-30 00:05:46 Duration: 20s478ms Database: brasilia User: intelifix Remote: [local] Application: psql
10 1m32s 6 2s428ms 35s290ms 15s404ms 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 30 20 3 45s523ms 15s174ms 23 3 46s902ms 15s634ms [ User: intelifix - Total duration: 1m32s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m32s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-08-30 23:14:24 Duration: 35s290ms 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-30 20:06:09 Duration: 33s114ms 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-30 20:10:13 Duration: 9s616ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 1m29s 62 164ms 5s437ms 1s438ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 30 09 7 6s978ms 996ms 10 6 10s176ms 1s696ms 11 12 20s182ms 1s681ms 13 13 22s942ms 1s764ms 14 24 28s928ms 1s205ms [ User: intelifix - Total duration: 1m29s - Times executed: 62 ]
[ Application: [unknown] - Total duration: 1m29s - Times executed: 62 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (282662, 317, '255041117421417,216525158602,216825678996,216891988498,216843727694,216524168796,216683690101,216522681941,216830371835,216889263149,216839503444,216880808989,216542506669,216728653546,216794265572,216882039098,216565880927,216526772239,216841504548,216820820207,216538058705,216683867996,216914576584,216566352645,216606025461,216830424971,216820530527,216848084663,216726769501,216648435773,216673257993,216889406372,216541248095,216565570515,216526913240,216855809300', '',064,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-30 13:35:24 Duration: 5s437ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (282662, 317, '258082115349296,216848157475,216844118091,216642531415,216450907393,216641902431,216530706483,216322740116,216446216172,216913893656,216322331636,216843129296,216880829193,216642926986,216853104659,216919117992,216684864446,216845709302,216540290214,216666889516,216673127879,216830044148,216623499399,216882096377,216535219606', '',064,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-30 13:27:48 Duration: 4s749ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (282688, 317, 'ZTE3ANNRCP34551,6C11BA6C5499,6C11BA6C549A,ZTEGDC6FC78A$ZTE3ANNQCA04834,14CA56D2B627,14CA56D2B628,ZTEGD971784D$ZTE3ANNQ8128166,689E29BE72EF,689E29BE72F0,ZTEGD7B7A896$ZTE3ANNR9W24143,D89A0DAA91FD,D89A0DAA91FE,ZTEGDB166FFA$ZTE3ANNQCA21074,14CA56D432C7,14CA56D432C8,ZTEGD971B7BD$ZTE3ANNR4N48787,4896D959D28A,4896D959D28B,ZTEGD97FDE58$ZTE3ANNR2Q57059,F4E84F85ED52,F4E84F85ED53,ZTEGD97B519D$ZTE3ANNQCA33026,14CA56D54AE7,14CA56D54AE8,ZTEGD971E66D$ZTE3ANNT2V58958,D8313990F4AC,D8313990F4AD,ZTEGDD30D8CD$ZTE3ANNT2V55429,D8313990A1F6,D8313990A1F7,ZTEGDD30CB04$ZTE3ANNT4P84126,F00C51535A52,F00C51535A53,ZTEGDE353F34$ZTE3ANNT3H36907,D831399A249A,D831399A249B,ZTEGDD3260CA$ZTE3ANNR5W32099,48D68231741C,48D68231741D,ZTEGDB007D62$ZTE3ANNRCB36836,D83139212E56,D83139212E57,ZTEGDD2A4579$ZTE3ANNRCB68619,D83139241740,D83139241741,ZTEGDD2AC1A0$ZTE3ANNR4N25515,4896D957B11A,4896D957B11B,ZTEGD97F8370$ZTE3ANNRCB01193,D831391DEAF4,D831391DEAF5,ZTEGDD29BA3E$ZTE3ANNQ7511960,C4EBFF8C0B8C,C4EBFF8C0B8D,ZTEGD70A7D58$ZTE3ANNR4N18184,4896D9570548,4896D9570549,ZTEGD97F66CD$ZTE3ANNRCP29792,6C11BA6BE50F,6C11BA6BE510,ZTEGDC6FB4F3$ZTE3ANNQ3616341,3CF9F0A6546C,3CF9F0A6546D,ZTEGD640A370$ZTE3ANNR2Q15994,F4E84F822ADC,F4E84F822ADD,ZTEGD97AB134$ZTE3ANNR3Y11313,4896D950C9DE,4896D950C9DF,ZTEGD97E5CE6$ZTE3ANNT2V91612,D8313993F200,D8313993F201,ZTEGDD31585B$ZTE3ANNR6R27163,48D682380164,48D682380165,ZTEGDB0194EE$ZTE3ANNR2Q19217,F4E84F827666,F4E84F827667,ZTEGD97ABDCB$ZTE3ANNQCA17580,14CA56D3E0E3,14CA56D3E0E4,ZTEGD971AA17$ZTE3ANNQCA36514,14CA56D59CA7,14CA56D59CA8,ZTEGD971F40D$ZTE3ANNRB762676,5872C993F629,5872C993F62A,ZTEGDC621FA7$ZTE3ANNQ5207920,3CF9F0A7E4B6,3CF9F0A7E4B7,ZTEGD640E627', '',0318,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-30 11:24:18 Duration: 4s568ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 1m22s 1 1m22s 1m22s 1m22s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 30 05 1 1m22s 1m22s [ User: intelifix - Total duration: 1m22s - Times executed: 1 ]
[ Application: psql - Total duration: 1m22s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-30 05:32:06 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-30 05:31:59 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
13 1m16s 6 2s73ms 31s37ms 12s799ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 30 20 3 35s915ms 11s971ms 23 3 40s880ms 13s626ms [ User: intelifix - Total duration: 1m16s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m16s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-30 23:14:59 Duration: 31s37ms 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-30 20:06:41 Duration: 27s72ms 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-30 23:36:07 Duration: 7s677ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 1m10s 6 2s909ms 27s21ms 11s769ms copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 30 20 3 35s618ms 11s872ms 23 3 34s999ms 11s666ms [ User: intelifix - Total duration: 1m10s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m10s - Times executed: 6 ]
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-08-30 20:09:12 Duration: 27s21ms 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-30 23:17:37 Duration: 25s795ms 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-30 23:36:32 Duration: 6s192ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 1m4s 6 1s474ms 27s360ms 10s828ms 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 30 20 3 31s187ms 10s395ms 23 3 33s781ms 11s260ms [ User: intelifix - Total duration: 1m4s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m4s - Times executed: 6 ]
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-08-30 23:12:28 Duration: 27s360ms 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-30 20:04:18 Duration: 25s190ms 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-30 23:35:45 Duration: 4s740ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 1m4s 6 2s122ms 22s103ms 10s788ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 30 20 3 32s859ms 10s953ms 23 3 31s872ms 10s624ms [ User: intelifix - Total duration: 1m4s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m4s - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-30 23:11:28 Duration: 22s103ms 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-30 20:03:22 Duration: 21s772ms 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-30 20:09:44 Duration: 8s965ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 1m4s 6 2s341ms 22s667ms 10s682ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 30 20 3 30s545ms 10s181ms 23 3 33s550ms 11s183ms [ User: intelifix - Total duration: 1m4s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m4s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-30 23:10:50 Duration: 22s667ms 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-30 20:02:46 Duration: 19s793ms 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-30 20:09:32 Duration: 8s410ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 49s301ms 4 3s982ms 21s142ms 12s325ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 30 20 2 24s176ms 12s88ms 23 2 25s124ms 12s562ms [ User: intelifix - Total duration: 49s301ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 49s301ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-08-30 23:12:49 Duration: 21s142ms 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-30 20:04:37 Duration: 19s662ms 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-30 20:10:03 Duration: 4s513ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 47s189ms 53 585ms 1s973ms 890ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 30 08 3 3s132ms 1s44ms 09 4 3s332ms 833ms 10 3 2s349ms 783ms 11 4 3s416ms 854ms 12 5 4s393ms 878ms 13 4 3s580ms 895ms 14 4 3s307ms 826ms 15 3 2s595ms 865ms 16 3 2s499ms 833ms 17 3 2s536ms 845ms 18 4 3s709ms 927ms 19 3 2s706ms 902ms 20 3 2s512ms 837ms 21 3 2s299ms 766ms 22 4 4s817ms 1s204ms [ User: intelifix - Total duration: 47s189ms - Times executed: 53 ]
[ Application: psql - Total duration: 47s189ms - Times executed: 53 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-30 22:20:04 Duration: 1s973ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-30 08:00:09 Duration: 1s387ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-30 18:20:02 Duration: 1s165ms Database: rio User: intelifix Remote: [local] Application: psql
20 46s862ms 6 1s517ms 15s381ms 7s810ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 30 20 3 22s901ms 7s633ms 23 3 23s960ms 7s986ms [ User: intelifix - Total duration: 46s862ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 46s862ms - Times executed: 6 ]
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-08-30 23:11:44 Duration: 15s381ms 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-30 20:03:37 Duration: 14s965ms 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-30 23:35:38 Duration: 6s777ms 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 262 13m39s 166ms 29s375ms 3s125ms call rs_giga_triagem (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 30 00 12 1m3s 5s306ms 01 12 33s813ms 2s817ms 02 12 31s902ms 2s658ms 03 12 32s944ms 2s745ms 04 12 34s111ms 2s842ms 05 12 32s533ms 2s711ms 06 12 30s89ms 2s507ms 07 12 31s309ms 2s609ms 08 12 32s856ms 2s738ms 09 12 31s940ms 2s661ms 10 12 32s549ms 2s712ms 11 12 32s187ms 2s682ms 12 12 31s457ms 2s621ms 13 12 32s203ms 2s683ms 14 12 33s523ms 2s793ms 15 10 32s438ms 3s243ms 16 10 32s138ms 3s213ms 17 10 32s2ms 3s200ms 18 10 31s858ms 3s185ms 19 10 31s371ms 3s137ms 20 11 1m15s 6s854ms 21 10 31s811ms 3s181ms 22 11 34s889ms 3s171ms [ User: intelifix - Total duration: 13m39s - Times executed: 262 ]
[ Application: psql - Total duration: 13m39s - Times executed: 262 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-30 00:05:31 Duration: 29s375ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-30 20:05:24 Duration: 22s458ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-30 20:15:23 Duration: 22s110ms Database: rio User: intelifix Remote: [local] Application: psql
2 62 1m29s 164ms 5s437ms 1s438ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 30 09 7 6s978ms 996ms 10 6 10s176ms 1s696ms 11 12 20s182ms 1s681ms 13 13 22s942ms 1s764ms 14 24 28s928ms 1s205ms [ User: intelifix - Total duration: 1m29s - Times executed: 62 ]
[ Application: [unknown] - Total duration: 1m29s - Times executed: 62 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (282662, 317, '255041117421417,216525158602,216825678996,216891988498,216843727694,216524168796,216683690101,216522681941,216830371835,216889263149,216839503444,216880808989,216542506669,216728653546,216794265572,216882039098,216565880927,216526772239,216841504548,216820820207,216538058705,216683867996,216914576584,216566352645,216606025461,216830424971,216820530527,216848084663,216726769501,216648435773,216673257993,216889406372,216541248095,216565570515,216526913240,216855809300', '',064,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-30 13:35:24 Duration: 5s437ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (282662, 317, '258082115349296,216848157475,216844118091,216642531415,216450907393,216641902431,216530706483,216322740116,216446216172,216913893656,216322331636,216843129296,216880829193,216642926986,216853104659,216919117992,216684864446,216845709302,216540290214,216666889516,216673127879,216830044148,216623499399,216882096377,216535219606', '',064,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-30 13:27:48 Duration: 4s749ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (282688, 317, 'ZTE3ANNRCP34551,6C11BA6C5499,6C11BA6C549A,ZTEGDC6FC78A$ZTE3ANNQCA04834,14CA56D2B627,14CA56D2B628,ZTEGD971784D$ZTE3ANNQ8128166,689E29BE72EF,689E29BE72F0,ZTEGD7B7A896$ZTE3ANNR9W24143,D89A0DAA91FD,D89A0DAA91FE,ZTEGDB166FFA$ZTE3ANNQCA21074,14CA56D432C7,14CA56D432C8,ZTEGD971B7BD$ZTE3ANNR4N48787,4896D959D28A,4896D959D28B,ZTEGD97FDE58$ZTE3ANNR2Q57059,F4E84F85ED52,F4E84F85ED53,ZTEGD97B519D$ZTE3ANNQCA33026,14CA56D54AE7,14CA56D54AE8,ZTEGD971E66D$ZTE3ANNT2V58958,D8313990F4AC,D8313990F4AD,ZTEGDD30D8CD$ZTE3ANNT2V55429,D8313990A1F6,D8313990A1F7,ZTEGDD30CB04$ZTE3ANNT4P84126,F00C51535A52,F00C51535A53,ZTEGDE353F34$ZTE3ANNT3H36907,D831399A249A,D831399A249B,ZTEGDD3260CA$ZTE3ANNR5W32099,48D68231741C,48D68231741D,ZTEGDB007D62$ZTE3ANNRCB36836,D83139212E56,D83139212E57,ZTEGDD2A4579$ZTE3ANNRCB68619,D83139241740,D83139241741,ZTEGDD2AC1A0$ZTE3ANNR4N25515,4896D957B11A,4896D957B11B,ZTEGD97F8370$ZTE3ANNRCB01193,D831391DEAF4,D831391DEAF5,ZTEGDD29BA3E$ZTE3ANNQ7511960,C4EBFF8C0B8C,C4EBFF8C0B8D,ZTEGD70A7D58$ZTE3ANNR4N18184,4896D9570548,4896D9570549,ZTEGD97F66CD$ZTE3ANNRCP29792,6C11BA6BE50F,6C11BA6BE510,ZTEGDC6FB4F3$ZTE3ANNQ3616341,3CF9F0A6546C,3CF9F0A6546D,ZTEGD640A370$ZTE3ANNR2Q15994,F4E84F822ADC,F4E84F822ADD,ZTEGD97AB134$ZTE3ANNR3Y11313,4896D950C9DE,4896D950C9DF,ZTEGD97E5CE6$ZTE3ANNT2V91612,D8313993F200,D8313993F201,ZTEGDD31585B$ZTE3ANNR6R27163,48D682380164,48D682380165,ZTEGDB0194EE$ZTE3ANNR2Q19217,F4E84F827666,F4E84F827667,ZTEGD97ABDCB$ZTE3ANNQCA17580,14CA56D3E0E3,14CA56D3E0E4,ZTEGD971AA17$ZTE3ANNQCA36514,14CA56D59CA7,14CA56D59CA8,ZTEGD971F40D$ZTE3ANNRB762676,5872C993F629,5872C993F62A,ZTEGDC621FA7$ZTE3ANNQ5207920,3CF9F0A7E4B6,3CF9F0A7E4B7,ZTEGD640E627', '',0318,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-30 11:24:18 Duration: 4s568ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 53 47s189ms 585ms 1s973ms 890ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 30 08 3 3s132ms 1s44ms 09 4 3s332ms 833ms 10 3 2s349ms 783ms 11 4 3s416ms 854ms 12 5 4s393ms 878ms 13 4 3s580ms 895ms 14 4 3s307ms 826ms 15 3 2s595ms 865ms 16 3 2s499ms 833ms 17 3 2s536ms 845ms 18 4 3s709ms 927ms 19 3 2s706ms 902ms 20 3 2s512ms 837ms 21 3 2s299ms 766ms 22 4 4s817ms 1s204ms [ User: intelifix - Total duration: 47s189ms - Times executed: 53 ]
[ Application: psql - Total duration: 47s189ms - Times executed: 53 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-30 22:20:04 Duration: 1s973ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-30 08:00:09 Duration: 1s387ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-30 18:20:02 Duration: 1s165ms Database: rio User: intelifix Remote: [local] Application: psql
4 47 1h39m56s 1s250ms 14m26s 2m7s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 30 07 3 15m31s 5m10s 08 3 5m58s 1m59s 09 3 5m54s 1m58s 10 3 5m49s 1m56s 11 3 6m7s 2m2s 12 3 5m47s 1m55s 13 3 5m47s 1m55s 14 3 6m18s 2m6s 15 3 5m52s 1m57s 16 3 5m55s 1m58s 17 3 5m45s 1m55s 18 3 5m48s 1m56s 19 3 5m45s 1m55s 20 2 48s252ms 24s126ms 21 3 6m59s 2m19s 22 3 5m43s 1m54s [ User: intelifix - Total duration: 1h39m56s - Times executed: 47 ]
[ Application: psql - Total duration: 1h39m56s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-30 07:19:27 Duration: 14m26s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-30 21:11:44 Duration: 6m42s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-30 14:11:01 Duration: 5m59s Database: rio User: intelifix Remote: [local] Application: psql
5 47 1h4m12s 224ms 4m38s 1m21s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 30 07 3 6m54s 2m18s 08 3 3m38s 1m12s 09 3 3m42s 1m14s 10 3 3m41s 1m13s 11 3 3m41s 1m13s 12 3 3m32s 1m10s 13 3 3m34s 1m11s 14 3 3m39s 1m13s 15 3 3m36s 1m12s 16 3 3m39s 1m13s 17 3 3m33s 1m11s 18 3 3m32s 1m10s 19 3 3m43s 1m14s 20 3 6m31s 2m10s 21 2 3m35s 1m47s 22 3 3m35s 1m11s [ User: intelifix - Total duration: 1h4m12s - Times executed: 47 ]
[ Application: psql - Total duration: 1h4m12s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-30 07:27:16 Duration: 4m38s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-30 20:25:51 Duration: 4m9s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-30 19:14:29 Duration: 3m11s Database: brasilia User: intelifix Remote: [local] Application: psql
6 37 40s442ms 630ms 5s672ms 1s93ms call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 30 08 3 7s305ms 2s435ms 09 2 1s789ms 894ms 10 3 2s429ms 809ms 11 2 1s788ms 894ms 12 1 744ms 744ms 13 2 3s970ms 1s985ms 14 2 1s373ms 686ms 15 3 2s834ms 944ms 16 3 2s596ms 865ms 17 3 2s679ms 893ms 18 2 1s874ms 937ms 19 3 2s392ms 797ms 20 3 4s450ms 1s483ms 21 3 2s736ms 912ms 22 2 1s475ms 737ms [ User: intelifix - Total duration: 40s442ms - Times executed: 37 ]
[ Application: psql - Total duration: 40s442ms - Times executed: 37 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-30 08:00:07 Duration: 5s672ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-30 13:20:04 Duration: 2s956ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-30 20:20:04 Duration: 2s607ms Database: rio User: intelifix Remote: [local] Application: psql
7 18 13s702ms 176ms 3s675ms 761ms create table temp0000290020 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 30 10 5 10s874ms 2s174ms 11 3 602ms 200ms 13 5 1s133ms 226ms 14 5 1s92ms 218ms [ User: intelifix - Total duration: 13s702ms - Times executed: 18 ]
[ Application: [unknown] - Total duration: 13s702ms - Times executed: 18 ]
-
CREATE TABLE temp0000290020 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"25-08-2026", "ate" :"30-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-30 10:35:33 Duration: 3s675ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290020 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"25-08-2026", "ate" :"30-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-30 10:30:08 Duration: 3s526ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290020 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"25-08-2026", "ate" :"30-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-30 10:29:57 Duration: 3s275ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 14 4s464ms 251ms 473ms 318ms call rs_giga_triagem (?) / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 30 15 2 552ms 276ms 16 2 651ms 325ms 17 2 523ms 261ms 18 2 563ms 281ms 19 2 749ms 374ms 20 2 685ms 342ms 21 2 738ms 369ms [ User: intelifix - Total duration: 4s464ms - Times executed: 14 ]
[ Application: psql - Total duration: 4s464ms - Times executed: 14 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR') / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-30 19:35:06 Duration: 473ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR') / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-30 21:35:06 Duration: 439ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR') / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-30 20:55:06 Duration: 416ms Database: brasilia User: intelifix Remote: [local] Application: psql
9 12 4s627ms 291ms 542ms 385ms select pro_id, pgp_sym_decrypt(nome, ?)::varchar, pgp_sym_decrypt(descricao, ?)::varchar, pgp_sym_decrypt(classe, ?)::varchar, pgp_sym_decrypt(php, ?)::varchar, pgp_sym_decrypt(extras, ?)::varchar from progs order by pro_id;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 30 08 1 412ms 412ms 09 2 769ms 384ms 10 2 799ms 399ms 11 3 1s91ms 363ms 13 2 877ms 438ms 14 2 677ms 338ms [ User: lenon - Total duration: 4s627ms - Times executed: 12 ]
[ Application: [unknown] - Total duration: 4s627ms - Times executed: 12 ]
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-08-30 13:12:09 Duration: 542ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-08-30 10:46:03 Duration: 425ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-08-30 08:35:40 Duration: 412ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
10 10 4s807ms 359ms 677ms 480ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 30 09 2 931ms 465ms 10 1 562ms 562ms 11 3 1s377ms 459ms 13 2 1s128ms 564ms 14 2 807ms 403ms [ User: intelifix - Total duration: 4s807ms - Times executed: 10 ]
[ Application: [unknown] - Total duration: 4s807ms - Times executed: 10 ]
-
select * from rs_menu_grants (317, 81, 1);
Date: 2026-08-30 13:12:09 Duration: 677ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (317, 18, 1);
Date: 2026-08-30 10:46:03 Duration: 562ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (317, 18, 1);
Date: 2026-08-30 11:46:56 Duration: 516ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 9 2s313ms 156ms 416ms 257ms select * from rs_equipamento_consulta (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 30 08 4 996ms 249ms 09 2 435ms 217ms 11 3 880ms 293ms [ User: intelifix - Total duration: 2s313ms - Times executed: 9 ]
[ Application: [unknown] - Total duration: 2s313ms - Times executed: 9 ]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('8C444F079F5F');
Date: 2026-08-30 11:32:46 Duration: 416ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('983910095E15');
Date: 2026-08-30 08:38:31 Duration: 400ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('942CB346787E');
Date: 2026-08-30 11:29:48 Duration: 261ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 8 6s118ms 213ms 1s345ms 764ms call rs_giga_tecnicos ();Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 30 00 3 2s751ms 917ms 03 2 852ms 426ms 20 2 2s163ms 1s81ms 21 1 350ms 350ms [ User: intelifix - Total duration: 6s118ms - Times executed: 8 ]
[ Application: psql - Total duration: 6s118ms - Times executed: 8 ]
-
CALL RS_GIGA_TECNICOS ();
Date: 2026-08-30 00:05:02 Duration: 1s345ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TECNICOS ();
Date: 2026-08-30 20:05:03 Duration: 1s171ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TECNICOS ();
Date: 2026-08-30 00:05:03 Duration: 1s34ms Database: brasilia User: intelifix Remote: [local] Application: psql
13 7 2s994ms 278ms 599ms 427ms select p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, p.proacl, acldefault(?, p.proowner) as acldefault, p.pronamespace, p.proowner from pg_proc p left join pg_init_privs pip on (p.oid = pip.objoid and pip.classoid = ?::regclass and pip.objsubid = ?) where p.prokind <> ? and not exists ( select ? from pg_depend where classid = ?::regclass and objid = p.oid and deptype = ?) and (pronamespace != ( select oid from pg_namespace where nspname = ?) or exists ( select ? from pg_cast where pg_cast.oid > ? and p.oid = pg_cast.castfunc) or exists ( select ? from pg_transform where pg_transform.oid > ? and (p.oid = pg_transform.trffromsql or p.oid = pg_transform.trftosql)) or p.proacl is distinct from pip.initprivs);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 30 20 3 976ms 325ms 23 4 2s18ms 504ms [ User: intelifix - Total duration: 2s994ms - Times executed: 7 ]
[ Application: pg_dump - Total duration: 2s994ms - Times executed: 7 ]
-
SELECT p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, p.proacl, acldefault('f', p.proowner) AS acldefault, p.pronamespace, p.proowner FROM pg_proc p LEFT JOIN pg_init_privs pip ON (p.oid = pip.objoid AND pip.classoid = 'pg_proc'::regclass AND pip.objsubid = 0) WHERE p.prokind <> 'a' AND NOT EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_proc'::regclass AND objid = p.oid AND deptype = 'i') AND (pronamespace != ( SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog') OR EXISTS ( SELECT 1 FROM pg_cast WHERE pg_cast.oid > 16383 AND p.oid = pg_cast.castfunc) OR EXISTS ( SELECT 1 FROM pg_transform WHERE pg_transform.oid > 16383 AND (p.oid = pg_transform.trffromsql OR p.oid = pg_transform.trftosql)) OR p.proacl IS DISTINCT FROM pip.initprivs);
Date: 2026-08-30 23:35:02 Duration: 599ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
SELECT p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, p.proacl, acldefault('f', p.proowner) AS acldefault, p.pronamespace, p.proowner FROM pg_proc p LEFT JOIN pg_init_privs pip ON (p.oid = pip.objoid AND pip.classoid = 'pg_proc'::regclass AND pip.objsubid = 0) WHERE p.prokind <> 'a' AND NOT EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_proc'::regclass AND objid = p.oid AND deptype = 'i') AND (pronamespace != ( SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog') OR EXISTS ( SELECT 1 FROM pg_cast WHERE pg_cast.oid > 16383 AND p.oid = pg_cast.castfunc) OR EXISTS ( SELECT 1 FROM pg_transform WHERE pg_transform.oid > 16383 AND (p.oid = pg_transform.trffromsql OR p.oid = pg_transform.trftosql)) OR p.proacl IS DISTINCT FROM pip.initprivs);
Date: 2026-08-30 23:17:41 Duration: 528ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
SELECT p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, p.proacl, acldefault('f', p.proowner) AS acldefault, p.pronamespace, p.proowner FROM pg_proc p LEFT JOIN pg_init_privs pip ON (p.oid = pip.objoid AND pip.classoid = 'pg_proc'::regclass AND pip.objsubid = 0) WHERE p.prokind <> 'a' AND NOT EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_proc'::regclass AND objid = p.oid AND deptype = 'i') AND (pronamespace != ( SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog') OR EXISTS ( SELECT 1 FROM pg_cast WHERE pg_cast.oid > 16383 AND p.oid = pg_cast.castfunc) OR EXISTS ( SELECT 1 FROM pg_transform WHERE pg_transform.oid > 16383 AND (p.oid = pg_transform.trffromsql OR p.oid = pg_transform.trftosql)) OR p.proacl IS DISTINCT FROM pip.initprivs);
Date: 2026-08-30 23:10:03 Duration: 490ms Database: rio User: intelifix Remote: [local] Application: pg_dump
14 7 2s901ms 304ms 514ms 414ms select c.tableoid, c.oid, c.relname, c.relnamespace, c.relkind, c.reltype, c.relowner, c.relchecks, c.relhasindex, c.relhasrules, c.relpages, c.reltuples, c.relallvisible, c.relallfrozen, c.relhastriggers, c.relpersistence, c.reloftype, c.relacl, acldefault( case when c.relkind = ? then ?::"char" else ?::"char" end, c.relowner) as acldefault, case when c.relkind = ? then ( select ftserver from pg_catalog.pg_foreign_table where ftrelid = c.oid) else ? end as foreignserver, c.relfrozenxid, tc.relfrozenxid as tfrozenxid, tc.oid as toid, tc.relpages as toastpages, tc.reloptions as toast_reloptions, d.refobjid as owning_tab, d.refobjsubid as owning_col, tsp.spcname as reltablespace, false as relhasoids, c.relispopulated, c.relreplident, c.relrowsecurity, c.relforcerowsecurity, c.relminmxid, tc.relminmxid as tminmxid, array_remove(array_remove(c.reloptions, ?), ?) as reloptions, case when ? = any (c.reloptions) then ?::text when ? = any (c.reloptions) then ?::text else null end as checkoption, am.amname, (d.deptype = ?) is true as is_identity_sequence, c.relispartition as ispartition from pg_class c left join pg_depend d on (c.relkind = ? and d.classid = ?::regclass and d.objid = c.oid and d.objsubid = ? and d.refclassid = ?::regclass and d.deptype in (...)) left join pg_tablespace tsp on (tsp.oid = c.reltablespace) left join pg_am am on (c.relam = am.oid) left join pg_class tc on (c.reltoastrelid = tc.oid and tc.relkind = ? and c.relkind <> ?) where c.relkind in (...) order by c.oid;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 30 20 3 1s199ms 399ms 23 4 1s702ms 425ms [ User: intelifix - Total duration: 2s901ms - Times executed: 7 ]
[ Application: pg_dump - Total duration: 2s901ms - Times executed: 7 ]
-
SELECT c.tableoid, c.oid, c.relname, c.relnamespace, c.relkind, c.reltype, c.relowner, c.relchecks, c.relhasindex, c.relhasrules, c.relpages, c.reltuples, c.relallvisible, c.relallfrozen, c.relhastriggers, c.relpersistence, c.reloftype, c.relacl, acldefault( CASE WHEN c.relkind = 'S' THEN 's'::"char" ELSE 'r'::"char" END, c.relowner) AS acldefault, CASE WHEN c.relkind = 'f' THEN ( SELECT ftserver FROM pg_catalog.pg_foreign_table WHERE ftrelid = c.oid) ELSE 0 END AS foreignserver, c.relfrozenxid, tc.relfrozenxid AS tfrozenxid, tc.oid AS toid, tc.relpages AS toastpages, tc.reloptions AS toast_reloptions, d.refobjid AS owning_tab, d.refobjsubid AS owning_col, tsp.spcname AS reltablespace, false AS relhasoids, c.relispopulated, c.relreplident, c.relrowsecurity, c.relforcerowsecurity, c.relminmxid, tc.relminmxid AS tminmxid, array_remove(array_remove(c.reloptions, 'check_option=local'), 'check_option=cascaded') AS reloptions, CASE WHEN 'check_option=local' = ANY (c.reloptions) THEN 'LOCAL'::text WHEN 'check_option=cascaded' = ANY (c.reloptions) THEN 'CASCADED'::text ELSE NULL END AS checkoption, am.amname, (d.deptype = 'i') IS TRUE AS is_identity_sequence, c.relispartition AS ispartition FROM pg_class c LEFT JOIN pg_depend d ON (c.relkind = 'S' AND d.classid = 'pg_class'::regclass AND d.objid = c.oid AND d.objsubid = 0 AND d.refclassid = 'pg_class'::regclass AND d.deptype IN ('a', 'i')) LEFT JOIN pg_tablespace tsp ON (tsp.oid = c.reltablespace) LEFT JOIN pg_am am ON (c.relam = am.oid) LEFT JOIN pg_class tc ON (c.reltoastrelid = tc.oid AND tc.relkind = 't' AND c.relkind <> 'p') WHERE c.relkind IN ('r', 'S', 'v', 'c', 'm', 'f', 'p') ORDER BY c.oid;
Date: 2026-08-30 23:35:01 Duration: 514ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
SELECT c.tableoid, c.oid, c.relname, c.relnamespace, c.relkind, c.reltype, c.relowner, c.relchecks, c.relhasindex, c.relhasrules, c.relpages, c.reltuples, c.relallvisible, c.relallfrozen, c.relhastriggers, c.relpersistence, c.reloftype, c.relacl, acldefault( CASE WHEN c.relkind = 'S' THEN 's'::"char" ELSE 'r'::"char" END, c.relowner) AS acldefault, CASE WHEN c.relkind = 'f' THEN ( SELECT ftserver FROM pg_catalog.pg_foreign_table WHERE ftrelid = c.oid) ELSE 0 END AS foreignserver, c.relfrozenxid, tc.relfrozenxid AS tfrozenxid, tc.oid AS toid, tc.relpages AS toastpages, tc.reloptions AS toast_reloptions, d.refobjid AS owning_tab, d.refobjsubid AS owning_col, tsp.spcname AS reltablespace, false AS relhasoids, c.relispopulated, c.relreplident, c.relrowsecurity, c.relforcerowsecurity, c.relminmxid, tc.relminmxid AS tminmxid, array_remove(array_remove(c.reloptions, 'check_option=local'), 'check_option=cascaded') AS reloptions, CASE WHEN 'check_option=local' = ANY (c.reloptions) THEN 'LOCAL'::text WHEN 'check_option=cascaded' = ANY (c.reloptions) THEN 'CASCADED'::text ELSE NULL END AS checkoption, am.amname, (d.deptype = 'i') IS TRUE AS is_identity_sequence, c.relispartition AS ispartition FROM pg_class c LEFT JOIN pg_depend d ON (c.relkind = 'S' AND d.classid = 'pg_class'::regclass AND d.objid = c.oid AND d.objsubid = 0 AND d.refclassid = 'pg_class'::regclass AND d.deptype IN ('a', 'i')) LEFT JOIN pg_tablespace tsp ON (tsp.oid = c.reltablespace) LEFT JOIN pg_am am ON (c.relam = am.oid) LEFT JOIN pg_class tc ON (c.reltoastrelid = tc.oid AND tc.relkind = 't' AND c.relkind <> 'p') WHERE c.relkind IN ('r', 'S', 'v', 'c', 'm', 'f', 'p') ORDER BY c.oid;
Date: 2026-08-30 20:02:03 Duration: 502ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
SELECT c.tableoid, c.oid, c.relname, c.relnamespace, c.relkind, c.reltype, c.relowner, c.relchecks, c.relhasindex, c.relhasrules, c.relpages, c.reltuples, c.relallvisible, c.relallfrozen, c.relhastriggers, c.relpersistence, c.reloftype, c.relacl, acldefault( CASE WHEN c.relkind = 'S' THEN 's'::"char" ELSE 'r'::"char" END, c.relowner) AS acldefault, CASE WHEN c.relkind = 'f' THEN ( SELECT ftserver FROM pg_catalog.pg_foreign_table WHERE ftrelid = c.oid) ELSE 0 END AS foreignserver, c.relfrozenxid, tc.relfrozenxid AS tfrozenxid, tc.oid AS toid, tc.relpages AS toastpages, tc.reloptions AS toast_reloptions, d.refobjid AS owning_tab, d.refobjsubid AS owning_col, tsp.spcname AS reltablespace, false AS relhasoids, c.relispopulated, c.relreplident, c.relrowsecurity, c.relforcerowsecurity, c.relminmxid, tc.relminmxid AS tminmxid, array_remove(array_remove(c.reloptions, 'check_option=local'), 'check_option=cascaded') AS reloptions, CASE WHEN 'check_option=local' = ANY (c.reloptions) THEN 'LOCAL'::text WHEN 'check_option=cascaded' = ANY (c.reloptions) THEN 'CASCADED'::text ELSE NULL END AS checkoption, am.amname, (d.deptype = 'i') IS TRUE AS is_identity_sequence, c.relispartition AS ispartition FROM pg_class c LEFT JOIN pg_depend d ON (c.relkind = 'S' AND d.classid = 'pg_class'::regclass AND d.objid = c.oid AND d.objsubid = 0 AND d.refclassid = 'pg_class'::regclass AND d.deptype IN ('a', 'i')) LEFT JOIN pg_tablespace tsp ON (tsp.oid = c.reltablespace) LEFT JOIN pg_am am ON (c.relam = am.oid) LEFT JOIN pg_class tc ON (c.reltoastrelid = tc.oid AND tc.relkind = 't' AND c.relkind <> 'p') WHERE c.relkind IN ('r', 'S', 'v', 'c', 'm', 'f', 'p') ORDER BY c.oid;
Date: 2026-08-30 23:17:40 Duration: 446ms Database: rio User: intelifix Remote: [local] Application: pg_dump
15 6 2m17s 10s175ms 44s946ms 22s956ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 30 00 3 1m10s 23s412ms 06 3 1m7s 22s500ms [ User: lenon - Total duration: 2m17s - Times executed: 6 ]
[ Application: psql - Total duration: 2m17s - Times executed: 6 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-08-30 00:02:48 Duration: 44s946ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-08-30 06:02:44 Duration: 41s837ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-08-30 06:03:09 Duration: 15s251ms Database: contagem User: lenon Remote: [local] Application: psql
16 6 1m42s 10s672ms 24s133ms 17s53ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 30 00 3 1m8s 22s800ms 06 3 33s918ms 11s306ms [ User: intelifix - Total duration: 1m42s - Times executed: 6 ]
[ Application: psql - Total duration: 1m42s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-30 00:06:10 Duration: 24s133ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-30 00:05:25 Duration: 23s789ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-30 00:05:46 Duration: 20s478ms Database: brasilia User: intelifix Remote: [local] Application: psql
17 6 1m32s 2s428ms 35s290ms 15s404ms 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 #17
Day Hour Count Duration Avg duration Aug 30 20 3 45s523ms 15s174ms 23 3 46s902ms 15s634ms [ User: intelifix - Total duration: 1m32s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m32s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-08-30 23:14:24 Duration: 35s290ms 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-30 20:06:09 Duration: 33s114ms 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-30 20:10:13 Duration: 9s616ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 6 1m16s 2s73ms 31s37ms 12s799ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 30 20 3 35s915ms 11s971ms 23 3 40s880ms 13s626ms [ User: intelifix - Total duration: 1m16s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m16s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-30 23:14:59 Duration: 31s37ms 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-30 20:06:41 Duration: 27s72ms 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-30 23:36:07 Duration: 7s677ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 6 1m10s 2s909ms 27s21ms 11s769ms 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 #19
Day Hour Count Duration Avg duration Aug 30 20 3 35s618ms 11s872ms 23 3 34s999ms 11s666ms [ User: intelifix - Total duration: 1m10s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m10s - Times executed: 6 ]
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-08-30 20:09:12 Duration: 27s21ms 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-30 23:17:37 Duration: 25s795ms 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-30 23:36:32 Duration: 6s192ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 6 1m4s 1s474ms 27s360ms 10s828ms 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 #20
Day Hour Count Duration Avg duration Aug 30 20 3 31s187ms 10s395ms 23 3 33s781ms 11s260ms [ User: intelifix - Total duration: 1m4s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m4s - Times executed: 6 ]
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-08-30 23:12:28 Duration: 27s360ms 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-30 20:04:18 Duration: 25s190ms 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-30 23:35:45 Duration: 4s740ms 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 13m41s 13m41s 13m41s 1 13m41s select * from rs_smart_fiscal_entrada () / 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 #1
Day Hour Count Duration Avg duration Aug 30 20 1 13m41s 13m41s [ User: intelifix - Total duration: 13m41s - Times executed: 1 ]
[ Application: psql - Total duration: 13m41s - Times executed: 1 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-30 20:18:43 Duration: 13m41s Database: rio User: intelifix Remote: [local] Application: psql
2 2m57s 10m45s 6m52s 3 20m37s analyze verbose;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 30 05 3 20m37s 6m52s [ User: intelifix - Total duration: 20m37s - Times executed: 3 ]
[ Application: psql - Total duration: 20m37s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-30 05:10:47 Duration: 10m45s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-30 05:17:41 Duration: 6m54s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-30 05:20:39 Duration: 2m57s Database: contagem User: intelifix Remote: [local] Application: psql
3 1s250ms 14m26s 2m7s 47 1h39m56s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 30 07 3 15m31s 5m10s 08 3 5m58s 1m59s 09 3 5m54s 1m58s 10 3 5m49s 1m56s 11 3 6m7s 2m2s 12 3 5m47s 1m55s 13 3 5m47s 1m55s 14 3 6m18s 2m6s 15 3 5m52s 1m57s 16 3 5m55s 1m58s 17 3 5m45s 1m55s 18 3 5m48s 1m56s 19 3 5m45s 1m55s 20 2 48s252ms 24s126ms 21 3 6m59s 2m19s 22 3 5m43s 1m54s [ User: intelifix - Total duration: 1h39m56s - Times executed: 47 ]
[ Application: psql - Total duration: 1h39m56s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-30 07:19:27 Duration: 14m26s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-30 21:11:44 Duration: 6m42s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-30 14:11:01 Duration: 5m59s Database: rio User: intelifix Remote: [local] Application: psql
4 1m22s 1m22s 1m22s 1 1m22s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 30 05 1 1m22s 1m22s [ User: intelifix - Total duration: 1m22s - Times executed: 1 ]
[ Application: psql - Total duration: 1m22s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-30 05:32:06 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-30 05:31:59 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
5 224ms 4m38s 1m21s 47 1h4m12s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 30 07 3 6m54s 2m18s 08 3 3m38s 1m12s 09 3 3m42s 1m14s 10 3 3m41s 1m13s 11 3 3m41s 1m13s 12 3 3m32s 1m10s 13 3 3m34s 1m11s 14 3 3m39s 1m13s 15 3 3m36s 1m12s 16 3 3m39s 1m13s 17 3 3m33s 1m11s 18 3 3m32s 1m10s 19 3 3m43s 1m14s 20 3 6m31s 2m10s 21 2 3m35s 1m47s 22 3 3m35s 1m11s [ User: intelifix - Total duration: 1h4m12s - Times executed: 47 ]
[ Application: psql - Total duration: 1h4m12s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-30 07:27:16 Duration: 4m38s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-30 20:25:51 Duration: 4m9s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-30 19:14:29 Duration: 3m11s Database: brasilia User: intelifix Remote: [local] Application: psql
6 6s478ms 1m30s 47s364ms 4 3m9s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 30 20 2 1m32s 46s23ms 23 2 1m37s 48s705ms [ User: intelifix - Total duration: 3m9s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m9s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-30 23:17:11 Duration: 1m30s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-30 20:08:44 Duration: 1m25s 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-30 23:36:25 Duration: 6s605ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 408ms 56s714ms 28s349ms 4 1m53s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 30 20 2 57s122ms 28s561ms 23 2 56s276ms 28s138ms [ User: intelifix - Total duration: 1m53s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m53s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-30 20:05:34 Duration: 56s714ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-30 23:13:45 Duration: 55s842ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-30 23:35:50 Duration: 433ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 10s175ms 44s946ms 22s956ms 6 2m17s select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 30 00 3 1m10s 23s412ms 06 3 1m7s 22s500ms [ User: lenon - Total duration: 2m17s - Times executed: 6 ]
[ Application: psql - Total duration: 2m17s - Times executed: 6 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-08-30 00:02:48 Duration: 44s946ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-08-30 06:02:44 Duration: 41s837ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-08-30 06:03:09 Duration: 15s251ms Database: contagem User: lenon Remote: [local] Application: psql
9 10s672ms 24s133ms 17s53ms 6 1m42s call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 30 00 3 1m8s 22s800ms 06 3 33s918ms 11s306ms [ User: intelifix - Total duration: 1m42s - Times executed: 6 ]
[ Application: psql - Total duration: 1m42s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-30 00:06:10 Duration: 24s133ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-30 00:05:25 Duration: 23s789ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-30 00:05:46 Duration: 20s478ms Database: brasilia User: intelifix Remote: [local] Application: psql
10 2s428ms 35s290ms 15s404ms 6 1m32s 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 30 20 3 45s523ms 15s174ms 23 3 46s902ms 15s634ms [ User: intelifix - Total duration: 1m32s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m32s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-08-30 23:14:24 Duration: 35s290ms 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-30 20:06:09 Duration: 33s114ms 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-30 20:10:13 Duration: 9s616ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 2s73ms 31s37ms 12s799ms 6 1m16s 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 30 20 3 35s915ms 11s971ms 23 3 40s880ms 13s626ms [ User: intelifix - Total duration: 1m16s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m16s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-08-30 23:14:59 Duration: 31s37ms 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-30 20:06:41 Duration: 27s72ms 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-30 23:36:07 Duration: 7s677ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 3s982ms 21s142ms 12s325ms 4 49s301ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 30 20 2 24s176ms 12s88ms 23 2 25s124ms 12s562ms [ User: intelifix - Total duration: 49s301ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 49s301ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-08-30 23:12:49 Duration: 21s142ms 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-30 20:04:37 Duration: 19s662ms 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-30 20:10:03 Duration: 4s513ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 2s909ms 27s21ms 11s769ms 6 1m10s copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 30 20 3 35s618ms 11s872ms 23 3 34s999ms 11s666ms [ User: intelifix - Total duration: 1m10s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m10s - Times executed: 6 ]
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-08-30 20:09:12 Duration: 27s21ms 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-30 23:17:37 Duration: 25s795ms 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-30 23:36:32 Duration: 6s192ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 1s474ms 27s360ms 10s828ms 6 1m4s copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 30 20 3 31s187ms 10s395ms 23 3 33s781ms 11s260ms [ User: intelifix - Total duration: 1m4s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m4s - Times executed: 6 ]
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-08-30 23:12:28 Duration: 27s360ms 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-30 20:04:18 Duration: 25s190ms 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-30 23:35:45 Duration: 4s740ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 2s122ms 22s103ms 10s788ms 6 1m4s copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 30 20 3 32s859ms 10s953ms 23 3 31s872ms 10s624ms [ User: intelifix - Total duration: 1m4s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m4s - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-30 23:11:28 Duration: 22s103ms 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-30 20:03:22 Duration: 21s772ms 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-30 20:09:44 Duration: 8s965ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 2s341ms 22s667ms 10s682ms 6 1m4s copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 30 20 3 30s545ms 10s181ms 23 3 33s550ms 11s183ms [ User: intelifix - Total duration: 1m4s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m4s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-08-30 23:10:50 Duration: 22s667ms 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-30 20:02:46 Duration: 19s793ms 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-30 20:09:32 Duration: 8s410ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 1s517ms 15s381ms 7s810ms 6 46s862ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 30 20 3 22s901ms 7s633ms 23 3 23s960ms 7s986ms [ User: intelifix - Total duration: 46s862ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 46s862ms - Times executed: 6 ]
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-08-30 23:11:44 Duration: 15s381ms 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-30 20:03:37 Duration: 14s965ms 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-30 23:35:38 Duration: 6s777ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 166ms 29s375ms 3s125ms 262 13m39s call rs_giga_triagem (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 30 00 12 1m3s 5s306ms 01 12 33s813ms 2s817ms 02 12 31s902ms 2s658ms 03 12 32s944ms 2s745ms 04 12 34s111ms 2s842ms 05 12 32s533ms 2s711ms 06 12 30s89ms 2s507ms 07 12 31s309ms 2s609ms 08 12 32s856ms 2s738ms 09 12 31s940ms 2s661ms 10 12 32s549ms 2s712ms 11 12 32s187ms 2s682ms 12 12 31s457ms 2s621ms 13 12 32s203ms 2s683ms 14 12 33s523ms 2s793ms 15 10 32s438ms 3s243ms 16 10 32s138ms 3s213ms 17 10 32s2ms 3s200ms 18 10 31s858ms 3s185ms 19 10 31s371ms 3s137ms 20 11 1m15s 6s854ms 21 10 31s811ms 3s181ms 22 11 34s889ms 3s171ms [ User: intelifix - Total duration: 13m39s - Times executed: 262 ]
[ Application: psql - Total duration: 13m39s - Times executed: 262 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-30 00:05:31 Duration: 29s375ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-30 20:05:24 Duration: 22s458ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-30 20:15:23 Duration: 22s110ms Database: rio User: intelifix Remote: [local] Application: psql
19 164ms 5s437ms 1s438ms 62 1m29s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 30 09 7 6s978ms 996ms 10 6 10s176ms 1s696ms 11 12 20s182ms 1s681ms 13 13 22s942ms 1s764ms 14 24 28s928ms 1s205ms [ User: intelifix - Total duration: 1m29s - Times executed: 62 ]
[ Application: [unknown] - Total duration: 1m29s - Times executed: 62 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (282662, 317, '255041117421417,216525158602,216825678996,216891988498,216843727694,216524168796,216683690101,216522681941,216830371835,216889263149,216839503444,216880808989,216542506669,216728653546,216794265572,216882039098,216565880927,216526772239,216841504548,216820820207,216538058705,216683867996,216914576584,216566352645,216606025461,216830424971,216820530527,216848084663,216726769501,216648435773,216673257993,216889406372,216541248095,216565570515,216526913240,216855809300', '',064,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-30 13:35:24 Duration: 5s437ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (282662, 317, '258082115349296,216848157475,216844118091,216642531415,216450907393,216641902431,216530706483,216322740116,216446216172,216913893656,216322331636,216843129296,216880829193,216642926986,216853104659,216919117992,216684864446,216845709302,216540290214,216666889516,216673127879,216830044148,216623499399,216882096377,216535219606', '',064,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-30 13:27:48 Duration: 4s749ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (282688, 317, 'ZTE3ANNRCP34551,6C11BA6C5499,6C11BA6C549A,ZTEGDC6FC78A$ZTE3ANNQCA04834,14CA56D2B627,14CA56D2B628,ZTEGD971784D$ZTE3ANNQ8128166,689E29BE72EF,689E29BE72F0,ZTEGD7B7A896$ZTE3ANNR9W24143,D89A0DAA91FD,D89A0DAA91FE,ZTEGDB166FFA$ZTE3ANNQCA21074,14CA56D432C7,14CA56D432C8,ZTEGD971B7BD$ZTE3ANNR4N48787,4896D959D28A,4896D959D28B,ZTEGD97FDE58$ZTE3ANNR2Q57059,F4E84F85ED52,F4E84F85ED53,ZTEGD97B519D$ZTE3ANNQCA33026,14CA56D54AE7,14CA56D54AE8,ZTEGD971E66D$ZTE3ANNT2V58958,D8313990F4AC,D8313990F4AD,ZTEGDD30D8CD$ZTE3ANNT2V55429,D8313990A1F6,D8313990A1F7,ZTEGDD30CB04$ZTE3ANNT4P84126,F00C51535A52,F00C51535A53,ZTEGDE353F34$ZTE3ANNT3H36907,D831399A249A,D831399A249B,ZTEGDD3260CA$ZTE3ANNR5W32099,48D68231741C,48D68231741D,ZTEGDB007D62$ZTE3ANNRCB36836,D83139212E56,D83139212E57,ZTEGDD2A4579$ZTE3ANNRCB68619,D83139241740,D83139241741,ZTEGDD2AC1A0$ZTE3ANNR4N25515,4896D957B11A,4896D957B11B,ZTEGD97F8370$ZTE3ANNRCB01193,D831391DEAF4,D831391DEAF5,ZTEGDD29BA3E$ZTE3ANNQ7511960,C4EBFF8C0B8C,C4EBFF8C0B8D,ZTEGD70A7D58$ZTE3ANNR4N18184,4896D9570548,4896D9570549,ZTEGD97F66CD$ZTE3ANNRCP29792,6C11BA6BE50F,6C11BA6BE510,ZTEGDC6FB4F3$ZTE3ANNQ3616341,3CF9F0A6546C,3CF9F0A6546D,ZTEGD640A370$ZTE3ANNR2Q15994,F4E84F822ADC,F4E84F822ADD,ZTEGD97AB134$ZTE3ANNR3Y11313,4896D950C9DE,4896D950C9DF,ZTEGD97E5CE6$ZTE3ANNT2V91612,D8313993F200,D8313993F201,ZTEGDD31585B$ZTE3ANNR6R27163,48D682380164,48D682380165,ZTEGDB0194EE$ZTE3ANNR2Q19217,F4E84F827666,F4E84F827667,ZTEGD97ABDCB$ZTE3ANNQCA17580,14CA56D3E0E3,14CA56D3E0E4,ZTEGD971AA17$ZTE3ANNQCA36514,14CA56D59CA7,14CA56D59CA8,ZTEGD971F40D$ZTE3ANNRB762676,5872C993F629,5872C993F62A,ZTEGDC621FA7$ZTE3ANNQ5207920,3CF9F0A7E4B6,3CF9F0A7E4B7,ZTEGD640E627', '',0318,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-30 11:24:18 Duration: 4s568ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 630ms 5s672ms 1s93ms 37 40s442ms call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 30 08 3 7s305ms 2s435ms 09 2 1s789ms 894ms 10 3 2s429ms 809ms 11 2 1s788ms 894ms 12 1 744ms 744ms 13 2 3s970ms 1s985ms 14 2 1s373ms 686ms 15 3 2s834ms 944ms 16 3 2s596ms 865ms 17 3 2s679ms 893ms 18 2 1s874ms 937ms 19 3 2s392ms 797ms 20 3 4s450ms 1s483ms 21 3 2s736ms 912ms 22 2 1s475ms 737ms [ User: intelifix - Total duration: 40s442ms - Times executed: 37 ]
[ Application: psql - Total duration: 40s442ms - Times executed: 37 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-30 08:00:07 Duration: 5s672ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-30 13:20:04 Duration: 2s956ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-30 20:20:04 Duration: 2s607ms Database: rio User: intelifix Remote: [local] Application: psql
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 6 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Aug 30 09 1 0ms 0ms 11 1 0ms 0ms 13 2 0ms 0ms 19 1 0ms 0ms 22 1 0ms 0ms [ User: intelifix - Total duration: 3m14s - Times executed: 6 ]
[ Application: psql - Total duration: 3m14s - Times executed: 6 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 3,901 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 16 FATAL entries
- 862 ERROR entries
- 0 WARNING entries
- 1 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 858 Max number of times the same event was reported
- 879 Total events found
Rank Times reported Error 1 858 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Aug 30 00 59 01 59 02 60 03 59 04 60 05 59 06 60 07 59 08 60 09 59 10 49 11 59 12 54 13 55 14 47 - ERROR: prepared statement "_PLAN0000000029C007E0" does not exist
- ERROR: prepared statement "_PLAN00000000299C92C0" does not exist
- ERROR: prepared statement "_PLAN00000000299C89A0" does not exist
Statement: DEALLOCATE "_PLAN0000000029C007E0"
Date: 2026-08-30 00:00:43 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN00000000299C92C0"
Date: 2026-08-30 00:01:43 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN00000000299C89A0"
Date: 2026-08-30 00:02:44 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 8 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Aug 30 00 1 02 1 03 2 05 1 06 1 13 1 23 1 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-08-30 00:03:13 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-08-30 02:27:19 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-30 03:03:20 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
3 6 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #3
Day Hour Count Aug 30 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-30 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-08-30 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-08-30 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
4 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Aug 30 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-30 05:32:06 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-30 05:32:06 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-30 05:32:06 Database: contagem Application: psql User: intelifix Remote: [local]
5 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #5
Day Hour Count Aug 30 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-08-30 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-30 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
6 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #6
Day Hour Count Aug 30 03 1 - LOG: database system was shut down at 2026-08-30 03:05:01 -03
Date: 2026-08-30 03:05:02