Vous n'êtes pas identifié(e).
- Contributions : Récentes | Sans réponse
Pages : 1
#1 Re : Général » memoire epuisée et TopMemoryContext » 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 ?
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
#2 Re : Général » memoire epuisée et TopMemoryContext » 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.
#3 Re : Général » memoire epuisée et TopMemoryContext » 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.
#4 Re : Général » memoire epuisée et TopMemoryContext » 19/09/2014 07:46:35
Non nous sommes sur une machine virtuelle complètement dédiée.
#5 Re : Général » memoire epuisée et TopMemoryContext » 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
#7 Général » memoire epuisée et TopMemoryContext » 18/09/2014 12:28:26
- isc84
- Réponses : 14
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...
Pages : 1