pgBadger-
Global information
- Generated on Mon Jun 8 23:50:10 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 6,207 log entries in 8s
- Log start from 2026-06-07 00:02:01 to 2026-06-07 23:59:06
-
Overview
Global Stats
- 135 Number of unique normalized queries
- 497 Number of queries
- 2h34m1s Total query duration
- 2026-06-07 00:02:09 First query
- 2026-06-07 23:38:30 Last query
- 5 queries/s at 2026-06-07 23:38:19 Query peak
- 2h34m1s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 2h34m1s Execute total duration
- 467 Number of events
- 8 Number of unique normalized events
- 377 Max number of times the same event was reported
- 0 Number of cancellation
- 5 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
- 98 Total number of sessions
- 5 sessions at 2026-06-07 06:35:01 Session peak
- 3d13h24m44s Total duration of sessions
- 52m17s Average duration of sessions
- 5 Average queries per session
- 1m34s Average queries duration per session
- 50m43s Average idle time per session
- 513 Total number of connections
- 5 connections/s at 2026-06-07 00:05:01 Connection peak
- 2 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-06-07 23:38:19 Date
SELECT Traffic
Key values
- 3 queries/s Query Peak
- 2026-06-07 23:36:35 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-06-07 23:38:19 Date
Queries duration
Key values
- 2h34m1s 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) Jun 07 00 13 0ms 20s227ms 6s184ms 57s340ms 57s340ms 57s340ms 01 6 0ms 3s150ms 2s813ms 3s150ms 3s150ms 3s150ms 02 6 0ms 4s93ms 3s73ms 4s93ms 4s93ms 4s93ms 03 6 0ms 3s125ms 2s497ms 3s125ms 3s125ms 3s125ms 04 6 0ms 3s369ms 2s865ms 3s369ms 3s369ms 3s369ms 05 8 0ms 8m17s 1m20s 2m8s 8m17s 8m17s 06 10 0ms 10s851ms 4s296ms 22s314ms 22s314ms 22s314ms 07 10 0ms 13m32s 1m33s 13m32s 13m32s 13m32s 08 10 0ms 4m54s 33s806ms 27s559ms 4m54s 4m54s 09 10 0ms 5m6s 35s31ms 2s970ms 5m33s 5m33s 10 10 0ms 5m4s 34s800ms 3s75ms 5m31s 5m31s 11 10 0ms 5m10s 35s530ms 5m37s 5m37s 5m37s 12 10 0ms 5m6s 34s998ms 5m33s 5m33s 5m33s 13 10 0ms 5m4s 34s846ms 5m32s 5m32s 5m32s 14 10 0ms 5m4s 35s121ms 5m34s 5m34s 5m34s 15 10 0ms 5m2s 34s654ms 3s109ms 5m30s 5m30s 16 10 0ms 5m8s 35s290ms 5m36s 5m36s 5m36s 17 10 0ms 5m9s 35s383ms 5m36s 5m36s 5m36s 18 12 0ms 5m17s 30s517ms 3s36ms 5m45s 5m45s 19 10 0ms 5m30s 38s47ms 32s453ms 5m30s 5m30s 20 66 0ms 5m11s 12s53ms 1m52s 5m40s 5m40s 21 10 0ms 5m30s 37s795ms 29s935ms 5m30s 5m30s 22 10 0ms 5m8s 35s131ms 2s966ms 5m35s 5m35s 23 224 0ms 1m26s 7s591ms 1m20s 1m26s 2m2s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 07 00 2 0 4s373ms 0ms 8s746ms 8s746ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 2 0 3s642ms 0ms 7s284ms 7s284ms 07 4 0 3m50s 1m51s 13m32s 13m32s 08 4 0 1m20s 0ms 27s559ms 4m54s 09 4 0 1m23s 0ms 0ms 5m33s 10 4 0 1m22s 0ms 0ms 5m31s 11 4 0 1m24s 0ms 5m37s 5m37s 12 4 0 1m23s 0ms 5m33s 5m33s 13 4 0 1m23s 0ms 5m32s 5m32s 14 4 0 1m23s 0ms 5m34s 5m34s 15 4 0 1m22s 0ms 0ms 5m30s 16 4 0 1m24s 0ms 5m36s 5m36s 17 4 0 1m24s 0ms 5m36s 5m36s 18 6 0 58s126ms 1s548ms 1s656ms 5m45s 19 4 0 1m30s 0ms 32s453ms 5m30s 20 9 51 12s971ms 53s504ms 1m51s 5m40s 21 4 0 1m30s 0ms 29s935ms 5m30s 22 4 0 1m23s 0ms 0ms 5m35s 23 7 217 7s591ms 1m4s 1m20s 2m1s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 07 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 Jun 07 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 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 0 0.00 0.00% Day Hour Count Average / Second Jun 07 00 25 0.01/s 01 17 0.00/s 02 18 0.01/s 03 19 0.01/s 04 17 0.00/s 05 23 0.01/s 06 23 0.01/s 07 21 0.01/s 08 23 0.01/s 09 24 0.01/s 10 23 0.01/s 11 22 0.01/s 12 23 0.01/s 13 22 0.01/s 14 23 0.01/s 15 23 0.01/s 16 22 0.01/s 17 23 0.01/s 18 24 0.01/s 19 22 0.01/s 20 25 0.01/s 21 24 0.01/s 22 22 0.01/s 23 5 0.00/s Day Hour Count Average Duration Average idle time Jun 07 00 1 10m 8m40s 01 8 1h1m30s 1h1m28s 02 3 1h 59m54s 03 5 32m38s 32m35s 04 3 1h1m 1h54s 05 4 47m30s 44m49s 06 3 1h1m 1h45s 07 8 54m30s 52m32s 08 5 50m 48m53s 09 4 48m15s 46m47s 10 5 50m37s 49m27s 11 3 50m 48m1s 12 4 47m30s 46m2s 13 3 1h2s 58m6s 14 3 1h 58m3s 15 5 50m36s 49m27s 16 3 1h1m42s 59m45s 17 3 46m40s 44m42s 18 4 1h2m5s 1h33s 19 4 1h 58m25s 20 5 38m31s 35m52s 21 3 1h6s 58m 22 4 1h45s 59m17s 23 5 41m41s 36m1s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-06-07 00:05:01 Date
Connections per database
Key values
- brasilia Main Database
- 513 connections Total
Connections per user
Key values
- intelifix Main User
- 513 connections Total
-
Sessions
Simultaneous sessions
Key values
- 5 sessions Session Peak
- 2026-06-07 06:35:01 Date
Histogram of session times
Key values
- 78 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 98 sessions Total
Sessions per user
Key values
- intelifix Main User
- 98 sessions Total
Sessions per host
Key values
- [local] Main Host
- 98 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 5,188 buffers Checkpoint Peak
- 2026-06-07 03:05:01 Date
- 269.529 seconds Highest write time
- 0.010 seconds Sync time
Checkpoints Wal files
Key values
- 2 files Wal files usage Peak
- 2026-06-07 00:09:55 Date
Checkpoints distance
Key values
- 63.18 Mo Distance Peak
- 2026-06-07 03:05:01 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jun 07 00 5,054 269.529s 0.003s 269.538s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 5,188 0.283s 0.005s 0.298s 04 0 0s 0s 0s 05 4,356 438.318s 0.013s 438.361s 06 1,887 189.393s 0.002s 189.403s 07 734 73.442s 0.003s 73.449s 08 24 2.445s 0.007s 2.459s 09 20 2.029s 0.004s 2.037s 10 23 2.35s 0.006s 2.363s 11 20 2.028s 0.003s 2.035s 12 23 2.35s 0.007s 2.367s 13 22 2.249s 0.005s 2.262s 14 22 2.249s 0.004s 2.262s 15 22 2.249s 0.005s 2.262s 16 23 2.35s 0.005s 2.365s 17 22 2.25s 0.004s 2.262s 18 968 97.181s 0.007s 97.202s 19 21 2.129s 0.003s 2.135s 20 320 32.119s 0.013s 32.14s 21 360 36.146s 0.002s 36.153s 22 24 2.449s 0.005s 2.462s 23 0 0.062s 0.003s 0.079s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jun 07 00 0 0 2 20 0.002s 0.001s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 2 17 0.002s 0.002s 04 0 0 0 0 0s 0s 05 0 0 2 94 0.004s 0.008s 06 0 0 1 8 0.002s 0.001s 07 0 0 0 9 0.002s 0.001s 08 0 0 0 6 0.002s 0.003s 09 0 0 0 3 0.002s 0.002s 10 0 0 0 5 0.002s 0.003s 11 0 0 0 3 0.002s 0.001s 12 0 0 0 5 0.003s 0.003s 13 0 0 0 5 0.002s 0.002s 14 0 0 0 5 0.002s 0.002s 15 0 0 0 5 0.002s 0.002s 16 0 0 0 5 0.002s 0.002s 17 0 0 0 5 0.002s 0.002s 18 0 0 0 55 0.002s 0.005s 19 0 0 0 3 0.002s 0.001s 20 0 0 0 14 0.010s 0.003s 21 0 0 0 5 0.002s 0.001s 22 0 0 0 6 0.002s 0.002s 23 0 0 0 3 0.001s 0.003s Day Hour Count Avg time (sec) Jun 07 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 Jun 07 00 29,966.00 kB 29,966.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 16,175.00 kB 16,175.00 kB 04 0.00 kB 0.00 kB 05 6,999.00 kB 13,713.80 kB 06 4,091.00 kB 16,709.00 kB 07 4,675.00 kB 15,506.00 kB 08 95.00 kB 13,271.00 kB 09 162.00 kB 11,336.00 kB 10 82.00 kB 9,701.50 kB 11 162.00 kB 8,295.00 kB 12 82.00 kB 7,101.00 kB 13 81.50 kB 5,768.00 kB 14 81.50 kB 4,688.00 kB 15 82.50 kB 3,813.50 kB 16 81.50 kB 3,103.00 kB 17 82.00 kB 2,529.00 kB 18 932.25 kB 2,949.50 kB 19 162.00 kB 2,287.00 kB 20 263.00 kB 1,982.50 kB 21 674.00 kB 1,782.00 kB 22 82.00 kB 1,535.00 kB 23 216.00 kB 1,231.67 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 Jun 07 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.21 sec Highest CPU-cost vacuum
Table public.logs
Database rio - 2026-06-07 21:11:01 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 0.21 sec Highest CPU-cost vacuum
Table public.logs
Database rio - 2026-06-07 21:11:01 Date
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- pg_toast.pg_toast_2619 (1) Main table vacuumed on database rio
- 5 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 856 171 978,970 84 393 rio.pg_catalog.pg_statistic 1 1 0 0 0 0 0 3,157 378 1,859,804 351 2,258 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,502 552 1,988,142 520 3,857 rio.public.logs 1 0 0 0 0 0 0 364 324 388,121 3 75 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 140 36 93,316 3 9 Total 5 4 0 0 0 0 0 7,019 1,461 5,308,353 961 6,592 Vacuum throughput per table
Key values
- public.logs (0.21) 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 (4543) Main table with removed tuples on database rio
- 9420 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_statistic 1 1 4,543 7,458 0 0 1,286 contagem.pg_catalog.pg_statistic 1 1 4,211 7,274 0 0 1,011 rio.pg_toast.pg_toast_2619 1 1 563 672 0 143 143 contagem.pg_toast.pg_toast_2619 1 1 103 118 0 24 33 rio.public.logs 1 0 0 15,832,382 0 0 632,506 Total 5 4 9,420 15,847,904 0 167 634,979 Pages removed per table
Key values
- pg_toast.pg_toast_2619 (143) Main table with removed pages on database rio
- 167 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jun 07 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 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 1 0 22 0 0 23 0 0 - 0.21 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
- 82 Total read queries
- 268 Total write queries
Queries by database
Key values
- rio Main database
- 331 Requests
- 2h28m35s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 493 Requests
User Request type Count Duration intelifix Total 493 2h33m45s copy to 268 35m35s others 147 18m6s select 78 1h40m3s lenon Total 4 16s30ms select 4 16s30ms Duration by user
Key values
- 2h33m45s (intelifix) Main time consuming user
User Request type Count Duration intelifix Total 493 2h33m45s copy to 268 35m35s others 147 18m6s select 78 1h40m3s lenon Total 4 16s30ms select 4 16s30ms Queries by host
Key values
- [local] Main host
- 497 Requests
- 2h34m1s ([local])
- Main time consuming host
Queries by application
Key values
- pg_dump Main application
- 280 Requests
- 1h58m23s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-06-07 20:05:04 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 199 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 13m32s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-07 07:18:33 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 8m17s analyze verbose;[ Date: 2026-06-07 05:08:19 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 5m30s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-07 19:10:32 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 5m30s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-07 21:10:32 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 5m17s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-07 18:10:19 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 5m11s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-07 20:10:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 5m10s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-07 11:10:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 5m9s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-07 17:10:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 5m8s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-07 22:10:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 5m8s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-07 16:10:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 5m6s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-07 12:10:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m6s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-07 09:10:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 5m4s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-07 14:10:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m4s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-07 13:10:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m4s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-07 10:10:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m2s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-07 15:10:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 4m54s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-07 08:09:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 2m8s analyze verbose;[ Date: 2026-06-07 05:10:28 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
19 1m46s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-06-07 07:20:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 1m26s COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;[ Date: 2026-06-07 20:08:31 - 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 1h31m21s 32 952ms 13m32s 2m51s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 07 07 2 13m35s 6m47s 08 2 4m55s 2m27s 09 2 5m7s 2m33s 10 2 5m5s 2m32s 11 2 5m11s 2m35s 12 2 5m7s 2m33s 13 2 5m5s 2m32s 14 2 5m5s 2m32s 15 2 5m3s 2m31s 16 2 5m9s 2m34s 17 2 5m10s 2m35s 18 2 5m18s 2m39s 19 2 5m32s 2m46s 20 2 5m13s 2m36s 21 2 5m31s 2m45s 22 2 5m9s 2m34s [ User: intelifix - Total duration: 1h31m21s - Times executed: 32 ]
[ Application: psql - Total duration: 1h31m21s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-07 07:18:33 Duration: 13m32s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-07 19:10:32 Duration: 5m30s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-07 21:10:32 Duration: 5m30s Database: rio User: intelifix Remote: [local] Application: psql
2 10m26s 2 2m8s 8m17s 5m13s analyze verbose;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 07 05 2 10m26s 5m13s [ User: intelifix - Total duration: 10m26s - Times executed: 2 ]
[ Application: psql - Total duration: 10m26s - Times executed: 2 ]
-
analyze verbose;
Date: 2026-06-07 05:08:19 Duration: 8m17s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-07 05:10:28 Duration: 2m8s Database: contagem User: intelifix Remote: [local] Application: psql
3 8m37s 32 413ms 1m46s 16s176ms select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 07 07 2 1m48s 54s15ms 08 2 26s607ms 13s303ms 09 2 26s777ms 13s388ms 10 2 25s982ms 12s991ms 11 2 26s531ms 13s265ms 12 2 25s902ms 12s951ms 13 2 27s60ms 13s530ms 14 2 28s552ms 14s276ms 15 2 27s102ms 13s551ms 16 2 27s171ms 13s585ms 17 2 26s426ms 13s213ms 18 2 28s393ms 14s196ms 19 2 30s922ms 15s461ms 20 2 27s750ms 13s875ms 21 2 28s923ms 14s461ms 22 2 25s510ms 12s755ms [ User: intelifix - Total duration: 8m37s - Times executed: 32 ]
[ Application: psql - Total duration: 8m37s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-07 07:20:20 Duration: 1m46s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-07 19:11:03 Duration: 30s303ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-07 21:11:00 Duration: 28s273ms Database: rio User: intelifix Remote: [local] Application: psql
4 6m41s 137 2s446ms 18s634ms 2s927ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 07 00 6 32s951ms 5s491ms 01 6 16s880ms 2s813ms 02 6 18s440ms 3s73ms 03 5 14s503ms 2s900ms 04 6 17s192ms 2s865ms 05 6 17s605ms 2s934ms 06 6 16s152ms 2s692ms 07 6 15s973ms 2s662ms 08 6 16s284ms 2s714ms 09 6 16s412ms 2s735ms 10 6 16s721ms 2s786ms 11 6 17s337ms 2s889ms 12 6 16s675ms 2s779ms 13 6 15s940ms 2s656ms 14 6 17s 2s833ms 15 6 16s341ms 2s723ms 16 6 16s293ms 2s715ms 17 6 16s964ms 2s827ms 18 6 17s446ms 2s907ms 19 6 17s176ms 2s862ms 20 6 17s243ms 2s873ms 21 6 17s260ms 2s876ms 22 6 16s288ms 2s714ms [ User: intelifix - Total duration: 6m41s - Times executed: 137 ]
[ Application: psql - Total duration: 6m41s - Times executed: 137 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-07 00:05:20 Duration: 18s634ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-07 02:35:05 Duration: 4s93ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-07 05:05:05 Duration: 3s393ms Database: rio User: intelifix Remote: [local] Application: psql
5 2m46s 2 1m19s 1m26s 1m23s 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 Jun 07 20 1 1m26s 1m26s 23 1 1m19s 1m19s [ 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-06-07 20:08:31 Duration: 1m26s 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-06-07 23:36:10 Duration: 1m19s Database: rio User: intelifix Remote: [local] Application: pg_dump
6 1m49s 2 49s632ms 1m 54s949ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 07 20 1 1m 1m 23 1 49s632ms 49s632ms [ User: intelifix - Total duration: 1m49s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m49s - Times executed: 2 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-07 20:05:23 Duration: 1m Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-07 23:17:10 Duration: 49s632ms Database: rio User: intelifix Remote: [local] Application: pg_dump
7 1m45s 2 19s109ms 1m26s 52s973ms 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 #7
Day Hour Count Duration Avg duration Jun 07 23 2 1m45s 52s973ms [ User: intelifix - Total duration: 1m45s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m45s - Times executed: 2 ]
-
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-06-07 23:13:54 Duration: 1m26s 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-06-07 23:37:31 Duration: 19s109ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
8 1m39s 2 19s84ms 1m20s 49s675ms 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 #8
Day Hour Count Duration Avg duration Jun 07 23 2 1m39s 49s675ms [ User: intelifix - Total duration: 1m39s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m39s - Times executed: 2 ]
-
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-06-07 23:11:24 Duration: 1m20s 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-06-07 23:36:56 Duration: 19s84ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
9 1m18s 2 16s419ms 1m2s 39s353ms 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 #9
Day Hour Count Duration Avg duration Jun 07 23 2 1m18s 39s353ms [ User: intelifix - Total duration: 1m18s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m18s - Times executed: 2 ]
-
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-06-07 23:12:27 Duration: 1m2s 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-06-07 23:37:12 Duration: 16s419ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
10 1m4s 4 2s91ms 30s669ms 16s97ms copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 07 20 2 32s760ms 16s380ms 23 2 31s629ms 15s814ms [ User: intelifix - Total duration: 1m4s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m4s - 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-06-07 20:05:55 Duration: 30s669ms 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-06-07 23:17:40 Duration: 29s69ms 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-06-07 23:37:52 Duration: 2s559ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
11 57s8ms 4 8s679ms 20s227ms 14s252ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 07 00 2 37s477ms 18s738ms 06 2 19s530ms 9s765ms [ User: intelifix - Total duration: 57s8ms - Times executed: 4 ]
[ Application: psql - Total duration: 57s8ms - Times executed: 4 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-07 00:05:21 Duration: 20s227ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-07 00:05:52 Duration: 17s250ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-07 06:05:12 Duration: 10s851ms Database: rio User: intelifix Remote: [local] Application: psql
12 55s768ms 4 1s534ms 26s613ms 13s942ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 07 20 2 28s582ms 14s291ms 23 2 27s186ms 13s593ms [ User: intelifix - Total duration: 55s768ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 55s768ms - Times executed: 4 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-06-07 20:06:26 Duration: 26s613ms 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-06-07 23:18:08 Duration: 25s651ms 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-06-07 20:09:17 Duration: 1s969ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
13 53s343ms 4 2s798ms 24s552ms 13s335ms copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 07 20 2 27s350ms 13s675ms 23 2 25s993ms 12s996ms [ User: intelifix - Total duration: 53s343ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 53s343ms - 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-06-07 20:08:56 Duration: 24s552ms 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-06-07 23:36:33 Duration: 22s878ms 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-06-07 23:38:29 Duration: 3s114ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
14 42s637ms 4 1s369ms 20s954ms 10s659ms copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 07 20 2 22s406ms 11s203ms 23 2 20s230ms 10s115ms [ User: intelifix - Total duration: 42s637ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 42s637ms - 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-06-07 20:04:04 Duration: 20s954ms 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-06-07 23:16:03 Duration: 18s860ms 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-06-07 20:09:12 Duration: 1s452ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
15 39s556ms 4 1s450ms 18s690ms 9s889ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 07 20 2 20s471ms 10s235ms 23 2 19s84ms 9s542ms [ User: intelifix - Total duration: 39s556ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 39s556ms - Times executed: 4 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-07 20:03:13 Duration: 18s690ms 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-06-07 23:15:19 Duration: 17s634ms 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-06-07 20:09:08 Duration: 1s781ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
16 38s321ms 4 1s546ms 18s52ms 9s580ms 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 Jun 07 20 2 19s599ms 9s799ms 23 2 18s721ms 9s360ms [ User: intelifix - Total duration: 38s321ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 38s321ms - Times executed: 4 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-07 20:02:42 Duration: 18s52ms 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-06-07 23:14:49 Duration: 17s123ms 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-06-07 23:37:43 Duration: 1s598ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
17 35s957ms 2 16s648ms 19s309ms 17s978ms 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 Jun 07 20 1 19s309ms 19s309ms 23 1 16s648ms 16s648ms [ User: intelifix - Total duration: 35s957ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 35s957ms - Times executed: 2 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-06-07 20:04:23 Duration: 19s309ms 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-06-07 23:16:20 Duration: 16s648ms Database: rio User: intelifix Remote: [local] Application: pg_dump
18 28s529ms 4 1s170ms 13s689ms 7s132ms 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 Jun 07 20 2 14s910ms 7s455ms 23 2 13s619ms 6s809ms [ User: intelifix - Total duration: 28s529ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 28s529ms - 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-06-07 20:03:27 Duration: 13s689ms 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-06-07 23:15:32 Duration: 12s448ms 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-06-07 20:09:09 Duration: 1s220ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
19 27s9ms 4 844ms 12s725ms 6s752ms 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 Jun 07 20 2 13s708ms 6s854ms 23 2 13s300ms 6s650ms [ User: intelifix - Total duration: 27s9ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 27s9ms - 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-06-07 20:02:55 Duration: 12s725ms 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-06-07 23:15:01 Duration: 12s455ms 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-06-07 20:09:06 Duration: 982ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
20 24s887ms 2 4s798ms 20s88ms 12s443ms copy auditor.auditor_2026_06 (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 #20
Day Hour Count Duration Avg duration Jun 07 23 2 24s887ms 12s443ms [ User: intelifix - Total duration: 24s887ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 24s887ms - Times executed: 2 ]
-
COPY auditor.auditor_2026_06 (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-06-07 23:14:14 Duration: 20s88ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_06 (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-06-07 23:37:36 Duration: 4s798ms 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 137 6m41s 2s446ms 18s634ms 2s927ms call rs_giga_triagem (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 07 00 6 32s951ms 5s491ms 01 6 16s880ms 2s813ms 02 6 18s440ms 3s73ms 03 5 14s503ms 2s900ms 04 6 17s192ms 2s865ms 05 6 17s605ms 2s934ms 06 6 16s152ms 2s692ms 07 6 15s973ms 2s662ms 08 6 16s284ms 2s714ms 09 6 16s412ms 2s735ms 10 6 16s721ms 2s786ms 11 6 17s337ms 2s889ms 12 6 16s675ms 2s779ms 13 6 15s940ms 2s656ms 14 6 17s 2s833ms 15 6 16s341ms 2s723ms 16 6 16s293ms 2s715ms 17 6 16s964ms 2s827ms 18 6 17s446ms 2s907ms 19 6 17s176ms 2s862ms 20 6 17s243ms 2s873ms 21 6 17s260ms 2s876ms 22 6 16s288ms 2s714ms [ User: intelifix - Total duration: 6m41s - Times executed: 137 ]
[ Application: psql - Total duration: 6m41s - Times executed: 137 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-07 00:05:20 Duration: 18s634ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-07 02:35:05 Duration: 4s93ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-07 05:05:05 Duration: 3s393ms Database: rio User: intelifix Remote: [local] Application: psql
2 32 1h31m21s 952ms 13m32s 2m51s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 07 07 2 13m35s 6m47s 08 2 4m55s 2m27s 09 2 5m7s 2m33s 10 2 5m5s 2m32s 11 2 5m11s 2m35s 12 2 5m7s 2m33s 13 2 5m5s 2m32s 14 2 5m5s 2m32s 15 2 5m3s 2m31s 16 2 5m9s 2m34s 17 2 5m10s 2m35s 18 2 5m18s 2m39s 19 2 5m32s 2m46s 20 2 5m13s 2m36s 21 2 5m31s 2m45s 22 2 5m9s 2m34s [ User: intelifix - Total duration: 1h31m21s - Times executed: 32 ]
[ Application: psql - Total duration: 1h31m21s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-07 07:18:33 Duration: 13m32s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-07 19:10:32 Duration: 5m30s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-07 21:10:32 Duration: 5m30s Database: rio User: intelifix Remote: [local] Application: psql
3 32 8m37s 413ms 1m46s 16s176ms select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 07 07 2 1m48s 54s15ms 08 2 26s607ms 13s303ms 09 2 26s777ms 13s388ms 10 2 25s982ms 12s991ms 11 2 26s531ms 13s265ms 12 2 25s902ms 12s951ms 13 2 27s60ms 13s530ms 14 2 28s552ms 14s276ms 15 2 27s102ms 13s551ms 16 2 27s171ms 13s585ms 17 2 26s426ms 13s213ms 18 2 28s393ms 14s196ms 19 2 30s922ms 15s461ms 20 2 27s750ms 13s875ms 21 2 28s923ms 14s461ms 22 2 25s510ms 12s755ms [ User: intelifix - Total duration: 8m37s - Times executed: 32 ]
[ Application: psql - Total duration: 8m37s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-07 07:20:20 Duration: 1m46s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-07 19:11:03 Duration: 30s303ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-07 21:11:00 Duration: 28s273ms Database: rio User: intelifix Remote: [local] Application: psql
4 4 1m4s 2s91ms 30s669ms 16s97ms 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 #4
Day Hour Count Duration Avg duration Jun 07 20 2 32s760ms 16s380ms 23 2 31s629ms 15s814ms [ User: intelifix - Total duration: 1m4s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m4s - 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-06-07 20:05:55 Duration: 30s669ms 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-06-07 23:17:40 Duration: 29s69ms 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-06-07 23:37:52 Duration: 2s559ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
5 4 57s8ms 8s679ms 20s227ms 14s252ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 07 00 2 37s477ms 18s738ms 06 2 19s530ms 9s765ms [ User: intelifix - Total duration: 57s8ms - Times executed: 4 ]
[ Application: psql - Total duration: 57s8ms - Times executed: 4 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-07 00:05:21 Duration: 20s227ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-07 00:05:52 Duration: 17s250ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-07 06:05:12 Duration: 10s851ms Database: rio User: intelifix Remote: [local] Application: psql
6 4 55s768ms 1s534ms 26s613ms 13s942ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 07 20 2 28s582ms 14s291ms 23 2 27s186ms 13s593ms [ User: intelifix - Total duration: 55s768ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 55s768ms - Times executed: 4 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-06-07 20:06:26 Duration: 26s613ms 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-06-07 23:18:08 Duration: 25s651ms 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-06-07 20:09:17 Duration: 1s969ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
7 4 53s343ms 2s798ms 24s552ms 13s335ms 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 #7
Day Hour Count Duration Avg duration Jun 07 20 2 27s350ms 13s675ms 23 2 25s993ms 12s996ms [ User: intelifix - Total duration: 53s343ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 53s343ms - 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-06-07 20:08:56 Duration: 24s552ms 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-06-07 23:36:33 Duration: 22s878ms 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-06-07 23:38:29 Duration: 3s114ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
8 4 42s637ms 1s369ms 20s954ms 10s659ms 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 #8
Day Hour Count Duration Avg duration Jun 07 20 2 22s406ms 11s203ms 23 2 20s230ms 10s115ms [ User: intelifix - Total duration: 42s637ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 42s637ms - 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-06-07 20:04:04 Duration: 20s954ms 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-06-07 23:16:03 Duration: 18s860ms 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-06-07 20:09:12 Duration: 1s452ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
9 4 39s556ms 1s450ms 18s690ms 9s889ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 07 20 2 20s471ms 10s235ms 23 2 19s84ms 9s542ms [ User: intelifix - Total duration: 39s556ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 39s556ms - Times executed: 4 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-07 20:03:13 Duration: 18s690ms 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-06-07 23:15:19 Duration: 17s634ms 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-06-07 20:09:08 Duration: 1s781ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
10 4 38s321ms 1s546ms 18s52ms 9s580ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 07 20 2 19s599ms 9s799ms 23 2 18s721ms 9s360ms [ User: intelifix - Total duration: 38s321ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 38s321ms - Times executed: 4 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-07 20:02:42 Duration: 18s52ms 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-06-07 23:14:49 Duration: 17s123ms 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-06-07 23:37:43 Duration: 1s598ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
11 4 28s529ms 1s170ms 13s689ms 7s132ms 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 #11
Day Hour Count Duration Avg duration Jun 07 20 2 14s910ms 7s455ms 23 2 13s619ms 6s809ms [ User: intelifix - Total duration: 28s529ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 28s529ms - 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-06-07 20:03:27 Duration: 13s689ms 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-06-07 23:15:32 Duration: 12s448ms 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-06-07 20:09:09 Duration: 1s220ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
12 4 27s9ms 844ms 12s725ms 6s752ms 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 #12
Day Hour Count Duration Avg duration Jun 07 20 2 13s708ms 6s854ms 23 2 13s300ms 6s650ms [ User: intelifix - Total duration: 27s9ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 27s9ms - 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-06-07 20:02:55 Duration: 12s725ms 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-06-07 23:15:01 Duration: 12s455ms 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-06-07 20:09:06 Duration: 982ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
13 4 22s684ms 724ms 11s813ms 5s671ms 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 #13
Day Hour Count Duration Avg duration Jun 07 20 2 12s668ms 6s334ms 23 2 10s16ms 5s8ms [ User: intelifix - Total duration: 22s684ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 22s684ms - 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-06-07 20:03:43 Duration: 11s813ms 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-06-07 23:15:44 Duration: 9s292ms 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-06-07 20:09:11 Duration: 854ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
14 4 21s861ms 648ms 10s298ms 5s465ms 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 #14
Day Hour Count Duration Avg duration Jun 07 20 2 11s53ms 5s526ms 23 2 10s807ms 5s403ms [ User: intelifix - Total duration: 21s861ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 21s861ms - Times executed: 4 ]
-
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-06-07 20:02:20 Duration: 10s298ms 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-06-07 23:14:29 Duration: 10s159ms 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-06-07 20:09:04 Duration: 754ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
15 4 20s911ms 2s969ms 8s901ms 5s227ms 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 #15
Day Hour Count Duration Avg duration Jun 07 20 2 11s992ms 5s996ms 23 2 8s918ms 4s459ms [ User: intelifix - Total duration: 20s911ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 20s911ms - 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-06-07 20:06:51 Duration: 8s901ms 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-06-07 23:34:38 Duration: 5s949ms 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-06-07 20:09:21 Duration: 3s90ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
16 4 16s30ms 638ms 7s634ms 4s7ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 07 00 2 8s746ms 4s373ms 06 2 7s284ms 3s642ms [ User: lenon - Total duration: 16s30ms - Times executed: 4 ]
[ Application: psql - Total duration: 16s30ms - Times executed: 4 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-06-07 00:02:09 Duration: 7s634ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-06-07 06:02:08 Duration: 6s646ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-06-07 00:02:10 Duration: 1s111ms Database: contagem User: lenon Remote: [local] Application: psql
17 4 9s47ms 2s181ms 2s369ms 2s261ms copy ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 07 20 2 4s629ms 2s314ms 23 2 4s417ms 2s208ms [ User: intelifix - Total duration: 9s47ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 9s47ms - Times executed: 4 ]
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-06-07 20:02:08 Duration: 2s369ms 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-06-07 20:09:03 Duration: 2s259ms 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-06-07 23:14:17 Duration: 2s235ms Database: rio User: intelifix Remote: [local] Application: pg_dump
18 4 8s406ms 462ms 3s942ms 2s101ms copy public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 07 20 2 4s405ms 2s202ms 23 2 4s1ms 2s [ User: intelifix - Total duration: 8s406ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 8s406ms - Times executed: 4 ]
-
COPY public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) TO stdout;
Date: 2026-06-07 20:03:31 Duration: 3s942ms 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-06-07 23:15:35 Duration: 3s408ms 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-06-07 23:37:47 Duration: 592ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
19 4 4s650ms 1s66ms 1s249ms 1s162ms copy ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 07 20 2 2s334ms 1s167ms 23 2 2s316ms 1s158ms [ User: intelifix - Total duration: 4s650ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 4s650ms - Times executed: 4 ]
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-06-07 23:37:38 Duration: 1s249ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-06-07 20:09:01 Duration: 1s233ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-06-07 20:02:05 Duration: 1s100ms Database: rio User: intelifix Remote: [local] Application: pg_dump
20 4 1s278ms 205ms 435ms 319ms copy public.lotes (lot_id, lot_criacao, ofi_id, usu_id, cli_id, lot_tipo, lot_qtd_itens, mod_id, lot_data, lot_notafiscal, lot_qtd_cq, lot_lote_saida, arq_id, con_id, ss_id, lot_sem_serial, lot_status, lot_sucata, lot_novo, cli_original, nota_original, lot_preco_unit, lot_stone, lc_id) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 07 20 2 629ms 314ms 23 2 649ms 324ms [ User: intelifix - Total duration: 1s278ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1s278ms - Times executed: 4 ]
-
COPY public.lotes (lot_id, lot_criacao, ofi_id, usu_id, cli_id, lot_tipo, lot_qtd_itens, mod_id, lot_data, lot_notafiscal, lot_qtd_cq, lot_lote_saida, arq_id, con_id, ss_id, lot_sem_serial, lot_status, lot_sucata, lot_novo, cli_original, nota_original, lot_preco_unit, lot_stone, lc_id) TO stdout;
Date: 2026-06-07 23:17:41 Duration: 435ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lotes (lot_id, lot_criacao, ofi_id, usu_id, cli_id, lot_tipo, lot_qtd_itens, mod_id, lot_data, lot_notafiscal, lot_qtd_cq, lot_lote_saida, arq_id, con_id, ss_id, lot_sem_serial, lot_status, lot_sucata, lot_novo, cli_original, nota_original, lot_preco_unit, lot_stone, lc_id) TO stdout;
Date: 2026-06-07 20:05:56 Duration: 423ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lotes (lot_id, lot_criacao, ofi_id, usu_id, cli_id, lot_tipo, lot_qtd_itens, mod_id, lot_data, lot_notafiscal, lot_qtd_cq, lot_lote_saida, arq_id, con_id, ss_id, lot_sem_serial, lot_status, lot_sucata, lot_novo, cli_original, nota_original, lot_preco_unit, lot_stone, lc_id) TO stdout;
Date: 2026-06-07 23:37:52 Duration: 214ms 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 2m8s 8m17s 5m13s 2 10m26s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 07 05 2 10m26s 5m13s [ User: intelifix - Total duration: 10m26s - Times executed: 2 ]
[ Application: psql - Total duration: 10m26s - Times executed: 2 ]
-
analyze verbose;
Date: 2026-06-07 05:08:19 Duration: 8m17s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-07 05:10:28 Duration: 2m8s Database: contagem User: intelifix Remote: [local] Application: psql
2 952ms 13m32s 2m51s 32 1h31m21s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 07 07 2 13m35s 6m47s 08 2 4m55s 2m27s 09 2 5m7s 2m33s 10 2 5m5s 2m32s 11 2 5m11s 2m35s 12 2 5m7s 2m33s 13 2 5m5s 2m32s 14 2 5m5s 2m32s 15 2 5m3s 2m31s 16 2 5m9s 2m34s 17 2 5m10s 2m35s 18 2 5m18s 2m39s 19 2 5m32s 2m46s 20 2 5m13s 2m36s 21 2 5m31s 2m45s 22 2 5m9s 2m34s [ User: intelifix - Total duration: 1h31m21s - Times executed: 32 ]
[ Application: psql - Total duration: 1h31m21s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-07 07:18:33 Duration: 13m32s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-07 19:10:32 Duration: 5m30s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-07 21:10:32 Duration: 5m30s Database: rio User: intelifix Remote: [local] Application: psql
3 1m19s 1m26s 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 Jun 07 20 1 1m26s 1m26s 23 1 1m19s 1m19s [ 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-06-07 20:08:31 Duration: 1m26s 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-06-07 23:36:10 Duration: 1m19s Database: rio User: intelifix Remote: [local] Application: pg_dump
4 49s632ms 1m 54s949ms 2 1m49s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 07 20 1 1m 1m 23 1 49s632ms 49s632ms [ User: intelifix - Total duration: 1m49s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m49s - Times executed: 2 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-07 20:05:23 Duration: 1m Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-07 23:17:10 Duration: 49s632ms Database: rio User: intelifix Remote: [local] Application: pg_dump
5 19s109ms 1m26s 52s973ms 2 1m45s 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 Jun 07 23 2 1m45s 52s973ms [ User: intelifix - Total duration: 1m45s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m45s - Times executed: 2 ]
-
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-06-07 23:13:54 Duration: 1m26s 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-06-07 23:37:31 Duration: 19s109ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
6 19s84ms 1m20s 49s675ms 2 1m39s 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 Jun 07 23 2 1m39s 49s675ms [ User: intelifix - Total duration: 1m39s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m39s - Times executed: 2 ]
-
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-06-07 23:11:24 Duration: 1m20s 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-06-07 23:36:56 Duration: 19s84ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
7 16s419ms 1m2s 39s353ms 2 1m18s 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 Jun 07 23 2 1m18s 39s353ms [ User: intelifix - Total duration: 1m18s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m18s - Times executed: 2 ]
-
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-06-07 23:12:27 Duration: 1m2s 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-06-07 23:37:12 Duration: 16s419ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
8 16s648ms 19s309ms 17s978ms 2 35s957ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 07 20 1 19s309ms 19s309ms 23 1 16s648ms 16s648ms [ User: intelifix - Total duration: 35s957ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 35s957ms - Times executed: 2 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-06-07 20:04:23 Duration: 19s309ms 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-06-07 23:16:20 Duration: 16s648ms Database: rio User: intelifix Remote: [local] Application: pg_dump
9 413ms 1m46s 16s176ms 32 8m37s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 07 07 2 1m48s 54s15ms 08 2 26s607ms 13s303ms 09 2 26s777ms 13s388ms 10 2 25s982ms 12s991ms 11 2 26s531ms 13s265ms 12 2 25s902ms 12s951ms 13 2 27s60ms 13s530ms 14 2 28s552ms 14s276ms 15 2 27s102ms 13s551ms 16 2 27s171ms 13s585ms 17 2 26s426ms 13s213ms 18 2 28s393ms 14s196ms 19 2 30s922ms 15s461ms 20 2 27s750ms 13s875ms 21 2 28s923ms 14s461ms 22 2 25s510ms 12s755ms [ User: intelifix - Total duration: 8m37s - Times executed: 32 ]
[ Application: psql - Total duration: 8m37s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-07 07:20:20 Duration: 1m46s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-07 19:11:03 Duration: 30s303ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-07 21:11:00 Duration: 28s273ms Database: rio User: intelifix Remote: [local] Application: psql
10 2s91ms 30s669ms 16s97ms 4 1m4s copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 07 20 2 32s760ms 16s380ms 23 2 31s629ms 15s814ms [ User: intelifix - Total duration: 1m4s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m4s - 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-06-07 20:05:55 Duration: 30s669ms 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-06-07 23:17:40 Duration: 29s69ms 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-06-07 23:37:52 Duration: 2s559ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
11 8s679ms 20s227ms 14s252ms 4 57s8ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 07 00 2 37s477ms 18s738ms 06 2 19s530ms 9s765ms [ User: intelifix - Total duration: 57s8ms - Times executed: 4 ]
[ Application: psql - Total duration: 57s8ms - Times executed: 4 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-07 00:05:21 Duration: 20s227ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-07 00:05:52 Duration: 17s250ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-07 06:05:12 Duration: 10s851ms Database: rio User: intelifix Remote: [local] Application: psql
12 1s534ms 26s613ms 13s942ms 4 55s768ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 07 20 2 28s582ms 14s291ms 23 2 27s186ms 13s593ms [ User: intelifix - Total duration: 55s768ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 55s768ms - Times executed: 4 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-06-07 20:06:26 Duration: 26s613ms 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-06-07 23:18:08 Duration: 25s651ms 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-06-07 20:09:17 Duration: 1s969ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
13 2s798ms 24s552ms 13s335ms 4 53s343ms copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 07 20 2 27s350ms 13s675ms 23 2 25s993ms 12s996ms [ User: intelifix - Total duration: 53s343ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 53s343ms - 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-06-07 20:08:56 Duration: 24s552ms 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-06-07 23:36:33 Duration: 22s878ms 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-06-07 23:38:29 Duration: 3s114ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
14 4s798ms 20s88ms 12s443ms 2 24s887ms copy auditor.auditor_2026_06 (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 #14
Day Hour Count Duration Avg duration Jun 07 23 2 24s887ms 12s443ms [ User: intelifix - Total duration: 24s887ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 24s887ms - Times executed: 2 ]
-
COPY auditor.auditor_2026_06 (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-06-07 23:14:14 Duration: 20s88ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_06 (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-06-07 23:37:36 Duration: 4s798ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
15 1s369ms 20s954ms 10s659ms 4 42s637ms copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 07 20 2 22s406ms 11s203ms 23 2 20s230ms 10s115ms [ User: intelifix - Total duration: 42s637ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 42s637ms - 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-06-07 20:04:04 Duration: 20s954ms 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-06-07 23:16:03 Duration: 18s860ms 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-06-07 20:09:12 Duration: 1s452ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
16 1s450ms 18s690ms 9s889ms 4 39s556ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 07 20 2 20s471ms 10s235ms 23 2 19s84ms 9s542ms [ User: intelifix - Total duration: 39s556ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 39s556ms - Times executed: 4 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-07 20:03:13 Duration: 18s690ms 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-06-07 23:15:19 Duration: 17s634ms 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-06-07 20:09:08 Duration: 1s781ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
17 1s546ms 18s52ms 9s580ms 4 38s321ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 07 20 2 19s599ms 9s799ms 23 2 18s721ms 9s360ms [ User: intelifix - Total duration: 38s321ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 38s321ms - Times executed: 4 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-07 20:02:42 Duration: 18s52ms 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-06-07 23:14:49 Duration: 17s123ms 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-06-07 23:37:43 Duration: 1s598ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
18 1s170ms 13s689ms 7s132ms 4 28s529ms 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 Jun 07 20 2 14s910ms 7s455ms 23 2 13s619ms 6s809ms [ User: intelifix - Total duration: 28s529ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 28s529ms - 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-06-07 20:03:27 Duration: 13s689ms 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-06-07 23:15:32 Duration: 12s448ms 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-06-07 20:09:09 Duration: 1s220ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
19 844ms 12s725ms 6s752ms 4 27s9ms 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 Jun 07 20 2 13s708ms 6s854ms 23 2 13s300ms 6s650ms [ User: intelifix - Total duration: 27s9ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 27s9ms - 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-06-07 20:02:55 Duration: 12s725ms 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-06-07 23:15:01 Duration: 12s455ms 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-06-07 20:09:06 Duration: 982ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
20 724ms 11s813ms 5s671ms 4 22s684ms 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 #20
Day Hour Count Duration Avg duration Jun 07 20 2 12s668ms 6s334ms 23 2 10s16ms 5s8ms [ User: intelifix - Total duration: 22s684ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 22s684ms - 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-06-07 20:03:43 Duration: 11s813ms 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-06-07 23:15:44 Duration: 9s292ms 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-06-07 20:09:11 Duration: 854ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
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 5 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jun 07 10 2 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 16 1 0ms 0ms [ User: intelifix - Total duration: 5m14s - Times executed: 5 ]
[ Application: psql - Total duration: 5m14s - Times executed: 5 ]
-
;
Date: Duration: 0ms Database: postgres User: contagem Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 2,842 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 417 FATAL entries
- 49 ERROR entries
- 0 WARNING entries
- 1 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 377 Max number of times the same event was reported
- 467 Total events found
Rank Times reported Error 1 377 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jun 07 00 16 01 14 02 15 03 14 04 14 05 19 06 16 07 15 08 16 09 17 10 18 11 17 12 16 13 16 14 16 15 17 16 16 17 16 18 18 19 17 20 17 21 18 22 18 23 1 - FATAL: database "brasilia" does not exist
- FATAL: database "testes" does not exist
- FATAL: database "brasilia" does not exist
Date: 2026-06-07 00:02:09 Database: brasilia Application: [unknown] User: lenon Remote: [local]
Date: 2026-06-07 00:02:10 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-06-07 00:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
2 45 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #2
Day Hour Count Jun 07 08 3 09 3 10 3 11 3 12 3 13 3 14 3 15 3 16 3 17 3 18 3 19 3 20 3 21 3 22 3 - ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
Detail: Character with value 0x09 must be escaped.
Context: JSON data, line 22503: "nrSerie":"ZTEEH7VM1L08287... PL/pgSQL function rs_resumo_tcia(integer) line 139 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-07 08:01:01 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Character with value 0x09 must be escaped.
Context: JSON data, line 46119: "nrSerie":"ZTEEH7VM1L08287... PL/pgSQL function rs_resumo_tcia(integer) line 139 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-07 08:20:06 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Character with value 0x09 must be escaped.
Context: JSON data, line 22503: "nrSerie":"ZTEEH7VM1L08287... PL/pgSQL function rs_resumo_tcia(integer) line 139 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-07 08:40:06 Database: rio Application: psql User: intelifix Remote: [local]
3 36 FATAL: database "..." does not exist /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn(
Times Reported Most Frequent Error / Event #3
Day Hour Count Jun 07 07 1 08 3 09 2 10 1 11 2 12 3 13 3 14 3 15 2 16 3 17 3 18 2 19 2 20 3 21 2 22 1 - FATAL: database "brasilia" does not exist /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn(
- FATAL: database "brasilia" does not exist /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn(
- FATAL: database "brasilia" does not exist /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1018: 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-06-07 07:55:19 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-07 08:15:19 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-07 08:35:31 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
4 3 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #4
Day Hour Count Jun 07 03 3 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-06-07 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-07 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Context: SQL statement "SELECT ID,DADOS FROM GIGA_TESTES WHERE STATUS = 0 AND DATE( CRIACAO ) >= ( CURRENT_DATE - 20 ) ORDER BY ID" PL/pgSQL function rs_giga_triagem(character varying) line 79 at FOR over EXECUTE statement
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-06-07 03:05:01 Database: rio Application: psql User: intelifix Remote: [local]
5 2 ERROR: could not connect to server "..."
Times Reported Most Frequent Error / Event #5
Day Hour Count Jun 07 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-06-07 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-06-07 05:30:01 Database: rio Application: psql User: intelifix Remote: [local]
6 2 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #6
Day Hour Count Jun 07 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-06-07 05:30:16 Database: contagem Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-06-07 05:30:16 Database: contagem Application: psql User: intelifix Remote: [local]
7 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #7
Day Hour Count Jun 07 03 1 - LOG: database system was shut down at 2026-06-07 03:05:01 -03
Date: 2026-06-07 03:05:02
8 1 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #8
Day Hour Count Jun 07 03 1 - FATAL: the database system is shutting down
Date: 2026-06-07 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]