I am raising an issue because Dan said I had to.

ibara commented 6 years ago

From #devious:

21:33 <@bcallah> congrats FreeBSD team for importing 10% of your entire ports tree in the last 24 hours
21:33 <@bcallah> FreshPorts.org reports FreeBSD has 3180 new ports in the last 24 hours
21:33 <@bcallah> There are 31855 FreeBSD ports total.
21:34 < dvl> DO YOU DOUBT IT?
21:34 <@bcallah> nope, I'm congratulating them on a lot of hard work :)
21:34 <@bcallah> lol do you have a script that pings you whenever freshports is mentioned? :)
21:34 < dvl> I SEE EVERYTHING EVERYWHERE.
21:35 < dvl> Perhaps Add PHP 7.2 RC6 contributed somewhat.
21:35 <@bcallah> I buy that
21:35 <@bcallah> yeah no kidding, I'm looking at the list now
21:36 <@bcallah> I guess all the jokes about PHP are becoming more true by the day...
21:36 < dvl> It's also on multiple branches and I think thatpage is reporting them all without distinction.  Please raise an issue and I will 
             fix it.  Sorry, in the middle of scripting.

dlangille commented 6 years ago

thank you.

dlangille commented 5 years ago

There are a bunch of functions which need adjustment to work only on HEAD. For example:

CREATE OR REPLACE FUNCTION Stats_PortCount() returns int8 AS $$
        DECLARE
                PortCount       int8;

        BEGIN
                SELECT count(*)
                  INTO PortCount
                  FROM ports, element
                 WHERE element.status = 'A'
                   AND ports.element_id = element.id;

                return PortCount;
        END
$$ LANGUAGE 'plpgsql';

dlangille commented 5 years ago

The code appears correct for some counts, such as past 24 hours.

However, I noticed the cache file has not been updated recently:

[dan@x8dtu-nginx01:/var/db/freshports/cache/html] $ ls -l
total 10
-rw-r--r--  1 freshports  freshports     9 Oct  3 04:01 PortsTreeCount
-rw-rw-r--  1 freshports  freshports  2200 Oct  1 15:01 stats.html
-rw-rw-r--  1 freshports  freshports  2593 Oct  3 13:47 vuln-latest.html
-rw-r--r--  1 freshports  freshports    76 Oct  3 13:47 vuxml_revision

stats.html should be updated hourly. It is two days old.

dlangille commented 5 years ago

That file is generated by hourly_stats.pl:

[dan@pro02:~/src/freshports/scripts] $ grep -r stats.html *
hourly_stats.pl:        print "renaming '$OutputFile' to '$OutputFileDir/stats.html'\n";
hourly_stats.pl:        rename "$OutputFile", "$OutputFileDir/stats.html";

That script is invoked by this periodic:

[dan@x8dtu-nginx01:/usr/local/etc/periodic/hourly] $ grep hourly_stats.pl *
180.fp_stats_hourly:    echo "cd $fp_scripts_dir && /usr/local/bin/perl hourly_stats.pl > /dev/null" | su -fm $fp_freshports_user || rc=3

That periodic is enabled:

[dan@x8dtu-ingress01:/var/db/freshports/cache/html] $ grep fp_stats_hourly_enable /etc/periodic.conf
fp_stats_hourly_enable="YES"

NOTE: the file is generated in the ingress01 jail. That directory is mounted read-only by the nginx01 jail.

dlangille commented 5 years ago

If I invoke the script manually, it creates the file:

[root@dev-ingress01:/var/db/freshports/cache/html] # ls -l
total 26
-rw-r--r--  1 freshports  freshports     9 Oct  3 03:08 PortsTreeCount
-rw-rw-r--  1 freshports  freshports  2593 Oct  3 13:47 vuln-latest.html
-rw-r--r--  1 freshports  freshports    76 Oct  3 13:47 vuxml_revision
[root@dev-ingress01:/var/db/freshports/cache/html] # /usr/local/etc/periodic/hourly/180.fp_stats_hourly
[root@dev-ingress01:/var/db/freshports/cache/html] # ls -l
total 26
-rw-r--r--  1 freshports  freshports     9 Oct  3 03:08 PortsTreeCount
-rw-rw-r--  1 freshports  freshports  2197 Oct  3 14:49 stats.html
-rw-rw-r--  1 freshports  freshports  2593 Oct  3 13:47 vuln-latest.html
-rw-r--r--  1 freshports  freshports    76 Oct  3 13:47 vuxml_revision
[root@dev-ingress01:/var/db/freshports/cache/html] #

dlangille commented 5 years ago

found it. No periodic hourly crontab entry. For shame!~

[root@dev-ingress01:/usr/local/etc/periodic/hourly] # grep periodic /etc/crontab 
1   3   *   *   *   root    periodic daily
15  4   *   *   6   root    periodic weekly
30  5   1   *   *   root    periodic monthly

dlangille commented 5 years ago

I noticed this crontab entry was in place on prod (x8dtu-ingress01) and was running:

[dan@x8dtu-ingress01:/var/db/freshports/cache/html] $ sudo grep hourly /var/log/cron
Oct  3 00:01:03 x8dtu-ingress01 /usr/sbin/cron[66030]: (root) CMD (periodic hourly)
Oct  3 01:01:09 x8dtu-ingress01 /usr/sbin/cron[98053]: (root) CMD (periodic hourly)
Oct  3 02:01:01 x8dtu-ingress01 /usr/sbin/cron[33099]: (root) CMD (periodic hourly)
Oct  3 03:01:10 x8dtu-ingress01 /usr/sbin/cron[64083]: (root) CMD (periodic hourly)
Oct  3 04:01:11 x8dtu-ingress01 /usr/sbin/cron[96367]: (root) CMD (periodic hourly)
Oct  3 05:01:14 x8dtu-ingress01 /usr/sbin/cron[27090]: (root) CMD (periodic hourly)
Oct  3 06:01:13 x8dtu-ingress01 /usr/sbin/cron[57054]: (root) CMD (periodic hourly)
Oct  3 07:01:12 x8dtu-ingress01 /usr/sbin/cron[87170]: (root) CMD (periodic hourly)
Oct  3 08:01:09 x8dtu-ingress01 /usr/sbin/cron[18259]: (root) CMD (periodic hourly)
Oct  3 09:01:09 x8dtu-ingress01 /usr/sbin/cron[50268]: (root) CMD (periodic hourly)
Oct  3 10:01:00 x8dtu-ingress01 /usr/sbin/cron[82280]: (root) CMD (periodic hourly)
Oct  3 11:01:10 x8dtu-ingress01 /usr/sbin/cron[13585]: (root) CMD (periodic hourly)
Oct  3 12:01:06 x8dtu-ingress01 /usr/sbin/cron[50638]: (root) CMD (periodic hourly)
Oct  3 13:01:00 x8dtu-ingress01 /usr/sbin/cron[96353]: (root) CMD (periodic hourly)
Oct  3 14:01:06 x8dtu-ingress01 /usr/sbin/cron[27927]: (root) CMD (periodic hourly)
Oct  3 15:01:07 x8dtu-ingress01 /usr/sbin/cron[61934]: (root) CMD (periodic hourly)

