SELECT host, port, height, status, DATE_TRUNC('minute', last_probed) AS last_probed, DATE_TRUNC('minute', last_alive) AS last_alive, version, jumpers, user_agent, ARRAY_LENGTH(peers,1) AS peers, ver_msg_payload::jsonb->>'version' AS "my_ver", ver_msg_payload::jsonb ? 'relay' AS "inc_prb_byte" FROM nodes WHERE ARRAY_LENGTH(peers,1) > 1 ORDER BY array_length(peers,1) DESC; host | port | height | status | last_probed | last_alive | version | jumpers | user_agent | peers | my_ver | inc_prb_byte -----------------+-------+--------+-------------------------------------------+------------------------+------------------------+---------+---------+--------------------------------+-------+--------+-------------- 24.22.36.204 | 8333 | 572410 | Busy? (No answer in 15 sec.) | 2021-05-09 07:53:00-06 | 2021-05-08 23:47:00-06 | 70002 | 0x1 | /Satoshi:0.9.1/ | 2000 | 70001 | t 73.123.155.71 | 8333 | 405040 | Alive | 2021-05-09 08:01:00-06 | 2021-05-09 08:01:00-06 | 70001 | 0x1 | /Satoshi:0.8.1/ | 2000 | 99999 | t 68.198.126.140 | 8333 | 395138 | Busy? (No answer in 15 sec.) | 2021-05-09 08:01:00-06 | 2021-05-08 22:26:00-06 | 70001 | 0x1 | /Satoshi:0.8.1/ | 2000 | 70001 | t 68.50.46.131 | 8333 | 682767 | Alive | 2021-05-09 08:52:00-06 | 2021-05-09 08:52:00-06 | 70002 | 0x1 | /Satoshi:0.9.1/ | 2000 | 99999 | t 187.11.149.63 | 8333 | 3747 | Busy? (No answer in 15 sec.) | 2021-05-09 08:05:00-06 | 2021-05-08 07:04:00-06 | 70002 | 0x1 | /Satoshi:0.9.4/ | 2000 | 70001 | t 141.126.41.5 | 8333 | 500476 | Busy? (No answer in 15 sec.) | 2021-05-09 08:05:00-06 | 2021-05-08 01:53:00-06 | 70002 | 0x1 | /Satoshi:0.9.2.1/ | 2000 | 99999 | t 70.20.26.208 | 8333 | 682702 | Busy? (No answer in 15 sec.) | 2021-05-09 08:00:00-06 | 2021-05-09 01:26:00-06 | 70002 | 0x1 | /Satoshi:0.9.1/ | 2000 | 70001 | t 102.65.8.49 | 8333 | 490352 | Busy? (No answer in 15 sec.) | 2021-05-09 08:00:00-06 | 2021-05-08 22:24:00-06 | 70002 | 0x1 | /Satoshi:0.9.3/ | 2000 | 70001 | t 37.133.140.90 | 8333 | 275031 | Alive | 2021-05-09 07:57:00-06 | 2021-05-09 07:57:00-06 | 70001 | 0x1 | /Satoshi:0.8.1/ | 2000 | 99999 | t 100.0.189.111 | 8333 | 439523 | Busy? (No answer in 15 sec.) | 2021-05-09 08:53:00-06 | 2021-05-09 07:07:00-06 | 70001 | 0x1 | /Satoshi:0.8.0/ | 2000 | 70001 | t 73.20.70.19 | 8333 | 306476 | Alive | 2021-05-09 08:22:00-06 | 2021-05-09 08:22:00-06 | 70001 | 0x1 | /Satoshi:0.8.6/ | 2000 | 99999 | t 72.93.243.211 | 8333 | 0 | Could not connect! | 2021-05-09 08:05:00-06 | 2021-05-08 18:13:00-06 | 70014 | 0x9 | pbtc | 2000 | 99999 | t 82.64.252.71 | 8333 | 682682 | Could not connect! | 2021-05-09 08:00:00-06 | 2021-05-09 01:27:00-06 | 70001 | 0x1 | /Satoshi:0.8.6/ | 2000 | 70001 | t 76.77.185.10 | 8333 | 346455 | Alive | 2021-05-09 08:08:00-06 | 2021-05-09 08:09:00-06 | 70002 | 0x1 | /Satoshi:0.9.3/ | 1005 | 99999 | t 45.77.168.153 | 56792 | 680017 | Alive | 2021-05-09 08:05:00-06 | 2021-05-09 08:05:00-06 | 70002 | 0x1 | /Satoshi:0.9.4/ | 1002 | 70001 | t 37.139.102.73 | 8333 | 545335 | Busy? (No answer in 15 sec.) | 2021-05-09 08:04:00-06 | 2021-05-09 04:41:00-06 | 70002 | 0x1 | /Satoshi:0.9.5/ | 1002 | 99999 | t 178.62.233.72 | 8333 | 682516 | Violated BTC Protocol: Bad header length! | 2021-05-09 08:05:00-06 | 2021-05-07 23:28:00-06 | 70015 | 0x9 | /bcoin:2.1.2/ | 1001 | 99999 | t 207.154.255.238 | 8333 | 682729 | Could not connect! | 2021-05-09 08:05:00-06 | 2021-05-09 04:42:00-06 | 70015 | 0x9 | /bcoin:2.1.2/ | 1001 | 99999 | t 18.191.109.28 | 8333 | 682702 | Violated BTC Protocol: Bad header length! | 2021-05-09 08:05:00-06 | 2021-05-09 01:31:00-06 | 70015 | 0x9 | /bcoin:v1.0.2/ | 1001 | 70001 | t 35.185.237.65 | 8333 | 682660 | Violated BTC Protocol: Bad header length! | 2021-05-09 08:05:00-06 | 2021-05-08 19:39:00-06 | 70015 | 0x9 | /bcoin:2.1.2/ | 1001 | 99999 | t 34.74.26.21 | 8333 | 682666 | Could not connect! | 2021-05-09 08:46:00-06 | 2021-05-08 19:57:00-06 | 70015 | 0x9 | /bcoin:2.0.0-dev/ | 1001 | 99999 | t 68.183.147.68 | 8333 | 682747 | Could not connect! | 2021-05-09 08:05:00-06 | 2021-05-09 06:22:00-06 | 70015 | 0x9 | /bcoin:2.0.0/ | 1001 | 99999 | t 173.249.10.49 | 8333 | 677617 | Could not connect! | 2021-05-09 08:02:00-06 | 2021-05-08 20:59:00-06 | 70015 | 0x9 | /bcoin:2.1.2/ | 1001 | 99999 | t 216.229.241.250 | 8333 | 682503 | Could not connect! | 2021-05-09 08:05:00-06 | 2021-05-07 21:39:00-06 | 70015 | 0x9 | /bcoin:v1.0.2/ | 1001 | 99999 | t 51.161.105.193 | 8333 | 682679 | Could not connect! | 2021-05-09 09:16:00-06 | 2021-05-08 21:50:00-06 | 70015 | 0x9 | /bcoin:2.1.2/ | 1001 | 99999 | t 138.219.43.168 | 8333 | 682647 | Violated BTC Protocol: Bad header length! | 2021-05-09 08:05:00-06 | 2021-05-08 18:09:00-06 | 70015 | 0x9 | /bcoin:2.1.2/ | 1001 | 70001 | t 200.58.109.75 | 8333 | 682680 | Violated BTC Protocol: Bad header length! | 2021-05-09 08:05:00-06 | 2021-05-08 22:29:00-06 | 70015 | 0x9 | /bcoin:2.1.2/ | 1001 | 99999 | t 54.201.49.1 | 8333 | 682549 | Violated BTC Protocol: Bad header length! | 2021-05-09 08:05:00-06 | 2021-05-08 04:16:00-06 | 70015 | 0x9 | /bcoin:2.1.2/ | 1001 | 99999 | t 13.80.134.215 | 33890 | 651813 | Alive | 2021-05-09 08:05:00-06 | 2021-05-09 08:05:00-06 | 70015 | 0xd | /bcoin:2.1.2/ | 1001 | 99999 | t 159.89.42.205 | 8333 | 682759 | Alive | 2021-05-09 07:50:00-06 | 2021-05-09 07:50:00-06 | 70015 | 0x40d | /Satoshi:0.17.0/ | 1000 | 70001 | t 144.91.66.137 | 6455 | 16258 | Alive | 2021-05-09 08:05:00-06 | 2021-05-09 08:05:00-06 | 70002 | 0x1 | /MultiChain:0.2.0.11/ | 1000 | 70001 | t 90.189.123.103 | 8333 | 682773 | Alive | 2021-05-09 09:06:00-06 | 2021-05-09 09:07:00-06 | 70015 | 0x408 | /Satoshi:0.20.0/ | 1000 | 70001 | t 52.201.156.205 | 8333 | 682768 | Alive | 2021-05-09 08:53:00-06 | 2021-05-09 08:53:00-06 | 70015 | 0x40d | /Satoshi:0.16.3(bitcore)/ | 1000 | 70001 | t 202.166.152.149 | 8333 | 303960 | Could not connect! | 2021-05-09 08:05:00-06 | 2021-05-07 23:23:00-06 | 70001 | 0x1 | /Satoshi:0.8.5/ | 1000 | 99999 | t 72.65.246.83 | 8333 | 682761 | Alive | 2021-05-09 08:05:00-06 | 2021-05-09 08:05:00-06 | 70013 | 0x9 | /libbitcoin:3.6.0/ | 1000 | 99999 | t 72.65.246.84 | 8333 | 682761 | Alive | 2021-05-09 08:05:00-06 | 2021-05-09 08:05:00-06 | 70013 | 0x9 | /libbitcoin:3.6.0/ | 1000 | 99999 | t 74.129.229.9 | 8333 | 390016 | Busy? (No answer in 15 sec.) | 2021-05-09 08:05:00-06 | 2021-05-08 06:20:00-06 | 70002 | 0x1 | /Satoshi:0.9.2.1/ | 1000 | 70001 | t 102.182.126.120 | 8333 | 258354 | Busy? (No answer in 15 sec.) | 2021-05-09 08:45:00-06 | 2021-05-08 18:36:00-06 | 32400 | 0x1 | | 796 | 99999 | t 178.19.104.218 | 8333 | 682565 | Busy? (No answer in 15 sec.) | 2021-05-09 08:05:00-06 | 2021-05-08 06:20:00-06 | 70015 | 0x9 | /Gocoin:1.9.9pre/ | 501 | 70001 | t 47.6.129.142 | 8333 | 258354 | Busy? (No answer in 15 sec.) | 2021-05-09 08:46:00-06 | 2021-05-07 22:11:00-06 | 32400 | 0x1 | | 291 | 99999 | t 35.237.254.241 | 8333 | 682770 | Alive | 2021-05-09 09:00:00-06 | 2021-05-09 09:00:00-06 | 70002 | 0x1 | /Satoshi:0.10.3/ | 73 | 99999 | t 192.151.158.26 | 8333 | 682770 | Alive | 2021-05-09 08:59:00-06 | 2021-05-09 08:59:00-06 | 70001 | 0x1 | /therealbitcoin.org:0.7.0.1/ | 68 | 99999 | t 108.31.170.100 | 8333 | 682775 | Alive | 2021-05-09 09:12:00-06 | 2021-05-09 09:12:00-06 | 99999 | 0x1 | /therealbitcoin.org:0.9.99.99/ | 58 | 70001 | f 205.134.172.4 | 8333 | 682769 | Alive | 2021-05-09 08:57:00-06 | 2021-05-09 08:57:00-06 | 70001 | 0x1 | /therealbitcoin.org:0.7.0.1/ | 57 | 70001 | f 213.109.238.156 | 8333 | 682770 | Alive | 2021-05-09 08:58:00-06 | 2021-05-09 08:58:00-06 | 99999 | 0x1 | /therealbitcoin.org:0.9.99.99/ | 41 | 99999 | t 84.16.46.130 | 8333 | 479466 | Could not connect! | 2021-05-09 08:59:00-06 | 2021-05-07 15:10:00-06 | 99999 | 0x1 | /therealbitcoin.org:0.9.99.99/ | 32 | 99999 | t 205.134.172.6 | 8333 | 682770 | Alive | 2021-05-09 09:01:00-06 | 2021-05-09 09:01:00-06 | 99999 | 0x1 | /therealbitcoin.org:0.9.99.99/ | 31 | 99999 | t 196.234.208.70 | 8333 | 146113 | Alive | 2021-05-09 09:13:00-06 | 2021-05-09 09:13:00-06 | 40000 | 0x1 | | 30 | 99999 | t 103.36.92.112 | 8333 | 682752 | Busy? (No answer in 15 sec.) | 2021-05-09 08:59:00-06 | 2021-05-09 07:10:00-06 | 99999 | 0x1 | /therealbitcoin.org:0.9.99.99/ | 30 | 99999 | t 82.79.58.192 | 8333 | 682761 | Alive | 2021-05-09 08:01:00-06 | 2021-05-09 08:01:00-06 | 99999 | 0x1 | /therealbitcoin.org:0.9.99.99/ | 18 | 99999 | t 205.134.172.26 | 8333 | 682438 | Alive | 2021-05-09 08:58:00-06 | 2021-05-09 08:58:00-06 | 99999 | 0x1 | /therealbitcoin.org:0.9.99.99/ | 12 | 99999 | t 205.134.172.28 | 8333 | 682754 | Alive | 2021-05-09 09:01:00-06 | 2021-05-09 09:01:00-06 | 99999 | 0x1 | /therealbitcoin.org:0.9.99.99/ | 9 | 99999 | t (52 rows) SELECT COUNT(*) FROM nodes; count -------- 105037 (1 row) SELECT COUNT(*) FROM nodes WHERE user_agent IS NOT NULL; count ------- 8580 (1 row) SELECT COUNT(*) FROM nodes WHERE ARRAY_LENGTH(peers,1) = 1; count ------- 2920 (1 row) SELECT COUNT(*) FROM nodes WHERE ARRAY_LENGTH(peers,1) > 1; count ------- 52 (1 row) SELECT COUNT(*) FROM nodes WHERE user_agent LIKE '%therealbitcoin.org%'; count ------- 16 (1 row)