pgBadger-
Global information
- Generated on Sat May 23 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-23 20:02:01 to 2026-05-23 20:11:51
-
Overview
Global Stats
- 39 Number of unique normalized queries
- 86 Number of queries
- 9m38s Total query duration
- 2026-05-23 20:02:03 First query
- 2026-05-23 20:11:51 Last query
- 3 queries/s at 2026-05-23 20:11:00 Query peak
- 9m38s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 9m38s 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
- 9m49s Total duration of sessions
- 3m16s Average duration of sessions
- 28 Average queries per session
- 3m12s Average queries duration per session
- 3s866ms Average idle time per session
- 3 Total number of connections
- 1 connections/s at 2026-05-23 20:09:46 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 3 queries/s Query Peak
- 2026-05-23 20:11:00 Date
SELECT Traffic
Key values
- 2 queries/s Query Peak
- 2026-05-23 20:02:03 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 3 queries/s Query Peak
- 2026-05-23 20:11:00 Date
Queries duration
Key values
- 9m38s 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 23 20 86 158ms 1m32s 6s723ms 2m14s 2m14s 2m14s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 23 20 3 83 6s723ms 1m4s 2m14s 2m14s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 23 20 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare May 23 20 0 0 0.00 0.00% Day Hour Count Average / Second May 23 20 3 0.00/s Day Hour Count Average Duration Average idle time May 23 20 3 3m16s 3s866ms -
Connections
Established Connections
Key values
- 1 connections Connection Peak
- 2026-05-23 20:09:46 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 23 20 0 0s 0s 0s Day Hour Added Removed Recycled Synced files Longest sync Average sync May 23 20 0 0 0 0 0s 0s Day Hour Count Avg time (sec) May 23 20 0 0s Day Hour Mean distance Mean estimate May 23 20 0.00 kB 0.00 kB -
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size May 23 20 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Autovacuum actions (5 minutes period)
NO DATASET
Average Autovacuum Duration
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
Average Autovacuum Duration (5 minutes average)
NO DATASET
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- unknown (0) Main table vacuumed on database
- 0 vacuums Total
Vacuum throughput per table
Key values
- unknown (0) Max CPU elapsed for vacuum on database
- unknown (0 ms) Max I/O read time for vacuum on database
- unknown (0 ms) Max I/O write time for vacuum on database
Tuples removed per table
Key values
- unknown (0) Main table with removed tuples on database
- 0 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs May 23 20 0 0 - 0 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 3 Total read queries
- 83 Total write queries
Queries by database
Key values
- rio Main database
- 37 Requests
- 7m39s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 86 Requests
User Request type Count Duration intelifix Total 86 9m38s copy to 83 9m37s select 3 977ms Duration by user
Key values
- 9m38s (intelifix) Main time consuming user
User Request type Count Duration intelifix Total 86 9m38s copy to 83 9m37s select 3 977ms Queries by host
Key values
- [local] Main host
- 86 Requests
- 9m38s ([local])
- Main time consuming host
Queries by application
Key values
- pg_dump Main application
- 86 Requests
- 9m38s (pg_dump)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-05-23 20:05:53 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 1m32s COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;[ Date: 2026-05-23 20:09:12 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
2 1m3s COPY public.logs (mensagem, quando) TO stdout;[ Date: 2026-05-23 20:05:53 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
3 35s820ms COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;[ Date: 2026-05-23 20:06:31 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
4 32s759ms COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;[ Date: 2026-05-23 20:09:46 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
5 30s312ms COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;[ Date: 2026-05-23 20:07:05 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
6 25s405ms 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-23 20:04:26 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
7 23s486ms COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;[ Date: 2026-05-23 20:04:50 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
8 22s157ms COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;[ Date: 2026-05-23 20:03:26 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
9 21s540ms COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;[ Date: 2026-05-23 20:02:47 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
10 17s349ms COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;[ Date: 2026-05-23 20:03:43 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
11 15s980ms COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;[ Date: 2026-05-23 20:03:04 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
12 13s544ms COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;[ Date: 2026-05-23 20:04:01 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
13 13s180ms 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-23 20:07:18 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
14 10s902ms 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-23 20:02:23 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
15 10s323ms COPY public.tcia_lote_fluxos (tl_id, flu_id, criacao) TO stdout;[ Date: 2026-05-23 20:07:40 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
16 9s904ms COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;[ Date: 2026-05-23 20:10:48 - Database: brasilia - User: intelifix - Remote: [local] - Application: pg_dump ]
17 9s592ms COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;[ Date: 2026-05-23 20:10:07 - Database: brasilia - User: intelifix - Remote: [local] - Application: pg_dump ]
18 8s630ms COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;[ Date: 2026-05-23 20:10:18 - Database: brasilia - User: intelifix - Remote: [local] - Application: pg_dump ]
19 7s372ms COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;[ Date: 2026-05-23 20:10:56 - Database: brasilia - User: intelifix - Remote: [local] - Application: pg_dump ]
20 6s601ms COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;[ Date: 2026-05-23 20:10:25 - 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 1m36s 2 4s594ms 1m32s 48s394ms 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 23 20 2 1m36s 48s394ms [ User: intelifix - Total duration: 1m36s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m36s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-23 20:09:12 Duration: 1m32s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-23 20:11:13 Duration: 4s594ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
2 1m3s 2 554ms 1m3s 31s899ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 23 20 2 1m3s 31s899ms [ User: intelifix - Total duration: 1m3s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m3s - Times executed: 2 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-23 20:05:53 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-23 20:10:38 Duration: 554ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
3 48s20ms 3 2s295ms 35s820ms 16s6ms 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 23 20 3 48s20ms 16s6ms [ User: intelifix - Total duration: 48s20ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 48s20ms - 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-23 20:06:31 Duration: 35s820ms 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-23 20:10:48 Duration: 9s904ms 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-23 20:11:39 Duration: 2s295ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
4 43s100ms 3 3s937ms 32s759ms 14s366ms 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 #4
Day Hour Count Duration Avg duration May 23 20 3 43s100ms 14s366ms [ User: intelifix - Total duration: 43s100ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 43s100ms - 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-23 20:09:46 Duration: 32s759ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-05-23 20:11:19 Duration: 6s403ms 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-23 20:11:50 Duration: 3s937ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
5 39s392ms 3 1s707ms 30s312ms 13s130ms 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 23 20 3 39s392ms 13s130ms [ User: intelifix - Total duration: 39s392ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 39s392ms - Times executed: 3 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-23 20:07:05 Duration: 30s312ms 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-23 20:10:56 Duration: 7s372ms 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-23 20:11:41 Duration: 1s707ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
6 32s872ms 3 1s740ms 21s540ms 10s957ms 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 23 20 3 32s872ms 10s957ms [ User: intelifix - Total duration: 32s872ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 32s872ms - Times executed: 3 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-23 20:02:47 Duration: 21s540ms 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-23 20:10:07 Duration: 9s592ms 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-23 20:11:31 Duration: 1s740ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
7 32s256ms 3 1s468ms 22s157ms 10s752ms 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 23 20 3 32s256ms 10s752ms [ User: intelifix - Total duration: 32s256ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 32s256ms - Times executed: 3 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-23 20:03:26 Duration: 22s157ms 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-23 20:10:18 Duration: 8s630ms 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-23 20:11:33 Duration: 1s468ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
8 32s14ms 3 1s188ms 25s405ms 10s671ms 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 23 20 3 32s14ms 10s671ms [ User: intelifix - Total duration: 32s14ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 32s14ms - 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-23 20:04:26 Duration: 25s405ms 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-23 20:10:34 Duration: 5s419ms 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-23 20:11:37 Duration: 1s188ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
9 26s963ms 2 3s477ms 23s486ms 13s481ms 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 23 20 2 26s963ms 13s481ms [ User: intelifix - Total duration: 26s963ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 26s963ms - Times executed: 2 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-05-23 20:04:50 Duration: 23s486ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-05-23 20:10:37 Duration: 3s477ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 25s345ms 3 1s395ms 17s349ms 8s448ms 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 23 20 3 25s345ms 8s448ms [ User: intelifix - Total duration: 25s345ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 25s345ms - 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-23 20:03:43 Duration: 17s349ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-05-23 20:10:25 Duration: 6s601ms 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-23 20:11:35 Duration: 1s395ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
11 19s742ms 3 873ms 15s980ms 6s580ms 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 23 20 3 19s742ms 6s580ms [ User: intelifix - Total duration: 19s742ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 19s742ms - 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-23 20:03:04 Duration: 15s980ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-05-23 20:10:10 Duration: 2s888ms 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-23 20:11:32 Duration: 873ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
12 15s247ms 3 758ms 13s544ms 5s82ms 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 23 20 3 15s247ms 5s82ms [ User: intelifix - Total duration: 15s247ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 15s247ms - 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-23 20:04:01 Duration: 13s544ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-05-23 20:10:28 Duration: 944ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-05-23 20:11:36 Duration: 758ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
13 14s561ms 3 2s631ms 6s596ms 4s853ms copy public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration May 23 20 3 14s561ms 4s853ms [ User: intelifix - Total duration: 14s561ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 14s561ms - 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-23 20:11:07 Duration: 6s596ms 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-23 20:07:27 Duration: 5s333ms 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-23 20:11:45 Duration: 2s631ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
14 14s281ms 3 945ms 10s902ms 4s760ms 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 23 20 3 14s281ms 4s760ms [ User: intelifix - Total duration: 14s281ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 14s281ms - 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-23 20:02:23 Duration: 10s902ms 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-23 20:09:57 Duration: 2s433ms 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-23 20:11:29 Duration: 945ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
15 13s180ms 1 13s180ms 13s180ms 13s180ms 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 23 20 1 13s180ms 13s180ms [ User: intelifix - Total duration: 13s180ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 13s180ms - 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-23 20:07:18 Duration: 13s180ms Database: rio User: intelifix Remote: [local] Application: pg_dump
16 10s679ms 2 356ms 10s323ms 5s339ms 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 23 20 2 10s679ms 5s339ms [ User: intelifix - Total duration: 10s679ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 10s679ms - Times executed: 2 ]
-
COPY public.tcia_lote_fluxos (tl_id, flu_id, criacao) TO stdout;
Date: 2026-05-23 20:07:40 Duration: 10s323ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lote_fluxos (tl_id, flu_id, criacao) TO stdout;
Date: 2026-05-23 20:11:08 Duration: 356ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 9s712ms 3 2s997ms 3s656ms 3s237ms 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 23 20 3 9s712ms 3s237ms [ User: intelifix - Total duration: 9s712ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 9s712ms - Times executed: 3 ]
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-05-23 20:02:10 Duration: 3s656ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-05-23 20:11:28 Duration: 3s58ms 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-23 20:09:54 Duration: 2s997ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 6s963ms 3 414ms 4s190ms 2s321ms 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 23 20 3 6s963ms 2s321ms [ User: intelifix - Total duration: 6s963ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 6s963ms - 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-23 20:03:47 Duration: 4s190ms 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-23 20:10:27 Duration: 2s358ms 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-23 20:11:35 Duration: 414ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
19 4s820ms 2 1s221ms 3s598ms 2s410ms 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 23 20 2 4s820ms 2s410ms [ User: intelifix - Total duration: 4s820ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 4s820ms - 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-23 20:11:00 Duration: 3s598ms 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-23 20:11:43 Duration: 1s221ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
20 4s214ms 3 1s351ms 1s440ms 1s404ms 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 23 20 3 4s214ms 1s404ms [ User: intelifix - Total duration: 4s214ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 4s214ms - Times executed: 3 ]
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-23 20:09:50 Duration: 1s440ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-23 20:02:06 Duration: 1s422ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-23 20:11:25 Duration: 1s351ms 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 48s20ms 2s295ms 35s820ms 16s6ms 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 23 20 3 48s20ms 16s6ms [ User: intelifix - Total duration: 48s20ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 48s20ms - 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-23 20:06:31 Duration: 35s820ms 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-23 20:10:48 Duration: 9s904ms 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-23 20:11:39 Duration: 2s295ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
2 3 43s100ms 3s937ms 32s759ms 14s366ms 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 #2
Day Hour Count Duration Avg duration May 23 20 3 43s100ms 14s366ms [ User: intelifix - Total duration: 43s100ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 43s100ms - 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-23 20:09:46 Duration: 32s759ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-05-23 20:11:19 Duration: 6s403ms 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-23 20:11:50 Duration: 3s937ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
3 3 39s392ms 1s707ms 30s312ms 13s130ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 23 20 3 39s392ms 13s130ms [ User: intelifix - Total duration: 39s392ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 39s392ms - Times executed: 3 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-23 20:07:05 Duration: 30s312ms 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-23 20:10:56 Duration: 7s372ms 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-23 20:11:41 Duration: 1s707ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
4 3 32s872ms 1s740ms 21s540ms 10s957ms 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 23 20 3 32s872ms 10s957ms [ User: intelifix - Total duration: 32s872ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 32s872ms - Times executed: 3 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-23 20:02:47 Duration: 21s540ms 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-23 20:10:07 Duration: 9s592ms 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-23 20:11:31 Duration: 1s740ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
5 3 32s256ms 1s468ms 22s157ms 10s752ms 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 23 20 3 32s256ms 10s752ms [ User: intelifix - Total duration: 32s256ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 32s256ms - Times executed: 3 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-23 20:03:26 Duration: 22s157ms 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-23 20:10:18 Duration: 8s630ms 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-23 20:11:33 Duration: 1s468ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
6 3 32s14ms 1s188ms 25s405ms 10s671ms 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 23 20 3 32s14ms 10s671ms [ User: intelifix - Total duration: 32s14ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 32s14ms - 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-23 20:04:26 Duration: 25s405ms 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-23 20:10:34 Duration: 5s419ms 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-23 20:11:37 Duration: 1s188ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
7 3 25s345ms 1s395ms 17s349ms 8s448ms 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 23 20 3 25s345ms 8s448ms [ User: intelifix - Total duration: 25s345ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 25s345ms - 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-23 20:03:43 Duration: 17s349ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-05-23 20:10:25 Duration: 6s601ms 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-23 20:11:35 Duration: 1s395ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
8 3 19s742ms 873ms 15s980ms 6s580ms 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 23 20 3 19s742ms 6s580ms [ User: intelifix - Total duration: 19s742ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 19s742ms - 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-23 20:03:04 Duration: 15s980ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-05-23 20:10:10 Duration: 2s888ms 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-23 20:11:32 Duration: 873ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
9 3 15s247ms 758ms 13s544ms 5s82ms 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 23 20 3 15s247ms 5s82ms [ User: intelifix - Total duration: 15s247ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 15s247ms - 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-23 20:04:01 Duration: 13s544ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-05-23 20:10:28 Duration: 944ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-05-23 20:11:36 Duration: 758ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
10 3 14s561ms 2s631ms 6s596ms 4s853ms 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 23 20 3 14s561ms 4s853ms [ User: intelifix - Total duration: 14s561ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 14s561ms - 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-23 20:11:07 Duration: 6s596ms 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-23 20:07:27 Duration: 5s333ms 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-23 20:11:45 Duration: 2s631ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
11 3 14s281ms 945ms 10s902ms 4s760ms copy public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration May 23 20 3 14s281ms 4s760ms [ User: intelifix - Total duration: 14s281ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 14s281ms - 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-23 20:02:23 Duration: 10s902ms 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-23 20:09:57 Duration: 2s433ms 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-23 20:11:29 Duration: 945ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
12 3 9s712ms 2s997ms 3s656ms 3s237ms 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 23 20 3 9s712ms 3s237ms [ User: intelifix - Total duration: 9s712ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 9s712ms - Times executed: 3 ]
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-05-23 20:02:10 Duration: 3s656ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-05-23 20:11:28 Duration: 3s58ms 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-23 20:09:54 Duration: 2s997ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 3 6s963ms 414ms 4s190ms 2s321ms 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 23 20 3 6s963ms 2s321ms [ User: intelifix - Total duration: 6s963ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 6s963ms - 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-23 20:03:47 Duration: 4s190ms 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-23 20:10:27 Duration: 2s358ms 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-23 20:11:35 Duration: 414ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
14 3 4s214ms 1s351ms 1s440ms 1s404ms 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 23 20 3 4s214ms 1s404ms [ User: intelifix - Total duration: 4s214ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 4s214ms - Times executed: 3 ]
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-23 20:09:50 Duration: 1s440ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-23 20:02:06 Duration: 1s422ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-23 20:11:25 Duration: 1s351ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
15 3 1s92ms 164ms 552ms 364ms copy public.lotes (lot_id, lot_criacao, ofi_id, usu_id, cli_id, lot_tipo, lot_qtd_itens, mod_id, lot_data, lot_notafiscal, lot_qtd_cq, lot_lote_saida, arq_id, con_id, ss_id, lot_sem_serial, lot_status, lot_sucata, lot_novo, cli_original, nota_original, lot_preco_unit, lot_stone, lc_id) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration May 23 20 3 1s92ms 364ms [ User: intelifix - Total duration: 1s92ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 1s92ms - Times executed: 3 ]
-
COPY public.lotes (lot_id, lot_criacao, ofi_id, usu_id, cli_id, lot_tipo, lot_qtd_itens, mod_id, lot_data, lot_notafiscal, lot_qtd_cq, lot_lote_saida, arq_id, con_id, ss_id, lot_sem_serial, lot_status, lot_sucata, lot_novo, cli_original, nota_original, lot_preco_unit, lot_stone, lc_id) TO stdout;
Date: 2026-05-23 20:06:31 Duration: 552ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lotes (lot_id, lot_criacao, ofi_id, usu_id, cli_id, lot_tipo, lot_qtd_itens, mod_id, lot_data, lot_notafiscal, lot_qtd_cq, lot_lote_saida, arq_id, con_id, ss_id, lot_sem_serial, lot_status, lot_sucata, lot_novo, cli_original, nota_original, lot_preco_unit, lot_stone, lc_id) TO stdout;
Date: 2026-05-23 20:10:48 Duration: 376ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lotes (lot_id, lot_criacao, ofi_id, usu_id, cli_id, lot_tipo, lot_qtd_itens, mod_id, lot_data, lot_notafiscal, lot_qtd_cq, lot_lote_saida, arq_id, con_id, ss_id, lot_sem_serial, lot_status, lot_sucata, lot_novo, cli_original, nota_original, lot_preco_unit, lot_stone, lc_id) TO stdout;
Date: 2026-05-23 20:11:40 Duration: 164ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
16 3 550ms 174ms 191ms 183ms copy ceps2009.cep_bairros (id, uf, idloc, bairro) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 23 20 3 550ms 183ms [ User: intelifix - Total duration: 550ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 550ms - Times executed: 3 ]
-
COPY ceps2009.cep_bairros (id, uf, idloc, bairro) TO stdout;
Date: 2026-05-23 20:11:23 Duration: 191ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_bairros (id, uf, idloc, bairro) TO stdout;
Date: 2026-05-23 20:02:05 Duration: 184ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_bairros (id, uf, idloc, bairro) TO stdout;
Date: 2026-05-23 20:09:49 Duration: 174ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 2 1m36s 4s594ms 1m32s 48s394ms 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 23 20 2 1m36s 48s394ms [ User: intelifix - Total duration: 1m36s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m36s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-23 20:09:12 Duration: 1m32s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-23 20:11:13 Duration: 4s594ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 2 1m3s 554ms 1m3s 31s899ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 23 20 2 1m3s 31s899ms [ User: intelifix - Total duration: 1m3s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m3s - Times executed: 2 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-23 20:05:53 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-23 20:10:38 Duration: 554ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 2 26s963ms 3s477ms 23s486ms 13s481ms 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 23 20 2 26s963ms 13s481ms [ User: intelifix - Total duration: 26s963ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 26s963ms - Times executed: 2 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-05-23 20:04:50 Duration: 23s486ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-05-23 20:10:37 Duration: 3s477ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 2 10s679ms 356ms 10s323ms 5s339ms 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 23 20 2 10s679ms 5s339ms [ User: intelifix - Total duration: 10s679ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 10s679ms - Times executed: 2 ]
-
COPY public.tcia_lote_fluxos (tl_id, flu_id, criacao) TO stdout;
Date: 2026-05-23 20:07:40 Duration: 10s323ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lote_fluxos (tl_id, flu_id, criacao) TO stdout;
Date: 2026-05-23 20:11:08 Duration: 356ms 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 4s594ms 1m32s 48s394ms 2 1m36s 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 23 20 2 1m36s 48s394ms [ User: intelifix - Total duration: 1m36s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m36s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-23 20:09:12 Duration: 1m32s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-23 20:11:13 Duration: 4s594ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
2 554ms 1m3s 31s899ms 2 1m3s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 23 20 2 1m3s 31s899ms [ User: intelifix - Total duration: 1m3s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m3s - Times executed: 2 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-23 20:05:53 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-23 20:10:38 Duration: 554ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
3 2s295ms 35s820ms 16s6ms 3 48s20ms 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 23 20 3 48s20ms 16s6ms [ User: intelifix - Total duration: 48s20ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 48s20ms - 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-23 20:06:31 Duration: 35s820ms 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-23 20:10:48 Duration: 9s904ms 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-23 20:11:39 Duration: 2s295ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
4 3s937ms 32s759ms 14s366ms 3 43s100ms 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 #4
Day Hour Count Duration Avg duration May 23 20 3 43s100ms 14s366ms [ User: intelifix - Total duration: 43s100ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 43s100ms - 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-23 20:09:46 Duration: 32s759ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-05-23 20:11:19 Duration: 6s403ms 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-23 20:11:50 Duration: 3s937ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
5 3s477ms 23s486ms 13s481ms 2 26s963ms 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 23 20 2 26s963ms 13s481ms [ User: intelifix - Total duration: 26s963ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 26s963ms - Times executed: 2 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-05-23 20:04:50 Duration: 23s486ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-05-23 20:10:37 Duration: 3s477ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 13s180ms 13s180ms 13s180ms 1 13s180ms 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 #6
Day Hour Count Duration Avg duration May 23 20 1 13s180ms 13s180ms [ User: intelifix - Total duration: 13s180ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 13s180ms - 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-23 20:07:18 Duration: 13s180ms Database: rio User: intelifix Remote: [local] Application: pg_dump
7 1s707ms 30s312ms 13s130ms 3 39s392ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration May 23 20 3 39s392ms 13s130ms [ User: intelifix - Total duration: 39s392ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 39s392ms - Times executed: 3 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-23 20:07:05 Duration: 30s312ms 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-23 20:10:56 Duration: 7s372ms 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-23 20:11:41 Duration: 1s707ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
8 1s740ms 21s540ms 10s957ms 3 32s872ms 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 23 20 3 32s872ms 10s957ms [ User: intelifix - Total duration: 32s872ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 32s872ms - Times executed: 3 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-23 20:02:47 Duration: 21s540ms 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-23 20:10:07 Duration: 9s592ms 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-23 20:11:31 Duration: 1s740ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
9 1s468ms 22s157ms 10s752ms 3 32s256ms 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 23 20 3 32s256ms 10s752ms [ User: intelifix - Total duration: 32s256ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 32s256ms - Times executed: 3 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-23 20:03:26 Duration: 22s157ms 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-23 20:10:18 Duration: 8s630ms 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-23 20:11:33 Duration: 1s468ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
10 1s188ms 25s405ms 10s671ms 3 32s14ms 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 23 20 3 32s14ms 10s671ms [ User: intelifix - Total duration: 32s14ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 32s14ms - 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-23 20:04:26 Duration: 25s405ms 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-23 20:10:34 Duration: 5s419ms 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-23 20:11:37 Duration: 1s188ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
11 1s395ms 17s349ms 8s448ms 3 25s345ms 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 23 20 3 25s345ms 8s448ms [ User: intelifix - Total duration: 25s345ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 25s345ms - 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-23 20:03:43 Duration: 17s349ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-05-23 20:10:25 Duration: 6s601ms 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-23 20:11:35 Duration: 1s395ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
12 873ms 15s980ms 6s580ms 3 19s742ms 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 23 20 3 19s742ms 6s580ms [ User: intelifix - Total duration: 19s742ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 19s742ms - 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-23 20:03:04 Duration: 15s980ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equip_defeitos (ed_id, flu_id, def_id, tec_id, ed_fonte, ed_confirmado, ed_consertado, fp_id, ed_modo) TO stdout;
Date: 2026-05-23 20:10:10 Duration: 2s888ms 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-23 20:11:32 Duration: 873ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
13 356ms 10s323ms 5s339ms 2 10s679ms 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 23 20 2 10s679ms 5s339ms [ User: intelifix - Total duration: 10s679ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 10s679ms - Times executed: 2 ]
-
COPY public.tcia_lote_fluxos (tl_id, flu_id, criacao) TO stdout;
Date: 2026-05-23 20:07:40 Duration: 10s323ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lote_fluxos (tl_id, flu_id, criacao) TO stdout;
Date: 2026-05-23 20:11:08 Duration: 356ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 758ms 13s544ms 5s82ms 3 15s247ms 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 23 20 3 15s247ms 5s82ms [ User: intelifix - Total duration: 15s247ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 15s247ms - 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-23 20:04:01 Duration: 13s544ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-05-23 20:10:28 Duration: 944ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) TO stdout;
Date: 2026-05-23 20:11:36 Duration: 758ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
15 2s631ms 6s596ms 4s853ms 3 14s561ms 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 23 20 3 14s561ms 4s853ms [ User: intelifix - Total duration: 14s561ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 14s561ms - 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-23 20:11:07 Duration: 6s596ms 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-23 20:07:27 Duration: 5s333ms 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-23 20:11:45 Duration: 2s631ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
16 945ms 10s902ms 4s760ms 3 14s281ms copy public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 23 20 3 14s281ms 4s760ms [ User: intelifix - Total duration: 14s281ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 14s281ms - 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-23 20:02:23 Duration: 10s902ms 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-23 20:09:57 Duration: 2s433ms 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-23 20:11:29 Duration: 945ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
17 2s997ms 3s656ms 3s237ms 3 9s712ms 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 23 20 3 9s712ms 3s237ms [ User: intelifix - Total duration: 9s712ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 9s712ms - Times executed: 3 ]
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-05-23 20:02:10 Duration: 3s656ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-05-23 20:11:28 Duration: 3s58ms 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-23 20:09:54 Duration: 2s997ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 1s221ms 3s598ms 2s410ms 2 4s820ms 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 23 20 2 4s820ms 2s410ms [ User: intelifix - Total duration: 4s820ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 4s820ms - 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-23 20:11:00 Duration: 3s598ms 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-23 20:11:43 Duration: 1s221ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
19 414ms 4s190ms 2s321ms 3 6s963ms 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 23 20 3 6s963ms 2s321ms [ User: intelifix - Total duration: 6s963ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 6s963ms - 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-23 20:03:47 Duration: 4s190ms 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-23 20:10:27 Duration: 2s358ms 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-23 20:11:35 Duration: 414ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
20 1s351ms 1s440ms 1s404ms 3 4s214ms 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 23 20 3 4s214ms 1s404ms [ User: intelifix - Total duration: 4s214ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 4s214ms - Times executed: 3 ]
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-23 20:09:50 Duration: 1s440ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-23 20:02:06 Duration: 1s422ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-23 20:11:25 Duration: 1s351ms 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
- 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