But still, that file is not being created.

dlangille commented 5 years ago

This is the current timetable:

# grep periodic /etc/crontab 
0   *   *   *   *   root    periodic hourly
1   3   *   *   *   root    periodic daily
15  4   *   *   6   root    periodic weekly
30  5   1   *   *   root    periodic monthly

Prod was scheduled at 1, now at 0

dlangille commented 5 years ago

Well, this might be the reason why it does not run on prod:

[root@x8dtu-ingress01 /var/db/freshports/cache/html]# /usr/local/etc/periodic/hourly/180.fp_stats_hourly 
DBI connect('dbname=freshports.org;host=127.1.0.203;sslmode=require','reading',...) failed: fe_sendauth: no password supplied at /usr/local/lib/perl5/site_perl/FreshPorts/database.pm line 47.
Can't call method "prepare" on unblessed reference at hourly_stats.pl line 46.
[root@x8dtu-ingress01 /var/db/freshports/cache/html]#

dlangille commented 5 years ago

Well, this is not useful:

$FreshPorts::Config::password_readonly = '';

dlangille commented 5 years ago

PostgreSQL password was update to reflect what is in my password manager
~freshports/.pgpass was updated to use a wildcard for the host and use the password from above

Now the script runs:

[root@x8dtu-ingress01 /usr/local/etc/freshports]# ls -l ~freshports/cache/html/
total 10
-rw-r--r--  1 freshports  freshports     9 Oct  3 04:01 PortsTreeCount
-rw-rw-r--  1 freshports  freshports  2197 Oct  3 15:26 stats.html
-rw-rw-r--  1 freshports  freshports  2593 Oct  3 13:47 vuln-latest.html
-rw-r--r--  1 freshports  freshports    76 Oct  3 13:47 vuxml_revision
[root@x8dtu-ingress01 /usr/local/etc/freshports]#

I will check back after the top of the hour.

dlangille commented 5 years ago

Success on this host:

[dan@x8dtu-ingress01:/var/db/freshports/cache/html] $ ls -l
total 10
-rw-r--r--  1 freshports  freshports     9 Oct  3 04:01 PortsTreeCount
-rw-rw-r--  1 freshports  freshports  2197 Oct  3 16:00 stats.html
-rw-rw-r--  1 freshports  freshports  2593 Oct  3 13:47 vuln-latest.html
-rw-r--r--  1 freshports  freshports    76 Oct  3 13:47 vuxml_revision
[dan@x8dtu-ingress01:/var/db/freshports/cache/html] $ date
Wed Oct  3 16:17:33 UTC 2018
[dan@x8dtu-ingress01:/var/db/freshports/cache/html] $

dlangille commented 5 years ago

So... It appears fixed. Does OP agree?

ibara commented 5 years ago

A quick glance suggests that things are at least partially fixed. And now is a good time to be looking all this over, as it looks like PHP 7.3 has recently been imported.

The right-side panel says there have been 7026 new ports this month, which seems high. However, once you click on that, the new page you get says there are 219 new ports this month, which totally makes sense to me and the list of ports indeed has no duplicates, so this part is definitely fixed.

dlangille commented 5 years ago

The code used to get a total is incorrect. Let's try a simple approach:

freshports.dev=#   SELECT P.element_id, element_pathname(element_id)
freshports.dev-#     FROM ports P
freshports.dev-#    WHERE P.date_added > now() - '1 month'::interval
freshports.dev-# ORDER BY P.date_added DESC;
 element_id |                           element_pathname                           
