The best metaphors I've read is in Bird by Bird. The author describes two different scenarios.
The first is that perfection & progress is much like driving late at night with headlights. You will only be able to see as far as your headlights allow. You might be going through a canyon, on a straight and narrow highway, or going the wrong way. But all you know for certain is what is in front of you.
The second is that you have to frame your perfectionism around something. That could be your loved ones, your dreams in life, whatever. If it's always framed around your past achievements, you're comparing to the past and not to the future version of what could be. Getting clear on why you're doing it is very important.
I truly believe you can devoid yourself of perfectionism. I've gone from being afraid to publish work to the public, to only publishing in the public and shaping my work based on the imperfections being pointed out in my shitty first attempts.
Your first attempt will be shitty. Your second attempt will be less shitty. Do this for long enough and you'll start to get a feel for proficiency and what others see as "perfection".