pgBadger-
Global information
- Generated on Sat May 16 23:50:03 2026
- Log file: /usr/local/pgsql/data/log/serverlog-04.log, ..., /usr/local/pgsql/data/log/serverlog-26.log
- Parsed 200 log entries in 2s
- Log start from 2026-05-16 20:02:01 to 2026-05-16 20:13:27
-
Overview
Global Stats
- 41 Number of unique normalized queries
- 88 Number of queries
- 11m13s Total query duration
- 2026-05-16 20:02:02 First query
- 2026-05-16 20:13:27 Last query
- 2 queries/s at 2026-05-16 20:08:17 Query peak
- 11m13s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 11m13s 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
- 11m25s Total duration of sessions
- 3m48s Average duration of sessions
- 29 Average queries per session
- 3m44s Average queries duration per session
- 4s16ms Average idle time per session
- 3 Total number of connections
- 1 connections/s at 2026-05-16 20:10:56 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 2 queries/s Query Peak
- 2026-05-16 20:08:17 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2026-05-16 20:02:02 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 2 queries/s Query Peak
- 2026-05-16 20:08:17 Date
Queries duration
Key values
- 11m13s 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 16 20 88 151ms 1m46s 7s654ms 1m23s 2m21s 2m21s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 16 20 2 86 7s654ms 1m16s 1m23s 2m21s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 16 20 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare May 16 20 0 0 0.00 0.00% Day Hour Count Average / Second May 16 20 3 0.00/s Day Hour Count Average Duration Average idle time May 16 20 3 3m48s 4s16ms -
Connections
Established Connections
Key values
- 1 connections Connection Peak
- 2026-05-16 20:10:56 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 16 20 0 0s 0s 0s Day Hour Added Removed Recycled Synced files Longest sync Average sync May 16 20 0 0 0 0 0s 0s Day Hour Count Avg time (sec) May 16 20 0 0s Day Hour Mean distance Mean estimate May 16 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 16 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 16 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
- 2 Total read queries
- 86 Total write queries
Queries by database
Key values
- rio Main database
- 38 Requests
- 8m50s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 88 Requests
User Request type Count Duration intelifix Total 88 11m13s copy to 86 11m13s select 2 368ms Duration by user
Key values
- 11m13s (intelifix) Main time consuming user
User Request type Count Duration intelifix Total 88 11m13s copy to 86 11m13s select 2 368ms Queries by host
Key values
- [local] Main host
- 88 Requests
- 11m13s ([local])
- Main time consuming host
Queries by application
Key values
- pg_dump Main application
- 88 Requests
- 11m13s (pg_dump)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-05-16 20:08:17 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 37 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 1m46s COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;[ Date: 2026-05-16 20:10:20 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
2 1m14s COPY public.logs (mensagem, quando) TO stdout;[ Date: 2026-05-16 20:06:23 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
3 39s911ms COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;[ Date: 2026-05-16 20:07:48 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
4 38s640ms 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-16 20:07:03 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
5 34s259ms 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-16 20:10:55 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
6 28s409ms COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;[ Date: 2026-05-16 20:05:08 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
7 27s142ms 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-16 20:04:40 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
8 23s607ms COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;[ Date: 2026-05-16 20:03:34 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
9 22s993ms COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;[ Date: 2026-05-16 20:02:52 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
10 19s229ms 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-16 20:03:53 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
11 17s890ms 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-16 20:03:10 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
12 15s335ms 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-16 20:08:04 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
13 14s552ms COPY public.tcia_lote_fluxos (tl_id, flu_id, criacao) TO stdout;[ Date: 2026-05-16 20:08:33 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
14 14s68ms 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-16 20:04:13 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
15 13s962ms 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-16 20:02:26 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
16 12s626ms COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;[ Date: 2026-05-16 20:11:21 - Database: brasilia - User: intelifix - Remote: [local] - Application: pg_dump ]
17 11s810ms COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;[ Date: 2026-05-16 20:11:36 - Database: brasilia - User: intelifix - Remote: [local] - Application: pg_dump ]
18 11s270ms 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-16 20:12:12 - Database: brasilia - User: intelifix - Remote: [local] - Application: pg_dump ]
19 9s220ms 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-16 20:11:45 - Database: brasilia - User: intelifix - Remote: [local] - Application: pg_dump ]
20 8s695ms COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;[ Date: 2026-05-16 20:12:21 - 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 1m52s 2 5s741ms 1m46s 56s291ms 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 16 20 2 1m52s 56s291ms [ User: intelifix - Total duration: 1m52s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m52s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-16 20:10:20 Duration: 1m46s 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-16 20:12:42 Duration: 5s741ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
2 1m15s 2 613ms 1m14s 37s628ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 16 20 2 1m15s 37s628ms [ User: intelifix - Total duration: 1m15s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m15s - Times executed: 2 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-16 20:06:23 Duration: 1m14s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-16 20:12:00 Duration: 613ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
3 53s337ms 3 3s427ms 38s640ms 17s779ms 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 16 20 3 53s337ms 17s779ms [ User: intelifix - Total duration: 53s337ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 53s337ms - 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-16 20:07:03 Duration: 38s640ms 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-16 20:12:12 Duration: 11s270ms 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-16 20:13:14 Duration: 3s427ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
4 50s784ms 3 2s177ms 39s911ms 16s928ms 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 16 20 3 50s784ms 16s928ms [ User: intelifix - Total duration: 50s784ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 50s784ms - Times executed: 3 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-16 20:07:48 Duration: 39s911ms 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-16 20:12:21 Duration: 8s695ms 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-16 20:13:16 Duration: 2s177ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
5 45s163ms 3 3s928ms 34s259ms 15s54ms 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 16 20 3 45s163ms 15s54ms [ User: intelifix - Total duration: 45s163ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 45s163ms - 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-16 20:10:55 Duration: 34s259ms 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-16 20:12:49 Duration: 6s974ms 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-16 20:13:25 Duration: 3s928ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
6 38s193ms 3 2s573ms 22s993ms 12s731ms 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 16 20 3 38s193ms 12s731ms [ User: intelifix - Total duration: 38s193ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 38s193ms - Times executed: 3 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-16 20:02:52 Duration: 22s993ms 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-16 20:11:21 Duration: 12s626ms 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-16 20:13:02 Duration: 2s573ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
7 37s179ms 3 1s760ms 23s607ms 12s393ms 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 16 20 3 37s179ms 12s393ms [ User: intelifix - Total duration: 37s179ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 37s179ms - Times executed: 3 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-16 20:03:34 Duration: 23s607ms 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-16 20:11:36 Duration: 11s810ms 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-16 20:13:05 Duration: 1s760ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
8 33s898ms 3 1s638ms 27s142ms 11s299ms 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 16 20 3 33s898ms 11s299ms [ User: intelifix - Total duration: 33s898ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 33s898ms - 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-16 20:04:40 Duration: 27s142ms 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-16 20:11:54 Duration: 5s117ms 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-16 20:13:10 Duration: 1s638ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
9 33s743ms 2 5s334ms 28s409ms 16s871ms 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 16 20 2 33s743ms 16s871ms [ User: intelifix - Total duration: 33s743ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 33s743ms - Times executed: 2 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-05-16 20:05:08 Duration: 28s409ms 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-16 20:11:59 Duration: 5s334ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 30s589ms 3 2s138ms 19s229ms 10s196ms 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 16 20 3 30s589ms 10s196ms [ User: intelifix - Total duration: 30s589ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 30s589ms - 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-16 20:03:53 Duration: 19s229ms 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-16 20:11:45 Duration: 9s220ms 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-16 20:13:07 Duration: 2s138ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
11 21s871ms 3 1s4ms 17s890ms 7s290ms 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 16 20 3 21s871ms 7s290ms [ User: intelifix - Total duration: 21s871ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 21s871ms - 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-16 20:03:10 Duration: 17s890ms 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-16 20:11:24 Duration: 2s975ms 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-16 20:13:03 Duration: 1s4ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
12 18s209ms 3 3s100ms 7s825ms 6s69ms 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 #12
Day Hour Count Duration Avg duration May 16 20 3 18s209ms 6s69ms [ User: intelifix - Total duration: 18s209ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 18s209ms - 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-16 20:12:34 Duration: 7s825ms 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-16 20:08:16 Duration: 7s284ms 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-16 20:13:21 Duration: 3s100ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
13 17s303ms 3 918ms 13s962ms 5s767ms copy public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration May 16 20 3 17s303ms 5s767ms [ User: intelifix - Total duration: 17s303ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 17s303ms - 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-16 20:02:26 Duration: 13s962ms 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-16 20:11:08 Duration: 2s422ms 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-16 20:13:00 Duration: 918ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
14 15s714ms 3 734ms 14s68ms 5s238ms 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 16 20 3 15s714ms 5s238ms [ User: intelifix - Total duration: 15s714ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 15s714ms - 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-16 20:04:13 Duration: 14s68ms 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-16 20:11:49 Duration: 911ms 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-16 20:13:09 Duration: 734ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
15 15s335ms 1 15s335ms 15s335ms 15s335ms 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 16 20 1 15s335ms 15s335ms [ User: intelifix - Total duration: 15s335ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 15s335ms - 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-16 20:08:04 Duration: 15s335ms Database: rio User: intelifix Remote: [local] Application: pg_dump
16 15s17ms 2 464ms 14s552ms 7s508ms 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 16 20 2 15s17ms 7s508ms [ User: intelifix - Total duration: 15s17ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 15s17ms - Times executed: 2 ]
-
COPY public.tcia_lote_fluxos (tl_id, flu_id, criacao) TO stdout;
Date: 2026-05-16 20:08:33 Duration: 14s552ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lote_fluxos (tl_id, flu_id, criacao) TO stdout;
Date: 2026-05-16 20:12:36 Duration: 464ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 10s234ms 3 3s340ms 3s491ms 3s411ms 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 16 20 3 10s234ms 3s411ms [ User: intelifix - Total duration: 10s234ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 10s234ms - Times executed: 3 ]
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-05-16 20:11:04 Duration: 3s491ms 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-16 20:12:58 Duration: 3s401ms 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-16 20:02:10 Duration: 3s340ms Database: rio User: intelifix Remote: [local] Application: pg_dump
18 9s120ms 3 587ms 5s693ms 3s40ms 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 16 20 3 9s120ms 3s40ms [ User: intelifix - Total duration: 9s120ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 9s120ms - 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-16 20:03:59 Duration: 5s693ms 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-16 20:11:48 Duration: 2s839ms 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-16 20:13:08 Duration: 587ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
19 5s144ms 2 1s97ms 4s46ms 2s572ms 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 16 20 2 5s144ms 2s572ms [ User: intelifix - Total duration: 5s144ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 5s144ms - 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-16 20:12:25 Duration: 4s46ms 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-16 20:13:17 Duration: 1s97ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
20 5s113ms 3 1s597ms 1s881ms 1s704ms 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 16 20 3 5s113ms 1s704ms [ User: intelifix - Total duration: 5s113ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 5s113ms - Times executed: 3 ]
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-16 20:11:00 Duration: 1s881ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-16 20:12:55 Duration: 1s635ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-16 20:02:06 Duration: 1s597ms Database: rio User: intelifix Remote: [local] Application: pg_dump
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 3 53s337ms 3s427ms 38s640ms 17s779ms 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 16 20 3 53s337ms 17s779ms [ User: intelifix - Total duration: 53s337ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 53s337ms - 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-16 20:07:03 Duration: 38s640ms 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-16 20:12:12 Duration: 11s270ms 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-16 20:13:14 Duration: 3s427ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
2 3 50s784ms 2s177ms 39s911ms 16s928ms 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 16 20 3 50s784ms 16s928ms [ User: intelifix - Total duration: 50s784ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 50s784ms - Times executed: 3 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-16 20:07:48 Duration: 39s911ms 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-16 20:12:21 Duration: 8s695ms 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-16 20:13:16 Duration: 2s177ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
3 3 45s163ms 3s928ms 34s259ms 15s54ms 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 16 20 3 45s163ms 15s54ms [ User: intelifix - Total duration: 45s163ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 45s163ms - 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-16 20:10:55 Duration: 34s259ms 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-16 20:12:49 Duration: 6s974ms 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-16 20:13:25 Duration: 3s928ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
4 3 38s193ms 2s573ms 22s993ms 12s731ms 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 16 20 3 38s193ms 12s731ms [ User: intelifix - Total duration: 38s193ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 38s193ms - Times executed: 3 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-16 20:02:52 Duration: 22s993ms 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-16 20:11:21 Duration: 12s626ms 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-16 20:13:02 Duration: 2s573ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
5 3 37s179ms 1s760ms 23s607ms 12s393ms 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 16 20 3 37s179ms 12s393ms [ User: intelifix - Total duration: 37s179ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 37s179ms - Times executed: 3 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-16 20:03:34 Duration: 23s607ms 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-16 20:11:36 Duration: 11s810ms 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-16 20:13:05 Duration: 1s760ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
6 3 33s898ms 1s638ms 27s142ms 11s299ms 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 16 20 3 33s898ms 11s299ms [ User: intelifix - Total duration: 33s898ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 33s898ms - 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-16 20:04:40 Duration: 27s142ms 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-16 20:11:54 Duration: 5s117ms 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-16 20:13:10 Duration: 1s638ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
7 3 30s589ms 2s138ms 19s229ms 10s196ms 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 16 20 3 30s589ms 10s196ms [ User: intelifix - Total duration: 30s589ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 30s589ms - 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-16 20:03:53 Duration: 19s229ms 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-16 20:11:45 Duration: 9s220ms 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-16 20:13:07 Duration: 2s138ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
8 3 21s871ms 1s4ms 17s890ms 7s290ms 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 16 20 3 21s871ms 7s290ms [ User: intelifix - Total duration: 21s871ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 21s871ms - 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-16 20:03:10 Duration: 17s890ms 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-16 20:11:24 Duration: 2s975ms 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-16 20:13:03 Duration: 1s4ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
9 3 18s209ms 3s100ms 7s825ms 6s69ms 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 #9
Day Hour Count Duration Avg duration May 16 20 3 18s209ms 6s69ms [ User: intelifix - Total duration: 18s209ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 18s209ms - 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-16 20:12:34 Duration: 7s825ms 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-16 20:08:16 Duration: 7s284ms 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-16 20:13:21 Duration: 3s100ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
10 3 17s303ms 918ms 13s962ms 5s767ms copy public.caixa_itens (cai_id, flu_id, tr_id, cai_ordem, cai_data_hora, cai_data, fd_id, fd_valor, cai_detalhes, anf_id, cai_valor, cai_garantia, ace_id, cai_retrabalho, usu_id, aud_id) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration May 16 20 3 17s303ms 5s767ms [ User: intelifix - Total duration: 17s303ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 17s303ms - 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-16 20:02:26 Duration: 13s962ms 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-16 20:11:08 Duration: 2s422ms 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-16 20:13:00 Duration: 918ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
11 3 15s714ms 734ms 14s68ms 5s238ms copy public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration May 16 20 3 15s714ms 5s238ms [ User: intelifix - Total duration: 15s714ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 15s714ms - 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-16 20:04:13 Duration: 14s68ms 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-16 20:11:49 Duration: 911ms 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-16 20:13:09 Duration: 734ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
12 3 10s234ms 3s340ms 3s491ms 3s411ms 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 16 20 3 10s234ms 3s411ms [ User: intelifix - Total duration: 10s234ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 10s234ms - Times executed: 3 ]
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-05-16 20:11:04 Duration: 3s491ms 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-16 20:12:58 Duration: 3s401ms 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-16 20:02:10 Duration: 3s340ms Database: rio User: intelifix Remote: [local] Application: pg_dump
13 3 9s120ms 587ms 5s693ms 3s40ms 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 16 20 3 9s120ms 3s40ms [ User: intelifix - Total duration: 9s120ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 9s120ms - 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-16 20:03:59 Duration: 5s693ms 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-16 20:11:48 Duration: 2s839ms 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-16 20:13:08 Duration: 587ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
14 3 5s113ms 1s597ms 1s881ms 1s704ms 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 16 20 3 5s113ms 1s704ms [ User: intelifix - Total duration: 5s113ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 5s113ms - Times executed: 3 ]
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-16 20:11:00 Duration: 1s881ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-16 20:12:55 Duration: 1s635ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-16 20:02:06 Duration: 1s597ms Database: rio User: intelifix Remote: [local] Application: pg_dump
15 3 2s571ms 212ms 1s799ms 857ms copy public.lote_caixas (cai_id, lot_id, cai_criacao, usu_id, mod_id, is_id, novo, qtd, cai_obs, cai_check, cai_check_data, cai_check_user, cai_check_mens) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration May 16 20 3 2s571ms 857ms [ User: intelifix - Total duration: 2s571ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 2s571ms - Times executed: 3 ]
-
COPY public.lote_caixas (cai_id, lot_id, cai_criacao, usu_id, mod_id, is_id, novo, qtd, cai_obs, cai_check, cai_check_data, cai_check_user, cai_check_mens) TO stdout;
Date: 2026-05-16 20:06:25 Duration: 1s799ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_caixas (cai_id, lot_id, cai_criacao, usu_id, mod_id, is_id, novo, qtd, cai_obs, cai_check, cai_check_data, cai_check_user, cai_check_mens) TO stdout;
Date: 2026-05-16 20:12:01 Duration: 559ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_caixas (cai_id, lot_id, cai_criacao, usu_id, mod_id, is_id, novo, qtd, cai_obs, cai_check, cai_check_data, cai_check_user, cai_check_mens) TO stdout;
Date: 2026-05-16 20:13:10 Duration: 212ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
16 3 1s390ms 173ms 756ms 463ms copy public.lotes (lot_id, lot_criacao, ofi_id, usu_id, cli_id, lot_tipo, lot_qtd_itens, mod_id, lot_data, lot_notafiscal, lot_qtd_cq, lot_lote_saida, arq_id, con_id, ss_id, lot_sem_serial, lot_status, lot_sucata, lot_novo, cli_original, nota_original, lot_preco_unit, lot_stone, lc_id) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 16 20 3 1s390ms 463ms [ User: intelifix - Total duration: 1s390ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 1s390ms - 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-16 20:07:04 Duration: 756ms 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-16 20:12:12 Duration: 460ms 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-16 20:13:14 Duration: 173ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
17 3 546ms 158ms 218ms 182ms copy ceps2009.cep_bairros (id, uf, idloc, bairro) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration May 16 20 3 546ms 182ms [ User: intelifix - Total duration: 546ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 546ms - Times executed: 3 ]
-
COPY ceps2009.cep_bairros (id, uf, idloc, bairro) TO stdout;
Date: 2026-05-16 20:02:04 Duration: 218ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_bairros (id, uf, idloc, bairro) TO stdout;
Date: 2026-05-16 20:12:53 Duration: 168ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_bairros (id, uf, idloc, bairro) TO stdout;
Date: 2026-05-16 20:10:59 Duration: 158ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 2 1m52s 5s741ms 1m46s 56s291ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 16 20 2 1m52s 56s291ms [ User: intelifix - Total duration: 1m52s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m52s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-16 20:10:20 Duration: 1m46s 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-16 20:12:42 Duration: 5s741ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 2 1m15s 613ms 1m14s 37s628ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration May 16 20 2 1m15s 37s628ms [ User: intelifix - Total duration: 1m15s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m15s - Times executed: 2 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-16 20:06:23 Duration: 1m14s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-16 20:12:00 Duration: 613ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 2 33s743ms 5s334ms 28s409ms 16s871ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 16 20 2 33s743ms 16s871ms [ User: intelifix - Total duration: 33s743ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 33s743ms - Times executed: 2 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-05-16 20:05:08 Duration: 28s409ms 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-16 20:11:59 Duration: 5s334ms 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 5s741ms 1m46s 56s291ms 2 1m52s 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 16 20 2 1m52s 56s291ms [ User: intelifix - Total duration: 1m52s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m52s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-16 20:10:20 Duration: 1m46s 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-16 20:12:42 Duration: 5s741ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
2 613ms 1m14s 37s628ms 2 1m15s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 16 20 2 1m15s 37s628ms [ User: intelifix - Total duration: 1m15s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m15s - Times executed: 2 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-16 20:06:23 Duration: 1m14s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-16 20:12:00 Duration: 613ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
3 3s427ms 38s640ms 17s779ms 3 53s337ms 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 16 20 3 53s337ms 17s779ms [ User: intelifix - Total duration: 53s337ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 53s337ms - 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-16 20:07:03 Duration: 38s640ms 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-16 20:12:12 Duration: 11s270ms 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-16 20:13:14 Duration: 3s427ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
4 2s177ms 39s911ms 16s928ms 3 50s784ms 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 16 20 3 50s784ms 16s928ms [ User: intelifix - Total duration: 50s784ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 50s784ms - Times executed: 3 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-16 20:07:48 Duration: 39s911ms 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-16 20:12:21 Duration: 8s695ms 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-16 20:13:16 Duration: 2s177ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
5 5s334ms 28s409ms 16s871ms 2 33s743ms 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 16 20 2 33s743ms 16s871ms [ User: intelifix - Total duration: 33s743ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 33s743ms - Times executed: 2 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-05-16 20:05:08 Duration: 28s409ms 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-16 20:11:59 Duration: 5s334ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 15s335ms 15s335ms 15s335ms 1 15s335ms 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 16 20 1 15s335ms 15s335ms [ User: intelifix - Total duration: 15s335ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 15s335ms - 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-16 20:08:04 Duration: 15s335ms Database: rio User: intelifix Remote: [local] Application: pg_dump
7 3s928ms 34s259ms 15s54ms 3 45s163ms copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration May 16 20 3 45s163ms 15s54ms [ User: intelifix - Total duration: 45s163ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 45s163ms - 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-16 20:10:55 Duration: 34s259ms 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-16 20:12:49 Duration: 6s974ms 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-16 20:13:25 Duration: 3s928ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
8 2s573ms 22s993ms 12s731ms 3 38s193ms 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 16 20 3 38s193ms 12s731ms [ User: intelifix - Total duration: 38s193ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 38s193ms - Times executed: 3 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-16 20:02:52 Duration: 22s993ms 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-16 20:11:21 Duration: 12s626ms 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-16 20:13:02 Duration: 2s573ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
9 1s760ms 23s607ms 12s393ms 3 37s179ms 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 16 20 3 37s179ms 12s393ms [ User: intelifix - Total duration: 37s179ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 37s179ms - Times executed: 3 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-16 20:03:34 Duration: 23s607ms 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-16 20:11:36 Duration: 11s810ms 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-16 20:13:05 Duration: 1s760ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
10 1s638ms 27s142ms 11s299ms 3 33s898ms 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 16 20 3 33s898ms 11s299ms [ User: intelifix - Total duration: 33s898ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 33s898ms - 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-16 20:04:40 Duration: 27s142ms 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-16 20:11:54 Duration: 5s117ms 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-16 20:13:10 Duration: 1s638ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
11 2s138ms 19s229ms 10s196ms 3 30s589ms 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 16 20 3 30s589ms 10s196ms [ User: intelifix - Total duration: 30s589ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 30s589ms - 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-16 20:03:53 Duration: 19s229ms 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-16 20:11:45 Duration: 9s220ms 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-16 20:13:07 Duration: 2s138ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
12 464ms 14s552ms 7s508ms 2 15s17ms copy public.tcia_lote_fluxos (tl_id, flu_id, criacao) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration May 16 20 2 15s17ms 7s508ms [ User: intelifix - Total duration: 15s17ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 15s17ms - Times executed: 2 ]
-
COPY public.tcia_lote_fluxos (tl_id, flu_id, criacao) TO stdout;
Date: 2026-05-16 20:08:33 Duration: 14s552ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lote_fluxos (tl_id, flu_id, criacao) TO stdout;
Date: 2026-05-16 20:12:36 Duration: 464ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 1s4ms 17s890ms 7s290ms 3 21s871ms 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 #13
Day Hour Count Duration Avg duration May 16 20 3 21s871ms 7s290ms [ User: intelifix - Total duration: 21s871ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 21s871ms - 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-16 20:03:10 Duration: 17s890ms 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-16 20:11:24 Duration: 2s975ms 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-16 20:13:03 Duration: 1s4ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
14 3s100ms 7s825ms 6s69ms 3 18s209ms copy public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration May 16 20 3 18s209ms 6s69ms [ User: intelifix - Total duration: 18s209ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 18s209ms - 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-16 20:12:34 Duration: 7s825ms 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-16 20:08:16 Duration: 7s284ms 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-16 20:13:21 Duration: 3s100ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
15 918ms 13s962ms 5s767ms 3 17s303ms 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 16 20 3 17s303ms 5s767ms [ User: intelifix - Total duration: 17s303ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 17s303ms - 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-16 20:02:26 Duration: 13s962ms 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-16 20:11:08 Duration: 2s422ms 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-16 20:13:00 Duration: 918ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
16 734ms 14s68ms 5s238ms 3 15s714ms copy public.fluxo_passos (fp_id, flu_id, wfp_id, res_id, fp_criacao, tec_id, fp_data, mot_id, fp_obs, fp_foto, om_id) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 16 20 3 15s714ms 5s238ms [ User: intelifix - Total duration: 15s714ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 15s714ms - 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-16 20:04:13 Duration: 14s68ms 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-16 20:11:49 Duration: 911ms 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-16 20:13:09 Duration: 734ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
17 3s340ms 3s491ms 3s411ms 3 10s234ms 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 16 20 3 10s234ms 3s411ms [ User: intelifix - Total duration: 10s234ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 10s234ms - Times executed: 3 ]
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-05-16 20:11:04 Duration: 3s491ms 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-16 20:12:58 Duration: 3s401ms 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-16 20:02:10 Duration: 3s340ms Database: rio User: intelifix Remote: [local] Application: pg_dump
18 587ms 5s693ms 3s40ms 3 9s120ms 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 16 20 3 9s120ms 3s40ms [ User: intelifix - Total duration: 9s120ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 9s120ms - 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-16 20:03:59 Duration: 5s693ms 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-16 20:11:48 Duration: 2s839ms 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-16 20:13:08 Duration: 587ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
19 1s97ms 4s46ms 2s572ms 2 5s144ms 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 16 20 2 5s144ms 2s572ms [ User: intelifix - Total duration: 5s144ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 5s144ms - 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-16 20:12:25 Duration: 4s46ms 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-16 20:13:17 Duration: 1s97ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
20 1s597ms 1s881ms 1s704ms 3 5s113ms 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 16 20 3 5s113ms 1s704ms [ User: intelifix - Total duration: 5s113ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 5s113ms - Times executed: 3 ]
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-16 20:11:00 Duration: 1s881ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-16 20:12:55 Duration: 1s635ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-16 20:02:06 Duration: 1s597ms Database: rio User: intelifix Remote: [local] Application: pg_dump
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
-
Events
Log levels
Key values
- 100 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