Drupal 8 - List all paragraphs referenced in a field and frequency used across all content types

list_paragraphs_used.php

<?php

use Drupal\paragraphs\Entity\Paragraph;

$field_name = 'field_my_field';

$query = \Drupal::entityQuery('node');
$node_ids = $query
    ->condition('status', 1)
    ->exists($field_name)
    ->execute();

$paragraphs = [];
foreach($node_ids as $node_id) {
  $node = \Drupal\node\Entity\Node::load($node_id);
  $hero_paragraphs = $node->get($field_name)->referencedEntities();
  foreach($hero_paragraphs as $parag) {
    if($parag->getParagraphType()->id) {
      array_push($paragraphs, $parag->getParagraphType()->id);
    }
  }
}

//print_r(array_unique($paragraphs));
print_r(array_count_values($paragraphs));