HTML tags used in my blog entries

Owned by simonw, visibility: Public

SQL query
WITH tags AS (
    SELECT
        (regexp_matches(body, '<(\w+)[^>]*>', 'g'))[1] AS tag
    FROM blog_entry
)
SELECT
    tag,
    COUNT(*) AS count
FROM tags
GROUP BY tag
ORDER BY count DESC

63 rows

tag count
span 31148
p 29632
a 23646
code 8022
li 6572
h4 2421
pre 2272
em 2169
strong 2142
div 1946
img 1730
acronym 1595
blockquote 1548
ul 1442
td 1014
br 1006
sub 381
h3 367
tr 335
samp 161
ol 150
dd 118
dt 118
th 114
dfn 94
q 92
iframe 59
sup 38
table 33
tbody 31
thead 30
dl 26
h2 26
kbd 22
cite 21
figure 20
b 19
lite 19
source 19
figcaption 17
g 17
ins 15
i 12
video 11
hr 10
button 10
h5 9
audio 8
del 8
param 4
object 2
s 2
summary 2
small 2
details 2
picture 2
abbr 1
caption 1
var 1
center 1
style 1
embed 1
script 1
Copy and export data

Duration: 284.69ms