PostgreSQL La base de donnees la plus sophistiquee au monde.

Forums PostgreSQL.fr

Le forum officiel de la communauté francophone de PostgreSQL

Vous n'êtes pas identifié(e).

#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 ?


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

#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...

Pied de page des forums

Propulsé par FluxBB