pgBadger-
Global information
- Generated on Sat Jun 6 23:50:05 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 6,732 log entries in 3s
- Log start from 2026-06-06 00:02:01 to 2026-06-06 23:41:52
-
Overview
Global Stats
- 142 Number of unique normalized queries
- 581 Number of queries
- 2h33m37s Total query duration
- 2026-06-06 00:02:05 First query
- 2026-06-06 23:41:52 Last query
- 4 queries/s at 2026-06-06 23:41:35 Query peak
- 2h33m37s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 2h33m37s Execute total duration
- 477 Number of events
- 8 Number of unique normalized events
- 388 Max number of times the same event was reported
- 0 Number of cancellation
- 7 Total number of automatic vacuums
- 10 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 101 Total number of sessions
- 4 sessions at 2026-06-06 13:05:01 Session peak
- 3d17h7m17s Total duration of sessions
- 52m56s Average duration of sessions
- 5 Average queries per session
- 1m31s Average queries duration per session
- 51m25s Average idle time per session
- 525 Total number of connections
- 5 connections/s at 2026-06-06 00:05:01 Connection peak
- 2 Total number of databases
SQL Traffic
Key values
- 4 queries/s Query Peak
- 2026-06-06 23:41:35 Date
SELECT Traffic
Key values
- 3 queries/s Query Peak
- 2026-06-06 04:35:48 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-06-06 23:41:35 Date
Queries duration
Key values
- 2h33m37s 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 06 00 24 0ms 18s809ms 3s731ms 5s212ms 1m1s 1m1s 01 15 0ms 4s58ms 1s955ms 5s791ms 7s232ms 7s232ms 02 12 0ms 3s342ms 2s95ms 5s166ms 5s166ms 5s166ms 03 17 0ms 4s252ms 1s700ms 5s505ms 5s689ms 5s689ms 04 44 0ms 3s715ms 787ms 4s927ms 5s478ms 5s747ms 05 17 0ms 7m34s 36s765ms 2m1s 7m34s 7m34s 06 10 0ms 8s56ms 3s936ms 19s232ms 19s232ms 19s232ms 07 10 0ms 8m50s 1m 54s321ms 8m50s 8m50s 08 10 0ms 5m10s 35s791ms 3s403ms 5m40s 5m40s 09 10 0ms 5m28s 38s160ms 33s507ms 5m28s 5m28s 10 10 0ms 5m13s 36s256ms 3s594ms 5m43s 5m43s 11 10 0ms 5m25s 37s944ms 3s855ms 5m57s 5m57s 12 10 0ms 5m11s 35s846ms 3s306ms 5m41s 5m41s 13 10 0ms 5m9s 35s676ms 5m38s 5m38s 5m38s 14 10 0ms 5m5s 35s68ms 3s201ms 5m33s 5m33s 15 10 0ms 5m6s 35s230ms 5m34s 5m34s 5m34s 16 10 0ms 5m2s 34s892ms 3s251ms 5m31s 5m31s 17 10 0ms 5m18s 36s472ms 3s194ms 5m44s 5m44s 18 10 0ms 5m5s 35s342ms 3s404ms 5m34s 5m34s 19 10 0ms 5m5s 35s178ms 5m34s 5m34s 5m34s 20 61 0ms 5m9s 12s685ms 2m2s 5m41s 5m41s 21 11 0ms 5m8s 32s574ms 3s949ms 5m39s 5m39s 22 10 0ms 5m35s 38s486ms 31s922ms 5m35s 5m35s 23 230 0ms 1m50s 8s269ms 1m31s 1m50s 1m52s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 06 00 8 0 855ms 166ms 1s1ms 5s212ms 01 3 0 387ms 0ms 0ms 1s163ms 02 0 0 0ms 0ms 0ms 0ms 03 4 0 372ms 160ms 193ms 1s137ms 04 32 0 251ms 219ms 504ms 1s250ms 05 4 0 308ms 0ms 213ms 1s21ms 06 2 0 2s542ms 0ms 5s85ms 5s85ms 07 4 0 2m27s 4s311ms 54s321ms 8m50s 08 4 0 1m25s 0ms 0ms 5m40s 09 4 0 1m30s 0ms 33s507ms 5m28s 10 4 0 1m25s 0ms 0ms 5m43s 11 4 0 1m29s 0ms 1s660ms 5m57s 12 4 0 1m25s 0ms 0ms 5m41s 13 4 0 1m24s 0ms 5m38s 5m38s 14 4 0 1m23s 0ms 0ms 5m33s 15 4 0 1m23s 0ms 5m34s 5m34s 16 4 0 1m22s 0ms 0ms 5m31s 17 4 0 1m26s 0ms 1s619ms 5m44s 18 4 0 1m23s 0ms 0ms 5m34s 19 4 0 1m23s 0ms 5m34s 5m34s 20 6 49 13s764ms 59s29ms 2m1s 5m41s 21 5 0 1m8s 0ms 458ms 5m39s 22 4 0 1m31s 0ms 31s922ms 5m35s 23 9 221 8s269ms 1m8s 1m31s 1m50s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 06 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 06 00 0 1 1.00 0.00% 01 0 1 1.00 0.00% 02 0 0 0.00 0.00% 03 0 1 1.00 0.00% 04 0 3 3.00 0.00% 05 0 1 1.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 06 00 29 0.01/s 01 19 0.01/s 02 17 0.00/s 03 24 0.01/s 04 18 0.01/s 05 26 0.01/s 06 21 0.01/s 07 20 0.01/s 08 25 0.01/s 09 22 0.01/s 10 22 0.01/s 11 23 0.01/s 12 22 0.01/s 13 23 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 27 0.01/s 21 23 0.01/s 22 24 0.01/s 23 3 0.00/s Day Hour Count Average Duration Average idle time Jun 06 00 1 10m 8m30s 01 8 1h1m27s 1h1m24s 02 5 1h36s 1h31s 03 6 27m29s 27m24s 04 5 1h36s 1h29s 05 3 1h5s 56m37s 06 5 1h37s 1h29s 07 5 58m36s 56m34s 08 5 50m36s 49m24s 09 4 1h2m7s 1h32s 10 3 1h1m44s 59m43s 11 3 1h1s 57m54s 12 4 1h45s 59m15s 13 4 47m30s 46m1s 14 3 51m40s 49m43s 15 3 1h1m42s 59m44s 16 4 1h2m44s 1h1m17s 17 4 47m30s 45m59s 18 4 47m31s 46m2s 19 3 1h1m41s 59m44s 20 6 32m50s 30m41s 21 4 1h45s 59m15s 22 4 47m30s 45m54s 23 5 42m22s 36m1s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-06-06 00:05:01 Date
Connections per database
Key values
- brasilia Main Database
- 525 connections Total
Connections per user
Key values
- intelifix Main User
- 525 connections Total
-
Sessions
Simultaneous sessions
Key values
- 4 sessions Session Peak
- 2026-06-06 13:05:01 Date
Histogram of session times
Key values
- 82 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 101 sessions Total
Sessions per user
Key values
- intelifix Main User
- 101 sessions Total
Sessions per host
Key values
- [local] Main Host
- 101 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 10,491 buffers Checkpoint Peak
- 2026-06-06 00:19:50 Date
- 270.024 seconds Highest write time
- 0.007 seconds Sync time
Checkpoints Wal files
Key values
- 3 files Wal files usage Peak
- 2026-06-06 00:09:50 Date
Checkpoints distance
Key values
- 83.35 Mo Distance Peak
- 2026-06-06 00:09:50 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jun 06 00 19,137 684.016s 0.019s 684.071s 01 2,426 243.645s 0.023s 243.702s 02 1,586 159.326s 0.022s 159.374s 03 1,916 192.393s 0.019s 192.444s 04 4,421 443.331s 0.036s 443.416s 05 6,799 652.286s 0.028s 652.35s 06 4,367 269.299s 0.001s 269.308s 07 860 86.322s 0.003s 86.338s 08 20 2.031s 0.003s 2.038s 09 21 2.131s 0.003s 2.139s 10 21 2.128s 0.003s 2.136s 11 20 2.029s 0.003s 2.039s 12 21 2.129s 0.002s 2.138s 13 22 2.248s 0.005s 2.261s 14 22 2.249s 0.005s 2.261s 15 23 2.353s 0.005s 2.367s 16 21 2.136s 0.006s 2.149s 17 21 2.127s 0.007s 2.138s 18 355 35.572s 0.006s 35.59s 19 24 2.449s 0.006s 2.461s 20 157 16.084s 0.009s 16.104s 21 37 3.782s 0.01s 3.811s 22 21 2.128s 0.003s 2.134s 23 58 7.145s 0.008s 7.16s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jun 06 00 0 0 6 484 0.004s 0.006s 01 0 0 1 459 0.003s 0.007s 02 0 0 0 407 0.004s 0.006s 03 0 0 1 518 0.003s 0.006s 04 0 0 1 831 0.003s 0.011s 05 0 0 3 688 0.003s 0.008s 06 0 0 1 7 0.001s 0.001s 07 0 0 0 21 0.001s 0.003s 08 0 0 0 3 0.002s 0.001s 09 0 0 0 3 0.002s 0.001s 10 0 0 0 3 0.002s 0.001s 11 0 0 0 3 0.002s 0.001s 12 0 0 0 3 0.002s 0.001s 13 0 0 0 4 0.002s 0.003s 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.003s 17 0 0 0 3 0.004s 0.003s 18 0 0 0 8 0.002s 0.004s 19 0 0 0 6 0.002s 0.002s 20 0 0 0 22 0.003s 0.003s 21 0 0 0 15 0.002s 0.005s 22 0 0 0 4 0.002s 0.001s 23 0 0 0 11 0.004s 0.003s Day Hour Count Avg time (sec) Jun 06 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 06 00 14,986.33 kB 36,325.17 kB 01 1,896.14 kB 19,744.14 kB 02 1,394.50 kB 10,618.33 kB 03 1,324.57 kB 2,550.57 kB 04 2,061.45 kB 2,931.27 kB 05 6,791.12 kB 16,733.62 kB 06 8,642.00 kB 13,590.00 kB 07 1,613.67 kB 11,449.67 kB 08 162.00 kB 9,296.00 kB 09 162.00 kB 8,383.00 kB 10 162.00 kB 7,561.00 kB 11 162.00 kB 6,821.00 kB 12 162.00 kB 6,155.00 kB 13 81.50 kB 5,271.00 kB 14 81.50 kB 4,286.00 kB 15 82.00 kB 3,488.00 kB 16 82.00 kB 2,842.00 kB 17 163.00 kB 2,444.00 kB 18 201.00 kB 2,009.67 kB 19 82.00 kB 1,585.50 kB 20 318.33 kB 1,288.67 kB 21 52.25 kB 929.50 kB 22 164.00 kB 730.00 kB 23 45.50 kB 630.00 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 06 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
- 1.41 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_06
Database contagem - 2026-06-06 00:06:19 Date
- 0 sec Highest CPU-cost analyze
Table
Database contagem - Date
Average Autovacuum Duration
Key values
- 1.41 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_06
Database contagem - 2026-06-06 00:06:19 Date
Analyzes per table
Key values
- public.temp0000281847 (5) Main table analyzed (database rio)
- 10 analyzes Total
Vacuums per table
Key values
- pg_toast.pg_toast_2619 (1) Main table vacuumed on database contagem
- 7 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 138 60 180,187 19 37 rio.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 876 177 1,103,018 99 368 contagem.auditor.auditor_2026_06 1 0 0 0 0 0 0 5,929 5,172 6,483,481 0 0 rio.public.logs 1 0 0 0 0 0 0 764 328 426,173 212 5,289 rio.pg_catalog.pg_attribute 1 1 0 0 0 0 0 736 271 251,253 2 36 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,462 1,051 3,062,767 999 7,247 rio.pg_catalog.pg_statistic 1 1 0 0 0 0 0 3,468 437 2,002,211 392 2,396 Total 7 5 0 0 0 0 0 14,373 7,496 13,509,090 1,723 15,373 Vacuum throughput per table
Key values
- auditor.auditor_2026_06 (1.41) Max CPU elapsed for vacuum on database contagem
- unknown (0 ms) Max I/O read time for vacuum on database contagem
- unknown (0 ms) Max I/O write time for vacuum on database contagem
I/O timing (ms) CPU (s) Table read write elapsed contagem.pg_toast.pg_toast_2619 0 0 0 rio.pg_toast.pg_toast_2619 0 0 0.06 contagem.auditor.auditor_2026_06 0 0 1.41 rio.public.logs 0 0 0.17 rio.pg_catalog.pg_attribute 0 0 0.21 contagem.pg_catalog.pg_statistic 0 0 0.07 rio.pg_catalog.pg_statistic 0 0 0.26 Total 0 0 2.18 Tuples removed per table
Key values
- pg_catalog.pg_statistic (4304) Main table with removed tuples on database rio
- 10732 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_statistic 1 1 4,304 7,492 0 0 1,286 contagem.pg_catalog.pg_statistic 1 1 3,782 7,274 0 0 1,011 rio.pg_catalog.pg_attribute 1 1 1,862 23,058 0 319 537 rio.pg_toast.pg_toast_2619 1 1 671 677 0 0 286 contagem.pg_toast.pg_toast_2619 1 1 113 116 0 0 57 contagem.auditor.auditor_2026_06 1 0 0 795,462 0 0 34,955 rio.public.logs 1 0 0 15,825,097 0 0 632,152 Total 7 5 10,732 16,659,176 0 319 670,284 Pages removed per table
Key values
- pg_catalog.pg_attribute (319) Main table with removed pages on database rio
- 319 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.pg_catalog.pg_attribute 1 1 1862 319 contagem.pg_toast.pg_toast_2619 1 1 113 0 rio.pg_toast.pg_toast_2619 1 1 671 0 contagem.auditor.auditor_2026_06 1 0 0 0 rio.public.logs 1 0 0 0 contagem.pg_catalog.pg_statistic 1 1 3782 0 rio.pg_catalog.pg_statistic 1 1 4304 0 Total 7 5 10,732 319 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jun 06 00 1 1 01 0 0 02 0 0 03 0 0 04 0 6 05 5 3 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 1 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 - 1.41 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 129 Total read queries
- 271 Total write queries
Queries by database
Key values
- rio Main database
- 416 Requests
- 2h28m6s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 570 Requests
User Request type Count Duration intelifix Total 570 2h33m24s copy to 270 38m34s ddl 1 24s107ms others 181 18m34s select 118 1h35m51s lenon Total 11 13s300ms select 11 13s300ms Duration by user
Key values
- 2h33m24s (intelifix) Main time consuming user
User Request type Count Duration intelifix Total 570 2h33m24s copy to 270 38m34s ddl 1 24s107ms others 181 18m34s select 118 1h35m51s lenon Total 11 13s300ms select 11 13s300ms Queries by host
Key values
- [local] Main host
- 581 Requests
- 2h33m37s ([local])
- Main time consuming host
Queries by application
Key values
- pg_dump Main application
- 281 Requests
- 1h54m22s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-06-06 07:25:20 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 227 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 8m50s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-06 07:13:51 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 7m34s analyze verbose;[ Date: 2026-06-06 05:07:35 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 5m35s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-06 22:10:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 5m28s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-06 09:10:29 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 5m25s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-06 11:10:27 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 5m18s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-06 17:10:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 5m13s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-06 10:10:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 5m11s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-06 12:10:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 5m10s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-06 08:10:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 5m9s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-06 20:10:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 5m9s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-06 13:10:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m8s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-06 21:10:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 5m6s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-06 15:10:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m5s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-06 19:10:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m5s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-06 18:10:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m5s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-06 14:10:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m2s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-06 16:10:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 2m1s analyze verbose;[ Date: 2026-06-06 05:09:37 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
19 1m50s 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-06 23:14:46 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
20 1m32s 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-06 23:11:38 - 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 1h27m28s 32 1s59ms 8m50s 2m44s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 06 07 2 8m52s 4m26s 08 2 5m11s 2m35s 09 2 5m30s 2m45s 10 2 5m14s 2m37s 11 2 5m27s 2m43s 12 2 5m12s 2m36s 13 2 5m10s 2m35s 14 2 5m6s 2m33s 15 2 5m7s 2m33s 16 2 5m3s 2m31s 17 2 5m20s 2m40s 18 2 5m6s 2m33s 19 2 5m6s 2m33s 20 2 5m11s 2m35s 21 2 5m9s 2m34s 22 2 5m36s 2m48s [ User: intelifix - Total duration: 1h27m28s - Times executed: 32 ]
[ Application: psql - Total duration: 1h27m28s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-06 07:13:51 Duration: 8m50s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-06 22:10:37 Duration: 5m35s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-06 09:10:29 Duration: 5m28s Database: rio User: intelifix Remote: [local] Application: psql
2 9m36s 2 2m1s 7m34s 4m48s analyze verbose;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 06 05 2 9m36s 4m48s [ User: intelifix - Total duration: 9m36s - Times executed: 2 ]
[ Application: psql - Total duration: 9m36s - Times executed: 2 ]
-
analyze verbose;
Date: 2026-06-06 05:07:35 Duration: 7m34s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-06 05:09:37 Duration: 2m1s Database: contagem User: intelifix Remote: [local] Application: psql
3 8m8s 32 430ms 54s321ms 15s252ms select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 06 07 2 55s849ms 27s924ms 08 2 28s420ms 14s210ms 09 2 31s915ms 15s957ms 10 2 28s722ms 14s361ms 11 2 31s897ms 15s948ms 12 2 28s463ms 14s231ms 13 2 28s87ms 14s43ms 14 2 26s922ms 13s461ms 15 2 27s361ms 13s680ms 16 2 28s404ms 14s202ms 17 2 26s485ms 13s242ms 18 2 28s180ms 14s90ms 19 2 27s333ms 13s666ms 20 2 29s983ms 14s991ms 21 2 29s703ms 14s851ms 22 2 30s340ms 15s170ms [ User: intelifix - Total duration: 8m8s - Times executed: 32 ]
[ Application: psql - Total duration: 8m8s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-06 07:14:45 Duration: 54s321ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-06 09:11:01 Duration: 31s343ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-06 11:10:58 Duration: 31s297ms Database: rio User: intelifix Remote: [local] Application: psql
4 7m6s 138 2s495ms 10s11ms 3s89ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 06 00 6 24s593ms 4s98ms 01 6 19s670ms 3s278ms 02 6 17s791ms 2s965ms 03 6 19s511ms 3s251ms 04 6 18s74ms 3s12ms 05 6 17s714ms 2s952ms 06 6 18s201ms 3s33ms 07 6 19s549ms 3s258ms 08 6 17s575ms 2s929ms 09 6 19s520ms 3s253ms 10 6 19s89ms 3s181ms 11 6 20s511ms 3s418ms 12 6 17s125ms 2s854ms 13 6 18s180ms 3s30ms 14 6 17s314ms 2s885ms 15 6 17s677ms 2s946ms 16 6 17s148ms 2s858ms 17 6 18s148ms 3s24ms 18 6 18s662ms 3s110ms 19 6 17s705ms 2s950ms 20 6 16s735ms 2s789ms 21 6 18s159ms 3s26ms 22 6 17s675ms 2s945ms [ User: intelifix - Total duration: 7m6s - Times executed: 138 ]
[ Application: psql - Total duration: 7m6s - Times executed: 138 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-06 00:05:26 Duration: 10s11ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-06 05:05:09 Duration: 4s362ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-06 03:05:22 Duration: 4s252ms Database: rio User: intelifix Remote: [local] Application: psql
5 2m45s 2 1m19s 1m26s 1m22s 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 06 20 1 1m19s 1m19s 23 1 1m26s 1m26s [ User: intelifix - Total duration: 2m45s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m45s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-06 23:39:16 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-06 20:08:12 Duration: 1m19s Database: rio User: intelifix Remote: [local] Application: pg_dump
6 2m14s 2 23s886ms 1m50s 1m7s 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 #6
Day Hour Count Duration Avg duration Jun 06 23 2 2m14s 1m7s [ User: intelifix - Total duration: 2m14s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m14s - 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-06 23:14:46 Duration: 1m50s 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-06 23:40:52 Duration: 23s886ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
7 1m57s 2 57s468ms 1m 58s959ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 06 20 1 1m 1m 23 1 57s468ms 57s468ms [ User: intelifix - Total duration: 1m57s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m57s - Times executed: 2 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-06 20:05:20 Duration: 1m Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-06 23:18:25 Duration: 57s468ms Database: rio User: intelifix Remote: [local] Application: pg_dump
8 1m54s 2 22s89ms 1m32s 57s291ms 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 06 23 2 1m54s 57s291ms [ User: intelifix - Total duration: 1m54s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m54s - 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-06 23:11:38 Duration: 1m32s 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-06 23:40:07 Duration: 22s89ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
9 1m38s 2 21s85ms 1m17s 49s60ms 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 06 23 2 1m38s 49s60ms [ User: intelifix - Total duration: 1m38s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m38s - 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-06 23:12:55 Duration: 1m17s 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-06 23:40:28 Duration: 21s85ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
10 1m5s 4 1s919ms 32s668ms 16s289ms 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 06 20 2 30s249ms 15s124ms 23 2 34s907ms 17s453ms [ User: intelifix - Total duration: 1m5s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m5s - 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-06 23:18:59 Duration: 32s668ms 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-06 20:05:50 Duration: 28s330ms 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-06 23:41:12 Duration: 2s238ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
11 1m 4 1s547ms 30s556ms 15s38ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 06 20 2 27s773ms 13s886ms 23 2 32s378ms 16s189ms [ User: intelifix - Total duration: 1m - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m - Times executed: 4 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-06-06 23:19:34 Duration: 30s556ms 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-06 20:06:19 Duration: 26s226ms 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-06 23:41:14 Duration: 1s821ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
12 59s200ms 34 244ms 14s554ms 1s741ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 06 00 6 21s297ms 3s549ms 01 6 8s500ms 1s416ms 02 6 7s355ms 1s225ms 03 6 7s683ms 1s280ms 04 6 8s526ms 1s421ms 05 4 5s836ms 1s459ms [ User: intelifix - Total duration: 59s200ms - Times executed: 34 ]
[ Application: psql - Total duration: 59s200ms - Times executed: 34 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-06 00:05:16 Duration: 14s554ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-06 05:05:04 Duration: 2s899ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-06 04:45:04 Duration: 2s533ms Database: rio User: intelifix Remote: [local] Application: psql
13 53s991ms 4 2s565ms 24s289ms 13s497ms 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 06 20 2 27s135ms 13s567ms 23 2 26s855ms 13s427ms [ User: intelifix - Total duration: 53s991ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 53s991ms - 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-06 23:39:41 Duration: 24s289ms 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-06 20:08:36 Duration: 23s772ms 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-06 20:09:02 Duration: 3s363ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
14 52s414ms 4 8s24ms 18s809ms 13s103ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 06 00 2 36s333ms 18s166ms 06 2 16s80ms 8s40ms [ User: intelifix - Total duration: 52s414ms - Times executed: 4 ]
[ Application: psql - Total duration: 52s414ms - Times executed: 4 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-06 00:05:20 Duration: 18s809ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-06 00:05:37 Duration: 17s523ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-06 06:05:09 Duration: 8s56ms Database: rio User: intelifix Remote: [local] Application: psql
15 41s810ms 4 1s212ms 20s216ms 10s452ms 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 06 20 2 21s429ms 10s714ms 23 2 20s381ms 10s190ms [ User: intelifix - Total duration: 41s810ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 41s810ms - 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-06 20:04:03 Duration: 20s216ms 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-06 23:17:09 Duration: 19s48ms 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-06 23:41:10 Duration: 1s332ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
16 41s654ms 4 1s437ms 19s529ms 10s413ms 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 06 20 2 20s233ms 10s116ms 23 2 21s420ms 10s710ms [ User: intelifix - Total duration: 41s654ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 41s654ms - Times executed: 4 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-06 23:16:23 Duration: 19s529ms 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-06 20:03:13 Duration: 18s796ms 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-06 23:41:06 Duration: 1s891ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
17 40s598ms 4 1s606ms 18s844ms 10s149ms 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 06 20 2 20s146ms 10s73ms 23 2 20s451ms 10s225ms [ User: intelifix - Total duration: 40s598ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 40s598ms - Times executed: 4 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-06 23:15:48 Duration: 18s844ms 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-06 20:02:41 Duration: 18s335ms 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-06 20:08:45 Duration: 1s811ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
18 35s413ms 2 17s360ms 18s52ms 17s706ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 06 20 1 17s360ms 17s360ms 23 1 18s52ms 18s52ms [ User: intelifix - Total duration: 35s413ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 35s413ms - Times executed: 2 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-06-06 23:17:27 Duration: 18s52ms 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-06 20:04:20 Duration: 17s360ms Database: rio User: intelifix Remote: [local] Application: pg_dump
19 30s551ms 4 1s272ms 14s692ms 7s637ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 06 20 2 15s964ms 7s982ms 23 2 14s587ms 7s293ms [ User: intelifix - Total duration: 30s551ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 30s551ms - 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-06 20:03:28 Duration: 14s692ms 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-06 23:16:36 Duration: 13s234ms 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-06 23:41:07 Duration: 1s352ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
20 30s176ms 4 802ms 14s847ms 7s544ms copy public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 06 20 2 14s466ms 7s233ms 23 2 15s710ms 7s855ms [ User: intelifix - Total duration: 30s176ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 30s176ms - 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-06 23:16:03 Duration: 14s847ms 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-06 20:02:54 Duration: 13s663ms 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-06 23:41:04 Duration: 863ms 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 7m6s 2s495ms 10s11ms 3s89ms call rs_giga_triagem (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 06 00 6 24s593ms 4s98ms 01 6 19s670ms 3s278ms 02 6 17s791ms 2s965ms 03 6 19s511ms 3s251ms 04 6 18s74ms 3s12ms 05 6 17s714ms 2s952ms 06 6 18s201ms 3s33ms 07 6 19s549ms 3s258ms 08 6 17s575ms 2s929ms 09 6 19s520ms 3s253ms 10 6 19s89ms 3s181ms 11 6 20s511ms 3s418ms 12 6 17s125ms 2s854ms 13 6 18s180ms 3s30ms 14 6 17s314ms 2s885ms 15 6 17s677ms 2s946ms 16 6 17s148ms 2s858ms 17 6 18s148ms 3s24ms 18 6 18s662ms 3s110ms 19 6 17s705ms 2s950ms 20 6 16s735ms 2s789ms 21 6 18s159ms 3s26ms 22 6 17s675ms 2s945ms [ User: intelifix - Total duration: 7m6s - Times executed: 138 ]
[ Application: psql - Total duration: 7m6s - Times executed: 138 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-06 00:05:26 Duration: 10s11ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-06 05:05:09 Duration: 4s362ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-06 03:05:22 Duration: 4s252ms Database: rio User: intelifix Remote: [local] Application: psql
2 34 59s200ms 244ms 14s554ms 1s741ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 06 00 6 21s297ms 3s549ms 01 6 8s500ms 1s416ms 02 6 7s355ms 1s225ms 03 6 7s683ms 1s280ms 04 6 8s526ms 1s421ms 05 4 5s836ms 1s459ms [ User: intelifix - Total duration: 59s200ms - Times executed: 34 ]
[ Application: psql - Total duration: 59s200ms - Times executed: 34 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-06 00:05:16 Duration: 14s554ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-06 05:05:04 Duration: 2s899ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-06 04:45:04 Duration: 2s533ms Database: rio User: intelifix Remote: [local] Application: psql
3 32 1h27m28s 1s59ms 8m50s 2m44s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 06 07 2 8m52s 4m26s 08 2 5m11s 2m35s 09 2 5m30s 2m45s 10 2 5m14s 2m37s 11 2 5m27s 2m43s 12 2 5m12s 2m36s 13 2 5m10s 2m35s 14 2 5m6s 2m33s 15 2 5m7s 2m33s 16 2 5m3s 2m31s 17 2 5m20s 2m40s 18 2 5m6s 2m33s 19 2 5m6s 2m33s 20 2 5m11s 2m35s 21 2 5m9s 2m34s 22 2 5m36s 2m48s [ User: intelifix - Total duration: 1h27m28s - Times executed: 32 ]
[ Application: psql - Total duration: 1h27m28s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-06 07:13:51 Duration: 8m50s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-06 22:10:37 Duration: 5m35s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-06 09:10:29 Duration: 5m28s Database: rio User: intelifix Remote: [local] Application: psql
4 32 8m8s 430ms 54s321ms 15s252ms select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 06 07 2 55s849ms 27s924ms 08 2 28s420ms 14s210ms 09 2 31s915ms 15s957ms 10 2 28s722ms 14s361ms 11 2 31s897ms 15s948ms 12 2 28s463ms 14s231ms 13 2 28s87ms 14s43ms 14 2 26s922ms 13s461ms 15 2 27s361ms 13s680ms 16 2 28s404ms 14s202ms 17 2 26s485ms 13s242ms 18 2 28s180ms 14s90ms 19 2 27s333ms 13s666ms 20 2 29s983ms 14s991ms 21 2 29s703ms 14s851ms 22 2 30s340ms 15s170ms [ User: intelifix - Total duration: 8m8s - Times executed: 32 ]
[ Application: psql - Total duration: 8m8s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-06 07:14:45 Duration: 54s321ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-06 09:11:01 Duration: 31s343ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-06 11:10:58 Duration: 31s297ms Database: rio User: intelifix Remote: [local] Application: psql
5 29 5s745ms 151ms 261ms 198ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 06 00 1 153ms 153ms 01 1 189ms 189ms 03 1 160ms 160ms 04 24 4s821ms 200ms 05 2 421ms 210ms [ User: intelifix - Total duration: 5s745ms - Times executed: 29 ]
[ Application: [unknown] - Total duration: 5s745ms - Times executed: 29 ]
-
SELECT * FROM RS_TRIAGEM (429, 5, '113', 3, '241712558689,241730455476,241695563238,241698752629,241646252848,230055048895,241607287585,241597544547,241708369213,241689966283,241714230919,241635792736,241694251932,241602969207,241658217494,241593894449', NULL, NULL, 0320, 00);
Date: 2026-06-06 04:17:45 Duration: 261ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (429, 5, '113', 3, '241682713443,241636074155,241655621832,241650811430,241727001436,241646251030,241598148197,241646257292,241649688907,241656689803,241664839207,241695527880,241675469313,241647373754,241678333947,241634789797', NULL, NULL, 0320, 00);
Date: 2026-06-06 04:17:03 Duration: 242ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (429, 5, '113', 3, '241606239010,241630014854,241695603141,241727455778,241654561414,241598870727,241726980424,241654470216,241654447788,241593084561,241617367480,241630161839,241676777184,241728744456,241727000426,241659717180,241605413946,241659784864', NULL, NULL, 0320, 00);
Date: 2026-06-06 04:22:44 Duration: 237ms Database: rio User: intelifix Remote: [local] Application: [unknown]
6 7 3s3ms 334ms 511ms 429ms select pro_id, pgp_sym_decrypt(nome, ?)::varchar, pgp_sym_decrypt(descricao, ?)::varchar, pgp_sym_decrypt(classe, ?)::varchar, pgp_sym_decrypt(php, ?)::varchar, pgp_sym_decrypt(extras, ?)::varchar from progs order by pro_id;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 06 00 1 410ms 410ms 01 1 403ms 403ms 03 1 494ms 494ms 04 3 1s359ms 453ms 05 1 334ms 334ms [ User: lenon - Total duration: 3s3ms - Times executed: 7 ]
[ Application: [unknown] - Total duration: 3s3ms - Times executed: 7 ]
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-06-06 04:05:14 Duration: 511ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-06-06 03:54:27 Duration: 494ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-06-06 04:15:39 Duration: 441ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
7 6 3s200ms 470ms 590ms 533ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 06 00 1 590ms 590ms 01 1 570ms 570ms 04 3 1s560ms 520ms 05 1 478ms 478ms [ User: intelifix - Total duration: 3s200ms - Times executed: 6 ]
[ Application: [unknown] - Total duration: 3s200ms - Times executed: 6 ]
-
select * from rs_menu_grants (499, 19, 1);
Date: 2026-06-06 00:52:32 Duration: 590ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (500, 19, 1);
Date: 2026-06-06 04:05:14 Duration: 581ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (499, 81, 1);
Date: 2026-06-06 01:05:22 Duration: 570ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 5 810ms 151ms 193ms 162ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 06 00 2 306ms 153ms 03 1 193ms 193ms 04 2 309ms 154ms [ User: intelifix - Total duration: 810ms - Times executed: 5 ]
[ Application: [unknown] - Total duration: 810ms - Times executed: 5 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-06-06 03:57:41 Duration: 193ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0464;
Date: 2026-06-06 04:05:15 Duration: 156ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0305;
Date: 2026-06-06 00:53:25 Duration: 155ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 4 1m5s 1s919ms 32s668ms 16s289ms copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 06 20 2 30s249ms 15s124ms 23 2 34s907ms 17s453ms [ User: intelifix - Total duration: 1m5s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m5s - 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-06 23:18:59 Duration: 32s668ms 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-06 20:05:50 Duration: 28s330ms 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-06 23:41:12 Duration: 2s238ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
10 4 1m 1s547ms 30s556ms 15s38ms 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 Jun 06 20 2 27s773ms 13s886ms 23 2 32s378ms 16s189ms [ User: intelifix - Total duration: 1m - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m - Times executed: 4 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-06-06 23:19:34 Duration: 30s556ms 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-06 20:06:19 Duration: 26s226ms 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-06 23:41:14 Duration: 1s821ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
11 4 53s991ms 2s565ms 24s289ms 13s497ms 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 Jun 06 20 2 27s135ms 13s567ms 23 2 26s855ms 13s427ms [ User: intelifix - Total duration: 53s991ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 53s991ms - 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-06 23:39:41 Duration: 24s289ms 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-06 20:08:36 Duration: 23s772ms 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-06 20:09:02 Duration: 3s363ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
12 4 52s414ms 8s24ms 18s809ms 13s103ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 06 00 2 36s333ms 18s166ms 06 2 16s80ms 8s40ms [ User: intelifix - Total duration: 52s414ms - Times executed: 4 ]
[ Application: psql - Total duration: 52s414ms - Times executed: 4 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-06 00:05:20 Duration: 18s809ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-06 00:05:37 Duration: 17s523ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-06 06:05:09 Duration: 8s56ms Database: rio User: intelifix Remote: [local] Application: psql
13 4 41s810ms 1s212ms 20s216ms 10s452ms 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 Jun 06 20 2 21s429ms 10s714ms 23 2 20s381ms 10s190ms [ User: intelifix - Total duration: 41s810ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 41s810ms - 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-06 20:04:03 Duration: 20s216ms 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-06 23:17:09 Duration: 19s48ms 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-06 23:41:10 Duration: 1s332ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
14 4 41s654ms 1s437ms 19s529ms 10s413ms 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 Jun 06 20 2 20s233ms 10s116ms 23 2 21s420ms 10s710ms [ User: intelifix - Total duration: 41s654ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 41s654ms - Times executed: 4 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-06 23:16:23 Duration: 19s529ms 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-06 20:03:13 Duration: 18s796ms 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-06 23:41:06 Duration: 1s891ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
15 4 40s598ms 1s606ms 18s844ms 10s149ms 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 Jun 06 20 2 20s146ms 10s73ms 23 2 20s451ms 10s225ms [ User: intelifix - Total duration: 40s598ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 40s598ms - Times executed: 4 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-06 23:15:48 Duration: 18s844ms 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-06 20:02:41 Duration: 18s335ms 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-06 20:08:45 Duration: 1s811ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
16 4 30s551ms 1s272ms 14s692ms 7s637ms 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 #16
Day Hour Count Duration Avg duration Jun 06 20 2 15s964ms 7s982ms 23 2 14s587ms 7s293ms [ User: intelifix - Total duration: 30s551ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 30s551ms - 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-06 20:03:28 Duration: 14s692ms 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-06 23:16:36 Duration: 13s234ms 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-06 23:41:07 Duration: 1s352ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
17 4 30s176ms 802ms 14s847ms 7s544ms 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 #17
Day Hour Count Duration Avg duration Jun 06 20 2 14s466ms 7s233ms 23 2 15s710ms 7s855ms [ User: intelifix - Total duration: 30s176ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 30s176ms - 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-06 23:16:03 Duration: 14s847ms 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-06 20:02:54 Duration: 13s663ms 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-06 23:41:04 Duration: 863ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
18 4 22s94ms 729ms 10s712ms 5s523ms 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 Jun 06 20 2 10s652ms 5s326ms 23 2 11s441ms 5s720ms [ User: intelifix - Total duration: 22s94ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 22s94ms - 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-06 23:16:50 Duration: 10s712ms 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-06 20:03:42 Duration: 9s904ms 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-06 20:08:50 Duration: 748ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
19 4 22s88ms 797ms 10s500ms 5s522ms 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 #19
Day Hour Count Duration Avg duration Jun 06 20 2 11s297ms 5s648ms 23 2 10s790ms 5s395ms [ User: intelifix - Total duration: 22s88ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 22s88ms - 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-06 20:02:19 Duration: 10s500ms 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-06 23:15:26 Duration: 9s977ms 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-06 23:41:01 Duration: 813ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
20 4 18s614ms 2s274ms 7s31ms 4s653ms 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 #20
Day Hour Count Duration Avg duration Jun 06 20 2 9s306ms 4s653ms 23 2 9s308ms 4s654ms [ User: intelifix - Total duration: 18s614ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 18s614ms - 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-06 20:06:41 Duration: 7s31ms 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-06 23:37:37 Duration: 6s227ms 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-06 23:41:47 Duration: 3s80ms 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 2m1s 7m34s 4m48s 2 9m36s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 06 05 2 9m36s 4m48s [ User: intelifix - Total duration: 9m36s - Times executed: 2 ]
[ Application: psql - Total duration: 9m36s - Times executed: 2 ]
-
analyze verbose;
Date: 2026-06-06 05:07:35 Duration: 7m34s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-06 05:09:37 Duration: 2m1s Database: contagem User: intelifix Remote: [local] Application: psql
2 1s59ms 8m50s 2m44s 32 1h27m28s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 06 07 2 8m52s 4m26s 08 2 5m11s 2m35s 09 2 5m30s 2m45s 10 2 5m14s 2m37s 11 2 5m27s 2m43s 12 2 5m12s 2m36s 13 2 5m10s 2m35s 14 2 5m6s 2m33s 15 2 5m7s 2m33s 16 2 5m3s 2m31s 17 2 5m20s 2m40s 18 2 5m6s 2m33s 19 2 5m6s 2m33s 20 2 5m11s 2m35s 21 2 5m9s 2m34s 22 2 5m36s 2m48s [ User: intelifix - Total duration: 1h27m28s - Times executed: 32 ]
[ Application: psql - Total duration: 1h27m28s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-06 07:13:51 Duration: 8m50s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-06 22:10:37 Duration: 5m35s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-06 09:10:29 Duration: 5m28s Database: rio User: intelifix Remote: [local] Application: psql
3 1m19s 1m26s 1m22s 2 2m45s 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 06 20 1 1m19s 1m19s 23 1 1m26s 1m26s [ User: intelifix - Total duration: 2m45s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m45s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-06 23:39:16 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-06 20:08:12 Duration: 1m19s Database: rio User: intelifix Remote: [local] Application: pg_dump
4 23s886ms 1m50s 1m7s 2 2m14s 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 Jun 06 23 2 2m14s 1m7s [ User: intelifix - Total duration: 2m14s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m14s - 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-06 23:14:46 Duration: 1m50s 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-06 23:40:52 Duration: 23s886ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
5 57s468ms 1m 58s959ms 2 1m57s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 06 20 1 1m 1m 23 1 57s468ms 57s468ms [ User: intelifix - Total duration: 1m57s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m57s - Times executed: 2 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-06 20:05:20 Duration: 1m Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-06 23:18:25 Duration: 57s468ms Database: rio User: intelifix Remote: [local] Application: pg_dump
6 22s89ms 1m32s 57s291ms 2 1m54s 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 06 23 2 1m54s 57s291ms [ User: intelifix - Total duration: 1m54s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m54s - 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-06 23:11:38 Duration: 1m32s 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-06 23:40:07 Duration: 22s89ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
7 21s85ms 1m17s 49s60ms 2 1m38s 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 06 23 2 1m38s 49s60ms [ User: intelifix - Total duration: 1m38s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m38s - 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-06 23:12:55 Duration: 1m17s 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-06 23:40:28 Duration: 21s85ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
8 17s360ms 18s52ms 17s706ms 2 35s413ms 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 06 20 1 17s360ms 17s360ms 23 1 18s52ms 18s52ms [ User: intelifix - Total duration: 35s413ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 35s413ms - Times executed: 2 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-06-06 23:17:27 Duration: 18s52ms 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-06 20:04:20 Duration: 17s360ms Database: rio User: intelifix Remote: [local] Application: pg_dump
9 1s919ms 32s668ms 16s289ms 4 1m5s copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 06 20 2 30s249ms 15s124ms 23 2 34s907ms 17s453ms [ User: intelifix - Total duration: 1m5s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m5s - 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-06 23:18:59 Duration: 32s668ms 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-06 20:05:50 Duration: 28s330ms 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-06 23:41:12 Duration: 2s238ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
10 430ms 54s321ms 15s252ms 32 8m8s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 06 07 2 55s849ms 27s924ms 08 2 28s420ms 14s210ms 09 2 31s915ms 15s957ms 10 2 28s722ms 14s361ms 11 2 31s897ms 15s948ms 12 2 28s463ms 14s231ms 13 2 28s87ms 14s43ms 14 2 26s922ms 13s461ms 15 2 27s361ms 13s680ms 16 2 28s404ms 14s202ms 17 2 26s485ms 13s242ms 18 2 28s180ms 14s90ms 19 2 27s333ms 13s666ms 20 2 29s983ms 14s991ms 21 2 29s703ms 14s851ms 22 2 30s340ms 15s170ms [ User: intelifix - Total duration: 8m8s - Times executed: 32 ]
[ Application: psql - Total duration: 8m8s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-06 07:14:45 Duration: 54s321ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-06 09:11:01 Duration: 31s343ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-06 11:10:58 Duration: 31s297ms Database: rio User: intelifix Remote: [local] Application: psql
11 1s547ms 30s556ms 15s38ms 4 1m copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 06 20 2 27s773ms 13s886ms 23 2 32s378ms 16s189ms [ User: intelifix - Total duration: 1m - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m - Times executed: 4 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-06-06 23:19:34 Duration: 30s556ms 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-06 20:06:19 Duration: 26s226ms 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-06 23:41:14 Duration: 1s821ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
12 2s565ms 24s289ms 13s497ms 4 53s991ms copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 06 20 2 27s135ms 13s567ms 23 2 26s855ms 13s427ms [ User: intelifix - Total duration: 53s991ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 53s991ms - 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-06 23:39:41 Duration: 24s289ms 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-06 20:08:36 Duration: 23s772ms 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-06 20:09:02 Duration: 3s363ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
13 8s24ms 18s809ms 13s103ms 4 52s414ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 06 00 2 36s333ms 18s166ms 06 2 16s80ms 8s40ms [ User: intelifix - Total duration: 52s414ms - Times executed: 4 ]
[ Application: psql - Total duration: 52s414ms - Times executed: 4 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-06 00:05:20 Duration: 18s809ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-06 00:05:37 Duration: 17s523ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-06 06:05:09 Duration: 8s56ms Database: rio User: intelifix Remote: [local] Application: psql
14 1s212ms 20s216ms 10s452ms 4 41s810ms 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 06 20 2 21s429ms 10s714ms 23 2 20s381ms 10s190ms [ User: intelifix - Total duration: 41s810ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 41s810ms - 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-06 20:04:03 Duration: 20s216ms 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-06 23:17:09 Duration: 19s48ms 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-06 23:41:10 Duration: 1s332ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
15 1s437ms 19s529ms 10s413ms 4 41s654ms 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 06 20 2 20s233ms 10s116ms 23 2 21s420ms 10s710ms [ User: intelifix - Total duration: 41s654ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 41s654ms - Times executed: 4 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-06 23:16:23 Duration: 19s529ms 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-06 20:03:13 Duration: 18s796ms 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-06 23:41:06 Duration: 1s891ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
16 1s606ms 18s844ms 10s149ms 4 40s598ms 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 06 20 2 20s146ms 10s73ms 23 2 20s451ms 10s225ms [ User: intelifix - Total duration: 40s598ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 40s598ms - Times executed: 4 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-06 23:15:48 Duration: 18s844ms 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-06 20:02:41 Duration: 18s335ms 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-06 20:08:45 Duration: 1s811ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
17 1s272ms 14s692ms 7s637ms 4 30s551ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 06 20 2 15s964ms 7s982ms 23 2 14s587ms 7s293ms [ User: intelifix - Total duration: 30s551ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 30s551ms - 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-06 20:03:28 Duration: 14s692ms 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-06 23:16:36 Duration: 13s234ms 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-06 23:41:07 Duration: 1s352ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
18 802ms 14s847ms 7s544ms 4 30s176ms copy public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 06 20 2 14s466ms 7s233ms 23 2 15s710ms 7s855ms [ User: intelifix - Total duration: 30s176ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 30s176ms - 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-06 23:16:03 Duration: 14s847ms 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-06 20:02:54 Duration: 13s663ms 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-06 23:41:04 Duration: 863ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
19 729ms 10s712ms 5s523ms 4 22s94ms 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 #19
Day Hour Count Duration Avg duration Jun 06 20 2 10s652ms 5s326ms 23 2 11s441ms 5s720ms [ User: intelifix - Total duration: 22s94ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 22s94ms - 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-06 23:16:50 Duration: 10s712ms 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-06 20:03:42 Duration: 9s904ms 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-06 20:08:50 Duration: 748ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
20 797ms 10s500ms 5s522ms 4 22s88ms 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 #20
Day Hour Count Duration Avg duration Jun 06 20 2 11s297ms 5s648ms 23 2 10s790ms 5s395ms [ User: intelifix - Total duration: 22s88ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 22s88ms - 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-06 20:02:19 Duration: 10s500ms 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-06 23:15:26 Duration: 9s977ms 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-06 23:41:01 Duration: 813ms 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 4 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jun 06 12 1 0ms 0ms 13 1 0ms 0ms 17 2 0ms 0ms [ User: intelifix - Total duration: 8s298ms - Times executed: 4 ]
[ Application: psql - Total duration: 8s298ms - Times executed: 4 ]
-
;
Date: Duration: 0ms Database: postgres User: rio Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 3,068 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 427 FATAL entries
- 49 ERROR entries
- 0 WARNING entries
- 1 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 388 Max number of times the same event was reported
- 477 Total events found
Rank Times reported Error 1 388 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jun 06 00 20 01 14 02 14 03 15 04 15 05 21 06 16 07 15 08 17 09 16 10 16 11 17 12 17 13 18 14 17 15 16 16 17 17 18 18 17 19 16 20 18 21 18 22 19 23 1 - FATAL: database "brasilia" does not exist
- FATAL: database "testes" does not exist
- FATAL: database "brasilia" does not exist
Date: 2026-06-06 00:02:05 Database: brasilia Application: [unknown] User: lenon Remote: [local]
Date: 2026-06-06 00:02:06 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-06-06 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 06 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-06 08:00:25 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-06 08:20:07 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-06 08:40:07 Database: rio Application: psql User: intelifix Remote: [local]
3 35 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 06 07 1 08 3 09 3 10 3 11 2 12 2 13 1 14 3 15 3 16 2 17 1 18 3 19 3 20 2 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-06 07:55:19 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-06 08:15:19 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-06 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 06 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-06 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Context: SQL statement "SELECT A.USU_CHAVE AS CHAVE, A.USU_NOME AS TECNICO, C.DEP_NOME AS DEPARTAMENTO FROM USUARIOS A INNER JOIN TECNICOS B ON B.USU_ID = A.USU_ID AND B.TEC_STATUS = 0 INNER JOIN DEPARTAMENTOS C ON C.DEP_ID = B.DEP_ID WHERE A.USU_ATIVO = 'S' AND A.OFI_ID = nOficina ORDER BY 2" PL/pgSQL function rs_giga_tecnicos() line 26 at FOR over SELECT rows
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-06-06 03:05:01 Database: rio Application: psql User: intelifix Remote: [local]
Date: 2026-06-06 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
5 2 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Jun 06 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-06 05:30:16 Database: contagem Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-06-06 05:30:16 Database: contagem Application: psql User: intelifix Remote: [local]
6 2 ERROR: could not connect to server "..."
Times Reported Most Frequent Error / Event #6
Day Hour Count Jun 06 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-06 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-06 05:30:01 Database: rio 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 06 03 1 - LOG: database system was shut down at 2026-06-06 03:05:01 -03
Date: 2026-06-06 03:05:03
8 1 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #8
Day Hour Count Jun 06 03 1 - FATAL: the database system is shutting down
Date: 2026-06-06 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]