memoire epuisée et TopMemoryContext

isc84 · 18/09/2014 12:28:26

Bonjour,

Je rencontre un problème sur une base postgres 9.3.5:
mes logs affichent des messages "mémoire épuisée" lors des requêtes des utilisateurs et j'ai dans les logs un grand nombre de lignes commençant par:

TopMemoryContext: 378624 total in 35 blocks; 30368 free (164 chunks); 348256 used
TopTransactionContext: 8192 total in 1 blocks; 7392 free (0 chunks); 800 used
Remote Con hash: 8192 total in 1 blocks; 1680 free (0 chunks); 6512 used
CFuncHash: 8192 total in 1 blocks; 1680 free (0 chunks); 6512 used
Record information cache: 24576 total in 2 blocks; 15984 free (5 chunks); 8592 used
RI compare cache: 24576 total in 2 blocks; 15984 free (5 chunks); 8592 used
RI query cache: 8192 total in 1 blocks; 2704 free (0 chunks); 5488 used
RI constraint cache: 40688 total in 2 blocks; 3744 free (0 chunks); 36944 used
Btree proof lookup cache: 8192 total in 1 blocks; 1680 free (0 chunks); 6512 used
Type information cache: 24240 total in 2 blocks; 3744 free (0 chunks); 20496 used
Operator lookup cache: 57344 total in 3 blocks; 36416 free (12 chunks); 20928 used
TableSpace cache: 8192 total in 1 blocks; 3216 free (0 chunks); 4976 used
MessageContext: 8192 total in 1 blocks; 6976 free (0 chunks); 1216 used
Operator class cache: 8192 total in 1 blocks; 1680 free (0 chunks); 6512 used
smgr relation table: 122880 total in 4 blocks; 52528 free (14 chunks); 70352 used
TransactionAbortContext: 32768 total in 1 blocks; 32736 free (0 chunks); 32 used
Portal hash: 8192 total in 1 blocks; 1680 free (0 chunks); 6512 used
PortalMemory: 8192 total in 1 blocks; 7888 free (0 chunks); 304 used
PortalHeapMemory: 1024 total in 1 blocks; 272 free (0 chunks); 752 used
ExecutorState: 65696 total in 4 blocks; 9120 free (1 chunks); 56576 used
HashTableContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
HashBatchContext: 16384 total in 1 blocks; 4624 free (0 chunks); 11760 used
TupleSort: 3924016 total in 10 blocks; 554208 free (1 chunks); 3369808 used
TupleSort: 32816 total in 2 blocks; 7584 free (0 chunks); 25232 used
printtup: 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: 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
Unique: 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: 0 total in 0 blocks; 0 free (0 chunks); 0 used
Relcache by OID: 57344 total in 3 blocks; 26864 free (6 chunks); 30480 used
CacheMemoryContext: 8786968 total in 32 blocks; 3367864 free (158 chunks); 5419104 used
CachedPlan: 64512 total in 6 blocks; 25872 free (0 chunks); 38640 used
CachedPlanSource: 15360 total in 4 blocks; 4360 free (0 chunks); 11000 used
unnamed prepared statement: 57344 total in 3 blocks; 8104 free (1 chunks); 49240 used
idx_connexion_premio_pha_med: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_prog_connexion_pid: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
(...)

Quelqu'un aurait une idée de la direction vers laquelle chercher la solution svp?

Pour info, ma conf:

shared_buffers = 4GB
work_mem = 8MB # min 64kB
maintenance_work_mem = 256MB # min 1MB
max_stack_depth = 4MB # min 100kB
checkpoint_segments = 32 # in logfile segments, min 1, 16MB each
random_page_cost = 2.0 # same scale as above
effective_cache_size = 12GB

Je precise aussi qu'il tourne sous VMWare.

Merci à vous...

ruizsebastien · 18/09/2014 13:19:24

bonjour,

Et au niveau système : combien de RAM ?

Cordialement,

isc84 · 18/09/2014 13:47:22

16GB

gleu · 18/09/2014 19:36:41

Les paramètres mémoire ne semblent pas mauvais en soit. Combien de connexions sont en cours ? et pourrait-on avoir la trace complète du stack mémoire ? oh, je suppose que votre PostgreSQL est en 64 bits ?

isc84 · 18/09/2014 21:26:01

Bonsoir,
Il s'agit d'un postgres 64bits sur une debian wheezy (sous VMWare).
Il y avait environ 400 connexions au moment du crash.

Voici la trace:

