Skip to content

Instantly share code, notes, and snippets.

@cswinter
Created July 8, 2018 06:49
Show Gist options
  • Save cswinter/38c915c1d5c8176ae61682a9b78af7b1 to your computer and use it in GitHub Desktop.
Save cswinter/38c915c1d5c8176ae61682a9b78af7b1 to your computer and use it in GitHub Desktop.
➜ LocustDB git:(master) RUSTFLAGS="-Ccodegen-units=1" CARGO_INCREMENTAL=0 cargo run --features nerf --release --bin repl -- nyc
Finished release [optimized] target(s) in 0.06s
Running `target/release/repl nyc`
NERFED!
Loading nyc into table trips.
Loaded data in 1121 seconds.
# Table `trips` (1464785771 rows, 42794.30 MiB) #
payment_type: 1397.69MiB
pickup_puma: 2611.38MiB
store_and_fwd_flag: 1397.63MiB
pickup_cdeligibil: 1214.21MiB
rate_code_id: 1235.83MiB
snowfall: 1788.64MiB
mta_tax: 1669.69MiB
trip_distance: 5528.60MiB
pickup_ntaname: 1409.25MiB
improvement_surcharge: 1401.48MiB
passenger_count: 1397.46MiB
ehail_fee: 1397.46MiB
cab_type: 1397.53MiB
vendor_id: 1397.58MiB
total_amount: 3697.29MiB
trip_type: 62.35MiB
dropoff_puma: 2611.38MiB
pickup_datetime: 5588.67MiB
trip_id: 5589.44MiB
# Table `_meta_tables` (2 rows, 0.00 MiB) #
timestamp: 0.00MiB
name: 0.00MiB
locustdb> SELECT passenger_count, to_year(pickup_datetime), count(0) FROM trips;
Scanned 1464785771 rows in 3431ms (0.43B 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 3429ms (0.43B 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 3425ms (0.43B 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 3430ms (0.43B 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 3426ms (0.43B 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 3432ms (0.43B 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 3423ms (0.43B 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>
Failed to parser query: Alt
locustdb> ;
Failed to parser query: Alt
locustdb> SELECT passenger_count, to_year(pickup_datetime), count(0) FROM trips;
Scanned 1464785771 rows in 3425ms (0.43B 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 3423ms (0.43B 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 3425ms (0.43B 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 3430ms (0.43B 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 5989ms (0.24B 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 5986ms (0.24B 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 5984ms (0.24B 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 5980ms (0.24B 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 5985ms (0.24B 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 5983ms (0.24B 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 5981ms (0.24B 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 5986ms (0.24B 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 5975ms (0.25B 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 5991ms (0.24B 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>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment