pgBadger-
Global information
- Generated on Mon Jun 22 23:50:15 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 9,864 log entries in 13s
- Log start from 2026-06-21 00:00:06 to 2026-06-21 23:59:29
-
Overview
Global Stats
- 139 Number of unique normalized queries
- 518 Number of queries
- 2h55m40s Total query duration
- 2026-06-21 00:02:23 First query
- 2026-06-21 23:38:21 Last query
- 4 queries/s at 2026-06-21 23:37:52 Query peak
- 2h55m40s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 2h55m40s Execute total duration
- 1,905 Number of events
- 16 Number of unique normalized events
- 1,425 Max number of times the same event was reported
- 0 Number of cancellation
- 6 Total number of automatic vacuums
- 0 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 191 Total number of sessions
- 7 sessions at 2026-06-21 12:10:01 Session peak
- 7d4h49m5s Total duration of sessions
- 54m17s Average duration of sessions
- 2 Average queries per session
- 55s183ms Average queries duration per session
- 53m22s Average idle time per session
- 200 Total number of connections
- 5 connections/s at 2026-06-21 03:05:17 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 4 queries/s Query Peak
- 2026-06-21 23:37:52 Date
SELECT Traffic
Key values
- 2 queries/s Query Peak
- 2026-06-21 23:36:15 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-06-21 23:37:52 Date
Queries duration
Key values
- 2h55m40s 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 21 00 14 0ms 21s364ms 6s951ms 2s631ms 3s630ms 58s893ms 01 6 0ms 3s950ms 3s149ms 2s663ms 3s85ms 3s950ms 02 6 0ms 4s331ms 3s617ms 2s694ms 3s847ms 4s331ms 03 8 0ms 3s543ms 1s951ms 897ms 2s888ms 3s543ms 04 6 0ms 3s299ms 2s885ms 2s561ms 3s14ms 3s299ms 05 9 0ms 9m5s 1m18s 2s518ms 2s871ms 9m6s 06 10 0ms 21s456ms 5s969ms 2s520ms 3s177ms 25s439ms 07 10 0ms 14m9s 1m37s 2s443ms 2s668ms 14m9s 08 10 0ms 5m37s 38s463ms 2s574ms 3s481ms 5m37s 09 10 0ms 5m45s 39s248ms 2s779ms 3s49ms 5m45s 10 10 0ms 5m52s 40s271ms 2s650ms 3s409ms 5m52s 11 15 0ms 5m35s 28s823ms 2s852ms 31s731ms 5m35s 12 11 0ms 16m21s 1m44s 2s572ms 16s763ms 16m21s 13 10 0ms 5m41s 39s339ms 2s747ms 3s429ms 5m41s 14 10 0ms 5m46s 39s699ms 2s683ms 2s904ms 5m46s 15 10 0ms 5m52s 40s167ms 2s733ms 3s460ms 5m52s 16 10 0ms 5m42s 39s17ms 2s737ms 2s983ms 5m42s 17 10 0ms 5m29s 37s853ms 2s751ms 2s836ms 5m29s 18 12 0ms 5m13s 29s958ms 2s414ms 2s698ms 5m41s 19 10 0ms 5m23s 36s885ms 2s379ms 2s548ms 5m53s 20 65 0ms 5m6s 11s654ms 48s389ms 1m32s 5m37s 21 11 0ms 5m14s 32s744ms 2s457ms 2s821ms 5m44s 22 10 0ms 5m22s 36s783ms 2s429ms 2s984ms 5m51s 23 235 0ms 1m23s 7s194ms 1m8s 1m16s 1m23s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 21 00 3 0 7s814ms 0ms 0ms 286ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 1 0 225ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 2 0 12s719ms 0ms 0ms 0ms 07 4 0 3m59s 0ms 0ms 1m48s 08 4 0 1m32s 0ms 0ms 30s971ms 09 4 0 1m33s 0ms 0ms 30s243ms 10 4 0 1m36s 0ms 0ms 33s294ms 11 8 0 49s179ms 0ms 0ms 31s731ms 12 4 0 4m39s 0ms 0ms 2m18s 13 4 0 1m33s 0ms 0ms 34s225ms 14 4 0 1m35s 0ms 0ms 34s62ms 15 4 0 1m36s 0ms 0ms 32s83ms 16 4 0 1m33s 0ms 0ms 31s150ms 17 4 0 1m30s 0ms 0ms 32s825ms 18 6 0 57s332ms 0ms 0ms 2s360ms 19 4 0 1m28s 0ms 0ms 0ms 20 10 49 12s570ms 0ms 47s448ms 2m3s 21 5 0 1m8s 0ms 0ms 231ms 22 4 0 1m27s 0ms 0ms 0ms 23 14 221 7s194ms 1m4s 1m8s 1m22s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 21 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 21 00 0 1 1.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 1 1.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 1 1.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 3 3.00 0.00% Day Hour Count Average / Second Jun 21 00 15 0.00/s 01 6 0.00/s 02 6 0.00/s 03 11 0.00/s 04 7 0.00/s 05 9 0.00/s 06 13 0.00/s 07 7 0.00/s 08 6 0.00/s 09 9 0.00/s 10 6 0.00/s 11 20 0.01/s 12 1 0.00/s 13 8 0.00/s 14 9 0.00/s 15 7 0.00/s 16 7 0.00/s 17 8 0.00/s 18 8 0.00/s 19 7 0.00/s 20 10 0.00/s 21 7 0.00/s 22 8 0.00/s 23 5 0.00/s Day Hour Count Average Duration Average idle time Jun 21 00 3 43m20s 42m48s 01 13 1h1m7s 1h1m6s 02 6 1h 59m57s 03 11 25m28s 25m26s 04 6 1h3m 1h2m57s 05 8 53m45s 52m17s 06 8 59m23s 59m15s 07 12 58m15s 56m53s 08 7 1h48s 59m53s 09 7 52m51s 51m55s 10 7 1h25s 59m28s 11 12 49m10s 48m34s 12 8 54m31s 52m7s 13 7 56m43s 55m46s 14 8 54m29s 53m39s 15 7 1h51s 59m54s 16 7 1h25s 59m29s 17 7 1h1m13s 1h19s 18 7 1h1s 59m10s 19 7 1h1m46s 1h53s 20 10 37m41s 36m25s 21 6 1h53s 59m53s 22 7 1h26s 59m33s 23 10 44m50s 42m1s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-06-21 03:05:17 Date
Connections per database
Key values
- rio Main Database
- 200 connections Total
Connections per user
Key values
- intelifix Main User
- 200 connections Total
-
Sessions
Simultaneous sessions
Key values
- 7 sessions Session Peak
- 2026-06-21 12:10:01 Date
Histogram of session times
Key values
- 158 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 191 sessions Total
Sessions per user
Key values
- intelifix Main User
- 191 sessions Total
Sessions per host
Key values
- [local] Main Host
- 191 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 6,617 buffers Checkpoint Peak
- 2026-06-21 00:09:53 Date
- 269.204 seconds Highest write time
- 0.071 seconds Sync time
Checkpoints Wal files
Key values
- 2 files Wal files usage Peak
- 2026-06-21 03:05:02 Date
Checkpoints distance
Key values
- 68.45 Mo Distance Peak
- 2026-06-21 03:05:02 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jun 21 00 6,617 269.204s 0.003s 269.221s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 5,685 0.357s 0.065s 0.467s 04 0 0s 0s 0s 05 4,611 461.8s 0.027s 461.859s 06 2,036 203.955s 0.002s 203.962s 07 713 71.449s 0.004s 71.459s 08 30 3.031s 0.004s 3.098s 09 21 2.129s 0.003s 2.137s 10 21 2.131s 0.003s 2.139s 11 21 2.159s 0.005s 2.255s 12 1,261 126.255s 0.086s 126.366s 13 21 2.124s 0.023s 2.168s 14 21 2.13s 0.009s 2.144s 15 21 2.126s 0.063s 2.204s 16 21 2.13s 0.016s 2.152s 17 21 2.116s 0.036s 2.165s 18 1,113 111.451s 0.134s 111.616s 19 21 2.133s 0.064s 2.214s 20 85 8.576s 0.096s 8.748s 21 21 2.127s 0.063s 2.196s 22 21 2.116s 0.014s 2.134s 23 57 5.756s 0.004s 5.77s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jun 21 00 0 0 2 25 0.003s 0.001s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 2 14 0.052s 0.009s 04 0 0 0 0 0s 0s 05 0 0 2 101 0.018s 0.005s 06 0 0 0 11 0.002s 0.001s 07 0 0 1 10 0.002s 0.001s 08 0 0 0 3 0.002s 0.002s 09 0 0 0 3 0.002s 0.001s 10 0 0 0 3 0.003s 0.001s 11 0 0 0 3 0.003s 0.002s 12 0 0 0 14 0.063s 0.026s 13 0 0 0 3 0.022s 0.008s 14 0 0 0 3 0.009s 0.003s 15 0 0 0 3 0.062s 0.021s 16 0 0 0 3 0.015s 0.006s 17 0 0 0 3 0.035s 0.012s 18 0 0 0 54 0.063s 0.018s 19 0 0 0 3 0.063s 0.022s 20 0 0 0 10 0.056s 0.028s 21 0 0 0 3 0.062s 0.021s 22 0 0 0 3 0.013s 0.005s 23 0 0 0 3 0.003s 0.003s Day Hour Count Avg time (sec) Jun 21 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 21 00 34,331.00 kB 34,331.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 17,524.00 kB 17,524.00 kB 04 0.00 kB 0.00 kB 05 8,332.00 kB 10,944.00 kB 06 3,601.00 kB 15,689.00 kB 07 4,464.00 kB 14,567.00 kB 08 255.00 kB 13,135.00 kB 09 166.00 kB 11,838.00 kB 10 166.00 kB 10,671.00 kB 11 83.00 kB 9,140.00 kB 12 2,572.00 kB 4,737.50 kB 13 166.00 kB 4,064.00 kB 14 166.00 kB 3,674.00 kB 15 166.00 kB 3,323.00 kB 16 166.00 kB 3,007.00 kB 17 166.00 kB 2,723.00 kB 18 1,252.33 kB 3,134.33 kB 19 166.00 kB 2,563.00 kB 20 220.67 kB 2,121.00 kB 21 166.00 kB 1,753.00 kB 22 166.00 kB 1,594.00 kB 23 409.50 kB 1,422.50 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 21 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.19 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database rio - 2026-06-21 05:09:41 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 0.19 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database rio - 2026-06-21 05:09:41 Date
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- pg_toast.pg_toast_2619 (1) Main table vacuumed on database brasilia
- 6 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 46 8 29,546 0 0 rio.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 831 125 744,446 45 230 brasilia.pg_catalog.pg_statistic 1 1 0 0 0 0 0 77 2 7,364 0 0 rio.pg_catalog.pg_statistic 1 1 0 0 0 0 0 3,065 367 1,693,946 340 2,101 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,203 93 443,618 80 743 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 143 20 55,009 4 6 Total 6 6 0 0 0 0 0 6,365 615 2,973,929 469 3,080 Vacuum throughput per table
Key values
- pg_catalog.pg_statistic (0.19) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
Tuples removed per table
Key values
- pg_catalog.pg_statistic (4533) Main table with removed tuples on database rio
- 9745 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_statistic 1 1 4,533 7,458 0 0 1,286 contagem.pg_catalog.pg_statistic 1 1 4,277 7,274 0 0 1,011 rio.pg_toast.pg_toast_2619 1 1 613 678 0 139 161 brasilia.pg_catalog.pg_statistic 1 1 180 449 0 0 36 contagem.pg_toast.pg_toast_2619 1 1 106 111 0 5 50 brasilia.pg_toast.pg_toast_2619 1 1 36 14 0 0 14 Total 6 6 9,745 15,984 0 144 2,558 Pages removed per table
Key values
- pg_toast.pg_toast_2619 (139) Main table with removed pages on database rio
- 144 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.pg_toast.pg_toast_2619 1 1 613 139 contagem.pg_toast.pg_toast_2619 1 1 106 5 brasilia.pg_toast.pg_toast_2619 1 1 36 0 brasilia.pg_catalog.pg_statistic 1 1 180 0 rio.pg_catalog.pg_statistic 1 1 4533 0 contagem.pg_catalog.pg_statistic 1 1 4277 0 Total 6 6 9,745 144 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jun 21 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 6 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 - 0.19 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
- 97 Total read queries
- 270 Total write queries
Queries by database
Key values
- rio Main database
- 343 Requests
- 2h49m14s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 504 Requests
User Request type Count Duration etiquetas Total 7 2s874ms select 7 2s874ms intelifix Total 504 2h54m23s copy to 270 34m48s others 151 19m45s select 83 1h59m48s lenon Total 7 1m14s select 7 1m14s Duration by user
Key values
- 2h54m23s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 7 2s874ms select 7 2s874ms intelifix Total 504 2h54m23s copy to 270 34m48s others 151 19m45s select 83 1h59m48s lenon Total 7 1m14s select 7 1m14s Queries by host
Key values
- [local] Main host
- 518 Requests
- 2h55m40s ([local])
- Main time consuming host
Queries by application
Key values
- pg_dump Main application
- 286 Requests
- 2h20m44s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-06-21 10:26:54 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 214 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 16m21s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-21 12:21:22 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 14m9s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-21 07:19:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 9m5s analyze verbose;[ Date: 2026-06-21 05:09:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 5m52s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-21 15:10:54 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 5m52s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-21 10:10:53 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 5m46s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-21 14:10:48 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 5m45s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-21 09:10:47 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 5m42s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-21 16:10:43 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 5m41s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-21 13:10:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 5m37s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-21 08:10:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 5m35s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-21 11:10:36 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m29s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-21 17:10:30 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 5m23s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-21 19:10:24 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m22s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-21 22:10:24 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m14s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-21 21:10:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m13s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-21 18:10:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m6s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-21 20:10:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 2m25s analyze verbose;[ Date: 2026-06-21 05:11:33 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
19 2m7s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-06-21 12:23:30 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 1m45s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-06-21 07:20:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1h48m44s 32 999ms 16m21s 3m23s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 21 07 2 14m12s 7m6s 08 2 5m38s 2m49s 09 2 5m47s 2m53s 10 2 5m53s 2m56s 11 2 5m36s 2m48s 12 2 16m29s 8m14s 13 2 5m43s 2m51s 14 2 5m48s 2m54s 15 2 5m54s 2m57s 16 2 5m43s 2m51s 17 2 5m30s 2m45s 18 2 5m14s 2m37s 19 2 5m24s 2m42s 20 2 5m7s 2m33s 21 2 5m15s 2m37s 22 2 5m23s 2m41s [ User: intelifix - Total duration: 1h48m44s - Times executed: 32 ]
[ Application: psql - Total duration: 1h48m44s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-21 12:21:22 Duration: 16m21s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-21 07:19:10 Duration: 14m9s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-21 15:10:54 Duration: 5m52s Database: rio User: intelifix Remote: [local] Application: psql
2 11m32s 3 746ms 9m5s 3m50s analyze verbose;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 21 05 3 11m32s 3m50s [ User: intelifix - Total duration: 11m32s - Times executed: 3 ]
[ Application: psql - Total duration: 11m32s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-06-21 05:09:07 Duration: 9m5s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-21 05:11:33 Duration: 2m25s Database: contagem User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-21 05:09:07 Duration: 746ms Database: brasilia User: intelifix Remote: [local] Application: psql
3 10m57s 32 415ms 2m7s 20s554ms select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 21 07 2 1m46s 53s416ms 08 2 29s825ms 14s912ms 09 2 28s736ms 14s368ms 10 2 31s813ms 15s906ms 11 2 30s481ms 15s240ms 12 2 2m10s 1m5s 13 2 32s674ms 16s337ms 14 2 32s733ms 16s366ms 15 2 30s425ms 15s212ms 16 2 30s27ms 15s13ms 17 2 31s647ms 15s823ms 18 2 26s703ms 13s351ms 19 2 29s174ms 14s587ms 20 2 29s872ms 14s936ms 21 2 28s693ms 14s346ms 22 2 27s843ms 13s921ms [ User: intelifix - Total duration: 10m57s - Times executed: 32 ]
[ Application: psql - Total duration: 10m57s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-21 12:23:30 Duration: 2m7s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-21 07:20:55 Duration: 1m45s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-21 13:11:15 Duration: 32s193ms Database: rio User: intelifix Remote: [local] Application: psql
4 6m47s 136 2s239ms 17s283ms 2s994ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 21 00 6 32s260ms 5s376ms 01 6 18s894ms 3s149ms 02 6 21s704ms 3s617ms 03 5 14s714ms 2s942ms 04 6 17s315ms 2s885ms 05 6 15s692ms 2s615ms 06 6 15s774ms 2s629ms 07 6 14s840ms 2s473ms 08 6 16s606ms 2s767ms 09 6 16s604ms 2s767ms 10 6 17s75ms 2s845ms 11 5 14s111ms 2s822ms 12 6 29s427ms 4s904ms 13 6 17s518ms 2s919ms 14 6 16s165ms 2s694ms 15 6 16s967ms 2s827ms 16 6 16s605ms 2s767ms 17 6 16s418ms 2s736ms 18 6 15s513ms 2s585ms 19 6 14s978ms 2s496ms 20 6 15s911ms 2s651ms 21 6 15s865ms 2s644ms 22 6 16s269ms 2s711ms [ User: intelifix - Total duration: 6m47s - Times executed: 136 ]
[ Application: psql - Total duration: 6m47s - Times executed: 136 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-21 00:05:19 Duration: 17s283ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-21 12:05:17 Duration: 16s512ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-21 02:15:06 Duration: 4s331ms Database: rio User: intelifix Remote: [local] Application: psql
5 2m40s 2 1m16s 1m23s 1m20s 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 21 20 1 1m16s 1m16s 23 1 1m23s 1m23s [ User: intelifix - Total duration: 2m40s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m40s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-21 23:35:44 Duration: 1m23s 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-21 20:08:03 Duration: 1m16s Database: rio User: intelifix Remote: [local] Application: pg_dump
6 1m43s 2 20s499ms 1m22s 51s681ms 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 21 23 2 1m43s 51s681ms [ User: intelifix - Total duration: 1m43s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m43s - 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-21 23:13:43 Duration: 1m22s 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-21 23:37:11 Duration: 20s499ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
7 1m38s 2 45s409ms 53s433ms 49s421ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 21 20 1 53s433ms 53s433ms 23 1 45s409ms 45s409ms [ User: intelifix - Total duration: 1m38s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m38s - Times executed: 2 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-21 20:05:11 Duration: 53s433ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-21 23:17:42 Duration: 45s409ms Database: rio User: intelifix Remote: [local] Application: pg_dump
8 1m33s 2 17s511ms 1m16s 46s931ms copy auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 21 23 2 1m33s 46s931ms [ User: intelifix - Total duration: 1m33s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m33s - 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-21 23:11:21 Duration: 1m16s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-21 23:36:35 Duration: 17s511ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
9 1m23s 6 8s662ms 20s823ms 13s902ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 21 00 2 40s131ms 20s65ms 06 2 18s479ms 9s239ms 11 2 24s803ms 12s401ms [ User: intelifix - Total duration: 1m23s - Times executed: 6 ]
[ Application: psql - Total duration: 1m23s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-21 00:05:22 Duration: 20s823ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-21 00:05:41 Duration: 19s307ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-21 11:59:03 Duration: 14s328ms Database: rio User: intelifix Remote: [local] Application: psql
10 1m15s 2 16s257ms 58s952ms 37s604ms 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 #10
Day Hour Count Duration Avg duration Jun 21 23 2 1m15s 37s604ms [ User: intelifix - Total duration: 1m15s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m15s - 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-21 23:12:20 Duration: 58s952ms 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-21 23:36:51 Duration: 16s257ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
11 1m14s 7 247ms 21s560ms 10s593ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 21 00 2 23s158ms 11s579ms 06 2 25s439ms 12s719ms 11 3 25s554ms 8s518ms [ User: lenon - Total duration: 1m14s - Times executed: 7 ]
[ Application: psql - Total duration: 1m14s - Times executed: 7 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-06-21 11:59:24 Duration: 21s560ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-06-21 06:02:23 Duration: 21s456ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-06-21 00:02:23 Duration: 21s364ms Database: rio User: lenon Remote: [local] Application: psql
12 1m12s 2 14s478ms 58s515ms 36s497ms 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 #12
Day Hour Count Duration Avg duration Jun 21 23 2 1m12s 36s497ms [ User: intelifix - Total duration: 1m12s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m12s - 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-21 23:14:42 Duration: 58s515ms 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-21 23:37:26 Duration: 14s478ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
13 1m4s 4 2s142ms 32s 16s150ms copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 21 20 2 34s162ms 17s81ms 23 2 30s440ms 15s220ms [ User: intelifix - Total duration: 1m4s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m4s - Times executed: 4 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-06-21 20:05:44 Duration: 32s 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-21 23:18:11 Duration: 28s298ms 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-21 20:08:46 Duration: 2s161ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
14 55s554ms 4 2s526ms 26s292ms 13s888ms copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 21 20 2 26s58ms 13s29ms 23 2 29s495ms 14s747ms [ User: intelifix - Total duration: 55s554ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 55s554ms - 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-21 23:36:10 Duration: 26s292ms 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-21 20:08:26 Duration: 23s532ms 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-21 23:38:20 Duration: 3s203ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
15 55s212ms 4 1s568ms 26s739ms 13s803ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 21 20 2 28s308ms 14s154ms 23 2 26s904ms 13s452ms [ User: intelifix - Total duration: 55s212ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 55s212ms - Times executed: 4 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-06-21 20:06:14 Duration: 26s739ms 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-21 23:18:40 Duration: 25s105ms 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-21 23:37:43 Duration: 1s799ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
16 42s476ms 4 1s175ms 20s884ms 10s619ms 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 21 20 2 22s59ms 11s29ms 23 2 20s416ms 10s208ms [ User: intelifix - Total duration: 42s476ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 42s476ms - 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-21 20:03:58 Duration: 20s884ms 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-21 23:16:38 Duration: 19s74ms 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-21 23:37:39 Duration: 1s341ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
17 41s190ms 4 1s638ms 20s93ms 10s297ms 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 21 20 2 19s459ms 9s729ms 23 2 21s731ms 10s865ms [ User: intelifix - Total duration: 41s190ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 41s190ms - Times executed: 4 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-21 23:15:20 Duration: 20s93ms 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-21 20:02:39 Duration: 17s571ms 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-21 20:08:37 Duration: 1s887ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
18 38s886ms 4 1s484ms 18s270ms 9s721ms 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 21 20 2 19s131ms 9s565ms 23 2 19s755ms 9s877ms [ User: intelifix - Total duration: 38s886ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 38s886ms - Times executed: 4 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-21 23:15:51 Duration: 18s270ms 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-21 20:03:11 Duration: 17s639ms 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-21 20:08:40 Duration: 1s492ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
19 37s875ms 2 18s213ms 19s661ms 18s937ms 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 21 20 1 19s661ms 19s661ms 23 1 18s213ms 18s213ms [ User: intelifix - Total duration: 37s875ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 37s875ms - Times executed: 2 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-06-21 20:04:17 Duration: 19s661ms 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-21 23:16:56 Duration: 18s213ms Database: rio User: intelifix Remote: [local] Application: pg_dump
20 28s214ms 4 895ms 13s559ms 7s53ms copy public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 21 20 2 14s455ms 7s227ms 23 2 13s759ms 6s879ms [ User: intelifix - Total duration: 28s214ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 28s214ms - 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-21 20:02:53 Duration: 13s559ms 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-21 23:15:33 Duration: 12s849ms 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-21 23:37:33 Duration: 910ms 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 136 6m47s 2s239ms 17s283ms 2s994ms call rs_giga_triagem (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 21 00 6 32s260ms 5s376ms 01 6 18s894ms 3s149ms 02 6 21s704ms 3s617ms 03 5 14s714ms 2s942ms 04 6 17s315ms 2s885ms 05 6 15s692ms 2s615ms 06 6 15s774ms 2s629ms 07 6 14s840ms 2s473ms 08 6 16s606ms 2s767ms 09 6 16s604ms 2s767ms 10 6 17s75ms 2s845ms 11 5 14s111ms 2s822ms 12 6 29s427ms 4s904ms 13 6 17s518ms 2s919ms 14 6 16s165ms 2s694ms 15 6 16s967ms 2s827ms 16 6 16s605ms 2s767ms 17 6 16s418ms 2s736ms 18 6 15s513ms 2s585ms 19 6 14s978ms 2s496ms 20 6 15s911ms 2s651ms 21 6 15s865ms 2s644ms 22 6 16s269ms 2s711ms [ User: intelifix - Total duration: 6m47s - Times executed: 136 ]
[ Application: psql - Total duration: 6m47s - Times executed: 136 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-21 00:05:19 Duration: 17s283ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-21 12:05:17 Duration: 16s512ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-21 02:15:06 Duration: 4s331ms Database: rio User: intelifix Remote: [local] Application: psql
2 32 1h48m44s 999ms 16m21s 3m23s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 21 07 2 14m12s 7m6s 08 2 5m38s 2m49s 09 2 5m47s 2m53s 10 2 5m53s 2m56s 11 2 5m36s 2m48s 12 2 16m29s 8m14s 13 2 5m43s 2m51s 14 2 5m48s 2m54s 15 2 5m54s 2m57s 16 2 5m43s 2m51s 17 2 5m30s 2m45s 18 2 5m14s 2m37s 19 2 5m24s 2m42s 20 2 5m7s 2m33s 21 2 5m15s 2m37s 22 2 5m23s 2m41s [ User: intelifix - Total duration: 1h48m44s - Times executed: 32 ]
[ Application: psql - Total duration: 1h48m44s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-21 12:21:22 Duration: 16m21s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-21 07:19:10 Duration: 14m9s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-21 15:10:54 Duration: 5m52s Database: rio User: intelifix Remote: [local] Application: psql
3 32 10m57s 415ms 2m7s 20s554ms select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 21 07 2 1m46s 53s416ms 08 2 29s825ms 14s912ms 09 2 28s736ms 14s368ms 10 2 31s813ms 15s906ms 11 2 30s481ms 15s240ms 12 2 2m10s 1m5s 13 2 32s674ms 16s337ms 14 2 32s733ms 16s366ms 15 2 30s425ms 15s212ms 16 2 30s27ms 15s13ms 17 2 31s647ms 15s823ms 18 2 26s703ms 13s351ms 19 2 29s174ms 14s587ms 20 2 29s872ms 14s936ms 21 2 28s693ms 14s346ms 22 2 27s843ms 13s921ms [ User: intelifix - Total duration: 10m57s - Times executed: 32 ]
[ Application: psql - Total duration: 10m57s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-21 12:23:30 Duration: 2m7s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-21 07:20:55 Duration: 1m45s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-21 13:11:15 Duration: 32s193ms Database: rio User: intelifix Remote: [local] Application: psql
4 7 1m14s 247ms 21s560ms 10s593ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 21 00 2 23s158ms 11s579ms 06 2 25s439ms 12s719ms 11 3 25s554ms 8s518ms [ User: lenon - Total duration: 1m14s - Times executed: 7 ]
[ Application: psql - Total duration: 1m14s - Times executed: 7 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-06-21 11:59:24 Duration: 21s560ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-06-21 06:02:23 Duration: 21s456ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-06-21 00:02:23 Duration: 21s364ms Database: rio User: lenon Remote: [local] Application: psql
5 6 1m23s 8s662ms 20s823ms 13s902ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 21 00 2 40s131ms 20s65ms 06 2 18s479ms 9s239ms 11 2 24s803ms 12s401ms [ User: intelifix - Total duration: 1m23s - Times executed: 6 ]
[ Application: psql - Total duration: 1m23s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-21 00:05:22 Duration: 20s823ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-21 00:05:41 Duration: 19s307ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-21 11:59:03 Duration: 14s328ms Database: rio User: intelifix Remote: [local] Application: psql
6 6 2s653ms 192ms 1s16ms 442ms select * from rs_caixa_qr ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 21 00 1 286ms 286ms 03 1 225ms 225ms 11 1 714ms 714ms 23 3 1s428ms 476ms [ User: etiquetas - Total duration: 2s653ms - Times executed: 6 ]
[ Application: [unknown] - Total duration: 2s653ms - Times executed: 6 ]
-
select * from rs_caixa_qr ();
Date: 2026-06-21 23:31:20 Duration: 1s16ms Database: rio User: etiquetas Remote: [local] Application: [unknown] Bind query: yes
-
select * from rs_caixa_qr ();
Date: 2026-06-21 11:58:52 Duration: 714ms Database: rio User: etiquetas Remote: [local] Application: [unknown] Bind query: yes
-
select * from rs_caixa_qr ();
Date: 2026-06-21 00:20:19 Duration: 286ms Database: rio User: etiquetas Remote: [local] Application: [unknown] Bind query: yes
7 6 1s845ms 159ms 625ms 307ms select p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, p.proacl, acldefault(?, p.proowner) as acldefault, p.pronamespace, p.proowner from pg_proc p left join pg_init_privs pip on (p.oid = pip.objoid and pip.classoid = ?::regclass and pip.objsubid = ?) where p.prokind <> ? and not exists ( select ? from pg_depend where classid = ?::regclass and objid = p.oid and deptype = ?) and (pronamespace != ( select oid from pg_namespace where nspname = ?) or exists ( select ? from pg_cast where pg_cast.oid > ? and p.oid = pg_cast.castfunc) or exists ( select ? from pg_transform where pg_transform.oid > ? and (p.oid = pg_transform.trffromsql or p.oid = pg_transform.trftosql)) or p.proacl is distinct from pip.initprivs);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 21 20 3 714ms 238ms 23 3 1s130ms 376ms [ User: intelifix - Total duration: 1s845ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1s845ms - Times executed: 6 ]
-
SELECT p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, p.proacl, acldefault('f', p.proowner) AS acldefault, p.pronamespace, p.proowner FROM pg_proc p LEFT JOIN pg_init_privs pip ON (p.oid = pip.objoid AND pip.classoid = 'pg_proc'::regclass AND pip.objsubid = 0) WHERE p.prokind <> 'a' AND NOT EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_proc'::regclass AND objid = p.oid AND deptype = 'i') AND (pronamespace != ( SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog') OR EXISTS ( SELECT 1 FROM pg_cast WHERE pg_cast.oid > 16383 AND p.oid = pg_cast.castfunc) OR EXISTS ( SELECT 1 FROM pg_transform WHERE pg_transform.oid > 16383 AND (p.oid = pg_transform.trffromsql OR p.oid = pg_transform.trftosql)) OR p.proacl IS DISTINCT FROM pip.initprivs);
Date: 2026-06-21 23:10:02 Duration: 625ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
SELECT p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, p.proacl, acldefault('f', p.proowner) AS acldefault, p.pronamespace, p.proowner FROM pg_proc p LEFT JOIN pg_init_privs pip ON (p.oid = pip.objoid AND pip.classoid = 'pg_proc'::regclass AND pip.objsubid = 0) WHERE p.prokind <> 'a' AND NOT EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_proc'::regclass AND objid = p.oid AND deptype = 'i') AND (pronamespace != ( SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog') OR EXISTS ( SELECT 1 FROM pg_cast WHERE pg_cast.oid > 16383 AND p.oid = pg_cast.castfunc) OR EXISTS ( SELECT 1 FROM pg_transform WHERE pg_transform.oid > 16383 AND (p.oid = pg_transform.trffromsql OR p.oid = pg_transform.trftosql)) OR p.proacl IS DISTINCT FROM pip.initprivs);
Date: 2026-06-21 20:02:03 Duration: 374ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
SELECT p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, p.proacl, acldefault('f', p.proowner) AS acldefault, p.pronamespace, p.proowner FROM pg_proc p LEFT JOIN pg_init_privs pip ON (p.oid = pip.objoid AND pip.classoid = 'pg_proc'::regclass AND pip.objsubid = 0) WHERE p.prokind <> 'a' AND NOT EXISTS ( SELECT 1 FROM pg_depend WHERE classid = 'pg_proc'::regclass AND objid = p.oid AND deptype = 'i') AND (pronamespace != ( SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog') OR EXISTS ( SELECT 1 FROM pg_cast WHERE pg_cast.oid > 16383 AND p.oid = pg_cast.castfunc) OR EXISTS ( SELECT 1 FROM pg_transform WHERE pg_transform.oid > 16383 AND (p.oid = pg_transform.trffromsql OR p.oid = pg_transform.trftosql)) OR p.proacl IS DISTINCT FROM pip.initprivs);
Date: 2026-06-21 23:36:13 Duration: 287ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 4 1m4s 2s142ms 32s 16s150ms copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 21 20 2 34s162ms 17s81ms 23 2 30s440ms 15s220ms [ User: intelifix - Total duration: 1m4s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m4s - Times executed: 4 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-06-21 20:05:44 Duration: 32s 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-21 23:18:11 Duration: 28s298ms 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-21 20:08:46 Duration: 2s161ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
9 4 55s554ms 2s526ms 26s292ms 13s888ms 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 #9
Day Hour Count Duration Avg duration Jun 21 20 2 26s58ms 13s29ms 23 2 29s495ms 14s747ms [ User: intelifix - Total duration: 55s554ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 55s554ms - 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-21 23:36:10 Duration: 26s292ms 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-21 20:08:26 Duration: 23s532ms 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-21 23:38:20 Duration: 3s203ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
10 4 55s212ms 1s568ms 26s739ms 13s803ms 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 21 20 2 28s308ms 14s154ms 23 2 26s904ms 13s452ms [ User: intelifix - Total duration: 55s212ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 55s212ms - Times executed: 4 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-06-21 20:06:14 Duration: 26s739ms 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-21 23:18:40 Duration: 25s105ms 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-21 23:37:43 Duration: 1s799ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
11 4 42s476ms 1s175ms 20s884ms 10s619ms 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 #11
Day Hour Count Duration Avg duration Jun 21 20 2 22s59ms 11s29ms 23 2 20s416ms 10s208ms [ User: intelifix - Total duration: 42s476ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 42s476ms - 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-21 20:03:58 Duration: 20s884ms 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-21 23:16:38 Duration: 19s74ms 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-21 23:37:39 Duration: 1s341ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
12 4 41s190ms 1s638ms 20s93ms 10s297ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 21 20 2 19s459ms 9s729ms 23 2 21s731ms 10s865ms [ User: intelifix - Total duration: 41s190ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 41s190ms - Times executed: 4 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-21 23:15:20 Duration: 20s93ms 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-21 20:02:39 Duration: 17s571ms 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-21 20:08:37 Duration: 1s887ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
13 4 38s886ms 1s484ms 18s270ms 9s721ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 21 20 2 19s131ms 9s565ms 23 2 19s755ms 9s877ms [ User: intelifix - Total duration: 38s886ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 38s886ms - Times executed: 4 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-21 23:15:51 Duration: 18s270ms 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-21 20:03:11 Duration: 17s639ms 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-21 20:08:40 Duration: 1s492ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
14 4 28s214ms 895ms 13s559ms 7s53ms 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 #14
Day Hour Count Duration Avg duration Jun 21 20 2 14s455ms 7s227ms 23 2 13s759ms 6s879ms [ User: intelifix - Total duration: 28s214ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 28s214ms - 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-21 20:02:53 Duration: 13s559ms 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-21 23:15:33 Duration: 12s849ms 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-21 23:37:33 Duration: 910ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
15 4 27s663ms 1s162ms 12s908ms 6s915ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 21 20 2 13s592ms 6s796ms 23 2 14s70ms 7s35ms [ User: intelifix - Total duration: 27s663ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 27s663ms - 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-21 23:16:04 Duration: 12s908ms 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-21 20:03:23 Duration: 12s250ms 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-21 20:08:41 Duration: 1s342ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
16 4 21s660ms 655ms 10s453ms 5s415ms 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 #16
Day Hour Count Duration Avg duration Jun 21 20 2 10s519ms 5s259ms 23 2 11s140ms 5s570ms [ User: intelifix - Total duration: 21s660ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 21s660ms - 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-21 23:16:19 Duration: 10s453ms 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-21 20:03:37 Duration: 9s864ms 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-21 23:37:37 Duration: 687ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
17 4 18s775ms 792ms 8s766ms 4s693ms 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 #17
Day Hour Count Duration Avg duration Jun 21 20 2 9s83ms 4s541ms 23 2 9s691ms 4s845ms [ User: intelifix - Total duration: 18s775ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 18s775ms - 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-21 23:14:56 Duration: 8s766ms 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-21 20:02:18 Duration: 8s291ms 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-21 23:37:31 Duration: 925ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
18 4 18s772ms 2s114ms 7s801ms 4s693ms 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 #18
Day Hour Count Duration Avg duration Jun 21 20 2 8s88ms 4s44ms 23 2 10s683ms 5s341ms [ User: intelifix - Total duration: 18s772ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 18s772ms - 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-21 23:34:07 Duration: 7s801ms 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-21 20:06:35 Duration: 5s974ms 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-21 23:38:16 Duration: 2s882ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
19 4 9s463ms 486ms 4s275ms 2s365ms copy public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 21 20 2 4s660ms 2s330ms 23 2 4s803ms 2s401ms [ User: intelifix - Total duration: 9s463ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 9s463ms - Times executed: 4 ]
-
COPY public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) TO stdout;
Date: 2026-06-21 23:16:09 Duration: 4s275ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) TO stdout;
Date: 2026-06-21 20:03:27 Duration: 4s174ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) TO stdout;
Date: 2026-06-21 23:37:37 Duration: 528ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
20 4 9s212ms 2s205ms 2s396ms 2s303ms copy ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 21 20 2 4s521ms 2s260ms 23 2 4s690ms 2s345ms [ User: intelifix - Total duration: 9s212ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 9s212ms - Times executed: 4 ]
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-06-21 23:37:30 Duration: 2s396ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-06-21 20:08:35 Duration: 2s316ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-06-21 23:14:46 Duration: 2s293ms Database: rio User: intelifix Remote: [local] Application: pg_dump
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 746ms 9m5s 3m50s 3 11m32s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 21 05 3 11m32s 3m50s [ User: intelifix - Total duration: 11m32s - Times executed: 3 ]
[ Application: psql - Total duration: 11m32s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-06-21 05:09:07 Duration: 9m5s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-21 05:11:33 Duration: 2m25s Database: contagem User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-21 05:09:07 Duration: 746ms Database: brasilia User: intelifix Remote: [local] Application: psql
2 999ms 16m21s 3m23s 32 1h48m44s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 21 07 2 14m12s 7m6s 08 2 5m38s 2m49s 09 2 5m47s 2m53s 10 2 5m53s 2m56s 11 2 5m36s 2m48s 12 2 16m29s 8m14s 13 2 5m43s 2m51s 14 2 5m48s 2m54s 15 2 5m54s 2m57s 16 2 5m43s 2m51s 17 2 5m30s 2m45s 18 2 5m14s 2m37s 19 2 5m24s 2m42s 20 2 5m7s 2m33s 21 2 5m15s 2m37s 22 2 5m23s 2m41s [ User: intelifix - Total duration: 1h48m44s - Times executed: 32 ]
[ Application: psql - Total duration: 1h48m44s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-21 12:21:22 Duration: 16m21s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-21 07:19:10 Duration: 14m9s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-21 15:10:54 Duration: 5m52s Database: rio User: intelifix Remote: [local] Application: psql
3 1m16s 1m23s 1m20s 2 2m40s 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 21 20 1 1m16s 1m16s 23 1 1m23s 1m23s [ User: intelifix - Total duration: 2m40s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m40s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-21 23:35:44 Duration: 1m23s 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-21 20:08:03 Duration: 1m16s Database: rio User: intelifix Remote: [local] Application: pg_dump
4 20s499ms 1m22s 51s681ms 2 1m43s 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 21 23 2 1m43s 51s681ms [ User: intelifix - Total duration: 1m43s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m43s - 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-21 23:13:43 Duration: 1m22s 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-21 23:37:11 Duration: 20s499ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
5 45s409ms 53s433ms 49s421ms 2 1m38s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 21 20 1 53s433ms 53s433ms 23 1 45s409ms 45s409ms [ User: intelifix - Total duration: 1m38s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m38s - Times executed: 2 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-21 20:05:11 Duration: 53s433ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-21 23:17:42 Duration: 45s409ms Database: rio User: intelifix Remote: [local] Application: pg_dump
6 17s511ms 1m16s 46s931ms 2 1m33s copy auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 21 23 2 1m33s 46s931ms [ User: intelifix - Total duration: 1m33s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m33s - 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-21 23:11:21 Duration: 1m16s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-06-21 23:36:35 Duration: 17s511ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
7 16s257ms 58s952ms 37s604ms 2 1m15s 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 21 23 2 1m15s 37s604ms [ User: intelifix - Total duration: 1m15s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m15s - 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-21 23:12:20 Duration: 58s952ms 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-21 23:36:51 Duration: 16s257ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
8 14s478ms 58s515ms 36s497ms 2 1m12s 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 21 23 2 1m12s 36s497ms [ User: intelifix - Total duration: 1m12s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m12s - 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-21 23:14:42 Duration: 58s515ms 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-21 23:37:26 Duration: 14s478ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
9 415ms 2m7s 20s554ms 32 10m57s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 21 07 2 1m46s 53s416ms 08 2 29s825ms 14s912ms 09 2 28s736ms 14s368ms 10 2 31s813ms 15s906ms 11 2 30s481ms 15s240ms 12 2 2m10s 1m5s 13 2 32s674ms 16s337ms 14 2 32s733ms 16s366ms 15 2 30s425ms 15s212ms 16 2 30s27ms 15s13ms 17 2 31s647ms 15s823ms 18 2 26s703ms 13s351ms 19 2 29s174ms 14s587ms 20 2 29s872ms 14s936ms 21 2 28s693ms 14s346ms 22 2 27s843ms 13s921ms [ User: intelifix - Total duration: 10m57s - Times executed: 32 ]
[ Application: psql - Total duration: 10m57s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-21 12:23:30 Duration: 2m7s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-21 07:20:55 Duration: 1m45s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-21 13:11:15 Duration: 32s193ms Database: rio User: intelifix Remote: [local] Application: psql
10 18s213ms 19s661ms 18s937ms 2 37s875ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 21 20 1 19s661ms 19s661ms 23 1 18s213ms 18s213ms [ User: intelifix - Total duration: 37s875ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 37s875ms - Times executed: 2 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-06-21 20:04:17 Duration: 19s661ms 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-21 23:16:56 Duration: 18s213ms Database: rio User: intelifix Remote: [local] Application: pg_dump
11 2s142ms 32s 16s150ms 4 1m4s copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 21 20 2 34s162ms 17s81ms 23 2 30s440ms 15s220ms [ User: intelifix - Total duration: 1m4s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m4s - Times executed: 4 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-06-21 20:05:44 Duration: 32s 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-21 23:18:11 Duration: 28s298ms 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-21 20:08:46 Duration: 2s161ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
12 8s662ms 20s823ms 13s902ms 6 1m23s call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 21 00 2 40s131ms 20s65ms 06 2 18s479ms 9s239ms 11 2 24s803ms 12s401ms [ User: intelifix - Total duration: 1m23s - Times executed: 6 ]
[ Application: psql - Total duration: 1m23s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-21 00:05:22 Duration: 20s823ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-21 00:05:41 Duration: 19s307ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-21 11:59:03 Duration: 14s328ms Database: rio User: intelifix Remote: [local] Application: psql
13 2s526ms 26s292ms 13s888ms 4 55s554ms 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 21 20 2 26s58ms 13s29ms 23 2 29s495ms 14s747ms [ User: intelifix - Total duration: 55s554ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 55s554ms - 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-21 23:36:10 Duration: 26s292ms 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-21 20:08:26 Duration: 23s532ms 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-21 23:38:20 Duration: 3s203ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
14 1s568ms 26s739ms 13s803ms 4 55s212ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 21 20 2 28s308ms 14s154ms 23 2 26s904ms 13s452ms [ User: intelifix - Total duration: 55s212ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 55s212ms - Times executed: 4 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-06-21 20:06:14 Duration: 26s739ms 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-21 23:18:40 Duration: 25s105ms 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-21 23:37:43 Duration: 1s799ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
15 1s175ms 20s884ms 10s619ms 4 42s476ms 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 21 20 2 22s59ms 11s29ms 23 2 20s416ms 10s208ms [ User: intelifix - Total duration: 42s476ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 42s476ms - 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-21 20:03:58 Duration: 20s884ms 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-21 23:16:38 Duration: 19s74ms 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-21 23:37:39 Duration: 1s341ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
16 247ms 21s560ms 10s593ms 7 1m14s select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 21 00 2 23s158ms 11s579ms 06 2 25s439ms 12s719ms 11 3 25s554ms 8s518ms [ User: lenon - Total duration: 1m14s - Times executed: 7 ]
[ Application: psql - Total duration: 1m14s - Times executed: 7 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-06-21 11:59:24 Duration: 21s560ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-06-21 06:02:23 Duration: 21s456ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-06-21 00:02:23 Duration: 21s364ms Database: rio User: lenon Remote: [local] Application: psql
17 1s638ms 20s93ms 10s297ms 4 41s190ms 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 21 20 2 19s459ms 9s729ms 23 2 21s731ms 10s865ms [ User: intelifix - Total duration: 41s190ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 41s190ms - Times executed: 4 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-21 23:15:20 Duration: 20s93ms 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-21 20:02:39 Duration: 17s571ms 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-21 20:08:37 Duration: 1s887ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
18 1s484ms 18s270ms 9s721ms 4 38s886ms 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 21 20 2 19s131ms 9s565ms 23 2 19s755ms 9s877ms [ User: intelifix - Total duration: 38s886ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 38s886ms - Times executed: 4 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-21 23:15:51 Duration: 18s270ms 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-21 20:03:11 Duration: 17s639ms 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-21 20:08:40 Duration: 1s492ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
19 895ms 13s559ms 7s53ms 4 28s214ms 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 21 20 2 14s455ms 7s227ms 23 2 13s759ms 6s879ms [ User: intelifix - Total duration: 28s214ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 28s214ms - 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-21 20:02:53 Duration: 13s559ms 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-21 23:15:33 Duration: 12s849ms 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-21 23:37:33 Duration: 910ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
20 1s162ms 12s908ms 6s915ms 4 27s663ms 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 21 20 2 13s592ms 6s796ms 23 2 14s70ms 7s35ms [ User: intelifix - Total duration: 27s663ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 27s663ms - 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-21 23:16:04 Duration: 12s908ms 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-21 20:03:23 Duration: 12s250ms 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-21 20:08:41 Duration: 1s342ms 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 2 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jun 21 13 1 0ms 0ms 21 1 0ms 0ms [ User: intelifix - Total duration: 5m44s - Times executed: 2 ]
[ Application: psql - Total duration: 5m44s - Times executed: 2 ]
-
;
Date: Duration: 0ms Database: postgres User: rio Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 5,681 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 24 FATAL entries
- 1879 ERROR entries
- 0 WARNING entries
- 2 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 1,425 Max number of times the same event was reported
- 1,905 Total events found
Rank Times reported Error 1 1,425 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jun 21 00 60 01 59 02 59 03 60 04 59 05 59 06 60 07 59 08 60 09 59 10 60 11 56 12 59 13 60 14 59 15 60 16 60 17 59 18 60 19 60 20 59 21 60 22 59 23 60 - ERROR: prepared statement "_PLAN0000000029E78D10" does not exist
- ERROR: prepared statement "_PLAN0000000029C76F30" does not exist
- ERROR: prepared statement "_PLAN0000000029E76D20" does not exist
Statement: DEALLOCATE "_PLAN0000000029E78D10"
Date: 2026-06-21 00:00:06 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029C76F30"
Date: 2026-06-21 00:01:06 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029E76D20"
Date: 2026-06-21 00:02:07 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 137 ERROR: procedure rs_giga_processa_arquivos() does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Jun 21 00 6 01 6 02 6 03 6 04 6 05 6 06 6 07 6 08 6 09 6 10 6 11 5 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-21 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_GIGA_PROCESSA_ARQUIVOS()Date: 2026-06-21 00:15:05 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-21 00:25:04 Database: brasilia Application: psql User: intelifix Remote: [local]
3 137 ERROR: procedure rs_giga_triagem(...) does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count Jun 21 00 6 01 6 02 6 03 6 04 6 05 6 06 6 07 6 08 6 09 6 10 6 11 5 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-21 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_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-06-21 00:15:05 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-21 00:25:04 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 21 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-21 08:01: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_TCIA_PROCESSA_LOTES()Date: 2026-06-21 08:20:08 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-21 08:40:07 Database: brasilia Application: psql User: intelifix Remote: [local]
5 45 ERROR: procedure rs_giga_tecnicos() does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Jun 21 00 2 01 2 02 2 03 1 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-21 00:05:02 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-21 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-21 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
6 45 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #6
Day Hour Count Jun 21 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-21 08:01:01 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-21 08:20:08 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-21 08:40:07 Database: rio Application: psql User: intelifix Remote: [local]
7 16 ERROR: function rs_smart_fiscal_saida() does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Jun 21 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-21 07:20:55 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-21 08:11:07 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-21 09:11:15 Database: brasilia Application: psql User: intelifix Remote: [local]
8 16 ERROR: function rs_smart_fiscal_entrada() does not exist
Times Reported Most Frequent Error / Event #8
Day Hour Count Jun 21 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-21 07:20:55 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-21 08:11:07 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-21 09:11:15 Database: brasilia Application: psql User: intelifix Remote: [local]
9 12 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #9
Day Hour Count Jun 21 03 6 11 6 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-06-21 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-21 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-06-21 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
10 9 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #10
Day Hour Count Jun 21 00 1 06 1 09 1 11 1 14 1 17 1 18 1 19 1 22 1 - FATAL: database "testes" does not exist
- FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-06-21 00:02:25 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-06-21 06:02:27 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-06-21 09:43:02 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
11 8 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #11
Day Hour Count Jun 21 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-21 05:30:02 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-21 05:30:02 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-21 05:30:02 Database: brasilia Application: postgres_fdw User: lenon Remote: 127.0.0.1
12 3 ERROR: procedure rs_atualiza_estoque_automatico() does not exist
Times Reported Most Frequent Error / Event #12
Day Hour Count Jun 21 00 1 06 1 11 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
- 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-21 00:05:22 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-21 06:05:12 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-21 11:59:03 Database: brasilia Application: psql User: intelifix Remote: [local]
13 3 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #13
Day Hour Count Jun 21 03 3 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-06-21 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-21 03:05:02 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-21 03:05:02 Database: rio Application: [unknown] User: etiquetas Remote: [local]
14 2 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #14
Day Hour Count Jun 21 03 1 11 1 - LOG: database system was shut down at 2026-06-21 03:05:02 -03
- LOG: database system was shut down at 2026-06-21 11:54:28 -03
Date: 2026-06-21 03:05:03
Date: 2026-06-21 11:58:48
15 1 ERROR: function rs_del_temporario() does not exist
Times Reported Most Frequent Error / Event #15
Day Hour Count Jun 21 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-21 21:25:02 Database: brasilia Application: psql User: intelifix Remote: [local]
16 1 ERROR: function rs_lote_entrada_fechar_automatico() does not exist
Times Reported Most Frequent Error / Event #16
Day Hour Count Jun 21 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-21 18:00:02 Database: brasilia Application: psql User: intelifix Remote: [local]