TopMemoryContext: 378624 total in 35 blocks; 30368 free (164 chunks); 348256 used
TopTransactionContext: 8192 total in 1 blocks; 7392 free (0 chunks); 800 used
Remote Con hash: 8192 total in 1 blocks; 1680 free (0 chunks); 6512 used
CFuncHash: 8192 total in 1 blocks; 1680 free (0 chunks); 6512 used
Record information cache: 24576 total in 2 blocks; 15984 free (5 chunks); 8592 used
RI compare cache: 24576 total in 2 blocks; 15984 free (5 chunks); 8592 used
RI query cache: 8192 total in 1 blocks; 2704 free (0 chunks); 5488 used
RI constraint cache: 40688 total in 2 blocks; 3744 free (0 chunks); 36944 used
Btree proof lookup cache: 8192 total in 1 blocks; 1680 free (0 chunks); 6512 used
Type information cache: 24240 total in 2 blocks; 3744 free (0 chunks); 20496 used
Operator lookup cache: 57344 total in 3 blocks; 36416 free (12 chunks); 20928 used
TableSpace cache: 8192 total in 1 blocks; 3216 free (0 chunks); 4976 used
MessageContext: 8192 total in 1 blocks; 6976 free (0 chunks); 1216 used
Operator class cache: 8192 total in 1 blocks; 1680 free (0 chunks); 6512 used
smgr relation table: 122880 total in 4 blocks; 52528 free (14 chunks); 70352 used
TransactionAbortContext: 32768 total in 1 blocks; 32736 free (0 chunks); 32 used
Portal hash: 8192 total in 1 blocks; 1680 free (0 chunks); 6512 used
PortalMemory: 8192 total in 1 blocks; 7888 free (0 chunks); 304 used
PortalHeapMemory: 1024 total in 1 blocks; 272 free (0 chunks); 752 used
ExecutorState: 65696 total in 4 blocks; 9120 free (1 chunks); 56576 used
HashTableContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
HashBatchContext: 16384 total in 1 blocks; 4624 free (0 chunks); 11760 used
TupleSort: 3924016 total in 10 blocks; 554208 free (1 chunks); 3369808 used
TupleSort: 32816 total in 2 blocks; 7584 free (0 chunks); 25232 used
printtup: 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: 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
Unique: 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: 0 total in 0 blocks; 0 free (0 chunks); 0 used
Relcache by OID: 57344 total in 3 blocks; 26864 free (6 chunks); 30480 used
CacheMemoryContext: 8786968 total in 32 blocks; 3367864 free (158 chunks); 5419104 used
CachedPlan: 64512 total in 6 blocks; 25872 free (0 chunks); 38640 used
CachedPlanSource: 15360 total in 4 blocks; 4360 free (0 chunks); 11000 used
unnamed prepared statement: 57344 total in 3 blocks; 8104 free (1 chunks); 49240 used
idx_connexion_premio_pha_med: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_prog_connexion_pid: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
prog_connexion_pkey: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_presc_editee: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
fki_dsi_presc_editee: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
pk_fab_listen: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
pg_index_indrelid_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
pg_class_relname_nsp_index: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used
index_dsi_biologie_resultat_libelle_examen_libelle: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_biologie_resultat_libelle_examen_id: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_biologie_resultat_patient_nip: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_biologie_resultat_join3: 3072 total in 2 blocks; 1648 free (1 chunks); 1424 used
index_dsi_biologie_resultat_date_resultats: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_biologie_resultat_nip_recu: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_biologie_resultat_nip: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_biologie_resultat_id: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_biologie_resultat_fichier: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_biologie_resultat_echantillon_demandeur: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_biologie_resultat_date_actes: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_adm_code_praticien_type: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_adm_code_praticien_insee: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_adm_code_praticien_code_type: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used
adm_code_praticien_ind_code: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_prog_utilisateur_preference_cle_login: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used
index_onco_radio_presc_idbilan: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_radio_bilan_clusters: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_datedeb_cre: 3072 total in 2 blocks; 1736 free (2 chunks); 1336 used
pk_radio: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
pk_bilan_meta: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used
vue_annuaire_interne: 7168 total in 3 blocks; 1000 free (0 chunks); 6168 used
index_prog_messages_modifie: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_prog_messages_datesupprdestinatairedatesuppremetteur: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used
index_prog_messages_cle: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
idx_msgs_exp0: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
idx_msgs_dest0: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
pk_prog_msgs0: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
pr_produit_fk1: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
fk1_pr_produit: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
pr_produit_pkey: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
sp_specialite_tmp2: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
sp_specialite_temp_cipucd: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
sp_specialite_fk7: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
sp_specialite_fk6: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
sp_specialite_fk5: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
sp_specialite_fk4: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
sp_specialite_fk3: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
sp_specialite_fk1: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
fk6_sp_specialite: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
fk5_sp_specialite: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
fk4_sp_specialite: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
fk3_sp_specialite: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
fk1_sp_specialite: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
sp_specialite_pkey: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
premio_dispoadm_seringue_pkey: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
premio_dispoadm_infuseur_pkey: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
CachedPlan: 15360 total in 4 blocks; 7456 free (0 chunks); 7904 used
index_adm_code_type_examen_id: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
adm_code_type_exa_index1: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
adm_code_type_examen_pkey: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_adm_examen_histo_nip: 3072 total in 2 blocks; 1576 free (0 chunks); 1496 used
index_adm_examen_id_mut: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_adm_examen_id_caisse: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_adm_examen_id: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
adm_examen_nip_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
adm_examen_pkey: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_index_document_sih_nip_valide: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used
index_document_sih_nip: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_document_sih_id: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
pk_document_sih_nomcr: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_prescription_imagerie_id_rdz: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_prescription_imagerie_id: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_demande_hospitalisation_detail_id_demande: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_demande_hospitalisation_tmp: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_demande_hospitalisation_nip: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_demande_hospitalisation_id: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
idx_dsi_transport_presc: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_directive_anticipee_nip: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_bi_codeloc: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_bi_id: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_bi_nip_clusters: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_bi_med_loc: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used
index_bi_med: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
pk_bilan: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_pat_terrains_id: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_allergie_nip: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_pat_note_nip: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
premio_li_rcp_pkey: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
premio_protocole_localisation_id: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
premio_protocole_localisation_code: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
pg_constraint_conrelid_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_formulaire_id_formulaire_lie: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_formulaire_nip: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_formulaire_id: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_formulaire_agent_datecreation: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used
vue_premio_presc_detail: 121856 total in 17 blocks; 6056 free (0 chunks); 115800 used
vue_premio_presc_detail_toppe: 23552 total in 5 blocks; 3064 free (0 chunks); 20488 used
pk_dsi_code_adm_time: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
CachedPlan: 7168 total in 3 blocks; 1648 free (0 chunks); 5520 used
CachedPlanSource: 3072 total in 2 blocks; 664 free (0 chunks); 2408 used
CachedPlanQuery: 7168 total in 3 blocks; 2744 free (18 chunks); 4424 used
SPI Plan: 1024 total in 1 blocks; 808 free (0 chunks); 216 used
CachedPlanSource: 3072 total in 2 blocks; 680 free (0 chunks); 2392 used
CachedPlanQuery: 7168 total in 3 blocks; 3952 free (18 chunks); 3216 used
SPI Plan: 1024 total in 1 blocks; 808 free (0 chunks); 216 used
CachedPlan: 7168 total in 3 blocks; 1648 free (0 chunks); 5520 used
CachedPlanSource: 3072 total in 2 blocks; 664 free (0 chunks); 2408 used
CachedPlanQuery: 7168 total in 3 blocks; 2744 free (18 chunks); 4424 used
SPI Plan: 1024 total in 1 blocks; 808 free (0 chunks); 216 used
CachedPlan: 7168 total in 3 blocks; 2856 free (0 chunks); 4312 used
CachedPlanSource: 3072 total in 2 blocks; 680 free (0 chunks); 2392 used
CachedPlanQuery: 7168 total in 3 blocks; 3952 free (18 chunks); 3216 used
SPI Plan: 1024 total in 1 blocks; 808 free (0 chunks); 216 used
CachedPlanSource: 3072 total in 2 blocks; 1800 free (0 chunks); 1272 used
CachedPlanQuery: 3072 total in 2 blocks; 104 free (1 chunks); 2968 used
SPI Plan: 1024 total in 1 blocks; 808 free (0 chunks); 216 used
CachedPlanSource: 3072 total in 2 blocks; 1816 free (0 chunks); 1256 used
CachedPlanQuery: 3072 total in 2 blocks; 64 free (1 chunks); 3008 used
SPI Plan: 1024 total in 1 blocks; 808 free (0 chunks); 216 used
CachedPlanSource: 3072 total in 2 blocks; 1800 free (0 chunks); 1272 used
CachedPlanQuery: 7168 total in 3 blocks; 2912 free (1 chunks); 4256 used
SPI Plan: 1024 total in 1 blocks; 808 free (0 chunks); 216 used
varian_comment_nip: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
CachedPlanSource: 3072 total in 2 blocks; 1816 free (0 chunks); 1256 used
CachedPlanQuery: 7168 total in 3 blocks; 4336 free (18 chunks); 2832 used
SPI Plan: 1024 total in 1 blocks; 808 free (0 chunks); 216 used
index_dsi_biologie_defaut_code: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
dsi_biologie_defaut_code_pk: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
idx_code_voieabord: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
pk_id_voieabord: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
pk_id_voieadm: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_transmission_ciblee_nip: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_transmission_ciblee_id: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_transmission_ciblee_soin: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_cle_liaison_idcycle: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
idx_adm_cle_liaison_cycle_code: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used
idx_adm_cle_liaison_code: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
pk_cle_liaison_dsi: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
vue_premio_molecule_fc: 15360 total in 4 blocks; 2976 free (1 chunks); 12384 used
vue_premio_molecule_premed: 15360 total in 4 blocks; 2976 free (1 chunks); 12384 used
pk_dsi_posologie_unite_libelle: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_premio_mol_info2: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_premio_mol_info: 3072 total in 2 blocks; 2008 free (1 chunks); 1064 used
pg_toast_2618_index: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used
vue_premio_molecule: 23552 total in 5 blocks; 3736 free (1 chunks); 19816 used
vue_premio_molecule_chi_medass: 15360 total in 4 blocks; 2736 free (1 chunks); 12624 used
idx_essai_bras: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
idx_presc_nip: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
idx_dsi_presc_id: 3072 total in 2 blocks; 2008 free (2 chunks); 1064 used
dsi_presc_pkey: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
index_action_id: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
unik_agenda_action_code: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
agenda_action_pk: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_maladie_creutzfeldt_nip: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_ress_serv_id: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
pk_ress_service: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_ress_salle_id: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
pk_ress_salle: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_ress_medecin_id: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
pk_ress_med: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_ress_app_id: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
pk_ress_appareil: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_ress_id: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
agenda_ressource_pk: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
index_agenda_agenda_histo_nip: 3072 total in 2 blocks; 1576 free (0 chunks); 1496 used
index_agenda_agenda_2b: 3072 total in 2 blocks; 1144 free (1 chunks); 1928 used
index_agenda_agenda_2: 3072 total in 2 blocks; 1144 free (1 chunks); 1928 used
index_agenda_agenda_1: 3072 total in 2 blocks; 1648 free (1 chunks); 1424 used
index_agenda_nip2: 3072 total in 2 blocks; 1576 free (1 chunks); 1496 used
index_agenda_nip: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_agenda_id2: 3072 total in 2 blocks; 1576 free (1 chunks); 1496 used
index_agenda_id: 3072 total in 2 blocks; 1576 free (1 chunks); 1496 used
index_agenda_agenda_etat_attente: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used
agenda_idx_date: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
agenda_agenda_pk: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_motif_entree_libelle: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_motif_entree_id: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_inf_acte_id: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
contrainte_dsi_inf_acte_code_interne_unique: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_adm_pat_consultation_histo_nip: 3072 total in 2 blocks; 1624 free (0 chunks); 1448 used
index_adm_pat_consultation_nip: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_adm_pat_consultation_login_date: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used
index_adm_pat_consultation_login: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_med_int_nip: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
pk_nip_med_int: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used
index_onco_med_int_id: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_med_int_code: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
pkmedint: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_prescription_generale_id: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_prescription_generale_commentprat: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
idx_presc_gen_nip: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
pk_presc_gen: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_inf_adm_nip_date_datedebrecherche_datefinrecherche: 3072 total in 2 blocks; 1736 free (2 chunks); 1336 used
index_dsi_inf_adm_nip: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_inf_adm_datereelle_idlogin: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used
idx_adm_idjour: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
idx_adm_comm: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
dsi_inf_adm_id: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
dsi_inf_adm_datereelle: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
dsi_inf_adm_date: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
pk_inf_adm: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_prescription_jour_vecteur_idcycle: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_prescription_jour_vecteur_dureeadm_idcycle_jour_rang_iden: 3072 total in 2 blocks; 1648 free (1 chunks); 1424 used
idx_vecteur_2: 3072 total in 2 blocks; 2008 free (1 chunks); 1064 used
idx_jour_vecteur_tmp: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
idx_jour_vecteur: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
dsi_presc_jour_pk_7: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_prescription_jour_medicament_vecteur_visible_idvecteur: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used
index_prescription_jour_medicament_vecteur_idcycle: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_prescription_jour_medicament_vecteur_dureeadm_idcycle_jou: 3072 total in 2 blocks; 1648 free (1 chunks); 1424 used
index_dsi_presc_jour_medicament_vecteur_idcycle_visible: 3072 total in 2 blocks; 2008 free (1 chunks); 1064 used
idx_medicament_vecteur_2: 3072 total in 2 blocks; 2008 free (1 chunks); 1064 used
idx_med_vecteur_clee: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
idx_jour_medicament_vecteur: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
idx_jour_med_vect_tmp: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
dsi_presc_jour_pk_6: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_presc_jour_pca_produit_visible_idcycle_jour_rang_iden: 3072 total in 2 blocks; 1648 free (1 chunks); 1424 used
index_dsi_presc_jour_pca_produit_idcycle_visible: 3072 total in 2 blocks; 2008 free (1 chunks); 1064 used
index_dsi_presc_jour_pca_produit_idcycle: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_presc_jour_pca_produit_id: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_presc_jour_medicament_idcycle_datetheo: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used
index_dsi_presc_jour_medicament_visible_idcycle_jour_rang_ident: 3072 total in 2 blocks; 1648 free (1 chunks); 1424 used
index_dsi_presc_jour_medicament_dureeadm_idcycle_jour_rang_iden: 3072 total in 2 blocks; 1648 free (1 chunks); 1424 used
idx_jour_med_tmp: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
idx_jour_med_non_visible: 3072 total in 2 blocks; 1960 free (1 chunks); 1112 used
idx_jour_med_a: 3072 total in 2 blocks; 1464 free (1 chunks); 1608 used
idx_jour_med_0: 3072 total in 2 blocks; 2008 free (1 chunks); 1064 used
idx_jour_med: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
dsi_presc_jour_med_idx_ucd: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
dsi_presc_jour_pk_5: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
premio_jours_idx_ucd: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_premio_presc_jour_produit_identite: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
idx_presc_jour_premio3: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
idx_presc_jour_premio2: 3072 total in 2 blocks; 2008 free (1 chunks); 1064 used
idx_presc_jour_premio1: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
idx_presc_jour_premio0: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
idx_premio_jour_5: 3072 total in 2 blocks; 1464 free (1 chunks); 1608 used
idx_premio_jour2: 3072 total in 2 blocks; 2008 free (1 chunks); 1064 used
index_dsi_presc_jour_pca_visible_idcycle_jour_rang_identite: 3072 total in 2 blocks; 1648 free (1 chunks); 1424 used
index_dsi_presc_jour_pca_idcycle_visible: 3072 total in 2 blocks; 2008 free (1 chunks); 1064 used
index_dsi_presc_jour_pca_idcycle: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_presc_jour_pca_id: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_presc_jour_diet_visible_idcycle_jour_rang_identite: 3072 total in 2 blocks; 1648 free (1 chunks); 1424 used
index_dsi_presc_jour_diet_idcycle_visible: 3072 total in 2 blocks; 2008 free (1 chunks); 1064 used
index_dsi_presc_jour_diet_idcycle: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_presc_jour_diet_id: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_presc_jour_molecule_datetheo_top_visible: 3072 total in 2 blocks; 1784 free (2 chunks); 1288 used
idx_presc_jour_molecule5: 3072 total in 2 blocks; 1512 free (1 chunks); 1560 used
idx_presc_jour_molecule4: 3072 total in 2 blocks; 1944 free (0 chunks); 1128 used
idx_presc_jour_molecule3: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
idx_presc_jour_molecule2: 1024 total in 1 blocks; 40 free (0 chunks); 984 used
idx_presc_jour_molecule1: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
idx_presc_jour_molecule0: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
index_dsi_presc_jour_sang_visible_idcycle_jour_rang_identite: 3072 total in 2 blocks; 1696 free (1 chunks); 1376 used
index_dsi_presc_jour_sang_idcycle_visible: 1024 total in 1 blocks; 40 free (0 chunks); 984 used
index_dsi_presc_jour_sang_idcycle: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
index_dsi_presc_jour_sang_id: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
index_dsi_presc_jour_examen_visible_idcycle_jour_rang_identite: 3072 total in 2 blocks; 1648 free (1 chunks); 1424 used
index_dsi_presc_jour_examen_idcycle_visible: 3072 total in 2 blocks; 2008 free (1 chunks); 1064 used
index_dsi_presc_jour_examen_idcycle: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_presc_jour_examen_id: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_presc_jour_biologie_visible_idcycle_jour_rang_identit: 3072 total in 2 blocks; 1648 free (1 chunks); 1424 used
index_dsi_presc_jour_biologie_idcycle_visible: 3072 total in 2 blocks; 2008 free (1 chunks); 1064 used
index_dsi_presc_jour_biologie_idcycle: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_presc_jour_biologie_id: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_presc_jour_biologie_demande: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_presc_jour_acte_infirmier_visible_idcycle_jour_rang_i: 3072 total in 2 blocks; 1648 free (1 chunks); 1424 used
index_dsi_presc_jour_acte_infirmier_tmp: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_presc_jour_acte_infirmier_idcycle_visible: 3072 total in 2 blocks; 2008 free (1 chunks); 1064 used
index_dsi_presc_jour_acte_infirmier_idcycle: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_presc_jour_acte_infirmier_id: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_presc_jour_divers_visible_idcycle_jour_rang_identite: 3072 total in 2 blocks; 1648 free (1 chunks); 1424 used
index_dsi_presc_jour_divers_idcycle_visible: 3072 total in 2 blocks; 2008 free (1 chunks); 1064 used
index_dsi_presc_jour_divers_id: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_presc_jour_divers_cycle: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_presc_jour_ide_pha_id: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
idx_jour_pha_0: 1024 total in 1 blocks; 40 free (0 chunks); 984 used
pk_dsi_presc_jour_ide_pha: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
idx_jour_non_pha_id: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
idx_jour_non_pha_0: 1024 total in 1 blocks; 40 free (0 chunks); 984 used
pk_dsi_pres_jour_ide_non_pha: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
index_dsi_presc_jour_visible_idcycle_jour_rang_identite: 3072 total in 2 blocks; 1696 free (1 chunks); 1376 used
idx_presc_jour3: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
idx_presc_jour2: 1024 total in 1 blocks; 40 free (0 chunks); 984 used
idx_presc_jour1: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
idx_presc_jour: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
pg_toast_27770_index: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used
adm_code_sitfam_pk: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
code_pays_pkey: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_pec_nip_deb: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used
idx_planning_lit_6: 3072 total in 2 blocks; 1304 free (1 chunks); 1768 used
idx_planning_lit_5: 3072 total in 2 blocks; 1304 free (1 chunks); 1768 used
index_dsi_planning_lit_nip: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_planning_lit_demande: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
idx_planning_lit_depart: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
idx_planning_lit_4: 3072 total in 2 blocks; 1736 free (2 chunks); 1336 used
idx_planning_lit_3: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used
idx_planning_lit_1: 3072 total in 2 blocks; 1736 free (2 chunks); 1336 used
idx_planning_lit_0: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_code_chambre_id: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_code_lit_id: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_idx_planning_chambre_0_idchambre_deb_fin: 3072 total in 2 blocks; 1736 free (2 chunks); 1336 used
index_dsi_planning_chambre_depart_fin: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used
idx_planning_chambre_0: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
idx_planning_salleattente_1: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_planning_secteur_idsecteur_depart_fin: 3072 total in 2 blocks; 1736 free (2 chunks); 1336 used
idx_planning_secteur_1: 3072 total in 2 blocks; 1736 free (2 chunks); 1336 used
idx_planning_secteur_0: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_code_secteur_id: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
CachedPlanSource: 3072 total in 2 blocks; 672 free (0 chunks); 2400 used
CachedPlanQuery: 15360 total in 4 blocks; 8552 free (23 chunks); 6808 used
SPI Plan: 1024 total in 1 blocks; 808 free (0 chunks); 216 used
index_fab_dilution: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
premio_dispoadm_poche_pkey: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_pharmacie_serialized_specialite_codeucd0: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
pk_spe_serial: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
pk_premio_lot: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
premio_vehicule_pkey: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_premio_fabrication_reconstitution_idlotsolvant: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_premio_fabrication_reconstitution_idlotFlacons: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_fab_reconstitution: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
vue_pha_lot: 7168 total in 3 blocks; 800 free (0 chunks); 6368 used
index_dsi_presc_cycle_unite_fonc_id: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used
index_dsi_presc_cycle_id: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
idx_dsi_cycle3: 3072 total in 2 blocks; 1736 free (0 chunks); 1336 used
idx_dsi_cycle2: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
idx_dsi_cycle: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
idx_cycle_0: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
dsi_presc_cycle_pkey: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_pharmacie_homemade_lot_id: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_dsi_pha_lot_id: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
dsi_pha_lot_pkey: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_pharmacie_liaison_specialite_atc_racine: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_pharmacie_liaison_specialite_atc: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
pharmacie_liaison_specialite_idx0: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_pharmacie_liaison_specialite_id: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
pharmacie_liaison_specialite_pk: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_premio_spe_ucd: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
dsi_pha_specialite_ucd_pkey: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_premio_spe: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
dsi_pha_specialite_pkey: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
pg_inherits_parent_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
vue_premio_molecule_specialite: 15360 total in 4 blocks; 5400 free (1 chunks); 9960 used
index_code_pmsi_cim10_libellecourt: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_code_pmsi_cim10_code: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
pk_code_pmsi_cim10_codeb: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_adm_code_service_horspmsi: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_adm_code_service_code: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
premio_fab_annulee_idx1: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used
premio_fab_annulee_idx0: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used
index_fab_annulee_nip: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
premio_fabrication_annulee_pkey: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_prog_connexion_admin_dialog: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_pharmacie_molecule_onereuse_idmol_deb: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used
contrainte_pharmacie_molecule_onereuse: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used
pharmacie_liaison_molecule_idx0: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_pharmacie_liaison_molecule_id: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
pharmacie_liaison_molecule_pk: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_prenom_adm_pat: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_nom_dn_adm_pat: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used
index_adm_pat_nss: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_adm_pat_nomjf_upper: 3072 total in 2 blocks; 1768 free (0 chunks); 1304 used
index_adm_pat_nomjf: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_adm_pat_nom_upper: 3072 total in 2 blocks; 1768 free (0 chunks); 1304 used
index_adm_pat_nom: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_adm_pat_nip: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_adm_pat_id_mut: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_adm_pat_id_caisse: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
adm_pat_nip_pkey: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
idx_premio_protocole_chimio_new_libelle: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
premio_protocole_chimio_new_pkey: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
idx_presc_premio_nip: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
idx_premio_presc_rcp: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used
idx_premio_presc4: 3072 total in 2 blocks; 1960 free (1 chunks); 1112 used
pk_presc_premio: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
premio_fabrication_idpres_cycle2: 3072 total in 2 blocks; 1824 free (0 chunks); 1248 used
premio_fabrication_idpres_cycle: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used
premio_fabrication_idpres2: 3072 total in 2 blocks; 1960 free (1 chunks); 1112 used
premio_fabrication_idpres: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_premio_fabrication_datedepart: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_fab_nip: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
idx_fabrication3: 3072 total in 2 blocks; 1304 free (1 chunks); 1768 used
idx_fabrication2: 3072 total in 2 blocks; 1304 free (1 chunks); 1768 used
idx_fabrication1: 3072 total in 2 blocks; 1304 free (1 chunks); 1768 used
idx_fabrication0b: 3072 total in 2 blocks; 1240 free (1 chunks); 1832 used
idx_fabrication0: 3072 total in 2 blocks; 1064 free (1 chunks); 2008 used
premio_fabrication_pkey: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
vue_pha_molecule: 15360 total in 4 blocks; 4792 free (0 chunks); 10568 used
prog_utilisateur_appli_code: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_prog_utilisateur_appli_code: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_adm_param_type: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_adm_param_param: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
pk_bugzilla_utilisateur: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
EventTriggerCache: 8192 total in 1 blocks; 8160 free (2 chunks); 32 used
Event Trigger Cache: 8192 total in 1 blocks; 3744 free (0 chunks); 4448 used
dextr_date_extraction_pkey: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used
idx_quicklinks: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_prog_connexion_logs_users_connexion: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used
index_prog_connexion_log_user: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
idp_conn_logs: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used
pk_prog_util_v3: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_prog_group_utilisateur_utilisateur: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_prog_appli_group_groupe: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
pk_prog_appli_group_groupe: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
pg_toast_2619_index: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used
prog_utilisateur_password_index_for_ldap: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_prog_utilisateur_id: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
unik_prog_util_login: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
unik_prog_util_code: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
pk_prog_utilisateur_initiales: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
pk_pro_util_id: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
index_adm_code_entite_code: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
pkeycode: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
pg_attrdef_adrelid_adnum_index: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used
pg_db_role_setting_databaseid_rol_index: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used
pg_opclass_am_name_nsp_index: 3072 total in 2 blocks; 1736 free (2 chunks); 1336 used
pg_foreign_data_wrapper_name_index: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
pg_enum_oid_index: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
pg_foreign_server_oid_index: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
pg_statistic_relid_att_inh_index: 3072 total in 2 blocks; 1736 free (2 chunks); 1336 used
pg_cast_source_target_index: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used
pg_language_name_index: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
pg_collation_oid_index: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
pg_amop_fam_strat_index: 3072 total in 2 blocks; 1736 free (2 chunks); 1336 used
pg_index_indexrelid_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
pg_ts_template_tmplname_index: 1024 total in 1 blocks; 64 free (0 chunks); 960 used
pg_ts_config_map_index: 3072 total in 2 blocks; 1784 free (2 chunks); 1288 used
pg_opclass_oid_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
pg_foreign_data_wrapper_oid_index: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
pg_event_trigger_evtname_index: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
pg_ts_dict_oid_index: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
pg_event_trigger_oid_index: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
pg_conversion_default_index: 3072 total in 2 blocks; 1784 free (2 chunks); 1288 used
pg_operator_oprname_l_r_n_index: 3072 total in 2 blocks; 1736 free (2 chunks); 1336 used
pg_trigger_tgrelid_tgname_index: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used
pg_enum_typid_label_index: 1024 total in 1 blocks; 64 free (0 chunks); 960 used
pg_ts_config_oid_index: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
pg_user_mapping_oid_index: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
pg_opfamily_am_name_nsp_index: 3072 total in 2 blocks; 1784 free (2 chunks); 1288 used
pg_foreign_table_relid_index: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
pg_aggregate_fnoid_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
pg_constraint_oid_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
pg_rewrite_rel_rulename_index: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used
pg_ts_parser_prsname_index: 1024 total in 1 blocks; 64 free (0 chunks); 960 used
pg_ts_config_cfgname_index: 1024 total in 1 blocks; 64 free (0 chunks); 960 used
pg_ts_parser_oid_index: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
pg_operator_oid_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
pg_namespace_nspname_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
pg_ts_template_oid_index: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
pg_amop_opr_fam_index: 3072 total in 2 blocks; 1736 free (2 chunks); 1336 used
pg_default_acl_role_nsp_obj_index: 3072 total in 2 blocks; 1784 free (2 chunks); 1288 used
pg_collation_name_enc_nsp_index: 3072 total in 2 blocks; 1784 free (2 chunks); 1288 used
pg_range_rngtypid_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
pg_ts_dict_dictname_index: 1024 total in 1 blocks; 64 free (0 chunks); 960 used
pg_opfamily_oid_index: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
pg_class_oid_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
pg_proc_proname_args_nsp_index: 3072 total in 2 blocks; 1736 free (2 chunks); 1336 used
pg_attribute_relid_attnum_index: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used
pg_proc_oid_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
pg_language_oid_index: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
pg_namespace_oid_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
pg_amproc_fam_proc_index: 3072 total in 2 blocks; 1736 free (2 chunks); 1336 used
pg_foreign_server_name_index: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
pg_conversion_oid_index: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
pg_user_mapping_user_server_index: 1024 total in 1 blocks; 64 free (0 chunks); 960 used
pg_conversion_name_nsp_index: 1024 total in 1 blocks; 64 free (0 chunks); 960 used
pg_authid_oid_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
pg_auth_members_member_role_index: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used
pg_tablespace_oid_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
pg_database_datname_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
pg_auth_members_role_member_index: 1024 total in 1 blocks; 64 free (0 chunks); 960 used
pg_database_oid_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
pg_authid_rolname_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
MdSmgr: 24576 total in 2 blocks; 7296 free (12 chunks); 17280 used
ident parser context: 0 total in 0 blocks; 0 free (0 chunks); 0 used
hba parser context: 7168 total in 3 blocks; 304 free (2 chunks); 6864 used
LOCALLOCK hash: 24576 total in 2 blocks; 5696 free (4 chunks); 18880 used
Timezones: 83472 total in 2 blocks; 3744 free (0 chunks); 79728 used
ErrorContext: 8192 total in 1 blocks; 8160 free (5 chunks); 32 used
172.18.2.95(49334) -- 2014-09-18 10:29:20 CEST -- mblondeau : ERREUR: mémoire épuisée
172.18.2.95(49334) -- 2014-09-18 10:29:20 CEST -- mblondeau : DÉTAIL: Échec d'une requête de taille 1572864.
172.18.2.95(49334) -- 2014-09-18 10:29:20 CEST -- mblondeau : INSTRUCTION : select a.voieadm, a.voieabord, initcap(b.dci) as dci, a.idmol, a.level, a.jour_fin_adm, a.rang, a.dureeadm, a.doseajustee, a.datedepart from premio_fabrication a inner join vue_pha_molecule b on a.idmol=b.id where a.idpres=326869 and a.cycle=1 and a.datedepart='2014-09-19 00:00:00.000' order by rang
-- 2014-09-18 10:29:20 CEST -- : LOG: n'a pas pu exécuter le processus autovacuum worker : Ne peut allouer de la mémoire

