Vous n'êtes pas identifié(e).
Pages : 1
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
Hors ligne
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.
Hors ligne
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.
Hors ligne
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
Hors ligne
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.
Hors ligne
Merci pour ce retour, je vais effectivement proposer cela à la MOE de cette application.
Cordialement
Hors ligne
Pages : 1
