pgBadger-
Global information
- Generated on Sat Sep 26 23:50:12 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 11,051 log entries in 9s
- Log start from 2026-09-26 00:00:58 to 2026-09-26 23:49:22
-
Overview
Global Stats
- 179 Number of unique normalized queries
- 1,002 Number of queries
- 4h4m37s Total query duration
- 2026-09-26 00:02:23 First query
- 2026-09-26 23:45:05 Last query
- 4 queries/s at 2026-09-26 23:43:22 Query peak
- 4h4m37s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 4h4m37s Execute total duration
- 1,678 Number of events
- 7 Number of unique normalized events
- 1,645 Max number of times the same event was reported
- 0 Number of cancellation
- 15 Total number of automatic vacuums
- 22 Total number of automatic analyzes
- 20 Number temporary file
- 247.60 MiB Max size of temporary file
- 67.38 MiB Average size of temporary file
- 246 Total number of sessions
- 9 sessions at 2026-09-26 01:02:03 Session peak
- 9d12h48m18s Total duration of sessions
- 55m48s Average duration of sessions
- 4 Average queries per session
- 59s665ms Average queries duration per session
- 54m48s Average idle time per session
- 257 Total number of connections
- 8 connections/s at 2026-09-26 03:05:16 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 4 queries/s Query Peak
- 2026-09-26 23:43:22 Date
SELECT Traffic
Key values
- 3 queries/s Query Peak
- 2026-09-26 12:52:11 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-09-26 23:43:22 Date
Queries duration
Key values
- 4h4m37s 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) Sep 26 00 23 0ms 20s228ms 5s130ms 4s536ms 8s229ms 1m1s 01 41 0ms 3s665ms 1s90ms 5s516ms 5s815ms 6s678ms 02 12 0ms 4s90ms 2s809ms 4s419ms 5s596ms 7s429ms 03 13 0ms 7s25ms 2s743ms 3s357ms 4s941ms 10s151ms 04 49 0ms 6s139ms 1s32ms 4s535ms 6s963ms 9s150ms 05 28 0ms 11m10s 51s194ms 4s288ms 3m1s 11m11s 06 12 0ms 19s423ms 5s270ms 3s67ms 3s425ms 27s63ms 07 16 0ms 8m47s 58s513ms 3s131ms 1m34s 8m47s 08 34 0ms 5m10s 19s861ms 3s295ms 44s313ms 6m19s 09 21 0ms 5m19s 28s365ms 3s81ms 14s835ms 5m49s 10 32 0ms 5m12s 18s363ms 3s156ms 3s311ms 5m56s 11 32 0ms 5m11s 19s736ms 3s193ms 41s468ms 5m57s 12 35 0ms 5m13s 22s225ms 20s957ms 1m2s 5m44s 13 30 0ms 5m20s 20s713ms 5s442ms 16s331ms 5m52s 14 19 0ms 5m11s 30s806ms 3s229ms 3s819ms 5m56s 15 20 0ms 5m12s 29s858ms 3s107ms 15s841ms 5m43s 16 18 0ms 5m14s 32s771ms 3s165ms 14s644ms 5m44s 17 18 0ms 5m11s 32s954ms 3s207ms 3s405ms 5m57s 18 21 0ms 5m15s 28s57ms 3s162ms 14s682ms 5m45s 19 18 0ms 5m20s 33s221ms 3s180ms 14s857ms 5m51s 20 119 0ms 6m42s 10s978ms 1m4s 1m11s 7m9s 21 19 0ms 5m30s 31s969ms 3s517ms 46s277ms 5m30s 22 18 0ms 5m22s 33s494ms 3s151ms 14s748ms 5m52s 23 354 0ms 1m3s 5s658ms 1m6s 1m6s 1m8s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 26 00 4 0 6s936ms 0ms 0ms 373ms 01 28 0 337ms 271ms 486ms 1s116ms 02 0 0 0ms 0ms 0ms 0ms 03 2 0 347ms 0ms 0ms 0ms 04 36 0 309ms 367ms 593ms 1s93ms 05 13 0 242ms 0ms 200ms 874ms 06 3 0 9s21ms 0ms 0ms 0ms 07 10 0 1m31s 0ms 715ms 4m12s 08 20 0 32s176ms 0ms 653ms 3m23s 09 9 0 1m3s 0ms 0ms 3m26s 10 19 0 29s653ms 0ms 237ms 3m23s 11 18 0 33s668ms 0ms 648ms 3m23s 12 18 0 34s829ms 0ms 6s59ms 3m24s 13 12 0 49s146ms 0ms 512ms 3m31s 14 6 0 1m33s 0ms 0ms 3m24s 15 8 0 1m11s 0ms 0ms 3m32s 16 6 0 1m34s 0ms 0ms 3m26s 17 6 0 1m34s 0ms 0ms 3m31s 18 9 0 1m2s 0ms 0ms 3m24s 19 6 0 1m35s 0ms 0ms 3m28s 20 19 81 12s675ms 42s864ms 1m2s 3m44s 21 7 0 1m23s 0ms 0ms 3m23s 22 6 0 1m36s 0ms 0ms 3m31s 23 30 324 5s658ms 1m3s 1m6s 1m8s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 26 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 Sep 26 00 0 0 0.00 0.00% 01 0 3 3.00 0.00% 02 0 0 0.00 0.00% 03 0 1 1.00 0.00% 04 0 2 2.00 0.00% 05 0 1 1.00 0.00% 06 0 0 0.00 0.00% 07 0 2 2.00 0.00% 08 0 4 4.00 0.00% 09 0 1 1.00 0.00% 10 0 3 3.00 0.00% 11 0 4 4.00 0.00% 12 0 2 2.00 0.00% 13 0 2 2.00 0.00% 14 0 0 0.00 0.00% 15 0 1 1.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 1 1.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 2 2.00 0.00% Day Hour Count Average / Second Sep 26 00 17 0.00/s 01 10 0.00/s 02 10 0.00/s 03 18 0.01/s 04 8 0.00/s 05 11 0.00/s 06 13 0.00/s 07 10 0.00/s 08 12 0.00/s 09 12 0.00/s 10 15 0.00/s 11 13 0.00/s 12 11 0.00/s 13 12 0.00/s 14 8 0.00/s 15 9 0.00/s 16 7 0.00/s 17 8 0.00/s 18 7 0.00/s 19 7 0.00/s 20 11 0.00/s 21 7 0.00/s 22 7 0.00/s 23 14 0.00/s Day Hour Count Average Duration Average idle time Sep 26 00 10 55m36s 55m24s 01 15 1h48s 1h45s 02 10 1h36s 1h32s 03 18 23m38s 23m36s 04 9 1h2m20s 1h2m14s 05 9 1h59s 58m20s 06 11 58m15s 58m10s 07 11 1h1m21s 59m56s 08 8 1h22s 58m58s 09 11 59m22s 58m27s 10 12 1h1m56s 1h1m7s 11 12 1h1m41s 1h48s 12 11 1h44s 59m34s 13 11 1h1m2s 1h5s 14 10 1h20s 59m21s 15 9 1h2m15s 1h1m9s 16 9 1h47s 59m42s 17 7 1h44s 59m19s 18 8 1h1m2s 59m48s 19 7 1h 58m35s 20 10 43m46s 41m36s 21 8 1h14s 58m58s 22 7 1h25s 58m59s 23 13 35m7s 32m32s -
Connections
Established Connections
Key values
- 8 connections Connection Peak
- 2026-09-26 03:05:16 Date
Connections per database
Key values
- rio Main Database
- 257 connections Total
Connections per user
Key values
- intelifix Main User
- 257 connections Total
-
Sessions
Simultaneous sessions
Key values
- 9 sessions Session Peak
- 2026-09-26 01:02:03 Date
Histogram of session times
Key values
- 218 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 246 sessions Total
Sessions per user
Key values
- intelifix Main User
- 246 sessions Total
Sessions per host
Key values
- [local] Main Host
- 246 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 84,881 buffers Checkpoint Peak
- 2026-09-26 00:09:46 Date
- 269.953 seconds Highest write time
- 0.097 seconds Sync time
Checkpoints Wal files
Key values
- 9 files Wal files usage Peak
- 2026-09-26 00:09:46 Date
Checkpoints distance
Key values
- 281.37 Mo Distance Peak
- 2026-09-26 00:09:46 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Sep 26 00 95,989 648.123s 0.077s 648.229s 01 3,392 339.539s 0.224s 339.794s 02 1,584 158.716s 0.084s 158.826s 03 1,393 139.69s 0.157s 139.879s 04 4,421 442.605s 0.108s 442.748s 05 9,988 983.065s 0.24s 983.332s 06 6,193 269.952s 0.002s 269.958s 07 1,520 151.972s 0.074s 152.061s 08 268 26.9s 0.105s 27.02s 09 68 6.846s 0.07s 6.929s 10 41 4.144s 0.081s 4.243s 11 607 61.089s 0.104s 61.218s 12 2,175 217.735s 0.005s 217.75s 13 381 41.025s 0.015s 41.052s 14 57 5.72s 0.016s 5.739s 15 35 3.523s 0.01s 3.54s 16 24 2.411s 0.003s 2.417s 17 24 2.419s 0.005s 2.431s 18 488 48.93s 0.067s 49.003s 19 24 2.412s 0.002s 2.418s 20 131 13.149s 0.016s 13.175s 21 128 12.85s 0.068s 12.929s 22 25 2.514s 0.062s 2.579s 23 207 20.775s 0.069s 20.857s Day Hour Added Removed Recycled Synced files Longest sync Average sync Sep 26 00 0 0 12 459 0.063s 0.006s 01 0 0 1 659 0.064s 0.01s 02 0 0 1 392 0.062s 0.006s 03 0 0 0 376 0.044s 0.007s 04 0 0 2 776 0.061s 0.01s 05 0 0 4 662 0.069s 0.008s 06 0 0 1 11 0.002s 0.001s 07 0 0 0 33 0.062s 0.01s 08 0 0 0 150 0.061s 0.006s 09 0 0 0 43 0.062s 0.025s 10 0 0 0 20 0.068s 0.021s 11 0 0 1 367 0.063s 0.01s 12 0 0 3 203 0.002s 0.002s 13 0 0 0 153 0.004s 0.005s 14 0 0 1 34 0.015s 0.001s 15 0 0 0 15 0.008s 0.002s 16 0 0 0 3 0.003s 0.001s 17 0 0 0 4 0.003s 0.003s 18 0 0 0 52 0.063s 0.003s 19 0 0 0 3 0.002s 0.001s 20 0 0 0 32 0.009s 0.003s 21 0 0 0 30 0.061s 0.006s 22 0 0 0 4 0.062s 0.016s 23 0 0 0 86 0.062s 0.02s Day Hour Count Avg time (sec) Sep 26 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 Sep 26 00 34,052.83 kB 116,433.50 kB 01 1,895.33 kB 55,385.89 kB 02 1,331.50 kB 25,452.00 kB 03 1,048.00 kB 4,652.29 kB 04 2,311.90 kB 3,129.90 kB 05 8,421.38 kB 13,555.25 kB 06 10,731.00 kB 12,836.00 kB 07 1,744.40 kB 10,154.60 kB 08 294.20 kB 6,104.20 kB 09 83.50 kB 3,836.00 kB 10 49.20 kB 2,425.20 kB 11 529.50 kB 1,516.00 kB 12 31,037.50 kB 31,433.50 kB 13 822.25 kB 48,100.75 kB 14 360.00 kB 36,821.00 kB 15 110.00 kB 31,501.50 kB 16 190.00 kB 26,879.00 kB 17 95.00 kB 22,991.50 kB 18 992.00 kB 18,809.00 kB 19 190.00 kB 16,068.00 kB 20 528.67 kB 13,162.67 kB 21 133.00 kB 9,669.00 kB 22 192.00 kB 7,829.00 kB 23 176.50 kB 6,081.75 kB -
Temporary Files
Size of temporary files
Key values
- 495.20 MiB Temp Files size Peak
- 2026-09-26 05:31:55 Date
Number of temporary files
Key values
- 4 per second Temp Files Peak
- 2026-09-26 05:32:02 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Sep 26 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 20 1.32 GiB 67.38 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 16 1.02 GiB 36.92 MiB 247.60 MiB 64.98 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-26 05:32:04 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-26 05:31:55 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 4 307.87 MiB 57.22 MiB 94.17 MiB 76.97 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-26 05:30:42 Duration: 39s276ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-26 05:30:38 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 247.60 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-26 05:31:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 247.60 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-26 05:31:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 94.17 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-26 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 94.17 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-26 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 62.30 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-26 05:30:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 57.22 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-26 05:30:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 40.91 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-26 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 40.85 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-26 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 40.84 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-26 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 40.84 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-26 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 40.84 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-26 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 40.83 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-26 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 40.83 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-26 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 37.00 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-26 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 36.94 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-26 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 36.94 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-26 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 36.93 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-26 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 36.93 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-26 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 36.92 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-26 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 36.92 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-26 05:32:03 - 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 brasilia - 2026-09-26 05:19:04 Date
- 0 sec Highest CPU-cost analyze
Table
Database brasilia - Date
Average Autovacuum Duration
Key values
- 0.41 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database brasilia - 2026-09-26 05:19:04 Date
Analyzes per table
Key values
- public.temp0000292580 (7) Main table analyzed (database rio)
- 22 analyzes Total
Table Number of analyzes rio.public.temp0000292580 7 brasilia.pg_catalog.pg_attribute 2 rio.pg_catalog.pg_type 2 rio.public.temp0000292596 2 brasilia.public.temp0000240992 1 rio.pg_catalog.pg_attribute 1 rio.pg_catalog.pg_index 1 rio.pg_catalog.pg_class 1 brasilia.pg_catalog.pg_type 1 rio.public.temp0000292592 1 rio.pg_catalog.pg_depend 1 brasilia.pg_catalog.pg_class 1 rio.public.temp0000292582 1 Total 22 Vacuums per table
Key values
- public.temp0000292596 (2) Main table vacuumed on database rio
- 15 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.public.temp0000292596 2 0 0 0 0 0 0 3,660 8 217,146 0 0 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,369 101 450,145 83 700 brasilia.pg_catalog.pg_class 1 1 0 0 0 0 0 256 104 128,297 3 7 rio.pg_catalog.pg_statistic 1 1 0 0 0 0 0 3,629 784 3,348,856 725 4,457 brasilia.pg_catalog.pg_attribute 1 1 0 0 0 0 0 562 205 234,977 0 0 brasilia.pg_catalog.pg_type 1 1 0 0 0 0 0 112 46 53,384 3 6 rio.pg_catalog.pg_class 1 1 0 0 0 0 0 454 133 155,720 2 5 rio.pg_catalog.pg_index 1 1 0 0 0 0 0 90 27 20,579 1 1 rio.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 854 203 1,086,323 123 374 rio.pg_catalog.pg_type 1 1 0 0 0 0 0 178 49 65,061 4 8 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 139 27 86,280 6 17 brasilia.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,595 287 1,321,216 267 1,877 rio.pg_catalog.pg_attribute 1 1 0 0 0 0 0 940 199 276,907 5 123 brasilia.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 179 35 113,448 15 32 Total 15 13 0 0 0 0 0 16,017 2,208 7,558,339 1,237 7,607 Vacuum throughput per table
Key values
- pg_catalog.pg_statistic (0.41) Max CPU elapsed for vacuum on database brasilia
- unknown (0 ms) Max I/O read time for vacuum on database brasilia
- unknown (0 ms) Max I/O write time for vacuum on database brasilia
I/O timing (ms) CPU (s) Table read write elapsed rio.public.temp0000292596 0 0 0.08 contagem.pg_catalog.pg_statistic 0 0 0.1 brasilia.pg_catalog.pg_class 0 0 0.12 rio.pg_catalog.pg_statistic 0 0 0.29 brasilia.pg_catalog.pg_attribute 0 0 0.22 brasilia.pg_catalog.pg_type 0 0 0.17 rio.pg_catalog.pg_class 0 0 0.28 rio.pg_catalog.pg_index 0 0 0.07 rio.pg_toast.pg_toast_2619 0 0 0.05 rio.pg_catalog.pg_type 0 0 0.15 contagem.pg_toast.pg_toast_2619 0 0 0 brasilia.pg_catalog.pg_statistic 0 0 0.41 rio.pg_catalog.pg_attribute 0 0 0.26 brasilia.pg_toast.pg_toast_2619 0 0 0 Total 0 0 2.2 Tuples removed per table
Key values
- pg_catalog.pg_attribute (5786) Main table with removed tuples on database rio
- 22734 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 1 1 5,786 22,164 0 147 594 rio.pg_catalog.pg_statistic 1 1 4,406 7,498 0 0 1,286 contagem.pg_catalog.pg_statistic 1 1 4,180 7,274 0 0 1,011 brasilia.pg_catalog.pg_statistic 1 1 3,834 7,360 0 0 1,072 brasilia.pg_catalog.pg_attribute 1 1 2,140 20,425 0 0 553 rio.pg_toast.pg_toast_2619 1 1 661 677 0 0 279 rio.pg_catalog.pg_type 1 1 644 2,209 0 0 77 rio.pg_catalog.pg_index 1 1 269 1,885 0 3 52 brasilia.pg_catalog.pg_class 1 1 207 3,338 0 0 130 rio.pg_catalog.pg_class 1 1 167 3,374 0 0 151 brasilia.pg_catalog.pg_type 1 1 160 2,187 0 7 59 brasilia.pg_toast.pg_toast_2619 1 1 148 133 0 0 67 contagem.pg_toast.pg_toast_2619 1 1 132 118 0 0 58 rio.public.temp0000292596 2 0 0 51,914 0 0 3,712 Total 15 13 22,734 130,556 0 157 9,101 Pages removed per table
Key values
- pg_catalog.pg_attribute (147) Main table with removed pages on database rio
- 157 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.pg_catalog.pg_attribute 1 1 5786 147 brasilia.pg_catalog.pg_type 1 1 160 7 rio.pg_catalog.pg_index 1 1 269 3 contagem.pg_catalog.pg_statistic 1 1 4180 0 rio.public.temp0000292596 2 0 0 0 brasilia.pg_catalog.pg_class 1 1 207 0 rio.pg_catalog.pg_statistic 1 1 4406 0 brasilia.pg_catalog.pg_attribute 1 1 2140 0 rio.pg_catalog.pg_class 1 1 167 0 rio.pg_toast.pg_toast_2619 1 1 661 0 rio.pg_catalog.pg_type 1 1 644 0 contagem.pg_toast.pg_toast_2619 1 1 132 0 brasilia.pg_catalog.pg_statistic 1 1 3834 0 brasilia.pg_toast.pg_toast_2619 1 1 148 0 Total 15 13 22,734 157 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Sep 26 00 0 0 01 0 5 02 0 0 03 0 0 04 0 2 05 7 2 06 0 0 07 0 0 08 0 1 09 0 0 10 0 1 11 1 2 12 6 7 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 1 - 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
- 295 Total read queries
- 418 Total write queries
Queries by database
Key values
- rio Main database
- 551 Requests
- 2h36m53s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 966 Requests
User Request type Count Duration etiquetas Total 7 5s353ms select 7 5s353ms intelifix Total 966 4h3m30s copy to 405 42m20s ddl 13 2m15s others 289 35m3s select 259 2h43m51s lenon Total 29 1m1s select 29 1m1s Duration by user
Key values
- 4h3m30s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 7 5s353ms select 7 5s353ms intelifix Total 966 4h3m30s copy to 405 42m20s ddl 13 2m15s others 289 35m3s select 259 2h43m51s lenon Total 29 1m1s select 29 1m1s Queries by host
Key values
- [local] Main host
- 1,002 Requests
- 4h4m37s ([local])
- Main time consuming host
Queries by application
Key values
- pg_dump Main application
- 440 Requests
- 3h15m59s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-09-26 07:25:04 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 373 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 11m10s analyze verbose;[ Date: 2026-09-26 05:11:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 8m47s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-26 07:13:48 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 7m15s analyze verbose;[ Date: 2026-09-26 05:18:27 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
4 6m42s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-26 20:11:44 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 5m30s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-26 21:10:32 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 5m22s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-26 22:10:23 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 5m20s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-26 19:10:22 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 5m20s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-26 13:10:22 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 5m19s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-26 09:10:21 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 5m15s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-26 18:10:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 5m14s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-26 16:10:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m13s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-26 12:10:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 5m12s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-26 15:10:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m12s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-26 10:10:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m11s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-26 11:10:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m11s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-26 17:10:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m11s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-26 14:10:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 5m10s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-26 08:10:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 4m1s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-09-26 07:20:06 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
20 3m35s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-09-26 20:16:43 - 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 1h34m39s 48 2s94ms 8m47s 1m58s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 26 07 3 9m39s 3m13s 08 3 5m27s 1m49s 09 3 5m36s 1m52s 10 3 5m28s 1m49s 11 3 5m28s 1m49s 12 3 5m30s 1m50s 13 3 5m40s 1m53s 14 3 5m28s 1m49s 15 3 5m30s 1m50s 16 3 5m30s 1m50s 17 3 5m28s 1m49s 18 3 5m32s 1m50s 19 3 5m37s 1m52s 20 3 7m10s 2m23s 21 3 5m47s 1m55s 22 3 5m39s 1m53s [ User: intelifix - Total duration: 1h34m39s - Times executed: 48 ]
[ Application: psql - Total duration: 1h34m39s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-26 07:13:48 Duration: 8m47s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-26 20:11:44 Duration: 6m42s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-26 21:10:32 Duration: 5m30s Database: rio User: intelifix Remote: [local] Application: psql
2 1h5m8s 48 226ms 4m1s 1m21s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 26 07 3 5m36s 1m52s 08 3 3m50s 1m16s 09 3 3m54s 1m18s 10 3 3m50s 1m16s 11 3 3m52s 1m17s 12 3 3m52s 1m17s 13 3 3m59s 1m19s 14 3 3m51s 1m17s 15 3 4m1s 1m20s 16 3 3m54s 1m18s 17 3 4m 1m20s 18 3 3m52s 1m17s 19 3 3m56s 1m18s 20 3 4m41s 1m33s 21 3 3m53s 1m17s 22 3 3m59s 1m19s [ User: intelifix - Total duration: 1h5m8s - Times executed: 48 ]
[ Application: psql - Total duration: 1h5m8s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-26 07:20:06 Duration: 4m1s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-26 20:16:43 Duration: 3m35s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-26 15:14:31 Duration: 3m30s Database: brasilia User: intelifix Remote: [local] Application: psql
3 21m27s 3 3m1s 11m10s 7m9s analyze verbose;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 26 05 3 21m27s 7m9s [ User: intelifix - Total duration: 21m27s - Times executed: 3 ]
[ Application: psql - Total duration: 21m27s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-26 05:11:12 Duration: 11m10s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-26 05:18:27 Duration: 7m15s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-26 05:21:29 Duration: 3m1s Database: contagem User: intelifix Remote: [local] Application: psql
4 7m45s 144 153ms 9s668ms 3s235ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 26 00 7 27s278ms 3s896ms 01 6 18s555ms 3s92ms 02 6 19s375ms 3s229ms 03 6 19s472ms 3s245ms 04 6 18s305ms 3s50ms 05 7 19s158ms 2s736ms 06 6 18s935ms 3s155ms 07 6 18s726ms 3s121ms 08 6 18s966ms 3s161ms 09 6 18s726ms 3s121ms 10 6 18s957ms 3s159ms 11 6 18s904ms 3s150ms 12 6 19s333ms 3s222ms 13 8 24s87ms 3s10ms 14 6 19s579ms 3s263ms 15 6 19s354ms 3s225ms 16 6 18s889ms 3s148ms 17 6 19s463ms 3s243ms 18 6 18s834ms 3s139ms 19 6 18s916ms 3s152ms 20 8 31s732ms 3s966ms 21 6 21s176ms 3s529ms 22 6 19s131ms 3s188ms [ User: intelifix - Total duration: 7m45s - Times executed: 144 ]
[ Application: psql - Total duration: 7m45s - Times executed: 144 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-26 00:05:31 Duration: 9s668ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-26 20:05:11 Duration: 9s289ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-26 20:15:09 Duration: 7s888ms Database: rio User: intelifix Remote: [local] Application: psql
5 2m55s 6 5s100ms 46s668ms 29s236ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 26 08 3 1m22s 27s394ms 11 1 41s468ms 41s468ms 12 2 51s769ms 25s884ms [ User: intelifix - Total duration: 2m55s - Times executed: 6 ]
[ Application: [unknown] - Total duration: 2m55s - Times executed: 6 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030474, 0508 )', '/var/www/html/tmp/nf_carga_lotes_0508.xlsx');
Date: 2026-09-26 12:53:58 Duration: 46s668ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_seriais_expedidos(7,DATE(''2026-09-10''),DATE(''2026-09-25'')) ;', '/var/www/html/tmp/temp_54.xlsx');
Date: 2026-09-26 08:06:23 Duration: 44s313ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_seriais_expedidos(7,DATE(''2026-09-01''),DATE(''2026-09-26'')) ;', '/var/www/html/tmp/temp_54.xlsx');
Date: 2026-09-26 11:48:42 Duration: 41s468ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
6 2m17s 4 4s758ms 1m4s 34s336ms 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 Sep 26 20 2 1m8s 34s483ms 23 2 1m8s 34s190ms [ User: intelifix - Total duration: 2m17s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m17s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-26 20:08:43 Duration: 1m4s 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-09-26 23:16:45 Duration: 1m3s 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-09-26 20:10:44 Duration: 4s763ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 1m47s 6 3s188ms 40s110ms 17s925ms copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 26 20 3 53s888ms 17s962ms 23 3 53s666ms 17s888ms [ User: intelifix - Total duration: 1m47s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m47s - 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-09-26 20:06:28 Duration: 40s110ms 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-09-26 23:14:29 Duration: 39s646ms 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-09-26 20:10:19 Duration: 10s588ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 1m47s 4 361ms 53s343ms 26s833ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 26 20 2 53s619ms 26s809ms 23 2 53s712ms 26s856ms [ User: intelifix - Total duration: 1m47s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m47s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-26 23:13:47 Duration: 53s343ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-26 20:05:45 Duration: 53s258ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-26 23:33:38 Duration: 369ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
9 1m42s 34 150ms 20s170ms 3s21ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 26 00 6 33s643ms 5s607ms 01 6 15s585ms 2s597ms 02 6 14s339ms 2s389ms 03 5 15s496ms 3s99ms 04 6 20s851ms 3s475ms 05 2 1s540ms 770ms 13 1 423ms 423ms 20 2 853ms 426ms [ User: intelifix - Total duration: 1m42s - Times executed: 34 ]
[ Application: psql - Total duration: 1m42s - Times executed: 34 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-26 00:05:21 Duration: 20s170ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-26 03:15:08 Duration: 7s25ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-26 04:55:07 Duration: 6s139ms Database: rio User: intelifix Remote: [local] Application: psql
10 1m25s 3 11s445ms 1m2s 28s382ms create table temp0000292596 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 26 12 3 1m25s 28s382ms [ User: intelifix - Total duration: 1m25s - Times executed: 3 ]
[ Application: [unknown] - Total duration: 1m25s - Times executed: 3 ]
-
CREATE TABLE temp0000292596 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-26 12:51:52 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292596 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-26 12:53:05 Duration: 11s457ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292596 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-26 12:52:23 Duration: 11s445ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 1m23s 6 2s322ms 31s796ms 13s935ms 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 Sep 26 20 3 41s753ms 13s917ms 23 3 41s857ms 13s952ms [ User: intelifix - Total duration: 1m23s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m23s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-09-26 23:15:04 Duration: 31s796ms 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-09-26 20:07:02 Duration: 31s669ms 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-09-26 20:10:27 Duration: 7s761ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
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 Sep 26 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-09-26 05:32:04 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-26 05:31:55 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
13 1m22s 6 3s83ms 31s792ms 13s758ms 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 Sep 26 20 3 41s202ms 13s734ms 23 3 41s346ms 13s782ms [ User: intelifix - Total duration: 1m22s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m22s - 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-09-26 23:17:17 Duration: 31s792ms 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-09-26 20:09:15 Duration: 31s637ms 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-09-26 23:34:20 Duration: 6s470ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 1m11s 6 2s472ms 23s681ms 11s951ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 26 20 3 35s878ms 11s959ms 23 3 35s833ms 11s944ms [ User: intelifix - Total duration: 1m11s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m11s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-26 20:02:48 Duration: 23s681ms 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-09-26 23:10:49 Duration: 23s616ms 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-09-26 23:33:06 Duration: 9s744ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 1m11s 6 2s257ms 24s201ms 11s907ms 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 Sep 26 20 3 35s818ms 11s939ms 23 3 35s626ms 11s875ms [ User: intelifix - Total duration: 1m11s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m11s - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-26 20:03:30 Duration: 24s201ms 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-09-26 23:11:30 Duration: 24s151ms 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-09-26 20:09:48 Duration: 9s359ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 1m4s 6 1s847ms 25s347ms 10s773ms copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 26 20 3 31s848ms 10s616ms 23 3 32s790ms 10s930ms [ 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-09-26 23:12:29 Duration: 25s347ms 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-09-26 20:04:28 Duration: 25s68ms 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-09-26 23:33:33 Duration: 5s479ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 55s687ms 4 4s263ms 23s786ms 13s921ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 26 20 2 27s620ms 13s810ms 23 2 28s67ms 14s33ms [ User: intelifix - Total duration: 55s687ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 55s687ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-09-26 23:12:53 Duration: 23s786ms 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-09-26 20:04:52 Duration: 23s357ms 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-09-26 23:33:37 Duration: 4s281ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 54s435ms 6 2s456ms 20s228ms 9s72ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 26 00 3 27s371ms 9s123ms 06 3 27s63ms 9s21ms [ User: lenon - Total duration: 54s435ms - Times executed: 6 ]
[ Application: psql - Total duration: 54s435ms - Times executed: 6 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-09-26 00:02:23 Duration: 20s228ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-09-26 06:02:21 Duration: 19s423ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-09-26 00:02:28 Duration: 4s686ms Database: brasilia User: lenon Remote: [local] Application: psql
19 51s604ms 6 1s857ms 16s932ms 8s600ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 26 20 3 25s623ms 8s541ms 23 3 25s980ms 8s660ms [ User: intelifix - Total duration: 51s604ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 51s604ms - 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-09-26 23:11:47 Duration: 16s932ms 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-09-26 20:03:46 Duration: 16s548ms 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-09-26 20:09:56 Duration: 7s218ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 49s871ms 56 563ms 4s973ms 890ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 26 08 5 8s544ms 1s708ms 09 3 2s354ms 784ms 10 3 2s110ms 703ms 11 3 2s269ms 756ms 12 4 4s5ms 1s1ms 13 3 2s148ms 716ms 14 3 2s252ms 750ms 15 3 2s296ms 765ms 16 4 3s370ms 842ms 17 4 3s58ms 764ms 18 5 3s922ms 784ms 19 4 3s192ms 798ms 20 4 3s929ms 982ms 21 4 3s192ms 798ms 22 4 3s222ms 805ms [ User: intelifix - Total duration: 49s871ms - Times executed: 56 ]
[ Application: psql - Total duration: 49s871ms - Times executed: 56 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-26 08:00:06 Duration: 4s973ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-26 12:20:04 Duration: 1s823ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-26 20:20:03 Duration: 1s625ms Database: rio User: intelifix Remote: [local] Application: psql
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 144 7m45s 153ms 9s668ms 3s235ms call rs_giga_triagem (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 26 00 7 27s278ms 3s896ms 01 6 18s555ms 3s92ms 02 6 19s375ms 3s229ms 03 6 19s472ms 3s245ms 04 6 18s305ms 3s50ms 05 7 19s158ms 2s736ms 06 6 18s935ms 3s155ms 07 6 18s726ms 3s121ms 08 6 18s966ms 3s161ms 09 6 18s726ms 3s121ms 10 6 18s957ms 3s159ms 11 6 18s904ms 3s150ms 12 6 19s333ms 3s222ms 13 8 24s87ms 3s10ms 14 6 19s579ms 3s263ms 15 6 19s354ms 3s225ms 16 6 18s889ms 3s148ms 17 6 19s463ms 3s243ms 18 6 18s834ms 3s139ms 19 6 18s916ms 3s152ms 20 8 31s732ms 3s966ms 21 6 21s176ms 3s529ms 22 6 19s131ms 3s188ms [ User: intelifix - Total duration: 7m45s - Times executed: 144 ]
[ Application: psql - Total duration: 7m45s - Times executed: 144 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-26 00:05:31 Duration: 9s668ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-26 20:05:11 Duration: 9s289ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-26 20:15:09 Duration: 7s888ms Database: rio User: intelifix Remote: [local] Application: psql
2 56 49s871ms 563ms 4s973ms 890ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 26 08 5 8s544ms 1s708ms 09 3 2s354ms 784ms 10 3 2s110ms 703ms 11 3 2s269ms 756ms 12 4 4s5ms 1s1ms 13 3 2s148ms 716ms 14 3 2s252ms 750ms 15 3 2s296ms 765ms 16 4 3s370ms 842ms 17 4 3s58ms 764ms 18 5 3s922ms 784ms 19 4 3s192ms 798ms 20 4 3s929ms 982ms 21 4 3s192ms 798ms 22 4 3s222ms 805ms [ User: intelifix - Total duration: 49s871ms - Times executed: 56 ]
[ Application: psql - Total duration: 49s871ms - Times executed: 56 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-26 08:00:06 Duration: 4s973ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-26 12:20:04 Duration: 1s823ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-26 20:20:03 Duration: 1s625ms Database: rio User: intelifix Remote: [local] Application: psql
3 48 1h34m39s 2s94ms 8m47s 1m58s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 26 07 3 9m39s 3m13s 08 3 5m27s 1m49s 09 3 5m36s 1m52s 10 3 5m28s 1m49s 11 3 5m28s 1m49s 12 3 5m30s 1m50s 13 3 5m40s 1m53s 14 3 5m28s 1m49s 15 3 5m30s 1m50s 16 3 5m30s 1m50s 17 3 5m28s 1m49s 18 3 5m32s 1m50s 19 3 5m37s 1m52s 20 3 7m10s 2m23s 21 3 5m47s 1m55s 22 3 5m39s 1m53s [ User: intelifix - Total duration: 1h34m39s - Times executed: 48 ]
[ Application: psql - Total duration: 1h34m39s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-26 07:13:48 Duration: 8m47s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-26 20:11:44 Duration: 6m42s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-26 21:10:32 Duration: 5m30s Database: rio User: intelifix Remote: [local] Application: psql
4 48 1h5m8s 226ms 4m1s 1m21s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 26 07 3 5m36s 1m52s 08 3 3m50s 1m16s 09 3 3m54s 1m18s 10 3 3m50s 1m16s 11 3 3m52s 1m17s 12 3 3m52s 1m17s 13 3 3m59s 1m19s 14 3 3m51s 1m17s 15 3 4m1s 1m20s 16 3 3m54s 1m18s 17 3 4m 1m20s 18 3 3m52s 1m17s 19 3 3m56s 1m18s 20 3 4m41s 1m33s 21 3 3m53s 1m17s 22 3 3m59s 1m19s [ User: intelifix - Total duration: 1h5m8s - Times executed: 48 ]
[ Application: psql - Total duration: 1h5m8s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-26 07:20:06 Duration: 4m1s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-26 20:16:43 Duration: 3m35s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-26 15:14:31 Duration: 3m30s Database: brasilia User: intelifix Remote: [local] Application: psql
5 43 13s406ms 150ms 1s107ms 311ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 26 01 16 5s337ms 333ms 04 22 6s792ms 308ms 05 5 1s275ms 255ms [ User: intelifix - Total duration: 13s406ms - Times executed: 43 ]
[ Application: [unknown] - Total duration: 13s406ms - Times executed: 43 ]
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '241661495659,241667004345,241651802626,241712204054,241607379817,241698574957,230048042646,241605092647,241646144756,241620659609', NULL, NULL, 0320, 00);
Date: 2026-09-26 01:23:18 Duration: 1s107ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (429, 5, '113', 3, '241661371327,241706711229,241672910725,241712040627,241651591113,241614521233,230048410718,241592979398,241601468285,241695027394,241607638608,241703750020,241714067995,241630280818,241667125569,241604327689,241729503049,241646292728,241715742323', NULL, NULL, 0320, 00);
Date: 2026-09-26 04:43:14 Duration: 674ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '241704228405,241608689406,241615115869,241606099197,241695536164,241713153754,241676803147,241667171130,241731207984,241700831721,241731225360,241727245959,241620245472,241637729210,241655474163,241603129604,241734128102,241635230931', NULL, NULL, 0320, 00);
Date: 2026-09-26 04:22:00 Duration: 593ms Database: rio User: intelifix Remote: [local] Application: [unknown]
6 34 1m42s 150ms 20s170ms 3s21ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 26 00 6 33s643ms 5s607ms 01 6 15s585ms 2s597ms 02 6 14s339ms 2s389ms 03 5 15s496ms 3s99ms 04 6 20s851ms 3s475ms 05 2 1s540ms 770ms 13 1 423ms 423ms 20 2 853ms 426ms [ User: intelifix - Total duration: 1m42s - Times executed: 34 ]
[ Application: psql - Total duration: 1m42s - Times executed: 34 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-26 00:05:21 Duration: 20s170ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-26 03:15:08 Duration: 7s25ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-26 04:55:07 Duration: 6s139ms Database: rio User: intelifix Remote: [local] Application: psql
7 34 27s180ms 581ms 932ms 799ms 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 #7
Day Hour Count Duration Avg duration Sep 26 08 1 769ms 769ms 09 3 2s165ms 721ms 10 3 2s491ms 830ms 11 3 2s307ms 769ms 12 2 1s600ms 800ms 13 3 2s636ms 878ms 14 3 2s397ms 799ms 15 3 2s467ms 822ms 16 2 1s707ms 853ms 17 2 1s841ms 920ms 18 1 737ms 737ms 19 2 1s631ms 815ms 20 2 1s416ms 708ms 21 2 1s439ms 719ms 22 2 1s570ms 785ms [ User: intelifix - Total duration: 27s180ms - Times executed: 34 ]
[ Application: psql - Total duration: 27s180ms - Times executed: 34 ]
-
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-09-26 17:40:02 Duration: 932ms 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-09-26 14:20:02 Duration: 922ms 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-09-26 19:40:02 Duration: 919ms Database: rio User: intelifix Remote: [local] Application: psql
8 27 7s589ms 151ms 849ms 281ms select * from rs_equipamento_consulta (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 26 00 1 373ms 373ms 01 3 956ms 318ms 04 7 2s144ms 306ms 05 6 1s185ms 197ms 08 1 204ms 204ms 09 1 849ms 849ms 10 5 868ms 173ms 11 2 593ms 296ms 20 1 413ms 413ms [ User: intelifix - Total duration: 7s589ms - Times executed: 27 ]
[ Application: [unknown] - Total duration: 7s589ms - Times executed: 27 ]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('184251982336');
Date: 2026-09-26 09:07:53 Duration: 849ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('241599491427');
Date: 2026-09-26 04:31:49 Duration: 554ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('241621000204');
Date: 2026-09-26 01:39:24 Duration: 470ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 23 7s102ms 301ms 329ms 308ms 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 Sep 26 01 3 936ms 312ms 03 1 305ms 305ms 04 2 617ms 308ms 05 1 310ms 310ms 07 2 632ms 316ms 08 3 930ms 310ms 09 1 306ms 306ms 10 3 909ms 303ms 11 3 915ms 305ms 12 2 618ms 309ms 13 1 308ms 308ms 15 1 311ms 311ms [ User: lenon - Total duration: 7s102ms - Times executed: 23 ]
[ Application: [unknown] - Total duration: 7s102ms - Times executed: 23 ]
-
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-09-26 07:36:06 Duration: 329ms 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-09-26 01:22:18 Duration: 323ms 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-09-26 08:03:56 Duration: 316ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes
10 13 5s172ms 338ms 793ms 397ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 26 01 3 1s512ms 504ms 03 1 390ms 390ms 04 2 708ms 354ms 05 1 376ms 376ms 07 1 386ms 386ms 08 2 704ms 352ms 09 1 369ms 369ms 10 1 339ms 339ms 12 1 384ms 384ms [ User: intelifix - Total duration: 5s172ms - Times executed: 13 ]
[ Application: [unknown] - Total duration: 5s172ms - Times executed: 13 ]
-
select * from rs_menu_grants (499, 0, 1);
Date: 2026-09-26 01:22:18 Duration: 793ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (499, 81, 1);
Date: 2026-09-26 03:58:25 Duration: 390ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (508, 0, 1);
Date: 2026-09-26 07:36:06 Duration: 386ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 10 2s912ms 157ms 452ms 291ms call rs_giga_tecnicos ();Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 26 00 3 1s63ms 354ms 05 1 212ms 212ms 13 2 510ms 255ms 14 1 200ms 200ms 20 3 924ms 308ms [ User: intelifix - Total duration: 2s912ms - Times executed: 10 ]
[ Application: psql - Total duration: 2s912ms - Times executed: 10 ]
-
CALL RS_GIGA_TECNICOS ();
Date: 2026-09-26 00:05:02 Duration: 452ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TECNICOS ();
Date: 2026-09-26 00:05:01 Duration: 428ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TECNICOS ();
Date: 2026-09-26 20:05:01 Duration: 387ms Database: rio User: intelifix Remote: [local] Application: psql
12 9 3s758ms 361ms 621ms 417ms select * from rs_menu (?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 26 07 1 507ms 507ms 08 1 621ms 621ms 10 2 731ms 365ms 11 2 725ms 362ms 12 1 378ms 378ms 13 1 419ms 419ms 15 1 374ms 374ms [ User: intelifix - Total duration: 3s758ms - Times executed: 9 ]
[ Application: [unknown] - Total duration: 3s758ms - Times executed: 9 ]
-
SELECT * FROM RS_MENU (404, 1);
Date: 2026-09-26 08:03:56 Duration: 621ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MENU (508, 1);
Date: 2026-09-26 07:33:40 Duration: 507ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MENU (399, 1);
Date: 2026-09-26 13:46:58 Duration: 419ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
13 7 3s47ms 231ms 603ms 435ms 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 Sep 26 20 3 1s236ms 412ms 23 4 1s811ms 452ms [ User: intelifix - Total duration: 3s47ms - Times executed: 7 ]
[ Application: pg_dump - Total duration: 3s47ms - 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-09-26 20:09:18 Duration: 603ms 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-09-26 23:32:46 Duration: 590ms 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-09-26 23:42:30 Duration: 449ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
14 7 1s991ms 157ms 392ms 284ms 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 Sep 26 20 3 654ms 218ms 23 4 1s337ms 334ms [ User: intelifix - Total duration: 1s991ms - Times executed: 7 ]
[ Application: pg_dump - Total duration: 1s991ms - 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-09-26 23:32:45 Duration: 392ms 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-09-26 23:10:02 Duration: 384ms 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-09-26 23:42:30 Duration: 357ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
15 6 2m55s 5s100ms 46s668ms 29s236ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 26 08 3 1m22s 27s394ms 11 1 41s468ms 41s468ms 12 2 51s769ms 25s884ms [ User: intelifix - Total duration: 2m55s - Times executed: 6 ]
[ Application: [unknown] - Total duration: 2m55s - Times executed: 6 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030474, 0508 )', '/var/www/html/tmp/nf_carga_lotes_0508.xlsx');
Date: 2026-09-26 12:53:58 Duration: 46s668ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_seriais_expedidos(7,DATE(''2026-09-10''),DATE(''2026-09-25'')) ;', '/var/www/html/tmp/temp_54.xlsx');
Date: 2026-09-26 08:06:23 Duration: 44s313ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_seriais_expedidos(7,DATE(''2026-09-01''),DATE(''2026-09-26'')) ;', '/var/www/html/tmp/temp_54.xlsx');
Date: 2026-09-26 11:48:42 Duration: 41s468ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
16 6 1m47s 3s188ms 40s110ms 17s925ms 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 #16
Day Hour Count Duration Avg duration Sep 26 20 3 53s888ms 17s962ms 23 3 53s666ms 17s888ms [ User: intelifix - Total duration: 1m47s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m47s - 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-09-26 20:06:28 Duration: 40s110ms 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-09-26 23:14:29 Duration: 39s646ms 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-09-26 20:10:19 Duration: 10s588ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 6 1m23s 2s322ms 31s796ms 13s935ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 26 20 3 41s753ms 13s917ms 23 3 41s857ms 13s952ms [ User: intelifix - Total duration: 1m23s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m23s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-09-26 23:15:04 Duration: 31s796ms 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-09-26 20:07:02 Duration: 31s669ms 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-09-26 20:10:27 Duration: 7s761ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 6 1m22s 3s83ms 31s792ms 13s758ms 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 #18
Day Hour Count Duration Avg duration Sep 26 20 3 41s202ms 13s734ms 23 3 41s346ms 13s782ms [ User: intelifix - Total duration: 1m22s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m22s - 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-09-26 23:17:17 Duration: 31s792ms 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-09-26 20:09:15 Duration: 31s637ms 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-09-26 23:34:20 Duration: 6s470ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 6 1m11s 2s472ms 23s681ms 11s951ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 26 20 3 35s878ms 11s959ms 23 3 35s833ms 11s944ms [ User: intelifix - Total duration: 1m11s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m11s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-26 20:02:48 Duration: 23s681ms 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-09-26 23:10:49 Duration: 23s616ms 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-09-26 23:33:06 Duration: 9s744ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 6 1m11s 2s257ms 24s201ms 11s907ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 26 20 3 35s818ms 11s939ms 23 3 35s626ms 11s875ms [ User: intelifix - Total duration: 1m11s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m11s - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-26 20:03:30 Duration: 24s201ms 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-09-26 23:11:30 Duration: 24s151ms 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-09-26 20:09:48 Duration: 9s359ms 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 3m1s 11m10s 7m9s 3 21m27s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 26 05 3 21m27s 7m9s [ User: intelifix - Total duration: 21m27s - Times executed: 3 ]
[ Application: psql - Total duration: 21m27s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-26 05:11:12 Duration: 11m10s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-26 05:18:27 Duration: 7m15s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-26 05:21:29 Duration: 3m1s Database: contagem User: intelifix Remote: [local] Application: psql
2 2s94ms 8m47s 1m58s 48 1h34m39s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 26 07 3 9m39s 3m13s 08 3 5m27s 1m49s 09 3 5m36s 1m52s 10 3 5m28s 1m49s 11 3 5m28s 1m49s 12 3 5m30s 1m50s 13 3 5m40s 1m53s 14 3 5m28s 1m49s 15 3 5m30s 1m50s 16 3 5m30s 1m50s 17 3 5m28s 1m49s 18 3 5m32s 1m50s 19 3 5m37s 1m52s 20 3 7m10s 2m23s 21 3 5m47s 1m55s 22 3 5m39s 1m53s [ User: intelifix - Total duration: 1h34m39s - Times executed: 48 ]
[ Application: psql - Total duration: 1h34m39s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-26 07:13:48 Duration: 8m47s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-26 20:11:44 Duration: 6m42s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-26 21:10:32 Duration: 5m30s Database: rio User: intelifix Remote: [local] Application: psql
3 1m22s 1m22s 1m22s 1 1m22s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 26 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-09-26 05:32:04 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-26 05:31:55 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
4 226ms 4m1s 1m21s 48 1h5m8s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 26 07 3 5m36s 1m52s 08 3 3m50s 1m16s 09 3 3m54s 1m18s 10 3 3m50s 1m16s 11 3 3m52s 1m17s 12 3 3m52s 1m17s 13 3 3m59s 1m19s 14 3 3m51s 1m17s 15 3 4m1s 1m20s 16 3 3m54s 1m18s 17 3 4m 1m20s 18 3 3m52s 1m17s 19 3 3m56s 1m18s 20 3 4m41s 1m33s 21 3 3m53s 1m17s 22 3 3m59s 1m19s [ User: intelifix - Total duration: 1h5m8s - Times executed: 48 ]
[ Application: psql - Total duration: 1h5m8s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-26 07:20:06 Duration: 4m1s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-26 20:16:43 Duration: 3m35s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-26 15:14:31 Duration: 3m30s Database: brasilia User: intelifix Remote: [local] Application: psql
5 4s758ms 1m4s 34s336ms 4 2m17s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 26 20 2 1m8s 34s483ms 23 2 1m8s 34s190ms [ User: intelifix - Total duration: 2m17s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m17s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-26 20:08:43 Duration: 1m4s 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-09-26 23:16:45 Duration: 1m3s 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-09-26 20:10:44 Duration: 4s763ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 5s100ms 46s668ms 29s236ms 6 2m55s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 26 08 3 1m22s 27s394ms 11 1 41s468ms 41s468ms 12 2 51s769ms 25s884ms [ User: intelifix - Total duration: 2m55s - Times executed: 6 ]
[ Application: [unknown] - Total duration: 2m55s - Times executed: 6 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030474, 0508 )', '/var/www/html/tmp/nf_carga_lotes_0508.xlsx');
Date: 2026-09-26 12:53:58 Duration: 46s668ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_seriais_expedidos(7,DATE(''2026-09-10''),DATE(''2026-09-25'')) ;', '/var/www/html/tmp/temp_54.xlsx');
Date: 2026-09-26 08:06:23 Duration: 44s313ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_seriais_expedidos(7,DATE(''2026-09-01''),DATE(''2026-09-26'')) ;', '/var/www/html/tmp/temp_54.xlsx');
Date: 2026-09-26 11:48:42 Duration: 41s468ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
7 11s445ms 1m2s 28s382ms 3 1m25s create table temp0000292596 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 26 12 3 1m25s 28s382ms [ User: intelifix - Total duration: 1m25s - Times executed: 3 ]
[ Application: [unknown] - Total duration: 1m25s - Times executed: 3 ]
-
CREATE TABLE temp0000292596 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-26 12:51:52 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292596 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-26 12:53:05 Duration: 11s457ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292596 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-26 12:52:23 Duration: 11s445ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 361ms 53s343ms 26s833ms 4 1m47s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 26 20 2 53s619ms 26s809ms 23 2 53s712ms 26s856ms [ User: intelifix - Total duration: 1m47s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m47s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-26 23:13:47 Duration: 53s343ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-26 20:05:45 Duration: 53s258ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-26 23:33:38 Duration: 369ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
9 3s188ms 40s110ms 17s925ms 6 1m47s copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 26 20 3 53s888ms 17s962ms 23 3 53s666ms 17s888ms [ User: intelifix - Total duration: 1m47s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m47s - 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-09-26 20:06:28 Duration: 40s110ms 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-09-26 23:14:29 Duration: 39s646ms 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-09-26 20:10:19 Duration: 10s588ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 2s322ms 31s796ms 13s935ms 6 1m23s copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 26 20 3 41s753ms 13s917ms 23 3 41s857ms 13s952ms [ User: intelifix - Total duration: 1m23s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m23s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-09-26 23:15:04 Duration: 31s796ms 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-09-26 20:07:02 Duration: 31s669ms 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-09-26 20:10:27 Duration: 7s761ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 4s263ms 23s786ms 13s921ms 4 55s687ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 26 20 2 27s620ms 13s810ms 23 2 28s67ms 14s33ms [ User: intelifix - Total duration: 55s687ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 55s687ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-09-26 23:12:53 Duration: 23s786ms 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-09-26 20:04:52 Duration: 23s357ms 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-09-26 23:33:37 Duration: 4s281ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 3s83ms 31s792ms 13s758ms 6 1m22s copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 26 20 3 41s202ms 13s734ms 23 3 41s346ms 13s782ms [ User: intelifix - Total duration: 1m22s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m22s - 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-09-26 23:17:17 Duration: 31s792ms 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-09-26 20:09:15 Duration: 31s637ms 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-09-26 23:34:20 Duration: 6s470ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 2s472ms 23s681ms 11s951ms 6 1m11s copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 26 20 3 35s878ms 11s959ms 23 3 35s833ms 11s944ms [ User: intelifix - Total duration: 1m11s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m11s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-26 20:02:48 Duration: 23s681ms 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-09-26 23:10:49 Duration: 23s616ms 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-09-26 23:33:06 Duration: 9s744ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 2s257ms 24s201ms 11s907ms 6 1m11s copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 26 20 3 35s818ms 11s939ms 23 3 35s626ms 11s875ms [ User: intelifix - Total duration: 1m11s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m11s - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-26 20:03:30 Duration: 24s201ms 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-09-26 23:11:30 Duration: 24s151ms 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-09-26 20:09:48 Duration: 9s359ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 1s847ms 25s347ms 10s773ms 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 #15
Day Hour Count Duration Avg duration Sep 26 20 3 31s848ms 10s616ms 23 3 32s790ms 10s930ms [ 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-09-26 23:12:29 Duration: 25s347ms 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-09-26 20:04:28 Duration: 25s68ms 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-09-26 23:33:33 Duration: 5s479ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 2s456ms 20s228ms 9s72ms 6 54s435ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 26 00 3 27s371ms 9s123ms 06 3 27s63ms 9s21ms [ User: lenon - Total duration: 54s435ms - Times executed: 6 ]
[ Application: psql - Total duration: 54s435ms - Times executed: 6 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-09-26 00:02:23 Duration: 20s228ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-09-26 06:02:21 Duration: 19s423ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-09-26 00:02:28 Duration: 4s686ms Database: brasilia User: lenon Remote: [local] Application: psql
17 1s857ms 16s932ms 8s600ms 6 51s604ms 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 Sep 26 20 3 25s623ms 8s541ms 23 3 25s980ms 8s660ms [ User: intelifix - Total duration: 51s604ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 51s604ms - 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-09-26 23:11:47 Duration: 16s932ms 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-09-26 20:03:46 Duration: 16s548ms 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-09-26 20:09:56 Duration: 7s218ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 153ms 9s668ms 3s235ms 144 7m45s call rs_giga_triagem (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 26 00 7 27s278ms 3s896ms 01 6 18s555ms 3s92ms 02 6 19s375ms 3s229ms 03 6 19s472ms 3s245ms 04 6 18s305ms 3s50ms 05 7 19s158ms 2s736ms 06 6 18s935ms 3s155ms 07 6 18s726ms 3s121ms 08 6 18s966ms 3s161ms 09 6 18s726ms 3s121ms 10 6 18s957ms 3s159ms 11 6 18s904ms 3s150ms 12 6 19s333ms 3s222ms 13 8 24s87ms 3s10ms 14 6 19s579ms 3s263ms 15 6 19s354ms 3s225ms 16 6 18s889ms 3s148ms 17 6 19s463ms 3s243ms 18 6 18s834ms 3s139ms 19 6 18s916ms 3s152ms 20 8 31s732ms 3s966ms 21 6 21s176ms 3s529ms 22 6 19s131ms 3s188ms [ User: intelifix - Total duration: 7m45s - Times executed: 144 ]
[ Application: psql - Total duration: 7m45s - Times executed: 144 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-26 00:05:31 Duration: 9s668ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-26 20:05:11 Duration: 9s289ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-26 20:15:09 Duration: 7s888ms Database: rio User: intelifix Remote: [local] Application: psql
19 150ms 20s170ms 3s21ms 34 1m42s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 26 00 6 33s643ms 5s607ms 01 6 15s585ms 2s597ms 02 6 14s339ms 2s389ms 03 5 15s496ms 3s99ms 04 6 20s851ms 3s475ms 05 2 1s540ms 770ms 13 1 423ms 423ms 20 2 853ms 426ms [ User: intelifix - Total duration: 1m42s - Times executed: 34 ]
[ Application: psql - Total duration: 1m42s - Times executed: 34 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-26 00:05:21 Duration: 20s170ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-26 03:15:08 Duration: 7s25ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-26 04:55:07 Duration: 6s139ms Database: rio User: intelifix Remote: [local] Application: psql
20 563ms 4s973ms 890ms 56 49s871ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 26 08 5 8s544ms 1s708ms 09 3 2s354ms 784ms 10 3 2s110ms 703ms 11 3 2s269ms 756ms 12 4 4s5ms 1s1ms 13 3 2s148ms 716ms 14 3 2s252ms 750ms 15 3 2s296ms 765ms 16 4 3s370ms 842ms 17 4 3s58ms 764ms 18 5 3s922ms 784ms 19 4 3s192ms 798ms 20 4 3s929ms 982ms 21 4 3s192ms 798ms 22 4 3s222ms 805ms [ User: intelifix - Total duration: 49s871ms - Times executed: 56 ]
[ Application: psql - Total duration: 49s871ms - Times executed: 56 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-26 08:00:06 Duration: 4s973ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-26 12:20:04 Duration: 1s823ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-26 20:20:03 Duration: 1s625ms 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 9 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Sep 26 08 1 0ms 0ms 09 1 0ms 0ms 13 2 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 19 1 0ms 0ms 21 2 0ms 0ms [ User: intelifix - Total duration: 1m9s - Times executed: 8 ]
[ User: etiquetas - Total duration: 276ms - Times executed: 1 ]
[ Application: psql - Total duration: 1m9s - Times executed: 8 ]
[ Application: [unknown] - Total duration: 276ms - Times executed: 1 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 5,684 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 26 FATAL entries
- 1651 ERROR entries
- 0 WARNING entries
- 1 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 1,645 Max number of times the same event was reported
- 1,678 Total events found
Rank Times reported Error 1 1,645 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Sep 26 00 59 01 60 02 60 03 54 04 59 05 60 06 59 07 60 08 117 09 83 10 120 11 81 12 60 13 74 14 103 15 71 16 60 17 59 18 60 19 60 20 58 21 59 22 59 23 50 - ERROR: prepared statement "_PLAN0000000029AE5570" does not exist
- ERROR: prepared statement "_PLAN0000000029AE5570" does not exist
- ERROR: prepared statement "_PLAN0000000029AE5570" does not exist
Statement: DEALLOCATE "_PLAN0000000029AE5570"
Date: 2026-09-26 00:00:58 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029AE5570"
Date: 2026-09-26 00:01:59 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029AE5570"
Date: 2026-09-26 00:02:59 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 13 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Sep 26 00 1 06 2 07 2 08 1 10 2 11 3 13 1 23 1 - FATAL: database "testes" does not exist
- FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-09-26 00:02:30 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-09-26 06:02:29 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-09-26 06:42:33 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
3 9 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #3
Day Hour Count Sep 26 03 9 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-09-26 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-09-26 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-09-26 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
4 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Sep 26 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-09-26 05:32:04 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-26 05:32:04 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-26 05:32:04 Database: contagem Application: psql User: intelifix Remote: [local]
5 4 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #5
Day Hour Count Sep 26 03 4 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-09-26 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-26 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-09-26 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
6 2 ERROR: prepared statement "..." does not exist/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(
Times Reported Most Frequent Error / Event #6
Day Hour Count Sep 26 20 1 21 1 - ERROR: prepared statement "_PLAN0000000029DEA8F0" does not exist/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(
- ERROR: prepared statement "_PLAN0000000029AE5A00" does not exist/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(
Statement: DEALLOCATE "_PLAN0000000029DEA8F0"
Date: 2026-09-26 20:59:19 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029AE5A00"
Date: 2026-09-26 21:19:26 Database: rio Application: [unknown] User: etiquetas Remote: [local]
7 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #7
Day Hour Count Sep 26 03 1 - LOG: database system was shut down at 2026-09-26 03:05:01 -03
Date: 2026-09-26 03:05:02