44 Heb “Who [is there] for me in heaven? And besides you I do not desire [anyone] in the earth.” The psalmist uses a merism (heaven/earth) to emphasize that God is the sole object of his desire and worship in the entire universe.
45 The Hebrew verb כָלָה (khalah, “to fail; to grow weak”) does not refer here to physical death per se, but to the physical weakness that sometimes precedes death (see Job 33:21; Pss 71:9; 143:7; Prov 5:11).
46 Or “forever.”
47 Heb “is the rocky summit of my heart and my portion.” The psalmist compares the Lord to a rocky summit where one could go for protection and to landed property, which was foundational to economic stability in ancient Israel.
48 Or “for.”
49 The following line defines the phrase far from you in a spiritual sense. Those “far” from God are those who are unfaithful and disloyal to him.
50 Heb “everyone who commits adultery from you.”
51 Heb “but as for me, the nearness of God for me [is] good.”
52 The infinitive construct with -לְ (lé) is understood here as indicating an attendant circumstance. Another option is to take it as indicating purpose (“so that I might declare”) or result (“with the result that I declare”).

In other versions

ESVEnglish Standard Version

Whom have I in heaven but you?

And there is nothing on earth that I desire besides you.

My flesh and my heart may fail,

but God is the strength of my heart and my portion forever.

For behold, those who are far from you shall perish;

you put an end to everyone who is unfaithful to you.

But for me it is good to be near God;

I have made the Lord God my refuge,

that I may tell of all your works.

NIVNew International Version (2011)

Whom have I in heaven but you?

And earth has nothing I desire besides you.

My flesh and my heart may fail,

but God is the strength of my heart

and my portion forever.

Those who are far from you will perish;

you destroy all who are unfaithful to you.

But as for me, it is good to be near God.

I have made the Sovereign Lord my refuge;

I will tell of all your deeds.

CSBChristian Standard Bible

Who do I have in heaven but you?

And I desire nothing on earth but you.

My flesh and my heart may fail,

but God is the strength of my heart,

my portion forever.

Those far from you will certainly perish;

you destroy all who are unfaithful to you.

But as for me, God’s presence is my good.

I have made the Lord God my refuge,

so I can tell about all you do.

NLTNew Living Translation

Whom have I in heaven but you?

I desire you more than anything on earth.

My health may fail, and my spirit may grow weak,

but God remains the strength of my heart;

he is mine forever.

Those who desert him will perish,

for you destroy those who abandon you.

But as for me, how good it is to be near God!

I have made the Sovereign Lord my shelter,

and I will tell everyone about the wonderful things you do.

LEBThe Lexham English Bible

Whom do I have in the heavens except you?

And with you I have no other desire on earth.

My flesh and heart failed,

but God is the strength of my heart and my reward forever.

For indeed, those distancing themselves from you will be ruined.

You destroy each who abandons you for harlotry.

But as for me, the approach to God is for my good.

I have set the Lord Yahweh as my refuge,

in order to tell all your works.

KJV 1900King James Version

Whom have I in heaven but thee?

And there is none upon earth that I desire beside thee.

My flesh and my heart faileth:

But God is the strength of my heart, and my portion for ever.

For, lo, they that are far from thee shall perish:

Thou hast destroyed all them that go a whoring from thee.

But it is good for me to draw near to God:

I have put my trust in the Lord God,

That I may declare all thy works.

Public Domain