pgBadger-
Global information
- Generated on Sun Sep 20 23:50:16 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 8,529 log entries in 14s
- Log start from 2026-09-19 00:00:11 to 2026-09-19 23:59:57
-
Overview
Global Stats
- 153 Number of unique normalized queries
- 858 Number of queries
- 4h4m39s Total query duration
- 2026-09-19 00:02:22 First query
- 2026-09-19 23:43:33 Last query
- 5 queries/s at 2026-09-19 23:43:28 Query peak
- 4h4m39s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 4h4m39s Execute total duration
- 1,306 Number of events
- 6 Number of unique normalized events
- 1,267 Max number of times the same event was reported
- 0 Number of cancellation
- 6 Total number of automatic vacuums
- 1 Total number of automatic analyzes
- 20 Number temporary file
- 246.58 MiB Max size of temporary file
- 67.11 MiB Average size of temporary file
- 205 Total number of sessions
- 7 sessions at 2026-09-19 04:00:34 Session peak
- 7d6h27m30s Total duration of sessions
- 51m3s Average duration of sessions
- 4 Average queries per session
- 1m11s Average queries duration per session
- 49m52s Average idle time per session
- 219 Total number of connections
- 7 connections/s at 2026-09-19 23:39:59 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-09-19 23:43:28 Date
SELECT Traffic
Key values
- 3 queries/s Query Peak
- 2026-09-19 23:17:20 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-09-19 23:43:28 Date
Queries duration
Key values
- 4h4m39s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 19 00 42 0ms 33s561ms 5s53ms 6s670ms 31s805ms 1m28s 01 0 0ms 0ms 0ms 0ms 0ms 0ms 03 19 0ms 1m10s 9s262ms 26s133ms 54s923ms 1m23s 04 14 0ms 6s444ms 2s811ms 4s22ms 7s243ms 8s127ms 05 19 0ms 11m43s 1m18s 8s774ms 3m8s 11m43s 06 12 0ms 4s468ms 2s162ms 1s708ms 2s146ms 12s889ms 07 15 0ms 9m19s 1m6s 1s835ms 2m30s 9m19s 08 18 0ms 5m13s 32s579ms 1s924ms 15s145ms 5m43s 09 18 0ms 5m12s 32s386ms 1s806ms 2s47ms 5m57s 10 18 0ms 5m10s 32s103ms 1s756ms 1s964ms 5m54s 11 19 0ms 5m8s 30s385ms 1s768ms 1s878ms 5m52s 12 18 0ms 5m9s 32s205ms 1s892ms 2s96ms 5m54s 13 23 0ms 5m7s 25s138ms 1s773ms 2s685ms 5m52s 14 18 0ms 5m21s 32s966ms 1s768ms 15s100ms 5m50s 15 18 0ms 5m14s 33s325ms 1s860ms 15s412ms 5m46s 16 18 0ms 5m7s 32s55ms 1s827ms 2s76ms 5m52s 17 18 0ms 5m12s 32s565ms 1s758ms 2s133ms 5m57s 18 21 0ms 5m13s 27s921ms 1s939ms 3s800ms 5m57s 19 18 0ms 5m11s 32s226ms 1s799ms 2s193ms 5m55s 20 124 0ms 8m4s 11s857ms 1m5s 1m50s 8m4s 21 20 0ms 6m31s 33s271ms 1s969ms 44s977ms 6m31s 22 18 0ms 5m9s 32s697ms 1s814ms 2s74ms 5m53s 23 350 0ms 1m5s 5s709ms 1m5s 1m6s 1m8s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 19 00 14 0 2s712ms 0ms 0ms 3s88ms 01 0 0 0ms 0ms 0ms 0ms 03 5 0 7s83ms 0ms 1s932ms 31s163ms 04 0 0 0ms 0ms 0ms 0ms 05 3 0 441ms 0ms 0ms 425ms 06 3 0 1s335ms 0ms 0ms 0ms 07 9 0 1m50s 0ms 0ms 4m38s 08 6 0 1m34s 0ms 0ms 3m25s 09 6 0 1m34s 0ms 0ms 3m29s 10 6 0 1m33s 0ms 0ms 3m27s 11 7 0 1m20s 0ms 0ms 3m29s 12 6 0 1m33s 0ms 0ms 3m28s 13 10 0 56s256ms 0ms 0ms 3m28s 14 6 0 1m36s 0ms 0ms 3m31s 15 6 0 1m36s 0ms 0ms 3m39s 16 6 0 1m33s 0ms 0ms 3m28s 17 6 0 1m35s 0ms 0ms 3m33s 18 9 0 1m3s 0ms 0ms 3m30s 19 6 0 1m34s 0ms 0ms 3m28s 20 25 78 13s842ms 43s108ms 1m2s 4m2s 21 8 0 1m21s 0ms 0ms 3m30s 22 6 0 1m35s 0ms 0ms 3m38s 23 27 323 5s709ms 1m1s 1m4s 1m6s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 19 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Sep 19 00 0 2 2.00 0.00% 01 0 0 0.00 0.00% 03 0 2 2.00 0.00% 04 0 0 0.00 0.00% 05 0 1 1.00 0.00% 06 0 0 0.00 0.00% 07 0 1 1.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 1 1.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 1 1.00 0.00% Day Hour Count Average / Second Sep 19 00 23 0.01/s 01 0 0.00/s 03 24 0.01/s 04 7 0.00/s 05 11 0.00/s 06 9 0.00/s 07 10 0.00/s 08 8 0.00/s 09 7 0.00/s 10 7 0.00/s 11 10 0.00/s 12 7 0.00/s 13 9 0.00/s 14 6 0.00/s 15 7 0.00/s 16 9 0.00/s 17 8 0.00/s 18 7 0.00/s 19 8 0.00/s 20 11 0.00/s 21 8 0.00/s 22 9 0.00/s 23 14 0.00/s Day Hour Count Average Duration Average idle time Sep 19 00 16 42m43s 42m29s 01 8 12m7s 12m7s 03 9 1m27s 1m8s 04 14 1h2m17s 1h2m14s 05 9 50m6s 47m20s 06 9 1h40s 1h37s 07 8 1h45s 58m40s 08 11 56m10s 55m17s 09 7 1h1m16s 59m53s 10 7 1h44s 59m21s 11 7 1h1s 58m39s 12 10 57m48s 56m50s 13 7 1h44s 59m21s 14 8 1h24s 59m9s 15 7 1h2m13s 1h48s 16 7 1h 58m37s 17 8 53m45s 52m32s 18 7 1h2s 58m38s 19 7 1h29s 59m6s 20 11 45m27s 43m13s 21 9 54m52s 53m38s 22 7 1h 58m36s 23 12 33m2s 30m16s -
Connections
Established Connections
Key values
- 7 connections Connection Peak
- 2026-09-19 23:39:59 Date
Connections per database
Key values
- rio Main Database
- 219 connections Total
Connections per user
Key values
- intelifix Main User
- 219 connections Total
-
Sessions
Simultaneous sessions
Key values
- 7 sessions Session Peak
- 2026-09-19 04:00:34 Date
Histogram of session times
Key values
- 158 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 205 sessions Total
Sessions per user
Key values
- intelifix Main User
- 205 sessions Total
Sessions per host
Key values
- [local] Main Host
- 205 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 16,946 buffers Checkpoint Peak
- 2026-09-19 00:10:06 Date
- 269.890 seconds Highest write time
- 0.201 seconds Sync time
Checkpoints Wal files
Key values
- 5 files Wal files usage Peak
- 2026-09-19 00:10:06 Date
Checkpoints distance
Key values
- 174.53 Mo Distance Peak
- 2026-09-19 00:10:06 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Sep 19 00 22,992 812.535s 0.127s 812.769s 01 561 0.021s 0.201s 0.231s 03 13,083 592.526s 0.202s 592.76s 04 2,837 284.172s 0.075s 284.281s 05 10,400 1,007.397s 0.371s 1,007.8s 06 5,688 269.89s 0.063s 269.957s 07 151 15.204s 0.084s 15.319s 08 24 2.419s 0.065s 2.49s 09 23 2.313s 0.009s 2.328s 10 23 2.312s 0.006s 2.321s 11 23 2.312s 0.009s 2.323s 12 23 2.313s 0.008s 2.33s 13 71 7.131s 0.077s 7.217s 14 23 2.312s 0.023s 2.344s 15 23 2.312s 0.006s 2.322s 16 23 2.312s 0.006s 2.328s 17 23 2.311s 0.017s 2.334s 18 697 69.781s 0.039s 69.838s 19 23 2.312s 0.013s 2.332s 20 375 37.59s 0.016s 37.618s 21 41 4.124s 0.024s 4.223s 22 23 2.314s 0.003s 2.32s 23 6 0.614s 0.003s 0.622s Day Hour Added Removed Recycled Synced files Longest sync Average sync Sep 19 00 0 0 7 493 0.062s 0.008s 01 0 0 0 78 0.173s 0.003s 03 0 0 4 270 0.083s 0.011s 04 0 0 1 430 0.027s 0.006s 05 0 0 4 667 0.131s 0.019s 06 0 0 1 12 0.063s 0.006s 07 0 0 0 25 0.064s 0.038s 08 0 0 0 4 0.063s 0.023s 09 0 0 0 3 0.008s 0.003s 10 0 0 0 3 0.003s 0.002s 11 0 0 0 3 0.007s 0.003s 12 0 0 0 3 0.006s 0.003s 13 0 0 0 45 0.063s 0.006s 14 0 0 0 3 0.014s 0.008s 15 0 0 0 3 0.004s 0.002s 16 0 0 0 3 0.006s 0.002s 17 0 0 0 3 0.012s 0.006s 18 0 0 0 52 0.019s 0.009s 19 0 0 0 3 0.012s 0.005s 20 0 0 0 23 0.007s 0.004s 21 0 0 0 14 0.011s 0.005s 22 0 0 0 3 0.002s 0.001s 23 0 0 0 5 0.002s 0.002s Day Hour Count Avg time (sec) Sep 19 00 0 0s 01 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Sep 19 00 15,556.00 kB 60,668.75 kB 01 2,805.00 kB 6,986.00 kB 03 13,929.75 kB 19,685.50 kB 04 2,456.67 kB 18,749.83 kB 05 7,806.44 kB 15,451.89 kB 06 17,489.00 kB 17,489.00 kB 07 126.20 kB 12,927.40 kB 08 98.00 kB 8,882.00 kB 09 192.00 kB 7,601.00 kB 10 192.00 kB 6,860.00 kB 11 192.00 kB 6,194.00 kB 12 192.00 kB 5,593.00 kB 13 170.00 kB 4,808.00 kB 14 192.00 kB 4,126.00 kB 15 192.00 kB 3,732.00 kB 16 192.00 kB 3,378.00 kB 17 192.00 kB 3,059.00 kB 18 830.67 kB 2,703.67 kB 19 192.00 kB 2,211.00 kB 20 346.33 kB 1,866.33 kB 21 121.00 kB 1,478.00 kB 22 192.00 kB 1,281.00 kB 23 43.50 kB 1,100.50 kB -
Temporary Files
Size of temporary files
Key values
- 493.16 MiB Temp Files size Peak
- 2026-09-19 05:31:56 Date
Number of temporary files
Key values
- 4 per second Temp Files Peak
- 2026-09-19 05:32:01 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Sep 19 00 0 0 0 01 0 0 0 03 0 0 0 04 0 0 0 05 20 1.31 GiB 67.11 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.01 GiB 36.77 MiB 246.58 MiB 64.71 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-19 05:32:04 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-19 05:31:56 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 4 306.74 MiB 57.02 MiB 93.83 MiB 76.69 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-19 05:30:42 Duration: 39s480ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-19 05:30:38 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 246.58 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-19 05:31:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 246.58 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-19 05:31:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 93.83 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-19 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 93.83 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-19 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 62.07 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-19 05:30:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 57.02 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-19 05:30:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 40.75 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-19 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 40.68 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-19 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 40.68 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-19 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 40.67 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-19 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 40.67 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-19 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 40.66 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-19 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 40.66 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-19 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 36.85 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-19 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 36.79 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-19 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 36.78 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-19 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 36.78 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-19 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 36.78 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-19 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 36.77 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-19 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 36.77 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-19 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.34 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database rio - 2026-09-19 05:12:34 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 0.34 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database rio - 2026-09-19 05:12:34 Date
Analyzes per table
Key values
- public.temp0000291911 (1) Main table analyzed (database rio)
- 1 analyzes Total
Vacuums per table
Key values
- pg_toast.pg_toast_2619 (1) Main table vacuumed on database contagem
- 6 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 140 36 89,805 3 4 rio.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 846 218 1,091,585 136 480 rio.pg_catalog.pg_statistic 1 1 0 0 0 0 0 3,991 997 4,169,472 941 5,673 brasilia.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 180 43 132,690 20 50 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,386 191 772,560 168 1,352 brasilia.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,868 412 1,806,543 380 2,680 Total 6 6 0 0 0 0 0 10,411 1,897 8,062,655 1,648 10,239 Vacuum throughput per table
Key values
- pg_catalog.pg_statistic (0.34) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
Tuples removed per table
Key values
- pg_catalog.pg_statistic (4401) Main table with removed tuples on database rio
- 13467 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_statistic 1 1 4,401 7,481 0 0 1,286 contagem.pg_catalog.pg_statistic 1 1 4,261 7,274 0 0 1,011 brasilia.pg_catalog.pg_statistic 1 1 3,929 7,360 0 0 1,072 rio.pg_toast.pg_toast_2619 1 1 612 678 0 0 267 brasilia.pg_toast.pg_toast_2619 1 1 145 138 0 0 69 contagem.pg_toast.pg_toast_2619 1 1 119 108 0 0 59 Total 6 6 13,467 23,039 0 0 3,764 Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Pages removed per tables
NO DATASET
Table Number of vacuums Index scans Tuples removed Pages removed contagem.pg_toast.pg_toast_2619 1 1 119 0 rio.pg_toast.pg_toast_2619 1 1 612 0 rio.pg_catalog.pg_statistic 1 1 4401 0 brasilia.pg_toast.pg_toast_2619 1 1 145 0 contagem.pg_catalog.pg_statistic 1 1 4261 0 brasilia.pg_catalog.pg_statistic 1 1 3929 0 Total 6 6 13,467 0 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Sep 19 00 0 1 01 0 0 03 0 0 04 0 0 05 6 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 - 0.34 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
- 180 Total read queries
- 404 Total write queries
Queries by database
Key values
- rio Main database
- 424 Requests
- 2h36m5s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 835 Requests
User Request type Count Duration etiquetas Total 10 8s530ms select 10 8s530ms intelifix Total 835 4h3m22s copy to 401 42m22s ddl 3 1s954ms others 274 35m57s select 157 2h45m lenon Total 13 1m8s select 13 1m8s Duration by user
Key values
- 4h3m22s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 10 8s530ms select 10 8s530ms intelifix Total 835 4h3m22s copy to 401 42m22s ddl 3 1s954ms others 274 35m57s select 157 2h45m lenon Total 13 1m8s select 13 1m8s Queries by host
Key values
- [local] Main host
- 858 Requests
- 4h4m39s ([local])
- Main time consuming host
Queries by application
Key values
- pg_dump Main application
- 441 Requests
- 3h21m47s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-09-19 00:39:28 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 350 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 11m43s analyze verbose;[ Date: 2026-09-19 05:11:45 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 9m19s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-19 07:14:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 8m4s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-19 20:13:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 7m30s analyze verbose;[ Date: 2026-09-19 05:19:15 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
5 6m31s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-19 21:11:33 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 5m21s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-19 14:10:23 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 5m14s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-19 15:10:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 5m13s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-19 08:10:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 5m13s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-19 18:10:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 5m12s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-19 17:10:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 5m12s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-19 09:10:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m11s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-19 19:10:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 5m10s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-19 10:10:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m9s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-19 22:10:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m9s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-19 12:10:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m8s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-19 11:10:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m7s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-19 13:10:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 5m7s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-19 16:10:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 4m28s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-09-19 07:21:20 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
20 3m52s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-09-19 20:19:19 - 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 1h36m51s 48 1s435ms 9m19s 2m1s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 19 07 3 10m16s 3m25s 08 3 5m30s 1m50s 09 3 5m28s 1m49s 10 3 5m26s 1m48s 11 3 5m24s 1m48s 12 3 5m25s 1m48s 13 3 5m24s 1m48s 14 3 5m37s 1m52s 15 3 5m31s 1m50s 16 3 5m24s 1m48s 17 3 5m29s 1m49s 18 3 5m29s 1m49s 19 3 5m27s 1m49s 20 3 8m42s 2m54s 21 3 6m48s 2m16s 22 3 5m25s 1m48s [ User: intelifix - Total duration: 1h36m51s - Times executed: 48 ]
[ Application: psql - Total duration: 1h36m51s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-19 07:14:20 Duration: 9m19s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-19 20:13:06 Duration: 8m4s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-19 21:11:33 Duration: 6m31s Database: rio User: intelifix Remote: [local] Application: psql
2 1h7m44s 47 217ms 4m28s 1m26s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 19 07 3 6m12s 2m4s 08 3 3m53s 1m17s 09 3 3m58s 1m19s 10 3 3m55s 1m18s 11 3 3m57s 1m19s 12 3 3m57s 1m19s 13 3 3m56s 1m18s 14 3 3m59s 1m19s 15 3 4m10s 1m23s 16 3 3m56s 1m18s 17 3 4m1s 1m20s 18 3 3m58s 1m19s 19 3 3m56s 1m18s 20 2 5m42s 2m51s 21 3 3m59s 1m19s 22 3 4m6s 1m22s [ User: intelifix - Total duration: 1h7m44s - Times executed: 47 ]
[ Application: psql - Total duration: 1h7m44s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-19 07:21:20 Duration: 4m28s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-19 20:19:19 Duration: 3m52s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-19 15:14:41 Duration: 3m38s Database: brasilia User: intelifix Remote: [local] Application: psql
3 22m22s 3 3m8s 11m43s 7m27s analyze verbose;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 19 05 3 22m22s 7m27s [ User: intelifix - Total duration: 22m22s - Times executed: 3 ]
[ Application: psql - Total duration: 22m22s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-19 05:11:45 Duration: 11m43s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-19 05:19:15 Duration: 7m30s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-19 05:22:23 Duration: 3m8s Database: contagem User: intelifix Remote: [local] Application: psql
4 4m40s 130 167ms 11s989ms 2s157ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 19 00 10 34s771ms 3s477ms 03 4 13s861ms 3s465ms 04 6 9s854ms 1s642ms 05 6 10s305ms 1s717ms 06 6 10s946ms 1s824ms 07 6 11s27ms 1s837ms 08 6 10s982ms 1s830ms 09 6 10s951ms 1s825ms 10 6 10s982ms 1s830ms 11 6 10s694ms 1s782ms 12 6 11s339ms 1s889ms 13 6 10s778ms 1s796ms 14 6 10s789ms 1s798ms 15 6 11s243ms 1s873ms 16 6 11s325ms 1s887ms 17 6 11s214ms 1s869ms 18 6 11s292ms 1s882ms 19 6 11s18ms 1s836ms 20 8 34s965ms 4s370ms 21 6 10s942ms 1s823ms 22 6 11s151ms 1s858ms [ User: intelifix - Total duration: 4m40s - Times executed: 130 ]
[ Application: psql - Total duration: 4m40s - Times executed: 130 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-19 20:05:14 Duration: 11s989ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-19 00:55:31 Duration: 11s751ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-19 00:05:45 Duration: 10s545ms Database: rio User: intelifix Remote: [local] Application: psql
5 3m21s 24 277ms 1m10s 8s402ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 19 00 8 1m13s 9s136ms 03 4 1m19s 19s782ms 04 6 28s387ms 4s731ms 05 4 19s533ms 4s883ms 20 2 1s525ms 762ms [ User: intelifix - Total duration: 3m21s - Times executed: 24 ]
[ Application: psql - Total duration: 3m21s - Times executed: 24 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-19 03:46:11 Duration: 1m10s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-19 00:05:34 Duration: 33s561ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-19 00:55:19 Duration: 17s532ms Database: rio User: intelifix Remote: [local] Application: psql
6 2m20s 4 4s696ms 1m5s 35s98ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 19 20 2 1m9s 34s967ms 23 2 1m10s 35s228ms [ User: intelifix - Total duration: 2m20s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m20s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-19 23:16:47 Duration: 1m5s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-19 20:08:48 Duration: 1m5s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-19 23:34:17 Duration: 4s842ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 2m2s 15 3s50ms 16s46ms 8s178ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 19 00 6 1m4s 10s684ms 03 6 47s573ms 7s928ms 06 3 11s1ms 3s667ms [ User: intelifix - Total duration: 2m2s - Times executed: 15 ]
[ Application: psql - Total duration: 2m2s - Times executed: 15 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-19 00:05:17 Duration: 16s46ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-19 00:05:30 Duration: 13s166ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-19 00:05:41 Duration: 11s171ms Database: contagem User: intelifix Remote: [local] Application: psql
8 1m46s 6 3s89ms 39s856ms 17s819ms 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 Sep 19 20 3 53s337ms 17s779ms 23 3 53s580ms 17s860ms [ User: intelifix - Total duration: 1m46s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m46s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-09-19 23:14:29 Duration: 39s856ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-09-19 20:06:31 Duration: 39s824ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-09-19 23:33:51 Duration: 10s528ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
9 1m46s 4 352ms 53s350ms 26s597ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 19 20 2 53s702ms 26s851ms 23 2 52s685ms 26s342ms [ User: intelifix - Total duration: 1m46s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m46s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-19 20:05:47 Duration: 53s350ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-19 23:13:45 Duration: 52s289ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-19 23:33:41 Duration: 396ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 1m23s 6 2s235ms 31s848ms 13s923ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 19 20 3 41s739ms 13s913ms 23 3 41s798ms 13s932ms [ User: intelifix - Total duration: 1m23s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m23s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-09-19 20:07:06 Duration: 31s848ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-09-19 23:15:04 Duration: 31s816ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-09-19 23:34:00 Duration: 7s683ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 1m22s 1 1m22s 1m22s 1m22s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 19 05 1 1m22s 1m22s [ User: intelifix - Total duration: 1m22s - Times executed: 1 ]
[ Application: psql - Total duration: 1m22s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-19 05:32:04 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-19 05:31:56 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
12 1m22s 6 3s107ms 31s415ms 13s690ms copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 19 20 3 41s99ms 13s699ms 23 3 41s46ms 13s682ms [ User: intelifix - Total duration: 1m22s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m22s - Times executed: 6 ]
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-09-19 23:17:19 Duration: 31s415ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-09-19 20:09:20 Duration: 31s363ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-09-19 20:10:55 Duration: 6s627ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 1m11s 6 2s468ms 23s475ms 11s945ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 19 20 3 35s695ms 11s898ms 23 3 35s979ms 11s993ms [ User: intelifix - Total duration: 1m11s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m11s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-19 23:10:50 Duration: 23s475ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-19 20:02:50 Duration: 23s448ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-19 23:33:09 Duration: 10s35ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 1m11s 6 2s258ms 24s380ms 11s867ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 19 20 3 35s822ms 11s940ms 23 3 35s380ms 11s793ms [ User: intelifix - Total duration: 1m11s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m11s - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-19 20:03:31 Duration: 24s380ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-19 23:11:31 Duration: 23s925ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-19 23:33:20 Duration: 9s196ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 1m6s 9 377ms 20s321ms 7s441ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 19 00 3 31s805ms 10s601ms 03 3 31s163ms 10s387ms 06 3 4s7ms 1s335ms [ User: lenon - Total duration: 1m6s - Times executed: 9 ]
[ Application: psql - Total duration: 1m6s - Times executed: 9 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-09-19 03:36:47 Duration: 20s321ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-09-19 00:02:22 Duration: 20s1ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-09-19 00:02:30 Duration: 8s206ms Database: brasilia User: lenon Remote: [local] Application: psql
16 1m3s 6 1s719ms 25s81ms 10s637ms copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 19 20 3 31s843ms 10s614ms 23 3 31s979ms 10s659ms [ User: intelifix - Total duration: 1m3s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m3s - Times executed: 6 ]
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-09-19 20:04:30 Duration: 25s81ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-09-19 23:12:29 Duration: 25s12ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-09-19 23:33:36 Duration: 5s247ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 55s20ms 4 4s226ms 23s314ms 13s755ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 19 20 2 27s646ms 13s823ms 23 2 27s374ms 13s687ms [ User: intelifix - Total duration: 55s20ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 55s20ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-09-19 20:04:54 Duration: 23s314ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-09-19 23:12:53 Duration: 23s147ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-09-19 20:10:13 Duration: 4s332ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 51s544ms 6 1s818ms 16s742ms 8s590ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 19 20 3 25s631ms 8s543ms 23 3 25s912ms 8s637ms [ User: intelifix - Total duration: 51s544ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 51s544ms - Times executed: 6 ]
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-09-19 20:03:48 Duration: 16s742ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-09-19 23:11:47 Duration: 16s637ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-09-19 23:33:28 Duration: 7s442ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 48s704ms 54 574ms 3s23ms 901ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 19 08 3 2s637ms 879ms 09 3 2s410ms 803ms 10 4 3s85ms 771ms 11 4 3s342ms 835ms 12 3 2s485ms 828ms 13 4 3s103ms 775ms 14 3 2s292ms 764ms 15 5 6s14ms 1s202ms 16 4 3s348ms 837ms 17 3 2s226ms 742ms 18 3 2s385ms 795ms 19 4 3s275ms 818ms 20 4 5s514ms 1s378ms 21 4 4s271ms 1s67ms 22 3 2s312ms 770ms [ User: intelifix - Total duration: 48s704ms - Times executed: 54 ]
[ Application: psql - Total duration: 48s704ms - Times executed: 54 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-19 20:20:04 Duration: 3s23ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-19 15:20:04 Duration: 2s950ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-19 21:20:03 Duration: 1s774ms Database: rio User: intelifix Remote: [local] Application: psql
20 41s49ms 6 1s102ms 16s974ms 6s841ms 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 #20
Day Hour Count Duration Avg duration Sep 19 20 3 20s434ms 6s811ms 23 3 20s614ms 6s871ms [ User: intelifix - Total duration: 41s49ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 41s49ms - 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-09-19 23:11:07 Duration: 16s974ms 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-09-19 20:03:07 Duration: 16s796ms 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-09-19 23:33:11 Duration: 2s537ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 130 4m40s 167ms 11s989ms 2s157ms call rs_giga_triagem (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 19 00 10 34s771ms 3s477ms 03 4 13s861ms 3s465ms 04 6 9s854ms 1s642ms 05 6 10s305ms 1s717ms 06 6 10s946ms 1s824ms 07 6 11s27ms 1s837ms 08 6 10s982ms 1s830ms 09 6 10s951ms 1s825ms 10 6 10s982ms 1s830ms 11 6 10s694ms 1s782ms 12 6 11s339ms 1s889ms 13 6 10s778ms 1s796ms 14 6 10s789ms 1s798ms 15 6 11s243ms 1s873ms 16 6 11s325ms 1s887ms 17 6 11s214ms 1s869ms 18 6 11s292ms 1s882ms 19 6 11s18ms 1s836ms 20 8 34s965ms 4s370ms 21 6 10s942ms 1s823ms 22 6 11s151ms 1s858ms [ User: intelifix - Total duration: 4m40s - Times executed: 130 ]
[ Application: psql - Total duration: 4m40s - Times executed: 130 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-19 20:05:14 Duration: 11s989ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-19 00:55:31 Duration: 11s751ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-19 00:05:45 Duration: 10s545ms Database: rio User: intelifix Remote: [local] Application: psql
2 54 48s704ms 574ms 3s23ms 901ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 19 08 3 2s637ms 879ms 09 3 2s410ms 803ms 10 4 3s85ms 771ms 11 4 3s342ms 835ms 12 3 2s485ms 828ms 13 4 3s103ms 775ms 14 3 2s292ms 764ms 15 5 6s14ms 1s202ms 16 4 3s348ms 837ms 17 3 2s226ms 742ms 18 3 2s385ms 795ms 19 4 3s275ms 818ms 20 4 5s514ms 1s378ms 21 4 4s271ms 1s67ms 22 3 2s312ms 770ms [ User: intelifix - Total duration: 48s704ms - Times executed: 54 ]
[ Application: psql - Total duration: 48s704ms - Times executed: 54 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-19 20:20:04 Duration: 3s23ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-19 15:20:04 Duration: 2s950ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-19 21:20:03 Duration: 1s774ms Database: rio User: intelifix Remote: [local] Application: psql
3 48 1h36m51s 1s435ms 9m19s 2m1s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 19 07 3 10m16s 3m25s 08 3 5m30s 1m50s 09 3 5m28s 1m49s 10 3 5m26s 1m48s 11 3 5m24s 1m48s 12 3 5m25s 1m48s 13 3 5m24s 1m48s 14 3 5m37s 1m52s 15 3 5m31s 1m50s 16 3 5m24s 1m48s 17 3 5m29s 1m49s 18 3 5m29s 1m49s 19 3 5m27s 1m49s 20 3 8m42s 2m54s 21 3 6m48s 2m16s 22 3 5m25s 1m48s [ User: intelifix - Total duration: 1h36m51s - Times executed: 48 ]
[ Application: psql - Total duration: 1h36m51s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-19 07:14:20 Duration: 9m19s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-19 20:13:06 Duration: 8m4s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-19 21:11:33 Duration: 6m31s Database: rio User: intelifix Remote: [local] Application: psql
4 47 1h7m44s 217ms 4m28s 1m26s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 19 07 3 6m12s 2m4s 08 3 3m53s 1m17s 09 3 3m58s 1m19s 10 3 3m55s 1m18s 11 3 3m57s 1m19s 12 3 3m57s 1m19s 13 3 3m56s 1m18s 14 3 3m59s 1m19s 15 3 4m10s 1m23s 16 3 3m56s 1m18s 17 3 4m1s 1m20s 18 3 3m58s 1m19s 19 3 3m56s 1m18s 20 2 5m42s 2m51s 21 3 3m59s 1m19s 22 3 4m6s 1m22s [ User: intelifix - Total duration: 1h7m44s - Times executed: 47 ]
[ Application: psql - Total duration: 1h7m44s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-19 07:21:20 Duration: 4m28s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-19 20:19:19 Duration: 3m52s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-19 15:14:41 Duration: 3m38s Database: brasilia User: intelifix Remote: [local] Application: psql
5 36 35s951ms 589ms 6s846ms 998ms 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 Sep 19 08 3 8s656ms 2s885ms 09 3 2s614ms 871ms 10 2 1s622ms 811ms 11 2 1s640ms 820ms 12 3 2s699ms 899ms 13 2 1s504ms 752ms 14 3 2s579ms 859ms 15 1 895ms 895ms 16 2 1s706ms 853ms 17 3 2s306ms 768ms 18 3 2s368ms 789ms 19 2 1s670ms 835ms 20 2 1s695ms 847ms 21 2 1s670ms 835ms 22 3 2s319ms 773ms [ User: intelifix - Total duration: 35s951ms - Times executed: 36 ]
[ Application: psql - Total duration: 35s951ms - Times executed: 36 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-19 08:00:08 Duration: 6s846ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-19 12:40:02 Duration: 1s82ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-19 21:40:02 Duration: 954ms Database: rio User: intelifix Remote: [local] Application: psql
6 24 3m21s 277ms 1m10s 8s402ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 19 00 8 1m13s 9s136ms 03 4 1m19s 19s782ms 04 6 28s387ms 4s731ms 05 4 19s533ms 4s883ms 20 2 1s525ms 762ms [ User: intelifix - Total duration: 3m21s - Times executed: 24 ]
[ Application: psql - Total duration: 3m21s - Times executed: 24 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-19 03:46:11 Duration: 1m10s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-19 00:05:34 Duration: 33s561ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-19 00:55:19 Duration: 17s532ms Database: rio User: intelifix Remote: [local] Application: psql
7 15 2m2s 3s50ms 16s46ms 8s178ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 19 00 6 1m4s 10s684ms 03 6 47s573ms 7s928ms 06 3 11s1ms 3s667ms [ User: intelifix - Total duration: 2m2s - Times executed: 15 ]
[ Application: psql - Total duration: 2m2s - Times executed: 15 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-19 00:05:17 Duration: 16s46ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-19 00:05:30 Duration: 13s166ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-19 00:05:41 Duration: 11s171ms Database: contagem User: intelifix Remote: [local] Application: psql
8 10 4s115ms 150ms 1s219ms 411ms call rs_giga_tecnicos ();Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 19 00 3 2s117ms 705ms 04 2 1s125ms 562ms 20 5 872ms 174ms [ User: intelifix - Total duration: 4s115ms - Times executed: 10 ]
[ Application: psql - Total duration: 4s115ms - Times executed: 10 ]
-
CALL RS_GIGA_TECNICOS ();
Date: 2026-09-19 00:05:03 Duration: 1s219ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TECNICOS ();
Date: 2026-09-19 00:05:02 Duration: 729ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TECNICOS ();
Date: 2026-09-19 04:05:02 Duration: 642ms Database: brasilia User: intelifix Remote: [local] Application: psql
9 9 1m6s 377ms 20s321ms 7s441ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 19 00 3 31s805ms 10s601ms 03 3 31s163ms 10s387ms 06 3 4s7ms 1s335ms [ User: lenon - Total duration: 1m6s - Times executed: 9 ]
[ Application: psql - Total duration: 1m6s - Times executed: 9 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-09-19 03:36:47 Duration: 20s321ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-09-19 00:02:22 Duration: 20s1ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-09-19 00:02:30 Duration: 8s206ms Database: brasilia User: lenon Remote: [local] Application: psql
10 7 3s463ms 341ms 668ms 494ms 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 #10
Day Hour Count Duration Avg duration Sep 19 20 3 1s530ms 510ms 23 4 1s933ms 483ms [ User: intelifix - Total duration: 3s463ms - Times executed: 7 ]
[ Application: pg_dump - Total duration: 3s463ms - Times executed: 7 ]
-
SELECT p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, p.proacl, acldefault('f', p.proowner) AS acldefault, p.pronamespace, p.proowner FROM pg_proc p LEFT JOIN pg_init_privs pip ON (p.oid = pip.objoid AND pip.classoid = 'pg_proc'::regclass AND pip.objsubid = 0) WHERE p.prokind <> 'a' AND NOT EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_proc'::regclass AND objid = p.oid AND deptype = 'i') AND (pronamespace != ( SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog') OR EXISTS ( SELECT 1 FROM pg_cast WHERE pg_cast.oid > 16383 AND p.oid = pg_cast.castfunc) OR EXISTS ( SELECT 1 FROM pg_transform WHERE pg_transform.oid > 16383 AND (p.oid = pg_transform.trffromsql OR p.oid = pg_transform.trftosql)) OR p.proacl IS DISTINCT FROM pip.initprivs);
Date: 2026-09-19 20:02:04 Duration: 668ms 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-09-19 23:10:03 Duration: 630ms 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-09-19 23:17:20 Duration: 593ms Database: rio User: intelifix Remote: [local] Application: pg_dump
11 7 2s605ms 247ms 499ms 372ms 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 Sep 19 20 3 1s134ms 378ms 23 4 1s470ms 367ms [ User: intelifix - Total duration: 2s605ms - Times executed: 7 ]
[ Application: pg_dump - Total duration: 2s605ms - Times executed: 7 ]
-
SELECT c.tableoid, c.oid, c.relname, c.relnamespace, c.relkind, c.reltype, c.relowner, c.relchecks, c.relhasindex, c.relhasrules, c.relpages, c.reltuples, c.relallvisible, c.relallfrozen, c.relhastriggers, c.relpersistence, c.reloftype, c.relacl, acldefault( CASE WHEN c.relkind = 'S' THEN 's'::"char" ELSE 'r'::"char" END, c.relowner) AS acldefault, CASE WHEN c.relkind = 'f' THEN ( SELECT ftserver FROM pg_catalog.pg_foreign_table WHERE ftrelid = c.oid) ELSE 0 END AS foreignserver, c.relfrozenxid, tc.relfrozenxid AS tfrozenxid, tc.oid AS toid, tc.relpages AS toastpages, tc.reloptions AS toast_reloptions, d.refobjid AS owning_tab, d.refobjsubid AS owning_col, tsp.spcname AS reltablespace, false AS relhasoids, c.relispopulated, c.relreplident, c.relrowsecurity, c.relforcerowsecurity, c.relminmxid, tc.relminmxid AS tminmxid, array_remove(array_remove(c.reloptions, 'check_option=local'), 'check_option=cascaded') AS reloptions, CASE WHEN 'check_option=local' = ANY (c.reloptions) THEN 'LOCAL'::text WHEN 'check_option=cascaded' = ANY (c.reloptions) THEN 'CASCADED'::text ELSE NULL END AS checkoption, am.amname, (d.deptype = 'i') IS TRUE AS is_identity_sequence, c.relispartition AS ispartition FROM pg_class c LEFT JOIN pg_depend d ON (c.relkind = 'S' AND d.classid = 'pg_class'::regclass AND d.objid = c.oid AND d.objsubid = 0 AND d.refclassid = 'pg_class'::regclass AND d.deptype IN ('a', 'i')) LEFT JOIN pg_tablespace tsp ON (tsp.oid = c.reltablespace) LEFT JOIN pg_am am ON (c.relam = am.oid) LEFT JOIN pg_class tc ON (c.reltoastrelid = tc.oid AND tc.relkind = 't' AND c.relkind <> 'p') WHERE c.relkind IN ('r', 'S', 'v', 'c', 'm', 'f', 'p') ORDER BY c.oid;
Date: 2026-09-19 20:09:22 Duration: 499ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
SELECT c.tableoid, c.oid, c.relname, c.relnamespace, c.relkind, c.reltype, c.relowner, c.relchecks, c.relhasindex, c.relhasrules, c.relpages, c.reltuples, c.relallvisible, c.relallfrozen, c.relhastriggers, c.relpersistence, c.reloftype, c.relacl, acldefault( CASE WHEN c.relkind = 'S' THEN 's'::"char" ELSE 'r'::"char" END, c.relowner) AS acldefault, CASE WHEN c.relkind = 'f' THEN ( SELECT ftserver FROM pg_catalog.pg_foreign_table WHERE ftrelid = c.oid) ELSE 0 END AS foreignserver, c.relfrozenxid, tc.relfrozenxid AS tfrozenxid, tc.oid AS toid, tc.relpages AS toastpages, tc.reloptions AS toast_reloptions, d.refobjid AS owning_tab, d.refobjsubid AS owning_col, tsp.spcname AS reltablespace, false AS relhasoids, c.relispopulated, c.relreplident, c.relrowsecurity, c.relforcerowsecurity, c.relminmxid, tc.relminmxid AS tminmxid, array_remove(array_remove(c.reloptions, 'check_option=local'), 'check_option=cascaded') AS reloptions, CASE WHEN 'check_option=local' = ANY (c.reloptions) THEN 'LOCAL'::text WHEN 'check_option=cascaded' = ANY (c.reloptions) THEN 'CASCADED'::text ELSE NULL END AS checkoption, am.amname, (d.deptype = 'i') IS TRUE AS is_identity_sequence, c.relispartition AS ispartition FROM pg_class c LEFT JOIN pg_depend d ON (c.relkind = 'S' AND d.classid = 'pg_class'::regclass AND d.objid = c.oid AND d.objsubid = 0 AND d.refclassid = 'pg_class'::regclass AND d.deptype IN ('a', 'i')) LEFT JOIN pg_tablespace tsp ON (tsp.oid = c.reltablespace) LEFT JOIN pg_am am ON (c.relam = am.oid) LEFT JOIN pg_class tc ON (c.reltoastrelid = tc.oid AND tc.relkind = 't' AND c.relkind <> 'p') WHERE c.relkind IN ('r', 'S', 'v', 'c', 'm', 'f', 'p') ORDER BY c.oid;
Date: 2026-09-19 23:10:02 Duration: 404ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
SELECT c.tableoid, c.oid, c.relname, c.relnamespace, c.relkind, c.reltype, c.relowner, c.relchecks, c.relhasindex, c.relhasrules, c.relpages, c.reltuples, c.relallvisible, c.relallfrozen, c.relhastriggers, c.relpersistence, c.reloftype, c.relacl, acldefault( CASE WHEN c.relkind = 'S' THEN 's'::"char" ELSE 'r'::"char" END, c.relowner) AS acldefault, CASE WHEN c.relkind = 'f' THEN ( SELECT ftserver FROM pg_catalog.pg_foreign_table WHERE ftrelid = c.oid) ELSE 0 END AS foreignserver, c.relfrozenxid, tc.relfrozenxid AS tfrozenxid, tc.oid AS toid, tc.relpages AS toastpages, tc.reloptions AS toast_reloptions, d.refobjid AS owning_tab, d.refobjsubid AS owning_col, tsp.spcname AS reltablespace, false AS relhasoids, c.relispopulated, c.relreplident, c.relrowsecurity, c.relforcerowsecurity, c.relminmxid, tc.relminmxid AS tminmxid, array_remove(array_remove(c.reloptions, 'check_option=local'), 'check_option=cascaded') AS reloptions, CASE WHEN 'check_option=local' = ANY (c.reloptions) THEN 'LOCAL'::text WHEN 'check_option=cascaded' = ANY (c.reloptions) THEN 'CASCADED'::text ELSE NULL END AS checkoption, am.amname, (d.deptype = 'i') IS TRUE AS is_identity_sequence, c.relispartition AS ispartition FROM pg_class c LEFT JOIN pg_depend d ON (c.relkind = 'S' AND d.classid = 'pg_class'::regclass AND d.objid = c.oid AND d.objsubid = 0 AND d.refclassid = 'pg_class'::regclass AND d.deptype IN ('a', 'i')) LEFT JOIN pg_tablespace tsp ON (tsp.oid = c.reltablespace) LEFT JOIN pg_am am ON (c.relam = am.oid) LEFT JOIN pg_class tc ON (c.reltoastrelid = tc.oid AND tc.relkind = 't' AND c.relkind <> 'p') WHERE c.relkind IN ('r', 'S', 'v', 'c', 'm', 'f', 'p') ORDER BY c.oid;
Date: 2026-09-19 20:02:03 Duration: 388ms Database: rio User: intelifix Remote: [local] Application: pg_dump
12 7 2s517ms 167ms 629ms 359ms select * from rs_equipamento_consulta (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 19 00 5 1s711ms 342ms 05 1 425ms 425ms 13 1 381ms 381ms [ User: intelifix - Total duration: 2s517ms - Times executed: 7 ]
[ Application: [unknown] - Total duration: 2s517ms - Times executed: 7 ]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('544D4242006D7376');
Date: 2026-09-19 00:12:11 Duration: 629ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('4857544354642AB6');
Date: 2026-09-19 05:35:31 Duration: 425ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('ZTEGD7BAD605');
Date: 2026-09-19 00:20:31 Duration: 409ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 6 1m46s 3s89ms 39s856ms 17s819ms 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 Sep 19 20 3 53s337ms 17s779ms 23 3 53s580ms 17s860ms [ User: intelifix - Total duration: 1m46s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m46s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-09-19 23:14:29 Duration: 39s856ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-09-19 20:06:31 Duration: 39s824ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-09-19 23:33:51 Duration: 10s528ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 6 1m23s 2s235ms 31s848ms 13s923ms 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 Sep 19 20 3 41s739ms 13s913ms 23 3 41s798ms 13s932ms [ User: intelifix - Total duration: 1m23s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m23s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-09-19 20:07:06 Duration: 31s848ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-09-19 23:15:04 Duration: 31s816ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-09-19 23:34:00 Duration: 7s683ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 6 1m22s 3s107ms 31s415ms 13s690ms 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 Sep 19 20 3 41s99ms 13s699ms 23 3 41s46ms 13s682ms [ User: intelifix - Total duration: 1m22s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m22s - Times executed: 6 ]
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-09-19 23:17:19 Duration: 31s415ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-09-19 20:09:20 Duration: 31s363ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-09-19 20:10:55 Duration: 6s627ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 6 1m11s 2s468ms 23s475ms 11s945ms 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 Sep 19 20 3 35s695ms 11s898ms 23 3 35s979ms 11s993ms [ User: intelifix - Total duration: 1m11s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m11s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-19 23:10:50 Duration: 23s475ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-19 20:02:50 Duration: 23s448ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-19 23:33:09 Duration: 10s35ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 6 1m11s 2s258ms 24s380ms 11s867ms 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 Sep 19 20 3 35s822ms 11s940ms 23 3 35s380ms 11s793ms [ User: intelifix - Total duration: 1m11s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m11s - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-19 20:03:31 Duration: 24s380ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-19 23:11:31 Duration: 23s925ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-19 23:33:20 Duration: 9s196ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 6 1m3s 1s719ms 25s81ms 10s637ms 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 #18
Day Hour Count Duration Avg duration Sep 19 20 3 31s843ms 10s614ms 23 3 31s979ms 10s659ms [ User: intelifix - Total duration: 1m3s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m3s - Times executed: 6 ]
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-09-19 20:04:30 Duration: 25s81ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-09-19 23:12:29 Duration: 25s12ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-09-19 23:33:36 Duration: 5s247ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 6 51s544ms 1s818ms 16s742ms 8s590ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 19 20 3 25s631ms 8s543ms 23 3 25s912ms 8s637ms [ User: intelifix - Total duration: 51s544ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 51s544ms - Times executed: 6 ]
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-09-19 20:03:48 Duration: 16s742ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-09-19 23:11:47 Duration: 16s637ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-09-19 23:33:28 Duration: 7s442ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 6 41s49ms 1s102ms 16s974ms 6s841ms 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 #20
Day Hour Count Duration Avg duration Sep 19 20 3 20s434ms 6s811ms 23 3 20s614ms 6s871ms [ User: intelifix - Total duration: 41s49ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 41s49ms - 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-09-19 23:11:07 Duration: 16s974ms 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-09-19 20:03:07 Duration: 16s796ms 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-09-19 23:33:11 Duration: 2s537ms 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 3m8s 11m43s 7m27s 3 22m22s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 19 05 3 22m22s 7m27s [ User: intelifix - Total duration: 22m22s - Times executed: 3 ]
[ Application: psql - Total duration: 22m22s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-19 05:11:45 Duration: 11m43s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-19 05:19:15 Duration: 7m30s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-19 05:22:23 Duration: 3m8s Database: contagem User: intelifix Remote: [local] Application: psql
2 1s435ms 9m19s 2m1s 48 1h36m51s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 19 07 3 10m16s 3m25s 08 3 5m30s 1m50s 09 3 5m28s 1m49s 10 3 5m26s 1m48s 11 3 5m24s 1m48s 12 3 5m25s 1m48s 13 3 5m24s 1m48s 14 3 5m37s 1m52s 15 3 5m31s 1m50s 16 3 5m24s 1m48s 17 3 5m29s 1m49s 18 3 5m29s 1m49s 19 3 5m27s 1m49s 20 3 8m42s 2m54s 21 3 6m48s 2m16s 22 3 5m25s 1m48s [ User: intelifix - Total duration: 1h36m51s - Times executed: 48 ]
[ Application: psql - Total duration: 1h36m51s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-19 07:14:20 Duration: 9m19s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-19 20:13:06 Duration: 8m4s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-19 21:11:33 Duration: 6m31s Database: rio User: intelifix Remote: [local] Application: psql
3 217ms 4m28s 1m26s 47 1h7m44s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 19 07 3 6m12s 2m4s 08 3 3m53s 1m17s 09 3 3m58s 1m19s 10 3 3m55s 1m18s 11 3 3m57s 1m19s 12 3 3m57s 1m19s 13 3 3m56s 1m18s 14 3 3m59s 1m19s 15 3 4m10s 1m23s 16 3 3m56s 1m18s 17 3 4m1s 1m20s 18 3 3m58s 1m19s 19 3 3m56s 1m18s 20 2 5m42s 2m51s 21 3 3m59s 1m19s 22 3 4m6s 1m22s [ User: intelifix - Total duration: 1h7m44s - Times executed: 47 ]
[ Application: psql - Total duration: 1h7m44s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-19 07:21:20 Duration: 4m28s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-19 20:19:19 Duration: 3m52s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-19 15:14:41 Duration: 3m38s Database: brasilia User: intelifix Remote: [local] Application: psql
4 1m22s 1m22s 1m22s 1 1m22s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 19 05 1 1m22s 1m22s [ User: intelifix - Total duration: 1m22s - Times executed: 1 ]
[ Application: psql - Total duration: 1m22s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-19 05:32:04 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-19 05:31:56 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
5 4s696ms 1m5s 35s98ms 4 2m20s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 19 20 2 1m9s 34s967ms 23 2 1m10s 35s228ms [ User: intelifix - Total duration: 2m20s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m20s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-19 23:16:47 Duration: 1m5s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-19 20:08:48 Duration: 1m5s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-19 23:34:17 Duration: 4s842ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 352ms 53s350ms 26s597ms 4 1m46s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 19 20 2 53s702ms 26s851ms 23 2 52s685ms 26s342ms [ User: intelifix - Total duration: 1m46s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m46s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-19 20:05:47 Duration: 53s350ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-19 23:13:45 Duration: 52s289ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-19 23:33:41 Duration: 396ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 3s89ms 39s856ms 17s819ms 6 1m46s copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 19 20 3 53s337ms 17s779ms 23 3 53s580ms 17s860ms [ User: intelifix - Total duration: 1m46s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m46s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-09-19 23:14:29 Duration: 39s856ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-09-19 20:06:31 Duration: 39s824ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-09-19 23:33:51 Duration: 10s528ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 2s235ms 31s848ms 13s923ms 6 1m23s 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 Sep 19 20 3 41s739ms 13s913ms 23 3 41s798ms 13s932ms [ User: intelifix - Total duration: 1m23s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m23s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-09-19 20:07:06 Duration: 31s848ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-09-19 23:15:04 Duration: 31s816ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-09-19 23:34:00 Duration: 7s683ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
9 4s226ms 23s314ms 13s755ms 4 55s20ms 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 Sep 19 20 2 27s646ms 13s823ms 23 2 27s374ms 13s687ms [ User: intelifix - Total duration: 55s20ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 55s20ms - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-09-19 20:04:54 Duration: 23s314ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-09-19 23:12:53 Duration: 23s147ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-09-19 20:10:13 Duration: 4s332ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 3s107ms 31s415ms 13s690ms 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 #10
Day Hour Count Duration Avg duration Sep 19 20 3 41s99ms 13s699ms 23 3 41s46ms 13s682ms [ User: intelifix - Total duration: 1m22s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m22s - Times executed: 6 ]
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-09-19 23:17:19 Duration: 31s415ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-09-19 20:09:20 Duration: 31s363ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-09-19 20:10:55 Duration: 6s627ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 2s468ms 23s475ms 11s945ms 6 1m11s 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 Sep 19 20 3 35s695ms 11s898ms 23 3 35s979ms 11s993ms [ User: intelifix - Total duration: 1m11s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m11s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-19 23:10:50 Duration: 23s475ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-19 20:02:50 Duration: 23s448ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-19 23:33:09 Duration: 10s35ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 2s258ms 24s380ms 11s867ms 6 1m11s 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 Sep 19 20 3 35s822ms 11s940ms 23 3 35s380ms 11s793ms [ User: intelifix - Total duration: 1m11s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m11s - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-19 20:03:31 Duration: 24s380ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-19 23:11:31 Duration: 23s925ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-09-19 23:33:20 Duration: 9s196ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 1s719ms 25s81ms 10s637ms 6 1m3s 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 #13
Day Hour Count Duration Avg duration Sep 19 20 3 31s843ms 10s614ms 23 3 31s979ms 10s659ms [ User: intelifix - Total duration: 1m3s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m3s - Times executed: 6 ]
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-09-19 20:04:30 Duration: 25s81ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-09-19 23:12:29 Duration: 25s12ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-09-19 23:33:36 Duration: 5s247ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 1s818ms 16s742ms 8s590ms 6 51s544ms 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 #14
Day Hour Count Duration Avg duration Sep 19 20 3 25s631ms 8s543ms 23 3 25s912ms 8s637ms [ User: intelifix - Total duration: 51s544ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 51s544ms - Times executed: 6 ]
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-09-19 20:03:48 Duration: 16s742ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-09-19 23:11:47 Duration: 16s637ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-09-19 23:33:28 Duration: 7s442ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 277ms 1m10s 8s402ms 24 3m21s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 19 00 8 1m13s 9s136ms 03 4 1m19s 19s782ms 04 6 28s387ms 4s731ms 05 4 19s533ms 4s883ms 20 2 1s525ms 762ms [ User: intelifix - Total duration: 3m21s - Times executed: 24 ]
[ Application: psql - Total duration: 3m21s - Times executed: 24 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-19 03:46:11 Duration: 1m10s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-19 00:05:34 Duration: 33s561ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-19 00:55:19 Duration: 17s532ms Database: rio User: intelifix Remote: [local] Application: psql
16 3s50ms 16s46ms 8s178ms 15 2m2s call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 19 00 6 1m4s 10s684ms 03 6 47s573ms 7s928ms 06 3 11s1ms 3s667ms [ User: intelifix - Total duration: 2m2s - Times executed: 15 ]
[ Application: psql - Total duration: 2m2s - Times executed: 15 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-19 00:05:17 Duration: 16s46ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-19 00:05:30 Duration: 13s166ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-09-19 00:05:41 Duration: 11s171ms Database: contagem User: intelifix Remote: [local] Application: psql
17 377ms 20s321ms 7s441ms 9 1m6s select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 19 00 3 31s805ms 10s601ms 03 3 31s163ms 10s387ms 06 3 4s7ms 1s335ms [ User: lenon - Total duration: 1m6s - Times executed: 9 ]
[ Application: psql - Total duration: 1m6s - Times executed: 9 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-09-19 03:36:47 Duration: 20s321ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-09-19 00:02:22 Duration: 20s1ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-09-19 00:02:30 Duration: 8s206ms Database: brasilia User: lenon Remote: [local] Application: psql
18 1s102ms 16s974ms 6s841ms 6 41s49ms 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 Sep 19 20 3 20s434ms 6s811ms 23 3 20s614ms 6s871ms [ User: intelifix - Total duration: 41s49ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 41s49ms - 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-09-19 23:11:07 Duration: 16s974ms 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-09-19 20:03:07 Duration: 16s796ms 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-09-19 23:33:11 Duration: 2s537ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 167ms 11s989ms 2s157ms 130 4m40s call rs_giga_triagem (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 19 00 10 34s771ms 3s477ms 03 4 13s861ms 3s465ms 04 6 9s854ms 1s642ms 05 6 10s305ms 1s717ms 06 6 10s946ms 1s824ms 07 6 11s27ms 1s837ms 08 6 10s982ms 1s830ms 09 6 10s951ms 1s825ms 10 6 10s982ms 1s830ms 11 6 10s694ms 1s782ms 12 6 11s339ms 1s889ms 13 6 10s778ms 1s796ms 14 6 10s789ms 1s798ms 15 6 11s243ms 1s873ms 16 6 11s325ms 1s887ms 17 6 11s214ms 1s869ms 18 6 11s292ms 1s882ms 19 6 11s18ms 1s836ms 20 8 34s965ms 4s370ms 21 6 10s942ms 1s823ms 22 6 11s151ms 1s858ms [ User: intelifix - Total duration: 4m40s - Times executed: 130 ]
[ Application: psql - Total duration: 4m40s - Times executed: 130 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-19 20:05:14 Duration: 11s989ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-19 00:55:31 Duration: 11s751ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-19 00:05:45 Duration: 10s545ms Database: rio User: intelifix Remote: [local] Application: psql
20 589ms 6s846ms 998ms 36 35s951ms call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 19 08 3 8s656ms 2s885ms 09 3 2s614ms 871ms 10 2 1s622ms 811ms 11 2 1s640ms 820ms 12 3 2s699ms 899ms 13 2 1s504ms 752ms 14 3 2s579ms 859ms 15 1 895ms 895ms 16 2 1s706ms 853ms 17 3 2s306ms 768ms 18 3 2s368ms 789ms 19 2 1s670ms 835ms 20 2 1s695ms 847ms 21 2 1s670ms 835ms 22 3 2s319ms 773ms [ User: intelifix - Total duration: 35s951ms - Times executed: 36 ]
[ Application: psql - Total duration: 35s951ms - Times executed: 36 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-19 08:00:08 Duration: 6s846ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-19 12:40:02 Duration: 1s82ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-19 21:40:02 Duration: 954ms Database: rio User: intelifix Remote: [local] Application: psql
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 11 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Sep 19 11 1 0ms 0ms 12 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 2 0ms 0ms [ User: intelifix - Total duration: 16m38s - Times executed: 11 ]
[ Application: psql - Total duration: 16m38s - Times executed: 11 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 4,516 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 32 FATAL entries
- 1271 ERROR entries
- 0 WARNING entries
- 3 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 1,267 Max number of times the same event was reported
- 1,306 Total events found
Rank Times reported Error 1 1,267 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Sep 19 00 59 01 1 03 27 04 60 05 59 06 59 07 60 08 59 09 60 10 59 11 60 12 60 13 60 14 59 15 60 16 59 17 60 18 59 19 60 20 59 21 59 22 60 23 49 - ERROR: prepared statement "_PLAN0000000029DEBB30" does not exist
- ERROR: prepared statement "_PLAN0000000029DE4DB0" does not exist
- ERROR: prepared statement "_PLAN0000000029DE9FD0" does not exist
Statement: DEALLOCATE "_PLAN0000000029DEBB30"
Date: 2026-09-19 00:00:11 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029DE4DB0"
Date: 2026-09-19 00:01:12 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029DE9FD0"
Date: 2026-09-19 00:02:13 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 23 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #2
Day Hour Count Sep 19 00 14 01 8 03 1 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-09-19 00:46:55 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-19 00:46:55 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-19 00:46:55 Database: brasilia Application: [unknown] User: lenon Remote: [local]
3 8 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count Sep 19 00 1 03 1 06 1 16 2 22 2 23 1 - FATAL: database "testes" does not exist
- FATAL: database "testes" does not exist
- FATAL: database "testes" does not exist
Date: 2026-09-19 00:02:34 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-09-19 03:36:58 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-09-19 06:02:06 Database: testes Application: [unknown] User: lenon Remote: [local]
4 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Sep 19 05 4 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-19 05:32:04 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-19 05:32:04 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-19 05:32:04 Database: contagem Application: psql User: intelifix Remote: [local]
5 3 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #5
Day Hour Count Sep 19 00 1 03 2 - LOG: database system was shut down at 2026-09-19 00:46:55 -03
- LOG: database system was shut down at 2026-09-19 01:01:07 -03
- LOG: database system was shut down at 2026-09-19 03:09:17 -03
Date: 2026-09-19 00:48:39
Date: 2026-09-19 03:05:05
Date: 2026-09-19 03:36:12
6 1 FATAL: the database system is starting up
Times Reported Most Frequent Error / Event #6
Day Hour Count Sep 19 03 1 - FATAL: the database system is starting up
Date: 2026-09-19 03:36:12 Database: rio Application: [unknown] User: intelifix Remote: [local]