------------+----------------------------------------------------------------------
     902624 | /ports/head/devel/pecl-xdebug-devel
     902622 | /ports/head/devel/pecl-xdebug25
     902605 | /ports/head/security/py-bro-pkg
     902589 | /ports/branches/2018Q4/graphics/sam2p
     902585 | /ports/head/textproc/hs-parsec-numbers
     902573 | /ports/head/x11-fonts/materialdesign-ttf
     902571 | /ports/branches/2018Q4/security/revelation
     902560 | /ports/head/math/primme
     902554 | /ports/branches/2018Q4/graphics/mupdf
     902550 | /ports/head/devel/py-pylibsrtp
     902546 | /ports/head/devel/py-aioice
     902542 | /ports/head/multimedia/py-av
     902535 | /ports/branches/2018Q4/devel/git-subversion
     902529 | /ports/branches/2018Q4/devel/git-gui
     902532 | /ports/branches/2018Q4/devel/git-lite
     902525 | /ports/branches/2018Q4/devel/git
     902514 | /ports/branches/2018Q4/net/samba46
     902518 | /ports/branches/2018Q4/net/samba47
     902510 | /ports/branches/2018Q4/math/py-graphillion
     902505 | /ports/branches/2018Q4/comms/hylafax
     902360 | /ports/head/converters/php73-iconv
     902378 | /ports/head/devel/php73-json
     902410 | /ports/head/textproc/php73-pspell
     902407 | /ports/head/textproc/php73-ctype
     902416 | /ports/head/textproc/php73-xsl
     902392 | /ports/head/mail/php73-imap
     902398 | /ports/head/net/php73-soap
     902399 | /ports/head/net/php73-sockets
     902411 | /ports/head/textproc/php73-simplexml
     902404 | /ports/head/security/php73-sodium
     902419 | /ports/head/www/php73-session
     902415 | /ports/head/textproc/php73-xmlwriter
     902366 | /ports/head/databases/php73-odbc
     902388 | /ports/head/graphics/php73-exif
     902357 | /ports/head/archivers/php73-phar
     902381 | /ports/head/devel/php73-shmop
     902417 | /ports/head/www/mod_php73
     902414 | /ports/head/textproc/php73-xmlreader
     902391 | /ports/head/lang/php73-extensions
     902356 | /ports/head/archivers/php73-bz2
     902401 | /ports/head/security/php73-filter
     902420 | /ports/head/www/php73-tidy
     902390 | /ports/head/lang/php73
     902409 | /ports/head/textproc/php73-enchant
     902383 | /ports/head/devel/php73-sysvsem
     902400 | /ports/head/net/php73-xmlrpc
     902364 | /ports/head/databases/php73-interbase
     902385 | /ports/head/devel/php73-tokenizer
     902371 | /ports/head/databases/php73-pdo_odbc
     902384 | /ports/head/devel/php73-sysvshm
     902418 | /ports/head/www/php73-opcache
     902403 | /ports/head/security/php73-openssl
     902402 | /ports/head/security/php73-hash
     902389 | /ports/head/graphics/php73-gd
     902387 | /ports/head/ftp/php73-ftp
     902393 | /ports/head/math/php73-bcmath
     902405 | /ports/head/sysutils/php73-fileinfo
     902375 | /ports/head/databases/php73-sqlite3
     902379 | /ports/head/devel/php73-pcntl
     902377 | /ports/head/devel/php73-intl
     902412 | /ports/head/textproc/php73-wddx
     902361 | /ports/head/converters/php73-mbstring
     902395 | /ports/head/misc/php73-calendar
     902373 | /ports/head/databases/php73-pdo_sqlite
     902386 | /ports/head/ftp/php73-curl
     902374 | /ports/head/databases/php73-pgsql
     902363 | /ports/head/databases/php73-dba
     902370 | /ports/head/databases/php73-pdo_mysql
     902358 | /ports/head/archivers/php73-zip
     902372 | /ports/head/databases/php73-pdo_pgsql
     902397 | /ports/head/net/php73-ldap
     902362 | /ports/head/converters/php73-recode
     902368 | /ports/head/databases/php73-pdo_dblib
     902413 | /ports/head/textproc/php73-xml
     902406 | /ports/head/sysutils/php73-posix
     902394 | /ports/head/math/php73-gmp
     902369 | /ports/head/databases/php73-pdo_firebird
     902396 | /ports/head/net-mgmt/php73-snmp
     902382 | /ports/head/devel/php73-sysvmsg
     902367 | /ports/head/databases/php73-pdo
     902380 | /ports/head/devel/php73-readline
     902359 | /ports/head/archivers/php73-zlib
     902376 | /ports/head/devel/php73-gettext
     902408 | /ports/head/textproc/php73-dom
     902365 | /ports/head/databases/php73-mysqli
     902325 | /ports/head/biology/ncbi-cxx-toolkit
     902320 | /ports/head/science/simint
     902315 | /ports/head/deskutils/qownnotes
     902311 | /ports/head/science/molgif
     902306 | /ports/branches/2018Q4/multimedia/mjpegtools
     902298 | /ports/head/java/jdk10-doc
     902296 | /ports/branches/2018Q4/multimedia/libfame
     902288 | /ports/head/devel/py-deepdiff
     902282 | /ports/head/math/py-gau2grid
     902279 | /ports/branches/2018Q4/net/tcpflow
     902275 | /ports/head/devel/py-jsonpickle
     902262 | /ports/head/science/tinker
     902259 | /ports/branches/2018Q4/net/openafs
     902257 | /ports/head/net-p2p/py-libtorrent-rasterbar
     902244 | /ports/branches/2018Q4/databases/cockroach
     902233 | /ports/head/security/cargo-audit
     902227 | /ports/head/devel/rubygem-c21e
     902223 | /ports/head/devel/rubygem-cucumber-formatter-dots
     902219 | /ports/head/devel/rubygem-cucumber-messages
     902214 | /ports/head/editors/gnome-latex
     902210 | /ports/head/devel/coursier
     902203 | /ports/head/devel/libb2
     902196 | /ports/head/devel/py-libiocage
     902192 | /ports/head/devel/sccache
     902189 | /ports/head/sysutils/u-boot-pinebook
     902182 | /ports/branches/2018Q4/news/nzbget
     902175 | /ports/branches/2018Q4/databases/percona57-client
     902171 | /ports/branches/2018Q4/security/clamav-milter
     902168 | /ports/branches/2018Q4/security/clamav
     902165 | /ports/branches/2018Q4/security/strongswan
     902147 | /ports/head/net-mgmt/zabbix4-frontend
     902150 | /ports/head/net-mgmt/zabbix4-server
     902146 | /ports/head/net-mgmt/zabbix4-agent
     902149 | /ports/head/net-mgmt/zabbix4-proxy
     902148 | /ports/head/net-mgmt/zabbix4-java
     902135 | /ports/head/math/adol-c
     902130 | /ports/head/x11-fonts/psftools
     902126 | /ports/head/math/nanoflann
     902123 | /ports/branches/2018Q4/graphics/minder
     902118 | /ports/branches/2018Q4/net/traefik
     902092 | /ports/branches/2018Q4/www/py-django21
     902081 | /ports/branches/2018Q4/net-mgmt/monitoring-plugins
     902072 | /ports/head/math/deal.ii
     902065 | /ports/head/sysutils/stepsync
     902060 | /ports/head/sysutils/dwatch-json
     902057 | /ports/branches/2018Q4/net/librdkafka
     901988 | /ports/branches/2018Q4/mail/claws-mail-bsfilter
     902029 | /ports/branches/2018Q4/mail/claws-mail-pgp
     902024 | /ports/branches/2018Q4/mail/claws-mail-spamreport
     902019 | /ports/branches/2018Q4/mail/claws-mail-vcalendar
     902016 | /ports/branches/2018Q4/mail/claws-mail-address_keeper
     902013 | /ports/branches/2018Q4/mail/claws-mail-python
     902007 | /ports/branches/2018Q4/mail/claws-mail-fancy
     902004 | /ports/branches/2018Q4/mail/claws-mail-attach_warner
     902001 | /ports/branches/2018Q4/mail/claws-mail-managesieve
     901998 | /ports/branches/2018Q4/mail/claws-mail-pdf_viewer
     901994 | /ports/branches/2018Q4/mail/claws-mail-newmail
     901991 | /ports/branches/2018Q4/mail/claws-mail-libravatar
     901985 | /ports/branches/2018Q4/mail/claws-mail-fetchinfo
     901982 | /ports/branches/2018Q4/mail/claws-mail-gdata
     901979 | /ports/branches/2018Q4/mail/claws-mail-tnef
     901976 | /ports/branches/2018Q4/mail/claws-mail-mailmbox
     901972 | /ports/branches/2018Q4/mail/claws-mail-notification
     901969 | /ports/branches/2018Q4/mail/claws-mail-perl
     901966 | /ports/branches/2018Q4/mail/claws-mail-att_remover
     901962 | /ports/branches/2018Q4/mail/claws-mail-rssyl
     901959 | /ports/branches/2018Q4/mail/claws-mail-bogofilter
     901956 | /ports/branches/2018Q4/mail/claws-mail-spamassassin
     901952 | /ports/branches/2018Q4/mail/claws-mail-clamd
     901947 | /ports/branches/2018Q4/mail/claws-mail-archiver
     901945 | /ports/branches/2018Q4/net/gtk-vnc
     901943 | /ports/branches/2018Q4/mail/claws-mail
     901941 | /ports/branches/2018Q4/graphics/goocanvas2
     901938 | /ports/branches/2018Q4/www/py-flexget
     901933 | /ports/branches/2018Q4/editors/mg
     901927 | /ports/branches/2018Q4/www/newsboat
     901923 | /ports/branches/2018Q4/www/gitlab-ce
     901920 | /ports/branches/2018Q4/devel/gitaly
     901910 | /ports/branches/2018Q4/www/firefox-esr
     901913 | /ports/branches/2018Q4/www/firefox-esr-i18n
     901904 | /ports/branches/2018Q4/www/firefox-i18n
     901907 | /ports/branches/2018Q4/www/firefox
     901902 | /ports/branches/2018Q4/emulators/citra-qt5
     901899 | /ports/branches/2018Q4/emulators/citra
     901893 | /ports/branches/2018Q4/mail/thunderbird-i18n
     901896 | /ports/branches/2018Q4/mail/thunderbird
     901888 | /ports/branches/2018Q4/emulators/rpcs3
     901864 | /ports/branches/2018Q4/multimedia/libvpx
     901811 | /ports/branches/2018Q4/multimedia/gstreamer1-plugins-openh264
     901809 | /ports/branches/2018Q4/comms/gstreamer1-plugins-spandsp
     901806 | /ports/branches/2018Q4/multimedia/gstreamer1-plugins-vpx
     901804 | /ports/branches/2018Q4/graphics/gstreamer1-plugins-webp
     901802 | /ports/branches/2018Q4/graphics/gstreamer1-plugins-libcaca
     901800 | /ports/branches/2018Q4/audio/gstreamer1-plugins-lame
     901798 | /ports/branches/2018Q4/audio/gstreamer1-plugins-flac
     901796 | /ports/branches/2018Q4/audio/gstreamer1-plugins-pulse
     901794 | /ports/branches/2018Q4/audio/gstreamer1-plugins-taglib
     901792 | /ports/branches/2018Q4/multimedia/gstreamer1-plugins-resindvd
     901790 | /ports/branches/2018Q4/multimedia/gstreamer1-plugins-hls
     901788 | /ports/branches/2018Q4/multimedia/gstreamer1-plugins-dash
     901786 | /ports/branches/2018Q4/audio/gstreamer1-plugins-bs2b
     901784 | /ports/branches/2018Q4/audio/gstreamer1-plugins-flite
     901782 | /ports/branches/2018Q4/audio/gstreamer1-plugins-twolame
     901780 | /ports/branches/2018Q4/graphics/gstreamer1-plugins-png
     901775 | /ports/branches/2018Q4/graphics/gstreamer1-plugins-openjpeg
     901773 | /ports/branches/2018Q4/multimedia/gstreamer1-plugins-x265
     901771 | /ports/branches/2018Q4/audio/gstreamer1-plugins-musepack
     901769 | /ports/branches/2018Q4/audio/gstreamer1-plugins-spc
     901767 | /ports/branches/2018Q4/audio/gstreamer1-plugins-shout2
     901765 | /ports/branches/2018Q4/audio/gstreamer1-plugins-faac
     901763 | /ports/branches/2018Q4/www/gstreamer1-plugins-neon
     901760 | /ports/branches/2018Q4/graphics/gstreamer1-plugins-libvisual
     901758 | /ports/branches/2018Q4/audio/gstreamer1-plugins-a52dec
     901756 | /ports/branches/2018Q4/audio/gstreamer1-plugins-vorbis
     901754 | /ports/branches/2018Q4/x11-toolkits/gstreamer1-plugins-pango
     901750 | /ports/branches/2018Q4/graphics/gstreamer1-plugins-gl
     901748 | /ports/branches/2018Q4/audio/gstreamer1-plugins-opus
     901746 | /ports/branches/2018Q4/multimedia/gstreamer1-plugins-ttml
     901744 | /ports/branches/2018Q4/audio/gstreamer1-plugins-chromaprint
     901742 | /ports/branches/2018Q4/x11/gstreamer1-plugins-ximagesrc
     901740 | /ports/branches/2018Q4/graphics/gstreamer1-plugins-jpeg
     901738 | /ports/branches/2018Q4/audio/gstreamer1-plugins-sndfile
     901736 | /ports/branches/2018Q4/multimedia/gstreamer1-plugins-x264
     901734 | /ports/branches/2018Q4/multimedia/gstreamer1-plugins-dts
     901732 | /ports/branches/2018Q4/audio/gstreamer1-plugins-amrnb
     901730 | /ports/branches/2018Q4/audio/gstreamer1-plugins-modplug
     901728 | /ports/branches/2018Q4/audio/gstreamer1-plugins-mpg123
     901726 | /ports/branches/2018Q4/multimedia/gstreamer1-plugins-smoothstreaming
     901724 | /ports/branches/2018Q4/graphics/gstreamer1-plugins-aalib
     901719 | /ports/branches/2018Q4/multimedia/gstreamer1-plugins-ugly
     901717 | /ports/branches/2018Q4/security/gstreamer1-plugins-dtls
     901714 | /ports/branches/2018Q4/audio/gstreamer1-plugins-soundtouch
     901712 | /ports/branches/2018Q4/multimedia/gstreamer1-plugins-dv
     901710 | /ports/branches/2018Q4/audio/gstreamer1-plugins-jack
     901708 | /ports/branches/2018Q4/net/gstreamer1-plugins-srtp
     901706 | /ports/branches/2018Q4/multimedia/gstreamer1-plugins-mplex
     901704 | /ports/branches/2018Q4/multimedia/gstreamer1-plugins-assrender
     901702 | /ports/branches/2018Q4/net/gstreamer1-plugins-libmms
     901699 | /ports/branches/2018Q4/audio/gstreamer1-plugins-faad
     901689 | /ports/branches/2018Q4/multimedia/gstreamer1-plugins-bad
     901687 | /ports/branches/2018Q4/audio/gstreamer1-plugins-amrwbdec
     901685 | /ports/branches/2018Q4/multimedia/gstreamer1-plugins-dvdread
     901683 | /ports/branches/2018Q4/multimedia/gstreamer1-plugins-theora
     901820 | /ports/branches/2018Q4/x11-toolkits/gstreamer1-plugins-gtk
     901674 | /ports/branches/2018Q4/audio/gstreamer1-plugins-cdparanoia
     901677 | /ports/branches/2018Q4/devel/gstreamer1-plugins-soup
     901849 | /ports/branches/2018Q4/graphics/gstreamer1-plugins-gdkpixbuf
     901847 | /ports/branches/2018Q4/multimedia/gstreamer1-plugins-schroedinger
     901845 | /ports/branches/2018Q4/audio/gstreamer1-plugins-speex
     901843 | /ports/branches/2018Q4/graphics/gstreamer1-plugins-zbar
     901835 | /ports/branches/2018Q4/multimedia/gstreamer1-plugins-good
     901833 | /ports/branches/2018Q4/multimedia/gstreamer1-plugins-v4l2
     901831 | /ports/branches/2018Q4/graphics/gstreamer1-plugins-kms
     901829 | /ports/branches/2018Q4/multimedia/gstreamer1-plugins-mpeg2dec
     901827 | /ports/branches/2018Q4/sysutils/gstreamer1-plugins-cdio
     901824 | /ports/branches/2018Q4/multimedia/gstreamer1-plugins-libde265
     901822 | /ports/branches/2018Q4/multimedia/gstreamer1-plugins-kate
     901672 | /ports/branches/2018Q4/audio/gstreamer1-plugins-gsm
     901818 | /ports/branches/2018Q4/audio/gstreamer1-plugins-ogg
     901816 | /ports/branches/2018Q4/ftp/gstreamer1-plugins-curl
     901813 | /ports/branches/2018Q4/audio/gstreamer1-plugins-sidplay
     901681 | /ports/branches/2018Q4/audio/gstreamer1-plugins-wavpack
     901653 | /ports/branches/2018Q4/graphics/gstreamer1-plugins-cairo
     901655 | /ports/branches/2018Q4/multimedia/gstreamer1-plugins-rtmp
     901679 | /ports/branches/2018Q4/graphics/gstreamer1-plugins-rsvg
     901657 | /ports/branches/2018Q4/multimedia/gstreamer1-plugins-mpeg2enc
     901659 | /ports/branches/2018Q4/graphics/gstreamer1-plugins-openexr
     901662 | /ports/branches/2018Q4/audio/gstreamer1-plugins-gme
     901664 | /ports/branches/2018Q4/graphics/gstreamer1-plugins-opencv
     901667 | /ports/branches/2018Q4/audio/gstreamer1-plugins-ladspa
     901670 | /ports/branches/2018Q4/x11/gstreamer1-plugins-x
     901650 | /ports/branches/2018Q4/multimedia/gstreamer1
     901648 | /ports/branches/2018Q4/multimedia/gstreamer1-plugins
     901645 | /ports/branches/2018Q4/textproc/ibus
     901635 | /ports/head/databases/py-cassandra-driver
     901633 | /ports/branches/2018Q3/devel/googlemock
     901631 | /ports/branches/2018Q3/devel/googletest
     901581 | /ports/head/deskutils/kdeconnect-kde
     901579 | /ports/head/deskutils/kdeconnect-kde-kde4
     901574 | /ports/head/x11-toolkits/tepl
     901497 | /ports/head/misc/gnome-getting-started-docs
     901502 | /ports/head/net/libgrss
     901479 | /ports/head/devel/template-glib
     901525 | /ports/head/x11-themes/gnome-themes-extra
     901461 | /ports/head/deskutils/gnome-tweaks
     901516 | /ports/head/sysutils/tracker-miners
     901460 | /ports/head/deskutils/gnome-shell-extension-windowoverlay-icons
     901474 | /ports/head/devel/jsonrpc-glib
     901526 | /ports/head/x11-toolkits/libdazzle
     901446 | /ports/head/databases/sequeler
     901442 | /ports/head/devel/py-btest
     901437 | /ports/head/comms/apitran
     901412 | /ports/head/multimedia/vlc3
     901403 | /ports/branches/2018Q3/japanese/spamassassin
     901391 | /ports/branches/2018Q3/mail/spamassassin
     901369 | /ports/head/www/py-django-taggit-serializer
     901363 | /ports/head/sysutils/potnet
     901321 | /ports/head/databases/puppetdb-cli
     901313 | /ports/head/databases/puppetdb6
     901312 | /ports/head/databases/puppetdb-terminus6
     901303 | /ports/head/sysutils/puppetserver6
     901295 | /ports/head/sysutils/puppet6
     901289 | /ports/head/sysutils/rubygem-puppetserver-ca
     901283 | /ports/head/net/libyang
     901278 | /ports/head/audio/libopusenc
     901271 | /ports/head/benchmarks/linux-vdbench
     901264 | /ports/head/devel/py-pytest-xprocess
     901254 | /ports/head/science/bagel
     901214 | /ports/branches/2018Q3/databases/postgresql10-docs
     901209 | /ports/branches/2018Q3/databases/postgresql95-plpython
     901206 | /ports/branches/2018Q3/databases/postgresql10-contrib
     901204 | /ports/branches/2018Q3/databases/postgresql93-plpython
     901201 | /ports/branches/2018Q3/databases/postgresql96-contrib
     901199 | /ports/branches/2018Q3/databases/postgresql94-plperl
     901197 | /ports/branches/2018Q3/databases/postgresql95-plperl
     901195 | /ports/branches/2018Q3/databases/postgresql93-docs
     901191 | /ports/branches/2018Q3/databases/postgresql93-plperl
     901189 | /ports/branches/2018Q3/databases/postgresql96-pltcl
     901187 | /ports/branches/2018Q3/databases/postgresql95-pltcl
     901232 | /ports/branches/2018Q3/databases/postgresql94-docs
     901238 | /ports/branches/2018Q3/databases/postgresql94-pltcl
     901193 | /ports/branches/2018Q3/databases/postgresql93-client
     901212 | /ports/branches/2018Q3/databases/postgresql94-plpython
     901250 | /ports/branches/2018Q3/databases/postgresql94-contrib
     901248 | /ports/branches/2018Q3/databases/postgresql10-client
     901246 | /ports/branches/2018Q3/databases/postgresql96-plpython
     901244 | /ports/branches/2018Q3/databases/postgresql96-client
     901242 | /ports/branches/2018Q3/databases/postgresql10-plpython
     901240 | /ports/branches/2018Q3/databases/postgresql95-client
     901236 | /ports/branches/2018Q3/databases/postgresql94-client
     901234 | /ports/branches/2018Q3/databases/postgresql95-docs
     901230 | /ports/branches/2018Q3/databases/postgresql10-plperl
     901227 | /ports/branches/2018Q3/databases/postgresql95-contrib
     901225 | /ports/branches/2018Q3/databases/postgresql10-pltcl
     901223 | /ports/branches/2018Q3/databases/postgresql96-docs
     901220 | /ports/branches/2018Q3/databases/postgresql93-contrib
     901218 | /ports/branches/2018Q3/databases/postgresql93-pltcl
     901216 | /ports/branches/2018Q3/databases/postgresql96-plperl
     901177 | /ports/branches/2018Q3/databases/postgresql95-server
     901163 | /ports/branches/2018Q3/databases/postgresql10-server
     901172 | /ports/branches/2018Q3/databases/postgresql94-server
     901168 | /ports/branches/2018Q3/databases/postgresql93-server
     901182 | /ports/branches/2018Q3/databases/postgresql96-server
     901133 | /ports/head/cad/kicad-library-symbols
     901132 | /ports/head/cad/kicad-library-packages3d
     901131 | /ports/head/cad/kicad-library-footprints
     901134 | /ports/head/cad/kicad-library-templates
     901126 | /ports/head/security/onionscan
     901068 | /ports/branches/2018Q3/misc/freebsd-doc-da
     901114 | /ports/branches/2018Q3/misc/freebsd-doc-el
     901105 | /ports/branches/2018Q3/misc/freebsd-doc-tr
     901096 | /ports/branches/2018Q3/misc/freebsd-doc-zh_tw
     901087 | /ports/branches/2018Q3/misc/freebsd-doc-bn
     901078 | /ports/branches/2018Q3/misc/freebsd-doc-ja
     901059 | /ports/branches/2018Q3/misc/freebsd-doc-ru
     901050 | /ports/branches/2018Q3/misc/freebsd-doc-es
     901041 | /ports/branches/2018Q3/misc/freebsd-doc-hu
     901032 | /ports/branches/2018Q3/misc/freebsd-doc-zh_cn
     901023 | /ports/branches/2018Q3/misc/freebsd-doc-mn
     901014 | /ports/branches/2018Q3/misc/freebsd-doc-pl
     901005 | /ports/branches/2018Q3/misc/freebsd-doc-ko
     900996 | /ports/branches/2018Q3/misc/freebsd-doc-fr
     900987 | /ports/branches/2018Q3/misc/freebsd-doc-nl
     900967 | /ports/branches/2018Q3/misc/freebsd-doc-de
     900980 | /ports/branches/2018Q3/misc/freebsd-doc-pt
     900965 | /ports/branches/2018Q3/misc/freebsd-doc-all
     900969 | /ports/branches/2018Q3/misc/freebsd-doc-en
     900973 | /ports/branches/2018Q3/misc/freebsd-doc-it
     900751 | /ports/head/textproc/p5-Text-Table-XLSX
     900746 | /ports/head/textproc/p5-Spreadsheet-GenerateXLSX
     900742 | /ports/head/math/R-cran-forcats
     900738 | /ports/head/textproc/R-cran-rematch
     900733 | /ports/branches/2018Q3/net/asterisk15
     900728 | /ports/branches/2018Q3/net/asterisk13
     900724 | /ports/head/textproc/R-cran-openxlsx
     900720 | /ports/head/archivers/R-cran-zip
     900717 | /ports/branches/2018Q3/sysutils/rubygem-smart_proxy_dynflow
     900708 | /ports/head/misc/pyobd
     900701 | /ports/head/math/py-CyLP
     900690 | /ports/head/textproc/rubygem-regexp_parser
     900686 | /ports/head/textproc/rubygem-js_regex
     900682 | /ports/head/sysutils/bfs
     900668 | /ports/head/science/elk
     900664 | /ports/head/x11-toolkits/rubygem-tk
     900658 | /ports/head/audio/rhvoice-dictionary
     900653 | /ports/head/devel/rust-bindgen
     900648 | /ports/head/devel/py-molecule
     900634 | /ports/head/graphics/openexr
     900626 | /ports/head/devel/py-yamllint
     900622 | /ports/head/devel/py-pathspec
     900618 | /ports/head/textproc/libdiff
     900610 | /ports/head/x11-themes/freebsd-8k-wallpapers-kde
     900609 | /ports/head/x11-themes/freebsd-8k-wallpapers
     900602 | /ports/head/devel/vitables
     900587 | /ports/head/devel/vcglib
     900576 | /ports/head/databases/couchdb2
     900571 | /ports/head/devel/py-tree-format
     900566 | /ports/head/x11-fonts/spleen
     900562 | /ports/head/devel/py-python-gilt
     900558 | /ports/head/devel/py-git-url-parse
     900554 | /ports/head/devel/py-pytest-helpers-namespace
     900550 | /ports/head/math/py-fastdtw
     900546 | /ports/head/biology/py-loompy
     900542 | /ports/head/devel/py-cookiecutter
     900532 | /ports/head/science/py-PyFR
     900528 | /ports/head/devel/py-jinja2-time
     900520 | /ports/head/net/py-mpi4py
     900512 | /ports/head/math/py-gimmik
     900502 | /ports/head/math/libxsmm
     900498 | /ports/branches/2018Q3/www/lighttpd-mod_h264_streaming
     900494 | /ports/branches/2018Q3/www/lighttpd
     900492 | /ports/head/devel/xtoolchain-llvm70
     900487 | /ports/head/devel/py-poyo
     900481 | /ports/head/textproc/tttcmds
     900477 | /ports/head/devel/py-whichcraft
     900470 | /ports/head/databases/opendbviewer
     900456 | /ports/branches/2018Q3/devel/py-mdv
     900329 | /ports/head/math/py-pyodeint
     900325 | /ports/head/devel/py-pycodeexport
     900321 | /ports/head/devel/py-pycompilation
     900317 | /ports/head/math/py-pygslodeiv2
     900309 | /ports/head/cad/k40-whisperer
     900307 | /ports/branches/2018Q3/security/lockdown
     900303 | /ports/head/science/py-chempy
     900296 | /ports/head/math/py-PuLP
     900286 | /ports/head/print/pdf-redact-tools
     900275 | /ports/head/devel/ocaml-ocamlbuild
     900271 | /ports/head/devel/py-selectors2
     900269 | /ports/branches/2018Q3/security/libargon2
     900260 | /ports/branches/2018Q3/www/moodle33
     900263 | /ports/branches/2018Q3/www/moodle34
     900266 | /ports/branches/2018Q3/www/moodle35
     900257 | /ports/branches/2018Q3/www/moodle31
     900243 | /ports/head/lang/ott
     900239 | /ports/head/www/py-django-webpack-loader
     900227 | /ports/head/net/kf5-syndication
     900210 | /ports/head/textproc/py-ufal.udpipe
     900181 | /ports/head/www/searx
     900175 | /ports/head/net/rubygem-fog-openstack02
     900154 | /ports/head/devel/pear-channel-geshi
     900149 | /ports/branches/2018Q3/www/joomla3
     900128 | /ports/head/x11-toolkits/p5-Wx-GLCanvas
     900119 | /ports/head/science/luscus
     900115 | /ports/head/science/py-phono3py
     900111 | /ports/head/science/py-phonopy
     900102 | /ports/head/science/py-molmod
     900093 | /ports/head/net/rubygem-google-cloud-core
     900089 | /ports/head/net/rubygem-google-cloud-env
     900083 | /ports/head/audio/spc2it
     898914 | /ports/head/devel/py-grpcio-gcp
     898905 | /ports/head/science/dftbplus
     898891 | /ports/head/sysutils/lxqt-admin
     898888 | /ports/branches/2018Q3/www/varnish4
     898884 | /ports/branches/2018Q3/www/varnish6
     898866 | /ports/head/security/openssl111
     898833 | /ports/head/science/openmx
     898822 | /ports/head/dns/amass
     898816 | /ports/head/audio/libopenmpt
     898814 | /ports/head/devel/py-astroid1
     898812 | /ports/branches/2018Q3/www/flashplayer
     898714 | /ports/branches/2018Q3/print/ghostscript9-agpl-x11
     898707 | /ports/branches/2018Q3/print/ghostscript9-agpl-base
     898702 | /ports/head/audio/rhvoice
     898699 | /ports/branches/2018Q3/security/krb5-appl
     898689 | /ports/head/security/py-google-auth-httplib2
     898684 | /ports/head/security/p5-Alt-Crypt-RSA-BigInt
     898679 | /ports/head/math/p5-Math-Prime-Util-GMP
     898674 | /ports/head/math/p5-Math-Prime-Util
     898573 | /ports/head/science/msms
     898560 | /ports/head/science/lm
     898556 | /ports/head/devel/py-pytest-pycodestyle
     898543 | /ports/head/devel/py-pytest-flakes
