pgBadger-
Global information
- Generated on Mon Jun 9 23:50:05 2025
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-Wed.log
- Parsed 152,826 log entries in 4s
- Log start from 2025-06-09 00:02:01 to 2025-06-09 23:49:56
-
Overview
Global Stats
- 0 Number of unique normalized queries
- 0 Number of queries
- 0ms Total query duration
- - First query
- - Last query
- 0 queries/s at Query peak
- 0ms Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 0ms Execute total duration
- 81 Number of events
- 24 Number of unique normalized events
- 35 Max number of times the same event was reported
- 0 Number of cancellation
- 0 Total number of automatic vacuums
- 0 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 0 Total number of sessions
- 0 sessions at Session peak
- 0ms Total duration of sessions
- 0ms Average duration of sessions
- 0 Average queries per session
- 0ms Average queries duration per session
- n/a Average idle time per session
- 0 Total number of connections
- 0 Total number of databases
SQL Traffic
Key values
- 0 queries/s Query Peak
- Date
SELECT Traffic
Key values
- 0 queries/s Query Peak
- Date
INSERT/UPDATE/DELETE Traffic
Key values
- 0 queries/s Query Peak
- Date
Queries duration
Key values
- 0ms 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) Jun 09 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 0 0ms 0ms 0ms 0ms 0ms 0ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 0 0ms 0ms 0ms 0ms 0ms 0ms 19 0 0ms 0ms 0ms 0ms 0ms 0ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 09 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 09 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 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 13 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 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jun 09 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Jun 09 00 0 0.00/s 01 0 0.00/s 02 0 0.00/s 03 0 0.00/s 04 0 0.00/s 05 0 0.00/s 06 0 0.00/s 07 0 0.00/s 08 0 0.00/s 09 0 0.00/s 10 0 0.00/s 11 0 0.00/s 12 0 0.00/s 13 0 0.00/s 14 0 0.00/s 15 0 0.00/s 16 0 0.00/s 17 0 0.00/s 18 0 0.00/s 19 0 0.00/s 20 0 0.00/s 21 0 0.00/s 22 0 0.00/s 23 0 0.00/s Day Hour Count Average Duration Average idle time Jun 09 00 0 0ms 0ms 01 0 0ms 0ms 02 0 0ms 0ms 03 0 0ms 0ms 04 0 0ms 0ms 05 0 0ms 0ms 06 0 0ms 0ms 07 0 0ms 0ms 08 0 0ms 0ms 09 0 0ms 0ms 10 0 0ms 0ms 11 0 0ms 0ms 12 0 0ms 0ms 13 0 0ms 0ms 14 0 0ms 0ms 15 0 0ms 0ms 16 0 0ms 0ms 17 0 0ms 0ms 18 0 0ms 0ms 19 0 0ms 0ms 20 0 0ms 0ms 21 0 0ms 0ms 22 0 0ms 0ms 23 0 0ms 0ms -
Connections
Established Connections
Key values
- 0 connections Connection Peak
- Date
Connections per database
Key values
- unknown Main Database
- 0 connections Total
Connections per user
Key values
- unknown Main User
- 0 connections Total
-
Sessions
Simultaneous sessions
Key values
- 0 sessions Session Peak
- Date
Histogram of session times
Key values
- duration
Sessions per database
Key values
- unknown Main Database
- 0 sessions Total
Sessions per user
Key values
- unknown Main User
- 0 sessions Total
Sessions per host
Key values
- unknown Main Host
- 0 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 120,576 buffers Checkpoint Peak
- 2025-06-09 10:30:19 Date
- 270.019 seconds Highest write time
- 0.176 seconds Sync time
Checkpoints Wal files
Key values
- 73 files Wal files usage Peak
- 2025-06-09 10:30:19 Date
Checkpoints distance
Key values
- 2,328.54 Mo Distance Peak
- 2025-06-09 10:30:19 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jun 09 00 15,625 269.359s 0.004s 269.372s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 0 0s 0s 0s 04 0 0s 0s 0s 05 4,138 273.95s 0.006s 273.963s 06 116,729 1,078.659s 0.017s 1,078.722s 07 116,894 1,155.839s 0.091s 1,155.996s 08 135,899 2,188.937s 0.186s 2,189.205s 09 71,360 2,146.61s 0.255s 2,146.938s 10 153,006 2,909.342s 0.354s 2,909.792s 11 190,355 2,775.614s 0.407s 2,776.184s 12 91,274 2,162.773s 0.226s 2,163.076s 13 132,293 2,120.375s 0.252s 2,120.722s 14 154,277 3,065.231s 0.465s 3,065.817s 15 149,450 3,176.307s 0.385s 3,176.803s 16 152,555 2,711.773s 0.505s 2,712.414s 17 144,493 1,999.836s 0.23s 2,000.219s 18 112,732 889.796s 0.06s 889.917s 19 110,264 542.799s 0.02s 542.865s 20 111,480 630.571s 0.031s 630.654s 21 113,753 935.08s 0.037s 935.172s 22 113,081 749.491s 0.047s 749.585s 23 383 38.298s 0.018s 38.342s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jun 09 00 0 0 7 39 0.001s 0.002s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 0 0 0s 0s 04 0 0 0 0 0s 0s 05 0 0 2 76 0.001s 0.002s 06 0 0 69 275 0.001s 0.004s 07 0 0 69 1,504 0.002s 0.01s 08 0 0 80 3,259 0.004s 0.012s 09 0 0 47 4,456 0.002s 0.01s 10 0 0 101 4,903 0.013s 0.011s 11 0 11 114 5,545 0.006s 0.012s 12 0 0 52 3,754 0.002s 0.012s 13 0 4 74 3,487 0.024s 0.011s 14 0 5 87 5,177 0.058s 0.012s 15 0 6 82 5,332 0.003s 0.012s 16 0 5 90 4,892 0.062s 0.016s 17 0 3 78 3,467 0.008s 0.011s 18 0 0 66 825 0.002s 0.009s 19 0 0 65 289 0.003s 0.004s 20 0 0 67 390 0.002s 0.006s 21 0 0 66 627 0.002s 0.006s 22 0 0 67 762 0.003s 0.007s 23 0 0 0 106 0.008s 0.006s Day Hour Count Avg time (sec) Jun 09 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Jun 09 00 55,691.50 kB 323,804.50 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 0.00 kB 0.00 kB 04 0.00 kB 0.00 kB 05 12,681.50 kB 269,692.50 kB 06 283,307.00 kB 521,046.25 kB 07 112,663.20 kB 500,978.90 kB 08 109,189.58 kB 438,855.17 kB 09 70,661.36 kB 206,577.91 kB 10 150,139.36 kB 563,724.73 kB 11 171,022.42 kB 647,327.25 kB 12 71,394.25 kB 458,890.17 kB 13 116,118.55 kB 434,937.45 kB 14 125,537.50 kB 440,672.58 kB 15 119,947.33 kB 438,791.42 kB 16 96,930.50 kB 383,331.44 kB 17 120,161.91 kB 418,446.82 kB 18 120,424.89 kB 442,637.33 kB 19 267,729.50 kB 495,729.75 kB 20 181,995.00 kB 571,205.67 kB 21 181,877.50 kB 544,641.17 kB 22 156,509.00 kB 516,533.86 kB 23 386.00 kB 324,580.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 Jun 09 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Autovacuum actions (5 minutes period)
NO DATASET
Average Autovacuum Duration
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
Average Autovacuum Duration (5 minutes average)
NO DATASET
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- unknown (0) Main table vacuumed on database
- 0 vacuums Total
Tuples removed per table
Key values
- unknown (0) Main table with removed tuples on database
- 0 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jun 09 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 - 0 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 0 Total read queries
- 0 Total write queries
Queries by database
Key values
- unknown Main database
- 0 Requests
- 0ms (unknown)
- Main time consuming database
Queries by user
Key values
- unknown Main user
- 0 Requests
Queries per user
NO DATASET
User Request type Count Duration NO DATASET
Duration by user
Key values
- 0ms (unknown) Main time consuming user
Duration per user
NO DATASET
User Request type Count Duration NO DATASET
Queries by host
Key values
- unknown Main host
- 0 Requests
- 0ms (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 0 Requests
- 0ms (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-06-09 23:28:57 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Slowest individual queries
Rank Duration Query NO DATASET
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query NO DATASET
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query NO DATASET
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
- 13,543 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 73 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
- 8 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 35 Max number of times the same event was reported
- 81 Total events found
Rank Times reported Error 1 35 FATAL: terminando a conexão devido a um comando do administrador
Times Reported Most Frequent Error / Event #1
Day Hour Count Jun 09 16 35 2 17 FATAL: terminando a conexão devido a um comando do administrador2025-06-09 16:56:31 -03 ...: ... user=intelifix,db=rio,app=psql - unix(...):8963,client=... CONTEXTO: comando SQL "..." função PL/pgSQL rs_nf_associa_equipamento(...) linha 130 em comando SQL função PL/pgSQL rs_lote_manutencao_itens(...) linha 925 em atribuição função PL/pgSQL rs_triagem_recepcao(...) linha 58 em atribuição função PL/pgSQL rs_giga_triagem(...) linha 128 em atribuição2025-06-09 16:56:31 -03 ...: ... user=intelifix,db=rio,app=psql - unix(...):8963,client=... COMANDO: CALL RS_GIGA_TRIAGEM(...)
Times Reported Most Frequent Error / Event #2
Day Hour Count Jun 09 16 17 3 3 FATAL: o sistema de banco de dados está desligando
Times Reported Most Frequent Error / Event #3
Day Hour Count Jun 09 16 3 4 3 FATAL: banco de dados "..." não existe
Times Reported Most Frequent Error / Event #4
Day Hour Count Jun 09 06 1 16 1 17 1 5 2 LOG: could not send data to client: Pipe quebrado SQL statement "..." PL/pgSQL function rs_nf_associa_equipamento(...) line 130 at comando SQL PL/pgSQL function rs_lote_manutencao_itens(...) line 1011 at atribuição
Times Reported Most Frequent Error / Event #5
Day Hour Count Jun 09 16 2 - LOG: could not send data to client: Pipe quebrado SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 130 at comando SQL PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1011 at atribuição
- LOG: could not send data to client: Pipe quebrado SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 130 at comando SQL PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1011 at atribuição
Context: while updating tuple (47858,42) in relation "nf_entrada_itens"
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(140042,188,'71817185850054808778,216863763051$71516185850015000293,216614846075$2832C5F56633,216358754752$71822685850058002359,216879496572','',062,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""}]','$$$','',00);Date: 2025-06-09 16:56:31 Database: rio Application: app - 127.0.0.1:55916 User: intelifix Remote: [local]
Context: while updating tuple (47818,43) in relation "nf_entrada_itens"
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(139970,319,'EH8TP9T06123,E0B668A57DEC','',0459,00,'[{"item":"0","qrcode":""}]','$','',00);Date: 2025-06-09 16:56:31 Database: rio Application: app - 127.0.0.1:37380 User: intelifix Remote: [local]
6 2 LOG: could not send data to client: Pipe quebrado SQL statement "..." PL/pgSQL function rs_posicao_oficina_estatica(...) line 98 at EXECUTE
Times Reported Most Frequent Error / Event #6
Day Hour Count Jun 09 09 1 12 1 - LOG: could not send data to client: Pipe quebrado SQL statement " CREATE TABLE POSICAO_ESTOQUE31 AS SELECT * FROM RS_ESTOQUE_OFICINA( 6 ); CREATE INDEX POSICAO_ESTOQUE310 ON POSICAO_ESTOQUE31(CLI_ID,MOD_ID,STATUS_ID) TABLESPACE INDEXES; CREATE INDEX POSICAO_ESTOQUE311 ON POSICAO_ESTOQUE31(SERIE) TABLESPACE INDEXES; CREATE INDEX POSICAO_ESTOQUE312 ON POSICAO_ESTOQUE31(STATUS_ID,IS_ID) TABLESPACE INDEXES; CREATE INDEX POSICAO_ESTOQUE313 ON POSICAO_ESTOQUE31(MOD_ID) TABLESPACE INDEXES; CREATE INDEX POSICAO_ESTOQUE314 ON POSICAO_ESTOQUE31(TCN_ID) TABLESPACE INDEXES; CREATE INDEX POSICAO_ESTOQUE315 ON POSICAO_ESTOQUE31(OFI_ID) TABLESPACE INDEXES; COMMENT ON TABLE POSICAO_ESTOQUE31 IS '09/JUN/2025 09:05'; GRANT ALL ON POSICAO_ESTOQUE31 TO USUARIOS; GRANT SELECT ON POSICAO_ESTOQUE31 TO PUBLIC; DROP VIEW IF EXISTS POSICAO_ESTOQUE CASCADE; CREATE VIEW POSICAO_ESTOQUE AS SELECT *,nfgvt AS NF_VIVO FROM POSICAO_ESTOQUE31; ANALYZE POSICAO_ESTOQUE31; COMMENT ON VIEW POSICAO_ESTOQUE IS '09/JUN/2025 09:05'; GRANT ALL ON POSICAO_ESTOQUE TO PUBLIC; DROP TABLE IF EXISTS POSICAO_OFICINA_09 CASCADE; CREATE TABLE POSICAO_OFICINA_09 AS SELECT * FROM POSICAO_ESTOQUE31; CREATE INDEX POSICAO_OFICINA_090 ON POSICAO_OFICINA_09(CLI_ID,MOD_ID,STATUS_ID) TABLESPACE INDEXES; CREATE INDEX POSICAO_OFICINA_091 ON POSICAO_OFICINA_09(SERIE) TABLESPACE INDEXES; CREATE INDEX POSICAO_OFICINA_092 ON POSICAO_OFICINA_09(STATUS_ID,IS_ID) TABLESPACE INDEXES; CREATE INDEX POSICAO_OFICINA_093 ON POSICAO_OFICINA_09(MOD_ID) TABLESPACE INDEXES; CREATE INDEX POSICAO_OFICINA_094 ON POSICAO_OFICINA_09(TCN_ID) TABLESPACE INDEXES; CREATE INDEX POSICAO_OFICINA_095 ON POSICAO_OFICINA_09(OFI_ID) TABLESPACE INDEXES; ANALYZE POSICAO_OFICINA_09; COMMENT ON TABLE POSICAO_OFICINA_09 IS '09/JUN/2025 09:05 ULTIMA TABELA DO DIA'; GRANT SELECT ON POSICAO_OFICINA_09 TO PUBLIC; DROP VIEW IF EXISTS RS_POSICAO_OFICINA; CREATE VIEW RS_POSICAO_OFICINA AS SELECT OFI_NOME AS OFICINA, GRU_NOME AS GRUPO, CLI_NOME AS CIDADE, SERIE, ACESSORIO2 AS SMARTCARD, MODELO, NF_ENTRADA, NFGVT, VALOR, CITY AS SAP_CITY, STATE AS SAP_STATE,SAP,DATA_ENTRADA,STATUS, FLU_STATUS AS STATUS_FLUXO, PAS_NOME AS PASSO, RES_NOME AS RESULTADO, MOT_NOME AS MOTIVO,TCN_NOME AS TECNOLOGIA,GARANTIA_FAB, GARANTIA_NIV AS GARANTIA_OFICINA,IS_ID, 1::INTEGER AS QTD,NF_SAIDA FROM POSICAO_ESTOQUE31; GRANT ALL ON RS_POSICAO_OFICINA TO PUBLIC; " PL/pgSQL function rs_posicao_oficina_estatica(integer) line 98 at EXECUTE
Context: PL/pgSQL function rs_estoque_oficina(integer) line 411 at RAISE
Statement: SELECT * FROM RS_POSICAO_OFICINA_ESTATICA(0)Date: 2025-06-09 09:17:10 Database: rio Application: psql - unix(1861579@a2tech):8963 User: intelifix Remote: [local]
7 2 LOG: could not send data to client: Pipe quebrado SQL statement "..." PL/pgSQL function rs_nf_associa_equipamento(...) line 133 at comando SQL PL/pgSQL function rs_lote_manutencao_itens(...) line 1011 at atribuição
Times Reported Most Frequent Error / Event #7
Day Hour Count Jun 09 16 2 - LOG: could not send data to client: Pipe quebrado SQL statement "UPDATE NF_ENTRADA_MODELOS SET QTD_RECEBIDA = QTD_RECEBIDA + 1 WHERE NEM_ID = nNEM" PL/pgSQL function rs_nf_associa_equipamento(integer) line 133 at comando SQL PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1011 at atribuição
- LOG: could not send data to client: Pipe quebrado SQL statement "UPDATE NF_ENTRADA_MODELOS SET QTD_RECEBIDA = QTD_RECEBIDA + 1 WHERE NEM_ID = nNEM" PL/pgSQL function rs_nf_associa_equipamento(integer) line 133 at comando SQL PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1011 at atribuição
Context: while updating tuple (18056,118) in relation "nf_entrada_modelos"
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(140000,188,'11724385850044204947,942CB3F0D76E','',039,00,'[{"item":"0","qrcode":""}]','','',00);Date: 2025-06-09 16:56:31 Database: rio Application: app - 127.0.0.1:39268 User: intelifix Remote: [local]
Context: while updating tuple (18056,88) in relation "nf_entrada_modelos"
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(140020,188,'71817185850054808778,216863763051$71516185850015000293,216614846075$2832C5F56633,216358754752$71822685850058002359,216879496572','',062,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""}]','$$$','',00);Date: 2025-06-09 16:56:31 Database: rio Application: app - 127.0.0.1:45400 User: intelifix Remote: [local]
8 1 FATAL: terminando a conexão devido a um comando do administrador2025-06-09 16:56:31 -03 ...: ... user=intelifix,db=rio,app=app - 127.0.0.1:45400,client=... CONTEXTO: enquanto atualizava tupla (...) na relação "..." comando SQL "..." função PL/pgSQL rs_nf_associa_equipamento(...) linha 133 em comando SQL função PL/pgSQL rs_lote_manutencao_itens(...) linha 1011 em atribuição2025-06-09 16:56:31 -03 ...: ... user=intelifix,db=rio,app=app - 127.0.0.1:45400,client=... COMANDO: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(...)
Times Reported Most Frequent Error / Event #8
Day Hour Count Jun 09 16 1 9 1 FATAL: terminando a conexão devido a um comando do administrador2025-06-09 16:56:31 -03 ...: ... user=intelifix,db=rio,app=app - 127.0.0.1:37380,client=... CONTEXTO: enquanto atualizava tupla (...) na relação "..." comando SQL "..." função PL/pgSQL rs_nf_associa_equipamento(...) linha 130 em comando SQL função PL/pgSQL rs_lote_manutencao_itens(...) linha 1011 em atribuição2025-06-09 16:56:31 -03 ...: ... user=intelifix,db=rio,app=app - 127.0.0.1:37380,client=... COMANDO: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(...)
Times Reported Most Frequent Error / Event #9
Day Hour Count Jun 09 16 1 10 1 FATAL: banco de dados "..." não existe 2025-06-09 00:02:53 -03 ...: ... user=etiquetas,db=brasilia,app=app - 177.99.204.34:58654,client=... ERRO: comando preparado "..." não existe 2025-06-09 00:02:53 -03 ...: ... user=etiquetas,db=brasilia,app=app - 177.99.204.34:58654,client=... COMANDO: DEALLOCATE "..." 2025-06-09 00:03:58 -03 ...: ... user=etiquetas,db=brasilia,app=app - 177.99.204.34:58656,client=... ERRO: comando preparado "..." não existe 2025-06-09 00:03:58 -03 ...: ... user=etiquetas,db=brasilia,app=app - 177.99.204.34:58656,client=... COMANDO: DEALLOCATE "..."
Times Reported Most Frequent Error / Event #10
Day Hour Count Jun 09 00 1 11 1 FATAL: terminando a conexão devido a um comando do administrador2025-06-09 16:56:31 -03 ...: ... user=intelifix,db=rio,app=app - 127.0.0.1:44944,client=... CONTEXTO: comando SQL "..." função PL/pgSQL rs_nf_associa_equipamento(...) linha 133 em comando SQL função PL/pgSQL rs_lote_manutencao_itens(...) linha 1011 em atribuição2025-06-09 16:56:31 -03 ...: ... user=intelifix,db=rio,app=app - 127.0.0.1:44944,client=... COMANDO: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(...)
Times Reported Most Frequent Error / Event #11
Day Hour Count Jun 09 16 1 12 1 LOG: could not send data to client: Pipe quebrado AND LOT_NOTAFISCAL = REC.NF_NUMERO AND OFI_ID = REC.OFI_ID ORDER BY LOT_ID DESC LIMIT 1"..."rs_fast_excel"
Times Reported Most Frequent Error / Event #12
Day Hour Count Jun 09 16 1 - LOG: could not send data to client: Pipe quebrado AND LOT_NOTAFISCAL = REC.NF_NUMERO AND OFI_ID = REC.OFI_ID ORDER BY LOT_ID DESC LIMIT 1" PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 85 at comando SQL PL/Python function "rs_fast_excel"
Context: SQL statement "SELECT LOT_ID FROM LOTES WHERE CLI_ID = REC.CLI_ID AND MOD_ID = ANY( aModelos )
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 014026, 0406 )' , '/var/www/html/tmp/nf_carga_lotes_0406.xlsx' )Date: 2025-06-09 16:56:31 Database: rio Application: app - 127.0.0.1:37298 User: intelifix Remote: [local]
13 1 FATAL: terminando a conexão devido a um comando do administrador2025-06-09 16:56:31 -03 ...: ... user=intelifix,db=rio,app=app - 127.0.0.1:37298,client=... CONTEXTO: comando SQL "..." função PL/pgSQL rs_nf_carga_lotes(...) linha 85 em comando SQL função PL/Python "..."2025-06-09 16:56:31 -03 ...: ... user=intelifix,db=rio,app=app - 127.0.0.1:37298,client=... COMANDO: SELECT * FROM RS_FAST_EXCEL(...)' , '/var/www/html/tmp/nf_carga_lotes_0406.xlsx' )
Times Reported Most Frequent Error / Event #13
Day Hour Count Jun 09 16 1 14 1 FATAL: conexão com cliente foi perdida2025-06-09 09:17:10 -03 ...: ... user=intelifix,db=rio,app=psql - unix(...):8963,client=... CONTEXTO: função PL/pgSQL rs_estoque_oficina(...) linha 411 em RAISE comando SQL "..." função PL/pgSQL rs_posicao_oficina_estatica(...) linha 98 em EXECUTE2025-06-09 09:17:10 -03 ...: ... user=intelifix,db=rio,app=psql - unix(...):8963,client=... COMANDO: SELECT * FROM RS_POSICAO_OFICINA_ESTATICA(...)
Times Reported Most Frequent Error / Event #14
Day Hour Count Jun 09 09 1 15 1 FATAL: banco de dados "..." não existe 2025-06-09 10:41:25 -03 ...: ... user=etiquetas,db=brasilia,app=app - 177.99.204.34:62353,client=... ERRO: comando preparado "..." não existe 2025-06-09 10:41:25 -03 ...: ... user=etiquetas,db=brasilia,app=app - 177.99.204.34:62353,client=... COMANDO: DEALLOCATE "..."
Times Reported Most Frequent Error / Event #15
Day Hour Count Jun 09 10 1 16 1 FATAL: conexão com cliente foi perdida2025-06-09 12:25:02 -03 ...: ... user=intelifix,db=brasilia,app=psql - unix(...):8963,client=... CONTEXTO: função PL/pgSQL rs_estoque_oficina(...) linha 411 em RAISE comando SQL "..." função PL/pgSQL rs_posicao_oficina_estatica(...) linha 98 em EXECUTE2025-06-09 12:25:02 -03 ...: ... user=intelifix,db=brasilia,app=psql - unix(...):8963,client=... COMANDO: SELECT * FROM RS_POSICAO_OFICINA_ESTATICA(...)
Times Reported Most Frequent Error / Event #16
Day Hour Count Jun 09 12 1 17 1 FATAL: terminando a conexão devido a um comando do administrador2025-06-09 16:56:31 -03 ...: ... user=intelifix,db=rio,app=psql - unix(...):8963,client=... CONTEXTO: enquanto atualizava tupla (...) na relação "..." comando SQL "..." função PL/pgSQL rs_nf_associa_equipamento(...) linha 130 em comando SQL função PL/pgSQL rs_lote_manutencao_itens(...) linha 925 em atribuição função PL/pgSQL rs_triagem_recepcao(...) linha 58 em atribuição função PL/pgSQL rs_giga_triagem(...) linha 128 em atribuição2025-06-09 16:56:31 -03 ...: ... user=intelifix,db=rio,app=psql - unix(...):8963,client=... COMANDO: CALL RS_GIGA_TRIAGEM(...)
Times Reported Most Frequent Error / Event #17
Day Hour Count Jun 09 16 1 18 1 LOG: could not send data to client: Pipe quebrado PL/pgSQL function rs_nf_associa_equipamento(...) line 133 at comando SQL PL/pgSQL function rs_lote_manutencao_itens(...) line 1011 at atribuição
Times Reported Most Frequent Error / Event #18
Day Hour Count Jun 09 16 1 - LOG: could not send data to client: Pipe quebrado PL/pgSQL function rs_nf_associa_equipamento(integer) line 133 at comando SQL PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1011 at atribuição
Context: SQL statement "UPDATE NF_ENTRADA_MODELOS SET QTD_RECEBIDA = QTD_RECEBIDA + 1 WHERE NEM_ID = nNEM"
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(140043,188,'71822685850058002359,216879496572$2832C5F56633,216358754752$71516185850015000293,216614846075$71817185850054808778,216863763051','',062,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""}]','$$$','',00);Date: 2025-06-09 16:56:31 Database: rio Application: app - 127.0.0.1:58324 User: intelifix Remote: [local]
19 1 FATAL: terminando a conexão devido a um comando do administrador2025-06-09 16:56:31 -03 ...: ... user=intelifix,db=rio,app=app - 127.0.0.1:55916,client=... CONTEXTO: enquanto atualizava tupla (...) na relação "..." comando SQL "..." função PL/pgSQL rs_nf_associa_equipamento(...) linha 130 em comando SQL função PL/pgSQL rs_lote_manutencao_itens(...) linha 1011 em atribuição2025-06-09 16:56:31 -03 ...: ... user=intelifix,db=rio,app=app - 127.0.0.1:55916,client=... COMANDO: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(...)
Times Reported Most Frequent Error / Event #19
Day Hour Count Jun 09 16 1 20 1 FATAL: o sistema de banco de dados está iniciando
Times Reported Most Frequent Error / Event #20
Day Hour Count Jun 09 17 1 21 1 FATAL: terminando a conexão devido a um comando do administrador2025-06-09 16:56:31 -03 ...: ... user=intelifix,db=rio,app=app - 127.0.0.1:58324,client=... CONTEXTO: comando SQL "..." função PL/pgSQL rs_nf_associa_equipamento(...) linha 133 em comando SQL função PL/pgSQL rs_lote_manutencao_itens(...) linha 1011 em atribuição2025-06-09 16:56:31 -03 ...: ... user=intelifix,db=rio,app=app - 127.0.0.1:58324,client=... COMANDO: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(...)
Times Reported Most Frequent Error / Event #21
Day Hour Count Jun 09 16 1 22 1 FATAL: terminando a conexão devido a um comando do administrador2025-06-09 16:56:31 -03 ...: ... user=intelifix,db=rio,app=psql - unix(...):8963,client=... CONTEXTO: comando SQL "..." função PL/pgSQL rs_nf_associa_equipamento(...) linha 133 em comando SQL função PL/pgSQL rs_lote_manutencao_itens(...) linha 925 em atribuição função PL/pgSQL rs_triagem_recepcao(...) linha 58 em atribuição função PL/pgSQL rs_giga_triagem(...) linha 128 em atribuição2025-06-09 16:56:31 -03 ...: ... user=intelifix,db=rio,app=psql - unix(...):8963,client=... COMANDO: CALL RS_GIGA_TRIAGEM(...)
Times Reported Most Frequent Error / Event #22
Day Hour Count Jun 09 16 1 23 1 FATAL: terminando a conexão devido a um comando do administrador2025-06-09 16:56:31 -03 ...: ... user=intelifix,db=rio,app=app - 127.0.0.1:39268,client=... CONTEXTO: enquanto atualizava tupla (...) na relação "..." comando SQL "..." função PL/pgSQL rs_nf_associa_equipamento(...) linha 133 em comando SQL função PL/pgSQL rs_lote_manutencao_itens(...) linha 1011 em atribuição2025-06-09 16:56:31 -03 ...: ... user=intelifix,db=rio,app=app - 127.0.0.1:39268,client=... COMANDO: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(...)
Times Reported Most Frequent Error / Event #23
Day Hour Count Jun 09 16 1 24 1 FATAL: terminando a conexão devido a um comando do administrador2025-06-09 16:56:31 -03 ...: ... user=intelifix,db=brasilia,app=app - 127.0.0.1:32864,client=... CONTEXTO: atribuição PL/pgSQL "..." função PL/pgSQL rs_equip_id(...) linha 31 em atribuição função PL/pgSQL rs_lote_consiste_serial(...) linha 51 em atribuição2025-06-09 16:56:31 -03 ...: ... user=intelifix,db=brasilia,app=app - 127.0.0.1:32864,client=... COMANDO: SELECT * FROM RS_LOTE_CONSISTE_SERIAL(...)
Times Reported Most Frequent Error / Event #24
Day Hour Count Jun 09 16 1