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