Merci

gleu · 18/09/2014 23:35:03

Le plus intéressant est la dernière ligne. Le système lui-même est à court de mémoire. Pourtant, la configuration de PostgreSQL semble bonne. D'autres logiciels sont lancés sur ce serveur ?

isc84 · 19/09/2014 07:46:35

Non nous sommes sur une machine virtuelle complètement dédiée.

ruizsebastien · 19/09/2014 09:04:07

Bonjour,

C'est étrange car avec votre conf postgresql et 400 connexions au moment du crash, postgresql ne devrait pas consommer plus de la moitié des 16Gb de RAM...
Êtes-vous sur de bien disposer de 16 Gb et n'y aurait-il pas un ou plusieurs processus (hors postgresql) qui consommeraient de la RAM de manière excessive ?

Pouvez-vous nous donner à tout hasard les valeurs des paramètres autovacuum (select * from pg_settings where name like 'autovacuum%';) en particulier le autovacuum_max_workers ?
Cordialement,

gleu · 19/09/2014 10:16:53

Et le max_connections.

isc84 · 19/09/2014 10:28:42

Autovaccum

"autovacuum";"on";"";"Autovacuum";"Starts the autovacuum subprocess.";"";"sighup";"bool";"default";"";"";"";"on";"on";"";
"autovacuum_analyze_scale_factor";"0.1";"";"Autovacuum";"Number of tuple inserts, updates, or deletes prior to analyze as a fraction of reltuples.";"";"sighup";"real";"default";"0";"100";"";"0.1";"0.1";"";
"autovacuum_analyze_threshold";"50";"";"Autovacuum";"Minimum number of tuple inserts, updates, or deletes prior to analyze.";"";"sighup";"integer";"default";"0";"2147483647";"";"50";"50";"";
"autovacuum_freeze_max_age";"200000000";"";"Autovacuum";"Age at which to autovacuum a table to prevent transaction ID wraparound.";"";"postmaster";"integer";"default";"100000000";"2000000000";"";"200000000";"200000000";"";
"autovacuum_max_workers";"3";"";"Autovacuum";"Sets the maximum number of simultaneously running autovacuum worker processes.";"";"postmaster";"integer";"default";"1";"8388607";"";"3";"3";"";
"autovacuum_multixact_freeze_max_age";"400000000";"";"Autovacuum";"Multixact age at which to autovacuum a table to prevent multixact wraparound.";"";"postmaster";"integer";"default";"10000000";"2000000000";"";"400000000";"400000000";"";
"autovacuum_naptime";"60";"s";"Autovacuum";"Time to sleep between autovacuum runs.";"";"sighup";"integer";"default";"1";"2147483";"";"60";"60";"";
"autovacuum_vacuum_cost_delay";"20";"ms";"Autovacuum";"Vacuum cost delay in milliseconds, for autovacuum.";"";"sighup";"integer";"default";"-1";"100";"";"20";"20";"";
"autovacuum_vacuum_cost_limit";"-1";"";"Autovacuum";"Vacuum cost amount available before napping, for autovacuum.";"";"sighup";"integer";"default";"-1";"10000";"";"-1";"-1";"";
"autovacuum_vacuum_scale_factor";"0.2";"";"Autovacuum";"Number of tuple updates or deletes prior to vacuum as a fraction of reltuples.";"";"sighup";"real";"default";"0";"100";"";"0.2";"0.2";"";
"autovacuum_vacuum_threshold";"50";"";"Autovacuum";"Minimum number of tuple updates or deletes prior to vacuum.";"";"sighup";"integer";"default";"0";"2147483647";"";"50";"50";"";

Max_connections = 800

A tout hasard on a eu ce matin ce message pour un utilisateur

172.18.2.82(49237) -- 2014-09-19 10:06:38 CEST -- machampeau : ERREUR: données insuffisantes laissées dans le message
172.18.2.82(49238) -- 2014-09-19 10:06:39 CEST -- machampeau : ERREUR: format du message invalide
172.18.2.82(49237) -- 2014-09-19 10:06:39 CEST -- machampeau : ERREUR: données insuffisantes laissées dans le message
172.18.2.82(49238) -- 2014-09-19 10:06:39 CEST -- machampeau : ERREUR: format du message invalide
172.18.2.82(49237) -- 2014-09-19 10:06:40 CEST -- machampeau : ERREUR: données insuffisantes laissées dans le message
172.18.2.82(49238) -- 2014-09-19 10:06:40 CEST -- machampeau : ERREUR: format du message invalide
172.18.2.82(49237) -- 2014-09-19 10:06:40 CEST -- machampeau : ERREUR: données insuffisantes laissées dans le message
172.18.2.82(49238) -- 2014-09-19 10:06:41 CEST -- machampeau : ERREUR: format du message invalide

Je ne sais pas si ça peut être lié ... Ce matin tout va bien par contre.

ruizsebastien · 19/09/2014 10:32:46

