Created
July 8, 2018 06:49
-
-
Save cswinter/38c915c1d5c8176ae61682a9b78af7b1 to your computer and use it in GitHub Desktop.
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) 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