pgBadger-
Global information
- Generated on Sat Jun 20 23:50:07 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 10,319 log entries in 5s
- Log start from 2026-06-20 00:00:56 to 2026-06-20 23:49:59
-
Overview
Global Stats
- 143 Number of unique normalized queries
- 599 Number of queries
- 2h52m53s Total query duration
- 2026-06-20 00:02:25 First query
- 2026-06-20 23:46:58 Last query
- 4 queries/s at 2026-06-20 23:46:42 Query peak
- 2h52m53s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 2h52m53s Execute total duration
- 1,887 Number of events
- 17 Number of unique normalized events
- 1,410 Max number of times the same event was reported
- 0 Number of cancellation
- 6 Total number of automatic vacuums
- 9 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 190 Total number of sessions
- 7 sessions at 2026-06-20 03:44:22 Session peak
- 6d23h49m23s Total duration of sessions
- 52m59s Average duration of sessions
- 3 Average queries per session
- 54s595ms Average queries duration per session
- 52m5s Average idle time per session
- 196 Total number of connections
- 5 connections/s at 2026-06-20 03:05:16 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 4 queries/s Query Peak
- 2026-06-20 23:46:42 Date
SELECT Traffic
Key values
- 3 queries/s Query Peak
- 2026-06-20 23:44:21 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-06-20 23:46:42 Date
Queries duration
Key values
- 2h52m53s 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 20 00 18 0ms 23s266ms 6s161ms 3s140ms 6s85ms 1m5s 01 34 0ms 2s978ms 880ms 2s859ms 4s248ms 5s525ms 02 14 0ms 3s148ms 1s789ms 3s49ms 4s65ms 5s587ms 03 16 0ms 3s416ms 1s577ms 2s812ms 4s159ms 5s108ms 04 40 0ms 3s749ms 902ms 4s247ms 4s907ms 6s860ms 05 24 0ms 8m2s 27s161ms 2s674ms 11s310ms 8m3s 06 10 0ms 21s972ms 5s964ms 2s673ms 2s702ms 25s895ms 07 10 0ms 9m42s 1m7s 2s678ms 3s956ms 9m42s 08 10 0ms 6m26s 44s211ms 3s12ms 3s410ms 6m26s 09 10 0ms 5m36s 38s413ms 2s891ms 3s660ms 5m36s 10 10 0ms 6m22s 43s763ms 3s132ms 3s773ms 6m57s 11 10 0ms 6m24s 43s824ms 2s769ms 3s336ms 6m24s 12 10 0ms 5m40s 38s815ms 2s634ms 3s193ms 5m40s 13 10 0ms 5m35s 38s209ms 2s778ms 2s956ms 5m35s 14 10 0ms 5m52s 40s11ms 2s653ms 3s66ms 5m52s 15 10 0ms 5m36s 38s516ms 2s655ms 3s343ms 5m36s 16 10 0ms 5m40s 38s759ms 2s847ms 3s28ms 5m40s 17 10 0ms 5m45s 39s556ms 3s10ms 4s81ms 5m45s 18 11 0ms 5m55s 37s82ms 2s679ms 3s129ms 5m55s 19 10 0ms 5m51s 39s839ms 2s498ms 3s546ms 5m51s 20 63 0ms 6m17s 14s364ms 54s970ms 1m29s 6m17s 21 11 0ms 5m44s 35s772ms 2s693ms 3s202ms 5m44s 22 10 0ms 5m55s 40s464ms 2s712ms 3s547ms 5m55s 23 228 0ms 2m2s 9s680ms 1m24s 1m42s 2m2s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 20 00 2 0 12s358ms 0ms 0ms 0ms 01 22 0 255ms 197ms 291ms 545ms 02 2 0 458ms 0ms 0ms 0ms 03 4 0 348ms 0ms 0ms 433ms 04 28 0 247ms 206ms 404ms 635ms 05 12 0 281ms 0ms 181ms 1s28ms 06 2 0 12s947ms 0ms 0ms 0ms 07 4 0 2m44s 0ms 0ms 1m14s 08 4 0 1m45s 0ms 0ms 37s80ms 09 4 0 1m31s 0ms 0ms 29s683ms 10 4 0 1m44s 0ms 0ms 0ms 11 4 0 1m45s 0ms 0ms 36s208ms 12 4 0 1m32s 0ms 0ms 31s359ms 13 4 0 1m31s 0ms 0ms 30s368ms 14 4 0 1m35s 0ms 0ms 30s421ms 15 4 0 1m32s 0ms 0ms 31s855ms 16 4 0 1m32s 0ms 0ms 30s283ms 17 4 0 1m33s 0ms 0ms 30s423ms 18 5 0 1m18s 0ms 0ms 35s874ms 19 4 0 1m35s 0ms 0ms 30s558ms 20 7 50 15s590ms 340ms 54s598ms 1m32s 21 5 0 1m15s 0ms 0ms 31s512ms 22 4 0 1m36s 0ms 0ms 32s235ms 23 9 219 9s680ms 1m5s 1m24s 2m2s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 20 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 20 00 0 0 0.00 0.00% 01 0 1 1.00 0.00% 02 0 1 1.00 0.00% 03 0 2 2.00 0.00% 04 0 1 1.00 0.00% 05 0 2 2.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 1 1.00 0.00% Day Hour Count Average / Second Jun 20 00 13 0.00/s 01 7 0.00/s 02 8 0.00/s 03 23 0.01/s 04 9 0.00/s 05 7 0.00/s 06 12 0.00/s 07 7 0.00/s 08 6 0.00/s 09 5 0.00/s 10 8 0.00/s 11 6 0.00/s 12 8 0.00/s 13 6 0.00/s 14 7 0.00/s 15 8 0.00/s 16 8 0.00/s 17 7 0.00/s 18 6 0.00/s 19 7 0.00/s 20 10 0.00/s 21 6 0.00/s 22 7 0.00/s 23 5 0.00/s Day Hour Count Average Duration Average idle time Jun 20 00 4 1h45s 1h17s 01 12 1h58s 1h56s 02 7 1h26s 1h22s 03 18 15m31s 15m29s 04 9 1h2m 1h1m56s 05 10 55m58s 54m53s 06 6 1h 59m50s 07 11 1h1m25s 1h24s 08 7 1h1m14s 1h11s 09 6 1h 58m56s 10 6 52m30s 51m17s 11 7 1h1m21s 1h18s 12 6 1h1m18s 1h14s 13 7 1h 59m6s 14 7 52m51s 51m54s 15 6 1h56s 59m52s 16 8 53m45s 52m57s 17 8 53m45s 52m56s 18 6 1h59s 59m51s 19 6 1h 58m54s 20 11 39m46s 38m24s 21 6 1h 58m54s 22 6 55m50s 54m42s 23 10 46m17s 42m37s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-06-20 03:05:16 Date
Connections per database
Key values
- rio Main Database
- 196 connections Total
Connections per user
Key values
- intelifix Main User
- 196 connections Total
-
Sessions
Simultaneous sessions
Key values
- 7 sessions Session Peak
- 2026-06-20 03:44:22 Date
Histogram of session times
Key values
- 160 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 190 sessions Total
Sessions per user
Key values
- intelifix Main User
- 190 sessions Total
Sessions per host
Key values
- [local] Main Host
- 190 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 9,030 buffers Checkpoint Peak
- 2026-06-20 00:09:54 Date
- 269.920 seconds Highest write time
- 0.071 seconds Sync time
Checkpoints Wal files
Key values
- 3 files Wal files usage Peak
- 2026-06-20 00:09:54 Date
Checkpoints distance
Key values
- 96.05 Mo Distance Peak
- 2026-06-20 00:09:54 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jun 20 00 15,194 663.373s 0.033s 663.442s 01 3,177 318.876s 0.089s 319.017s 02 1,430 143.616s 0.103s 143.755s 03 1,511 151.788s 0.172s 152.014s 04 3,955 396.477s 0.12s 396.647s 05 7,814 673.174s 0.052s 673.284s 06 4,580 269.228s 0.002s 269.237s 07 894 89.715s 0.131s 89.862s 08 26 2.663s 0.007s 2.679s 09 21 2.133s 0.004s 2.145s 10 21 2.149s 0.004s 2.159s 11 21 2.135s 0.005s 2.145s 12 21 2.133s 0.007s 2.147s 13 21 2.128s 0.004s 2.136s 14 21 2.13s 0.008s 2.146s 15 21 2.13s 0.004s 2.139s 16 21 2.13s 0.004s 2.14s 17 21 2.133s 0.003s 2.143s 18 195 19.65s 0.066s 19.728s 19 21 2.13s 0.004s 2.138s 20 129 12.996s 0.013s 13.023s 21 45 4.603s 0.017s 4.643s 22 21 2.132s 0.004s 2.142s 23 64 6.466s 0.016s 6.493s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jun 20 00 0 0 5 449 0.014s 0.006s 01 0 0 1 764 0.016s 0.01s 02 0 0 1 408 0.063s 0.006s 03 0 0 0 422 0.069s 0.016s 04 0 0 1 658 0.064s 0.009s 05 0 0 4 647 0.008s 0.008s 06 0 0 0 8 0.002s 0.001s 07 0 0 1 18 0.064s 0.024s 08 0 0 0 4 0.003s 0.005s 09 0 0 0 3 0.003s 0.002s 10 0 0 0 3 0.003s 0.002s 11 0 0 0 3 0.004s 0.002s 12 0 0 0 3 0.005s 0.003s 13 0 0 0 3 0.003s 0.002s 14 0 0 0 3 0.007s 0.003s 15 0 0 0 3 0.004s 0.002s 16 0 0 0 3 0.003s 0.002s 17 0 0 0 3 0.003s 0.001s 18 0 0 0 25 0.063s 0.014s 19 0 0 0 3 0.003s 0.002s 20 0 0 0 18 0.005s 0.004s 21 0 0 0 19 0.006s 0.009s 22 0 0 0 3 0.004s 0.002s 23 0 0 0 5 0.013s 0.007s Day Hour Count Avg time (sec) Jun 20 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 20 00 14,677.17 kB 40,896.00 kB 01 1,617.80 kB 19,277.20 kB 02 1,215.83 kB 8,807.50 kB 03 892.67 kB 2,679.78 kB 04 2,348.67 kB 3,224.33 kB 05 7,368.12 kB 21,974.12 kB 06 6,605.00 kB 19,020.00 kB 07 1,777.33 kB 15,929.67 kB 08 91.00 kB 12,238.50 kB 09 166.00 kB 10,459.00 kB 10 166.00 kB 9,430.00 kB 11 166.00 kB 8,503.00 kB 12 166.00 kB 7,670.00 kB 13 165.00 kB 6,919.00 kB 14 166.00 kB 6,244.00 kB 15 166.00 kB 5,636.00 kB 16 166.00 kB 5,089.00 kB 17 166.00 kB 4,597.00 kB 18 378.50 kB 3,993.50 kB 19 166.00 kB 3,431.00 kB 20 393.33 kB 2,867.00 kB 21 59.50 kB 2,034.75 kB 22 166.00 kB 1,572.00 kB 23 41.50 kB 1,348.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 20 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.21 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database rio - 2026-06-20 05:08:40 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 0.21 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database rio - 2026-06-20 05:08:40 Date
Analyzes per table
Key values
- public.temp0000283142 (5) Main table analyzed (database rio)
- 9 analyzes Total
Vacuums per table
Key values
- pg_toast.pg_toast_2619 (1) Main table vacuumed on database contagem
- 6 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 176 37 123,894 11 26 rio.pg_catalog.pg_statistic 1 1 0 0 0 0 0 3,326 406 1,742,586 370 2,227 brasilia.pg_catalog.pg_shdepend 1 1 0 0 0 0 0 259 96 150,518 2 30 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,431 688 2,265,364 645 4,595 rio.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 927 134 857,742 57 270 brasilia.pg_catalog.pg_statistic 1 1 0 0 0 0 0 79 2 7,379 0 0 Total 6 6 0 0 0 0 0 7,198 1,363 5,147,483 1,085 7,148 Vacuum throughput per table
Key values
- pg_catalog.pg_statistic (0.21) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
Tuples removed per table
Key values
- pg_catalog.pg_statistic (4410) Main table with removed tuples on database rio
- 10616 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_statistic 1 1 4,410 7,492 0 0 1,286 contagem.pg_catalog.pg_statistic 1 1 4,258 7,274 0 0 1,011 brasilia.pg_catalog.pg_shdepend 1 1 866 9,728 0 0 101 rio.pg_toast.pg_toast_2619 1 1 765 675 0 0 300 brasilia.pg_catalog.pg_statistic 1 1 163 449 0 0 36 contagem.pg_toast.pg_toast_2619 1 1 154 114 0 8 55 Total 6 6 10,616 25,732 0 8 2,789 Pages removed per table
Key values
- pg_toast.pg_toast_2619 (8) Main table with removed pages on database contagem
- 8 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed contagem.pg_toast.pg_toast_2619 1 1 154 8 rio.pg_catalog.pg_statistic 1 1 4410 0 brasilia.pg_catalog.pg_shdepend 1 1 866 0 contagem.pg_catalog.pg_statistic 1 1 4258 0 rio.pg_toast.pg_toast_2619 1 1 765 0 brasilia.pg_catalog.pg_statistic 1 1 163 0 Total 6 6 10,616 8 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jun 20 00 0 0 01 1 3 02 0 0 03 0 0 04 0 4 05 5 2 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.21 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 150 Total read queries
- 269 Total write queries
Queries by database
Key values
- rio Main database
- 431 Requests
- 2h46m21s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 587 Requests
User Request type Count Duration etiquetas Total 2 1s14ms select 2 1s14ms intelifix Total 587 2h51m59s copy to 269 44m7s others 180 19m9s select 138 1h48m42s lenon Total 10 53s50ms select 10 53s50ms Duration by user
Key values
- 2h51m59s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 2 1s14ms select 2 1s14ms intelifix Total 587 2h51m59s copy to 269 44m7s others 180 19m9s select 138 1h48m42s lenon Total 10 53s50ms select 10 53s50ms Queries by host
Key values
- [local] Main host
- 599 Requests
- 2h52m53s ([local])
- Main time consuming host
Queries by application
Key values
- pg_dump Main application
- 280 Requests
- 2h8m23s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-06-20 22:25:03 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 226 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 9m42s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-20 07:14:43 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 8m2s analyze verbose;[ Date: 2026-06-20 05:08:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 6m26s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-20 08:11:27 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 6m24s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-20 11:11:26 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 6m22s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-20 10:11:24 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 6m17s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-20 20:11:19 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 5m55s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-20 22:10:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 5m55s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-20 18:10:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 5m52s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-20 14:10:54 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 5m51s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-20 19:10:52 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 5m45s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-20 17:10:47 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m44s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-20 21:10:46 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 5m40s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-20 16:10:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m40s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-20 12:10:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m36s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-20 09:10:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m36s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-20 15:10:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m35s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-20 13:10:36 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 2m18s analyze verbose;[ Date: 2026-06-20 05:10:23 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
19 2m2s 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-20 23:15:10 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
20 1m42s COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;[ Date: 2026-06-20 23:43:52 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1h38m53s 32 1s168ms 9m42s 3m5s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 20 07 2 9m46s 4m53s 08 2 6m27s 3m13s 09 2 5m37s 2m48s 10 2 6m23s 3m11s 11 2 6m26s 3m13s 12 2 5m41s 2m50s 13 2 5m36s 2m48s 14 2 5m54s 2m57s 15 2 5m37s 2m48s 16 2 5m41s 2m50s 17 2 5m46s 2m53s 18 2 5m56s 2m58s 19 2 5m53s 2m56s 20 2 6m21s 3m10s 21 2 5m46s 2m53s 22 2 5m57s 2m58s [ User: intelifix - Total duration: 1h38m53s - Times executed: 32 ]
[ Application: psql - Total duration: 1h38m53s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-20 07:14:43 Duration: 9m42s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-20 08:11:27 Duration: 6m26s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-20 11:11:26 Duration: 6m24s Database: rio User: intelifix Remote: [local] Application: psql
2 10m21s 3 621ms 8m2s 3m27s analyze verbose;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 20 05 3 10m21s 3m27s [ User: intelifix - Total duration: 10m21s - Times executed: 3 ]
[ Application: psql - Total duration: 10m21s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-06-20 05:08:04 Duration: 8m2s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-20 05:10:23 Duration: 2m18s Database: contagem User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-20 05:08:04 Duration: 621ms Database: brasilia User: intelifix Remote: [local] Application: psql
3 9m29s 32 416ms 1m10s 17s807ms select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 20 07 2 1m12s 36s288ms 08 2 35s883ms 17s941ms 09 2 28s360ms 14s180ms 10 2 33s455ms 16s727ms 11 2 34s783ms 17s391ms 12 2 29s979ms 14s989ms 13 2 29s123ms 14s561ms 14 2 29s174ms 14s587ms 15 2 30s686ms 15s343ms 16 2 28s985ms 14s492ms 17 2 28s957ms 14s478ms 18 2 34s479ms 17s239ms 19 2 29s137ms 14s568ms 20 2 1m3s 31s804ms 21 2 30s333ms 15s166ms 22 2 30s318ms 15s159ms [ User: intelifix - Total duration: 9m29s - Times executed: 32 ]
[ Application: psql - Total duration: 9m29s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-20 07:15:54 Duration: 1m10s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-20 20:12:21 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-20 08:12:03 Duration: 35s358ms Database: rio User: intelifix Remote: [local] Application: psql
4 6m40s 138 2s277ms 12s53ms 2s900ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 20 00 6 25s223ms 4s203ms 01 6 14s602ms 2s433ms 02 6 17s67ms 2s844ms 03 6 15s949ms 2s658ms 04 6 15s497ms 2s582ms 05 6 16s700ms 2s783ms 06 6 15s893ms 2s648ms 07 6 18s308ms 3s51ms 08 6 18s539ms 3s89ms 09 6 18s187ms 3s31ms 10 6 20s460ms 3s410ms 11 6 17s236ms 2s872ms 12 6 16s786ms 2s797ms 13 6 16s647ms 2s774ms 14 6 16s701ms 2s783ms 15 6 17s58ms 2s843ms 16 6 16s792ms 2s798ms 17 6 19s685ms 3s280ms 18 6 16s684ms 2s780ms 19 6 16s129ms 2s688ms 20 6 16s256ms 2s709ms 21 6 16s695ms 2s782ms 22 6 17s138ms 2s856ms [ User: intelifix - Total duration: 6m40s - Times executed: 138 ]
[ Application: psql - Total duration: 6m40s - Times executed: 138 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-20 00:05:29 Duration: 12s53ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-20 17:55:05 Duration: 4s81ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-20 07:55:05 Duration: 3s956ms Database: rio User: intelifix Remote: [local] Application: psql
5 3m11s 2 1m29s 1m42s 1m35s 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 20 20 1 1m29s 1m29s 23 1 1m42s 1m42s [ User: intelifix - Total duration: 3m11s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 3m11s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-20 23:43:52 Duration: 1m42s 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-20 20:08:35 Duration: 1m29s Database: rio User: intelifix Remote: [local] Application: pg_dump
6 2m28s 2 26s74ms 2m2s 1m14s 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 20 23 2 2m28s 1m14s [ User: intelifix - Total duration: 2m28s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m28s - 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-20 23:15:10 Duration: 2m2s 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-20 23:45:35 Duration: 26s74ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
7 2m2s 2 1m 1m1s 1m1s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 20 20 1 1m 1m 23 1 1m1s 1m1s [ User: intelifix - Total duration: 2m2s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m2s - Times executed: 2 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-20 23:19:44 Duration: 1m1s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-20 20:05:27 Duration: 1m Database: rio User: intelifix Remote: [local] Application: pg_dump
8 2m1s 2 22s996ms 1m38s 1m 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 20 23 2 2m1s 1m [ User: intelifix - Total duration: 2m1s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m1s - 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-20 23:11:43 Duration: 1m38s 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-20 23:44:46 Duration: 22s996ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
9 1m47s 2 22s864ms 1m24s 53s757ms copy auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 20 23 2 1m47s 53s757ms [ User: intelifix - Total duration: 1m47s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m47s - 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-20 23:13:08 Duration: 1m24s 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-20 23:45:09 Duration: 22s864ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
10 1m25s 2 17s673ms 1m8s 42s958ms 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 #10
Day Hour Count Duration Avg duration Jun 20 23 2 1m25s 42s958ms [ User: intelifix - Total duration: 1m25s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m25s - 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-20 23:16:18 Duration: 1m8s 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-20 23:45:52 Duration: 17s673ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
11 1m11s 32 377ms 15s214ms 2s231ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 20 00 6 23s63ms 3s843ms 01 6 9s705ms 1s617ms 02 6 7s66ms 1s177ms 03 5 7s589ms 1s517ms 04 6 13s685ms 2s280ms 05 3 10s285ms 3s428ms [ User: intelifix - Total duration: 1m11s - Times executed: 32 ]
[ Application: psql - Total duration: 1m11s - Times executed: 32 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-20 00:05:17 Duration: 15s214ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-20 05:05:08 Duration: 6s589ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-20 04:55:05 Duration: 3s749ms Database: rio User: intelifix Remote: [local] Application: psql
12 1m8s 4 2s819ms 33s586ms 17s180ms 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 #12
Day Hour Count Duration Avg duration Jun 20 20 2 32s315ms 16s157ms 23 2 36s406ms 18s203ms [ User: intelifix - Total duration: 1m8s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m8s - 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-20 23:20:19 Duration: 33s586ms 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-20 20:05:58 Duration: 29s460ms 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-20 20:09:22 Duration: 2s855ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
13 59s786ms 4 1s698ms 28s186ms 14s946ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 20 20 2 29s902ms 14s951ms 23 2 29s884ms 14s942ms [ User: intelifix - Total duration: 59s786ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 59s786ms - Times executed: 4 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-06-20 23:20:51 Duration: 28s186ms 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-20 20:06:29 Duration: 27s823ms 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-20 20:09:24 Duration: 2s78ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
14 57s520ms 4 2s913ms 26s33ms 14s380ms 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 20 20 2 28s574ms 14s287ms 23 2 28s946ms 14s473ms [ User: intelifix - Total duration: 57s520ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 57s520ms - 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-20 23:44:18 Duration: 26s33ms 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-20 20:09:01 Duration: 25s496ms 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-20 20:09:32 Duration: 3s78ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
15 55s357ms 4 8s768ms 19s83ms 13s839ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 20 00 2 37s505ms 18s752ms 06 2 17s852ms 8s926ms [ User: intelifix - Total duration: 55s357ms - Times executed: 4 ]
[ Application: psql - Total duration: 55s357ms - Times executed: 4 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-20 00:05:21 Duration: 19s83ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-20 00:05:39 Duration: 18s422ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-20 06:05:10 Duration: 9s83ms Database: rio User: intelifix Remote: [local] Application: psql
16 50s612ms 4 1s451ms 23s266ms 12s653ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 20 00 2 24s717ms 12s358ms 06 2 25s895ms 12s947ms [ User: lenon - Total duration: 50s612ms - Times executed: 4 ]
[ Application: psql - Total duration: 50s612ms - Times executed: 4 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-06-20 00:02:25 Duration: 23s266ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-06-20 06:02:23 Duration: 21s972ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-06-20 06:02:28 Duration: 3s922ms Database: contagem User: lenon Remote: [local] Application: psql
17 45s112ms 4 1s396ms 22s254ms 11s278ms copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 20 20 2 21s277ms 10s638ms 23 2 23s835ms 11s917ms [ User: intelifix - Total duration: 45s112ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 45s112ms - 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-20 23:18:23 Duration: 22s254ms 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-20 20:04:07 Duration: 19s881ms 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-20 23:46:06 Duration: 1s580ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
18 41s771ms 4 1s700ms 19s251ms 10s442ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 20 20 2 20s952ms 10s476ms 23 2 20s819ms 10s409ms [ User: intelifix - Total duration: 41s771ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 41s771ms - Times executed: 4 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-20 20:02:45 Duration: 19s251ms 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-20 23:16:59 Duration: 19s40ms 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-20 23:45:59 Duration: 1s778ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
19 40s327ms 4 1s498ms 19s332ms 10s81ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 20 20 2 20s859ms 10s429ms 23 2 19s467ms 9s733ms [ User: intelifix - Total duration: 40s327ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 40s327ms - Times executed: 4 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-20 20:03:19 Duration: 19s332ms 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-20 23:17:31 Duration: 17s969ms 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-20 20:09:14 Duration: 1s526ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
20 38s361ms 2 18s749ms 19s611ms 19s180ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 20 20 1 18s749ms 18s749ms 23 1 19s611ms 19s611ms [ User: intelifix - Total duration: 38s361ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 38s361ms - Times executed: 2 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-06-20 23:18:42 Duration: 19s611ms 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-20 20:04:26 Duration: 18s749ms Database: rio User: intelifix Remote: [local] Application: pg_dump
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 138 6m40s 2s277ms 12s53ms 2s900ms call rs_giga_triagem (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 20 00 6 25s223ms 4s203ms 01 6 14s602ms 2s433ms 02 6 17s67ms 2s844ms 03 6 15s949ms 2s658ms 04 6 15s497ms 2s582ms 05 6 16s700ms 2s783ms 06 6 15s893ms 2s648ms 07 6 18s308ms 3s51ms 08 6 18s539ms 3s89ms 09 6 18s187ms 3s31ms 10 6 20s460ms 3s410ms 11 6 17s236ms 2s872ms 12 6 16s786ms 2s797ms 13 6 16s647ms 2s774ms 14 6 16s701ms 2s783ms 15 6 17s58ms 2s843ms 16 6 16s792ms 2s798ms 17 6 19s685ms 3s280ms 18 6 16s684ms 2s780ms 19 6 16s129ms 2s688ms 20 6 16s256ms 2s709ms 21 6 16s695ms 2s782ms 22 6 17s138ms 2s856ms [ User: intelifix - Total duration: 6m40s - Times executed: 138 ]
[ Application: psql - Total duration: 6m40s - Times executed: 138 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-20 00:05:29 Duration: 12s53ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-20 17:55:05 Duration: 4s81ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-20 07:55:05 Duration: 3s956ms Database: rio User: intelifix Remote: [local] Application: psql
2 43 9s959ms 151ms 635ms 231ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 20 01 18 4s59ms 225ms 04 18 4s437ms 246ms 05 7 1s463ms 209ms [ User: intelifix - Total duration: 9s959ms - Times executed: 43 ]
[ Application: [unknown] - Total duration: 9s959ms - Times executed: 43 ]
-
SELECT * FROM RS_TRIAGEM (429, 5, '113', 3, '230041733646,230005924764,229990172026,229970641725,230005949009,230044214348,230028970830,230027456674,230043098189,229986797891,230024625455,230032961421,229988741718,230001049103,229977377185,229982290101,229987038903,230011079194,230053535572,229971188501,229970656978,229970526584,230051785053,230023321423,229976942542', NULL, NULL, 0295, 00);
Date: 2026-06-20 04:41:17 Duration: 635ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (429, 5, '113', 3, '229966079304,229967417178,230020124152,230010316483,230029128599,230051146876,230033383437,229971586474,229968557985,229968475778,229986525564,229982589905,230027341636,229988955779,230044200004,230038017480,229977654665,230041775973,230041044454,230041398204,229979251331,229991145263', NULL, NULL, 0295, 00);
Date: 2026-06-20 04:42:43 Duration: 395ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '241732838289,241730217697,241732839198,241619383132,241646712141,241730244647,241638413048,241638275256,241708604062,241672695776,241610156990,241652075761,241652291316,241631453850,241691398689,241664938587', NULL, NULL, 0320, 00);
Date: 2026-06-20 01:13:07 Duration: 357ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 32 1h38m53s 1s168ms 9m42s 3m5s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 20 07 2 9m46s 4m53s 08 2 6m27s 3m13s 09 2 5m37s 2m48s 10 2 6m23s 3m11s 11 2 6m26s 3m13s 12 2 5m41s 2m50s 13 2 5m36s 2m48s 14 2 5m54s 2m57s 15 2 5m37s 2m48s 16 2 5m41s 2m50s 17 2 5m46s 2m53s 18 2 5m56s 2m58s 19 2 5m53s 2m56s 20 2 6m21s 3m10s 21 2 5m46s 2m53s 22 2 5m57s 2m58s [ User: intelifix - Total duration: 1h38m53s - Times executed: 32 ]
[ Application: psql - Total duration: 1h38m53s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-20 07:14:43 Duration: 9m42s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-20 08:11:27 Duration: 6m26s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-20 11:11:26 Duration: 6m24s Database: rio User: intelifix Remote: [local] Application: psql
4 32 9m29s 416ms 1m10s 17s807ms select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 20 07 2 1m12s 36s288ms 08 2 35s883ms 17s941ms 09 2 28s360ms 14s180ms 10 2 33s455ms 16s727ms 11 2 34s783ms 17s391ms 12 2 29s979ms 14s989ms 13 2 29s123ms 14s561ms 14 2 29s174ms 14s587ms 15 2 30s686ms 15s343ms 16 2 28s985ms 14s492ms 17 2 28s957ms 14s478ms 18 2 34s479ms 17s239ms 19 2 29s137ms 14s568ms 20 2 1m3s 31s804ms 21 2 30s333ms 15s166ms 22 2 30s318ms 15s159ms [ User: intelifix - Total duration: 9m29s - Times executed: 32 ]
[ Application: psql - Total duration: 9m29s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-20 07:15:54 Duration: 1m10s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-20 20:12:21 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-20 08:12:03 Duration: 35s358ms Database: rio User: intelifix Remote: [local] Application: psql
5 32 1m11s 377ms 15s214ms 2s231ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 20 00 6 23s63ms 3s843ms 01 6 9s705ms 1s617ms 02 6 7s66ms 1s177ms 03 5 7s589ms 1s517ms 04 6 13s685ms 2s280ms 05 3 10s285ms 3s428ms [ User: intelifix - Total duration: 1m11s - Times executed: 32 ]
[ Application: psql - Total duration: 1m11s - Times executed: 32 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-20 00:05:17 Duration: 15s214ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-20 05:05:08 Duration: 6s589ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-20 04:55:05 Duration: 3s749ms Database: rio User: intelifix Remote: [local] Application: psql
6 10 1s688ms 151ms 181ms 168ms select * from rs_equipamento_consulta (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 20 01 1 176ms 176ms 03 1 158ms 158ms 04 8 1s353ms 169ms [ User: intelifix - Total duration: 1s688ms - Times executed: 10 ]
[ Application: [unknown] - Total duration: 1s688ms - Times executed: 10 ]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('216762940114');
Date: 2026-06-20 04:57:37 Duration: 181ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('230028970830');
Date: 2026-06-20 04:35:49 Duration: 181ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('229968557985');
Date: 2026-06-20 04:26:32 Duration: 178ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 6 2s437ms 327ms 492ms 406ms select pro_id, pgp_sym_decrypt(nome, ?)::varchar, pgp_sym_decrypt(descricao, ?)::varchar, pgp_sym_decrypt(classe, ?)::varchar, pgp_sym_decrypt(php, ?)::varchar, pgp_sym_decrypt(extras, ?)::varchar from progs order by pro_id;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 20 01 1 434ms 434ms 02 1 382ms 382ms 03 1 327ms 327ms 04 1 492ms 492ms 05 2 800ms 400ms [ User: lenon - Total duration: 2s437ms - Times executed: 6 ]
[ Application: [unknown] - Total duration: 2s437ms - Times executed: 6 ]
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-06-20 04:38:49 Duration: 492ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-06-20 05:05:13 Duration: 470ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-06-20 01:08:11 Duration: 434ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
8 5 2s824ms 406ms 767ms 564ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 20 01 1 767ms 767ms 03 1 474ms 474ms 04 1 637ms 637ms 05 2 944ms 472ms [ User: intelifix - Total duration: 2s824ms - Times executed: 5 ]
[ Application: [unknown] - Total duration: 2s824ms - Times executed: 5 ]
-
select * from rs_menu_grants (499, 0, 1);
Date: 2026-06-20 01:08:11 Duration: 767ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (500, 81, 1);
Date: 2026-06-20 04:38:49 Duration: 637ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (500, 19, 1);
Date: 2026-06-20 05:05:13 Duration: 538ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 4 1m8s 2s819ms 33s586ms 17s180ms copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 20 20 2 32s315ms 16s157ms 23 2 36s406ms 18s203ms [ User: intelifix - Total duration: 1m8s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m8s - 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-20 23:20:19 Duration: 33s586ms 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-20 20:05:58 Duration: 29s460ms 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-20 20:09:22 Duration: 2s855ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
10 4 59s786ms 1s698ms 28s186ms 14s946ms 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 20 20 2 29s902ms 14s951ms 23 2 29s884ms 14s942ms [ User: intelifix - Total duration: 59s786ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 59s786ms - Times executed: 4 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-06-20 23:20:51 Duration: 28s186ms 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-20 20:06:29 Duration: 27s823ms 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-20 20:09:24 Duration: 2s78ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
11 4 57s520ms 2s913ms 26s33ms 14s380ms copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 20 20 2 28s574ms 14s287ms 23 2 28s946ms 14s473ms [ User: intelifix - Total duration: 57s520ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 57s520ms - 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-20 23:44:18 Duration: 26s33ms 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-20 20:09:01 Duration: 25s496ms 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-20 20:09:32 Duration: 3s78ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
12 4 55s357ms 8s768ms 19s83ms 13s839ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 20 00 2 37s505ms 18s752ms 06 2 17s852ms 8s926ms [ User: intelifix - Total duration: 55s357ms - Times executed: 4 ]
[ Application: psql - Total duration: 55s357ms - Times executed: 4 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-20 00:05:21 Duration: 19s83ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-20 00:05:39 Duration: 18s422ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-20 06:05:10 Duration: 9s83ms Database: rio User: intelifix Remote: [local] Application: psql
13 4 50s612ms 1s451ms 23s266ms 12s653ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 20 00 2 24s717ms 12s358ms 06 2 25s895ms 12s947ms [ User: lenon - Total duration: 50s612ms - Times executed: 4 ]
[ Application: psql - Total duration: 50s612ms - Times executed: 4 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-06-20 00:02:25 Duration: 23s266ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-06-20 06:02:23 Duration: 21s972ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-06-20 06:02:28 Duration: 3s922ms Database: contagem User: lenon Remote: [local] Application: psql
14 4 45s112ms 1s396ms 22s254ms 11s278ms copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 20 20 2 21s277ms 10s638ms 23 2 23s835ms 11s917ms [ User: intelifix - Total duration: 45s112ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 45s112ms - 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-20 23:18:23 Duration: 22s254ms 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-20 20:04:07 Duration: 19s881ms 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-20 23:46:06 Duration: 1s580ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
15 4 41s771ms 1s700ms 19s251ms 10s442ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 20 20 2 20s952ms 10s476ms 23 2 20s819ms 10s409ms [ User: intelifix - Total duration: 41s771ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 41s771ms - Times executed: 4 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-20 20:02:45 Duration: 19s251ms 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-20 23:16:59 Duration: 19s40ms 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-20 23:45:59 Duration: 1s778ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
16 4 40s327ms 1s498ms 19s332ms 10s81ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 20 20 2 20s859ms 10s429ms 23 2 19s467ms 9s733ms [ User: intelifix - Total duration: 40s327ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 40s327ms - Times executed: 4 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-20 20:03:19 Duration: 19s332ms 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-20 23:17:31 Duration: 17s969ms 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-20 20:09:14 Duration: 1s526ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
17 4 30s294ms 930ms 14s673ms 7s573ms copy public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 20 20 2 15s703ms 7s851ms 23 2 14s590ms 7s295ms [ User: intelifix - Total duration: 30s294ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 30s294ms - 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-20 20:02:59 Duration: 14s673ms 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-20 23:17:13 Duration: 13s659ms 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-20 20:09:13 Duration: 1s29ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
18 4 28s272ms 1s518ms 12s718ms 7s68ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 20 20 2 14s33ms 7s16ms 23 2 14s239ms 7s119ms [ User: intelifix - Total duration: 28s272ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 28s272ms - 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-20 23:17:43 Duration: 12s718ms 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-20 20:03:31 Duration: 12s514ms 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-20 23:46:03 Duration: 1s521ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
19 4 26s11ms 3s616ms 9s779ms 6s502ms copy public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 20 20 2 12s414ms 6s207ms 23 2 13s597ms 6s798ms [ User: intelifix - Total duration: 26s11ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 26s11ms - 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-20 23:41:54 Duration: 9s779ms 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-20 20:06:53 Duration: 8s798ms 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-20 23:46:52 Duration: 3s817ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
20 4 25s725ms 909ms 12s131ms 6s431ms copy public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 20 20 2 12s495ms 6s247ms 23 2 13s230ms 6s615ms [ User: intelifix - Total duration: 25s725ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 25s725ms - 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-20 23:16:36 Duration: 12s131ms 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-20 20:02:22 Duration: 11s585ms 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-20 23:45:57 Duration: 1s98ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 621ms 8m2s 3m27s 3 10m21s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 20 05 3 10m21s 3m27s [ User: intelifix - Total duration: 10m21s - Times executed: 3 ]
[ Application: psql - Total duration: 10m21s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-06-20 05:08:04 Duration: 8m2s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-20 05:10:23 Duration: 2m18s Database: contagem User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-20 05:08:04 Duration: 621ms Database: brasilia User: intelifix Remote: [local] Application: psql
2 1s168ms 9m42s 3m5s 32 1h38m53s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 20 07 2 9m46s 4m53s 08 2 6m27s 3m13s 09 2 5m37s 2m48s 10 2 6m23s 3m11s 11 2 6m26s 3m13s 12 2 5m41s 2m50s 13 2 5m36s 2m48s 14 2 5m54s 2m57s 15 2 5m37s 2m48s 16 2 5m41s 2m50s 17 2 5m46s 2m53s 18 2 5m56s 2m58s 19 2 5m53s 2m56s 20 2 6m21s 3m10s 21 2 5m46s 2m53s 22 2 5m57s 2m58s [ User: intelifix - Total duration: 1h38m53s - Times executed: 32 ]
[ Application: psql - Total duration: 1h38m53s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-20 07:14:43 Duration: 9m42s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-20 08:11:27 Duration: 6m26s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-20 11:11:26 Duration: 6m24s Database: rio User: intelifix Remote: [local] Application: psql
3 1m29s 1m42s 1m35s 2 3m11s 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 20 20 1 1m29s 1m29s 23 1 1m42s 1m42s [ User: intelifix - Total duration: 3m11s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 3m11s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-20 23:43:52 Duration: 1m42s 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-20 20:08:35 Duration: 1m29s Database: rio User: intelifix Remote: [local] Application: pg_dump
4 26s74ms 2m2s 1m14s 2 2m28s 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 20 23 2 2m28s 1m14s [ User: intelifix - Total duration: 2m28s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m28s - 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-20 23:15:10 Duration: 2m2s 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-20 23:45:35 Duration: 26s74ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
5 1m 1m1s 1m1s 2 2m2s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 20 20 1 1m 1m 23 1 1m1s 1m1s [ User: intelifix - Total duration: 2m2s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m2s - Times executed: 2 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-20 23:19:44 Duration: 1m1s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-20 20:05:27 Duration: 1m Database: rio User: intelifix Remote: [local] Application: pg_dump
6 22s996ms 1m38s 1m 2 2m1s 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 20 23 2 2m1s 1m [ User: intelifix - Total duration: 2m1s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m1s - 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-20 23:11:43 Duration: 1m38s 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-20 23:44:46 Duration: 22s996ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
7 22s864ms 1m24s 53s757ms 2 1m47s 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 20 23 2 1m47s 53s757ms [ User: intelifix - Total duration: 1m47s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m47s - 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-20 23:13:08 Duration: 1m24s 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-20 23:45:09 Duration: 22s864ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
8 17s673ms 1m8s 42s958ms 2 1m25s 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 20 23 2 1m25s 42s958ms [ User: intelifix - Total duration: 1m25s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m25s - 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-20 23:16:18 Duration: 1m8s 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-20 23:45:52 Duration: 17s673ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
9 18s749ms 19s611ms 19s180ms 2 38s361ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 20 20 1 18s749ms 18s749ms 23 1 19s611ms 19s611ms [ User: intelifix - Total duration: 38s361ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 38s361ms - Times executed: 2 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-06-20 23:18:42 Duration: 19s611ms 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-20 20:04:26 Duration: 18s749ms Database: rio User: intelifix Remote: [local] Application: pg_dump
10 416ms 1m10s 17s807ms 32 9m29s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 20 07 2 1m12s 36s288ms 08 2 35s883ms 17s941ms 09 2 28s360ms 14s180ms 10 2 33s455ms 16s727ms 11 2 34s783ms 17s391ms 12 2 29s979ms 14s989ms 13 2 29s123ms 14s561ms 14 2 29s174ms 14s587ms 15 2 30s686ms 15s343ms 16 2 28s985ms 14s492ms 17 2 28s957ms 14s478ms 18 2 34s479ms 17s239ms 19 2 29s137ms 14s568ms 20 2 1m3s 31s804ms 21 2 30s333ms 15s166ms 22 2 30s318ms 15s159ms [ User: intelifix - Total duration: 9m29s - Times executed: 32 ]
[ Application: psql - Total duration: 9m29s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-20 07:15:54 Duration: 1m10s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-20 20:12:21 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-20 08:12:03 Duration: 35s358ms Database: rio User: intelifix Remote: [local] Application: psql
11 2s819ms 33s586ms 17s180ms 4 1m8s 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 20 20 2 32s315ms 16s157ms 23 2 36s406ms 18s203ms [ User: intelifix - Total duration: 1m8s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m8s - 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-20 23:20:19 Duration: 33s586ms 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-20 20:05:58 Duration: 29s460ms 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-20 20:09:22 Duration: 2s855ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
12 1s698ms 28s186ms 14s946ms 4 59s786ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 20 20 2 29s902ms 14s951ms 23 2 29s884ms 14s942ms [ User: intelifix - Total duration: 59s786ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 59s786ms - Times executed: 4 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-06-20 23:20:51 Duration: 28s186ms 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-20 20:06:29 Duration: 27s823ms 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-20 20:09:24 Duration: 2s78ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
13 2s913ms 26s33ms 14s380ms 4 57s520ms 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 20 20 2 28s574ms 14s287ms 23 2 28s946ms 14s473ms [ User: intelifix - Total duration: 57s520ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 57s520ms - 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-20 23:44:18 Duration: 26s33ms 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-20 20:09:01 Duration: 25s496ms 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-20 20:09:32 Duration: 3s78ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
14 8s768ms 19s83ms 13s839ms 4 55s357ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 20 00 2 37s505ms 18s752ms 06 2 17s852ms 8s926ms [ User: intelifix - Total duration: 55s357ms - Times executed: 4 ]
[ Application: psql - Total duration: 55s357ms - Times executed: 4 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-20 00:05:21 Duration: 19s83ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-20 00:05:39 Duration: 18s422ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-20 06:05:10 Duration: 9s83ms Database: rio User: intelifix Remote: [local] Application: psql
15 1s451ms 23s266ms 12s653ms 4 50s612ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 20 00 2 24s717ms 12s358ms 06 2 25s895ms 12s947ms [ User: lenon - Total duration: 50s612ms - Times executed: 4 ]
[ Application: psql - Total duration: 50s612ms - Times executed: 4 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-06-20 00:02:25 Duration: 23s266ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-06-20 06:02:23 Duration: 21s972ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-06-20 06:02:28 Duration: 3s922ms Database: contagem User: lenon Remote: [local] Application: psql
16 1s396ms 22s254ms 11s278ms 4 45s112ms 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 20 20 2 21s277ms 10s638ms 23 2 23s835ms 11s917ms [ User: intelifix - Total duration: 45s112ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 45s112ms - 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-20 23:18:23 Duration: 22s254ms 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-20 20:04:07 Duration: 19s881ms 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-20 23:46:06 Duration: 1s580ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
17 1s700ms 19s251ms 10s442ms 4 41s771ms 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 20 20 2 20s952ms 10s476ms 23 2 20s819ms 10s409ms [ User: intelifix - Total duration: 41s771ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 41s771ms - Times executed: 4 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-20 20:02:45 Duration: 19s251ms 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-20 23:16:59 Duration: 19s40ms 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-20 23:45:59 Duration: 1s778ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
18 1s498ms 19s332ms 10s81ms 4 40s327ms 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 20 20 2 20s859ms 10s429ms 23 2 19s467ms 9s733ms [ User: intelifix - Total duration: 40s327ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 40s327ms - Times executed: 4 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-20 20:03:19 Duration: 19s332ms 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-20 23:17:31 Duration: 17s969ms 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-20 20:09:14 Duration: 1s526ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
19 930ms 14s673ms 7s573ms 4 30s294ms 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 20 20 2 15s703ms 7s851ms 23 2 14s590ms 7s295ms [ User: intelifix - Total duration: 30s294ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 30s294ms - 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-20 20:02:59 Duration: 14s673ms 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-20 23:17:13 Duration: 13s659ms 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-20 20:09:13 Duration: 1s29ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
20 1s518ms 12s718ms 7s68ms 4 28s272ms 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 20 20 2 14s33ms 7s16ms 23 2 14s239ms 7s119ms [ User: intelifix - Total duration: 28s272ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 28s272ms - 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-20 23:17:43 Duration: 12s718ms 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-20 20:03:31 Duration: 12s514ms 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-20 23:46:03 Duration: 1s521ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 3 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jun 20 14 2 0ms 0ms 21 1 0ms 0ms [ User: intelifix - Total duration: 8s362ms - Times executed: 3 ]
[ Application: psql - Total duration: 8s362ms - Times executed: 3 ]
-
;
Date: Duration: 0ms Database: postgres User: rio Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 5,816 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 18 FATAL entries
- 1868 ERROR entries
- 0 WARNING entries
- 1 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 1,410 Max number of times the same event was reported
- 1,887 Total events found
Rank Times reported Error 1 1,410 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jun 20 00 59 01 58 02 57 03 55 04 59 05 60 06 59 07 60 08 59 09 60 10 59 11 60 12 60 13 59 14 60 15 59 16 60 17 59 18 60 19 60 20 59 21 60 22 59 23 50 - ERROR: prepared statement "_PLAN0000000029E8A8A0" does not exist
- ERROR: prepared statement "_PLAN0000000029E75650" does not exist
- ERROR: prepared statement "_PLAN0000000029E78D10" does not exist
Statement: DEALLOCATE "_PLAN0000000029E8A8A0"
Date: 2026-06-20 00:00:56 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029E75650"
Date: 2026-06-20 00:01:56 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029E78D10"
Date: 2026-06-20 00:02:57 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 138 ERROR: procedure rs_giga_processa_arquivos() does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Jun 20 00 6 01 6 02 6 03 6 04 6 05 6 06 6 07 6 08 6 09 6 10 6 11 6 12 6 13 6 14 6 15 6 16 6 17 6 18 6 19 6 20 6 21 6 22 6 - ERROR: procedure rs_giga_processa_arquivos() does not exist at character 6
- ERROR: procedure rs_giga_processa_arquivos() does not exist at character 6
- ERROR: procedure rs_giga_processa_arquivos() does not exist at character 6
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_PROCESSA_ARQUIVOS()Date: 2026-06-20 00:05:29 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-20 00:15:04 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_PROCESSA_ARQUIVOS()Date: 2026-06-20 00:25:07 Database: brasilia Application: psql User: intelifix Remote: [local]
3 138 ERROR: procedure rs_giga_triagem(...) does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count Jun 20 00 6 01 6 02 6 03 6 04 6 05 6 06 6 07 6 08 6 09 6 10 6 11 6 12 6 13 6 14 6 15 6 16 6 17 6 18 6 19 6 20 6 21 6 22 6 - ERROR: procedure rs_giga_triagem(unknown) does not exist at character 6
- ERROR: procedure rs_giga_triagem(unknown) does not exist at character 6
- ERROR: procedure rs_giga_triagem(unknown) does not exist at character 6
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-06-20 00:05:29 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-20 00:15:04 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-06-20 00:25:07 Database: brasilia Application: psql User: intelifix Remote: [local]
4 46 ERROR: procedure rs_giga_tecnicos() does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Jun 20 00 2 01 2 02 2 03 2 04 2 05 2 06 2 07 2 08 2 09 2 10 2 11 2 12 2 13 2 14 2 15 2 16 2 17 2 18 2 19 2 20 2 21 2 22 2 - ERROR: procedure rs_giga_tecnicos() does not exist at character 6
- ERROR: procedure rs_giga_tecnicos() does not exist at character 6
- ERROR: procedure rs_giga_tecnicos() does not exist at character 6
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-06-20 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-20 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-20 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
5 45 ERROR: procedure rs_tcia_processa_lotes() does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Jun 20 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-20 08:00:33 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-20 08:20:09 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-20 08:40:06 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 20 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-20 08:00:33 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-20 08:20:09 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Character with value 0x09 must be escaped.
Context: JSON data, line 46083: "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-20 08:40:06 Database: rio Application: psql User: intelifix Remote: [local]
7 16 ERROR: function rs_smart_fiscal_entrada() does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Jun 20 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-20 07:15:54 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-20 08:12:03 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-20 09:11:05 Database: brasilia Application: psql User: intelifix Remote: [local]
8 16 ERROR: function rs_smart_fiscal_saida() does not exist
Times Reported Most Frequent Error / Event #8
Day Hour Count Jun 20 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-20 07:15:54 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-20 08:12:03 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-20 09:11:05 Database: brasilia Application: psql User: intelifix Remote: [local]
9 8 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #9
Day Hour Count Jun 20 03 8 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-06-20 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-06-20 03:05:01 Database: rio Application: [unknown] User: lenon Remote: [local]
Context: PL/pgSQL function rs_giga_tecnicos() line 33 at IF
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-06-20 03:05:01 Database: rio Application: psql User: intelifix Remote: [local]
10 8 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #10
Day Hour Count Jun 20 00 1 02 1 03 3 06 1 12 1 15 1 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-06-20 00:02:26 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-06-20 02:53:34 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-20 03:43:52 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 20 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-20 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-20 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-20 05:30:02 Database: brasilia Application: postgres_fdw User: lenon Remote: 127.0.0.1
12 2 ERROR: procedure rs_atualiza_estoque_automatico() does not exist
Times Reported Most Frequent Error / Event #12
Day Hour Count Jun 20 00 1 06 1 - ERROR: procedure rs_atualiza_estoque_automatico() does not exist at character 6
- ERROR: procedure rs_atualiza_estoque_automatico() does not exist at character 6
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO()Date: 2026-06-20 00:05:21 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO()Date: 2026-06-20 06:05:10 Database: brasilia Application: psql User: intelifix Remote: [local]
13 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #13
Day Hour Count Jun 20 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-06-20 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-20 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
14 2 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #14
Day Hour Count Jun 20 01 2 - ERROR: syntax error at or near "836043907002992" at character 32
- ERROR: syntax error at or near "241730244647" at character 32
Statement: SELECT RS_SERIAL_TEMPORARIO( ''836043907002992' ) OR RS_SERIAL_TEMPORARIO_VIVO( ''836043907002992' )
Date: 2026-06-20 01:10:39 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT RS_SERIAL_TEMPORARIO( ''241730244647' ) OR RS_SERIAL_TEMPORARIO_VIVO( ''241730244647' )
Date: 2026-06-20 01:10:47 Database: rio Application: [unknown] User: intelifix Remote: [local]
15 1 ERROR: function rs_lote_entrada_fechar_automatico() does not exist
Times Reported Most Frequent Error / Event #15
Day Hour Count Jun 20 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-20 18:00:01 Database: brasilia Application: psql User: intelifix Remote: [local]
16 1 ERROR: function rs_del_temporario() does not exist
Times Reported Most Frequent Error / Event #16
Day Hour Count Jun 20 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-20 21:25:01 Database: brasilia Application: psql User: intelifix Remote: [local]
17 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #17
Day Hour Count Jun 20 03 1 - LOG: database system was shut down at 2026-06-20 03:05:01 -03
Date: 2026-06-20 03:05:02