et pour le reste de la question :

Êtes-vous sur de bien disposer de 16 Gb et n'y aurait-il pas un ou plusieurs processus (hors postgresql) qui consommeraient de la RAM de manière excessive ?

isc84 · 22/09/2014 12:14:32

Le serveur est dédié et seul postgresql tourne dessus.
Il dispose en tant que machine virtuelle de 16GB fixes, et VMWare n'était pas à cours de mémoire à ce moment là.
On ne swappait presque pas (140MB) et il restait environ 1GB de mémoire dispo sur la machine dediée.

gleu · 22/09/2014 22:59:09

Avoir un max_connections à 800 sur une machine virtuelle ? ça me semble très peu cohérent, ni réaliste pour un sou. Combien de vCPU ?

isc84 · 23/09/2014 09:08:36

La machine disposait de 8 vCPU (nous sommes redescendu à 4 et d'après notre revendeur il suffit de rester à 2 car la possibilité d'avoir plusieurs vCPU est uniquement là pour des questions de licences).

De plus, nous avons un système VMWare couplé à une solution Datacore avec auto-tiering ainsi vous avez un vue globale du système.

A ce sujet y-a-t-il des préconisations pour la virtualisation d'un serveur dédié Postgresql sous Linux ? Et pour enfoncer le clou des formations dans ce domaine existent-elles ?

