Boa tarde,
houve um erro no Postgres de uma das maquinas aqui da empresa.
Depois de um tempo que a aplicação está rodando dá o erro de falta de
memória. O banco não chega a cair.
O log:
22:33:55.471 BRDTERROR: out of memory
Operator class cache: 8192 total in 1 blocks; 3848 free (0 chunks); 4344
used
PL/PgSQL function context: 8192 total in 1 blocks; 2472 free (9 chunks);
5720 used
Rendezvous variable hash: 8192 total in 1 blocks; 3848 free (0 chunks);
4344 used
PLpgSQL function cache: 24328 total in 2 blocks; 5904 free (0 chunks);
18424 used
Record information cache: 8192 total in 1 blocks; 1800 free (0 chunks);
6392 used
TopTransactionContext: 8192 total in 1 blocks; 7312 free (0 chunks); 880
used
ExecutorState: 8192 total in 1 blocks; 6832 free (0 chunks); 1360 used
ExprContext: 8192 total in 1 blocks; 8176 free (0 chunks); 16 used
SPI Exec: 8192 total in 1 blocks; 7992 free (0 chunks); 200 used
ExecutorState: 73856 total in 5 blocks; 26064 free (5 chunks); 47792
used
TIDBitmap: 24576 total in 2 blocks; 2800 free (8 chunks); 21776 used
ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
ExprContext: 8192 total in 1 blocks; 8160 free (0 chunks); 32 used
AggContext: 8192 total in 1 blocks; 8104 free (0 chunks); 88 used
TupleHashTable: 8192 total in 1 blocks; 5704 free (0 chunks); 2488
used
ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
SPI Proc: 8192 total in 1 blocks; 6632 free (2 chunks); 1560 used
MessageContext: 8192 total in 1 blocks; 7072 free (0 chunks); 1120 used
CFuncHash: 8192 total in 1 blocks; 4936 free (0 chunks); 3256 used
MbProcContext: 1024 total in 1 blocks; 928 free (7 chunks); 96 used
smgr relation table: 8192 total in 1 blocks; 2808 free (0 chunks); 5384
used
TransactionAbortContext: 32768 total in 1 blocks; 32752 free (0 chunks);
16 used
Portal hash: 8192 total in 1 blocks; 3912 free (0 chunks); 4280 used
PortalMemory: 8192 total in 1 blocks; 8040 free (0 chunks); 152 used
PortalHeapMemory: 15360 total in 4 blocks; 3400 free (0 chunks); 11960
used
ExecutorState: 8192 total in 1 blocks; 712 free (6 chunks); 7480 used
ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
Relcache by OID: 8192 total in 1 blocks; 3376 free (0 chunks); 4816 used
CacheMemoryContext: 667472 total in 20 blocks; 202696 free (0 chunks);
464776 used
CachedPlan: 15360 total in 4 blocks; 2856 free (0 chunks); 12504 used
CachedPlanSource: 3072 total in 2 blocks; 624 free (0 chunks); 2448 used
SPI Plan: 1024 total in 1 blocks; 904 free (0 chunks); 120 used
idx_UNIQ_mo_queue: 1024 total in 1 blocks; 72 free (0 chunks); 952 used
mo_queue_idx_lote: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
idx_mo_queue=processed: 1024 total in 1 blocks; 304 free (0 chunks); 720
used
idx_mo_queue=importer_host: 1024 total in 1 blocks; 344 free (0 chunks);
680 used
mo_queue_pkey: 1024 total in 1 blocks; 344 free (0 chunks); 680 used
pg_index_indrelid_index: 1024 total in 1 blocks; 304 free (0 chunks);
720 used
pg_attrdef_adrelid_adnum_index: 1024 total in 1 blocks; 240 free (0
chunks); 784 used
CachedPlan: 1024 total in 1 blocks; 528 free (0 chunks); 496 used
CachedPlanSource: 3072 total in 2 blocks; 2000 free (3 chunks); 1072
used
SPI Plan: 1024 total in 1 blocks; 928 free (0 chunks); 96 used
unnamed prepared statement: 24576 total in 2 blocks; 3576 free (6
chunks); 21000 used
pg_ts_dict_oid_index: 1024 total in 1 blocks; 344 free (0 chunks); 680
used
pg_aggregate_fnoid_index: 1024 total in 1 blocks; 344 free (0 chunks);
680 used
pg_language_name_index: 1024 total in 1 blocks; 344 free (0 chunks); 680
used
pg_statistic_relid_att_index: 1024 total in 1 blocks; 240 free (0
chunks); 784 used
pg_ts_dict_dictname_index: 1024 total in 1 blocks; 280 free (0 chunks);
744 used
pg_namespace_nspname_index: 1024 total in 1 blocks; 304 free (0 chunks);
720 used
pg_opfamily_oid_index: 1024 total in 1 blocks; 344 free (0 chunks); 680
used
pg_opclass_oid_index: 1024 total in 1 blocks; 304 free (0 chunks); 720
used
pg_ts_parser_prsname_index: 1024 total in 1 blocks; 280 free (0 chunks);
744 used
pg_amop_fam_strat_index: 1024 total in 1 blocks; 88 free (0 chunks); 936
used
LOCALLOCK hash: 8192 total in 1 blocks; 3912 free (0 chunks); 4280 used
Timezones: 48616 total in 2 blocks; 5968 free (0 chunks); 42648 used
ErrorContext: 8192 total in 1 blocks; 8176 free (4 chunks); 16 used
Obrigado,
Guilherme Vianna
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
