This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
➜ LocustDB git:(master) git pull | |
Enter passphrase for key '/home/clemens/.ssh/id_rsa': | |
remote: Counting objects: 17, done. | |
remote: Compressing objects: 100% (4/4), done. | |
remote: Total 17 (delta 11), reused 17 (delta 11), pack-reused 0 | |
Unpacking objects: 100% (17/17), done. | |
From github.com:cswinter/LocustDB | |
106acb1..a10d938 master -> origin/master | |
Updating 106acb1..a10d938 | |
Fast-forward | |
src/bin/repl/main.rs | 53 ++++++++++++++++++++++++++++++++++---------------- | |
src/ingest/csv_loader.rs | 18 ++++++++--------- | |
src/ingest/nyc_taxi_data.rs | 81 ++++++++++++++++++++++++++++++++++++++++++----------------------------------- | |
src/mem_store/integers.rs | 28 ++++++++++++++------------- | |
tests/query_tests.rs | 24 +++++++++-------------- | |
5 files changed, 112 insertions(+), 92 deletions(-) | |
➜ LocustDB git:(master) sudo cpupower frequency-set -g performance | |
[sudo] password for clemens: | |
Setting cpu: 0 | |
Setting cpu: 1 | |
Setting cpu: 2 | |
Setting cpu: 3 | |
Setting cpu: 4 | |
Setting cpu: 5 | |
Setting cpu: 6 | |
Setting cpu: 7 | |
Setting cpu: 8 | |
Setting cpu: 9 | |
Setting cpu: 10 | |
Setting cpu: 11 | |
➜ LocustDB git:(master) RUSTFLAGS="-Ccodegen-units=1" CARGO_INCREMENTAL=0 cargo run --release --bin repl -- nyc | |
Compiling either v1.4.0 | |
Compiling unicode-xid v0.0.4 | |
Compiling cc v1.0.17 | |
Compiling libc v0.2.39 | |
Compiling unicode-xid v0.1.0 | |
Compiling num-traits v0.2.1 | |
Compiling quote v0.3.15 | |
Compiling rustc-serialize v0.3.24 | |
Compiling void v1.0.2 | |
Compiling rustc-demangle v0.1.7 | |
Compiling lazy_static v1.0.0 | |
Compiling bitflags v0.4.0 | |
Compiling ucd-util v0.1.1 | |
Compiling heapsize v0.3.9 | |
Compiling cfg-if v0.1.2 | |
Compiling regex v0.2.10 | |
Compiling itoa v0.3.4 | |
Compiling encode_unicode v0.1.3 | |
Compiling unicode-width v0.1.4 | |
Compiling byteorder v1.2.1 | |
Compiling serde v1.0.33 | |
Compiling serde v0.9.15 | |
Compiling dtoa v0.4.2 | |
Compiling utf8-ranges v1.0.0 | |
Compiling bit-vec v0.4.4 | |
Compiling seahash v3.0.5 | |
Compiling fnv v1.0.6 | |
Compiling unreachable v1.0.0 | |
Compiling proc-macro2 v0.2.3 | |
Compiling synom v0.11.3 | |
Compiling log v0.4.1 | |
Compiling futures-core v0.2.0-alpha | |
Compiling itertools v0.5.10 | |
Compiling regex-syntax v0.5.3 | |
Compiling iovec v0.1.2 | |
Compiling rand v0.4.2 | |
Compiling memchr v2.0.1 | |
Compiling num_cpus v1.8.0 | |
Compiling memchr v1.0.2 | |
Compiling time v0.1.39 | |
Compiling nix v0.5.1 | |
Compiling thread_local v0.3.5 | |
Compiling syn v0.11.11 | |
Compiling num-integer v0.1.36 | |
Compiling num-traits v0.1.43 | |
Compiling futures-channel v0.2.0-alpha | |
Compiling futures-io v0.2.0-alpha | |
Compiling aho-corasick v0.6.4 | |
Compiling csv-core v0.1.4 | |
Compiling nom v3.2.1 | |
Compiling num-iter v0.1.35 | |
Compiling futures-sink v0.2.0-alpha | |
Compiling futures-util v0.2.0-alpha | |
Compiling rustyline v1.0.0 | |
Compiling backtrace-sys v0.1.16 | |
Compiling miniz-sys v0.1.10 | |
Compiling futures-executor v0.2.0-alpha | |
Compiling quote v0.4.2 | |
Compiling syn v0.12.14 | |
Compiling num-bigint v0.1.43 | |
Compiling num-complex v0.1.43 | |
Compiling serde_json v0.9.10 | |
Compiling flate2 v1.0.1 | |
Compiling futures v0.2.0-alpha | |
Compiling csv v1.0.0 | |
Compiling bincode v0.9.2 | |
Compiling num-rational v0.1.42 | |
Compiling backtrace v0.3.5 | |
Compiling synstructure v0.6.1 | |
Compiling num v0.1.42 | |
Compiling chrono v0.4.0 | |
Compiling failure_derive v0.1.1 | |
Compiling failure v0.1.1 | |
Compiling serde_derive_internals v0.21.0 | |
Compiling serde_derive v1.0.33 | |
Compiling locustdb v0.1.0 (file:///home/clemens/src/LocustDB) | |
Finished release [optimized] target(s) in 1m 24s | |
Running `target/release/repl nyc` | |
Loading nyc into table trips. | |
Loaded data in 1174 seconds. | |
# Table `_meta_tables` (2 rows, 0.00 MiB) # | |
name: 0.00MiB | |
timestamp: 0.00MiB | |
# Table `trips` (1464785771 rows, 42610.88 MiB) # | |
rate_code_id: 1235.83MiB | |
trip_id: 5589.44MiB | |
store_and_fwd_flag: 1397.63MiB | |
payment_type: 1397.69MiB | |
dropoff_puma: 2611.38MiB | |
improvement_surcharge: 1401.48MiB | |
total_amount: 3697.29MiB | |
passenger_count: 1397.46MiB | |
trip_distance: 5528.60MiB | |
pickup_puma: 2611.38MiB | |
vendor_id: 1397.58MiB | |
pickup_cdeligibil: 1214.21MiB | |
pickup_ntaname: 1225.83MiB | |
pickup_datetime: 5588.67MiB | |
cab_type: 1397.53MiB | |
trip_type: 62.35MiB | |
mta_tax: 1669.69MiB | |
ehail_fee: 1397.46MiB | |
snowfall: 1788.64MiB | |
locustdb> SELECT cab_type, count(0) FROM trips; | |
Scanned 1464785771 rows in 256ms (5.71B rows/s)! | |
cab_type | count_0 | |
---------+------------ | |
"green" | 64407776 | |
"yellow" | 1400377995 | |
locustdb> SELECT cab_type, count(0) FROM trips; | |
Scanned 1464785771 rows in 251ms (5.82B rows/s)! | |
cab_type | count_0 | |
---------+------------ | |
"green" | 64407776 | |
"yellow" | 1400377995 | |
locustdb> SELECT cab_type, count(0) FROM trips; | |
Scanned 1464785771 rows in 253ms (5.78B rows/s)! | |
cab_type | count_0 | |
---------+------------ | |
"green" | 64407776 | |
"yellow" | 1400377995 | |
locustdb> SELECT cab_type, count(0) FROM trips; | |
Scanned 1464785771 rows in 253ms (5.79B rows/s)! | |
cab_type | count_0 | |
---------+------------ | |
"green" | 64407776 | |
"yellow" | 1400377995 | |
locustdb> SELECT cab_type, count(0) FROM trips; | |
Scanned 1464785771 rows in 252ms (5.79B rows/s)! | |
cab_type | count_0 | |
---------+------------ | |
"green" | 64407776 | |
"yellow" | 1400377995 | |
locustdb> SELECT cab_type, count(0) FROM trips; | |
Scanned 1464785771 rows in 251ms (5.82B rows/s)! | |
cab_type | count_0 | |
---------+------------ | |
"green" | 64407776 | |
"yellow" | 1400377995 | |
locustdb> SELECT cab_type, count(0) FROM trips; | |
Scanned 1464785771 rows in 253ms (5.78B rows/s)! | |
cab_type | count_0 | |
---------+------------ | |
"green" | 64407776 | |
"yellow" | 1400377995 | |
locustdb> SELECT cab_type, count(0) FROM trips; | |
Scanned 1464785771 rows in 251ms (5.84B rows/s)! | |
cab_type | count_0 | |
---------+------------ | |
"green" | 64407776 | |
"yellow" | 1400377995 | |
locustdb> SELECT cab_type, count(0) FROM trips; | |
Scanned 1464785771 rows in 252ms (5.79B rows/s)! | |
cab_type | count_0 | |
---------+------------ | |
"green" | 64407776 | |
"yellow" | 1400377995 | |
locustdb> SELECT cab_type, count(0) FROM trips; | |
Scanned 1464785771 rows in 252ms (5.79B rows/s)! | |
cab_type | count_0 | |
---------+------------ | |
"green" | 64407776 | |
"yellow" | 1400377995 | |
locustdb> SELECT passenger_count, count(0), sum(total_amount) FROM trips; | |
Scanned 1464785771 rows in 541ms (2.70B rows/s)! | |
passenger_count | count_0 | sum_1 | |
----------------+------------+--------------- | |
0 | 4107443 | 4509842206 | |
1 | 1028187597 | 1425303818216 | |
2 | 210577025 | 304718353489 | |
3 | 62345389 | 87788492212 | |
4 | 29994987 | 42514355874 | |
5 | 95184622 | 130181002616 | |
6 | 34380600 | 51063741303 | |
7 | 2595 | 8693795 | |
8 | 2525 | 8272055 | |
9 | 1367 | 7196690 | |
10 | 17 | 75470 | |
13 | 1 | 3150 | |
15 | 2 | 2410 | |
17 | 1 | 3995 | |
19 | 1 | 500 | |
25 | 1 | 760 | |
33 | 2 | 1719 | |
34 | 1 | 1680 | |
36 | 1 | 6155 | |
37 | 1 | 1420 | |
38 | 1 | 730 | |
47 | 1 | 900 | |
49 | 26 | 8440 | |
53 | 1 | 730 | |
58 | 2 | 5188 | |
61 | 1 | 3134 | |
65 | 3 | 7010 | |
66 | 1 | 1930 | |
69 | 1 | 580 | |
70 | 1 | 1070 | |
84 | 1 | 4384 | |
97 | 1 | 990 | |
113 | 1 | 1330 | |
125 | 1 | 1660 | |
129 | 7 | 6150 | |
133 | 1 | 1030 | |
134 | 1 | 5514 | |
137 | 1 | 5964 | |
141 | 1 | 1894 | |
155 | 1 | 9024 | |
158 | 1 | 1444 | |
160 | 1 | 1534 | |
163 | 1 | 1554 | |
164 | 1 | 6214 | |
165 | 1 | 1214 | |
177 | 1 | 1700 | |
192 | 1 | 953 | |
193 | 1 | 750 | |
208 | 1508 | 1062534 | |
211 | 1 | 700 | |
213 | 4 | 1000 | |
223 | 1 | 950 | |
225 | 1 | 1600 | |
247 | 1 | 1944 | |
249 | 1 | 950 | |
250 | 3 | 3770 | |
254 | 1 | 650 | |
255 | 10 | 17990 | |
locustdb> SELECT passenger_count, count(0), sum(total_amount) FROM trips; | |
Scanned 1464785771 rows in 536ms (2.73B rows/s)! | |
passenger_count | count_0 | sum_1 | |
----------------+------------+--------------- | |
0 | 4107443 | 4509842206 | |
1 | 1028187597 | 1425303818216 | |
2 | 210577025 | 304718353489 | |
3 | 62345389 | 87788492212 | |
4 | 29994987 | 42514355874 | |
5 | 95184622 | 130181002616 | |
6 | 34380600 | 51063741303 | |
7 | 2595 | 8693795 | |
8 | 2525 | 8272055 | |
9 | 1367 | 7196690 | |
10 | 17 | 75470 | |
13 | 1 | 3150 | |
15 | 2 | 2410 | |
17 | 1 | 3995 | |
19 | 1 | 500 | |
25 | 1 | 760 | |
33 | 2 | 1719 | |
34 | 1 | 1680 | |
36 | 1 | 6155 | |
37 | 1 | 1420 | |
38 | 1 | 730 | |
47 | 1 | 900 | |
49 | 26 | 8440 | |
53 | 1 | 730 | |
58 | 2 | 5188 | |
61 | 1 | 3134 | |
65 | 3 | 7010 | |
66 | 1 | 1930 | |
69 | 1 | 580 | |
70 | 1 | 1070 | |
84 | 1 | 4384 | |
97 | 1 | 990 | |
113 | 1 | 1330 | |
125 | 1 | 1660 | |
129 | 7 | 6150 | |
133 | 1 | 1030 | |
134 | 1 | 5514 | |
137 | 1 | 5964 | |
141 | 1 | 1894 | |
155 | 1 | 9024 | |
158 | 1 | 1444 | |
160 | 1 | 1534 | |
163 | 1 | 1554 | |
164 | 1 | 6214 | |
165 | 1 | 1214 | |
177 | 1 | 1700 | |
192 | 1 | 953 | |
193 | 1 | 750 | |
208 | 1508 | 1062534 | |
211 | 1 | 700 | |
213 | 4 | 1000 | |
223 | 1 | 950 | |
225 | 1 | 1600 | |
247 | 1 | 1944 | |
249 | 1 | 950 | |
250 | 3 | 3770 | |
254 | 1 | 650 | |
255 | 10 | 17990 | |
locustdb> SELECT passenger_count, count(0), sum(total_amount) FROM trips; | |
Scanned 1464785771 rows in 539ms (2.71B rows/s)! | |
passenger_count | count_0 | sum_1 | |
----------------+------------+--------------- | |
0 | 4107443 | 4509842206 | |
1 | 1028187597 | 1425303818216 | |
2 | 210577025 | 304718353489 | |
3 | 62345389 | 87788492212 | |
4 | 29994987 | 42514355874 | |
5 | 95184622 | 130181002616 | |
6 | 34380600 | 51063741303 | |
7 | 2595 | 8693795 | |
8 | 2525 | 8272055 | |
9 | 1367 | 7196690 | |
10 | 17 | 75470 | |
13 | 1 | 3150 | |
15 | 2 | 2410 | |
17 | 1 | 3995 | |
19 | 1 | 500 | |
25 | 1 | 760 | |
33 | 2 | 1719 | |
34 | 1 | 1680 | |
36 | 1 | 6155 | |
37 | 1 | 1420 | |
38 | 1 | 730 | |
47 | 1 | 900 | |
49 | 26 | 8440 | |
53 | 1 | 730 | |
58 | 2 | 5188 | |
61 | 1 | 3134 | |
65 | 3 | 7010 | |
66 | 1 | 1930 | |
69 | 1 | 580 | |
70 | 1 | 1070 | |
84 | 1 | 4384 | |
97 | 1 | 990 | |
113 | 1 | 1330 | |
125 | 1 | 1660 | |
129 | 7 | 6150 | |
133 | 1 | 1030 | |
134 | 1 | 5514 | |
137 | 1 | 5964 | |
141 | 1 | 1894 | |
155 | 1 | 9024 | |
158 | 1 | 1444 | |
160 | 1 | 1534 | |
163 | 1 | 1554 | |
164 | 1 | 6214 | |
165 | 1 | 1214 | |
177 | 1 | 1700 | |
192 | 1 | 953 | |
193 | 1 | 750 | |
208 | 1508 | 1062534 | |
211 | 1 | 700 | |
213 | 4 | 1000 | |
223 | 1 | 950 | |
225 | 1 | 1600 | |
247 | 1 | 1944 | |
249 | 1 | 950 | |
250 | 3 | 3770 | |
254 | 1 | 650 | |
255 | 10 | 17990 | |
locustdb> SELECT passenger_count, count(0), sum(total_amount) FROM trips; | |
Scanned 1464785771 rows in 536ms (2.73B rows/s)! | |
passenger_count | count_0 | sum_1 | |
----------------+------------+--------------- | |
0 | 4107443 | 4509842206 | |
1 | 1028187597 | 1425303818216 | |
2 | 210577025 | 304718353489 | |
3 | 62345389 | 87788492212 | |
4 | 29994987 | 42514355874 | |
5 | 95184622 | 130181002616 | |
6 | 34380600 | 51063741303 | |
7 | 2595 | 8693795 | |
8 | 2525 | 8272055 | |
9 | 1367 | 7196690 | |
10 | 17 | 75470 | |
13 | 1 | 3150 | |
15 | 2 | 2410 | |
17 | 1 | 3995 | |
19 | 1 | 500 | |
25 | 1 | 760 | |
33 | 2 | 1719 | |
34 | 1 | 1680 | |
36 | 1 | 6155 | |
37 | 1 | 1420 | |
38 | 1 | 730 | |
47 | 1 | 900 | |
49 | 26 | 8440 | |
53 | 1 | 730 | |
58 | 2 | 5188 | |
61 | 1 | 3134 | |
65 | 3 | 7010 | |
66 | 1 | 1930 | |
69 | 1 | 580 | |
70 | 1 | 1070 | |
84 | 1 | 4384 | |
97 | 1 | 990 | |
113 | 1 | 1330 | |
125 | 1 | 1660 | |
129 | 7 | 6150 | |
133 | 1 | 1030 | |
134 | 1 | 5514 | |
137 | 1 | 5964 | |
141 | 1 | 1894 | |
155 | 1 | 9024 | |
158 | 1 | 1444 | |
160 | 1 | 1534 | |
163 | 1 | 1554 | |
164 | 1 | 6214 | |
165 | 1 | 1214 | |
177 | 1 | 1700 | |
192 | 1 | 953 | |
193 | 1 | 750 | |
208 | 1508 | 1062534 | |
211 | 1 | 700 | |
213 | 4 | 1000 | |
223 | 1 | 950 | |
225 | 1 | 1600 | |
247 | 1 | 1944 | |
249 | 1 | 950 | |
250 | 3 | 3770 | |
254 | 1 | 650 | |
255 | 10 | 17990 | |
locustdb> SELECT passenger_count, count(0), sum(total_amount) FROM trips; | |
Scanned 1464785771 rows in 537ms (2.73B rows/s)! | |
passenger_count | count_0 | sum_1 | |
----------------+------------+--------------- | |
0 | 4107443 | 4509842206 | |
1 | 1028187597 | 1425303818216 | |
2 | 210577025 | 304718353489 | |
3 | 62345389 | 87788492212 | |
4 | 29994987 | 42514355874 | |
5 | 95184622 | 130181002616 | |
6 | 34380600 | 51063741303 | |
7 | 2595 | 8693795 | |
8 | 2525 | 8272055 | |
9 | 1367 | 7196690 | |
10 | 17 | 75470 | |
13 | 1 | 3150 | |
15 | 2 | 2410 | |
17 | 1 | 3995 | |
19 | 1 | 500 | |
25 | 1 | 760 | |
33 | 2 | 1719 | |
34 | 1 | 1680 | |
36 | 1 | 6155 | |
37 | 1 | 1420 | |
38 | 1 | 730 | |
47 | 1 | 900 | |
49 | 26 | 8440 | |
53 | 1 | 730 | |
58 | 2 | 5188 | |
61 | 1 | 3134 | |
65 | 3 | 7010 | |
66 | 1 | 1930 | |
69 | 1 | 580 | |
70 | 1 | 1070 | |
84 | 1 | 4384 | |
97 | 1 | 990 | |
113 | 1 | 1330 | |
125 | 1 | 1660 | |
129 | 7 | 6150 | |
133 | 1 | 1030 | |
134 | 1 | 5514 | |
137 | 1 | 5964 | |
141 | 1 | 1894 | |
155 | 1 | 9024 | |
158 | 1 | 1444 | |
160 | 1 | 1534 | |
163 | 1 | 1554 | |
164 | 1 | 6214 | |
165 | 1 | 1214 | |
177 | 1 | 1700 | |
192 | 1 | 953 | |
193 | 1 | 750 | |
208 | 1508 | 1062534 | |
211 | 1 | 700 | |
213 | 4 | 1000 | |
223 | 1 | 950 | |
225 | 1 | 1600 | |
247 | 1 | 1944 | |
249 | 1 | 950 | |
250 | 3 | 3770 | |
254 | 1 | 650 | |
255 | 10 | 17990 | |
locustdb> SELECT passenger_count, count(0), sum(total_amount) FROM trips; | |
Scanned 1464785771 rows in 536ms (2.73B rows/s)! | |
passenger_count | count_0 | sum_1 | |
----------------+------------+--------------- | |
0 | 4107443 | 4509842206 | |
1 | 1028187597 | 1425303818216 | |
2 | 210577025 | 304718353489 | |
3 | 62345389 | 87788492212 | |
4 | 29994987 | 42514355874 | |
5 | 95184622 | 130181002616 | |
6 | 34380600 | 51063741303 | |
7 | 2595 | 8693795 | |
8 | 2525 | 8272055 | |
9 | 1367 | 7196690 | |
10 | 17 | 75470 | |
13 | 1 | 3150 | |
15 | 2 | 2410 | |
17 | 1 | 3995 | |
19 | 1 | 500 | |
25 | 1 | 760 | |
33 | 2 | 1719 | |
34 | 1 | 1680 | |
36 | 1 | 6155 | |
37 | 1 | 1420 | |
38 | 1 | 730 | |
47 | 1 | 900 | |
49 | 26 | 8440 | |
53 | 1 | 730 | |
58 | 2 | 5188 | |
61 | 1 | 3134 | |
65 | 3 | 7010 | |
66 | 1 | 1930 | |
69 | 1 | 580 | |
70 | 1 | 1070 | |
84 | 1 | 4384 | |
97 | 1 | 990 | |
113 | 1 | 1330 | |
125 | 1 | 1660 | |
129 | 7 | 6150 | |
133 | 1 | 1030 | |
134 | 1 | 5514 | |
137 | 1 | 5964 | |
141 | 1 | 1894 | |
155 | 1 | 9024 | |
158 | 1 | 1444 | |
160 | 1 | 1534 | |
163 | 1 | 1554 | |
164 | 1 | 6214 | |
165 | 1 | 1214 | |
177 | 1 | 1700 | |
192 | 1 | 953 | |
193 | 1 | 750 | |
208 | 1508 | 1062534 | |
211 | 1 | 700 | |
213 | 4 | 1000 | |
223 | 1 | 950 | |
225 | 1 | 1600 | |
247 | 1 | 1944 | |
249 | 1 | 950 | |
250 | 3 | 3770 | |
254 | 1 | 650 | |
255 | 10 | 17990 | |
locustdb> SELECT passenger_count, count(0), sum(total_amount) FROM trips; | |
Scanned 1464785771 rows in 537ms (2.72B rows/s)! | |
passenger_count | count_0 | sum_1 | |
----------------+------------+--------------- | |
0 | 4107443 | 4509842206 | |
1 | 1028187597 | 1425303818216 | |
2 | 210577025 | 304718353489 | |
3 | 62345389 | 87788492212 | |
4 | 29994987 | 42514355874 | |
5 | 95184622 | 130181002616 | |
6 | 34380600 | 51063741303 | |
7 | 2595 | 8693795 | |
8 | 2525 | 8272055 | |
9 | 1367 | 7196690 | |
10 | 17 | 75470 | |
13 | 1 | 3150 | |
15 | 2 | 2410 | |
17 | 1 | 3995 | |
19 | 1 | 500 | |
25 | 1 | 760 | |
33 | 2 | 1719 | |
34 | 1 | 1680 | |
36 | 1 | 6155 | |
37 | 1 | 1420 | |
38 | 1 | 730 | |
47 | 1 | 900 | |
49 | 26 | 8440 | |
53 | 1 | 730 | |
58 | 2 | 5188 | |
61 | 1 | 3134 | |
65 | 3 | 7010 | |
66 | 1 | 1930 | |
69 | 1 | 580 | |
70 | 1 | 1070 | |
84 | 1 | 4384 | |
97 | 1 | 990 | |
113 | 1 | 1330 | |
125 | 1 | 1660 | |
129 | 7 | 6150 | |
133 | 1 | 1030 | |
134 | 1 | 5514 | |
137 | 1 | 5964 | |
141 | 1 | 1894 | |
155 | 1 | 9024 | |
158 | 1 | 1444 | |
160 | 1 | 1534 | |
163 | 1 | 1554 | |
164 | 1 | 6214 | |
165 | 1 | 1214 | |
177 | 1 | 1700 | |
192 | 1 | 953 | |
193 | 1 | 750 | |
208 | 1508 | 1062534 | |
211 | 1 | 700 | |
213 | 4 | 1000 | |
223 | 1 | 950 | |
225 | 1 | 1600 | |
247 | 1 | 1944 | |
249 | 1 | 950 | |
250 | 3 | 3770 | |
254 | 1 | 650 | |
255 | 10 | 17990 | |
locustdb> SELECT passenger_count, count(0), sum(total_amount) FROM trips; | |
Scanned 1464785771 rows in 535ms (2.73B rows/s)! | |
passenger_count | count_0 | sum_1 | |
----------------+------------+--------------- | |
0 | 4107443 | 4509842206 | |
1 | 1028187597 | 1425303818216 | |
2 | 210577025 | 304718353489 | |
3 | 62345389 | 87788492212 | |
4 | 29994987 | 42514355874 | |
5 | 95184622 | 130181002616 | |
6 | 34380600 | 51063741303 | |
7 | 2595 | 8693795 | |
8 | 2525 | 8272055 | |
9 | 1367 | 7196690 | |
10 | 17 | 75470 | |
13 | 1 | 3150 | |
15 | 2 | 2410 | |
17 | 1 | 3995 | |
19 | 1 | 500 | |
25 | 1 | 760 | |
33 | 2 | 1719 | |
34 | 1 | 1680 | |
36 | 1 | 6155 | |
37 | 1 | 1420 | |
38 | 1 | 730 | |
47 | 1 | 900 | |
49 | 26 | 8440 | |
53 | 1 | 730 | |
58 | 2 | 5188 | |
61 | 1 | 3134 | |
65 | 3 | 7010 | |
66 | 1 | 1930 | |
69 | 1 | 580 | |
70 | 1 | 1070 | |
84 | 1 | 4384 | |
97 | 1 | 990 | |
113 | 1 | 1330 | |
125 | 1 | 1660 | |
129 | 7 | 6150 | |
133 | 1 | 1030 | |
134 | 1 | 5514 | |
137 | 1 | 5964 | |
141 | 1 | 1894 | |
155 | 1 | 9024 | |
158 | 1 | 1444 | |
160 | 1 | 1534 | |
163 | 1 | 1554 | |
164 | 1 | 6214 | |
165 | 1 | 1214 | |
177 | 1 | 1700 | |
192 | 1 | 953 | |
193 | 1 | 750 | |
208 | 1508 | 1062534 | |
211 | 1 | 700 | |
213 | 4 | 1000 | |
223 | 1 | 950 | |
225 | 1 | 1600 | |
247 | 1 | 1944 | |
249 | 1 | 950 | |
250 | 3 | 3770 | |
254 | 1 | 650 | |
255 | 10 | 17990 | |
locustdb> SELECT passenger_count, count(0), sum(total_amount) FROM trips; | |
Scanned 1464785771 rows in 537ms (2.73B rows/s)! | |
passenger_count | count_0 | sum_1 | |
----------------+------------+--------------- | |
0 | 4107443 | 4509842206 | |
1 | 1028187597 | 1425303818216 | |
2 | 210577025 | 304718353489 | |
3 | 62345389 | 87788492212 | |
4 | 29994987 | 42514355874 | |
5 | 95184622 | 130181002616 | |
6 | 34380600 | 51063741303 | |
7 | 2595 | 8693795 | |
8 | 2525 | 8272055 | |
9 | 1367 | 7196690 | |
10 | 17 | 75470 | |
13 | 1 | 3150 | |
15 | 2 | 2410 | |
17 | 1 | 3995 | |
19 | 1 | 500 | |
25 | 1 | 760 | |
33 | 2 | 1719 | |
34 | 1 | 1680 | |
36 | 1 | 6155 | |
37 | 1 | 1420 | |
38 | 1 | 730 | |
47 | 1 | 900 | |
49 | 26 | 8440 | |
53 | 1 | 730 | |
58 | 2 | 5188 | |
61 | 1 | 3134 | |
65 | 3 | 7010 | |
66 | 1 | 1930 | |
69 | 1 | 580 | |
70 | 1 | 1070 | |
84 | 1 | 4384 | |
97 | 1 | 990 | |
113 | 1 | 1330 | |
125 | 1 | 1660 | |
129 | 7 | 6150 | |
133 | 1 | 1030 | |
134 | 1 | 5514 | |
137 | 1 | 5964 | |
141 | 1 | 1894 | |
155 | 1 | 9024 | |
158 | 1 | 1444 | |
160 | 1 | 1534 | |
163 | 1 | 1554 | |
164 | 1 | 6214 | |
165 | 1 | 1214 | |
177 | 1 | 1700 | |
192 | 1 | 953 | |
193 | 1 | 750 | |
208 | 1508 | 1062534 | |
211 | 1 | 700 | |
213 | 4 | 1000 | |
223 | 1 | 950 | |
225 | 1 | 1600 | |
247 | 1 | 1944 | |
249 | 1 | 950 | |
250 | 3 | 3770 | |
254 | 1 | 650 | |
255 | 10 | 17990 | |
locustdb> SELECT passenger_count, count(0), sum(total_amount) FROM trips; | |
Scanned 1464785771 rows in 536ms (2.73B rows/s)! | |
passenger_count | count_0 | sum_1 | |
----------------+------------+--------------- | |
0 | 4107443 | 4509842206 | |
1 | 1028187597 | 1425303818216 | |
2 | 210577025 | 304718353489 | |
3 | 62345389 | 87788492212 | |
4 | 29994987 | 42514355874 | |
5 | 95184622 | 130181002616 | |
6 | 34380600 | 51063741303 | |
7 | 2595 | 8693795 | |
8 | 2525 | 8272055 | |
9 | 1367 | 7196690 | |
10 | 17 | 75470 | |
13 | 1 | 3150 | |
15 | 2 | 2410 | |
17 | 1 | 3995 | |
19 | 1 | 500 | |
25 | 1 | 760 | |
33 | 2 | 1719 | |
34 | 1 | 1680 | |
36 | 1 | 6155 | |
37 | 1 | 1420 | |
38 | 1 | 730 | |
47 | 1 | 900 | |
49 | 26 | 8440 | |
53 | 1 | 730 | |
58 | 2 | 5188 | |
61 | 1 | 3134 | |
65 | 3 | 7010 | |
66 | 1 | 1930 | |
69 | 1 | 580 | |
70 | 1 | 1070 | |
84 | 1 | 4384 | |
97 | 1 | 990 | |
113 | 1 | 1330 | |
125 | 1 | 1660 | |
129 | 7 | 6150 | |
133 | 1 | 1030 | |
134 | 1 | 5514 | |
137 | 1 | 5964 | |
141 | 1 | 1894 | |
155 | 1 | 9024 | |
158 | 1 | 1444 | |
160 | 1 | 1534 | |
163 | 1 | 1554 | |
164 | 1 | 6214 | |
165 | 1 | 1214 | |
177 | 1 | 1700 | |
192 | 1 | 953 | |
193 | 1 | 750 | |
208 | 1508 | 1062534 | |
211 | 1 | 700 | |
213 | 4 | 1000 | |
223 | 1 | 950 | |
225 | 1 | 1600 | |
247 | 1 | 1944 | |
249 | 1 | 950 | |
250 | 3 | 3770 | |
254 | 1 | 650 | |
255 | 10 | 17990 | |
locustdb> SELECT passenger_count, to_year(pickup_datetime), count(0) FROM trips; | |
Scanned 1464785771 rows in 530ms (2.76B rows/s)! | |
passenger_count | col_0 | count_0 | |
----------------+-------+----------- | |
0 | 2009 | 1126 | |
0 | 2010 | 35487 | |
0 | 2011 | 2547937 | |
0 | 2012 | 1274858 | |
0 | 2013 | 5476 | |
0 | 2014 | 9848 | |
0 | 2015 | 46953 | |
0 | 2016 | 17829 | |
0 | 2017 | 167929 | |
1 | 2001 | 3 | |
1 | 2002 | 1 | |
1 | 2003 | 4 | |
1 | 2008 | 33 | |
1 | 2009 | 116050070 | |
1 | 2010 | 98991938 | |
1 | 2011 | 119969450 | |
1 | 2012 | 123955717 | |
1 | 2013 | 122918578 | |
1 | 2014 | 129404151 | |
1 | 2015 | 119150088 | |
1 | 2016 | 106826192 | |
1 | 2017 | 90921221 | |
1 | 2018 | 150 | |
1 | 2041 | 1 | |
2 | 2009 | 27534617 | |
2 | 2010 | 23053740 | |
2 | 2011 | 27132349 | |
2 | 2012 | 24900623 | |
2 | 2013 | 23610698 | |
2 | 2014 | 24221283 | |
2 | 2015 | 22349143 | |
2 | 2016 | 20290051 | |
2 | 2017 | 17484514 | |
2 | 2018 | 7 | |
3 | 2008 | 1 | |
3 | 2009 | 7860551 | |
3 | 2010 | 6700468 | |
3 | 2011 | 8015005 | |
3 | 2012 | 7716364 | |
3 | 2013 | 7343603 | |
3 | 2014 | 7348686 | |
3 | 2015 | 6580430 | |
3 | 2016 | 5810400 | |
3 | 2017 | 4969879 | |
3 | 2018 | 1 | |
3 | 2053 | 1 | |
4 | 2009 | 3829136 | |
4 | 2010 | 3282494 | |
4 | 2011 | 3819715 | |
4 | 2012 | 3752549 | |
4 | 2013 | 3593459 | |
4 | 2014 | 3512831 | |
4 | 2015 | 3105718 | |
4 | 2016 | 2770237 | |
4 | 2017 | 2328848 | |
locustdb> SELECT passenger_count, to_year(pickup_datetime), count(0) FROM trips; | |
Scanned 1464785771 rows in 527ms (2.78B rows/s)! | |
passenger_count | col_0 | count_0 | |
----------------+-------+----------- | |
0 | 2009 | 1126 | |
0 | 2010 | 35487 | |
0 | 2011 | 2547937 | |
0 | 2012 | 1274858 | |
0 | 2013 | 5476 | |
0 | 2014 | 9848 | |
0 | 2015 | 46953 | |
0 | 2016 | 17829 | |
0 | 2017 | 167929 | |
1 | 2001 | 3 | |
1 | 2002 | 1 | |
1 | 2003 | 4 | |
1 | 2008 | 33 | |
1 | 2009 | 116050070 | |
1 | 2010 | 98991938 | |
1 | 2011 | 119969450 | |
1 | 2012 | 123955717 | |
1 | 2013 | 122918578 | |
1 | 2014 | 129404151 | |
1 | 2015 | 119150088 | |
1 | 2016 | 106826192 | |
1 | 2017 | 90921221 | |
1 | 2018 | 150 | |
1 | 2041 | 1 | |
2 | 2009 | 27534617 | |
2 | 2010 | 23053740 | |
2 | 2011 | 27132349 | |
2 | 2012 | 24900623 | |
2 | 2013 | 23610698 | |
2 | 2014 | 24221283 | |
2 | 2015 | 22349143 | |
2 | 2016 | 20290051 | |
2 | 2017 | 17484514 | |
2 | 2018 | 7 | |
3 | 2008 | 1 | |
3 | 2009 | 7860551 | |
3 | 2010 | 6700468 | |
3 | 2011 | 8015005 | |
3 | 2012 | 7716364 | |
3 | 2013 | 7343603 | |
3 | 2014 | 7348686 | |
3 | 2015 | 6580430 | |
3 | 2016 | 5810400 | |
3 | 2017 | 4969879 | |
3 | 2018 | 1 | |
3 | 2053 | 1 | |
4 | 2009 | 3829136 | |
4 | 2010 | 3282494 | |
4 | 2011 | 3819715 | |
4 | 2012 | 3752549 | |
4 | 2013 | 3593459 | |
4 | 2014 | 3512831 | |
4 | 2015 | 3105718 | |
4 | 2016 | 2770237 | |
4 | 2017 | 2328848 | |
locustdb> SELECT passenger_count, to_year(pickup_datetime), count(0) FROM trips; | |
Scanned 1464785771 rows in 527ms (2.78B rows/s)! | |
passenger_count | col_0 | count_0 | |
----------------+-------+----------- | |
0 | 2009 | 1126 | |
0 | 2010 | 35487 | |
0 | 2011 | 2547937 | |
0 | 2012 | 1274858 | |
0 | 2013 | 5476 | |
0 | 2014 | 9848 | |
0 | 2015 | 46953 | |
0 | 2016 | 17829 | |
0 | 2017 | 167929 | |
1 | 2001 | 3 | |
1 | 2002 | 1 | |
1 | 2003 | 4 | |
1 | 2008 | 33 | |
1 | 2009 | 116050070 | |
1 | 2010 | 98991938 | |
1 | 2011 | 119969450 | |
1 | 2012 | 123955717 | |
1 | 2013 | 122918578 | |
1 | 2014 | 129404151 | |
1 | 2015 | 119150088 | |
1 | 2016 | 106826192 | |
1 | 2017 | 90921221 | |
1 | 2018 | 150 | |
1 | 2041 | 1 | |
2 | 2009 | 27534617 | |
2 | 2010 | 23053740 | |
2 | 2011 | 27132349 | |
2 | 2012 | 24900623 | |
2 | 2013 | 23610698 | |
2 | 2014 | 24221283 | |
2 | 2015 | 22349143 | |
2 | 2016 | 20290051 | |
2 | 2017 | 17484514 | |
2 | 2018 | 7 | |
3 | 2008 | 1 | |
3 | 2009 | 7860551 | |
3 | 2010 | 6700468 | |
3 | 2011 | 8015005 | |
3 | 2012 | 7716364 | |
3 | 2013 | 7343603 | |
3 | 2014 | 7348686 | |
3 | 2015 | 6580430 | |
3 | 2016 | 5810400 | |
3 | 2017 | 4969879 | |
3 | 2018 | 1 | |
3 | 2053 | 1 | |
4 | 2009 | 3829136 | |
4 | 2010 | 3282494 | |
4 | 2011 | 3819715 | |
4 | 2012 | 3752549 | |
4 | 2013 | 3593459 | |
4 | 2014 | 3512831 | |
4 | 2015 | 3105718 | |
4 | 2016 | 2770237 | |
4 | 2017 | 2328848 | |
locustdb> SELECT passenger_count, to_year(pickup_datetime), count(0) FROM trips; | |
Scanned 1464785771 rows in 526ms (2.78B rows/s)! | |
passenger_count | col_0 | count_0 | |
----------------+-------+----------- | |
0 | 2009 | 1126 | |
0 | 2010 | 35487 | |
0 | 2011 | 2547937 | |
0 | 2012 | 1274858 | |
0 | 2013 | 5476 | |
0 | 2014 | 9848 | |
0 | 2015 | 46953 | |
0 | 2016 | 17829 | |
0 | 2017 | 167929 | |
1 | 2001 | 3 | |
1 | 2002 | 1 | |
1 | 2003 | 4 | |
1 | 2008 | 33 | |
1 | 2009 | 116050070 | |
1 | 2010 | 98991938 | |
1 | 2011 | 119969450 | |
1 | 2012 | 123955717 | |
1 | 2013 | 122918578 | |
1 | 2014 | 129404151 | |
1 | 2015 | 119150088 | |
1 | 2016 | 106826192 | |
1 | 2017 | 90921221 | |
1 | 2018 | 150 | |
1 | 2041 | 1 | |
2 | 2009 | 27534617 | |
2 | 2010 | 23053740 | |
2 | 2011 | 27132349 | |
2 | 2012 | 24900623 | |
2 | 2013 | 23610698 | |
2 | 2014 | 24221283 | |
2 | 2015 | 22349143 | |
2 | 2016 | 20290051 | |
2 | 2017 | 17484514 | |
2 | 2018 | 7 | |
3 | 2008 | 1 | |
3 | 2009 | 7860551 | |
3 | 2010 | 6700468 | |
3 | 2011 | 8015005 | |
3 | 2012 | 7716364 | |
3 | 2013 | 7343603 | |
3 | 2014 | 7348686 | |
3 | 2015 | 6580430 | |
3 | 2016 | 5810400 | |
3 | 2017 | 4969879 | |
3 | 2018 | 1 | |
3 | 2053 | 1 | |
4 | 2009 | 3829136 | |
4 | 2010 | 3282494 | |
4 | 2011 | 3819715 | |
4 | 2012 | 3752549 | |
4 | 2013 | 3593459 | |
4 | 2014 | 3512831 | |
4 | 2015 | 3105718 | |
4 | 2016 | 2770237 | |
4 | 2017 | 2328848 | |
locustdb> SELECT passenger_count, to_year(pickup_datetime), count(0) FROM trips; | |
Scanned 1464785771 rows in 527ms (2.78B rows/s)! | |
passenger_count | col_0 | count_0 | |
----------------+-------+----------- | |
0 | 2009 | 1126 | |
0 | 2010 | 35487 | |
0 | 2011 | 2547937 | |
0 | 2012 | 1274858 | |
0 | 2013 | 5476 | |
0 | 2014 | 9848 | |
0 | 2015 | 46953 | |
0 | 2016 | 17829 | |
0 | 2017 | 167929 | |
1 | 2001 | 3 | |
1 | 2002 | 1 | |
1 | 2003 | 4 | |
1 | 2008 | 33 | |
1 | 2009 | 116050070 | |
1 | 2010 | 98991938 | |
1 | 2011 | 119969450 | |
1 | 2012 | 123955717 | |
1 | 2013 | 122918578 | |
1 | 2014 | 129404151 | |
1 | 2015 | 119150088 | |
1 | 2016 | 106826192 | |
1 | 2017 | 90921221 | |
1 | 2018 | 150 | |
1 | 2041 | 1 | |
2 | 2009 | 27534617 | |
2 | 2010 | 23053740 | |
2 | 2011 | 27132349 | |
2 | 2012 | 24900623 | |
2 | 2013 | 23610698 | |
2 | 2014 | 24221283 | |
2 | 2015 | 22349143 | |
2 | 2016 | 20290051 | |
2 | 2017 | 17484514 | |
2 | 2018 | 7 | |
3 | 2008 | 1 | |
3 | 2009 | 7860551 | |
3 | 2010 | 6700468 | |
3 | 2011 | 8015005 | |
3 | 2012 | 7716364 | |
3 | 2013 | 7343603 | |
3 | 2014 | 7348686 | |
3 | 2015 | 6580430 | |
3 | 2016 | 5810400 | |
3 | 2017 | 4969879 | |
3 | 2018 | 1 | |
3 | 2053 | 1 | |
4 | 2009 | 3829136 | |
4 | 2010 | 3282494 | |
4 | 2011 | 3819715 | |
4 | 2012 | 3752549 | |
4 | 2013 | 3593459 | |
4 | 2014 | 3512831 | |
4 | 2015 | 3105718 | |
4 | 2016 | 2770237 | |
4 | 2017 | 2328848 | |
locustdb> SELECT passenger_count, to_year(pickup_datetime), count(0) FROM trips; | |
Scanned 1464785771 rows in 526ms (2.78B rows/s)! | |
passenger_count | col_0 | count_0 | |
----------------+-------+----------- | |
0 | 2009 | 1126 | |
0 | 2010 | 35487 | |
0 | 2011 | 2547937 | |
0 | 2012 | 1274858 | |
0 | 2013 | 5476 | |
0 | 2014 | 9848 | |
0 | 2015 | 46953 | |
0 | 2016 | 17829 | |
0 | 2017 | 167929 | |
1 | 2001 | 3 | |
1 | 2002 | 1 | |
1 | 2003 | 4 | |
1 | 2008 | 33 | |
1 | 2009 | 116050070 | |
1 | 2010 | 98991938 | |
1 | 2011 | 119969450 | |
1 | 2012 | 123955717 | |
1 | 2013 | 122918578 | |
1 | 2014 | 129404151 | |
1 | 2015 | 119150088 | |
1 | 2016 | 106826192 | |
1 | 2017 | 90921221 | |
1 | 2018 | 150 | |
1 | 2041 | 1 | |
2 | 2009 | 27534617 | |
2 | 2010 | 23053740 | |
2 | 2011 | 27132349 | |
2 | 2012 | 24900623 | |
2 | 2013 | 23610698 | |
2 | 2014 | 24221283 | |
2 | 2015 | 22349143 | |
2 | 2016 | 20290051 | |
2 | 2017 | 17484514 | |
2 | 2018 | 7 | |
3 | 2008 | 1 | |
3 | 2009 | 7860551 | |
3 | 2010 | 6700468 | |
3 | 2011 | 8015005 | |
3 | 2012 | 7716364 | |
3 | 2013 | 7343603 | |
3 | 2014 | 7348686 | |
3 | 2015 | 6580430 | |
3 | 2016 | 5810400 | |
3 | 2017 | 4969879 | |
3 | 2018 | 1 | |
3 | 2053 | 1 | |
4 | 2009 | 3829136 | |
4 | 2010 | 3282494 | |
4 | 2011 | 3819715 | |
4 | 2012 | 3752549 | |
4 | 2013 | 3593459 | |
4 | 2014 | 3512831 | |
4 | 2015 | 3105718 | |
4 | 2016 | 2770237 | |
4 | 2017 | 2328848 | |
locustdb> SELECT passenger_count, to_year(pickup_datetime), count(0) FROM trips; | |
Scanned 1464785771 rows in 527ms (2.78B rows/s)! | |
passenger_count | col_0 | count_0 | |
----------------+-------+----------- | |
0 | 2009 | 1126 | |
0 | 2010 | 35487 | |
0 | 2011 | 2547937 | |
0 | 2012 | 1274858 | |
0 | 2013 | 5476 | |
0 | 2014 | 9848 | |
0 | 2015 | 46953 | |
0 | 2016 | 17829 | |
0 | 2017 | 167929 | |
1 | 2001 | 3 | |
1 | 2002 | 1 | |
1 | 2003 | 4 | |
1 | 2008 | 33 | |
1 | 2009 | 116050070 | |
1 | 2010 | 98991938 | |
1 | 2011 | 119969450 | |
1 | 2012 | 123955717 | |
1 | 2013 | 122918578 | |
1 | 2014 | 129404151 | |
1 | 2015 | 119150088 | |
1 | 2016 | 106826192 | |
1 | 2017 | 90921221 | |
1 | 2018 | 150 | |
1 | 2041 | 1 | |
2 | 2009 | 27534617 | |
2 | 2010 | 23053740 | |
2 | 2011 | 27132349 | |
2 | 2012 | 24900623 | |
2 | 2013 | 23610698 | |
2 | 2014 | 24221283 | |
2 | 2015 | 22349143 | |
2 | 2016 | 20290051 | |
2 | 2017 | 17484514 | |
2 | 2018 | 7 | |
3 | 2008 | 1 | |
3 | 2009 | 7860551 | |
3 | 2010 | 6700468 | |
3 | 2011 | 8015005 | |
3 | 2012 | 7716364 | |
3 | 2013 | 7343603 | |
3 | 2014 | 7348686 | |
3 | 2015 | 6580430 | |
3 | 2016 | 5810400 | |
3 | 2017 | 4969879 | |
3 | 2018 | 1 | |
3 | 2053 | 1 | |
4 | 2009 | 3829136 | |
4 | 2010 | 3282494 | |
4 | 2011 | 3819715 | |
4 | 2012 | 3752549 | |
4 | 2013 | 3593459 | |
4 | 2014 | 3512831 | |
4 | 2015 | 3105718 | |
4 | 2016 | 2770237 | |
4 | 2017 | 2328848 | |
locustdb> SELECT passenger_count, to_year(pickup_datetime), count(0) FROM trips; | |
Scanned 1464785771 rows in 524ms (2.79B rows/s)! | |
passenger_count | col_0 | count_0 | |
----------------+-------+----------- | |
0 | 2009 | 1126 | |
0 | 2010 | 35487 | |
0 | 2011 | 2547937 | |
0 | 2012 | 1274858 | |
0 | 2013 | 5476 | |
0 | 2014 | 9848 | |
0 | 2015 | 46953 | |
0 | 2016 | 17829 | |
0 | 2017 | 167929 | |
1 | 2001 | 3 | |
1 | 2002 | 1 | |
1 | 2003 | 4 | |
1 | 2008 | 33 | |
1 | 2009 | 116050070 | |
1 | 2010 | 98991938 | |
1 | 2011 | 119969450 | |
1 | 2012 | 123955717 | |
1 | 2013 | 122918578 | |
1 | 2014 | 129404151 | |
1 | 2015 | 119150088 | |
1 | 2016 | 106826192 | |
1 | 2017 | 90921221 | |
1 | 2018 | 150 | |
1 | 2041 | 1 | |
2 | 2009 | 27534617 | |
2 | 2010 | 23053740 | |
2 | 2011 | 27132349 | |
2 | 2012 | 24900623 | |
2 | 2013 | 23610698 | |
2 | 2014 | 24221283 | |
2 | 2015 | 22349143 | |
2 | 2016 | 20290051 | |
2 | 2017 | 17484514 | |
2 | 2018 | 7 | |
3 | 2008 | 1 | |
3 | 2009 | 7860551 | |
3 | 2010 | 6700468 | |
3 | 2011 | 8015005 | |
3 | 2012 | 7716364 | |
3 | 2013 | 7343603 | |
3 | 2014 | 7348686 | |
3 | 2015 | 6580430 | |
3 | 2016 | 5810400 | |
3 | 2017 | 4969879 | |
3 | 2018 | 1 | |
3 | 2053 | 1 | |
4 | 2009 | 3829136 | |
4 | 2010 | 3282494 | |
4 | 2011 | 3819715 | |
4 | 2012 | 3752549 | |
4 | 2013 | 3593459 | |
4 | 2014 | 3512831 | |
4 | 2015 | 3105718 | |
4 | 2016 | 2770237 | |
4 | 2017 | 2328848 | |
locustdb> SELECT passenger_count, to_year(pickup_datetime), count(0) FROM trips; | |
Scanned 1464785771 rows in 526ms (2.78B rows/s)! | |
passenger_count | col_0 | count_0 | |
----------------+-------+----------- | |
0 | 2009 | 1126 | |
0 | 2010 | 35487 | |
0 | 2011 | 2547937 | |
0 | 2012 | 1274858 | |
0 | 2013 | 5476 | |
0 | 2014 | 9848 | |
0 | 2015 | 46953 | |
0 | 2016 | 17829 | |
0 | 2017 | 167929 | |
1 | 2001 | 3 | |
1 | 2002 | 1 | |
1 | 2003 | 4 | |
1 | 2008 | 33 | |
1 | 2009 | 116050070 | |
1 | 2010 | 98991938 | |
1 | 2011 | 119969450 | |
1 | 2012 | 123955717 | |
1 | 2013 | 122918578 | |
1 | 2014 | 129404151 | |
1 | 2015 | 119150088 | |
1 | 2016 | 106826192 | |
1 | 2017 | 90921221 | |
1 | 2018 | 150 | |
1 | 2041 | 1 | |
2 | 2009 | 27534617 | |
2 | 2010 | 23053740 | |
2 | 2011 | 27132349 | |
2 | 2012 | 24900623 | |
2 | 2013 | 23610698 | |
2 | 2014 | 24221283 | |
2 | 2015 | 22349143 | |
2 | 2016 | 20290051 | |
2 | 2017 | 17484514 | |
2 | 2018 | 7 | |
3 | 2008 | 1 | |
3 | 2009 | 7860551 | |
3 | 2010 | 6700468 | |
3 | 2011 | 8015005 | |
3 | 2012 | 7716364 | |
3 | 2013 | 7343603 | |
3 | 2014 | 7348686 | |
3 | 2015 | 6580430 | |
3 | 2016 | 5810400 | |
3 | 2017 | 4969879 | |
3 | 2018 | 1 | |
3 | 2053 | 1 | |
4 | 2009 | 3829136 | |
4 | 2010 | 3282494 | |
4 | 2011 | 3819715 | |
4 | 2012 | 3752549 | |
4 | 2013 | 3593459 | |
4 | 2014 | 3512831 | |
4 | 2015 | 3105718 | |
4 | 2016 | 2770237 | |
4 | 2017 | 2328848 | |
locustdb> SELECT passenger_count, to_year(pickup_datetime), count(0) FROM trips; | |
Scanned 1464785771 rows in 528ms (2.77B rows/s)! | |
passenger_count | col_0 | count_0 | |
----------------+-------+----------- | |
0 | 2009 | 1126 | |
0 | 2010 | 35487 | |
0 | 2011 | 2547937 | |
0 | 2012 | 1274858 | |
0 | 2013 | 5476 | |
0 | 2014 | 9848 | |
0 | 2015 | 46953 | |
0 | 2016 | 17829 | |
0 | 2017 | 167929 | |
1 | 2001 | 3 | |
1 | 2002 | 1 | |
1 | 2003 | 4 | |
1 | 2008 | 33 | |
1 | 2009 | 116050070 | |
1 | 2010 | 98991938 | |
1 | 2011 | 119969450 | |
1 | 2012 | 123955717 | |
1 | 2013 | 122918578 | |
1 | 2014 | 129404151 | |
1 | 2015 | 119150088 | |
1 | 2016 | 106826192 | |
1 | 2017 | 90921221 | |
1 | 2018 | 150 | |
1 | 2041 | 1 | |
2 | 2009 | 27534617 | |
2 | 2010 | 23053740 | |
2 | 2011 | 27132349 | |
2 | 2012 | 24900623 | |
2 | 2013 | 23610698 | |
2 | 2014 | 24221283 | |
2 | 2015 | 22349143 | |
2 | 2016 | 20290051 | |
2 | 2017 | 17484514 | |
2 | 2018 | 7 | |
3 | 2008 | 1 | |
3 | 2009 | 7860551 | |
3 | 2010 | 6700468 | |
3 | 2011 | 8015005 | |
3 | 2012 | 7716364 | |
3 | 2013 | 7343603 | |
3 | 2014 | 7348686 | |
3 | 2015 | 6580430 | |
3 | 2016 | 5810400 | |
3 | 2017 | 4969879 | |
3 | 2018 | 1 | |
3 | 2053 | 1 | |
4 | 2009 | 3829136 | |
4 | 2010 | 3282494 | |
4 | 2011 | 3819715 | |
4 | 2012 | 3752549 | |
4 | 2013 | 3593459 | |
4 | 2014 | 3512831 | |
4 | 2015 | 3105718 | |
4 | 2016 | 2770237 | |
4 | 2017 | 2328848 | |
locustdb> SELECT passenger_count, to_year(pickup_datetime), trip_distance / 1000, count(0) FROM trips; | |
Scanned 1464785771 rows in 3086ms (0.47B rows/s)! | |
passenger_count | col_0 | col_1 | count_0 | |
----------------+-------+-------+--------- | |
0 | 2009 | 0 | 570 | |
0 | 2009 | 1 | 267 | |
0 | 2009 | 2 | 115 | |
0 | 2009 | 3 | 52 | |
0 | 2009 | 4 | 28 | |
0 | 2009 | 5 | 28 | |
0 | 2009 | 6 | 13 | |
0 | 2009 | 7 | 11 | |
0 | 2009 | 8 | 8 | |
0 | 2009 | 9 | 5 | |
0 | 2009 | 10 | 4 | |
0 | 2009 | 11 | 6 | |
0 | 2009 | 12 | 2 | |
0 | 2009 | 13 | 2 | |
0 | 2009 | 14 | 2 | |
0 | 2009 | 17 | 3 | |
0 | 2009 | 18 | 2 | |
0 | 2009 | 19 | 2 | |
0 | 2009 | 20 | 1 | |
0 | 2009 | 21 | 2 | |
0 | 2009 | 22 | 2 | |
0 | 2009 | 31 | 1 | |
0 | 2010 | 0 | 16834 | |
0 | 2010 | 1 | 10264 | |
0 | 2010 | 2 | 3858 | |
0 | 2010 | 3 | 1797 | |
0 | 2010 | 4 | 831 | |
0 | 2010 | 5 | 643 | |
0 | 2010 | 6 | 418 | |
0 | 2010 | 7 | 207 | |
0 | 2010 | 8 | 108 | |
0 | 2010 | 9 | 100 | |
0 | 2010 | 10 | 109 | |
0 | 2010 | 11 | 118 | |
0 | 2010 | 12 | 58 | |
0 | 2010 | 13 | 30 | |
0 | 2010 | 14 | 20 | |
0 | 2010 | 15 | 17 | |
0 | 2010 | 16 | 13 | |
0 | 2010 | 17 | 10 | |
0 | 2010 | 18 | 3 | |
0 | 2010 | 19 | 8 | |
0 | 2010 | 20 | 8 | |
0 | 2010 | 21 | 5 | |
0 | 2010 | 22 | 2 | |
0 | 2010 | 23 | 3 | |
0 | 2010 | 24 | 2 | |
0 | 2010 | 26 | 3 | |
0 | 2010 | 27 | 1 | |
0 | 2010 | 28 | 1 | |
0 | 2010 | 29 | 1 | |
0 | 2010 | 32 | 1 | |
0 | 2010 | 33 | 1 | |
0 | 2010 | 36 | 2 | |
0 | 2010 | 37 | 2 | |
0 | 2010 | 38 | 1 | |
0 | 2010 | 43 | 1 | |
0 | 2010 | 47 | 1 | |
0 | 2010 | 53 | 1 | |
0 | 2010 | 54 | 1 | |
0 | 2010 | 70 | 1 | |
0 | 2010 | 76 | 1 | |
0 | 2010 | 77 | 1 | |
0 | 2010 | 86 | 1 | |
0 | 2011 | 0 | 679047 | |
0 | 2011 | 1 | 884997 | |
0 | 2011 | 2 | 430866 | |
0 | 2011 | 3 | 211773 | |
0 | 2011 | 4 | 112552 | |
0 | 2011 | 5 | 69700 | |
0 | 2011 | 6 | 43498 | |
0 | 2011 | 7 | 26703 | |
0 | 2011 | 8 | 16962 | |
0 | 2011 | 9 | 13569 | |
0 | 2011 | 10 | 10974 | |
0 | 2011 | 11 | 8656 | |
0 | 2011 | 12 | 6488 | |
0 | 2011 | 13 | 4422 | |
0 | 2011 | 14 | 3534 | |
0 | 2011 | 15 | 3470 | |
0 | 2011 | 16 | 4541 | |
0 | 2011 | 17 | 4617 | |
0 | 2011 | 18 | 3805 | |
0 | 2011 | 19 | 2574 | |
0 | 2011 | 20 | 1710 | |
0 | 2011 | 21 | 965 | |
0 | 2011 | 22 | 581 | |
0 | 2011 | 23 | 340 | |
0 | 2011 | 24 | 214 | |
0 | 2011 | 25 | 189 | |
0 | 2011 | 26 | 153 | |
0 | 2011 | 27 | 138 | |
0 | 2011 | 28 | 114 | |
0 | 2011 | 29 | 63 | |
0 | 2011 | 30 | 73 | |
0 | 2011 | 31 | 58 | |
0 | 2011 | 32 | 72 | |
0 | 2011 | 33 | 39 | |
0 | 2011 | 34 | 46 | |
0 | 2011 | 35 | 39 | |
locustdb> SELECT passenger_count, to_year(pickup_datetime), trip_distance / 1000, count(0) FROM trips; | |
Scanned 1464785771 rows in 3085ms (0.47B rows/s)! | |
passenger_count | col_0 | col_1 | count_0 | |
----------------+-------+-------+--------- | |
0 | 2009 | 0 | 570 | |
0 | 2009 | 1 | 267 | |
0 | 2009 | 2 | 115 | |
0 | 2009 | 3 | 52 | |
0 | 2009 | 4 | 28 | |
0 | 2009 | 5 | 28 | |
0 | 2009 | 6 | 13 | |
0 | 2009 | 7 | 11 | |
0 | 2009 | 8 | 8 | |
0 | 2009 | 9 | 5 | |
0 | 2009 | 10 | 4 | |
0 | 2009 | 11 | 6 | |
0 | 2009 | 12 | 2 | |
0 | 2009 | 13 | 2 | |
0 | 2009 | 14 | 2 | |
0 | 2009 | 17 | 3 | |
0 | 2009 | 18 | 2 | |
0 | 2009 | 19 | 2 | |
0 | 2009 | 20 | 1 | |
0 | 2009 | 21 | 2 | |
0 | 2009 | 22 | 2 | |
0 | 2009 | 31 | 1 | |
0 | 2010 | 0 | 16834 | |
0 | 2010 | 1 | 10264 | |
0 | 2010 | 2 | 3858 | |
0 | 2010 | 3 | 1797 | |
0 | 2010 | 4 | 831 | |
0 | 2010 | 5 | 643 | |
0 | 2010 | 6 | 418 | |
0 | 2010 | 7 | 207 | |
0 | 2010 | 8 | 108 | |
0 | 2010 | 9 | 100 | |
0 | 2010 | 10 | 109 | |
0 | 2010 | 11 | 118 | |
0 | 2010 | 12 | 58 | |
0 | 2010 | 13 | 30 | |
0 | 2010 | 14 | 20 | |
0 | 2010 | 15 | 17 | |
0 | 2010 | 16 | 13 | |
0 | 2010 | 17 | 10 | |
0 | 2010 | 18 | 3 | |
0 | 2010 | 19 | 8 | |
0 | 2010 | 20 | 8 | |
0 | 2010 | 21 | 5 | |
0 | 2010 | 22 | 2 | |
0 | 2010 | 23 | 3 | |
0 | 2010 | 24 | 2 | |
0 | 2010 | 26 | 3 | |
0 | 2010 | 27 | 1 | |
0 | 2010 | 28 | 1 | |
0 | 2010 | 29 | 1 | |
0 | 2010 | 32 | 1 | |
0 | 2010 | 33 | 1 | |
0 | 2010 | 36 | 2 | |
0 | 2010 | 37 | 2 | |
0 | 2010 | 38 | 1 | |
0 | 2010 | 43 | 1 | |
0 | 2010 | 47 | 1 | |
0 | 2010 | 53 | 1 | |
0 | 2010 | 54 | 1 | |
0 | 2010 | 70 | 1 | |
0 | 2010 | 76 | 1 | |
0 | 2010 | 77 | 1 | |
0 | 2010 | 86 | 1 | |
0 | 2011 | 0 | 679047 | |
0 | 2011 | 1 | 884997 | |
0 | 2011 | 2 | 430866 | |
0 | 2011 | 3 | 211773 | |
0 | 2011 | 4 | 112552 | |
0 | 2011 | 5 | 69700 | |
0 | 2011 | 6 | 43498 | |
0 | 2011 | 7 | 26703 | |
0 | 2011 | 8 | 16962 | |
0 | 2011 | 9 | 13569 | |
0 | 2011 | 10 | 10974 | |
0 | 2011 | 11 | 8656 | |
0 | 2011 | 12 | 6488 | |
0 | 2011 | 13 | 4422 | |
0 | 2011 | 14 | 3534 | |
0 | 2011 | 15 | 3470 | |
0 | 2011 | 16 | 4541 | |
0 | 2011 | 17 | 4617 | |
0 | 2011 | 18 | 3805 | |
0 | 2011 | 19 | 2574 | |
0 | 2011 | 20 | 1710 | |
0 | 2011 | 21 | 965 | |
0 | 2011 | 22 | 581 | |
0 | 2011 | 23 | 340 | |
0 | 2011 | 24 | 214 | |
0 | 2011 | 25 | 189 | |
0 | 2011 | 26 | 153 | |
0 | 2011 | 27 | 138 | |
0 | 2011 | 28 | 114 | |
0 | 2011 | 29 | 63 | |
0 | 2011 | 30 | 73 | |
0 | 2011 | 31 | 58 | |
0 | 2011 | 32 | 72 | |
0 | 2011 | 33 | 39 | |
0 | 2011 | 34 | 46 | |
0 | 2011 | 35 | 39 | |
locustdb> SELECT passenger_count, to_year(pickup_datetime), trip_distance / 1000, count(0) FROM trips; | |
Scanned 1464785771 rows in 3084ms (0.47B rows/s)! | |
passenger_count | col_0 | col_1 | count_0 | |
----------------+-------+-------+--------- | |
0 | 2009 | 0 | 570 | |
0 | 2009 | 1 | 267 | |
0 | 2009 | 2 | 115 | |
0 | 2009 | 3 | 52 | |
0 | 2009 | 4 | 28 | |
0 | 2009 | 5 | 28 | |
0 | 2009 | 6 | 13 | |
0 | 2009 | 7 | 11 | |
0 | 2009 | 8 | 8 | |
0 | 2009 | 9 | 5 | |
0 | 2009 | 10 | 4 | |
0 | 2009 | 11 | 6 | |
0 | 2009 | 12 | 2 | |
0 | 2009 | 13 | 2 | |
0 | 2009 | 14 | 2 | |
0 | 2009 | 17 | 3 | |
0 | 2009 | 18 | 2 | |
0 | 2009 | 19 | 2 | |
0 | 2009 | 20 | 1 | |
0 | 2009 | 21 | 2 | |
0 | 2009 | 22 | 2 | |
0 | 2009 | 31 | 1 | |
0 | 2010 | 0 | 16834 | |
0 | 2010 | 1 | 10264 | |
0 | 2010 | 2 | 3858 | |
0 | 2010 | 3 | 1797 | |
0 | 2010 | 4 | 831 | |
0 | 2010 | 5 | 643 | |
0 | 2010 | 6 | 418 | |
0 | 2010 | 7 | 207 | |
0 | 2010 | 8 | 108 | |
0 | 2010 | 9 | 100 | |
0 | 2010 | 10 | 109 | |
0 | 2010 | 11 | 118 | |
0 | 2010 | 12 | 58 | |
0 | 2010 | 13 | 30 | |
0 | 2010 | 14 | 20 | |
0 | 2010 | 15 | 17 | |
0 | 2010 | 16 | 13 | |
0 | 2010 | 17 | 10 | |
0 | 2010 | 18 | 3 | |
0 | 2010 | 19 | 8 | |
0 | 2010 | 20 | 8 | |
0 | 2010 | 21 | 5 | |
0 | 2010 | 22 | 2 | |
0 | 2010 | 23 | 3 | |
0 | 2010 | 24 | 2 | |
0 | 2010 | 26 | 3 | |
0 | 2010 | 27 | 1 | |
0 | 2010 | 28 | 1 | |
0 | 2010 | 29 | 1 | |
0 | 2010 | 32 | 1 | |
0 | 2010 | 33 | 1 | |
0 | 2010 | 36 | 2 | |
0 | 2010 | 37 | 2 | |
0 | 2010 | 38 | 1 | |
0 | 2010 | 43 | 1 | |
0 | 2010 | 47 | 1 | |
0 | 2010 | 53 | 1 | |
0 | 2010 | 54 | 1 | |
0 | 2010 | 70 | 1 | |
0 | 2010 | 76 | 1 | |
0 | 2010 | 77 | 1 | |
0 | 2010 | 86 | 1 | |
0 | 2011 | 0 | 679047 | |
0 | 2011 | 1 | 884997 | |
0 | 2011 | 2 | 430866 | |
0 | 2011 | 3 | 211773 | |
0 | 2011 | 4 | 112552 | |
0 | 2011 | 5 | 69700 | |
0 | 2011 | 6 | 43498 | |
0 | 2011 | 7 | 26703 | |
0 | 2011 | 8 | 16962 | |
0 | 2011 | 9 | 13569 | |
0 | 2011 | 10 | 10974 | |
0 | 2011 | 11 | 8656 | |
0 | 2011 | 12 | 6488 | |
0 | 2011 | 13 | 4422 | |
0 | 2011 | 14 | 3534 | |
0 | 2011 | 15 | 3470 | |
0 | 2011 | 16 | 4541 | |
0 | 2011 | 17 | 4617 | |
0 | 2011 | 18 | 3805 | |
0 | 2011 | 19 | 2574 | |
0 | 2011 | 20 | 1710 | |
0 | 2011 | 21 | 965 | |
0 | 2011 | 22 | 581 | |
0 | 2011 | 23 | 340 | |
0 | 2011 | 24 | 214 | |
0 | 2011 | 25 | 189 | |
0 | 2011 | 26 | 153 | |
0 | 2011 | 27 | 138 | |
0 | 2011 | 28 | 114 | |
0 | 2011 | 29 | 63 | |
0 | 2011 | 30 | 73 | |
0 | 2011 | 31 | 58 | |
0 | 2011 | 32 | 72 | |
0 | 2011 | 33 | 39 | |
0 | 2011 | 34 | 46 | |
0 | 2011 | 35 | 39 | |
locustdb> SELECT passenger_count, to_year(pickup_datetime), trip_distance / 1000, count(0) FROM trips; | |
Scanned 1464785771 rows in 3082ms (0.48B rows/s)! | |
passenger_count | col_0 | col_1 | count_0 | |
----------------+-------+-------+--------- | |
0 | 2009 | 0 | 570 | |
0 | 2009 | 1 | 267 | |
0 | 2009 | 2 | 115 | |
0 | 2009 | 3 | 52 | |
0 | 2009 | 4 | 28 | |
0 | 2009 | 5 | 28 | |
0 | 2009 | 6 | 13 | |
0 | 2009 | 7 | 11 | |
0 | 2009 | 8 | 8 | |
0 | 2009 | 9 | 5 | |
0 | 2009 | 10 | 4 | |
0 | 2009 | 11 | 6 | |
0 | 2009 | 12 | 2 | |
0 | 2009 | 13 | 2 | |
0 | 2009 | 14 | 2 | |
0 | 2009 | 17 | 3 | |
0 | 2009 | 18 | 2 | |
0 | 2009 | 19 | 2 | |
0 | 2009 | 20 | 1 | |
0 | 2009 | 21 | 2 | |
0 | 2009 | 22 | 2 | |
0 | 2009 | 31 | 1 | |
0 | 2010 | 0 | 16834 | |
0 | 2010 | 1 | 10264 | |
0 | 2010 | 2 | 3858 | |
0 | 2010 | 3 | 1797 | |
0 | 2010 | 4 | 831 | |
0 | 2010 | 5 | 643 | |
0 | 2010 | 6 | 418 | |
0 | 2010 | 7 | 207 | |
0 | 2010 | 8 | 108 | |
0 | 2010 | 9 | 100 | |
0 | 2010 | 10 | 109 | |
0 | 2010 | 11 | 118 | |
0 | 2010 | 12 | 58 | |
0 | 2010 | 13 | 30 | |
0 | 2010 | 14 | 20 | |
0 | 2010 | 15 | 17 | |
0 | 2010 | 16 | 13 | |
0 | 2010 | 17 | 10 | |
0 | 2010 | 18 | 3 | |
0 | 2010 | 19 | 8 | |
0 | 2010 | 20 | 8 | |
0 | 2010 | 21 | 5 | |
0 | 2010 | 22 | 2 | |
0 | 2010 | 23 | 3 | |
0 | 2010 | 24 | 2 | |
0 | 2010 | 26 | 3 | |
0 | 2010 | 27 | 1 | |
0 | 2010 | 28 | 1 | |
0 | 2010 | 29 | 1 | |
0 | 2010 | 32 | 1 | |
0 | 2010 | 33 | 1 | |
0 | 2010 | 36 | 2 | |
0 | 2010 | 37 | 2 | |
0 | 2010 | 38 | 1 | |
0 | 2010 | 43 | 1 | |
0 | 2010 | 47 | 1 | |
0 | 2010 | 53 | 1 | |
0 | 2010 | 54 | 1 | |
0 | 2010 | 70 | 1 | |
0 | 2010 | 76 | 1 | |
0 | 2010 | 77 | 1 | |
0 | 2010 | 86 | 1 | |
0 | 2011 | 0 | 679047 | |
0 | 2011 | 1 | 884997 | |
0 | 2011 | 2 | 430866 | |
0 | 2011 | 3 | 211773 | |
0 | 2011 | 4 | 112552 | |
0 | 2011 | 5 | 69700 | |
0 | 2011 | 6 | 43498 | |
0 | 2011 | 7 | 26703 | |
0 | 2011 | 8 | 16962 | |
0 | 2011 | 9 | 13569 | |
0 | 2011 | 10 | 10974 | |
0 | 2011 | 11 | 8656 | |
0 | 2011 | 12 | 6488 | |
0 | 2011 | 13 | 4422 | |
0 | 2011 | 14 | 3534 | |
0 | 2011 | 15 | 3470 | |
0 | 2011 | 16 | 4541 | |
0 | 2011 | 17 | 4617 | |
0 | 2011 | 18 | 3805 | |
0 | 2011 | 19 | 2574 | |
0 | 2011 | 20 | 1710 | |
0 | 2011 | 21 | 965 | |
0 | 2011 | 22 | 581 | |
0 | 2011 | 23 | 340 | |
0 | 2011 | 24 | 214 | |
0 | 2011 | 25 | 189 | |
0 | 2011 | 26 | 153 | |
0 | 2011 | 27 | 138 | |
0 | 2011 | 28 | 114 | |
0 | 2011 | 29 | 63 | |
0 | 2011 | 30 | 73 | |
0 | 2011 | 31 | 58 | |
0 | 2011 | 32 | 72 | |
0 | 2011 | 33 | 39 | |
0 | 2011 | 34 | 46 | |
0 | 2011 | 35 | 39 | |
locustdb> SELECT passenger_count, to_year(pickup_datetime), trip_distance / 1000, count(0) FROM trips; | |
Scanned 1464785771 rows in 3078ms (0.48B rows/s)! | |
passenger_count | col_0 | col_1 | count_0 | |
----------------+-------+-------+--------- | |
0 | 2009 | 0 | 570 | |
0 | 2009 | 1 | 267 | |
0 | 2009 | 2 | 115 | |
0 | 2009 | 3 | 52 | |
0 | 2009 | 4 | 28 | |
0 | 2009 | 5 | 28 | |
0 | 2009 | 6 | 13 | |
0 | 2009 | 7 | 11 | |
0 | 2009 | 8 | 8 | |
0 | 2009 | 9 | 5 | |
0 | 2009 | 10 | 4 | |
0 | 2009 | 11 | 6 | |
0 | 2009 | 12 | 2 | |
0 | 2009 | 13 | 2 | |
0 | 2009 | 14 | 2 | |
0 | 2009 | 17 | 3 | |
0 | 2009 | 18 | 2 | |
0 | 2009 | 19 | 2 | |
0 | 2009 | 20 | 1 | |
0 | 2009 | 21 | 2 | |
0 | 2009 | 22 | 2 | |
0 | 2009 | 31 | 1 | |
0 | 2010 | 0 | 16834 | |
0 | 2010 | 1 | 10264 | |
0 | 2010 | 2 | 3858 | |
0 | 2010 | 3 | 1797 | |
0 | 2010 | 4 | 831 | |
0 | 2010 | 5 | 643 | |
0 | 2010 | 6 | 418 | |
0 | 2010 | 7 | 207 | |
0 | 2010 | 8 | 108 | |
0 | 2010 | 9 | 100 | |
0 | 2010 | 10 | 109 | |
0 | 2010 | 11 | 118 | |
0 | 2010 | 12 | 58 | |
0 | 2010 | 13 | 30 | |
0 | 2010 | 14 | 20 | |
0 | 2010 | 15 | 17 | |
0 | 2010 | 16 | 13 | |
0 | 2010 | 17 | 10 | |
0 | 2010 | 18 | 3 | |
0 | 2010 | 19 | 8 | |
0 | 2010 | 20 | 8 | |
0 | 2010 | 21 | 5 | |
0 | 2010 | 22 | 2 | |
0 | 2010 | 23 | 3 | |
0 | 2010 | 24 | 2 | |
0 | 2010 | 26 | 3 | |
0 | 2010 | 27 | 1 | |
0 | 2010 | 28 | 1 | |
0 | 2010 | 29 | 1 | |
0 | 2010 | 32 | 1 | |
0 | 2010 | 33 | 1 | |
0 | 2010 | 36 | 2 | |
0 | 2010 | 37 | 2 | |
0 | 2010 | 38 | 1 | |
0 | 2010 | 43 | 1 | |
0 | 2010 | 47 | 1 | |
0 | 2010 | 53 | 1 | |
0 | 2010 | 54 | 1 | |
0 | 2010 | 70 | 1 | |
0 | 2010 | 76 | 1 | |
0 | 2010 | 77 | 1 | |
0 | 2010 | 86 | 1 | |
0 | 2011 | 0 | 679047 | |
0 | 2011 | 1 | 884997 | |
0 | 2011 | 2 | 430866 | |
0 | 2011 | 3 | 211773 | |
0 | 2011 | 4 | 112552 | |
0 | 2011 | 5 | 69700 | |
0 | 2011 | 6 | 43498 | |
0 | 2011 | 7 | 26703 | |
0 | 2011 | 8 | 16962 | |
0 | 2011 | 9 | 13569 | |
0 | 2011 | 10 | 10974 | |
0 | 2011 | 11 | 8656 | |
0 | 2011 | 12 | 6488 | |
0 | 2011 | 13 | 4422 | |
0 | 2011 | 14 | 3534 | |
0 | 2011 | 15 | 3470 | |
0 | 2011 | 16 | 4541 | |
0 | 2011 | 17 | 4617 | |
0 | 2011 | 18 | 3805 | |
0 | 2011 | 19 | 2574 | |
0 | 2011 | 20 | 1710 | |
0 | 2011 | 21 | 965 | |
0 | 2011 | 22 | 581 | |
0 | 2011 | 23 | 340 | |
0 | 2011 | 24 | 214 | |
0 | 2011 | 25 | 189 | |
0 | 2011 | 26 | 153 | |
0 | 2011 | 27 | 138 | |
0 | 2011 | 28 | 114 | |
0 | 2011 | 29 | 63 | |
0 | 2011 | 30 | 73 | |
0 | 2011 | 31 | 58 | |
0 | 2011 | 32 | 72 | |
0 | 2011 | 33 | 39 | |
0 | 2011 | 34 | 46 | |
0 | 2011 | 35 | 39 | |
locustdb> SELECT passenger_count, to_year(pickup_datetime), trip_distance / 1000, count(0) FROM trips; | |
Scanned 1464785771 rows in 3092ms (0.47B rows/s)! | |
passenger_count | col_0 | col_1 | count_0 | |
----------------+-------+-------+--------- | |
0 | 2009 | 0 | 570 | |
0 | 2009 | 1 | 267 | |
0 | 2009 | 2 | 115 | |
0 | 2009 | 3 | 52 | |
0 | 2009 | 4 | 28 | |
0 | 2009 | 5 | 28 | |
0 | 2009 | 6 | 13 | |
0 | 2009 | 7 | 11 | |
0 | 2009 | 8 | 8 | |
0 | 2009 | 9 | 5 | |
0 | 2009 | 10 | 4 | |
0 | 2009 | 11 | 6 | |
0 | 2009 | 12 | 2 | |
0 | 2009 | 13 | 2 | |
0 | 2009 | 14 | 2 | |
0 | 2009 | 17 | 3 | |
0 | 2009 | 18 | 2 | |
0 | 2009 | 19 | 2 | |
0 | 2009 | 20 | 1 | |
0 | 2009 | 21 | 2 | |
0 | 2009 | 22 | 2 | |
0 | 2009 | 31 | 1 | |
0 | 2010 | 0 | 16834 | |
0 | 2010 | 1 | 10264 | |
0 | 2010 | 2 | 3858 | |
0 | 2010 | 3 | 1797 | |
0 | 2010 | 4 | 831 | |
0 | 2010 | 5 | 643 | |
0 | 2010 | 6 | 418 | |
0 | 2010 | 7 | 207 | |
0 | 2010 | 8 | 108 | |
0 | 2010 | 9 | 100 | |
0 | 2010 | 10 | 109 | |
0 | 2010 | 11 | 118 | |
0 | 2010 | 12 | 58 | |
0 | 2010 | 13 | 30 | |
0 | 2010 | 14 | 20 | |
0 | 2010 | 15 | 17 | |
0 | 2010 | 16 | 13 | |
0 | 2010 | 17 | 10 | |
0 | 2010 | 18 | 3 | |
0 | 2010 | 19 | 8 | |
0 | 2010 | 20 | 8 | |
0 | 2010 | 21 | 5 | |
0 | 2010 | 22 | 2 | |
0 | 2010 | 23 | 3 | |
0 | 2010 | 24 | 2 | |
0 | 2010 | 26 | 3 | |
0 | 2010 | 27 | 1 | |
0 | 2010 | 28 | 1 | |
0 | 2010 | 29 | 1 | |
0 | 2010 | 32 | 1 | |
0 | 2010 | 33 | 1 | |
0 | 2010 | 36 | 2 | |
0 | 2010 | 37 | 2 | |
0 | 2010 | 38 | 1 | |
0 | 2010 | 43 | 1 | |
0 | 2010 | 47 | 1 | |
0 | 2010 | 53 | 1 | |
0 | 2010 | 54 | 1 | |
0 | 2010 | 70 | 1 | |
0 | 2010 | 76 | 1 | |
0 | 2010 | 77 | 1 | |
0 | 2010 | 86 | 1 | |
0 | 2011 | 0 | 679047 | |
0 | 2011 | 1 | 884997 | |
0 | 2011 | 2 | 430866 | |
0 | 2011 | 3 | 211773 | |
0 | 2011 | 4 | 112552 | |
0 | 2011 | 5 | 69700 | |
0 | 2011 | 6 | 43498 | |
0 | 2011 | 7 | 26703 | |
0 | 2011 | 8 | 16962 | |
0 | 2011 | 9 | 13569 | |
0 | 2011 | 10 | 10974 | |
0 | 2011 | 11 | 8656 | |
0 | 2011 | 12 | 6488 | |
0 | 2011 | 13 | 4422 | |
0 | 2011 | 14 | 3534 | |
0 | 2011 | 15 | 3470 | |
0 | 2011 | 16 | 4541 | |
0 | 2011 | 17 | 4617 | |
0 | 2011 | 18 | 3805 | |
0 | 2011 | 19 | 2574 | |
0 | 2011 | 20 | 1710 | |
0 | 2011 | 21 | 965 | |
0 | 2011 | 22 | 581 | |
0 | 2011 | 23 | 340 | |
0 | 2011 | 24 | 214 | |
0 | 2011 | 25 | 189 | |
0 | 2011 | 26 | 153 | |
0 | 2011 | 27 | 138 | |
0 | 2011 | 28 | 114 | |
0 | 2011 | 29 | 63 | |
0 | 2011 | 30 | 73 | |
0 | 2011 | 31 | 58 | |
0 | 2011 | 32 | 72 | |
0 | 2011 | 33 | 39 | |
0 | 2011 | 34 | 46 | |
0 | 2011 | 35 | 39 | |
locustdb> SELECT passenger_count, to_year(pickup_datetime), trip_distance / 1000, count(0) FROM trips; | |
Scanned 1464785771 rows in 3079ms (0.48B rows/s)! | |
passenger_count | col_0 | col_1 | count_0 | |
----------------+-------+-------+--------- | |
0 | 2009 | 0 | 570 | |
0 | 2009 | 1 | 267 | |
0 | 2009 | 2 | 115 | |
0 | 2009 | 3 | 52 | |
0 | 2009 | 4 | 28 | |
0 | 2009 | 5 | 28 | |
0 | 2009 | 6 | 13 | |
0 | 2009 | 7 | 11 | |
0 | 2009 | 8 | 8 | |
0 | 2009 | 9 | 5 | |
0 | 2009 | 10 | 4 | |
0 | 2009 | 11 | 6 | |
0 | 2009 | 12 | 2 | |
0 | 2009 | 13 | 2 | |
0 | 2009 | 14 | 2 | |
0 | 2009 | 17 | 3 | |
0 | 2009 | 18 | 2 | |
0 | 2009 | 19 | 2 | |
0 | 2009 | 20 | 1 | |
0 | 2009 | 21 | 2 | |
0 | 2009 | 22 | 2 | |
0 | 2009 | 31 | 1 | |
0 | 2010 | 0 | 16834 | |
0 | 2010 | 1 | 10264 | |
0 | 2010 | 2 | 3858 | |
0 | 2010 | 3 | 1797 | |
0 | 2010 | 4 | 831 | |
0 | 2010 | 5 | 643 | |
0 | 2010 | 6 | 418 | |
0 | 2010 | 7 | 207 | |
0 | 2010 | 8 | 108 | |
0 | 2010 | 9 | 100 | |
0 | 2010 | 10 | 109 | |
0 | 2010 | 11 | 118 | |
0 | 2010 | 12 | 58 | |
0 | 2010 | 13 | 30 | |
0 | 2010 | 14 | 20 | |
0 | 2010 | 15 | 17 | |
0 | 2010 | 16 | 13 | |
0 | 2010 | 17 | 10 | |
0 | 2010 | 18 | 3 | |
0 | 2010 | 19 | 8 | |
0 | 2010 | 20 | 8 | |
0 | 2010 | 21 | 5 | |
0 | 2010 | 22 | 2 | |
0 | 2010 | 23 | 3 | |
0 | 2010 | 24 | 2 | |
0 | 2010 | 26 | 3 | |
0 | 2010 | 27 | 1 | |
0 | 2010 | 28 | 1 | |
0 | 2010 | 29 | 1 | |
0 | 2010 | 32 | 1 | |
0 | 2010 | 33 | 1 | |
0 | 2010 | 36 | 2 | |
0 | 2010 | 37 | 2 | |
0 | 2010 | 38 | 1 | |
0 | 2010 | 43 | 1 | |
0 | 2010 | 47 | 1 | |
0 | 2010 | 53 | 1 | |
0 | 2010 | 54 | 1 | |
0 | 2010 | 70 | 1 | |
0 | 2010 | 76 | 1 | |
0 | 2010 | 77 | 1 | |
0 | 2010 | 86 | 1 | |
0 | 2011 | 0 | 679047 | |
0 | 2011 | 1 | 884997 | |
0 | 2011 | 2 | 430866 | |
0 | 2011 | 3 | 211773 | |
0 | 2011 | 4 | 112552 | |
0 | 2011 | 5 | 69700 | |
0 | 2011 | 6 | 43498 | |
0 | 2011 | 7 | 26703 | |
0 | 2011 | 8 | 16962 | |
0 | 2011 | 9 | 13569 | |
0 | 2011 | 10 | 10974 | |
0 | 2011 | 11 | 8656 | |
0 | 2011 | 12 | 6488 | |
0 | 2011 | 13 | 4422 | |
0 | 2011 | 14 | 3534 | |
0 | 2011 | 15 | 3470 | |
0 | 2011 | 16 | 4541 | |
0 | 2011 | 17 | 4617 | |
0 | 2011 | 18 | 3805 | |
0 | 2011 | 19 | 2574 | |
0 | 2011 | 20 | 1710 | |
0 | 2011 | 21 | 965 | |
0 | 2011 | 22 | 581 | |
0 | 2011 | 23 | 340 | |
0 | 2011 | 24 | 214 | |
0 | 2011 | 25 | 189 | |
0 | 2011 | 26 | 153 | |
0 | 2011 | 27 | 138 | |
0 | 2011 | 28 | 114 | |
0 | 2011 | 29 | 63 | |
0 | 2011 | 30 | 73 | |
0 | 2011 | 31 | 58 | |
0 | 2011 | 32 | 72 | |
0 | 2011 | 33 | 39 | |
0 | 2011 | 34 | 46 | |
0 | 2011 | 35 | 39 | |
locustdb> SELECT passenger_count, to_year(pickup_datetime), trip_distance / 1000, count(0) FROM trips; | |
Scanned 1464785771 rows in 3086ms (0.47B rows/s)! | |
passenger_count | col_0 | col_1 | count_0 | |
----------------+-------+-------+--------- | |
0 | 2009 | 0 | 570 | |
0 | 2009 | 1 | 267 | |
0 | 2009 | 2 | 115 | |
0 | 2009 | 3 | 52 | |
0 | 2009 | 4 | 28 | |
0 | 2009 | 5 | 28 | |
0 | 2009 | 6 | 13 | |
0 | 2009 | 7 | 11 | |
0 | 2009 | 8 | 8 | |
0 | 2009 | 9 | 5 | |
0 | 2009 | 10 | 4 | |
0 | 2009 | 11 | 6 | |
0 | 2009 | 12 | 2 | |
0 | 2009 | 13 | 2 | |
0 | 2009 | 14 | 2 | |
0 | 2009 | 17 | 3 | |
0 | 2009 | 18 | 2 | |
0 | 2009 | 19 | 2 | |
0 | 2009 | 20 | 1 | |
0 | 2009 | 21 | 2 | |
0 | 2009 | 22 | 2 | |
0 | 2009 | 31 | 1 | |
0 | 2010 | 0 | 16834 | |
0 | 2010 | 1 | 10264 | |
0 | 2010 | 2 | 3858 | |
0 | 2010 | 3 | 1797 | |
0 | 2010 | 4 | 831 | |
0 | 2010 | 5 | 643 | |
0 | 2010 | 6 | 418 | |
0 | 2010 | 7 | 207 | |
0 | 2010 | 8 | 108 | |
0 | 2010 | 9 | 100 | |
0 | 2010 | 10 | 109 | |
0 | 2010 | 11 | 118 | |
0 | 2010 | 12 | 58 | |
0 | 2010 | 13 | 30 | |
0 | 2010 | 14 | 20 | |
0 | 2010 | 15 | 17 | |
0 | 2010 | 16 | 13 | |
0 | 2010 | 17 | 10 | |
0 | 2010 | 18 | 3 | |
0 | 2010 | 19 | 8 | |
0 | 2010 | 20 | 8 | |
0 | 2010 | 21 | 5 | |
0 | 2010 | 22 | 2 | |
0 | 2010 | 23 | 3 | |
0 | 2010 | 24 | 2 | |
0 | 2010 | 26 | 3 | |
0 | 2010 | 27 | 1 | |
0 | 2010 | 28 | 1 | |
0 | 2010 | 29 | 1 | |
0 | 2010 | 32 | 1 | |
0 | 2010 | 33 | 1 | |
0 | 2010 | 36 | 2 | |
0 | 2010 | 37 | 2 | |
0 | 2010 | 38 | 1 | |
0 | 2010 | 43 | 1 | |
0 | 2010 | 47 | 1 | |
0 | 2010 | 53 | 1 | |
0 | 2010 | 54 | 1 | |
0 | 2010 | 70 | 1 | |
0 | 2010 | 76 | 1 | |
0 | 2010 | 77 | 1 | |
0 | 2010 | 86 | 1 | |
0 | 2011 | 0 | 679047 | |
0 | 2011 | 1 | 884997 | |
0 | 2011 | 2 | 430866 | |
0 | 2011 | 3 | 211773 | |
0 | 2011 | 4 | 112552 | |
0 | 2011 | 5 | 69700 | |
0 | 2011 | 6 | 43498 | |
0 | 2011 | 7 | 26703 | |
0 | 2011 | 8 | 16962 | |
0 | 2011 | 9 | 13569 | |
0 | 2011 | 10 | 10974 | |
0 | 2011 | 11 | 8656 | |
0 | 2011 | 12 | 6488 | |
0 | 2011 | 13 | 4422 | |
0 | 2011 | 14 | 3534 | |
0 | 2011 | 15 | 3470 | |
0 | 2011 | 16 | 4541 | |
0 | 2011 | 17 | 4617 | |
0 | 2011 | 18 | 3805 | |
0 | 2011 | 19 | 2574 | |
0 | 2011 | 20 | 1710 | |
0 | 2011 | 21 | 965 | |
0 | 2011 | 22 | 581 | |
0 | 2011 | 23 | 340 | |
0 | 2011 | 24 | 214 | |
0 | 2011 | 25 | 189 | |
0 | 2011 | 26 | 153 | |
0 | 2011 | 27 | 138 | |
0 | 2011 | 28 | 114 | |
0 | 2011 | 29 | 63 | |
0 | 2011 | 30 | 73 | |
0 | 2011 | 31 | 58 | |
0 | 2011 | 32 | 72 | |
0 | 2011 | 33 | 39 | |
0 | 2011 | 34 | 46 | |
0 | 2011 | 35 | 39 | |
locustdb> SELECT passenger_count, to_year(pickup_datetime), trip_distance / 1000, count(0) FROM trips; | |
Scanned 1464785771 rows in 3084ms (0.47B rows/s)! | |
passenger_count | col_0 | col_1 | count_0 | |
----------------+-------+-------+--------- | |
0 | 2009 | 0 | 570 | |
0 | 2009 | 1 | 267 | |
0 | 2009 | 2 | 115 | |
0 | 2009 | 3 | 52 | |
0 | 2009 | 4 | 28 | |
0 | 2009 | 5 | 28 | |
0 | 2009 | 6 | 13 | |
0 | 2009 | 7 | 11 | |
0 | 2009 | 8 | 8 | |
0 | 2009 | 9 | 5 | |
0 | 2009 | 10 | 4 | |
0 | 2009 | 11 | 6 | |
0 | 2009 | 12 | 2 | |
0 | 2009 | 13 | 2 | |
0 | 2009 | 14 | 2 | |
0 | 2009 | 17 | 3 | |
0 | 2009 | 18 | 2 | |
0 | 2009 | 19 | 2 | |
0 | 2009 | 20 | 1 | |
0 | 2009 | 21 | 2 | |
0 | 2009 | 22 | 2 | |
0 | 2009 | 31 | 1 | |
0 | 2010 | 0 | 16834 | |
0 | 2010 | 1 | 10264 | |
0 | 2010 | 2 | 3858 | |
0 | 2010 | 3 | 1797 | |
0 | 2010 | 4 | 831 | |
0 | 2010 | 5 | 643 | |
0 | 2010 | 6 | 418 | |
0 | 2010 | 7 | 207 | |
0 | 2010 | 8 | 108 | |
0 | 2010 | 9 | 100 | |
0 | 2010 | 10 | 109 | |
0 | 2010 | 11 | 118 | |
0 | 2010 | 12 | 58 | |
0 | 2010 | 13 | 30 | |
0 | 2010 | 14 | 20 | |
0 | 2010 | 15 | 17 | |
0 | 2010 | 16 | 13 | |
0 | 2010 | 17 | 10 | |
0 | 2010 | 18 | 3 | |
0 | 2010 | 19 | 8 | |
0 | 2010 | 20 | 8 | |
0 | 2010 | 21 | 5 | |
0 | 2010 | 22 | 2 | |
0 | 2010 | 23 | 3 | |
0 | 2010 | 24 | 2 | |
0 | 2010 | 26 | 3 | |
0 | 2010 | 27 | 1 | |
0 | 2010 | 28 | 1 | |
0 | 2010 | 29 | 1 | |
0 | 2010 | 32 | 1 | |
0 | 2010 | 33 | 1 | |
0 | 2010 | 36 | 2 | |
0 | 2010 | 37 | 2 | |
0 | 2010 | 38 | 1 | |
0 | 2010 | 43 | 1 | |
0 | 2010 | 47 | 1 | |
0 | 2010 | 53 | 1 | |
0 | 2010 | 54 | 1 | |
0 | 2010 | 70 | 1 | |
0 | 2010 | 76 | 1 | |
0 | 2010 | 77 | 1 | |
0 | 2010 | 86 | 1 | |
0 | 2011 | 0 | 679047 | |
0 | 2011 | 1 | 884997 | |
0 | 2011 | 2 | 430866 | |
0 | 2011 | 3 | 211773 | |
0 | 2011 | 4 | 112552 | |
0 | 2011 | 5 | 69700 | |
0 | 2011 | 6 | 43498 | |
0 | 2011 | 7 | 26703 | |
0 | 2011 | 8 | 16962 | |
0 | 2011 | 9 | 13569 | |
0 | 2011 | 10 | 10974 | |
0 | 2011 | 11 | 8656 | |
0 | 2011 | 12 | 6488 | |
0 | 2011 | 13 | 4422 | |
0 | 2011 | 14 | 3534 | |
0 | 2011 | 15 | 3470 | |
0 | 2011 | 16 | 4541 | |
0 | 2011 | 17 | 4617 | |
0 | 2011 | 18 | 3805 | |
0 | 2011 | 19 | 2574 | |
0 | 2011 | 20 | 1710 | |
0 | 2011 | 21 | 965 | |
0 | 2011 | 22 | 581 | |
0 | 2011 | 23 | 340 | |
0 | 2011 | 24 | 214 | |
0 | 2011 | 25 | 189 | |
0 | 2011 | 26 | 153 | |
0 | 2011 | 27 | 138 | |
0 | 2011 | 28 | 114 | |
0 | 2011 | 29 | 63 | |
0 | 2011 | 30 | 73 | |
0 | 2011 | 31 | 58 | |
0 | 2011 | 32 | 72 | |
0 | 2011 | 33 | 39 | |
0 | 2011 | 34 | 46 | |
0 | 2011 | 35 | 39 | |
locustdb> SELECT passenger_count, to_year(pickup_datetime), trip_distance / 1000, count(0) FROM trips; | |
Scanned 1464785771 rows in 3081ms (0.48B rows/s)! | |
passenger_count | col_0 | col_1 | count_0 | |
----------------+-------+-------+--------- | |
0 | 2009 | 0 | 570 | |
0 | 2009 | 1 | 267 | |
0 | 2009 | 2 | 115 | |
0 | 2009 | 3 | 52 | |
0 | 2009 | 4 | 28 | |
0 | 2009 | 5 | 28 | |
0 | 2009 | 6 | 13 | |
0 | 2009 | 7 | 11 | |
0 | 2009 | 8 | 8 | |
0 | 2009 | 9 | 5 | |
0 | 2009 | 10 | 4 | |
0 | 2009 | 11 | 6 | |
0 | 2009 | 12 | 2 | |
0 | 2009 | 13 | 2 | |
0 | 2009 | 14 | 2 | |
0 | 2009 | 17 | 3 | |
0 | 2009 | 18 | 2 | |
0 | 2009 | 19 | 2 | |
0 | 2009 | 20 | 1 | |
0 | 2009 | 21 | 2 | |
0 | 2009 | 22 | 2 | |
0 | 2009 | 31 | 1 | |
0 | 2010 | 0 | 16834 | |
0 | 2010 | 1 | 10264 | |
0 | 2010 | 2 | 3858 | |
0 | 2010 | 3 | 1797 | |
0 | 2010 | 4 | 831 | |
0 | 2010 | 5 | 643 | |
0 | 2010 | 6 | 418 | |
0 | 2010 | 7 | 207 | |
0 | 2010 | 8 | 108 | |
0 | 2010 | 9 | 100 | |
0 | 2010 | 10 | 109 | |
0 | 2010 | 11 | 118 | |
0 | 2010 | 12 | 58 | |
0 | 2010 | 13 | 30 | |
0 | 2010 | 14 | 20 | |
0 | 2010 | 15 | 17 | |
0 | 2010 | 16 | 13 | |
0 | 2010 | 17 | 10 | |
0 | 2010 | 18 | 3 | |
0 | 2010 | 19 | 8 | |
0 | 2010 | 20 | 8 | |
0 | 2010 | 21 | 5 | |
0 | 2010 | 22 | 2 | |
0 | 2010 | 23 | 3 | |
0 | 2010 | 24 | 2 | |
0 | 2010 | 26 | 3 | |
0 | 2010 | 27 | 1 | |
0 | 2010 | 28 | 1 | |
0 | 2010 | 29 | 1 | |
0 | 2010 | 32 | 1 | |
0 | 2010 | 33 | 1 | |
0 | 2010 | 36 | 2 | |
0 | 2010 | 37 | 2 | |
0 | 2010 | 38 | 1 | |
0 | 2010 | 43 | 1 | |
0 | 2010 | 47 | 1 | |
0 | 2010 | 53 | 1 | |
0 | 2010 | 54 | 1 | |
0 | 2010 | 70 | 1 | |
0 | 2010 | 76 | 1 | |
0 | 2010 | 77 | 1 | |
0 | 2010 | 86 | 1 | |
0 | 2011 | 0 | 679047 | |
0 | 2011 | 1 | 884997 | |
0 | 2011 | 2 | 430866 | |
0 | 2011 | 3 | 211773 | |
0 | 2011 | 4 | 112552 | |
0 | 2011 | 5 | 69700 | |
0 | 2011 | 6 | 43498 | |
0 | 2011 | 7 | 26703 | |
0 | 2011 | 8 | 16962 | |
0 | 2011 | 9 | 13569 | |
0 | 2011 | 10 | 10974 | |
0 | 2011 | 11 | 8656 | |
0 | 2011 | 12 | 6488 | |
0 | 2011 | 13 | 4422 | |
0 | 2011 | 14 | 3534 | |
0 | 2011 | 15 | 3470 | |
0 | 2011 | 16 | 4541 | |
0 | 2011 | 17 | 4617 | |
0 | 2011 | 18 | 3805 | |
0 | 2011 | 19 | 2574 | |
0 | 2011 | 20 | 1710 | |
0 | 2011 | 21 | 965 | |
0 | 2011 | 22 | 581 | |
0 | 2011 | 23 | 340 | |
0 | 2011 | 24 | 214 | |
0 | 2011 | 25 | 189 | |
0 | 2011 | 26 | 153 | |
0 | 2011 | 27 | 138 | |
0 | 2011 | 28 | 114 | |
0 | 2011 | 29 | 63 | |
0 | 2011 | 30 | 73 | |
0 | 2011 | 31 | 58 | |
0 | 2011 | 32 | 72 | |
0 | 2011 | 33 | 39 | |
0 | 2011 | 34 | 46 | |
0 | 2011 | 35 | 39 | |
locustdb> SELECT trip_id FROM trips WHERE (passenger_count = 5) AND (vendor_id = "CMT") AND (total_amount < 500) | |
AND (store_and_fwd_flag = "1") LIMIT 100; | |
Scanned 1464785771 rows in 1075ms (1.36B rows/s)! | |
trip_id | |
---------- | |
163106718 | |
174687424 | |
175280990 | |
189096372 | |
298515659 | |
130612502 | |
91804982 | |
228237325 | |
210730145 | |
152363765 | |
303171377 | |
303600048 | |
195778208 | |
195827261 | |
135130551 | |
208684890 | |
208926304 | |
161072070 | |
244996620 | |
257680549 | |
122800644 | |
80845388 | |
104895642 | |
259106549 | |
190937722 | |
190953060 | |
191366388 | |
299069329 | |
84895468 | |
154865525 | |
155088848 | |
164837200 | |
177367538 | |
245281086 | |
237961482 | |
203844240 | |
261961948 | |
142031633 | |
112520068 | |
173799760 | |
174182597 | |
182124046 | |
194235323 | |
138080491 | |
138089339 | |
207059403 | |
144660880 | |
102569125 | |
166444891 | |
241317351 | |
83385404 | |
233908085 | |
263677077 | |
156105032 | |
113478507 | |
243127062 | |
255415775 | |
85701057 | |
97545508 | |
147380973 | |
148254686 | |
106309860 | |
121789437 | |
121970701 | |
122012280 | |
201367926 | |
212714740 | |
310082405 | |
247696432 | |
181868551 | |
193071605 | |
293214555 | |
137556872 | |
237368106 | |
237523596 | |
237547051 | |
202610735 | |
203089568 | |
139768745 | |
103186939 | |
176394104 | |
250557151 | |
195132906 | |
136472715 | |
136644714 | |
232337094 | |
208072881 | |
106048938 | |
locustdb> SELECT trip_id FROM trips WHERE (passenger_count = 5) AND (vendor_id = "CMT") AND (total_amount < 500) AND (store_and_fwd_flag = "1") LIMIT 100; | |
Scanned 1464785771 rows in 1073ms (1.36B rows/s)! | |
trip_id | |
---------- | |
201367926 | |
212714740 | |
303171377 | |
303600048 | |
164837200 | |
176394104 | |
247696432 | |
181868551 | |
193071605 | |
122800644 | |
85701057 | |
103186939 | |
243127062 | |
139768745 | |
232337094 | |
208684890 | |
208926304 | |
263677077 | |
83385404 | |
233908085 | |
310082405 | |
102569125 | |
163106718 | |
174687424 | |
175280990 | |
259106549 | |
135130551 | |
228237325 | |
261961948 | |
161072070 | |
173799760 | |
174182597 | |
245281086 | |
299069329 | |
84895468 | |
97545508 | |
210730145 | |
144660880 | |
156105032 | |
112520068 | |
190937722 | |
190953060 | |
191366388 | |
152363765 | |
106048938 | |
250557151 | |
195778208 | |
195827261 | |
293214555 | |
138080491 | |
138089339 | |
208072881 | |
177367538 | |
194235323 | |
136472715 | |
136644714 | |
80845388 | |
91804982 | |
207059403 | |
154865525 | |
155088848 | |
113478507 | |
244996620 | |
257680549 | |
189096372 | |
298515659 | |
130612502 | |
237368106 | |
237523596 | |
237547051 | |
147380973 | |
148254686 | |
104895642 | |
166444891 | |
182124046 | |
195132906 | |
137556872 | |
202610735 | |
203089568 | |
106309860 | |
241317351 | |
255415775 | |
121789437 | |
121970701 | |
122012280 | |
237961482 | |
203844240 | |
142031633 | |
locustdb> SELECT trip_id FROM trips WHERE (passenger_count = 5) AND (vendor_id = "CMT") AND (total_amount < 500) AND (store_and_fwd_flag = "1") LIMIT 100; | |
Scanned 1464785771 rows in 1075ms (1.36B rows/s)! | |
trip_id | |
---------- | |
243127062 | |
189096372 | |
298515659 | |
130612502 | |
212714740 | |
303171377 | |
303600048 | |
244996620 | |
181868551 | |
84895468 | |
97545508 | |
232337094 | |
203844240 | |
142031633 | |
195778208 | |
195827261 | |
139768745 | |
91804982 | |
152363765 | |
163106718 | |
174687424 | |
175280990 | |
247696432 | |
259106549 | |
121789437 | |
121970701 | |
122012280 | |
228237325 | |
207059403 | |
263677077 | |
176394104 | |
255415775 | |
137556872 | |
80845388 | |
237961482 | |
201367926 | |
113478507 | |
195132906 | |
293214555 | |
138080491 | |
138089339 | |
154865525 | |
155088848 | |
112520068 | |
83385404 | |
233908085 | |
208684890 | |
208926304 | |
310082405 | |
166444891 | |
250557151 | |
182124046 | |
194235323 | |
136472715 | |
136644714 | |
208072881 | |
144660880 | |
104895642 | |
164837200 | |
177367538 | |
190937722 | |
190953060 | |
191366388 | |
202610735 | |
203089568 | |
103186939 | |
193071605 | |
122800644 | |
135130551 | |
85701057 | |
147380973 | |
148254686 | |
102569125 | |
161072070 | |
173799760 | |
174182597 | |
245281086 | |
257680549 | |
299069329 | |
237368106 | |
237523596 | |
237547051 | |
210730145 | |
261961948 | |
156105032 | |
106309860 | |
241317351 | |
106048938 | |
locustdb> SELECT trip_id FROM trips WHERE (passenger_count = 5) AND (vendor_id = "CMT") AND (total_amount < 500) AND (store_and_fwd_flag = "1") LIMIT 100; | |
Scanned 1464785771 rows in 1074ms (1.36B rows/s)! | |
trip_id | |
---------- | |
250557151 | |
195778208 | |
195827261 | |
137556872 | |
261961948 | |
142031633 | |
303171377 | |
303600048 | |
163106718 | |
174687424 | |
175280990 | |
244996620 | |
257680549 | |
298515659 | |
130612502 | |
84895468 | |
97545508 | |
233908085 | |
152363765 | |
181868551 | |
194235323 | |
136472715 | |
136644714 | |
83385404 | |
232337094 | |
208072881 | |
263677077 | |
154865525 | |
155088848 | |
112520068 | |
189096372 | |
299069329 | |
237368106 | |
237523596 | |
237547051 | |
202610735 | |
203089568 | |
182124046 | |
195132906 | |
139768745 | |
80845388 | |
144660880 | |
156105032 | |
208684890 | |
208926304 | |
310082405 | |
102569125 | |
164837200 | |
177367538 | |
245281086 | |
122800644 | |
135130551 | |
210730145 | |
190937722 | |
190953060 | |
191366388 | |
212714740 | |
113478507 | |
166444891 | |
241317351 | |
255415775 | |
85701057 | |
147380973 | |
148254686 | |
106309860 | |
247696432 | |
259106549 | |
121789437 | |
121970701 | |
122012280 | |
228237325 | |
207059403 | |
103186939 | |
176394104 | |
243127062 | |
193071605 | |
138080491 | |
138089339 | |
91804982 | |
203844240 | |
104895642 | |
161072070 | |
173799760 | |
174182597 | |
293214555 | |
237961482 | |
201367926 | |
106048938 | |
locustdb> SELECT trip_id FROM trips WHERE (passenger_count = 5) AND (vendor_id = "CMT") AND (total_amount < 500) AND (store_and_fwd_flag = "1") LIMIT 100; | |
Scanned 1464785771 rows in 1074ms (1.36B rows/s)! | |
trip_id | |
---------- | |
164837200 | |
177367538 | |
182124046 | |
193071605 | |
137556872 | |
208684890 | |
208926304 | |
263677077 | |
152363765 | |
303171377 | |
303600048 | |
181868551 | |
195132906 | |
122800644 | |
135130551 | |
91804982 | |
228237325 | |
142031633 | |
173799760 | |
174182597 | |
244996620 | |
257680549 | |
299069329 | |
85701057 | |
232337094 | |
203844240 | |
261961948 | |
166444891 | |
250557151 | |
195778208 | |
195827261 | |
293214555 | |
138080491 | |
138089339 | |
80845388 | |
154865525 | |
155088848 | |
112520068 | |
247696432 | |
194235323 | |
136472715 | |
136644714 | |
201367926 | |
212714740 | |
147380973 | |
148254686 | |
103186939 | |
161072070 | |
243127062 | |
255415775 | |
84895468 | |
97545508 | |
208072881 | |
144660880 | |
174687424 | |
175280990 | |
245281086 | |
190937722 | |
190953060 | |
191366388 | |
237368106 | |
237523596 | |
237547051 | |
156105032 | |
113478507 | |
163106718 | |
176394104 | |
259106549 | |
121789437 | |
121970701 | |
122012280 | |
237961482 | |
202610735 | |
203089568 | |
106048938 | |
139768745 | |
210730145 | |
310082405 | |
102569125 | |
189096372 | |
298515659 | |
130612502 | |
207059403 | |
106309860 | |
241317351 | |
83385404 | |
233908085 | |
104895642 | |
locustdb> SELECT trip_id FROM trips WHERE (passenger_count = 5) AND (vendor_id = "CMT") AND (total_amount < 500) AND (store_and_fwd_flag = "1") LIMIT 100; | |
Scanned 1464785771 rows in 1073ms (1.36B rows/s)! | |
trip_id | |
---------- | |
181868551 | |
194235323 | |
135130551 | |
80845388 | |
207059403 | |
261961948 | |
303171377 | |
303600048 | |
243127062 | |
255415775 | |
130612502 | |
84895468 | |
97545508 | |
233908085 | |
210730145 | |
147380973 | |
148254686 | |
293214555 | |
138080491 | |
138089339 | |
208072881 | |
154865525 | |
155088848 | |
112520068 | |
176394104 | |
182124046 | |
195132906 | |
136472715 | |
136644714 | |
91804982 | |
228237325 | |
152363765 | |
232337094 | |
208684890 | |
208926304 | |
263677077 | |
144660880 | |
156105032 | |
250557151 | |
195778208 | |
195827261 | |
139768745 | |
237961482 | |
202610735 | |
203089568 | |
113478507 | |
164837200 | |
177367538 | |
245281086 | |
257680549 | |
299069329 | |
104895642 | |
161072070 | |
189096372 | |
298515659 | |
83385404 | |
310082405 | |
102569125 | |
174687424 | |
175280990 | |
244996620 | |
193071605 | |
121789437 | |
121970701 | |
122012280 | |
137556872 | |
237368106 | |
237523596 | |
237547051 | |
142031633 | |
103186939 | |
163106718 | |
173799760 | |
174182597 | |
190937722 | |
190953060 | |
191366388 | |
212714740 | |
106048938 | |
166444891 | |
247696432 | |
259106549 | |
122800644 | |
203844240 | |
241317351 | |
85701057 | |
201367926 | |
106309860 | |
locustdb> SELECT trip_id FROM trips WHERE (passenger_count = 5) AND (vendor_id = "CMT") AND (total_amount < 500) AND (store_and_fwd_flag = "1") LIMIT 100; | |
Scanned 1464785771 rows in 1073ms (1.36B rows/s)! | |
trip_id | |