gleu a écrit :

Avoir un max_connections à 800 sur une machine virtuelle ? ça me semble très peu cohérent, ni réaliste pour un sou. Combien de vCPU ?

Pourriez-vous préciser ce qui semble irréaliste svp?

Merci

Dernière modification par isc84 (23/09/2014 09:39:42)

gleu · 24/09/2014 01:13:33

Un CPU normal (non virtualisé) peut traiter, suivant les cas, entre dix et vingt requêtes simultanées. Avec 800 connexions, cela fait 800 requêtes simultanées possibles, soit entre 40 et 80 CPU. À comparer avec votre nombre de vCPU... totalement irréaliste.

Concernant les préconisations pour la virtualisation d'un serveur PostgreSQL, il n'y en a pas pour deux raisons :
* la première est que c'est fortement déconseillé, pour plusieurs raisons, et surtout si vous cherchez à obtenir des performances (cela étant dit, bon nombre d'utilisateurs passent par de la virtualisation avec PostgreSQL avec bonheur... tout dépend de ses besoins en performance... et de la compétence de l'équipe de virtualisation) ;
* la deuxième est que PostgreSQL ne s'adresse pas directement au matériel, il passe toujours par le système d'exploitation, donc si le système d'exploitation est compatible avec le système de virtualisation, alors PostgreSQL est aussi compatible.

