Forums PostgreSQL.fr

lpo77

Membre

Erreur 53200 Out of Memory

Bonjour,

Sur une de nos applications nous avons régulièrement une erreur 53200 lors de l'exécution d'une requête , ci-dessous la pile d'erreur

[5-1] ERROR:  53200: out of memory
[6-1] DETAIL:  Failed on request of size 1572864.
[7-1] LOCATION:  AllocSetRealloc, aset.c:973

Voici la trace coté serveur d'application

org.jboss.logging.jboss-logging - 3.1.2.GA | ERROR: out of memory
  Détail : Failed on request of size 1572864.
executing failed
org.hibernate.exception.GenericJDBCException: could not extract ResultSet

la configuration du cluster pgs
effective_cache_size                | 12800MB
shared_buffers                      | 384MB
work_mem                            | 384MB

La configuration serveur
RHEL 6.5
RAM : 16Go
2 CPUs

Cordialement

ruizsebastien

Membre

Re : Erreur 53200 Out of Memory

Bonjour,

on dirait que vous avez consommé toutes la mémoire du serveur (ram+swap).
Vos pouvez checker vos logs system pour avoir une idée plus précise.
dans votre conf le work_mem me semble trop élevé (je mettrais 50MB environ) . Par contre vous pouvez augmenter shared_buffers.
Quelle est la valeur de votre paramètre max_connections ?
Combien de connexions actives simultanées avez-vous habituellement (max) ?
Pouvez-vous nous dire quel traitement était en exécution au moment de l'erreur ?

Dernière modification par ruizsebastien (16/03/2018 11:35:45)

---

Cordialement,

Sébastien.

gleu

Administrateur

Re : Erreur 53200 Out of Memory

De plus, généralement, dans le cas de ce type d'erreur, il y a un mem trace avec les tailles des différentes allocations. Ce serait intéressant de le fournir.

---

Guillaume.

lpo77

Membre

Re : Erreur 53200 Out of Memory

Bonjour,

merci pour vos réponse et je m'excuse de cette réponse tardive.

il n'y a rien dans les traces "system"

Ci-dessous un extrait de la log  postgresql

