Re: BUG #16707: Memory leak

On Mon, Nov 09, 2020 at 04:34:33PM -0500, Tom Lane wrote:
> * look in postmaster log for memory dump

TopMemoryContext: 154592 total in 8 blocks; 40296 free (89 chunks); 114296 used
RI compare cache: 16384 total in 2 blocks; 6664 free (3 chunks); 9720 used
RI query cache: 8192 total in 1 blocks; 2624 free (0 chunks); 5568 used
RI constraint cache: 40888 total in 2 blocks; 2624 free (0 chunks); 38264 used
CFuncHash: 8192 total in 1 blocks; 560 free (0 chunks); 7632 used
Tsearch dictionary cache: 8192 total in 1 blocks; 1584 free (0 chunks); 6608 used
Tsearch parser cache: 8192 total in 1 blocks; 1584 free (0 chunks); 6608 used
Tsearch configuration cache: 8192 total in 1 blocks; 1584 free (0 chunks); 6608 used
Sequence values: 8192 total in 1 blocks; 1584 free (0 chunks); 6608 used
Btree proof lookup cache: 8192 total in 1 blocks; 560 free (0 chunks); 7632 used
HandleParallelMessages: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
Type information cache: 24352 total in 2 blocks; 2624 free (0 chunks); 21728 used
TableSpace cache: 8192 total in 1 blocks; 2096 free (0 chunks); 6096 used
Operator lookup cache: 24576 total in 2 blocks; 10760 free (3 chunks); 13816 used
RowDescriptionContext: 8192 total in 1 blocks; 6896 free (0 chunks); 1296 used
MessageContext: 8192 total in 1 blocks; 6896 free (1 chunks); 1296 used
Operator class cache: 8192 total in 1 blocks; 560 free (0 chunks); 7632 used
smgr relation table: 65536 total in 4 blocks; 16664 free (14 chunks); 48872 used
TransactionAbortContext: 32768 total in 1 blocks; 32512 free (0 chunks); 256 used
Portal hash: 8192 total in 1 blocks; 560 free (0 chunks); 7632 used
TopPortalContext: 8192 total in 1 blocks; 7936 free (1 chunks); 256 used
Relcache by OID: 32768 total in 3 blocks; 11536 free (6 chunks); 21232 used
CacheMemoryContext: 2340096 total in 18 blocks; 191496 free (53 chunks); 2148600 used
index info: 2048 total in 2 blocks; 952 free (1 chunks); 1096 used: event_push_actions_staging_id
index info: 2048 total in 2 blocks; 968 free (1 chunks); 1080 used: ev_extrem_id
index info: 2048 total in 2 blocks; 968 free (1 chunks); 1080 used: ev_extrem_room
index info: 2048 total in 2 blocks; 648 free (2 chunks); 1400 used: event_forward_extremities_event_id_room_id_key
index info: 2048 total in 2 blocks; 648 free (2 chunks); 1400 used: event_push_actions_stream_ordering
index info: 3072 total in 2 blocks; 1136 free (1 chunks); 1936 used: event_push_actions_rm_tokens
index info: 2048 total in 2 blocks; 648 free (2 chunks); 1400 used: event_push_actions_room_id_user_id
index info: 3072 total in 2 blocks; 1104 free (1 chunks); 1968 used: event_id_user_id_profile_tag_uniqueness
index info: 1024 total in 1 blocks; 48 free (0 chunks); 976 used: room_stats_historical_end_ts
index info: 2048 total in 2 blocks; 680 free (1 chunks); 1368 used: room_stats_historical_pkey
index info: 2048 total in 2 blocks; 952 free (1 chunks); 1096 used: application_services_txns_id
index info: 2048 total in 2 blocks; 648 free (2 chunks); 1400 used: application_services_txns_as_id_txn_id_key
index info: 2048 total in 2 blocks; 680 free (1 chunks); 1368 used: event_push_summary_user_rm
index info: 2048 total in 2 blocks; 952 free (1 chunks); 1096 used: presence_stream_user_id
index info: 2048 total in 2 blocks; 680 free (1 chunks); 1368 used: presence_stream_id
index info: 2048 total in 2 blocks; 952 free (1 chunks); 1096 used: device_inbox_stream_id
index info: 2048 total in 2 blocks; 624 free (1 chunks); 1424 used: device_inbox_user_stream_id
index info: 2048 total in 2 blocks; 680 free (1 chunks); 1368 used: pg_toast_2619_index
index info: 2048 total in 2 blocks; 920 free (0 chunks); 1128 used: user_directory_stream_pos_lock_key
index info: 2048 total in 2 blocks; 680 free (1 chunks); 1368 used: stream_positions_idx
index info: 2048 total in 2 blocks; 920 free (0 chunks); 1128 used: stats_incremental_position_lock_key
index info: 2048 total in 2 blocks; 952 free (1 chunks); 1096 used: room_stats_current_pkey
index info: 2048 total in 2 blocks; 952 free (1 chunks); 1096 used: application_services_state_pkey
index info: 2048 total in 2 blocks; 592 free (1 chunks); 1456 used: pg_statistic_relid_att_inh_index
index info: 2048 total in 2 blocks; 920 free (0 chunks); 1128 used: appservice_stream_position_lock_key
index info: 2048 total in 2 blocks; 648 free (2 chunks); 1400 used: federation_stream_position_instance
index info: 2048 total in 2 blocks; 952 free (1 chunks); 1096 used: users_in_public_rooms_r_idx
index info: 2048 total in 2 blocks; 680 free (1 chunks); 1368 used: users_in_public_rooms_u_idx
index info: 2048 total in 2 blocks; 952 free (1 chunks); 1096 used: user_directory_user_idx
index info: 2048 total in 2 blocks; 952 free (1 chunks); 1096 used: user_directory_room_idx
index info: 2048 total in 2 blocks; 952 free (1 chunks); 1096 used: user_directory_search_user_idx
index info: 2048 total in 2 blocks; 760 free (2 chunks); 1288 used: user_directory_search_fts_idx
index info: 2048 total in 2 blocks; 592 free (1 chunks); 1456 used: user_ips_user_token_ip_unique_index
index info: 2048 total in 2 blocks; 952 free (1 chunks); 1096 used: user_ips_last_seen_only
index info: 2048 total in 2 blocks; 680 free (1 chunks); 1368 used: user_ips_last_seen
index info: 2048 total in 2 blocks; 952 free (1 chunks); 1096 used: user_signature_stream_idx
index info: 2048 total in 2 blocks; 920 free (0 chunks); 1128 used: local_current_membership_room_idx
index info: 2048 total in 2 blocks; 680 free (1 chunks); 1368 used: local_current_membership_idx
index info: 2048 total in 2 blocks; 648 free (2 chunks); 1400 used: server_signature_keys_server_name_key_id_key
index info: 2048 total in 2 blocks; 952 free (1 chunks); 1096 used: user_stats_current_pkey
index info: 2048 total in 2 blocks; 680 free (1 chunks); 1368 used: device_uniqueness
index info: 2048 total in 2 blocks; 648 free (2 chunks); 1400 used: device_lists_remote_cache_unique_id
index info: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used: threepid_validation_token_session_id
index info: 1024 total in 1 blocks; 48 free (0 chunks); 976 used: threepid_validation_token_pkey
index info: 2048 total in 2 blocks; 952 free (1 chunks); 1096 used: destinations_pkey
index info: 2048 total in 2 blocks; 648 free (2 chunks); 1400 used: stream_ordering_to_exterm_rm_idx
index info: 2048 total in 2 blocks; 952 free (1 chunks); 1096 used: stream_ordering_to_exterm_idx
index info: 2048 total in 2 blocks; 952 free (1 chunks); 1096 used: received_transactions_ts
index info: 2048 total in 2 blocks; 648 free (2 chunks); 1400 used: received_transactions_transaction_id_origin_key
index info: 2048 total in 2 blocks; 624 free (1 chunks); 1424 used: e2e_cross_signing_keys_idx
index info: 2048 total in 2 blocks; 624 free (1 chunks); 1424 used: server_keys_json_uniqueness
index info: 1024 total in 1 blocks; 48 free (0 chunks); 976 used: monthly_active_users_time_stamp
index info: 1024 total in 1 blocks; 48 free (0 chunks); 976 used: monthly_active_users_users
index info: 2048 total in 2 blocks; 592 free (1 chunks); 1456 used: current_state_events_room_id_type_state_key_key
index info: 2048 total in 2 blocks; 920 free (0 chunks); 1128 used: current_state_events_event_id_key
index info: 2048 total in 2 blocks; 920 free (0 chunks); 1128 used: event_push_summary_stream_ordering_lock_key
index info: 2048 total in 2 blocks; 680 free (1 chunks); 1368 used: pg_toast_70339161_index
index info: 2048 total in 2 blocks; 648 free (2 chunks); 1400 used: device_federation_inbox_sender_id
index info: 2048 total in 2 blocks; 680 free (1 chunks); 1368 used: account_data_stream_id
index info: 2048 total in 2 blocks; 680 free (1 chunks); 1368 used: account_data_uniqueness
index info: 2048 total in 2 blocks; 920 free (0 chunks); 1128 used: group_attestations_renewals_v_idx
index info: 2048 total in 2 blocks; 920 free (0 chunks); 1128 used: group_attestations_renewals_u_idx
index info: 2048 total in 2 blocks; 648 free (2 chunks); 1400 used: group_attestations_renewals_g_idx
index info: 1024 total in 1 blocks; 48 free (0 chunks); 976 used: blocked_rooms_idx
index info: 1024 total in 1 blocks; 48 free (0 chunks); 976 used: ui_auth_sessions_session_id_key
index info: 1024 total in 1 blocks; 64 free (0 chunks); 960 used: room_aliases_id
index info: 1024 total in 1 blocks; 48 free (0 chunks); 976 used: room_aliases_room_alias_key
index info: 2048 total in 2 blocks; 952 free (1 chunks); 1096 used: ex_outlier_stream_pkey
index info: 3072 total in 2 blocks; 1136 free (1 chunks); 1936 used: e2e_room_keys_with_version_idx
index info: 2048 total in 2 blocks; 680 free (1 chunks); 1368 used: room_account_data_stream_id
index info: 2048 total in 2 blocks; 624 free (1 chunks); 1424 used: room_account_data_uniqueness
index info: 2048 total in 2 blocks; 952 free (1 chunks); 1096 used: user_daily_visits_ts_idx
index info: 2048 total in 2 blocks; 680 free (1 chunks); 1368 used: user_daily_visits_uts_idx
index info: 2048 total in 2 blocks; 920 free (0 chunks); 1128 used: private_user_data_max_stream_id_lock_key
index info: 2048 total in 2 blocks; 648 free (2 chunks); 1400 used: device_lists_outbound_last_success_unique_idx
index info: 2048 total in 2 blocks; 952 free (1 chunks); 1096 used: device_federation_outbox_id
index info: 2048 total in 2 blocks; 648 free (2 chunks); 1400 used: device_federation_outbox_destination_id
index info: 2048 total in 2 blocks; 920 free (0 chunks); 1128 used: device_lists_outbound_pokes_stream
index info: 2048 total in 2 blocks; 648 free (2 chunks); 1400 used: device_lists_outbound_pokes_user
index info: 2048 total in 2 blocks; 680 free (1 chunks); 1368 used: device_lists_outbound_pokes_id
index info: 2048 total in 2 blocks; 592 free (1 chunks); 1456 used: e2e_cross_signing_signatures2_idx
index info: 2048 total in 2 blocks; 952 free (1 chunks); 1096 used: user_stats_historical_end_ts
index info: 2048 total in 2 blocks; 680 free (1 chunks); 1368 used: user_stats_historical_pkey
index info: 2048 total in 2 blocks; 680 free (1 chunks); 1368 used: pg_toast_15165859_index
index info: 2048 total in 2 blocks; 968 free (1 chunks); 1080 used: event_txn_id_ts
index info: 3072 total in 2 blocks; 1136 free (1 chunks); 1936 used: event_txn_id_txn_id
index info: 2048 total in 2 blocks; 952 free (1 chunks); 1096 used: event_txn_id_event_id
index info: 1024 total in 1 blocks; 48 free (0 chunks); 976 used: remote_profile_cache_time
index info: 1024 total in 1 blocks; 48 free (0 chunks); 976 used: remote_profile_cache_user_id
TS dictionary: 1024 total in 1 blocks; 696 free (0 chunks); 328 used: simple
index info: 2048 total in 2 blocks; 952 free (1 chunks); 1096 used: event_search_event_id_idx
index info: 2048 total in 2 blocks; 952 free (1 chunks); 1096 used: event_search_ev_ridx
index info: 2048 total in 2 blocks; 760 free (2 chunks); 1288 used: event_search_fts_idx
TS dictionary: 8192 total in 4 blocks; 2864 free (9 chunks); 5328 used: english_stem
index info: 2048 total in 2 blocks; 624 free (1 chunks); 1424 used: room_tag_uniqueness
index info: 2048 total in 2 blocks; 952 free (1 chunks); 1096 used: profiles_user_id_key
index info: 2048 total in 2 blocks; 680 free (1 chunks); 1368 used: e2e_device_keys_json_uniqueness
index info: 3072 total in 2 blocks; 984 free (1 chunks); 2088 used: remote_media_repository_thumbn_media_origin_id_width_height_met
index info: 3072 total in 2 blocks; 1048 free (1 chunks); 2024 used: remote_media_cache_thumbnails_media_origin_media_id_thumbna_key
index info: 2048 total in 2 blocks; 680 free (1 chunks); 1368 used: e2e_room_keys_versions_idx
150 more child contexts containing 287744 total in 275 blocks; 108096 free (155 chunks); 179648 used
WAL record construction: 49768 total in 2 blocks; 6368 free (0 chunks); 43400 used
PrivateRefCount: 8192 total in 1 blocks; 2624 free (0 chunks); 5568 used
MdSmgr: 32768 total in 3 blocks; 19048 free (15 chunks); 13720 used
LOCALLOCK hash: 32768 total in 3 blocks; 16832 free (8 chunks); 15936 used
Timezones: 104120 total in 2 blocks; 2624 free (0 chunks); 101496 used
ErrorContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
Grand total: 3575000 bytes in 533 blocks; 596232 free (450 chunks); 2978768 used

Which was for this process:
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
postgres 10000 2.6 16.3 5547172 5374656 ? Ss Nov08 54:10 postgres: synapse synapse [local] idle

Kurt