pgBadger-
Global information
- Generated on Sun May 17 23:50:03 2026
- Log file: /usr/local/pgsql/data/log/serverlog-04.log, ..., /usr/local/pgsql/data/log/serverlog-26.log
- Parsed 196 log entries in 2s
- Log start from 2026-05-17 20:02:01 to 2026-05-17 20:11:44
-
Overview
Global Stats
- 39 Number of unique normalized queries
- 86 Number of queries
- 9m31s Total query duration
- 2026-05-17 20:02:02 First query
- 2026-05-17 20:11:44 Last query
- 4 queries/s at 2026-05-17 20:09:12 Query peak
- 9m31s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 9m31s 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
- 3 Total number of sessions
- 0 sessions at Session peak
- 9m42s Total duration of sessions
- 3m14s Average duration of sessions
- 28 Average queries per session
- 3m10s Average queries duration per session
- 3s758ms Average idle time per session
- 3 Total number of connections
- 1 connections/s at 2026-05-17 20:02:01 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 4 queries/s Query Peak
- 2026-05-17 20:09:12 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-17 20:09:12 Date
Queries duration
Key values
- 9m31s 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 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 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 Day Hour Prepare Bind Bind/Prepare Percentage of prepare May 17 20 0 0 0.00 0.00% Day Hour Count Average / Second May 17 20 3 0.00/s Day Hour Count Average Duration Average idle time May 17 20 3 3m14s 3s758ms -
Connections
Established Connections
Key values
- 1 connections Connection Peak
- 2026-05-17 20:02:01 Date
Connections per database
Key values
- brasilia Main Database
- 3 connections Total
Connections per user
Key values
- intelifix Main User
- 3 connections Total
-
Sessions
Simultaneous sessions
Key values
- 0 sessions Session Peak
- Date
Histogram of session times
Key values
- 2 60000-600000ms duration
Sessions per database
Key values
- brasilia Main Database
- 3 sessions Total
Sessions per user
Key values
- intelifix Main User
- 3 sessions Total
Sessions per host
Key values
- [local] Main Host
- 3 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 17 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 Day Hour Count Avg time (sec) May 17 20 0 0s Day Hour Mean distance Mean estimate May 17 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 -
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 - 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
- 4 Total read queries
- 82 Total write queries
Queries by database
Key values
- rio Main database
- 37 Requests
- 7m36s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 86 Requests
User Request type Count Duration intelifix Total 86 9m31s copy to 82 9m30s select 4 712ms Duration by user
Key values
- 9m31s (intelifix) Main time consuming user
User Request type Count Duration intelifix Total 86 9m31s copy to 82 9m30s select 4 712ms Queries by host
Key values
- [local] Main host
- 86 Requests
- 9m31s ([local])
- Main time consuming host
Queries by application
Key values
- pg_dump Main application
- 86 Requests
- 9m31s (pg_dump)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-05-17 20:03:04 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 36 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 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 ]
2 1m8s COPY public.logs (mensagem, quando) TO stdout;[ Date: 2026-05-17 20:05:55 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
3 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 ]
4 31s457ms COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;[ Date: 2026-05-17 20:07:08 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
5 29s494ms 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-17 20:09:42 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
6 25s641ms 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 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
7 22s945ms COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;[ Date: 2026-05-17 20:04:46 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
8 21s871ms COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;[ Date: 2026-05-17 20:02:47 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
9 21s735ms COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;[ Date: 2026-05-17 20:03:26 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
10 17s102ms 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 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
11 15s206ms 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-17 20:03:41 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
12 14s343ms 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 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
13 12s85ms 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-17 20:03:58 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
14 11s149ms COPY public.tcia_lote_fluxos (tl_id, flu_id, criacao) TO stdout;[ Date: 2026-05-17 20:07:46 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
15 11s120ms 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 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
16 10s238ms COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;[ Date: 2026-05-17 20:10:04 - Database: brasilia - User: intelifix - Remote: [local] - Application: pg_dump ]
17 10s61ms 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:10:44 - Database: brasilia - User: intelifix - Remote: [local] - Application: pg_dump ]
18 8s968ms COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;[ Date: 2026-05-17 20:10:16 - Database: brasilia - User: intelifix - Remote: [local] - Application: pg_dump ]
19 7s257ms COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;[ Date: 2026-05-17 20:10:52 - Database: brasilia - User: intelifix - Remote: [local] - Application: pg_dump ]
20 6s604ms 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-17 20:11:14 - 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 1m30s 2 4s472ms 1m26s 45s344ms 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 [ User: intelifix - Total duration: 1m30s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m30s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-17 20:09:12 Duration: 1m26s 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-17 20:11:07 Duration: 4s472ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
2 1m8s 2 558ms 1m8s 34s407ms 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 [ User: intelifix - Total duration: 1m8s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m8s - Times executed: 2 ]
-
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-17 20:10:33 Duration: 558ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
3 49s357ms 3 2s76ms 37s219ms 16s452ms 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 [ User: intelifix - Total duration: 49s357ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 49s357ms - 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-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-17 20:10:44 Duration: 10s61ms 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-17 20:11:33 Duration: 2s76ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
4 40s551ms 3 1s836ms 31s457ms 13s517ms 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 [ User: intelifix - Total duration: 40s551ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 40s551ms - Times executed: 3 ]
-
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
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-17 20:10:52 Duration: 7s257ms 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-17 20:11:35 Duration: 1s836ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
5 39s695ms 3 3s595ms 29s494ms 13s231ms 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 [ User: intelifix - Total duration: 39s695ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 39s695ms - 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-17 20:09:42 Duration: 29s494ms 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-17 20:11:14 Duration: 6s604ms 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-17 20:11:42 Duration: 3s595ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
6 33s730ms 3 1s620ms 21s871ms 11s243ms 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 [ User: intelifix - Total duration: 33s730ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 33s730ms - Times executed: 3 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-17 20:02:47 Duration: 21s871ms 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-17 20:10:04 Duration: 10s238ms 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-17 20:11:24 Duration: 1s620ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
7 32s132ms 3 1s429ms 21s735ms 10s710ms 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 [ User: intelifix - Total duration: 32s132ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 32s132ms - Times executed: 3 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-17 20:03:26 Duration: 21s735ms 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-17 20:10:16 Duration: 8s968ms 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-17 20:11:27 Duration: 1s429ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
8 31s322ms 3 1s233ms 25s641ms 10s440ms 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 [ User: intelifix - Total duration: 31s322ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 31s322ms - 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-17 20:04:23 Duration: 25s641ms 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:10:29 Duration: 4s448ms 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-17 20:11:30 Duration: 1s233ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
9 26s610ms 2 3s664ms 22s945ms 13s305ms 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 [ User: intelifix - Total duration: 26s610ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 26s610ms - Times executed: 2 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-05-17 20:04:46 Duration: 22s945ms 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-17 20:10:33 Duration: 3s664ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 22s914ms 3 1s171ms 15s206ms 7s638ms 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 [ User: intelifix - Total duration: 22s914ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 22s914ms - 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-17 20:03:41 Duration: 15s206ms 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-17 20:10:22 Duration: 6s537ms 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-17 20:11:28 Duration: 1s171ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
11 20s396ms 3 738ms 17s102ms 6s798ms 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 [ User: intelifix - Total duration: 20s396ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 20s396ms - 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-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-17 20:10:07 Duration: 2s555ms 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-17 20:11:25 Duration: 738ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
12 14s343ms 1 14s343ms 14s343ms 14s343ms 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 #12
Day Hour Count Duration Avg duration May 17 20 1 14s343ms 14s343ms [ User: intelifix - Total duration: 14s343ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 14s343ms - 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-17 20:07:22 Duration: 14s343ms Database: rio User: intelifix Remote: [local] Application: pg_dump
13 13s949ms 3 663ms 11s120ms 4s649ms 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 17 20 3 13s949ms 4s649ms [ User: intelifix - Total duration: 13s949ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 13s949ms - 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-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-17 20:09:53 Duration: 2s164ms 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-17 20:11:23 Duration: 663ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
14 13s584ms 3 2s814ms 5s544ms 4s528ms 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 17 20 3 13s584ms 4s528ms [ User: intelifix - Total duration: 13s584ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 13s584ms - 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-17 20:07:32 Duration: 5s544ms 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-17 20:11:01 Duration: 5s226ms 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-17 20:11:39 Duration: 2s814ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
15 13s531ms 3 711ms 12s85ms 4s510ms copy public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration May 17 20 3 13s531ms 4s510ms [ User: intelifix - Total duration: 13s531ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 13s531ms - 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-17 20:03:58 Duration: 12s85ms 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-17 20:11:29 Duration: 734ms 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-17 20:10:25 Duration: 711ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 11s578ms 2 428ms 11s149ms 5s789ms 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 [ User: intelifix - Total duration: 11s578ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 11s578ms - Times executed: 2 ]
-
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-17 20:11:03 Duration: 428ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 8s945ms 3 2s695ms 3s270ms 2s981ms 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 [ User: intelifix - Total duration: 8s945ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 8s945ms - Times executed: 3 ]
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-05-17 20:09:50 Duration: 3s270ms Database: brasilia 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-17 20:02:09 Duration: 2s979ms 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-17 20:11:22 Duration: 2s695ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
18 6s441ms 3 438ms 4s308ms 2s147ms 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 [ User: intelifix - Total duration: 6s441ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 6s441ms - 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-17 20:03:46 Duration: 4s308ms 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-17 20:10:24 Duration: 1s694ms 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-17 20:11:28 Duration: 438ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
19 4s497ms 2 972ms 3s524ms 2s248ms 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 [ User: intelifix - Total duration: 4s497ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 4s497ms - 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-17 20:10:55 Duration: 3s524ms 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-17 20:11:36 Duration: 972ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
20 4s324ms 3 1s405ms 1s489ms 1s441ms 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 [ User: intelifix - Total duration: 4s324ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 4s324ms - Times executed: 3 ]
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-17 20:09:47 Duration: 1s489ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-17 20:11:19 Duration: 1s429ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-17 20:02:06 Duration: 1s405ms Database: rio User: intelifix Remote: [local] Application: pg_dump
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 3 49s357ms 2s76ms 37s219ms 16s452ms 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 [ User: intelifix - Total duration: 49s357ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 49s357ms - 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-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-17 20:10:44 Duration: 10s61ms 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-17 20:11:33 Duration: 2s76ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
2 3 40s551ms 1s836ms 31s457ms 13s517ms 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 [ User: intelifix - Total duration: 40s551ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 40s551ms - Times executed: 3 ]
-
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
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-17 20:10:52 Duration: 7s257ms 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-17 20:11:35 Duration: 1s836ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
3 3 39s695ms 3s595ms 29s494ms 13s231ms 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 [ User: intelifix - Total duration: 39s695ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 39s695ms - 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-17 20:09:42 Duration: 29s494ms 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-17 20:11:14 Duration: 6s604ms 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-17 20:11:42 Duration: 3s595ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
4 3 33s730ms 1s620ms 21s871ms 11s243ms 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 [ User: intelifix - Total duration: 33s730ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 33s730ms - Times executed: 3 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-17 20:02:47 Duration: 21s871ms 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-17 20:10:04 Duration: 10s238ms 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-17 20:11:24 Duration: 1s620ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
5 3 32s132ms 1s429ms 21s735ms 10s710ms 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 [ User: intelifix - Total duration: 32s132ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 32s132ms - Times executed: 3 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-17 20:03:26 Duration: 21s735ms 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-17 20:10:16 Duration: 8s968ms 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-17 20:11:27 Duration: 1s429ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
6 3 31s322ms 1s233ms 25s641ms 10s440ms 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 [ User: intelifix - Total duration: 31s322ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 31s322ms - 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-17 20:04:23 Duration: 25s641ms 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:10:29 Duration: 4s448ms 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-17 20:11:30 Duration: 1s233ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
7 3 22s914ms 1s171ms 15s206ms 7s638ms 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 [ User: intelifix - Total duration: 22s914ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 22s914ms - 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-17 20:03:41 Duration: 15s206ms 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-17 20:10:22 Duration: 6s537ms 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-17 20:11:28 Duration: 1s171ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
8 3 20s396ms 738ms 17s102ms 6s798ms 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 [ User: intelifix - Total duration: 20s396ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 20s396ms - 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-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-17 20:10:07 Duration: 2s555ms 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-17 20:11:25 Duration: 738ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
9 3 13s949ms 663ms 11s120ms 4s649ms 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 #9
Day Hour Count Duration Avg duration May 17 20 3 13s949ms 4s649ms [ User: intelifix - Total duration: 13s949ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 13s949ms - 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-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-17 20:09:53 Duration: 2s164ms 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-17 20:11:23 Duration: 663ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
10 3 13s584ms 2s814ms 5s544ms 4s528ms 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 [ User: intelifix - Total duration: 13s584ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 13s584ms - 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-17 20:07:32 Duration: 5s544ms 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-17 20:11:01 Duration: 5s226ms 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-17 20:11:39 Duration: 2s814ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
11 3 13s531ms 711ms 12s85ms 4s510ms 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 #11
Day Hour Count Duration Avg duration May 17 20 3 13s531ms 4s510ms [ User: intelifix - Total duration: 13s531ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 13s531ms - 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-17 20:03:58 Duration: 12s85ms 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-17 20:11:29 Duration: 734ms 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-17 20:10:25 Duration: 711ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 3 8s945ms 2s695ms 3s270ms 2s981ms 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 [ User: intelifix - Total duration: 8s945ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 8s945ms - Times executed: 3 ]
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-05-17 20:09:50 Duration: 3s270ms Database: brasilia 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-17 20:02:09 Duration: 2s979ms 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-17 20:11:22 Duration: 2s695ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
13 3 6s441ms 438ms 4s308ms 2s147ms 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 [ User: intelifix - Total duration: 6s441ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 6s441ms - 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-17 20:03:46 Duration: 4s308ms 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-17 20:10:24 Duration: 1s694ms 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-17 20:11:28 Duration: 438ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
14 3 4s324ms 1s405ms 1s489ms 1s441ms 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 [ User: intelifix - Total duration: 4s324ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 4s324ms - Times executed: 3 ]
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-17 20:09:47 Duration: 1s489ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-17 20:11:19 Duration: 1s429ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-17 20:02:06 Duration: 1s405ms Database: rio User: intelifix Remote: [local] Application: pg_dump
15 3 2s230ms 200ms 1s675ms 743ms 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 17 20 3 2s230ms 743ms [ User: intelifix - Total duration: 2s230ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 2s230ms - 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-17 20:05:56 Duration: 1s675ms 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:10:34 Duration: 354ms 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-17 20:11:30 Duration: 200ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
16 3 515ms 168ms 177ms 171ms copy ceps2009.cep_bairros (id, uf, idloc, bairro) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 17 20 3 515ms 171ms [ User: intelifix - Total duration: 515ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 515ms - Times executed: 3 ]
-
COPY ceps2009.cep_bairros (id, uf, idloc, bairro) TO stdout;
Date: 2026-05-17 20:02:04 Duration: 177ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_bairros (id, uf, idloc, bairro) TO stdout;
Date: 2026-05-17 20:09:45 Duration: 169ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_bairros (id, uf, idloc, bairro) TO stdout;
Date: 2026-05-17 20:11:18 Duration: 168ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
17 2 1m30s 4s472ms 1m26s 45s344ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration May 17 20 2 1m30s 45s344ms [ User: intelifix - Total duration: 1m30s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m30s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-17 20:09:12 Duration: 1m26s 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-17 20:11:07 Duration: 4s472ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 2 1m8s 558ms 1m8s 34s407ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 17 20 2 1m8s 34s407ms [ User: intelifix - Total duration: 1m8s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m8s - Times executed: 2 ]
-
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-17 20:10:33 Duration: 558ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 2 26s610ms 3s664ms 22s945ms 13s305ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration May 17 20 2 26s610ms 13s305ms [ User: intelifix - Total duration: 26s610ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 26s610ms - Times executed: 2 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-05-17 20:04:46 Duration: 22s945ms 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-17 20:10:33 Duration: 3s664ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 2 11s578ms 428ms 11s149ms 5s789ms copy public.tcia_lote_fluxos (tl_id, flu_id, criacao) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 17 20 2 11s578ms 5s789ms [ User: intelifix - Total duration: 11s578ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 11s578ms - Times executed: 2 ]
-
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-17 20:11:03 Duration: 428ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 4s472ms 1m26s 45s344ms 2 1m30s 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 [ User: intelifix - Total duration: 1m30s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m30s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-17 20:09:12 Duration: 1m26s 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-17 20:11:07 Duration: 4s472ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
2 558ms 1m8s 34s407ms 2 1m8s 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 [ User: intelifix - Total duration: 1m8s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m8s - Times executed: 2 ]
-
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-17 20:10:33 Duration: 558ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
3 2s76ms 37s219ms 16s452ms 3 49s357ms 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 [ User: intelifix - Total duration: 49s357ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 49s357ms - 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-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-17 20:10:44 Duration: 10s61ms 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-17 20:11:33 Duration: 2s76ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
4 14s343ms 14s343ms 14s343ms 1 14s343ms 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 #4
Day Hour Count Duration Avg duration May 17 20 1 14s343ms 14s343ms [ User: intelifix - Total duration: 14s343ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 14s343ms - 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-17 20:07:22 Duration: 14s343ms Database: rio User: intelifix Remote: [local] Application: pg_dump
5 1s836ms 31s457ms 13s517ms 3 40s551ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration May 17 20 3 40s551ms 13s517ms [ User: intelifix - Total duration: 40s551ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 40s551ms - Times executed: 3 ]
-
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
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-17 20:10:52 Duration: 7s257ms 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-17 20:11:35 Duration: 1s836ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
6 3s664ms 22s945ms 13s305ms 2 26s610ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration May 17 20 2 26s610ms 13s305ms [ User: intelifix - Total duration: 26s610ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 26s610ms - Times executed: 2 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-05-17 20:04:46 Duration: 22s945ms 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-17 20:10:33 Duration: 3s664ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 3s595ms 29s494ms 13s231ms 3 39s695ms copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration May 17 20 3 39s695ms 13s231ms [ User: intelifix - Total duration: 39s695ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 39s695ms - 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-17 20:09:42 Duration: 29s494ms 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-17 20:11:14 Duration: 6s604ms 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-17 20:11:42 Duration: 3s595ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
8 1s620ms 21s871ms 11s243ms 3 33s730ms 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 [ User: intelifix - Total duration: 33s730ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 33s730ms - Times executed: 3 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-17 20:02:47 Duration: 21s871ms 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-17 20:10:04 Duration: 10s238ms 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-17 20:11:24 Duration: 1s620ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
9 1s429ms 21s735ms 10s710ms 3 32s132ms 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 [ User: intelifix - Total duration: 32s132ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 32s132ms - Times executed: 3 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-17 20:03:26 Duration: 21s735ms 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-17 20:10:16 Duration: 8s968ms 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-17 20:11:27 Duration: 1s429ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
10 1s233ms 25s641ms 10s440ms 3 31s322ms 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 [ User: intelifix - Total duration: 31s322ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 31s322ms - 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-17 20:04:23 Duration: 25s641ms 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:10:29 Duration: 4s448ms 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-17 20:11:30 Duration: 1s233ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
11 1s171ms 15s206ms 7s638ms 3 22s914ms 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 [ User: intelifix - Total duration: 22s914ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 22s914ms - 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-17 20:03:41 Duration: 15s206ms 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-17 20:10:22 Duration: 6s537ms 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-17 20:11:28 Duration: 1s171ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
12 738ms 17s102ms 6s798ms 3 20s396ms 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 [ User: intelifix - Total duration: 20s396ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 20s396ms - 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-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-17 20:10:07 Duration: 2s555ms 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-17 20:11:25 Duration: 738ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
13 428ms 11s149ms 5s789ms 2 11s578ms 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 [ User: intelifix - Total duration: 11s578ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 11s578ms - Times executed: 2 ]
-
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-17 20:11:03 Duration: 428ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 663ms 11s120ms 4s649ms 3 13s949ms 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 [ User: intelifix - Total duration: 13s949ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 13s949ms - 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-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-17 20:09:53 Duration: 2s164ms 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-17 20:11:23 Duration: 663ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
15 2s814ms 5s544ms 4s528ms 3 13s584ms 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 [ User: intelifix - Total duration: 13s584ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 13s584ms - 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-17 20:07:32 Duration: 5s544ms 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-17 20:11:01 Duration: 5s226ms 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-17 20:11:39 Duration: 2s814ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
16 711ms 12s85ms 4s510ms 3 13s531ms copy public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 17 20 3 13s531ms 4s510ms [ User: intelifix - Total duration: 13s531ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 13s531ms - 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-17 20:03:58 Duration: 12s85ms 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-17 20:11:29 Duration: 734ms 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-17 20:10:25 Duration: 711ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 2s695ms 3s270ms 2s981ms 3 8s945ms 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 [ User: intelifix - Total duration: 8s945ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 8s945ms - Times executed: 3 ]
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-05-17 20:09:50 Duration: 3s270ms Database: brasilia 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-17 20:02:09 Duration: 2s979ms 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-17 20:11:22 Duration: 2s695ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
18 972ms 3s524ms 2s248ms 2 4s497ms 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 [ User: intelifix - Total duration: 4s497ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 4s497ms - 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-17 20:10:55 Duration: 3s524ms 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-17 20:11:36 Duration: 972ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
19 438ms 4s308ms 2s147ms 3 6s441ms 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 [ User: intelifix - Total duration: 6s441ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 6s441ms - 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-17 20:03:46 Duration: 4s308ms 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-17 20:10:24 Duration: 1s694ms 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-17 20:11:28 Duration: 438ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
20 1s405ms 1s489ms 1s441ms 3 4s324ms 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 [ User: intelifix - Total duration: 4s324ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 4s324ms - Times executed: 3 ]
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-17 20:09:47 Duration: 1s489ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-17 20:11:19 Duration: 1s429ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-17 20:02:06 Duration: 1s405ms Database: rio 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
- 98 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