TopMemoryContext: 137296 total in 18 blocks; 9640 free (26 chunks); 127656 used
  Type information cache: 24240 total in 2 blocks; 3744 free (0 chunks); 20496 used
  Btree proof lookup cache: 8192 total in 1 blocks; 1680 free (0 chunks); 6512 used
  TopTransactionContext: 8192 total in 1 blocks; 7392 free (0 chunks); 800 used
  Prepared Queries: 24576 total in 2 blocks; 15984 free (5 chunks); 8592 used
  TableSpace cache: 8192 total in 1 blocks; 3216 free (0 chunks); 4976 used
  Operator lookup cache: 24576 total in 2 blocks; 11888 free (5 chunks); 12688 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: 57344 total in 3 blocks; 34320 free (10 chunks); 23024 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: 15128 total in 2 blocks; 176 free (0 chunks); 14952 used
      ExecutorState: 1382352 total in 40 blocks; 484208 free (0 chunks); 898144 used
        HashTableContext: 268435504 total in 1 blocks; 0 free (0 chunks); 268435504 used
          HashBatchContext: 0 total in 0 blocks; 0 free (0 chunks); 0 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: 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: 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: 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: 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: 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
        BTree Array Context: 1024 total in 1 blocks; 744 free (0 chunks); 280 used
        ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
        BTree Array Context: 3072 total in 2 blocks; 2760 free (6 chunks); 312 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: 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: 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: 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: 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: 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: 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: 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: 24576 total in 2 blocks; 10752 free (3 chunks); 13824 used
  CacheMemoryContext: 1529264 total in 26 blocks; 15792 free (0 chunks); 1513472 used
    CachedPlan: 1047552 total in 10 blocks; 339352 free (0 chunks); 708200 used
    sub_linelinedata_managed_objecti2rid_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    sub_linelinedata_managed_objectentity_in_versiontechnicalid_ind: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    sub_linelinedata_managed_objectentity_in_versionregionname_inde: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    sub_line_pkey: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    linedata_managed_objecti2rid_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    linedata_managed_objectentity_in_versiontechnicalid_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    linedata_managed_objectentity_in_versionregionname_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    line_pkey: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    CachedPlanSource: 299312 total in 10 blocks; 88368 free (0 chunks); 210944 used
      unnamed prepared statement: 1040384 total in 7 blocks; 11688 free (5 chunks); 1028696 used
    CachedPlan: 1024 total in 1 blocks; 784 free (0 chunks); 240 used
    CachedPlanSource: 1024 total in 1 blocks; 648 free (0 chunks); 376 used
      CachedPlanQuery: 1024 total in 1 blocks; 592 free (0 chunks); 432 used
    aliastechnicalid_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    aliasregionname_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    alias_pkey: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    uk_psvdjvgibm0aptute1u7aynw5: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    data_managed_object_aliases_pkey: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used
    pg_attrdef_adrelid_adnum_index: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used
    service_calendardata_managed_objecti2rid_index: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    service_calendardata_managed_objectentity_in_versiontechnicalid: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    service_calendardata_managed_objectentity_in_versionregionname_: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    service_calendar_pkey: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    info_linki2rid_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    info_linkentity_in_versiontechnicalid_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    info_linkentity_in_versionregionname_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    info_link_pkey: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    uk_ani4kw42q0epmgn9v9jpkee4i: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    data_managed_object_info_links_pkey: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used
    pg_toast_2619_index: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used
    timebanddata_managed_objecti2rid_index: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    timebanddata_managed_objectentity_in_versiontechnicalid_index: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    timebanddata_managed_objectentity_in_versionregionname_index: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    timeband_pkey: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    uk_htaec9svvtwm7v6e0hlm77cv: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    day_type_times_bands_pkey: 1024 total in 1 blocks; 64 free (0 chunks); 960 used
    uk_fjncd9kt20bticw3it4xx6eam: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    property_of_day_day_types_pkey: 1024 total in 1 blocks; 64 free (0 chunks); 960 used
    property_of_daydata_managed_objecti2rid_index: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    property_of_daydata_managed_objectentity_in_versiontechnicalid_: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    property_of_daydata_managed_objectentity_in_versionregionname_i: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    property_of_day_pkey: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    uk_5f81ml0p1fjk364mc6oemn8v: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    day_type_properties_of_day_pkey: 1024 total in 1 blocks; 64 free (0 chunks); 960 used
    operating_daydata_managed_objecti2rid_index: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    operating_daydata_managed_objectentity_in_versiontechnicalid_in: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    operating_daydata_managed_objectentity_in_versionregionname_ind: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    operating_day_pkey: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    uk_bks1y94pltw8oxynfcws0vk3a: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    day_type_operating_days_pkey: 1024 total in 1 blocks; 64 free (0 chunks); 960 used
    day_typedata_managed_objecti2rid_index: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    day_typedata_managed_objectentity_in_versiontechnicalid_index: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    day_typedata_managed_objectentity_in_versionregionname_index: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    day_type_pkey: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    validity_condition_day_types_pkey: 1024 total in 1 blocks; 64 free (0 chunks); 960 used
    uk_rqxle8qbcu17ubgmiwn127ct1: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    availability_conditionvalidity_conditiontechnicalid_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    availability_conditionvalidity_conditionregionname_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    availability_condition_pkey: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    validity_conditiontechnicalid_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    validity_conditionregionname_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    validity_condition_pkey: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    source_entitytechnicalid_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    source_entityregionname_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    source_entity_pkey: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    uk_tw8ijm45c23pnc1pn68a8iix: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    entity_in_version_source_entities_pkey: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used
    directiontype_of_valuedata_managed_objecti2rid_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    directiontype_of_valuedata_managed_objectentity_in_versiontechn: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    directiontype_of_valuedata_managed_objectentity_in_versionregio: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    direction_pkey: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    region_pkey: 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_db_role_setting_databaseid_rol_index: 1024 total in 1 blocks; 64 free (0 chunks); 960 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_class_relname_nsp_index: 1024 total in 1 blocks; 16 free (0 chunks); 1008 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_type_oid_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    pg_aggregate_fnoid_index: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    pg_constraint_oid_index: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    pg_rewrite_rel_rulename_index: 1024 total in 1 blocks; 64 free (0 chunks); 960 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_type_typname_nsp_index: 1024 total in 1 blocks; 16 free (0 chunks); 1008 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; 1784 free (2 chunks); 1288 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_attribute_relid_attnam_index: 1024 total in 1 blocks; 64 free (0 chunks); 960 used
    pg_conversion_oid_index: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    TopMemoryContext: 181328 total in 23 blocks; 5624 free (14 chunks); 175704 used
  TopTransactionContext: 8192 total in 1 blocks; 7368 free (1 chunks); 824 used
  Prepared Queries: 24576 total in 2 blocks; 15984 free (5 chunks); 8592 used
  Record information cache: 24576 total in 2 blocks; 15984 free (5 chunks); 8592 used
  Type information cache: 24240 total in 2 blocks; 3744 free (0 chunks); 20496 used
  TableSpace cache: 8192 total in 1 blocks; 3216 free (0 chunks); 4976 used
  Operator lookup cache: 24576 total in 2 blocks; 11888 free (5 chunks); 12688 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: 57344 total in 3 blocks; 26096 free (10 chunks); 31248 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: 13576 total in 2 blocks; 208 free (0 chunks); 13368 used
      ExecutorState: 1292224 total in 30 blocks; 472896 free (0 chunks); 819328 used
        HashTableContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
          HashBatchContext: 33677360 total in 14 blocks; 7715616 free (16 chunks); 25961744 used
        HashTableContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
          HashBatchContext: 33677360 total in 14 blocks; 7715616 free (16 chunks); 25961744 used
        HashTableContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
          HashBatchContext: 50454576 total in 16 blocks; 181984 free (27 chunks); 50272592 used
        TupleSort: 53469232 total in 16 blocks; 181408 free (27 chunks); 53287824 used
        TupleSort: 32816 total in 2 blocks; 7584 free (0 chunks); 25232 used
        TupleSort: 25944112 total in 13 blocks; 7855168 free (21 chunks); 18088944 used
        HashTableContext: 67108960 total in 2 blocks; 0 free (0 chunks); 67108960 used
          HashBatchContext: 131120 total in 1 blocks; 0 free (0 chunks); 131120 used
        HashTableContext: 536871008 total in 2 blocks; 0 free (0 chunks); 536871008 used
          HashBatchContext: 65584 total in 1 blocks; 0 free (0 chunks); 65584 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
        TopMemoryContext: 137296 total in 18 blocks; 12616 free (34 chunks); 124680 used
  TopTransactionContext: 8192 total in 1 blocks; 7392 free (0 chunks); 800 used
  Prepared Queries: 24576 total in 2 blocks; 15984 free (5 chunks); 8592 used
  TableSpace cache: 8192 total in 1 blocks; 3216 free (0 chunks); 4976 used
  Operator lookup cache: 24576 total in 2 blocks; 11888 free (5 chunks); 12688 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: 24576 total in 2 blocks; 5696 free (4 chunks); 18880 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: 13680 total in 2 blocks; 152 free (0 chunks); 13528 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: 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: 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
        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
        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
        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
        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: 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: 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: 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: 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: 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: 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: 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
  Relcache by OID: 24576 total in 2 blocks; 8672 free (3 chunks); 15904 used
  CacheMemoryContext: 4844904 total in 38 blocks; 1925304 free (3 chunks); 2919600 used
    CachedPlan: 1047552 total in 10 blocks; 406304 free (0 chunks); 641248 used
    stop_point_in_journey_patterni2rid_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    stop_point_in_journey_patternentity_in_versiontechnicalid_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    stop_point_in_journey_patternentity_in_versionregionname_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    stop_point_in_journey_pattern_pkey: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    CachedPlanSource: 296200 total in 10 blocks; 115920 free (0 chunks); 180280 used
      unnamed prepared statement: 1040384 total in 7 blocks; 163368 free (7 chunks); 877016 used
    group_of_operatorsgroup_of_entitiesdata_managed_objecti2rid_ind: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    group_of_operatorsgroup_of_entitiesdata_managed_objectentity_in: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    group_of_operators_pkey: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    directiontype_of_valuedata_managed_objecti2rid_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    directiontype_of_valuedata_managed_objectentity_in_versiontechn: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    directiontype_of_valuedata_managed_objectentity_in_versionregio: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    direction_pkey: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    stop_place_entrancestop_place_componentsite_componentsite_eleme: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    stop_place_entrance_pkey: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    vehicle_journeydata_managed_objecti2rid_index: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    vehicle_journeydata_managed_objectentity_in_versiontechnicalid_: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    vehicle_journeydata_managed_objectentity_in_versionregionname_i: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    vehicle_journey_pkey: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    pg_toast_104004_index: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used
    availability_conditionvalidity_conditiontechnicalid_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    availability_conditionvalidity_conditionregionname_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    availability_condition_pkey: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    group_of_linesgroup_of_entitiesdata_managed_objecti2rid_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    group_of_linesgroup_of_entitiesdata_managed_objectentity_in_ver: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    group_of_lines_pkey: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    passenger_stop_assignmentstop_assignmentdata_managed_objecti2ri: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    passenger_stop_assignmentstop_assignmentdata_managed_objectenti: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    passenger_stop_assignment_pkey: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    pidestinationtype_of_valuedata_managed_objecti2rid_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    pidestinationtype_of_valuedata_managed_objectentity_in_versiont: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    pidestinationtype_of_valuedata_managed_objectentity_in_versionr: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    pidestination_pkey: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    purpose_of_groupingtype_of_valuedata_managed_objecti2rid_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    purpose_of_groupingtype_of_valuedata_managed_objectentity_in_ve: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    purpose_of_grouping_pkey: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    pipoint_on_routei2rid_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    pipoint_on_routeentity_in_versiontechnicalid_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    pipoint_on_routeentity_in_versionregionname_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    pipoint_on_route_pkey: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    boarding_positionstop_place_spacestop_place_componentsite_compo: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    boarding_position_pkey: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    linedata_managed_objecti2rid_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    linedata_managed_objectentity_in_versiontechnicalid_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    linedata_managed_objectentity_in_versionregionname_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    line_pkey: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    stop_placesitesite_elementplacedata_managed_objecti2rid_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    stop_placesitesite_elementplacedata_managed_objectentity_in_ver: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    stop_place_pkey: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    operatororganisationdata_managed_objecti2rid_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    operatororganisationdata_managed_objectentity_in_versiontechnic: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    operatororganisationdata_managed_objectentity_in_versionregionn: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    operator_pkey: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    journey_patterndata_managed_objecti2rid_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    journey_patterndata_managed_objectentity_in_versiontechnicalid_: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    journey_patterndata_managed_objectentity_in_versionregionname_i: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    journey_pattern_pkey: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    scheduled_boarddata_managed_objecti2rid_index: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    scheduled_boarddata_managed_objectentity_in_versiontechnicalid_: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    scheduled_boarddata_managed_objectentity_in_versionregionname_i: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    scheduled_board_pkey: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    piroutedata_managed_objecti2rid_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    piroutedata_managed_objectentity_in_versiontechnicalid_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    piroutedata_managed_objectentity_in_versionregionname_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    piroute_pkey: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    sub_linelinedata_managed_objecti2rid_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    sub_linelinedata_managed_objectentity_in_versiontechnicalid_ind: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    sub_linelinedata_managed_objectentity_in_versionregionname_inde: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    sub_line_pkey: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    access_spacestop_place_spacestop_place_componentsite_components: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    access_space_pkey: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    scheduled_stop_pointpointdata_managed_objecti2rid_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    scheduled_stop_pointpointdata_managed_objectentity_in_versionte: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    scheduled_stop_pointpointdata_managed_objectentity_in_versionre: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    scheduled_stop_point_pkey: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    CachedPlan: 15360 total in 4 blocks; 3872 free (0 chunks); 11488 used
    CachedPlanSource: 15360 total in 4 blocks; 4952 free (0 chunks); 10408 used
      CachedPlanQuery: 15360 total in 4 blocks; 6240 free (2 chunks); 9120 used
    CachedPlanSource: 130048 total in 7 blocks; 63288 free (5 chunks); 66760 used
      CachedPlanQuery: 130048 total in 7 blocks; 32392 free (1 chunks); 97656 used
    aliastechnicalid_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    aliasregionname_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    alias_pkey: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    uk_psvdjvgibm0aptute1u7aynw5: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    data_managed_object_aliases_pkey: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used
    service_calendardata_managed_objecti2rid_index: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    service_calendardata_managed_objectentity_in_versiontechnicalid: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    service_calendardata_managed_objectentity_in_versionregionname_: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    service_calendar_pkey: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    info_linki2rid_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    info_linkentity_in_versiontechnicalid_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    info_linkentity_in_versionregionname_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    info_link_pkey: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    uk_ani4kw42q0epmgn9v9jpkee4i: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    data_managed_object_info_links_pkey: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used
    timebanddata_managed_objecti2rid_index: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    timebanddata_managed_objectentity_in_versiontechnicalid_index: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    timebanddata_managed_objectentity_in_versionregionname_index: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    timeband_pkey: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    uk_htaec9svvtwm7v6e0hlm77cv: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    day_type_times_bands_pkey: 1024 total in 1 blocks; 64 free (0 chunks); 960 used
    uk_fjncd9kt20bticw3it4xx6eam: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    property_of_day_day_types_pkey: 1024 total in 1 blocks; 64 free (0 chunks); 960 used
    property_of_daydata_managed_objecti2rid_index: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    property_of_daydata_managed_objectentity_in_versiontechnicalid_: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    property_of_daydata_managed_objectentity_in_versionregionname_i: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    property_of_day_pkey: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    uk_5f81ml0p1fjk364mc6oemn8v: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    day_type_properties_of_day_pkey: 1024 total in 1 blocks; 64 free (0 chunks); 960 used
    operating_daydata_managed_objecti2rid_index: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    operating_daydata_managed_objectentity_in_versiontechnicalid_in: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    operating_daydata_managed_objectentity_in_versionregionname_ind: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    operating_day_pkey: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    uk_bks1y94pltw8oxynfcws0vk3a: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    day_type_operating_days_pkey: 1024 total in 1 blocks; 64 free (0 chunks); 960 used
    day_typedata_managed_objecti2rid_index: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    day_typedata_managed_objectentity_in_versiontechnicalid_index: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    day_typedata_managed_objectentity_in_versionregionname_index: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    day_type_pkey: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    validity_condition_day_types_pkey: 1024 total in 1 blocks; 64 free (0 chunks); 960 used
    uk_rqxle8qbcu17ubgmiwn127ct1: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    validity_conditiontechnicalid_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    validity_conditionregionname_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    validity_condition_pkey: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    source_entitytechnicalid_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    source_entityregionname_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    source_entity_pkey: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    uk_tw8ijm45c23pnc1pn68a8iix: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    entity_in_version_source_entities_pkey: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used
    quaystop_place_spacestop_place_componentsite_componentsite_elem: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    quay_pkey: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    CachedPlan: 1024 total in 1 blocks; 784 free (0 chunks); 240 used
    CachedPlanSource: 1024 total in 1 blocks; 648 free (0 chunks); 376 used
      CachedPlanQuery: 1024 total in 1 blocks; 592 free (0 chunks); 432 used
    region_pkey: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    pg_attrdef_oid_index: 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_description_o_c_o_index: 3072 total in 2 blocks; 1736 free (2 chunks); 1336 used
    CachedPlan: 7168 total in 3 blocks; 1864 free (0 chunks); 5304 used
    CachedPlan: 31744 total in 5 blocks; 9248 free (0 chunks); 22496 used
    CachedPlanSource: 3072 total in 2 blocks; 1096 free (0 chunks); 1976 used
      CachedPlanQuery: 7168 total in 3 blocks; 2352 free (1 chunks); 4816 used
    CachedPlanSource: 15360 total in 4 blocks; 4048 free (0 chunks); 11312 used
      CachedPlanQuery: 31744 total in 5 blocks; 9408 free (1 chunks); 22336 used
    pg_toast_2619_index: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used
    pg_index_indrelid_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    pg_db_role_setting_databaseid_rol_index: 1024 total in 1 blocks; 64 free (0 chunks); 960 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_class_relname_nsp_index: 1024 total in 1 blocks; 16 free (0 chunks); 1008 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_type_oid_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
    pg_aggregate_fnoid_index: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    pg_constraint_oid_index: 1024 total in 1 blocks; 200 free (0 chunks); 824 used
    pg_rewrite_rel_rulename_index: 1024 total in 1 blocks; 64 free (0 chunks); 960 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_type_typname_nsp_index: 1024 total in 1 blocks; 16 free (0 chunks); 1008 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_attribute_relid_attnam_index: 1024 total in 1 blocks; 16 free (0 chunks); 1008 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; 64 free (0 chunks); 960 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: 8192 total in 1 blocks; 2080 free (0 chunks); 6112 used
  ident parser context: 1024 total in 1 blocks; 448 free (0 chunks); 576 used
  hba parser context: 7168 total in 3 blocks; 1600 free (2 chunks); 5568 used
  LOCALLOCK hash: 57344 total in 3 blocks; 34320 free (10 chunks); 23024 used
  Timezones: 104112 total in 2 blocks; 3744 free (0 chunks); 100368 used
  ErrorContext: 8192 total in 1 blocks; 8160 free (5 chunks); 32 used
2018-03-14 14:40:26 CET [31387]: [5-1] ERROR:  53200: out of memory
2018-03-14 14:40:26 CET [31387]: [6-1] DETAIL:  Failed on request of size 1572864.
2018-03-14 14:40:26 CET [31387]: [7-1] LOCATION:  AllocSetRealloc, aset.c:973

Cordialement

gleu

Administrateur

Re : Erreur 53200 Out of Memory

Le plus grosse allocation est réalisée pour la HashTable (qui correspond à plus de la moitié de la mémoire allouée pour la requête). Le premier test que je ferais dans ce cas est de baisser la work_mem. Ça ne risque pas d'améliorer la durée d'exécution mais ça devrait au moins permettre d'exécuter la requête complètement.

---

Guillaume.

lpo77

Membre

Re : Erreur 53200 Out of Memory

Merci pour ce retour, je vais effectivement proposer cela à la MOE de cette application.

Cordialement