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 30845
p 29113
a 23355
code 7911
li 6489
h4 2366
pre 2239
em 2134
strong 2092
div 1881
img 1686
acronym 1595
blockquote 1500
ul 1430
br 1006
td 974
sub 381
h3 367
tr 325
samp 161
ol 142
dd 118
dt 118
th 104
dfn 94
q 92
iframe 59
sup 38
table 31
tbody 29
thead 28
dl 26
h2 26
kbd 22
cite 21
figure 20
b 19
source 19
figcaption 17
g 17
lite 16
ins 15
i 12
video 11
button 10
hr 10
h5 9
del 8
audio 8
param 4
object 2
summary 2
small 2
details 2
picture 2
abbr 1
s 1
caption 1
var 1
center 1
style 1
script 1
embed 1
Copy and export data

Duration: 268.32ms