Vous n'êtes pas identifié(e).
Pages : 1
Bonsoir,
merci pour cette information
Cordialement
Lucien
Merci pour votre retour
avez-vous une idée pour avoir des informations complémentaires (élever le niveau de trace de la base ...) ?
Cordialement
Lucien
Bonjour,
nous avons de façon récurrente les erreurs suivantes
2018-04-23 21:42:47 CEST [31826]:[1]ERROR: 08P01: invalid string in message
2018-04-23 21:42:47 CEST [31826]:[2]LOCATION: pq_getmsgstring, pqformat.c:691
2018-04-23 21:42:47 CEST [31826]:[3]FATAL: 08P01: invalid frontend message type 0
2018-04-23 21:42:47 CEST [31826]:[4]LOCATION: SocketBackend, postgres.c:419
dans le fichier de log de notre base postgresql
comment peut-on identifier la cause ?
notre base est en version 8.4.16 elle est hébergée sur OS Linux RHEL 6.3
Cordialement
Merci pour ce retour, je vais effectivement proposer cela à la MOE de cette application.
Cordialement
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
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
Pages : 1