(457 rows)

freshports.dev=#

dlangille commented 5 years ago

As you can see, some of that is on branches, not just head, so let's get more specific.

Using an example from https://news.freshports.org/2018/10/06/getting-a-link-from-a-package-name/ let's change the SQL to use head only.

freshports.dev=#      SELECT P.element_id, element_pathname(P.element_id)
freshports.dev-#     FROM ports P
freshports.dev-#    JOIN element_pathname EP ON P.element_id = EP.element_id
freshports.dev-#    WHERE P.date_added > now() - '1 month'::interval
freshports.dev-#      AND EP.pathname LIKE '/ports/head/%'
freshports.dev-#  ORDER BY P.date_added DESC;
 element_id |                        element_pathname                         
------------+-----------------------------------------------------------------
     902624 | /ports/head/devel/pecl-xdebug-devel
     902622 | /ports/head/devel/pecl-xdebug25
     902605 | /ports/head/security/py-bro-pkg
     902585 | /ports/head/textproc/hs-parsec-numbers
     902573 | /ports/head/x11-fonts/materialdesign-ttf
     902560 | /ports/head/math/primme
     902550 | /ports/head/devel/py-pylibsrtp
     902546 | /ports/head/devel/py-aioice
     902542 | /ports/head/multimedia/py-av
     902399 | /ports/head/net/php73-sockets
     902392 | /ports/head/mail/php73-imap
     902416 | /ports/head/textproc/php73-xsl
     902407 | /ports/head/textproc/php73-ctype
     902410 | /ports/head/textproc/php73-pspell
     902395 | /ports/head/misc/php73-calendar
     902405 | /ports/head/sysutils/php73-fileinfo
     902389 | /ports/head/graphics/php73-gd
     902402 | /ports/head/security/php73-hash
     902403 | /ports/head/security/php73-openssl
     902418 | /ports/head/www/php73-opcache
     902364 | /ports/head/databases/php73-interbase
     902409 | /ports/head/textproc/php73-enchant
     902356 | /ports/head/archivers/php73-bz2
     902414 | /ports/head/textproc/php73-xmlreader
     902417 | /ports/head/www/mod_php73
     902381 | /ports/head/devel/php73-shmop
     902357 | /ports/head/archivers/php73-phar
     902388 | /ports/head/graphics/php73-exif
     902366 | /ports/head/databases/php73-odbc
     902415 | /ports/head/textproc/php73-xmlwriter
     902419 | /ports/head/www/php73-session
     902404 | /ports/head/security/php73-sodium
     902411 | /ports/head/textproc/php73-simplexml
     902398 | /ports/head/net/php73-soap
     902396 | /ports/head/net-mgmt/php73-snmp
     902369 | /ports/head/databases/php73-pdo_firebird
     902394 | /ports/head/math/php73-gmp
     902406 | /ports/head/sysutils/php73-posix
     902413 | /ports/head/textproc/php73-xml
     902368 | /ports/head/databases/php73-pdo_dblib
     902362 | /ports/head/converters/php73-recode
     902397 | /ports/head/net/php73-ldap
     902372 | /ports/head/databases/php73-pdo_pgsql
     902358 | /ports/head/archivers/php73-zip
     902370 | /ports/head/databases/php73-pdo_mysql
     902363 | /ports/head/databases/php73-dba
     902391 | /ports/head/lang/php73-extensions
     902393 | /ports/head/math/php73-bcmath
     902401 | /ports/head/security/php73-filter
     902420 | /ports/head/www/php73-tidy
     902390 | /ports/head/lang/php73
     902383 | /ports/head/devel/php73-sysvsem
     902400 | /ports/head/net/php73-xmlrpc
     902382 | /ports/head/devel/php73-sysvmsg
     902385 | /ports/head/devel/php73-tokenizer
     902371 | /ports/head/databases/php73-pdo_odbc
     902384 | /ports/head/devel/php73-sysvshm
     902367 | /ports/head/databases/php73-pdo
     902380 | /ports/head/devel/php73-readline
     902387 | /ports/head/ftp/php73-ftp
     902359 | /ports/head/archivers/php73-zlib
     902374 | /ports/head/databases/php73-pgsql
     902376 | /ports/head/devel/php73-gettext
     902408 | /ports/head/textproc/php73-dom
     902375 | /ports/head/databases/php73-sqlite3
     902379 | /ports/head/devel/php73-pcntl
     902377 | /ports/head/devel/php73-intl
     902412 | /ports/head/textproc/php73-wddx
     902361 | /ports/head/converters/php73-mbstring
     902365 | /ports/head/databases/php73-mysqli
     902360 | /ports/head/converters/php73-iconv
     902378 | /ports/head/devel/php73-json
     902386 | /ports/head/ftp/php73-curl
     902373 | /ports/head/databases/php73-pdo_sqlite
     902325 | /ports/head/biology/ncbi-cxx-toolkit
     902320 | /ports/head/science/simint
     902315 | /ports/head/deskutils/qownnotes
     902311 | /ports/head/science/molgif
     902298 | /ports/head/java/jdk10-doc
     902288 | /ports/head/devel/py-deepdiff
     902282 | /ports/head/math/py-gau2grid
     902275 | /ports/head/devel/py-jsonpickle
     902262 | /ports/head/science/tinker
     902257 | /ports/head/net-p2p/py-libtorrent-rasterbar
     902233 | /ports/head/security/cargo-audit
     902227 | /ports/head/devel/rubygem-c21e
     902223 | /ports/head/devel/rubygem-cucumber-formatter-dots
     902219 | /ports/head/devel/rubygem-cucumber-messages
     902214 | /ports/head/editors/gnome-latex
     902210 | /ports/head/devel/coursier
     902203 | /ports/head/devel/libb2
     902196 | /ports/head/devel/py-libiocage
     902192 | /ports/head/devel/sccache
     902189 | /ports/head/sysutils/u-boot-pinebook
     902150 | /ports/head/net-mgmt/zabbix4-server
     902148 | /ports/head/net-mgmt/zabbix4-java
     902149 | /ports/head/net-mgmt/zabbix4-proxy
     902146 | /ports/head/net-mgmt/zabbix4-agent
     902147 | /ports/head/net-mgmt/zabbix4-frontend
     902135 | /ports/head/math/adol-c
     902130 | /ports/head/x11-fonts/psftools
     902126 | /ports/head/math/nanoflann
     902072 | /ports/head/math/deal.ii
     902065 | /ports/head/sysutils/stepsync
     902060 | /ports/head/sysutils/dwatch-json
     901635 | /ports/head/databases/py-cassandra-driver
     901581 | /ports/head/deskutils/kdeconnect-kde
     901579 | /ports/head/deskutils/kdeconnect-kde-kde4
     901574 | /ports/head/x11-toolkits/tepl
     901474 | /ports/head/devel/jsonrpc-glib
     901460 | /ports/head/deskutils/gnome-shell-extension-windowoverlay-icons
     901516 | /ports/head/sysutils/tracker-miners
     901461 | /ports/head/deskutils/gnome-tweaks
     901525 | /ports/head/x11-themes/gnome-themes-extra
     901479 | /ports/head/devel/template-glib
     901502 | /ports/head/net/libgrss
     901497 | /ports/head/misc/gnome-getting-started-docs
     901526 | /ports/head/x11-toolkits/libdazzle
     901446 | /ports/head/databases/sequeler
     901442 | /ports/head/devel/py-btest
     901437 | /ports/head/comms/apitran
     901412 | /ports/head/multimedia/vlc3
     901369 | /ports/head/www/py-django-taggit-serializer
     901363 | /ports/head/sysutils/potnet
     901321 | /ports/head/databases/puppetdb-cli
     901313 | /ports/head/databases/puppetdb6
     901312 | /ports/head/databases/puppetdb-terminus6
     901303 | /ports/head/sysutils/puppetserver6
     901295 | /ports/head/sysutils/puppet6
     901289 | /ports/head/sysutils/rubygem-puppetserver-ca
     901283 | /ports/head/net/libyang
     901278 | /ports/head/audio/libopusenc
     901271 | /ports/head/benchmarks/linux-vdbench
     901264 | /ports/head/devel/py-pytest-xprocess
     901254 | /ports/head/science/bagel
     901133 | /ports/head/cad/kicad-library-symbols
     901134 | /ports/head/cad/kicad-library-templates
     901131 | /ports/head/cad/kicad-library-footprints
     901132 | /ports/head/cad/kicad-library-packages3d
     901126 | /ports/head/security/onionscan
     900751 | /ports/head/textproc/p5-Text-Table-XLSX
     900746 | /ports/head/textproc/p5-Spreadsheet-GenerateXLSX
     900742 | /ports/head/math/R-cran-forcats
     900738 | /ports/head/textproc/R-cran-rematch
     900724 | /ports/head/textproc/R-cran-openxlsx
     900720 | /ports/head/archivers/R-cran-zip
     900708 | /ports/head/misc/pyobd
     900701 | /ports/head/math/py-CyLP
     900686 | /ports/head/textproc/rubygem-js_regex
     900690 | /ports/head/textproc/rubygem-regexp_parser
     900682 | /ports/head/sysutils/bfs
     900668 | /ports/head/science/elk
     900664 | /ports/head/x11-toolkits/rubygem-tk
     900658 | /ports/head/audio/rhvoice-dictionary
     900653 | /ports/head/devel/rust-bindgen
     900648 | /ports/head/devel/py-molecule
     900634 | /ports/head/graphics/openexr
     900626 | /ports/head/devel/py-yamllint
     900622 | /ports/head/devel/py-pathspec
     900618 | /ports/head/textproc/libdiff
     900610 | /ports/head/x11-themes/freebsd-8k-wallpapers-kde
     900609 | /ports/head/x11-themes/freebsd-8k-wallpapers
     900602 | /ports/head/devel/vitables
     900587 | /ports/head/devel/vcglib
     900576 | /ports/head/databases/couchdb2
     900571 | /ports/head/devel/py-tree-format
     900566 | /ports/head/x11-fonts/spleen
     900562 | /ports/head/devel/py-python-gilt
     900558 | /ports/head/devel/py-git-url-parse
     900554 | /ports/head/devel/py-pytest-helpers-namespace
     900550 | /ports/head/math/py-fastdtw
     900546 | /ports/head/biology/py-loompy
     900542 | /ports/head/devel/py-cookiecutter
     900532 | /ports/head/science/py-PyFR
     900528 | /ports/head/devel/py-jinja2-time
     900520 | /ports/head/net/py-mpi4py
     900512 | /ports/head/math/py-gimmik
     900502 | /ports/head/math/libxsmm
     900492 | /ports/head/devel/xtoolchain-llvm70
     900487 | /ports/head/devel/py-poyo
     900481 | /ports/head/textproc/tttcmds
     900477 | /ports/head/devel/py-whichcraft
     900470 | /ports/head/databases/opendbviewer
     900329 | /ports/head/math/py-pyodeint
     900325 | /ports/head/devel/py-pycodeexport
     900321 | /ports/head/devel/py-pycompilation
     900317 | /ports/head/math/py-pygslodeiv2
     900309 | /ports/head/cad/k40-whisperer
     900303 | /ports/head/science/py-chempy
     900296 | /ports/head/math/py-PuLP
     900286 | /ports/head/print/pdf-redact-tools
     900275 | /ports/head/devel/ocaml-ocamlbuild
     900271 | /ports/head/devel/py-selectors2
     900243 | /ports/head/lang/ott
     900239 | /ports/head/www/py-django-webpack-loader
     900227 | /ports/head/net/kf5-syndication
     900210 | /ports/head/textproc/py-ufal.udpipe
     900181 | /ports/head/www/searx
     900175 | /ports/head/net/rubygem-fog-openstack02
     900154 | /ports/head/devel/pear-channel-geshi
     900128 | /ports/head/x11-toolkits/p5-Wx-GLCanvas
     900119 | /ports/head/science/luscus
     900115 | /ports/head/science/py-phono3py
     900111 | /ports/head/science/py-phonopy
     900102 | /ports/head/science/py-molmod
     900093 | /ports/head/net/rubygem-google-cloud-core
     900089 | /ports/head/net/rubygem-google-cloud-env
     900083 | /ports/head/audio/spc2it
     898914 | /ports/head/devel/py-grpcio-gcp
     898905 | /ports/head/science/dftbplus
     898891 | /ports/head/sysutils/lxqt-admin
     898866 | /ports/head/security/openssl111
     898833 | /ports/head/science/openmx
     898822 | /ports/head/dns/amass
     898816 | /ports/head/audio/libopenmpt
     898814 | /ports/head/devel/py-astroid1
     898702 | /ports/head/audio/rhvoice
     898689 | /ports/head/security/py-google-auth-httplib2
     898684 | /ports/head/security/p5-Alt-Crypt-RSA-BigInt
     898679 | /ports/head/math/p5-Math-Prime-Util-GMP
     898674 | /ports/head/math/p5-Math-Prime-Util
     898573 | /ports/head/science/msms
     898560 | /ports/head/science/lm
     898556 | /ports/head/devel/py-pytest-pycodestyle
     898543 | /ports/head/devel/py-pytest-flakes
