pgBadger-
Global information
- Generated on Thu May 21 23:50:03 2026
- Log file: /usr/local/pgsql/data/log/serverlog-04.log, ..., /usr/local/pgsql/data/log/serverlog-26.log
- Parsed 190 log entries in 2s
- Log start from 2026-05-21 20:02:02 to 2026-05-21 20:11:38
-
Overview
Global Stats
- 39 Number of unique normalized queries
- 83 Number of queries
- 9m24s Total query duration
- 2026-05-21 20:02:03 First query
- 2026-05-21 20:11:38 Last query
- 3 queries/s at 2026-05-21 20:08:59 Query peak
- 9m24s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 9m24s 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
- 9m36s Total duration of sessions
- 3m12s Average duration of sessions
- 27 Average queries per session
- 3m8s Average queries duration per session
- 4s5ms Average idle time per session
- 3 Total number of connections
- 1 connections/s at 2026-05-21 20:11:08 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 3 queries/s Query Peak
- 2026-05-21 20:08:59 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2026-05-21 20:09:32 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 3 queries/s Query Peak
- 2026-05-21 20:08:59 Date
Queries duration
Key values
- 9m24s 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 21 20 83 168ms 1m25s 6s796ms 1m26s 1m26s 1m26s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 21 20 3 80 6s796ms 1m8s 1m26s 1m26s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 21 20 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare May 21 20 0 0 0.00 0.00% Day Hour Count Average / Second May 21 20 3 0.00/s Day Hour Count Average Duration Average idle time May 21 20 3 3m12s 4s5ms -
Connections
Established Connections
Key values
- 1 connections Connection Peak
- 2026-05-21 20:11:08 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 21 20 0 0s 0s 0s Day Hour Added Removed Recycled Synced files Longest sync Average sync May 21 20 0 0 0 0 0s 0s Day Hour Count Avg time (sec) May 21 20 0 0s Day Hour Mean distance Mean estimate May 21 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 21 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 21 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
- 80 Total write queries
Queries by database
Key values
- rio Main database
- 35 Requests
- 7m23s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 83 Requests
User Request type Count Duration intelifix Total 83 9m24s copy to 80 9m23s select 3 695ms Duration by user
Key values
- 9m24s (intelifix) Main time consuming user
User Request type Count Duration intelifix Total 83 9m24s copy to 80 9m23s select 3 695ms Queries by host
Key values
- [local] Main host
- 83 Requests
- 9m24s ([local])
- Main time consuming host
Queries by application
Key values
- pg_dump Main application
- 83 Requests
- 9m24s (pg_dump)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-05-21 20:06:25 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 38 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 1m25s COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;[ Date: 2026-05-21 20:08:59 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
2 1m2s COPY public.logs (mensagem, quando) TO stdout;[ Date: 2026-05-21 20:05:47 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
3 34s837ms 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-21 20:06:24 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
4 30s657ms COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;[ Date: 2026-05-21 20:06:57 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
5 30s163ms COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;[ Date: 2026-05-21 20:09:30 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
6 23s139ms COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;[ Date: 2026-05-21 20:03:26 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
7 22s807ms 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-21 20:04:24 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
8 21s25ms COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;[ Date: 2026-05-21 20:02:47 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
9 20s784ms COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;[ Date: 2026-05-21 20:04:44 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
10 17s192ms COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;[ Date: 2026-05-21 20:03:43 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
11 15s389ms 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-21 20:03:03 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
12 14s33ms COPY public.nf_entrada_itens (nem_id, serie, valor, li_id, modo, nea_id, tipo_local, lc_id, rede_msg, sub_modelo) TO stdout;[ Date: 2026-05-21 20:07:12 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
13 12s772ms 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-21 20:04:01 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
14 10s531ms 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-21 20:02:23 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
15 10s58ms COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;[ Date: 2026-05-21 20:09:52 - Database: brasilia - User: intelifix - Remote: [local] - Application: pg_dump ]
16 10s15ms 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-21 20:10:34 - Database: brasilia - User: intelifix - Remote: [local] - Application: pg_dump ]
17 9s975ms COPY public.tcia_lote_fluxos (tl_id, flu_id, criacao) TO stdout;[ Date: 2026-05-21 20:07:33 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
18 8s958ms COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;[ Date: 2026-05-21 20:10:44 - Database: brasilia - User: intelifix - Remote: [local] - Application: pg_dump ]
19 8s571ms COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;[ Date: 2026-05-21 20:10:03 - Database: brasilia - User: intelifix - Remote: [local] - Application: pg_dump ]
20 7s427ms COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;[ Date: 2026-05-21 20:10:11 - 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 4s478ms 1m25s 45s233ms 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 21 20 2 1m30s 45s233ms [ 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-21 20:08:59 Duration: 1m25s 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-21 20:11:00 Duration: 4s478ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
2 1m3s 2 553ms 1m2s 31s603ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 21 20 2 1m3s 31s603ms [ 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-21 20:05:47 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-21 20:10:24 Duration: 553ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
3 46s937ms 3 2s83ms 34s837ms 15s645ms 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 21 20 3 46s937ms 15s645ms [ User: intelifix - Total duration: 46s937ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 46s937ms - 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-21 20:06:24 Duration: 34s837ms 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-21 20:10:34 Duration: 10s15ms 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-21 20:11:27 Duration: 2s83ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
4 41s441ms 3 1s825ms 30s657ms 13s813ms 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 21 20 3 41s441ms 13s813ms [ User: intelifix - Total duration: 41s441ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 41s441ms - Times executed: 3 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-21 20:06:57 Duration: 30s657ms 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-21 20:10:44 Duration: 8s958ms 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-21 20:11:29 Duration: 1s825ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
5 40s527ms 3 3s874ms 30s163ms 13s509ms 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 21 20 3 40s527ms 13s509ms [ User: intelifix - Total duration: 40s527ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 40s527ms - 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-21 20:09:30 Duration: 30s163ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-05-21 20:11:07 Duration: 6s488ms 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-21 20:11:37 Duration: 3s874ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
6 33s502ms 3 1s791ms 23s139ms 11s167ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration May 21 20 3 33s502ms 11s167ms [ User: intelifix - Total duration: 33s502ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 33s502ms - Times executed: 3 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-21 20:03:26 Duration: 23s139ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-21 20:10:03 Duration: 8s571ms 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-21 20:11:21 Duration: 1s791ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
7 32s682ms 3 1s598ms 21s25ms 10s894ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration May 21 20 3 32s682ms 10s894ms [ User: intelifix - Total duration: 32s682ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 32s682ms - Times executed: 3 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-21 20:02:47 Duration: 21s25ms 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-21 20:09:52 Duration: 10s58ms 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-21 20:11:18 Duration: 1s598ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
8 29s274ms 3 1s245ms 22s807ms 9s758ms 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 21 20 3 29s274ms 9s758ms [ User: intelifix - Total duration: 29s274ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 29s274ms - 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-21 20:04:24 Duration: 22s807ms 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-21 20:10:19 Duration: 5s222ms 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-21 20:11:24 Duration: 1s245ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
9 25s817ms 3 1s197ms 17s192ms 8s605ms 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 #9
Day Hour Count Duration Avg duration May 21 20 3 25s817ms 8s605ms [ User: intelifix - Total duration: 25s817ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 25s817ms - 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-21 20:03:43 Duration: 17s192ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-05-21 20:10:11 Duration: 7s427ms 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-21 20:11:22 Duration: 1s197ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
10 24s610ms 2 3s825ms 20s784ms 12s305ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration May 21 20 2 24s610ms 12s305ms [ User: intelifix - Total duration: 24s610ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 24s610ms - Times executed: 2 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-05-21 20:04:44 Duration: 20s784ms 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-21 20:10:23 Duration: 3s825ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 18s850ms 3 920ms 15s389ms 6s283ms 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 21 20 3 18s850ms 6s283ms [ User: intelifix - Total duration: 18s850ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 18s850ms - 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-21 20:03:03 Duration: 15s389ms 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-21 20:09:54 Duration: 2s541ms 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-21 20:11:19 Duration: 920ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
12 14s676ms 3 783ms 12s772ms 4s892ms 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 21 20 3 14s676ms 4s892ms [ User: intelifix - Total duration: 14s676ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 14s676ms - 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-21 20:04:01 Duration: 12s772ms 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-21 20:10:14 Duration: 1s120ms 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-21 20:11:23 Duration: 783ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
13 14s490ms 3 2s553ms 6s229ms 4s830ms 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 21 20 3 14s490ms 4s830ms [ User: intelifix - Total duration: 14s490ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 14s490ms - 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-21 20:10:54 Duration: 6s229ms 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-21 20:07:21 Duration: 5s707ms 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-21 20:11:33 Duration: 2s553ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
14 14s33ms 1 14s33ms 14s33ms 14s33ms 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 #14
Day Hour Count Duration Avg duration May 21 20 1 14s33ms 14s33ms [ User: intelifix - Total duration: 14s33ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 14s33ms - 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-21 20:07:12 Duration: 14s33ms Database: rio User: intelifix Remote: [local] Application: pg_dump
15 13s623ms 3 758ms 10s531ms 4s541ms copy public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration May 21 20 3 13s623ms 4s541ms [ User: intelifix - Total duration: 13s623ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 13s623ms - 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-21 20:02:23 Duration: 10s531ms 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-21 20:09:41 Duration: 2s333ms 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-21 20:11:16 Duration: 758ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
16 10s269ms 2 293ms 9s975ms 5s134ms 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 21 20 2 10s269ms 5s134ms [ User: intelifix - Total duration: 10s269ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 10s269ms - Times executed: 2 ]
-
COPY public.tcia_lote_fluxos (tl_id, flu_id, criacao) TO stdout;
Date: 2026-05-21 20:07:33 Duration: 9s975ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lote_fluxos (tl_id, flu_id, criacao) TO stdout;
Date: 2026-05-21 20:10:55 Duration: 293ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 9s865ms 3 3s91ms 3s612ms 3s288ms 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 21 20 3 9s865ms 3s288ms [ User: intelifix - Total duration: 9s865ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 9s865ms - Times executed: 3 ]
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-05-21 20:02:11 Duration: 3s612ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-05-21 20:09:38 Duration: 3s161ms 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-21 20:11:16 Duration: 3s91ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
18 7s751ms 3 322ms 4s936ms 2s583ms 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 21 20 3 7s751ms 2s583ms [ User: intelifix - Total duration: 7s751ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 7s751ms - 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-21 20:03:48 Duration: 4s936ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) TO stdout;
Date: 2026-05-21 20:10:13 Duration: 2s492ms 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-21 20:11:22 Duration: 322ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
19 4s887ms 2 1s300ms 3s586ms 2s443ms 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 21 20 2 4s887ms 2s443ms [ User: intelifix - Total duration: 4s887ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 4s887ms - 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-21 20:10:47 Duration: 3s586ms 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-21 20:11:30 Duration: 1s300ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
20 4s321ms 3 1s364ms 1s515ms 1s440ms 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 21 20 3 4s321ms 1s440ms [ User: intelifix - Total duration: 4s321ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 4s321ms - Times executed: 3 ]
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-21 20:11:12 Duration: 1s515ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-21 20:02:07 Duration: 1s441ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-21 20:09:35 Duration: 1s364ms Database: brasilia 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 46s937ms 2s83ms 34s837ms 15s645ms 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 21 20 3 46s937ms 15s645ms [ User: intelifix - Total duration: 46s937ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 46s937ms - 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-21 20:06:24 Duration: 34s837ms 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-21 20:10:34 Duration: 10s15ms 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-21 20:11:27 Duration: 2s83ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
2 3 41s441ms 1s825ms 30s657ms 13s813ms 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 21 20 3 41s441ms 13s813ms [ User: intelifix - Total duration: 41s441ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 41s441ms - Times executed: 3 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-21 20:06:57 Duration: 30s657ms 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-21 20:10:44 Duration: 8s958ms 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-21 20:11:29 Duration: 1s825ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
3 3 40s527ms 3s874ms 30s163ms 13s509ms 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 21 20 3 40s527ms 13s509ms [ User: intelifix - Total duration: 40s527ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 40s527ms - 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-21 20:09:30 Duration: 30s163ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-05-21 20:11:07 Duration: 6s488ms 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-21 20:11:37 Duration: 3s874ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
4 3 33s502ms 1s791ms 23s139ms 11s167ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration May 21 20 3 33s502ms 11s167ms [ User: intelifix - Total duration: 33s502ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 33s502ms - Times executed: 3 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-21 20:03:26 Duration: 23s139ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-21 20:10:03 Duration: 8s571ms 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-21 20:11:21 Duration: 1s791ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
5 3 32s682ms 1s598ms 21s25ms 10s894ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration May 21 20 3 32s682ms 10s894ms [ User: intelifix - Total duration: 32s682ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 32s682ms - Times executed: 3 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-21 20:02:47 Duration: 21s25ms 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-21 20:09:52 Duration: 10s58ms 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-21 20:11:18 Duration: 1s598ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
6 3 29s274ms 1s245ms 22s807ms 9s758ms 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 21 20 3 29s274ms 9s758ms [ User: intelifix - Total duration: 29s274ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 29s274ms - 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-21 20:04:24 Duration: 22s807ms 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-21 20:10:19 Duration: 5s222ms 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-21 20:11:24 Duration: 1s245ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
7 3 25s817ms 1s197ms 17s192ms 8s605ms 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 21 20 3 25s817ms 8s605ms [ User: intelifix - Total duration: 25s817ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 25s817ms - 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-21 20:03:43 Duration: 17s192ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-05-21 20:10:11 Duration: 7s427ms 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-21 20:11:22 Duration: 1s197ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
8 3 18s850ms 920ms 15s389ms 6s283ms 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 21 20 3 18s850ms 6s283ms [ User: intelifix - Total duration: 18s850ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 18s850ms - 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-21 20:03:03 Duration: 15s389ms 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-21 20:09:54 Duration: 2s541ms 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-21 20:11:19 Duration: 920ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
9 3 14s676ms 783ms 12s772ms 4s892ms 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 21 20 3 14s676ms 4s892ms [ User: intelifix - Total duration: 14s676ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 14s676ms - 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-21 20:04:01 Duration: 12s772ms 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-21 20:10:14 Duration: 1s120ms 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-21 20:11:23 Duration: 783ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
10 3 14s490ms 2s553ms 6s229ms 4s830ms 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 21 20 3 14s490ms 4s830ms [ User: intelifix - Total duration: 14s490ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 14s490ms - 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-21 20:10:54 Duration: 6s229ms 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-21 20:07:21 Duration: 5s707ms 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-21 20:11:33 Duration: 2s553ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
11 3 13s623ms 758ms 10s531ms 4s541ms 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 21 20 3 13s623ms 4s541ms [ User: intelifix - Total duration: 13s623ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 13s623ms - 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-21 20:02:23 Duration: 10s531ms 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-21 20:09:41 Duration: 2s333ms 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-21 20:11:16 Duration: 758ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
12 3 9s865ms 3s91ms 3s612ms 3s288ms 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 21 20 3 9s865ms 3s288ms [ User: intelifix - Total duration: 9s865ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 9s865ms - Times executed: 3 ]
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-05-21 20:02:11 Duration: 3s612ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-05-21 20:09:38 Duration: 3s161ms 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-21 20:11:16 Duration: 3s91ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
13 3 7s751ms 322ms 4s936ms 2s583ms 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 21 20 3 7s751ms 2s583ms [ User: intelifix - Total duration: 7s751ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 7s751ms - 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-21 20:03:48 Duration: 4s936ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) TO stdout;
Date: 2026-05-21 20:10:13 Duration: 2s492ms 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-21 20:11:22 Duration: 322ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
14 3 4s321ms 1s364ms 1s515ms 1s440ms 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 21 20 3 4s321ms 1s440ms [ User: intelifix - Total duration: 4s321ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 4s321ms - Times executed: 3 ]
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-21 20:11:12 Duration: 1s515ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-21 20:02:07 Duration: 1s441ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-21 20:09:35 Duration: 1s364ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 2 1m30s 4s478ms 1m25s 45s233ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration May 21 20 2 1m30s 45s233ms [ 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-21 20:08:59 Duration: 1m25s 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-21 20:11:00 Duration: 4s478ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 2 1m3s 553ms 1m2s 31s603ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 21 20 2 1m3s 31s603ms [ 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-21 20:05:47 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-21 20:10:24 Duration: 553ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 2 24s610ms 3s825ms 20s784ms 12s305ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration May 21 20 2 24s610ms 12s305ms [ User: intelifix - Total duration: 24s610ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 24s610ms - Times executed: 2 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-05-21 20:04:44 Duration: 20s784ms 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-21 20:10:23 Duration: 3s825ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 2 10s269ms 293ms 9s975ms 5s134ms copy public.tcia_lote_fluxos (tl_id, flu_id, criacao) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 21 20 2 10s269ms 5s134ms [ User: intelifix - Total duration: 10s269ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 10s269ms - Times executed: 2 ]
-
COPY public.tcia_lote_fluxos (tl_id, flu_id, criacao) TO stdout;
Date: 2026-05-21 20:07:33 Duration: 9s975ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lote_fluxos (tl_id, flu_id, criacao) TO stdout;
Date: 2026-05-21 20:10:55 Duration: 293ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 2 4s887ms 1s300ms 3s586ms 2s443ms 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 21 20 2 4s887ms 2s443ms [ User: intelifix - Total duration: 4s887ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 4s887ms - 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-21 20:10:47 Duration: 3s586ms 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-21 20:11:30 Duration: 1s300ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
20 2 3s597ms 410ms 3s186ms 1s798ms copy public.nf_entrada_modelos (nem_id, nf_id, mod_id, sap, valor, valor_unit, seriais, qtd_teorica, qtd_recebida) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 21 20 2 3s597ms 1s798ms [ User: intelifix - Total duration: 3s597ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 3s597ms - Times executed: 2 ]
-
COPY public.nf_entrada_modelos (nem_id, nf_id, mod_id, sap, valor, valor_unit, seriais, qtd_teorica, qtd_recebida) TO stdout;
Date: 2026-05-21 20:07:15 Duration: 3s186ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_modelos (nem_id, nf_id, mod_id, sap, valor, valor_unit, seriais, qtd_teorica, qtd_recebida) TO stdout;
Date: 2026-05-21 20:10:48 Duration: 410ms 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 4s478ms 1m25s 45s233ms 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 21 20 2 1m30s 45s233ms [ 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-21 20:08:59 Duration: 1m25s 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-21 20:11:00 Duration: 4s478ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
2 553ms 1m2s 31s603ms 2 1m3s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 21 20 2 1m3s 31s603ms [ 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-21 20:05:47 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-21 20:10:24 Duration: 553ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
3 2s83ms 34s837ms 15s645ms 3 46s937ms 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 21 20 3 46s937ms 15s645ms [ User: intelifix - Total duration: 46s937ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 46s937ms - 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-21 20:06:24 Duration: 34s837ms 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-21 20:10:34 Duration: 10s15ms 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-21 20:11:27 Duration: 2s83ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
4 14s33ms 14s33ms 14s33ms 1 14s33ms 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 21 20 1 14s33ms 14s33ms [ User: intelifix - Total duration: 14s33ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 14s33ms - 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-21 20:07:12 Duration: 14s33ms Database: rio User: intelifix Remote: [local] Application: pg_dump
5 1s825ms 30s657ms 13s813ms 3 41s441ms 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 21 20 3 41s441ms 13s813ms [ User: intelifix - Total duration: 41s441ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 41s441ms - Times executed: 3 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-21 20:06:57 Duration: 30s657ms 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-21 20:10:44 Duration: 8s958ms 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-21 20:11:29 Duration: 1s825ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
6 3s874ms 30s163ms 13s509ms 3 40s527ms copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration May 21 20 3 40s527ms 13s509ms [ User: intelifix - Total duration: 40s527ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 40s527ms - 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-21 20:09:30 Duration: 30s163ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-05-21 20:11:07 Duration: 6s488ms 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-21 20:11:37 Duration: 3s874ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
7 3s825ms 20s784ms 12s305ms 2 24s610ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration May 21 20 2 24s610ms 12s305ms [ User: intelifix - Total duration: 24s610ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 24s610ms - Times executed: 2 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-05-21 20:04:44 Duration: 20s784ms 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-21 20:10:23 Duration: 3s825ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 1s791ms 23s139ms 11s167ms 3 33s502ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration May 21 20 3 33s502ms 11s167ms [ User: intelifix - Total duration: 33s502ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 33s502ms - Times executed: 3 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-21 20:03:26 Duration: 23s139ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-21 20:10:03 Duration: 8s571ms 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-21 20:11:21 Duration: 1s791ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
9 1s598ms 21s25ms 10s894ms 3 32s682ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration May 21 20 3 32s682ms 10s894ms [ User: intelifix - Total duration: 32s682ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 32s682ms - Times executed: 3 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-21 20:02:47 Duration: 21s25ms 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-21 20:09:52 Duration: 10s58ms 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-21 20:11:18 Duration: 1s598ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
10 1s245ms 22s807ms 9s758ms 3 29s274ms 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 21 20 3 29s274ms 9s758ms [ User: intelifix - Total duration: 29s274ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 29s274ms - 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-21 20:04:24 Duration: 22s807ms 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-21 20:10:19 Duration: 5s222ms 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-21 20:11:24 Duration: 1s245ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
11 1s197ms 17s192ms 8s605ms 3 25s817ms 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 21 20 3 25s817ms 8s605ms [ User: intelifix - Total duration: 25s817ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 25s817ms - 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-21 20:03:43 Duration: 17s192ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos (eq_id, mod_id, eq_criacao, usu_id, eq_serie, cli_id, ofi_id, eq_mac_address, arq_id, cli_id_old, eq_homologado, eq_homologdt, eq_upd_firmware, eq_qr_code, cli_original, power_dados, eq_transf, validado) TO stdout;
Date: 2026-05-21 20:10:11 Duration: 7s427ms 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-21 20:11:22 Duration: 1s197ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
12 920ms 15s389ms 6s283ms 3 18s850ms 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 21 20 3 18s850ms 6s283ms [ User: intelifix - Total duration: 18s850ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 18s850ms - 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-21 20:03:03 Duration: 15s389ms 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-21 20:09:54 Duration: 2s541ms 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-21 20:11:19 Duration: 920ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
13 293ms 9s975ms 5s134ms 2 10s269ms 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 21 20 2 10s269ms 5s134ms [ User: intelifix - Total duration: 10s269ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 10s269ms - Times executed: 2 ]
-
COPY public.tcia_lote_fluxos (tl_id, flu_id, criacao) TO stdout;
Date: 2026-05-21 20:07:33 Duration: 9s975ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lote_fluxos (tl_id, flu_id, criacao) TO stdout;
Date: 2026-05-21 20:10:55 Duration: 293ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 783ms 12s772ms 4s892ms 3 14s676ms 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 21 20 3 14s676ms 4s892ms [ User: intelifix - Total duration: 14s676ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 14s676ms - 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-21 20:04:01 Duration: 12s772ms 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-21 20:10:14 Duration: 1s120ms 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-21 20:11:23 Duration: 783ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
15 2s553ms 6s229ms 4s830ms 3 14s490ms 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 21 20 3 14s490ms 4s830ms [ User: intelifix - Total duration: 14s490ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 14s490ms - 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-21 20:10:54 Duration: 6s229ms 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-21 20:07:21 Duration: 5s707ms 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-21 20:11:33 Duration: 2s553ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
16 758ms 10s531ms 4s541ms 3 13s623ms 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 21 20 3 13s623ms 4s541ms [ User: intelifix - Total duration: 13s623ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 13s623ms - 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-21 20:02:23 Duration: 10s531ms 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-21 20:09:41 Duration: 2s333ms 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-21 20:11:16 Duration: 758ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
17 3s91ms 3s612ms 3s288ms 3 9s865ms 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 21 20 3 9s865ms 3s288ms [ User: intelifix - Total duration: 9s865ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 9s865ms - Times executed: 3 ]
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-05-21 20:02:11 Duration: 3s612ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-05-21 20:09:38 Duration: 3s161ms 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-21 20:11:16 Duration: 3s91ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
18 322ms 4s936ms 2s583ms 3 7s751ms 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 21 20 3 7s751ms 2s583ms [ User: intelifix - Total duration: 7s751ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 7s751ms - 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-21 20:03:48 Duration: 4s936ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) TO stdout;
Date: 2026-05-21 20:10:13 Duration: 2s492ms 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-21 20:11:22 Duration: 322ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
19 1s300ms 3s586ms 2s443ms 2 4s887ms 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 21 20 2 4s887ms 2s443ms [ User: intelifix - Total duration: 4s887ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 4s887ms - 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-21 20:10:47 Duration: 3s586ms 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-21 20:11:30 Duration: 1s300ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
20 410ms 3s186ms 1s798ms 2 3s597ms copy public.nf_entrada_modelos (nem_id, nf_id, mod_id, sap, valor, valor_unit, seriais, qtd_teorica, qtd_recebida) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 21 20 2 3s597ms 1s798ms [ User: intelifix - Total duration: 3s597ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 3s597ms - Times executed: 2 ]
-
COPY public.nf_entrada_modelos (nem_id, nf_id, mod_id, sap, valor, valor_unit, seriais, qtd_teorica, qtd_recebida) TO stdout;
Date: 2026-05-21 20:07:15 Duration: 3s186ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_modelos (nem_id, nf_id, mod_id, sap, valor, valor_unit, seriais, qtd_teorica, qtd_recebida) TO stdout;
Date: 2026-05-21 20:10:48 Duration: 410ms Database: brasilia 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
- 95 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