Skip to content

Instantly share code, notes, and snippets.

@jcjones
Created February 21, 2016 04:49
Show Gist options
  • Save jcjones/947ac15de9f308db6ea8 to your computer and use it in GitHub Desktop.
Save jcjones/947ac15de9f308db6ea8 to your computer and use it in GitHub Desktop.
How many DNS Names are, on average, in each certificate issued by Let's Encrypt?
SELECT
AVG(count)
FROM
(SELECT
c.certID,
(SELECT
COUNT(n.name)
FROM
name AS n
WHERE
n.certID = c.certID) AS count
FROM
le_current_certificate AS c) AS a;
We can make this file beautiful and searchable if this error is corrected: No tabs found in this TSV file in line 0.
AVG(count)
3.7804
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment