pgBadger-
Global information
- Generated on Sun Jun 14 23:50:06 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 4,714 log entries in 4s
- Log start from 2026-06-14 00:02:02 to 2026-06-14 23:46:05
-
Overview
Global Stats
- 135 Number of unique normalized queries
- 505 Number of queries
- 2h49m45s Total query duration
- 2026-06-14 00:02:13 First query
- 2026-06-14 23:46:05 Last query
- 3 queries/s at 2026-06-14 23:45:27 Query peak
- 2h49m45s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 2h49m45s Execute total duration
- 469 Number of events
- 15 Number of unique normalized events
- 138 Max number of times the same event was reported
- 0 Number of cancellation
- 5 Total number of automatic vacuums
- 0 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 136 Total number of sessions
- 7 sessions at 2026-06-14 07:02:02 Session peak
- 4d22h8m26s Total duration of sessions
- 52m7s Average duration of sessions
- 3 Average queries per session
- 1m14s Average queries duration per session
- 50m52s Average idle time per session
- 142 Total number of connections
- 5 connections/s at 2026-06-14 03:05:16 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 3 queries/s Query Peak
- 2026-06-14 23:45:27 Date
SELECT Traffic
Key values
- 2 queries/s Query Peak
- 2026-06-14 21:11:12 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 3 queries/s Query Peak
- 2026-06-14 23:45:27 Date
Queries duration
Key values
- 2h49m45s 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 14 00 13 0ms 21s876ms 6s599ms 58s445ms 58s445ms 58s445ms 01 6 0ms 3s423ms 2s986ms 3s423ms 3s423ms 3s423ms 02 6 2s625ms 3s43ms 2s792ms 3s43ms 3s43ms 3s43ms 03 7 0ms 3s442ms 2s797ms 3s798ms 3s798ms 3s798ms 04 6 0ms 3s137ms 2s826ms 3s137ms 3s137ms 3s137ms 05 9 0ms 9m 1m18s 2m26s 9m1s 9m1s 06 10 0ms 11s894ms 5s277ms 23s328ms 23s328ms 23s328ms 07 10 0ms 14m9s 1m38s 1m55s 14m9s 14m9s 08 10 0ms 5m49s 39s888ms 31s400ms 5m49s 5m49s 09 10 0ms 5m39s 39s181ms 32s227ms 5m39s 5m39s 10 10 0ms 5m43s 39s260ms 31s78ms 5m43s 5m43s 11 10 0ms 5m29s 37s755ms 3s421ms 5m58s 5m58s 12 10 0ms 5m15s 36s310ms 3s548ms 5m46s 5m46s 13 10 0ms 5m23s 36s821ms 5m51s 5m51s 5m51s 14 10 0ms 5m15s 36s421ms 3s238ms 5m46s 5m46s 15 10 0ms 5m23s 36s891ms 5m52s 5m52s 5m52s 16 10 0ms 5m9s 35s516ms 5m39s 5m39s 5m39s 17 10 0ms 5m15s 35s971ms 5m44s 5m44s 5m44s 18 12 0ms 5m16s 30s644ms 3s156ms 5m48s 5m48s 19 10 0ms 5m24s 37s180ms 5m53s 5m53s 5m53s 20 66 0ms 5m35s 13s391ms 2m20s 6m 6m 21 11 0ms 5m41s 35s325ms 30s22ms 5m41s 5m41s 22 10 0ms 5m31s 37s820ms 29s23ms 5m31s 5m31s 23 229 0ms 2m6s 9s406ms 1m24s 2m6s 2m25s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 14 00 2 0 6s527ms 0ms 13s55ms 13s55ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 2 0 7s17ms 0ms 14s34ms 14s34ms 07 4 0 4m1s 0ms 1m55s 14m9s 08 4 0 1m35s 0ms 31s400ms 5m49s 09 4 0 1m33s 0ms 32s227ms 5m39s 10 4 0 1m33s 0ms 31s78ms 5m43s 11 4 0 1m30s 0ms 1s677ms 5m58s 12 4 0 1m26s 0ms 0ms 5m46s 13 4 0 1m27s 0ms 5m51s 5m51s 14 4 0 1m26s 0ms 0ms 5m46s 15 4 0 1m28s 0ms 5m52s 5m52s 16 4 0 1m24s 0ms 5m39s 5m39s 17 4 0 1m26s 0ms 5m44s 5m44s 18 6 0 58s413ms 0ms 2s360ms 5m48s 19 4 0 1m28s 0ms 5m53s 5m53s 20 8 51 14s683ms 1m5s 2m20s 5m35s 21 5 0 1m14s 227ms 30s22ms 5m41s 22 4 0 1m30s 0ms 29s23ms 5m31s 23 9 220 9s406ms 1m9s 1m24s 2m24s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 14 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 14 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Jun 14 00 12 0.00/s 01 4 0.00/s 02 4 0.00/s 03 11 0.00/s 04 4 0.00/s 05 8 0.00/s 06 12 0.00/s 07 5 0.00/s 08 4 0.00/s 09 6 0.00/s 10 4 0.00/s 11 6 0.00/s 12 5 0.00/s 13 6 0.00/s 14 6 0.00/s 15 5 0.00/s 16 5 0.00/s 17 5 0.00/s 18 5 0.00/s 19 5 0.00/s 20 8 0.00/s 21 5 0.00/s 22 4 0.00/s 23 3 0.00/s Day Hour Count Average Duration Average idle time Jun 14 00 1 10m 8m35s 01 10 1h1m12s 1h1m10s 02 4 1h1s 59m57s 03 9 22m4s 22m2s 04 5 1h1m12s 1h1m8s 05 5 50m 47m38s 06 6 57m30s 57m22s 07 11 1h1m22s 59m52s 08 5 56m36s 55m16s 09 5 50m 48m41s 10 5 56m 54m41s 11 4 1h1m23s 59m48s 12 4 1h2m 1h29s 13 6 51m40s 50m39s 14 6 52m10s 51m10s 15 6 51m40s 50m38s 16 4 1h 58m31s 17 6 51m40s 50m40s 18 4 1h1m19s 59m47s 19 5 1h 58m46s 20 8 39m37s 37m47s 21 6 51m41s 50m36s 22 4 52m30s 50m55s 23 7 39m52s 34m44s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-06-14 03:05:16 Date
Connections per database
Key values
- rio Main Database
- 142 connections Total
Connections per user
Key values
- intelifix Main User
- 142 connections Total
-
Sessions
Simultaneous sessions
Key values
- 7 sessions Session Peak
- 2026-06-14 07:02:02 Date
Histogram of session times
Key values
- 109 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 136 sessions Total
Sessions per user
Key values
- intelifix Main User
- 136 sessions Total
Sessions per host
Key values
- [local] Main Host
- 136 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 5,647 buffers Checkpoint Peak
- 2026-06-14 00:09:52 Date
- 269.614 seconds Highest write time
- 0.007 seconds Sync time
Checkpoints Wal files
Key values
- 3 files Wal files usage Peak
- 2026-06-14 03:05:01 Date
Checkpoints distance
Key values
- 69.15 Mo Distance Peak
- 2026-06-14 03:05:01 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jun 14 00 5,647 269.614s 0.002s 269.622s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 5,612 0.343s 0.005s 0.359s 04 0 0s 0s 0s 05 4,684 469.466s 0.01s 469.494s 06 2,369 237.088s 0.002s 237.094s 07 715 71.64s 0.009s 71.666s 08 21 2.134s 0.003s 2.142s 09 21 2.128s 0.003s 2.136s 10 21 2.134s 0.007s 2.147s 11 21 2.133s 0.004s 2.142s 12 21 2.13s 0.003s 2.138s 13 21 2.129s 0.002s 2.136s 14 20 2.029s 0.003s 2.037s 15 21 2.13s 0.003s 2.138s 16 22 2.252s 0.005s 2.271s 17 21 2.13s 0.002s 2.137s 18 987 98.805s 0.007s 98.827s 19 21 2.132s 0.003s 2.139s 20 262 33.944s 0.01s 33.97s 21 21 2.131s 0.004s 2.139s 22 20 2.037s 0.003s 2.046s 23 154 15.485s 0.003s 15.495s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jun 14 00 0 0 1 21 0.001s 0.001s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 3 20 0.002s 0.002s 04 0 0 0 0 0s 0s 05 0 0 2 96 0.002s 0.004s 06 0 0 0 9 0.001s 0.001s 07 0 0 0 16 0.002s 0.005s 08 0 0 0 3 0.002s 0.001s 09 0 0 0 3 0.002s 0.001s 10 0 0 0 3 0.004s 0.003s 11 0 0 0 3 0.002s 0.002s 12 0 0 0 3 0.002s 0.001s 13 0 0 0 3 0.002s 0.001s 14 0 0 0 3 0.002s 0.001s 15 0 0 0 3 0.002s 0.001s 16 0 0 0 5 0.002s 0.002s 17 0 0 0 3 0.002s 0.001s 18 0 0 0 54 0.002s 0.004s 19 0 0 0 3 0.002s 0.001s 20 0 0 1 16 0.004s 0.003s 21 0 0 0 3 0.002s 0.002s 22 0 0 0 3 0.002s 0.001s 23 0 0 0 3 0.002s 0.003s Day Hour Count Avg time (sec) Jun 14 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 14 00 31,189.00 kB 31,189.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 17,702.00 kB 17,702.00 kB 04 0.00 kB 0.00 kB 05 8,235.50 kB 10,822.50 kB 06 4,753.00 kB 15,617.00 kB 07 1,158.00 kB 12,473.00 kB 08 166.00 kB 9,546.00 kB 09 166.00 kB 8,608.00 kB 10 166.00 kB 7,764.00 kB 11 166.00 kB 7,004.00 kB 12 165.00 kB 6,320.00 kB 13 165.00 kB 5,705.00 kB 14 165.00 kB 5,151.00 kB 15 166.00 kB 4,652.00 kB 16 84.50 kB 3,987.00 kB 17 166.00 kB 3,423.00 kB 18 813.75 kB 2,909.00 kB 19 166.00 kB 2,259.00 kB 20 223.33 kB 1,872.00 kB 21 165.00 kB 1,555.00 kB 22 165.00 kB 1,416.00 kB 23 330.50 kB 1,268.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 14 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.20 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database rio - 2026-06-14 05:09:39 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 0.20 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database rio - 2026-06-14 05:09:39 Date
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- pg_catalog.pg_statistic (1) Main table vacuumed on database contagem
- 5 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_catalog.pg_statistic 1 1 0 0 0 0 0 2,230 101 469,540 88 783 rio.pg_catalog.pg_statistic 1 1 0 0 0 0 0 3,100 369 1,788,429 347 2,231 rio.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 772 144 893,787 95 338 brasilia.pg_catalog.pg_statistic 1 1 0 0 0 0 0 80 2 7,536 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 140 26 91,849 0 0 Total 5 5 0 0 0 0 0 6,322 642 3,251,141 530 3,352 Vacuum throughput per table
Key values
- pg_catalog.pg_statistic (0.2) 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 (4677) Main table with removed tuples on database rio
- 9889 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_statistic 1 1 4,677 7,458 0 0 1,286 contagem.pg_catalog.pg_statistic 1 1 4,358 7,274 0 0 1,011 rio.pg_toast.pg_toast_2619 1 1 569 680 0 0 263 brasilia.pg_catalog.pg_statistic 1 1 180 449 0 0 36 contagem.pg_toast.pg_toast_2619 1 1 105 115 0 13 45 Total 5 5 9,889 15,976 0 13 2,641 Pages removed per table
Key values
- pg_toast.pg_toast_2619 (13) Main table with removed pages on database contagem
- 13 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jun 14 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 5 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 - 0.20 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
- 84 Total read queries
- 271 Total write queries
Queries by database
Key values
- rio Main database
- 336 Requests
- 2h43m16s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 501 Requests
User Request type Count Duration intelifix Total 501 2h49m18s copy to 271 44m6s others 150 19m28s select 80 1h45m43s lenon Total 4 27s90ms select 4 27s90ms Duration by user
Key values
- 2h49m18s (intelifix) Main time consuming user
User Request type Count Duration intelifix Total 501 2h49m18s copy to 271 44m6s others 150 19m28s select 80 1h45m43s lenon Total 4 27s90ms select 4 27s90ms Queries by host
Key values
- [local] Main host
- 505 Requests
- 2h49m45s ([local])
- Main time consuming host
Queries by application
Key values
- pg_dump Main application
- 284 Requests
- 2h5m35s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-06-14 15:15:16 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 196 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 14m9s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-14 07:19:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 9m analyze verbose;[ Date: 2026-06-14 05:09:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 5m49s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-14 08:10:50 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 5m43s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-14 10:10:45 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 5m41s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-14 21:10:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 5m39s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-14 09:10:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 5m35s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-14 20:10:36 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 5m31s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-14 22:10:33 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 5m29s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-14 11:10:30 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 5m24s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-14 19:10:25 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 5m23s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-14 15:10:25 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m23s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-14 13:10:24 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 5m16s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-14 18:10:18 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m15s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-14 14:10:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m15s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-14 12:10:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m15s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-14 17:10:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m9s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-14 16:10:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 2m26s analyze verbose;[ Date: 2026-06-14 05:11:29 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
19 2m6s 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-14 23:15:27 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
20 1m51s 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-14 23:11:56 - 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 1h36m24s 32 923ms 14m9s 3m select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 14 07 2 14m13s 7m6s 08 2 5m50s 2m55s 09 2 5m40s 2m50s 10 2 5m44s 2m52s 11 2 5m30s 2m45s 12 2 5m16s 2m38s 13 2 5m24s 2m42s 14 2 5m16s 2m38s 15 2 5m25s 2m42s 16 2 5m11s 2m35s 17 2 5m16s 2m38s 18 2 5m17s 2m38s 19 2 5m25s 2m42s 20 2 5m36s 2m48s 21 2 5m42s 2m51s 22 2 5m32s 2m46s [ User: intelifix - Total duration: 1h36m24s - Times executed: 32 ]
[ Application: psql - Total duration: 1h36m24s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-14 07:19:10 Duration: 14m9s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-14 08:10:50 Duration: 5m49s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-14 10:10:45 Duration: 5m43s Database: rio User: intelifix Remote: [local] Application: psql
2 11m27s 3 715ms 9m 3m49s analyze verbose;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 14 05 3 11m27s 3m49s [ User: intelifix - Total duration: 11m27s - Times executed: 3 ]
[ Application: psql - Total duration: 11m27s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-06-14 05:09:01 Duration: 9m Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-14 05:11:29 Duration: 2m26s Database: contagem User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-14 05:09:02 Duration: 715ms Database: brasilia User: intelifix Remote: [local] Application: psql
3 9m13s 32 438ms 1m49s 17s284ms select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 14 07 2 1m51s 55s934ms 08 2 30s277ms 15s138ms 09 2 31s260ms 15s630ms 10 2 29s876ms 14s938ms 11 2 29s414ms 14s707ms 12 2 29s927ms 14s963ms 13 2 27s830ms 13s915ms 14 2 30s399ms 15s199ms 15 2 26s871ms 13s435ms 16 2 28s315ms 14s157ms 17 2 27s619ms 13s809ms 18 2 30s305ms 15s152ms 19 2 28s484ms 14s242ms 20 2 33s744ms 16s872ms 21 2 28s794ms 14s397ms 22 2 28s100ms 14s50ms [ User: intelifix - Total duration: 9m13s - Times executed: 32 ]
[ Application: psql - Total duration: 9m13s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-14 07:21:00 Duration: 1m49s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-14 20:11:09 Duration: 32s908ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-14 09:11:11 Duration: 30s821ms Database: rio User: intelifix Remote: [local] Application: psql
4 6m57s 138 2s271ms 16s842ms 3s26ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 14 00 6 31s129ms 5s188ms 01 6 17s918ms 2s986ms 02 6 16s756ms 2s792ms 03 6 19s104ms 3s184ms 04 6 16s959ms 2s826ms 05 6 19s964ms 3s327ms 06 6 18s448ms 3s74ms 07 6 18s416ms 3s69ms 08 6 18s203ms 3s33ms 09 6 19s753ms 3s292ms 10 6 17s845ms 2s974ms 11 6 17s290ms 2s881ms 12 6 16s712ms 2s785ms 13 6 16s275ms 2s712ms 14 6 17s352ms 2s892ms 15 6 16s905ms 2s817ms 16 6 15s816ms 2s636ms 17 6 15s616ms 2s602ms 18 6 17s246ms 2s874ms 19 6 17s948ms 2s991ms 20 6 17s44ms 2s840ms 21 6 16s950ms 2s825ms 22 6 17s946ms 2s991ms [ User: intelifix - Total duration: 6m57s - Times executed: 138 ]
[ Application: psql - Total duration: 6m57s - Times executed: 138 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-14 00:05:18 Duration: 16s842ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-14 05:05:07 Duration: 5s703ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-14 10:05:05 Duration: 3s851ms Database: rio User: intelifix Remote: [local] Application: psql
5 3m24s 2 1m36s 1m47s 1m42s 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 14 20 1 1m47s 1m47s 23 1 1m36s 1m36s [ User: intelifix - Total duration: 3m24s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 3m24s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-14 20:09:22 Duration: 1m47s 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-14 23:43:06 Duration: 1m36s Database: rio User: intelifix Remote: [local] Application: pg_dump
6 2m32s 2 25s717ms 2m6s 1m16s 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 14 23 2 2m32s 1m16s [ User: intelifix - Total duration: 2m32s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m32s - 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-14 23:15:27 Duration: 2m6s 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-14 23:44:47 Duration: 25s717ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
7 2m14s 2 23s145ms 1m51s 1m7s copy auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 14 23 2 2m14s 1m7s [ User: intelifix - Total duration: 2m14s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m14s - Times executed: 2 ]
-
COPY auditor.auditor_2026_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-14 23:11:56 Duration: 1m51s 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-14 23:43:59 Duration: 23s145ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
8 2m5s 2 1m1s 1m3s 1m2s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 14 20 1 1m3s 1m3s 23 1 1m1s 1m1s [ User: intelifix - Total duration: 2m5s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m5s - Times executed: 2 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-14 20:05:37 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-14 23:19:51 Duration: 1m1s Database: rio User: intelifix Remote: [local] Application: pg_dump
9 1m46s 2 22s99ms 1m24s 53s498ms 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 14 23 2 1m46s 53s498ms [ User: intelifix - Total duration: 1m46s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m46s - 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-14 23:13:20 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-14 23:44:21 Duration: 22s99ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
10 1m10s 4 2s291ms 33s468ms 17s732ms copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 14 20 2 35s170ms 17s585ms 23 2 35s760ms 17s880ms [ User: intelifix - Total duration: 1m10s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m10s - 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-14 23:20:26 Duration: 33s468ms 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-14 20:06:12 Duration: 32s829ms 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-14 20:10:11 Duration: 2s340ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
11 1m8s 2 12s714ms 55s455ms 34s85ms copy auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 14 23 2 1m8s 34s85ms [ User: intelifix - Total duration: 1m8s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m8s - 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-14 23:16:22 Duration: 55s455ms 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-14 23:45:00 Duration: 12s714ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
12 1m3s 4 1s637ms 31s160ms 15s967ms 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 14 20 2 33s435ms 16s717ms 23 2 30s432ms 15s216ms [ User: intelifix - Total duration: 1m3s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m3s - Times executed: 4 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-06-14 20:06:48 Duration: 31s160ms 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-14 23:20:58 Duration: 28s794ms 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-14 20:10:14 Duration: 2s274ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
13 1m 4 8s400ms 21s876ms 15s162ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 14 00 2 40s356ms 20s178ms 06 2 20s294ms 10s147ms [ User: intelifix - Total duration: 1m - Times executed: 4 ]
[ Application: psql - Total duration: 1m - Times executed: 4 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-14 00:05:23 Duration: 21s876ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-14 00:05:41 Duration: 18s480ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-14 06:05:12 Duration: 11s894ms Database: rio User: intelifix Remote: [local] Application: psql
14 59s466ms 4 3s198ms 28s324ms 14s866ms 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 14 20 2 31s523ms 15s761ms 23 2 27s943ms 13s971ms [ User: intelifix - Total duration: 59s466ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 59s466ms - 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-14 20:09:50 Duration: 28s324ms 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-14 23:43:31 Duration: 24s682ms 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-14 23:46:03 Duration: 3s261ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
15 45s540ms 4 1s319ms 22s356ms 11s385ms copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 14 20 2 23s880ms 11s940ms 23 2 21s659ms 10s829ms [ User: intelifix - Total duration: 45s540ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 45s540ms - 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-14 20:04:14 Duration: 22s356ms 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-14 23:18:31 Duration: 20s340ms 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-14 20:10:09 Duration: 1s523ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
16 44s899ms 4 1s772ms 20s401ms 11s224ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 14 20 2 22s173ms 11s86ms 23 2 22s725ms 11s362ms [ User: intelifix - Total duration: 44s899ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 44s899ms - Times executed: 4 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-14 20:02:47 Duration: 20s401ms 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-14 23:17:04 Duration: 20s90ms 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-14 23:45:08 Duration: 2s634ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
17 42s159ms 4 1s558ms 19s548ms 10s539ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 14 20 2 20s988ms 10s494ms 23 2 21s171ms 10s585ms [ User: intelifix - Total duration: 42s159ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 42s159ms - Times executed: 4 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-14 23:17:38 Duration: 19s548ms 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-14 20:03:20 Duration: 19s429ms 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-14 23:45:11 Duration: 1s623ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
18 36s792ms 2 17s992ms 18s799ms 18s396ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 14 20 1 18s799ms 18s799ms 23 1 17s992ms 17s992ms [ User: intelifix - Total duration: 36s792ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 36s792ms - Times executed: 2 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-06-14 20:04:33 Duration: 18s799ms 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-14 23:18:49 Duration: 17s992ms Database: rio User: intelifix Remote: [local] Application: pg_dump
19 32s179ms 4 1s420ms 14s493ms 8s44ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 14 20 2 16s265ms 8s132ms 23 2 15s914ms 7s957ms [ User: intelifix - Total duration: 32s179ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 32s179ms - 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-14 23:17:53 Duration: 14s493ms 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-14 20:03:34 Duration: 14s277ms 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-14 20:10:06 Duration: 1s988ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
20 30s51ms 4 846ms 14s784ms 7s512ms copy public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 14 20 2 14s420ms 7s210ms 23 2 15s631ms 7s815ms [ User: intelifix - Total duration: 30s51ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 30s51ms - 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-14 23:17:18 Duration: 14s784ms 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-14 20:03:01 Duration: 13s488ms 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-14 20:10:02 Duration: 931ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 138 6m57s 2s271ms 16s842ms 3s26ms call rs_giga_triagem (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 14 00 6 31s129ms 5s188ms 01 6 17s918ms 2s986ms 02 6 16s756ms 2s792ms 03 6 19s104ms 3s184ms 04 6 16s959ms 2s826ms 05 6 19s964ms 3s327ms 06 6 18s448ms 3s74ms 07 6 18s416ms 3s69ms 08 6 18s203ms 3s33ms 09 6 19s753ms 3s292ms 10 6 17s845ms 2s974ms 11 6 17s290ms 2s881ms 12 6 16s712ms 2s785ms 13 6 16s275ms 2s712ms 14 6 17s352ms 2s892ms 15 6 16s905ms 2s817ms 16 6 15s816ms 2s636ms 17 6 15s616ms 2s602ms 18 6 17s246ms 2s874ms 19 6 17s948ms 2s991ms 20 6 17s44ms 2s840ms 21 6 16s950ms 2s825ms 22 6 17s946ms 2s991ms [ User: intelifix - Total duration: 6m57s - Times executed: 138 ]
[ Application: psql - Total duration: 6m57s - Times executed: 138 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-14 00:05:18 Duration: 16s842ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-14 05:05:07 Duration: 5s703ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-14 10:05:05 Duration: 3s851ms Database: rio User: intelifix Remote: [local] Application: psql
2 32 1h36m24s 923ms 14m9s 3m select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 14 07 2 14m13s 7m6s 08 2 5m50s 2m55s 09 2 5m40s 2m50s 10 2 5m44s 2m52s 11 2 5m30s 2m45s 12 2 5m16s 2m38s 13 2 5m24s 2m42s 14 2 5m16s 2m38s 15 2 5m25s 2m42s 16 2 5m11s 2m35s 17 2 5m16s 2m38s 18 2 5m17s 2m38s 19 2 5m25s 2m42s 20 2 5m36s 2m48s 21 2 5m42s 2m51s 22 2 5m32s 2m46s [ User: intelifix - Total duration: 1h36m24s - Times executed: 32 ]
[ Application: psql - Total duration: 1h36m24s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-14 07:19:10 Duration: 14m9s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-14 08:10:50 Duration: 5m49s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-14 10:10:45 Duration: 5m43s Database: rio User: intelifix Remote: [local] Application: psql
3 32 9m13s 438ms 1m49s 17s284ms select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 14 07 2 1m51s 55s934ms 08 2 30s277ms 15s138ms 09 2 31s260ms 15s630ms 10 2 29s876ms 14s938ms 11 2 29s414ms 14s707ms 12 2 29s927ms 14s963ms 13 2 27s830ms 13s915ms 14 2 30s399ms 15s199ms 15 2 26s871ms 13s435ms 16 2 28s315ms 14s157ms 17 2 27s619ms 13s809ms 18 2 30s305ms 15s152ms 19 2 28s484ms 14s242ms 20 2 33s744ms 16s872ms 21 2 28s794ms 14s397ms 22 2 28s100ms 14s50ms [ User: intelifix - Total duration: 9m13s - Times executed: 32 ]
[ Application: psql - Total duration: 9m13s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-14 07:21:00 Duration: 1m49s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-14 20:11:09 Duration: 32s908ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-14 09:11:11 Duration: 30s821ms Database: rio User: intelifix Remote: [local] Application: psql
4 4 1m10s 2s291ms 33s468ms 17s732ms copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 14 20 2 35s170ms 17s585ms 23 2 35s760ms 17s880ms [ User: intelifix - Total duration: 1m10s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m10s - 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-14 23:20:26 Duration: 33s468ms 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-14 20:06:12 Duration: 32s829ms 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-14 20:10:11 Duration: 2s340ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
5 4 1m3s 1s637ms 31s160ms 15s967ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 14 20 2 33s435ms 16s717ms 23 2 30s432ms 15s216ms [ User: intelifix - Total duration: 1m3s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m3s - Times executed: 4 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-06-14 20:06:48 Duration: 31s160ms 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-14 23:20:58 Duration: 28s794ms 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-14 20:10:14 Duration: 2s274ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
6 4 1m 8s400ms 21s876ms 15s162ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 14 00 2 40s356ms 20s178ms 06 2 20s294ms 10s147ms [ User: intelifix - Total duration: 1m - Times executed: 4 ]
[ Application: psql - Total duration: 1m - Times executed: 4 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-14 00:05:23 Duration: 21s876ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-14 00:05:41 Duration: 18s480ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-14 06:05:12 Duration: 11s894ms Database: rio User: intelifix Remote: [local] Application: psql
7 4 59s466ms 3s198ms 28s324ms 14s866ms copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 14 20 2 31s523ms 15s761ms 23 2 27s943ms 13s971ms [ User: intelifix - Total duration: 59s466ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 59s466ms - 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-14 20:09:50 Duration: 28s324ms 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-14 23:43:31 Duration: 24s682ms 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-14 23:46:03 Duration: 3s261ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
8 4 45s540ms 1s319ms 22s356ms 11s385ms copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 14 20 2 23s880ms 11s940ms 23 2 21s659ms 10s829ms [ User: intelifix - Total duration: 45s540ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 45s540ms - 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-14 20:04:14 Duration: 22s356ms 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-14 23:18:31 Duration: 20s340ms 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-14 20:10:09 Duration: 1s523ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
9 4 44s899ms 1s772ms 20s401ms 11s224ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 14 20 2 22s173ms 11s86ms 23 2 22s725ms 11s362ms [ User: intelifix - Total duration: 44s899ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 44s899ms - Times executed: 4 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-14 20:02:47 Duration: 20s401ms 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-14 23:17:04 Duration: 20s90ms 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-14 23:45:08 Duration: 2s634ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
10 4 42s159ms 1s558ms 19s548ms 10s539ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 14 20 2 20s988ms 10s494ms 23 2 21s171ms 10s585ms [ User: intelifix - Total duration: 42s159ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 42s159ms - Times executed: 4 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-14 23:17:38 Duration: 19s548ms 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-14 20:03:20 Duration: 19s429ms 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-14 23:45:11 Duration: 1s623ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
11 4 32s179ms 1s420ms 14s493ms 8s44ms copy public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 14 20 2 16s265ms 8s132ms 23 2 15s914ms 7s957ms [ User: intelifix - Total duration: 32s179ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 32s179ms - 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-14 23:17:53 Duration: 14s493ms 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-14 20:03:34 Duration: 14s277ms 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-14 20:10:06 Duration: 1s988ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
12 4 30s51ms 846ms 14s784ms 7s512ms copy public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 14 20 2 14s420ms 7s210ms 23 2 15s631ms 7s815ms [ User: intelifix - Total duration: 30s51ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 30s51ms - 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-14 23:17:18 Duration: 14s784ms 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-14 20:03:01 Duration: 13s488ms 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-14 20:10:02 Duration: 931ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
13 4 27s95ms 3s422ms 10s160ms 6s773ms 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 #13
Day Hour Count Duration Avg duration Jun 14 20 2 14s297ms 7s148ms 23 2 12s797ms 6s398ms [ User: intelifix - Total duration: 27s95ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 27s95ms - 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-14 20:07:19 Duration: 10s160ms 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-14 23:41:16 Duration: 9s375ms 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-14 20:10:19 Duration: 4s137ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
14 4 27s90ms 1s167ms 11s888ms 6s772ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 14 00 2 13s55ms 6s527ms 06 2 14s34ms 7s17ms [ User: lenon - Total duration: 27s90ms - Times executed: 4 ]
[ Application: psql - Total duration: 27s90ms - Times executed: 4 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-06-14 00:02:13 Duration: 11s888ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-06-14 06:02:13 Duration: 11s548ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-06-14 06:02:15 Duration: 2s486ms Database: contagem User: lenon Remote: [local] Application: psql
15 4 26s494ms 729ms 12s907ms 6s623ms copy public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 14 20 2 12s857ms 6s428ms 23 2 13s636ms 6s818ms [ User: intelifix - Total duration: 26s494ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 26s494ms - Times executed: 4 ]
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-06-14 23:18:11 Duration: 12s907ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-06-14 20:03:52 Duration: 12s53ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-06-14 20:10:07 Duration: 803ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
16 4 25s517ms 913ms 12s307ms 6s379ms 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 #16
Day Hour Count Duration Avg duration Jun 14 20 2 13s220ms 6s610ms 23 2 12s297ms 6s148ms [ User: intelifix - Total duration: 25s517ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 25s517ms - 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-14 20:02:22 Duration: 12s307ms 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-14 23:16:40 Duration: 11s103ms 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-14 23:45:05 Duration: 1s193ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
17 4 11s917ms 2s720ms 3s327ms 2s979ms copy ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 14 20 2 6s47ms 3s23ms 23 2 5s869ms 2s934ms [ User: intelifix - Total duration: 11s917ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 11s917ms - Times executed: 4 ]
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-06-14 20:02:08 Duration: 3s327ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-06-14 23:16:27 Duration: 3s7ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-06-14 23:45:04 Duration: 2s862ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
18 4 11s719ms 490ms 5s392ms 2s929ms copy public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 14 20 2 5s917ms 2s958ms 23 2 5s802ms 2s901ms [ User: intelifix - Total duration: 11s719ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 11s719ms - Times executed: 4 ]
-
COPY public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) TO stdout;
Date: 2026-06-14 20:03:40 Duration: 5s392ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) TO stdout;
Date: 2026-06-14 23:17:58 Duration: 5s312ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) TO stdout;
Date: 2026-06-14 20:10:07 Duration: 524ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
19 4 4s997ms 1s93ms 1s536ms 1s249ms copy ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 14 20 2 2s747ms 1s373ms 23 2 2s249ms 1s124ms [ User: intelifix - Total duration: 4s997ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 4s997ms - Times executed: 4 ]
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-06-14 20:09:56 Duration: 1s536ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-06-14 20:02:05 Duration: 1s211ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-06-14 23:45:01 Duration: 1s155ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
20 4 3s396ms 156ms 1s761ms 849ms copy public.lote_caixas (cai_id, lot_id, cai_criacao, usu_id, mod_id, is_id, novo, qtd, cai_obs, cai_check, cai_check_data, cai_check_user, cai_check_mens) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 14 20 2 1s918ms 959ms 23 2 1s478ms 739ms [ User: intelifix - Total duration: 3s396ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3s396ms - Times executed: 4 ]
-
COPY public.lote_caixas (cai_id, lot_id, cai_criacao, usu_id, mod_id, is_id, novo, qtd, cai_obs, cai_check, cai_check_data, cai_check_user, cai_check_mens) TO stdout;
Date: 2026-06-14 20:05:39 Duration: 1s761ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_caixas (cai_id, lot_id, cai_criacao, usu_id, mod_id, is_id, novo, qtd, cai_obs, cai_check, cai_check_data, cai_check_user, cai_check_mens) TO stdout;
Date: 2026-06-14 23:19:52 Duration: 1s289ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_caixas (cai_id, lot_id, cai_criacao, usu_id, mod_id, is_id, novo, qtd, cai_obs, cai_check, cai_check_data, cai_check_user, cai_check_mens) TO stdout;
Date: 2026-06-14 23:45:15 Duration: 189ms 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 715ms 9m 3m49s 3 11m27s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 14 05 3 11m27s 3m49s [ User: intelifix - Total duration: 11m27s - Times executed: 3 ]
[ Application: psql - Total duration: 11m27s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-06-14 05:09:01 Duration: 9m Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-14 05:11:29 Duration: 2m26s Database: contagem User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-14 05:09:02 Duration: 715ms Database: brasilia User: intelifix Remote: [local] Application: psql
2 923ms 14m9s 3m 32 1h36m24s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 14 07 2 14m13s 7m6s 08 2 5m50s 2m55s 09 2 5m40s 2m50s 10 2 5m44s 2m52s 11 2 5m30s 2m45s 12 2 5m16s 2m38s 13 2 5m24s 2m42s 14 2 5m16s 2m38s 15 2 5m25s 2m42s 16 2 5m11s 2m35s 17 2 5m16s 2m38s 18 2 5m17s 2m38s 19 2 5m25s 2m42s 20 2 5m36s 2m48s 21 2 5m42s 2m51s 22 2 5m32s 2m46s [ User: intelifix - Total duration: 1h36m24s - Times executed: 32 ]
[ Application: psql - Total duration: 1h36m24s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-14 07:19:10 Duration: 14m9s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-14 08:10:50 Duration: 5m49s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-14 10:10:45 Duration: 5m43s Database: rio User: intelifix Remote: [local] Application: psql
3 1m36s 1m47s 1m42s 2 3m24s 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 14 20 1 1m47s 1m47s 23 1 1m36s 1m36s [ User: intelifix - Total duration: 3m24s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 3m24s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-14 20:09:22 Duration: 1m47s 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-14 23:43:06 Duration: 1m36s Database: rio User: intelifix Remote: [local] Application: pg_dump
4 25s717ms 2m6s 1m16s 2 2m32s 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 14 23 2 2m32s 1m16s [ User: intelifix - Total duration: 2m32s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m32s - 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-14 23:15:27 Duration: 2m6s 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-14 23:44:47 Duration: 25s717ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
5 23s145ms 1m51s 1m7s 2 2m14s copy auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 14 23 2 2m14s 1m7s [ User: intelifix - Total duration: 2m14s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m14s - Times executed: 2 ]
-
COPY auditor.auditor_2026_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-14 23:11:56 Duration: 1m51s 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-14 23:43:59 Duration: 23s145ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
6 1m1s 1m3s 1m2s 2 2m5s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 14 20 1 1m3s 1m3s 23 1 1m1s 1m1s [ User: intelifix - Total duration: 2m5s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m5s - Times executed: 2 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-14 20:05:37 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-14 23:19:51 Duration: 1m1s Database: rio User: intelifix Remote: [local] Application: pg_dump
7 22s99ms 1m24s 53s498ms 2 1m46s 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 14 23 2 1m46s 53s498ms [ User: intelifix - Total duration: 1m46s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m46s - 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-14 23:13:20 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-14 23:44:21 Duration: 22s99ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
8 12s714ms 55s455ms 34s85ms 2 1m8s 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 14 23 2 1m8s 34s85ms [ User: intelifix - Total duration: 1m8s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m8s - 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-14 23:16:22 Duration: 55s455ms 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-14 23:45:00 Duration: 12s714ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
9 17s992ms 18s799ms 18s396ms 2 36s792ms 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 14 20 1 18s799ms 18s799ms 23 1 17s992ms 17s992ms [ User: intelifix - Total duration: 36s792ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 36s792ms - Times executed: 2 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-06-14 20:04:33 Duration: 18s799ms 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-14 23:18:49 Duration: 17s992ms Database: rio User: intelifix Remote: [local] Application: pg_dump
10 2s291ms 33s468ms 17s732ms 4 1m10s copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 14 20 2 35s170ms 17s585ms 23 2 35s760ms 17s880ms [ User: intelifix - Total duration: 1m10s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m10s - 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-14 23:20:26 Duration: 33s468ms 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-14 20:06:12 Duration: 32s829ms 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-14 20:10:11 Duration: 2s340ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
11 438ms 1m49s 17s284ms 32 9m13s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 14 07 2 1m51s 55s934ms 08 2 30s277ms 15s138ms 09 2 31s260ms 15s630ms 10 2 29s876ms 14s938ms 11 2 29s414ms 14s707ms 12 2 29s927ms 14s963ms 13 2 27s830ms 13s915ms 14 2 30s399ms 15s199ms 15 2 26s871ms 13s435ms 16 2 28s315ms 14s157ms 17 2 27s619ms 13s809ms 18 2 30s305ms 15s152ms 19 2 28s484ms 14s242ms 20 2 33s744ms 16s872ms 21 2 28s794ms 14s397ms 22 2 28s100ms 14s50ms [ User: intelifix - Total duration: 9m13s - Times executed: 32 ]
[ Application: psql - Total duration: 9m13s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-14 07:21:00 Duration: 1m49s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-14 20:11:09 Duration: 32s908ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-14 09:11:11 Duration: 30s821ms Database: rio User: intelifix Remote: [local] Application: psql
12 1s637ms 31s160ms 15s967ms 4 1m3s 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 14 20 2 33s435ms 16s717ms 23 2 30s432ms 15s216ms [ User: intelifix - Total duration: 1m3s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m3s - Times executed: 4 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-06-14 20:06:48 Duration: 31s160ms 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-14 23:20:58 Duration: 28s794ms 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-14 20:10:14 Duration: 2s274ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
13 8s400ms 21s876ms 15s162ms 4 1m call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 14 00 2 40s356ms 20s178ms 06 2 20s294ms 10s147ms [ User: intelifix - Total duration: 1m - Times executed: 4 ]
[ Application: psql - Total duration: 1m - Times executed: 4 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-14 00:05:23 Duration: 21s876ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-14 00:05:41 Duration: 18s480ms Database: contagem User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-14 06:05:12 Duration: 11s894ms Database: rio User: intelifix Remote: [local] Application: psql
14 3s198ms 28s324ms 14s866ms 4 59s466ms 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 14 20 2 31s523ms 15s761ms 23 2 27s943ms 13s971ms [ User: intelifix - Total duration: 59s466ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 59s466ms - 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-14 20:09:50 Duration: 28s324ms 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-14 23:43:31 Duration: 24s682ms 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-14 23:46:03 Duration: 3s261ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
15 1s319ms 22s356ms 11s385ms 4 45s540ms copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 14 20 2 23s880ms 11s940ms 23 2 21s659ms 10s829ms [ User: intelifix - Total duration: 45s540ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 45s540ms - 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-14 20:04:14 Duration: 22s356ms 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-14 23:18:31 Duration: 20s340ms 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-14 20:10:09 Duration: 1s523ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
16 1s772ms 20s401ms 11s224ms 4 44s899ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 14 20 2 22s173ms 11s86ms 23 2 22s725ms 11s362ms [ User: intelifix - Total duration: 44s899ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 44s899ms - Times executed: 4 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-14 20:02:47 Duration: 20s401ms 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-14 23:17:04 Duration: 20s90ms 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-14 23:45:08 Duration: 2s634ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
17 1s558ms 19s548ms 10s539ms 4 42s159ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 14 20 2 20s988ms 10s494ms 23 2 21s171ms 10s585ms [ User: intelifix - Total duration: 42s159ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 42s159ms - Times executed: 4 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-06-14 23:17:38 Duration: 19s548ms 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-14 20:03:20 Duration: 19s429ms 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-14 23:45:11 Duration: 1s623ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
18 1s420ms 14s493ms 8s44ms 4 32s179ms 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 14 20 2 16s265ms 8s132ms 23 2 15s914ms 7s957ms [ User: intelifix - Total duration: 32s179ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 32s179ms - 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-14 23:17:53 Duration: 14s493ms 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-14 20:03:34 Duration: 14s277ms 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-14 20:10:06 Duration: 1s988ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
19 846ms 14s784ms 7s512ms 4 30s51ms 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 14 20 2 14s420ms 7s210ms 23 2 15s631ms 7s815ms [ User: intelifix - Total duration: 30s51ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 30s51ms - 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-14 23:17:18 Duration: 14s784ms 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-14 20:03:01 Duration: 13s488ms 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-14 20:10:02 Duration: 931ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
20 3s422ms 10s160ms 6s773ms 4 27s95ms copy public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 14 20 2 14s297ms 7s148ms 23 2 12s797ms 6s398ms [ User: intelifix - Total duration: 27s95ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 27s95ms - 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-14 20:07:19 Duration: 10s160ms 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-14 23:41:16 Duration: 9s375ms 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-14 20:10:19 Duration: 4s137ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 4 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jun 14 09 1 0ms 0ms 10 1 0ms 0ms 13 1 0ms 0ms 21 1 0ms 0ms [ User: intelifix - Total duration: 5m46s - Times executed: 4 ]
[ Application: psql - Total duration: 5m46s - Times executed: 4 ]
-
;
Date: Duration: 0ms Database: postgres User: rio Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 2,576 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 12 FATAL entries
- 456 ERROR entries
- 0 WARNING entries
- 1 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 138 Max number of times the same event was reported
- 469 Total events found
Rank Times reported Error 1 138 ERROR: procedure rs_giga_triagem(...) does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jun 14 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-14 00:05:18 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-14 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-14 00:25:04 Database: brasilia Application: psql User: intelifix Remote: [local]
2 138 ERROR: procedure rs_giga_processa_arquivos() does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Jun 14 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-14 00:05:18 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-14 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-14 00:25:04 Database: brasilia Application: psql User: intelifix Remote: [local]
3 46 ERROR: procedure rs_giga_tecnicos() does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count Jun 14 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-14 00:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-06-14 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-14 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
4 45 ERROR: procedure rs_tcia_processa_lotes() does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Jun 14 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-14 08:01: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-14 08:20:07 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-14 08:40:08 Database: brasilia Application: psql User: intelifix Remote: [local]
5 45 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #5
Day Hour Count Jun 14 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-14 08:01:09 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Character with value 0x09 must be escaped.
Context: JSON data, line 46101: "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-14 08:20:07 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Character with value 0x09 must be escaped.
Context: JSON data, line 22503: "nrSerie":"ZTEEH7VM1L08287... PL/pgSQL function rs_resumo_tcia(integer) line 139 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-14 08:40:08 Database: rio Application: psql User: intelifix Remote: [local]
6 16 ERROR: function rs_smart_fiscal_saida() does not exist
Times Reported Most Frequent Error / Event #6
Day Hour Count Jun 14 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-14 07:21:00 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-14 08:11:20 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-14 09:11:12 Database: brasilia Application: psql User: intelifix Remote: [local]
7 16 ERROR: function rs_smart_fiscal_entrada() does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Jun 14 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-14 07:21:00 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-14 08:11:20 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-14 09:11:12 Database: brasilia Application: psql User: intelifix Remote: [local]
8 8 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #8
Day Hour Count Jun 14 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-14 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-14 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-14 05:30:02 Database: brasilia Application: postgres_fdw User: lenon Remote: 127.0.0.1
9 6 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #9
Day Hour Count Jun 14 00 1 03 1 05 1 06 1 11 2 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-06-14 00:02:15 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-06-14 03:03:50 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-14 05:37:44 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
10 4 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #10
Day Hour Count Jun 14 03 4 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-06-14 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-14 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-14 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
11 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #11
Day Hour Count Jun 14 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-06-14 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-14 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
12 2 ERROR: procedure rs_atualiza_estoque_automatico() does not exist
Times Reported Most Frequent Error / Event #12
Day Hour Count Jun 14 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-14 00:05:23 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-14 06:05:12 Database: brasilia Application: psql User: intelifix Remote: [local]
13 1 ERROR: function rs_lote_entrada_fechar_automatico() does not exist
Times Reported Most Frequent Error / Event #13
Day Hour Count Jun 14 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-14 18:00:03 Database: brasilia Application: psql User: intelifix Remote: [local]
14 1 ERROR: function rs_del_temporario() does not exist
Times Reported Most Frequent Error / Event #14
Day Hour Count Jun 14 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-14 21:25:02 Database: brasilia Application: psql User: intelifix Remote: [local]
15 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #15
Day Hour Count Jun 14 03 1 - LOG: database system was shut down at 2026-06-14 03:05:01 -03
Date: 2026-06-14 03:05:02