pgBadger-
Global information
- Generated on Sat May 23 23:50:06 2026
- Log file: /usr/local/pgsql/data/log/serverlog-04.log, ..., /usr/local/pgsql/data/log/serverlog-26.log
- Parsed 1,466 log entries in 5s
- Log start from 2026-05-17 20:02:01 to 2026-05-23 20:11:51
-
Overview
Global Stats
- 46 Number of unique normalized queries
- 610 Number of queries
- 1h6m57s Total query duration
- 2026-05-17 20:02:02 First query
- 2026-05-23 20:11:51 Last query
- 4 queries/s at 2026-05-22 20:08:44 Query peak
- 1h6m57s Total query duration
- 224ms Prepare/parse total duration
- 0ms Bind total duration
- 1h6m57s Execute total duration
- 0 Number of events
- 0 Number of unique normalized events
- 0 Max number of times the same event was reported
- 0 Number of cancellation
- 0 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
- 30 Total number of sessions
- 1 sessions at 2026-05-22 15:04:29 Session peak
- 7h18m7s Total duration of sessions
- 14m36s Average duration of sessions
- 20 Average queries per session
- 2m13s Average queries duration per session
- 12m22s Average idle time per session
- 30 Total number of connections
- 2 connections/s at 2026-05-18 09:23:07 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 4 queries/s Query Peak
- 2026-05-22 20:08:44 Date
SELECT Traffic
Key values
- 3 queries/s Query Peak
- 2026-05-17 20:02:02 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-05-22 20:08:44 Date
Queries duration
Key values
- 1h6m57s 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) May 17 20 86 158ms 1m26s 6s645ms 2m4s 2m4s 2m4s May 18 09 1 482ms 482ms 482ms 482ms 482ms 482ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 20 89 154ms 1m40s 7s207ms 1m40s 1m53s 1m53s May 19 09 0 0ms 0ms 0ms 0ms 0ms 0ms 20 90 152ms 1m22s 6s72ms 1m23s 1m23s 1m23s May 20 20 92 150ms 1m29s 6s290ms 2m8s 2m8s 2m8s May 21 20 83 168ms 1m25s 6s796ms 1m26s 1m26s 1m26s May 22 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 20 83 154ms 1m23s 6s463ms 1m24s 1m24s 1m24s May 23 20 86 158ms 1m32s 6s723ms 2m14s 2m14s 2m14s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 17 20 4 82 6s645ms 1m10s 2m4s 2m4s May 18 09 1 0 482ms 482ms 482ms 482ms 10 0 0 0ms 0ms 0ms 0ms 20 7 82 7s207ms 1m4s 1m40s 1m53s May 19 09 0 0 0ms 0ms 0ms 0ms 20 7 83 6s72ms 1m11s 1m23s 1m23s May 20 20 9 83 6s290ms 1m6s 2m8s 2m8s May 21 20 3 80 6s796ms 1m8s 1m26s 1m26s May 22 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 20 1 82 6s463ms 1m9s 1m24s 1m24s May 23 20 3 83 6s723ms 1m4s 2m14s 2m14s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 17 20 0 0 0 0 0ms 0ms 0ms 0ms May 18 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms May 19 09 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms May 20 20 0 0 0 0 0ms 0ms 0ms 0ms May 21 20 0 0 0 0 0ms 0ms 0ms 0ms May 22 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 20 0 0 0 0 0ms 0ms 0ms 0ms May 23 20 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare May 17 20 0 0 0.00 0.00% May 18 09 1 1 1.00 100.00% 10 0 0 0.00 0.00% 20 0 0 0.00 0.00% May 19 09 0 0 0.00 0.00% 20 0 0 0.00 0.00% May 20 20 0 0 0.00 0.00% May 21 20 0 0 0.00 0.00% May 22 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 20 0 0 0.00 0.00% May 23 20 0 0 0.00 0.00% Day Hour Count Average / Second May 17 20 3 0.00/s May 18 09 2 0.00/s 10 0 0.00/s 20 3 0.00/s May 19 09 2 0.00/s 20 3 0.00/s May 20 20 3 0.00/s May 21 20 3 0.00/s May 22 14 3 0.00/s 15 2 0.00/s 16 0 0.00/s 20 3 0.00/s May 23 20 3 0.00/s Day Hour Count Average Duration Average idle time May 17 20 3 3m14s 3s758ms May 18 09 0 0ms 0ms 10 2 1h1m30s 1h1m30s 20 3 3m37s 4s131ms May 19 09 2 24s13ms 24s13ms 20 3 3m5s 3s642ms May 20 20 3 3m16s 4s31ms May 21 20 3 3m12s 4s5ms May 22 14 1 107ms 107ms 15 2 1h1m30s 1h1m30s 16 2 1h1m30s 1h1m30s 20 3 3m2s 3s692ms May 23 20 3 3m16s 3s866ms -
Connections
Established Connections
Key values
- 2 connections Connection Peak
- 2026-05-18 09:23:07 Date
Connections per database
Key values
- rio Main Database
- 30 connections Total
Connections per user
Key values
- intelifix Main User
- 30 connections Total
-
Sessions
Simultaneous sessions
Key values
- 1 sessions Session Peak
- 2026-05-22 15:04:29 Date
Histogram of session times
Key values
- 14 60000-600000ms duration
Sessions per database
Key values
- rio Main Database
- 30 sessions Total
Sessions per user
Key values
- intelifix Main User
- 30 sessions Total
Sessions per host
Key values
- [local] Main Host
- 30 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 2 buffers Checkpoint Peak
- 2026-05-19 09:47:20 Date
- 0.227 seconds Highest write time
- 0.002 seconds Sync time
Checkpoints Wal files
Key values
- 0 files Wal files usage Peak
- 2026-05-19 09:47:20 Date
Checkpoints distance
Key values
- 0.02 Mo Distance Peak
- 2026-05-19 09:47:20 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time May 17 20 0 0s 0s 0s May 18 09 0 0s 0s 0s 10 0 0s 0s 0s 20 0 0s 0s 0s May 19 09 2 0.227s 0.002s 0.233s 20 0 0s 0s 0s May 20 20 0 0s 0s 0s May 21 20 0 0s 0s 0s May 22 14 0 0s 0s 0s 15 0 0s 0s 0s 16 0 0s 0s 0s 20 0 0s 0s 0s May 23 20 0 0s 0s 0s Day Hour Added Removed Recycled Synced files Longest sync Average sync May 17 20 0 0 0 0 0s 0s May 18 09 0 0 0 0 0s 0s 10 0 0 0 0 0s 0s 20 0 0 0 0 0s 0s May 19 09 0 0 0 1 0.002s 0.002s 20 0 0 0 0 0s 0s May 20 20 0 0 0 0 0s 0s May 21 20 0 0 0 0 0s 0s May 22 14 0 0 0 0 0s 0s 15 0 0 0 0 0s 0s 16 0 0 0 0 0s 0s 20 0 0 0 0 0s 0s May 23 20 0 0 0 0 0s 0s Day Hour Count Avg time (sec) May 17 20 0 0s May 18 09 0 0s 10 0 0s 20 0 0s May 19 09 0 0s 20 0 0s May 20 20 0 0s May 21 20 0 0s May 22 14 0 0s 15 0 0s 16 0 0s 20 0 0s May 23 20 0 0s Day Hour Mean distance Mean estimate May 17 20 0.00 kB 0.00 kB May 18 09 0.00 kB 0.00 kB 10 0.00 kB 0.00 kB 20 0.00 kB 0.00 kB May 19 09 10.00 kB 14,014.00 kB 20 0.00 kB 0.00 kB May 20 20 0.00 kB 0.00 kB May 21 20 0.00 kB 0.00 kB May 22 14 0.00 kB 0.00 kB 15 0.00 kB 0.00 kB 16 0.00 kB 0.00 kB 20 0.00 kB 0.00 kB May 23 20 0.00 kB 0.00 kB -
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size May 17 20 0 0 0 May 18 09 0 0 0 10 0 0 0 20 0 0 0 May 19 09 0 0 0 20 0 0 0 May 20 20 0 0 0 May 21 20 0 0 0 May 22 14 0 0 0 15 0 0 0 16 0 0 0 20 0 0 0 May 23 20 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Autovacuum actions (5 minutes period)
NO DATASET
Average Autovacuum Duration
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
Average Autovacuum Duration (5 minutes average)
NO DATASET
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- unknown (0) Main table vacuumed on database
- 0 vacuums Total
Vacuum throughput per table
Key values
- unknown (0) Max CPU elapsed for vacuum on database
- unknown (0 ms) Max I/O read time for vacuum on database
- unknown (0 ms) Max I/O write time for vacuum on database
Tuples removed per table
Key values
- unknown (0) Main table with removed tuples on database
- 0 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs May 17 20 0 0 May 18 09 0 0 10 0 0 20 0 0 May 19 09 0 0 20 0 0 May 20 20 0 0 May 21 20 0 0 May 22 14 0 0 15 0 0 16 0 0 20 0 0 May 23 20 0 0 - 0 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
- 35 Total read queries
- 575 Total write queries
Queries by database
Key values
- rio Main database
- 262 Requests
- 53m3s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 695 Requests
User Request type Count Duration intelifix Total 695 1h16m35s copy to 658 1h16m27s select 37 8s258ms lenon Total 1 482ms select 1 482ms Duration by user
Key values
- 1h16m35s (intelifix) Main time consuming user
User Request type Count Duration intelifix Total 695 1h16m35s copy to 658 1h16m27s select 37 8s258ms lenon Total 1 482ms select 1 482ms Queries by host
Key values
- [local] Main host
- 696 Requests
- 1h16m35s ([local])
- Main time consuming host
Queries by application
Key values
- pg_dump Main application
- 609 Requests
- 1h6m57s (pg_dump)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-05-20 20:06:37 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 268 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 1m40s COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;[ Date: 2026-05-18 20:09:59 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
2 1m32s COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;[ Date: 2026-05-23 20:09:12 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
3 1m29s COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;[ Date: 2026-05-20 20:09:09 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
4 1m26s COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;[ Date: 2026-05-17 20:09:12 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
5 1m25s COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;[ Date: 2026-05-21 20:08:59 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
6 1m23s COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;[ Date: 2026-05-22 20:08:44 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
7 1m22s COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;[ Date: 2026-05-19 20:08:50 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
8 1m9s COPY public.logs (mensagem, quando) TO stdout;[ Date: 2026-05-18 20:06:13 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
9 1m8s COPY public.logs (mensagem, quando) TO stdout;[ Date: 2026-05-17 20:05:55 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
10 1m3s COPY public.logs (mensagem, quando) TO stdout;[ Date: 2026-05-23 20:05:53 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
11 1m2s COPY public.logs (mensagem, quando) TO stdout;[ Date: 2026-05-21 20:05:47 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
12 1m2s COPY public.logs (mensagem, quando) TO stdout;[ Date: 2026-05-20 20:05:58 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
13 59s981ms COPY public.logs (mensagem, quando) TO stdout;[ Date: 2026-05-19 20:05:39 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
14 58s818ms COPY public.logs (mensagem, quando) TO stdout;[ Date: 2026-05-22 20:05:36 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
15 38s277ms 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-05-18 20:06:53 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
16 37s219ms 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-05-17 20:06:34 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
17 37s209ms 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-05-19 20:06:18 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
18 35s820ms 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-05-23 20:06:31 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
19 35s503ms 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-05-22 20:06:13 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
20 35s418ms COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;[ Date: 2026-05-18 20:07:32 - 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 10m52s 14 4s112ms 1m40s 46s588ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 17 20 2 1m30s 45s344ms May 18 20 2 1m45s 52s507ms May 19 20 2 1m26s 43s237ms May 20 20 2 1m34s 47s408ms May 21 20 2 1m30s 45s233ms May 22 20 2 1m27s 43s993ms May 23 20 2 1m36s 48s394ms [ User: intelifix - Total duration: 10m52s - Times executed: 14 ]
[ Application: pg_dump - Total duration: 10m52s - Times executed: 14 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-18 20:09:59 Duration: 1m40s 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-05-23 20:09:12 Duration: 1m32s 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-05-20 20:09:09 Duration: 1m29s Database: rio User: intelifix Remote: [local] Application: pg_dump
2 7m29s 14 442ms 1m9s 32s78ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 17 20 2 1m8s 34s407ms May 18 20 2 1m10s 35s246ms May 19 20 2 1m 30s212ms May 20 20 2 1m2s 31s499ms May 21 20 2 1m3s 31s603ms May 22 20 2 59s361ms 29s680ms May 23 20 2 1m3s 31s899ms [ User: intelifix - Total duration: 7m29s - Times executed: 14 ]
[ Application: pg_dump - Total duration: 7m29s - Times executed: 14 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-18 20:06:13 Duration: 1m9s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-17 20:05:55 Duration: 1m8s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-23 20:05:53 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: pg_dump
3 5m40s 21 2s76ms 38s277ms 16s198ms 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 #3
Day Hour Count Duration Avg duration May 17 20 3 49s357ms 16s452ms May 18 20 3 52s285ms 17s428ms May 19 20 3 48s861ms 16s287ms May 20 20 3 47s523ms 15s841ms May 21 20 3 46s937ms 15s645ms May 22 20 3 47s175ms 15s725ms May 23 20 3 48s20ms 16s6ms [ User: intelifix - Total duration: 5m40s - Times executed: 21 ]
[ Application: pg_dump - Total duration: 5m40s - Times executed: 21 ]
-
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-05-18 20:06:53 Duration: 38s277ms 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-05-17 20:06:34 Duration: 37s219ms 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-05-19 20:06:18 Duration: 37s209ms Database: rio User: intelifix Remote: [local] Application: pg_dump
4 4m49s 21 1s670ms 35s418ms 13s793ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration May 17 20 3 40s551ms 13s517ms May 18 20 3 46s873ms 15s624ms May 19 20 3 40s994ms 13s664ms May 20 20 3 39s890ms 13s296ms May 21 20 3 41s441ms 13s813ms May 22 20 3 40s510ms 13s503ms May 23 20 3 39s392ms 13s130ms [ User: intelifix - Total duration: 4m49s - Times executed: 21 ]
[ Application: pg_dump - Total duration: 4m49s - Times executed: 21 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-18 20:07:32 Duration: 35s418ms 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-05-19 20:06:53 Duration: 31s638ms 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-05-17 20:07:08 Duration: 31s457ms Database: rio User: intelifix Remote: [local] Application: pg_dump
5 4m42s 21 3s229ms 33s916ms 13s465ms 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 #5
Day Hour Count Duration Avg duration May 17 20 3 39s695ms 13s231ms May 18 20 3 45s866ms 15s288ms May 19 20 3 37s333ms 12s444ms May 20 20 3 38s203ms 12s734ms May 21 20 3 40s527ms 13s509ms May 22 20 3 38s49ms 12s683ms May 23 20 3 43s100ms 14s366ms [ User: intelifix - Total duration: 4m42s - Times executed: 21 ]
[ Application: pg_dump - Total duration: 4m42s - Times executed: 21 ]
-
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-05-18 20:10:33 Duration: 33s916ms 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-05-23 20:09:46 Duration: 32s759ms 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-05-21 20:09:30 Duration: 30s163ms Database: rio User: intelifix Remote: [local] Application: pg_dump
6 3m52s 21 1s598ms 23s245ms 11s83ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration May 17 20 3 33s730ms 11s243ms May 18 20 3 34s288ms 11s429ms May 19 20 3 32s712ms 10s904ms May 20 20 3 34s779ms 11s593ms May 21 20 3 32s682ms 10s894ms May 22 20 3 31s678ms 10s559ms May 23 20 3 32s872ms 10s957ms [ User: intelifix - Total duration: 3m52s - Times executed: 21 ]
[ Application: pg_dump - Total duration: 3m52s - Times executed: 21 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-20 20:02:49 Duration: 23s245ms 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-05-18 20:02:51 Duration: 23s163ms 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-05-19 20:02:48 Duration: 21s989ms Database: rio User: intelifix Remote: [local] Application: pg_dump
7 3m51s 21 1s422ms 25s65ms 11s30ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration May 17 20 3 32s132ms 10s710ms May 18 20 3 39s791ms 13s263ms May 19 20 3 30s652ms 10s217ms May 20 20 3 32s645ms 10s881ms May 21 20 3 33s502ms 11s167ms May 22 20 3 30s663ms 10s221ms May 23 20 3 32s256ms 10s752ms [ User: intelifix - Total duration: 3m51s - Times executed: 21 ]
[ Application: pg_dump - Total duration: 3m51s - Times executed: 21 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-18 20:03:33 Duration: 25s65ms 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-05-21 20:03:26 Duration: 23s139ms 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-05-20 20:03:27 Duration: 22s223ms Database: rio User: intelifix Remote: [local] Application: pg_dump
8 3m39s 21 1s188ms 27s884ms 10s458ms 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 May 17 20 3 31s322ms 10s440ms May 18 20 3 33s959ms 11s319ms May 19 20 3 29s997ms 9s999ms May 20 20 3 34s755ms 11s585ms May 21 20 3 29s274ms 9s758ms May 22 20 3 28s307ms 9s435ms May 23 20 3 32s14ms 10s671ms [ User: intelifix - Total duration: 3m39s - Times executed: 21 ]
[ Application: pg_dump - Total duration: 3m39s - Times executed: 21 ]
-
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-05-20 20:04:31 Duration: 27s884ms 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-05-18 20:04:38 Duration: 27s29ms 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-05-17 20:04:23 Duration: 25s641ms Database: rio User: intelifix Remote: [local] Application: pg_dump
9 3m6s 14 3s272ms 24s943ms 13s287ms 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 May 17 20 2 26s610ms 13s305ms May 18 20 2 29s625ms 14s812ms May 19 20 2 24s174ms 12s87ms May 20 20 2 28s206ms 14s103ms May 21 20 2 24s610ms 12s305ms May 22 20 2 25s835ms 12s917ms May 23 20 2 26s963ms 13s481ms [ User: intelifix - Total duration: 3m6s - Times executed: 14 ]
[ Application: pg_dump - Total duration: 3m6s - Times executed: 14 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-05-18 20:05:03 Duration: 24s943ms 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-05-20 20:04:55 Duration: 23s831ms 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-05-23 20:04:50 Duration: 23s486ms Database: rio User: intelifix Remote: [local] Application: pg_dump
10 2m48s 21 1s171ms 17s349ms 8s5ms 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 #10
Day Hour Count Duration Avg duration May 17 20 3 22s914ms 7s638ms May 18 20 3 25s674ms 8s558ms May 19 20 3 22s309ms 7s436ms May 20 20 3 24s24ms 8s8ms May 21 20 3 25s817ms 8s605ms May 22 20 3 22s23ms 7s341ms May 23 20 3 25s345ms 8s448ms [ User: intelifix - Total duration: 2m48s - Times executed: 21 ]
[ Application: pg_dump - Total duration: 2m48s - Times executed: 21 ]
-
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-05-23 20:03:43 Duration: 17s349ms 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-05-21 20:03:43 Duration: 17s192ms 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-05-18 20:03:50 Duration: 16s861ms Database: rio User: intelifix Remote: [local] Application: pg_dump
11 2m16s 21 698ms 17s247ms 6s494ms 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 #11
Day Hour Count Duration Avg duration May 17 20 3 20s396ms 6s798ms May 18 20 3 20s300ms 6s766ms May 19 20 3 18s703ms 6s234ms May 20 20 3 19s873ms 6s624ms May 21 20 3 18s850ms 6s283ms May 22 20 3 18s519ms 6s173ms May 23 20 3 19s742ms 6s580ms [ User: intelifix - Total duration: 2m16s - Times executed: 21 ]
[ Application: pg_dump - Total duration: 2m16s - Times executed: 21 ]
-
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-05-18 20:03:08 Duration: 17s247ms 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-05-17 20:03:04 Duration: 17s102ms 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-05-23 20:03:04 Duration: 15s980ms Database: rio User: intelifix Remote: [local] Application: pg_dump
12 1m44s 21 682ms 15s385ms 4s977ms 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 #12
Day Hour Count Duration Avg duration May 17 20 3 13s531ms 4s510ms May 18 20 3 16s870ms 5s623ms May 19 20 3 13s641ms 4s547ms May 20 20 3 17s45ms 5s681ms May 21 20 3 14s676ms 4s892ms May 22 20 3 13s504ms 4s501ms May 23 20 3 15s247ms 5s82ms [ User: intelifix - Total duration: 1m44s - Times executed: 21 ]
[ Application: pg_dump - Total duration: 1m44s - Times executed: 21 ]
-
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-05-18 20:04:11 Duration: 15s385ms 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-05-20 20:04:04 Duration: 15s229ms 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-05-23 20:04:01 Duration: 13s544ms Database: rio User: intelifix Remote: [local] Application: pg_dump
13 1m40s 21 2s66ms 7s375ms 4s768ms 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 May 17 20 3 13s584ms 4s528ms May 18 20 3 16s982ms 5s660ms May 19 20 3 13s195ms 4s398ms May 20 20 3 14s805ms 4s935ms May 21 20 3 14s490ms 4s830ms May 22 20 3 12s525ms 4s175ms May 23 20 3 14s561ms 4s853ms [ User: intelifix - Total duration: 1m40s - Times executed: 21 ]
[ Application: pg_dump - Total duration: 1m40s - Times executed: 21 ]
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-05-18 20:08:01 Duration: 7s375ms 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-05-20 20:11:06 Duration: 6s903ms Database: brasilia 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-05-18 20:12:03 Duration: 6s824ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 1m38s 21 663ms 11s301ms 4s688ms 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 #14
Day Hour Count Duration Avg duration May 17 20 3 13s949ms 4s649ms May 18 20 3 15s69ms 5s23ms May 19 20 3 14s61ms 4s687ms May 20 20 3 14s300ms 4s766ms May 21 20 3 13s623ms 4s541ms May 22 20 3 13s179ms 4s393ms May 23 20 3 14s281ms 4s760ms [ User: intelifix - Total duration: 1m38s - Times executed: 21 ]
[ Application: pg_dump - Total duration: 1m38s - Times executed: 21 ]
-
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-05-18 20:02:24 Duration: 11s301ms 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-05-17 20:02:22 Duration: 11s120ms 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-05-19 20:02:23 Duration: 11s34ms Database: rio User: intelifix Remote: [local] Application: pg_dump
15 1m35s 7 11s975ms 16s85ms 13s603ms copy public.nf_entrada_itens (nem_id, serie, valor, li_id, modo, nea_id, tipo_local, lc_id, rede_msg, sub_modelo) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration May 17 20 1 14s343ms 14s343ms May 18 20 1 16s85ms 16s85ms May 19 20 1 13s332ms 13s332ms May 20 20 1 12s274ms 12s274ms May 21 20 1 14s33ms 14s33ms May 22 20 1 11s975ms 11s975ms May 23 20 1 13s180ms 13s180ms [ User: intelifix - Total duration: 1m35s - Times executed: 7 ]
[ Application: pg_dump - Total duration: 1m35s - Times executed: 7 ]
-
COPY public.nf_entrada_itens (nem_id, serie, valor, li_id, modo, nea_id, tipo_local, lc_id, rede_msg, sub_modelo) TO stdout;
Date: 2026-05-18 20:07:49 Duration: 16s85ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_itens (nem_id, serie, valor, li_id, modo, nea_id, tipo_local, lc_id, rede_msg, sub_modelo) TO stdout;
Date: 2026-05-17 20:07:22 Duration: 14s343ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_itens (nem_id, serie, valor, li_id, modo, nea_id, tipo_local, lc_id, rede_msg, sub_modelo) TO stdout;
Date: 2026-05-21 20:07:12 Duration: 14s33ms Database: rio User: intelifix Remote: [local] Application: pg_dump
16 1m19s 14 293ms 15s117ms 5s702ms copy public.tcia_lote_fluxos (tl_id, flu_id, criacao) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 17 20 2 11s578ms 5s789ms May 18 20 2 15s649ms 7s824ms May 19 20 2 10s867ms 5s433ms May 20 20 2 10s627ms 5s313ms May 21 20 2 10s269ms 5s134ms May 22 20 2 10s158ms 5s79ms May 23 20 2 10s679ms 5s339ms [ User: intelifix - Total duration: 1m19s - Times executed: 14 ]
[ Application: pg_dump - Total duration: 1m19s - Times executed: 14 ]
-
COPY public.tcia_lote_fluxos (tl_id, flu_id, criacao) TO stdout;
Date: 2026-05-18 20:08:18 Duration: 15s117ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lote_fluxos (tl_id, flu_id, criacao) TO stdout;
Date: 2026-05-17 20:07:46 Duration: 11s149ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lote_fluxos (tl_id, flu_id, criacao) TO stdout;
Date: 2026-05-19 20:07:28 Duration: 10s431ms Database: rio User: intelifix Remote: [local] Application: pg_dump
17 1m4s 21 2s606ms 3s656ms 3s87ms 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 May 17 20 3 8s945ms 2s981ms May 18 20 3 10s189ms 3s396ms May 19 20 3 8s908ms 2s969ms May 20 20 3 8s815ms 2s938ms May 21 20 3 9s865ms 3s288ms May 22 20 3 8s408ms 2s802ms May 23 20 3 9s712ms 3s237ms [ User: intelifix - Total duration: 1m4s - Times executed: 21 ]
[ Application: pg_dump - Total duration: 1m4s - Times executed: 21 ]
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-05-23 20:02:10 Duration: 3s656ms 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-05-21 20:02:11 Duration: 3s612ms 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-05-18 20:12:28 Duration: 3s570ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
18 49s737ms 21 322ms 5s434ms 2s368ms 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 May 17 20 3 6s441ms 2s147ms May 18 20 3 8s93ms 2s697ms May 19 20 3 6s823ms 2s274ms May 20 20 3 7s519ms 2s506ms May 21 20 3 7s751ms 2s583ms May 22 20 3 6s144ms 2s48ms May 23 20 3 6s963ms 2s321ms [ User: intelifix - Total duration: 49s737ms - Times executed: 21 ]
[ Application: pg_dump - Total duration: 49s737ms - Times executed: 21 ]
-
COPY public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) TO stdout;
Date: 2026-05-18 20:03:55 Duration: 5s434ms 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-05-20 20:03:48 Duration: 5s95ms 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-05-21 20:03:48 Duration: 4s936ms Database: rio User: intelifix Remote: [local] Application: pg_dump
19 33s521ms 14 780ms 4s330ms 2s394ms copy public.nf_entrada_itens (nem_id, serie, valor, li_id, modo, nea_id, tipo_local, data_conf, lc_id, rede_msg, sub_modelo) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration May 17 20 2 4s497ms 2s248ms May 18 20 2 4s967ms 2s483ms May 19 20 2 4s547ms 2s273ms May 20 20 2 5s411ms 2s705ms May 21 20 2 4s887ms 2s443ms May 22 20 2 4s391ms 2s195ms May 23 20 2 4s820ms 2s410ms [ User: intelifix - Total duration: 33s521ms - Times executed: 14 ]
[ Application: pg_dump - Total duration: 33s521ms - Times executed: 14 ]
-
COPY public.nf_entrada_itens (nem_id, serie, valor, li_id, modo, nea_id, tipo_local, data_conf, lc_id, rede_msg, sub_modelo) TO stdout;
Date: 2026-05-20 20:10:58 Duration: 4s330ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_itens (nem_id, serie, valor, li_id, modo, nea_id, tipo_local, data_conf, lc_id, rede_msg, sub_modelo) TO stdout;
Date: 2026-05-18 20:11:56 Duration: 3s964ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_itens (nem_id, serie, valor, li_id, modo, nea_id, tipo_local, data_conf, lc_id, rede_msg, sub_modelo) TO stdout;
Date: 2026-05-19 20:10:30 Duration: 3s766ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 30s989ms 21 1s318ms 1s815ms 1s475ms copy ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 17 20 3 4s324ms 1s441ms May 18 20 3 4s753ms 1s584ms May 19 20 3 4s459ms 1s486ms May 20 20 3 4s466ms 1s488ms May 21 20 3 4s321ms 1s440ms May 22 20 3 4s448ms 1s482ms May 23 20 3 4s214ms 1s404ms [ User: intelifix - Total duration: 30s989ms - Times executed: 21 ]
[ Application: pg_dump - Total duration: 30s989ms - Times executed: 21 ]
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-18 20:02:07 Duration: 1s815ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-22 20:09:18 Duration: 1s640ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-19 20:10:53 Duration: 1s609ms 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 21 5m40s 2s76ms 38s277ms 16s198ms 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 #1
Day Hour Count Duration Avg duration May 17 20 3 49s357ms 16s452ms May 18 20 3 52s285ms 17s428ms May 19 20 3 48s861ms 16s287ms May 20 20 3 47s523ms 15s841ms May 21 20 3 46s937ms 15s645ms May 22 20 3 47s175ms 15s725ms May 23 20 3 48s20ms 16s6ms [ User: intelifix - Total duration: 5m40s - Times executed: 21 ]
[ Application: pg_dump - Total duration: 5m40s - Times executed: 21 ]
-
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-05-18 20:06:53 Duration: 38s277ms 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-05-17 20:06:34 Duration: 37s219ms 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-05-19 20:06:18 Duration: 37s209ms Database: rio User: intelifix Remote: [local] Application: pg_dump
2 21 4m49s 1s670ms 35s418ms 13s793ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 17 20 3 40s551ms 13s517ms May 18 20 3 46s873ms 15s624ms May 19 20 3 40s994ms 13s664ms May 20 20 3 39s890ms 13s296ms May 21 20 3 41s441ms 13s813ms May 22 20 3 40s510ms 13s503ms May 23 20 3 39s392ms 13s130ms [ User: intelifix - Total duration: 4m49s - Times executed: 21 ]
[ Application: pg_dump - Total duration: 4m49s - Times executed: 21 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-18 20:07:32 Duration: 35s418ms 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-05-19 20:06:53 Duration: 31s638ms 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-05-17 20:07:08 Duration: 31s457ms Database: rio User: intelifix Remote: [local] Application: pg_dump
3 21 4m42s 3s229ms 33s916ms 13s465ms 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 #3
Day Hour Count Duration Avg duration May 17 20 3 39s695ms 13s231ms May 18 20 3 45s866ms 15s288ms May 19 20 3 37s333ms 12s444ms May 20 20 3 38s203ms 12s734ms May 21 20 3 40s527ms 13s509ms May 22 20 3 38s49ms 12s683ms May 23 20 3 43s100ms 14s366ms [ User: intelifix - Total duration: 4m42s - Times executed: 21 ]
[ Application: pg_dump - Total duration: 4m42s - Times executed: 21 ]
-
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-05-18 20:10:33 Duration: 33s916ms 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-05-23 20:09:46 Duration: 32s759ms 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-05-21 20:09:30 Duration: 30s163ms Database: rio User: intelifix Remote: [local] Application: pg_dump
4 21 3m52s 1s598ms 23s245ms 11s83ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration May 17 20 3 33s730ms 11s243ms May 18 20 3 34s288ms 11s429ms May 19 20 3 32s712ms 10s904ms May 20 20 3 34s779ms 11s593ms May 21 20 3 32s682ms 10s894ms May 22 20 3 31s678ms 10s559ms May 23 20 3 32s872ms 10s957ms [ User: intelifix - Total duration: 3m52s - Times executed: 21 ]
[ Application: pg_dump - Total duration: 3m52s - Times executed: 21 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-20 20:02:49 Duration: 23s245ms 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-05-18 20:02:51 Duration: 23s163ms 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-05-19 20:02:48 Duration: 21s989ms Database: rio User: intelifix Remote: [local] Application: pg_dump
5 21 3m51s 1s422ms 25s65ms 11s30ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration May 17 20 3 32s132ms 10s710ms May 18 20 3 39s791ms 13s263ms May 19 20 3 30s652ms 10s217ms May 20 20 3 32s645ms 10s881ms May 21 20 3 33s502ms 11s167ms May 22 20 3 30s663ms 10s221ms May 23 20 3 32s256ms 10s752ms [ User: intelifix - Total duration: 3m51s - Times executed: 21 ]
[ Application: pg_dump - Total duration: 3m51s - Times executed: 21 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-18 20:03:33 Duration: 25s65ms 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-05-21 20:03:26 Duration: 23s139ms 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-05-20 20:03:27 Duration: 22s223ms Database: rio User: intelifix Remote: [local] Application: pg_dump
6 21 3m39s 1s188ms 27s884ms 10s458ms 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 #6
Day Hour Count Duration Avg duration May 17 20 3 31s322ms 10s440ms May 18 20 3 33s959ms 11s319ms May 19 20 3 29s997ms 9s999ms May 20 20 3 34s755ms 11s585ms May 21 20 3 29s274ms 9s758ms May 22 20 3 28s307ms 9s435ms May 23 20 3 32s14ms 10s671ms [ User: intelifix - Total duration: 3m39s - Times executed: 21 ]
[ Application: pg_dump - Total duration: 3m39s - Times executed: 21 ]
-
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-05-20 20:04:31 Duration: 27s884ms 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-05-18 20:04:38 Duration: 27s29ms 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-05-17 20:04:23 Duration: 25s641ms Database: rio User: intelifix Remote: [local] Application: pg_dump
7 21 2m48s 1s171ms 17s349ms 8s5ms 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 #7
Day Hour Count Duration Avg duration May 17 20 3 22s914ms 7s638ms May 18 20 3 25s674ms 8s558ms May 19 20 3 22s309ms 7s436ms May 20 20 3 24s24ms 8s8ms May 21 20 3 25s817ms 8s605ms May 22 20 3 22s23ms 7s341ms May 23 20 3 25s345ms 8s448ms [ User: intelifix - Total duration: 2m48s - Times executed: 21 ]
[ Application: pg_dump - Total duration: 2m48s - Times executed: 21 ]
-
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-05-23 20:03:43 Duration: 17s349ms 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-05-21 20:03:43 Duration: 17s192ms 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-05-18 20:03:50 Duration: 16s861ms Database: rio User: intelifix Remote: [local] Application: pg_dump
8 21 2m16s 698ms 17s247ms 6s494ms 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 #8
Day Hour Count Duration Avg duration May 17 20 3 20s396ms 6s798ms May 18 20 3 20s300ms 6s766ms May 19 20 3 18s703ms 6s234ms May 20 20 3 19s873ms 6s624ms May 21 20 3 18s850ms 6s283ms May 22 20 3 18s519ms 6s173ms May 23 20 3 19s742ms 6s580ms [ User: intelifix - Total duration: 2m16s - Times executed: 21 ]
[ Application: pg_dump - Total duration: 2m16s - Times executed: 21 ]
-
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-05-18 20:03:08 Duration: 17s247ms 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-05-17 20:03:04 Duration: 17s102ms 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-05-23 20:03:04 Duration: 15s980ms Database: rio User: intelifix Remote: [local] Application: pg_dump
9 21 1m44s 682ms 15s385ms 4s977ms 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 #9
Day Hour Count Duration Avg duration May 17 20 3 13s531ms 4s510ms May 18 20 3 16s870ms 5s623ms May 19 20 3 13s641ms 4s547ms May 20 20 3 17s45ms 5s681ms May 21 20 3 14s676ms 4s892ms May 22 20 3 13s504ms 4s501ms May 23 20 3 15s247ms 5s82ms [ User: intelifix - Total duration: 1m44s - Times executed: 21 ]
[ Application: pg_dump - Total duration: 1m44s - Times executed: 21 ]
-
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-05-18 20:04:11 Duration: 15s385ms 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-05-20 20:04:04 Duration: 15s229ms 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-05-23 20:04:01 Duration: 13s544ms Database: rio User: intelifix Remote: [local] Application: pg_dump
10 21 1m40s 2s66ms 7s375ms 4s768ms 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 #10
Day Hour Count Duration Avg duration May 17 20 3 13s584ms 4s528ms May 18 20 3 16s982ms 5s660ms May 19 20 3 13s195ms 4s398ms May 20 20 3 14s805ms 4s935ms May 21 20 3 14s490ms 4s830ms May 22 20 3 12s525ms 4s175ms May 23 20 3 14s561ms 4s853ms [ User: intelifix - Total duration: 1m40s - Times executed: 21 ]
[ Application: pg_dump - Total duration: 1m40s - Times executed: 21 ]
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-05-18 20:08:01 Duration: 7s375ms 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-05-20 20:11:06 Duration: 6s903ms Database: brasilia 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-05-18 20:12:03 Duration: 6s824ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 21 1m38s 663ms 11s301ms 4s688ms 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 #11
Day Hour Count Duration Avg duration May 17 20 3 13s949ms 4s649ms May 18 20 3 15s69ms 5s23ms May 19 20 3 14s61ms 4s687ms May 20 20 3 14s300ms 4s766ms May 21 20 3 13s623ms 4s541ms May 22 20 3 13s179ms 4s393ms May 23 20 3 14s281ms 4s760ms [ User: intelifix - Total duration: 1m38s - Times executed: 21 ]
[ Application: pg_dump - Total duration: 1m38s - Times executed: 21 ]
-
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-05-18 20:02:24 Duration: 11s301ms 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-05-17 20:02:22 Duration: 11s120ms 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-05-19 20:02:23 Duration: 11s34ms Database: rio User: intelifix Remote: [local] Application: pg_dump
12 21 1m4s 2s606ms 3s656ms 3s87ms copy ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration May 17 20 3 8s945ms 2s981ms May 18 20 3 10s189ms 3s396ms May 19 20 3 8s908ms 2s969ms May 20 20 3 8s815ms 2s938ms May 21 20 3 9s865ms 3s288ms May 22 20 3 8s408ms 2s802ms May 23 20 3 9s712ms 3s237ms [ User: intelifix - Total duration: 1m4s - Times executed: 21 ]
[ Application: pg_dump - Total duration: 1m4s - Times executed: 21 ]
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-05-23 20:02:10 Duration: 3s656ms 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-05-21 20:02:11 Duration: 3s612ms 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-05-18 20:12:28 Duration: 3s570ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
13 21 49s737ms 322ms 5s434ms 2s368ms copy public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration May 17 20 3 6s441ms 2s147ms May 18 20 3 8s93ms 2s697ms May 19 20 3 6s823ms 2s274ms May 20 20 3 7s519ms 2s506ms May 21 20 3 7s751ms 2s583ms May 22 20 3 6s144ms 2s48ms May 23 20 3 6s963ms 2s321ms [ User: intelifix - Total duration: 49s737ms - Times executed: 21 ]
[ Application: pg_dump - Total duration: 49s737ms - Times executed: 21 ]
-
COPY public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) TO stdout;
Date: 2026-05-18 20:03:55 Duration: 5s434ms 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-05-20 20:03:48 Duration: 5s95ms 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-05-21 20:03:48 Duration: 4s936ms Database: rio User: intelifix Remote: [local] Application: pg_dump
14 21 30s989ms 1s318ms 1s815ms 1s475ms copy ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration May 17 20 3 4s324ms 1s441ms May 18 20 3 4s753ms 1s584ms May 19 20 3 4s459ms 1s486ms May 20 20 3 4s466ms 1s488ms May 21 20 3 4s321ms 1s440ms May 22 20 3 4s448ms 1s482ms May 23 20 3 4s214ms 1s404ms [ User: intelifix - Total duration: 30s989ms - Times executed: 21 ]
[ Application: pg_dump - Total duration: 30s989ms - Times executed: 21 ]
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-18 20:02:07 Duration: 1s815ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-22 20:09:18 Duration: 1s640ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-19 20:10:53 Duration: 1s609ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
15 19 3s481ms 150ms 348ms 183ms copy ceps2009.cep_bairros (id, uf, idloc, bairro) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration May 17 20 3 515ms 171ms May 18 20 3 713ms 237ms May 19 20 3 503ms 167ms May 20 20 3 512ms 170ms May 21 20 2 356ms 178ms May 22 20 2 330ms 165ms May 23 20 3 550ms 183ms [ User: intelifix - Total duration: 3s481ms - Times executed: 19 ]
[ Application: pg_dump - Total duration: 3s481ms - Times executed: 19 ]
-
COPY ceps2009.cep_bairros (id, uf, idloc, bairro) TO stdout;
Date: 2026-05-18 20:02:05 Duration: 348ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_bairros (id, uf, idloc, bairro) TO stdout;
Date: 2026-05-18 20:10:37 Duration: 197ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_bairros (id, uf, idloc, bairro) TO stdout;
Date: 2026-05-20 20:02:05 Duration: 196ms Database: rio User: intelifix Remote: [local] Application: pg_dump
16 17 6s658ms 164ms 731ms 391ms copy public.lotes (lot_id, lot_criacao, ofi_id, usu_id, cli_id, lot_tipo, lot_qtd_itens, mod_id, lot_data, lot_notafiscal, lot_qtd_cq, lot_lote_saida, arq_id, con_id, ss_id, lot_sem_serial, lot_status, lot_sucata, lot_novo, cli_original, nota_original, lot_preco_unit, lot_stone, lc_id) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 17 20 2 847ms 423ms May 18 20 2 981ms 490ms May 19 20 3 999ms 333ms May 20 20 3 1s122ms 374ms May 21 20 2 814ms 407ms May 22 20 2 800ms 400ms May 23 20 3 1s92ms 364ms [ User: intelifix - Total duration: 6s658ms - Times executed: 17 ]
[ Application: pg_dump - Total duration: 6s658ms - Times executed: 17 ]
-
COPY public.lotes (lot_id, lot_criacao, ofi_id, usu_id, cli_id, lot_tipo, lot_qtd_itens, mod_id, lot_data, lot_notafiscal, lot_qtd_cq, lot_lote_saida, arq_id, con_id, ss_id, lot_sem_serial, lot_status, lot_sucata, lot_novo, cli_original, nota_original, lot_preco_unit, lot_stone, lc_id) TO stdout;
Date: 2026-05-18 20:06:53 Duration: 731ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lotes (lot_id, lot_criacao, ofi_id, usu_id, cli_id, lot_tipo, lot_qtd_itens, mod_id, lot_data, lot_notafiscal, lot_qtd_cq, lot_lote_saida, arq_id, con_id, ss_id, lot_sem_serial, lot_status, lot_sucata, lot_novo, cli_original, nota_original, lot_preco_unit, lot_stone, lc_id) TO stdout;
Date: 2026-05-20 20:06:34 Duration: 611ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lotes (lot_id, lot_criacao, ofi_id, usu_id, cli_id, lot_tipo, lot_qtd_itens, mod_id, lot_data, lot_notafiscal, lot_qtd_cq, lot_lote_saida, arq_id, con_id, ss_id, lot_sem_serial, lot_status, lot_sucata, lot_novo, cli_original, nota_original, lot_preco_unit, lot_stone, lc_id) TO stdout;
Date: 2026-05-17 20:06:34 Duration: 576ms Database: rio User: intelifix Remote: [local] Application: pg_dump
17 16 14s381ms 200ms 1s768ms 898ms 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 #17
Day Hour Count Duration Avg duration May 17 20 3 2s230ms 743ms May 18 20 2 1s958ms 979ms May 19 20 2 1s863ms 931ms May 20 20 2 2s41ms 1s20ms May 21 20 2 2s215ms 1s107ms May 22 20 3 2s35ms 678ms May 23 20 2 2s36ms 1s18ms [ User: intelifix - Total duration: 14s381ms - Times executed: 16 ]
[ Application: pg_dump - Total duration: 14s381ms - Times executed: 16 ]
-
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-05-21 20:05:49 Duration: 1s768ms 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-05-23 20:05:55 Duration: 1s693ms 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-05-17 20:05:56 Duration: 1s675ms Database: rio User: intelifix Remote: [local] Application: pg_dump
18 14 10m52s 4s112ms 1m40s 46s588ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 17 20 2 1m30s 45s344ms May 18 20 2 1m45s 52s507ms May 19 20 2 1m26s 43s237ms May 20 20 2 1m34s 47s408ms May 21 20 2 1m30s 45s233ms May 22 20 2 1m27s 43s993ms May 23 20 2 1m36s 48s394ms [ User: intelifix - Total duration: 10m52s - Times executed: 14 ]
[ Application: pg_dump - Total duration: 10m52s - Times executed: 14 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-18 20:09:59 Duration: 1m40s 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-05-23 20:09:12 Duration: 1m32s 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-05-20 20:09:09 Duration: 1m29s Database: rio User: intelifix Remote: [local] Application: pg_dump
19 14 7m29s 442ms 1m9s 32s78ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration May 17 20 2 1m8s 34s407ms May 18 20 2 1m10s 35s246ms May 19 20 2 1m 30s212ms May 20 20 2 1m2s 31s499ms May 21 20 2 1m3s 31s603ms May 22 20 2 59s361ms 29s680ms May 23 20 2 1m3s 31s899ms [ User: intelifix - Total duration: 7m29s - Times executed: 14 ]
[ Application: pg_dump - Total duration: 7m29s - Times executed: 14 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-18 20:06:13 Duration: 1m9s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-17 20:05:55 Duration: 1m8s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-23 20:05:53 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: pg_dump
20 14 3m6s 3s272ms 24s943ms 13s287ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 17 20 2 26s610ms 13s305ms May 18 20 2 29s625ms 14s812ms May 19 20 2 24s174ms 12s87ms May 20 20 2 28s206ms 14s103ms May 21 20 2 24s610ms 12s305ms May 22 20 2 25s835ms 12s917ms May 23 20 2 26s963ms 13s481ms [ User: intelifix - Total duration: 3m6s - Times executed: 14 ]
[ Application: pg_dump - Total duration: 3m6s - Times executed: 14 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-05-18 20:05:03 Duration: 24s943ms 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-05-20 20:04:55 Duration: 23s831ms 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-05-23 20:04:50 Duration: 23s486ms Database: rio User: intelifix Remote: [local] Application: pg_dump
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 4s112ms 1m40s 46s588ms 14 10m52s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 17 20 2 1m30s 45s344ms May 18 20 2 1m45s 52s507ms May 19 20 2 1m26s 43s237ms May 20 20 2 1m34s 47s408ms May 21 20 2 1m30s 45s233ms May 22 20 2 1m27s 43s993ms May 23 20 2 1m36s 48s394ms [ User: intelifix - Total duration: 10m52s - Times executed: 14 ]
[ Application: pg_dump - Total duration: 10m52s - Times executed: 14 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-18 20:09:59 Duration: 1m40s 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-05-23 20:09:12 Duration: 1m32s 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-05-20 20:09:09 Duration: 1m29s Database: rio User: intelifix Remote: [local] Application: pg_dump
2 442ms 1m9s 32s78ms 14 7m29s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 17 20 2 1m8s 34s407ms May 18 20 2 1m10s 35s246ms May 19 20 2 1m 30s212ms May 20 20 2 1m2s 31s499ms May 21 20 2 1m3s 31s603ms May 22 20 2 59s361ms 29s680ms May 23 20 2 1m3s 31s899ms [ User: intelifix - Total duration: 7m29s - Times executed: 14 ]
[ Application: pg_dump - Total duration: 7m29s - Times executed: 14 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-18 20:06:13 Duration: 1m9s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-17 20:05:55 Duration: 1m8s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-23 20:05:53 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: pg_dump
3 2s76ms 38s277ms 16s198ms 21 5m40s 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 #3
Day Hour Count Duration Avg duration May 17 20 3 49s357ms 16s452ms May 18 20 3 52s285ms 17s428ms May 19 20 3 48s861ms 16s287ms May 20 20 3 47s523ms 15s841ms May 21 20 3 46s937ms 15s645ms May 22 20 3 47s175ms 15s725ms May 23 20 3 48s20ms 16s6ms [ User: intelifix - Total duration: 5m40s - Times executed: 21 ]
[ Application: pg_dump - Total duration: 5m40s - Times executed: 21 ]
-
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-05-18 20:06:53 Duration: 38s277ms 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-05-17 20:06:34 Duration: 37s219ms 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-05-19 20:06:18 Duration: 37s209ms Database: rio User: intelifix Remote: [local] Application: pg_dump
4 1s670ms 35s418ms 13s793ms 21 4m49s copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration May 17 20 3 40s551ms 13s517ms May 18 20 3 46s873ms 15s624ms May 19 20 3 40s994ms 13s664ms May 20 20 3 39s890ms 13s296ms May 21 20 3 41s441ms 13s813ms May 22 20 3 40s510ms 13s503ms May 23 20 3 39s392ms 13s130ms [ User: intelifix - Total duration: 4m49s - Times executed: 21 ]
[ Application: pg_dump - Total duration: 4m49s - Times executed: 21 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-18 20:07:32 Duration: 35s418ms 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-05-19 20:06:53 Duration: 31s638ms 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-05-17 20:07:08 Duration: 31s457ms Database: rio User: intelifix Remote: [local] Application: pg_dump
5 11s975ms 16s85ms 13s603ms 7 1m35s copy public.nf_entrada_itens (nem_id, serie, valor, li_id, modo, nea_id, tipo_local, lc_id, rede_msg, sub_modelo) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration May 17 20 1 14s343ms 14s343ms May 18 20 1 16s85ms 16s85ms May 19 20 1 13s332ms 13s332ms May 20 20 1 12s274ms 12s274ms May 21 20 1 14s33ms 14s33ms May 22 20 1 11s975ms 11s975ms May 23 20 1 13s180ms 13s180ms [ User: intelifix - Total duration: 1m35s - Times executed: 7 ]
[ Application: pg_dump - Total duration: 1m35s - Times executed: 7 ]
-
COPY public.nf_entrada_itens (nem_id, serie, valor, li_id, modo, nea_id, tipo_local, lc_id, rede_msg, sub_modelo) TO stdout;
Date: 2026-05-18 20:07:49 Duration: 16s85ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_itens (nem_id, serie, valor, li_id, modo, nea_id, tipo_local, lc_id, rede_msg, sub_modelo) TO stdout;
Date: 2026-05-17 20:07:22 Duration: 14s343ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_itens (nem_id, serie, valor, li_id, modo, nea_id, tipo_local, lc_id, rede_msg, sub_modelo) TO stdout;
Date: 2026-05-21 20:07:12 Duration: 14s33ms Database: rio User: intelifix Remote: [local] Application: pg_dump
6 3s229ms 33s916ms 13s465ms 21 4m42s 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 #6
Day Hour Count Duration Avg duration May 17 20 3 39s695ms 13s231ms May 18 20 3 45s866ms 15s288ms May 19 20 3 37s333ms 12s444ms May 20 20 3 38s203ms 12s734ms May 21 20 3 40s527ms 13s509ms May 22 20 3 38s49ms 12s683ms May 23 20 3 43s100ms 14s366ms [ User: intelifix - Total duration: 4m42s - Times executed: 21 ]
[ Application: pg_dump - Total duration: 4m42s - Times executed: 21 ]
-
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-05-18 20:10:33 Duration: 33s916ms 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-05-23 20:09:46 Duration: 32s759ms 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-05-21 20:09:30 Duration: 30s163ms Database: rio User: intelifix Remote: [local] Application: pg_dump
7 3s272ms 24s943ms 13s287ms 14 3m6s copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration May 17 20 2 26s610ms 13s305ms May 18 20 2 29s625ms 14s812ms May 19 20 2 24s174ms 12s87ms May 20 20 2 28s206ms 14s103ms May 21 20 2 24s610ms 12s305ms May 22 20 2 25s835ms 12s917ms May 23 20 2 26s963ms 13s481ms [ User: intelifix - Total duration: 3m6s - Times executed: 14 ]
[ Application: pg_dump - Total duration: 3m6s - Times executed: 14 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-05-18 20:05:03 Duration: 24s943ms 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-05-20 20:04:55 Duration: 23s831ms 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-05-23 20:04:50 Duration: 23s486ms Database: rio User: intelifix Remote: [local] Application: pg_dump
8 1s598ms 23s245ms 11s83ms 21 3m52s copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration May 17 20 3 33s730ms 11s243ms May 18 20 3 34s288ms 11s429ms May 19 20 3 32s712ms 10s904ms May 20 20 3 34s779ms 11s593ms May 21 20 3 32s682ms 10s894ms May 22 20 3 31s678ms 10s559ms May 23 20 3 32s872ms 10s957ms [ User: intelifix - Total duration: 3m52s - Times executed: 21 ]
[ Application: pg_dump - Total duration: 3m52s - Times executed: 21 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-20 20:02:49 Duration: 23s245ms 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-05-18 20:02:51 Duration: 23s163ms 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-05-19 20:02:48 Duration: 21s989ms Database: rio User: intelifix Remote: [local] Application: pg_dump
9 1s422ms 25s65ms 11s30ms 21 3m51s copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration May 17 20 3 32s132ms 10s710ms May 18 20 3 39s791ms 13s263ms May 19 20 3 30s652ms 10s217ms May 20 20 3 32s645ms 10s881ms May 21 20 3 33s502ms 11s167ms May 22 20 3 30s663ms 10s221ms May 23 20 3 32s256ms 10s752ms [ User: intelifix - Total duration: 3m51s - Times executed: 21 ]
[ Application: pg_dump - Total duration: 3m51s - Times executed: 21 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-18 20:03:33 Duration: 25s65ms 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-05-21 20:03:26 Duration: 23s139ms 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-05-20 20:03:27 Duration: 22s223ms Database: rio User: intelifix Remote: [local] Application: pg_dump
10 1s188ms 27s884ms 10s458ms 21 3m39s 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 #10
Day Hour Count Duration Avg duration May 17 20 3 31s322ms 10s440ms May 18 20 3 33s959ms 11s319ms May 19 20 3 29s997ms 9s999ms May 20 20 3 34s755ms 11s585ms May 21 20 3 29s274ms 9s758ms May 22 20 3 28s307ms 9s435ms May 23 20 3 32s14ms 10s671ms [ User: intelifix - Total duration: 3m39s - Times executed: 21 ]
[ Application: pg_dump - Total duration: 3m39s - Times executed: 21 ]
-
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-05-20 20:04:31 Duration: 27s884ms 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-05-18 20:04:38 Duration: 27s29ms 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-05-17 20:04:23 Duration: 25s641ms Database: rio User: intelifix Remote: [local] Application: pg_dump
11 1s171ms 17s349ms 8s5ms 21 2m48s 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 May 17 20 3 22s914ms 7s638ms May 18 20 3 25s674ms 8s558ms May 19 20 3 22s309ms 7s436ms May 20 20 3 24s24ms 8s8ms May 21 20 3 25s817ms 8s605ms May 22 20 3 22s23ms 7s341ms May 23 20 3 25s345ms 8s448ms [ User: intelifix - Total duration: 2m48s - Times executed: 21 ]
[ Application: pg_dump - Total duration: 2m48s - Times executed: 21 ]
-
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-05-23 20:03:43 Duration: 17s349ms 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-05-21 20:03:43 Duration: 17s192ms 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-05-18 20:03:50 Duration: 16s861ms Database: rio User: intelifix Remote: [local] Application: pg_dump
12 698ms 17s247ms 6s494ms 21 2m16s 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 May 17 20 3 20s396ms 6s798ms May 18 20 3 20s300ms 6s766ms May 19 20 3 18s703ms 6s234ms May 20 20 3 19s873ms 6s624ms May 21 20 3 18s850ms 6s283ms May 22 20 3 18s519ms 6s173ms May 23 20 3 19s742ms 6s580ms [ User: intelifix - Total duration: 2m16s - Times executed: 21 ]
[ Application: pg_dump - Total duration: 2m16s - Times executed: 21 ]
-
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-05-18 20:03:08 Duration: 17s247ms 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-05-17 20:03:04 Duration: 17s102ms 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-05-23 20:03:04 Duration: 15s980ms Database: rio User: intelifix Remote: [local] Application: pg_dump
13 293ms 15s117ms 5s702ms 14 1m19s copy public.tcia_lote_fluxos (tl_id, flu_id, criacao) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration May 17 20 2 11s578ms 5s789ms May 18 20 2 15s649ms 7s824ms May 19 20 2 10s867ms 5s433ms May 20 20 2 10s627ms 5s313ms May 21 20 2 10s269ms 5s134ms May 22 20 2 10s158ms 5s79ms May 23 20 2 10s679ms 5s339ms [ User: intelifix - Total duration: 1m19s - Times executed: 14 ]
[ Application: pg_dump - Total duration: 1m19s - Times executed: 14 ]
-
COPY public.tcia_lote_fluxos (tl_id, flu_id, criacao) TO stdout;
Date: 2026-05-18 20:08:18 Duration: 15s117ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lote_fluxos (tl_id, flu_id, criacao) TO stdout;
Date: 2026-05-17 20:07:46 Duration: 11s149ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lote_fluxos (tl_id, flu_id, criacao) TO stdout;
Date: 2026-05-19 20:07:28 Duration: 10s431ms Database: rio User: intelifix Remote: [local] Application: pg_dump
14 682ms 15s385ms 4s977ms 21 1m44s 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 #14
Day Hour Count Duration Avg duration May 17 20 3 13s531ms 4s510ms May 18 20 3 16s870ms 5s623ms May 19 20 3 13s641ms 4s547ms May 20 20 3 17s45ms 5s681ms May 21 20 3 14s676ms 4s892ms May 22 20 3 13s504ms 4s501ms May 23 20 3 15s247ms 5s82ms [ User: intelifix - Total duration: 1m44s - Times executed: 21 ]
[ Application: pg_dump - Total duration: 1m44s - Times executed: 21 ]
-
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-05-18 20:04:11 Duration: 15s385ms 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-05-20 20:04:04 Duration: 15s229ms 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-05-23 20:04:01 Duration: 13s544ms Database: rio User: intelifix Remote: [local] Application: pg_dump
15 2s66ms 7s375ms 4s768ms 21 1m40s 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 #15
Day Hour Count Duration Avg duration May 17 20 3 13s584ms 4s528ms May 18 20 3 16s982ms 5s660ms May 19 20 3 13s195ms 4s398ms May 20 20 3 14s805ms 4s935ms May 21 20 3 14s490ms 4s830ms May 22 20 3 12s525ms 4s175ms May 23 20 3 14s561ms 4s853ms [ User: intelifix - Total duration: 1m40s - Times executed: 21 ]
[ Application: pg_dump - Total duration: 1m40s - Times executed: 21 ]
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-05-18 20:08:01 Duration: 7s375ms 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-05-20 20:11:06 Duration: 6s903ms Database: brasilia 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-05-18 20:12:03 Duration: 6s824ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 663ms 11s301ms 4s688ms 21 1m38s 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 May 17 20 3 13s949ms 4s649ms May 18 20 3 15s69ms 5s23ms May 19 20 3 14s61ms 4s687ms May 20 20 3 14s300ms 4s766ms May 21 20 3 13s623ms 4s541ms May 22 20 3 13s179ms 4s393ms May 23 20 3 14s281ms 4s760ms [ User: intelifix - Total duration: 1m38s - Times executed: 21 ]
[ Application: pg_dump - Total duration: 1m38s - Times executed: 21 ]
-
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-05-18 20:02:24 Duration: 11s301ms 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-05-17 20:02:22 Duration: 11s120ms 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-05-19 20:02:23 Duration: 11s34ms Database: rio User: intelifix Remote: [local] Application: pg_dump
17 2s606ms 3s656ms 3s87ms 21 1m4s 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 May 17 20 3 8s945ms 2s981ms May 18 20 3 10s189ms 3s396ms May 19 20 3 8s908ms 2s969ms May 20 20 3 8s815ms 2s938ms May 21 20 3 9s865ms 3s288ms May 22 20 3 8s408ms 2s802ms May 23 20 3 9s712ms 3s237ms [ User: intelifix - Total duration: 1m4s - Times executed: 21 ]
[ Application: pg_dump - Total duration: 1m4s - Times executed: 21 ]
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-05-23 20:02:10 Duration: 3s656ms 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-05-21 20:02:11 Duration: 3s612ms 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-05-18 20:12:28 Duration: 3s570ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
18 780ms 4s330ms 2s394ms 14 33s521ms copy public.nf_entrada_itens (nem_id, serie, valor, li_id, modo, nea_id, tipo_local, data_conf, lc_id, rede_msg, sub_modelo) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 17 20 2 4s497ms 2s248ms May 18 20 2 4s967ms 2s483ms May 19 20 2 4s547ms 2s273ms May 20 20 2 5s411ms 2s705ms May 21 20 2 4s887ms 2s443ms May 22 20 2 4s391ms 2s195ms May 23 20 2 4s820ms 2s410ms [ User: intelifix - Total duration: 33s521ms - Times executed: 14 ]
[ Application: pg_dump - Total duration: 33s521ms - Times executed: 14 ]
-
COPY public.nf_entrada_itens (nem_id, serie, valor, li_id, modo, nea_id, tipo_local, data_conf, lc_id, rede_msg, sub_modelo) TO stdout;
Date: 2026-05-20 20:10:58 Duration: 4s330ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_itens (nem_id, serie, valor, li_id, modo, nea_id, tipo_local, data_conf, lc_id, rede_msg, sub_modelo) TO stdout;
Date: 2026-05-18 20:11:56 Duration: 3s964ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_itens (nem_id, serie, valor, li_id, modo, nea_id, tipo_local, data_conf, lc_id, rede_msg, sub_modelo) TO stdout;
Date: 2026-05-19 20:10:30 Duration: 3s766ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 322ms 5s434ms 2s368ms 21 49s737ms copy public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration May 17 20 3 6s441ms 2s147ms May 18 20 3 8s93ms 2s697ms May 19 20 3 6s823ms 2s274ms May 20 20 3 7s519ms 2s506ms May 21 20 3 7s751ms 2s583ms May 22 20 3 6s144ms 2s48ms May 23 20 3 6s963ms 2s321ms [ User: intelifix - Total duration: 49s737ms - Times executed: 21 ]
[ Application: pg_dump - Total duration: 49s737ms - Times executed: 21 ]
-
COPY public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) TO stdout;
Date: 2026-05-18 20:03:55 Duration: 5s434ms 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-05-20 20:03:48 Duration: 5s95ms 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-05-21 20:03:48 Duration: 4s936ms Database: rio User: intelifix Remote: [local] Application: pg_dump
20 1s318ms 1s815ms 1s475ms 21 30s989ms copy ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 17 20 3 4s324ms 1s441ms May 18 20 3 4s753ms 1s584ms May 19 20 3 4s459ms 1s486ms May 20 20 3 4s466ms 1s488ms May 21 20 3 4s321ms 1s440ms May 22 20 3 4s448ms 1s482ms May 23 20 3 4s214ms 1s404ms [ User: intelifix - Total duration: 30s989ms - Times executed: 21 ]
[ Application: pg_dump - Total duration: 30s989ms - Times executed: 21 ]
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-18 20:02:07 Duration: 1s815ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-22 20:09:18 Duration: 1s640ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-19 20:10:53 Duration: 1s609ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 224ms 1 224ms 224ms 224ms SELECT pro_id, pgp_sym_decrypt(nome, $1)::varchar, pgp_sym_decrypt(descricao, $1)::varchar, pgp_sym_decrypt(classe, $1)::varchar, pgp_sym_decrypt(php, $1)::varchar, pgp_sym_decrypt(extras, $1)::varchar from progs ORDER BY PRO_ID;Times Reported Time consuming prepare #1
Day Hour Count Duration Avg duration May 23 09 1 224ms 224ms [ User: lenon - Total duration: 482ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 482ms - Times executed: 1 ]
-
SELECT pro_id, pgp_sym_decrypt(nome, $1)::varchar, pgp_sym_decrypt(descricao, $1)::varchar, pgp_sym_decrypt(classe, $1)::varchar, pgp_sym_decrypt(php, $1)::varchar, pgp_sym_decrypt(extras, $1)::varchar from progs ORDER BY PRO_ID;
Date: 2026-05-18 09:23:07 Duration: 224ms Database: postgres User: rio Remote: lenon Application: [local] Queryid: [unknown]
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 1 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration May 18 09 1 0ms 0ms [ User: lenon - Total duration: 482ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 482ms - Times executed: 1 ]
-
;
Date: Duration: 0ms Database: postgres User: rio Remote: lenon Application: [local] Queryid: [unknown] parameters: $1 = '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3'
-
Events
Log levels
Key values
- 734 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 0 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
- 0 EVENTLOG entries
Events per 5 minutes
NO DATASET
Most Frequent Errors/Events
Key values
- 0 Max number of times the same event was reported
- 0 Total events found
Rank Times reported Error NO DATASET