Skip to content

Instantly share code, notes, and snippets.

@lahwaacz
Last active June 15, 2021 13:41
Show Gist options
  • Save lahwaacz/deec40be335a0ba623bac066184bcf4d to your computer and use it in GitHub Desktop.
Save lahwaacz/deec40be335a0ba623bac066184bcf4d to your computer and use it in GitHub Desktop.
Largest manual pages in Arch Linux
manpages=# select name, section, lang, length(raw) as bytes_raw, length(txt) as bytes_txt from archmanweb_manpage join archmanweb_content on content_id = archmanweb_content.id order by bytes_raw desc limit 50;
name | section | lang | bytes_raw | bytes_txt
-----------------------------+---------+------+-----------+-----------
salt | 7 | en | 14814797 | 15403125
Image::ExifTool::TagNames | 3pm | en | 1944720 | 1973904
ffmpeg-all | 1 | en | 1698774 | 1496318
lapacke.h | 3 | en | 1560412 | 1411064
arm-none-eabi-gcc | 1 | en | 1401061 | 1310444
arm-none-eabi-g++ | 1 | en | 1401061 | 1310444
gcc | 1 | en | 1401061 | 1310444
g++ | 1 | en | 1401061 | 1310444
aarch64-linux-gnu-g++ | 1 | en | 1401059 | 1310442
aarch64-linux-gnu-gcc | 1 | en | 1401059 | 1310442
avr-gcc | 1 | en | 1401059 | 1310442
avr-g++ | 1 | en | 1401059 | 1310442
ffprobe-all | 1 | en | 1353123 | 1184451
rclone | 1 | en | 1349140 | 1385201
ffplay-all | 1 | en | 1342158 | 1173259
lm32-elf-g++ | 1 | en | 1331927 | 1242820
or1k-elf-gcc | 1 | en | 1331927 | 1242820
nds32le-elf-g++ | 1 | en | 1331927 | 1242820
lm32-elf-gcc | 1 | en | 1331927 | 1242820
riscv64-elf-gcc | 1 | en | 1331927 | 1242820
riscv64-elf-g++ | 1 | en | 1331927 | 1242820
nds32le-elf-gcc | 1 | en | 1331927 | 1242820
or1k-elf-g++ | 1 | en | 1331927 | 1242820
riscv64-linux-gnu-gcc | 1 | en | 1331925 | 1242818
riscv64-linux-gnu-g++ | 1 | en | 1331925 | 1242818
perltoc | 1perl | en | 1320490 | 716509
lapack.h | 3 | en | 1162618 | 1037563
perlapi | 1perl | en | 923032 | 705584
ffmpeg-filters | 1 | en | 892565 | 811383
cabal | 1 | en | 849824 | 1110017
cmake-modules | 7 | en | 746111 | 799351
guestfs | 3 | en | 740703 | 677277
mpv | 1 | en | 708719 | 819373
doubleOTHERcomputational | 3 | en | 604824 | 669960
complexOTHERcomputational | 3 | en | 603863 | 669983
complex16OTHERcomputational | 3 | en | 596138 | 661153
postconf | 5 | en | 595055 | 645211
extraclangtools | 1 | en | 588962 | 671798
pysnmp | 1 | en | 568601 | 611275
python-pysnmp | 1 | en | 568601 | 611275
qemu-qmp-ref | 7 | en | 541401 | 549896
qemu-qmp-ref | 7 | en | 541401 | 549896
scons | 1 | en | 526334 | 612962
realOTHERcomputational | 3 | en | 515569 | 571453
cmake-commands | 7 | en | 486553 | 493249
hg | 1 | en | 479830 | 504529
perluniprops | 1perl | en | 475834 | 493321
smb.conf | 5 | en | 446222 | 446881
mail | 1 | en | 444475 | 521398
perlfunc | 1perl | en | 443433 | 425688
(50 rows)
manpages=# select name, section, lang, length(raw) as bytes_raw, length(txt) as bytes_txt from archmanweb_manpage join archmanweb_content on content_id = archmanweb_content.id where txt is not null order by bytes_txt desc limit 50;
name | section | lang | bytes_raw | bytes_txt
-----------------------------+---------+------+-----------+-----------
salt | 7 | en | 14814797 | 15403125
Image::ExifTool::TagNames | 3pm | en | 1944720 | 1973904
zshall | 1 | en | 20091 | 1583867
ffmpeg-all | 1 | en | 1698774 | 1496318
lapacke.h | 3 | en | 1560412 | 1411064
rclone | 1 | en | 1349140 | 1385201
g++ | 1 | en | 1401061 | 1310444
arm-none-eabi-g++ | 1 | en | 1401061 | 1310444
gcc | 1 | en | 1401061 | 1310444
arm-none-eabi-gcc | 1 | en | 1401061 | 1310444
avr-gcc | 1 | en | 1401059 | 1310442
aarch64-linux-gnu-g++ | 1 | en | 1401059 | 1310442
aarch64-linux-gnu-gcc | 1 | en | 1401059 | 1310442
avr-g++ | 1 | en | 1401059 | 1310442
nds32le-elf-g++ | 1 | en | 1331927 | 1242820
lm32-elf-g++ | 1 | en | 1331927 | 1242820
or1k-elf-gcc | 1 | en | 1331927 | 1242820
riscv64-elf-g++ | 1 | en | 1331927 | 1242820
or1k-elf-g++ | 1 | en | 1331927 | 1242820
nds32le-elf-gcc | 1 | en | 1331927 | 1242820
riscv64-elf-gcc | 1 | en | 1331927 | 1242820
lm32-elf-gcc | 1 | en | 1331927 | 1242820
riscv64-linux-gnu-g++ | 1 | en | 1331925 | 1242818
riscv64-linux-gnu-gcc | 1 | en | 1331925 | 1242818
ffprobe-all | 1 | en | 1353123 | 1184451
ffplay-all | 1 | en | 1342158 | 1173259
cabal | 1 | en | 849824 | 1110017
lapack.h | 3 | en | 1162618 | 1037563
mpv | 1 | en | 708719 | 819373
ffmpeg-filters | 1 | en | 892565 | 811383
cmake-modules | 7 | en | 746111 | 799351
perltoc | 1perl | en | 1320490 | 716509
perlapi | 1perl | en | 923032 | 705584
guestfs | 3 | en | 740703 | 677277
extraclangtools | 1 | en | 588962 | 671798
complexOTHERcomputational | 3 | en | 603863 | 669983
doubleOTHERcomputational | 3 | en | 604824 | 669960
complex16OTHERcomputational | 3 | en | 596138 | 661153
postconf | 5 | en | 595055 | 645211
scons | 1 | en | 526334 | 612962
pysnmp | 1 | en | 568601 | 611275
python-pysnmp | 1 | en | 568601 | 611275
realOTHERcomputational | 3 | en | 515569 | 571453
qemu-qmp-ref | 7 | en | 541401 | 549896
qemu-qmp-ref | 7 | en | 541401 | 549896
mail | 1 | en | 444475 | 521398
hg | 1 | en | 479830 | 504529
perluniprops | 1perl | en | 475834 | 493321
cmake-commands | 7 | en | 486553 | 493249
mencoder | 1 | it | 387163 | 492077
(50 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment