pgBadger-
Global information
- Generated on Sun Oct 11 23:50:10 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 4,431 log entries in 8s
- Log start from 2026-10-11 00:02:02 to 2026-10-11 23:43:06
-
Overview
Global Stats
- 157 Number of unique normalized queries
- 982 Number of queries
- 3h55m11s Total query duration
- 2026-10-11 00:02:07 First query
- 2026-10-11 23:43:06 Last query
- 5 queries/s at 2026-10-11 23:43:01 Query peak
- 3h55m11s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 3h55m11s Execute total duration
- 22 Number of events
- 6 Number of unique normalized events
- 8 Max number of times the same event was reported
- 0 Number of cancellation
- 11 Total number of automatic vacuums
- 15 Total number of automatic analyzes
- 20 Number temporary file
- 250.15 MiB Max size of temporary file
- 68.07 MiB Average size of temporary file
- 166 Total number of sessions
- 7 sessions at 2026-10-11 06:42:38 Session peak
- 6d8h11m58s Total duration of sessions
- 55m Average duration of sessions
- 5 Average queries per session
- 1m25s Average queries duration per session
- 53m35s Average idle time per session
- 180 Total number of connections
- 4 connections/s at 2026-10-11 00:05:01 Connection peak
- 4 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-10-11 23:43:01 Date
SELECT Traffic
Key values
- 3 queries/s Query Peak
- 2026-10-11 07:16:33 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-10-11 23:43:01 Date
Queries duration
Key values
- 3h55m11s 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) Oct 11 00 22 0ms 18s968ms 4s181ms 1m3s 1m3s 1m3s 01 12 0ms 4s51ms 2s33ms 4s266ms 4s266ms 4s266ms 02 12 0ms 3s854ms 2s7ms 4s130ms 4s130ms 4s130ms 03 10 0ms 4s8ms 2s6ms 4s297ms 4s297ms 4s297ms 04 12 0ms 3s744ms 1s945ms 3s998ms 3s998ms 3s998ms 05 17 0ms 10m12s 1m20s 7m10s 10m12s 10m12s 06 19 0ms 11s933ms 2s972ms 7s190ms 30s877ms 30s877ms 07 40 0ms 8m34s 25s447ms 2m16s 3m51s 8m34s 08 60 0ms 5m1s 10s866ms 36s882ms 3m21s 5m46s 09 29 0ms 5m5s 20s168ms 3m24s 5m48s 5m48s 10 24 0ms 5m 23s642ms 3m14s 5m43s 5m43s 11 25 0ms 5m1s 22s770ms 3m18s 5m43s 5m43s 12 24 190ms 5m2s 24s38ms 3m22s 5m46s 5m46s 13 24 0ms 5m7s 24s262ms 3m22s 5m51s 5m51s 14 30 0ms 5m1s 19s247ms 3m21s 5m45s 5m45s 15 24 0ms 5m9s 24s612ms 3m29s 5m53s 5m53s 16 24 0ms 4m58s 23s894ms 3m22s 5m42s 5m42s 17 24 0ms 5m1s 23s931ms 3m21s 5m44s 5m44s 18 27 0ms 5m2s 21s411ms 3m21s 5m45s 5m45s 19 24 189ms 5m2s 23s960ms 3m21s 5m45s 5m45s 20 112 0ms 6m44s 11s796ms 1m17s 3m36s 7m5s 21 26 0ms 5m48s 23s770ms 3m18s 5m48s 5m48s 22 24 0ms 5m3s 24s52ms 3m22s 5m46s 5m46s 23 337 0ms 1m2s 5s854ms 1m5s 1m6s 1m15s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 11 00 4 0 2s89ms 0ms 8s356ms 8s356ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 4 0 1s797ms 0ms 0ms 7s190ms 07 16 0 59s537ms 13s360ms 2m12s 8m34s 08 25 0 22s505ms 727ms 4s422ms 5m46s 09 11 0 50s446ms 963ms 3m24s 5m48s 10 6 0 1m30s 2s609ms 3m14s 5m43s 11 7 0 1m17s 153ms 3m18s 5m43s 12 6 0 1m31s 0ms 3m22s 5m46s 13 6 0 1m32s 0ms 3m22s 5m51s 14 12 0 45s842ms 670ms 3m21s 5m45s 15 6 0 1m33s 0ms 3m29s 5m53s 16 6 0 1m30s 0ms 3m22s 5m42s 17 6 0 1m31s 0ms 3m21s 5m44s 18 9 0 1m1s 2s815ms 3m21s 5m45s 19 6 0 1m31s 0ms 3m21s 5m45s 20 13 79 13s705ms 1m6s 1m11s 6m44s 21 8 0 1m13s 42s822ms 3m18s 5m48s 22 6 0 1m31s 0ms 3m22s 5m46s 23 16 321 5s854ms 1m3s 1m5s 1m13s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 11 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 Oct 11 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 1 1.00 0.00% 08 0 3 3.00 0.00% 09 0 2 2.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 2 2.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Oct 11 00 15 0.00/s 01 6 0.00/s 02 5 0.00/s 03 10 0.00/s 04 6 0.00/s 05 7 0.00/s 06 14 0.00/s 07 8 0.00/s 08 8 0.00/s 09 6 0.00/s 10 8 0.00/s 11 7 0.00/s 12 6 0.00/s 13 8 0.00/s 14 8 0.00/s 15 5 0.00/s 16 6 0.00/s 17 6 0.00/s 18 5 0.00/s 19 6 0.00/s 20 8 0.00/s 21 6 0.00/s 22 7 0.00/s 23 9 0.00/s Day Hour Count Average Duration Average idle time Oct 11 00 1 10m 8m28s 01 14 1h2m19s 1h2m17s 02 6 1h 59m56s 03 7 33m19s 33m17s 04 6 1h1m 1h56s 05 5 1h 55m28s 06 7 56m34s 56m26s 07 13 1h18s 59m 08 9 54m46s 53m34s 09 7 1h1m9s 59m46s 10 6 51m40s 50m5s 11 6 1h19s 58m44s 12 7 1h43s 59m21s 13 6 51m40s 50m3s 14 7 1h1m8s 59m46s 15 7 56m51s 55m27s 16 5 1h59s 59m5s 17 6 1h50s 59m15s 18 5 1h36s 58m40s 19 5 1h1m2s 59m7s 20 9 42m7s 39m40s 21 5 1h24s 58m20s 22 5 1h 58m4s 23 12 33m 30m16s -
Connections
Established Connections
Key values
- 4 connections Connection Peak
- 2026-10-11 00:05:01 Date
Connections per database
Key values
- rio Main Database
- 180 connections Total
Connections per user
Key values
- intelifix Main User
- 180 connections Total
-
Sessions
Simultaneous sessions
Key values
- 7 sessions Session Peak
- 2026-10-11 06:42:38 Date
Histogram of session times
Key values
- 143 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 166 sessions Total
Sessions per user
Key values
- intelifix Main User
- 166 sessions Total
Sessions per host
Key values
- [local] Main Host
- 166 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 10,666 buffers Checkpoint Peak
- 2026-10-11 00:09:50 Date
- 270.034 seconds Highest write time
- 0.069 seconds Sync time
Checkpoints Wal files
Key values
- 4 files Wal files usage Peak
- 2026-10-11 03:05:02 Date
Checkpoints distance
Key values
- 107.56 Mo Distance Peak
- 2026-10-11 03:05:02 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Oct 11 00 10,666 270.034s 0.002s 270.039s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 8,916 0.179s 0.07s 0.256s 04 0 0s 0s 0s 05 7,403 745.795s 0.033s 745.855s 06 4,359 269.823s 0.001s 269.828s 07 2,286 229.237s 0.015s 229.266s 08 943 103.067s 0.013s 103.097s 09 40 4.045s 0.008s 4.065s 10 24 2.42s 0.004s 2.428s 11 25 2.519s 0.004s 2.527s 12 26 2.621s 0.004s 2.629s 13 26 2.619s 0.003s 2.628s 14 34 3.43s 0.006s 3.442s 15 25 2.521s 0.004s 2.531s 16 25 2.52s 0.004s 2.529s 17 24 2.42s 0.004s 2.429s 18 1,040 103.967s 0.008s 103.983s 19 25 2.52s 0.004s 2.528s 20 56 5.633s 0.005s 5.646s 21 60 6.042s 0.006s 6.059s 22 25 2.52s 0.004s 2.529s 23 58 5.824s 0.002s 5.831s Day Hour Added Removed Recycled Synced files Longest sync Average sync Oct 11 00 0 0 2 35 0.002s 0.001s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 4 27 0.065s 0.004s 04 0 0 0 0 0s 0s 05 0 0 3 175 0.012s 0.008s 06 0 0 1 11 0.001s 0.001s 07 0 0 1 272 0.002s 0.006s 08 0 0 0 416 0.002s 0.006s 09 0 0 0 19 0.002s 0.005s 10 0 0 0 5 0.002s 0.002s 11 0 0 0 5 0.001s 0.002s 12 0 0 0 5 0.002s 0.002s 13 0 0 0 5 0.002s 0.002s 14 0 0 0 16 0.001s 0.003s 15 0 0 0 5 0.001s 0.002s 16 0 0 0 5 0.001s 0.002s 17 0 0 0 5 0.002s 0.002s 18 0 0 0 77 0.002s 0.004s 19 0 0 0 5 0.001s 0.002s 20 0 0 1 22 0.001s 0.003s 21 0 0 0 14 0.002s 0.004s 22 0 0 0 5 0.002s 0.002s 23 0 0 0 12 0.001s 0.002s Day Hour Count Avg time (sec) Oct 11 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 Oct 11 00 42,290.00 kB 42,290.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 27,536.50 kB 27,536.50 kB 04 0.00 kB 0.00 kB 05 7,960.86 kB 11,160.14 kB 06 9,723.00 kB 12,042.00 kB 07 2,515.17 kB 9,288.50 kB 08 1,687.00 kB 5,887.33 kB 09 45.20 kB 3,498.60 kB 10 96.00 kB 2,413.00 kB 11 96.00 kB 1,973.00 kB 12 95.50 kB 1,616.50 kB 13 95.50 kB 1,326.00 kB 14 72.33 kB 1,043.33 kB 15 95.50 kB 816.00 kB 16 96.00 kB 682.00 kB 17 96.00 kB 570.50 kB 18 901.50 kB 2,801.00 kB 19 96.00 kB 2,063.00 kB 20 383.33 kB 1,664.33 kB 21 78.75 kB 1,210.50 kB 22 96.00 kB 895.00 kB 23 84.00 kB 741.00 kB -
Temporary Files
Size of temporary files
Key values
- 500.30 MiB Temp Files size Peak
- 2026-10-11 05:31:55 Date
Number of temporary files
Key values
- 4 per second Temp Files Peak
- 2026-10-11 05:32:01 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Oct 11 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 20 1.33 GiB 68.07 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.03 GiB 37.31 MiB 250.15 MiB 65.66 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-11 05:32:03 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-11 05:31:55 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 4 310.75 MiB 57.75 MiB 95.05 MiB 77.69 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-11 05:30:40 Duration: 38s674ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-11 05:30:37 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 250.15 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-11 05:31:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 250.15 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-11 05:31:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 95.05 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-11 05:30:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 95.05 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-11 05:30:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 62.91 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-11 05:30:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 57.75 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-11 05:30:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 41.35 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-11 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 41.29 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-11 05:31:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 41.29 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-11 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 41.28 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-11 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 41.28 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-11 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 41.28 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-11 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 41.28 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-11 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 37.37 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-11 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 37.31 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-11 05:31:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 37.31 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-11 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 37.31 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-11 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 37.31 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-11 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 37.31 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-11 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 37.31 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-11 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.26 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database brasilia - 2026-10-11 05:17:54 Date
- 0 sec Highest CPU-cost analyze
Table
Database brasilia - Date
Average Autovacuum Duration
Key values
- 0.26 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database brasilia - 2026-10-11 05:17:54 Date
Analyzes per table
Key values
- public.temp0000293942 (6) Main table analyzed (database rio)
- 15 analyzes Total
Vacuums per table
Key values
- pg_toast.pg_toast_2619 (1) Main table vacuumed on database contagem
- 11 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 139 35 95,589 14 31 rio.public.temp0000292754 1 0 0 0 0 0 0 4 3 774 0 0 brasilia.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 179 46 164,894 25 61 rio.public.temp0000293714 1 0 0 0 0 0 0 4 3 774 0 0 brasilia.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,799 524 2,233,250 490 3,396 rio.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 880 253 1,085,475 141 514 rio.pg_catalog.pg_attribute 1 1 0 0 0 0 0 470 169 251,733 1 27 rio.pg_catalog.pg_type 1 1 0 0 0 0 0 83 35 55,105 0 0 rio.public.temp0000293942 1 0 0 0 0 0 0 66 4 4,497 0 0 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,279 854 2,673,150 822 5,865 rio.pg_catalog.pg_statistic 1 1 0 0 0 0 0 3,361 1,207 4,167,482 1,153 6,880 Total 11 8 0 0 0 0 0 10,264 3,133 10,732,723 2,646 16,774 Vacuum throughput per table
Key values
- pg_catalog.pg_statistic (0.26) 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 contagem.pg_toast.pg_toast_2619 0 0 0 rio.public.temp0000292754 0 0 0 brasilia.pg_toast.pg_toast_2619 0 0 0 rio.public.temp0000293714 0 0 0 brasilia.pg_catalog.pg_statistic 0 0 0.26 rio.pg_toast.pg_toast_2619 0 0 0.05 rio.pg_catalog.pg_attribute 0 0 0.14 rio.pg_catalog.pg_type 0 0 0.07 rio.public.temp0000293942 0 0 0 contagem.pg_catalog.pg_statistic 0 0 0.08 rio.pg_catalog.pg_statistic 0 0 0.25 Total 0 0 0.85 Tuples removed per table
Key values
- pg_catalog.pg_statistic (4582) Main table with removed tuples on database rio
- 15674 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_statistic 1 1 4,582 7,464 0 0 1,286 contagem.pg_catalog.pg_statistic 1 1 4,256 7,274 0 0 1,011 brasilia.pg_catalog.pg_statistic 1 1 3,899 7,360 0 0 1,071 rio.pg_catalog.pg_attribute 1 1 1,950 21,780 146 0 559 rio.pg_toast.pg_toast_2619 1 1 670 673 0 57 223 brasilia.pg_toast.pg_toast_2619 1 1 129 148 0 14 58 contagem.pg_toast.pg_toast_2619 1 1 99 112 0 11 48 rio.pg_catalog.pg_type 1 1 89 2,233 26 0 73 rio.public.temp0000292754 1 0 0 1,007 0 0 64 rio.public.temp0000293714 1 0 0 1,007 0 0 64 rio.public.temp0000293942 1 0 0 1,007 0 0 64 Total 11 8 15,674 50,065 172 82 4,521 Pages removed per table
Key values
- pg_toast.pg_toast_2619 (57) Main table with removed pages on database rio
- 82 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.pg_toast.pg_toast_2619 1 1 670 57 brasilia.pg_toast.pg_toast_2619 1 1 129 14 contagem.pg_toast.pg_toast_2619 1 1 99 11 rio.public.temp0000292754 1 0 0 0 rio.public.temp0000293714 1 0 0 0 brasilia.pg_catalog.pg_statistic 1 1 3899 0 rio.pg_catalog.pg_attribute 1 1 1950 0 rio.pg_catalog.pg_type 1 1 89 0 rio.public.temp0000293942 1 0 0 0 contagem.pg_catalog.pg_statistic 1 1 4256 0 rio.pg_catalog.pg_statistic 1 1 4582 0 Total 11 8 15,674 82 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Oct 11 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 6 0 06 0 0 07 1 4 08 4 11 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 - 0.26 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
- 173 Total read queries
- 428 Total write queries
Queries by database
Key values
- rio Main database
- 447 Requests
- 2h31m33s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 966 Requests
User Request type Count Duration intelifix Total 966 3h54m53s copy to 400 41m58s ddl 28 1m39s others 381 34m23s select 157 2h36m51s lenon Total 16 18s71ms select 16 18s71ms Duration by user
Key values
- 3h54m53s (intelifix) Main time consuming user
User Request type Count Duration intelifix Total 966 3h54m53s copy to 400 41m58s ddl 28 1m39s others 381 34m23s select 157 2h36m51s lenon Total 16 18s71ms select 16 18s71ms Queries by host
Key values
- [local] Main host
- 982 Requests
- 3h55m11s ([local])
- Main time consuming host
Queries by application
Key values
- psql Main application
- 490 Requests
- 3h9m51s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-10-11 23:18:50 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 364 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 10m12s analyze verbose;[ Date: 2026-10-11 05:10:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 8m34s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-11 07:13:36 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 7m10s analyze verbose;[ Date: 2026-10-11 05:17:24 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
4 6m44s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-11 20:11:45 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 5m48s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-11 21:10:49 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 5m9s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-11 15:10:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 5m7s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-11 13:10:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 5m5s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-11 09:10:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 5m3s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-11 22:10:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 5m2s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-11 12:10:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 5m2s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-11 18:10:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m2s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-11 19:10:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 5m1s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-11 08:10:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m1s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-11 17:10:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m1s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-11 14:10:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m1s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-11 11:10:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-11 10:10:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 4m58s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-11 16:10:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 3m41s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-10-11 07:19:30 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
20 3m28s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-10-11 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 1h31m58s 48 2s319ms 8m34s 1m54s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 11 07 3 9m18s 3m6s 08 3 5m19s 1m46s 09 3 5m22s 1m47s 10 3 5m17s 1m45s 11 3 5m18s 1m46s 12 3 5m19s 1m46s 13 3 5m25s 1m48s 14 3 5m18s 1m46s 15 3 5m26s 1m48s 16 3 5m15s 1m45s 17 3 5m18s 1m46s 18 3 5m19s 1m46s 19 3 5m19s 1m46s 20 3 7m12s 2m24s 21 3 6m5s 2m1s 22 3 5m20s 1m46s [ User: intelifix - Total duration: 1h31m58s - Times executed: 48 ]
[ Application: psql - Total duration: 1h31m58s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-11 07:13:36 Duration: 8m34s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-11 20:11:45 Duration: 6m44s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-11 21:10:49 Duration: 5m48s Database: rio User: intelifix Remote: [local] Application: psql
2 1h3m11s 48 245ms 3m41s 1m18s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 11 07 3 5m20s 1m46s 08 3 3m46s 1m15s 09 3 3m50s 1m16s 10 3 3m42s 1m14s 11 3 3m43s 1m14s 12 3 3m49s 1m16s 13 3 3m48s 1m16s 14 3 3m47s 1m15s 15 3 3m55s 1m18s 16 3 3m49s 1m16s 17 3 3m48s 1m16s 18 3 3m48s 1m16s 19 3 3m48s 1m16s 20 3 4m37s 1m32s 21 3 3m44s 1m14s 22 3 3m48s 1m16s [ User: intelifix - Total duration: 1h3m11s - Times executed: 48 ]
[ Application: psql - Total duration: 1h3m11s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-11 07:19:30 Duration: 3m41s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-11 20:16:43 Duration: 3m28s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-11 15:14:21 Duration: 3m26s Database: brasilia User: intelifix Remote: [local] Application: psql
3 20m13s 3 2m50s 10m12s 6m44s analyze verbose;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 11 05 3 20m13s 6m44s [ User: intelifix - Total duration: 20m13s - Times executed: 3 ]
[ Application: psql - Total duration: 20m13s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-10-11 05:10:14 Duration: 10m12s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-11 05:17:24 Duration: 7m10s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-11 05:20:15 Duration: 2m50s Database: contagem User: intelifix Remote: [local] Application: psql
4 9m38s 252 179ms 18s968ms 2s295ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 11 00 12 43s100ms 3s591ms 01 12 24s396ms 2s33ms 02 12 24s86ms 2s7ms 03 10 20s65ms 2s6ms 04 12 23s345ms 1s945ms 05 12 26s31ms 2s169ms 06 12 22s469ms 1s872ms 07 11 21s980ms 1s998ms 08 12 24s317ms 2s26ms 09 11 24s221ms 2s201ms 10 10 22s151ms 2s215ms 11 11 22s255ms 2s23ms 12 10 22s579ms 2s257ms 13 11 22s948ms 2s86ms 14 12 22s958ms 1s913ms 15 10 22s799ms 2s279ms 16 10 23s131ms 2s313ms 17 11 22s331ms 2s30ms 18 10 22s389ms 2s238ms 19 10 22s442ms 2s244ms 20 10 53s425ms 5s342ms 21 10 22s201ms 2s220ms 22 11 22s915ms 2s83ms [ User: intelifix - Total duration: 9m38s - Times executed: 252 ]
[ Application: psql - Total duration: 9m38s - Times executed: 252 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-11 00:05:20 Duration: 18s968ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-11 20:05:20 Duration: 18s512ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-11 20:15:16 Duration: 14s714ms Database: rio User: intelifix Remote: [local] Application: psql
5 2m15s 4 4s220ms 1m3s 33s766ms 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 Oct 11 20 2 1m7s 33s805ms 23 2 1m7s 33s726ms [ User: intelifix - Total duration: 2m15s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m15s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-11 20:08:41 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-10-11 23:16:40 Duration: 1m2s 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-10-11 23:34:04 Duration: 4s656ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 1m48s 6 3s229ms 40s586ms 18s140ms 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 #6
Day Hour Count Duration Avg duration Oct 11 20 3 54s287ms 18s95ms 23 3 54s553ms 18s184ms [ User: intelifix - Total duration: 1m48s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m48s - 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-10-11 23:14:27 Duration: 40s586ms 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-10-11 20:06:27 Duration: 40s420ms 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-10-11 23:33:39 Duration: 10s694ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 1m47s 4 368ms 53s397ms 26s813ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 11 20 2 53s816ms 26s908ms 23 2 53s435ms 26s717ms [ 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-10-11 20:05:45 Duration: 53s397ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-11 23:13:45 Duration: 53s67ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-11 20:10:05 Duration: 418ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 1m23s 6 2s307ms 31s653ms 13s936ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 11 20 3 41s810ms 13s936ms 23 3 41s807ms 13s935ms [ 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-10-11 23:15:02 Duration: 31s653ms 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-10-11 20:07:02 Duration: 31s647ms 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-10-11 20:10:24 Duration: 7s855ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
9 1m22s 6 3s18ms 31s978ms 13s813ms 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 #9
Day Hour Count Duration Avg duration Oct 11 20 3 41s539ms 13s846ms 23 3 41s344ms 13s781ms [ 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-10-11 20:09:13 Duration: 31s978ms 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-10-11 23:17:12 Duration: 31s815ms 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-10-11 20:10:46 Duration: 6s521ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 1m22s 1 1m22s 1m22s 1m22s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 11 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-10-11 05:32:03 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-11 05:31:55 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
11 1m11s 6 2s521ms 23s575ms 11s953ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 11 20 3 35s844ms 11s948ms 23 3 35s874ms 11s958ms [ 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-10-11 23:10:48 Duration: 23s575ms 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-10-11 20:02:47 Duration: 23s558ms 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-10-11 20:09:33 Duration: 9s764ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 1m11s 6 2s254ms 24s382ms 11s922ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 11 20 3 35s922ms 11s974ms 23 3 35s613ms 11s871ms [ 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-10-11 20:03:29 Duration: 24s382ms 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-10-11 23:11:29 Duration: 24s155ms 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-10-11 23:33:08 Duration: 9s203ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 1m5s 6 5s695ms 15s732ms 10s979ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 11 00 3 39s65ms 13s21ms 06 3 26s812ms 8s937ms [ User: intelifix - Total duration: 1m5s - Times executed: 6 ]
[ Application: psql - Total duration: 1m5s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-10-11 00:05:30 Duration: 15s732ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-10-11 00:05:14 Duration: 13s194ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-10-11 06:05:22 Duration: 11s933ms Database: brasilia User: intelifix Remote: [local] Application: psql
14 1m4s 6 1s709ms 25s519ms 10s803ms copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 11 20 3 32s308ms 10s769ms 23 3 32s512ms 10s837ms [ 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-10-11 20:04:28 Duration: 25s519ms 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-10-11 23:12:28 Duration: 25s255ms 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-10-11 23:33:23 Duration: 5s546ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 56s134ms 4 4s289ms 23s715ms 14s33ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 11 20 2 28s4ms 14s2ms 23 2 28s130ms 14s65ms [ User: intelifix - Total duration: 56s134ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 56s134ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-10-11 20:04:52 Duration: 23s715ms 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-10-11 23:12:52 Duration: 23s669ms 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-10-11 23:33:28 Duration: 4s460ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 54s907ms 1 54s907ms 54s907ms 54s907ms select * from rs_resumo_lote_entrada (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 11 07 1 54s907ms 54s907ms [ User: intelifix - Total duration: 54s907ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 54s907ms - Times executed: 1 ]
-
SELECT * FROM RS_RESUMO_LOTE_ENTRADA (00, 06, ' ', '2026-10-01', '2026-10-11', 00, 00);
Date: 2026-10-11 07:30:44 Duration: 54s907ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 51s765ms 6 1s836ms 16s899ms 8s627ms 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 Oct 11 20 3 25s953ms 8s651ms 23 3 25s812ms 8s604ms [ User: intelifix - Total duration: 51s765ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 51s765ms - 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-10-11 23:11:46 Duration: 16s899ms 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-10-11 20:03:46 Duration: 16s828ms 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-10-11 20:09:52 Duration: 7s262ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 41s467ms 6 1s83ms 17s13ms 6s911ms copy public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 11 20 3 20s705ms 6s901ms 23 3 20s761ms 6s920ms [ User: intelifix - Total duration: 41s467ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 41s467ms - Times executed: 6 ]
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-10-11 23:11:05 Duration: 17s13ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-10-11 20:03:04 Duration: 17s8ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-10-11 23:32:59 Duration: 2s661ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 40s375ms 52 300ms 1s217ms 776ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 11 08 4 2s821ms 705ms 09 4 3s582ms 895ms 10 4 3s42ms 760ms 11 4 2s873ms 718ms 12 4 3s218ms 804ms 13 3 2s340ms 780ms 14 3 2s199ms 733ms 15 3 2s350ms 783ms 16 3 2s119ms 706ms 17 3 2s459ms 819ms 18 4 3s141ms 785ms 19 3 2s208ms 736ms 20 3 2s529ms 843ms 21 3 2s207ms 735ms 22 4 3s280ms 820ms [ User: intelifix - Total duration: 40s375ms - Times executed: 52 ]
[ Application: psql - Total duration: 40s375ms - Times executed: 52 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-11 09:00:03 Duration: 1s217ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-11 08:00:06 Duration: 1s31ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-11 22:20:03 Duration: 959ms Database: brasilia User: intelifix Remote: [local] Application: psql
20 38s806ms 4 182ms 35s138ms 9s701ms create table temp0000293930 as select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 11 08 4 38s806ms 9s701ms [ User: intelifix - Total duration: 38s806ms - Times executed: 4 ]
[ Application: [unknown] - Total duration: 38s806ms - Times executed: 4 ]
-
CREATE TABLE temp0000293930 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "6", "cliente" : "0", "nf" : "", "data-de" : "06-10-2026", "data-ate" : "11-10-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-10-11 08:44:42 Duration: 35s138ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293930 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "6", "cliente" : "0", "nf" : "", "data-de" : "06-10-2026", "data-ate" : "11-10-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-10-11 08:44:44 Duration: 1s743ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293930 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "6", "cliente" : "0", "nf" : "", "data-de" : "06-10-2026", "data-ate" : "11-10-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-10-11 08:45:44 Duration: 1s741ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 252 9m38s 179ms 18s968ms 2s295ms call rs_giga_triagem (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 11 00 12 43s100ms 3s591ms 01 12 24s396ms 2s33ms 02 12 24s86ms 2s7ms 03 10 20s65ms 2s6ms 04 12 23s345ms 1s945ms 05 12 26s31ms 2s169ms 06 12 22s469ms 1s872ms 07 11 21s980ms 1s998ms 08 12 24s317ms 2s26ms 09 11 24s221ms 2s201ms 10 10 22s151ms 2s215ms 11 11 22s255ms 2s23ms 12 10 22s579ms 2s257ms 13 11 22s948ms 2s86ms 14 12 22s958ms 1s913ms 15 10 22s799ms 2s279ms 16 10 23s131ms 2s313ms 17 11 22s331ms 2s30ms 18 10 22s389ms 2s238ms 19 10 22s442ms 2s244ms 20 10 53s425ms 5s342ms 21 10 22s201ms 2s220ms 22 11 22s915ms 2s83ms [ User: intelifix - Total duration: 9m38s - Times executed: 252 ]
[ Application: psql - Total duration: 9m38s - Times executed: 252 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-11 00:05:20 Duration: 18s968ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-11 20:05:20 Duration: 18s512ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-11 20:15:16 Duration: 14s714ms Database: rio User: intelifix Remote: [local] Application: psql
2 52 40s375ms 300ms 1s217ms 776ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 11 08 4 2s821ms 705ms 09 4 3s582ms 895ms 10 4 3s42ms 760ms 11 4 2s873ms 718ms 12 4 3s218ms 804ms 13 3 2s340ms 780ms 14 3 2s199ms 733ms 15 3 2s350ms 783ms 16 3 2s119ms 706ms 17 3 2s459ms 819ms 18 4 3s141ms 785ms 19 3 2s208ms 736ms 20 3 2s529ms 843ms 21 3 2s207ms 735ms 22 4 3s280ms 820ms [ User: intelifix - Total duration: 40s375ms - Times executed: 52 ]
[ Application: psql - Total duration: 40s375ms - Times executed: 52 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-11 09:00:03 Duration: 1s217ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-11 08:00:06 Duration: 1s31ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-11 22:20:03 Duration: 959ms Database: brasilia User: intelifix Remote: [local] Application: psql
3 48 1h31m58s 2s319ms 8m34s 1m54s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 11 07 3 9m18s 3m6s 08 3 5m19s 1m46s 09 3 5m22s 1m47s 10 3 5m17s 1m45s 11 3 5m18s 1m46s 12 3 5m19s 1m46s 13 3 5m25s 1m48s 14 3 5m18s 1m46s 15 3 5m26s 1m48s 16 3 5m15s 1m45s 17 3 5m18s 1m46s 18 3 5m19s 1m46s 19 3 5m19s 1m46s 20 3 7m12s 2m24s 21 3 6m5s 2m1s 22 3 5m20s 1m46s [ User: intelifix - Total duration: 1h31m58s - Times executed: 48 ]
[ Application: psql - Total duration: 1h31m58s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-11 07:13:36 Duration: 8m34s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-11 20:11:45 Duration: 6m44s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-11 21:10:49 Duration: 5m48s Database: rio User: intelifix Remote: [local] Application: psql
4 48 1h3m11s 245ms 3m41s 1m18s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 11 07 3 5m20s 1m46s 08 3 3m46s 1m15s 09 3 3m50s 1m16s 10 3 3m42s 1m14s 11 3 3m43s 1m14s 12 3 3m49s 1m16s 13 3 3m48s 1m16s 14 3 3m47s 1m15s 15 3 3m55s 1m18s 16 3 3m49s 1m16s 17 3 3m48s 1m16s 18 3 3m48s 1m16s 19 3 3m48s 1m16s 20 3 4m37s 1m32s 21 3 3m44s 1m14s 22 3 3m48s 1m16s [ User: intelifix - Total duration: 1h3m11s - Times executed: 48 ]
[ Application: psql - Total duration: 1h3m11s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-11 07:19:30 Duration: 3m41s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-11 20:16:43 Duration: 3m28s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-11 15:14:21 Duration: 3m26s Database: brasilia User: intelifix Remote: [local] Application: psql
5 39 36s291ms 583ms 3s937ms 930ms call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 11 08 3 5s638ms 1s879ms 09 2 1s869ms 934ms 10 2 1s580ms 790ms 11 2 1s513ms 756ms 12 2 1s573ms 786ms 13 3 2s570ms 856ms 14 3 2s154ms 718ms 15 3 2s501ms 833ms 16 3 2s444ms 814ms 17 3 2s556ms 852ms 18 2 1s809ms 904ms 19 3 2s469ms 823ms 20 3 3s330ms 1s110ms 21 3 2s671ms 890ms 22 2 1s607ms 803ms [ User: intelifix - Total duration: 36s291ms - Times executed: 39 ]
[ Application: psql - Total duration: 36s291ms - Times executed: 39 ]
-
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-10-11 08:00:05 Duration: 3s937ms 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-10-11 20:20:02 Duration: 1s563ms 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-10-11 09:20:02 Duration: 1s11ms Database: rio User: intelifix Remote: [local] Application: psql
6 22 4s725ms 180ms 298ms 214ms call rs_giga_triagem (?) / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 11 07 1 186ms 186ms 09 1 298ms 298ms 10 2 445ms 222ms 11 1 215ms 215ms 12 2 402ms 201ms 13 1 251ms 251ms 15 2 436ms 218ms 16 2 440ms 220ms 17 1 253ms 253ms 18 2 375ms 187ms 19 2 379ms 189ms 20 2 432ms 216ms 21 2 410ms 205ms 22 1 194ms 194ms [ User: intelifix - Total duration: 4s725ms - Times executed: 22 ]
[ Application: psql - Total duration: 4s725ms - Times executed: 22 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR') / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-11 09:55:04 Duration: 298ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR') / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-11 16:55:05 Duration: 254ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR') / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-11 17:55:05 Duration: 253ms Database: brasilia User: intelifix Remote: [local] Application: psql
7 15 30s634ms 356ms 11s43ms 2s42ms select * from rs_posicao_oficina_html (?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 11 07 6 17s524ms 2s920ms 08 9 13s109ms 1s456ms [ User: intelifix - Total duration: 30s634ms - Times executed: 15 ]
[ Application: [unknown] - Total duration: 30s634ms - Times executed: 15 ]
-
SELECT * FROM RS_POSICAO_OFICINA_HTML ('{ "oficina" : "6" , "grupo" : "1" , "nivel" : "1" , "cliente" : "0" , "modelo" : "0" }');
Date: 2026-10-11 07:28:43 Duration: 11s43ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_POSICAO_OFICINA_HTML ('{ "oficina" : "6" , "grupo" : "1" , "nivel" : "1" , "cliente" : "0" , "modelo" : "0" }');
Date: 2026-10-11 08:12:01 Duration: 2s117ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_POSICAO_OFICINA_HTML ('{ "oficina" : "6" , "grupo" : "1" , "nivel" : "1" , "cliente" : "0" , "modelo" : "0" }');
Date: 2026-10-11 08:07:39 Duration: 2s102ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 11 15s820ms 1s58ms 5s40ms 1s438ms create table temp0000293942 as select * from rs_equipamentos_lista (?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 11 07 9 13s638ms 1s515ms 08 2 2s182ms 1s91ms [ User: intelifix - Total duration: 15s820ms - Times executed: 11 ]
[ Application: [unknown] - Total duration: 15s820ms - Times executed: 11 ]
-
CREATE TABLE temp0000293942 AS SELECT * FROM RS_EQUIPAMENTOS_LISTA (00, 00, 0431, 06, 3, '');
Date: 2026-10-11 07:35:48 Duration: 5s40ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293942 AS SELECT * FROM RS_EQUIPAMENTOS_LISTA (00, 00, 0431, 06, 3, '');
Date: 2026-10-11 08:01:32 Duration: 1s113ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293942 AS SELECT * FROM RS_EQUIPAMENTOS_LISTA (00, 00, 0431, 06, 3, '');
Date: 2026-10-11 07:35:56 Duration: 1s91ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 8 15s547ms 241ms 4s309ms 1s943ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 11 00 4 8s356ms 2s89ms 06 4 7s190ms 1s797ms [ User: lenon - Total duration: 15s547ms - Times executed: 8 ]
[ Application: psql - Total duration: 15s547ms - Times executed: 8 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-10-11 00:02:07 Duration: 4s309ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-10-11 06:02:05 Duration: 3s859ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-10-11 00:02:09 Duration: 2s598ms Database: brasilia User: lenon Remote: [local] Application: psql
10 8 2s524ms 298ms 389ms 315ms select pro_id, pgp_sym_decrypt(nome, ?)::varchar, pgp_sym_decrypt(descricao, ?)::varchar, pgp_sym_decrypt(classe, ?)::varchar, pgp_sym_decrypt(php, ?)::varchar, pgp_sym_decrypt(extras, ?)::varchar from progs order by pro_id;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 11 07 1 307ms 307ms 08 3 912ms 304ms 09 2 696ms 348ms 14 2 606ms 303ms [ User: lenon - Total duration: 2s524ms - Times executed: 8 ]
[ Application: [unknown] - Total duration: 2s524ms - Times executed: 8 ]
-
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-10-11 09:35:08 Duration: 389ms 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-10-11 08:10:57 Duration: 311ms 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-10-11 14:51:16 Duration: 307ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
11 7 2s247ms 215ms 548ms 321ms 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 #11
Day Hour Count Duration Avg duration Oct 11 20 3 660ms 220ms 23 4 1s587ms 396ms [ User: intelifix - Total duration: 2s247ms - Times executed: 7 ]
[ Application: pg_dump - Total duration: 2s247ms - 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-10-11 23:10:02 Duration: 548ms 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-10-11 23:42:07 Duration: 408ms Database: contagem 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-10-11 23:32:36 Duration: 315ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 7 1s981ms 190ms 424ms 283ms 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 #12
Day Hour Count Duration Avg duration Oct 11 20 3 621ms 207ms 23 4 1s359ms 339ms [ User: intelifix - Total duration: 1s981ms - Times executed: 7 ]
[ Application: pg_dump - Total duration: 1s981ms - 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-10-11 23:17:14 Duration: 424ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
SELECT p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, p.proacl, acldefault('f', p.proowner) AS acldefault, p.pronamespace, p.proowner FROM pg_proc p LEFT JOIN pg_init_privs pip ON (p.oid = pip.objoid AND pip.classoid = 'pg_proc'::regclass AND pip.objsubid = 0) WHERE p.prokind <> 'a' AND NOT EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_proc'::regclass AND objid = p.oid AND deptype = 'i') AND (pronamespace != ( SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog') OR EXISTS ( SELECT 1 FROM pg_cast WHERE pg_cast.oid > 16383 AND p.oid = pg_cast.castfunc) OR EXISTS ( SELECT 1 FROM pg_transform WHERE pg_transform.oid > 16383 AND (p.oid = pg_transform.trffromsql OR p.oid = pg_transform.trftosql)) OR p.proacl IS DISTINCT FROM pip.initprivs);
Date: 2026-10-11 23:10:02 Duration: 333ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
SELECT p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, p.proacl, acldefault('f', p.proowner) AS acldefault, p.pronamespace, p.proowner FROM pg_proc p LEFT JOIN pg_init_privs pip ON (p.oid = pip.objoid AND pip.classoid = 'pg_proc'::regclass AND pip.objsubid = 0) WHERE p.prokind <> 'a' AND NOT EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_proc'::regclass AND objid = p.oid AND deptype = 'i') AND (pronamespace != ( SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog') OR EXISTS ( SELECT 1 FROM pg_cast WHERE pg_cast.oid > 16383 AND p.oid = pg_cast.castfunc) OR EXISTS ( SELECT 1 FROM pg_transform WHERE pg_transform.oid > 16383 AND (p.oid = pg_transform.trffromsql OR p.oid = pg_transform.trftosql)) OR p.proacl IS DISTINCT FROM pip.initprivs);
Date: 2026-10-11 23:42:08 Duration: 313ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
13 6 1m48s 3s229ms 40s586ms 18s140ms 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 #13
Day Hour Count Duration Avg duration Oct 11 20 3 54s287ms 18s95ms 23 3 54s553ms 18s184ms [ User: intelifix - Total duration: 1m48s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m48s - 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-10-11 23:14:27 Duration: 40s586ms 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-10-11 20:06:27 Duration: 40s420ms 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-10-11 23:33:39 Duration: 10s694ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 6 1m23s 2s307ms 31s653ms 13s936ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 11 20 3 41s810ms 13s936ms 23 3 41s807ms 13s935ms [ 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-10-11 23:15:02 Duration: 31s653ms 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-10-11 20:07:02 Duration: 31s647ms 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-10-11 20:10:24 Duration: 7s855ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 6 1m22s 3s18ms 31s978ms 13s813ms 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 #15
Day Hour Count Duration Avg duration Oct 11 20 3 41s539ms 13s846ms 23 3 41s344ms 13s781ms [ 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-10-11 20:09:13 Duration: 31s978ms 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-10-11 23:17:12 Duration: 31s815ms 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-10-11 20:10:46 Duration: 6s521ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 6 1m11s 2s521ms 23s575ms 11s953ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 11 20 3 35s844ms 11s948ms 23 3 35s874ms 11s958ms [ 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-10-11 23:10:48 Duration: 23s575ms 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-10-11 20:02:47 Duration: 23s558ms 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-10-11 20:09:33 Duration: 9s764ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 6 1m11s 2s254ms 24s382ms 11s922ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 11 20 3 35s922ms 11s974ms 23 3 35s613ms 11s871ms [ 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-10-11 20:03:29 Duration: 24s382ms 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-10-11 23:11:29 Duration: 24s155ms 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-10-11 23:33:08 Duration: 9s203ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 6 1m5s 5s695ms 15s732ms 10s979ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 11 00 3 39s65ms 13s21ms 06 3 26s812ms 8s937ms [ User: intelifix - Total duration: 1m5s - Times executed: 6 ]
[ Application: psql - Total duration: 1m5s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-10-11 00:05:30 Duration: 15s732ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-10-11 00:05:14 Duration: 13s194ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-10-11 06:05:22 Duration: 11s933ms Database: brasilia User: intelifix Remote: [local] Application: psql
19 6 1m4s 1s709ms 25s519ms 10s803ms 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 #19
Day Hour Count Duration Avg duration Oct 11 20 3 32s308ms 10s769ms 23 3 32s512ms 10s837ms [ 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-10-11 20:04:28 Duration: 25s519ms 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-10-11 23:12:28 Duration: 25s255ms 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-10-11 23:33:23 Duration: 5s546ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 6 51s765ms 1s836ms 16s899ms 8s627ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 11 20 3 25s953ms 8s651ms 23 3 25s812ms 8s604ms [ User: intelifix - Total duration: 51s765ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 51s765ms - 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-10-11 23:11:46 Duration: 16s899ms 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-10-11 20:03:46 Duration: 16s828ms 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-10-11 20:09:52 Duration: 7s262ms 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 2m50s 10m12s 6m44s 3 20m13s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 11 05 3 20m13s 6m44s [ User: intelifix - Total duration: 20m13s - Times executed: 3 ]
[ Application: psql - Total duration: 20m13s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-10-11 05:10:14 Duration: 10m12s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-11 05:17:24 Duration: 7m10s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-11 05:20:15 Duration: 2m50s Database: contagem User: intelifix Remote: [local] Application: psql
2 2s319ms 8m34s 1m54s 48 1h31m58s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 11 07 3 9m18s 3m6s 08 3 5m19s 1m46s 09 3 5m22s 1m47s 10 3 5m17s 1m45s 11 3 5m18s 1m46s 12 3 5m19s 1m46s 13 3 5m25s 1m48s 14 3 5m18s 1m46s 15 3 5m26s 1m48s 16 3 5m15s 1m45s 17 3 5m18s 1m46s 18 3 5m19s 1m46s 19 3 5m19s 1m46s 20 3 7m12s 2m24s 21 3 6m5s 2m1s 22 3 5m20s 1m46s [ User: intelifix - Total duration: 1h31m58s - Times executed: 48 ]
[ Application: psql - Total duration: 1h31m58s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-11 07:13:36 Duration: 8m34s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-11 20:11:45 Duration: 6m44s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-11 21:10:49 Duration: 5m48s 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 Oct 11 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-10-11 05:32:03 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-11 05:31:55 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
4 245ms 3m41s 1m18s 48 1h3m11s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 11 07 3 5m20s 1m46s 08 3 3m46s 1m15s 09 3 3m50s 1m16s 10 3 3m42s 1m14s 11 3 3m43s 1m14s 12 3 3m49s 1m16s 13 3 3m48s 1m16s 14 3 3m47s 1m15s 15 3 3m55s 1m18s 16 3 3m49s 1m16s 17 3 3m48s 1m16s 18 3 3m48s 1m16s 19 3 3m48s 1m16s 20 3 4m37s 1m32s 21 3 3m44s 1m14s 22 3 3m48s 1m16s [ User: intelifix - Total duration: 1h3m11s - Times executed: 48 ]
[ Application: psql - Total duration: 1h3m11s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-11 07:19:30 Duration: 3m41s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-11 20:16:43 Duration: 3m28s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-11 15:14:21 Duration: 3m26s Database: brasilia User: intelifix Remote: [local] Application: psql
5 54s907ms 54s907ms 54s907ms 1 54s907ms select * from rs_resumo_lote_entrada (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 11 07 1 54s907ms 54s907ms [ User: intelifix - Total duration: 54s907ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 54s907ms - Times executed: 1 ]
-
SELECT * FROM RS_RESUMO_LOTE_ENTRADA (00, 06, ' ', '2026-10-01', '2026-10-11', 00, 00);
Date: 2026-10-11 07:30:44 Duration: 54s907ms Database: rio User: intelifix Remote: [local] Application: [unknown]
6 4s220ms 1m3s 33s766ms 4 2m15s 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 Oct 11 20 2 1m7s 33s805ms 23 2 1m7s 33s726ms [ User: intelifix - Total duration: 2m15s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m15s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-11 20:08:41 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-10-11 23:16:40 Duration: 1m2s 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-10-11 23:34:04 Duration: 4s656ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 368ms 53s397ms 26s813ms 4 1m47s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 11 20 2 53s816ms 26s908ms 23 2 53s435ms 26s717ms [ 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-10-11 20:05:45 Duration: 53s397ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-11 23:13:45 Duration: 53s67ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-11 20:10:05 Duration: 418ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 3s229ms 40s586ms 18s140ms 6 1m48s copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 11 20 3 54s287ms 18s95ms 23 3 54s553ms 18s184ms [ User: intelifix - Total duration: 1m48s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m48s - 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-10-11 23:14:27 Duration: 40s586ms 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-10-11 20:06:27 Duration: 40s420ms 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-10-11 23:33:39 Duration: 10s694ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
9 4s289ms 23s715ms 14s33ms 4 56s134ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 11 20 2 28s4ms 14s2ms 23 2 28s130ms 14s65ms [ User: intelifix - Total duration: 56s134ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 56s134ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-10-11 20:04:52 Duration: 23s715ms 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-10-11 23:12:52 Duration: 23s669ms 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-10-11 23:33:28 Duration: 4s460ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 2s307ms 31s653ms 13s936ms 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 Oct 11 20 3 41s810ms 13s936ms 23 3 41s807ms 13s935ms [ 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-10-11 23:15:02 Duration: 31s653ms 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-10-11 20:07:02 Duration: 31s647ms 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-10-11 20:10:24 Duration: 7s855ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 3s18ms 31s978ms 13s813ms 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 #11
Day Hour Count Duration Avg duration Oct 11 20 3 41s539ms 13s846ms 23 3 41s344ms 13s781ms [ 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-10-11 20:09:13 Duration: 31s978ms 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-10-11 23:17:12 Duration: 31s815ms 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-10-11 20:10:46 Duration: 6s521ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 2s521ms 23s575ms 11s953ms 6 1m11s copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 11 20 3 35s844ms 11s948ms 23 3 35s874ms 11s958ms [ 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-10-11 23:10:48 Duration: 23s575ms 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-10-11 20:02:47 Duration: 23s558ms 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-10-11 20:09:33 Duration: 9s764ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 2s254ms 24s382ms 11s922ms 6 1m11s copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 11 20 3 35s922ms 11s974ms 23 3 35s613ms 11s871ms [ 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-10-11 20:03:29 Duration: 24s382ms 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-10-11 23:11:29 Duration: 24s155ms 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-10-11 23:33:08 Duration: 9s203ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 5s695ms 15s732ms 10s979ms 6 1m5s call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 11 00 3 39s65ms 13s21ms 06 3 26s812ms 8s937ms [ User: intelifix - Total duration: 1m5s - Times executed: 6 ]
[ Application: psql - Total duration: 1m5s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-10-11 00:05:30 Duration: 15s732ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-10-11 00:05:14 Duration: 13s194ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-10-11 06:05:22 Duration: 11s933ms Database: brasilia User: intelifix Remote: [local] Application: psql
15 1s709ms 25s519ms 10s803ms 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 Oct 11 20 3 32s308ms 10s769ms 23 3 32s512ms 10s837ms [ 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-10-11 20:04:28 Duration: 25s519ms 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-10-11 23:12:28 Duration: 25s255ms 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-10-11 23:33:23 Duration: 5s546ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 182ms 35s138ms 9s701ms 4 38s806ms create table temp0000293930 as select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 11 08 4 38s806ms 9s701ms [ User: intelifix - Total duration: 38s806ms - Times executed: 4 ]
[ Application: [unknown] - Total duration: 38s806ms - Times executed: 4 ]
-
CREATE TABLE temp0000293930 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "6", "cliente" : "0", "nf" : "", "data-de" : "06-10-2026", "data-ate" : "11-10-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-10-11 08:44:42 Duration: 35s138ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293930 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "6", "cliente" : "0", "nf" : "", "data-de" : "06-10-2026", "data-ate" : "11-10-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-10-11 08:44:44 Duration: 1s743ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293930 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "6", "cliente" : "0", "nf" : "", "data-de" : "06-10-2026", "data-ate" : "11-10-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-10-11 08:45:44 Duration: 1s741ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 1s836ms 16s899ms 8s627ms 6 51s765ms 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 Oct 11 20 3 25s953ms 8s651ms 23 3 25s812ms 8s604ms [ User: intelifix - Total duration: 51s765ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 51s765ms - 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-10-11 23:11:46 Duration: 16s899ms 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-10-11 20:03:46 Duration: 16s828ms 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-10-11 20:09:52 Duration: 7s262ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 1s83ms 17s13ms 6s911ms 6 41s467ms copy public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 11 20 3 20s705ms 6s901ms 23 3 20s761ms 6s920ms [ User: intelifix - Total duration: 41s467ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 41s467ms - Times executed: 6 ]
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-10-11 23:11:05 Duration: 17s13ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-10-11 20:03:04 Duration: 17s8ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-10-11 23:32:59 Duration: 2s661ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 179ms 18s968ms 2s295ms 252 9m38s call rs_giga_triagem (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 11 00 12 43s100ms 3s591ms 01 12 24s396ms 2s33ms 02 12 24s86ms 2s7ms 03 10 20s65ms 2s6ms 04 12 23s345ms 1s945ms 05 12 26s31ms 2s169ms 06 12 22s469ms 1s872ms 07 11 21s980ms 1s998ms 08 12 24s317ms 2s26ms 09 11 24s221ms 2s201ms 10 10 22s151ms 2s215ms 11 11 22s255ms 2s23ms 12 10 22s579ms 2s257ms 13 11 22s948ms 2s86ms 14 12 22s958ms 1s913ms 15 10 22s799ms 2s279ms 16 10 23s131ms 2s313ms 17 11 22s331ms 2s30ms 18 10 22s389ms 2s238ms 19 10 22s442ms 2s244ms 20 10 53s425ms 5s342ms 21 10 22s201ms 2s220ms 22 11 22s915ms 2s83ms [ User: intelifix - Total duration: 9m38s - Times executed: 252 ]
[ Application: psql - Total duration: 9m38s - Times executed: 252 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-11 00:05:20 Duration: 18s968ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-11 20:05:20 Duration: 18s512ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-11 20:15:16 Duration: 14s714ms Database: rio User: intelifix Remote: [local] Application: psql
20 356ms 11s43ms 2s42ms 15 30s634ms select * from rs_posicao_oficina_html (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 11 07 6 17s524ms 2s920ms 08 9 13s109ms 1s456ms [ User: intelifix - Total duration: 30s634ms - Times executed: 15 ]
[ Application: [unknown] - Total duration: 30s634ms - Times executed: 15 ]
-
SELECT * FROM RS_POSICAO_OFICINA_HTML ('{ "oficina" : "6" , "grupo" : "1" , "nivel" : "1" , "cliente" : "0" , "modelo" : "0" }');
Date: 2026-10-11 07:28:43 Duration: 11s43ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_POSICAO_OFICINA_HTML ('{ "oficina" : "6" , "grupo" : "1" , "nivel" : "1" , "cliente" : "0" , "modelo" : "0" }');
Date: 2026-10-11 08:12:01 Duration: 2s117ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_POSICAO_OFICINA_HTML ('{ "oficina" : "6" , "grupo" : "1" , "nivel" : "1" , "cliente" : "0" , "modelo" : "0" }');
Date: 2026-10-11 08:07:39 Duration: 2s102ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 6 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Oct 11 09 2 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 18 1 0ms 0ms [ User: intelifix - Total duration: 36s366ms - Times executed: 6 ]
[ Application: psql - Total duration: 35s221ms - Times executed: 5 ]
[ Application: [unknown] - Total duration: 1s145ms - Times executed: 1 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 1,946 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 17 FATAL entries
- 4 ERROR entries
- 0 WARNING entries
- 1 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 8 Max number of times the same event was reported
- 22 Total events found
Rank Times reported Error 1 8 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Oct 11 03 1 04 1 06 1 09 1 12 1 14 1 21 1 22 1 - FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-10-11 03:06:10 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-11 04:33:02 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-11 06:42:38 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
2 5 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #2
Day Hour Count Oct 11 03 5 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-10-11 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-11 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-11 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
3 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count Oct 11 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-10-11 05:32:03 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-11 05:32:03 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-11 05:32:03 Database: contagem Application: psql User: intelifix Remote: [local]
4 2 FATAL: database "..." 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 #4
Day Hour Count Oct 11 10 1 17 1 - FATAL: database "jaboatao" 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(
- FATAL: database "jaboatao" 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(
Date: 2026-10-11 10:16:45 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-11 17:37:59 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
5 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #5
Day Hour Count Oct 11 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-10-11 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-11 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
6 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #6
Day Hour Count Oct 11 03 1 - LOG: database system was shut down at 2026-10-11 03:05:02 -03
Date: 2026-10-11 03:05:02