pgBadger-
Global information
- Generated on Fri May 22 23:50:03 2026
- Log file: /usr/local/pgsql/data/log/serverlog-04.log, ..., /usr/local/pgsql/data/log/serverlog-26.log
- Parsed 230 log entries in 2s
- Log start from 2026-05-22 14:04:25 to 2026-05-22 20:11:09
-
Overview
Global Stats
- 38 Number of unique normalized queries
- 83 Number of queries
- 8m56s Total query duration
- 2026-05-22 20:02:02 First query
- 2026-05-22 20:11:09 Last query
- 4 queries/s at 2026-05-22 20:08:44 Query peak
- 8m56s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 8m56s 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
- 8 Total number of sessions
- 1 sessions at 2026-05-22 15:23:22 Session peak
- 4h15m8s Total duration of sessions
- 31m53s Average duration of sessions
- 10 Average queries per session
- 1m7s Average queries duration per session
- 30m46s Average idle time per session
- 8 Total number of connections
- 1 connections/s at 2026-05-22 15:23:22 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
- 1 queries/s Query Peak
- 2026-05-22 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
- 8m56s 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 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 Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) 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 Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) 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 Day Hour Prepare Bind Bind/Prepare Percentage of prepare 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% Day Hour Count Average / Second May 22 14 3 0.00/s 15 2 0.00/s 16 0 0.00/s 20 3 0.00/s Day Hour Count Average Duration Average idle time May 22 14 1 107ms 107ms 15 2 1h1m30s 1h1m30s 16 2 1h1m30s 1h1m30s 20 3 3m2s 3s692ms -
Connections
Established Connections
Key values
- 1 connections Connection Peak
- 2026-05-22 15:23:22 Date
Connections per database
Key values
- rio Main Database
- 8 connections Total
Connections per user
Key values
- intelifix Main User
- 8 connections Total
-
Sessions
Simultaneous sessions
Key values
- 1 sessions Session Peak
- 2026-05-22 15:23:22 Date
Histogram of session times
Key values
- 4 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 8 sessions Total
Sessions per user
Key values
- intelifix Main User
- 8 sessions Total
Sessions per host
Key values
- [local] Main Host
- 8 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 0 buffers Checkpoint Peak
- Date
- seconds Highest write time
- seconds Sync time
Checkpoint write buffers (5 minutes period)
NO DATASET
Checkpoints Wal files
Key values
- 0 files Wal files usage Peak
- Date
Checkpoint Wal files usage (5 minutes period)
NO DATASET
Checkpoints distance
Key values
- 0 Mo Distance Peak
- Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time May 22 14 0 0s 0s 0s 15 0 0s 0s 0s 16 0 0s 0s 0s 20 0 0s 0s 0s Day Hour Added Removed Recycled Synced files Longest sync Average sync 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 Day Hour Count Avg time (sec) May 22 14 0 0s 15 0 0s 16 0 0s 20 0 0s Day Hour Mean distance Mean estimate 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 -
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 22 14 0 0 0 15 0 0 0 16 0 0 0 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 22 14 0 0 15 0 0 16 0 0 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
- 1 Total read queries
- 82 Total write queries
Queries by database
Key values
- rio Main database
- 36 Requests
- 7m8s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 83 Requests
User Request type Count Duration intelifix Total 83 8m56s copy to 82 8m56s select 1 228ms Duration by user
Key values
- 8m56s (intelifix) Main time consuming user
User Request type Count Duration intelifix Total 83 8m56s copy to 82 8m56s select 1 228ms Queries by host
Key values
- [local] Main host
- 83 Requests
- 8m56s ([local])
- Main time consuming host
Queries by application
Key values
- pg_dump Main application
- 83 Requests
- 8m56s (pg_dump)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-05-22 20:09:24 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 39 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 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 ]
2 58s818ms COPY public.logs (mensagem, quando) TO stdout;[ Date: 2026-05-22 20:05:36 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
3 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 ]
4 31s435ms COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;[ Date: 2026-05-22 20:06:48 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
5 28s704ms 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-22 20:09:13 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
6 22s924ms 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-22 20:04:15 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
7 22s562ms COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;[ Date: 2026-05-22 20:04:37 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
8 20s982ms COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;[ Date: 2026-05-22 20:03:21 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
9 20s971ms COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;[ Date: 2026-05-22 20:02:45 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
10 15s231ms 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-22 20:03:00 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
11 14s226ms 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-22 20:03:36 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
12 12s93ms 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-22 20:03:52 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
13 11s975ms 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-22 20:07:00 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
14 10s198ms 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-22 20:02:21 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
15 9s817ms COPY public.tcia_lote_fluxos (tl_id, flu_id, criacao) TO stdout;[ Date: 2026-05-22 20:07:20 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
16 9s376ms 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:10:11 - Database: brasilia - User: intelifix - Remote: [local] - Application: pg_dump ]
17 8s943ms COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;[ Date: 2026-05-22 20:09:33 - Database: brasilia - User: intelifix - Remote: [local] - Application: pg_dump ]
18 8s259ms COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;[ Date: 2026-05-22 20:09:44 - Database: brasilia - User: intelifix - Remote: [local] - Application: pg_dump ]
19 7s404ms COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;[ Date: 2026-05-22 20:10:18 - Database: brasilia - User: intelifix - Remote: [local] - Application: pg_dump ]
20 6s473ms 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-22 20:09:50 - Database: brasilia - User: intelifix - Remote: [local] - Application: pg_dump ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1m27s 2 4s153ms 1m23s 43s993ms 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 22 20 2 1m27s 43s993ms [ User: intelifix - Total duration: 1m27s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m27s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-22 20:08:44 Duration: 1m23s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-22 20:10:33 Duration: 4s153ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
2 59s361ms 2 542ms 58s818ms 29s680ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 22 20 2 59s361ms 29s680ms [ User: intelifix - Total duration: 59s361ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 59s361ms - Times executed: 2 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-22 20:05:36 Duration: 58s818ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-22 20:10:01 Duration: 542ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
3 47s175ms 3 2s296ms 35s503ms 15s725ms 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 22 20 3 47s175ms 15s725ms [ User: intelifix - Total duration: 47s175ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 47s175ms - Times executed: 3 ]
-
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 Duration: 35s503ms 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-22 20:10:11 Duration: 9s376ms Database: brasilia 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-22 20:10:59 Duration: 2s296ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
4 40s510ms 3 1s670ms 31s435ms 13s503ms 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 22 20 3 40s510ms 13s503ms [ User: intelifix - Total duration: 40s510ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 40s510ms - Times executed: 3 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-22 20:06:48 Duration: 31s435ms 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-22 20:10:18 Duration: 7s404ms Database: brasilia 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-22 20:11:01 Duration: 1s670ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
5 38s49ms 3 3s229ms 28s704ms 12s683ms 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 22 20 3 38s49ms 12s683ms [ User: intelifix - Total duration: 38s49ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 38s49ms - Times executed: 3 ]
-
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-22 20:09:13 Duration: 28s704ms 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-22 20:10:39 Duration: 6s115ms Database: brasilia 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-22 20:11:08 Duration: 3s229ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
6 31s678ms 3 1s764ms 20s971ms 10s559ms 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 22 20 3 31s678ms 10s559ms [ User: intelifix - Total duration: 31s678ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 31s678ms - Times executed: 3 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-22 20:02:45 Duration: 20s971ms 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-22 20:09:33 Duration: 8s943ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-22 20:10:50 Duration: 1s764ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
7 30s663ms 3 1s422ms 20s982ms 10s221ms 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 22 20 3 30s663ms 10s221ms [ User: intelifix - Total duration: 30s663ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 30s663ms - Times executed: 3 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-22 20:03:21 Duration: 20s982ms 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-22 20:09:44 Duration: 8s259ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-22 20:10:52 Duration: 1s422ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
8 28s307ms 3 1s291ms 22s924ms 9s435ms 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 22 20 3 28s307ms 9s435ms [ User: intelifix - Total duration: 28s307ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 28s307ms - Times executed: 3 ]
-
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-22 20:04:15 Duration: 22s924ms 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-22 20:09:57 Duration: 4s90ms Database: brasilia 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-22 20:10:56 Duration: 1s291ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
9 25s835ms 2 3s272ms 22s562ms 12s917ms 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 22 20 2 25s835ms 12s917ms [ User: intelifix - Total duration: 25s835ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 25s835ms - Times executed: 2 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-05-22 20:04:37 Duration: 22s562ms 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-22 20:10:00 Duration: 3s272ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 22s23ms 3 1s324ms 14s226ms 7s341ms 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 22 20 3 22s23ms 7s341ms [ User: intelifix - Total duration: 22s23ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 22s23ms - Times executed: 3 ]
-
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-22 20:03:36 Duration: 14s226ms 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-22 20:09:50 Duration: 6s473ms Database: brasilia 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-22 20:10:54 Duration: 1s324ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
11 18s519ms 3 698ms 15s231ms 6s173ms 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 22 20 3 18s519ms 6s173ms [ User: intelifix - Total duration: 18s519ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 18s519ms - Times executed: 3 ]
-
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-22 20:03:00 Duration: 15s231ms 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-22 20:09:36 Duration: 2s589ms Database: brasilia 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-22 20:10:51 Duration: 698ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
12 13s504ms 3 682ms 12s93ms 4s501ms 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 22 20 3 13s504ms 4s501ms [ User: intelifix - Total duration: 13s504ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 13s504ms - Times executed: 3 ]
-
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-22 20:03:52 Duration: 12s93ms 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-22 20:10:55 Duration: 728ms Database: contagem 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-22 20:09:53 Duration: 682ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 13s179ms 3 862ms 10s198ms 4s393ms 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 #13
Day Hour Count Duration Avg duration May 22 20 3 13s179ms 4s393ms [ User: intelifix - Total duration: 13s179ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 13s179ms - Times executed: 3 ]
-
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-22 20:02:21 Duration: 10s198ms 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-22 20:09:23 Duration: 2s118ms Database: brasilia 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-22 20:10:48 Duration: 862ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
14 12s525ms 3 2s573ms 5s24ms 4s175ms 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 #14
Day Hour Count Duration Avg duration May 22 20 3 12s525ms 4s175ms [ User: intelifix - Total duration: 12s525ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 12s525ms - Times executed: 3 ]
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-05-22 20:10:27 Duration: 5s24ms 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-22 20:07:08 Duration: 4s927ms 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-22 20:11:04 Duration: 2s573ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
15 11s975ms 1 11s975ms 11s975ms 11s975ms 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 22 20 1 11s975ms 11s975ms [ User: intelifix - Total duration: 11s975ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 11s975ms - Times executed: 1 ]
-
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-22 20:07:00 Duration: 11s975ms Database: rio User: intelifix Remote: [local] Application: pg_dump
16 10s158ms 2 341ms 9s817ms 5s79ms 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 22 20 2 10s158ms 5s79ms [ User: intelifix - Total duration: 10s158ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 10s158ms - Times executed: 2 ]
-
COPY public.tcia_lote_fluxos (tl_id, flu_id, criacao) TO stdout;
Date: 2026-05-22 20:07:20 Duration: 9s817ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lote_fluxos (tl_id, flu_id, criacao) TO stdout;
Date: 2026-05-22 20:10:29 Duration: 341ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 8s408ms 3 2s606ms 3s192ms 2s802ms 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 22 20 3 8s408ms 2s802ms [ User: intelifix - Total duration: 8s408ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 8s408ms - Times executed: 3 ]
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-05-22 20:02:09 Duration: 3s192ms 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-22 20:10:47 Duration: 2s609ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-05-22 20:09:21 Duration: 2s606ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 6s144ms 3 471ms 3s997ms 2s48ms 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 22 20 3 6s144ms 2s48ms [ User: intelifix - Total duration: 6s144ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 6s144ms - Times executed: 3 ]
-
COPY public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) TO stdout;
Date: 2026-05-22 20:03:40 Duration: 3s997ms 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-22 20:09:52 Duration: 1s675ms Database: brasilia 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-22 20:10:54 Duration: 471ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
19 4s448ms 3 1s389ms 1s640ms 1s482ms copy ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration May 22 20 3 4s448ms 1s482ms [ User: intelifix - Total duration: 4s448ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 4s448ms - Times executed: 3 ]
-
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-22 20:02:06 Duration: 1s418ms 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:10:45 Duration: 1s389ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
20 4s391ms 2 953ms 3s438ms 2s195ms 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 #20
Day Hour Count Duration Avg duration May 22 20 2 4s391ms 2s195ms [ User: intelifix - Total duration: 4s391ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 4s391ms - Times executed: 2 ]
-
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-22 20:10:22 Duration: 3s438ms 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-22 20:11:02 Duration: 953ms 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 3 47s175ms 2s296ms 35s503ms 15s725ms 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 22 20 3 47s175ms 15s725ms [ User: intelifix - Total duration: 47s175ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 47s175ms - Times executed: 3 ]
-
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 Duration: 35s503ms 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-22 20:10:11 Duration: 9s376ms Database: brasilia 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-22 20:10:59 Duration: 2s296ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
2 3 40s510ms 1s670ms 31s435ms 13s503ms 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 22 20 3 40s510ms 13s503ms [ User: intelifix - Total duration: 40s510ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 40s510ms - Times executed: 3 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-22 20:06:48 Duration: 31s435ms 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-22 20:10:18 Duration: 7s404ms Database: brasilia 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-22 20:11:01 Duration: 1s670ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
3 3 38s49ms 3s229ms 28s704ms 12s683ms 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 22 20 3 38s49ms 12s683ms [ User: intelifix - Total duration: 38s49ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 38s49ms - Times executed: 3 ]
-
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-22 20:09:13 Duration: 28s704ms 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-22 20:10:39 Duration: 6s115ms Database: brasilia 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-22 20:11:08 Duration: 3s229ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
4 3 31s678ms 1s764ms 20s971ms 10s559ms 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 22 20 3 31s678ms 10s559ms [ User: intelifix - Total duration: 31s678ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 31s678ms - Times executed: 3 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-22 20:02:45 Duration: 20s971ms 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-22 20:09:33 Duration: 8s943ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-22 20:10:50 Duration: 1s764ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
5 3 30s663ms 1s422ms 20s982ms 10s221ms 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 22 20 3 30s663ms 10s221ms [ User: intelifix - Total duration: 30s663ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 30s663ms - Times executed: 3 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-22 20:03:21 Duration: 20s982ms 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-22 20:09:44 Duration: 8s259ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-22 20:10:52 Duration: 1s422ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
6 3 28s307ms 1s291ms 22s924ms 9s435ms 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 22 20 3 28s307ms 9s435ms [ User: intelifix - Total duration: 28s307ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 28s307ms - Times executed: 3 ]
-
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-22 20:04:15 Duration: 22s924ms 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-22 20:09:57 Duration: 4s90ms Database: brasilia 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-22 20:10:56 Duration: 1s291ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
7 3 22s23ms 1s324ms 14s226ms 7s341ms 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 22 20 3 22s23ms 7s341ms [ User: intelifix - Total duration: 22s23ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 22s23ms - Times executed: 3 ]
-
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-22 20:03:36 Duration: 14s226ms 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-22 20:09:50 Duration: 6s473ms Database: brasilia 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-22 20:10:54 Duration: 1s324ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
8 3 18s519ms 698ms 15s231ms 6s173ms 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 22 20 3 18s519ms 6s173ms [ User: intelifix - Total duration: 18s519ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 18s519ms - Times executed: 3 ]
-
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-22 20:03:00 Duration: 15s231ms 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-22 20:09:36 Duration: 2s589ms Database: brasilia 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-22 20:10:51 Duration: 698ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
9 3 13s504ms 682ms 12s93ms 4s501ms 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 22 20 3 13s504ms 4s501ms [ User: intelifix - Total duration: 13s504ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 13s504ms - Times executed: 3 ]
-
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-22 20:03:52 Duration: 12s93ms 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-22 20:10:55 Duration: 728ms Database: contagem 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-22 20:09:53 Duration: 682ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 3 13s179ms 862ms 10s198ms 4s393ms 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 #10
Day Hour Count Duration Avg duration May 22 20 3 13s179ms 4s393ms [ User: intelifix - Total duration: 13s179ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 13s179ms - Times executed: 3 ]
-
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-22 20:02:21 Duration: 10s198ms 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-22 20:09:23 Duration: 2s118ms Database: brasilia 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-22 20:10:48 Duration: 862ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
11 3 12s525ms 2s573ms 5s24ms 4s175ms 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 #11
Day Hour Count Duration Avg duration May 22 20 3 12s525ms 4s175ms [ User: intelifix - Total duration: 12s525ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 12s525ms - Times executed: 3 ]
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-05-22 20:10:27 Duration: 5s24ms 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-22 20:07:08 Duration: 4s927ms 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-22 20:11:04 Duration: 2s573ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
12 3 8s408ms 2s606ms 3s192ms 2s802ms 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 22 20 3 8s408ms 2s802ms [ User: intelifix - Total duration: 8s408ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 8s408ms - Times executed: 3 ]
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-05-22 20:02:09 Duration: 3s192ms 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-22 20:10:47 Duration: 2s609ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-05-22 20:09:21 Duration: 2s606ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 3 6s144ms 471ms 3s997ms 2s48ms 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 22 20 3 6s144ms 2s48ms [ User: intelifix - Total duration: 6s144ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 6s144ms - Times executed: 3 ]
-
COPY public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) TO stdout;
Date: 2026-05-22 20:03:40 Duration: 3s997ms 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-22 20:09:52 Duration: 1s675ms Database: brasilia 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-22 20:10:54 Duration: 471ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
14 3 4s448ms 1s389ms 1s640ms 1s482ms 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 22 20 3 4s448ms 1s482ms [ User: intelifix - Total duration: 4s448ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 4s448ms - Times executed: 3 ]
-
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-22 20:02:06 Duration: 1s418ms 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:10:45 Duration: 1s389ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
15 3 2s35ms 207ms 1s417ms 678ms 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 #15
Day Hour Count Duration Avg duration May 22 20 3 2s35ms 678ms [ User: intelifix - Total duration: 2s35ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 2s35ms - Times executed: 3 ]
-
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-22 20:05:38 Duration: 1s417ms 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-22 20:10:01 Duration: 410ms Database: brasilia 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-22 20:10:56 Duration: 207ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
16 2 1m27s 4s153ms 1m23s 43s993ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 22 20 2 1m27s 43s993ms [ User: intelifix - Total duration: 1m27s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m27s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-22 20:08:44 Duration: 1m23s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-22 20:10:33 Duration: 4s153ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 2 59s361ms 542ms 58s818ms 29s680ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration May 22 20 2 59s361ms 29s680ms [ User: intelifix - Total duration: 59s361ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 59s361ms - Times executed: 2 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-22 20:05:36 Duration: 58s818ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-22 20:10:01 Duration: 542ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 2 25s835ms 3s272ms 22s562ms 12s917ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 22 20 2 25s835ms 12s917ms [ User: intelifix - Total duration: 25s835ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 25s835ms - Times executed: 2 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-05-22 20:04:37 Duration: 22s562ms 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-22 20:10:00 Duration: 3s272ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 2 10s158ms 341ms 9s817ms 5s79ms copy public.tcia_lote_fluxos (tl_id, flu_id, criacao) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration May 22 20 2 10s158ms 5s79ms [ User: intelifix - Total duration: 10s158ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 10s158ms - Times executed: 2 ]
-
COPY public.tcia_lote_fluxos (tl_id, flu_id, criacao) TO stdout;
Date: 2026-05-22 20:07:20 Duration: 9s817ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lote_fluxos (tl_id, flu_id, criacao) TO stdout;
Date: 2026-05-22 20:10:29 Duration: 341ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 2 4s391ms 953ms 3s438ms 2s195ms 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 #20
Day Hour Count Duration Avg duration May 22 20 2 4s391ms 2s195ms [ User: intelifix - Total duration: 4s391ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 4s391ms - Times executed: 2 ]
-
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-22 20:10:22 Duration: 3s438ms 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-22 20:11:02 Duration: 953ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 4s153ms 1m23s 43s993ms 2 1m27s 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 22 20 2 1m27s 43s993ms [ User: intelifix - Total duration: 1m27s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m27s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-22 20:08:44 Duration: 1m23s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-22 20:10:33 Duration: 4s153ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
2 542ms 58s818ms 29s680ms 2 59s361ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 22 20 2 59s361ms 29s680ms [ User: intelifix - Total duration: 59s361ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 59s361ms - Times executed: 2 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-22 20:05:36 Duration: 58s818ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-22 20:10:01 Duration: 542ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
3 2s296ms 35s503ms 15s725ms 3 47s175ms 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 22 20 3 47s175ms 15s725ms [ User: intelifix - Total duration: 47s175ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 47s175ms - Times executed: 3 ]
-
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 Duration: 35s503ms 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-22 20:10:11 Duration: 9s376ms Database: brasilia 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-22 20:10:59 Duration: 2s296ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
4 1s670ms 31s435ms 13s503ms 3 40s510ms 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 22 20 3 40s510ms 13s503ms [ User: intelifix - Total duration: 40s510ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 40s510ms - Times executed: 3 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-22 20:06:48 Duration: 31s435ms 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-22 20:10:18 Duration: 7s404ms Database: brasilia 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-22 20:11:01 Duration: 1s670ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
5 3s272ms 22s562ms 12s917ms 2 25s835ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration May 22 20 2 25s835ms 12s917ms [ User: intelifix - Total duration: 25s835ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 25s835ms - Times executed: 2 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-05-22 20:04:37 Duration: 22s562ms 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-22 20:10:00 Duration: 3s272ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 3s229ms 28s704ms 12s683ms 3 38s49ms 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 22 20 3 38s49ms 12s683ms [ User: intelifix - Total duration: 38s49ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 38s49ms - Times executed: 3 ]
-
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-22 20:09:13 Duration: 28s704ms 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-22 20:10:39 Duration: 6s115ms Database: brasilia 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-22 20:11:08 Duration: 3s229ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
7 11s975ms 11s975ms 11s975ms 1 11s975ms 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 #7
Day Hour Count Duration Avg duration May 22 20 1 11s975ms 11s975ms [ User: intelifix - Total duration: 11s975ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 11s975ms - Times executed: 1 ]
-
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-22 20:07:00 Duration: 11s975ms Database: rio User: intelifix Remote: [local] Application: pg_dump
8 1s764ms 20s971ms 10s559ms 3 31s678ms 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 22 20 3 31s678ms 10s559ms [ User: intelifix - Total duration: 31s678ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 31s678ms - Times executed: 3 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-22 20:02:45 Duration: 20s971ms 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-22 20:09:33 Duration: 8s943ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-22 20:10:50 Duration: 1s764ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
9 1s422ms 20s982ms 10s221ms 3 30s663ms 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 22 20 3 30s663ms 10s221ms [ User: intelifix - Total duration: 30s663ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 30s663ms - Times executed: 3 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-22 20:03:21 Duration: 20s982ms 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-22 20:09:44 Duration: 8s259ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-22 20:10:52 Duration: 1s422ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
10 1s291ms 22s924ms 9s435ms 3 28s307ms 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 22 20 3 28s307ms 9s435ms [ User: intelifix - Total duration: 28s307ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 28s307ms - Times executed: 3 ]
-
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-22 20:04:15 Duration: 22s924ms 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-22 20:09:57 Duration: 4s90ms Database: brasilia 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-22 20:10:56 Duration: 1s291ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
11 1s324ms 14s226ms 7s341ms 3 22s23ms 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 22 20 3 22s23ms 7s341ms [ User: intelifix - Total duration: 22s23ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 22s23ms - Times executed: 3 ]
-
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-22 20:03:36 Duration: 14s226ms 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-22 20:09:50 Duration: 6s473ms Database: brasilia 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-22 20:10:54 Duration: 1s324ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
12 698ms 15s231ms 6s173ms 3 18s519ms 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 22 20 3 18s519ms 6s173ms [ User: intelifix - Total duration: 18s519ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 18s519ms - Times executed: 3 ]
-
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-22 20:03:00 Duration: 15s231ms 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-22 20:09:36 Duration: 2s589ms Database: brasilia 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-22 20:10:51 Duration: 698ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
13 341ms 9s817ms 5s79ms 2 10s158ms 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 22 20 2 10s158ms 5s79ms [ User: intelifix - Total duration: 10s158ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 10s158ms - Times executed: 2 ]
-
COPY public.tcia_lote_fluxos (tl_id, flu_id, criacao) TO stdout;
Date: 2026-05-22 20:07:20 Duration: 9s817ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lote_fluxos (tl_id, flu_id, criacao) TO stdout;
Date: 2026-05-22 20:10:29 Duration: 341ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 682ms 12s93ms 4s501ms 3 13s504ms 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 22 20 3 13s504ms 4s501ms [ User: intelifix - Total duration: 13s504ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 13s504ms - Times executed: 3 ]
-
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-22 20:03:52 Duration: 12s93ms 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-22 20:10:55 Duration: 728ms Database: contagem 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-22 20:09:53 Duration: 682ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 862ms 10s198ms 4s393ms 3 13s179ms 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 #15
Day Hour Count Duration Avg duration May 22 20 3 13s179ms 4s393ms [ User: intelifix - Total duration: 13s179ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 13s179ms - Times executed: 3 ]
-
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-22 20:02:21 Duration: 10s198ms 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-22 20:09:23 Duration: 2s118ms Database: brasilia 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-22 20:10:48 Duration: 862ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
16 2s573ms 5s24ms 4s175ms 3 12s525ms 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 #16
Day Hour Count Duration Avg duration May 22 20 3 12s525ms 4s175ms [ User: intelifix - Total duration: 12s525ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 12s525ms - Times executed: 3 ]
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-05-22 20:10:27 Duration: 5s24ms 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-22 20:07:08 Duration: 4s927ms 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-22 20:11:04 Duration: 2s573ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
17 2s606ms 3s192ms 2s802ms 3 8s408ms 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 22 20 3 8s408ms 2s802ms [ User: intelifix - Total duration: 8s408ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 8s408ms - Times executed: 3 ]
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-05-22 20:02:09 Duration: 3s192ms 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-22 20:10:47 Duration: 2s609ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-05-22 20:09:21 Duration: 2s606ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 953ms 3s438ms 2s195ms 2 4s391ms 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 22 20 2 4s391ms 2s195ms [ User: intelifix - Total duration: 4s391ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 4s391ms - Times executed: 2 ]
-
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-22 20:10:22 Duration: 3s438ms 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-22 20:11:02 Duration: 953ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
19 471ms 3s997ms 2s48ms 3 6s144ms 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 22 20 3 6s144ms 2s48ms [ User: intelifix - Total duration: 6s144ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 6s144ms - Times executed: 3 ]
-
COPY public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) TO stdout;
Date: 2026-05-22 20:03:40 Duration: 3s997ms 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-22 20:09:52 Duration: 1s675ms Database: brasilia 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-22 20:10:54 Duration: 471ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
20 1s389ms 1s640ms 1s482ms 3 4s448ms 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 22 20 3 4s448ms 1s482ms [ User: intelifix - Total duration: 4s448ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 4s448ms - Times executed: 3 ]
-
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-22 20:02:06 Duration: 1s418ms 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:10:45 Duration: 1s389ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
-
Events
Log levels
Key values
- 115 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