pgBadger-
Global information
- Generated on Fri May 15 23:50:24 2026
- Log file: /usr/local/pgsql/data/log/serverlog-04.log, ..., /usr/local/pgsql/data/log/serverlog-26.log
- Parsed 1,928 log entries in 23s
- Log start from 2026-05-15 09:16:36 to 2026-05-15 20:16:10
-
Overview
Global Stats
- 79 Number of unique normalized queries
- 323 Number of queries
- 36m7s Total query duration
- 2026-05-15 09:16:42 First query
- 2026-05-15 20:13:07 Last query
- 4 queries/s at 2026-05-15 10:46:57 Query peak
- 36m7s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 36m7s Execute total duration
- 22 Number of events
- 2 Number of unique normalized events
- 18 Max number of times the same event was reported
- 0 Number of cancellation
- 37 Total number of automatic vacuums
- 51 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 74 Total number of sessions
- 11 sessions at 2026-05-15 09:34:17 Session peak
- 1d17h15m59s Total duration of sessions
- 33m27s Average duration of sessions
- 4 Average queries per session
- 29s284ms Average queries duration per session
- 32m58s Average idle time per session
- 74 Total number of connections
- 4 connections/s at 2026-05-15 10:05:06 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 4 queries/s Query Peak
- 2026-05-15 10:46:57 Date
SELECT Traffic
Key values
- 3 queries/s Query Peak
- 2026-05-15 09:32:05 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-05-15 10:46:57 Date
Queries duration
Key values
- 36m7s 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 15 09 55 0ms 12s595ms 2s279ms 23s144ms 40s908ms 40s908ms 10 101 0ms 1m46s 6s860ms 1m10s 1m18s 1m47s 11 9 0ms 895ms 563ms 1s736ms 2s891ms 2s891ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 73 0ms 9m58s 9s468ms 11s478ms 30s720ms 10m2s 16 0 0ms 0ms 0ms 0ms 0ms 0ms 20 85 0ms 1m41s 7s677ms 1m33s 2m24s 2m24s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 15 09 33 0 1s972ms 6s493ms 18s335ms 21s342ms 10 13 84 7s133ms 1m1s 1m10s 1m47s 11 8 0 584ms 444ms 1s339ms 2s891ms 12 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 47 0 13s441ms 1s989ms 2s993ms 9m58s 16 0 0 0ms 0ms 0ms 0ms 20 4 81 7s677ms 1m20s 1m33s 2m24s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 15 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare May 15 09 0 6 6.00 0.00% 10 0 3 3.00 0.00% 11 0 2 2.00 0.00% 12 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 8 8.00 0.00% 16 0 0 0.00 0.00% 20 0 0 0.00 0.00% Day Hour Count Average / Second May 15 09 32 0.01/s 10 16 0.00/s 11 5 0.00/s 12 0 0.00/s 14 4 0.00/s 15 14 0.00/s 16 0 0.00/s 20 3 0.00/s Day Hour Count Average Duration Average idle time May 15 09 32 15m57s 15m53s 10 4 2m55s 1s929ms 11 13 57m31s 57m31s 12 4 1h1m30s 1h1m30s 14 1 10m32s 10m32s 15 5 41m5s 38m47s 16 12 1h1m2s 1h1m2s 20 3 3m41s 4s75ms -
Connections
Established Connections
Key values
- 4 connections Connection Peak
- 2026-05-15 10:05:06 Date
Connections per database
Key values
- contagem Main Database
- 74 connections Total
Connections per user
Key values
- lenon Main User
- 74 connections Total
-
Sessions
Simultaneous sessions
Key values
- 11 sessions Session Peak
- 2026-05-15 09:34:17 Date
Histogram of session times
Key values
- 30 3600000-28800000ms duration
Sessions per database
Key values
- contagem Main Database
- 74 sessions Total
Sessions per user
Key values
- lenon Main User
- 74 sessions Total
Sessions per host
Key values
- [local] Main Host
- 74 sessions Total
Sessions per application
Key values
- [unknown] Main Application
- 74 sessions Total
Application Count Total Duration Average Duration [unknown] 55 1d14h17m3s 41m45s pgAdmin 4 - CONN:317375 1 16m52s 16m52s pgAdmin 4 - CONN:4169423 4 31s709ms 7s927ms pgAdmin 4 - CONN:4928586 1 37s27ms 37s27ms pgAdmin 4 - CONN:6961207 2 18m34s 9m17s pgAdmin 4 - DB:brasilia 2 21m41s 10m50s pgAdmin 4 - DB:contagem 1 21m39s 21m39s pgAdmin 4 - DB:postgres 1 38m9s 38m9s pgAdmin 4 - DB:rio 1 38m3s 38m3s pg_dump 6 22m45s 3m47s -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 2,532 buffers Checkpoint Peak
- 2026-05-15 09:44:34 Date
- 269.994 seconds Highest write time
- 0.014 seconds Sync time
Checkpoints Wal files
Key values
- 0 files Wal files usage Peak
- 2026-05-15 09:56:46 Date
Checkpoints distance
Key values
- 82.82 Mo Distance Peak
- 2026-05-15 09:44:34 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time May 15 09 7,323 695.914s 0.04s 696.023s 10 922 92.593s 0.015s 92.64s 11 94 9.486s 0.007s 9.502s 12 0 0s 0s 0s 14 0 0s 0s 0s 15 2,717 294.145s 0.04s 294.224s 16 0 0s 0s 0s 20 322 32.406s 0.009s 32.433s Day Hour Added Removed Recycled Synced files Longest sync Average sync May 15 09 0 7 0 880 0.002s 0.009s 10 0 0 0 185 0.002s 0.006s 11 0 0 0 70 0.002s 0.002s 12 0 0 0 0 0s 0s 14 0 0 0 0 0s 0s 15 0 3 0 701 0.003s 0.006s 16 0 0 0 0 0s 0s 20 0 0 0 188 0.002s 0.003s Day Hour Count Avg time (sec) May 15 09 0 0s 10 0 0s 11 0 0s 12 0 0s 14 0 0s 15 0 0s 16 0 0s 20 0 0s Day Hour Mean distance Mean estimate May 15 09 13,341.00 kB 22,983.12 kB 10 518.17 kB 697.50 kB 11 150.00 kB 1,444.00 kB 12 0.00 kB 0.00 kB 14 0.00 kB 0.00 kB 15 8,750.17 kB 14,362.33 kB 16 0.00 kB 0.00 kB 20 494.00 kB 17,336.33 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 15 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 20 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.08 sec Highest CPU-cost vacuum
Table pg_catalog.pg_shdepend
Database template1 - 2026-05-15 09:39:20 Date
- 0 sec Highest CPU-cost analyze
Table
Database template1 - Date
Average Autovacuum Duration
Key values
- 0.08 sec Highest CPU-cost vacuum
Table pg_catalog.pg_shdepend
Database template1 - 2026-05-15 09:39:20 Date
Analyzes per table
Key values
- public.temp0000232294 (10) Main table analyzed (database brasilia)
- 51 analyzes Total
Table Number of analyzes brasilia.public.temp0000232294 10 contagem.public.temp0000226040 6 brasilia.auditor.auditor_2026_05 4 contagem.auditor.auditor_2026_05 3 rio.public.temp0000277706 3 rio.pg_catalog.pg_attribute 2 rio.auditor.auditor_2026_05 2 brasilia.pg_catalog.pg_shdepend 2 brasilia.pg_catalog.pg_attribute 2 brasilia.public.temp0000232296 2 rio.pg_catalog.pg_type 1 contagem.pg_catalog.pg_index 1 contagem.public.nf_entrada 1 brasilia.pg_catalog.pg_depend 1 contagem.pg_catalog.pg_type 1 contagem.pg_catalog.pg_attribute 1 brasilia.public.nf_entrada 1 contagem.pg_catalog.pg_class 1 rio.pg_catalog.pg_index 1 rio.pg_catalog.pg_depend 1 contagem.pg_catalog.pg_depend 1 brasilia.pg_catalog.pg_class 1 rio.pg_catalog.pg_class 1 brasilia.pg_catalog.pg_index 1 brasilia.pg_catalog.pg_type 1 Total 51 Vacuums per table
Key values
- public.temp0000232294 (10) Main table vacuumed on database brasilia
- 37 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples brasilia.public.temp0000232294 10 0 0 0 0 0 0 2,182 60 139,648 0 0 rio.public.temp0000277706 3 0 0 0 0 0 0 4,356 12 258,813 0 0 brasilia.auditor.auditor_2026_05 3 0 0 0 0 0 0 301 34 63,112 2 96 contagem.auditor.auditor_2026_05 3 0 0 0 0 0 0 229 9 16,527 0 0 brasilia.public.temp0000232296 2 0 0 0 0 0 0 436 12 27,900 0 0 brasilia.pg_catalog.pg_attribute 1 1 0 0 0 0 0 682 103 276,176 4 168 contagem.pg_catalog.pg_index 1 1 0 0 0 0 0 69 31 55,848 0 0 rio.pg_catalog.pg_type 1 1 0 0 0 0 0 79 7 17,590 2 56 rio.pg_catalog.pg_attribute 1 1 0 0 0 0 0 782 143 323,837 10 278 rio.pg_catalog.pg_class 1 1 0 0 0 0 0 243 63 161,571 0 0 rio.pg_catalog.pg_statistic 1 1 0 0 0 0 0 302 105 399,212 76 647 rio.pg_catalog.pg_depend 1 1 0 0 0 0 0 188 35 113,272 9 1,147 brasilia.pg_catalog.pg_class 1 1 0 0 0 0 0 238 57 153,062 0 0 brasilia.pg_catalog.pg_type 1 1 0 0 0 0 0 70 3 13,714 0 0 template1.pg_catalog.pg_shdepend 1 1 0 0 0 0 0 96 38 89,476 34 4,176 rio.pg_catalog.pg_index 1 1 0 0 0 0 0 69 32 56,548 1 40 contagem.pg_catalog.pg_class 1 1 0 0 0 0 0 240 62 160,445 0 0 rio.auditor.auditor_2026_05 1 0 0 0 0 0 0 123 5 10,506 1 33 contagem.pg_catalog.pg_attribute 1 1 0 0 0 0 0 694 109 286,532 2 66 contagem.pg_catalog.pg_type 1 1 0 0 0 0 0 75 6 15,800 1 35 brasilia.pg_catalog.pg_index 1 1 0 0 0 0 0 70 32 56,061 1 44 Total 37 15 0 0 0 0 0 11,524 958 2,695,650 143 6,786 Vacuum throughput per table
Key values
- public.temp0000232294 (0.2) Max CPU elapsed for vacuum on database brasilia
- unknown (0 ms) Max I/O read time for vacuum on database brasilia
- unknown (0 ms) Max I/O write time for vacuum on database brasilia
I/O timing (ms) CPU (s) Table read write elapsed brasilia.public.temp0000232294 0 0 0.2 rio.public.temp0000277706 0 0 0.12 brasilia.auditor.auditor_2026_05 0 0 0.02 contagem.auditor.auditor_2026_05 0 0 0 brasilia.public.temp0000232296 0 0 0.04 brasilia.pg_catalog.pg_attribute 0 0 0.08 contagem.pg_catalog.pg_index 0 0 0 rio.pg_catalog.pg_type 0 0 0.04 rio.pg_catalog.pg_attribute 0 0 0.07 rio.pg_catalog.pg_class 0 0 0.03 rio.pg_catalog.pg_statistic 0 0 0.02 rio.pg_catalog.pg_depend 0 0 0.07 brasilia.pg_catalog.pg_class 0 0 0.03 brasilia.pg_catalog.pg_type 0 0 0.01 template1.pg_catalog.pg_shdepend 0 0 0.08 rio.pg_catalog.pg_index 0 0 0.01 contagem.pg_catalog.pg_class 0 0 0.02 rio.auditor.auditor_2026_05 0 0 0 contagem.pg_catalog.pg_attribute 0 0 0.05 contagem.pg_catalog.pg_type 0 0 0 brasilia.pg_catalog.pg_index 0 0 0 Total 0 0 0.89 Tuples removed per table
Key values
- pg_catalog.pg_attribute (8331) Main table with removed tuples on database rio
- 28215 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 1 1 8,331 16,938 0 0 459 brasilia.pg_catalog.pg_attribute 1 1 7,866 16,905 0 0 430 contagem.pg_catalog.pg_attribute 1 1 7,840 17,355 0 0 441 brasilia.pg_catalog.pg_type 1 1 772 1,988 0 0 65 contagem.pg_catalog.pg_type 1 1 762 2,024 0 0 67 rio.pg_catalog.pg_type 1 1 756 1,997 0 0 67 contagem.pg_catalog.pg_index 1 1 391 1,211 0 0 37 rio.pg_catalog.pg_index 1 1 387 1,201 0 0 37 brasilia.pg_catalog.pg_index 1 1 366 1,186 0 0 37 template1.pg_catalog.pg_shdepend 1 1 313 13,058 0 0 100 rio.pg_catalog.pg_statistic 1 1 305 1,537 0 0 156 rio.pg_catalog.pg_depend 1 1 67 18,264 0 0 154 rio.pg_catalog.pg_class 1 1 26 2,521 0 0 109 contagem.pg_catalog.pg_class 1 1 21 2,541 0 0 109 brasilia.pg_catalog.pg_class 1 1 12 2,481 0 0 108 brasilia.public.temp0000232296 2 0 0 5,601 0 92 420 rio.public.temp0000277706 3 0 0 61,253 0 0 4,416 brasilia.auditor.auditor_2026_05 3 0 0 22,812 0 0 559 rio.auditor.auditor_2026_05 1 0 0 4,467 0 0 118 brasilia.public.temp0000232294 10 0 0 27,999 0 458 2,102 contagem.auditor.auditor_2026_05 3 0 0 20,314 0 0 498 Total 37 15 28,215 243,653 0 550 10,489 Pages removed per table
Key values
- public.temp0000232294 (458) Main table with removed pages on database brasilia
- 550 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed brasilia.public.temp0000232294 10 0 0 458 brasilia.public.temp0000232296 2 0 0 92 brasilia.pg_catalog.pg_attribute 1 1 7866 0 rio.public.temp0000277706 3 0 0 0 brasilia.auditor.auditor_2026_05 3 0 0 0 contagem.pg_catalog.pg_index 1 1 391 0 rio.pg_catalog.pg_type 1 1 756 0 rio.pg_catalog.pg_attribute 1 1 8331 0 rio.pg_catalog.pg_class 1 1 26 0 rio.pg_catalog.pg_statistic 1 1 305 0 rio.pg_catalog.pg_depend 1 1 67 0 brasilia.pg_catalog.pg_class 1 1 12 0 brasilia.pg_catalog.pg_type 1 1 772 0 template1.pg_catalog.pg_shdepend 1 1 313 0 rio.pg_catalog.pg_index 1 1 387 0 contagem.pg_catalog.pg_class 1 1 21 0 rio.auditor.auditor_2026_05 1 0 0 0 contagem.pg_catalog.pg_attribute 1 1 7840 0 contagem.pg_catalog.pg_type 1 1 762 0 contagem.auditor.auditor_2026_05 3 0 0 0 brasilia.pg_catalog.pg_index 1 1 366 0 Total 37 15 28,215 550 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs May 15 09 26 35 10 0 0 11 0 0 12 0 0 14 0 0 15 11 16 16 0 0 20 0 0 - 0.08 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
- 105 Total read queries
- 218 Total write queries
Queries by database
Key values
- rio Main database
- 123 Requests
- 29m30s (rio)
- Main time consuming database
Queries by user
Key values
- lenon Main user
- 859 Requests
User Request type Count Duration intelifix Total 341 39m7s copy to 165 22m18s ddl 72 5m1s select 104 11m46s lenon Total 859 37m1s copy from 139 12m59s ddl 680 22m39s others 7 1m4s select 33 17s560ms Duration by user
Key values
- 39m7s (intelifix) Main time consuming user
User Request type Count Duration intelifix Total 341 39m7s copy to 165 22m18s ddl 72 5m1s select 104 11m46s lenon Total 859 37m1s copy from 139 12m59s ddl 680 22m39s others 7 1m4s select 33 17s560ms Queries by host
Key values
- [local] Main host
- 1,191 Requests
- 1h15m50s ([local])
- Main time consuming host
Queries by application
Key values
- pg_dump Main application
- 176 Requests
- 22m20s (pg_dump)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-05-15 15:38:45 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 113 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 9m58s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2025-12-01''),DATE(''2026-01-06'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');[ Date: 2026-05-15 15:36:21 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 1m46s COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;[ Date: 2026-05-15 10:46:57 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
3 1m41s COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;[ Date: 2026-05-15 20:10:09 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
4 1m18s COPY public.logs (mensagem, quando) TO stdout;[ Date: 2026-05-15 20:06:23 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
5 1m16s COPY public.logs (mensagem, quando) TO stdout;[ Date: 2026-05-15 10:42:53 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
6 43s201ms 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-15 10:43:38 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
7 41s172ms 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-15 10:47:39 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
8 39s293ms 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-15 20:07:04 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
9 38s66ms COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;[ Date: 2026-05-15 10:44:21 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
10 34s254ms COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;[ Date: 2026-05-15 20:07:43 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
11 33s798ms 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-15 20:10:43 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
12 29s388ms CREATE TABLE temp0000277706 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);[ Date: 2026-05-15 15:09:57 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 28s141ms COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;[ Date: 2026-05-15 10:39:22 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
14 27s33ms COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;[ Date: 2026-05-15 20:05:05 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
15 25s355ms COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;[ Date: 2026-05-15 10:40:05 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
16 25s66ms 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-15 20:04:37 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
17 24s917ms 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-15 10:41:11 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
18 24s841ms COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;[ Date: 2026-05-15 10:41:36 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
19 23s849ms COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;[ Date: 2026-05-15 20:02:53 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
20 22s52ms COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;[ Date: 2026-05-15 20:03:31 - Database: rio - User: intelifix - Remote: [local] - Application: pg_dump ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 10m14s 6 229ms 9m58s 1m42s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 15 09 3 15s421ms 5s140ms 15 3 9m58s 3m19s [ User: intelifix - Total duration: 10m14s - Times executed: 6 ]
[ Application: [unknown] - Total duration: 10m14s - Times executed: 6 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2025-12-01''),DATE(''2026-01-06'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-05-15 15:36:21 Duration: 9m58s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(7,80,''/var/www/html/uploads/LOTE AUTOMATICO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');
Date: 2026-05-15 09:40:27 Duration: 6s155ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,80,''/var/www/html/uploads/LOTE AUTOMATICO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');
Date: 2026-05-15 09:39:12 Duration: 5s790ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-15.log
2 3m37s 4 4s944ms 1m46s 54s486ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 15 10 2 1m51s 55s850ms 20 2 1m46s 53s122ms [ User: intelifix - Total duration: 3m37s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m37s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-15 10:46:57 Duration: 1m46s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-15 20:10:09 Duration: 1m41s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-15 10:49:19 Duration: 5s440ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
3 2m36s 4 485ms 1m18s 39s32ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 15 10 2 1m16s 38s454ms 20 2 1m19s 39s610ms [ User: intelifix - Total duration: 2m36s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m36s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-15 20:06:23 Duration: 1m18s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-15 10:42:53 Duration: 1m16s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-15 10:48:40 Duration: 574ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
4 1m49s 6 2s418ms 43s201ms 18s217ms 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 #4
Day Hour Count Duration Avg duration May 15 10 3 56s252ms 18s750ms 20 3 53s50ms 17s683ms [ User: intelifix - Total duration: 1m49s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m49s - Times executed: 6 ]
-
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-15 10:43:38 Duration: 43s201ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
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-15 20:07:04 Duration: 39s293ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
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-15 20:11:52 Duration: 10s985ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
5 1m39s 6 4s754ms 41s172ms 16s522ms 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 15 10 3 52s914ms 17s638ms 20 3 46s221ms 15s407ms [ User: intelifix - Total duration: 1m39s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m39s - Times executed: 6 ]
-
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-15 10:47:39 Duration: 41s172ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
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-15 20:10:43 Duration: 33s798ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
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-15 10:49:26 Duration: 6s986ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
6 1m34s 6 1s877ms 38s66ms 15s792ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration May 15 10 3 48s545ms 16s181ms 20 3 46s208ms 15s402ms [ User: intelifix - Total duration: 1m34s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m34s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-15 10:44:21 Duration: 38s66ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-15 20:07:43 Duration: 34s254ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-15 20:12:03 Duration: 10s75ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
7 1m18s 6 2s81ms 28s141ms 13s99ms 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 15 10 3 40s683ms 13s561ms 20 3 37s914ms 12s638ms [ User: intelifix - Total duration: 1m18s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m18s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-15 10:39:22 Duration: 28s141ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-15 20:02:53 Duration: 23s849ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-15 20:11:08 Duration: 11s984ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
8 1m11s 6 1s752ms 25s355ms 11s909ms 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 15 10 3 38s468ms 12s822ms 20 3 32s987ms 10s995ms [ User: intelifix - Total duration: 1m11s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m11s - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-15 10:40:05 Duration: 25s355ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-15 20:03:31 Duration: 22s52ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-15 10:48:18 Duration: 10s668ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
9 1m3s 6 1s643ms 25s66ms 10s504ms 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 #9
Day Hour Count Duration Avg duration May 15 10 3 31s599ms 10s533ms 20 3 31s428ms 10s476ms [ User: intelifix - Total duration: 1m3s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m3s - Times executed: 6 ]
-
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-15 20:04:37 Duration: 25s66ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
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-15 10:41:11 Duration: 24s917ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
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-15 10:48:35 Duration: 5s38ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
10 1m2s 4 9s855ms 29s388ms 15s739ms create table temp0000277706 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration May 15 09 3 33s569ms 11s189ms 15 1 29s388ms 29s388ms [ User: intelifix - Total duration: 1m2s - Times executed: 4 ]
[ Application: [unknown] - Total duration: 1m2s - Times executed: 4 ]
-
CREATE TABLE temp0000277706 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-15 15:09:57 Duration: 29s388ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
CREATE TABLE temp0000277706 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-15 09:29:22 Duration: 12s194ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
CREATE TABLE temp0000277706 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-15 09:35:30 Duration: 11s519ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-15.log
11 1m 4 4s243ms 27s33ms 15s243ms copy public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration May 15 10 2 29s85ms 14s542ms 20 2 31s888ms 15s944ms [ User: intelifix - Total duration: 1m - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-05-15 20:05:05 Duration: 27s33ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-05-15 10:41:36 Duration: 24s841ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-05-15 20:11:40 Duration: 4s854ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
12 57s396ms 6 1s147ms 19s253ms 9s566ms 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 #12
Day Hour Count Duration Avg duration May 15 10 3 29s447ms 9s815ms 20 3 27s949ms 9s316ms [ User: intelifix - Total duration: 57s396ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 57s396ms - Times executed: 6 ]
-
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-15 10:40:25 Duration: 19s253ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
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-15 20:03:50 Duration: 18s722ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
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-15 10:48:27 Duration: 8s360ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
13 42s11ms 6 908ms 17s842ms 7s1ms 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 15 10 3 22s242ms 7s414ms 20 3 19s768ms 6s589ms [ User: intelifix - Total duration: 42s11ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 42s11ms - Times executed: 6 ]
-
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-15 10:39:40 Duration: 17s842ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
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-15 20:03:09 Duration: 16s64ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
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-15 10:48:08 Duration: 3s229ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
14 37s612ms 6 2s931ms 8s806ms 6s268ms 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 15 10 3 18s502ms 6s167ms 20 3 19s109ms 6s369ms [ User: intelifix - Total duration: 37s612ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 37s612ms - Times executed: 6 ]
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-05-15 20:08:13 Duration: 8s806ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-05-15 10:44:51 Duration: 8s600ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-05-15 20:12:16 Duration: 7s371ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
15 37s290ms 17 1s225ms 9s710ms 2s193ms create table temp0000232294 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration May 15 09 7 19s66ms 2s723ms 15 10 18s223ms 1s822ms [ User: intelifix - Total duration: 37s290ms - Times executed: 17 ]
[ Application: [unknown] - Total duration: 37s290ms - Times executed: 17 ]
-
CREATE TABLE temp0000232294 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 07);
Date: 2026-05-15 09:32:54 Duration: 9s710ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
CREATE TABLE temp0000232294 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 07);
Date: 2026-05-15 15:27:07 Duration: 4s686ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
CREATE TABLE temp0000232294 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 07);
Date: 2026-05-15 09:39:16 Duration: 1s868ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-15.log
16 35s263ms 6 877ms 14s863ms 5s877ms 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 15 10 3 18s793ms 6s264ms 20 3 16s470ms 5s490ms [ User: intelifix - Total duration: 35s263ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 35s263ms - Times executed: 6 ]
-
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-15 10:38:50 Duration: 14s863ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
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-15 20:02:26 Duration: 12s889ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
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-15 10:47:53 Duration: 3s52ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
17 34s726ms 6 866ms 16s323ms 5s787ms 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 #17
Day Hour Count Duration Avg duration May 15 10 3 16s490ms 5s496ms 20 3 18s236ms 6s78ms [ User: intelifix - Total duration: 34s726ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 34s726ms - Times executed: 6 ]
-
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-15 20:04:12 Duration: 16s323ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
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-15 10:40:46 Duration: 14s750ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
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-15 20:12:48 Duration: 1s9ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
18 32s439ms 2 15s738ms 16s701ms 16s219ms 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 #18
Day Hour Count Duration Avg duration May 15 10 1 16s701ms 16s701ms 20 1 15s738ms 15s738ms [ User: intelifix - Total duration: 32s439ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 32s439ms - Times executed: 2 ]
-
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-15 10:44:38 Duration: 16s701ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
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-15 20:07:59 Duration: 15s738ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
19 29s49ms 4 416ms 16s244ms 7s262ms copy public.tcia_lote_fluxos (tl_id, flu_id, criacao) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration May 15 10 2 16s701ms 8s350ms 20 2 12s348ms 6s174ms [ User: intelifix - Total duration: 29s49ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 29s49ms - Times executed: 4 ]
-
COPY public.tcia_lote_fluxos (tl_id, flu_id, criacao) TO stdout;
Date: 2026-05-15 10:45:10 Duration: 16s244ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.tcia_lote_fluxos (tl_id, flu_id, criacao) TO stdout;
Date: 2026-05-15 20:08:27 Duration: 11s931ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.tcia_lote_fluxos (tl_id, flu_id, criacao) TO stdout;
Date: 2026-05-15 10:49:14 Duration: 456ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
20 21s188ms 6 3s15ms 4s505ms 3s531ms copy ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 15 10 3 11s674ms 3s891ms 20 3 9s514ms 3s171ms [ User: intelifix - Total duration: 21s188ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 21s188ms - Times executed: 6 ]
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-05-15 10:47:49 Duration: 4s505ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-05-15 10:49:37 Duration: 3s648ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-05-15 10:38:33 Duration: 3s520ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 19 10s949ms 453ms 812ms 576ms select pro_id, pgp_sym_decrypt(nome, ?)::varchar, pgp_sym_decrypt(descricao, ?)::varchar, pgp_sym_decrypt(classe, ?)::varchar, pgp_sym_decrypt(php, ?)::varchar, pgp_sym_decrypt(extras, ?)::varchar from progs order by pro_id;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 15 09 6 3s499ms 583ms 10 3 1s613ms 537ms 11 2 1s343ms 671ms 15 8 4s492ms 561ms [ User: lenon - Total duration: 10s949ms - Times executed: 19 ]
[ Application: [unknown] - Total duration: 10s949ms - Times executed: 19 ]
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-05-15 11:16:10 Duration: 812ms Database: contagem User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-05-15 09:39:14 Duration: 684ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-05-15 15:42:29 Duration: 649ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-15.log
2 17 37s290ms 1s225ms 9s710ms 2s193ms create table temp0000232294 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 15 09 7 19s66ms 2s723ms 15 10 18s223ms 1s822ms [ User: intelifix - Total duration: 37s290ms - Times executed: 17 ]
[ Application: [unknown] - Total duration: 37s290ms - Times executed: 17 ]
-
CREATE TABLE temp0000232294 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 07);
Date: 2026-05-15 09:32:54 Duration: 9s710ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
CREATE TABLE temp0000232294 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 07);
Date: 2026-05-15 15:27:07 Duration: 4s686ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
CREATE TABLE temp0000232294 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 07);
Date: 2026-05-15 09:39:16 Duration: 1s868ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-15.log
3 15 11s13ms 608ms 895ms 734ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 15 09 3 2s67ms 689ms 10 2 1s535ms 767ms 11 2 1s705ms 852ms 15 8 5s705ms 713ms [ User: intelifix - Total duration: 11s13ms - Times executed: 15 ]
[ Application: [unknown] - Total duration: 11s13ms - Times executed: 15 ]
-
select * from rs_menu_grants (80, 18, 1);
Date: 2026-05-15 11:16:10 Duration: 895ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
select * from rs_menu_grants (80, 18, 1);
Date: 2026-05-15 15:26:58 Duration: 873ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
select * from rs_menu_grants (80, 72, 1);
Date: 2026-05-15 15:09:28 Duration: 810ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-15.log
4 11 7s902ms 399ms 2s117ms 718ms create table temp0000226040 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration May 15 09 8 5s517ms 689ms 15 3 2s384ms 794ms [ User: intelifix - Total duration: 7s902ms - Times executed: 11 ]
[ Application: [unknown] - Total duration: 7s902ms - Times executed: 11 ]
-
CREATE TABLE temp0000226040 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 02);
Date: 2026-05-15 09:33:16 Duration: 2s117ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
CREATE TABLE temp0000226040 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 02);
Date: 2026-05-15 15:08:16 Duration: 1s518ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
CREATE TABLE temp0000226040 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 02);
Date: 2026-05-15 09:43:14 Duration: 566ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-15.log
5 7 2s445ms 167ms 933ms 349ms select * from rs_equipamento_consulta (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration May 15 11 2 643ms 321ms 15 5 1s801ms 360ms [ User: intelifix - Total duration: 2s445ms - Times executed: 7 ]
[ Application: [unknown] - Total duration: 2s445ms - Times executed: 7 ]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('168440939010');
Date: 2026-05-15 15:10:45 Duration: 933ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('241690963238');
Date: 2026-05-15 11:16:12 Duration: 460ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('831218931000645');
Date: 2026-05-15 15:10:49 Duration: 284ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-15.log
6 6 10m14s 229ms 9m58s 1m42s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration May 15 09 3 15s421ms 5s140ms 15 3 9m58s 3m19s [ User: intelifix - Total duration: 10m14s - Times executed: 6 ]
[ Application: [unknown] - Total duration: 10m14s - Times executed: 6 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2025-12-01''),DATE(''2026-01-06'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-05-15 15:36:21 Duration: 9m58s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(7,80,''/var/www/html/uploads/LOTE AUTOMATICO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');
Date: 2026-05-15 09:40:27 Duration: 6s155ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,80,''/var/www/html/uploads/LOTE AUTOMATICO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');
Date: 2026-05-15 09:39:12 Duration: 5s790ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-15.log
7 6 1m49s 2s418ms 43s201ms 18s217ms 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 #7
Day Hour Count Duration Avg duration May 15 10 3 56s252ms 18s750ms 20 3 53s50ms 17s683ms [ User: intelifix - Total duration: 1m49s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m49s - Times executed: 6 ]
-
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-15 10:43:38 Duration: 43s201ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
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-15 20:07:04 Duration: 39s293ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
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-15 20:11:52 Duration: 10s985ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
8 6 1m39s 4s754ms 41s172ms 16s522ms 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 #8
Day Hour Count Duration Avg duration May 15 10 3 52s914ms 17s638ms 20 3 46s221ms 15s407ms [ User: intelifix - Total duration: 1m39s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m39s - Times executed: 6 ]
-
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-15 10:47:39 Duration: 41s172ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
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-15 20:10:43 Duration: 33s798ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
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-15 10:49:26 Duration: 6s986ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
9 6 1m34s 1s877ms 38s66ms 15s792ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration May 15 10 3 48s545ms 16s181ms 20 3 46s208ms 15s402ms [ User: intelifix - Total duration: 1m34s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m34s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-15 10:44:21 Duration: 38s66ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-15 20:07:43 Duration: 34s254ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-15 20:12:03 Duration: 10s75ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
10 6 1m18s 2s81ms 28s141ms 13s99ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration May 15 10 3 40s683ms 13s561ms 20 3 37s914ms 12s638ms [ User: intelifix - Total duration: 1m18s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m18s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-15 10:39:22 Duration: 28s141ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-15 20:02:53 Duration: 23s849ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-15 20:11:08 Duration: 11s984ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
11 6 1m11s 1s752ms 25s355ms 11s909ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration May 15 10 3 38s468ms 12s822ms 20 3 32s987ms 10s995ms [ User: intelifix - Total duration: 1m11s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m11s - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-15 10:40:05 Duration: 25s355ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-15 20:03:31 Duration: 22s52ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-15 10:48:18 Duration: 10s668ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
12 6 1m3s 1s643ms 25s66ms 10s504ms 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 #12
Day Hour Count Duration Avg duration May 15 10 3 31s599ms 10s533ms 20 3 31s428ms 10s476ms [ User: intelifix - Total duration: 1m3s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m3s - Times executed: 6 ]
-
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-15 20:04:37 Duration: 25s66ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
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-15 10:41:11 Duration: 24s917ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
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-15 10:48:35 Duration: 5s38ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
13 6 57s396ms 1s147ms 19s253ms 9s566ms 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 #13
Day Hour Count Duration Avg duration May 15 10 3 29s447ms 9s815ms 20 3 27s949ms 9s316ms [ User: intelifix - Total duration: 57s396ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 57s396ms - Times executed: 6 ]
-
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-15 10:40:25 Duration: 19s253ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
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-15 20:03:50 Duration: 18s722ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
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-15 10:48:27 Duration: 8s360ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
14 6 42s11ms 908ms 17s842ms 7s1ms 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 #14
Day Hour Count Duration Avg duration May 15 10 3 22s242ms 7s414ms 20 3 19s768ms 6s589ms [ User: intelifix - Total duration: 42s11ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 42s11ms - Times executed: 6 ]
-
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-15 10:39:40 Duration: 17s842ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
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-15 20:03:09 Duration: 16s64ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
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-15 10:48:08 Duration: 3s229ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
15 6 37s612ms 2s931ms 8s806ms 6s268ms 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 15 10 3 18s502ms 6s167ms 20 3 19s109ms 6s369ms [ User: intelifix - Total duration: 37s612ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 37s612ms - Times executed: 6 ]
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-05-15 20:08:13 Duration: 8s806ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-05-15 10:44:51 Duration: 8s600ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-05-15 20:12:16 Duration: 7s371ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
16 6 35s263ms 877ms 14s863ms 5s877ms 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 15 10 3 18s793ms 6s264ms 20 3 16s470ms 5s490ms [ User: intelifix - Total duration: 35s263ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 35s263ms - Times executed: 6 ]
-
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-15 10:38:50 Duration: 14s863ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
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-15 20:02:26 Duration: 12s889ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
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-15 10:47:53 Duration: 3s52ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
17 6 34s726ms 866ms 16s323ms 5s787ms 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 #17
Day Hour Count Duration Avg duration May 15 10 3 16s490ms 5s496ms 20 3 18s236ms 6s78ms [ User: intelifix - Total duration: 34s726ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 34s726ms - Times executed: 6 ]
-
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-15 20:04:12 Duration: 16s323ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
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-15 10:40:46 Duration: 14s750ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
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-15 20:12:48 Duration: 1s9ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
18 6 21s188ms 3s15ms 4s505ms 3s531ms copy ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 15 10 3 11s674ms 3s891ms 20 3 9s514ms 3s171ms [ User: intelifix - Total duration: 21s188ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 21s188ms - Times executed: 6 ]
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-05-15 10:47:49 Duration: 4s505ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-05-15 10:49:37 Duration: 3s648ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-05-15 10:38:33 Duration: 3s520ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
19 6 18s340ms 472ms 6s835ms 3s56ms copy public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration May 15 10 3 9s599ms 3s199ms 20 3 8s741ms 2s913ms [ User: intelifix - Total duration: 18s340ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 18s340ms - Times executed: 6 ]
-
COPY public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) TO stdout;
Date: 2026-05-15 10:40:32 Duration: 6s835ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) TO stdout;
Date: 2026-05-15 20:03:56 Duration: 6s226ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) TO stdout;
Date: 2026-05-15 10:48:29 Duration: 2s244ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
20 6 9s792ms 1s528ms 1s820ms 1s632ms 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 15 10 3 4s879ms 1s626ms 20 3 4s913ms 1s637ms [ User: intelifix - Total duration: 9s792ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 9s792ms - Times executed: 6 ]
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-15 10:47:44 Duration: 1s820ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-15 20:02:07 Duration: 1s781ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY ceps2009.cep_coordenadas (id, uf, cep, latitude, longitude, precisaocoord) TO stdout;
Date: 2026-05-15 20:12:36 Duration: 1s598ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 229ms 9m58s 1m42s 6 10m14s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 15 09 3 15s421ms 5s140ms 15 3 9m58s 3m19s [ User: intelifix - Total duration: 10m14s - Times executed: 6 ]
[ Application: [unknown] - Total duration: 10m14s - Times executed: 6 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2025-12-01''),DATE(''2026-01-06'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-05-15 15:36:21 Duration: 9m58s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(7,80,''/var/www/html/uploads/LOTE AUTOMATICO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');
Date: 2026-05-15 09:40:27 Duration: 6s155ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,80,''/var/www/html/uploads/LOTE AUTOMATICO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');
Date: 2026-05-15 09:39:12 Duration: 5s790ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-15.log
2 4s944ms 1m46s 54s486ms 4 3m37s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 15 10 2 1m51s 55s850ms 20 2 1m46s 53s122ms [ User: intelifix - Total duration: 3m37s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m37s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-15 10:46:57 Duration: 1m46s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-15 20:10:09 Duration: 1m41s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-15 10:49:19 Duration: 5s440ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
3 485ms 1m18s 39s32ms 4 2m36s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 15 10 2 1m16s 38s454ms 20 2 1m19s 39s610ms [ User: intelifix - Total duration: 2m36s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m36s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-15 20:06:23 Duration: 1m18s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-15 10:42:53 Duration: 1m16s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-05-15 10:48:40 Duration: 574ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
4 2s418ms 43s201ms 18s217ms 6 1m49s 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 #4
Day Hour Count Duration Avg duration May 15 10 3 56s252ms 18s750ms 20 3 53s50ms 17s683ms [ User: intelifix - Total duration: 1m49s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m49s - Times executed: 6 ]
-
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-15 10:43:38 Duration: 43s201ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
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-15 20:07:04 Duration: 39s293ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
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-15 20:11:52 Duration: 10s985ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
5 4s754ms 41s172ms 16s522ms 6 1m39s 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 15 10 3 52s914ms 17s638ms 20 3 46s221ms 15s407ms [ User: intelifix - Total duration: 1m39s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m39s - Times executed: 6 ]
-
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-15 10:47:39 Duration: 41s172ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
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-15 20:10:43 Duration: 33s798ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
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-15 10:49:26 Duration: 6s986ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
6 15s738ms 16s701ms 16s219ms 2 32s439ms 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 15 10 1 16s701ms 16s701ms 20 1 15s738ms 15s738ms [ User: intelifix - Total duration: 32s439ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 32s439ms - Times executed: 2 ]
-
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-15 10:44:38 Duration: 16s701ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
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-15 20:07:59 Duration: 15s738ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
7 1s877ms 38s66ms 15s792ms 6 1m34s copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration May 15 10 3 48s545ms 16s181ms 20 3 46s208ms 15s402ms [ User: intelifix - Total duration: 1m34s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m34s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-15 10:44:21 Duration: 38s66ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-15 20:07:43 Duration: 34s254ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-05-15 20:12:03 Duration: 10s75ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
8 9s855ms 29s388ms 15s739ms 4 1m2s create table temp0000277706 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration May 15 09 3 33s569ms 11s189ms 15 1 29s388ms 29s388ms [ User: intelifix - Total duration: 1m2s - Times executed: 4 ]
[ Application: [unknown] - Total duration: 1m2s - Times executed: 4 ]
-
CREATE TABLE temp0000277706 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-15 15:09:57 Duration: 29s388ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
CREATE TABLE temp0000277706 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-15 09:29:22 Duration: 12s194ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
CREATE TABLE temp0000277706 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-15 09:35:30 Duration: 11s519ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-15.log
9 4s243ms 27s33ms 15s243ms 4 1m 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 15 10 2 29s85ms 14s542ms 20 2 31s888ms 15s944ms [ User: intelifix - Total duration: 1m - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m - Times executed: 4 ]
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-05-15 20:05:05 Duration: 27s33ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-05-15 10:41:36 Duration: 24s841ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.giga_testes (id, serial, arquivo, dados, criacao, status, flu_id) TO stdout;
Date: 2026-05-15 20:11:40 Duration: 4s854ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
10 2s81ms 28s141ms 13s99ms 6 1m18s copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration May 15 10 3 40s683ms 13s561ms 20 3 37s914ms 12s638ms [ User: intelifix - Total duration: 1m18s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m18s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-15 10:39:22 Duration: 28s141ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-15 20:02:53 Duration: 23s849ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-15 20:11:08 Duration: 11s984ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
11 1s752ms 25s355ms 11s909ms 6 1m11s copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration May 15 10 3 38s468ms 12s822ms 20 3 32s987ms 10s995ms [ User: intelifix - Total duration: 1m11s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m11s - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-15 10:40:05 Duration: 25s355ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-15 20:03:31 Duration: 22s52ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-05-15 10:48:18 Duration: 10s668ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
12 1s643ms 25s66ms 10s504ms 6 1m3s 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 #12
Day Hour Count Duration Avg duration May 15 10 3 31s599ms 10s533ms 20 3 31s428ms 10s476ms [ User: intelifix - Total duration: 1m3s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m3s - Times executed: 6 ]
-
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-15 20:04:37 Duration: 25s66ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
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-15 10:41:11 Duration: 24s917ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
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-15 10:48:35 Duration: 5s38ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
13 1s147ms 19s253ms 9s566ms 6 57s396ms 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 #13
Day Hour Count Duration Avg duration May 15 10 3 29s447ms 9s815ms 20 3 27s949ms 9s316ms [ User: intelifix - Total duration: 57s396ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 57s396ms - Times executed: 6 ]
-
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-15 10:40:25 Duration: 19s253ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
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-15 20:03:50 Duration: 18s722ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
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-15 10:48:27 Duration: 8s360ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
14 416ms 16s244ms 7s262ms 4 29s49ms copy public.tcia_lote_fluxos (tl_id, flu_id, criacao) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration May 15 10 2 16s701ms 8s350ms 20 2 12s348ms 6s174ms [ User: intelifix - Total duration: 29s49ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 29s49ms - Times executed: 4 ]
-
COPY public.tcia_lote_fluxos (tl_id, flu_id, criacao) TO stdout;
Date: 2026-05-15 10:45:10 Duration: 16s244ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.tcia_lote_fluxos (tl_id, flu_id, criacao) TO stdout;
Date: 2026-05-15 20:08:27 Duration: 11s931ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.tcia_lote_fluxos (tl_id, flu_id, criacao) TO stdout;
Date: 2026-05-15 10:49:14 Duration: 456ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
15 908ms 17s842ms 7s1ms 6 42s11ms 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 #15
Day Hour Count Duration Avg duration May 15 10 3 22s242ms 7s414ms 20 3 19s768ms 6s589ms [ User: intelifix - Total duration: 42s11ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 42s11ms - Times executed: 6 ]
-
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-15 10:39:40 Duration: 17s842ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
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-15 20:03:09 Duration: 16s64ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
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-15 10:48:08 Duration: 3s229ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
16 2s931ms 8s806ms 6s268ms 6 37s612ms copy public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 15 10 3 18s502ms 6s167ms 20 3 19s109ms 6s369ms [ User: intelifix - Total duration: 37s612ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 37s612ms - Times executed: 6 ]
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-05-15 20:08:13 Duration: 8s806ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-05-15 10:44:51 Duration: 8s600ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.prod_estoques (ofi_id, pro_id, est_data, pe_inicial, pe_entradas, pe_ajustes, pe_saidas, criacao) TO stdout;
Date: 2026-05-15 20:12:16 Duration: 7s371ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
17 877ms 14s863ms 5s877ms 6 35s263ms 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 #17
Day Hour Count Duration Avg duration May 15 10 3 18s793ms 6s264ms 20 3 16s470ms 5s490ms [ User: intelifix - Total duration: 35s263ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 35s263ms - Times executed: 6 ]
-
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-15 10:38:50 Duration: 14s863ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
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-15 20:02:26 Duration: 12s889ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
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-15 10:47:53 Duration: 3s52ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
18 866ms 16s323ms 5s787ms 6 34s726ms 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 #18
Day Hour Count Duration Avg duration May 15 10 3 16s490ms 5s496ms 20 3 18s236ms 6s78ms [ User: intelifix - Total duration: 34s726ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 34s726ms - Times executed: 6 ]
-
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-15 20:04:12 Duration: 16s323ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
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-15 10:40:46 Duration: 14s750ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
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-15 20:12:48 Duration: 1s9ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
19 3s15ms 4s505ms 3s531ms 6 21s188ms copy ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration May 15 10 3 11s674ms 3s891ms 20 3 9s514ms 3s171ms [ User: intelifix - Total duration: 21s188ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 21s188ms - Times executed: 6 ]
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-05-15 10:47:49 Duration: 4s505ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-05-15 10:49:37 Duration: 3s648ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY ceps2009.cep_logradouros (id, uf, idloc, idbaiini, idbaifinal, tplog, endereco, complemento, cep) TO stdout;
Date: 2026-05-15 10:38:33 Duration: 3s520ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
20 472ms 6s835ms 3s56ms 6 18s340ms copy public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 15 10 3 9s599ms 3s199ms 20 3 8s741ms 2s913ms [ User: intelifix - Total duration: 18s340ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 18s340ms - Times executed: 6 ]
-
COPY public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) TO stdout;
Date: 2026-05-15 10:40:32 Duration: 6s835ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) TO stdout;
Date: 2026-05-15 20:03:56 Duration: 6s226ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
-
COPY public.equipamentos_referencia (eq_id, mod_id, eq_detalhe, validado, power_dados, usu_id, usu_data) TO stdout;
Date: 2026-05-15 10:48:29 Duration: 2s244ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-15.log
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
- 838 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 18 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
- 4 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 18 Max number of times the same event was reported
- 22 Total events found
Rank Times reported Error 1 18 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #1
Day Hour Count May 15 09 18 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-05-15 09:56:46 Database: contagem Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-15.log
Date: 2026-05-15 09:56:46 Database: contagem Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-15.log
Date: 2026-05-15 09:56:46 Database: contagem Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-15.log
2 4 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #2
Day Hour Count May 15 09 3 10 1 - LOG: database system was shut down at 2026-05-15 09:56:46 -03
- LOG: database system was shut down at 2026-05-15 09:57:42 -03
- LOG: database system was shut down at 2026-05-15 09:58:17 -03
Date: 2026-05-15 09:57:07 Log file: /usr/local/pgsql/data/log/serverlog-15.log
Date: 2026-05-15 09:57:43 Log file: /usr/local/pgsql/data/log/serverlog-15.log
Date: 2026-05-15 09:58:25 Log file: /usr/local/pgsql/data/log/serverlog-15.log