/
gce-instances.sql
62 lines (61 loc) · 5.48 KB
/
gce-instances.sql
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
insert into cloud_instances(provider,date_observed,region,name,cpu,ram,cost) values
('Google Compute Engine','2018-07-06','us-central1','n1-standard-1',1,3.75,0.0475)
,('Google Compute Engine','2018-07-06','us-central1','n1-standard-2',2,7.5,0.0950)
,('Google Compute Engine','2018-07-06','us-central1','n1-standard-4',4,15,0.1900)
,('Google Compute Engine','2018-07-06','us-central1','n1-standard-8',8,30,0.3800)
,('Google Compute Engine','2018-07-06','us-central1','n1-standard-16',16,60,0.7600)
,('Google Compute Engine','2018-07-06','us-central1','n1-standard-32',32,120,1.5200)
,('Google Compute Engine','2018-07-06','us-central1','n1-standard-64',64,240,3.0400)
,('Google Compute Engine','2018-07-06','us-central1','n1-standard-96',96,360,4.5600)
,('Google Compute Engine','2018-07-06','us-central1','f1-micro',1,0.60,0.0076)
,('Google Compute Engine','2018-07-06','us-central1','g1-small',1,1.70,0.0257)
,('Google Compute Engine','2018-07-06','us-central1','n1-highmem-2',2,13,0.1184)
,('Google Compute Engine','2018-07-06','us-central1','n1-highmem-4',4,26,0.2368)
,('Google Compute Engine','2018-07-06','us-central1','n1-highmem-8',8,52,0.4736)
,('Google Compute Engine','2018-07-06','us-central1','n1-highmem-16',16,104,0.9472)
,('Google Compute Engine','2018-07-06','us-central1','n1-highmem-32',32,208,1.8944)
,('Google Compute Engine','2018-07-06','us-central1','n1-highmem-64',64,416,3.7888)
,('Google Compute Engine','2018-07-06','us-central1','n1-highmem-96',96,624,5.6832)
,('Google Compute Engine','2018-07-06','us-central1','n1-highcpu-2',2,1.80,0.0709)
,('Google Compute Engine','2018-07-06','us-central1','n1-highcpu-4',4,3.60,0.1418)
,('Google Compute Engine','2018-07-06','us-central1','n1-highcpu-8',8,7.20,0.2836)
,('Google Compute Engine','2018-07-06','us-central1','n1-highcpu-16',16,14.40,0.5672)
,('Google Compute Engine','2018-07-06','us-central1','n1-highcpu-32',32,28.80,1.1344)
,('Google Compute Engine','2018-07-06','us-central1','n1-highcpu-64',64,57.6,2.2688)
,('Google Compute Engine','2018-07-06','us-central1','n1-highcpu-96',96,86.4,3.402)
,('Google Compute Engine','2018-07-06','us-central1','n1-ultramem-40',40,938,6.3039)
,('Google Compute Engine','2018-07-06','us-central1','n1-ultramem-80',80,1922,12.6078)
,('Google Compute Engine','2018-07-06','us-central1','n1-megamem-96',96,1433.6,10.6740)
,('Google Compute Engine','2018-07-06','us-central1','n1-ultramem-160',160,3844,25.2156)
;
# Preemptibles
insert into cloud_instances(provider, date_observed, region, name, cpu, ram, cost) values
('Google Compute Engine', '2018-07-21', 'us-central1', 'n1-standard-1 preemptible', 1, 3.75, 0.0100)
,('Google Compute Engine', '2018-07-21', 'us-central1', 'n1-standard-2 preemptible', 2, 7.5, 0.0200)
,('Google Compute Engine', '2018-07-21', 'us-central1', 'n1-standard-4 preemptible', 4, 15, 0.0400)
,('Google Compute Engine', '2018-07-21', 'us-central1', 'n1-standard-8 preemptible', 8, 30, 0.0800)
,('Google Compute Engine', '2018-07-21', 'us-central1', 'n1-standard-16 preemptible', 16, 60, 0.1600)
,('Google Compute Engine', '2018-07-21', 'us-central1', 'n1-standard-32 preemptible', 32, 120, 0.3200)
,('Google Compute Engine', '2018-07-21', 'us-central1', 'n1-standard-64 preemptible', 64, 240, 0.6400)
,('Google Compute Engine', '2018-07-21', 'us-central1', 'n1-standard-96 preemptible', 96, 360, 0.9600)
,('Google Compute Engine', '2018-07-21', 'us-central1', 'f1-micro preemptible', 1, 0.60, 0.0035)
,('Google Compute Engine', '2018-07-21', 'us-central1', 'g1-small preemptible', 1, 1.70, 0.0070)
,('Google Compute Engine', '2018-07-21', 'us-central1', 'n1-highmem-2 preemptible', 2, 13, 0.0250)
,('Google Compute Engine', '2018-07-21', 'us-central1', 'n1-highmem-4 preemptible', 4, 26, 0.0500)
,('Google Compute Engine', '2018-07-21', 'us-central1', 'n1-highmem-8 preemptible', 8, 52, 0.1000)
,('Google Compute Engine', '2018-07-21', 'us-central1', 'n1-highmem-16 preemptible', 16, 104, 0.2000)
,('Google Compute Engine', '2018-07-21', 'us-central1', 'n1-highmem-32 preemptible', 32, 208, 0.4000)
,('Google Compute Engine', '2018-07-21', 'us-central1', 'n1-highmem-64 preemptible', 64, 416, 0.8000)
,('Google Compute Engine', '2018-07-21', 'us-central1', 'n1-highmem-96 preemptible', 96, 624, 1.2000)
,('Google Compute Engine', '2018-07-21', 'us-central1', 'n1-highcpu-2 preemptible', 2, 1.80, 0.0150)
,('Google Compute Engine', '2018-07-21', 'us-central1', 'n1-highcpu-4 preemptible', 4, 3.60, 0.0300)
,('Google Compute Engine', '2018-07-21', 'us-central1', 'n1-highcpu-8 preemptible', 8, 7.20, 0.0600)
,('Google Compute Engine', '2018-07-21', 'us-central1', 'n1-highcpu-16 preemptible', 16, 14.40, 0.1200)
,('Google Compute Engine', '2018-07-21', 'us-central1', 'n1-highcpu-32 preemptible', 32, 28.80, 0.2400)
,('Google Compute Engine', '2018-07-21', 'us-central1', 'n1-highcpu-64 preemptible', 64, 57.6, 0.4800)
,('Google Compute Engine', '2018-07-21', 'us-central1', 'n1-highcpu-96 preemptible', 96, 86.4, 0.7200)
,('Google Compute Engine', '2018-07-21', 'us-central1', 'n1-ultramem-40 preemptible', 40, 938, 1.3311)
,('Google Compute Engine', '2018-07-21', 'us-central1', 'n1-ultramem-80 preemptible', 80, 1922, 2.6622)
,('Google Compute Engine', '2018-07-21', 'us-central1', 'n1-megamem-96 preemptible', 96, 1433.6, 2.2600)
,('Google Compute Engine', '2018-07-21', 'us-central1', 'n1-ultramem-160 preemptible', 160, 3844, 5.3244)
;