-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathdatabase-eg.txt
More file actions
executable file
·72 lines (62 loc) · 4.8 KB
/
database-eg.txt
File metadata and controls
executable file
·72 lines (62 loc) · 4.8 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
ixmaps=# \d
List of relations
Schema | Name | Type | Owner
--------+-------------------+----------+--------
public | ip_addr_info | table | ixmaps
public | tr_item | table | ixmaps
public | traceroute | table | ixmaps
public | traceroute_id_seq | sequence | ixmaps
(4 rows)
ixmaps=# select * from ip_addr_info limit 12;
ip_addr | asnum | lat | long | hostname
-----------------+-------+---------+----------+-------------------------------------------
222.222.222.222 | 17672 | 39.9289 | 116.388 | 222.222.222.222
206.223.115.12 | 1273 | 37.555 | -122.269 | xe-0.equinix.asbnva01.us.bb.gin.ntt.net
97.74.5.196 | 26496 | 33.6119 | -111.891 | ip-97-74-5-196.ip.secureserver.net
12.6.7.8 | 7018 | 45.4691 | -122.553 | 12.6.7.8
10.1.1.1 | 3303 | 0 | 0 | 10.1.1.1
11.11.11.0 | 3303 | 38 | -97 | 11.11.11.0
22.22.22.22 | 3303 | 38 | -97 | 22.22.22.22
33.66.66.66 | 27064 | 38 | -97 | 33.66.66.66
33.77.77.88 | 27064 | 38 | -97 | 33.77.77.88
66.77.88.99 | 209 | 34.1374 | -118.353 | 66.77.88.99
99.88.77.66 | 3303 | 38 | -97 | adsl-99-88-77-66.dsl.frs2ca.sbcglobal.net
128.1.2.3 | 11488 | 42.38 | -71.1329 | 128.1.2.3
(12 rows)
ixmaps=# select * from tr_item limit 12;
traceroute_id | hop | attempt | status | ip_addr | rtt_ms
---------------+-----+---------+--------+-------------+--------
13 | 1 | 1 | c | 12.4.5.1 | 12
13 | 1 | 2 | c | 12.4.5.1 | 17
13 | 2 | 1 | c | 33.66.66.66 | 45
13 | 3 | 1 | d | 44.66.77.88 | 71
13 | 3 | 2 | t | 44.66.77.88 | 65
14 | 1 | 1 | c | 12.4.5.1 | 12
14 | 1 | 2 | c | 12.4.5.1 | 17
14 | 2 | 1 | c | 33.66.66.66 | 45
14 | 2 | 2 | c | 33.66.66.66 | 42
14 | 3 | 1 | d | 44.66.77.88 | 71
14 | 3 | 2 | t | 44.66.77.88 | 65
15 | 1 | 1 | c | 12.4.5.1 | 12
(12 rows)
ixmaps=> select * from traceroute limit 12;
id | sub_time | dest | dest_ip | submitter | zip_code | privacy | timeout | protocol | maxhops | status | attempts
----+------------------------+------------------+-----------------+-----------+------------+---------+---------+----------+---------+--------+----------
1 | 2009-09-03 18:39:04-04 | www.ixmaps.ca | 206.248.138.108 | Private12 | M5S 1C7 | 8 | 1 | i | 255 | i | 4
2 | 2009-09-06 19:26:13-04 | uvic.ca | 142.104.193.247 | Ellen72 | M6G 4M1 | 8 | 1 | i | 255 | c | 4
3 | 2009-09-06 19:26:31-04 | www.unbc.ca | 142.207.144.140 | Matthew | 12345-0002 | 8 | 1 | i | 255 | i | 4
4 | 2009-09-06 19:26:37-04 | athabascau.ca | 131.232.31.232 | Graeme F. | 00124 | 8 | 1 | i | 255 | c | 4
5 | 2009-09-06 19:26:45-04 | www.usask.ca | 128.233.192.253 | Bonnie | 99123-1111 | 8 | 1 | i | 255 | i | 4
6 | 2009-09-06 19:26:51-04 | www.umanitoba.ca | 130.179.16.50 | Michael | V8B 1A3 | 8 | 1 | i | 255 | c | 4
7 | 2009-09-06 19:26:58-04 | www.lakeheadu.ca | 65.39.15.214 | Isabel | R2B 2H6 | 8 | 1 | i | 255 | c | 4
8 | 2009-09-06 19:27:05-04 | www.uwindsor.ca | 137.207.71.197 | Lewis B. | B3N 4Y2 | 8 | 1 | i | 255 | i | 4
9 | 2009-09-06 19:27:11-04 | www.utoronto.ca | 142.150.210.13 | Loretta B | 46122 | 8 | 1 | i | 255 | c | 4
10 | 2009-09-06 19:27:17-04 | www.yorku.ca | 130.63.236.137 | Tom | 35167 | 8 | 1 | i | 255 | c | 4
11 | 2009-09-06 19:27:24-04 | www.uottawa.ca | 137.122.14.11 | Ian04 | 85102 | 8 | 1 | i | 255 | i | 4
12 | 2009-09-06 19:27:31-04 | www.umontreal.ca | 132.204.5.67 | Franklin | 90102 | 8 | 1 | i | 255 | c | 4
(12 rows)
ixmaps=# select * from traceroute_id_seq;
sequence_name | last_value | increment_by | max_value | min_value | cache_value | log_cnt | is_cycled | is_called
-------------------+------------+--------------+---------------------+-----------+-------------+---------+-----------+-----------
traceroute_id_seq | 541 | 1 | 9223372036854775807 | 1 | 1 | 32 | f | t
(1 row)