(225 rows)

freshports.dev=#

dlangille commented 5 years ago

That's better. Now, let's get a count instead:

freshports.dev=#   SELECT count(*)
freshports.dev-#     FROM ports P
freshports.dev-#    JOIN element_pathname EP ON P.element_id = EP.element_id
freshports.dev-#    WHERE P.date_added > now() - '1 month'::interval
freshports.dev-#      AND EP.pathname LIKE '/ports/head/%';
 count 
-------
   225
(1 row)

freshports.dev=#

ibara commented 5 years ago

Yup, this last one looks like it is the winner.

dlangille commented 5 years ago

I'll update Stats_PortCountNewInterval() when I'm next online.

dlangille commented 5 years ago

Have a look at https://dev.freshports.org/

ibara commented 5 years ago

That looks right.

dlangille commented 5 years ago

This is now in test: https://test.freshports.org/

dlangille commented 5 years ago

This is now in staging: https://stage.freshports.org/

dlangille commented 5 years ago

I noticed that 'Port Added: unknown' is on each port page.

This is not a data issue. This is either SQL query or display related.

NOTE: this is not an issue. It is because the date added for that port is not known to FreshPorts.

dlangille commented 5 years ago

Fixed on https://www.freshports.org/

ibara commented 5 years ago

To wrap up, from #devious again:

12:38 < dvl> bcallah:  fixed? https://github.com/FreshPorts/freshports/issues/67#issuecomment-428034506
12:41 <@bcallah> dvl: yeah has been fine for me the last few days
12:45 < dvl> bcallah: OK, if you comment, the audit trail is nicely closed.

Commenting, can close!

dlangille commented 5 years ago

Audit trail for the win,

FreshPorts / freshports

I am raising an issue because Dan said I had to. #67