pgBadger-
Global information
- Generated on Sat Jun 13 23:50:06 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 5,083 log entries in 4s
- Log start from 2026-06-13 00:02:01 to 2026-06-13 23:46:19
-
Overview
Global Stats
- 141 Number of unique normalized queries
- 582 Number of queries
- 2h38m59s Total query duration
- 2026-06-13 00:02:09 First query
- 2026-06-13 23:45:20 Last query
- 4 queries/s at 2026-06-13 23:45:01 Query peak
- 2h38m59s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 2h38m59s Execute total duration
- 467 Number of events
- 15 Number of unique normalized events
- 138 Max number of times the same event was reported
- 0 Number of cancellation
- 8 Total number of automatic vacuums
- 13 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 132 Total number of sessions
- 5 sessions at 2026-06-13 00:05:23 Session peak
- 4d22h15m56s Total duration of sessions
- 53m45s Average duration of sessions
- 4 Average queries per session
- 1m12s Average queries duration per session
- 52m33s Average idle time per session
- 134 Total number of connections
- 4 connections/s at 2026-06-13 06:02:09 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 4 queries/s Query Peak
- 2026-06-13 23:45:01 Date
SELECT Traffic
Key values
- 3 queries/s Query Peak
- 2026-06-13 05:18:34 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-06-13 23:45:01 Date
Queries duration
Key values
- 2h38m59s 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 13 00 15 0ms 18s95ms 5s661ms 8s570ms 55s941ms 55s941ms 01 35 0ms 2s890ms 916ms 4s260ms 5s207ms 5s924ms 02 12 0ms 3s288ms 1s978ms 4s817ms 4s817ms 4s817ms 03 12 0ms 3s147ms 1s915ms 4s222ms 4s222ms 4s222ms 04 19 0ms 3s647ms 1s700ms 5s924ms 6s726ms 6s726ms 05 31 0ms 7m22s 19s175ms 5s515ms 2m4s 7m22s 06 10 0ms 8s707ms 4s181ms 9s362ms 19s382ms 19s382ms 07 12 0ms 7m26s 43s256ms 55s549ms 7m26s 7m26s 08 10 0ms 5m28s 37s489ms 3s317ms 5m57s 5m57s 09 10 0ms 5m42s 39s221ms 30s774ms 5m42s 5m42s 10 10 0ms 5m43s 38s861ms 29s15ms 5m43s 5m43s 11 10 0ms 5m32s 38s168ms 32s759ms 5m32s 5m32s 12 10 0ms 5m24s 37s282ms 3s148ms 5m55s 5m55s 13 10 0ms 5m27s 37s279ms 5m56s 5m56s 5m56s 14 10 0ms 5m20s 36s545ms 3s241ms 5m48s 5m48s 15 10 0ms 5m38s 38s665ms 30s888ms 5m38s 5m38s 16 10 0ms 5m27s 37s714ms 3s568ms 5m57s 5m57s 17 10 0ms 5m22s 36s710ms 3s11ms 5m51s 5m51s 18 11 0ms 5m15s 33s125ms 3s248ms 5m46s 5m46s 19 10 0ms 5m15s 36s39ms 5m44s 5m44s 5m44s 20 63 0ms 5m23s 12s778ms 1m58s 5m54s 5m54s 21 11 0ms 5m22s 33s531ms 3s261ms 5m52s 5m52s 22 10 0ms 5m50s 40s64ms 31s508ms 5m50s 5m50s 23 231 0ms 2m23s 9s131ms 1m29s 1m59s 2m23s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 13 00 2 0 4s285ms 0ms 0ms 8s570ms 01 23 0 244ms 228ms 360ms 1s223ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 7 0 376ms 629ms 903ms 943ms 05 18 0 316ms 526ms 636ms 1s266ms 06 2 0 4s681ms 0ms 0ms 9s362ms 07 6 0 1m23s 894ms 55s549ms 7m26s 08 4 0 1m29s 0ms 0ms 5m57s 09 4 0 1m33s 0ms 30s774ms 5m42s 10 4 0 1m33s 0ms 29s15ms 5m43s 11 4 0 1m31s 0ms 32s759ms 5m32s 12 4 0 1m28s 0ms 0ms 5m55s 13 4 0 1m29s 0ms 5m56s 5m56s 14 4 0 1m27s 0ms 0ms 5m48s 15 4 0 1m32s 0ms 30s888ms 5m38s 16 4 0 1m29s 0ms 1s618ms 5m57s 17 4 0 1m27s 0ms 0ms 5m51s 18 5 0 1m9s 0ms 1s122ms 5m46s 19 4 0 1m26s 0ms 5m44s 5m44s 20 6 51 13s792ms 1m3s 1m58s 5m54s 21 5 0 1m10s 0ms 574ms 5m52s 22 4 0 1m35s 0ms 31s508ms 5m50s 23 10 221 9s131ms 1m9s 1m29s 2m23s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 13 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 13 00 0 0 0.00 0.00% 01 0 2 2.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 3 3.00 0.00% 05 0 2 2.00 0.00% 06 0 0 0.00 0.00% 07 0 1 1.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 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 13 00 11 0.00/s 01 6 0.00/s 02 4 0.00/s 03 10 0.00/s 04 7 0.00/s 05 7 0.00/s 06 9 0.00/s 07 7 0.00/s 08 5 0.00/s 09 4 0.00/s 10 5 0.00/s 11 4 0.00/s 12 5 0.00/s 13 5 0.00/s 14 4 0.00/s 15 4 0.00/s 16 4 0.00/s 17 4 0.00/s 18 4 0.00/s 19 5 0.00/s 20 8 0.00/s 21 4 0.00/s 22 5 0.00/s 23 3 0.00/s Day Hour Count Average Duration Average idle time Jun 13 00 2 45m47s 45m4s 01 10 1h52s 1h49s 02 6 1h30s 1h26s 03 8 23m21s 23m18s 04 4 1h45s 1h37s 05 7 1h10s 58m45s 06 7 56m51s 56m45s 07 8 1h1m41s 1h36s 08 8 54m30s 53m43s 09 4 1h 58m22s 10 5 50m 48m42s 11 4 1h1m23s 59m47s 12 5 50m 48m46s 13 4 1h 58m27s 14 5 54m36s 53m23s 15 4 1h45s 59m8s 16 4 1h37s 59m2s 17 4 1h6s 58m34s 18 4 1h1m19s 59m48s 19 4 1h7s 58m37s 20 8 39m4s 37m24s 21 5 1h1m5s 59m51s 22 5 50m1s 48m40s 23 7 39m19s 34m18s -
Connections
Established Connections
Key values
- 4 connections Connection Peak
- 2026-06-13 06:02:09 Date
Connections per database
Key values
- rio Main Database
- 134 connections Total
Connections per user
Key values
- intelifix Main User
- 134 connections Total
-
Sessions
Simultaneous sessions
Key values
- 5 sessions Session Peak
- 2026-06-13 00:05:23 Date
Histogram of session times
Key values
- 110 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 132 sessions Total
Sessions per user
Key values
- intelifix Main User
- 132 sessions Total
Sessions per host
Key values
- [local] Main Host
- 132 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 9,016 buffers Checkpoint Peak
- 2026-06-13 00:09:53 Date
- 270.000 seconds Highest write time
- 0.009 seconds Sync time
Checkpoints Wal files
Key values
- 3 files Wal files usage Peak
- 2026-06-13 00:09:53 Date
Checkpoints distance
Key values
- 101.27 Mo Distance Peak
- 2026-06-13 00:09:53 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jun 13 00 14,205 664.302s 0.018s 664.354s 01 4,286 430.427s 0.046s 430.52s 02 1,697 170.47s 0.024s 170.525s 03 1,770 177.51s 0.017s 177.555s 04 2,967 298.006s 0.027s 298.074s 05 8,109 768.075s 0.033s 768.154s 06 4,542 269.871s 0.002s 269.88s 07 1,020 102.382s 0.007s 102.401s 08 22 2.25s 0.003s 2.261s 09 21 2.13s 0.003s 2.138s 10 21 2.131s 0.003s 2.139s 11 21 2.131s 0.003s 2.138s 12 21 2.133s 0.003s 2.14s 13 20 2.03s 0.003s 2.036s 14 20 2.026s 0.003s 2.033s 15 21 2.13s 0.004s 2.139s 16 21 2.129s 0.003s 2.138s 17 470 47.08s 0.001s 47.086s 18 833 83.523s 0.004s 83.537s 19 21 2.128s 0.003s 2.136s 20 206 20.718s 0.008s 20.736s 21 38 3.863s 0.008s 3.883s 22 20 2.033s 0.003s 2.039s 23 584 58.56s 0.005s 58.582s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jun 13 00 0 0 5 433 0.003s 0.008s 01 0 0 2 886 0.003s 0.01s 02 0 0 0 456 0.003s 0.007s 03 0 0 1 347 0.003s 0.006s 04 0 0 1 578 0.003s 0.009s 05 0 0 3 730 0.003s 0.009s 06 0 0 1 8 0.002s 0.001s 07 0 0 0 18 0.002s 0.003s 08 0 0 0 4 0.002s 0.002s 09 0 0 0 3 0.003s 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 3 0.002s 0.001s 14 0 0 0 3 0.002s 0.001s 15 0 0 0 3 0.003s 0.002s 16 0 0 0 3 0.002s 0.001s 17 0 0 0 5 0.001s 0.001s 18 0 0 0 28 0.002s 0.002s 19 0 0 0 3 0.002s 0.001s 20 0 0 0 22 0.002s 0.003s 21 0 0 0 12 0.002s 0.004s 22 0 0 0 3 0.002s 0.001s 23 0 0 1 11 0.002s 0.004s Day Hour Count Avg time (sec) Jun 13 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 13 00 12,308.43 kB 40,760.57 kB 01 2,147.30 kB 18,334.20 kB 02 1,199.14 kB 8,228.86 kB 03 1,293.71 kB 2,217.00 kB 04 1,682.67 kB 2,638.33 kB 05 6,299.56 kB 16,162.33 kB 06 7,474.00 kB 12,268.00 kB 07 1,959.00 kB 10,466.00 kB 08 84.00 kB 8,073.50 kB 09 166.00 kB 6,908.00 kB 10 166.00 kB 6,234.00 kB 11 165.00 kB 5,627.00 kB 12 165.00 kB 5,081.00 kB 13 165.00 kB 4,589.00 kB 14 165.00 kB 4,147.00 kB 15 166.00 kB 3,749.00 kB 16 166.00 kB 3,391.00 kB 17 988.00 kB 3,150.00 kB 18 1,241.50 kB 2,918.50 kB 19 166.00 kB 2,516.00 kB 20 302.67 kB 2,107.00 kB 21 69.33 kB 1,574.33 kB 22 165.00 kB 1,289.00 kB 23 285.00 kB 1,080.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 13 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.33 sec Highest CPU-cost vacuum
Table public.logs
Database rio - 2026-06-13 17:11:47 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 0.33 sec Highest CPU-cost vacuum
Table public.logs
Database rio - 2026-06-13 17:11:47 Date
Analyzes per table
Key values
- public.temp0000282483 (11) Main table analyzed (database rio)
- 13 analyzes Total
Vacuums per table
Key values
- pg_toast.pg_toast_2619 (1) Main table vacuumed on database brasilia
- 8 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples brasilia.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 64 15 75,976 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 163 8 25,749 0 0 rio.pg_catalog.pg_statistic 1 1 0 0 0 0 0 3,457 474 2,116,581 430 2,679 rio.pg_catalog.pg_index 1 1 0 0 0 0 0 120 45 23,883 1 1 rio.public.logs 1 0 0 0 0 0 0 1,069 672 835,311 189 4,725 rio.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 828 151 972,416 89 391 brasilia.pg_catalog.pg_statistic 1 1 0 0 0 0 0 86 4 8,043 0 0 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,308 6 164,164 0 0 Total 8 7 0 0 0 0 0 8,095 1,375 4,222,123 709 7,796 Vacuum throughput per table
Key values
- public.logs (0.33) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed brasilia.pg_toast.pg_toast_2619 0 0 0 contagem.pg_toast.pg_toast_2619 0 0 0.02 rio.pg_catalog.pg_statistic 0 0 0.27 rio.pg_catalog.pg_index 0 0 0.05 rio.public.logs 0 0 0.33 rio.pg_toast.pg_toast_2619 0 0 0.06 brasilia.pg_catalog.pg_statistic 0 0 0 contagem.pg_catalog.pg_statistic 0 0 0.04 Total 0 0 0.77 Tuples removed per table
Key values
- pg_catalog.pg_statistic (4451) Main table with removed tuples on database rio
- 9780 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_statistic 1 1 4,451 7,475 0 0 1,286 contagem.pg_catalog.pg_statistic 1 1 4,269 7,274 0 0 1,011 rio.pg_toast.pg_toast_2619 1 1 565 679 0 0 259 brasilia.pg_catalog.pg_statistic 1 1 164 449 0 0 36 rio.pg_catalog.pg_index 1 1 135 1,879 0 0 58 contagem.pg_toast.pg_toast_2619 1 1 132 113 0 7 58 brasilia.pg_toast.pg_toast_2619 1 1 64 14 0 0 18 rio.public.logs 1 0 0 15,873,935 0 0 634,234 Total 8 7 9,780 15,891,818 0 7 636,960 Pages removed per table
Key values
- pg_toast.pg_toast_2619 (7) Main table with removed pages on database contagem
- 7 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed contagem.pg_toast.pg_toast_2619 1 1 132 7 brasilia.pg_toast.pg_toast_2619 1 1 64 0 rio.pg_catalog.pg_statistic 1 1 4451 0 rio.pg_catalog.pg_index 1 1 135 0 rio.public.logs 1 0 0 0 rio.pg_toast.pg_toast_2619 1 1 565 0 brasilia.pg_catalog.pg_statistic 1 1 164 0 contagem.pg_catalog.pg_statistic 1 1 4269 0 Total 8 7 9,780 7 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jun 13 00 0 0 01 0 7 02 0 0 03 0 0 04 0 3 05 7 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 1 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 - 0.33 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
- 132 Total read queries
- 272 Total write queries
Queries by database
Key values
- rio Main database
- 414 Requests
- 2h33m18s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 570 Requests
User Request type Count Duration intelifix Total 570 2h38m38s copy to 272 42m17s others 178 17m51s select 120 1h38m29s lenon Total 12 21s110ms select 12 21s110ms Duration by user
Key values
- 2h38m38s (intelifix) Main time consuming user
User Request type Count Duration intelifix Total 570 2h38m38s copy to 272 42m17s others 178 17m51s select 120 1h38m29s lenon Total 12 21s110ms select 12 21s110ms Queries by host
Key values
- [local] Main host
- 582 Requests
- 2h38m59s ([local])
- Main time consuming host
Queries by application
Key values
- pg_dump Main application
- 284 Requests
- 1h56m23s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-06-13 20:15:04 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 220 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 7m26s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-13 07:12:27 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 7m22s analyze verbose;[ Date: 2026-06-13 05:07:23 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 5m50s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-13 22:10:52 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 5m43s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-13 10:10:45 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 5m42s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-13 09:10:44 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 5m38s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-13 15:10:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 5m32s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-13 11:10:33 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 5m28s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-13 08:10:29 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 5m27s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-13 13:10:28 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 5m27s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-13 16:10:28 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 5m24s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-13 12:10:26 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m23s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-13 20:10:24 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 5m22s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-13 17:10:24 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m22s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-13 21:10:23 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m20s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-13 14:10:21 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m15s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-13 18:10:17 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m15s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-13 19:10:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 2m23s 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-13 23:15:57 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
19 2m4s analyze verbose;[ Date: 2026-06-13 05:09:28 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
20 1m59s 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-13 23:12:04 - 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 1h29m59s 32 783ms 7m26s 2m48s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 13 07 2 7m28s 3m44s 08 2 5m29s 2m44s 09 2 5m43s 2m51s 10 2 5m44s 2m52s 11 2 5m33s 2m46s 12 2 5m25s 2m42s 13 2 5m28s 2m44s 14 2 5m21s 2m40s 15 2 5m39s 2m49s 16 2 5m28s 2m44s 17 2 5m23s 2m41s 18 2 5m16s 2m38s 19 2 5m16s 2m38s 20 2 5m24s 2m42s 21 2 5m23s 2m41s 22 2 5m51s 2m55s [ User: intelifix - Total duration: 1h29m59s - Times executed: 32 ]
[ Application: psql - Total duration: 1h29m59s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-13 07:12:27 Duration: 7m26s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-13 22:10:52 Duration: 5m50s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-13 10:10:45 Duration: 5m43s Database: rio User: intelifix Remote: [local] Application: psql
2 9m26s 3 340ms 7m22s 3m8s analyze verbose;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 13 05 3 9m26s 3m8s [ User: intelifix - Total duration: 9m26s - Times executed: 3 ]
[ Application: psql - Total duration: 9m26s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-06-13 05:07:23 Duration: 7m22s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-13 05:09:28 Duration: 2m4s Database: contagem User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-13 05:07:23 Duration: 340ms Database: brasilia User: intelifix Remote: [local] Application: psql
3 8m13s 32 428ms 51s487ms 15s410ms select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 13 07 2 52s903ms 26s451ms 08 2 28s340ms 14s170ms 09 2 29s783ms 14s891ms 10 2 27s828ms 13s914ms 11 2 31s366ms 15s683ms 12 2 29s610ms 14s805ms 13 2 28s556ms 14s278ms 14 2 27s907ms 13s953ms 15 2 29s974ms 14s987ms 16 2 31s310ms 15s655ms 17 2 28s186ms 14s93ms 18 2 29s700ms 14s850ms 19 2 28s121ms 14s60ms 20 2 30s291ms 15s145ms 21 2 28s891ms 14s445ms 22 2 30s348ms 15s174ms [ User: intelifix - Total duration: 8m13s - Times executed: 32 ]
[ Application: psql - Total duration: 8m13s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-13 07:13:19 Duration: 51s487ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-13 16:10:59 Duration: 30s835ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-13 11:11:04 Duration: 30s768ms Database: rio User: intelifix Remote: [local] Application: psql
4 6m36s 138 2s341ms 9s72ms 2s869ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 13 00 6 24s28ms 4s4ms 01 6 16s278ms 2s713ms 02 6 17s782ms 2s963ms 03 6 15s918ms 2s653ms 04 6 19s326ms 3s221ms 05 6 15s837ms 2s639ms 06 6 15s616ms 2s602ms 07 6 16s556ms 2s759ms 08 6 16s989ms 2s831ms 09 6 18s571ms 3s95ms 10 6 16s338ms 2s723ms 11 6 16s838ms 2s806ms 12 6 17s398ms 2s899ms 13 6 15s957ms 2s659ms 14 6 16s524ms 2s754ms 15 6 17s96ms 2s849ms 16 6 17s550ms 2s925ms 17 6 15s309ms 2s551ms 18 6 16s850ms 2s808ms 19 6 15s859ms 2s643ms 20 6 18s922ms 3s153ms 21 6 15s918ms 2s653ms 22 6 18s530ms 3s88ms [ User: intelifix - Total duration: 6m36s - Times executed: 138 ]
[ Application: psql - Total duration: 6m36s - Times executed: 138 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-13 00:05:21 Duration: 9s72ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-13 04:55:08 Duration: 3s647ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-13 16:35:05 Duration: 3s568ms Database: rio User: intelifix Remote: [local] Application: psql
5 2m58s 2 1m25s 1m33s 1m29s 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 13 20 1 1m25s 1m25s 23 1 1m33s 1m33s [ User: intelifix - Total duration: 2m58s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m58s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-13 23:42:37 Duration: 1m33s 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-13 20:08:23 Duration: 1m25s Database: rio User: intelifix Remote: [local] Application: pg_dump
6 2m46s 2 23s457ms 2m23s 1m23s 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 13 23 2 2m46s 1m23s [ User: intelifix - Total duration: 2m46s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m46s - 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-13 23:15:57 Duration: 2m23s 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-13 23:44:13 Duration: 23s457ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
7 2m20s 2 20s438ms 1m59s 1m10s 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 #7
Day Hour Count Duration Avg duration Jun 13 23 2 2m20s 1m10s [ User: intelifix - Total duration: 2m20s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m20s - 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-13 23:12:04 Duration: 1m59s 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-13 23:43:28 Duration: 20s438ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
8 1m59s 2 57s150ms 1m2s 59s822ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 13 20 1 57s150ms 57s150ms 23 1 1m2s 1m2s [ User: intelifix - Total duration: 1m59s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m59s - Times executed: 2 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-13 23:20:25 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-13 20:05:20 Duration: 57s150ms Database: rio User: intelifix Remote: [local] Application: pg_dump
9 1m50s 2 21s164ms 1m29s 55s271ms 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 13 23 2 1m50s 55s271ms [ User: intelifix - Total duration: 1m50s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m50s - 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-13 23:13:34 Duration: 1m29s 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-13 23:43:49 Duration: 21s164ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
10 1m7s 4 2s183ms 33s861ms 16s960ms 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 13 20 2 31s642ms 15s821ms 23 2 36s199ms 18s99ms [ User: intelifix - Total duration: 1m7s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m7s - 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-13 23:21:00 Duration: 33s861ms 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-13 20:05:50 Duration: 29s459ms 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-13 23:44:39 Duration: 2s337ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
11 1m4s 2 10s237ms 54s758ms 32s498ms copy auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 13 23 2 1m4s 32s498ms [ User: intelifix - Total duration: 1m4s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m4s - Times executed: 2 ]
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-13 23:16:52 Duration: 54s758ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-13 23:44:23 Duration: 10s237ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
12 58s333ms 4 1s490ms 28s46ms 14s583ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 13 20 2 28s796ms 14s398ms 23 2 29s537ms 14s768ms [ User: intelifix - Total duration: 58s333ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 58s333ms - Times executed: 4 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-06-13 23:21:31 Duration: 28s46ms 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-13 20:06:21 Duration: 27s75ms 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-13 20:09:10 Duration: 1s721ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
13 57s529ms 4 3s75ms 25s528ms 14s382ms 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 13 20 2 28s517ms 14s258ms 23 2 29s12ms 14s506ms [ User: intelifix - Total duration: 57s529ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 57s529ms - 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-13 23:43:03 Duration: 25s528ms 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-13 20:08:49 Duration: 25s441ms 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-13 23:45:18 Duration: 3s484ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
14 56s174ms 32 580ms 11s350ms 1s755ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 13 00 5 16s807ms 3s361ms 01 6 10s165ms 1s694ms 02 6 5s957ms 992ms 03 5 6s857ms 1s371ms 04 6 10s354ms 1s725ms 05 4 6s31ms 1s507ms [ User: intelifix - Total duration: 56s174ms - Times executed: 32 ]
[ Application: psql - Total duration: 56s174ms - Times executed: 32 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-13 00:05:12 Duration: 11s350ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-13 04:55:04 Duration: 3s79ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-13 05:05:04 Duration: 2s935ms Database: rio User: intelifix Remote: [local] Application: psql
15 52s350ms 4 8s124ms 18s95ms 13s87ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 13 00 2 35s518ms 17s759ms 06 2 16s831ms 8s415ms [ User: intelifix - Total duration: 52s350ms - Times executed: 4 ]
[ Application: psql - Total duration: 52s350ms - Times executed: 4 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-13 00:05:19 Duration: 18s95ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-13 00:05:36 Duration: 17s422ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-13 06:05:10 Duration: 8s707ms Database: rio User: intelifix Remote: [local] Application: psql
16 43s477ms 4 1s269ms 21s50ms 10s869ms copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 13 20 2 21s108ms 10s554ms 23 2 22s369ms 11s184ms [ User: intelifix - Total duration: 43s477ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 43s477ms - 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-13 23:19:03 Duration: 21s50ms 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-13 20:04:04 Duration: 19s838ms 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-13 23:44:36 Duration: 1s319ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
17 42s730ms 4 1s639ms 20s184ms 10s682ms 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 13 20 2 20s902ms 10s451ms 23 2 21s828ms 10s914ms [ User: intelifix - Total duration: 42s730ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 42s730ms - Times executed: 4 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-13 23:17:34 Duration: 20s184ms 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-13 20:02:44 Duration: 19s263ms 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-13 23:44:29 Duration: 1s644ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
18 41s9ms 4 1s441ms 19s216ms 10s252ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 13 20 2 20s351ms 10s175ms 23 2 20s657ms 10s328ms [ User: intelifix - Total duration: 41s9ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 41s9ms - Times executed: 4 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-13 23:18:08 Duration: 19s216ms 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-13 20:03:16 Duration: 18s661ms 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-13 20:09:01 Duration: 1s689ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
19 38s35ms 2 18s715ms 19s319ms 19s17ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 13 20 1 18s715ms 18s715ms 23 1 19s319ms 19s319ms [ User: intelifix - Total duration: 38s35ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 38s35ms - Times executed: 2 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-06-13 23:19:22 Duration: 19s319ms 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-13 20:04:22 Duration: 18s715ms Database: rio User: intelifix Remote: [local] Application: pg_dump
20 32s823ms 4 1s445ms 16s764ms 8s205ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 13 20 2 14s368ms 7s184ms 23 2 18s454ms 9s227ms [ User: intelifix - Total duration: 32s823ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 32s823ms - 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-13 23:18:25 Duration: 16s764ms 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-13 20:03:28 Duration: 12s922ms 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-13 23:44:34 Duration: 1s690ms 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 6m36s 2s341ms 9s72ms 2s869ms call rs_giga_triagem (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 13 00 6 24s28ms 4s4ms 01 6 16s278ms 2s713ms 02 6 17s782ms 2s963ms 03 6 15s918ms 2s653ms 04 6 19s326ms 3s221ms 05 6 15s837ms 2s639ms 06 6 15s616ms 2s602ms 07 6 16s556ms 2s759ms 08 6 16s989ms 2s831ms 09 6 18s571ms 3s95ms 10 6 16s338ms 2s723ms 11 6 16s838ms 2s806ms 12 6 17s398ms 2s899ms 13 6 15s957ms 2s659ms 14 6 16s524ms 2s754ms 15 6 17s96ms 2s849ms 16 6 17s550ms 2s925ms 17 6 15s309ms 2s551ms 18 6 16s850ms 2s808ms 19 6 15s859ms 2s643ms 20 6 18s922ms 3s153ms 21 6 15s918ms 2s653ms 22 6 18s530ms 3s88ms [ User: intelifix - Total duration: 6m36s - Times executed: 138 ]
[ Application: psql - Total duration: 6m36s - Times executed: 138 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-13 00:05:21 Duration: 9s72ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-13 04:55:08 Duration: 3s647ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-13 16:35:05 Duration: 3s568ms Database: rio User: intelifix Remote: [local] Application: psql
2 32 1h29m59s 783ms 7m26s 2m48s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 13 07 2 7m28s 3m44s 08 2 5m29s 2m44s 09 2 5m43s 2m51s 10 2 5m44s 2m52s 11 2 5m33s 2m46s 12 2 5m25s 2m42s 13 2 5m28s 2m44s 14 2 5m21s 2m40s 15 2 5m39s 2m49s 16 2 5m28s 2m44s 17 2 5m23s 2m41s 18 2 5m16s 2m38s 19 2 5m16s 2m38s 20 2 5m24s 2m42s 21 2 5m23s 2m41s 22 2 5m51s 2m55s [ User: intelifix - Total duration: 1h29m59s - Times executed: 32 ]
[ Application: psql - Total duration: 1h29m59s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-13 07:12:27 Duration: 7m26s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-13 22:10:52 Duration: 5m50s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-13 10:10:45 Duration: 5m43s Database: rio User: intelifix Remote: [local] Application: psql
3 32 8m13s 428ms 51s487ms 15s410ms select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 13 07 2 52s903ms 26s451ms 08 2 28s340ms 14s170ms 09 2 29s783ms 14s891ms 10 2 27s828ms 13s914ms 11 2 31s366ms 15s683ms 12 2 29s610ms 14s805ms 13 2 28s556ms 14s278ms 14 2 27s907ms 13s953ms 15 2 29s974ms 14s987ms 16 2 31s310ms 15s655ms 17 2 28s186ms 14s93ms 18 2 29s700ms 14s850ms 19 2 28s121ms 14s60ms 20 2 30s291ms 15s145ms 21 2 28s891ms 14s445ms 22 2 30s348ms 15s174ms [ User: intelifix - Total duration: 8m13s - Times executed: 32 ]
[ Application: psql - Total duration: 8m13s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-13 07:13:19 Duration: 51s487ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-13 16:10:59 Duration: 30s835ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-13 11:11:04 Duration: 30s768ms Database: rio User: intelifix Remote: [local] Application: psql
4 32 56s174ms 580ms 11s350ms 1s755ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 13 00 5 16s807ms 3s361ms 01 6 10s165ms 1s694ms 02 6 5s957ms 992ms 03 5 6s857ms 1s371ms 04 6 10s354ms 1s725ms 05 4 6s31ms 1s507ms [ User: intelifix - Total duration: 56s174ms - Times executed: 32 ]
[ Application: psql - Total duration: 56s174ms - Times executed: 32 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-13 00:05:12 Duration: 11s350ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-13 04:55:04 Duration: 3s79ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-13 05:05:04 Duration: 2s935ms Database: rio User: intelifix Remote: [local] Application: psql
5 27 6s219ms 153ms 338ms 230ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 13 01 13 2s439ms 187ms 05 14 3s780ms 270ms [ User: intelifix - Total duration: 6s219ms - Times executed: 27 ]
[ Application: [unknown] - Total duration: 6s219ms - Times executed: 27 ]
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '230041428890,229988746768,230034045252,229986795669,229988692140,230032419617,230028892842,230029342336,229970832327,229971259999,230019599397,230026255356,230035748594,230053763653,229991506162,230049537886,230010219908', NULL, NULL, 0295, 00);
Date: 2026-06-13 05:33:11 Duration: 338ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '230032586681,230032330114,230033797495,230026060411,230030701122,230028297878,229989732533,230052548898,230019019813,229974479393,229976774040,230053600405,229975833253,229991279900,229972502434,230032707781', NULL, NULL, 0295, 00);
Date: 2026-06-13 05:30:37 Duration: 336ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (429, 5, '113', 3, '241777780724,241762679899,241738489515,241777773551,241745779104,241762568801,241770172136,241745476672,241745325771,241767752124,241745378605,241767728686,241764832737,241769939307,241764856678,241770128595,241747571827,241764044040,241769937589,241769929508,241765292535,241765299202,241767473051,241746013852,241767472445,241767704667,241746135861,241743189805,241770096673,241769935872,241770025454,241746149802,241777935463,241740679807,241767787480,241745769406,241740691324,241759471518,241739477175,241767745961', NULL, NULL, 0464, 00);
Date: 2026-06-13 05:18:34 Duration: 319ms Database: rio User: intelifix Remote: [local] Application: [unknown]
6 8 4s271ms 349ms 717ms 533ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 13 01 2 1s228ms 614ms 04 3 1s414ms 471ms 05 2 1s87ms 543ms 07 1 540ms 540ms [ User: intelifix - Total duration: 4s271ms - Times executed: 8 ]
[ Application: [unknown] - Total duration: 4s271ms - Times executed: 8 ]
-
select * from rs_menu_grants (499, 0, 1);
Date: 2026-06-13 01:11:55 Duration: 717ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (500, 19, 1);
Date: 2026-06-13 05:18:34 Duration: 544ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (500, 19, 1);
Date: 2026-06-13 05:35:08 Duration: 543ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 8 3s177ms 280ms 505ms 397ms 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 #7
Day Hour Count Duration Avg duration Jun 13 01 2 940ms 470ms 04 3 1s62ms 354ms 05 2 820ms 410ms 07 1 354ms 354ms [ User: lenon - Total duration: 3s177ms - Times executed: 8 ]
[ Application: [unknown] - Total duration: 3s177ms - Times executed: 8 ]
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-06-13 01:11:55 Duration: 505ms 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-13 01:35:03 Duration: 435ms 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-13 05:35:08 Duration: 418ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
8 5 838ms 152ms 183ms 167ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 13 01 4 677ms 169ms 04 1 160ms 160ms [ User: intelifix - Total duration: 838ms - Times executed: 5 ]
[ Application: [unknown] - Total duration: 838ms - Times executed: 5 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0295;
Date: 2026-06-13 01:25:51 Duration: 183ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0295;
Date: 2026-06-13 01:37:26 Duration: 171ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0295;
Date: 2026-06-13 01:14:02 Duration: 169ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 4 1m7s 2s183ms 33s861ms 16s960ms 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 13 20 2 31s642ms 15s821ms 23 2 36s199ms 18s99ms [ User: intelifix - Total duration: 1m7s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m7s - 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-13 23:21:00 Duration: 33s861ms 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-13 20:05:50 Duration: 29s459ms 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-13 23:44:39 Duration: 2s337ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
10 4 58s333ms 1s490ms 28s46ms 14s583ms 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 13 20 2 28s796ms 14s398ms 23 2 29s537ms 14s768ms [ User: intelifix - Total duration: 58s333ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 58s333ms - Times executed: 4 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-06-13 23:21:31 Duration: 28s46ms 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-13 20:06:21 Duration: 27s75ms 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-13 20:09:10 Duration: 1s721ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
11 4 57s529ms 3s75ms 25s528ms 14s382ms 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 13 20 2 28s517ms 14s258ms 23 2 29s12ms 14s506ms [ User: intelifix - Total duration: 57s529ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 57s529ms - 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-13 23:43:03 Duration: 25s528ms 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-13 20:08:49 Duration: 25s441ms 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-13 23:45:18 Duration: 3s484ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
12 4 52s350ms 8s124ms 18s95ms 13s87ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 13 00 2 35s518ms 17s759ms 06 2 16s831ms 8s415ms [ User: intelifix - Total duration: 52s350ms - Times executed: 4 ]
[ Application: psql - Total duration: 52s350ms - Times executed: 4 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-13 00:05:19 Duration: 18s95ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-13 00:05:36 Duration: 17s422ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-13 06:05:10 Duration: 8s707ms Database: rio User: intelifix Remote: [local] Application: psql
13 4 43s477ms 1s269ms 21s50ms 10s869ms 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 13 20 2 21s108ms 10s554ms 23 2 22s369ms 11s184ms [ User: intelifix - Total duration: 43s477ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 43s477ms - 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-13 23:19:03 Duration: 21s50ms 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-13 20:04:04 Duration: 19s838ms 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-13 23:44:36 Duration: 1s319ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
14 4 42s730ms 1s639ms 20s184ms 10s682ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 13 20 2 20s902ms 10s451ms 23 2 21s828ms 10s914ms [ User: intelifix - Total duration: 42s730ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 42s730ms - Times executed: 4 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-13 23:17:34 Duration: 20s184ms 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-13 20:02:44 Duration: 19s263ms 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-13 23:44:29 Duration: 1s644ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
15 4 41s9ms 1s441ms 19s216ms 10s252ms 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 13 20 2 20s351ms 10s175ms 23 2 20s657ms 10s328ms [ User: intelifix - Total duration: 41s9ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 41s9ms - Times executed: 4 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-13 23:18:08 Duration: 19s216ms 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-13 20:03:16 Duration: 18s661ms 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-13 20:09:01 Duration: 1s689ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
16 4 32s823ms 1s445ms 16s764ms 8s205ms 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 13 20 2 14s368ms 7s184ms 23 2 18s454ms 9s227ms [ User: intelifix - Total duration: 32s823ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 32s823ms - 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-13 23:18:25 Duration: 16s764ms 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-13 20:03:28 Duration: 12s922ms 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-13 23:44:34 Duration: 1s690ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
17 4 29s585ms 847ms 14s935ms 7s396ms 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 13 20 2 13s802ms 6s901ms 23 2 15s782ms 7s891ms [ User: intelifix - Total duration: 29s585ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 29s585ms - 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-13 23:17:49 Duration: 14s935ms 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-13 20:02:57 Duration: 12s797ms 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-13 20:08:59 Duration: 1s4ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
18 4 25s412ms 817ms 12s187ms 6s353ms 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 #18
Day Hour Count Duration Avg duration Jun 13 20 2 13s142ms 6s571ms 23 2 12s269ms 6s134ms [ User: intelifix - Total duration: 25s412ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 25s412ms - 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-13 20:02:21 Duration: 12s187ms 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-13 23:17:10 Duration: 11s452ms 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-13 20:08:57 Duration: 954ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
19 4 24s482ms 625ms 12s81ms 6s120ms 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 13 20 2 11s686ms 5s843ms 23 2 12s795ms 6s397ms [ User: intelifix - Total duration: 24s482ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 24s482ms - 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-13 23:18:42 Duration: 12s81ms 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-13 20:03:44 Duration: 11s60ms 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-13 23:44:35 Duration: 714ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
20 4 21s44ms 2s996ms 7s884ms 5s261ms 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 13 20 2 9s798ms 4s899ms 23 2 11s246ms 5s623ms [ User: intelifix - Total duration: 21s44ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 21s44ms - 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-13 23:40:50 Duration: 7s884ms 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-13 20:06:45 Duration: 6s802ms 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-13 23:45:14 Duration: 3s361ms 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 340ms 7m22s 3m8s 3 9m26s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 13 05 3 9m26s 3m8s [ User: intelifix - Total duration: 9m26s - Times executed: 3 ]
[ Application: psql - Total duration: 9m26s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-06-13 05:07:23 Duration: 7m22s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-13 05:09:28 Duration: 2m4s Database: contagem User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-13 05:07:23 Duration: 340ms Database: brasilia User: intelifix Remote: [local] Application: psql
2 783ms 7m26s 2m48s 32 1h29m59s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 13 07 2 7m28s 3m44s 08 2 5m29s 2m44s 09 2 5m43s 2m51s 10 2 5m44s 2m52s 11 2 5m33s 2m46s 12 2 5m25s 2m42s 13 2 5m28s 2m44s 14 2 5m21s 2m40s 15 2 5m39s 2m49s 16 2 5m28s 2m44s 17 2 5m23s 2m41s 18 2 5m16s 2m38s 19 2 5m16s 2m38s 20 2 5m24s 2m42s 21 2 5m23s 2m41s 22 2 5m51s 2m55s [ User: intelifix - Total duration: 1h29m59s - Times executed: 32 ]
[ Application: psql - Total duration: 1h29m59s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-13 07:12:27 Duration: 7m26s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-13 22:10:52 Duration: 5m50s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-13 10:10:45 Duration: 5m43s Database: rio User: intelifix Remote: [local] Application: psql
3 1m25s 1m33s 1m29s 2 2m58s 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 13 20 1 1m25s 1m25s 23 1 1m33s 1m33s [ User: intelifix - Total duration: 2m58s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m58s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-13 23:42:37 Duration: 1m33s 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-13 20:08:23 Duration: 1m25s Database: rio User: intelifix Remote: [local] Application: pg_dump
4 23s457ms 2m23s 1m23s 2 2m46s 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 13 23 2 2m46s 1m23s [ User: intelifix - Total duration: 2m46s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m46s - 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-13 23:15:57 Duration: 2m23s 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-13 23:44:13 Duration: 23s457ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
5 20s438ms 1m59s 1m10s 2 2m20s copy auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 13 23 2 2m20s 1m10s [ User: intelifix - Total duration: 2m20s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m20s - 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-13 23:12:04 Duration: 1m59s 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-13 23:43:28 Duration: 20s438ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
6 57s150ms 1m2s 59s822ms 2 1m59s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 13 20 1 57s150ms 57s150ms 23 1 1m2s 1m2s [ User: intelifix - Total duration: 1m59s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m59s - Times executed: 2 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-13 23:20:25 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-13 20:05:20 Duration: 57s150ms Database: rio User: intelifix Remote: [local] Application: pg_dump
7 21s164ms 1m29s 55s271ms 2 1m50s 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 13 23 2 1m50s 55s271ms [ User: intelifix - Total duration: 1m50s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m50s - 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-13 23:13:34 Duration: 1m29s 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-13 23:43:49 Duration: 21s164ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
8 10s237ms 54s758ms 32s498ms 2 1m4s copy auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 13 23 2 1m4s 32s498ms [ User: intelifix - Total duration: 1m4s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m4s - Times executed: 2 ]
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-13 23:16:52 Duration: 54s758ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-13 23:44:23 Duration: 10s237ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
9 18s715ms 19s319ms 19s17ms 2 38s35ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 13 20 1 18s715ms 18s715ms 23 1 19s319ms 19s319ms [ User: intelifix - Total duration: 38s35ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 38s35ms - Times executed: 2 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-06-13 23:19:22 Duration: 19s319ms 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-13 20:04:22 Duration: 18s715ms Database: rio User: intelifix Remote: [local] Application: pg_dump
10 2s183ms 33s861ms 16s960ms 4 1m7s 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 13 20 2 31s642ms 15s821ms 23 2 36s199ms 18s99ms [ User: intelifix - Total duration: 1m7s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m7s - 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-13 23:21:00 Duration: 33s861ms 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-13 20:05:50 Duration: 29s459ms 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-13 23:44:39 Duration: 2s337ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
11 428ms 51s487ms 15s410ms 32 8m13s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 13 07 2 52s903ms 26s451ms 08 2 28s340ms 14s170ms 09 2 29s783ms 14s891ms 10 2 27s828ms 13s914ms 11 2 31s366ms 15s683ms 12 2 29s610ms 14s805ms 13 2 28s556ms 14s278ms 14 2 27s907ms 13s953ms 15 2 29s974ms 14s987ms 16 2 31s310ms 15s655ms 17 2 28s186ms 14s93ms 18 2 29s700ms 14s850ms 19 2 28s121ms 14s60ms 20 2 30s291ms 15s145ms 21 2 28s891ms 14s445ms 22 2 30s348ms 15s174ms [ User: intelifix - Total duration: 8m13s - Times executed: 32 ]
[ Application: psql - Total duration: 8m13s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-13 07:13:19 Duration: 51s487ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-13 16:10:59 Duration: 30s835ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-13 11:11:04 Duration: 30s768ms Database: rio User: intelifix Remote: [local] Application: psql
12 1s490ms 28s46ms 14s583ms 4 58s333ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 13 20 2 28s796ms 14s398ms 23 2 29s537ms 14s768ms [ User: intelifix - Total duration: 58s333ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 58s333ms - Times executed: 4 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-06-13 23:21:31 Duration: 28s46ms 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-13 20:06:21 Duration: 27s75ms 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-13 20:09:10 Duration: 1s721ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
13 3s75ms 25s528ms 14s382ms 4 57s529ms 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 13 20 2 28s517ms 14s258ms 23 2 29s12ms 14s506ms [ User: intelifix - Total duration: 57s529ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 57s529ms - 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-13 23:43:03 Duration: 25s528ms 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-13 20:08:49 Duration: 25s441ms 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-13 23:45:18 Duration: 3s484ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
14 8s124ms 18s95ms 13s87ms 4 52s350ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 13 00 2 35s518ms 17s759ms 06 2 16s831ms 8s415ms [ User: intelifix - Total duration: 52s350ms - Times executed: 4 ]
[ Application: psql - Total duration: 52s350ms - Times executed: 4 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-13 00:05:19 Duration: 18s95ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-13 00:05:36 Duration: 17s422ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-13 06:05:10 Duration: 8s707ms Database: rio User: intelifix Remote: [local] Application: psql
15 1s269ms 21s50ms 10s869ms 4 43s477ms 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 13 20 2 21s108ms 10s554ms 23 2 22s369ms 11s184ms [ User: intelifix - Total duration: 43s477ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 43s477ms - 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-13 23:19:03 Duration: 21s50ms 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-13 20:04:04 Duration: 19s838ms 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-13 23:44:36 Duration: 1s319ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
16 1s639ms 20s184ms 10s682ms 4 42s730ms 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 13 20 2 20s902ms 10s451ms 23 2 21s828ms 10s914ms [ User: intelifix - Total duration: 42s730ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 42s730ms - Times executed: 4 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-13 23:17:34 Duration: 20s184ms 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-13 20:02:44 Duration: 19s263ms 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-13 23:44:29 Duration: 1s644ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
17 1s441ms 19s216ms 10s252ms 4 41s9ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 13 20 2 20s351ms 10s175ms 23 2 20s657ms 10s328ms [ User: intelifix - Total duration: 41s9ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 41s9ms - Times executed: 4 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-13 23:18:08 Duration: 19s216ms 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-13 20:03:16 Duration: 18s661ms 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-13 20:09:01 Duration: 1s689ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
18 1s445ms 16s764ms 8s205ms 4 32s823ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 13 20 2 14s368ms 7s184ms 23 2 18s454ms 9s227ms [ User: intelifix - Total duration: 32s823ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 32s823ms - 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-13 23:18:25 Duration: 16s764ms 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-13 20:03:28 Duration: 12s922ms 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-13 23:44:34 Duration: 1s690ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
19 847ms 14s935ms 7s396ms 4 29s585ms copy public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 13 20 2 13s802ms 6s901ms 23 2 15s782ms 7s891ms [ User: intelifix - Total duration: 29s585ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 29s585ms - 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-13 23:17:49 Duration: 14s935ms 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-13 20:02:57 Duration: 12s797ms 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-13 20:08:59 Duration: 1s4ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
20 817ms 12s187ms 6s353ms 4 25s412ms 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 13 20 2 13s142ms 6s571ms 23 2 12s269ms 6s134ms [ User: intelifix - Total duration: 25s412ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 25s412ms - 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-13 20:02:21 Duration: 12s187ms 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-13 23:17:10 Duration: 11s452ms 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-13 20:08:57 Duration: 954ms 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 3 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jun 13 11 1 0ms 0ms 12 1 0ms 0ms 21 1 0ms 0ms [ User: intelifix - Total duration: 8s856ms - Times executed: 3 ]
[ Application: psql - Total duration: 8s856ms - Times executed: 3 ]
-
;
Date: Duration: 0ms Database: postgres User: rio Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 2,731 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 10 FATAL entries
- 456 ERROR entries
- 0 WARNING entries
- 1 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 138 Max number of times the same event was reported
- 467 Total events found
Rank Times reported Error 1 138 ERROR: procedure rs_giga_triagem(...) does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jun 13 00 6 01 6 02 6 03 6 04 6 05 6 06 6 07 6 08 6 09 6 10 6 11 6 12 6 13 6 14 6 15 6 16 6 17 6 18 6 19 6 20 6 21 6 22 6 - ERROR: procedure rs_giga_triagem(unknown) does not exist at character 6
- ERROR: procedure rs_giga_triagem(unknown) does not exist at character 6
- ERROR: procedure rs_giga_triagem(unknown) does not exist at character 6
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-06-13 00:05:21 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-06-13 00:15:04 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-06-13 00:25:06 Database: brasilia Application: psql User: intelifix Remote: [local]
2 138 ERROR: procedure rs_giga_processa_arquivos() does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Jun 13 00 6 01 6 02 6 03 6 04 6 05 6 06 6 07 6 08 6 09 6 10 6 11 6 12 6 13 6 14 6 15 6 16 6 17 6 18 6 19 6 20 6 21 6 22 6 - ERROR: procedure rs_giga_processa_arquivos() does not exist at character 6
- ERROR: procedure rs_giga_processa_arquivos() does not exist at character 6
- ERROR: procedure rs_giga_processa_arquivos() does not exist at character 6
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_PROCESSA_ARQUIVOS()Date: 2026-06-13 00:05:21 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_PROCESSA_ARQUIVOS()Date: 2026-06-13 00:15:04 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_PROCESSA_ARQUIVOS()Date: 2026-06-13 00:25:06 Database: brasilia Application: psql User: intelifix Remote: [local]
3 46 ERROR: procedure rs_giga_tecnicos() does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count Jun 13 00 2 01 2 02 2 03 2 04 2 05 2 06 2 07 2 08 2 09 2 10 2 11 2 12 2 13 2 14 2 15 2 16 2 17 2 18 2 19 2 20 2 21 2 22 2 - ERROR: procedure rs_giga_tecnicos() does not exist at character 6
- ERROR: procedure rs_giga_tecnicos() does not exist at character 6
- ERROR: procedure rs_giga_tecnicos() does not exist at character 6
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-06-13 00:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-06-13 00:35:01 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-06-13 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
4 45 ERROR: procedure rs_tcia_processa_lotes() does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Jun 13 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: procedure rs_tcia_processa_lotes() does not exist at character 6
- ERROR: procedure rs_tcia_processa_lotes() does not exist at character 6
- ERROR: procedure rs_tcia_processa_lotes() does not exist at character 6
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-13 08:00:26 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-13 08:20:06 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-13 08:40:08 Database: brasilia Application: psql User: intelifix Remote: [local]
5 45 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #5
Day Hour Count Jun 13 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-13 08:00:26 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-13 08:20:06 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Character with value 0x09 must be escaped.
Context: JSON data, line 22503: "nrSerie":"ZTEEH7VM1L08287... PL/pgSQL function rs_resumo_tcia(integer) line 139 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-13 08:40:08 Database: rio Application: psql User: intelifix Remote: [local]
6 16 ERROR: function rs_smart_fiscal_saida() does not exist
Times Reported Most Frequent Error / Event #6
Day Hour Count Jun 13 07 1 08 1 09 1 10 1 11 1 12 1 13 1 14 1 15 1 16 1 17 1 18 1 19 1 20 1 21 1 22 1 - ERROR: function rs_smart_fiscal_saida() does not exist at character 15
- ERROR: function rs_smart_fiscal_saida() does not exist at character 15
- ERROR: function rs_smart_fiscal_saida() does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_SMART_FISCAL_SAIDA()Date: 2026-06-13 07:13:19 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_SMART_FISCAL_SAIDA()Date: 2026-06-13 08:10:57 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_SMART_FISCAL_SAIDA()Date: 2026-06-13 09:11:13 Database: brasilia Application: psql User: intelifix Remote: [local]
7 16 ERROR: function rs_smart_fiscal_entrada() does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Jun 13 07 1 08 1 09 1 10 1 11 1 12 1 13 1 14 1 15 1 16 1 17 1 18 1 19 1 20 1 21 1 22 1 - ERROR: function rs_smart_fiscal_entrada() does not exist at character 15
- ERROR: function rs_smart_fiscal_entrada() does not exist at character 15
- ERROR: function rs_smart_fiscal_entrada() does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_SMART_FISCAL_ENTRADA()Date: 2026-06-13 07:13:19 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_SMART_FISCAL_ENTRADA()Date: 2026-06-13 08:10:57 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_SMART_FISCAL_ENTRADA()Date: 2026-06-13 09:11:13 Database: brasilia Application: psql User: intelifix Remote: [local]
8 8 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #8
Day Hour Count Jun 13 05 8 - ERROR: relation "public.equipamentos" does not exist at character 49
- ERROR: relation "public.equipamentos" does not exist
- ERROR: relation "public.codigos_barra" does not exist at character 70
Statement: DECLARE c1 CURSOR FOR SELECT eq_id, mod_id FROM public.equipamentos
Date: 2026-06-13 05:30:01 Database: brasilia Application: postgres_fdw User: lenon Remote: 127.0.0.1
Context: remote SQL command: SELECT eq_id, mod_id FROM public.equipamentos
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;Date: 2026-06-13 05:30:01 Database: rio Application: psql User: intelifix Remote: [local]
Statement: DECLARE c1 CURSOR FOR SELECT eq_id, eq_seq, eq_codigo, eq_extra FROM public.codigos_barra
Date: 2026-06-13 05:30:01 Database: brasilia Application: postgres_fdw User: lenon Remote: 127.0.0.1
9 4 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #9
Day Hour Count Jun 13 03 4 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-06-13 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-13 03:05:01 Database: rio Application: psql User: intelifix Remote: [local]
Date: 2026-06-13 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
10 4 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #10
Day Hour Count Jun 13 00 1 03 2 06 1 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-06-13 00:02:10 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-06-13 03:06:16 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-13 03:52:08 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
11 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #11
Day Hour Count Jun 13 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-06-13 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-13 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
12 2 ERROR: procedure rs_atualiza_estoque_automatico() does not exist
Times Reported Most Frequent Error / Event #12
Day Hour Count Jun 13 00 1 06 1 - ERROR: procedure rs_atualiza_estoque_automatico() does not exist at character 6
- ERROR: procedure rs_atualiza_estoque_automatico() does not exist at character 6
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO()Date: 2026-06-13 00:05:19 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO()Date: 2026-06-13 06:05:10 Database: brasilia Application: psql User: intelifix Remote: [local]
13 1 ERROR: function rs_lote_entrada_fechar_automatico() does not exist
Times Reported Most Frequent Error / Event #13
Day Hour Count Jun 13 18 1 - ERROR: function rs_lote_entrada_fechar_automatico() does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_LOTE_ENTRADA_FECHAR_AUTOMATICO()Date: 2026-06-13 18:00:01 Database: brasilia Application: psql User: intelifix Remote: [local]
14 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #14
Day Hour Count Jun 13 03 1 - LOG: database system was shut down at 2026-06-13 03:05:01 -03
Date: 2026-06-13 03:05:02
15 1 ERROR: function rs_del_temporario() does not exist
Times Reported Most Frequent Error / Event #15
Day Hour Count Jun 13 21 1 - ERROR: function rs_del_temporario() does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_DEL_TEMPORARIO()Date: 2026-06-13 21:25:01 Database: brasilia Application: psql User: intelifix Remote: [local]