Quant aux formations, il en existe pour PostgreSQL, sur différents niveaux et/ou thèmes. Spécifiquement ciblé virtualisation, je n'en connais pas.

#1 18/09/2014 12:28:26

memoire epuisée et TopMemoryContext

#2 18/09/2014 13:19:24

Re : memoire epuisée et TopMemoryContext

#3 18/09/2014 13:47:22

Re : memoire epuisée et TopMemoryContext

#4 18/09/2014 19:36:41

Re : memoire epuisée et TopMemoryContext

#5 18/09/2014 21:26:01

Re : memoire epuisée et TopMemoryContext

#6 18/09/2014 23:35:03

Re : memoire epuisée et TopMemoryContext

#7 19/09/2014 07:46:35

Re : memoire epuisée et TopMemoryContext

#8 19/09/2014 09:04:07

Re : memoire epuisée et TopMemoryContext

#9 19/09/2014 10:16:53

Re : memoire epuisée et TopMemoryContext

#10 19/09/2014 10:28:42

Re : memoire epuisée et TopMemoryContext

#11 19/09/2014 10:32:46

Re : memoire epuisée et TopMemoryContext

#12 22/09/2014 12:14:32

Re : memoire epuisée et TopMemoryContext

#13 22/09/2014 22:59:09

Re : memoire epuisée et TopMemoryContext

#14 23/09/2014 09:08:36

Re : memoire epuisée et TopMemoryContext

#15 24/09/2014 01:13:33

Re : memoire epuisée et TopMemoryContext

Pied de page des forums

PostgreSQL.fr

À propos

Nous contacter

Groupes Locaux

Réseaux Sociaux