pgBadger-
Global information
- Generated on Mon Jun 1 23:50:08 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 11,395 log entries in 7s
- Log start from 2026-05-31 00:00:35 to 2026-05-31 23:59:59
-
Overview
Global Stats
- 142 Number of unique normalized queries
- 564 Number of queries
- 2h38m40s Total query duration
- 2026-05-31 00:02:11 First query
- 2026-05-31 23:59:59 Last query
- 4 queries/s at 2026-05-31 23:37:56 Query peak
- 2h38m40s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 2h38m40s Execute total duration
- 1,865 Number of events
- 7 Number of unique normalized events
- 1,426 Max number of times the same event was reported
- 0 Number of cancellation
- 6 Total number of automatic vacuums
- 0 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 153 Total number of sessions
- 6 sessions at 2026-05-31 12:22:26 Session peak
- 5d13h15m16s Total duration of sessions
- 52m15s Average duration of sessions
- 3 Average queries per session
- 1m2s Average queries duration per session
- 51m13s Average idle time per session
- 580 Total number of connections
- 5 connections/s at 2026-05-31 03:05:16 Connection peak
- 2 Total number of databases
SQL Traffic
Key values
- 4 queries/s Query Peak
- 2026-05-31 23:37:56 Date
SELECT Traffic
Key values
- 3 queries/s Query Peak
- 2026-05-31 23:36:29 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-05-31 23:37:56 Date
Queries duration
Key values
- 2h38m40s 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) May 31 00 14 0ms 21s998ms 6s35ms 2s437ms 2s895ms 58s119ms 01 6 0ms 3s138ms 2s694ms 2s416ms 2s734ms 3s138ms 02 6 0ms 2s957ms 2s440ms 2s143ms 2s521ms 2s957ms 03 8 0ms 2s914ms 2s60ms 2s309ms 2s706ms 3s360ms 04 6 0ms 2s823ms 2s435ms 2s161ms 2s422ms 2s823ms 05 8 0ms 8m28s 1m22s 2s641ms 2s854ms 8m28s 06 13 0ms 11s971ms 3s924ms 2s480ms 2s671ms 22s929ms 07 13 0ms 13m5s 1m9s 2s625ms 4s95ms 13m5s 08 13 0ms 5m22s 28s886ms 2s493ms 3s492ms 5m48s 09 13 0ms 5m4s 26s789ms 2s247ms 2s415ms 5m31s 10 13 0ms 4m51s 25s682ms 2s225ms 2s566ms 4m51s 11 13 0ms 5m2s 26s770ms 2s148ms 2s365ms 5m30s 12 13 0ms 5m2s 26s761ms 2s315ms 2s525ms 5m30s 13 13 0ms 4m58s 26s312ms 2s368ms 2s640ms 4m58s 14 13 0ms 5m35s 29s323ms 2s173ms 2s382ms 5m35s 15 13 0ms 5m6s 27s198ms 2s257ms 2s285ms 5m37s 16 13 0ms 5m9s 27s254ms 2s340ms 2s565ms 5m36s 17 13 0ms 5m15s 28s16ms 2s221ms 2s539ms 5m45s 18 14 0ms 4m59s 24s763ms 2s352ms 2s541ms 5m28s 19 13 0ms 5m20s 28s149ms 2s314ms 2s421ms 5m47s 20 65 0ms 5m20s 12s299ms 47s24ms 1m36s 5m47s 21 13 0ms 5m2s 27s58ms 2s366ms 2s801ms 5m33s 22 13 0ms 5m5s 26s892ms 2s254ms 2s315ms 5m32s 23 242 0ms 1m33s 8s261ms 1m12s 1m42s 1m58s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 31 00 3 0 4s640ms 0ms 0ms 290ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 1 0 167ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 5 0 3s88ms 0ms 0ms 1s296ms 07 7 0 2m6s 0ms 0ms 1m36s 08 4 0 1m27s 0ms 0ms 1s577ms 09 4 0 1m22s 0ms 0ms 0ms 10 4 0 1m19s 0ms 0ms 25s845ms 11 4 0 1m22s 0ms 0ms 0ms 12 4 0 1m22s 0ms 0ms 0ms 13 4 0 1m21s 0ms 0ms 26s637ms 14 4 0 1m31s 0ms 0ms 28s733ms 15 4 0 1m24s 0ms 0ms 0ms 16 4 0 1m24s 0ms 0ms 0ms 17 4 0 1m26s 0ms 0ms 1s336ms 18 5 0 1m5s 0ms 0ms 915ms 19 4 0 1m27s 0ms 0ms 1s368ms 20 6 50 13s944ms 0ms 47s24ms 1m56s 21 4 0 1m23s 0ms 0ms 0ms 22 4 0 1m23s 0ms 0ms 0ms 23 16 226 8s261ms 1m3s 1m12s 1m46s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 31 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare May 31 00 0 1 1.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 1 1.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 1 1.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 2 2.00 0.00% Day Hour Count Average / Second May 31 00 26 0.01/s 01 19 0.01/s 02 19 0.01/s 03 25 0.01/s 04 19 0.01/s 05 24 0.01/s 06 25 0.01/s 07 23 0.01/s 08 28 0.01/s 09 24 0.01/s 10 27 0.01/s 11 25 0.01/s 12 33 0.01/s 13 24 0.01/s 14 27 0.01/s 15 25 0.01/s 16 24 0.01/s 17 25 0.01/s 18 25 0.01/s 19 24 0.01/s 20 28 0.01/s 21 25 0.01/s 22 24 0.01/s 23 12 0.00/s Day Hour Count Average Duration Average idle time May 31 00 6 55m30s 55m16s 01 10 1h54s 1h52s 02 4 1h 59m57s 03 11 19m15s 19m14s 04 5 1h3m36s 1h3m33s 05 5 1h 57m48s 06 5 1h2s 59m52s 07 9 58m26s 56m46s 08 6 1h 58m57s 09 5 1h 58m50s 10 6 51m40s 50m44s 11 5 1h 58m51s 12 14 26m 25m35s 13 5 1h 58m52s 14 5 1h 58m44s 15 6 55m30s 54m31s 16 5 1h36s 59m25s 17 5 1h36s 59m23s 18 6 1h1m20s 1h22s 19 5 1h1m4s 59m51s 20 7 45m5s 43m11s 21 6 1h30s 59m31s 22 5 1h 58m50s 23 7 47m21s 42m35s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-05-31 03:05:16 Date
Connections per database
Key values
- brasilia Main Database
- 580 connections Total
Connections per user
Key values
- intelifix Main User
- 580 connections Total
-
Sessions
Simultaneous sessions
Key values
- 6 sessions Session Peak
- 2026-05-31 12:22:26 Date
Histogram of session times
Key values
- 125 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 153 sessions Total
Sessions per user
Key values
- intelifix Main User
- 153 sessions Total
Sessions per host
Key values
- [local] Main Host
- 153 sessions Total
Sessions per application
Key values
- [unknown] Main Application
- 153 sessions Total
Application Count Total Duration Average Duration [unknown] 124 4d20h2m20s 56m8s pgAdmin 4 - CONN:1884909 2 4s14ms 2s7ms pgAdmin 4 - CONN:5519315 2 3s947ms 1s973ms pgAdmin 4 - DB:contagem 1 8s620ms 8s620ms pgAdmin 4 - DB:postgres 1 23s943ms 23s943ms pgAdmin 4 - DB:rio 2 20s305ms 10s152ms pg_dump 4 35m48s 8m57s psql 17 16h36m6s 58m35s -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 7,171 buffers Checkpoint Peak
- 2026-05-31 03:05:01 Date
- 269.854 seconds Highest write time
- 0.004 seconds Sync time
Checkpoints Wal files
Key values
- 3 files Wal files usage Peak
- 2026-05-31 03:05:01 Date
Checkpoints distance
Key values
- 74.51 Mo Distance Peak
- 2026-05-31 03:05:01 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time May 31 00 7,079 269.854s 0.001s 269.861s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 7,171 0.353s 0.005s 0.369s 04 0 0s 0s 0s 05 4,384 438.506s 0.011s 438.538s 06 1,755 175.586s 0.002s 175.594s 07 898 90.141s 0.006s 90.159s 08 20 2.03s 0.003s 2.037s 09 22 2.253s 0.005s 2.267s 10 21 2.141s 0.004s 2.151s 11 136 13.668s 0.004s 13.678s 12 83 8.409s 0.01s 8.432s 13 24 2.445s 0.006s 2.461s 14 20 2.025s 0.003s 2.032s 15 22 2.248s 0.006s 2.261s 16 22 2.241s 0.004s 2.253s 17 20 2.026s 0.002s 2.032s 18 851 85.327s 0.009s 85.354s 19 23 2.326s 0.002s 2.332s 20 151 15.204s 0.008s 15.223s 21 22 2.235s 0.004s 2.246s 22 22 2.254s 0.005s 2.264s 23 397 53.434s 0.007s 53.461s Day Hour Added Removed Recycled Synced files Longest sync Average sync May 31 00 0 0 2 23 0.001s 0.001s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 3 21 0.002s 0.002s 04 0 0 0 0 0s 0s 05 0 0 2 109 0.003s 0.004s 06 0 0 0 11 0.002s 0.001s 07 0 0 0 24 0.003s 0.004s 08 0 0 0 3 0.002s 0.001s 09 0 0 0 5 0.002s 0.002s 10 0 0 0 5 0.002s 0.002s 11 0 0 0 7 0.002s 0.002s 12 0 0 0 23 0.002s 0.005s 13 0 0 0 6 0.003s 0.002s 14 0 0 0 3 0.002s 0.001s 15 0 0 0 5 0.002s 0.003s 16 0 0 0 5 0.002s 0.002s 17 0 0 0 3 0.002s 0.001s 18 0 0 1 35 0.002s 0.004s 19 0 0 0 4 0.001s 0.001s 20 0 0 0 22 0.002s 0.003s 21 0 0 0 5 0.002s 0.002s 22 0 0 0 5 0.002s 0.002s 23 0 0 0 55 0.002s 0.005s Day Hour Count Avg time (sec) May 31 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate May 31 00 36,598.00 kB 36,598.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 19,075.50 kB 19,075.50 kB 04 0.00 kB 0.00 kB 05 8,715.50 kB 11,829.00 kB 06 3,820.00 kB 16,727.00 kB 07 1,983.00 kB 14,127.33 kB 08 159.00 kB 11,427.00 kB 09 81.00 kB 9,779.00 kB 10 81.00 kB 7,940.00 kB 11 155.00 kB 6,451.00 kB 12 88.00 kB 4,760.75 kB 13 84.50 kB 3,474.00 kB 14 159.00 kB 2,983.00 kB 15 81.00 kB 2,559.50 kB 16 81.00 kB 2,088.50 kB 17 159.00 kB 1,803.00 kB 18 664.00 kB 1,911.50 kB 19 160.00 kB 1,501.00 kB 20 174.33 kB 1,250.00 kB 21 81.00 kB 988.50 kB 22 81.00 kB 816.00 kB 23 186.80 kB 639.40 kB -
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size May 31 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 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 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.25 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database rio - 2026-05-31 05:08:49 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 0.25 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database rio - 2026-05-31 05:08:49 Date
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- public.logs (2) Main table vacuumed on database rio
- 6 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.public.logs 2 0 0 0 0 0 0 648 237 315,063 195 4,869 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,807 530 1,951,712 472 3,313 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 122 30 77,529 3 6 rio.pg_catalog.pg_statistic 1 1 0 0 0 0 0 3,717 662 2,822,363 610 3,800 rio.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 781 139 870,162 86 288 Total 6 4 0 0 0 0 0 8,075 1,598 6,036,829 1,366 12,276 Vacuum throughput per table
Key values
- pg_catalog.pg_statistic (0.25) 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 (4356) Main table with removed tuples on database rio
- 8821 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_statistic 1 1 4,356 7,458 0 0 1,286 contagem.pg_catalog.pg_statistic 1 1 3,752 7,274 0 0 1,011 rio.pg_toast.pg_toast_2619 1 1 601 676 0 0 274 contagem.pg_toast.pg_toast_2619 1 1 112 111 0 0 54 rio.public.logs 2 0 0 31,550,714 0 0 1,260,643 Total 6 4 8,821 31,566,233 0 0 1,263,268 Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs May 31 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 4 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 1 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 1 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 - 0.25 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
- 95 Total read queries
- 276 Total write queries
Queries by database
Key values
- rio Main database
- 400 Requests
- 2h33m (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 554 Requests
User Request type Count Duration etiquetas Total 5 1s570ms select 5 1s570ms intelifix Total 554 2h38m11s copy to 276 40m25s others 193 18m29s select 85 1h39m15s lenon Total 5 28s211ms select 5 28s211ms Duration by user
Key values
- 2h38m11s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 5 1s570ms select 5 1s570ms intelifix Total 554 2h38m11s copy to 276 40m25s others 193 18m29s select 85 1h39m15s lenon Total 5 28s211ms select 5 28s211ms Queries by host
Key values
- [local] Main host
- 564 Requests
- 2h38m40s ([local])
- Main time consuming host
Queries by application
Key values
- pg_dump Main application
- 289 Requests
- 1h58m7s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-05-31 05:42:19 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 232 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 13m5s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-31 07:18:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 8m28s analyze verbose;[ Date: 2026-05-31 05:08:30 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 5m35s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-31 14:10:36 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 5m22s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-31 08:10:23 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 5m20s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-31 20:10:22 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 5m20s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-31 19:10:21 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 5m15s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-31 17:10:17 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 5m9s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-31 16:10:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 5m6s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-31 15:10:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 5m5s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-31 22:10:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 5m4s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-31 09:10:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m2s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-31 21:10:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 5m2s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-31 11:10:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m2s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-31 12:10:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 4m59s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-31 18:10:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 4m58s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-31 13:09:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 4m51s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-31 10:09:53 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 2m13s analyze verbose;[ Date: 2026-05-31 05:10:44 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
19 1m36s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-05-31 07:19:43 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 1m33s COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;[ Date: 2026-05-31 23:14:44 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1h30m41s 32 873ms 13m5s 2m50s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 31 07 2 13m8s 6m34s 08 2 5m23s 2m41s 09 2 5m5s 2m32s 10 2 4m52s 2m26s 11 2 5m3s 2m31s 12 2 5m3s 2m31s 13 2 4m58s 2m29s 14 2 5m36s 2m48s 15 2 5m7s 2m33s 16 2 5m11s 2m35s 17 2 5m16s 2m38s 18 2 5m 2m30s 19 2 5m21s 2m40s 20 2 5m21s 2m40s 21 2 5m3s 2m31s 22 2 5m6s 2m33s [ User: intelifix - Total duration: 1h30m41s - Times executed: 32 ]
[ Application: psql - Total duration: 1h30m41s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-31 07:18:07 Duration: 13m5s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-31 14:10:36 Duration: 5m35s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-31 08:10:23 Duration: 5m22s Database: rio User: intelifix Remote: [local] Application: psql
2 10m42s 2 2m13s 8m28s 5m21s analyze verbose;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 31 05 2 10m42s 5m21s [ User: intelifix - Total duration: 10m42s - Times executed: 2 ]
[ Application: psql - Total duration: 10m42s - Times executed: 2 ]
-
analyze verbose;
Date: 2026-05-31 05:08:30 Duration: 8m28s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-05-31 05:10:44 Duration: 2m13s Database: contagem User: intelifix Remote: [local] Application: psql
3 8m26s 32 424ms 1m36s 15s836ms select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 31 07 2 1m37s 48s972ms 08 2 27s275ms 13s637ms 09 2 26s129ms 13s64ms 10 2 24s817ms 12s408ms 11 2 26s904ms 13s452ms 12 2 26s937ms 13s468ms 13 2 25s678ms 12s839ms 14 2 27s743ms 13s871ms 15 2 29s713ms 14s856ms 16 2 25s582ms 12s791ms 17 2 30s217ms 15s108ms 18 2 27s242ms 13s621ms 19 2 27s684ms 13s842ms 20 2 27s321ms 13s660ms 21 2 29s445ms 14s722ms 22 2 26s136ms 13s68ms [ User: intelifix - Total duration: 8m26s - Times executed: 32 ]
[ Application: psql - Total duration: 8m26s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-31 07:19:43 Duration: 1m36s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-31 17:10:46 Duration: 29s792ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-31 15:10:36 Duration: 29s203ms Database: rio User: intelifix Remote: [local] Application: psql
4 5m52s 138 2s104ms 17s498ms 2s553ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration May 31 00 6 29s954ms 4s992ms 01 6 16s168ms 2s694ms 02 6 14s643ms 2s440ms 03 6 16s37ms 2s672ms 04 6 14s615ms 2s435ms 05 6 15s846ms 2s641ms 06 6 15s86ms 2s514ms 07 6 15s109ms 2s518ms 08 6 14s689ms 2s448ms 09 6 14s12ms 2s335ms 10 6 14s4ms 2s334ms 11 6 13s795ms 2s299ms 12 6 14s435ms 2s405ms 13 6 14s456ms 2s409ms 14 6 13s384ms 2s230ms 15 6 13s579ms 2s263ms 16 6 14s660ms 2s443ms 17 6 14s468ms 2s411ms 18 6 14s642ms 2s440ms 19 6 14s124ms 2s354ms 20 6 15s269ms 2s544ms 21 6 15s603ms 2s600ms 22 6 13s763ms 2s293ms [ User: intelifix - Total duration: 5m52s - Times executed: 138 ]
[ Application: psql - Total duration: 5m52s - Times executed: 138 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-31 00:05:19 Duration: 17s498ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-31 01:25:05 Duration: 3s138ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-31 20:35:04 Duration: 3s100ms Database: rio User: intelifix Remote: [local] Application: psql
5 3m17s 3 18s93ms 1m33s 1m5s copy auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration May 31 23 3 3m17s 1m5s [ User: intelifix - Total duration: 3m17s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 3m17s - Times executed: 3 ]
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-31 23:14:44 Duration: 1m33s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-31 23:59:41 Duration: 1m25s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-31.log
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-31 23:37:38 Duration: 18s93ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
6 2m52s 3 18s559ms 1m17s 57s578ms copy auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration May 31 23 3 2m52s 57s578ms [ User: intelifix - Total duration: 2m52s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 2m52s - Times executed: 3 ]
-
COPY auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-31 23:57:16 Duration: 1m17s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-31.log
-
COPY auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-31 23:12:13 Duration: 1m16s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-31 23:37:04 Duration: 18s559ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
7 2m46s 2 1m17s 1m28s 1m23s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration May 31 20 1 1m28s 1m28s 23 1 1m17s 1m17s [ User: intelifix - Total duration: 2m46s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m46s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-31 20:08:27 Duration: 1m28s 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-05-31 23:36:02 Duration: 1m17s Database: rio User: intelifix Remote: [local] Application: pg_dump
8 2m13s 3 16s12ms 59s388ms 44s418ms copy auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration May 31 23 3 2m13s 44s418ms [ User: intelifix - Total duration: 2m13s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 2m13s - Times executed: 3 ]
-
COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-31 23:58:15 Duration: 59s388ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-31.log
-
COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-31 23:13:11 Duration: 57s855ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-31 23:37:20 Duration: 16s12ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
9 2m1s 3 14s597ms 53s985ms 40s540ms copy auditor.auditor_2026_02 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration May 31 23 3 2m1s 40s540ms [ User: intelifix - Total duration: 2m1s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 2m1s - Times executed: 3 ]
-
COPY auditor.auditor_2026_02 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-31 23:55:58 Duration: 53s985ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-31.log
-
COPY auditor.auditor_2026_02 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-31 23:10:57 Duration: 53s38ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_02 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-31 23:36:45 Duration: 14s597ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
10 1m45s 2 47s413ms 58s544ms 52s979ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration May 31 20 1 58s544ms 58s544ms 23 1 47s413ms 47s413ms [ User: intelifix - Total duration: 1m45s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m45s - Times executed: 2 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-31 20:05:21 Duration: 58s544ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-31 23:17:40 Duration: 47s413ms Database: rio User: intelifix Remote: [local] Application: pg_dump
11 1m3s 4 1s963ms 30s517ms 15s827ms 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 #11
Day Hour Count Duration Avg duration May 31 20 2 32s556ms 16s278ms 23 2 30s752ms 15s376ms [ User: intelifix - Total duration: 1m3s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m3s - Times executed: 4 ]
-
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-05-31 20:05:53 Duration: 30s517ms 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-05-31 23:18:11 Duration: 28s788ms 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-05-31 20:09:09 Duration: 2s38ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
12 1m 4 8s517ms 21s998ms 15s80ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration May 31 00 2 39s834ms 19s917ms 06 2 20s488ms 10s244ms [ User: intelifix - Total duration: 1m - Times executed: 4 ]
[ Application: psql - Total duration: 1m - Times executed: 4 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-05-31 00:05:23 Duration: 21s998ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-05-31 00:05:52 Duration: 17s835ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-05-31 06:05:13 Duration: 11s971ms Database: rio User: intelifix Remote: [local] Application: psql
13 55s576ms 4 1s380ms 27s208ms 13s894ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration May 31 20 2 28s760ms 14s380ms 23 2 26s815ms 13s407ms [ User: intelifix - Total duration: 55s576ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 55s576ms - Times executed: 4 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-31 20:06:24 Duration: 27s208ms 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-05-31 23:18:40 Duration: 25s434ms 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-05-31 20:09:11 Duration: 1s552ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
14 55s77ms 4 2s522ms 25s718ms 13s769ms copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration May 31 20 2 26s837ms 13s418ms 23 2 28s240ms 14s120ms [ User: intelifix - Total duration: 55s77ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 55s77ms - Times executed: 4 ]
-
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-05-31 23:36:28 Duration: 25s718ms 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-05-31 20:08:51 Duration: 23s717ms 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-05-31 20:09:18 Duration: 3s119ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
15 52s885ms 45 700ms 5s782ms 1s175ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration May 31 08 3 10s377ms 3s459ms 09 3 2s863ms 954ms 10 3 2s857ms 952ms 11 3 3s454ms 1s151ms 12 3 2s972ms 990ms 13 3 2s963ms 987ms 14 3 3s143ms 1s47ms 15 3 2s793ms 931ms 16 3 2s992ms 997ms 17 3 3s19ms 1s6ms 18 3 3s52ms 1s17ms 19 3 3s12ms 1s4ms 20 3 3s315ms 1s105ms 21 3 2s845ms 948ms 22 3 3s222ms 1s74ms [ User: intelifix - Total duration: 52s885ms - Times executed: 45 ]
[ Application: psql - Total duration: 52s885ms - Times executed: 45 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-05-31 08:40:07 Duration: 5s782ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-05-31 08:00:05 Duration: 3s492ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-05-31 11:00:03 Duration: 1s563ms Database: rio User: intelifix Remote: [local] Application: psql
16 42s418ms 4 1s611ms 21s420ms 10s604ms 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 May 31 20 2 23s31ms 11s515ms 23 2 19s386ms 9s693ms [ User: intelifix - Total duration: 42s418ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 42s418ms - Times executed: 4 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-31 20:02:43 Duration: 21s420ms 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-05-31 23:15:19 Duration: 17s750ms 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-05-31 23:37:44 Duration: 1s635ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
17 41s74ms 4 1s73ms 20s283ms 10s268ms 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 #17
Day Hour Count Duration Avg duration May 31 20 2 21s607ms 10s803ms 23 2 19s466ms 9s733ms [ User: intelifix - Total duration: 41s74ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 41s74ms - Times executed: 4 ]
-
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-05-31 20:04:04 Duration: 20s283ms 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-05-31 23:16:35 Duration: 18s393ms 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-05-31 20:09:07 Duration: 1s323ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
18 39s648ms 4 1s332ms 19s87ms 9s912ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 31 20 2 20s597ms 10s298ms 23 2 19s50ms 9s525ms [ User: intelifix - Total duration: 39s648ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 39s648ms - Times executed: 4 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-31 20:03:15 Duration: 19s87ms 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-05-31 23:15:50 Duration: 17s718ms 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-05-31 20:09:02 Duration: 1s509ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
19 36s852ms 2 17s972ms 18s879ms 18s426ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration May 31 20 1 18s879ms 18s879ms 23 1 17s972ms 17s972ms [ User: intelifix - Total duration: 36s852ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 36s852ms - Times executed: 2 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-05-31 20:04:23 Duration: 18s879ms 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-05-31 23:16:53 Duration: 17s972ms Database: rio User: intelifix Remote: [local] Application: pg_dump
20 28s480ms 4 1s98ms 13s258ms 7s120ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 31 20 2 14s558ms 7s279ms 23 2 13s922ms 6s961ms [ User: intelifix - Total duration: 28s480ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 28s480ms - Times executed: 4 ]
-
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-05-31 20:03:29 Duration: 13s258ms 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-05-31 23:16:02 Duration: 12s823ms 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-05-31 20:09:04 Duration: 1s299ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 138 5m52s 2s104ms 17s498ms 2s553ms call rs_giga_triagem (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 31 00 6 29s954ms 4s992ms 01 6 16s168ms 2s694ms 02 6 14s643ms 2s440ms 03 6 16s37ms 2s672ms 04 6 14s615ms 2s435ms 05 6 15s846ms 2s641ms 06 6 15s86ms 2s514ms 07 6 15s109ms 2s518ms 08 6 14s689ms 2s448ms 09 6 14s12ms 2s335ms 10 6 14s4ms 2s334ms 11 6 13s795ms 2s299ms 12 6 14s435ms 2s405ms 13 6 14s456ms 2s409ms 14 6 13s384ms 2s230ms 15 6 13s579ms 2s263ms 16 6 14s660ms 2s443ms 17 6 14s468ms 2s411ms 18 6 14s642ms 2s440ms 19 6 14s124ms 2s354ms 20 6 15s269ms 2s544ms 21 6 15s603ms 2s600ms 22 6 13s763ms 2s293ms [ User: intelifix - Total duration: 5m52s - Times executed: 138 ]
[ Application: psql - Total duration: 5m52s - Times executed: 138 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-31 00:05:19 Duration: 17s498ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-31 01:25:05 Duration: 3s138ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-31 20:35:04 Duration: 3s100ms Database: rio User: intelifix Remote: [local] Application: psql
2 45 52s885ms 700ms 5s782ms 1s175ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 31 08 3 10s377ms 3s459ms 09 3 2s863ms 954ms 10 3 2s857ms 952ms 11 3 3s454ms 1s151ms 12 3 2s972ms 990ms 13 3 2s963ms 987ms 14 3 3s143ms 1s47ms 15 3 2s793ms 931ms 16 3 2s992ms 997ms 17 3 3s19ms 1s6ms 18 3 3s52ms 1s17ms 19 3 3s12ms 1s4ms 20 3 3s315ms 1s105ms 21 3 2s845ms 948ms 22 3 3s222ms 1s74ms [ User: intelifix - Total duration: 52s885ms - Times executed: 45 ]
[ Application: psql - Total duration: 52s885ms - Times executed: 45 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-05-31 08:40:07 Duration: 5s782ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-05-31 08:00:05 Duration: 3s492ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-05-31 11:00:03 Duration: 1s563ms Database: rio User: intelifix Remote: [local] Application: psql
3 32 1h30m41s 873ms 13m5s 2m50s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 31 07 2 13m8s 6m34s 08 2 5m23s 2m41s 09 2 5m5s 2m32s 10 2 4m52s 2m26s 11 2 5m3s 2m31s 12 2 5m3s 2m31s 13 2 4m58s 2m29s 14 2 5m36s 2m48s 15 2 5m7s 2m33s 16 2 5m11s 2m35s 17 2 5m16s 2m38s 18 2 5m 2m30s 19 2 5m21s 2m40s 20 2 5m21s 2m40s 21 2 5m3s 2m31s 22 2 5m6s 2m33s [ User: intelifix - Total duration: 1h30m41s - Times executed: 32 ]
[ Application: psql - Total duration: 1h30m41s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-31 07:18:07 Duration: 13m5s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-31 14:10:36 Duration: 5m35s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-31 08:10:23 Duration: 5m22s Database: rio User: intelifix Remote: [local] Application: psql
4 32 8m26s 424ms 1m36s 15s836ms select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration May 31 07 2 1m37s 48s972ms 08 2 27s275ms 13s637ms 09 2 26s129ms 13s64ms 10 2 24s817ms 12s408ms 11 2 26s904ms 13s452ms 12 2 26s937ms 13s468ms 13 2 25s678ms 12s839ms 14 2 27s743ms 13s871ms 15 2 29s713ms 14s856ms 16 2 25s582ms 12s791ms 17 2 30s217ms 15s108ms 18 2 27s242ms 13s621ms 19 2 27s684ms 13s842ms 20 2 27s321ms 13s660ms 21 2 29s445ms 14s722ms 22 2 26s136ms 13s68ms [ User: intelifix - Total duration: 8m26s - Times executed: 32 ]
[ Application: psql - Total duration: 8m26s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-31 07:19:43 Duration: 1m36s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-31 17:10:46 Duration: 29s792ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-31 15:10:36 Duration: 29s203ms Database: rio User: intelifix Remote: [local] Application: psql
5 5 28s218ms 760ms 9s536ms 5s643ms copy public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration May 31 20 2 10s600ms 5s300ms 23 3 17s617ms 5s872ms [ User: intelifix - Total duration: 28s218ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 28s218ms - Times executed: 5 ]
-
COPY public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) TO stdout;
Date: 2026-05-31 20:02:18 Duration: 9s536ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) TO stdout;
Date: 2026-05-31 23:59:56 Duration: 8s797ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-31.log
-
COPY public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) TO stdout;
Date: 2026-05-31 23:14:58 Duration: 8s59ms Database: rio User: intelifix Remote: [local] Application: pg_dump
6 5 11s315ms 2s103ms 2s362ms 2s263ms copy ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration May 31 20 2 4s686ms 2s343ms 23 3 6s628ms 2s209ms [ User: intelifix - Total duration: 11s315ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 11s315ms - Times executed: 5 ]
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-05-31 20:02:07 Duration: 2s362ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-05-31 20:08:57 Duration: 2s324ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-05-31 23:14:48 Duration: 2s266ms Database: rio User: intelifix Remote: [local] Application: pg_dump
7 5 5s738ms 1s20ms 1s506ms 1s147ms copy ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration May 31 20 2 2s176ms 1s88ms 23 3 3s562ms 1s187ms [ User: intelifix - Total duration: 5s738ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 5s738ms - Times executed: 5 ]
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-31 23:59:43 Duration: 1s506ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-31.log
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-31 20:08:55 Duration: 1s96ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-31 20:02:05 Duration: 1s79ms Database: rio User: intelifix Remote: [local] Application: pg_dump
8 4 1m3s 1s963ms 30s517ms 15s827ms 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 May 31 20 2 32s556ms 16s278ms 23 2 30s752ms 15s376ms [ User: intelifix - Total duration: 1m3s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m3s - Times executed: 4 ]
-
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-05-31 20:05:53 Duration: 30s517ms 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-05-31 23:18:11 Duration: 28s788ms 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-05-31 20:09:09 Duration: 2s38ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
9 4 1m 8s517ms 21s998ms 15s80ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration May 31 00 2 39s834ms 19s917ms 06 2 20s488ms 10s244ms [ User: intelifix - Total duration: 1m - Times executed: 4 ]
[ Application: psql - Total duration: 1m - Times executed: 4 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-05-31 00:05:23 Duration: 21s998ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-05-31 00:05:52 Duration: 17s835ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-05-31 06:05:13 Duration: 11s971ms Database: rio User: intelifix Remote: [local] Application: psql
10 4 55s576ms 1s380ms 27s208ms 13s894ms 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 May 31 20 2 28s760ms 14s380ms 23 2 26s815ms 13s407ms [ User: intelifix - Total duration: 55s576ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 55s576ms - Times executed: 4 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-31 20:06:24 Duration: 27s208ms 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-05-31 23:18:40 Duration: 25s434ms 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-05-31 20:09:11 Duration: 1s552ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
11 4 55s77ms 2s522ms 25s718ms 13s769ms copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration May 31 20 2 26s837ms 13s418ms 23 2 28s240ms 14s120ms [ User: intelifix - Total duration: 55s77ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 55s77ms - Times executed: 4 ]
-
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-05-31 23:36:28 Duration: 25s718ms 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-05-31 20:08:51 Duration: 23s717ms 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-05-31 20:09:18 Duration: 3s119ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
12 4 42s418ms 1s611ms 21s420ms 10s604ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration May 31 20 2 23s31ms 11s515ms 23 2 19s386ms 9s693ms [ User: intelifix - Total duration: 42s418ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 42s418ms - Times executed: 4 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-31 20:02:43 Duration: 21s420ms 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-05-31 23:15:19 Duration: 17s750ms 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-05-31 23:37:44 Duration: 1s635ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
13 4 41s74ms 1s73ms 20s283ms 10s268ms 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 May 31 20 2 21s607ms 10s803ms 23 2 19s466ms 9s733ms [ User: intelifix - Total duration: 41s74ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 41s74ms - Times executed: 4 ]
-
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-05-31 20:04:04 Duration: 20s283ms 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-05-31 23:16:35 Duration: 18s393ms 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-05-31 20:09:07 Duration: 1s323ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
14 4 39s648ms 1s332ms 19s87ms 9s912ms 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 May 31 20 2 20s597ms 10s298ms 23 2 19s50ms 9s525ms [ User: intelifix - Total duration: 39s648ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 39s648ms - Times executed: 4 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-31 20:03:15 Duration: 19s87ms 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-05-31 23:15:50 Duration: 17s718ms 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-05-31 20:09:02 Duration: 1s509ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
15 4 28s480ms 1s98ms 13s258ms 7s120ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration May 31 20 2 14s558ms 7s279ms 23 2 13s922ms 6s961ms [ User: intelifix - Total duration: 28s480ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 28s480ms - Times executed: 4 ]
-
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-05-31 20:03:29 Duration: 13s258ms 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-05-31 23:16:02 Duration: 12s823ms 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-05-31 20:09:04 Duration: 1s299ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
16 4 28s52ms 722ms 13s451ms 7s13ms copy public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 31 20 2 14s174ms 7s87ms 23 2 13s878ms 6s939ms [ User: intelifix - Total duration: 28s52ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 28s52ms - Times executed: 4 ]
-
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-05-31 20:02:56 Duration: 13s451ms 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-05-31 23:15:32 Duration: 13s156ms 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-05-31 20:09:01 Duration: 722ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
17 4 27s774ms 3s489ms 10s654ms 6s943ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration May 31 00 2 13s630ms 6s815ms 06 2 14s143ms 7s71ms [ User: lenon - Total duration: 27s774ms - Times executed: 4 ]
[ Application: psql - Total duration: 27s774ms - Times executed: 4 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-05-31 06:02:12 Duration: 10s654ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-05-31 00:02:11 Duration: 10s16ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-05-31 00:02:15 Duration: 3s614ms Database: contagem User: lenon Remote: [local] Application: psql
18 4 22s57ms 652ms 10s607ms 5s514ms copy public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 31 20 2 11s491ms 5s745ms 23 2 10s565ms 5s282ms [ User: intelifix - Total duration: 22s57ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 22s57ms - Times executed: 4 ]
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-05-31 20:03:43 Duration: 10s607ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-05-31 23:16:17 Duration: 9s912ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-05-31 20:09:05 Duration: 884ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
19 4 19s765ms 2s903ms 8s73ms 4s941ms copy public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration May 31 20 2 10s977ms 5s488ms 23 2 8s788ms 4s394ms [ User: intelifix - Total duration: 19s765ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 19s765ms - Times executed: 4 ]
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-05-31 20:06:47 Duration: 8s73ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-05-31 23:34:33 Duration: 5s790ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-05-31 23:38:26 Duration: 2s998ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
20 4 9s311ms 495ms 4s241ms 2s327ms copy public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 31 20 2 4s574ms 2s287ms 23 2 4s737ms 2s368ms [ User: intelifix - Total duration: 9s311ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 9s311ms - Times executed: 4 ]
-
COPY public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) TO stdout;
Date: 2026-05-31 23:16:07 Duration: 4s241ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) TO stdout;
Date: 2026-05-31 20:03:33 Duration: 4s70ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) TO stdout;
Date: 2026-05-31 20:09:04 Duration: 503ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m13s 8m28s 5m21s 2 10m42s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 31 05 2 10m42s 5m21s [ User: intelifix - Total duration: 10m42s - Times executed: 2 ]
[ Application: psql - Total duration: 10m42s - Times executed: 2 ]
-
analyze verbose;
Date: 2026-05-31 05:08:30 Duration: 8m28s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-05-31 05:10:44 Duration: 2m13s Database: contagem User: intelifix Remote: [local] Application: psql
2 873ms 13m5s 2m50s 32 1h30m41s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 31 07 2 13m8s 6m34s 08 2 5m23s 2m41s 09 2 5m5s 2m32s 10 2 4m52s 2m26s 11 2 5m3s 2m31s 12 2 5m3s 2m31s 13 2 4m58s 2m29s 14 2 5m36s 2m48s 15 2 5m7s 2m33s 16 2 5m11s 2m35s 17 2 5m16s 2m38s 18 2 5m 2m30s 19 2 5m21s 2m40s 20 2 5m21s 2m40s 21 2 5m3s 2m31s 22 2 5m6s 2m33s [ User: intelifix - Total duration: 1h30m41s - Times executed: 32 ]
[ Application: psql - Total duration: 1h30m41s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-31 07:18:07 Duration: 13m5s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-31 14:10:36 Duration: 5m35s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-31 08:10:23 Duration: 5m22s Database: rio User: intelifix Remote: [local] Application: psql
3 1m17s 1m28s 1m23s 2 2m46s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 31 20 1 1m28s 1m28s 23 1 1m17s 1m17s [ User: intelifix - Total duration: 2m46s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m46s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-31 20:08:27 Duration: 1m28s 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-05-31 23:36:02 Duration: 1m17s Database: rio User: intelifix Remote: [local] Application: pg_dump
4 18s93ms 1m33s 1m5s 3 3m17s copy auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration May 31 23 3 3m17s 1m5s [ User: intelifix - Total duration: 3m17s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 3m17s - Times executed: 3 ]
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-31 23:14:44 Duration: 1m33s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-31 23:59:41 Duration: 1m25s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-31.log
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-31 23:37:38 Duration: 18s93ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
5 18s559ms 1m17s 57s578ms 3 2m52s copy auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration May 31 23 3 2m52s 57s578ms [ User: intelifix - Total duration: 2m52s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 2m52s - Times executed: 3 ]
-
COPY auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-31 23:57:16 Duration: 1m17s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-31.log
-
COPY auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-31 23:12:13 Duration: 1m16s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-31 23:37:04 Duration: 18s559ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
6 47s413ms 58s544ms 52s979ms 2 1m45s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration May 31 20 1 58s544ms 58s544ms 23 1 47s413ms 47s413ms [ User: intelifix - Total duration: 1m45s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m45s - Times executed: 2 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-31 20:05:21 Duration: 58s544ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-31 23:17:40 Duration: 47s413ms Database: rio User: intelifix Remote: [local] Application: pg_dump
7 16s12ms 59s388ms 44s418ms 3 2m13s copy auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration May 31 23 3 2m13s 44s418ms [ User: intelifix - Total duration: 2m13s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 2m13s - Times executed: 3 ]
-
COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-31 23:58:15 Duration: 59s388ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-31.log
-
COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-31 23:13:11 Duration: 57s855ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-31 23:37:20 Duration: 16s12ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
8 14s597ms 53s985ms 40s540ms 3 2m1s copy auditor.auditor_2026_02 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration May 31 23 3 2m1s 40s540ms [ User: intelifix - Total duration: 2m1s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 2m1s - Times executed: 3 ]
-
COPY auditor.auditor_2026_02 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-31 23:55:58 Duration: 53s985ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-31.log
-
COPY auditor.auditor_2026_02 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-31 23:10:57 Duration: 53s38ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_02 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-05-31 23:36:45 Duration: 14s597ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
9 17s972ms 18s879ms 18s426ms 2 36s852ms 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 May 31 20 1 18s879ms 18s879ms 23 1 17s972ms 17s972ms [ User: intelifix - Total duration: 36s852ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 36s852ms - Times executed: 2 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-05-31 20:04:23 Duration: 18s879ms 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-05-31 23:16:53 Duration: 17s972ms Database: rio User: intelifix Remote: [local] Application: pg_dump
10 424ms 1m36s 15s836ms 32 8m26s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration May 31 07 2 1m37s 48s972ms 08 2 27s275ms 13s637ms 09 2 26s129ms 13s64ms 10 2 24s817ms 12s408ms 11 2 26s904ms 13s452ms 12 2 26s937ms 13s468ms 13 2 25s678ms 12s839ms 14 2 27s743ms 13s871ms 15 2 29s713ms 14s856ms 16 2 25s582ms 12s791ms 17 2 30s217ms 15s108ms 18 2 27s242ms 13s621ms 19 2 27s684ms 13s842ms 20 2 27s321ms 13s660ms 21 2 29s445ms 14s722ms 22 2 26s136ms 13s68ms [ User: intelifix - Total duration: 8m26s - Times executed: 32 ]
[ Application: psql - Total duration: 8m26s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-31 07:19:43 Duration: 1m36s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-31 17:10:46 Duration: 29s792ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-31 15:10:36 Duration: 29s203ms Database: rio User: intelifix Remote: [local] Application: psql
11 1s963ms 30s517ms 15s827ms 4 1m3s 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 #11
Day Hour Count Duration Avg duration May 31 20 2 32s556ms 16s278ms 23 2 30s752ms 15s376ms [ User: intelifix - Total duration: 1m3s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m3s - Times executed: 4 ]
-
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-05-31 20:05:53 Duration: 30s517ms 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-05-31 23:18:11 Duration: 28s788ms 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-05-31 20:09:09 Duration: 2s38ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
12 8s517ms 21s998ms 15s80ms 4 1m call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration May 31 00 2 39s834ms 19s917ms 06 2 20s488ms 10s244ms [ User: intelifix - Total duration: 1m - Times executed: 4 ]
[ Application: psql - Total duration: 1m - Times executed: 4 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-05-31 00:05:23 Duration: 21s998ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-05-31 00:05:52 Duration: 17s835ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-05-31 06:05:13 Duration: 11s971ms Database: rio User: intelifix Remote: [local] Application: psql
13 1s380ms 27s208ms 13s894ms 4 55s576ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration May 31 20 2 28s760ms 14s380ms 23 2 26s815ms 13s407ms [ User: intelifix - Total duration: 55s576ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 55s576ms - Times executed: 4 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-31 20:06:24 Duration: 27s208ms 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-05-31 23:18:40 Duration: 25s434ms 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-05-31 20:09:11 Duration: 1s552ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
14 2s522ms 25s718ms 13s769ms 4 55s77ms copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration May 31 20 2 26s837ms 13s418ms 23 2 28s240ms 14s120ms [ User: intelifix - Total duration: 55s77ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 55s77ms - Times executed: 4 ]
-
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-05-31 23:36:28 Duration: 25s718ms 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-05-31 20:08:51 Duration: 23s717ms 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-05-31 20:09:18 Duration: 3s119ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
15 1s611ms 21s420ms 10s604ms 4 42s418ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration May 31 20 2 23s31ms 11s515ms 23 2 19s386ms 9s693ms [ User: intelifix - Total duration: 42s418ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 42s418ms - Times executed: 4 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-31 20:02:43 Duration: 21s420ms 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-05-31 23:15:19 Duration: 17s750ms 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-05-31 23:37:44 Duration: 1s635ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
16 1s73ms 20s283ms 10s268ms 4 41s74ms 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 May 31 20 2 21s607ms 10s803ms 23 2 19s466ms 9s733ms [ User: intelifix - Total duration: 41s74ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 41s74ms - Times executed: 4 ]
-
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-05-31 20:04:04 Duration: 20s283ms 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-05-31 23:16:35 Duration: 18s393ms 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-05-31 20:09:07 Duration: 1s323ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
17 1s332ms 19s87ms 9s912ms 4 39s648ms 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 May 31 20 2 20s597ms 10s298ms 23 2 19s50ms 9s525ms [ User: intelifix - Total duration: 39s648ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 39s648ms - Times executed: 4 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-31 20:03:15 Duration: 19s87ms 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-05-31 23:15:50 Duration: 17s718ms 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-05-31 20:09:02 Duration: 1s509ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
18 1s98ms 13s258ms 7s120ms 4 28s480ms 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 May 31 20 2 14s558ms 7s279ms 23 2 13s922ms 6s961ms [ User: intelifix - Total duration: 28s480ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 28s480ms - Times executed: 4 ]
-
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-05-31 20:03:29 Duration: 13s258ms 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-05-31 23:16:02 Duration: 12s823ms 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-05-31 20:09:04 Duration: 1s299ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
19 722ms 13s451ms 7s13ms 4 28s52ms 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 #19
Day Hour Count Duration Avg duration May 31 20 2 14s174ms 7s87ms 23 2 13s878ms 6s939ms [ User: intelifix - Total duration: 28s52ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 28s52ms - Times executed: 4 ]
-
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-05-31 20:02:56 Duration: 13s451ms 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-05-31 23:15:32 Duration: 13s156ms 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-05-31 20:09:01 Duration: 722ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
20 3s489ms 10s654ms 6s943ms 4 27s774ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 31 00 2 13s630ms 6s815ms 06 2 14s143ms 7s71ms [ User: lenon - Total duration: 27s774ms - Times executed: 4 ]
[ Application: psql - Total duration: 27s774ms - Times executed: 4 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-05-31 06:02:12 Duration: 10s654ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-05-31 00:02:11 Duration: 10s16ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-05-31 00:02:15 Duration: 3s614ms Database: contagem User: lenon 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 2 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration May 31 09 1 0ms 0ms 14 1 0ms 0ms [ User: intelifix - Total duration: 4s735ms - Times executed: 2 ]
[ Application: psql - Total duration: 4s735ms - Times executed: 2 ]
-
;
Date: Duration: 0ms Database: postgres User: rio Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 5,869 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 434 FATAL entries
- 1430 ERROR entries
- 0 WARNING entries
- 1 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 1,426 Max number of times the same event was reported
- 1,865 Total events found
Rank Times reported Error 1 1,426 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count May 31 00 59 01 59 02 60 03 59 04 60 05 59 06 59 07 59 08 60 09 59 10 60 11 59 12 60 13 59 14 60 15 59 16 60 17 59 18 60 19 59 20 60 21 59 22 60 23 59 - ERROR: prepared statement "_PLAN0000000029B02720" does not exist
- ERROR: prepared statement "_PLAN0000000029D0AF20" does not exist
- ERROR: prepared statement "_PLAN00000000299A1A60" does not exist
Statement: DEALLOCATE "_PLAN0000000029B02720"
Date: 2026-05-31 00:00:35 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029D0AF20"
Date: 2026-05-31 00:01:36 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN00000000299A1A60"
Date: 2026-05-31 00:02:37 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 427 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count May 31 00 16 01 15 02 14 03 14 04 14 05 19 06 16 07 17 08 23 09 19 10 21 11 19 12 20 13 19 14 21 15 20 16 19 17 19 18 20 19 19 20 20 21 20 22 19 23 4 - FATAL: database "brasilia" does not exist
- FATAL: database "testes" does not exist
- FATAL: database "brasilia" does not exist
Date: 2026-05-31 00:02:11 Database: brasilia Application: [unknown] User: lenon Remote: [local]
Date: 2026-05-31 00:02:15 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-05-31 00:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
3 5 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #3
Day Hour Count May 31 03 5 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-05-31 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-05-31 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-05-31 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
4 2 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count May 31 05 2 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-05-31 05:30:16 Database: contagem Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-05-31 05:30:16 Database: contagem Application: psql User: intelifix Remote: [local]
5 2 ERROR: could not connect to server "..."
Times Reported Most Frequent Error / Event #5
Day Hour Count May 31 05 2 - ERROR: could not connect to server "Brasilia"
- ERROR: could not connect to server "Brasilia"
Detail: connection to server at "localhost" (127.0.0.1), port 9276 failed: FATAL: database "brasilia" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;Date: 2026-05-31 05:30:01 Database: rio Application: psql User: intelifix Remote: [local]
Detail: connection to server at "localhost" (127.0.0.1), port 9276 failed: FATAL: database "brasilia" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;Date: 2026-05-31 05:30:01 Database: rio Application: psql User: intelifix Remote: [local]
6 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #6
Day Hour Count May 31 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-05-31 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-05-31 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
7 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #7
Day Hour Count May 31 03 1 - LOG: database system was shut down at 2026-05-31 03:05:01 -03
Date: 2026-05-31 03:05:02